PROFESSIONAL SUMMARY

20 years experience in software engineering encompassing all SDLC phases surrounding database administration DBA , system analysis and design, software design, implementation, integration, conversion, system/unit testing, support and documentation of web apps, online and batch systems. Environments utilized include IBM CICS, COBOL, DB2, IMS, MQ, REXX, z/OS .

TECHNICAL SKILLS

• Languages/Tools: DB2 Sysplex, DB2 Native Stored Procedures, Mainview, IBM Data Studio, BMC Cat/Chg Mgr, REXX, TSO/ISPF OS/JCL, TOAD DB2 / Oracle , PL/SQL, Ansi SQL, CICS, Cobol/Cobol II, CMM Level II, Candle's Explain, FILE-AID DB2, CA-1, SPUFI, VIASOFT, XPEDITER, OMEGAMON XE PE, PROEDIT, DFSORT, MS Project, MS Office Word, Excel, PowerPoint , Librarian, SDF II, FTP, IBM Utilities, PANVALET, Control-M, Endeavor, ACF2, Visio, Lotus Notes, JSS Job Scheduling System
• Databases: DB2 z/OS v10.1 IMS v12, Oracle 9i
• Environments: z/OS, OS/390, IBM 30xx
• Certified/Training: DB2 v10 SQL Optimization / Tuning
• Oracle 9i Database Administration
• Solaris 8 System Administration - UNIX

PROFESSIONAL EXPERIENCE

Confidential

Accomplishments include:

• Provide DB2 / IMS, Data Replication, DASD, MQ application requirements / support for High Availability Very Large Resilient Systems
• Performance Tune DB2 z/OS v10 subsystems and SQL queries including but not limited to Predicate Staging, Optimizer estimation, Access Path Strategies, Join Methods using IBM EXPLAIN utility, and IBM Data Studio's Visual Explain
• Monitor Production subsystem KPI's using CA Detector, BMC Mainview analyzing/investigating variances regarding constraint relief of DB2 trace reports and SMF data
• Restructure segmented spaces into Partition By Range objects optimizing SYSPLEX parallelism using DB2 v10 attributes to reduce Heavy OLTP with HA workload CPU costs
• Install, configure and update IBM Data Replication software suites
• Transport 3 TB's across 3 SYSPLEXES with 10 LPARS at 4K TPS
• Generate DB2 v10 utility jobs using REXX routines and recursive SQL to produce repeatable processes for Very Large Databases across multiple workloads
• Create DBA Dashboard SOP monitoring and Application Management reports using
• REXX and DB2 Catalog data
• SMS storage group utilization
• Replication threshold, error and usage
• Analyze and Modify DB2 Buffer Pool configurations to optimize DBM1 address space usage
• Design and Create physical DB2 z/OS v10 objects
• Develop and Maintain cost saving solutions surrounding zEC12 CPU consumption, DASD utilization, DBMS utility overruns and contention

Confidential

Oracle DB2 DBA

Confidential Global Wealth Information Management system, functioning as an application DBA.

Accomplishments include:

• Design and Create physical DB2 z/OS v9 objects and System security
• Production subsystem monitoring Key Performance Indicators using BMC Mainview
• Deploy Native Stored Procedures
• Resolve DB2 z/OS v9 data capacity issues surrounding monitoring and resizing
• Provided DBMS/DBA Standard Operating Procedures

DB2 DBA z/OS

For the State of PA Office of Information Technology, Bureau of Enterprise Architecture, Division of Data Management and Operations, functioning as a DBA performance tuning DB2 v8 z/OS.

Accomplishments include:

• Production subsystem monitoring Key Performance Indicators using Omegamon DB2PE , analyzing Performance, Accounting and Statistic traces
• Performance Tune DB2 z/OS v8 SQL queries including but not limited to Predicate Staging, Optimizer estimation, Access Path Strategies, Join Methods using IBM DB2 EXPLAIN utility
• Design and Create physical DB2 z/OS v8 objects and System security
• Optimize DB2 z/OS objects to reflect v8 standards
• Application SQL Tuning reducing In DB2 Time
• DBMS performance recommendations surrounding EDM, SORT, RID pools and Locking
• Utility RECOVER, REORG, COPY restructuring to reflect DB2 v8 performance enhancements
• Buffer Pool Tuning strategic planning and implementation/monitoring
• Performance Tuning DB2 z/OS v8 reducing high workload CPU utilization
• Resolve DB2 z/OS v8 data capacity issues surrounding monitoring and resizing
• Provided DBMS/DBA Standard Operating Procedures

DB2 z/OS DBA

Confidential Information Technology DB2 Administration group functioning as an Application DBA performing object and data creation, modification and migration utilizing IBM Sysplex architecture with SMP shared memory processors .

Accomplishments include:

• Lead the team to successful completion of daily and weekly activities
• DB2 z/OS v8 data and object migration across SCHEMA/LPARs using Unload/Load/Cross Load/ DDL migration tools with integrity checking
• Create physical DB2 z/OS v8 objects, Stored Procedures, System security
• Maintain Data Replication Propagator Capture and Apply servers
• Plan/Create/Maintain backup and recovery of database information
• Resolve DB2 z/OS v8 data capacity issues managing parallelism and disk / tape
• Optimize DB2 z/OS objects to reflect v8 standards

Sr. Programmer Analyst

Confidential Corporate Information Technology department Open Access Electric and Gas Choice, functioning as a Sr. Programmer Analyst consultant on the Electronic Data Interchange and Information Data Repository applications support team.

Accomplishments include:

• Analyze and enhance Extraction, Transformation and Loading ETL of legacy to Oracle Data Warehouse using Stored Procedures
• Create optimized SQL for both DB2 and Oracle 9i databases
• Project plan and lead to completion daily, weekly and monthly activities
• Provided RDBMS vendor technical support information regarding issues
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party software
• Install GASTAR application and Oracle database client services
• Oracle Provider for OLE DB 9.2.0.4.8
• Oracle ODBC Driver 9.2.0.5.4
• Configuration for Oracle clients
• Conversion of Choice EDI subsystems to Customer Information Management System supported EDI subsystems.
• Produce EDI 810 Invoices, 814 Enrollments, 820 Payments, 867 Usage, 824 Advice.
• Debug CICS/COBOL/DB2/JCL applications running under JSS/ESP Job Scheduling System

Sr. Programmer Analyst

For the Judiciary department, functioning as a Sr. Programmer Analyst consultant on the Automated Criminal Management System conversion team.

Accomplishments include:

• MONITORED and OPTIMIZED the performance of the SQL plans executing using BMC tools
• Performance Tune DB2 z/OS v7 SQL queries including but not limited to Predicate Staging, Optimizer estimation, Access Path Strategies, Join Methods using IBM DB2 EXPLAIN utility
• Analyze IDMS Logical Record processing techniques with regard to DB2 v7 SQL set processing counterparts
• Create convert efficient COBOL / DB2 batch programs from COBOL / IDMS programs

Data Analyst / Sr. Programmer Analyst

For a healthcare company, functioning as a Data Analyst consultant on the Ameri-Health HMO to PPO and Pennsylvania Personal Choice HMO to PPO conversion team.

Accomplishments include:

• Create data facility for MHS Ops department MS ACCESS AND EXCEL 2002
• Created data migration facilities using BMC tools
• Automate data extraction, transformation, reconciliation and reformat ETL like and then writing it to the target repository to be exploited
• Designed and developed CICS/COBOL/DB2 OS/390 application conversion programs, unit and system test
• Trained in HIPAA Business rules

Sr. Programmer/Analyst

For a computer services company, functioning as a Senior Programmer Analyst consultant on the Fire and Inland Marine Insurance conversion project for Arkansas Farm Bureau Agency.

Accomplishments include:

• Provide expertise in CICS and DB2 OS/390 application system and program design
• Wrote reentrant, reusable, stay-resident DB2 Stored Procedures for Rate Reduction application functions
• Instruct Natural and COBOL programmers on efficient CICS pseudo-conversational and DB2 techniques
• Identified Natural's conversational constructs and documented CICS pseudo-conversational counterpart solutions
• Convert production application from Natural/DB2 to CICS/DB2/Cobol II
• Analyze, Code, Unit and Integration Test ten CICS/Cobol II/DB2 programs

