OBJECTIVE:

• Seeking for a challenging role as a Tableau Developer in a prestigious company and exploit my skills in Data modeling, reporting, Visualization and Business Intelligence skills in meeting company's goals and Objectives.

SUMMARY

• 6+ years of Experience in Tableau and Data warehousing applications within various domains like Networking, Retail, agriculture, Healthcare, Production at client locations.
• Tableau Desktop Qualified Associate with Extensive Tableau Knowledge in Enterprise Environment that includes 8.x/9.x/10.x versions as both developer and Administrator.
• Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public.
• Experience in determining the requirements of the business, users and produced the workflow process and diagrams with the help of Microsoft Visio and other Microsoft applications.
• Involved in all phases (SDLC) of the project from planning, requirement gathering, design, develop, test and implementation.
• Developed compelling, Interactive Dashboards using different features like Filters, Parameters, Actions, Calculations, Sets, Groups, Aggregate functions.
• Experience in relational databases like Oracle, Teradata, MS Access, Netezza, SQL Server, Informix
• Expertise in writing SQL Queries, updating complex stored Procedures in PL/SQL & T - SQL, User-defined Functions, Views, Cursors and Triggers.
• Extensive experience in database tuning, query optimization resolving key performance issues to reduce the turnaround times between tableau and databases.
• Developed and implemented solutions leveraging the Alteryx Designer Desktop, Alteryx Server and Alteryx Scheduler including process documentation and training clients on theory of operation.
• Experience in managing Repository, cleansing data Sources, Target Databases and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Configured the tableau server to use active directory authentication so the client s users could directly log in.
• Experience with different SQL server BI tools SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) with good knowledge in SQL Server Analysis Services (SSAS)
• Ensured dashboards on development met production standards and trained the business users on driving for self- analysis using tableau.
• Created relationship between two different Data Source's by using Data- blending.
• Implemented indexes on tables and views for optimum performance tuning.
• Extensive experience in creating Tableau scorecards to measure KPIs, Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, pie charts, cross maps, Heat maps and density charts.
• Improved Reports performance in tableau using Alteryx extracts.
• Good understanding of Tableau Desktop architecture for designing and developing dashboards.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed test plans and scripts, prepare test data, reconcile data sources and execute functional tests.
• Build relationship with Technology partners. Support communication and cooperation between the teams.
• Expertise as tableau server admin involves User creation, Users Addition to Group, Editing & Deleting Users and Activating Licenses, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Created incremental refreshes for data sources on Tableau server.
• Used Alteryx for Data Engineering and Tableau for reporting
• Extensively involved in Reverse-Engineering and Business rules extraction in project planning, strategic planning, systems analysis and troubleshooting, quality control, scheduling and planning and tracking of results.

TECHNICAL SKILLS

BI tools: Tableau (Desktop & Server) 10.x/9.x/8.x, Alteryx 11.x, R, Power BI, SSIS/SSRS/SSAS

Business Analysis: Requirement analysis, data flow diagram, flowcharts, business process modeling & improvement, functional requirement Analysis, source to target mappings, gap analysis, cause and effect analysis, decision tree.

Methodologies: UML, Agile Modeling, SDLC model, Waterfall model, Spiral model, Use Cases

Office Suite: MS Office, MS Excel, MS Word, MS Visio, MS Project, Outlook, Open Office

Programming: C, C++, Java, SQL, T-SQL, PL/SQL, HTML, VB Script

Databases: MS Access, MySQL, SQL, PL/SQL, Teradata, Netezza, DB2, Oracle 11g/10g/9i, SQL Server 2012/2008/2005

Operating Systems: Windows, Linux, Unix, Ubuntu

Data modeling: ER Diagrams, Conceptual, Logical & physical modeling.

ETL Tools: Alteryx, Talend, SSIS, Informatica

Scripting Languages: JavaScript, jQuery, Python, PERL, HTML

Tools: and Packages: SQL*Plus, SQL * Loader, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Senior Tableau Developer

Environment: Tableau (Desktop/Server), Teradata, Teradata SQL Assistant, Oracle 12c, Toad, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), O365 share point, OneDrive, Webex Teams

Responsibilities:

• Analyzed the business requirements, identifying the requirements, reviewing and communicating with business and getting sign offs from business.
• Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Tableau.
• Upgraded Tableau server from 8.0 to 9.0 in DEV and QA along with Migration of reports.
• Prepared Tableau reports in various subject areas like Materials Procurement Savings, Bill of Materials, Customer Service Index, Employee Productivity and Employee Safety.
• Played critical role in establishing Best practices for tableau reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
• Connected Tableau server with SharePoint portal and setup auto refresh.
• Worked closely with the ETL Team to automate the Data load process, create required aggregate tables, indexing and table portioning for performance optimization of Reports.
• Worked on understanding of relational database structures, theories, principles and practices.
• Wrote Custom SQL scripts for creating aggregate tables and generating views.
• Effectively used data blending feature in Tableau to integrate different database tables.
• Designed and developed various analytic reports / dashboards using Tableau.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Dual Water Fall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems. Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
• Built Excel, Qlik View and Domo reports in Tableau. Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Resolved various performance issues and analyzed the best process distribution for different projects. Assisted power users in Tableau dashboard development.
• Documented all Development/ Enhancement activities as a part SOX controlled mechanism.

