Phillip Sean Cook Email & Phone Number

United States

Contract to hire to assist the Asset Management department during a staffing transition. Supported the department in the capacity of a Financial Analyst for creating budget templates, excel based/system based reporting, AP Distributions, HR incentives, OHFA project, Operating Deficit Guaranty Analysis, and other tasks as assigned and needed.

Columbus, Ohio

Contract performing testing, configuration, staging, and tracking of company point of sale assets. Working with team members to ensure timely completion of assigned projects.

Columbus, Ohio Area

Established process improvement strategies and tactics for more efficient use of their DBMS/AMS (Association Management Software.) Worked to increase staff communication, gather user requirements, and provided end user training on the software. Through close communication with Executive Management, and more efficient use of technology, data errors were reduced and revenue increased. Performed the role of IT and Network support and escalated issues to our IT Managed Services Company as needed. Data extraction with SQL to provide ad-hoc data for Marketing and Communications to engage members for campaigns, and surveys.

Columbus, Ohio Area

Contracted to assist in multi-department process flows where needed and improve data collection. Data was provided by several departments via MS Excel, entered into a master spread sheet, and then entered into scorecards I created for tracking results. By increasing communication, gathering user requirements, and raw data analysis, the results identified breaks in processes, and allowed for corrective action to reduce labor hours. In addition, I built a data entry platform with SharePoint Designer 2013 for technicians to enter data while in the field.

Columbus, Ohio Area

Contracted for data extraction/data mining techniques on large volume MS Excel files, detailed line item analysis, and reported results back to management. Data Analysis was completed to back into data through the use of MS Excel Pivot Tables, V-Look-ups and Oracle/OBI to obtain the necessary results.

Columbus, Ohio Area

Responsible for pharmaceutical returns analytics on behalf of CVS Caremark in accordance with GAAP and computational mathematics. Compiled, and applied data analysis for 2300 returns quarterly with MS Excel and IBM AS400 business systems for reporting to senior levels of management. Additional responsibilities included weekly vendor conference calls as well as data analysis and tracking of Walgreens' and Kroger pharmaceutical returns. Created an MS Excel database to automate the CVS returns data analysis process for a faster and accurate view of the CVS returns variance analysis.

Columbus, Ohio

Recruited by owners to perform all accounts payable functions in accordance with GAAP while company was in transition for sale using Real World 5.0 accounting system. This included creating purchase orders for sales staff, matching receipts, processing invoices for payment, calculating Ohio Sales and Use tax, posting to the ledger, performing the weekly check run, and monthly, quarterly, and year end close. Assumed additional customer facing responsibilities, front end walk in sales, office administration, and training a new hire for the position of receptionist while simultaneously handling day to day A/P responsibilities.

Hired into newly created Revenue Cycle Management department with responsibilities revolving around all facets of operating a small cancer hospital within a hosting hospital. Used Siemens Medical Software (SMS) and MS Excel to lead all financial and administrative responsibilities including charge capture, CMS compliance, and chart review. Functioned as a liaison between both hospitals for administration and financial reporting.