Sharon Morse Email and Phone Number

•Determines business requirements in collaboration with Business Analysts and end users.•Identifies gaps between software functionality and business requirements and suggests potential solutions. .•With assistance from the systems administrators and/or database administrators, installs, configures, and tests package application software.•Determines efficient data sources, processing requirements, output formats, timing issues, and cost factors associated with a new system implementation or upgrade.•Prepares detailed specifications from which programs will be written.•Designs, codes, tests, and documents custom programs and /or changes to application modules and reports of varying complexity.•May develop or assist in the development of training sessions for users or other programmer/analysts involved in systems related work.•Designs, implements, and documents user/technical support procedures. Provides ongoing maintenance support of existing systems.•Works with other computing support groups to provide ongoing support for departments in the use of various College systems, including continuing improvements in system usage, problem resolution, and additional training.•Must maintain a current knowledge of technology trends and development tools/techniques which will include attending workshops, reading journals, and reviewing vendor documentation.•Works independently and in teams with minimal supervision.

DBA• Installation, upgrade and configuration of 10 MS SQL Servers and associated databases in clustered and unclustered environments.• Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).• Responsible for upgrading and maintenance of 13 database applications, SharePoint 2010,Ellucian PowerCampus, Microsoft Dynamics Great Plains 2012, EMS Calendar, Medicat, Helpstar, PowerFaids, Edexpress, Edconnect, Evisions Argos, Cashnet, Management Reporter 2012, FRX Reporting.• Responsible for acquisitions, installation and conversion of all applicable new campus vendor software.• Assisted in creation of Data Warehouse and Data Standards for entire college community.• Instrumental in converting from Citrix platform to VMware VDI platform for all applications.• Experience in implementing different types of Replication Models like Snapshot and Transactional.• Creation and maintenance of databases, creating Roles and managing user permissions.• T-SQL coding and testing: functions, views, triggers, cursors, and stored procedures.• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.• Management of users including creation/alteration, grant of system/dB roles and permissions on various database objects.• Extensive experience in creating Tables, Views, Indexes, Stored Procedures, Cursors, Triggers, packages, scheduling jobs, sending and sending alerts.

• Managed a staff of 7 Application Analysts and associated department budget.• Instituted a new Help Desk software for all staff and students and reduced the number of calls to application analysts by 50%.• Responsible for all Active Directory creation of accounts and groups.• Responsible for Windows authentication to all applicable applications.• Responsible for upgrading and maintenance of 13 database applications.• Management and creation of all Application Web servers and Application Servers.• Documented disaster recovery plans and participated disaster recovery drills.• Responsible for acquisitions, installation and conversion of all applicable new campus vendor software.• Saved the company $15,000 by upgrading the accounting software in house instead of contracting with a vendor.• Member of several user groups for institutional policy.

• Responsible for all client support for independently owned software.• Managed a staff of 2 client service employees.• Responsible for all documented procedures for support.• Responsible for all upgrading of client applications via onsite and Webex.