SUMMARY:

• Over 4+ years of IT experience as a Tableau Developer in various Industry verticals like Health Care, Finance, Insurance, and Service. Maintained positive communications and working relationships at all business levels.
• Experience in Tableau Desktop/Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Data Blending, and Maps etc.,
• Hands - on experience in creating solution driven dashboards by developing different chart types including Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experience in MS Access Support, Hadoop, Big Data.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Experience in creating different visualizations using Bars, Lines, and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report.
• Experience in Installation, Configuration, and administration of Tableau Server in a multi-server and multi-tier environment.
• Extensive experience in building Interactive dashboards using Tableau.
• Involved in upgrading Tableau platforms in a clustered environment and performing content upgrades.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms.
• Expert in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in developing and modifying cubes using SSAS and transform into the pivot table.
• Expert in developing Drill through and Drill down reports using Crystal Reports, Informatica, MS SQL Server Reporting Services (SSRS).
• Quick learner, excellent communication skills, and good performer both in the team and independent job environments. Never missed the deadline for any projects.

TECHNICAL SKILLS:

Reporting Tools: Tableau, Business Object Suite Business Objects BI 4.0, SAP BW, Web I XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client (3.1), Supervisor, Broadcast Agent, Info view, Crystal Reports Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2.

Databases: Oracle SQL Server Sybase, Teradata, MS Assess, DB2.

Data Modeling Tools: ER Studio, VISIO, Dimensional Data Modeling (Star Schema, Snow-Flake, FACT Dimensions), ERWIN iGrafx.

Languages: SQL, PL/SQL, C, C++, JAVA, J2EE, HTML, XHTML

Operating systems: UNIX, LINUX, Windows 98, XP, 2008/NT.

Application Servers: Web Logic, Web Sphere, Tomcat.

Software Packages: MS OFFICE

PROFESSIONAL EXPERIENCE:

Tableau Developer/Data Analyst

Confidential - SFO, CA

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL
• Server for design, development, Performance testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views/reports 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 was broken into regions allowing a business user to understand where we have most users vs. least users.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Created Trend Lines and changed the formatting of the dashboard.
• Created Bar charts and tableau Reports as per the business Requirement and created the own template by pulling the table or view from vector wise.
• Gave permissions to specified Business users to access the Reports.
• Replace the data sources by adding the flat table for improving the performance on tableau side
• Publish the workbooks on QC and Production Server.
• Worked on SQL Server development including writing T-SQL Queries and creating SQL Server objects like Stored Procedures, User-defined Functions, Views, Triggers, implementing T-SQL relational database models and data integrity
• Used Parameters and Calculation to build the report.
• Edit the Alias and Replace the References.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advanced features of Tableau software like to link data from Actian Vector together on one dashboard and to filter data in multiple views at once.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• 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 SQL Server and MS Excel.

Environment: Tableau Desktop/Server 10.1, 10.3, 10.5Actian, Oracle.

Tableau Developer

Confidential -The Woodlands, TX

Responsibilities:

• Gathered requirements from end users, involved in modifying various technical & functional specifications.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advanced features of Tableau software like, to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Wrote complex TSQL/PL SQL queries to get data from different sources and test results with expected results.
• Assisted in installation and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Using Tableau JavaScript API for performance improvement of the web page.
• Filtering Views in the dashboards Using Javascript API.
• Extracted large data to Tableau from Amazon Redshift to analyze visualize and share information.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins and security checks.
• Data collection and leveraging on data manipulation teams for required data.
• Identify new metrics and enhance the existing KPI's.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Scheduled frequency and time to refresh data for when sources are published or extracted to the server.
• Proof-read all documents and maintain the accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing Ad-hoc Reporting.

Environment: Tableau Desktop 8.1-8.2, Tableau server / Administrator, SQL developer, SQL 2008, Oracle 10g, PL/SQL, T-SQL Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007, Business objects 4.0, Amazon Redshift.

Tableau Developer

Confidential

Responsibilities:

• Created Dashboards for various fields like Consumer Banking & Credit Cards for reporting purpose.
• Created Dashboard to analyze the trends for Market, Region and Branch wise for the Regional Manager to interact and filter on a branch in the Dashboard.
• Enhanced the dashboard with nested sorting feature, and URL links to apply the lock filter on a specific product and navigate around the dashboard.
• Published data sources & 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.
• Participated in meetings, reviews, and user group discussions and business groups for data driven decision requirements to create multiple Dashboards and being able to navigate from one Dashboard to another.
• Customer satisfaction is at the top priority, which includes having consistent communication and providing them with a variety of customized reports.
• These reports measure the performance against the predetermined quality specifications. Once the customer’s reporting needs understood, the reports produced according to the customer’s requirements.
• Created Scatter Plots, Box Plots Graph for customer detail dashboard with filters applied for top customers.
• Using data blending between multiple sources created Donut, Bullet, Bar in Bar graph for comparing Target Goals with Actual.
• Done Map enhancements like dynamic size and auto zoom were created and filtering through Map to Dealer city and customer city were used to analyze a Dealership or customer.
• Coordinated with data analysis process, writing queries in SQL, joining tables, pivot tables in Excel for the early process of connecting to data in Tableau.
• Solved Performance issues on Executive Business Dashboards to increase the speed for filtering on the Dashboard.

Environment: Tableau 9.x, Windows 7 SP1, Microsoft Excel 2010, Microsoft Access 2010, SQL Server

Tableau Developer/ Admin

Confidential

Responsibilities:

• Worked closely with Client Services/Finance/Fraud & Risk team to gather requirements for designing the Data warehouse model.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Responsible for creating Metrics, Filters, Calculated fields, Parameters using Tableau Desktop.
• Develop reports, dashboards using Tableau 8.3 for quick reviews to be presented to Business and IT users.
• Developed UNIX and PL/SQL scripts for pre-& post session processes to automate daily loads.
• Worked with Modelers and Architects for table issues.
• Worked on building Mappings, Mapplets.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Prepared detailed documentation for development, Test cases, testing different scenarios and documenting the result, working on defect fixes from System Testing & User Testing.
• Hands-on learning with different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Tested ETL code in Dev. SIT & UAT environments to ensure defect free code.
• Provided Development support for System Testing/User acceptance testing.
• Migration workbook creation and tracking the code versions.
• Worked on Performance tuning of the report with huge queries using concurrent query execution for better performance of the report.

Environment: Tableau 7.2, 8.2/8.3, Tableau Server/Administrator, Teradata SQL Assistant, Oracle 11g, Agile-Scrum, MS VISIO, Microsoft Office Suite. MS Excel 2007, MS Access, JQuery, JavaScript.