PROFESSIONAL SUMMARY:

• 23 years combined experience as an Analytics/Report Developer, Data Analyst, Business Analyst, Programmer, Tester, Trainer, Technical Writer, and Production Support Specialist. Over teh last 13 years, I performed Analytics/Report Development and Business Analysis work on Business Intelligence and
• Analytics Teams to promote TEMPeffective decision making at Confidential / UCHealth. I joined Epic team as a Clarity Report Writer, and developed tools individually or wif project teams to support inpatient and outpatient areas, clinical quality, patient safety, process improvement, regulatory auditing and compliance, chief executive suite, and health system access and growth. I will use development, problem solving, data and business analysis, and end - to-end build skills to work wif team and halp our health system and service lines improve in these areas, as well as UCHealth’s mission, vision, values and core objectives.
• I worked on innovative Metrics and Service Line projects using teh Analytics Metric Model, Epic (Caboodle data warehouse, Clarity, Epic-Crystal integration), Business Objects, Sharepoint, and Microsoft BI reporting and analysis development tools. I trained and mentored teammates and users on front-end and back-end reporting skills. My development/analysis background and communication skills will uniquely halp in my work wif customers, analysts and team, and business analyst skills will aid in specifications gathering, business-to-technical translation, and understanding customers' reporting needs. I was lead analyst for UCHealth’s ITSM analytics/reporting request and incident queue, worked wif
• Service Desk/Support teams to improve resolution and user self-service process through documentation,, and enhanced Knowledge Base articles. Previous testing,, technical writing and project coordinating background will also be useful during build process and post implementation support. I can quickly shift gears and support dynamically changing project goals and customer needs. Over 23 years, I provided information and data for quality improvement and decision making wifin industries of Health Care, Commercial Information Analysis, Insurance Fraud Tracking and Claims Processing, Biotechnology, Pharmaceutical, Healthcare Insurance, Health and Wellness, Sales Operations Forecasting, Telecommunications, Data Security / Compliance / Litigation Support, Billing & Invoicing, and Check Printing.

TECHNICAL SKILLS:

PROGRAMMING: T-SQL / MS SQL, Oracle PL/SQL, DB2 SQL, Crystal and QlikView script, C, XML, COBOL, JCL.

Exposure: DAX (Tabular Models, PowerPivot), CCL (Cerner Command Language), ActionScript, CSS (Cascading Style Sheets), SAS, Schema/Lisp, Adobe Flash Professional 8.0, HTML.

SQL: Stored Procedures, Views, Temp Tables, CTEs, input/out vars/parameters, detail, aggregation. Picklist procedures. Parameter Sets. Exposure to Query Plan tools. Import data into custom tables.

MICROSOFT BI STACK: SSMS/SQL Server Management Studio, SSRS/Reporting Services, SSAS/Analysis Services - Tabular Models (ex critical Ambulatory Quality Metrics project) and exposure to Cubes (ex Oncology Service Line project), SSIS/Integration Services (ex Jobs, Packages). Visual Studio.

EPIC: Epic-Crystal Integration for Crystal reports (end-to-end). Crystal report development, Epic template creation, Epic report creation, Data Courier, debug in Business Objects, exposure to batch job scheduling. Exposure to Reporting Workbench. Validate report output/accuracy against Epic charts. Inpatient Data Model certified, Stork Data Model proficient. Fluent wif UserWeb, Nova Notes, Galaxy, hub, Data Dictionaries, etc.

CRYSTAL REPORTS / BUSINESS OBJECTS / SAP / WEBI / UNIVERSE: Crystal Designer XI/ 10.0/9.0/ 8.0/8.5/7.0, Business Objects Enterprise (BOE)/Crystal Enterprise/Server XI (Console)/Administrator, Java Reporting Component (JRC) Viewer. Relational Databasing - Schemas/Models/Joins, SQL Scripting/Querying/Stored Procedures. Lead Developer, account Subject Matter Expert. Central Management Console, Infoview. Support user permissions through login and AD groups. Exposure to WEBI reporting, Business Objects Universe.

MICROSOFT TFS: Version Control system. TFS wifin Visual Studio or TFS Web Portal. Deployment Change Control process - update code, back-up code, query plans, I/O client stat files.

MICROSOFT POWER BI: Some development, data model, design. Licensing, Portal, Workspace, publishing, DAX.

ITSM: Triage all Incidents and Service Requests for Analytics’ team queue, time tracking. Created 20+ Knowledge Base articles for Analytics/Reporting tools (for Service Desk, Epic Support Team, and self-service users) to improve process for I.T./Epic teams and UCHealth users. Create Alerts, create guides on Knowledge Base/Configuration Items.

SHAREPOINT: Report/Analytics Tool deployment and publishing for UCHealth Analytics Report Library (Prod and Stage), AD-group permissions (ex PHI, Non-PHI, Restricted Libraries, sites, subsites). Reporting against Sharepoint Lists. Created guide for locating and running Sharepoint reports (ex Analytics “Common Themes” reports). File version management.

SSRS SERVER: New solution while system retires SharePoint BI library integration. Migrate Analytics Report Library reports from Sharepoint to SSRS Server, and published/displayed via new Atlas report search portal. Permissions varied between Analytics, Power Users, PHI, Non-PHI (AD groups), or fully Restricted (custom permissions).

ATLAS: New UCHealth report search portal. Migrate Analytics Report Library reports from Sharepoint to SSRS Server, and publish/display wifin Atlas.

EXCEL PIVOT / POWER PIVOT / POWER QUERY: Service Line dashboards (ex critical Ambulatory Quality Metrics project used by executive/leadership/clinical teams). Visual Basic Combine Excel tabs into CSV files (often 50+ tabs from state/national compliance requirements) and import into database tables.

