Olga Shukhmeister
** ****** **., *********, **, L4J 9E9
Cell: 647-***-****
acy8f0@r.postjobfree.com
Objective: Software Quality Assurance Specialist
PROFESSIONAL PROFILE
10+ years of varied experience in IT field focusing on Quality Assurance and Software Testing
Working experience with System Integration, Functional and Non-Functional Testing (Security, Performance, Regression, Stress, Compatibility) on large (ERP system, Trading Platform, Data Warehouse) and other projects (Client-Server and multi-tier Web-based applications)
Deep understanding of SDLC (Waterfall, Agile, Scrum), and Software Quality Assurance ( testing standards, methodologies /techniques, and data modeling)
Experience in developing Test Documentation: Test Plans, Test Cases, Bug Reports and Traceability Matrix
Extensive experience working with defect tracking tools: HP QC, Jira, FogBugz
Strong background in the area of information management, data mining, data warehousing and data processing
Substantial SQL experience in Data Warehouse, ETL, and back-end testing for data validation
Knowledge of Trading platforms, Capital Markets and Wealth Management products
Experience with automated testing tools and software development tools
Self-motivator and quick learner. Proven ability to handle multiple demands and competing priorities
Strong work ethics - focused, dedicated, loyal and committed - willing to do what is right and what is required
TECHNICAL PROFILE
RDBMS
MS SQL Server 2005/2008/2012, Oracle 9i-11g, MS Access 2003/2007/2010
Defect Tracking Tools
HP QC, JIRA, FogBugz
Programming Language
SQL, PL/SQL, Visual Basic, HTML, XML, Java, JavaScript, VBScript, SPSS, SAS
MS Office Tools
MS Word, Excel, PowerPoint, Outlook, Visio
Operating Systems
Windows NT/2000/XP/Vista/7/8/10,Unix/Linux
Automation Tools
Selenium, HP QTP
PROFESSIONAL EXPERIENCE
Ralota Technologies Inc., Toronto, ON September 2013 – Present
QA Analyst
Ralota is a global management services company specializing in the finance and technology sectors. Ralota develops Custom Software solutions which provide its customers with Direct Market Access to over 10 major markets around the world.
Creating Test Cases and Test Plans according to business specifications
Executing Functional, Regression, Stress and User Acceptance Testing of in-house Trading platforms
Working with Direct Market Access, high frequency trading, regulatory reporting, order matching and market simulation
Analyzing FIX protocol messages to track trade communication and troubleshoot trading outages
Using FogBugz bug tracking system for logging and managing defects
Running automated tests developed in an in-house test automation harness
Involved in customer release support and trading floor support
Performing backend database testing using MySQL
Interaction as a liaison between BA, QA and development teams to understand and document requirements related to user specifications
Olga Shukhmeister Cell: 647-***-**** page 2/3
Provided defects analysis, collaborated with development team to resolve issues, re-tested after fix and performed Regression test
Working in environment driven by Agile software development approach
Technical environment
Windows 7/8, MS SQL, MySQL, MS Office, UNIX, HTML 5
Bazan Group Oil Refineries Ltd, Israel September 2009 - May 2013
Sr. QA Analyst
Israel's largest Oil Refinery, providing a variety of products used in industrial operation, transportation, private consumption, agriculture and infrastructures
Extensively worked with the Business Analysts in understanding the requirements
Produced and maintained QA documentation for the project, prepared test plans, executed test cases, created test execution, test completion and defect status reports
Analyzed the business process workflows, mapped documents indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
Involved in extensive DATA validation using SQL queries and back-end testing
Developed ETL test scripts based on Data Design Documents
Performed data validation and data integrity testing for flat files (counts, duplicates, NULL values, orphans)
Tested complex ETL mappings and reusable transformations for daily data loads
Performed back-end database testing against Oracle 10g, developed complex SQL queries during End-to-End testing for CRM, Billing, and ERP solutions
Executed and modified automated scripts according to functional changes for regression testing on HP QTP, analyzed automation run variations
Technical environment
Windows 7/8, Informatica 8.6-9.5, ETL Tools, HP QC/ALM, TOAD, Oracle PL/SQL, MS SQL Server, MS Office
Bateman Litwin, Israel February 2006 - August 2009
QA Analyst/ Data Analyst
A worldwide supplier of advanced technologies, products, and engineering services for the metals and mining & minerals industries
Created QA documentation package, including test plan, test cases and traceability matrix
Worked closely with R&D teams including developers and business analysts
Performed following types of testing: Hardware, Integration, Functional, Regression, UAT, Black Box and Front/Back End
Managed test documentation and reported defects in HP Quality Center
Designed and manipulated data using SQL queries
Programmed in MS Office environment (VBA)
Participated in development of front end templates for data analysis and statistical data summary representation for department heads, senior management and external clients based on business requirements
Technical environment
Win XP/Vista, MS Office, SQL Server 2005, MS Access 2000, VBA, HP QC/ALM
Olga Shukhmeister Cell: 647-***-**** page 3/3
Midgam Research & Consulting, Israel May 1999 - February 2006
Data Analyst/ SQL Developer
Database – database design, implementation and administration with MS SQL Server
Developed, and modified MS Access database including forms, reports, tables, and queries
Administrated database processes to identify presence of errors and technical flaws
Developed and maintained a web based application in HTML, JavaScript, VBScript
Performed code reviews, corrected errors by making appropriate changes
Tested, detected problem and improved existing database
Managed, updated and manipulated data base structure and reports with the use of advanced
MS Excel functions
Generated weekly, monthly, and quarterly reports
Collected analysed, interpreted data and presented to management
EDUCATION
MS SQL Server 2005 Development Course, Hi-Tech College, Israel 2008
Trading on the stock and futures markets Course, Israel 2008
Computer Science Diploma, Technion, Israel 1996 - 1999