Christopher Gilpin Email & Phone Number

Omaha, Ne, Us

Omaha, Ne, Us

West Des Moines, Iowa, Us

San Diego, Ca, Us

Create, maintain, prioritize, and sequence the product backlog based on business value. Create user stories and acceptance tests from themes and features granular enough for a single sprint. Ability to manage multiple, simultaneous efforts spanning multiple projects and stakeholders.

Author of "Just Having Fun Fishing" - wrote short funny stories for the magazine. Assisted with sales and marketing. Group forum assistant on fishing baits and techniques used.

Lincoln, Nebraska, Us

Columbus, Ga, Us

San Francisco, California, Us

Responsible for designing brand new functionality and solutions for the multiple Credit Card Fraud line of businesses throughout Wells Fargo for the Prevent application. Gathering requirements, working with the technical departments to come up with solutions, built Visio workflows, documented data mapping by reading through XML code, writing ad hoc SQL queries from a SQL Server databases, and creating a technical solution design document (SDD) for the internal developers. Introducing and implementing the system development life cycle (SDLC) and iterative methodologies to help improve the process and the quality of the finished product. o Microsoft SQL Server 2014o SQL Ad hoc querieso Microsoft Visio 2010o Microsoft Office 2010o Snag-It - ver. 13o Altova XMLSpy

Developed design documentation for a proprietary leasing software called Aspire. Researched and troubleshoot issues and documenting the root cause and solutions. Writing Meta Data SQL and ad hoc queries for a SQL Server database for researching and report writing.o Microsoft SQL Server 2014o SQL Meta Data SQL queries Ad hoc queries Microsoft Visio 2007• Utilized the reverse engineering functionality. Microsoft Visual Studio• Ticketing system Snag-It - ver.13 Microsoft Office 2016• Office 365

I managed up to six employees in a production environment. We all worked as a team to design, produce, and install signage products for personal and corporate customers in a timely manner. In-house and on-site installs, sales, graphic designing, printing, car wraps, banners, apparel, and managing all projects.o Graphic Software Corel Draw 7 & 8 FlexiSign Design 10o Printer/Cutter Roland SP540 – 54” Roland VS640 – 64”o Cold Laminator 54” 36”

Omaha, Ne, Us

September 2015 - December 2015Business Solutions Architect Lead, IIBA memberClient: CVS PharmacyMay 2015 - September 2015Business Solutions Architect Lead, IIBA member (Promotion)Client: DIRECTVOctober 2014 - May 2015Business Solutions Architect Client: DIRECTV

Brookfield, Wisc., Us

Responsible for requirements review, analysis and design completion of Evolve Projects and provide oversight to development lifecycle, coding, testing, deployment and production support.Currently working with the executive team on the “Next Generation of Evolve Customer Service & Collections Vendors” project. This entails in working with multiple vendors and provides feedback on current technologies for the next platform along with cost savings for the company. • SQL – Oracle 11g• Oracle SQL Developer v4.0.2• MS Office 2010• CA Clarity PPM• PegaReach Pro:• Evolve Customer Service• Evolve Collections• Evolve Workbench• HTML• Java Script• SnagIt 11

Brookfield, Wisc., Us

First Data Sr Data Analyst (Consultant)Performed data extraction, aggregation, and quality check from mulitple data sources to create business analytic reporting to the executive teams. Worked with the team to documented and train on all of the current processes for a 3rd party consultant firm to take over the business. (The business is moving to India).• SQL – Oracle 11g• SQL – MS Access 2010• Oracle SQL Developer v3.2• Toad for Oracle• SnagIt 11• Office 2010• WinSCP• Oracle Web Apps

Boulder, Colorado, Us

Omaha, Nebraska, Us

Directed the development of applications, administration, and other IT services for the University Relations (UR) division. Managed all aspects of the fundraising database system for UR and cooperation with the IT Department (design, development, implementation, administration, updates, requirement gathering, and reporting.) Served as the interface between UR users and the IT division.

Omaha, Nebraska, Us

Worked with the nonprofit Gift and Pledge business to upgrade the Advance Web application that is used for collecting gifts and donations. Also implemented efficient and standardized processes to increase productivity to meet deadlines.

San Francisco, California, Us

