SUMMARY

• Over 7 years of experience in Data Warehousing Business Intelligence Platforms and Expertise in Tableau 9.x/8.x, Oracle 11g/10g/9i, SQL Server, SQL, HTML, Web Based Technologies and Client Server Technologies.
• Worked on Datawarehouse environment like EDW, Data Marts and also on ETL andData modelingmethodologies (Normalization, Star Schema, and Snow Flake Schema).
• Experience in Installation, Configuration of Tableau, and Oracle on windows environment.
• Ensuring Data visualization Best practice, Design consideration for best performance in Tableau.
• Played key role in Performing Analysis, Design and development of multiple Tableau dashboards and deployed in multiple environment (Dev/Stage/Production).
• Extensive Experience in gathering requirements from business users and Product Owners.
• Experience working with a team in facilitating Brain storm sessions, Business gathering and implementation and worked closely with end users.
• Experience working with Star and Snowflake Schemas.
• Sound knowledge of RDBMS concepts, SQL (Oracle 11g/10g/9i, Sql Server 2008)
• Extensive Experience in Tableau working with Tableau Desktop, Tableau Server, Tableau Reader
• Experience using Tableau to create visually interactive reports, requests, filters, dashboards and workbook design.
• Hands - on experience in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau
• Tableau Administration user experience administering privileges, user groups and scheduled instances for reports.
• Proficient in Agile/Scrum and Waterfall Methodology, demonstrated excellent Organizational Skills and the ability to effectively handle multiple tracks of assignments.
• Worked as a team player and also as an individual contributor with good interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows (NT, 2000/03/XP/Vista/7)

Languages: SQL, PL/SQL

Reporting Tools: Tableau9.x/8.x/7.x

Databases: Oracle 9i/10g/11g, MS SQL Server2005/2008, MS Access

Utilities: SQL Developer, TOAD, SQL*PLUS, SQL Query Browser

Web Technologies: HTML, XML

Office Applications: Microsoft Office 2007/2003/2000/97 (Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential - Watsonville, CA

Sr. Tableau Developer

Responsibilities:

• Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents (BRD’s), preparing high level and low level design documents, Development, Support.
• Worked as a Lead on Roadmap projects as well as Tier 1 projects.
• Participated in Business Requirement Documents review, Functional Requirements Documents Data Model Reviews to understand the requirements and to prepare the necessary design documents accurately.
• Played key role in Performing Analysis, Design and development of multiple Tableau dashboards and deployed in multiple environment (Dev/Stage/Production).
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created solution driven Tableau dashboards by developing different chart types including Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, and Histograms in Tableau Desktop
• Created Tableau workbooks with calculations, parameters, Quick Filters.
• Worked on generating various Tableau workbooks and dashboards extracting data from various sources such as Oracle, SQL Server and data files using data blending and joins.
• Created parameters for Prompts in Calculations for various Tableau workbooks and dashboards
• Experience Implementing Proactive Tableau Environment Health Checks and Performance Threshold Alerting
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Created Tableau Scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps using show me functionality.
• Executed and tested required queries and data before publishing Dashboard to Tableau Server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Coordinated the DEV work efforts to offshore team.
• User Adoption training to the end-users on Tableau desktop.
• Followed AgileScrumprocess to streamline development process with iterative and incremental development.
• Performed Tableau administration function like Migration of Tableau Workbook and Dashboard from one server /environment to others.

Environment: Tableau 9.x/8.x, Oracle 10GR2, Toad 9.7.2, SQL*Plus, SQL Server 2008

Confidential - Palo Alto, CA

Tableau Developer

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Involved in creating database objects like tables, views, procedures, T-SQL to provide definition, structure and to maintain data efficiently.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created URL Actions to navigate from one Dashboard visual to another visual opened in a new browser window using separate TDE.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• Access dashboards from any browser or tablet.
• Involved in installation of Tableau desktop 7.0, Tableau server Application software
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended
• Deep experience with the design and development of Tableau visualization solutions
• Experience in Agile Development process.

Environment: Tableau 7.x, Oracle Database 10g, TOAD, SQL, Windows 2008 server

Confidential - Florida, FL

Responsibilities:

• Involved in Gathering Business Requirements for the Model and for developing reports from the business users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Analyzed the source data and handled efficiently by modifying the data types.
• Created tableau dashboards for measures with forecast and reference lines.
• Generated tableau dashboards with combination charts for clear understanding.
• Involved in creating a dual-axis bar chart with multiple measures.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Established Relationships and Joins between the query subjects of the Model
• Developed various reports using table's types like Table Across, Pane Down, and Pane Across.
• Enhanced reports with new features and functionality based on the business requirements.
• Developed List, Cross Tab, Chart and Drill through Reports in tableau.
• Worked on Cascading Filters page and implemented various parameters, filters, calculated table calculations, aggregations, specific conditions & created analytical reports.
• Developed many reports using the conditional variables according to the need of end users.
• Testing and improving report performance, performance tuning on complex reports on the report level.
• Worked on scheduling reports to run monthly, weekly and daily basis using scheduler

Environment: Tableau 6.0/6.x/7.x, Oracle 10g, SQL, PL/SQL, Toad for Data Analyst 2.5, Windows 2003

Confidential

SQL Developer

Responsibilities:

• Interacted with the Business Users and Supervisors to gather business requirements.
• Converted the User Requirements into Business Requirements Document, Functional and Technical Requirements Documents.
• Created Business Process Models from the requirement specifications.
• Worked on developing Tables, Views, Indexes, Stored Procedures, Triggers, Queries, and Macros using MS SQL Server and Oracle databases.
• Involved in Partitioning tables that have bulk inserts, deletes and updates to improve the performance.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Designed, programmed, deployed and tested the requested Reports.
• Developed Data Flow Diagrams, illustrating the flow of data from the legacy systems into the Application database Tables, along with checkpoints for testing verification.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
• Analyzed long running queries and tuned the complex queries to optimize application and system performance.
• Developed user test cases and validated test results during user acceptance testing.
• Assisted in test planning and execution. Created test plan for User Acceptance Testing.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: MS SQL Server 2005, MS Access, Oracle, SQL Server Integration Services (SSIS), SSRS Import & Export Data, SQL Reporting Services, XML.