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

Asserts & Liabilities Management System

Company

Asserts & Liabilities Management System

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

Digital Energy- Meters Phase II.

Company

Digital Energy- Meters Phase II.

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

Mattel Toy Sales reporting

Company

Mattel Toy Sales reporting

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

Harvesting Install Base

Company

Harvesting Install Base

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

Real Time Order Management POC

Company

Real Time Order Management POC

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

VeriFone

Company

VeriFone

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

Investment Management Data Quality

Company

Investment Management Data Quality

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

Skills

Oracle Tableau

Compliance Control Accounts(CCA) and Production Validation Accounts(PVA)

Company

Compliance Control Accounts(CCA) and Production Validation Accounts(PVA)

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