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:
undefinedTimeline
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
Similar Profiles
Katie StroupeKatie Stroupe
Retirement Service Consultant at AscensusRetirement Service Consultant at Ascensus
Todd BrookerTodd Brooker
Client Relationship Manager/Senior Retirement Services Consultant at AscensusClient Relationship Manager/Senior Retirement Services Consultant at Ascensus
Esther AneyoEsther Aneyo
Customer Service Representative at AscensusCustomer Service Representative at Ascensus
Patricia MalonePatricia Malone
Operations Associate, Investment Services at AscensusOperations Associate, Investment Services at Ascensus
Lance GillLance Gill
Machinist at M&SMachinist at M&S