Sofya Slavina

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