PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Designing, Administration, Analysis and Management in Business Intelligence Data warehousing . 5+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0,8.1, 8.2,9.0 as a developer and Administrator .
• Experienced with Performance Tuning and Optimization of the Rendering Time on the Visualizations and Dashboards.
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Experienced in Tableau working with different Enterprise Data sources likes SAP HANA, SSAS Cubes, Hadoop HDFS, Oracle Enterprise Servers and the Extracts ( auto/incremental ).
• Administration, Installation and configuration of a Core Licensed Tableau Server.
• Hands - on experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop .
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, Security Concepts, calculations and Relationships.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from ( Tableau 8.0 to 9.0).
• Extensively worked on tabcmd, tabadmin, creating users, sites and projects in tableau .
• Experience in creating Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Hands-on experience on Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes using Key Performance Indicators KPI's .
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Experience in data extraction, data integration, data modeling and data rendering in Tableau.
• Strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Expertise in analysis, design and implementation of data warehousing applications using Teradata, Informatica UNIX, DB2, and SQL Server technologies.

TECHNICAL SKILLS:

Web Technologies: HTML, CSS, JAVA SCRIPT, XML, HTTP

Data Modeling tools: Star Schema Modeling, Snow Flake Modeling

Programming Languages: C, C++, SQL, PL/SQL, Tableau Desktop, Tableau Server

Databases: MS SQL Server 2005/2008/2008 R2/2012

Visualization Tools: Tableau 9.2/9.0/8.1/8.0

Operating System: Windows

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Sr Tableau Developer

Responsibilities:

• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 9.0.
• Preparing Dashboards using calculations, parameters in Tableau.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Defined best practices for Tableau report development.
• Extensively used data blending, embed functionalities in Tableau.
• Migration of the reports from Cognos 10.1 to Cognos 10.2.1 environments.
• Worked directly with business customers to build reports, dashboards, ad-hoc reports and portals with Cognos 10.2 reporting tools like report studio, query studio and analysis studio
• Created Relational Metadata model using Cognos Framework Manager .
• Creating Public Folders, Private Folders, My pages and custom views in Cognos Connection.

Environment: Tableau 8.0, OBIEE 10.1.3.4.1, Oracle10g/9i, OBI11g, Cognos BI 10.2/10.1

Confidential, Colorado, CO

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 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.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Understood the business requirements document and Data model design document to come up with the Cognos model design.
• Creating reports using Webi (Web Intelligence) and Deski (Desktop Intelligence) using Business Objects XI R2 and R3.
• Develop Ad-hoc Business object reports according to user’s requests.

Environment: Tableau, Tableau server, CrystalReports,, Web Intelligence 4.1/4.0/3.1, MS Excel, SQL Server, HANA DB.

Confidential, Chicago, IL

BI/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 showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Worked closely with 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.
• 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) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• 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.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Environment: MS SQL Server 2005, 2008 SQL BI Suite (SSIS, SSRS), MS Access 2003 & Windows Server 2003, Oracle, MS Visual Studio.

Confidential, Chicago, IL

Tableau Developer/ Admin

Responsibilities:

• Worked in Global Markets repository team and created BI solutions to business users.
• Crated Dashboards/Reports for different investment portfolios.
• Involved in creating dashboards by extracting data from different sources (Data Blending).
• Created interactive dashboard and applied filter, highlight and URL actions to the dashboard.
• Responsible for creating calculated fields, LOD Calculations, bins, sets, geo coding and hierarchies.
• Performed type conversion functions when connected to relational data sources.
• Ability to authoring on Tableau server by changing mark types and adding filters.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitored and maintained incremental refreshes for data sources on Tableau server.
• Configured Cache settings which improved the performance of the reports and Dashboards.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Developed interactive dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Reviewed basic SQL queries and altered for better performance in Tableau Desktop.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop/Server 7.0/8.1, Oracle 10g, MS SQL Server 2008, Windows Server 2012, MS Excel/Access 2007

Confidential

Tableau Developer

Responsibilities:

• Evaluated Global consumer risk reporting data models to design Tableau solutions.
• Worked in BI team to fulfill the needs of regulatory/management/finance/loss mitigation/fraud reporting and 10Q.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Created users using Tableau Admin and assigned privileges to create report/publishing reports to server.
• Enabled the data security filters for the users/groups using AD groups.
• Performed report tuning using extracts, Cache options, removing unused fields.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible for creating /delivering monthly reports to business users.

Environment: Tableau Desktop/Server 7.0, Oracle 10g, SQL, TOAD, Windows 2003.

Confidential

SQL Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created ad-hoc reports for the upper level management using Stored Procedures and MS SQL Server 2005 Reporting Services (SSRS) following the business requirements.
• Created reports by dragging data from cube and wrote mdx scripts.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, VBS.