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 and Data modeling methodologies (Normalization, Star Schema, and Snow Flake Schema).
• Experience in Installation, Configuration of Tableau, and Oracleon windows environment.
• EnsuringData 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).
• Proficient in 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

Reporting Tools: Tableau 9.x/8.x/7.x

Database: Oracle 10g/9i/8i, SQL Server 2008/2005, MS - Access

Programming Languages: SQL, PL/SQL

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

Web Technologies: HTML, XML

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

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 forTableau server logons and security checks
• Worked a great extent with the design and development of Tableau visualizations which includes PreparingDashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Created solution driven Tableaudashboards 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 asOracle, 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 toBusiness 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.
• 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 Designprocess for various Sources and Targets.
• Involved in creating database objects like tables, views, procedures, T-SQL toprovide 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 browserwindow 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 LevelExecutives.
• 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

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 businessusers.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changesto 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 analysisand 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