RYAN OTTERBERG

**** ** ***** ***** ******, IA *0021 515-***-**** ade42r@r.postjobfree.com

SUMMARY

DB2 Database Certified

Project Management

Database Programming

Systems Consulting

Technical Liaison

Data Mapping

Function System Design Document Creation

Business Requirements Document Creation

Testing Coordination

Process Improvements

Creation of Testing Guides and Documents

Working Knowledge of Power Designer

Production Roll-out

COMPUTER SKILLS

Languages

·HTML, SQL, PL/SQL, Java

Software

·SAS, SAS EG, Hyperion, Business Objects, Harvest, Power Designer

EXPERIENCE

December 2016 – Present

Independent IT Consulting

•Provide various levels of IT support including, but not limited to database, business analysis, requirements gathering/management, computer support and troubleshooting.

•Create training documentation to help streamline processes and procedures.

•Evaluate collections processes and create standards for consistency.

•Recommends and implements process improvements.

•Acts as a Sales Representative for company.

June 2003 – December 2017

June 2014 – September 2015

Technical Engineer, Grace Church

•Provide support of the church database and daily functionality of its operation.

•User security and group security within the database

•Online Giving and Contributions

•Event Setup and Coordination

•Database Backups

•System Enhancements and Upgrades

•Process improvements on database usage and security settings

•Act as the Projection/Video Lead for the Creative Arts Team that supports projection and video needs for any church functions including but not limited to special events, dramas, musicals, weddings, funerals, etc.

Apps Systems Engineer 5, Wells Fargo Home Mortgage

•Part of the MIDE Production Support team within Consumer Lending Technology (TOG).

•Responsible for initial triage of business and technical issues that relate to the MIDE System, working with MIDE business partners, database analysts, developers, architects, etc.

•Owns and supports the production issue from impact assessment to production implementation and sign off.

•Responsible for ensuring any long-term resolution is identified, captured, evaluated, resolutions developed, and communicated appropriately. Proactively recommends process improvements on ETL procedures.

•Consults with both business and technical partners across different applications to triage the issue. Viewed as an internal consultant with technical and business groups.

•Works with a production support team to understand the issue and focuses on bringing the issue to resolution, escalating as necessary.

•May initiate system testing of identified resolution.

•Prioritizes issues that are currently being worked by the Production Support team based on severity, number of end users impacted, etc.

•Acts as single point of contact / TOG liaison for all business users & technology partner s data needs.

•Provides level 1, 2, & 3 Analysis for production issues deriving resolution to highly complex business data problems in support of the data program

•Creates initial FSD (Functional System Design) artifact for production issues and collaborates with ETL developers for final FSD development.

•Assists in determining size, scope, impacts, risk, and strategy for responding to inquiries that are data program wide, time sensitive and require consistency and alignment to meet the business needs.

•Works with user groups both business and TOG to provide training, resolve questions, assess user needs, and recommend changes.

•Work directly with Quality Assurance teams in coordination of UAT efforts and ensures successful UAT efforts before moving into Production environment

January 2013 – June 2014

Apps Systems Engineer 4, Wells Fargo Home Mortgage

•Within the Real Estate Lending area of the Technology & Operations Group (TOG), acts as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology, tools and existing designs technologies for a mid-scale delivery team in support of the new platform for Wells Fargo Home Mortgage Servicing (Home Preservation).

•Analyzes highly complex business requirements, designs and writes technical specifications to design or redesign complex computer platforms and applications.

•Provides coding direction to less experienced staff

•Acts as an expert technical resource for modeling, simulation and analysis efforts.

•Verifies program logic by overseeing the preparation of test data, testing and debugging of programs.

•Oversees overall systems testing and the migration of platforms and applications to production.

•Develops new documentation, departmental technical procedures and user guides.

•Leads projects, allocates and manages resources and manages the work of less experienced staff.

•Assures quality, security and compliance requirements are met for supported area

•Participate in all phases of the software development lifecycle with various other business units.

•Performs UAT efforts on system enhancements and partners with Quality Assurance and Line of Business users on successful migration through all testing phases into production

January 2012 – January 2013

Business Systems Consultant 4, Wells Fargo Home Mortgage

•Manage contractors/vendors for projects

•Responsible for implementing new processes and ensure successful delivery.

•Responsible for actively managing and driving improvements to data as a business asset across WFHM.

•Engage business units data managers, Subject Matter Experts (SME), and BCD Data Project Managers to capture and document comprehensive and actionable business requirements for the data warehouse