QLIKVIEW: QlikView 9/10, QlikView Enterprise, QEMC (QlikView Enterprise Management Console), Access Point, QlikView Publisher, I.E. Plugins, Citrix.

SQL / DATABASE: RDBMS Schemas/Models, ERDs, MS SQL / T-SQL, ORACLE PL/SQL ORACLE 8i/9i; Data Warehouses / Data Marts / Materialized Views / Tables; Oracle SQL+/Toad; DB2 SQL, DB2 database, DBVisualizer; MS Query Analyzer (for MSPS/MS Project reports); System/DB Troubleshooting. OAGIS BOD, Data Mapping. Part of SQL Server community, SQL Saturday, etc.

APPLICATIONS MS Word/Excel/Access/PowerPoint, Skype For Business/Outlook/Lotus Notes, OneNote, Notepad++, Active Directory, Relational Database - RDBMS Schemas, ERDs, SQL Querying.

TEAM LEAD: Design and Development, Code Review, Testing, Customer Support

: Designed/conducted customer & internal Technical Courses, materials/manuals.

UNIX / LINUX: VI-editor, Unix-Shell Programming, SQL, C

OPERATING SYSTEMS: Windows 98/NT/2000/XP/Vista/7/10, Unix/Linux, MS DOS

PROFESSIONAL EXPERIENCE:

Confidential

Analytics Developer, Data Analyst

Responsibilities:

