PROFESSIONAL SUMMARY:

• 10+ years of Business Analyst (BA) experience, backed up by extensive project management (PM) and software development experience, including:
• Business requirements gathering, document creation (BRD), functional & technical specs, use cases, user stories, UML, Business Process Management (BPM), workflow analysis / optimization.
• UAT test script creation, test mgmt., implementation mgmt., user training & user guide docs.
• Business Intelligence (BI), data analysis, data warehouse (fact/dimension tables, DWH), data modeling, data flow, ETL.
• Web portal/site development, UI/customer experience, content development, testing.
• Project initiation & estimation. Requirements definition, project resources planning, reporting, tracking, metrics, use of milestones, review gates.
• Issue resolution / tracking / escalation / prioritization, chair meetings, meeting minutes.
• Risk management & mitigation, issues management, change control / management processes.
• Scope definition, software development / work plans, WBS, project schedule, budget/financial analysis, statement of work, stakeholder interface,
• Project status reporting, user / customer communication, manage expectations.
• Implementation, deployment, stress & performance testing, test management.
• Recent contracts by industry:
• Banking - WFB, Confidential, Schwab, Visa - 5 years
• Biotech / Healthcare - BioMarin, Kaiser, Bayer Pharmaceutical, Abbott Diabetes, Confidential - 4 years
• Experienced with hands on management with Microsoft Project, Visio, Excel.
• Experience with full System Development Life Cycle (SDLC) in multi-project / task environment.
• Certified Project Management Professional (PMP).
• Experience with Waterfall, Agile, PMBOK, PMM & RUP methodologies.
• Experience with software test, QA & Validation procedures required by FDA 21 Part 820 regulations covering software and documentation, FDA 21 Part 11 regs covering data storage.

TECHNICAL SKILLS:

HARDWARE: Mainframe, network, server, client-server, web environments.

DATABASE: Oracle, PL/SQL, SQL, Oracle forms/Developer 2000, Oracle Data Warehouse, and DBA functions Oracle table mods /rebuilds /reloads/ETL/stored procedures, triggers/data modeling/ER & DF diagrams, Redbrick, SQL Loader. SQL Server, ERWIN, DB2, Informix, IMS, IMAGE. Informatica PowerCenter, PowerAnalyzer. MySQL.

WEB: Software development HTML, C, CGI scripts, CSS, XML, IIS, ADO, ASP, JSP, Java, JavaScript, PHP.

OPERATING SYSTEMS: HP-UX, AIX, Sun Solaris, Windows 7 / 8, Linux.

PROGRAMMING: C, JavaScript, Java, VBScript, PERL, PHP, Unix shell scripting, HTML, CGI, JSP.

DOCUMENTATION and CHANGE CONTROL TOOLS: Agile, TrueChange, ClearCase, SourceSafe.

APPLICATIONS: Customer Relationship Mgmt (CRM) - Supply Chain/ Demand Chain, Data Warehouse/BI, Web Portal systems, Integrated Web/Database Systems. Call Center systems, Banking, LIMS/LES IM systems.

SKILLS: Business / Systems Analysis, Project Management, full SDLC software development.

BUSINESS ANALYSTS, PROJECT MANAGEMENT TOOLS: Visio, PowerPoint, MSFT Project, Excel, Word, Access, SharePoint, LiveLink, Clarity/Open Workbench.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Database COE/DBCC Governance Program effort
• Workflow process development and documentation:
• Process areas: governance, support, risk mgmt., standards, operations.
• Workflows developed through SME interviews and reviews.
• Workflows documented in descriptive Word documents and Visio or Tibco graphic representations.
• SharePoint site development for EDM Group process documentation.

Environment: Microsoft Office suite. Visio, TIBCO

Confidential, South San Francisco, CA

Business Analysis

Responsibilities:

• Develop requirements to replace existing system: Managed Care Contracts Letter of Agreement system.
• Existing system issues:
• Uses Access-base, not scalable.
• Uses antiquated input and output methods- Excel spreadsheets.
• Errors in code and DB schema create errors in process.
• Critical for medical treatments, patient care.
• Requirements were developed through stakeholder interviews and reviews, Access data base schema analysis and code analysis.

Environment: Microsoft Office suite. Visio. Access data base.

Confidential, San Francisco, CA

Business Analysis / Product Owner using Agile Methodology

Responsibilities:

