PROFESSIONAL SUMMARY

25 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 Catalog Manager, BMC Change Manager, BMC LogMaster, APPTUNE, CA RC Suites, CA Detector, CA Insight, IBM IDAA Netezza, 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, Oracle 9i

Environments: IBM z/OS, MVS

PROFESSIONAL EXPERIENCE

United States Department of Housing and Urban Development

DB2 DBA z/OS

• Functioning as a Database Management Analyst
• Accomplishments include DB2 v10 CM8 skip migration for the HUDCAPS General Ledger
• Inventoried DB2 subsystem attributes and application level objects for 3 subsystems, 15 Development, 1 Regression and 1 Production environment
• Ensured Installation, Migration, System Operation, Utility, Command, Backup and Recovery, Security, Rebind, Catalog and Plan Table conversion
• Constructed/Implemented subsystem and application Pre-Post Migration Protocols and Test Plans
• Created generic REXX/DB2 routines t generate DB2 Utility JCL for COPY / REORG / RUNSTATS / REBIND / BIND / RECOVER / REPAIR
• Recommended DB2 Pre-Post v10 NFM upgrade functionality for POC consideration

Confidential

For CMA Card Services' functioning as a Database Management Analyst

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 t 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
• Design/Build/Implement Historical CA Detector database t provide trending DB2 package and statement level statistics for Performance analysis and troubleshooting
• Restructure segmented spaces int Partition By Range objects optimizing SYSPLEX parallelism using DB2 v10 attributes t reduce Heavy OLTP with HA workload CPU costs
• Install, configure and update IBM Data Replication, Websphere CDC and Data Studi software suites
• Transport 3 TB's across 3 SYSPLEXES with 10 LPARS at 5K TPS
• Generate DB2 v10 utility jobs using REXX routines and recursive SQL t 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
• Configured IBM IDAA Netezza Proof of Concepts showing 90 reduction of SQL Query Elapsed Time
• Analyze and Modify DB2 Buffer Pool configurations t optimize DBM1 address space usage
• Design and Create physical DB2 z/OS v10 objects using CA RC/Query and RC/Migrator
• Develop and Maintain cost saving solutions surrounding zEC12 CPU consumption, DASD utilization, DBMS utility overruns and contention
• Provide 24x7 On-Call support engaging infrastructure and enterprise teams where appropriate

Confidential

For Merrill Lynch 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

Confidential

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

Confidential

For the AETNA 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 t 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 t reflect v8 standards

Confidential

Sr. Programmer Analyst

• For the 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 t Oracle Data Warehouse using Stored Procedures
• Create optimized SQL for both DB2 and Oracle 9i databases
• Project plan and lead t 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 t 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

Confidential

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 t Predicate Staging, Optimizer estimation, Access Path Strategies, Join Methods using IBM DB2 EXPLAIN utility
• Analyze IDMS Logical Record processing techniques with regard t DB2 v7 SQL set processing counterparts
• Create convert efficient COBOL / DB2 batch programs from COBOL / IDMS programs

Confidential

Data Analyst / Sr. Programmer Analyst

• For a healthcare company, functioning as a Data Analyst consultant on the Ameri-Health HM t PP and Pennsylvania Personal Choice HM t PP 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 t the target repository t be exploited
• Designed and developed CICS/COBOL/DB2 OS/390 application conversion programs, unit and system test
• Trained in HIPAA Business rules

Confidential

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 t CICS/DB2/Cobol II
• Analyze, Code, Unit and Integration Test ten CICS/Cobol II/DB2 programs

Confidential

• DB2 DBA 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 t 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

Confidential

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 t 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 t ensure quality and completeness

Confidential

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

Confidential

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.

Confidential

Sr. Programmer/Analyst Consultant

• 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
• Project scope, analysis and design with program construction.
• FOCUS v6.8 file definition analysis, design and development of 200 DB2 tables.
• 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.