Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Abhishek Kumar

New Delhi

Summary

Data Analyst with 7+ years of experience specializing in Business Intelligence (BI) and Master Data Management (MDM), focusing on leveraging SQL Server as the primary database for data integration and reporting. Proven expertise in migrating reports from Excel to Power BI, creating dynamic dashboards that empower data-driven decision-making. Skilled in DAX for data analysis and delivering actionable insights that enhance organizational performance.

Strong proficiency in SAP data integration, with experience optimizing data workflows and ensuring high-quality master data management. Expertise in aligning data governance processes across systems, ensuring consistency and compliance to support business intelligence initiatives.

Solid foundation in SQL Server, using T-SQL for basic data querying, manipulation, and reporting. Able to leverage SQL Server to manage and streamline large datasets, ensuring data integrity and supporting reporting processes.

Proven ability to develop insightful reporting tools and process optimizations that improve operational efficiency and enhance data visualization across teams. Committed to driving business intelligence strategies to optimize decision-making and performance.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Power BI Developer

Publicis Resources
New Delhi
05.2023 - 01.2025

Tools: Power BI, Advanced Excel, SAP, SQL Server

  • Developed Power BI dashboards to enhance the visualization of MDM metrics, enabling stakeholders to make informed, data-driven decisions.
  • Led MDM initiatives focused on optimizing data governance and improving data quality across systems, integrating data from SQL Server, SAP, and Excel.
  • Collaborated with cross-functional teams to translate business requirements into technical solutions using Power BI, streamlining reporting and analytics.
  • Managed data extraction and transformation between SAP and Power BI, ensuring seamless integration and reliable reporting.
  • Utilized SQL Server for basic data querying and manipulation, supporting data flow between SAP, Power BI, and Excel for comprehensive analysis and reporting.

Data Analyst

AWC Software Pvt Ltd
10.2021 - 04.2024

Tools: MS Excel, SAP, Power BI, SQL Server

  • Led Master Data Registration for customer and vendor data in SAP, ensuring data accuracy and alignment with business processes.
  • Used DAX functions in Power BI to track productivity, quality, and SLA compliance in MDM processes, enhancing performance visibility.
  • Managed data cleanup projects, improving data accuracy and visualizing results with Power BI dashboards, enabling actionable insights.
  • Supported global teams in maintaining master data across systems, ensuring consistency and reliability across SAP, Excel, and Power BI.
  • Utilized SQL Server for basic querying and data manipulation, ensuring smooth data integration between SAP, Power BI, and Excel for comprehensive reporting and analysis.

Business Analyst

Actiknow Business Consulting
New Delhi
04.2020 - 09.2021
  • Tools: MS Excel, Google Sheets, Power BI
  • Developed interactive Power BI dashboards for survey analysis and business insights
  • Analyzed customer sales data to provide actionable business insights
  • Interacted with clients to gather business requirements and improve data analysis processes.

Business Analyst

Actiknow business consulting
07.2019 - 03.2020
  • Tools: MS Excel, Power BI, VBA-Macros, WRIKE
  • Optimized master data processes for a European logistics portal, improving data processing efficiency
  • Automated data mapping processes and integrated freight and tax regulation updates.

Data Analyst

Actiknow business consulting
12.2016 - 06.2019
  • Project: RS (Europe-based Shipping & Logistics Portal)
  • Optimized master data files for carriers in the logistics industry
  • Analyzed shipping company data based on quotations and tax regulations.

Education

Master of Computer Applications -

Guru Gobind Singh Indraprastha University
New Delhi
01.2016

Bachelor of Computer Applications -

Jamia Hamdard University
New Delhi
04-2013

Skills

  • DAX Functions Expertise
  • Master Data Management (MDM)
  • SQL server reporting services
  • Introductory SAP Skills
  • Power Apps Workflow Automation
  • Data Modeling
  • Data Reporting
  • Excel Proficiency

Certification

  • Microsof Power BI - A complete Introduction - Udemy
  • Exce Essential - Udemy

Timeline

Power BI Developer

Publicis Resources
05.2023 - 01.2025

Data Analyst

AWC Software Pvt Ltd
10.2021 - 04.2024

Business Analyst

Actiknow Business Consulting
04.2020 - 09.2021

Business Analyst

Actiknow business consulting
07.2019 - 03.2020

Data Analyst

Actiknow business consulting
12.2016 - 06.2019

Master of Computer Applications -

Guru Gobind Singh Indraprastha University

Bachelor of Computer Applications -

Jamia Hamdard University
Abhishek Kumar