• Working on Clinical Quality team to halp improve Patient Safety and Quality, Process Improvement, Regulatory reporting, and Infection Prevention through data analytics work.
• As Analytics Developer and Data Analyst, I design, develop and support back-end SQL stored procedures, front-end Sharepoint/SSRS and PowerBI reports for Service Line Quality Metrics projects, and independent reports. Support projects from end-to-end as developer, specs gatherer, data and business analyst, and tester. I mentored teammates and users on front-end, back-end reporting skills, and how to pull and map where data exists in Clarity database based on user screen prints (using Epic tools and SQL code). Began initial learning of Vizient reporting, teammate’s workflow for building Vizient Data Models, and how Clinical Quality Data Model is being built.
• Work wif system-wide executive/senior leadership, Clinical Quality, I.S. (Analytics and Epic analyst teams), Service Line leadership, customers/users, Clinical Informatics members to design Analytics / Business Intelligence solutions to improve data and information distribution, and reporting to halp wif decision making, improved processes, workflow and quality. Our team works on Service Line Quality Metrics dashboards, reports and tools (Inpatient and Ambulatory), which will improve communication, research, knowledge and decision making, reduce redundancy and increase standardization wifin and across departments, regions and system.
• Use Microsoft BI reporting/analysis development tools (SSMS/SQL Server Management Studio, SSRS/Reporting Services, SSAS/Analysis Services - Tabular Models, SSIS/Integration Services), Power BI, TFS/Team Foundation Server versioning control), Business Objects/SAP/Crystal Reports, and Epic (Clarity, Caboodle data warehouse, Epic-Crystal integration) to publish tools wifin SSRS Server, Sharepoint sites/subsites, Epic Hyperspace, and Power BI cloud, to be searchable wifin new UCHealth Atlas Portal.
• I develop back-end SQL code and front-end tools for Quality and Obstetrics projects, involving Clinical and Coding/Revenue Cycle data:
• Medical Staff and Provider Reporting/Credentialing: Built back-end and front-end automation tools to support provider credentialing for MSO/Medical Staff Office, and various UCHealth teams. Develop complex SQL stored procedures, pulling a large amount of provider activity from many Epic Modules (ex: Attending, Visit, Admit, Discharge, Consulting, OB/Stork, Episode of Care, Treatment Team, Anesthesiologist, Radiologist/Radiant, Surgeon/OpTime, and Note Author provider). Reports deployed to SSRS Server and searchable via new Atlas report portal for Monthly batch files, Ad hoc report, and Detail level data. Summary level data is based on Final Coded Diagnoses and Procedures (DX/ICD codes), and Obstetric, Surgery and Radiology procedures.
• NOTES related Reports/Database Improvement: Developed and tested SQL from complex “Provider Notes” database structure. To halp improve system-wide *Notes-related Reports* in speed/run time and performance, I researched Notes database tables, worked on query performance tuning, and tested potential database column indexing improvements (using previous role lessons, and recent web research and webinars). Provided suggestions to IT/DBA team. Was able to gain DBA buy-in to add database indexes to improve speed and performance for system-wide Notes-related Reports and Analytics tools.
• Revenue Cycle data: For many reports, often pull in Coding/Diagnosis data (Final Coded ICD codes, CPT codes), Hospital and Provider Billing, Transaction/Hospital Account data. Work wif Revenue Cycle, HIM, Coding teams.
• Inpatient Quality reports: Design, develop, test and support tools wif Inpatient departments to improve clinical quality, patient safety, care and outcomes, risk management, staff and provider accountability, patient charting, clinical documentation, process/workflow, decision making, and for urgent regulatory and auditing requirements (HQIP, CMS, JCAHO, NHSN, CDC). EX: Readmission, LOS, Mortality, Infection Control, LDAs, Central Lines, CAUTI, Dialysis, Disease Screening, Case Management Screening, Priority Discharge, Diagnoses, Problem Lists, Orders, Surgery/Procedure, Radiology, Notes, Medications, Flowsheets, ADT flow, Sepsis, Pain Management.
• Obstetrics Projects (Severe Hypertension and OB Outcomes tools): I worked deeply wif regional and system-wide teams (ex: OB steering committee) to improve patient outcomes for Severe Hypertension and Medication Treatment. I developed SQL stored procedures for 4 metrics, in various user validation stages: (1) Of pregnant and postpartum patients wif a Severely Elevated BP, how many had follow up readings wifin specific timeframe? (2) How many of those received medication treatment according to protocol wifin specific timeframes? (3) How long did it take for Provider and RN Communication to occur? (4) How often were related Order Sets used? Teh system TEMPhas begun using initial data to improve patient outcomes, but are still working to determine various metric scopes and criteria better for various QI projects. Separately, to support many system QI projects and metrics, I continue to modify my “OB Outcomes” report and back-end code.
• HQIP Quality Projects (OB): Critical projects for HQIP metrics (Healthcare Quality Improvement Program). HQIP program encourages quality and health outcome improvements. It offers significant pay-for-performance financial incentives (separate from usual reimbursements) for hospital partners that meet performance targets in quality and operational efficiency. For UCHealth’s Clinical Quality in Obstetrics/Newborn/Pediatrics areas, we need to provide data for metrics around: Severe Hypertension and Medication Treatment, Depression, Substance Abuse, Language / Race / Ethnicity / Special Needs, and Breastfeeding. I developed code and reports, or leveraged existing reports to support these metrics.
• COVID reporting: I developed SQL stored procedure to pull very broad COVID data. It pulls Inpatient and Ambulatory/Outpatient data for ALL COVID results (positive, negative, confirmed, suspected/ruled out, unknown/inconclusive, antibodies) from Infection Flag, Diagnosis (Final Coded, Encounter Dx, etc), CPT code, Order/Lab/Test, and Registry level data for retroactive historical/analysis/trending needs. Also researched and supported users wif existing simplified COVID reports.
• Infection Prevention reports: STI/Sexually Transmitted Infections and Medication/Antibiotic Treatment, NHSN reporting, Tuberculosis exposure.
• “COMMON THEMES” tools: To provide a large amount of information for multiple users, teams, departments and purposes, in as few analytics tools as possible, my former team and I developed system-wide “Common Themes” reports for many Epic areas. For Clinical Quality requests, I continue to enhance, support and train users on SSRS / Sharepoint Analytics Report Library tools for: Hospital ADT Events (Admission/Discharge/Transfer), LDAs, Flowsheets, Procedure Orders, Procedure and Medication Order Modes and Smart Sets, Diagnoses, and Provider Activity reports. Users can select various parameters wifin Sharepoint reports and filter/sort output. Tools include patient demographics and provider details across health system location hierarchy/structure.
• Document steps for tools.
• Publish SSRS reports to Sharepoint and SSRS Server wif Visual Studio, all searchable through Atlas Portal. Set up Ad hoc reporting, or Refresh schedules and Data-Driven publications. Use Team Foundation Server to maintain version control. Publication is based on system-wide Analytics PHI and non-PHI permission architecture based on AD groups supported by Epic Security, User Provisioning, Analytics teams.
• Train users on specific Epic-Crystal Integrated or Workbench reports wifin Epic Hyperspace (My Reports).
• Work wif Epic and Quality analysts, Clinical Informatics, and users to document or translate general user requirements and detailed specifications using Epic data dictionaries and UserWeb.
• Develop reports mostly against Epic Clarity and Caboodle data warehouse, sometimes linking to Lawson and Employee Health database tables. Researched connections to other non-Epic databases (ex: NurseCall, RL, D3).
• ITSM / Service Manager: From previous role of lead developer/support for UCHealth’s ITSM analytics/reporting request and incident queue, I am fluent wif and continue to leverage ITSM to support projects (for self-service or technical support role, user, analyst or developer usage, request entry/support, documentation,, Knowledge Base articles). Our Clinical Quality group also uses a self-built Sharepoint request queue while waiting for our team to be added to ITSM as a technical team.
• Design, develop, publish and support reports, or run back-end code for many Epic areas and data models:
• Obstetrics/Stork: For Pregnant, Delivering, Postpartum patients, and Neonatal/Infants - Severe Hypertension for QI and HQIP projects (Patient Safety/Staff Follow-Up Metrics, Provider and RN Communication, and Medication Treatment), OB Outcomes, High Risk OB, Mortality, Readmission, ADT and ICU / High Level Care Transfers, SBIRT and Substance Abuse, Depression Scales, Postpartum Hemorrhage and QBL / EBL, Blood Transfusion, OB Provider and Procedural Roles, Early Elective Deliveries, NTSV, C-Sections and Medication usage, Hysterectomies, Eclampsia and Pre-eclampsia, Oxytocin Induction, NWA Scores, Infant Cooling/Cord Gas, Infant Discharge, Pulse Ox.
• Revenue Cycle/Billing/Charges/Account/Transaction/Hospital and Professional reporting - Diagnosis reporting based on Coding (Final Coded, ICD and CPT codes, by Visit/HAR/Hospital Account Record levels).
• Inpatient/ClinDoc/Orders
• ADT (Admissions, Discharges, Transfers), Readmissions, LOS
• Pharmacy/Willow: Medication Administration and Treatments, MAR, Order/Order Sets
• Lab/Beaker (Orders, Components, Results, Tests, Specimens)
• Perioperative/Surgery/OpTime
• Radiology/Radiant/Anesthesiology
• Consulting, Episode of Care, Treatment Team
• Attending, Visit, Admit, Discharge
• Notes, Diagnoses, Smart Elements, Concepts
• Employee reporting (Epic, Lawson)
• New and refreshed technical courses - Epic /Proficiencies: Clarity/SQL, Inpatient Data Model, Stork Data Model, Core and Shared Clinical Application Essentials, SQL Query and Database performance tuning, Power BI, and DAX webinars.

Confidential

Analytics Developer, Epic Report Writer

Responsibilities:

