PROFESSIONAL SUMMARY:

• An astute technocrat with 4 years of experience in Software Design, Development, Implementation and Maintenance of Business Intelligence tools & applications
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8/9 and 10
• Adept in Requirements Gathering, Analysis, Design, Development, Testing and Production of reporting & analysis projects
• Diligent in end - to-end Software Development Life Cycle (SDLC), Agile methodologies, Iterative and Scrum
• Sound understanding of Transactional & Dimensional Data Modeling, Data Warehousing Concepts, and designing Star & Snowflake Schemas
• Experience in creating different visualization using Bars, Lines, Maps, Scatter plots, Bubbles, Heat maps, and Highlighted Tables.
• Well-versed in designing interactive Dashboards using drill capabilities using Filters and Dashboard Prompts.
• Skilled in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Reports.
• Tableau Experience in Enterprise Environment and as a Tableau Administrator worked on technical support, troubleshooting, report design and monitoring of system usage.
• Experience in writing medium to complex SQL queries, creating different SQL Objects, Fine Tuning the code, and also in using SQL*Loader for loading data into Data Warehouse/Data Mart.
• Rich experience in Test case design, Unit Testing, and User Acceptance Testing (UAT)
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills

TECHNICAL SKILLS:

BI/ Reporting Tools: Tableau 8, 9, and 10/ 10.0.2

RDBMS: Oracle 10g/11g/12c, SQL Server 2008

Data Base Tools: Hive, SQL Developer, TOAD, SQL*Plus, SQL * Loader, Neteeza

Languages: SQL, PL/SQL, HTML, XHTML, Java Scripts

Specialties: Data Visualization, Business Intelligence, Data Analysis

PROFESSIONAL EXPERIENCE:

Confidential, Walnut creek, CA

Tableau Developer/ETL Developer

Responsibilities:

• Gathered Business Requirements, Interacted with Strategic Development Team, Business analyst to analyze business needs and developed technical specifications.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Migrated various reports from excel to Tableau 10.X
• 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 the usage of quick filters for on demand-needed information.
• Generated tableau dashboards for sales with forecast and reference lines, Demographic Data for marketing teams and generated interactive dashboards with an implementation of Data blending on databases.
• Installation and configuration of Tableau server in cluster environment. Performing administration tasks such as creating and managing users, sites, groups, setting permissions, providing access to the users using user filters and adding them to the specific group.
• Created various Dashboards using various Custom SQL data and published them into the Tableau Server.

Environment: Tableau Desktop 10.0, Tableau Server 10.0.2, Hive, MS Excel

Confidential, Milpitas, CA

Tableau Developer/ETL Developer

Responsibilities:

• Performed business analysis, gathering requirement specifications, and project planning in UML.
• Conducted highly interactive JAD sessions with Account stakeholders such as users, QA Analysts, and Project Management Team.
• Generated reports using pivot tables in MS Excel.
• Developed use-cases for the system with special emphasis on defining Parent-child use case Hierarchy.
• Involved in end to end implementation and enhancements starting from requirement gathering and dashboards development in Tableau.
• Performed extensive Data Analysis both in the source system and Data Mart; as needed for the project requirements.
• Create mock-up reports for complex reports as needed.
• Created Technical design documents for documentation purposes.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Insurance App.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• 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.

Environment: Tableau Desktop 10.0, Tableau Server 10.0.2, Hive, MS Excel

Confidential, Farmington, CT

Tableau Developer/ Informatica Support

Responsibilities:

• Performed business analysis, gathering requirement specifications, and project planning in UML.
• Conducted highly interactive JAD sessions with Account stakeholders such as users, QA Analysts, and Project Management Team.
• Generated reports using pivot tables in MS Excel.
• Developed use-cases for the system with special emphasis on defining Parent-child use case Hierarchy.
• Involved in end to end implementation and enhancements starting from requirement gathering and dashboards development in Tableau.
• Performed extensive Data Analysis both in the source system and Data Mart; as needed for the project requirements.
• Create mock-up reports for complex reports as needed.
• Created Technical design documents for documentation purposes.
• Modeled and Developed database object structures (Tables, Stored Procedures) needed for the reporting purposes.
• 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 Database tables.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Insurance App.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them on 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.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Created complex MS Excel reports. Have used various functions like Vlookup, if statements, count if, concatenate etc.
• ETL job monitoring through Oracle db, Informatica ETL Tools.
• Providing detailed level analysis with of the failure to development team.

Environment: Tableau Desktop 8, Tableau Server 8, Oracle, 10g, SQL, MS Excel, Win Server 2008 R2, Active Directory

Confidential

Tableau Developer/Business Analysist

Responsibilities:

• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Created Data extracts for better performance and accessing data offline.
• Cleared errors according to business requirements in excel sheet and helped to create Documentation for the dashboards.
• Extracted data from different sources connecting them and used the same to create dashboard.
• Reviewed Business requirements and prepared the dashboards as per the requirements.
• Maintained reports and addressed data needs to provide reporting solutions.
• Analyzed the database tables and created database views based on the columns needed.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables) and Power point presentations.
• Worked with pivots, VLOOKUP, conditional formatting, large record sets. Including data manipulation and cleaning.

Environment: Tableau Desktop, Tableau Server, SQL, Microsoft office, Oracle 11g