Aleksandr Ospennikov Email & Phone Number

Черногория

- Developing an automation strategy, developing and supporting an automation roadmap- Improvement of internal frameworks in Python to automate front (Selenium) and data tests (Pandas, AWS services, PySpark for testing data quality and ETL processes)- Refinement of existing generators of standard autotests and implementation of new ones- Mentoring automation team membersDuring my work, I implemented the following integrations into automation frameworks:- Consul and Vault API (HashiCorp)- Slack API- AWS S3- AWS SNS- Databricks API- Databricks Filesystem (DBFS)-TestITIn my work I used: Asana, TestIt, Pycharm, Databricks, Amazon family services (Redshift/S3/SNS, Parameter Store), Consul and Vault (HashiCorp), TeamCity, Montecarlo DQ, Apache Airflow

Москва, Россия

Development of regression autotests for back / front modules based on the company's internal framework (Cucumber / Selenuim), which are run both automatically in CI and by job in Jenkins.Participation in the demo team, mainly showing the developed autotests and their new features.For convenience and time saving, a php telegram bot was developed to regress critical services after the release was delivered.Analysis of logs, localization of bugs, search for the causes of their occurrence.Interviewing and mentoring new employees, testing training (auto/manual), distribution of tasks between members of the testing team, release regression organization.Creating test artifacts in Jira: test plan, test cycle, test case, bugs.API testing, log analysis, UI testing, work with design system, error localization.Preparation of IFT reports (integration-functional testing), participation in the PSI (acceptance test)The following solutions were used to fulfill the duties: Jetbrains Idea / PHPStorm, VSCode, DBeaver, Postman, jMeter, Fiddler, devtools, loghouse, prometheus, swagger, grafana, alert manager, openshift, terminal.

Москва, Россия

Work on the DWH (Data Warehouse) project.Organization of the process of testing DWH tasks, communication with business users, UAT testing, all related processes: preparation of a test plan and UAT forms. Tasks evaluation (story point).Manual functional testing (using PLSQL Developer). Preparation test data, analysis and planning of recalculations of database cubes on UAT environment.Work with tasks takes place in the Jira system, during the testing process we use: PLSQL Developer, SAP BO, SAS, OLAP reports, Confluence.Completed many professional development courses during my career.

Казань, Республика Татарстан, Россия

Implementation of a system for detecting transactional fraud, development, updating and maintenance.Implemented integrations with other banking systems via API, dblinks, file exchanges.As part of testing: functional testing of assemblies, integrations.As part of the preparation of new functionality, stress testing (together with server admins), maintaining checklists.As part of maintenance: development of stored procedures (T-SQL), query optimization.A lot of research work, analysis of traces, logs, source code of patches and assemblies for the possibility of implementing various improvements according to customer requirements.Work according to the Scrum methodology, where I am a developer / tester. Communication with an English-speaking vendor (Jira, WebEx, phone)In my work I use software solutions:MS SQL Management, MS SQL Profiler, pgAdmin, performance monitor, event viewer, task scheduler, Soap UI, Postman, Browser Dev-Tools, zabbix, confluence, grafana, Service Desk, youtrack, jira.

Казань, Республика Татарстан, Россия

Software maintenance (Argus, ASR Start)Testing assemblies on test environments, making a decision on delivery for production.Working with databases (Oracle SQL Developer).Creation of sql reports, scripts-handlers on sql, pl / sql, completion of the missing functionality of the systems by developing sql jobs.Work in HelpDesk systems and Jira bug tracker

Казань, Республика Татарстан, Россия

Working with SAP, PuTTY.Maintenance and support of users via Help Desk.Development of macros in VBA for Excel for automatic reporting, generation of printable forms of various acts, support for the performance of macros previously implemented by other employees.