Lynn Umbarger Email & Phone Number

Troy, Mi, Us

Troy, Mi

• As an admin, set up a JIRA Storyboard for a dozen work streams (over 40 users) to enter stories into to communicate their requirements for a Private Label Servicing (PLS) offering (medium-to-large scale project) whereby Flagstar Bank services mortgage loans on behalf a mortgage origination clients using the clients’ logos and names when communicating with the clients’ borrowers.• As an admin, set up a Confluence website for the PLS Project tracking, requirements, process flows, project plan, action items, meeting minutes, etc.• In Black Knight’s MSP application, worked with the Testing Center of Excellence (TCOE) to enter test data into the test region (P7), configure headers and loan screens, identify affected outbound reports, External Out files and LFNs that had PLS ramifications. This data would eventually make its way downstream to our internal Data Warehouse where it would be exposed to web services of various applications like Flagstar’s IVR, CRM (Salesforce) and borrower-facing website MyLoans. • Created Business Requirements Documents (BRDs) and gathered requirements for the PLS Project and verified requirement validity and thoroughness through a series of collaborative requirement gathering sessions with each of the business units that owned part of the PLS process.• Environment/Tools: Admin for Confluence and Jira, Toad for Oracle 12.6, Black Knight MSP, HTML, Microsoft tools: Visio, Project, PowerPoint, Excel(Pivots); Communication Tools: WebEx, Global Meet, Snipping Tool, Cisco Jabber

Southfield, Mi

• Took part in a Connected Vehicle, Sales/Plan & Define effort for client VW of America to enhance and augment their existing Vehicle Communications Ecosystem utilizing Over-the-Air (OTA) updates and Identity Management (IdM) cloud components.• Identified multiple components such as: Customer Web Portal (Mobile phone UI), In-Vehicle App/UI, Telematics Data Management, Call Center UI, Dealer Interfaces, Billing/Subscriber CRM, Third Party Integration points.• As a Confluence Admin, extracted user requirements from various client presentations, client websites, meeting notes, discovery sessions, etc. and created Business Requirement Documents (BRDs) and Architectural Strategy Documents (ASDs). • Created Gliffy diagrams (Confluence diagraming tool) for process flows and architectural data components for the BRDs and ASDs and worked with developers and architects to identify code vulnerabilities or potential programming exploits and close them down prior to development.• Environment/Tools: Confluence/Jira, Microsoft tools: Visio, Project, PowerPoint, Excel; Communication Tools: WebEx, Global Meet, Snipping Tool, Cisco Jabber

Troy, Mi

• Project 1: Performed a series of (Agile) updates, enhancements and bug fixes to the Warehouse Line of Credit (Warloc) application. These lines of credit were real estate secured short-term lines of credit that allow mortgage bankers to fund loans into the secondary market until the loans are purchased by the end institutional investors. These updates were part of a monthly production, change control cadence.• Requirements were gathered from the users in the Warehouse Lending business unit, they were then entered into Jira where they were tracked via Epics/Stories/Tasks or Test Cases, throughout the development/test/release lifecycle. Performed System, Regression and UAT type testing.• Updates to application documentation called the Application Information Document (AID) and any affected process flows that may have changed were performed using Visio/Word. These and other deployment artifacts were then entered into ACM/P8 documentation and content library for auditing purposes.• Worked with the Testing Center of Excellence (TCOE), Production Release team, Web Developers, DBA’s, etc. during production deployment to ensure proper installation of new releases.• Project 2: Performed staffing, resource coordination and work stream development for a Private Label Servicing (PLS) offering (medium-to-large scale project) whereby Flagstar Bank would take over mortgage loans to service after origination at the client’s institution. Monitored budget, expenses, P.O.’s, etc.• Created Business Requirements Documents (BRDs) and gathered requirements for the PLS Project and verified requirement validity and thoroughness through a series of collaborative requirement gathering sessions with each of the business units that owned part of the PLS process.Environment/Tools: Jira, Toad for Oracle 12.6, .Net, HTML, Microsoft tools: Visio, Project, PowerPoint, Excel(Pivots); Communication Tools: WebEx, Global Meet, Snipping Tool, Cisco Jabber

Lansing, Mi

• Used Agile/Scrum methodology to obtain user stories, develop wireframes, and to compile and prioritize product backlog to be developed and tested in two week Sprints. Performed sprint planning, product backlog refinement, and participated in daily stand-up scrum meetings. Coordinated User Acceptance Testing (UAT) with the application business owners and reported status up to project stakeholders.• Documented business processes and requirements for an Offender Management System (OMS) using Microsoft Dynamics CRM. Used Visio and various MS Office Suite tools to gather and document business rules and requirements. Utilized SharePoint for document storage and versioning and Team Foundation Server (TFS) for code storage and versioning.• Performed data analytics on integration data transferred between OMS and other DOC systems like OMNI, LEIN, OTIS, etc. Determined course of action for dropped data and initiated an analytics dashboard to be used by project stakeholders.• Documented and diagrammed entire portfolio application landscape with emphasis on application interfaces. Created web-facing diagrams that allowed the visitor click on and drill-down into more detailed diagrams of the various interfaces.Environment/Tools: Microsoft Dynamics CRM, DB Artisan, Scribe (for data integration), MS Visual Studio, SQL Server Manager Studio, Team Foundation Server (TFS), SharePoint, Microsoft Suite of tools, MS Visio, Internet Information Services (IIS) Manager, HTML

