Data Server

RATNA BHUSHAN

PHONE-571-***-****

Email: ******.**@*****.***

PROFESSIONAL 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 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 PeopleSoft Suite.

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 in Profiling and analyzing data during the Report development.

Hands on experience of implementing end-to-end BI solution using Tableau.

Experience of leading large team in onsite model or onsite-offshore model 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.

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

Informatica 9.1,8

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

People Tools

: People Tools Application Designer, 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:

TOYOTA, CA 04/16 – Till Date

Role: Sr. Tableau Developer

Responsibilities:

Gather and analyze the business requirements and then translate them to technical specifications.

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

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Implemented Responsive web design by using Vertical and Horizontal containers in dashboard.

Used Table Calculations, Parameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards.

Environment: Tableau 9.3/Tableau Server, Oracle, HTML5, CSS3, JavaScript and D3.js, Tab jolt, Windows Server 2008 R2.

American Airlines,TX 01/15 – 03/16

Role: 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.

Responsible for Deploying and Maintenance of dashboards on Tableau Server.

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, Tab jolt, Windows Server 2008 R2.

Southwest Airlines, TX. 07/ 13 – 11/15

Role: 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.

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.

Exxon mobil, TX 09/12 – 07/13

Role: 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 and

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.

IBM, HYD, INDIA 09/08 – 08/12

Role: Sr. Informatica Developer

Responsibilities:

Involved interactively with the business units to understand the requirements and gather the feedback during the design, development and testing of solutions.

Worked on various data sources such as Oracle, DB2 UDB and flat files.

Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.

Wrote SQL Queries as part of Data validation in the Target tables

Created the Scripts to process the business logic from the Landing Zone to the Common Staging Area(CSA)

Created the Email task notifications to notify the error messages and also used the command task to run the BTEQ scripts in the workflow monitor.

Created Dimension Tables and Fact Tables based on the warehouse design.

Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.

Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.

Having brief practical knowledge on Power Exchange Navigator, Power Exchange Bulk Data movement, power exchange change data capture.

Worked on utilities like FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.

Created mapplets and reusable transformations.

Creating sessions and batches to run with the logic embedded in the mappings using Informatica Power Center Workflow Manager.

Used Informatica features to implement Type I, II changes in slowly changing dimension tables.

Conducting debugging sessions and fixing invalid mappings.

Designed and developed UNIX Scripts to automate the tasks.

Used the different types of transformations in Informatica such as Source Qualifier, Look up, Router, Joiner, Union, Aggregator etc.

Created necessary Repositories to handle the metadata in the ETL process.

Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.

Strong in UNIX Shell and PERL scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Maestro, Control-M.

Done the Unit testing after successfully loading the data into Landing Zone (LZ) area.

Environment: Informatica PowerCenter 8.6, Oracle 10g, Flat Files, Toad, SQL, PL/SQL, UNIX Scripting, Teradata13.1, Teradata SQL Assistant, MLOAD, FASTLOAD, TPUMP.

Contact this candidate