SUMMARY:

• Perform system analysis, project supervision, research and strategic planning.
• Work independently with customer during software installation, software upgrades.
• Identify and document business requirements while working closely with customers.
• Identify technologies required for development; use of those technologies to build complex data integration application/solution.
• Document installation of Informatica products for customer
• Educate business users on Informatica platform

SOFTWARE/LANGUAGE:

• Informatica Software
• Amazon Web Services (AWS)
• Informatica Data Quality (IDQ)
• SQL Server 2008
• Informatica Proactive Monitoring
• Teradata
• Informatica B2B (dx, dt)
• SAP Business Objects
• Informatica TDM
• Oracle Applications
• Oracle 9i RDBMS (DBA Associate)
• Oracle 9i RDBMS (DBA Professional)
• ERWin
• SQL Navigator
• SQL & PL/SQL
• JAVA, PERL
• Shell scripting (development/support)
• SQA Automated Regression Testing Tool
• SAS 9.4

EXPERIENCE:

Informatica Data Quality Tool Specialist - Administrator Informatica

Confidential

Environment: Linux, Informatica PowerCenter, Informatica Data Quality, Informatica Metadata Manager, 10.0, 10.1

Responsibilities:

• Senior Informatica Data Quality Tool Specialist
• Environment Implementation
• Security model design
• Data Quality training
• Training and day to day leadership of junior Informatica Administrators
• Senior Informatica Administrator
• Environment Implementation
• Environment upgrades
• Training and day to day leadership of junior Informatica Administrators

Informatica Administrator

Confidential

Environment: Windows Server 2012, Informatica PowerCenter, Informatica Proactive Monitoring, RTAM/RulePoint, Informatica Metadata Management 9.6, 10.0, 10.1

Responsibilities:

• Senior Informatica Administrator
• Project code upgrades
• Environment upgrades
• Security model design
• Informatica training
• Training and day to day leadership of junior Informatica Administrators
• Environment strategic management
• Informatica 9.6 to 10.1 upgrade planning and implementation

Informatica Administrator

Confidential

Environment: Linux, Windows Server 2012, Informatica PowerCenter, Informatica Data Quality, Informatica Metadata Management 9.5, 9.6,10.0, 10.1

Responsibilities:

• Senior Informatica Administrator
• Project code upgrades
• Environment upgrades
• Security model design
• Environment strategic management
• Informatica 9.x to 10.1 upgrade planning and implementation
• ETL Support, tier 1 and tier 2 (on-call support as needed)

Informatica Administrator

Confidential

Environment: AIX, Linux, Windows, Informatica PowerCenter, Informatica Data Quality, Informatica Data Validation Option (DVO) Informatica Test Data Management (TDM), Informatica Metadata Management 9.5, 9.6

Responsibilities:

• Senior Informatica Administrator
• ETL Application Support (on-call support as needed)
• Data Integration application design consulting with business units
• Informatica:
• Environment implementation
• Process documentation development
• Operational Standards, and Practices development
• Project code upgrades
• Environment upgrades
• Code Migration
• Application on-boarding
• Security automation via Active Directory / LDAP
• User creation
• Test Data Management software POC support

Informatica Administrator

Confidential

Environment: Solaris, Linux, AIX, Informatica PowerCenter 9.5, 9.1, 8.6

Responsibilities:

• Senior Informatica Administrator
• Completed initial installation and checkout of Informatica AE 9.5
• Completed ongoing maintenance activities within Informatica PowerCenter

Informatica Administrator

Confidential

Environment: Solaris, Linux, AIX, Informatica PowerCenter 9.5, 9.1, 8.6

Responsibilities:

• Senior Informatica Administrator
• Informatica project code upgrades
• Informatica Code Migration
• Data Integration application design consulting with business units
• Informatica Application on-boarding
• Informatica User creation

Informatica Administrator

Confidential

Environment: Solaris, Linux, AIX, Informatica PowerCenter 9.5, 9.1, 8.6

Responsibilities:

• ETL Production support
• Data Integration application design consulting with business units
• Senior Informatica Administrator
• Project code upgrades
• Code Migration
• Informatica User creation

Informatica Administrator/Architect

Confidential

Environment: Windows 2008 R2, SQL Server 2008, Informatica PowerCenter 9.5, Informatica Proactive Monitoring

Responsibilities:

• Senior Informatica Administrator
• Installation/configuration Proactive Monitoring
• Installation/configuration Data Quality
• Installation/configuration Metadata Manager
• Installation/configuration B2B (DX, DT)
• Completed initial installation and checkout of Informatica AE 9.5
• Developed operational processes and procedures
• Migrated ETL code between environments
• Responsible for Informatica infrastructure installation and configuration for Confidential
• Responsible for procedures defining ETL code migrations for supporting Informatica PowerCenter 9.5

