Project Oracle

[pic]

Periyarselvan Ramanathan

TrueComp Specialist

Email:*************@*****.***

Cell: 626-***-****

Professional Summary

> An IT consultant having 9 years 6 months of experience in Analysis,

Design, Development, Testing and Implementation of different Data

warehousing projects

> Having 3 Years of experience in TrueComp Application, a Compensation

Management Tool from Callidus Software, which includes Performance

tuning of Batch Jobs like Import, Pipeline and DataMart ETL.

> Acted as a Functional and Technical SME for TrueComp Upgrade from v4.4

to v5.2.3 in DB2 Platform and managed the Overall Upgrade project to

completion.

> Extensive experience in supporting TrueComp Application including

TrueComp UI, Import, Pipeline, DataMart ETL and all inbound/Outbound

interfaces.

> Experience in implementing Pipeline StageHooks and modified

PipelineReadQueries to improve the performance of different pipeline

stages.

> Experience in implementing Pipeline StageHooks and modified

PipelineReadQueries to improve the performance of different pipeline

stages.

> Experience in implementing the Multi threading in DataMart ETL.

> Experience in creating Compensation plans and rules to support new

payment structure to Brokers.

> Experience in Modifying existing Plans and Rules to improve the

performance as well as to modify the payment structure to certain

brokers.

> Extensively involved in Customizing/Improvising the TrueComp Features

based on Business needs like enabling the Summarize mode pipeline,

Deferred Reset Option, Modifying OQCS (Order Queue Chunk Size), etc.,

> Performed the application tuning of BSC application including tuning of

Pipeline and DataMart ETL jobs to improve Performance & Operation

effectiveness of the application.

> Have a very good Knowledge of Incentive Compensation Management (ICM)

Domain and its elements.

> Experience in Data Warehousing tools like Ab initio, Informatica, DTS

packages (SQL Server).

> Experience in Oracle, DB2 and SQL server Databases.

> Extensive experience in all Data Base Objects including Stored

Procedures, Functions, Triggers, Packages, Indexes, Synonyms

(aliases), Directories, etc.,

> Certified by Oracle as Oracle Certified Associate (OCA).

> Completed TrueComp 5.2 Fundamentals Course and Exam in Callidus

University Portal.

> Very strong understanding of Data Warehousing Concepts including ETL

and reporting concepts.

> Experience in providing the support for production environment in

24x7.

> Extensive Experience in Extract, Transfer and Load (ETL) Process of

Data warehousing using multiple Tools like Ab-initio and Informatica.

Educational Details

Degree and Institute Major and Specialization

Date

Bachelor of Shanmugha College of Electrical and Electronics

Engineering, Engineering, Tanjore Engineering

April 2000 (Affiliated to

Bharathidasan University,

Trichy)

Technical Profile

Software Oracle 8i/9i, PL/SQL, Ab initio, Microsoft SQL

Server, Unix Shell Scripting, Tera data, Perl,

Informatica, DB2

Hardware HP 9000 servers, Pentium PCs connected to the

LAN, SunOS 5.7, WIN NT Server, Windows 2k

Server, UNIX, LINUX, AIX

Tools TrueComp 4.4. TrueComp 5.2.3,Ab initio GDE,

Oracle Enterprise Manager, SQL*Plus, SQL Server

Enterprise Manager, Query Analyzer, SQL Server

English Query, SQL Server DTS Package, Toad,

PL/SQL Developer, EZSQL, SQL Loader, Putty,

K2RCMAC Tool, WinSQL, Citrix Client, Putty,

Informatica 7x, Informatica 8x, DB2

Methods Water Fall and XP (AGILE) methodology.

Domain Experience Telecom, Retail (Marketing Research) and

Healthcare domain.

Management Experience 3 Years as Team Lead and 3 years as Project

lead.

RDBMS Oracle 8i/9i/10g, MSSQLServer, DB2

