acpl1w@r.postjobfree.com

*** * ****** ** 770-***-****

Gopal Ramanathan

Madison, WI 53703

Gopal Ramanathan

Experience Summary

Seasoned DW and ETL Architect, Designer and Developer with 10 years of work experience in IT industry with vast

exposure in design and development of Data Warehouse on Relational (Oracle and Teradata) databases. Effectively

involved in various phases of Data warehousing projects that include Requirements Gathering, Analysis, Design,

Development, Testing in Oracle and Teradata Technology and Informatica ETL tool with good understanding in Retail

and Financial services industry. Strong analytical skills combined with good experience in ETL process in Data

Warehousing lifecycle with good inter-personal, written and oral communication skills.

• Experience in leading and managing teams. Handled multiple roles including Data Architect, Team Lead,

Onsite coordinator, Informatica Developer.

• Expert in Database and ETL Architecture using Oracle/Teradata/Informatica/Unix.

• Worked in Retail Markets, Mortgage Banking and Credit Card domain.

• Key member in setting Informatica standards and best practices for the project.

• Good knowledge of Real Time Data Integration with Informatica MQ.

• Designed and Conducted Informatica and Oracle training sessions and mentored peers.

• Proficient in analyzing and translating business requirements to technical requirements and architecture.

Education

Bachelor of Technology in Electronics Engineering from Anna University (MIT Campus) in 2005.

Certification and Awards

Oracle Certified Associate (OCA) in Database Administration.

Teradata Certified Associate.

Informatica Certified in Informatica 8 Mapping design.

Brainbench Certified in SQL.

Brainbench Certified in Interpersonal Communication.

Trained in ETL Tools - Ab Initio and SSIS

Trained in Reporting Tools – SAS, SPSS and SSRS

Technical Skills

ETL Tools Informatica

Operating Systems WINDOWS, Sun Solaris7.0/8.0, Linux 5.x

Databases and Tools Teradata, Oracle 9i/10g/11g, PL/SQL, Netezza, Callidus TrueComp

Programming SQL, PL/SQL, Visual Basic 6.0, C, VB.NET, Unix

Languages

Other Utilities MS Visio, TOAD, SQL Navigator, Aqua, SQL Developer, Heat, Tidal Scheduler, Marval,

SCM Surround, Microsoft VSS, Quality Centre, Test Track Pro, Jira, Peregrine, Sub

version, Control M, Amazon AWS, Amazon Brazil/Apollo, ScrumWorks

Relevant Project Experience

Amazon Shopbop DW Integration (Shopbop - Madison, WI, US)

Duration March 2014– Till Date

Technology Informatica PowerCenter 9.1.0/9.6.0, Oracle 11g, Unix, Amazon Linux, Amazon AWS – S3, EC2

Page 1 of 8

Dated: May, 2015

acpl1w@r.postjobfree.com

738 E Dayton St 770-***-****

Gopal Ramanathan

Madison, WI 53703

Shopbop, an Amazon.com company is an online powerhouse of contemporary fashion

Project Abstract

and a Madison-based retailer of designer clothing and accessories for women.

Shopbop’s Datawarehouse has a size of over 16 TB and the infrastructure is

maintained and supported by a third party vendor. This has to be integrated into

Amazon. And as part of integration into Amazon, all Amazon standards have to be

enforced in terms of data volume, retention, security and performance.

The key activities in this project will include the reengineering of existing

datawarehouse to be more robust and efficient, with appropriate data retention in

different layers of the warehouse, adding appropriate indexes for better performance,

partitioning the schema/tables wherever needed indexes and Data security

implementing Amazon's UCI/PII policies and then migrating all data and code base into

Amazon Infrastructure.

In addition to integration into Amazon, this also involves projects that are highly

revenue yielding that includes the marketing and sales of products thru different

affiliate networks across the world with Impact Radius.

Role Review Architecture of the existing Shopbop Data warehouse and ETL

Datawarehouse

architecture and provide feedback on design improvements and best practices.

Architect

Create document templates and standards for Design, Technical Spec,

Implementation and Test Plan and enforce the standards to all team members.

Strategize Infrastructure and Data migration into Amazon with maintaining all

standards

Design and Develop Data Retention processes

Design the Architectural diagram for Amazon Infrastructure for Shopbop DW

and BI and the data flow processes.

Install and Setup Amazon Servers.

Designed and Developed code base to export the entire Database from Third

Party Vendor, Upload to Amazon Cloud (S3), Download to Amazon server and

Import into Amazon DB.

Analyze the requirements, Architect, Design, Prepare/Review Technical

Specification Document, Development, Code review and Unit Testing of the

