Programmer/Project Manager

IBM, Austin, TX 1998-2009
Project Lead
Specialized experience in data warehousing, reporting, database access, ETL design and development

Designed and implemented a new product that provided data warehouse and reporting capability for storage network installations. Installed and configured product and development environment, assisted team members with hardware and software troubleshooting. Maintained and reported team status, defined detailed design, participated in reviews for design and code implementation.
· Implemented SQL scripts to extract transform and load data (ETL) for data warehouse.
· Conducted programs in Java and Visual Basic using ODBC and JDBC to collect and reconfigure data.
· Worked on collection of data to Data Warehouse from Sybase, MS-SQL, Oracle and DB2 databases.
· Assisted in identification and handling of information detail and categorization for data warehouse global reusable common components.
· Worked on design and implementation of several IBM proprietary data warehouse reporting engines that supported DB2 and Oracle.
· Created over 25 reports addressing formulas, sub-totals, totals, hourly status and forecasting.
· Addressed reporting related to storage resource management and SAN environments, space usage for load balancing, monitoring daily status on scheduled backup and archive jobs.
· Prepared detailed design documentation that was used to prepare service documenttation.
· Implemented projects for operation on multiple operating systems including, AIX, UNIX, Windows, and mainframe.
· All projects addressed implementations using multiple languages.

CONTRACT & CONSULTING POSITIONS 1993-1997
City of Austin Health Department
Project Manager
Conducted physical inventory of computers in Travis County Health Services offices in preparation for upgrade to new state immunization tracking system.

SUN Integration
Test Coordinator
Wrote testing overview, maintained testing schedule, tracked defect reports, and participated in daily project review meetings for team developing Internet Service Provider Network at Sprint.

Abbott Diagnostic Division
Project Manager
Lead a ten person team that developed test strategies and test plans to verify 23 test tools used in the development of a new blood test instrument requiring FDA certification. Team also executed testing and documented results.

MCI
System Analyst/Programmer
· Consultant for a Data Warehouse project in Colorado Springs, CO using Sybase on AIX 6000 platform. Code ksh shell scripts to collect source input files via FTP and awk scripts to normalize data for input into database; create SQL tables, procedures, indexes for source data load.
· Outlined and implemented a configuration management system to use for tracking ETL scripts.
· Designed, implemented and documented voice prompt management system for multi-tasking client-server automated call processor.
· Designed tool to dynamically allocate memory for an internal data base used by the call processing application.

Texas Instruments
Team Lead
Tracked status of eight person team enhancing a Voice Dialing System, reported weekly status, tracked defects for project
Programmer
Designed and implemented a user interface to monitor T1 lines and DSP channel activity and utilities to collect status information from shared memory about incoming and outgoing lines, and format information for display using bourne and ksh scripts.

Citicorp TTI, Santa Monica CA 1983-1992
Project Manage
Managed an 80 member development team that delivered $4M in projects over 2 years. Enhanced and maintained 300 ATM X.25 Wide Area Network and network monitoring facility for Citibank in Germany.
Programmer/Team Lead
· Served as team leader for over 15 projects with three to six members.
· Coded in C for proprietary ATM systems, responsible for verifying design specifications.
· Designed ATM back office administration function and implemented interface definition.
· Created design to backward engineer table driven ATM system of an acquired bank to work with custom touch screen ATM unit built on UNIX engine.
· Implemented in 8080 assembly language, Chinese graphic character language screens.
· Worked in Quality Assurance and Integration testing of ATM banking network.

EDUCATION
PMP Certification Intensive Training. St. Edwards Professional Education Center. Test September, 2009.
M.S. Management Information Systems. In Progress. St. Edwards University Austin, TX.
Technical Training as required during career: Accounting, Data Communications, Project Management, Systems Design Methodology, PC Network Configuration, C++ and object oriented design, Visual Basic and several other programming languages.
M.A. Humanities-Art History, California State University, Dominques Hills CA.
California State University International Studies Program. Selected for 1 year program in Florence, Italy
B.A. Art and Education, Rosary College, River Forest, IL

COMMUNITY SERVICE
Travis County Board of Elections 2006-present Election Judge
Webmaster volunteer for 5 community organizations
Lakeway Citizen Police Academy graduate 2009
Meals on Wheels, 2004-present, Tivoli Team, Route 90