Data Analyst Sql Server

KEVIN GORMAN

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

IT professional with experience as a Technical Analyst and Consultant for mulƟple clients. Impacƞul professional with business skills across mulƟple business lines. Recognized for understanding data structures and Data mapping. Strong AnalyƟcal skills including business case development, requirements and data documentaƟon. Core competencies include:

Data AnalyƟcs CreaƟve Problem solving Waterfall and Agile Methodologies TroubleshooƟng Database Experience Requirements Analysis ETL Data Mapping Client/Stakeholder RelaƟons Full SLDC Experience Process Engineering Process Improvement Programming ReporƟng Tools EXPERIENCE

General Motors, Warren, MI 07/2015 – 06/2025

Business Analyst/Quality Chain Engineer – Engineering AnalyƟcs Focus Tools & Technologies: PostgreSQL, SQL Server, Power BI, SSRS, Hadoop, SQL, Oracle Data Modeler, DBeaver, VBA

Developed of a reporƟng soluƟon using PostgreSQL, PowerBI and Excel, reducing engineer status reporƟng effort up to 20 hours each month. Department savings were over $400,000. Applied data modeling techniques across a 70+ table schema and documented detailed requirements through one-on-one sessions with engineering SMEs. Integrated Excel, Access, PostgreSQL and Hadoop environments.

Created a business case and iniƟal 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 implementaƟon. Modeled in SQL Server.

Applied process improvement methodologies, achieving Six Sigma Green and Black Belt recogniƟon. Proctor Financial, Troy MI 01/2015 – 07/2015

Data Analyst II – ReporƟng AutomaƟon & Client-Focused SoluƟons Tools & Technologies: SQL Server, Advanced T-SQL, SSRS, SQL Server Management Studio (SSMS)

Automated data import and reporƟng processes in an SQL Server environment using advanced t-SQL scripƟng and stored procedures. Collaborated with department stakeholders to define and implement changes. Built development and tesƟng environments to ensure data accuracy and process reliability.

Designed and implemented a dynamic SSRS report that delivered customized data views for different clients, enhancing usability and relevance without needing program changes

Used SQL Server Management Studio (SSMS) proficiently for query development, job scheduling, performance tuning, and database object management. Summit Health (now Quest DiagnosƟcs) June 2012 – October 2014 Analyst/Programmer - Supported biometric data operaƟons Tools & Technologies: VBA, MS Access, SQL, Data Flow Diagramming, Dev/Test Environments, Data Modeling

Developed custom Data Entry Capture applicaƟons using VBA and MS Access for both U.S. and offshore teams, improving data quality and entry speed. Led user training and workflow opƟmizaƟon to ensure adopƟon and efficiency.

Integrated scanning soŌware with data entry systems through custom scripƟng and process redesign, resulƟng in a 2x increase in throughput.

Designed an automated a scheduling soluƟon for a naƟonal retailer’s flu shot clinics using VBA, reducing a previously manual 4-month effort (by 3–4 staff) to an automated 5-minute process.

Built a data-matching algorithm to reconcile 400,000+ consent forms with lab results feeds, replacing manual work with an automated soluƟon that was 5x faster and more accurate. KEVIN GORMAN *****-******@*******.*** PAGE 2

ADDITIONAL RELEVANT EXPERIENCE

GalaxESoluƟons, Detroit, MI

Programmer Analyst for a naƟonal drug store chain Performed data integraƟon and cross-plaƞorm extract and load operaƟons on a systems and data consolidaƟon project for CVS Pharmacy.

Developed a tool to cross reference AS400/RPG fields with mainframe (COBOL) structure equivalents.

Loaded data to a Teradata warehouse for Medicare reporƟng. Blue Cross Blue Shield of MI, Detroit, MI

Advanced Developer/Analyst

Supported Dental Claims, Mailing, Actuarial, Accounts Payable and Accounts Receivable departments.

Created User Requirements and Use Case documentaƟon for a Vision IntegraƟon project.

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

Streamlined a month end process for a Corporate ContribuƟons 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 Ɵme reporƟng 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 Managed projects for Ford’s producƟve and non-producƟve material transfers.

Built Use Cases and standard workflows for non-prod material billing system.

Helped Ford replace Dun & Bradstreet’s with PeopleSoŌ’s accounƟng soŌware. EDUCATION

MSA in InformaƟon Systems Management

Central Michigan University, Mount Pleasant, MI

Bachelor of Arts, BA in Environmental Studies with PoliƟcal Science and Sociology St. Lawrence University, Canton, NY

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 DocumentaƟon Systems & Plaƞorm IntegraƟon Dev Ops Change Management Test Case and Regression TesƟng Mythologies User Stories Screen Mapping Systems Porƞolio Management Languages: C#(.net) Python SQL/T-SQL VBA Access Excel COBOL PL/I ReporƟng: MS SQL ReporƟng Services (SSRS) Crystal Reports Power BI Minitab Databases: DB2 SQL Server MS Access PostgreSQL Hadoop Oracle Teradata IMS db DB UƟliƟes AnalyƟcal Tools: Visio ABC Flowcharter CASE Tools Oracle Data Designer/Process flow Data modeling packages RaƟonal Requisite Pro Excel IBM’s DOORS Smartsheet Data flow Process flow Swim Lane diagrams Mind Mapping

Contact this candidate