SUMMARY

• 10+ years of professional experience, with 6+ years of experience in designing, administration, analysis, building impactful reports and dashboards using Tableau Business Intelligence, 6+ years of experience in Quality Assurance both Manual and Automation testing of client server, web - based applications
• Effectively managed complex projects with global implementations and managed group of testing team members as a Sr. Tableau Consultant by assigning projects, setting deadlines, tracking project status, publishing project closure report with analysis
• Rich experience in Banking, Insurance domain, Oracle CRM and IBM Mainframe applications
• Expertise in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects
• Expertise in Tableau desktop, reader and server, for data analysis and producing attractive visuals/dashboards to convey the story inside the data
• Proficient in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server
• Expertise in various reporting objects like Info objects, Data sources, Info cube, Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups, Parameters in Tableau
• Expertise in Joining tables, multiple data connections using Blending, Actions, Calculations, Forecasting, Parameters and Trend lines
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps
• Experience in trouble shooting of performance issues which were associated with Tableau reports.
• Proficient in all phases of BI full life cycles includinganalysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training
• Expertise in Data warehouse modeling in Dimension Model, Fact table, star schema, Snow flake schema and in data marts
• Expertise in preparing Cost Estimation, Project plan, Run plan and Statement of Work (SOW)
• Proficient in publishing various status reports like Daily, Weekly, monthly using Peoplesoft
• Well versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle(STLC), Defect Management Life Cycle
• Experience in V & V, Waterfall and Agile methodology (Scrum Based Testing)
• Proficient in Defect management system using tool HP ALM Quality center, participating defect status meetings, defect reporting and analysis of defect
• Expertise in managing UAT support, ensure the test script, test data preparation, defect management, conducting defect status calls, managing new CR’s till smooth completion of UAT
• Strong working knowledge in NoSQL databases Hadoop Hive, Hbase, Cassandra and MongoDB
• Good understanding of SOAP, Web Services, XML, JSON
• Played significant role in various phases of project life cycle, such as requirements definition, functional and technical design, testing, production support and implementation

TECHNICAL SKILLS

BI Tools: Tableau 8.2/9.1/9.2/9.3/10.0

Database / Tools: Hadoop - Hbase, Hive, MongoDB, Cassandra, Teradata, Oracle 9i, SQL developer 2005, SQL server

Applications: Oracle CRM, Oracle Apex, IBM Mainframe, Peoplesoft

Operating Systems: Windows, Linux, VMWare

Test Management tools: HP ALM - Quality Center, QTP

Supporting tools: Unix/Shell Scripting, WinSCP, Putty, Toad, CBIS / ISIS (Web Service tools)

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Tableau developer

Responsibilities:

• Participated in Business user meetings for requirement gathering and analysis, managing the deliverables
• Prepared Cost /Effort estimation for subject area based on the business requirements provided
• Created Project Plan documents as per business requirements and providing walkthrough to stakeholders
• Worked closely with Business users, interacted with ETL developers, Project Managers, and members of the QA teams
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security
• Published and shared the reports, dashboards with business users through Tableau server
• Involved in administration tasks such as Setting permissions, managing ownerships and providing access to the users and adding them to the specific group
• Developed Parameter based reports, Drill-down reports, Charts and Tabular reports using Tableau and enabled ad-hoc reporting
• Documented all the dashboards related information, overview of each dashboard, calculations performed on each dashboard
• Prepared and published project status reports like daily, weekly, monthly using peoplesoft, prepared project closure and analysis report
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Supported all phases of the project development, testing, Pre-implementation runs and Production support
• Delivered tasks on time, bug free and with high quality also with excellent customer service skills

Confidential

Tableau Developer

Responsibilities:

