PROFESSIONAL SUMMARY:

• 10+ years of total IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Retail, Manufacturing, Transportation, Banking, Service, Telecom, and Finance sectors.
• 6+ years of experience with Tableau Desktop, Tableau Server, Tableau Reader, Tableau Public.
• Experienced in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• Extensively worked on Tableau admin functionalities including Installations/ Configuration.
• Worked on Upgrades, Patches, Change management, Performance tuning, Standards and Best Practices.
• Worked on Metadata Management, Cluster/Distributed Management, Cache/ History Management, User Management, Scheduling.
• Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions 7, 8.1, 9.1, and 10/10.1.
• Expertise on all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of projects.
• Built and expanded reports available for both internal support and external customer reports, which included increasing the scope of data extracted and better utilization of reporting.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Proficient in Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000/7.0 , (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages, oracle supplied utilities
• Excellent understanding of Data modelling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
• Extensive experience SSIS, SSRS, PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Involved in the designing and Building of Universes, Classes and objects
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Set up Universe level conditions to restrict data based on report requirements.
• Developed and created classes with Dimension, Detail & Measure objects and developed Custom hierarchies to support drill down reports and created star and snow flack schemas.
• Worked extensively with the major functionality of SSRS ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues with inSSRS.

TECHNICAL SKILLS:

Business Intelligence: Tableau 7/8.1/9/9.3/10 , SAP Business Objects 3.1/XI R2/ 6.5/ 6.1X/ 5.X, Crystal Reports, Xcelsius, Data Services, Web Intelligence.

RDBMS: IBM DB2, Oracle 10g/ 9i/ 8i, SQL Server 2000/2005, Teradata 8.5/ 12, Ms Access

OLAP: Tableau 6.1/7/8/9.1/9.3/10 MS SQL Analysis 2000, Business Objects / XI R2/Xi3.0, ER studio, LCM.

Languages: C, C++, Java( J2EE), PL/SQL, SQL

Operating Systems: Windows NT, Windows 98/XP/ 2000/2003/2008 , Mainframes (MVS/OS390), VM ware, Citrix.

Project Management: MS Project, Oracle ADI 11.2, MS Access, MS Visio, MS Excel, and Lotus Notes.

ETL Tools: SAP BODS, Informatica and SQL Data Transformation Services.

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Sr Tableau Admin/Developer

Responsibilities:

• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users groups projects workbooks and the appropriate permission sets for Tableau server logons and security checks
• Worked as Tableau architect in standardizing Tableau for enterprise wide deployment
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• 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 accurately
• Wrote and modified various Stored Procedures used in the application using T SQL
• Schedule and maintain packages by daily weekly and monthly in SQL Server Agent
• Perform quality assurance checks and update databases to ensure data integrity
• Involved in preparing project plan of Tableau reporting on metadata of Informatica Analyst and Metadata manager. Provided initial estimation on data modelling and Tableau reports development.
• Involved in analyzing metadata of Informatica analyst and Metadata Manager. Worked on understanding tables and views relations.
• Involved in Glossary creation in Informatica Analyst and linking the Glossary in Metadata Manager Using enumerated Links to understand the data flow from source to target of Informatica power centre mappings.
• Involved in developing custom SQL queries in oracle to use in tableau reports development using tableau desktop.
• Created different visualizations using bubble charts, bar chart, pie chart, line chart, heat map and scatter plot.
• Conducted UAT on all the reports and worked on performance tuning of the reports by minimizing the simple filters and using action filters.
• Involved in tableau admin activities like creating user groups and AD groups linking, flagging workbooks which need to be deleted.
• Involved in creating business glossary, defining and creating business terms and categories, defining rules, usages, data stewards and owners for business terms.
• Performed data lineage analysis to determine how metadata for a business term is derived and viewing audit trails for business terms and categories.
• Involved in creating design documents for all the reports and conducted training sessions with all the end users.
• Involved in creating use cases document and test scripts documents for all the tableau dashboards.

Environment: Tableau Desktop 9.3/10, Informatica Analyst 10.1, Metadata Manager10.1, Oracle, SQL, Toad for Oracle 12.8 and MS Excel.

Confidential, Columbus, OH

SR BI/Tableau Developer

Responsibilities:

• Involved in Installation and upgrade of Tableau server and server performance tuning.
• Involved in user and content administration on tableau server.
• Responsible to ensure the daily operations support and maintenance. Performance related to Tableau infrastructure including System Maintenance, Security Administration, License Management, Troubleshooting Tableau workbooks and Performance Monitoring.
• Involved in reviewing business requirements and analyzing data form Excel/Oracle SQL Server for design, development, testing and production rollout of reporting and analysis projects with Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by colour that was broken into regions allowing business user to understand the customer distribution and density.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, MS SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• 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 quick filters to filter needed information.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Developed and created classes with Dimension, Detail & Measure objects and developed Custom hierarchies to support drill down reports
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Involved in creating web intelligence reports on top of universe.
• Involved in resolving user access related issues.
• Involved in supporting DB connections and universe related issues.

Environment: Tableau Desktop 8.1 & 9, SAP BO 4.0, Tableau Server, SAP BODS, MS Office Suite, Oracle, SQL Server R2, MS Excel.

Confidential, San Jose, CA

SR Tableau Admin/Developer

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active.

Confidential, San Jose, CA

Tableau Developer

Responsibilities:

• Involved in creating Tableau reports using complex custom SQL queries.
• Involved in designing new projects and execute them with minimal human resources.
• Created dashboards using multiple data sources.
• Administered Tableau server and helped in tuning of server.
• Involved in gathering information from clients.
• Worked with MySQL and optimization of SQL Queries.
• Created semantic/metadata layer in Tableau
• Created executive dashboard with KPI visualization (1-2 dashboards, 4-8 KPIs)
• Created underlying drill through detailed reports
• Created Wide variety of dashboards.
• Involved in creation of aggregated tables using OLAP data source (DW)
• Worked with customers, internal and external, to define and document the scope and functional requirements for data and reporting needs.
• Involved in backup of tableau server and optimization of server performance.
• Closely worked with manager for designing the requirements.
• Worked in integrating the tableau into mobile applications.
• Involved in analysing the existing XIR/2 environment with 2 node cluster, windows AD SSO enabled and with BODI.
• Involved in preparing sizing for SAP BO 4.0 (2 node cluster) and SAP BODS 4.1 servers with SQL server database.
• Used report conversion tool for converting 1300 Desk-I reports into Web-I reports. Converted as per department wise.
• Redeveloped all not converted Desk-I reports to Web-I in SAP BO 4.0
• Applied functional and formatting changes to partially converted reports in BO 4.0.
• Using Import Wizard and Upgrade manager migrated objects from XIR2 to BO 4.0.
• Involved in migration of universes, reports, users, groups and all the objects from XIR2 environment to SAP BO 4.0 environment.
• Involved in creating use security model for each department for data security.

Environment: Tableau Desktop v8, Tableau Server v8, SAP BO 4.0/ XiR/2, My-SQL, SQL server, Java, Excel, and CSV files.

Confidential

Sr BI Developer

Responsibilities:

• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creating web intelligence reports on
• Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.

Environment: Tableau Server v7/v8, Tableau Desktop v7/v8, SAP BO 3.1, web-i, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2.

Confidential

BO Consultant

Responsibilities:

• Provided inputs for Data Warehouse Design Considerations and Dimensional Modelling and Designed Factory Model approach for Both ETL & Report development Processes.
• Used Data Integrator Transforms PIVOT row level transformation as per reports requirement.
• Used Rapid marts to customize the Xcelsius dashboard (Standard Content)
• Deployed ETL objects from development to production and Quality.
• Used outer joins to retrieve the data and used self joins and sub queries to meet the report requirement. Involved in creation of performance management metric Universe, Metrics, Analytics and personal and corporate dashboards.
• Communicating with Business Users to understand and consolidate data warehouse requirements across functional areas like sales and finance
• Understanding the user Requirements and prepared Low Level Technical Specification documents for the entire Web-I reports.
• Involved in development of Web-Intelligence reports.
• Developed Business Objects universes
• Prepared test cases, performed Unit testing, documented the test results, involved in Code reviews.

Environment: SAP BO 3.0, BODI, Xcelcius 2005, UDT, SQL Server 2005, Microsoft Office, ODBC, Info-view, CMC, and CCM.

Confidential

BO Consultant

Responsibilities:

• Involved in assessing and planning an incremental migration
• Involved in creating a system backup during migration and used Import Wizard for migration
• Involved in analysing the Source & Destination environment and adjust the stage CMS and exported the content from Stage CMS to a BIAR file.
• Migrated data using the Import wizard and clustering CMS Machines and involved in scheduling objects
• Migrated BO Universes and reports
• Extracted XML report specs from BO environment using Macro add inns in BO
• Involved in resolving support tickets related to reports, universes and BO admin.

Environment: BO 6.X/5X, Supervisor, SQL Server 2000, Microsoft office, ODBC.