Nicholas Davies

About Nicholas Davies

Advanced Microsoft Excel skills (VBA Programming, Vlookup, Pivot Table) SQL…

Experience

1. Business Analyst Iv

   Centene Corporation

   Feb 2018 — Present

   Identify opportunities for process redesign to increase claims auto-adjudication rates Web Page Design / built 3 training websites within SharePoint using HTML, CSS, JavaScript, PNG, & MP4 files Recorded 14 training videos with Zoom to be embedded within my SharePoint pages Serve as the subject matter expert on two behavioral health Medicaid markets (Missouri and New Hampshire) Resolved business-cirtical problems for two Medicaid markets (Iowa and New Mexico) as part of an ad hoc SWAT team Serve as the subject matter expert on SQL for my team and other departments (Joins, Count, Avg, Sum, Case Statements, Outer Query & Subquery) Automated routine tasks with VBA programming Performed root cause analysis on mispriced claims for Provider Reps, and worked with the relevant departments to resolve those issues Review provider contracts and design flow charts to aid in co-worker understanding of the contracts Lead one-on-one training sessions with new employees Identified gaps in training and implementeded improvements in training programs Recorded YouTube training videos for co-workers (how to do Vlookups, Pivot Tables, custom functionsin VBA, etc)

Skills

• Adobe Livecycle Designer
• Comic Book Illustration
• Bloomberg Terminal
• Cartoons
• Sharepoint
• Visual Arts
• Art
• Wordpress
• Visio
• Economics
• Microsoft Sql Server
• Javascript
• Book Illustration
• Access
• Microsoft Excel
• Microsoft Word
• Financial Analysis
• Outlook