Business Analyst Data Engineer

Keith W. Ahrens

Email: ************@*****.***

Phone: 203-***-****

Professional Summary

Business Analyst and Data Engineer with over 15 years of experience in financial services, healthcare, and manufacturing. Skilled in requirements gathering, ERP and CRM systems, process modeling, stakeholder engagement, and data analysis. Proven success in Agile and Waterfall environments, translating business needs into technical solutions using SQL, ETL tools, and BI platforms. Currently pursuing Microsoft Azure and Generative AI certifications.

Core Competencies

Requirements Gathering and Documentation

Agile and Waterfall Project Management, Scrum Master, DEVOPS, SDLC, CI/CS

SAP, SAGE 100, SAGE 300,

Data Modeling, ETL Development, Data Science

SQL, T-SQL, PL/SQL, Python, C#, VB.net, COBOL

SSIS, SSRS, SSAS, Tableau, Power BI

Azure DevOps, Jira, MS Project

Stakeholder Engagement and UAT

KPI Tracking and Process Improvement

Oracle, SQL Server, MySQL, NoSQL

Professional Experience

U.S. Bank – Remote

Consultant Data Engineer / Business Analyst

November 2022 – December 2024

Gathered business requirements and conducted UAT and JAD sessions

Authored RTM, FRS, and Swimlane documentation

Managed Agile sprint planning using Azure DevOps and Jira

Developed and maintained ETL pipelines using SSIS, SQL Server, Python, and .NET

Supported data vault integrations and disaster recovery processes

onsemi Technology – East Fishkill, NY

Data Engineer / Business Analyst

May 2022 – October 2022

Migrated Oracle ERP data to OCI Cloud and Oracle OAC

Created dashboards and reporting flows for manufacturing operations

Documented legacy system transitions and managed IBM MQ file transfers

Berkley Insurance – Stamford, CT

Data Warehouse Engineer / Analyst

January 2022 – March 2022

Developed insurance planning data models and ETL packages

Streamlined legacy code and supported business reporting needs

UnitedHealth Group – Optum IT – Remote

Data Engineer / Business Analyst

September 2018 – December 2021

Conducted business analysis for financial planning systems

Created dashboards and reports using Tableau and Power BI

Managed Agile and Waterfall projects and collaborated with stakeholders

Automated ETL deployments using IBM Workload Scheduler

Sikorsky-Lockheed Martin – Stratford, CT

Consultant Business Systems Analyst

November 2016 – May 2018

Gathered requirements and developed tools for performance tracking

Created dashboards and KPIs for aircraft assembly efficiency

Integrated data from SAP, SAS, Oracle, and SQL Server

Northwell Health – Lake Success, NY

Business Analyst / Web Developer / Project Manager

June 2014 – April 2016

Defined data and reporting needs for HR and payroll systems

Developed web applications and automated workflows

Managed CLM application data and integrated SAS reporting

Guaranteed Returns – Holbrook, NY

Business Analyst / IT Director / Project Manager

March 2009 – May 2013

Led modernization of reporting and data access systems

Managed SharePoint migration, SAGE 100 and SAGE 300 ERP and extranet customer portal development

Collaborated with vendors and internal teams to align technical solutions

Additional roles available upon request (Oracle DBA, VBA Programmer, Report Writer)

Education and Certifications

American InterContinental University – Schaumburg, IL

Bachelor of Science in Information Technology – Magna Cum Laude

Focus: Database Optimization, ASP.Net, C#, Java, Systems Management

Certifications and Training

Microsoft Azure (in progress) – Completed courses via Optum Tech

Generative AI with Python (in progress)

The Chubb Institute – Business and Internet Programming

Contact this candidate