Xavier Bracco

adli01@r.postjobfree.com

PROFILE

Accomplished IBM Information Systems Technology Engineer. Sr. DBA & Data Architect / Application Systems Engineer with strong background on System Development Life Cycle and MPP/Relational/Hierarchical Database Architectures. Emphasis on the design/development and maintenance of performance-oriented applications as well as system conversions/migrations and integrations. Experience in the following sectors: Private Banking, Military / DOD, HR & Payroll, Health & Social Services, Workflow, Logistics, Criminal Justice, Retail Marketing & Order Entry, Gas & Oil, Utilities, Medical Insurance Processing, Data Warehousing / Decision Support, Accounting & Inventory, Wall Street, Auto Manufacturing

CORE COMPETENCIES

Accomplished DBMS background in Massively Parallel Processing (MPP) along with the performance tuning distribution process.

Proficient in DBMS products such as DB2, IMS/DB, Datacom/DB, IDMS, VSAM, and Oracle

Comprehensive use of Greenplum’s Data Center Monitoring for all query processing

Message Queueing practice to split and manage the processing slices associated with the Greenplum database

Understanding of Hortonworks along with Hadoop and Ambari

Solid understanding of Data Wrangling

Strong IBM Technology background

Understanding of Cloudera Data Management tool

Solid analytical mindset for business requirement gathering relational database architecture, implementation, and data migration

Strong background in Data Analysis & Modeling, Mapping, Functional & Technical Specifications

Extensive experience in OLTP utilizing COBOL, DB2, and CICS/ESA for large scale application systems under z/OS

Greenplum Compression Analysis for Storage and Performance

IBM & Pivotal Training with Udemy

Dell / EMC

Greenplum MPP & PostgreSQL Version Updates

IBM

DB2/UDB Version Updates

IBM

DB2/UDB Version Updates at Performance & Tuning Level

IBM

DB2/UDB Version Updates at Application Development Level

IBM

CICS/ESA Version Updates at the Application Development Level

IBM

z/OS Version Update for Software Products

IBM

AIX/Linux Version Updates

Pivotal

Microsoft

Udemy

Red Hat

AWS / S3 / Operational with Greenplum / PostgreSQL (Udemy)

Azure / Cloud (Udemy)

The Agile Approach & Waterfall

Linux

TECHNICAL SKILLS

Hardware

IBM 370/43XX/3090/9000/S390/Z9, HP 3000, AMDAHL/5850, SUN/SOLARIS

DELL POWER EDGE 6100/200, IBM AIX/p550, ISILON

Languages & Development Tools

COBOL II/370/390/E, BASIC, DB2/Stored Procedures, BMS, FORTRAN, JCL, PL/I, ASSEMBLER, BORLAND C++, CLIST, SQL*PLUS, JavaScript, ISQL, REXX-SQL, IDEAL, ADSO, PL/SQL, PERL5, SQR, MadLib

Operating Systems, Utilities & Virtualization

Z/OS, OS/MVS, OS/390, HP-DOS, MS-DOS, OS/2, Windows95/NT/XP/7, VM/CMS/VSE, LINUX, Dell Building Blocks, S3

Database Management Systems

DB2/UDB, IMS/VS, DATACOM/DB, IDMS/R, DMS, FOCUS, ORACLE9, FoxPro, VSAM, VM/AS, SYBASE, PSOFT/SQLBASE, Informix, MS-ACCESS, MySQL,

MS-SQL/2005, Oracle/XE, Greenplum, Redshift,

T-SQL, PostgreSQL

Commercial Software

DB2/Visual Explain, Active Directory, BMC, Eclipse DB/Browser, LE, COGNOS, Easytrieve, XPEDITER, INTERTEST, CA-7, TSO/E, IBM/QMF, GDDM-ICU, ISPF/PDF, SDF-II, DITTO, PLATINUM, STROBE, ISI, QUICK-START, ENDEVOR, Z/OS Connect, DB2/PM, OMEGAMON, TOAD, PANVALET, MICROFOCUS-ANIMATOR-REVOLVE, SMP/E, IBM CDC, EDI/MQ, FILE-AID, ABEND-AID, PVCS, SUN/XVISION, PEOPLETOOLS, DADS, CA-Metadata/AllFusion, MICRO FOCUS, Crystal Reports, DB2/Estimator, DB2/Connect/NDM, INSYNC, Quest, AQT, Exeros/Discovery, Siperian/MDM, SAP, pgAdmin III, Aginity, Putty, WinScp, WinSQL, Cloudera Data Management, MagicDraw, VISIO, QuerySurge

GUI Interface Products

Visual Basic, Visual Age

ETL Tools Supported

Pentaho, DataStage

Modeling Tools

LEGACYAID, COMPUWARE/DevEnterprise,

ErWin, Rational/RUP/DA, DB2 Data Studio, ER/Studio

Data Visualization Tools Supported

Plateau, YellowFin, SAS

Professional Experience

RGBSI – FORD Motors – Troy Michigan 11/19 – 03/20

Enterprise Data / Solutions Architect – Troy, Michigan

System Environment:

Windows10, MagicDraw, Visio, SQL, Oracle, PowerPoint, QuerySurge

Responsibilities:

Acting as a Solutions & Database Architect to study the process of a building model using a CASE tool known as MagicDraw. Including in this process provided an evaluation of the client’s current IT processing state along with a very thorough presentation of their to-be state considering the client uses an extensive number of 3rd party vendor software products. All associated analysis was completed and presented to the consulting firm.

Insight Global - WellCare – Tampa Florida 09/17 – 10/19

DBA Data Systems Administrator Consultant, Enterprise Data Architect – Tampa, Florida

System Environment:

EMC/DCA, Windows10, Linux, Pivotal/Greenplum BB, GP Command Center, WinScp, Aginity, EditPlus3, PostgreSQL, Amazon / Redshift, PL/SQL, VMWare, QuerySurge, Embarcadero Data Modeling Tools (ER/Studio), Tableau, SAS

Responsibilities:

Acting as a DBA Solutions Architect to analyze and implement Warehousing databases using Greenplum Building Blocks for Big Data delivered in context of a specific solution and as such it may encompass description of an entire system or only its specific parts. Extensive performance & tuning effort as well as training for all developers involved. Provided client with extensive amount of training in the arts of using the MPP Architecture. Other responsibilities included extensive amount of troubleshooting and debugging queries to attain acceptable performance as well as Data Analysis and Migrations from mutually exclusive databases.

EMC Corporation / Pivotal – Tampa Florida Office 03/11 – 07/17

DBA Technical Consultant, Enterprise Data / Solutions Architect – Tampa, Florida

System Environment:

IBM Z9/p550, IBM CDC, EMC/DCA, Windows7, AIX, z/OS, Linux, EMC/Greenplum, DB2/zOS/UDB, Visio/2010, ISPF/PDF, TSO/E, JCL, Oracle/XE, PL/SQL, Erwin, RUP/DA, Quest, DB2 Control Center, VMWare / CENTOS8, GP Command Center, MySQL, SSIS, AQT, WinScp, pgAdmin III, Aginity, EditPlus3, PostgreSQL, Pentaho, DataStage, WinSQL, GP/Hadoop, ISILON

Responsibilities:

Acting as a DBA Solutions Architect to analyze and implement Warehousing databases using Greenplum for Big Data delivered in context of a specific solution and as such it may encompass description of an entire system or only its specific parts. Responsible for the multiplicity of Data Analysis and Migrations from a number of databases to PostgreSQL; the most valuable ones were related to DB2 schemas, VSAM datasets, and IMS segments inclusively, as well as Oracle. Greenplum helps organizations of all sizes accomplish warehousing practices with the appropriate speed and processing required producing analytic results that help organizations make viable decisions with data that may be migrated from a variety of databases like Business Finance, Telephony, Banking, Health Informatics, Scientific, and Military (USAF), to name a few.

ATSI Group – Daimler – Daimler Trucking North America 01/08 – 03/11

Enterprise Data / Solutions Architect – Portland, Oregon

System Environment:

IBM Z9/p550, Windows/XP, SAP, AIX, z/OS Connect, File-Aid, BMC Control-M, IMS/TM, DB2/UDB, Visio/2008, MS-SQL/2005, Erwin, RUP/DA, T-SQL, APPC/API, MySQL, Informix, Quest, NDM, DB2, AQT, Exeros/Discovery, DB2 Data Studio, Siperian/MDM, Active Directory, SDLC/DA

Responsibilities:

As Daimler continues to grow presently dealing with all the new trucking companies that have been acquired throughout the USA and the rest of the world, have been given the task as acting Database Architect to review the current IMS / DB2 models for the IMACS (Information Manufacturing and Accounting) system in order to ascertain that all customers, addresses, materials and parts, major components, and vendors data coming from all the other systems may be integrated to consolidate and eliminate redundant applications in the manufacturing and control arena as well as cost accounting (CBFC – Combined Basic Financial Controls System). Utilizing the Siperian/MDM tool the design, data de-duplication, and implementation of the new database is accomplished into the final DB2/UDB for AIX as well as for z/OS. Extensive amount of Data Analysis and Migration from mutually exclusive databases.

ATSI Group – Daimler – Daimler Trucking North America 01/06 – 12/07

Enterprise Data / Solutions Architect – Portland, Oregon

System Environment:

IBM Z9/p550, Omegamon, AIX, Windows/XP, z/OS Connect, LE, INSYNC, CICS/ESA, E/COBOL, BMC Control-M, IMS/TM, JavaScript, DB2/UDB/MDC, NDM, Quest, DB2/Visual Explain, MS-SQL/2005, Easytrieve, CA-Metadata/AllFusion, T-SQL, MySQL, APPC/API, Informix, Crystal Reports, Erwin, Visio/2000, Mh-Tran, RUP/DA, AQT, DB2/Estimator, DB2 Data Studio, Active Directory, Quest, Eclipse, Siperian/MDM, SDLC/DA

Responsibilities:

Acted as an Architect/DBA/Developer for the evaluation, enhancement and replication of the Cleveland plant of truck manufacturing in order to emulate a new plant being built in Monterey Mexico (Saltillo). This analysis starts from the time the IMACS (Information Manufacturing and Accounting) system generates the BOM (Bill of Materials) from an IMS/DB2 for z/OS database to the processing of all the JCL data streams to explode the construction of that truck and transfer of data from the z/OS environment into the robot software that manipulates the arms for assembly. The data processing of such architecture represents a large-scale distribution of data to MS-SQL servers as well as DB2/UDB for AIX. New physical data models were presented via the use of RUP/DA for implementation as well as collection of data that is intrinsic to each plant mode of operation for the daily analysis of parts and components for assembly. Other responsibilities involved the day-to-day structural DBA practice from Logical to Physical model implementations to evaluation and troubleshooting of Stored Procedures and E/COBOL executing both in z/OS and AIX with DB2/UDB. Extensive amount of Data Analysis and Migration from mutually exclusive databases.

ATSI Group - Daimler – Daimler Trucking North America 02/05 – 12/06

Enterprise Data / Solutions Architect – Portland, Oregon

System Environment:

IBM Z9/p550, Omegamon, Windows/XP, z/OS Connect, LE, INSYNC, CICS/ESA, E/COBOL, BMC Control-M, IMS/TM, DB2/UDB/MDC, DB2/Visual Explain, T-SQL, APPC/API, MySQL, Informix, Easytrieve, CA-Metadata/AllFusion, AQT, Crystal Reports, Erwin, DB2 Data Studio, Active Directory, JavaScript, MS-SQL/2005, Visio/2000, Mh-Tran, RUP/DA, DB2/Estimator, NDM, Quest, DB2/Connect, Eclipse, SDLC/DA

Responsibilities:

Acted as an Architect/DBA for the evaluation and design of a Process/Dataflow for an IMS/DB2 Warranty Sub-system (IMAC) conversion. The current application to be converted to a new platform using Websphere Java/J2EE executing as a front-end on Windows/XP but utilizing DB2/UDB to control claims for the manufactured trucks at the dealer’s sites. The DB2 models were assessed from the IMS structure and mapped into the new 4CS/iWarranty application front-end. For warehousing, DB2 tables were created for use by COGNOS/CUBE implementing multi-dimensional (MDC) tables to take advantage of its performance. Other responsibilities included modeling of a Customer & Address centralized database, Concessions Model, and Engineering Data Exchange Model (EDEX); and the review of over 2000 COBOL/I and COBOL/II programs to be converted into E/COBOL using LE for IMS/DB2 and CICS/ESA with Mh-Tran. Extensive amount of Data Analysis and Migration from mutually exclusive databases.

