PROFESSIONAL SUMMARY:

• 12+ years of experience in Data warehousing and Business Intelligence technologies along with over 8 years of data visualization using Tableau.
• Worked in multiple geographic locations (US, Singapore, Hong Kong, China, Japan, India).
• Worked in all phases of BI full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Extensive experience with design and development of Tableau visualization solutions.
• Well versed in Tableau 2018.3,10.x with experience in Tableau Desktop, Tableau server, Tableau Online, Tableau Public and Tableau Reader.
• Employed various Tableau functionalities like Tableau Extracts, Live, Parameters, Filters, Context Filters, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Data Blending, and Maps etc.,
• Hands-on experience in creating solution driven dashboards by developing different chart types including Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, Histograms and Custom Graphs in Tableau Desktop.
• Expertise in Tableau 2018.3,10.x,9.x, SAP BI 4.0, 4.1, XiR3, Microsoft power BI and Informatica Power Center 9.1
• Developed attractive visuals/dashboards using Power BI with multiple data sets.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Expertise in trouble shooting of performance issues which were associated with Tableau Dashboards.
• Expertise in Data Analysis, interpreting and analysing data for driving business solutions.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Well versed in Business Objects (BI4.1/XIR3.1/6.x) with experience in Designer, Reporting, Web Intelligence, CMS, CCM and Admin.
• Expertise in Admin, designing Universes & Reports using SAP BI 4.x.
• Expertise in designing developing Dashboards using MS Power BI.
• Expertise in tuning reports and Universe.
• Good knowledge on creating Groups, Users and Scheduling of the reports to end users using in Central Management Console and BI Launchpad.
• Worked on creating Azure Data Factory for moving and transforming the data.
• Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations
• Extensive experience in developing static and dynamic dashboards using Xcelsius4.5 via the web service connectors like QAAWS, Live Office, XML.
• Prepared the functional and technical specifications according to Organizational wide standards.

TECHNICAL SKILLS:

• Tableau Desktop 2018.3,10.5,10.3,10.2,9x,8x, Server, Tableau Online and Tableau Reader.
• SAP Business Intelligence 4.x, XI3.1/ XIR2.1, CMC, CCM, CMS, UDT, IDT, BI Launchpad, Web Intelligence, UMT and Import wizard.
• Microsoft Power BI
• Microsoft Azure DB(Cloud system)
• SQL Server 2008/2012/2014/2017 , Oracle 11g/10g and Teradata.
• Quality Center V9.2, TOAD, Service Now and JIRA.
• Informatica Power Center 9.10 and IBM Data Stage v7.5.
• Operating Systems Windows 98/2000/XP/NT, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. Tableau Architect

• Meeting Business stake holders to understand business requirement and ways to provide solutions through Tableau visualizations.
• Responsible for Tableau Environment, Security, Architecture setup.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Worked on Proof of Concepts to decide Tableau as Confidential BI strategy for enterprise reporting.
• Created technical specification documents related to Tableau design and architecture.
• Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
• Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Performed tuning of tableau workbooks and extracts to make them functional with large sets of data.
• Created responsive Dashboards for Mobile/Ipad /PC orientation views.
• Actively participating in the requirement gathering sessions. Understanding the source system (Connect Suite) data structure and planning on transformation of that data to target Azure Sql server.
• As a Tableau Subject Matter Expert, regularly meeting with Tableau Developer and User Community to understand the concerns and requirements and provide required solutions and guidance. Reviewing Interactive Data Source (IDS) table structures and redesigning tables and views as required.
• Implemented Okta security for external/internal users and documented the process.
• Implemented Tableau performance benchmarks based on Tableau best practices business requirements.
• Involved in creating views, stored procedures, and custom SQL queries to import data from Azure SQL server to Tableau.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Developed Power BI model used for financial reporting.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure.

Environment: Tableau Desktop 2018.3,10x, Tableau Server, SQL Server, MS Power BI, Azure Cloud, Tortoise SVN, JIRA, Service Now.

Confidential

Sr. Tableau Lead/Developer.

