Suraj Kumar Dubey
Data Specialist
Gurugram
Summary
Seasoned Data Specialist adept in Agile Methodology for project implementation, with comprehensive proficiency across Data Governance, 3+ years of experience in Quality Assurance, BI Reporting, ETL, Cloud Integration, SQL Querying, Analytical Modeling, and Customer Master Data management. Recognized for optimizing processes, automating workflows, and delivering actionable insights. Poised to catalyze efficiency and unlock data potential within any organizational context.
Overview
4
4
years of professional experience
Work History
Data Specialist
Baker Hughes
Gurugram, Haryana (Hybrid)
03.2022 - Current
- Directed a pivotal project aimed at enhancing Data Quality organization-wide, employing a diverse set of technologies including Informatica and PySpark in a six month time. Developed robust data governance frameworks utilizing cutting-edge tools such as Databricks, alongside Business Intelligence solutions reducing Data inconsistencies resulting in 60% decline in support tickets.
- Implemented continuous improvements to ensure data integrity and reliability, empowering informed decision-making and fostering organisational success.
- Successfully integrated Databricks with multiple systems including AWS, Box Cloud, and Salesforce, employing efficient PySpark ingestion frameworks. Seamlessly orchestrating data workflows across diverse platforms to ensure smooth data integration and synchronization.
- Developed comprehensive data models to denormalise highly normalised datasets, enabling accessibility and utility for various teams within organization. Streamlined complex data structures to improve usability and efficiency, facilitating easier data access and interpretation.
- Developed detailed ETL Pipelines for data handling solutions using Informatica Data Quality tool, verifying compliance with internal needs and stakeholder requirements.
- Expertise in Informatica MDM, created physical data model, match & merge, hierarchy design, data load, cleanse functions, ActiveVos tasks, queries and packages etc.
- Writing advanced SQL queries to analyze data anomalies, trends, and risks to improve Data Quality within the organization.
- Organizing, and Maintaining KYC related data. This involves ensuring data integrity, accuracy, and completeness, as well as complying with data privacy and security regulations.
- Visualization, Development and Automation of Power BI Reports for Operations and KYC Data in order to analyze Inconsistencies between MDM and downstream.
- Designed and Automated Access Requests Processes for Customer Representatives in different Product Company across different locations using Power Apps.
- Collaborating with Technical and Non Technical Audience for effective use of Customer MDM application in ways that it can be understood by Business Stakeholders.
Developer
Tata Consultancy Services Limited
Pune, Maharashtra
01.2021 - 02.2022
- Experienced in Informatica IDQ, SQL and Data Warehousing, with good command on Data Modeling and providing business solutions in Technical as well as Functional aspects.
- Hands on experience in Master Data Management (MDM) - Managing Support Incidents/Tickets, Working on Problem Ticket Management & Change Management, Automation of Operational Activities, Working on Data Integration Stories.
- Working experience in tools such as Informatica IDQ (ETL), Putty (Unix Terminal), Soap UI, Toad (SQL DB2), Informatica Data Director.
- Developed comprehensive documentation to facilitate seamless handoff to other team members
Education
Bachelor of Technology - Mechanical Engineering
Dr. A. P. J Abdul Kalam Technical University
Lucknow 08.2016 - 09.2020
Senior Secondary - PCM
Kaushambi Public School (CBSE)
Prayagraj 04.2014 - 05.2015
High School -
Bethany Convent School (CBSE)
Prayagraj 04.2012 - 05.2013
Skills
SQL
ETL/ ELT ( Extract Transform Load)
Master Data Management
Data Governance
Data Quality Assurance
Databricks
PySpark
Unix
Microsoft Office Suite
Hadoop Ecosystem
Power BI
Microsoft Power Automate
Project Management
Python
Data Cleaning
Accomplishments
- Acknowledged for leading the Customer Master Data Analytics Project while successfully resolving significant data inconsistencies
- Recognition of Team Efforts Under the Category of DIGITAL TRANSFORMATION awarded for Excellence in Deliveries Across TPS,OFE and OFS in Baker Hughes.
- Distributed Storage and Processing Fundamentals ( TrendyTech- Certificate ID: as3avrncia, Issued: 2023-04-30)
- Informatica Master Data MDM ( Udemy Certification).
- Cloud Customer 360 (onDemand eLearning, Informatica)
- Mastering Data Modeling Fundamentals (Udemy Certification )
- SQL Essential Training ( LinkedIn Certification)
Timeline
Data Specialist
Baker Hughes
03.2022 - Current
Developer
Tata Consultancy Services Limited
01.2021 - 02.2022
Bachelor of Technology - Mechanical Engineering
Dr. A. P. J Abdul Kalam Technical University
08.2016 - 09.2020
Senior Secondary - PCM
Kaushambi Public School (CBSE)
04.2014 - 05.2015
High School -
Bethany Convent School (CBSE)
04.2012 - 05.2013