Apr 2022 – Jun 2022 · 2 mos · Mumbai, Maharashtra, India

• Analysis circled around the customer churn in the Private Cars segment for the factors of the renewability of policies in a 6-year window period.
• Primary data research was conducted with various business teams to understand the pattern and uniqueness of Engine – ChassisNumber logic. Look – a – Like – Model was created using predictive analysis in python, SQL and R.
• The model created in an AWS environment was customized to the need basis and could identify the intents in the insurance metrics with an accuracy of ~75% on the raw data. The model was trained on two different clusters taking into account nine dimensions among the top preferred categories for pattern recognition.

Aug 2021 – Mar 2023 · 1 yr 7 mos · Amritsar, Punjab, India

• Enhancing Corporate Liaison with industries, reevaluating and upgrading the brand perception of IIM Amritsar among the corporates to get better student career opportunities.
• Managing corporate relations and engagement while facilitating the placements process.

Jul 2020 – Jun 2021 · 11 mos · Bangalore Urban, Karnataka, India

• Client : Microsoft
• => At Cognizant Analytics, I worked towards providing solutions to Client's problems based on Data Analysis and Business Understanding in the Digital domain.
• => As a part of Bing Ads Analytics team for the Online Advertising division of Microsoft, I worked on Big Data solutions for Monitoring, Estimating, and Reporting live metrics for the global marketplace for Yahoo! and Bing Advertising Paid Search ecosystem.
• => Carried out hands­on analysis on the Cosmos (Big Data analysis platform) using SQL like syntaxes for several analysis/investigation/live site events.
• => Used Microsoft enabled internal Tools (Live Metrics tool) for carrying out several daily reporting, monitoring of KPI's and investigations.
• => Used Microsoft enabled internal tools for Supply side and Demand side angles for investigation/analysis purposes, these tools have advanced reporting capabilities for further drill down.
• => Technology : SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS),Power BI, Agora.

Jan 2019 – Jun 2020 · 1 yr 5 mos · Bangalore Urban, Karnataka, India

• Client : Microsoft
• Microsoft Cloud Infrastructure and Operations (MCIO) is the engine that powers Microsoft's cloud services. MCIO system helps in managing the demand planning and capacity utilization of Microsoft unified infrastructure (Data Centers). The system is completely built on cloud using Azure technologies encompassing data of huge volumes into a single system. The main intention of building such a system was to make it simpler for the users to consume data from single point to generate insights for driving the business. The system is completely automated with data quality checks in place for identifying any anomaly.
• => Involved in requirement and gap analysis which was critical phase of building such a huge and complex system.
• => Helped in the development of the application phase by phase, progressing from consuming the data from upstream and performing ETL to convert data into fact-­dimensional modeling on Azure Data warehouse followed by building MDM cubes for business users.
• => Provided support after deployment and communicated to the end users effectively to improve the usage of the application.
• => Technology : Azure Data Factory, Azure Data Lake, SQL Server, SSIS, Power BI.

Jan 2018 – Dec 2018 · 11 mos · Bangalore Urban, Karnataka, India

• Client : McAfee
• => Involved in data analysis of various customers in Mcafee.
• => Worked on data transformations using PL/SQL as source, Informatica as ETL Tool and PL/SQL as destination.
• => The project was inclined towards enhancement. Worked on optimization of the codes/workflows to make Account Search easier for the Client.
• => Technology : : PL/SQL, Informatica

Dec 2015 – Dec 2015 · 0 mo · Delhi, India