Bill Ritchie Email and Phone Number

Currently Junior Informatica Administrator and CA Workload Automation DE Administrator.Experience also includes :1. Informatica 10.1 Administration - VM Upgrades, 9.5.1 to 10.1 Migration, Security, Bash scripting, Administrative console, deployment of workflows using deployment groups and XML, applying patches, troubleshooting user problems.2. Oracle ETL development with stored procedures.3. Informativa ETL develoment - 9.5.1/10.1 Powercenter : Respository, Designer,Workflow, Monitor. Simple to complex design,development and deployment of mappings and workflows.3. Design ,development and deployment of CA Workload Automation Application/Job Flows. Includes on-call troubleshooting and support.

* Co-developed new, unique ORACLE procedure-based process that interfaced with existing C++ mailing address certification programs. Upgrade resulted in increase of available CPU processing during peak times and an overall 10% increase of system efficiency. * Designed and developed new ORACLE package consisting of procedures and functions, to extract aged Fundraising data from the company ORACLE data base and archive the data to offline storage. Data storage on the ORACLE production system was reduced by 30%, and performance increased on Fundraising queries by 10% - 25%. The monthly departmental Innovation award was received because of these efforts.* Directed Fundraising development team and participated in the upgrade of company ORACLE 8i database to version 10g. Modified package code, forms and reports to conform to new database standards and requirements. Tuned many PL-SQL queries, which achieved a 25% - 75% increase in performance. Project resulted in an overall increase in the efficiency, stability and security of the database.* Collaborated with offshore development partners and team of 5 local developers as the Technical Lead on pilot project to replace legacy ORACLE Fundraising forms and reports with web-based user interface. Designed and created back-end ORACLE PL-SQL-based procedures to seamlessly integrate with the new web site code. The projected provided a more efficient, robust interface. The monthly departmental Star Performer award was received because of these efforts.

* With minimal training and experience, became the Technical Lead for the Fundraising application on this multi-million dollar project that replaced aging legacy COBOL-based systems with an integrated, custom developed family of applications.Tuned over 100 forms, processes and reports for performance gains, creating more efficient code and reducing bottlenecks. Efforts helped increase overall system performance by 25%, reduced costs and consolidated company information.* Collaborated with contract partners and company teams to develop and maintain ORACLE-based enterprise application with ORACLE 6i forms/reports and Crystal reports.

MicroFocus COBOL Developer, developing custom enterprise applications and reports to be deployed to multiple customer locations.