Sofya Slavina

Sofya Slavina

Sr. Database Analyst (latest)

Followers of Sofya Slavina77 followers
location of Sofya SlavinaNew York City Metropolitan Area

Connect with Sofya Slavina to Send Message

Connect

Connect with Sofya Slavina to Send Message

Connect
  • Timeline

  • About me

    Sr. Database Developer at Stifel Financial Corp.

  • Education

    • Moscow State Technical University

      -
      BS Industrial Engineering (Automation of Manufactoring Processes)

      Professional Training (2014-2016): Implementing a Data Warehouse with Microsoft SQL Server MS SQL Server Performance Tuning and Optimization Administering a SQL Database Infrastructure LinkedIn Courses (2018):Tableau (in-training)Machine Learning & AI FoundationsR for Data ScienceNoSQL for SQL Professionals

    • Moscow High School 19

      -
      A highly selective school with specialization in STEM subjects.
  • Experience

    • EngenderHealth

      Jan 1997 - Jan 2011
      Sr. Database Analyst (latest)

      Designed, developed and maintained multiple highly customized web-based applications that were used by about 500 people in the US and 25 country offices worldwide.TECHNOLOGIES USED:advanced T-SQL- complex queries, functions, stored proceduresMS SQL Server (7-2008), MS SSRSASP.NET-C#, Classic ASP, VBScript, JavaScript, HTML, CSS Solely developed one of the key systems, Maternal Health Monitoring and Reporting application, which captures multiple indicators for the major global multi-million-dollar 5-year project that facilitates reporting from 11 Africa and Asia based country offices and expedites preparation of reports for United States Agency for International Development (USAID) and country missions.The system was cited as an example of best practice by USAID. Show less

    • Bank Hapoalim בנק הפועלים

      Jan 2011 - Dec 2017
      Sr. Database Developer & Application Programmer

      Designed, implemented and maintained MS SQL Server databases, efficient ETL pipelines (packages) and reports for various projects.Supported production level ETL processes. Troubleshot and timely resolved production system issues.Simplified some unnecessary complex legacy SQL Server stored procedures to reduce the upload package run time. TECHNOLOGIES USED:advanced T-SQL- complex queries, functions, stored proceduresMS SQL Server (2008, 2014), Oracle12c, MS SSISLotusScript, JavaScript, HTML, CSS IBM Rational ClearCase - version control system• Developed ETL packages that upload data from various sources into custom SQL Server databases. As a result of updating legacy package used for private banking, its running time was dramatically reduced by correcting logic on the database side.• Designed and scheduled administrative reports for Internet Banking system to get required data from SQL Server database into Excel spreadsheets using SSIS.• As a team member (solely working on the back-end), participated in the development of the enterprise-level corporate banking system that combines data from various sources: (ACBS - Oracle based system, SQL Server databases, data marts, mainframe extracts, Excel files) and provides the complete overview of customer's financial information. It is daily used by about 100 people at the New York branch. Show less

    • Stifel Financial Corp.

      Oct 2018 - now
      Sr. Database Developer
  • Licenses & Certifications

    • Programming Foundations: Secure Coding

      LinkedIn
      Dec 2022
      View certificate certificate
    • Machine Learning & AI Foundations: Value Estimations

      LinkedIn
      Feb 2018
      View certificate certificate
    • NoSQL for SQL Professionals

      LinkedIn
      Mar 2018
      View certificate certificate
    • R for Data Science: Lunchbreak Lessons

      LinkedIn
      May 2018