Prashanth Shetty Email & Phone Number

 Impressive success in developing and managing the design and delivery of complex Extract Transform & Load (ETL) integration streams, critical data migrations, legacy re-designing strategy and implementation, data architecture design and so on.Successfully worked on data warehousing methodologies such as Star Schema, Dimensions and Fact Tables for Data Modeling, DataExtraction, Data Transformation, Data Loading; developed unit testsand functional/integration tests & supported production deployments of developed solutions Possess in-depth expertise in:o BI and Data warehousing using SSIS 2008 /2012 /2016o SQL Server 2008/12/16 BIDS/SSDTo Database development using SQL Server 2008/2012o SSMS and Visual Studio 2008, 2010, 2015• Delivered solutions in migrating data from On-premises server to Azure by creating Azure SQL DB, Azure SQL DW and Azure Data Factory(ADF)• Well-versed knowledge of SQL profiler and Query analyzer to enhance performance of SQL server by tracing and tuning the query. Upgrade customer systems, database upgrades, data conversions, implementing tools in the Epicor framework. Installing and configuring Epicor E10.1 product (latest 10.1.600) EPICOR DB Upgrade from Vista/Vantage 8.03.405 to 10.1.xx versions. EPICOR DB Upgrade from 9.05 (Sql\SqlUnicode\Progress) to 10.1.xx versions. EPICOR DB Upgrade from EPICOR DB upgrade 10.1 to 10.2. Strong Knowledge of BAQ, BPM, Crystal Report & SSRS development.

Listed skills include Microsoft Sql Server, Sql Server Integration Services, Sql Server Reporting Services, and Sql.