SUMMARY:

• Over 7+ 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 administration of Tableau Desktop/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.
• 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.
• 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.
• 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, Microsoft SQL Server and Microsoft Analysis Services.
• 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 ware house.
• 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 2018.1/10.5/10.0/9.2/8.0/7.0 , Tableau Desktop, Tableau server, Tableau Reader, Tableau Public

BI/Reporting Tools: Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Crystal Reports, IBM Cognos, Power BI and QlikView

ETL Tools: Informatica, ETL and Reporting Tools

Databases: MS SQL Server, MS Access 2016, Oracle11g, Postgre SQL, Teradata

MS: office suite, MS Visio, Dream viewer

Programming Languages: Java, C, C++, 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, NYC, NY

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.
• 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.
• Developed various reports using SQL for Inventory Management and Innovations team in accordance with Business Strategies.
• Created Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
• Involved in reviewing business requirements and analyzing data sources from Excel/MySQL.
• 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
• 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
• Used SQL tools like Squirrel and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.

Environment: Tableau Desktop (9.x/10.x/2018.x), Tableau Server (9.x/10.x), Teradata, SAS, Flat files, Oracle, SQL, Microsoft Power BI, Microsoft Project 2016, MS Access 2016, Windows 2008 Server.

Senior Tableau Developer

Confidential, Hartford, CT

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.
• 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.
• Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.
• Setup trusted authentication in Tableau server and pass requests from Web server.
• Setup user security for the entire landscape to facilitate Windows AD login.
• Worked heavily 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 (9.x/10.x/2018.x), Tableau Server (9.x/10.x), Tableau Reader (9.x/10.x), IBM Cognos, Crystal Reports 2008/2011, SQL Server 2005/2008/2012 , Windows 2007 server, MS Access

Tableau Developer

Confidential, Louisville, KY

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD).
• Deep experience with the design and development of Tableau visualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.
• Configured different data sources using Tableau Desktop.
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Configured AD security using tableau server.
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop 7/8, Tableau Server 7/8, MYSQL Server, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, Toad, MS Office 2013, Visual Studio 2010.

Tableau Developer/ Data Analyst

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 like Spot fire, QlikView, and OBIEE 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 .
• As a Site Level Admin created Project folders & assigned permissions for respective Active Directory groups.
• 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 9.0/8.3, Tableau server, SQL developer, Data Stage, Toad, Windows Server 2012, Windows Server 2012, Microsoft office 2013, MS SQL Server 2012, Agile, Microsoft Excel 2013

Tableau Developer

Confidential

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Used Data Blending, groups, combine fields, calculated fields, aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated the tableau reports to other portals.
• Provided reporting solutions for OLTP and OLAP systems.
• Published Workbooks and Dashboards to the Tableau server.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau Desktop 7/8, Tableau Server 7/8, SQL Server 2008 Enterprise Edition, T-SQL, Excel, Windows Server 2012, MS Excel/Access 2010IBM Cognos, Visual Studio.

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.

Environment: Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005, SSRS.