PROFESSIONAL SUMMARY:

• Senior/Lead Level Business Analyst with over 15 years experience in eliciting, documenting, and managing functional and non - functional requirements for Enterprise-wide Software, web-enabled, and EDW projects using Agile/Scrum, Waterfall, and RUP methodologies. Proficient in deliverables of analysis phase of SDLC; Business Requirements Document, Functional Requirements Document, Use Cases (Waterfall) and User Stories (Agile). Extensive experience with data mapping, data integration, data migration, and data conversion. Strong QA background and experience. Familiar with MDM methodology.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Working with Product Owner and SME, gather and document User Stories
• Create process flows and data diagrams

Tools: used: Jira, Visio, MS Office, SharePoint

Confidential

Senior Business Analyst

Responsibilities:

• Create Process flows from requirements
• Perform data mapping in preparation for data integration, escalating data quality/integrity issues to management
• Perform System and Integration test of application and cube
• Create Cognos reports
• Create ‘How To’ documents; how to use application, how to navigate specific user scenarios
• Learn new tool to facilitate resolution of vendor-related data issues
• SQL used to confirm results

Tools: used: Microsoft Office, SharePoint (used to export data from Excel files to DW), SQL Management Studio (SSMS), COGNOS, Pivot Tables, Visio, Outlook

Confidential

IT Business Analyst

Responsibilities:

• Gathers requirements from Product Owners; creates business requirements documentation for Functional and Non-Functional requirements.
• As member of Infrastructure team, manage and tracks Confidential &E field work orders
• Senior Analyst on multiple project teams

Tools: used: Jira, Remedy, Sharepoint, Microsoft Office, Visio

Confidential

Questionnaire Configuration Coordinator (Contract)

Responsibilities:

• Working with SME's, gathered the design, security, and configuration requirements for development of proprietary software specializing in immigration questionnaires and related data
• Conduct integration, functional, regression, and system testing as driven by requirements
• Create/Evaluate/Manage problem report tickets in conjunction with configuration requirements and provide post-implementation /application support

Tools: used: Visio, Excel, Word, Lotus Notes, SharePoint, proprietary defect tracking tool

Confidential

Master Data Management Business Systems Analyst (Contract)

Responsibilities:

• Upon completion of, created documentation for end users in preparation for deployment of proprietary software for Master Data Management
• Collaborated with programmers on analysis, usability and functional requirements, security, and design of new software application
• Create test scripts and conducted functional, regression, integration, and system test of software customization, ensuring requirements successfully implemented before rollout
• Manage project documentation in LiveLink ( CMS)
• Map technology assets from source to software in preparation for data migration

Tools: used: Collibra, Visio, MS Office, Lync, LiveLink, (Paint and Snagit used for mockups)

Confidential - San Francisco/San Ramon, CA

Contract Senior Business Analyst

Responsibilities:

• Partner with business users to elicit, document, and manage requirements for SAP integration project which enabled customers to make online account payments.
• Create deliverables including 'as is' process flows, Requirements Traceability Matrix, and (BRD) Business Requirements Document for web -based application.

Tools: used: Visio, Excel, Word, Outlook, SharePoint (CMS)

Confidential - San Ramon, CA

Data Analyst (Contract)

Responsibilities:

• Partner with business users to document requirements and create (BRD) Business Requirements Documents
• Using SQL queries and physical/logical models, created source-to-target mappings of Deposit, Loan, and Security products, identifying data integrity issues an escalating as necessary
• Identify the requirements specifically for the European Liquidity Coverage Ratio (EULCR) and United States Liquidity Coverage Ratio (USLCR)

Tools: used: Excel, Word, Outlook, SQL Management Studio (SSMS), PL/SQL Developer, Toad Data

Confidential - Napa, CA

Business System Analyst/Project Lead (Contract)

Responsibilities:

