Summary

A senior Informatica Architect with very strong professional background in Data warehouse domain and over 11 years of industry experience in the software engineering, processes and methodologies, and management specializing in:

• Expertise and working experience in establishing the process, methodology standards at all phases of an Enterprise Data warehouse.
• Extensive experience in the areas of Systems Analysis, Fit-Gap Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & Reports, conducting testing and validations, conducting user training, documentation and Production Support.
• Very strong analytical, technical and business skills in architecting and designing using ETL applications.
• Technical leadership, mentoring and managing senior designers, developers and development teams.

Technical Expertise

Primary skills : Informatica PowerCenter 9.1.0, 9.0.1, 8.6.1, IDQ 901 and PWX 901
Secondary skills : Oracle 11G, Unix Shell and PERL Scripts.
Modeling Tool : Power Designer 12.5
Domain skills : Pharma, Telecom, Healthcare, Finance, Airlines, SCM, and Logistics
Scheduling Tools : $Universe, DAC, Tivoli and Autosys
Migration Tool : Kintana
Operating System : MS DOS 6.22, Win 3.x/95/98, Win NT 4.0, 2003/2000/XP, Sun Solaris, Linux and AIX.
Other tools : TOAD 9.5, Query Analyzer, Remedy BMC Software, Quality Center and PVCS.

Project: Informatica LDAP Integration
Duration: Aug 2010 to Till Date
Role: Informatica Architect/Administrator
Environment: Informatica PowerCenter, 9.0.1 HF2, Softerra LDAP Administrator, and LDAP V3.0
Client: Confidential, Somerset, NJ.

Description:

MetLife, Inc. is a leading global provider of insurance, annuities and employee benefit programs, serving 90 million customers in over 50 countries. Through its subsidiaries and affiliates, MetLife holds leading market positions in the United States, Japan, Latin America, Asia Pacific, Europe and the Middle East.

Responsibilities:

• Architected Native to LDAP migration process.
• Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for Informatica PowerCenter Grid implementation.
• Architected and designed end to end process automation for Informatica ID recertification to meet MetLife’s compliance goals.
• Prepared a plan for LDAP migration and worked closely with Informatica Administrators and IT Teams to perform the migration from Native security to LDAP.
• Documented the LDAP configuration process and worked closely with Informatica Technical support on some of the issues.
• Designed and developed Informatica ID Recertification process to help MetLife comply with IT Security policies and standards.
• Extensively worked on Informatica Mappings, Sessions, Workflows and UNIX Shell scripts to provide end to end solution to ID Recertification process.

Description:

AstraZeneca (AZ) is a global, innovation-driven, integrated biopharmaceutical company. AZ’s mission is to make a meaningful difference to patient health through great medicines that bring benefit for patients and add value for our stakeholders and society.AZ active in over 100 countries with a growing presence in emerging markets including China, Brazil, India and Russia.

Responsibilities:

• Installed and configured PowerCenter 9.0.1 and 9.1.0 on UNIX platform.
• Installed and configured Informatica PowerExchange CDC 9.1.0 and 9.0.1 for Oracle on UNIX platform.
• Performed Informatica upgrade from V8.6.1 to 9.0.1 and 9.1.0.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Installed and configured the following IDQ 9.0 components on AIX UNIX Servers.
• DQ Content Basic.
• DQ Content Accelerator
• DQ Content IMO
• Configured OS Profiles and LDAP Authentication.
• Installed and configured Informatica Support Console 1.5 to proactively monitor the environment.
• Extensively worked 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.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Ensure that all support requests are properly approved, documented, and communicated using the MQC tool. Documenting common issues and resolution procedures.

Project: CISCO Systems Informatica Architecture
Duration: Oct 2009 to Oct 2010
Role: Informatica Administrator/Developer
Environment: Informatica Power Center 9.0.1, 8.6,1, UNIX Kshell Scripts, Teradata 12 and Oracle 10G
Client: Confidential, Morrisville, NC

Description:

The Enterprise Data Warehouse (EDW) provides services to CISCO business and IT clients. EDW acquires, prepares, and delivers reporting data for business decision making. This operational data is for trending analysis and near real-time reporting (transactional data). Services include data source analysis, modeling, quality analysis, structure design to enable reporting analysis, mining & discovery of data for an integrated view of Cisco's business and customers.

Cisco Data Warehouse is the repository for a multitude of Cisco’s corporate information. There are three major data flows:

• Load data periodically into Cisco Data Warehouse, which provides data to other external systems
• Maintain data in reference data tables.
• Retrieve data out for end user reporting and analysis.

