- Copied and modified a Cognos security report to give desired results for an IT Budget project.
- 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 expense and revenue 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.)
- Did an analysis of a network drive to see where the most space is used and made recommendations on how to reorganize the directory structure.
- 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.
- Wrote a Visual Basic .Net program for General Accounting that creates a file in FUPLOAD format for copier, trustee and investment charges to be fed into to Banner Finance.
- Converted all Oracle Discoverer monthly Budget reports to Oracle Reports Builder utilizing PL/SQL.
