SUMMARY

• A competent and experienced business systems analyst with 12 + years of continuous performance in various projects, multi - disciplinary teams of varying sizes and complex programs of work. Has the ability to build strong relationships with all stakeholders and to turn proposals into reality. Especially successful in management roles that demand rigor, a high level of drive and dedication with a focused attitude towards delivering business outcomes through the use of Waterfall and Agile methodologies.
• Technical experience in implementing solutions that improve enterprise effectiveness, streamline business processes and process workflows.
• Solution oriented approach with diverse experience in business systems analysis, requirements definition and specification, system design, process modeling, and software development.
• Collaborated with Stakeholders, End users, SME, Third Party vendors to analyze and document information needs and functional requirements delivering accurate and detailed artifacts such as Business Requirements (BRD), Functional Specification Design, Process Workflows, High Level System Design Documents, Proof of Concept (POC), Blue Print Design, GAP analysis, Database Data mapping and Test Plans for a broad range of business applications and IT solutions throughout all phases of the project life cycle (SDLC).
• Cross-functional, enterprise-wide workflow experience with broad experience in business applications.
• Experienced with multiple project approaches including Waterfall, Agile-Scrum, JAD, RAD, Spiral methodologies.
• SDLC Methodologies: UML diagrams (Activity, Sequence, Context, Sequence, Class, Use Cases, Swim lanes).
• Experienced with e-Commerce B2C/B2B Portals, SAP HR/FI, CRM-Siebel, DMS IBM Filenet Web Portal, .NET Framework, ERP (SAP ByD), Content management Systems (Documentum and IBM Filenet).
• Experience in developing prototype mockup screens for presentations to end-users, stakeholders and SME’s for the functional design.
• Experienced in the Software Development Life Cycle process (SDLC), from Gap Analysis, Data Mapping to Requirements Gathering, Design, Testing, Implementation, and Maintenance.
• Primary liaison with end user, stakeholders, third party vendors, software architects, SME’s, Quality Assurance and development teams (on site and offshore) on .Net, Web (B2C/B2B), ERP, and CRM platforms.
• Participated in Black and White Box testing as part of the Quality Assurance team, performed UT, UAT, Regression, and Integration testing. Developed test cases and test objectives.
• Experience as a data analyst in Client Server applications (RDBMS Oracle, T-SQL, DB2).

TECHNICAL SKILLS

Databases: Oracle (SQL and PL/SQL), MS T/SQL, MS Access and DB2

Languages: MS SQL, Oracle PL/SQL

Platforms: NET Architecture, SOA, Visual Studio, SharePoint, Java, ASP, XML, AJAX, J2EE, E-Commerce (B2C and B2B), SAP ECC 6.0, FileNet (IBM - Content Management), Documentum (EMC2), Team Foundation Server (TFS) and SharePoint

Software Tools: SNAGIT, MS SQL Analyzer, HP Quality Center, ETL: SSIS - SQL Server Integration Services

Packages: COTS: SAP R/3/XI, COGEN (Insurance), SAP ByD (Supply Chain), SAP HR/FI

Business Objects: SAP BI Solutions, COGNOS

Software Applications: General Finance and Accounting: Accounts Payable and Receivables, General Ledger, Billing, Human Resources, Payroll, Sales and Marketing, Credit Risk, Underwriting and Commissions

Industries: Telecommunications, Biotechnical, Entertainment, Health Care, Property, Casualty Insurance

Project Skills: Microsoft Office: Excel, Word, Visio, MS Project Manager, PowerPoint and Web Conferencing

