Professional Summary:

• 12 years of IT experience, related to various aspects involving analysis, design, development, testing and administration of Data warehouse applications using Informatica suite of products.
• Worked extensively on Data warehousing, Production Support and Data Migration projects using ETL Tools Informatica 5.1/6.2/7.1/8.1/8.6.5/9.0.1/9.1/9.5 for about 6.8 years as a developer Development and P.Support 6 Years as Informatica Administrator and DB2UDB 1.5 Years
• Worked on Informatica MDM HUB to Populate Master data that are uniquely identify an entity for various systems
• Worked onInformatica ILM tool to mask sensitive data on non production environment.
• Proficiency inInformatica administration like Installation, upgrade, migration, User management, back/restore, code promotion, OS Profiling, HA, GRID and LDAP etc.
• Proficiency in using tools like DB2 Load, Import, Export, Reorg, Runstats, Reorg Check, Backup/Restore, and Db2look.
• Having exposure to Hadoop Map Reduce, HDFS, Pig and Hive.
• Ability to work with all levels of end users in a help desk capacity.
• Worked extensively on production support, Strictly followed ITIL process
• Exposure to Healthcare, Retail and Manufacturing Domain
• Well versed in principles of organizational development, team facilitation, group process, leadership development and ability to analyze situation and offer cost innovative effective solutions.

Technical Skill:

Experience:

Lead Consultant

Confidential

Description:

• Confidential project provides managed services support for various applications of Sony. CDW is one of the
• projects under AMS which comprises of the Business intelligence and Data Warehousing applications
• of the client CDW provides a consolidated reporting on sales/Forecast and budget information of the
• organization. There are about 20 applications focusing on different subject areas like Customer data
• management, sales, forecast, freight billing, inventory reporting etc...

Responsibilities:

• WSR preparation and presentation to Client Managers.
• Analysis and Estimation for new requirements based on the discussion with the Business Team.
• Lead the onsite team and Co-ordination with the offshore team
• Monitoring of the ETL batch jobs and fixing the job abends
• Enhancements of the existing ETL systems as per business requirement
• Performance tuning of the ETL jobs.
• Analyzing the data issues, finding out the root cause and providing the solutions
• Support of bug fixes and data issue reported
• Coordinate of day-to-day activities for the project and Interact with offshore team for project statusand issues.
• Informatica admin activities like creation of folders, Connections, user and assigning proper privileges.
• Migrating the code between different environments

Experience:

ETL Developer

Responsibilities:

• Developed Power Center mappings for cleansing the data based on the business rules.
• Huge Volume of CID data have been loaded in to landing tables for different countries in multiple groups.
• Written shell scripts to archive files that are older than 3 days.
• Setup ssh between Informatica server and Application server and wrote a script to sftp files periodically.
• Integral part of a huge team in providing consulting for the complete life cycle of MDM implementation on
• Informatica MDM 9.5.1.
• Performed GAP analysis onprior MDM solution including the data model and the user interface
• Documented the master entities, data types, referential integrity, foreign key relationships new business
• requirements that were proposed to tweak the earlier MDCP data model
• Designed the Data Model in the MDM Hub by creating Base Objects using schema import and manually adding
• rows based on customer requirements
• Defined foreign-key relationships for Base Objects that had multiple foreign keys and look up tables
• Defined MDCP, Contacts Information Directory CID sources in the System and Trust providing columns trust
• enable capability depending on the sources they are derived
• Defined landing tables and created staging tables for each base object depending on the sources
• Created one to one and one to many mappings between the Landing Staging Tables
• Designed developed multiple cleansing and standardization scenarios using source to target mappings
• Address Doctor and set validation rules accordingly.
• Created Hierarchies like World Region- Country in the Data Model by creating Entity Objects, Entity Types ,
• Hierarchies Relationship Base Objects, then created profiles to be utilized for IDD also Data Stewards
• Created Batch Groups executed them manually worked with other teams to createcustom stored procedure
• scripts to perform automation of batch group execution
• Monitored Batch job error debug and handling, Release Management, schema exports, imports, changelists and
• Validation using metadata manager

ETL Administrator/Developer

Responsibilities:

• Migrate existing ETL processes from IBM Warehouse Manager to InformaticaPowerCenter 9.1 with sources and targets that include, but are not limited to, DB2, Oracle and flat files.
• Migrate all applicable supporting processes, programs, and scripts from AIX to Linux
• Cross systems integration in support of end to end ETL processing.
• Document and execute unit and system testing of migrated processes.
• Coordinate with support team on administrative issues relating to PowerCenter 9.1 environment.
• Document/populate pertinent metadata for objects migrated to PowerCenter 9.1.
• Prepare administration and operations handbook for new ETL environment on PowerCenter 9.1.
• Installed and configured Power Center 9.1 fixpack 4
• Migrated Informatica to new server.
• Have implemented PowerCenter LDAP configuration and migrated all Native users to LDAP.
• Implemented OS profiling as it is shared environment.
• Created Informatica queries and shell scripts for code migration.

Environment:Informatica 9.1, DB2 UDB v9, Oracle 11g, SUSI Linux, HP Quality Center and IBM Warehouse Manger

ETL Developer

Description:

is a leading retail pharmacy which is continuously recognized as an industry leader in Health Care Corporation. As per Various compliance and security mandates such as the HIPAA Security Rule and Client audits requests are directly/ indirectly requires the encryption of detailed sensitive information. This includes protected health information PHI and personally identifiable information PII .This Project was built to encrypt the sensitive underlying data in the repositories and application with PHI and PII information.PBM Data masking is an initiative to mask the sensitive production data PHI and PII in the non-production systems like development, test, training and support.

Responsibilities:

• Coordinated with project architects, managers and application SME's to find set of sensitive elements in applications.
• Assisted in developing the HLD documents, built the LLD documents for all the applications like QL, Recap, Hercules and PBMBest
• Enterprise applications include QL, RECAP, Hercules and PBMBEST and others in DEV, SIT and STP environments are masked using InformaticaPowerCenter and ILM.
• Incorporated policy/rule/plan for sensitive elements to be masked using ILM tool
• Cross reference architecture methods are designed to mask original values on these non-production environments.
• Informatica ILM and InformaticaPowerCenter are used in data masking development process.
• Worked on wide varieties of sources like DB2 mainframe, UDB, Flat files, and Copy books.
• Cross Reference tables, Seed mappings, Copy mappings and Substitution mappings are developed at application level for all tables.
• Enterprise level mappings designed using parameter files and persistent cache files.
• Cache creation techniques and transformation level tuning are implemented to achieve performance.
• Worked on Informatica Power Exchange to access copybooks from mainframe environments.

Environment:Informatica power center 9.0.1/8.6, Informatica ILM, Informatica Power Exchange, DB2, UDB, Mainframe, Toad, Citrix, AIX Unix, HP Quality Center

ETL Developer

Description:

is the largest pharmacy health care provider in the United States with offerings across the entire spectrum of pharmacy care.CVS Caremark is a market leader in mail order pharmacy, retail pharmacy, specialty pharmacy, and retail clinics. As one of the country's largest pharmacy benefits managers PBMs , it provides access to a network of more than 64,000 pharmacies and includes one of the industry's most comprehensive disease management programs The current project involves preparing design documentation, coding new modules, attending client review meetings , end-to-end testing and deployment for various applications in CVS Caremark.

Responsibilities:

• Managing a team of 16 and responsible for all the deliverables
• Involved in KAP phase Secondary shadow and Primary shadow, given playback of knowledge acquired
• Involved in resourcing for all CVS requirements from AIM- Handling client escalation and fulfill client requirements
• Supported different applications like QA, RECAP, PBMBest, Hercules

Environment:Informatica 9.x, Oracle 10g, Teradata, DB2 UDB v9, TWS, HP Service Manager

ETL Developer

Description:

is a leading pet specialty retailer with more than 1000 stores in all 50 states across USA providing products, services and advice that make it easier for customers to be great pet parents for last 46 years. PETCO is a privately held company headquartered in San Diego, USA.PETCO uses the BI application portfolio for its decision making process in various subject areas like Sales, Operation, Supply chain, Finance, Advertising and Marketing. PETCO uses enterprise data warehouse to perform various business analysis that will help business to make effective business decisions. Netezza is used as Enterprise Data warehouse Database and used for ETL Purpose.

Responsibilities:

• Responsible for Netezza knowledge acquisition phase, Secondary shadow and primary shadow support.
• Responsible for resource identification and trainings Involved in project plan, resource loading activities.
• Requirements gathering in discussion with SME's

Environment:Netezza, Linux and oracle 10g

ETL Developer

Description:

is a specialty retailer of consumer electronics in the United States, accounting for 19 of the market. It also operates in Mexico, Canada, China, Turkey and the United Kingdom. The company's subsidiaries include Geek Squad, Magnolia Audio Video, Pacific Sales, and, in Canada operates under both the Best Buy and Future Shop label. Together these operate more than 1,150 stores in the United States, Puerto Rico, Canada, China, Mexico, and Turkey.The Negotiation Tool is used to help Best Buy BBY merchants holistically analyze their Vendor Program Agreements and determine appropriate year-over-year changes based on category strategy and budgets, planned sales and receipts by Vendor, and specific Vendor Program components. The Negotiation Tool helps Best Buy to have a proper communication channel and information flow between Best Buy and its suppliers which lead to increased efficiencies, reduced costs and better customer service.

