Feb 2021 – Mar 2022 · 1 yr 1 mo · Bangalore Urban, Karnataka, India · On-site

Jul 2018 – Feb 2021 · 2 yrs 7 mos

• Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
• Design, implement and maintain Power BI dashboards to support system-wide strategic initiatives; work with BI team to develop and implement Meta-data layer in Data Platform to support future Self-Service BI model and assist Power BI users
• Trained employees on Power Automate,Power BI for improved data management, monitoring effectiveness and suggesting improvements.
• Created various Excel documents to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
• Create and maintain reporting infrastructure to facilitate visual representation of manufacturing data for purposes of operations planning and execution. Examples include backlog analysis, capacity planning, production machinery status, pacing, quality,work in process (WIP) and other real-time production reports.
• Development of ETL processes, tabular or multidimensional models. Support to product,vendor management, customer service and sales departments with ad hoc analyses.
• Functional testing (data validation, paging/filtering, triggers/events, navigation)
• To a certain degree, may assist indirectly in the technical build-out and/or support of databases,query tools, reporting tools, BI tools, dashboards, etc. that enable analysis, modeling, and/or data visualization.
• Collaborated with engineering team on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Performed large-scale data conversions, transferring api JSON data into standardized tabular formats for integration into databases.
• Created a global operations dashboard which has been adopted globally not only within the BU but across other BU's
• Implemented multiple automation initiatives to improve efficiency of operations.

Oct 2016 – Jun 2018 · 1 yr 8 mos

• End-to-end ownership of key metrics, work with respective product owners to understand areas we need to measure and ensure the needle is moving in the right direction.
• Strong knowledge of and experience with statistics; potentially other advanced math as well and good working knowledge of SQL ability.
• Good knowledge in analyzing, gathering, managing and documenting operational data
• Handling multiple reports, working with formulae, pivot tables & pivot charts and various other excel sheet components for accurate data reporting.
• Responsible for enabling data platforms with scalable solutions for key internal and external customer experiences.

Aug 2015 – Oct 2016 · 1 yr 2 mos

• Retrieve, analyze and report necessary data from source systems using SQL or Python.
• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
• Handle multiple projects at once, deal with ambiguity and rapidly-changing priorities.
• Advanced ability to draw insights from analysis, frame recommendations supported by data, and clearly communicate them to stakeholders and senior management.
• Pioneer new ideas to increase speed and reduce delivery cost to customers
• Produce trends and charts for performance monitoring & control on daily, weekly, monthly basis

Jul 2014 – Aug 2015 · 1 yr 1 mo

• Daily Monitor all required KPIs effectively to ensure they meet their targets
• Own the MIS delivery for the account with respect to all aspects of WFM Planning, Scheduling, Forecasting, Real Time Management, Reporting
• Ability to work on data and generate various types dashboards, reports/ad-hoc reports
• Understand business requirement & converting it into technical functional specification for Excel Macros using VBA & Excel Formula.

Oct 2013 – Jul 2014 · 9 mos · Gurugram, Haryana, India

• Created and implemented database designs and data models.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Wrote and optimized in-application SQL statements.
• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL.

Jun 2013 – Oct 2013 · 4 mos

• Generated queries utilizing SQL to create required reports.
• Prepared monthly ad hoc reporting in alignment with client needs.
• Updated and maintained mortgage contract database utilizing Microsoft Access.
• Used MS ACCESS,SQL to generate required reports and optimize query creation