SUMMARY

• Tableau Developer with 9+ years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applications and the related Database Platforms.
• Extensive experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 7.x/8.x /9.x/10.x (Desktop, Server, Reader, Mobile) as a Developer and Analyst.
• Subject matter expert (SME) in Tableau
• Worked on SAP Business Objects (BOBJ), Tableau and SAP BI reporting applications for Wolters Kluwer Managerial Services.
• Experienced Hadoop Developer, have a strong background with file distribution systems in a big - data arena. Understands the complex processing needs of big data and have experience developing codes and modules to address those needs.
• Well versed in installation, configuration, supporting and managing of Big Data and underlying infrastructure of Hadoop Cluster along with CDH3&4 clusters.
• Real time experience in Hadoop/Big Data related technology experience in Storage, Querying, Processing and analysis of data.
• Certified in Tableau.
• Strong knowledge of Business/Process Data flow in organizations and experienced in data modelling concepts.
• Work experience in Tableau 10.x, 9.x & 8.x, Informatica Power center 9.x and SSIS.
• Strong expertise in end-to-end Tableau Designing from dashboard design/development to deployment/maintenance.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experience with TABCMD and TABADMIN
• Good experience with Tableau administration as well.
• Experience in Data Analytics, Reporting and ETL development & Support.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies,
• Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
• Extensive experience with Tableau: reporting and administration
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Experience working with Extracts, Live datasets, managing access privileges
• Expertise in SQL quires.
• Good understanding of Database and Data warehousing concepts.
• Trained 70 People on Tableau Visualization and Data Warehousing concepts.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, MicroStrategy, SSRS, Informatica and Alteryx.
• Developed Power Shell Script, which naturally makes PPT out of the Tableau Server and Send it to Business Users.
• Worked on tableau python Libraries like tabdocumentapi, tableauSDK to automate the Tableau Administration and Documentation activities.
• Worked on Integration of SQL Server, Power Shell, and Postgre SQL to develop Dynamic Scripts.
• Working on JavaScript to make the Tableau administration activities easy.
• Working on tabdocumentapi that helps to create the tableau technical document easy with single Click.
• Mentored business power users to create reports/dashboards using tableau desktop.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop v7.x/v8.x/v9.x/10.x, Tableau Server v7.x/v8.x/9.x/10.x, Power BI, Qlikview, SAP BW 7.0

Databases: SQL Server 2014, Oracle 11g, Azure SQL Server, Redshift. Hadoop HIVE, MongoDB

ETL Tools: Informatica, SSIS

Programming Languages: SQL, PL/SQL, HTML, PowerShell, Java script and UNIX shell script

PROFESSIONAL EXPERIENCE

Confidential, San Diego, California

Sr. Tableau Developer

Responsibilities:

• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developing Standard and Create reports using Tableau Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Built various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time
• Created Tableau Reports for the different Modules to help the business to take Critical Decisions.
• Building the customized and interactive tableau dashboards using multiple data sources
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. creating and managing extracts
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Using TABCMD and TABADMIN
• Created worksheets and dashboards by using custom queries and multiple tables.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Creating DB views for the reporting purpose.
• Managed relationships with senior business stakeholders to ensure the effective capturing of business requirements and commitment to project objectives.
• Made my own content, which diminish the Man endeavors for minimizing the Tableau Workbooks from Higher Version to Lower Versions.
• Developed a Python Script, without the accessibility of Tableau server, information refreshing will happen consequently alongside Security.
• Developed Power Shell Script, which naturally makes PPT out of the Tableau Server and Send it to Business Users.
• Worked on tableau python Libraries like tabdocumentapi, tableauSDK to automate the Tableau Administration and Documentation activities.
• Worked on Integration of SQL Server, Power Shell, and Postgre SQL to develop Dynamic Scripts.
• Working on JavaScript to make the Tableau administration activities easy.
• Working on tabdocumentapi that helps to create the tableau technical document easy with single Click.

Confidential, New York City, NY

Sr. Tableau Developer

Responsibilities:

