Manager Business Intelligence resume example with 11 years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK Home: (555) 432-1000 - Cell: - resumesample@example.com - -
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
Expected in July 2015
: CIS Devry University - , GPA: CIS
Expected in 6/2010
Associate of Arts: College of Lake County - Grayslake, IL GPA:
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
05/2015 to Current
Manager, Business Intelligence Verizon – Kaneohe, HI,
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.
2014 to 05/2015
Manager, Data ServicesMindbody, Inc – San Luis Obispo, CA,
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.
09/2013 to 2014
Data Analyst/SQL DeveloperUsa Vein Clinics – Northbrook, 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 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.
06/2013 to 10/2014
System Analyst/Business AnalystIntrado – Louisville, KY,
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.
03/2012 to 06/2013
Data Collections SpecialistAllstate – Broken Arrow, OK,
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.
04/2010 to 03/2012
Licensed Sales ProfessionalMark Havlic Allstate Agency – City, STATE,
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.
Professional Affiliations
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.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.