SUMMARY

Mr. Cezar Zaharia is a QA Consultant with extensive experience in all stages of System Development Life Cycle including requirement definition, design, architecture, testing and support. His domain expertise include Financial Services, Telecommunications, Government Services, and Logistics and Inventory. Cezar has exceptional QA experience, from developing test strategies, test scripts, to test implementation and execution, test automation, back-end testing, and web testing. He is highly skilled at executing functional, integration, interface, and regression testing for large complex technology Infrastructures and software projects. Cezar is a goal oriented individual with exceptional communication, interpersonal and leadership skills.

PROFFESIONAL EXPERIENCE

Company

Position

Dates

Bell Canada

QA Lead

Nov 2015 – May 2016

Canadian Tire

QA Consultant

Feb 2015 – Oct 2015

QuickPlay Media

Technical QA

Mar 2014 – Sep 2014

RBC Investor Services

Senior QA Analyst

Feb 2012 – Nov 2012

Toronto Transit Commission

QA Lead

Dec 2007 – Dec 2011

IBM Canada

QA Lead/ Test Lead/ Senior Systems Analyst/ Test Coordinator

Feb 2001 – Dec 2007

University of Western Ontario

Research Engineer

Apr 1998 – Aug 2000

PROJECT HIGHLIGHTS

Bell Canada

QA Lead, Nov 2015 – May 2016

Project:

CIBC Enterprise Contact Centre Optimization (ECCO) program

•Designed test strategies for ECCO Historical Reporting Solution (HRPT) responsible for pulling out of Genesys and Verint telyephony related data and placing it into a data mart necessary to support reporting systems at CIBC

•Developed SQL scripts to validate the data loaded into Bell Consolidation Layer (mapping rules, source to target counts, data check, data constraints), a custom centralized data warehouse of the HRPT

•Tested ETL jobs within the Consolidation Layer

•Planned HRPT testing effort, implemented testing metrics, reported defects using HP ALM and prepared test status reports

Canadian Tire

QA Consultant, Feb 2015 – Oct 2015

Project:

Canadian Tire Flagship Homerun project

•Analysed user stories for the new Showcase store in Edmonton, web and mobile apps(Android), content management (Adobe CQ5)

•Created back end data validation test cases ande test scenarios

•Responsible for UAT test execution, test case development, test data creation, regression testing (Selenium IDE), end-to-end defect tracking (Jira Agile), test coverage, progress and status of execution reports

Quick Play Media

Technical QA, Mar 2014 – Sep 2014

Project:

Telus Optik on the go & SingTel “Hawk” project

•Analyzed project requirements and defined the test strategy for Telus Optik on the go project; a multiscreen video service utilizing QuickPlay’s managed service for TV-everywhere-express

•Reviewed Telus XML metadata feed files, verified content ingestion and different delivery use cases (first time, image/metadata update); provided the appropriate feedback to ensure that Telus AMS 2.0 content (SVOD and TVOD) integrate with QuickPlay’s Media Processor

•Sanity testing (Jira) for Rogers Anyplace Tv client application - Android Kitkat 4.2/4.4 devices

•Planned and implemented testing framework for the Discovery Layer (catalog browsing) functionality, and Open Video Console application (content management interface – Java based) for SingTel “Hawk” project; an end-to-end solution for a multi-screen video service utilizing QuickPlay’s managed service

•Deployed software builds to setup test environment, and developed data generation sql scripts required to execute functional test cases, implement test harness for SingTel Rest API testing

RBC Investor Services

Senior QA Analyst, Feb 2012 – Nov 2012

Project:

Enterprise Custody Program (ECP)

•Coordinated test activities with offshore testers for ECP project; an integrated custody solution using TCS BaNCS platform that included trades, safekeeping, entitlements and tax management

•Analyzed custody requirements for new reports, consolidation and rationalization of existing Crystal reports; created and executed the corresponding BI reporting test cases

•Developed test plans, regression test cases for various interfaces with BI/DW trading platform

•Wrote SQL queries for data validation across different data sources for ECP data warehouse

•Managed test cases, requirements and defects in HPQC, followed up on issue resolution, reported risks and execution status to management

Toronto Transit Commission (TTC)

QA Lead/ QA Analyst, Dec 2007 – Dec 2011

Project:

MMS system replacement (IFS implementation)

Role: QA Lead

•Coordinated the Functional, Integration and Performance testing of the Inventory workflows implemented within Industrial and Financial Systems ERP

•Created data migration test plan for the Inventory module based on data mapping requirements

•Developed SQL scripts to test Cognos BI reports and dashboards

•Prepared status reports, updated traceability matrix and record of test results documents

•Worked with SQL scripts to perform data transformation/manipulation testing and data quality/completeness validation for IFS system

•Created use cases required to test MS Office 2010 compatibility of IFS components, SharePoint and MS Excel custom application, due to upgrade from Microsoft Office 2003

•Developed integration test cases between IFS Inventory/Purchasing system and Accounts Payable, Vehicle Work Order, the GL, web applications, SharePoint forms etc.

•Prepared system testing artifacts such as configuration tests, security tests, recovery tests, load tests and performance tests for in-house built applications (inventory management)

Role QA Analyst – expert level

•Developed and executed test plans for IFS software customizations (Inventory, Purchasing, Accounts Payable), month-end/year-end financial reports and web applications

•Developed integration test plans for the Inventory Data Warehousing system

•Created and executed data migration test cases (IMS database to Oracle)

•Wrote SQL scripts for backend testing, test data creation and Cognos reports testing

•Analyzed, documented and tracked the issues associated with IFS customizations

•Developed and executed functional test cases for SharePoint documents (Inventory Request, Project Stock Material Requisition), and SharePoint integration into IFS based workflows

