SUMMARY:

• Passionate, diligent and focused Engineer with around 5 years of experience in Data warehousing and Business Intelligence technologies along with around 3+ years of data visualization using Tableau.
• Expertise in Tableau 8, 10.x and IBM Cognos 8.x, 10.x.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Creation of metrics, attributes, filters, reports, and dashboards.
• Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Designed, developed and supported BI solutions, involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Having good exposure on Dimensional Data Modeling (Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables).

TECHNICAL SKILLS:

BI Tools: Tableau 10.x, Tableau 8.3, Cognos 8.x, Cognos 10.x, Talend (ETL) tool.

Languages: SQL, PLSQL, XML

Operating Systems: Windows NT/2000/XP/Vista.

Data platforms: DB2, Oracle, MS/Access, MS SQL Server 2014, MySQL.

PROFESSIONAL EXPERIENCE:

Tableau-Report Developer

Confidential

Responsibilities:

• Designed, developed and tested and maintained Tableau functional reports based on user requirements.
• Experience on tableau server administration including configuration, creation of sites, projects, groups, user and their permissions.
• Provided support for Tableau developed objects and understand tool administration.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualization and complex calculations to manipulate the data
• Design and develop rich Graphic visualizations with Drill Down and Drop-Down menu option and Parameters using Tableau.
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept.
• Published Workbooks by creating user filters.
• Experience with creating Worksheets and Dashboard.
• Experience in BI interactive Dashboard.
• Designed and developed standard reports, cross-tab reports.
• Pprepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports.

Technology stack: TableauDesktop10.3/9.3.0, Tableauserver/Administrator, Sleeper, SSIS, OLAP, Oracle10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Tableau Admin/Developer

Confidential

Responsibilities:

• Performing Admin activities like project management, migration of dashboards, creating schedules for extract refreshes and subscriptions.
• Developing data model to create reports and dashboards. Developing worksheets using parameters, calculated fields, groups, sets and hierarchies.
• Developing worksheets with assorted styles like bar, pie, tree map, dual axis, filled maps.
• Implementing the reports with best practices to improve the report performance.
• Creating rich dashboards using Tableau Dashboard and applying actionable insights.
• Interacted and worked with ETL team for improving performance on data from multiple data sources.

Technology stack: Tableau7.0/6.0, Tableau server, Oracle 11i, SQL, SQL*Plus, TOAD, Windows2003/XP, UNIX.

PL/SQL developer

Confidential

Responsibilities:

• Created and managed users, roles, groups, and database security.
• Created Triggers to enforce data and referential integrity.
• Analyzed database growth, space requirement and User/Login Roles.
• Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
• Experienced in Configuring and Managing Linked Servers, data transfer between SQL Server and another heterogeneous relational database such as Oracle and DB2.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion, conditional split and aggregate for creating SSIS ETL Solution.
• Used Transformations such as Union All, Merge and Breakpoints in SSIS.
• Used all types of container tasks such as for loop, foreach loop and sequence container in SSIS.
• Designed SSIS package to transfer data from various sources like text files, XML files, Excel, flat files to SQL server database.
• Created, monitored and troubleshoot errors in SQL jobs that import/export data between systems.

Technology stack: Oracle10g, Oracle FORMS/REPORTS (10g), Designer10g, Oracle, Application Server9i, EXCEL, MS Office.