• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.

• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.1 in Dev, QA, UAT and Prod environments.
• Upgraded Tableau 8.1 environment to Tableau 8.2
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development creating and modifying worksheets and data visualization dashboards.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin commands in creating backups and restoring backups of Tableau repository.

Tech Environment: Tableau Desktop 8.2/8.1/8.0 , Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g,IBM DB2, Microsoft Excel 2007, MS Access , Windows 2007 server, java 1.5 platform, Microsoft office 2007 .

• Developed a dashboard to measure critical KPIs including admission rates, patient waiting time, referrals, and patient satisfaction.
• Involved in Exploring, Designing, Building, QCing and Deployment the high level dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics using Tableau 7.0 & 8.0 tool.
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Adhered to good systems agile development methodology.
• Developed, maintained and documented highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Developed universe using Information design tool (IDT)
• Good experience in Tableau Business Intelligence Tool for dashboard development.
• Presented to higher management the discovered trends and analysis, forecast data, recommendations and risks identified.
• Coordinated and conducted business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, and DBA’s and project managers.
• Worked to understand Business requirements, analysis and translated them into Application and operational requirements.
• Translated functional requirements of the reports build into technical specifications document.
• Involved in the complete process cycle; functional skills in analyzing the client requirements: translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.
• Developed and executed test cases and test plans for functional performance of the reports.
• Translated functional requirements of the reports build into technical specifications document.
• Tuned Universes for Report level performance.
• Designed deliverable content to precisely reflect the engagement contract and client needs and strive to improve deliverable quality through verification and validation of results.
• Designed aggregated tables on the most frequently queried data for Daily, Monthly & Yearly based reports.
• Wrote PL/SQL validation queries for cross testing the resulting data from the reports.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
• Created Classes and Objects for management system based on the warehouse schema in Universe.
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Migrated number of reports from Dev /Test to Production environments.
• Created Star Flake Schema and created new universe by using techniques like indexing, derived tables, setting up contexts and creating Loves.
• Revised the Group Structure in both Development and Production Environments.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Created alerts, filters and inserted Breaks in designing reports.
• Design processes to minimize data quality risks and proactively identify potential data issues.

Environment: Tableau 7.0, XI R3.1,QAAWS, Oracle 11g, PLSQL, SQL SERVER 2005,TOAD, UNIX , BI 4.0 Launch Pad, Xcelsius Dashboards

• As a CFS team member, interacted with Functional/End-users to gather requirements for Core reporting system.
• By understanding Exceptional features and User expectations for reporting system, by designed Business Requirement Packages (BRP's) to successfully implement Business logic.
• Worked in Tableau environment to Create dashboards including weekly , monthly , daily reports.
• Utilized Tableau Desktop to publish them to server
• Managed Production, Test and Development environments including installation of patches, security administration and access controls.
• Involved in writing complex business rules for populating dimension tables, fact tables, and Aggregate tables.
• Resolved the loops using Contexts and checked the Integrity of the Universes.
• Exported the Universes to Repository for making it available to users

• Created complex reports like Detail level Transaction reports, monthly Aging, YTD cash goal reports,
• Created Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Created Complex workbook to visualize Wal-Mart & Target sales using scattered plots , bar charts by tableau desktop
• Applied Multi-dimensional analysis such as slice and dice, drill functions at report level.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 6.0
• Identify risks associated with the testing strategy, then document and communicate such risk to stakeholders
• Involved resolving Error's in the reports like context error, Syntax errors, Multivalve Error, Timeout errors,
• Created custom Function's (Date range, Time functions, array functions, and Conditional formatting functions in the reports.

Environment: Rich Client, Info-View Web Intelligence, CCM, CMC, Designer, Crystal Reports XI, Crystal Xcelsius 2008, SQL 2008, Oracle 10g, SAP LOGON GUI 7.10 (FSCM ERP R/3), ECM Live link workspace, Import Wizard, Microsoft Excel 2007, Tableau 6.0

This project is been designed for Pragathi Organics Ltd. Industry, that they want to computerize their operations. In the view of the huge database required for this industry and the security Oracle database has been preferred. This company is involving in production and exports of different chemical products user interaction is provided through main menu comprising display choices to maintain customer order, sales order, purchase order, inventory debt , supplier and production unit. Proposed functionalities for each of the unit and database development based on the information with respect to the organization flow.

Responsibilities:

• Tested and documented the databases created.
• Gained understanding of the business process/requirement and translated them into technical requirements.
• Created Database Objects like Tables, Views, Synonyms and Sequences.
• Extensively used of PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Tested the entire application in testing environment and exported to production.
• Done the documentation and provided on-site production support.

Test Environment: Oracle, SQL, PL/SQL, Windows.