SUMMARY:

• I am seeking a senior position in Database and Software Engineering, preferably in an IBM Mainframe z/OS DB2 or Large Relational Data Warehousing and ETL environment.
• I have many years of completed large business, database and application, analysis, design, development, testing, deployment, administration, support and maintenance experience.
• This includes numerous years working as a senior technical project lead, database administrator and software development team manager.
• My experience traverses most business sectors; Telecommunications, Manufacturing, Public Utilities, Retail, Health Care, Education, and Insurances.
• Including most back office business functions; Customer Management, Billing, Financials, Auditing, Supply Chain Management, Materials Warehousing, Business Reporting & Intelligence, Medical Records, Vendor Management, and Technical Infrastructure. All with a focus on excellent Service Levels (SLAs), Customer Satisfaction, and Timely Auditable Data Centric processes.
• Please assume that all my experience below, involved all phases of database and software development within methodologies such as SDLC and Agile
• Business Requirements, Data Sources, Capacity Expectations, Interfaces, Dependencies, ROI, LOE’s, Project Plan, etc.
• Data Models, Data Flows, Process Flows, Programing Specifications, UI Layouts, Architecture, etc.
• Data Creation & Population, Program Coding, Batch Processing Scripts, Interfaces, Reporting, etc.
• Unit Testing, Debugging, QA Deployments, End to End, Parallel, UAT, etc.
• Documentation, Accurate Communications, Meetings, Formal Classes, etc.
• Documentation, Timing, Dependencies, Tech Support Teams, Technical Support, etc.
• Production SLA Support, Performance Tuning, Business Assistance, Data Research, Tickets, Auditing, etc.
• Business Modifications, Process Improvements, Data Clean - Up, Package Upgrades, etc.
• Change Management, Project Tracking, Prioritizations, Status Reporting, Disaster Recovery, etc.

SKILLS:

File Structures: DB2, IMS/DB, VSAM, GSAM, ISAM, QSAM, BDAM, DataCom, MS/Access, Oracle, SQL\Server, Informix, RDBMS, VLDB

DBA Tools: CA/Platinum (all), BMC (Catalog, Change, & Confidential Mgr), TMON, Compuware (DB/Expert, DB2 FileAid), DB2I, Omegamon

File/Data Tools: SPUFI, QMF, FILEAID, PRF, PS Record Editor, Business Objects, MS/SQL, TOAD, DATA EXPERT, IDCAMS, DATA VANTAGE, DLT0, OS2 Query, SQLtalk, SQL Plus, Crystal Reports, ER Studio, ERWin, DBvisualizer, Informatica Power Center

Data Languages: SQL, DDL, DLI, CICS Command Level

Utilities: IBM (IEB, IEF, IEH, IKJ), SYNCSORT, IDCAMS, All DB2 Database Utilities, FTP

Languages: COBOL II, COBOL, FORTRAN, BASIC, PL/1, ASSEMBLER, MARK IV & V, People Code

Communications: CICS, IMS/DC, DCM/2, Communications Manager, LU6.2, APPC, VTAM, HTTP

Terminal Control & UI: BMS, MFS, SCREEN PLUS, SDF2, PS Panel Editor, HTML

Testing Tools & Monitors: XPEDITOR, DBUGAID, INTERTEST, CEDF, TMON, JCLCHECK, ANIMATOR, OMEGAMON, INSIGHT, Smart Test, JHS

Development Systems: TSO/ISPF/PDF, ROSCOE, TSS/QED, Micro Focus Workbench, PS Tools, Informatica Power Center

Operating Systems: S390, Windows, MVS/ESA, MVS/XA, OS/MVS, Z/OS, GCOS, MS/DOS, OS2, Apple DOS, UNIX

Methodologies: SDLC, Agile, Scrum, Waterfall, Rally, Jira

Miscellaneous: TSO/CLIST/DIALOG, ISPF, Panvalet, REXX, ROSCOE/RPF, MS/Office, Skype, Teams, Visio, IMS/DOS/BAT, IBM/MVS/JCL, CA7/11, MS/Works, Lotus 123, Flowchart 3, QUIKSTART

