Project Developer

Rajesh Vankayala

Mail To : ******.*********@*****.***

Phone : +1-334-***-****

Experience Summary

Currently working as Informatica Manager with Accenture

Total 11.8 years of experience in Tata Consultancy Services

Total 8 years of experience with Banking and Financial Services

Experience in managing the projects from end to end

Experience as an ETL Architect in designing the end to end ETL Processes

Experience in Informatica Bigdata Edition and Informatica Developer

Experience in data analysis, creating the Source to Target mappings

Experience in data ware housing projects and sound knowledge on the data ware housing concepts like Star Schema, Snow Flake, Slowly Changing Dimensions, etc.

Experience in Performance Tuning of the ETL Mappings

Experience as an ETL developer creating ETL Mappings by using different transformations

Experience on Oracle11g, SQL, PL/SQL

Experience in Unix and Shell Scripting

Technical Skills

Languages

MF COBOL

Programming Skills

Unix Shell Scripting

Database

Oracle 11g, SQL Server 2008, Hive

Operating System

Windows, Unix, Linux

Tools

Informatica 9.5, Toad, Putty, Callidus Truecomp, Oracle General Ledger, PL/SQL Developer, Oracle Mantas, Informatica Developer

Domain Experience

Banking and Financial Services

Education Summary

Degree and Date

Institute

Major and Specialization

Master of Computers and Applications

Pondicherry University

Computer Science

Employment Summary

Employer

Employment Period

Tata Consultancy Services Ltd

May 2003 to Feb 2015

Accenture

Feb 2015 to till date

Professional Memberships / Certifications

Professional Certification

Date Certified

Certified Informatica Developer

Sep 2008

Contributions/Achievements

Received “Star of the Quarter” award from TCS in the month of March 2011.

Received “Best Process Improvement for the Quarter” award from TCS for the RBCB Case conversion project.

Assignments

The details of the various assignments that I have worked on are listed here, in chronological order.

1.Oakland Analytics Factory

Project

Oakland Analytics Factory

Customer

Manufacturing Company

Period

Jul 2015 to till date

Role

Technical Lead

Description

Responsible for designing the ETL Processes and lead the development efforts working in onsite offshore model

Technology

Informatica Power Center 9.6.1, Informatica Developer 9.6.1

Hortonworks Hadoop 2.0, Hive 2.0

Roles and Responsibilities

Understand the requirements of the projects

Design the ETL Mappings

Create/Modify the ETL Mappings

Design test cases for data quality testing

Assign and Track the status of the Tasks assigned to the team

Review the deliverable

2.EDW Release2

Project

EDW Release 2

Customer

Insurance Company

Period

May 2015 to June 2015

Role

Technical Lead

Description

Responsible for understanding the EDW Architecture, Integration points and provide the estimates for the ETL effort for Release 2.

Technology

Informatica Power Center 9.5, Informatica Developer 9.6.1

SQL Server 2010

Roles and Responsibilities

Understand EDW Architecture and Integration Points to help in the estimation

Working with Project Manager for creating project plans/task plans

Reviewing existing Best Practices and making suggestions/recommendations for improvising the processes

3.ABC Retail Profitability

Project

ABC Retail Profitability

Customer

PNC Financial Services

Period

Apr 2013 to Feb 2015

Role

Technical Lead/ETL Architect/Sr. Developer

Description

Responsible for designing the ETL Processes and managing the ETL development efforts in the project ABC Retail Profitability.

Technology

Informatica Power Center 9.5, Unix, Activity based costing product Acorn

Roles and Responsibilities

Understand the requirements of the projects, incidents

Design the ETL Mappings

Create/Modify the ETL Mappings

Design test cases for data quality testing

Assign and Track the status of the Tasks assigned to the team

4. PNC Risk Management and Compliance

Project

PNC Risk Application Support

Customer

PNC Financial Services

Period

Nov 2010 to till Date

Role

Project Lead

Description

Application Development and Maintenance of the Applications in the Risk Management and Compliance Applications like STX, PXP, BTC, etc.

STX - An Anti Money Laundering system used to monitor the transactions from various source systems such as Teller, Visa, AMTRUST, ACH, ATF, etc. on the basis of pre-defined rules or scenarios to determine if a transaction is suspicious. If the transactions are found suspicious alerts will be created to have the Business users investigate into these transactions.

PXP - A Politically Exposed Persons system to scan OFAC and PEP list for identifying the customers that we are not permitted to do business with and to identify high risk customers.

Technology

Informatica Power Center 8.6, Unix, Oracle Mantas

Roles and Responsibilities

Understand the requirements of the projects, incidents

Design the ETL Mappings

Create/Modify the ETL Mappings

Design test cases for data quality testing

Assign and Track the status of the Tasks assigned to the team

5.PNC Risk Management and Compliance – RBC Case Conversion Project

Project

PNC Risk Management and Compliance - RBC Case Conversion Project

Customer

PNC Financial Services

Period

Dec 2011 to Apr 2012

