Home / Archive by category "Technology Projects"

Technology Projects

Wylie Blanchard’s – Technology Projects

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