Participate in the analysis, design, development, testing, functional system design documentation, implementation, and maintenance of Microsoft Dynamics CRM 2011 from the business requirements.Customized and develop in the Microsoft Dynamics CRM 2011 for detail design and design walk-through. Worked closely with the business and assisted in writing the business requirements and change requests for the functional system design documentation. Worked closely with the Project Managers to meet deadlines and managing meetings with the appropriate departments.• Microsoft Dynamics CRM 2011• Microsoft Office 2007 (Word, Excel, Access, Outlook, Visio, & SQL queries)• Microsoft Lynch 2010• Sybase PowerDesigner Viewer 15• SnagIt 10• Helios TextPad 5

Reston, Va, Us

Supported the Department of Energy’s (DOE) Office of Electricity (OE) Delivery and Energy Reliability, Smart Grid Technologies, Energy Information Administration (EIA), and Chicago Transit Authority (CTA). Analyzed research data, became a subject matter expert (SME), developed efficient processes in collecting and compiling data to publicize, and assisted in automated data acquisition for the Energy Assurance Daily and Hurricane Situation Reports. I assisted in building a Life-Cycle Cost Analyst tool for CTA in Microsoft Access Database to allow them to project capital costs, emissions, maintenance costs, building new and/or modify depot and fuel stations on a yearly and per bus type basis. Currently utilizing/developing in:• SQL Server 2000 & 2005, Oracle 10g & 11g, and Access 2007• Statistics and Trend Analysis• Report writing in Microsoft Access• Microsoft Visio Professional 2010• Toad for Oracle• Microsoft SharePoint• SnagIt 9

Milwaukee, Wi, Us

• Administered the PrintStream software which includes training and assisting users, developing and testing hot fixes/upgrades, liaison between the vendor and management.• Built relationships with executives, sales, IT, accounting, and external clients to help support and build efficient and marketing applications.• Developed, implemented, and supported Microsoft Dynamics CRM 4 application for the Executive and Sales team.• Developed, configured, and supported Microsoft SharePoint web pages.• Developed, configured, and supported Crystal Reports. • Query building in Microsoft SQL Server 2000 and 2005.• Developed, configured, and supported Direct Edje eCommerce sites for WMI customers.• Technical backup for IT Technician when needed.• Consulted, trained, and supported WMI customers.• Implemented and upgraded MIS systems.

• Developed efficient and user-friendly MS Access databases. • Developed technical and user documentation manuals.• Technical support for business and personal IT systems.• Authorized DELL reseller (2004-present).

• Legacy data conversion utilizing SQL Server, Enterprise Manager, Delphi, DTS, and MS Office• Extracted, transformed, and loaded data using MACC’s standard processes.• Verified data and account balances after each conversion.• Improved and updated conversion processes.

• Successfully lead a team that developed and implemented an automated conversion process that reduce the conversion time by 90%, improve data accuracy by 99%, and allowing sales to increase.• Key activities related to data conversions such as data transfer specification, data parameters, testing and balancing output, and documentation.

Omaha, Ne, Us

• Involved with an engineering team that was responsible to convert the nuclear plants computer system from analog to digital.• Designed, coded, tested, documented, implemented and maintained the ERFCS system.• Developed web friendly PDF documentation for internal web users. • Documented entire testing process of programs from development to implementation.• Programmed in DCL, C, C++, FORTRAN, and SQL in OpenVMS environment with Setcim Database.• Developed internal web pages and programmed in HTML, XML, Java Scripting, and Cold Fusion.• Developed user friendly GUI interfaces in AspenTech GCS, OPCON, and Process Explorer for the Nuclear Controllers.• Trained controllers on how to use the screens.• Utilized ACDSee, Photoshop, and Corel Draw to create presentations for division meetings.

Omaha, Ne, Us

• Developed internal user friendly web reports using Cognos Reporting and Oracle SQL.• Gathered requirements from internal clients and built reports to meet their needs. • Developed detail documentation manuals for business users and technical staff.• Built custom reports for publication on the company intranet.• Utilized Cognos Reporting, Oracle SQL, Impromptu, PowerPlay, PowerBuilder, SQL Plus, Transformer, and Toad applications to build queries, reports, and matrix cubes. • As a consultant, I developed custom reports so quickly and efficiently that OPPD did not have to hire additional report writer staff, thus saving them money.

Wichita, Kansas, Us

• Responsible for installing, upgrading, and supporting backup and recovery windows systems.• Performed assessments, audits, and reviews to evaluate organizational conformity to established policies and procedures.• Developed a 2 day automated process utilizing SMS application to upgrade over 300 PCs and laptops from Windows 95 to Windows NT and upgrade MS Office 97 to MS Office 2000 with only using 2 technicians for support. • Worked closely with upper management to cut IT costs through evaluating, testing, and recommending software and hardware.