• Software enhancements to the WICE system as Product Owner for self-managing teams-
• Conversion to Active Directory/ LDAP/Single Sign-on configuration for the WICE application.
• WICE Request Light application.
• WICE enhancements.
• WICE Plot, Time & Holiday Schedule and TMSC-IC alignments apps.
• PO (Business Analyst) for Agile developer team implementing changes to comments and workflow dashboard displays.
• PO for installing WICE portal upgrades for SIT, UAT, Pre-Prod and Production environments.
• User guide and documentation development-
• Brazos Portal Admin application.
• Pilot Admin app.
• TMSC-IC Alignment Admin app.
• Time and Holiday Admin app.
• Other activities-
• Business Process Management & Improvement.
• Develop/document scope, detailed business requirements, business rules, use cases.
• Guide developer and QA interpretation of business requirements for dev and test.
• Workflow analysis, improvement and enhancement.
• Requirements gathering.
• Applications
• WICE - Wholesale Integrated Customer Experience.
• AES - Automated Enrollment Solutions.
• WICE and AES are Confidential internal applications used to enroll Confidential customers as users of Confidential products such as Basic Banking, Wire Transfers, etc.
• Tools-
• Rally Agile Management.
• ALM (Application Lifecycle Management).
• IBM BPM (IBM Business Process Management application).

Environment: Agile project management/software development methodologies. Microsoft Office suite. Visio. DCM doc repository.

Confidential, San Rafael, CA

Business Analysis / Data Analysis

Responsibilities:

• Work with clinical study teams to develop BI metrics (SQMs, KPIs) from clinical ops study data. Study data is accumulated in a Rave Medidata EDC system and passed to a Comprehend cloud GUI presentation system for graphic metrics and dashboards.
• Do Data analysis to verify Rave data is correctly captured in the Comprehend system.
• Evaluate/review metrics developed by Comprehend to determine if BioMarin requirements have been met.
• Work with study managers and study teams to define and clarify BioMarin requirements.
• Work with Comprehend development team to coordinate/facilitate metric development.
• Create/update business requirements document, other project documents.
• Implement Global Decision Tracking (GDT) System; GDT is a Software as a Service (SaaS) solution. Vendor: Intagras, Inc.
• Configure Out-of-Box system to support current BioMarin Label Management processes.
• Develop use cases, new work flows, new business processes.
• Create/update business requirements document, other project documents.
• Do UAT and acceptance testing with the team.
• Independent Research Portal-
• Develop test scenarios-
• Do integration testing and UAT testing
• Applications:
• Independent Research Proposal Submission/Review/Approval/Tracking System
• IR Portal & Tracker apps, Vendor: Elegrity Independent Research Portal and eGrants management
• Grants and Charitable Contributions and Independent Research Support functions, Vendor: MResults eTMF - (electronic Trial Master File System)
• Application: Veeva Vault Document Management System
• Activities:
• Site Administration, User setup, Workflows, Testing

Environment: Waterfall, PMBOK & RUP project management methodologies. Microsoft Office suite. Visio. Microsoft Project, SQL, SQL Server, LiveLink doc repository. COTS products.

Confidential, Fairfield, CA

Business Analysis / Data Interface Analysis

Responsibilities:

• Review / evaluate / recommend solutions for data interfaces in an SAP environment-
• Review/analysis of existing business processes and software systems for conversion to Enterprise Service Bus / Service-oriented Architecture-
• Activities:
• Project Management:
• Schedule interface reviews based on complexity and priority, and resources available.
• Business Analysis:
• Review data interfaces for completeness in terms of business process functionality.
• Identify gaps in business processes.
• Review business requirements for completeness.
• Update business requirements as required.
• System Support:
• Data analysis using Squirrel SQL Client / SQL on AS/400.
• Software functionality review
• QA / test procedures.
• Software analysis:
• Review data interfaces for completeness in terms of technical functionality, compatibility with other systems. Update technical specifications.
• Identify problem areas in interfaces (field size, type, availability of data, error mgmt., etc.).
• Presentation of findings:
• Create document outlining problem areas in business and technical specs.
• Include options and solutions to rectify problems.

Environment: SAP PI, ECC, CRM - Waterfall, PMBOK & RUP project mgmt methodologies. PowerPoint, Excel. Visio, Word, Msft Office suite. SAP, Oracle, DB2, Unix.

Confidential, San Francisco-Bay area, California

Business Analysis / Software Development / Project Management

Responsibilities:

• Creation of informational / educational website
• Project Management:
• Define required tasks for project.
• Create project plan, schedule.
• Track project tasks, monitor / document status.
• Business Analysis:
• Determine general business objectives.
• Define business requirements for site content, develop site content.
• Define user interface requirements, ease of use, page flow,
• Define test requirements.
• Get trademark registration.
• Software development:
• Determine software requirements.
• Execute development tasks on project plan.
• System / UAT test. Implement final product.

