Goutham Kumar

Developed and supported scalable ETL/ELT data pipelines in Azure Databricks using PySpark, Spark SQL, Python, and Delta Lake. Designed Bronze, Silver, and Gold data layers using Medallion Architecture and implemented Delta Lake processing patterns including MERGE/upsert and incremental loads.

Developed and supported stored procedures, indexes, views, UDFs, constraints, and complex SQL queries for retail and claims-related business requirements. Designed SSIS packages for data warehouse loads and delivered SSRS reports and SSAS models.

Partnered with business analysts and data modelers on logical/physical design and developed complex T-SQL queries, stored procedures, indexes, functions, and views. Built SSIS packages with various transformations and implemented error logging.

Participated in requirements gathering, technical design, development, testing, and implementation of BI analytics solutions. Developed T-SQL stored procedures, functions, cursors, views, and multidimensional data warehouse models using star/snowflake schemas and MDX.

Translated business requirements into technical specifications and database designs; developed stored procedures, triggers, indexes, UDFs, constraints, and file-processing workflows. Tuned T-SQL and stored procedures using SQL Profiler, execution plans, DBCC commands, and Dynamic Management Views/Functions.

Master of Science in Computer Information Sciences from Harrisburg University of Science and Technology, completed in April 2020.

Master of Science in Information Systems Engineering and Management from Harrisburg University of Science and Technology, completed in August 2017.

Master of Business Administration from the University of Findlay, completed in May 2014.