Project SDLC Methodologies: Rational Tools (Use Cases, Waterfall, RAD, JAD, UML (Data Modeling), AGILE ( User Stories), Business Process Modeling (BPM).

Change Management: JIRA, Remedy, Test Director, Rational Tools and HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential - Burbank, CA

Business Systems and Data Analyst

Responsibilities:

• Led the business enterprise solutions for the integration of data points to expand the core metadata of LOB from Digital Project Management (DPM) (Theatrical, Home Entertainment (HE), DC Comics Books) into the Master Data Management System RELTIO iCloud software application.
• This project objective was to produce data clean-up and conversion of fully approved localized IP data from all territories from various line of business. Expansion of the IP Glossary data model to include advanced metadata (e.g. Character, Story, Environment, Object, Publishing, Language) into the existing core metadata database for data metrics and analytics .
• Data analysis generating Excel Pivot tables, formulas.
• Participated with the Data Governance, DC, HE, Theatrical stakeholders, end users to gather, analyze the business requirements and produced the Business Requirements Document (BRD), Data Mapping.
• Produced the gap analysis: As is vs. to be processes, Functional Requirements documents.
• Incorporated use cases UML Data Flow Diagrams (DFD)as part of the high level design, wireframes, POC screens. This entailed documentation of current and future state of business process.
• Produced the Advanced Metadata conceptual data model entities and attributes using NAVICAT software tool.
• Produced the test plans and test case scenarios and collaborated in reviewing and approving from the end users.

Environment: RELTIO (Master Data Management iCloud software applications), MONGO NoSQL database, MS Office products

Confidential - Irvine, CA

Business Systems Analyst

Responsibilities:

• Participated as a Lead Systems Analyst in the conversion and implementation from Microsoft Dynamics to SAP ByD (Supply Chain) Web portal application. Collaborated in doing the analysis of the current state, elicited and produced the Business Requirements (BRD) from stakeholders, SME’s from inception to document approvals, collaborated in with key business users to analyze and scope out their business need.
• Worked closely with Marketing, Domestic and International Sales, Operations, Field Service, Finance-Accounting, Claims, and Quality departments to understand their business requirements and partner with consultant firms to develop creation of the Business Requirements and the Functional Requirements documents; supported enhancement to the CRM application.
• Performed gap analysis: As is vs to be processes.
• Managed relationships with multiple departments for design of new solutions features.
• Created SAP ByDesign training materials (work instructions and test cases) for all the business departments for the Supply Chain.
• Developed prototype mockup screens, wireframes, swim lanes diagrams for presentations to end-users, stakeholders and SME’s for functional design.
• Produced the current state (“as is”) and proposed solution (“to be”) UML Flow, Activity and Sequence diagrams as part of functional design. Proof of Concept (POC) and business requirements developed UML diagrams, process and data flow diagrams use cases, created the data mapping, impact and gap analysis for the data conversion.
• Collaborated with the SAP Third Party vendor development team to review the functional design document; detailed level design and functional Use Cases, SAP ByD Business Objects Reporting screen design.
• Produced the data mapping from source to target. Produced GUI Dashboard interface design as part of the backend database AD-HOC reporting needs to the end users. Developed mockup screens for the dashboard screens UI, POC, Use Cases; incorporated High Level Design as part of the Functional Requirements.
• Produced the Traceability Matrix for the Business, Functional and test case Objectives.
• Developed the test plan, test case scenarios for the UAT team.

Environment: Oracle 11i, Web Services, MS Office products, SAP ByD

Confidential - Los Angeles, CA

Business Systems and Data Analyst

Responsibilities:

• Led the business enterprise solutions for the integration of MD-Staff credentialing physicians for the conversion to MSOnet (Online Web based application). This entailed analysis of the existing MD-Staff application, produced detailed business process diagrams for new appointments and re-appointments, produced the gap and impact analysis on business processes and data transformation values. Generated inventory of the existing reports, letters and database data mapping elements from source to target.
• Designed a UI for the end users to be able to generate AD-Hoc reports from the database via COGNOS in a Datawarehouse (DW) platform..
• Integrated privileges content from MD-Staff and advanced practice allied health professionals to the through a Web-based subscription service to the Web TM (MSOW), Morrisey’s application.
• Define the business process for the initial, reappointment and expirable appointments for the physicians to be converted to the MSOnet Online Web based application.
• Produced the data mapping from source to target. Developed and executed SQL Queries for data profiling and analysis on the Web dashboard and reporting business requirements.
• Developed SQL database Queries to validate Data Dictionary, data mining and enhancements to the ETL process for data transformation and integrity from source to target databases.
• Developed prototype mockup screens, wireframes for presentations to end-users, stakeholders and SME’s for functional design.
• Produced the current state (“as is”) and proposed solution (“to be”) flow diagrams as part of functional design. Proof of Concept (POC) and business requirements developed UML diagrams (Activity, Use Cases, Sequence), process and data flow diagrams use cases, created the data mapping, impact and gap analysis for the data conversion.
• Produced the Traceability Matrix for the Business, Functional and test case Objectives.

Environment: Oracle 11i, Web Services, Java, Crystal Reports, MS Office products

Confidential - El Segundo, CA

Technical Business Systems Analyst

Responsibilities:

• Led the business enterprise solution and design for enhancements to the Web Portal Community Portal application to be able to identify patients who are eligible for clinical interventions based upon criteria for clinical studies and measures. These patient populations will be identified using the HEDIS (The Healthcare Effectiveness Data and Information Set) core measures.
• Analyzed and incorporated the Business requirements from SME’s, End Users and produced the High-Level Design, Functional Requirements documents.
• Developed and executed SQL scripts for data profiling, scrubbing, impact analysis.
• Incorporated new reports from the Community Portal dashboard to generate the pursuit list, patient intervention and clinical metrics details and summary performance reports to be exported as PDF or EXCEL files.
• Communicated and collaborated with stakeholders to analyze and document information needs and functional requirements delivering accurate and detailed artifacts such as functional specification design, high level system design documents, GAP analysis, database data mapping and test plans.
• Documented the ETL process data mapping from Source to Target Datawarehouse (DW) database mappings and the upstream applications and Community Portal DW DFD’s.
• Developed use cases UML Data Flow Diagrams (DFD), decomposition diagrams and context diagrams to capture the functional requirements; incorporated wireframes, POC screens as part of the solution design. This entailed documentation of current and future state of business process.
• Produced training documentation for the Web Portal application: Community Portal.

Environment: Web Services, MS SQL, AGILE (SCRUM, User Stories), Team Foundation services (TFS)

Confidential - Cypress, CA

Business Systems and Data Analyst

Responsibilities:

• Participated as a Lead Systems Analyst in the conversion from the legacy Enterprise Data Storage System (EDSS/DataWatch) to Documentum; this project entailed migrating the 80+ data groups stored from EDSS to EMC2| Documentum thus providing the business a single platform to retrieve content, thus moving the enterprise one step closer toward providing a complete 360° view of member based content.
• Migration of decommission EDSS data groups to InfoArchiver (Documentum), thus purging the metadata from the legacy application.
• Collaborated in gathering of Business Requirements (BRD) with stakeholders, SME’s from inception to document approvals, collaborated in with key business users from the claims, pharmacy, subscribers, providers, Medicare and Medicaid teams to analyze and scope out business need.
• Produced high level design (FSD) functional and non-functional requirements, assumptions) and collaborated with functional teams (development, Architects, database, QA, service delivery and PM’s) in helping them implement solution based on high level design, use cases and test plans.
• Produced detailed functional design specifications, Proof of Concept (POC) and business requirements developed UML diagrams, use cases, created the data mapping and gap analysis for the data conversion.
• Participated in the Call Center IVR (Interactive Voice Response) Consumer letter Integration project for correspondence such as emails, text messages, outbound calls, and chats. This project entailed gathering business requirements and produced the high-level design documents.
• Supported QAT and UAT efforts, collaborated in reviewing and approving test plans and test objectives and testing activities to resolve any anomalies.
• Developed SQL database Queries for data reporting profiling.

