Rameshkumar Kannan

Responsibilities:  Responsible for the Architecture, Technical Analysis, Design, Development, Testing, deployment and Administration of data warehouse using Informatica Platform, Control-M and GoAnywhere.  Installation and configuration of Informatica PowerCenter products

Deputed at Equinix Inc, USA  Design and automated ETL Routine using PL/SQL and UNIX shell scripting.  Involved in requirement gathering and functional documentations.  Documented Technical high level design and low level design.  Involved in the design and code review of ETL components and Reconciliation process at a project level

 Design RFDW Data sourcing layer orchestration and design EOD control table structures.  Capacity planning and infrastructure estimation for batch processing.  Work with DSL delivery manager and tech leads to layout EOD implementation tasks and schedule.  Redesign and develop Informatica mappings.  Develop UNIX shell script for orchestration.

 Responsible for the compiling the detailed definition of requirements with help of business analysts.  Involved in designing conceptual logical modeling and physical modeling.  Prepare ETL framework and standards, best practices.  Design and develop ETL processes and prepare reposting layer definitions.  Load optimization, performance improvements  Release managements and source code control.

 Requirement analysis, Design and development.  Designed and developed Informatica Mappings and Sessions.  Identifying performance bottlenecks and turning  Identify and develop reusable transformations, and mapplets.  Created shell scripts for automation.

 POC with informatica to understand the data lineage feasibility and showcase to internal customers.  Worked with enterprise architects to create the metadata presentation layer.  Gather user requirements and preparing high level technical design and low level documents for development.  Design and develop xconnects to connect tool repositories for extracting metadata. .

Deputed at Deutsche Bank

Technical consultant for various projects for Charles Schwab Investments, San Francisco, USA, Putnam Investments, USA.

Electrical and Electronics Engineering