Summary
Overview
Work history
Education
Skills
Certification
Additional Information
Custom
Personal Information
Languages
Timeline
Generic
SHIKHER SINGH

SHIKHER SINGH

Watford,London, City of

Summary

Experienced architect/specialist offering 15 years of experience helping customer to solve world's toughest data and AI problems. Highly skilled in Data Engineering, Enterprise Data warehousing, Delta Lake implementation and Data Governance Solutions to ensure ongoing efficiency and achievement to modernise Customer Data Platform.

Overview

15
15
years of professional experience
1
1
Certification

Work history

Data Solution Architect

Accenture
London, London
03.2024 - Current
  • Accountable to engage and accelerate decision-making in establishing a Data & AI foundation for customers
  • Assessed the requirements and enterprise principles to design a target platform architecture, specifically leveraging Azure and Databricks for a comprehensive data foundation. Accountable to increase the efficacy of the customer Databricks platform, as well as the technology, process, organisational structure and operating model supporting it.
  • Reviewed customer current data quality mechanisms, Databricks platform lakehouse buildout, best practices on medallion Architecture, Unity Catalog set-up assessment, performance and cost management, Databricks new feature adoption and recommendations provided accordingly.
  • Designed data pipelines, data lakes, and data warehouses that enable efficient data processing and analytics on the Databricks platform and assisted in the actual implementation and deployment of Databricks solutions, ensuring they meet the customer's requirements and best practices

Paternity Break

Paternity Break
London
12.2023 - 02.2024

Learnt a lot about being parents of little one.

  • Carried out day-to-day duties accurately and efficiently.
  • Quickly learned and applied new skills to daily tasks, improving efficiency and productivity.

Resident solution Architect, Professional Services

databricks
London
02.2023 - 11.2023
  • Engaged with customers to understand their data architecture, analytics, and machine learning needs, and proposing solutions that align with Databricks' platform capabilities
  • Designed data pipelines, data lakes, and data warehouses that enable efficient data processing and analytics on the Databricks platform
  • Assisted in the actual implementation and deployment of Databricks solutions, ensuring they meet the customer's requirements and best practices
  • Collaborating with existing data systems, data sources, and other tools to create an integrated and cohesive data analytics ecosystem
  • Provided technical support and troubleshooting assistance during and after the deployment of Databricks solutions
  • Conducted training sessions for customers to enable them to effectively use the Databricks platform and get the most out of their data
  • Promoted best practices for data engineering, data science, and machine learning on the Databricks platform
  • Key contributor to drive 100% booking and 87 % revenue at databricks EMEA region during Q2 while closely working with 100k + customers

Principal Data Engineer

Norton LifeLock, Ireland Limited
11.2020 - 12.2022
  • Responsible for architecting, designing, developing data lake for NLOK telemetry on AWS using EMR, Glue, S3, Athena and Spark
  • Prepared consumption layer to visualize data on Quick Sight
  • Responsible for doing POC, building architecture for enhancement, data governance, and securityas well as integration with other companies after merger & acquisition
  • Recently implemented governance for Quick Sight and Athena usage and analytics using serverless architecture such as lambda, Athena, S3 and CloudWatch
  • Completed POC for alternative solution for Elasticsearch Stack to serve researchers
  • Responsible to set-up best code practices in production as well as infrastructure management using terraform
  • Also, built dashboard for CTO by visualizing aggregated file and URL based blocks by Norton product past few months
  • Similarly, I helped various partners by visualizing dataset based on types of threats blocked.

Technical instructor - Spark and AWS

UCD/SimpliLearn/Edureka
06.2017 - 11.2020
  • Developer courses to experienced professionals, trained almost 350 working professionals in last 3 years.
  • Streamlined technical instruction process to enhance team productivity.
  • Held regular review sessions before examinations, boosting confidence and reducing test anxiety amongst learners.
  • Created accessible learning materials, promoting self-study and continuous learning.
  • Encouraged active participation during class discussions, fostering a collaborative learning environment.
  • Fostered a conducive learning environment, ensuring maximum knowledge retention.

Cloud architect

Accenture Services Solutions Ltd
Bangalore
10.2016 - 08.2019
  • Responsible for architecting, designing, developing solutions for clients, and delivering technical workshops, performing POC specific for customers focusing migration from on-premises to Cloud Data Warehouse (AWS and GCP)
  • Worked closely with Amazon and Cloudera as a partner to work on technical solution and on client offerings and assisted pre-sales team from technical point of view for cloud migration.
  • Built an Accenture offering to migrate on-premises Data Warehouse into Cloud based solutions In an automated process, the offering can migrate any on-premises database service into AWS (Redshift, S3, EMR), Snowflake, Google Cloud Platform (Big Query, Cloud Storage) based on customer interest
  • Accenture SPOC to build partnership with Cloudera Organization by organizing different workshop of Cloudera Cloud offerings, building the road map for Accenture-Cloudera joint solutions, building capability within Accenture on different Cloudera offerings/ services
  • Accenture SPOC to do POC with Attunity Organization by installing Attunity Visibility on GCP platform and it had become part of successful delivery of this product on GCP. Attunity Visibility, a tool to be used by customers to analyze and predict their historical data to move to cloud. Also, Involved in POC using Ni-Fi, Cloudera Navigator part of Accenture RFP response Solution team for any cloud-based data warehousing/RDBMS

Sr, Teradata DBA

