Business Systems Analyst

Sheila Marie C. Pascual

Mobile Number: +63-917-*******

Currently works with AIGSS for 6.5 years for various roles such as SME, Business Analyst/Lead and QMO (Quality Management Office) Lead

Total work experience of 19 years as Business Analyst in Banking & Insurance domains. Assumed other roles such as Business Analyst/Lead, Test Analyst/Lead, Project Coordinator, Country Lead and Assistant Relationship Manager.

A team player who can work collaboratively at all levels of Project team.

Work and communicate effectively with multi-cultural project sponsors, customers &/or clients.

ACADEMIC / PROFESSIONAL CERTIFICATIONS

Bachelor of Science in Applied Mathematics from De La Salle University, Manila September 1991

PROFESSIONAL EXPERIENCE SUMMARY

Senior Analyst with AIU-MRTC/ Chartis Techology/ AIG Shared Services (AIGSS) Philippines since Jun 2008

Korea (offshore) Country Lead with Deutsche Knowledge Services (DKS), from Jul 2007 – Jan 2008

Reporting Workstream Team Lead with Deutsche Knowledge Services (DKS), from Aug 2006 – Jun 2007

Assistant Relationship Manager with Citibank N.A Singapore, from May 2004 – Dec 2004

Senior Business Analyst/ Test Analyst/Project Coordinator with Metrobank Technology Inc (MTI), from Jun 1998-Apr 2004, Apr 2005-Aug 2006

Jr. System Analyst with Prudential Bank-EDP Dept, from 1992-1996

New Accounts Clerk/Teller with Prudential Bank, from 1991-1992

TECHNICAL EXPERTISE

Tools MS Office (Word, Excel, Project, Visio), HPQC (HP Quality Center) and JIRA for Incident Management, MS SQL, DB Solo, Rapid Sql, XML Spy

DOMAIN KNOWLEDGE

Banking/Financial (Investment, Retail)

Insurance (Consumer and Commercial Lines)

DETAILED PROFESSIONAL WORK EXPERIENCE (AIGSS)

Exposed to all phases of project development including project estimation (Gate 2 and 3 projects), requirements gathering, analysis and documentation, testing and implementation.

Job responsibilities include conducting requirement workshop, requirements gathering/elicitation and analysis (including Use Cases/ UML creation, prototyping, preparation of other requirements documents), test planning, test case and scripts preparation, test execution, and deployment.

Project : Quality Management Office (QMO)

Client : Testing Shared Services Unit (TSSU)

Duration : February 23, 2015 - Present

Role : QMO Lead

AIGSS TSSU-QMO works with global TSSU-QMO in the development and support of programs, activities and services that integrate quality assurance, performance monitoring and analysis, and resources throughout the TSSU.

Roles and Responsibilities

Leads the QMO analyst to ensure all weekly, monthly and yearly reporting are generated and submitted with quality on time.

Generates standard and adhoc Management reports.

Reviews the generated reports (such as Chargeability report, Weekly status report, Headcount report and other adhoc reports that may be requested) prior to submission to the Management team.

Plans and develops standards and practices that will improve the processes being executed throughout the TSSU team.

Project : United Guaranty – Hong Kong (UG HK)

Client : UG Hongkong

Duration : September 29, 2014 – February 20, 2015

Role : Business Analyst

UG HK project is part of a comprehensive effort to analyze and identify solutions to align the UGC-HKIS application to the AIG technology standards.

Roles and Responsibilities

Document functional requirements and Use cases using the standard AIGSS requirement document and Use case templates.

Conduct walkthrough of Use cases to the project team and Business/Stakeholders.

Project : Japan Translation (under Testing Shared Services Unit (TSSU))

Client : AIG - Japan

Duration : Jun 23, 20

Role : Business Analyst/ Test Lead

Japan translation project focuses on the translation of Saisentan artifacts such as BRD, SRS, SHLD and other adhoc documents and the review of these translated documents.

