Priyanka G
Career Objective
I am a motivated individual, with well-developed IT, team-working and communication skills. Looking forward to work in creative, challenging and learning atmosphere which provides me ample opportunities to grow. I have the attitude to learn quickly and work in teams. Facing challenges and meeting deadlines are my strengths. I seek a challenging and rewarding position that allows me to learn new technologies as well as polish the skills which I possess at the moment. Professional Summary
• 11 years of professional experience in Software Testing.
• Rich Experience in Manual Testing, API Testing, ETL Testing, Bigdata Testing, Report testing.
• Having knowledge on Banking, Financial & Health care domains.
• Worked in Projects that have been managed traditionally (waterfall models) as well as those that have been managed in a more iterative/incremental fashion (Agile).
• Proficient in Manual Testing like Black Box, Functional, Regression Testing, Smoke Testing, and Database Testing of Web Applications Products.
• Having experience in Testing Client-server and Web Based applications & API testing using postman.
• Well known with all the stages of Defect Tracking Life Cycle.
• Excellent understanding of SQA Techniques and complete knowledge of the
• SDLC and Testing Life Cycle (STLC).
• Experience in testing Web and mobile Services using Soap UI tool, request, and response xml.
• Experience in GUI Testing, API testing, Regression Testing, Data Driven Testing, Functional Testing.
• Integrated Appium with various testing frameworks like TestNG, JUnit, or Cucumber to facilitate behavior-driven development
(BDD) and enhance test management and reporting capabilities.
• Implemented test automation scripts for mobile testing using Appium for Android and iOS applications.
• Strong Knowledge in Data Warehouse Concepts.
• Testing frameworks and libraries which are used for API testing.
• Developed and implemented an automation strategy that aligns with the overall testing and development goals of the organization.
• Extensive testing ETL experience using MSBI_SSIS& Data stage.
• Extensive testing Reporting experience using Tableau, MSBI_SSRS, Obiee & Cognos.
• Expertise in problem solving and Tracking Bug Reports using Bug tracking Tools like Jira, Bug tracker & HP ALM.
• String Knowledge in HQL using Pyspark & Scala.
• Work closely with development teams, product managers, business analysts, and other stakeholders to understand the application's architecture and requirements
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
Educational Qualification
• Master of Computer Applications from Osmania University (2007-2010). Professional Experience
• Working as Sr. Quality Analyst for IQVIA from Oct 2022 to Apr 2024.
• Worked as Sr. consultant for Capgemini Technology Services India Limited from July 2021 to Sep 2022
• Worked as Sr. Software engineer for CGI India Limited from Oct 2019 to June 2021.
• Worked as consultant for Capgemini Technology Services India Limited from Mar 2016 to Sep 2019.
• Worked as a Sr. Quality Analyst for Virinchi Technologies from Dec 2014 to Mar 2016.
• Worked as a Quality Analyst for Virinchi Technologies from Aug 2011 to Sep2013. ********.********@*****.***
Technical Summary
• Testing Skills : Functional Testing, API Testing, Bigdata Testing, ETL Testing, Report Testing
• Management tools : Jira, Bug-Tracker, HP ALM, SOAP UI, POSTMAN
• Test Approaches : Waterfall, Agile/Scrum, SDLC, STLC, Bug Life Cycle
• Database : Oracle, Teradata, Hadoop, HUE, Impala, Toad
• OS : Windows OS family, Unix.
• MS Office : MS Word/PowerPoint/Excel/Outlook.
• Languages : C++, Basics of Core Java, SQL, Python, Spark, Scala, ML.
• Servers : SQL Server.
• ETL Tools : MSBI(SSIS), Data Stage, Informatica
• Reporting Tools : MSBI_SSRS, Obiee & Cognos, Tableau. WORK EXPERIENCE (11 Years)
IQVIA Oct 2022– Apr 2024
Sr. Quality analyst
• Project Title : I2E
• Client : Linguamtics
• Environment : Java, oracle, Rest Assure
• Team Size : 4
• Role : QA Automation Engineer
• Description :
I2E is an agile and interactive text mining application for the extraction and analysis of information.I2E’s NLP-based querying capabilities, coupled with its scalability and flexibility, mean it is ideally suited to answering many challenging, high value questions in life sciences and healthcare by unlocking knowledge buried in the scientific literature and other textual information. Rather than just retrieving documents, I2E can rapidly identify, extract, synthesize and analyze specific, relevant facts and relationships, such as those between genes and diseases or compounds and side effects. Customers include nine of the top ten global pharmaceutical companies.
• Roles &
Responsibilities :
- Involved in Requirement Analysis, Design, Development and Testing of the risk workflow system.
- Actively participated in agile testing. Completed tasks on time for each sprint to meet the deadlines.
- Determined test strategies based on requirements, developed test plans, and test cases and executed test scripts.
- Designed and executed comprehensive API test scenarios using Postman and SoapUI to validate the functionality, performance, and security of backend APIs.
- Created and executed API tests using Java libraries like RestAssured to validate data exchange between components.
- Developed and executed test cases for UI testing to ensure the proper functionality and user experience of web and mobile applications.
- Utilized REST API experience to comprehensively assess the functionality and integration of application components
- Utilized Postman and SoapUI to create and execute automated API tests, enabling continuous integration and faster feedback in the development process.
- Developed automated SQL scripts for data setup, data validation, and database verification to streamline testing processes and increase test efficiency.
- Set up, configured, and managed continuous integration (CI) pipelines using Hudson to automate the build, test, and deployment processes.
- Managed and maintained test data sets for various testing scenarios, ensuring the availability of relevant and diverse data to support testing activities.
Capgemini Jul 2021– Sep 2023
Sr. consultant
• Project Title : Team SynNergy
• Client : Synchrony Financial
• Environment : Java
• Team Size : 7
• Role : Quality Analyst
• Description :
Customer insights end to end process run in exploration and delivers transformed data for feeds like workstation complaints, ACM AIT, ACM IRR, ACM CX complaints, ECOM, FDR transactions, vail category (also known as Vail 4), vail speech, web IVA, web Echat and VOC Text Category to MIS team. MIS team builds tableau reports on this data. Target tables for all these fields are in edlcustcare schema and transformed based on the business rules provided by MIS team
• Roles &
Responsibilities :
- Demonstrated expertise in designing and executing comprehensive API test suites using Postman and Soap UI. Validated payment endpoints, and transaction data, and managed various error scenarios
- Testing frameworks and libraries which are used for API testing.
- Used Java libraries like requests to interact with APIs, HTTP requests, parsing responses, and validating JSON/XML data in API test scenarios.
- Conducted regular team meetings to discuss progress, challenges, and strategies for improving testing processes
- Worked on Views, Stored Procedures and Triggers and tested them by writing SQL Quires
- Developed and maintained tests for APIs and backend services using Java and RESTful API testing libraries like Rest Assured.
CGI Oct 2019– Jun 2021
Sr. Software engineer
• Project Title : AAH
• Client : PNC Bank
• Environment : Pyspark, Linux, HUE, Tableau
• Team Size : 6
• Role : Test Analyst
• Description :
This project consists of designing and building AML portfolio monitoring visualization decision support tools analyzation portfolio segments and transaction threats .provide a single source of AML information that will allow AML stakeholders more effectively and efficiently identify, investigate, track and report on AML risk stand up internal technology may process us to build and support AML reporting need on a go forward basis .Solidify and establish business processes that govern the consumption of and review of AML reporting to ensure follow through on the disposition of information provided by reports with intelligent Automation
• Roles &
Responsibilities :
- Validate schema of the tables like column names, data type, length, null-ability etc.
- Providing details analysis to the developers and data analysts in case of any mismatches.
- Validated Business test cases for various scenarios for RTM projects.
- Direct client interaction involving conference calls, walkthroughs, meetings and reviews on a daily and weekly basis and in between as needed.
- Tested complex reports according to fulfil client Requirements.
- Performed Regression Testing and Reported Results Capgemini Mar 2016– Sep 2019
Consultant
• Project Title : Earth & Moon
• Client : HSBC-UK
• Environment : UNIX Environment, Teradata,Orcale, Data stage,Cognos
• Team Size : 6
• Role : ETL Tester
• Description :
Project Earth and Moon has been initiated in response to the ‘Ring fencing legalization’ outlined in the financial services (Banking Reform) act 2013 which is being implemented within the United Kingdom
(UK) on 1st January 2019.The regulations require HSBC to separate into two logical banks, each bank, known as Ring fenced bank (RFB) and Non-Ring fenced bank (NRFB) will operate independently of the other and will have separate capital reserves and undertake separate settlement with the Bank of England by using the same IT structure
• Roles &
Responsibilities :
- Developed complex Teradata queries for data validation and verifying the ETL Mapping Rules.
- Identified and prepared Test Scenarios.
- Involved in Functional Testing, Re-Testing, Regression Testing and End-to-End testing.
- Interacting with development team for bug’s closure.
- Implementing new change requests from client & Prepared Test data for UAT Scenarios. Virinchi Dec 2014– Mar 2016
Sr. Quality Analyst
• Project Title : APD Data ware house
• Client : Advance Financial Inc., USA
• Environment : MSBI SSIS, MS SQL server
• Team Size : 4
• Role : ETL Tester
• Description :
APD is a Pay Day Loan application that helps Pay Day Loan Companies to web-enable their existing business processes. They have been built based on the expertise of the leading industry personnel with extensive domain and operational experience. This application enables the employees at various locations of a company to carry out transactions on the web. Major Functionalities other than loan procedures include customer registration, setting up security groups, rules and rule values, carrying out core transactions like Advance/Loan, Rollover, Buyback, Payments etc.
• Roles &
Responsibilities :
- Authoring Test Script, execution, defect reporting and defect verification.
- Prepared and given walkthrough on Test Activity Plan and Test Design Matrix.
- Improved and enhanced the test scripts according to the functional changes to handle more scenarios.
- Performed Regression Testing and Reported Results.
- Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
- Validate schema of the tables like column names, data type, length, null-ability etc.
- Conducted Data Migration and Data Cleansing.
- Worked with ETL group for understating mappings for dimensions and facts. Virinchi Aug 2011– Sep 2013
Quality Analyst
• Project Title : APD
• Client : Advance Financial Inc., USA
• Environment : MSBI SSIS, MS SQL,Oracle,Java
• Team Size : 4
• Role : Tester
• Description :
APD is a Pay Day Loan application that helps Pay Day Loan Companies to web-enable their existing business processes. They have been built based on the expertise of the leading industry personnel with extensive domain and operational experience. This application enables the employees at various locations of a company to carry out transactions on the web. Major Functionalities other than loan procedures include customer registration, setting up security groups, rules and rule values, carrying out core transactions like Advance/Loan, Rollover, Buyback, Payments etc.
• Roles &
Responsibilities :
- Understanding business requirements.
- Involved in Functional Testing, Re-Testing, Regression Testing and End-to-End testing.
- Conducted GUI Testing and Database Testing.
- Interacting with development team for bugs closure and implementing new change requests from client.
- Developed automated SQL scripts for data setup, data validation, and database verification to streamline testing processes and increase test efficiency.
- Planned and executed regression testing to validate the stability of existing functionalities after each software release or change.
- Conducted exploratory testing to identify defects and usability issues, ensuring a positive user experience.
- Managed and maintained test data sets for various testing scenarios, ensuring the availability of relevant and diverse data to support testing activities.
- Created and maintained test documentation, including test plans, test cases, and test execution reports, adhering to the company's testing standards and best practices.