•Act as a Business Requirements Analyst and Team Lead for MIDE and related Data Program activities

•Coordinate all requirements work for both the MIDE integrated layer and semantic marts

•Facilitate Data Requirements review and analysis after Business Unit submission

•Sign-off on deliverables resulting from these requirements

•Prepare requirements bundles for delivery increment planning

•Manage Technology Operations Group (TOG) relationship with the technical data requirements team leads

•Manage ongoing operations of the Requirements Traceability tool

•Provide requirements and coordinate with TOG QA for testing activities

•Work closely with program leadership to ensure requirements associated with key migration activities are complete and actionable

•Assist in the enrichment and deployment of data requirements processes and artifacts

•Support broad-based communications across the Data Program Leadership

•Act as a resource for other requirements analysts

•Performs UAT efforts on system enhancements and partners with Quality Assurance and Line of Business users on successful migration through all testing phases into production

May 2011 – January 2012

E-Business Systems Consultant 4, Wells Fargo Home Mortgage

•Work with various lines of business and application teams converting from one secure access management system to another due to the Wachovia merger.

•Act as a liaison between the converting applications team and Channel Secure trams collecting technical information from the applications team.

•Establish timeframes for development, QA, and production deployments.

•Assist with production deployments.

•Performs UAT efforts on system enhancements and partners with Quality Assurance and Line of Business users on successful migration through all testing phases into production

January 2009 – May 2011

Business Systems Consultant 5, Wells Fargo Home Mortgage

•Acts as liaison between technology and the business for overall data management for Wells Fargo Financial Information Systems

•Works with various line of business to help data users meet their data needs

•Assist with various data related projects working with project managers, data users, and key business partners to ensure timely transitions on meeting data needs

•Monitor budget for data enhancements, data extracts, data source alterations, and data source creations

•Assist with Wells Fargo Auto Finance technical projects

•Works directly with Line of Business partners on successful migration from each phase of UAT into the production environment; creates ad-hoc and automated scripts

January 2006 – January 2009

Apps Systems Engineer 4, Wells Fargo Home Mortgage

Team Lead

•Provides technical consultation and support in the development of computer applications and programs

•Analyzes business requirements, designs and writes technical specifications to design or redesign computer solutions

•Develops original and/or complex code or provides coding guidance to less experienced staff

•Leads and/or performs modeling, simulations and analysis efforts

•Verifies program logic by overseeing the preparation of test

data, testing and debugging of programs

•Participates in overall systems testing

•Leads the migration of applications to production

•Develops new documentation, participates in the development of department technical procedures and designs user guides

•As an escalation point for application support and troubleshooting, provides guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems

•Leads projects, including assignment of tasks, and provides direction and guidance to less experienced staff

•Assures quality, security and compliance requirements

are met for supported area and oversees updating and testing of the business continuation plan

•Supported various DB2 datamarts, Teradata datamarts, SAS Server, ETL processes, general user support (access, query termination, query tuning, SQL tuning), performance monitoring, datamart capacity and performance

•Works directly with Line of Business partners on successful migration from each phase of UAT into the production environment; creates ad-hoc and automated scripts

September 2002 – January 2006

Operations Analyst 4, Wells Fargo Home Mortgage

•Analyzed business issues and made recommendations to maximize operational efficiency, quality and compliance concerns

•Worked under limited supervision to analyze and solve complex operational, systems-related and/or customer issues

•Created and maintains databases and management reports, interpreting data and identifying trends for managers

•Worked with managers to apply data to business goals and analytical requirements, which included capacity planning, volume forecasting and unit costing

•Managing vendor relationships, defined user requirements and performed user acceptance testing

•Managed projects requiring some coordination

•Identified, developed and implemented policies, procedures and training materials to assure compliance with government regulations and to maximize efficiency and customer service

•Provided database support for 15 department databases. Created and maintained monthly management reports and also ad-hoc reports using various reporting tools

September 1996 – September 2002

Property Manager, Noble Homes, Inc.

•General property management for rental properties

• All technical office support

•Created and maintains databases and management reports

•Web Design and Maintenance

•Managing vendor relationships

• Assisted with new construction open houses

EDUCATION

November 2018 – Present

B.S. Information Technology

Capella University

August 2000 – May 2002

A.A.S, Business Information Systems Computer Programming School

Certification in Database Programming Received

August 1991 – May 1994

University Of Nebraska - Lincoln

Contact this candidate