Jaikishorebabu Karnam Karunakaran

acpnd9@r.postjobfree.com

+1-919-***-****

Experience Summary

8.8 Years of Professional IT experience in Data warehousing & Business Intelligence for

Insurance, Healthcare & Life sciences domains, involved in the complete SDLC for

custom tools/applications’ data migration, data Integration configurations based on

Informatica 7.1/8.6/9.6.1, Unix, Relational databases Oracle, SQL Server, DB2 and on

On Cloud Applications like Oracle On Demand (OOD), Sales Force data centre

(SFDC) using Informatica web services and SFDC Data Loader.

Proficient in Analyzing the Business Processes requirements and translating them into

technical requirements, design data architecture for data Integration/Migration,

dimensions data model.

Expertise on PL/SQL and UNIX shell scripting.

Worked on using Informatica Web services to integrate data to On cloud applications.

Proficient in Post production support activities with effective change management, scope

tracking and solving issues. Documenting of System Maintenance Technical document

(SMTD), Service design Plan (SDP), Service transition Plan (STP) documents for

each Support work order.

Highlights

• POC for Interacting Informatica Webservics with OOD application.

• Designed the Parallel Processing of Workflows

• Designed the Looping of workflows to pass small chunks of data to eliminate timeout

errors of web services.

• Automated the Remedy Ticket creation using Informatica web services reduced 2 PD

effort/month.

• Create the generic email success/failure UNIX script.

Skills

Data Warehousing Tools Informatica 7.1/8.6

Database Oracle 9i/10g, DB2,SQL Server 2005/2008,MS Access

Programming GUI SQL,PL/SQL,Unix Shell scripting

Tools/Utilities Toad,QMF,PL/SQL developer,vi editor

Scheduling Tools Tivoli Maestro scheduler(TWS),In Process Manager(IPM)

Configuration Management Visual source safe(VSS), Team Foundation Server(TFS)

External Data Loaders SFDC data Loader, Soap UI

Business Domain Insurance, Pharmaceutical

Page 1 of 4

Personal details:

First Name : JAI KISHORE BABU

Last Name : KARNAM KARUNAKARAN

H1 status : Valid I797 Petition till 07/18/2016

Qualification : B.Tech, JNTU Anantapur

Projects

1. TycoIS-EIM Support

The TycoIS EIM (Enterprise Information Management) Data Warehouse stores a consolidation of

business data coming from the organization’s major production systems like Oracle EBS, Siebel,

ADMIN, CARMS systems and from the third party tools like mastermind, get paid. TycoIS EDW is

the foundation for the creation of strategic reporting systems that are used to help manage and

control the business. Primarily Informatica ETL Load processes and scripts are single point of

solution to Business to consolidate all applications data for analysis and decision making. All

reports are pulled from Informatica through various Reporting technologies like Business objects.

Responsibilities:

Single point of contact for Tyco for all Wipro services and eliverables.

Perform day to day development activities to drive towards the completion of

project tasks and furnish the delivery units within schedule.

Review of Wipro deliverables

Assisting Tyco IT team for deployment activities

Participate in review meetings

Resolve issues and provide clarification to customer in a timely manner

Coordinate with offshore team for clarifications and work load sharing

2. GlaxoSmithKline- Gross2Net (11/19/2012 09/26/2014)

BPI Revenue Management & Revenue Recognition Suites is a vendor application that GSK plans

to use for to model and develop their long range revenue forecast. GSK must develop and deliver

daily feeds of contract, pricing and discount information.

Role: Technical Lead

Responsibilities:

Understand the Business requirement and convert them to Technical

specifications.

Built the Reusable components like

• Automation of Remedy Ticket Creation using Informatica Web services.

• Generic email Unix script.

• Generic PL/SQL Procedure to capture/validate the data counts.

Reviewing the mappings, unit test cases, tracking and solving the defects

occurring during the different phases of the Software Development life cycle.

Communicating with the customers on the ongoing Business changes and

implementing them.

Page 2 of 4

Environment: Informatica 8.6,Oracle 11g,SQL server 2008,Unix,Toad,PL/SQL

