Yogesh Nandanwar
Navi Mumbai
Summary
Highly skilled and accomplished Data Modeler with over 10 years of experience in building and scaling enterprise-wide data warehouses in Financial domain. Expertise in modeling data across different layers of the data warehouse architecture, mapping business consumption requirements, designing semantic layers, and implementing advanced modeling techniques. Being a part of data warehouse automation, cloud platforms (Snowflake and AWS), and setting up data platforms for various analytical workloads.
Overview
9
9
years of professional experience
Work History
Data Modeler
Capgemini Pvt Ltd
Navi Mumbai
08.2022 - Current
- Led the design and implementation of data models for enterprise-wide data warehouses, optimizing scalability and performance across different layers.
- Translated complex business consumption requirements into efficient data structures on the data platform, enabling streamlined data access and analysis.
- Designed and implemented semantic layers to meet consumption requirements, enhancing data accessibility for end-users.
- Utilized advanced modeling techniques such as Dimensional modelling, Data Vault modeling to ensure robustness and flexibility in the data architecture.
- Contributed to data warehouse automation initiatives, optimizing development cycles and enhancing productivity.
- Leveraged Snowflake and AWS platforms to build scalable and reliable data solutions.
- Set up data platforms catering to various analytical workloads, including BI, ML, and AI, ensuring optimal performance and resource utilization.
- Applied deep knowledge of the finance industry to address industry-specific data requirements and compliance standards.
Senior Data Engineer/ Jr Data Modeller
Accenture Pvt Ltd
Navi Mumbai
05.2021 - 07.2022
- Designed and developed for solution for new Sourcing Data requirements (Interop's (PARCEL Data) and delivered within SLAs.
- Identify & create data mappings required for all entities in reporting layer and maintain the transformation matrix.
- Write scripts for each & every view with suitable logic, and provide a surrogate key wherever required.
- Rewrite Retail report SQL queries as per Teradata standard or tuned them to retrieve results in specified SLA using minimum system resources.
- Performance tuning by checking the table's stats, Diagnosis Data,limits of CPU usage, IO usage, and Skew range. and Correct setting Index.
- Automated environment setup for innovation area independent of environments i.e., DEV, Automated TESTING Approaches to validate data for Regression testing, System Testing ,System Integration Testing,Unit Testing, etc.
Data Engineer
Capgemini Pvt Ltd
Navi Mumbai
02.2015 - 04.2021
- Successfuly lead projects with regulatory reporting requirements for European clients, Help teams (BASEL, SIMREP, GSIB, FINREP, MREL, FATCA, etc.) for resolving defects.Designed and developed solutions for new reporting requirements and delivered within SLAs.
- Also working on Defects raised by the testing Team and resolved in given SLAs.
- Optimized queries for maximum efficiency and scalability in a production environment.
- Developed scripts to automate routine tasks such as backups, indexing, and query optimization.
- Resolved complex technical issues related to database systems performance tuning.
- Resolved complex database issues through thorough analysis and problem-solving skills.
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
Education
BE - Computer Engineering Technology
Mumbai University
Mumbai05-2013
Skills
- Data Warehousing
- Data Modeling
- Dimensional Data Modeling
- Data Vault Modeling
- Data Quality Management
- Requirements Gathering
- Business Intelligence
- Database Development
- Data Analytics
- Data Engineering
- SQL and Databases
- Snowflake
- Teradata
- AWS(Redshift)
- Agile Methodology
- DBT
- CI/CD
- Problem-Solving
- Python Programming
Languages
English
First Language
Hindi
Proficient (C2)
C2
Marathi
Proficient (C2)
C2
Timeline
Data Modeler
Capgemini Pvt Ltd
08.2022 - Current
Senior Data Engineer/ Jr Data Modeller
Accenture Pvt Ltd
05.2021 - 07.2022
Data Engineer
Capgemini Pvt Ltd
02.2015 - 04.2021
BE - Computer Engineering Technology
Mumbai University
Similar Profiles
Purnashilpa WaghmarePurnashilpa Waghmare
Senior Manager at Capgemini Pvt LtdSenior Manager at Capgemini Pvt Ltd
Rijo John CharivinpuramRijo John Charivinpuram
Consultant at Capgemini Pvt LtdConsultant at Capgemini Pvt Ltd
RAMANDEEP KAURRAMANDEEP KAUR
Senior Associate at Capgemini Pvt LtdSenior Associate at Capgemini Pvt Ltd