SUMMARY

• Working as Senior BI Tableau consultant with 8 years of IT experience software life cycle (Requirement Analysis, Design, Development and Implementation) and production support of large - scale projects.
• 4.6 years of Business Intelligence experience in utilizing Tableau to implement complex analytical solutions which access data from multiple sources.
• Worked on Tableau Desktop, Tableau Server, and SQL Server.
• Development of Finance, Telecom, Retail operations and Infrastructure Reports in Tableau 7.x/8.x/9.x
• Developed Tableau Reports from various entities like Financial, Transactions, Accounts, Performance, Telecom and Retail operations.
• Created reconciliation reports for operational department as part of Cost Operational Initiative Program.
• Creates high level view, clubbing transactions and financials at one stage, which allows the user to drilldown from day the transaction happened till the day the transaction been paid.
• Followed agile methodologies to develop Tableau dashboards.
• Experience inProfilingandanalyzing dataduring the Report development.
• Hands on experience of implementing end-to-end BI solution usingTableau.
• Experience of leading large team inonsite model or onsite-offshoremodel of project implementation
• Performed advanced analytics and developed Visualization using Tableau on Trading and Insurance Applications datasets.
• Designed, Developed, Tested the Tableau Dashboards and Administrating the Dashboards on Tableau Servers.
• Experience in performance tuning of Tableau Dashboards using Performance Recorder and Tabjolt.
• Used Tabjolt during tableau server migration from 8.0 to 9.0 and also used extensively to test the performance of dashboards.
• Capable of multitasking & prioritizing in a fast paced and agile work Environment.
• Having Experience in installing/Upgrading Tableau Server 8.0 to 9.0.
• Extract, transform and load data from multiple data sources into the Tableau application.
• We analyze data from Amazon Redshift instance with Tableau.
• Create, evaluate and select appropriate design alternatives which meet requirements and are consistent with standards and processes
• Experience in Data Warehouse Methodologies Star, Snowflake Schemas, Slowly Changing Dimensions (SCD’s) and Dimensional Modeling.

TECHNICAL SKILLS

Operating Systems: Linux, Unix, Windows, Ubuntu

ETL: Ascential Data Stage 7.1

Databases: Oracle 11g/10g, SQL Server 2008

BI: Tableau 8.0/9.0

BigData: Hadoop, Hive & Teradata

Tools: Toad, Oracle SQL Developer, Tableau Power Tools

Scripting: Python, Java Script

Job Control Tool: Autosys

Data Modeling Tool: Erwin, MS Visio

SQL Tools: BIDS Tools, Application Engine, Application, Integration Broker, PS Query and BI/ XML Publisher, People Code, C, C++, Java, HTML, xml, web services, Json & PeopleSoft HCM and FSCM

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Tableau Developer

Responsibilities:

• Worked with the Business users to understand the business and convert the business requirements into technical specification documents.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Increased extract performance by aggregating data and rolling up dates when creating extracts.
• Implemented Responsive web design by using Vertical and Horizontal containers in dashboard.
• Implemented content security for site, project, and object with windows AD integration.
• Created story points to provide clear insight of dashboard usage.
• Used Table Calculations, Parameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards.
• Implemented row-level security to define data access restrictions for users.
• Implemented security in Tableau workbooks by creating filter in workbooks and also implemented security at Data Extraction level.
• Created a TDE files to improve the performance of visualization calculation in Tableau Dashboards.
• Schedule TDE Reloads on Server and Troubleshoot errors and failures.
• Used JavaScript API to integrate Tableau visualizations into web applications.
• Used JavaScript for filtering the data displayed in visualizations with HTML controls in the page.
• Responsible for Deploying and Maintenance of dashboards on Tableau Server.
• We connect to the data from Amazon redshift instance with tableau.
• We used to build and scale Tableau server in cloud using Amazon EC2 instances in AWS.
• Optimized the dashboards in Tableau desktop using Performance Recorder and Analyzed dashboard performance on Tableau Server through Tabjolt, JMeter.

Environment: Tableau 9.0/8.0, Tableau Server Hadoop, Hive, HTML5, CSS3, JavaScript and D3.js, AWS, Tab jolt, Windows Server 2008 R2.

Confidential, Dublin, Ohio

Sr. Tableau Developer

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Setup and Administrating the Tableau Cluster Infrastructure and Perform upgrades.
• Used Data blending, Data densification and Data scaffolding features in Dashboards.
• Improved performance in dashboards by implementing context filters on dashboards.
• Wrote PowerShell scripts to automate the TDE file refresh on Tableau Servers.
• Used Table Calculations, Patameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards.
• Created Actions in Worksheets and Dashboards for interactivity in dashboard views.
• Performed Tableau Server administration activities like Site and Project creations and adding users and providing permissions to workbooks.
• Used Python scripts to assemble TDE files from a series of complex queries against our oracle database.
• Using data frames in Python we used to read data from Tableau.
• Provide dynamic selections of measures and dimensions in visualization by creating parameters and calculated fields.
• Implemented security in Tableau workbooks by creating filter in workbooks and also implemented security at Data Extraction level.
• Used Tableau Admin views to identify the performance issues on the Tableau workbooks.
• Created a TDE files to improve the performance of visualization calculation in Tableau Dashboards.
• Schedule TDE Reloads on Server and Troubleshoot errors and failures.
• Responsible for Deploying and Maintenance Tableau Dashboards on Server.

Environment: Tableau 8.0, Tableau Server, Hadoop, Hive, Java, Python, SQL Server, Toad, SQL, PL/SQL, PowerShell, HTML5, CSS3, JavaScript and D3.js, Windows Server 2008 R2.

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Developed dashboards in Tableau Desktop and published them on to Tableau Server that 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.
• Capable of multitasking & prioritizing in a fast paced and agile work environment
• Strong knowledge on Tableau server architecture and building TDE and Workbooks by applying business rules and data validations
• Schedule TDE Reloads on Server and Troubleshoot errors and failures.
• Responsible for Deploying and Maintenance of Tableau Dashboards on Server.
• Created a Data Models and Complex calculated expressions on Equity Data and publish on server to use by business users.
• Installed Tableau server in Prod, UAT, SIT, DEV environments.
• Create different Sites and Projects and implemented Workbook and data level security
• Developed Dashboards by using various TDE files and Refresh the Dashboards with Autosys jobs.
• Improve the dashboard performance by optimizing the calculations.
• Used Unix Timestamp conversion tools to convert date time format.
• Strong SQL knowledge to write complex Queries and also have strong Data Modeling Experience.

Environment: Tableau 7.0/8.0, Oracle 11g, SQL Server, Netezza, Toad, SQL, PL/SQL, UNIX Shell Scripting, Autosys.

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Designed ETL packages to deal with multiple data sources and load the data into target data sources by implementing multiple transformations using SQL Server Integration Services (SSIS).

Environment: SQL Server 2008, Management Studio, SSIS, SSRS Windows XP/7, MS ACCESS, MS EXCEL, Oracle 10g, PL/SQL Developer, TOAD, Unix

Confidential

SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2000, MS Access.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Visio
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Developed complex T-SQL code for the application.
• Worked in SQL server agent for job scheduling and batch queries.
• Installed and maintained MS SQL Server 2005
• Written SQL queries and stored procedures to generate data for reports.
• Involved in testing the triggers and procedures to be used in the production for optimization and improving the performance.

Environment: SQL Server 2005, Management Studio, Windows XP, Oracle 10g, Excel, PL/SQL Developer 1.1.3, TOAD, Unix