David Shayatovich

Senior Database Developer at Technomic, Inc.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Greater Chicago Area
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Adrea Jackson

Dave is an extraordinarily talented developer with an advanced understanding of SQL data concepts. During our time working together on the same development team, I watched him take expert approaches to solving difficult problems with his code. He quickly understood the large amount of organizational information required to successfully integrate into our team, and became a leader in our group within weeks. He took it upon himself to solve problems that he found, both technically and organizationally. He's a joy to work with, and I would absolutely recommend him for other Analytics and BI teams!

Amogh Rajan

I worked with David at Texture Health. David was very resourceful and was always eager to collaborate on projects. I thoroughly enjoyed his energy and his ability to diffuse tense situations. David is a good BI Developer and helped drive value through the features he helped build!

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

  • AWS Fundamentals; Migrating to the Cloud
    Coursera
    Jul, 2020
    - Nov, 2024
  • AWS Fundamentals: Addressing Security Risk
    Coursera
    Jun, 2020
    - Nov, 2024
  • AWS Fundamentals: Going Cloud-Native
    Coursera
    Jun, 2020
    - Nov, 2024

Experience

  • Technomic, Inc.
    • United States
    • Business Consulting and Services
    • 100 - 200 Employee
    • Senior Database Developer
      • Sep 2020 - Present

      • Rebuilding ETL streams using Azure Data Factory pipelines. • Rewriting slow dynamic SQL using SSAS - DAX expressions • Designing back end code for software enhancements • Optimizing stored procedures to greatly improve the customer experience • Working on project to incorporate disparate customer data • Optimizing periodic data cleaning processes • Rebuilding ETL streams using Azure Data Factory pipelines. • Rewriting slow dynamic SQL using SSAS - DAX expressions • Designing back end code for software enhancements • Optimizing stored procedures to greatly improve the customer experience • Working on project to incorporate disparate customer data • Optimizing periodic data cleaning processes

  • InnerWorkings
    • United Kingdom
    • Advertising Services
    • 400 - 500 Employee
    • Business Intelligence Developer
      • 2019 - 2019

      • Supported Data Services team with daily workload of TSQL and SSRS bug fixes and enhancements • Documented and improved data services team’s deployment process saving time and ensuring accurate deployment of reports and stored procedures • Supported Data Services team with daily workload of TSQL and SSRS bug fixes and enhancements • Documented and improved data services team’s deployment process saving time and ensuring accurate deployment of reports and stored procedures

  • AArete
    • United States
    • Business Consulting and Services
    • 300 - 400 Employee
    • Sr Data Architecture Consulant
      • 2019 - 2019

      • Architected process for gathering, reposing and performing calculations on data, replacing cumbersome spreadsheets previously used saving 3-5 man hours per report • Created Teradata stored procedures and metatables to support automation project making maintenance of several reports easy for one person to manage • Architected process for gathering, reposing and performing calculations on data, replacing cumbersome spreadsheets previously used saving 3-5 man hours per report • Created Teradata stored procedures and metatables to support automation project making maintenance of several reports easy for one person to manage

  • Texture Health
    • United States
    • Hospitals and Health Care
    • 1 - 100 Employee
    • Business Intelligence Developer
      • 2018 - 2019

      • Parameterized SSIS packages for reusability on multiple servers and for ease of promotion from development to production. • Coded cross platform SSIS data flow from SQL Azure to MySQL 6.5. • Centralized code in series of stored procedures, parameterized for multi tenant ETL. • Built in regression testing and debugging counts in stored procedures saving time in unit and integration testing. • Parameterized SSIS packages for reusability on multiple servers and for ease of promotion from development to production. • Coded cross platform SSIS data flow from SQL Azure to MySQL 6.5. • Centralized code in series of stored procedures, parameterized for multi tenant ETL. • Built in regression testing and debugging counts in stored procedures saving time in unit and integration testing.

  • Precision Point Solutions, Inc.
    • United States
    • Information Technology & Services
    • SR Data Warehouse Developer (PROJECT)
      • 2018 - 2018

      • Designed and built multi database ETL architecture • Using SSIS, built ETL process to merge, transform and load data from multiple sources (REST API) to one Kimball data warehouse • Designed and built multi database ETL architecture • Using SSIS, built ETL process to merge, transform and load data from multiple sources (REST API) to one Kimball data warehouse

  • AArete
    • United States
    • Business Consulting and Services
    • 300 - 400 Employee
    • Data Warehouse Engineer
      • 2016 - 2017

      • Architected SSIS package to populate 1 TB medical claims database which maintained data integrity and validated all data was loaded properly. By comparison queries used 90% less system resources and ran in a fraction of the time • Socialized data warehouse project by presenting to internal teams using new data marts demonstrating database efficiency, size and performance • Physically modeled database using DB Schema which created DDL scripts as well as database diagrams which were used to communicate database layout to organization Show less

  • Agile Unicorn - acquired by Forté Group (on client site - RJW Transport)
    • Bolingbrook, Illinois, United States
    • Senior Data Engineer
      • 2016 - 2016

      • Wrote dynamic open query statements used to replicate Oracle 11 data tables (Synapse) to SQL Server. Queries called by SSIS package nightly to keep databases in sync • Created SSIS package to process 150+ Excel files into two different data solutions one of which a data table used for detailed data analysis • Devised SSRS reports and wrote complex query of aforementioned data analysis table which helped warehouse managers analyze order frequency and truck loads to better plan staffing and ship items more efficiently Show less

  • PTSO (via Kforce)
    • Seattle, Washington, United States - (remote in Woodridge IL)
    • Business Intelligence Developer
      • 2015 - 2015

      • Optimized stored procedures using temp tables, analyzing joins and indexing tables • Wrote stored procedure to auto update table statistics • Optimized stored procedures using temp tables, analyzing joins and indexing tables • Wrote stored procedure to auto update table statistics

  • Innovista Health
    • United States
    • Hospitals and Health Care
    • 100 - 200 Employee
    • Sr Business Intelligence Developer
      • 2015 - 2015

      • After taking online course, analyzed database and indexed tables to improve query performance. Queries usually taking nearly an hour completed in minutes • Created stored procedure to report table index status providing recommended action • After taking online course, analyzed database and indexed tables to improve query performance. Queries usually taking nearly an hour completed in minutes • Created stored procedure to report table index status providing recommended action

  • Aldera Holdings, Inc. (now Evolent Health)
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Software Engineer II
      • 2014 - 2015

      • Coded software enhancements using TSQL, created and edited stored procedures • Added screen elements and reports to Aldera system using TSQL, XSL and ASP • Produced documentation for fellow developers to speed up on-boarding process • Modified SSIS packages both in production support and on enhancement team • Worked with QA engineers and system analysts to clarify enhancement requests. • Debugged software issues reported by clients as well as internal QA processes • Created TFS work items to track checked-in code Show less

  • IPeople Healthcare
    • United States
    • Software Development
    • 1 - 100 Employee
    • Analytics and Design Specialist
      • Jan 2012 - Dec 2013

      • Analysis and Design team representative on IPeople Patient Portal design and development team which included prototyping dashboards and user interface screens • Principle developer of IPeople Patient Portal which included frontend as well as database backend development • Created NPR reports for numerous client needs including downloads for third party systems and government compliance reporting • Assisted clients with custom Quest query development including debugging existing queries • Created and taught Meditech DR course for client hospital Show less

  • St. Bernards Hospital, Inc. (via Digital Prospectors)
    • Jonesboro, Arkansas, United States - (remote - Woodridge IL)
    • NPR report writer
      • 2010 - 2011

      • Built pharmacy productivity report listing staff members and their productivity by hour • Wrote turnaround time download to help staff track turnaround of operating rooms by doctor • Other NPR report projects as needed • Built pharmacy productivity report listing staff members and their productivity by hour • Wrote turnaround time download to help staff track turnaround of operating rooms by doctor • Other NPR report projects as needed

  • Providence Health & Services
    • Hospitals and Health Care
    • 700 & Above Employee
    • NPR report writer
      • 2010 - 2011

      • Migrated numerous NPR reports from Magic to 6.0 client server platform • Created improved version of readmission report to help billing and clinical staff • Created multi use reports to avoid unnecessary duplication of reports and save time on future maintenance • Migrated numerous NPR reports from Magic to 6.0 client server platform • Created improved version of readmission report to help billing and clinical staff • Created multi use reports to avoid unnecessary duplication of reports and save time on future maintenance

  • Sg2
    • United States
    • Hospitals and Health Care
    • 200 - 300 Employee
    • Business Intelligence Developer
      • Feb 2010 - Aug 2010

      • Developed quality control reports to ensure accuracy and speed of processing client data • Merged large files to create logical records in SQL 2005 database for analysis and processing • Formatted client files to meet Sg2 specifications for processing and analysis • Developed quality control reports to ensure accuracy and speed of processing client data • Merged large files to create logical records in SQL 2005 database for analysis and processing • Formatted client files to meet Sg2 specifications for processing and analysis

  • Wheaton Franciscan Healthcare
    • United States
    • Hospitals and Health Care
    • 700 & Above Employee
    • Integrations Analyst
      • Feb 2003 - Dec 2009

      • Wrote mission critical NPR reports including an outpatient scheduling report and discharge report sent home with patients and used in continuation of care • Created SQL Server Reporting Services reports and data extracts for numerous users and maintained security on SQL Server 2000 for said reports and extracts • Developed Boston Workstation script to input employee benefits elections into Meditech, saving Human Resources staff 24-32 hours of data entry • Created ad hoc Boston Workstation scripts to update Meditech dictionaries • Created NPR download files for interfacing with third party applications, for input to Boston Workstation scripts or for data analysis • Implemented procedure to ensure uninterrupted delivery of medications to patients during loss of power or network connectivity • Modified data extract applications written in Visual Basic • Designed and implemented procedure to notify scheduling department when a patient’s discharge date was changed insuring a high level of therapist productivity • Undertook project to create patient data files in HL7 format as part of CMS pilot program, one of only 10 hospitals in the Midwest participating • Developed custom and much more useful versions of standard reports in LSS (Physician Billing and receivables • Supported Meditech DR by running table audits and reporting table errors to Meditech ensuring accuracy of data Show less

  • Telcordia Technologies
    • United States
    • Telecommunications
    • 400 - 500 Employee
    • Programmer Analyst
      • Jan 1999 - Oct 2001

      • Primary contact for organization to Visual One vendor as well as project manager on all upgrades, troubleshooting, report requests or general usage questions from users • Created trouble ticket database in Access 2000 to help eLearning staff track and resolve technical issues with customers relating to eLearning products • Rewrote trouble ticket system in Visual Basic 6.0 with a SQL 7.0 backend • Wrote and maintained reports module using MS Access 2000 producing several data analysis reports • Converted two databases written in Access version 2.0 to Access 2000 • Wrote custom Transact SQL queries for executive director for use in decision support. Extracted data lead to savings of over $48,000 in revenue and increased customer satisfaction • Wrote Visual C++ program to reformat raw data from Protobase credit card system for analysis by end users • Streamlined registration confirmation process for customer service staff, greatly reducing time and cost needed to gather data, and cost of printing and faxing confirmation letters to clients • Overhauled monthly catalog mailing process, which led to much improved productivity for marketing group • Initiated analysis project to remove duplicate logical records across three primary customer databases. This included the writing of documentation aimed at helping users identify duplicate records as well as a process to merge them • Tested interface functionality written by vendor of Visual One software, including creation of test files, and testing of general functionality of records created and modified by interface Show less

  • Edward Hospital
    • United States
    • Hospitals and Health Care
    • 700 & Above Employee
    • Programmer Analyst
      • Jan 1996 - Oct 1998

      • Created license plate database for security staff to track all employee vehicles. Database was updated by HR system to input new employees saving manual data entry. • Created training database to allow IT staff to track training records for clinical staff. Database was updated by HR system to input new employees saving manual data entry. • Created suite of reports for Central Scheduling department and setup reports to run on automatic schedule. Created numerous reports for other departments and users using NPR • Produced downloads from Meditech for multiple departments and uses including internal and external customers. Downloads also used to identify records to be modified using Microscript • Created and edited Microscripts using Visual Basic to insure successful completion of large data loads to Meditech modules • Successfully designed, created, and provided end-user training of Paradox relational databases • Formatted, converted, and manipulated files using Paradox scripts and query utilities • Created queries, imported tables, and produced output using MS Access • Backed up help desk by covering call center when needed Show less

  • Metromail Corporation
    • Lombard, IL
    • Production Programmer / Production Technician
      • Aug 1994 - Jan 1996

      • Designed, wrote, and tested COBOL programs for a variety of applications including: Database updates, data reformats, and sort exits • Configured JCL streams and flowcharted workflow monitoring input and output record counts • Designed, wrote, and tested COBOL programs for a variety of applications including: Database updates, data reformats, and sort exits • Configured JCL streams and flowcharted workflow monitoring input and output record counts

Education

  • Northern Illinois University
    Bachelor of Science - BS, Computer Science
    1992 - 1994
  • Lisle Sr High School
    Diploma, General studies
    1984 - 1988

Community

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