Nov 2022 – Jul 2025 · 2 yrs 8 mos · Atlanta, Georgia, United States · Hybrid

• Energy Data Application
• Spearheaded the creation and implementation of a novel energy consumption data model and Key Performance Indicators (KPIs) in response to the 2022 energy crisis. This initiative targeted major European plants and enabled EMRA leaders to meticulously monitor natural gas and electricity consumption, facilitating optimized usage.
• Resulted in a remarkable 20% month-over-month reduction in energy consumption, achieved through informed decision-making driven by real-time insights.
• Preventive Maintenance Data Application
• Orchestrated collaborative efforts with the Global EMRA team to streamline and automate preventive maintenance processes across diverse plant operations.
• Integration of data from three distinct SAP source systems across 15+ plants into a centralized Datalake framework.
• Automation of essential KPIs, such as PM completion and compliance, yielded substantial efficiencies, resulting in a significant reduction of manual effort—equivalent to 10+ hours bi-weekly across the network.
• Noteworthy qualitative benefits include enhanced data integrity through robust quality rules, minimal human intervention, and near real-time metric availability, transcending mere quantitative gains.
• Downtime Data Model
• Successfully onboarded 11 plants onto the downtime data application platform, with ongoing efforts to expand coverage to additional facilities.
• Collaborated closely with the Global EMRA team and plant process engineers to standardize over 1000 source downtime types, aligning with global OEE downtime classification standards.
• Establishment of standardized practices serves as a foundation for developing a comprehensive global benchmark, facilitating cohesive organizational efforts to address machine downtime challenges.
• The initiative underscores a commitment to operational excellence and continuous improvement, fostering a culture of data-driven decision-making and performance optimization at a global scale.

Jan 2022 – Nov 2022 · 10 mos · Atlanta, Georgia, United States

• Data Engineer - Novelis
• Developed applications using Pyspark and Spark-SQL for data extraction, transformation and aggregation for analyzing &
• transforming the data to uncover insights into the plant machine reliability patterns.
• Created error handling, exception management and data quality routines to expose the anomalies in the data, reducing production issues by 34%.
• ETL data from Sources Systems (SAP, Maximo, Oracle) to Azure Data Lake and processed the data in Azure Databricks.
• Designed and jointly developed the data architecture with the data architect and ensures security and maintenance.
• Explores suitable options, designs, and creates data pipelines (data lake/data warehouses) for specific analytical solutions.

Aug 2021 – Jan 2022 · 5 mos · Atlanta, Georgia, United States

• Working under Prof. Jaspal Sagoo (CTO CDC) on emerging technologies with a focus in Cloud computing and also High-performance Quantum Computing, Internet of Things (IoT), Augmented and Virtual Reality.
• Responsible to conduct research and present a technology’s incremental advancement, scope, radical innovative application based on existing capabilities (Lab tested, bleeding-edge advances)

Aug 2020 – Jul 2021 · 11 mos · India

• R&D Supply Chain Intelligence (SCI)
• Conducted extensive research to enable & apply Multilingual Model Support and durable model for Framework Manager Project. The model was employed in 10+ SCI framework packages.
• Optimized six dashboards from the SCI base package where underlying Data modules were consistently failing refresh due to high contention. Manually re-designed the SQL queries following best practices
• Developed a Fraud Report that listed fraud orders and curbside pickups along with a month over month trend. This report was included in SCI's base package and used for an application demo with Forrester Research.
• BI-DWH Design, Design Data Mart, Build & Architect Meta-Data Model using Cognos Framework Manager.

Jan 2019 – Aug 2020 · 1 yr 7 mos

• Employed Statistical methods (time series, survival analysis, logistic regression, and data mining.) to develop
• employee-turnover forecasting models. The recommendation and insights were able to successfully lower attrition from
• 20.2% in the Q1 of 2019 to 11.2% in Q1 2020.
• Spearheaded requirement gathering process and client (user) interaction to extract and document requirements in the form of a Business Requirement Document (BRD). Creating over 78 technical and business requirement documents.
• Led a project to automate 100+ manual excel reports to Cognos while also streamlining the process and helping clients cut down 650+ hours/month of billable efforts.
• Was responsible for mentoring junior teammates through development, requirement gathering, reporting, and analytical front, enabling a team of 4 freshers to get up to speed.
• Led a team of four to develop POCs for the application of Tableau and Power BI in the client's organization and presented it to the C-level executives.

Nov 2017 – Aug 2020 · 2 yrs 9 mos

• Worked for an American banking client in the Consumer Private Wealth Management LOB as an offshore BI developer.
• Roles and Responsibilities:
• Spearheaded the requirement gathering and understanding, design, development and implementation stages of the system development life-cycle including analysis, design, coding, troubleshooting, documentation, testing, and implementation.
• Worked with Quality Analysts to help them understand the system to meet all the required test cases to be verified before the code is migrated to subsequent environments QA, UAT, and PROD. Delivered over 45 error-free BI reporting applications.
• Was responsible for troubleshooting and providing technical solutions for business issues and projects at priority. Solved around 13 tickets per week.
• Automated 100+ manual excel reports to Cognos reports, while also retiring the existing data source and mapping to a new and optimal source. The project helped save the client tons of manual effort and capital.

Nov 2015 – Aug 2020 · 4 yrs 9 mos

• Completed the foundation in Data and Analysis training in 6 months.
• Specialised in IBM Cognos for Reporting and Analysis and Informatica for ETL (Extract Transform Load).
• Developed data extraction and transformation pipelines and developed over 20 Cognos reports.
• Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports, and parameterized reports to provide visible data for data analysts and businesses utilizing Cognos and Tableau.