Informatica Specialist Resume
4.00/5 (Submit Your Rating)
Windsor, CT
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
Informatica SpecialistResponsibilities:
- 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
Informatica SpecialistResponsibilities:
- 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
Informatica SpecialistResponsibilities:
- 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
Informatica SpecialistResponsibilities:
- 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
Informatica SpecialistResponsibilities:
- 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
Informatica SpecialistResponsibilities:
- 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.