Summary
Overview
Work History
Education
Skills
Websites
Certification
Consulting Skills
Industry Domains
Professional Experience Summary
Project Experiences
Visa
Personal Information
Timeline
Generic

Sushant Kumar

Dallas,TX

Summary

As a Data Management leader, I bring extensive expertise in organizing, enhancing, and optimizing data assets within organizations. My 14+ years of professional summary highlights a track record of successfully leading teams in the implementation and maintenance of robust data cataloging and data governance and MDM systems. I excel in developing strategies for metadata management, master data management, ensuring data quality, and fostering collaboration between data stakeholders. My proficiency includes defining metadata standards, establishing data governance frameworks, and overseeing the creation of comprehensive data dictionaries. My leadership extends to driving initiatives that align with industry best practices and compliance standards.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Manager

Deloitte Consulting LLP
01.2015 - Current

Consultant

Infosys Ltd.
01.2011 - 01.2015

Business Analyst

Tech Mahindra Ltd.
06.2009 - 01.2011

Education

Master's (MBA - IT) -

Symbiosis University
01.2009

Bachelor's (Computer Science Engineering) -

M.P.U.A.T, University
01.2007

Skills

  • Data Catalog: Alation, Collibra, Informatica EDC
  • Data Governance: Alation, Collibra, Informatica CDGC, AXON
  • Data Quality: Informatica Data Quality (IDQ/CDQ), Collibra DQ
  • MDM: Informatica MDM, Informatica C360, Informatica Ref360
  • Reporting: Tableau, PowerBI, SQL
  • Datawarehouse / Business Intelligence: OBIEE 11g, OBIA
  • Cloud: AWS

Certification

  • Alation Data Catalog Consultant
  • Informatica MDM 10.4 Certified
  • AWS Certified Cloud Practitioner
  • Oracle BI Suite 11g Certified Specialist

Consulting Skills

  • Requirements Gathering, Process Discovery, Current State Assessment
  • Technology Assessment, Tool Evaluation and Comparison
  • Project Management, Project Estimation, Project Planning
  • Focus Groups, Workshops, & Presentations
  • Customer Relationship Management
  • Cross-Functional Collaboration
  • Excellent verbal and written communication skills

Industry Domains

  • Manufacturing
  • Hi-Tech
  • Life-Sciences

Professional Experience Summary

Data Management (Data Catalog, Data Governance, Data Quality)

