OBJECTIVE:

Around 7 years of experience in the IT Industry. Worked on Tableau Desktop, Tableau Server and efficient in connecting various data sources. Possesses high level of proficiency in creating and troubleshooting complex reports, dashboards, security configurations, and provides a high level of customer service while managing several high priority issues concurrently.

PROFESSIONAL SUMMARY:

• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Experience in working with Tableau Desktop, Tableau Server, Tableau Online, and Tableau Reader in various versions of Tableau 2018.1, 10.5, 10.4, 10.0, 9.3 as a developer.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Experience in the maintenance and scheduling of Tableau Data extracts using Tableau server and the Tableau Command utility.
• Experience in creating Filters, quick filters, table calculations, LOD's, calculated measures and parameters.
• Combined multiple data sources using data blending in Tableau to keep track of sensor data, operator inputs, and real - time systems all in one dashboard.
• Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-down menu option and Parameterized views using Tableau.
• Created solution driven dashboards by developing different charts types including cross tab's, Heat/Geo/tree maps, pie/bar charts/circle views/Lines/Area charts, Scatter plots, bullet Graphs, Histograms, and Highlight tables using show me functionality.
• Knowledge in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Exported Data using two new JavaScript API that enables programmatic access to data in the visualization.
• Knowledge on data extraction, transformation and loading data from various sources like Oracle, and Flat files.
• Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Working on Tableau Desktop - Connecting to multiple data sources, building quick views, advanced filtering, Sorting, Groups, Hierarchy, Create Sets, Actions, Table Calculations and using necessary Parameters, Data Blending.
• Understanding of Data warehouse concepts such as Dimensional modeling, slowly changing dimensions, Star and snow flake schemas.
• Responsible to Deliver Proof of Concepts using AWS, understanding customer business requirement.
• Good understanding in AWS solutions like EC2, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups.
• Worked on AWS EC2 Instances Provisioning, VPC setup, Auto scaling for availability of EC2Instances and availability of applications.
• Managed and reviewed huge Hadoop log files. Created data model for tableau.
• Tableau experience in designing Interactive Reports and Data Visualization using Tableau Desktop.
• Experienced in Developing Tableau Reports and Dashboards from multiple data sources using Data Blending.
• Worked with Microsoft Tableau, Data Zen, DAX expressions, Power View and Power Query integrated with SharePoint
• Assist in creating strategy for SharePoint Online (business process improvements, workflows, forms, BCS/WCF integrations, mobile accessibility, etc.
• Translated business logic from one system (SQL, Excel, etc) into Alteryx in a quick and accurate manner.
• Used Python to import data and perform data cleaning and integrated it with Tableau to build visualizations.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers etc.
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Proficient in Power BI, Tableau, Qlik and R-Shiny data visualization tools to analyze and obtain insights into large datasets, create visually powerful and actionable interactive reports and dashboard
• Hands-on experience with discovering, analyzing, and identifying key elements in the data thereby communicating the insights, trends, and future forecasts that impact consumer behavior

TECHNICAL SKILLS:

Languages: Python, R, SAS

Operating Systems: Windows, Linux, UNIX, and Mac OS

Database: Oracle, MySQL, Mongo DB, Cassandra

Tools: NumPy, Pandas, Scikit-learn, Tensor Flow, NLTK, ggplot2

Reporting Tools: Tableau, Power Bi

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence, Development Studio, SSMA ETL Tools Data Stage, SSIS, Informatica

Database: SQL Server 2012, MS Access, Sybase, MongoDB, MS EXCEL

Programming SQL, T: SQL, HTML

Other Tools: Azure, MS Office Suite (Microsoft Word, Power Point, MS Visio, Excel), Active Directory, MS Visuals

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr. Tableau Developer

Responsibilities:

• Designed, developed, maintained Tableau functional reports based on the requirements of the user.
• Experience in design and development of Tableau visualization solutions.
• 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 (10.5, 10.4/10.3/10.2/10.1/9.3/9.2 ). and Tableau
• Experienced in creating the groups, users, workbooks and also permission sets for the tableau server logons and checks
• Hands on development in assisting the users in creating the worksheets and also modifying them and data visualization dashboards.
• Designed, developed and tested various Tableau/Tableau visualization for dashboard and ad-hoc reporting solutions.
• Preparing Dashboards using the calculations, parameters in the Tableau and creating SQL datasets for Tableau and Ad-hoc reports.
• Expert on creating the report schedules on Tableau server.
• Developed story telling boards in desktop and published in to the server which allowed users to understand the data with the filters when they needed certain information.
• Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes) using Tableau
• Created python script for creating data source as.tde files.
• Extensive experienced in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Proficient in developing Entity- relationship diagrams, star/snow flake schema designs and expert in modeling the transactional databases and data ware house.
• Provided production support to Tableau users and written custom SQL to support business requirements.
• Blended the data from the different databases in to one report by selecting the primary keys from each database for the data validation.
• Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, transformation and load ETL routines for migrating data from non - relational or source relational to target relational.
• Involved in creating the ad hoc analysis and reporting requests in a timely manner for BML Risk related to the fraud approvals, yearly, monthly and daily.
• Mastered the ability to design, develop and deploy effective dashboardsand also rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters, actions using Tableau.
• Installing Tableau Server in an enterprise level for substantial number of Global users with a Governance principle.
• Involved in reviewing the requirements and data sources from the MS Excel for the design, development, production of reporting and the analysis projects within Tableau Desktop.
• Worked extensively with Advance Analysis Actions,LODs (FIXED, INCLUDE, EXCLUDE) Calculations, Parameters, Background images, Maps.
• Involved in Trouble Shooting, Performance tuning of reports with the huge queries using query execution for better performance and resolving issues within Tableau/Tableau Desktop/Server Reports.
• Tested dashboards to ensure data matching per the business requirements and any changes in the underlying data.
• Perform Linux scripting to move the files from one location to other

