Venkatagowtham C

About Venkatagowtham C

Project Lead/ Senior ETL Architect in the Cognizant Technology Solutions US Corp. A Data warehouse Process and Project Lead having 17+ years of work experience on leading, designing, delivering robust, scalable, and highly available Data warehouse and Data Integration solutions. Experienced in project management, serving as client\'s point of contact for Executive system reporting, project status reporting and issue resolution among other responsibilities. After analyzing the business needs. Mentored and lead teams to completion of projects. Have proven experience in System analysis, design, development, Data Warehouse/Data Mart design, RDBMS and implementation of client server applications in SDLC and Agile methodology. Technical hands-on experience in development of Data warehousing solutions using Ralph Kimball/Bill Inmon methods with the help of, Informatica BDM,Power Center 10.x,9.x/8.x, Oracle SQL/PLSQL,Hadoop,Hive,Sqoop, InformaticaDataQuality9.6 and UNIX Shell/Perl Scripts with clear understanding of ER modeling for OLTP and dimension modeling for OLAP.Specialized in mentoring and building high caliber teams, develop both onsite and off-shore capabilities; retaining and developing top-notch talent to deliver challenging projects on-budget and on-time. Also have strong technical architecture capabilities for defining and assessing the system architecture and migration of legacy system architectures to emerging technologies.Possess excellent analysis, implementation and teamwork skills.Prior to joining Cognizant Technologies,I was a Software Engineer at iSOFT (A CSC Company), within their Data Migration practice where my responsibilities Responsible for designing a reusable framework for performing data migration of different hospital trusts’ (under National Helath Services) data from their current ePM to Lorenzo Regional Care product built by CSC for them. Designed and Developed data warehouses/data marts for select hospital trusts under NHS on demand.

Experience

1. Senior Etl Developer Lead Project Manager

   Cognizant

   Sep 2010 — Present · Chennai, IN

   Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.•Extensive experience in developing Informatica complex mappings and transformations.•Planed, coordinated and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure which helped in 100% data security.•Performed major role in understanding the business requirements and in designing the Health Insurance Application Architecture to build a data warehouse.•Extensively used oracle stored procedures, indexes and partitioning options to increase the performance of the database by 30-40%

Education

• Jawaharlal Nehru Technological University

  Bachelor's degree

  2003 — 2007

Skills

• Unix
• Squoop
• Perl
• Tableau
• Sql
• Data Warehousing
• Microsoft Office
• Training
• Testing
• Informatica Big Data Management
• Microsoft Sql Server
• Business Objects Data Integrator
• Informatica
• Hdfs 2.7.1
• Extract, Transform, Load (Etl)
• Data Transformation Services (Dts)
• Business Analysis
• Oracle
• Requirements Analysis
• Software Project Management
• Requirements Gathering
• Bmc Remedy
• Agile Methodologies
• Toad
• Management
• Project Management
• Oracle Sql Developer
• Hive 1.2.1
• Systems Analysis
• Sql Server Reporting Services (Ssrs)
• Powerpoint
• Microsoft Excel
• Ambari
• Software Development Life Cycle (Sdlc)
• Leadership
• Business Intelligence
• Alm
• Hadoop,Hive,Squoop,Jira
• Jira
• Pl/Sql