We provide IT Staff Augmentation Services!

Consultant - Sr. Software Qa Engineer Resume

PROFESSIONAL SUMMARY

  • 11 years of diverse experience in software quality assurance methodologies in Technology industry.
  • Strong Experience in project management, designing test plan, test strategies and maintaining Automated Test Scripts, analyzing errors and automation testing.
  • Expertise in system software testing, creation and documentation of test strategies, test cases and regression test bed setup. Possess a high technical aptitude and a high level of analytical ability and trained in the use of test automation tools and applications customized for proprietary uses.
  • me understand and believe in the integration of techniques, me learn more and do more of the work, add more value to the team. Be able to handle complex situations and time crunch schedules, would create more value for the company and for the customer. Strong intra personal skills in interacting wif End - Users, Excellent work ethics, self-motivated, work independently, quick learner, team player and team oriented.
  • Extensive Experience in Testing Preparing test plan and test strategy.
  • Experience in Software development life cycle: - Agile and Waterfall.
  • Excellent time management skills, Motivational skills
  • Extensive Experience Quality center(ALM) Create project, add modules, writing test plan, test scripts, creating defects, assigning defects, create regression bed, link defects to test case, executing test scripts.
  • Strong experience in working wif Enterprise Data warehouse (EDW) using SSIS and Informatica Power center as the ETL tool.
  • Extensive experience in JIRA bug reporting tool. And also incorporated wif Version one (Agile tool) and link defects between JIRA and Version one.
  • Testing experience in White box testing, black box testing, exploratory testing, boundary testing, Unit testing, integration testing, functional testing, system testing, stress testing, performance testing, regression testing, beta testing, Smoke testing and acceptance testing.
  • Ability to understand the problems/issues of members in team
  • Involved in testing the applications on mobile devices and IPad.
  • Expertise in Integration testing, Performance testing, Regression testing, System testing, User Acceptance testing, Volume testing, and Unit testing and Stress testing.
  • Test plan preparation, Test Strategy preparation, Test cases review, test cases execution, designing, executing, verifying and analyzing test programs. Mapped test cases wif the requirement.
  • Provide tools training to new consultants/employees.
  • Contributed extensively towards Manual testing / Automated testing / Web testing / Client Server testing / UAT
  • Developing bug reports, Build Certification and test data preparation. Jira was used to track issues/defects. Execution of test cases, Logged all the defects. Also Used Jira to Report the bug to the Developer.
  • Proficient in documenting and executing test plans and test cases for manual testing and automated testing.
  • Descriptive programming / Expert programming using QTP.
  • Proficient in Data driven testing and Keyword testing by using QTP.
  • Production support for the issues/defects get from the client/client services on the priority basis of P0 (Blocker), P1 (Critical), P2 and P3. Triage issues for production support whether related to Data, Code or business requirements.
  • Documenting Test documents using MS Office tools- Word, Excel, PowerPoint.
  • Compare all schema objects between two servers using Red gate tool belt.
  • Used ETL tool SSIS (Sql Server integration Services).Running job through SSIS package
  • Performance of Jobs running on new server
  • Participate in Production deployments, running new server as production and old server as parallel server and monitor the behavior of new server for couple of weeks.
  • Used Job Activity monitor to run & monitor SQL server agent jobs.
  • Preparation of regression test bed for automation
  • Develop various documents for automation and performance shared testing services division
  • Coordination wif production support team.
  • Plan specification requirements review, Design review, test plan review and test cases review meetings coordination.
  • Weekly reports, interim test reports, build status reports.
  • Experienced in working wif load data from CSV files.
  • Experience in domains - Media, Financial, Banking and Pharmaceuticals.
  • Risk assessment, Risk mitigation plan

TECHNICAL SKILLS:

Databases: SQL Server 2008/2012, Oracle 9i/10g

Testing Tools: QTP, Quality Center(ALM), SOAP UI

Languages: SQL, PL/SQL

Database Utilities: Sql Server Management studio, SQL Developer, TOAD

Operating System: Windows 95/98/2000/2003/XP/2007

Data warehousing Tools: SSIS(Sql Server integration Services), Informatica Power Center 8

Reporting Tools: Business Objects XI, Dundas Chart

Data Modelling Tools: Erwin, Microsoft Visio 2010

Source Version Control: Perforce, VSS, CVS

SDLC: Agile & WaterFall

Build Deployment: Team city, Varalogix, ClearQuest

Aglie Tools: Pivotal Tracker, VersionOne, Agility

Other tools: FileZilla

PROFESSIONAL EXPERIENCE

Confidential

Consultant - Sr. Software QA engineer

Environment: SQL Server 2012, Quality center (ALM 11), Agile Methodology, Web testing, Clear Quest, Red Gate tool belt, FileZilla, Version One, Team city, SSIS, JIRA bug reporting tool