Roles and Responsibilities

Review translated business requirement documents (BRD) and provide review findings (defects) which are logged in a review log for appropriate action of AWS (3rd party translator).

Monitor the review progress of the translated BRD of the Manila and Japan team.

Plan the review schedule of other requirements artifacts such as System Requirement Specification (SRS).

Prepare a statistics of review findings (defects) identified during the BRD review activity. This is used to identify the key problem areas on BRD translation.

Prepare and submit weekly status report to Project Manager.

Project : PAS Global - IT BA (eBao Program of Work)

Client : AIG

Duration : July 1, 2013 – Present

Role : Global IT Business Analyst

The Global IT BA group was formed to address processes and standardization of gaps that have occurred in the regional/local requirements gathering efforts that have driven implementations of CLP in China and Vietnam, with rapidly progressing projects in APAC and Latin America.

Roles and Responsibilities

Review of eBao Functional Specification Document (FSD) of AIG Core release 3 (ACR 3).

Provide FSD review findings and logs them via JIRA.

Identify essential Business Analysis methodology standards to support future eBao or other policy administration system programs or projects such as:

oDrove coordination and documentation of Functional Decomposition Diagram (FDD) with eBao Business Analysis lead based on AIGSS FDD documentation

oDocumented naming convention proposal based on review of BRDs and FSDs produced globally

oMet and proposed Organizational alignment among Global BAs (former BSD), IT BA team,

oand eBao team with their respective roles and responsibilities

oProvided outputs based on meetings held with eBao BA Lead in eBao, Shanghai such as understanding and documentation of eBao BA practices, differences of business analysis approach of eBao BA team across the Columbia/Mexico (LAR), Korea (KR) and Singapore (SG) eBao projects.

oProposed and documented a Business Analysis approach based on the lessons learned from previous eBao Core release engagements leading to proposed changes in future projects.

Project : SG-Consumer Lines Platform (CLP) - Gate 1

Client : AIG Singapore

Duration : April 2013 – July 30, 2013

Role : Lead Business Analyst

SG-CLP (Gate 1) project aims to establish the AIG Core and Singapore-specific requirements detailing the common processes, reports, documents and product standardization of Consumer Lines of Business (Auto, Home, IPA).

Roles and Responsibilities

Participate in SG CLP workshop and records action, parking and requirement gap items.

Guide and assist the AIGSS Project BA team in understanding the requirement gaps raised during workshop and business requirement document (BRD) preparation. Ensures the team uses the BRD template according to SDLC 3.0.

Review and revise the prepared BRDs prior to Business review.

Facilitate and participate in the internal and business review session of BRDs.

Monitor the BRD delivery to the business.

Handle the consolidation of clarification items on the requirements raised by BAs

Coordinate with Business SME for response or feedback on the requirements clarification items.

Work with Project Manager to establish the BRD approach in terms of standardizing the BRD content and review process.

Project : APAC-Consumer Lines Platform (CLP) Backend Services (Gate 2 and 3)

Client : Chartis Asia Pacific – China, Vietnam

Duration : October 2011 – March 2013

Role : Lead Business Analyst

APAC- CLP for Backend Services comprises of different modules such as Booking service and Inquiry services. The objective of the project is to provide a solution for booking the policy and claims issued on CLP, a third party application developed by eBao. In addition, the system allows inquiring the policy and claiming information of both existing and new transactions. The Backend services perform data extraction, validation, enrichment and persistence prior to booking the transactions into GOALD. It covered the product such as Auto, Home and IPA.

Roles and Responsibilities

Provide requirements and testing efforts for Gate 3 estimation of the project.

Coordinate with eBao (subscriber), Mphasis (China GoalD owner) and Regional representatives during requirements gathering/ validation and testing phases (Integration).

Prepare and maintain the Requirement Specification Document (RSD);

Conduct RSD walkthrough with Stakeholders to discuss the details in the document; acquires stakeholder sign-off of the RSD.

