SUMMARY

• 9 Years of extensive IT experience in design, development, implementation and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse and QA Technical Analyst.
• Hands on experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8 and Tableau 9.
• As a Tableau Developer, responsible for creating wonderful visualizations to help clients to take their decisions faster at first look.
• Developed dash boards with rich Graphic visualizations, Drill Down and Drop down menu options, Parameterized using Tableau.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Involved in design and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other by making use of actions according to the business/client requirement.
• Published Tableau Dashboards in Tableau Server, Tableau public.
• Involved in Tableau Server configuration, creating Users, Groups, Projects and assign Privileges etc.
• Experience in Tableau Projects (involved in the complete lifecycle from requirement gathering, data modeling - scripting, developing and testing dashboards using Tableau)
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets Graphs, Heat maps and Highlight tables.
• Applied different filters like normal filters, quick filters, context filters, sharing filters, and use as filters, user filters.
• Accessed various data sources across the enterprise to pull data for reporting and analysis.
• Installation of Tableau Desktop and Tableau Server
• Involved in admin activities like publishing, creation of subscriptions etc.
• Extensive experience on building Interactive dashboards using Tableau.
• Exposure in writing SQL Queries.
• Have complete knowledge of SDLC, Worked under waterfall methodology, Agile Methodology.
• Worked on software applications including Stand-alone and Web-based at different phases of the Software Development Life Cycle (SDLC).
• Performed GUI, Positive, Negative, Configuration, Performance, Load, Stress and Regression Testing, Functionality, Data Validation, Unit, Integration, End-to-End and System Testing.
• Possess excellent skills in Bug Reporting using HP Quality Center.
• Excellent analytical, problem solving and communication skills and a strong ability to learn new tools and technologies in short span and implement independently.

TECHNICAL SKILLS

Business Intelligence tools: Tableau Suite of Tools 8.3/9.2/9.3.

Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC.

Databases: MS SQL Server 2005/2008/2008R2/2012, MS Access 2000, Oracle 10g/9i.

Programming Languages: SQL, PL/SQL.

Operating Systems: UNIX, Linux, Windows

Requirements Management: Requisite Pro, Microsoft Office (Word, PowerPoint, Excel)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Tableau Admin/Developer

Responsibilities:

• Developed various data connections from data source to Tableau Server for report and dashboard development.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Performance tuning of workbooks, data sources, and providing best practices for user community
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• 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.
• Designed Summary and Detailed reports using Data Blending feature in Tableau and utilized the cascading feature on Dimensions to provide dependency on objects through filters.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Experience in Tableau Installation (Desktop as well as Server)
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Monitored and maintained incremental refreshes for data sources on Tableau server.
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• Created Subscriptions for dashboards through Tableau Server to receive daily email according to user requirement.
• Worked on both system administrators and site administrators with the correct permissions to add users from the Users page.
• Used Tabcmd to refresh extracts and schedule data sources through command prompt.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.
• Configured the report viewing security for various users at various levels using Report Manager.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

Environment: Tableau Desktop 9.2, 9.3, Tableau Server 8.x, Tabcmd, Tabadmin, MS SQL Server 2012, MS SQL Server Integration Services, Oracle 9i/10g, PL/SQL, MS Visual Studio 2010, SQL Server Reporting Services, SharePoint development, and Performance Point.

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Involved in gathering the requirements and analyzing the requirements and interact with the customer to find the proper information.
• Responsible for Preparing the Report Design specifications based on the User's requirement.
• Extracted data from various sources and performed data blending.
• Created different type of charts.
• Created worksheets and dashboards by using custom queries and multiple tables.
• Created various interactive customized dashboards and stories.
• Applied various types filters like Data source filters, Quick filters and Context Filters, Cascade Filters and Global Filters.
• Created table calculations, calculated fields and parameters.
• Published sheets and dashboards on server.
• Developed complex reports and visualizations using Tableau Desktop as per requirements.
• Executed and tested required queries and reports before publishing.
• Validate the data for each report and review the reports.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-Coding.
• Updating the weekly status and tracking the query sheet.
• Created Stories using Tableau as part of report presentations to Business.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities

Environment: Windows, Tableau Desktop 8.3, Tableau Server, MS Office Suite, SQL Server, MS Excel

Confidential

Tableau Developer

Responsibilities:

