SUMMARY:

Accomplished Information Technology Professional with 20+ years industry experience and verifiable track record of delivering leading - edge and cost-saving solutions for companies in diverse industries. Roles and responsibilities have included: Requirements Gathering, Testing and Test Case validation/verification, Project Management, Teaching, Data Analytics, Testing and Development, JAD Session Coordination. Proficient in numerous SDLC methodologies (Agile and Waterfall) and have substantial skills in software/applications, data bases and programming tools. Industry experience includes: Banking, finance, manufacturing, insurance, corporate data security, offender management education, marketing, logistics, and transportation.

TECHNICAL SKILLS:

Project Methodologies: Agile/SCRUM Joint Application Design (JAD) Waterfall, Requirements Gathering System Development Life Cycle (SDLC) Rapid Application Development (RAD), Six Sigma Certified Business Process Analysis Confidential Productivity Management, User Stories Wire-Frames Multi-Tier Client/Server Methodology

Skills: Toad, JAVA, HTML, MS Word, SQL Navigator, Team Foundation Server FOCUS, WebFocus, MS Project, SQL Plus, SQL Server, Oracle, Optimal Trace, MS Access, ISPF, Active Directory, DB2, XML, MS Excel, AS/400, Jira, SQL, JCL, MS Visio, COBOL, UNIX, TSO, VM/CMS, EDI, FileAid

PROFESSIONAL EXPERIENCE:

Confidential, Troy, MI

Business Analyst

Responsibilities:

• 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 Confidential 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

Confidential, Troy, MI

Business Analyst

Responsibilities:

• Wrote Business Requirements Documents (BRD) for several web-based applications allowing Confidential Fleet and Confidential Tire dealers to claim incentive money for fleet sales
• Created an application landscape diagram (Visio) for all web pages, batch jobs and file transfers that read or wrote the SQL Server Database.
• Documented business processes and requirements for a Confidential vehicle model year shutdown process. Several teams needed this document for coordination of tasks to be performed in proper sequence to remove these particular vehicles from user-selection in the claims process

Confidential, Lansing, MI

Business Analyst

Responsibilities:

• 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. Analyzed REST/SOAP Web Service code for efficiencies.
• 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: 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

Confidential, Troy, Michigan

Business Analyst

Responsibilities:

• 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 (Oracle EBS & JDE). 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: SQL Server 2008, Oracle 11g, Oracle EBS, 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

Confidential, Auburn Hills, Michigan

Business Analyst

Responsibilities:

• 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 Confidential 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

Confidential, Farmington Hills, Michigan

Business Analyst

Responsibilities:

• 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

Confidential, Auburn Hills, Michigan

Business Analyst

Responsibilities:

• 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 software

Environment: MS-Acess, HTML, MS Office Tools, OptimalTrace, Harvest/BladeLogic

Confidential, Dearborn, Michigan

Business Analyst & Project Management

Responsibilities:

• 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 reviews

Environment: UML, Oracle, SQL, PL/SQL, Oracle Designer, DevPartner, iGraphix, Oracle Forms 10i, UNIX Shell scripts, SQL*Plus, Vi editor, TOAD, EditPlus 2, MS Project

Confidential, Southfield, Michigan

PRINCIPAL CONSULTANT

Responsibilities:

• 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

Business Analyst & Lead Tester

Confidential, Michigan

Responsibilities:

• 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

Student

Confidential, Boston, Massachusetts

Responsibilities:

• Completed Confidential ’s E-Commerce Software Development Program (ESDP) to polish skills in Java, Oracle, HTML, Web design methodologies, and JavaScript.
• Furthered expertise in Active Server Pages (ASP), Extensible Mark-up Language (XML), Common Gateway Interface (CGI/Perl), VBScript, and Cascading Style Sheets (CSS).
• Selected as Project Manager of a 5-member team to create and present a web-enabled solution as part of final class project.

Environment: Java, Oracle, HTML, XML, VBScript, CGI/Perl, ASP, CSS

Project Manager/Business Analyst/Lead Tester

Confidential, Troy, Michigan

Responsibilities:

• 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