Microsoft Office Data

Rohit Appandaraju

Boston, MA ***** 617-***-**** ***********.*@*****.***.***

www.linkedin.com/in/rohit-appandaraju/

EDUCATION

Northeastern University, Boston, MA (GPA-4.0) Jan 2017-Present Master of Science in Data Analytics

Courses: Database Management and Database Design, Collecting Storing and Retrieving Data, Business Intelligence in Tableau, Deterministic Operations Research, Engineering Probability and Statistics

Anna university Guindy, Chennai, India May 2012- Aug 2016 Bachelor of Technology in Mechanical Engineering

Relevant courses: Statistics and Probablity, Transform and Differential Equations, Linear algebra Certificate: Lean Green Belt from Institute of Industrial and Systems Engineers TECHNICAL KNOWLEDGE

Tools: SQL Server Management Studio(SSMS), SQL Reporting Services, Toad Modeler, Microsoft Visio, Tableau, Microsoft Office Suite, Power BI, Lingo, Adobe Photoshop, AutoCAD, ANSYS, PLC, R studio

Programming Languages: R, Python, MSSQL, PostgreSQL Minitab. ACADEMIC PROJECTS

Healthcare database System using SQL Aug 2017-Present

• Prepared database with various attributes for a healthcare industry using SSMS(SQL)

• Modelled database diagram using Toad Modeler and studied functional aspect of attributes involved in preparing the model.

• Automated Inventory, reduced data redundancy, simplified appointments for doctors and patients. Cost Trend Analysis of housing prices in Massachusetts June2017-July 2017

• Led initiative to build statistical models using historical data to predict real estate prices in several economic markets. Focused on Analyzing factors affecting the value of the properties in Massachusetts.

• Developed prediction algorithm using advanced data mining algorithms to classify similar properties together to develop sub-markets.

• Created and presented executive dashboards and scorecards to show the trends in the data using Studied the factors influencing the trend.

Titanic Survival Prediction in Kaggle Jan 2017- Mar 2017

• Cleaned raw data to consistent data and filtered the required data using R.

• Created customized reports and processes in R and Tableau Desktop, explored insights for predicting the model.

• Built the model using R and Improved the model's prediction accuracy to 65%.

Contact this candidate