Project Data
Resume:
Sai Kiran Kondraju
Sr. Informatica Developer/Admin/Architect
***.*.********@*****.***
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