Analyst Oracle

*

Thomas R. Fulton (US Citizen) Primary Phone: 248-***-****

**** ******** ****. ********* *****: 586-***-****

Commerce Township, MI 48382-4346 E-mail Address: abnft0@r.postjobfree.com

EDUCATION:

Bachelor of Science Degree in Business Data Processing - Ferris State University, Big Rapids, MI

TECHNICAL SKILLS:

Languages: COBOL, COBOL II, PL/1, ASSEMBLER, RPG, IMS DC/DB, DL/1, MFS, DCCS,

BMP-CHECKPOINT/RESTART, MMP, DB2, DB2 Utilities, SQL, SPUFI, QMF, CICS, VSAM, Focus,

Easytrieve, Teradata, MVS, AIX, z/OS, TSO, JCL, ISPF, GDG, REXX, Syncsort, Xpediter, FileAID,

IMSExpert, Gentran, Endevor, Panvalet, Changeman, CA7/CA11, DCCS, IDMS, Total, SAS,

UCC10/DSIMS Data Dictionary, Windows-NT/2000/XP/98/95, Linux, MS 2000, Lotus Notes, Sybase,

PowerBuilder 5, C++, Oracle 5/7/8i/9i/10g, PL/SQL, PL/SQL plus, Oracle Forms 6, Designer 2000,

Developer 2000, Erwin Data Modeling, SQL/Loader, TOAD, HPUX Unix Scripts, SAP, Mercury Test

Director, NATURAL, (AS400,CL,COBOL, RGB/ILE,ETL,DDS).

Middleware: IBM MQ Series, FTP, SOAP, EDI (210/276/277/278/834/858/860/947/993/994/997).

Web Development: J2EE, Java 2, JSP, JavaScript, JSP, Cold Fusion 4, XML, HTML, UDB, WebSphere, WSAD,

Toad, ADO.NET, CTG-Gateway, Domino, Visual Basic, Crystal Reports 8/9. Apache.

Project Management: MS Project 98, System Development Life Cycle (SDLC), MS Office (MS Word, MS Excel,

PowerPoint, MS LiveMeeting), VISO, Pert, Gant, JAD, SDM, Yordon Demarco.

PROFESSIONAL EXPERIENCE as an I. T. Consultant/Contractor from 1992 to the present:

05/2008 to 03/2009 Sierra ITS of Troy, MI: End Client – R. L. Polk.

Role: Senior Analyst – Used Vehicle, Monthly New Vehicle (VIO), Stat Survey,

Used Vehicle Load Balancing, Commercial Data Base Process (UNIX, scripts).

• Provided production scheduling, system/program error resolution and on-call 7x24 supports.

• Implemented system testing, user training, SIT/UAT development and created system run manuals.

The technical environment included: COBOL, PL/1, DB2, SQL, SPUFI, FOCUS-VAX/VMS, ADO.NET,

IMS-BMP, z/OS, CLIST, ASSEMBLER, MVS, VSE/SP, DCCS, JCL, DL/I, IMS DC/DB, CICS, VSAM,

TSO/ISPF, FTP, EDI, ETL, UNIX, IBM/DELL PCs, IBM 3090 and ES/9000, AS400, CL, RGB/ILE,

MS EXCEL, JAVA, HTML, ORACLE 10g/11i, PL/SQL, TOAD, REXX, PANVALET, FILEAID.

10/2007 to 03/2008 Covansys of Farmington Hills, MI: End Client – Daimler Financial Services.

Role: Senior Analyst – ABS Retail/Lease/Truck Suite.

• Migrated the ABS Retail/Lease/Truck Suite System coordinating with regular user meetings, analyzed needs,

discussed current procedures, analyzed and designed automated systems.

• Implemented more than 350 program elements, and provided system testing, user training, SIT/UAT case

development and documentation. The technical environment included : COBOL, PL/1, ENDEVOR, DB2,

SPUFI, IMS-BMP, z/OS, EASTRIEVE, CRYSTAL REPORTS, MVS, VSE/SP, DCCS, JCL, CLIST,

DL/I, and CA7/11,TSO/ISPF, FTP, MQ SERIES on IBM/DELL PCs, an IBM 3090 and ES/9000.

08/2007 to 09/2007 Halo Group of Novi, MI, End Client – American Community Mutual Insurance Co.

Role: Back-fill Senior Programmer Analyst – Agent Marketing, Agent Alpha Search, P + Health.

• Verified cross platform testing and reworked batched CA7 scheduling improving run efficiency utilizing: FTP,

CA7/11, COBOL II CICS, PL/1, FOCUS, DB2, SPUFI, QMF, TSO, JCL, ISPF, GDG, XPEDITER,

