System Analyst Sql Developer

Vladimir Tsinman

E-mail: *********@*****.*** ca.linkedin.com/in/vladimirtsinman Vaughan, ON cell ph. 416-***-****

QA/System Analyst Engineer with more than 8 years’ experience involving manual and automated testing, gathering, risk analysis, project planning, scheduling, testing, defect reporting. Proven ability to coordinate large-scale projects with a high degree of effectiveness. An outstanding, analytical, decision- making, problem solving, highly motivated, creative and diligent individual.

Technical Summary

Databases:

Oracle 11,12, SQL Developer, DynamoDB, DB2, MS Access

Operating systems and platform:

Unix/Linux, Windows XP, Windows 7, Sun/Solaris, HP-UX, AWS, Postman, Azure

Programming languages:

SQL/PL SQL, Unix Shell Scripting, C/C++, Cobol, Java Script, VBScript, Java/J2EE, XML, JSON

Third party software:

TOAD, Exceed, Rational Clear Quest, HP (QTP), Selenium, SSH, FileZilla, Putty, VPN/Secure Citrix, Jenkins, Visual Basic

SD Methodologies:

Agile, Scrum, Waterfall

Office tools:

MS Project, Visio, Power Point, Excel, UltraEdit, Acces

Testing and Bug tracking software:

HP ALM/QC, Test Director, Mercury Quality Centre, Rational RQM, Bugzilla, Jira, ETL tools, Hadoop

EMPLOYMENT HISTORY

Rogers 2016 – 2024

Senior QA analyst/lead (Vendor’s contract)

Creation and execution of functional, regression front end (Web, Mobile applications), back End including API tests; raising defects with HP ALM, Jira

Creation of automation scripts for Web and Desktop application projects by using QTP, Selenium tool, which significantly decrease testing time and help the company not to use different resources for testing purposes

Extensively creation and run SQL Query to extract and analyze data from various database tables. This allows fixes to several issues in an appropriate manner

Hadoop, ETL by using SQL testing

Testing AWS to Azure (with Databricks) migration

Rogers

Program/System analyst 2013 – 2015

Developed, debugged Code and root cause analysis by using “C”, “Cobol” programming languages, where new developed code extremely reduced application run timing process

Managed RQM defect, that successfully decreased defect’s time resolution

Analyzed data with running complex SQL queries, that significantly simplified tickets/incidents finding solution

Full 24/7 production support of Billing/Invoice applications, production tickets resolution by using UNIX and Windows platform tools. The support significantly increased SLA

Gathered appropriate information, reviewed log files, created and ran database queries, analyzed, researched, and troubleshoot reported issues, which helped to improve quality of bill calculation and presentation

Telus 2007 – 2012

Senior QA Tester / Team lead

By using Agile methodology created Plans, Test Cases for new/existing price plans and features by using Mercury Quality Centre and Excel. Tested Amdocs Ensemble and Enabler modules for Wireless Number Portability implementation, which resolved many billing issues

Lead onsite/offshore team to coordinate project resources, which increased efficiency of testing process

Executed UAT, Functional, IVR test cases with CSM and web-based commercial applications (E-care, Mercury, Apollo, SD) for subscriber’s activation. This avoided many front-end and back-end development errors

Created all types of binary, XML files for voice and data usage in order to provide testing inputs, that helped to cover all scenarios

Implemented manual and automated testing by using UNIX scripts and QTP for Telus domain GUI front-end application project, that was helped the company not to use different resources for testing purposes.

Quickly and efficiently resolved environment, usage issues by using UNIX command. Debugged and analyzed Root-cause, investigated log files for failures during processing, transactions, billing, and Interfaces, which has decreased other team investigation time

Amdocs 2005 - 2006

System Tester

Execution UAT, based on ETL (NM1 Data Migration project), functional, regression Test Cases for Amdocs Modules, eCare, WAC (web-based applications) and IVR application.

Analyzed Functional and Business requirements, develop test plan and test cases. Created various types of usage, modification BSI MAF files, ran MAF/MPS process, ran billing and validation of bill images

EDUCATION

Selenium IDE, Selenium WebDriver, Hadoop, Advanced SQL and Cobol courses

Polytechnic University.

Bachelor of Software engineering

Contact this candidate