SUMMARY

• Over 9+ years of experience in IT industry as BI Administrator with Tableau and strong skills in Databases and Data warehousing concepts.
• Expertise in Tableau 10.0/9.2/9.1/8.0 , Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online and Tableau Public.
• Worked on different Tableau versions (Tableau 10.0/9.2/9.1/8.0 /7.0)
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.
• 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.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Develop Tableau reports that provide clear visualizations of various industry - specific KPIs.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Extensively worked on setting up of Sites, Projects, groups, Users, Schedule refreshes & subscriptions
• Configured the SMTP setup for the subscriptions and alerts to get emails accordingly
• Monitored the disk usage accordingly to maintain optimum free space for other activities to run smoothly
• Setup Active directory authentication and local authentication for various users and maintained various security profiles accordingly.
• Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side
• Used Kerberos for user authentication thru Active directory (Win AD).
• Migrated Tableau Server to AWS cloud and viewed from the framework of a traditional infrastructure,
• Deployment of Tableau Mobile with Air Watch(IOS) and customized Tableau Mobile for the organization
• Enable Snapshot security for mobile work with IOS
• Tracked Tableau Server Performance for Alerts, Monitoring, Tuning and Troubleshooting
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Worked heavily usingTabadmin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Event based control on workbooks and export visualizations using API
• Automated several scheduling jobs, migration jobs and server activities using automation scripts by using Tabcmd script.
• Used TabMigrate to make it possible to do repeatable bulk migrations and maintain security.
• Createdautomated scripts for tableau workbook refreshwhen not using live connections.

TECHNICAL SKILLS

Data Visualization/ Reporting Tools: Tableau Desktop 7/8.1/9/10, Tableau Public 8.x/9.x,10.x Tableau Reader 8.x/9.x,10.x Tableau Server 8.x/9.x/10.x

RDMS/ DBMS: MS-SQL Server 2014/2012/2008 R2/2008/2005, Oracle 8i/9i/10g, MS Access.

