Tableau Developer

Sudhakar, acx0m1@r.postjobfree.com, 573-***-****.

• Overall 8 years of experience in System Analysis, Design, Development and support of Involved in Business Intelligence Tools Usage of MSBI and Tableau in Production, QA, and Development environments.

• Skilled in Tableau Desktop versions 9.1, 9.2, 8.1 and 8.2. for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails.

• Experience in creating solution driven dashboards by developing different chart types including Crosstab's,Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, in Tableau Desktop.

• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.

• Expertise in writing SQL Queries, SSIS, SSRS, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages using Microsoft .NET framework.

• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.

• Implemented Tableau /Oracle BI security at the Data (Data security) and object (Roles and Permissions) security.

• Expert in Tableau server commands like synchronization, Tabcmd and Tableau server backup activity. Improved Reports performance in Tableau using extracts and context filters.

• Strong Tableau Reports I.e. Worksheet and Dashboard creation experience.

• Highly proficient in the use of SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.

• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.

• Utilized dynamic data connections for Reports creation.

Work Experience

Tableau developer/administrator Client: Bed Bath,Retail,Jersey city/NJ. December 2015 to present.

Roles & Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects

• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.

• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.

• Scheduled the published dashboards from Tableau Server on weekly basis.

• Sending the dashboards to users by emails with the help of admin team with subscriptions.

• Mentored business power users to create reports/dashboards using Tableau desktop.

• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

• Work with senior management to plan, define and clarify dashboard goals, objectives and requirement.

• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

• Given training/demos to users on Tableau Desktop for development.

• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

• Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.

• Administered user groups and scheduled instances for reports in Tableau.

• Administered user, user groups, and scheduled instances for reports in Tableau. Built complex formulas in Tableau for various business calculations.

Environment: Tableau Desktop 9.x, Tableau server / Administrator, SQL developer, SQL Server 2012 2008, Oracle 11g/12c, Microsoft Excel 2012, Microsoft office 2012 .

Tableau Developer, Client: Best Buy,Retail,Minneapolis,MN. January 2015 to October 2015 Roles & Responsibilities: • Partnered with business analysts to understand requirements, source systems, and perform data analysis. .

• Developed proof of concepts to showcase BI tool functionality to the end users and management audience including report and dashboards. Built the needed master data objects as "Attribute Views

• Improved performance by narrowing the data set by creating projection nodes and by applying filters

• Wrote SQL script required to create Script based Calculation Views

• Built Visualizations and Storyboards. Combined data sets, edit, and cleansed datasets. Enriched data by creating calculated measures and attributes in the data sets. Grouped multiple measures together and used them in visualizations

• Lead the Reporting Architecture and mapping development effort for the project.

• Designed, Developed and Presented Dashboards. Made interactive designs using Multiple Drills Down, Dynamic Visibility, and Alert Features to support various requirement scenarios.

• Dashboards using Advanced Multiple Drills Down, Dynamic Visibility.

Environment: Tableau Desktop 8.0/8.3 Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, Microsoft office 2007.

Tableau Developer, Client: MK,Retail,NJ/NY. February 2014 to December 2014.

Roles & Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment, and user training.

• Involved in Physical/Logical design of database, creating and managing the database and all the database objects.

• Designed and developed reports using Crystal Reports.

• Designed and developed various complex reports.

• Generated reports that can handle dynamic grouping and dynamic sorting.

• Involved in dimensional modeling to design data warehouse.

• Used the calculated members in the fact tables to improve efficiency.

• Involved in Performance tuning, query optimization and execution plan of queries for better performance.

• Created roles, assigned permissions and users/groups to roles to limit the access for the users.

• Communicated with clients regarding system requirements, ensuring the development and implementation of customized products for customer satisfaction

• Prepared functional specifications for user requirements.

• Experience in writing, testing, and implementation of the PL/SQL triggers, stored procedures, functions, and packages to implement business logic.

• Developed and modified applications, authored database procedures and triggers for data processing.

• Created entry forms/reports for various modules. Created databases, loaded initialization data, generated users, and assigned roles and access.

• Created Tables, Indexes, Table Spaces, Views, Synonyms, and Integrity Constraints.

• Prepared user manual and technical documents for the end user.

• Maintenance and support for the system. Involved in end user training

Environment: Oracle 9i, Server 2000, PL/SQL, TOAD, SQL, SQL Server Management Studio, SQL Server Integration Services (SSIS).

Tableau Developer, Client: Amex Finance,Phoenix,AZ, March 2013 to January 2014 Roles and Responsibilities:

• Served as Tableau subject matter expert to assist the BI team in learning Tableau, addressing development roadblocks, and migrating reports from existing server to new Tableau enterprise server.

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau Development life cycle.

• Administer and support a multi-tier Tableau Infrastructure include upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general system maintenance.

• Assist users with Tableau development, suggested enhancements to developed reports, and publishing reports to the server with security settings.

• Assist with Tableau server administration, security configuration including setting up AD user groups, permissions, security roles.

• Creating active directory groups, importing them to Tableau server, syncing the groups on daily basis.

• Publishing the reports on server, scheduling workbooks, data sources on server.

• Embedding reports on BI Marketplace which is a common platform to share reports to end users.

• Created Rich Graphic visualization/dashboards to enable a fast read on sales and key business drivers and to direct attention to key area

• Incorporated a regional and national comparative / benchmark metrics to give context to individual performance

• Designed high-level view of the current state of dealer operation, leads, and website activity using Tableau

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report.

Environment: Tableau Desktop & Server 7/8, MS SQL Server, SQL Developer

PL/SQL Developer Client: ZETA INTERACTIVE, Hyderabad, Andhra Pradesh. November 2010 to January 2013

Roles & Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.

• Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, Dynamic SQL and Cursor Variables.

• Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.

• Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.

• Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, and Indexes.

• Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.

• Generated Oracle FORMS and REPORTS using Designer 6i.

• Designed and Developed Reports using Oracle Discoverer 9i.

• Improved Performance of Discoverer Reports using Materialized views.

• Developed UNIX Shell Scripts for Autonomous Jobs.

• Experience in developing logical and physical database design, data modeling using Erwin.

• Provided Productions support and ongoing user support for the application.

• Designed Development Documentation and Support Documentations.

Environment: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, Oracle Application Server 9i and UNIX.

SQL Developer Client: Speck Systems, Hyderabad,Andhra Pradesh August 2008 to September 2010

Roles and Responsibilities:

• Collected business requirements from different sources and wrote the technical specifications for building the Data model.

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.

• Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.

• Interact with internal and external clients to understand requirements, explain issues and prioritize work.

• Created functions, stored procedures, triggers and constraints using T-SQL.

• Developed database structures and SQL queries for web applications.

• Worked with development team to improve application performance by tuning queries.

• Analyzed poorly performing SQL queries to improve application performance.

• Connected to different types of sources to extract data and destinations to load the data using Connection manager.

Environment: SQL Server 2005/2008, SQL Developer, Windows XP, MS Access, MS Excel

Contact this candidate