Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Shankar Ganesh AP

Data Engineer
Chennai,TN

Summary

SKILL SUMMARY:

A passionate and experienced Data Engineer that wants to help you transform the way your business uses the data and ensures your architectural design meets the need of everyone in your business. I have 11+ years of experience in designing and executing solutions for complex business problems using Informatica Powercenter.

Overview

11
11
years of professional experience
5
5
years of post-secondary education
3
3
Certifications

Work History

Analyst

Bank of America Continuum India
Chennai
01.2016 - Current
  • Understand the Existing Data model and enhance functionality of existing systems
  • Migrating/converting legacy systems into common Data architecture
  • Develop ETL for Data warehouse (Netezza, Oracle Exadata)
  • Extracting Data from DB2/Teradata and load it into production using Informatica/Unix and Netezza load utilities like NZload
  • Query performance Remediation and Optimization
  • Creating LLD, and Reviewing HLD, Creating Test plan and Reviewing UTC scripts
  • Creating Business Requirement Documentation
  • Document Best Practices and Methods.

Associate Projects

Incandescent Technologies Private Limited, Citibank
Chennai, India, India
11.2015 - 12.2015
  • Understand the Existing Data model and enhance functionality of existing systems
  • Develop ETL for Data warehouse (Netezza, Oracle Exadata)

Associate Projects

Cognizant Technology Solutions
Chennai, India, India
08.2010 - 10.2015
  • Understand the Existing Data model and enhance functionality of existing systems
  • Migrating/converting legacy systems into common Data architecture
  • Develop ETL for Data warehouse (DB2, Netezza UNIX) Extracting Data from mainframes and load it into production using Informatica/Unix and Netezza load utilities like NZload
  • Query performance Remediation and Optimization
  • Creating LLD, and Reviewing HLD, Creating Test plan and Reviewing UTC scripts
  • Creating Business Requirement Documentation
  • Document Best Practices and Methods.

Education

Master of Science - Information Technology

College of Engineering Guindy Campus(Anna University
Chennai
08.2005 - 05.2010

Skills

    ETL Tools: Informatica Power Center 9x, Power Exchange 9x

Database Environment: Netezza 7034, DB2 971, Teradata, Oracle 12cOperating Environments: Mainframes, UNIX, WindowsData warehouse tools: SQL and ETL Utilities for the Above DatabasesMicrosoft Office ToolsControl-M and Quality Control Tools

Certification

Teradata Associate Certification

Timeline

Analyst

Bank of America Continuum India
01.2016 - Current

Associate Projects

Incandescent Technologies Private Limited, Citibank
11.2015 - 12.2015

Associate Projects

Cognizant Technology Solutions
08.2010 - 10.2015

Master of Science - Information Technology

College of Engineering Guindy Campus(Anna University
08.2005 - 05.2010
Shankar Ganesh APData Engineer