SUMMARY

• Over 8.5 Years of IT Experience in Data Warehousing and Business Intelligence applications in Retail, Financial, Health Care, Pharmacy and Manufacturing industries.
• 4.5+ years of extensive Tableau experience using Tableau 9.X/8.X/7.X as a developer and Analyst.
• Business objects in creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• In - depth knowledge on Tableau Desktop, Tableau Reader, Tableau Server, Tableau Online and Tableau Public.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Experience in working with Amazon RedShift for better and real time analysis.
• Widespread understanding of SDLC Methodologies like Waterfall, Agile/Scrum.
• Extensive experience in Siebel 7/8 implementations, administration & configuration.
• Strong knowledge OLAP and OLTP systems and Experience in using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling for designing Data warehouse /Data marts.
• Experience in designing stunning visualizations using Tableau software and publishing and presenting dashboards on web and desktop platforms.
• Data migrating (using ETL tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports and integrated them to Pro clarity, Share point Portal.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Skilled in Tableau Desktop for visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
• Experienced in roles such as End-to-End BI and data-warehouse Solution implementation expert, BI Project Concept Scoping, BI Semantic layer Designer, BI Reports/Dashboards/Scorecards design and development, Project Management, Business Analyst, BI KPIs Modeling.
• Experience in Requirement Analysis, Gap Analysis, Change Management and Impact Analysis, Capacity planning, Proposal Development, Design validation, Technical leadership, and mentoring and user .
• Experience inTrouble Shooting, Performance tuning of reportsand resolving complex issues.
• Experience in Installation, Configuration and administrationof Tableau Server in amulti-serverandmulti-Tier.
• Experience in gathering requirements, analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects

TECHNICAL SKILLS

BI Tools: Tableau(Desktop/Server/Mobile/Public),TIBCO Spot fire, Crystal Reports X1, XCelsius, SQL Server Reporting Services (SSRS), OBIEE, QlikView, Cognos report tools

Databases: Oracle 8i/9i; SQL Server7.0&2000; Teradata, MS SQL Server, DB2, SQL/PLSQL, MySQL, IBM DB2, Amazon RedShift, Hadoop

Languages: UML, C, C++, HTML, Java, Oracle ETL, SQL, PL/SQL, .NET, VB, CSS, Java Script, Shell Scripting.

ETL Tools: Informatica, SSIS, Datastage

Application Packages: MS Visio, MS Project, MS Access, MS Office Suite, RDBMS Oracle 11g

PROFESSIONAL EXPERIENCE

Confidential, Morrisville, NC

Tableau Developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Experience in designing QlikviewDocument/User Setting, Layouts to make consistent and professional optimized look to clients.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Performed planning, design, and development of QlikviewBI dashboards and data integration in a highly complex global services environment, interfacing Qlikview.
• Converted Excel and crystal reports to Qlikviewdashboards.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Connected to Amazon RedShift through Tableau to extract live data for real time analysis.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Strong Understanding on other components in Spotfire like TIBCO Spotfire Statistical Services, Automation Services and Application Data Services.
• Also expertise in using Impala database.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level
• Developed User Security Groups in TIBCO Spot firefor Authenticating the Access to the tool and providing authorization to view limited data.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with Mobile analytical portal and setup auto refresh feature.

Environment: Tableau Desktop 9.0/8.0/7.0, Tableau server / Administrator, SQL developer, SSAS/SSIS, Amazon RedShift, Hadoop, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential, San Roman, CA

Sr. TableauDeveloper/ Data Analyst

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.
• Installation, maintenance and administration of Tableau Servers.
• Experience in Marks,Publisher and Security.
• Have good experience on Derivative products in Banking Industry, derivative is a security with a price that dependent upon one or more underline assets like stocks, bonds, Currencies and interest rates, It can be either be traded over the counter or on an exchange.
• Analysed tableau on different KPI metrics like customer satisfaction and net promoter scale (1 -7, Unsatisfied 7-8 Moderator, 8-10 satisfied) Includes Client retention, Revenue growth and commercial client growth rates.
• Involved in credit derivative and mortgage-backed security.
• Derivatives either be tradedover-the-counter or on anexchange.
• Some of the derivative products which I involved in Credit, vaaiable intrest rate loan, and fixed intrest rate.
• Worked in the agile methodology using Scrum, which has its primary focus on the management part of the software development in small iterations of four weeks sprint.
• Designed and developed Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies
• Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Developed different views using Tableau Desktop that were published to the business stake holders for analysis and customization using filters and actions.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.
• Designed Spot fire Information model, Elements, Information links to create reports.
• Administered user, user groups, Projects and Sites.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Created Forecasted Reports for the Upcoming Year to Observe Trends in Tableau.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Environment: Tableau Desktop 8.1.6 and 8.2 Tableau Server, Oracle SQL Server, Teradata, MS Access.

Confidential, Stamford, CT

Tableau Developer/ Data Analyst

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Implemented Automation of Tableau Backup on weekly basis and stored them in separate folder automatically.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• 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) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.

Environment: TableauDesktop 7 & 8.1,TableauServer, Business Objects, SQL Server 2008/2012SQL, PL/SQL.

Confidential, Andover, MA

SQL Developer

Responsibilities:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin
• Involved in the design and implementation of database.
• Used DDL to create the database objects and created Master and Transaction table package
• Involved in coding, unit testing, and end-to-end testing of the developed modules.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling and Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization and created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 9i, SQL* LOADER, Forms 6i, Reports 6i, Discoverer 10g, XML Publisher.

Confidential

SQL Developer

Responsibilities:

• Modified report wherever needed as per the suggestions given by business analyst and analyzed the existing Actuate and SQR reports.
• Migrated actuate code of data extract to PL/SQL equivalent and created PL/SQL functions, packages, procedures and joins.
• Coordinated with the client to make sure that there is not much change during the migration of the reports.
• Assessed the pros and cons of migration and conveyed the same to the Business Analyst.
• Created Cross-Tab, Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.

Environment: SQL Server 2005 Enterprise, Crystal reports, SQR, SSIS, SSRS, SSAS, Windows Enterprise Server 2003, IIS 6.0, Visual studio 2005, Share Point (WSS3)