Data Analyst Ii

Anthony Louis Donati

**** *********** *****

Coral Springs, FL 33065

******@***.*** (e-mail)

561-***-**** (cellphone)

Employment

Healthcare Specialist

United HealthGroup (formerly Change Healthcare)

11/2018 – 10/2024

Support ME Operations (advocates and case coordinator agents, team leaders, supervisors, managers, directors, and VPs) with SAS reporting on key Cisco telephony metrics and summarized case progression lifecycle metrics.

Solely responsible for developing, enhancing, and troubleshooting 100+ on-demand operational reports in the SAS portal, as well as several internal and external reports scheduled for auto-delivery on shared drives, secured FTP locations (for clients), and via secured e-mail. Also, on-the-fly adhoc reporting requests were completed as needed.

Mentor programmers in the Philippines (Manila, Cebu City) and in the US – provide training sessions of correct business/technical practices (build and configure new reports in the SAS Management Console, update and/or revamp existing “dinosaur” reports with current SAS/SQL logic, and troubleshoot coding errors on a case-by-case basis.

Data Analyst II

Catholic Health Services

8/2013 – 09/2018

Produce weekly, monthly, quarterly, and annual reporting for the Corporate Office (President, COO, VP’s, Directors), SNF/IRF/ALF administrators, community liaisons in the field, and AHCA regulatory agents.

Present aggregated AHCA inpatient discharge data by calendar year and quarter, county, hospital, payor, discharge disposition, service type, principal ICD-10 diagnosis codes, DRG/MDC categories, CPT code ranges, attending/referring physicians, and revenue codes. Data was packaged in MS Excel PowerPivot dashboards, Crystal Reports, and Crystal XCelsius.

Maintain knowledge and documentation of business unit workflows, application module functionality (in KNS, HMIS, AllScripts, and SunCoast), and database schemas.

Test and evaluate quality and integrity of all published CHS reports, often cross-checked against “Bible” reports. When needed, examine reports to determine root causes for issues and best courses of action for resolution.

Healthcare Analyst II

Molina Healthcare of Florida, Inc.

10/2008 – 10/2009

Provide Finance Department with membership and revenue breakouts by plan (TANF, SSI), age, gender, and county to assist with monthly budget trend reports. Also, built custom SQL queries and Crystal/MS Excel reports to reconcile new, continuing, terminated, and retroactive claimants. Claimant volume and revenue projected with respective monthly 834 (eligibility)/820 (revenue) AHCA audit files from CMS.

Develop data integrity reports for various departments (Finance, Member Services, Pharmacy) to discover discrepancies with billing and payments in relation to CMS provider fee schedules, data-entry errors by call center representative, and missing pharmacy data elements uploaded from 3rd party vendors.

Manage/coordinate meetings with corporate IT programmers to ensure timely submissions for monthly recurring pharmacy, claim, and encounter data to AHCA.

Informatics Analyst

Aetna, Inc.

06/2006 – 07/2008

Sole creator of the “Aetna” branded template used for all of Aetna’s Crystal Reporting needs; artwork/framework included various types of borders(rounded-edging, color filling, shadows, etc.) for the page headers/footers, Aetna logos, report id subreports, Aetna confidentiality notices, section suppression for “No Data” message functionality, page numbers, and function-driven “data date” for live vs. 1-day old reports.

Built the Company Configuration Summary report, which was driven by a suite of multi-linked subreports (auto-driven by stored procedures), which contained client, claim, product, report/market segment, and plan data.

Utilize Business Object’s Crystal Management Console(CMC) to deliver operational, payment, Book of Business (all clients – summary), invoicing, and quarterly summary reports for internal/external clients via the web.

Healthcare Economist

Vista Healthplans, Inc.

11/2004 – 06/2006

Extensive experience creating parameterized dashboard reports utilizing the most advanced Crystal Reports techniques available. Skills include drill-down with hyperlinks, on-demand subreports, alerts, automatic & manual crosstabs, pie charts, bar and line graphs, group/record sorting and filtering, advanced conditional formulas, TopN summaries, and running totals.

Utilize SQL Server – Query Analyzer to develop and enhance stored procedures with multiple table joins, user-defined functions, Oracle open queries, nested shell scripting, complex case statements, datatype conversions, along with table/field updates.

Create MS Excel pivot tables based on V-lookup functions and SQL Server ODBC connections.

Education

Bachelor of Science in Applied Mathematics

University of Florida, Gainesville, FL

Honors: Pi Mu Epsilon National Honorary Society

Overall GPA: 3.6

Relevant Coursework: Numerical Analysis, Linear Algebra, Numerical Linear Algebra, Abstract Algebra,

Mathematical Statistics, Calculus II & III, Advanced Calculus I & II, Sets & Logic, Numbers & Polynomials

Skills

Languages : SQL, SAS, Redshift, Java, MatLab, C.

Databases : MS SQL Server, Amazon Redshift, Cisco, Oracle, MS Access, Mosaix

Systems : Windows, MAC-Apple, UNIX, AS/400.

Tools : MS Office XP/Project/Sharepoint/Visio, SAS, SAS Web Portal, PowerBi, Tableau, Crystal Reports,

Crystal Management Console (CMC), Oracle Financials, SQL Enterprise Manager/Query Analyzer,

Monarch, MatLab, ProClarity.

Contact this candidate