David Appleby Email & Phone Number

Cincinnati, Oh, Us

Us

Solutions for Patient Safety - Provide support for underlying database for Solutions for Patient Safety (SPS). SPS is a network of pediatric hospitals working together to eliminate harm.Provide medical data to researchers on various grant funded projects.PostgreSQL development for various projects on as needed basis.Learning new skills as I develop as a data engineer.

New York City, Ny, Us

Designed and built a data hub for the LexisNexis print business. The data hub serves as the central data repository for legal publications sold through LexisNexis Bookstore and third-party vendors. In addition, a tool was built for Sales to search active publications and display relevant information. Fuzzy search and relevance scoring was built from the ground up using tokenized term and trigram inverted indexes.Designed and built the database for the LNNA & UK Event Center app with Microsoft SQL Server. The LNNA & UK Event Center app is a virtual event management platform tailored to the needs of event planners at LexisNexis. Substantial savings are delivered with increasing adoption of the app due to cost of commercial software that would otherwise be required for large events. The cost savings realized with the app permits the company to hold additional events that were not feasible in the past due to budget constraints. Database tables, constraints, indexes, stored procedures, triggers, full audit trail, and scalar user-defined functions were developed by me. The app features an admin portal for event creation (guest list, presenters, breakout sessions) and reporting, followed up with user-experience side for event registration, meeting sign-up, and ability to view recordings of meetings.Designed and built the database for a project tracking app for the LNNA Operations Analytics Team. Full auditing is the key feature of the app that allows managers to view all activity for a given project.Built a Python and SQL Server based report automation tool for Small Law. The automation aggregates training data for new sales reps and creates an Excel file with a simple report for management review.Support legacy applications as necessary.

London, Uk, Gb

I worked with a global team of network engineers, desktop support, and external vendors to deliver unified communications solutions to C-Suite and other executive leaders of RELX business units. - Designed and built an Access database serving as a central repository of critical information for the multimedia team such as site support contact details, endpoint data, and conference room details.- Developed a Python script automating a monthly report and reduced time to complete from 4-5 hours to a matter of minutes.- Designed an Excel form for internal use.- Coordinated and reviewed technology requirements with executive admins for video calls.- Gained valuable experience in various unified communication platforms including MS Teams/Skype for Business and Zoom. Assisted in setting up Webex events.- Connected and managed video calls with appropriate Poly conferencing/analytics tools including RealPresence Desktop, RealPresence Resource Manager, RealAccess, RMX Manager, and RealPresence DMA.

Dayton, Oh, Us

- Provided technical support to library patrons with issues such as network connectivity, Microsoft Office application assistance, and printing.

Cincinnati, Oh, Us

- Implemented laboratory information management system (LIMS) in the Middletown QC lab to reduce redundant data entries and improve productivity.- Reduced lab costs by aligning vendors with parent site and identifying alternative brands/packaging.- Improved manufacturing processes by identifying and correcting root causes of variability.

Cincinnati, Ohio, Us

Beauty Care Technology- Formulated prototypes of personal cleansing products and analyzed data from internal and external product trials.- Successes include being a part of the teams responsible for the launch of Olay Moisture Ribbons body wash and Olay Quench body lotion.- Conducted design of experiments (DOE) studies with JMP.

Abbott Park, Illinois, Us

Hospital Products Division- Developed analytical method for parenteral drug formulation.- Analyzed data as appropriate for method validation.

Bachelor'S Degree, Analytics

Associate Of Applied Science, Data Analytics

Bachelor Of Science - Bs, Chemistry

Sql Nanodegree Program

Nanodegree, Predictive Analytics For Business

Rpa Developer With Uipath Nanodegree