Arcus Consulting - Independence Blue Cross 07/04 - 12/04

Enterprise Data Architect - Center City, Philadelphia

System Environment:

IBM ES/9000, Z/OS, OS/390, CICS/ESA, COBOL/390, DB2/UDB, XPEDITER, ISPF/PC, JCL, TSO/E, ENDEVOR, TCP/IP (FTP), INSYNC, Windows/NT, SDLC/DA, Scheduler, DB2 Utilities

Responsibilities:

Part of an engineering team to build a major Data Warehouse (COB - Claims On-Board) Database using several ETL modules designed and written in COBOL/390 for DB2/UDB. The process entailed the extraction of data from an AS/400 Claims Processing System (MHS, PPO) into a conglomeration of data for further manipulation (ETLs) into the appropriate formats for DB2 to load via SQL/DB2 Utilities and COBOL/390 ETLs considering the Business Intelligence functional/technical requirements. Prepared classes for the developers to get familiar with coding COBOL/390 under LE/390 for batch and CICS/ESA. Several technical documents were produced to present management with issues of Performance and data manipulation at the COBOL and DB2 Utility levels as well as Technological Staging Laws to use as reference when dealing with Data Warehouses and CICS/ESA online applications connecting to outside products like the AS/400.

ISI Consulting, LLC – JP Morgan Chase 11/02 – 07/04

Analyst / Programmer - Tampa, FL

System Environment:

IBM ES/9000, OS/390, CICS/ESA, BMS, COBOL/390, DB2/SP, DB2/UDB, XPEDITER, INTERTEST, ISPF/PC, JCL, VISIO, TSO/E, ENDEVOR, QMF, EDI/MQ, TCP/IP (FTP), CA-PANVALET, Windows/NT, FILE-AID, SDLC/DA, TOAD, QA, VSAM, MF-REVOLVE, COBOL/Miner, CONTROL-M, IMS, ORACLE9, ACCESS, ErWin, NDM, Solutions Architect

Responsibilities:

Lead engineer to convert a major system for the processing of Pricing and Billing to centralize the data to a DB2 database (CICS & COBOL/390). Acted as a Data Analyst, Architect, and Programmer to bring the data from all its different storage platforms (VSAM, IMS, Oracle9, and Tandem/SQL) to the new Global Pricing & Billing System (GPBS) using COBOL/390 modules. Wrote the process schematics for the Panvalet to Endevor migration as well as the data-mapping documentation from 5 different subsystems.

Cue Data Services, Inc. / MIS Technologies, Inc. - JP Morgan Chase 01/01 - 12/01

Analyst / Programmer – Manhattan, NY - Christiana, DE

System Environment:

IBM ES/9000, OS/390, CICS/ESA, SAS, BMS, SDLC/DA, COBOLII, DB2/UDB, DB2/SP, XPEDITER, INTERTEST, ISPF/PC, JCL, QA, VISIO, TSO/E, ENDEVOR, QMF, EDI/MQ, TCP/IP (FTP), CA-PANVALET, Windows/NT, FILE-AID, EDI/MQ, VSAM, WORKFLOW, MF-REVOLVE, ErWin, CONTROL-M, DADS, Solutions Architect

Responsibilities:

Lead engineer to design, develop, and implement a CICS/DB2/UDB subsystem for the Private Banking Online System (PBIS) to allow the client to modify and transmit standing wires using MQ. A CICS background transaction was also constructed to monitor and execute MQ transmittals. Converted 115 DB2 tables and data for the database Account Number expansion process because of the merger effort between Chase and JP Morgan. Automated the entire manual printing of Branch Checks in PBIS via TCP/IP (FTP) using CICS online.

Cue Data Services, Inc. / MIS Technologies, Inc. - JP Morgan 04/99 - 12/00

Enterprise Data Architect – Manhattan, NY - Christiana, DE

System Environment:

IBM ES/9000, OS/390, LE, SAS, CICS/ESA, BMS, WORKFLOW, COBOLII/390, ASSEMBLER, DB2 Stored Procedures, VISIO, DB2/UDB, VSAM, DB2/PM, SDLC, XPEDITER, INTERTEST, ISPF/PC, JCL, SDLC/DA, TSO/E, CA-PANVALET, EDI/MQ, ENDEVOR, ErWin, VisualAge/COBOL, MF-REVOLVE, QMF, REXX, FTP, Windows/NT, TCP/IP, APPC/API, DevEnterprise, CONTROL-M, Visio, DADS

Responsibilities:

Lead engineer to perform the evaluation and conversion of APS/COBOLII to COBOL/390 as well as DB2/UDB tuning for the Securities Trading Accounting & Reporting System (STARS) under CICS and batch. Assumed interactive role with Financial Analysts to implement requirements for their daily back office operation (NYSE). Involved in the conversion of the Consolidated Government Reporting System (CGRS - SEC Filings) from APS/COBOLII CICS/VSAM to CICS/COBOL390 DB2/UDB, Stored Procedures, and batch. Provided proof of concept to management for IBM’s Transaction Server Architecture using GUI interfaces as the client and the IBM Mainframe as the server.

Cue Data Services, Inc. - Arthur Andersen Technology Solutions 08/98 - 04/99

Enterprise Data Architect - Sarasota, FL

System Environment

IBM ES/9000, 0S/390, CICS/ESA, SAS, COBOL/390, DB2/UDB, DB2/SP, PEOPLETOOLS/SQR, MF/ANIMATOR, SDLC/DA, Windows/NT, WORKFLOW, VISIO, XPEDITER, ErWin, SQLBASE, ISPF/PC, JCL, TSO/E, CA-PANVALET, LEGACYAID

Responsibilities:

Acted as technical design/development lead for the conversion requirements, interfaces, and re-engineering of Arthur Andersen’s Human Resources & Payroll system from CICS/ESA, DB2, COBOLII and VSAM, to PeopleSoft, DB2, COBOL/390 and SQR.

Cue Data Services, Inc. - Intersolv Corporation 09/96 - 08/98

Enterprise Data / Solutions Architect - Rockville, MD

System Environment:

IBM/9000, MVS/ESA, CICS/ESA, SAS, COBOLII, DB2, DB2/2, MF/REVOLVE, OS/2, PERL5, Windows/NT, INTERSOLV/PVCS, MICRO FOCUS, SDLC, VISIO, MS-SQL, BORLAND/C++, IMAGIX/4D, SUN/SOLARIS/UNIX, /XVISION, ErWin, RATIONAL ROSE, VisualAge/C++, VISUAL BASIC, MF/WB TANDEM, ISPF/PC, IMS DB/DC, LEGACYAID

Responsibilities:

Responsible for developing and documenting a factory methodology standard that became the Y2K conversion guide for different languages and hardware platforms. Provided technical support to re-engineer online, GUI, and batch applications to comply with the advent of the year 2000 (ISO) as well as converting some of these applications to new platforms. Designed and developed PERL programs to facilitate the year 2000 conversion process. Provided technical guidelines for an OS/VS COBOL to COBOL for MVS/VM conversion. Also served as part of a complexity team as a liaison to the Vice President of Systems for the evaluation and selection of application development/debugging tools as well as troubleshooting of in-house software enabling products.

AIC / IBM - Dept. Health & Social Services 06/96 - 09/96

DBA Enterprise Data / Solutions Architect - Madison, WI

System Environment:

IBM/3090, MVS/ESA, Windows/NT, CICS/ESA, COBOLII, DB2, PLATINUM, QMF, SPUFI, XPEDITER, OS/2, DB2PM, STROBE

Responsibilities:

Involved in the performance and tuning process for the KIDS DB2 database to identify I/O contention and concurrency issues. As part of the complete tuning process, evaluated DB2 CICS/ESA online as well as batch COBOL II programs (SQL/DML) along with the current physical database model. As a result of this effort, a technical recommendation report was prepared for management. Worked on the analysis for the construction of a Data Warehouse and archival process for the KIDS database.

