Paritosh Kumar
Data Engineering Associate Manager
Hyderabad
Summary
Experienced Information Technology professional with 14 years of experience currently serving as an Associate Manager at Accenture Solutions Pvt Ltd in Hyderabad. Overseeing a team of consultants responsible for development work for clients, my role also includes requirement gathering, mappings, and client engagement to ensure business objectives are met.
Overview
16
16
years of professional experience
8
8
years of post-secondary education
2
2
Certifications
Work History
Data Engineering Associate Manager
Accenture Solutions Pvt Ltd
07.2023 - Current
- Company Overview: Accenture Solutions Pvt Ltd is a global professional services company with leading capabilities in digital, cloud, and security. It offers a wide range of services and solutions in strategy and consulting, digital transformations, technology implementations, and operations.
- Analyzing existing on-prem environment and optimizing inventory for SAS 9.4 to SAS Viya migration.
- Conducting user training sessions and workshops to gather required inputs from different teams.
- Assessing existing environments and ensuring seamless infrastructure setup.
- Drive data, SAS DI jobs and EG projects migration.
- Integrating SAS Viya with other systems and conducting comprehensive testing.
- Facilitate user training, develop documentation, and provide post-migration support.
- Optimize performance and champion continuous improvement by staying abreast of SAS Viya updates.
- Accenture Solutions Pvt Ltd is a global professional services company with leading capabilities in digital, cloud, and security. It offers a wide range of services and solutions in strategy and consulting, digital transformations, technology implementations, and operations.
- Project Title: Nationwide Building Society (UK)
- Environment: SAS Viya 4.0, SAS Data Integration Studio, SAS Enterprise Guide, SAS Studio, SAS Visual Analytics, SAS Environment Manager, Apache Airflow, SQL, Python, Power BI
Data Engineering Associate Manager
Accenture Solutions Pvt Ltd
07.2021 - 06.2023
- Implementation of business logics for validation of vehicle purchase transactions, buyer enrollment, vehicle return processes, etc. using sas codes.
- Development of lambda function using python.
- Project Title: Cox Automotive (Atlanta, US)
- Environment: SAS Enterprise Guide, SAS Management Console, AWS, Python, PostgreSQL, SQL
Data Engineering Consultant
Accenture Solutions Pvt Ltd
04.2021 - 06.2021
- Data pipeline creation in SAS data integration studio for forecasting projects.
- Project Title: Academy Sports (US)
- Environment: SAS Enterprise Guide, SAS Management Console, SAS Data Integration Studio
Data Engineering Consultant
Accenture Solutions Pvt Ltd
09.2020 - 06.2021
- The end-to-end data pipeline is being developed in SAS DI to facilitate data preparation for forecasting projects undertaken by the data science team.
- Project Title: Belk(Charlotte, US) & Academy Sports (US)
- Environment: Data Integration Studio, SAS Enterprise Guide, SAS Management Console, GCP
Data Engineering Consultant
Accenture Solutions Pvt Ltd
11.2019 - 09.2020
- Configuration of SAS Customer Intelligence environment for different LOBs like voice, data, vas, etc.
- Preparation and creation of source information map for multistage daily, weekly and monthly campaigns.
- Multilanguage configurations based on subscribers.
- On-Demand Target and Control group creation.
- Datamart creation as per business requirement using SQL and SAS.
- Project Title: Azerconnect(Baku, Azerbaijan)
- Environment: SAS Customer Intelligence Studio, SAS Data Integration Studio, SAS Information Map Studio, SAS Management Console, Oracle DB, SQL
Consultant-Technical
Wipro Limited
10.2018 - 11.2019
- Development of Datamart for modules of different lines of business using SAS Data Integration Studio (extensive use of loop, lookup and SCD transformations).
- Customized server level properties for SAS CI configuration.
- Using datamarts created source information map for CI environment having all KPIs given by the client.
- Configured all objects like business context, campaign definitions, communication definitions, and export definitions (output SMS file sent to another team for communication).
- Development of some reports on SAS WRS using imaps and stored processes.
- Project Title: Oriental Bank of Commerce(Gurgaon)
- Environment: SAS Customer Intelligence Studio, SAS Data Integration Studio, SAS Web Report Studio, SAS Information Map Studio, SAS Management Console, Oracle DB, DB2 DB
SAS Consultant
Infodrive Analytics Pvt. Ltd.
05.2018 - 10.2018
- ETL jobs are created for DataMart of new LOB.
- Created source Imap for in SAS Customer Intelligence Studio for new LOB.
- Development of campaign management environment for new LOB with server-level configuration.
- Developed business contexts, campaign definitions, communication definitions, export definitions.
- Created customized diagram tools as per business requirement.
- Migrated all objects(users, groups, libraries, tables, jobs, OLAB cubes, Imaps, WRS reports, campaigns, diagrams, etc.) from SAS9.3 to 9.4 for existing LOB.
- Created information maps and stored processes for SAS WRS report.
- Project Title: Dish TV India Ltd., India(Noida)
- Environment: SAS Customer Intelligence studio 6.5, SAS Data Integration Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Management Console, SAS Stored Process
SAS Consultant
Infodrive Analytics Pvt. Ltd.
09.2014 - 05.2018
- Understanding the business requirements and creating the LLD and HLD documents.
- Developed a detailed design document for the ETL process to create the Data Mart for Data, Vas, and Voice for SAS Campaign Management.
- Configuration of environment for SAS Customer Intelligence Studio.
- Project Title: Idea Cellular India Pvt Ltd., India(Pune)
- Environment: SAS Customer Intelligence Studio, SAS Data Integration Studio, SAS Enterprise Guide, SAS Information Map Studio, SAS Web Report Studio, SAS Management Console, SAS Stored Process
Associate Consultant
Lericon Informatics Pvt. Ltd.
01.2014 - 08.2014
- Requirement gathering.
- Client interaction.
- Automated existing programs writing complex MACROS for improving efficiency.
- Used procedures like PROC IMPORT for getting data into SAS from differently formatted files like Excel, CSV file, .txt files etc.
- Through knowledge in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
- Report creation using PROC REPORT and PROC TABULATE.
- Analysis of data regression analysis and time series forecasting.
- Project Title: HPSEB(Himachal Pradesh State Electricity Board)
- Environment: SAS 9.3, SAS EG, SAS/SQL, SAS/MACROS, ORACLE DB, SAS Data Integration Studio, and MS Office.
Associate Consultant
Lericon Informatics Pvt. Ltd.
08.2013 - 12.2013
- Reading raw data from various locations and creating SAS datasets.
- Importing data and descriptive files from excel using proc import.
- Accessing required data from Oracle database using SQL pass-through and libname statements.
- Manipulating the data sets as per the requirement and given description.
- Data Cleaning and Data Validation by using various procedures.
- Design and build datasets according to project specifications by using SAS/BASE and SAS/SQL.
- Creating Reports using Base SAS Reporting Procedures and Excel.
- Used various procedures like proc SQL, proc summary, proc report, proc freq, proc means, proc contents, proc dataset, proc append, proc import, proc export, proc print, proc sort.
- Designed job flows using SAS/DI to extract data from source systems, perform required transformations and load back to target.
- Working extensively in sorting, merging, concatenating, and modifying SAS Datasets.
- Extracted data from the database using SAS SQL procedures and created SAS data sets.
- Project Title: Chhatisgrah Government, Ministry of Finance
- Environment: SAS 9.3, SAS EG, SAS/SQL, SAS/MACROS, ORACLE DB, SAS DI, and MS Office.
Engineer Water Treatment
JalKalVibhag(Kanpur Jal Sansthan)
07.2009 - 08.2011
- Responsible for maintenance and operations of rapid gravity filters.
- Responsible for operation of clariflocculators, setting tanks, and allied gravity feed chlorinators.
- Involved in allied laboratory works for quality control.
- Creation of different reports and presentations using MS-Office.
- Project Title: Water Treatment and Distribution
Education
M.Tech -
National Institute of Technology
Jamshedpur 01.2011 - 01.2013
B.Tech -
University Institute of Engineering And Technology, Kanpur
01.2005 - 01.2009
Intermediate -
UP Board
01.2003 - 01.2004
High School -
UP Board
01.2001 - 01.2002
Skills
SAS Data Integration Studio
SAS BI tools
SAS Customer Intelligence
SAS migration to cloud environment
SAS Viya
Apache Airflow
Python
Power BI
Unix
DB2, Oracle, PostgreSQL, Teradata databases
Certification
SAS Certified Base Programmer
Timeline
Data Engineering Associate Manager
Accenture Solutions Pvt Ltd
07.2023 - Current
Data Engineering Associate Manager
Accenture Solutions Pvt Ltd
07.2021 - 06.2023
Data Engineering Consultant
Accenture Solutions Pvt Ltd
04.2021 - 06.2021
Data Engineering Consultant
Accenture Solutions Pvt Ltd
09.2020 - 06.2021
Data Engineering Consultant
Accenture Solutions Pvt Ltd
11.2019 - 09.2020
Consultant-Technical
Wipro Limited
10.2018 - 11.2019
SAS Consultant
Infodrive Analytics Pvt. Ltd.
05.2018 - 10.2018
SAS Consultant
Infodrive Analytics Pvt. Ltd.
09.2014 - 05.2018
Associate Consultant
Lericon Informatics Pvt. Ltd.
01.2014 - 08.2014
Associate Consultant
Lericon Informatics Pvt. Ltd.
08.2013 - 12.2013
M.Tech -
National Institute of Technology
01.2011 - 01.2013
Engineer Water Treatment
JalKalVibhag(Kanpur Jal Sansthan)
07.2009 - 08.2011
B.Tech -
University Institute of Engineering And Technology, Kanpur
01.2005 - 01.2009
Intermediate -
UP Board
01.2003 - 01.2004
High School -
UP Board
01.2001 - 01.2002