SUMMARY

• Over 8+ years of professional experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.0, 8.1, 8.0, Tableau 7 and Tableau 6.
• Good knowledge of Relational database concepts and possess strong knowledge in writing SQL queries in Oracle, Teradata and MS SQL Server.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Expertise in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Strong experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Strong in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Experience in Tableau Server 8, online publishing, Sharing, and Tableau online.
• Created extract files for improving the performance. Have used different Mark types and Mark properties in views to provide better insights into large data sets.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proven ability in gathering customer behavior data from a wide variety of marketing campaign data sources utilizing statistical modeling tools to identify actionable insights for improvement.
• Expertise in different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading, and building Star schema.
• Good knowledge of System Development Life Cycle (SDLC), Agile (scrum) and Waterfall development environments.
• Strong analytical, logical, communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

BI Reporting Tools: Tableau Desktop 7.0/8.0/8.1,9.0 Public, Tableau Server, Cognos

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer, Visio and Sybase Power Designer.

Databases: Oracle 9i/10g/11g, MySQL, MS Access SQL Server, IBM DB2 UDB 8.0/7.0, 2008/2005/7.0/6.0 ,TeradataV2R5/V2R4/V2R3,Sybase 12.x/11.x

Programming: SQL, TSQL, PL/SQL, Unix Shell Scripting, Kernel Programming, Perl Programming, VB, Java, C, C++

Tools: Teradata SQL assistant, SQL Navigator, SQL Developer, TOAD 7.x, MS - Visio, HP Quality Centre, Rational Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, CA

Tableau Admin/Developer

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defining best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau
• Actively involved in business requirements gathering from end users and business analysts.
• Created visualizations reports on sales quotas, attainments and performance on various categories to ascertain the overall sales effectives of each program.
• Created stacked bars to show the quota and actual performance for each sales rep by region.
• Created report using dual axes to show the gap in performance.
• Responsible for analyzing functional Specs and preparing technical specifications per business needs.
• Created Executive Dashboard Scorecard that provides sales reps and sales manager performance KPIs.
• Created story showing the performance of each sales rep since sales territory assignment.
• Developed reports for different sales management hierarchies.
• Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• Implemented Data blending to pull data from disparate sources.
• Used joins and applied filters to limit the data sourced into report.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Reference Lines, box plots and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Created and Published Tableau Dashboards into Tableau Server.
• Worked with T-SQL and PL/SQL queries
• Write SQL queries for data validation and data integration where necessary.
• Created incremental refreshes for data sources on Tableau server.
• Work closely with DBA's and ETL teams to meet reporting requirements and improve performance.
• Evaluate live vs extracts connections based on data size and performance requirements.

Environment: Tableau 9.0, V 8 (Desktop, Server, Reader), Oracle, SQL Server, PL/SQL, TOAD

Confidential, San Diego, CA

Tableau Admin/Developer

Responsibilities:

• Worked in coordination with Clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement
• Created Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created complex Executive dashboards using Tableau Desktop that was published for the business stake holders for analysis and customization using filters and actions.
• Created dashboard using parameters, sets, groups and complex calculations.
• Implemented various data connections from data source toTableauServer for report and dashboard development
• Monitored VizQL server, Application Server and data server activity to track performance and system stability
• Developed actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Developed many reports with multiple data connections and performed data blending and created different visualizations like Bar Charts, Gantt Bar Charts, tree maps, bubble charts using complex joins.
• Created complex reports like Detail level Transaction report's, monthly Aging, YTD cash goal reports,
• Quarterly reports by creating multiple queries, sub queries, and merged dimensions, ranking features in single report.
• Worked with SSIS and SSRS for developing and extracting reports.
• Involved in creating guided navigation links for Interactive dashboards in Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Wrote T-SQL queries for database validation.
• Provided 24/7 production support for Tableau users.
• Involved in testing dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Participated in meetings, reviews, and user groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Reader, Tableau Server, Tabcmd, Oracle, MS Office 2007/2010, SQL Server 2008, Windows 7, Enterprise Manager, SQL Server Management Studio, Microsoft Excel.

Confidential - Minneapolis, MN

Tableau Developer

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 6.0 to Tableau 6.1
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill Through using Microsoft Reporting Services.
• Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems with different transformation and scheduled Jobs to run the packages on a daily basis.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Maintained and supported Microsoft Team Foundation Server (TFS) to allow for a secure code in a multi-team environment.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio. .

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, Oracle 11g, Toad, MS Office

Confidential - Bloomington, IN

BI Developer

Responsibilities:

• Created reports using prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio.
• Used Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Developed multiple Complex reports like Master-detail relationship, drill through, burst options and Cascading prompts using Report studio.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created Active reports using data deck, tab data button bar, Iterator and sliders.
• Created reports containing multiple data containers like List, Cross-tab and Repeater tables.
• Created dashboards for a managerial overview with drill up and drill down capabilities.
• Scheduled reports using Cognos scheduler and emailed to various recipients as required.
• Test/validate system tables/files in System Test, UAT and Production environment.

Environment: Cognos BI (Framework manager, Report Studio, Query Studio), Active Reports, Cognos Business Insight Advanced, Oracle 10g, TOAD.

Confidential

ETL/DW tester

Responsibilities:

• Involved in Preparing Test Plan and Test Approach.
• Participated in Requirement Analysis, Use-Case Analysis and Gap Analysis.
• Test Development was implemented under Agile/Scrum Methodology.
• Coordinated Daily meetings, Sprint Retrospectives and Scrum calls and Analyzed user Stories.
• Developed Test Artifacts for each Sprint.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix in IBM Rational Test Suite.
• Organized meetings for Test Plan Reviews and Test Approach Summary.
• Tested ETL jobs used for creating the warehouse using Informatica.
• Tested the ETL applications and ETL Process using Informatica.
• Developed Test Plans, Test Cases for ETL/Data Warehouse applications.
• Executed sessions and batches in Informatica and tracked the log file for failed sessions
• Validated Informatica transformation loading process by using SQL and PL/SQL
• Tested DW reports developed in Business Objects.
• Responsible for Backend testing and executing SQL queries
• Wrote extensive PL/SQL and SQL queries to validate conversion of data from the source warehouse tables to Confidential tables.
• Helped in testing and validating reports created using SSIS/SSAS
• Conducted Back-end Testing on Oracle database whenever necessary using SQL
• Queries via Oracle SQL Developer.
• Written queries in Access, TOAD, SQL Developer and Db Visualizer.
• Executed Test Scripts and Opened defects.
• Trained other testers and Communicated with development team regarding fix status and timelines.
• Used Clear Quest extensively for Defect Tracking, Creating Queries for Defect Reporting.
• Actively participated in walkthroughs, weekly QA status, Defects and SME meetings.
• Conducted Integration, System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT) and Performance testing.
• Responsible for the documentation of the whole Testing Process of Core Applications for future Acquisitions.
• Active Participation in Implementation Plan Reviews

Environment: Informatica, Business Objects, SQL, PL/SQL, SQL Developer, Advanced SQL, Oracle 9i, SQL server 2005, Db Visualizer, Java, J2EE, EJB, Java Scripts, Business Objects, FORTENT/Searchspace, KYC 3.2, Rational Clear Quest, Java, V.B 6.0, Oracle, DB2, MS Office, Windows XP