# Erik (@renznest.com)

Profile: https://sifa.id/p/renznest.com
Headline: Senior Data Analyst @ Hallmark HCS | Views are my own

## About

As a passionate and dedicated individual to medical science study and healthcare policy, I am looking for opportunities to make a difference in the compassion, patient care, and disease perception. I hope to do this through means of clinical practice, research, and advocating proven efficiencies in hopes to increase the quality of care delivered to patients; ensure patients are treated as people, not statistics; contribute to the policies that govern how and why care is delivered; and reframe how disease is related to and perceived.

## Experience

- **Senior Data Analyst at Hallmark - Healthcare Workforce Technology** (2026 – present)
- **Lab Technician at North Metro Pool and Spa** (2009 – 2010)
  Tested water samples for pools and spas.
  
  Gained proficiency in titration labs and working quickly and accurately in a laboratory environment.
  
  Acquired valuable knowledge of chemical products and usage in a practical manner.
- **G.I.T. FIT Instructor at Georgia Institute of Technology, Campus Recreation Center** (2008 – 2010)
  I taught two dance classes centered around cardiovascular exercise at the Recreation Center on campus.
- **Waiter/Host at Olde Towne Café on Main** (2008 – 2008)
  Sat customers at tables as well as handled reservations. Took orders and also helped with food preparation in the kitchen.
- **Bagger/Cashier at Publix Super Markets** (2005 – 2007)
  Started as a bagger and helped with customer service tasks. Became a cashier after 6 months. Began basic Customer Service tasks.
- **Consultant BI Analyst at The Southeast Permanente Medical Group** (2023 – 2026)
  Created reporting in Tableau and Power BI for business partners to investigate clinical operations. Helping to align financial and clinical data for better insights into value and budget. Developed Shiny application (Rhino framework) to allow for self-service of ad hoc data requests from business partners. Utilized Quarto sites to publish technical documentation, wikis, and data dictionaries to open data access throughout wider organization and improve data literacy. Analytic lead on care pathway work within organization. Helping to pilot data concierge approach to service requests with an aim to improve analytic resource towards more strategic use in the organization.
- **Solutions Analyst at Northside Hospital** (2022 – 2023)
  Create and maintain a suite of reports across 5 hospital sites and multiple physician practices ranging from financial to clinical using Visual Studio, HTML, JavaScript, Power BI, Netezza, R and Spotfire. Help to maintain database system for the hospital spanning raw to production databases. Investigating ML models for trends within the hospital system.
  
  Developed python scripts to complete data warehouse migration validation (validate records matched across old and new databases) and generation of report to investigate discrepancies.
  
  Created R script for web scraping hospital diversion status and import to database to combine with an ML model to better understand and attempt to predict emergency room capacity.
  
  Taught R to team of analysts to improve skills in the team and work towards integration with Spotfire and Power BI.Included topics in R basics, Posit Studio, Forecasting, Visual Studio Code, and R markdown.
  
  Created geospatial analysis animation to look at patient location against emergency room locations for hospital system over time.
  
  Reworked revenue forecasting model using the fable package. Updated script to utilize the purrr library and decrease code and improve efficiency of scripts. Data was extracted from Netezza data warehouse through automatedPython script which then called rpy2 to automatically run the forecasting methods in R (due to better statistical assurance of models) and sent results back to Python to be inserted back to the data warehouse for consumption by Spotfire.
- **Senior Data Analyst at UK Health Security Agency** (2021 – 2022)
  Led data analytics for a COVID-19 response cell. Reviewed and proposed plan for transitioning from spreadsheet data capture to relational database. Acquired server space for data storage and maintenance. Produced psuedonymized and and identifiable databases for external and internal research to add to global intelligence on SARS-CoV-2 management and national intelligence aiding policy decisions. Produced Power BI reports available to internal team members for accessing and manipulating operational and research data sans coding. Developed quality assurance processes to check database updates were accurate and drove use of GitLab and version control to ensure continuity and open sourcing of scripts. Sourced national datasets and linked to study specific data to answer research questions. Quality checked complex deduplication and matching methods within R. Contributed to pandemic response paper which is currently being submitted for publication.
  
  Helped with other national outbreaks including data linkage, ad hoc analyses, operational report production and new study ethics applications and approval process. Conducted various viral prevalence analyses to compare over years and produced paper quality charts as well as living Power BI report to estimate and monitor prevalence through national surveillance methods.
  
  Deputized by cell lead for various meetings to act as cell representative working with internal and external stakeholders of all grades.
  
  Led cell shift from shared drive storage to SharePoint storage and implemented the use of Kanban boards and collaborative working through Teams and the Office 365 Suite.
