EXPERIENCE SUMMARY:

• 9 years of experience in Business Requirement Analysis, design and development of various BI projects in Technology, Life Science, Media and food/beverage industry as a Data and Reporting Analyst.
• 3+ years of experience in design, building Tableau Visualization and Dashboards for Data Analysis and reporting applications.
• Have good understanding of Tableau architecture, design, development, deployment and end user experience.
• Experience in creating different visualizations using Bars, Lines, Maps, Scatter plots, Histograms, Bullet chart, Heat maps and Highlight tables.
• Build custom chart like Funnel chart, Pareto chart, Donuts chart and Waterfall model.
• Extensively worked in Tableau advanced calculations, LOD expression and Tableau maps.
• Mastered the ability to design and deploy rich Graphic visualizations using Dual axis, Dashboard Action, Drill Down, Quick Filters and Parameters.
• Used Data Blending, Cross Data Base join & Union to combine data from multiple sources.
• Managed user access restriction to the Tableau Dashboard/views on the server.
• Experience in performance tuning and troubleshooting of Tableau Dashboards and Reports.
• Outstanding Data analysis skills including Data mapping from source to target database schema, Data Cleansing and processing, writing data load scripts to load data in presentation layer and researching complex data problems.
• 4 years experience in analysis, modeling, design and development of Business Object Universe and Webi Reports for analytic and ad - hoc reporting applications.
• Extensive knowledge in various reporting objects like Dimension, Measures, Hierarchies, Transformations, filters, calculated fields, Sets, Groups, Parameters etc.
• Strong understanding of Data warehouse, Data Marts concepts, Star Schema, Snowflake Schema, FACT and Dimensions tables, conceptual, logical and physical data modeling.
• Worked on various Key Performance Indicators (Sales, Profit, Order, Inventory, Pricing, Delivery, Forecasting etc.) In Dashboard/ Reports development using Tableau and Business objects.
• Follow Best Practices for Dashboard Design and worked on Performance improvement of the Visualization and Reports.
• Strong Problem solving skills with the ability to determine Business Partner needs and create purpose built solution
• Ability to work both independently and as a Team member.

KEY DOMAIN AND TECHNICAL KNOWLEDGE:

Industry: Technology, Life Science, Media &Entertainment, Food & Beverage

Domain: Business Intelligence and Data Analytics

Tools: and Technology: Tableau Desktop, Tableau Server, SAP Business Object,Teradata SQL Assistant, Data Warehouse, Data Mart, Data Analysis, Data Modelling, Performance and Load Testing

Database: SQL, Teradata, Oracle

Process/Methodologies: SDLC, Agile Model & Waterfall Model

Documentation: Requirement Traceability Metrics, Data Mapping, Design Doc, Report MockupTest Script

Operating System: MAC, Window

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata
• Assist Project Team with ad-hoc analysis, integration support, and testing of the Revenue Management System.
• Prepare the high-level design and provide the Report mock-up.
• Co-ordinate with IT team to convert the Custom SQL to create materialized tables/views and involve in performance improvement of the queries.
• Used LOD & Tableau quick table calculation like Running Total, Window Avg, and Percentage of total, Rank and perform secondary calculation in the dashboard.
• Developed various reports using Tableau features like Parameters, Filters, Groups, Dual Axis, Dashboard Actions, etc. for analysis.
• Built customer wiring hierarchy for drill down operation.
• Created End-to-End test cases; involved in integrated testing and support user acceptance testing.
• Created tableau Data extract and used shared Tableau extract to use across different reports.
• Manage end user restriction and access to the Projects and workbooks on the server.
• Created background images, button, Color/Text formatting and used the same in the Dashboard to get a better look and feel of the dashboards with IOS integration.
• Prepared product demo for end users to help them understand the use of tool and easier way to use.

Tool: Tableau Desktop, Tableau Server, SQL, Teradata, Oracle, Microsoft Excel

Confidential

Responsibilities:

• Partner with internal and external teams; working across multiple functional units including internal system end users, Revenue Management and Technology.
• Understand and analyze the existing visualization and underlying source system
• Build Pricing and Booking dashboard to help the team in Business and Operation dashboard development activity to meet the delivery deadline.
• Created Calculated metrics to convert Number format to represent the KPI in Thousands (K), Millions (M) and Billion (B).
• Created Tableau Data extract and used the shared data extract on server for dashboard reporting.
• Prepared one and two parameters Visualization link and co-ordinate with the UI team to embed the server links with UI portal.
• Used quick table calculation and calculated field for Top/Bottom analysis, Parameter control for User interaction.
• Used Dashboard action to switch among the different reports, Navigation between Summary and detail reporting.

Tool: /Technologies used- Tableau Desktop, Tableau Server, SQL, Microsoft Excel

Confidential

Responsibilities:

• Requirement analysis and creating data mapping documents identifying key data elements and prepared requirement specifications and data flow diagrams.
• Worked in coordination with clients for feasibility study of the project in Tableau and with DB Teams for designing the database as per project requirement.
• Prepared High-level design document and project plan.
• Designed and developed various analytical reports from multiple data sources by blending data in Tableau Desktop.
• Used custom SQL queries to fetch data from the presentation layer to Tableau for reporting.
• Build Tableau dashboard and Stories using Bar, Line, Text Table and Tree Map for FDA Reporting
• Created Heat Map, Tree Map, Highlighted tables to report the Active/In-active Patients, Prescribes & Pharmacies information across territory and states.
• Developed various reports using Tableau features like Parameters, Filters, Sets, Groups, Actions, etc. to present users with various scenarios of predictive analysis
• Prepared FDA Submission document and review with Business team.

Tool: Tableau Desktop, Tableau Server, SQL

Confidential

Responsibilities:

• Analyze the Business Requirement Doc, Creating Requirement gap tracker, and project plan.
• Developed the ER diagrams for reports, which gives the information about the underlying source and their relationship.
• Created data mapping documents identifying key data elements and prepared requirement specifications, data flow diagrams and design doc.
• Review the Data Mapping and Design Doc with Business team and update the documents based on Business feedback and created Dashboard mock-up.
• Modeled the underlying source that used in Tableau visualization and dashboard for Reseller WW Operation team.
• Creating Data base aggregates and installed Autosys jobs for process automation.
• Building the Business Object Universe and Webi Reports.
• Performance analysis of BO reports and database queries.
• Preparing Unit and Integration test scripts and provide supports during User Acceptance Testing.
• Preparing Implementation Plan, backout Plan and involved in Release management activity.
• Provide support after project deployment (Release note, Post Validation and warrant Support etc.)

Tools: /Technologies used- SQL, Teradata, SAP Business Object Universe, SAP BO Webi, Autosys Job