Tableau Consultant Resume
Baltimore, MD
PERSONAL PROFILE:
SeniorBusiness Intelligence Developer specializing in Tableau and SAP BusinessObjectswith extensive experience in complete Software Development Life Cycle (SDLC), including requirement definition, analysis, design, development, testing and implementation.
PROFESSIONAL SUMMARY:
- 9 years of IT experience, including over 6 years in Tableau and SAP BusinessObjects.
- Proven track record of successful implementation of Full Lifecycle of Tableau and BusinessObjects solutions, including extraction, tansformation and loading(ETL).
- Extensive experience in generating and maintaining Interactive Tableau Dashboards andReports to visualize the stories inside the data.
- Proficiency in Publishing and Scheduling reports using Tableau Server and Tableau Online.
- Expertise in creating visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps, Donut charts, Waterfall charts, Pareto Charts, Tree Map and Highlight tables.
- Experience in designing Dashboards and Reports with large volumes of data from various data sources such as Oracle, SQL Server and Teradata databases.
- Experience in creating and maintaining creating and managing sites, setting permissions, managing ownerships and providing access to the users.
- Extensive experience in building and managing Universes, Complex and Ad - hoc Reports, and Dashboards for transactional systems as well as for Data Warehouses.
- Experience in providing Production Support and Administration for Tableau and Business Objects environments, including ServerMaintenance.
- Demonstrated understanding of Dimensional Modeling (Star Schema and Snow Flake) and other Data Warehousing Concepts.
- Proficiency in SQL, PL/SQL, C#.NET, ASP.NET and VB.NET.
- Profound functional knowledge of applications and their underlying relational database structure like Oracle Financials, IBM Maximo, eB CAP, eB Nuclear, HP PPM Center and HP ITSM.
- Able to work on own initiative or as part of a team, backed by excellent communication skills along with the capability to solve problems efficiently.
- Diversified domain experience in Energy, Utilities, Manufacturing, Banking, and Financial Services.
SKILLS PROFILE:
BI Tools: Tableau 10.x/9.x/ 8.x (Desktop and Server) and SAP BusinessObjectsBI 4.x/3.1/XI R2 (Central Configuration Manager, Central Management Console, Information Design Tool, Designer, Business Objects, Desktop Intelligence, Web Intelligence, Report Conversion Tool, InfoView/ BI Launchpad, Crystal Reports, Xcelsius, Live Office, Upgrade Management Tool, Desktop Compatibility Package, Lumira).
Databases: Oracle, SQL Server, DB2,Teradata and Access
Query Tools: SQL Developer, Toad, SQL Server Management Studio, Aqua Data Studio and Teradata SQL Assistant
Languages: SQL, PL/SQL, Java, Shell, HTML, XML, C, C++, C#.NET, ASP.NET and VB.NET
Platforms: UNIX(Solaris), LINUX(RedHat), Windows Server
PROFESSIONAL EXPERIENCE:
Confidential, Baltimore, MD
Tableau Consultant
Responsibilities:
- Collaborated closely with business users to collect requirements and prepared Functional and Technical Design Documents.
- Involved in design, development and maintenance of Datamarts.
- Established a standardized methodology for designingDatamarts by De-normalizing transactional Oracle DBs using Materialized Views.
- Designed, developed, tested, and maintained Tableau reports based on user requirements.
- Converted existing BO reports to tableau dashboards.
- Generatedand maintained Performance Dashboards, Score Cards, Metrics, What-if Analysis, Prompts, Drills and Reports using Tableau Desktop.
- Created different KPIs using calculated key figures and parameters
- Developed Tableau data visualizations using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
- Developed donut charts and implemented complex features in charts like bar charts in tooltip.
- Created customized and interactive dashboards using multiple data sources.
- Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
- Built groups, hierarchies, sets to create detail level summary reports and dashboards using KPIs.
- Provided production support to end users and wrote custom SQL to support business requirements.
- Utilized Tableau server to publish and share the reports with the business users.Distributed reports using techniques like Packaged Workbooks and PDF.
- Involved in administration tasks such as setting permissions, managing ownerships and providing access to the users and adding them to specific groups.
- Designed, developed and maintained Business Objects Universes for supporting standard and ad-hoc reports.Resolved loops and traps in the Universes using Contexts and Aliases.
- Created reports using Universes, Stored Procedures, Free-hand SQL and Personal Data File Providers as data sources.
- Created complex canned and ad-hoc reports using Business Objects functionalities like Slice & Dice, Drill, Functions, Cross Tab, Master Detail and Formulae etc.
- Created Xcelsius Dashboardsand Live Office presentations.Developed and published stories in Lumira.
- Scheduled Reports using various methods for distribution of information.
- Participated in migration from Business Objects 3.1to 4.1.
- Prepared training materials and assisted instructorsin basic as well as advanced training classes.
- Delegated work to off-shore developers and coordinated their work with on-site team.
Environment: Tableau 10.x/ 9.x, SAP Business Objects BI 4.x/ 3.1, IBM WAS Server 8.x, IBM HTTP Server 8.x, Oracle 11g, SQL Server 2012, SQL Developer4.x,TFS2010 and Windows 7/ XP/ Server 2012
Confidential, Columbia, MD
Tableau Consultant
Responsibilities:
- Involved in gathering, analyzing, and documenting Business and Functional Requirements for Dashboards and Reports.
- Created and documented Technical Specifications based on Functional Requirements.
- Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
- Extensively used of advanced filters, groups, actions, complex calculations in Tableau Desktop.
- Prepared Dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
- Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
- Designed and deployed rich graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
- Utilized Tableau server to publish and share the reports with the business users.
- Identified the factors involving the performance of the reports and coordinated in creation of indexes to improve the query perfromance.
- Used data blending feature in Tableau to connect different databases like Oracle, MS SQL Server.
- Created and administered users, user groups, and scheduled instances of reports in Tableau Server.
- Designed, developed and maintained BusinessObjects Universes for supporting standard, complex and ad-hoc reports.
- Created numerous reports by extracting data from Transactional Databases as well as Datamarts.
- Created reports using Universes, Free-hand SQL and Personal Data File Providers as data sources.
- Promoted Universes, Reports and other content from lower tiers to production.
Environment: Tableau 8.x/ 9.x, SAP BusinessObjects BI 4.x, Oracle 10g/ 11g, Teradata, Teradata SQL Assistant 14.x, CVS, IBMWAS Server 8.x, IBM HTTP Server 8.xand Windows 7/ Server 2012/ 2012 R2
Confidential, Baltimore, MD
BusinessObjects/TableauConsultant
Responsibilities:
- Collected requirements and prepared Functional and Technical Design Documents.
- Involved in design, development and maintenance of Universes and Datamarts.
- Designed, developed and maintained Universes for supporting complex and ad-hoc reports.
- Resolved loops and traps in the Universes using Contexts and Aliases.
- Created reports using Universes, Stored Procedures, Free-hand SQL andPersonal Data File Providers as data sources.
- Created complex canned and ad-hoc reports using Business Objects functionalities like Slice & Dice, Drill, Functions, Cross Tab, Master Detail and Formulae etc.
- Created Xcelsius Dashboardsand Live Office presentations.
- Scheduled Reports using various methods for distribution of information.
- Converted and remediated Desktop Intelligence reports to Web Intelligence using Report Conversion Tool.
- Utilized Desktop Compatibility Package to support legacy Desktop Intelligence content.
- Imported/ Exported the Universes, Reportsand Dashboards from/ to repository to make them accessible to end-users.
- Migrated Universes, Reports and other content fromlower tiers to production.
- Created Usersand Groups and assigned security privileges.
- Migrated content from XI R2 using Upgrade Management Tool.
- Participated in developing proof of concept for Tableau for interactive dashboards.
- Createdcomplex Interactive Tableau Dashboards andReports for visualizing data.
- Utilized Tableau server to schedule, publish and share the reports with the business users.
- Prepared end-user training materials and trained new developers.
Environment: SAP Business Objects BI 3.1/ XI R2, Tableau 8.x, IBM WAS Server 6.x/ 8.x, IBM HTTP Server 6.x/ 8.x, Oracle 10g/ 11g, Oracle Financial/ EBS, SQL Server 2008/ 2012, SQL Developer3.x/ 4.x,TFS 2010 and Windows 7/ XP/ Server
Confidential, Columbus, OH
Business Objects Developer
Responsibilities:
- Collected requirements and prepared Functional and Technical Design Documents.
- Involved in design of Logical and Physical Data Models for warehouse databases.
- Used Star Schema and Snow Flake Schema in the data modeling phase.
- Developed Universes using Designer and exported them to the Repository to make them available to the users after checking the integrity.
- Resolved loops in the Universes using Contexts and Aliases.
- Created complex canned and ad-hoc reports using Business Objects functionalities like Slice & Dice, Drill, Functions, Cross Tab, Master Detail and Formulae etc.
- Developed Thin Client as well as Thick Client reports and exported them to be viewed by users on InfoView.
- Developed reports using Stored Procedures and Personal Data Files.
- Scheduled and monitored reports using custom Calendars.
- Managed Users, Groups, Repositories, Folders and Documents.
- Interacted with customers on regular basis, in order to generate reports required and to resolve the existing issues.
Environment: SAP Business Objects XI R2, Tomcat, Apache, Oracle 9i/ 10g, SQL Server 2000, SQL Developer 1.5, Toad 9.0, Team Foundation Server 2008 and Windows XP/ Server 2000/ 2003.
Confidential
Software Engineer
Responsibilities:
- Requirement analysis and design of system and database using a structured approach.
- Developed demo versions of products to solicit and in corporate customer feedback into the design.
- Involved in design, development, and implementation of applications.
- Developed Graphical User Interfaces (GUI) for applications.
- Participated in database Normalization.
- Created database objects such as tables, views and synonyms.
- Scripted stored procedures and functions implementing business rules.
- Involved in testing phase of the application
- Created and maintained documentation for functional and technical specifications.
Environment: .NET, HTML, UML, SQL Server 2000 and Windows 2000/ NT