• Work on 20+ person Analytics/Business Intelligence team to design and develop Sharepoint tools (SSRS and PowerPivot) and Crystal Reports for Service Line Metrics projects and independent reports covering a diverse spectrum of health care data, information and purposes. Support projects from end-to-end as developer, data and business analyst, and tester. I mentored teammates and users on front-end and back-end reporting skills.
• Work wif executive/senior leadership, I.S. and system-wide leadership, customers/users, analyst teams and Analytics team members to design Business Intelligence solutions to improve analytics solutions, data and information distribution, and reporting. Health system goal is to improve information access and usage for decision making, improved processes, workflow and quality, for clinical and access/growth opportunities. For example, our team is working on Service Line Metrics dashboards and broad tools (ex: Ambulatory Quality, Oncology, Obstetrics) so users and teams across health system can find information wifin a single or several dashboards, rather than many disparate, unrelated reports. These span from high-level Tier1 (executive) and Tier2 (management) dashboards to lower-level Tier3 (clinical/analyst) drilldown tools. This will improve communication, research, knowledge and decision making wifin and across departments, and reduce redundant effort.
• Use Microsoft BI reporting/analysis development tools (SSMS/SQL Server Management Studio, SSRS/Reporting Services, SSAS/Analysis Services - Tabular Models/Cubes, SSIS/Integration Services, PowerBI, TFS/Team Foundation Server versioning control), Business Objects/Crystal Reports/Webi/Universe, Epic (Clarity, Caboodle data warehouse, Epic-Crystal integration), and system-wide Analytics Metric Model infrastructure, to publish tools wifin Sharepoint sites/subsites, Epic Hyperspace, PowerBI cloud, and Business Objects/SAP/Infoview.
• Inpatient Quality reports: Design and develop tools wif Inpatient departments to improve clinical quality, patient safety, care and outcomes, risk management, staff and provider accountability, patient charting/clinical documentation, process/workflow, decision making, and for urgent regulatory, investigation, and auditing requirements (ex: CMS, JCAHO, NHSN, CDC). EX: Pain Management, Sepsis, Mortality-Readmission, Infection Control, Surgery, Radiology, Disease Screening, LDA/CentralLines, Wound Care, Nutrition, Equipment, Notes, Ordering, Procedure, Medications, Diagnosis, Flowsheets, ADT flow).
• Obstetrics projects (OB Outcomes tool and OB Universe ETL/tables): I worked wif teh Obstetrics Service Line to design and develop a broad Outcomes tool for various quality improvement and analysis purposes. We are working to enhance and improve teh tool for analytical/statistical purposes. I work wif several developers to support teh OB Universe ETL code and tables that populate many Obstetrics reports.
• Ambulatory Quality Service Line Metrics project: This project was driven from executive team for Ambulatory growth and Population Health, which involved chief executive team, Ambulatory and PopHealth project managers/coordinators, Epic and Analytics teams. Developed executive-level Tier1 dashboard using SSRS and SQL stored procedures, and management-level Tier2 using PowerPivot and Tabular Model. I developed code from our Metric Model tables, populated through ETL and existing Tier3 (RADAR) tools. Metrics covered preventative data for vaccination and screening, such as Pneumonia, Hypertension, Colorectal Cancer, Breast Cancer, Cervical Cancer, and Diabetes. Used system-wide Analytics Metric Model tables wifin Caboodle Data Warehouse.
• Population Health project: In addition to Ambulatory Quality Metrics project (tied to PHSO project), I developed several reports for CPCi and CPCPlus projects, including Alternative Visits, Risk Levels for Patients Seen or Not Seen, Shared Decision Making Tools, and Nurse Triage after Discharge.
• Patient Line project: For executive team and new Patient Line scheduling department, I developed Scheduling reports to halp teams analyze scheduling volumes by staff type and scheduling tools (ex: nurse, Patient Line schedulers, Online Scheduling / MyHeatlhConnection, etc).
• Oncology Service Line Metrics Project: This project was driven from Oncology Service Line leadership for process improvement projects. Patient Volumes by clinics, providers, disease areas/groupers, and Research. I supported front-end tools (Performance Point and PowerPivot), and back-end development (SQL stored procedures, views, Dimension and Fact tables, ETL jobs, Oncology Universe tables and cube).
• TeleHealth / Vidyo auditing project: For UCHealth innovation initiative (ex: remote/virtual ICU and monitoring), I’m developing code to halp TeleHealth/Vidyo team analyze certain metrics - # virtual instances by provider and service lines, travel miles saved for patient and providers, etc. To develop front-end dashboard using PowerBI.
• Access project: Update Access Department configurations and department sets by Directors monthly to support Access and Ambulatory Quality/Population Health tools. Leverage Access sets for Ambulatory Quality tool.
• Health Data Compass: Lead analyst to halp answer questions for Health Data Compass project/vendors across inpatient, ambulatory and billing areas. Work wif Epic teams to determine data sources and analyze code.
• “COMMON THEMES” tools: To provide a large amount of information for multiple users, teams, departments and purposes, in as few analytics tools as possible, our team developed system-wide “Common Themes” reports for many Epic areas. I developed SSRS/Sharepoint tools for Hospital ADT Events (Admission/Discharge/Transfer), Procedure Orders, Procedure and Medication Order Modes and Smart Sets (Verbal, Standard, Cosign Deficiency), LDAs/Flowsheets, Wound Care/HAPU/Pressure Injuries, and halped build Diagnoses report. Users can select various parameters wifin Sharepoint reports and filter/sort output. Tools include patient demographics and provider details across health system location hierarchy/structure. Frequently support Flowsheet tools.
• Provider Credentialing: Support provider credentialing by using existing Common Themes tools.
• Work wif team to create “How to Find and Run Common Themes and Sharepoint Reports” guides.
• Publish SSRS reports, Tabular Models and Cubes to Sharepoint or production servers wif Visual Studio. Upload Power Pivot/Excel solutions directly to Sharepoint. Set up Refresh schedules and Data-Driven publications. Use Team Foundation Server to maintain version control. Publication is based on system-wide Analytics PHI and non-PHI permission architecture based on AD groups supported by Epic Security, User Provisioning, Analytics teams.
• Develop Crystal reports for many service lines, departments, user groups, and Epic data models. Published ad hoc Crystal reports wifin Business Objects/Infoview, mostly for leadership and analysts. Published Crystal reports for clinicians and other user groups wifin Epic Hyperspace (My Reports) through Data Courier.
• Work wif Epic analysts and users to translate general user requirements and detailed specifications using Epic data dictionaries (exported or on UserWeb).
• Regularly update existing code when Epic upgrades and source fields become deprecated.
• Develop reports mostly against Epic Clarity and Caboodle data warehouse, sometimes linking to Lawson database tables. For Telehealth project, using Vidyo tables that extract from Vidyo/Telehealth system.
• ITSM / Service Manager: Lead analyst for UCHealth’s ITSM analytics/reporting request and incident queue, worked wif Service Desk/Support team leadership and analysts to improve resolution and user self-service process through documentation,, and new Knowledge Base articles.
• CEO Dashboard/Census: Support daily “CEO Dashboard” and “CEO Census” reports used by executive and leadership teams (ETL jobs, Sharepoint distribution). Help improve process and support, incident documentation.
• Design, develop, publish and support reports for many Epic areas and data models:
• Obstetrics/Stork (OB Outcomes, Kangaroo Care, Provider Connect, HCG Preg Tests/Orders vs Charges)
• Inpatient/ClinDoc/Orders (Pain Management, Sepsis, Mortality-Readmission, Infection Control/NHSN/Surg, CDC/Ebola Screening, Extubation/Intubation, LDAs/PICC/Lines/CentralLines, Notes, some VQI, Monthly Language stats / Primary Language / Ethnicity % breakdown, Preferred Names)
• ADT (Admissions, Discharges, Transfers), Readmissions, LOS
• Oncology/Beacon (Service Line Metrics project, Oncology Universe, support Epic reports)
• Pharmacy/Willow (Antibiotic Spectrum, Order Modes, other)
• Lab/Beaker (Orders, Components, Results, Tests, Specimens)
• Perioperative/Surgery/OpTime
• Rehab (Flowsheet data, CMS Rehab Audits)
• Radiology/Cardiology - exposure
• Billing/Charges/Account/Transaction/Hospital and Professional reporting - exposure
• Research - exposure
• Employee reporting (Epic, Lawson)
• Completed technical courses - Epic Clarity/SQL, Inpatient Data Model, Stork Data Model (Proficiency), PowerBI courses, Microsoft BI stack (SSRS/Reporting Services, SSAS/Analysis Services). Introduced to R, Data Science.

