SUMMARY:

• 9+ years of extensive experience in IT as BI Developer with Tableau and Business Intelligence Tools with expertise in data warehousing concepts.
• 5+ years of experience in Tableau Development and 4+ years of experience in SQL and MicroStrategy.
• Experience in Tableau 10.5/10.4/10.3 / 10.2/10.1/10.0/9.3/9.2 /9.1/8.0 /7.0 as a BI Developer, Analyst and Admin.
• In - depth knowledge on Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud and designed several business dashboards.
• Expertise in Installation, configuration, upgrading and administration of Tableau Desktop/Server.
• Proficient in data visualization, Reporting, Analysis, Bar Charts, Pie Charts, Heat Maps, Scatter Plots, Page Trails, Geographic Map and Density Charts in Tableau Desktop.
• Created actions, customized relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, drill down analysis and in-memory in tableau.
• Performed extensively with Calculations, Parameters, Background images, Advance analysis Actions and Maps.
• Working pastime on recent versions of Tableau 10 and 10.1/10.2 to understand the differences and features for creating innovative dashboards on data sources procured from Superdatascience, Kaggle and Github.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Used parameters, action filters and sets for preparing dashboards and worksheets in Tableau.
• Performed extensively with Calculations, Parameters, Background images, Advance analysis Actions and Maps.
• Worked on reference lines, trend Lines, statistical concepts. Used groups, sets, hierarchies to create detail level summary report and dashboards using KPI's.
• Worked on the improvement of dashboard reports bycreating KPI (key performance indicators) for the top administration.
• Expertise in configuration of Tableau server 10.0/9.2 in various environments and Used Tableau admin tools and Tableau CMD to configure the server following best practices and setting up security profiles for various User groups and Users.
• Built Operational Dashboards strictly focused on tracking operational and financial performance.
• Used SAS in the area of Analytics and ‘Analytical Data Preparation’ and Tableau in the area of data discovery, visualization and intuitive, interactive dashboarding.
• Worked on configuring various data sources using Data Blending.
• Requested data from Google Analytics from Tableau, and overcome the sampling limits that would typically apply in the interface and the Core Reporting API.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Proficient in Tableau server commandstomigrate workbooks from environment to another environment and also carried out Tableau server backup, monitoring and debugging tasks.
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Created automated scripts for tableau workbook refresh when not using live connections
• Setup of Distributed Server environments for optimum load balancing.
• Utilized efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Held responsibility in setting up security profiles for various user groups and users using Tab admin and Tabcmd Tools.
• Worked on setting permissions on content for specific users or group on a per site basis.
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
• Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side.
• Experience in publishing and sharing workbooks, data sources with user filter to tableau server, setting schedules, subscriptions, authorization and permissions, incremental refresh extracts and updating serverdata that are using extracts.
• Experience in working on different data warehousing methodologies including star schema and snowflake schema, ETL processes, dimensional modeling, reporting tools.
• Experience in using Custom SQL for tableau and in writing queries for generating tabular reports, formatting report layout and expressions.
• Involved in complete Software Development Lifecycle (SDLC) by identifying the business requirements and converting them to tableau design.
• End to end involvement in designing, testing, deploying and support of data visualizations using Tableau Desktop.

TECHNICAL SKILLS:

Tableau Desktop 10.5/10.4/10.3 / 10.2/10.1/10.0/9.3/9.2 /9.1/8.0: Used various tableau versions to create visualizations appealing to end users and customers

Tableau Server 10.2/10.1/10.0/9.3/9.2: Installation and configuration of Tableau server on various versions, Service pack upgrades, Version upgrades and end to end architecture design

Tableau Cloud, Tableau Reader, Tableau Public, Tableau Mobile: Well versed with other products of Tableau on what to use as per the requirements

Platforms: UNIX, Win, LINUX, Web Sphere, Apache/Tomcat, Oracle, MS SQL Server, Access, DB2, Teradata, AWS Redshift

Analytical Skills: SAS Enterprise Guide, SAS Enterprise Miner, Micro Strategy, IBM Modeler, R Programming