Environment: small company development team. Waterfall, PMBOK & RUP project mgmt methodologies. PowerPoint, Excel. Visio, Word, Msft Office suite. HTML, PHP, Javascript development tools.

Confidential, Salinas, CA

Project Manager / Business Analyst

Responsibilities:

• Conversion of Confidential NA credit card systems to Confidential - BI tools logical separation.
• Project objectives:
• Logical separation of user access to BI tools: Cognos, SAS, DataStage, TM1, DB/DH, misc. tools.
• Activities:
• Develop project documents: test, validation, review, approval, closeout.
• Monitor, facilitate and report on conversion progress.
• Interface with business and technical Confidential groups to facilitate conversion.
• Facilitate review and approvals process by business and technical groups.
• Conversion of Confidential NA credit card systems to Confidential - Acxiom data separation.
• Project objectives:
• Separate customer data in data warehouse of outside vendor - Acxiom - into Confidential and Confidential data sets. Adjust DW access for sellco & remainco employees..
• Activities:
• Hold status meetings, report to stakeholders, conversion monitoring group, CapitalOne. Track / monitor separation process.
• Work with business and technical stakeholders to facilitate data separation.
• Enhancement Projects:
• Fact Act system enhancements:
• Project objectives:
• Enhance fraud security measures for online customer support systems.
• Activities:
• Work with BA, SA, SMEs, stake-holders, developers to create requirements docs, design docs, project plan, test plan, implementation plan, validation plan.
• Hold weekly status meetings for stakeholders to track/report project status, deal with issues: software, hardware, system/UAT/regression testing, QA, fraud, risk, etc.
• Facilitate project execution to completion.
• Project size: $1.1 million. Team size: 30 business, 25 technical.
• Menards Prescreen of One:
• Project objectives:
• Prescreen private card applicants for Menards stores.
• RAD Hardship Tool:
• Project objectives:
• Provide agent collectors with one tool for gathering and storing hardship customer information, to reduce errors and delays, improve customer service.

Environment: multiple project teams of business and technical personnel in a matrix organizational structure. Waterfall, PMBOK & RUP project mgmt methodologies. Clarity/Open WorkBench & MSFT Project project mgmt software, PowerPoint, Excel. Visio. HP Quality Center test mgmt. Web environment.

Confidential, San Francisco, CA

Business Systems Consultant

Responsibilities:

• Conversion of Wachovia customer base to Confidential customers -
• Project objectives:
• Import Wachovia customer databases into XA online Customer Authentication SOR database.
• Activities:
• Develop project documents: Requirements, project plan, design.
• Work with developers to create operational conversion docs: system overviews, process and work flows, conversion timelines and game plans.
• Monitor, facilitate and report on conversion progress.
• Interface with other relevant WFB groups: Enterprise Transition Services, Internet Services group, Online Customer Services, etc.
• Coordinate XA conversions with other WFB applications and lines of business: Hogan Customer Info System database, Business-online-Banking, Bill-Pay, HomeEquity,etc.
• Multiple conversions by state and line of business: up to 1,000,000 customers per conversion.
• Team size: 10 business,15 technical. $10 million + overall project budget.
• Retirement of Powers online Customer Authentication System of record-
• Project objectives:
• Retire the Powers system and move it’s functionality to the XA and Hogan systems. Included software apps and multiple dedicated servers. Retire all hardware and software assets.
• Activities:
• Work with technical personnel to determine test & production databases, and all supporting systems to be terminated, retired or discontinued.
• Determine all external systems interfacing with the Powers system and procedures for disengagement.
• Create game plan / timeline for disengagement process.
• Implement disengagement process.
• Event Readiness Conversion Validation environment-
• Project objectives:
• Support for XA contributions to ER Lite test environment.
• Activities:
• Work with developers to coordinate creation of test environments for distinct Wachovia conversions (by line - BillPay, CashEdge and by location - Florida, Virginia, etc.)

Environment: multiple project teams of business and technical personnel in a matrix organizational structure. Waterfall, PMBOK & RUP project management methodologies. MSFT Project, PowerPoint, Excel. Visio. Unix servers w/Informix DB, IBM Z/OS w/DB2 database, CICS, COBOL.

Confidential, Oakland, CA

IT Project Manager / BA

Responsibilities:

