SUMMARY:

• 7 Years of extensive BI Experience in Enterprise Environment in Tableau 7.0, 8.X, 9.X,10.X as a potential Developer and Analyst.
• Expertise in performing BI Role gathering requirements, analysis, modeling, design, and development of reports and dashboards for analytics and reporting applications.
• Hands on Tableau desktop v9/v10, Tableau server and Tableau Reader.
• Extensive experience working with Tableau Software as a dashboard developer .
• Worked on Jira Agile Boards and Configured swim lanes.
• Extensive experience creating ad - hoc reports in Tableau Desktop.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Calculations and Maps etc.
• Experience in creating visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables .
• Experience in Data Archiving using Cognos Report Studio, Framework Manager and Transformers.
• Created solution driven dashboards by developing different chart types including Crosstabs,Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Expertise in development of Tableau visualizations which includes preparing dashboards using various reporting objects such as facts, attributes transformations, filters, prompts, calculated fields, parameters, groups, sets and hierarchies.
• Practical understanding of the Data Modeling Dimensional Relational concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Mastered in joining tables, multiple data connections using blending , worked on Data Extracts and managing queries.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites .
• Used multiple Tableau data sources (. tds) from excel, CSV, text files and RDBMS (SQL Server) as source systems for workbook generation using Export/Live connection and methodologies.
• Improved Reports performance in Tableau using LOD expressions and context filters .
• Implemented row and column level security .
• Having hands on experience in data analysis by using Hive to retrieve the data from Hadoop cluster, SQL to retrieve data from Oracle database.
• Experience in Tableau REST API.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources
• Experience with creating the Tableau dashboards with relational and multi-dimensional databases including Oracle, MySQL and Teradata, gathering and manipulating data from various sources
• Extensive Experience in Tableau Server includes Automatic Backup, Cluster Node environment.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Involved in creating Stored Procedures, tables, and views for applications .
• Expertise in complete BI Cycle ( DB, ETL, DWH, Reporting).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Worked with JIRA services to set up service Desk, create service desk request types and, make queues for service desk teams.
• Familiar with entire software development life cycle ( SDLC ) and various project methodologies such as Jira , Agile and Scrum Methodology.
• Effective communicator in both written and verbal and able to effectively interact with all levels of Management.

TECHNICAL SKILLS:

BI Tools: Tableau 7x, 8x, 9x, 10x (Desktop, Server, Reader), Business Intelligence Development Studio (SSIS/SSRS), Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI, MicroStrategy, Cognos and QlikView

ETL Tools: SQL Server Integration Services (SSIS), Informatica Power Center 7/8, Data Stage, Alteryx, Talend

SQL TOOLS: SQLPLUS, PLSQL DeveloperOperating systems: Windows XP, Windows 7, UNIX/LINUX

Programming Languages: SQL, PL/SQL

Data Bases & Data Modeling: SQL Server, Greenplum, MS Access, Teradata, Oracle 11g/10g, Excel Flat files, Sybase, Hadoop, DB2, Amazon Red Shift, Cloud Computing, Amazon web services, Erwin, ER Studio

PROFESSIONAL EXPERIENCE:

Confidential, IN

Sr. Tableau Developer/Admin

Responsibilities:

• The objective of this project is to create an ecosystem of business users to create and manage their own Tableau dashboards switching away from excel, develop new dashboards from a new data warehouse to answer business questions and share with the respective group for further analysis and decision making; and to create a custom portal to host their dashboards.
• Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.
• Created technical specification documents related to Tableau design and architecture.
• Created several Tableau data extracts with prebuilt calculations, parameters and sets to enable end users to easily utilize the extracts as semantic layer to create their own workbooks.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Worked on machine learning on large size data using Spark and MapReduce
• Performed data analysis by using Hive to retrieve the data from Hadoop cluster, SQL to retrieve data from Oracle database.
• Responsible for Tableau Environment, Security, Architecture setup.
• Worked on Proof of Concepts to decide Tableau as a BI strategy for enterprise reporting.
• Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.
• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.
• Created Server Monitoring workbook views and a custom workbook to see ‘My activity’ on Tableau Server using Tableau Server Repository Database (Postgresql).
• Actively involved in creating a custom portal design hosting Tableau workbooks using JavaScript API.
• Created responsive workbooks for Ipad /PC orientation views.
• Worked on JIRA customization- Issue Schemes, workflow Schemes, Field Configuration Schemes, Screen Schemes, Permission Schemes, Notification Schemes.
• User admin and Handling Licenses Performed JIRA Configuration.
• Worked with end users in creating complex dashboards in an iterative process.
• Created several automated scripts to backup, restore and auto sync Windows AD users.
• Extensively used tabcmd and tabadmin for various Tableau server maintenance activities.
• Performed tuning of tableau workbooks and extracts to make them functional with large sets of data.
• Conducted training sessions for Tableau Power users to use it as a Self-service BI tool.
• Managed and coordinated with offshore team on deliverables.

Environment: Tableau 8.2/8.3,9.X,10.X, Server and Desktop, Jira 6.x and 7.x, Postgresql, SQL Server 2012, Oracle 11g, SQL/PLSQL, Windows Server 2012, Hadoop, MapReduce, HDFS, Kafka, Pig, VISIO.

Confidential, VA

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Liaison for project managers, managers, directors, and stakeholders.
• Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.
• Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.
• Developed, derived and clarified functional specifications and Use cases.
• Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
• Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.
• Designed the conceptual and business process models.
• Implementation of new systems including the integration of the new system with existing systems.
• Verifying installed systems to ensure that they adequately meet user requirements.
• Physical design of data record data files and databases.
• Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.

Environment: SAP Business Objects BI 4.0 (CMC, Information Design Tool (IDT), Web I), Tableau 7.0/8.1 Server and Desktop, Oracle 10g and 11g, SQL Server 2012, Spark, Hive, Kafka, HBase, Teradata, SQL/PLSQL, Windows Server/professional, VISIO.

Confidential, TX

Tableau Developer/SQL Developer

Responsibilities:

• Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
• Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time
• Building the customized and interactive dashboards using multiple data sources
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Gathered user requirements, analyzed and designed software solution based on the requirements
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developing Standard and Create reports using Tableau Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Creating DB views for the reporting purpose.
• Preparing Report Mapping Documents as per Specifications.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored 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.

Environment: Tableau Desktop 8.2, Tableau server OBIEE, SQL Server 2008.

Confidential

SQL Developer/Data analyst

Responsibilities:

• Conducted one-on-one sessions with business users to Gather Data Warehouse Requirements.
• Updated existing models to integrate new functionality into an existing application.
• Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions.
• Developed normalized Logical and Physical database models to design OLTP system.
• Created Dimensional Model for the reporting system by identifying required dimensions and facts using Erwin.
• Created DDL scripts for implementing Data Modeling changes.
• Created ERWIN reports in HTML, RTF format depending upon the requirement.
• Published Data model in model mart, created naming convention files, co-coordinated with DBAs' to apply the data model changes.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN.
• Created and maintained Metadata, including table, column definitions.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Responsible for Defining the Naming Standards for data warehouse.
• Possess strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
• Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Eliminated errors in Erwin models through the implementation of Model Mart (a companion tool to Erwin that controls the versioning of models).

Environment: DataWarehouse, HTML, ERWIN, SQL Developer.