We provide IT Staff Augmentation Services!

Tableau Developer Resume

Cleveland, OH

SUMMARY

  • 7 years of total experience in Information Technology Industry with expertise in Designing and Developing of Tableau Desktop / Tableau Server, Business Objects, SSRS, Crystal Reports, Data Warehouse applications and ETL Informatica.
  • Expertise in interacting with Business Partners and domain experts for requirement analysis, project estimates, development life cycle, deployment and testing of various reports.
  • Extensive knowledge in various reporting objects like Hierarchies, Transformations, filters, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
  • Experienced in developing rich interactive reports, dashboards and other user interface elements integrating various reporting components from multiple sources.
  • Presented various reports to senior management and clients to analyze data trends and future forecasting options using Tableau.
  • Quickly and effectively diagnosed and responded to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards .
  • Performed detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples).
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Generated dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Designed dashboards for measures with forecast, trend line and reference lines.
  • Experienced in designing complex dashboards that take advantage of all Tableau functions, including data blending, actions, parameters, and more.
  • Translated the business needs into system requirements by communicating with the business on non - technical level and with the System Analyst on technical level .
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Strong understanding of AGILE and SCRUM methodology and sprint grooming and regular standups.
  • Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
  • Experience with dimensional modeling using star schema and snowflake models.
  • Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
  • Worked with CI/CD as part of development and integration process.
  • Extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units
  • Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
  • Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
  • Ability to use custom SQL for performance improvements using data reduction.
  • Thorough knowledge of different RDBMS like Oracle, SQL Server.
  • An enthusiastic and project-oriented team player with solid communication skills by communicating clearly and concisely with colleagues and leadership skills by managing groups and delegated responsibilities, planned and coordinated a variety of tasks, solved problems and resolved conflict in the company.
  • 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.
  • Good knowledge on Tableau JavaScript API in applying filters, switching tabs, chain calls, etc.
  • Experience with integration of Tableau with Embedded Views in web applications.
  • Extensive experience Designing, Installing, Administration and Developing Crystal Reports using Crystal Reports 2008/2013.
  • Extensive experience with BOE clustering of components for resilience and load balancing.
  • Good experience with Universe design, Web Intelligence, Desktop Intelligence, creating ad-hoc reports and archiving reports along with performing User acceptance testing and Data accuracy test.
  • Experience in generating complex queries by linking data from multiple data providers using free hand SQL, PL/SQL, Stored Procedures, Triggers, Functions and packages with development tools like TOAD and SQL Developer.
  • Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, Security Management and 24/7 Production supports.
  • Extensive Experience in Business Objects 4.0/XI R3/R2/6.X/5.X (Designer, CMC, Web Intelligence, Desktop Intelligence, Scheduler, Import wizard).

TECHNICAL SKILLS

Business Intelligence Tools: Tableau 8.2, 9.1, 10, 10.3/10.5, 2018.2/2018.3 , 2019.2/2019.4 , 2020.1/2020.2 Crystal Reports 2008/2013, SSRS 2005/08/ 08 R2, Business Objects 4.0/XI R3/R2/6.X/5.X, QaaWS, CMC, Designer, Business View Manager, Info View, Web Intelligence.

ETL: Informatica PowerCenter 10.2/9.5/8.6.1

Databases: Oracle 8i/9i/10g/11g, 12c, MS SQL Server.

Operating systems: Windows 2007/2003/XP, Linux, Microsoft Office (Word, Excel, Outlook, PowerPoint, Project).

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Tableau developer

Responsibilities:

  • Modifying existing reports and to develop new reports by analyzing databases, data sources, and structures for the benefit of internal users.
  • Implemented Tableau Dashboard reporting solution for Bank Services group in the organization.
  • Replicated bank specific data sources from Cognos to Tableau and created Excel UAT files for comparison.
  • Provided support to team with the transition from Cognos to Tableau.
  • Recreated bank specific reports and validated data against Cognos reports.
  • Replicated the Cognos reports to Tableau and used Action filters, Parameters and LOD calculations, Quick Table calculations, Sets, etc. in Tableau dashboards and worksheets to minimize the complexity.
  • Scheduled meetings with users to train them and assist them with the Tableau questions.
  • Created and assisted users in Tableau worksheet development and Tableau web edit development.
  • Worked in Tableau environment to create dashboards weekly, monthly, daily reports using Tableau desktop & publish them to server.
  • 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.
  • 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 Tableau server.
  • Extensive experience in creating dashboards using calculations, set actions and parameters in Tableau.
  • Created advanced analytical dashboards using Reference Lines, Bands, forecast and Trend Lines.
  • Mastered in different formatting techniques, using Annotations and Mark Label.
  • Developed effective and interactive Dashboards using Parameters Actions, Set Actions and Highlight Actions.
  • Constantly tested SQL for joins and contexts for new object creation.
  • Optimize SQL queries for better performance.
  • Developed Data Dictionary Tableau report for all data sources and pointed the data dictionary report to excel data source available on SharePoint folder.
  • Created quick reference guides for all data source models.
  • Provided support for standalone Tableau reports and updated Landing Page Tableau report with weekly UFR metrics.
  • Created multiple projects on Tableau server and allocated permissions to users and groups at Project, Workbook and Data Source level.

