PROFESSIONAL SUMMARY:

• Strategic and results - oriented Senior Data Analyst with 15+ years of success analyzing, summarizing, and interpreting financial and statistical data.
• Proven outstanding technical skills in querying and manipulating data using a variety of tools. Excellent critical thinking and problem-solving skills.
• Financial reporting
• Trend analysis
• Performance metrics
• Price/cost/margin analysis
• Ad-hoc reporting
• PL-SQL/T-SQL/SAS coding
• Data mining
• Dashboards (Power BI, Tableau)
• Budgeting and forecasting
• Spreadsheet/report design
• Medicare/Medicaid programs and regulations
• Medical claims/encounter data
• Clinical coding systems (ICD-9, ICD-10, CPT, DRG, APC, ASC)
• Managed care operations
• Medical bill review
• based pricing
• Direct provider contracting
• Healthcare pricing models

TECHNICAL SKILLS

• SAS Software, T-SQL, PL/SQL
• Power BI, Business Objects
• Cognos, Tableau, MS Office Suite
• (Excel, Word, Access, PowerPoint)
• Outlook Express, SharePoint
• Peachtree/Sage 50 Accounting
• PeopleSoft Query, JIRA

WORK EXPERIENCE:

Confidential - Peachtree Corners, GA

Senior Healthcare Data Analyst

Responsibilities:

• Have successfully helped 15+ clients in various industries with reporting/data analytics requests.
• Advise companies on reporting solutions to help improve efficiency and automation.
• Create visually impactful dashboards in Power BI for sales and marketing teams, finance, etc.
• Extract, interpret, and analyze data to identify key metrics and transform raw data into meaningful, actionable information.
• Use quantitative data to develop an understanding of customer behavior, demographics, and lifecycle.
• Present detailed reports and explain results to various levels within organizations.

Confidential - Peachtree Corners, GA

Senior Healthcare Data Analyst

Responsibilities:

• Analyzed client health claims data to show savings from various cost containment solutions, including -based pricing (RBR), medical benefits review (MBR), out-of-network solutions (OON), and direct provider contracting (DPC).
• Provided sales team with region-specific analytics and identified profitable revenue growth opportunities/insights.
• Developed interactive Power BI dashboards for the visualization of key performance metrics and trends.
• Contributed to the implementation of Medicare pricing tools for ASC, APC, DRG, and Professional claim services.
• Wrote SQL scripts in SQL Server database for adhoc and other types of reports.
• Maintained and updated reports accessible on company portal to ensure that clients have insight into the performance of their health benefit plan(s).
• Mentored and instructed junior analysts on various aspects of healthcare and data analytics.

Confidential - Stone Mountain, GA

Senior Cost Analyst

Responsibilities:

• Supported the IT team with transition from Sage 50 Accounting software to Acumatica ERP System.
• Modified SQL queries to pull specific data from Sage Containers and Report Manager applications.
• Imported data from Sage into Power BI and created custom monthly report summaries and dashboards.
• Provided written and verbal analysis of costs related to specific jobs and customers to management and made suggestions for further analysis.
• Instructed accounting team on process to update monthly reports.

Confidential - Atlanta, GA

Data Analyst

Responsibilities:

• Supported the Construction Services team with the development and maintenance of various business models.
• Collaborated with team members to improve processes which support the natural gas pricing and supply management platforms.
• Developed strategies to understand and prioritize data needs for both internal and external clients.
• Designed, developed, and analyzed reports to measure business performance and understand cost drivers.
• Conducted ad-hoc analytics using PeopleSoft Query reporting tool to support data-driven insights into claims data.
• Assisted with preparation of annual budget and forecast.

Confidential - Athens, GA

Contract System Specialist

Responsibilities:

• Designed and developed a new automated system to manage, review, and maintain all provider and vendor contracts.
• Set up profiles containing comparative information on contract financial terms, key provisions, and performance.
• Established a more efficient invoicing and payment system.
• Created a system for analyzing quotes, bids, and proposals for the implementation of new contracts.
• Set up system alerts to ensure the timely completion of the contracting process for renewals.
• Provided instruction to the staff on how to utilize the new system.

Confidential - Atlanta, GA

Senior Medical Economics Analyst

Responsibilities:

• Coded and implemented SQL and/or SAS code to obtain data for reporting and analysis.
• Designed standard reports included in month-end reporting package.
• Created complex Cognos reports using lists, crosstabs, charts, and graphs.
• Created Cognos Dashboards for presentation of key metrics to finance executives.
• Provided financial support and analysis for strategic business decisions and medical cost savings initiatives.
• Analyzed and interpreted variances in monthly/yearly trend reports and provided drill downs into specific data issues.
• Analyzed proposed contractual rate changes to determine financial impact on medical loss ratio.
• Measured, monitored, and communicated provider settlements related to alternative payment models.
• Assigned as the analyst for Georgia Quality Assurance team. Provided reports to measure HEDIS compliance and to ensure the availability of sufficient provider resources for our members.
• Completed ad-hoc analysis of data to support both internal and external customers.
• Created and maintained documentation of procedures to help ensure consistency and accuracy in report completion.
• Participated in critical review and revision of existing systems and processes.
• Mentored and trained co-workers on query writing and report presentation.
• Provided clear and precise written summaries of reports. Made suggestions for further analysis when necessary.

Confidential - Atlanta, GA

Financial Analyst

Responsibilities:

• Updated weekly and monthly trend reports in Business Objects and provided written analysis to upper management.
• Analyzed claims data of prospective clients to show potential savings opportunities and secure new business contracts.
• Completed complex ad-hoc requests requiring extensive knowledge of the claims database and considerable skill writing SQL code.
• Ran numerous queries to test that new rules for correct coding were properly implemented.
• Created invoicing program in Business Objects and established review process for monthly invoices to ensure accuracy.
• Trained all new analysts on company processes and the use of SQL Navigator and Business Objects reporting tools.