Data Software Engineer

Sumod Shinde

972-***-**** adchcq@r.postjobfree.com www.linkedin.com/in/sumod-shinde https://public.tableau.com/profile/sumod EDUCATION

M.S. in Information Technology and Management The University of Texas at Dallas GPA: 3.85/4 May 2020 Certifications: Tableau for Data Science, Machine Learning A-Z, Master SQL for Data Science, Descriptive and Inferential Statistics Scholarship: New Deans Excellence Scholarship

B.S. in Computer Engineering The University of Mumbai, India GPA: 3.95/4 Aug 2017 Certifications: Data Analytics with R

CERTIFICATIONS & TECHNICAL SKILLS

Programming: Python, R, SQL, PL-SQL, Java, C, C++

Databases: MySQL, PostgreSQL, Oracle

Analytical Tools: Tableau, Advanced Microsoft Excel, QlikView, RStudio, SAP HANA, SAP Business Objects, SAS Machine Learning: Regression, Classification, Clustering, Apriori, ARIMA Forecasting, ANN Big Data: Apache Hadoop (Storage), Apache Hive, Impala, Sqoop, Flume, Apache Spark BUSINESS EXPERIENCE

Assistant Software Engineer Tata Consultancy Services Dec 2017 – Jun 2018

• Achieved 10% increase in defect identification by performing scaled automation testing using python test framework

• Reduced manual efforts by 20% per week by developing automated Python script for SALT failure triage process

• Leveraged SQL querying skills to extract data into Microsoft Excel by establishing a live connection

• Executed automation test scripts using selenium by formulating end-to-end testing on storage systems project

• Designed various test cases in accordance with the given business requirements by improvising on previous test cases

• Reviewed new areas of opportunity in daily agile standup meetings with team leads, product owner and stakeholders

• Analyzed and reported the number of hours saved per week in triage process by generating MS-Excel reports

• Enhanced product quality in concurrent sprints by developing scorecards to identify key areas of defects ACADEMIC PROJECT

Business Data Warehousing: Predictive Analytics Using SAP Business Objects Sep 2019 – Nov 2019

• Estimated the future value of liquid assets by performing a time series analysis on the cashflow data

• Created interaction variables to reduce forecasting error of the predictive model by 6.8%

• Established rules for customer search patterns and constructed a flow graph by conducting association rule mining

• Predicted number of customers responding to the promotional offer with 91.97% accuracy by defining a classification model Big Data Analytics: Exploratory Data Analysis Using Tableau & Hive Apr 2019 - Jun 2019

• Imported geolocation and truck information data into Hadoop File System by incorporating external tables using Hive

• Eliminated the skewness in the data by identifying and normalizing risk factor associated with truck accidents

• Identified cities prone to high number of accidents by integrating Apache Hadoop with Tableau dashboards Business Analytics with R: Bitcoin Price Prediction Using ARIMA Forecasting Jan 2019 - Mar 2019

• Utilized cryptocurrency, crude oil and stock price variables to improve forecasting accuracy of bitcoin prices by 9%

• Visualized periodogram and analyzed results to identify the trends in bitcoin prices based on seasonality

• Optimized ARIMA model to efficiently forecast bitcoin prices and visualized the results using ggplot2 Business Analytics with R: Sales Prediction Using Multi-Linear Regression Analysis Jan 2019 - Mar 2019

• Predicted the price based on customer demographics by extracting and cleaning 2 million records of Black Friday Sales

• Improved fitness of multi-linear regression model by 7.5% using advanced techniques like backward elimination Data Visualization: Integrated Analysis Using R and Tableau Sept 2018 - Oct 2018

• Identified insights and key performance indicators by implementing decision tree and K-means clustering algorithm

• Designed compelling visualizations on Tableau to effectively analyze factors affecting the survival rate of travelers ORGANIZATIONS & PUBLICATIONS

• Web Management Officer – Performed data manipulation on SQL server for Student Organization at UT Dallas.

• Board member – Handled finances and organized Events held by Infinity Lions Club at UT Dallas.

• Standards Elimination Parser Using Natural Language Processing – IEEE (Institute of Electrical & Electronics Engineers Conference)

Contact this candidate