Ritesh Agarwal

  • Qlikview Developer
  • New York City, NY
  • Member Since Mar 03, 2023

Candidates About

                       

                       Ritesh Agarwal                                                                                                       

 

PROFESSIONAL SUMMARY

 

Ø  5 Years of IT experience on Qlikview 11 with Requirements gathering, integrating multiple databases located on different location, ETL activities, implementing data mart and data warehouse, data modelling according requirements and situation, represent data into different Qlikview charts, set analysis, coding for complex macros, managing Qlikview Server etc.  

Ø  Certified professional in QlikView, implementing end to end from requirement gathering to go live and after implement support development.

Ø  Good working knowledge on Data warehousing concepts like Data warehouse Architecture, Star schema, Snowflake schema, Data marts and Dimension and Fact tables.

Ø  Worked with Variables, Set Analysis, Aggregate functions, Joins and Mapping Functions.

Ø  Creation of QVDs and using incremental load from different sources.

Ø  Having Implementation to provide security permissions using Section Access.

Ø  I have successfully Installed Qlikview server and configured server to the optimal usage based on the Performance and Event Logs.

Ø  I had created Qlikview Dashboard which give the performance of the task and the Qlikview server

Ø  Having hands on Experience in QlikView Server, Publisher & Admin

Ø  Build a Qlikview Application which can show metadata for all the QVD files created on the server

Ø  Qlikview Application which will show how many task are running, finished or failed in QMC

Ø  Designed and implemented various POC’s – Eg: Big Data, Ticket Dashboard, BA Application status Dashboard,etc.

Ø  Created Excel, PPT, Word file in Qlikview application with the help of nPrinting.

Ø  Self-motivated, task & result oriented professional with good analytical and communication skills.

Ø  Strong knowledge in basic components of QlikView Enterprise like List Boxes, Multi Boxes, Tables, Charts, Current Selection Boxes, Buttons, Drill  down,  ranking,  breaks  and  merged  dimensions Trends, KPI’s, custom requests for Excel Export, And experience in editing scripts for creating variables, fields, and calculated expressions, basic and aggregated functions.

Ø  Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.

Ø  I have good experience with the tools like Tableau and Power BI in development as well as admin area.

Ø  I have been working on Microsoft Azure Cloud to store data in Data Lakes as we have billions of records for each month

 

 

 

 

 

 

COMPANY Worked For

Name of Company

Period

KPIT

March 2017 to Present

TCS

Dec 2012 to Feb 2017

 

 

PROFESSIONAL EDUCATION

Degree Obtained

Name of School/University

Period

BE

Pune University

2008-2012

HSC

Pune University

2006-2008

SSC

Pune University

2005-2006

 

Certificate:

Technology

1. Qlikview

2. Cognos

3. DataStage

 

 

TRAINING ATTENDED:

Training Name

Conducted By

1. Qlikview

Qliktech

2. Qlik Sense

Qliktech

3. Big Data & Handoop

Tata Consultancy Services

4. Cognos

Tata Consultancy Services.

5. Power BI

HP

6. Microsoft Azure

HP

 

 

TECHNICAL SKILLS

Operating System

Windows

Software Languages

Macro in Qlikview

RDBMS

MS SQL  (2005/2008), DB2

Database, DI & BI Tools

Qlikview 11, Cognos 10 , DataStage 8.5, Power BI, SSRS, Microsoft Azure

Design, Version Control and Documentation Tools

 MS-Word, MS-Excel

 

 

 

RECENT proJECTS

 

 

Sales Compensation Dashboard, HP

Mar 2017 –  Till Date

 

Overview

The project is based on data for credit being paid out for the Sales

Resprestative and also the incentive based on their performance.

In this project as we are having billions of data records to process via different partitions, and we are using Microsoft Azure for data lake and data fatory.

Technologies

Qlikview 11 , Power BI , Microsoft Azure

Supported platforms

Windows

Team size

4                                                                                  

Role

 Technical Lead & Application Support Analyst

·         Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

·         Involved in requirement gathering and preparing the Business Requirement Document (BRD).

  • Data Modeling and Report Development
  • Coordinating with offshore team for making the dashboard and understanding them the requirement

·         Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

  • Testing, Validations, Timely delivery of Reports and Support for existing QV implementation and trained business users.

 

 

 

Proactive Sensing and SQDF, Chrysler

Dec 2016 – Feb 2017

 

Overview

The project is based on advanced analysis , we are having data from the

 Sensors of the car and then pulled into Big Data environment on which Qlikview Reporting is done.

Technologies

Qlikview 11

Supported platforms

Windows

Team size

4                                                                                  

Role

Support Team Lead & Application Support Analyst

·         Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

·         Involved in requirement gathering and preparing the Business Requirement Document (BRD).

  • Data Modeling and Report Development
  • Coordinating with offshore team for making the dashboard and understanding them the requirement

·         Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

  • Testing, Validations, Timely delivery of Reports and Support for existing QV implementation and trained business users.

 

 

Qlikview Server Migration, Chrysler

Sept 2016 – Nov 2016

 

Overview

The project is to migrate all the QVS, QDS , QVWS, DSC from one clustered environment to other. This migration was in need due to server configuration

 changes according to company needs.

All migration activities from preparation of new clustered environment, migration of all application, configuration, tasks etc. was part of this project.

Technologies

Qlikview 11

Supported platforms

Windows

Team size

4                                                                                  

Role

Support Team Lead & Application Support Analyst

·         Along with this I am handling the Support team which includes 4 members at onsite and 5 at offshore.

