Paul Carson
Data Engineer
Cincinnati,OH
Summary
Skilled business solutions technology professional offering in-depth understanding of securing and leveraging data resources. Accomplished in building brand new systems that meet complex business requirements. Primary Expertise includes MS SQL, MongoDB, Power BI, SSRS, C#, Python
Overview
8
8
years of professional experience
Work History
Data Engineer
Ascensus
Cincinnati, Ohio
07.2022 - Current
- Developed reporting dashboard process for critical and at risk bottlenecked business process facilitating 70% reduction in volume of work in high risk stages over 60 day period.
- Developed data pipeline and analytics process to pull in Workforce Indicator (PEGA) metrics for key WFH analysis initiative.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Developed, implemented and maintained data analytics protocols, standards and documentation.
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls
Software Developer
Ascensus
Cincinnati, OH
01.2021 - 07.2022
- Customer facing Developer on strategically deployed Agile team
- Identify root cause problems for enterprise high profile pain points
- Developed .NET Core website and MS SQL solution to outdated, Excel based tool leading to immediate >20% jump in ancillary billing revenue
- Resolved and automated via RPA critical bottle neck in Benefits Continuation process resulting in >25% reduction in cycle time, reduced employee time required by 11 FTE and >$500K annualized savings
- Worked on web based solution using .NET and MS SQL to provide accurate data from >25 acquisition companies in centralized location facilitating greater visibility into business
- Optimize data consumption via development of reports, dashboards and automation using MSSQL, SSRS, Power BI.
- Updated old code bases to modern development standards, improving functionality
Senior IT Business Analyst
Ascensus
Cincinnati, OH
06.2019 - 12.2020
- Partner with internal and external stakeholders to migrate legacy processes to Pega BPM
- Support geographically dispersed, cross functional, Agile software development team
- Migrated over 50% of Retirement TPA plans from disparate legacy systems to Pega BPM
- Identify business requirements and optimization opportunities using robotic technology
- Gather requirements, develop wireframes for proposed technology improvements
- Work with business and development to write highly effective user stories
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes
Software Developer, Consultant
HealthGuard Cyber Risk Management
Cincinnati, OH
06.2017 - 06.2019
- Partner with senior leadership at healthcare covered entities to develop, support or optimize effective Risk Management processes
- Gather requirements and process map for client projects
- Perform quantitative Risk Analysis for specific client scenarios
- Re-engineered application security questionnaire process reducing time to complete by 70% for client company
- Supported client Business Continuity Planning by developing capacity models with relevant dependencies
- Developed interactive Risk Models in R (Shiny) based on FAIR Ontology for use in modeling loss exposure scenarios.
- Analyzed problematic areas to provide recommendations and solutions
Senior Business & Process Optimization Analyst
PNC Bank
Miamisburg, OH
03.2017 - 03.2018
- Perform comprehensive analysis of systems, process review, and strategic planning for major migration of three retail-servicing systems into one enterprise-level servicing platform successfully and accurately migrating over 75K accounts.
- Spearhead development of innovative processes to align system through implementation of Lean Six Sigma tools and methodologies
- Collaborate directly with internal and external stakeholders throughout project lifecycle
- Created procedures for migration and integration from ground-up, developing repeatable processes to enhance efficiency and streamline operations
- Utilized Python and Monarch OCR to clean and wrangle disparate data for analysis and integrated reports from all four systems
- Designed Access database and wrote balancing queries in SQL to identify and report on balance issues
- In Tableau developed and launched dashboard reporting to improve access and visibility for senior management.
Process Optimization Analyst
Fifth Third Bank
Cincinnati, OH
12.2015 - 03.2017
- Collaborated with internal and external business partners to gather requirements and launch high-level, cross-functional optimization projects impacting multiple business lines
- Leveraged Lean Six Sigma methodologies, data analytics, and data science to create data-driven solutions for overcoming business challenges
- Designed and deployed innovative process to minimize rework loops in Auto Loss Mitigation business line, slashing cycle time by 56%, through root cause analysis, time studies, and gage R&R
- Developed and supported Centralized Disclosure Team process in Mortgage Line of Business
- Reduced cures to direct channel loan applications by 52% with total savings of $2.7M over six months
- Created intelligent dashboard to provide senior management in Mortgage Department with improved access and forecasting
- Led Business Control and Enterprise Risk teams in process mapping and risk rating for high-risk areas of consumer banking.
- Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork
Education
Master of Business Administration (MBA) - Finance
Keller Graduate School of Management, DeVry University
Bachelor of Arts -
University of Cincinnati
Cincinnati, OHLean Six Sigma Black Belt -
BMGI
Skills
Technical Skills:
MS SQL, Mongo Db, Power BI, SSRS, C#, NET, Python
Product development
Programming
Software Development
NET development
Advanced analytics
Report generation
Data analysis
Timeline
Data Engineer
Ascensus
07.2022 - Current
Software Developer
Ascensus
01.2021 - 07.2022
Senior IT Business Analyst
Ascensus
06.2019 - 12.2020
Software Developer, Consultant
HealthGuard Cyber Risk Management
06.2017 - 06.2019
Senior Business & Process Optimization Analyst
PNC Bank
03.2017 - 03.2018
Process Optimization Analyst
Fifth Third Bank
12.2015 - 03.2017
Master of Business Administration (MBA) - Finance
Keller Graduate School of Management, DeVry University
Bachelor of Arts -
University of Cincinnati
Lean Six Sigma Black Belt -
BMGI