Career Summary

Areas of strength include strong analytical, technical and communication skills, strong team member able to take on any role assigned. Looking for an opportunity to increase my project management skill set and to provide excellent customer service.

Occupational Licenses & Certificates:Project Management Institute, Project Management Professional

Education : Bachelor of Arts Degree

Software:MicroSoft applications (EXCEL, Project, PowerPoint, WORD, VISIO, etc.),
COBOLII, JCL, TSO/SPF/ISPF, ORACLE SQL, Xpediter, SlickEdit, TOAD

Hardware:IBM mainframe - OS/ZOS; Personal Computers - Windows

DBMS: ORACLE, DB2, MS SQL SERVER

Professional Experience

Confidential, Inc Team Lead, Developer 11/2001 - 10/2011

Accounting application team lead on the FederalRetirement Thrift Investment Board (FRTIB) contract for the government employee Thrift Savings Plan (TSP) 401k mission critical accounting application for ten years. Hired as Sub-contractor the first three years and employee Technical Team Lead for seven years.

11/2001 10/2004
Sub-contractor during the initial requirements, development and implementation stages of the two year project. The only developer on a four person team containing a Project Manager and two accountants, solely responsible for the accounting application technical section of the project requirements document presented to FRTIB; solely responsible for the analysis, design and development of the mainframe modules. Responsibilities included:

• Chaired meetings with accounting analysts reviewed work flow, reports and processes of legacy application; defined business rules
• Chaired meetings with analysts and developers for the upstream mainframe OmniPlus and downstream server Savantage COTS applications discussed data flow, data elements, job execution flow, data retrieval and output processing requirements
• Chaired meetings with ORACLE database administrators (DBA) discussed table layouts and schemas, server system and database table requirements
• Designed the business rules translation reference tables. ORACLE tables containing upstream COTS data element values and the business rules to convert to downstream COTS data elements values. Designed to minimize future module modification.
• Developed SQL scripts executed by DBA to load and modify tables using TOAD for ORACLE data analysis tool
• My system analysis was essential to the definition and development of system mainframe interface files and server ORACLE table layouts and schemas
• Instrumental in the overall client/server system design by dividing the application into three major functions: data retrieval preprocessor, data reformat and database table interface.
• Designed and developed the mainframe driver modules for each of the major functions
• Designed and developed a common sub-routine used by the Cash, Disbursement and General Ledger mainframe database interface table modules to reformat and insert general ledger transactions into the COTS accounting general journal tables
• After implementation
• trained and assisted team members on the accounting application
• provided 24/7 accounting application production support
• Completed system documentation
• Developed VISIO data, system and job flow diagrams
• Created WORD document versions of modules, specifications, production job schedules and job dependencies

10/2004 10/2009
Technical Team Lead of a two person team responsible for the maintenance of the accounting application modules for the following client system change requests (SCR) due to FRTIB initiatives; major COTS version upgrades; major mainframe and virtual server hardware upgrades; and ORACLE database version upgrades. Responsibilities included:

• Attended daily production support meetings discuss issues pertaining to application; upcoming events
• Attended weekly team leads meetings discuss current and upcoming projects, issues
• Attended test team meetings discuss testing schedules, issues
• Attended CM meetings discuss module and project promotions, issues
• SCR implementation
• attend meetings to review requirements with other application team leads
• develop impact assessments, manpower estimates
• determine accounting application tasks, add tasks to overall project plan
• attend meetings to discuss project progress, modify project plan as necessary
• develop program specifications
• design modifications to application system flow if necessary
• assist in the development, testing, and implementation of application modifications

10/2009 10/2011
Technical Team Lead of a five person team consisting of a Team Lead, Business Analyst and two Software Engineers. The team was responsible for the replacement of the COTS Savantage Altimate server Disbursement Module with the COTS OmniPay mainframe Disbursement Module. This project involved a complete reworking/rewriting of the major functions of the accounting application as well as data migration from ORACLE tables to mainframe VSAM files. Responsibilities included:

• Attained the Project Management Professional (PMP) certification
• Incorporated PMI processes and procedures in COTS package upgrade
• Determined project stakeholders
• Produced work breakdown structure chart and dictionary; determined critical tasks
• Produced Issues log, tracked risks, determined critical path, determined product milestones
• Lead data migration from ORACLE tables to mainframe VSAM files
• Held data requirement meetings with mainframe front end analysts and server backend analysts
• Held data business rules meetings with Accounting Operations team
• Developed data migration matrix containing ORACLE table columns, corresponding VSAM data elements and the business rules associated to format the data values
• Developed migration data flows and migration flat file layouts
• Developed SQL statements to retrieve data values from ORACLE tables
• Developed scope, functional design and program specification documents
• Assisted with migration files data verification
• Assisted with migration module development and unit/integration testing
• Assisted the BA
• Attended requirement meetings with FRTIB, Accounting Operations, COTS analysts, and DBA
• Produced scope, functional design and program specification documents
• Instrumental in the redesign of the ORACLE business rules reference tables

Confidential, Consultant, Team Leader 06/2000 - 06/2001

On-site Team Lead managing four telecommuting developers maintaining CICS modules for various client units at BNA. The team provided maintenance support for business and financial applications. My responsibilities included:

• Reviewed and analyzed client requests; reviewed proposed modifications with client
• Determined modules to be modified, produced program specifications and assigned modules to team
• Chaired team meetings and code walkthroughs via telephone conference calls
• Provided technical assistance when needed
• Coordinated team module hand-off process to QA by functionally packaging modules into weekly promotions; assisted during UAT
• Chaired weekly status report meetings with client
• Reviewed and compiled team weekly time sheets delivered to client

Confidential, Consultant, Team Leader 01/1997 - 05/2000

Team Lead on a five member team consisting of four developers tasked with the development of a telephone billing application using Micro-Focus COBOL accessing ORACLE database tables. Responsibilities included:

• Reviewed and modified system requirements with project manager
• Developed system flows; analyzed, designed modules; produced module specifications and assigned modules to team members
• Coded main driver and 15 sub-drivers
• Provided weekly progress reports to management team
• Provided project updates to project plan
• Assisted with unit, intersystem and UAT testing
• Ported completed application to the IBM mainframe, modified modules to access DB2 tables

Confidential,Project Lead 1989 - 1996

Production Support manager and a PowerBuilder developer.
As Production Support Manager for the Software Defined Network billing application, responsibilities included:

• Attended monthly management meetings discuss issues pertaining to application; upcoming events
• Supervised a team consisting of six production and one CM support personnel
• Ensured the timely completion of nightly production mainframe jobs with 24/7 support
• Supervised the analysis and correction of production issues
• Chaired daily production support meetings reviewing the previous night’s execution and tracking areas for improvement
• Implemented parallel job executions which fine tuned and shortened production run time
• Managed documentation modifications to production job schedules and job dependencies charts
• Managed release software moves from development to test and production
• Reviewed and signed time sheets; conducted performance reviews

As a PowerBuilder developer, assisted in the development and implementation of a data table management application for mission critical legacy reference and operational data. Responsibilities included:

• Reviewed program specifications; voiced recommendations on system implementation
• Assisted with system design and program specifications
• Assigned as a liaison between team and interfacing groups
• Maintained the application MS SQL Server security tables.
• Point of contact with Data Base Administration Group and technical liaison to PowerSoft technical support group
• Designed application security schema and the associated MS SQL Server database tables
• Developed backend stored procedures to access MS SQL Server tables
• Developed FTP and PowerBuilder script to migrate table data from mainframe to server