Responsibilities:

• Installed and configured PowerCenter 8.6.1 on UNIX platform.
• Upgraded to Informatica PowerCenter 8.6.1 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Informatica Corporation.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Configured OS Profiles and LDAP Authentication.
• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and vice versa.
• Worked on Push Down Optimization to optimize Oracle loads.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Creation and maintenance of Informatica users and privileges.
• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Worked on Informatica Templates to standardize the CISCO process and maintain consistency across different teams.
• Worked on UNIX shell scripts to handle Job Control Process.
• Testing the Informatica Objects in QA before moving them into Production.
• Designed and documented ETL standards document.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.

Project: SPARC SWIFT Integration
Duration: Apr 2009 to Oct 2009
Role: Informatica Administrator/Developer
Environment: Informatica Power Center 8.6,1, and Oracle 10G
Client: Confidential, San Diego, CA

Description:

Sony is a multinational conglomerate corporation headquartered in Minato, Tokyo, Japan, and one of the world's largest media conglomerates with revenue exceeding ¥ 7,730.0 billion (FY2008). Sony is one of the leading manufacturers of electronics, video, communications, video game consoles, and information technology products for the consumer and professional markets.

The objective of the SPARC (Relase1) project is to move the service order processing for VAIO PC models from SIS (Legacy System) into SPARC (SAP). Also the purchase, receipts and inventory maintenance for current locations will be moved to SPARC. As a result of this, there is a need for new interface files to be developed to ensure that the SWIFT application continue to function and report the same service orders data, accommodations data, parts inventory data, purchase order data, and receiver data that is reported for VAIO Laptop models currently.

Responsibilities:

• Installed and configured PowerCenter 8.6.1 on UNIX platform.
• Installation and configuration of PowerCenter 8.6.1 hot fixes, patches and version upgrade from PowerCenter 8.5.1 to PowerCenter 8.6.1.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Deployment of Informatica Mappings/Sessions/Workflows into Production environment. Testing the Informatica Objects in QA before moving them into Production.
• Designed and documented ETL standards document.
• Worked on shell scripts to sftp (Secured FTP) the file to and from TumbleWeed Server Directory.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Worked on Object Queries, resolving conflicts delete and purge objects.
• Ensure that all support requests are properly approved, documented, and communicated using the Remedy tool. Documenting common issues and resolution procedures.

Project: Customer Information Systems DW
Duration: July 2008 to March 2009
Role: Informatica Administrator
Environment: Informatica Power Center 8.6, SQR, Business Objects Xi, Power Designer 12.5, Kintana, TOAD 9.5, and Oracle 11G
Client: Confidential, Charleston, WV

Description:

BrickStreet Mutual Insurance Company began its role as West Virginia’s first private workers’ compensation carrier on Jan. 1, 2006. BrickStreet is a mutual company owned by its policyholders, and is among the largest writers of workers' compensation coverage in the nation.

The CIS project will address external reporting needs for these very strategic clients by deliveringa suite of external facing reports, accessible via an online tool. These reports will serviceBrick Street customers, agencies and other partners to help define Brick Street’s position in the marketplace. Some of the goals of this project are to retain customers, impact revenues, having a competitive advantage, strategic adaptability and data integrity.

Responsibilities

• Architect the process for Informatica PowerCenter 8.6 Administration.
• Responsible for Installation & configuration of Informatica PowerCenter 8.6 (Client, Repository Service & Integration Service) on UNIX machine.
• Configured Master Node and Backup nodes under High Availability environment.
• Created and maintained Users, Groups, Roles and Privileges.
• Repository Service Backup, Recovery and Migration between Dev, UAT and Prod environments.
• Creating and maintaining Grids and Nodes.
• Designing and developing the ETL frame work and processes using Informatica 8.6.0, to run on the Domain, Integration Services and Nodes, on a Highly Available Grid ETL Infrastructure. Hands on knowledge on Integration Services Architecture and its components such as Load Balancer, DTM processing, Grids, code pages and data movement modes etc.
• Migration of changes, enhancements, upgrades, etc. through the various environments.
• Installed and configured Metadata Manager Services.
• Migration of Mappings, Sessions and Workflows from Dev to UAT and PROD environment.
• Hands on experience in creating Deployment Groups and Applying Labels.
• Responsible for Installation of Patches and upgrades.
• Extensively worked on Performance Tuning of Informatica Server and Repository Server.
• Installed and configured Webservices Hub.
• Have good knowledge on Troubleshooting and providing speedy solution in case of failure of the applications.
• Have good knowledge on Installation and Configuration of PowerCenter Connect for LDAP.Setting standards and guidelines for QA and helping system testing activities to ensure that systems fulfill design requirements.

• Responsible for Unit, Integration, Performance and System Testing of ETL environment and raising the defects in QC tool.
• Created documents and manuals for Informatica Installation, Configuration, Migration procedures ETL Architecture and Naming Standards.
• Trained people on Informatica PowerCenter 8.6 on Administration and Development.

Project: CISCO Systems – EDW 2B
Duration: June 2005 to July 2008
Role: Informatica Administrator/Developer
Environment: Informatica Power Center 8.5.1, and Teradata
Client: Confidential, San Jose, CA/Hyderabad, India

Description:

The Enterprise Data Warehouse (EDW) provides services to CISCO business and IT clients. EDW acquires, prepares, and delivers reporting data for business decision making. This operational data is for trending analysis and near real-time reporting (transactional data). Services include data source analysis, modeling, quality analysis, structure design to enable reporting analysis, mining & discovery of data for an integrated view of Cisco's business and customers.

Cisco Data Warehouse is the repository for a multitude of Cisco’s corporate information. There are three major data flows:

• Load data periodically into Cisco Data Warehouse, which provides data to other external systems
• Maintain data in reference data tables.
• Retrieve data out for end user reporting and analysis.

Responsibilities

• Responsible for Administration of Informatica PowerCenter.8.5.1
• Migration of Mappings, Sessions and Workflows from Dev to UAT and PROD environment.
• Hands on experience in creating Deployment Groups and Applying Labels.
• Good knowledge on Object Queries, resolving conflicts, Delete and Purge objects.
• Hands on experience in Object Versioning and its features such as Check-in, Check-out, Undo-Checkout, Viewing History, Setting the Object Status etc.
• Responsible for Installation of Patches and upgrades.
• Extensively worked on Performance Tuning of Informatica Server and Repository Server.
• Responsible for upgrading from Informatica 8.1.1 to 8.5.1
• Responsible for monitoring batch execution job schedules
• Provide technical expertise in all aspects of administrative data processing.
• Responsible for installation & configuration of Informatica PowerCenter (Client, Server & Repository Server).
• Support data extraction, cleansing, aggregation, reorganization, transformation, and load operations.
• Access data from multiple operational data sources, re-map source data into a common format, Filter data, calculate derived values, aggregates, load cleansed data to the central DW. Extensive use of Informatica 8.5.1 and ETL performance tuning.
• Migration of changes, enhancements, upgrades, etc. through the various environments.
• Ensure that all support requests are properly approved, documented, and communicated using the appropriate tools. As well as documenting common issues and resolution procedures.
• Responsible for Unit, Integration, Performance and System Testing of ETL environment and raising the defects in QC tool.

Project: USFC
Duration: Mar 04 to May 05
Role: Informatica Developer/Administrator
Environment: Informatica Power Center 7.0, Crystal Reports V10.0, ERWin V5.0, Oracle 9i, SQL and PL/SQL
Client: Confidential, Chicago, IL/Hyderabad, India

Description:

USF Corporation is the holding company for a $2.29 billion group of companies that provide comprehensive and innovative supply-chain management solutions. The USF team is comprised of 5 companies working under USF Corporation. They are. USF Bestway, USF Dugan, USF Glen Moore, USF Holland and USF Reddaway. USF provides services to help companies prioritize and re-engineer their movement of material and product, so they can concentrate on their core businesses. With new logistics solutions USF and its group of growing companies is perfectly positioned to support the ever-changing needs of its customers. USF Corporation (USFC) is the holding company for its trucking and logistics companies.

Responsibilities

• Responsible for Administration of Informatica PowerCenter.7.0
• Responsible for installation & configuration of Informatica PowerCenter (Client, Server & Repository Server).
• Managed PVCS Tracker to resolve already opened SCR’s and also opened new SCR’s for any changes in Business Requirements and updated them until, they got resolved by applying in the design and the development areas.
• Developed shell scripts to disable or enable constraints in tables and truncating the tables to avoid fragmenting of the database table due to frequent deleting of the records.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager, PMCMD and also using scheduling tools like Autosys. Generated completion messages and status reports using Workflow manager.
• Involved in documenting the Deployment plan and created Test Scripts for the Unit test plan.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Involved in System Testing and User Acceptance Testing to check the data loading into the target, which was extracted from different source systems according to the user requirements.
• Migrating Folders, Mappings, Workflows across Repositories, Folders and to the higher version of Informatica.
• Actively involved in the Production support and also transferred knowledge to the other team members.
• Responsible for onsite/offshore co-ordination

