SUMMARY

• Overall 9+ Years of Experience in analysis, design and development of reports using Tableau, Oracle SQL, epic data sources and Data analysis.
• Working knowledge and practice working in Agile development environment.
• 4+ years of Experience in Tableau Desktop/Server, creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Involved in Tableau Server configuration, creating Users, Groups, Projects and assign Privileges etc.,
• Experience working in various industry sectors such as Banking and Retail Business
• Extensive knowledge in Dimensional data modeling, Star Schema, Snow - Flake Schema, Normalization, Physical and Logical modeling.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
• Utilized all Tableau tools including Tableau Desktop, Tableau Public, and Tableau Reader
• Experience in configuration and administration of Tableau Server in a multi-server and multi-tier environment.
• Experience Interacting with power user community to understand and document requirements.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.
• Report development experience using Microsoft SQL Server Reporting Services (SSRS)
• Designed, developed, enhanced, performance tune maintain scripts usingSSISand SQL scripting. Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes.
• Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts.
• Managed multiple technical project workflows and ensuring data quality from end-to-end.
• Tackle the most difficult of challenges and know how to get to the best solution
• Experience with analysis, data, databases, and business intelligence
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts,
• Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Excellent with Actions and Quick Filters.
• Excellent communicator - ability to tell a story through data.

TECHNICAL SKILLS

Reporting Tools: Tableau Suite of Tools 10.0, 9.2, 9.0, 8.2, 8.1, 8.0, 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema ModelingSnowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer, Visio and Sybase Power Designer.

Databases: MS SQL Server-2016, 2008, DB2, MS Access

SQL Programming: SQL

Tools: SQL assistant, SQL Navigator, SQL Developer, MS - Visio, HP Quality Centre, Teradata. SSRS, SSIS

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer/Analyst

Responsibilities:

• Conduct requirement gathering meetings and analyze the business requirements and then translate them to technical specifications.
• Engaged with senior level management.
• Supported Sally Stores and BSG Full Service sales departments.
• Created different workbooks to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Applied Row level security.
• Performance Tuning of Dashboards and working with users and Database teams for design review and modelling.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Involved working in POC to various team for their Adhoc analysis of data with Tableau.
• Hands on Alteryx developed a sample Dashboards by connecting to Alteryx.
• Provided training to more than 300 users in Sally Stores Sales Conference including senior level management.
• Received excellent feedback from users and acclamation from Vice President & Director.

Environment: Tableau 10.1, Desktop, Tableau server, Alteryx, Oracle 11, SQL 2016, SQL*Plus, Windows 2003/ XP,SSRS/SSIS

Confidential, Spring, Houston

Tableau Business Analyst/Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Wrote SQL scripts and queries to extract data from various data sources.
• Wrote SQL queries for the data validation and testing the reports.

Environment: Tableau 9.2, Desktop, Tableau server, SQL, SQL*Plus

Confidential, White Plains, NY

Tableau Business Analyst/Developer - Lead

Responsibilities:

• Introduction and presentation of Tableau to the senior management including CEO, CFO, Finance Planning Manager, Operations Manager and Sales & Marketing Directors.
• Conduct requirement gathering meetings and analyze the business requirements and then translate them to technical specifications.
• Supported finance, accounting, operations and sales departments.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Performance Tuning of Dashboards and working with users and Database teams for design review and modelling.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Involved working in POC to various team for their Adhoc analysis of data with Tableau.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Provided training to the super users.
• Wrote SQL scripts and custom queries to extract data from various data sources

Environment: Tableau 9.2, Desktop, Tableau server, Oracle 11, SQL, SQL*Plus, Windows 2003/ XP,SSRS

Confidential, White Plains, NY

Lead Tableau Developer

Responsibilities:

