Category: Projects
-
Rollout of Lenovo Laptops/Desktops: @SpiceWorks
Asset Upgrade. Roll out of 100 new Lenovo laptops and desktops. Review of IT department assets revealed an inventory of outdated and out of warrenty user equipment. Review of current equipment contract with Dell reviewed that the contract was not competitively priced. I decided to review other brands and market offerings. Sought out and received…
-
Database Implementation: @SpiceWorks
Installed, administered and developed database solutions utilizing SQL Server 2012 Enterprise – T-SQL scripts, SSIS, Stored procedures, SQ scripting, FTP scripting Consultant: Database Administrator/Developer for Non-Profit Organization -Installed, configured and maintained SQL Server 2012 Enterprise -Monitored replication, job execution, database installations and upgrades -Implemented disaster recovery, backup and restore strategies, standards and scripts -Maintained and enforced…
-
Get a “World Class Web Presence”: @Twitter
Get a “World Class Web Presence that Wows” – Great Tech Pros – http://buff.ly/1fbbFHf pic.twitter.com/5xFNo6fk0r www.twitter.com
-
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…
