Gourav Soni

Background

About Gourav Soni

Analytically minded accomplished professional Data Analyst - DWH/BI/Reporting and over 12+ years of experience in data analysis and data architecture. Ability to mine hidden gems located within large sets of structured and unstructured data. Skilled in the areas of agile development Data warehousing Business Intelligence and data analytics. • Experience in Design of High Level ETL SSIS Packages for integrating data using OLE DB connections from various Heterogeneous sources ( Excel CSV Flat File Oracle and Text Format Data) by using multiple transformations provided by SSIS. • Highly proficient in T-SQL for developing complex Stored Procedures Triggers Tables User Defined Functions Data Cleansing Relational Database models and Data integrity and SQL joins • Experience in Report Creation using SQL Server Reporting Services (SSRS). • Power BI tools – Power BI Desktop Power BI Dashboard calculated columns and calculated measures using DAX and data modeling. • Experienced in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs. • Experienced in designing and developing large amounts of enterprise reports using the data from ETL Loads SSAS Cubes and various data sources.