process

Develop and Enhance the existing code base to be more generic and scalable.

Design mappings, sessions and workflows for the data load process using

Informatica, Oracle and Unix.

Provide solution and work with all teams for the data load management for the

entire Shopbop

Build and enhance the operational model for all online affiliate networks and all

Page 2 of 8

Dated: May, 2015

acpl1w@r.postjobfree.com

738 E Dayton St 770-***-****

Gopal Ramanathan

Madison, WI 53703

programs for those networks.

Responsible for upgrading Informatica from 9.1.0 to 9.6.0

Analyzed Clickstream data load and usage. And introduced better model

including the restructure of tables along with partitioning, indexes.

Worked on Data retention policy and archival/purge of all Clickstream tables

that reduced the total DB size from 16 TB to 7 TB.

Analyze slow performing jobs and provide solution for improvement – In both

DB and ETL.

JPMC ICDW Framework and Common Components (JPMorgan Chase - Columbus, OH, US)

Duration April 2012– February 2014

Technology Informatica PowerCenter 9.1, Teradata, Unix, Control M

ICDW (Integrated Consumer Data Warehouse) is an initiative in JPMC's Retail

Project Abstract

Financial Services division to move away from the existing technology landscape and

its inherent pain areas of an outdated infrastructure's performance, inability to support

time-to-market, scalability and lack of support for cross-lob analytical needs. ICDW

Development and Support involves the integration of various Lines of Business (LOB)

data into the ICDW framework that will be hosted on a new, faster, scalable platform

and a data model that will support cross-LOB analytical requirements.

The key controls that make up the project will include building of Enterprise Integration

model based on IBM's BDW, Scalable and efficient solutions architecture using the

appliance based Teradata platform and Informatica 9.1 ETL infrastructure, Robust

analytics layer using SAS, Reports and dashboards using Cognos, and Data security

implementing JPMC's PII policies and procedures using Teradata semantic views.

Role Lead the central common components team for ICDW

Architect and

Provide consulting and present the reference Architecture for all new LOBs

Team Lead

coming into ICDW

Review Design of Data, ETL and BI architecture for all teams and provide

feedback on design improvements and best practices and approval

Analyze the requirements and providing a feasibility report for each common

requirement

Architect, Design, Prepare/Review Technical Specification Document,

Development, Code review and Unit Testing of common component process

Develop and Enhance the Audit Model and Common Components for the

entire ICDW

Design, build and maintain mappings, sessions and workflows for the ICDW

data load process using Informatica, Teradata and Unix

Design and Schedule all the data load processes using Control M.

Page 3 of 8

Dated: May, 2015

acpl1w@r.postjobfree.com

738 E Dayton St 770-***-****

Gopal Ramanathan

Madison, WI 53703

Proposed the Real Time reference Architecture for ICDW using Informatica MQ

Provided solution and worked with all teams for the data load management for

the entire ICDW platform

Enhanced the performance of overall ETL load with different Teradata TPT

utilities – Fastload, Multiload and Tpump

Enhanced all generic UNIX scripts to accomplish Query Banding in Teradata

for all SQLs, which helped in the analysis and improvement of complex, time

consuming and resource consuming queries

CHL Incentive Management (JPMorgan Chase - NJ, US)

Duration January 2010 – March 2012

Technology Informatica PowerCenter 9.1, Informatica PowerCenter 8.6.1/9.0, Oracle 10g/11 PL/SQL, Unix,

True Comp

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with

Project Abstract

assets of $2.1 trillion and operations in more than 60 countries. The firm is a leader in

investment banking, financial services for consumers, small business and commercial

banking, financial transaction processing, asset management, and private equity. A

component of the Dow Jones Industrial Average, JPMorgan Chase serves millions of

consumers in the United States and many of the world’s most prominent corporate,

institutional and government clients under its J.P. Morgan, Chase and WaMu brands.

JPMorgan Chase & Co., a financial holding company, provides a range of financial

services worldwide. It operates in six segments: Investment Bank, Commercial

Banking, Treasury & Securities Services, Asset Management, Retail Financial

Services, and Card Services.

JPMorgan Chase & Co. was founded in 1823 and is headquartered in New York, New

York and today has more than 200,000 employees.

CHL Incentive Management project is one of critical projects for JP Morgan Chase &

Co. The project involves use of specialized tools for calculation of incentives for their

Home Lending department. Home Lending division uses Callidus TrueComp, a

specialized Incentive Compensation Management tool, to calculate incentives for all

sales associates, managers and other associated parties in the sales channel involved

in selling of various mortgage and home equity products offered by the bank.

