John C. McGee
Haslet, Texas 76052
817-***-**** ● ****.*.*****.*@*****.***
Seeking an opportunity to further my value as an asset in a position of that will provide growth potential and longevity.
SKILLS
Process MonthEnd Scheduling and various monthly/quarterly financial reports including month close
Reconciliation of daily hospital financial data
National account management support with business methodolgoies
Agile Methodolgies
Power BI User
Orbit Reporting
PeopleSoft
Business Process
Financial Analysis & Reporting
HR & Timekeeping
SQL
Data Consolidation
Process Improvement
Monthly Financial Reconciliations of Buy Cards and T&E
Database management and manipulation
Account reconciliation and payment reimbursements
Report generation with data manipulation
Able to read and comprehend various Bill of Lading formats
Excellent professional customer service skills
Software Asset Management
Microsoft Office Suite
Staff Management
Medisoft Professional (Medical A/P & A/R Billing, Patient
Familiar with 835, 837 and 277 payer files
Records Management SAP, Siebel, Lotus Notes
HIPAA/OSHA Training
Inventory Asset Management
Tax Knowledge
Purchasing & inventory management
Knowledge of instructional and procedural creation
Report Generation and data manipulation through SQL
Perform AR/Bad Debt/Charity Adjustments support
EDUCATION
Kaplan University B.S. in Health Care Administration (with Management emphasis) Davenport, IA
Graduated: July 23, 2013
EXPERIENCE
Likewize Device Protection, LLC Southlake, TX
09/2021 – Present
Senior Analyst Client Operations, National Account
Responsible for corporate level client decision support for national US and Canadian cellular accounts (about 8 million subscribers), management level escalations, data mining & data management, and B2B customer inquiry interactives and solution generation. Financial management of fund submissions to subs across entire client base. Create data driven reporting utilizing excel with Z lookups, pivot tables, Power BI, and proprietary software to compose complex reporting requirements. Support data integrity efforts to comply with compliance and auditing requirements. Supply executive management and corporate clientele with trend analysis, forecasting, and project management support to identify solutions-based resolution and process vulnerabilities. Frequent engagement in meetings to further drive sales and marketability of the company brand, while maintaining strict adherence to policy and state regulations, and multi-state laws. Daily engagement use of Sharepoint, Microsoft Teams, and Zoom to coordinate efforts internally and with B2B customer for excellent client management directives and solution process actions.
UT Southwestern Medical Center (State of Texas) Dallas, TX
03/2020 – 09/2021
Administrative Associate/Dept. Administrator
Relieves director of various internal administrative duties, which require thorough understanding of, and adherence to functions, programs, and policies of unit and university. Reviews department policy manuals periodically to update and institute changes as necessary. May provide comprehensive administrative support to Chairman, Vice Chairman, Director, Department Manager, or other upper level administrator. Responsible for monitoring and maintaining unit's budget; provides input to supervisor; prepares and submits various budgetary reports; time & attendance entry; assists supervisor with annual budget process. May delegate approval authority for all dollar level expenditures for designated entity; coordinates process for items requiring Chair level approval, and/or has delegated approval authority over these items. Responsible for all departmental financial reporting and budget analysis. Coordinates supervisor's schedule; makes travel arrangements (if necessary); plans meeting itineraries, etc. for director or outside visitors. Charged with approval of vacation and sick leave transactions; interprets V/SL policies for unit's personnel. Prepare or coordinate preparation of complex reports requiring significant contact with other departments and outside organizations. Provide professional support for special projects, which may include editorial and administrative support for manuscripts and abstracts for publication; prepares material for oral and/or written presentations; coordinates and prepares materials for courses, meetings, and conferences; performs Library and Internet research. May provide assistance in preparing grants and contracts, which may include assistance with budget preparation and/or oversight. Additionally, responsible for maintaining sub−ledgers and ledgers for various accounts, including reviewing expenditures and encumbrances, reconciling accounts, and ensuring appropriate use of funds. May provide working supervision for staff of lower rank. Performs other duties as assigned.
DISYS, Inc. Fort Worth, TX
10/2019 – 12/2019
Software Asset Management Analyst (Contract)
Facilitate and review process requests for licensing acquisitions for goods, services and intellectual property globally on behalf of a Fort Worth based client. Perform research on licensing ownership and migration requirements to ensure legal standards are kept. Responsible for management of new intellectual software acquisitions as well as software renewals to include: installation, maintenance package agreements, perpetual or limited license contract adherence, and verification of asset purchase integrity. Issue purchase orders in accordance with client corporate policies and perform follow up research on RFP’s as well as PO completion.
Baptist Hospitals of Southeast Texas Beaumont, TX
09/2016 – 10/2019
Business Analyst
Analyzes the organization’s expenses against budgeted and historical activity. Used Agile methodologies to complete monthend close processes with SQL, and S Access. Assists in the preparation of annual operating budgets and monthly forecasts. Responsible for generation of reports regarding the financial condition of the entire Baptist system (to include contractual entities). Perform critical functions to support the billing infrastructure of the Baptist system and reconcile information against the Charge Master and other financial nodes including the business process between hospital systems. Develop reports and analytic objects which meet business requirements of business organizations. Collaborate with technical experts and business units to determine the best possible reporting mechanisms. Reviewed 835, 837 and 277 claim files to reconcile remittances for account adjustments. Ensure the daily upload and posting of monetary account adjustments as well as their financial classifications as well as generate financial reporting schemes to include KP&I and P&L. Deployed excellent interpersonal skills including verbal and written communication skill, teamwork and customer service skills. Develops, prepares, analyzes, and distributes financial reports upon request. Creates, maintains, and maps general ledger accounts to improve the company’s financial reporting abilities. Produce ad hoc financial data reports. Understand and use database schemes, tables, relationships, and constraints. Also responsible for Month End reporting process and data generation through various applications to support executive management for organizational health from a financial standpoint.