Summary
Overview
Work History
Education
Skills
Software
Certification
Timeline
Generic

Samarth Desai

Data Solution Consultant
Bengaluru

Summary

A skilled Data Solution Consultant with over 2 years of expertise in data analytics, benchmarking, HRIS analytics, and M&A analytics. Proficient in data visualization, interactive dashboard creation, data processing, manipulation, and ETL using tools such as SQL, Python, Power BI, MS Excel, Alteryx, Databricks, and Synapse. Capable of converting complex data into actionable insights to support informed decision-making.

Overview

6
6
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
3
3
Languages

Work History

Consultant

PwC Service Delivery Center
Bengaluru
05.2022 - Current

Project Saratoga

  • Handled a cross functional team of three people to deliver the client results seamlessly with minimum errors and maximum efficiency.
  • Collaborated with clients to understand their specific data needs and business objectives.
  • Efficiently processed and managed large volumes of HRIS data, ensuring accuracy and completeness.
  • Developed and implemented data cleaning protocols to enhance data quality.
  • Generated comprehensive reports and dashboards to present key HR metrics and trends.
  • Provided data-driven recommendations to improve HR processes, enhance employee engagement, and optimize workforce planning.
  • Identified opportunities for system enhancements and automation to reduce manual effort and increase productivity.
  • Applied data analysis to tasks, identifying business challenges and designing potential operational enhancements.
  • Provided ongoing support to resolve data-related issues and queries, ensuring user satisfaction.
  • Created and maintained documentation for processes, reports, and system functionalities.
  • Reduced the data collection, processing and insight generation time by 35% by automating the ETL and data mapping functions.

Project Neon

  • Partnered with clients to understand their strategic objectives, providing tailored data insights to support their M&A activities.
  • Prepared and presented detailed reports and analyses to senior executives, facilitating informed decision-making and strategic planning.
  • Designed and implemented robust ETL workflows to integrate and process large datasets from multiple sources.
  • Automated data extraction, transformation, and loading processes, reducing manual workload by 40%.
  • Conducted comprehensive data analysis to support mergers, acquisitions, divestitures, and carve-outs, providing clients with actionable insights.
  • Created interactive dashboards and detailed reports, enhancing data visibility and decision-making for clients.
  • Improved data quality by 30% through rigorous data validation, cleansing, and enrichment processes.
  • Reduced data reconciliation deviations by 25% by standardizing data processing techniques and leveraging advanced analytics tools.

Project Helium

  • Analyzed large datasets to identify patterns and correlations that indicate supplier risk, providing clients with early warning signals and risk mitigation strategies.
  • Conducted segmentation of suppliers based on risk levels, performance metrics, and strategic importance, helping clients prioritize supplier management efforts.
  • Leveraged data analytics to identify new potential suppliers and service providers, considering factors like cost, reliability, and market trends, leading to more informed procurement decisions.
  • Integrated data from multiple sources, including ERP systems, procurement databases, and third-party risk assessment tools, to provide a holistic view of supplier performance.
  • Monitored and analyzed market trends to anticipate supply chain disruptions and recommend proactive measures, improving client preparedness and resilience.
  • Worked closely with procurement teams, risk managers, and other stakeholders to ensure alignment and effective use of dashboard insights in decision-making processes.
  • Developed automated reporting systems that generate regular updates on supplier performance and risk status, reducing the manual effort required for ongoing monitoring.

Associate Software Engineer

Accenture
Bengaluru
07.2018 - 01.2019
  • Proactively identified and addressed potential bottlenecks in application performance, resulting in consistently smooth end-user experiences.
  • Collaborated with product owners to stay current on intended functionality.
  • Conducted daily one-on-one meetings with clients to remain in- formed about their expectations and requirements.
  • Provided billing database support, including but not limited to updating billing information, resolving anomalies and duplications, and addressing outliers, for a UK-based telecommunications company.
  • Successfully resolved customer issues through the implementation of workarounds and solutions, debugging and creating defect fixes as required.

Education

MBA - Operations Management

Symbiosis Institute of Business Management
Bengaluru, India
04.2020 - 04.2022

Bachelor of Engineering - Information Science

BVB College of Engineering And Technology
Hubli, India
08.2014 - 06.2018

Skills

  • HRIS Data Analysis

  • Data Manipulation

  • ETL

  • Benchmarking

  • M&A Data Analysis

  • Dashboard Creation

  • Data Visualization

  • Client Relationships

  • Continuous Improvement

  • Business Analysis

  • Data Analytics

  • Team Collaboration

  • Adaptability

  • Interpersonal Skills

Software

Python

Power BI

Alteryx

MS Office

MySQL

Databricks

Azure Synapse

Certification

Power BI Data Analyst Associate, Microsoft - March 2023 - March 2025.

Timeline

Power BI Data Analyst Associate, Microsoft - March 2023 - March 2025.

03-2023

Azure Data Fundamentals, Microsoft - June 2022

06-2022

Consultant

PwC Service Delivery Center
05.2022 - Current

MBA - Operations Management

Symbiosis Institute of Business Management
04.2020 - 04.2022

Associate Software Engineer

Accenture
07.2018 - 01.2019

Bachelor of Engineering - Information Science

BVB College of Engineering And Technology
08.2014 - 06.2018
Samarth DesaiData Solution Consultant