Manager, Business Intelligence Resume Example Family Health Network

MANAGER, BUSINESS INTELLIGENCE

Professional Summary

Industrious Business Intelligence Manager developing and preparing business intelligence processes and strategies. Adept at analyzing project requirements and developing appropriate strategies. Committed to ensuring adherence to data standards while utilizing business resources. Adept at finding inefficiencies in current processes and discovering low cost, reasonable, and actionable solutions.

Education and Training

CIS, July 2015Devry UniversityCIS

Associate of Arts : 6/2010College of Lake County - Grayslake, IL

Skill Highlights

MS Word, MS Excel(Pivot tables, Vlookups, and Macros), MS PowerPoint, MS Outlook, MS Lync, MS Access
MS Visio, Oracle, Lotus Notes
SQL Server 2014, SQL Server 2012, BIDS, Microsoft Visual Studio 2010, Microsoft Visual Studio 2013
SQL, VB.net, SSIS, SSRS, SSAS

Knowledge of metrics, analytics, and data analysis techniques
Knowledge of business analysis processes including the system development life cycle.
Excellent analytical skills;
Management of Cross-Functional Teams
Process Analysis & Redesign
Ability to absorb new technologies and information quickly;

Professional Experience

Manager, Business Intelligence
June 2015 to CurrentFamily Health Network - Chicago, IL

Managed BI team consisting of 4 Business Intelligence Analysts and 2 Business Intelligence Developers Assigned new production of reports based upon skill set and bandwidth Constructed SSRS Reports, SSIS Packages, and SSAS Cubes when needed.
Learned all aspects of the company including ICD-9 / ICD-10 Diagnosis Codes CPT Codes Claims Member Assignment State Re-Determination State Files 834 837 CMS Files TRR 837I, 837P files from Providers Care Coordination metrics and methodology UM Metrics and Methodology Production Reports Assisted in the implementation of a number of projects and systems Claims System MA Platform in existing customer management system CMS Annual Report NCQA Accreditation Effort HFS State Annual Report Monthly HFS Reports Monthly Internal Deliverables Daily Internal Deliverables Weekly Internal Deliverables Weekly External Deliverables Personally created 150+ reports across a number of different functions, including Production Reports of my own design for Enrollment and Claims Department Personally created multiple automation tools to drop files to the FTPs of Provider Groups.
Worked in cross-functional projects including but not limited to:
1) Distribution of admissions and discharge data on members
2) ICD-9 to ICD-10 Mapping process
3) Identification of diseases via ICD-9 and ICD-10 codes of encounters
4) Identification of diseases via pharmacy data such as Rx fill frequency, dosage, Rx GPI code, Rx classification, Rx category, and Rx purpose
5) Identification of Diabetics via A1C lab results and cross reference of pharmacy and encounter data
6) Identification of pregnancy via HcG lab test and cross reference of encounter data
7) Stratification using real health profile value and dividing health in 10 to 15 distinct categories. Health Profile is assigned values from 0 to 1000. High being 1000, low being 0. True risk is then assigned members rather than the normal statistical distribution of 2% high, etc.
8) Cross reference between membership population and provider (doctor) population using addresses - address, cities, postal code, and state data. Comparing distribution of specialists to the member population that needs them i.e. Pregnant women to OBGYN, Cancer patients to Oncologists, members who have heart disease to Cardiologists, etc.
9) looking at doctors panels and comparing to frequency of annual check-ups for members in panel, panels to periodic check-ups for diabetics. Verifying that doctors are seeing all patients in their panel in a timely manner.
10) Comparing member discharges to discharge assessments. Looking at the best ways to avoid a re-admission. Ways include: A) Verify member is taking prescribed medication B) Verify member saw their PCP within 14 days of discharge C) Verify all required lab tests are done timely
11) Look at member's with co-morbidities and compare lab data to pharmacy data to look for trends and predictive triggers are on stratification changes.
12) Look at Psychiatric/ Behavioral Health conditions and lab and pharmacy data for members with 2 or more behavioral health conditions
13) Look at members with Depression, Bi-polar disorder, Schizophrenia, Psychosis, and Dementia and review Rx and Lab data to compare to encounter data and compare to members with 2 or more behavioral health conditions
14) Look at Health Profiles of members with Asthma, Diabetes, Hypertension and compare stratification to members that also have behavioral health conditions.

Manager, Data Services
January 2014 to June 2015West Lake Financial Group - Buffalo Grove, IL

Managed data team consisting of 3 data analysts and 2 database developers.
Assigned new production of files based upon skill set and bandwidth
Worked with Account Teams to maintain good relationships with clients
Managed expectations on file deadlines and assisted with gathering requirements
Worked with President, VP of Operations, and CTO to improve processes to exceed deadlines
Created metrics and monitoring procedures to manage 250 + processes across 30 clients
Worked on implementation of new clients
Worked on correcting logic errors in the web sites with the web team
Worked with VP of Client Services to manage expectations across departments.
Developed SSIS packages with script tasks to streamline export processes.
Developed reports utilizing SSRS
Worked on architecting new database with CTO.
Created triggers, stored procedures, and BI files using SQL Server
Worked with SQL Server 2012
Worked with ETL process.

Data Analyst/SQL Developer
October 2013 to January 2014West Lake Financial Group - Buffalo Grove, IL

