Data Analyst Tableau

ANIKET AVASARKAR

862-***-**** adfcj1@r.postjobfree.com https://www.linkedin.com/in/aniketavasarkar/

Summary

The diverse job roles and multiple domain experience has helped me gain high proficiency in Data analysis, Data Mining, ETL process, Reporting services, Database Design and Data modeling.

Knowledge of implementing methodologies like Software Development Life Cycle (SDLC), Agile, SAFe, RUP and Scrum environment.

Experience in creation / updating of Clustered and Non-clustered Indexes to keep up the SQL Server Performance.

Extensive knowledge and hands on experience with Dynamic SQL, My SQL, PLSQL and MSSQL queries in RDBMS Environment.

Experience in My SQL, SQL Server DTS (Data Transformation Services), Azure SQL Database, RDBMS and SSIS (Integration Service) package design, construction and deployment.

Well-experienced using different synchronous transformation functions like Aggregate, Data conversion, Lookup, Derived column, Merge, Merge join, OLE DB Commands, Conditional split, Union all etc.

Created visualization dashboards, Stories/Reports, KPIS using Tableau and Power BI for the customer acquisition and for creating business strategies.

Generated data visualizations, interactive dashboards and reports using tools like SQL SSRS, IBM Cognos, Power BI and Tableau.

Experience in BPMN, business requirements gathering, database design and assisting in development of web based and client/server.

Hands on experience in test plans, test scripts and executions of test cases to ensure application meet the user requirements.

Generated various dashboards, visualizations, reports, score carding using tools like Tableau and Power BI using the data extracted from different data sources such as Teradata, Oracle DB, MS SQL Server and Microsoft Access.

EDUCATION

Master’s in Information Technology and Analytics, Rutgers University, Newark, NJ, USA May 2020

Bachelors in Electronics and Telecommunication, University of Mumbai July 2013

SKILLS

Programming Languages: R, Python, Java, C++, JavaScript

Machine Learning: Regression, SVM, Random Forest, Clustering, Classification, A/B Testing, Time-series forecasting

Database: Oracle SQL, MySQL, Postgre SQL, Teradata, MS Access

Data Visualization Tools: Advanced Excel, Tableau, Google Analytics, MS Power BI, Alteryx, ETL Tools

Statistical Analysis Tools: MS Excel, SAS, R, SPSS, Stata

Other Tools: Service Now, HPSM

Business Analytics: Functional Requirements, Documentation, Requirements gathering, User Acceptance Testing, User

Stories, BRD, Agile, Scrum, Requirements Elicitation, Use Case Diagrams

Application: MS Office (Word, Excel, PowerPoint, Access), JIRA, Confluence, Informatica, AWS, MS Visio

WORK EXPERIENCE

Business Data Analyst, Orange Business Services, Mumbai, India Aug 2017 – Feb 2018

Automated Excel reports using macros, pivot tables, conditional statement which increased efficiency of the client delivery by 25%.

Performed exploratory data analysis using Python to generate insights that helped the Client to look into the problem areas.

Built compelling, robust, effective interactive dashboards in Tableau that answered key business questions.

Performed data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation, data analysis.

Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Power BI and Tableau by analyzing sales figures & financial figures.

Responsible for identifying, analyzing and translating the business requirements various artifacts such as Business Requirement Document (BRD) and Functional Specification Document (FSD).

Conducted thorough questioning to understand and record the requirements as user stories and created visual models which are easily understood by business and technical personnel.

Created Use Case Scenarios and maintained the Textual Use Cases (Business User stories and modeled Use Case Diagrams, Activity Diagrams and Business Flow Diagrams).

Facilitated JAD Sessions, Interviews, Surveys/Questionnaire and Focus Groups to elicit requirements from stakeholders, business users and SME’s for business requirements.

Created Mock-up screens and UML diagrams such as sequence, activity and use case diagrams using MS Visio for proper visualization.

Created and developed Power BI and Tableau visualizations for the Key Performance Indicator (KPIs) and trend analysis.

Business Data Analyst, Capgemini, Mumbai, India Feb 2015 – Jan 2017

Developed statistical models that reduced the data processing times by up to 70%, thereby, increasing the client’s profit by 20%.

Supervised and trained new interns in analyzing and visualizing data using SQL and Power BI.

Generated action filters, parameters and calculated sets for framing dashboards and worksheets in Tableau Desktop.

Built data models using regression analysis, forecasting algorithms, and A/B testing to analyze the business metrics.

Developed ad-hoc reports using SQL queries, stored procedures, views, common table expressions to procure customer data.

Collected, cleaned, and analyzed data to identify trends to recommend on the process improvement and correlation to produce accurate results.

Generated various dashboards, visualizations, reports, using tools like Tableau and Power BI from the data extracted from different data sources such as Teradata, MS SQL Server and Microsoft Access.

Designed ETL Process using ETL tools (Informatica) and Implementation of Data Movement, Error Capturing & Reporting.

Used SAS statistical software to analyze and interpret data, thereby, identifying key business metrics and drawing conclusions.

Built dashboards and reports using Tableau to visualize the KPIs that answered key business questions.

Developed & presented user stories to communicate user requirements to the Product owner and the development team, and assisted in creating the Product Backlog by working with the Product Owner.

Participated in Backlog refinement meetings for managing the higher priority product backlog items.

Active involvement in the Sprint ceremonies: Sprint Planning meeting, Sprint Review Meeting, Retrospective, and Product Backlog Refinement.

Documented user stories using Rally and worked with the product owner to define SMART acceptance criteria.

Performed Document analysis, conducted interviews with various teams and Executives to understand about As-Is process and dependencies and identifying process improvements in the To-Be process.

ACADEMIC PROJECTS

Wine Quality Prediction using Python, NumPy, Pandas

Built and compared predictive models to analyze wines and predict quality of each based on chemical properties. Designed Random Forest, SVM, Decision Tree, and KNN models using Python.

Achieved highest accuracy (83.63%) with Random Forest. SVM - 80.83%, Decision Tree - 75.96%, KNN - 73.92%. Visualized results with matplotlib and seaborn.

Analysis of Top 50 Spotify Songs for 2018 using Python

Achieved 96.67% accuracy for machine learning model designed to determine key attributes among most popular Spotify songs from 2018. Built and compared Random Forest, KNN, Decision Tree, and multiple regression models in Python.

Analyzed attributes such as danceability, energy, music key, and loudness. Visualized results in Tableau.

Brent Oil Prices Prediction using R, Time Series

Predicted oil prices for next 5 years using time series methods such as Average Method, Naive Method, Drift Method, Seasonal Naive Method, SES, and Holt's Linear Trend Method. Programmed ARIMA, Autocorrelation, Regression in R using ts, stl, forecast, FitAR, season, and predict packages.

Found that Drift Method is best or weekly and monthly data, while ARIMA model is best for the yearly data.

Contact this candidate