Prashanth Subramanian Email & Phone Number

United Kingdom

• Design and Implementation of Real time big data ingestion and batch data load (LAMBDA and Kappa Data Architecture) using Azure Event hub, Azure Stream Analytics, Azure Data Factory, Azure Databricks (Pyspark and Spark SQL) and Synapse analytics• Development of bronze, silver, gold Delta Lake Architecture for combining both batch and streaming data• Extensive experience on Datawarehouse architecture design, modelling (Dimensional data modelling) and development in Azure SQL and Synapse serverless pool• Experience on Data Orchestration and Integration (ETL\ELT) using Azure Data Factory• Developed Data Quality and Sales MI Report using Data Visualization tools using Power BI and SSRS• Strong fundamental knowledge in T-SQL queries and Python basics• Deployed ADF Pipelines using Azure DevOps CICD• Experience on Synapse Pipeline (Spark job data transformation)

Chennai, Tamil Nadu, India

• Development of Data Warehouse project (Ralph Kimball) from scratch• Unstructured data ingestion and curation using Azure Data Factory V2 Pipelines• Experienced on writing U-SQL scripts in Azure Data Lake Analytics and Stored procedures to build multidimensional model• Built Live Streaming of real time IOT temperature and ambulance data using IOT Hub and Stream Analytics• Extensive usage of Cosmos db to store JSON data in document based db (Mongo API)• Configured Hive External tables using HD Insight• Hands on Knowledge on using SSIS to integrate data from various data sources such as Oracle, DB2 and etc• Written advanced queries using T-SQL and Polybase• Hands on Experience on creating near real time analysis, MI Dashboards and visualizations using Power BI• Client interfacing skills and proven team handling skills• Guiding and mentoring team of size 12 on Big data Azure technologies.

Bengaluru Area, India

Has worked on Azure Logic apps, Azure Data factory, Azure Data Lake (Storage and analytics), Setting up pipeline activities, developing Azure Data marts for analytics and data scientists.

Have worked on Azure cloud data and analytics using Event hubs, Azure stream analytics, Data factory (ADF), Data lake (ADL), Azure functions and Machine learning studio.Have worked on MS BI Technologies such as SSIS, SSAS SSRS, Power BI and was a technical lead for a team of 12

London, United Kingdom

1). provided Level 1 and Level 2 support on Microsoft Sql server 2012, BI, Sharepoint 2010, Tableau and Powerpivot.2).Research and Implementation of BIG Data analytics with Open Source NO-SQL Cassandra3). Development of Social Media Integration with Microsoft BI and interactive reports in Power BI.4). R&D on how Tableau Visual Analytics product fit into our Media company data.5). Migration of Sharepoint 2010, excel powerpivot 2010 to Sharepoint 2013 and excel power pivot 2013

London, United Kingdom

Data analyst expertise in hard core development ofData Integration: 1). Microsoft ETL - SSIS 2). Pentaho ETL - Kettle,3). Talend Open Studio for Data integration,Data Warehouse:1). Microsoft Sql Server 2008R22). Cassandra (NoSql) - Big Data AnalyticsMulti Dimensional Database (OLAP):1).Cube Development using Microsoft SSAS,2).Cube Development using Opensource Pentaho Mondrian Data Mining:1).Forecasting Companies revenue growth performance, 2). Analysis of Data Trends and patterns using Microsoft Decision Tree Algorithm, 3). Microsoft Time series algorithm, 4).Artificial Neural Networks.Reporting:1).SSRS reports2). Telerik Reports embedded on websites.3). Pentaho Report Designer.4). Microsoft Power Pivot.

London, United Kingdom

Programmer Analyst in Cognizant Technology Solutions, this is a fortune 100 fastest growing IT company.Work experience on Microsoft Sql Server 2000, 2005, 2008, 2008R2 and worked for Cognizant's UK ,US,German, French Clients.MS SQL Database Production and Testing server Support Performance Tuning, Query Optimisation and Security.Data warehouse Development and Administration. Experienced with Microsoft ETL Tools SSIS. Strong working Knowledge of OLTP, OLAP Cube Development using SSAS. Designing Star Schema and Snow Flake schema.

Chennai Area, India

Training in Sql Server 2005,ASP.Net 3.5, Project Management Skills.Junior web developer and Sql Server Database Administrator