Amutha Prabakaran

*: adzxc0@r.postjobfree.com

(: 970-***-**** Denver, CO

I have 4+ years of experience in Business intelligence, Data Analysis and Visualization, Advanced Analytics, ETL, Data Warehouse development, Support, and Implementation.

PROFILE SUMMARY

Extensive experience using Tableau Server, Tableau Desktop, Tableau Public, and AWS QuickSight.

Strong experience in SQL Server development, System Analysis, Design, Development, and Support of MS SQL Servers.

Have a good understanding of Tableau Architecture, design, and development with experience in designing and deploying data visualizations

Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems.

Extensively involved in Data Extraction, Transformation, and Loading (ETL process) from source to target systems using SQL.

Expertise in designing and developing various dashboards, and reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, TreeMaps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization, and other making use of actions, other local and global filters according to the business/client requirement

Proficient in designing techniques like Snowflake schema, Star schema, fact and dimension tables, and logical and physical modeling.

Involved in publishing various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.

Experienced in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.

Extensive knowledge of various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, calculated fields, etc., in Tableau.

Experience in creating filters, quick filters, data source filters, global filters, context filters, and user filters.

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

Experience in implementing Data blending, Replacing references, Customized queries, and advanced visualizations in Tableau.

Worked on improving dashboard reports by creating KPIs (key performance indicators) for the top administration.

Extensive experience using Tableau functionalities for creating different Requests, Filters, Charts, and Interactive Dashboards with page and dashboard Prompts.

Created a Heat Map showing sales data by color broken into regions allowing business users to understand sales patterns (lowest vs. highest) in various regions.

Created sites to set up user or group permission for projects, views, workbooks, and data sources.

Embedded dashboards into the portal by publishing them into Tableau Server or Tableau Online.

Allowed users to perform schedules for data extracts by configuring the Tableau Server.

Highly motivated, energetic individual and a very good team player willing to work hard to meet intensive schedules and having excellent communication, presentation, and interpersonal skills.

SKILLS AND COMPETENCIES

BI Tools: Tableau Desktop 10.1, 10, 9.2, 7, Tableau Server 10.1, 10, AWS QuickSight, Power BI

Databases: MS SQL Server 2005/2008/2012/2016/2017, MySQL, Oracle, MS Access

Tools: MS Excel, MS Word, MS PowerPoint, DataGrip, Chime, Asana

Additional Skills: JSON, C#, Python

Aws: Amazon Redshift, Amazon S3

EDUCATION

Master’s Degree in Computer Application

PROFESSIONAL EXPERIENCE

Amazon BI Analyst – QuickSight / SQL / Tableau Oct 2022 – Present

Description:

Global Military Population with Diversity, Equity, and Inclusion. Veterans, Military Spouses, and People with Disabilities. Hiring for different Ethnicities, different job levels, and the Sim org leader. Same way the Promotion, and Attrition as well as Military Spouses and People with Disabilities.

Responsibilities:

Communicate client’s business requirements by constructing easy-to-understand data and process models.

Developed detailed specifications based on user stories from product managers and other stakeholders.

Acquired data from multiple sources and prepared data for further analysis.

Import the custom SQL, Excel, and flat files into QuickSight Spices.

Extensively used SQL for accessing and manipulating database systems.

Worked on Data verification and validations to evaluate whether the data generated according to the requirement is appropriate and consistent.

Extracted data from existing data sources and performed ad-hoc queries using SQL.

Measure the metrics based on weekly, monthly, and yearly. Drill up and drill down the date hierarchies.

Expertise in designing and developing dashboards and reports utilizing QuickSight Visualizations like Bar Graphs, Scatter Plots, Pie Charts, Donut Charts, TreeMaps, Funnel Charts, Box Plots, Waterfall Charts, Filled maps, Points Maps, Line charts, Pivot tables, Histogram.

Extensive knowledge of reporting objects like Hierarchies, Calculated fields, Sorting, Parameters, and Filters in QuickSight.

Experienced in detailed document and report preparation and complex internal and external data analysis.

Identify, analyze, and interpret trends or patterns in the large data set.

Created a list of suggested insights and custom insights based on their interpretation of the data in the visuals.

Publish and share the dashboard. Set the Manage permission, review the users and groups, and their roles and settings.

Open Queue BI Analyst - Tableau / SQL Jun 2019 – Sep 2022

Description:

A Retail Analyst is responsible for optimizing business performance and strives to achieve company goals including profit, new products, and sales. Customer analysis is the practice of using qualitative and quantitative data to gain insight into your customers. The goal is to understand their wants, needs, pain points, and objectives. At the same time, customer analysis helps us understand what drives people to make a purchase, how and when these purchases happen, the frequency of these purchases, and other relevant information.

Responsibilities:

Gathered Business Requirements and interacted with the Executive Directors and project managers to understand the business processes better.

Imported data from SQL Server and MS Excel to Tableau to generate reports.

Deep experience with the design and development of Tableau visualization solutions.

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

Involved in extracting, transforming, and loading data directly from different source systems like Excel, Oracle, flat files, and SQL Server.

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

Created external, internal, and context filters to improve performance.

Used Data Blending, groups, combined fields, calculated fields, aggregated fields, and spotlighting to compare and analyze data from different perspectives.

Analyzed and improved SQL query performance

Maintained high standards of data quality and integrity in the database

Developed different components in the dashboard to visually analyze the data.

Used dimension on the Page shelf for detailed analysis of the view by members of the dimension.

Created parameters and quick filter. Created sets to display top N and Bottom N customers based on their sales.

Create a customer segmentation dashboard using advanced techniques by creating a donut chart, funnel chart, and Histogram.

Hierarchy management, drill-ups, and drill-down.

Established a Level of detail calculation to hide the critical data.

Generate a tableau dashboard with a forecast and the reference line.

Created Action in Worksheet, a dashboard for interactivity and comparing against different views.

Published workbooks and dashboards to the Tableau Server.

Combined Visualization into the interactive dashboard and published them to the web.

Created groups and users in Tableau Server.

Tableau Server, Tableau Site Administrators create and manage the site's users and groups, create projects to organize content on the site, and assign permissions to allow users (groups) to access the content.

Contact this candidate