Business Analyst Technical
Resume:
Donnie Sprinkle
Concord NC 28025
Primary Phone 704-***-****
E-mail: ***********@********.**.***
Technical Expertise
Mainframe
Hardware: IBM 30XX/43XX
Software: Basic; CICS Command; CICS Macro; Clist; COBOL; COBOL II; DB2/IBM; Easytrieve+; MVS JCL; Intertest; JES; Librarian; INFOR/GEAC/DBS M: Series HR, Payroll and Report Writer; MS/DOS; OS/MVS/XA; Pascal; PDL; PL/1; SPUFI; QMF; TSO/ISPF; CA-7; CA-11;VSAM; Endevor; DOS/VSE; DOS/VSE JCL; OLLY Editor; SQL DB2; APS Programming Language; MFE Cobol, Quality Center, INFOR/GEACE Series, SAS, ZEKE, DB2 Stored Procedures, Agile Methodology
Server/PC
Hardware: Personal Computers
Software: Crystal Reports; Crystal Enterprise; Lawson Payroll, HR and Benefits 8.03; Excel; Word; Access; Project, Microfocus COBOL; PeopleSoft 8.8, PeopleTools 8.4, SQR, SQL, APP Designer; Unix, Windows, Micro focus Cobol, MFE, Remedy, Active Client (GEAC), FICS. FMS, INovah, EMR for Accounting
Experience
Business Analyst at City of Charlotte – CCCi Consulting
10/2012 – Current
Senior Business Analyst
Performing day to day Business functions for the accounting dept. with AP, AR, FA and GL.
FMS Accounts Receivable tool – Implemented Collection Agency interface, Debt Setoff
GEAC E-Series GL, AP, & AR, GEAC Active Client
Security Administrator for GEAC, INovah, FMS, FICS, GL Data warehouse
Writing reports using GEAC IE Report Writer
FICS, EMR, MPC and Image Now daily maintenance
GL Uploads performed daily using JCL and ZEKE to run and schedule jobs
Creating Project Plans for small to medium projects and managing these projects.
JCL, SAS, COBOL, ISPF, WORD, EXCEL, MS Project are all utilized.
Excel used extensively including pivot tables
Writing Training Documents and training end Users on New Software Productsand Enhancements
Modified SAS programs for GL Upload processing while converting to ERP
Maintaining Help Desk tickets on Remedy
Technical Analyst at Bi-Lo /Winn Dixie – TEK Systems
07/2012 – 10/2012
Senior Technical Analyst
JCL, MVS, VSAM, Endevor, MFE, Easytrieve, GEAC M Series Accounts Payable, Accounts Receivable, GL, Fixed Assets, PDL, Millennium, Excel, Word, Endevor
Created Mapping Documents and crosswalks to Map GL data from Legacy GEAC system to Peoplesoft.. Wrote Cobol program to extract the data and create upload files for Peoplesoft..
Technical Analyst at Vanguard Group – Liquid Hub Consulting
10/2010 – 12/2011
Senior Technical Analyst
Environment: COBOL, ISPF, DB2,DB2 Stored Procedures, JCL, MVS, VSAM, Endevor, MFE, Easytrieve, Excel, Word, Quality Center, Agile and Endevor
Developed and supported Mainframe systems with interface to Midtier for Webapplications. All data was DB2 using stored procedures for data retrieval and storage. All development and testing using MFE interface.
Worked in testing roles when development work was not available. Wrote test scripts for new development using Quality Center.
Technical Analyst at Blue Cross Blue Shield – Ettain
11/2008-06/2010
Technical Analyst
Environment: SAS, COBOL, ISPF, DB2, CICS, JCL, MVS, VSAM, Endevor, APS 4thGeneration Language, Easytrieve, Excel, Word, Power Point, Project and Endevor
Conversion of Insurance Groups and Subscribers from an old IMS system to CICS/DB2 usi
Analysis and Design of new systems and tables for Insurance Subscribers and Claims
Created Mapping documents going from old systems to new systems for all financials
Full Life Cycle Analysis, Design, Develop, Test and Implement new systems
Gathering functional requirements and writing technical specs for conversion
Developed Cobol, Easytrieve/VSAM and DB2 Programs for conversion of 20 million subscribers
APS Programming Language was the language that BCBS used for all Production applications
Spent three months working on the Financial applications including AP, AR, and GL
Produced Documentation for all new systems as well as any changes that were made to Production.
Technical Analyst at State Comptroller’s Office, The State of Texas ACS Consulting
02/2007-05/2008
Technical Analyst
Environment: COBOL, ISPF, DB2, CICS, JCL, MVS, VSAM, Endevor, Excel, Word. Millennium
Provided GEAC support for M Series DB2.
Worked with End Users and Management to support GEAC Payroll/HR Package Software Systems
Worked as a Business Analyst to determine Business model changes and enhancements.
Met with Users to determine new requirements and wrote detail design specs for new systems
Wrote technical Design Documents for the Technical groups for coding
Developed Cobol/VSAM and DB2 Interfaces for Benefits. Vendor Reporting, and Open Enrollment
Responsible for completing work orders consisting of changes, problem fixes, and enhancements for all GEAC related items utilizing the Full Life Cycle, providing formal estimates, technical design, technical test plans, documentation and executing these processes’ through implementation.
Technical Analyst/Project Manager at Jackson Memorial Hospital, Miami 05/2006-02/2007
Project Manager - Donnie Sprinkle Company
Environment: COBOL, ISPF, MVS, JCL, VSAM, IMS, EASYTRIEVE+,GEAC, PDL, Millennium and Endevor
Installed new Field Expansion Release
Responsible for the conversion of 350 Easytrieve+ and 200 COBOL user written programs that interface with GEAC Payroll System to make them compliant with the new release Developed and managed Project Plan with Microsoft Project.
Responsible for testing, documentation and migration. Responsible for 2 other consultants and the implementation of GEAC 12.0. New release
Technical Analyst/Business Analyst at GEAC Computer Systems, Inc. (Vendor) Aramark Corporation
02/2005-05/2006
Contract Technical Analyst / Business Analyst
Environment: COBOL, ISPF, MVS, JCL, VSAM, CICS, WORD, EXCEL,GEAC, PDL, Millennium and Endevor
Responsible for the implementation of GEAC HR12.0 and Millennium 3.5 at Aramark Corporation
Responsible for completing work orders consisting of changes, problem fixes, and enhancements for all GEAC related items utilizing the Full Life Cycle, providing formal estimates, technical design, technical test plans, documentation and executing these processes’ through implementation.
Gathered Functional requirements and wrote Technical work requests
Worked for GEAC to do all online CICS conversion and Interface Cobol/DB2 Programs
Payroll consisted of 100,000+ employees, performed testing and worked with end users
Prepared presentations for users explaining new features
Technical Analyst/Business Analyst at Jackson Memorial Hospital, Miami FL
11/2004-02/2005
Contract - Donnie Sprinkle Company
Implemented Position Control including 16 new online programs (PDL) and 10 Cobol programs for Conversion & maintenance for GEAC M-Series
Technical Analyst/Business Analyst at Baptist Health Systems, Pensacola, FL
05/2004-11/2004- Donnie Sprinkle Company
Technical Analyst
Environment: Lawson, GEAC, PDL, Millennium, COBOL, JCL, IMS, VSAM, ISPF, CICS, SQL, DB2 and Endevor
Developed programs to extract the data from the Legacy system (Mainframe) and format it to Lawson transactions and loading these to Lawson
Responsible for the conversion & implementation of Lawson HR/Payroll/Benefits from GEAC M-Series
Developed Interfaces from Lawson to existing systems and vendors.
Created Data Mapping Crosswalks and Gap Analysis
Responsible for all HR/Payroll and Benefit Conversions.
Utilized UNIX system operating tools and languages.
Wrote SQL to update and validate system conversion results.
Crystal Interfaces and Crystal Reports were created for 30+ programs to replace the old Legacy systems.
Technical Analyst/Project Manager Mercy Hospital, Miami,FL
02/2004-05/2004
Project Manager
Environment: Access, JCL, GEAC, PDL, Millennium COBOL, MVS, SQL Server, Project Mgmt and Endevor
Wrote an application using Microsoft Access to archive the data from the GEAC legacy system allowing online access to HR/Benefit data.
Technical Analyst/Business Analyst/Project Manager at Broyhill Furniture, NC
05/2003-02/2004
Project Manager/Technical Analyst/Business Analyst
Environment: PeopleSoft, MVS, ISPF, JCL, COBOL, VSAM, GEAC, SQR, People Tools, Project Mgmt
Responsible for the support and Maintenance of the GEAC HR/Payroll M-Series system including Yearend, Profit Sharing, and Benefits. This all took place while implementing the PeopleSoft system.
Co-Project Manager
Implementation of the PeopleSoft 8.8 HR/Payroll and Base Benefits systems.
Responsible for the entire Conversion from the Legacy GEAC system to PeopleSoft
Wrote Crosswalks and Data Mapping Requirements from GEAC systems to Peoplesoft
Approx 35 SQR’s to load the data to PeopleSoft.
Responsible for managing the tasks for the Technical group, and assuring that the Planning, Development, Testing, and Implementation was completed in a 6-month window.
Wrote several SQR reports and interfaces for various Payroll and Benefit requirements.
Assisted in the data validation and running of test scripts.
PeopleSoft training for People Tools I 8.4 & People Tools II 8.4, SQR– PeopleSoft University, Atlanta
Technical Analyst/Business Analyst at Mercy Hospital, Miami, FL
06/2000-03/2003
Project Manager/Technical Analyst/Business Analyst
Environment: Lawson, MVS, ISPF, JCL, COBOL, VSAM, DB2, CICS, GEAC,Millennium, Project Mgmt
Responsible for the smooth transition of outsourcing all of Mercy’s GEAC products, including Payroll, Human Resources, Benefits, and General Ledger.
Installed upgrade HR: M releases 11.12.46 through 11.12.49 and performed Quarterly and Year end functions, including W2’s and yearend taxes for multiple years.
Implemented GEAC Benefits and FSA modules.
Performed Data conversion and data mapping from Geac Payroll, Human Resources, and Benefits to
Lawson software system.
Performed data acceptance and parallel testing in Lawson
Wrote Crystal reports from Lawson Oracle tables to replace interfaces previously coming from Geac to other applications.
Wrote Crystal reports for Benefits and Payroll; and was administrator for Crystal Enterprise reports set up.
Attended Lawson formal training for Payroll 8.0 and Human Resources Structure 8.0.
Technical Analyst/Business Analyst at Mercy Hospital, Miami FL
07/1999-04/2000
Contract
Installed the Y2K release of GEAC HR/Payroll and Benefits, in addition to release 11.12.42, 11.12.43, 11.12.44, 11.12.45, and Millennium 3.2, in a DOS/VSE environment.
Installed the Benefits module and wrote Report Writer reports as required.
Completed Year-end processing.
Responsible for training the user and technical staff members on the Geac system, including reviewing and creating screens, tools, PDL, Report Writer, Retro Pays, Monitor, and User Called Routines (UCR’s).
State of Ohio, Columbus, OH
02/1999-07/1999
Contract
Environment: MVS, ISPF, JCL, COBOL, DB2, VSAM, GEAC, Project Mgmt
Worked on the customization and installation team for Geac DB2 Human Resources and Payroll system,
Developed several UCR’s used with Garnishments, Position Control, and Vacation in PAY020 and PAY040.
Created new screens, PDL, and Batch Transactions for interfaces to external systems and to create transactions fed into Pay020 to update additional Geac databases.
Developed external DB2 COBOL programs using imbedded SQL and calling Geac common routines.
Worked with users to identify custom code that related to specific government rules that had to be incorporated into the Geac system through extensive customization.
Baptist Hospital, Winston Salem, NC
11/1997-01/2000
Environment: Peoplesoft, MVS, ISPF, JCL, COBOL, VSAM, GEAC, SQR, People Tools, Project Technical Support for Geac Human Resources and Payroll system on an as needed basis for over two years.
Performed Yearend for both years until client converted to People Soft software.
Installed the Y2K system developed by Grace Technologies in November 1999.
Wrote all Conversion Programs from GEAC to PeopleSoft. This included the GEAC data extract for Payroll, HR and Benefits systems.
Rite-Aid Corporation, Harrisburg, PA
05/1998-09/1999
Contract
Environment: MVS, ISPF, JCL, COBOL, VSAM, GEAC, CICS
Wrote conversion programs for all GEAC/DBS files to an AS-400 application.
Provided support for the GEAC/DBS HR:M Payroll application for 40,000 employees.
Performed as Project Lead for a group with very little GEAC/DBS product experience.
Consulted with Managers and Directors to explain GEAC/DBS functionality to help the client better understands the problems and processes that were needed to stabilize the current system.
Responsible for maintaining external systems that were CICS DB2-based, and used as interfaces to the HR: M Payroll system.
Grace Consulting/Grace Technologies
05/1997-05/1998
Contract
Supported 10 Geac/DBS M: Series customers for support and enhancements.
Instructed customer personnel on Geac/DBS functionality and how to use the Geac/DBS tools.
Performed year-end processing for all assigned customers, on-site and remote.
Worked on the Y2K team to develop the Grace Y2K release for Geac/DBS Human Resources and Payroll systems.
Performed a conversion from Geac to Lawson for INOVA Health Systems and performed some of the data mapping.
Walt Disney World, Orlando, FL
03/1995-05/1997
Contract
Environment: MVS, ISPF, JCL, COBOL, VSAM, DB2, GEAC,PDL
Responsible for programming and analysis for the Geac/DBS HR:M software, Version 11:02:34 to11:10:36 system (VSAM), including modifications to existing systems, work requests, and the development of new systems utilizing the Geac/DBS tools (Millennium, SDT, and PDL).
Added additional Facts DataFile records and new screens as required by client.
Worked with Geac/DBS Multi-Mill and DBS General Ledger system, including installation of four update tapes (11:02:35, 11:02:36, 11:10:36, 11:10:37, and 11:10:38) and Year-end processing and W-2’s.
Provided on-call support for Payroll and Human Resources systems.
Created conversion extracts from Geac/DBS to the SAP software package and created consolidated tax reporting for both Geac/DBS and SAP systems. (Performed mostly via remote dial up, with 1 week every 2 months on-site.)
Installed Millennium 3.0 for VSAM Multi-Mill environment.
Belk Store Services
Contract
05/1994-05/1995
Environment: MVS, ISPF, JCL, COBOL, VSAM, DB2, GEAC,PDL
Developed, tested, and implemented the Geac/DBS HR:M Payroll and Human Resources system, using PDL, COBOL, and DB2
Assisted in the implementation of the GEAC Benefits module and wrote several Report Writer reports and COBOL DB2 programs for Benefits system.
Duke Energy
06/1981-01/1992
Applications Programmer (01/1992-05/1994)
Responsible for Programming Support for GEAC/DBS HR: M system, release 11.02.31, including Payroll Human Resources, and Benefits administration systems.
Application Control Analyst (10/1987-01/1992)
Responsible for supporting various IBM software packages. Supported CA-7, Network Data Mover, and maintained all Printers, Pagedefs, Formdefs, Fonts, etc.
Senior Operator (06/1981-10/1987)
Maintained and operated an IBM mainframe shop.
Contact this candidate