Chris Fritz Email and Phone Number

• Severing as a subject matter export for volume forecasting and effective day calculations.• Forecast for the total number of Rxs shipment on yearly, quarterly, monthly, and daily bases• Worked cross-functionally to set companywide targets for internal and industry metrics.• Generate and provide daily reporting to Senor Leaders by using SQL, Hyperion cubes, and Excel. • Implement process improvement using SQL, Excel, and Tableau• Monitor and maintain internal web based reporting.• Collaborated to improve and streamline daily process in printing medical billing forms.• Generate and monitor reporting on based on internal department’s headcount, staffed working hours as well as overtime.

• Managed four full-time employees that provide rebate payments and reporting for the DFO book of business.• Created client-specific reporting templates detailing clients’ current rebate payment using SQL and Excel, while improving accuracy and timeliness. • Created, maintained, and presented on the tracking and reporting for department-wide payment processes, client setups, and open client issues to enable managers to more effectively and efficiently assign and monitor their team's workloads.• Collaborated with cross-functional internal partners and validated and set up client information and payment rates into the internal Client Rebate System, and to satisfy client requested ad-hoc reporting.• Partnered with the Treasury and Accounts Payable teams to generate and send manual payments to clients.

• Drafted and deployed SQL queries to generate pharmaceutical rebate reporting, determine pricing strategies, complete pricing impact analyses, and calculate client guarantees. • Created formula-driven database tables and assemble multi-source data via Multi Load (M-Load) scripts.• Developed ad-hoc financial reporting for cross-functional partners.• Created procedure documentation for accrual and rebate reports to streamline on-boarding and education.

With a strong focusing on efficiency through process improvement, accuracy, and consistency, I develop and test audit systems to ensure quantitatively balanced claims within and between various platforms. I also develop, automate, and test Microsoft Excel and Access databases to monitor systems access, generate productivity reports, and trigger action plans. I write Visual Basic for Applications code to generate patient billing and process audit reports within Microsoft Office. I collaborate with internal and external parties to resolve billing software issues and user troubleshooting while serving as security and technical liaison for the Medical Billing and Claims Processing teams. I effectively monitor security settings for internal and external software users, and ensure compliance through a structured user functionality.

Develop and test Microsoft Excel and Access databases and tables by writing Visual Basic for Applications code to generate reports within Microsoft Office. I create and test scripts for new software applications, including Excel, Access, as well as internally-developed programs. This is to enhance the group’s daily workflow, and ensure the efficiency, quality, and timeliness of the daily operations. While, interact with clients and branches to prevent audit violations. Research account interactions through multiple databases to investigate client outages and physical address violations as mandated by the USA PATRIOT Act. I also design and develop electronic and hard copy marketing fliers for department events and meetings, while maintaining and updating the department’s intranet site

Resolved discrepancies with CitiBank clients’ debit and credit card transactions through thorough database research, and provided detailed daily reports to managers and other internal departments. I also balanced monthly billing reports with external credit card vendors.

Conducted secure banking transactions for individuals and commercial entities. I developed leadership skills by: creating task schedules for 16 branch employees, set and monitored branch referral goals for the Investment Specialist, and promoted and built client awareness for the branch’s Financial Advisor and products

Supervised five teams of full-time landscaping professionals, which totaled 15 employees. I was also responsible for monitoring team production levels and tracking the input and output of work-related data and inventory.

Independently maintained 15 accounts with local grocery stores by developing and maintaining customer relations with several clients. I organized product shipments and marketing materials from beverage suppliers within supermarkets