Sr. Business Data Analyst / Sr. Tableau Developer Resume
Irving, TX
SUMMARY
- 8+ years of IT experience interacting with business users and technical community for requirements gathering, software data modeling/design, solution delivery planning and communication on various BI/Data Analytics platforms.
- 4+ years of experience in Tableau Desktop/ Tableau Server 10.x/9.x/8.x/7.x, creating highly interactive Data visualization Dashboards.
- Having4+ yearsof experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
- Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
- Expertise in Tracking, Documenting, Capturing, Managing and Communicating the Requirements using Requirement Traceability Matrix (RTM).
- In depth understanding of the Gap Analysis i.e., As - Is and To-Be business processes and experience in converting these requirements into Technical Specifications and preparing Test Plans.
- Expertise in designing and creating various analytical reports and Dashboards with rich interactive visualizations to help users to identify critical KPIs and facilitate strategic planning in the organization.
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, LOD's, Sets, Groups, Parameters etc., in Tableau.
- Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Pareto Charts, Funnel Charts, Bar Graphs, Scatter Plots, Pie-Charts, Donut Charts, Bubble Charts, Funnel Charts, Heap Maps, Tree Maps,Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
- Extensive experience in developing reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating various reporting components from multiple sources Tableau like Tableau Server, Teradata, Google Analytics, Hadoop Hive, Amazon Redshift, Hyperion.
- Hands on experience in embedding Tableau reports and dashboards on external websites using Java API scripting.
- Extensive experience in Tableau Administration for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
- Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle, SQL Server, Tableau, Alteryx, Informatica, Micro Strategy, Business Objects, SSRStechnologies.
- Good Knowledge in Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
- 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.
- Good knowledge of Data Warehousing concepts, RDBMS and multi-dimensionalschema (Star Schema and Snowflake Schema) and worked on both OLAP and OLTP databases.
- Coordinated Technical Reviews, developed System requirements. Developed test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT).
- Worked in the onshore/offshore model, performing key responsibilities.
- Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
TECHNICAL SKILLS
BI Tools: Tableau (Desktop/Server),Micro Strategy, Business Objects, SSRS
ETL Tools: Alteryx, Informatica, SSIS
Front End Tools: MS Project, MS Office Suite ( Word, Excel, PowerPoint), Visible Analyst
Databases: Teradata, Oracle, SQL Server, DB2, Netezza, SAP HANA
Data modeling: ERwin, ER Studio, MS Visio
Document Management: Visual Source Safe, Share point, Ultra Edit, Documentum
Scripting Languages: Java Script, C, C++, HTML, SQL, PL/SQL, and XML
Methodologies: Kimball/InmanData Modeling, Star/Snow flake Schema, Waterfall, Agile
PROFESSIONAL EXPERIENCE
Confidential, Irving TX
Sr. Business Data Analyst / Sr. Tableau Developer
Responsibilities:
- Interacted with business users and performed Gap Analysis of client requirements.
- Work with business in understanding the Nature of Data, accordingly will get the best possible way to create dashboards in Tableau for different Domains using multiple data sources.
- Worked closely with business power users to create reports/complex dashboards using tableau desktop.
- Worked closely with manager to analyze & understand Business requirements; gathered User, Functional and Non-Functional requirements & translated the requirements into User Stories.
- Update weekly status on projects to Business Users, Stakeholders, SME’s, and Managers.
- Actively participated in JAD sessions to work with SME’s, Business Users in gathering data related information for all metrics.
- Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.
- Involved in reviewing business requirements and analyzing data sources form Excel, Oracle, SQL Server, SAP HANA, SAP BW, Netezza for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop and Created Reusable dashboards to utilize the same process for all the Models for Different Source systems.
- Schedule Winshuttle job to pull data out of SAP to share drive.
- Worked on designing BO reports and schedule them for reporting purpose in Tableau.
- Schedule SSIS to load data from Share drive to SQL server tables.
- Created Sessions and workflows for the Source to Staging data flow and staging to Target loading.
- Designed and developed Mappings and Sessions based on the business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
- Create calculated views in SAP HANA/ SQL Server/ Netezza.
- Created Data loads, Data Quality Checks for ensuring data accuracy and reproducibility.
- Created both logical and physical designs of a database and ran the reports.
- Created Dashboards and Storyboards based on the SFDC metadata using Tableau 10.x and validated the loads
- Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts, Lollipop Charts, Heat Maps, Funnel Charts, Bar Charts, Page Trails, and Density Chart.
- Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
- Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
- Mastered in different Formatting techniques, using Annotations and Mark labels.
- Developed effective and interactive Dashboards using Calculated Fields and Parameters across Multiple Data Sources.
- Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
- Strong Dashboard design experience and passionate practitioner of effective data visualization.
- Published and shared views on Tableau server and Scheduled extract refresh and subscriptions.
- Provided Production support to Tableau users and fine-tuned Custom SQL scripts to support business requirements.
Environment: Tableau 10.x (Desktop/Server), SAP BO, MS SQL Server, Aginity, SAP HANA, SAP Logon, Winshuttle, Nintex, SSIS, SQL Assistant, CA Service Desk, UNIX, Microsoft (Word, Access, Excel, Outlook), JIRA.
Confidential, Austin TX
Sr. Data Analyst / Tableau Consultant
Responsibilities:
- Worked directly with client, data architects, business analyst and internal team members to understand reporting requirements,identified various KPI’s and designed solutions to enhance business decision-making.
- Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
- Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
- Involved in Agile Methodology (Scrum) from requirements gathering to maintenance and monitoring the progress.
- Analyze and implement the data flow into different layers in EDW.
- Participate in physical design of data record, data files and EDW databases.
- Worked on Data Profiling and Data cleansing, Data Quality activities.
- Designed and developed stored procedures, queries and views necessary to support Tableau reports.
- Prepared mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
- Created extensive Tableau reports, various interactive dashboards and published them on Tableau Server.
- Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle and performing data blending in reports.
- Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
- Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
- Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
- Worked extensively on Advance analysis actions, Calculations, Parameters, Background images, Trend Lines, Statistics and table calculations.
- Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
- Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
- Embedded Tableau reports/dashboards on to the external web pages.
- Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
- Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
- Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
- Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
- Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
- Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
Environment: Tableau 10.x/9.x (Desktop/Server),MS SQL Server, SSIS, TOAD, Teradata SQL Assistant, CA Service Desk, UNIX, MS VISIO, Microsoft (Word, Access, Excel, Outlook), Primavera.
Confidential, Miami FL
Tableau Consultant
Responsibilities:
- Worked with the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
- Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks. Works with external organizations to gather requirements and resolve issues.
- Consistently attended meetings with the client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
- Worked closely with manager to analyze & understand Business requirements; gathered User, Functional and Non-Functional requirements & translated the requirements into User Stories.
- Generated Business Requirement documents (BRD), Functional Specification design documents (FSD) and Functional Requirement Documents (FRD).
- Participate actively in Agile Scrum meetings and share the mapping/ Functional Review with development and testing teams and sending MOM to the participants after the meeting.
- Deployed the reports and Scheduled Reports for the use of end users and customersWork Experience.
- Research on the new sources of data and map them into Database tables.
- Assist in verifying data to ensure that it adequately meets user requirements.
- Implement the best design patterns and solution to adapt for future changes.
- Participate in physical design of data record, data files and databases.
- As a Data Analyst worked on Mapping Documents to load facts and dimension tables as well as created mapping for aggregated views.
- Work with ETL team to them let understand the Data Mapping Document.
- Worked with ETL toolfor cleansing and blending different data sources for analyzing the data.
- Worked on Metadata Requirements/Definitions for the new/required data sources (Tables/Columns).
- Created aggregated views to transform the data as per business needs, before creating visualizations.
- Analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, chartsand pivot tables.
- Created extensive custom joins for blending data from several different data sources like Hadoop Hive, SAP HANA by blending data on a single worksheet in Tableau Desktop.
- Created Tableauscorecards, dashboards using stack bars, bar graphs, scattered plots using show me functionality.
- Implemented Data Representation using Visualization Techniques in Tableau (Graphs, charts etc).
- Created Groups, hierarchies, and Sets to create detail level summary reports and dashboards using KPI's
- Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableauapplication.
- 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
- Used Table Calculations, Parameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards.
- Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
- Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop for data validation.
Environment: Tableau 10.x/9.x (Desktop/Server),MS SQL Server, Informatica, TOAD, Teradata SQL Assistant, CA Service Desk, UNIX, MS VISIO, Microsoft (Word, Access, Excel, Outlook), Embarcadero, VB Macros, Agile, BOX, JIRA.
Confidential, Raleigh, NC
Tableau Developer
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.
- Acted as liaison between Business Intelligence and Business User groups to relay change requests.
- Performed extensive GAP analysis in the project as there were numerous ‘As-Is’ and ‘To-Be’ conditions.
- As a Data Analyst worked in coordination with clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
- Deployment of TableauServer in clustered environment by mapping server nodes to primary machine.
- 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.
- Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
- Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
- Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
- Generated guided navigation links for Interactive dashboards in Tableau.
- Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
- Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
- Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states
- Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate the data..
- Worked with Individual Axes, Blended Axes, and Dual Axes.
- Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
- Created and updated stored procedures and functions to meet the requirements and changes specified by the users
- Pushed all the created stored procedures and functions to the development, training and production servers.
- Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
- Involved in scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
- Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
- Oversee the performance of Design to develop technical solutions from Analysis documents.
- Provided post implementation production support.
Environment: Tableau 9.x/8.x (Desktop/ Server), Alteryx, MS SQL Server 2012, SSIS, VB Macros,Oracle, Oracle 11g, Erwin, SharePoint, Agile, JIRA, Microsoft (Word, Access, Excel, Outlook), Embarcadero.
Confidential, Lakeland, FL
Tableau Developer
Responsibilities:
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
- Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro and managed the concurrence of the parties involved with respect to the evaluation criterion.
- Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
- Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Database Servers.
- Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case.
- Used SQL queries for organizing and extracting data from Teradata databases to suffice adhoc data requests for Business Users.
- Captured Data flow diagrams and formatting of the data flowing through interfaces.
- Accumulated system requirements for analytical reports across different subject areas like Finance, Marketing, Merchandising users to convert MicroStrategy reports to Tableau reports.
- Designed standardized datamarts with aggregated tables and views to suffice data sourcing requirements for Tableau reporting solutions.
- Configured the Data mapping between Oracle and SQL Server to Teradata.
- Designed and Developed single reports instead of multiple reports as in Tableau by implementing row level security and user filters to cater multiple users with different access levels to the data.
- Conducted meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
- Created exceptions report which were then submitted to project lead and stakeholders on a regular basis.
- Facilitated user acceptance testing and test strategies with Tableau power users.
- Performed manual front-end testing to check all functionalities of different modules.
- Suggested measures and recommendations to improve the current application performance with the aid of SCR’s (Small Change Requests).
- Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
Environment: Tableau (Desktop/ Server), Teradata, Share Point, TFS, Agile-Scrum, Informatica, Micro Strategy, UNIX, SQL Server, Erwin, Share point MS VISIO, Microsoft Office (Word, Access, Excel, Outlook, Project).
Confidential, Boston, MA
Data Analyst/Tableau Developer
Responsibilities:
- Worked with end users to gain an understanding of information and core data concepts behind their business.
- Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
- Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
- Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
- Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
- Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
- Written several shell scripts using UNIX Korn shell for file transfers, error logging, data archiving, checking the log files and cleanup process.
- Metrics reporting, data mining and trends in helpdesk environment using Access
- Create and Monitor workflows using workflow designer and workflow monitor.
- Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
- Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
- Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
- Identify & record defects with required information for issue to be reproduced by development team.
- Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
- Flexible to work late hours to coordinate with offshore team.
Environment: Teradata Oracle, PL/SQL, SQL Server 2008, MS SQL, Informatica, MicroStrategy, Erwin, DB2, HP Open View, Lotus Notes, Windows XP, MS Office Suite (Word, Excel, PowerPoint).
Confidential
SQL BI Analyst / Developer
Responsibilities:
- Created and/or strengthen systems fordatacollection, management, reporting and analysis. Advised the agency on technology needs to maximize efficiency and support a culture of managing todata
- Assisted in the creation and documentation of the business processes fordatacollection, entry, reporting, review and use ofdatato strengthen performance management
- Implemented logical and physicaldatamodeling
- Developed PL/SQL stored procedures for the end-user report requirements
- Created crystal reports on the stored procedures and exported the Business Objects reports to WEBI, to be viewed by all users on the intranet and extranet
- Created queries for multidimensional analysis using slice, dice and drill modes
- Analyzed complex business needs presented by the user community and/or clients and recommended technical solutions to improve the reporting environment
- Accomplished Performance tuning of SQL queries and stored procedures using Database tuning advisor in SQL Server
- Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS
- Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
- Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches
- Created SSIS packages and used Analysis Services processing task to update the cube with current data
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
- Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
- Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
- Identified the dimension, fact tables and designed the data warehouse using star schema
- Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
- Created report snapshots to improve the performance of SSRS
- Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures
Environment: Windows XP/2000 Server, SQL Server 2000/2005, SSRS, Crystal Reports, BO Web Intelligence, MSOffice,XML,T-SQL, SSIS, SSRS.