SUMMARY:

• Over 22 years of experience in multiple areas of information technology such as application architecture and design, SQL performance tuning, project management, project budgeting, project leadership, systems analysis and design, programming, project implementation,, support, recruiting, and resource management. Seeking a position to lead project initiatives by applying my experience, abilities, and skills with emphasis on the following:
• System design and architecture
• Strategic planning and project management
• Customer consulting and collaboration
• Oral and written communication
• Management and leadership
• Analysis and reporting
• Providing solutions and solving problems
• Learning new systems, applications, software, and processes
• The ability to effectively work on multiple project efforts

TECHNICAL SKILLS:

Hardware: IBM 3090/400E and various IBM compatible personal computers.

Languages: COBOL, COLBOL II, SQL, SAS, JCL, CICS, IMS DC, BASIC, SAP ABAP4 ( only), Focus, Data Analyzer, CA - IDEAL, Visual Basic, Power Builder, and MARK4.

Software: TSO/ISPF, FILE AID, FILE AID for DB2, ErWin, ENDEVOR, IBM utilities, Xpeditor, QMF, SPUFI, BMC, CA-IDEAL DeBugger, CA-7, and CA-LIBRARIAN.

Operating Systems: MVS/XA, MS/DOS, Windows (NT, XP, 2000)

PC software: MS Access, MS Word, MS Excel, MS Project, MS PowerPoint, Outlook 2000.

PROFESSIONAL EXPERIENCE:

Confidential - Richardson, Texas

Data Warehouse Architect/Consultant

Responsibilities:

• Design, develop, and implement modifications to add data elements to various ETL processes for various projects (including DB2 UDB load scripts and SAS programs). Assist with the design, development, and implementation of various drug related regulatory changes (HIPAA, Medicare Part B) as they affect
• Data Warehouse processes. Provide solutions for optimization of ETL processes, with heavy emphasis on optimizing DB2 SQL processes (using both IBM High Performance Unload utilities and COBOL). Assist with the management of multiple projects that require phased implementations. Consult with user teams to help with the efficient access of data from Data Warehouse tables. Work with near-shore and off-shore resources to provide technical solutions to enhance Data Warehouse processes. Work with multiple application areas that feed the Data Warehouse on various projects. Manage the mainframe efforts for multiple projects at once.

Confidential - Dallas, Texas

Architect/SME/Consultant

Responsibilities:

• Designed and developed enhancements to the Strategic Rewards System to facilitate modifications for the Address Expansion project. Work effort included the creation of a new common service to extract demographic information from DB2 to include in communications with various partners and vendors.
• Efforts also included post implementation performance enhancement improvements to long running DB2 processes. Processing time cut by at least 50% by modifying SQL calls or overall program logic and flow. Played a major role in the design, development, and implementation of DB2 data extract processes to facilitate nightly processing for the MORE project. Assisted in the design, development, and implementation of solutions involving DB2 processes for the Strategic Rewards Solution area.

Confidential - Richardson, Texas

Data Warehouse Architect/Consultant

Responsibilities:

• Assisted with the design, development, and implementation of changes to add data elements to various ETL processes for various projects. Assisted with the design, development, and implementation of regulatory changes for the National Provider Identifier (NPI) project for the Confidential data warehouse. Provided solutions for helping analysts to identify reasons for the rejection of external prescription/medical claims. Offered solutions for optimization of long running processes. Provided part-time assistance (as needed) with various ETL processes involving populating various data warehouse tables with data from the mainframe.

Confidential - Dallas, Texas

Architect/SME/Consultant

Responsibilities:

• Played a major role in the design, management, development, and implementation of the Strategic Rewards Solution mainframe DB2 database application in . Served as the lead application architect/SME for the design of the database model (using the Erwin modeling tool). Worked closely with DBA’s to identify performance improvements for the database table calls in application programs.
• Continuously providing project consultation and production support consultation to the technical staff and various corporate business areas on efficient and effective database access for rewards data. Very proficient in the efficient access of data stored in relational database tables using SQL. Served as the lead architect for the transition efforts of the Legacy Confidential rewards systems to the MBNA rewards system. Constantly sought to provide value-added designs, process improvements, and ideas to help the technology sector provide solutions that help drive business. Assisted in managing the projects to help keep them on the designated timeline.

Confidential

Project Manager/Technical Lead

Responsibilities:

• Managed and coordinated multiple mainframe initiatives. Provided project and production liaison support between technical staff and various corporate business areas. MBNA is a major credit card processor with staff in Dallas, Delaware, England, Ireland, and Spain. Coordination of efforts for successful implementations requires adhering to a strict corporate systems development methodology, as well as creation, reviews, and approval of COBOL/DB2 code, JCL, and architectural designs. SAS programs, QMF queries, MS Access databases, and SyncSort utilities are used to assist with testing efforts and quality validation procedures. Project efforts include but are not limited to architecture and infrastructure planning, data modeling and database design, testing coordination, implementation planning, timeline planning, project budgets and resource planning, and status reporting to customers, technical staff, and senior management.

Confidential - Plano, Texas

Consultant

Responsibilities:

• Provided baseline support, including on-call 1 week per month, for an accounts receivables system writing in Walker Tools. The batch portion of the system utilized COBOLII/JCL and DB2 (via the Walker IOSYS bridge). Wrote 2 batch conversion programs (COBOLII/DB2/JCL) using native SQL. Also provided baseline support for the Online Data Entry (ODE) application. The system consisted of a PC based version and a mainframe version, both supplied by Allen Systems Group.

Confidential - Plano, Texas

Consultant

Responsibilities:

• Responsibilities included analyzing batch COBOLII/DB2/IMS programs, as well as Focus/Data Analyzer programs. Also created and executed test plans for the Confidential Y2K conversion project.

Confidential - Tulsa, Oklahoma

Computer Systems Analyst Consultant

Responsibilities:

• Technical lead for a small team that was responsible for the analysis and remediation of IDEAL/DATACOM and COBOL/DATACOM programs as well as building test cases for the WorldCom Y2K conversion project.

Confidential - Oklahoma City, Oklahoma

Applications Consultant

Responsibilities:

• Wrote new batch reporting and processing programs for the global accounts receivable system using COBOLII and DB2. Wrote new online inquiry/update programs for the global accounts receivable system using COBOLII, DB2, and command level CICS.

Confidential - Lincoln, Nebraska

Applications Consultant and Account Manager

Responsibilities:

• Developed new batch reporting and processing programs, along with new online inquiry/update programs for the Department of Corrections’ accounting system using COBOLII, DB2, command level CICS, and QMF. Marketed the consulting company’s ( Confidential, Inc. ) services to the Confidential Central Data Processing department and to other companies in the Lincoln/Omaha area. Recruited and interviewed candidates to fill job openings for Confidential in the Lincoln/Omaha area.

Confidential - Oklahoma City, Oklahoma

Applications Consultant

Responsibilities:

• Supervised the design and development of enhancements to the tax sub-system for the Hertz Equipment Rental (HERC) application (APS/COBOLII/DB2/CICS). Provided for new-hires in the use of APS (COBOL code generator), COBOLII, and DB2 software. Consulted on the development of documentation procedures for the HERC application’s COBOLII/DB2/CICS online sub-systems. Maintained several APS/COBOLII, DB2, CICS, IDMS, and VSAM programs. Supported and maintained the tax interface for the rental agreement application process (including installing and customizing the Vertex tax rates and software). Designed, developed, and implemented an APS/COBOLII/DB2/CICS physical inventory system.