Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Hobbies and Interests
Timeline
Generic

Prabhakar Dubey

Mathura

Summary

Enthusiastic and driven Data Analyst/Engineer with 5.5 years of experience in developing, implementing, and testing BI and software solutions. Individual with strong programming abilities, critical thinking skills, and the capability to grasp new concepts and technologies quickly.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Lead Engineer

Harman Connected Services
Gurugram
02.2024 - Current
  • Created Dashboard for Microsoft finance-related data and publishing over Power bi service along with enhancing and maintaining reports.
  • Created SQL stored procedures to pull data in Power BI to create datasets to eventually use in modeling.
  • Handled all kinds of database objects like stored procedures, views, schemas, and temporary tables.
  • Created and maintained multiple pipelines in ADF to update the data in Power BI service by scheduling pipelines to run for a specified routine.
  • Conducted data cleaning and preparation tasks while working on a Power BI Project - extracting data from SQL Server and Excel sheets, and transforming data. Also, created measures and columns using DAX formulas.

Data Engineer

Pratham Software(PSI)
02.2022 - 01.2024
  • Experience in writing T-sql code using functions, views, temp tables and other database objects
  • Wrote parameterized sql queries for generating SSRS(Sql Server Reporting Services), formatting report layout in SSRS 2019/2017/2014/2008 R2/2008
  • Experience in optimizing t-sql code to use in SSRS reports to make them run faster
  • Created visually appealing reported including Drill Down, Sub eports, images using image api or database image
  • Created and worked on SSIS pipeline enhancement along with ADF pipelines to dump data in sql server as tagret.
  • Worked on a self-service report builder platform to create reports using Telerik reporting services and created multiple paginated reports over Telerik report builder
  • Conducted data cleaning and preparation tasks while working on a Power Bi Project - extracting data from sql server and excel sheets and transformed data and created measures and columns using DAX formulas
  • Created/maintained multiple pipelines in ADF and tranforming the the data as per business rules before dumping the data in azure storages
  • Created pipelines in AWS Glue and Azure Data Factory to create, automate and clone SSIS data pipelines and usd the dumped to datafor modelling in power bi and established relationships externally before creating visual dashboards in power bi desktop
  • Created various Visualized reports and reployed dashboard using Power Bi service
  • Knowledge in building datawarehouse, staging area database using ETL pielines in SSIS and datawarehouse tables in SQL Server.

Senior Sytsems Engineer

Infosys Pvt Ltd
10.2018 - 01.2022
  • Working in developing and enhancing DB2 module and stored procedures to include various changes in database related to various Mainframe - online and batch modules
  • Experience in creating ETL packages using data from heterogeneous sources to MS SQL Server by using SSIS services and BCP utility
  • Experience in creating SSIS data pipelines to use that dumped data in SSAS for analytics and then creating SSRS reports, thus implementing full Microsoft BI stack
  • Experience in documentation at stages of designing, developing and testing
  • Experience in writing test scripts on different levels of Testing
  • Worked on Database and Log Backups Restoration, Backup Strategies, Scheduling Backups
  • Work experience in AGILE methodologies
  • Knowledge on different Levels of Testing (Unit Testing, Integration Testing, System Testing).

Education

Bachelor Of Technology - Computer Science and Engineering

Jaipur Engineering College and Research Center

Senior Secondary School -

SPU Inter college

High School -

Delhi Public School

Skills

  • T-SQL
  • Power BI
  • SSRS
  • MSBI
  • Microsoft SQL Server
  • SSIS
  • TELERIK
  • Datawarehousing
  • Data Modelling
  • ETL
  • Azure Data Factory
  • pyspark
  • Pandas
  • DB2
  • COBOL
  • Python

Certification

  • Azure Data Certification - DP 900
  • Udemy Certification - Data Warehouse Developer- SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL
  • Udemy Certification in SQL Server (T-SQL, Administration, Performance) and SSRS
  • Infosys Certification - Agile Methodologies Certification

Accomplishments

  • Awarded with 'Emerging Employee award' at Pratham Software.
  • Got Various written and verbal Appreciation from Client for showing exemplary proactiveness and Excellent Performance during Projects.
  • Awarded with 'Achiever' award in my unit for Q3 20-21 at Infosys.

Hobbies and Interests

  • Graphic designing
  • Reading about Cosmos and Indian mythology
  • Travelling

Timeline

Lead Engineer

Harman Connected Services
02.2024 - Current

Data Engineer

Pratham Software(PSI)
02.2022 - 01.2024

Senior Sytsems Engineer

Infosys Pvt Ltd
10.2018 - 01.2022
  • Azure Data Certification - DP 900
  • Udemy Certification - Data Warehouse Developer- SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL
  • Udemy Certification in SQL Server (T-SQL, Administration, Performance) and SSRS
  • Infosys Certification - Agile Methodologies Certification

Bachelor Of Technology - Computer Science and Engineering

Jaipur Engineering College and Research Center

Senior Secondary School -

SPU Inter college

High School -

Delhi Public School
Prabhakar Dubey