LiveCareer-Resume

Manager Business Intelligence resume example with 11 years of experience

Jessica Claire
Montgomery Street, San Francisco, CA 94105 609 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 Services Mindbody, 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 Developer Usa 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 ETL process.
06/2013 to 09/2013
Benefit Analyst Arthur J Gallagher & Co. Weslaco, TX,
  • 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 Analyst Intrado 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 Specialist Allstate 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 Professional Mark 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.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

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.

Resume Overview

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

  • Associate of Arts

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: