Nathan Vayner

Database developer/SQL DBA at Savasta and Company Inc
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Brooklyn, New York, United States, US
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Amazon Redshift Essentials
    LinkedIn
    Sep, 2023
    - Sep, 2024
  • Microsoft Azure Synapse for Developers
    LinkedIn
    Jul, 2020
    - Sep, 2024
  • Crystal Reports 2013 Essential Training
    Lynda.com
    May, 2019
    - Sep, 2024
  • Programming Foundations: Algorithms
    Lynda.com
    May, 2019
    - Sep, 2024
  • Programming Foundations: Object-Oriented Design
    Lynda.com
    May, 2019
    - Sep, 2024
  • Advanced SQL for Query Tuning and Performance Optimization
    Lynda.com
    Apr, 2019
    - Sep, 2024
  • Learning Azure SQL Querying
    LinkedIn
    Apr, 2019
    - Sep, 2024
  • Learning VBA in Excel
    Lynda.com
    Apr, 2019
    - Sep, 2024
  • Advanced SQL Server: Reporting Services
    Lynda.com
    Mar, 2019
    - Sep, 2024
  • Scrum: The Basics
    Lynda.com
    Sep, 2018
    - Sep, 2024
  • Microsoft SQL Server 2014: Backup and Recovery
    Lynda.com
    Oct, 2016
    - Sep, 2024
  • Learning NoSQL Databases
    Lynda.com
    Sep, 2016
    - Sep, 2024
  • SQL Server 2012: Designing Database Solutions
    Lynda.com
    Dec, 2015
    - Sep, 2024
  • SQL Server: Triggers Stored Procedures and Functions
    Lynda.com
    Apr, 2014
    - Sep, 2024
  • Unix C/C++
    Pace University