Eagle Systems - J.B. Hunt Transport 01/96 - 04/96

Analyst / Programmer - Lowell, AR

System Environment:

IBM/9000, MVS/ESA, CICS/ESA/PLEX, COBOLII, DB2, VSAM, AM/WORKBENCH, REXX, PLATINUM, OMEGAMON, LMF, SDLC, INTERTEST, XPEDITER, CICS/APPC/API, TPX, OS/2, SMALLTALK, VISUALAGE, OS/2-COMMUNICATIONS MANAGER

Responsibilities:

Assisted in the re-engineering of AM/WORKBENCH programs to access data from the DB2 Logistic Transportation database using CICS/APPC. Designed and constructed a workflow-processing prototype to handle Truck Loads/Less Than Truck Loads shipments (Logistics) from different customer needs. Wrote and re-engineered online modules to comply with the new applications being introduced into the existing systems. Prepared technical review documentation to I.S. management regarding relational models, online (shells) and batch coding standards, Client/Server interfaces, and AD/Cycle methodology. Received first time exposure to Visual Age and Smalltalk during client’s evaluation of product to replace AM/WORKBENCH.

DASI - LL Bean 01/95 - 12/95

Analyst / Programmer - Freeport, ME

System Environment:

IBM/3090, MVS/ESA, CICS/ESA/PLEX, COBOLII/MVS, LE/MVS, DB2, VSAM, IDEAL/DATACOM, Windows/NT, PLATINUM, WORKFLOW, ADW/AWS/DWS, SDLC, OS/2, DB2/2, OOA/OOD, MICRO FOCUS, DITTO, REXX, JCL, XPEDITER, DB2/MONITOR, SYBASE, Q/A, JAD/DSS, CA-7, ABEND-AID

Responsibilities:

Assisted in the re-engineering of the Order Entry System for the International IS division. Also participated in the analysis, design, and construction of a new application for an Enterprise Shipping Platform as well as Business-To-Business process for Japan Orders using SYBASE and DB2. Converted programs from COBOLII to COBOL/370 for most of the online and batch applications. Involved in the standardization of the online applications development process considering the new LE/370 environment and Client/Server position for CICS/ESA. Provided technical support to the LE/370 conversion process as well as troubleshoot most of the applications being converted. Provided training to the IS programming staff in the area of CICS/ESA/PLEX online engineering for DPL (Distributed Processing Links) and its use for Client/Server architecture. Acted as a technical adviser to the Vice President of Information Services concerning technical factors related to Client/Server advancements and front-end re-engineering with the advent of the new IBM OS/390 technology.

DASI - LL Bean 08/93 - 11/94

Analyst / Programmer - Freeport, ME

System Environment:

IBM/9000, MVS/ESA, CICS/ESA, COBOLII/MVS, DB2, VSAM, IDEAL/DATACOM, PLATINUM, ADW/AWS/DWS, OS/2, Windows/NT, DB2/2, OOA/OOD, MICRO FOCUS, PATH/VU, SEEC, HYPER-STATION, STROBE, WORKFLOW, XPEDITER, JCL, REXX, SDLC, DITTO, DB2/MONITOR, POWERBUILDER, Q/A, JAD/DSS, CA-7, ABEND-AID

Responsibilities:

Part of a 14-engineering team to model/design and re-engineer the LL Bean Order Entry System (batch/online) into an Interactive Order Information Base System (IOIB). This new application served as a Data Warehouse as well as a batch order fulfillment process interacting with high performance online CICS/DB2 transactions (sub second response time). Also involved in a programming prototype to establish knowledge of the PowerBuilder/Dialog System tools to provide positive assessments regarding the GUI interface directive.

CBA / IBM - Volusia County Criminal Justice 02/93 - 07/93

Analyst / Programmer - Deland, FL

System Environment:

IBM/9000, VM/CMS/VSE, COBOLII, CICS/VS, SQL/DS, DB2, SDLC, VSAM, QMF, Q/A, JAD/DSS

Responsibilities:

Part of a 4-analyst team to re-engineer the Volusia County Criminal Justice Information System (CJIS) to evaluate and re-engineering of the online and batch programs written in COBOL/CICS/VSAM to be converted to COBOLII/CICS/DB2. Provided online and batch structured programming guidelines as well as technical support in the areas of SQL/DS, COBOLII, QMF, and CICS to the County’s programming staff.

DASI - LL Bean 09/91 - 02/93

Analyst / Programmer - Freeport, ME

System Environment:

IBM/3090, IBM PS/2, MAC, ISPF/PDF, MVS/XA, DB2, QMF, OS/2, ROSCOE, IDEAL, DATACOM, VSAM, TSO/E, Windows/NT, PLATINUM, SDLC, XPEDITER, COBOLII, DISPATCH, PATHVU/2, SEEC, BMS, CICS/VS, ADW, JCL, SAS, SQL, FOXPRO, PIM/IE, Q/A, JAD/DSS, CA-7

Responsibilities:

Part of a 12-analyst team to design and implement a Corporate Marketing System (CMS). This system links with the Customer Order System for the US and International customers. Involved in the review and redesign of the CMS logical model using ADW CASE. This system resided under DB2 using COBOLII, BMS, and CICS/VS. Worked on batch conversion of various COBOL/VSAM batch programs to COBOLII/DB2. Also involved in the revision of existing IDEAL/DATACOM subsystems to be converted to CICS/VS using DB2. Such revision generated a conversion guideline to all existing batch programs using VSAM. Worked on conversion programs that populated the entire customer DB2 database using a combination of existing VSAM, flat files, and DATACOM/DB. Worked on the conversion of the International customer database residing under FOXPRO to populate existing DB2 tables. Wrote the duplicate elimination process to clean the CMS database of duplicate customers and its corresponding addresses. Wrote various online programs for the Customer Maintenance subsystem as well as a JCL Control Card online subsystem (CCORS) to service batch stream processing.

ComRim Systems, Inc. - Alyeska Pipeline Service Co. 01/91 - 09/91

Enterprise Data / Solutions Architect - Anchorage, AK

System Environment:

IBM/3081, PS/2, MVS/XA, VM/XA, IBM/QMF, SQL/DS, OS/2, ISPF/PDF, DBSU, CICS/VS, VSAM, EASEL, COBOLII, SDF/BMS, SAS, SDLC, DATABASE MANAGER, REXX/2, COMMUNICATIONS MANAGER, OUTBOUND, NETNAV, LIBRARIAN, IMS/DC, Q/A, JAD/DSS

Responsibilities:

Installed and debugged the Data Logger system across all pumps stations (11 stations) to communicate with the main office in Anchorage, Alaska (IBM 3081, SQL/DS). Such application was designed and developed by us at ComRim the previous year. All programming and communications were properly tested as required by the client. Responsible for the revision and modification of a Preventive Maintenance system (PM) processing under CICS/VS and IMS/DB. Involved with users for the programming of enhancements to existing modules and the design/development of new ones (menus, I/O screens, and reports). Involved in the redesign of a security subsystem to cover the Valdez terminal through Prudhoe Bay, written under CICS/VS, COBOL, and VSAM at the host, dBase IV and Windows at the PS/2 level. Resolved logical and physical database model redesign as well as involved in the setup for Outward Bound product to transfer data files from PS/2s to host SQL/DS database. NETNAV was also utilized for this data transfer function.

ComRim Systems, Inc. - Alyeska Pipeline Service Co. 03/90 - 12/90

Enterprise Data / Solutions Architect - Anchorage, AK

System Environment:

IBM/3081, PS/2, SYMBOL handheld, MVS/XA, SAS, VM/XA, IBM/QMF, FOCUS, 3D, LOTUS 1-2-3G, SAA, IBM/AS, C, UBASIC, IEW, REXX, SDLC, EASEL, COMMUNICATIONS MANAGER, JAD/DSS

Responsibilities:

