Sudhanshu Grover Email & Phone Number

Troy, Mi, Us

Teaneck, New Jersey, Us

I am currently working at Cognizant, a leading global provider of IT, consulting, and business process services, where I help clients transform their data assets into strategic advantages. • Created Data Architecture roadmap, Data Modeling framework and Data Governance strategy for merger of various Banking institutions and Retail chains• Engaged primary stakeholders to carve out a bi-temporal data modeling approach for integrating bank loans, collaterals, facilities, parties and regulatory data residing in Azure based Snowflake environment• Created Logical and Physical data models for Operational and SCD 2/5/7 enabled Dimensional environments using ERWin with Data Movement capability to show full lineage between source and target• Created an outside-the-box solution to create data lineage mappings of use cases (from Data Landing to Staging to MDM to ODS and/or Data Marts to Consumption) using a seamless approach showing detailed attribute transformations, from one Data Model to the next, as data traverses across various platforms• Carried out source system data analysis and data profiling exercise in Snowflake and Oracle/AWS enabled environments to gauge data quality and analyze metadata spectrum of all attributes, coming from disparate data sources, for Data Modeling purposes• Created Party Management Data Model solutions for a major US Banking institution that ingests data from various sources, verifies it against MDM “Golden Record” (Oracle and Hadoop based) data, and maintains hierarchical Party-to-Party relationship for downstream/consumption applications• Identified gaps in existing data management practice and proposed solutions to resolve and mitigate impact on various downstream/consumption applications• Mentored team members and conducted knowledge sharing sessions on advanced ETL strategies, data load parallelization and bulk data loading

Southfield, Mi, Us

• Created DW/BI framework and defined rules and guidelines for Data Management in transactional, ODS and Dimensional Data Warehouse environments• Constructed transactional (Normalized 3rd NF) and dimensional/analytical (Denormalized flat) logical and physical data models for integrated data management of disparate sources using ERwin, defined naming standards, compared various models for import/export, created lineage reports and other artifacts• Implemented materialized views for CDC (Change Data Capture), analyzed data storage requirements based on fact granularity and dimension expansion rate based on Type 2/4/5/7 SCD approach, defined source to target data mappings, created ground rules for data extraction, cleansing, transformation, loading and error handling• Managed and Spearheaded, design and development of full suite of Oracle based data integration repository consisting of polymorphically overloaded PL/SQL packages, procedures and functions using advance techniques like bulk data loading routines, dynamic SQLs, collection objects employing table functions and pipeline routines for dynamic data mapping, transformation and loading routines for DW environments, transactional data processing for OLTP applications, and capturing metadata for data quality, auditing and performance monitoring• Built Data Visualization and Analytical Tableau Dashboard and Stories to give an overall holistic approach with meaningful information for Business users to track KPIs using dynamic sliders for predictive analysis• Designed and created data segmentation and partitioning scheme for transactional database, Operational Data Store (ODS) and DW environment, conducted performance enhancement and query optimization using B-Tree/Bitmap indexes, optimizer hints and analyzing Oracle AWR reports• Evaluated and suggested technological advancements for AWS migration, created prototypes and presentations to demonstrate better data processing strategies using AWS

Irving, Tx, Us

Milwaukee, Wi, Us

Southfield, Mi, Us

Bethesda, Md, Us

Gurgaon, Haryana, In