Mainframe Applications Developer
Resume:
CHERYL SMITH
TAYLOR, MI *****
**********@*****.***
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