Devansh Sharma Email & Phone Number

Chicago, Il, Us

Fullerton, California, United States

● Mentored and tutored over 500 undergraduates in STEM disciplines, including Computer Science, Mathematics and Statistics.

Mumbai, Maharashtra, India

● Built a Data Factory (ADF) pipeline canvas based on the requirements as optimistically as possible without any hops in between.● Created re-usable stored procedure that will insert and update the ADF pipeline runs execution logs for pre-job & post-job logs in such a way that there will be only one record per pipeline run.● Worked with logic apps to send an email notification in case of pipeline failure with the error message.● Created a pipeline that will pull the XML/JSON data from Rest APIs using web activity and writing the data to Azure Data Lake Gen2.● Worked with data flows for achieving complex transformations like flattening the XML/JSON data and performing required transformations.● Created Azure Key vaults and used them to store sensitive information.● Worked with match & merge job with SCD Type 1 incremental logic.● Created parameterized linked services & datasets.● Worked on writing complex T-SQL like stored procedures, views, joins, and user-defined functions.● Created inline table-valued functions which will return the table as output.● Created fixed-width output files using data flows. ● Created scheduled triggers which will have a frequency of every hour & every day.● Worked with Solution Architects to understand the project Architecture and prepared the Technical Design Document (TOD).● Understand the full end-to-end development activities from design to going live for ETL development in the Azure platform.● Created a pipeline that will take incremental loads following the SCD Type 2 method.● Proactively worked in the code deployment from Dev to QA & QA to Prod using ARM Templates.● Actively involved in code review and bug fixing to improve the execution performance of queries.● Troubleshooting long-running queries and doing performance tuning.● Worked on the data quality checks for different source systems using Databricks.● Worked in the QA team to write the test case scenarios and document it.

Ahmedabad, Gujarat, India

● Employed data-driven strategies, including multivariate regression analysis, clustering algorithms, and data visualization using Tableau, to conduct root cause analysis, resulting in a 20% decrease in operational costs during COVID-19 disruptions.● Deployed a 92% accurate SVM model to identify COVID-19 data inconsistencies, enabling data-driven decisions that reduced operational impact by 32%. ● Collaborated with business analysts to translate insights into actionable solutions.● Built a new web module using React.js that integrated seamlessly within the subsidiary company BCool's website. This module streamlined remote data entry for marketing users and accountants, resulting in an 85% improvement in data processing efficiency.

Indore, Madhya Pradesh, India

● Developed a collaborative filtering recommender system to provide personalized recommendations to users, resulting in a 30% increase in user engagement rate.● Implemented Principal Component Analysis (PCA) and feature scaling techniques for dimensionality reduction on customer behavior data, reducing dataset complexity by 50% and improving model training time by 35%.● Developed a robust spam email detection system using Naive Bayes and bag-of-words techniques, achieving an impressive 92% classification accuracy.● Led the development of advanced neural network architectures to predict bike rental demands with 85% accuracy, enabling data-driven decision-making.● Analyzed and implemented diverse techniques to tackle complex data challenges, honing analytical and critical thinking skills.

Indore, Madhya Pradesh, India

● Architected and developed responsive web applications utilizing HTML5, CSS3, and JavaScript, ensuring optimal user experience across various devices and platforms.● Implemented RESTful APIs using Python, facilitating seamless data exchange between the client-side and back-end services.● Optimized MySQL databases for efficient data storage and retrieval, contributing to a 25% reduction in query execution time.● Collaborated with designers and back-end developers to ensure seamless integration and functionality across the entire web application stack.

Master Of Science - Ms, Computer Science, 3.8/4

Bachelor Of Technology - Btech, Computer Science And Engineering, 3.9/4