Work Experience
Freelance Writer / Fractional Data Services
MARCH 2018 – PRESENT
Established and grew a successful copywriting and data analysis business that provided high-quality writing services to clients in a variety of industries.
Managed all aspects of the business, including client relationships, project management, and financial operations.
Wrote data-driven copy for websites, brochures, advertisements, and other marketing materials, resulting in increased engagement and conversions for clients.
Developed strong skills in copywriting, marketing, and entrepreneurship.
Created data visualizations exploring data acquired from states like Oregon and Michigan to show evidence of lab fraud.
Created data visualizations for ASA’s ‘Regulating Patient Health’ survey of US laboratories.
Educated clients on EHR fundamentals, workflow terminology, and project management principles, and reporting best practices.
Trained staff on NextGen. Created customized NextGen training for COTS/ Customized EHR solution.
Created NextGen custom reports. Monitored compliance activities and created compliance processes.
Implemented HL7 interfaces from analysis to implementation. Coordinated with multiple vendors for dental, lab, and radiology interfacing.
Created onboarding training materials including video.
Created data extracts for ad hoc reporting.
Trained clinic staff on Tableau, created custom dashboards.
Advised non-profit clinic leadership on policy, procedure, and infrastructure issues.
UPMC Health Plan, Pittsburgh, PA — Lead Data Architect (Software Engineer – Expert)
JANUARY 2017 – FEBRUARY 2018
Educated and advised executive staff on key data assets and their value.
Delivered Membership dashboard as a POC in PowerBI / Azure to demonstrate migration capabilities.
Created a 3 Year strategic plan and road map for data development at UPMC.
Created and Chaired IT Data Management team for cross-functional data management program. Architected onboarding process for data from new technology and new partner acquisitions.
Created an interactive training module for all Health Plan employees on basic data governance concepts. Helped create a data steward / information owner committee for data governance.
Created a task force to mobilize data to address the Opioid crisis.
Approved new models for data warehouse development.
Created a project intake process for data projects across the health plan supported by customized SharePoint build.
Assisted in Test Data Management architecture to support new Centralized QA Governance efforts.
Created Process Documentation for the department to echo its growing needs organizationally.
UPMC Health Plan, Pittsburgh, PA — ETL Engineer – Expert
JANUARY 2012 – DECEMBER 2016
Repaired and recreated ETL to support HEDIS Reporting
Created a full test environment to allow for first end to end testing in the department. Implemented Version control.
Created logical and physical models for warehouse including Type 1 / Type 2 SCD’s.
Created and edited all mappings for ICD-10 solution over 400 mappings in a 6 month period.
Tuned ETL mappings (reduced some 24 hour processing tasks to 5 minutes, decreased average load times from 16 hours to 8 hours).
Worked closely with users to strategically align departments with business needs, and discuss the roadmap to future success.
Created ETL / extracts from Informatica repositories to examine usage and compliance to coding standards in addition to creating coding and documentation standards..
Enabled / setup Metadata Manager, Reporting Services, Salesforce modules. Configuration of servers for upgrade to 9.6.
Created Process Documentation for the department.
Mentored teammates on relational database design, data warehousing design. Troubleshooting for over 1,000 active mappings and sessions that built the Insurance Enterprise Data Warehouse.
Children’s Hospital of Pittsburgh of UPMC, Pittsburgh, PA — Senior Systems Analyst
JUNE 2010 – DECEMBER 2011
Senior Systems Analyst, Clinical Data Warehouse Team (Cerner)
Acted as a Project Manager for the Medipac conversion project, Golden Gate conversion project, Cognos universe conversion project teams.
Served on Project Management Lifecycle team to ensure consistent processes across all of Children’s IT. Co-authored paper on data management.
Assisted in creation of RFP and the subsequent vendor selection for an ETL tool. Mentored other employees on relational database design and data warehousing design. Created documentation and department process to support Honest Broker reporting.
Updated departmental process diagrams.
Compiled information regarding SOX compliance and expected controls. Wrote and maintained BI reports and documentation.
Performed documentation audit.
Kaiser Permanente (SCAL / Peak Healthcare), Pasadena, CA — Senior Project Manager / Revenue Cycle Interfacing Expert
JANUARY 2009 – JANUARY 2010
Project Manager / HL7 specialist, SME for Radiology, Cardiology, ESRD, Home Health, and Laboratory billing, coding, and compliance.
Constructed and maintained project plans, budgets, and ROI.
Mentored other employees on relational database design, HL7 interfacing techniques, coding and compliance issues, HIPAA.
Analyzed regional data to support further initiatives and to report on project progress.
Created financial reporting data mart by extracting data from Epic in Crystal reports, and transforming / loading into an easy-to query SQL Server solution
Aviana Global Technologies, Brea, CA — Senior Business Intelligence Consultant
SEPTEMBER 2006 – DECEMBER 2009
In-house (Aviana):
Conducted training for healthcare vertical for sales, technical, and the company overall. Domain / Subject Matter Expert for Healthcare.
Participated as a Senior Consultant in several contracts and engagements. Performed technical interviews for healthcare candidates.
Staffing engagements for several teams including the Systems Integration, Care Vue Reporting, and Oracle Database Implementation.
Cedars-Sinai (Epic, Clinical Data Warehousing, Clinical Reporting)
Performed clinical data validation across 40 metrics created from 200 points of data. Staffing engagements for several teams including the Systems Integration, Care Vue Reporting, and Oracle Database Implementation Team.
Performed clinical data validation across 40 KPI’s with 20 databases.
Created Extracts of many varieties from several databases for CDR (Clniical Data Repository) from EHRs and HL7 messaging.Transformed data and loaded it to CDR utilizing stored procedures / summary tables, along with documentation of procedures and transformations.
Created HL7 interfaces at Engine level in Ensemble.
Performed technical and functional requirements analysis for end-users of Oracle databases and HL7 interfaces.
Assisted in documenting clinical data repository and the 100 related interfaces.
Documented functional, technical, and clinical requirements for over 50 clinical, scheduling, and A/D/T interfaces from / to Epic Bridges.
Alta Med (Clinical and Financial) Data Warehousing
Pre-sales and analysis for an enterprise wide corporate data warehouse. Formulated content of response to RFP as it related to Domain Expertise in Health Care.
Conducted interviews of 40 data stakeholders to establish and document complex functional requirements of a large-scale health care data warehousing project.
Articulated needs as Domain / Subject Matter Expert for internal developers. Assisted the organization in formulating meaningful KPI’s.
Authored the algorithm for the data warehouse’s Master Patient, Master Provider, Master Procedure (CPT), and Master Diagnoses (ICD-9) list.
Authored reports to assist in CMS, HEDIS, and Joint Commission reporting. Assisted in the data modeling and overall design of the data warehouse.
Created Extract, Transform, Load scripting in SQL for some grant-supplied databases (those supplied in ‘Universe’).
OnCure Oncology (Clinical and Financial Data Warehousing)
Conducted interviews with 16 employees to establish scoping requirements for a large-scale data warehousing project.
Wrote Business Intelligence Roadmap that included a full, phased project plan to assess all data requirements and sources.
Arcadian (Financial Data Warehousing)
Conducted interviews with 30 employees to establish scoping requirements for a large-scale data warehousing project.
Wrote Business Intelligence Roadmap that included a full, phased project plan to assess all data requirements and sources.
Acted as pre-sales in order to secure the engagement for the Business Intelligence
Beatson Oncology Clinic, Glasgow, Scotland, UK —Implementations Expert (Associate Physicist)
APRIL 2006 – SEPTEMBER 2006
Developed data standard for Beatson Oncology Centre after evaluating national data needs including MCN data, internal reporting needs, and unique UK healthcare issues.
Proposed national cancer data standard for Scotland based on current clinical data capture and the cancer registry system of other nations.
Developed a reporting suite for VARiS to fit all data needs.
Successfully organized a Go-Live and Implementation date for two months following my arrival to the department.
Developed an infrastructure of highly trained employees to support VARiS within Beatson Oncology Centre.
Created Reporting database.Created Extract, Transform, Load stored procedures from Sybase for data extraction and transformation in reporting database.
Assisted in the development of clinical QA protocols for physics, dosimetry, and radiotherapy based on IRMER regulations.
Authored training materials.
Trained 250+ employees on usage of VARiS, which included standard usage and NHS data-focused training.
Re-architected system to match Beatson’s needs.
UPMC Cancer Centers, Pittsburgh, PA — DBA IV
JANUARY 2003 – MARCH 2006
UPMC Cancer Centers (Radiation Oncology: Financial Analyst III – DBA V)
Documented charge process, scheduling process, and treatment processes in VARiS for Sarbanes-Oxley compliance.
Automated charge process based on levels of treatment and implemented charge interface to Epic. Developed predictive financial reports based on patient scheduling with less than
1% error rate.
Documented Historical Business Structures and Statistical Reporting Methods.
Documented site-specific usage information for VARiS as implemented on a multiple-site multiple- accelerator clustered server, and fitting the complex business needs of a global / hospital-based radiation oncology administration.
Created an Honest Broker System for the department of Radiation Oncology.
Developed a daily statistical package for radiation oncology treatments, starts, and clinical pathways. Developed ETL /datamart to combine data from four EHR sources for daily statistical reporting, ad hoc reporting, referral trending reporting, as well as support casefinding and research initiatives.
Developed training materials on the use of EPIC/Clarity data warehouse with intent for Radiation and Medical Oncology Statistical Gathering.
Developed data quality checking method using several reporting systems to assist in full casefinding. Served as main honest broker of the data for use in Quality Assurance Initiatives.
UPMC Cancer Centers (Finance: Financial Analyst III)
Implemented PeopleSoft 7.5 Financial Reporting. Within weeks, streamlined statistical reporting process from 30 days per report to standard daily statistical package according to the business needs and structures.
Responsible for the reporting of all radiation oncology statistics for a fast-changing, multi-site, multi- system company.
Implemented E&M Coding Distribution Reporting via Crystal Reports using HCFA standardized data and organizing information into charts for ease of dissemination.
Created data mart for financial and statistical reporting.
Designed and implemented VBA code in Access to accommodate stringent medical billing needs. Designed, implemented and maintained Cancer Centers Dashboard reports.
Designed, implemented, and maintained processes for Radiation Oncology CDM, Scheduling, Billing, and statistics.
UPMC CMI Finance, Pittsburgh, PA — Financial Systems Analyst
FEBRUARY 1999 – DECEMBER 2002
Wrote and compiled Financial Analyst training materials in 2000.
Created several cross-functional reports and a physicians scorecard that integrated Epic data with Financial Data.
Produced all monthly Income Statements for 400 physician practices.
Designed Access database to analyze and generate fee schedules.
Created cross-mappings and validated the conversion from DBS to PeopleSoft.
Qualex, Pittsburgh, PA — Customer Service / Data Analyst
JANUARY 1996 – JANUARY 1999
Designed, developed, implemented, and maintained a weekly quality assurance / performance program for over 70 employees spanning 10 departments.
Collected data and investigated troubled cases for quality assurance program across several different systems using several types of data collection (queries, manual tabulation, printer information).
Converted QA program from Excel to Access database in 3NF and created corresponding “Performance Enhancement Training” (PET) Program report ‘suite’.
Assisted PET implementation in Qualex labs nationwide, including written documentation and on-site or in-house training and setup.
PUBLICATIONS
Market Audits Combat Cannabis Misinformation— Co-author, FOIA’d data from states and created data extractions and visualizations.
Federating Clinical Data from Six Pediatric Hospitals: Process and Initial Results from the PHIS+ Consortium — Co-author, created data extractions from Cerner and Honest Brokerage Process Diagrams