• Understand the Requirements and Functionality of the application from specifications.
• Involved in reviewing business requirements and analysing data sources form Excel/Oracle/ SQLServer for design, development, Performance testing, and production rollover of reporting and analysis projects within Tableau Desktop
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel
• 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.
• Involved in creating views, stored procedures, and custom SQL queries to import data from SQL server to Tableau
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization
• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards
• Consistently attended meetings with the client subject matter experts to acquire functional business requirements
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltips.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations
• Involved in trouble shooting of performance issues which were associated with Tableau reports
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group

Environment: Tableau Desktop 10x, Tableau Server, SQL Server, Oracle 11g, Tortoise SVN, JIRA, Service Now.

Confidential, Los Angeles, CA

Sr. Tableau lead/Developer

• Development of operational reports using Tableau, requirements gathering and collaboration with multiple stakeholders
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advanced features of Tableau software like, to link data from different connections together on one dashboard and to filter data in multiple views at once
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Defined best practices for Tableau report development
• Created dashboard using parameters, sets, groups and calculations
• Prepared end user training document and provided training

Environment: Tableau Desktop 9x, Tableau server, Oracle 10g, SQL Server Tortoise SVN. Service Now Reporting, JIRA reporting, ARP(Access Request Portal)

Confidential

Tableau Developer

• Deep experience with the design and development of Tableau visualization solutions
• Preparing Dashboards using calculations, parameters in Tableau
• Demonstrated knowledge in dealing with various functionalities like global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users
• Worked on design and development of Tableau visualization solution
• Developed high-level dash boards using Tableau reporting tool for the higher managements.
• Involved in creating a dual-axis bar chart with multiple measures
• Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis

Environment: Tableau Desktop 9x, Tableau Server, SQL Server, Service Now Reporting

Confidential

Tableau Developer & BA

• Gathering requirements and prepared BRD and Functional spec's
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Generated Dashboards with Tableau filters, Parameters and sets to handle views more efficiently.
• Developed Tableau workbooks from multiple data sources using Data Blending
• 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.
• Fine \tuned SQL Queries for maximum efficiency and performance.
• Developed various views in Tableau (Tree maps, Heat Maps, Scatter plot)
• Developed Logical calculations, mapping, formatting
• Created Tableau reports by using dimensions and measures like List, Cross tab, Graph and Dashboards
• Created individual Worksheets and incorporated them into Dashboards with the appropriate filters.
• Implemented Data-Blending for synchronizing the data from multiple data sources
• Created the Tableau data extract and published it in server by optimizing it to reduce the report rendering time
• Sending the dashboards to users by emails with the help of admin team with subscriptions
• Responsible for the BO universe design and development using XIR2&R3 Designer tool
• Understanding and analysing business and functional requirements related to Business Objects (WebI/DeskI) Reporting design.
• Scheduling of the reports for end users using Central Management Console (CMC) and Info View
• Created the Ad hoc reports as per the end user’s requests
• Formatted reports as per the user’s requirements using all the facilities in Business Objects, which allows the users to analyse the data
• Testing and data validation of the reports as per the business requirement

Environment: Tableau Desktop 8x, Business Objects XI R2&XI R3.1, Web I, Web Rich client, Desk I, Designer, CMC, Import Wizard, TOAD, Service Now Reporting.

Confidential, Texas, USA

Developer

• Understood the current Architecture, databases and designed schemas
• Interacted with the Business Users to analyse the business process and gathered the requirements made necessary changes to schema objects to fulfil their reporting and business needs
• Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements
• Interacted with the users to analyse the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements
• Successfully tested all the reports and exported them to Live
• Built static Dashboards using Crystal Xcelsius with the data in Excel files
• Updated the static models with live data connecting via the Web Service connectors like QAAWS
• Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008
• Effectively communicated with offshore and development team in different locations
• Effectively communicated with users in various locations throughout USA
• Creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart
• Used macro scripts for automating the execution of maps
• Designed and developed Informatica mappings for data loads
• Informatica Power Center 8 (Source Analyzer, Mapping Designer)

Environment: Business Objects XCelsius 4.5, BOXI R3.1, Informatica Power Center7x, Teradata and Control M.

Confidential - MI

Developer

• Involved in Report development
• Crosstab reports and complex reports.
• Involved some of universes minor changes
• Created thin client reports using Web Intelligence
• Created the reports using Business Objects functionalities like combined queries, Slice and Dice, Drill Operations
• Resolved Issues within allocated Timeframe (SLA)

Environment: Business Objects XI R2/6.x, Oracle 9i/Teradata.