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
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
Similar Profiles
Megan MunroeMegan Munroe
Associate Scientist at IQVIAAssociate Scientist at IQVIA
Asmat ShaikhAsmat Shaikh
Associate Director, Safety Project Leadership at IQVIAAssociate Director, Safety Project Leadership at IQVIA
Lokesh ALokesh A
Salesforce Engineer-2 at IQVIASalesforce Engineer-2 at IQVIA