DB2 z/OS DBA

Confidential analyzed FAU's Student Information System DB2 v6 for OS/390 performance.

• DB2 v6 DBMS analysis regarding performance short-comings and advice solutions.
• Identified application program design, DB2 subsystem environment, DB2 primary objects and DB2 utility flaws
• Defined specification strategy for DB2 utilities to REORG, RUNSTATS, DB Start/Stop, RECOVER, IMAGECOPY, REBUILD, LOCKING and ISOLATION LEVEL
• Designed and Implement the DB2 system Point-In-Time recovery strategy
• Recommended on-going DB2 object maintenance schedules
• Recommended DB2 object definitions and DB2 environment parameters for increased performance

DB2 DBA

DB2 DBA OS/390 and Senior Programmer/Analyst on the Application Development group's General Ledger system software support team responsible for online and batch programs utilizing

CICS, COBOL II, DB2 on MVS/ESA.

• Held DB2 Administration responsibilities for six financial production applications
• MONITORED DB2 object dataset space utilization
• Defined and created DB2 objects Tablespaces, Tables, Indexes, Views, Synonyms, etc.
• Defined and created DB2 utilities to LOAD, REORG, STATISTICS, DB Start/Stop, RECOVER, IMAGECOPY,etc.
• Designed and implemented the DB2 application data Point-In-Time RECOVERY and CONTINGENCY processes regarding Daily, Monthly and Transactional General Ledger data
• Analyzed, designed and implemented multiple programmer testing environment for DB2 databases, plan/package and production data retrieval
• Trained staff on using optimized DB2 SQL queries, updates and utilities in a production environment using Control-M
• Created process, entity-relationship ERD and support diagram documentation
• Debugged and enhanced General Ledger applications Derivation, Posting, Summary reporting, Intra-Day and external application Interfaces
• Provided customer/user interaction to ensure quality and completeness

Team Leader

Specification Writer

Sr. Programmer/Analyst Consultant

For a large financial services company, functioned as a Senior Programmer/Analyst/Specification Writer on the Electronic Data Interchange EDI systems software development team responsible for online and batch programs utilizing CICS/COBOL II, DB2 on MVS/ESA. Accomplishments included analysis, design, construction and implementation.

• 25 batch programs utilizing DB2 database and VSAM file formats collecting and converting x12 3010-4010 820, 821, 823, 835, etc.
• 14 CICS multi-purpose data entry, modification and create screens providing user maintenance views of processed x12 3010-4010 811, 820, 821, 823, 835.
• EDI Specification Writer interfacing with clients and in-house staff compiling business and system requirements.
• Lead a 4 person team writing application, program design and code specifications
• Batch reconciliation reports inspecting DB2, VSAM and QSAM tables/files.

Sr. Programmer/Analyst Consultant

For the Corporate Financial Systems department, functioned as a Senior Programmer/Analyst on the Cost Management System core software development team responsible for online and batch programs utilizing CICS/COBOL II, DB2 ClientSoft, ADW KnowledgeWare, FOCUS, TSO/ISP with IBM utilities applied on MVS/ESA. Accomplishments included analysis, design, construction and implementation.

• DB2 SQL Performance Tuning realizing 250,000/year CPU charge back savings
• Create Program Design/Specifications, Test scripts, Test Modules, Unit and System tests.
• GUI Client Front-Ends, CICS Screens, System Processes,Common System Interfaces,Reports
• Online data migration utility for customer community using VSAM data structures.
• Batch reconciliation reports inspecting DB2, VSAM and QSAM tables/files.

Sr. Programmer/Analyst Consultant

• FOCUS v6.8 file definition analysis, design and development of 200 DB2 tables.
• Project scope, analysis and design with program construction.
• Senior Programmer/Analyst responsible for developing weekly/monthly batch managerial reports written in COBOL II using DB2 tables, large VSAM and QSAM files. Accomplishments included
• Large VSAM and QSAM Master File Descriptions for batch execution.
• Weekly batch process efficiencies were high priority running under MVS/ESA.
• FOCUS v6.8 advanced user training regarding efficient program design, DB2 table and VSAM data extraction utilizing MVS/ESA facilities through JCL.