Work Experience

Client: Kaiser Permanente, CA

Sep 2007 - Till Date

Project: Broker Sales Compensation (BSC)

Role: Project Lead

Broker Sales Compensation system is an Incentive Compensation Management

Application meant to pay brokers who are selling Kaiser Health plans.

Application is designed using TrueComp, a Callidus Product, which receives

data from inbound interfaces using ETL (Ab initio) and provides data to

Outbound Systems such as Kaiser's AP (to complete the payment), TAX5500,

Actuate application (for generating statements), etc., Recently Kaiser has

moved from TrueComp v4.4 to TrueComp v5.2.3

Responsibilities:

> Provided SME support both as Functional and Technical Expert for

Callidus Upgrade Project where TrueComp 4.4 version is upgraded to

TrueComp 5.2.3 version in DB2 database

> Provided SME support both as Functional and Technical Expert for

Actuate and Oracle Upgrade Project where Actuate is upgraded from v7

to v10 and Oracle is upgraded from 8i to 10g

> Performed the application tuning of BSC application including tuning

of Pipeline and DataMart ETL jobs to improve Performance & Operation

effectiveness of the application.

> Experience in implementing Pipeline StageHooks and modified

PipelineReadQueries to improve the performance of different pipeline

stages.

> Experience in implementing the Multi threading in DataMart ETL.

> Experience in creating Compensation plans and rules to support new

payment structure to Brokers.

> Experience in Modifying existing Plans and Rules to improve the

performance as well as to modify the payment structure to certain

brokers.

> Worked with Callidus Support team and Consulting team to get the

ideal field fixes for the issue encountered during Callidus Upgrade.

> Provided Technical as well as Functional resolution or workaround for

all the issues encountered during different phases of Callidus

Upgrade.

> Helped defining the Performance testing and Functional testing scope

for Callidus Upgrade Project.

> Helped sizing the need for additional hardware for the Callidus

Upgrade Project.

> Understood the new features of the new version and presented the

changes in the new version to the business users.

> Extensively involved in Customizing/Improvising the TrueComp Features

based on Business needs like enabling the Summarize mode pipeline,

Deferred Reset Option, Modifying OQCS(Order Queue Chunk Size), etc.,

Other Release Activities:

> Involved in Project planning and Monitoring & control including

defining scope of work, estimating.

> Involved in Controlling the Quality by ensuring Reviews and Test

coverage.

> Involved in keeping the functional documents up to date based on the

application changes

> Involved in keeping service level agreements intact for releases and

production support, which has financial implications.

Environment: TrueComp 4.4, TrueComp 5.2.3, AIX, Oracle 9i/10g, DB2, PL/SQL,

Unix Shell Scripting, Ab initio GDE and Co-operating System, Informatica,

Actuate, Pentium PCs connected to the LAN (Local Area Network) and to the

local network.

Client: British Telecom, Cardiff, UK.

Jan 2007 - Aug 2007

Project: Electronic Billing Presentment and Payment (EBPP)

Role: Project Lead

EBPP is Online Billing and Payments Application for British Telecom. It

converts RAW data files from legacy(Mainframes) system to ASCII Data file

in a format readable by a third party software, EADIRECT, which is used for

bill presentment. Ab-initio is used for data Transformation from RAW to

ASCII and PL/SQL and SQL Loader is used for storing data into Oracle

Database. Presentation and Payments is developed using Java and EADIRECT.

Responsibilities:

> Extensively involved in developing raw file Conversion Mapping using

Ab initio.

> Extensively involved in remodeling the Oracle database using

partitions (table partitions and related index partitions) to improve

the performance of the application.

> Involved in creating the utility applications in Oracle and UNIX to

monitor the data growth in database, file system at OS level and to

automate the support activities including purging, automatic startup

scripts for batch jobs, etc.

> Experience in using PVCS for Configuration Management of all

deliverables.

