Tableau Developer Hadoop Data
Resume:
Veena surigi
******.*****@*****.***
Summary:
•8+ years of IT experience in Tableau Desktop/Tableau Server and also in every phase of Software Development Life Cycle.
•Extensive experience in creating highly interactive Data visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
•Good understanding of Tableau Desktop architecture for designing and developing dashboards.
•Expertise in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
•Created numerous ad-hoc analysis, dashboards, reports, graphs, and charts.
•Experience in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Bubbles, Histograms, Bullets, Heat maps, Crosstab reports, Donut and Funnel chats.
•Excellent in applying Actions and Quick Filters.
•Extensive Experience in Tableau server sites, User access and permissions.
•Experience in scheduling tableau report extracts on server and monitoring them on server.
•Experience in connecting Tableau desktop and server with Oracle and Big Data Hadoop data sources.
•End to end experience in designing and deploying data visualizations using Tableau.
•Prepared test cases and test scenarios to test the reports and dashboards in development level as well in database level.
•Expertise in interacting with end users, functional/technical experts and identifying, analyzing and developing the reports that meet the business needs.
•Strong Excel,powepoint access with focus on financial modeling and report writing via The use of pivot tables, vlookups queries and table configuration. Trend analysis and data interpretation.
•Proficient in conducting Gap Analysis, designing data flows and communicating the trade-off decisions on product features based on technology and customer requirements.
•Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.
•Experience in creating aggregates, sets, Joins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
•Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.
•I have working knowledge on data warehouse experience
•Hands on experience in publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.
•Implemented row-level security to define data access restrictions for users.
•Implemented security in Tableau workbooks by creating filter in workbooks also implemented security at Data Extraction level.
•Extensively provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
•Well versed with the Financial and Banking Domains.
•Expertise in analysis, design and implementation of database applications using Teradata, Big Data, DB2, Oracle and SQL Server database technologiesl.
•Extensively Worked on Star Schema, Snowflake Schema, Data Modeling, Logical and Physical Model, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
•Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
•Implemented drill in place so that users could view data at the granular level and make effective decisions concerning the business.
•Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.
•Built and expanded reports available for both internal support and external customer/carrier reports, which included increasing the scope of data extracted and utilized for reporting purposes.
•Strong in Analysis and collecting business requirements from Business Analysts and users.
•Excellent communication, interpersonal and analytical skills and a highly motivated team player with the ability to work independently.
•Ability to learn and adapt quickly to the emerging new technologies and paradigms.
•Extensive experience on onshore/offshore module engagements.
•Extensive experience in System design and development required for business process.
•Specialize in working with technical staff to create, interpret, and implement business requirements into technical specifications.
Education details :
Education: Bachelor's degree
Stream: ECE
University:JNTU
Year of completion:2012
Technical Skills
BI / Visualization Tools : Tableau Desktop 10.x/9.x/2019.3.1Tableau Server 10.x/9.x/2019.3.1,Excel
Languages: SQL, HTML, PL/SQL
Databases: ORACLE 11g/10g
Tools TOAD, SQL Developer, PL/SQL
Operating System: Windows XP, LINUX
Professional experience
Wellsfargo, NC Sep’19– Till date
Senior Tableau Developer(SME)/BI Developer
Comprehensive Capital Analysis and Review (CCAR9Q)
Wellsfargo is a leading financial services company, advising clients in all aspects of finance, across the globe and around the clock. It comes under financial domain. Comprehensive Capital Analysis and Review (CCAR9Q) provide a solution for all types of risk and is in accordance to Basel III Accord. It contains Higher Level Reports in BI Answers and dashboards for different regions.
Responsibilities:
•Gathering report requirements from various stakeholders, cross functional departments, business users and documenting them in the reports specifications document and report inventory.
•Involved in translating the business questions and business requirements to actual and final dashboard technical requirements.
•Experience using the Tableau tool to handle the various data feeds from different data sources using the Tableau Desktop tool.
•Building the customized and interactive dashboards using multiple data sources.
•Performed various report\dashboard activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau reports for various analysis
•Provided SME support for tableau issues within the team.
•Experience using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.
•Involved in creating the report mapping document, reports specs doc and interacting the cross functional departments and stakeholders for gathering report\dashboards requirements.
•Strong Excel, powepoint access with focus on financial modeling and report writing via The use of pivot tables, vlookups queries and table configuration. Trend analysis and data interpretation.
•Involved in creating the report mock ups, proto types for the end dashboards and interacting with stakeholders for report change request and sign -off on the requirements.
•Experience using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
•Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
•Developed various dashboards, used context filters, sets while dealing with huge volume of data.
•Establishes and enforces processes to ensure a consistent, well managed, and well-integrated data warehouse infrastructure.
•Involved in designing and developing the architecture of reporting layer.
•Deigned lot of mockup dashboards and reviewed with business and solution architecture team in the reporting layer design phase and suggested changes and modification to the model
•Created Dashboards using calculations, parameters in Tableau.
•Understanding of relational database structures, theories, principles, and practices.
•Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
•Deep experience with the design and development of Tableau visualization solutions.
•Responsible for Developing a Dashboard and preparing ad-hoc Reporting.
•Developed Interactive dashboards with blended views and provided multiple filtering option and action filters with best interaction.
•Involved in creating calculations at certain aggregation in reports using FIXED functions.
•Created Context filters in the dashboard reports so that users can see relevant values based on filter selection.
•Created Trend line charts for CCAR9Q scenario types based on 9quarters at different levels (i.e. Exposure Category, MIS, IHC Counterparty Code) for CCAR9Q User group.
•Enabled highlight feature in Tableau visualization dashboards so that users can highlight values on reports.
•Experience in Big Data Hadoop connectivity with tableau desktop and tableau server.
•Experience in debugging data related issues by validating data using Big data Hadoop Hue.
•Involved in data model design discussions with Big Data Hadoop Impala teams.
•Involved in creation of Active directory groups for Tableau project sites to manage user security.
•Involved in Cost Reporting Project to create Corporate Function dashboard where users can see the L1 Expenses and Head count in the Organization at Business Unit level.
•Created drilldown reports from Business Unit level to subdivision, Division and Account.
•Created Trend charts, Bar charts and Stacked Bar charts for displaying Head count at Region level.
•Created parameter based reports to switch between USD and CHF Reports.
• Created aggregated calculations, Calculated Field, Table Calculations, Totals, and Percentages using Measures.
•Extensively Worked on Star Schema, Snowflake Schema, Data Modeling, Logical and Physical Model, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
•Active Participation in final UAT phase in assisting and leading the users in testing the data in the ad-hoc workbooks and dashboards.
•Liaison between various cross functional departments, stake holders and business end users for the reports, dashboards clarifications, development, Usage of reports and end user tableau reports training.
Environment: Tableau server 10.1, Tableau Desktop 10.x, Big Data Hadoop Impala, Oracle 11g, UNIX/Linux.
Everyday Health, NY Jun’16 –Sep’18
Senior Tableau Developer
Health Insights
Everyday Health Group is a digital media company which owns websites and produces content relating to health and wellness. Insight is an Analytics application used to track and analyze the historical sales and calls details of their products and employees for different regions.
Responsibilities:
•Understanding enhancement/change requirements and designing the reports to meet the requirements.
•Created compound calculations to shape the data and build filters, advanced reports using diversified charts and dashboards visualizations.
•Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
•Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
•Involved in reviewing business requirements and analyzing data sources form different sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
•Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
•Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs least users using Tableau.
•Projected and forecasted future growth in terms of number of subscribers in various services by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server.
•Converted charts into Crosstabs for further underlying data analysis in MS Excel.
•Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle.
•Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
•Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
•Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/ dynamic and static datasets.
•Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
•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.
•Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
•Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
Environment: Tableau server 9.x, Tableau Desktop 9.x, Oracle 10g/11g, UNIX/Linux.
BNY Mellon
Feb’13- Nov’15
Senior Tableau Developer
Product Control Operations
The Bank of New York Mellon Corporation, which does business as BNY Mellon, is an American worldwide banking and financial services holding company headquartered in New York City. It comes under finance domain. Users analyze pnl reports, Balance sheet reconciliation reports based on user adjustments.
Responsibilities:
• Involved in reviewing business requirements and analyzing data sources coming from different systems.
•Created Business requirement documents and plans for creating dashboards by designing and developing Tableau visualization solutions.
• Developed Tableau reports and effectively used data blending feature in the tableau using calculated fields.
• Created different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, and Highlight tables.
•Developed various dashboards, used Context filters, sets while dealing with huge volume of data.
•Used parameters and input controls to give users control over certain values.
•Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop.
•Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
•Extensive use of joins, blending, custom SQL, hierarchies, action filters, extract filters, data source filters, parameters, table calculations, LOD expressions, sets, groups, bins in Tableau Desktop.
Environment: Tableau server 9.x, Tableau Desktop 9.x, Oracle 10g/11g, UNIX/Linux.
Diebold Nixdorf – Hyderabad, India
Jun’ 2012 - Jan 2013
Tableau Developer
• Analyzed business requirements thoroughly; created Tableau reporting design documentation and
•obtained feedback from business and IT
• Developed complex-banded reports, box plots, and histograms using Tableau desktop 10.0 and
•published these self-serve reports on Tableau Server 10.0.
•Administered and supported Tableau infrastructure including upgrade analysis and planning,
•security administration, release management, performance tuning and troubleshooting.
•Performed production readiness audit of Tableau applications.
•Experimented with new features and enhancements released by Tableau and brought them into the platform
•and organization.
• Provided leadership and ability to mentor team members for continued professional and technical
•growth in support of the business partners.
•Participated in Agile SCRUM stand-ups, retro and planning meetings and provided excellent
•Ideas and recommendations that were implemented in future sprints.
Contact this candidate