SUMMARY

• 7.7 years of experience in software application testing
• ASDA - MIT certified Professional
• Worked wif some of teh leading US based customers which include Confidential, Confidential
• Experience of working through teh entire Software Product Testing Lifecycle
• Passion for learning new skills and exploring new environment
• Strong noledge 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 wif 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 wif 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 TEMPeffectively.
• Extensive experience in team handling wif 7 - 8 members across shores wif 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 teh audit quality check to ensure on teh 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

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead - 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 teh related documents for teh 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 wif dev and project team.
• SIT Sign off are provided for that teh project highlighting all relevant point.
• Support provided for teh UAT validation after SIT
• Estimations where provided based on teh release planning, and teh number of user stories created for each sprint/iteration.
• Made sure that Rally is update for teh user stories in respective sprint for teh QA
• Daily stand-up calls in order to report teh progress in agile based projects to teh scrum master per teh 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 teh needs during planning and execution phase of various projects.
• Project plan review and clarifications are done wif BA and Dev team along wif business partner.
• Risks & issues and Mitigation plan are sent out in weekly status report along wif Resource utilization Report.
• Automation penetration report in order to measure teh Automation status, risks and issues if any.
• Estimation Metrics for teh 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 wif Confidential SMEs on teh data validation and integration testing for MLR 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 teh application flow and workaround for teh project release.
• Capture test scenarios based on teh priority and do risk based testing considering teh project load and number of resources for each project based on teh individual capacity and time frame to fulfill teh right needs from client partners.
• Work closely wif Business Analyst and Project team to have right understanding of teh requirement and teh deliverables based on estimation provided wif in teh provided timeframe.
• Train teh team on teh workflow and review teh scripts and get it signed off from teh right project team members to proceed further wif teh execution.
• Defined teh test data and test environment setup follow up wif respective team for teh validation.
• Data conditioning for teh batch run for specific set of validation and required data.
• Evaluation of exit criteria and provide successful deliverables wif signoff.
• Prepare teh 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 teh fields in teh UI/Frontend forms are mapped consistently wif teh corresponding DB table.
• Any change in teh frontend corresponds to Create, Retrieve, Update and delete action invoked at teh back end. We check if teh right action is invoked and teh invoked action in itself is success or not.
• Data Integrity - teh updated and most recent values/Status of shared data checking in all teh places should be consistently teh same.
• Transformation Rule validation: We validate teh transformation logic by writing SQL queries.
• Automation - Based on teh stability of mapping document provided and teh volume of teh scripts to be executed teh scripts are generated using macro and automated by connecting teh respective DB testing tool and UFT in order to validate teh SQL scripts based on teh existing functionality and validation.
• Handled large agile projects that involved various processes of scrum and Kanban.
• Validation and verification done in teh agile projects needs to meets teh needs of teh end user. Hence we ensure that built system in small increments is tested tan teh increased systems functionality in each release, and potentially deliver a working system at teh end of each increment that actually meets teh end users needs rather TEMPthan teh requirements that were captured.
• Every release we teh estimation done based on teh release planning, and teh number of user stories created for each sprint/iteration.
• QA team involves right from teh estimation phase in order to have teh timely delivery and fix teh bugs in earlier stage as and when it’s developed.
• JIRA, Rally, Where teh 2 applications which me have used as a part of agile process and assign tasks and have a frequent check on teh capacity of each resources and teh amount of work been complete per teh task allocation.
• Daily stand-up calls will be attended in order to report teh progress to teh scrum master per teh offshore team task completion and retro meeting are used as teh platform to highlight on teh improvising area and best practices for each sprint.
• Defects are logged in ALM and teh defect ID will be mentioned in teh application Rally, JIRA for reference along wif attachment for teh dev team and project team reference.
• Status will be updated accordingly once teh task is complete or need any clarifications.
• Frequently teh work progress is been monitored for teh team and update teh tasks based on priority and timeframe.
• Once teh final validation are done and we move teh tasks to teh completed state, Project sign off for each release will be given based on teh status.

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

Confidential

Automation Tester

Responsibilities:

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

Environment: Quick Test Professional 10, Quality Center 10

Confidential

Data warehouse/frontend Tester

Responsibilities:

• Understanding teh application flow and teh differences that would bring potential issues during teh data migration testing process.
• Ensuring teh data standardization has been taken place appropriately per requirement.
• Mapping documents are considered as teh base reference to do teh validation along wif teh application flow noledge.
• Data comparison for teh existing reports in Hyperion against teh new reporting tool OBIEE this was done using teh appropriate SQL query and data conditioning.
• Teh OBIEE reports where tan validated against teh DB based on various transformation logics and parameters.
• Use cases provided by business where also validated to make sure that teh data migrated are as per teh business needs and fits into teh client need.
• Excel level validations are done for standard reports and adhoc reports for specific time period data.
• Reusable scripts were scripted for teh standard validation that can be done for migration validation. This was later used to be implemented in teh macro to generate standard checks for 1000s of table validation.
• Defects were logged and tracked until closure along wif required artifacts.
• Trained teh new joiners to understand teh validation been done and supported them to do teh validation right.
• Provided teh up to date status to teh team lead and made sure all teh risks and status are addressed promptly.
• Validation where done right from teh saying level to teh 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 teh mapping documents and other testing artifacts provided.
• Quality center was used to script, maintain all teh SQL scripts and reporting test cases for validation.
• Execution was done directly in teh Quality center and defects where raised for teh failed test steps along wif 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 teh backend testing and teh GUI and other application functionalities are tested based on teh business noledge provided.
• Scheduled calls in order to have precise clarity in teh requirement and ensure teh RTM scenarios are covered rightly.
• Status reports were sent to teh team lead and made sure feedback where obtained.

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

Confidential

Application Tester

Responsibilities:

• Testing was done for teh Aprimo marketing, campaigns and events application in teh web based URL.
• Various case flows was validated based on teh flow diagram and teh status change was validated for different user roles.

Environment: Aprimo FS application, Ariba, Quality Center 9.2