SUMMARY:

• 10+years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools
• Extensive experience with design and development of Tableau visualization solutions.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau reader in various versions of Tableau (7.x/8.x/9.x) and VizQL, SQL, PL SQL and UNIX shell scripting.
• Experience in business process analysis/modeling, business requirements, and developing High level Designs and Prototypes for Business applications.
• Support and maintain Project Data Models at multiple levels of detail and functionality (conceptual, logical, physical and subject - level) in developing star schema and snowflake schema.
• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Efficient in identifying and analyzing Business requirements from documents and end-user discussions and deliver the data requirements necessary to support DW subject areas.
• Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Proficient in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Good expertise in building dashboards and stories based on the available data points.
• Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
• Harnessing best ways in designing stunning visualizations using tableau software, publishing and presenting dashboards on web and desktop platforms. Trouble Shooting skills, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and sequel server reporting services(SSRS).
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Working knowledge of ODBC, OLEDB, T-SQL, SQL, PL/SQL, Teradata, Stored Procedures, Functions, Packages, Triggers, and scripting languages.
• Well-versed with Microsoft Office Suite including Office365, Lync, MS Visio, MS Access, Project, Power Query, PowerPivot, DAX, SharePoint, and SharePoint Designer.
• Widespread knowledge in using report building tools like PowerBI, Tableau, Spotfire and Qlikview.
• Experience in working at various levels of software development cycle such as Analysis, Designing, Developing, and Testing & Implementation of business applications in Client Server / Relational Database Management environment for Windows Platform.
• An empathetic listener and persuasive speaker with excellent written and verbal skills.

WORK EXPERIENCE:

Confidential - Houston, TX

Tableau Developer

Responsibilities:

• Involved in generating proper data in excel for Tableau Dashboard.
• Gathering business requirements from various users of different Departments.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Extracts data from multiple database to create Tableau Dashboards.
• Involved in installation and patch up gradation of application on servers.
• Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Effectively use data blending features in tableau for developing data reports.
• Define and develop best practices for Tableau report development.
• Administer user, user groups, and schedule instances for reports in Tableau.
• Execute and test required queries and reports before publishing.
• Responsible for efficient timely backups, project, groups' creation.
• Scheduled for auto refresh of dashboards on the application server.
• Design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using Tableau.
• Create side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Coordinate with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.
• Provide support for Tableau developed objects and understand tool administration
• Skillfully Used Link Tables utility to update Access table to reflect the Excel changes.
• Skillful at creating multi-level hierarchy in Tableau Dashboard.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations. Recommended Dashboards per Tableau visualization features.
• Efficient at using Parameter in calculation field to give flexibility to end user.
• Created different kinds of actions to make the worksheet invisible while there is no selection.
• Skillfully created different kinds of actions for navigation and drill down.
• Created custom color pallet, custom shapes to use in dashboard.
• Work in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Environment: Tableau Desktop 9.2, 8.1/8.2, Tableau server, Oracle 10g, SQL Server, SQL developer, SQL Microsoft Excel.

Confidential - Cincinnati, OH

Tabelau 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 was 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.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were 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.
• 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.
• 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.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Actively participated in clarification meeting with the Clients.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Developed business process and technical design documentation for each reporting service developed in this project.

Environment: Tableau Desktop (9.0 - 9.0.3), Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential

Tableau Developer

Responsibilities:

• Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
• Involved in designing and creating Dimensional Data model (Star schema) for Dodge Global Network application and ENR Survey reports.
• Worked with CIO of the organization in gathering the requirements to create Project/User Usage
• Executive Dashboards, International DR's Usage reports for Sales Executives.
• Developed complex data visualization reports and dashboards related to User Activities, Trends on DGN application and Dodge Market Share, Build Share and Spec Share using multiple large volume data sources.
• Created various Data migration monitoring and Mark Logic feed reports to help customer support teams.
• Created Project planning and Defect tracking reports which help Management to keep track of budgets and Project releases.
• Extensively used Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, Maps etc.
• 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.
• Worked on creating multiple data connections and created run book designs.
• Experience in Requirement Analysis, Gap Analysis, Change Management and Impact Analysis, Capacity.

