Umakanth Reddy Rondla

Experience

• 

  Macy's

  Apr 2008 - May 2010

  ETL Developer
• 

  IMS Health

  Jun 2010 - Nov 2010

  Sr.ETL Developer
• 

  NetApp

  Dec 2010 - Jun 2011

  Sr.ETL Developer

  *Worked on Building the Hierarchy systems to support the NetApp HR Reporting systems.The Real challenges faced when the Intern converted to Employee or Employee changes there positions in the organization to another Reporting manager , handling the hierarchy changes in the system.

• 

  Novartis, Australia & New Zealand

  Jul 2011 - Oct 2012

  Sr.ETL Developer
• 

  Inovalon

  Nov 2012 - May 2013

  Sr.ETL Developer
• 

  Freddie Mac

  Jun 2013 - Apr 2014

  Sr.ETL Developer
• 

  Booz Allen Hamilton

  Apr 2014 - Sept 2014

  Sr.ETL Developer

  The Goal of the Project is to migrate from Legacy system to the new EDW to support the Internal and external reporting needs. The project involved with the migration of new ETL Tool and Data warehouse. * The Legacy system has Multiple interfaces (32 Interfaces) with other systems for Daily and monthly feeds.The migration has several challenges while moving to the Legacy system to EDW.i.e Data validation from Legacy system to EDW,Defining the dependency check based on the several triggers and systems availability.Identifying the number of interfaces and retiring the un used Applications from the Legacy system.Coordinating with the multiple teams to explain the accuracy of data from the new system.Repointing the ETL to the EDW and building the new ETL from the EDW to Interfaces. Show less

• 

  Dealertrack

  Oct 2014 - now

  Tech Lead