General: Database & Software, Team, Project Management, Design, Development, Testing, Training, Deployment, Support, Maintenance, Performance Tuning, Disaster Recovery, Auditing, Data Warehousing, ETL, ERP

WORK EXPERIENCE:

Principle Software Engineer, Lead Software Engineer

Confidential, Southfield, MI

Responsibilities:

• Subject matter expert (SME) on all stages of development, as well as operational support, maintenance, and enhancement of a large Oracle based Operational Data Store (ODS).
• This consisted of the migration of hundreds of database tables from various data environments (DB2, Sybase, Informix, Oracle, Flat Files) into the Oracle Operational Data Store (ODS), as well as almost a hundred application database tables for one-time migration to Oracle, this was done using mostly Informatica Power Center ETL tool.
• I was responsible for all Oracle Table creation/SQL/DDL Test/QA/Production Schema management, performance tuning, and continued Informatica ETL 24/7 operational support, maintenance, and enhancement of the Oracle ODS.
• Subject matter expert (SME) on all IT operational support, maintenance, and enhancement of a large telecommunications Conferencing Billing system.
• The system environment was Z/OS, DB2, and Batch COBOL.
• Also lead engineer migrating the above mentioned Billing system from the Mainframe/COBOL/DB2 environment to UNIX/JAVA/Oracle.
• I also designed and developed this entire application, prior to the merger of Level 3 Communications and Confidential Communications.
• Ongoing assistance to mainframe technical support and application development teams with DB2 database administration issues.

Principle Software Engineer

Confidential, Southfield, MI

Responsibilities:

• Subject matter expert (SME) on all IT operational support, maintenance, and enhancement of a large telecommunications Conferencing Billing system.
• The system environment was Z/OS, DB2, and Batch COBOL.
• Developed billing ETL processes and all target database/tables, for migration of data from proprietary (INTEC) indexed sequential data storage system into DB2 Relational Database.
• Ongoing assistance to mainframe technical support and application development teams with DB2 database administration issues.

Senior Database and Application Consultant

Confidential, Dearborn, MI

Responsibilities:

• Designed a secondary medical claims appeal system for 3 health insurance companies, in support of the Affordable Care Act.
• I worked with company Owners and Attorneys interpreting the new ACA claim appeal laws as they applied to information gathering and claims processing.
• Developed the Relational Data Model, Data Flow Diagram, and UI/Screen designs for this application.
• This was an off-hour’s contract being done as a favor for an old professional friend.

Senior Applications Development Manager, Principle Software Engineer

Confidential, Southfield, MI

Responsibilities:

• Manager of SAP-SD (Billing) and SAP-AR ABAP development and configuration team, responsible for the overall customization, maintenance and support of SAP Billing application used for international telecommunications customers.
• Technical Manager of Network Call Traffic Management Information Reporting system, responsible for all support, maintenance, and development.
• This system was an extremely high volume (300+ million transactions per day) daily, weekly, and monthly enterprise wide reporting and management information system system, producing approximately 250 reports on a regular basis utilizing very large DB2 database tables and flat files in an IBM Z/OS environment.

Senior Database and Application Consultant

Confidential, Hamtramck, MI

Responsibilities:

• I worked with company executives on a Telecommunications Billing Software RFP process as a technical and functional software and database reviewer.
• This involved gathering billing system requirements from Confidential department heads and employees, and communicating/verifying with the software vendors.
• I was also responsible for reviewing the data model and software structures and supplying details to the client.
• Assisted the client in gathering resumes and interviewing software engineers to work on the new billing platform.
• This was an off hour’s contract done as a favor for an old manager.

Application Database Administrator, Senior Software Engineer, Technical Instructor

Confidential, Southfield, MI

Responsibilities:

