Candidates About

Raymond L. Heilman

Objective

As a developer and data analyst in a variety of industries including heavy equipment, healthcare, and national defense systems I have mined in large datasets in SQL to deliver business intelligence to managers in interactive reports via office suite tools that allow them to make informed decisions.  As a software trainer, specializing in databases and spreadsheets, I have used plain language to explain technical concepts to end users giving them hooks on which to securely hang their newfound knowledge.  I am seeking a position where I can use my experience to provide understandable data solutions for clients, both internal and external.

Experience

Consultant – TEKsystems

February 2017 – January 2018

Process Analyst - Nucor Steel Gallatin:

·         Talked with internal customers concerning their needs through business analysis of help desk requests

·         Met with internal department customers to prioritize help desk requests

·         Queried underlying data to define the issues for process requirements

·         Analyzed the necessary resources and fully document requirements for development resources

·         Created reports and report specifications for internal customers and development resources

·         Facilitated business systems testing and training with users

Technical Environment: T/SQL, PL/SQL, Microsoft Excel, Visio, Order To Cash (proprietary software), Carrier Point OMSI

Senior Consultant – Integrated Information Systems, Inc.

July 2016 – February 2017

Senior Consultant:

·         Captured periodic snapshots of transactional data to Data Warehouse using stored procedures

·         Created reports from queries into Data Warehouse for use in IMI, a cloud hosted ERP application

Technical Environment: T/SQL, Microsoft Excel

Software Developer/Data Analyst – Integrated Information Systems, Inc.

April 2005 – June 2016

Software Developer – Raytheon Missile Systems:

·         Integral development team member for proprietary IMI ERP system, both client hosted and cloud hosted versions

·         Captured outside data using ODBC connections, DTS/SSIS for loading into MS SQL Server 2005/2008/2012

·         Created and maintained analysis cubes in Analysis Services/SSAS

·         Captured periodic snapshots of transactional data to Data Warehouse using stored procedures

·         Created key reports from queries into Data Warehouse for use in IMI ERP systems

·         Go-to team member for T/SQL assistance

Data Analyst – Raytheon Missile Systems:

·         Performed data analysis for Supply Chain (on time arrival of materials), Production (efficiency, realization), Contracts (EAC, budgetary analysis), and Finance

·         Created ad hoc queries and reports for specific analysis requests from client

ETL – Raytheon Missile Systems:

·         Migration team member for a complex year-long conversion of client data from SQL Server to the headquarters SAP PRISM installation

·         Developed, created and tested stored procedures for extraction to text files

·         Scrubbed data and reported outliers resulting in 99.97% accuracy

Technical Environment: T/SQL, DTS/SSIS, Analysis Services/SSAS, Microsoft Excel, Tableau

Software Developer/Data Analyst - Myers and Stauffer LC

November 2000 – February 2005

Software Developer:

·         Development team member for proprietary software to set compensation rates for nursing facilities and hospitals

·         Generated monthly reports to facilities participating in the Kentucky Medicaid program

Data Analyst:

·         Captured data from Oracle PL/SQL extracts, MS Excel spreadsheets, and OCR from documents for loading into MS SQL Server databases

·         Performed data analysis to detect fraudulent service provider claims based on separately charging items that, by regulations, should be bundled

·         Submitted results to the Kentucky Medicaid department for reimbursement

Technical Environment: T/SQL, PL/SQL, Visual FoxPro

Software Developer - Bradbury and Associates, Inc.

April 2000 – September 2000

Software Developer:

·         Development team member for proprietary MPM software that tracks production and maintenance costs of operating coal mining equipment

Technical Environment: Visual FoxPro

Senior Trainer/Software Developer/Partner – Computer Training Solutions, Inc.

January 1987 – March 2000

Software Developer:

·         Development team member for proprietary Monolith student tracking software application

·         Tracked and charted student registration and attendance metrics

·         Produced training completion certificates for verification of continuing education credits

Senior Trainer:

·         Developed key training materials for beginning, intermediate, and advanced level software classes

·         Conducted beginning, intermediate, and advanced level software training sessions

Technical Environment: Visual FoxPro, Microsoft Access, Microsoft Office

Education

Eastern Kentucky University

Bachelor’s Degree, Computer Science and Mathematics

Fall 1978 – Fall 1982