Category: Projects
-
Reflection: Global Immersion in Brazil 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 […]
-
Reflection: Global Immersion in Germany 2019
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 […]
-
GE Healthcare – Capacity Command Center
Steered the optimization and improvement of java and SQL application processes for hospital encounter analytics. Encompassed the assessment of system architecture, code structure and development procedures in an agile project management environment.
-
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-ins> Go […]
-
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, & C#,: Trizetto’s […]
-
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.
-
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 […]
-
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 […]