Microsoft Office Analyst
Resume:
GLENN P. WILLIAMS
Apt F
Elk Grove Village. IL 60007
*******@*******.***
j
Hardware:
IBM30XX, IBM370, IBM PC, SERIES I, HONEYWELL DPS8
Operating Systems:
OS/MVS, MVS/XA, EDX, UNIX, WINDOWS NT, XP
IBM Tools and Software:
ABENDAID,FILEAID,PANVALET, CICS,QMF,CLIST,IMSDB/DC,ROSCOE,
JCL,SPUFI, DB2,LIBRARIAN,TSO/SPF,
EZTRIEVE,MICRO FOCUS CICS,VSAM, ENDEVOR, RACF
Server Side Tools:
MICRO FOCUS CICS, ORACLE, UNIX, CRYSTAL REPORTS,VISUAL BASIC
Package Software:
HEALTHQUEST, MICROSOFT OFFICE SUITE
January 2017 to September 2017 – American Airlines – Tempe AZ
QA testing lead and developer in converting American Airlines credit card processing files from FTP to sFTP. Included in the effort were PGP Encryption and AES Encryption upgrades. This project involved both internal and external partners during testing. Communication and coordination were essential in successful completion.
Tools used: sFTP, Rexx, JCL, and IBM’s suite of development tools.
September 2015 to June 2016 – Boeing Aircraft –Seattle WA.
Created program specifications for developers to code and create the new CIMS – Composite Information Management System. Duties have included spec writing and UAT testing. Also please refer to May 2014 to December 2014 – Boeing Aircraft –Seattle WA.
December 2014 to August 2015 - Paccar Corporation – Renton WA
Developer assigned to a team tasked with the responsibility of converting COBOL EZTRIEVE, and TELON modules to Enterprise Cobol using the zOS operating system. In the case of the EZTRIEVE AND TELON modules the task is to re-write them entirely in COBOL with the stated management goal of improving performance.
The standard suite of IBM development tools is used in this effort.
May 2014 to December 2014 – Boeing Aircraft –Seattle WA.
Analyst assigned to a team charged with the responsibility of reverse engineering the Composite Information Management System (CIMS) written in COBOL using DB2 and Dialog Manager using the AGILE development methodology . In short, the team analyzed over 200 hundred programs to identify the business rules for each. Then documented those rules so that they could be used as a basis for writing program specifications for a new system to be written in C# on a new platform.
October 2012 to July 2013 - Ford Motor Credit
Analyst assigned to the EDW reporting team. Duties included the extraction, transformation and
loading of data from business DB2 tables to the EDW reporting team Teradata databases.
Technical mainframe skill set for this effort includes: TSO/MVS, JCL, COBOL/DB2/MVS, and Teradata SQL Assistant.
January 2011 to October 2012 – Blue Cross Blue Shield of Michigan – Detroit, MI
Analyst assigned to BCBSM’s CDH support maintenance team. Duties include support of the Blue Cross Blue Shield of Michigan NASCO Claims Systems. Included are the following responsibilities:
GLENN P. WILLIAMS
PAGE 2
SER/CSR development and execution
Working knowledge of Change Manager/CSR financial tool.
Working knowledge of MOS claims processes.
Advanced work experience with MS Excel, Access, and Visio
Proven ability to work independently, with team lead or team members
Working knowledge of NASCO’s HIQK transaction
Working knowledge of NASCO’s Project Data Manager (PDM)
Technical mainframe skill set for this effort includes: TSO/MVS, JCL, COBOL/DB2/MVS, Fileaid, and Endevor.
Responsible for requirements and functional architecture analysis.
Involved in testing, training and implementation of applications.
Formulated and defined system scope and objectives based on user needs and thorough understanding of business processes.
Worked with internal business groups on process improvement projects designed to improve business results.
Provided guidance concerning business implications of application development projects.
June 2007 to December 2010 – Blue Cross Blue Shield of Michigan – Detroit MI
Analyst assigned to Medicare Advantage Base Support. As its name implies, this is an ongoing effort to support the business of Medicare Advantage. Included are applications dedicated to both Membership & Billing, Pharmacy and Claims as well as a variety of third party interfaces. Software tools used in this effort include COBOL 390, IMS DB, DB2, and Microsoft Office Suite.
February 2006 to June 2007 – Blue Cross Blue Shield of Michigan
Analyst assigned to the Medicare Advantage Subsidy project. Essentially a data mining operation, this effort determined subscriber and group eligibility for subsidy payments from Medicare. To do this, subscriber membership and claims information was retrieved from various BCBSM data stores. This data was then packaged and sent to Medicare for evaluation and approval. Software tools used in this effort include COBOL 390, IMS DB, DB2, and Microsoft Office Suite
April 2005 to February 2006 – Blue Cross Blue Shield of Michigan – Detroit MI
Analyst assigned to the Flexible Blue project – a new product offered by the insurer featuring high deductibles in return for lower monthly premiums. The primary focus of this project was to integrate drug claims into the product. To that end, duties included identifying groups and membership that have the eligible drug benefit, communicating that information to partnered vendors administrating the plan and processing and storing claim information. Software tools
GLENN P. WILLIAMS
PAGE 3
used in this effort include COBOL 390, IMS DB/DC, DB2, and Microsoft Office Suite
March 2004 to April 2005 - Blue Cross Blue Shield of Michigan – Detroit MI
Analyst assigned to the Social Security Elimination project. An effort designed to replace the SSN as the subscribers contract ID with a deidentified number throughout the system. Duties include the identification of all data stores housing the contract Id and all application programs accessing those stores. Once identified, the appropriate design changes are made, coded, tested and implemented.
A second project within SSN Elimination is the installation of a data access layer in application programs currently using IMS or DB2 database calls. Duties in this area include identification of data access applications candidates, as well as the design, coding, testing and implementation of the common routines to replace the database calls.
November 2002 to October 2003 – University of Michigan Health System – Ann Arbor, MI
Involved in the HIPAA compliance upgrade of the Blue Cross ACCESS system. Responsibilities include all CICS applications. These programs provide for online real-time claims editing and as a consequence of HIPAA require considerable refitting.
November 2001 to October 2002 – University of Michigan Health System – Ann Arbor, MI
Converted a data extract and reporting system written in FOCUS to COBOL II, ORACLE, UNIX and CRYSTAL REPORTS. The data extract is submitted to the University Hospital Consortium for
Purposes of caseload evaluation and comparison. The reporting system allows management to
evaluate the data and correct errors before submission.
October 2000 to October 2001 – University of Michigan Health System – Ann Arbor, MI
Assisted in a new development effort in the Admitting and Business Services department. The Workflow system that tracks an inpatient from booking to Discharge insuring all the various business tasks required during a patient stay are completed. Responsibilities include the development of management reports and business forms using Crystal Reports 8.0 and Oracle 8.16.
Also responsible for the support of the Registration Workflow system – an automated paperless process that replaced the Insurance Verification departments’ mainframe exception reporting system. Duties primarily include resolving data and/or scheduling issues between the Oracle database and the mainframe.
GLENN P. WILLIAMS
PAGE 4
June 1998 to October 2000 – University of Michigan Health System – Ann Arbor MI
Supported the hospitals Insurance Verification systems. Duties in this area included maintenance of
Existing COBOL and PLI batch applications as well as the development of new applications in both
Batch and CICS environments. Acted as both analyst and programmer in these efforts working
Directly with the client to solve problems and improve business processes.
February 1998 to June 1998 – University of Michigan – Ann Arbor, MI
Y2K modifications to mainframe legacy systems. Duties included coding, testing and debugging
Of mainframe COBOL and PLI applications in preparation for the Year 2000 changeover.
June 1996 to February 1998 - Technical Consultant on assignment at BCBSM – Detroit MI
Responsible for design and development of mainframe applications for the IRIS project (Inquiry Response Information System). Duties have included: development of system requirements, and specifications for systems and program design. Acted as a focal point for all questions regarding data retrieval from the mainframe. Provided direction to newer members of programming staff.
Sept. 1993 to June 1996 - Lead Programmer/Analyst on assignment at Chrysler Corporation – Detroit, MI
Designed, developed and maintained various systems within Chrysler Service Contracts Division. Provided direction to junior members of staff. Interacted with MIS staff and end users to develop database designs, program specifications, test plans and system implementation plans.
GLENN P. WILLIAMS
PAGE 5
Sept . 1992 to Sept. 1993 - Programmer/Analyst on assignment at HCIA – Ann Arbor, MI
Designed, coded and tested a statistics management system. Developed a series of CICS applications that assign DRG values and weights, retrieve and update diagnosis and procedure code information.
Aug. 1991 to Aug. 1992 - Programmer/Analyst on assignment at U of M Hospital – Ann Arbor, MI
Member of the MEDICPAC Patient Accounting and Medical Records Project Team. Developed several sub-modules including a CICS application to update patient files. Wrote conversion programs to take data from IMS to VSAM, and interface programs to feed into MEDIPAC.
April 1991 to July 1991 - Programmer/Analyst on assignment at Mercy Information Systems – Farmington Hills, MI
Developed batch reporting programs as satellite functions of MEDIPAC Patient Management. Duties included file design, program development and system implementation. Developed an Accounts Receivable Tracking System to access accounts receivable and patient data.
July 1989 to March 1991 - Programmer/Analyst on assignment at Chrysler Corporation – Detroit, MI
Member of the Dealer Capital Loan Project Team. Responsible for screen design, new program development, testing, implementation and user training. Assisted in the development of
Automated Inventory Management System. Duties included user interviews to determine system requirements, specification, program and system development, acceptance testing and user training.
April 1989 to July 1989 - Programmer/Analyst on assignment at Mercy Information Systems, Farmington Hills, MI
Enhanced and maintained CICS and batch systems for Catherine McAuley Health Center.
Responsibilities included user liaison activities to establish system requirements, designing,
coding and implementation.
October 1988 to April 1989 - Programmer/Analyst on assignment at EDS – Flint, MI
Supported and maintained various engineering systems within the Service Parts Organization. Developed and tested code within an IBM/DB environment.
July 1988 to October1988 - Programmer/Analyst on assignment at Highland Super-Stores _ Plymouth, MI
Designed and coded service applications utilizing DB2, CICS and COBOL
GLENN P. WILLIAMS
PAGE 6
March 1988 to July 1988 - Programmer/Analyst on assignment at Ford Motor Company – Dearborn, MI
Supported and maintained applications within Finance and Staff Systems.
July 1987 to March 1988 - Programmer/Analyst on assignment at CPHA – Ann Arbor, MI
Supported the Cost Quality Management System. This system combined clinical and financial data from multiple health care institutions to provide analysis of performance for hospitals within a specific peer group. Duties included maintenance and support, re-design of reformatting programs, CICS screen design, coding and implementation. Worked with users to resolve hardware and software problems.
esigned, developed and maintained various systems within Chrysler Service Contracts Division. Provided direction to junior members of staff. Interacted with MIS staff and end users to develop database designs, program specifications, test plans and system implementation plans.
March 1987 - July 1987 - Programmer/Analyst on assignment at American Motors
Corporation – Detroit, MI
Developed interfaces between vehicle history and accounting systems for vehicle holdback,
company car acquisition, and floor plan adjustment fund files. Duties included analysis of system
requirements, coding, testing and debugging.
Nov. 1986 to March 1987 - Programmer/Analyst on assignment at CPHA – Ann Arbor, MI
Assisted in developing Statistical Reporting System for the Department of Defense to evaluate the quality of health care administered in the U.S. Military. Duties included system design, coding, unit and system testing, and system documentation.
May 1986 to Nov. 1986 - Programmer/Analyst on assignment at Chrysler Corporation – Detroit, MI
Developed and maintained incentive programs for fleet buyers.
Sept. 1984 to May 1986 - Programmer/Analyst on assignment at Henry Ford Hospital – Troy, MI
Assisted in procedure code expansion project. Project required analysis and/or modification of virtually every program in the Accounts Receivable system. Major updates made to admitting transactions (DRG’s). Developed the Hospital Census Reporting System for the administrative staff. Provided maintenance and support for various production systems. Participated in the installation, testing and implementation of MEDTEC Professional Services Billing System. Designed and coded an interface between MEDTEC and the General Ledger system.
Education
1966 – Northern Michigan University – Marquette, MI
1967 – Oakland Community College – Orchard Lake MI
1973 – Sierra College – Rocklin CA
1980 – Control Data Institute Southfield MI
1981 – Cleary College, Ypsilanti MI
References Available Upon Request
Contact this candidate