ALLEN J. BROADY
Winston-Salem,NC
Summary
Results-driven Data Engineer with 5+ years designing, building, and optimizing enterprise data pipelines, ETL processes, and analytics solutions across healthcare, manufacturing, retail, and research industries. Proven expertise in SQL Server, Python, SSIS, and cloud-based data tools, with strong skills in data modeling, database administration, automation, and business intelligence reporting. Adept at translating business needs into scalable, high-performance data solutions.
Overview
11
11
years of professional experience
1
1
Certification
Work History
IT Engineer
P&A Group
Roxboro, NC
05.2021 - Current
- Designed and maintained SQL Server databases and ETL pipelines to integrate vendor, customer, and internal systems, reducing data refresh times by 70%.
- Automated reporting processes using Python, PowerShell, and SSRS, eliminating 40% of manual workload.
- Managed database performance tuning, indexing, and security for high-availability systems.
- Developed and deployed Power BI dashboards to track operational KPIs and support decision-making.
- Collaborated cross-functionally to gather requirements and build scalable data solutions.
Application Developer
Medcost
Winston-Salem, NC
03.2020 - 05.2021
- Built and maintained SSIS data integration workflows to load provider and claim data into SQL Server.
- Developed C#, VB.NET, and SQL applications for healthcare reporting, including billing reconciliation and member demographics.
- Created QA test environments for ETL processes prior to production deployment.
- Designed SSRS reports to deliver analytics to payer and provider groups, reducing delivery times from days to hours.
Senior Applications Developer
AW North Carolina
Durham, NC
08.2019 - 03.2020
- Developed ETL processes in SSIS and SQL Server for manufacturing, logistics, and finance departments.
- Created Tableau dashboards and SSRS reports to visualize production metrics and supply chain KPIs.
- Designed a logistics optimization algorithm projected to save $50K annually in transportation costs.
Lead Data Engineer / Developer (Analytics)
Biogen
RTP, NC
02.2019 - 08.2019
- Engineered automation scripts for bioassay experiments, integrating VBA, C++, and SQL-based pipelines.
- Developed Tableau dashboards and statistical models (R, SAS JMP) to analyze experimental results.
- Migrated legacy VB applications to modern frameworks, improving maintainability and performance.
Business Analyst / BI Developer
HanesBrands
Winston-Salem, NC
11.2018 - 02.2019
- Built aggregate reporting processes in SQL Server and Power Query to improve forecast accuracy.
- Designed SSIS ETL jobs to cleanse and integrate sales and inventory data.
- Developed event-driven C++ and SQL code for automated data import/export workflows.
Data Analyst / Project Coordinator
Advance Auto Parts
Raleigh, NC
07.2017 - 02.2018
- Created Power BI and Tableau dashboards for vendor reporting, improving client satisfaction scores by 15%.
- Developed pricing and inventory forecasting models using SPSS Modeler and R.
- Managed multiple retail analytics projects, coordinating cross-team deliverables.
Data Analyst (HICS/Membership)
BCBS NC
Durham, NC
03.2015 - 12.2016
- Designed SQL queries and SSIS packages to process and analyze membership data for 300K+ records.
- Delivered compliance reporting for CMS with 100% on-time submission rate.
Education
Master of Arts - Mathematics (Applied/Abstract)
East Carolina University
01.2014
Bachelor of Science - Applied Physics
East Carolina University
01.2012
Skills
Languages: SQL, Python (Pandas, PySpark, BeautifulSoup), R, C, C#, VBA, Java, JavaScript, FORTRAN
Data Tools & Platforms: SQL Server (SSIS, SSRS, SSAS), Oracle, MySQL, Teradata, Tableau, Power BI, Business Objects
Data Engineering Skills: ETL pipeline development, data modeling, database optimization, API integration, data warehousing, data quality management
Cloud & Big Data: Azure Data Factory, AWS Data Analytics, Databricks (via coursework)
Other Tools: Git, PowerShell, MS Access, Excel (VLOOKUP, Pivot Tables, Macros), SAS, SPSS Modeler
Operating Systems: Windows, Unix, Linux
Certification
- Microsoft Professional Certificate in Data Science
- Certificate in Cryptography
- Diploma in Psychology, Diploma in Legal Studies
- Online Coursework: Azure Data Engineer Associate (Microsoft Learn), AWS Data Analytics (Coursera), PySpark & Big Data Essentials (edX)
Timeline
IT Engineer
P&A Group
05.2021 - Current
Application Developer
Medcost
03.2020 - 05.2021
Senior Applications Developer
AW North Carolina
08.2019 - 03.2020
Lead Data Engineer / Developer (Analytics)
Biogen
02.2019 - 08.2019
Business Analyst / BI Developer
HanesBrands
11.2018 - 02.2019
Data Analyst / Project Coordinator
Advance Auto Parts
07.2017 - 02.2018
Data Analyst (HICS/Membership)
BCBS NC
03.2015 - 12.2016
Master of Arts - Mathematics (Applied/Abstract)
East Carolina University
Bachelor of Science - Applied Physics
East Carolina University