SUMMARY:

• Around 6 years of experience in Designing, Analysis, Development, Implementation and Management in Business Intelligence data visualization tools with specialization in Tableau.
• Experience in working with Tableau Desktop, Tableau Server, Tableau Online, and Tableau Reader in various versions of Tableau 2018.1, 10.5/10.4/10.0/9.2/9.0/8.2/8.0 as a developer and administrator.
• Extensive experience in Installation, configuration, upgrade and administering Tableau Desktop and Tableau Server
• Combined multiple data sources using data blending in Tableau to keep track of sensor data, operator inputs, and real - time systems all in one dashboard.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-down menu option and Parameterized views using Tableau.
• Expertise in end to end Business Intelligence (BI) implementation including creating BRD's, loading data to Datawarehouse and Create Tableau Reports and Dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 9.0 to 10.0 and Tableau 10.0 to 2018.1
• Experience in creating, generating and maintaining highly interactive Tableau Dashboards, Tableau Scorecards, and Reports using Stack bars, Bar graphs, Line graphs, Scattered plots, Bubble charts, Pie charts, Histograms, Geographical maps, Heat maps, Bullets, Gantt charts and Highlight tables using show me functionality.
• Hands-on experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets, facts, attributes, transformations, filters, prompts and hierarchies in Tableau
• Worked with Extracted Data Sources and Live Connection Sources.
• Proficiency in Scheduling, Publishing and Distribution of reports.
• Experience in the maintenance and scheduling of Tableau Data extracts using Tableau server and the Tableau Command utility.
• Writing T-SQL queries in SQL Server, AWS Redshift environment.
• Knowledge in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Physical and Logical Data modelling.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Experience in data extraction and integration, data modeling and data rendering, cross database joins and unions in Tableau.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, and Microsoft SQL Server.
• Strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving Key Performance Issues.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflakes modeling, fact and dimension tables modeling of data
• Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/ analysis, design, development, testing and production rollover.
• Experience in Informatica (ETL) tools which is widely used in building enterprise data warehouse.
• Experience working in Agile, Waterfall and Scrum project management methodologies.
• Participate in the user requirement gathering and Design meetings.
• Highly proficient in understanding the complex applications and making enhancements as per client requirements with creative ideas.

TECHNICAL SKILLS:

Tableau: Tableau Desktop 2018.1/10.5/10.0/9.2/8.0/7.0, Tableau server, Tableau Reader, Tableau Public, Tableau Online

ETL Tools: Informatica, Five Tran

Databases: MS SQL Server, Oracle11g, PostgreSQL, Teradata, Amazon Redshift

Programming Languages: SQL, TSQL, PL/SQL

Scripting Languages: Python, HTML5, CSS5, JavaScript

Operating Systems: Windows XP/7/8/10, Mac, UNIX

Methodology: Agile Methodology, Scrum Model, Water fall method.

PROFESSIONAL EXPERIENCE:

Senior Tableau Developer

Confidential, SFO, California

Responsibilities:

• Interacting with Business Architecture and Reporting Manager, gathering the requirements according to client needs.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Collaborate with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Strong understanding of Data Warehouse concepts, Star Schema , Snowflake Schema , Business Process Analysis, Physical and Logical data modeling.
• Built functionalities by writing condition to in corporate with various metrics and hands on experience in Level of Detail Expressions (LOD’s) such as Daily profit KPI, Percent of total, yearly trending analysis and root cause behavior.
• Writing complex SQL queries on Teradata handling source data challenges and adapting to the dynamic nature of the project.
• Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Involved in reviewing business requirements and analyzing data sources from Excel.
• Designed and deployed interactive reports with Drill Downs, drop down menu option, Parameters and Linked reports using Tableau
• Built reporting against Single, Multiple Tables, Views and Complex Custom SQL
• Worked with business partners and BI engineers to rigorously define, implement and further develop metrics and key performance indicators.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, and parameters.
• Scheduled data refresh on Tableau Server for Daily/weekly/monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Develop parameter-based reports, drill-down reports, charts, and Tabular reports using Tableau Desktop.
• Migrated all dashboards from Tableau 9.3 to 10.3 and 10.5 to 2018.1

