Anil I.

Anil I.

Tableau Developer with Oracle Sql

Bengaluru , India

Experience: 8 Years

Anil

Bengaluru , India

Tableau Developer with Oracle Sql

8400 USD / Year

  • Immediate: Available

8 Years

Now you can Instantly Chat with Anil!

About Me

  • Overall 8 years of experience in Data Warehousing and Business Intelligence.
  • Involved in Understanding client Requirements, Analysis of Functional specification, Technical specification & Preparation, Review of ...
  • Extensive experience in using various BI tools like Cognos8.x and Tableau 8.0, 8.1, 9.0,10 and SQL
  • Extensively worked in different areas in Tableau which includes Live Reporting, Extracts, and Publishing Workbooks in server, Scheduling, enabling reporting and data level securities.
  • Experience in developing reports with Parameters, Groups, Sets, Calculated fields, LOD.
  • Rich experience in developing reports and dashboards which includes various charts like Donut, Crosstab, Pie- Chart, Global map, Bar Chart,Line Chart,Waterfall Chart, Bubble Chart , Tree Map etc.
  • Experience in showing fields more than 60 Dimensions other than measures.
  • Experience in showing KPI’s like different shapes for points.
  • Experienced in showing top N highest values and top N lowest values in same sheet using parameter selection.
  • Experience in YTD,MTD and YOY,MOY calculations.
  • Experienced in tuning report level performance.
  • Experience in implementation of Data Blending.
  • Experience in Filters (Extract,Data Source, Report, Column, Context, User and Actions).
  • Experience in Dual Axis and showing the graph in New Visualization.
  • Good Experience in building, publishing reports and dashboards and scheduling with specific time to refresh the Extracts.
  • Experience in creating Usage Tracker Tableau Server Reports.
  • Experience in creating Projects, adding Users , Scheduling in tableau server.
  • Experience in Alerts and Subscriptions in tableau server.
  • Experience in user filter, providing dashboard and report access to specific users.
  • Experience in Tableau Server Installation, created projects, users, group, scheduler.
  • Experienced in performing various database activities which includes connecting to SQL  and writing Custom SQL while building the reports.
  • Good experience in connecting to SQl and joining multiple tables and cross joins.
  • Good experience in creating Unit Test Cases to compare SQL data and tableau reports.
  • Has involved as mentor and trained colleagues in Tableau within the organization.
  • Excellent overall software Development life cycle (SDLC) experience which includes Agile methodologies, Conceptual and Logical Thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.

Quick learner and adaptive to new and challenging technological environments

Show More

Portfolio Projects

Description

  • Understanding the business requirements and designed reports to meet client needs..
  • Exclusively worked on development of reports like List Report, Crosstab Reports, and Chart Reports. Created headers & footers for the reports.
  • Created various types of reports like master detailed reports. Created List, Chart and Crosstab Reports.
  • Developed reports with conditional formatting to highlight the data.
  • Developed some Complex Reports using calculated fields in Report studio.
  • Conditionally display list or Cross tab based on prompt.
  • Sort a report based on columns.
  • Developed drill through reports to link two reports containing related information.

Show More Show Less

Description

  • Understanding the business requirements and designed reports to meet client needs Developed dashboard reports.
  • Exclusively worked on development of reports like List Report, Cross tab Reports,and Chart Reports.
  • Created various types of reports like master detailed reports.
  • Developed reports with conditional formatting to highlight the data.
  • Developed reports by using conditional blocks.
  • Developed some Complex Reports using calculated fields in Report studio.
  • Conditionally display list or Cross tab based on prompt .
  • Developed drill through reports to link two reports containing related information.

Show More Show Less

Description

  • Conditionally display list or Cross tab based on prompt .
  • Created Dashboards using different components of Cognos .
  • Created various types of reports like master detailed reports.
  • Written SQL queries to build the reports.
  • Exclusively worked on development of reports like List Report, Crosstab Reports, and Chart Reports. Created headers & footers for the reports.
  • Developed drill through reports to link two reports containing related information.
  • Developed reports with various filters.
  • Developed reports using Formatting.

