Resume

Sign in

Data Analyst

Location:
Fullerton, California, United States
Posted:
April 13, 2018

Contact this candidate

Resume:

Santosh Konchada

Fullerton, CA ac44tz@r.postjobfree.com 714-487-(7959)

LinkedIn: www.linkedin.com/in/santoshkonchada Website: konchada2.github.io

Summary: Data enthusiast with major focus on data exploration, statistical analysis, deriving insights from data and building data models. Extensively used R, SQL, MS Excel for analyzing complex large data sets and data quality checks. Proficient in data visualizations, creating interactive dashboards and BI reports using Tableau and Power BI

Work Experience

Data Analyst intern, Orange County’s Credit Union, Santa Ana, CA (Jun 2017- Dec 2017)

Extensively worked on T-SQL queries to validate data integrity across multiple sources which improved the accuracy of financial and consumer data by 60%

Created set of automated stored procedures to manage data governance and data quality programs

Monitored the performance of data warehouse load process, times and KPI’s in Power BI

Performed BULK insert ETL operations to classify gender across all sources based on the first name

Created interactive dashboards in Power BI by pulling data from MS SQL Server and performed drill-down analysis to detect trends in data quality issues and data load processes

Graduate Research Assistant, Information Systems Department, CSUF, Fullerton, CA (Jul 2016 - Dec 2017)

Supported Department chair and staff of 3 with database activities involving data extraction, loading and cleaning 1000+ alumni records using Microsoft Access to increase workflow efficiency by 30%

Data Analysis - Research Project

• Built a regression model to predict the average salary of MBA grad using rank of university and analytical courses taken

Validated the data and analyzed 5000+ course records using pivot tables, v-lookup in Excel and visualized using Tableau

Marketing Data Analyst, ML Edutech, Hyderabad, India (May 2014- July 2015)

Built complex SQL queries on multiple relational databases to join and analyze 80 + application usage data

Created traffic reports using Google Analytics, build dashboards on Tableau and performed ad hoc analysis

Conducted exploratory analysis using R to improve customer acquisition and usage behavior (number of clicks, installs)

Education

California State University, Mihaylo College of Business and Economics, Fullerton, CA (Aug 2015- Dec 2017)

Master of Science in Information System and Decision Science, Concentration- Business Analyst

Skills

Tools: MS SQL server, Tableau, Power BI, SSRS, Google analytics, MS Excel, PowerPoint, Forecast Pro

Programming Languages: R, python, SQL

Statistical / Data Mining Knowledge: Hypothesis testing, regression analysis, clustering, k-means, multivariate analysis

Academic Projects

Capstone Project- Medicare Analytics (Jan 2017 - May 2017)

Analyzed inpatient data to find average patient cost across each city and state for top 100 diagnostics using Python

Created a user-friendly dashboard in Tableau and provided actionable insights

Predictive Model for S&P Stock Market Prices using R - Data Mining (Aug 2016 - Dec 2016)

Preprocessed the data by removing outliers and conducted exploratory analysis to detect patterns using R and Xl-Miner

Performed feature selection, PCA, Multiple Linear regression, K-Nearest neighbor and Classification methods

Marketing Information Technology - Google AdWords Marketing Campaign (Jan 2016 - May 2016)

Applied digital marketing strategies to build traffic on client’s website using Google Analytics and Google AdWords

Generated cost-efficient keywords for the campaigns using Google keyword Planner and improved CTR by 3%



Contact this candidate