·         Enhancement/Change Estimation, Requirement gathering and technical consultancy to users and code reviewing and participation in Issue resolution are main responsibilities.

 

 

Chrysler Capacity & Options Planning (COPS), Chrysler

May 2016 – Sept  2016

 

Overview

It is a detailed analysis reporting system for the day to day based forecasting and options planning.

What if analysis, Pareto Analysis, Adhoc Reporting, Details reporting are the base KPIs for it

Technologies

Qlikview 11

Supported platforms

Windows

Team size

4                                                                                  

Role

QV Developer & Application Support Analyst

·         Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

·         Involved in requirement gathering and preparing the Business Requirement Document (BRD).

  • Data Modeling and Report Development
  • Coordinating with offshore team for making the dashboard and understanding them the requirement

·         Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

  • Testing, Validations, Timely delivery of Reports and Support for existing QV implementation and trained business users..

 

 

 

 

GTCR , Chrysler

Dec 2015 – May 2016

 

Overview

Fiat and Chrysler have different systems and processes at regional / sector level. Since TCR process differences are relatively minor, Powertrain requested extensive enhancements and the necessity to upgrade FIAT Vehicle system, the opportunity for communization has been analyzed and identified. The project goal is to provide Group Purchasing, Powertrain and Vehicle Engineering with a new common Technical Cost Reduction solution.

Technologies

Qlikview 11

Supported platforms

Windows

Team size

3                                                                                  

Role

QV Developer & Application Support Analyst

·         Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

·         Involved in requirement gathering and preparing the Business Requirement Document (BRD).

  • Data Modeling and Report Development
  • Coordinating with offshore team for making the dashboard and understanding them the requirement

·         Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

  • Testing, Validations, Timely delivery of Reports and Support for existing QV implementation and trained business users.

 

 

 

 

 

Chrysler Capital, Chrysler

Apr 2015 – Dec 2015

 

Overview

Chrysler Capital, a private label with Santander Consumer USA (SCUSA), provides dealers with the tools to be successful while assisting customers in purchasing Chrysler vehicles. SCUSA is a financial services company based in Dallas that Chrysler Group has partnered with. Chrysler Capital is a branded finance partner available to Chrysler dealers. The suite of solutions include full-spectrum automotive financing, floor plan and leasing, fleet, commercial, and real estate lending solutions. Chrysler Capital operates in additional areas such as dealer loans for real estate, capital investments, and revolving lines of credit.

Technologies

Qlikview 11

Supported platforms

Windows

Team size

3                                                                                  

Role

QV Developer & Application Support Analyst

·         Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

·         Involved in requirement gathering and created BRD.

  • Data Modeling and Report Development

·         Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

  • Testing, Validations, Timely delivery of Reports and Support for existing QV implementation and trained business users.
  • Unit and Integration testing of Qlikview task/Application as per the test cases provided by client.

 

 

Fleet Net Margin, Chrysler.

Dec 2014 – Apr 2015

 

 

Overview

Fleet Net Margin Application is a Qlikview application providing insight into Chrysler’s Fleet Program. This Application contains information about the vehicles sold to different Customers in various Markets under the various Programs like LTDR, GDP etc. Also it gives comprehensive information about the Net Margin based on the base cost, Gross margin and Incentives.

 

Technologies

Qlikview 11

Supported platforms

Windows

Team size

4                                                                                  

Role

QV Developer & Application Support Analyst

·         Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

·         Involved in requirement gathering and preparing the Business Requirement Document (BRD).

  • Data Modelling and Report Development

·         Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

·         Created Reported with the help of nPrinting.

  • Testing, Validations, Timely delivery of Reports and Support for existing QV implementation and trained business users.
  • Unit and Integration testing of Qlikview task/Application as per the test cases provided by client.

 

 

 

 

 

 

Active Order Management, Chrysler

Feb 2014 – Dec 2014

 

Overview

Active Order Management (AOM) allows users to easily manage and organize orders (sold orders, stock orders and pilot orders). It enables manufacturers and logistics providers to quickly adapt to changing market demands and satisfy customer needs, transforming order strategies from a cost increasing production methodology to an approach with considerable cost reductions and shorter lead times over traditional production methods

 

Technologies

Qlikview 11

Supported platforms

Windows

Team size

3                                                                                  

Role

QV Developer & Application Support Analyst

·         Interacting with end users to gather the functional requirements and customize Qlikview dashboards accordingly and involved in developing, enhancing, re-engineering, maintaining, supporting Qlikview applications.

·         Involved in requirement gathering and preparing the Business Requirement Document (BRD).

  • Data Modeling and Report Development

·         Involved in creating dashboard style of layouts using different sheet objects like List boxes, Multi boxes, slider, current selections box, buttons, charts, text objects, bookmarks, etc.

  • Testing, Validations, Timely delivery of Reports and Support for existing QV implementation and trained business users.
  • Unit and Integration testing of Qlikview task/Application as per the test cases provided by client.

 

 

Customer Care, Chrysler

Mar 2013 – Feb 2014

 

Overview

This project aim is to establish a Dashboard for Chrysler Call center (CAC & STAR) which represents various KPIs for business and provides platform to analyze the underlying data.

Chrysler provides support to consumers, dealers, business center and third parties through its Call Center which are present in US, Canada and other International locations. Chrysler provides support through its own Call Centers and other outsourced locations managed by Convergys, Minacs, etc.

 

Technologies

Qlikview 11

Supported platforms

Windows

Team size

  • Experience:
    7 Years
  • Birthday:
    12/31/1969

Contact Us

This website requires cookies to provide all of its features. By using our website, you agree to our use of cookies. More info