SUMMARY

• 15 years of experience in Business Analysis with Use Cases, RUP, and UML, Agile methodology, Visio, wireframes, SharePoint, MS Suite ( Confidential, Excel, PowerPoint) Managed 4 B2C (public facing website) projects through the full SDLC including ongoing maintenance and support
• Experience managing multiple projects simultaneously including scope, WBS, scheduling resources and budgeting
• 5 years’ experience with MS project
• Excellent organizational and communication skills with attention to detail
• Full Lifecycle experience from project initiation through implementation with minimal supervision

TECHNICAL SKILLS

• DB2
• SQL
• MS SQL Server
• Oracle
• Stellent
• IPM
• Business Objects
• Informatica (ETL)
• CDO
• Microsoft Suite
• Project
• Access
• Excel
• PowerPoint
• Visio PowerBuilder 6.0
• WindowsNT
• Bachman CASE toolset
• SEER/HPS CASE toolset
• Entity Relationship Data Modeling
• ERWin
• UML
• Use Case
• Visio
• RUP
• RequisitePro
• Crystal Reports
• Test Director
• PVCS
• VSS Yourdon Structured Analysis and Design

PROFESSIONAL EXPERIENCE

Confidential, Santa, CA

Business Analyst (Consultant)

Responsibilities:

• Responsible for creating business requirements documents for the healthcare portal home page and healthcare broker access and registration, creating use cases, making business and system recommendations in consultation with major business users related to redesign of an enterprise wide healthcare portal
• Responsible for the creation of the requirement traceability matrix in conjunction with the QA team
• Create database/file design in MS SQL or MySQL or other relational database, write SQL queries
• Participated in joint application design sessions with project team members
• Ability to meet timelines and deliver quality documentation under very tight schedules\deadlines
• Work directly with all functional teams (Development, Architect, Database, Quality Assurance, Service Delivery, Project Management, etc.)

Confidential, Richmond, VA

Business Systems Analyst (Consultant)

Responsibilities:

• Responsible for providing business requirements analysis, systems analysis, creating use cases, recommendations and consultation and/or advice related to system design of the enterprise wide document management system integrating document files from multiple systems using web services, XML, and SOAP
• Completes the High Level Design Document (HLD) based on business requirements
• Responsible for the validation of the traceability matrix throughout the life of the project
• Perform data validation, data integration and Backend / DB testing using SQL queries manually
• Responsible for SharePoint 2013 BRD, mapping document, QA document management and workflow management
• Identities and evaluates impact of changes to systems
• Influences and advises project team on project scope and system impact
• Responsible for the review and feedback for Low Level Design Documents (LLD), test plans, test scripts and test results
• Participate in joint application design sessions with project team members
• Ability to meet timelines and deliver quality documentation under very tight schedules and deadlines
• Assist the project team with providing high level estimates for projects and the ability to deliver based on forecast
• Work directly with all functional teams (Development, Architect, Database, Quality Assurance, Service Delivery, Project Management, etc.)

Confidential, Irvine, CA

Business Systems Analyst (Consultant)

Responsibilities:

• Responsible for business analysis for custom configuration and implementation of loan origination system for retail and wholesale channels utilizing use case analysis and Agile methodology, SharePoint and Visio to track and visualize requirements.
• Performed gap analysis to ensure that functional, non­functional and data requirements are met for new loan origination system
• Created functional and technical workflow documentation of new loan origination system utilizing UML diagrams with Visio toolset

Confidential, CA

Business Systems Analyst (Consultant)

Responsibilities:

• Responsible for business analysis for maintenance of Account Order Entry system utilizing SharePoint and Visio, that supports equity and bond assets using web services as a front end with Oracle database as the backend.
• Performed data mining and data analysis using advanced SQL queries and Excel Pivot Tables to ensure data integrity and consistency from multiple data sources
• Wrote Requirement Specifications and Functional Specifications documentation to enhancement of Account Order Entry System utilizing SharePoint to add annuities to functionality as well as test cases for unit testing

Confidential, CA

Sr. Business Systems Analyst (Consultant)

Responsibilities:

