Data Analyst

MOULIKA BALARAM

Bellevue, WA ***** • 309-***-**** • **************@*****.*** • linkedin.com/in/moulib

SUMMARY

Masters Graduate with 3+ years of professional experience in Data Analysis, Business Intelligence, Data Modeling and Data Mining to help business make data driven decisions

Proficient in analyzing and handling billion of records using SQL, Python, R, Shell scripting, SSIS and Azure

Experienced in building reports and deriving insights using data visualization tools such as Tableau, Power BI and MS Excel

Analyzed results using various statistical techniques like ANOVA, t-tests, A-B testing and RFM Analysis

Well versed in machine learning algorithms such as Decision Trees, Random forest, K- nearest neighbors, K- Means clustering and Naïve Bayes Classification

TECHNICAL SKILLS

Database: SQL Server, MS Access, MS SQL

Data Visualization: Tableau, PowerBI, MS Excel

Programming Languages: Python, R, SQL

Data Tools: Azure, SSIS

EDUCATION

Master of Science in Business Analytics June – 2020

University of Washington, Tacoma GPA: 3.95

Bachelor of Technology in Electrical and Electronics Engineering May-2016

G. Narayanamma Institute of Technology and Science for Women, Hyderabad, India GPA: 3.30

PROFESSIONAL EXPERIENCE

Data Analyst, MultiCare Health System, Tacoma, USA June 2019 – June 2020

Built real-time dashboards in PowerBI to analyze patient re-return rate trends and patient migrations across different segments that helped senior leadership for strategic decision-making

Built a ML model to predict likelihood of a patient to re-admit into emergency department. These scores are used by the hospital staff to provide extra care to patients with high re-return rate. This model has the accuracy of 77% and forecasted a savings of $1.5 M in a year

Performed in depth exploratory analysis and evaluated the impact of 5 factors on the re-admit rate

Created detailed reports in order to simplify findings into presentations to assist data-driven decision making

Extensively involved in writing SQL queries to pull the required information from database using MS SQL

Played a vital role in designing database schema and built ETL pipeline using SSIS to integrate required patient data

Designed and created a mobile application using power apps that healthcare providers and staff can utilize to easily identify at risk patients in real time

Worked extensively in documenting the Source to Target Mapping documents with data transformation logic

Collaborated with non-technical business users to understand their analytical needs and accordingly developed reports

Data Analyst, Infosys, India May 2016 – Aug 2018

Played integral role in developing online retail store loyalty and sales strategy, generating a lift in net sales by $1.2M over a period of 3 months.

Streamlined the campaign performance measurement reporting process using SQL scripts and developing excel dashboards reducing run time from 6 hours to 1/2 hour

Analyzed test campaigns and recommended future initiatives to drive customer acquisition for new online accounts

Supported data science team to build and validate customer value model to help teams focus on the right accounts for a variety of marketing campaigns.

Developed on-going adhoc reports and provided analytical support to marketing, senior management and other functional teams to make critical business decisions

ACADEMIC PROJECTS

Analysis of Amazon Reviews (Electronic Category)

Built text classification model on Amazon reviews to identify positive, negative and neutral reviews using random forest model

Performed Topic modeling using Latent Dirichlet Allocation (LDA) to identify key topics of concentration among customer reviews

Performed preprocessing and exploratory data analysis using Pandas package

Housing Sale Price Prediction – Regression Analysis

Built multiple regression model to predict sales price of residential properties in Bellevue, Washington, using R.

Used statistical techniques such as transformation of variables, check for regression assumptions, variable selection based on AIC, step wise regression, correlation and verified assumptions using constant variance and normality test

AWARDS & ACCOMPLISHMENTS

Best project award at 3rd Annual MSBA Applied Project showcase for AY 2020

A lifetime member of Beta Gamma Sigma (BGS). BGS recognizes and honors the top 10% of graduate students around the world in business schools accredited by the Association to Advance Collegiate Schools of Business (AACSB)

Recipient of Milgard Endowment Scholarship for AY 2019

Best Poster award at inter college level TechFest for AY 2015

Contact this candidate