• Partner with business users to elicit business requirements and create (FRD) Functional Requirements Document, (BRD) Business Requirements Document and Requirements Traceability Matrix
• Mentored Junior BSA
• Worked with stakeholders to create 'as is' and 'to be' process flows
• Create deliverables including Test Plan, Test Cases / Scripts and Test Findings for CRM, Online Payment Center, Policy Management, U/W, and Billing
• Lead multiple projects to business sign-off and prioritization of requirements
• Managed project defects and provide application support
• Lead UAT
• Performed system, integration, regression testing of proprietary software post data migration and provide post-implementation support

Tools: used: Visio, Excel, Word, Outlook, VIsio, (Paint and Snagit used for mockups)

Confidential - San Ramon, CA

Data Analyst

Responsibilities:

• Document business requirements and created (BRD) Business Requirements document, (FRD) Functional Requirements and Technical Specifications document for CRM and Data Warehouse projects
• Using SQL Management Studio and Toad, used SQL queries to ensure all required tables and data elements were accurately depicted in newly created tables for data migration project
• Identified field-level data quality issues between source and target tables and escalated to architect
• Collaborated with programmers, architect, and end-users to ensure functional business requirements met for numerous projects
• Compare physical/logical models between multiple versions of EDW for purpose of data migration activities; used SQL queries for benchmarks, and created 'before and after' data snapshots of migrated data using SQL queries
• Perform data mapping of source-to-target tables/fields for development of new data warehouse
• Perform data profiling using data models and SQL queries
• Perform system, integration, and regression testing on EDW and CRM application and UAT on CRM
• Create QA project deliverables including; Test Plan, Test Cases, and Test Scripts
• As an advocate for maintaining data integrity, escalated data issues regarding data quality so that data followed governance rules and remained consistent.

Tools: used: SQL Management Studio (SSMS), PL/SQL Developer, Toad Data Point, Excel, Word

Confidential - San Rafael, CA

Business System Analyst

Responsibilities:

• Translate high levelbusinessrequirements from Finance Product Owner into functional specifications documentation for the IT organization, and created Agile user stories and tasks for software development projects
• Participate in Agile sprints and project sizings, grooming, and manage changes to user stories, acceptance criteria, specifications and defects
• Coordinate project delivery tasks with internal IT groups (development, infrastructure) through all stages of Systems Development Life Cycle.
• Collaborated with programmers to deliver finished product

Tools: used: Rally, Excel, Word, Outlook

Confidential - San Francisco, CA

Business Analyst

Responsibilities:

• Sole IT BSA on pricing engine component of enterprise development initiative; delivery of new policy processing software for Workers Compensation insurance.
• Following Agile/Scrum methodology (daily stand-up, project sizing, grooming, creation of user stories and acceptance criteria), collaborated with actuary, programmers, dba, architect and business partners to iteratively deliver required functionality.
• Dissected State-specific algorithms into business requirements
• Created rule-based matrix for ease of tracking and managing algorithms

Tools: used: SQL Management Studio (SSMS), Rally, Excel, Word, Outlook

Confidential - Fairfield, CA

Business Analyst (Contract)

Responsibilities:

• Sole BSA- Provided client support in deployment of Salesforce
• Requirements gathering/documentation for Salesforce development project
• Collaborated with programmer and created Technical Specifications document, wireframes, storyboards, and documentation
• Create and execute test cases and scripts; performing regression and system testing
• Create Data Dictionary
• Managed defects

Tools: used: SFDC, Bugzilla, Excel, Word, Visio, SFDC

Confidential - Napa, CA

QA Analyst

Responsibilities:

• Used SQL queries to pull monthly Sales figures and compare results to BO Reports
• Coordinate test efforts with programmers for end-to-end, system, regression and integration testing of web-enabled applications and reports using Business Objects.
• Audit daily data warehouse load metrics using SQL queries; identify discrepancies, trace to source, report findings to developer and/or stakeholder group, and monitor until issue(s) resolved.
• Worked with stakeholders to create 'as is' and 'to be' process flows, identifying gaps

