Technical/Data Analyst

KEVIN GORMAN

Lake Orion, MI ***** 248-***-**** *****-******@*******.*** linkedin.com/in/kevin-gorman-analyst

TECHNICAL DATA ANALYST

Technical Data Analyst with experiences with data analytics, data structures and process improvement. Business experiences with Medical Claims, Engineering, Finance and Education environments. Strong Analytical skills including business requirements documentation, data modeling and process flow documentation. Core competencies include:

Data Analytics Creative Problem solving Waterfall and Agile Methodologies Troubleshooting

Database Experience ETL Cross Functional Leadership Data Analytics Reporting

Full SLDC Experience Process Engineering/Re-Engineering Programming

TECHNICAL SKILLS

Methodologies: Data Modeling Database Design Data Flow Diagrams ETL Systems Gap Analysis Business Case Development System Life Cycle Methodologies Business Process Re-engineering Business Requirements Documentation Systems & Platform Integration Dev Ops Change Management Test Case and Regression Testing Mythologies User Stories Screen Mapping Systems Portfolio Management

Programming: C# Python SQL/T-SQL VBA Access Excel COBOL PL/I JCL

Reporting: MS SQL Reporting Services (SSRS) Crystal Reports Power BI Minitab Excel

Databases: DB2 SQL Server MS Access PostgreSQL Hadoop Oracle Teradata IMS db XBase

Analytical Tools: Visio ABC Flowcharter CASE Tools Oracle Data Designer/Process flow Data modeling packages Rational Requisite Pro Excel IBM’s DOORS Smartsheet Data flow Process flow Swim Lane diagrams Mind Mapping

EXPERIENCE

General Motors, Warren, MI July 2015 – June 2025

Business Analyst/Quality Chain Engineer – Engineering Analytics Focus

Was brought into GM to assist with a reporting mechanism which after development was estimated to save the department over $400,000 a year. Stayed with GM for 10 years.

Developed a database and reporting system that reduced engineer status reporting effort up to 20 hours each month. Department savings were over $400,000. Migrated database from SQL Server to PostgreSQL

Created a business case and initial system design for a graphics database for GM’s Design Studio for driver display indicators. Conducted process analysis, risk assessment (reducing Federal liability exposure), and presented data models/UI mockups and requirements to IT for implementation.

Applied process improvement methodologies, achieving Six Sigma Green and Black Belt recognition.

Proctor Financial, Troy MI 01/2015 – 07/2015

Data Analyst II – Reporting Automation & Client-Focused Solutions

Automated data import and reporting processes in an SQL Server environment (t-SQL), collaborating with department stakeholders to define and implement reporting changes. Built development and testing environments to ensure data accuracy and system integrity.

Designed and implemented a dynamic SSRS report that delivered customized data views for different client, enhancing usability and relevance.

Summit Health (now Quest Diagnostics) June 2012 – Oct 2014

Analyst/Programmer - Supported biometric data operations

Developed Data Entry Capture systems for both US and offshore data entry operations. Led user training and workflow optimization to improve data quality and speed.

Collaborated with users to Integrate scanning software with data entry systems that doubled throughput.

Designed an automated scheduling system for a national retailer’s flu shot clinics, reducing a 4-month manual task (requiring 3–4 people) to a 5-minute automated process.

Built an automated matching process for 400,000+ consent forms and lab results, achieving higher accuracy and 5x faster throughput compared to existing processing.

ADDITIONAL RELEVANT EXPERIENCES

GalaxESolutions, Detroit, MI

Programmer Analyst for a national drug store chain

Performed data integration and cross-platform extract and load operations on a systems and data consolidation project for CVS Pharmacy.

Helped to consolidate 3 major prescription claims systems focusing on common eligibility functions.

Loaded data to a Teradata warehouse for Medicare reporting.

Blue Cross Blue Shield of MI, Detroit, MI

Advanced Developer/Analyst

Summary: Functioned as a combination of analyst and developer Supporting Finance, Accounting, Actuarial and Dental Claims Systems. Helped to bring in consultants to help BCBSM save millions in the mailing space.

Documented $40 million plus in savings in the Mailing Area. Led to a significant modernization project.

Streamlined a month end process for a Corporate Contributions process from 3 weeks to 3 days.

Supported an Actuarial Services Refund system for 6 years that returned over $200 million a year to various BCBSM groups for overpayments.

Maintained a time reporting system for Hourly Employees. Documented business processes and flows for system replacement.

Great Lakes Technology Group (Ford), Dearborn MI

Lead Business Analyst – Financial Systems Unit at Ford Motor Company

Consultant to Ford Motor Company's productive and non-productive material systems and services.

Bridged business and technical teams – Served as liaison between financial users (including international teams) and IT, defining requirements, documenting processes, and creating user/technical documentation.

Improved system reliability – Analyzed and resolved issues in batch cycle processing, leading to multiple bug fixes and improved operational stability.

EDUCATION

MSA in Information Systems Management

Central Michigan University, Mount Pleasant, MI

Certificate in COBOL Programming

Computer Processing Institute, Woburn, MA

Bachelor of Arts, BA in Environmental Studies with Political Science and Sociology

St. Lawrence University, Canton, NY

Contact this candidate