May 2021 - Present
UST Global

Data Analyst

Exploring and pre-processing of different datasets using Apache PySpark and Python Pandas.

Descriptive statistical analysis was performed on processed tables.

Build configurable python script for curation of raw data.

Post processing analysis and visualization done using matplotlib and seaborn.

Nov 2018 - May 2021
Accenture

PySpark Developer

Hands-on experience in migration of Oracle SQL to PySpark application on AWS by data transformation and aggregations using Apache Spark DataFrame API.

Experience with various services of AWS such as Glue, Athena, S3, EMR, RDS .

Involved in creation of Reverse Engineering documents to analyze existing Oracle SQL system and development of Work Product Document used by Visualization team.

Designed and developed Data Comparison tool using Python which is used to compare and validate data as part of unit testing in development.

Developed python script to automate orchestration of Qlik Sense and Nprinting tasks.

March 2017 - Nov 2018
Accenture

Automation and Support Engineer

Automated Release Deployment plan for the project using VBA which has reduced creation and reviewing of deployment plan from 20hrs to 2hrs .

Automated various client related excel reports using Python scripting with libraries such as openpyxl , win32com which saves 5+ hrs/week .

Responsible for problem tickets creation using ServiceNow REST API and python .

Implemented VBA to automate daily reports notification email.

Developed web scraping script for client using VBA to get the latest version of all open source software used in project from MVN repository website which saved 100+ hrs for client.

Experience in User management , Change management in ServiceNow tool.

March 2016 - May 2016
BOSCH

Intern

Developed Software for Data Acquisition and Report Generation for Conventional Fuel Injection Pumps on KMM Computer using Labview.