Confidential, Rockville, MD

Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Interactive data visualizations in Tableau desktop and providing BI Solutions to the management for strategic decision making.
• Experience working on Tableau Desktop - Connecting to multiple data sources, building quick views, advanced filtering, Sorting, Groups, Hierarchy, Create Sets, Actions, Table
• Calculations and using necessary Parameters, Forecast, Trend lines, Data Blending.
• Analysis of sales for each group/department, over different dimensions like Region, Units, Organizations.
• Creating dashboard that navigates to the Detail dashboard for specific drill down Analysis.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on clients need.
• Developed donutcharts and implemented complex features in charts like creating bar charts in tooltip.
• Hands on building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's
• Tableau administration and development roles and helping the client with the issues of data connections, extraction and maintenance.
• Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
• As a Tableau Developer I was responsible for the design, development and production support of interactive data visualizations used across the company.

Environment: Tableau Desktop 8.2 and 9.0 Tableau Server, DB2, Oracle SQL Server, Teradata, MS Access

Confidential, Tampa, Florida

Data Analyst/ Tableau Developer

Responsibilities:

• Involved in gathering, analyzing & translating business requirements into analytic approaches.
• Analyzed and processed complex data sets using advanced querying, visualization and analytics tools.
• Developed subject segmentation algorithm using R.
• Developed pipelines for test data.
• Handled importing data from various data sources, performed transformations using Hive, Map Reduce, and loaded data into HDFS.
• Used Statistical methods to analyze the performance of each clinical site for forecasting number of days to reach the target number of sites for a clinical study.
• 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.
• 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.
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• 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.
• Worked on Tabcmd to schedule the report's and setup email reports using command lines.

Confidential, Waltham, Massachusetts

Tableau Developer

Responsibilities:

• Interacted with the business users and business analysts to gather the requirements and worked on requirement specification document to build the reports accordingly.
• Closely worked with the data team for data requirements with respect to reporting needs.
• Created Dashboards and reports using Tableau.
• Created custom Geo-mapping, Bullet charts, Bars and Stacked bar charts, line charts, text tables, bubble charts, pie charts, scatter plots, header metrics etc.
• Managing projects, data sources and extracts on tableau server.
• Used advanced functions such as table calcs and LOD (level of detail) calculations wherever required.
• Defined best practices for tableau environment to standardize maintain consistency and improve efficiency.
• Publishing dashboards as tabs to group dashboards for every program.
• Comprehensive tableau testing for reconciling measures and other values between database and Tableau environment (views and dashboards)
• Reviewing and suggesting improvements for dashboards and visualizations developed.
• The project has many filters viz., context filters, quick filters (cascading filters) and traditional filters etc.
• Blending multiple data sources to allow for different views on application data in a single dashboard.
• Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• 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 stakeholders and business groups.
• Stories have been created to give Quick over-view of the selected category, and the story contains corresponding dashboard as well, for further analysis by the user.

Environment: Tableau Desktop 8.0/9.1, Tableau server / Administrator, SQL developer, SQL 2012,Oracle 11g, DB2, MS SQL Server Integration Services, MS SQL Server Reporting Services, JavaScript API, Microsoft Excel, MS Access.

Confidential, Sioux Falls, SD

Tableau Developer

Responsibilities:

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a state.
• Developed customized calculations when required.
• Designed and created MicroStrategy reports, objects (Attributes, Filters. Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Worked on drill through reports by creating HTML references.
• 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.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Installing JDBC SAP HANA driver for the connection and extracted data into Tableau.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau Server 8, Tableau Desktop 8, SAP Hana, SQL BI Suite (SSIS, SSRS, SSAS), Visual Studio 2010, Windows, Jira.

Confidential, Aberdeen, SD

Tableau Developer

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.
• 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.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Combined views and reports into interactive dashboards in Tableau Desktop that 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.
• 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.
• Developing complex T-SQL queries, common table expressions (CTE), stored procedures and functions used for designing SSIS packages.
• 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 stakeholders and business groups.

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