FILEAID, MS OFFICE, ENDEVOR, PANVALET, NATURAL, JAVA, WEBSPHERE.

Developed/devised SIT/UAT cases. Created Root Cause Solution Repository.

2

04/2006 to 03/2007 Capgemini Consulting of Southfield, MI: End Client – General Motors.

Roles: Lead Analyst – GVC, Senior Analyst - Sarbanes-Oxley/SOX/GMNA RIMS Playbook,

Senior Analyst: RIMS, BID, CSI, DID, DNPS, SAS, BARS, ECDB.

• Supported on-call GM Mainframe Applications utilizing: MVS/AIX, UNIX, CA7/11, FTP, COBOL II CICS,

PL/1, FOCUS, IMS DB/DC, BMP CHKPNT/RESTART, MMP, DB2, SPUFI, QMF, TSO, JCL, ISPF,

CLISTGDG, XPEDITER, FILEAID, MQ SERIES, MS OFFICE, EDI (210/850/857), ENDEVOR,

PANVALET, EASYTRIEVE, JAVA, WEBSPHERE, Oracle 8i//9i/10g; developed/devised SIT/UAT

cases.

• Provided Offshore Mainframe Technical support; created documentation to Knowledge Transfer run schedules,

utilized DB2 stored procedures and problem resolution protocols to the Offshore team in Mumbia, India.

Interviewed global clients via MS LiveMeeting/Conference calls to build the GM RIMS Sarbanes-Oxley(SOX)

Playbook.

01/2006 to 03/2006 – Free-Lansing I.T. projects as a Mainframe/Middleware/Web Programmer/Analyst.

Client: Dawson’s Tree Trim, Enhance the Customer Sales Analysis System. J2EE, HTML,ASP.

11/2005 to 12/2005 APEX Systems, Inc. Scottsdale, AZ., EDS Det., MI: End Client – Detroit Diesel.

Roles: Back-fill Oracle Application Developer/ Mainframe Support

• Provided ERP Application Conversion of Manufacturing Operations Non-EGR and ILVS to Oracle 9.2/Oracle

Forms 6, PL/SQL and UNIX Scripts to WSAD/JAVA2/JSP/JAVA SCRIPT/HTML/XML Windows XP

plant shop floor desktop screen menus.

Supported ERP Mainframe Applications utilizing: (MVS/AIX, CA7, FTP, COBOL II CICS, PL/1, FOCUS, IMS

DB/DC, BMP CHECKPOINT/RESTART, DB2, TSO, JCL, ISPF, REXX, GDG, XPEDITER, FILEAID, MQ

SERIES, MS OFFICE, EDI (857/210), CTG-Gateway.

05/2005 to 10/2005 – Free-Lansing I.T. projects as a Web Programmer/Analyst.

Client: Rent-A-Reck, Enhance the Sales Analysis System. J2EE/JAVA, HTML, ASP.

09/2004 to 04/2005 Charter Global, Inc. – Norcross, GA: End Client – DTE.

Roles: Mainframe Analyst / Oracle Application DBA

• Prototyped DB2 table load from Oracle 8i table and verify/support ( CA7, FTP) Supply Chain MMS

COBOL II CICS, PL/1, FOCUS, IMS DB/DC, BMP CHECKPOINT/RESTART, DB2, TSO, JCL, CA7,

ISPF, GDG, FOCUS, XPEDITER, FILEAID, MS OFFICE, EDI (860/947). Developed ad hoc SAS

Supply Chain Transaction Statistical Tracking Reports. Client: DTE Energy – Detroit, MI: Performed, Supply

Chain MMS Vendor Master Data Cleansing.

• Tuned Oracle 8i/9i application system queries, utilized Oracle Forms 6; Attended Oracle 10g Lab Seminar.

Developed user-friendly PL/SQL/UNIX scripts and extracts IMS DB reports from parallel MMS database.

Populated SAP MMS Table to create/load Oracle 8i tables and POT/AOT Oracle Forms 6 reports.

01/2004 to 08/2004 Trialon Corporation – Troy, MI: End Client – DCX.

Roles: Database Architect, Programmer Analyst

End Client: DCX Global Plant (Oracle 8i) Chemical Dispersion Hazard Tracking System; utilized DCCS.

• Created prototype draft database designs with ERWIN and UNIX scripts to clone MS Access Tables.

Designed UDB DB2 Tables and Cloned MS Access Tables utilizing WebSphere/WSAD with J2EE draft screens as

client option 2. Prototyped Cognos Reports using UDB Table and Unix Scripts as client option 1.

Prototyped MS Access Table using (PL/SQL) to create/load Oracle 8i tables and create SAS/Crystal Reports.

09/2003 to 12/2003 Point4 Solutions – Somerset, NJ: Client – Ford Motor /Visteon.

Roles: Back-Fill QA Analyst/Tester, Programmer Analyst, DBA

• Reviewed, analyzed and executed the cloning of the CMMS Ford/Visteon Manufacturing System in Dearborn,

Michigan with online SQA test scripts utilizing Mercury Test Director validating CMMS, WERS, ILVS

bridge/interface data sets and Cold Fusion reports.

Analyzed/Fixed online/batch MVS/AIX COBOL, COBOL II, DB2, GDG, JCL, TSO, ISPF, REXX,

CLIST,XPEDITER, FILEAID, IMS DC/DB, BMP CHECKPOINT/ RESTART, PL/1, FOCUS,

3

EASYTRIEVE, CHANGEMAN, GENTRAN, ETL, EDI (210/947/993) and Assembler programs and system

abnormal test terminations utilizing ManageNow logging software. Support Oracle 8i Visteon/Ford Cloned System.

Provided a draft DB2 initial table load and replace table data stored procedure test environment.

• Initiated Web business rule enhancement using Java2, J2EE and JSP maintenance code derived from JADS.

• As a DBA, developed UNIX Scripts/DB2 table load/recovery stored procedures; prototyped tables using ERWIN

for data modeling and prototyped MQ Series Queues. Created Oracle forms 4.5 Load/Recovery Reports.

Support Websphere/WSAD and CTG-Gateway migration.

09/2001 to 09/2003 Southeastern, MI: End Clients - MGS Staffing Services, PrePaid Legal

Independent Associates, Bill’s Tree & Co., Rent A Wreck, Highland Pawn.

Roles: Senior Programmer/Analyst/DBA

• Setup and Train small businesses to utilize Microsoft Office 2000, Outlook Express 6 and MS FrontPage 2000.

• Provided proto-typed middleware transitions utilizing MQ Series, SOAP, WEBSPHERE/WSAD or CTG-Gateway

in test case environment required and supported the production environment code using: (Java2, JSP,

MVS/AIX, COBOL II, PL/1, FOCUS, DB2, IMS DC/DB, TSO, JCL, ISPF, REXX, GDG, FILEAID,

XPEDITER, EASYTRIEVE, BMP CHECKPOINT/RESTART, MS OFFICE, CICS, VSAM, GENTRAN,

EDI (994/996), Oracle 8i, Forms 4.5/6, Cognos Reports, Cold Fusion); functioned as interim production support

DBA. Convert Oracle 7 to Oracle 8i/Unix Scripts.

11/2000 to 09/2001 Strategic Staffing Solutions – Detroit, MI: End Client – BCBSM.

Roles: Senior Programmer/Analyst-DBA

• Support, document, develop, convert COBOL/ COBOL II programs, production procedures and interface multi-

platforms utilizing XML business document exchange via MQ Series; provide system/project/program/

HIPAA standards documentation for Blue Cross Blue Shield of Michigan: HART on WEB DENIS UNIX

platform with a NASCO formatted feed and developed/devised test SIT/UAT cases.

• Created XML DTD syntax business start and end tag names data dictionary and designed model XML business

documents.

• Converted MVS/AIX, TSO, JCL, GDG, ISPF, REXX, EDI (276/277/278/834), ETL, ENDEVOR, PANVALET,

FILEAID, XPEDITER, COBOL/COBOL II, PL/1, IMS DC/DB, BMP, CLIST,

CHECKPOINT/RESTART, DB2, FOCUS, CICS, VSAM, Assembler, EASYTRIEVE, GENTRAN,

Convert Oracle 7 programs to XML and MQ Series.

• Developed Java 2 Enterprise Edition-J2EE prototype screens utilizing parsing module and create test cases.

• Modeled data, Designed test DB2 tables and exported test data via UDB to test DB2 tables, test DB2 Data

Warehouse and Data Modeled with ERWIN. DBA, granted privileges to project team members as the acting

UDB DB2 DBA and supported Websphere and GTG-Gateway interfaces.

07/2000 to 11/2000 Computer Horizons Corp. – Troy, MI: End Client – SBC.

Roles: Senior Programmer/Analyst (Data Warehouse): Support, document/Data Model, develop

production procedures and provide multi-platform ad hoc reports/ Data Mining,

(Converted Tandem Data Warehouse to Teradata Data Warehouse) for the SBC Ameritech Customer Utilization

Tracking System utilizing the SDLC. Designed ad hoc Oracle Forms 4.5 and Crystal Reports Area Code tracking

reports; created UNIX scripts.

11/1998 to 06/2000 - Free-Lansing I.T. projects as a Mainframe/Middleware/Web Programmer/Analyst.

Clients: Rent-A-Reck, Dawson’s Tree Trim. Enhance and maintain the Clients Inventory Systems. J2EE/JAVA,

HTML, ASP.

03/1998 to 10/1998

Phoenix Consulting, Inc. – Bloomfield Hills, MI – End Client: Comerica Bank

Roles: Senior Analyst/Project Leader: Provided Y2K testing and compliance documentation

Of the on-line/ batch client systems.

• Performed extensive Y2K compliance testing and documentation of the Comerica Bank Trust Systems and

4

Documented Y2k-compliance. (Continued on page 4)

• Tested GDG, TSO, JCL, ISPF, REXX, XPEDITER, FILEAID, IMS DC/DB, BMP

CHECKPOINT/RESTART, CICS, VSAM ANSI COBOL, COBOL II, DB2, PL/1, EASYTRIEVE,

On-line/Batch ASSEMBLER programs on-line/batch programs.

03/1998 to 06/1998

Phoenix Consulting, Inc. – Bloomfield Hills, MI – End Client: Henry Ford Hospital

• Performed Y2K VSAM File conversion and testing of the Henry Ford Hospital

Registrations/Admissions CICS/VSAM ANSI COBOL, COBOL II on-line/batch ASSEMBLER

programs. Addressed multiple program languages within the Registrations Admissions System.

• Technical Environments: CICS (VSAM), ANSI COBOL, COBOL II, EASYTRIEVE PLUS, PL/1,

JCL, IDCAMS, CA7/11, FOCUS, ABEND-AID, ASSEMBLER.

02/1997 to 02/1998 Kmart Corporation – Troy, MI

Roles: Systems Engineer/DBA - Initiated the retirement of Kmart legacy financial and inventory systems.

• Performed as DBA, extensive End-User Analysis and instituted the retirement of both batch/online D & B AMAPS

Inventory System conversion from Oracle 6 to Oracle 7 design/Forms. Coded, tested methodologies and trained

users through JADS. Developer Financial schema utilizing Oracle Designer2000/Developer 2000.

Coded prototype C++, VISUAL BASIC 4, TSO, JCL, ISPF, GDG, FILEAID, COBOL II, XPEDITER, PL/1,

CICS, IMS DC/DB, BMP CHECKPOINT/RESTART, DB2, VSAM, FOCUS, EASYTRIEVE,

EDI (210/860) on-line/batch Assembler programs. Developed code utilizing AS400 COBOL/RPG/ETL and

Variety of program languages to supply immediate system prototype reports for replacing General Ledger,

Margin Management, O. E. and subsidiary financial systems, utilized ERP, JADS and Unix Scripts.

• Created a Mainframe Financial Department Data warehouse via Oracle 7; ad hoc reports via Forms 4.5.

01/1996 to 01/1997 - Free-Lansing I.T. projects as a Mainframe Programmer/Analyst.

Client: Utilite Chemical: Maintain and enhance the Patient Review System: COBOL, IMS, DB2, CICS, JCL, TSO,

XPEDITER, FILEAID, ABENDAID, LIBRARIAN, PANVALET.

06/1995 to 12/1995 Anatec Corporation – Bingham Hills, MI

Role: Programmer/Analyst: Provided system migration of the Chrysler Transportation System.

• Performed extensive End-User Analysis. Designed the system following the System Life Cycle Methodology.

Developed specifications (both detailed and program). Coded, tested in PowerBuilder/Sybase (both system

and unit), and trained Sybase/NOVELL users (both one-on-one) and small groups). Coded TSO, JCL, GDG,

ISPF, FILEAID, XPEDITER, IMS DC/DB, BMP CHECKPOINT/ RESTART, COBOL II, CICS, VSAM,

DB2, FOCUS, EASYTRIEVE, CLIST, REXX on-line programs. Enhanced transportation screens.

Performed DBD and PSB Generations. Developed CHECKPOINT/RESTARTS.

04/1992 to 05/1995 - Free-Lansing I.T. projects as a Mainframe Programmer/Analyst.

Client: Utilite Chemical: Maintain and enhance the Patient Review System: COBOL, IMS, DB2, CICS, JCL, TSO,

XPEDITER, FILEAID, ABENDAID, LIBRARIAN, PANVALET.

03/1978 to 03/1992 - Provided Staff coverage for Detroit Edison MIS Systems.

Roles: Applications Systems Programmer/Analyst/DBA- IMS/DB2/CICS/ORACLE/FOCUS

and Project Leader.

Contact this candidate