PROFESSIONAL SUMMARY:

• Over 7 years of IT experience as a Tableau, SSRS Developer and Data Analyst in various Industry verticals like Financial Services, Health Care, Insurance Services.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader.
• Skilled in Tableau Desktop for data visualization through various charts such as bar charts, line charts, combination charts, pivot table, scatter plots, pie charts and packed bubbles and used multiple measures for comparison such as Individual Axis, Blended Axis, and Dual Axis.
• Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop - Down menu options and Parameterized using Tableau.
• Developed Donut charts for analyzing sales planning data.
• Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions).
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Worked extensively with Advance analytics like Lines and Bands, Trend Lines.
• Strong Knowledge of Tabcmd and Tabadmin Commands, able to generate log files when required.
• Have been working with various data sources such as Oracle, SQL Server, Hadoop, SAP HANA, ODBC and flat file sources.
• Extensive experience in MS SQL Server, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, Hadoop, DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
• Have good knowledge on Data Modelling concepts.
• Good knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in oracle.
• Maintained positive communications and working relationships at all business levels. Willing to relocate: Anywhere.

TECHNICAL SKILLS:

Programming/Reporting: Tableau Server v7/v8, Tableau Desktop 7/v8/v9/v10, Business Objects 5.1/6.0/6.1a/6.1b/6/ XiR2(central management console), Crystal reports XI/2008, Web Intelligence 2.7/6.0/ XI, Informatica

Database: ORACLE 9i/8i/7i, MS SQL Server 2000/2005, Ms-Access, TOAD.

Operating Systems: MS Windows 2000/NT/98/XP, LINIX, MSDOS, Sun Solaris.

Programming: IBM DB2, HTML, SQL, PL/SQL, XML, Java/J2EE

Software: MS Project, MS Word 97/2016, MS Excel 97/2016, MS Office, MS PowerPoint.

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer

Confidential - Glendale, CA

Environment: Tableau Desktop 8.2, 9.0, 10.0, Tableau Server, DB2, Oracle SQL Server, Teradata, MS Access, CSV files, salesforce data

Responsibilities:

• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Involved in license management SLA's with Tableau support.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Developed views and 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.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Developed reports using multiple measures like Individual Axes, Blended Axes, and Dual Axes.
• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web. Scheduled the published dashboards from Tableau Server on weekly basis.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Combine Data sources by Joining Multiple Tables and using Data Blending.
• Site, Project, User & group creations and permission settings using portal or TABADMIN.
• Analyzing performance issues either in server or desktop by checking logs.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Facilitating Java API, Rest APIs, Web editing, importing Tableau metadata upon request by other projects using DB.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

Sr. Tableau Developer

Confidential, Dublin, OH

Environment: s: Tableau Desktop 8x, Tableau Server 8x, Oracle, SQL Server 2008 R2, MS Excel

Responsibilities:

• Gathering user requirements, analyzing, designing and efforts estimations
• Building executive, adhoc, and custom dashboards and publishing to Tableau server.
• Testing, monitoring performances, cleaning unused dashboards.
• Creating Sites, Groups, Projects using TABCMD & TABADMIN commands.
• Installation and Activating Tableau Ports using TABCMD.
• Conducting kick off meetings, status calls, walk thru sessions and s to business users.
• Created best practices, publishing checklists and repository backups etc.Conducting performance tuning, applying user and data source level securities upon need.
• Conducting POC for tableau server setup for non-existing tableau applications.
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed.
• Executed and tested required queries and reports before publishing.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8.1 desktop/Server.
• Created schedules, Tasks, Groups, Users, Permissions and Subscriptions on Tableau server.
• Effectively used data blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Experience in creating sets, joins, hierarchies, filters, global filters, quick filters, context filters, table calculations, calculated measures and parameters.
• Experience in creating various views in Tableau by different charts such as maps, bars, lines, cross tab, packet bubbles, scatter plot, heat maps and highlight tables.
• Extensively involved in developing the java code using HTML, JSP for the front-end screen development.

Tableau Developer

Confidential, New Brunswick, NJ

Environment: Tableau Desktop/Server 8.0/8.2/8.4, Oracle 10g, MS SQL Server 2008, Windows Server 2012, MS Excel/Access 200, salesforce data

Responsibilities:

• Actively involved in gathering 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.
• Extensively used advanced 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.
• Trained end client users on Tableau Desktop by providing step-by-step guidance from basics to advanced functions in Tableau including working with calculations, parameters, and date functions. Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Created and modified Interactive Dashboards and guided navigation links within Interactive Dashboards. Published the developed dashboard, reports on the Tableau Server for end user consumption. Scheduled extracts on tableau server after the completion of data load into the warehouse.
• Responsible to facilitate load testing and benchmarking the developed product to meet SLA.
• Created Test Cases and documented the Test Results and shared with project team.
• Involved in validating Tableau reports, Dashboard by writing SQL against databases.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Sr. Data Analyst

Confidential

Environment: Oracle 10g, SQL Server 2005, Business Objects XiR2, Informatica.

Responsibilities:

• Interacted with the Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• ConductedJAD sessionsto gather requirements, performedUse Caseandwork flow analysis, outlined business rules, and developed domain object models.
• Created a conceptual design based on the interaction with the functional and technical team.
• Analyzed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system.
• Analyzed, created and formatted the Reports as per Business Requirements.
• Analyzed and created various Adhoc Reports for users based on User Requirements.
• Created both list and drill down reports identifying the data hierarchy.
• Performed report validation writing SQL queries using TOAD on an Oracle database.
• Created process documents, reporting specs and templates, material and slideshow presentations for the application development teams and managements.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Createdand maintained specifications and process documentation to produce the required data deliverables (data profiling, source to Client maps, flows).

SQL Developer

Confidential

Environment: SQL Server 2005/2000, T-SQL, SSIS, SSRS, SSAS, DB Artisan, Management Studio, Query Analyzer, Windows 2003/2000 Server, Visual Studio, Oracle 9i

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed and implemented stylish report layouts.
• Identified the Data Source and defining them to build the Data Source Views. Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created datasets in T-SQL, stored procedures for SSRS.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.