Glen Powers Email & Phone Number

Houston, Tx, Us

Create dynamic financial data mining models. Review and analyze unreconciled general ledger accounts.

Houston, Texas, Us

Contractor Preparing financial operations reports for Baylor College of Medicine and its affiliates. Assist in design of SAP-Business Warehouse queries to eliminate manual processes being performed throughout the creation of financial reports.

Migrate 17,000 Meditech NPR reports from 8 distinct databases to enterprise wide standards. Consolidate 8 databases to 3 regionally based databases. Monitor progress of SQL/NPR development staff on progress of report development.• Maintain inventory of 17,000 legacy report catalog via the application tool Quickbase• Research changes in selection criteria/parameters from legacy to new standards for enterprise system• Coordinate end user requests for new reports/changes in existing reports with development team

Analyze Oracle-Retail Sales Inventory management ledger system for a national sports equipment retailer; Flow chart and document how sub systems interface with Inventory Value Ledger; Reviewed Sales, Purchasing, Warehousing and other sub systems and how they effect the value of perpetual merchandise inventory.

Glenview, Illinois, Us

Held responsibility for daily and monthly production of operations reports. Developed internal reports via Qlikview, Meditech Data Repository and other SQL-based data warehouse products. Maintained data links to four hospital reporting systems, including Meditech, Affinity, CPSI and Paragon. Aided in development of mobile MedPar tool. Created mobile morning report for senior division management and local facility management. Designed on-demand net revenue accrual application for use in mid-month projections and month-end close, as well as on-demand cost-of-charge ratio (CCR) application to monitor real-time facility performance.Provided ad hoc financial reports, combining pre-Rehabcare data with current Rehabcare data. Produced data archive for pre-Rehabcare information not saved by Rehabcare to complete government-required reports, crossing pre- and post-acquisition periods. Served as key team member during Rehabcare information technology data transition in 2010. Delivered and authored standard mobile Qlikview financial reports.Spearheaded CCR application to monitor facility exposure to prospective loss of government-based net revenue. Presented facility's current CCR through help of application to determine whether CCR was above or below threshold change from previously published CCR.Delivered analysis of net revenue per patient day to negotiate with current and prospective insurance providers, with ability to see negative net revenue trends within insurance providers and drill down to causes of trends, whether physician utilization, admittance of lower severity clients or cost-per-patient versus revenue.Offered short-term acute marketing tool to highlight monetary effect of discharging patients exceeding Medicare geometric length of stay. Resulted in potential savings of $4,000,000.

Glenview, Illinois, Us

Produced daily and monthly operating reports. Maintained data links to four hospital reporting systems inclduing Meditech, Affinity, CPSI and Paragon. Created a mobile morning report for senior division management and local facilty management. Produced a data archive for pre-Rehabcare information, not saved by Rehabcare, to complete government-required reports, crossing pre- ad post-acquisition periods.

Us

Director of Budgeting and Financial Analysis, 2005-2009Consolidated 21 hospital budgets and production of operations review reports. Developed data transformation tool for easy migration of budget data from budget software to facility general ledger systems. Maintained daily and monthly operations reporting system for senior management operations reviews. Created ad hoc reports from internal data warehouse as well as data warehouse from two financial reporting systems, Meditech and Affinity.Oversaw financial operations of five long-term acute facilities in Amarillo; Upheld financial records and oversaw proper classification of costs. Monitored timely and accurate recording of billable charges. Produced budgets, cost report work-paper data and ad hoc pro forma financial analysis. Held responsibility for general ledger database for; , hospitals. Provided functions as main developer of standard FRx/MAS 500 financial reports.Managed consolidated income statement, EBDITA and balance sheet reports for 21 healthcare facilities and corporate entities.Served as project leader, guiding financial systems consolidation during Triumph and SCCI merger, completed on time and under budget.Authored facility budget program to consolidate entities.Introduced automated data reporting system to expedite more timely investor reports.

Supervised business office, health information and support staff. Maintained financial records of healthcare partnership going through Chapter 11 bankruptcy, working as liaison with corporate attorneys. Provided testimony to U.S. bankruptcy court. Produced schedules and reports as required by courts and other entities. Facilitated electronic transfer of accounts receivable information to outsourcing contractor. Provided information in pursuit of sale of facility. Managed 20 full-time employees.Held responsibility for general accounting, payroll, accounts payable, network administration and systems analyst. Oversaw production and validity of month-end financial reports and budget, projection and actual expense analysis. Managed cash requirements and flow. Coordinated hardware and software upgrades to Meditech. Upheld integrity of integrated information and billing system. Liaised for external and internal audit requests. Presented daily and weekly labor monitoring/productivity system.Developed series of ad hoc reports to monitor managed-care plan performance.Offered functions as core team leader for Meditech conversion of general ledger, accounts payable and payroll systems.Delivered pro forma and product line profitability analyses.Developed accounts payable prioritizing system to allow payment of critical vendors while managing limited funds.

Controller, 1995. Managed general accounting, accounts payable, payroll and financial reporting for Houston facilities. Coordinated activities of accounting staff to ensure timely and accurate financial reporting. Delivered monthly reimbursement exhibits. Maintained integrity of balance sheet accounts. Monitored staffing levels and daily activities of nine staff members.

Edinburg, Texas, Us

Held responsibility for general accounting, accounts payable, payroll and financial reporting for multiple healthcare facilities. Coordinated activities of accounting staff to ensure timely and accurate financial reporting to local and corporate administration. Prepared monthly reimbursement exhibits. Ensured integrity of balance sheet accounts. Monitored staffing and oversaw functions of at least nine full-time employees.

Prepared pro forma analyses for new business ventures and assisted in merger with Twelve Oaks Hospital and Bayou City Medical Center. Evaluated profitability of product lines and facilitated capital asset procurements. Conducted financial reporting functions and prepared annual operational budgets. Maintained cost report work papers supporting documentation, ensuring integrity and timeliness of corporate reports. Produced and paid payroll-related taxes and interfaced regarding monthly performance issues. Computerized statistical reporting process and designed more accurate monthly cost input report. Led improvements to budget system. Supervised three full-time employees.

Maintained financial records for defunct area Hospital Corporation of America hospitals. Produced ad hoc financial analysis for Bellaire Medical Center Chief Financial Officer.

Held responsibility for general accounting, accounts payable, payroll and financial reporting. Oversaw activities of accounting department to deliver timely and accurate financial reporting. Developed monthly reimbursement exhibits. Upheld integrity of balance sheet accounts.

Guided financial affairs for 190-bed health care facility, including data processing and business office. Ensured ongoing integrity of financial system.

Directed financial reporting for not-for-profit child welfare organization. Produced semi-monthly payroll for more than 200 employees. Maintained records for operating fund and four investment funds. Supervised staff of four.

Coordinated conversion from Humana financial reporting system to Saint order entry system.

Global, Us

Held responsibility for preparing financial reports. Oversaw duties of four staff members.

M.B.A, Healthcare Administration

M.S, Accounting

B.S, Business Administration