Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Dinesh K

Woodlands,Texas

Summary

With over 5 years of extensive experience in MS SQL Server Development, I possess comprehensive expertise across multiple versions (2019, 2016, 2014) and Microsoft's suite of products, including SSIS and SSRS. My skills encompass creating, configuring, and fine-tuning ETL workflows for homogeneous and heterogeneous systems using SSIS, as well as developing complex SSIS and DTS packages for ETL purposes with intricate transformations. I have demonstrated proficiency in data conversion, normalization, data modeling, and multidimensional modeling, including the creation of fact tables, dimension tables, star schema, and snowflake dimensional schema using Erwin.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Graduate Research Assistant

Kennesaw State University
08.2022 - 05.2023
  • Designed and developed complex SQL queries, stored procedures, and functions for data analysis and reporting, resulting in improved data accuracy and efficiency.

Data Analyst

Infosys Ltd.
01.2018 - 07.2022
  • Collaborated with business stakeholders, developers, production teams, and cross-functional units to understand business needs and discuss solution options.
  • Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to the data warehouse, utilizing components like For Each Loop Container, Execute Package task, Execute SQL Task, Send Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, and Slowly Changing Dimension
  • Performed ETL mappings using MS SQL Server Integration Services.
  • Designed high-level ETL/SSIS architecture for overall data transfer from OLTP to the data warehouse with SSIS, prepared ETL/SSIS mapping processes, and maintained mapping documents.
  • Created SSIS packages for dynamic ETL/SSIS flow to validate, extract, transform, and load data into the database using components like Lookup, Fuzzy Lookup, Derived Column, Conditional Split, and Slowly Changing Dimension for data scrubbing and validation checks during staging.
  • Designed Change Data Capture to capture insert, update, and delete activity applied to SQL Server tables, making the details of changes available.


Spark Developer Summer Intern

ECIL, Government of India
05.2017 - 08.2017
  • Responsible for design, end to end development and delivery of data from different source files into HDFS using shell script, Spark, Scala and Tableau.
  • Involved in developing Spark code using Scala and Spark-SQL for faster testing and processing of data and exploring of optimizing it using SparkContext, Spark-SQL.
  • Used dataFrame API in Scala for converting the distributed collection of data organized into named columns
  • Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs and Scala.

Education

Master of Science, Computer Science -

Kennesaw State University
05.2024

Skills

  • Python
  • Microsoft SQL Server
  • Oracle
  • MS Access
  • Crystal Reports 9/10
  • SSRS
  • SSIS
  • SSAS

Certification

  • MICROSOFT CERTIFIED DATA ANALYST ASSOCIATE (PL 300)
  • MICROSOFT CERTIFIED POWER PLATFORM FUNDAMENTALS ANALYST (PL 900)

Timeline

Graduate Research Assistant

Kennesaw State University
08.2022 - 05.2023

Data Analyst

Infosys Ltd.
01.2018 - 07.2022

Spark Developer Summer Intern

ECIL, Government of India
05.2017 - 08.2017

Master of Science, Computer Science -

Kennesaw State University

Similar Profiles

CREATE PROFILE
Dinesh K