Requests
48
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Global Medical ResponseData Analyst - Revenue Strategy & Analytics
Nov. 2024Lewisville, Texas, United States• Extract, aggregate, and organize data from SQL databases that house revenue cycle data from separate front-end billing applications. • Generate and manage NSA-related dashboard data and operational reporting procedures.
• Routinely test data for accuracy and ensure reporting integrity. Troubleshoot irregular data issues (e.g., Correct non-conforming data relationships or unmapped new data elements).
• Produce an NSA-specific EOM reporting package for executive and operational leadership teams.
• Create routine and ad-hoc queries/analysis as requested.
• Provide analytical support through advanced data compilation and predictive modeling to revenue operations, finance and accounting.
• Develop analyses/models to measure revenue mix and sensitivity assessments.
• Work with revenue cycle management team in compiling data for deep dive analyses around NSA trip volumes by status, dispute success and accounts receivable aging.
• Gather business and technical requirements from revenue team leadership and translate requests into functional operational reports and dashboards using Power BI and Excel.
• Assist with data governance activities to ensure that data is presented consistently across all business units and the organization.
• Monitor daily ETL results to ensure source data is loaded in an accurate and timely manner. Troubleshoot and resolve issues as necessary. • Maintain, repair, and optimize stored procedures and related processes as assigned.
• Create SOPs and process flow diagrams as required.
CompuGroup Medical USRCM Controller
Jun. 2024 - Nov. 2024Richardson, Texas, United States• System Process Issue Cash Variance Analysis
• Client Invoicing and Revenue Projection Updates
• Modifying and optimizing processes, including:
o Creating current client list in SharePoint, including PowerApps forms and Power Automate workflows
o Moving client pricing request process to SharePoint utilizing PowerApps forms and Power Automate workflows
o Moving At Risk and Termination processes and lists from Excel into SharePoint, including PowerApps forms and Power Automate Workflows
o Creation and maintenance of SharePoint site for RCM Special Projects
o Creation of new reports in Power BI
R1 RCMSenior Corporate Finance Analyst
Apr. 2023 - Jun. 2024United States• Cash Reporting, including:
o Creating cash queries utilizing SSMS and Power Query
o QA new cash reports utilizing client reports and existing cash reports
o Maintenance of cash reports, including updating scripts as needed
o Refreshing cash reports, ensuring data integrity
o Assisting in building waterfall models for 8 clients
o Cash and revenue modeling for one client with over 20 divisions
• Modifying and optimizing processes, reports, and SQL scripts, including:
o Reporting System Migration – move processes from SQL Server based to Snowflake based database structure
o Learning Snowflake and building new database for testing and learning in Snowflake environment
o Migrating cash reporting to Snowflake based reports
o QA new cash reports utilizing SSMS reports, client reports, and other existing reports
o Creation and maintenance of basic SharePoint site for FP&A
o Creation of new reports and dashboards in Power BI for both cash collections and productivity, including data integration and SQL programming as needed
US Anesthesia PartnersSenior Financial Analyst
Apr. 2018 - Apr. 2023Dallas, Texas• Primarily Responsible for Accurate Revenue Recognition, including: - Monthly revenue close process, data integrity verification & journal entry preparation using SQL queries, Power Pivot, Power Query, Amazon Redshift / DBeaver, heavy Excel, and OfficeConnect - Monthly extraction, formatting, & verification of data to load to accounting system (WorkDay) - Extensive utilization of SSMS & SQL logic for reporting & variance analysis utilizing large data sets - Monthly AR Runouts & Calibrations
- Monthly finance packets consisting of 6 reports for 32 divisions • Modifying & optimizing processes, reports, & SQL scripts for Revenue Cycle, including: - Revenue Recognition System Migration - SQL Server based to Amazon Redshift based database structure, coordinating with 2 programmers to have all month end revenue recognition processes moved to new system, including extensive UAT & QA - System migration from Microsoft Dynamics based accounting system to WorkDay - Changing accounting reports from Jet based with Microsoft Dynamics to OfficeConnect based with WorkDay - Creating team calendar in Microsoft Teams to help track team PTO & interdependent monthly deadlines
- Creating team checklists in Microsoft Teams - Optimizing monthly finance packets using automation – utilizing Microsoft Automate & Adobe Acrobat DC Pro to gather parameters for file locations, creating 6 PDF reports for 32 divisions, splitting each report up by division, bringing together the 6 reports for each division to create divisional reports, adding page numbers, & saving the files with the applicable month & division in the filename - Creating Power Pivot files in Excel for large data sets, including Excel based expense detail files & monthly topside files - General automation/optimization utilizing SQL, VBA, Microsoft Automate, Adobe Acrobat DC, Power Pivot, Power Query, OfficeConnect, extensive Excel formulas, etc. for revenue related files used throughout our team
Inform Diagnostics Senior Revenue Analyst / RCM Data Analyst
Oct. 2014 - Apr. 2018Irving, Texas- Primarily Responsible for Accurate Revenue Recognition, including:
o Monthly revenue close process, data integrity verification and journal entry preparation using SQL queries, Power Pivot, SmartConnect, GreatPlains and deFacto
o Monthly extraction, formatting and verification of data for reporting cube
o Extensive utilization of SSMS and SQL logic for reporting and variance analysis SQL
o Quarterly audit preparation and documentation, including reconciliation of transactional detail to financials and other reports
o Monthly AR and Cash Reconciliations Reporting
o Weekly Refund Processing - Modifying and optimizing processes, reports, and SQL scripts for Revenue Cycle, including: o Creation of Managed Care team SharePoint portal, including data integration / standardization, workflow automation, form creation, etc.
o Redesigning AR and Cash Reconciliation files used monthly to use more formulas and links; Redesign reduced time required for completion from several business days to approximately one business day in addition to increasing accuracy and readability.
o Reconstructing month end and flash files (Case Volume Report, End of Month Estimate, Accrual, Revenue Walk, Revenue Variance) to run more smoothly and quickly as well as reduce file size, while better meeting the needs of end users
o Optimizing weekly refund and vendor SQL queries and process
o Integration of acquisitions and new business lines into the MLS Revenue Process for close, flash (pre-close) and audit - Working with treasury and cash applications to reduce average monthly cash reconciling items by 90%
- Creation of Revenue Specific deFacto reporting cube and associated reports, including reports utilizing both GAAP and JGAAP requirements, reports by payor as well as business line, time comparitive reports, quarterly summaries, and audit reports
- Assisting other team members and/or training as needed with Excel, PowerPivot, and deFacto questions, issues and troubleshooting
HMSBusiness Analyst (Contract / Project)
Jan. 2014 - Oct. 2014Irving, Texas- Collection of business requirements for accounting system contract migrations
- Review of SAS code and pseudo code from existing Legacy system
- Creation of reporting specifications for Java/SQL developers/programmers
- Creation of SQL procedure code for database updates to assist developers with heavy workloads
- QA of final reports to ensure data integrity and financial accuracy in the new proprietary system
- Ensuring data from client source claim files is feeding appropriately through 4 systems and working with multiple IT and business teams when necessary to update associated processes
- SharePoint portal upkeep for System Migration, Batch Process Project, IT/Development and QA teams
- Extensive use of SQL queries in Teradata and Toad, utilizing both existing SQL logic and queries created from scratch, for data research and extraction from multiple production and test servers as well as research regarding table structures and relationships
- Improvement of client reporting processes and data integrity when needed, including database changes related to field size, data mapping and resolution of data redundancy issues
- 1,200+ hours of project experience obtained toward CAPM (Certified Associate in Project Management)
Eagle Hospital PhysiciansFinancial Analyst - Revenue Cycle
Jan. 2013 - Dec. 2013- Direct coordination of reporting needs and issue resolution with third party billing company
- Reconciliation of data from multiple sources to ensure consistency - Creating and updating various reference documents, including active physician NPI number listings by site (updated quarterly) and Medicaid/Medicare allowable rates by CPT code (region specific for each hospital system client) utilizing resources such as CodeItRight Online
- Developing new reports and restructuring reports utilizing Excel, including extensive use of pivot tables, vlookups, charts, and high-level nested formulas; including but not limited to: o Monthly AR Trend Report – Restructured for ease of updating and data accuracy with multiple control checks - Utilizing background data files, process for this report reduced from almost 2 weeks to approximately 3 days
o Monthly Waterfall Report – Revised to more accurately compare site specific charges and payments by date of service – Reduced process for monthly completion from two weeks to approximately 4 days
o Other various monthly reports created separately for both internal and external clients
o Tracking and prioritizing a large list of monthly and project tasks for the entire Revenue Cycle Department
o Ad hoc reports as requested by hospital system clients and senior management (including VP of Revenue Cycle and Chief Financial Officer)
o Data compilations and reconciliation of data from various sources for specialized reports
PartnerSource, Inc.Technical Risk Specialist - Information Services
Apr. 2010 - Jan. 2013Dallas, Texas- Support Insurance/Consulting service aspects of Texas Nonsubscription as member of IS team
- Establish and build relationships with Third Party Administrators (TPA’s)
- Establish data access for new clients and resolve data-related issues, including creating new processes to better streamline the data retrieval process
- Record detailed Information Service processes and create reference documents for all TPA and client information needed to follow the documented processes
- Develop reports utilizing Excel with extensive use of pivot tables, vlookups, charts, and high-level nested formulas, including: o Quarterly loss run reviews for approximately 35 clients
o Annual statistical reports o Texas Nonsubscription versus Workers' Compensation savings charts
o Underwriter reports for insurance renewal process
o Industry-specific benchmark studies – Most Recent Study: Retail Industry Nonsubscription programs (using information for 32 participating companies)
o Ad hoc reports as requested by clients
o Actuarial analysis
o Data compilations from various sources for specialized reports, such as reports regarding various non-related lines of coverage
CONEXISReporting Analyst
May. 2008 - Apr. 2010Irving, Texas- Researched table structures and data elements using SQL Server Management Studio (read only) in order to improve accuracy and better streamline queries used in Access to create existing reports and to create new queries/reports as needed
- Developed new reports utilizing extensive Access queries to pull raw data from ODBC/SQL Server database
- Automated monthly reports utilizing Access and Excel, including reports using data pulled from SharePoint and/or data obtained from ODBC connection to SQL Server DB
- Built and maintained Finance SharePoint intranet portal
- Automated business processes utilizing SharePoint and InfoPath
- Prepared and taught classes regarding new technologies and processes for the finance department
- Prepared reports with information obtained from Great Plains
- Performed adjustments in Great Plains and company-developed ECM software
- Completed monthly and ad-hoc Client COBRA, Flexible Spending, and Premium Account Reconciliations
- Completed and/or automated monthly Billing Reports and Client Fee Reports
- Served as initial member of specialized client reporting team
CartusReporting Analyst
Mar. 2007 - May. 2008- Promoted from International Resource Team Administrator May 2007
- Ran and analyzed reports utilizing Access and other database programs
- Created new reports in Access and Excel as requested
- Completed assorted special projects in PowerPoint, Excel, and Access
- Submitted expense reports for VP
- Organized travel arrangements for VP
- Posted Job Requisitions utilizing internal system
- Submitted Move/Add/Change forms to security and facilities
- Provided backup for International Resource Team (IRT) Admin, IRT Specialists, Corporate Team Admins, and Senior Reporting Analyst
- Assigned files to specialists and activated services as needed
- Performed all IRT reporting
Intch is a Professional Networking App for the Future of WorkSee more people like Tiffany on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
489368 people
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
18
Senior Software Engineer @ EarnIn
68882 people
18
Senior Software Engineer @ EarnIn
42
Senior Mining Engineer @ Riot blockchain
21
Technical Support Engineer - L2 @ Axis Communications / 2N