Experience and Skills
Areas of Expertise
Industries
Crystal Reports ver. 8 thru 11
TOAD
PL/SQL
MS Word
MS Excel
SQL
SQL Tunning
SQL*Loader
SQL Packages, Trigger, Functions
Oracle 7 thru 19c
UNIX
Business Analysis
Data Warehousing
Project Planning
System Application Architecture Design
Large Scale Conversions
Systems Integration
System Design/Analysis
Data Design/Analysis
System Implementation
Testing
Oracle Data Loading from files
Business process automation
State Government
Manufacturing
Education
Professional Expertise
Reports Developer
Manages Crystal Report support.
Develops and implements Crystal Report update designs
Manages client training for Crystal Reports creation.
License design, print processing, and CYPRESS integration
Programmer/Senior Analyst
Develops and supported an Oracle license system.
Create and support several PL/SQL procedures for data processing.
Analise, implement and support several sub systems for License 2000.
Developed, monitor and maintain Web Credit Card Payment processing systems.
Support and maintain 4 License 2000 Systems along with MYLicense online system.
Senior Software Developer
Designed, developed, maintained
and supported a web based Oracle reporting system.
Created a data warehouse system and PL/SQL procedures for data processing
Work History
DM Incorporated August 2000 – Present
State of Michigan – Government
Senior Analyst
Converted mainframe data to an oracle database to meet system requirements for the License 2000 system. Designed an Email Notification System for broadcasts emails and payment notifications. Gathered requirements and did functional design for a credit card processing system that would create accountancy reports for the main accounting system based upon Agency, Department, unit and account code for each license type, handle credit card charge backs and cancelled payments, and do automatic transfers files to the MAIN and SIGMA accounting system. Gathered requirements and did functional design for a online bulk document and credit card processing system that would create user accounts from a excel spread sheet, verify and update licenses information, and create a generic payment point for the system to allow one credit card payment for multiple license types, process the payments to multiple licenses for finale processing. Create and process License, postcards and report formats to integrate with CYPRESS and the Consolidated Print Center.
Skills Used
Areas of Expertise
Crystal Reports ver. 8 thru 11
TOAD
PL/SQL
MS Word
MS Excel
SQL
SQL Tunning
SQL*Loader
SQL Packages, Trigger, Functions
Oracle 7 thru 19c
UNIX
Business Analysis
Data Warehousing
Project Planning
System Application Architecture Design
Large Scale Conversions
Systems Integration
System Design/Analysis
Data Design/Analysis
System Implementation
Testing
Oracle Data Loading from files
Business process automation
Steelcase - Sales
UNIX Support/Oracle Support after hours
Supported off business hours processes that loaded Oracle tables from a main frame export.
Experience and Skills
Areas of Expertise
Industries
Oracle 7 thru 19c
UNIX
Business process Monitoring
Manufacturing
Michigan Association of School Boards - Non-profit association
Crystal Reports Developer as needed
Supplied support, report design, and Crystal Report Training on an as needed basis
Experience and Skills
Areas of Expertise
Industries
Crystal Reports
Business Analysis
Training
Education
State of Michigan - Government
QA System Tester
System testing for the MiCSES system. Created records to test the MiCSES system as required by the System Test requirement documentation and report and found defects.
Experience and Skills
Areas of Expertise
Industries
System testing
Business Analysis
Testing
State Government
Anderson Clarke June 1998 to August 2000
State of Michigan - State Government
Senior Software Developer
Designed, developed, maintained and supported a web based Oracle reporting system. Responsible for the Oracle system support, programmer assignments and creation of a web based report system for a state wide online web based system. Created several PL/SQL procedures for data processing, report deployment and report scheduling. Aided in trouble shooting long running and complex Crystal Reports.
Experience and Skills
Areas of Expertise
Industries
PL/SQL
Dynamic SQL
SQL
SQL Tunning
SQL Packages, Trigger, Functions
Oracle
Business Analysis
Project Planning
System Application Architecture Design
System Design/Analysis
System Implementation
Testing
State Government
UPP Systems June 1997 to June 1998
Kellogg - Manufacturing
Programmer/Analyst, Customer Support Specialist
Maintained the sales system. Designed and implemented the interfaces. Tuned the system. Executed the duties of the System DBA.
Experience and Skills
Areas of Expertise
Industries
TOAD
PL/SQL
SQL
SQL Tunning
Oracle
Testing
Online Data sync process monitoring
Manufacturing
University of Michigan - Education August 1994 to May 1997
Programmer/Analyst
Designed, developed, maintained and supported the Dynamic Student Data Warehouse and the transcript order entry system. Maintained student data system. Trained the users on the system. Executed system testing and verified the results
Experience and Skills
Areas of Expertise
Industries
Crystal Reports
PL/SQL
SQL
SQL Packages, Trigger, Functions
Oracle
Mainframe Programming
Project Planning
System Application Architecture Design
Large Scale Conversions
Systems Integration
System Design/Analysis
Data Design/Analysis
System Implementation
Testing
Business process automation
Education
Certifications and Education
Bachelor of Business – Computer Information Systems, Ferris State University, Big Rapids, MI