Summary
Overview
Work History
Education
Skills
Certification
References
Project Management
Software Engineering Methodologies
References
Timeline
Generic

Khushmeet Singh

Katy

Summary

Dynamic Technical Architect with extensive experience at TCS Ltd, specializing in Snowflake and BigID solutions, demonstrating expertise in designing robust data governance frameworks and enhancing data security while leading global teams.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Technical Architect

TCS Ltd
08.2023 - Current
  • Coordinated a team across the globe to provide support. Worked with the user and client team to understand the BigID and Snowflake Data Platform solution architecture, design, development, and deployment, focused on bringing a data-driven culture across the enterprises.
  • Designed and deployed dynamic data masking policies within Snowflake to protect sensitive data based on user roles, ensuring compliance with regulatory standards.
  • Leveraged BigID to automatically discover, classify, and catalog sensitive data across Snowflake environments, enabling streamlined governance and security protocols.
  • Implemented warehouse resizing methods and various performance tuning features to improve the performance of large and complex queries against large data sets, complex joins, and loading/unloading significant amounts of data.
  • Used BigID's automation capabilities to identify new data sources and continuously monitor data for compliance risks, reducing manual oversight in large datasets.

Snowflake Architect

Corporate Solutions General
04.2022 - 08.2023
  • Responsible for designing and implementing robust security policies to ensure that sensitive data is protected from unauthorized access. This may include defining user roles, access controls, and data classification policies.
  • Designing and implementing data models and schemas in Snowflake to support business requirements.
  • Created Functions and procedures to handle Automatic Data type issues in Migration and developed queries to debug issue in Snowflake Vs Teradata Databases.

Solution Architect/ Sr. Data Engineer

FMI, USA
02.2021 - 03.2022
  • Developed DBT models with Python and Snowflake for efficient data warehouse integration.
  • Created mapping documents to clarify data flow from sources to targets.
  • Collaborated with data engineers and analysts to enhance quality of data pipelines.
  • Led weekly code reviews, training Development and DA teams on Snowflake standards.
  • Implemented data governance policies to ensure accuracy and security of data.
  • Registered datasets in Nebula for streamlined metadata management.
  • Supported Data Masking and Warehouse solutions, maintaining production stability.
  • Delivered cost-saving solutions through Time-Travel and Warehouse modifications.

SAP HANA Specialist

Exxon, USA
The Woodlands
09.2019 - 01.2021
  • Collaborated with Agile teams utilizing Azure DevOps to ensure timely project delivery.
  • Led engineering team in optimizing data ingestion and visualization processes.
  • Facilitated architecture discussions to align team objectives with business goals.
  • Developed complex ETL pipelines for seamless data integration into data lake.
  • Conducted workshops and whiteboarding sessions to gather requirements from business users.
  • Utilized Snowflake tools, including SnowSQL and SnowPipe, for efficient data management.
  • Monitored data usage and performance to identify optimization opportunities.
  • Designed disaster recovery and business continuity plans for Snowflake environments.

Lead Consultant (Solutions) – Data

IBM GBS US
08.2018 - 09.2019
  • Designed and implemented solutions for Data Governance and GDPR compliance.
  • Developed architecture for Customer 360 initiatives and cloud migration strategies.
  • Crafted data pipelines, ensuring security and adherence to GDPR frameworks.
  • Engineered data lakes and warehouses in Snowflake for batch and real-time processing.
  • Executed SnowSQL, Python, and SQL commands for effective data management.

Lead Consultant (Solutions) – Data

XCEL Energy– USA
01.2018 - 07.2018
  • Gather customer business and technical requirements and write requirements documents.
  • Worked on numerous BW on HANA models in FI-GL, FI-AR, FI-AP, CO-CCA, CO-PCA, Custom Pricing workbench and contract management functional areas leveraging LSA++ architecture and new BW modeling objects and capabilities like Composite Providers, ADSO and hybrid modeling.
  • Translating the business requirements into SAP Information models and mapping them into SAP system to build and develop high-end reports.
  • Meeting Client expectations. Initial hand holding during setup and solution/setup implementation.

Lead Consultant (Solutions) – Data

SCHLUMBERGER –USA
10.2016 - 01.2018
  • Conduct and coordinate mapping meetings with legacy system IT and business users for interfaces, conversions, and processes affecting in the legacy system.
  • Ingested data from API, on-prem DB, loaded to snowflake, perform snow analytical query to transform data, and visualize using powerbi (ELT).
  • Solution design and implementation especially in areas like Data Governance, GDPR solution, Customer 360, On premise to Cloud Migration, Cost Optimization using open-source data ingestion/visualization.
  • Design and develop attribute, analytic and calculation views on SAP HANA using SAP HANA Studio 1.0 using SAP HANA Live and Simple Finance 2.0 Add-on.