Confidential - Colorado Spgs, CO

Crystal Reports Developer, QlikView Dashboards Developer, Business/Technical Analyst

Responsibilities:

• Work on three person Business Intelligence Report Developer team to design and develop Crystal Reports and QlikView Dashboards for a diverse spectrum of health care data, information and purposes (see above). Support projects from end-to-end (full SDLC) as Programmer/Analyst and Business Analyst.
• EX: $6 million savings through 340B program.
• Work wif BI director, I.S. and system-wide departmental management, customers/users and executive/senior leadership to design Business Intelligence solutions to improve data and information distribution and reporting. Health System goal is to improve information usage and access for decision making, improved processes, workflow and quality. For example, our BI team is working wif users to create broad departmental or categorized dashboards (ex: Quality Management, Surgery Analytics, Pharmacy/Dispensed Drug Monitoring (real-time inpatients or historical), Volume Statistics, Patient Lists, Throughput Times, etc) so multiple users wifin a department or multiple departments can find information wifin a single dashboard, rather than many disparate, unrelated, reports. This will improve communication, research, knowledge and decision making wifin and across departments, and reduce random and redundant work and output for I.T. As another example, our BI team is planning to create new cross- “Master” tables that will link systems originally missing ”linkable” keys, in order to drive data relationships across disparate systems and make reporting much easier and accurate.
• Perform end-to-end SDLC steps and roles for report/dashboard projects (as listed below in consulting role).
• Using QlikView 9 and 10, Enterprise and Publisher, design and develop reports and dashboards for Health System. Perform Crystal Reports development work (as listed below in consulting role).
• Develop first tier QlikView and SQL Loader scripts to create QVD data extracts from RDBMS/databases to reduce load on source databases. Develop second tier QlikView/SQL scripts (QVW files) against QVD flat files or source database (RDBMS, Excel, Access) which builds dataset for dashboard applications. Create third tier front-end design, calculations, expressions, formulas and objects (list boxes/filters/parameters, tables, charts, gauges, sliders, action buttons, URL links, Google Maps, text boxes, sheets, tabs, etc). Create convenient Bookmarks for users wif various filter ps. Design and develop “Ad hoc Reports” wifin dashboards that users can run and print to physical printer or to PDF printer and save electronically.
• Use QlikView Enterprise Management Console to schedule data loaders and dashboards to run daily or as needed. Work wif team to set up QlikView and Windows level folder hierarchy by departments, data areas, and categories for dashboard access by various user groups. Provide access to users via QlikView and Windows level group security and various QlikView licenses (Document CALs for single dashboard full-time usage, Named User Licenses for multiple dashboard full-time usage, Session CALs for usage when sessions are available). Push QlikView Plugins for fat-client Internet Explorer users or support thin-client Citrix users. Beginning to use QlikView Publisher to schedule Reports to auto-email to users, clinicians, managers, employees, vendors or Lotus Notes Groups. Will create databases to maintain security for data bursting and distribution to various users and groups.
• Work wif Oracle, DB2, MS SQL, MySQL, iSeries, Sybase relational databases, views, tables, data warehouses, and Crystal Reports Designer XI R2 and Server/Enterprise, and SAP/Business Objects XI 3.0.
• Work wif relationship database models, schemas, Entity Relationship Diagrams (ERMs) and data dictionaries to create informal technical/system design documents, develop reports/dashboards, SQL scripts, queries and views.
• Develop Crystal and QlikView code, scripts, reports and dashboards against various systems: Cerner, HIS, PICIS/ORManager/SmarTrack (Surgery/Periop), PACU/PACUManager (Postop), McKesson/Pharmacy, 340b/Drug Discount, Cactus/Physician Privileges, PhysicianLink, Premier/Core Measures, PowerPath/Pathology, RIS/Pacs/Provox/Cerner (Radiology), LotusNotes (Ticket/Work Order/Change Management), PHS/Scheduling, Lawson/Payroll-HR, IPCC-Cisco/Call Center, etc.
• Work wif SIS (Surgery Information Systems) and our Surgery staff in iterative cycles to customize SIS Analytics (Periop Dashboard) QlikView product for our Health System. Extract Surgery data as QVD files through Medsurg loaders, match data elements to SIS code and product, confirm calculations and requirements, create bookmarks, reload iteratively modified product for user acceptance, and usage, provide access, and halp test and train. Continue to manage all new surgery needs and projects, and find way to converge wif single surgery dashboard.
• Design, develop and manage reports and dashboards for Quality (ex: Falls Prevention, Infection Prevention, Patient Charting, Vaccine Screening, HIV Babies Screening, Medical Staff Outcomes, Core Measures, Physician Privileges, Case Management, Medical Records Suspension, Physician Documentation and Timeliness, Order Authentication, Signing Compliance), Prenatal/OB/Mother Baby/Birth Center, Departmental Throughput (ex: Emergency Department, Radiology, Lab, Urgent Care), ICD-9 (preparing for ICD-10), JCAHO/JointCommission or CMS, Executive Rounding in health system, Surgery/OR/PACU (ex: OR Turnover Times, Volume Statistics, SCIP Measurements, Equipment and Materials Usage, Medication Auditing, Preoperative Briefing, Room Utilization, PACU Checkpoint Times, Chart Auditing), Pharmacy (ex: Informatics Audits, Anticoagulation Monitoring, Charges, 340b Drug Discount), Pathology/Breast Center (ex: Tumor Size, Margins/Metrics), Lung Nodule Clinic, Radiology (ex: Checkpoints, Procedure Times), Mammography, Departmental Patient Lists (ex: Hospitalists, Inpatients, Outpatient, managing patient encounters, reconciling scanning and medical records), Departmental Scheduling (Preauthorization, Patient Volume, Charge Worksheets, Itineraries, appointment efficiency), internal Ticketing Status (ex: I.S. Work Orders, Change Management), Project Management, Compliance (ex: HIPAA, PHI, vendor), Insurance, Materials, Integrated Therapy, Acupuncture, Finance (ex: Billing, Payroll, Flexing), Human Resources, Communications and Marketing, etc.
• Train customers on QlikView dashboards design (if not previously co-designed wif user), usage and functionality.

  EX: How to view dashboards, and export and print objects in Access Point.

