Data Software Engineer

ANURAG RACHCHA

Boston, Massachusetts. ***** 646-***-****

*******.*@*****.***.*** https://www.linkedin.com/in/anuragrachcha/ https://github.com/AnuragRachcha EDUCATION

Northeastern University, Boston, MA May 2021

Master of Science, Information Systems (Specialization: Data Analytics) (GPA: 3.7/4) University of Pune, Pune, India May 2018

Bachelor of Engineering, Computer Engineering (First Class with Distinction) TECHNICAL SKILLS

Programming Languages - Python, R, Java, C++, SQL

Database Technologies - MySQL, SQL Server 2017, Oracle 11g, MongoDB Business Intelligence Tools - Tableau, Power BI, Talend, SSIS Python Libraries - numpy, pandas, matplotlib, seaborn, BeautifulSoup, scikit-learn Other Tools - Jupyter Notebook, Advanced Excel, Netbeans, PowerPoint, Git EXPERIENCE

Venkasys Technologies Pvt Ltd, Pune, India (Software Engineer) June 2018 - April 2019

• Worked with product managers & teams to understand the business problems & develop data-driven solutions

• Leveraged SQL procedures to enable bulk insertion of customer data & invoice calculation, speeding up process by approximately 15%

• Analysed customer’s usage data to introduce/modify plans and market the product to expand customer base and increase revenues

• Used MS Excel and created reports to provide analytics on the client’s balances

• Acted as Implementation Support for End-User application and reconciliation as well as on-going user support CSIR-CDRI, Pune, India (Research & Data Analysis Intern) August 2017 - January 2018

• Key Participant from requirement gathering to translate strategy into an operational plan

• Co-led creative control on project’s direction & engaged with stakeholders to define solutions relevant to our research on science journalism

• Performed extensive SQL Scripting to create database of science reporters & created SQL Procedures to load in SQL Database from data fetched from publisher websites on project ‘Science Reporting across the globe’

• Created monthly reports based on inferences and analysis using data visualisation techniques in python PROJECTS

Stock Market Analysis

• Used pandas to fetch technology stocks information from Yahoo Finance to understand recent stock behaviour

• Performed data analysis to calculate ‘moving average’ over various timeframes & understood trend of the stock

• Compared daily percentage returns of company stocks & found correlation in stocks using the ‘pearsonr’ value

• Analysed & cleansed data to calculate ‘daily return’ to get more in-depth information on the risk of the stock

• “Monte Carlo” analysis on Apple and Google stocks for 2018-19 showed higher value at risk for Google stocks Dental Office System

• Translated business requirements into technical design specifications for ER schema

• Generated DDL Scripts for MySQL & used stored procedures, functions & views for automation and fast data retrieval

• Developed front-end using Servlets, JSP & JSTL to perform CRUD operations on the backend Boston Housing Price Analysis

• Demonstrated univariate Linear Regression on rooms per house & price of houses using least square method

• Calculated RMSE value of 6.60 to conclude that it is reasonable to expect house price to be within $13,200

(Price range of $1000) of the regression line

• Implemented multivariate regression using scikit-learn to calculate coefficient estimate & found house prices to be in high correlation with number of rooms

• Validated the correlation by predicting prices on training and validation sets of rooms and house prices and observed random distribution on seaborn visualisation to reveal almost no patterns

Contact this candidate