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+

    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

    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

    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

    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”: @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

    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

    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

    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…