Glen Molinari

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

Oakland Township, MI. 48306

Home: 248-***-**** Cell: 248-***-**** Work: 313-***-****

Experience Summary

Over thirty years of data processing experience involving project leading, technical leading, coding, analysis, design, testing, documenting and implementation of application software for a wide variety of industries.

Extensive programming experience using:

Enterprise COBOL/COBOL II/COBOL, DB2, CICS, MS Access, Visual Basic, VSAM, OS/MVS JCL, Oracle, SAS, PL/1

Excellent business and analytical skills as well as strong written and oral communication abilities.

Education

-Informatica Advanced Performance and Tuning online training course, TrainOvation.com.

-Informatica PowerCenter Introduction and Basics online training course, TrainOvation.com.

-Structured Systems Analysis course, UTA, Dearborn, MI

-AFP class, IBM, Marietta, GA -Advanced SQL and Tuning for DB2 Applications course, Platinum Technology -CICS Computer Based Training course, Computer Task Group, Inc. -C Programming class, Front Range Community College, CO. -DB/DC Training course, IBM, Boulder, CO. Included IMS DB/DC concepts and programming techniques. -Structured Systems Analysis class, Computer Task Group, Inc. -REXX Programming class, Computer Task Group, Inc. -Easytrieve Computer Based Training course, Computer Task Group, Inc. -DB2/SQL Computer Based Training course, Computer Task Group, Inc. -CICS Programming class, Computer Task Group, Inc. -Diploma in Computer Programming, Chubb Institute, N.J. Intensive 525 hour computer programming course covering: Analysis, Program Design, Program Techniques, Machine code, Assembler/COBOL languages, OS/VS2 MVS JCL, data management utilities, VSAM, CMS/XEDIT, and TSO/ISPF.

-Computer Coursework, Kean College, N.J.

Earned 50 credits toward a degree in Math and Computer Science.

Hardware

IBM 30XX, IBM 43XX, IBM 370, IBM PS/2, IBM PC

Software

DB2, Oracle, SQL/DS, CICS, SAS, MVS JCL and utilities, VSAM, IMS, AFP, Excelerator, SMP/E, Expediter, VBomp, MS Access, Excel, Word, IDMS, TSO/ISPF, ISPF/DM, CMS/XEDIT, Roscoe, QMF, SPUFI, ISQL, Retain, Easytrieve, Endevor, Changeman, FTP, Toad, SQL Developer, SQL Server Management Studio, Informatica Analyst

Languages

COBOL, COBOL II, Enterprise COBOL, MF COBOL, Assembler, SQL, PL/1, REXX, C, Pascal, Clipper 5.01, dBase III+, Visual Basic, Vision

Operating Systems

MVS/370, MVS/XA, MVS/ESA, VM/SP, VM/ESA, MS-DOS, OS/2, Windows

Applications

EDI / X12, Corporate Banking (Global Cash Management, Electronic Payment Origination, Electronic Invoicing), Manufacturing (Prototype Build Tracking, Bill of Material, Quality Management, Material Pricing, Consolidated Purchasing, Inventory Management, Stock Status, Kanban), Education Tracking, Order Processing, Financial Reporting, Education Reporting, Resource Planning, Project Tracking, Labor Tracking, Project Management, Human Resource Management, Student Loan Management, Healthcare Management

Experience

Blue Cross Blue Shield of MI

Detroit, MI

September 2014 – Present

Blue Cross Blue Shield of MI: September 2014 - Present

As a Technical Lead and Sr. Programmer/Analyst for a major healthcare company, supported, maintained and enhanced the data warehouse system which was used for back-end reporting and analytics of monthly claims for hospitals and doctors as well as for plan membership. This is a large system that processes and loads millions of rows of data every month and is critical for user groups to be able to view claims, membership, provider and Medicare Advantage information. My role consisted of the design, development, testing, implementation and maintenance of programs and job streams for various projects. This also consisted of writing QMF and SPUFI queries to occasionally add or delete rows in the database, verify that the counts were correct after a modification and to perform in-depth research on claims or membership questions. In addition, as the primary subject matter expert of the data warehouse, was counted on to frequently answer user and other team member inquiries about the data, the process and flow of a particular line of business or the system itself and assisted in getting new employees up to speed in the environment. The programs are written in Enterprise COBOL and SAS, the data is stored in DB2 tables and the online data entry screens are written in CICS.

Computer Aid

Northville, MI

October 2007 – September 2014

Blue Cross Blue Shield of MI: October 2007 – September 2014

As a QA Consultant, was counted on to provide technical assistance and deliver projects on time and on budget. Verified and validated whether products or services met specified requirements. Implemented quality assurance objectives and processes, monitored, and evaluated testing results against the predetermined objectives and applied recommended actions for improvements. Was part of all phases of the QA process and interacted with all members of the project team. Worked on multiple programs/systems as a testing lead and on high complexity projects/issues across multiple development environments and enterprise-wide systems. Provided technical leadership and support (e.g., subject matter expertise) for the IT team. The primary focus was the validation of ETL (Extract, Transformation and Loading) projects that created new/enhanced existing subject areas within the BCBSM Enterprise Data Warehouse as well as validation of the data extraction process from the EDW.

As a Technical Lead and Sr. Data Analyst, pulled Corporate Membership, Risk Adjusted Membership and Claims from mainframe DB2 tables and Oracle databases to pull extensive Member and Claims detail. Analyzed multiple mainframe jobs to determine how various data elements were populated and worked with the Informatica team so those fields were populated correctly on the Oracle data warehouse for Corporate Membership sales and reporting. Used SAS to automate the data pulls and control the jobs to extract and load the data to the tables in our Sandbox. Created additional jobs to pull data files and load them as Oracle tables into our Sandbox as well. Used Toad, SQL Developer, SQL Server and MS Access to create, test and enhance various queries and Informatica Analyst to profile various columns for data quality purposes. Created various reports using WebFocus for Corporate Membership reporting. Also compared SQL results to various mainframe IQ files and DB2 databases for validation purposes.

Resource Technologies

Troy, MI

January 2003 – October 2007

Daimler Chrysler: January 2003 – October 2007

As a Project Leader - Sr. Programmer/Analyst for a major automotive company, prioritized necessary maintenance tasks within engineering for the new Integrated Prototype Test and Build Solution. This consisted of scheduling and leading user meetings with managers of the various user groups to determine which tasks were most critical to the organization. For the Vehicle Build Management System module within IPTBS, lead the project through its entire lifecycle from the initial gathering of user requirements and creating detailed technical specifications all the way through testing, implementation and production maintenance. In addition, worked with internal customers to organize the release schedule by determining which modules to incorporate into production and what the timing for those modules would be. Researched existing systems and the associated programs to help keep Vehicle Engineering Operations under their allotted budget, which was reduced from the prior year. This consisted of delegating some of the changes and modifying some programs to better process the cross charging of stock room part costs to the correct departments for engineering vehicle builds. The programs were written in PL/1 and COBOL II, the data was stored in DB2 tables and the online data entry screens were written in CICS. This also consisted of writing QMF queries to calculate and track cross charged part quantities and costs. Lead in the design, development, testing, implementation and maintenance of a vehicle build system which tracked build counts, build locations and prototype build types within engineering along with all the various FTP feeds to financial and planning systems. In addition, created necessary user reports and extracts from this system upon request. This system was written in Access and Visual Basic.

Information Systems Consultants

Troy, MI

May 2002 – December 2002

Mastercard International: May 2002 – December 2002

As a Sr. Programmer/Analyst for a major credit card company, assisted in the design, development, testing and implementation of the conversion to a new switch processor. This consisted of handling the conversion of the incoming data from the Tandem to the new MVS format. This also included the creation of the master settlement file along with various report and extract programs. All programs were written in COBOL II and the data was stored in VSAM files.

Tek Systems

Southfield, MI

September 1996 – April 2002

Ford Credit: January 2002 – April 2002

As a Sr. Programmer/Analyst for a major automotive credit company, worked on various financial systems. This included assisting in the writing and maintaining of a system to calculate the residual and rate subvention on leased cars which helped figure out tax deductions for the company. All programs were written in COBOL II and the data was stored in VSAM files.

K-Mart: March 2001 - December 2001

As a Sr. Programmer/Analyst for an international retail chain, was part of a team that designed, developed, tested and implemented the Guest in Stock report. This was a corporate report that was viewed by the company CEO. The data used for the calculations was extracted from DB2 and IMS databases, all programs were written in COBOL II and Vision, and the online screen to kick off the report was written in CICS. Worked on various projects for replenishment systems including a new process to handle product flow through. All programs were written in COBOL II, the data was stored in DB2 and IMS tables and the online user interface was written in CICS.

Lear Corporation: March 2000 - March 2001

As a Sr. Programmer/Analyst for a major automotive supplier, was involved in the design, development and testing of the One Bill of Material system enhancement for Wire Systems. This included developing new online and batch programs and modifying existing programs that were written in COBOL II, the data was stored in DB2 tables and the user interface was written in CICS. Worked on a project to prevent invoice numbers from rolling over to zero in a single year. Developed a data entry screen in COBOL II which used CICS as the user interface and DB2 tables to store the data to submit an online job to generate the daily production report which replaced the scheduled batch job.

