Aaron Hall
Charlotte,NC
Summary
Results-driven Data Analyst with a proven track record of supporting diverse operations, utilizing data to inform critical business decisions, and driving process automation. Proficient in SQL, Excel, and Power BI, with advanced skills in data analysis and visualization. Adept at collaborating with cross-functional teams to provide valuable insights for informed decision-making.
Overview
5
5
years of professional experience
Work History
Data Analyst
Billtrust
02.2024 - Current
- Provide actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Optimize UAT data mining workflow by migrating from Google Sheets to Python, enhancing data accuracy, and bolstering a stakeholder dashboard for informed business decisions.
- Develop custom algorithms to increase the effectiveness of analytical insights.
- Design and maintain an inquiry submission system for offshore teams, incorporating custom data tracking to monitor KPIs, ensuring alignment with organizational goals and objectives.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
Associate Data Analyst
Billtrust
08.2021 - Current
- Lead initiatives to optimize operational efficiency, resulting in a 50% productivity improvement and a 23% volume increase
- Support development of an automated invoice volume management program, resulting in monthly cost savings equivalent to 6 full-time employees' workloads, totaling $10,000 per month
- Enable scalable operations by transitioning processes to BPO teams, saving $3 million annually through effective training and quality metrics implementation
- Manage Business Process Outsourcing team on a daily basis, ensuring smooth operations and timely execution
- Collaborate in the development of a UAT workflow for onboarding clients, increasing their overall success rates by 22%
- Develop an automated ticket system for seamless cross-functional team communication, improving issue resolution and operational efficiency
- Demonstrate experience in performing ad hoc analysis, insight requests, and data extractions to enhance critical business processes
- Manage daily performance reporting and analytics to support operational success and monitor key performance indicators (KPIs).
Senior Payment Operations Specialist
Billtrust
02.2021 - 08.2021
- Performed thorough throughput testing to ensure accurate automation of various CSV, PDF, and XML data points, ensuring reliable data processing and minimizing errors
- Created automated email routing to accurately deliver customer invoicing emails, improving communication efficiency and ensuring timely delivery
- Liaised between various internal departments to successfully offload onshore product volume to offshore processing teams, fostering seamless collaboration and achieving resource optimization
- Optimized multiple products from the incubation stage through customer-facing production, ensuring streamlined processes and enhanced efficiency
- Established transactional threshold criteria for metadata quality assurance, ensuring high standards of data accuracy and integrity
- Identified errors in automation and audited data to determine areas of workflow improvement, enabling enhanced accuracy and efficiency
- Implemented quality control protocols and curated quality standards to establish success metrics, resulting in improved customer satisfaction and success rates
- Created standard operating procedures (SOPs) in accordance with various customer service level agreements (SLAs), ensuring consistent quality and compliance
- Facilitated the onboarding process for new customers, ensuring a seamless transition and establishing strong client relationships.
Associate Client Support Specialist
Billtrust
12.2019 - 02.2021
- Managed team of Data Entry Specialists during day-to-day payment processing
- Identified various data patterns for increased automation opportunities to limit manual efforts
- Archived data storage for PCI-compliant credit card information and login credentials
- Created and maintained unique SOPs for more than 50 different customers and issuers
- Served as point of escalation for all technical issues related to Payment Operations
- Reviewed and critiqued business standards for onboarding customers
- Facilitated end-to-end virtual payment processing for over 50 different customers.
Data Entry Specialist - Contract
07.2019 - 12.2019
- Produced over 130 successful virtual credit card transactions per day
- Maintained an accuracy percentage greater than 99%
- Processed all virtual payments within 24-48 hour SLAs
- Researched and documented nuanced business rules for new customers in order to identify areas of improvement in the workflow process
- Contributed to secure archiving of customer credit card and banking information
- Coordinated daily customer payment exception reports.
Education
Bachelor of Arts in Communications -
Seton Hall University
South Orange, NJSkills
- Power BI
- SQL
- Excel/Google Sheets
- Python
- Microsoft Power Automate
- Microsoft SharePoint
- Business Insight Reporting
- Data Visualization & Forecasting
- Google Apps Script
- JIRA
- Confluence
Timeline
Data Analyst
Billtrust
02.2024 - Current
Associate Data Analyst
Billtrust
08.2021 - Current
Senior Payment Operations Specialist
Billtrust
02.2021 - 08.2021
Associate Client Support Specialist
Billtrust
12.2019 - 02.2021
Data Entry Specialist - Contract
07.2019 - 12.2019
Bachelor of Arts in Communications -
Seton Hall University