• Train technical users/customers on basic QlikView development/design to create their own simple dashboards.
• Completed basic technical courses - QlikView Design and Development (Business Intelligence tool), basic Cerner Command Language (CCL), Cerner Applications (Discern Explorer, Discern Expert, Power Notes, Architecture/ Troubleshooting). Introduction to: Crucial Conversations, Liberating Structures, Toastmasters.

Confidential - Colorado Spgs, CO

Crystal Reports Developer, Business Analyst

Responsibilities:

• Work on two person Crystal Report Development team to design and develop Crystal Reports for a diverse spectrum of health care data, information and purpose (see above). Support projects from end-to-end (full SDLC).
• Work wif Oracle, DB2, MS SQL, MySQL, iSeries, Sybase relational databases, views, tables, data warehouses, and Crystal Reports Designer XI R2 and Server/Enterprise, and SAP/Business Objects XI 3.0.
• Work wif relationship database models, schemas, Entity Relationship Diagrams (ERMs) and data dictionaries to create informal technical/system design documents, Crystal Reports, and develop SQL scripts, queries and views.
• Develop reports using advanced features: Multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drilldown through on demand subreports, dynamic link labeling, group and record selection criteria, commands, cross-tabs, charts/graphs, complex functions and formulas, multi-pass formulas, shared variables, running totals, imported parameters and record sets from stored procedures, conditionally suppressed sections and objects, error handling/messaging, clean and attractive designs, user-friendly instructional ToolTips. Report against relational databases via ODBC and JDBC connections, as well as Excel and Access databases. Complete production implementation by loading reports to Business Objects Enterprise/BOE, scheduling auto-recurring reports as needed and managing user access. Set up many reports to automatically email to users or Lotus Notes groups or send to physical printers at specific times.
• Manage, research, resolve and complete IS Requests, Work Orders, Change Management tickets, and Production/Incident tickets. Most requests minimally include general statements and descriptions of desired Reports to satisfy Business Case, while a few include more detail on required data, fields, purpose, etc. After requirements gathering, modify or design and develop Crystal Reports, and manage settings or implement new Reports on Business Objects Enterprise/BOE (Crystal Reports distribution center). Complete in depth research (ex: online, technical forums, manuals/books) for complex solutions, design and workarounds.
• Work closely wif customers, executive/senior leadership, upper level and project management, BA, SSA (Systems Support Analyst), Developer/DBA, Network and informal QA teams to translate business needs into informal functional/technical requirements and design documents via Requirements Discovery Questionnaires, report mockups and define technical solutions via EDI. Work through approach, assessment, risk/issues management, and customer interviews to gather requirements and plan SDLC steps, phasing, timeline, design, development, testing cycle, production implementation, and post implementation. Document, organize and distribute session outcomes, requirements, changes, issues, process and workflow as needed.
• Perform testing (Unit, System, User Acceptance) via Use Cases. Through iterative phases, work wif customer on testing and user acceptance at design, functional and UI levels.
• Train customers on Crystal Reports design (if not previously co-designed wif user), usage and functionality.

  EX: How to view, export and run reports on BOE if not automatically emailed or printed.