Project: Business System Renewal (BSR)
Duration: Sept 2003 to Feb 2004
Role: ETL Consultant
Environment: Informatica Power Center 6.2.1, DB2
Client: Confidential, Melbourne, VIC, Australia

Description:

Medibank is Australia’s largest provider of private health insurance. It is the only national health insurer, covering nearly 3 million people. Medibank offers health insurance to all Australians through retail and corporate products as well as catering for overseas students and visitors.

Management and Legislative (M&L) Reporting Continuity delivered by Legacy is a functional component in scope of the BSR Phase1, Hospital Claims. This functional component will integrate iMed claims and benefit information to the appropriate legacy data stores to enable the current management and legislative reporting capability. This solution will require a newly developed interface between iMed and Legacy.

Responsibilities

• Preparing the requirements study document
• Requirement gathering and Business Analysis.
• Architect, designed and developed Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Architected, designed and developed Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0.
• Participating in User meetings, gathering requirements.
• Responsible for Documenting processes and procedures required for support
• Participating in special projects involving the implementation of a new tools or applications.
• Responsible for Monitoring batch execution job schedules
• Work closely with Onshore Team Leads to track and drive production incidents to closure.
• Responsible for documenting and maintaining all procedure and work instruction documents related to training, support, and admin procedures.
• Provide immediate response from 7am * 7pm (Monday * Friday) on system alerts, ticket requests, and user requests.
• Provide after hours and weekend coverage for mission critical production applications. (On call rotation)
• Respond to emergencies and escalates as appropriate internally and to external vendors.
• Migration of changes, enhancements, upgrades, etc. through the various environments.
• Ensure that all support requests are properly approved, documented, and communicated using the appropriate tools. As well as documenting common issues and resolution procedures.
• Application Quick Reference guides are up to date and primary support person has a printed copy at their desk.
• Ensure the integrity and readiness of the production environment by coordinating the resources required for reliable processing
• Interact with the recovery team on critical outages.
• Open, dispatch, and close cases in ticketing system.
• Perform analysis and provide consultation regarding the potential impact new projects or proposed functionality enhancements might have on current applications.
• Manage all aspects of system disaster planning and recovery, including normal file backup and archiving.
• Analyze poor performance in application at all tiers, and provide remediation path, and possibly implementation of same.
• Troubleshoot complex performance issues in Oracle (database and SQL).
• Designed and built Datamart by using Star Schema’s Using ERWIN 4.5.
• Writing and changing Pearl Scripts to manage and executes work units.

Project: RIS ANZ Performance Tuning
Duration: Jan 2003 to Aug 2003
Role: ETL Analyst
Environment: Informatica Power Center 6.0, Oracle 9i
Client: Confidential, Melbourne, VIC, Australia

Description:

ANZ is one of the largest banks in Australia. ANZ is significantly expanding its risk capability, via projects such as RXMR and OCV.
It is recognized that the current Risk reporting platform is inadequate to meet future Retail and Corporate risk reporting requirements, required by Group Risk Management and the Business for Effective Risk Management (ERM).ANZ implemented the new Risk Information Store (ETL, Metadata Tools, and Data profiling), and sought a systems integrator partner to design build and implement the solution in 2003.

But over a period of time due to integration of several systems in RIS (Risk Information Store) the performance of ETL mappings that are written in Informatica, have been degraded. RIS ANZ Performance tuning project involves analyzing the ETL programs and providing solution for overall performance of system.

Responsibilities

• Preparation of Scope of Work.
• Analyze existing mappings and sessions for performance issues.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Responsible for Error handling.
• Suggest probable tuning solutions.
• Coordinated with the DBA Team, Source systems, BSA team, offshore team and Data Quality team for Different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and identify bugs, new requirement changes and Data Quality Issues.
• Incorporating performance related changes to mappings and sessions.
• Identifying the areas of re-usable functionality and designing re-usable ETL components to be useful across different data domains and lines of business
• Unit testing of mappings and sessions.
• Updating Design documents and test scripts due to changes.
• Design, implement and manage multiple, concurrent hardware and software systems of varying sizes and complexities. Work with IT and Business managers to plan, control, and implement technical solutions to business problems.
• Prepare status reports and participate in meetings.
• Provides guidance and mentoring and training to less experienced personnel.
• Frequently leads formal and informal teams of other internal technical staff or external resources.
• Responsible for Informatica ETL Development, Source to Target mapping.
• Responsible for administration of Informatica PowerCenter.
• Participating in special projects involving the implementation of a new tools or applications.

