Prateek Patel

Experience

• 

  HP

  Jul 2016 - Apr 2017

  Technical Solutions Consultant

  Primarily responsible for handling inflow of Client issues arising from HP line of products such as servers workstation and large scale data networks. Troubleshooting was done primarily through guiding level 1 engineers who were on phones directly with client and at location service engineers.

• 

  Deloitte

  May 2017 - Jun 2022

  Client -> Hillrom is an industry leader and a trusted partner to health care providers, caregivers, and patients around the world. As a part of Everest project, business critical data needs to be converted from legacy systems to SAP, offering a seamless single interface to business andretail customers.Role -> Team Lead/ Data Specialist->Identify rules & generate data quality reports for business to understand the quality of data-> Develop mappings to facilitate the migration of data from multiple source systems to SAP using IDQ.-> Involved in Data Profiling phase of the project to help business identify & define scope for various modules-> Lead developer on a Power BI POC pitched to the client as an alternative to Excel based reporting, which has been picked up for next cycle of the project.-> Responsible for generating pre/post data validation reports for master & transactional objects to validate correctness of data-> Responsible for developing ETL’s for Master objects like Customer/Vendor etc. using Informatica Data Quality.-> Responsible for developing various Excel based Macros to be used as accelerators for automating various reporting tasks. Show less As business technology analyst I mainly help clients improve their productivity and optimizing the flow of their business processes through the use of various technology tools. Client -> Medtronic is the world's largest standalone medical technology development company. Acquiring Covidien created scope for pre-conversion, data profiling and validation of legacy Covidien data spanning across multiple systems and geographies. The aim of the various CGen’s aimed at migrating the data of multiple geographies to an integrated data warehouse. Role -> Module Lead/Data Quality Specialist-> Lead the Supply Chain, Regulatory and MKE modules from offshore containing over 10 objects impacting 8 countries and 40+ sites, achieving over 99% data accuracy-> Responsible for performing Data Matching activity to identify potential duplicates at Customer, Material & Vendor level-> Identify rules & generate Data Quality reports for business to assess the quality of data-> Responsible for generating pre/post data validation reports for master & transactional objects to validate correctness of data-> Lead developer on designing various sample Power BI Dashboards for client approval as part of the POC.-> Post Approval developed object specific Interactive Power BI Dashboards to plot various KPIs.-> The skeleton, template and approach of the dashboards developed was adopted as a default for various other Power BI dashboards developed across the client projects for various teams.-> Python scripts to automate the process of DDL script generation-> Responsible for designing and build of the system without impacting the existing system and preparation /update of Functional and technical documents-> Responsible for developing various Excel based Macros to be used as accelerators for automating various reporting tasks. Show less

  • Consultant

    Sept 2020 - Jun 2022

  • Business Technology Analyst

    May 2017 - Sept 2020
• 

  PwC

  Aug 2021 - now

  Senior Associate