Environment: Data Warehouse, Documentum (Enterprise Content Management/ uCI Cloud platform), InfoArchiver, MS SQL Server, MS Office products

Confidential - Agoura Hills, CA

Senior Business Systems Analyst /Data Analyst

Responsibilities:

• Participated as a Lead Systems Analyst in the conversion and implementation from Documentum to IBM FileNet (Content Management) a Web portal application; this project entailed scanning of documents at BAC for all supported divisions, routing documents for indexing to external vendors and ingestion of documents into FileNet database repository.
• Collaborated in gathering of business requirements (BRD) with stakeholders, SME’s from inception to document approvals, collaborated in with key business users to analyze and scope out business need.
• Facilitated scrum ceremonies (User Stories grooming, sprint planning, retrospectives, daily stand-ups, review sprint backlog, updated burn down chart at the end of each iteration).
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise.
• Designed a Web UI for the stakeholders to manually route the loan batches for processing to BAC or external vendors allocating batch priorities as per BAC Taxonomy.
• Produced high level design (functional and non-functional requirements, assumptions) and collaborated with functional teams (development, Architects, database, QA, service delivery and PM’s) in helping them implement solution based on high level design, use cases and test plans.
• Produced detailed functional design specifications, Proof of Concept (POC) and business requirements developed UML diagrams, Incorporated XML/XSD schemas specifications as part of the high-level design document.
• Developed prototype mockup screens for presentations to end-users, stakeholders and SME’s for functional design.
• Produced the data dictionary mappings for the inventory of reports as part of the Functional Requirements, participated in JAD sessions with data modelers to define the conceptual and logical design for the reporting database schema.
• Developed current state (“as is”) process data mapping and proposed solution (“to be”) process mapping models as part of the functional design.
• Participated as a Lead Business Systems Analyst in projects to comply with Department of Justice (DOJ), Real Estate Settlement Procedures Act (RESPA) and Internal Revenue Service (IRS) obligations for loans that are on bankruptcy status.
• Collaborated in JAD workshops with Functional Solution Architects and Subject Matter Experts to establish technical vision, blue print design, analyzed reporting requirements that will be generated by the COGNOS UI portal as per KPI, define security access roles.
• Developed use cases and traceability matrix as part of HLD (High Level Design).
• Developed SQL database Queries to validate Data Dictionary, data mining and enhancements to SSIS ETL process for data transformation and integrity.

