Summary
Overview
Work History
Education
Skills
Certification
Currentposition
Personal Information
Timeline
Generic
Vikas Sharma

Vikas Sharma

Senior Manager Data Engineering
Reading,United Kingdom

Summary

Experienced Data Engineer / Architect with a strong background in designing and implementing data engineering architecture for cloud-based and on-premise applications. Seeking a challenging career opportunity to leverage extensive training and skills and make a meaningful impact on company success.

Overview

17
17
years of professional experience
4
4
Certifications

Work History

Senior Manager Data Engineering

EXL Services
London, United Kingdom
04.2024 - Current
  • Company Overview: Domains: Banking and Insurance
  • Modernize Data Platform from legacy systems to Azure hosted architecture.
  • Collaborate with stakeholders to define the organization's data strategy, including data storage, data integration, data governance, and data lifecycle management.
  • Designing and building data solutions across various data platforms (Batch, Real time processing). Understanding in Spark Data Frames, Spark SQL for processing large volume of data.
  • Experienced in building data Platforms using Medallion architecture (Lakehouse).
  • Building and supporting data pipelines for various data orchestrations, data transformations, data quality, data governance in Azure Data Bricks.
  • Experienced in building conceptual, logical and physical data models for various businesses using tools like DBSchema/ER Studio.
  • Engagements with Sales and Pre sales teams in winning projects bids
  • Leading a team of Data engineers in building cloud hosted data solutions
  • Organizing various technical sessions for clients and internal to the organization
  • Domains: Aviation, Banking, HealthCare, and Utilities
  • Led cross-functional teams to achieve project milestones and deliver high-quality results.

Client: Canopius Insurance.

Data Architect / Lead Data Engineer

Agilisys
London, United Kingdom
12.2021 - 04.2024
  • Provided technical presentations to business (BH) in winning project
  • Have done data modelling for various NHS Trusts on cloud platforms using tool DbSchema
  • Designed and built complex Mapping Data Flows in Azure Synapse for ETL solution
  • Contributed to writing HLD and LLD documents
  • Developed DevOps CI/CD Pipelines for code promotion into higher environment and applied in other projects
  • Set up SHIR connectivity with various data sources
  • Supported Data Science team in building ML models in PySpark using Azure Notebooks
  • Helped business in setting up optimised data pipelines in Synapse
  • Set up DevOps board for tracking progress of project
  • Technical knowledge sharing presentations given to business.

Client: Royal Marsden Hospital, Benenden Health insurance,Essex Police,Bournemouth Christchurch and Poole council.

Azure Data Integration Engineer

Tata Consultancy Services (TCS)
London, United Kingdom
12.2019 - 11.2021
  • Understanding and building Solution Design for VA Cost Curve Tool
  • Developed Data engineering pipelines on Azure
  • Design and architect data related solutions
  • Developed CC Tool (Cost Curve Tool) for ODS team
  • Build various data pipelines for ACARS messages and aircraft maintenance team
  • Supported SCV (Single Customer View) on COSMOS DB
  • Successfully implemented Cost Curve Tool and various Data pipelines for VA
  • Design data solutions in Customer Data Enablement (CDE) team.

Client: Virgin Atlantic Airways (VAA).

Sr. Data Engineer

Tata Consultancy Services (TCS)
Reading, United Kingdom
05.2016 - 11.2019
  • Developed a data mart for Wholesale Marketing Systems (WMS) team called as DMS
  • DMS interacts with various market driven entities (IDX, ESB) to implement legislative changes through various Inbound and Outbound interfaces
  • DMS is used to trigger MOSL transactions and further business processing
  • Developed a data mart on MS Azure for both Waste and Clean Water teams which holds data from various systems and APIs Like Optimum Energy, SAP
  • Successfully designed the required system

Client: Thames Water.

Developer

Tata Consultancy Services (TCS)
Banglore, India
11.2015 - 04.2016
  • Core designer for MDP Re-design project
  • There was a need to develop dynamic framework which is capable enough to handle any number of clients, considering different source file (XML) structure
  • Successfully implemented new framework into production

