Data Analyst Tableau Developer

MANJULA VUSKAMURI

Email: **************@*****.***

Ph. #: 404-***-****

Professional Summary:

•Experienced Data Analyst with 5 years of experience in Data Extraction, Data Modelling and Data Visualization.

•Domain knowledge and experience in Retail, Banking and Manufacture industries.

•Proficient in Predictive Modeling including Regression Models, Decision Tree, Random Forests and Sentiment Analysis.

•Knowledge on Natural Language Processing (NLP) algorithm and Text Mining.

•Proficient in Python 2.x/3.x with SciPy Stack packages including NumPy, Pandas, SciPy and matplotlib.

•Expert in performing DDL/DML/DCL commands using SQL Server Management Studio SSMS.

•Expertise in writing SQL Queries, sub-queries, and complex joins for generating Complex Stored Procedures, and Views.

•Excellent Tableau Developer, expertise in building, publishing customized interactive reports and dashboards with customized parameters and user - filters using Tableau (9.x/10.x).

•Involved in design and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other by making use of actions according to the business/client requirement.

•Experienced in Agile methodology and SCRUM process.

•Experience in using Git Hub for version control.

•Strong business sense and abilities to communicate data insights to both technical and nontechnical clients.

•Strong communication skills and willingness to take initiative to contribute beyond basic responsibilities along with the ability to effectively present to the target audience.

TECHNICAL SKILLS:

•Machine Learning: Regression analysis, Bayesian Method, Decision Tree, Random Forests, Neural Network, Sentiment Analysis, K-Means Clustering, KNN and Ensemble Method, Natural Language Processing (NLP)

•Databases-MS SQL Server 2005/2008/2008R2/2012, Oracle 10g/9i.

•Programming Languages-SQL, Oracle, Amazon S3 bucket, Python.

•Requirements Management- Microsoft Office (Word, PowerPoint, Excel), Git Hub

EDUCATION:

B.S.Computer Science, MKR College, Devarakonda – Osmania University – 2005

ACHIEVEMENT:

Expert level trainer on Tableau at company level and was awarded best trainer in the year 2018.

EXPERIENCE:

Client: Vonage, Atlanta, GA October 2018 – Till Date

Role: Data Analyst

Responsibilities:

•Participated in scrum meeting and sprint meeting to coordinate with software development life cycle process; involved in confidential global team environment.

•Gathered requirement from team lead and prepared for technical documentation.

•Created and maintained SQL database object such as tables, views, indexes and store procedures with SQL Server Management Studio (SSMS) 2012.

•Developed Store Procedure in T-SQL to replace existing SSIS packages in ETL process and gained better Performance.

•Involved in generating reports using Tableau.

•Cleaned data source in SQL Server and prepared data source in Tableau metadata using complex joins, Custom SQL, split and data blending.

•Designed, developed, and maintained daily, weekly, monthly and year-end summary, trending and benchmark reports repository in Tableau Desktop.

Environment: Tableau Desktop 7.0, Tableau Server 7.0, MS SQL Server 2012, GitHub.

Client: Delta Technology October 2016 – Sep 2018

(Consumer Debt Management, Financial & Manufacturing)

Atlanta, GA

Role: Data Analyst/ Data Scientist

Project: 1

Responsibilities:

•Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping.

•Performed data imputation using Scikit-learn package in Python.

•Conducted analysis on assessing customer consuming behaviors and applied customer segmentation with clustering algorithms such as K-Means Clustering and Hierarchical Clustering.

•Built classification models include Logistic Regression, SVM, Decision Tree, Random Forest to predict Customer Churn Rate.

•Used F-Score, AUC/ROC, Confusion Matrix, MAE, RMSE to evaluate different Model performance.

•Utilized natural language processing (NLP) techniques to Optimized Customer Satisfaction.

•Expert in all areas of SQL Server including Tables, views, stored procedures and maintaining the data integrity.

•Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer, and Cross Joins.

•Designed rich data visualizations to model data into human-readable form with Tableau and Matplotlib.

•Built few reports in Tableau and Excel for the management to track the performance of representatives and their current business situation which is used as a single source of truth.

•Developed data visualization using Cross tabs, Heat maps, Box and Whisker charts, Pie charts and Bar charts.

•Responsible for creating calculated fields, geo coding and hierarchies using Tableau Desktop.

•Used GitHub for version controlling.

Environment: Python 3.x (Scikit-Learn/SciPy/NumPy/Pandas/NLTK/Matplotlib/Seaborn), Tableau Desktop 2019, Tableau Server 2019, Machine Learning (Regressions, KNN, SVM, Decision Tree, Random Forest), NLP, Agile/SCRUM, MS SQL Server 2017, GitHub.

Project: 2

Responsibilities:

•Performed optimal pricing analysis on Sales growth 2018 Vs 2017 and Sales growth Vs Budget.

•Performs complex pattern recognition of automotive time series data and forecast demand through ARIMA models for multivariate time series data.

•Strong Transact-SQL query writing skills DDL, DML, and DCL.

•Developed complex stored procedures using SQL Server.

•Worked with performance tuning of already written SQL codes.

•Designed, developed, and maintained daily and monthly summary, trending, and benchmark reports repository in Tableau Desktop.

•Generated complex calculated fields and parameters, filters, dynamic sets, groups, actions, custom color palettes, statistical analysis to meet business requirements.

•Implemented visualizations and views like combo charts, stacked bar charts, pareto charts, donut charts, geographic maps, spark lines, crosstabs etc.

•Published workbooks and extract data sources to Tableau Server, implemented row-level security and scheduled automatic extract refresh.

Environment: Python 3.x (Scikit-Learn/SciPy/NumPy/Pandas), Tableau (Desktop 10.x/Server 10.x), Amazon Redshift.

Project: 3

Responsibilities:

•Analyzed the data from Oracle and created reports in excel to assist client in observing weekly trends in revenue generated.

•Maintained and developed complex SQL queries, stored procedures, views, functions, and reports that meet customer requirements using Oracle.

•Created Views and Table-valued Functions, Common Table Expression (CTE), joins, complex sub queries to provide the reporting solutions.

•Optimized the performance of queries by removing the unnecessary columns and redundant data, normalized tables, established joins and created index.

•Developed and implemented several types of Financial Reports (Income Statement, Profit& Loss Statement, EBIT, ROIC Reports) by using Tableau desktop.

•Built an Executive Dashboard for the load details and revenue generated through loads on Tableau which is used across the company as a single source of truth.

•Automated daily report using Python.

Environment: Python 2.x, Tableau (Desktop 8.x/Server 8.x), Oracle 11g.

Contact this candidate