- **Information Analyst at NIHR (National Institute for Health Research)** (2020 – 2021)
  Working within the Business Intelligence Unit (BIU) in the South West Peninsula (SWP) Local Clinical Research Network (LCRN) for the NIHR. My role is to help measure and report on the LCRNs performance against nationally defined high-level objectives, urgent public health priorities, and overall recruitment across the SWP portfolio.
  
  I work across all delivery teams to provide up-to-date data on recruitment and performance. I also produce analyses on public data sets to identify areas of disease prevalence for specialties to target recruitment and identify areas of improvement for inclusive recruitment.
  
  Completed the production a new and more efficient monthly and quarterly report template that is automated to ease team pressures and increase awareness of data within the LCRN for internal teams and external directors. Also continuing development on Qlikview dashboards to facilitate independent data review and interrogation for recurring requests. Conduct training on Qlikview dashboards to support teams in where to find and how to use information available for recruitment, performance and data quality.
  
  Worked on a repurposing an internal solution for the SWP team to automate research site selection steps. Completed the update of internal trackers to automatically refresh with up-to-date information to stop data losing meaning and remove manual time-consuming processes for teams. Created an agile workforce management process designed for a team of 20 flexibly working nurses to identify hours spent by location and study with ad little input as possible and linked to a continuously updating and interactive Google Data Studio report.
- **GP Engagement Manager/Project Manager at InHealth Intelligence** (2020 – 2020)
  Management of stakeholder relationships for the South West Child Health Information Service ( SW CHIS) including: General Practitioner staff (clinical and administrative), Local Medical Committee Leads, CCGs, PHE and NHS Commissioners.
  
  Led the creation of social media platforms during the COVID-19 pandemic to achieve engagement with stakeholders. Platforms generated a wide audience and enabled new means of contact and opened new connections with the wider healthcare industry (i.e. NHS England through immunisation campaigns and NHS Digital for NEMS implementation). Tracked analytics across Facebook, LinkedIn and Twitter to see which types of posts elicited highest engagement and views to direct what content should be shared and how best to encourage interaction with the SW CHIS. Utilised a CRM to track issues  across 300+ practices in the South West and ensure resolution. This helped to achieve the culture shift from manual submission of data (.pdf, handwritten, etc.) to electronic methods (system generated reports, direct extraction). These changes helped decrease administrative load on practices and increase accuracy due to reduction of transcription errors. Held online sessions to increase education and awareness of services and address issues affecting multiple practices.
  
  Helped with implementation and updating of extraction methods to include SNOMED CT codes alongside Read2 and Read3. Helped review data issues and internal processes relating to SNOMED extractions.
  
  Led an improvement project to review all internal processes relating to the SW CHIS. The goal was to ensure proper documentation and end-to-end procedures were in place to clarify task owners. This included: assembly of steering and working groups with members from all teams engaged with SW CHIS tasks, documentation of standard operating procedures, and a baseline code review for the service. This was led across the SW, North East London and South West London CHISs.
- **Specialist at Apple Retail** (2010 – 2012)
  Sold Apple products, ranging from iPod Touch to iMac desktops. Learned important computing skills and how to incorporate a wide variety of Apple products in a business environment. Knowledge of operational systems and logistics in regards to stock. Worked daily on SAP: stock overviews, cycle counts, and good receipt & delivery. Placed over RAM upgrade returns and correcting variances linked to this process.
- **Work Study Associate at Dance 101** (2010 – 2010)
  Participated in a Work Study program with Dance 101 Studio in Atlanta, GA
