Hi, I’m
Yash Dubey
Data Engineer
Summary
Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code,data pipelines. Background includes data mining, warehousing ,ETL and analytics.
Overview
6
years of professional experience
6
years of post-secondary education
1
Certification
Work History
IQVIABangalore
Consultant
08.2021 - Current
Job overview
- Worked on various Incentive Compensation Projects in Med tech space to implement the data architecture of reporting into the dashboard with maintaining data in star schema
- Automated ETL operations which helped in saving lot of hours for the process and designed a generic data architecture which can be reused for multiple tenants
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
- Developed, implemented and maintained data analytics protocols, standards, and documentation.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Documented and communicated database schemas using accepted notations.
- Designed data models for complex analysis needs.
- Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
- Demonstrated strong organizational and time management skills while managing multiple projects.
- Worked with business and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
- Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
A&H InfotechBangalore
Consultant
03.2021 - 07.2021
Job overview
- Designed integration tools to combine data from multiple, varied data sources such as Redshift, files and big data installations.
- Worked independently to design, develop and test code for Sony Music using Pyspark.
- Learned and implemented Pyspark along with AWS in order to get
better understanding of the project - Worked with Big Data Analytical problem , applied ETL using spark framework .
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
- Interpreted data models for conversion into ETL diagrams and code.
- Verified performance and reliability of development database transformation solutions via extensive simulation testing.
- Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
- Documented and communicated database schemas using accepted notations.
Infosys(EY Transition)Bangalore
Senior Data Analyst
08.2019 - 03.2021
Job overview
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Developed database objects, including tables, views using SQL
- Analyzed SAP transactions to build logical business intelligence model.
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Developed database objects, including tables, views using SQL. Produced monthly reports using advanced Excel spreadsheet functions.
- Documented business workflows for stakeholder review
- Collaborated with stakeholders to identify business needs and data sources.
- Used SQL ,ETL ,OLAP concept with Power BI and Power Query to create reports and recommended courses of action to upper management.
Ernst and YoungBangalore
Advanced Analyst
04.2018 - 07.2019
Job overview
- Collected data and developed detailed spreadsheets to identify trends and create revenue, profitability, and expense forecasts.
- Reviewed financial reports and streamlined operations to increase productivity.
- Synthesized current business intelligence data to produce reports and polished presentations, highlighted findings and recommended changes.
- Developed database objects, including tables, views using SQL.
- Produced monthly reports using advanced Excel spreadsheet
functions. - Designed and developed schema data models.
- Documented business workflows for stakeholder review.
- Identified and documented detailed business rules and use cases
based on requirements analysis. - Participated in requirements meetings and data mapping sessions to understand business needs.
- Updated organizational and process of subsystems to improve and
streamline data collection. - Analyzed SAP transactions to build logical business intelligence model for real-time reporting needs.
- Used SQL ,ETL ,OLAP concept with Power BI and Power Query to create reports and recommended courses of action to upper management.
CapegeminiChennai
Software Engineer
03.2017 - 04.2018
Job overview
- Performed duties in accordance with all applicable standards, policies and regulatory guidelines to promote safe working environment.
- Worked on Informatica Power Centre tool- Source Analyzer, Data-warehousing designer, Mapping and Mapplet designer
- Responsible for extraction of data from different sources system to Staging area and loaded the data to the target database by ETL process
- Worked on various transformation like filter for flat files to identify source and target bottlenecks
- Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer
- Responsible for fixing the problem- Defect solving, testing existing mappings and workflow
- Coordination with users, workflow, individual modules
- Carried out day-day-day duties accurately and efficiently.
- Maintained energy and enthusiasm in fast-paced environment.
- Designed data models for analysis needs.
Education
BBD NIIT Lucknow
Bachelor of Technology from Information Technology
07.2012 - 08.2016
University Overview
- Member of Chess Club
- Organized chess events
St. Joseph Montessori SchoolLucknow
Senior Secondary
04.2010 - 06.2011
St. Joseph Montessori School
Higher Secondary
04.2008 - 06.2009
Skills
Team Leadership & Development
Data Warehousing
Data Warehousing Management
SQL Programming
Database Management
DSA(Basic to Intermediate)
Python,Pyspark
Apache Spark
Certification
Certified Oracle SQL Expert
Timeline
Consultant
IQVIA
08.2021 - Current
Consultant
A&H Infotech
03.2021 - 07.2021
Senior Data Analyst
Infosys(EY Transition)
08.2019 - 03.2021
Advanced Analyst
Ernst and Young
04.2018 - 07.2019
Software Engineer
Capegemini
03.2017 - 04.2018
BBD NIIT
Bachelor of Technology from Information Technology
07.2012 - 08.2016
St. Joseph Montessori School
Senior Secondary
04.2010 - 06.2011
St. Joseph Montessori School
Higher Secondary
04.2008 - 06.2009