Mike Scalise

Mike Scalise

My thoughts on SQL Server, Project Management, Fitness, and all points in between

Portfolio

I take a “you first” approach to my projects. In other words, I don’t work on a project unless I think it can benefit others. When I consult for organizations, I seek to understand their needs and wants. I leverage my project management and technical expertise to set clear expectations for what is realistic within their timeline and budget. This approach results in a mutually-beneficial relationship that leads to easy-to-use, effective solutions.

Here is a sample list of projects I’ve worked on over the past two decades. If you have any questions, feel free to contact me.

YearNameDescriptionTechnologies Used
2018Report of Available Software within a Date RangeScript to generate report of Ellucian software releases.T-SQL
2018Inactive Login Suspension ScriptUtility to disable Ellucian Colleague accounts after a period of inactivity.T-SQL
2017MSEARCHUtility to search contents of Unidata files and SQL Server tables from the Unidata Colon Prompt.Envision Basic
2017MLISTDICTUtility to display file dictionaries for Ellucian Colleague Clients that use SQL Server as their database.Envision Basic
2017MLISTUtility to display Ellucian Colleague SQL query results in an easy-to-read format.Envision Basic
2016Unidata File/Field to SQL Server Table/Column MappingUtility that assists Ellucian Colleague clients in a Unidata to SQL migration.T-SQL
2016The Money Challenge TrackerExcel spreadsheet with formulas to assist people in saving money.Microsoft Excel
2016SpeedCloneUtility to make Ellucian Colleague clones more efficient.T-SQL
2016Google To Toggl IntegrationUtility to transfer Google Calendar entries to Toggl time-tracking system.Google Apps Script
2016Audit Script for Newer Software Overwritten by Older SoftwareAudit script for Ellucian Colleague software issues.T-SQL
2015Ellucian Colleague Security AuditScript to display Ellucian Colleague security information in an easy-to-read format.T-SQL
20136x6x2013 – The Gender CollectionGraphic design project for 6×6 – The International Small Art Phenomenon.Adobe Illustrator
2012Transcript Import SystemScript to transfer transcript information from third-party Ellucian to Ellucian Colleague system.T-SQL
2010Web Directory (Faculty, Staff, Students) Refresh ProcessScript to manage information about employees.T-SQL
2010Campus Safety Card Swipe to Ellucian Colleague IntegrationScript to transfer time card entries from card swipe system to Ellucian Colleague system for payroll.T-SQL
2009Campus Safety Parking Permit SystemSystem for managing parking permit and billing information.Envision Basic
2004Naz SchedulerSoftware to convert a Nazareth text-based class schedules to a color-coded HTML tables.Visual Basic 6
2004Disk Error Log (DEL)Software to record floppy disk error and resolution information.Visual Basic 6
2003Killer CountdownSoftware to close specific programs after a given period of time.Visual Basic 6
2003D&M’s Incredible Machine ProgramSoftware to assist in solving The Incredible Machine puzzles.Visual Basic 6
2002Tae Kwon DoSoftware to teach students patterns, forms, and terminology of Tae Kwon Do.Visual Basic 6
2002MP3 RenamerSoftware to make renaming MP3s en masse easier.Visual Basic 6
1999CPatchUtility to patch and customize executable (.exe) files.Private Compiler