Summary
Overview
Work History
Education
Skills
Websites
Timeline
Other Details
Generic
Abhishek Sharma

Abhishek Sharma

Noida

Summary

Results-driven Data Analyst with over 11 years of experience in analyzing and interpreting complex data sets to extract valuable insights. Proficient in data mining, ETL processes, and data visualization using tools such as Azure Databricks, SQL, Python, Tableau, and Power BI. Skilled in working with advanced Tableau features, creating automated dashboards, and transforming unstructured data into actionable reports. Robust business intelligence skills and expertise in cloud databases like Snowflake. Committed to delivering data-driven solutions that drive growth and enhance business performance.

Overview

11
11
years of professional experience

Work History

Data Analyst - Module Lead

Mphasis Ltd.
Noida
09.2022 - Current
  • Performing exploratory data analysis and generating ETL pipelines on big datasets of global Indices and Corporate Actions Events coming from multiple Data Providers such as Reuters, Refinitiv, and FactSet, to compare various attributes like Prices, Currencies, or Event types using Python algorithms, snowflake database, and SQL queries
  • Designing a Data Mapping and Quality Check Framework that checks the coverage or mapping among various Datasets within Snowflake Database using advanced SQL queries with time-intelligence functions, Stored Procedures, and Dynamic SQL functionalities
  • Transformed multiple revenue assessment Excel spreadsheets into a single dynamic and real-time Dashboard using Microsoft Power BI. Furthermore, I integrated the dashboard with a SharePoint site with scheduled Refresh Functionalities
  • Managing multiple projects and collaborating with the team using JIRA tickets for updating the progress or hurdles found within the project.

Data Analyst

Optum Global Solution Pvt Ltd.
08.2021 - 09.2022
  • Performed the cost-benefit analysis for healthcare clients using Data from hospitals in the North America region and created a dynamic Dashboard using Tableau with critical metrics and automated insights, which resulted in increasing their revenue by 20% after highlighting the major focus areas and revenue enhancement opportunities along with the recommendation that business needs to look upon
  • Performed data mining on unstructured data (healthcare) using PySpark and SQL algorithms in Azure Databricks and created insightful dashboards with various key metrics and KPIs in Tableau Desktop and Power BI for Global healthcare clients
  • Performed anomaly detection and time series forecasting by analyzing current and historical industry data using Python libraries such as Pycaret and Prophet which help businesses to build future strategies
  • Created the process automation framework using Python and Pyspark in Azure Databricks that automates the insights generation process and visualizes the generated insights in the Tableau and Power BI dashboard.

Global Spend Analyst

Startek
01.2020 - 08.2021
  • Created a Spend Dashboard for Procurement and Finance team using Microsoft Excel and Power BI (DAX) that visualizes – certain KPIs (TAT, Productivity, etc.), month-wise spending, Budget Vs actual spend analysis, major global vendors, major spend categories, major spend regions, etc
  • Created a purchasing forecast tool for one of our key clients to accommodate their custom purchasing patterns
  • The client uses this monthly to plan their $ 100+ million Purchase Orders.

Asst. Manager - Spend Analyst

The-Hitech Robotics Systems Pvt Ltd.
01.2020 - 08.2021
  • Perform Spend analytics for various Clients present across the globe and drive valuable insights from the data using Excel, Power BI, Tableau, and SQL.

Asst. Manager - Sourcing Analyst

Samsung India Electronics Pvt Ltd.
07.2012 - 02.2019
  • Negotiating the best price deals for the material requirements, Strategic Sourcing, and Vendor development for direct and indirect material and making Budget requirements, Procurement plans, and Purchase orders (PR to PO) for MLCC Components using SAP MM
  • Add-on Responsibilities from Jan 2016 onwards: Creating Spend analytics reports drive valuable insights from the data using Excel and Tableau
  • Performing monthly Procurement spend analysis, aging inventory analysis, and global Vendor data management (commodity-wise) using SAP mm and Microsoft Excel.

Education

Bachelor of Science - Electrical, Electronics And Communications Engineering

Amity University
Noida, Uttar Pradesh, India
05.2012

12th -

St. Francis School Shamli (ISC Board)
01.2008

10th -

St. Francis School Shamli (ICSE Board)
01.2006

Skills

  • Data Analysis
  • Process Mapping
  • Data Mapping
  • Gap Analysis
  • Data Validation
  • A/B Testing
  • Python Programming
  • Advance SQL
  • Data Quality Check Framework
  • Tableau Desktop
  • Microsoft Power BI
  • Snowflake Database
  • JIRA
  • Advance Excel

Websites

Timeline

Data Analyst - Module Lead

Mphasis Ltd.
09.2022 - Current

Data Analyst

Optum Global Solution Pvt Ltd.
08.2021 - 09.2022

Global Spend Analyst

Startek
01.2020 - 08.2021

Asst. Manager - Spend Analyst

The-Hitech Robotics Systems Pvt Ltd.
01.2020 - 08.2021

Asst. Manager - Sourcing Analyst

Samsung India Electronics Pvt Ltd.
07.2012 - 02.2019

Bachelor of Science - Electrical, Electronics And Communications Engineering

Amity University

12th -

St. Francis School Shamli (ISC Board)

10th -

St. Francis School Shamli (ICSE Board)

Other Details

  • Date of Birth: 03/19/1990
  • Marital Status: Single
  • Language: English (Advance)

Similar Profiles

CREATE PROFILE
Abhishek Sharma