- Worked on a project to determine why certain records are not coming off the FARBREC - AP outstanding checks report.
- Uploaded and indexing Endowment and restricted fund document images to be accessible through Banner.
- Assisted in Raiser's Edge/Banner FUPLOAD plugin modification and tested for upgrade to Cloud version of Raiser's Edge called NXT.
- Uploaded and indexed School of Medicine check and invoice images to be accessible through Banner.
- Modified Cognos AR reports for Medical School data.
- Assisted in the transition from VPN to Amazon Workspaces by installing and configuring software.
- Modified a Grant Cognos report to allow for selection of more historical data and added JavaScript code to pre-select current fiscal year and period.
- Created Visual Basic and Java programs that check Banner for Finance users that no longer have an active assignment.
- Modified Cognos reports to use cascading prompts and JavaScript to pre-select fiscal year and period. Waiting on review of screen look/layout.
- Created Java versions of Banner FUPLOAD interface programs using the Eclipse IDE, so they are more portable.
- Connected users to Cisco VPN with dual factor authenticaion on Android and iPhone phones.
- Assisted in encryption of hard drives on laptops by enabling secuirty chip in BIOS to allow Microsoft BitLocker Administration & Monitoring to run.
- Tested and set up new connections for upgrade of SQL Server for Microsoft Forecaster Budget Software.
- Worked with central IT to automate the Raiser's Edge feed file process using AppWorx and scripts.
- Created a Fixed Assets report in Cognos that is saving hours of work.
- Created historical revenue and expense reports in Cognos.
- Wrote SQL queries against Production and ODS (data warehouse) tables as needed.
- Added code to my VB .Net program that converts Raiser's Edge output to Banner FUPLOAD format for the Raiser's Edge Event module. This saves the university thousands of dollars the vendor wanted to charge for software customization.
- Upgraded Bank of America Merrill Lynch Image Onsite to the latest version for a couple of users. (Uses SQL Server.)
- Created a parameterized version of Student AR report to assist with data analysis. This saves hours in analysis time.
- Converted Oracle Discoverer Cash Receipts reports to Oracle Reports Builder utilizing PL/SQL.
My Projects