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 and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Extensive experience working as a Business Intelligence Consultant with specialization in Microstrategy.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Excellent understanding of Data modeling (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 in 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.
• Worked extensively with the major functionality of Microstrategy ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports .
• Professional in writing complex Formulas, Sub Reports, Summary Reports.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in MSTR.
• Installation, configuration and administration of Tableau .
• Deployed the reports and Scheduled Reports for the use of end users and customers.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Worked extensively with creating reports as per user requirements using MSTR.
• Extensive working experience in Packages, Procedures, Cursors and Triggers.
• Experienced in tuning Long running SQL queries for better performance.
• Expertise in using Version controllers like Clear Quest, Clear Case, SVN and PVCS.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

Languages : HTML, PL/SQL, XML, Java/J2EE

Applications : Oracle SQL Developer

Reporting tools: Tableau (Desktop,Reader,Server) V7.x/8.x, Microstrategy 9.0.1

Databases : Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008 R2, MS Access, Teradata

Operating Systems : Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Packages / Tools : MS Office, Toad, Putty.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• 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 like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle
• 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.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• 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.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• 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 SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v7/v8, Tableau Desktop v7/v8, Teradata, Oracle, Clear quest, Clear case, Excel, JAVA, J2EE,UNIX, Linux RHEL 5.4.

Confidential, Columbus, OH

Tableau Developer/ Analyst

Responsibilities:

• Involved in creating dashboards and reports in Tableau 7.1.
• Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Created incremental refreshes for data sources on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau server and documented upgrade plan from Tableau 6.0 to Tableau 6.1
• Created and assisted users in Tableau dashboard development.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in writing complex SQL queries using table joins (inner and outer).

Environment:: Tableau Server 7.0.1, Tableau Desktop 7.0.1, MYSQL Server, Oracle 11g, Netezza, Sybase, Crystal XI, Info view, Excel, JAVA, J2EE, Tomcat., TSQL.

Confidential

Programmer/Systems Analyst

Responsibilities:

• Developed Public Objects.
• Involved in requirement gathering and analysis.
• Developed Application/Public Objects such as Advanced Metrics (Dimensional, Transformation, Conditional, Ranking, Percentage, Count), Base Formula, Advanced Filters, Relationship Filters, Report Filters, Report Limits, Prompts and Custom Groups.
• Designed and Developed the Monthly, Quarterly and Yearly Reports and Templates (Standard and Ad Hoc).
• Created Browsing Hierarchy for providing drill down/up/across options for the Web users.
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Export Options, Prompt Ordering, Totals based upon the business.
• Worked with multiple databases, flat files and XML files.
• Created the test cases for unit testing and also involved in integration testing of the application.
• Involved in Unit Testing of reports and Dashboards, Data Validation for both report level and Dashboard level (Unit, SQL and Data Validation at UAT).
• Involved in UAT / QC Testing, Maintenance for the Business Users.
• All the Test Cases were created and executed in Test Plan and Test Lab modules of HP Quality Center.

Environment: MicroStrategy 9.0.2, Desktop, Web,Oracle