• Responsible for business analysis for maintenance of Asset Setup and Maintenance (Security Master) system that supports equity and bond assets as well as portfolio management for a major securities firm using PowerBuilder as a front end with Oracle database as the backend.
• Modeled Securities Database and integrated feeds from other financial (A/R, A/P, G/L) databases from MS SQL Server, DB2, and MS Access
• Performed data mining and data analysis using advanced SQL queries and Excel Pivot Tables to ensure data integrity and consistency from multiple data sources

Confidential, CA

Sr. Business Analyst (Consultant)

Responsibilities:

• Maintained and managed Ecommerce web based customer facing website with J2EE architecture with JAVA and XML tied to Oracle Database and constructed APIs and complex SQL.
• Conduct user interviews, use cases, analyzed and updated existing documentation utilizing SharePoint and Visio
• Responsible for creating Project Plans from project initiation thru implementation using Microsoft Project and performed Cost/Benefit Analysis for CRM Data warehouse using Oracle Database and Business Objects front end to analyze and create new customer opportunities for commercial and private bank divisions
• Analyzed current process and data flow and created UML documentation Performed data analysis of multiple outside sources and created performance reports using in - depth calculations to ensure integrity of data

Confidential, CA

Business Systems Analyst (Consultant)

Responsibilities:

• Responsible for business and data analysis of mortgage tools and mortgage comparisons such as Total Cost Analysis, Debt Consolidation and Prequalification for new web based Loan Origination System
• Wrote functional requirements to connect to customer base (B2C) for loan servicing and rate analysis utilizing Agile Methodology
• Wrote functional and technical requirements documentation for mortgage proposal scenarios using SharePoint, Visio, and wireframes of Total Cost Analysis (equity growth and term reduction) and Debt Consolidation (term reduction and savings reinvestment) utilizing UML for .NET framework with VB and ColdFusion
• Provided supervisory role for 3 junior analysts using my experience to guide and assist their job responsibilities

Confidential, Irvine, CA

Business Systems Analyst (Consultant)

Responsibilities:

• Responsible for business analysis to de­commission previous reporting system to provide reports closely aligned to business needs
• Conducted JAD sessions and performed business analysis of web based customer facing Empower LOS data reporting system (using SQL Server database and Crystal Reports) to align the following reports more closely to business needs
• Responsible for Funding reports (units by AE, region, and company, volume, rate, LTV), Stratification reports (fixed versus ARM loans, full doc, limited, stated) and Raw data report (loan level data)
• Performed analysis of SQL stored procedures and wrote functional and technical specifications with JAVA and XML to re­engineer the above reports to ensure data consistency and proper technical standards (for example funded loans were defined differently across reports).

Confidential, Irvine, CA

Business Analyst (Consultant)

Responsibilities:

• Responsible for analysis to de­commission and to replace legacy system to process loans Worked with subject matter experts to document business use cases for setup, underwriting and closing agent functions of new web based loan origination system (vendor Palisades) to replace legacy loan origination system.
• Ensured that LOS provided compliance with federal and state laws, HMDA and RESPA Worked with vendor to document interface use case for credit reporting function of new windows based loan origination system.

Confidential, Irvine, CA

Business Analyst (Consultant)

Responsibilities:

• Wrote functional specifications (presentation layer, business rules, and data requirements with JAVA and XML to integrate web based loan origination system (Empower) with AVM vendor to automatically generate AVM reports from vendor system without re­entering loan data
• Wrote use cases, requirement specifications and test plans (unit, system, user acceptance) to add rescission entry, reporting and tracking to loan origination system (Empower), used RUP methodology and UML with Oracle Data warehouse

Confidential, Oakland, CA

Project Manager

Responsibilities:

• Wrote project charter, developed project plan, budget, work breakdown structure and project schedule for full lifecycle effort using Microsoft Project to convert paper based notification system to fully system based storage and retrieval system to notify customers of tax payment schedules, project completed on time and on budget, used RUP methodology
• Served as PM with line and budget responsibilities for 15 persons and business analyst to upgrade Payroll system and introduced full lifecycle development methodology for the project which used VB and ColdFusion and MS SQL Server database

Confidential, San Francisco, CA

Systems Architect

Responsibilities:

• Performed DBA duties, wrote complex SQL statements to ensure data interfaces were integrated and tuned SQL to ensure proper functionality.
• Designed and implemented three tier architecture for redesign of Legacy Billing system using Java GUI and DB2 database.