The Gillette Company

Data Warehouse Analyst / Developer / Team Leader

Jan-01

Aug-02

• Analysis and Design for extracting Gross Sales Pricing Conditions from SAP R/3 4.6 and loading into the Global Data Warehouse and downstream interfaces. Analysis, Design, development and implementation of Orders and Deliveries Reconciliation between SAP R/3 and the Global Data Warehouse. Analysis and Design and Team Lead for the Global Order Status Harmonization Project in which Order and Delivery measures reported to downstream interfaces were standardized for all markets. Team Lead for inclusion of ECO Fees into the Orders, Deliveries and Invoices data stores for European markets for reporting to downstream report marts.

Codman

Oracle SQL Developer

Apr-00

Jun-00

• Analysis and Design for adding the End-User Sales into the Corporate-wide Data Repository. Included all batch processing and associated controls.

Codman

Oracle SQL Developer

Nov-99

Apr-00

• Identified, communicated and resolved major issues with the interface between Indirect Sales and the Commissions System.

Codman

Oracle SQL Developer

Aug-99

Oct-99

• Analysis, Design and Implementation of a number of complex Oracle queries and file exports to support a Federal Government Pricing Audit conducted by Ernst & Young. This project involved a number of queries, work tables and UNIX Scripts.

Codman

Oracle SQL Developer

Jun-99

Sep-99

• Analysis and Design of manual and automated processes associated with the Resolution of various Pricing Issues between the local Pricing systems and Corporate Pricing Systems.

Codman

Cognos Impromptu / PowerPlay Developer

May-99

Jun-99

• Analysis, Design and Implementation of the First Production PowerCube for the Marketing department. This involved upgrading the Pilot PowerCube to incorporate additional measures and categories. Also included a number of "canned" reports for user sales analysis.

Codman

Systems Integrator

Sep-98

Sep-98

• Planned, coordinated and successfully implemented the client-side upgrade for Oracle SQL*Net v2 and PB 5.04 run-time DLL's for approximately 1200 users.

Codman

Systems Integrator

Aug-98

Jan-00

• Planned Y2K Test Design and Executed Y2K Testing for a number of PowerBuilder / Oracle applications. Off-site support for actual turn of events for Y2K.

Codman

Cognos Impromptu / PowerPlay Developer

Aug-98

Nov-98

• Analysis, Design and Initial Implementation of a Pilot Cognos PowerCube for the Marketing department. This involved utilizing Impromptu 4.0 to create a catalog of the data warehouse, create and test the necessary queries, define the model, and build the cube on a weekly basis. The Cube was then copied to a shared area on the Network for client access.

Boston Edison

Systems Integrator

Apr-95

May-96

• Lead Analyst, Project Leader, Lead Technical Architect, Developer and Mentor role for Boston Edison's "Customer Service System". This back-office application allowed Telephone Reps to quickly respond to "Lights Out" scenarios based on information obtained from 3 different applications on multiple systems. This PB v4, Oracle application utilized the Attachmate 3270 and VT 100 terminal emulator APIs as well as interfacing to FastCall software running on the Automatic Call Distribution system.

Boston Edison

Instructor

Mar-95

Mar-95

• Instructor for Attachmate Class on API for PowerBuilder. Received excellent feedback.

Boston Gas Company

SQL Query Developer

Aug-92

Aug-92

• Develop SQL Queries; Assist Engineering Dept with queries from new mainframe (IDMS/R) Master Directory database.