SUMMARY:

• Informatica Certified Specialist with 9 years of total IT (Informatica, Oracle Apps) experience in which 7+ years on Powercenter 9.5.1/9.1/8.6.1 Design/Development/Administration) and 2 years on Oracle Applications 11i /R12(Development/Design).
• Highly Skilled in designing Data Models and preparing HLD and LLD for Informatica Developments.
• Expertise in Installation of Informatica Powercenter Server and maintenance.
• Expertise in Informatica Administration and Repository Management.
• Deployed Informatica 9.5.1 in Dev, Test and Prod environments in US for one of the biggest financial services Client.
• Production (UK) Informatica Administrator for almost 2 years and was part of Go Live team for 2 trusts.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes
• Development of Complex Mappings, Mapplets, Worklets and Workflows.
• Capable of working independently and as well as part of a team.
• Good Exposure in Healthcare Modules.
• Familiar with Modules like Order Management, Oracle Purchasing, Oracle Payables, Oracle Inventory. Bill of Materials, Projects.
• Experience in development of Conversions, Oracle Reports, XML Reports, Excel Reports and Discoverer Reports in Oracle Applications environment.
• Configuring AOL setup in 11i, like creating users, assigning responsibilities, registering Executables, Concurrent programs, assigning in Request Groups.
• Good Communication skills in interacting with clients.
• Travelled to UK for 1 year 6 months on Work permit and 2 months on Business Visa for Confidential project.

TECHNICAL SKILLS:

DW Tool: Informatica Powercenter 9.5.1 / 9.1 /8.6

ERP Tool: Oracle Applications 11i (11.5.9)/R12

ERP Modules: INV,PO,OM, AP, BOM,WIPDatabase, MSSQL Server,DB2 UDB,Oracle 9i/11G, Netezza

Languages: SQL, PL/SQL, C,COBOL,ASP

Tools: TOAD, SQL *Plus, SQL *Loader, FTP, Discoverer 4i,XML Publisher

GUI Tools: MSTR, Hyperion, SAP BO, Developer 2000 (Forms 6i and Reports 6i)

OS: UNIX(RHEL),MS - Dos, Windows Series

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, CT

Responsibilities:

• Managed Informatica Infrastructure Team.
• Handled Informatica Administration for 3 different portfolios.
• Maintained 8 repositories across different portfolios.
• Automated outages with Unix Scripts.
• Deployment of Code to various environments
• Performance tuning on long running jobs
• Created Unix scripts for Automated backups
• Created Unix scripts for Automated user maintenance in Test and Prod environments
• Created Unix scripts to Automate Jobs based on file and data availability in SAN and DB.

Confidential, Phoenix

Responsibilities:

• Deployed and Upgraded from Informatica 8.6.1 to Informatica 9.5.1 in Development, Test and Production environments on Unix Platforms.
• Setup Grid environment in Test and Production.
• Repository Management.
• Deployment of Code to various environments
• Performance tuning on long running jobs
• Created Unix scripts for Automated backups
• Created Unix scripts for Automated user maintenance in Test and Prod environments
• Created Unix scripts to Automate Jobs based on file and data availability in SAN and DB.
• Received Client appreciations for Successful Deployment of Informatica Powercenter.
• Received Best faculty award for training 6 batches on Informatica Powercenter 9.5.1
• Improve the Overall documentation of the CIQR process as a card replacement transaction subject area.
• In corporate CIQR into the new WSDW infrastructure strategy (Data Warehouse/Data Mart).
• Moving existing Cognos 7.4 reports/cubes which are required to Microstrategy solution used by WSDW
• Moving existing ETL processes which are required to Informatica solution used by WSDW
• Preparation of Design Documents
• Creation of LDM and PDM based on Design
• Developed mappings to migrate data to DW and DM
• Loaded historical data to DW and DM
• Received on the Spot Award for successfully completing the CIQR project on time and without any Issues.

Confidential

Responsibilities:

• Informatica Server Administration.
• Installation and Maintenance of Informatica Server
• Design and Development of Informatica based extract and transformation solution as part of the overall Confidential Migration solution.
• Design and development of Trust based solution and dependency model to the core solution.
• Development of theInformaticaMappings, lookups, reusable components, Sessions, Work Flows etc. as per the design documents/communication
• Development-Production Delivery model development and carrying out regular development build uplifts & Functional Area Design/Requirement changes.
• Verification and validation of the internal ETL Loading tool (LDMS, Blob Tool).
• Involved in reviewing the Test Cases written by the peers
• Onsite Coordination with Offshore team.

Confidential

Responsibilities:

• PO Supplier Conversion.
• BOM Routings Conversion.
• Confidential WIP Traveler Report. (XML with Barcodes)
• NAFTA Certificate in XML
• CIP Analysis XML Report
• Confidential Project Material Breakdown Summary Report
• Projects WBA Custom Form.
• PO INA Outbound Interface

Confidential

Responsibilities:

• Created Mappings, Mapplets and Workflows.
• Used various Transformations like Lookups, Filter, Data-Masking, SQL, Unconnected Lookups, Router, Union, Rank, Sequence, Joiner, SQ, Expression, Agrregation etc.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL
• Fixed invalid Mapping's, tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows.

Confidential

Responsibilities:

• Customized Confidential Cost Analysis Report.
• Customized Costing Reports.(Excel format)
• Zero Cost Script Main Weekly SCCR
• Zero Cost Script Clean up Monthly Zero Cost Validation
• Item Cost Analysis by Level Weekly Cost Update
• Item Cost Comparison Monthly Item Cost Archiving
• Created Custom Auto invoice Exception Report.
• Customized various existing Reports.
• Created PL/SQL Packages and Procedures
• Supporting Production Issues.
• Developed Customized Forms in Costing(Received E-Award for Form Development)
• Monthly ADP Taxware uploads.
• Awarded E Award for Excellence in Technical Skills
• Received Training on Hyperion Reporting(IR,FR,WA)

Confidential

Customization and Production Support

Responsibilities:

• Created the PO Summary Report which is Export friendly.
• Created Cost Value Comparison Report.(Excel format)
• Created Items not in BOM Report(XML Format)
• Customized various existing Reports.
• Upgraded various reports into XML.
• Created PL/SQL Packages and Procedure
• Supporting Production Issues.