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)