Andrew John
Houston,TX
Summary
Results-driven analyst focused on optimizing pharmacy benefits and driving operational efficiency through data analytics. Successfully developed dashboards and presented insights that directly improved client outcomes, while fostering collaboration among teams to enhance business growth and maintain data integrity across multiple platforms.
Overview
8
8
years of professional experience
Work History
Senior Business Analyst
Caremark LLC
Northbrook, IL
06.2024 - Current
- Facilitates monthly committee meetings and departmental functional calls, providing updates for account management team.
- Joined consultant data committee to maintain current templates and modeling for supported teams.
- Manages task assignments and project distribution among analysts to optimize workload balance.
- Maintains training materials and task lists for new hires through Confluence to support smooth transitions.
- Serves as consultant during client sales calls in collaboration with sales team.
- Prepares quarterly business reports for stakeholders to monitor progress towards company goals.
- Facilitates workshops to elicit stakeholder feedback on project initiatives.
- Delivers timely support by tracking issues and communicating resolutions to end users.
- Analyzes business processes to identify areas for improvement and efficiency.
Business Analyst
Caremark LLC
Northbrook, IL
08.2022 - 06.2024
- Created ad hoc models and dashboards addressing complex client needs.
- Utilized SAS to pull data efficiently for advanced data modeling tasks.
- Recommended process improvements through thorough analysis of systems and workflows.
- Maintained accurate client-specific pricing by collaborating with underwriting teams.
- Streamlined sales service and marketing activities through effective management of Salesforce.
- Generated RXInsight reports for client consultations, focusing on industry trends.
- Consulted with coalitions, ensuring optimal benefits while maximizing client savings.
- Analyzed competitive strategies by assessing drug market and share trends.
Charge Reconciliation Analyst
RadPartners
El Segundo, CA
06.2021 - 08.2022
- Analyzed reconciliation discrepancies to ensure accurate financial reporting.
- Collaborated with cross-functional teams to resolve account inconsistencies.
- Reviewed transaction data to identify and address variances promptly.
- Managed reconciliation processes for multiple accounts within designated timelines.
- Documented findings and communicated updates to relevant stakeholders effectively.
- Investigated any discrepancies or irregularities identified during the reconciliation process.
- Tracked progress of open items and followed up with appropriate parties when necessary.
- Assisted with month-end close processes by preparing various reconciliations including balance sheet accounts.
- Conducted extensive research into customer accounts as needed to resolve outstanding issues.
- Researched and prepared account analysis for all reconciling items on a periodic basis.
Staff Accountant
Choice Specialty Pharmacy
Missouri City, TX
01.2019 - 05.2021
- Managed general ledger entries and reconciliations for accurate financial reporting.
- Prepared monthly financial statements and analyzed variances against budgeted figures.
- Developed and maintained financial reports using accounting software for internal reviews.
- Monitored accounts payable and receivable, ensuring timely processing of invoices.
- Prepared monthly account reconciliations for bank accounts, credit cards, and other balance sheet accounts.
- Managed financial operations, month-end reporting, financial schedules and reconciliations.
- Researched complex transactions to ensure proper classification within the general ledger accounts.
- Analyzed existing accounting processes to recommend improvements in efficiency or effectiveness.
Education
BBA - Accounting
University of Houston
DowntownSkills
- Data analysis
- SQL database management
- Power BI and Tableau
- Data visualization techniques
- Data forecasting
- KPI monitoring
- Stakeholder engagement
- Client consultation
- User testing
- Financial analysis
- Confluence and SharePoint
- Microsoft Office Suite
- Analytical thinking
Timeline
Senior Business Analyst
Caremark LLC
06.2024 - Current
Business Analyst
Caremark LLC
08.2022 - 06.2024
Charge Reconciliation Analyst
RadPartners
06.2021 - 08.2022
Staff Accountant
Choice Specialty Pharmacy
01.2019 - 05.2021
BBA - Accounting
University of Houston