Summary
Overview
Work History
Education
Skills
Certification
Software
Accomplishments
Interests
Timeline
Generic
VIKASH KUMAR

VIKASH KUMAR

Senior Consultant (Azure Big Data Engineer)
Hyderabad,India

Summary

10+ years of experience (India and US) including 3+ years of working experience as Big Data Engineer using Azure Databricks/Spark. Having experience in realizing business objectives by providing insights, enabling and delivering strategic IT solutions (in both on-premises and cloud) across Sales, Promotions and Trade program domain in Retail & CPG sector. Involved in creating data ingestion pipelines to process big data in Azure Data Lake. Have knowledge of variety of data sets (like Consumers digital engagement, POS Scan, Shipment data) with excellent capability to explore, learn and understand newer business domains and technology. Have a H1B visa valid till April 2022.

Overview

2
2
Languages
3
3
Certifications
4
4
years of post-secondary education
10
10
years of professional experience

Work History

Senior Consultant

Capgemini
Hyderabad, Telangana
02.2018 - Current
  • Developing big data ingestion pipelines using Azure Data Factory and Apache Spark (Databricks), to cleanse and process variety of data (Csv, Json, Parquet, Delta, AVRO) for Advanced Analytics
  • Created Databricks notebook to push data to API using Python & to cosmos DB
  • Developed parameterized Azure Data Factory Pipelines, Data Sets, Linked Services. Used Azure Key Vaults for storing secrets for APIs, Cosmos DB
  • Using Delta lake to store refined data in Azure Data Lake Storage Gen2 for highly performant Databricks notebooks
  • Created Databricks views on delta lake for Advanced Analytics use
  • Collaborating with Advanced Analytics team (Data Science) in Productinizing model scoring notebooks, Monitoring and troubleshooting model scoring notebooks in Production for any failure
  • Using Azure GitHub for version control and CICD (Azure Devops) to deploy Databricks notebooks to higher environments
  • Experience in Performance tuning of existing long running data pipelines(notebooks)
  • Created best practices document for Databricks notebook development (Pyspark) & it is used across other team
  • Mentoring team of size 5, providing highly performant generic design during Sprint Development and resolving their impediments. Performing Code Review
  • Assisting Product Owner (client) to refine user story with all necessary inputs, changes required and design considerations
  • Assisting Data Lakes support team in resolving outstanding issues in production
  • Conducted knowledge sharing session with other teams on functional or technical topics (ADF, Azure Databricks etc)

Consultant

Capgemini (India, US)
Hyderabad, Telangana
03.2014 - 01.2018
  • Involved in brain storming sessions with client and business users during tenure at onshore (Philip Morris's Facility at Richmond, VA)
  • Provided Adhoc data request to business users
  • Played role of onshore lead and interacted with offshore team
  • Developed ETL process using SSIS as per business requirement and troubleshoot SSIS packages for any failure
  • Involved in Database design
  • Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions and created clustered and non-clustered indexes
  • Involved in SQL Server 2014 upgrade activity from 2008r2
  • Developed data cleansing, validation and mapping mechanism to map and load POS Scan data to On-Premises SQL Server
  • Created user test plan and user test result document for UAT activity
  • Developed automated tool to setup test data in lower environment

Senior Software Engineer

Capgemini (Erstwhile iGate, Patni)
Hyderabad, Telangana
02.2013 - 02.2014
  • Created SSIS packages using various data transformations like Conditional Split, Multi Cast, Data Conversion, Derived Column, Aggregate, Look-Up, Merge, Merge Join, Sort, Union All and Script Components
  • Created T-SQL Scripts to Patch data based on business need and for any service requests
  • Worked in replacing legacy feeds (LFR Project) for shipment volume data, which saved client 50M USD every year
  • Worked in automation of many internal processes to get rid of extensive traditional manual process
  • Involvement in requirement discussion/gathering with customer and writing Functional, Technical Design document. Involved in Design, Development and Testing phases

Software Engineer

Capgemini (Erstwhile iGate, Patni)
Hyderabad, Telangana
02.2011 - 01.2013
  • Worked in migrating Talk Talk UK residential customers data from legacy system to Trio system in Oracle
  • Involved in creation of Procedures and Functions as per business rules in PL/SQL
  • Developed attributes mapping between legacy and new system
  • Created Audit and Reconciliation Reports (Data Quality Reports) at each stages which played important role in Migration Go-Live
  • Involved in daily BAU (Business as usual) task, including report generation for daily call record for client, timely system checks and cleaning up spaces if needed, to let system run without any interruptions

Education

B. Tech - Electronics And Communications Engineering

SRM University
Chennai
08.2006 - 06.2010

Skills

Data analysis

undefined

Certification

Professional Scrum Master - 1

Software

Azure Databricks, Delta Lake

Pyspark

Spark SQL, Python

Azure Data Lake Gen2

Azure Data Factory

Azure SQL Database

T-SQL, SSIS

Azure Cosmos DB

Azure Synapse

Accomplishments

  • Supervised and mentored team of 5 staff members
  • Introduction to Python Course by DataCamp
  • Pat-On-The-Back award for strong analytical capabilities and technical prowess in August 2014
  • Pat-On-The-Back award for driving Customer satisfaction March 2015
  • XtraMile award for outstanding performance in Q1, 2019
  • STAR award for outstanding performance in June 2020
  • IEVOLVE award on successful implementation of idea
  • Long Service award 2021 - on completing 10 years of service with Capgemini
  • Capgemini Certified Aspiring Architect

Interests

Reading, Badminton, Movies

Timeline

Microsoft Certified Azure Data Fundamentals (DP-900)

07-2021

Microsoft Certified Azure Fundamentals (AZ-900)

09-2020

Professional Scrum Master - 1

09-2018

Senior Consultant

Capgemini
02.2018 - Current

Consultant

Capgemini (India, US)
03.2014 - 01.2018

Senior Software Engineer

Capgemini (Erstwhile iGate, Patni)
02.2013 - 02.2014

Software Engineer

Capgemini (Erstwhile iGate, Patni)
02.2011 - 01.2013

B. Tech - Electronics And Communications Engineering

SRM University
08.2006 - 06.2010

Similar Profiles

CREATE PROFILE
VIKASH KUMARSenior Consultant (Azure Big Data Engineer)