• Develop portal for research collaboration.
• Develop research project review and approval capability.
• Develop project documents: Requirements, project plan.
• Work with developers to create design docs for page and dashboard graphics.
• Work with business users to develop requirements, UAT docs: Requirements, Traceability Matrix, Test Plan, test scripts, training, use cases, work flows.
• Manage project to successful completion.
• SQL Server, .NET environment.
• Team size: 3 technical, 3 business.
• Lab Management/Execution System (LIMS/LES)-
• Project objectives:
• Develop informatics system for bio sample extraction.
• Activities:
• Work with technical personnel to determine lab informatics requirements: specimen tracking, lab instrument data capture, sample aliquoting, concentration/quality analysis, normalization, specimen inventory management.
• Lab robot coordination.
• Determine IT project tasks, communications and risk mgmt plans.
• Develop workflows, lab IT processes, data QC processes.
• Use work breakdown methodology to determine Project Plan tasks.
• Develop project plan, coordinate work, manage meetings, document system architectures, schedules, resource allocations, project documents, budgets.
• Manage to project plan, to project completion.
• Manage status reporting, issues logs, project tracking, communicate status to stakeholders.
• Work with / coordinate tech team activities.
• Work with stakeholders to develop user requirements, project priorities, risks, business processes.
• Team size: 10 business, 10 technical.

Environment: 3+ working groups (15+ people total) of business and technical personnel in a matrix organizational structure. Waterfall, PMBOK & Agile-based project management methodologies. MSFT Project, PowerPoint, Excel. Visio. Biomek FXp & NXp lab robots and associated methods programming. HIPAA privacy requirements on patient data. SAS

Confidential, San Francisco, CA

Project Manager - Business Analyst

Responsibilities:

• E-mail / Data Enhancement project - CRM/sales/contact management - Project objectives:
• Consolidate multiple sales databases.
• Provide mass email campaign capabilities to user groups.
• Provide reporting and metrics on email campaign responses.
• Activities:
• Manage project relationship with multiple vendors in SaaS (Software as a Service) environment:
• Acumen - Custom application code interface between database and Cvent email/event management, hosted at Wallstreet On Demand. database of record hosting.
• Wallstreet On Demand - web site, landing page & Acumen custom code hosting.
• Cvent - Targeted event mass email generation & response recording with metrics.
• ExactTarget - Targeted event mass email generation & response recording, metrics.
• Work with Confidential Investment Management ( CSIM ) organizations responsible for: sales support, marketing email campaigns, fund sales, hardware/software, reporting and -statistics, fraud, risk, unit-system-QA & user testing, installation and implementation.
• Work with Schwab & vendor personnel on web and email template design & business processes.
• Develop project plans, coordinate work, manage meetings, document system architectures, determine tasks, schedules, resource allocations, project documents, budgets, risk mgmt.
• Use work breakdown methodology (WBS) to determine project tasks required.
• Manage status reporting, issues logs, project tracking, communicate status to stakeholders.
• Work with and coordinate tech team activities related to specific projects.
• Work with stakeholders to develop user requirements, project priorities, business processes.
• Develop risk mitigation & communication plans, UAT/acceptance plans and criteria.
• Technical design and review of CRM data warehouse structure and content, data loading.
• Review of and modifications to HTML and customer-facing web content.
• Team size: 10 business, 20 technical.

Environment: 10+ working groups (30-40 people total) of business and technical personnel in a matrix organizational structure. J++/Oracle. COTS products. Waterfall, PMBOK & RUP project management methodologies. MSFT Project, PowerPoint, Excel. Visio.

Confidential, San Francisco, CA

Project Manager

Responsibilities:

• Extreme Makeover project - Standardize and enhance customer experience with online banking at Walls. Worked as PM for the Online Customer Service group to implement the OCS component of the Extreme Makeover project.
• Data Enhancement project - Link and standardize interfaces to the two primary customer databases for online banking. Worked as PM for the Online Customer Service group to implement the OCS component of the Data Enhancement project. Software and hardware installs.
• Activities:
• Work with representatives of multiple Confidential organizations responsible for: hardware, online customer and banking web software, database software, reporting and statistics, banker and customer communications, customer support, banking processes, unit, system, QA & user testing, installation and implementation, fraud, & risk issues, etc.
• Develop project plans, coordinate work, manage meetings, document system architectures, determine tasks, schedules, resource allocations, project documents, budgets, risk mgmt.
• Use work break down to determine tasks required to accomplish project objectives.
• Manage status reporting, issues logs, project tracking, communicate status to stakeholders.
• Work with and coordinate tech team activities related to specific projects.
• Work with stakeholders to develop user requirements, project priorities, risks, business processes, UAT anad acceptance testing.

Environment: 30+ person teams of business and technical personnel in matrix organizational structure. Java, C++, Websphere MQ, Oracle.