Environment: Tableau 2019.4 /2020.2 , Desktop/Server, Cognos, Oracle, Microsoft SQL server, Service Now, Zira, MS Excel/Access, Windows 7 professional.

Confidential, Berkeley, MO

Tableau Developer

Responsibilities:

  • Interacted with users in analyzing the report requirements and developed multi-purpose reports to use across all the departments.
  • Participated in Daily stand up meetings with Technical Lead, manager and other developers and also weekly share meetings with Users.
  • Created tableau Views, Dashboards and Stories for future analysis and added subscribers to reports on Tableau Server.
  • Created advanced chart types, visualizations and complex calculations using Level of Detail expressions to manipulate the data.
  • Created and Scheduled Data Extracts for better performance of dashboards with multiple worksheets.
  • Effectively used new feature Cross-Database Joins to blend data between different data sources on/after Tableau 2018.3.
  • Trained users on using filters and actions created on dashboard effectively and provided subscription instructions to users.
  • Created various bar charts like variable-width bar charts, cascade charts and Marimekko charts.
  • Exposed to new features like clustering, cross data source filters and Highlighters.
  • Published the Reports into the folders in Central Management Console (CMC) and scheduled the reports to run monthly, quarterly, weekly, daily or based on the calendar in CMC.
  • Developed Sub reports in order to display data from databases of two different Servers.
  • Extensively created Complicated Formulas, functions and Created Reports include formatting options such as Charting, Mapping, Grouping, Sorting, Alerting, Field highlighting, Drill-down and Parameter prompts.
  • Maintaining server activities, user activity, and customized views on Server Analysis.
  • Created report schedules on Tableau server and Tableau Online.

Environment: Tableau 10.0/10.3, 2018.3, Desktop/Server, Oracle, Microsoft SQL server, Service Now, Team Foundation Server (TFS), MS Excel/Access, Windows 7 professional.

Confidential, Santa Monica, CA

Tableau and ETL Developer

Responsibilities:

  • Development of Tableau reports for CODM mobile game on player engagement and purchase history.
  • Reconfigured the Tableau server Permissions and Groups based on engagement, retention period and Revenue access levels.
  • Created complex queries against Databricks fact tables and connected the data source to Tableau Desktop.
  • SQL query data validation on Databricks and Tableau Desktop.
  • Connected to Databricks cluster to refresh extracts for CODM Tableau dashboards.
  • Upgraded to Tableau 2018.2 to use latest features like Tableau Extension Gallery, Dashboard Extensions and redesigned and simplified the complex old reports using latest Tableau features.
  • Experienced on using Microsoft Analytics services to establish Tableau Data source connection and created Tableau reports.
  • Provided user training on new Tableau report updates and features.
  • Analyzed business data using SAP Analysis for Office (AFO) service.
  • Simplified complex dashboards to give better performance while connected to live connection.
  • Redesigned old Tableau reports to use current features and capabilities across multiple teams.
  • Developed KPI based mobile & desktop dashboards and used LOD expressions to KPIs for certain functionalities.
  • Published Tableau dashboards that use Input Variables on Tableau server.
  • Extensively used context filters on Tableau dashboards to improve performance while changing filters.
  • Developed dashboards with Set Actions and Parameter Actions to extend user interactivity on dashboards.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Communicated with business customers to discuss the issues and requirements.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
  • Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
  • Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Effectively worked on Onsite and Offshore work model.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
  • Used Informatica file watch events to pole the FTP sites for the external mainframe files.
  • Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
  • Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
  • Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
  • Identified problems in existing production data and developed one-time scripts to correct them.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Tableau 10, 2018.1/2018.2 Desktop/Server, Data Bricks, AFO, Informatica PowerCenter 10.2/9.5/8.6.1 , Service Now, Zira, ALM, MS Excel/Access, Windows 10 professional.

Hire Now