Programming languages
June 1999 - ACS,
Inc. State Healthcare Division (formerly Consultec LLC)
Present Atlanta,
GA/ East Lansing, MI
Programmer/Analyst
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 Assignments:
HEDIS
Role:
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.
Technology:
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.
Role:
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.
Technology:
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 8.1.7.2.0 to 9.2.0.5. 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.
Role:
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.
Technology:
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.
Role:
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.
Technology:
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.
Population Manager
Role:
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.
Technology:
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)
Role:
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.
Technology:
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
Michigan University
Mt. Pleasant, Michigan
Bachelor of Science in Business
Administration
Major: Management Information
Systems
Overall GPA: 3.34 (4.0 Scale)
September 1998 Themis
Inc.
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
Community College
Client/Server Applications Development
in Powerbuilder 6.5
October 2001 Sybase
Educational Services
Fast Track To Powerbuilder 7.0
May 2003 Compuware
Corporation
Performance Tuning and Analysis
with DevPartner Java Edition
May 2003 Compuware
Corporation
QA Center Enterprise Training
Classes: Test Automation Using QA Run, Test Management Using QA Director
June 2003 ACS,
Inc
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
Sybase Adaptive Server Enterprise Home
Microsoft Developers Network Home