Sai Kiran Kondraju

413-***-****

Sr. Informatica Developer/Admin/Architect

acfsa5@r.postjobfree.com

SUMMARY:

. 10 years of experience in the Complete Lifecycle and Administration of

Informatica applications/infrastructures using industry accepted

methodologies and procedures.

. Good requirements containment skills, and efficient project management

ensuring containment of scope, deliverable management and ensuring

high customer satisfaction.

. Project Development and Infrastructure Administration with main roles

as Project Lead, Technical Architect and Lead Informatica

Administrator.

. Experience in leading teams to successful project implementation with

proper management, engagement with top management, scope containment,

and Quality assurance.

. Experience working in Onsite, Offshore model. Experience leading a

team of developers and Administrators. Mentor team of developers and

Administrators.

. Experience on Response to RFP.

. Aptitude for analyzing, identifying problems and coming with out of

the box solutions.

. Ability to achieve organizational integration, assimilate job

requirements, employ new ideas, concepts, methods, and technologies.

. Excellent communication, interpersonal and analytical skills.

. Self-motivated, quick learner and adaptive to new and challenging

technological environments.

KEY ACHIEVEMENTS:

. Managed and Lead several Informatica Projects right from SDLC phases

like Requirement Analysis, Design, Coding, Unit Testing and Support

during UAT/Warranty Support

. Extensively worked on ETL projects using Informatica (PowerCenter

7x/8x/9x), PL/SQL and Unix Shell Scripting.

. Lead a Informatica Administration team for carrying administrative and

support tasks across 40+ domains in 8x/9x versions which are hosting

400+ Informatica applications.

. Implemented Informatica Data Quality 9.1 and Metadata Manager

. Lead Setup Informatica cloud environments and develop standards across

installation and development of Informatica cloud tasks.

. Setup of Composite Environments along with load balancing.

. Experience of leveraging ITIL V3 processes

. Often worked in different projects for fire-fighting cases wherein

rapid development and understanding skills are needed.

. Worked on open source ETL technologies such as JASPERETL (ETL tool)

and MySQL

. Worked on Microsoft technologies such as SSIS and SQL Server.

. Have knowledge of Scheduling tools like Autosys, Crontab

. Have knowledge of Web Technologies including Java and .NET.

. Awarded DW DON Award, which is a global award at Cognizant Technology

solutions.

. Received several "Special contribution towards project excellence

(SCOPE)" awards

EDUCATIONAL SUMMARY:

. Bachelor of Technology (Computer Science Engineering) from

JNTU, India

CERTIFICATIONS

. Oracle certified Associate

. RDBMS Concepts(Brain Bench)

. UNIX Korn Shell Scripting(Brain Bench)

TECHNICAL SKILLS :

ETL Tools : Informatica Power Center 7.1/8.6/9.1/9.6,

Informatica Power Exchange 9.1,

Informatica Data

Quality 9.1/9.5, Informatica cloud, Metadata Manager,

Power exchange for

Mainframe/SAP/Webservices/Netezza, JasperETL. SQL

Server Integration Services(SSIS).

EAI Tools : Composite 6.1

LANGUAGES : SQL, PLSQL, UNIX Shell Scripting,

TOAD, UC4, Autosys, Dot Net, Java, XML, HTML,

Visual Source Safe, subversion, C++.

DATABASES : Oracle 8i/9i/10, Teradata 13.0, MySQL, Microsoft SQL

Server 2005/2008, DB2.

OPERATING SYSTEMS : UNIX, RedHat Linux 5.8, Windows 7/Vista/XP/2008

EMPLOYMENT HISTORY:

V-Soft Consulting

Jul 2013 - Till date

Associate

Neat Company,Philadelphia, PA

Apr 2014 - Till Date

Project: Customer Datawarehouse Informatica

Architect/Admin/Developer

Neat company transforms digital and paper documents into useful, organized

information. Their integrated system of software, hardware, cloud service,

and mobile app makes it easy to acquire, search, share, and access your

most important information - anywhere, anytime.

Neat company had a requirement for building Customer Datawarehouse to

provide single version of Customer data. This project involved integration

of data from Various data sources such as Netsuite, Neatcloud, Netsuite CRM

etc and load into Datawarehouse built on MySQL.

Responsibilities:

. Interaction with Business users from various departments to understand

their requirements and current challenges