Four key teams, Rewards Management, Data Integration, Configuration and Reporting,

collaborate with each other for accurate payments of incentives. The project is one of

the mission critical projects for JP Morgan Chase and Co as the incentives calculated

are part of the payroll of the employees. The incentives need to be generated

accurately and send to the finance department well in time so that the incentive

amounts can be included in the pay check generated 1st and 15th of every month.

Interim incentive statements are generated before pay file is sent to finance

departments for employees to review their incentive and report any miss outs or

discrepancies. These discrepancies need to be corrected before the final pay file is

reported to finance team. All these process are part of the project and are time critical

in order to generate pay file in time with accurate incentive amounts to be paid to the

employee as part of the semimonthly pay check.

Page 4 of 8

Dated: May, 2015

acpl1w@r.postjobfree.com

738 E Dayton St 770-***-****

Gopal Ramanathan

Madison, WI 53703

Data Integration team sources, transforms and loads Payee and Hierarchy data, Sales

transactions and other data elements from multiple source systems to the Callidus

TrueComp incentive tool

Role Key player of Data Integration Team.

Team Lead

Play the role of Designer, Senior Developer and Onsite Coordinator.

Handle the incentive systems for JP Morgan Chase and Co. Home Lending

department to ensure accurate and timely calculation of incentives that can be

paid to the employees as part of the semimonthly/Monthly payroll.

Responsible for analyzing the business requirements and providing a feasibility

report for each requirement.

Responsible for providing estimates to the client for implementation of the

business requirements.

Responsible for understanding requirements from business and also ensure

that the offshore team members also understand the requirement correctly

Responsible for Design, Technical Specification Document preparation,

Development, Code review and Unit Testing of the process

Design, build and maintain mappings, sessions and workflows for the

TrueComp data load process using Informatica, PL/SQL and Unix.

Prepare test data, support SIT and UAT and resolve the defects.

Responsible for production support of the Data load processes, Issue Analysis,

Root Cause Evaluation, Issues Resolution and Closure

Feebase (CompuCredit – Atlanta, US)

Duration December 2006 – December 2009

Technology Informatica PowerCenter 7.2.1, Oracle 10g PL/SQL, Netezza, Unix

Project Abstract The Fee Based marketing Department offers ancillary products to CompuCredit’s credit

card customers. A variety of insurance and membership products are sold at credit

card acquisition, card activation, and to existing card holders. The marketing channels

on which products are sold include IVR, on-line services, outbound telemarketing, and

customer service cross-sell. All aspects of the product development life cycle are

supported starting from product set up, pitching, and sales to product fulfillment and

billing.

The major development Projects related to Feebase were

FDR to TSYS Conversion

Gathered the requirements and designed the module to transfer the SOR for all the

accounts in BankFirst portfolio from FDR to TSYS and changing it to private label

accounts. This included booking new accounts at TSYS, transferring the balances to

TSYS, set up the insurance on accounts and changing the vendor process

requirements, holding payments during the migration and send down the held

Page 5 of 8

Dated: May, 2015

acpl1w@r.postjobfree.com

738 E Dayton St 770-***-****

Gopal Ramanathan

Madison, WI 53703

payments after migration.

Private Label Conversion

This was an important corporate initiative to transfer the accounts from banks like

Columbia Bank and Trust (CB&T), First Bank of Delaware (FBoD) etc to closed

accounts with the private label. The bin numbers were changed and so as the account

numbers for these accounts. We transferred the products to the new accounts,

matched up the accounts in all aspects successfully.

Oracle 10G migration of FBDD

Migrated the Feebase database from unsupported 8i to more robust 10g environment.

Redesigned core processes and added data source management and error handling

modules to the overall system. This provided 60% performance improvements in

almost all the processes reducing the overheads in loads, simplified trouble shooting

and maintenance.

Integration of all Feebase channels

Integrated all the Feebase channels to use the centralized, reusable code package to

market the products thereby removing the duplicate enrollment and improved customer

experience. This resulted in increased sales and revenue and less code support.

Feebase Nightly Enhancements

Re-engineered the Feebase processes which loaded the master files and acquisition

product sales. Removed obsolete file loads and enhanced the load process for the

Master file loads from PL/SQL to Informatica, accomplishing a significant 85%

improvement in the overall Feebase loads.

Role Single point of contact for the client in Feebase related activities.

Onsite Team

Play the role of Technical lead, Designer, Developer, Onsite offshore

Lead

coordinator and Analyst

Coordinate the entire SDLC for each project in Feebase.

Interact with various groups in CompuCredit to ensure the proper and timely

implementation of production processes.

