SUMMARY

• Business Intelligence professional with over 8years of experience in Software Design, Dashboard development, Integration, Implementation of BI and Database Platforms.
• Involved in using Agile methodologies and SDLC of Reporting Projects which includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollouts.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensively worked on Tableau 6.x/7.x/8.x (Desktop, Server, Reader), Micro Strategy, SQL
• Experience in Installation, Configuration and administrationof Tableau Server in amulti - server and multi-tier environment
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Introduced Tableau to Client’s to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Experience in designing techniques like Snowflake& Star schemas, fact and dimension tables, logical and physical modeling.
• Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Expert in tableau server commands like synchronization and Tableau server backup activity.
• Strong knowledge and understanding of Object oriented Java Scripting.
• Improved Reports performance in tableau using extracts and context filters.
• Worked with multiple teams where the development was on from one side and maintained the offshore.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables, OLAP and OLTP data sets.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.
• Team player with good communication and interpersonal skills. Productive interaction with business partners to identify business information needs for reports.

AREAS OF EXPERTISE

• Tableau 6.0/7.0/8.0/8.1/8.2
• Tableau Server
• Microsoft SQL Server
• Oracle 8i/9i/10g/11g
• MicroStrategy
• SDLC
• ETL
• Teradata
• Business Analysis

PROFESSIONAL EXPERIENCE

Tableau Administrator

Confidential, Plano, TX

Responsibilities:

• Helped set up a Data Integration Layer which consolidated data from multiple data sources ensuring data consistency and data quality by handling basic data cleansing and standardization of data elements
• Worked with Business Leads, Solutions Architect, and other Scrum Team members in an agile process to deliver high quality and efficient Tableau dashboards and ad-hoc reporting capabilities.
• Built user-friendly visualizations using most of the Tableau Desktop features including actions, parameters, LOD calculations, filters and various others.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Utilized Agile Scrum Project Management methodology to meet project requirements and goals for the project.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams and created Technical Design Document from the functional specification documents.
• Utilized Tableau Analytics to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value.
• Designed a Tableau Architecture and installed Tableau on Cloud based on number of Business Users.
• Generated visuals in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Design and deployed rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau and provided these visuals in Tableau online and Reader to Stake Holders.
• Generated context filters and used performance actions while handling huge volume of data.
• Created multiple Adhoc dashboards in Tableau in order to represent the status like strength and weakness etc. for the business users Confidential a glance.
• Created dashboards for financial department such as accounts payable, accounts receivables, Cash management and Asset management for Finance Team.
• Developed dashboard related to Asset management department for asset category and subcategory, depreciation and asset retirement.
• Worked on Python scripts to convert CSV files to flat files to ingest the data for ETL.
• Worked on Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).
• Created tables, views, materialized views with indexes in SQL Server to tune the performance.
• Installed and Monitored of Tableau Server (Dev and Prod) on AWS Environment.
• Installed the Tableau Server on the EC2 instances and configure the instances as primary and worker servers.
• Implemented AWS security features in Tableau Server to enable a single report or dashboard to securely serve the needs of a broad and diverse user base, including both internal and external users
• Created incremental refreshes for data sources on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created report schedules, data connections, projects, groups in Tableau server.
• Administered users, user groups, and scheduled instances for reports in Tableau.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Used Java Script API to customize the views, selects, filters, date and time.

Environment: Tableau 9.0/9.2, Tableau v8.2 (Tableau Desktop, Tableau Reader, Tableau Online and Tableau Server), Oracle12g (SQL, PL/SQL), SQL Server 2008, Python 2.7.

Sr. Tableau Developer/Admin

Confidential, Dallas, TX

Responsibilities:

