-
Salesforce to Salesforce Migration
Migrated all information from a 3rd party managed package built on Salesforce to the native Salesforce Education Data Architecture, including custom objects as required. All data was retained, including relational integrity. Functionality and security were optimized, and the migration was completed with no operational down time.
-
Salesforce / Jenzabar Integration
Real-time integration between Salesforce and SQL Server-based Jenzabar campus management systems. Using CDATA PowerShell modules, built a real-time synchronization of leads, contacts, online applications, and financial aid information for the admissions department across two divisions sharing one Salesforce instance.
-
Student / Staff Self-Service Intranet
Built from the ground up: a complete student and staff intranet covering schedules, financials, class attendance, ID card creation/management, and automated account creation across four ERP components. Programmed with PHP, XML, XSLT, JavaScript, and SOAP web services; ID creation used fpdf and GD to manipulate images and generate PDFs on the fly.
-
SSRS-based "My Information" System
With no additional licensing cost, transitioned a legacy reporting system with 200+ reports to a centralized, Active Directory-controlled system built entirely in SQL Server Reporting Services. Navigation launches from a customizable dashboard aggregating each user's key information.
-
Salesforce / CampusVue Integration
Real-time integration between Salesforce and SQL Server-based CampusVue, using custom web services and native Salesforce APIs to synchronize leads, activities, and documents for admissions across three campuses and two independent campus management systems.
-
SIS Data Migration — DiamondD to CampusVue
Migrated leads, students, academic records, and historical contact info from DiamondD to CampusVue. Through schema research and SQL profiling, migrated over a decade of data across two campuses — five months, on time, with negligible data issues.
-
ID Card Scanning App for Attendance
Using FileMaker Pro, rapidly built and deployed an attendance ID-scanning solution for convocation events and athletic center attendance, deployable on iPhones, iPads, or any browser-enabled device, with Active Directory authentication via FileMaker Server.
-
Document Automation and Integration
Automated scanning and association of student-supplied documents with multiple back-end systems using SimpleIndex, SQL Server, and PHP — meeting document storage and security requirements while keeping files available through the systems people already use.
-
Moodle Term Rollout Automation
Using Moodle's native web service API, built an automated term-initialization procedure duplicating individualized course templates into every session for the coming term, saving considerable hours across several hundred courses each term.
-
Moodle Multi-Campus, Multi-College Integration
Automated and integrated users, courses, and enrollments from three separate CampusVue SIS systems into a single Moodle instance, enabling shared online courses across all campuses, colleges, and a new online college.
-
Print Magazine Production Management System
Ground-up redesign and deployment of a full magazine production system: multi-tier architecture, automated time and project reporting, mailing list prep, MAS200 billing integration, and complex billing metrics. Data store: a highly relational MS SQL Server database with 160+ tables and 230+ stored procedures; interfaces built in FileMaker Server Advanced.
-
Database Architect for Powergroups.com
SQL Server database design and stored procedure programming for a high-volume groupware web application, including interfacing with components and a distributed multi-tier hardware structure.
