We provide IT Staff Augmentation Services!

Sr. Tableau Consultant Resume

CharlottE

SUMMARY

  • Over 8 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
  • Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
  • Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster) and administration of Tableau Desktop/Server.
  • Solid understanding of SQL, understand and have worked with various data source types like Oracle, Neteeza, SQL server.
  • Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
  • Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
  • Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
  • Used OData URL of Sales force connector table to connect to the Tables.
  • Experience in configuring reports from different data sources using data lending.
  • Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
  • Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
  • Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML
  • Improved Reports performance in tableau using extracts and context filters
  • Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
  • Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production
  • Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x, OBIEE 11g/10.1.3.4

ETL Tools: Informatica7.x/8.x (Power Center)

RDBMS: Oracle 9i/10g/11g, MS SQL Server 2008, Teradata

Languages: HTML, XML

Operating Systems: Windows 95/98/NT/2000/XP/7

FTP ToolsWin: SCP 5.X, FileZilla 3.5.x, Putty

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Sr. Tableau Consultant

Responsibilities:

  • Develop various data connections from 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 published them to the web.
  • Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
  • Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
  • Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
  • Work directly with management, vendors, and third parties to ensure that Web site’s financial transactions and database management applications operate at peak efficiency.
  • Ensured projects were completed on time and within budget.
  • Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
  • Utilize Tabadmin and Tabcmd commands to create backups and restore backups of Tableau repository.
  • Hands on experience in Tableau server maintenance and Tableau server backup activities.
  • Consolidate multiple data silos that exist on campus to one location.
  • Scheduled data extracts on a daily basis.
  • Sophisticated stored procedures and triggers to provide complete technical solutions.
  • Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.
  • Resolved end user reporting problems through collaboration with IT and Operations.
  • Environment Support to User community, Service Request & Resolution.
  • Expertise in failed over activities in production Environments.

Environment: Windows XP, Tableau 8.1/7.0, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and JavaScript.

Confidential, New Jersey

Tableau Consultant

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.
  • 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.
  • Combined visualizations into Interactive Dashboards and publish them to the web.
  • Created groups and users in Tab.leau server
  • Used commands in Tabcmd and Tabadmin utility tool.
  • 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, process flow of the mappings, and provided Knowledge Transfer to the end users.

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

Confidential, Boston, MA

BI Consultant

Responsibilities:

  • Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
  • Experience in Preparing Design Specification documents based on functional requirements and involved in the preparation of Technical Design Documents.
  • Used MUD environment during development of the project.
  • Responsible for Creating the Physical Layer, Business Model and Mapping Layer and Presentation Layer in ANA Repository (.RPD) using Oracle BI Administration Tool.
  • Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Ago(), To Date based on the Requirements.
  • Created Attributes and Metrics in the BMM layer.
  • Created Aggregated Tables to improve the Performance of the Reports.
  • Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
  • Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
  • Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
  • Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
  • Created Business Model to support Ad hoc Reports for User Access based on Requirements.
  • Configured Presentation layer used by different User Groups and established the various standard queries, in order to support the presentation layer.
  • Security settings in Oracle Administration Tool to set up groups, access privileges, query privileges, and manage security for groups in BI Answers.
  • Managed Security privileges for each subject area and dashboards according to user requirements.
  • Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to 11.1.1.6.0.
  • Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.
  • Used theCatalogmanager and maintained the web catalog to manage Dashboards and Answers.
  • Test the reports and data in OBIEE against Micro strategy and validate them.
  • Responsible for documenting the OBIEE framework and track the progress.

Environment: OBI 10/11g, Informatica Power center 7.1.2/8.1,Oracle 11g, Microsoft Windows Server 2003, MS VISIO.

Confidential, CA

BI Consultant

Responsibilities:

  • Upgraded the existing Siebel Analytics Application on 7.8.4 to Oracle Business Intelligence 10.1.3.2
  • Migrated the existing Web Catalog using SAW Migrate utility.
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
  • Added Aggregate measures using Aggregate Persistence Wizard.
  • Configured Business Intelligence Delivers
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
  • Designed and implemented the single sing on (SSO) functionality.
  • Involved in setting up Clustering of Oracle BI servers for Load Balancing.
  • Developed automation tool to seed and purge the cache in Admin tool.
  • Migrated the Repository from Development to Production using UDML Utilities.
  • Designed Interactive Dashboards and created dashboard prompts.
  • Involved in configuring sources, targets, tasks and execution plans using DAC.
  • Have developed requests/custom reports using Siebel Answers based on Sales and Promotion subject areas in order to analyze and understand the Sales Opportunities and Promotion details by Brands/Promotions, Forecast to Estimated spending.
  • Involved in development of reports like campaign budget, Breakeven(CBAB) and campaign management reports
  • Involved in Query Tuning to maximize the performance of reports and Dashboards.
  • Used Informatica to extract the data from Siebel CRM, transform and load to warehouse.
  • Acted as a single point of contact for the Global data mart for coordinating the development across the platform. Responsible for onsite- offshore co-ordination.

Environment: Oracle Business Intelligence 10.1.3.2,Siebel Analytics 7.8.2/7.8.4, Siebel 7.5.3.4, Informatica Power center 7.1.2/8.1, DAC 7.7,Oracle 10g.

Confidential, Austin, TX

BI Developer

Responsibilities:

  • Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
  • Experience in Preparing Design Specification documents based on functional requirements and involved in the preparation of Technical Design Documents.
  • Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
  • Added Aggregate measures using Aggregate Persistence Wizard.
  • Enabled Usage Tracking Table and Dashboards.
  • Configured Business Intelligence Delivers
  • Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
  • Designed and implemented the single sing on (SSO) functionality.
  • Developed automation tool to seed and purge the cache in Admin tool.
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level.
  • Involved in designing STAR schema and developed complex Mappings / Mapplets using various Transformation / Re-usable Transformations (Update Strategy, Filter, Router, Expression, Lookup, and Aggregator) for implementing Dealer Data Warehouse.
  • Designed and developed Pre and Post session tasks and data extracted from Transaction System into Staging Area.
  • Developed custom SDE and SIL mappings to extract and load the data into Warehouse.
  • Experience in customizing out of the box reports to support the business requirements.
  • Experience in configuring sources, targets, tasks and execution plans using DAC.
  • Involved in Query Tuning to maximize the performance of reports and Dashboards.
  • Involved in assigning and managing privileges and rights given to the appropriate users and groups using Oracle BI Presentation Services Administration.
  • Involved in the creation of Presentation groups and users to provide access to the appropriate reports and dashboards.
  • Involved in managing the users to access Interactive dashboards by using the security matrix.

Environment: Oracle Business Intelligence 10.1.3.2,Siebel Analytics 7.8.2/7.8.4, Siebel 7.5.3.4, Informatica Power center 7.1.2/8.1, DAC 7.7,Oracle 10g.

Confidential

BI Developer

Responsibilities:

  • Created custom functions, stored procedures and packages to retrieve the data from tables.
  • Involved in creating synonyms to reduce the usage of base tables to securing the data.
  • Extensively used cursors, cursor for loops to fetch the data from different tables.
  • Involved in writing UNIX shell scripts.
  • Developed and deployed the User Interfaces using Oracle Developer 6i Forms.
  • Developed and deployed the reports using Developer 6i Reports.
  • Performed optimization of SQL queries (Used Explain Plan, TK-prof and Hints to tune SQL Queries.)

Environment: Oracle 8i, PL/SQL, Sun Solaris 5.0, Forms 4.5i, Reports 5, TOAD, SQL * Loader

Hire Now