> Extensively involved in building business rules using the Ab initio

ETL tool.

> Extensively involved in bug fixes, which are occurred in the

migration project.

> Extensively involved in code review, developing unit test cases and

test scenarios for the entire flow of the application.

Environment: Oracle 9i, PL/SQL, Unix Shell Scripting, Ab initio GDE and Co-

operating System, Linux, Java, JSP, Struts, EADIRECT and Pentium PCs

connected to the LAN (Local Area Network) and to the local network.

Tools: Ab initio GDE, Oracle Enterprise Manger, SQL* PLUS, TOAD, PL/SQL

Developer, EADIRECT and Putty

Client: ACNielsen INC., IL

Apr 2005 - Jan 2007

Project: Open Consumer Data warehouse (OCDW) - Databank

Role: Project Lead

Databank is a Data Warehousing project where we Extract data from PLDB Data

Sources, Transform PLDB data into relational data format and Load the

Transformed data into DWH built on Oracle. Also Databank calculates

dimension level rollups for Market and Product Dimensions. Ab-initio is

used for Extract ion & transformation and Oracle PL/SQL is used for

Loading.

Responsibilities:

Developer:

> Designed and Developed Functional Modules in Oracle PL/SQL, Ab-initio

and Shell Scripting based on the requirements.

> Involved in Complex Data Load Operation development using Oracle

Packages, Procedure, Functions and Directories, which converts and

uploads the data available in Flat File to Oracle Tables in bulk

mode.

> Involved in Complex ETL Operation development using Ab-Initio, which

converts the Main Frame Format5, files to ASCII format and staged it

in Oracle Staging server.

> Converted the Complex ETL code in Ab initio and Data Load code in

Oracle packages to Scalable code which can be leveraged for multiple

clients with very less customization.

> Developed Utility reports for Application performance, Monitoring

Data Profile, etc.,

> Developed Utility scripts in Shell scripting for automating the Batch

Jobs.

> Performed Configuration Management using PVCS.

Support:

> Provided Support for Weekend Data Load processing

> Developed Utility tools using PL/SQL and Ab initio for Maintenance

activities.

> Handling Problem ticket raised through HEAT (Ticket System in

ACNIELSEN).

> Provided Support for Configuring ETL and DBLOAD Application for new

clients.

Environment: Oracle 9i, PL/SQL (Packages, Procedures, Functions, and

Directories), Unix Shell Scripting, Ab initio Co-operating System,

LINUX/AIX and Pentium PCs connected to the LAN (Local Area Network) and to

the local network.

Tools: Ab initio GDE, Oracle Enterprise Manger, SQL* PLUS, TOAD, PL/SQL

Developer, SQL*Loader and putty

Client: QWEST INTERPRISE INC, Minneapolis, MN Jul

2004 - Apr 2005

Project: Qwest Totalcare

Role: Programmer Analyst and Production Support Analyst

Oracle Applications - QWEST uses Oracle Applications for handling financial

functions like Accounts Payable (AP), Accounts Receivable (AR), General

Ledger (GL), Purchasing Order (PO) and Inventory (INV). Qwest is working

towards tailoring the Oracle Applications to meet the client's

requirements.

CPE Application Suite - This suite of applications contains COT, PM

Override & STA. The main functionality of this suite is to get the quotes

finalized and make those quotes available for the downstream systems like

Clarify & Oracle Apps. In addition to this, the discounts on a quote can

also be controlled. The Sales Team maintenance is also done through this

suite of applications.

Responsibilities:

> Providing proactive support to application by checking interfaces,

tables and concurrent requests for any data integrity issues and

fixing the same before releasing the system to users.

> Providing support for all application issues including Sev1, Sev2,

Sev3 and Sev4.

> Involved in developing Utility tools using SQL, PL/SQL (Procedures,

Functions and Triggers) and UNIX scripts for Maintenance activities.

> Handling tickets raised by the users of system and provide the

