SUMMARY:

• Around 9 years of extensive experience in IT with full System Analysis, Design, Development, Implementation and Maintenance of Business Intelligence Reporting Products.
• Extensive experience in working with Tableau Desktop, Tableau Server, Tableau Online and Tableau Reader in various versions.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experienced working on Data Blending against multiple data sources using common fields.
• Expertise in designing and development of various dashboards and reports utilizing various Tableau Visualizations like Line, Bar, Column, Scatter, Heat Map, Tree Map, Filled Geography Map, Packed Bubble and other custom chart types.
• Added Analytics such as Trend Lines, Reference lines and Forecasts.
• Customized Mark Types and Tooltips for these various visualizations.
• Created Filters on workbooks using fields, custom list of values and Top Ranks.
• Created reusable Parameters to capture user values and also use them in calculated fields.
• Developed Calculated Fields, Table Calculations and Level of Detail Expressions.
• Developed Sets to define sub set of data and used them as filters for focused analysis.
• Created Custom Groups of categorical dimensional data and used in visualizations.
• Added Tooltips to provide additional information for different marks on views.
• Developed highly interactive dashboards using action and highlight filters across visualizations.
• Added annotations in Stories to further explain data points.
• Experienced with publishing and scheduling workbooks to Tableau Server.
• Excellent knowledge of Relational database concepts and possess strong knowledge in SQL.
• Worked with data warehouse teams and business teams as a liaison between them.
• Possess excellent analytical and problem solving skills with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions for business requirements.
• Result oriented, self - motivated, team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS:

BI/ Reporting Tools: Tableau Desktop v 10.3.10.0, 9,8,7,6 Tableau Server v 10.3,10.0 9,8,7,6, HortonWorks Hadoop Hive 32 bit 2.1.2

RDBMS: Oracle 12c, Oracle 11g, 10g, 9i MS SQL Server 2014, 2012, 2008, SQL Server Management Studio 2012, MS Excel - MS Access.

Languages: SQL, PL/SQL, Java, C, C++, HTML.

Other Tools: SAP Business Objects, SSRS, Power BI Desktop, QlikView

Operating Systems: Windows, UNIX/LINUX, AIX, HP UX.

PROFESSIONAL EXPERIENCE:

Confidential, Bartlesville, OK

Sr. Tableau Developer

Responsibilities:

• Built connections to MS SQL Server database and Hortonworks Hadoop Hive to analyze information content for consumption through data providers in Tableau.
• Developed Dashboard by using multiple data sources and custom SQL in tableau data providers.
• Created Project Implementation Status Tracking dashboard. This dashboard contains multiple worksheets in horizontal and vertical containers along with legends and user interactive filters.
• Used Bar charts for Monthly Submittals to show count of forms submitted per division by month.
• Created hierarchal navigation from Divisions Summary chart to Site Codes which further drills down to Detail Dashboard showing detail information on these specific forms using Action Filters.
• Created Area charts for all the Months and Divisions to see On-time Submittal Percentage Trend.
• Developed Sparkline chart to show how the total submittals per division is trending.
• Applied different color coding for division per pane of monthly submittals.
• Created different Pie charts for work type, total forms created and anomaly evaluation.
• Created Parameters so that the user has the option to select different Days and view the data as of 30 days or 60 days or 90 Days submittals.
• By the use and leverage of Level of Detail expressions created multiple conditional calculations.
• Used different Date calculations to find the frequency of how the status of a form performed between Years, Months and Weeks. Views are also filtered from Current Month to Prior 2 Years.
• Used Show/Hide Filters based on All Form selections or only by Compliance Assurance Form Selection.
• Created Reset button filter to clear and reapply all the values of filters at one time and the user also has the option to filter the data with wild characters.
• Using URL action passed values and created independent links to different dashboards. Created one master dashboard where all existing forms have a corresponding worksheet in tableau workbook and are synced to the Master Dashboard.
• Created URL in calculated field and passed that calculation in URL action.
• Used Custom Color Palette, Shapes, Fonts and different Workbook Themes.
• Added custom Tooltips to desired Marks also allowing data selection.
• Published Tableau workbooks to desired Tableau Server Project folders.
• Upgraded tableau workbooks from 10.0 Version to 10.3 version.
• Edited published data sources from live to extracts for better performance.
• Performed use case testing on Tableau Dashboards and demoed them to users.
• Created Refresh Schedules for full refresh and incremental refresh for specific form dashboards.

Environment : Tableau Desktop 10.3, 10.0, Tableau Server, Microsoft SQL Server 2012, SQL Server Management Studio 2012, Hortonworks Hadoop Hive 32bit 2.1.2

Confidential, Rosemont, IL

Sr. Tableau Developer

Responsibilities:

• Extensive experience with design and development of Tableau visualizations. Worked on multiple reporting projects.
• Built connections to desired databases and analyzed database table content information.
• Worked with building Joins on acquired tables where applicable in Data Source Pane.
• Built multiple data sources and blended data on common linked fields when applicable.
• Build Summary and detailed product segment, geography segment and market segment reports displaying various charts and cross tables.
• Developed Scatter Plots to show detail data points across multiple measures.
• Developed Time Series Line charts and applied trend lines and forecast for continuous data.
• Developed Filled Maps to display regional variations.
• Created customized Bins for Histograms and added Reference Line for Average.
• Built report level calculated fields for custom generating calculations.
• Developed combined sets to perform focused analysis on subsets of data.
• Added filters such as quick filters and context filters
• Built views using quick table calculations computing across and down table and pane levels.
• Built Level of Detail calculated fields to include or exclude dimensions from the view.
• Used different workbooks to create interactive aesthetically pleasing dashboards and stories.
• Created Actions in Dashboards for interactivity and to compare data against different views.
• Assisted Users in User Acceptance Testing and presented completed reports.
• Published finalized workbooks to server into desired project folders.
• Worked with Admin Team to identify different groups and users as recipients of built reports.
• Posses the ability to interact professionally with a diverse group, including executives, managers, and LOB personal and act as a liaison between these groups.

Environment : Tableau Desktop 9.3, 9.1, 9.0, 8.1, 8.0, Tableau, Oracle 11g & 12c, MS Access.

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle/SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• 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 Map by color and size by region for subscriber metrics.
• Projected and forecasted future growth in terms of number of subscribers developing Area Chart to show details at the county level.
• Converted charts into Crosstabs for further underlying data analysis in the view.
• Blended data from multiple databases into one report by selecting linked field.
• Reviewed basic SQL queries and edited inner, left, and right joins of tables in data source pane.
• Developed Dashboards and published them to Tableau Server allowing end users to analyze the data on the fly using action filters for on-demand purpose.
• Added analytics to the view and used selected parameter values to adjust the reference line.
• Added Tooltips to provide additional information for different marks on views.
• Created custom groups using related dimensional values to provide custom rollup.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data updated the worksheets.
• Published worksheets and related data sources to server.
• Participated in meetings, reviews, and user group discussions as well as communicated with stakeholders and business groups.

Environment: Tableau Desktop 8.1 & 7, Tableau Server, MS Office Suite, Oracle 11g.

Confidential, St. Louis, MO

Tableau Developer

Responsibilities:

• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary
• Created dashboards for users to measure performance of their services and portfolios.
• Developed different tableau visualizations such as Cross tab, Bar Charts and other charts.
• Developed Area charts and Filled Maps and added Mark types to compare data.
• Created calculated fields using different functions.
• Created Parameters to permit users to alter the measure plotted in a view.
• Used Tooltips to sort, exclude, keep only and view underlying data for selected maps.
• Design, develop and support complex performance reports.
• Provided production support for Enterprise wide Tableau application.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important projects and business stakeholders throughout the project life cycle.

Environment: Tableau Software 7.0, 8.0, Microsoft office, SQL Server 2008.

Confidential, New York, NY

Tableau Developer

Responsibilities:

• Worked on multiple projects building different workbooks. Created and assisted users in Tableau dashboard development.
• Used different Mark types and Mark properties in view to provide better insights into data.
• Created various types of charts for better visualization like Column and Pie charts.
• Created Bar Charts which are complied with data sets, and added trend lines.
• Formatted these visualizations at all levels for font, totals, band size, borders and other properties.
• Added filters and used quick filters for interaction to display data immediately upon user choice.
• Added tool tips to desired visualizations providing more details for each mark.
• Developed dashboards and published to the Tableau Server so that the end users who are having access to the server can view the data.
• Worked with business team to capture requirements.
• Developed technical documentation for each reporting service developed in this project.

Environment: Tableau Server 6, Tableau Desktop 6, MS SQL Server 2008, Oracle 10g, Excel.

Confidential, Chicago, IL

Business Analyst / Business Objects Developer

Responsibilities:

• Was personally involved in meetings with Business Team Managers and colleagues to define and scope list of reports, content desired in these reports, formatting and presentation standards for these reports, Time Line of Development and helped in assessment of Level of Effort with other team members.
• Worked with Data Warehouse team to identify underlying Oracle database related to business requirements.
• Documented UAT Process and worked with the Team to take Sign Offs on reports completed.
• Was involved in Weekly Meetings with Managers to update Status of report development.
• Was proactive in updating all concerned stakeholders with respect to completed and pending tasks.
• Worked with different team member and end user groups to better understand the system and developed usable reporting products and reported in a timely manner.
• For Tables and Sections used variables as filters so as to show data or hide if condition is not met.
• In detailed reports which show holdings applied breaks at Sector Level to show Sub Totals for each Sector.
• Applied Custom Number formatting for selected measures.
• Used Pre-Defined Cells such as Page Numbers, Last Refresh Date and others on specific desired reports.
• Used Documents Structure Map and Element Properties to custom name them so as to relate to which data set each table or chart is referring to. Organized this information which helped in detail documentation of report design and development process.
• Created list of tables and their relationships for dimensional modeling identifying lookup tables and fact tables and scoped inventory of tables needed for creating the universe.
• Updated applicable reports which needed changes with respect to either misaligned data or new display format or additional report level filters or query changes and other related changes and overrode current report to allow users to retest updated reports.

Environment: Oracle 9i, TOAD, Business Objects XIR3 XIR2 Web Intelligence.