C. Prasanna Kumar

aco955@r.postjobfree.com

908-***-**** * 503

Experience Summary

. 9+ years of extensive experience in the IT industry with thorough

understanding of Data Warehousing terminology and proficient in Data

Warehousing tools like Ab Initio (GDE 2.5,3.0 Co-Op

2.14,3.0,3.1,3.2,OC,ACE) and Actuate (V 7,8).

. Presently working as ETL AbInitio Administrator with Citi EPS Project.

. Expertise in Abinitio components available in the market (OC,CC,ACE,MHUB)

. Designed and implemented ETL applications(AI,ORACLE,WEBSPHERE) in UNIX

environments

. Strong Experience in AbInitio Co-Operating System, GDE, EME, key

management, co>op License management and debugging strategies.

. Taking care of CPU and Memory Utilization, server performance checks and

backups.

. Well versed in EME administration, Code migration and environment check

out.

. Handled Server level issues of abinitio and analyzed CPU, processor

bottlenecks with abinitio environment.

. EME Setup, project creation in EME, EME Groups/users and setting

permissions, EME Restart, Backups.

. Development experience with ETL, Data Mapping, Transformation and Loading

from Source to Target Databases

. Actively interacting with business users, software development team and

system administrators in gathering the requirements and creating

functional and design specifications.

. Expertise in DWH concepts and implementing the same

. Extensive experience on SQL, fairly comfortable with PL/SQL.

. Working in production support and Maintenance and dealing with issues

like recovery mechanisms and failure analyses.

. Knowledge on ISO, CMM Levels.

. Good team player with excellent communication, written and presentation

skills with strong aptitude to learn new technologies.

Skills

. ETL Tools : Ab Initio (GDE, Co-Op 2.14,3.0,3.1, 3.2),

ACE

. Reporting Tools : Actuate e-Report designer (V6,7,8)

. Operating System : UNIX, AIX, Windows Xp/2000/NT

. Languages : C/C++,SQL,PLSQL, Actuate basic

. DBMS : Oracle9i, SQL Server,DB2

. Management Tools : VSS, Autosys, Harvest, USD 60,Tivoli,Autosys, OC,

CC

Education

> B.Tech (Information Technology) from Madras University, India 1999 -2003.

Experience Summary

. Presently working with LnT InfoTech as Sr. Systems engineer,

June'10 - Till date

. Worked for Syntel as Analyst Programmer, Nov'06 - June'10

. Worked for Everest consulting as S/W Engineer from Aug'06 to

Nov'06

. Worked for Infobiz as S/W Engineer from Nov'04- July'06

Project Experience

Project - 1

Client : CITI BANK -NJ, USA

Project : EPS GENESIS AI Support

Team Size : 9

Period : Jan '14 - Till data

The GENESIS data warehouse is common pool of contacts, positions, and

customer account balances across all of CITI, for use of Finance, Risk and

Compliance. The GENESIS use base includes:

- Finance

- Risk and compliance operation and Consumers of Data users

Responsibilities:

. OC, ACE End to end setup of application setup and configuration

. WAS configuration for OC and ACE

. EME Setup, project creation in EME, EME Groups/users and setting

permissions

. EME Restart, Backup and Restore

. Troubleshooting Access Related issues with GDE, EME, ACE and OC

. Job import for OC.

. Worked in creating EME repositories and configuring EME web interface.

. Project and Sandbox Setup

. Worked in automated server level monitoring scripts for abinitio

environment.

. Involved in conducting full COB test for all supported Applications.

. Patch release/Project release and migrations and common project

checkouts.

. Adding user to tag group/Project EME

. Monitoring alerts and running delete scripts/adding files to ignore list

. Key related issues.

. Weekend on call activities and Checkouts after server reboots and patch

upgrades.

Project - 2

Client : CITI BANK -NJ, USA

Project : GFTS STE AI Support

Team Size : 9

Period : July '10 - Jan'14

As part of the project we are supposed to provide end to end architectural

support for Abinitio applications running on NAM and EMEA servers

Responsibilities:

. Worked with citi architects to review and prepare build documents for 20

new abinitio servers (DEV, UAT, PROD & COB).

. Key bundle management

. EME Restart, Backup and Restore

. Troubleshooting Access Related issues with GDE and EME

. Worked in automated server level monitoring scripts for abinitio

environment.

. Involved in conducting full COB test for all supported Applications.

. Patch release/Project release and migrations and common project

checkouts.

. Installation and configuration of Abinitio components

Project - 3

Client : Allstate Insurance, Chicago IL

Project : AFT ETL Development.

Team Size : 4

Period : Dec '08 - June'10

Vertical : Insurance.

XCOM - MFT - The primary purpose of this project is to convert all

Integration's Ab Initio jobs/graphs that invokes the XCOM component to the

new file transfer component that Enterprise had developed. In addition, a

generic mass file transfer routine will be introduced using a configuration

file. This routine will be called by all "XCOM" graphs in Integration's

inventory.

DCM (Data Center Migration) In order to provide robust computing

environments, reduce deployment & operating costs, improve DR and support

new technologies, Allstate will be adopting a 2 data center model. As part

of this all the existing servers ( Windows, Unix and DB) are migrated to

new Data center Environment that includes code changes for server, file

location.

Responsibilities:

. Identify all XCOM processes/graphs that are owned and maintained by AFT

Integration. Gather all the configuration profile and place them a single

repository.

. Introduce Oracle tables that hold the configuration and access profiles.

. Preparation of Design, Code inspection, UTP documents.

. Convert the existing AFT XCOM graphs to call the AFT Common/Generic Bulk

Transfer graph.

. Remediate ab initio code to meet GPP, ISG changes to the data directory