Integrate/Coordinate with different teams to gather and understand the precise

requirements regarding the system, data load process and source data

validation for each project.

Preparation of the Requirements document/Work Request document.

Preparation of time estimates for the completion of each project including

estimation of the various resources required for the project/work request.

Responsible for Design, Technical Specification Document preparation,

Development, Code review and Unit Testing of the process.

Test data preparation, UAT Support and track the defects to Closure.

Preparation of Implementation Plan Document and creation of RFCs, providing

suggestion to the business for process improvement.

Support for production Implementation, Validation of the production data to

ensure that the data load has no discrepancy.

Page 6 of 8

Dated: May, 2015

acpl1w@r.postjobfree.com

738 E Dayton St 770-***-****

Gopal Ramanathan

Madison, WI 53703

Tracking the effort spent, and the issues encountered during each of the

different phases of the project.

Production support for all the Feebase processes.

Responsible for Issue Analysis, Root Cause Evaluation, Issues Resolution and

Closure.

Application Value Maintenance (CompuCredit - Atlanta, US)

Duration October 2006 – November 2006

Technology Informatica PowerCenter 6.2.1, Oracle 9i PL/SQL, TOAD, SQL Navigator

Project Abstract CompuCredit Datastore has master file and transaction loads for different portfolios like Aspire,

PVN and BOA from TSYS and BankFirst from FDR. All these have SLAs to be met so that the

business can use the data appropriately. The master file load processes are crucial to the business

units because no revenue generating activities can take place until these loads complete

successfully.

These existing processes need support, bug fixes and enhancements so that SLA’s

can be met consistently and also the project overheads for CompuCredit can be

reduced.

Role Involved in carrying out major enhancements and bug fix in the various

processes, developed PL/SQL scripts, modified and tested the PL/SQL

packages and debugging process of the queries.

Involved in creating/modifying Informatica jobs to enhance the processes.

Tracked and developed a permanent fix for recurring issues.

Monitored the health of the system and tuned the jobs for optimal performance.

Tracked the enhancements/fixes in the processes using Cognizant quality tools

like Prolite and eTracker.

Responsible for consolidating the weekly and monthly changes and issues.

Tier II Production Support (CompuCredit - Atlanta, US)

Duration June 2005 - September 2006

Technology Oracle 9i PL/SQL, Informatica PowerCenter 6.2.1, Visual Basic 6.0, Tidal Scheduler,

HEAT

Project Abstract CompuCredit Tier II production support module provided off hours Tier II support for

CompuCredit applications that run from 9 PM to 9 AM EST Monday through Sunday.

The jobs in CompuCredit are scheduled in a Tidal Scheduler and when a job failed in

production, the client need not wait until the next day to resolve any issues. Tier II

production support provided the reason and resolution for the failure within 30 minutes.

It involved production monitoring, immediate responses and resolutions for production

Page 7 of 8

Dated: May, 2015

acpl1w@r.postjobfree.com

738 E Dayton St 770-***-****

Gopal Ramanathan

Madison, WI 53703

issues. Root cause analysis for the frequently occurring issues was also done. There

were more than 3000 jobs running in CompuCredit’s production environment. Loads up

to 1 TB records were monitored.

Meeting the SLAs for certain applications were critical as it might result in revenue loss

for CompuCredit. Tier II Support Group had been playing a vital part in providing SLA

compliance by achieving 24x7 support using onsite-offshore model. Tier II Support also

provided appropriate metrics to the client that was analyzed and areas of

improvements were identified. Tier II boasts 85% issue closure rate without

reassignment to the next level. Tier II also developed a value add tool – Issue Tracking

System. Using this system the user could easily find out the frequency of the issues

and hence work on giving a permanent fix to such issues thus increasing productivity

and the quality of the deliverables.

Role Involved in Operational Model and Knowledge Transition Plan for Tier II

Support.

Analyzed the Tidal jobs and identified the best technical solutions for complex

technical issues.

Resolved the Tier II production issues with a quick turnaround time.

Documented the daily issues with their resolutions.

Permanently resolving issues that occurred frequently in recent past by doing a

thorough root cause analysis.

Responsible for preparing Weekly Status Reports, collecting Metrics and

sharing it across on-site.

Responsible for design and development of a value add tool – Issue Tracking

System – CompuCredit’s Knowledge Base coded in Visual Basic and Oracle,

to capture all the issues and store them in a database to help solve issues with

a faster turnaround time in future.

Involved in successful delivery of the tool Issue Tracking System which has

been successfully implemented and moved to production.

Played an active part in production support activities.

Page 8 of 8

Dated: May, 2015

Contact this candidate