We provide IT Staff Augmentation Services!

Sr. Tableau Developer/business Analyst Resume

San Antonio, TX

SUMMARY

  • 7years of experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau.
  • Extensive Tableau Desktop, Tableau Server Experience in Enterprise Environment, in various Tableau versions of 6.x, 7.x, 8.x, 9.x and 10.x as a developer and Administrator.
  • Experience in working with Tableau Desktop, Tableau Server, Alteryx, and Tableau Reader in various versions of Tableau 2019.4/10x/9x/8x/7x.
  • Experienced business analyst specializing in requirements analysis and SDLC documentation. Waterfall, UP , Agile and Scrum methodologies. Business Process Re - engineering (BPR) . Experience in full life cycle. Provide project coordination.
  • Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
  • Creation of metrics , attributes, filters, reports , and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Knowledge on RPA UI Path,Blue prisum.
  • MS Office Suite Skills, especially SharePoint, PowerPoint & Excel (including pivot tables, charts etc.)
  • Connected Tableau server to publish dashboard to a central location for portal integration .
  • Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, 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.
  • Proficient in creating Tableau scorecards, Tableau dashboards using advance Tableau functions like calculated fields, LOD (Level of Detail), Ad-hoc Calculations, etc.
  • Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
  • Strong Analytical and Problem-Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.
  • Used Data Blending, groups, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Experienced in designing customized interactive dashboards in Tableau using Actions, filters, parameter, Security Concepts, calculations and Relationships.
  • Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
  • Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
  • 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.
  • Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards in Finance and Funds sector.
  • Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
  • Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.

TECHNICAL SKILLS

BI Tools: Tableau 9x, 10x (Desktop, Server, Public), Looker. Business Intelligence Development Studio (SSRS), SSIS, Alteryx, Qlik sense, Einstein Analytics and Power BI, Crystal Report, Cognos.

ETL tool: Informatica Power Center 7/8, SQL Server Integration Services (SSIS), OLAP(Cubes)

Databases: Teradata, SQL Server, MySQL, SQLite, Hadoop/HBase, Hive, MS Access, Oracle 12c, Vertica, Salesforce, DB2.

Applications: Microsoft Office, MS Visio, Visible Analyst, Share point

Web Technologies: HTML, CSS, JavaScript

Languages: C, C#, Core Java, Python, R (BIGDATA)

Web Scripting: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio 2003/2005

Web Tools: MS-Front Page, Dream Weaver

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr. Tableau Developer/Business Analyst

Responsibilities:

  • Participated in Regulation W Banking Project and requirements gathering and translate business requirements into report visualization specifications design documents.
  • Translate business requirements into Tableau Dashboards.
  • Using Tableau Prep for Data preparation and combine them into single source of data using joins and unions.
  • 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.
  • Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
  • Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
  • We observed that most customers fared well by simply replicating their on-premises approach . Azure SQL DB uses the same drivers as SQL Server 2016, which inherently reduces complexity. With Tableau Desktop UI there is a single SQL Server connector for Azure SQL DB .
  • Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many Tableau reports.
  • Used trend lines extensively for correlating different KPI's for new product launches.
  • Designed, Developed and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
  • Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool).
  • Worked in Requirement Collections, Analysis, Development and Customization of the Application and implementing Requirements for the Project.
  • Involved in Publishing of various kinds of Live, Interactive data visualizations , Dashboards, reports and workbooks from Tableau Desktop to Server.
  • Developed Parameters and Dimension based reports, drill down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
  • Produce high quality and high value visualizations in Tableau that are Regulation W restricts certain kinds of transactions between banks and their affiliates.
  • Quickly resolve any internal customers issues raised and publish new versions of dashboards on a regular basis.
  • The main scope of this project is Regulation W aims to protect banks and federal deposit insurance funds from undue financial risk.
  • Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
  • Use various data source like SQL server, Google Analytics, App Dynamics, Hadoop and Hive.
  • Increased revenue by 1.5% and reduced disconnects of cable accounts by 6% through new Health check customer data dashboard. utilizing scripting languages to leverage Tableau's APIs (JavaScript API, Data Extract API, REST API).
  • As a Tableau Developer designed, developed, prototyping the various dashboards using tableau desktop 2019.3 version. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering ranking, Top-N Analysis, hierarchies)
  • Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
  • Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
  • Created a dashboard on Transactions Between Member Banks and Their Affiliates and Intercompany Transactions (Transactions Between Member Banks and Their Affiliates - Sections 23A and 23B of the Federal Reserve Act.
  • Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks.
  • Creating Alters for Transactions between a bank and its nonbank affiliates must occur according to arm’s-length terms and circumstances.

Environment: Tableau Desktop 2019.4, 10x, Tableau Server, SQL Server 2008/2008 R2, Netezza, Tableau Prep, SharePoint, MS Visio, spark,Agile, Jira Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Austin, TX

Sr. Tableau Developer/Business Analyst

Responsibilities:

  • Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
  • Translate business requirements into Tableau Dashboards
  • Created and managed plans using JIRA Portfolio .
  • Assigned the appropriate resources to the JIRA agile Portfolio - Story, Epics.
  • Experience in using python api, java script api.
  • Produce high quality and high value visualizations in Tableau that are widely adopted by CPI
  • Facilitated discussion, decision making, and conflict resolution to ensure consistent progresses.
  • Tracked metrics that are important to the team in order to deliver success and continuous improvement.
  • Helped the scrum team ensure they meet the definition of 'done' for each product feature and removed internal and external impediments to their progress
  • Quickly resolve any internal customers issues raised and publish new versions of dashboards on a regular basis.
  • Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
  • Translated business user concepts and ideas into comprehensive business requirements and design documents.
  • Created project plans in accordance with project management framework standards and procedures. Identified ongoing issues and gaps within project plans, in order to eliminate implementation issues.
  • Planned, facilitated and reported on quality assurance testing efforts.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Work with existing data model to produce accurate dashboards with respect to Rally and other tools.
  • Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
  • Created different views in workbook to visually analyze the data.
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
  • Gathered user requirements analyzed and designed software solution based on the requirements.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
  • Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
  • Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Restricted data for users using Row level security and User filters.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.

.

Environment: Oracle11g, ABC 11g, OWB 10g Release2, TOAD, PL/SQL, Bigdata (python, java) JDE, SQL Loader, Microsoft SQL Server, Unix

Confidential, Orange County, CA

Tableau Developer/Admin

Responsibilities:

  • Tableau license procurement and reporting across organization (United States, Asia Pacific, Europe, Middle East and Africa).
  • Interacting with business users to identify and build out visualizations . Experience with Sorting, Building Groups and using in visualizations.
  • Worked on Global, local and Context filters.
  • Build our reporting and KPI’s for executive team and multiple functional areas.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
  • Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Mappings, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.
  • As a Tableau Developer designed, developed, prototyping the various dashboards using tableau desktop 2019.3 version. Also involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering ranking, Top-N Analysis, hierarchies)
  • Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
  • Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool) and Data warehouse.
  • Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.
  • Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
  • Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources using Python and developed frontend backend python modules.
  • Created various interactive reports/dashboards using tableau desktop.
  • Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management. Created different Calculation fields according to requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.
  • Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report. Experienced on Date functions creating, executing test Cases and documenting the Test Results.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau (Desktop/Online) Informatica, MS Access, Python, MS SQL Server 2012,Excel.

Hire Now