Steven Kathi, Developer in Katy, TX, United States
Steven is available for hire
Hire Steven

Steven Kathi

Verified Expert  in Engineering

Data Warehouse Design Developer

Katy, TX, United States

Toptal member since July 10, 2022

Expertise
Visual Studio DevelopmentSQLData WarehouseSSISC#Windows DevelopmentGitETLOLAPJiraBusiness Intelligence DevelopmentCC++
Bio

Steven is experienced in a variety of relational and non-relational database and data processing technologies on-premise and in the cloud. As a certified Azure Data Engineer, he excels in implementing Azure database and business intelligence solutions and migrating existing on-premise solutions to the Azure Cloud. Steven has participated in many projects designing, implementing, and administering online transactional processing (OLTP) systems and data warehouses.

Portfolio

Enbridge
Azure SQL Databases, SQL Server Integration Services (SSIS), SSRS Reports...
EPAM Systems
SQL, T-SQL (Transact-SQL), SQL Server 2016, C#, ReSharper, Windows PowerShell...
EPAM Systems
Visual Studio, SQL Server 2016, SQL Server BI, Database Design, ETL, Azure...

Experience

  • SQL Management Studio - 20 years
  • Visual Studio - 20 years
  • SQL - 20 years
  • SQL Server Integration Services (SSIS) - 15 years
  • Database Design - 15 years
  • Data Warehouse Design - 10 years
  • C# - 5 years
  • SQL Server 2016 - 5 years

Availability

Part-time

Preferred Environment

Windows, Visual Studio, SQL Server 2016, SQL Management Studio, Git, Azure

The most amazing...

...project I've done was creating a Production reporting application for oil and gas production and tracking planned/unplanned outages for a major global company.

Work Experience

Senior Database Developer

2022 - 2024
Enbridge
  • Designed and implemented production reports in Power BI and SSRS.
  • Designed data warehouse and ETL procedures for importing new data.
  • Developed new database procedures for data loading and business logic.
  • Performed data validation in support of energy production management software upgrade.
Technologies: Azure SQL Databases, SQL Server Integration Services (SSIS), SSRS Reports, Microsoft Power BI, Business Intelligence (BI), Data Warehousing, ETL

Database Developer

2020 - 2022
EPAM Systems
  • Developed Microsoft SQL Server store procedures for data validation.
  • Built data import and data processing logic in T-SQL and PowerShell.
  • Created unit tests for database procedures and business workflows in C# and ReSharper.
  • Managed Microsoft SQL Server database releases and Azure CI/CD pipelines.
Technologies: SQL, T-SQL (Transact-SQL), SQL Server 2016, C#, ReSharper, Windows PowerShell, Jira, Azure

Delivery and Project Manager, Technical Lead

2017 - 2020
EPAM Systems
  • Designed and implemented data warehouse and ETL for production measurement.
  • Migrated database applications with ETL, database, and OLAP layers from on-premise to Azure.
  • Developed business logic in consultation with stakeholders and SMEs.
  • Managed support and work intake for a system with 1000+ users.
Technologies: Visual Studio, SQL Server 2016, SQL Server BI, Database Design, ETL, Azure, Azure SQL, C#, Microsoft Power BI, Azure Data Factory (ADF)

Project Manager, Team Lead

2015 - 2017
EPAM Systems
  • Performed requirement analysis and project and resource planning.
  • Created and implemented a self-service data loading interface.
  • Designed and implemented the data transformation logic.
  • Developed an interface for metric and formula management.
Technologies: Data Warehouse Design, SQL Server Integration Services (SSIS), Database Design, Spotfire, T-SQL (Transact-SQL), C#

Experience

Energy Production Reporting

Handled an upstream reporting implementation for business analysis, development, deployment, training, and support, decommissioned the older reporting platform, and led the migration to Azure.

Main accomplishments:
• Designed business logic in consultation with stakeholders and SMEs
• Handled database and ETL design
• Managed support and work intake for the system with 1000+ users
• Acted as the technical lead for the Azure migration of ETL (SSIS), database (MYSQL), and Olap (SSAS) layers
• Provided consulting to other teams in Azure migration.
• Designed and implemented a data validation framework with statistical analysis, a usage statistics system with reporting, and a homeless data interface.
• Created and implemented ETL load from Excel source

Education

1994 - 2000

Master of Science Degree in Computer Science

The Faculty of Engineering at Lund University - Lund, Sweden

Certifications

AUGUST 2020 - PRESENT

Associate Cloud Engineer

Google Cloud

MAY 2020 - MAY 2023

Microsoft Certified: Azure Data Engineer Associate

Microsoft

Skills

Tools

Visual Studio, SQL Management Studio, Git, SQL Server BI, ReSharper, Jira, Microsoft Power BI, Spotfire

Paradigms

Database Design, ETL, OLAP, Business Intelligence (BI)

Storage

SQL Server 2016, SQL Server Integration Services (SSIS), Azure SQL, Databases, Google Cloud, Microsoft SQL Server, SQL Server Reporting Services (SSRS), Azure SQL Databases

Languages

SQL, C#, T-SQL (Transact-SQL), C, C++, Java

Frameworks

Windows PowerShell

Platforms

Windows, Azure

Other

Data Warehouse Design, Azure Data Factory (ADF), Hardware Design, Computer Science, SSRS Reports, Data Warehousing

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring