Jun 2022 – Jul 2024 · 2 yrs 1 mo · Gurugram, Haryana, India · Remote

• Working with one of the largest insurance companies in the Vendor Excellence team of the claims department spanning 50+ vendors, maintaining 20+ scorecards and saving approximately 10% of the manual efforts of the company.
• Got the opportunity to work end to end, i.e., from working on SAS code, creating logics to creating the visuals for the scorecard, and got positive feedback for delivering the scorecard before time.
• The three main pillars of the scorecard-Pricing, Timeliness, Quality.
• Maintaining all the Production refresh processes with on time refreshes
• as well as tracking with vendors on a monthly basis. Checking results, doing primary/ secondary QC of the scorecards, maintaining quality data.
• Doing the EDA of the complete process, end to end updating the data pipeline, Configuration file update,
• Ingestion of monthly files, quality check and validation.
• Handling quarterly report of Savings Tracker and did enhancements within simulated timelines. Got appreciated for on time deliveries. CoreLogic Integration for Ladder assist scorecard, gathered
• requirements from the Stakeholder to understand the new metrics, updated the CoreLogic pipeline and created Timeliness metrics, pushed the changes to production presenting SLA for each metric.

May 2021 – Jun 2022 · 1 yr 1 mo · Gurugram, Haryana, India

• Worked with Publicis Sapient as client.
• Built out the data and reporting infrastructure from the ground up using Power BI and SQL to provide real-time insights into the product, marketing funnels, and business KPIs.
• Work with clients to understand business requirements and translate those need into actionable reports in Power BI and tableau saving hours of manual each week

Mar 2020 – May 2021 · 1 yr 2 mos · Faridabad, Haryana, India

• Managed and work under the owner of company. I created a well data-oriented sheets for capturing the total sales and purchase for previous years.
• Along with customer wise profitability analysis to help clearly understand the overall sales pattern throughout the year.
• Digital temperature controllers and indicators understanding.

Aug 2018 – Nov 2018 · 3 mos · New Delhi Area, India

• Management and Operating team of FSS (Forecasting and Scheduling services) project in various parts of India and data analyst of various power generation projects.
• Data visualisation using Tableau software for better forecasting system of energy usage and determining the efficiency of the plant.
• Project Management of the forecasting and scheduling services in various states of India.

Jul 2016 – Jan 2017 · 6 mos · Bangalore

• Developed the automated solar tracker robot with improved efficiency.
• Worked on Robot Operating system (ROS).
• Worked on PIC Microcontroller

Jun 2015 – Jul 2015 · 1 mo