Resume

Sign in

Data Analyst

Location:
Carpentersville, Illinois, United States
Posted:
February 22, 2018

Contact this candidate

Resume:

SNEHA REDDY

Chicago, IL 614-***-**** ac4key@r.postjobfree.com

PROFESSIONAL SUMMARY

3+ years of experience as a Data Analyst with deep cross-industry expertise in Analytics, Business Intelligence, Database Marketing, Statistics and passionate about analytics that deliver actionable insights, monetize marketing outcomes, drive optimizations & data-driven business decisions.

Thought leader in data visualization, advanced analytic techniques such as predictive analytics, content recommendations, data mining, data strategies, analytic platforms.

EDUCATION

Master of Science in Management Information Systems December 2017 University of Akron, Akron, Ohio GPA: 3.6/4.0

TECHNICAL SKILLS

Programming Languages : C, C++, C#.Net, JAVA, XML, Python

Visualization Tools : Tableau 10.3.2, Qlikview, Spotfire, Power BI, KNIME, Google Analytics, Alteryx

Statistical Tools : JMP Pro 13, R

MS office suite : Word, Excel, Power Point, Access, Visio, Project

Databases : MySQL, MS SQL Server 2008 R2/2005, PL/SQL, Oracle 11g

Database Skills : Data Modeling, SQL Performance Tuning and Data Analysis using Tableau

Other Tools : IBM Rhapsody, Visual Studio, MATLAB, Oracle Data Modeler, Jupyter Notebook

WORK EXPERIENCE

The University of Akron: Akron, Ohio

Research Analyst Sep2016-Dec2017

Perform data analysis and data profiling using complex SQL on various source systems

Generate ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from oracle database systems

Enforce referential integrity for consistent relationship between parent and child tables

Prepare day to day, weekly and semester reports on student testing patterns and their grades

Work extensively on SQL querying using Joins, Alias, Functions, Triggers and Indexes

Extensive use of EXCEL PIVOT tables to analyze the result data set

Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, graph and chart manipulation using EXCEL.

Profiling of students based on key performance indicators and dividing into various groups

Use statistical methods and different classification algorithms to analyze the pattern of grades for the courses in every semester by using Python

KREATIV WEB Solutions: Hyderabad, India

Data Analyst May2014-June2016

Involved with Kreativ Web Solutions Marketing and Analytics team for driving the revenue and profit growth in the company’s online and offline business through the development and implementation of analytics, decision support systems and predictive models.

Roles &Responsibilities:

Analyze requirements, create use cases, activity diagrams using Ms Visio

Assist in database designing, writing views, stored procedures and query optimization using SQL

Perform data extract, clean, load, transform

Responsible for segmentation of customers based on their buying profiles

Predictive Modeling and Data visualization using Python and Tableau

Involve in search engine optimization (SEO) team to provide the best marketing path for the client by performing exploratory data analysis to draw insights using Tableau

Create dashboards based on in-depth weekly, monthly, quarterly and annual metrics reporting of current online traffic, conversion trends and highlights of ongoing marketing campaigns using Tableau

Perform business intelligence activities including data mining and analytical processing to identify trends in the data then reporting and charting findings for dissemination within the company; provide ad-hoc reports as requested under the guidance of senior data analyst

Collect, consolidate and analyze data/metrics from multiple sources such as site analytics and Store analytics

Built a predictive model using the machine learning algorithms by studying the response received for the web designs in KNIME and Python

Perform statistical analysis including univariate, bivariate and multivariate methods, Logistic regression in Python to analyze company’s data and E-commerce website in order to identify business trends and create visual outputs for the business to make decisions

Responsible for analyzing data and articulate insights as stories, which are then converted into actionable recommendations for business initiatives

Hydro Chem. Solutions Secunderabad, India

Sales Data Analyst Jan2013 – Apr2014

Create SQL queries and stored procedures, maintaining and tuning stored procedures based on day to day job, monitoring the performance of the database

Use Power BI and tableau to transform data from various sources like Excel, Database into visually appealing, interactive visualizations called dashboards

Experience with data cleansing and Data migration for accurate reporting. Thoroughly analyze the data and integrated different data sources to process matching functions

Use different statistical modeling techniques to analyze campaigns for insights into attrition behavior, performance of campaigns over time, interpreted data and provided ongoing reports using JMP

Participate in reviews and meetings to evaluate documents, plans, requirements, specification and supported business team with various weekly reports

Identify trends in data and recommend actions to senior analyst from complex data sets

Report internal stakeholders utilizing business intelligence to support and grow the business

Bharat Heavy Electricals Limited Hyderabad, India

Reporting Analyst Sep2012 – Dec2012

Analysis of the sales performance metrics for the machinery of all departments

Advanced data from primary and secondary sources and provided ad-hoc reports

Conduct analysis from the surveys taken from all departments and employees

Monitor working Computer Numerically Controlled machines

ACADEMIC PROJECTS

Chicago Crime Report Analysis: Analysis of the data on criminals and segment them based on their profiles to create data visualization charts (Tableau, R, Power BI )

OGON Project: Analyzed the various product categories and used market basket analysis to study cross sell patterns, customer buying patterns and recommended the changes to increase their customer base (Spotfire, Python)

Business Analytics Project: Provided insights of real estate market in NE Ohio by using different statistical models like regression model, descriptive statistics and correlation analysis (JMP Pro)

Goodyear: Reviewed the existing knowledge management practices (SWEEPS) of the organization and studied customer survey data to analyze the problem of drop in sales (Tableau, Visual Basic 4.0, Microsoft Access database)

PROJECT MANAGEMENT: Designed a project schedule and work breakdown structure for the new driver’s license identification (DL/ID) document system for State of OHIO by doing (MS Project)

Performed Machine Learning Techniques to predict the profit of a chain, and drew insights from the visualizations made in KNIME. (R, KNIME, Tableau)



Contact this candidate