Sql Developer Server

OLGA NESTEROVA SQL Developer

346-***-**** ********@*****.*** Katy, TX https://www.linkedin.com/in/neoninel

SUMMARY

Accomplished SQL Developer with a proven track record of delivering high-quality database solutions experience. Expertise in database design, development, SQL programming, stored procedure development, query and indexes optimization, administration across various industries. Skilled in ETL processes, data analysis (statistics, AI, ML), collaborate in an interdisciplinary environment and implementing scalable data-driven solutions. Results-oriented, continuous learning and innovative professional in the database management and data analysis.

TECHNICAL SKILLS

Database Management: MS SQL Server, T-SQL, Database Design, Normalization, Information System Models, ER, IDEF, BP, SAP, Performance optimization, Data Protection, Database Administration, Stored Procedures, Stored Functions, Triggers, CTE, Windows functions, MERGE queries, Tuning, DBMS, PL/SQL, MySQL, SQLite, ERWIN, ER/Studio, Spatial analysis and geoprocessing

Data Integration and Analysis: SSMS, SSIS, SSAS, SSRS, SQL Agent, Crystal Report, ETL, OLAP, OLTP, Mathematical statistics, Data mining, Data Analysis methods, Artificial Intelligence and Machine learning models

Basic Programming Languages: Python, C#, Delphi, R, PHP, JavaScript, VBA, HTML, DAX, MDX

Utilities and Tools: MS Excel, MS Access, MS Word, RapidMiner, Statistics, SPSS, GitLab, GIS, ArcGIS, MapWindow, MapInfo, Miro, Trello

EDUCATION

PH. D Technical Science University of Tyumen – Russia

POST GRADUATE PROGRAM Artificial Intelligence and Machine Learning The University of Texas at Austin

MASTER’S DEGREE Math and Computer Science University of Tyumen – Russia

CERTIFICATION MCSA MS SQL Server Microsoft Certification

WORK HISTORY

SLB Spouse Association Houston, US Volunteering DATABASE COORDINATOR from April 2024

Maintained the SSA Houston Members Database and administered the Facebook group.

Resolved technical communication issues for 10% of members by eliminating database inconsistencies.

Helped to plan the budget with an accuracy 5% higher than the previous year based on membership forecast changes.

Enhanced data security by removing outdated access rights and restricting link-based access.

University of Texas at Austin US Postgraduate program STUDENT/RESEARCHER September 2023 – June 2024

Successfully learned artificial intelligence and machine learning tools with Python, using EDA, Data preprocessing and treatment, Seaborn, Linear regression, Decision tree, Pruning, Random Forest, Logistic regression, Bagging, Boosting, SMOTE, Cross Validation, Hyperparameter Tuning, ANN, TensorFlow, Keras, Computer Vision, CNNs, Image processing, Transfer Learning, NLP, LLMs, Transformers, Prompt Engineering. Developed and completed the predictive models.

Identified new revenue opportunities through data analysis and developed predictive models with 0.8-0.98 accuracy/precision/recall/f1 score, depends on project busyness demands, and were estimated for robustness and generalizability.

Developed an artificial neural network from scratch, a robust image classifier using transfer learning, and an advanced support ticket categorization system using LLM, transformers, and prompt engineering.

AutomaCon Inc Russia Remote SQL DEVELOPER November 2022 – April 2023

Designed and optimized dozens of SQL databases on five servers, implemented ETL processes, applying CI/CD with GitLab.

Improved data integrity and met new business requirements by restructuring databases and developing efficient queries, stored procedures and by the elimination of outdated solutions.

Increased performance by 20-50% and reduced downtime by 10% through optimized complex queries and troubleshooting.

Enhanced documentation and collaboration, leading to better data quality, decision-making, and reduced redundancy.

Some bugs, when exchanging millions of rows of data daily between SQL and NoSQL databases, have been fixed.

Optimized changes of 50+ procedures to meet new developer demands by scripting in days rather than by hand over months.

Reduced downtime by 10% by applying strong skills in troubleshooting, diagnosing, and resolving database issues.

Brought significant expertise to the team by maintaining current knowledge of database technologies and sharing ideas.

OLGA NESTEROVA 346-***-**** Page 2

WORK HISTORY CONTIUED

Geology and Oil and Gas Production Institute Industrial of University of Tyumen Tyumen, Russia Part-time

Held up to two diverse roles simultaneously at the University September 2016 – July 2023

LECTURER/SUPERVISOR: Taught database design, OLAP/OLTP systems, ETL processes, Big Data technologies, GIS technologies and data mining for oil and gas industry, achieving 92% rate of passing.

Analysed student progress to develop targeted exercises for success, encouraged collaboration among students to cross-pollinate ideas and improve academic performance, that contributed to all supervised undergraduate projects (10+) and five master's degree dissertations being successfully implemented in oil and gas and other industries.

SCIENTIST/DATA ANALYST: Researched optimization of oil and gas production in Western Siberia.

Collaborate in an interdisciplinary environment and published cited in Russia studies on improving accuracy of oil field production forecasts to reduce errors that has contributed to advancing oil field production research.

Conducted spatial analysis for for healthcare analytical systems, enhancing accuracy in production forecasts. Developed GIS data projects, integrating spatial data with database systems.

Mathematical and Computer Science Institute of University of Tyumen Tyumen, Russia Full-time

Held up to tree diverse roles simultaneously at the University September 2008 – September 2022

SQL DEVELOPER/DATA ANALYST: Developed certified software for Tyumen Cardiology Research Center, securing intellectual property rights, designed, and administered databases, analyzed data for scientific studies.

Certified software for ultrasound diagnostics, clinical diagnostics, clinical care, angiography, cardiology, radiology surgery, and physiotherapy have facilitated the reducing paperwork, the data accessibility for various specialists, for healthcare centers and research projects.

Implemented robust security measures allowed to ensure the sensitive data protection and compliance with industry standards.

LECTURER: Taught database design, OLAP/OLTP systems, ETL processes, GIS technologies and data mining, enabling students to be sought after for career opportunities. Mentored and taught database development and data analytics for 3 sessions of 100 students per year.

Achieved 95% student pass rate through curriculum development and support, boosting student success.

Mentored students after hours on projects, and managed student research projects in database and information systems, so dozens of innovative solutions have been implemented in industry.

Conducted spatial analysis for optimizing oil and gas production in Western Siberia, enhancing accuracy in production forecasts. Developed GIS data projects, integrating spatial data with database systems.

SCIENTIST/DATA ANALYST: Conducted research on medical data analysis and information retrieval methods.

Participated in a scientific grant for the processing of big medical data, researched into the information retrieval ontology, published cited in Russia articles on data analysis and data mining techniques,, collaborate in an interdisciplinary environment helping to improve analysis of heterogeneous medical data.

Conducted research on medical data analysis and information retrieval, contributing to advancements in healthcare.

ACTING DIRECTOR OF IT DEPARTMENT Part-time September 2020 – May 2022

Increased enrollment and student success by modifying curriculums to meet new educational standards.

Managed IT department work, enhancing research and teamwork among 20 employees and 500+ students.

PUBLICATIONS (ORCID: 0000-0001-7691-0885)

"The profile of the patient to be ready to use digital technologies and AI methods when receiving medical care",

Co-Author, Russian Federation Healthcare, 2022

"Incidence and Structure of TBI in Adults in Tyumen During 2016-2020", Lead Analyst and Co-Author, Russian Neurosurgical Journal, 2022

"Evaluation of Platelet Parameters in Cerebral Stroke with HIV", Co-Author, Medical Alphabet, 2021

"Modern Problems of Stroke During Hospitalization", Lead Analyst and Co-Author, Neuroscience Journal, 2021

"Analysis of new data protection opportunities in Microsoft SQL Server 2019", Co-Author, Information Security Conference, 2021

"Distributed Storage Systems Protection with Hadoop", Co-Author, Information Security Conference, 2021

"Patients' Attitudes Toward Healthcare Digitalization During COVID-19", Co-Author, Therapeutic Forum Proceedings, 2020

"Western Siberia Oil Field Gas Content Analysis", Lead Analyst and Co-Author, International Scientific Conference, 2019

"Western Siberia Oil Fields Gas Content Research Results", Lead Analyst and Co-Author, International Scientific Conference, 2019

"Information Retrieval in Medical Archives Using Context-Temporal Ontology", Lead author, Tyumen State University Bulletin, 2011

Contact this candidate