PROFESSIONAL SUMMARY:

• Working as Senior BI Tableau consultant with 7 years of IT software life cycle (Requirement Analysis, Design, Development and Implementation) and production support experience.
• 4+ years of Business Intelligence experience in utilizing Tableau as a full - stack Tableau Consultant to implement complex analytical solutions for high grown businesses.
• Development of Airlines, Telecom, Financial Reports in Tableau 7.x/8.x/9.x/10.x/2018.1
• Hands on experience in creating the Executive Level, Operational Level, Informational Level Hi-Tech data visualization dashboards.
• Mostly, worked as a liaison between the business and data team to architect the dashboards for executive level decision making. Those reports were consumed by the CEO, CIO, CTO, CFO & VP of Sales and Finance.
• Created reconciliation reports for operational department as part of Cost Operational Initiative Program.
• Extensive experience in creating database objects like tables,views,indexes,stored procedure,user defined functions using SQL Server 2008/14/16.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc using SSIS/DTS utility.
• 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 data visualization dashboards.
• Experience in Profiling and analyzing data during the Report development.
• Expertise with T-SQL in writing complex queries, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and maintaining data integrity.
• Extensive experience in creating database objects like stored procedures, views, tables, indexes and user defined functions using SQL SERVER 2008/2012/2014/2016 .
• Hands on experience working with Hi-Tech Data Visualization BI tools such as Tableau, Power-BI, Advance Excel.
• 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
• Designed, Developed, Tested the Tableau Dashboards and Administrating the Dashboards on Tableau Servers.
• Experience with installation, configuration and upgrading of Tableau tool across environments.
• Manage the applications Users, groups, and integration with active directory
• Experience in Tableau Migration and Scheduling as part of Tableau Admin roles.
• Experience in taking back ups and restoration of Tableau repository.
• 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 used extensively to test the performance of dashboards.
• Capable of multitasking & prioritizing in a fast paced and agile work Environment.
• Extract, transform and load data from multiple data sources into the Tableau application such as Informatica, Fivetran
• Extensively worked on creating the reports on large data sets into Tableau such as Million Rows Etc.
• Experience on connecting the Tableau with different data souces such as the Hadoop Horton-Works, AWS, SalesForce, Oracle, SQL Server 2012 R, HANA etc.
• 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, Informatica, FiveTran

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

BI: Tableau 8.x/9.x

BigData: Hadoop Horton-Works, Hive & Teradata

Tools: Toad, Oracle SQL Developer, Tableau Power Tools

Scripting: Java Script

Job Control Tool: Autosys

Data Modeling Tool: Erwin, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. BI Tableau Developer

• Worked with the Business users to understand the business and convert the business requirements into technical specification documents.
• Performed extensive GAP analysis in the project by interacting with business users
• Developed interactive dashboards for customer understand statistics summary about financials, market share & flight utilization, flight statistics, revenue per channel using Quick filters.
• Created Scatter Plots, Stacked Bars for top 10 and worst 10 flights in the period using context filter.
• Developed interactive dashboards for analyze customer response to new promotions effectiveness, acceptance, discontinuation, trend detections, seasonal forecasting and market intelligence.
• Fine-tuned SQL Queries for maximum efficiency and performance.
• Designed and developed various analytical reports from multiple data sources by blending data n a single worksheet in Tableau Desktop.
• 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.
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Used Table Calculations, Parameters, geographic mapping, Sets, Actions and LOD expressions for solving complex business issues and solved Optimize issues in Dashboards.
• Provide dynamic selections of measures and dimensions in visualization by creating parameters in addition, calculated fields.
• Optimized the dashboards in Tableau desktop using Performance Recorder and Analyzed Dashboard performance on Tableau Server through Tab jolt JMeter.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server From 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 security in Tableau workbooks by creating filter in workbooks and also implemented Security at Data Extraction level.
• Schedule TDE Reloads on Server and Troubleshoot errors and failures.
• Responsible for Deploying and Maintenance Tableau Dashboards on Server Providing Security.
• Create a TDE files to improve the performance of visualization calculation in Tableau Dashboards.
• Coordinating with Business Analyst in Validating report requirements.

Environment: Tableau 9.X/10.3.4/Tableau Server, Oracle, HTML5, CSS3, JavaScript and D3.js, Tab jolt, Windows 7.

Confidential, Irving,Tx

BI Tableau Developer

• 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.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• 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.
• 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 have strong Data Modeling Experience.

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

Confidential, SFO, CA

Tableau Developer

• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Used Actions extensively to link and filter sheets for easier navigation in Dashboards Interacted with business users to gather requirements and provided guidance for the Data Warehouse team in how to structure data for optimal use in Tableau.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau Desktop
• Create visually compelling and actionable interactive worksheets and dashboards.
• Involved in end to end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau
• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with MS SQL Server Databases.
• Different chart objects like Bar Chart, Line Chart, Text Tables, Tree Maps and Scatter Plot.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from SQL Server and MS Excel.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.

Environment: Tableau Desktop 8.1, Tableau Server, SQL server, MS Excel, Windows.

Confidential, San Ramon,CA

SQL Server / BI Developer

• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages
• Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Query Analyzer, SQL Server Profiler, Erwin 7.3/MS Visio 2007.