SUMMARY

• Over 8 years of IT experience in Tableau Desktop/Server.
• Expertise in writing Store procedures, SQL Queries, Dynamic - queries, and complex joins for generating
• Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
• Having strong analytical, logical, Communication and problem solving skills.
• Ability to adapt to new technologies by self-learning.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Strong Knowledge in COBOL with Program Structuring, Table Processing, File Handling, Subroutines & Database Interfaces.
• Experienced in using REXX programming in Control M (z/OS) for running Jobs & Batch processing.
• Worked as a Dedicated Team member, in a highly dynamic & pressure oriented environment with tight schedules and deadlines in an onsite/offshore delivery model infused by a distinct culture of customer satisfaction.
• Highly recognized at all jobs for my strong dedication towards work.
• Excellent analytical and collaboration skills. Adapt quickly changes, self-starter, self-motivated.
• Goal oriented professional possessing strong work ethics, interpersonal and communication skills. I am a fast learner of new and required tools and technologies.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Extensive experience working in Windows, LINUX environment.
• Extensive experience in development of DATAWAREHOUSING technologies.
• Knowledge on Google API development skills, SQL Server, ETL processes SSIS, SSAS and SSRS.
• Built dashboards to help reduction of Market budgets and increase ROI.
• Lead a small team when doing dashboards for analyzing internal marketing dept performance in ODM consisting Tableau.
• Experience including technical support, troubleshooting, report design and monitoring of system usage.

TECHNICAL SKILLS

Data Visualization Tools: Tableau Desktop 10 .X9.x/8.x/7.x, Tableau Server 8.x, 9.x, Oracle, SQL Server

ETL Tools: Informatica 8/9.x, ODI10g, SSRS, SSIS

Operating Systems: Windows 2000/XP-Pro/Vista/7/8/10

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, HTML 4.0

Database Tools: SQL Developer, PLSQL Developer, SQL* Plus, TOAD, T-SQL

RDBMS: Oracle 11g/10g/9i, SQL SERVER 2005/2008, DB2, Teradata, Netezza, Hadoop

PROFESSIONAL EXPERIENCE

Tableau Admin/Developer

Confidential, Fairfax, VA

Responsibilities:

• Mentored business power users to create reports/dashboards using tableau desktop.
• Used forecasting feature to provide predictive information to model future based on the history which added value to our project.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• 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.
• Utilized Alteryx for blending data from multiple databases to create a single Data source.
• Provided insights of Time series forecasting data analysis of weekly sales for regions and retail users using R and Tableau.
• Built predictive models for various research using R, including trend analysis, linear regression and logistic regression.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic datasets.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Experience in creating advanced Custom Filters by using Pass-Through Expressions in Micro Strategy. Expertise in creating interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.
• Built the DW environment using the Tableau and SQL server tables with Terabytes of Data. Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Developed various views in Tableau like Tree maps, Heat maps, Scatter plots, Geographic maps, Line chart, Pie charts, etc.
• Created Special technically directed documents for better acceptance of the reports.
• Created reports based on Claims Data and EMR data from the Medicaid data base.
• Created jump plots to analyze the company’s market.
• Created dashboards to analyze performances of different levels of sales teams in different places of market by using LOD calculations and table calculations
• Defined best practices for Tableau report development.
• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• As a part of internal usage, helped the company analyze staff performances by creating visualizations from the data stored in the form of ICD-9 codes and the CPT codes.
• Created report schedules on Tableau server.
• Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
• Find efficient ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Generated Interactive dashboards with filters, Parameters and Actions to handle views more efficiently.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic datasets.
• Experienced with different kind of Dashboard like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.
• 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 Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards. requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
• Created, Maintained & Scheduled various reports in SSRS like Drill down and Drill through & Parameterized Reports using SQL Server Reporting Services SSRS.
• Built, published customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Formatting from raw data into clean data, Updating and correcting clean data, and Input of data into database.
• Responsible for running SQL queries against Oracle database to generate reports.
• Identification of dataflow/workflow issues, as well as finding the source of the issues and resolving them.
• Analysing technical requirements and design new data models or update existing data models.
• Day to Day maintenance activities, Third Party Vendor Support
• Knowledge and work experience in RDBMS concepts
• Use z/OSDB2 NativeMainframedaily to perform DB2 DBA functions
• Experienced in z/OSmainframeenvironment using JCL and SQL.
• Created and updated JCL so jobs can be tested before they go into production. Use z/OSMainframedaily to perform DB2 DBA functions.

Environment: Tableau Desktop 10x,9x, Tableau Server 9, SQL Server, Oracle 10, Microsoft Office Suite (Word, Excel, Power Point), HP ALM. Tableau Desktop 8.x, Tableau Server, Windows Server Standard R2, Excel, Oracle, Hadoop)