Data Analyst

• Address: ***** SE Summerhill Ln Issaquah, WA ***29 • Cell: +1-734-***-**** • ****************@*****.*** • LinkedIn - Sailaja Konda

• GitHub - Sailaja Konda

SAILAJA KONDA

****************@*****.*** LinkedIn - Sailaja Konda GitHub-Sailaja Konda Cell: +1-734-***-**** EDUCATION

Master of Professional Studies in Data Analytics Sep 2018 – Mar 2020 Northeastern University – Seattle Campus, WA, USA GPA: 3.91 / 4.0 Coursework: Predictive Analytics (Machine Learning), Data Warehousing & SQL, Data Management & Big Data, Data Mining Applications, Visualization for Data Analytics (Tableau), Business Intelligence, Risk Analytics

• Project 1: Convolutional Neural Network Web Application for Graffiti Image Recognition. Improved the performance of model from 55% to 87% using Regularization/Parameter Tuning techniques (Python, TensorFlow.js)

• Project 2: Zillow House Prices Prediction Analysis (Random Forest, Naïve Bayes, K-Means Clustering) using R

• Project 3: Hospital Nursing Intervention Pilot Program using Star Schema and Snowflake Schema (SQL)

• Project 4: Costco Sales Analysis with Collaborative Recommendation System using PySpark SQL & Tableau

• Project 5: Suggested metrics for Measuring Content Engagement in PR Industry for Onclusive client using Python

• Project 6: Video Games Sales Analysis using ARIMA model, Lasso Regression and K-Means Clustering using R

• Project 7: Prediction of Diabetes using Hypothesis Testing, ANOVA, Logistic, Lasso Regression, PCA using Python

• Project 8: Suggested metrics for Measuring Content Engagement in PR Industry for Onclusive client using Python Bachelor of Technology: Electronics and Communication Engineering Jun 2012 – Mar 2016 Jawaharlal Nehru Technological University (JNTU), Anantapur, AP, India GPA: 8.4 / 10 PROFESSIONAL EXPERIENCE

The Spur Group, Bellevue, WA, USA (Client: Microsoft) Sep 2019 – Dec 2019 Data Analytics Consultant

(Project – Azure Marketing Data Support)

• Performed Visual Studio customer subscription analysis and built various metrics using Power BI

• Performed Error Analysis on Visual Studio file downloads using SQL and documented the variations

• Developed analysis reports and visualization using DAX functions like table function, aggregation, count, logical, text, matrix visualization and date functions in Power BI

• Collect and Document client requirements using project management tools including Wireframes using Power Point and Excel reports

• Used various sources to pull data into Power BI such as Excel, SQL Server and Azure etc.

• Effectively communicated and provided recommendations through the analysis, preparation and presentation of technical data to internal and external customers using dashboard reports

(Project – HR Analytics)

• Built HR Analytics dashboards for Employee Turnover and Employee Quality of hire to use as a marketing material for client purpose

• Developed a predictive model to predict the likelihood of employee’s terminations using Random Forest Classification with Python script in Power BI

• Performed ARIMA Time Series Analysis to predict the Employee termination and retention rate using Power BI

• Designing and Developing the Dashboard Reports in power BI using DAX functions like table function, aggregation, count, logical, text and date functions in Power BI

• Worked with visual filters, page filters, report filters and drill through filters in power BI reports Health Catalyst, Bellingham, WA, USA Jun 2019 – Sep 2019 Data Analytics Engineer (Project – Population Building)

• Worked on Epic, Cerner data to develop a method for reusable content for Health Catalyst clients

• Worked on Subject Area Mart (SAM) designer and Population Builder for Analyzing Clinical data of Patients

• Wrote SQL queries to extract clinical data & created new metrics for analyzing Heart Failure, Sepsis Patients

• Address: 23726 SE Summerhill Ln Issaquah, WA 98029 • Cell: +1-734-***-**** • ****************@*****.*** • LinkedIn - Sailaja Konda

• GitHub - Sailaja Konda

• Proposed solutions to utilize reusable content, leading to a 60% reduction in time for writing SQL queries

• Performed Care Map analysis for Sepsis, COPD and Analysis on Value Sets

• Performed Analysis on Medication reference Metadata in various EMR source marts to prescribe drugs to patients

• Populated data from Population Builder to Leading Wisely by creating tables and views from JSON data

• Designed dashboards using Leading Wisely for identifying and reporting various key metrics to identify target areas of improvement

• Helped to resolve bugs in integration of Population Builder data analytics tool with the SQL Server backend using Visual Studio

• Used GIT commands and Visual Studio to push the files on Reusable content on Azure Devops to track the progress Tech Mahindra Ltd., Hyderabad, India (Client: General Electric (GE)) Mar 2016 – Aug 2018 Associate Software Engineer (Project - Wind Fleet Visibility)

• Created RESTful web services to Predix 2.0 using Spring Boot by deploying webservices on Cloud Foundry to collect live data of windmill assets

• Processed huge amounts of live data from Predix to make predictions of future windmill asset behavior

• Wrote SQL queries, and stored procedures to get access to various threshold values of windmill assets

• Proposed methods to improve power prediction analysis to optimize the performance of windmill assets

• Analyzed and interpreted data to identify trends, patterns of power availability and power production graphs

• Leveraged data to perform Time Series analysis to predict the power prediction for various windmill farms using Excel and MyDashboard

• Created power analysis dashboards using MyDashboard and reported results and monitor key metrics

• Coordinate with other teams to identify threshold levels of assets to support power prediction analysis

• Helped a team to get access to features of various applications by integrating those using Rally

• Handled the access requests, issues of GE end users and Application Support activities

• Coordinating with Systems analysts and Data Engineers for storing and deleting data Envision Financial Systems, Bangalore, India (Client: Standard Chartered) May 2014 – Aug 2015 Junior Data Analyst

• Develop new and modify existing SQL codes to meet marketing campaign objectives

• Used DDL and DML for writing triggers, stored procedures, and data manipulation on customer transaction data

• Create joins and sub-queries for complex queries involving multiple tables from different databases

• Analyze and interpret data to identify trends, patterns and opportunities for the business and client

• Exporting data to MS Excel for periodic and exception reporting; creating various types of graphs and summaries

• Created Excel macros to automate multiple manual tasks in application to generate reports

• Prepare reports that interpret customer behavior based on various KPI’s to present to internal and external audiences

• Analyzed and documented insights on Source Control using Subversion Method SKILL SET

• Languages – C, SQL, JAVA, R Programming, Python, PySpark

• Tools – MySQL, SSMS, Eclipse, R Studio, Jupyter, Tableau, Power BI, Office 365, MATLAB, Alteryx CERTIFICATIONS

• Applied Data Science in Python (University of Michigan)

• Tableau Analyst (Tableau)

• Data Warehousing for Business Intelligence (University of Michigan)

• MYSQL for Data Analytics and Business Intelligence

• Alteryx Bootcamp and Alteryx Self-Service Analytics

Contact this candidate