Andrew Berry Email and Phone Number

Vue.js + TypeScript, Java + Spring Boot, MS SQL Server

- Build and maintain data integration projects in C# (pulling data from flat files on network drives or third-party APIs/web services into SQL tables for ETL processes to later consume). This includes the development of a process improvement for terminations, to automatically find terminated employees from HR reports and create ServiceNow tickets for the application access removals. - Build and maintain ASP.NET MVC web projects (known as "Essentials" apps) in C#/TypeScript/React.js for business users to enter data - Expose JSON API endpoint for Tableau dashboard to consume data in one of the Essentials applications - Create and maintain database tables and procedures in dev to support Essentials and integration apps - Set up Jenkins pipelines to simplify deployment process for Essentials and integration apps - Carry out various administrative tasks related to essentials access and document management (DocLink)

- Used SQL, Tableau, and BI reporting tools such as Oracle BI and SAP BusinessObjects to resolve data questions and reporting needs for users across the university, as well as external stakeholders such as college ranking agencies, SACS accreditation auditors, and government entities. - Used data processing tools such as SSIS, R, and python to move data between RDBMS systems (Oracle, MS SQL Server) - Used C#, VB.NET, JavaScript, R, and python to maintain legacy web applications and create utilities/processes to simplify day-to-day tasks - Examined ETL jobs in IBM DataStage to determine data lineage of warehouse data points to diagnose and resolve data issues

- Developed and maintained web modules using DNN (formerly known as DotNetNuke), C#, JavaScript, CSS, and HTML for learners and instructors within the Savant virtual campus/academy, as well corporate site internal apps for employee use - Developed stored procedures and created data models within EntityFramework visual ERD designer to support data needs of web apps

As lab technician, I performed tasks for the professors in the Computer Science department such as account creation, software installation and maintenance, and troubleshooting lab equipment

Serve concessions, cleaning, and stocking food items.