• Local IS/IT Project Lead for Business Intelligence.
• Prepared Project Plan identified and notified the project team members.
• Conducted meetings for requirement gathering with business users, different teams of different applications.
• Develop multiple data connections from various data source to Tableau Server for report and dashboard development.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Working with Row level security using User filters and Username in Calculated fields.
• Developed charts and graphs involving Dual Axis charts and controlling view of worksheet via calculated fields and parameters.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Wrote SQL scripts and custom queries to extract data from various data sources

Environment: Windows XP, Tableau 9.0/8.1, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SSRS and SSIS

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Level of Detail Expressions and Date functions.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Performance Tuning of Dashboards and working with users and Database teams for design review and modelling.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tabcmd and Tab admin utility tool.
• Involved working in POC to various team for their Adhoc analysis of data with Tableau.
• Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8
• Implemented new features in Tableau 8 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Wrote Store procedures and custom queries to extract data from various data sources

Environment: Tableau 7/8.2, Tableau 7 Desktop, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, Windows 2003/ XP,SSRS, UNIX.

Confidential, Houston - TX

Tableau Consultant

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1. Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Reviewed Business requirements and prepared the dashboards as per the requirements
• Extracted data from different sources connecting them and used the same to create dashboard
• Modified the existing dashboard as per the user requirements Used Tableau Desktop for creating different interactive views and dashboards.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.
• Performed unit test/integrated testing scenarios which were used to obtain the UAT's.
• Developed narratives that describe the technical process in business terms.
• Communicated on daily basis with stakeholders and clients on Tableau related activities

Environment: Tableau 7.0,6.0,5.1, SQL, Oracle 10g, Crystal Reports 2008, SSRS,SSIS and MS Office Suite.

Confidential, Irving - TX

Tableau Consultant

Responsibilities:

• Interacted and worked with ETL team for improving performance on data from multiple data sources
• 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.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE. This is done to improve Report performance.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Involved in the complete process cycle; functional skills in analyzing the client requirements: translating new ideas into client-specific solutions using opportunity identification, requirements development, delivery, support, analysis and quick learner.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Worked on Bar charts, line Charts, combo charts, heat maps and incorporated them into dashboards.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience with Sorting, Building Groups and using in visualizations.
• Worked on Global, local and Context filters.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.

Environment: Tableau 7.0, SQL Server 2012, Windows

Confidential

Tableau Consultant

Responsibilities:

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau 6.0, 5.1, Informatica Power Center 8.6.1, Oracle 10g/9i, SQL, PL/SQL, MS Access, SQL server 2008, DB2, MS excel 2000

Confidential

Business Analyst / BO Developer

Responsibilities:

• Interacted with the End Users and responsible training sessions to impart knowledge on designed universes and published reports.
• Responsible to process Data mining activities to gather data and compile it to make a thorough analysis.
• Worked resolving the loops in universes using Aliases and Contexts.
• Upgraded Business Objects universes and reports from version XI 3.1 to 4.0.
• Involved in testing the reports while migrating from XI 3.1 to 4.0.
• Created Web reports with multiple data providers and synchronized the data using Merge Dimensions.
• Updating databases, systems and business intelligence tools.
• Created Dashboard using SAP Business Objects Xcelcius Dashboard and MS Excel
• Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
• Wrote SQL queries for the data validation and testing the reports.
• Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.

Environment: Business Objects XI 4.0/3.1, Web Intelligence 2.x/6 and Info view, Universe Designer, Publication Wizard, Import Wizard, and Dashboard Manager.

Confidential

Business Analyst/ BO Developer

Responsibilities:

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Worked as Dashboard / Performance Manager for the Net Investment and Interest to analyze the investment return.
• Created master detail reports using drill up and drill down functionalities
• Prepared reports using master detail, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter
• Used SQL against the database to check retrieved data integrity.
• Exported universes to the repository for making resources available to users.
• Actively involved in planning, documentation and administrative tasks.

Environment: Business Objects XIR2, Oracle 10g, MS SQL Server 2000, PL/SQL, Windows 2000/XP Server.