TECHNICAL SKILLS:

• Tableau 7.0,8.1,9.0,10.0
• Tableau Server 8.0, 9.0,10.0
• Alteryx
• Snap Logic
• Toad for Oracle
• Microsoft Visual Studio 2008, 2010, 2012, 2015, SQL Server 2008, 2010, 2012, 2014, 2017, Access, Excel, Oracle, Web API, C#, XML, JSON, HTML5, HTML, CSS, JavaScript, JQUERY, PHP, Python

EXPERIENCE:

Confidential

Network Executive

Responsibilities:

• Produced visual analytics to strategically establish new standards across the network related to compensation structures, unit cost, target preference and contract terms.
• Partnered with Clinical Analytics to create utilization management dashboards that highlighted opportunities to engage with facilities to mutually achieve better outcomes for members.
• Created reporting around productivity metrics in order to assist manager level associates manage work strategically.
• Produced visual analysis to maintain access to services
• Designed and automated process of contract completion with the use of Snaplogic an elastic cloud application to ETL data from email boxes into task list. Created front end forms to allow associates to complete task and track work. Designed reporting via Tableau to monitor completion rate and strategically deploy resources to manage workloads. This resulted in a 40% reduction of workload creating efficiencies in administrative cost.

Confidential

Business Intelligence Consultant

Responsibilities:

• Successfully completed analysis of request for proposal data for TRICARE bid. Gave strategic direction for competitive discounts. Created Fee Schedule Modeler, tracking system and reporting to support contracting efforts and strategic decisions by leadership to successfully implement the TRICARE network.
• Successfully completed system migration which required extracting, and analyzing millions of lines of contract rate data to determine standardized rate structures vs. variant rates to efficiently move our claims payment processes into the primary claims payment system which created savings in administrative cost.

Confidential

Business Intelligence Analyst

Responsibilities:

• Automated banking process for contract negotiation that was previously done in Excel and VBA by importing data into Access and creating InfoPath frontend. Wrote C#, XML, and SQL code to automate banking calculations and designed dashboard in Tableau to fully automate report. Later transitioned database completely into SQL Server for seamless reporting and integration to other data tables which accumulated $20M in savings over a three year period and created savings in administrative costs.
• Developed and Created Automated tracking process that were previously done on individual Excel sheets and reported on individually. Developed and designed system to track expansion efforts using SQL queries, procedures, triggers, relational database, and a Tableau reporting end point to create a live tracking and reporting environment to enable real - time decision making for Senior Leadership. This reduced FTE resources by increasing efficiency in provider recruitment, reducing rework, and automating reports.
• Lead team of Analysts in the development of various market analysis dashboards in Tableau for contracting use to analyze markets and areas to focus. Wrote custom SQL to maximize efficiency and ran various ad-hoc requests to determine metrics to focus on.
• Lead analytic team in the creation of claims process which included writing custom SQL queries to export, transform and load claims data from company’s PLSQL Medical Claims database and imported them into SQL Server Behavioral Health database.
• Managed expansion efforts by creating SQL queries to identify new opportunities, generating analytical interactive Tableau dashboard reports to maximize current opportunities, and providing clear, analytical reports for senior management to track progress and make critical decisions.
• As a SharePoint site collection administrator for the Network Operations department, developed and designed several forms, processes, site pages for informational, organization, and engagement purposes. Leveraged SharePoint lists/libraries and custom workflows to create solutions focused on request processing, dashboards and reporting to Senior Leadership.
• Lead the development and design of project which allows users to locate services for a member with SQL functions and interactive Tableau mapping front end that allows a user to select a zip code and radius to generate a map and listing of service providers within the network based on their product, specialties, and other attributes.
• Created, Designed and implemented provider intake request process which involved training and collaboration with several departments in the organization. Leveraged InfoPath, SharePoint, and SharePoint Designer to create custom SharePoint workflows to help improve the efficiency and tracking of provider relations request based on business logic. This has automated the process and increased efficiency of assigning work that comes into the department. Also connected the SharePoint list data to tableau software to create a dashboard report to track tasks that are outstanding or closed, turnaround times, trending requests, etc.

Confidential

Account Installation Specialist

Responsibilities:

• Designed and administered SharePoint site collection for the department. Created solution with InfoPath front end which migrated reporting from excel to SharePoint environment.
• Developed Time Clock solution for employee punch inn/out tracking which migrated reporting from Excel to SharePoint environment with an InfoPath from frontend data entry point.
• Developed Stat Reporting solution for associates to report and track production which migrated reporting from Excel to SharePoint environment with an InfoPath frontend data entry point.
• Managed several products across several states regarding member’s benefits and eligibility. Responded to helpdesk tickets and benefits requests. Responsible for interpreting, analyzing member benefit documents and maintaining data integrity in the system
• Trained 30 new associates for a complete system rebuild of member benefits.

Confidential

Customer Service Specialist

Responsibilities:

• Assessed and process requests from members and providers related to behavioral health claims, certifications, and applications to the provider network.

Confidential

Banking Specialist

Responsibilities:

• Provided support in approving refunds, supervisor calls, loan accounts, charge off accounts, card approvals, new accounts, and account closing.