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
Similar Profiles
Bhuvanesh SelvanBhuvanesh Selvan
Solution Architect - Product Development at Harman Connected ServicesSolution Architect - Product Development at Harman Connected Services
Skanda A RSkanda A R
Software Engineer, Product Development at HARMAN CONNECTED SERVICESSoftware Engineer, Product Development at HARMAN CONNECTED SERVICES
Puneet AggarwalPuneet Aggarwal
Lead Engineer at Harman Connected Services Pvt. LtdLead Engineer at Harman Connected Services Pvt. Ltd