Confidential - Colorado Spgs, CO

Senior Business/Technical Analyst

Responsibilities:

• Strong communication, support, relationships and synergy wif internal/external customers, business groups, and IT team (directors, managers, developers, DBAs, network and QA teams).
• Take initiative exploring and documenting factory, call center and systems processes and work flows. Research and learn fast. Adaptable and versatile in complex environment and industry.
• Support Agile Methodology / System Development Life Cycle (SDLC) based on SOA (Service Oriented Architecture) technologies and solutions (ex: Web Services, Messaging Infrastructure/Architecture, Message Queuing, Publisher/Subscriber, XML messaging, Windows Communication Foundation, Distributed Computing/ Transacting, Remoting, ABC (Address/Binding/Contract) and Endpoints, Asynch/Synchronous Communication).
• Solid understanding of business functional areas and business management issues.
• Represent IT organization in requirements discovery and approach definition meetings wif external departments, customers and IT team. Document meeting outcomes, communicate project status and issues internally and externally. Work wif project management to coordinate internal/external follow-ups to close issues in support of project requirements and delivery assurance.
• Support Delivery Model and Assurance (Discover, Define, Detail/Design, Develop, Deploy/Deliver). Create Assessment, Analysis, Design/Approach, Requirements documents, as well as support Project Management documentation and planning, such as PM Plan/Agreement, Cost-Benefit estimates, timelines, work plans, and Project Impact Assessment (ex: Change Control, Issues, RACD/Risks, Assumptions, Constraints, Dependencies).
• Use creativity and brainstorming to generate questions and interview business areas (ex: Manufacturing, Contact Center, Marketing, Finance), break down and capture low-level details while maintaining big picture. Use research results to document complex business flow and processes, and create functional matrices for new applications, functions, architectural solutions, and complex Order, Packaging and Shipping scenarios.
• Translate Business-to-Technical requirements using Use Cases, communicate Technical-to-Business specifications to customers and managers. Analyze project request and existing system documentation to support business process, workflow documentation. Create analysis, design and requirements documentation, and work wif lead architects and developers to capture approach and solutions. Document traceability from business objectives to business requirements, rules and Use Cases to functional and testing requirements.
• Testing - Use skills to support software test, system integration, quality assurance, and delivery of technical solutions while focusing on business products and customer satisfaction. Create Master Test Plan for all phases (ex: Smoke, Sanity, Unit, System/Integration/String, Regression, Stress/Load/Volume/Scalability, Performance, Usability, Compliance/Compatibility). Create suite of test cases to support complex scenarios. Perform testing of new applications. Work wif customers, developers, business analyst and QA teams to complete test phases.

Confidential - Colorado Springs, CO

Business/Data Analyst, Production Support/Triage

Responsibilities:

• High level of multi-tasking and concentration. Support high volume of projects and overlapping releases wifin strict deadlines.
• Work wif integrated environment of large scale Order Entry and Order Management systems that is part of a complex Service Oriented Architecture environment and is composed of several legacy OM systems.
• Work closely wif customers at all levels, upper level/project managers, architects/DBAs, developers, business analysts and quality assurance teams to understand business needs and define technical solutions via EDI.\
• Create business, functional/technical requirements, design specifications documents, and Requirement Tractability Matrices RTMs.
• Complete end-to-end build and SDLC through approach, assessment, risk/issues management, business requirement and JAD meetings to gather requirements, define business process flows and work flows, plan phasing steps, timeline, design, development, testing cycle, production implementation, and post implementation. Document and distribute session outcomes, requirements, changes, issues, process, workflow.
• Work wif XML, Data Mapping, BOD (Business Object Document) tools for troubleshooting, testing and research as Business Analyst and on Product Support/Triage team.
• Support full System Development Life Cycle (SDLC) wif understanding of various technologies and platforms such as complex SOA (Service Oriented Architecture), ESB (Enterprise Server Bus), BOD (Business Object Document), SOA messagingand system-to-system transformation/ translation (XML, XSLT, DTDs, Schemas),

Confidential - Colorado Spgs, CO

Crystal Reports Developer, Tech Business Analyst

Responsibilities:

• Consult on two person team wif Small Business customers to enhance and accelerate their business (Building Contractors, Electricians, Landscapers, Auto, Photographers, Massage Therapists, Magazines, Salons, Sports).
• Work as main Crystal Developer to design and develop Crystal Reports on customer and company information, rate and price sheets, revenue and profit, statistics and trends in order to halp customers optimize business.
• Work wif MS SQL relational database, tables and Excel database. Help design websites and hosting.
• Work closely and communicate wif customers at all levels and technical team to understand business needs and define technical solutions via EDI.
• Create business and functional/technical requirements, design specifications documents, and report mockups.
• Work through customer interviews to gather requirements, business goals, document business plans, plan phasing steps, timeline, design, development, testing cycle, user acceptance and implementation.
• Work wif customers on pricing, budget, timeline, user acceptance testing. Received optimal feedback from customers regarding increased business from website, visibility, online marketing and advertising.

Confidential - Pleasanton, CA

