PROFESSIONAL ASSOCIATIONS: IBM Best Team Member

• Evaluating Small Talk/Visual Works, MQ, Net Server, etc.
• Licensed Real Estate Associate Broker N.Y.S.
• Adjunct Professor in Math/Computer Science/Business

AREAS OF EXPERTISE

• SYSTEM ARCHITECT: Business Objects
• Data Modeling, Erwin, UML SDLC
• Thomas De Marco, Gane Sarson,
• Warnier Orr and Yourdon Methodologies
• HARDWARE: Intel PC Pentiums/Servers, CISCO Routers
• AMDAHL 470/V6/V8, TERADATA DBC/1012, IBM PC/PS2
• IBM System 360, 370, 390, 30xx, 43xx, 9xxx, ES9xxx
• OPERATING SYSTEMS: Z/OS OS/MVS/XA JES 2, 3 JCL
• DOS/VSE VM/CMS
• VISTA, Windows NT/2000, Windows 95/98/XP, MS/DOS
• LINUX/UNIX/AIX
• OS/2
• SOFTWARE: CICS Command , BMS, Intertest/EDF, XPEDITER
• DB2, UDB, QMF, SPUFI VSAM
• IMS DB/DC, MFS, BTS II
• CA-DATACOM
• MS-Office, MS-Project, MS-Access, MS-Visual Basic
• Model 204
• Teradata
• Websphere
• MQ Series
• Data Warehouse
• Eclipse Development Workbench
• PowerBuilder
• SYBASE, Oracle, SQL Server
• Lotus Notes, Ami Pro
• FOCUS 6.5
• SAS
• EDI
• File-Aid, ICCF ISPF/PDF/SPIFFY VISIO
• Endevor, Librarian, Panvalet, Roscoe
• TSO/E, REXX, CLISTS, Dialog Manager
• LANGUAGES: SQL MS SQL, DB2, BRIO, DS, MSA IE , DL/1, RDBMS
• COBOL, COBOL II, COBOL III, MF COBOL
• ADABAS Natural , Assembler, FORTRAN
• PL/1, C, C
• JAVA, JAVA Script
• Easytrieve/Plus, GASP II Simulation , Mark IV and V
• GEAC/DBS/MSA/McCormack Dodge Packages

BACKGROUND:

A seasoned professional with over fifteen years experience in data processing. Expertise includes coding, testing, implementation, designing and writing of functional descriptions, business objects, project management and independent project development on various system platforms. Applications have included banking, brokerage, credit card services, communications, education, engineering, financial, healthcare, human resources, insurance, internet, manufacturing, retailing, shipping, software services, teaching, telephony and utilities.

EXPERIENCE:

Confidential

Partnerships

IBM - GLOBAL SERVICES

• As a Consultant serviced various internal customer groups in ISC-IW, WorldWide Distribution Data Warehouse.
• Wrote IT Requirements, Business Proposals Lotus Notes , analysis and code PL/1 /MVS/DB2/WebSphere/MQSI Gateway programs SCLM interfacing with existing AIX system and BRIO reporting of UDB activity.

IBM - MERRILL LYNCH BROKERAGE multiple independent engagements

As a Consultant for IBM monitored Foreign Exchange Trade system in CICS v2.3 and Visual Age PL/1 MLE v1.0 for VSE/ESA. Independent support GFX Back-Office trading settlement, SWIFT confirm-payment processing, hedge funds, Implement support, upgrades, fixes for production EMU system using CA-DATACOM/DB v9.0 with CA-VOLLIE v5.0 under POWER v6.3,stored procs, CLS, GL troubleshoot Global System UML, MS/VISIO/Office.

IBM - LUCENT TECH

• Assisted in a Year 2000 analysis team as a consultant with IBM, for Lucent Technology, refining IBM's RA
• Tool to study date related corporate data processing software impact issues for upcoming millennium.
• Produced client deliverables and a recommended approach for the solutions using Microsoft Project, Access,
• Excel, Word and QMF.

IBM - MANUFACTURING

