Cindy Edwards Email & Phone Number

Grand Rapids, Michigan, United States

• Analyze report requirements and identify future data integrity problems before work begins. • Work with internal resources to ensure report requests are started, updated and completed in a timely manner.• Assist internal resources and customers navigate roadblocks or slowdowns related to reporting projects.• Act as a central point of contact for coordination between IT teams and reporting projects and issues.• Utilize available tools such as Power BI, SQL, SSRS, and Excel, to design, document, develop, and test complex clinical, financial, human resource and quality reports from multiple data sources and types (database, flat file, and spreadsheet).• Assist staff to integrate data across applications or service lines as needed. Recommends and initiates improvements in data integration, which minimize duplicative entry and maximize retrieval of useable information.• Prepare and maintain documentation related to solutions, scripts and queries. This will include documentation of all changes to the report and dashboard design, testing, validation and implementation.• Assist in the creation of appropriate report and dashboard access security practices and ensure compliance within the team.• Identify system changes to improve internally integrated system data to meet business needs and make recommendations changes that could improve reporting capability.• Research current and emerging technologies related to areas of report writing, through independent research, attending relevant conferences, trade shows and professional organization meetings. • Mentor, train and coach less experienced members of the IT team in the technical and soft skills related to report writing.

Grand Rapids, Michigan, United States

Responsible for performing routine yield analysis to identify trend discrepancies in allowed amounts. Takes appropriate action to resolve.Revenue Management analytical analysis and reporting.Analyzes changes to CPT codes impacting fee schedules by utilizing appropriate reference materials, internet sources, seminars and publications.Prepares a payer scorecard across the service lines by CPT code to compare allowed amounts.Utilizes the CMS RM tab reporting feature to ensure compliance of contract terms.Responsible for double checking the accuracy of all insurance fee schedules in the billing system based on the payer’s fee schedule release dates.Responsible for reviewing new/updated insurance fee schedules for all contracts to ensure they are updated or programmed in the billing system per the direction of the contract.Assist the Director of Revenue Integrity in program fee schedule changes for the new fiscal year based on the approved methodology approved by CFOProvides assistance to staff from all internal & external locations regarding fee schedule concerns, questions and provides instruction.Collaborates with billing system team to troubleshoot fee schedule related issues until a resolution is agreed upon.Responsible for other designated projects as assigned.Responsible for taking on and learning the billing system for aspects impacting revenue to understand and get at root causes of issues.

Harahan, La

• Translate insurance contracts into data frameworks and development SQL code in MS SQL Management Studio to model expected payments for the purpose of identifying underpaid accounts and autogenerating detailed note to aid auditors in collection efforts.• Translate the Medicare Inpatient Prospective Payment System (IPPS) into data frameworks and development SQL code in MS SQL Management Studio to model expected payments which priced accounts with 99% accuracy. • Assisted in database construction and consultation of best practices on database design.

3017 Lime St, Metairie, La 70006

• Generated standard reports and present analysis to clients. • Collected data and performed analysis for ad hoc reports using query and data manipulation tools such as MS SQL Server Management Studio, MS SSRS, MS Access, and MS Excel. • Created more effective presentation platforms and time efficient procedures for reports including the implementation of pivot tables, combo boxes and macros resulting in user friendly reporting and analysis tools. • Incorporated statistics into standard reports by calculating standard score for monthly trending within facilities resulting in rapid detection of erroneous data from both frontend users and backend database anomalies.• Documented project procedures on new and existing reports resulting in easy transition of projects and precise project specification.• Trained junior employees on tools such as MS SQL Server Management Studio, MS SSRS, MS Access, and MS Excel. • Assisted in proprietary program beta testing and the on going data integrity monitoring.

Frisco, Tx

• Supported the BI documentation team by communicating relevant analytical knowledge to the BI team and acting as a liaison between the BI team and the analysts resulting in efficient documentation of reports from the Analytics Department. • Provided quality assurance by comparing the developmental BI tool data to existing BI solution data resulting in the discovery of data, design and functional anomalies with the tool.• Maintained ongoing documentation of functional and data changes to reports waiting to be implemented in the BI tool allowing the project to move forward without rework.

• Created macros to perform regression and forecasting analysis in Excel for the purpose of predicting volume for budgeting, resulting in a user-friendly report with selection capabilities that allows the end-user to define criterion for the model and view customized predicted results both numerically and graphically.• Automated, tested and deployed project predicting the impact to revenue and bad debt due to shifts in ER level of care distribution across facilities by utilizing trending data of patient volume by payors, resulting in accurate predictions of projected yearly budget and financial impact.• Volunteered to participate on the intranet project team during downtime, learned PHP by deciphering code and asking select questions to teammates, resulting in producing the first report to support multilayered data presentation in the department.• Lead Centra training classes for the Analytics Department on the creation of Excel reports utilizing combo box technology and on the automatic creation of a statistical anomaly summary used on monthly trending data through the use of standard scores, resulting in easy detection of suspicious data and in greater productivity of the Analytics Department as a whole.• Analyzed breakdowns in the functionality of reports by deciphering the VBA code, resulting in continued support of reports after attrition. • Mentored two analysts while acting as a Team Lead resulting in increasing their knowledge of the business and in the functionality of reports, simultaneously increasing their productivity and job satisfaction.• Documented project procedures on new and existing reports resulting in easy transition of projects and precise project specification.• Facilitated meetings with senior management.• Provided statistical consultation to senior management.

• Generated standard reports and present analysis to clients. • Collected data and performed analysis for ad hoc reports using query and data manipulation tools such as MedeFinance, Hyperion, ShowCase, AS400, Access, and Excel. • Created more effective presentation platforms and time efficient procedures for reports including the implementation of pivot tables, combo boxes and macros resulting in user friendly reporting and analysis tools. • Incorporated statistics into standard reports by calculating standard score for monthly trending within facilities and normalized metric analysis across facilities resulting in rapid detection of erroneous data from both frontend users and backend database anomalies.• Acquired Yellow Belt certification in Six Sigma.• Anticipated the needs of the customer by creating historical summaries of standardized reports resulting in a top requested trending report.• Prepared meetings notes and distributed them, resulting in greater communication and documentation of ongoing project development.

• Collaborated with a three person analysis team to produce more than 60 high dimensional cross tabulation reports in two months resulting in the first project finished in the history of the company with all reports completed on time.• Provided quality assurance by detecting design and functional anomalies in survey questions and the data resulting in creating the most accurate reports possible.

• Created a statistical reporting system of branch daily deposits that calculated the percentage deposited per week by each branch and generated an overall performance of each branch for the year allowing VPs in the association office to monitor branch performance quantitatively.

• Facilitated functional requirements, designed, coded HTML delivery tool, performed user acceptance, launched, assisted and trained users, coded concept and semantic, analyzed data using statistical techniques in SAS and MATLAB, wrote reports and presented a 12 month free response text comprehension experimental project.• Provided quality assurance by designing and implementing software testing processes to expose design and functional anomalies.• Successfully implemented a novel diagnostic assessment tool that quantifies varying support for cognitive strategies exhibited in free response recalls of texts.

M.S., Cognitive Psychology

Activities and Societies: Graduate Student Council - Treasurer/Secretary/Internet Support (2001-2004) Library Committee - Member.

B.S., Psychology

A.A., Mathematics

Diploma Of Education, General