Business Analyst

Karen E. Perestrejo

Email: ***********@*****.*** -- Kent, WA

Home: 253-***-**** -- Cell: 206-***-****

Business Analyst with 14+ years of experience in: all phases of the Project Life Cycle and System/Software Development Life Cycle; collaborating with subject matter experts (SMEs) and software developers to bridge the gap between user requirements and software functionality; identity management to guard against cyber threats; and creating and analyzing reports to resolve issues and preserve data integrity. Associate of Applied Sciences degree in Computer Science. Technical Training (T) and/or Experience (E):

ASP.NET - T JavaScript - T SQL Server 2008 R2 - T

C#.NET - T MS Office (All Versions) – T/E Visual Basic for Applications – T/E

Database Theory & Design - T MS Project and Visio - E Visual Studio 2010 - T

HTML/XHTML/CSS - T SharePoint – T/E Windows (All Versions) - T Skills:

Adaptability Critical Thinking Knowledge Transfer

Attention to Detail Customer Service Process & Workflow Mapping

Business Analysis Gap Analysis Technical & Process Documentation

Communication Issue Tracking/Resolution Test Case Matrix/Script Development RR Donnelley – Contract through Kelly Services

Business Analyst, August 2015 – April 2016

● Solutions Delivery Group (SDG) – Account Management & Automated Fulfillment o Applied in-depth professional experience and broad knowledge of both business and technology to analyze and develop integrated solutions to resolve moderate to complex technical and business issues

o Supported the Digital Solutions Architecture (DSA) and Healthcare Workflow Solutions (HWS) IT development teams by developing clear and concise technical specifications for development efforts and testing

o Conducted facilitated sessions with internal and external customers to define detailed business and functional requirements for solution development. Established and maintained clear scope boundaries

o Served as a liaison between internal customers and functional IT departments during the initial phases of development. Consistently identified critical data elements and business rules required to develop solutions

o Conducted cross-functional product design reviews at key stages during development to ensure product quality. Reviewed test conditions and expected results for product and user acceptance testing

Accel BI – Contract at King County Metro Transit (KCMT) Business Analyst, February 2015 – June 2015

● Capital Management and Reporting System (CMRS) – Requirements Gathering at KCMT o Supported the requirements gathering phase for an enterprise project and portfolio management system which needed to provide a single, Transit-wide repository of relevant, up-to-date capital project data (scope, schedule and budget/cost).

o Conducted interviews with KCMT staff to capture existing Capital Improvement Program processes and procedures.

o Authored As-Is and To-Be business, functional and technical requirements documents. o Identified dependencies and interactions with other KCMT and King County systems. The Boeing Company – Contract Labor through Chipton-Ross Access Administrator, May 2012 – April 2014

● Supplier Identity Management (SIdM) – Implementation & Transition project at The Boeing Company o As part of the Supplier Portal Access Team, supported two-factor authentication initiative to guard the Boeing Supplier Portal (BSP) against cyber threats. o Assisted suppliers with accessing the BSP through the use of OTP (One Time Password) Hardware Tokens and Exostar’s Managed Access Gateway (MAG). o Utilized issue tracking software for issue (initiate, track, and resolve) and knowledge base (inventory of common issues and resolutions) management.

o Resolved 2nd level tickets submitted by Boeing users and suppliers. o Used Boeing and Exostar reports along with Excel’s VBA to create detailed spreadsheets used to identify and resolve issues with: supplier access, unauthorized users, and access provisioning failures between systems.

o As Vetting Administrator, identified Organization & Application Administrators and approved token activation requests.

o Worked extensively with Boeing’s Supplier Quality ODA (Organization Designation Authorization) staff and supplier Unit Members (UMs) & Designated Airworthiness Representatives (DARs) to ensure UM/DAR portal access & compliance with FAA quarterly reporting requirements. Renton Technical College

AAS in Computer Science, September 2010 – December 2012

● Renton Technical College Registration Database – Project for Database Theory and Design. o Created a college registration database using MS Excel 2007 and a complex Enterprise Relationship Diagram (ERD) using MS Publisher 2007.

o In addition to registration, database allowed the user to add new students, classes, courses and instructors. Utilized tables, forms, macros, sub-forms, commands, queries and reports.

● Renton Technical College Registration Web Application – Project for Developing Rich Internet Client Applications.

o Created an ASP.NET web application using Visual Studio, C#, HTML, JavaScript, and CSS. o Developed SQL Server database and utilized a middle tier containing a connection string and stored procedures to connect to, and interact with the database. The Boeing Company

Business Process Analyst, September 1997 – August 2008

● Enterprise Resource Planning (ERP) Software Implementation and Upgrade – Multiple projects at The Boeing Company – Business Analyst, Team Lead, and Accounts Payable (A/P) Project Coordinator o Supported the development and implementation for three ERP software implementations/upgrades

(BaaN IV, BaaN ERP, and Manugistics).

o Collaborated with subject matter experts (SMEs) and software developers (internal and vendor IT) to bridge the gap between user requirements and software functionality by supporting all phases of software development including: requirements gathering, analysis, & definition; data mapping; data migration/conversion; integration; documentation; testing; and implementation. o As A/P Project Coordinator, acted as liaison between process/implementation team and executive management by developing and presenting status charts, risk analysis, and issue logs. o Lead cross-functional Business Partner assessment team building consensus for software functionality changes and participated as A/P focal on other cross-functional teams. o Developed methods and processes to support software functionality changes. o Authored documentation used in change management and configuration management processes. o Developed test plan approach, detailed test plans, and performed software testing (unit, integration, regression, and acceptance) to validate; functionality of COTS and heavily customized vendor software meets user requirements, and data migration accuracy. o Participated in Value Stream Mapping to: document As-Is and To-Be enterprise level process flows, create A/P Visio swim lane charts, perform gap analysis, and create Work Breakdown Structure. o Lead the A/P development/implementation team and end users through multiple test cycles and implementation cutover activities.

o Facilitated Finance test cycle meetings to track identification, review, prioritization, assignment, and resolution of errors/defects encountered during test cycles. o Mentored and assisted other analysts in using project tools and creating deliverables. o Developed & delivered knowledge transfer & end user training materials to site experts. Employment History:

● Business Analyst, 8/2015 – 4/2016

Kelly Services, Seattle, WA - Contractor at R.R. Donnelley

● Business Analyst, 2/2015 – 6/2015

Accel BI, Seattle, WA - Contractor at King County Metro Transit

● Access Administrator, 5/2012 – 4/2014

The Boeing Company, Renton & Bellevue, WA – Contract Labor through Chipton-Ross

● Business Process Analyst, 9/1997 – 8/2008, Supplier Code Administrator, 6/1996 – 12/1998 The Boeing Company, Renton, WA

Education:

● Renton Technical College, 9/2010 – 12/2012 GPA 3.89 Renton, WA

o Associate of Applied Sciences in Computer Science -- Graduated: 12/12 with Honors o Applications Developer -- 1 year certificate program -- Graduated: 8/11 with Honors o Computer Science Certificate – 1 year certificate program -- Graduated: 12/12 with Honors o Awarded honors and placed on the Vice President’s Honors List each quarter

Contact this candidate