Sandra Cerilli

ca.linkedin.com/in/sandracerilli ada7uh@r.postjobfree.com 416-***-****

PROFESSIONAL SUMMARY

Quality Assurance Analyst with extensive mutual funds experience in the financial industry. Focusing on testing and defect management for a variety of trading platform projects within major banking and vendor organizations. Committed to supporting the team with a proven track record of being the subject matter expert. Highly driven individual providing detailed materials to ensure guidelines are followed and programs are being utilized to meet company goals and objectives.

AREAS OF EXPERTISE

Manual Testing (SIT, BAT/UAT) and Defect Management

Mutual Fund and Securities Software Application

Software Development Life Cycle

ALM and JIRA, Agile and Waterfall Methodologies

Strong Analytical and Problem Solving Skills

Training and Development

Customer Service and Project Coordination

Coaching and Mentoring

TECHNICAL EXPERTISE

Familiar with SQL queries, QTP and Scenario Tester testing tools

Unitrax, iFAST/Desktop, iFAST Web Plus (Corfax based software applications for mutual fund recordkeeping)

Process Via Imaging (PVI) (Workflow system)

AS400 Applications (IBM and Prime OE), Think or Swim, Active Trader Platform (Equity and Options trading platform), FundSERV, Java Applications (NDEX, Active Trader Dashboard, IBM Trade Innovator, Think or Swim Desktop), CPS (Client Portfolio System) Tenemos (T24), BPS (Brokerage Processing System - Broadridge Mainframe System)

MS Project and MS Office Application – Excel and Sharepoint

CAREER EXPERIENCE

Broadridge Financial Solutions October 2018 – present

Quality Assurance Analyst

Facilitate Change Management meetings, prepare and execute test plans via ALM for all Registered Products (RSPs and RESPs) in QA and Productions regions

Perform Turnover weekend Sanity Testing and Regression Testing

Run Daily Automated Health Check Script and Reports for Broadridge Clients

B2B Bank November 2017 – May 2018

UAT Analyst

Lead and supported following projects: Mortgage Repatriation, New Credit Card Launch and FundSERV version 28,

Drafted test artifacts including test plans, test cases based on Functional and Business specification documents

Provided feedback on peer review test plans

International Financial Data Services November 2016 – August 2017

UAT Analyst

Successfully completed Day 1 and Day 2 test web initiatives surrounding enhancements, new business requirements, new client onboarding and product development. Smoke, Sprint and Business as Usual (BAU)Testing included.

Created test cases using business artifacts and product knowledge.

Reviewed test plans, business requirements for all changes to iFAST web applications with the team.

Executed test cases and document test results. Escalate system issues to the UAT Lead and retest defects.

Provided feedback on testing strategy and quality assurance testing.

Projects

iFAST Web Plus – Onboarding for new client Sunlife Financial

Sprint, Business as Usual (BAU) and Connectivity Testing and French content validation for Sunlife Financial, Renaissance Investments, Capital Group, Russell Investments, IA Clarington, Sentry Investments, Manulife Financial, Natixis Global Asset Management, PIMCO Canada

Manulife Financial October 2015 – October 2016

Business System Analyst

Acted as a liaise between the vendor IFDS and Manulife Financial to bring awareness of potential impacts facing the system when changes are implemented.

Completed Impact Analysis and Implementation documents to comply with Project Management Life Cycle.

Compared files for fund mergers mock runs to ensure accuracy for upcoming production activities.

Projects

ESG/FundSERV v25.2 and v26

Segregated Fund Merger Rationalization

Standard Life Segregated Integration

Service Desk

TD Wealth Management March 2011 – June 2015

IT Test/Quality Analyst – Investing and Trading Systems

Smoke (Connectivity Testing), Business Acceptance/User Acceptance (UAT) Production Acceptance and Regression Testing. Test Strategy, Test Plan and Case Creation and Execution, Test Plan Walkthroughs, Status Reporting and Defect Reporting and Management.

Led the ESG XML Conversion and FATCA projects for the Prime OE system in order to comply with industry standards

Managed IBM, Prime OE, NDEX and ATP Quarterly Maintenance Releases to ensure all changes were accurately implemented and that the systems remain Business as Usual.

Provided flexibility with scheduled work hours to ensure Agile release patches for Think or Swim were smoke tested for connectivity and avoiding interruptions with service.

Provided training and mentoring to other testing analysts to ensure testing methodologies and procedures were followed.

Created “how to” documents as a job aid for new trainees to ensure smooth onboarding of new team members to ensure consistency with procedures and processes.

Updated existing user guides and procedures to allow for quick and efficient training, and to ensure all adult learning principles were being utilized.

Acted as an information source and a trouble shooter for internal clients Prime Order Entry system in order to efficiently test the various functionalities of the system.

Projects:

Test Environment: IBM ISS-OSS and Prime OE (AS400), IBM Trade Innovator (Java), FundSERV, Think or Swim, NDEX (Java), Active Trader Platform (Nexa), Active Trader Dashboard (Java)

Testing Tool: Manual, ALM Quality Center

Project Description: IBM, Prime OE, TiSales Functional and Regression Releases, ESG (FundSERV) Maintenance and FATCA Functional and Regression Releases. Active Trader Dashboard Phase 1, Active Trader Client and Server Functional and Regression Releases, NDEX Regression, Think or Swim Releases (Agile)

TD Wealth Management May 2010 – February 2011

IT Test/Quality Analyst – Business Systems

