SUMMARY:

• My experiences with the Informatica suite of tools has been successfully applied in the Communications, Insurance, Health care, Data management and Banking industries. Each of these industries has their own unique opportunities. The focus of my efforts recently has been in the engineering, architecting, implementation, configuration, and support of large, highly available, and complex environments. One relatively small environment required a new enterprise solution for the growing enterprise data warehouse.
• During my tenure, the environment was enhanced through several steps to increase size, performance, reliability and currency. Having increased to 20+ Informatica environments and 200 developers, these environments are now the primary tool for all of the data transformation.

TECHNICAL SKILLS:

Informatica: Power Center Enterprise Edition 9x PowerCenter 7x, 8x, 9x PowerExchange for SAP 9x PowerExchange 5.2, 8x, 9x PowerExchange CDC 9x

Oracle: Database administration 8x/9x Oracle Discoverer Oracle Internet Developer 6/6i Oracle Application Server Developer 2000 Oracle OEM

Other: PL/SQL SQL*Plus SQL Loader SQL Navigator Toad Putty MS Word, Excel, Powerpoint, Access Visio Bash and Korn shell scripting

PROFESSIONAL EXPERIENCE:

Sr. Consultant

Confidential, New York

Responsibilities:

• Installation, configuration, and support of Informatica PowerCenter Enterprise edition 9x, including IDQ, IDE, MM, Grid, HA, Team based development, IDA, LDAP authentication, PowerExchange 9x, PowerExchange for SAP 9x on Unix, Windows, and mainframe IBM z/OS
• Architect and engineering of the design, flow, and requirements for complex, highly available, multi - million dollar Informatica projects
• Provider of technical support to all developers and users of the Informatica tools and environments.
• Tester for enterprise wide Informatica PowerCenter and PowerExchange installations on Unix, Windows, and mainframe IBM z/OS.
• Design, develop, implement, and support of custom Unix shell scripts that support the Informatica installs.
• Authored documents for Informatica installation, configuration, standards, requirements, testing and support
• Disaster Recovery design, implementation, and testing
• Primary point of contact for all technical issues involving Informatica corporation support tickets

Lead Informatica Administrator

Confidential, Rochester, New York

Responsibilities:

• Multiple departmental s for excellence in performing my responsibilities
• Successfully installed/upgraded several enterprise ETL solutions that contain and manage the various Enterprise Data Warehouses
• Grew a single small Informatica environment into 20+ environments through several multimillion dollar expansions.
• Lead Administrator for all of the Informatica installations. Unix, Windows, and mainframe IBM z/OS
• Project Manager for upgrades/installations and major data migrations
• Technical Lead to all developers and users of our Informatica tools
• Lead Architect who designed the flow and requirements for any and all Informatica projects
• Engineered all technical aspects of projects including hardware, software, network, database, and end user interfaces.
• Developer of administration and automations Unix shell scripts
• Tester for enterprise wide Informatica PowerCenter and PowerExchange installations on Unix, Windows, and mainframe IBM z/OS.
• Facilitated diverse teams on Informatica process improvement and change control initiatives
• Design and authored documentation for Informatica standards, requirements, testing and support
• Minimized workload 57% by streamlining and automating manual processes through code review and performance enhancements thereby improving applications and redeploying with increased efficiencies.
• Subject Matter Expert and primary support for development on hundreds of Informatica applications
• Provided, coaching, mentoring, and career management by establishing regular communication sessions with developers and junior team members.
• Installed all instances of Informatica PowerCenter, PowerExchange, and PowerExchange for Oracle (CDC) on Unix, Windows, and mainframe IBM z/OS
• Upgraded all installations of of Informatica PowerCenter, PowerExchange, and PowerExchange for Oracle (CDC) Versions 7.1.2, 8.0, 8.5, 8.51, 8.61, 9.0, 9.01, 9.10 on Unix, Windows, and mainframe IBM z/OS.
• Configured all installations of Informatica PowerCenter, PowerExchange, and PowerExchange for Oracle (CDC), Versions 7.1.2, 8.0, 8.5, 8.51, 8.61, 9.0, 9.01, 9.10 on Unix, Windows, and mainframe IBM z/OS.
• Tuned all installations of Informatica PowerCenter, PowerExchange, and PowerExchange for Oracle (CDC) Versions 7.1.2, 8.0, 8.5, 8.51, 8.61, 9.0, 9.01, 9.10 on Unix, Windows, and mainframe IBM z/OS.
• Supported all installations of Informatica PowerCenter, PowerExchange, and PowerExchange for Oracle (CDC) Versions 7.1.2, 8.0, 8.5, 8.51, 8.61, 9.0, 9.01, 9.10 Unix, Windows, and mainframe IBM z/OS.
• Troubleshooting and root cause analysis for all installations of Informatica PowerCenter, PowerExchange, and PowerExchange for Oracle (CDC). Both local and remote. Versions 7.1.2, 8.0, 8.5, 8.51, 8.61, 9.0, 9.01, 9.10 on Unix, Windows, and mainframe IBM z/OS.
• Primary point of contact for all technical issues involving Informatica corporation support tickets
• Created and delivered presentations on and mentoring for Developers, Administrators, Team Leads, Project Managers, Engineers, Architects, and Management. To assure all parties have the Informatica basics.

Sr. Oracle DBA/ Oracle Developer /Data Warehouse

Confidential, Rochester, New York

Responsibilities:

• ed Council of Leaders for excellence in performing my responsibilities
• Supported the integration of sales performance and customer activity data across many disparate systems for a $1.7B organization
• Effectively managed multiple personnel on several successful enhancements for the data warehouse.
• Primary support and development for all department Informatica applications maintaining 99.9% up time
• Plan, maintain, tune, and troubleshoot multiple Oracle production, development, and test databases while maintaining the corporate service level agreement of 99.99% up time
• Installed Oracle databases for Data Warehouse projects
• Created users and maintained security on Oracle databases for Data Warehouse projects
• Created indexes Oracle databases for Data Warehouse projects
• Performed performance tuning on Oracle databases for Data Warehouse projects
• Upgraded Oracle databases from 8i to 9i
• Installed patches, bug fixes as necessary
• Developed and maintained programs required for financial applications
• Engineered and created data flow, data mapping, and other technical documents for data warehouse projects