Bank One: September 1996 – March 2000

As a Sr. Programmer/Analyst for a major global bank, helped design, code, test and implement batch and online programs for financial EDI systems. The programs were written in COBOL II, the data was stored in VSAM files and CICS was used to control the batch processes as well as for the user interface. These systems used FTP to read in the X12 EDI data from the other institution, CICS to kick off and control the data that was read in, and COBOL II programs to translate the EDI segments and process and store the data in VSAM files. Enhanced, modified and supported the Electronic Payment Origination System and the Electronic Invoicing System for Global Cash Management. Modified, tested and documented the YR2K changes that were necessary for the certification of both of those systems. Participated in a project to convert all COBOL programs to COBOL II. Made modifications to existing COBOL II programs and JCL job streams to add new customers and convert existing EDI customers during merger turnover between two large financial institutions. Designed and coded COBOL II screens using CICS as the user interface to maintain and browse DB2 tables that tracked incoming wires.

United Technologies Automotive

Dearborn, MI

January 1993 – September 1996

As a Sr. Programmer/Analyst, was involved in the design, development and testing of the new One Bill of Material system for Wire Systems. This involved replacing the old system, which was written in COBOL and VBOMP to store the data, with COBOL II, DB2 to store the data and CICS for the user interface. Developed a system to create expediting reports using COBOL II programs that extracted data stored in DB2 tables by initiating batch jobs which were submitted online through CICS. Delegated work needed and managed the Online Releasing and Material Pricing systems which were written in COBOL, II the data was stored in DB2 tables and online user interface was CICS. Designed to exact specifications and tested company documents in AFP, which were vital to meet the requirements of our customers. Developed, enhanced and maintained the other manufacturing systems including Quality Management, Consolidated Purchasing, Warehousing, Kanban and Stock Status. All of these systems were written in COBOL II, developed with mainframe or MF COBOL, the data was stored in DB2 tables and CICS was used for the user interface.

Computer Task Group

Denver, CO/Southfield, MI

February 1991 - July, 1993

State of Colorado: November 1992 – December 1992

Performed modifications and testing on a CICS online student loan escrow system for a state student loan program. All modules were written in COBOL and all screen data was retrieved from VSAM files. Modified existing jobs in OS/JCL to translate, compile, and linkedit the programs.

Minnesota Based Bank: July 1992 – November 1992

Developed CICS online programs within a large banking human resource inquiry subsystem. All screen data was retrieved from DB2 tables and manipulated by COBOL II modules. Prepared BMS maps, coded and tested all assigned modules. Modified existing jobs in JCL to translate, precompile, compile, linkedit, and bind the programs. Utilized SPUFI to test DB2 queries online.

IBM: January 1992 – July 1992

For a major hardware and software manufacturer, performed modifications and enhancements on a work and resource management system consisting of resource planning, labor tracking, project management, and administrative functions. The system contained approximately 400 REXX and PL/1 programs, 250 screens, and 800 help panels. The screens and help panels were written in ISPF/DM and the data was retrieved from SQL/DS tables. All work was designed to meet SAA, CUA, and NLS standards.

Also generated last minute reports for department managers in QMF based on SQL/DS queries. Utilized ISQL to test SQL/DS queries online.

Computer Task Group: May 1991 – September 1991

For regional management of a consulting firm, developed programs in Clipper 5.01 and Pascal for an education tracking system. The system was used to track employee survey answers to regional classes. This was a menu driven system consisting of updating, adding, deleting, and printing the databases. Summary reports were dynamically generated based on user selected criteria.

IBM: February 1991 – December 1991

As a representative for a major computer hardware and software manufacturer, was responsible for providing solutions for software code defects via direct telephone contact with customers. Some of the 180 products supported include the following: DFP, CICS, COBOL, PL/1, FORTRAN, DB2, IMS, QMF, SMP/E, EREP, DFHSM, RACF, DF/DSS, JES2, JES3 and the MVS operating system. As Level I support, provided customers with PTF fixes for known problems utilizing RETAIN, or routed problem records to the appropriate Level 2 representative for continued problem source identification. Also provided customers with written documentation for assistance with product and maintenance installation. Took on additional responsibilities of training and assisting new staff and helped develop and maintain a database in dBase III+ for monitoring feedback on individual problem records. Also created QMF reports based on DB2 queries for employee statistics and call volume.

Contact this candidate