PROFESSIONAL SUMMARY:

• 7+ Years of experience in Business intelligence application design, development and administration of various data warehousing projects using Tableau and Tibco Spotfire.
• Experience with creating Complex Tableau and Spotfire Dashboards, Maintaining the existing Dashboards, Reports and Administration activities
• Expertise in SDLC Process that involves Requirements gathering, data analysis, prototype design and deploying the dashboards/Solutions into Production.
• Expert in designing Tableau dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Created multiple visualizations, calculated columns, LOD s sets, groups and drill down techniques for detail analysis using actions.
• Experience with Tableau server, Publishing Dashboards, Setting up permissions, Subscriptions and alerts and worked on TABCMD and TABADMIN command level Utility.
• Building, Publishing Customized interactive reports and Dashboards, report scheduling using tableau server.
• Worked with implementing row level security and user filters in Tableau.
• Worked on designing dashboard / reports /and Build KPI metrics that give better understanding of data and outliers and professional looks using Tableau.
• Worked on ETL Tools Informatica Power center Designer and good understanding of data warehousing, tart schema, Fact and Dimension tables.
• Expertise in Data Warehouse and Database development skills using Oracle SQL, Teradata, MS SQL Server, Hadoop Hive and Netezza.
• Created Complex Information Links to pull the data from DB2, Oracle 10g/11g, SQL Server, and Flat files, Hadoop Hive and SAS datasets.
• Developed reports using Spotfire Professional and published the same to Spotfire Server for Business Users use.
• Designed and deployed reports with Drill Down, Drill Through and Drop - down menu option and Parameterized and Linked reports using Spotfire
• Capable of Understanding the business environment and translate business requirements into technical Specifications.

TECHNICAL SKILLS:

Operating Systems: MS Windows 2000, XP, Vista, MS 2003 server, UNIX

Language: SQL, Iron Python, R, JavaScript, HTML and XML

Spotfire: Spotfire Professional 5.0, Spotfire web player

Business Intelligence: Tableau 5.0,6.0,9.0,10.3,10.5

Databases: Oracle 9i/11g/12C, SQL Server 2005/2008, MS-Access, IBM Netezza, DB2, Hadoop Hive

Other Technologies: Visio, MS Office (Word, Excel, PowerPoint, Project, and Outlook).

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Sr. Tableau Developer

Responsibilities:

• Gathered Requirements from Business users, analyze the requirements, perform data analysis, create wireframes and build complex Tableau Dashboards.
• Created SQL scripts with multiple joins and filters to extract the data from the databases like Oracle 12C and Netezza and connected Hadoop Hive and Tableau for representing big data.
• Worked on tabcmd command line tool for creating groups, add/remove users, create users etc.
• Creating Complex Visualizations Bar Charts, Line Charts, Combination Charts, Tree Maps, Pie Charts etc.
• Creating Visualizations with calculated columns, sets, Groups, Level of detail (LOD) s, filters, Actions and parameters and Table calculations in Tableau.
• Implemented Row level security to restrict the access to the particular user and user user filters. working with both live and tableau data extracts and published the dashboards on to the Tableau server and scheduling the dashboards.
• Modified the existing Tableau Reports and improved the performance of the Dashboards.
• Trained Business users on the Report Usage and make them to use more automated reporting services than excel reports.

Environment: Tableau 9.5, 10.0, 10.3, 10.5, Oracle 12C, Toad, Teradata, Hadoop Hive.

Confidential, Herndon, VA

Senior Data and Reporting Developer

Responsibilities:

• Gathering the requirements from business team and transmuting them into technical architecture and design documents.
• Involved in estimation, analysis and solution documents.
• Strong experience in creating sophisticated visualizations, calculated columns and custom expressions.
• Developed Line Chart, Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Calculated Columns, Parameters and Table level Calculations.
• Created Complex SQL scripts to pull the data from Oracle 10g/11g.
• Expert in Writing SQL Queries on Oracle and DB2.
• Created various Reports using Tableau and involved in Performance tuning.
• Created reports using complex calculations and variables.
• Implemented User level security to the Reports.
• Serve as a primary point of contact for Production Support issue resolution.
• Extensively worked with formatting the reports according to the user requirements.
• Developed Dashboard reports for Project portfolios which help in better analysis for decision making using Spotfire.
• Published the dashboards onto the Tableau server and worked with both live and tableau data extracts.
• Involved in migrating the dashboards from Development to Production environments.
• Documented the entire effort. The documents generated during the process were User Requirements Specifications, Peer Review Log, Design Specifications, Validation Plan, Validation Summary Reports, Release statement, Production Approval Form and Project planning documents.
• Analyze and document process along with quick resolutions for typical issues in production and which were critical to the process.

Environment: Tableau 9.0,9.5, Excel 2010, Iron Python, Oracle 11g, Toad

Confidential, Thousand Oaks, CA

Tableau and Spotfire Developer

Responsibilities:

• Gathered requirements from business users and performed data analysis and reporting solutions.
• Developed Spotfire Visualizations that has multiple data tables.
• Used data table properties, Property Controls, Filters, Joins and custom functions to get formulated data from information links.
• Worked on various visualizations like Bar Charts, line Charts, cross tables, Maps, Combination charts etc.
• Used Load on Demand to improve performance of Spotfire dashboards.
• Created configuration blocks in Spotfire and setting up guided analysis to carry the filter selections from one analysis to other.
• Created Information links, Parameterization, defined join rules in Information designer.
• Created Action Controls using Iron Python and Bookmarks in an analysis file.
• Worked on Tibco Spotfire Server, Web Player and Library administration.
• Created Complex Information links that involves multiple database tables, Joins and Filters.

Environment: Tibco Spotfire Professional 4.0,5.0, Spotfire Web Player, Spotfire server, Windows 2008 server, SQL Server 2008

Confidential

Associate Consultant

Responsibilities:

• Worked with Onshore team and understand the business needs and created Tableau Dashboards.
• Created Dashboards on Sales, Inventory, segments, ROI and Financial information.
• Extracted the data from various databases and combined them into a single Tableau dashboard using data blending and data joining.
• Created Actions, Parameters, Complex filters, calculated columns etc. in Tableau.
• Participated in the meeting and created technical design documents and prototypes in Excel or on a paper. wrote Complex SQL scripts to extract the data from various databases and performed data analysis and reporting.
• Participated in Code Gate reviews and moved the dashboards to production.
• Published the Tableau Dashboards on to the Tableau Server and provided access to the respective user groups.
• Created Tableau User groups and provided access using LDAP Authentication also automated the tableau reports using alerts and Subscriptions.

Environment: Tableau 6.0, Windows 2008 server, SQL Server 2008,Oracle 10g,SQL,MS EXCEL,MS Access