**** ****** *****, ***** ********, OH 44133
25+ years progressive IT experience as developer, systems analyst/designer, technical team lead, data replication administrator, project manager and enterprise integration architect in various industries, including health insurance and health care, telecommunications, manufacturing, federally-funded and state-managed programs, and casualty insurance.
Proficiency in exploiting technology on horizontal integration implementation in classical mainframe and distributed platforms.
Experience in implementing architectural design patterns to modernize and revitalize heritage application systems by exposing application assets as service components.
As Team Lead, experience in production support and service delivery to ensure that service delivery commitments are met and production issues are promptly diagnosed and remediated.
TECHNICAL SKILLS SUMMARY
Enterprise Architecture: TOGAF 9 Enterprise Architecture (certificate from Architecting the Enterprise, Ltd, UK).
Mainframe: z/OS, JCL, TSO/ISPF, COBOL, CICS (including CICS Asynchronous API), DB2/DB2 Stored Procedures, SQL, QMF, SPUFI, IMS, VSAM, Xpediter/CICS, z/OS XML System Services, z/OS UNIX Services.
Automated Software Version Control: Changeman.
Workload Automation and Orchestration: Control-M V9.0.19 Workload Automation (BMC Software).
Service/Data Integration: IBM MQ, Control-M Event Manager.
Documentation: IBM Rational System Architect, Microsoft VISIO.
IT Applications Programmer Lead, IT Claims
Progressive Corporation (contract thru Precision Systems)
Dec 2020 – Dec 2021
Mayfield Village, OH
Built the Claim Number Expansion Project (CNE) Data Discovery Database on ACCESS which contains information (i.e., jobname, procs, programs, parms, etc.) on all mainframe jobs that ran within a 56-week period. Data was extracted from the ESP Workload Automation History Database. Identified those programs, called modules, copybooks and datasets that reference the claim number, and developed online queries which are used by project team members to access job information from the database on demand. CNE is designed to enable the Company to shift from 7-digit to 9-digit claim numbers to accommodate projected growth in business
Modified Mainframe COBOL/CICS/DB2/DB2 Stored Procedures and SAS programs as required by the CNE project. Integration with other platforms is done partly thru IBM MQ messaging. Job scheduling using ESP Workload Automation. Agile methodology using Azure Boards to track and manage the project from problem identification/analysis to coding/testing, QA then to production including post-elevate production verification.
State IT Implementation Team Lead/Lead Control-M Scheduler
IT Division, Dept. of Human Services (DHS), State of Iowa
(contract thru American Computer Systems, Inc.)
Oct 2012 – Dec 2020
Des Moines, IA
Performed systems analysis on the Department’s legacy Automated Benefit Calculation (ABC) System in preparation for the State’s initiatives on re-engineering the application for ACA compliance. ABC is a z/OS COBOL/CICS/CICS Web Services application that processes applications, eligibility determination, benefit calculation and financial transactions for the State’s federally funded and state-managed programs.
Developed the architecture for and project managed the implementation of an enterprise batch workload automation and service integration solution for the Department using Control-M V9 from BMC Software. Control-M replaced a home-grown manually managed job scheduling tool.
Collaborated with product reseller staff on the installation and configuration of the various Control-M components, including the Control-M Enterprise Manager, Control-M servers on both the mainframe and on distributed platforms, and Control-M Agents on the UNIX and Windows environments.
Trained and managed a 7-member team on how to:
- construct, test and deploy Control-M Smart folders, job definitions/job interdependencies, calendars and rule-based calendars
- set up cross-platform job interdependencies using global conditions
- use Control-M Forecast to assess potential effects of events in or changes to the environment by using what-if scenarios
- use the Control-M Batch Impact Manager to proactively determine the business impact of a failure in a batch process
- utilize the Control-M Event Manager (CMEM) to enable near real-time data integration with Federal (i.e., SSA, IRS, etc.) and private business partners as well as with other State systems running on various platforms.
Production support and service delivery:
- coordinated with business areas on schedules for conversion of processes critical to their daily operations to automated scheduling and cross-platform integration.
- impressed upon users the positive changes such as elimination of manual interventions in Operations, full automation of data interfaces between programs/processes in different platforms and with external business partners including the IRS and SSA, and ensured prompt delivery of service to beneficiaries (e.g., much earlier generation of financial transactions for Welfare/Cash Assistance, Food Assistance and Child Support recipients, etc.).
- monitored production involving automated processes to identify and promptly remediate any issues.
- reported periodically to IT and affected business area management on the schedules and status of automation sub-projects.
Senior Developer, Enterprise and B2B Applications
Parker Hannifin, Inc.
(contract thru Exodus Integrity Services)
Feb 2010 – Sep 2012
Served as Lead Developer for:
PHconnect - a B2B e-Commerce system which is used to communicate purchase orders and delivery requirements for materials to partnered suppliers in near real-time. It also enables customers to query online on the status of and delivery schedules for customer orders. The system is used by all Divisions and manufacturing locations and customers worldwide. Cross-platform integration between Z/OS COBOL/CICS/IMS/DB2 host systems and .NET applications that feed the commerce-enabled portals is implemented using WebSphere MQ messaging and DB2 Connect. Critical inventory data residing on dispersed data bases in different locations around the world is replicated, synchronized and reconciled using IBM InfoSphere Replication Server. Operational data is also summarized and downloaded to a SQL database which provides corporate management with analytics capabilities.
Global Query System (GQS) - a COBOL/CICS/DB2 application which enables the more than 450 Divisions and manufacturing locations worldwide to query on the status of purchase orders and on the stock status and availability of inventory items in real-time. GQS uses IBM WebSphere MQ shared-queue query/reply messaging and IBM WebSphere Message Broker as an enterprise service bus to access JDE and CMS MRP Systems databases in Europe and in the U.S.
Data Replication Administrator
Enterprise Integration, Global Business Solutions
Aug 2009 – Feb 2010
Under sub-contract with IBM Global Services, served as administrator for data replication using IBM InfoSphere Replication Server V9.7 Q replication in a UNIX/AIX environment. Operational data is replicated from DB2 to the Enterprise Data Warehouse. Main responsibilities included the following:
• Designed and implemented ETL rules for loading operational data to the Enterprise Data Warehouse using and IBM InfoSphere DataStage.
• Set up and maintain WebSphere MQ objects that are required for Q replication on the source and target systems, including queue managers, remote and local queues, sender channels, transmission queues and matching receiver channels.
• Configure replication queue maps which define how data is transported from the Q Capture program on the source server to the Q Apply program on the target server. Database transactions are applied to the target Oracle tables thru aliases defined in a DB2 federated server.
• Create and maintain Q replication subscriptions (for every pair of source and target tables, a subscription is needed to map columns on the source table to corresponding columns on the target table). There are some 500 Q subscriptions which are maintained in each of the four replication environments (Development, Test, Stage, Production).
• Monitor the execution and performance of the Q replication configuration both in the production as well as non-production environments to ensure that end-to-end latency and throughput are within performance targets.
Wrote UNIX Shell scripts, Oracle and DB2 SQL and ASNCLP commands which are used to manage the different replication environments (e.g., start/stop Capture or Apply programs, start/stop MQ objects, build/maintain/activate/de-activate subscriptions, create/alter/load target tables, etc.).
Cigna Health Care (contract thru Modis)
Oct 2008 – Jul 2009
Heavily involved in the Due Diligence tasks that were undertaken to evaluate the capabilities of the Portico Provider product and determine whether it meets CIGNA's current- and future-state requirements for a Provider Book of Record (PBoR) platform. Developed technical use cases that were used in the proof of technology phase, and the outcomes were used by Company management as an overriding factor for acquiring the product.
Designed the architecture and spearheaded the development for the following initiatives:
• interface between the Claim Engines (COBOL/CICS/DB2 on z/OS and OS/400) and the Provider Book of Record (PBoR) which runs on the UNIX platform. Implementation was made in several phases: (a) Deploy direct feed for Non-Contracting Provider data from Portico; (b) Execute provider selection in Portico instead of the Claim Engines; (c) Phase out Contracting Provider data download from external partners/third party vendors; and (d) As the end state, completely phase out local provider data repositories that reside in the Claim Engines.
• Redwood 3065-2 Project which enabled the PPO Claim Engine to send provider reimbursement data captured at payment determination to General Ledger Shared Services. GL runs in UNIX/AIX on the distributed platform, and integration with the Claim Engine on the mainframe was implemented using IBM WebSphere MQ V7, WebSphere Message Broker and DB2 stored procedures.
• Interface between the Claim Adjudication Systems (COBOL/CICS/DB2) on the mainframe and the Claim Book of Record (CBOR) on the UNIX platform to ensure that the correct claim disposition status is propagated to CBOR in near real-time.
• Multi-stage de-implementation of the Provider File Maintenance IMS on-line application as part of the strategic PBoR initiative, and the automated integration of non-contracted provider data with the Claim Adjudication Systems. The automated integration eliminated the need for manual entry.
IT Technical Team Lead
AT&T (contract thru Accenture)
Aug 2006 – Sep 2008
Served as Technical Team Lead for 15-member offshore team (Accenture Manila) responsible for development, maintenance and production support for the following AT&T mainframe and distributed applications:
• Common Ameritech Message Processing Systems (CAMPS) - consists of five COBOL/CICS/DB2 billing applications for the Midwest (IL, MI, OH, IN, WI) that run in parallel in five different but symmetrically configured z/OS systems in Parallel Sysplex environments. Datashare DB2 databases.
• Primary Carrier Reciprocal Compensating System (PCRCS) – UNIX-based reciprocal compensation billing system for AT&T’s Southwest operations (CA, NV, OK, TX, MO). Written in PERL, Java (J2SE), Oracle Forms and PL/SQL.
• Local Exchange Carrier Services Billing (LSB) – AT&T’s local exchange carrier services billing application which provides carriers with real-time billing information through Web portals.
• CLYDE - AT&T’s DB2 payment processing/error correction application for the Midwest is a mainframe COBOL/DB2 which processes approximately 400,000 payment transactions daily.
Developed the COBOL/DB2 interface between the Ameritech Customer Information System and the Midwest Billing applications to propagate Optional Calling Plan updates from ACIS to the billing applications in near real-time mode. Integration was implemented using WebSphere MQ V6 publish/subscribe as the backbone. Exploited use of DB2 Stored Procedures to minimize network load. Eliminated numerous customer complaints that were due to incorrect billing statements.
Reported and conducted presentations to business, IT and Quality Center management to communicate architectural choices and decisions to support business and operational requirements and standards and obtain sign-offs on proposed application architecture and business and technical design specifications.
(contract thru Exodus Integrity Services)
Feb 2006 – Jul 2006
Served as analyst/developer for the Manufacturing Systems Series (MSS) Inventory Management and Purchase Order Sub-systems. MSS is an enterprise z/OS COBOL/CICS/DB2 application. Coded system enhancements for the following projects:
• Integration of the Gas Turbine Division into MSS. Transaction data is staged on DB2 databases and exposed to .NET applications that provide e-Commerce portals to suppliers ("buy side") and customers ("sell side").
• Inventory Search Project - to enable the stock inventory sub-system to automatically search alternate warehouses when a stock item is not available at the primary warehouse.
• Perpetual Inventory Sub-system - to facilitate on-line entry of required supplier delivery schedules (need dates, quantities needed, etc.) for Kanban purchase orders. These schedules are transmitted to suppliers in near real-time thru PHconnect.
Systems Analyst/Developer, Midwest Billing Systems
AT&T (contract thru Accenture)
Jan 2005 – Jan 2006
Served as Senior Systems Analyst/Developer for the AT&T Midwest Billing Systems:
• Common Ameritech Message Processing Systems (CAMPS) - consists of five COBOL/CICS/DB2 billing applications for the Midwest (IL, MI, OH, IN, WI) that run in parallel in five different but symmetrically configured z/OS systems in Parallel Sysplex environments. Written in COBOL and datashare DB2 databases.
• CLYDE - AT&T’s COBOL/CICS/DB2 payment processing/error correction application for the Midwest which processes approximately 400,000 payment transactions daily.
Senior IT Consultant
Ohio Dept. Of Job & Family Services
(contract thru American Management Systems)
Jan 1996 – Dec 2004
As senior consultant from American Management Systems, wrote the General System Design technical specifications and led the development for the following major state initiatives:
• Modifications to the Child Support Enforcement System (COBOL/IMS DB/DC) to render the system compliant with requirements for Federal certification.
• Integration of the IV-E/Non IV-E Foster Care program into the Child Support Enforcement System.
• Implementation of the Privatization Module which allowed counties to employ child support enforcement services from third party vendors.
• Centralization of the Child Support Enforcement System Collection and Disbursements Financial Reporting.
• Modifications to the Welfare System eligibility determination and benefit calculation modules to comply with legislative mandates on benefit calculations for homes with multiple Assistance Groups.
• Re-engineering of the Welfare System (IMS DB/DC) to enable the batch and on-line applications to use common eligibility determination and benefit calculation modules.
• Development of a child SSN verification process for the Child Care Information Data Systems that links automatically with the Social Security Administration SSN verification systems.
• Provide Child Care specialists with remote on-line capability via the Internet using IBM Host-on-Demand to capture during inspection the compliance status of child care centers with Federal and state regulations.
• Enable welfare and child support recipients to access benefit issuance information residing on IMS applications via the Internet. Integration was implemented through a front-end Oracle-based web application (e-ICMS) and IBM MQ Series.
Senior Systems Analyst/Developer
Oklahoma Dept. of Health and Human Services
(contract thru American Management Systems)
Apr 1995 – Dec 1995
Oklahoma City, Oklahoma
Performed systems analysis and programming on the State of Oklahoma Child Support Enforcement System to render the system compliant with requirements for Federal certification. The application system was an IMS DB/DC system written in COBOL.
Senior IT Consultant
Oct 1994 – Mar 1995
Client: National City Corporation
Designed an IMS credit card database using IBM's Financial Systems Data Model (FSDM). Documented design specifications for the initial population and subsequent maintenance of the database.
Client: Nestle, USA, Solon, OH
Conducted system impact analysis to assess the scope of system re-engineering necessary to allow the company’s major IMS applications to cross-reference internally-developed product coding structure (IPC) with the Universal Product Code (UPC) across all lines of business. Objective was to enable the company to integrate order entry, inventory management and distribution operations, and to consolidate financial reporting. Existing architecture used IMS Intersystem Communication (ISC) for simultaneous real-time update of IMS data that reside in different physical locations in the US.
Senior Systems Analyst/Developer
Blue Cross & Blue Shield of Ohio
Sep 1982 – Sep 1994
Served as primary resource in the design, construction and implementation of a COBOL/IMS DB/DC health insurance adjudication and provider reimbursement system for hospital claims, and in the subsequent conversion to COBOL/CICS/DB2.
Designed and developed the DRG-based Institutional Provider Reimbursement Module to support the company’s fixed-priced reimbursement agreements with hospitals for inpatient cases (fixed price by diagnosis-related group regardless of patient length of stay except in cases with complications).
Heavily involved in the design and construction of a DB2 Claim History Data Warehouse as part of the initiative to “bring the data close to the user”. Actively engaged with business areas in formulating the data acquisition rules and in defining the transformation logic that was used in the ETL process.
Performed extensive data mining and BI development using QMF/High Performance Option (HPO) and SAS/STAT to provide the Provider Finance And Risk Management Division with data needed to develop DRG pricing parameters (i.e., DRG weight, average length of stay, etc.), and to support product development and reimbursement contract negotiations with hospital and physician networks.
Mentored and provided technical support to the Group Reporting Section in composing and tuning DB2 SQL queries against the data warehouse for group reporting purposes.
Project managed the Managed Care Interface (MCI) project to build a real-time interface between the claim adjudication system and the Utilization Review/Medical Review application. Eliminated the 7-10 day lag time between claim processing and medical review.
Advisor to Chief of Operations
Computer Dept., Ministry of Finance, State of Bahrain
Aug 1979 – Jul 1982
Advised the Chief of Operations and collaborated with IBM account manager, system engineers and system programmers on IBM S/370 computer hardware and system software configuration planning and procurement for the newly-built Government Data Center. Coordinated with building contractors, security specialists and system engineers on physical planning for the Data Center.
Served as systems analyst/designer on the design, development and implementation of an Electricity Customer Accounting System for the State and a Materials Inventory and Purchase Order System for the Stores Directorate, Ministry of Finance. Both application systems were IMS DB/DC written in COBOL.
Developer/Systems Analyst/Supervisor, Operations Planning and Control
Computer Department, Manila Electric Company
Sep 1972 – Jul 1979
As Systems Analyst/Developer, served as a primary resource in the conversion of the company’s Payroll System from an S/360 Assembler to S/370 COBOL and in the design, construction and implementation of an IMS DB/DC Customer Accounting System for electricity utility customer accounts throughout the Manila Metropolitan area and surrounding provinces.
As Operations Planning and Control Supervisor, managed a production support team consisting of systems analysts, developers and schedulers who were responsible for the maintenance and production scheduling for the Customer Accounting System.
University of the Philippines/Philippine School of Business Administration
B. S. Business Administration (major in Economics)
1968 – 1972
Computer Research and Programming Institute, Manila, Philippines
Computer Programming: S/370 Assembler, COBOL, FORTRAN
Baldwin Wallace University
B.S. Computer Information Science
Enrolled only in and completed Advanced Courses in Operating Systems Concepts, Systems Analysis and Design, and Application Development.
1992 - 1994