SUMMARY:

• 7+ years of experience in Designing, Administration, Analysis and Management in Business Intelligence Data warehousing. 5 + years of extensive Tableau Experience in Enterprise.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, 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 end user requirement.
• Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trials and Density Chart.
• Experienced in Software Development Life Cycle (SDLC) that includes providing documentation on design, testing, and migration from development to production of report building using Tableau.
• Experience in connecting to data directly from different source systems like Flat Files, MS Access, MS Excel, Oracle, MS SQL Server, AWS and Tableau Data Extracts.
• Performed Extract, Transform and Load operations from the databases using SSIS. Also, created the merge, lookup and send mail tasks. Created triggers, stored procedures and complex queries.
• Knowledge of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc.).
• Experience in Tableau Server installation, configuration, creating Users, Groups, and Projects and assign Privileges, Row level security etc.
• Good Experience in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in using SQL Server Integration Services (SSIS) to extract, Transform and Load data from any OLEDB Provider like MS Access, Flat File, Excel, Oracle, also worked to Automate the ETL operations.
• Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Strong Experience in 21CFR part 11 which includes electronic signatures, electronic records, audit trials, open and closed systems.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS)
• Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources. Assigning roles and permissions to users and updating the current roles and permissions.
• Resolved performance issues and worked for better scalability and availability of Tableau Server.
• Regularly accessing JIRA tool and other internal issue trackers for the Project development.
• 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.

TECHNICAL SKILLS:

Programming Language: SQL, Java Script, C++, Java, HTML, HTML5, XML

BI/Reporting Tools: Tableau Desktop, Tableau Online, Tableau Mobile, Tableau Reader

Databases: Oracle 12c, Oracle 11g, 10g, 9i, MS SQL Server, Teradata, Hadoop, MS Excel, SAS, MS Access.

Operating Systems: Linux, Unix, Windows

PROFESSIONAL EXPERIENCE:

Confidential - Sunnyvale, CA

Tableau / Business Intelligence Developer

Responsibilities:

• Worked with business users, interpreted business requirements that users looked to dashboards to answer and created server-based Tableau dashboards with automatic updates.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, Flat File, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Performed Gap Analysis according to client requirements.
• Developed complex reports and data visualizations using Tableau Desktop such as performing gap analysis and comparative analysis.
• Created extensive joins for data blending from several different data sources
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images and Maps.
• Histogram, Pie Charts, box/scatter plot, time series graph was used to show Project metrics. Backgrounds maps were used to project Resource level data and the amount of resources assigned to projects from different countries.
• Created Table of Contents (TOC) for the reports, a common navigation page which had all the links to various reports.
• Used components like action filters, quick filters, groups, bins, hierarchies, sorts, sets, maps, parameters and table level calculations to improve data visualization for SSRS.
• Improved performance in dashboards by implementing global, local and context filters.
• Interacted and worked with Testing Teams to check and run the test cases.
• Identified the project goals, story pointed, provided timelines and added tasks to work on respective project goals.
• Created Drill-down and navigation features extensively in Tableau Desktop.
• Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.
• Communicated clearly with the peers, supervisors and managers.
• Wrote SQL queries to validate the data in the application level as part of functional testing.
• Used SQL Developer to pull the data into PowerBI to visualize the data and Performed SQL Tuning and query optimization tools like Explain Plan.
• Developed and published dashboards, reports on the Tableau Server and provided access to end users to view data on front end side.
• Optimized load times on even complex dashboards by applying best approaches.
• Created and delivered monthly reports to business users.
• 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.
• Designed and developed Jobs that extract data from Flat Files, cleanse it, transform it as per business requirement and populate the data into DB2 Table.
• Extracted data from various Flat Files/Database Tables for applying the transformations provided by the business. Designed Transformation jobs for applying the business rules provided.
• Extensively worked on Transformer, lookup, join, merge, funnel, Sequential File, dataset, change capture and Database stages.

Environment: Tableau Desktop 10.0, 9.3, Tableau Server, MS Excel, MS Word, SQL Server 2012, JIRA, IBM DataStage 9.1.

Confidential - San Antonio TX

Tableau Developer \Administrator

Responsibilities:

• Has experience in writing complex reports and visualizations on various types and sizes of databases and data warehouse environment and advanced knowledge in server administration.
• Assisted users with questions and issues using Tableau.
• Developed workbooks and dashboards for the global sales and Risk Management Team to support company initiatives to better equip sales people at client sites with the right tool and Information.
• Liaise between business users and Tableau Support Team.
• Work with various infrastructure teams and Tableau Support Team to help improve dashboard response time.
• Used actions extensively to link and filter sheets for easier navigation in dashboards.
• Interacted with business users to gather requirements and provided guidance for the Data Warehouse Team in how to structure data for optimal use in Tableau.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad).
• Worked in Tableau environment to Create dashboards like weekly, monthly, daily reports using Tableau desktop and publish them to server.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls.
• Involved in writing complex business rules for populating Dimension Tables, Fact Tables, and Aggregate Tables.
• Advocate the use of Tableau Solution and help educate business users to facilitate early adoption of the tool.
• Collected data on various process measurements and formatted into graphs using Tableau Software.
• Building, publishing interactive reports and dashboards, report scheduling using Tableau Server.
• Set up Tableau Desktop, Data Analysis and publishing reports.
• Created pitch books, financial models and determined pre-money valuation range for all new deals using various Tableau advanced charts.
• Designed and developed Jobs that extract data from Flat Files, cleanse it, transform it as per business requirement and populate the data into DB2 table.
• Extracted data from various Flat Files/Database Tables for applying the transformations provided by the business. Designed Transformation jobs for applying the business rules provided.
• Extensively worked on Transformer, lookup, join, merge, funnel, Sequential File, dataset, Change Capture and Database Stages.