• Developed various dashboards illustrating data visualizations using Tableau Desktop
• Installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Preparing Report Mapping Documents as per Specifications.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Defined best practices for Tableau report development.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• PerformTableauServer admin duties; add users/groups from Active Directory; instances in Tableau Server..
• Implemented action filters, parameters, calculated filed and set for preparing dashboards andworksheets inTableau.
• Effectively used data blending feature in Tableau.
• Created different Action filters, Parameters and calculated fields to create most complicated dashboards.
• Worked with Tableau administrator in managing Production, Test and Development environments.
• Used data blending feature in tableau and defined best practices for Tableau report development.
• Created report on Cloud based environment using Amazon Redshift and published on Tableau Online.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau
• Desktop to validate static and dynamic data for data validation.
• Created SharePoint site to store all tableau workbooks and data source.
• Published Packaged workbooks.
• Prepared and published customized reports/dashboards.
• Converted SSRS and Microstrategy reports into Tableau.
• DevelopedQVDashboards using various Chart types (straight, pivot, bar, Pie, gauge, combo, List boxes, Input Field, Table Box, sliders).
• Developed Geo/Area Maps to show details on which states have most sales vs. the least sales.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Converted Pearl Script Query in to SQL Query for ETL.
• Created reports in Tableau using SSRS SQL Queries and Stored procedures.
• Created reports using Custom SQL for complex report views.
• Executed and tested required queries and reports before publishing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Confidential

Tableau Developer/ Data Analyst

Responsibilities:

• Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different data sources.
• Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Understanding of relational database structures, theories, principles, and practices.
• Monitored Application Server and Tableau Data server activity to track performance and system availability
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Worked with Tableau administrator in managing Production, Test and Development environments including installation of patches, security administration and access controls in Tableau
• Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, SQL Server 2008.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA's with Tableau support.
• Developed proof of concept for best practices in Tableau development & deployment, and ad-hoc reporting.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Building, publishing customized interactive reports and dashboards using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

Confidential

Business intelligence Developer

Responsibilities:

• Worked closely with business stakeholders to define requirements to support strategic and tactical decision-making.
• Developed reports, dashboards using Tableau for quick reviews to be presented to Business and IT users.
• Analyzed backend data from SQL Server and Oracle create effective dashboards.
• Created Tableau Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, and Shared Encoding) using Tableau Desktop.
• Gathered Business requirements, translated them to work items and delivered on time, on budget - meeting Business expectations.
• Worked across organizational boundaries, identified business information needs, and implemented applications that fulfilled them.
• Prepared Use cases and look and feel documents and were reviewed with end users.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Created actual sales and target sales view with Trend lines, table calculations to see the difference between each quarter.
• Coordinated and facilitated end user acceptance testing.
• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Data blending implemented on databases and generated interactive dashboards.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generate Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• Generated tableau dashboards with combination charts for clear understanding.
• Created Workbooks and Projects, Database Views, Data Sources and Data Connections.
• Designed dashboards servicing all business segments.
• Applied communication, analytical and problem-solving skills to help maximize the benefit of system investments.
• Prioritized customer issues properly and communicated updates as appropriate. Used good judgment to determine problems that needed escalation.
• Worked across organizational boundaries, identified business information needs, and implemented applications that fulfilled them.
• Managed multiple issues in a fast-paced environment.
• Created Tableau Admin Insights, which help users to understand the background process of Tableau Server like Licensing, Space usage, Time stats, Load stats etc.,
• Created Relative Time dimension in Tableau.

Confidential

Data Analyst/ Business Systems Analyst

Responsibilities:

• Analysed the business requirements of the project by studying the Business Requirement Specification document.
• Revisited the business rules and redefined many attributes and relationships in the model and cleansed unwanted tables and columns as part of Data Analysis tasks
• Created a logical design and physical design in Erwin.
• Maintained security and data integrity of the database
• Identified the business function activities and processes, data attributes, and table metadata, and documented detailed design specifications
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Extensively used Erwin for developing data model using star schema methodologies.
• Created Entity relationship diagrams (ERD), Function relationship diagrams(FRD), data flow diagrams(DFD) and enforced all referential integrity constraints using Erwin data modeling tool
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Good knowledge and experience on Global Custody operations, capital markets, securities services, vendor management operations, trade finance, trade settlements, income processing, tax, corporate actions, market claims and reconciliations, NAV generations.