Responsibilities:

• Understanding the Requirements and Design
• Creation of High level and low level Design Document
• Developed Mappings based on the requirement.
• Prepared Unit test cases and Tested according to Unit Test Cases
• Additional responsibility of providing technical guidance to other team members.

Environment:Informatica 8.1/8.6, Teradata V2R5, HP Quality Center

ETL Administrator

Description:

is in the process of implementing SAP R/3 ERP system in more than 80 countries, with 15 implementations having already gone live. Nestle maintains market specific data at the local SAP R/3 implementations as well as some portion of it in the centralized SAP R/3 database on DB2 at Switzerland. Data from various disparate legacy systems needs to be extracted, cleansed, transformed and loaded into these SAP databases. The ETL tool being used is Informatica Power Center 6.2/7.1. Additional Informatica components are used for accessing and modifying data of proprietary data stores like AS/400, SAP R/3, SAP BW and these are achieved through the use of respective Informatica Power Connect 6.

Responsibilities:

• Weekly dash board review with the customer on tickets and SLA.
• Creation of new environment and configuration and Administration and configuration of Informatica Servers.
• InstallingInformatica Power Center 8.6.1 on AIX and applying Patches/Hot fixes.
• UpgradingInformatica Power Center 8.1.1 to Informatica Power Center 8.6.1
• Creating and Configuring Power Center Domains, Nodes, Repository Services, Integration Services, Data Analyzer Services, Metadata Manger Services on Grid etc.
• Building Backup and Restore scripts for Informatica Repositories.
• Involved in coordinating the storage and backup process using TWS.

Environment:Informatica 6.2/7.1/8.1/8.5.1, Power connect SAP AS400,SQL Server 2005, Power Channel, SAP Front end tool, Quest Central, DB2UDB, Peregrine Service Center, TWS

ETL Developer

Description:

is in the process of implementing SAP R/3 ERP system in more than 80 countries, with 15 implementations having already gone live. Nestle maintains market specific data at the local SAP R/3 implementations as well as some portion of it in the centralized SAP R/3 database on DB2 at Switzerland. Data from various disparate legacy systems needs to be extracted, cleansed, transformed and loaded into these SAP databases. The ETL tool being used is Informatica Power Center 6.2/8.1. Additional Informatica components are used for accessing and modifying data of proprietary data stores like AS/400, SAP R/3, SAP BW and these are achieved through the use of respective Informatica Power Connect 6.

Responsibilities:

• Took the responsibility for ETL implementation for Nestle Water France in onsite. And also reviewed Functional Specification, helped data object owners for preparation of functional specification. Review ETL functional specification on behalf of GC. Also developed complex objects in ETL from onsite.
• As an Onsite ETL Coordinator responsible for the following at Nestle Water France
• Lead the data team ETL and LSMW for requirement analysis and generating the Business Requirement Specification for France Waters markets.
• Responsible for approving ETL development, Change request estimations.
• Review of work items developed by team members and development of reusable objects that are to be used across different mappings.
• Involved in designing of the market side data migration process for Nestle Water France market.
• Additional responsibility of providing technical guidance to other team members.
• Involved in high level data loading planning for whole France Implementation from FUT to Go-Live cut over activities.

Environment:Informatica 6.2, Power connect SAP, Power Channel, LSMW, Quest Central, DB2UDB, Peregrine, SQL Server 2005

ETL Administrator

Description:

is in the process of implementing SAP R/3 ERP system in more than 80 countries, with 15 implementations having already gone live. Nestle maintains market specific data at the local SAP R/3 implementations as well as some portion of it in the centralized SAP R/3 database on DB2 at Switzerland. Data from various disparate legacy systems needs to be extracted, cleansed, transformed and loaded into these SAP databases. The ETL tool being used is Informatica Power Center 6.2/7.1. Additional Informatica components are used for accessing and modifying data of proprietary data stores like AS/400, SAP R/3, SAP BW and these are achieved through the use of respective Informatica Power Connect 6.Another aspect of the job is to design ETL process for the upcoming markets in various countries falling under three zones AMS Brazil, Mexico, Caribbean, Bolivia, Peru, Austral, Chile, Canada and US , AOA Philippines, Australia, Thailand and EUR Austria, Belgium, Germany, France, Hungary, Russia, Poland, UK, Germany, Italy, Spain, Netherlands, Switzerland, Ukraine, Romania, Greece