Project Experiences

  • Alation Data Governance & Data Catalog Implementation, Manager, Data Catalog and Governance Lead (Deloitte), 08/2023, Present, Global Paper manufacturing firm wanted to leverage the Data catalog tool to enable teams for finding data faster and facilitate collaboration among teams. The scope of the project included, tool vendor evaluation and selection followed by data catalog implementation phase., Conduct assessment for Alation, Collibra and Informatica CDGC and generate tool comparison summary, Develop data catalog onboarding roadmap and high-level implementation timeline, Define data catalog team structure and detailed roles and responsibilities, Develop Alation's data catalog governance framework, establish data policies and standards, Review data consumption requirements and conduct infrastructure sizing discussions with vendor, Seamless integration with other enterprise applications like Access Management, Incident Management and Data Quality tools, Prioritization of new data sources for scanning and enablement of data catalog capabilities such as business glossary, data profiling, data lineage, data classification and metadata import, Connect Alation with multiple source systems such as AWS Data Lake, Salesforce, Qlikview, PowerBI etc. to scan and ingest metadata into data catalog, Discuss and define the critical configuration items for Alation data catalog i.e. Domains and Subdomains, User Roles, User Groups, Data Privacy requirements etc., Define and create templates for Business Glossary, Business terms, Articles, Policies, Define data security framework, Define approval workflows for governance of data catalog objects (create, update, delete), Bulk upload of business terms, articles and policies defined by various stakeholder teams, Provide training to client teams, enabling them to perform the responsibilities of Catalog Admin, Data Source Admin, and Data Steward, Migration of data objects from lower environment to production, Alation Cloud Data Catalog/Governance, AWS
  • Alation Data Catalog, Data Governance, Data Quality & Big ID Implementation, Manager, Data Governance & Catalog Lead (Deloitte), 09/2022, 08/2023, Global Computers manufacturing and services firm decided to upgrade their IT landscape by implementing complete Data management solution. The project scope included, defining an enterprise solution architecture with applications shortlisted by client and migrate the existing data from Collibra data catalog to Alation data catalog, Develop enterprise application integration architecture including Alation (Data Catalog, Data Governance), BigID (Data Classification), Manta (Data Lineage) and IDQ (Data Quality), Develop integrated project plan to track the development and dependencies of each module and application, Review future data consumption requirements and conduct infrastructure sizing discussions with vendors (Alation, BigID and Manta), Work with client platform team and setup infrastructure for Alation, BigID and Manta, Develop data quality framework, data quality operating model, Define data quality rules, metrics and KPI's by capturing requirements from business stakeholders, Complete configurations for Alation: Domains and Subdomains, User Roles, User Groups, Business Glossaries, Business terms, Policies, Articles, Access and Permissions etc., Complete configurations for BigID: Classifications Categories and Subcategories, define RegEx for custom classification groups, Configure and scan metadata from source systems into Alation, Configure and scan source systems using BigID for data classification, Develop migration strategy for data catalog objects from Collibra to Alation, Conduct E2E systems integration testing, BigID to Alation integration for data classification tags, Manta to Alation integration for Data lineage, IDQ (data quality) to Alation integration for data quality metrics, Develop systems and business teams onboarding plan, Provide training to business and IT users on new systems (Alation, BigID, Manta, IDQ), Alation Data Catalog, BigID, Manta, Informatica IDQ
  • Data Quality Strategy and Implementation, Manager, Data Quality Lead (Deloitte), 03/2022, 09/2022, Global Pharmaceutical firm was looking for establishing an enterprise Data Quality solution to track the data issues at each step of the HCP/HCO process. The project included, tool vendor evaluation and selection followed by implementation phase., Conduct assessment for Informatica Cloud data quality, Collibra data quality and Ataccama data quality tools and prepare a comparison summary to reflect best fit for organizations needs, Conduct POCs/pilot testing of the data quality tools to assess ease of use and real-world performance, Review data profiling results with clients and capture data quality rule requirements, Define data quality scorecards for DQ dimensions (Validity, Completeness, Accuracy etc.), Develop data quality rules for HCP/HCO critical data elements using Informatica Cloud Data Quality Assets such as Rule Specification, Data Dictionary, Cleanse, Parse, Develop rules for address validation and standardization to append Geo Coding details using Verifier asset, Develop mapplet and mappings for standard data quality checks like null check, format check, data type check etc. that can be reused for executing checks against multiple tables/ columns in a data integration pipeline, Develop reporting data model and physical schema in Postgres DB to capture Data quality rules execution results and metrics, Develop data quality dashboard and reports using PowerBI to monitor health of the HCP/HCO data by data owners, Informatica Cloud Data Quality, Python, Postgres DB, Power BI
  • Customer MDM, Data Governance, Data Catalog Implementation & Product MDM Data Model Design, Manager, Customer MDM (Deloitte), 04/2021, 03/2022, A Global Cloud computing and virtualization technology company wanted to implement a customer MDM solution to consolidate and streamline their customer data to increase operational efficiency. Client also wanted to implement data catalog and governance solutions to maintain the customer master data. Client had chosen full informatica product stack (Informatica Customer360, Informatica EDC, Informatica AXON, IDQ) for the Customer Master solution. The project included planning, design, implementation phase for customer MDM., Conduct discovery sessions to capture the definition of a "customer" that meets current and future business objectives, Capture current state systems and attributes for customer master, Develop logical data model, data dictionary and physical data model for customer master, Develop the source to target attributes mapping for customer master, Review and discuss sales hierarchy and legal hierarchy requirements, Develop Customer Core data enrichment process (Acquire, Enrich and Synchronize), Conduct review sessions business and data architect to understand the Match needs, source system trust scores, data model and pre-landing/landing table structures, Define the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups, Led development of integration via services integration framework (SIF) and the Business Entity Services, Define conceptual model, Data domains, Business glossaries and terms in AXON, Scan metadata from source systems in EDC, link EDC data sets in AXON., Define policies, data quality rules in AXON and generate and execute DQ rules in IDQ, Define roles and access permissions in AXON for data governance and stewardship, Integrate DQ metrics from IDQ to AXON, Informatica Customer360, Informatica AXON, Informatica EDC, Informatica Data Quality
  • Customer MDM Assessment, Reference MDM Assessment & Data Model Design, Sr Consultant, Customer MDM (Deloitte), 10/2020, 03/2021, A Global Computers manufacturing and services firm wanted to assess the maturity of the organization to develop the roadmap and timelines for Customer and Reference MDM. The project scope included, capturing the current state systems and process, define future state MDM architecture and develop high level customer data model, Conduct discovery sessions with stakeholders to capture current state systems and processes where customer master data and reference data is captured, Document key pain points and business challenges faced by team due to bad customer and reference master data, Capture critical data elements (CDEs) and high-level attributes for customer master data, Capture the current list of Reference data items along with their source systems, Perform fit-gap analysis of the client's customer MDM requirements with Informatica's Party data model, Develop high-level data model for Customer MDM using Informatica's Party data model to address client's requirements, Review the MDM implementation styles (Registry model, Consolidation model, Coexistence model, and Centralized model) and discuss pros and cons of each based on client's requirements, Develop Customer MDM and Reference MDM architecture and define high-level integrations with other enterprise applications, Informatica MDM 10.4, Microsoft Visio, Microsoft PowerPoint, Microsoft Excel
  • OBIEE 11g/ OBIA Implementation - Supply Chain and Finance Analytics, Functional Consultant (Deloitte), 09/2015, 10/2016, US based ATM manufacturing firm was upgrading their legacy ERP system to Oracle EBS. As part of the modernization effort client wanted to leverage OBIEE 11g and OBIA to establish data warehouse and reporting solution that can complement Oracle ERP solution. The project vanilla setup of reports and dashboards, followed by customization of reports for Finance and Supply Chain Analytics module., Setup the vanilla OOB dashboards and reports for Oracle BI Applications, Showcase the OOB reports to business users in meetings and workshops and capture their requirements, Prepare mock-up reports by leveraging the existing OBIEE dashboards, prepare proof of concepts and present it to the client teams, Translate business and user requirements into accurate system requirements specification documents through systems and data analysis, Develop reports using OBIEE Answers generate different Analytics Views (Pivot Table, Chart, Column Selector and Table), Analyze the amount of customization required in reporting (RPD/Web Catalog) and ETL layer for reports which are not available through OOB model, OBIEE 11g, Informatica PowerCenter 9.5, Oracle SQL Developer

Visa

H1B, I140 Approved

Personal Information

Title: Data Management SME

Timeline

Manager

Deloitte Consulting LLP
01.2015 - Current

Consultant

Infosys Ltd.
01.2011 - 01.2015

Business Analyst

Tech Mahindra Ltd.
06.2009 - 01.2011

Master's (MBA - IT) -

Symbiosis University

Bachelor's (Computer Science Engineering) -

M.P.U.A.T, University
Sushant Kumar