Role

Project Lead

Description

The project aims at converting RBC AML and Fraud cases in RBC Case Management system “ICMS“ to the PNC AML and Fraud Detection application Oracle Mantas.

Technology

Informatica Power Center 8.6, Oracle Mantas, Unix

Roles and Responsibilities

Understand the requirements of the case conversion

Perform the Data Analysis and create a source to target mapping

Create the design and data model for the data staging and end to end the data process flow

Create the ETL Mappings

Design test cases for data quality testing

Perform System Testing

6.Bulk Data Extract

Project

Bulk Data Extracts

Customer

PNC Mortgage

Period

Nov 2010 to Mar 2011

Role

ETL Architect/ETL Manager

Description

BDE- Bulk Data Extract is an application to design and develop ~150 interfaces for loading the Mortgage Loan Servicing data in to the Operational Data Store and create ~200 operational reports to the Business users

Technology

Informatica Power Center 8.6.1, Oracle 11g

Roles and Responsibilities

Create a design for the ETL Process

Create the data model for the BDE Operational Data Store

Design the Audit Balance Control for the project

Design the Testing Strategy

Manage the project execution from end to end

7.Enterprise Incentive Management System

Project

Enterprise Incentive Management System

Customer

PNC Mortgage

Period

Jan 2007 – Nov 2010

Role

ETL Lead

Description

Enterprise Incentive Management System is an application which processes the payroll for the Mortgage Loan Officers by calculating the loan incentive commissions on the basis of the volume of the loans and type of the loans closed. Also this application loads the payments processed in the Truecomp Datamart and daily reports are published through the True Portal.

Technology

Informatica Power Center 7.1, Actuate Reporting Tool, SQL Server 2005

Roles and Responsibilities

Development of the Interfaces from the Mortgage Origination Application, PeopleSoft HRMS Application

Get the requirements from the users for the compensation plans

Develop the Compensation plans

Design the Test Case and Test Plans

Perform Unit Testing

Provide support for the ETL Interfaces and Truecomp Datamart

8.Oracle GL Implementation and Support

Project

Oracle GL Implementation and Support

Customer

GE Asset Management

Period

August 2005 to Dec 2006

Role

Developer

Description

GE-AM is a wholly owned subsidiary of G.E that is into Funds management and Portfolio management business. GE-Asset Management is in the business of managing assets. GEAM is a registered investment advisor with offices in the U.S, Canada, Europe and Japan. Usually they invest money in U.S equity, International Equity, Fixed Income, Real estate, Private Equity etc.

The project is implementation of the General Ledger module which replaces the mainframe system. It involves in building the inbound and outbound interfaces to General Ledger, in addition with data conversions. There are different source systems from which data will be flowing into the General Ledger.

Technology

Informatica Power Center 7.1, Oracle Financial Services – General Ledger

Roles and Responsibilities

Requirements gathering and the analysis of the legacy source

Design the stage database

Design the ETL Interfaces and end to end ETL Process

Develop the ETL Mappings

Design the Test Cases

Perform Unit Testing

Perform System Testing

9. Marketing Dashboard Datamart

Project

Marketing Dashboard Datamart

Customer

GE Power Systems

Period

April 2005 to July 2005

Role

Developer

Description

Much of the needed information for GEE Global Marketing to monitor performance and make decisions is either not digitally stored or kept in disparate locations.

The key objective of this project is to facilitate reporting by providing a one-stop shop for the team’s data needs and to provide users with the ability to easily work, sort, drilldown, and report on various performance metrics including Opportunities, Initiatives, and Commercialization. The idea here is to create a unified view of enterprise marketing information by consolidating the data from various sources and storing it in a datamart.

Technology

Informatica Power Center 6.x, Oracle

Roles and Responsibilities

Requirements gathering and the analysis of the legacy source systems using REVINE

Database design/modelling using ERWIN

Loading the Test data into Database

Development of the mappings using Informatica

Preparing the Test plans

Unit Testing and System Testing

Production Rollout

10. HBI EXIT

Project

HBI EXIT FP – OFF SHORE

Customer

GE Consumer and Industrial

Period

August 2003 to March 2005

Role

Developer/Module Lead

Description

This is a migration project which involves migration of the Honey well Bull Mainframe applications to HP Unix. The project involves in migrating the Honey well Bull JCLs to Unix Shell Scripts, DM8 Sqls to Oracle 9i Sqls and Altran COBOL sources to MF COBOL Sources.

Technology

MF-COBOL, Altran-COBOL, SQL, UNIX Shell Scripting

Roles and Responsibilities

Performing complete dependency checks pertaining to one Y2 Unit due for conversion and issues to be addressed before conversion

Prepare plan for the order of conversion of COBOL programs for conversion

Delegation of COBOL sources and JCL programs for conversion

Conversion of COBOL and JCL programs using project specific tools

Testing the COBOL program output with other outputs from the existing programs using SMARTDIFF utility and evaluating the test results

Rolling out the converted sources into production

Contact this candidate