Category: Projects
-
Material Status Management: @SpiceWorks
Front End Application incorporating MS Access, SAP & SQL Server – SQL scripting an Visual Basic scripting Material Status Management – Finished Goods and Direct Materials An audit management system for the Data Management area that identifies products and materials that need to be discontinued from production and purchase. The application audits product and…
-
Customer Bill Tracking tool: @SpiceWorks
Created bill tracking tool for client incorporating MS Access, SQL Server and Visual Studio – SQL scripting, VB.Net Customer had a ms access tool for tracking bills that was being used by 25 different employees. Complaint was that the tool would often freeze when one or more individuals was using it or when processing the…
-
Customer Audit Comparisons: @SpiceWorks
Front End Application incorporating 1WorldSync, MS Access, SAP & SQL Server – SQL scripting an Visual Basic scripting An application for Data Analysts to quickly compare and analyze customer audit data. The application imports the product audit findings from the customer and then compares, matches and displays the data with product data listed in SAP…
-
DataSync Central – Publication Delete: @SpiceWorks
Front End Application incorporating 1WorldSync, MS Access, SAP & SQL Server An application for the Data Sync area to update changes to product data that is published to clients. Using data published in 1WorldSync, the application extracts and saves new data from SAP, notifies analysts when the new data is ready to be republished and…
-
Quality Audit System: @SpiceWorks
Stand Alone Application incorporating MS Access – Visual Basic scripting Led project responsible for development and implementation of inventory management database for CDHP Operations area. Process integrated data from 3 different work streams into a central location so that it was user friendly. Project enhanced the quality program of operations area and is the preferred…
-
Production Tracking System – Medical Claims: @SpiceWorks
Stand Alone process incorporating MS Excel & several internal programs – Visual Basic scripting & SQL scripting Developed automated system for Claims area to track and monitor employee production data by linking internal database/mainframe reports via MS Excel, allowing raw data reports to be usable in strategic planning. Execution Time : It took 4 weeks…
-
RDP Scripting – Medical Claims: @SpiceWorks
Internal Application using DOS scripting & Visual Basic scripting Led project to enhance medical claim adjudication for subscript issues for Claims area. Project required combining expertise in business processes and sql scripting to program an internal application to auto process medical claims. Project reduced 2 year back log of Subscript claims by 75 % within…
