June 1999 - ACS,
Inc. State Healthcare Division (formerly Consultec LLC)
Present Atlanta, GA/ East Lansing, MI
Designed and developed two and three tier client/server applications using Powerbuilder 6.5, 7.0 and 9.0 as the front end development tool, and a variety of Oracle and Sybase databases on the backend. Designed, developed, unit and system tested business application logic, user interface and stored procedures/functions on multiple platforms. Served as the back-up product team manager in the absence of my supervisor – overseeing a development staff of 14. Served as a project manager for a full-lifecycle software development project. Provided support to users and operations staff including troubleshooting application issues and handling changes in the technical environment. Conducted user training and prepared user documentation and online help as well as technical system documentation. Provided technical and functional content to marketing and proposal efforts.
Project manager for the entire HEDIS project lifecycle for the State of Montana. Planned the project, created a project notebook including EV metrics based on the cost model (working with the PMO) and managed the execution of the design and development of a prototype and the subsequent project phases including requirements gathering, design, development, unit and system testing, UAT, and operational turnover. Managed resources and budget, conducted bi-weekly project team meetings and provided weekly project scorecard reports to upper management. Also created the system architecture design and participated in system development as a Powerbuilder resource.
Oracle PL/SQL stored procedures on the backend, which reside in a schema on the data warehouse (Oracle 9i). Two-tier Powerbuilder 9 front-end reporting application which allows for user-definition of runtime parameters and user-execution of the back-end analytics.
Responsible for the design, development and unit testing of new releases and enhancements of the existing Powerbuilder applications, as well as the implementation and configuration of the software for new clients, and ongoing support and maintenance to existing customer sites. Create detailed documentation of work and maintain the application database stored procedures and kornshell scripts.
Powerbuilder 9 application with a standalone Powerbuilder 9 engine application that runs batch jobs.
The application data and the data mart reside on Oracle (although there is a Sybase ASE 12/ASIQ 12.4.2 implementation currently in supported in production in North Carolina). The versions of Oracle currently supported range from 18.104.22.168.0 to 22.214.171.124. An automated off-hours transformation process on the Solaris database server pauses job processing and performs the extract from the data warehouse, loads the OmniAlert tables, performs database maintenance, and removes old data.
Created and unit-tested backend PL/SQL stored procedures for the application security and scheduler modules. Created cleansed warehouse data for test/demo environment using PL/SQL procedures.
J2EE framework on WebLogic application server with Oracle 9i backend (resides on the data warehouse). JAVA servlets are passed to the browsers on user workstations.
Prepared internal design for system enhancements consisting of program specifications, file descriptions, screen designs, record layouts, report layouts, and workflows. Coded, tested, and debugged programs from the internal design specifications. Assisted in the production of user documentation and online help. Conducted walk-throughs of design and code for client and team peers. Responsible for the system implementation at various call centers including technical support, system configuration, and end user training.
Two-tier online application with user interface/business logic developed using Powerbuilder 6.5 and ASA 6 (and 7 up to 7.0.2) backend. Separate batch applications for loading provider and member files and for the archive/recall of old communication records also developed using Powerbuilder 6.5.
Developed enhancements migrated from PB5 to 6.5. Participated in system testing and fixed application bugs in preparation for system acceptance by the State of North Carolina.
Two-tier application with user interface/business logic developed using Powerbuilder 6.5 and Map Objects with an ASIQ 12.4.2 backend.
Drug Rebate Analysis Management System (DRAMS)
Designed and developed several search and display windows as well as reusable control objects for the commercial provider version of the application. Also participated in system testing in preparation for system acceptance by the State of Montana and the State of Minnesota.
Two-tier application with user interface/business logic developed using Powerbuilder 6.5 and Oracle 8.0 backend.
PC Support Technician
Assisted in preparing Windows 95 and NT workstations for Y2K. Provided technical assistance to the user group with software and hardware problems. Built PC Workstations, ghosted machines, and applied troubleshooting skills to system performance problems.
SAP Implementation Consultant
Provided user support, conducted user training and assisted in the design of system changes for the Performance Polymers division's implementation of the SAP R/3 software Materials Management (MM) and Sales and Distribution (SD) modules. Also developed user and system documentation.
December 1998 Central
Mt. Pleasant, Michigan
Bachelor of Science in Business Administration
Major: Management Information Systems
Overall GPA: 3.34 (4.0 Scale)
September 1998 Themis
Mainframe Immersion Certification
Classes: MVS/JCL, TSO/ISPF, MVS Utilities, Introduction to COBOL Programming, VSAM Programming & Optimization, DB2 SQL & Application Programming, CICS Command Level Programming.
May 2000 Lansing
Client/Server Applications Development in Powerbuilder 6.5
October 2001 Sybase
Fast Track To Powerbuilder 7.0
May 2003 Compuware
Performance Tuning and Analysis with DevPartner Java Edition
May 2003 Compuware
QA Center Enterprise Training Classes: Test Automation Using QA Run, Test Management Using QA Director
June 2003 ACS,
MMIS Concepts Class
June 2003 ACS Professional Development Center
Advanced Medicaid Claims Processing Class
May 2005 Cognos Training Services
Cognos ReportNet FastTrack
May 2005 Cognos Training Services
PowerPlay Transformer OLAP Modeling and Report Building
August 2005 ACS Professional Development Center
Introduction To Project Management
Handy Powerbuilder and other client/server development links:
PFC (PowerBuilder Foundation Class) Tips and Tricks
Undocumented Datawindow Secrets
Good Oracle PL/SQL FAQ
General Oracle FAQ
Oracle 10g Enterprise Home
Sybase Adaptive Server Enterprise Home
Sybase IQ Home
Microsoft Developers Network Home