Dean Barrett Email & Phone Number

Bloomington, In, Us

Bloomington, Indiana, United States

• Create/modify T-SQL Tables, Views, Stored Procedures, etc. for enhancements to production systems• Write/refactor C# code for new features or bug resolution in .NET Core (MVC, EF, Vue3) applications• Serve as Scrum Master for development team• Work with Product Owners to refine feature requests into actionable developer items• Document developer and system processes to establish team norms and increase transparency of system behaviors• Converted necessary data from Oracle 12 legacy system to MS SQL Server 2019• Established and documented database conventions (naming, data types, etc.) for all converted data• Created templates to document column-level decisions for each converted table to aid all project members• Led stakeholder conversations converting loose "story" definitions into actionable specifications• Created spreadsheet templates to aid developer understanding of written functional specifications down to the field level• Revised Active Batch (job scheduler) plan to use a "critical path" structure to aid in error resolution and recovery

Bloomington, In

• Supervised three managers of programming staff for data and application development• Set team development priorities in sync with organizational priorities• Managed developer workload, deployments, and customer feedback using Jira• Configured Cirrus Identity to use Social Login for alumni and donor-facing systems• Established system integrations between Blackbaud CRM and Salesforce CRM, Commerce Cloud, and Marketing Cloud• Built/altered tables and ran ad hoc queries against MS SQL Server databases• Created initial processes for data integration and security on a Tableau Cloud Server implementation• Administered Google for Education instance for the alumni.iu.edu domain• Developed and maintained custom Microsoft .net (C#, MVC) web applications• Maintained Web and SQL Server for a full-sized developer instance of Blackbaud CRM• Merged and deployed code for in-house applications and vended system customizations (Git)

Bloomington, Indiana Area

• Manage all phases of the system development lifecycle for alumni information systems• Develop and maintain ASP.NET (C#) web services and applications• Oversee front-line support (helpdesk) for alumni who use our technical services• Configure and manage vended software solutions (Blackbaud CRM, iModules)• Co-manage developer workload with IU Foundation peer using Jira• Develop coding, business process, and documentation standards for IT team• Build/alter tables and run ad hoc queries against MS SQL Server databases• Maintain web and SQL server for a full-sized developer instance of our CRM

* Managed the support of Indiana University's TIME application across all campuses* Documented and prioritized all bugs and enhancements for development team* Tested all system enhancements and bug fixes before production release* Served as functional lead for supporting systems (HRMS, OneStart, IUIE, and Workflow)* Assisted Java developers with complex business logic specifications and coding* Acted as business consultant for Timekeeping collaboration with USC

* Developed J2EE web applications using Eclipse, Struts, OJB and Spring on Tomcat server* Designed/modified user interfaces using JSTL, JSP, CSS, HTML, and JavaScript* Reviewed/refactored code submitted by team members for functionality and team standards* Clarified/revised functional and design specifications to meet system requirements* Built/altered tables, ran ad hoc queries, and created SQL scripts on Oracle 10g* Created/revised Java team standards and deployment documentation in Confluence* Served as backup to Java team technical project manager

* Ensured PeopleSoft and HRMS Electronic Documents (eDocs) met stakeholder needs* Created specifications for modifications to PeopleSoft and HRMS eDocs* Tested IU customizations and PeopleSoft upgrades before production release* Provided systems support and training for central office users in eDocs and PeopleSoft* Administered Flexible Service component in PeopleSoft * Managed overhaul of Online Application System (OLA) into university-wide application* Coordinated testing, reporting, and functional implementation of annual budget load to PeopleSoft HRMS

* Tested HRMS functionality against current business procedures* Documented procedures for Benefits Administrator and end-users* Developed expected results of legacy system for scripted testing in HRMS

* Interviewed customers to discover their website needs* Developed ASP, JavaScript, and VB Script code to deliver dynamic content* Formed navigation structure, color schemes, and graphics for web use* Constructed interactive web elements with Macromedia Flash* Created database structure and queries for ASP delivery

Bs, Computer Information Systems

Activities and Societies: Alpha Iota Delta top 1% of graduating seniors.

Ms, Master Of Information Systems

School of Library and Information Science

Graduate Certificate, Business Analytics

Nanodegree, Mobile Web Specialist

This was part of the Grow with Google challenge. 10,000 students were awarded an initial scholarship to the program for a trial.

Certificate, Small-Business Management