Prepare and maintain the Policy, Claims and Financial Object Model (POM, COM and FOM) worksheets. Involved in data mapping between CLP and GOALD.

Prepare and maintain other CMMI documents such as Requirements List, Use Cases, and Requirements Traceability Matrix.

Prepare, review and maintain CMMI test artifacts such as Test Plans (Master, System and Integration), Test cases and conditions, and test scripts (System and Integration)

Lead and conduct system test execution; analyzes defects raised by test team and coordinated with development team for defect resolution.

Prepare weekly system and integration test status summary report to the IQA (Internal Quality Assurance) team.

Manage and monitor the deliverables of co-BA and ensure these deliverables meet the target delivery date.

Provide support to Performance and System Integration test team on their test execution.

Provide weekly status update on the BA deliverables and highlights any issues of the project to the Project manager

Follow through stakeholders on the signoff of RSD and Master Test Plan.

Conduct Weekly status meeting with Regional and country stakeholders together and prepare minutes of the meeting.

Work closely with System Analyst during the data mapping of CLP and GOALD, discussion and understanding of technical solution of the project requirement and issues encountered during testing.

Assist the Project Manager in preparing some of the PM artifacts such as Project proposal, Project Charter, Baseline Map, etc.

Act as interim Project Manager and tasks to monitor and control the project cost, budget and schedule; provide weekly status report to Region.

Project : S3B-Guam (Gate 2)

Client : Guam

Duration : January 2, 2013 – February 15, 2013

Role : Lead Business Analyst

The project aimed to implement a simplified booking facility called S3B Philippines in order to comply with booking requirements and eliminate use of DTO.

Roles & Responsibilities

Coordinate and manage the Requirement specification document (RSD) preparation and completion.

Facilitate the requirement elicitation and validation meeting with the Business SME.

Prepare the initial Gate 3 estimation.

Project : APAC Combined @Venture Wave 2 (Gate 2 estimation)

Client : AIG APA – China, Taiwan, Philippines, Vietnam and New Zealand

Duration : January 2012 – February 15, 2012

Role : Lead Business Analyst

The project aimed to implement a fully automated online solution for small to medium enterprise (SME) business to Wave 2 countries such as China, Taiwan, Philippines, Vietnam and NZ. In addition, it also aimed to implement the backend (GOALD booking) services and reporting functions which was developed from Wave 1 APAC countries.

Roles & Responsibilities

Contributed and participated in the preparation, review and completion of Gate 2 proposal

Provided Gate 2 estimation for tasks under Requirement analysis phase.

Project : Concierge-Dubai (Gate 3)

Client : Chartis UAE

Duration : July 2011 - Nov 2011

Role : Test Analyst

Concierge-Dubai is a web based policy servicing application for Home and Auto insurance business of Chartis-Dubai. This project is the second country where the Concierge system is deployed. After Concierge Australia, this project is enhanced further to support Private Client Group (PCG) business in UAE.

Roles & Responsibilities

Perform in system test execution, including reporting of incidents in HPQC (Incident Log tool)

Prepare system test cases, test condition and test cases

Re-test fixed incidents and provided proof of test.

Work with development team in resolution of test incidents

Prepare and submit the weekly test status update to Test team lead.

Project : DMWeb-Sweden Enhancement II (Gate 3)

Consumer Lines Platform Global Application Solution (CLPGAS)

Client : Chartis - Dublin Regional Technology Center (DRTC)

CLPGAS – Chartis, New York

Duration : Feb 2011-Apr 2011; May 2011-Jun 2011

Role : Test Analyst

DMWeb Sweden Enhancement II is a tactical short-medium term solution for the Sweden DM (Direct Marketing) Business to enable growth via a new OKQ8 Sponsor Billing Organization and increased operational efficiency via key enhancements on the current European DMWeb platform.

CLPGAS will establish global operational readiness supporting high-volume, low-cost products and services for consumer lines business segments on a single platform accelerating profitable customer-focused initiative. It covers A&H products.

