Manager Project

Giri Kesavan

Phone: 214-***-****(M) **************@*****.***

OBJECTIVE:

To work a Sr ETL Manager/Lead/Developer/Architect in an enterprise environment utilizing my technical, analytical and leadership skills.

SUMMARY:

• Over 14 years of total Software experience as a Data Warehousing Architect, Data Modeler, Application Development Manager and Sr. ETL Developer

• Experience on cross-domain, cross-functional and cross-industry

• Over 10 years experience in Architecture, ETL Tool selection and ETL coding

• Knowledgeable in designing and constructing Meta and Master Data Management solutions

• More than 6 years experience as an ETL Lead/Manager on various DW projects/enterprise integration environments.

• 4 years of experience in Logical Data Modeling different data warehouse projects

• Familiar with Data Mining/Pattern Mining methodologies.

• Experience in dimensional data models with Star schema and Snowflake schema.

• Enterprise level experience in DW Normalized relational modeling, conformed dimension design modeling and different ERP modeling.

• Expertise in developing technology road maps, architectural blueprints while keeping up-to-date with emerging technologies, and recommends business directions based on these technologies.

• Design/develop/test experience with ETL tools like Informatica/Datastage/ODI/SAP

• Coding and testing experience with other ETL methodologies using Pro*C, Stored Procedures and Shell Scripts

• Worked on many different OLAP and OLTP environments linked to Data Integration.

• Strong knowledge in SQL, PL/SQL, T-SQL

• Hands on experience in many BI tools like Brio-Hyperion, Business Objects, Oracle Forms and SSAS.

• Over 2 years experience as DBA

• Broad Business knowledge in FIOS, Manufacturing, Group Insurance, Individual Insurance, Membership Financial

• Strong communication & Business User Interaction skills, proven ability and desire to quickly master new technologies and skills.

Experience Summary

1. JP Morgan Chase (Sr.ETL Developer/Architect/ETL Manager) Dallas, TX May 2011 to till date

Project Worked: Doc Engine

Started as a Sr ETL Developer/Architect, later became an Oracle Lead and then assumed the development responsibility of the whole group.

Doc Engine is part of the Default IT group in JPM Chase. This group deals with mortgage defaults, loan modifications and the government incentives to avoid any foreclosures. However our group’s utmost important responsibility is to generate all the documents/letters send to the customers. This includes loan modification letters, trial packages, final packages, Gov. approval packages and denial packages etc. Chase has about 15 million customers including home equity users. Since we are Chase’s end point for customer communications, there was no room for any error whatsoever.

Responsibilities

• Manage a Development team of 15 members with activities including hiring, assigning the tasks, monitoring the tasks and co ordinate with the other teams.

• Forecasting the project hours, strategy development, team building and work assignments for the entire calendar year.

• Interact with the business leaders/managers and understand the requirements and their inputs on the current systems/future projects.

• Design the metadata engine system (customer letters, documents) so that business can add and remove any fields /columns with a minimum time.

• Design metadata tables, control tables, transaction tables for the new project (DOC Engine Project)

• Redesign the existing ETL architecture based on the metadata(Oracle procedures and Informatica)

• Design a single Informatica program workflow (mappings, sessions) to replace the existing 60 different programs.

• Work on bringing the data from three different MSP systems to a single system (conforms with CHASE, WAMU and CHASE)

• Establish data modelling naming standards to promote quality model deliverables.

Environment: Unix, Unix Scripting, Powercenter Informatica 8.6/9.0, Informatica Data Quality 7.0, IBM Datastage 8.0 , Erwin 7.0, PL/SQL, Toad 8.0, Oracle 11g, Oracle Stored Procedures, SQL Developer.

2. Verizon Telecom (Architect/Lead/Sr ETL Developer) Dallas, TX Feb 2007 to Apr 2011

Project Worked: MDR, IVAPP Mart, VASIP Mart, LEC Mart, CDI

Metrics Data Repository (MDR) is Verizon’s most advanced and significant reporting system with a DB size of more than 100TB. MDR had an average budget of 15 Million dollars and supplied many key metrics to the top Executives. I have worked with MDR in many end to end projects with roles such as a Project Manager, Lead Analyst, Architect and Lead Developer. I handled independently very strategic and non–strategic projects. Worked on multiple projects at the same time and always delivered them on time or before.

