SUMMARY

• 17 years of IT experience with more than 14 years in Business Intelligence (BI) and Data Warehousing (DW) projects.
• 5 years of experience in Tableau Infrastructure, Tableau dashboards design, development,bug fix, and best practice and excellent visualization skills
• Thorough understanding of data warehouse methodologies (Kimball and Inmon)
• Built hundreds of reports and dashboards, implemented many projects ranging from complex BI server installations, cluster setup, tuning, Datamarts, Cubes, ETL, Architecture, Data modelling, BI strategic solution design, governance and system security
• Extensive hands on experience in BI Agile Project Management, Tableau dashboarddevelopment
• Developed and managed BI Full life - cycle projects including Design, Integration, Migration projects (Data migration, Source migration and software migration) and managed SDLC and Product life-cycle processes.

TECHNICAL SKILLS

• Tableau Desktop
• Tableau Server 6 7 8.x 9.x
• SAP Business Objects Enterprise 4.0
• XI 3.0/6i/5i
• Xcelsius
• DeskI
• Designer
• WebI
• Crystal Reports
• SSRS/SSIS/SSAS
• Webservices QAAWs
• REST
• XML
• PowerPivot
• Salesforce.com
• Oracle ERP
• SAP ERP
• Teradata
• Oracle
• DB2
• SQL Server
• MySQL
• Composite
• Netezza
• Erwin
• ERStudio
• Informatica
• SAP HANA
• BODS
• TOAD
• Java Script
• VBA
• VBScript
• SQL
• PL/SQL
• T-SQL
• Shell script
• XML
• PHP
• MS Project
• Version Control
• Visio
• MS Office
• Remedy
• SourceSafe
• SharePoint
• InfoPath
• Alteryx Designer

PROFESSIONAL EXPERIENCE

Sr. Tableau Consultant/ BI Lead

Confidential - Houston, TX

Responsibilities:

• Worked as a Lead Tableau Architect, responsible for overall deployment architecture, created, managed distributed architecture, technical design documents and best practices sessions
• Managed a team of Tableau developers and analysts, worked in multiple projects with both onshore and offshore teams
• Involved in weekly Elte partner calls with Tableau Product managers, Particapated in several Alpha and Beta Tableau product testings
• Hands on experience in Tableau architecture, Tableau Server installation, development, administration, bug fix and several day-day customer issue resolutions related to both server as well as dashboards
• Worked on ETL process using SSIS tool to get data for visualizations, Worked with BODS basis team to get the ETL transformed data into Warehouse. Involved in Creating the Schema objects including Attributes, Facts, Hierarchies and Transformations.
• Worked closely with Tableau vendor to fix the gaps such as SAP HANA to Tableau single sign-on, Excel based data sources on SharePoint and many other Tableau limitations
• Developed several best practices, advanced knowledge share, Tableau training sessions for a self service BI reporting model and trained power users on Tableau best practices
• Developed several interactive complex dashboards and story boards that included parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Built various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Provided future forecast analysis, past trends for different finance KPI segments.Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• CreatedTableau 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.
• Administered Tableau servers for high availability, monitored user groups, scheduled instances, resource hog dashboards to improve server performance

Sr. Tableau Consultant/ BI Lead

Confidential - Houston, TX

Responsibilities:

• With the success of BP North America Gas Tableau implementation I was re-hired into BP GCRO group to implement Tableau server setup, Dashboards and Reporting.
• Implemented enterprise Tableau server setup, Single sign-on and security and deployed dashboards and Story boards for BP Gulf of Mexico organization Health safety, operations and Finance and Supply chain teams.
• Built data federation layer using composite and SSIS tools, built SSAS based cubes for analysis. Sourced data into Tableau and SSRS reports.
• Worked as liaison between BP IT, business and many Government agencies such as EPA, NRDA, and integrated external data with internal
• Provided power user training on Tableau Desktop to build reports and analyze data
• Gathered, defined and documented business requirements, developed project plans, mockups, test scripts. Lead day-to-day communication and interaction efforts with senior executives, stakeholders, and Engineering and Operations teams.
• Developed and maintained high level overview of the project and design flows using MS Visio.Worked on Business Intelligence standardization to create database layers with user-friendly views in Oracle that can be used for development of various dashboards.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.Analyzed dimensional and fact tables in GoM data mart that details Environmental data related to oil spills, work force injuries, treatments and audits.
• Built numerous dashboards that included Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.Used geographic view, which clearly gives the performance of a particular state.
• Effectively used data blending feature in Tableau to connect different databases like Oracle, MS SQLServer.

Tableau Consultant/ BI Lead

Confidential - Houston, TX

Responsibilities:

• Joined BP North America gas business unit to transform their legacy reporting system to next generation automated self service decision support system.
• Evaluated Reporting and Dashboard solutions (Xcelsius, Micro strategy, Tableau); selected and implemented Tableau as dashboard presentation layer.
• Built a team of analysts Developed insightful dashboards and user stories using Tableau.
• Integrated Tableau as the primary reporting tool to source data from multiple databases through single source Data warehouse with one version of data using Composite, Netezza, Oracle and SQL Server databases.
• Obsoleted and converted more than 180 adhoc business objects and Excel based reports and provided the Dashboards to meet and exceed internal customer needs
• Analyzed the multidimensional data to provide key sights and answer key questions such as
• What is the Recordable rate, what are BP’s High potential incidents, which are the best contractors based on safety, what is the most common cause for accidents, etc.

Business Intelligence Lead

Confidential, CA

Responsibilities:

• Developed BI strategy and roadmap with industry best practices. Provided guidelines including tips, tricks and best practices for optimal BI solution
• Deployed dashboards for Warner Home TV using Xcelsius Live Office and QAAWS (Query as a web Service) to display in TV monitors located across lobbies. Responsible for Successful deployment of Sales and Marketing report systems.
• Developed and deployed Business Objects Universes and DeskI, WebI reports on Sales, Finance and Marketing data systems for SAP FICO, HR modules involving AWF Billing and Payments.
• Architected Workflows and Job flows in DI. Implemented custom transformation Logic and business rules for data massaging.
• Developed other team members, trained the end users by visiting different Operating Centers and rolled out the projects successfully.