Data Analyst Tableau

Summary:

*+ years of experience in data analysis and statistical modelling including data extraction, manipulation, visualization and validation techniques, reporting on various projects.

Solid understanding of all phases of the Software Development Life Cycle (SDLC) methodology and excellent understanding of Agile, and Scrum.

Experience in developing different Statistical, Text Analytics, Data Mining solutions to various business generating and problem data visualizations using Python and Tableau Design and development of Data warehouse for Business Intelligence data marts, and reporting.

Experience in working with Tableau Desktop, Tableau Server, Looker, and Tableau Reader in various versions of Tableau.

Worked on several python packages like NumPy, pandas, PyTables, Seaborn, Matplotlib, and Scikit-learn.

Worked with Machine Learning, multivariate regression, predictive analytics, data visualization, statistical analysis of large-scale datasets, hypothesis testing, and anomaly detection.

Participated in all phases of data mining; data collection, data cleaning, developing models, validation, visualization.

Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modelling Transactional Databases and Data Warehouse.

Good knowledge with OLTP/OLAP System and E-R modeling, developing database, dimensional, and multidimensional modeling.

Proficient in creating filters, quick filters, data source filters global filters, context filters, user filters, actions, and creating Dashboards for key performance indicators (KPI).

Proficient in developing different types of Tableau Reports and Tableau Dashboards, working at the data model to fit Tableau's needs, and discovering data by Tableau to best answer the business questions.

Knowledge of using PyCharm, Anaconda, Visual Studio, and Sublime Text while developing the different applications in python.

Good knowledge in MS office (MS Excel, MS Word).

Hands-on experience in Stored Procedures, Functions, Triggers, and strong experience in writing complex queries, using SQL Server, MySQL, Oracle, and PL/SQL.

Experience in SQL Query tuning and instance tuning as part of performance tuning.

Good knowledge of tracking systems such as JIRA and version control tools such as Git.

Experience in developing data applications in Linux/Windows environments.

Flexible, enthusiastic, and project-oriented team player with excellent communication skills with leadership abilities to develop a creative solution for the challenging requirement of the client.

Skills:

Methodologies:

SDLC, Agile

Languages:

Python, SQL, Machine Learning

Reporting Tools:

Tableau, Tableau Desktop, Tableau Server, Tableau Reader, Looker

Databases:

MS-SQL Server, MS Access, MySQL, Oracle, PL/SQL

Tools:

JIRA, Git, GitHub, PyCharm, Anaconda, Visual Studio, Sublime Text

Packages:

NumPy, Pandas, PyTables, Seaborn, Matplotlib, Scikit-learn

Operating System:

Windows, Linux

Documentation Tools:

MS Excel, MS Word

Education:

Master of Science – Information Systems (Jan 2019 - Jan2021)

Stevens University of Technology

Stevens Institute of Technology - Hoboken, NJ Jan 2020 – Dec 2020

Role: Data Analyst

Responsibilities:

Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team.

Facilitated the automation process for the reports - which are required to run a monthly and weekly basis using Python script.

Used Pandas, NumPy, SciPy, Matplotlib, and Scikit-learn in Python for developing various Machine Learning algorithms.

Designed and developed various analytical reports from multiple data sources by blending data in a single worksheet in Tableau Desktop and created TreeMap, Heat maps, and background maps

Create customize SQL Queries using MySQL Management Studio to pull specified data for analysis and report building in conjunction with Crystal Reports.

Developed Data Mapping, Data Governance, Transformation, and Cleansing rules for the Master Data Management Architecture involving OLTP and OLAP.

Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.

Manage Departmental Reporting systems, troubleshooting daily issues, and integrating existing Access databases with numerous external data sources including (SQL, Excel, & Access).

Utilized Tableau server to publish and share the reports with the business users.

Wrote several SQL Queries using SQL Assistant for Ad Hoc Data Pull request.

Perform data collection, data cleaning, data wrangling, and data analysis on the data sets in Python.

Used JIRA and Git for version control in the project management.

Procedures/Functions/Packages optimization using advanced PL/SQL features and dynamic SQL.

Involves a process of deep analysis of over 100 rules with Python to find concepts from ontologies that make the rules dynamic.

Assisted in the process of building a rule engine for the company application.

Stevens Institute of Technology - Hoboken, NJ Mar 2019 – Dec 2019

Role: Data Analyst

Responsibilities:

Utilized Agile/Scrum methodologies to monitor steer and develop project objectives.

Imported the customer data into Python using Panda’s libraries and performed various data analysis - found patterns in data which helped in key decisions for the company.

Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation.

Highly immersive Data Science program involving Data Manipulation & Visualization, Web Scraping, Machine Learning, Python programming, SQL, Unix Commands, and Databases.

Worked in data investigation, responsible for interpreting variables and data visualization.

Managed worksheets using the manual and automated process on the Tableau development server.

Utilized Tableau and custom SQL features to create dashboards and identify correlation.

Developing Programs based on Oracle, PL/SQL for all the extracts, and interface changes.

Generating various capacity planning reports (graphical) using Python packages like NumPy, Matplotlib.

Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.

Designed Tableau bar graphs, scattered plots, and geographical maps to create detailed level summary reports and dashboards.

Used JIRA for bug tracking and fixing in project management and version control tools like GitHub.

Importing and Exporting Data from Access Database and building SQL Queries for data manipulation Reporting in Access and VLOOKUP in Excel.

Business Analyst Astral Technologies Mumbai, India Aug. 2018 – Oct. 2018

Managed project plan, drive project completion, facilitating issues, maintaining control over scope and ensuring that project artifacts are maintained

Managed project risk. Identify and engage key project stakeholders/partners to avoid unanticipated issues and gaps during project execution

Responsible for identifying potential risks to client data and services and providing recommendations on steps to remediate

Implement systems to automate third party management, assess their vendor’s overall cybersecurity posture, and monitor for cybersecurity incidents

Data Analyst Cabme.in Mumbai, India Aug. 2016 – Oct. 2016

Devised and implemented databases, data collections systems, data analytics and other strategies that optimize statistical efficiency and quality

Analysed multiple functions and levels of the organization and effectively, both verbally and visually, communicate findings and insights to non-technical business partners

Researched on big data/analytics projects that gather and integrate large volumes of data, perform analysis, interpret results, and create insights and recommendations for organization-wide use

Worked within the BP&A team to develop and implement visualizations of data analyses and predictive analytics to provide people trends and insights to the broader organization

Market Research Analyst Feedback Consulting Mumbai, India Jan. 2016 – Aug. 2016

Ensure that solutions constructed meet requirements in areas such as compatibility, interoperability, flexibility,

scalability, performance and stability

Built closely with business partners in gathering detailed business requirements, establishing business definitions, translating to technical requirements for development team and gaining approval

Create report mock ups based on requirements and coordinates with technical team in finalizing design and

receiving sign

Recommended process/customer service improvements, innovative solutions, policy changes and/or major

variations from established policy that must be approved by appropriate leadership prior to implementation

Academic Experience: Root cause analysis on jobs automation

Academic Experience: Credit card fraud detection

Rohan Shah

Data Analyst

Location: Jersey City, NJ-07307 Mobile: 551-***-**** Email: ****************@*****.***

Contact this candidate