IVAPP application (source system) is an order provisioning system for FIOS TV, FIOS VIDEO, FIOS Digital Voice and FTTP Voice services. As part of this Mart, I lead many design/development activities. Also created many key metrics based on the provisioning status of the order, like order completion, Pending, future pending. Also played similar role in VASIP (Value Added Services), which is a third party interfaces for selling Verizon movies , Email services and so on. LEC systems are (which had more than 7 different source systems for ordering and billing information) conventional voice lines mostly residing in mainframe systems. The other key projects, I was involved were enterprise dimension mart (EDM), Equipment retrieval(ER) systems and ONT (Optical Network Terminals).

Responsibilities

• Architect and Integrate systems into a single DWH repository. Provide the best possible reporting solutions for the business needs.

• Ensure the architecture conforms to enterprise blueprints.

• Take part of the Architectural design on Master Data Management in Verizon Enterprise Level.

• Establish data modelling standards to promote quality model deliverables.

• Logical and physical data modeling for the various facts and dims. Enhance the Entities/attributes for the wider reporting needs.

• Design and model the tables in Stage, Transient, ODS, DataMart and Aggr. Mart areas.

• Lead the ETL team of up to 5 team members in analyzing, designing, developing, deploying & automating MDR Warehouse Activities.

• Complete Ownership of the Marts like IVAPP, ER and ONT

• Understand the business rules and interact with business users for the requirement gathering

• Design the ETL strategy, write Unix Scripts & write SQL queries for the reports.

• Handled more than 300 files on a daily basis from many different systems.

• Excellent working knowledge in Unix/SFTP process.

• Received and sent files using NDM/SFTP between many different source systems and downstream systems

Environment: Erwin 4.1/7.0, Unix, Unix Scripting, Pearl, Greenplum, SQL Advantage, Oracle Data Integrator 10g, Microsoft SSAS, SSIS, SSRS, Powercenter Informatica 8.6/ 7.1/6.3, Informatica Data Quality 7.0, AppWorx, Teradata, Microstrategy, Microsoft Analytical Services, Microsoft Reporting/Cube Services, OLTP and OLAP systems,Verizon Proprietary Metrics(VZAI), Oracle 9.2.0, Erwin 4.0, PL/SQL, Toad 8.0, benthic, Windows NT Servers.

3. Temple-Inland (Sr ETL Developer/Architect/Lead) Austin, TX Jun 2004 to Jan 2007

Projects Worked: Guaranty bank DW, Financial Systems DW & Corrugated Packaging DW.

Temple-Inland has three vertical divisions - finance, forest products and corrugated packaging. I actively participated in forging the strategy for the first enterprise data warehousing for Temple Inland. Based on the specific business needs and source systems complexity, designed the table extraction rules, stage tables (History tables and Incremental Look alike) & mart tables. Participated in source system analysis, Source Data Analysis, Business Requirement gathering & source field-target field matrix as per the business rules. Lead/Co Coordinated the ETL Team for the development, testing, object promotions and deployment.

Responsibilities

• Lead the ETL team in analyzing, designing ,developing & deploying on different business areas of Temple Inland Inc.(Banking, Financial & Corrugated Packaging)

• Design the complete ETL strategy. Identification of the folders, user permissions, reusable objects, making the pilot mappings in the INFA.

• Active participation in the every cycle of the project, right from the requirement gathering to the postproduction support.

• Identify the entities, attributes as the facts and dims in Data mart. Identify the entities for the persistent Stage/ODS areas based on the source system extracts.

• Understand the business and profitability calculations. Implement this in the ETL mappings and the source system data.

• Creating/ Building mapping with the best possible way for the efficiency and reducing the window of running time in the designer 7.1/6.3

• Running/scheduling workflows and Sessions using the workflow manager 7.1/6.3

Environment: SQL Advantage, Powercenter Informatica 7.1/6.3, Brio/Hyperion 8.3, Reports, Oracle 9.2.0, Erwin 4.0, ISQL, PL/SQL, Toad 8.0, benthic, AIX Unix, Windows NT Servers.

