Data Analyst

Reethu Sadhana Chowdary Gundavarapu,

Professional Science Masters in Data Science and Business Analytics

E-mail: ******.*******@*****.*** Ph: +1-980-***-****

PROFESSIONAL SUMMARY

Data analyst with excellent Analytical and Problem solving skills. Currently seeking challenging roles as a data or business analyst that enhance my skill set. I aspire to exceed the expectations of the employer and grow along with my contribution to the company.

Skilled in Data Analysis, Modeling, Cleansing, Reporting and Database Management in various industries.

Extensive experience using Tableau Desktop v 9.3/10.0/10.1/10.2/10.3, Tableau Online and Tableau Server.

Experience in Database Development and Data modeling such as Creation of Tables, Stored Procedures, Views, Functions, Triggers (DDL and DML), indexes, and user defined functions.

In depth knowledge in Tableau Advance Analysis features like Data blending, Customized Queries, Actions, Calculations, Forecasting, Parameters and Trend lines.

Strong background in Quantitative Data Analysis, Predictive, Forecasting and Regression techniques.

Extensively worked on SAS Enterprise Guide/ SAS Enterprise Miner/ SAS Forecast Studio on various transactional datasets.

Developed/Performed various Models/Actions in R including Clusters, Decision trees, Regression, Anova Tables, Word Cloud, Extracted Twitter Data, Merged Datasets and Created Various Visualizations including Bar Charts, Box Plots, Scatter Plots and Pie Charts.

Created key performance indicators using table calculations and manipulating strings, arithmetic calculations, aggregation options and logical functions.

Extracted data and developed Social Media Strategies per requirements of clients and successfully decreased the negative sentiment.

TECHNICAL SKILLS

Databases

Oracle 9i/10g/11g, MySQL Workbench 6.0/6.1/6.2/6.3, Microsoft SQL server 2014/2012

BI Reporting Tools

Tableau 10.x/9.x/8.3 (Desktop/Server/Online/Reader)

SAS Tools

SAS Enterprise Miner 13.1, SAS Enterprise Guide 6.1, SAS Forecast Studio 13.1

Languages

SQL, R, C, Python, D3.js, Java, HTML, PHP

BI Tools

Analytic Solver, WEKA, Radiant

Packages

MS Office

Scripting Languages

Java Script, XML, CSS

Operating Systems

Windows 98/2000/XP/XP Professional/7/8/10

PROFESSIONAL EXPERIENCE

Tableau Data Analyst February 2017 - Present

Reliable Software Resources

Interacted with key Business Users and gathered Business Requirements to identify Key Performance Indicators to be displayed in reports.

Developed dashboards which includes Geographical Mapping functionalities and Advanced Data Visualization features of Tableau involving multiple dimensions and measures.

Worked on all the Data manipulation features in Tableau like calculated fields, Parameters, Table calculations, Sets, Filters, Actions, Custom sorting etc.

Created Custom SQL queries and Parameters. Involved Performance Enhancement activities.

Developed Forecasting Trends based on Historical Data.

Understanding and implementing best practices of Data Visualization.

Environment: Tableau Desktop 10.2/10.3, Tableau Server, Tableau Online, Oracle SQL 10g/11g

Graduate Research Assistant September 2016 – December 2016

University of North Carolina, Charlotte

Queried Survey and Unstructured data and performed sentiment analysis on each subject and student feedback.

Helped in Designing an optimal path based on data from students and professors.

Performed various Analysis methods and Visualizations.

Weekly Reports to the Faculty Director and Presentations to faculty, Director of the program.

Data Science and Business Analytics Intern Summer 2016

Educated Globe Inc.

Integration of a Learning Management Tool (LMS) with a Machine Learning tool to provide an adaptive learning environment for students.

Performed Data Extraction, Cleansing, Analysis and Visualization.

Understanding high level open source LMS, high level Machine Learning products/API.

Considered appropriate Data models and Algorithms for each use case.

Identified Key Performance Indicators and successfully implemented the results.

Environment: SAS Enterprise Miner 13.1, SAS Enterprise Guide 6.1, Python, R, Oracle SQL 10g

Graduate Teaching Assistant January 2016 – May 2016

University of North Carolina, Charlotte

Assisted faculty members with classroom instruction, exams, record keeping, and other miscellaneous projects.

Tutor or mentor students and lead discussion sections.

Prepare presentations and deliver lectures. Helped professors and teachers develop course plans.

Create and write materials such as a syllabus, visual aids, answer keys, supplementary notes, and course websites.

Data Analyst June 2014 – May 2015

Persistent Systems

Utilized various analytical methods to provide all stakeholders with Analysis, Insight and Direction that will moved the Key Business Metrics of success.

Understood and Managed data in various forms and channels - marketing contact and response data, web data, sales data, webinar data, in-product data, purchasing history, etc. - both structured and unstructured.

Forecasted Sales, Profits and various Business Metrics using Historical data and Transactional data.

Created new Databases, Tables, established relationship among tables in a database in Oracle SQL 10g/11g.

Enabled Timely Reporting and Analytics of new product features by ensuring that those features are properly instrumented and surfacing insights in dashboards.

Analyzed the trends and cleaned the data using R and Python to provide insights to the client and identify KPIs.

Correlated Customer Purchase History with exposure to marketing campaigns or frequency of sales calls, etc. to provide insight into campaign effectiveness.

Environment: Oracle SQL 9i, R, Python, Tableau, PHP, HTML

ACADEMIC QUALIFICATIONS

University of North Carolina, Charlotte, NC. 2015- 2016

•PSM in Data Science and Business Analytics. (GPA: 3.8)

•Coursework: Big data for competitive Advantage, Visual Analytics, Business Intelligence, Database Systems, Advanced Business Analytics, Decision Modelling, Knowledge Based Systems, Machine Learning, Consumer Analytics, Social Media Marketing.

VNR VJIET, Hyderabad, India. 2011- 2015

•B. Tech in Electronics and communication. (GPA: 4)

ACADEMIC PROJECTS

•Innovation strategy and Data Wrangling for large unstructured patent data of Microsoft.

Used Hadoop Map-Reduce and Hive to perform data cleansing and using business Analytics tools and methods, we have developed an Innovation strategy for Microsoft recommending how they should use the patent data for accomplishing higher profits.

Predictive analytics for a supermarket and QVC data using SAS.

Used SAS tools and methods to determine which of the customers in their loyalty program should get coupons. Analyzed QVC data to see the factors effecting sales and made recommendations for higher sales.

Designed an online bookstore using PHP and CSS.

Enabled login by new users and previous users and stored all the information in our database. Also, included the search functionality by books, authors etc. for easy access of the website. The website was well received among the audience.

Analyzed Home Medicare Agencies Data.

Integrated the Home Medicare data with tax data and applied various analysis methods to find factors effecting Medicare ratings.

Analyzed customer data based on survey of Indian Restaurants in Charlotte which helped residents in choosing the right pick.

Analyzed and designed Social Media Strategy for Nintendo gaining insights into trends and reducing negative sentiment.

Created Visualizations for crime related data of Charlotte using d3.js and Tableau helping the residents gain knowledge about the density of different crimes at different locations.

Developed Analytical Solver models for many Business problems to maintain balance between profits and inventory.

ADDITIONAL SKILLS

Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Worked as the Treasurer of IETE (Institute of Electronics and Telecommunication Engineers) and managed the funds, persuaded the Principal to conduct workshops.

Examined the ideas and documents received by the participants as the Head of Innovation Club.

Managed and allocated stay for two French associated as a volunteer of AISEC, the world's largest non-profit youth-run organization.

Contact this candidate