Experience

  • Savasta and Company Inc
    • United States
    • Insurance
    • 1 - 100 Employee
    • Database developer/SQL DBA
      • Sep 2020 - Present

      Responsible for database migrations to Azure SQL server managed instance Created and maintained various SSIS packages, alerts, store procedures, functions, views, triggers, .NET CLR Design various analytical/reconciliation reports using SSRS and Crystal reports. Redesigned Fundman applications to utilize ASP. Net, HTML, CSS and SSRS Develop data flow diagrams for various ETL processes by using Visio, SSMS Performed database backups, recovery, and database replications Responsible for database migrations to Azure SQL server managed instance Created and maintained various SSIS packages, alerts, store procedures, functions, views, triggers, .NET CLR Design various analytical/reconciliation reports using SSRS and Crystal reports. Redesigned Fundman applications to utilize ASP. Net, HTML, CSS and SSRS Develop data flow diagrams for various ETL processes by using Visio, SSMS Performed database backups, recovery, and database replications

  • Mayor’s Office of Contract Services (MOCS)
    • Database Developer/Application Support Specialist
      • Jul 2019 - Sep 2020

      Responsible for design and maintenance of R2 procurement analytical dashboard report, by utilizing MSSQL, Tableau, VBA for Excel, and PASSPort system Responsible for LL63, Vendors contracts ETL/EAI processes and documentations using T-SQL, SSIS Design and maintain Vendor’s Search reporting solution using MSSQL, Oracle database, SSIS, SSRS Responsible for design and maintenance of R2 procurement analytical dashboard report, by utilizing MSSQL, Tableau, VBA for Excel, and PASSPort system Responsible for LL63, Vendors contracts ETL/EAI processes and documentations using T-SQL, SSIS Design and maintain Vendor’s Search reporting solution using MSSQL, Oracle database, SSIS, SSRS

  • Montefiore
    • United States
    • Hospitals and Health Care
    • 300 - 400 Employee
    • Software Engineer
      • Oct 2018 - Jun 2019

      Develop and maintain ETL processes by using SSIS, part of Healthy Planet project implementation Design various reconciliation and analytical reports using SSRS, Crystal report and Tableau Develop and maintain ETL processes by using SSIS, part of Healthy Planet project implementation Design various reconciliation and analytical reports using SSRS, Crystal report and Tableau

  • Con Edison
    • United States
    • Utilities
    • 700 & Above Employee
    • Senior Database Developer
      • Aug 2017 - Aug 2018

      Database Developer/Data Analyst Database Developer/Data Analyst

  • Medical Knowledge Group
    • United States
    • Advertising Services
    • 100 - 200 Employee
    • Database Developer
      • Nov 2016 - Jan 2017

      Conducted database research and analysis in order to create various analytical reports. Conducted database research and analysis in order to create various analytical reports.

  • Triumph Learning
    • Canada
    • 1 - 100 Employee
    • Web\Database Developer
      • May 2014 - Jun 2016

      Design and maintain Triumph Learning’s web reporting portal. Perform various data analysis in order to assist with processing company’s inventory. Responsible for database migration to new version of SQL Server 2014. Participated in design of Waggle online learning solution. Design SSIS packages, alerts, store procedures, views, and triggers. Design and maintain Triumph Learning’s web reporting portal. Perform various data analysis in order to assist with processing company’s inventory. Responsible for database migration to new version of SQL Server 2014. Participated in design of Waggle online learning solution. Design SSIS packages, alerts, store procedures, views, and triggers.

  • GetTaxi
    • Spain
    • Truck Transportation
    • US IT & Application Support Manager
      • Oct 2013 - Mar 2014

      In charge of the design and maintenance of the GetTaxi.com driver’s portal utilizing the following tools (CSS, HTML, DHTML, PHP, MySQL, Ajax, jQuery) Design and maintain views, stored procedure, various kinds of reports by using the following tools (MySQL Workbench, Crystal Report 11, MyDBR) Accountable for updates and maintenance of the GetTaxi.com inventory system. Responsible for product bugs, release cycles, testing related to the DriverBox application. Conducted comprehensive web researches and analysis to recommend and implement the best course of actions for GetTaxi.com Acted as company liaison Responsible for IT infrastructure and equipment Show less

  • Bloomingdales.com
    • 1 - 100 Employee
    • Content Engineer
      • Apr 2008 - Oct 2013

      Designed and maintain Bloomingdale’s website utilizing the following tools (CSS, Spring/Tiles, HTML, DHTML, ASP/ASP.net, Ajax, JQuery) Participated in implementation of the weekly creative releases Accountable for design and update of the lookbooks , microsites and styleguides. Created and maintain views, stored procedure and reports by using the following tools (MS SQL 2000/2005/2008 Crystal Report 11, SSRS, DTS/SSIS) Conducted comprehensive web researches and analysis to recommend and implement the best course of actions. Show less

  • Visiting Nurses Regional Health Care System
    • Accounting
    • 1 - 100 Employee
    • SQL Server DBA/Database Developer
      • Nov 2006 - Feb 2008

      Conducted comprehensive database research and analysis in order to create various analytical reports by using the following tools (SQL 2000/2005, Crystal Report 9/11, McKesson system) Performed full maintenance of the MS SQL server, including database backups and recovery, job scheduling, replication Responsible for the Cell Track application using the following tools (SQL 2005, SSIS, ASP.net, Java Script, VBScript, XML) Designed and maintain Ineligible Providers application by using the following tools (SQL 2005, SSIS, ASP.net Crystal Reports 9, JavaScript) Responsible for large quantity of data extracts and analysis in order to assist with unprocessed A/R balances Designed DTS/SSIS packages, alerts, store procedures, views, triggers Show less

  • Montefiore Medical Center Home Health Agency
    • United States
    • Medical Practices
    • Senior Systems Analyst/SQL Server DBA
      • Mar 2003 - Nov 2006

      Provided comprehensive data research analysis utilizing a variety of enterprise applications and report writing tools including the following (MS SQL 2000, Crystal Report 9.0/10, MS Access, Misys system, OLAP cubes). Migrated old Delta database system to MS SQL 2000 in order to provide management of the agency with up to date financial and patient information Responsible for database replication, design DTS packages Worked in conjunction with clinical, administrative and financial management groups in order to create various analytical reports and application Provided full maintenance of the MS SQL server, including database backups and recovery, job scheduling Responsible for the full cycle development and implementation of Client/Server and Web applications for financial and statistical analysis, which are used as management tools by senior management of the agency using the following tools (ASP.Net, Visual Basic 6.0, OLE DB, ADO, Crystal Reports) Responsible for redesign of the PIMS application from FoxPro by using the following tools (ASP.Net, MSSQL 2000, Crystal Reports 10) Show less

  • Central Admission Unit, Visiting Nurse Service of New York
    • Systems Manager
      • Apr 2001 - Aug 2002

      Developed and maintained the CAU Data Log application used as a primary tool to monitor incoming information about patients Performed full cycle migration of the CAU Data Log application from MS Access 97 to Oracle 8i database by using Visual Basic 6.0, ASP, JavaScript, MS Access 97 OLE DB Technology, Crystal Reports 7.0 and Oracle 8i. Implementation included logical and physical database design, coding of stored procedures, packages and triggers. Performed thorough system testing Designed the Compliance Monitor application for the internal department auditing by using VBA for MS Excel Acted as department liaison Show less

  • PaineWebber Trust Company
    • Senior Programmer/Systems Analyst
      • Feb 2000 - Feb 2001

      Designed various financial Client/Server and web applications, which utilized the following technologies: ASP, JavaScript, MS Access 97, Sybase 11, OLE DB Technology, COM, Crystal Reports 7.0 and Visual Basic 6.0 Designed the Fiche Viewer web application to view numerous financial statements Developed Brokers Performance Report application to allow the trust officers to view financial information about Brokers or clients by using VBA for MS Access Was responsible for maintenance and support of existing financial applications on Novell network server Show less

  • Bloomingdale's
    • United States
    • Retail
    • 700 & Above Employee
    • Programmer/Systems Analyst
      • Mar 1997 - Sep 1999

      Was responsible for the full cycle development and implementation of various Client/Server programs and systems for financial and retailing analysis and reporting, which are used as management planning tools by senior management of the company. Implementation on the server side included interaction with CICS and DB2 screens through Attachmate Extra for transferring data into MS SQL server, and Access databases in real time. Front-end design and coding was done in Visual Basic 4.0/5.0, VBA for MS Excel, VBA for MS Access, ASP using the following (ActiveX Controls, DAO, RDO, ADO 2.5 and OLE DB technologies), Extra Basic, MS Access, and Crystal Reports. Responsible for migration of the existing application from MS Access to MS SQL server and Intranet use. Implementation included interaction with end users and establishing their needs for certain applications, logical and physical database design, coding of stored procedures and triggers Participated in maintenance of the MS SQL server. Show less

  • Leshkowitz & Company CPA's
    • Computer Programmer
      • Jun 1995 - Dec 1996

      Designed and developed new Customer Inquiry System written in Visual Basic and MS Access, to perform multiple accounting as well as financial computation and analysis Prepared multiple reports in MS Excel and Lotus 1-2-3 Designed back-end databases Was responsible for production problem-resolution and troubleshooting Developed front - end Travel Database Program written in MS Access to keep track of all travel arrangements and expenses Performed installation and comprehensive testing of the program Prepared and reconciled monthly documents with General Ledger Performed monthly bank statement's reconciliation Performed tax research and preparation Show less

Education

  • Pace University
    1999 - 1999
  • City University of New York-College of Staten Island
    1992 - 1996
  • THE COLLEGE OF STATEN ISLAND - City University of New York
    Bachelor of Science, Accounting
    1992 - 1996
  • School#9

Community

You need to have a working account to view this content. Click here to join now