Quality Assurance Analyst

Sandra Cerilli

ca.linkedin.com/in/sandracerilli ********@******.*** 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/Zephyr, 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)

●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), Appian (Unifide platform), Broadridge (Dataphile), Doxim and Docusign

●MS Project and MS Office Application – Excel and Sharepoint

CAREER EXPERIENCE

Fidelity Clearing Canada May 2022 – December 2024

Quality Assurance Analyst (Contractor)

●Successful completion of monthly releases. Test creation, execution and defect management using JIRA/Zephyr in SIT environments. Facilitate Regression testing in UAT.

●Participated in grooming Stories for upcoming release.

●Projects – uOpen (Unifide) and KYC

FD Technologies February 2022 – May 2022

Quality Assurance Analyst

●Project testing of Independent Electricity System Operator (IESO).

●Using TFS and Zephyr, created manual test cases, executed test cases and reported defects.

Broadridge Financial Solutions October 2018 – February 2022

Quality Assurance Analyst

●Successful ongoing maintenance of all Registered Products, Book Cost and Representative Compensation systems in QA and Production regions

●Perform and successfully maintain “Turnover” (QA to Production) weekend Sanity Testing and Regression Testing

●Run and successfully maintain 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