Project: EK Engineering
Duration: May 2002 to Dec 2002
Role: Informatica Prod Support Engg
Environment: Informatica PowerMart 6.0, Business Objects 4.0 and Oracle 8
Client: Confidential, Dubai, UAE

Description:

The core functions of Emirates Engineering are managed with the help of EMPACS, an OLTP (On-line Transactional Processing) based legacy system. The core functionality of the system is to extract the data from EMPACS and other OLTP system, then the Transformation of this data with help of Informatica PowerMart (ETL tool) to the ODS oracle database and subsequently to Data Warehouse / Data Mart. Further to this, the data will be analyzed using Business Objects reporting tool.

Responsibilities

• Installed Power Center Repository Server, Power Center Server and also Power Center Client Tools and creating Repositories, Relational connections and User permissions.
• Involved in gathering all the business requirements and specifications from the business enterprise solutions team.
• Interacted with Business Analysts to translate Business requirements into technical specifications.
• Involved in analyzing the Data Flow diagrams to implement it during the development process.
• Involved in configuring the Data warehouse while specifying and setting the size of the database.
• Involved in designing the various Reusable Informatica Objects.
• Implemented various transformations like Expression, Aggregator, Lookup, Normalizer, Joiner, Filter, Union, Stored Procedure, Router, Sequence Generator, Rank and Update Strategy.
• Involved in creating mapplets that would be reusable in various other mapping interfaces having similar business requirements.
• Extracted source definitions from various relational tables and flat file sources.
• Created mappings using Mapping Designer, Transformation Developer, Mapplet designer (for re-usable transformations) and Warehouse Designer to load the data from various sources.
• Created simple informatica interface routines for validating the data from the databases.
• Involved in performance tuning of Informatica Objects and Oracle queries.
• Worked on running and scheduling the Informatica Jobs using the shell scripts written on the UNIX box.
• Monitoring the scripts and triggering them again in case of failure of the scripts
• Populated the Staging areas with various Source like Flat files (Fixed and Delimited) and Relational Tables (SQL Server and Oracle).
• Making sure to run and monitor the on-demand and scheduled workflows on a daily basis, based on the user requirements.
• Used debugger to test the mapping and fixed the bugs
• Developed Mapplets and reusable Transformations
• Developed robust mappings transformations and workflows with built in reconciliation and error handling.
• Developed shell scripts for file watcher, file validation and to call Informatica workflows from Unix shell prompt.
• Prepared Technical Specification documents (TSD) for Mappings, Sessions and workflows for new requirement changes.
• Working on code enhancements for effective functioning of the system.
• Worked on Informatica Mappings to trace and fix the bugs, which are reported by other users.

Project: Shell PDO Corporation
Duration: Sept 2001 to Apr 2002
Role: ETL Developer
Environment: Informatica Power Center 5.1, Oracle 7.3, i2 TM/TO and CIS
Client: Confidential, Muscat, Oman

Description:

Petroleum Development Oman LLC (PDO) is the leading Oil exploration and production company in the Sultanate of Oman. It accounts for more than 90% of Oman’s crude oil production and nearly all of its natural gas supply - and generates 40% of the country’s GDP. It is owned jointly by the Government of Oman (60%), the Royal Dutch/Shell Group (34%), TotalFina Elf (4%) and Partex (2%).

Solution: Transportation Management System
Software Stack: i2 TM/TO, CIS, IIS, Weblogic, CIS & SAP
Company: Confidential

Responsibilities

• Creating Informatica Mappings
• Creating Business Workflows using Informatica
• Used various transformation such as Filter, Expression, Aggregate, Look-up, sequence, Joiner, Router, Update Strategy, and Stored procedure transformation for better data cleansing and to migrate clean and consistent data.
• Used debugger to test the mapping and fixed the bugs
• Developed Mapplets and reusable Transformations
• Managing, Migrating and Maintaining Informatica Repository in Test and Production environments
• Testing the Informatica mappings and Workflows
• Installing and Troubleshooting Informatica Server and Client
• Integrating SAP, i2 Transportation Management System & Oracle Financials
• Preparing & Conducting User Acceptance Testing, Integration & Performance Testing,
• Issue Tracking & Resolution,
• Change request Tracking & resolution and Documentation

Educational Qualification

Master of Computer Applications