Jayraj Gupta

About Jayraj Gupta

Data-driven Engineering Specialist with 15 plus years of experience in Cloud Database Architecture, Database Design,Data Modeling, Data Analytical BI Solutions, and Data Integration implementation. Over 12+ years of experience in leading Data and BI Team in full SDLC of DW projects from Scoping, Analyzing detailed Business Requirements, Data Analysis, reviewing existing systems, cost, performance, and capabilities, architect Data warehousing, Designing databases, modeling Enterprise data models and data governance solutions, implementation of complex data integration processes in order to improve and build new BI Analytical systems.· Gained Expert-level skills while working in industries - FIAT CHRYSLER Automobiles, Ford Credit and Delphi Automotive in DW design, Multi-dimensional Enterprise data models, Data pipelines implementation, BI Dashboards design using wide range of database platforms and ETL/BI tools -Snowflake,Azure,Teradata, DB2,Oracle,Power Designer,Erwin,Qlik Sense,Qlikview,Cognos,Business Objects,Power BI,DataStage,Informatica,ADF,Hadoop Spark programming, PySpark etc.· 10+ Years of specialization in conducting Proof Of Concepts and rapid prototyping a model to find the most efficient BI solutions. Successfully completed several POCs using different data integration, BI tools such as Kafka, Google Cloud BigQuery, Azure HD Insight, Apache Beam, and SQL DBM by prototyping a model to demonstrate efficiency and cost savings.· Vast experience in completing the migration of various Legacy systems into modern databases like Snowflake by laying out a detailed plan, using the right tools and procedures, and creating technical documentation to guide and instruct the team.· Excellent experience in estimating query load, security role-based access control hierarchy,scripts/pipelines, azure blob storage, and Snowflake tools to migrate huge historical data/ongoing data from Legacy systems into the modern databases like Snowflake.· Proficient in existing data model optimization, query profiling,warehouse, cluster sizing, setting up resource monitor, and building cost usage dashboards in order to help cut down the Snowflake or any database credit usage by different applications, and to optimize the large-size databases.· Highly skilled in designing Database architecture and Semantic model on any databases like Snowflake, implementing streaming real time data integration pipelines to consume operational raw data from various systems using integration solutions like Snowflake,Azure tools.

Experience

1. Data Architect

   Big Lots

   Sep 2020 — Present · Columbus, OH, US

Education

• Biju Patnaik University of Technology (BPUT)

  Bachelors of Science, Information and Technology Engineering

• Biju Patnaik University of Technology, Odisha

  Bachelors of Science, Information Technology