SUMMARY:

• Over 7+ years of work experience on Business Intelligence tools in the Information Technology Industry in designing and developing TABLEAU Visualizations.
• Experience in Tableau 10.5/10.4/10.3/10.2/10.1/10.0/9.3/9.2/9.1/8.0/7.0 as a BI Developer, Analyst and Admin
• Well versed in using Sharepoint to retrieve, change, and insert items in a list, files in a document library list,
• Automated business processes using sequential workflow for auto archiving documents to another site collection, synchronous
• Introduced Tableau to Client's to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End - user and help them make effective business decisions.
• Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend line calculated measures.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Bubbles, Tree maps and Highlight tables.
• Extensive knowledge in using Filters, calculated fields and Parameters.
• Make visualizations perform as well as possible by using the Data Engine, Extracts and using connection methods correctly.
• Created conditional filters and Actions links to filter the data on dashboard.
• Handle changes in the data source such as field addition, deletion or name changes.
• Publishing sheets and dashboards on server Using Tableau Desktop and tableau public
• Participate in weekly review meetings with the Technical Program Manager to discuss project Status, reports design and/or requirements.
• Combined multiple data sources using data blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-down menu option and Parameterized views using Tableau.
• Strong working experience of Oracle 10G/11G/12c as Developer.
• Hands on Experienced in Database programming using Oracle PL/SQL.
• Involved in writing PL/SQL Stored Procedures, Functions, Cursors, Triggers and Package.
• Written complex SQL (Sub queries and Join conditions), in PL/SQL
• Troubleshoot and debug system and/or data errors.
• Proficient knowledge in performance tuning and knowledge to work according to the Work Request and Change Request.
• Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications, creating dashboards, designing Universes, Full Client/Web reports etc.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Used efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Created automated scripts for tableau workbook refresh when not using live connections
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Ability to understand the business requirements and Data models.
• Automated SQL*LOADER to load data from flat files.
• Vast Experience in Oracle advance SQL Programming Using Analytical functions, Sub Queries, indexes and Set Operators.
• Proficient in creation, modification and effectively use of database objects like Tables, Constraint, Sequences, Indexes, Group Functions, and Views.
• Experience and Excellent Exposure in Query tuning using Materialized Views & Indexes.
• Expertise in getting the data from different data source such as flat files, Excel, Microsoft SQL server, oracle SQL.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Responsible for verifying business requirements, ETL Analysis, ETL develop and design of the flow and the logic for the Data warehouse using Informatics.
• Understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modelling experience using Normalization, Business Process Analysis, Dimensional Data modelling, FACT and dimensions tables, physical and logical data modelling.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.

TECHNICAL SKILLS:

Technical Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++.

Business Intelligence tools: Excel, Oracle, SQL, Tableau Desktop, Tableau Server

Reporting Tools: Tableau, OBIEE Tableau desktop 7.x/8.x/9.x/10.x, Tableau Server, Tableau online, Tableau reader ETL Tools Informatics, Share point, SSIS, SSRS, SSAS. Databases MS SQL Server, Oracle 10g,11g,Teradata

Programming Languages: SQL, TSQL, PL/SQL Scripting Languages HTML5, CSS5, JavaScript

Operating Systems: Windows XP/7/8/10, Unix, Windows 7/8 / XP / Database

Methodology: Agile, Waterfall, Scrum

PROFESSIONAL EXPERIENCE:

Tableau Developer

Confidential - Pittsburgh, PA

Responsibilities:

• Interacted with business users to gather requirements and created several dashboards.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau Desktop & publish them to server.
• Responsible for creating dashboards and overall creation of data visualizations.
• Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc)
• Converting business requirements into dashboard views and designs.
• Created Dashboards and Storyboards in Tableau 10, 9.0, and validated the loads.
• Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Performed optimization on the existing reports to decrease the run time to meet the real time requirements and made changes to the existing reports for good look and feel for the users.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage.
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis.
• Responsible for verifying business requirements, ETL Analysis, ETL develop and design of the flow and the logic for the Data warehouse using Informatics.
• Created users in TABLEAU server and assigned permissions, create extract refreshes, schedule refreshes, create groups and projects, monitoring site activity optionally adding users, giving permission only particular user read and write or only read and other content related tasks, permissions required for the tableau server administrator page are based on site roles.
• Understanding the concepts of refreshing, migrations and scheduling, taking back ups and restoration of tableau repository.
• Managing users, groups and integration with active directory.
• Capable of doing Tableau Server Management (clustering, load balancing, user management etc).
• Used ETL tool to transform, load and extract the data into data w arehouse and to create business intelligence reporting.
• Created sites, lists, libraries, imported several spreadsheets to sharepoint lists,
• Specified system requirements and designed solutions,
• Worked with clients to help them get the most out of sharepoint in performing their job duties,

