JOSEPH DEMAIO

Experience

• 

  PPL EnergyPlus

  Jun 2011 - Sept 2012

  Database Analyst

  • Designed, created and modified MS Access databases including tables, queries, forms and reports, Access and Excel VBA, and with Visio diagrams linking to multiple back end Oracle databases to accommodate the needs of the back office• Improved processes that utilized Access and Excel VBA apps and supported back office for monthly and quarterly close being on call as necessary• Participated in a team effort to upgrade and deliver Access databases that tied in to proprietary third-party system with an Oracle back end for the accounting department using MS Access as a front end.• Modified Access and Excel apps for upgrade from Office 2003 to Office 2010 Show less

• 

  Guardian Life

  Sept 2012 - Jun 2013

  SQL Server and Oracle Database Developer

  • Developed using PL/SQL packages (procedures and functions) Oracle back-end in collaboration with .Net front-end team to replace obsolete application. • Migrated customer service application from Access back end to MS SQL Server back end customized with VBA front-end code, rewriting functions to work with MS SQL back end. • Designed, developed and implemented MS Access database including tables, queries, forms and reports, using VBA and SQL solutions for Crisis Command Center

• 

  PPL EnergyPlus

  Jun 2013 - Aug 2013

  Database Developer

  • Enhanced and debugged databases as the first-line support for the back-office accountants for monthly and quarter closings involving all aspects of Microsoft Access including VBA, forms, reports, macros. Created and updated reports, forms and processes. • Documented low-level and mid-level data and logic flow for back-office accounting databases with both written details and Visio graphical diagrams. Developed MS PowerPoint presentations for the documentation• Called back after a layoff Show less

• 

  Johnson & Johnson

  Oct 2013 - Apr 2014

  Database Developer

  • Designed, developed and implemented an MS Access data quality application using VBA that identifies and quarantines data errors and downloads them to Excel spread sheets allowing users to upload corrected data.• Designed and developed an MS Access application that writes DDL to customize the migration of MS Access back-end database to SQL Server • Migrated Health Care Compliance application from Access back end to MS SQL Server back end customized with VBA front-end code, rewriting functions to work with MS SQL back end, and rewriting VBA code to SQL stored procedures Show less

• 

  Merck

  Oct 2014 - Feb 2017

  Application Programmer

  Developing an application to model and evaluate risk reduction, life expectancy and cost using high-level mathematics and statistics in Excel with VBA to evaluate relative efficacy, and cost effectiveness for multiple drugs for use by various regulatory agencies in multiple countries.Created a stand-alone VBA add-in to produce tornado diagrams - a bar chart, where the data categories are listed vertically instead of horizontally, and the categories are ordered so that the largest bar appears at the top of the chart, such that the chart resembles a tornado. Show less

• 

  FedChem, LLC (Contractor through TEKSystems - part time)

  Nov 2017 - Apr 2019

  Database Developer

  • Developing a Microsoft Access database to track and report operations for chemical manufacturer including multiple aspects of raw material receipts, product manufacture, testing and approval. • Producing automated reports that include receipts of raw materials, batch records, certificates of analysis, government regulatory, and other reports through a user-friendly GUI front end making use of SQL queries, stored procedures, and functions.• Conferring regularly with senior management to gather requirements, develop testing procedures, and database documentation, including user manual and data-flow diagrams (Visio). Show less

• 

  Dräger

  May 2019 - Nov 2022

  Business Analyst

  Provide US Service Operations and cross functional service teams with business data reporting and analysis. Responsible for database administration, data consolidation, data analysis and management reporting. Utilize various software platforms to generate metrics and develop actionable recommendations. Provide support to service functional teams or management by developing databases, collecting and analyzing data and reporting results based on the needs of end users. Collaborate with various function teams within the service organization to achieve business results.• Develop databases, reports and dashboards using Microsoft SQL, CRM, and SAP to provide key data for use in analyzing business performance and trending information to help drive operational success.• Provide support for Service Department where needed regarding special projects for business data reporting on a monthly, quarterly, and annual basis.• Develop programs and maintain report forms and formats, information dashboards, data generators, canned reports and other end-user portals or resources to measure and analyze the effectiveness of Service Operations for the purpose of driving operating efficiencies and customer satisfaction.• Work in collaboration with the SAP and CRM Service Support Specialists to ensure alignment with data accuracy. Show less

• 

  Lehigh Valley Health Network

  Jan 2023 - Oct 2023

  Performance Data Analyst

  Analyzed and communicated sensitive healthcare productivity and performance-based data to high-level hospital executive management and colleagues within Lehigh Valley Physician Group.• Managed facilities database to track and report site management and facility status for multiple healthcare facilities throughout the network.• Created dashboards utilizing Tableau with Excel and SQL Server back ends to report clinician performance and productivity. • Produced ad hoc reports for senior management team. Show less

• 

  Trinity Life Sciences

  Jan 2024 - Jun 2024

  Database Documentation Specialist

  Database Documentation Specialist working on a contract basis to play a crucial role in documenting the legacy SQL database systems. Key Responsibilities (Job description):System Documentation: Thoroughly document the existing SQL database structures, including tables, relationships, stored procedures, views, and functions, making use of Microsoft Azure AI. Data Mapping: Create detailed data maps illustrating the flow of information within the legacy systems.Collaboration: Work closely with IT staff and database managers to understand and accurately document the existing systems.Best Practices: Recommend documentation standards and best practices for database management.Gap Analysis: Identify potential risks, data integrity issues, or inefficiencies in current systems.Modernization Support: Provide essential documentation to support the transition to new database systems. Show less

• 

  St. Luke's University Health Network

  Jan 2025 - now

  Business Analyst

  Focusing on maintaining and optimizing provider scheduling systems, templates, and decision trees in Epic, ensuring adherence to patient access guidelines, collaborating with IT and operations teams, and supporting performance reviews and scheduling solutions for assigned specialties.