Roles & Responsibilities

Assisted in the system testing of DMWeb-Sweden application.

Performed system integration and regression testing of CLPGAS application.

Project : eXtra- Europe Production Support (PSG)

Client : Chartis Dublin Regional Technology Center (DRTC)

Duration : Jun 2010 – Oct 2010

Role : Business Analyst

Roles & Responsibilities:

Perform triage and analysis to production issues

Create Defect Analysis Documents (DAD) out of the analysis.

Perform system testing of fixes prior to build release to DRTC-QA environment.

Perform system integration testing of released build.

Projects : BPO-Belgium

Policy Database

Spain Upgrade (Process Optimization)

Quote Follow-up

Mid-Term Adjustments (Phase 2 Enhancements)

GL (Casualty) and PI (Professional Indemnity) Products Enhancement

Client : Chartis - Dublin Regional Technology Center (DRTC)

Duration : November 2008 – November 2010; Jan 2011

Role : Lead Business Analyst/Test Analyst

eXtra-Europe is a policy administration, PEGA based, solution for Commercial Lines deployed in European countries such as France, Germany, Italy, Netherlands, Spain, Belgium, Luxembourg, Austria, Portugal, Switzerland, Denmark, Norway and Sweden.

Roles & Responsibilities:

Work with the BA counterpart in DRTC on revising the documented requirements.

Prepare, review and revise Functional Specification Documents (FSD)/ Use Cases including prototype and process flow diagrams, as necessary.

Review QA and UAT test plan and test cases

Review QA incidents raised by QA team and assess validity before handling off to developers for fix.

Perform sanity test of fixes and build releases in QA environment.

Perform system integration.

Work as interim DRTC BA for Spain Upgrade project in DRTC (Dublin) office during the absence of BA lead.

Project : Korea Agency System Automation (Phase 1)

Client : AIG - Korea

Duration : Jun 2008-Oct 2008

Role : Lead Business Analyst

The project aimed to automate the business products and process to generate more New Business production via distribution channels and improve the process of policy processing (quoting, booking and issuing) by building a web portal that serves as a Quotation engine for Producers and internal staff.

Roles & Responsibilities:

Facilitate the elicitation of business and functional requirements (including non-functional requirements) of the project and document these requirements using the Chartis standard Requirement Specification and Use Case templates.

Prepare UML and Process Flow Diagrams using MS-Visio as supplementary to Requirement documents.

Present and validate the requirements with users and stakeholders, usually on-site, and obtained business signoff prior to proceeding on the next phase.

DETAILED PROFESSIONAL WORK EXPERIENCE (Deutsche Knowledge Services (DKS))

Project : Financial System Renewal (FSR)

Client : Deutsche Bank – Finance, Korea

Duration : Jul 2007-Jan 2008

Role : Korea Country Lead

Roles & Responsibilities:

Work with Singapore counterpart ensures the timely delivery of project deliverables; monitors project progress across project workstream in DKS and takes appropriate actions or decisions to maintain project schedule.

Prepare weekly project dashboard and presents to Program Management Team and Operations Committee.

Ensure that the business scope document is updated for any developments or changes on the business requirements that CFO (Chief Finance Officer) had signed off conditionally or agreed.

Conduct fortnightly working group meeting to discuss or communicate project issues and updates with Project team and CFOs.

During users acceptance testing (UAT), act as a Test Coordinator who reports to Test Manager and Project Manager; prepares UAT signoff document; schedules daily UAT meeting to project team and CFO.

Review and provide input to project plan, test strategy and test plan. Discuss project plan and test plan to CFO.

Project : Financial System Renewal (FSR)

Client : Deutsche Bank (Global)

Duration : Aug 2006-Jun 2007

Role : Reporting Workstream Lead

Roll-in implementation of General Ledger template 4 using ETL, SAP and Cognos to Deutsche Bank globally which standardize the feeds, accounting and ledger postings, as well as the group and local reporting processes.