As a Project Leader for IBM's Development and Process Record System DPRS , monitored all manufacturing production systems and interfaced with users to program IMS/DB PL/1 requests, support international wideband reports, ZAP database segments, coordinate transmissions between data centers and correct all production errors. Produced weekly system reports Script and conducted biweekly user status meetings. Worked on initial model of PPP SQL/DS system for Proposed Processing Planning requests for interplant engineering analyzers. Used

Lotus Notes, VM/CMS, QMF.

IBM - FLORIDA POWER LIGHT

As a Consultant for this utility company, coded logic in COBOL II using SQL/DS and ISPF panels for scrolling inquiries on radiation exposure monitoring and access control system REMACS . Worked with program skeletons produced from a program generator with all table, panels and basic call structures REMACS used ISPF services for menu processing and a REXX exec to control menu to function, and function to function transfers used QMF for table Queries.

IBM - PRODIGY

As a lead Consultant for IBM completed system code PL/1,COBOL , documentation Script , on-line CICS file VSAM maintenance screens and relational database DB2 input to interface with system groups to implement Impression Billing system. Handled all users 'AD HOC' reporting requests and SPUFI inquiries. Used MS WORD for system status reports.

COMPUTER HORIZONS SOLUTIONS MRC.

As a Team Leader supervised, analyzed and developed Year 2000 strategies and system solutions for several applications. Project teams consisted of up to 10 people in three groups analyzing COBOL I II, C, C , PL/1, FORTRAN, FOCUS, REXX, VB, Clists, SAS, Easytrieve/Plus, Assembler languages using IDMS, IMS/DB, DB2, ORACLE, SIEBEL, VSAM, UDB, M204, ADABAS, CA-DATACOM, Teradata databases and IMS/DC, CICS, ADSO on-line screens. Interfaced with clients AT T, Prudential, Square D, etc to further develop construction plans and implementation strategies. Led a specialized team to develop strategy planning and coordination with the client and their production schedule. Worked in team efforts to code, test, upgrade several client applications. Wrote RPC, analysis results and summation tables.

FINANCIAL/BANKING/BROKERAGE/CREDIT CARD SERVICES: SALOMON SMITH BARNEY

As a Consultant Work Flow Translator Team Lead staffed and managed a team of 30 deengineers to create COBOL business objects from established COBOL DB2/CICS legacy back-office brokerage Stock Option Purchase Trading system. Utilized system development methodology derived from analysis of COBOL BUSINESS OBJECTS book authored, written and employed by Robert Levey to put his object structure in the form of variable/s within a method within an object/s within a defined class. Analyzed entire system flow to determine critical event analysis including time dependent transactions and functions. Worked with Work Flow Analyst in developing system Visio/Scripts/DFD/Specs and logic flows for the teams. Analyzed business rules and functions using a case tool, DECOMP, built with Visual Basic/SQL Server and Java for end user interface. Trained teams to use the toolset and understand business functions. Removed all control flow logic.

Confidential

• As a Project Leader supported developing database modeling system for the merger of two banks. The system, R2/D2, was originally written in SPL, acted as DBA to integrate IMS/DB and IMS/DB2 users, userids, userapps, nodes, lterms, vtamapps, nodeapps and clients. The system had a PowerBuilder front end supporting DDCS, DB2/2 and SQL servers. The PC platforms were OS/2 and Windows using OOP, Smalltalk and Visual C .
• As a Consultant for their newly formed brokerage stock transfer agency, handling stock transfers and electronic securities, coded IDMS CICS programs to accomplish new systems development and electronic transfer of such certificates. Wrote all issue level reports and was a team member for certificate expansion conversions.

CITICORP

