SUMMARY:

• 14+ years of experience in Software quality assurance and testing as a team member and a team lead with system development lifecycle experience in requirement analysis, testing effort analysis, designing, developing and implementing test plans, test cases, defect documentation and regression.
• Performed the role of system test lead, senior system test analyst while working on custom built and vendor licensed applications in technologies like Oracle Business Intelligence, ADF, C#, ASP .Net, VB .Net, JAVA, GoldenGate, PL/SQL on UNIX and Windows platforms.
• Implemented automated testing using Selenium Web Driver, JAVA, REST - Assured and Junit/TestNG -
• Data driven automation frameworks to validate dynamic and static elements
• UI/Reports data verification against Oracle DB and SQL Server
• Well versed in the use of Document Object Model API, JSON for automation
• API manual testing using Postman and API automation testing using JAVA and REST-Assured.
• Implemented automated testing using HP-UFT -
• Data driven automation frameworks to validate dynamic and static elements
• UI/Reports data verification against Oracle DB
• Working knowledge of Jenkins, Cucumber and Git.
• Effectively worked in onshore - offsite model as an onsite coordinator.
• Industry experience in Telecommunication, Retail and Healthcare verticals.

SKILLS SUMMARY:

• Test Automation SQA Testing & Methodologies Requirement Analysis Test Strategies Test Plans, Cases & Processes Defect/Bug Tracking
• Regression & Negative Testing White Box and Black Box UI & Compatibility Testing Integration Testing DB & Application Upgrade Testing Data Integrity Testing
• ETL, DW & BI Testing Performance/Load/Stress Testing Documentation

TECHNOLOGIES AND TOOLS:

Database: Oracle, MS SQL Server

Data Integration: GoldenGate, PL/SQL

Hadoop & Big Data: Impala, Hive, Sqoop, Oozie

Business Intelligence: Oracle BIEE, Oracle BI Publisher

Application & Web servers: WebLogic, JBoss, Oracle HTTP Server

Programming Languages: Structured Query Language (SQL), JAVA, Visual Basic

Source Code Control & Configuration Management: Subversion, Bitbucket

Agile Methodologies: Kanban, Scrum and SAFe

Testing Tools: HP Application Lifecycle Management (ALM), eJira

Test Automation Tools and API: HP QPT/UFT, Selenium Web Driver, JAVA and TestNG, RemoteWebDrvier, Document Object Model API, Cucumber, JSON

API Testing: Postman (Manual) and REST-Assured (Automation)

JOB EXPERIENCE:

Confidential

Test Engineer

Responsibilities:

• File processing and data loader for eligibility file containing claims from insurance companies
• Analyzing the existing system built on SQL Server / T SQL based loader to legacy tables to create test scenarios.
• Creating manual and automation test scripts for the new loader built on JAVA to handle larger loads and to achieve faster UI API response to interfacing teams.
• Creating data scenarios and test automation of the queries to verify data between legacy and future state databases using the JAVA, Selenium, SQL Server and JUnit/TestNG.
• Test the customer implementations in a production like environment to ensure that legacy and future state data matches.
• Test the updates to existing and new APIs to provide claim data to interfacing teams
• Analyze the contracts or requirements and create test scenarios
• Manual test the API using Postman to validate that the API response and verify the API Response data against SQL Server DB.
• Building and updating automation scripts using REST-Assured, JAVA, SQL and JUnit/TestNG
• Claim View UI to allow the adjustors to view, update and validate the claims
• Manual and automation testing of the UI to validate the data the against the database
• Test the New Product - Risk Queue - based on eligibility and PBM/ABM risk data which identify risks associated with a claim and send notifications to the adjusters about the same.
• Participate in the Sprint ceremonies
• Backlog Refinements - analyze and refine the stories, estimate the points in version One / JIRA
• Sprint reviews and provide Story demos, Daily Scrum Stand Ups, Sprint Retrospectives

Confidential

BI Analyst - OBIEE/ODI developer

Responsibilities:

• Building new analysis, ad-hoc queries, dashboards reports and dashboards in OBIEE to meet business requirements.
• Analyze legacy reports to create SQLs based BI Publisher reports.
• Analyzing business requirements to build SDE, SIL and Load Plans for loading custom tables in ODI.
• Implementing query blocking to make the subject areas more user friendly.
• Working on repository updates to create and modify subject areas, business model filters, level based hierarchies, session variables, repository variables, initialization blocks, foreign keys and complex joins.
• Unit testing the OBIEE reports by validating the results against the data base by creating manual SQLs.
• Working with the test team to debug defects and providing fixes.

Confidential, Tampa, FL

Lead Analyst - Quality Assurance

Responsibilities:

• Gathering information and analyzing the business requirements to estimate the effort (ROM) for functional, integration and regression testing.
• Analyzing Design documents and interacting with Product and Development teams to prepare test scope and strategy and manual and automated test plans for functional, integration and regression testing.
• Creating and Managing Projects, Test Cases in HP-QC / HP-ALM and Test Plan Package.
• Creating SQL scripts to balance data between Publix and Instacart databases on SQL Server and Teradata DBs.
• Executing Test Scripts, raising tickets (bug reports) for defects found and closing once fixed.
• Scheduling/attending cross teams status calls and Sending out daily status e-mails to stakeholders.
• Responsible for reviewing the test strategy and test plan documents prepared by team members.
• Technologies used during to deliver the above QA duties are HP Application Lifecycle Management (ALM), SQL Server Management Studio, Rocket BlueZone, Beyond Compare, Mainframe Display, Structured Query Language (SQL), Teradata database, Teradata SQL Assistant, MS SQL Server database, Postman, Microsoft Office Word, Microsoft Office Excel, and Microsoft Visio Viewer.

Confidential, Tampa FL

