With a diverse background in hospital operations, I bring expertise in inventory management, surgical scheduling, procurement, and data analysis. As an Excel expert and a problem-solver, I have created multiple custom tools and workflows to streamline processes and enhance efficiency.Here are some key solutions I’ve developed:- RepMailer Pro: Streamlined vendor rep communication by automating multi-vendor surgical case notifications in just three mouse clicks.- SupplyMailer Pro: Automated supply vendor communication regarding new items and setups within the system.- Vendor Rep Directory: Created a comprehensive directory to improve coordination for surgeries and supply management.- Implant and Instrument Tray Conflict Checking Tool: Designed a conflict-checking tool for implant and instrument trays, ensuring smooth surgical operations.- Human Tissue Database (MS Access): Enhanced surgeon efficiency by developing a database to improve allograft selection.- Patient Scheduling Database (MS Access): Built a scheduling database that boosted efficiency for VNA clinicians and schedulers by more than 200%.- Surgical Supply Forecast Tool: Developed a forecasting tool for Supply Chain to anticipate upcoming item and implant needs.- Operating Room Expense Models: Created detailed expense models to track and optimize operating room costs.- Operating Room Utilization Tool: Built a tool to identify operating room utilization by surgeon, providing insights for scheduling and resource allocation.- Tray Sterilization Support Tool: Assisted Central Sterile Processing with a tool to streamline tray sterilization and scheduling.I specialize in leveraging existing company resources like MS Excel, MS Access, Power BI and other data-driven tools to solve complex problems, improve workflows, and support executive decision-making. My passion lies in optimizing hospital operations, ensuring efficient resource utilization, and contributing to better patient outcomes.
Listed skills include Customer Service, Advanced Excel, Data Visualization, Postgresql, and 28 others.