Troy, Michigan

• Documented business processes for a web application replacement effort. Existing application written in ASP.NET to be replaced by similar functioning SharePoint site and forms. Used Visio in the documentation and requirements gathering phase.• Owned and maintained over a dozen web-based applications (most written in .Net) that accessed SQL Server and Oracle databases. Most were internally facing however several were external. Would fix or triage the application before hand-off to developers in an attempt to short cycle any development corrections/costs. Performed unit, system and regression testing and coordinated User Acceptance Testing (UAT) with the application business owners.• Managed and participated in many migration projects and efforts including (but not limited to): Active Directory Services (ADS) 2003 to ADS 2008 for domain consolidation, Dot Net 1.0 to .Net 4.0, SQL Server 2005 to SQL Server 2008, Windows XP Professional to Windows 7, SharePoint installation, etc..• Re-engineered and documented complex job stream that picked up two dozen plant-FTPed data files, concatenated them into single files that were uploaded into Focus databases via Webfocus Data Migrator jobs. This DB was then read by Oracle PL/SQL stored procedures, error checked and written to an Oracle database, where the users could access this data via an ASP.Net web application.Environment/Tools: SQL Server 2008, Oracle 11g, SharePoint, .Net and ASP.Net, Microsoft Suite of tools, SSH Tectia, Toad, iWay Data Migrator, MS Visual Studio, SQL Server Manager Studio, Oracle DB Developer, Remote Desk Connection, Internet Information Services (IIS) Manager, HTML

Auburn Hills, Michigan

• Gathered goals, objectives, business and system requirements to create use cases and to-be process flows for the installation and configuration of an “out of the box” fraud detection system solution called Intellinx• Co-led workshops with the Financial Intelligence Department to develop business rules that would identify internally suspicious activities such as the extraction of personally identifiable information (PII) used in identity theft and various policy violations such as celebrity look-ups• Met with the Corporate Information System Services department to developed business rules for externally suspicious activities such as: spam attacks, phishing, account take-over, protocol tunneling, and cross-channel attacks/distractions to determine if an out-of-band-authentication was necessary• Collaborated with the Network Infrastructure Team to re-visit cost and effort estimates on the hardware/software requirements for new router and switch taps and/or mirror ports, cabling, database farms and back-up/disaster recovery solutions • Authored the necessary project artifacts to prepare for the upcoming Design Phase gate passage• On another project; worked with the Global Capital Marketing department on gathering requirements for an Intellectual Properties Attorney invoicing system that would accept USD payments made by an inventor that would pass through the Comerica Foreign Exchange department to a patent attorney in a foreign country• Utilized Compuware's Optimal Trace to input requirements, goals and objectives for traceability Environment: MS-Access, HTML, MS Office Tools, OptimalTrace, Harvest/BladeLogic

Farmington Hills, Michigan

On contract to Daimler Financial Services • Gathered business and system requirements and created process flows for installation and configuration of an existing Contract/Portfolio Management System• Co-lead workshops to gather additional requirements from the client• Prepared Business Requirement Documents (BRD) for client verification• Authored Functional Specifications Document for the design team• Developed to-be process flow diagrams, with concentration on interfaces to the current local landscape applications

Auburn Hills, Michigan

• Developed Business Process Flows for client/user verification• Gathered business and system requirements for web enabled application to replace an existing MS-Access application• During JAD Sessions, developed the following System Development Life Cycle (SDLC) artifacts: Project Charter, Project Risk and Complexity Worksheet, Business Requirements Document (BRD), System Requirements Specifications (SRS), Use Cases, Functional Decomposition (of existing system), Build Vs. Buy Worksheet• Utilized Compuware's Optimal Trace to input requirements, goals and objectives for traceability and business process flows, enter time into Compuware’s Changepoint tracking softwareEnvironment: MS-Acess, HTML, MS Office Tools, OptimalTrace, Harvest/BladeLogic

Dearborn, Michigan

