CHERYL SMITH

***** ******** **

TAYLOR, MI *****

313-***-****

advrg0@r.postjobfree.com

SUMMARY

I have over 25 years of experience in the IT Industry. I have possessed roles including Lead Analyst, Project Leader, Business Analyst and Programmer/Analyst. During my years with Ford, I maintained Teradata data warehouse environments and supported and maintained the EDW data warehouse. I have experience working in all phases of the SDLC with emphasis on planning, design, development, testing, and implementation. My technical skills include but are not limited to ORACLE, COBOL, COBOL II, JCL, CICS, JES, Teradata and SQL. .

TECHNICAL SKILLS

Abend-AID

CICS

COBOL / COBOL II

Data Warehouse

DB2

File-AID/MVS

JCL

JES

Micro Focus COBOL

MVS

Oracle

PL/SQL

SQL

Teradata

TSO/ISPF

PROFESSIONAL EXPERIENCE

Ford Motor Company

BusinessAnalyst/SeniorEngineer

September 2014 – February 2023

Designed and Implement system to take file from the mainframe and place it on the cloud

Supported Global Securitization system.

Performed Data Architect duties. .

Designed and Implemented Teradata data warehouse projects.

Environment: Teradata, IBM z/OS TSO/ISPF COBOL II, DB2, VSAM, IDCAMS, File Manager, Fault Analyzer, MVS, JCL, JES ZOS Connect

The Epitec Group

August 2010 – September 2014

Ford Motor Credit, (August 2010 - 2014)

Incorporated Teradata Utilities and SQL to load new tables.

Supported systems that load Teradata data.

Verify the integrity of the data.

Provide enhancements to the data warehouse.

Supported the production of Teradata data warehouse.

Initiated new data in an existing database, maintained existing data, and purged obsolete data.

Environment: Teradata, IBM z/OS TSO/ISPF COBOL II, DB2, VSAM, IDCAMS, File Manager, Fault Analyzer, MVS, JCL, JES

PROFESSIONAL EXPERIENCE – Continued

Thomson Reuters, Ann Arbor, MI

Data Mananger

April 2009 – August 2010

Worked closely with the client manager and account team to identify and understand clients’ healthcare information needs.

Assured that data management projects are delivered on time, fit for use, and within budget.

Developed, maintained and documented database design and data enhancement specifications, and presented these to the client.

Designed, maintained, executed, and documented database tests and supported user acceptance testing.

Instructed clients on database structure, data quality, documentation, and software applications.

Assisted the analytic consulting staff in evaluating the usability of the databases.

Recognized and managed out-of-scope activities so appropriate actions could be taken to reset client expectations or obtain additional revenue to support the work being done.

Environment: Oracle Developer, SQL, DataStage and Advantage Suite

Compuware Corporation, MI

Business Analyst / Programmer / On Site Coordinator

January 1995 – February 2009

Ford Motor Company, (March 2006 – December 2008)

Managed Asia Pacific IT teams for 17 different systems.

Collaborated with the offshore team in preparing and reviewing functional and technical specifications for incident and problem resolution.

Responsible for coding, programming and maintaining Teradata, and DB2 programs.

Coded JCL and responsible for running all JCL test jobs.

Used FileAid to analyze data and create new data.

Served as code editor for TSO/ISPF.

Collaborated with business partners in the coordination in Customer Acceptance testing of fixes.

Ensured coverage for incident acknowledgement during India's non-working hours and holidays.

Prioritized issues and monitored resolution.

Monitored off-shore resources to ensure all production and business support requirements were met.

Prepared and presented status to management.

Environment: IBM, Teradata, COBOL, DB2, VSAM, IDCAMS, TSO/ISPF, Abend-AID, File-AID/MVS, JCL, TSO/ISPF

Ford Motor Company, (October 2001 – March 2006)

Incorporated Teradata Utilities and SQL to load tables.

Supported systems that loaded the data to the Teradata tables.

Verified the integrity of the data in the Teradata tables.

Provided enhancements to the data warehouse.

Supported the production of Teradata data warehouse.

Initiated new data in an existing database, maintained existing data, and purged obsolete data.

Environment: Teradata, IBM z/OS TSO/ISPF COBOL II, DB2, VSAM, IDCAMS, Abend-AID, File-AID/MVS, TSO, JCL, JES

University of Michigan, (January 1995 – August 2001)

Designed, implemented, and supported PeopleSoft Student Financials.

Designed system modifications to support current business polices, including creation of projects, menus, panel groups, panels, process definitions, fields, records, and translated values.

Modified SQR, COBOL, and PeopleCode.

Analyzed and developed a conversion process.

Applied PeopleSoft fixes, enhanced, and corrected student accounting process.

Collaborated in IMS to DB2 conversion.

Designed ID card system, developed flow charts, programmed specifications, and supported the implementation effort.

Environment: PeopleSoft, MS Windows 98, UNIX, MVS, Oracle 8.1.7.0.0, PeopleTools 7.61, PeopleCode, SQR, MS Word, MS Excel, Crystal Reports, Lotus Notes, Micro Focus COBOL, PFE, COBOL II, DB2, QMF, CLIST, JCL, SQL, SQL *Plus, PL/SQL, PeopleSoft Query, PeopleSoft Student Financials, TSO/ISPF, Roscoe

PROFESSIONAL EXPERIENCE – Continued

Sysco Foods, TX

Programmer / Analyst

October 1993 – January 1995

Developed, implemented, and supported the uniform vendor system.

Modified and supported programs.

Transferred data from AS/400 to MVS.

Designed, developed, implemented, and supported payment confirmation.

Designed, developed, implemented, and supported order entry auto confirmation systems.

Environment: IBM MVS, DB2, COBOL II, CICS-Command, SAS, VSAM, IDCAMS, TSO/ISPF, SDSF, Interest, TLMS, Abend- AID, File-AID/MVS, CLIST, JCL, QMF, SPUFI

Houston Chronicle, TX

Programmer / Analyst

April 1993 – October 1993

Enhanced the current Billing System.

Designed and created test data.

Executed system tests.

Designed, developed, and implemented a Customer Variance System.

Wrote CLISTs to compile programs, calculate block size, create and list GDGs.

Environment: IBM MVS, COBOL II, Xpediter, JCL, VSAM, File-AID/MVS, Abend-AID, TSO/ISPF

EDUCATION

Bachelors of Business Administration, Operations Research Information Systems, Magna Cum Laude, Eastern Michigan University, Ypsilanti, Michigan

Contact this candidate