TECHNICAL EXPERTISE

Software

CASE Tools CA-Gen, AllFusion Gen, AdvantageGen, COOL:Gen, Composer, IEF , CANAM Report Composer, Crystal Reports, COBOL, COBOL II, TSO/ISPF, JCL, SPUFI, QMF, Test Director, BU Designer, SAP R/3 FI/CO, Panvalet, FileAid, AbendAid, MS Office, MS Project, Kintana, NIKU, SABRE System, Lotus Notes

Database

DB2, DB2/2, Access for DB2, Oracle, PL/SQL, Toad for Oracle, IMS, DL/1, MS Access

Environment/Communication Tools

IBM Mainframe, MVS, IMS, CICS, CE/CSE Access, UNIX, COM Proxy, ASP, MQ Series, GuardIEn, AUTOSYS, Tandem, Windows NT, TCP/IP, Librarian, Endevor, Changeman, Component Based Development, Client/Server Architecture, Full Software Development Life Cycle Methodology SDLC

PROFESSIONAL EXPERIENCE

Confidential

Performing design and development for the Child Support System of online and batch COOL:Gen modules and COBOL programs on the DB2/CICS platform. Design, development, maintenance, and administration of Data Models. Researching and providing solutions to the outstanding customer requests to correct errors in the Legal, Case and Financial Subsystems. Supporting user requirements by creating analysis documentation including Conceptual Designs and Detail Designs and performing system impact analysis for upcoming changes. Managing, coordinating, and documenting technical related activities between Technical Team, QA Team and business staff. Analyzing and resolving reported problems from the users and testers and coordinating fixes with the software vendors, DBAs, and IT management.

Confidential

Design and development of new COOL:Gen Graphical User Interface windows, batch programs and Unix scripts for the Automation Project of the Computron Costing System on the Oracle/Unix platform. Maintenance and enhancements of the existing production batch and online modules, including analyzing and modifying modules to improve operating performance and eliminate errors. Enforced Cool:Gen Standards, Guidelines and Procedures related to the management of the data model objects. Approved deliverables produced by business analysts and external IT suppliers. Participated in scheduling and coordination with senior accountants of the monthly financial close cycle. Provided assistance and guidance to lower level analysts and programmers

Confidential

Provided support in the roll out of Oracle-based software packages to all State Courts. Development and maintenance of the complex reporting system using COOL:Gen, CANAM Report Composer and Crystal Reports in the Client/Server Encyclopedia and GUI environment under Windows NT. Working directly with business staff to determine best technical solutions for business requirements, analyzing functional specifications and writing technical specifications and software release documentation.

Confidential

Software Engineering using COOL:Gen and Report Composer on Tandem/Oracle platform in Component Based Development for the Texas Medicaid Healthcare System. Participated in the Business User Requirement interacting with the state government client, Technical Detail Design and Development Phase for the National Provider Identifier project. Developed and implemented a new major component for the Attestation Data Model. Designed and generated reports and file handling utilities for the Cash Financial Reporting System using CANAM Report Composer.

Confidential

Performed full life cycle development effort of American Freightways System conversion into FedEx Freight System on DB2/CICS platform. Identified COOL:Gen, Report Composer and COBOL objects to be modified to conform to the new address functionality. Conducted impact analysis across multiple Data Models and systems, eliminated obsolete modules, defined requirements and designed, coded and implemented the impacted modules. Performed data modeling and ERD changes with retransformations to DSD and Encyclopedia Administrator duties as needed, including model migrations, code object migrations, adoptions, user access and version control.

Confidential

Participated in the design and development of the Health Plan Membership Address Project for the critical healthcare CBS Foundation System in the MVS/CICS/DB2 environment. The COOL:Gen objects comprised of block mode online screens, GUI windows, and batch programs. Delivery of the project included working with the development teams to understand the implementation of requirements, designing and coding COOL:Gen and COBOL programs, revising and submitting JCL jobs, participating in code peer reviews, conducting unit and peer testing and documenting detailed test plans to ensure smooth implementation.

Confidential

Developed and implemented new components for the CDE Personal Lines System utilizing COOL:Gen Component Based Development techniques and methodology. Performed Construction of MVS based transactions and Packaging with COM Proxy generation of DLLs and ASPs for the Web-based client. Created test cases and test harnesses for the Unit and Integration Test in the CICS regions with the MQ Series and coordinated with the testers the deployment of monthly and quarterly releases. Analyzed and solved existing production system discrepancies. Provided technical guidance and mentoring to junior staff members.

Confidential

Developed and implemented batch and online procedures and Common Action Blocks programs to incorporate new Regional Jets Agreements for the Airline Passenger Revenue Accounting System using Cool:Gen CASE tool. Added new functionality to the existing IMS online procedures. Developed new COBOL External Action Blocks in MVS/DB2 environment with JCL. Responsible for meeting with customers, gathering requirements and obtaining final customer approvals for system enhancements. Conducted technical walkthroughs, created design specifications, and performed software testing.

Confidential

Designed, implemented and maintained batch processing and on-line transactions using Cool:Gen/Composer toolset for the Airline Passenger Revenue Accounting Application. Performed business analysis, including detailed analysis of federal registers to formulate business requirements and design specifications for the Airline Origin and Destination Survey System to comply with the Department of Transportation government regulations. Completed the design, construction, unit and integration testing and data migration with Oracle SQL into UNIX server of the Passenger Yield Analysis System. Converted Developer 2000/Oracle reports into CANAM Report Composer reports using input from procedures. Established Report Composer as a reporting tool standard and created complete technical documentation, including program design specifications, data analysis, test plans, user-training manuals, UNIX shell scripting and scheduling for the report processing of the entire system. Provided 24 hour multiple client on call support in UNIX/Oracle environment.

Confidential

Responsible for development, enhancements and support of the 23 complex mainframe financial systems for the Semiconductor Group in MVS/DB2 environment with JCL. Developed online block mode transactions in IEF and batch COBOL/DB2 programs with embedded SQL. Performed Encyclopedia Administration duties on rotating basis, including data model backups, migrations, installations and version control. Coordinated testing and implementation of the interfacing systems and enhanced DB2 performance functions for the Financial Transaction System. Managed team responsible for business analysis on eliminating legacy mainframe systems as a Project Lead on the Capital Expenditures System. Created detailed scripts, system configuration, and conducted customer presentations of the business scenarios using SAP R/3. Performed Configuration Management and Quality Assurance duties. Assisted with a transition of a large development team to a self-directed work team. Provided 24 hour worldwide customer base support in MVS/DB2 environment.