JSainsbury's, Tata Consultancy Services Limited
London
03.2015 - 09.2016
  • Worked as a Senior Teradata DBA for JSainsbury's in London and taken care of their 5 Teradata boxes including Prod, Pre-prod, Dev, Test, UAT, Involved in BAR operation using TARA & DSA
  • Implemented new BAR solution DSA successfully on 4 BAR Servers, built the entire Teradata box from beginning to Enterprise Data Warehouse
  • Mentored and led DBA team in JSainsbury's., Involved in upgrade from Teradata 14.10 to Teradata worked as a Tuning expert, query rewriter, View-point Monitoring, TASM monitoring, involved in TTU deployment and installation

Big data Consultant

Tata Consultancy Services Limited
Gurgaon
03.2012 - 03.2015
  • Worked as a Hadoop Developer in implementing Big Data Solution for client Data Warehouse
  • Involved in extracting data from Teradata using Sqoop and ingesting file into HDFS, involved increating Hive tables, loading with data, map joining, some arithmetic operation and writing hivequeries that will run internally in map reduce way
  • Involved in generating reports for MSTR, SAS, Pentaho and B2B users and handled a team of 25members for Teradata & Informatica Development

Programmer Analyst

Tata Consultancy Services Limited
Gurgaon
09.2010 - 03.2012
  • Carried out requirement analysis of Functional Requirements and Conceptual Design and implementation, prepared high-level design for client business process and enhancements
  • Mentored new team members for corporate action activities, worked for Canadian Clearing and Depository Services as a programmer analyst, developed TCS B@NCS Corporate action module SWIFT functionality specific to the needs of customer
  • Involved in code walkthroughs and peer reviews, designed the solutions according to client's needs
  • Prepared the detailed plan for the development of the Business requirements and Enhancements Projects

Education

Master of Science - Computer Science - Data Science

Trinity College, University of Dublin

Bachelor of Technology (B. Tech.) - Computer Science

G.B. Pant University of Agriculture & Technology

Skills

  • Databricks platform, Unity Catalog, DLT, Spark, Delta Lake, ML Flow, Platform Security, Azure Networking,
  • Azure Synapse, Delta Sharing, AWS- Glue, Athena, Quick Sight
  • Redshift, S3, EC2, EMR, SCT, Snowflake, GCP- Big Query
  • Cloud Storage, Terraform, CI/CD
  • Tool - SQL workbench, Aqua Data Studio, Bit-Bucket
  • Big Data- Hadoop Ecosystem Tools, Cloudera, Hadoop, Hive
  • Impala, Sqoop, Spark, Flume, Pig, HBase, MapR, MPP
  • Database- Teradata (16,14,12), Redshift, RDBMS- Oracle, MySQL
  • Languages- Python, Scala, UNIX Shell Script, PL/SQL, Jupiter Notebook, SQL
  • ETL Tool- Informatica 9,10, 915, Glue, DLT, Structured Streaming
  • Operating System - UNIX, Windows, LINUX, MacOS
  • Database performance, Systems design, Technology architecture analysis
  • Sybase PowerBuilder 105 g, Teradata Client
  • SQL Advantage, Teradata Admin, Teradata Index Wizard
  • Informatica Power Centre, Attunity Visibility, Apache Ni-fi

Certification

Databricks Certified Spark Developer python 3.0

Databricks Certified Data Engineer Associate/Professional

Cloudera Certified Spark and Hadoop Developer (CCA 175)

AWS Certified Solution Architect- Associate/Professional

Teradata 14 certified professional, Teradata 14 Certified SQL professional.

AWS Certified Data Analytics Specialty

Certified in Data Science Intensive by Springboard

Internet of Things: How did we get here by Coursera Intermediate Python for Data Science by Data Camp

AI for Trading Nanodegree - Udacity

GCP certified - Professional Data Engineer

Certified in Financial Market: A Beginner's Module by National Stock of Exchange

ITIL 2011 Foundation Certified

Additional Information

Awards and Achievements: ,

  • Awarded (In FY16-17) with Celebrates Excellence Award in TCS for implementing DSA architecture successfully
  • Awarded (In FY14-15) with Star of the Month for exceptional delivery.
  • SDTT tool built is adopted in Cloudera Data PlatformExtra Curricular/Participation Class Representative of Data Science Strand in TrinityCollege Dublin during Masters
  • Public Speaker and trainer in databricks Data AI Tech Summit

Custom

6

Personal Information

Languages

English

Timeline

Data Solution Architect

Accenture
03.2024 - Current

Paternity Break

Paternity Break
12.2023 - 02.2024

Resident solution Architect, Professional Services

databricks
02.2023 - 11.2023

Principal Data Engineer

Norton LifeLock, Ireland Limited
11.2020 - 12.2022

Technical instructor - Spark and AWS

UCD/SimpliLearn/Edureka
06.2017 - 11.2020

Cloud architect

Accenture Services Solutions Ltd
10.2016 - 08.2019

Sr, Teradata DBA

JSainsbury's, Tata Consultancy Services Limited
03.2015 - 09.2016

Big data Consultant

Tata Consultancy Services Limited
03.2012 - 03.2015

Programmer Analyst

Tata Consultancy Services Limited
09.2010 - 03.2012

Master of Science - Computer Science - Data Science

Trinity College, University of Dublin

Bachelor of Technology (B. Tech.) - Computer Science

G.B. Pant University of Agriculture & Technology
SHIKHER SINGH