We provide IT Staff Augmentation Services!

Sr. Tableau Developer Resume

0/5 (Submit Your Rating)

Indianapolis, IN

SUMMARY:

  • Have 8 +years’ experience in Business Intelligence applications (Tableau & MicroStrategy), data modeling, designing and architecting data warehouses for the Retail, Healthcare, Financial and Telecom industries.
  • 5+ Years of extensive experience in Tableau Desktop, Tableau Server in various version of tableau including Tableau 9 x and Tableau 10 x. Proficient in data integration between different sources and reporting the same on Tableau environment. Extensive experience with Tableau Dashboard, Reports, and Data Visualization
  • Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
  • Well versed with the MicroStrategy product suite namely MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Dashboards.
  • Extensively worked in creating and integrating Reports and Objects in MicroStrategy (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) in the data warehouse.
  • Implemented proactive delivery reports and implemented the business intelligence solutions using MicroStrategy Narrowcast Server.
  • Extensive work experience with Ad hoc reporting using SQL queries and standard reporting environment.
  • Extensive work experience in designing Data Marts using different multi - dimensional modeling techniques such as Star Schema and Snowflake Schema for FACT and Dimensional tables that includes Logical and Physical data modeling.
  • Familiar in working with very large databases like Oracle, DB2, Teradata and SQL Server with MicroStrategy Suite.
  • Extensively worked with business to gather, review, validate and document the business requirements.
  • Experience in writing, reviewing and executing test scripts using different testing applications.
  • Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually. Proven experience at building,, motivating and leading professional teams, managing projects and supporting client relationships.

TECHNICAL SKILLS:

BI Tools: Tableau 9.x/10.x, MicroStrategy 9.4.1/9.3.1/9. x/8.x Desktop, Web, Object Manager, Command Manager, Dashboards and scorecards.

ETL Tools: Informatica, Data stage, Alteryx

RDBMS: Oracle 12c/11g/10g/9i, Teradata, SQL Server 2008/2005

Languages: SQL, PL/SQL, HTML, C, C++.

OS: MS Windows NT/2003/XP/ME/95/98, Windows 8, Windows 10, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr. Tableau Developer

Responsibilities:

  • Extensively worked with business to gather, review, validate and document analytic requirements.
  • Building dashboards from Tabular Models to help users to identify critical KPIs and facilitate centrally monitoring the clinical data.
  • Developing custom clinical trial dashboards for users to understand discontinuations rates, treatment compliance, patient safety and many more in a clinical study.
  • Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends.
  • Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
  • Produced attractive visuals/dashboards to convey the story inside the data.
  • Produced analytics by blending different data sources in tableau.
  • Worked extensively with Advance analysis Actions, Filters, Calculations, Parameters, Background images, Trend Lines, Statistics and table calculations.
  • Configured tableau to team SharePoint site so that data into the dashboard is imported directly.
  • Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
  • Optimized Data Connections, Data Extracts, and schedules for background tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
  • Worked as production support lead, which involved managing, handling, analysis and implementation of Incidents/Issues.
  • Worked with data warehousing team to fix key data mapping, data flow and data integrity Issues.
  • Good knowledge in Incident management tools like service now.
  • Created reports to easily track, maintain and respond to Incidents on service now.
  • Used service now auto schedule feature to export data directly and feed to tableau for user reporting.

Environment: Tableau Software 9.x/10.x, Microsoft office, SQL, Oracle, SharePoint, Alteryx

Confidential, Newark, NJ

Sr. Business Intelligence developer

Responsibilities:

  • Interact with the Business Management Solutions team on a Data Warehousing project involving MicroStrategy implementation on Teradata database. Involved in software development life cycle (SDLC) of the Project.
  • Involved in interacting with Data Architect in building Views and Table structures for Micro Strategy.
  • Configured the Intelligence Server and pointed the database instances in both development & Production environments.
  • On the Architectural aspect of MicroStrategy, created and modified mappings in the process of creating new Attributes and Facts.
  • Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters, Administrated MicroStrategy Intelligence Server and Web.
  • Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary
  • Embedded live Tableau dashboards on PowerPoint presentations, keeping the slides always updated
  • Designed and developed dashboards for use by Executives and Directors on a daily/weekly basis.
  • Setup stand alone and distributed Tableau Server to publish and distribute dashboards easily
  • Participated in discussions for Tableau Server architecture design on Cloud, enhancing performance, scalability and high availability. Connected tableau server with SharePoint portal and setup auto refresh
  • Involved in MicroStrategy Administration using modules viz, User manager, Command manager, service manager, VLDB Settings, License manager, Subscriptions and Events.
  • Performed the administration tasks like tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
  • Worked on support project involving fixing frequent customer trouble tickets.
  • Created security filters to restrict access to users under their directors using tailored groups.
  • Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.