. Analyze data from various data sources such as Netsuite, Netsuite CRM

and Neatcloud(Mongo DB) data

. Identify right tools and configurations for accessing the data from

Netsuite and Neatcloud

. Explored various ETL tools and identified Informatica Powercenter

Enterprise edition tool for CDW project.

. Executing proof of concepts on PowerCenter Express tool and check

whether it will meet all client requirements or not.

. Designed and implemented Informatica Powercenter 9.6 infrastructure

on windows server 2012

. Designed and Developed Star Schema for Customer Datawarehouse on

MySQL.

. Development and Testing of mappings for Dimensions such as Customer,

Product etc and Facts such as Transactions etc.

. Leveraged Perl scripting on automating Informatica Daily load

processes

. Developed custom scripts to extract files kept on Amazon S3.

. Backup and restore of Informatica repositories.

. Create Users and Groups for granting access to users.

. Migration of Informatica code across DEV/TST/PROD environments.

. Performance tuning of code.

Environment: Informatica 9.6 Enterprise/Express, Netsuite, MySQL, JIRA,

Windows Server 2012. Perl

Shire Pharmaceuticals, Chesterbrook, PA

Nov 2013 - Mar 2014

Project: BI COE Sr

Informatica Consultant

BI COE stands for Business Intelligence Center of Excellence. This project

involved Administration of Informatica and UC4 along with Design and

development.

Responsibilities:

Informatica:

. Administration of 9.0.1/9.5 Informatica infrastructure which includes

PowerCenter, Data Quality, Powerexchange etc

. Creating Groups, roles, privileges and assigned them to each user

group.

. Creating Folders and manages user and user group access to objects in

the repository

. Migration of objects in all phases (DEV, SIT, Prod and Post Prod) of

projects

. Used JIRA for tracking work such as Service Request, Incident

Management and Work Requests.

. Administered Model Repository service, Data integration service and

Analyst services for Informatica Data Quality 9.1

. Stopping/starting Informatica Repository and Server processes.

. Worked with clients / storage /Unix / DBA teams to resolve issues

. Solved various Production issues of Application teams

. Opening Informatica SRs (support requests) and working along with the

Informatica Global support to troubleshoot failures

. Responding and Resolving Requests, incidents, problems submitted by

Application teams within SLA

. Prepared documents for Requirements, Design, Unit Testing, Deployment

etc

. Designed and developed ETL Mappings, Sessions and Workflows based on

the requirements

UC4:

. Creating UC4 tasks for transferring files, Archiving files on Windows

and LINUX platforms.

. Creating UC4 tasks for invoking Informatica tasks.

. Building, Testing, Migration and Support of UC4 tasks along with

documentation.

. Creation of users and groups and granting privileges to them.

. Supporting users for UC4 Issues.

. Maintenance of UC4 infrastructure.

Environment: Informatica 9.0.1/9.5, UC4 V6/V9, Informatica Data Quality

9.0.1/9.5, JIRA, LINUX, putty, Netezza

Hibu, King of Prussia, PA

Jul 2013 - Oct 2013

Project: Data Integration Team

Sr Informatica Consultant

Leading Informatica Admin team for administering Informatica

infrastructure. This is a GRID Informatica infrastructure with several

components. Apart from leading Informatica Admin team, I had worked on

Requirement Analysis, Designing, Development, Testing and Support of

several Informatica projects.

Responsibilities:

. Administration of 9.1 Informatica infrastructure which includes

PowerCenter, Data Quality, Powerexchange etc

. Installed Powerexchange of Netezza and SAP.

. Analyzed Risks, Suggested Recommendations and implemented Best

Practices on Informatica infrastructure

. Backup and Restoring of Informatica Repository and security

administration

. Partner and interface with development teams to resolve issues and

also with other infrastructure teams such as UNIX, DBA, Disaster

Recovery and Production Support teams

. Creating Groups, roles, privileges and assigned them to each user

group.

. Creating Folders and manages user and user group access to objects in

the repository

. Involved in migration of objects in all phases (DEV, INT and PRD) of

projects

. Administered Model Repository service, Data integration service and

Analyst services for Informatica Data Quality 9.1

. Implemented Data Quality 9.1 and executed operations such as

Profiling, Standardizing, Parsing, Validating and Duplicate

Identification of customer data

. Implemented new Address files for Address Doctor in Data Quality.

. Built a Metadata queries for maintaining an Audit table for all