4. Prudential Financial (Sr. ETL Developer) Roseland, NJ Nov 2001 to May 2004

Projects Worked: Premier Agent, Orphan Management, Client Portfolio System, GIDW

All these projects are under United States Consumer Group of Prudential Individual Financial Insurance. Users of this group are the Policy Agents or the Producers of Prudential Financial who market, sales or support the Prudential Insurance Policies. Information or data about the customers/clients and policies are stored in different Admin systems and majority of the data resides in variety of mainframe systems, which are not properly connected. All these projects mentioned above are designed to provide the customer information in a simple and efficient way to the agents.

Responsibilities

• Design, development, testing and implementation of the Premier Agent Data Repository Project using stored procedures.

• Production support of the Premier Agent Project which includes data analysis of the historical data and checking of the weekly load status

• Develop the stored procedure for loading the data into the premier agent database from stage tables to the production table.

• Coordinating development & testing team for any changes to be implemented in the system.

• Business analysis of the Orphan management system. Creating the input data load files for high value affluent policies using another VB application “Cscrub”.

• Dicing and Slicing of the input data for the Business feed back. Testing of the system

• Data mapping of the mainframe data fields to the PruDBMaster database.

• Review the Data Model of the PruDBMaster and give the error feedback.

• Assist Datastage 6.0 implementation over the existing stored procedure ETL process in the Premier Agent system.

• Data loading of the test data into PruDB master for the testing of Mobilink data synchronization

• Synchronize the PruDBMaster database with other databases like PruDB Remote and CDS, PAS,

Environment: SQL Advantage, Cscrub, Crystal Reports, Ascential Datastage 5.0/6.0, Visual Basic 6.0 Forms, ISQL, PL/SQL,Unix, Pro*C, SQL, Informatica Powermart 5.0, Business Objects 5.1 , IBM UDB DB2 7.2

5. Cendant Corporation (Developer/Lead) Dublin, OH May 2001 to Oct 2001

Project Worked: Membership Financials (memfin)

Cendant is developing a financial application for their Direct Marketing Division called Membership Financial. This application serves for billing, collection and revenue recognition for Cendant membership business. Project spans into 6 different modules which includes new Membership(newly developed system which is in Oracle and Java),Old Membership(Old system in VAX), Financial Transaction Control (accepts billing, refund, and other financial transactions from other systems), Financial Data Store ,Membership Client Return, Core Financials.

Membership Financials objective is to provide Secure and audible systems and procedures that will enable CMS to be confident in its financial reporting; specifically its membership revenue recognition, deferred revenue, deferred commission expenses and cash tie out process.

Responsibilities

• Develop mappings extensively using Informatica Designer

• Creating/ Building and Running / scheduling Batches and Sessions using the Server Manager.

• Supporting and maintaining the system areas of development and User Acceptance Test

• Installing the new software changes which come as packages to these areas.

• Taking and restoring the back up whenever necessary for the testing and development team

• Running necessary Java process, Scripts, reports, Informatica transactions in these environments

• Creating the entries in the defect tracking system for fixing which pop upped while testing

• Coding, Co-ordinating the testing, development activities

Environment: SQL Navigator, Unix, Brio Query, Informatica, Rational Clear Quest, SQL plus, SQL Loader TOAD, Shell scripts, Oracle utilities Windows NT 4.0, UNIX, Oracle 8.1.6

6. GE Capital (Developer/DBA) Danbury, CT Apr 2000 to May 2001

Project Worked: Panther Asset Valuation Engine (PAVE)

Panther is an enterprise wide initiation of the GE Capital. It is an integration cum re-engineering of three divisions of GE Capital (CE F, E E F and V F S) Under Panther, GE capital developed and implemented web-based application called Panther Asset valuation Engine (PAVE) for Asset Management Team. Asset team uses the PAVE application to calculate the residual values corresponding to any term and of any

asset.

Responsibilities:

• All DBA activities of the PAVE Database including setting up Database, mounting & dismounting , performance tuning, Backup etc.

• Writing PL/SQL stored procedures and the packages where parameters need to be appropriately passed to the front end to store and retrieve data from the back end.

