SUMMARY:

• 7.7 years of experience in software application testing
• Worked with some of the leading US based customers which include Confidential
• Experience of working through the entire Software Product Testing Lifecycle
• Passion for learning new skills and exploring new environment
• Strong knowledge and working experience of using SQL and automation as add - on for web application testing and quality database testing
• Extensive experience in team work and building team
• Strong experience in working as an test lead for 4+ years and mentoring juniors, handling escalations
• Involved in customer facing role with exposure to requirement understanding and design problem resolution
• 9 months of automation testing experience using QTP 9.2 and UFT12.2
• Good analytical, problem solving and leadership skills with an ability to grasp things quickly
• Trained and Experienced in Agile testing methodology and trained in DevOps
• Sound profile in Frontend application testing using - Essbase Hyperion, CUBES, Microstrategy OBIEE
• Ability to perform well in a fast-paced environment, managing multiple priority tasks effectively.
• Extensive experience in team handling with 7 - 8 members across shores with successful delivery.
• Coordinating defect calls and project calls
• Documentations done for End-to-End testing across applications in home loans and credit risk as an SME.
• Led the audit quality check to ensure on the Project quality and repository maintenance.
• Pro-actively look for opportunities to improve business value derived from application
• Define entry/exit criteria for test phases and put together QA metrics to respective stake holders and Project team

TECHNICAL SKILLS:

Operating Systems: Windows XP/Vista/7, Linux, Mac OS X

DB/backend technologies: Teradata for SQL assistance 11, Aginity Netezza workbench 8.3, Toda for data analysts 3, SQL server

Frontend/ web based technologies: Hyperion, Essbase Cubes, Microstrategy, OBIEE, Pega Systems

Databases: SQL, Oracle

Test management and automation tools: HP- ALM 12, HP- UFT 12.2, Rally, JIRA

WORK EXPERIENCE:

Confidential

Frontend/DB/Automation Testing

Responsibilities:

• Review relevant documentation (BRD/HLD/LLD/Mapping) and provide all relevant updates to Offshore and assign tasks.
• Review Project Test Plan/Test Strategy/Scenarios/Scripts created by team and get it signed off by respective project team.
• Collective repository of having all the related documents for the Audit purpose created in secured SharePoint sites. Lesson learnt document for further references.
• Coordinate/Initiate meeting for walkthrough/project status update.
• Execution, Defects logged in ALM and tracked until closure by coordinating with dev and project team.
• SIT Sign off are provided for that the project highlighting all relevant point.
• Support provided for the UAT validation after SIT
• Estimations where provided based on the release planning, and the number of user stories created for each sprint/iteration.
• Made sure that Rally is update for the user stories in respective sprint for the QA
• Daily stand-up calls in order to report the progress in agile based projects to the scrum master per the offshore team task
• Led Automation Testing effort in UI Functionality
• Identified different stages and product for each test life cycle.
• Size estimated for each work product.
• Computed total testing effort.
• Weekly Status Reports based on the needs during planning and execution phase of various projects.
• Project plan review and clarifications are done with BA and Dev team along with business partner.
• Risks & issues and Mitigation plan are sent out in weekly status report along with Resource utilization Report.
• Automation penetration report in order to measure the Automation status, risks and issues if any.
• Estimation Metrics for the projects and handled escalations.
• Defect status and Defect Acceptance Rate Metrics.

Environment: Toad, SQL Server, Rally, HP-ALM 12, HP-UFT 12.2

Confidential

Frontend/DB Testing

Responsibilities:

• Requirement Analysis, Risk Analysis, Feature requirement analysis, Business Impact analysis, Schedule and task status tracking and workaround, data sheet request and readiness for testing, Tracking defect to closure for QA in defect calls, Evaluating exit criteria
• Feasibility analysis, Estimation and release plans for module-level tasks in Waterfall models, Problem solving, Integration Testing, Onsite-offshore Coordination
• Worked closely with Confidential SMEs on the data validation and integration testing for Confidential and finance related applications.
• Validation of input file feeds from Mainframe systems and data validation using toad for data analysts.
• Coordinating onshore requirement discussion call, providing estimation, task allocation, follow up, review meeting, execution and status meeting, defect tracking in ALM, sign off and validation in UAT environment.

Environment: SQL Server, Toad, Mainframe system, HP-ALM 11

Confidential

Frontend/DB Testing

Responsibilities:

• Created a Test strategy for the application flow and workaround for the project release.
• Capture test scenarios based on the priority and do risk based testing considering the project load and number of resources for each project based on the individual capacity and time frame to fulfill the right needs from client partners.
• Work closely with Business Analyst and Project team to have right understanding of the requirement and the deliverables based on estimation provided with in the provided timeframe.
• Train the team on the workflow and review the scripts and get it signed off from the right project team members to proceed further with the execution.
• Defined the test data and test environment setup follow up with respective team for the validation.
• Data conditioning for the batch run for specific set of validation and required data.
• Evaluation of exit criteria and provide successful deliverables with signoff.
• Prepare the test deliverables report and sent it to client manager.