Environment: Tableau Software 8.x, Microsoft office, SQL Server, Teradata, SharePoint, MicroStrategy 9.4.1 (Desktop, Administrator, Architect, Intelligence Server, Web, Object Manager)

Confidential, Secaucus, NJ

Tableau/ MicroStrategy Developer

Responsibilities:

  • Design and development of new MicroStrategy Reports for the new Retail BI system - created Schema objects / Application objects as well as configuration objects in Test environment.
  • As MicroStrategy Architect Involved in building schema objects to supported business process change or enhancements throughout projects.
  • Handling Daily user issues - Setting up and maintaining MicroStrategy web user roles and ps, helped in resolving daily issues in running Reports and Data Integrity issues.
  • Created advanced metrics (simple, nested & compound), advanced filters, advanced prompts, report designs and drill maps.
  • Created Tableau Dashboards showing Time Series Analysis of Web Traffic and sales conversion based on different factors. Exhibited internal sales trends using Tableau for better understanding of profitability of different client segments. This replaced time consuming Excel/ SAS based data analysis.
  • Created Tableau Dashboard visualizing impact of different media based Advertisements on Same Store Sales over different timeframe. Evolved Tableau visuals demonstrating relationships between TV advertisements, sales conversion of web traffic and call volumes at the call centers. Complex data joining and data blending was used to bring all the from diverse data sources in to one dashboard.
  • Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
  • Created several base formulas (mathematical expressions) using existing facts in MicroStrategy that can be re-used to build any number of metrics.
  • Generated advanced reports in grid, graph and SQL mode, consisting of data analysis by combining a template with filters, using MicroStrategy Desktop and Web.
  • Used MicroStrategy Object Manager to migrate MicroStrategy objects from development environment to the Test environment.
  • Design, build and maintain logical model for MicroStrategy reporting application.
  • Design, build and maintain all MicroStrategy schema objects (attributes, facts, hierarchies).
  • Good understanding of the type of schemas that best support MicroStrategy in different scenarios.

Environment: Tableau Software 7.0, Microsoft office, SQL Server, SharePoint, MicroStrategy 9.2 (Desktop, Administrator, Architect, Intelligence Server, Web), Object Manager, Oracle, UNIX.

Confidential

MicroStrategy Developer

Responsibilities:

  • Involved in the software development life cycle (SDLC) of the Project.
  • Participated in the end user meetings to obtain the business requirements for creating reports.
  • Involved in Data-Modeling Analysis like Creation of Snowflake schema, report structure based on the user requirements.
  • Used the Project Creation Wizard to create Facts and Attributes and used the respective editors to enhance them.
  • Team player with excellent communication and problem solving skills.
  • Created Attributes, Facts for different MicroStrategy projects.
  • Created the requirements Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment.
  • Created Reports using complex Filters and Compound Metrics and Prompts.
  • Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
  • Extensively used MicroStrategy Report Services to generate Report Documents.
  • Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services.
  • Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
  • Implemented proactive, personalized information delivery services using MicroStrategy Narrowcast Server. Created different objects that define Narrowcast Server services, including content Information Objects, Documents, Publications, Subscription Sets, and Schedules.
  • Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters, Administrated MicroStrategy Intelligence Server and Web.
  • Managing schema objects and application objects across the project by using Object Manager.

Environment: MicroStrategy 9.0/8.0 (Desktop/Agent, Object Manager, WEB, Enterprise Manager) Teradata, Oracle 10g (PL/SQL), Windows 2000 Professional, UNIX.

Confidential

MicroStrategy Consultant

Responsibilities:

  • Analyze requirements and develop derived metrics, custom report objects as required
  • Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.
  • Created Complex Metrics forcing Dimensionality and Conditionality embedded with prompts.
  • Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up Tables, Indexes and Views.
  • Extensively involved in data modeling to create attribute relationships.
  • Developed new reports and converted existing reports for the business line to satisfy the specifications using MicroStrategy Desktop and MicroStrategy web.
  • Developed MicroStrategy reports and related objects.
  • Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies
  • Responsible for testing of developed reports and report objects.
  • Created transformations to-do time series analysis and to compare the values at different times such as sales at this year versus last year, or month-to-date.
  • Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode.
  • Involved in Analysis, Design, Development, Testing, Documentation and Implementation of the project.
  • Maintain standardized MicroStrategy design, development, testing and deployment task documentation
  • Troubleshoot MicroStrategy application issues internally and with vendor
  • Design, build and maintain logical model for MicroStrategy reporting application
  • Design, build and maintain all MicroStrategy schema objects (attributes, facts, hierarchies)
  • Understand the type of schemas that best support MicroStrategy in different scenarios

Environment: MicroStrategy Desktop 8.1.2/9.0, MicroStrategy Intelligence Server 8, Oracle 10g, SQL, Windows 2000.

We'd love your feedback!