Environment: Tableau Desktop, Tableau 2018, Oracle 11g, MS. Word, MS. Excel, SharePoint, PowerPoint.

Tableau Developer

Confidential - Norfolk, VA

Responsibilities:

• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build the dashboards to satisfy the business needs.
• Understand Requirements, Analyzing Systems and Source Databases.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Combine data sources by joining multiple tables and using data blending.
• Used Data blending, groups, combine fields, calculated fields, and aggregate fields to compare and analyze data in different perspectives.
• Created parameters, Quick Filters, Action filters, Calculated & combined sets to compare data against different views.
• Worked in Tableau environment to build customized and interactive reports, dashboards to view weekly, Monthly, Daily reports using Tableau Desktop and publish to server with report scheduling.
• Test mapping to assure data is loaded as per ETL specifications.
• Implement dynamic Tableau visualizations with the help of Tableau KPI's.
• Used performance record of workbook and various techniques to optimize & analyze dashboard performance.

Environment: Tableau 9, 10, Microsoft SQL Server, MySQL.

Tableau Developer

Confidential - Linthicum, MD

Responsibilities:

• Involved in reviewing business requirements and analyzing data from different data sources for design, development, testing, and production
• Rollover of reporting and analysis projects within Tableau Desktop.
• Converting SSRS reports to Tableau Dashboards, to show users the efficiency and performance optimization compared to SSRS reports as POC.
• Converted 75 Crystal and SSRS reports to Tableau dashboard connecting to different databases such as Teradata and Sql server Hive.
• Worked closely with Java UI team to integrate Tableau reports to company web portal.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Written complex Hive and SQL queries for data analysis to meet business requirements.
• Working experience on designing and implementing complete end-to-end Hadoop Cycle integrating to tableau and writing complex calculations.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in Tableau.
• Implemented best practices in all the dashboards using extracts, context filters and fixed time-consuming reports using performance recording feature.
• Conducted Training sessions for Tableau Power users and created the documents for end-user support.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created Adhoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports. Used Excel, flat files, CSV files to create Tableau Adhoc reports.
• Worked on creating multiple data connections and created run book designs.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups
• Involved in migration activities related to Tableau across the environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.

Environment: Tableau Desktop 9.0 & 9.3, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Tableau Developer

Confidential - Durham, NC

Responsibilities:

• Created Tableau worksheet and dashboards which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances of data refresh activity to be consumed by Tableau reports.
• Built complex formulas (using "calculated-field" feature) in Tableau for various business calculations.
• Provided resolution to performance problems of dashboards deployed on tableau server using out of the box performance analyzer tool of tableau desktop and tableau server.
• Created and assisted users in Tableau dashboard development.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple functional business s units responsible for operations and strategic decision making.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

SQL Developer

Confidential

Responsibilities:

• Worked as developer responsible for the design and development of data warehouse tables.
• Performed SQL reporting with the ability to create SQL views and wrote SQL queries.
• Efficient in all phases of the software development lifecycle (SDLC), coherent with Data Cleansing, Data Conversion, Performance Tuning and Unit Testing.
• Experience in analyzing Star Schema/Snowflake Schema, Dimensional Data Modeling, Logical and Physical Data Modeling using Toad Data Modeler, SQL Developer.
• Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Worked with Business Analyst and Reporting and Information Delivery Architect to design solutions that simultaneously meet both functional and architectural requirements.
• Developed Calculated Measures and assigning these Aggregation levels based on Dimension Hierarchies.
• Framing the business logic plus code for accessing data stores.
• Develop validation routines for complex business rules and data handling.
• Worked with various functional experts to implement their functional knowledge into working Procedures.
• Troubleshoot performance issues and bugs within packages.

Environment: MS-Office Tools, SQL, PL/SQL, UNIX, Shell Scripting, Manual Testing, Test Director, DB2, and Oracle