Order Management System is used to track the history of each ORDER. OMS maintains entire life cycle

of each order. Every order progresses from draft order created to order delivered status. Orders are

Classified according to their order types. There are multiple order types like Add-on, Conversion,

Multisite, Resale etc. Summary dashboard lists the number of orders in each status and order type. The

First drill down provides information on how many orders are in an order date for particular status and

Order type. The second drill down provides order progress of orders for selected order date. The third drill

down provides details for selected order.

Responsibilities:

• Recommended visualizations and key metrics to be used,
• Prepared interactive dashboards using calculated fields, parameters, filters and hierarchies,
• Linked dashboards using actions,
• Deployed dashboards in Server,
• Used data blending functionality to combine data from two data sources,
• Involved in writing SQL queries and views,
• Key Metrics used in the project include Year to date, Churn Percentage, Year-on-Year Percentage etc,
• Involved in end-to-end testing of the reports.

Responsibities:

• Recommended visualizations and key metrics to be used,
• Develop interactive dashboards using parameter, filters, hieararchies etc.
• Deployed dashboards in Server.
• Involved in end-to-end testing of the reports

Environment: Tableau Desktop 2018.1, Tableau Server 2018.1, Azure Hive, MS office.

• Involved in requirement analysis,
• Involved in preparation of Business requirements document,
• Worked on preparation of Functional requirements document,
• Recommended visualizations and key metrics to be used,
• Prepared interactive dashboards using calculated fields, parameters, filters and hierarchies,
• Linked dashboards using actions,
• Deployed dashboards in Server,
• Used data blending functionality to combine data from two data sources,
• Involved in writing SQL queries and views,
• Key Metrics used in the project include Year to date, Churn Percentage, Year-on-Year Percentage etc,

Involved in end-to-end testing of the reports.

• Involved in requirement analysis/ GAP Analysis,
• Prepared Business requirements document,
• Prepared Functional specifications document,
• Recommended visualizations and key metrics to be used,
• Designed dashboards according to business needs,
• Prepared interactive dashboards using calculated fields, parameters, filters and hierarchies,
• Linked dashboards using Filter actions and URL actions,
• Involved in writing SQL queries and views,
• Published the dashboards in Tableau Server.
• Assigned tasks to team and fixed the issues team faced.
• Involved in end-to-end testing of the reports,

• Actively involved as part of a team for gathering and analyzing the needs of end user requirements and system specifications.
• Scheduled extract synchronization with database.
• Designed various Data visualizations, charts, dashboards, prototypes and demos, published it in Tableau Server.
• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Involved in generating daily/weekly finance trending reports using Tableau.
• Successfully administered user, user groups, and scheduled instances for reports in Tableau.
• Improved performance by tuning dashboards.
• Worked on various complex SQL queries and views to implement the business logic.
• Worked on Integration testing of the reports.

• Analyzing the user requirements, preparing documents and developing specifications,
• Created mappings, mapplets and workflow design,
• Performance Tuning of the Workflow, Session and Mapping,
• Involved in in Data Extraction from Oracle and flat file data sources to load the extracts

into the target warehouse,

• Involved in unit testing.

Responsibilities:

• Develop various customized charts using calculated fields, parameters and filters etc.
• Involved in defect fixing and finding work-around solutions,
• Deployed dashboards in Server,
• Involved in end-to-end testing of the reports.

Environment: Tableau Desktop 2018.1.4, Tableau Server 2018.1.4, Hive, MS office.