Pamela Johansen
Mokena,IL
Summary
Accomplished Senior Accounting Operations Analyst with a proven track record at Personify Health, enhancing financial processes and implementing automated solutions. Expert in Microsoft Excel and SQL, adept at data analytics and improving operational efficiency. Demonstrated ability to lead cross-functional teams in developing advanced reporting tools, significantly reducing manual workload and maintaining high accuracy in financial reporting.
Overview
34
34
years of professional experience
Work History
Senior Accounting Operations Analyst
Personify Health
01.1991 - Current
- Contacted internal and external customers to obtain documentation to support invoices and claims.
- Identified, recommended and executed opportunities to enhance accounts receivable and billing processes to meet finance requirements.
- Leveraged accounting and finance experiences and expertise to identify, propose and implement automated solutions and reduce manual processes.
- Prepared spreadsheets using formulas, V-lookup and other intermediate and advanced Microsoft Excel skills.
- Maintained account accuracy by reviewing and reconciling monthly.
- Work with senior developers to design and establish standards for building reporting solutions
- Provide assistance with interpretation of raw data and complied information from multiple sources
- Analyze data for accuracy issues and work with related departments to make corrections
- Coordinate and complete ad-hoc client requests utilizing MS SQL, MS Excel and MS Access by creating queries combining multiple sources to produce financial reporting
- Responsible for tracking aggregate stop loss through reporting
- File aggregate reimbursement requests with stop loss carrier and manage subsequent audit process
- Designed and implemented internal client fund tracking using MS Excel
- Tested and successfully implemented Benefit Focus, our online reporting tool
- Tested and successfully implemented Connexure fka Young Consulting Reporting Warehouse used to provide daily paid claims and funding requests to clients as well as ongoing troubleshooting when accuracy issues occur
Skills
- Month-end close
- Microsoft Excel
- Data Analytics
- Microsoft SQL/Access
Timeline
Senior Accounting Operations Analyst
Personify Health
01.1991 - Current
Similar Profiles
Akeya JohnsonAkeya Johnson
RBP Member Services Supervisor at Personify HealthRBP Member Services Supervisor at Personify Health
Juanita WymanJuanita Wyman
Intake Specialist at Personify healthIntake Specialist at Personify health
Uddeshya Kumar TripathiUddeshya Kumar Tripathi
SDET at Personify HealthSDET at Personify Health
Luis RamirezLuis Ramirez
IT Support Specialist at Personify HealthIT Support Specialist at Personify Health
Philip R. DunlapPhilip R. Dunlap
Practice Manager at Vascular Specialists LLCPractice Manager at Vascular Specialists LLC