Show More Show Less

Description

  • Work closely and build relationships with team members and client.
  • Developed reports with various Parameters.
  • Developed reports based on Groups and Sets.
  • Worked on Quick Filter, Action Filter.
  • Dealt with over 100 million Data and done performance Tuning.
  • Build Dashboards by Live-connect and Extract
  • Experience with creating Worksheets And Dashboard
  • Working with Data Connections.
  • Experience in taking extracts and building the reports.
  • Worked on Calculated Fields, Context Filters, Hierarchy.
  • Resolved the performance issues of the Reports
  • Shows Bar chart with Target Lines.
  • Experience in Row Level Security.
  • Experience with Publishing and Scheduling the Dashboards.
  • Written complex SQL queries to build the Dashboards.
  • Involved in creating Test Case Scenarios.

Show More Show Less

Description

  • Built complex reports connected live to Oracle ERP DB.
  • Built reports related to backlogs, Cancelled Orders, Channel revenue, Invoice by Item etc.
  • Installed Tableau server to host these reports.
  • Experience with Multiple data Connections to develop the report.
  • Involved to implement custom calculations and Sets.
  • Developed reports with various Parameters.
  • Experience in Dual Axis and showing the graph in New Visualization.
  • Experienced in showing top 10 highest values and top 10 lowest values in same sheet.

Show More Show Less

Description

  • Built complex financial reports with eight data sources and worked with blending which were based on data from various data sources.
  • Experienced in performing various database activities which includes writing SQL queries, Custom SQL while building the reports.
  • Experience in Table Calculations and Filters (Data Source, Report, Column, Context, User and Actions).
  • Experience in Dual Axis and showing the graph in New Visualization.
  • Good Experience in Building, publishing reports and dashboards and scheduling with specific time to refresh the Extracts.
  • Experienced in showing top 10 highest values and top 10 lowest values in same sheet.
  • Experience in creating LOD Expressions.
  • Experience in developing reports with Parameters, Groups, Sets, Calculated fields
  • Has involved in Quality Management activities by creating project related documents.
  • Has involved as mentor and trained colleagues in Tableau within the organization.

Show More Show Less

Description

  • Good experience in connecting to SharePoint site through OData and build reports.
  • Directly involved with client and understand the requirements to build the tableau reports
  • Experience with creation of projects, users, groups and the appropriate permission sets for Tableau server logons and security checks.
  • Experience in Filters (Data source, Report, Column, Context, User and Actions).
  • Experience in YTD,MTD and YOY,MOY calculations.
  • Experience in creating LOD Expressions.
  • Good Experience in Building, publishing reports and dashboards and scheduling with specific time to refresh the Extracts.
  • Experience in creating dashboards using calculated fields, parameters, groups, sets, table calculations and hierarchies.
  • Experience in Dual Axis and showing the graph in New Visualization.
  • Good experience in agile methodology process.
  • Has involved as mentor and trained colleagues in Tableau within the organization.

Show More Show Less

Description

  • Good experience in connecting to SharePoint site through OData and build reports.
  • Directly involved with client and understand the requirements to build the tableau reports
  • Experience with creation of projects, users, groups and the appropriate permission sets for Tableau server logons and security checks.
  • Experience in Filters (Data source, Report, Column, Context, User and Actions).
  • Experience in YTD,MTD and YOY,MOY calculations.
  • Experience in creating LOD Expressions.
  • Good Experience in Building, publishing reports and dashboards and scheduling with specific time to refresh the Extracts.
  • Experience in creating dashboards using calculated fields, parameters, groups, sets, table calculations and hierarchies.
  • Experience in Dual Axis and showing the graph in New Visualization.
  • Good experience in agile methodology process.
  • Has involved as mentor and trained colleagues in Tableau within the organization.

Show More Show Less