• Extensively participated in development phase meetings for business analysis and attended both business / functional requirement document walkthrough
• Analyzed the requirements and created Technical specification document based on the functional document provided by the business
• Prepared Cost estimation for subject area based on the business requirements provided
• Prepared Project plan, Strategy and Run plan according to the business requirements for tiny, small, large projects and providing Strategy walkthrough to stakeholders
• Provided walk through of new requirements and ensured the team understands the same and proceeded further
• Participated in Business user meetings for requirement gathering and analysis, managing the deliverables using Tableau Business Intelligence tools
• Created Project Plan documents as per business requirements and providing walkthrough to stakeholders
• Worked closely with Business users, interacted with ETL developers, Project Managers, and members of the QA teams
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Prepared and published project status reports like daily, weekly, monthly using peoplesoft, prepared project closure and analysis report
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Experienced in Defect Life Cycle Management using HP ALM quality center, Defect reporting, participating defect status call along development, interface, TP system teams for resolving, retesting and closing the defect
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports
• Used Agile testing methodology (Scrum based testing) for achieving deadlines in UAT testing
• Reviewed, maintained and updated regression suites upon receiving new build and ensure reuse of the suite for CR’s
• Supported all phases of the project development such as UT, ST, SIT, UAT, UVT, Pre- implementation runs and production support
• Delivered the activities on time, bug free and with high quality also with Excellent customer service skills

Confidential

Senior Test Analyst

Responsibilities:

• Extensively participated in development phase meetings for business analysis and attended both business / functional requirement document walkthrough
• Reviewed Business Requirement documents, Design Documents to determine the functionality of the application
• Prepared Test plan, Test strategy, Run plan and Effort estimation according to the business requirements for tiny, small, large projects
• Provided walkthrough of new requirements and ensured the team understands the same and proceeded further
• Conducted internal Test scenario, test condition and test cases review to ensure the test coverage against requirements
• Prepared Test data based on the test scenarios by using Boundary-value analysis and Equivalence partitioning techniques
• Prepared Run plan, Traceability matrix documents, Day Zero checklists
• Prepared and published project status reports like daily, weekly, monthly using PeopleSoft prepared project closure report with details defect analysis and test coverage reports
• Performed sanity testing, interacted with various application teams for connectivity testing to ensure the system readiness to kick start testing
• Experienced in Defect Life Cycle Management using HP ALM quality center and generated defect status reports, conducted defect status call across development, interface, TP system teams for resolving, retesting and closing the defect
• Experienced in Bulk loading process for non ODS countries, loading the files from different TP systems into database
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL for data integrity
• Experienced coordinating Black box testing of the application including Functional testing, Regression testing, System Integration testing, UAT testing and GUI testing
• Coordinated with users in UAT, prepared test scripts, test data, published UAT status report, conducted UAT defect status call
• Gathered new requirements from users on time of UAT, raising CR for the new requirements and followed up till the closure
• Supported all phases of the project development such as UT, ST, SIT, UAT and production support
• Delivered the activities on time, bug free and with high quality also with excellent customer service skills

Confidential

Test Analyst

Responsibilities:

• Analyzed Business requirements, Functional specification document and developed Test scenarios, test conditions and test cases accordingly
• Prepared Test data based on the Test scenarios using equivalence partitioning and boundary value analysis techniques
• Performed sanity testing and coordination with application team for connectivity testing to ensure the system readiness
• Extensively worked in Black box testing including Functional, System Integration, Regression and User Acceptance testing
• Expertise in defect management using HP Quality center for bug reporting, tracking and closure and presenting defect status report, conduct defect status call till the project closure
• Expertise in Bulk loading process for non ODS countries, loading the files from different TP systems into BL database
• Performed database testing to verify backend database transactions and wrote complex queries to compare the counts and data from source to target
• Participated in week end review meetings and reported the status to manager
• Coordinated user acceptance testing activities with users for both offshore and onshore
• Prepared user test scripts for UAT based on business requirements
• Prepared UAT test data requirement and verified the data on basis of user requirement
• Published reports and defect status of UAT on a daily and weekly basis till project sign off
• Used Agile testing methodology for achieving deadlines in UAT testing
• Provided knowledge transfer about the application flow, guiding other host navigation to validate the data against application to end users
• Gathered new requirements on time of UAT from users, raised CR for the new requirements and follow up with other teams till closure
• Got appreciation from business and stake holders for UAT coordination