Technology used: Sharepoint, Cognos 8, SAP R/3 (RDM), SAP BW, BEx Analyzer/Explorer, dbNexus

Roles & Responsibilities:

Act as a central point of coordination, requirement analysis and review of country specific reporting needs.

Participate in FSR project scoping for Deutsche Bank – Mumbai, India.

Develop a clear project plan deliverables for Manila implementation

Conduct periodic review of performance of the team identifying key improvements and knowledge gap.

Manage the overall team deliverables and ensured the timely delivery of these according to agreed project timeline.

DETAILED PROFESSIONAL WORK EXPERIENCE (Citibank, N.A, Singapore)

Projects : Citibusiness Conversion from FlexCube to Systematics;

Business-As-Usual (BAU) enhancements

Client : Citibank N.A - Poland

Duration : May 2004-Dec 2004

Role : Assistant Relationship Manager

Roles & Responsibilities:

First point of contact for Poland supported by International Banking Services (IBS) on business initiatives or requests.

Follow up product processors (IT developers) teams deliverables such as estimates, production problem fix, UAT issues resolutions, and functional and technical design specifications

Coordinate pre-implementation and implementation requirements with product processors, data center/ UAT and production operators (including checklist preparation; ensures IDs and reports necessary for the cutover are defined properly)

Perform project management by monitoring project status and delivery of Citibank service center, prepare UAT schedules in accordance with country’s request; perform necessary coordination to various units necessary to completion of project/s or any country concerns

Monitor UAT batch processing and ensures delivery of online availability within agreed service level agreement (SLA); performed UAT completion follow-up and communications with business users

DETAILED PROFESSIONAL WORK EXPERIENCE (Metrobank Technology Inc (MTI))

Projects : Branch Automation System (BAS)

Base 24 ATM projects

BancNet InterBank Fund Transfer,

Metrobank MasterCard as Acquirer and Issuer,

Metrobank VISA Acquirer,

Mastercard 3DES, Metrobank Branches Consolidation,

Metrobank-Solidbank branch consolidation

Metrobank-PSBank branch Consolidation

Metrobank Canton to Systematics system conversion

Client : Metrobank branches; Metrobank-ATM Department

Duration : May 1996 – Aug 2006

Role : Lead Business Analyst, Test Lead

Roles & Responsibilities:

Gather business requirements and translated these to functional design specifications that can be successfully executed by IT developers;

Present the business requirements/functional design specifications to Project team and users and secured signoff of this from users prior to technical build.

Prepare and review system integration testing (SIT) test plan and test scripts based on agreed business and functional requirements

Perform system integration testing and logged any test issues encountered during the execution of testing.

Act as test lead during system integration and users acceptance test activities.

Provide post go-live support to users and MBTC-Technology Customer Service Center on project queries and issues

Project : Customer Insights (developed by SAS)

Client : Metrobank

Duration : Sep 2007 – Aug 2009 and Nov 2009

Role : Project Coordinator

The project aimed the centralization of demographic data of Metrobank clients into a single database system where this information comes from various feeder systems (such as Systematics and Datawarehouse). This also facilitates the preparation of management reports to be used by the Bank’s management & executives

Roles & Responsibilities:

Point of contact of MBTC-Technology for this project to coordinate the queries and requirements of SAS for the completion of the project to MBTC-Technology Operations and IT teams;

DETAILED PROFESSIONAL WORK EXPERIENCE (Prudential Bank – EDP Department)

Project : CA/SA Automation (Current Account/Savings Account)

Client : Prudential Bank

Duration : 1992-1996

Role : System Analyst

Roles & Responsibilities:

Migrate the Bank’s savings and current accounts’ balance into the new CA/SA system and perform reconciliation at the end of the migration activity.

Provide user support to business users on CA/SA/FCDU system after the conversion activity.

Provide business user training prior to implementation.

For enhancements to the system, conduct product testing to ensure client requests are met.

Contact this candidate