Gregory Peterson Email and Phone Number

• Administered the several SQL Server databases and processes at the 16 campuses which included restoring and backing up databases and included optimizing queries and tables.• Created an automated process to compile three separate calculations and their related statistical data to store the data in a database that interfaces with Excel which saved the registrars hours on a daily basis.• Created four automated ETL processes using SSIS to import data into the campus databases from… Show more • Administered the several SQL Server databases and processes at the 16 campuses which included restoring and backing up databases and included optimizing queries and tables.• Created an automated process to compile three separate calculations and their related statistical data to store the data in a database that interfaces with Excel which saved the registrars hours on a daily basis.• Created four automated ETL processes using SSIS to import data into the campus databases from contracted financial institutions• Developed several queries to interface with the Blackboard system to keep track of attendance and to create new users in Blackboard and enroll the new users into their classes• Created and repaired stored procedures and views to adjust for changes to import processes and changes to export processes• Created automated processes that sent student attendance data and student enrollment data to two third party companies that processed student loans• Participated in two conversions of the student information system Show less

• Create new procedures for the ETL processes of data from the ElDorado database to the clients FTP sites• Add new features to the company API interfacing with the database• Modify the web site to accommodate new features of the organizational portal

• Created and modified reports and processes using MS SQL Server, SSRS and SSIS for eClinical Works• Created a web application to record facility forms from the web that had the capability to save unfinished forms so that they could be completed and submitted at a later date in case of emergencies and the application had the option for the manager to modify the questions on the form• Created a web application that facilitated peer reviews for the doctors so that patient visits could be… Show more • Created and modified reports and processes using MS SQL Server, SSRS and SSIS for eClinical Works• Created a web application to record facility forms from the web that had the capability to save unfinished forms so that they could be completed and submitted at a later date in case of emergencies and the application had the option for the manager to modify the questions on the form• Created a web application that facilitated peer reviews for the doctors so that patient visits could be reviewed and evaluated by other doctors in the same specialty with the option for the doctor being reviewed to dispute the review• Created an SSRS report for coding review that saved an employee at least one hour on a daily basis• Created web page applications using Visual Studio MVC Razor, ASP .NET and C# with Bootstrap• Created web pages for modifying internal databases using MS Web Forms• Created and maintain ETL procedures to retrieve and utilize data from outside sources into the database• Created and modified dashboard screens using Dundas Dashboard• Used Kanban for project development Show less

• Developed SQL scripts for reporting and data analysis with a MySQL database for Granville Homes• Assisted with data analysis and data validation on a special project with Granville Homes

• Modify current processes to incorporate latest USDA specifications for ETL procedures• Develop an Excel spreadsheets for data entry and error checking for herd test day data• Reproduce production reports in 4D• Create processes to produce special reports for customers• Create reports in MS Access prior to converting old UNISYS database system to Oracle

• Developed solutions for new processes for the student records system• Modified and enhanced current processes in the student records system using PeopleSoft and Oracle• Developed functional and technical specifications for all modifications to the PeopleSoft system• Developed special reports for management using the PeopleSoft system and Oracle