We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

5.00 Rating

Warren, NJ

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.
  • Solid understand of SQL and understand and have worked with various data source types like Oracle and 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.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar
  • Graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and
  • Global filters according to the end user requirement.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical
  • KPIs and facilitate strategic planning in the organization.
  • Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning,
  • Strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking results.
  • Experience in configuring reports from different data sources using data blending.
  • Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
  • 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 10.3/9.3/9.0/8.3/8.2/8.1/7, Tableau Server 10.3/9.3/8.2, OBIEE 11g/10.1.3.4
  • ETL Tools Informatica 7.x/8.x (Power Center)
  • RDBMS SAP Hana, Oracle 9i/10g/11g, MS SQL Server 2008, Teradata
  • Languages HTML, XML
  • Operating Systems Windows 95/98/NT/2000/XP/7
  • FTP Tools WinSCP 5.X, Filezilla 3.5.x, Putty

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

Sr. Tableau Developer

Responsibilities:

  • Gather and analyze the business requirements and then translate them to technical specifications.
  • Integrated all portfolios, applications, releases, environments, builds, deployments, QA tests and defects by mapping all with DevOps fields, which are auto-generated.
  • Data feeds are coming from vElite server from all Jenkins builds and deployments through Rabit MQ. They are auto-inserted into MySQL DB on the backend.
  • Showing only one Portfolio now as POS, with simulated Jenkins Turbo Build for ATG Apps.
  • All applications are mapped into a specific list of customized pre-defined codes through a mapping data source.
  • Working extensively using Excel to validate the data and use as the source data files.
  • Analyzing the data using Statistical features in Tableau to develop trend analysis.
  • Provided mock up visuals to speed up requirements visualization.
  • Hands-on development in creating and modifying worksheets and data visualization Dashboards.
  • Created Level of detail expressions (LOD Expressions) data source columns are computed for each row in the underlying table.
  • Applied action filters specific sheets in the dashboard and cross dashboard.
  • Experience Dual Axes and show the graph in new visualization.
  • Good Experience in data blending with multiple data sources.
  • Experience in table calculations like windows max and percentage of total.
  • Created data source level filters, context filters and cascading filter to improve performance and user flexibility.
  • Developed Tabular, drill down, parameterized, cascaded and sub-reporting
  • Designed and Optimized Connections Live, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
  • Performance tuning of reports and resolving issues within Tableau Server.
  • Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
  • Testing dashboards to ensure data was matching as per the business requirement if any changes in underlying data.

Environment: Tableau Desktop 10.3/9.3/9.2, Tableau server, SQL, My SQL, Hive, Windows 2007, MS-Access and MS Excel

Confidential, Branchburg, NJ

Tableau Developer

Responsibilities:

  • Actively involved in gathering requirements from end users, involved in modifying various technical & Functional specifications.
  • Created Dashboards with combination of charts to help Users to analyze and understand the data and by navigating through the reports for detail analysis.
  • Created Parameters, Actions, and filters etc. for detail Visualization to meet end user needs.
  • 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.
  • Resolved loops by creating contexts for each fact table and also by adding aliases.
  • Track the issues and document the development process for program references
  • Conducted Training sessions for Tableau users and created the documents for end-user support.
  • Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization Dashboards.
  • Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
  • Design and development of various reports and dashboards that can be easily accessible through Tableau.

Environment: Tableau Desktop 9.0,9.2, Tableau server, SQL, Oracle 11g, SAP Hana, Windows 2007 /XP, MS-Access and MS Excel

Confidential, Houston, TX

Tableau Developer

Responsibilities:

  • As part of the Development team, Designed and developed innovative dashboard, analytics, and reports using Tableau Desktop 8.2
  • Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards etc.) using Tableau
  • Created Adhoc reports in Tableau 8.2 to visualize top incompatible Apps
  • Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up), List, crosstab etc. using Tableau.
  • Created complex formulas and calculations within Tableauto meet the needs of complex business logic
  • Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web
  • Developed various data connections from data source toTableauDesktop for report and dashboard development
  • Created Technical Documentation for reports and maintenance/enhancements of existing Reports
  • Involved in project planning, scheduling for database module with project managers
  • Discussed with business people to understand the rules for defining the Test Status of Apps at the report level
  • Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine
  • 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
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images and Maps and interacting with SAP Hana modelers to design materialized view.
  • Effectively used data blending feature in tableau. Defined best practices for Tableau report development
  • Connect Tableau to SAP Hana using Generic ODBC Connection
  • SAP Hana live connection experience with extensive report development experience, dash boarding and development of reporting
  • Generated Reports using Global Variables, using SAP Hana source
  • Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using
  • Analysis of data for the purpose of Product Version Mapping

Environment: Tableau 8.2 Desktop, SAP Hana, MS SQL Server 2008R2/2005 OBIEE, SSRS, Windows 7, Management Studio

Confidential, Philadelphia, PA

Tableau Developer

Responsibilities:

  • Analyzed various reports, dashboards, scorecards in OBIEE and created the same using Tableau Desktop.
  • Mentored business power users to create reports/dashboards using tableau desktop.
  • Designed and Developed various analytical reports from multiple data sources by blending data on a single
  • Utilized advance features of Tableau software like to link data from different connections together on one dashboard to filter data in multiple views at once.
  • Involved in new KPI generation for Scorecards.
  • Data collection and leveraging on data manipulation teams for required data.
  • Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
  • Identify new metrics and enhance the existing KPI's.
  • Dashboard Visualization through Tableau BI application.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards.
  • Effectively used data blending, filters, actions and Hierarchies feature in tableau.
  • Defined best practices for Tableau report development.
  • Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.

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

Confidential, Temple Terrace, FL

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 also 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 also established the various standard queries, in order to support the presentation layer.
  • Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages 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, Stamford, CT

BI Developer

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 break even (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.

We'd love your feedback!