• Architected a large scale Business Intelligence/Data warehouse platform for a well-known Media company using Microsoft SQL Server 2008 R2 Parallel Data warehouse V1.0 on AU2/AU3/AU3.5• Migrating data and TSQL code from SMP SQL Server 2008 R2 to PDW environment.• Created the ETL framework to load over 500 million records a day in the PDW/DSQL environment.• Creating dynamic table partitioning, managing and monitoring PDW BI Environment.• Set up DEV, Test and Production architecture using PDW Appliances in a complex BI environment.• Performance tuning PDW DSQL Code• Created and Architected Dashboards, KPI, Event Based reporting applications with front end tools like Tableau, SSRS, RoamBI for both traditional and mobile clients.• Created Mutiple BI/EDW POCs using SQL Server 2012 (SSIS, SSAS(Tabular), Tableau, PowerPivot, PowerView, Database Engine, SSRS)• Architected Large to Medium size data warehouse for various clients in many industries (Includes Healthcare, Human Resources, Financial and Entertainment industries.)• Managed and mentored consultants and Business Intelligence engineers.

* Leading RPA Technical Solution Architecture /Platform across.* Configuring Blue Prism RPA solution across various business LOBs.* Leading Artificial intelligence/Automation solution definition and design. * Identifying systems/platform required to achieve end to end solution followed by PoCs.* Review solutions/code and advise delivery teams.

* Greenfield Implementation of SQL PDW V1(SQL Server Parallel Data warehouse)* Migration of SMP to SQL Server PDW platform* DBA activities for MPP and SMP environment including Back Up Strategy,Indexing Strategy etc. * Creating dynamic partitioning and load strategy. * Understanding and analyzing the best strategy to implement various shapes of the data received from various sources into MPP platform. * Architected BI/Datawarehouse/BIG data connectors to sources like Facebook, Twitter, DFA, ATLAS and many other digital media sources.* Training Data Architects on best practices and development approach for complicated data projects.