- **Transport Planner & Modeler at Jacobs** (2016 – 2020)
  Consultant in Transport Planning & Modelling.
  
  Office Lead for BeyondZero and Co-Lead for South West BeyondZero Region. Led local team with coordinating events among all Jacobs Networks and bolstered attendance and office participation in events. Ensured global and local events were covered and assisted in office planning to maintain an inclusive and diverse culture that promoted safety, mental health & well being.
  
  Active Positive Mental Health Champion and coordinated Exeter Office efforts with the local PMH team. Drove efforts to gauge staff mental health throughout my year on the team & put forward initiatives to improve office.
  
  Coding of large city network for a Large Local Majors (LLM) and Major Road Network (MRN) scheme consisting of updating a previously existing SATURN model to a 2018 base year and conducting the calibration and validation exercise to meet TAG standards. Completed Appraisal Specification Reports (ASRs) for schemes and assisted in writing the Data Collection Report (DCR) and Local Model Validation Report (LMVR). Also aided in planning forecast model development and checks to be employed on the forecast network.
  
  Acted as project manager on a variety of projects. Projects were rolled over to new PMs upon move but at time of departure, all projects were on budget and on time for delivery or for extension and handover to new company at the end of contract period. Management consisted of weekly finance monitoring, check of non-billed versus billable events and monthly forecasting tasks to ensure projects stayed on budget and on margin.
  
  Management of real time information system for coaches throughout Devon County. Manage data input and contact between data management company and coach operators.
  
  Complete detailed analyses for use within scheme approval reports and technical notes for government and public use. Model user benefits, traffic flows, junctions, and more in line with clients' needs.
  
  Proficient in Excel, SATURN, ArcGIS, and TUBA.
- **Chief Editor at 6med** (2016 – 2017)
  Managing team of 5 other writers. Organization of topics and deadlines as well as final edits and reivew of articles. Publication of Articles online. Authoring articles on healthcare news and medical topics for aspiring physicians and current medical students.
- **Owner at Erik Renz Photography** (2015 – 2017)
  Wedding photographer specializing in reportage-style photography. Creative and unique perspective to wedding photography, capturing the traditional memories and searching out the lesser-known moments of a wedding day.
- **Customer Support Representative at Hearst Health** (2015 – 2016)
  Help clients on queries related to the Hearst Health portfolio in the UK, including: Drug Knowledge Database; Optimise RX; and Map of Medicine. Undergoing training to help field technical support queries.
- **Healthcare Assistant at Nurse Plus UK Ltd** (2016 – 2016)
  Assist in nursing and care homes including: personal care, medications. Full training in Manual Handling, CPR, Medications, and Mental Health/Learning Disabilities.
- **Honorary Research Fellow Associate at University of Exeter Medical School** (2015 – 2016)
  Working with Dr. David Llewellyn in Neuroepidemiology. Performed Scoping of dementia research library as a part of large scale meta-review on dementia risk factors. Partook in a Stata course to develop new statistical analysis skills alongside SPSS knowledge.
- **Clinical Researcher at Hearst Health** (2015 – 2015)
  Research drug formularies for International clients including: medications brands/generic names, interactions, allergic reactions, indications & contraindications, and strengths. Prepare data in system and review entered data for specificity before sending database for production.
  
  Functional Lead for new International development projects for FDB International including resource planning and estimation, project management and data analysis.
  
  Lead on ESN Implementation. I coordinate with a group of 4 other employees to identify solutions provided by the implementation and use of an Enterprise Social Network (ESN; Yammer) as well as integration with Sharepoint. Developed clinical team Sharepoint site to coordinate and aid in the restructuring of the clinical team.
- **Financial Analyst at Northside Hospital** (2014 – 2015)
  Conduct biweekly update meetings for providers attesting to the Meaningful Use Affordable Care Act (ACA) incentive. Contribute solutions to clinical and technical causes of non-adherence to the incentive. Developed tracking spreadsheets to account for a variety of measures and stages of the program.
  
  Performed analytics on different measures inside Meaningful Use to pinpoint problem areas for practices and where to target improvements.
  
  Provided guidance and implementation on function of over 15 different Electronic Health Record (EHR) applications.
  
  Research ACA for current and upcoming changes to financial impacts on the hospital; run analytics on these programs and how they impact hospital revenue and provider payment.
