Siddharth Tandon

Siddharth TandonPhone: (- Technology ConsultantEmail:-Microsoft Corporation Pvt. Ltd. – Hyderabad (INDIA)Other: LinkedIn/ Blogs/ GitHub Objective Big Data Consultant, with expertise and experience on big data solutions, advanced analytics, data science/ machine learning, data marts, business intelligence (BI), database, reporting tools and looking for a challenging role in an organization Career Synopsis Total 8+ years of experience (July 18, 2011 – Present) Worked on multiple advanced analytics, BI and data science projects Built statistical models and heuristics to predict, optimize, and guide various aspects of business based on available data Extensively worked on Python, R, Azure data stack, Kafka, Microsoft data tools, SQL Server etc. Solved various problems on Kaggle and Analytics Vidhya Involved in requirement gathering both onshore and offshore Ability to contribute in a team environment and communicate the ideas effectively Capable of delivering projects in new leading technologies Multiple recognition for various projects Successfully lead multiple projects Engineered from Ajay Kumar Garg Engg. College (UPTU) Employer Summary: Working for Microsoft from Dec 2014 onwards Worked for MAQ Software Pvt. Ltd. from July 2011 to Nov 2014 Advanced Analytics (Machine Learning, HDInsight, Azure technologies, R, Python, TensorFlow, Keras) Experienced in following machine learning methods: Regression, Decision Trees, Random Forest, Boosting, Neural Networks, Fuzzy Systems, Support Vector Machines, Ensembling Methods, Association Rules, Singular Value Decomposition, Principal Component Analysis, Cluster Analysis Good experience in following: Collaborative Filtering, Consumer Segmentation, NLP, Text Analytics, Information Retrieval, Search Relevance, Fraud detection Familiarity with time-series analysis and implications on how to model and test Good experience with HDInsight cluster Designed multiple IOT applications, which involves data movement and orchestrations using ADF, handling events and generate notifications using IOT Hub/ Event Hub, Azure stream analytics, PowerBI, Azure SQL DB Good experience in Kafka with Spark Streaming Good experience in writing Hive queries Good experience in R and Python Working on deep networks using Tensorflow and Keras Database Development & Administration: Experienced in designing database and modelling Data warehouses Experienced in developing stored procedures, functions, views, triggers Incorporated complex business logic into stored procedures and functions for re-usability. Strong debugging skills and the ability to solve complex problems Experienced in query optimization MS-BI Stack (SSIS, SSAS – Multidimensional and Tabular model): Experienced in Extracting, transforming and loading (ETL) data from Excel, Flat file, SQL Server to MS SQL Server by using SSIS Ability to analyze complex and large data sets and to extract information for effective decision making Good experience in Error Handling with normal load & fast load in SSIS Worked on various control flow containers (Foreach Loop, etc.) Good experience in various transformations like Derived column, Data conversion, Lookup, Script component, Conditional split, Multicast, Union all, etc... Experienced in working with C#.Net in SSIS with script task Experience in different type of configuration files to deploy the SSIS packages across all environments Experience in developing & deploying cubes using SQL Server Analysis Services (SSAS) using both Multidimensional and Tabular approach Experience in creating hierarchies and attribute relationships Experience in writing MDX, DAX queries Technical skills Query Languages Python, R, SQL, DAX, MDX, C#.Net On-premise data stack SQL Server, SQL Server Data Tools (SSIS, SSAS), Power BI Azure technologies Data Factory, Data lake, Data Catalog, Azure SQL DB, Azure SQL DWH, Azure Databricks, Cosmos DB (SQL API & Mongo DB API), Storage Accounts, Azure Search, Event Hubs, Stream Analytics, Spark, HDInsight Deep Learning frameworks Tensorflow, Keras Open Source technologies Apache Kafka with Spark Streaming, Spark, Hive, Map Reduce framework Machine Learning Linear and Logistic Regression, Trees, SVM, Ensembling methods, Neural Networks, CNNs, NLP, Clustering, Regularization, Dimensionality Reduction, Recommendation systems Projects Komatsu: This project aims to improve customer resolution time for machine related issues by reducing overall troubleshooting time and providing consolidated view of data across various disconnected systems. Using Databricks (Scala) and data lake I have created a conceptualized DWH in Datalake and then with the help of Polybase loaded data in Azure Datawarehouse for reporting needs. The entire orchestration happened through ADF Skills: Azure Databricks, Scala, Azure Datawarehouse, ADF, Data lake Astra: This project aims to perform market basket analysis on top of Sales data and predicting when the customer will buy the next product. I was acting as liaison between customer and the offshore team which involves regular demos to stakeholders, design discussions, requirement gathering, helping offshore team with the model generation and provide guidance in understanding the domain and data Skills: Azure SQL Db, Azure ML, Python, ADF, Power BI Rolls Royce This project aims to predict the engine life of different aircrafts, and my role is to work on various regression models, starting from gathering the data, generating feature set, predicting and optimize the models and finally showing the results on PowerBi Skills: Azure SQLDb, HDInsight Cluster, Hive, ADF, Azure ML, PowerBi Cognizant Technologies Implemented complete enterprise DWH solution (DWH, ETL, Tabular model with security, PowerBI reports) for Cognizant’s Delivery Excellence team Skills: SQL Server Data tools 2013 (SSIS, Tabular model), SQL Server 2014, PowerBI Nigerian Breweries The project is segregated into multiple modules, first part is to automate the data loading from flat files and SQL server, second part is to build a cube, and the last one is to build Power BI reports using cube as a data source Skills: SQL Server Data tools 2013 (SSIS, SSAS), SQL Server 2014, PowerBI Certificates AI-100: Designing and Implementing an Azure AI Solution 774: Perform Cloud Data Science with Azure Machine Learning 475: Design and Implement Big Data Analytics Solution 473: Design and Implement Cloud Data Platform Solutions 532: Implementing Microsoft Azure Solutions 461: Querying Microsoft SQL Server 2012 -: TS: Microsoft SQL Server 2008, Database Development