These are all student projects:- They are not polished up in a variety of ways
- The code reflects that students were learning at all levels while working on the projects
- Many of the SIM projects of the past have been used to add value here at the College of Business
AND - Students learned a lot- Organizational value was a key
- Cool technologies were explored
|Improve the Accounting Flow Vizualizer
|Databases in the cloud (Azure) exercise.
Jerome Scott on LinkedIn
|Scripted Group Membership
Powershell script automatically assigns group memberships.
Nick Derrickson on LinkedIn
COB Retention Analysis
Complex SQL statements allow for data inconsistencies and current data architecture to provided needed retention data for the College of Business.
Hongjun Gao on LinkedIn
ETL: Data extracted from a web site are reformatted in a macro to better support analysis.
Excel formulas identify best-in-class funds while allowing for expected changes in the underlying lists. Saves hours of effort performed monthly.
Jason Rizk on LinkedIn
Demostrate extracting transferring data between an Azure SQL database and an Azure document store database
Create a walkthrough that shows how to set up a DcoumentDB database on Azure and how to load data into in using a C# program.
Robert Toumbs on LinkedIn
Quickbooks data is reformualted in Excel into a dashboard for top management to improve financial communication and save time.
|ETL from spreadsheet to QuickBooks for a family business.
Conner Schumacher on LinkedIn
|ESet ETL Project Expansion
Ingests XML from an external provider integrating locally-sourced data to produce data uploaded to a cloud-based app.
Ian Bacon on LinkedIn
|Reads student IDs into an Excel spreadsheet for club attendance.
Jaycob Cooper on LinkedIn
Vania Alfitri on LinkedIn
Chase Ellison on LinkedIn
|Austin Hall ETL
Hourly integration of multi-source data using SQL Stored Procedures, Powershell Scriptings, WINSCP Automation, and Salesforce Data Downloads.
Tyler Acevedo Tyler on LinkedIn
Alex Rooke Alex on LinkedIn
Kyle Copeland Kyle on LinkedIn
Jerome Scott Jerome on LinkedIn
|Automated Sharepoint Online Group Creation
Create project groups for classes in the cloud version of Sharepoint.
Ezra Gross on LinkedIn
Karl Benjamin on LinkedIn
Miles Fajer on LinkedIn
|SalesForce Automation Securely exchange data with Salesforce in a scripted fashion; integrate with other data using a C# program.||OSU Change Management Audit Review change management processes for an OSU client; evaluating risks, controls, and audit objectives to generate supportable conclusions.|
|Scripted Group Creation to support group work in Sharepoint.||Cloud integration: Digital Measures to Drupal Facilitate transfer of data from one cloud system to another, adapting to security and other infrastructure/logical constraints.||A query to retrieve activity on a Sharepoint site to assess participant activity.|