Environment: IBM FileNet, Oracle DW, MS SQL Server, AS/400 (iSeries), IBM Cognos, Microsoft BI Tools, Agile/Scrum (User Stories) Methodology, Use Cases/UML, HP Quality Center (QC), MS Office Products, JAVA, XML/XSD.

Confidential - Los Angeles, CA

Business Systems Analyst

Responsibilities:

• Converted and implemented from Legacy Systems to a Web Portal e-Agent application for multiline of insurance products.
• Gathered business and functional requirements to redesign “Agent GUI/Web Portal” Consumer Servicing Application (B2C) Java/ASP application to provide better agents experience for servicing new and existing multi-line of business (Auto, Home, Earthquake, Life, Financial policies, insured’s policy payments (cash, credit card and check transactions) and streamline business functionality for the agent’s Quote/Buy, Fair Isaac (FICO scores) screens.
• Led international business enterprise solutions for MedImmune Netherlands and UK sites from legacy systems conversion and implementation into SAP R/3 HR and Benefits modules with Payroll data. This entailed gathering business requirements, scope analysis, streamline business process and departments workflows.
• Involved in systems analysis of international sites HRMS and Payroll software applications to produce data mapping, gap analysis and architectural design for data migration to SAP HR and outbound interfaces to other third party vendors systems. (Worker’s Comp, Private Health Care Insurance).
• Attended business and security workshops in Netherlands and UK to define legal compliance for data sharing among European and US sites and requirements’ approval.

Environment: SAP R/3 XI, MS SQL Server