Environment: Tableau Desktop 7.0 Sybase ASE 11.9, Oracle 11G (Oracle Enterprise Manager), SAP Business Objects XI 3.1, Microsoft Office Suite, IBM DataStage 8.5

Confidential - Reston, VA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/MS SQL Server for design, development, testing of reporting and analysis projects within Tableau Desktop.
• 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.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Acts as a Tableau Administrator, Using Tableau Server publishing the developed dashboards to the Tableau Server with the user management, security, content restriction, authentication, authorization, Tableau Extracts scheduling and refreshment and Users access.
• Created multiple automated reports and dashboards sourced from data warehouse using Tableau/SSRS.
• Wrote T-SQL Procedures/Views to facilitate data access for reporting needs.
• Update and upgrade the OBIEE platform to customize the system as per needs. Install and configure OBIEE Tools across multiple tools and versions.
• Designed SSIS Packages to transfer data from flat files to SQL database tables.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Developed Metadata Models in Tableau and dashboards.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Created dashboards using Tableau desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created and updated server architecture for scheduling tasks. Analyzed and resolved performance and server-based issues.
• Formulated procedures for installation and configuration of Tableau desktop.
• Designed and developed SSIS packages for Tableau dashboards.
• Created and updated server architecture for scheduling tasks. Analyzed and resolved performance and server-based issues.
• Designed and developed Jobs that extract data from Flat Files, cleanse it, transform it as per business requirement and populate the data into DB2 table.
• Extracted data from various Flat Files/Database tables for applying the transformations provided by the business. Designed Transformation jobs for applying the business rules provided.
• Extensively worked on Transformer, lookup, join, merge, Funnel, Sequential File, dataset, Change Capture and Database Stages.
• Design and develop web application using JavaScript, HTML, CSS and integrate the server links into the JavaScript to facilitate the changes and user access restriction.

Environment: Tableau Desktop (Version 8.1.2 - Version 9.0.2), JIRA, JavaScript, .Net APIs, ETL -Informatica, SSIS, SSRS, SQL Server, IBM DataStage 8.5, Microsoft Visual Studio, Microsoft Visual Basic, WebStorm, Oracle, OBIEE, SQL Server Management Studio, MS Excel, MySQL.

Confidential - New York, NY

Tableau Developer\Administrator

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Server.
• Created different KPI's using Table calculations and calculated key figures Manipulating Strings, Arithmetic Calculations, Aggregation Options and Logical functions.

  Developed a 360-business dashboard with multiple panels and Parameters.

  Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions and provided an interactive reporting environment of the Revenue Impact Analysis, Inventory Control, Pricing Opportunity Analysis, Markets Overview, Shopping Activity, etc., in the developed dashboards.
• Created actual sales and target sales view with Trend lines, Table Calculations to see the difference between each quarter.
• Implemented Data Blending, embed functionalities in case of merging different sources and created dual-axis bar chart with multiple measures.
• Prepared and executed Test plans for Unit Testing, System Testing and User Acceptance Testing (UAT).
• Involved in Extraction, Transformation and Loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks, embedding views in the Tableau Server.
• Created Test Scripts, Test hierarchy to represent the features and functionality that need to be test in the application.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Assisted users in creating and modifying Worksheets and data visualization dashboards.
• Used getData functions of getSummaryData() and getUnderlyingData() retrieving user to select the particular Dimension for better visualization.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau 10.x/9.x, Tableau Desktop, Tableau Server, Tableau Online, Oracle 11i, Windows Server Standard R2, Excel, SQL Server management studio, MS SQL Server 2008R2, SSRS, SSAS, Teradata, UNIX, LINUX.

Confidential, Austin TX

MS BI developer

Responsibilities:

• Working as a BI Consultant in Business Analytics team.
• Supporting and loading the RCA.
• Maintaining the data warehouse, ETL processes ((DTS - SQL 2000)/(SSIS - SQL 2005)) packages and also maintaining the reporting part.
• Working for BOBJ-Business objects - BODI as an ETL process to one of the project.
• Creating the DW bus matrix, dimensionality modeling for the BOBJ by integrating the BOBJ with Kodiak RCA.
• Understanding the existing data modeling (db model) in MS Visio.
• Extracting the different source feeds text file, excel, Siebel CRM Answers feeds into the SSIS\ DTS packages of ARCA (Kodiak RCA, SE (South East) RCA).
• Running the back-end supporting stored procedures to the end reports in MS BI environment.
• Implementing and Supporting the SE RCA ETL process using the MS BI tool for loading the SE RCA data warehouse.
• Developing and Maintaining the BO XI (Xcelsius 2008) to build up the Scorecards and Dashboards to the biz users using BO Power User and Xcelsius.
• Using SQL server Enterprise manager\BIDS as an ETL\DTS for extracting data from source, transformation and load the data into target tables.
• Ad-hoc ETL, Reports requirement runs.
• Working on the SSRS reports/Scorecards to publish to the different user communities and publishing different SSRS reports tabular, matrix, parameterized, and chart reports using SSRS.
• Implemented all the sub component tools of SSRS such as Report manager, Reports, Report server, Report viewer, and Report builder for the SSRS reports generation purpose and also for the ad-hoc report requirements.
• Also implemented and supported some of the most advanced analytical reports with the tool MS Performance point server 2007 (Monitoring, Analysis & Planning) to create the MS PPS models, applications, user roles.

Environment: BI solutions, BI environment, BI applications, MS BI toolkit\Product stack (Suite) Windows, and BOXI- BODI, Power User, & BOBJ