Responsibilities:-

  • Using Quality center(ALM) Create project, add modules, writing test plan, test scripts, creating defects, assigning defects, create regression bed, link defects to test case, executing test scripts, reporting defects, re-testing of scripts/defects after fixes code deployed to the environment. If defect fails reassign back to development team and explain defects and provide screen shot to clarify more to it.
  • Serve as a Quality/Business Analyst on the PJM Tools Refresh upgrade projects.
  • Lead efforts for following up wif data owners on deliverables to ensure the timely handling of project related tasks.
  • Manage small projects related to enhancement of the desktop computing experience.
  • Create and carry out test plans and activities for customers or business initiatives.
  • Ensure that project qualitymanagementtasks are completed as scheduled and report results to program manager. Provide timely updates of all project tasks to management on a daily/weekly/monthly basis.
  • Perform project activities, ensuring the accuracy, quality and integrity of the information while providing consistent content and appearance wifin the project.
  • Manage and own requirements and quality assurance activities on the project.Apply industry standard Project Management methodology (PMI) to project activities.
  • Display proficiency wif the modules and tools used for the assigned Projects such as knowledge of Sharepoint, Quality Center, Test Automation tools, Jira.
  • Set up meeting wif Identrophy,Project managers, BA, developers, DBAs for clarity related to requirements, use cases, defects, change requests.
  • Create, manage and execute manual test cases in HP Quality Center (QC 11)
  • Create, manage and re-test defects using HP Quality Center and SOA tools.
  • Work closely wif the developers to maintain high quality software development to ensure maintenance of the standard framework throughout the suite of product.
  • Execute manual test scripts and conduct ad-hoc testing.
  • Work together wif the release engineer and rest of the deployment team for product/application deployment to various environments.
  • Work on SQL Server database (PJM’s) and SQL database in order to achieve proficiency in third party application to support testing efforts.
  • Create and Run SQL queries to test backend data in test and prod environment.
  • Used Pivotal Tracker for Sprints (Stories, sprint planning, Backlog items, BurnUp and Burndown chart).
  • Run Smoke Testing after each deployment to Test, stage and production.
  • Expertise in Integration testing, Performance testing, Regression testing, System testing, User Acceptance testing, Volume testing, and Unit testing and Stress testing.
  • Test plan preparation, Test Strategy preparation, Test cases review, test cases execution, designing, executing, verifying and analyzing test programs.
  • Participated in deployments on Test and Production environment.
  • Prepared test cases, Performed sniff testing, Review of test cases, test plan wif team
  • Defined Entry & Exit criteria
  • Risk assessment, Risk mitigation plan
  • Coordination wif development team (Identrophy). Co-ordination/discussion wif Identrophy about requirements, change request, defects associated to Use cases providing all details, assign defects to them.
  • Requirements review, Design review, test plan review, test cases review meetings coordination.
  • Clear Quest to create deployment schedule in Test/Stage/Production environment.

Confidential

Sr. Software QA engineer

