Tableau Data

Shaistha Mohammed

Summary

Over *+ years of experience in IT industry in design, development, implementation and maintenance of BI tools and applications, report development, and visualizations using Tableau, SSRS, Oracle, SQL Server, etc.

Well versed experience in Tableau Desktop and Tableau Server in various versions of Tableau 7.x/8.x/9.x/10. x/2018.X

In depth knowledge of Data modelling and SDLC phases such as Requirement analysis, Design, Development, Implementation, Deployment, and maintenance with strong understanding on methodologies such as Waterfall, Agile and Scrum.

Experienced in developing reports and dashboards leveraging a business intelligence and/or reporting platform.

Experience creating and optimizing SQL queries and working with databases

Proficient in creating Tableau Visualizations with Dashboards using tableau features like Action Filters, Quick Filters, Hyper Linking, Drill down, and Ranking.

Expertise in designing dashboard reports with Key Performance Indicators (KPI) for higher authorities by making use of local and global filters, Attributes, Facts, Hierarchies, Level of Detail, Calculated fields, analytics commands, groups, sets, parameters, Transformations, Prompts in Tableau and perform ad-hoc analysis for monthly, weekly reporting for efficient decision making.

Cleaning and blending various data sources Data mapping from source to target database, skilled in best practices in determining a live connection versus Tableau Data Extract.

Ability to achieve optimization through extracts or SQL queries, troubleshooting, performance tuning and supporting Business reporting platforms effectively.

Created Visualizations using integrated Analytics in Tableau Desktop by using Worksheet Summary card, and also used Advanced Statistical Tools such as customizing Box plots and creating confidence Intervals.

Worked on providing Meaningful Context to Visualizations by using Tools such as Labels, Annotations and Tooltips.

Very good knowledge in entire Business Intelligence Project Life Cycle and proficient in visualizing through Tableau to analyze, attain insights into large datasets, create visually compelling and actionable interactive dashboards and reports.

Mastered in ability to design and deploy rich Graphic visualizations using Lines and Pies, Bars, Scatter plots, Maps, Bubble charts, Bullets, Histograms, and highlight tables.

Well experienced in assisting/training users to modify and create worksheets and data visualization dashboards using Tableau Desktop, administered user, user groups, and scheduled instances for reports in Tableau.

Worked on various reports using best practices and different visualizations like Donut charts, Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Advanced Tableau experience from dashboard design and development. Expertized with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions

Perform process analysis to identify issues and work for solutions across multiple environments

Good knowledge on working with extracts, facts and dimensions.

Excellent interpersonal and customer relational skills, communication, presentation skills and leadership qualities.

Enthusiastic and goal-oriented with ability to communicate to both the end users and technical team for requirement gathering, documenting, and suggesting the capabilities of Tableau Visualization for effective outcomes and able to drive the team with challenging spirit.

Technical Skills

Languages

SQL, HTML, CSS, XML, Java, Java Script, Python

Operating Systems

Windows 7,8,10, MAC OS X

Tools

Tableau, SSRS, Oracle 11g Database, MS Office Suite, GitHub, MS Project 2013.

BI Tools

Tableau 2018.X, 10.x, 9.x, MicroStrategy, SQL Server Reporting Services (SSRS), Tableau Server

Methodologies

Waterfall, Agile, BI Life cycle

Data Modeling

MS Visio

Database Tools

SQL Developer, SQL Server Management Studio, Teradata SQL Assistant

Data Blending Tools

Informatica, MS SQL Server Integration Services (SSIS).

Professional Experience:

Macys Technologies, Duluth, GA Mar 2018 – Current

Sr. Tableau Developer

Macy's is America's department store, an iconic brand and retail industry leader. Our Data visualization team works across Marketing analytics units to help our business turn data into valuable information and to understand a phenomenon visually using tableau. The Project is to develop deliver value to various business partners by providing capabilities to analyze large data sets and provide Business Intelligence reporting solutions by creating reports, dashboards, and scorecards in Tableau.

Responsibilities:

Collaborated with campus users to create and support Tableau data visualization objects and custom dashboards.

Developed key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Created Dashboards with interactive views using Dashboard actions, trends and drill downs along with user level security.

Created sets/groups to display top products based on their sale.

Involved in full project lifecycle of SDLC and coordinated with all project teams.

Interacted with Subject Matter Experts & End Users to gather business requirements.

Acted as liaison between Business Intelligence and Business User groups to relay change requests.

Mentored business power users to create reports/dashboards using tableau desktop.

Built complex calculations using advanced functions (LOD, RANK_DENSE, ATTR, DATEDIFF, STR, IFs, nested IFs, Windows functions, and QUICK TABLE calculations).

Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations to develop interactive views / dashboards and to facilitate statistical analysis of data for end users.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Tested dashboards to ensure data was matching as per the business requirements and if there were

