2021-2022

Lead Solution Advisor at Deloitte Risk and Financial Advisory

• Managed extensive fraud investigations, forensic analysis, and regulatory compliance projects for leading global clients. • Collaborated closely with clients to address complex data-related issues, utilizing SQL and Python/R for effective problem-solving and risk reduction. • Handled a team for a high-profile client to oversee indirect tax (VAT/GST) and TIN validation processes, guaranteeing compliance reporting for VAT/GST/DST and resolving missing invoice issues.

2019-2021

Data Analyst at Tata Power Delhi Distribution Limited

• Imported 50 RDBMS tables and 20 external files into Cloudera Hadoop using Sqoop, resulting in a more efficient data storage and processing system. • Developed and executed a comprehensive data integration strategy, ingesting XML files generated by smart meters into Hadoop using Apache Sqoop. • Generated detailed monthly and daily reports on meter operations, analyzing data from over 10,000 smart meters. Provided actionable insights to the operations team, resulting in a 15% increase in overall meter performance. • Increased the revenue by 900K and saved expenditure by 10 % by deploying the payment defaulter prediction model. • Developed sentiment analysis model by analyzing customer reviews on social media about the services provided by the company using NLP.

2018-2019

Big Data Engineer at NCR Corp

• Designed and created 3 repositories with dimension and fact tables in Hive, improving data organization and accessibility for reporting purposes. • Implemented Change Data Capture (CDC) methodology to track and update real-time changes in the source database, reducing data latency by 75%.

2014-2017

System engineer at Tata Consultancy Services

Contributed to Teradata to Big Data migration project with Sqoop, ETL, and Hive.