Informatica workflow runs, identifying dependencies of

Sources/Targets/Lookups.

. Translated the Business Requirement Documents (BRD) and Function

Specification Document (FSD) and laid out the solutions for the data

extraction, business logic implementation & target loading strategies.

. Extract, Transform and load of data from variety of Sources to

datawarehouse built on Netezza.

. Leveraged Bulk load for loading huge volume(in Terabytes) of data into

Netezza database

. Performance tuning of Long running Informatica processes.

. Built reusable scripts on LINUX for transferring files files from one

server to Informatica server.

. Stopping/starting Informatica Repository and Server processes.

. Leveraged Shell Scripting in UNIX and LINUX for automating several

tasks such as Back up of repositories and domain etc.

. Extensively experience on UNIX shell scripts on automation (Auto

restart of servers, Disk space utilization, Informatica Server

monitoring and UNIX file system maintenance and cleanup, and scripts

using Informatica Command line utilities.

. Defining Informatica standards and best practices for Development and

support

. Proof of Concepts on new technologies, new Informatica features.

. Help application teams in improving efficiency of ETL Processes.

. Worked with storage/Unix/ DBA teams to resolve issues and perform

Root Cause Analysis

. Maintenance of NAS, SAN and Veritas file systems on LINUX servers

. Solved various Production issues of Application teams

. Opening Informatica SRs (support requests) and working along with the

Informatica Global support to troubleshoot failures

. Responding and Resolving Requests, incidents, problems submitted by

Application teams within SLA

. Proficient in various communications protocols (SSH, SFTP)

. Add and update ODBC entries

Environment: Informatica 9.1, Informatica Power Exchange 9.1, Informatica

Data Quality 9.1, SQL,PL/SQL,Unix, putty, Netezza, Oracle, Toad

Cognizant Technology Solutions

Apr 2006 - Jun 2013

Associate

MERCK Co & Inc Whitehouse Station, NJ

Apr 2012 - Jun 2013

Project: EIM Engineering team

Informatica Admin/Architect

MERCK is one of the top pharmaceutical companies in lifesciences domain.

Leading Informatica Engineering team, which is a dedicated team for

executing proof of concepts, identifying new features, building ETL/EAI

Infrastructures, as per ITIL standards and Design/Development of

Informatica projects

Responsibilities:

Informatica:

. Done End to End Implementation Informatica installation across UNIX

and LINUX platforms.

. Upgrade of Informatica environments from 9.1 to 9.5

. Handling migration and complex upgrades working on development, QA

and production environments

. Reducing maintenance needs, improving reliability, reducing execution

time and performance tuning and monitoring of Informatica

Environments.

. Proof of Concepts on new technologies new Informatica features

(Metadata Manager etc).

. Installation, configuration and administration of Metadata Manager.

. Resolving performance related issues

. Resolve Infrastructure/application related issues

. As a member of COE, Review Design/Code of Informatica applications.

. Reusability across Integrations

. Adhere standards across Integrations

. Optimize Architecture and design solutions

. Reviewed requirements for completeness and accuracy.

. Implemented an Informatica based ETL solution fulfilling stringent

performance requirements.

. Conducted impact assessment and determine size of effort based on

requirements.

. Identify, recommend and implement ETL process and architecture

improvements.

. Developed project plans to implement ETL solution and identify

resource requirements.

Informatica Cloud:

. Implementation of 19 Informatica cloud environments on Windows 2008

servers for various divisions in MERCK.

. Installed Teradata and Oracle clients for providing ability to

interact with Oracle and Teradata Clients

. Worked on several Proof of Concepts

. Installed Apache for sharing files on Windows 2008 servers

. Design and development of Informatica cloud tasks to extract,

transform and load data for Various Sources and Targets

. Established Coding standards and Naming Conventions to be followed for

Informatica Cloud Development

. Paper Presentations and Demo on Informatica cloud

. Support for user related issues.

Composite:

. End to End Implementation of Composite Information server environments

on LINUX servers.

. Cluster configuration and load balancing on Test and Production

environments.

. Following ITIL process for implementing Composite environment

. LDAP Configuration for enabling users to login using Merck Network

password

. Migration of Composite repository from MySQL to Oracle.

. Installation of patches for Composite environment.

Environment: Informatica 9.1, Informatica Cloud, Windows 2008 server,

SQL,PL/SQL, Unix, Redhat Linux 5.8, putty, Teradata tools and utilities,

Toad, Composite 6.1

MERCK Co & Inc Whitehouse Station, NJ

Jan 2010 - Mar 2012

Project: Informatica Admin

Informatica Admin lead

Lead a team of 8 Informatica Administrators across US, India & Argentina

for carrying administrative and support tasks for 40+ domains in 7x/8x/9x

versions, as per ITIL standards. 400+ Informatica applications are lying in

these Infrastructures and we support a user base of 1000+ users.

Responsibilities:

. All the Administrative tasks for 60+ Informatica repositories

belonging to Informatica version (7.1.4/8.6.1/9.1) on UNIX/LINUX

hardware's across North America/Asia Pacific and EMEA locations.

. Installation, Configuration and Administration of Informatica

Environments.

. Configured High Availability/GRID for Informatica Environments.

. Backup and Restoring of Informatica Repository upgrades and security

administration

. Upgrade of Informatica environments from 7.x to 8.x and 8.x to 9.x

. Applying Hotfixes

. Partner and interface with development teams to resolve issues and

also with other infrastructure teams such as UNIX, DBA, Disaster

Recovery and Production Support teams

. Creating Groups, roles, privileges and assigned them to each user

group.

. Creating Folders and manages user and user group access to objects in

the repository

. Involved in migration of objects in all phases (DEV, INT and PRD) of

projects

. Created and Configured Model Repository service, Data integration

service and Analyst services for Informatica Data Quality 9.1

. Implemented Data Quality 9.1 and executed operations such as

Profiling, Standardizing, Parsing, Validating and Duplicate

Identification of customer data

. Executed proof of concept for reading data from Oracle/Teradata and

load into Teradata database using Teradata tools and utilities.

. Maintenance of Disaster recovery environment

. Lead Application teams to Integrate Informatica with Teradata to

read/load data from Teradata.

. Maintaining Axway and Teradata tools and utilities

. Stopping/starting Informatica Repository and Server processes.

. Leveraged Shell Scripting in UNIX and LINUX for automating several

tasks such as Code Migration, Back up of repositories and domain etc.

. Extensively experience on UNIX shell scripts on automation (Auto

restart of servers, Disk space utilization, Informatica Server

monitoring and UNIX file system maintenance and cleanup, and scripts

using Informatica Command line utilities.

. Defining Informatica standards and best practices

. Proof of Concepts on new technologies, new Informatica features.

. Help application teams in improving efficiency of ETL Processes.

. Worked with clients / storage /Unix / DBA teams to resolve issues

. Configuring High Availability and Disaster Recovery of Informatica

Environments.

. Setting up Secure Shell Authentication(SSH) for logging in without

using a password

. Distribution of Scripts/Files across 30 UNIX environments using Secure

Copy(SCP)

. Used HP Quality Center 9.2 for running test cases

. Setup of NAS File systems and SAN file systems with standard

privileges

. Solved various Production issues of Application teams

. Opening Informatica SRs (support requests) and working along with the

Informatica Global support to troubleshoot failures

. Responding and Resolving Requests, incidents, problems submitted by

Application teams within SLA

. Proficient in various communications protocols (SSH, SFTP)

. Add and update ODBC entries

. Experience in PowerExchange for SAP, Webservices

. Create, backup, restore and DR for Informatica Repositories.

. Configuring LDAP Authentication.

. Standardize SDLC Documentation

. Review Design/Code

. Reusability across Integrations

. Adhere standards across Integrations

. Optimize Architecture and design solutions

Environment: Informatica 8.6/7.1/9.1, Informatica Power Exchange 9.1,

Informatica Data Quality 9.1, SQL,PL/SQL,Unix, putty, power exchange,

Axway, Teradata 13, Teradata tools and utilities 13, Toad, Remedy Tool

MERCK Co & Inc, Whitehouse Station, NJ

Jul 2009 - Dec 2009

Project: HtR Peoplesoft and ETL for SIC.

Lead Informatica Designer/Developer

Goal of this project is to replace the peoplesoft with the SAP system. This

would reduce the number of intermediate database objects, thus increasing

the maintainability and reducing the run-time of the project.The files

generated as part of this project will be sent to Bonus computation

projects for SIC(Sales Incentive compensation).

Responsibilities:

. Coordinated with source system owners to define required system

specifications and to define and obtain data extracts

. Developed logical and physical data model for the Staging and

Reporting requirement.

. Developed Coding Standards for ETL/Informatica development to simplify

and standardize Informatica code for this project.

. Designed, Implemented and documented error handling logic, which is

used in all mappings.

. Extracted data from sources like Oracle 10g and Flatfile transformed

the data according the business requirement.

. Created components supporting the Enterprise Data Architecture and

Design.

. Development of complex mappings using Informatica and

assignment/review of work done by team members.

. Leveraged oracle indexes and Informatica Partitioning to improve

performance of Informatica code.

. Deployed reusable transformation objects such as mapplets to avoid

duplication of metadata, reducing the development time.

. Responsible for performance tuning of Informatica transformations,

mappings and database performance tuning

. Automation of ETL processes with scheduling tools and exception-

handling procedures

. Optimize code performance by analyzing indexes, joins and views.

. Development of Complex PL/SQL stored procedures.

. Leveraged UNIX Script for dynamic generation of parameter files.

. Development and execution of ETL test plans.

. Preparing the necessary documents like Unit Test document, SOP and

Case study

. Extensively worked in the performance tuning of the programs and ETL

processes.

. Migration of code to various environments.

. Support for SIT/UAT/Production.

Environment: Informatica 8.6/7.1, SQL and PL/SQL, UNIX shell scripting and

Flat files

MERCK Co & Inc Whitehouse Station, NJ

Jul 2009 - Dec 2009

Project: PTRS Lead SSIS

Designer/Developer

PTRS stands for Probability of technical and regulatory sources. Evaluates

the probability of success for projects created with a combination of

Compound and Indication.

Responsibilities:

. Responsible for gathering and analysis of business requirements for

development.

. Build efficient SSIS packages for processing fact and dimension tables

with complex transforms and type 1 and type 2 changes.

. Lead Project Planning & Effort Estimation.

. Implemented Agile methodologies to deliver project in small chunks

. Participated in daily standup meeting to discuss on project updates

and deliverables.

. Created Jobs and scheduled Packages using SQL Server Management Studio

for the Daily Load.

. Designed, developed and documented Data flows and Control flows

. Assignment/review of work done by team members.

. Conducted code walkthroughs and review peer code and documentation.

. Performing the Unit Testing

. Preparing the necessary documents like Unit Test document, SOP and

Case study

. Support for SIT/UAT/Production.

Environment: SQL Server 2008, SSIS

MERCK Co & Inc Whitehouse Station, NJ

April 2009 - Jun 2009

Project: RoADS

Lead SSIS Designer/Developer

RoADS stands for Repository of authoritative data sources. The data from

several diversified database source systems would be consolidated into

one database and RoADS database would be identified as "Single point of

truth" data.

Responsibilities:

. Responsible for gathering and analysis of business requirements for

development.

. Lead Project Planning & Effort Estimation.

. Developed ETL processes using MS SQL and SSIS.

. Implemented Agile methodologies to deliver project in small chunks

. Participated in daily standup meeting to discuss on project updates

and deliverables.

. Created Jobs and scheduled Packages using SQL Server Management Studio

for the Daily Load.

. Designed, developed and documented Data flows and Control flows

. Assignment/review of work done by team members.

. Performing the Unit Testing

. Preparing the necessary documents like Unit Test document, SOP and

Case study

. Support for SIT/UAT/Production.

Environment: SQL Server 2008, SSIS, Agile methodology

Merck Sharp and Dohme, Whitehouse Station, NJ

Nov 2008 - Mar 2009

Project: JADE (Joint Asian Diabetes evaluation) Reporting Module

Lead JasperETL Designer/Developer

Goal of this project is to develop the Reporting Module solution for the

JADE managed patient care application. This includes Design and development

of star schema along with creation and loading aggregate tables for

Reporting. The reporting module needs to be integrated to JADE portal.

Responsibilities:

. Analyzing Source System data and Requirement Analysis.

. Designed end to end ETL architecture & developed Coding Standards for

ETL development to simplify and standardize code for this project.

. Created components supporting the Enterprise Data Architecture and

Design.

. Designed and created Star Schema

. Develop functional specification, High Level Design and Technical

Specification.

. Work with Reporting team to get to an agreement on what level of

complexity to be handled by ETL and reporting side.

. Design, creation and loading of Aggregate tables for generating Jasper

Reports quickly.

. Development of complex mappings using JASPERETL and assignment/review

of work done by team members.

. Coordinating with client managers/leads at different locations(US,

Australia, Hong Kong)

. Development of Source to Staging and staging to Target jobs.

. Performing the Unit Testing

. Preparing the necessary documents like Unit Test document, SOP and

Case study

. Extensively worked in the performance tuning of the programs and ETL

processes.

. Involved in testing support and bug fixes.

Environment: JasperETL, MySQL & UNIX.

Callidus Software (a vendor for Merck) Whitehouse Station, NJ

June 2007- Oct 2008

Project: HHICT (Human Health Incentive compensation tool)

Informatica Designer/Developer

Goal of this project is to develop the TrueComp incentive compensation

system to provide the Client bonus group and business users with the

ability to check for bonus eligibility for the sales organizations in USHH

and MVD divisions and to administer and calculate sale incentive plan (SIP)

bonuses. Callidus is a third party vendor of MERCK.

Responsibilities:

. Requirement analysis and design of project

. Development of complex mappings and assigning and review of work done

by team members.

. Developing SQL overrides in source Qualifier according to business

requirements.

. Analyzing Source System data and Information.

. Working on Informatica - Source Analyzer, Warehouse Designer, Mapping

Designer, Mapplet and Transformations.

. Prepared Unix shell scripts for automation and performance tuning

. Support other ETL developers; providing mentoring, technical

assistance, troubleshooting and alternative development solutions

. Involved in the development of Source to Staging and staging to Target

Mappings.

. Created Datamaps in Informatica PowerExchange and extracted data from

DB2

. Troubleshoot the data and performance issues raised by user community,

designed, developed and deployed the code to fix them.

. Preparing the necessary documents like Unit Test document, SOP and

Case study

. Extensively worked in the performance tuning of the programs and ETL

processes.

. Involved in support for testing and bug fixes.

Environment: Informatica Power Center 7.1, Informatica Power exchange 7.1,

SQL, UNIX, DB2, Oracle 9i database, Flat files, Crontab

MERCK Co & Inc Whitehouse Station, NJ

Dec 2006 -May 2007

Project: GR DSS (Government Reporting Decision Support System)

Informatica Developer

The purpose of GR DSS is to calculate Product Prices for all prior years of

history and all the monthly, quarterly and yearly time periods. Integrate

information from diverse databases and do a data conversion and populating

the target tables. The ETL Part involves loading the data from data sources

into the Staging area and then into the Target Tables.

Responsibilities:.

. Analyzing and understanding sources of fixed width Flat files, DB2

Tables, SQL server, Oracle, and target with Oracle.

. Involved in Designing Mapping documents, which include details of

field-to-field mapping between sources and target, Business

(Transformation) Rules, Processing flow and details of sessions, pre-

dependencies, post-dependencies, and exception error processing

methodology

. Developing Mappings as per the design document with proper naming

conventions for transformations and Mapping variables.

. Implemented transformation logic using Informatica 7.1.2, working with

Transformations such as Router, Lookup (connected & unconnected),

Update Strategy, Source Qualifier, Joiner, Expression, Aggregator and

Sequence generator.

. Developed number of Complex INFORMATICA Mappings, Mapplets and

Reusable Transformations for the GRDSS Systems to facilitate daily,

monthly and yearly loading of data.

. Prepared Unix shell scripts for automation and performance tuning

. Involved in the development of Source to Staging and staging to Target

Mappings.

. Performing the Unit Testing

. Preparing the necessary documents like Unit Test document and SOP.

. Extensively worked in the performance tuning of the programs and ETL

processes.

. Involved in testing support and bug fixes.

Environment: Informatica Power Center 7.1, Informatica Power Exchange 7.1,

SQL, Unix, Oracle 9i database, Flat files, Mainframe files.

MERCK, West Point, PA

June 2006 - Nov 2006

Project: MERLIN

Informatica ETL Developer

The Merlin BI project involves populating data for implementing a flexible

reporting environment that provides access to Merlin HQ, which includes

Tactics and DS Usage modules. The purpose of building Tactics metric was to

provide a mechanism for analyzing the tactics used by Sales Representative

to convince the prescriber about the current product. The purpose of DS

Usage was loading of the DS Usage tables that are used in the reporting

front end.

Responsibilities:

. Analyzing and understanding sources of fixed width Flat files, DB2

Tables, SQL server, Oracle, and target with Oracle.

. Developed ETL processes to load data from SQL Server, Flat files into

the target Oracle database by applying business logic on

transformation mapping for inserting and updating records when loaded.

. Developing Mappings as per the design document with proper naming

conventions for transformations and Mapping variables.

. Developing Tasks/Sessions and workflows as required with session

variables.

. Performance tuning of Informatica workflows

. Working on Informatica - Source Analyzer, Warehouse Designer, Mapping

Designer, Mapplet and Transformations.

. Prepared Unix shell scripts for automation and performance tuning

. Involved in the development of Source to Staging and staging to Target

Mappings.

. Used most of the Transformations such as Source Qualifier, Aggregator,

Lookup, Filter, Sequence generator, Update strategy etc.

. Created Datamaps in Informatica PowerExchange

. Performing the Unit Testing

. Preparing the necessary documents like Unit Test document and SOP.

. Extensively worked in the performance tuning of the programs and ETL

processes.

. Involved in testing support and bug fixes.

Environment: Informatica Power Center 7.1, Informatica Power Exchange 7.1,

SQL, PL/SQL, UNIX, DB2, Oracle 9i database, Flat files.

2. Trezure Infosystems, India

Dec 2004 - Mar 2006

Software Engineer

Kotak Mahindra, India

Jun 2005 - Mar 2006

Project: INVRM (Investment research Module)

Informatica ETL Developer

Kotak Mahindra is an investment bank serving institutional, corporate,

government and individual clients. Their business include trade finance,

Asset based Finance, Working capital finance, Loans. Banks are information-

intensive and highly dependent on information technology as it critically

dependent on reports for bank operations. It needs Business Intelligence

reports for taking decisions.

Responsibilities:

. Analyzing and understanding sources of fixed width Flat files, SQL

server, Oracle, and target with Oracle.

. Involved in ETL processes to load data from SQL Server, Flat files

into the target Oracle database by applying business logic on

transformation mapping for inserting and updating records when loaded.

. Designing Mapping documents, which include details of field-to-field

mapping between sources and target, Business (Transformation) Rules,

Processing flow and details of sessions, pre-dependencies, post-

dependencies, and exception error processing methodology

. Developing Mappings as per the design document with proper naming

conventions for transformations and Mapping variables.

. Working on Informatica - Source Analyzer, Warehouse Designer, Mapping

Designer, Mapplet and Transformations.

. Prepared Unix shell scripts for automation and performance tuning

. Involved in the development of Source to Staging and staging to Target

Mappings.

. Used most of the Transformations such as Source Qualifier, Aggregator,

Lookup, Filter, Sequence generator, Update strategy etc.,

. Performing the Unit Testing

. Preparing the necessary documents like Unit Test document and SOP.

. Extensively worked in the performance tuning of the programs and ETL

processes.

. Involved in testing support and bug fixes

Environment: Informatica Power Center 7, SQL, UNIX, Oracle 9i database,

Flat Files

RPG LifeSciences, India

Dec 2004 - Jun 2005

Project: PSAT(Pharma Sales Analysis Tool)

Informatica ETL Developer

RPG LifeSciences is a provider of quality pharmaceuticals and health care

products. The project deals with the Sales and Marketing Data collected

from different tests conducted on the subjects. The data is then

consolidated into the data mart which is used for the report generation.

Responsibilities:

. Extracted data from Oracle, Fixed width and Delimited Flat files

Transformed the data according the business requirement and then

Loaded into Oracle database.

. Modified several of the existing mappings and created several new

mappings based on the user requirement.

. Working on Informatica - Source Analyzer, Warehouse Designer, Mapping

Designer, Mapplet and Transformations.

. Prepared Unix shell scripts for automation and performance tuning

. Created reusable transformations and Mapplets and used them in

mappings

. Involved in the development of Source to Staging and staging to Target

Mappings.

. Used most of the Transformations such as Source Qualifier, Aggregator,

Lookup, Filter, Sequence generator, Update strategy etc.,

. Performing the Unit Testing

. Preparing the necessary documents like Unit Test document and SOP.

. Extensively worked in the performance tuning of the programs and ETL

processes.

. Involved in testing support and bug fixes.

Environment: Informatica Power Center 7, SQL, UNIX, Oracle 9i database.

Contact this candidate