Project Sales
Resume:
********@*****.***
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
********@*****.***
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
********@*****.***
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
********@*****.***
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
********@*****.***
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
********@*****.***
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
********@*****.***
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
********@*****.***
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