Environment: Pega Systems, Toad 8.3, Oracle SQL Server, ALM 11.

Confidential

Onshore Coordinator/Module Lead/DB Tester

Responsibilities:

• DB test lead role wherein data validation was done to ensure whether the fields in the UI/Frontend forms are mapped consistently with the corresponding DB table.
• Any change in the frontend corresponds to Create, Retrieve, Update and delete action invoked at the back end. We check if the right action is invoked and the invoked action in itself is success or not.
• Data Integrity - the updated and most recent values/Status of shared data checking in all the places should be consistently the same.
• Transformation Rule validation: We validate the transformation logic by writing SQL queries.
• Automation - Based on the stability of mapping document provided and the volume of the scripts to be executed the scripts are generated using macro and automated by connecting the respective DB testing tool and UFT in order to validate the SQL scripts based on the existing functionality and validation.
• Handled large agile projects that involved various processes of scrum and Kanban.
• Validation and verification done in the agile projects needs to meets the needs of the end user. Hence we ensure that built system in small increments is tested then the increased systems functionality in each release, and potentially deliver a working system at the end of each increment that actually meets the end users needs rather than the requirements that were captured.
• Every release we the estimation done based on the release planning, and the number of user stories created for each sprint/iteration.
• QA team involves right from the estimation phase in order to have the timely delivery and fix the bugs in earlier stage as and when it’s developed.
• JIRA, Rally, Where the 2 applications which I have used as a part of agile process and assign tasks and have a frequent check on the capacity of each resources and the amount of work been complete per the task allocation.
• Daily stand-up calls will be attended in order to report the progress to the scrum master per the offshore team task completion and retro meeting are used as the platform to highlight on the improvising area and best practices for each sprint.
• Defects are logged in ALM and the defect ID will be mentioned in the application Rally, JIRA for reference along with attachment for the dev team and project team reference.
• Status will be updated accordingly once the task is complete or need any clarifications.
• Frequently the work progress is been monitored for the team and update the tasks based on priority and timeframe.
• Once the final validation are done and we move the tasks to the completed state, Project sign off for each release will be given based on the status.

Environment: Teradata 12, Aginity Netezza Workbench 3.2, Microstrategy, Quick Test Professional, JIRA

Confidential

Automation Tester

Responsibilities:

• Build better understanding about the application and the flow to update the framework based on the new requirements.
• Requirement understanding and clarification calls with the business team and the manual testing team to deliver quality code and testing.
• Ensure the manual scripts for the new functionalities are signed off and working fine to implement in the automation as a part of regression for future release.
• Updated the existing the regression suite with New requirement and GUI changes which involved functionality validation.
• Provided demo to the business team after every code change and have created the lesson learnt document for further references on the changes and updates been implemented.
• Provided daily status update to the client leadership and weekly update to Client on the status.

Environment: Quick Test Professional 10, Quality Center 10

Confidential

Data warehouse/frontend Tester

Responsibilities:

• Understanding the application flow and the differences that would bring potential issues during the data migration testing process.
• Ensuring the data standardization has been taken place appropriately per requirement.
• Mapping documents are considered as the base reference to do the validation along with the application flow knowledge.
• Data comparison for the existing reports in Hyperion against the new reporting tool OBIEE this was done using the appropriate SQL query and data conditioning.
• The OBIEE reports where then validated against the DB based on various transformation logics and parameters.
• Use cases provided by business where also validated to make sure that the data migrated are as per the business needs and fits into the client need.
• Excel level validations are done for standard reports and adhoc reports for specific time period data.
• Reusable scripts were scripted for the standard validation that can be done for migration validation. This was later used to be implemented in the macro to generate standard checks for 1000s of table validation.
• Defects were logged and tracked until closure along with required artifacts.
• Trained the new joiners to understand the validation been done and supported them to do the validation right.
• Provided the up to date status to the team lead and made sure all the risks and status are addressed promptly.
• Validation where done right from the saying level to the downstream reports.

Environment: Teradata 11, Toad for Oracle, Hyperion, OBIEE, Quality Center 9.2

Confidential

Database Tester

Responsibilities:

• Ensured that relevant documents were referred to create Test plan and got signed off for testing artifacts.
• Test scenarios where created based on the mapping documents and other testing artifacts provided.
• Quality center was used to script, maintain all the SQL scripts and reporting test cases for validation.
• Execution was done directly in the Quality center and defects where raised for the failed test steps along with validate proof of failure and steps to reproduce.
• Defects where tracked to closure and certain defects that where deferred to next release was validated in respective release.
• Data integrity was validated for the backend testing and the GUI and other application functionalities are tested based on the business knowledge provided.
• Scheduled calls in order to have precise clarity in the requirement and ensure the RTM scenarios are covered rightly.
• Status reports were sent to the team lead and made sure feedback where obtained.

Environment: Teradata 11, Toad for Oracle, Hyperion, OBIEE, Quality Center 9.2