Resume

Sign in

Data Sql

Location:
El Monte, California, United States
Salary:
70000
Posted:
April 12, 2018

Contact this candidate

Resume:

ANUSHA

MANJAPPA

ac44ei@r.postjobfree.com

+1-626-***-****

anushamanjappa

anushamanjappa

Los Angeles

Computer Information System

graduate student,actively seeking

full time opportunities as an analyst

with strong real time IT experience of

4 years and good knowledge of

Statistics,Machine Learning and

Business Intelligence tools and

techniques .

IEEE Publication

IEEE PAPER ON BIG DATA ANALYSIS

OF YOUTH TOBACCO SMOKING

TRENDS IN THE UNITED STATES IN R

AND TABLEAU

Incorporated big data techniques

such as R and Tableau to explore the

tobacco smoking trends among the

youth in the United States. Results

indicate that there is more number of

youth male smokers than youth

female smokers. The results also

indicate that more than 51 percent

of current youth smokers want to

quit smoking.

Skills

PROGRAMMING LANGUAGES

R

Python

PHP

Javascript

Java

HTML

CSS

JUNIT

TOOLS & TECHNOLOGIES

BI Tools and Concepts

Microsoft Power BI

Tableau

R Studio

Microsoft Excel

Bluemix

DreamViewer

Anaconda

Spyder

Android Studio

Crystal Reports

Business Objects

CLOUD PLATFORM

Hadoop

Spark

IBM Watson

AWS

Databricks

Microsoft Azure

DATABASES (SQL / NOSQL)

MS SQL Server

HiveQL

Sqoop

PIG

Microsoft Access

ETL

Education

CALIFORNIA STATE UNIVERSITY, LOS ANGELES, USA

Master of Science Computer Information System 2018 GPA: 3.8/4

JSS ACADEMY OF TECHNICAL EDUCATION, BANGALORE, INDIA Bachelor of Engineering Computer Science 2014

GPA:3.9/4

Employment

ITA DEPARTMENT - CITY OF LA Los Angeles, CA, USA

Data Analyst Intern Aug 2017 to Dec 2017

SKILLS : SQL, Power BI, Tableau, PHP, HTML, CSS, Excel, Power Pivot, Agile Methodology, MS O ce Tools

•Implemented the DART application for the Mayor of LA, Eric Garcetti to review the services provided to the City using PHP, HTML, CSS and MySQL.

•Connected DART Application to power BI using MySQL server, transformed data-driven analysis for business processes into meaningful insights,analyzed reports and Iframed the Visualizations. Created Stored procedures,functions and triggers.

•Steamed live MyLA311 data from data.lacity.org using Socrata api to access the open data resources and created e ective visualizations of it using Power BI to live stream it on KIOSKS in LA .

•Delivered technical presentations to the Mayor and the public before it went live. RIEDON INC. Los Angeles, CA, USA

Programmer Analyst Intern Jun 2017 to Aug 2017

SKILLS : JAVA, SQL, R,Tableau, DBA, Filemaker, Excel, Power Pivot, MS O ce Tools, Agile Methodology

•Implement the labor tracking system to track the time taken by employees to manufacture di erent resisters using DBA and FileMaker by introducing bar codes to digitize the entire process .

•Used R to Analyze the data statistically by including machine learning algorithms. Identi ed business opportunities and recommended solutions.

•Visualized the data on Tableau to see nearly 30% growth in overall pro t. CALIFORNIA STATE UNIVERSITY, LOS ANGELES Los Angeles, CA, USA Graduate Research Assistant Nov 2016 to Aug 2017

SKILLS : JAVA, SQL, R, Tableau, Android studio, HTML, CSS, JAVA, Excel, MS Tools, Healthcare. Google Analytics

• Worked with Dr.Shilpa Balan to coordinate research into Analysis of Youth Tobacco Smoking Trends in the USA in R and Tableau and published it at the IEEE. As an enhancement i also developed an android application for tobacco prevention in android studio.

• Worked with dean of E & M department Dr. Kwong in developing the Asian Paci c website of Cal State LA . COGNIZANT TECHNOLOGY SOLUTIONS Chennai, TN, India

Programmer Analyst Aug 2014 to Jul 2016

SKILLS: Java, Sql, AngularJS, JavaScript, JSP, Hibernate, JUNIT, XML, MS O ce Tools, Agile Methodology, Web Services, Healthcare

Caremore Anthem Web Application : Client ( Anthem.inc)

•Created web services in xml using WSO2 which can be integrated along with web applications to automate tasks. MEDICAID Web Application for NYC : Client( Xerox)

•Translated business requirements into technical solutions for Member and Contact Management modules of the MEDICAID web application of New York using java, jsf,JavaScript, AngularJS and sql under Agile Methodology, documented the entire process in MS O ce tools and Visio and demonstrated the same to the client and got acceptance to all the stories.

•Managed back-end DB development solely using hibernate and MySQL functions, triggers, stored procedures and views.

•Strengthened developmental methodologies by introducing JUNIT NSOFT INDIA PRIVATE LIMITED Bangalore, Karnataka, India Android Developer Intern Jan 2014 to Jun 2014

SKILLS : JAVA, SQL, Eclipse, Android

Spot Billing Application:

• Hardware cost was optimized by developing an android application to replace spot billing machines used by State Government (BESCOM).

Projects

BIG DATA ANALYSIS OF HEALTHCARE OUTCOMES AND PATIENT SATISFACTION USING R Feb 2017 to May 2017 SKILLS : R Studio, R, SQL, Excel

Analyzed Healthcare Outcomes and Patient Satisfaction using R studio with three public data sets provided by HCAHPS. Visualized data to understand and measure variables a ecting patient satisfaction and healthcare quality and compared ratings of hospitals. It helps us improve the overall quality of patient satisfaction.

BIG DATA ANALYSIS OF AVIATION ACCIDENT USING TABLEAU Feb 2017 to May 2017 SKILLS :Tableau, SQL,Excel

Analyzed the aviation crashes dataset in Tableau to nd out insights about the airline crashes to map the number of crashes and injuries occurred to the airline which was prone to most number of such incidents and to see the measures taken by them and judge how e ective the respective measures were. Implemented various visualizations to make it understandable. PREDICTIVE ANALYSIS OF NEWYORK MOTOR VEHICLE COLLISIONS Feb 2017 to May 2017 SKILLS : Python, AzureML, SparkML, SQL, Excel

Performed predictive analysis on the NYC motorcycle accident dataset to predict the pattern of accidents using AzureML and SparkML. Followed Supervised Learning approach. The models considered in AzureML are multiclass decision forest classi cation,multiclass decision jungle classi cation and multiclass neural network classi cation and the models used in SparkML are Random forest classi er,Decision tree Classi er and Logistic regression.

BIG DATA ANALYSIS OF HEALTHCARE AGENCIES IN MEDICARE USING PYTHON AND IBM WATSON Aug 2017 to Dec 2017 Hibernate

RDBMS

SKILLS : Python, Spyder, Anaconda, SQL, Excel

Big Data drawn from Medicare.gov’s compare websites and directories was analysed in Python and IBM Watson to nd out the e ectiveness of Home Health Care Agencies. Spyder present in the Anaconda IDE was made use of to analyse the data in Python. Data Analysis and Predictive Analysis was carried out.A separate medicare Twitter data feed was also analysed in addition in IBM Watson.



Contact this candidate