Confidential, Plano, TX

Tableau Developer

Environment: Tableau(Desktop/Server), PL/SQL, Oracle 12 c, Teradata 16.x, web Intelligence Rich Client, MicroStrategy Developer, MicroStrategy Web, ServiceNow, IDM, Universe design Tool, Information Design Tool, O365 share point, OneDrive, Microsoft Teams

Responsibilities:

• Collect and analyze customer requirements for designing/enhancing Webi Reports and Tableau Dashboards.
• Created the data model to understand the relationship and structure of database tables.
• Extensive analysis of PL/SQL to understand the functionality of MSTR reports/dashboards.
• Hands on Programming skills in SQL, PL/SQL.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Provided Tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters.
• Worked on Creating various plots and drill down analysis using Tableau desktop. Worked on scheduling reports, managing data sources and refresh extracts.
• Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau.
• Generated Tableau dashboards with combination charts for clear understanding.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards in web.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Lead my team following Onsite-Offshore model
• Documented all the steps of migration and Submitted the POC.

Confidential, St Louis, MO

Tableau Developer

Environment: Tableau 10.4, SQL Server Management Studio, Oracle 10g/11g, Toad, Stored Procedures, Functions and Triggers, PL/SQL, SQL Develop

Responsibilities:

• Interacted with business users for gathering requirements of the applications to be developed.
• Developed detail technical requirements based on the business requirements
• Participated in weekly design reviews and walkthroughs with the project manager and client
• Worked on multiple databases and created powerful cross joins to report all metrics on one platform.
• Creating stored procedures and some complex queries to embed this in SSRS reports.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front- end application.
• Implemented indexes on tables and views for optimum performance tuning.
• 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
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, sizing and layout, data emphasis, highlighting, color, fonts, tooltips, and performance improvement.
• Performed performance tuning on desktop and tableau server to understand the slow performing dashboards and made enhancements to improve the speed for better user experience

Confidential, Pleasanton, CA

Alteyx/Tableau Developer

Environment: Tableau 10.2, Alteryx 11.x, Oracle 10g/11g, SQL*Plus, Toad, Stored Procedures, Functions and Triggers, PL/SQL, SQL Developer, SQL Server, T-SQL, Microsoft Excel, Power BI.

Responsibilities:

• Involved in reviewing business requirements and analyzing data from Excel, Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects in both Tableau and Power BI.
• Planned and executed business analysis of large data sets, analyzing and interpreting collected data to meet business requirements in Alteryx ETL environment.
• Access, blend, and cleanse data from multiple sources using Alteryx.
• Designed daily and monthly KPI's for productivity and created an end to end workflow in Alteryx to report these metrics through tableau
• Created large data extracts using in database Alteryx tools.
• Performed ETL jobs and schedules using Alteryx scheduler to have automated process.
• Blended data from multiple databases by selecting primary keys from each database for data validation.
• 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.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Reviewed SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations
• Actively participated in clarification meeting with the Clients and educated on interactive usage of dashboards to get powerful insights from data.
• Generated SQL and PL/SQL scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in writing PL/SQL Packages, Functions and Stored Procedures and Data Base Triggers

Confidential

ETL/Tableau Developer

Environment: Tableau 10.2, Alteryx, Netezza, MS Visio, Agile-Scrum, MS Project, Teradata

Responsibilities:

• Gathered Business Requirements, interacted with the Directors, Project Manager and SMEs to get a better understanding of the Business Processes and analyze the data source Netezza.
• Conducted Gap Analysis, created Use Cases, workflows, screen shots and Power Point presentations for the Web Applications.
• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions
• Created complex dashboards and involved in performance tuning of operational dashboards in Tableau using the various sources of data from the excel sheets, Teradata and SQL server databases
• Designed and Optimized Connections, Data Extracts, schedules for background tasks and data refreshes for the corporate Tableau server
• Built automated data processing & reporting workflows using Alteryx.
• Utilized Alteryx analytics software to process sophisticated cost models and SQL data conversions.
• Developed Alteryx workflows to create optimized and consumable data sources which are then used to develop Tableau visualizations or dashboards that are published, maintained and distributed through Tableau Server
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Managed workbooks across environments, capture and monitor user activity and track the usage trend, report the server performance metrics.
• Evaluated the database performance and performed tuning, backup, restoration and disaster recovery
• Worked extensively with MS Visio and Rational tools to document requirements
• Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Experience with formatting styles including Annotations, Layout Containers, Mark Labels, Rich Text Formatting, and Shared Encoding.
• Developed Complex dashboards and used advance chart visualizations in Tableau like Dual Waterfall charts, Axis, Bullet Graphs, Bubble Charts, etc. to assist business users in solving complex problems.
• Built Complex Reports using advanced reporting functions like with YTD calculations, MTD calculations, percentage differences, sets and groups etc. in Tableau.
• Implemented Donut chart to study Network Health across all regions.