PROFESSIONAL SUMMARY:

• Senior/Lead Level IT Analyst experienced with enterprise - wide software, SaaS, and EDW development projects leading numerous teams to successful deployment applied in multiple industries; Insurance, Mortgage. Banking, Travel, Airline, Retail, State Government, and Pharmaceutical . Experienced in Waterfall, Agile/Scrum, and RUP SDLC methodologies.
• Lead projects from inception to deployment collaborating with programmers and team to interview SME's and other principal's to elicit, document and manage requirements in keeping with Best Practices
• Created and managed use cases, wire frames, storyboards, test strategy, test plan, test cases and test findings with a thorough knowledge of Waterfall, RUP, Agile/Scrum. Also delivered process flow diagrams and requirements traceability documentation.
• Managed project artifacts in Sharepoint and LiveLink
• Managed UAT; developed training documents
• Created project deliverables including BRD, FRD, Test Strategy, Test Plan, Test Cases / Scripts and Test Findings leading teams throughout testing process
• As an intermediate SQL user, performed data analysis and testing, and created source to target mappings
• Experienced in Waterfall, Agile/Scrum, and RUP methodologies

PROFESSIONAL EXPERIENCE:

Confidential

Questionnaire Configuration Coordinator

• Working with SME's, gathered the design, security, and configuration requirements for development of proprietary software specializing in immigration questionnaires and related data
• Review/generate configuration requirements through each implementation phase
• 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 support

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

Confidential

Master Data Management Business Systems Analyst

• Upon completion of training, create training documentation for end users in preparation for deployment of proprietary software for Master Data Management
• Collaborated with programmers on analysis, requirements, security, and design of new software application
• Create test scripts and conduct functional, regression, integration, and system test of software customization, ensuring requirements successfully implemented before rollout
• Manage project documentation in LiveLink ( CMS)
• Research of Company documentation and identify artifacts relevant to Master Data Management
• Research source systems for Master Data Management data elements (field-level)
• 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

Senior Business Analyst

• 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

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

• Partner with business users to elicit business requirements and create (FRD) Functional Requirements Document and (BRD) Business Requirements Document
• 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 development
• Managed project defects and project deliverables
• Lead UAT
• Perform 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

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

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

Confidential, San Rafael, CA

Business System Analyst

• Translate high level business requirements into functional specifications documentation for the IT organization, and create Agile user stories and tasks for software development projects
• Work with Finance Product Owner to elicit requirements
• Participate in Agile 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

• 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 software functionality.
• Dissected State algorithms into system requirements
• Used SQL queries to test data output to ensure algorithms were in compliance with specific State rules and regulations

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

Confidential, Fairfield, CA

Business Analyst

• 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 and storyboards, and training documentation
• Create and execute test cases and scripts
• Create Data Dictionary
• Managed defects

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

Confidential, Sacramento, CA

Business System Analyst

• 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 training in the usage and construction of use cases.
• Track requirements and update BRD’s throughout the entire project.
• Identify project gaps in the requirements and escalate 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, Bellevue, WA

Business Analyst/ Data Analyst/ QA Lead (Contract) Data Warehouse Project

• 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 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 training 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, BeyondCompare2, Informatica,Putty, Business Objects, IBM DB2, (Paint and Snagit used for mockups)

Confidential, Anaheim, CA

Consultant Analyst & QA Manager

• 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, BeyondCompare2, Informatica,Business Objects, SSMS

Confidential, San Rafael, CA

Consultant Project Lead / RUP Mentor

• 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 training and mentoring other analysts in the requirements gathering process and its critical role in the SDLC
• Mentored analysts in the use of ReqPro
• 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

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