Patrick Larson Email & Phone Number

San Francisco, California, US

ETL Development using Ab Initio in a Teradata Warehouse.

St. Louis, Missouri, US

ETL Technical Lead first for Wachovia Securities and then Wells Fargo Advisors. Environment is Oracle Data Store and DB2 Warehouse using Informatica,

ETL Development using DataStage Server Edition (7.5.2) in an Oracle/Data Store, Teradata/Warehouse configuration. As migration to the Wachovia system apprroached, I began migrating to use Informatica in a Oracle/Data Store, DB2/Warehouse configuration. This position overlapped with my previous postion for 10 months.

Unix development in a Sun environment using PERL/Informix. This job consisted of using a vendor product that is a calculation and posting engine for performance measurement, (CheckFree's CALiPER), with an extensive application built around the core functionality. This system contained thousands of tables and over 7TB of combined storage.

Participated as a member of the core team that architected the new batch framework and participated in the Application Reengineering project which was the first project to make use of the new batch framework. My role was to act as an Analyst and Developer participating in all phases of development. We utilized Rational ReqPro for requirements, Test Manager.

Lead a team involved with the OMS project to integrate the proposed Himalaya order management system into the Bull mainframe backend, (BMI). Supervised the efforts of 5-7 people, holding regular status meetings, prioritization of tasks and issues, defect tracking with ClearQuest, implementation planning. When the overall program was cancelled, we actually.

Lead a team of developers through all phases of application development, implementation, and support in a Tandem environment. Documented and analyzed requirements, generated specifications, and supervised all aspects of code development. Programmed in COBOL, TACL, and occasionally in TAL using D30-D47 operating systems. Coordinated production primary and.

US

Analyzed, designed, coded, tested and implemented programs in a Tandem environment with the D30 operating system. Programs coded in COBOL with extensive use of NON-STOP SQL. Tandem skills include FUP, Peruse, Inspect, Control, Bint, SQLCI, Netbatch, and TMF. Additional IBM mainframe experience adding CA-7, Expediter, and DYL-280 to existing knowledge. Some.

Analyzed, designed, coded, tested and implemented both batch and on-line systems on a IBM 3080 series Mainframe. Programs were written in COBOL, CA-EARL, and UFO using structured programming techniques. JCL was written in OS/MVS-XA environment. Development tools and utilities included TSO/ISPF, ROSCOE, CA-LIBRARIAN, CA-TLMS, CA-DISPATCH and.

Designed, coded, tested and implemented a system to group securities together for settlement with a clearing house. This replaced a manual system and enabled the company to reduce costs significantly. On-line and batch programs were coded in COBOL using structured programming techniques. Heavy database, CASE, and documentation experience in a large.