PROFESSIONAL SUMMARY:

• A very good Experience in BI using Tableau and Tableau Server.
• Hands on experience in administering, deploying, and maintaining Models, Reports.
• Expertise in complete Life Cycle Development Process of a reporting solution that involved Gathering Business Requirements, Analyzing Business Needs, Documenting Business Information
• Utilized Best Practices and Proven Methodology in modeling data, ETL and other BI development process.
• Utilized the JavaScript API to create a customized portal for the property management group.
• Integrated Tableau dashboards into internal web portal using Java Script API
• Good Tableau Experience in Enterprise Environment and Tableau Administrator experience
• Including technical support, troubleshooting, report design and monitoring of system usage
• Extensive experience on building dashboards using Tableau.
• Involved in upgrading Tableau platforms in clustered environment and performing content Upgrades.
• Established Best Practices for Enterprise Tableau Environment and application intake and
• Development processes.
• Experience in Business Interacting directly with the client for Business needs.
• Working Knowledge of Tableau Servers, working with Tableau Data source Extract Schedules.
• Utilized features such as multiple tables, visualizations, drill down and other analytics reporting and analysis tools to deliver business insights.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Expert in designing Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Expert in designing Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Extensively worked on Power Center Client Tools - Designer, Workflow Manager, Workflow Monitor
• Expertise in Data Warehouse and Database development skills using Oracle SQL.
• Created SAS aggregates for ad hoc reports, issue resolution, compensation reporting, targeting analysis, business development, sales operations, and the analysis of market potential
• Extensive Working Experience in Testing for UAT testing and Production for Support through Tickets and Involved in Executing Scripts.
• Microsoft Excel skills include: VLOOKUP, Pivot tables, Index/Match, Filters, offset etc.
• Excellent analytical and problem solving skills
• Created Complex Information Links to pull the data from Oracle 10g/11g, Sqlserver, Flat files and SAS datasets.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Spotfire
• Administrator and restrict the group members to access only particular folders in the library as Library Administrator.

TECHNICAL SKILLS:

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

Language: SQL, Iron Python, R, C, C++, Java, JavaScript, HTML and XML

Tableau: Tableau 9.7.2, Tableau Reader, Tableau Public.

Spotfire: Spotfire professional 6.5: 7.0.1, Spotfire web player

Business Intelligence: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007, Tableau, Micro strategy, statistical Analysis tools/Engine TERR.

Databases: MySQL, Oracle 9i/11g, SQL Server 2005/2008 R2, MS-Access, Star and Snowflake Data warehousing schemas with (RDBMS, OLTP, OLAP).

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

PROFESSIONAL EXPERIENCE:

Confidential, Menomonee Falls, WI

Tableau Developer

Responsibilities:

• Developed Dashboard reports for Project portfolios which help in better analysis for decision making using Spotfire.
• Created Tableau dashboards using Stack Bars, Bar Graphs, Scattered Plots, Geographical maps, Gant Charts using show me functionality.
• Created Complex workbooks and Dashboards in Tableau by connecting to multiple data source (Teradata)
• Using data blending.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Extensively used Action Filters and Extract Connections to Develop Dashboards
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Hands on experience to extract, manipulate and built complex formulas in Tableau for various Business calculations.

Environment: Tableau 9.7.2, Tibco Spotfire Professional 7.0.1, Teradata , Iron Python .

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Worked and developed reports and analytic strategies for the Confidential s AML (Anti Money Laundering) Operations to help identifying alerts related to governance, risk and compliance
• Creating Complex Visualizations using Heat Maps, Pie Charts, Combination charts, 3D - Scatter Plots, Map Charts etc.
• Created Tableau dashboards using Stack Bars, Bar Graphs, Scattered Plots, Geographical maps, Gant Charts using show me functionality.
• Created Complex workbooks and Dashboards in Tableau by connecting to multiple data source (Teradata) Using data blending.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Creating dynamic Visualizations using Text Areas, Input Fields, and Property Controls, Document properties, using Prompts and calculated columns and custom expressions in Tibco Spotfire.
• Created Information Links for many databases for populating data into Visualization from underlying databases such as Teradata and Oracle etc.
• Worked on building complex SQL queries from scratch and also worked on performance tuning of queries for better performance.
• Created joins, Procedures, and Temp tables (AppWork Tables) as a part of business requirement.
• Optimized Information Links and queries to increase performance design and implementation of global, enterprise class Spotfire environment.
• Created derived elements, view filters as per requirement.
• Participated in business requirement document preparation.
• Designed and created dashboard reports for Executive Board of company
• Analyzed external and regulatory reporting, intercompany and internal management reporting needs of the business process.
• Maintained and updated dashboard reports as required by the business owners.
• Conducted and guided Spotfire BI application global roll out, managed QA Testing, User Acceptance Testing, software update, migration deployment and parallel run, stabilizing the server platform and application to achieve steady state for transitioning.