- **Research Asistant at Atlanta VA Medical Center** (2011 – 2015)
  Volunteer for Dr. Madeleine Hackney on the effects of Tango dance on individuals with Parkinson’s disease. Assisted participants to learn steps and complete pre-, post-, and follow-up testing. Taught a six week tango course to a group of 20+ participants. Co-authoring a paper on differences between mono monofocal and multifocal intraocular lenses. Ran statistical analyses and interpreted results. CITI training completed. Presented research at the 7th Annual Emory DOM Research Day and placed 3rd out of 121 poster presentations.
- **Medical Assistant at Internal Medicine Practice of Northside** (2012 – 2014)
  2 years of hands-on medical experience: patient history collection, history of present illness summaries, collection of vital signs, CLIA-waived testing, intramuscular and intradermal injections. Informed patients of lab results and facilitated resolve of prescription related issues. Actively manage provider schedules and acting office manager during times of manager absence. Placed over hiring, training, and management of three new medical assistants. Initiated office change from ICD-9 to ICD-10 coding systems. Placed over the Medicare EHR incentive including: setup of electronic health record and practice management systems to record and track measures, attestation and preparations for the 2014 incentive. These incentives have a potential gain of +$30,000 in total. Assisted in merge from a privately owned PCP to a practice under Northside Hospital, including: inventory, quality assurance, coordinating meetings, and meetings safety and Joint Commission standards.
- **Instructor at Adapted Tango for Parkinson's** (2012 – 2012)
  Taught bi-weekly Adapted Tango classes for a study on the effects of Tango dance on individuals with Parkinson’s disease. Choreographed and directed class. Managed and paired partners to individuals with PD.

## Education

- **University of South Florida** — MS of Health Sciences (2013 – 2014)
- **Georgia Institute of Technology** — Bachelors of Science (2007 – 2012)
- **Blessed Trinity Catholic High School** — High School (2003 – 2007)
- **St. Ursula's School** — Primary School (1999 – 2002)

## Skills

- PostgreSQL
- Shiny
- FastAPI
- Docker
- DigitalOcean
- Data Science
- Quarto
- GitHub
- Computer Science
- Healthcare Information Technology (HIT)
- Google Cloud Platform (GCP)
- Electronic Health Records (EHR)
- Python (Programming Language)
- Epic Systems
- Weightlifting
- Olympic Lifting
- Gitlab
- Git
- iWork
- Mac
- Matlab
- Chemistry
- Microsoft Office
- Teaching
- Customer Service
- Data Analysis
- Aspen HYSYS
- Photoshop
- Dance
- Mac OS
- Management
- OS X
- Aperture
- PC
- iPad
- Photography
- Social Media
- Research
- Final Cut Studio
- Apple Macintosh
- Guitar
- Piano
- Dance Instruction
- Ukulele
- ArcGIS
- SATURN
- TUBA
- Microsoft Excel
- SharePoint
- Microsoft Power BI
- Transact-SQL (T-SQL)
- Biochemistry
- Qualitative Research
- Financial Analysis
- Analytical Skills
- Business Analysis
- R (Programming Language)
- Clinical Research
- Microsoft PowerPoint
- Microsoft Word
- SharePoint Administration
- Virtual Teams
- Microsoft Teams
- Cross-cultural Teams
- ArcGIS Products
- ArangoDB

## Certifications

