Sr ETL Informatica developer
Resume:
Jaikishorebabu Karnam Karunakaran
**********.***@*****.***
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