Environment: Tableau 9.7.2, Tibco Spotfire 7.0.1, Teradata , Iron Python .

Confidential, Columbus, OH

Tableau 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 Map Chart, Cross table, Bar chart, Tree map and complex reports which involves Property Controls, Custom Expressions.
• Created Complex Information Links to pull the data from Oracle 10g/11g.
• Expert in Writing SQL Queries on Oracle and DB2.
• Created the Materialized views on the aggregate functions and used that in the reports.
• Created reports using complex calculations and variables.
• Generated and implemented MicroStrategy reports by creating projects, Attributes, Hierarchies, Metrics, Filters, and Templates.
• Experience with Scheduling Tableau Extracts, working with Multiple Data sources using Data Joining and Data Blending.
• Created various complex SQL Queries, Stored Procedures, and User Defined Functions to implement the Business logic.
• Developed dashboards in MicroStrategy as well that provides users a highly graphical and summarized
• View of the key metrics.
• Created public objects like metrics, prompts, filters using MicroStrategy desktop.
• Providing training to Business users in Tableau.
• Designed search engine capability in Tableau.
• Experience in working with large amount of data using live connection.
• Good knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and
• Dashboards generated from various database sources.
• Serve as a primary point of contact for Production Support issue resolution.
• Extensively worked with formatting the reports according to the user requirements.
• Experience in creating MicroStrategy schema objects and Application Objects.
• Good knowledge in developing and designing reports through SSRS and Excel
• 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: Iron Python, Microstrategy, Humming Bird and SAS UNIX, MySQL, SAS enterprise 9.3, SAS Enterprise Guide 4.5, SAS (Base, Macros, SQL), SAS/Graph, SAS/Access, SAS/ETL, SAS/Stat, SAS/BI, SAS/ODS, Tableau 8.2 and BO.

Confidential, Emeryville, CA

Tableau Developer

Responsibilities:

• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• Extensively used Action Filters and Extract Connections to Develop Dashboards
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Hands on experience to extract, manipulate and built complex formulas in Tableau for various
• Business calculations.
• Created numerous dashboards in Tableau Desktop based on the data collected from Insurance App's by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Implementation of Row Level Security and performance tuning of reports.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Insurance App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Designed Dashboard Landing Page where most of the metrics are grouped into different planks
• Used data table properties, Property Controls, Filters, Joins and custom functions to get formulated data from information links.
• Worked on various visualizations like Tree Map, Box Plot, Parallel Co - ordinate plot, Scatter Plot & Map Chart.
• Created Information links, Parameterization, defined join rules in Information designer.
• Created Action Controls using Iron Python.
• Worked on Tibco Spotfire Server, Web Player and Library administration.

Environment: Tableau, Windows 2008 server, SQL Server 2008, SSIS

Confidential

Application Developer

Responsibilities:

• Worked on various visualizations like Tree Map, Box Plot, Parallel Co - ordinate plot, Scatter Plot & Map Chart etc .
• Created Information links, parameterization, defined join rules in Information designer.
• Used Load on Demand to improve performance of Spotfire dashboards
• Configured Spotfire server -Set up single sign on.
• Building Interactivity into Tableau Dashboards using Action filters, Summarized and Detailed Reporting Views.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Dealing with multiple data sources in Dashboards using Data Joining.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Analysed the Action logs to find what the users are doing, when they login, who did what etc.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using Teradata SQL Assistant.
• Using Spotfire and Tableau BI tools to build exclusive dashboards for the Business use and intractability.
• Creating dynamic Visualizations using Text Areas, Input Fields, Property Controls, Document properties, using Prompts and calculated columns and custom expressions etc.

Environment: Tibco Spotfire 5.5, Tableau, Windows 2008 server, SQL Server 2012