Jerah Walter Email & Phone Number

Colorado Springs, Colorado, United States

Englewood, CO

• Simplified PO request process by replacing an Excel form with a C# ASP.NET web application that collects and verifies business logic needed by the Procurement team. After the request is approved, it is transmitted to.
• Created new & maintained existing ASP.NET web forms with C#, VB.NET, AJAX Control Tool Kit and CSS for internal use across the enterprise.
• Developed custom.NET Web APIs to remove direct database connections from applications running on end-user workstations.
• Automated data uploads to an AWS S3 bucket from an on-premises SQL Server using C# Windows Console Application.
• Developed and maintained end user solutions with a SQL Server database backend.
• Used DB links and Synonyms within SQL Server store procedures to load and analyze data across different systems.

Englewood, Colorado, United States

• Developed a solution to streamline a custom invoice approval process used by executive leadership by using C#, Windows Form desktop application, ASP.NET web application, a scheduled SSIS package with a SQL Server.
• Created custom reports within ASP.NET web forms using RDLC (Report Definition Language Client Side).
• Created a web-based application to interface Oracle ERP Inventory to facilitate the transfer of inventory to different organizations within the company.
• Created SSIS packages to load data into SQL Server from various dynamic sources such as custom bank records/delimited files and to send out custom reports to end-users.
• Wrote SQL Server stored procedures to send out scheduled reports to end-users.
• Assisted in upgrading the team’s production SQL Server from 2012 to 2016.

Englewood, Colorado, United States

Englewood, Colorado, United States

• Created and administered Auto IT automation scripts to assist Staff Accountants in inputting data into Oracle.
• Mentor and assist fellow coworkers within the team on company policies & procedures as well as project development.
• Completed Resource Utilization Analysis on various groups within the Accounting department for senior management to make decisions on staffing hours and costs.
• Perform ad hoc queries for end-users utilizing Hyperion Interactive Reporting.
• Created documentation of program development for end-user support.

Englewood, Colorado, United States

• Automated data input from various source files used by Accountants using Microsoft Access and VBA and created formatted reports to Excel using Microsoft Access.
• Interact with individual(s) performing processes to further tailor/customize a solution for the end-user.
• Work with subject matter experts to develop new process maps and solutions for existing processes.

Englewood, Colorado, United States

Boulder, CO

• Created, managed and enhanced database analysis for pre-project planning with SQL server 2000 and Access databases.
• Generated stored procedures for use in end-user applications and company reports.
• Reviewed, evaluated and resolved data issues though the use of adhoc queries.
• Developed, managed and maintained Visual Basic 6 applications.
• Built, maintained, and enhanced custom reporting utilizing Microsoft Excel for Accounting and Sales department.
• Provided product support to end-users for company developed applications.

Greeley, CO

• Managed daily reports to StarTek's clients in a mission critical environment.
• Delivered daily reports by means of remote access, on call rotation, SQL Server 2000, Crystal Reports and Microsoft Excel.
• Resolved daily reporting issues in a helpdesk environment by usage of ProClarify ticketing software, direct contact with the end-user.
• Provided data verification with ad hoc queries through SQL Server 2000 and Analysis Services