Informatica Administrator/Architect

Confidential

Environment: Solaris, Oracle 9i, 10g, 11i, SAP Business Objects SAP R/3 (PowerExchange)

Responsibilities:

• Informatica Senior Administrator
• Data Integration application design support
• Informatica Cloud Services Administrator
• Work as the Informatica administrator
• Migrated Informatica code between environments
• Responsible for daily ETL code migrations, supporting both Informatica PowerCenter 8.6.1 and Informatica Cloud Services Objects
• Worked with Operations Center team to transfer ETL code migrations to Operations center.
• Informatica Cloud Services Administrator
• Work closely with both on shore, off shore and ‘remote’ ETL Developer teams
• Troubleshooting complex deployment issues tied to SAP R3 and Informatica PowerCenter

Informatica Administrator/Architect

Confidential

Environment: Solaris, Oracle 9i, 10g, 11i, SAP Business Objects SAP R/3 (PowerExchange)

Responsibilities:

• Responsible for daily ETL code migrations and maintenance of automated scripting
• Worked with Operations Center team to transfer ETL code migrations to Operations center.
• Worked with Operations Center to install REMEDY application designed to prepare a single UNIX command line text string used to automate Informatica code migrations.
• Provide mentoring to Confidential junior Informatica Administrators
• Provide mentoring to Confidential business groups who have chosen to use Informatica to support their data ETL projects

Informatica Administrator/Architect

Confidential

Environment: Solaris, Oracle 9i, 10g, 11i, (PowerExchange) IMS, VSAM

Tools: ets: Informatica PowerCenter 9.1, Informatica Data Explorer, Informatica Metadata Explorer

Responsibilities:

• Responsible for Informatica PowerCenter installation
• Supervised the daily deliverables of the Informatica Professional services team
• Provided Informatica PowerCenter operations documentation to Confidential
• Provide mentoring to Confidential business groups who have chosen to use Informatica to support their data ETL projects
• Developed UNIX scripting to control and monitor Informatica pre and post session/workflow tasks

Informatica Administrator/Architect

Confidential

Environment: Solaris, Oracle 9i, 10g, 11i, SAP R/3 (PowerExchange)

Tools: Informatica PowerCenter 8.6, Informatica Data Explorer, Informatica Data Quality

Responsibilities:

• Responsible for Informatica Software License review preparation
• Developed Informatica license review procedure for Blue Shield of California
• Provide mentoring to Confidential business groups who have chosen to use Informatica to support their data ETL projects

Informatica Administrator/Architect

Confidential

Environment: Solaris, Oracle 9i, 10g, 11i, SAP R/3 (PowerExchange)

Tools: Informatica PowerCenter 8.1.1 to 8.6, Informatica Data ExplorerInformatica Metadata Explorer

Responsibilities:

• Responsible for Informatica consolidating multiple versions of Informatica PowerCenter installations
• Developed model to support Informatica multiple O/S profiles for PowerCenter integration services
• Provided training to Informatica developers (single to multiple O/S profile transition)
• Responsible for Informatica upgrade (8.1.1 to 8.6)
• Provide mentoring to Confidential Healthcare business groups who have chosen to use Informatica to support their data ETL projects
• Leveraged PowerCenter features to control and monitor Informatica servers using Tivoli
• Developed Unix scripting to control and monitor Informatica pre and post session/workflow tasks

Informatica Administrator

Confidential

Environment: Solaris, Windows 2000, Oracle 9i, 10g, 11i

Tools: Informatica PowerCenter 8.1.1 to 8.6, Informatica Data Explorer, Informatica Metadata Explorer

Responsibilities:

• Responsible for Informatica upgrade from 32bit to 64 bit (8.6 HF 10)
• Developed model to support Informatica repository upgrades: complete or partial repository
• Provided training to Informatica developers (8.1.1 to 8.6 transition)
• Responsible for Informatica upgrade (8.1.1 to 8.6)
• Responsible for Informatica upgrade ( 32bit to 64 bit architecture)
• Developed model to support Informatica repository upgrades: complete or partial repository
• Developed Informatica mappings to extract data from operational data systems
• Provide mentoring to Raytheon Missile Systems business groups who have chosen to use Informatica to support their data ETL projects
• Developed Unix scripting to control and monitor Informatica servers
• Developed Unix scripting to control and monitor Informatica pre and post session/workflow tasks