Data Analyst Tableau Developer

Email: adwarr@r.postjobfree.com #832-***-****

linkedin.com/in/ambreenimran

Ambreen Imran

BI Data Analyst – Tableau

1

Profile

Industrial experience in different domain like Retail, Medical Insurance and claims, Banking and Finances

5 years of experience in Tableau reporting (Desktop, Server) and data analytics. As a BI Developer, I was involved in designing and deploying complex data visualizations reports using Tableau Desktop. At the same time, able to transform the data at the backend using SQL codes to bring highly required data into dashboard

Experience in building the End-To-End complete dashboard with all required functions like Context filters, Action filters, Tooltip info, Parameters and so on. Able to present to the team with different levels of data like YTD, MTD, MOM and YOY metrics.

Involved in Tableau server monitoring, extend the dashboard access and revoke the access to the respective dashboards

Establishing the connection to Snowflake and other related data sources to blended the data as per project requirements

Fluent in communicating with the business partners and to get the requirements.

Expertise in designing and creating various analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization.

Knowledge in Tableau server commands to migrate workbooks and Tableau server backup and debugging.

Used SQL queries to write complex stored procedures, queries to connect to SQL Server to pull the data in tableau desktop. Validated the results in Tableau reconciling data using SQL queries. Extensive knowledge in different reporting objects like facts, attributes, hierarchies, calculated fields, transformations, filters, sets, groups, prompts, parameters, etc.

Possess strong knowledge of database management in writing complex SQL queries, joins, query optimization and resolving key performance issues.

Involved in reviewing business requirements and analyzing data sources from Flat File Excel, Oracle, SAS, Teradata, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Worked with SQL Developer, Microsoft Access databases, and Excel Spreadsheet.

Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.

Highly motivated team player and a quick learner with good communication, strong problem-solving skills and excellent in presentation and interpersonal skills.

Extremely well organized, meticulous, and highly self - motivated. Skills

Reporting and Analytics: Tableau, Base SAS

Databases: SQL Server, Oracle, AWS Redshift, MySQL, Snowflake, Hadoop

ETL: SSIS, Alteryx BI

SQL queries and scripts, data import/export using various tools and platforms

Data consistency checks, data analysis and design, programming, and concept testing. Email: adwarr@r.postjobfree.com #832-***-****

linkedin.com/in/ambreenimran

Ambreen Imran

BI Data Analyst – Tableau

2

INDUSTRY EXPERIENCE

Client: USAA

Duration: October 2021 to March 2023

Worked with a business partner to get the requirements and build the detailed analysis before starting the project. After the approval, we have started creating the data tables in Snowflake based on the different products. Finally connected to Tableau to build the dashboards as per the requirement. Responsibilities:

As a BI Developer, I was involved in designing and deploying complex data visualizations reports using Tableau Desktop. At the same time, able to transform the data at the backend using SQL codes to bring highly required data into dashboard

Data blending on SQL Server database and generated interactive dashboards

Tested reports, uploaded tableau dashboards on to server, and provided production support for tableau users.

Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

Experience in building the End-To-End complete dashboard with all required functions like Context filters, Action filters, Tooltip info, Parameters and so on. Able to present to the team with different levels of data like YTD, MTD, MOM and YOY metrics.

Involved in Tableau server monitoring, extend the dashboard access and revoke the access to the respective dashboards

Establishing the connection to Snowflake and other related data sources to blended the data as per project requirements

On the tenure of transition from Hadoop to Snowflake, involved in various testing and debugging the data using Excel, SAS and SQL

Worked on SAS to validate tables that migrated to Snowflake from Hadoop

Created new schemas when migrating data from Hadoop to Snowflake

Fluent in communicating with the business partners and to get the requirements.

Expertise in designing and creating various analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization

Client: Cardinal Health

Duration: April 2018 to September 2021

I worked as a Tableau developer with focus on reporting and creating dashboards. Worked with a business analyst to analyze data, understand the user requirements, layout, and look and feel of the application. Responsibilities:

Data blending on SQL Server database and generated interactive dashboards

Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies

Created data validation SQL Queries to analyze source data from legacy systems to EPIC Claims Systems

Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters Email: adwarr@r.postjobfree.com #832-***-****

linkedin.com/in/ambreenimran

Ambreen Imran

BI Data Analyst – Tableau

3

Developed and maintained issue log where business users enter their feedback by working on dashboard in QA environment. Implemented the feedback and incorporated the necessary changes

Generated dashboards with quick filters, parameters and sets to handle views more efficiently

Published workbooks by creating user filters so that only appropriate teams can view it

Used excel sheet, flat files, CSV files to generate ad-hoc reports

Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers

Created advance connections, join tables, create & manage extract and monitor queries using SQL

Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals

Experience in designing and development of Tableau visualization solutions and creating business requirement documents and plans for creating dashboards with MS SQL Server as backend

Extensive experience in reviewing business requirements and analyzing data sources from Excel/MS SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop

Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using filters and actions

Efficiently solved different escalations / issues / queries directly with customers

Analyze business information to identify process improvements for increasing business efficiency and effectiveness

Participate in cross-functional meetings to resolve recurring customer issues

Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards

REFERENCES

Available upon request.

Contact this candidate