Summary
Overview
Work History
Education
Skills
Personal Information
Projects
Timeline
Generic

Varaprasad Srirambhatla

Summary

Highly technical and competent individual with Twenty Plus years of experience in Data Engineering, System Analysis, Architect, Design, Development, Administration, Implementation, Testing, Production Support and Maintenance of Data Warehouse Business Applications on LINUX, AIX , Windows and AWS cloud platforms Data Warehousing Experience with Architect, Designing, Programming, Administration and Supporting Skills. Excellent experience with ETL (Extract, Transform and Loading) Tools like Informatica Power Center,Informatica Developer Tool,Informatica Cloud,Informatica Data Profiling,Informatica Data Quality and Enterprise Data Catalog ,Axon Governance etc. Data Warehousing Experience with AWS Cloud Services of AWS Glue, EMR,Lambda,Step Functions , Event Bridge , Cloud watch logs ,Athena ,Kinesis Stream and Amazon Redshift. Data Lake experience with Hadoop Big data technologies on HortonWorks and Cloudera platforms. Superior Communication skills, inter personal skills and Proven ability to perform both as an individual & as a Lead. Practical database engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. Offering several-year background managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.

Overview

21
21
years of professional experience

Work History

Data Engineer Lead/Admin/Architect

American Honda Motor Co
Los Angeles, CA
04.2005 - Current
  • Journey at Honda initiated as Senior ETL Developer to build Enterprise Data Warehouse: (CoreMQ & SOCRATES(Finance Division)) Used Informatica PWC tools, PWX,LUW db2, Unix Shell Scripting for populating the warehouse
  • 2008 Onwards: Informatica Admin responsibility .Assigned primarily to administer Upgrades and admin specific activities
  • Have done so far 10-12 Upgrades on the PWC side
  • 2012 Onwards: Informatica IICS product was required for Salesforce Integration
  • Completed POC and initiated the Design, Development,Implementation and Administration
  • 2013 Onwards: For future Data warehouse needs and Big Data technology was needed
  • Involved in POC of Big Data Informatica tools and initiated the Design, Development,Implementation and Administration
  • Have done 4 Major Upgrades of Big Data Platform
  • 2021 Onwards: Honda focused on building Data Warehouse on AWS Cloud Platform
  • Involved in POC of AWS Cloud Services and Implemented with vendor partnership
  • And currently supporting as admin/governance role for AWS warehouse along with Administrator responsibilities
  • Have Done 10 Major Upgrades of IICS platform 2023 Onwards: Initiated POC on Informatica Cloud Data Governance and Catalog tool which includes of Metadata Management,Data Profiling, Data Quality,Data marketplace, Data Governance and Catalog.
  • Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
  • Optimized existing queries to improve query performance by creating indexes on tables.
  • Developed and implemented data models, database designs, data access and table maintenance codes.
  • Developed Python scripts for extracting data from web services API's and loading into databases.
  • Created stored procedures for automating periodic tasks in SQL Server.
  • Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.

ETL Developer/ Administrator

Liberty Mutual
Indianapolis, IN
02.2004 - 03.2005
  • Analyzed, designed, and developed ETL processes with PowerCenter to fulfill user expectations.
  • Implemented Unix shell scripting for ETL jobs.
  • Enhanced efficiency of ETL processes by optimizing performance

ETL Administrator/ Developer

Lucent Technologies
Murray Hill, NJ
08.2003 - 01.2004
  • Managed deployment of software from development to quality assurance to production environments.
  • Managed ETL administration tasks, ensuring smooth data extraction, transformation, and loading processes

Education

Bachelor of technology in Electrical & Electronics -

Skills

  • Informatica PWC Administration
  • Data Catalog & Data Governance
  • Informatica PWC Development
  • Data Lakes & Data Warehousing
  • Informatica Cloud Administration
  • Big Data
  • ETL Design & Implementation
  • Informatica Cloud Development
  • Informatica EDC Tools
  • Informatica Data Engineering Administration
  • AWS Cloud ETL Design & Implementation
  • Informatica Data Engineering Development
  • Informatica Cloud Data Governance Catalog
  • GitHub
  • CI/CD pipelines
  • Sox Compliance
  • Kerberos Setup
  • Salesforce
  • All BI tools
  • Service Now
  • Cyberark
  • Hadoop Ecosystem
  • Spark Framework
  • Big Data Processing
  • Data Pipeline Design
  • Data Warehousing
  • Scripting Languages
  • SQL and Databases
  • Relational databases
  • Big data technologies
  • Continuous Improvement
  • Data Analysis
  • Performance Tuning
  • Metadata Management
  • Time management abilities
  • Requirements Gathering
  • Data Acquisitions
  • Technical Support
  • Effective Communication
  • Excellent Communication
  • Interpersonal Skills
  • Problem-Solving
  • Organizational Skills
  • Architecture planning
  • Interpersonal Communication
  • Data Analytics
  • Professionalism
  • Active Listening
  • Team building
  • Teamwork and Collaboration

Personal Information

Title: Data Engineer Lead/Admin/Architect

Projects

American Honda Motor Co, Los Angeles, CA, 04/05/05, Current, Data Engineer Lead/Admin/ETL Architect, (2005-2008): Journey at Honda initiated as Senior ETL Developer to build Enterprise Data Warehouse: (CoreMQ & SOCRATES(Finance Division)) Used Informatica PWC tools, PWX,LUW db2, Unix Shell Scripting for populating the warehouse. 2008 Onwards: Informatica Admin responsibility .Assigned primarily to administer Upgrades and admin specific activities. Have done so far 10-12 Upgrades on the PWC side. 2012 Onwards: Informatica IICS product was required for Salesforce Integration. Completed POC and initiated the Design, Development,Implementation and Administration. 2013 Onwards: For future Data warehouse needs and Big Data technology was needed. Involved in POC of Big Data Informatica tools and initiated the Design, Development,Implementation and Administration. Have done 4 Major Upgrades of Big Data Platform. 2021 Onwards: Honda focused on building Data Warehouse on AWS Cloud Platform. Involved in POC of AWS Cloud Services and Implemented with vendor partnership. and currently supporting as admin/governance role for AWS warehouse along with Administrator responsibilities. Have Done 10 Major Upgrades of IICS platform 2023 Onwards: Initiated POC on Informatica Cloud Data Governance and Catalog tool which includes of Metadata Management,Data Profiling, Data Quality,Data marketplace, Data Governance and Catalog. Liberty Mutual, Indianapolis, IN, 02/04/04, 03/05/05, ETL Developer/ Administrator Lucent Technologies, Murray Hill, NJ, 08/03/03, 01/04/04, ETL Administrator/ Developer

Timeline

Data Engineer Lead/Admin/Architect

American Honda Motor Co
04.2005 - Current

ETL Developer/ Administrator

Liberty Mutual
02.2004 - 03.2005

ETL Administrator/ Developer

Lucent Technologies
08.2003 - 01.2004

Bachelor of technology in Electrical & Electronics -

Varaprasad Srirambhatla