• Analyzed the functionality and business requirement and transformed the Functional Design Document into Technical Design Document.
• Helped screen Tableau Developers for the proposed BI team.
• Was engaged with Enterprise Business Continuity Management in efforts to implement Tableau as a reporting tool.
• Gathered business and functional requirements from all stake holders.
• Created and updated server architecture for scheduling tasks.
• Analyzed and resolved performance and server based issues.
• Prepared backups using Tabadmin and Tabcmd commands..
• Created Dashboards with interactive views, trends and drill downs using agile methodology.
• Prepared test scripts and documented user training modules.
• Generated reports with SQL queries and relevant files.
• Developed heat map, geographic maps, symbol maps, cross tab reports, pie charts, bar charts, scatter plots etc., for understanding of business users.
• Documented interactive dashboards by combination of views and reports.
• Created crosstabs by conversion of existing charts and conducted data analysis using interactive Excel features.
• Implemented table partitioning to maintain performance levels.
• Formulated procedures for installation and configuration of Tableau desktop.
• Designed and developed SSIS packages for Tableau dashboards.
• Participated in performance tracking activity by evaluating server tasks.
• Modified data visualization dashboards and developed data connections.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Successfully trained senior management in developing self-service dashboard for personal data discovery and consumption.
• Helped with tracking and automating employee business continuity training progress (slowly changing data) through Tableau.
• Utilized advance features ofTableausoftware 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.
• Processed the data inSASfor the given requirement usingSASprogramming concepts.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Environment: Tableau 7 & 8 Desktop, Tableau Server, Oracle 11i, Teradata, Informatica 8.x, Windows 2003/ XP

Business Intelligence Developer - Tableau

Confidential, Herndon, VA

Responsibilities:

• Utilized Tableau Analytics to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Handled parameters, dashboards with JavaScript API having flexibility towards affecting the visualizations.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.
• Involved in created stored procedures, views, and custom SQL queries to import data from sql server to tableau.
• Used Tableau JavaScript API to integrate to integrate tableau visualizations in web based applications such as dynamically loading and resizing, selecting marks, responding to the events in visualizations.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Displayed visualizations from Tableau Server, Tableau Public and Tableau Online in web pages using JavaScript API.
• 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.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Environment: Tableau Server, Tableau Desktop 6 & 7, Micro Strategy 8.1.1, Desktop Reports, Web Intelligence Reports, Architect, Administration, Dashboard, MS SQL Server 2000, Confidential -SQL, Access 2000

Tableau Consultant

Confidential, Chicago, IL

Responsibilities:

• Interaction with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• 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.
• Involved in the design of the Application Business logic Components, which formed the architecture for distributed application development encapsulating business and data logic.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Implemented navigation and drill down features in Tableau dashboards.
• Used advanced mapping techniques, Aggregate Calculations, Duplicate Data connections, swapping dimensions with parameters in Tableau workbooks and dashboard development.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Created visually compelling and actionable interactive reports and dashboards.
• Created Backup scripts to take periodic backups for the content on Tableau server.
• Defined group/user level security standards for Tableau.
• Modified/maintained and created Products Universe.
• Created a component, which stores the total business logic of the portal, which contains many class modules related to business.
• Developed, deployed, and managed Commerce applications for the Web.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in reports.

Environment: Tableau Desktop and Server, Business Objects 5.x, Erwin, Windows 2000, IIS 5.0, ASP, SQL Server 2005/2008, VB 6.0, COM, MTS, HTML, DHTML, MS Visual SourceSafe, VBA, Excel

Business Analyst/Reports Developer

Confidential

Responsibilities:

• Interacted with clients for Business Requirements during design & implementation phases.
• Migrated databases from SQL Server 2005& various other sources into SQL Server 2008.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, & import/export wizard while developing packages.
• Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• All data were migrated to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server.
• Involved in the Data Warehouse design process
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports
• Created Web Intelligence Ad-hoc and canned reports in 3.1.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard
• Developed Dashboards for the higher management of the company
• Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Involved in writing Confidential -SQL, stored procedures, views, triggers, used indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition,.NET, Visual Studio, SQL, Confidential -SQL, MS Access, MSBI, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS,SSRS.

SQL Server Developer

Confidential

Responsibilities:

• Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Involved in debugging of packages and procedures and functions and troubleshoot jobs using the debugging tool.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in Database design, creation and maintenance of Databases.
• Worked on managing the use of disk space, memory & connections by monitoring.
• Created tables and views.
• Created functions, stored procedures, triggers and constraints using Confidential -SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Server & Application fine-tuning & trouble shooting.
• Wrote maintenance plans and code optimization.
• Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
• Monitoring MS SQL Server performance and network issues.
• Performance monitoring and tuning of SQL servers.

Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access