BI Tools: Cognos 11.x, 10.x, 9.x, 8.x Cognos Business Intelligence (8.1 to 8.4) (Report Studio, Query Studio, Analysis Studio and Metrics Studio. SSIS, SSRS, BIDS.

Modeling Tools: Cognos Cube Designer, Cognos Transformer & Cognos Framework Manger. MS Visio 2007/2010/2013

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005, Oracle 9i/10g, OLTP, OLAP, SQL Query Analyzer.

Programming Languages: Confidential -SQL, PL/SQL, MDX, XML, ASP .NET

Web Technologies: HTML, XML, CSS

Operating Systems: Windows Server 2003/2008/XP and Unix/Linux.

PROFESSIONAL EXPERIENCE

Confidential, Southlake, TX

Senior Tableau Developer

Responsibilities:

• Gathered user requirements, analyzed, and designed various tableau visualizations.
• Setup and configuration of Tableau server 9.2 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created action filters, parameters, and calculated Fields for preparing dashboards and worksheets in Tableau.
• Created customized reports using various chart types like, text tables, bar Charts, pie Charts, stack bars, lollipop charts in excel and tableau.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Involved in created views, and custom sql queries to import data from databases to tableau.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Build dashboards for measures with trend line.
• Tested reports and uploaded tableau dashboards on to server.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the dashboards.
• Performed End to end testing using SQL Queries in Oracle & SAP.

Environment: Tableau Desktop 9.0/8.0 Tableauserver / Administrator, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, Microsoft office 2007

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created
• Business requirement documents and plans for creating dashboards.
• Written numerous technical essays and taught workshops on building scalable web applications on AWS.
• Created custom applications like "Subscription app" where users input their email address to schedule the workbooks data to be delivered as a dataset on a monthly basis using Tableau rest API resources to interact with various workbooks and dashboards.
• Dynamically load and resize visualizations
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Worked heavily usingTabadmin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Designed and setup user securityfor the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrationsfrom one environment to another.
• Setup of Distributed Server environmentsfor optimum load balancing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement
• Managed the migration of fixed income data mart from oracle to Teradata
• Provided the supporting role in designing the Security Architecture in the Business Objects 4.1
• Worked on CMC to create the User-groups and worked on the security rights
• Worked on life-cycle manager for business objects Xi R3.1. Promotion Management for 4.1
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports

Environment: Tableau Server, Tableau Desktop 8.x, Power BI, R 3.1.2, OBIEE11.1.1.6, Toad, SQL Server 2012, PL/SQL, Confidential -SQL, SSIS, MS Access, TFS

Confidential, Des Moines, IA

Tableau Developer/Administrator

Responsibilities:

• Proficient in Installing Configuring and Administration of Tableau Server
• Extensive experience in Tableau Administration Tool for Configuration adding users managing licenses and data connections scheduling tasks embedding views by integrating with other platforms like SharePoint
• Involved in publishing of various kinds of interactive data visualizations dashboards and work books from Tableau Desktop to Tableau Servers.
• Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Using the command line tools and configuration utility on the primary server and pushed the updates to the workers.
• Analyzed and used Tableau Server system requirements based on many factors, including the number of users and target workload.
• Configured Tableau Server to use an external identity provider (IdP) to authenticate Tableau Server users over SAML 2.0
• Used a PEM-encoded x509 certificate with the extension.crt for authentication of users using SSO with SAML
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Worked heavily usingTab admin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Designed and setup user securityfor the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrationsfrom one environment to another.

Environment: Report Studio, Analysis Studio, Query Studio, Framework Manager, Cognos Power Play Transformer, Tableau Desktop 9.0/7.0/8.0, Tableau Server 9.1, Business Objects, Excel, SQL developer, SQL 2008, Windows.

Confidential

Tableau Developer

Responsibilities:

• Used efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Createdautomated scripts for tableau workbook refreshwhen not using live connections
• Experience withTableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Experienced in managing schedules and scheduling workbooks and activities on Tableau Server
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR
• Analyzing web traffic and creating google analytic dashboards to visualize the web traffic interactively.
• Setup of SSO between Tableau portal and Oracle.
• Installed and setup cluster environment for Tableau server and used Jmeter for load balancing and load analysis
• Using the command line tools and configuration utility on the primary server pushed the updates to the workers.
• Used Kerberos for user authentication thru Active directory (Win AD).
• Performance tuning for the Tableau Visualizations and s users.
• Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.
• Assigning various extract schedules and using blending techniques to optimize the performance of Tableau.

Environment: MS SQL Server 2012/2008 R2, Excel, BCP, Confidential -SQL, PL-SQL, SQL BI Suite (SSIS, SSRS, SSAS), MS Office, Visual Studio 2010,Tableau Desktop 7/8 Tableau Server 8, Team Foundation server.

Confidential

Business Objects Administrator

Responsibilities:

• Identifying Business data and requirement and able to modifying them into data model accordingly.
• Research the business and system processes and collaborate with the reading material that end user provides.
• Installed and configured Business Objects on window environment.
• Implemented column and row level restrictions due to different business group requirements. And prepare raw data at Meta data level accordingly.
• Created versatile reports by linking data from multiple data sources, using SQL and stored procedures for the further use.
• Created reports using slice and dice, drill down, functions, cross tab, master detail tables and formulas, etc. in Business Objects function.
• Developed hierarchies, classes, objects and condition objects to support drill down reports in Business Objects.
• Publish broadcasting and maintenance business intelligence reports to vast number of end users.
• Migration and deploy the universes, reports across multiple environments.
• Maintaining, Testing and Production repositories and development.
• Scheduled broadcasting and refreshing documents monthly, weekly and daily through Broadcast Agent Server.
• Conducting UAT sessions with the clients.
• Provide training for the users in demand area. Like preparing the universe, access reports and system documentation.

Environment: PL/SQL, SQL*Loader, SQL 2008, UNIX, Oracle 8i, Toad, XML/BI Publisher, MS Excel.

Confidential

SQL Server BI/MSBI Developer

Responsibilities:

• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Optimized the query performance with modification in Confidential -SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for superior performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.