Janar Yermekbayeva Page*

J ANAR Y E R M E K B A Y E V A

Texas Area, USA

607-***-**-** adj7cm@r.postjobfree.com https://www.linkedin.com/in/janar-omar-7017711a3/

Authorized to work in the US

CAREER OBJECTIVE

As Software Test Specialist that allows me to develop and utilize my wide-ranging analytical, IT knowledge and skills while applying my valuable experience to solve complex problems in a dynamically challenging environment. I am focusing to contribute at Texas IT Industry.

PROFESSIONAL SUMMARY

• Strong knowledge of Software Developing Life Cycle, Software Testing Life Cycle.

• Good understanding of web applications architecture and data formats like JSON, XML, HTML, CSS

• Firm experience in manual Testing

• Ability to derive test scenarios from user stories and use cases

• Good experience in creating and developing the documentation of Automation Framework

• Proven experience in establishing the in-depth documentation of real and conceptual structure of automation framework which provides support and guidance to the QA team

• Solid understanding of Relational and Object-Oriented Database Design, proficient in writing SQL queries for further performing Back-end testing of application using JDBC library in Java

• Highly organized, systematic and adaptable with an excellent attention to detail, with the ability to recognize the relative importance of software issues and to prioritize work effectively

• Ability to work with all members of a software project development team and customers, in a professional and yet dynamic and creative environment, fostering an open, friendly and constructive working relationship with all members of the team

• Proven ability in writing complex SQL queries with multiple joins to compare data extracts from source to target databases for migrations test automation.

• Extensive knowledge on Database System, SAS (Accessing Data, Manipulation, using SQL, Prepared Reports, Combining Data)

• Strong experience in automation ETL and Migrations, firm understanding ETL Workflows.

• Understanding key concepts of Cloud Service Providers

• Excellent Communication skills, Quickly Learning, Team problem solving ability, Analytical skills, and Management skills

TECHNICAL EXPERIENCE

Programming Languages R, Python, C++, SQL

Testing Tools

Selenium, Scrum, Standards, frameworks, ISO, IEC,

OSSTMM (Testing Methodology Manual), Use

Guides, Use Cases, Error Messages

Statistical Analysis and DBMS Tools

RStudio, SAS, Spreadsheets with Microsoft Excel,

Kaggle, Power BI, MS SQL Server, MS Access

General Computer Knowledge

MS Office, HTML. Data Visualization, Presentation, IT Service Desk, (MS Word, Excel, Outlook, Power

Point- Badge Skills LinkedIn)

Language (Translator) Russian, Kazakh-Fluent

Janar Yermekbayeva Page2

PROFESSIONAL EXPERIENCE

Test Data Entry with Inventory Market data, Sodexo Inc. Aug 2019-March 2020

(After immigration in USA, May 2019)

Sodexo Inc. in the State University of New York at Binghamton, NY, USA, Vestal, NY

• Monitor price processes weekly with Ariba Spend Management (IBM) system

• Utilize Sodexo’s Web-Based e-Procurement System for the daily input 250 records

• Prepared inventory data in Real Time Mode, Web-Based Database System

• Generate reports in Excel

• Applying local software, Manual Testing, export/import data

• Calculated, rounded new price values, and Verifies Data Entered Database to ensure accuracy.

• Write documentation to describe logic, design, coding, corrections testing of computer programs.

• Clerical and Manager Assistant Duties.

In Education Area Mentoring Software Developing Life Cycle Tools Trainer IT courses at Department of System Analysis and Control, The Eurasian National University Kazakhstan 2014-2019

• Taught the following undergraduate/graduate courses: Life Cycle Tools in IT, Introduction/ Advanced C++ Programming, R Programming, Database Management System, Digital Signal Processing, Control System Tools,in English / Kazakh / Russian.

• Coordinated more than 20 groups and individual projects for students, guided them toward understanding complex concepts.

• Prepared Programming exercises and explained them to students. QA Test Specialist, Omar Lab Ltd, HealthCare 2010-2013

• Monitor, maintain, and provide reports for defect resolution to the team and IT management and to assist in process improvement in these areas

• Work with domain experts and developers to develop and execute test plans

• Work closely with the development team, application support team, and Frontier help desk team to troubleshoot issues in production and development environments.

• Work with developers to capture development test objects and use in automation testing

• Develop and maintain an automation framework and scripts to drive quality and efficiency improvements for new products

• Write documentation to describe logic, design, coding, corrections testing of computer programs.

• Analyzed data provided by customers for determine key data needed.

• Created custom complex SQL queries to generate specific reports.

• Use SQL queries to update, control data per customer in project.

• Assisted in development for preparation and cleaning data from Hospital Information Systems Databases

• Generated Statistical reports and Database Reports, presentation, and documentation of Analytical Methods.

• Supported technical team members for technologies such as Microsoft Excel and SQL server. Manual Tester, ITRC Ltd 2005-2007

• Create and maintain automation frameworks

• Work with management to resolve issues and report on quality of system maintenance activity and new releases

• Create/execute/maintain automation scripts

• Works directly with software developers, test engineers, product owners, business analysts, project leaders Janar Yermekbayeva Page3

• Work with automation team to design and develop test suites

• Improvements in software engineering key performance indicators

• Measure system performance on multi-user platforms through test scenarios, providing analysis results and recommendations

• Write documentation to describe logic, design, coding, corrections testing of computer programs. SIGNIFICANT PROJECTS AS SELF RESEARCHER

Data Mining in Data Storage based on SQL Server

• This is my project at Eurasian National University. It is an advanced step to understand how

• Create Data Storage based on SQL Server, Dimensions, Relationships.

• Apply the Business intelligence tools to perform extract, transform and load operations (ETL) on data from data warehouses.

• Analyzed the Predictive Model for Grocery Market. Development of an Automatic Database Management Software for Bird Migration Monitoring

• Applied object database management system (ODBMS) / Cache with

• Monitored and analyzed seasonally behavior of bird migration.

• As result this project get Student Innovator Award from the InterSystems Corporation, USA,

• Project: https://www.intersystems.com/

PROFESSIONAL QUALIFICATIONS

HarvardX edX Platform Harvard University

Data Science: R Basics January 2021

Secure Software Testing Online Platform, Since 2021 Software Testing Foundations: Continuous Testing and DevOps Learning Selenium

Python / Kaggle Aug 2020

Data Science & Artificial Intelligence Workshop at Binghamton University and IBM Oct 2019 Eurasian National University Astana, Kazakhstan

BS of Computer Science

WES Credential Evaluation USA, 2019

REFERENCES

Vladimir V. Nikulin, Associate Professor; Department of Electrical and Computer Engineering, State University of New York at Binghamton, Tel: 607-***-****, adj7cm@r.postjobfree.com Dias Nurmagambetov, Ph.D., Lecturer I, Department of Mathematics, Prairie View A&M University, TX, Tel: (936) 261- 1989, adj7cm@r.postjobfree.com.

Victor A. Skormin, Distinguished Service Professor, Department of Electrical and Computer Engineering, State University of New York at Binghamton, Tel: 607-***-****, adj7cm@r.postjobfree.com Sergey Edward Lyshevski, Professor of Electrical Engineering, Department of Electrical and Microelectronic Engineering, Rochester Institute of Technology, Tel: 585- 475-4370, E-mail: adj7cm@r.postjobfree.com, adj7cm@r.postjobfree.com

Janar Yermekbayeva Page4

Contact this candidate