Data Analytics, BI, Data science, ETL

Arpitha Jayarama

LINKEDIN: Arpitha Jayarama +1-312-***-**** EMAILID: *********@****.***.*** WEBSITE: https://ajayarama.wixsite.com/arpitha Illinois Institute of Technology, Chicago, IL May 2018 Master of Information Technology and Management [Specialization in Data Analytics and Management], GPA: 3.9/4.0 PES Institute of Technology, Bangalore, India July 2014 Bachelor of Engineering in Information Science and Engineering, GPA: 3.5/4.0 SKILLS

• Programing Language: Java, R, Python, SQL, PL/SQL, XML, Java script, MongoDB

• Databases: MySQL, Oracle DB, SQL Server, Cassandra

• Tools: R Studio, MS Excel (Pivot, VBA), MS Access, MS Visio, MS Project, Pentaho, SSIS, SSRS, Google Analytics, Hadoop, Hive

• BI and Visualization Tools: Tableau, SQL Developer, Microsoft Power BI, Microsoft Azure Machine Learning Studio, Qlikview

• Certification: i) Hadoop Starter Kit(Udemy), ii) Beginner to Pro in Excel: Financial Modeling and Valuation

• Publications: Effective blood bank management based on RFID in real time systems. IEEE, Embedded Systems(ICES),2014. URL: http://ieeexplore.ieee.org/document/6953176/

EXPERIENCE

Salt Flats, Data and BI Intern, Chicago Sep 2017- April 2018

• Design, Build and Deploy dashboard for in house application using Python Framework called Django.

• Performed quantitative, visual analysis on internal data of the company it helped management with schedule optimization.

• Actively Participated in planning Agile development process and scrum team meetings.

• With minimal assistance launched Python web application environment using AWS Elastic Beanstalk. Accenture, Data Analyst, Bangalore/India Aug 2014 - Aug 2016

• Performed data analysis on the firm’s financial data and used SSRS to create and manage reports to help management.

• Automated the project functionality by developing in house tools, developed packages using SSAS to perform ETL.

• Analyzed, fixed and monitored critical production environment issues using SSIS technology.

• Settled failures identified with numerous ETL Jobs and server issues which helped the team achieve robustness.

• Store and retrieve data from database using SQL queries and Performed extensive data driven competitive analysis.

• Involved in data migration project to move data to cloud platform, Performed data integrity, analysis and validity (MySQL). Illinois Institute of Technology, Production Assistant, Chicago July 2017-Nov 2017

• Supported production of scheduled classroom audio & video capture and classroom technology trouble shooting.

• Worked collaboratively with faculty and performed Database Maintenance of the department.

• Operated IIT Online camera, A/V controls and assured the integrity of production information to students worldwide. RELAVENT PROJECTS

Bitcoin Price Forecasting with Time series and Machine Learning Algorithms

• Analyzed and forecasted the prices of Bitcoin, ethereum and ripple with 90% accuracy rate by using time series analysis, Bayesian and Exploratory tool which uses ‘Prophet’ package.

• Performed complete EDA (Exploratory Data Analysis) and SWRT analysis to understand the trends involved in the data.

• Performed Liner regression and Random Forest on Python platform to identify the factors that affect the price of the bitcoin.

• Developed a dashboard using Exploratory to show KPI, identify potential influencing variables and display root cause analysis. Time Series Analysis and Regression Analysis On Global Temperature Anomaly

• Analyzed trends in 100,000 records of anomalies in temperature change and came up with a time series model for predicting the future climatic conditions using R studio.

• Performed feature Selection, build and optimized classifiers using machine learning techniques.

• worked on producing effective data visualization on monthly and yearly data, using Tableau and Qlikview. Data Analysis for an E-commerce company by using SQL, Python and SAS

• Performed analysis on the dataset with over 100,000 records consisting of sales data of various products across various years.

• Implemented Affinity Analysis to discover co-occurrence relation among products by analyzing customers purchase behavior.

• Performed Regression Analysis and Predictive Analysis using SAS and offered recommendations. Data Warehouse application for a GRE dataset using SQL, Pentaho and Tableau and building OLTP and OLAP

• Analyzed and designed source data and dimensional star-schema by creating dimension tables and fact tables.

• Implemented ETL in Pentaho by using star schema to load physical tables in MySQL server.

• Implemented Kimball approach with bus architecture to drill down and drill across various dimensions and data-marts.

• Developed a Tableau dashboard with drill down consisting of charts and graphs for enrollment, credits, average GRE score etc. Sentimental Analysis on TripAdvisor Restaurant Review Dataset

• Sentimental Analysis program is built using python to predict if the customer review is positive or negative.

• Libraries utilized include scikit-learn, Pandas, NLTK, PyLab and Random Forest Classifier is used to train the model for prediction.

Contact this candidate