PROFESSIONAL SUMMARY:

• An astute technocrat with 5 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,Hive

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

WORK EXPERIENCE:

Confidential, Sunnyvale, CA

Tableau 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, Shrewsbury, MA

Tableau Developer/ Business Analysist

Responsibilities:

• Extracted the business requirements from the end users keeping in mind their need for the application, and documented it for the developers.
• Gathered requirements for analyzing and designing multi-dimensional reports.
• Identified system integration requirement, coordinated, the collection and verification of business needs, use case models for the functional requirement.
• Involved in Lead contracting division team in JAD sessions for project needs assessment for process models.
• Interacted with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Converted the Functional Specs to technical design and designed the overall metadata development in Tableau.
• Creating dataflow diagram and documenting the whole data movement process.
• Modeled star schema for reporting as per the business requirements.
• Experience with creating Worksheets and Dashboard.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Created dashboards for Engineers to measure performance of their field engineers and manufacturer defects.
• Preparing Dashboards using calculations, parameters in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created role based dashboards by implementing data/row level security.
• Migrated reports and dashboard from development to test environment.
• Training classes to the employees on Tableau software.
• Setup Tableau Server to publish and distribute dashboards easily.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Working with Multiple data Connections.
• Assisted in mining data from Oracle database for specific reporting purposes.
• Updated mapping tables as per the functional needs.
• Provided support to business team by responding to ad-hoc data requests, answering questions, and providing technical support and analysis.

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

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