HDR, Inc.  PeopleSoft Consultant

• Re-engineer Visual Basic/Access Project Forecasting Application in PeopleSoft
• Re-Create Project reports in SQR

Modules: Project Costing

Period: March 2002 - Present

United Health Group PeopleSoft Consultant

• Participated in Financials Upgrade v.7.0 - v.8.0(SP2)
• Responsible for Adding 6 New Chartfields to all AR/Billing Application Engine Programs
• Modified/Tested External Banking Data loads
• Modified/Tested Refund Processing

Modules: Accounts Receivable/Billing

Period: October 2001 - March 2002

Sprint North Supply PeopleSoft Consultant

• Participated in v.8.0 Implementation
• Modified Customer Information Pages to add additional Credit information
• Create additional Customer Hold Messages for Credit Holds
• Developed nightly process to place/remove additional Customer Credit Holds
• Design, Develop and implement process to allow analysts to modify and consolidate Customer invoices
• Design, develop and implement custom invoice sqr
• Design, develop custom Credit information page and update process
• Develop Custom page for analysts to intercept order lines and choose which ones to send to Billing System

Modules: Accounts Receivable/Billing/Order Management

Period: May 2001 - September 2001

Gallaudet University PeopleSoft Consultant

• Develop University specific Benefits Statement for Employees
• Extract K-12 Student Demographics and Academic Data from Ancillary Systems
• Develop Migration Plan to load K-12 Student data into PeopleSoft Higher Ed
• Prototype K-12 Student Records setup and demonstrate separation from Higher Ed

Modules: Human Resources/Payroll/Student Administration

Period: February 2001 - May 2001

University Of Michigan PeopleSoft Consultant

• Participated in Recruiting/Admissions Module Implementation
• Research and correct help desk issues for Recruiting/Admissions
• Developed/Modified/Tested External Data loads (Test Scores, Create Prospects/Applicants)
• Develop Internet Prospect Load Application
• Design, develop and implement Medical School Applicant Interface
• Re-design COBOL processes to SQR
• Production Support

Modules: Student Administration

Period: April 2000 - February 2001

PK Solutions, Inc. PeopleSoft Consultant

• Participated in GL Conversion to add reporting levels to financial structure
• Developed Various Financial reports using NVision
• Developed scripts for data conversion

Modules: General Ledger

Period: January 2000

Time Warner Cable PeopleSoft Consultant

• Participated in HRMS/Payroll/Pension Administration Implementation
• Evaluated Output Distribution Software to Interface with PeopleSoft
• Wrote Conversion software
• Loaded Conversion Data from flat files using SMARTDB
• Wrote/Modified SQR reports, Panels, processes
• Wrote SQR interfaces for ACH, Positive Pay, and others
• Applied TAX Updates to various databases
• Developed additional functionality(KRONOS Time Keeping Interface)
• Applied Tools Upgrade, Patches and Fixes
• Update COBOL for Union Pension Calculations using MicroFocus Object COBOL

Modules: Human Resources/Payroll/Benefits Administration

Period:   October 1999 – April 2000

PK Solution, Inc.

PeopleSoft Implementation Partner, Consultant
 

• SQR Development
• Develop Run Control Panels
• Process Definitions
• Assisted with User Acceptance Testing
• Provided additional customization programming support

Modules: Human Resources/Payroll

Period: December 1998 - June 1999

First Data Corporation

Integrated Payment Systems Application Development, Senior Systems Analyst
 

• Project Lead
• Application DBA
• Subject Matter Expert Cashtax Applications
• CICS Conversion from v2.0 to v4.1
• Provide System development and programming analysis
• Co-developed TTAX Plus Tax Payment System
• Assisted in the development of Structured Development Methodology
• Conversion of PC product to utilize TCP/IP interface to mainframe application

Henry Ford Health Systems

Patient Encounter & Financial Applications , Senior Systems Analyst
 

• Project Lead
• Business Analyst
• Application DBA
• Provide system development and programming analysis.
• Developed Hospital Service and Station Census Tracking & Analysis.
• Enhanced Inpatient Satisfaction Survey Application.
• Re Engineered Intensive Care Physicians Reporting DB2 Database.
• Developed Executive queries for Intensive Care Physicians.

Chrysler Corporation World Headquarters

Market Representation, Senior Systems Analyst
 

• Project Lead
• Business Analyst
• Application DBA
• Co-Designed Sybase Dealer Database
• Developed Sybase Database Table Administrator Application.
• Developed Dealer Database Maintenance Application.
• Documented and Presented Dealer Database ERD.
• Assisted in developing Application Security requirements and procedures.
• Developed interface to Mainframe DB2 tables from Sybase Database

Product Developer
 

• Co-developed Automated testing software to run Compuware's mainframe product line Hiperstation.
• Wrote upgrade to an existing product, Playback + for CICS.
• Development used VISUAL BASIC v.3.0/4.0, ACCESS and several other third party controls.
• Assisted in Quality Assurance testing and debugging efforts for several products.

K-Mart World Headquarters

Senior Systems Analyst
 

• Re-engineer the prototype design for the Shelf Landed Costing System
• New designs included DB2 tables, COBOL programs, JCL, SyncSort and other tools
• Documented with Data Flow Diagrams and System Flow Diagrams

Chrysler Corporation MIS

Senior Systems Analyst
 

• Project Lead
• Business Analyst
• Application DBA
• Developed Application for the Chrysler Customer Assistance Center
• Used ODBC interface to Sybase tables in a UNIX environment.
• Developed interface to ACCESS application.
• Developed interface to unload the Sybase tables, and update DB2 tables using COBOL II with
• IMS Checkpoint Restart facility.
• Provided System Documentation, Help Files, etc.

Buick Motor Division Sales and Marketing Division

Systems Engineer
 

• Provided Maintenance and Reporting Support for Buick ANSWERS Warranty System
• Developed Automated CAMIP Reporting Application for Quarterly Reports
• Developed Automated Warranty Reporting Application for Monthly Warranty Reports
• Converted ACCESS based Oldsmobile Product Tracking Application to be used by Buick
• Provided Consulting to Buick and EDS accounts for Excel applications/programming
• Assisted in development of Marketing Application to Excel files
• Assisted Account in Buick Dealer Reorganizations

EDS Mid Michigan Regional Support Center

Systems Engineer
 

• Redesigned and developed DCI Marketing Survey System
• Responsible for conversion of 3 of 36 systems involved in the Buick Dealer
• Code Evaluation Project
• Assisted in Documentation and Implementation of all affected systems for the
• Buick Dealer Code Evaluation Project.
• Assisted in Year 2000 conversion of Saturn Engineering Systems