Environment: Tableau Desktop (9.x,10x, 2018.x), Tableau Server (9.x,10.x, 2018.x), Teradata, SAS, Flat files, Oracle, SQL.

Tableau Admin/Developer

Confidential, Seattle, WA

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Setup and configuration of Tableau server 9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server per best practices.
• 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.
• Related views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Setup trusted authentication in Tableau server and pass requests from Web server.
• Gathered Business Requirements by interacting with Business Users, Project Manager and SMEs.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
• Used various Data models as source for reporting including Dimensional Data Model, Star Schema model, Fact, Measures and Dimensions tables, and Transactional and Logical data models.
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Cognos Reports into Tableau Dashboards.
• Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Function as a mentor/lead and provided training to less experienced staff, and assist in designing and development of ad hoc reports for all team members (onsite and offshore)
• Setup user security for the entire landscape to facilitate Windows AD login.
• Worked on using Tab-admin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Worked on Setting up Tableau Server on AWS.
• Actively involved in the Server migration and the Tableau Server Installation process.
• Implemented pivot/un-pivot, transpose features of Power BI to load data into excel Power Pivot.
• Used Elastic Load Balancing to distribute requests across multiple gateways in a Tableau Server cluster.
• Creating users, groups, projects, Data Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.

Environment: Tableau Desktop (8.x/9/x), Tableau Server (8.x/9.x), Tableau Reader (8.x/9.x), SQL Server 2005/2008/2012, Windows 2007 server, MS Access

Tableau Developer

Confidential, Tampa, FL

Responsibilities:

• Responsible to Create Dashboards for compliance reports, treasury reports, Daily P&L reports for Client and internal management using Tableau Desktop and Server.
• Involved in migration reports from various reporting tools Excel to Tableau.
• Involved in migration reports from Oracle BI Publisher to Tableau. And involved in Data extraction and transformation to Oracle BI to Tableau.
• Implemented Installation of Tableau Desktop 9.0/8.3 and Tableau Server.
• Used Trend Lines, Reference Lines and Annotations to describe the data. Created Data extracts for better performance and accessing data offline.
• Had good knowledge and experience in Data Modeling. Used parameters and input control to give users control over certain values.
• Worked extensively on setting up groups, roles and user permissions in Tableau Server .
• Managed the application’s users, groups, and integration with Active Directory.
• Experience in taking backups and restoration of Tableau repository.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created complex calculation using Table Calculation, Date, Aggregate functions in Tableau.
• Providing support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Assisting QA team in creating Test Cases, Test Scenarios and working closely with QA team in managing all the reported defects.
• Working closely with the Business teams in organizing Training for UAT Sessions and assisting business teams to write use cases throughout UAT Phase.
• Assist managers in meeting client expectation by monitoring timely delivery of daily, weekly and monthly deliverables.
• Involved in integration of Tableau JavaScript API Filters in web application.
• Basic understanding of financial instruments, accounting concepts, Hedge Fund Industry.
• Prepared financial statements for all funds on the monthly, quarterly, and yearly basis.
• Publishing Reports, workbooks & data source to the server and export the reports in different Formats.
• Effective oral and written communication. Ability to engage meetings/calls with clients/counter parts in other groups.

Environment: Tableau Desktop 8.3, Tableau server 8.3, SQL Server 2012

SQL Developer

Confidential

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows server 2003 server.
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Support and maintained database clustering.
• Configuring, tuning and optimizing SQL Server 2000.
• Administer tasks like managing users, roles and permissions.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS packages for data import/export and scheduling jobs for backups.
• Creating database maintenance plan for performance of SQL Server, which covers database integrity checks, update database statistics and re-indexing.
• Maintained high availability of database using Database Mirroring and Log Shipping .
• Job monitoring and make sure all jobs running successfully at night.
• Performed level scripting, fixing of codes and software enhancement process.
• Worked with linked servers and distributed transactions.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Involved in cubes using SQL Server Analysis Services.