Customer Service System
Resume:
Vyacheslav ( Slava ) Pechersky
North York, M2M 1P1
Tel. 416-***-****
Cell 416-***-****
E-mail ********@*****.***
Professional skills
Languages SQL, PL/SQL, KornShell, Java, C/C++, VBScript, Perl,
Awk, BTEQ, HTML, XML, COBOL, SAS
Software SAP BODS, Informatica, Oracle Browser, Toad, SQLPlus,
SQL Assistant, DB Visualizer, PVCS, MKS, JIRA, HP QC, QTP,
PeopleSoft, Endevor, ZEKE, Control-M, CA-7, MS Office
Methodology Agile, Waterfall, RUP
Databases Oracle, DB2, Teradata, SQL Server, Informix, MS Access, IMS
Systems AIX, Sun Solaris, HP-UX, Windows NT/2000/2003/XP, MVS, z/OS,
Hardware IBM PC, HP, Sun SPARC, RS6000, IBM 390
Summary
Extensive quality assurance experience.
Extensive experience in Data warehouse testing.
Extensive experience in testing of batch applications on Unix platform.
Extensive experience in testing web-based applications.
Extensive experience in testing mainframe applications.
Extensive experience in writing of SQL and PL/SQL complex scripts.
Strong experience with testing methodology, test strategy and planning.
Excellent analytical and problem solving abilities.
Ability to communicate effectively with both technical and business staff.
Capable to work independently within a dynamic team,
organize time among multiple tasks.
Excellent organizational, written and verbal skills.
Work experience
2015,January – 2015, December Senior QA Analyst Canadian Tire (contract)
Worked on the Finance BI projects. The objective of this projects was to design and implement a central consolidated Business Intelligence platform for the disparate data sources.
Reviewed business and technical requirements to provide full coverage testing;
Set up test environment, prepared test cases and corresponding SQL scripts
for IA to Landing, Landing to Staging and Staging to Data Mart testing; These scripts
included date, landing ID, counts and lookup validation and full record set comparison;
Worked with the development team to ensure adequate tests are being created;
Executed staging and mart jobs from ESP scheduler;
Wrote complex Korn Shell scripts allowing to simplify IA to Landing testing for a large files
Prepared VB script to automate IA to Landing testing with XML source files;
Modified the procedure for testing of type 2 table;
Effectively participated in QA status meetings;
Documented test results, filled defect reports and enhancement requests in HP QC;
Technology: Netezza, Oracle, DB Visualizer, Toad, Kornshell, Awk, SQL, HP QC, Excel,
z/OS, ESP, Windows XP, AIX, Linux
2013, June – 2015, January Senior QA Analyst Everlink Payment (contract)
Worked on the Master Card Settlement project allowing finance easier to reconcile CUCC, Everlink and Master Card nodes data for ATM and POS transactions.
Set up test environment, prepared test plan, test scripts and data for unit, regression, system integration and UAT testing;
Performed system integration and UAT testing for the modified ETL batch components processing Master Card ATM and POS transactions on HP Unix system.
Performed functional and system testing for ETL jobs corresponding to a very complex interfaces;
Performed regression, system integration and user acceptance testing for the batch programs producing compare reports.
Wrote Kornshell scripts allowing to automate regression testing.
Collaborated with developers and business analysts in the analysis of different reports comparing data in CUCC, Everlink and Master Card nodes.
Documented test results, filled defect reports and enhancement requests;
Effectively participated in QA status meetings;
Coordinated promotion of the batch jobs to QA with Source Control Admin team.
Provided Unix training for other testers.
Technology: Kornshell, Oracle, SQL, PL/SQL, HP-UX, Syncsort, AIX, DB2, MF Cobol,
Informatica, PVCS, HP QC, Excel
2013, February – 2013, June Senior QA Analyst Capgemini (contract)
Worked on the No Bills Apllication Maintenance project for Hydro One Customer Service Data Warehouse System (CSS). The system permitted Hydro One to bill the customer for electric, lighting and other services based on the energy consumption, charge types and retailer enrollment information.
Performed data fix and unit testing for the back end components of the Customer Service Data Warehouse System.
Performed regression, system integration and user acceptance testing for the front and back end applications related to the Billing system of CSS.
Wrote complex SQL and PL/SQL scripts validating Billing system.
Collaborated with business analysts in the analysis of test results related to billing applications.
Documented test results, filled defect reports and enhancement requests in Sir Workbench.
Provided mentoring and training for new testers.
Technology: Kornshell, Awk, C, Oracle, SQL, PL/SQL, HP-UX, Syncsort, PVCS,
HP QC, Visio, MS Office, MVS, TSO/ISPF, DB2, JCL, Endevor, SPUFI
2012, May – 2013, February Senior QA Analyst Teradata (contract)
Participated in the Enterprise wide Data Management implementation designed to leverage SAP data across all stores and distribution centers of Loblaw Corporation. Worked on Track 3 and Track 4 phases of the project related to extracting, transforming and loading of the SAP data to Teradata and Oracle Warehouse.
Reviewed the requirements for each phase and produced test plan to provide full coverage testing;
Set up test environments, prepared test plans, test scripts, traceability matrix and data files for functional unit testing (FUT) of different business process areas.;
Worked with the development team to ensure adequate unit tests are being created;
Performed unit testing of BTEQ scripts executed for initial load of different core Teradata tables;
Performed functional unit testing for BODS jobs corresponding to a very complex interfaces;
This testing included assembly, extractor, etl, transactional and data correctness testing.
Debugged landing and core BODS jobs to identify defects and reasons of failure;
Analyzed defects occurred in the BODS jobs executed by system integration testing team and made recommendations on how to fix it;
Documented test scripts, test results and defect reports in HP QC;
Effectively participated in QA status meetings;
Provided mentoring and Unix training for other testers.
Technology: Teradata, SQL Assistant, SAP BODS, BTEQ, Kornshell, Awk, SQL,
PeopleSoft, Oracle, HP QC, IBM RTC, Excel, Windows XP, AIX
2010, November – 2012, May Senior QA Analyst, Hudson’s Bay (contract)
Worked on the maintenance project for the Retek supply chain data warehouse system .
Performed automated testing and support for all components of the Retek system implemented on the Unix and mainframe platform;
Set up test environment, prepared test plan, test scripts and data for unit, regression, system integration and UAT testing;
Performed unit testing of complex ETL jobs extracting, transforming and loading data from different interfaces of the Retek Data Warehouse;
Run batch jobs and automated the process validating output files and database changes.
Documented test results and track defects to closure;
Assisted to development team in resolution of the Retek defect issues;
Produced ad-hoc business reports on the regular bases.
Technology: Kornshell, Awk, Toad, PL/SQL, Pro*C, HP-UX, PVCS, Cobol, DB2,
TSO/ISPF, JCL, File Aid, z/OS, Endevor, SAS, Informatica, HP QC
2009, November – 2010, November Senior QA Analyst, London Life Insurance (contract)
Worked on the Harmonized Sales Taxes (HST) and Address CleanUp projects for the London Life Global Retirement System (GRS). These projects were initiated in response to the provincial tax change which is impacted to the Investment Management Fees (IMF).
Reviewed technical requirements for HST and Address CleanUp projects and created test cases;
Performed functional, system integration and regression testing for the Global Pension web applications related to HST and Address Cleanup projects;
Performed performance and usability testing for web applications related to the Grandfathering fund project;
Set up test environment, prepared test plan and completed functional and regression
testing for business methods related to HST and Address Cleanup projects;
Collaborated with business analysts in the analysis of test results related to
Global Pension applications for HST and Address Cleanup projects;
Created automated test scripts to enable regression testing;
Conducted regression testing using automated scripts;
Collaborated with a development team to resolve defect issues in a new business
methods corresponding to HST project;
Documented test scripts, test results and filled defect reports in HP QC;
Provided mentoring and HP QC training for other testers.
Technology: SQL, PL/SQL, Pro*C, Kornshell, Awk, XML, Toad, AIX, PVCS, HP QC
2006, November – 2009, November QA Technical Lead, LCBO (contract)
Worked on the large Traffic Migration project that is composed of the conversion and porting from the mainframe to Unix for different business functional areas. The LCBO Traffic Data Warehouse System serves as a repository of information regarding the movement of Import and North American cargo containers.
Reviewed technical and business requirements documentation for each testing phase and created test cases to provide full coverage testing for batch and web components of Traffic applications;.
Set up test environment, prepared functional, regression and UAT test plans and test scripts and made testing for both batch and web Traffic applications;
Performed functional, regression, system integration and UAT testing for Logistics
batch and web applications;
Worked with Data Migration team to coordinate access to data migrated from appropriate test environments and cycles;
Prepared complex SQL queries validating data migration processes.
Collaborated with business analysts in the analysis of test results related to Customs and Traffic applications;
Collaborated with a development team to resolve defect issues;
Coordinated promotion of the Traffic jobs to QA and Production with Source Control Admin team and Scheduler Admin team;
Documented test results, filled defect reports and enhancement requests;
Prepared complete documentation related to the Traffic applications for Production Support team;
Transferred skills and knowledge to other testers and users.
Technology: SQL, PL/SQL, Cobol, Kornshell, Perl, HP-UX, AIX, MVS, DB2, Oracle,
PeopleSoft, HP QC, PVCS, TSO/ISPF, JCL, CICS
2006, July – 2006, November Senior IT Consultant, Scotia Bank (contract)
Worked on the Job Code and Pay Level conversions (JCC and PLC) for the Human Resources System of Scotia Bank.
Reviewed technical documentation for each testing phase and created test cases to provide full coverage testing for the Human Resources applications;
Performed enhancement, unit and SIT testing for Human Resources batch applications related to Job Code and Pay Level conversions Project (JCC and PLC);
Performed enhancement, unit and SITtesting for batch cash applications related to Base Salary Adjustment Program (BSA);
Set up test environment, prepared unit and SIT test plan, test scripts and made testing for JCC, PLC and cash programs;
Collaborated with a development team to resolve defect issues;
Collaborated with business analysts in the analysis of test results related to Cash applications;
Documented test results and defect reports in the HP Quality Centre;
Produced ad-hoc business reports on the regular bases.
Technology: Cobol, DB2, AIX, Kornshell, Awk, SQL, PVCS, HP QC
2005, November - 2006, July Senior QA Engineer NCR Teradata (contract)
Participated in the large scale Enterprise Data Warehouse system implementation for Toy ”S” Us.
The system was built based on the Teradata Demand Change Management application suite. It’s included allocation, capacity planning, maintenance, forecasting and replenishment business functions.
Reviewed technical and business documentation for DCM applications
and created test cases;
Set up test environment and prepared UAT test plans and automated test scripts related to maintenance and capacity planning applications;
Performed system integration, regression and user acceptance testing for allocation and maintenance programs;
Prepared complex SQL queries validating allocation, capacity planning, forecast and replenishment applications.
Collaborated with business analysts in the analysis of test results related to allocation and capacity planning applications;
Documented test results and track defects to closure.
Technology: C, SQL, Kornshell, AWK, BTEQ, Teradata, Toad,
AIX, MPRAS, Test Director
2005, May – 2005, November Senior QA Analyst, Hudson’s Bay (contract)
Worked on the LID project related to the Retek data warehouse system modifications. The scope of the project was to provide Bay, Home Outfitters and Designer Depot stores with the same functionality as is currently available in Zellers stores.
Reviewed technical and business documentation for LID project and created test cases;
Performed enhancement, maintenance, testing and support for all components of the Retek system implemented on the Unix and Mainframe platform;
Performed unit testing of complex ETL jobs extracting, transforming and loading data from different interfaces of the Retek Data Warehouse;
Prepared test scripts and data for unit, regression, system integration and UAT testing.
Documented test results and track defects to closure;
Produced ad-hoc business reports on the regular bases;
Provided mentoring and training for production support team and junior testers.
Technology: Test Director, Informatica, Pro*C, Kornshell, SQL, PL/SQL, Oracle,
Toad, HP-UX, MKS
2003, April – 2005, May Senior QA Analyst, Capgemini (temporary)
Worked on the large scale Apllication Maintenance project for Hydro One Customer Service Data Warehouse System (CSS). The system permitted Hydro One to bill the customer for electric, lighting and other services based on the energy consumption, charge types and retailer enrollment information.
Performed support and testing for the front and back end components of the Customer Service System.
Performed regression, system integration and user acceptance testing for the front and back end applications related to the Payment system of CSS.
Prepared test plan and created test scripts related to back end applications during MPMR Rebate project. Successfully completed unit, system integration, regression and user acceptance testing assignments in the project.
Collaborated with business analysts in the analysis of test results related to MPMR Rebate applications.
Documented test results, filled defect reports and enhancement requests.
Provided daytime and nighttime PTST and Production support on the rotation base.
Provided PTST support mentoring and training for other testers.
Technology: Cobol, CICS, TSO/ISPF, DB2, MVS/JCL, File Aid, DFSort, REXX, SPUFI/SQL,
Kornshell, Oracle, SQL HP-UX
2002, May – 2003, April Senior QA Analyst, Ministry of Community and Social
Services (contract)
Participated in the Application Maintenance Project for Service Delivery Model Technology
This system was designed for the management and delivery Ontario Works (OW) and Ontario Disability Support Program (ODSP) services.
Reviewed technical and business documentation for SDMT applications and created test cases;
Performed maintenance and testing of the on-line and back end components of the SDMT.
Wrote and executed unit test scripts for batch processes. Reviewed unit test results and confirmed results to the corresponding Detail Design documents. These processes generated business reports (PTST) based on business requirements;
Wrote and executed assembly test scripts for changes made to SDMT back end applications.
Performed test variance correction and re-test as required;
Supported user acceptance and regression testing and resolved test variances as required.
Collaborated with a development team to resolve defect issues;
Documented test results and defect reports in SIR Workbench.
Technology: SQL, Cobol, CICS, TSO/ISPF, DB2, JCL, z/OS, PVCS
2000,August – 2002, May Senior QA Analyst, Hydro One (contract)
Worked on the large scale Market Ready project for Hydro One Customer Service Data Warehouse System (CSS). The system permitted Hydro One to bill the customer for electric, lighting and other services based on the energy consumption, charge types and retailer enrollment information.
Reviewed technical and business documentation and created test cases;
Prepared test plans, created test scripts and data for testing of Core Billing System.
Performed system integration and user acceptance testing for this system.
The system permitted Hydro One to bill the customer for electric and lighting services;
Performed regression, system integration and user acceptance testing of the changes on the Payment system of CSS implemented during Market Ready project;
Coordinated testing for the Retailer Enrollment system;
Performed system integration and user acceptance testing for this system;
Monitored the progress of the tasks and prepared reports for the management;
Performed regression, system integration and user acceptance testing for these applications.
Documented test results, filled defect reports and enhancement requests;
Coordinated promotion of the Billing jobs to PTST and Production with Source Control Admin team;
Produced ad-hoc business report on the regular bases.
Technology: Kornshell, Oracle,SQL, C++, HP-UX, Oracle, Windows 2000,
Cobol, CICS, TSO/ISPF, DB2, MVS/JCL, File Aid, ZEKE
1998, September – 2000, July QA Analyst Purolator Courier (contract)
Worked on the large conversion project for the Service Directory data warehouse system. This system contains information related to locations serviced by Purolator Courier.
Participated in the migration of Service Directory applications from MVS to UNIX platform.
Solved numerous performance problems for Global Courier System by redesigning and rewriting back end applications.
Performed enhancement, maintenance, support and testing for Service Directory and made it year 2000 compliant.
Performed unit, regression and system integration testing for Service Directory applications, provided support for user acceptance testing.
Wrote Kornshell scripts and storage procedures to produce special business reports as
requested by the client.
Provided mentoring and training for junior staff and users.
Provided nighttime Production support on the rotation base..
Technology: Cobol, SQL, Kornshell, HP-UX, Informix, HTML, XML, MKS
1997, April -1998, September Programmer Analyst Fidelity Investments,
Toronto (contract)
Worked on the project for the Global Pension Plan Recordkeeping System (GPRS). The system was designed to enable Fidelity Investments to service and provide information that will retain and attract Group Savings Administration business.
Performed enhancement, maintenance, support and testing for the GPRS system and made this system year 2000 compliant;
Produced ad -hoc business reports (KornShell script, SQL, DB2 and Excel).
Created Detail Technical Design Documents for Technical SIRs.
Wrote Kornshell scripts to automate regression and system integration testing;
Provided nighttime Production support on the rotation base.
Technology : Kornshell, Microfocus Cobol, C, SQL, AIX, DB2, CICS, Syncsort,
Control-M, PVCS, MS Office
Education: M.Sc. In Physics, Tadjik State University, USSR
References available upon request
Contact this candidate