PROFESSIONAL SUMMARY:

• 8 years an analytics professional with leadership, management, analytical, and problem resolution skills
• 5 years of Project Oversight experience at Confidential and Confidential Health Plan
• 9months of JIRA experience
• 2 years agile environment experience
• 7 years experience in Data Warehousing,
• 8 years SQL Data Query writing for data validation
• 8 years experience working with SQL and in Requirements gathering and implementations
• 8 years experience with end results
• 6 years experience with MS Visio and MS Project
• Proficient in MS Excel and Word
• Capable of bridging technology and business goals to provide productive solutions.
• Demonstrated success in streamlining existing operations and upgrading applications.

TECHNICAL EXPERIENCE:

Languages: SSIS, SSRS, SSAS, SQL Server 2012

Applications: Analytics Administrator, Crystal Reporting, IDQ, IDX, Oracle, MS Office Tools, SQL, FTP, Tools, QNXT/ Confidential, Cognos Impromptu, Medical Intelligence, Report Builder, McKesson Applications (CCMS, Interqual, DM, CRMS, VITAL, Eloquence), MS Office - Excel, Word, Visio, MS Project, JIRA, Netezza, Toad

Operating Systems: Microsoft Windows OS, UNIX, MAC OS

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Intelligence Analyst

• Project activity coordination, assembling various project artifacts and documents
• Meeting participation, coordination and facilitation, documentation deliverable creation
• Conducting reviews throughout the implementation period and into the post-implementation phase.
• Serves as liaison between departmental team business owners, end users, IT, Claims and Clinical.
• Responds to ad hoc requests for support, reports and analysis using Cognos or SQL queries.
• Supports departmental management team by providing project status information.
• Maintains task queues in JIRA and track the assignments of other assigned individuals to the project.

Confidential

Business Analyst

• Provide data integration solutions for application import process
• Analyze current state business and make future state recommendations
• Developed and maintained project plans and/or tasks lists using Microsoft Excel
• Project manager for onboarding new applications

Confidential, Denver, CO

Business Configuration Analyst

• Developed SQL queries for quality and assurance of file transfers and data integrity
• Daily use of Excel and MS Access to dump the data and analyze based on business needs
• Developing environments to be used for testing and a range of functionalities per technical specifications.
• Configured Qnxt for the member benefits and claims teams.
• Reduced Qnxt ticket backlog by 50% to help the company meet goals
• Configure healthcare insurance payer systems
• Analysis of benefit plans and configuration of benefit plans/rules
• Analyze and create data workflows

Confidential, Richmond

Manager

• Daily distribution of data cleanups based on ftp process errors using SSRS
• Developed automated SQL queries to write deliverables for the state agency which have received 100% accuracy
• Worked on claims, provider, member data extracting and importing data from various sources such as flat files
• Data mapping determining what data will be extracted from an internal data warehouse, transformed and sent to an external party using MS Office/Visio/Excel
• Performed large data mining efforts on Claims and member health HIPPA data using complex SQL queries
• Analyzed business requirements, system requirements, data mapping requirement specifications
• Responsible for documenting functional and secondary system requirements within MS Excel
• Developed error subscriptions which in turn increased annual authorization issue detection by 90% using SSRS
• Slashed clinical staff overhead by implementing an automated mailing process that showed 10% daily time reduction
• Successfully Implemented new lines of business which increased company’s by 10,000 members
• Ignited a team of business analysts for numerous Software and Claims system implementations
• Created sql based business logic to ensure compliance with all mailings based on
• Lead team of business analysts for QNXT systems conversion with thousands of data points
• Lead daily scrum meetings for project implementations

Confidential, Richmond

Data Analyst

• Transfer member and provider HIPPA data and demographics through secure nightly FTP process
• Performed large data mining efforts on Claims and member health HIPPA data using complex SQL queries
• Responsible for analyzing various data sources such as flat files, ASCII Data, Relational Data (Oracle, MS SQL Server) from various data sources.
• Wrote logic to create automatic letters sent to members, providers, hospitals using SQL/ Eloquence
• Delivered files in various formats (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Daily FTP process analysis identifying and correcting errors and fallout
• Creation of analysis reports using SQL to identify data discrepancies caused by FTP failures and errors
• Assistance with design, development and implementation of the Clinical Application Software servicing 200k members
• Systems expert team lead for QNXT claims configuration implementation
• Team Lead for ICD 10 system configuration
• Implemented CCMS software for launch of Inova Health Care
• Monitor daily flat file transfers of provider payments and demographics within QNXT and IDX

Confidential, Richmond

Data Analyst I

• Created regulatory reports for departmental business analysis using SQL
• Implemented Provider Data reconciliation reporting that saw a 25% decrease in provider discrepancies
• SQL analysis slashed overpayments to vendors with estimated savings of 500k
• Project lead/Manager on individual consideration rate project
• Developed and enhanced existing corporate metrics for the department president and Directors SQL/Excel
• Monitor daily flat file transfers of provider and hospital payments and demographics
• Daily use of Excel and MS Access to dump and analyze data based on business needs
• Gather business intelligence and reporting requirements using MS Office Tools