| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Kiestwood Circle
Plano, Texas Street Address
Home: PHONE NUMBER AVAILABLE
Email: EMAIL AVAILABLE cell: PHONE NUMBER AVAILABLE
SUMMARY
Information technology professional with proven skills in systems development and analysis, problem solving, client interaction, project leadership, and over twenty years of programming experience.
JOB QUALIFICATIONS HIGHLIGHTS
- 30+ years experience with MVS Cobol, Cobol II, DB2, VSAM, JCL, SAS, CICS.
-Ability to multi-task and manage multiple projects.
-Strong interpersonal skills and ability to establish productive working relationships.
-Positive, professional attitude.
-Strong communications and presentation skills.
-PC skills include MS Excel, MS Word, MS Project, MS PowerPoint.
-
PROFESSIONAL EXPERIENCE
PEPSICO/FRITO-LAY --- Oracle Support (BIS) Jan 2013 July 2015
Sr. Consultant
Supporting the business/technical Oracle, ESP, and mainframe application upgrades. Purchase to Pay (P2P), Fixed Assets, Accounts Payable, Product Cost, and etc.
Utilizing Cobol II, DB2(v9), SAS, Endevor, ESP(Mainframe/Unix), Quality Center, StarTeam, SQL, JCL, SPUFI, TSO/ISPF, MQ Series, etc.
PEPSICO/FRITO-LAY --- ReNew Oracle Project (BIS) Jan 2012 - Dec 2012
Sr. Consultant
Project ReNew has been chartered to upgrade the Frito-Lay US (FLUS) core financial systems. This includes Oracle Financials, Purchase to Pay (P2P) and Product Cost Accounting systems. Upon completion of this project, FLUS will be on a current/supported version of Oracle Financials.
The main focus of this project is to migrate the existing solution to Oracle version R12.1.X, a current and supported version of the Oracle e-Business suite. In addition, the scope includes implementing improved capabilities in several selected areas, including legal entity reporting, supplier portal and indirect procurement. The project also includes some minor performance tuning and Business Objects reporting for the Sales Accounting systems.
PepsiCo will be migrating the existing Oracle application suite to a current and supported version of the applications.
Utilizing Cobol II, DB2(v9), SAS, Endevor, ESP(Mainframe/Unix), Quality Center, StarTeam, SQL, JCL, SPUFI, TSO/ISPF, MQ Series, etc.
PEPSICO/FRITO-LAY --- Human Resources Systems (HRS) March 2009 - Dec. 2010
Sr. Consultant
Developed and coded the 2009 Ewing Scorecards at the Division, Region, Sales, and Plant levels. This tool is to measure the performance on key HR initiatives. Utilizing SAS Base/Stats, FSP, AF. Access. Plus Procs and Macros.
Maintain the new process from implementation thru the year-end.
PEPSICO BUINESS SOLUTION GROUP (PBSG) August 2008 Dec. 2008
Sr. Consultant
Enterprise Systems Development - Enterprise Test Center - End-To-End Testing (E2E)
Responsible for creation and update of new E2E staging libraries, compile screen changes, member move screen changes, MSM updates of source synchronization and archive processes, DB2 Bind cards, JCL checker (SAS), other cosmetic and requested changes.
Responsible for migration of all DB2 applications Credit to Collections (C2C), Finished Goods Inventory (FIG), Advertising/Merch. Promotions (AMP), Sales Accounting (FS2), Field Sales Commissions (FC2), Inventory Tracking & Costing (ITC). Utilizing Cobol, DB2(v9), SQL, JCL, SPUFI, TSO/ISPF, etc.
Projects were completed successfully and on time.
Bank of America/MBNA Technology, Inc. March 2007 Sept 2007
FM More/Hybrid project
Developed common interface modules for the new Disclosure information/process. This included a new DB2 table and a Table Master VSAM table to be accessed by the interfacing areas with the bank needing disclosure information. Developed a conversion module to convert the old/new Disclosure info into the new DB2 table. Developed a utility to load the new repricing/curing errors to the new DB2 online table for the users to view. Modified several existing modules within the FM core per repricing/curing processes. Utilizing Cobol II / Cobol, DB2(v9), VSAM, Easytrieve, JCL etc.
PEPSICO BUINESS SOLUTION GROUP (PBSG) Sep. 2006 Dec. 2006
Sr. Consultant
Designed and coded the new Costing Engine per the Annual Operational Plan (AOP) for the plants, distribution centers and business entities.
Environment: DB2, COBOLII, SAS, SPUFI, TSO/ISPF, JCL
Bank of America/MBNA Technology, Inc. Jan. 2005 Aug. 2006
FM/Information Delivery System
Lead Software Engineer
Developed new Repricing / Curing modules for the new business rules of BofA credit card processing. Also developed a new common central module that incorporated the new business rules from the old existing modules.
Responsible for assisting with the conversion of BofA credit cards to the MBNA platform.
Warehouse and Data Reporting- Project 380 Phase II for North America & United Kingdom.
Designed, code, and implemented the adding of new D2 Source table programs, modification
of existing DB2 Source table programs, the adding of new NDM transmissions and modification of existing transmissions.
Modified several screens within the Information Delivery s SSI CICS front-end systems for
North America and Europe UK/Ireland.
Designed, coded, and implemented SAS tools for referential integrity (RI) verification reports
and created new sum hash and trailer reports for the transmissions.
Environment: DB2, COBOL, SAS, CICS, SPUFI, TSO/ISPF, JCL, Endeavor, Expediter,
CA7/11, Mercury Quality Center, Peregrine 5.1, Route SDM, File_Aid.
PEPSICO/FRITO-LAY CORPORATION - Plano,Texas 1996 2004
Sr. Consultant
Enhanced, maintained and supported the core payroll systems of PeopleSoft (versions7.0/7.5/8.x) processing, plus quarter end reporting (SQR), and W2/updates for yearend processing. Utilizing 3-Tier Architecture and mainframe batch processing using Cobol II, DB2v7, VSAM, Easytrieve, SAS, etc.
Project leader and production support of vendor interface (inbound/outbound) systems General Ledger, Disability Management, Cost of Manufacturing, Relocation Reimbursement, 401K and Capital Stock, Exercised Stock Options, Risk Management, Pension Management, Health and Life Care Reserves utilizing Cobol II, DB2, VSAM, SAS.
Developed and programmed the Disaster Recovery process. The controller wanted to have in place a payroll disaster recovery plan and process to pay employees (all 45,000), if the data center was destroyed. By using the DB2 data unload flat files, Cobol II, AFP, VSAM, and JCL I created a mainframe batch process to produce the payroll register, pay checks, accounting transactions and PeopleSoft adjustment transactions. This process was approved by the controller, internal, and external auditors.
(PeopleSoft HR/Benefits/Payroll client server based system using host DB2 database) Enhanced and implemented version 5.12 of PeopleSoft payroll system. Team member that developed front end data gathering of Earnings, Taxes, and Deductions of feeds from (approx. 80) plants and field distribution centers, payroll benefits service offices, sales compensation, and etc. Maintained and supported the system through implementation. Utilizing Cobol II, DB2, SQL, VSAM, Easytrieve, etc.
Converted Focal Point 2 a SAS bonus and yearly compensation system to Cobol/DB2 processing system. Utilizing Cobol II, DB2, etc. Implemented the system 01/03.
Developed the Ewing Scorecard tools (5) to measure regional performance on key HR initiatives utilizing SAS Base/Stat, FSP, AF, Access, plus Procs and Macros.
Collected and organized data from the Frito-Lay Pension History (35 years worth from 3 different Payroll Systems) that was outsourced to the vendor Fidelity. Using SAS, Procs, and Macros.
Member of project team to convert PeopleSoft HR data to Oracle on AIX Unix server for use on a web based system. Wrote several SAS programs and used Oracle SQL to audit conversion.
Environment: DB2, COBOL, SAS, CICS, SPUFI, TSO/ISPF, JCL, Endeavor, Expediter,
CA7/11, Mercury Quality Center, Route SDM, File_Aid.
EDUCATION
B.S., AIB University, Iowa |