ENVIRONMENT: Oracle9i/10G, Pl/SQL, SQL, SQL developer, UNIX (Putty), Tableau 7.x

Confidential - Austin, TX

Tableau Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of client requirements.
• 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.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Responsible for upgrading the Tableau 7.0 to Tableau 8.2.
• Installing and configuring of Tableau worker servers.
• Created views in Tableau Desktop that was published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Effectively used data blending, filters, actions, and hierarchies feature in tableau.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Projected and forecasted future growth in terms of number of customers indeveloping Area Maps to show details on which states were connected the most.
• Tableau server maintenance, Tableau server backup activity.
• Created users using Tableau Admin and assigning privileges to create report/publishing reports to server.
• 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.
• Enabled the data security filters for the users/groups in an AD.
• Tuned the reports performance using Cache options / Timely refreshes of data.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Responsible for creating /delivering monthly reports to business users.

ENVIRONMENT: Windows Server 2012, Tableau Desktop 8.2/8.0/7.0, Tableau Server, SQL Server 2008/2012, PL/ SQL, MS-Access, MS Excel and JavaScript.

Confidential, SFO, CA

Tableau Developer/Admin

Responsibilities:

• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams and created Technical Design Document from the functional specification documents.
• Utilized Tableau Analytics to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value.
• Designed a Tableau Architecture and installed Tableau on Cloud based on number of Business Users.
• Generated visuals in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Design and deployed rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau and provided these visuals in Tableau online and Reader to Stake Holders.
• Generated context filters and used performance actions while handling huge volume of data.
• Created multiple Adhoc dashboards in Tableau in order to represent the status like strength and weakness etc. for the business users at a glance.
• Created dashboards for financial department such as accounts payable, accounts receivables, Cash management and Asset management for Finance Team.
• Developed dashboard related to Asset management department for asset category and subcategory, depreciation and asset retirement.
• Worked on Python scripts to convert CSV files to flat files to ingest the data for ETL.
• Worked on Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).
• Created tables, views, materialized views with indexes in SQL Server to tune the performance.
• Installed and Monitored of Tableau Server (Dev and Prod) on AWS Environment.
• Installed the Tableau Server on the EC2 instances and configure the instances as primary and worker servers.
• Implemented AWS security features in Tableau Server to enable a single report or dashboard to securely serve the needs of a broad and diverse user base, including both internal and external users
• Created incremental refreshes for data sources on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tab admin and Tab CMD commands in creating backups and restoring backups of Tableau repository.
• Created report schedules, data connections, projects, groups in Tableau server.
• Administered users, user groups, and scheduled instances for reports in Tableau.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Used Java Script API to customize the views, selects, filters, date and time.

ENVIRONMENT: Tableau 9.0, Tableau v8.2 (Tableau Desktop, Tableau Reader, Tableau Online and Tableau Server), Oracle12g (SQL, PL/SQL), SQL Server 2008, Python 2.7.

Confidential

SQL / Tableau Developer

Responsibilities:

• Complete administration of MS-SQL Server version 7.0/MS SQL 2000.
• Migration of databases from SQL7.0 to MS SQL 2000 wherever required
• Provided 24/7 Support for Production, Development & Test Servers of MSSQL Servers.
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLAP systems.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Generated periodic reports based on the statistical analysis of the data from various time frame using Tableau.
• Performed Database backups (operating system, flat file backups & export/import).
• Tuned SQL statements (e.g.: - Using Indexes) and PL/SQL Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Designed & created Reports using Report Builder in Developer 2000.
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Handled corrupt databases diagnosed and repaired them.

ENVIRONMENT: SQL Server 11.0/2012, T-SQL, Query Analyzer, Windows 2012/NT 6.2 Server, MS Office 201/14.0, Crystal Reports, Tableau 8.1.