Home / Archive by category "Technology Projects"

Technology Projects

Wylie Blanchard’s – Technology Projects

Reflection: Global Immersion in Brazil 2019

Wylie Blanchard - Brazil Immersion 2019
I just returned from a 9 day immersion trip in Brazil learning about their economy and business practices with a group of MBA graduate students from the University of Illinois at Urbana-Champaign. First, let me say that I've always wanted to visit Brazil. Prior to this trip, I had an interest in the economics of South America, along with Africa and the Central American region of North America,...
Read More

Reflection: Global Immersion in Germany 2019

Wylie Blanchard - Germany Immersion
I just returned from a 9 day immersion trip in Germany learning about their economy and business practices with a group of MBA graduate students from the University of Illinois at Urbana-Champaign. My initial interest in visiting Germany was to revisit a country I briefly lived in as a child with my parents. Overall, I feel that the trip gave me a better understanding of German economics, thou...
Read More

Analyze & Visualize SQL Server Data w/ Power Pivot & Power View in Excel

Last updated 05-13-2017 In this tutorial we'll use Microsoft Excel to retrieve data from our SQL Server database. We'll then model, analyze and visualize the data using Excel's Power Pivot and Power View features. Activate the Power Pivot & Power View add-ins          Open MS Excel 2013\2016          Go to File > Options > Add-Ins          In the Manage box, click COM Add-in...
Read More

PCP Member Eligibility Secure Email

Automated, Hippa Compliant, system to email member eligibility lists to Primary Care Physicians. Trizetto's QNXT™ Enterprise Core Administration System & ASM's MD-Staff - Credentialing. Created an automated, HIPAA compliant, process to securely batch and distribute member eligibility lists to PMG/non-Presence PCP's on a monthly basis via individual PCP email addresses.Utilizing SQL, SSIS, &am...
Read More

Support Desk Ticket Dashboard: @SpiceWorks

Heat Call Logging Dashboard - Support Ticket System A dashboard showing support tickets, top 5 queues, sla acknowledge rate, monthly/weekly inventory and monthly/weekly average days to resolve for heat call logging using pie charts, bullet/column graphs and spark line indicators. Originally posted on spiceworks.
Read More

Simple Audit of SQL Server Agent: @SpiceWorks

Who Changed My SQL Server Agent Job? Created process and ssrs report to audit changes to SQL Server Agent Jobs on SQL Server 2008 R2. Created process using SSRS, SSMS, T-SQL, SQL Triggers. Created and implemented process to audit changes to SQL Server Agent Jobs on SQL Server 2008 R2. Created a new schema and table structure to capture audit data for agent jobs. Created triggers on the sysjobs, sy...
Read More

Find A Doctor – Mobile App: @SpiceWorks

Medical Provider Listing - Mobile Application Created back-end development to transform and import provider data in to SQL Server Database. Create backend process using SSIS, C#, T-SQL and FTP, Phynd Unified Provider Management (UPM) Platform. This was a team project combining the web development team and database development Team. I lead the effort for the database development team to create ...
Read More

Mobile SQL Server Lab: @SpiceWorks

Mobile build of a SQL Server Lab that I run on any computer/laptop. Recently saw a presentation on creating a Mobile SQL Lab on a LapTop. I already have one but it's not great at running too many virtual machines, so I decided I'll create a new lab with more power and that's a little different than what I have. After a lot of research on my options I decided to build my new lab with a mini-pc. Wit...
Read More

Security Deployment for Mobile Devices: @SpiceWorks

Deployed Enterprise Mobility Management System for Mobile Devices. Interviewed four companies EMMs options to allow network connectivity and allow our IT team management control. Finally chose to move forward with MobileIron which allows policy setting controls for mobile devices.   1 Month Duration 100-249 Users 100-249 Devices
Read More
Top