SUMMARY:

• IT Professional with 8+ years of referable experience in analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/ Data Mart Design, BI Solutions, OLAP, Client/Server and Web applications on Window and Unix platforms.
• 6+ years of strong experience in Tableau Desktop, Tableau Server and Tableau Online.
• End to end experience in designing and deploying data visualizations using Tableau.
• Expert in gathering external data to Tableau from different sources like Oracle, SQL Server & flat files etc., for data visualization.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Expertise in developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Sound knowledge of relational database concepts and writing customized SQL/TSQL queries.
• Strong knowledge on Other BI Tools like (SAP BO, PowerBI, Alteryx)
• Specialized in creating complex query reports using Oracle, SQL Server, SAP HANA, MS Access, local files, and various RDBMS.
• Expert in generating on - demand and scheduled reports for business analysis or management decision using Tableau and Power BI.
• Skilled at building and deploying multi-valued parameterized reports using Power Bi, Tableau.
• Good understanding of Tableau architecture, design, development and end user experience.
• Extensive experience with Advance analysis like Actions, Calculations, Parameters, and Background images, Maps, Trend Lines and Statistics.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.

TECHNICAL COMPETENCIES:

BI Tools: Tableau Suite of Tools 10.1/9.x/8.x/7.x which includes Tableau Desktop, online and Public Tableau Server 10.0/9.3/9.2/8.3 , SAS, SAP Business Objectives 4.x/3.x, Power BI, Cognos

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005, T-SQL, MS Access, DB2, HANA

Environment: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Tableau Developer

Responsibilities:

• Work closely with Client Services/Finance/Fraud & Risk team to gather requirements for designing Tableau Reports.
• Design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Price Benchmark Regression curves using the client financial data.
• Synchronized version control - especially with respect to PDF vs. Tableau reports.
• Modify reports to use the user specified variance for conditional formatting.
• Developed Audit reports based on the client’s logins and download PDF reports in the portal.
• Developed ECR calculations and benchmark regression power trend line curves.
• Reviewed all the calculations used in Tableau reports and moved them to the Database.
• Worked under SQL Server stored procedures and big data environments.
• Worked on homegrown analytic SAAS solutions are the most widely installed in the industry?
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Created different KPI using calculated key figures and parameters.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Built Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.
• Also involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

Environment: Tableau Server 10.3/9.3, Tableau Desktop 10.3/10.3.4 and 10.5, Python, Windows Server Standard R2,T-SQL, Power BI 2013, Excel, SQL Server management studio, MS SQL Server 2012

Confidential, Jersey City, NJ

Sr. Tableau Consultant

Responsibilities:

• Develop complex Tableau Visualizations.
• Extensively used parameters, calculated fields, Sets, Action Filters in the Report Development.
• Set up Tableau Server with SAML configuration.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Connected Tableau PostgreSQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Utilized the Extract API in Tableau 9.3 to create dynamic Tableau data extracts using R, Python programming.
• Performed data profiling, data cleansing and data Analysis using complex SQL on various sources systems including Oracle.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Maintained and managed Tableau and Power BI driven reports and dashboards.
• Created few Tableau data extracts using R language, Python programming and Extract API within Tableau9.3.
• Actively involved in the Server migration and the Fresh Tableau Server Installation Process.
• Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.
• Worked on SQL Performance tuning with Code optimization, Indexing, Execution Plan Analysis.
• Displayed changes of annual usage trend and annual productions from Year to Year with R and Tableau.
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Defined best practices for Tableau report development.
• Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet
• Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Designed and implemented SSO security model giving access to users from main application to Tableau using Tableau API calls.
• Consulted on Tableau server performance enhancements; upgrades from version 9.3 to 10.3 and server reconfiguration based on workbook complexity and data extraction

Environment: Tableau Server 10.3, Tableau Desktop 10.3.5/10.4/10.5 , Windows Server Standard R2,T-SQL, Excel, SQL Server Management Studio, MS SQL Server 2012

Confidential, Newark, NJ

Tableau Site Admin

Responsibilities:

• Created and updated server architecture for scheduling tasks.
• Created various User groups by assigning row and column level security at application level, folder level and user level.
• Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it.
• Administered user, user groups, and scheduled instances for reports in Tableau by controlling the access of resources to intended user.
• Used the Tableau Online sync application to schedule automatic refresh tasks for extracts of data and to maintain on local network.
• Analyzed and resolved performance and server based issues.
• Prepared backups using TabAdmin and TabCmd commands.
• Formulated procedures for installation and configuration of Tableau desktop.
• Designed and developed SSIS packages for Tableau dashboards.
• Utilized data blending activities for Tableau functionalities.
• Participated in performance tracking activity by evaluating server tasks.
• Modified data visualization dashboards and developed data connections

Environment: Tableau Server 7.0.3, SQL Server 2008

Confidential

Business Objects Consultant

Responsibilities:

• Used Report level joins and unions in some of the reports, created prompts and calculations in RS and FM model.
• Validated the schema and found the errors present in the ETL and also took part in giving the recommendations to fix the problem.
• Modified existing Universes to meet user-reporting requirements.
• Interacted with Business Objects technical team to solve the bugs involved in Business Objects.
• Full life cycle implementation of BW that includes Data Modeling, Data Extraction, Data transformation, Data loading(Full/Delta upload), Scheduling jobs, Monitoring data loads, production support, troubleshooting and reporting
• Responsible for data modeling in the data warehousing effort of the Sales and Distribution, and Master data (Customer and Material Master) for the SAP BW
• Worked extensively on standard and custom defined LO and LIS extractors. Used LO extract structures and data sources in sales material management to facilitate the data extraction to BW
• Performed various tuning techniques (aggregates, statistics, partitioning and multi-providers, OLAP Cache) to optimize the query performance
• Used ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to Update Key Figures in the Info Cubes
• Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates and Involved in Production Support
• Heavy Technical concentration in designing Info Packages, Info Sources, Update Rules, Reports for Sales and Distribution
• Interacted with the Business Analyst, Users and Business leads to understand their business needs.
• Modified universes and created reports for them accordingly.
• Worked on Data Extraction and transforming data from using Data Integrator.
• Provided technical leadership for Business Intelligence (BI) roadmap and the direction of application projects from data capture through application design & implementation.
• Implemented the best practices for Business Objects Environment.

Confidential

SQL Developer

Responsibilities:

• Managed database objects like stored procedures, views, tables etc.
• Optimized queries that were taking long time to display desired result set.
• Created groups, roles, users and assigning access privileges to users.
• Created new stored procedures and modifying existing ones as per business requirements.
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.
• Performed data analysis to generate various trend reports.
• Performed identification, analysis and resolved report defects within time scope and established development guidelines.

Environment: SQL Server 2005, SQL Server Management Studio, SQL Server Reporting Services (SSRS)