SUMMARY:

• Experience of 8+ year’s in design, development, implementation, and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse.
• Extensive experience of nearly 4+ year’s in Tableau Desktop, Tableau Server, Tableau Reader, Tableau Public in various versions of Tableau 6.x/7.x/8.x.
• Proficient in designing and development of various dashboards, reports utilizing different Tableau Visualizations like 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 business/client requirement.
• Proficient in using parameters, dynamics groups and sets, data hierarchies, filters, calculated fields and other custom function like string functions, date functions and logical functions.
• Experience in creating multiple types of filters, quick filters, data source filters, global filters, context filters and user filters.
• Designed and developed numerous analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Strong experience in SQL Server development, System Analysis, Design, Development and support of Microsoft SQL Server 2005,2008, 2012.
• Outstanding knowledge in writing complex SQL queries, Stored Procedures, Database tuning, query optimization and resolving key performance issues.
• Well-built understanding of Data warehousing concepts, data modelling experience using Normalization, Business Process Analysis, Reengineering and Dimensional Data modelling.
• Expertise in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Augmented lot of KPIs and also action filters to redirect to detail.
• Proficient skills in writing and debugging Stored Procedures, Views and triggers using T-SQL Script.
• Experience in working with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development and to manage risk analysis and mitigation plans, status reports and client presentations.
• Brilliant leadership capability, reporting as well as analytical/problem solving artistry with attention to detail.
• Sturdy interpersonal ability with strong verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

BI Tools: Tableau 9.0/8.x/7 (Desktop/Server/Reader)

Databases: Oracle 9i/10g, Microsoft SQL server 2014/2012/2008/2005, T-SQL

Programming Languages: HTML, XML, C, C++, SQL, T-SQL, PHP

Scripting Languages: Java Script, Perl, XML, CSS

Operating systems: UNIX, LINUX, Windows XP/Vista

PROFESSIONAL EXPERIENCE:

Confidential, Union, NJ

Sr Tableau Developer/Admin

Responsibilities:

• Developed Tableau dashboards according to user specifications.
• Extensively used Data Blending techniques in dashboard development.
• Supported different user groups and business domains.
• Wide knowledge of tableau server, installation, configuration, administrative functions, back up of the servers and load balancing techniques.
• Acknowledged security configuration including user/ group setup, configuration of trusted ticket authentication, permissions and security roles.
• Monitored the Tableau Servers to ensure high availability to the users.
• Expertise in Data Interoperability and Analytics.
• Provided Tableau Demo’s to new onboarding users.
• Setup new projects, security groups, roles and administer users for all supported platforms.
• Excellent requirements gathering skills.
• Developed worksheets and data visualization dashboards with graphs and filters.
• Created report schedules on Tableau server. Developed monthly reports and dashboards.
• Created calculated fields as per business requirement. Described best practices for Tableau report development.
• Capability of handling multiple projects while encountering deadlines and documenting progress towards those deadlines.
• Potential to be a self-starter that can provide leadership.
• Excellent communication skills.

Environment: Tableau Server V8.0/8.1/9.0, Tableau Desktop, Oracle, Netezza, Teradata, Excel, Windows2008 R2.

Confidential, Tampa, FL

Tableau Developer/ Data Analyst

Responsibilities:

• Worked closely with the business users to identify various KPI’s and designed reporting solutions to enhance business decision-making.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.
• Developed and modified Business Intelligence analytical reports/dashboards using Tableau Desktop and worked on all types of report types like tables, matrix, charts, sub reports etc.
• 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.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drilldown reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created very complex Dashboards using Tableau 8.0 using the drill down, drill across, actions for business steering committee.
• Designed, Developed and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Ability to design a Data Source to reincarnate in Tableau.
• Supervise the application’s users, groups, and integration with Active Directory.
• Extracted data from various sources (SQL Server, Oracle, text files and excel documents).
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Experience in taking back ups and restoration of Tableau repository.
• Technical oversight of the entire Tableau Server infrastructure from user setup to performance tuning.

Environment: Tableau 8.0, Oracle, PL/SQL, Control-M, MS Visio, MS Project, MS Office (Word, excel, PowerPoint).

Confidential, Richfield, MN

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, and testing and production rollover of reporting and analyze projects within Tableau Desktop.
• Created views in Tableau Desktop, that were published to internal team for review and further data analysis and even customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers and End Users.
• 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 stake holders and business groups.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel.

Confidential, Boston, MA

Tableau Developer

Responsibilities:

• Extracting the data tables using custom generated queries from Excel files, Access/SQL database and providing exacted data as an input to 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, Trend Lines, Statistics and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Defined best practices for Tableau report development. Hands-on development assisting users increasing and modifying worksheets and data visualization dashboards.
• Worked on functional requirements sessions with business and technology stakeholders on data modeling, integration, and configuration for data warehouse with automated and manual field data collection systems.
• Supervised Vizql and WGSQL processes to monitor performance and system stability.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Provided 24/7 production support for Tableau users and conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Created SQL Queries for testing the tableau Dashboards.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services (SSRS).
• Developed Reports in SSRS to send the reports directly to the respective E-mails, using Subscriptions. Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 6/7, Tableau Desktop 6/7, MS SQL Server 2008, Oracle 10g, SQL BI suite (SSIS, SSRS, SSAS).

Confidential, City of Industry, California

SQL Server Developer

Responsibilities:

• Team member of the BI module and involved in analysis of business requirements template, decomposition matrix, dimensionality modeling and ETL strategy.
• Worked on Microsoft SQL Server 2005 Tools-SQL Server Integration services (SSIS), SQL Server analysis services (SSAS) and SQL Server reporting services (SSRS).
• Responsible for extracting the data from different source feeds like Flat file, XML, OLE DB, and Excel.
• Connected to different types of sources to extract data and destinations to load the data using Connection manager.
• Defined the data Sources, data Source views, dimensions, cubes within the Business Intelligence Development Studio (BIDS) Using SSAS.
• Used Business Intelligence Development Studio, Management Studio for developing SSIS, SSAS and SSRS.
• Performed parameterized reports, reports bursting and scorecards.
• Involved in performing drill down data, calculations, sorting the data, adding groups, subtotals, and color code the business data exceptions.

Environment: MS SQL Server 2005, SSRS, SSAS, SSIS, Windows, MS Office suite, Quality Center, Kiln.