As lead Consultant became Project Leader for this national bank's credit services, prepared all functional designs, specifications and programmed all PROFITS Profitability Reporting On-line Financial Information Tracking System Information Expert programs GEAC/MSA - V87.01 . Worked with Accounting MIS VP to formulate all reports in the 4th generation language SQL using relational database Teradata input. Analyzed and developed LIMs Logical Interface Modules with Teradata DBA. Worked with users to assist them in reporting financial summaries and consolidation for their respective divisions. Interfaced with Corporate Data Center in the initial design and set-up of multi-vendor hardware system. Used system methodology based on Meilir Page-Jones/Ed Yourdon. Documented new financial reporting system for publication.

AMERICAN EXPRESS

As a Consultant for this entertainment and credit card company designed the Accounts Payable on-line CICS system for their plastic card payments and transactions LASER . Wrote high level design Yourdon for data capture from service establishments. System design included interface into global fraud database to reject invalid cards, verified credit limits as well as returning authorization codes and appropriate charges to both service establishments and cardholders. Suspense flag and reports for transactions under review. Prepared data dictionary element matrix list for all screen and newly modeled database fields IMS DB/DC .

GENERAL ELECTRIC CREDIT CORP.

As a Team Consultant created CICS v4.1 test plans for conversion of 37 regions. Received UNIX packets from

• LU6.2-TCP/IP protocol to mainframe CICS front end using IBM MQ Series. Analyzed data packets in MQ transactions from Unix system to expand client table input arrays, correct CICS news screens for update and retrieval of client groups and blocked client switching from restricted accounts. Used MS-Project, Access, TMON, and Omegamon in developing test plans, results and solution tables for shared region resources. Coordinated testing with database administrators for impact and assessment of total business unit operations.
• Participated in a team of Anderson Consultants, employees, IBM specialists in solution planning and testing of all test, development and production regions. IBM UDB queries/updating. Used ISPF/PDF to run SMP/E commands.

COMMUNICATIONS/TELEPHONY:

NYNEX NMCC NYNEX MOBILE multiple engagements

As an Advisor for this regional telecommunications company optimized TELESECTOR application production systems, analyzed job performances using STROBE, IMS monitors, SMS, TMON, Omegamon, using skills acquired from years of experience, to streamline runtime, CPU, EXCPS, and effectively use all system resources. Presented management with performance and optimization proposals. Support INFO2000 Telecommunications management billing system using DB2/CICS COBOL II QMF reports . Used MS Word for trouble log reports. Added DB2 table for partition archiving of quadrants, time/stamp redundancy sanity check, with host generated table values. Used Relay Gold for 24-hour support.

UNITED TELEPHONE

As a Consultant for this major independent telecommunications company worked on Customer Loop Assignment Systems CLAS to produce various database IMS/DB reports and system updates to maintain the assignment of physical equipment through service and repair order processing. On-line inquiries IMS/DC , message switching, PF key program switching and on-line COBOL reports.

AT T 4 divisions multiple engagements

As a Consultant for this major telecommunications company was responsible for the design, development and production implementation of Payroll Mechanized Time Reporting System for human resources payroll and pension, human factors engineer design, design of screen layouts IMS/DC , program specifications, coding PL/1 and testing of Employee Inquiry transactions database IMS/DB , and design and testing of message input and output modules. All initial design Warnier Orr was written in pseudo code using Script. As an analyst defined solutions for the development of Employee Benefits Package to handle over 90 union contracts with various benefit plans associated with each contract. Worked in Business Service Support group to oversee all production development and testing of the TIMES payroll input system. Monitored all production runs during corporate divestiture with SAS, ADABAS Natural , Fortran, Model 204, IDMS and IMS systems. Worked in the Treasury Department balancing databases IMS/DB COBOL for eight companies for stock transfers, sales, equity issues and tender offers created statistical data used in balancing billing totals for security transactions, streamlined operations, worked with internal auditors to cross check all transactions, allowed for on-line inquiry options IMS/DC to switch account number between companies, also to display ESOP or DRISPP information when there was no common securities. Taught PL/1 concepts to COBOL programmers, studied new C language.

BROOKLYN UNION GAS KEYSPAN