Executed Business Acceptance/User Acceptance Testing, created and executed test cases and plans. Reported, tracked and retested defects.

Projects:

Environment: C3MFS (Front End - Web) and SMS (Back End - Unitrax), IBM ISS-OSS

Testing Tool: Manual and HP Quality Center

Project Description: MFDA Customer Investor Profile Changes, New Relationship Codes, TFSA Systematic Changes, Entitlements

Manulife Financial March 2010 – May 2010

Business System Analyst

Tested assigned functionalities including User Acceptance, Regression, USD Purchase Options, Confirms and Statements, DSC Calculations and Systematic Plans.

Defect and Management Reporting.

Projects:

Client: Citigroup

Environment: iFAST/Desktop

Testing Tool: Manual

Project Description: Conversion of AIC funds from Unitrax platform to iFAST/Desktop platform

International Financial Data Services October 2009 – February 2010

Release Administrator

Processed code reconciliation as required for scheduled releases.

Tracked and updated change requests and packing slips.

Ensured release notifications and status reports were completed and communicated weekly.

Coordinated and supported the Release Analyst and Managers.

Produced the UAT Log for the Domestic calls with clients.

Created and maintained release implementation schedule.

Monitored and organized the Release Management Mailbox.

Completed a process and procedure guide for new hires and to train co-op students on processes and procedures.

RBC Dexia Investor Services March 2006 - November 2008

Quality Assurance Analyst

Tested enhancements and corrected defect items to ensure the business requirements were created and performed accurately according to the Release Notes documents provided by the vendor.

Tested base functionality for new activated clients on FundSERV so that client trading could be performed automatically instead of manually through the broker.

Learned Unitrax (application used by Citigroup) in order to efficiently test the various functionalities of the system.

Learned the “Process and Development (PAD)” system used by the Business to be familiar with how they track defect items and request information from the vendor.

Maintained a progress report showing high success rates for each release to inform QA Manager and Business team on status of testing and defects found.

Created a quick reference guide “How to Review Test Cases on Mercury Quality Center” for the Business Unit to allow for a faster review of test cases and results.

Maintained a project plan using MS Project for the Enterprise Web team which provided timelines and task distribution for each team member.

Used Mercury Quality Center to store and download test cases from vendor, report results and direct internal defects to appropriate person for resolution.

Reduced time taken to complete and consolidated Executive Summary Report for QA and Executive Team and acted as a point of reference and support.

Projects:

GPlus Cash Optimization Date: August 2008 – November 2008

Client: RBC Dexia Internal; Environment: GPlus (Viewfinder); Test Tool: Mercury Quality Center

Enterprise Web Date: January 2008 – August 2008

Client: RBC Dexia Internal; Environment: Java, Oracle and Crystal Viewer; Test Tool: Mercury Quality Center

Project 3: Unitrax Date: March 2006 – January 2008

Client: Citigroup; Environment: Unitrax and FundSERV; Test Tool: Mercury Quality Center

International Financial Data Services February 1998 – March 2006

Quality Management Analyst – Level 2

Acquired more knowledge of iFAST application (formerly Corfax) in order to efficiently test the various functionalities of the system and acted as an information source and a trouble shooter for internal clients.

Conducted research and gathered pertinent information to document testing strategies.

Participated in the review of testing and documentation of other testing analysts to ensure accuracy.

Provided training and mentoring to other testing analysts to ensure testing methodologies and procedures were followed.

Ensured effective communication of user testing related issues were directed to appropriate internal and external parties via defect tracking tool “Magic” to store and prioritize all issues for resolution.

Detected defects in the early stages of testing to ensure the successful implementation of code deployment in client production environment.

Created test plans for functional, regression and Y2K testing for enhancement and defect items to ensure the requirements were created to perform accurately as per Business and Technical documents.

Projects:

Date: February 1998 – February 2006

Client: Manulife, Dynamic, AIM, Synergy, CFDS

Projects/Teams: Tax, RESP, Y2K, Transaction Processing, Segregated Funds, Dynamic Conversion

Environment: Operating System - Unix, Corfax/iFAST and Desktop

Testing Tool: Manual and Mercury Test Director

Responsibilities: QA testing and defect management for Enhancements and fixed Defects. Performed SIT and regression testing

EDUCATION, PROFESSIONAL DEVELOPMENT & AFFILIATIONS

University of Windsor– Bachelor of Arts in Languages and Literature

Berlitz Language School, Bologna, Italy – Completed Teaching English as a Second Language

International Financial Data Services - Delivering Exceptional Customer Care - 2001

IWCC Training in Communications - Effective Technical Writing - 2001

Learning Tree International - Certificate in Software Testing and Inspection Methods – 2002

Internal Training at IFDS – How to Negotiate Successfully, Stress Management, Prioritization Management, Test Director – 2003, 2004, 2005

RBCD Campus Requisite Courses - Anti-Money Laundering, Privacy and Securities Lending 401 -2006, 2007

Learning Tree International - Certificate in MS Project Level 1 – 2008

Toronto College of Technology – Certificate in Mercury Quality Centre and SQL -2010

TD - Testing Methodologies Overview – 2012

TD – Employee Recognition for Reducing Service Interruptions – 2014

Participating in the Shoppers Drug Mart® OneWalk to Conquer Cancer benefiting Princess Margaret Cancer Centre – September 2015

LANGUAGES

Fluent in Italian - read, write and speak

Partially fluent in French and Spanish – read and write

Contact this candidate