Jerry Sorum Email & Phone Number

Serve as project lead on complex projects which required coordination, planning, prioritizing and scheduling work of technical employees during project development, implementation, and maintenance phases.Working with an Agile and Scrum methodology to ensure delivery of high quality work with every iteration.Responsible for the design, development, and testing of an ETL process to harvest data from numerous sources in order to standardize the data to be ingested by a third party vendor… Show more Serve as project lead on complex projects which required coordination, planning, prioritizing and scheduling work of technical employees during project development, implementation, and maintenance phases.Working with an Agile and Scrum methodology to ensure delivery of high quality work with every iteration.Responsible for the design, development, and testing of an ETL process to harvest data from numerous sources in order to standardize the data to be ingested by a third party vendor, Actimize.Responsible for the design, development, and testing of a generic file processing framework which has the capabilities of loading any type of data from the following formats: delimited, fixed-width, and XML.Provide technical assistance and mentoring to other programmers. Show less

● Experience in Database Administration for large and complex databases in SQL Server 2014/2008 R2.● Expertise in Database Administration on production servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.● Expertise in T-SQL writing stored procedures, triggers and functions.● Expert in data transformation services and bulk loads with SSIS and bulk insert ETL operations.● Troubleshoot performance problems… Show more ● Experience in Database Administration for large and complex databases in SQL Server 2014/2008 R2.● Expertise in Database Administration on production servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.● Expertise in T-SQL writing stored procedures, triggers and functions.● Expert in data transformation services and bulk loads with SSIS and bulk insert ETL operations.● Troubleshoot performance problems, fine-tuning of databases and index analysis. Show less

Responsible for the design, development, testing, and certification of an Oracle relational database and .Net client/server application for a robust and dynamic ACC Registry collection engine. Worked under tight timelines in order for GE to be the first vendor certified with the American College of Cardiology (ACC).Analyze and solve complex problems on numerous client sites to restore operations or enhance performance.Serve as a liaison to the Process and Procedure Task Force to… Show more Responsible for the design, development, testing, and certification of an Oracle relational database and .Net client/server application for a robust and dynamic ACC Registry collection engine. Worked under tight timelines in order for GE to be the first vendor certified with the American College of Cardiology (ACC).Analyze and solve complex problems on numerous client sites to restore operations or enhance performance.Serve as a liaison to the Process and Procedure Task Force to analyze and make recommendations to Senior Management for improvements to the Quality Management System.Provide technical assistance and mentoring to other programmers. Show less

Responsible for the design, development, and testing of an Oracle relational database and a Java client/server application for a robust and dynamic content management system which was XML based and required minimal software enhancements (focus was on reusability), which is proprietary to LodgeNet.Responsible for the redesign, development, and testing of an Oracle relational database and software packages for efficient revenue based scheduling, which is proprietary to LodgeNet.Rewrote a… Show more Responsible for the design, development, and testing of an Oracle relational database and a Java client/server application for a robust and dynamic content management system which was XML based and required minimal software enhancements (focus was on reusability), which is proprietary to LodgeNet.Responsible for the redesign, development, and testing of an Oracle relational database and software packages for efficient revenue based scheduling, which is proprietary to LodgeNet.Rewrote a process, reducing processing time from 168 hours to 2 hours.Analyzed and solved complex problems considering computer hardware capacity and limitations, operational time, and form of desired results with innovative solutions.Provided input for strategic planning of systems and applications to the Director of Architecture and Management Team.Responsible for assisting project management in gathering requirements, writing design documentation, test scripts, and implementation plans for new systems and programs. Show less

Redesigned, developed, and tested Oracle relational database and software packages for ingesting revenue data from remote hotel sites.Co-taught a PL/SQL class to other members in the company.Helped rewrite a process, cutting processing time from 72 hours to 15 minutes.Gathered requirements and wrote documentation for new products.Provided technical assistance to other programmers.

Served as project lead on complex projects which required coordination, planning, prioritizing and scheduling work of technical employees during project development, implementation, and maintenance phases.Influenced and negotiated project, product and architectural direction.Facilitated, coordinatedd and communicated with management, the team, the department and our customers with a focus on customer satisfaction.

Prepared Y2K certification documents, test plans, test cases, and test results for the United States Department of the Interior.Provided consulting services to the Microsoft Terra Server Project.Information System Liaison to the United States Geological Survey in Reston.Converted legacy data from 3480 tapes to DLT tapes to ensure data archival preservation.Programmer BDesigned, developed, and tested Oracle relational database and software packages for ingesting different… Show more Prepared Y2K certification documents, test plans, test cases, and test results for the United States Department of the Interior.Provided consulting services to the Microsoft Terra Server Project.Information System Liaison to the United States Geological Survey in Reston.Converted legacy data from 3480 tapes to DLT tapes to ensure data archival preservation.Programmer BDesigned, developed, and tested Oracle relational database and software packages for ingesting different types of metadata and data dynamically from remote mapping centers.Provided technical assistance to other programmers. Show less

Master Of Science, Engineering Management

Bachelor Of Science, Computer Science