Badges
Certifications
Work Experience
Data Engineer
invesco• October 2018 - Present
● Defining, recommending, and delivering Business Intelligence Strategies and roadmap to improve the Technology Strategy. ● Extract structured, semi-structured data through Python scripts for data transformation. ● Developing the Data warehouse with SQL Server, this acts as a single point of source for all the Power BI reports. ● Worked and lead end to end migration project from SSIS 2008 R2 to SSIS 2016 from scratch. ● Designing and Developing the Dashboard Reports in Power BI using DAX. ● Worked on In-house POC for predicting Vulnerability Trend using Apache Spark.
Data Analyst
Deloitte• June 2017 - October 2018
● Improved ETL and SQL Stored Procedures in some projects that helped to reduce around 25% of the month-end processing time. ● Designed and worked on SSIS packages to pull data from multiple sources (Excel, Flat File, etc.). ● Modernized existing financial reporting solutions using Tableau visualizations and dashboards.
Associate Consultant
capgemini• June 2014 - June 2017
● Successfully, Implemented ETL Packages to load Data in Data warehouse and optimized OLTP database and design reports on SSRS. ● Involved in the development/deployment of ETL packages in MSSQL 2012 to load Data. ● Through automation, improved efficiency 15%, freeing up 20 labor hrs/mo.
Education
Nagpur University
Information Technology, BE• June 2010 - June 2014