Responsibilities:

• The ETL tool used for populating OLAP was Informatica 6.1/6.2/7.1/8.1/8.6.1
• Involved in the development process for the design of the complex mappings and sessions.
• Configuring Connections wrtSAP, AS400, DB2, Oracle and Sql Server
• Debugging all the infrastructure issues related to Dev, QA, CM Pre Prod and Production.
• Interacting with different markets across the globe for the Dev, QA and CM environment issues related with Infrastructure
• Creation of new environment and configuration and Administration and configuration of Informatica Servers.
• Participating in BCP and DR Tests for the existing and newly build environments and creating TRP Technical Recovery Plan documents to effective support in during a DR incident.
• Handled Multiple Outages in our environment and have coordinated the activities with various teams involved in the Outage.
• Resolving issues related to all the Markets and helping markets to setup the Infrastructure for their Pre Prod and Prod activities till GO LIVE.
• Scheduling OFF LINE and ON LINE Backups.
• Checked daily database backups and performed test recovery to ensure that database backups are functioning on a regular schedule
• Creation and alteration of table spaces, users, granting privilege to users, creation of database triggers, database backup and recovery, export/import of data, troubleshooting.
• Monitored applications and database performance, and adjusted database parameters, application code or schema as needed.
• Using DB2 utilities like, Reorg, Load, Runstat, Import and Export.
• Monitor DB2 UDB databases for space utilization and performance degradation and tune as needed.

Environment:Informatica 6.2/7.1 Power connect SAP AS400, Power Channel, SAP Front end tool, Quest Central, DB2UDB, Peregrine service center

ETL Developer

Description:

The purpose of the QFD Scorecard reporting and web solution is to provide an automated global tool for the GSLs and RSLs during quarterly business reviews that will help facilitate a clear consistent definition of what a strategic supplier is through candid assessments of supplier performance across Seven CTQs. Quality, Delivery, Productivity, NPI, Risk, Responsiveness, Commercial. At present, the QFD metrics are entered manually and reports are pulled out using an Access interface. This is a tedious process and is more prone to errors in reporting. Accessibility of the tool to its various users is also restrictive. Web Interface would also provide the visibility to various users across the globe.

Responsibilities:

• Providing strategic and tactical direction
• Decide ETL Strategy
• Development of Mappings, Analyze the existing mappings and prepare Business Logics Documents for existing mappings.
• Identifying priorities in consultation with the client and changing the schedule
• Preparing MD120, UTP Unit Test Plans documents.
• Prepare the ETL Transformation Specifications for business logics.
• Performance tuning of different mappings
• Scheduling of job by making job chains using Redwood Explorer

Environment:Oracle 8i, Teradata V2R5, Informatica 6.2

ETL Developer

Description:

HR data. The project also would focus on converting the existing Business Objects suite of HR Reporting to the Cognos platform. The primary focus of the project is to optimize the data mart structure and retain the current ad-hoc reporting capabilities.

Responsibilities:

• Providing strategic and tactical direction
• Decide ETL Strategy
• Development of Mappings
• Developing test specifications
• Scheduling of job by making job chains using Redwood Explorer
• Performance tuning of different mappings

Environment:Oracle 8i, Teradata V2R5, Informatica 6.2

ETL Developer

Description:

This project is to provide different reports and support adhoc queries for making intelligent banking decision based on data available in various branches across the country connected over a period of time. Bank wants to have tool, which will help it to analyze the current business trends and to make predictions about the future business trends. Especially the Bank is focused on getting the analytic information about Target customer groups, Loss making schemes, Season wise financial analysis etc.

Responsibilities:

• Worked as ETL Developer involved in Requirement Analysis, Data Warehouse design, Loading of data into warehouse under ETL phase using Informatica5.1 and SQL Loader.
• Developed various kinds of mappings
• Performed different types of transformation, mapping of different sources
• Optimizing the mapping to load the data in slowly changing dimension.
• Done performance tuning of the mappings
• Responsible for scheduling Jobs

Environment:Oracle 8i, Informatica 5.1

Developer

Description:

This project is mainly to computerize the existing system. The client is large Electronic equipments Manufacturing Company. They have products including a wide range like Interconnect products and switches, computer peripherals, entertainment, medical electronics etc. So we developed software to maintain the details of Sales, Stock list.

Responsibilities:

• Worked as Developer involved in Requirement Analysis and development
• Worked as design programmer
• Involved in design, coding and testing

Environment:VB-6.0, Oracle