Technology projects of IT Leader Wylie Blanchard - Chicago IL

Reflection: Global Immersion in Brazil 2019

Posted on December 13, 2019December 21, 2020 by Wylie Blanchard

Brazil: Global Immersion 2019 | Wylie Blanchard

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 Amer...
More

Reflection: Global Immersion in Germany 2019

Posted on August 19, 2019October 23, 2020 by Wylie Blanchard

Germany: Global Immersion 2019 - Wylie Blanchard

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, ...
More

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

Posted on July 14, 2016October 23, 2020 by Wylie Blanchard

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...
More

PCP Member Eligibility Secure Email

Posted on May 29, 2016October 23, 2020 by Wylie Blanchard

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, SS...
More

Support Desk Ticket Dashboard: @SpiceWorks

Posted on April 17, 2016February 15, 2020 by Wylie Blanchard

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.
More

Simple Audit of SQL Server Agent: @SpiceWorks

Posted on March 18, 2016October 23, 2020 by Wylie Blanchard

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...
More

Find A Doctor – Mobile App: @SpiceWorks

Posted on February 15, 2016October 22, 2020 by Wylie Blanchard

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 ...
More

SQL Server Enhancements for Developers: @SlideShare

Posted on February 4, 2016October 23, 2020 by Wylie Blanchard

Presence Health Partners - SQL Server Technology Enhancements for Developers - Wylie Blanchard

SQL Server Technology Enhancements for Developers – 2008 to 2012/2014 @SlideShare Your team is planning to upgrade from your SQL Server 2008 environment. Learn what’s new in SQL 2012/2014. Which features and enhancements are really important to the work life of a SQL Server Developer. In this presentation we’ll explore SQL Server 2012/2014 new possibilities, showing you how to use new T...
More

Mobile SQL Server Lab: @SpiceWorks

Posted on December 30, 2015October 9, 2020 by Wylie Blanchard

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....
More