PRATEEK CHANDRA

Gurgaon, Haryana 
prateek29chandra@gmail.com
9657426473
I am working as a Consultant with KPMG Global Services and part of Data Analytics - Data Platforms Team. I have 
overall 7 Years of work experience working on multiple ETL and Analytical tools. I have previously worked with 
Deloitte, Mphasis and Nvidia.

Consultant
KPMG Global Services 
December 2020 to Present
Working as a Alteryx SME on different Projects.
Developed an ETL Process model along with validations for Different processes, thereby, removing manual 
intervention.
Designed Framework and migrated data from TM1 Cognos to SQL Using TM1py Library, used Alteryx/ SSIS for 
ETL operations and importing data to SQL Server.
Skilled in performing data parsing, data manipulation and data preparation using Alteryx/SSIS
Built an internal visualization platform for the clients to view and compare data across different time period. 
Created Reusable Components/Macros in Alteryx for Fuzzy Logic, reading & creating password protected Files in 
Alteryx.
Working on automating existing daily/weekly activities using Alteryx workflows which resulted in saving of hours. 
Directing, managing and overseeing daily operations within my Team, ensuring that they meet deadlines and work 
efficiently.
Building analytical solutions and workflows using tools like Alteryx. Monitoring the adherence of the project 
deliveries to the specified timelines.
Coordinating with onshore team to meet business requirement. Developed and translated the business 
requirements into effective and insightful data pipeline.
Created Python scripts for getting data from multiple sources into Data frames and pushing data into SQL server.
Senior Executive
Deloitte - Mumbai, Maharashtra 
April 2019 to November 2020
Name of assignment or project:
Client: JP Morgan Chase 
Responsibilities :
Taking requirement from users, analyzing data and identifying key Automation Areas. Involved in maintaining 
BRD Repositories.

Automated several task/jobs thereby reducing manual intervention and bringing efficiencies
Built analytical solutions and workflows using tools like Alteryx. Monitoring the adherence of the project deliveries to 
the specified timelines.
Created Analytical apps in Alteryx to make Workflows more Dynamic and User friendly. 
Proposed Model to calculate Employee efficiency on the basis of the client process.
Created data pipelines from data from different sources to provide insights at scale. 
Worked with large, complex data sets.
Worked autonomously with limited direction from client or project team to solve a problem. 
Created reusable components/macros to reduce scripting process time.
Proposed solution for Money Trail within multiple accounts of different banks.
Proposed solution for calculating debit credit utilization which helped in providing valuable insights. Used Python 
on handling Excel/Flat file data and loading into SQL server.
Software Engineer (Developer) 
Mphasis - Mumbai, Maharashtra 
June 2015 to March 2019
Main project features:
Worked on SQL Server, software development, implementation and support using Microsoft technologies involving 
multiple projects in the Insurance domain.
Was part of the data migration team while working on different Web based application. 
Experienced in writing SQL queries, procedures and functions.
Worked on Web applications for Insurance Domain using C#, ASP.NET MVC Architecture. 
Experience on testing Web services using SOAP.
Worked with the application developers and provide necessary SQL Scripts using T-SQL. 
Developed complex stored procedures to create various reports.
Actively designed the database to fasten certain daily jobs and some stored procedure.
Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server. 
Worked on SSIS Package, DTS Import/Export for transferring data from Database (Excel and Text format data) to 
SQL Server.
Worked with other groups in the organization to identify permanent fixes to recurring problems , including application 
code-related issues and improve documentation that help support the fast-paced and intense trading environment.
Quality Assurance Intern
Nvidia Corporation
January 2014 to June 2014
Investigated , analyzed and logged defects and record production issues Experience working with multiple complex 
systems interacting with one another . Worked on different Linux based Operating System . Executed scripts and 
perform sanity testing. Tested different Hardware/Software stack for different vendors. Executed UNIX commands for 
OEM Driver testing and debugging production issues

Masters of Computer Applications