SUMMARY

• Senior Business, Systems, Technical Analyst and Project Manager with 25 years of experience achieving optimum levels of competitive advantage and profitability for an organization with high emphasis on quality (Analytics)
• Specialist in the effective use of business process engineering to leverage information for the business purpose it serves and the secure sharing of information inside and outside the organization (Information Management)
• Technical Expert in the software life cycle: planning (as - is to future state or commercial off-the-shelf deployment), analysis, design, development, testing, implementation and maintenance (Information Technology)
• A Subject Matter Expert with inpatient, outpatient and ancillary (LAB, RAD, PHARM, etc.) core functions encompassing: claims, billing, financial forecasting, legal, quality, compliance, access to care/pt. population (Healthcare Operations)
• Business Requirement Elicitation & Documentation (BABOK)
• Management of ICD-10/5010/HEDIS Projects
• Database Design/Development, T-SQL Query, Stored Procedures, Functions and VBA Scripting
• Electronic Medical Record Analysis/Development/Implementation/Maintenance
• Systems and Quality Processes Review (Modification to Organizational Workflow)
• Use Case Diagraming/User Stories to include End User Go-Live Support
• Pharmaceutical Analytics - Medicare Part D (PDP) via Prescription Drug Plans and Advantage Plans (MA-PD)
• Root Cause and Impact Analysis with Process Mapping
• Joint Application Development (JAD)
• Data Extraction, Transfer and Load (ETL)
• Demonstrated understanding of statistical concepts (regression, correlation, analysis of variance, etc.)

TECHNICAL SKILLS

Platforms and Collaboration: MS Windows (10/7) and x32/64-bit, MS SharePoint 2014 and Team Foundation Server

MS Office: Word/Excel (VBA)/PowerPoint/OneNote/Publisher/Outlook/InfoPath/Skype/OneDrive/Office365

Database: MS Access (VBA)/MS SQL Server 2005-2014/Teradata/SalesForce/Fieldglass

BI Tools: SQL 05-14/SAS/Bus. Objects/Cognos 10/Crystal Reports/SSIS/SSAS/SSRS/Tableau 9.1

REQ Tools: JIRA/HP Quality Center 9.2/HP ALM

EMRs/Claim: EPIC/QNXT 4.7/AHLTA/PowerMHS/IKA/Cerner/Allscripts/Meditech/NexGen

Publishing: Adobe Acrobat Pro/HTML/Corel Draw 9.0//Uberflip/CAD/Photoshop 5.5/PageMaker/Illustrator

DoD/MHS: PEPR/PPS/MHS Insight/MDR/M2/MCFAS/PDTS/EASIV/DEERS/TEDS/CCDD

PROFESSIONAL EXPERIENCE

Confidential

Project Manager/Senior Business Consultant

Responsibilities:

• Initiated, planned and executed specifications per project/service agreements such that Key Performance Indicators were met. At all times assured effort, estimation and scheduling were on time.
• Analyzed large datasets to Geomap service station throughout Arizona. Which included a compliment of reporting capabilities for the end client that were developed via complex queries in a SQL Server environment.
• Built the infrastructure (data warehouse) to hold business metrics. This led to successful management of county and state adherence and tracking throughout the life of the project.
• With my proprietary tool, led conference calls to gather requirements for the project completion (high level business, business, functional, non-functional and user requirements).

Confidential

Senior Analytic Advisor

Responsibilities:

• Managed analytics and outcomes for 12 Health Plans across 7 states via EXCEL (VBA), SQL and SSRS reporting assuring compliance with Federal and State contractual requirements
• Reviewed and provided documentation for maintenance and distributed of Medicare Part D claims detail file for integration into enterprise wide database BI
• Modeled data using MS Excel (VBA), Access (VBA), SQL, and/or other data ware house analytical tools
• Assisted with training and mentoring other Data Analysts
• Assisted with determining work load and related activities for other Data Analysts

Confidential

ICD-10 Readiness Analyst/Coordinator

Responsibilities:

• Independently and in cooperation with the Project Management Officer used MS Project Professional 2010 for the effective management of this important and highly visible project
• Delivered effective presentations that offered immediate insight and recommended task planning, resource allocation, expenditures and impact assumptions for the project
• Used Excel (VBA)/Gantt/bar/milestone charts for reporting dependencies and/or constraints among activities and network/production schedules that where united to show an overall integrated Master program schedule
• Maintained and advanced the ICD-10 project to include support of physician training, joint ventures, benefit management as paired with new code set and business vendor readiness programs

Confidential

Senior Business Analyst

Responsibilities:

• Worked closely with Stake Holders, Development Team and Software Testing team takingownership of user requests to ensure that timely, complete solutions where delivered to the user for Pharma Regulatory Compliance
• Utilized JIRA to advise Business Stakeholders and current/future benefits management suppliers (Merck, AmgenBiogen, Genentech, Ispen, Novartis and Takeda) on ways to optimize their Reimbursement processes through root cause analysis
• Planned, facilitated and coordinated User Acceptance Testing (UAT) using Excel for universal template
• Led comprehensive preliminary testing and produced all entrance criteria documentation required to promote products under development to Production with both onshore and off-shore resources