Tools: used: SQL Management Studio (SSMS), Business Objects, Visio, Excel, Word, Confidential

Confidential - San Francisco, CA

Business System /Data Consultant

Responsibilities:

• Using SQL queries, performed gap analysis and data mapping between Oracle and Teradata in preparation for data warehouse migration/integration of Bill Pay application
• Working with stakeholders and business end users, created (BRD) Business Requirements Document
• Create Test Plan for System Integration Testing

Tools: used: SQL Navigator, Teradata SQL Assistant, Business Objects, Word

Confidential - Sacramento, CA

Business System Analyst (Contract)

Responsibilities:

• Sole BSA for a flagship project designed to web-enable all of the tax forms, as a part of a 15 member team of web developers, project manager and data analyst.
• Elicit and document business and system requirements from stakeholders and programmers via JAD sessions, obtaining sign-off from stakeholders on finalized requirements.
• Capture compliance- driven State rules and regulations for vehicle State Use Tax
• Create test documentation to ensure system calculations were accurately applied
• Create (BRD) Business Requirements Document, (FRD) Functional Requirements, and Technical Specification documentation
• Create high-level storyboard with Visio diagrams to demonstrate 'to be' business process flows for stakeholders
• Utilize UML to create use cases for core functions.
• Provide in the usage and construction of use cases.
• Track requirements and update BRD’s throughout the entire project.
• Using Requirements Traceability Matrix, identified gaps and escalated to Project Manager.
• Create Test Plans, coordinate test efforts with 5 testers for end-to-end, regression, integration, system and UAT testing.
• Mentor less experienced analysts in documentation of requirements.
• Work with users and programmers in the definition, placement and design of headers, labels, fields, and navigational elements on web-enabled taxpayer forms.
• Maintain and manage project artifacts in SharePoint.

Tools: used: SharePoint, proprietary requirements documentation tool, Word, Visio, Excel (Paint and Snagit used for mockups)

Confidential - Napa, CA

Consultant Analyst

Responsibilities:

• Created 'as is' and 'to be' process flows and documentation for stakeholders and IT structured testing activities using SQL queries to deliver all test scripts and expected results. Results compared between SQL and Business Objects reports
• Perform system/regression/integration testing, create UAT documentation and manage UAT testing
• Work with SME's to gather requirements and create (BRD) Business Requirements document
• Setup of projects and associated output(s) in Mercury QC Center

Tools: used: Visio, Word, Excel, HP Quality Center, Outlook, SQL Management Studio, Business Objects

Confidential - Sacramento, CA

Consultant Data Analyst (Consultant)

Responsibilities:

• Create 'as is' process flows for multiple data marts via translating SQL queries into VISIO diagrams
• Review and update in-place application documentation for and knowledge transfer sessions

Tools: used: Visio, Word, Excel, Outlook

Confidential - Bellevue, WA

Business Analyst/ Data Analyst/ QA Lead

Responsibilities:

• Led Horizontal and Vertical interview sessions with stakeholders and business users in sales and marketing to elicit data warehouse functional requirements related to new eMarketing strategy.
• Defined functional and technical requirements and data mappings to support ETL and Business Processes related to LZ (Repository) for transformation of data from source to target, staging area to apply business rules/ business logic to data and validation/ loading of data into the data warehouse from presentation to the business through Business Objects. Collaborated with programmers to deliver data warehouse.
• Manually created and managed 1,000’s of requirements and a complete requirements matrix.
• Worked as a liaison from IT to the business stakeholders to ensure that all critical paths were followed, tracked and managed changes to requirements, supported Data Warehouse PM in efforts to maintain all associated requirements.
• Created Test Strategy, Test Plan, Test Cases and Test Scripts; assigning each team member test responsibilities while monitoring and reporting on team's progress throughout project.
• Performed extensive testing of new EDW tables/fields using SQL queries; compared data snapshot results to Business Objects reports
• Provided in QA methodology as required; document bugs and monitor disposition, attend and participate daily triage meetings, review programmer's scope documents and test plans, commenting as required and serve as liaison between test team and development.
• Participated in Proof of Concept testing for DBMS and IQ software, contributed to SOW, developed benchmark metrics, Test Plan(s), Test Findings and created RUP process documentation for Business Analyst team.
• Led Test Team in successful delivery of a new Oracle and DB2 Data Warehouse, met project deadline and delivered quality data warehouse on time affording Expedia to meet their Company goal by delivering warehouse to user community on time.
• Update source-to-target mappings for data migration activities from source application to EDW
• Validate physical/logical models and mapping documentation

