Quality Assurance Sql Developer
Resume:
Amrita Pattnaik
********.******@*****.***
Career Summary:
Having 14 Years of experience in IT industry in Quality Assurance & Software Testing which includes Functional Testing,ETL/Data Warehouse Testing and REST API Testing.
Expertise in Functional, End to End testing, Integration, Regression, Sanity Testing. Strong Black Box, Functional and Structural Testing capabilities, conceptualization skills, and deep expertise in developing and running tests on application software, identifying, and analyzing problems and tracking them to closure.
Have ETL testing experience in Informatica Power Center tool.
Experience in writing and execution of complex SQL, ETL/Interfaces/Backend testing/Data mart testing.
Having good knowledge on Database Testing.
Good Exposure to Data Warehousing/ETL concepts.
Hands on experience in Incremental Load Testing in ETL.
Involved in writing Test Scripts and execution by Clear Quest, TFS (Team Foundation Server), Quality Center, JIRA Tool.
Involved in writing SQL Queries on SQL Developer, Microsoft SQL Server, Monet, Hive, PostgreSQL and Oracle Tool (Toad).
Good experience in working on UNIX and Linux environments.
Experience with CI/CD pipelines and integration of ETL testing within DevOps environments.
Good knowledge on git/bit bucket, Jenkins, Docker concepts.
Well versed and have working experience with the V-MODEL of Software Development Life Cycle, Agile Methodologies, Water fall, Testing Life Cycle and DEFECT LIFE CYCLES.
Expertise in development of test scenario, test plan followed by review, execution, troubleshooting and reporting of bugs for application software.
ISTQB Certified Tester (Foundation Level).
Exposure to cloud data platforms like AWS.
Involved in Test Case Design, Execution and Result Analysis.
Possesses excellent communication skills along with sound ability to interact with clients, based on technical and business requirements.
Capability of working under pressure, to meet strict project deadlines and achieve complete customer satisfaction.
Flexible and versatile to adapt to any new environment and work on any project in testing domain.
Technical Skills:
Operating Systems : Windows, UNIX, Linux.
Database : SQL Developer, Microsoft SQL server, PostgreSQL, Hive, Monet, Oracle
Testing Tools : Clear Quest, TFS, Quality Center, JIRA (zephyr squad Jira),Unix Putty, WinScp
ETL Tool : Informatica Power Center
API Tools : SOAPUI, Postman for Windows (10.21.0)
Domain Knowledge : Automotive, Retail, Banking, Background Verification, Telecom Billing
Methodologies : SDLC, STLC, Agile Methods, BUG LIFE CYCLE.
Education:
Bachelor of Engineering in Information Technology from Biju Patnaik University of Technology (BPUT), INDIA
Interpersonal Skills:
Highly organized and dedicated with a positive approach for problem solving.
Self-starter and highly positive attitude for learning for developments.
Have excellent ability to communicate clearly and honestly.
Ability to handle multiple assignments under pressure and consistently meet the set time frames.
Thrive on working in a challenging environment.
Commitment to teamwork, continuous learning, and skill development.
Career Experience:
APEXON (Techno soft Corporation) SEP 2023 – AUG 2024
Project 1 (Current) : CVFM,ACMS2,ECM
Organization: Apexon
Role
Functional, ETL & API tester
Client
Volkswagen Group of America
Tools
Jira, Confluence, Postman for windows, WinSCP, Putty, Informatica Power Center
Database
Toad for Oracle 17.0, Microsoft SQL server, Data Lake Hive, Impala
Responsibilities
• Understanding the requirement by going through the design document.
• Understanding the end to end process flow of the project right from loading the source data into staging table.
• Prepared Test scenarios document.
• Involved in test case preparation and testing of Stories in each sprint/release.
• Designing & Executing test cases.
• Responsible for writing, executing, and debugging SQL queries to perform data completeness, correctness, data transformation and data quality testing.
• Running the Workflow/Packages for ETL process.
• Writing SQL queries to validate the ETL process.
• Designing & Executing test cases.
• Verifying the data between source (Microsoft SQL server) target database (Hive) after ETL process is completed.
• Utilized Pytest testing framework to automate test case.
• Used Python Pandas for data validation, manipulation.
• Tested REST APIs calls such as GET call, POST call.
• Writing SQL queries to validate the data between API response and source database.
• Communicating with other team’s members (Development Team, Technical Support, and Business Support) in order to resolve the issues.
• Reporting the Daily and Weekly Status Report to the client.
• Involving in Standup meetings, addressing the issues with developer, scrum master and clients.
• Involved in Effort estimation process during the Test Planning phase.
HARMAN CONNECTED SERVICES April 2014 – May 2023
Project 2 (Past) : Autobahn
Organization: Harman
Connected Services
Role
ETL & Functional Tester
Client
IRI / Circana
Tools
Jira, Confluence, Airflow, WinSCP, Mobaxterm, DB Runner, Unix Putty, SSMS
Database
Microsoft SQL server, PostgreSQL, Hive, Monet
Responsibilities
•Understanding the end-to-end process flow of the project right from loading the source data into staging table.
•Involved in System testing for each module after development is completed.
•Prepared Functional test cases in all the phases of ETL Testing.
•Involved in preparing the Test Plan document.
•Involved in End-to-End testing.
•Responsible for writing, executing and debugging SQL queries to perform data
completeness, correctness, data transformation and data quality testing
•Writing SQL queries to validate the ETL process.
•Designing & Executing test cases.
•Verifying the data in target database (Hive & Monet) after ETL process is completed.
•Involved in testing different reports in Unify UAT and production environment.
•Communicating with other team’s members (Development Team, Technical Support,
and Business Support) in order to resolve the issues.
•Reporting the Daily and Weekly Status Report to the client.
•Involving in Standup meetings, addressing the issues with Onsite coordinator, and
scrum master and clients.
•Involved in Effort estimation process during the Test Planning phase.
Project 3 (Past) : SAS Migration
Organization : Harman Connected Services
Role
DB Tester
Client
IRI / Circana
Tools
WINSCP, Unix Putty, Mainframe
Database
SQL Developer
Responsibilities
•Understanding the migration project as there are around 700 SAS jobs were in the scope of migrating to Python.
•Understanding of Mainframe framework
•Involved in preparing Functional test cases.
•Responsible for writing, executing the test cases in Mainframe to perform data completeness, correctness, data transformation and data quality testing.
•Verifying/Comparing the data Source vs. Target files.
Project 4 (Past) : ARGO
Organization: Harman Connected Services
Role
DB Tester
Client
Ellucian, USA
Tools
Jira, QA Complete, Oracle, Docker, Jenkins
Responsibilities
Understanding functional requirement specifications.
Involved in configuring setup for Cobol, Java, ProC, Shell processes.
Involved in compiling the Cobol, ProC, Shell processes.
Involved in running the Cobol, ProC, Shell processes after the compilation is successful.
Involved in analyzing the requirement using Banner application.
Involved in writing shell & SQL scripting and executing the batch jobs and verifying the data in reports.
Involved in automating the batch process automation using Groovy, shell scripting.
Involved in writing Groovy scripting (which is compatible Oracle and other data bases) and executing the batch jobs and verifying the data in reports.
Identifying the issues or blockers, raising the bugs and assigning to SME’s/
Developers/Architects.
Re-testing the issues/blockers once the bug is fixed.
Involved in configuring the seed data creation using Oracle SQL and generating XML’s file based on inputs provided by SME’s and running the jobs and validating the data in reports.
Involving in Scrum meetings, addressing the issues with customer.
Project 5 (Past) : Contractor Advantage
Organization: Harman Connected Services
Role
Functional tester
Client
First Advantage Offshore Services
Tools
JIRA, Confluence, SQL Developer, SQL Plus, Citrix, Jenkins, SoapUI 4.5.1, Postman
Responsibilities
Involved in requirement discussion with all the stake holders in the group meetings.
Engaged with engineering team in preparing High Level estimates.
Proactive discussions with Scrum master and project management team in finalizing the sprint items for future releases
Actively involved in Daily Scrum meetings
Proactively initiated the Demo calls with the onsite Project manager.
Being SME, helped my team member to understand the functionality and business flows.
Trained new members (QA, Dev, automation team and also the newly joined BA) in the project on the business/functional flow of the application.
Involved in test case preparation and testing of Stories in each sprint/release
F IR S T A D V AN T AG E June 2012 – March 2014
Project 6 (Past) : FLEET
Organization: First Advantage
Role
Functional tester
Client
First Advantage Offshore Services
Tools
TFS (Team Foundation Server), SQL Developer
Responsibilities
Involved in Functional, Regression and User Acceptance Testing of Fleet Application.
Testing web application/services of the Fleet solutions.
Analysis of Business Requirements and Creating Scenarios.
Involved in writing SQL Queries on Microsoft SQL Server 2008. Defect logging on TFS (Team Foundation Server).
A M D OCS I N DI A P V T LT D Dec 2009 – April 2012
Project 7 (Past) : Amdocs Cramer (OSS)
Organization: Amdocs India Pvt Ltd
Role
Functional tester
Client
Virgin Media, UK
Tools
HP Quality Center, Toad for Oracle, UNIX, Cramer
Responsibilities
Involved in Functional, Regression and User Acceptance Testing of Cramer Application.
Analysis of Business Requirements and Creating Scenarios.
Involved in creation and execution of Test Cases.
Involved in writing SQL Queries on Oracle Tool (Toad)
Defect logging on HP Quality Center.
Test script review and troubleshooting of issues.
Project 8 (Past) : Sensis
Organization: Amdocs India Pvt Ltd
Role
Functional tester
Client
Telstra, Australia.
Tools
HP Quality Center
Responsibilities
Have worked on Change Requirements (CRs).
Attending Business meeting with end customers for reviewing CRs, test planning and execution of the CRs.
Development of test scenario, test plan followed by review, execution, troubleshooting and reporting of bugs according to Business Requirements.
Coordinated the onsite team (Melbourne, Australia) for performing User Acceptance Testing in live customer environment.
Retest critical defects assigned from end customer.
Logging and Tracking defects in Quality Center (QC).
Involved in System testing.
Involved in automation testing using QTP tool with execution and debugging skills using QTP.
Have worked as POC in campaign management domain.
Managed a team of 6 members by allocating tasks and solving issues faced by team members.
Mentoring new team members for process, technical and business requirements for the project.
AC C ENT U RE S E R VI C E S I ND I A P V T L T D Feb 2007 – Dec 2009
Project 9 (Past) : BT Retail E2E Testing
Organization: Accenture Services India PVT LTD
Role
Functional tester
Client
British Telecom
Tools
HP Quality Center, Toad
Responsibilities
Involved in End to End Testing of Business Products module.
Preparation of Test conditions based on the analysis.
Test Case, Test Script writing and Defect logging on HP Quality Center.
Involved in writing SQL Queries on Oracle Tool (Toad).
Test script review, execution, debugging and troubleshooting.
Project 10 (Past) : MOSS
Organization: Accenture Services India PVT LTD
Role
Functional tester
Client
Grant Thornton International
Tools
TFS (Team Foundation Server).
Responsibilities
Involved in System Integration and End to End Testing of MOSS (Microsoft Office SharePoint Server) Application.
Preparation of Test conditions based on the analysis.
Project 11 (Past) : DBS Core Banking Solution
Organization : Accenture Services India PVT LTD
Role
Functional tester
Client
Development Bank of Singapore
Tools
Clear Quest
Responsibilities
Testing for the Lending Module for DBS core banking solution.
Analysis of Functional Documents.
Preparation of Test conditions based on the analysis.
Preparation of highly complex Test Scripts.
Requirements Mapping done with the Test Scenarios prepared.
Preparation of High Level Test Scripts for the Interfaces involved in Finacle based on the Test Scenarios.
Test Data Preparation.
Kept track of all the deliverables prepared by me and made sure that I meet strict project deadlines and achieve complete customer satisfaction. Functional testing of Finacle.
•Communicating with other team’s members (Development Team, Technical Support, and Business Support) in order to resolve the issues.
•Reporting the Daily and Weekly Status Report to the client.
•Involving in Scrum meetings, addressing the issues with scrum master.
Identified bugs in stories and application and reports on time to the concerned people through JIRA.
Bugs are raised in JIRA with the proper description, Steps to reproduce and the screenshot documents in JIRA.
Actively involved in process activities in the project - implemented standard processes in testing phase.
Created Regression Suite, Sanity test suite and appropriate test cases for the project.
Sends Status Report to offshore & onsite Mangers on Daily and weekly basis.
Provides appropriate comments and suggestions during the project meetings.
Have a very good rapport with the offshore and onshore team members in the project.
Communicates issues, problems, concerns and suggestions to concerned/appropriate people on time.
Assures quality output of work on desired time.
Involved in QC build deployment & complete End to End testing process.
Involved in Badge Bar Code testing using QR Scanner in Smartphone.
Involved in Regression testing.
Involved in UAT and Production checkout testing - involves in Smoke & Sanity testing for UAT & Production releases.
Monitoring the resources and guiding them of the day today tasks that need to be completed.
Preparation of highly complex Test scripts.
Defect Logging and tracking done in TFS (Team Foundation Server) Tool.
Involved in reviewing of Test scripts.
Involved in Test execution of MOSS Application.
Contact this candidate