Responsibilities:-

  • Used In-house tool for uploading txt or xml file in the table for testing (Ingest tool, Exodus - extract, PVS (publication verification system).
  • Create SSIS job and environment. Run SSIS jobs (as per the Geography) to create extracts.
  • Create PVS profiles for new geographies.
  • Add queries in PVS for additional checks runs for day to day basis.
  • Teamcity to deploy build to UAT/Performance/QA environment.
  • Production support for the issues/defects get from the client/client services on the priority basis of P0(Blocker),P1(Critical),P2 and P3. Triage issues for production support whether related to Data, Code or business requirements.
  • Jira was used to track issues/defects.
  • Running job through SSIS package
  • Prepared test plan and test strategy document
  • Create additional queries for testing Text files.
  • Testing the Web Services through SOAP UI
  • Involved in testing the applications on mobile (IPhone and Android) devices and IPad.
  • Participated in daily stand up meetings
  • Participated in retrospective meetings actively suggesting great ideas to improve the scrum process to achieve better results
  • Involved in release planning meeting before the release and prepared the documents for the team to follow the testing during production
  • Used VersionOne for keeping track of Sprints (Stories, sprint planning, Backlog items, BurnUp and Burndown chart).
  • Verify All objects/jobs exist/running on old server has been copied on New server
  • Verify data produced by old server same set of data has been produced by new server.
  • Compare all schema objects between two servers using Red gate tool belt.
  • Participate in Production deployments, running new server as production and old server as parallel server and monitor the behavior of new server for couple of weeks.
  • Used Job Activity monitor to run & monitor SQL server agent jobs.
  • Used Jira/version one for reporting the bugs.
  • Create Reports, Prepared test cases.
  • Performed sanity testing
  • Review of test cases, test plan wif team
  • Defined Entry & Exit criteria
  • Develop various documents for automation and performance shared testing services division
  • Review project performance metrics
  • Risk assessment, Risk mitigation plan
  • Coordination wif tech support team.
  • Requirements review, Design review, test plan review, test cases review meetings coordination.

Confidential, PA

Sr. Software QA engineer

Responsibilities

  • Test plan preparation, Test Strategy preparation, Test cases review, test cases execution, designing, executing, verifying and analyzing test programs.
  • Add/update QTP scripts to the Framework
  • Uploaded all test cases to Quality Center
  • Mapped test cases wif the requirement
  • Execution of test cases through Quality Center
  • Also was part of Production support team. Production support of the product delivered to the client in warranty period. Issues/defects getting from client/client services need to be taken care as per the criticality of the defect. Critical defects need to be triaged, fix, tested and deployed to production.
  • Logged all the defects in the Quality Center
  • Performed sanity testing
  • Review of test cases, test plan wif business
  • Defined Entry & Exit criteria
  • Identification of test scenario for automation
  • Preparation of regression test bed for automation
  • Develop various documents for automation and performance shared testing services division
  • Business components preparation and storing in Quality center
  • Performed sanity testing
  • Review project performance metrics
  • Risk assessment, Risk mitigation plan
  • Coordination wif tech support team.
  • Requirements review, Design review, test plan review, test cases review meetings coordination.
  • Weekly reports, interim test reports, build status reports.
  • Preparation and presentation to management.
  • Analyzed the existing business scenario and understood the business rules.

Confidential

Sr. Software QA engineer

Responsibilities:

  • Extensive Experience in Testing Preparing test plan and test strategy.
  • Execution of test cases, Logged all the defects
  • Prepared test plan and test strategy document
  • Participate in Production deployments
  • Review of test cases, test plan wif IT team members and Business members.
  • Preparation of regression test bed for automation
  • Coordination wif production support team.
  • Plan specification requirements review, Design review, test plan review and test cases review meetings coordination.
  • Extensive experience in create Tables, Indexes, Views, Constraints, Packages, Procedures, Function and other database objects on production databases.
  • Extensive experience in developing Complex SQL Queries, Sub Queries, Nested Queries and correlated sub query.
  • Identified resources for information and source systems data flows.
  • Study the existing system and gather the business requirements. Interacting wif Project Managers along wif team leaders.
  • Designing and developing Schemas using Entity Relationships, Normalizing the relations, creating Tables, Views, Indexes and Sequences and coding.
  • Creating PL/SQL Stored Procedures, Triggers, Database Views, Materialized Views, Synonyms and Functions.
  • Developing SQL*Loader scripts for various CSV data feeds.
  • Performance Tuning (SQL Tuning,PL/SQL Code tuning) using SQL HINTS.
  • Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control
  • Collected client’s information and modified the existing project.
  • Creation of star schema wif different Dimension and Fact tables.
  • Unit Testing of PL/SQL Code. Involved in Writing the Test plan.

Confidential, NY

Software QA engineer

Responsibilities:

  • Application Design, Development, testing.
  • Prepared test plan and test strategy document
  • Participate in Production deployments
  • Review of test cases, test plan wif IT team members and Business members.
  • Preparation of regression test bed for automation
  • Coordination wif production support team.
  • Plan specification requirements review, Design review, test plan review and test cases review meetings coordination.
  • Developing Stored Procedures and Triggers for Data selection.
  • Developing PL/SQL blocks and Queries as per client’s requirements using SQL Developer.
  • Debugging and Manual Testing the product.
  • Creating Group/Cross-Tab Reports, Effective correlation report, Growth chart.
  • Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.
  • Code breakage for making it generic.
  • Application testing, development, testing.
  • Developed PL/SQL Business Functions, procedures required for ETL Process
  • Provided technical support to other developers and coordinated escalation of issues Involved in code reviews and code implementation in production environment.
  • Unit Testing of PL/SQL Code. Involved in Writing the Test plan.

Confidential

QA engineer

Responsibilities:

  • Create Reports, Prepared test cases.
  • Performed sanity testing
  • Review of test cases, test plan wif team
  • Resolution of issues raised by client.
  • Identified resources for information and source systems data flows.
  • Study the existing system and gather the business requirements. Interacting wif Project Managers along wif team leaders.
  • Designing and developing Schemas using Entity Relationships, Normalizing the relations, creating Tables, Views, Indexes and Sequences and coding.
  • Creating PL/SQL Stored Procedures, Triggers, Views, Materialized Views, Synonyms and Functions.
  • Extensive experience in developing Complex SQL Queries, Sub Queries, Nested Queries and correlated sub query.

Confidential

QA engineer

Responsibilities:

  • Create Reports, Prepared test cases.
  • Review of test cases, test plan wif team
  • Responsible primarily for writing SQL queries.
  • Performing QA on PL/SQL procedures for matching of feeds, cross enrichment and maintaining the Database.
  • Participated in designing activities of Data modeling like Logical and Physical Data Model.
  • Also converted several standalone procedures/functions in PL/SQL to packaged procedure for code reusability, modularity and control.

Confidential

QA engineer

Responsibilities:

  • Responsible primarily for writing SQL queries, stored procedures, functions, packages and database triggers, exception handlers, Cursors and also involved in Query Level Performance tuning.
  • Performing QA on PL/SQL procedures for matching of feeds, cross enrichment and maintaining the Database.
  • Resolution of issues raised by client.
  • Analyzed the different data feeds and design accordingly.
  • Participated in designing activities of Data modeling like Logical and Physical Data Model.
  • Developed SQL*Loader scripts for various csv and Flat files data feeds.
  • Using SQL Hints for query optimization.
  • EXECUTE IMMEDIATE for generating dynamic queries.

Hire Now