Shrey Gupta

Background

About Shrey Gupta

Expert level knowledge and experience with data modeling and database/data warehouse design within the public and private sectors. Highly experienced in the creation of business intelligence reporting environments that include Operational Data Stores (ODS), Data Warehouses and Data Marts. Provides technical leadership among business Intelligence, data warehouse and data integration partners. Solid track record of fostering strong internal relationships and effectively managing client expectations regarding service delivery. Demonstrates sense of urgency, strong commitment and accountability while making sound decisions and achieving goals; Independent problem solving skills and self-direction.Summary :• Successfully delivered 30 Data Warehouse, Business Intelligence, Data Integration/Conversion projects with 14 clients in Logistic, Retail, Insurance, Pharma, Finance & Health Care industry• Converting requirement specification, Source system understanding into Conceptual, Logical and physical Data Model, Data flow (DFD).• Worked extensively on Erwin, Power Designer and ER Studio in several projects in both OLAP and OLTP applications.• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.• Expert in conceptual, logical data modeling. 3rd Normal Form (3NF), Dimension Modeling, Star/snowflake Modeling for data warehouse, data mart• Leading team of developers/Architect offshore and onsite during the design, development and Testing phases and experience in working with multiple vendors.Specialties: Ralph Kimball & Bill Inmon methodology, Power Designer, Erwin and ER/Studio Data Modeling, Oracle, DB2, Netezza, SQL, Teradata, ETL Architect.