Guy Flig Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Utilized Cassandra and SQL Server in SQL scripts for validating Extract Transform Load (ETL) process based on the Source To Target (STM) mapping. Trading data from various source systems along with reference and static data was pulled, transformed and enriched based on the defined mapping rules and ended up in regulatory reports.• Performed regression testing by automating Ant and SQL scripts using Jenkins.• Validated proper transmission and content of JSON files.• Responsibilities included all aspects of test planning, test case development and test case execution.• Compiled, analyzed and reported test results using Jira.• Conducted defect triage meetings.

Toronto, Ontario, Canada

• Responsibilities included all aspects of test planning, test case development and test case execution.• Utilized Oracle and Netezza in extensive SQL scripts for testing DataStage jobs based on the Source To Target (STM) mapping as part of Extract Transform Load (ETL) process for EDW initiatives.• Compiled, analyzed and reported test results using the HP ALM.• Conducted defect triage meetings.• Validated Cognos reports as well as daily push email reports against Business Stories.

Toronto, Ontario, Canada

• Carried out quality assurance activities for all aspects of test planning, test case development and test case execution.• Compiled, analyzed and reported test results using the HP Quality Center (HPQC). • Utilized DB2 in extensive SQL scripts for testing Informatica jobs based on the Source To Target (STM) mapping as part of ETL (Extract Transform Load) process for BIDW initiatives.• Validated the Health Watch New Generation (HWNG) pharmacy system’s functionality as well as its integration and synchronization with Merchandise Management System (MMS) responsible for inventory maintenance.• Validated appropriate functionality of Point of Sale (POS) consisting of two types of Cash Registers (IBM and NCR) in conjunction with HWNG and MMS.• Used Informix database and various VB Macros in Excel in system testing verifications.• Tested the Interactive Voice Response (IVR) and WebRefill systems connected to HWNG. Both systems allow patients refilling prescriptions over the phone or on the Web.• Verified proper adjudication between HWNG and Third Party Insurance Companies for eligible patients.• Tested correct integration between HWNG and several types of Dispensing Robots (Baker Cell and ScriptPro).

Toronto, Ontario, Canada

• Carried out quality assurance activities for all aspects of test planning, test case development and test case execution.• Compiled, analyzed and reported test results using Gemini (web based defect tracking tool).• Developed VB Macros for validating final results against the expected ones.• Tested the integration between the iMIS and the Membership and Certification modules.• Participated in SIT and UAT test phases.

Toronto, Ontario, Canada

• Responsibilities included all aspects of test planning, test case development and test case execution.• Compiled, analyzed and reported test results using the HP Quality Center (MQC) and MKS.• Participated in SIT, BAT and UAT test phases. Assisted Business Users to carry out PIV test phase.• Reviewed design specifications and business requirements for completeness and adherence to business needs.• Developed VB Macros for validating final results against the expected ones.• Utilized SQL Server, Sybase and Oracle in system testing verifications.• Verified Value at Risk (VaR) and Profits and Losses (P&L) for various portfolios using different financial instruments.• Tested Web-based Client Profitability Model dealing with such clients’ aspects as Financial Summary, Income and Revenue Statements, Rankings, Credit Ratings.

Toronto, Ontario, Canada

• Responsibilities included all aspects of test planning, test case development and test case execution.• Compiled, analyzed and reported test results using the HP Quality Center (MQC).• Participated in SIT, BAT and UAT test phases. Assisted Business Users to carry out PIV test phase.• Reviewed design specifications and business requirements for completeness and adherence to business needs.• Utilized SQL Server, Sybase and Oracle in system testing verifications.• Tested Web-based applications for capturing Specific Allowances.• Validated ETL (Extract Transform Load) process utilizing complex SQL scripts on SQL Server.

Tel Aviv, Israel

• Created and implemented test suites for Enterprise Resource Planning (ERP), Human Resources (HR), Customer Relationship Management (CRM), Inventory Management systems for National Service Project.• Tested “Web based Work Order forwarding” project for Transportation Company (Egged). • Carried out quality assurance activities for Online Financial Channel (OFC) to Tel-Aviv Stock Exchange provided by Bank Leumi to its customers. This service granted direct access to stock exchange market and supplied in-depth financial analysis for various stock market aspects and allowed financial operations such as buying-selling of stocks, bonds and other bank products such as mutual funds, etc.• Designed and developed scripts for monitoring and filtering log files.• Provided intrusion detection testing.• Responsibilities included all aspects of test planning, test case development and test execution.• Created tools for coverage analysis providing a consistent, repeatable process for gathering requirements, planning and scheduling tests, analyzing results, and defect management process.• Designed and implemented unit testing for various ASP / ASP.NET projects based on SQL Server 2000 databases involving photo and digital imaging file sharing, digital printing applications, video chat, SMS management, online marketing automation channel and electronic catalogs with e-commerce elements and other development systems.• Developed mitigation strategy and risk analysis. • Created test plans for unit and system testing.

Tel Aviv, Israel

• Tested numerous applications for real time wireless technology for mobile devices such as employee time tracking, inventory availability and inventory ordering, urgent delivery information and priority updates. • Utilized ColdFusion and SQL Server 2000 for the back end testing of client-server wireless applications for WAP devices.• Created and implemented scripts for monitoring and analyzing log files as well as unit and system testing.

Tel Aviv, Israel

Herzliyya, Tel Aviv, Israel