developer,TFS, vi editor.

3. GlaxoSmithKline-NACRM FFE(Support)-(01/02/2012-12/31/2012)

Application Support services to GSK NA Pharma IT for CRM (GSK 360) FFE R2 OOD

Enhancements (“the Application”),Customer Relationship Management” or “GSK 360” application

used by NA Pharma Field Force Enablement and Contact Center teams.

Role: Application Lead

Responsibilities:

Post production support activities with effective change management and scope

tracking and solving issues.

Suggesting Service Improvement Plans (SIP) to increase the job cycle

performance.

Documenting of System Maintenance Technical document (SMTD), Service

design Plan (SDP), Service transition Plan (STP) documents for each Support

work order.

Communicating and coordinating with different system teams like IPM, DBA,

upstream/downstream teams on time if have any Issues.

Environment: Informatica 8.6,Oracle 11g,Unix,Toad,PL/SQL Developer,IPM/TWS,Soap

UI,vi editor,VSS.

4. GlaxoSmithKline-NACRM FFE(Dev)-(12/20/2010-01/01/2012)

NA CRM FFE (Field Force Enablement for Customer Relationship Management) Data Integration

is an On cloud application for Oracle On Demand(OOD) to develop next generation Field Force

tool to enable account based calendar management, call activity tracking, visibility to basic

customer hierarchy and basic sales reporting used by NA Pharma Field Force Enablement and

Contact Center teams.

Role: Application Lead

Responsibilities:

Understand the Business requirement and convert them to Technical

specifications.

POC for migrating the data to OOD application using Informatica web services.

Built the Reusable components like

• Separate OOD application login and logout mapping/sessions using

Informatica Web services.

• Increase the performance of the informatica jobs by implementing

looping logic and parallel processing in interacting with the OOD

application.

Reviewing the mappings, unit test cases, tracking and solving the defects

occurring during the different phases of the Software Development life cycle.

Environment: Informatica 8.6,Oracle 11g,Unix,Toad,PL/SQL Developer,IPM/TWS,Soap

UI,vi editor,VSS.

5. Honeywell EAS SFDCHONEYWELL (05/27/2010 11/19/2010)

The purpose of the integration is to migrate the existing data set belongs to specific Business

Process to Salesforce.com.

Page 3 of 4

6. Farmers Insurance Group EFBI R2A (10/14/2009 05/12/2010)

This project collects data from FPPS System that is applicable to Home Quote

(FIRE) such as information about the Quote,Dwelling,mobile home etc structure it

so it can be reported, and provide analysts with the ability to query and report

quote information. The ability to perform these functions will enable the analysts

to measure the effectiveness of price actions and their impact on loss

performance and retention.

7. Hanover Insurance Group Home Quote Analytics and Account Analytics

(04/14/2008 10/12/2009)

This project collects quote data from POS that is applicable to Home Quote such

as information about the Quote, Prospect, Primary Residence etc structure it so it

can be reported, and provide analysts with the ability to query and report quote

information.

8. Hanover Insurance Group Upgrade Testing (05/13/2007 04/11/2008)

As Part of Conversion of Informatica version from 7.1 to 8.6,the existing

Production schedules running on Unix Arsenal Server in Informatica 7.1 are

moved to the New Linux Server LXPR2PC.

9. Hanover Insurance Group Personal Lines PL Auto Quote Analytics (09/21/2006

05/11/2007)

As a standard, all reference data used in the EDW must be stored in versioned

tables in the EDW.On a daily basis, each of the tables will be brought into the

EDW reference tables and the data in these tables will be versioned.

Role: ETL Developer

Responsibilities

Writing the SQL Scripts for extracting data in the application and applying those

Scripts in the Database of the Application according to the Requirement.

Developing the Informatica Objects and unit testing.

Supporting the application in Warranty Period.

Environment: Informatica 7.1/8.6,Oracle 10g, UNIX, Toad, QMF, Tivoli Maestro

Scheduler, vi editor, VSS.

Page 4 of 4

Contact this candidate