Yatin Wasan

Associate Consultant at KPMG Global Services (KGS), Infrastructure team, based in India, with 3 years of experience with application projects in Power BI, SQL, Power Automate, SharePoint, Power apps, Tableau, Python, Alteryx and Excel.

I specialize in developing high-complexity Power BI dashboards and performing data transformations in Alteryx while actively engaging in client requirement gathering.

With a client-facing role on the Data Analytics team, my responsibilities encompass crafting and managing financial and asset management dashboards using Power BI to deliver exceptional value.

Also gained experience in facilitating client meetings, conducting workshops, and delivering presentations to stakeholders at various organizational levels.

• Rising Star Award - KPMG
• KUDOS Award - KPMG
• SPOT Award - KPMG
• Pat on the back Award - VertexPlus Technologies
• Several client delights from KPMG for delivering complex projects

Project 1: Key Metrics Analysis Dashboard

Client : US (Oil and Natural Gas Industry)

Roles and Responsibilities:

• We were engaged by the client to develop several Power BI Dashboards for ongoing   monitoring and analysis of key performance metrics related to PG&E's natural gas and other services across the United States. 

• The dashboards were created to provide insight into metrics including total miles spread, accomplished miles, number of in-progress projects, and weekly forecasts, offering valuable insights into the company's operational performance.

Environment: Power BI, Alteryx

Project 2 : Demand Analysis- Cluster Model

Client: Retail  

Roles and Responsibilities:

Project Management

For a US based client identified the location for new service plants to be opened basis the demand  data available with Latitude and Longitude.

• Targeted to meet 80% demand in 2 transit day.

• Generated demand centric clusters using K- Mean cluster in Python  

• Created workflows to fetch data from different sources using Alteryx.  

• Created workflows to clean and manipulate the unstructured data to structured data.  

• Performed unit testing on alteryx to isolate each part of the project and show that the  individual parts of the project are correct  .

• Used many tools of alteryx such as preparation tools, transformation tools and Joins to  transform the data and extracted the same data to visualise it in tableau for data visualisation.

Environment: Power BI, Tableau, Alteryx, Python

Project 3 : India retail sector Growth forecast

Domain: Retail Sector

Roles and Responsibilities:

My major responsibility was to perform Descriptive analytics and data preparing for modelling  team. Assist modelling team in creating a:  

• Assisted meddling team in writing codes in Python for an Arimax model on Macro  economic factors like GDP, Consumer Confidence Index, House hold savings, real disposable  incomes, Unemployment rate to forecast the growth rate for retail sector in eleven countries,  using Oxford economics data.  

• Model validations, outlier detections, data preparation for Tableau etc.  

Environment: Power BI ,Power apps,Python, ARIMAX time series forecasting model, Tableau dashboard

• Infrastructure
• Asset & Service Management
• Telecommunication

• English
• Hindi

2 Month, Can Relocate