SIDDHARTH GEHLOT

A W S S A C E R T I F I E D M C S A S Q L B I S A S C E R T I F I E D

Phone: 312-***-**** Email: ac6l4e@r.postjobfree.com Website: https://www.linkedin.com/in/siddharthgehlot04/ https://www.siddharthgehlot.com/

EDUCATION

● Master of Science - Management Information Systems,2018 University of Illinois at Chicago – Chicago, IL

● Bachelor of Engineering - Electronics & Communication Engineering,2014 Rajiv Gandhi Proudyogiki Vishwavidyalaya – Bhopal, MP, India CERTIFICATIONS

● AWS Certified Solution Architect - Associate

● Microsoft Certified Solution Associate - SQL 2016 Business Intelligence Development

● Microsoft Certified Professional – Implementing a SQL Data Warehouse & Developing Data Model

● SAS Certified Base Programmer for SAS 9

SKILLS

● Data Analysis – SQL, PL/SQL, SAS, R, Python, VBA, MS Excel, Microsoft BI (SSIS, SSAS, SSRS), Power BI, Tableau, Google Analytics

● Big Data – Hadoop, MapReduce, Pig, Hive, MongoDB

● Machine Learning Techniques – Linear, Multiple & Logistic Regression, Decision Tree, Random Forest, K-NN, SVM, Apriori, Eclat, UCB, NLP, PCA. LDA

● Deep Learning & Statistical Techniques - Artificial & Convolution Neural Network, Factor Analysis, Correlation, `ANOVA, Chi-Square test, t-test

● Database Tools – MS SQL Server, PostgreSQL, MySQL, Teradata SQL, Oracle, MS Access

● Programming Languages – C#.NET, ASP.NET, JAVA, C, C++, JDBC, JSF, JSP, HTML, CSS, AWS WORK EXPERIENCE

APPLICATION DEVELOPMENT (GRADUATE ASSISTANT) – UIC Office of International Affairs June 2017 – Present

● Skillsets - Perl, SQL, JAVA, HTML, SQL Server, Request tracker, Wordpress, Tableau

● Project Management - Defined the scope and generated Operation Level Agreement, allocated appropriate access of RT application to 12 departments ensuring qualitative and timely deliverables.

● Business Analysis - Created workflow, development, testing & release plan for project, kept track of requirements, dependencies and timelines.

● Process Automation - Upgraded the paper based Application to e-Application. Built perl codes for approval request and workflow.

● Data Analysis - Imported the data collected from the e-Application to SQL Server. Analyze & Visualization of result using tableau.

● Knowledge Transfer - On boarded new team members and provided project specific training. APPLICATION DEVELOPER-MICROSOFT BI, SQL, C#.NET – IBM May 2015 – June 2016

● Skillsets – SQL, SAS, Microsoft BI (SSIS, SSAS, SSRS), C#.NET

● Data Analysis - Using SAS & SQL for the analysis and reporting of large dataset.

● Agile Knowledge - Worked on 'Data Scrambling ' & 'SQL Server Migration 2008 to 2012'. Resolved Service Requests.

● Technical Enablement – Developed scripts, created tables, complex SQL functions, store procedures, cursors and Triggers.

● Business Intelligence - Built and modified the existing SSIS packages, SSAS OLAP cubes &created reports using SSRS.

● Business Analysis - Designed system workflow, prepared the specifications document and provided business support on development projects.

● Project Management - Consulted with SPOC of 20 countries on project status, proposals and technical issues on behalf of 3 different IBM teams.

● Regression Testing - Analyzed the project requirement, created test cases & executed them. DATA ANALYST & QA ENGINEER– Abhyudaya Mutlimedia Pvt.Ltd. February 2014 – April 2015

● Skillsets - SAS, SQL, C#.NET, Microsoft BI (SSIS, SSAS)

● End to End Development - Developed a dynamic web application using C#.NET and WPF. Created SSIS packages for ETL process. Created date dimension, Natural & balanced hierarchy for SSAS dimensions. Created cube using measures & dimension.

● Customer Relationship - Provided continuous maintenance and development of bug fixes and patch sets for existing web applications.

● Technical Enablement - Developed and modified complex SQL queries. Imported, Exported & manipulated data. Designed databases and altered tables using SQL Server. Created reports & graphs using SAS PROC REPORT, PROC GPLOT etc. Exported outputs, tables and graphs using ODS. ACADEMIC PROJECTS

● MICROSOFT BI - AdventureWorks DW SSIS - Created SSIS package, performed ETL task using Control flow & Data flow. Error & Event handling of SSIS packages. SSAS - Created SSAS package using data source & data source view. Developed MDX & DAX queries. SSRS - Created tabular report. ● ALASKA AIRLINES ANALYSIS (Analysis & Visualization using tableau ) - Visualization & comparison of number of Alaska flights for 33 cities in US. competitive analysis for 11 airlines. Prepared 13 dashboards & 3 stories which included visualization & details of competitor, performance & time analysis of Alaska Airline. ● AWS Redshift data visualization using tableau & SQL Workbench - https://s3.amazonaws.com/siddharthgehlot/siddharth+-+Copy.html