• Entered test cases into HP Test Director using User Interface Specs and Uses Cases as inputs• Developed Use Cases for ID&Assess phase of the present project cycle and interpreted UML documents• Gathered business requirements/rules from the customer during JAD sessions and updated descriptions into OracleDesigner• Updated and created logical process flows (in iGraphix) based on business rules and logical data model• Worked with Central Architecture (CA) team in an ongoing capacity to ensure Vehicle Product Offerings (VPO) documentation was compliant with the latest standards• Created all initial versions of VPO Application Program Interface (API) Call-Frames and published to the rest of Financials At the Speed of Thought (F@ST) team• Worked with testing resources to identify test cases and scenarios from paths through the logical process flows• Scheduled and moderated program spec technical inspections with the DBAs, SMEs, and CA team• Tracked, updated and moved all logical documentation on the VPO effort up into PVCS (source code management library), retrieved and published as necessary• Assisted Project Management in collecting and compiling project team statuses and time usage• Worked with other project teams' BAs and IT leads to develop APIs• Scheduled and moderated CA team, DBAs and SMEs VPO code reviewsEnvironment: UML, Oracle, SQL, PL/SQL, Oracle Designer, DevPartner, iGraphix, Oracle Forms 10i, UNIX Shell scripts, SQL*Plus, Vi editor, TOAD, EditPlus 2, MS Project,

Greater Detroit Area

See all contract positions below

Southfield, Michigan

• Developed and maintained client’s Loan Servicing System (LSS), and championed functionality enhancements to reduce costs for client by $10,000 per month.• Established web-based central repository for company’s Intranet, detailing business work flows and information data flows within 50+ page site, and serving as training tool for client's business users and IS department.• Supported loan servicing system to interface with other systems such as Oracle Financials 11i, web-enabled credit application submittal system, credit bureau request/response system, and various bank wire/payment transfer systems.• Flowcharted major Oracle packages, jobs, and components to facilitate gap analysis against perceived business rules.• Conducted root cause analysis to identify sources of problems and execute corrective action. • Recommended and implemented continuous improvement processes. Environment: Oracle, SQL, PL/SQL, SQR, Oracle Forms 6i, UNIX Shell scripts, SQL*Plus, SQL Navigator, MS-Access (ODBC), Vi editor, TOAD, EditPlus 2, MS Project, Brio

Southfield, Michigan

• Defined business requirements for web-enabled credit application submittal system and delivered internal staff training.• Created system integration test scripts, and provided senior management with technical architecture and approach presentations developed in PowerPoint.• Collected business and functional requirements for software migration project to be re-written as a suite of 25 Microsoft Access, Visual Basic, and Excel applications. • Documented business processes and made several site visits across North America to identify and clarify additional requirements.• Planned and designed several interface points between other external systems. Environment: MS-Word, MS-Excel, MS-Access, MS-PowerPoint, Visual Basic, Visio, XML

Troy, Michigan

• Participated in Y2K compliance efforts, lead projects involving Electronic Data Interchange (EDI) of shipping data, and successfully executed several migration efforts.• Migrated EDI system from MVS to VM/CMS in order to FTP documents to a UNIX box running Radley EDI and CARaS EDI translators.• Supervised 10 development team members on 7 different projects.• Spearheaded Y2K testing for applications that included: Order Entry, Shop Floor, Purchasing, Repetitive Manufacturing, Accounts Payable, Bill of Materials, Inventory Control, and Scrap/Cost of Sales - all modules of the Cullinet Application System (IDMS/COBOL).Environment: EDI, COBOL, IDMS, Radley EDI, CARaS EDI, Gentran, EDIFACT, VM/CMS, MVS/JCL, FTP, FILEAID

Troy, Michigan

• Participated in supplemental staffing capacity for Human Resources and Payroll department. • Engineered screens in CICS, authored reports in COBOL, and maintained payroll system developed in COBOL II.• Analyzed and redesigned employee contribution tracking system written in QBASIC utilizing smart databases and Novell network printing functions.• Headed analysis, design and programming of an Employee Arrearage Tracking system which stored payroll deductions in VSAM files and enabled modifications to be performed online via CICS. Environment: COBOL II, CICS, VSAM, ISAM, FILEAID, MVS/JCL, QBASIC

Greater Detroit Area

• Wayne State University, Detroit, Michigan • Ryder Trucking/LogiCorp, Ann Arbor, Michigan• Oakland Schools, Pontiac, Michigan• Alexander Hamilton Life Insurance, Farmington Hills, Michigan• Visual Services, Inc., Bloomfield Hills, Michigan• Dennis Lane & Associates Collateral Insurance, Warren, Michigan• Vlassic Foods, Farmington, Michigan• Selectcare Health Insurance, Troy, Michigan• Wayne State University, Detroit, Michigan (Student Programmer)• General Motors, Warren, Michigan (Co-op)

Bachelor Of Science, Computer Science

Activities and Societies: Astronomy ClubB.S. in Computer Science

Sharepoint 5-Day Architecture Class

E-Commerce Software Development Program (Esdp)

• Completed Keane’s E-Commerce Software Development Program (ESDP) to polish skills in Java, Oracle, HTML, Web design methodologies.