Quality Assurance Project

Anthony Kong

****-** ***** **, *******, ON M*E*R* 647-***-****

**************@*******.***

Relevant Experience

Bell Canada

Business Systems Analyst - Business Intelligence (Consultant)

August 2014 - Present

. Prime focus on the implementation of Big Data Project Phase 2 and

encompassing new ingestion sources and operationalizing Phase 1 sources

. Elicited technical requirements for the Big Data Project from various

stakeholders to understand technical details and delta changes in

ingestion sources by documenting characteristics and ingestion data

types, leading to the validation of technical requirements and Use Cases

. Developed a Test Plan and Test Cases with various stakeholders on the BI

Business Team to track the cycles for Unit Test, Systems Integration

Testing (SIT) and User Acceptance Testing (UAT)

. Walkthrough of the System Requirement Specification (SRS) with the prime

and stakeholders across departments for sign-off

. Querying using Hive, Oracle, Teradata and Cloudera Impala to analyze

various sources of data pre and post ingestion

Scotiabank

Business Analyst - Business Intelligence

March 2011 - August 2014

Business-Side Application

. Assisted with reaching quarterly goals by analyzing trends in our

dashboard reports used to track forecasting by Leadership, leading to

positive feedback and praise for the team

. Setup dialogues between the Lync Team to identify improvements in the

data feeds provided, as well as enforced SLAs to ensure our technical

requirements were met and understanding various difficulties they

encountered, enabling us to adjust our timelines and deliver reports

without delay

. Documented discrepancies in the trend analysis and traced back to the

stakeholders for accountability in irregularities

. Collaborated with delegates from various business lines to extract

metrics and ensuring the data received was accurate for our IT Profile

Report

ETL/SSIS Development and Technical Analysis

. Understood the principles of ETL (Extract, Transform and Load) and how

the methodologies was implemented in our reports

. Partook in the maintenance of SSIS Scripts and Jobs with the use of SQL

Server BI Development Studio

. Developed reports using Cognos Report Studio used by leadership as

evidence of cost-savings overtime

. Use of SQL scripts to validate anomalies within the reports

. Executed ETL Jobs to maintain the system and refreshed various reports

in Cognos using SSIS (SQL Server Integrated Service)

. Developed test plans and test cases using HP/QC for Release Candidates

related to the system

Business Analyst - Consultant (Scotiabank)

Subject Matter Expert (SME)

. Tasked with the responsibility of managing "Demand and Capacity

Management" (DCM) system, had in-depth understanding of the needs of the

business and became the Subject Matter Expert (SME) with full autonomy

. Signed off on all business changes made to the system based on unique

knowledge of the business expectation and the expectation of how to

reflect the current organization structure

. Partook in conversations to resolve issues within our system, overcoming

changes in the business by setting up a new process and manipulating the

way the data was entering our system, leading to a reduction in

redundancy and higher level of accuracy in reporting

. Sat in on discussions as the Expert with other stakeholders to provide

expectations with new data feeds for DCM and that our Service Level

Agreements (SLA) was being met, allowing us to further prevent any data

loss

. Created detailed write-ups for the Senior Vice President outlining the

state of health each team was in and whether there was room for

improvement

Teaching and Mentoring

. Set-up seminars and 1-on-1 workshops to help Senior Managers and

Directors get hands-on training as well as building some understanding of

the concepts within the system, as well as scenarios where the tool can

be effective. This resulted in a 60% boost in usage over a sector of

approximately 2000 impacted users

Managing Resources

. Set up Conference calls with off-shore developers to identify issues in

the system changes made, overcoming communication barriers and about

business processes, leading to an of efficiency between the time a change

was requested and completed

Quality Assurance Analyst - Consultant (Scotiabank)

. Brought on to assist the team in completing an annual regression test of

the "Mortgage Centre of Expertise" project, was able to overcome a short

timeline and build a strong understanding of the requirements and the

expectations of testing, leading to a high daily test-case completion

rate

. Choice of tool to track testing was HP Quality Control (HP/QC)

Social Game Universe

Quality Assurance Analyst (Intern)

Jan 2011 to Mar 2011

. Use of Black Box Testing and Regression Testing in revisions for

different projects

. Quickly adapted to the nature of the Gaming Industry and

familiarized with the structure of the Agile Development Cycle.

. Developed tools to execute various forms of testing to identify the

various types of metrics

. Created Test Plans during testing phases and communicated the issues with

the development team

Education and Personal Development

York University

Bachelor of Arts in Information Technology and Management '13

Toronto, ON

(Originally set to graduate in 2011, became part-time student due to full-

time offer)

. Requirement Analysis - Ways to gather and translate all forms of

requirements

. System Design (SDLC) - Examined all forms of SDLC methodologies

(waterfall, Agile, Spiral) and best practice applications. Use of Use

Case Diagrams and UML

. Project Management (PMLC) - Examined PMLC best practices according to

PMBOK from PMI. Developed timelines using MS Project and MS Visio

. Database Design - Use of Schema, ERD, Physical Designs and normalization

to develop databases within

Oracle using SQL and PL/SQL

. Java Development - Understand and applications of OOP and methodologies

John Hopkins University (Coursera)

Specialization Certificate in Data Science

Dec 2014 to April 2015

. R Programming (Current)

. Data Cleansing (Future)

. Data Analysis (Future)

. Machine Learning (Future)

. Data Products (Future)

Learning Tree International

SQL Server Integrated Services for Business Intelligence

February 2014

. Course with the focus on Extractions, Transformations and Loads (ETL)

and how to develop database jobs using SSIS to be executed using SSMS

Technical Skills

. Java, Oracle, PL/SQL, Visual Basic, XHTML, ETL, SSMS, Cognos, HP/QC,

SSIS, Microsoft Visual Studio for BI Tools

. Advanced knowledge in Microsoft Office; Word, Excel, PowerPoint, Project,

Visio, Hive, Impala, Teradata, Python

Contact this candidate