•Reviewed Business Requirements Definition (BRD), Data Models, and System Specification Documentation (consolidated design documents, customization specs) to maintain consistent and traceable software requirements

•Worked with BAs, SMEs and development team to facilitate defect resolution

IBM Canada

QA Lead/ Test Lead/ Senior Systems Analyst/ Test Coordinator

Feb 2001 – Dec 2007

Project:

TD Canada Trust - Witness Call Recording, QA Lead - (Apr 2007 – Dec 2007)

•Designed, implemented and documented quality assurance deliverables, including test strategies, test plans, test cases, test data (SQL) and test metrics reports using HPQC

•Used complex SQL, joins, aggregations, groupings, in backend and Cognos BI report testing

•Analyzed the IP telephony software-based Call Recording/Quality Monitoring, designed performance (LoadRunner) and security test cases for call recording/evaluation/archiving

•Participated in the Witness applications configuration for the UAT environment, provided recommendations on resources needed for testing and developed test data generation procedures

•Planned test releases, maintained test cases for centralized/local call recording in the Production Acceptance Testing environment (PAT/UAT), documented results and wrote problem reports

Bank of Montreal - Test Lead (Jun 2006 – Apr 2007)

•Developed test plan, test strategy, gap analysis and test environment for the new netCC Billing Solution project; the update of BMO’s GenericIVR system

•Performed functional, integration, and system testing for the SendBill process

•Responsible for data mapping and reasonability check test cases for the netCC Billing system

•Designed a SendBill process to report charge and payment information using DB2 APIs, developed performance testing scenarios and led integration testing activities for SendBill

•Coordinated with technical/business/system support project team leads to resolve issues

Bell MSP Platform - Senior Systems Analyst (Apr 2004 – May 2006)

•Designed and implemented IVR applications (DirectTalk), added enhancements, and wrote corresponding test cases for Operational Readiness Testing (ORT) - AIX Websphere Application Server/AIX environment, XML middleware and Oracle database

•Designed and implemented an Unix shell script to support the hourly transmission of Nuance voice recognition log files, and conducted performance testing of the metrics staging server

•Tested Unix shell scripts to validate various ETL jobs and the data loaded into target database

•Created, updated, scheduled and executed Unix shell scripts as part of the ETL process testing

•Performed and validated integration and function test cases to support the single number access strategy for different lines of business and Nuance speech recognition (310-Bell redesign)

•Created SQL scripts to generate test data for the Wireline Call Routing based on skill set

•Designed and implemented state table enhancements and new API functions (Java and C/C++) for the migration of the SSP application from the existing platform in Ottawa to MSP in Toronto

Ibm.com- Avaya CVuIS solution - Test Coordinator (Mar 2003 – Mar 2004)

•Analyzed the testing needs, developed testing strategy for Teleweb (Java EE web application), investigated technical issues and followed up with development team to resolve defects

•Worked with deployment team on Teleweb release/change implementation, planned regression testing, generated test data(SQL Server) and verified code fixes and enhancements

•Scheduled test activities and provided test progress reports for a CVuIS application for IBM Brazil that enabled clients to contact an agent by using the “Call Me/Text Chat” web form

IBM Solution Delivery Services Centre - Team Lead (Feb 2001 – Feb 2003)

•Developed the overall test strategy for Production and Distribution Inventory System (PDIS)

•Created SQL scripts to verify source tables, staging tables and destination tables for ETL jobs that processed customer orders using data mapping specifications

•Responsible for PDIS documentation (Maintenance Plan, Configuration Management Plan, Monthly Status Report), traceability matrix, test plans, test procedures, assigning issues to team members, and creation of the design specifications for program modifications.

•Created the Decommission Plan, and coordinated the activities required to sunset PDIS system

University of Western Ontario

Research Engineer, Advanced Communication Engineering at UWO

Apr 1998 – Aug 2000

Responsabilities:

•Designed and performed experiments to test the performance of video stream applications over the Internet; analyzed the sequence of video frames generated with a modified version of Vic conferencing tool to observe packet loss and delays of real-time video traffic

•Configured the IP multicast environment (mrouter, MBone connection, application software for Unix and NT machines, monitoring tools); designed performance test scenarios and researched techniques designed for QoS management of real-time multicast over the Internet

TECHNICAL PROFICIENCIES

Technology

Tools

Operating Systems

Unix (AIX, Solaris, Linux), OS/2, MVS, DOS, Android 4.2/4.4, iOS 6.x/7.x, BlackBerry 7.1 OS, Windows 9x/2000/XP/Vista/Win7/, Apache Solr, Java EE, WebSphere, Citrix, VMWare, MS SharePoint, Windows NT/2000/2003/2008

Development Languages

C++, Java, VB, .Net Framework, Cobol, Korn Shell, Awk, PL-SQL, T-SQL, HTML, XML

Databases

DB2 7.1, Oracle 10g/11g, SQL Server 2008, IMS, Access 2000, Teradata

ETL

Datastage

Web

HTML, XML, WSDL, SOAP, CSS, Java Script, Flash, ASP, Tomcat, IIS 7.0, Oracle Weblogic 11g, WAS 5.1

Testing Tools

HP Quality Center, HP QuickTest Professional, Rational ClearQuest, LoadRunner, Selenium IDE, TrackRecord, QARun, Jira, Confluence, Rally

Telecom

Avaya CVuIS, DirectTalk 6000, Apropos, Nuance, Cisco IP Telephony, Genesys, Verint, VoIP, PBX, Cisco IP phones, Cisco CallManager

EDUCATION

Master’s Degree, Electrical and Computer Engineering - University of Western Ontario

Bachelor’s Degree, Computer and Control Engineering - University 'Gh. Asachi' of Iasi, Romania

CSTB/ISTQB Software Testing Certification

Contact this candidate