Sign in

Data Integration Architect Lead

Pleasanton, California, United States
August 09, 2018

Contact this candidate


Ramesh Kuppusamy

Pleasanton, CA 925-***-****

Diverse IT experience in designing, implementing and managing complex Enterprise Data Warehouse (EDW) and Online Transactional Processing (OLTP) systems for Banking, Finance, Retail and E-Commerce Businesses namely Bank of West, SONY Corporation, Sybase (SAP) etc.

Built and managed a large integration team responsible for ETL Tools, ETL Tool based processes for EDW and OLTP, Data Modeling, building Operational Data Stores (ODS) using Star, Snowflake Schemas

Played Integration Lead/Architect for many critical Banking data systems/Applications and part of the core Enterprise architecture council team

Strong Banking Domain Experience in implementing regulatory compliance such as KLIMT Reporting, EU & US LCR Submission, Liquidity Coverage Ratio (LCR), CCAR and FR 2052a (5G Reporting).

Built CRM (Sales & Marketing) and Finance functions, Data Mart for SONY Retail

Proven ability to manage multiple projects simultaneously and able to navigate through complex and changing business requirements with effective customer communications.

Part of the POC team to explore the migration of On-premise to AWS Cloud exploration project.

Responsible for diversified DevOps team to build Banking products for handling Deposits, Loans, Securities using Agile with a global team of Onsite (US) and Offshore (India) teams

Certified Scrum Master with Strong leadership and hands-on experience in managing cross functional teams of business process owners, stakeholders to understand requirements and manage IT Solutions


Core Competencies

Technical Skills









•Project Management

•Cross Functional Team Management

•Team building, Organizational skills

•Requirement gathering

•Process improvement

•Sourcing, Roadmap Development

•Advance Problem solving

•Technical Documentation

•Data warehousing, Big data, MDM

•Business Intelligence, Analytics

•Dev Ops

•AWS Cloud Migration

•Data Integration, Data Migration

•Informatica, AWS, EC2, RDS, S3, API Gateway, Data pipeline, Lambda, Salesforce


Client / Location

Project / Responsibilities

Role / Duration

Bank of West

San Ramon, CA

EDW – Enterprise Data Warehouse

Financial Data Mart EDW Transition

DevOps – Global Team Management

Bank Regulatory Compliance

Asset & Liability Mgmt. – Treasury

Data Integration Architect Lead

October 2013 - June 2018

SONY Corporation

Foster City, CA

CRM DataMart Development

PlayStation Network: Core Finance Functions – Development

Lead ETL Developer

August 2011 – October 2013

Sybase SAP

Dublin, CA

ETL Development

Performance Tuning

Staff Software Engineer

Jan 2000 – Aug 2011

BANK OF THE WEST, San Ramon, CA October 2013 – June 2018

Role: Data Integration Architect Lead

•Asset & Liability Management – Treasury: Led the project in design, development & Integration phases for Deposits, Loans, securities and secured funding by work with multiple cross functional teams that includes BSA, QA, DBA’s, prod ops and business teams. Successfully Implemented project for Liquidity Coverage Ratio (LCR) using Informatica power center 10.1/9.5, Oracle 11.0, UNIX shell scripting.

•Created dimensional model for the reporting systems by identifying required dimensions and facts using Erwin

Mass Affluent & Wealth Management :Designed, developed, integrated and implemented Mass Affluent / Wealth Management project used for marketing campaign using Informatica Power Centre 9.1, Oracle 11.0 & Unix scripting and successfully integrated in production as planned

•Risk Management : Independently designed and Integrated for Risk Management dual grading incoming feeds using Informatica power center 9.5, oracle 11.0 & Unix scripting and successfully implemented

•IT Transformation: Transitioned numerous Finance Data Mart (FDM) to Enterprise Data warehouse (EDW) – successfully completed this initiative within a year and brought huge cost savings

•Involved in Design and implementation solutions for data integration for eCRM and MDM projects and successfully integrated.

•Dev Ops Team Management: Implemented optimal Dev Ops ticketing process for Line of Business (LOB) & Intermediate Holding Company (IHC) products including enhancements and small projects. Metrics: On an average, closed 20 tickets per sprint and 20 small projects per year. Manage, coach and mentor Onshore and offshore teams across three different teams LOB, IHC & Data Quality

•Managed BIDM Operations: Responsible for smooth IT operations for a 25 member team by collaborating with Technology, Business, Shared Service Solution Division Head, Onshore & Offshore teams

SONY COMPUTER ENTERTAINMENT OF AMERICA, San Mateo, CA August 2011 – October 2013

Role: Lead ETL Developer


•Was extensively involved in design, development, testing and integrated for CRM Monocle data mart using Informatica Power Centre 9.1/8.5 which is used for email campaigns and other behavioral analysis for PlayStation consumers. Successfully implemented in production.

•Was extensively involved in developing ETL mappings for retail processes like Sell-in (products sold to retailer) and Sell-thru (products sold to consumers).Business is successfully using this Key Performance indicator (KPI) report on daily, monthly, quarterly and yearly basis.

•Provide regular digital reporting and analysis relating to performance and variance to monthly/quarterly targets on Sony Play station retail and online games, as well as trending performance and year over year comparisons

•Extensively involved in design, development and maintenance of ETL mappings on a financial DataMart for PlayStation Network using Informatica Power Centre 9.1, Oracle 10g, UNIX scripting and successfully implemented.

•Developed a Conceptual model for Data Warehouse using Erwin based on requirements analysis

SYBASE SAP, Dublin, CA January 2000 – August 2011

Role: Staff Software Engineer


Involved in requirement gatherings from business users, analyzed them and write technical specifications to design ETL processes.

Developed and enhanced ETL jobs to facilitate daily and monthly loading of data based on functional design for various systems which includes Application Registry Management system, License Management systems, Quality Management system and Hardware management systems

Developed Informatica mappings with transformations like lookup, router, expression, update strategy and joiner.

Performance tuning of mappings, transformations and sessions to optimize session performance.

Automation of Informatica Workflows using Shell Scripts and Schedulers.

Bug logging and tracking them to closure using Quality tracking system.

Responsible for the functional testing of ASE database 12.x and 15.x.

Point-in contact in doing HA certification for Sybase versions 12.x, 15.x for numerous operating Systems like., MS Windows 2000, Sun Solaris, IBM & HP Unix


BS, Engineering, Madras University, India

Certified Scrum Master (CSM)

Contact this candidate