Greg Ostrowski Email & Phone Number

Minneapolis, Minnesota, Us

Minneapolis, Minnesota, Us

Trained in the preparation of the Monthly, Quarterly and Annual Financial Statements for Hennepin Health and the corresponding Quarterly and Annual NAIC SAP (Statutory Accounting) reporting modules. (Supporting the Controller) Currently prepare all Finance schedules for the Quarterly NAIC and DHS Data Request Schedules and Work Papers.Prepare the Annual Supplemental Reports #1 and 1A for the Department of Commerce.Prepare the Claims Audit Selection for the Interim and Annual RSM Claims Audit. Prepare the Annual Gift Card Audit for HH Compliance and Hennepin County Internal Audit Department.Prepare the Quarterly Premium Tax Payments and the Annual Premium Tax Return for HMOs.Hennepin Health's Finance Staff took back in house, the processing of the DHS 820 capitation files, previously performed by Cirdan Health Systems. (HH's actuaries). I am responsible for executing the SQL Programs that retrieve our DHS 820 capitation file data and analyzing this data using Microsoft Access. This capitation data is then summarized in an Excel format and processed by members of our team to update our APEX General Ledger System.My newest duty is to calculate SafetyNet capitation amounts from our database for internal analysis and external reporting to HHS (Hennepin HealthCare). I track Capitation Revenue at the member level and summarize the Capitation Premiums by Product, the analysis of this information allows the calculation of member months, which is used for the reporting of Pass-Through EHP (Enhanced Hospital Payments) payments and Nursing Facilities withhold calculation amounts. I lead Hennepin Health's Overpayment Accounts Receivable Recovery team, I maintain our log, which contains detailed documentation for each Provider Refund received for claim adjustments. I was able to remove a Corrective Action Plan by creating an Invoice Master Database, featuring a compliant Invoice, and mail merge address process, along with populating applicable claims information.

San Francisco, California, Us

Financial Analysis (involving a deep dive data sourcing review) for the Corporate Regulatory Department Call Report Schedule RC-O (Other Data For Deposit and FICO Assessments) and RC-M (Memoranda) both components schedules of the RC (Balance Sheet); which are used, in part, to determine the FDIC Assessment Rate for Deposit Insurance. Essbase reports were created detailing "Other Borrowing" General Ledger account balances by Group, which allowed analysis and verification of secured and unsecured loan balances.Testing and documentation was performed to ensure data quality, data integrity, and adherence to data governance standards. Determined sources of schedule information and judged appropriateness and identified any gaps in desk procedures and work papers.

Provided financial and analytical support of PBM (Pharmacy Benefit Management) data for ClearScript's Customer Service and Clinical Services Teams. Responsible for working directly with account teams and clients to fulfill client requests. Prepared RFPs (Request for Proposals) and QBRs (Quarterly Business Reviews) and pricing models to determine discounts, proportions, and percentages for Operational and Financial Guarantees per contract. Proficient using Pharmacy adjudication/insurance accounting systems with strong emphasis on using visual basic code to analyzed large data bases of client information. The Audit of Argus Health Systems Standard Financial Reports for ClearScript Customers, and the startup of an internal audit program, auditing Rework claims on our Argus Nova adjudication platform, including the tying out of conversion data for new customers.Producing Ad Hoc reports, including detailed graphical reports displaying group level customer activity, (not currently available from our vendor), accurately and timely for our Customer Service Team.Using Argus Intel and IBM Cognos Focus reporting systems to download pharmacy member claims information to Access, Visual Basic to prepare the claims information and Excel/PowerPoint to present the claims information. Developing customer specific analysis models for different functional areas within ClearScript. Including Co-Pay Analysis models, Steering Letter Analysis models, Opioid Overutilization models, and Free First Fill/ Generic Incentive Program models for Customer Service and Med D Formulary build reports/ development and Formulary cleanup for Clinical Services. Leveraging company personnel's industry specific knowledge to accurately accumulate and disseminate claim data and modeling requests. Solid background in financial analysis of loan and insurance accounting systems with strong emphasis on SAS, Essbase, Excel and Visual Fox-Pro/Access analysis tools.

Participated on the project team for the production installation of the ATA System, a web based 13 F&G regulatory reporting system. Developed the business requirements inventory and Online Help/Reference Guide for the ATA system. Performed DTS file loading, SQL Navigator reference table verification, and performed testing and requirements assembly in preparation for Phase 2.

Responsible for the Financial Analysis/Accounting for Clearstone’s management of the RAS Preferred Drug Provider (PDP) program including the monthly audit of vendor (TMG) billing and receipts systems, (using Excel, Access (with visual basic) and Visio flowcharting. The following duties were performed: Monthly audit of vendor billing system, from billing extract verification to invoice generation and verification. Monthly audit of vendor delinquency reporting system. Weekly vendor verification and SAP generation of customer premium refunds. Creation and maintenance of receipts database containing lockbox, ACH and SSA receipts.

Responsible for providing and analyzing credit statistics for the consolidated U.S Bank with the following duties: General Ledger reconciliation of credit related accounts using Essbase to download the G.L mainframe accounts to Excel. All charge off and allowance for credit loss information was balanced to subsidiary credit database systems. Reporting consolidated credit statistics for external (10Q Earnings releases) on a GAAP basis and regulatory statistics on a RAAP basis for (Call/Frye Reports). Using Focus/SAS and a Credit Survey to collect, validate and accumulate credit information detailing US Bank’s past due, non accrual, restructured, and nonperforming assets. Preparing specialized Peer Group past due statistical analysis for senior management. Developing a Peer Group reporting database and investigating all available sources of credit and financial information for Peer Group comparisons. Using Visual Basic programming to update the Peer Group reporting Access database and validate quarterly 10Q past due credit statistics.

Master Of Business Administration (M.B.A.), Finance Concentration

Bachelor Of Science (B.S.), Accounting And Finance