- Introduction to Python for Data Engineering: Part II Course — Dataquest.io (https://app.dataquest.io/view_cert/7C0QCGL14JW7JTS218XZ)
- Intermediate Python for Data Engineering Course — Dataquest.io (https://app.dataquest.io/view_cert/H0D9PHH2QLFX69TK7CRK)
- Introduction to Python Part 1 — Dataquest.io (https://app.dataquest.io/view_cert/0UYZF71VO1YANEZUOU2Q)
- Programming Concepts in Python Course — Dataquest.io (https://app.dataquest.io/view_cert/WUE1NCLWRKNDZNL28NKJ)
- Introduction to Algorithms Course — Dataquest.io (https://app.dataquest.io/view_cert/VFMEI40ZTHLD5WO1MBWW)
- Command Line for Data Science Course — Dataquest.io (https://app.dataquest.io/view_cert/QR600PFE9OQYYNIUI6K8)
- Text Processing for Data Science Course — Dataquest.io (https://app.dataquest.io/view_cert/08CJO2FTEAOF4ZHKHLPL)
- Intermediate Command Line for Data Science Course — Dataquest.io (https://app.dataquest.io/view_cert/VWT957HNKB4JBPUWG7HI)
- Introduction to Git and Version Control Course — Dataquest.io (https://app.dataquest.io/view_cert/X7M7H2HHTQWP71R93WJ1)
- Intermediate SQL for Data Engineering Course — Dataquest.io (https://app.dataquest.io/view_cert/WYCJL509SONJN3OCCV6L)
- PostgresSQL for Data Engineering Course — Dataquest.io (https://app.dataquest.io/view_cert/ZLT4G00V9ESUXDL39IMK)
- Optimizing PostgreSQL Databases Course — Dataquest.io (https://app.dataquest.io/view_cert/4QWKJNU364AUH2NJYTL3)
- Production Databases Part — Dataquest.io (https://app.dataquest.io/view_cert/PZRE2C7CI4N3UCTTSVUF)
- Adult CPR/AED — American Red Cross (https://www.redcross.org/take-a-class/qrCode?certnumber=015NMNO)
- NumPy for Data Engineering Course — Dataquest.io (https://app.dataquest.io/view_cert/4CUTIWPEKRIFXRXN3MQH)
- Processing Large Datasets In Pandas Course — Dataquest.io (https://app.dataquest.io/view_cert/THXV6FSOUXPREBGCA5SO)
- Introduction to Data Structures Course — Dataquest.io (https://app.dataquest.io/view_cert/G4YDH9VQLE8XNREYSF7A)
- Health Service Modelling Associates 5 — Health Services Modelling Association (HSMA) (https://www.credential.net/5b1cc60f-c0d2-49fb-9a18-dd1962efd14e)
- Eleiko Weightlifting Level 1 — Eleiko
- Academy Accreditation - Databricks Fundamentals — Databricks (https://credentials.databricks.com/19902cf8-3731-42e1-a508-6e286160afcc)
- CPR & AED Certification — American Heart Association | American Stroke Association (http://N/A)
- Spanish — Duolingo
- Introduction to Data Analysis in R Course — Dataquest.io (https://app.dataquest.io/view_cert/OVX28MDDSF9PK79Q849R)
- Control Flow, Iteration and Functions in R Course — Dataquest.io (https://app.dataquest.io/view_cert/GKOUPDDVGEQNL3M8JJ46)
- Specialized Data Processing in R: Strings and Dates Course — Dataquest.io (https://app.dataquest.io/view_cert/RUFXXAP8HICBNZDU3LUQ)
- Data Visualization with R Path — Dataquest.io (https://app.dataquest.io/view_cert/58WZEHE4H7073P0F7MYM)
- Data Visualization in R Course — Dataquest.io (https://app.dataquest.io/view_cert/BIO9GQF1JEK18S7388QP)
- Data Cleaning in R Course — Dataquest.io (https://app.dataquest.io/view_cert/F4BCJCFJBBY27TKPGJ01)
- Data Cleaning in R: Advanced Course — Dataquest.io (https://app.dataquest.io/view_cert/3CXSZOGKU3W5NUERZQHQ)
- Linear Regression Modeling in R Course — Dataquest.io (https://app.dataquest.io/view_cert/TP5EG1YNL0DEGUYS1U8J)
- SQL Fundamentals Course — Dataquest.io (https://app.dataquest.io/view_cert/UE46O6VZUWMZ512O3KDQ)
- SQL Fundamentals Course — Dataquest.io (https://app.dataquest.io/view_cert/UE46O6VZUWMZ512O3KDQ)
- Machine Learning Fundamentals in R Course — Dataquest.io (https://app.dataquest.io/view_cert/QG9E68YLVI3YM6T79QXB)
- APIs in R Course — Dataquest.io (https://app.dataquest.io/view_cert/0FWPV1AFB8WLTQYPZ2NI)
- Web Scraping in R Course — Dataquest.io (https://app.dataquest.io/view_cert/FR1CJFWBNL0MYZJXIL22)
- Statistics Fundamentals in R Course — Dataquest.io (https://app.dataquest.io/view_cert/Q55F0DMWKB9JGO2SZ9ZK)
- Statistics Intermediate in R: Averages and Variability Course — Dataquest.io (https://app.dataquest.io/view_cert/4T7QPVQ1EPIPHH7FL5QZ)
- Probability: Fundamentals in R Course — Dataquest.io (https://app.dataquest.io/view_cert/U1V9ETDG0VEJP2IJT9PZ)
- Conditional Probability in R Course — Dataquest.io (https://app.dataquest.io/view_cert/AX5N5VJU9067HWQXCIAS)
- Hypothesis Testing in R Course — Dataquest.io (https://app.dataquest.io/view_cert/QICQDF27IB3BKAOARKYH)
- Introduction To Shiny Course — Dataquest.io (https://app.dataquest.io/view_cert/D0GQOF53YRNMUZNNWBII)
- Shiny Applications in R Path Part — Dataquest.io (https://app.dataquest.io/view_cert/G9CVQWZ2HHIO9R4LNNIH)
- Data Analyst in R Path — Dataquest.io (https://app.dataquest.io/view_cert/8WZN4NXG3ORXZZME2Z52)
- Introduction to Python for Data Engineering: Part I Course — Dataquest.io (https://app.dataquest.io/view_cert/PJGD0007C8HG7PN2BY8B)
- Introduction to Python for Data Engineering: Part I Course — Dataquest.io (https://app.dataquest.io/view_cert/V6Z6ZIY2YPMOH9NV4B17)

## Projects

- **Spring Dance Show 2012** — https://www.facebook.com/media/set/?set=a.328273950556791.92059.144314752286046&type=1
  Photography done for the marketing of the Blessed Trinity 2012 Spring Dance Show.
- **Renz Nest**
  Personal blog leveraging public datasets to provide clear analysis on topics mixed with some op-ed writing. Purpose is to show the complexity of interpreting data and drawing accurate conclusions.
- **Preact Health**
  Describing your overall health is tough. Made an algorithmic that compiles all the complexity and gives a number from 0-100 to describe your current health snapshot.

## Publications

- Protection from infection and reinfection due to the Omicron BA.1 variant in care homes — Frontiers in Immunology (https://www.frontiersin.org/articles/10.3389/fimmu.2023.1186134/full?&utm_source=Email_to_authors_&utm_medium=Email&utm_content=T1_11.5e1_author&utm_campaign=Email_publication&field=&journalName=Frontiers_in_Immunology&id=1186134)
- Paediatric acute hepatitis of unknown aetiology: a national investigation and adenoviraemia case-control study in the UK — The Lancet Child & Adolescent Health (https://www.sciencedirect.com/science/article/pii/S2352464223002158)
- Biomechanics of Navigating Stairs in Older Adults with Mono versus Multifocal Intraocular Lenses — Journal of Rehabilitation Research and Development (http://www.rehab.research.va.gov/jour/2016/536/pdf/jrrd-2015-02-0030.pdf)

## Volunteering

- Student Volunteer at Grady Health System
- Chaplaincy Ward Volunteer at Royal Devon and Exeter NHS Trust
- Street Pastor at Exeter Street Pastors

## Honors and awards

- 3rd Place Clinical Poster Presentation
- National Honors Society Member

## Languages

- Spanish (elementary)
- English (native)

## Other profiles

- website: https://pitch.preacthealth.com