Data Analyst, Business Data Analyst

RESHMA RAMESH

******.**********@*****.*** LinkedIn 937-***-****

PROFESSIONAL SUMMARY

• Data Analyst with 3.10 years of professional experience in various domains in IT with core competencies in data analysis and statistical modelling including data extraction, manipulation, visualization and reporting.

• Extensive knowledge of Exploratory Analysis, Predictive Data Modelling techniques, database concepts and writing complex queries using SQL. Created advanced interactive dashboards using Tableau and Excel.

• Experience in designing using Business modelling tools such as Microsoft Visio, writing effective and concise requirements with a strong understanding on Agile and Scrum Methodologies. SKILLS

• Tools: Tableau, MS Office (Excel, Visio, PowerPoint, MS Project), Google Analytics, SAS, IBM SPSS, Weka

• Statistics: Sentiment Analysis, Regression Analysis, ANOVA, A/B Testing, Hypothesis Testing, STATA, R Studio

• Programming Languages: SQL, Python, R, Selenium, Java, C, HTML5, CSS

• Databases: MySQL, Oracle, SQL Server Management Studio, T-SQL, MS Access CERTIFICATIONS

• Analysis and Visualization of data using advanced Microsoft Excel, Tableau 10 A-Z: Hands-On Tableau Training for Data Science EDUCATION

• M.S. in Information Systems University of Texas at Arlington, Texas (CGPA 3.67/4.0) Graduation Year: Dec 2017

• B.E.(Hons) in Electrical Engineering Acharya Nagarjuna University, India (CGPA 8.0/10.0) Graduation Year: Jun 2011 ACADEMIC PROJECTS

• Analysis and Design of Homestay Application using Microsoft Visio Field: UML Aug 2017-Dec 2017 o Created SRS document after analyzing functional, non-functional and feasibility requirements. o Analyzed the requirements and segregated them into high-level and low-level Use Cases, designed activity and sequence diagrams according to UML methodology using Visio.

• Sentimental Analysis on Twitter data using Python Field: Data Science Jan 2017- May 2017 o Performed Web Scraping on Twitter using Twitter streaming API Twython and collected 10K tweets on President Trump from different geographical locations.

o Conducted Sentimental Analysis on the data using TextBlob and calculated polarity and subjectivity scores. o Visualized data using Word Cloud & Conducted topic modelling on the collected tweets to see the kind of topics discussed.

• Statistical Analysis of the dataset, “Contraceptive method choice” Field: Business Statistics Aug 2016-Dec 2016 o Cleaned the dataset and predicted the current contraceptive method choice of a woman based on her demographic and socioeconomic characteristics using Multiple Regression, STATA and a statistical software SPSS.

• Classification and identification of handwritten digits using MNIST dataset Field: Data Mining Aug 2016-Dec 2016 o Carried out Data preprocessing on MNIST (Digit Recognition) Dataset and ran different classification algorithms (KNN, J48 and Naïve Bayes) in Weka to find out the accuracy of each algorithm. o Evaluated algorithms against different metrics like categorization accuracy and AUC to decide which algorithm worked well. PROFESSIONAL EXPERIENCE

Data Analyst Target E-Comm TATA Consultancy Services June 2013 - Jul 2015

• Initiated data management plans, performed data wrangling operations to clean data from various sources and created well-documented, comprehensive data dictionaries.

• Performed forecasting of future sales using statistical techniques and Data Mining techniques and helped in increasing the revenue by 15%. Improved managerial strategy by presenting the insights of the analysis to the higher management.

• Developed advanced interactive dashboards using Tableau to track KPI's, draw insights and recommendations. Generated automated Tableau reports and distributed them using techniques such as Packaged Workbooks and PDF. Junior Data Analyst Apollo Healthcare TATA Consultancy Services Oct 2011 - May 2013

• Gathered data from multiple sources and used SPSS and Excel Pivot tables to track and analyze data.

• Identified patterns in the data and developed functional dashboards and reports using advanced Excel functions. Performed daily data queries and prepared reports on a weekly, monthly and quarterly basis.

• Developed SQL queries to perform Business operations and used views, joins, subqueries to make desired data retrievals in an efficient way. Automated summary reports using Excel VBA reducing manual effort of 2 hours per week.

Contact this candidate