Additional Skills: SAP BOBJ 4.0/3.1, HANA, Qlikview, C, C+ +, Visual Basic, ASP.NET, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, CA

Sr. Tableau Developer/Admin

Responsibilities:

• Designed and developed Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Created and presentedweekly status update reports for the ongoing project and identified the roadblocks.
• Published many dashboards on Tableau Server and embedded them into web portal.
• Setup and configuration of Tableau server 10.2 in various environments and used Tableau CMD.
• Used Tableau admin tools to configure the server according to best practices.
• Building publishing customized interactive reports and dashboards report scheduling using Tableau server Creating New Schedules and checking the tasks daily on the server.
• Involved in creating dashboards and reports in Tableau 10.0 and Monitored server activities, user activity and also customized views.
• Connected to RSoftware for Hierarchy check of the given business requirement.
• Involved in upgrade of Tableau Server and also created Users Groups, Projects Workbooks and assigned Access levels in Server.
• Configuration of AWS in built SNS/SQS setup for job scheduling
• Create required shell or python scripts for data push from Tableau/Teradata to S3
• Provide the user access to team for AWS console and SSH connectivity to the Edge node.
• Created users groups projects Data connections settings as a tableau administrator.
• Created connections to Hadoop Hive and work with data/time data.
• Worked with Tableau scorecards dashboards using stack bars bar graphs scattered plots geographical maps Gantt charts using show me functionality.
• Created action filters parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Used Trend Lines, log axes, groups, hierarchies and sets to create detailed level summary report and dashboard using KPIs.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Conducted Training sessions for Tableau Power users and created the documents for end user support.
• Writing SQL queries for data validation of the reports and dashboards as necessary.
• Involved in Performance tuning the reports and dashboards for optimization.
• Exported the universes to the Repository for making resources available to the users.
• Experience in configuring reports from different data sources using data blending.
• Build organized customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables views procedures triggers and functions using T SQL to provide definition structure and to maintain data efficiently.

Confidential, Baltimore,MD

Senior Data Visualization Specialist

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used data connectors that are already available in Tableau, to create web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Used the Tableau Web Data Connector JavaScript library to connect to the GoogleAnalytics data without having pitfalls going directly with the GA connector
• Used Tableau web data connector to create gets stock price data from the Yahoo site.
• Used the Yahoo provided REST API that send queries for financial data.
• The connector then gets the closing price for the specified company for one year back from today's date.
• Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tab cmd and Tab admin utility tool and migrated Workbooks and Dashboards from Tableau 7 to Tableau 9.2
• Implemented new features in Tableau 9.2 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Involved in installation and upgrade of Tableau Server and Server performance tuning for Optimization.
• Involved in building Dashboards using parameters, sets, groups and calculations.
• Designed Views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Confidential, Scottdale,AZ

Tableau Developer/Admin

Responsibilities:

• Worked in coordination with Clients for feasibility study of the project in tableau and drawing up the timelines.
• Deployment of tableau Server in clustered environment by mapping server nodes to primary machine.
• Created Users, Groups and projects in tableau environment.
• Created and managed schedules for users.
• Created different views using a tableau Desktop that was published the business stakeholders for analysis and customization using filters and actions.
• Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
• Used Hbase structured, semi-structured, unstructured data - without any up-front modeling
• Used HBase enhanced ability to serve random reads and writes in real-time.
• Implemented various data connections from data source to tableau Server for report and dashboard development.
• Combined visualizations into Interactive tableau Dashboards and published them to the web portal.
• Created guided navigation links for Interactive dashboards in tableau.
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in tableau Desktop.
• Created Bullet graphs to determine average wages and workers compensation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculationto manipulate the data.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Formulates and recommends standards for achieving maximum performance and efficiency of the DWH.
• Design interactive dashboards in tableau Desktop and published them to tableau Server.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Design, create, and maintain a platform-wide, re-useable data extract layer within a tableau
• Experiment with new features and enhancements released by tableau, and bring them into the platform & organization.
• Responsible for designing scalable tableau Server Architecture in order to support Internal and External users, reviewing and optimization of existing workbooks and data sources.
• Experience with tableau application performance monitoring, capacity planning, and tuning for multiple members on multiple projects.