Leading analyst for the analysis, design, and construction of a Data Logging system under the BM/SAA profile. The application system was designed for distributed processing. The handheld PC (UBASIC) was developed to collect readings of pump station equipment and consoles, the PS/2 platform (Database Manager and SQL) was developed to collect, edit, and process data readings uploaded from the hand held for reporting and graphics, and the mainframe (VM/CMS, VM/AS, SQL/DS) to receive and load the data from the PS/2s to the SQL/DS database for a Decision Support System (Data Logger). Involved in the logical as well as the physical database modeling process for this Data Logger system at all platforms. Wrote all VM/AS, SQL, C, and some UBASIC code as well as EASEL prototype for this product.

ComRim Systems, Inc. - ARCO Alaska, Inc. 01/90 - 03/90

Analyst / Programmer - Anchorage, AK

System Environment:

IBM/3090, MVS/XA, IMS DB/DC, TSO, JCL, COBOL/II, SDLC, XPEDITER, MFS, ISPF/PDF, QMF, DB2, IEW, SAR

Responsibilities:

Part of a 6-analyst team to analyze and design ARCO’s Production Tracking System (APTS) using IEW CASE. Involved in the logical as well as the physical review of the existing model including its associated DFDs. Worked on coupling and cohesion of modules (decomposition diagram). The final product was to be developed under IMS/DC using COBOLII and DB2. Other responsibilities included a review of all BMPs under IMS to determine checkpoint intervals and be able to evaluate the IMS environment using the SAR tool. This study was carried out to review system capacity when operating with IMS/DB2 and its commit protocols for response time/batch processing considerations.

AGSI / IBM - US Air Force 07/89 - 11/89

Analyst / Programmer - Montgomery, AL

System Environment:

IBM/4341, MVS/XA, CICS/VS, TSO, JCL, SDLC, COBOLII, VSAM, DMS, DB2, INTERTEST, SDF-II, ISPF/PDF, SPUFI, QMF, Q/A

Responsibilities:

Provided technical support for the conversion of a SPERRY/COBOL/DMS Network database model to a DB2 Relational database model. This conversion covered a total of 800 screens and 320 programs using SDF-II for screen development and COBOLII/CICS/SQL as the host. The system related to the US Air Force CAMS which controls/maintains all F-16 airplane parts and engine/maintenance/flight schedules. The final product was installed for the Turkish Air Force (IBM 4381-93E).

AMS / World Computers - US Navy / Pentagon 09/87 - 06/89

Analyst / Programmer - Washington, DC

System Environment:

AMDAHL/5850, MVS/XA, VM/CMS, CICS/VS, SDLC, BMS, ISPF/PDF, APS/COBOL, VSAM, ICF, JCL, TSO/E, FOCUS, IMS/DB, DB2

Responsibilities:

Provided technical support for two financial and budget applications (CNO Gaming & AFDS) under CICS/VS and VM/CMS respectively. Coded conversion of modules from CICS to FOCUS and developed full in-house ISPF panels for VSAM reorgs, JCL streams, and other IDCAMS commands. Also coded process to simulate CICS batch processing using JCL and COBOL. Involved in a major VSAM reorganization and tuning and coded online and batch COBOL/SQL programs for a DB2 prototype (IMS to DB2) developing menus and I/O front ends.

Computer People / AMS - US Army 01/89 - 02/89

Analyst / Programmer - Roslyn, VA

System Environment:

IBM/3090, MVS/XA, COBOL, TSO, JCL, VSAM, COBOLII, ISPF/PDF, DIALOG MANAGER, CLIST, DSS

Responsibilities:

Involved in the review of a corporate data model to be used for a Maintenance Decision Support system for the Department of the Army. Provided database support in normalization to tune the entity model and wrote several COBOL programs and JCL utilities to populate such database by pointing to the corresponding VSAM clusters. Wrote various ISPF panels for batch processing.

DBMI - US Secret Service 02/88 - 06/88

Analyst / Programmer - Washington, DC

System Environment:

IBM/3090, MVS/XA, IDMS/R, OLQ, OLM, TSO, IDDM, ADGS, ADSO, CULPRIT, COBOL, JCL, DSS

Responsibilities:

Involved in the review of a Man-Hour Tracking System to develop a prototype using IDMS/R. Coded application using ADSO for the online process and a combination of CULPRIT and COBOL for

Contact this candidate