SUMMARY

• Over 7 years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms. Extensive Tableau experience in enterprise environment, in tableau 7.x, 8.x, 9.x as an analyst with in - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Expert in design, development & administration of Tableau Dashboards and servers in data warehouse environment.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Architected best practices in determining a live connection versus a Tableau Data Extract.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experience in creating the interactive dashboards using the various dashboard actions like filter, sizing, tiled, floating and URL.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option using Tableau.
• Experience on Tableau admin activities such as granting access, Tabcmd commands such as creating users from .csv, creating groups and adding users to groups, publishing a workbook.
• Extensiveexperience introubleshooting, performance tuningand supporting Business reporting platforms.
• Strong technical background with complete understanding of data warehouse modeling, architectures, OLAP, OLTP data sets.
• Created metadata dashboards with a quick filter by using metadata from TDS which drives the representation.
• Extensive knowledge in various reporting objects like attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters.
• Experience with designing dashboards for monitoring corporate KPIs while taking advantage of all tableau functions including data blending, actions and parameters.
• Published Tableau workbooks on Tableau Server with view permissions, scheduling and authentication features for refreshing the extracts on a particular schedule.
• Strong expertise in writing and updating simple and complex Packages, Stored Procedures, Functions, Views, cursors, indexes and Database Triggers using SQL and PL/SQL in Oracle.
• Ability to communicate business and technical issues to both business users and technical users.
• Excellent analytical and problem solving skills and can work independently as well as collectively & willing to relocate.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, Linux

Programming languages: C, C++, Java, SQL

Web Technologies: HTML, CSS, JavaScript, XML

Tools: Tableau, PL/SQL, Visio, SAP BO, SSIS, SSRS

Database: Oracle 10g/9i, MS Access, SQL Server

Others: IBM AS/400, MS Office Suite

PROFESSIONAL EXPERIENCE

Confidential - Boca Raton, FL

Sr. Tableau Developer

Responsibilities:

• Developed and supported reports that are needed to analyze business operations and processes. Gathered data to be used in the development of high-level analytics and quantitative techniques.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Generated Tableau dashboards with forecasting, Dual Axes and Reference Lines.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Worked on performing various dashboard activities such as grouping, sorting, ranking and ordering the data and using Tableau reports for various analysis Top - N Analysis, Comparative Analysis, Trend Analysis (Data vs Time).
• Developed SSIS packages using for each loop in control flow to process all flat files within folder, File System Task to move file into archive after processing and execute SQL task to insert transaction log data into the SQL table.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Conducted necessary ad-hoc data analysis and quantitative investigations for supporting business groups.
• Developed several Teradata SQL Queries using Teradata SQL Assistant for ad-hoc data pull request.
• Created customized reports with prompts and features like Conditional formatting, Master - Detail, Drill - through using Cognos Report Studio.
• Developed complex queries across various databases using MS Access to drive process automation and report development.
• Developed Cognos reports using Cascading Prompts, optional prompts and Report Bursting.
• Worked on optimizing and tuning the Teradata views and queries to improve the performance of batch and response time of data for users.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).
• Conducted user acceptance testing and mentored business users to slice and dice data using filters and parameters.
• Involved in Onsite & Offshore coordination to ensure the completeness of deliverables.

Confidential - Auburn Hills - MI

Tableau Developer

Responsibilities:

• Developed, organized, managed and maintained graphs, tables and document templates for the efficient creation of reports.
• Transformed the logic developed by Spotfire, OBIEE, WEBI reports into Tableau with enhanced data visualization.
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau Server.
• Created custom Function's Date range, Time functions, Logical functions in the reports.
• Created Filter and URL actions to navigate from the Executive Dashboard to the Detail Report and implemented the back button logic to navigate back to it.
• Generated Context filters and handled performance issues while dealing with huge volume of data.
• Setting user access, creating new Schedule's and checking the task's daily on the Tableau Server.
• Captured data source metadata from TDS for all data sources in house.
• Ensured the user security for the views using User filters and shared with business users.
• Worked on developing Tables, Indexes, Views, complex stored procedures, Triggers, Functions.
• Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts demonstrating key information for decision making.
• Published the developed dashboards into production and refreshed the scheduled extract, tuned the performance of the dashboard and created Tableau functional design document.
• Created performance analysis dashboard using Performance Analyzer and optimized the view which is taking more time in rendering/computing the raw data.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Created symbol maps to understand the geo-spatial distribution of projects with custom symbols to represent the application category.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Participated in the user requirement gathering and Design meetings. Translated business needs into reporting and analytic requirements.

Confidential - Southfield - MI

PL/SQL Developer

Responsibilities:

• Participated in design discussions with the application architects and suggest design changes for improved database performance.
• Back-end application development using Oracle 10g PL/SQL. Develop stored packages, procedures, and functions; create tables, views, constraints, foreign keys and indexes.
• Extensively used of advanced PL/SQL concepts such as collections and bulk processing to achieve best performance.
• Some data in the conversion process was provided by third party application in very large files. Used SQL Loader for loading these files in the database.
• Wrote UNIX scripts to automate the conversion process where various conversion processes were put together and called in an order. The process was monitored and it would provide online progress of the process.
• Involved in the analysis of Physical Data model for ETL mapping and process flow diagrams to develop Data mart design.
• Performed Oracle DBA tasks such as monitoring the database, creating users, granting roles and grants, application build, run conversion scripts.
• Used development tools such as Toad and SQL Developer for writing code and executing the queries.

Confidential

PL/SQL Developer

Responsibilities:

• Worked on SQL*Loader to Extract, Load and Transform data from varied data sources like Flat files and Oracle.
• Involved in Database Design and development.
• Designed Front-end interfaces and created reports as per the requirements using Forms/Reports 6i.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export.
• Dropped and recreated the indexes on tables for performance improvements.
• Performed Data Conversions and Data Cleansing.
• Worked on Packages to encapsulate procedures and functions.
• Performed Data Upload for all static tables using SQL*Loader.