• Understanding the business functionality for the development and enhancement of the project

• Assist the synchronization of the PAVE 1.2 database to the Global Panther Database.

Environment: Oracle Enterprise Manager, SQLplus, Java, SQL Loader, PL/SQL, TOAD, Shell scripts, Oracle utilities, Windows NT 4.0, UNIX, Oracle 8.0.5.1.0

7. Tata Consultancy Services Bombay, India Jul 1999 - Mar 2000

Project Worked: Office Automation System

Office Automation (O. A.) is an integrated Automation System of Tata Consultancy Services (TCS) which is having a single global database connected by the end users from all the offices of TCS in the world. In the project, O.A. Group integrated all the databases that were divided across many systems like MATC, HRMS, ADMIN, and PAYROLL by completely redesigning the physical and logical data model and implementing that.

Responsibilities

• Requirement analysis and redesign of the existing ADMIN System to the new version.

• Development and upgrade of the system in Forms 5.0 and Reports 3.0

• Design the Data model of the new admin system

• Data loading of the test data into the database using some loading tools like SQL Loader.

• Release of the software, version control, implementation and training to users.

• Change requests, Modifications, Data concurrencies, Backups of the system, DBA activities

Environment: PL/SQL, Developer 2000, Oracle Enterprise Manger, SQL Loader, Windows NT 4.0, Oracle 8.0.5

8. Stock Holding Corporation Of India limited Bombay, India Jun 1998 – Jun 1999

Project Worked: Safe Custody System

Safe custody system deals with the functionality of taking share scripts from Stock exchange mainly belong to Financial Institutions and keeping it in the safe custody. In this project, this process made automated and kept track of all the dealings which has done.

All process which includes acceptance, custody and withdrawals which follows many business rules and customs made simpler to the end user for any trading

Responsibilities

• Maintain all of the software that comes under the module WITHDRAWALS

• Take client requirements, develop the forms/reports, QAing

• Promote the codes for User Accepting testing& fix the bug.

• System study of the other modules that interacts with module Withdrawals

Environment: PL/SQL, Forms 3.0, Reports 2.5, Windows 95, UNIX, Oracle 7.3

Software Skills

Development Tools/Software : Informatica Power Mart 6.3/7.1/8.6/9.1, IBM Datastage 6.0/7.0/8.0, Hyperion-Brio 8.0, TOAD 7.0/8, SQL Navigator , Appworx/Maestro Scheduler, Erwin 4.0, Designer 6.0, Busines Objects 5.1/6.0, SQL Advantage, Microsoft SSAS, SSIS,SSRS, ISQL, SQL Plus 8.0, SQL Loader, Developer 2000, Command Center, Forms 3.0, Reports 2.5, Browser 2.0, Shell Scripts, VISIO Professional 5.0, Perl/Python, Greenplum, Oracle Data Integrator 10g, Informatica Data Quality, SAP BW, SAP ABAP

Languages : SQL, PL/SQL, T-SQL, Visual Basic Net, Unix, Unix Scripting, C,

Pro*C,Fortran, Visual Basic 6.0/7.0, Java

Operating System : Windows NT /2000/XP, UNIX Solaris/AIX, MS DOS

Databases : Oracle 10g, Oracle 9.2.0/8.1.7/8.0.5/ 7.3, SQL Server 2005,UDB DB2 7.2,

Sybase ASE 12.5, Sybase ASA 8.0, TeraData, IBM DB2, MS Access

Business Areas : Telecommunications, Manufacturing, Individual & Group Insurances, Asset management & Leasing, Membership financials

Education

4 Years Bachelors Degree in Engineering from NIT Calicut (Ranked among top 10 engineering institutes in India) -1998

Certifications

• Completed Certification in Oracle 8i Database Administration (Oracle Certified Professional Exam) conducted by the Oracle Corporation. In the certification all the papers of the database are been successfully passed which includes PL/SQL, Oracle Database Architecture and Administration, Back Up and Recovery, Performance Tuning and Network Administration.

• Completed Certification in Infomatica Powercenter 7 (Informatica Certified Designer) from Informatica Corporation after successfully completing the exams on Architecture and Administration, Mapping Design & Advanced Mapping Design

Contact this candidate