Category: Projects
-
MCSA: SQL Server 2012/2014 was issued by Microsoft to Wylie Blanchard
View my verified achievement from Microsoft. MCSA: SQL Server 2012/2014 was issued by Microsoft to Wylie Blanchard on December 29, 2014. Earners of the MCSA: SQL Server 2012/2014 certification have demonstrated the skills required to develop and maintain the next wave of mission-critical environments. They are qualified for a position as a database developer or database analyst. Skills:…
-
Managing OLAP Databases for DBA’s: @Google+
With the growing demand for Business Intelligence solutions it’s important that DBA learn how to manage these (not so new) analytical engines to ensure that data is efficient and secure. In this session, we’ll review Microsoft’s SQL Server Analysis Servies Multidimensional (OLAP) engine. We’ll review OLAP cube design, security, access permissions and other SSAS functionalty important…
-
SpiceWorks Deployment: @SpiceWorks
Deployed SpiceWorks on Non Profit business server for network monitoring and help desk ticket management. Working with a new client with 150 employees and limited IT resources. Current IT team consists of just one engineer (knowledgeable engineer but overwhelmed with requests and fixes). Leadership asked if there was something that we can do about improving…
-
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…
-
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…