• This data warehouse also consisted of numerous Very Large Databases (VLDBs), that required ongoing maintenance and performance tuning.
• Implementation of DB2 as the new corporate Relational Database Management System.
• This included the development of all DB2 standards and procedures, object naming conventions, plan and package standards, explain procedures, restart and recovery strategies, locking and performance strategies, program compile and bind procedures, referential integrity guidelines, access and security schemes, production object turnover procedures, utility control and execution procedures, and SQL coding standards.
• Created all documentation, JCL shells and control card examples, and conducted thorough testing and review for all of the above-mentioned DB2 object standards and procedures.
• Assisted in the configuration, installation, and testing of SPUFI and QMF, DB2 vendor software reviews and recommendations, and DB2 capacity planning and impact analysis.
• Ongoing assistance to mainframe technical support and application development teams with DB2 database administration issues.

Senior Applications and Database Consultant

Confidential, Troy, MI

Responsibilities:

• Application DB2 Database Administrator primary responsibilities include physical database design/modeling, development, ETL data conversion, testing, implementation, and maintenance of Data Warehouse objects.
• Also assisted Data Warehouse clients in SQL creation and performance tuning.

Database Administrator (DBA)

Confidential, Dearborn, MI

Responsibilities:

• I prepared and installed Platinum Technologies Database Analyzer product.
• This product is used to create and control the execution of all production z/OS DB2 database maintenance utilities.

Database Administrator (DBA)

Confidential, Troy, MI

Responsibilities:

• Administration and support of physical database objects for General Motor’s z/OS DB2 human resources.

Database Engineer

Confidential, Auburn Hills, MI

Responsibilities:

• Implementation of DB2 Customer (CIF), Account (AIF), and Address (ADF) databases into Hogan banking system.
• Installation and establishing standards and procedures of BMC Change Manager for DB2.
• Performance and tuning of various DB2 application systems.
• Confidential expansion and reorganization, as well as normal everyday support of numerous DB2 objects.

Database Administrator (DBA)

Confidential, Dearborn, MI

Responsibilities:

• DB2 Confidential expansion and reorganization, security authorization clean-up, installation/migration of DB2 version 2.3 to version 3.1, evaluation and testing of (Platinum, BMC, and Compuware) DB2 administration products, monitoring and enhancement of various DB2 components for the purpose of improving overall system performance.

Database Administrator (DBA)

Confidential, Grand Rapids, MI

Responsibilities:

• Clean up of DB2 security authorization tables, DB2 Confidential reorganization (Using Platinum DSF), and creation of new regularly scheduled Image Copy, Reorg, and Run Statistics utilities.

Senior Applications and Database Consultant

Confidential, Troy, MI

Responsibilities:

• Assisting with DB2 relational database application development.

Confidential

Senior Applications and Database Consultant

Responsibilities:

• I developed a QMF/DB2 Insurance Premium Data Warehouse extract and summarization process.

Senior Systems Engineer

Confidential, Southfield, MI

Responsibilities:

• Installation of People Soft ERP financial application.
• This application utilized DB2 as the Relational Database Management System (RDBMS) file server, and consisted of almost 700 DB2 database tables.
• Assisted as an advising consultant on the relational data modeling of a new DB2, object oriented Commercial Insurance Policy Management system.
• This system consisted of over 300 DB2 database tables.
• I also functioned as an application DB2 Database Administrator for the above-mentioned application, responsible for DB2 table Maintenance (DDL), back up, recovery, plans, packages, SQL coding standards, and performance tuning.

Applications Database Administrator

Confidential, Southfield, MI

Responsibilities:

• Implementation of DB2 as the new corporate Relational Database Management System.
• This included the development of all DB2 database standards and procedures, object naming conventions, plan and package standards, explain procedures, restart and recovery strategies, locking and performance strategies, program compile and bind procedures, referential integrity guidelines, access and security schemes, production object turnover procedures, utility control and execution procedures, and SQL coding standards.
• Created all documentation, JCL shells and control card examples, and conducted thorough testing and review for all of the above-mentioned DB2 object standards and procedures.
• Assisted in the configuration, installation, and testing of SPUFI and QMF, DB2 vendor software reviews and recommendations, and DB2 capacity planning and impact analysis.
• Provided general assistance and communications to Systems Support and Information Systems staff in all areas pertaining to the use of DB2.