Led and developed the design, development and deployment to support acquisition of another Pharma by Takeda on multiple platforms like Informatica cloud, AWS S3, Oracle and Unix for Ethics and compliance Transparency Reporting system.
Developed ETL mappings, Shell scripts, complex SQL queries and worked on Job Orchestration framework for automation of workloads.
Implemented performance tuning measures to meet SLAs.
Excellent problem-solving and analytical skills and understanding of business processes and data.
Conducted technical solution assessment and evaluation for multiple scenarios related to Transparency reporting data to Business.
Led the effort for assessment and improvement of source data quality and set up process for review of data quality metrics.
Takeda GmbH, Konstanz (Germany)
7 Jahre
2015-02 - 2022-01
Management and development of ETL projects
Senior consultant
Senior consultant
Lead and developed ETL projects from inception to completion, ensuring timely delivery and quality.
Played a pivotal role in designing, developing and implementing robust and scalable data extraction, transformation, and loading (ETL) solutions.
Extensively worked on SSRS reporting to develop reports related to Commercial sales sector on Sell-In/Sell-Out and Forecast. Used SSAS cube and MDX queries for report development.
Ensured adherence to best practices, coding standards and quality assurance processes.
Developed detailed data mapping and transformation logic and technical documentation.
Development and performance tuning of the Informatica mappings, using best practices and tuning standards. Implemented optimization approach to reduce execution time from hours to secs.
Infosys Ltd., Pune (India)
8 Jahre 2 Monate
2007-01 - 2015-02
Previous Experience
Held various technical roles at Teradata India Pvt. Ltd. and Infosys Technologies Pvt. Ltd., designing and developing data integration solutions using ETL frameworks, data profiling and data quality analysis, automation, and collaborated with cross functional data stakeholders.
Optimized ETL/ELT pipelines, scripts and database objects to improve large volume telemetry data processing using pushdown optimization, ETL parallelism and multithreading approaches ensuring efficient data processing and minimizing data latency.
Aus- und Weiterbildung
Aus- und Weiterbildung
Bachelor of Engineering in Computer Science (Pune University, Year 2007 with Distinction grade)
A result-oriented Senior Technical Lead/Data Engineer with 15+ years of experience driving data-driven initiatives at scale across Pharmaceuticals, Healthcare, Banking, Retail and Electronic Media industries.
Proven ability to design and develop multiple Data Integration, Migration and Data Management solutions for Data Warehouse and marts using various ETL and Database Technologies.
Deep understanding and hands-on experience in requirements gathering, ETL design and Modelling, Data mapping, Implementation, Data & Code Migration, Quality of ETLs, understanding and defining non-functional Requirements of DW, Data Profiling, data retention strategies and setting up review processes and standards.
Adept at ensuring data quality, compliance, security, scalability while fostering a culture of enterprise data governance.
Lead cross-functional teams, develop data strategies, optimize data infrastructure and foster collaboration to achieve business objectives.
Demonstrated leadership in technical solution evaluation, recommending best-fit solutions, capacity planning and architectural design as well as leading technical solutions for multiple projects.
Extensively worked on performance optimization techniques at database, ETL and UNIX levels like Pushdown Optimization (PDO), Database Statistics, Parallelism, Multithreading and Indexing.
Technical Skills
Expertise in Data Integration Tools: Informatica PWC, Informatica Cloud (15+),ADF
Data Integration: Datastage
Data Integration: Snowflake
Cloud Platform: AWS, Azure
Expertise in Relational Databases: Teradata (8), Oracle, MySQL, MS SQL Server
Expertise in Languages: SQL (15+), PL/SQL, Expertise in Unix Scripting, SAS,
Ability to work independently and as part of a team
Einsatzorte
Einsatzorte
Deutschland
möglich
Projekte
Projekte
3 Jahre 4 Monate
2022-01 - 2025-04
Acquisition of another pharmaceutical company
Senior ETL Lead
Senior ETL Lead
Led and developed the design, development and deployment to support acquisition of another Pharma by Takeda on multiple platforms like Informatica cloud, AWS S3, Oracle and Unix for Ethics and compliance Transparency Reporting system.
Developed ETL mappings, Shell scripts, complex SQL queries and worked on Job Orchestration framework for automation of workloads.
Implemented performance tuning measures to meet SLAs.
Excellent problem-solving and analytical skills and understanding of business processes and data.
Conducted technical solution assessment and evaluation for multiple scenarios related to Transparency reporting data to Business.
Led the effort for assessment and improvement of source data quality and set up process for review of data quality metrics.
Takeda GmbH, Konstanz (Germany)
7 Jahre
2015-02 - 2022-01
Management and development of ETL projects
Senior consultant
Senior consultant
Lead and developed ETL projects from inception to completion, ensuring timely delivery and quality.
Played a pivotal role in designing, developing and implementing robust and scalable data extraction, transformation, and loading (ETL) solutions.
Extensively worked on SSRS reporting to develop reports related to Commercial sales sector on Sell-In/Sell-Out and Forecast. Used SSAS cube and MDX queries for report development.
Ensured adherence to best practices, coding standards and quality assurance processes.
Developed detailed data mapping and transformation logic and technical documentation.
Development and performance tuning of the Informatica mappings, using best practices and tuning standards. Implemented optimization approach to reduce execution time from hours to secs.
Infosys Ltd., Pune (India)
8 Jahre 2 Monate
2007-01 - 2015-02
Previous Experience
Held various technical roles at Teradata India Pvt. Ltd. and Infosys Technologies Pvt. Ltd., designing and developing data integration solutions using ETL frameworks, data profiling and data quality analysis, automation, and collaborated with cross functional data stakeholders.
Optimized ETL/ELT pipelines, scripts and database objects to improve large volume telemetry data processing using pushdown optimization, ETL parallelism and multithreading approaches ensuring efficient data processing and minimizing data latency.
Aus- und Weiterbildung
Aus- und Weiterbildung
Bachelor of Engineering in Computer Science (Pune University, Year 2007 with Distinction grade)
A result-oriented Senior Technical Lead/Data Engineer with 15+ years of experience driving data-driven initiatives at scale across Pharmaceuticals, Healthcare, Banking, Retail and Electronic Media industries.
Proven ability to design and develop multiple Data Integration, Migration and Data Management solutions for Data Warehouse and marts using various ETL and Database Technologies.
Deep understanding and hands-on experience in requirements gathering, ETL design and Modelling, Data mapping, Implementation, Data & Code Migration, Quality of ETLs, understanding and defining non-functional Requirements of DW, Data Profiling, data retention strategies and setting up review processes and standards.
Adept at ensuring data quality, compliance, security, scalability while fostering a culture of enterprise data governance.
Lead cross-functional teams, develop data strategies, optimize data infrastructure and foster collaboration to achieve business objectives.
Demonstrated leadership in technical solution evaluation, recommending best-fit solutions, capacity planning and architectural design as well as leading technical solutions for multiple projects.
Extensively worked on performance optimization techniques at database, ETL and UNIX levels like Pushdown Optimization (PDO), Database Statistics, Parallelism, Multithreading and Indexing.
Technical Skills
Expertise in Data Integration Tools: Informatica PWC, Informatica Cloud (15+),ADF
Data Integration: Datastage
Data Integration: Snowflake
Cloud Platform: AWS, Azure
Expertise in Relational Databases: Teradata (8), Oracle, MySQL, MS SQL Server
Expertise in Languages: SQL (15+), PL/SQL, Expertise in Unix Scripting, SAS,