Worked on improving database efficiency by automating simple processes
Worked with client teams to update database on daily basis
Worked on development of new database structure utilizing SQL Server and cloud servers with focus on efficiency
Worked on improving database security by instituting security protocols for all users
Used troubleshooting techniques to resolve system, database, and server issues
Created triggers, stored procedures, and BI files using SQL Server
Created Databases in SQL Server at Account Team request
Worked with Web Team to connect Web Portal to Client SQL Server database
Constructed client specific Access Reports based on report specifications
Led Data Analyst team and allocated duties.
Developed reports utilizing SSRS
Worked with VP and President to attain best efficiency and meet deadlines for all clients
Worked with SQL Server 2012
Improved functionality of stored procedures with indexes
Worked with ETL process.

Benefit Analyst
July 2013 to October 2013AonHewitt - Lincolnshire, IL

Worked with developers to improve database efficiency
Created processes to shield database from corrupt data
Created reports to track enrollments, calls, and leads in call center
Created processes to improve database security
Created processes to improve sales and help enrollees find the best fit for their benefits
Documented system processes to improve system efficiency and functionality.

System Analyst/Business Analyst
July 2013 to November 2014Contracts - Amarac Technology Solutions - Chicago, IL

Managed several projects including creation of multiple applications
Managed requirements between end user and development team
Identified system issues and created testing protocols
Used system development life cycle to track project time line
Worked with SQL Server 2012
Utilized SQL queries to gather data to build reports
Developed SSIS packages with script tasks to streamline export processes.
Developed reports utilizing SSRS
Created triggers, stored procedures, and BI files using SQL Server.

Data Collections Specialist
April 2012 to July 2013EcoSure - Lincolnshire, IL

Worked with health departments in numerous states to obtain food safety inspection reports
Created presentations with MS PowerPoint analyzing food safety data for top QSR and FSR clients Led numerous quality control projects to improve efficiencies and eliminate waste in proprietary software Worked with developers to improve database efficiency
Created processes to shield database from corrupt data Integrated new client into database utilizing XML process requirements.
Constructed hierarchies with multiple nodes
Created processes to improve database security
Used troubleshooting techniques to resolve system issues Led team to improve core system weaknesses
Used Excel to track problems and documented issues on a daily basis
Used Excel to identify root causes of systems issues and relayed them onto the appropriate channels
Used Excel to run metrics and conduct analytics on industry data Utilized SQL queries to gather data to build reports
Created reports to track food safety violations across 30 clients with over 40,000 locations in total
Improved functionality of stored procedures with indexes.

Licensed Sales Professional
May 2010 to April 2012Mark Havlic Allstate Agency - Vernon Hills, IL

Identified customer needs and resolved telephoned problems on a daily basis
Provided service to clients by resolving their issues quickly and effectively
Worked with customers to handling ongoing issues with the Allstate website by helping reset passwords and user IDs
Provided service to the office network by repairing bad connections and re-booting system
Helped troubleshoot computers when they malfunctioned by identifying root causes of problems and ordering new parts when necessary
Sold insurance policies and achieved monthly sales goals.

Languages

Bilingual- Russian and English

Skills

VB.net; process optimization strategies, planning and implementation; automation tools; automation best practices and guidelines; understanding of benefits and benefits design - Health, Dental, Vision, Life, STD, LTD, LTC, Legal; knowledge of business analysis processes and guidelines; knowledge of Business Intelligence - implementation strategies, best practices, and training strategies; knowledge of call center processes and workflow and optimization opportunities, CMS (Center of Medicare and Medicaid Services) - knowledge of organization, compliance regulations; knowledge of CPT codes - uses in identification of diseases and common procedure categories; Knowledge of Client Management processes and strategies; Knowledge of best practices in Data Analysis along with decision trees and FAQs, training on reading commonly seen data, identifying discrepancies in numbers, building on current data sets to get full 365 analysis; Knowledge of identification processes for diseases by diagnosis; Knowledge of ETL processes, best practices, training strategies, improvement plans, tuning capabilities; knowledge of XML; knowledge of food safety and food safety processes; Knowledge of ICD-10 and ICD-9 codes; ability to build complex primary keys; ability to design and create a Data Warehouse from a number of sources with a number of dimensions/universes; Knowledge of data regulations and inspection requirements; knowledge of Health, Life, Property and Casualty insurance - held licenses in the past; knowledge of SQL coding logic and efficiency, ways to optimize queries, SPs, and scripts; Lotus Notes, knowledge of Medicare processes, files and workflow; knowledge of Medicaid processes, files and workflow; Macros in Excel and Access; MS Access, MS Excel, Excel, MS Outlook, MS PowerPoint, MS Word, MS Visio, Oracle; Knowledge of Pivot tables in Excel; Knowledge and ability to conduct presentations and the best way to structure PowerPoint decks; Knowledge of processes improvement strategies; Knowledge of protocol implementation strategies; Knowledge of quality control planning, design, and implementation; Knowledge of sales strategies, analysis, and optimization; Knowledge of script building and best practices; Knowledge of troubleshooting strategies, best practices, and troubleshooting trees.

Resume Overview

Companies Worked For:

Family Health Network
West Lake Financial Group
AonHewitt
Contracts - Amarac Technology Solutions
EcoSure
Mark Havlic Allstate Agency

School Attended

Devry University
College of Lake County

Job Titles Held:

Manager, Business Intelligence
Manager, Data Services
Data Analyst/SQL Developer
Benefit Analyst
System Analyst/Business Analyst
Data Collections Specialist
Licensed Sales Professional

Degrees

CIS , July 2015
Associate of Arts : 6/2010

Manager, Business Intelligence Resume Example

Resume Score: 90%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes