Sanjeev Sanjeev Kumar Kumar

About Sanjeev Sanjeev Kumar Kumar

Total 12+ years of IT experience in Business Intelligence: Requirements analysis, Key Performance Indicators (KPI), metrics development, sourcing and gap analysis, OLAP concepts and methods, aggregates / materialized views and performance, rapid prototyping, tool selection, semantic layers Data Modeling, Dimension Modeling, Normalization, Data Vault 2.0 Data Warehousing: Full life-cycle project leadership, business-driven requirements, capacity planning, gathering, feasibility analysis, enterprise and solution architecture, design, construction, data quality, profiling and cleansing, source-target mapping, gap analysis, data integration/ETL, SOA, data marts, Kimball methodology, star/snowflake design, ODS, Data Marts Data Analytics, Statistical method, Predictive Modeling, Forecasting, Trends, Data-Driven Technology, Big, Data Mining, Machine Learning, and Data Visualization. DBA/Developer in Production, Development, Test and, Data warehousing environment in Teradata, Oracle, SQL Server, Snowflake, Bigdata TOGAF/Zachman framework enterprise strategy and architecture, business requirements definition, guidelines and standards, process/data flow, conceptual / logical / physical design, performance, partitioning, optimization, scalability/throughput, data quality, exception handling, Metadata, Master Data design and implementation, auditing, capacity planning, use cases, traceability matrix etc.

Experience

1. Data Architect Dba Developer

   Pronix Inc

   Aug 2016 — Present · Miami, FL, US

   Role Architect/Developer/DBA/Technical LeadClients 1) Wex Inc.2) Geisinger3) Wawa Inc.4) AT & T• Working as Data architect/developer.• Responsible for detail architectural design.• Provided the complete roadmap for cloud migration on Azure from on premise.• Responsible on Source to target mapping and traceability matrix.• Working on Normalization, Canonical modeling, Data Vault 2.0, Data modelling, Normalization, Dimension Modelling, Database Designing using Erwin.• Working on conceptual, logical, and physical data model using Erwin.• Working on Migration to snowflake• Setup snowflake environment for all data warehouse need.• Set up external/internal stage for snowflake.• Working on Snowflake stream, data lake, task, procedures etc.• Worked on performance and tuning of data in snowflake environment• Worked on cost analysis for snowflake virtual ware house• Set up data sharing in snowflake environment• Set task and stream object on table for streaming in snowflake.• Worked on data masking and security in snowflake.• Validation before loading data to table, force, purge option, history view, copy command, snowpipe etc. in snowflake• Used feature like Fail safe, clone, time travel, table retention, data sampling, undrop, table swap, data sharing in snowflake • Working on delta lake (Lakehouse) in databricks• Performance & tuning of delta lake in Databricks like compaction, vacuum, indexing etc.• Created view (Stored, temporary, global) in Databricks• Created external tables, loaded data from external files into tables etc.• Worked on structured streaming in Databricks• Loaded incremental data through copy and auto loader• Build Complex distributed systems involving huge amount data handling in table types (column store, Heap, cluster Index) and its distribution (Replication, Hash, Round Robin) in Azure SQL warehouse.• Written and executed complex SQL, T-SQL and PL/SQL queries in Oracle, Snowflake, SQL server

Education

• Punjabi University

  Master of Computer Applications - MCA, Computer Science

Skills

• Teradata
• Oracle
• Requirements Analysis
• Database Administration
• Vendor Management
• Agile Methodologies
• Data Architects
• Disaster Recovery
• Nosql
• Business Analysis
• Micro Service
• Pl/Sql
• Sdlc
• Solution Architecture
• Unix
• Data Modeling
• Microsoft Sql Server
• Composites
• Dimensional Modeling
• Teradat
• Testing
• Olap
• Teradata Data Warehouse
• Data Warehouse Architecture
• Sql
• Postgresql
• Service-Oriented Architecture (Soa)
• Data Warehousing
• Business Requirements
• Enterprise Software
• Data Quality
• Enterprise Architecture
• Mysql
• Dba
• Exadata
• Business Intelligence
• Informatica
• Data Architecture
• Big Data
• Architecture