Lead Test Engineer

Responsibilities:

• Gathering information and analyzing the business requirements to estimate the effort (ROM) for functional, integration and regression testing.
• Analyzing Design documents and interacting with Product, BIA and Development teams to prepare test scope and strategy and manual and automated test plans for functional, integration and regression testing.
• Creating and Managing Projects, Test Cases in HP-QC / HP-ALM and Test Plan Package and updating all documents in Knowledge Repository.
• Preparing the data request forms and data scenarios required for the data loading.
• Executing Test Scripts, raising tickets (bug reports) for defects found and closing once fixed.
• Scheduling/attending cross teams status calls and Sending out daily status e-mails to stakeholders.
• Creating Sign off document and conducting meeting for the same with Development, DBAs and production teams.
• Responsible for reviewing the test strategy and test plan documents prepared by team members.
• Running Baseline Tests with old code for upgrade testing using automated and manual test scripts.
• Responsible for mentoring and supporting onsite and offshore team members and provide knowledge transfer on homegrown DW, ETL, enterprise reporting application and Oracle Business Intelligence to new team members.
• Creating/Executing automated test cases using HP-QTP/UFT and Selenium Web Driver, JAVA and TestNG based Testing for OBIEE and custom JAVA apps.
• Extensively used SQL queries to verify accuracy of data in reports, UI results against database.
• Testing the DW-ETL data load such as partitions creation, indexes, data staging, data load in tables, checking log files and verifying MV rewrites. Debugging the issues faced while data load. Creating and executing SQLs in SQL Developer to verify the data has been loaded successfully and correctly.
• Implemented automated test cases using Selenium Web Driver, JAVA and TestNG using Document Object Model API.
• Successfully used different location strategies like element name, element ID and DOM to logically map the HTML pages to pass input values and to validate the application while implementing the automated test using Selenium Web Driver, JAVA and TestNG
• Used RemoteWebDrvier, explicit and implicit waits and wrapping selenium calls while automating manual fixes using Selenium Web Driver, JAVA and TestNG to reduce the level of effort.
• Setting up test environments by executing Release Notes and Installation documents for applications based on Weblogic, ADF, OBIEE and JAVA.
• Setting up new WebLogic domains for scalable, active-active and high availability implementation for applications like Oracle business intelligence (11G and 12C), Oracle ADF and JAVA.
• Testing the Oracle business intelligence functionalities such as Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup (groups, access / query privileges), Business Model filters, Metadata Objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports), Agents (iBots), GoURLs, session variables, repository variables, initialization blocks, foreign keys and complex joins.
• Worked on upgrading OBIEE based application from OBIEE11G to OBIEE12C.
• Designed and developed an automated testing tool for Oracle Business Intelligence by repurposing the BI system utilities to reduce the time taken to upgrade OBIEE 11G to OBIEE 12C.
• Testing the real-time data integration and replication across application using ORACLE GoldenGate and UIs based on JAVA and ADF.
• Working with the performance testing team to create performance test plan for Siebel Analytics / Oracle Business Intelligence application.

Confidential, Tampa, FL

Lead Test Engineer

Responsibilities:

• Gathering of information and analyzing the requirements.
• Responsible for mentoring the team for support and enhancements.
• Responsible for conducting knowledge session for the client to explain the TCS functional understanding.
• Creation of Project in HP-QC
• Analyzing Requirement and High-Level Design documents and interacting with Development team.
• Creating Test Cases in HP-QC and Test Plan Package and updating all documents in Knowledge Repository.
• Reviewing Release Notes and finalizing the Test Cases.
• Running Baseline Tests with old code to duplicate the error conditions.
• Executing Release Notes and Test Scripts.
• Raising Tickets (Bug Reports) for defects found and closing once fixed.
• Creating Sign off document and conducting meeting for the same with Development and production team.
• Creating the data pool in Win Runner for testing.
• Effort analysis for integration, regression and functional testing.
• Review the test cases written for integration and functional testing as per the scenarios created.
• Working with the performance testing team to create the performance test plan for Siebel Analytics / Oracle Business Intelligence application.
• Preparing the data request forms that are required for the data loading.
• Testing the Siebel business intelligence functionalities such as Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Business Model filters, Metadata Objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports), iBots (Delivers), session variables, repository variables, initialization blocks, foreign keys and complex joins.
• Worked at the client site (Tampa, FL) for 2 years to a complete the testing for a critical release.

Confidential

Test Engineer

Responsibilities:

• Develop test scenarios - Analyzing Requirements(through SDD and SRS)
• Test Planning - Preparing Unit Test and System Test (Integration and Regression) Plans
• Test Design - Preparing Test cases
• Setting up testing environments
• Test Execution of the system test, integration and regression test cases.
• Coordinating with Client in Pre-Acceptance Test and User Acceptance Test.
• Defect Reporting - Logging Defects and Verification of defects
• Test Report Generation
• Defining/ changing current business rules as per the changes in the requirement documents.
• Using SQL for checking the output of various reports.
• GUI testing using WinRunner.
• Extensive unit, integration, and regression testing for all the modules of the application.

Confidential

Developer & Test Engineer

Responsibilities:

• Part of the development team as a Developer (DRF Module) in designing of DRF (Data Request Forms).
• Involved in Unit Testing and Bug Fixing.
• Worked as part of the testing team as a Testing lead responsible for preparing unit test plans and test cases for the DRF Module.
• Performed a role of a test engineer in executing the test cases and logging defects.
• Setting up testing environments
• Develop test scenarios - Analyzing Requirements (through SDD and SRS)
• Test Planning - Preparing Unit Test and System Test Plans
• Test Design, preparing Test cases and execution
• Defect Reporting - Logging Defects and Verification of defects
• Code inspection for defects and verifying the code standards conformance.