Tools: used: TOAD, Perforce, Jira, SharePoint (CMS), Tracker, DbDiff, Confidential Compare2, InformaticaPutty, Business Objects, IBM DB2, (Paint and Snagit used for mockups)

Confidential - Anaheim, CA

Consultant Analyst & QA Manager

Responsibilities:

• QA Manager; lead team in the testing of various components of the data warehouse, developed test and build plans for project(s) and supervised team’s test activities
• Contributed to SOW
• Analyst; leading JAD like sessions with stakeholders and business users for the purpose of defining facts and dimensions for data mart
• Performed extensive testing using SQL queries and compared data snapshot results to Business Objects reports

Tools: used: PL/SQL Developer, PVCS, Bug Tracker, SharePoint (CMS), DbDiff, Confidential Compare2, InformaticaBusiness Objects, SSMS

Confidential - San Rafael, CA

Consultant Project Lead / RUP Mentor

Responsibilities:

• Gathered and documented requirements for end-to-end policy processing software application using OO analysis methodologies and RUP
• Documented user requirements, developed use cases and created technical/functional (FRD) documents
• Responsible for project set-up and requirements management using Rational’s Requisite Pro
• Instrumental in and mentoring other analysts in the requirements gathering process and its critical role in the SDLC
• Mentored analysts in the use of ReqPro
• Through application of data quality process, identified major data migration issues that left unchecked, posed a potential and substantial loss to GPM in fines, penalties and employee productivity
• Participated in Lessons Learned sessions
• Contributor to user guide including tool tips
• Provide application support

Tools: and applications used: ReqPro, Word, Empower Gallagher, Excel

Confidential - San Bruno, CA

Consultant (Contract)

Responsibilities:

• Instrumental in design and development of department’s new intranet web site.
• Acted as liaison between user community and programmers in development, testing and deployment of web application for coast-to-coast use

Tools: and applications used: Lotus Domino, Word, Excel

Confidential - San Francisco, CA

Consultant / Project Lead (Contract)

Responsibilities:

• Collaborated with users and programmers to gather requirements for supply chain software application
• Developed test cases, assisted and participated in system, integration and regression testing of targeted enhancements
• Developed requirements and (FRD) Functional Design documentation

Tools: and applications used: Proprietary merchandise tracking system, Word, Excel

Confidential - Novato, CA

Lead Business System Analyst/ QA / Lotus Notes Developer

Responsibilities:

• Performed as data steward, ensuring governance rules were followed as part of QA role
• Extensive data mapping of data from mainframe to Lotus Notes; data conversion projects
• Created numerous BRD's, FRD's, and Technical Specs for software applications for Worker's Compensation, Commercial, and E&SR LOB's and products.
• Perform due-diligence on insurance product rates to ensure compliance with State-specific Insurance regulations and rules
• Trained in and functioned as QA Project Lead
• Participated in Lessons Learned sessions
• Created user documents including User Guide, tool tips and Helpful Hints
• Conducted application sessions
• Scripted and filmed video for nationwide rollout of new application
• Created, designed, and managed numerous software applications using Lotus Notes
• Provided Production /Application support

Tools: used: Rational Rose, Lotus Notes, Word, Excel, Doors, Access, Paradox, QA Center