Client: Swiss Re-Insurance.

Database Developer, Program Analyst

Tata Consultancy Services (TCS)
Melbourne, Australia
01.2014 - 10.2015
  • Database Developer for SuperPartners Australia, worked for Data Migration projects, Insurance Re mediation as Program Analyst
  • Appreciated by client for the work done for data migration from R2(Legacy Mainframe) to spRIGHT system.

Client: SuperPartners Australia.

Data Engineer

Tata Consultancy Services (TCS)
New Delhi, India
09.2011 - 04.2013
  • Income Tax Department (ITD) application has enabled client for easy PAN and TAN allotment, ITR and TDS return processing, tax accounting, resource and manpower management and many other activities
  • Responsibilities were - Development for data entry and processing forms ITR1-6, and rectification forms ITR 4,5,6 in AST Module
  • Implementing logic for computation of tax and defaults raised in TDS module
  • Implementing the processing of correction returns which was not being done earlier
  • Developing inbound and outbound interfaces between the current application and the new application TDSCPC as the legacy system has to be maintained as a repository, which requires both databases to be in sync.

Client: Department of Income Tax , India.

Developer

Birla Soft
Noida, India
09.2010 - 08.2011
  • Company Overview: Customer Name: GE General Electric
  • Database Developer Involved in ETL and migration processes

Client: GE General Electric

Database Developer

Nucleus Software
Noida, India
12.2007 - 09.2010
  • Company Overview: Customer Name: ACOM JAPAN
  • Database PL/SQL developer for Core Banking product FINNONE
  • Developed various database modules and core business logic written in PL/SQL to handle loan disbursal and complete life cycle of loan application
  • Involved in requirement gathering and client presentations to various business SMEs
  • Customer Name: ACOM JAPAN
  • Excellent rating for two consecutive years
  • Good understanding of BFSI domain
  • Received Best Nucleite of the Month Award

Education

Master of Computer Application - Computer Application

Jaypee Institiute of Infomration Technology
India

Skills

Databricks

SSMS SQL Server

Microsoft Azure

Cloud Computing

Python

Designing Data Solutions

Oracle Toad

PL/SQL

Azure Data Factory (ADF)

COSMOS DB

Azure Functions

Azure Synapse

Oracle

DBSchema

ER Studio

Microsoft Azure Data Lakes

Synapse Analytics

Azure Purview

Python IDE

PyCharm

Visual Studio Code

Power Shell

Performance Tuning

Database Design

Data Migration

BigData

Public Sectors

Utilities

Event Hub

Stream Analytics

Medallion Architecture

Azure Data Lake

Mapping Data Flow

XML

Unix shell scripting

Data Modelling

Oracle

Java

C

C

Certification

Databricks Certified Data Engineer Associates

Currentposition

EXL Services, Senior Manager Data Engineering, London, England

Personal Information

Total Experience: 16+ years

Timeline

Databricks Certified Data Engineer Associates
06-2024

Senior Manager Data Engineering

EXL Services
04.2024 - Current
Microsoft Certified Azure Fundamentals
02-2022

Data Architect / Lead Data Engineer

Agilisys
12.2021 - 04.2024
Microsoft Certified Data Fundamentals
03-2021
Microsoft Certified Data Engineer (Passed DP200 and DP201 Exam)
01-2021

Azure Data Integration Engineer

Tata Consultancy Services (TCS)
12.2019 - 11.2021

Sr. Data Engineer

Tata Consultancy Services (TCS)
05.2016 - 11.2019

Developer

Tata Consultancy Services (TCS)
11.2015 - 04.2016

Database Developer, Program Analyst

Tata Consultancy Services (TCS)
01.2014 - 10.2015

Data Engineer

Tata Consultancy Services (TCS)
09.2011 - 04.2013

Developer

Birla Soft
09.2010 - 08.2011

Database Developer

Nucleus Software
12.2007 - 09.2010

Master of Computer Application - Computer Application

Jaypee Institiute of Infomration Technology
Vikas SharmaSenior Manager Data Engineering