Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Piyush Dawani

South Windsor

Summary

Lead Data Engineer with extensive experience at Fresenius Medical Care, focusing on cloud solutions and data integration. Proficient in AWS and ETL development, optimizing resource utilization and ensuring project success through collaboration and problem-solving. Strong background in database engineering, data manipulation, and software integration. Demonstrates exceptional communication and organizational skills in fast-paced environments.

Overview

17
17
years of professional experience

Work History

Lead Data Engineer

Fresenius Medical Care
Lexington
10.2017 - 07.2025
  • Developed and implemented cloud-based solutions for clients utilizing Amazon Web Services.
  • Led cross-functional teams in systems integration projects, ensuring alignment of goals.
  • Researched new technologies for distributed application development on the Cloud platform.
  • Worked closely with DevOps engineers to automate various processes within the Cloud environment.
  • Optimized cloud resource utilization and expenditure through cost management tools.
  • Coordinated testing and validation procedures throughout the software development lifecycle.
  • Created graphs and charts detailing the results of data analysis initiatives.
  • Collaborated with team members to achieve project objectives and meet deadlines.

Solution Architect

Accenture
Boston
03.2017 - 10.2017
  • Developed an initial model for new IDQ tool by collaborating with diverse stakeholders.
  • Created resource allocation matrices and maintained change logs following project completion.
  • Set expectations by outlining update frequency, base time for refresh, and overall project flow.
  • Crafted sophisticated PL/SQL code targeting performance enhancements.
  • Worked jointly with ETL team to facilitate data extraction and loading for reporting purposes.
  • Constructed complex mappings along with a suite of reusable scripts and worklets.

Solution Architect

Accenture
Pennsylvania
03.2014 - 03.2017
  • Work with Different stake holders to develop wireframes for business users.
  • Provide estimates for 10 Dashboards project and worked on 6 of them as solution engineer.
  • Generated resource allocation matrix for all the above projects and generated variance and change log after completion of project.
  • Developed the overall flow, frequency of update and base time for refresh and set expectation before starting of project.
  • Develop Complex PL/SQL code for different performance improvement.
  • Worked with Salesforce team to developed process which will help in Capturing efficient CRM data.
  • Worked with ETL team to extract and load data in Reporting layer for BOBJ utilization.
  • Developed Data model on which both ETL load happens and provide basis of Universe.
  • Created dynamic rules in informatica which changes based on inputs from different user in CRM tool.
  • Created Dashboards which will help business to do predictive analysis and check productivity based on sales, region and accounts.
  • Worked with Support engineer in Upgrade process of Informatica (9.x to 10.x) and Teradata (14.x to 15.x).

ETL Lead

Accenture
Bangalore India
07.2012 - 03.2014
  • Conducted thorough evaluations of existing vendor systems, sharing key findings with the team.
  • Developed innovative system architecture, consulting industry experts to refine design.
  • Delivered compelling presentations of the new architecture to both onshore teams and clients.
  • Analyzed current requirements alongside existing issues, facilitating architectural improvements.
  • Authored design documentation (LLD and HLD) enabling prompt development initiation by teams.
  • Led data analyses targeting resolution of critical production issues.
  • Formulated MDM mappings while creating fuzzy rules for efficient account address processing.
  • Worked closely with onshore lead on project estimations and initial analytical tasks.

ETL Developer

Accenture
Bangalore India
11.2011 - 07.2012
  • Migrated Informatica logic into streamlined SQL queries and PL/SQL procedures.
  • Contributed to daily SCRUM meetings for status updates on progress.
  • Gained proficiency in i-Many application, developing Ell logic to reduce ETL dependencies.
  • Led knowledge transfer sessions with support team to evaluate existing architecture.
  • Adjusted code as per project architect's recommendations for improved functionality.
  • Transitioned Informatica mappings into effective PL/SQL coding solutions.
  • Developed essential database objects such as tables, views, and indexes based on requirements.
  • Applied best practices in ETL package creation, emphasizing error handling and logging.

PLSQL Developer

Accenture
Bangalore India
08.2008 - 11.2011
  • Drafted comprehensive analysis and design documentation detailing workflow creation for projects.
  • Programmed code following the specifications of design documents, particularly for report generation.
  • Established front-end triggers enabling uniform backend structures across client applications.
  • Built various database objects, including tables, views, indexes, and customized packages per requirements.
  • Resolved bugs arising from unit tests and peer reviews effectively.
  • Performed peer reviews of coding work and design documents authored by colleagues.
  • Created PL/SQL scripts to highlight budget discrepancies between projected plans and outcomes.
  • Constructed interactive dashboards facilitating real-time monitoring of project issues and resource management.

Education

Bachelor of Engineering - IT

SGISTS
Indore India
05-2008

Skills

  • Data modeling
  • ETL development
  • Amazon Web Services
  • Informatica
  • Python
  • Snowflake
  • Cost management
  • Agile methodology
  • SQL and PLSQL
  • Unix shell scripting
  • Oracle database management
  • Teradata data warehousing
  • SQL Server database management
  • Database management
  • PL/SQL programming
  • Problem solving
  • Data integration
  • ETL processes
  • Project management
  • Data warehouse design
  • ETL tool proficiency
  • Data quality management

References

References provided upon request

Timeline

Lead Data Engineer

Fresenius Medical Care
10.2017 - 07.2025

Solution Architect

Accenture
03.2017 - 10.2017

Solution Architect

Accenture
03.2014 - 03.2017

ETL Lead

Accenture
07.2012 - 03.2014

ETL Developer

Accenture
11.2011 - 07.2012

PLSQL Developer

Accenture
08.2008 - 11.2011

Bachelor of Engineering - IT

SGISTS

Similar Profiles

CREATE PROFILE
Piyush Dawani