YASH DUBEY
Data Analyst
Bengaluru,KA
Summary
Dedicated and motivated data analyst with proven ability to drive process efficiency and data integrity. Over 3 years of experience leading teams in ETL, data mining and data warehousing solutions. Exceptional skill in SQL-based environments.
Overview
1
1
Certification
6
6
years of post-secondary education
4
4
years of professional experience
Work History
Data Analyst
Infosys(EY transition)
Bangalore, Karnataka
08.2019 - Current
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending 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.
Data Analyst
Ernst and Young
Bangalore, Karnataka
04.2018 - 07.2019
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending 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.
ETL Informatica Developer
Capgemini
Chennai, Tamil Nadu
03.2017 - 04.2018
- 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
Bachelor of Technology - Information Technology
BBD NIIT
Lucknow 08.2012 - 07.2016
Senior Secondary -
St. Joseph Montessori School
Lucknow 07.2010 - 06.2011
Higher Secondary -
St. Joseph Montessori School
Lucknow 07.2008 - 07.2009
Skills
Data extracting
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Certification
Certified Oracle SQL Expert
Quote
The mind is everything. What you think, you become.
Gautama Buddha
Timeline
Data Analyst
Infosys(EY transition)
08.2019 - Current
Data Analyst
Ernst and Young
04.2018 - 07.2019
Certified Oracle SQL Expert
07-2017
ETL Informatica Developer
Capgemini
03.2017 - 04.2018
Bachelor of Technology - Information Technology
BBD NIIT
08.2012 - 07.2016
Senior Secondary -
St. Joseph Montessori School
07.2010 - 06.2011
Higher Secondary -
St. Joseph Montessori School
07.2008 - 07.2009
Similar Profiles
Ved ShuklaVed Shukla
Senior System Engineer at InfosysSenior System Engineer at Infosys
ASMITA KULKARNIASMITA KULKARNI
Consultant at InfosysConsultant at Infosys
Akshat YadavAkshat Yadav
Technology Lead-US at InfosysTechnology Lead-US at Infosys