and the landing zone changes. Also internal standards like referencing

all dbc files for the ab initio processes to AFT COMMON DB and removing

the Unicenter command lines in the allstate scripts.

. Testing and documentation of test results.

. Implementation in QA and production.

Environment: Ab Initio (GDE V1.13. 1.14, Co>Op V2.13.1, V2-14-1), Oracle

9i, UNIX)

Project - 4

Client : Allstate Insurance, Chicago IL

Project : AFT ETL Maintenance and Support.

Team Size : 4

Period : March '07 - Dec '08

Vertical : Insurance.

In AFT (Allstate Financial Technologies) System involves Integration of

data from Admin Systems & Producer Systems. Admin systems includes CKS,

CK4, CKI, ATLAS, LIFE70.

List of application we support includes Operational Data Store (ODS), Asset

Feeds, Sales force, TAI, producer and EPC. In the AFT system the financial

data for Premium, Claims and Sales is loaded to Unix system on a daily,

weekly and monthly basis using XCOM. Ab-Initio graphs are executed against

this data to perform transforms and edits. The ASP.NET user interface

(browser based) is used for validation of control totals, error correction,

resubmission and viewing reports.

Services to be performed by the Syntel can be divided into 2 major

classifications:

Maintenance Service Requests (Non-discretionary): Typically, this

represents work that must be performed by Syntel and is considered Syntel's

1st priority. Syntel's performance against work assigned is tracked and

reported on a monthly basis; typically represents production fixes and

administrative requests for production environment. Jobs run on daily and

monthly basis. Order of priority for any tickets is assigned by Allstate

and will fall into one of 3 severity levels (1-emergency or 2-critical)

Maintenance and Enhancement Services (Discretionary): Represents work that

is a lower priority for Syntel will be completed as time permits and is

assigned a priority on a case by case basis by Allstate and the Syntel;

typically represents enhancement type requests. This includes severity-3

service requests (non-critical maintenance) and severity-4 service requests

(enhancements).

Responsibilities:

. Application Maintenance includes job monitoring and handling with Aborts.

. Analyze issues and prepare technical specifications.

. Design and Development of Ab Initio Graphs.

. Making the necessary logic changes.

. Preparing Approach document, code inspection documents and test plan

document.

. Doing Unit and Regression testing.

. Delivering the quality deliverables within the deadlines according client

standards.

. Resolving the issues based on the priority.

. Preparation of Unit Test plans.

. Preparation of Audit log, Weekly and Monthly reports

. Peer Code reviews.

. Played Lead Role and effectively handled team from Onsite.

Environment: Ab Initio (GDE V1.13. 1.14, Co>Op V2.13.1, V2-14-1), Oracle

9i, Unix)

Project - 5

Client : Freightliner, USA

Project : OWL Reporting

Team Size : 8

Period : Dec '06- Feb '07

Vertical : Insurance.

Freightliner currently administers Warranty support for its products using

software applications hosted on the mainframe environment. Freightliner

has decided to move its warranty business processes to a new web based

application. Freightliner has setup a project, Online Warranty Link (OWL)

to achieve this migration.

Syntel is currently involved in analyzing AS-IS legacy warranty

application, documenting business rules and developing interfaces. Syntel

will leverage reports development experience and support Freightliner with

reports development elaborations in the environment provided by

Freightliner. Syntel will also involve in the technical designs and unit

testing of OWL reports.

Responsibilities:

. Understanding the requirements

. Develop Actuate Formula One Reports.

. Analyze and optimize existing report queries

. Testing and Reviewing.

Environment: Actuate Formula One- 8, Windows XP, IBM DB/2

Project - 6

Client : WACHOVIA BANK, USA

Project : WACHNETCC

Team Size : 6

Period : Aug '06 - Nov '06

Vertical : Banking.

The Project mainly deals in Prevent/ minimizes adverse impact to

Wachovia Customers (internal and external) caused by a disruption of

service within

IT Infrastructure. The Problem Management Process encompasses all

activities from

the time an outage is identified through root cause resolution. This

Application also

deals Customer Relationship Management. Some Modules include Wireless

Office

Reporting, PICCT Reporting, Root cause management

Responsibilities:

. Involved in Preparation of TDD(Technical Design).

. Report Enhancements.

. Designing of Reports for new requirement.

. Uploading of Reports to iserver.

. Functionality Testing Of Developed Reports.

. Created Libraries for enterprise use.

. Created Grouped, Cross tab, Sequential and Parallel reports

Environment: Actuate 8.0, Windows-2000, .Net, Harvest,DB2.

Project - 7

Client : Arena, UK

Project : Data Mart for Arena Products and Sales

Team Size : 4

Period : Nov '04 - May '06

This project deals with the products and sales. Data Mart for products and

sale for Ivoice Ltd the source data from oracle 8i/ Flat file as

extracting the data. Using PL/SQL Procedures, data populated into Facts and

Dimensions. This Data Mart contains various product types and their

competitors. The system allows marketing and sales users to maintain

targets for various products. A forecast is made for the potential that can

be achieved by users from current year and next five years. The invoices

are fed into the system via the Data warehouse.

The source data, which includes

. Daily, Weekly and Monthly Reports

. Quarterly Management Report.

. Customer Score Cards

. Products and their information Reports.

Responsibilities:

. Requirement analyses as per the client specification.

. Created Grouped, Cross tab, Sequential and Parallel reports.

. Used multiple Input filters, Memory sorters to integrate the data

from different data sources Involved in Preparation of TDD

(Technical Design).

. Involved in report Enhancements.

. Functionality Testing Of Developed Reports

Environment: Windows NT, Oracle 8, Visual basic

Contact this candidate