required information to the user

> Support and Development of shell scripts for UNIX batch jobs checking

concurrent program script.

> Production support work for Month end processing of Oracle

Application.

> Performed Configuration Management using PVCS and VSS

Environment: Oracle Applications 11i, Reports 6i, PL/SQL, Unix Shell

Scripting, Microsoft Access, Oracle 8i / 9i, Windows NT, Windows2k/Windows

NT4.0/Windows 9x, UNIX, HP 9000 servers, Pentium PCs connected to the

STARBASE LAN (Local Area Network) and to the local network.

Tools: SQL* PLUS, TOAD, SQL*Loader, MS-VSS, PVCS (QVCS) and Dimensions,

Remedy

Client: QWEST INTERPRISE INC, Minneapolis, MN Jan

2004 - Jun 2004

Project: Integrator

Role: Quality Analyst

Integrator is the backbone for provisioning of QWEST broadband services

like Cell Relay. Megabit Services. It supports the inventory, provisioning

and service assurance of the QWEST ATM/FR products and services. The system

was implemented on Visual works Smalltalk v3.0 on Windows NT, Sun Solaris

with Oracle 7.3.4 as the database.

Responsibilities:

> Involved in developing automated tools using shell scripts and Perl

scripts for executing the regression testing.

> Involved in developing automated tools using shell scripts and Perl

scripts for test data setup.

> Experience in Performing the Functional testing based on the Changes

in the Application functionality for quarterly releases.

> Performed regression testing for all releases.

> Experience in configuring the Test lab and test environment

administration.

> Tracked application defects using defect-tracking tools - Mercury

Quality Centre.

> Participated in End-to-End testing of the mass-market flow.

> Participated in UAT and go-no decisions during the release meetings

> Participated in User Stories discussion with Business and Development

team

Environment: HP-UX 11.0, Sun Solaris, Windows NT, K-shell scripts, SQL,

PL/SQL, Oracle 7.3.4, Exceed - for telnet, Citrix Client

Tools: SQL*PLUS, PL/SQL Developer, EZSQL, MS-VSS (for source code control),

QVCS and DIMENSIONS, TOAD

Client: QWEST Communications, Denver, CO, U.S.A. Feb

2001 - Dec 2003

Project: K2RCMAC GUI

Role: Quality Analyst

K2RCMAC GUI is a tool for automating the Manual correction of rejected and

pending MARCH orders due to wrong order formatting or misuse of USOCs.

K2RCMAC gathers the pending orders from different MARCH systems and stores

it in its own database. It will send the pending orders to the users for

correction according to the priority set to the orders. The users can

receive the orders in IWS (Intelligent WorkStation) where they are doing

their correction of unformatted orders and send it back to the MARCH

system.

K2 RCMAC is a tool that runs on desktop computer. It allows the user to

request the manual work that is not handled by the follow-through

provisioning system, in a simplified, priority order. K2 RCMAC IWS

decreases the time it takes to do manual input and reduces the possibility

of input error.

Responsibilities:

> Involved in developing automated tools using shell scripts and Perl

scripts for executing the regression testing.

> Involved in developing automated tools using shell scripts and Perl

scripts for test data setup.

> Performed the Functional testing based on the Changes in the

Application functionality for quarterly releases.

> Performed regression testing for all releases.

> Experience in configuring the Test lab and test environment

administration.

> Tracked application defects using defect-tracking tools - Mercury

Quality Centre.

> Participated in UAT and go-no decisions during the release meetings

> Participated in Requirements discussion with Business and Development

team.

Environment: SunOS 5.7, WIN NT Server, K-shell scripts, SQL, Sybase 11.0,

VSS, K2RCMAC, Dimensions - for Configuration, Exceed - for telnet, Citrix

Client

Tools: WINSQL, Putty, MS-VSS (for source code control), QVCS and DIMENSIONS

[pic]

Contact this candidate