We provide IT Staff Augmentation Services!

Senior Tableau Developer/data Analyst Resume

0/5 (Submit Your Rating)

Houston, TX

SUMMARY

  • Around 8 years of extensive IT Experience as a Data Analyst, Business Systems Analyst in Data Warehousing and Business Intelligence applications in Retail, Banking, Financial and Healthcare industries.
  • Extensive experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 9.x/8.x/7.x
  • Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
  • Experience in facilitating Joint Requirement Planning sessions with Business User Groups, conducting Joint Application Development sessions with IT Groups & Conflict Management with Project team members.
  • In depth understanding of the As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
  • Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
  • Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
  • Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
  • Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
  • Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
  • Expertise in web integration of Tableau Reports with HTML or Asp.Net.
  • Good usage of Tableau JavaScript API for performance improvement of web page.
  • Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
  • Proficient Star Schema dimensional modeling, which includes understanding business processes, modeling dimensions, hierarchies and facts.
  • Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
  • Working knowledge of performance improvement measures including aggregate tables, Indexes and Explain plan
  • Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
  • Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.

TECHNICAL SKILLS

Visualization Tools: Tableau Desktop 9.x/8.x/7.x, Tableau Server 9.x/8.x, Tableau Reader.

Data warehousing: BI OBIEE 11g, Hyperion Essbase, BI publisher

Tools: Erwin 4.0, SQL Developer, TOAD, Pl/Sql Developer Tidal Enterprise Edition and MS Visio

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Teradata and IBM DB2

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

Others: Informatica Power Center 8.1.1/7.1.2/7.1.1/7.1.5 , DataStage 7.5, SSIS, SSAS, SSRS

PROFESSIONAL EXPERIENCE

Senior Tableau Developer/Data analyst

Confidential, Houston, TX

Responsibilities:

  • Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • 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.
  • Generate KPI for customer satisfaction survey results and disease management.
  • 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: Windows XP, Windows 7,Tableau, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java.

Senior Tableau Developer

Confidential, Houston, TX

Responsibilities:

  • Gathered user requirements, analyzed and designed software solution based on the requirements.
  • Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
  • Prepared Business Requirement document and then converted business requirements into technical designs.
  • Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality and publishing them to tableau server and tableau Online.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created report schedules on Tableau server and Tableau Online.
  • Created complex formulas and calculations within Tableau to meet the needs of complex business logic
  • Created and assisted users in Tableau dashboard development.
  • Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
  • Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
  • Creating users, groups, projects, Data connections, settings as a tableau administrator.
  • Maintaining server activities, user activity, and customized views on Server Analysis.
  • Manage the application’s users, groups, and integration with Active Directory.
  • Good SQL reporting skills with the ability to create SQL views and write SQL queries.
  • Integration of Tableau reports with Asp.Net web applications and usage of JavaScript API for performance improvement.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Involved in testing the Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
  • Integration experience of SAP HANA with Tableau for high performance Visualizations, Dashboard analysis

Environment: Tableau Desktop 9.2, Tableau server, SAP HANA, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007.

Senior Tableau BI Developer

Confidential, MD

Responsibilities:

  • Involved in full project lifecycle of SDLC and coordinated with all project teams.
  • Interacted with Subject Matter Experts & End Users and gathered business requirements.
  • Responsible for writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications Document (FRD).
  • Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
  • Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
  • Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
  • Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
  • Created and administered user, user groups, and scheduled instances for reports in Tableau Server.
  • Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
  • Extensive experience in creating dashboards using calculations, parameters in Tableau.
  • Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
  • Mastered in different formatting techniques, using Annotations and Mark Label.
  • Developed effective and interactive Dashboards using Parameters and Actions.
  • Setting the user permissions in Tableau Sever.
  • Maintaining server activities, user activity, and customized views on Server Analysis.
  • Prepared proof of concept for best practices in Tableau deployment.
  • Expertise in providing business solutions by analyzing various trends, risks and patterns in the data using interactive reports.
  • Extensive use of advanced filters, groups, actions, complex calculations in Tableau Desktop
  • Involved in integration of Tableau JavaScript API Filters in web application
  • Defined best practices for Tableau report development.
  • Created dashboards and reports for ad-Hoc Reporting.
  • Played an important role in coordination with the entire team and managing the time estimates for the entire project.
  • Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
  • Provided post implementation production support.

Environment: Tableau (Desktop/ Server), Teradata, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007 server

Tableau Developer

Confidential, New York City, NY

Responsibilities:

  • Interacted with business to collect and understand Requirements.
  • Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
  • Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
  • Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
  • Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
  • Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS.
  • Created Data Definitions and help maintain Metadata repository.
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
  • Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
  • Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau / SSRS.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
  • Ability to work quickly and under tight delivery deadlines with focus on details.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Environment: Tableau (Desktop/ Server), MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010

BI Developer

Confidential, Lakewood, NJ

Responsibilities:

  • Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • 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.
  • Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
  • 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: Windows XP, Linux, Windows 7, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB.

BI Developer

Confidential

Responsibilities:

  • Interacting with client regularly for better understanding of the requirements and providing possible solutions and there by developing code.
  • Assigning the tasks to team basing on the change requests obtained and enhancing the application for better performance.
  • Supporting the application and resolving the issues with in timelines and providing solutions to client for important enhancements.
  • Involved in Test case preparation and maintained the Quality Standards throughout the project.
  • ETL Jobs Scheduling.
  • Working on ETL Enhancements.
  • Resolving P1 Issues.
  • Monitoring & troubleshooting of SSIS Daily Loads.
  • Looking into issues related to PPS and SSRS.
  • Supporting the application and resolving the issues with in timelines and providing solutions to client for important enhancements.

Environment: SSIS, SSRS, SSAS, Performance Point Server, SharePoint Server, Windows Server 2008R2.

We'd love your feedback!