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 Technical Specification. Extensive expe...
Show MoreSkills
Positions
Portfolio Projects
Description
CCA are created to test technical point of sales functionality and the accuracy of the system delivery of disclosure information of POS. PVA are created in Synchrony Financial system production environments to facilitate testing of functionalities that cannot be tested in the test environment. There are strict guidelines surrounding usage of production validation accounts., no transactions are allowed that will impact: Credit Bureau, Client Settlement/Reporting , Regulatory reporting.
Show More Show LessDescription
Harvesting Install base is service after sales business in GE Oil & Gas. It is a valves and parts business for machinery which used in Drilling purpose to get Oil and Gas. Scope of this project is to analyze the Aftermarkets data and loading data from New Markets to Aftermarkets and build Tableau Reports for Analysis.
Show More Show LessDescription
FFA Private Bank is the only independent private bank in Dubai. They have several branches in Dubai. FFA Private Bank has the ability to assist businesses, institutions and individuals at different levels. They have different operating systems. From this operating system they will collect funds from customers. Bank also provides funds to customer in the form of loans. All these transactions they stored in data base. The data warehousing project for this organization involved source data from different departments like finance, sales and marketing. Currently we have been involved in this project, with consolidating the companys data from different operational sources, data marts and then transforming and loading it in to a centralized data warehouse for various strategic business reports.
Show More Show LessDescription
- 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.
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.
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.
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.
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.
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.
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.
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.