As a Consultant Project Leader designed object oriented event analysis for inbound messages using IBM CallCoordinator CallPath services. Used CC CallPath CICS/MVS as an application enabler for coordinating voice and data applications that use PL/1 based programs to access the services of telephone switches Lucent Tech G3rV4 PBX voice recognition unit VRU/IVR using IBM Direct Talk/2 managed by CC CallPath SwitchServer/2 running under OS/2 with Cisco 7000 Routers. Using NYNEX's ANI automatic number identifier as a database key, populated the customer representative's screen with required information for on-line call transaction inquiries at hand. Designed and implemented a new customer automated credit extension and payment function blending with outbound marketing campaign. Used MS-Word, Ami Pro and Visio tools in telephony upgrade design.

PEPSI-COLA

As a lead Consultant for this international beverage, restaurant snack food co. became instrumental in the redesign of Human Resources Benefits System IMS/DB, CICS, PL/1 , conversion of CICS BMS/SPF to BMS/GT, FOCUS reports, user workshops, Personnel Confirmation Letters, Enrollment Forms Calculation Worksheets, Pension Benefits and Payroll contributions. Updated all documentation. Used PC-Windows RUMBA , Docutext, VM, File-Aid Intertest.

ENGINEERING:

GRUMMAN AEROSPACE

• As a Consultant became Database Administrator DBA IMS/DB for this national engineering aerospace
• corporation for their Corporate Parts Labor system. Created all ACB, DBD and PSB's. Worked with engineers in
• the complex database design of inverted tree parts assembly segments 32 levels of their relational and logical
• databases. Created data dictionary members and definitions for the new segments. Worked with programming staff in the testing of such

INTERNET:

• JADE SYSTEMS CORP. As a Lead Analyst identified financial reporting solutions using PRO IV for management budgeting. Coordinated junior team using Visual Basic and Java to set up newly modeled Oracle database web connection for catalog sales of marketed products. Try/Buy permanent position ended after company changed directives and position filled internally, company reorganized and management sold the business. MERCEDES BENZ CREDIT CORP.
• As Project Leader managed development team and became the 'gatekeeper' for the Sybase interface to mainframe, for nationwide lease/retail credit services, writing IVR VRU Sybase net-gateway database access CICS/DB2 stored procedures RSP . Delegated authority to teams to trouble shoot Voice Recognition system and worked together to satisfy user communities needs. Coordinated all user requests into product development and lead staff personal in user support environment. Scheduled weekly status meetings, development of solutions, new Imaging projects, Archiving Y2K. Try/Buy Director position ended after company moved out of state Detroit .

HEALTHCARE/INSURANCE:

INSURANCE SERVICES OFFICE INC. As a Consultant converted CICS online Data Cap System from IMS DB to IBM DB2. Worked independently to create new business functions. Wrote CICS temporary storage queues to capture changed data and populate other system areas.

METLIFE

As a team member assisted in the conversion to McCormack and Dodge Millennium DBS files from MSA general ledger E/M series for a major insurance pension provider COBOL III in VM, Easytrieve in MVS, LOTUS NOTES .

MEDCO MERCK

Worked in an Ad Hoc reporting group, utilizing Easytrieve/Plus report writer, creating medical claim history, summary and drug usage reports for nationwide users RUMBA . Interfaced with all pharmacy, NDC, client files.

BAXTER TRAVENOL

As a Consultant for this hospital service group implemented merge/purge COBOL program sub-system to maintain all segments in their database IMS/DB . Corrected all provider sorts and label programs. Created on-line CICS third party billing information patient test data.

HOME LIFE INSURANCE

As a Consultant for this national health life insurance corporation assisted in the training of personnel for IMS/DB use of Life Insurance Statistics System. Programmed major IMS/DB COBOL programs and wrote functional design for Phase 2 implementation of HR Payroll and Pension funding systems. Wrote all TSO Clist programs used in the system.

BINGHAMTON GENERAL

As a Systems Analyst for a hospital merger was responsible for programmed conversion systems in A/R, Payroll, G/L, HR Pensions, Vacation Schedule and Patient Invoice Billing. Used COBOL Report Writer feature.