Tableau & Alteryx Developer Resume
Phoenix, AZ
PROFESSIONAL SUMMARY:
- Technically competent and resourceful Tableau Developer with overall 7+ years IT experience in analyzing data and creating compelling visualizations to support business decision making.
- Possess strong relationship building, training and presentation skills.
- Excellent in rendering reports, managing subscriptions, creating reports in Tableau. Creating Workbooks by Importing data, Defining Relationships.
- Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
- Developing, Designing and supporting interactive Dashboard reports.
- Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
- Experience with the design and development of Tableau visualization solutions.
- Experience in Marks, Action, Filters, Parameters, Cards, Publisher and Security.
- Experience in Requirement gathering and Data analysis.
- Created Derived Columns to fulfill the User Requirements.
- Created Parameters to reports be more User friendly to End Users.
- Connecting multiple data source with Data Blending technique.
- Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
- Providing the Security while Publishing to the Tableau Server.
- Excellent in scheduling and deployment of reports in Tableau.
- 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 another database's.
- Designed the reports using Crystal reports And SSRS to create reports for the end users.
- Good knowledge in development of ETL and programs using various tools like MS BIDS, Oracle PL/SQL.
- Created Many TDE (Tableau Data Extract) for various Projects and Scheduled Refreshed on Tableau Server as per the Business needs.
- 7 years of experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web - based Applications and Databases.
- Strong experience in design and development of Tableau visualization solutions. Experience in creating reports using various charts, data bar and spark lines.
- Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance.
- Experience in Developing Performance Dashboards, Score cards, Metrics, what if analysis, Prompts, Drills, Search (using Add-ons), Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain, and Transportation, Variable Objects with formulas.
- Extensive experience using Tableau Desktop and publishing dashboards on Tableau Server.
- Extensive Tableau Experience in Enterprise Analytics Environment.
- Experience working on Windows, UNIX, LINUX environments.
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
- Creating New Schedule's and checking the tasks daily on the server.
- Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user.
Environment: Tableau Desktop 8.2, Tableau Desktop 9.3, Tableau server, Alteryx 11.0 & 11.3, Cognos, OBIEE CA Clarity PPM solutions, Oracle SQL developer, SQL Server 2012, Oracle 11g.
TECHNICAL SKILLS:
REPORTING TOOLS: Tableau desktop 7.0, Tableau desktop 8.2 and Tableau desktop 9.0, Tableau desktop 9.3
Software Methodologies: SDLC, Waterfall, Agile, XP, Scrum
Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams.
RDBMS: Oracle 11g/10g/9i, SQL Server 2012/2008, DB2, Mainframe
O/S: Windows NT/2000/2003/XP/Vista/7, UNIX, MS-DOS and Linux
WORK EXPERIENCE:
Confidential, Phoenix, AZ
Tableau & Alteryx Developer
Responsibilities:
- Developed an Executive CIO dashboard where involved in the complete development and deployment of the dashboard.
- Collaborated closely with SMEs to identify and analyze core requirements and key features of their perspective organizations.
- Approached complete agile implementation for each phase of the development.
- Created Backlog, Sprint Backlog and managed User Stories & led daily stand-up meetings.
- Facilitated daily scrum, sprint planning and sprint retrospectives meeting
- Ensured effective implementation of agile process
- Provided strategic guidance on structuring the project portfolio within Clarity and supports the development of associated processes.
- Created reports to improve data integrity and support the development of strategy for executives.
- Supported creation and exception reporting.
- Monitored daily reports which are going to executive level.
- Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
- Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
- Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
- Created corporate standard variables in the metadata to ensure standard measures and best practices are followed. Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.
- Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance. Developed different kinds of reports (pivots, charts, tabular) using global and local Filters. Design various reports, i.e. Drill down, Pivot, Narrative Reports in OBIEE Answers.
- Implemented Prompts to provide dynamic filter condition to End users. Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and charts.
- Designed and developed Performance Measurement Dashboards/ Reports that are Dynamic & Interactive with drilldown, drill across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
- Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
- Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions and managing Cache.
- Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders.
- Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.
- Providing object level security for different web groups based on responsibilities Understanding the Business requirements, Involved in Designing and Configuration of Business Intelligence Server Repository as per Business Needs.
- Used OBIEE Administration Tool for Customizing and modifying the physical, business model, and presentation layer of the repository. Working on OBIEE Answers to create the reports as per the client requirements.
- Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
- Developed highly polished executive level dashboard.
- Created analytical reports that drives ongoing monitoring of resource allocations and utilization.
- Provided strategic guidance on structuring the project portfolio within Clarity and supports the development of associated processes.
- Build the reports to improve data integrity and support the development of strategy for executives.
- Supported creation and exception reporting.
- Monitored daily reports which are going to executive level.
- Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.
- Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units. Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform being implemented by the client.
- Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server.
- 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
- Worked on Remedy in creating the PSR’s and Opening the WR’s for the projects.
- Worked closely with the other CA Clarity PPM production team for the Clarity system impact analysis and gap analysis for the new Clarity requirement, Clarity and existing data models by pulling the data to Tableau Presentation layer to make the data visual for the data analysis.
- Enterprise Portfolio/Project Mgmt. Solution (EPPMS) Administration, Functionality Support & Structural Development for Clarity.
- Provided support and administration of Clarity (i.e. user/group security administration, monitoring of jobs and issues troubleshooting).
Environment: Tableau Desktop 8.2, Tableau Desktop 9.3, Tableau server, Alteryx 11.0 & 11.3, Cognos, OBIEE CA Clarity PPM solutions, Oracle SQL developer, Hadoop, Teradata, SQL Server 2012, Oracle 11g.
Confidential, Denver, Confidential
Tableau Developer
Responsibilities:
- Worked directly with Business Lines in Customer Care, Loans, Management Information Systems, Card Management to gather dashboard requirements for development.
- Hands-on development assisting power users in creating and modifying worksheets and data visualization dashboards for departmental consumption.
- Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
- Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
- 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.
- Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
- Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
- Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server. Published Workbooks by creating user filters so that only appropriate teams could view it.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Extracting data from different sources connecting them and used the same to create dashboard.
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau Created
- Increased extract performance by aggregating data and rolling up dates when creating extracts.
- Created Parameters, Calculations, Conditions, and Filter (Local, Global) for various analytical reports and dashboards.
- Created and modified Interactive Dashboards and creating guided navigation links within Interactive Dashboards.
- Implemented row-level security to define data access restrictions for users.
- Created new sets and added and removed data using the tooltip, and combined and compared multiple sets.
Environment: Tableau Desktop 8.2, Tableau Server, Metadata, Teradata, Oracle 10g/11g, Windows XP.
Confidential, MI
Tableau Developer
Responsibilities:
- Redesigned the data source having data from different sources into one SQL Server and to Tableau.
- Interacted with Business Teams to understand what needs to be visualized.
- Understanding what the client is expecting out of the reports, data cleaning to get to the right numbers for the weekly report.
- Generated Tableau dashboards with forecast and reference lines.
- Analyzed and gained understanding of the underlying data. Enterprise Key Metric Tableau dashboard is sourced from multiple Excel files.
- Designed Tableau dashboards for Project/Resource analysis application and Enterprise Key Metric application. These dashboards were utilized by higher management to do analysis, product development and their market share
- Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.1.
- Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.
- Also developed a process in the company to generated Tableau dashboards, which can be used for all the clients in the company by gathering the requirements.
- Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
- Execute and analyze complex test cases and compare the results with expected results and product requirements.
- Worked on Context Filters and Cascading Filters page and implemented various parameters, filters, calculated table calculations, aggregations, specific conditions, & created analytical reports.
- Prepared the design documents using Crystal Reports.
- Developed many reports using the conditional variables according to the need of end users.
- Testing and improving report performance, performance tuning on complex reports on the report level.
- Worked on scheduling reports to run monthly, weekly and daily basis using scheduler.
Environment: Tableau desktop 8, Tableau Server, Metadata, Windows 2007, MS SQL Server 2012, Oracle, DB2.
Confidential
Tableau Developer
Responsibilities:
- Developed interactive Tableau visualizations after gathering Business Requirements, interacting with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
- 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 on Creating Aggregates, Hierarchies, Charts, Filters, Quick Filters, Context filters, User filters, Table Calculations and Trend Lines also calculated measures.
- Implemented data blending and joins to work with data from multiple databases in a single report.
- Implemented Data Representation using Visualization Techniques in Tableau (Graphs, Charts etc.)
- Involved in Data modeling, designing, and building relational databases.
- Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
- Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
- Understood underlying Data and reworked Data Analysis with PowerBI.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Developed & Implemented Reports using Tableau Server.
- Responsible for Creating of Users, Groups and Projects on Tableau Server.
- Created Customized and interactive dashboards (pulling data from multiple data sources)
- Implemented tableau data extracts and created dependencies to trigger subscriptions once the extracts are finished through TABCMD utility.
- Leveraged tableau built in graphical capabilities to create bar charts, tree maps, area charts and created custom visualization like donut charts, trellis plots etc.
- Worked on Visual Studio 2012 with SSIS and SSRS Integration.
Environment: Tableau Desktop, Tableau Server, MS Office Suite, Teradata, Oracle, SQL Server,