SUMMARY

• 8 + years of IT experience as a Business Analyst and Business Intelligence Report Developer with expertise in data modelling, design and development of reports for different business needs.
• Extensive experience of 3.5+ years in working with Tableau Desktop and Tableau Server
• 2+ years of experience with Agile Scrum development of projects for implementing full life cycle of reports development.
• Expertise in interacting with Business Partners and domain experts for requirement analysis, project estimates, development life cycle, deployment and testing of various reports.
• Expertise in using various features of Tableau for providing quick POCs, dashboards and stories helping senior management and different clients for understanding data trends and patterns.
• Administered user, user groups, sites and roles in Tableau Server
• Extensive knowledge in various reporting objects like Hierarchies, Transformations, filters, calculated fields, Sets, Groups, Parameters etc., in Tableau Desktop.
• Experience in working with different data sources like SQL, Oracle, Flat Files, ODBC connectors, Teradata, IBM DB2, etc.
• Ability to use custom SQL for performance improvements using data reduction.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie - charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
• Experienced in developing rich interactive report, dashboards and other user interface elements integrating various reporting components from multiple sources.
• Profound knowledge of Data modeling including Star Schema and Snow Flake Dimensional Data modeling, 3NF Normalized Data Modeling. Very good understanding of Logical Modeling and Fine-tuned Physical Data Modeling.
• Involved in creation of logical and physical data models.
• Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Presented various reports to senior management and clients to analyze data trends and future forecasting options using Tableau.
• Good knowledge on Tableau JavaScript API in applying filters, switching tabs, chain calls, etc.
• Good experience in source control tools like SVN, Kiln
• Performed code reviews of peers using Crucible and sharing the comments on data model, reports calculations, etc.
• Expertise with Microsoft Office products in documentation, presentations and data validations
• Extensive experience in developing Unit, Integration and UAT Test plans and Cases and also has experience in generating/executing SQL Test Scripts and Test results.
• Experience with integration of Tableau with Embedded Views in web applications.

TECHNICAL SKILLS

Tools: Tableau Desktop 9.x,8.x/7.X, Tableau Server, Tableau Reader, TIBCO Spotfire 6.X

Operating systems: Windows XP/2003/2007, Windows Server 2003/2008, UNIX

RDBMS: Oracle, SQL Server, Teradata, DB2, MS Access

Languages: HTML, C, C++, SQL, PL/SQL

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

Methodologies: Waterfall, RAD, Agile Scrum

PROFESSIONAL EXPERIENCE

Confidential, Mason, OH

Tableau Consultant

Responsibilities:

• Reported directly to the Senior Manager for EDW and Business Reporting.
• Designed and perfected the reporting requirement documents and the tracker logs to track and assign the work packets until they get completed /resolved.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Provide future forecast analysis and identify past trends for different investments and market segments.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Usage of Quick Table calculations to compare quarterly trend and sales.
• 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.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Converted Metric insight reports to tableau reports.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Excel.

Environment: Tableau 9.x Desktop, Tableau Server, Oracle, Teradata, SVN, HP ALM, SQL, PL-SQL, TSQL, SQL Server 2008, MS Office Suite.

Confidential, Minneapolis, MN

Tableau Developer

Responsibilities:

• Served as Business Systems Analyst meeting deadlines and budget requirements.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Oracle that can be used for development of various Tableau reports/ dashboards.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Analyzed dimensional and fact tables in a campaign data mart that details Inclusion, exclusion and Segmentation criteria, Offer assignment and campaign response by campaign.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Used geographic view, which clearly gives the performance of a particular state.
• Effectively used data blending feature in tableau to connect different databases like Oracle, MS SQL Server.
• Developed customized calculations when required.
• Worked on drill through reports by creating HTML references.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Usage of Context, SQL filters to improve performance and different date filters to show the details for different quarters and years.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Actively tracking schedule, clear and crisp communications with key resources, stakeholders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.
• Core member for integration of Tableau Reports with Asp.Net web application and usage of JavaScript API for performance improvement.
• Extensive use of Rally software tool to manage agile development, creation of user stories, estimates and updates. Viewing the burn down charts and other reports, updating the team in meetings.

Environment: Tableau 8.x/7.0, Tableau Server 8.0/7.0, Informatica, Oracle 10g, Oracle SQL Developer, SQL, Share Point, Agile-Scrum, Rally, Asp.Net, JavaScript.

Confidential -Stamford, CT

Tableau Developer

Responsibilities:

• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Sending the dashboards to users by emails with the help of admin team with subscriptions.
• Performance tuning of Reports by creating Linked Universes, Joins, Contexts, Aliases for resolving loops and checked the integrity of the universes using Business Objects Designer module during development.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Administered user groups and scheduled instances for reports in tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2008, Oracle 10g, UNIX, Toad, MS Office, Visual Studio 2010.

Confidential - Secaucus, NJ

Reporting Consultant/Business Analyst

Responsibilities:

• Participated in project and team meetings interacting and collaborating with team members and other departments as necessary.
• Refine client requirements and guide them through the decision making process.
• Designed and Constructed reports.
• Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies and worked on linking of the Universes using Business objects Designer.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects reports.
• Designed and developed extensive BO reports using combination of chart and tables
• Performed unit testing on developed reports.
• Executed SQL queries, stored procedures and integration with software development.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Understanding of relational database structures, theories, principles, and practices.
• Contributed to successful completion of project deliverables.
• Proof-read all documents and maintain accuracy of information and preparing.

Environment: Oracle 8, Business Objects 5.1, BO Designer, Supervisor, Windows XP, Tableau 7

Confidential

Business Analyst

Responsibilities:

• Worked with Project Sponsors and Stakeholders to complete Project Charter outlining scope, goals, deliverables and timing.
• Effectively communicated project expectations to team members and stakeholders in a timely and clear fashion.
• Worked closely with the Developers and QA team in order to maintain schedules for testing and any issues related to the application.
• Participated in documenting User Manual and UAT and followed up to resolve the issues.
• Thoroughly evaluated information gathered from multiple sources and derived conclusions.
• Reconciled conflicts, decomposed high-level information into details, abstracted information from low-level to a general understanding, and distinguished user requests from the underlying true needs.
• Proactively communicate and collaborate with external and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed: (Functional requirements (Business Requirements Document), Use Cases, GUI, Screen and Interface designs).
• Identifying and comprehending business issues and data challenges of client's organization and industry and help devise solutions.
• Created use cases and cross functional diagrams to showcase various departments roles and needs using MS Visio.
• Planning, execution, monitoring the project progress during all the phases of SDLC.
• Ensured all artifacts are delivered to meet the Project timelines. Helping teams to resolve defects and meet high quality standards.