any changes in underlying data.

Scheduled frequency and time to refresh data when sources are published or extracted to server.

Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Used Data Blending, Groups, combine fields and aggregated fields, spotlight into compare and analyze data in different perspectives.

Troubleshoot and fix user issues related to Tableau reports (underlying data or performance).

Environment: Tableau (Desktop/ Server) 2018.x, 10.x/9.x, Teradata, Teradata SQL Assistant, SQL Server 2012, PL/SQL, SQL Developer, Informatica Power Center, Python, SQL Server, Control-M.

KeyBank, Cleveland, Ohio Sep 2016 – Feb 2018

Business Intelligence (Tableau) Developer

Key Bank provides investment management, retail and commercial banking, consumer finance and investment banking products to individuals and companies throughout the United States and, for certain businesses, internationally. Our team uses analytical techniques to establish long term sales, servicing, and behavioral targets for Key Banks's clients.

Responsibilities:

Involved in the entire project lifecycle and communicated with the project teams.

Provided better insights using Mark types and Mark properties for huge data sets and perform ad-hoc analysis to report the performance monthly and weekly.

Created data extracts and published the sources to tableau server, refreshed extract in Tableau server from Tableau desktop.

Designed the reports with user level security with best practices and different visualizations, built complex calculations using advanced functions.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Communicated with the client and the BI team to collect the site specifications and business requirements to design functional and technical Business Requirement Document (BRD).

Mentored the BI teams in creating reports, dashboards in tableau desktop.

Designed and developed complex active reports and dashboards with various data visualizations using Tableau desktop on customer data.

Translated the business needs into a documentation for assigned project teams and designed conceptual business process models.

Developed the key indicators for appropriate tracking reports with graphical and written summations to help in quality improving initiatives.

Created interactive dashboards with views and actions, drill downs, trends, and created sets to show progress in the fields based on the success rate.

Implemented the features of Tableau such as Data blending, Data extracts, Forecasting, Dashboard actions, calculations, views/dashboards, and statistical data analysis for end users.

Tested the SQL scripts to develop the reports, dashboards, scorecards, and handled the performance issues very effectively.

Published the developed dashboards, reports on to the Tableau Server allowing the end users to access and view the data from server.

Monitored the project performance to be on-time and on-budget with the assigned efforts for the satisfaction of the authorities.

Environment: Tableau 9.x,10.x, MS Access, MS Excel, MS-SQL Server 2008, Oracle 11g, SQL, PL/SQL, T-SQL, Microsoft office 2007

United Health Group, Eden Prairie, MN Jan 2014 –Aug 2016

Role: Tableau Consultant

United health group is a health care industry and our team are committed to changing health care through outstanding service, valuable products, measurable savings and health care plans designed to fit members lives, year after year. The project is to implement Business Intelligence reporting solutions by creating reports, dashboards, and health care plan designed in Tableau.

Responsibilities:

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Analyzed requirements for various reports, dashboards and created proof of concept / prototype of the same using Tableau desktop.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

Creating basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios

Implemented Grand Totals, Sub-totals, and Changing Aggregation for Customizing the Data.

Created Hierarchies, sets, combined sets and Groups in Tableau.

Generated ad hoc Tableau reports on demand for providers.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Extensively developed different types of visualizations in Tableau like Dual Axis, bar charts, Water Fall charts, Bullet graphs, box and whisker plots.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Actively participated in clarification meeting with the Clients.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.

Environment: Tableau 8.0, Teradata, Oracle 10g, SQL Server 2008, SQL Developer, MS VISIO, MS Suite, Informatica, Micro Strategy, Erwin, Microsoft (Word, PowerPoint, Excel, Outlook)

VISA Inc - Ashburn, VA Feb 2012 – Dec 2013

SSRS Developer

Responsibilities:

•Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

•Worked with dimensions, Fact Tables, Star Schema design and other Data Warehouse concepts.

•Export and import data from Flat file, CSV file, Excel to/from SQL Server database using SSIS.

•Developed Complex SSIS Packages to load data into Staging and Data Warehouse systems.

•Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.

•Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.

•Developed, monitored and deployed SSIS packages for ETL flow to validate, extract, transform and load data into database.

•Managed and monitored the system utilization by using the query optimizer and checking the execution plan.

•Design and Developed multiple Enterprise reports using SSRS from both OLTP and OLAP databases

•Documented and delivered Functional Specification Document to the project team by using SQL Server.

•Involved in scheduling the reports and setting security for reports.

•Administered interface to organize reports and data sources, schedule report execution and delivery, and track report history using SSRS.

Environment: MS SQL Server 2008R2/2005, Visual Studio C#, Windows Server 2003, 2008R2, T-SQL, Visual Studio 2008

Education:

Bachelor of Technology – JNTU – India -2011.

Contact this candidate