Lead Crystal Reports Developer, Technical Business Analyst

Responsibilities:

• Work as main Crystal Developer to design and develop Zantaz Security, Auditing and Investigation reports to integrate into customer UI via Java Reporting Component (JRC) SDK using advanced Crystal Reports features (see EDS projects below) wifin strict deadlines. Build Data Security/Compliance reports to support audit, litigation, regulatory compliance for customers and avoid multi-million dollar regulatory fines and brand degradation.
• Source data from DB2 relational databases via ODBC/JDBC connections (ex: stored procedures, views, tables). Use Crystal Reports Designer XI and JRC Viewer, and develop DB2 SQL stored procedures.
• Work closely and communicate wif customers at all levels and technical team to understand business needs and define technical solutions via EDI.
• Create business and functional/technical requirements, design specifications documents, and report mockups. Use and create data dictionaries, relationship database models, schemas and Entity Relationship Diagrams (ERMs).
• Complete end-to-end build and SDLC through approach, assessment, risk/issues management, business requirement and JAD meetings, plan phasing steps, timeline, design, development, testing cycle, production implementation, and post implementation. Document, organize and distribute session outcomes, requirements, changes, issues, process and workflow.
• Perform testing (Unit, System, User Acceptance) of design, user friendliness, function, accuracy, performance.

Confidential - South San Francisco, CA

Crystal Reports Developer, Tech Business Analyst

Responsibilities:

• Work on two person CISO/BI Crystal Developer team to develop complex Product Sales, Forecasting and Case Investigation reports using advanced Crystal Reports features (see EDS projects below) wifin strict deadlines. Build reports to halp BI team and management monitor product and sales trends in order to optimize growth.
• Source data from Oracle relational databases via ODBC connections. Work wif stored procedures, materialized views, tables, data warehouses, data marts, and Crystal Reports Designer XI, Server/Enterprise and SQL Plus.
• Work closely and communicate wif customers and technical team to understand business needs and define technical solutions via EDI.
• Create business and functional/technical requirements, design specifications documents, and report mockups. Use and create data dictionaries, relationship database models, schemas and Entity Relationship Diagrams (ERMs).
• Complete end-to-end build and SDLC through approach, assessment, risk/issues management, business requirement and JAD meetings, plan phasing steps, timeline, design, development, testing cycle, production implementation, and post implementation. Document, organize and distribute session outcomes, requirements, changes, issues, process and workflow.
• Perform testing (Unit, System, User Acceptance) of design, user friendliness, function, accuracy, performance.

Confidential, Plano, TX

Lead Crystal Reports Developer

Responsibilities:

• Design and develop complex Crystal Reports for all branches of Medi-Cal Audits & Investigations Department:

  Medical Review Branch (MRB), Investigations Branch (IB) and Financial Audits Branch (FAB). Our reports halp auditors and investigators monitor provider and beneficiary activity, and target sources and causes of Medi-Cal fraud, which cost California, taxpayers and honest providers millions to a billion dollars annually. Teh reports halp law enforcement defend against illegal Medi-Cal billing for unnecessary services or procedures never performed.

• Develop Revenue Cycle and HR reports for executive and upper management wifin EDS and DHS.
• Develop scripts, queries, views and reports for EDS/Medi-Cal and Denti-Cal accounts wifin strict deadlines.
• Source data from relational databases via ODBC/JDBC connections (ex: Oracle, DB2, MS SQL stored procedures, views, tables) and Excel/Access. Use Crystal Reports Designer XI, Server/Enterprise, and all older versions.
• Work closely and communicate wif customers at all levels, upper level/project management, analysts, developers, DBAs, network and QA teams to understand business needs and define technical solutions via EDI.
• Create business and functional/technical requirements, design specifications documents, and report mockups. Use and create data dictionaries, relationship database models, schemas and Entity Relationship Diagrams (ERMs).
• Complete end-to-end build and SDLC through approach, assessment, risk/issues management, business requirement and JAD meetings, plan phasing steps, timeline, design, development, testing cycle, production implementation, and post implementation. Document and distribute session outcomes, requirements, changes, issues, process and workflow.
• Create testing documents and test data. Lead team and perform all testing (Unit, System, User Acceptance) and code review phases via Use Cases and test scripts. Work wif customers, analysts, developers and QA on testing and user acceptance of design, user friendliness, function, accuracy, performance. Modify reports as needed.
• Train customers and team members how to use final Crystal Reports products and how to develop basic Crystal Reports through full-day courses. Create curriculum, materials and manuals.
• For post implementation support and maintenance, create guidelines, Q&A documents and cheat sheets for users, and technical documentation for support teams.
• Develop reports using advanced features: Multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drilldown through on demand sub reports, dynamic link labeling, group and record selection criteria, commands, cross-tabs, charts/graphs, complex functions and formulas, multi-pass formulas, shared variables, running totals, imported parameters and record sets from stored procedures, conditionally suppressed sections and objects, error handling/messaging, clean and attractive designs, user-friendly instructional ToolTips. Perform SQL querying and coding to support report development and troubleshooting.
• Conduct MEDI-CAL CLAIMS TESTING for all Claim Types (HCFA1500/UB92 - Medical, LTC, In/Outpatient, Vision, X-Over, Pharmacy), Functions (Claims Adjudication, Case Mgmt, Denial of Claim, Explanation of Benefits), Provider/Beneficiary Master Files on Medi-Cal/Medicaid Management Information System using TSO/IPF, File-Aid.
• Support multiple end-to-end projects as Programmer Analyst, coding in COBOL and JCL. Research web integration methods using Java technology and Crystal Enterprise/CR Server, and debug issues.
• Help perform Claims Key Data Entry (KDE). Key corrections from initial claims scanning, imaging and Optical Character Recognition (OCR).