Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Ashok Kumar

Chennai

Summary

With a proven track record at Transunion, I excel in migrating and optimizing data systems using SQL, showcasing my technical prowess and problem-solving abilities. My leadership as a Module Lead at Mindtree and expertise in SSRS, T-SQL, and Azure underline my ability to deliver impactful data solutions and drive business insights.

Overview

12
12
years of professional experience

Work History

Senior Developer

Transunion
Chennai
05.2023 - Current
  • Implemented ETL processes using SQL and additional tools to migrate data across different systems.
  • Provided technical support to users in resolving database related issues and errors.
  • Conducted database tuning and performance monitoring to ensure optimal system functionality.

Module Lead

Mindtree
Chennai
05.2021 - 05.2023
  • Worked as a Module Lead, responsible for working with Azure T-SQL code.
  • Responsible for developing the Azure Data Factory (ADF) pipeline.
  • Writing Azure T-SQL Code and Handling Python Codes
  • Analyzed user feedback data to identify areas of improvement in the module's functionality.

Consultant

Capegemini
02.2017 - 05.2021
  • Company Overview: A Financial Service Organization Needs Various Types of Insights for Business People
  • Responsible for Creating Complex SQL Queries, Stored Procedures, Functions, Views, Triggers, CTE, Joins
  • Responsible for Creating Various Types of SSRS Report for High Level Business People to Perform their Analysis
  • The SSRS Report gives a detailed Insight to the Client in the form of Dashboard
  • Includes Development of Various Tabular, Chart, Metrics, Drill Down, Drill Through Reports
  • A Financial Service Organization Needs Various Types of Insights for Business People

Software Development Engineer

Accenture
05.2015 - 12.2016
  • GCS is an tool where payroll employees can login and see their Performance Metrics
  • Using Complex logic SQL Queries each Payroll Employees Performance is Evaluated and Their Performance is displayed as Dashboard using SSRS Reports

Data Analyst

Innovapoint Infotech
06.2013 - 01.2014
  • As a Data Analyst Responsible for Writing Complex Stored Procedures, Functions
  • Analyze the Unstructured Data
  • Perform ETL operation on the Data to Cleanse, Transform and Load to final Designed Database Using SSIS
  • Resposible for Designing the Database from Scratch

Associate

Meye Management Services
09.2012 - 06.2013
  • Responsible for deriving ETL Tables using SSIS Packages on Applying Business Logic on That
  • These Final ETL Tables are used to Design Dashboards for Higher Ofiicial People of the Firm to do their Analysis and Prediction for the Futre

Education

MCA -

Anna University
08.2009

B. Sc - Computer Science

Bharathidasan University
07.2006

Skills

  • SSRS
  • T-SQL
  • ADF
  • Azure
  • SQL Server
  • AWS data pipeline expertise
  • Oracle SQL developer
  • GitHub
  • Putty
  • DB Visualizer

Languages

  • English
  • Tamil

Timeline

Senior Developer

Transunion
05.2023 - Current

Module Lead

Mindtree
05.2021 - 05.2023

Consultant

Capegemini
02.2017 - 05.2021

Software Development Engineer

Accenture
05.2015 - 12.2016

Data Analyst

Innovapoint Infotech
06.2013 - 01.2014

Associate

Meye Management Services
09.2012 - 06.2013

MCA -

Anna University

B. Sc - Computer Science

Bharathidasan University
Ashok Kumar