Peggy Bishop Email and Phone Number

Ingest device data and transform for analytics and machine-learning. Responsible for end-to-end data engineering of device and system data from source to machine-learning. Engineer data pipelines in Databricks sourced from a Data Lakehouse using Pyspark and Delta Live Tables. Translate customer requirements into clean data for understanding of device trends and to prevent unplanned downtime.

This position is to provide on-going analytics to physicians for healthcare delivery process improvement and to gather data for research projects resulting in publications and conference presentations. Model data to streamline reporting.• Modeled data in a dimensional model to make report development faster• Provided KPI’s around patient outcomes, particularly in model/affinity groups to aid physicians and nurses in reducing harm. Biggest challenge was handling varying data quality in the source data.• Developed statistical process control charts and educated clinicians on the use thereof to improve hospital practices.• Created one of the first COVID-19 visualizations on Kentucky cases and deaths by county; this required use of Python to pull in external data and create extracts to the Tableau Server using Tableau Prep Builder for automation of the data pull.• Sourced patient, physician, surgery, medication, order and encounter data for specific ICD diagnoses, medications, and surgeries for projects from multiple data sources. • Designed Tableau workbooks for delivery to physicians to track daily metrics and to assist in data engineering to prepare data for statistical analysis.• Discovered novel ways to use the tools at hand to tackle highly complex database queries.• Within first three months gave presentations to our technical groups.• Mentored junior team members• Converted SSRS reports to Jasper iReports that is integrated with Oncore, the Web application that tracks clinical research studies.• Established strong relationship with the Vizient Hypoglycemia Measure Workgroup to provide planned and operational support of the “Optimal Care Glycemic Control” Tableau dashboard.• Skills used: data analysis, SQL, Tableau, requirements gathering, statistical process control charts, chemical knowledge of medications

This role was to convert SSRS reports to Jasper iReports that is integrated with Oncore, the Web application that tracks clinical research studies.• Discovered the stored procedures in the original reports and converted to SQL using common table expressions• Reproduced reports in iReports so that they closely resemble the original SSRS reports.• Skills used: SQL, Oracle, SQL Server 2008, SSRS, Java, Jaspersoft

Facilitated the collection and movement of data and information into a star-schema for easy analysis.

Departmental Data Quality sleuth: Analyzed data in OLAP, transactional and Hadoop systems. Technical lead for the Data Quality program using PMI project management principles and Agile sprints. Discovered large opportunities for revenue growth and cost reduction. Utilized AWS EMR, Amazon Redshift, Zeppelin, Python, Pyspark, Java and Pig Latin programming as well as SQL and a variety of reporting tools, depending on the requirements. Mentored junior members in project management best practices, SQL programming and other reporting tools.

Used Microsoft Project to devise plans and timelines, assign tasks, identify dependencies, track resource usage, and watch for slippage.Provided project estimating/sizing, planning/scheduling, risk management, quality assurance, tracking and reporting.Maintained the BO Tracker custom ETL tool I wrote.Wrote Crystal reports and stored procedures as needed as part of BOBJ (SAP - Business Objects) system monitoring.Improved change management and change control using Systems Development Lifecycle methodology and ITIL principles.Enhanced processes to ensure all developers and support teams work the same way, with adequate documentation of requirements, peer reviews, testing and timely delivery.Worked with managers outside my area to persuade them to use these new processes and provided regular updates and presentation of progress and solutions to challenges.As a liaison between the business and the support team, prioritized and tracked change requests and monitored progress ensuring timely delivery and solutions.Tracked systems with different reporting tools to understand problems waiting to surface and plan for remediation ahead of time.Developed mission, vision and strategic statements for Business Intelligence Center of Competency and assisted the team in making key process decisions for BI.Led outsourced teams administering BOBJ and SAP Business Warehouse systems by setting priorities, providing technical advice, creating/monitoring plans and goals.Developed the reporting peer code review design checklists and reviewed other developers’ reports. Made design recommendations to enhance performance and scalability.Installed BOBJ software, set user/group security, trained the BO Admins on use of BO tools, solved rights problems on BOBJ, enabled tracing.Provided estimates for BI projects as needed, including hardware and licensing estimates, as well as ROI.Reviewed BI project plans as requested and provided input to prevent problems before they happen.

Mentored server admins and provided priorities and timelines for change requests.Documented several of the Report Migration and promotions Roadmaps for proper promotion of reports, Business Views and security thereof.Proposed, designed and built the Migration Tracker application and database, and wrote custom utilities to load it so we could track the reports for migration in bulk.Trained migration team members in the proper use of migration tools (BO and my own) leading to the successful conversion of 10,000 reports to Business Objects.Able to track multiple vital properties of Crystal Reports, properties not provided easily by the Crystal Reports servers such as Info View names, success, failure and usage statistics from Crystal Reports servers with the Migration Tracker database. Member of Business Intelligence Center of Competency (BICOC) group and have written standards documentation for all phases of business intelligence.

Served multiple roles on a data warehouse project. Modeled and implemented data marts. Created Crystal Reports against transactional databases and data marts. Designed and debugged ETL scripts. Programmed VB.Net utilities to automate manual tasks. Performed data mart data validation. Wrote Oracle stored procedures and views.

Designed Web pages in Vignette and TCL.