Confidential, Plano,TX.

Tableau Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes
• Developed various dashboards, used context filters, sets while dealing with huge volume of data
• Provided Tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters
• Worked on Creating various plots and drill down analysis using Tableau desktop
• Worked on scheduling reports, managing data sources and refresh extracts. Developed SQL scripts to create database objects like Tables, Views and Sequences
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization
• Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Conducted Gap Analysis, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards in web
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Confidential, Melbourne

Sr. Data Analyst

Responsibilities:

• Gathered and documented the requirements that are critical to the business mission and translate business requirements into report visualization specification design documents.
• Designing and creation of tables and stored procedures, views, triggers, user-defined functions.
• Data Modelling (Physical and Logical) using Erwin for the new system to be introduced in the process.
• Created and maintained various databases for development and testing environment
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel, csv, text documents, pdf, and Flat file to MS SQL Server.
• Involved in writing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Created Triggers to enforce data and Referential Integrity.
• Designing and developing database management systems using ETL (SSIS) and maintain the database using stored procedures (SQL, PL/SQL) to fulfill the technical and business requirements of clients.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Writing T- SQL statements for retrieval of data and Involved in performance tuning of T- SQL Queries and Stored Procedures.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Developed various dashboards for Income Statements, financial reports in Tableau.
• Generated Interactive dashboards with filters, Parameters and Actions to handle views more efficiently Published reports/dashboards on Tableau server and created & managed Tableau server groups and permissions.
• Created aggregate data extracts for larger tables and configured schedulers on the server to refresh the data.
• Provided insights of Time series forecasting data analysis of weekly sales for regions and retail users using R and Tableau.
• Worked with SQL and extracted data using Alteryx and developed POCs (Proof of Concepts) by building reports and dashboards using Tableau 8.1 to demonstrate quick wins.
• Good Experience in database design using PL/SQL, SQL, ETL, T-SQL to write Stored Procedures, Functions, Triggers, Views.
• Proactively anticipated client needs and ascertain the means to improve satisfaction and monitor levels Improved the delivery process through continuous integration.
• Environment: Tableau Desktop, Tableau Server, SQL Server Management Studio (SSMS), MS SQL Server, Erwin, MS Office Suite (Word, Excel, PowerPoint

Confidential, Melbourne

Data /System Analyst

Responsibilities:

• ConvertedvariousSQLstatementsintostoredprocedurestherebyreducingthenumberofdatabase accesses.
• Handledimportingdatafromvariousdatasources,performedtransformationsusingHive,MapReduce,and loaded data into HDFS.
• InteractionwithBusinessAnalyst,SMEsandotherDataArchitectstounderstandBusinessneedsand functionality for various project solutions
• Identifying and executingprocessimprovements, hands-oninvarioustechnologies such as Oracle, Informatica, Business Objects.
• Created data governance and privacy policies.
• Manipulating/mining data from database tables (Redshift, Oracle, Data Warehouse)
• HandleconversationwithCountryDMteam,Financeteam,BIteamandregionalteamtogetsignofffor the products logic.
• Responsibleforarchitectinganalyticframeworksfordatamining,ETL,analysis,andreportingunderthe supervision of the Manager.
• Cleaned data by analyzing and eliminating duplicate and inaccurate data (outliers) using R.
• Worked in Agile Environment.
• Ensure that there are no missing values in the dataset and can be used for further Analysis.
• TrainedinBasicsofDataScientistandimplementedthosesoftwareapplicationsincollectingandmanaging patient data in Excel/SPSS.
• Assisted in performing statistical analysis of the data and storing them in a database.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Involved in designing and implementing the data extraction (XML DATA stream) procedures.
• Generated graphs and reports using ggplot in RStudio for analyzing models.
• Generating the Results and predicting the Accuracy.
• Preparing the Final Documents and ensure delivery to the Client before EOD.