Solution Consultant

Abbott Laboratories –USA
07.2015 - 09.2016
  • Gathered business requirements for logical and physical design of attributes, analytical views, and calculation views.
  • Analyzed and translated business requirements into technical specifications and architecture.
  • Migrated core business logic to calculation views, database triggers, and stored procedures.
  • Developed proof of concept for setting up SLT replication between SAP ECC and SAP HANA.

Solution Consultant

Bio-Rad –USA
01.2015 - 07.2015
  • Involved in Analysis, information gathering, development, testing, Support. Creation of process flows, test strategies, business, and architecture discussions.
  • Involved in extracting data from SAP ECC to SAP HANA through BODS, Data Stage. Supported the user community in addressing HANA related issues.
  • Responsible for effective communication between the project team and the customer. Provided weekly and monthly status reports to the higher management on team status.

Solution Consultant

Air Products and Chemicals, Inc. –USA
01.2013 - 01.2015
  • Feasibility and pre-requisite check for SAP HANA and created Schemas and Users for HANA.
  • Modeling – Creating Attribute / Analytical and Calculation views (Graphical/Scripted). Used my SQL knowledge to fulfill complex requirements using Sidecar Scenario.
  • User Management and Security in HANA – Creating Analytical Privileges.
  • Performance tuning of calculation scenarios using SQL Script guidelines.
  • Integration of HANA models with SAP BO BI Platform 4.0 and activated the uploaded Scenarios for data read from HANA DB.

Solution Consultant

Avantor –USA
03.2010 - 01.2013
  • Given training to the BW Core team members and process owners to understand BW Concepts.
  • Interact with the senior management and Power Users of Business to understand the business needs and SAP Developments in accordance with the IBM and Client Standard.
  • To Mentor the core team and lead them in a progressive manner to train the IBM team members.
  • Modeling of non-SAP Source System like Flat File and DB Connect, UD Connect Systems.
  • Design and Implemented 6 dashboards end to end from extraction, modelling, and Bex Reports.

Software Engineer

Accenture Services
02.2007 - 03.2010
  • Executed technical implementation of ETL processes using Informatica for job design and build.
  • Designed data warehouse entities to support reporting and analysis needs.
  • Coordinated scheduling and orchestration activities across multiple teams to ensure timely delivery.

Education

Bachelor of Technology - Electronics and Communication

Dr. A. P. J. Abdul Kalam Technical University
India
06-2006

Skills

  • Snowflake and BigID
  • SAP BW/4HANA and Native HANA
  • Ab Initio and Snowpipe
  • Change data capture (CDC)
  • Web Intelligence and Informatica
  • Central Management Console (CMC)
  • Power BI and Tableau
  • SQL and Python
  • Qlik Replica
  • S3 and Blob Storage
  • Snow Convert and SQL Database
  • Azure CI/CD and ADF (Azure Data Factory)
  • Data modeling and ETL processes
  • Data integration and problem solving
  • Business solutions

Certification

Snow Pro Certified, BigID fundamentals

References

Available upon request.

Project Management

  • Azure Boards
  • Sprint Planning

Software Engineering Methodologies

  • Agile
  • SCRUM
  • Waterfall

References

References available upon request.

Timeline

Technical Architect

TCS Ltd
08.2023 - Current

Snowflake Architect

Corporate Solutions General
04.2022 - 08.2023

Solution Architect/ Sr. Data Engineer

FMI, USA
02.2021 - 03.2022

SAP HANA Specialist

Exxon, USA
09.2019 - 01.2021

Lead Consultant (Solutions) – Data

IBM GBS US
08.2018 - 09.2019

Lead Consultant (Solutions) – Data

XCEL Energy– USA
01.2018 - 07.2018

Lead Consultant (Solutions) – Data

SCHLUMBERGER –USA
10.2016 - 01.2018

Solution Consultant

Abbott Laboratories –USA
07.2015 - 09.2016

Solution Consultant

Bio-Rad –USA
01.2015 - 07.2015

Solution Consultant

Air Products and Chemicals, Inc. –USA
01.2013 - 01.2015

Solution Consultant

Avantor –USA
03.2010 - 01.2013

Software Engineer

Accenture Services
02.2007 - 03.2010

Bachelor of Technology - Electronics and Communication

Dr. A. P. J. Abdul Kalam Technical University

Similar Profiles

CREATE PROFILE