SUMMARY:

• Certified Tableau professional with 8+ years of IT Experience in Business Analysis, Data Warehousing, Data Mining, Data Analysis focusing on Design, Development, Implementation and Testing of Business Intelligence and Data Analytics applications. Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
• Extensive experience in Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 7, Tableau 8, Tableau 9 Tableau 10.3 and SQL, PL SQL and UNIX shell scripting.
• Experience in the Development, Implementation of Database/Data Warehousing Environment, BI Analytics and Dashboards applications using Data Profiling, Data Extraction, Data Transformation, Data Loading, Data Visualization using Tableau, and Informatica.
• Expertise in the design and development of Tableau visualization and dashboard solutions using Tableau Desktop and publishing the same on Tableau Server/ Public/ Reader and external websites.
• Experience transforming complex business requirements into rich data visualizations using Tableau.
• Worked to a great extent with the design and development of BI reports / dashboards using Tableau visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Pareto Charts, Gantt Charts, Geographic Visualization and other making use of Actions, other local and Global filters according to the business/client requirement.
• Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folders, Hierarchies, Extract Filters, Table Calculations, calculated fields, LOD, Sets, Groups, Parameters, forecasting, blending and Trend Lines.
• Extensive experience with SQL Development - Querying data, creating tables, creating views, stored procedures, Triggers etc.
• Extensive knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, scheduling tasks.
• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and Expert in modeling Transactional Databases and Data Warehouse.
• Excellent understanding of ETL process, Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases and client/server applications.
• Worked with different data sources like Teradata, Oracle, SQL Server, XML, PeopleSoft, Excel and flat files, Big Data, DB2 etc.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports
• Experience in Installation, Configuration, and administration of Tableau Server in a multi-server and multi-tier environment.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Used Tableau’s flexibility to build a tabbed application with a wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like Finance, Retail etc.
• Created Index page and applied Actions in order to go back to the required Dashboards/Sheets.
• Created Show/Hide reporting concept and also displayed No Data Available using Floating.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server. Been part in writing technical requirement documents and low level design documents.
• Worked in Agile Development Methodology environment and good understanding of backlogs, sprints, ceremonies, burn down charts etc.
• Dedicated work with resilient mentality and desire to improve my knowledge and enhance my skills through continuous learning
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

Visualization Tools: Tableau Desktop 10.5/9.0/8.3, Tableau Server 10.5/9.3/8.3/8.2/7, Tableau Reader, Qlik Sense, Power Bi

OLAP Tools: Hyperion Essbase 11.x/9.x, Hyperion Planning, Excel Add-In, Smart View

ETL: Informatica Power Center 9.6, Data Stage 7.5, ODI Tools: SQL Developer, TOAD, Pl/SQL Developer Tidal Enterprise Edition and MS Visio, MS Excel

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Teradata and IBM DB2.

Languages: SQL, HTML, C, C++, Unix Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Washington, D.C

Sr. Tableau Consultant

Environment: Windows 7/XP/2000/2003/NT 4.0/Vista, UNIX, Sun Solaris, Linux, and MS-DOS.

Responsibilities:

• Created reports to users in Tableau by connecting to various data sources (MS SQL Server, Oracle, MS Excel, Netezza, .CSV).Analyzing the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developing predictive statistical models using statistical analysis and other predictive Data Modeling techniques.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations
• Develop views in Tableau that pull in query failures and give context and allow for analysis, that the reviewers can use to indicate oddities in the data as identified by secondary queries developed by ORS staff members.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields, to compare and analyze data in different perspectives.
• Generated ad-hoc Tableau reports based on user requirements.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Combined multiple data sources by joining tables and using Data Blending.
• Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports.
• Worked on groups, sets, different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created dashboards with the security using filters for the clients to measure cost saving.
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Developed tableau dashboards with combination charts for clear understanding.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Generated context filters and used performance actions while handling the huge volume of data.
• Handled Scheduling of data refresh on Tableau Server for weekly and monthly increments based on a business change to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Involved and support ETL team to replicated data from SAP or Non-sap source systems to HANA Database using Informatica.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau Desktop (9.x/10.x), Tableau Server (9.x/10.x), Informatica, Flat files, Oracle, Hana, SQL*Plus, TOAD, Windows 2003/ XP, UNIX, BMC.

Confidential, Jersey City, NJ

Sr. Tableau Developer/Admin

Responsibilities: -

• Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
• Basic understanding of financial instruments, accounting concepts, Hedge Fund Industry.
• Responsible to Create Dashboards for compliance reports, treasury reports, Daily P&L reports for Client and internal management using Tableau Desktop and Server.
• Prepare financial statements for all funds on the monthly, quarterly, and yearly basis.
• Involved in migration reports from various reporting tools like Spot fire, QlikView, and OBIEE to Tableau.
• Involved in migration reports from Oracle BI Publisher to Tableau. And involved in Data extraction and transformation to Oracle BI to Tableau.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in Informatica.
• Created Data Definitions and help maintain Metadata repository.
• Implemented Installation of Tableau Desktop 9.0/8.3 and Tableau Server.
• Used Trend Lines, Reference Lines and Annotations to describe the data. Created Data extracts for better performance and accessing data offline.
• Involved in license management SLA's with Tableau support.
• Manage the application’s users, groups, and integration with Active Directory
• Involved in reviewing business requirements and analyzing data sources from Excel/MySQL, Redshift for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Experience in taking back ups and restoration of Tableau repository
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created complex calculation using Table Calculation, Date, Aggregate functions in Tableau.
• Providing support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Assisting QA team in creating Test Cases, Test Scenarios and working closely with QA team in managing all the reported defects.
• Working closely with the Business teams in organizing Training for UAT Sessions and assisting business teams to write use cases throughout UAT Phase.
• Assist managers in meeting client expectation by monitoring timely delivery of daily, weekly and monthly deliverables.
• Publishing Reports, workbooks & data source to the server and export the reports in different Formats.
• Effective oral and written communication. Ability to engage meetings/calls with clients/counter parts in other groups.

Environment: Tableau Desktop 9.0/8.3 Tableau server, SQL developer, Data Stage, Toad, Windows 2003.

Confidential, Lawrenceville, GA

Sr. Tableau Consultant

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed various reports, dashboards, scorecards in Micro Strategy and created the same using Tableau desktop server.
• 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.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant
• Utilized the advanced features of Tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended.
• Involved in Buildingand publishing customized interactive reports and dashboards, and also experience in the schedulingof reports using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked on performance tuning of the dashboard in Tableau desktop
• Effectively used data blending, quick filters, actions, hierarchies features in the Tableau.
• Creating Tableau scorecards, Heat maps using show me functionality.
• Executed and tested required queries and reports before publishing.
• Converted Metric insight reports to tableau reports.
• Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards.
• Scheduled frequency and time to refresh data for the data sources publish or extracted to the server.
• Setting the user permissions in Tableau Server.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Deep experience with the design and development of Tableau visualization solutions
• Provided 24/7 production support for Tableau users.

Environment: Tableau 7/8.2 Desktop, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.

Confidential, Westborough, MA

Sr. Tableau Consultant

Responsibilities:

• Gather and analyze the business requirements and then translate them into technical specifications.
• Created different views in the workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE. This is done to improve Report performance.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter, and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps,
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Worked on Tabcmd to schedule the reports and setup email reports using command lines.
• Created Business requirement documents and plans for creating dashboards.
• Worked on migration reports from OBIEE to Tableau.
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau 6/7.0 Desktop, Tableau server, Oracle 11i, Data Stage 7.5, SQL Server, TOADWindows 2003/XP, UNIX.

Confidential, CT

BI Developer

Responsibilities:

• Exclusively involved in the design and developing Hyperion planning 11.1.1.3 and Essbase.
• Involved in creating currency and non-currency applications in Hyperion Planning based on the user requirements.
• Involved in design and developing Web based data forms to facilitate data entry within the Hyperion planning.
• Designed and developed the web based data forms to facilitate the data entry with in Hyperion planning.
• Involved in Assigning secured access to Essbase, Planning, Reporting, and Analysis in shared services.
• Responsible for Metadata changes and updates in Outline and Planning.
• Involved in creating metadata file (. ads) in order to load the metadata to dimensions under dimension library.
• Involved in developing Business rules, currency conversion scripts and assign them to data forms based on the requirement.
• Involved in developing static and dynamic user reports on Essbase cubes using financial reporting (FR) and publish them in Hyperion Planning.
• Involved in develop and schedule reports using the batch scheduler.
• Involved in exporting data based on UDA groups and Attribute dimension members.
• Involved in developing dashboards with multiple frames using Interactive reporting (IR) on a relational database and publish them in Hyperion Planning.
• Responsible for Monitoring error email, Batch jobs scheduling, enabling and running them in the production support environment
• Involved in Optimization and Performance Tuning of Outline/Data Loads/Calc Scripts.
• Exposed on resolving Production Issues.

Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase11.1.1.3, Tableau 7.0, Excel Add-In, Hyperion Interactive Reporting (IR), Smart View, Oracle 10g, MS Windows 2003 Server.

Confidential

SQL Server Developer

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows server 2003 server.
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Support and maintained database clustering.
• Configuring, tuning and optimizing SQL Server 2000.
• Involved in the implementation of snapshot replication.
• Administer tasks like managing users, roles and permissions.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS packages for data import/export, scrubbing and scheduling jobs for backups.
• Creating database maintenance plan for performance of SQL Server, which covers database integrity checks, update database statistics and re-indexing
• Maintained high availability of database using Database Mirroring and Log Shipping.
• Job monitoring and make sure all jobs running successfully at night.
• Performed level scripting, fixing of codes and software enhancement process.
• Worked with linked servers and distributed transactions.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Involved in cubes using SQL Server Analysis Services.

Environment: Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005, SSRS.