• Understand Requirement, Analyzing Systems and Source Databases.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Served as the Tableau Server administrator for more than a year. Work included day-to-day server monitoring, housekeeping, access provisioning, coordinated platform upgrades with an external team and the vendor, handled user tickets on dashboard performance issues, etc.
• Handled small development project work which pulls data from MS Excel files, MySQL and Oracle DB and translates to usable metrics which are highly visible to the client leadership.
• Created basic calculations including string manipulation, basic arithmetic calculations, Custom aggregations and ratios, date math, logic statements and quick table calculations.
• Representing data using the visualizations such using Charts.
• Used Trend Lines, Reference Lines and statistical techniques to describe the data.
• Used Measure name and Measure Value fields to create visualizations with multiple Measures and dimensions.
• Responsible for dashboard design, look and feel and development.
• Used parameters and input controls to give users control over certain values.

Environment: Windows, Tableau Desktop 8.3, Tableau Server, MS Office Suite, SQL Server, MS Excel.

Confidential

QA Technical Analyst

Responsibilities:

• Analyzed Business requirements, Use cases and Design Documents to develop test efforts in the Test Plan and generate test scenarios and test cases
• Involved in Developing Test Plans for Unit testing, Integration testing of the application from the Business requirements documents and Technical Specifications.
• Involved in Developing Test Plans for User Acceptance Testing of the Bell Canada from the Business requirements documents and Technical Specifications.
• Conducted interviews and brainstorming sessions with Business analysts and related employees, to create Test Cases/Scenarios.
• Translated Test conditions into Test Scripts for testing the Billing applications.
• Identified and assigned the Input and Expected data for each test script after creating a test database.
• Identified and created Defect Reporting Process.
• Carried out Functional, Integration and Regression Testing of the application.
• Conducted system, integration, and scalability testing of the product.
• Continuously maintained and updated test documentation for my areas of responsibility.

Confidential

QA Analyst

Responsibilities:

• Responsible in analyzing Test Requirements.
• Building the test cases with the help of the use cases.
• Developing Test plan of the application as per technical specifications.
• Involved in writing Unit and Regression Test cases for the Product.
• Involved in scripting the Test cases for ACH payments, ACH Templates.
• Created automated test scripts for validating the nightly product builds and regression testing.
• Maintained Defects using Defect Tracking System in Test Director.
• Used QTP to conduct Data Driven Testing by pulling data from a table.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Used Table Checkpoints to check values of object properties, Image checkpoint for property values of an image and information in a table respectively using Quick Test Professional.
• Used the VB script programming language for writing Test scripts in Quick Test Professional.
• Parameterized test data on scripts by using QTP.
• Performed all test assignments to ensure the application meets business requirements and client expectations.
• Interacted with developers & various members of project team to discuss and resolve defects and to determine their priorities.
• Summarize test results in formula test analysis reports according to the documentation standards.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Furnished weekly status reports to the project management team to track project status.

Confidential

QA Analyst

Responsibilities:

• Used java with TestNg framework for automating scripts.
• Developed test scripts to automate process of testing in Selenium WebDriver.
• Project is developed using agile methodology.
• Participated in JAD sessions and requirement walkthrough with business users.
• Participated in daily Scrum meetings to discuss the status of work done.
• Written and executed functional test plans for manual testing.
• Developed Acceptance Criteria for each sprint as part of release.
• Analyzed and reviewed Story Boards to gain overall understanding of the functionality of the application.
• Performed Positive and Negative testing by inputting valid and invalid data.
• Executed and scheduled the automation test scripts from Quality Center.
• Developed Scenarios, Features and Step definitions using Cucumber and developed a BDD framework.
• Implemented SOAP UI for Web service testing.
• Developed test scenarios, test cases and reviewed the test cases.
• Detected, Logged and classified defects based on the severity and priority.
• Performed Functional, Regression, End to End and User Acceptance testing (UAT).
• Performed Regression testing to ensure that changes made to software did not introduce any new bugs.
• Tested the new functionalities based on the new requirements and coordinated with development team in fixing the issues.
• Responsible for documenting the Automated Test results using SOAP UI and QTP.
• Involved in Backend Database testing by using Toad.
• Responsible for creating automation scripts by using QTP with Testing framework.
• Developed Data Driven Tests using SOAP UI and automated functional testing.
• Performed performance testing to establish the benchmark behavior of the system.
• Prepared the Test Results document, which summarizes testing activities and results.