SUMMARY

• Over 4 plus years of experience in analysis, design, administration, development, integration and maintenance of Data Warehouse, Business Intelligence and Database platforms.
• Extensive experience with design and development of Tableau Analytics.
• Experience on Business Intelligence platforms and processes across Banking, Insurance and Financial industries.
• 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 with Tableau Desktop objects to include Measures, Dimensions, Folders, Hierarchies, Extract, Filters, Table Calculations, Calculated Fields, Sets, Groups, Parameters, Forecasting, Blending and Trend Lines.
• Developed multiple reports/dashboards using Dual Axes charts, Geo - Maps, Histograms, filled map, bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar and Custom charts like Waterfall, Spider, Donut etc., to visualize the data
• Experience with Level of Detail Expressions (LOD) for complex calculations, and advanced grouping to implement semi additive measures.
• Familiarity with other traditional reporting tools like Power BI, MSTR, Spotfire is a plus.
• Tableau Server Concepts include Tabcmd, Tabadmin, creating/ adding users, sites and projects, managing licenses and data connections, and scheduling tasks.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and Implementation.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000, Windows XP

Databases: Oracle 10g/9i/8i, MS Access, MS SQL Server 2000, Hortonworks HIVE, BOX

DB Modelling: Alteryx, Informatica, Snaplogic

Reporting Tools: Tableau, Power BI, SSRS, DOMO

Methodologies: Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE

Confidential, New York

Tableau Consultant

Responsibilities:

• Create/manage Projects, Database Views, Data Sources and Data Connections in Tableau Server
• Efficiently manage time for timely project deadlines as well as ad hoc requests
• Writing PowerShell Scripts in Tabcmd and scheduling them to automate various Tableau Server requests
• Lead meetings with technical peers regarding the solution designs.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Build, customize and publish interactive reports, visualizations and dashboards using Tableau Desktop.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
• Scheduled extract refresh for weekly and monthly reports.
• Working with Snaplogic Pipelines to integrate the REST API with Oracle DB

Environment: Tableau 10.5, Tableau Server 2018.x, Oracle 11g, JIRA, BOX, PowerShell, Snaplogic

Confidential, Clinton, New Jersey

Tableau Consultant

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, and Gantt charts using show me functionality.
• Built complex formulas in Tableau for various business calculations.
• Worked extensively with advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics, and log axes, groups, hierarchies, sets to create detailed level summary reports, and dashboards using Tableau Desktop
• Leveraged advanced features of Tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Maps showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau8.1 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau 10.5, 2018.x (Desktop), Tableau Server 2018.x, Oracle 11i, Toad, MS Excel, Agile Central, HP ALM tool

Confidential, St Louis, MO

Tableau Developer

Responsibilities:

• Defined best practices for Tableau report development.
• Implemented Tableau BI Dashboard reporting solution for various groups in the organization.
• Published dashboards onto Tableau Server and from there consumers could choose viewing medium (laptop, pc, IPad).
• Created calculated fields using Tableau for implementation of color coding and proper aggregations for data coming from SAP BW.
• Created extensive joins for data blending from several different data sources.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, and Gantt charts using show me functionality.
• Built complex formulas in Tableau for various business calculations.
• Worked extensively with advance analysis actions, calculations, parameters, background images, maps, trend lines, statistics, and log axes, groups, hierarchies, sets to create detailed level summary reports, and dashboards using Tableau Desktop.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Created Tableau Dashboards for different devices like Desktop, Tablet and Mobile phone.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Introduced several levels of dashboard drill down and links to interrelated performance metrics
• Administered and provided production support for enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked with business analysts, interpreted business requirements, and created server-based Tableau dashboards with automatic updates.
• Leveraged advanced features of Tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• Created several dashboards with various chart types such as stacked bar charts, scatter plots, heat maps, and text tables that demonstrated insightful trends over a period of time.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Created electronic spread sheets.
• Performed Tableau Server administration activities including Site and Project creations, adding users and providing permissions to workbooks.

Environment: Tableau 9.x/8.x (Desktop/Server), Oracle 11i, Toad, SSAS, JavaScript, Business Objects, SAP BW, Wins

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Mentored business power users to create reports and dashboards using Tableau Desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• 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.
• Involved in new KPI generation for Scorecards.
• Data collection and leveraging on data manipulation teams for required data.
• 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.
• Developed the first dashboard for tracking quality assurance and data management of external and internal lab, vendor, and claims files
• Converted metric insight reports to tableau reports.
• Working extensively using Excel to validate the data and use as the source data files.
• Analyzing the data using Statistical features in Tableau to develop trend analysis.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones,

Environment: Tableau (Desktop, Server), Teradata, Teradata SQL Assistant, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint).