We provide IT Staff Augmentation Services!

Tableau Architect Resume

4.00 Rating

Aiken, SC

SUMMARY:

  • Having 7+ years of IT experience inBusiness Intelligence(Cognos, Tableau), Data warehousing, Data modeling.
  • 4 years of experience working with visualization tools like Tableau.
  • Have good understanding of Tableau Architecture, design, development and end user experience.
  • Extensive experience in Tableau Desktop, Tableau Server8.x.
  • Designed various KPI’s for business monitoring of Client.
  • Expertise in Designing Aggregations, Hierarchies, Formatting Sorting in Tableau.
  • Proficient in creating Groups, sets, Data bins
  • Good Expertise on working with Multiple Measures like Individual axis, Axis Blending and Dual axis.
  • Implemented Joins, Data Blending, Custom SQL in Tableau.
  • Good Knowledge in Users and Group Management, Licensing and Data Connections, Scheduling in Tableau Server.
  • End to end experience in designing and data visualizations using Tableau
  • Extensive experience working as a Business Intelligence with specialization inCognos 8.3/10.1.2.
  • Extensively usedFramework Manager,Query StudioandReport Studioformodel design, ad - hocreporting andadvancedreport authoring.
  • Systems analysis and design, converting requirements specifications into functional specifications.
  • Having Experience on Framework manager for creating models,folders,filters and publishing packagaes.
  • Expertise in developing and testing Complex reports (List, Cross tab, Charts, Maps, Drill through, Master-Detail, and Cascading) and Dashboards using Active Reports.
  • Worked with Different Databases likeOracle/9i/10g/11g, SQL Server 2000
  • Ability to work with different source systems (flat files, xml files, RDBMS, etc.)
  • Hands on experience withDimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
  • ExcellentVerbal & Written Communicationskills and strong inDocumentation.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
  • Proven background improving process quality and providing system Automation recommendations and Strategies to manage solutions and data efficiently..
  • Efficient in working closely with Development, QA, Product and Business owner teams to ensure high quality and timely delivery ofReports across multiple platforms and environments.

TECHNICAL SKILLS:

Reporting Tools: Tableau8.2/8.3(tableau Desktop, Tableau Server), Cognos 8BI, ( Framework Manager, Report Studio, Query Studio, Cognos Connection).

ETL Tools: Data Stage8.5/9.1.

Databases: Oracle 9x/10x/11x, SQL Server 2000/2005/2008/2012

Project Methodologies: Waterfall, RUP, Agile

Operating Systems: Windows 95/98/2000/XP/Vista/7, Linux

Programming Languages: C, C++

Other Tools: MS Office Suite, MS Project, Share Point

EMPLOYMENT HISTORY:

Confidential, Aiken, SC

Tableau Architect

Application: SPC

Responsibilities:

  • performed Gap Analysis according to Client requirements.
  • Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
  • Involved in JAD sessions with the whole team of Data Modeler, Analysts, and Developers to create a technical flow until reporting.
  • Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Tableau, timelines, testing, and technical delivery.
  • Worked closely with business power users to create reports/dashboards using tableau desktop.
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
  • Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Created Table of Contents (TOC), a common navigation page which had all the links to various reports.
  • Make use of filters and making them local and global accordingly.
  • Publish the developed dashboard, reports on the Tableau Server so that the end users who have access to the server can view the data.
  • Scheduled Full and Incremental Refresh of the underlying data sources while publishing them to the server.
  • Involved in the migration project where the Reports from Micro-strategy are re-created in tableau using more visualization options available as per End user requirement.
  • Analyzed the data in the Micro-Strategy reports.
  • Created Drill-down and navigation features extensively in Tableau Desktop.
  • Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
  • Actively participated in clarification meeting with the Client.
  • Created different types of charts.
  • Providing the Security while Publishing to the Tableau Server.
  • Applied various types filters like Data source filters, Quick filters and Context Filters.
  • Developed various types of complex reports like Cross tab reports, Drill Down and Master Detail Relationships.
  • Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
  • Coordinating with Business Analyst in validating report requirements.
  • Applied the actions in the work sheets and dashboards.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
  • Created Test Cases and documented the Test Results.
  • Extensively involved in doing user acceptance testing (UAT)

Environment: Tableau8.3, Datastage9.1, Oracle10g, Toad.

Confidential, Neenah, WI

Tableau Architect

Responsibilities:

  • Interaction with a diverse group of professionals and gathered user requirements and designed software solution based on the requirements.
  • Interacted with Business Analysts and Data Modelers and defined Mapping and Design process for various sources and Targets.
  • Adhere to good systems agile development methodology.
  • Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
  • Applied various types filters like Data source filters, Quick filters and Context Filters.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop.
  • Created incremental refreshes for data sources on Tableau server.
  • Coordinated database middleware issues with DBA's, system performance with System Architects.
  • Involved in license management SLA's with Tableau support.
  • Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.
  • Develop and maintain dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
  • Creation of workbooks and dashboards those are accessible on different environments like any browser or tablet.
  • Created Stories using Tableau as part of report presentations to Business
  • Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively
  • Responsible for Preparing the Report Design specifications based onthe User’s requirements
  • Created different types of charts.
  • Providing the Security while Publishing to the Tableau Server.
  • Developed various types of complex reports like Cross tab reports, Drill Down and Master Detail Relationships.
  • Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
  • Coordinating with Business Analyst in validating report requirements.
  • Applied the actions in the work sheets and dashboards.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Connecting multiple data source with Data Blending technique.
  • Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
  • Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
  • Extensively involved in doing user acceptance testing (UAT).
  • Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.

Environment: Tableau 7.0/8.0, MS Excel, DB2, TOAD, Windows

Confidential, New Orleans, LA

Tableau Developer

Application: Global Sales Data Mart

Responsibilities:

  • Involved in gathering the requirements andanalyzing them
  • Responsible for Preparing the Report Design specifications based onthe User’s requirement.
  • Involved in Data modeling.
  • Extracted data from various sources and performed data blending.
  • Creating Workbooks by Importing data, Defining Relationships.
  • Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
  • Developing, Designing and supporting interactive Tableau Dashboard reports.
  • Experience with the design and development of Tableau visualization solutions.
  • Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
  • Strong knowledge on software development life cycle (SDLC).
  • Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security..
  • Created Parameters to reports be more User friendly to End Users.
  • Connecting multiple data source with Data Blending technique.
  • Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
  • Providing the Security while Publishing to the Tableau Server.
  • Applied various types filters like Data source filters, Quick filters and Context Filters.
  • Created table calculations, calculated fields and parameters.
  • Created groups, sets, bins and performed conditional sorting and filtering as per the requirements.
  • Coordinating with Business Analyst in validating report requirements.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Executed and tested required queries and reports before publishing.
  • Validate the data for each report and review the reports.
  • Extensively involved in doing user acceptance testing (UAT).

Environment: Tableau Desktop, Tableau Server, Oracle, Informatica, Windows NT

Confidential, Bedford, NH

Tableau Architect

Responsibilities:

  • Interacted with business users for gathering requirements and look and feel of the applications to be a developer.
  • Created dashboard using parameters, sets, groups and calculated fields
  • Involved in creating a dual-axis bar chart with multiple measures and also created bins for different measures.
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Implemented data blending in order to merge data from different sources.
  • Used and applied actions like filter, highlight and URL to dashboards.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, SQL Server and Oracle.
  • Connected Tableau server with share-point portal and setup auto refresh feature.
  • Developed local and global filters while preparing worksheets and dashboards in Tableau.
  • Converted charts into Crosstabs for further underlying data analysis in MS Excel.
  • Published Tableau Packaged Workbook (.Twbx) in Server.
  • Performed Tableau type conversion functions when connected to relational data sources.
  • Experience in creating different Tableau workbooks, dashboards including Bars, Histograms, Pie charts, Maps, Scatter plots, Gantts, Bubbles and Highlight tables.
  • Creating Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau users.
  • Build homepage to navigate to all reports.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand data in an easy and efficient manner.
  • Created Bar Charts which is complied with data sets and added trend lines and forecasting for future predictions.
  • Involved in creation and updates of several SQL Indexes, joins, Views, Stored Procedures, triggers and functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Involved in performance tuning by creating and updating stored procedures and triggers.
  • Train end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableau including working with calculations, parameters and date functions.
  • Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Strong knowledge of Data Warehousing methodologies and concepts including Star Schemas, Snowflake Schema and identifying fact and dimensional tables.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Administered user, user groups, and scheduled instances for reports in Tableau.

Environment: Desktop & Server 8, MS SQL Server 2012, T-SQL, SQL Server Management Studio, SharePoint, MS Office 2010/2013.

Confidential

Tableau Architect

Application: P3MF

Responsibilities:

  • Interacted with cross functional teams to facilitate gathering of business requirements.
  • Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.
  • Developed various reports using functionalities like Drill through, Master Detail, Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
  • Worked on Analysis Studio to develop multi-dimensional reporting.
  • Performance tuning by analyzing and comparing the turnaround times between SQL and Congo's.
  • Recommended and coordinated development efforts and enhancements
  • Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
  • Used java scripts to manipulate the prompt pages and their functionalities.
  • Involved in writing Complex SQL queries to improve the performance of the report.
  • Testing reports using review checklists for Quality Assurance before delivering to the end users.
  • Involved in Deployment to QA, UAT and Production environment
  • Understanding the source systems and MD50’s developed by Oracle Financial team.
  • Gap Analysis with source systems.
  • Preparation of CV-40 documents.
  • Design and develop the ODS.
  • Developing in Framework Manager Project designing.
  • Creating Meta Data Models and Publishing packages to Cognos connection.
  • Preparation of Report design documents.
  • Responsible for the delivery of solution-oriented complex reports with multiple prompts, conditional formatting and calculated columns using Cognos report studio.
  • Developed reports with filters, calculations, prompts and conditions using Cognos report studio.
  • Developing the cube using IQD.
  • Involved in Scheduling and Cognos Report studio reports using Schedule Management in Cognos Connection.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Cognos Office Connection), Oracle 10g, Cognos Access Manger

Confidential

Tableau Architect

Responsibilities:

  • Interacted with cross functional teams to facilitate gathering of business requirements.
  • Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
  • Analyzed Business Requirements, performed GAP analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams and Robustness Diagram using Rational Rose.
  • Involved in Change Management Configuration using Rational Clear-Quest.
  • Performed UAT testing of the requirements. Testing for checking the data flow of the application using SQL.
  • Involved in preparing flow diagrams for the decision logic using Visio tool.
  • Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.
  • RUP process model was used for the different phases of the application development of the Software Development Life Cycle
  • Recommended and coordinated development efforts and enhancements
  • Generation of the UML Collaboration and Sequence Diagrams for specifying the call flow.
  • Worked on Data Mapping for the models for data transformation.
  • Worked with project managers, business analysts and end users to understand business requirements and translating them to technical specifications.
  • Involved in analyzing and documenting functional and technical requirements to develop packages and reports.
  • Developed standard/complex reports and analytics to meet the needs of business analysts and business users.
  • Built ad-hoc reports using prompts and parameters in Report Studio and Query Studio.
  • Extensive use of master-detail reports using repeaters and repeater tables.
  • Customized reports by adding Filters, Prompts, Calculations, Summaries and Functions.
  • Created Reports using multiple data providers like Packages, Personal data files, Stored Procedures and Free Hand SQL.
  • Bursting reports to different user groups.
  • Involved in full development of life cycle (SDLC) within Cognos reporting Framework from developing business requirements to production environment.
  • Provided the prompts, filters, drill up/drill down in Query Studio.
  • Created different types of reports like predefined Filters for the Ad hoc users, List, Cross-tab, Chart, Drill-Through and Master-Detail Reports for production using report studio

Environment: Cognos 8.3 (Framework Manager, Report Studio, Query Studio, Analysis studio), Oracle 10g, Windows, Microsoft Excel, Microsoft Word, Microsoft Visio, Rational Tools, Clear Quest, Clear Case, Microsoft Access

We'd love your feedback!