SUMMARY

• Over 7 years of experience in IT Industry. Expertise in the field of Business Intelligence (BI) Analytics, Reporting & Dashboard development using Tableau.
• Experience in gathering Business requirements, Analysis, Design, Implementation, and documentation of various functionalities of Data marts and Business Intelligence.
• Hands on experience in following the SDLC methodologies like Waterfall model and Agile model.
• Deep technical knowledge of both Tableau Desktop and Tableau Server from an administrative and a consultative standpoint
• Strong experience inData warehouse, ETL, and PL/SQL concepts.
• Have very good working knowledge on Java Scripting and SQL stored procedures.
• Extensive Experience in analysis, modeling, design, and development of Tableau reports and Dashboards for analytics and reporting applications
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts and publishing them totableauserver andtableauOnline.
• Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
• Mastered in different formatting techniques, using Annotations and Mark Label.
• Developed effective and interactive Dashboards using Parameters and Actions. Setting the user permissions inTableauServer.
• Worked on creating the Alteryx workflows to trigger Tableau data sources.
• Experienced in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries. Experienced in writing complex - SQL Stored Procedures and constructingTables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.
• Proven Experience in performance tuning and optimization of SQL queries
• Have exceptionally good working knowledge on SQL stored procedures.
• Experience in developing and debugging Stored Procedures and Triggers.
• Significant knowledge and experience in various Database Systems MS-SQL Server, Oracle, Sybase, DB2, Middle-Tier systems like Informatica and Java applications
• Involved in the Creation of Key Performance Indicators for an Organization and evaluated the performance of the Organization using KPIs in Tableau.
• Proficient in designing and deploying rich Graphic Visualizations with Drill Down and Drop-Down menu options using Tableau.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Working knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing, and processing, writing data extract scripts/programming of data conversion, and researching complex data problems.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables
• Good independent/team working skills and experiences, excellent communication skills and Self-motivated team player with strong problem-solving skills and thirst to learn the advanced concepts within the field of interest

TECHNICAL SKILLS

Programming Languages: JavaScript, SQL, PL/SQL, XML databases: MS-SQL Server, Oracle, Sybase, DB2

DBW Tools: Tableau (Desktop/Server), Business Objects, SAP BI, Alteryx

Operating Systems: Windows XP/7/8/ Vista, UNIX, Linux

Source Control: SVN, GIT, BIT BUCKET

Methodologies: Agile, Waterfall

Other Tools: Oracle SQL Developer, Toad for Oracle, Toad Data Point, SQL Loader, Informatica power center, DataStage, Soap UI Pro, AutoSys, JIRA, HP ALM, Jenkins, ETL

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr Tableau Developer/Admin

Responsibilities:

• Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
• Effectively utilized features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products.
• Involved in the Data warehouse, Data modeling based on the client requirements.
• Designed standardized Data Mart with aggregated data, calculated metrics to suffice the source data need for variousTableauReports and worked with ETL, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
• Built a single page application on React Native that made the end users as a portal with one stop shop to browse through the report building, publishing customized interactive reports and dashboards, report scheduling using Alteryx in Tableau Server.
• Worked on creating the Alteryx workflows to trigger Tableau data sources.
• Integrated Tableau Dashboards on the single page application with the help of JAVA Script API.
• Worked in Production Support Environment QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Managed a repository of re-usable data visualization templates and views.
• Supported Activities to document, evolve, and communicate artifacts developed using Tableau.
• Automated key reports using Tableau and it is used by Executives of the Organization.
• Documented, Implemented, and deployed tableau server on Windows, and TSM commands
• Extensively worked on metadata inTableaudesktop to modify data types, rename fields, joins, refresh data and change extract data options to prepare data sources to be used by users.
• CreatedTableauscorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts and publishing them totableauserver andtableauOnline.
• Created complex formulas and calculations withinTableauto meet the needs of complex business logic.
• Extensively used SQL in data profiling, modelling, and mining of data.
• Experience in using tabadmin tools and tabcmd for setting up security profiles for various user groups and users.
• Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Used advance features of Tableau like to link data from various sources merged on one dashboard and to filter data in multiple views at once.
• Created different views in workbook to visually analyze the data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.

Confidential, Jersey City, NJ

Tableau BI Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Implemented Tableau BI Dashboard as per the client requirement by using custom queries and multiple tables.
• Responsible in giving permissions to the new sites, create site admins, number of users per site and explaining basic knowledge of tableau server.
• Creating interactive dashboards with the related views as per client requirements.
• Published data sources, data extracts, worksheets, and dashboards into Tableau server.
• Scheduling the data extracts published to Tableau server.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Created Labeling & annotations, data blending, data extract publishing & applying filters, actions, quick filtering, hierarchies, conditional formatting, and dual axis graphs.
• Used SQL joins for joining different tables.
• Created SQL scripts and complex queries for data analysis and extraction.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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 for on demand needed information.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Confidential

Jr. Tableau Developer

Responsibilities:

• Extensively participated in discussions of BI team with business team and BA to get requirements.
• Involved in enhancements for existing dashboards by optimizing the workbooks.
• Created a Supply Chain Dashboard usingTableauin which the Order Booking and Shipments were visualized at each step.
• Validated data by comparing the data with different data sources using EXCEL and fixed the data issues.
• Created user training documents to educate the Users to make the use ofTableauDashboards effectively
• Extensive use of SQL queries for loading data and creating data extracts.
• Analyzing the customer retention details based on regions and customer segments using bar charts and tree maps.
• Worked on various internal projects for different departments like QA and Sales Team
• Organized user demos onTableauserver features like printing workbooks and email subscriptions
• CreatedTableauworkbooks using Oracle as data source. Performed tuning of SQL queries to optimize the dashboards.
• Created dashboard-using parameters, sets, groups, and calculations. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets inTableau.