Post Job Free

Resume

Sign in

Project Manager Sql Server

Location:
New York, NY
Posted:
September 12, 2023

Contact this candidate

Resume:

Kartic Chandra Saha

Work Authorization: US Citizen

Location: New York, NY 10018

linkedin: https://www.linkedin.com/in/kartic-saha-238242a1/

Email: adznfy@r.postjobfree.com

Ph: 646-***-****

Career Summary:

As a Software QA Analyst, I have 10+ years of experience in different domains like Financial, IOT Telematics, Healthcare, Insurance (Workers Compensation Claim). I have solid experience in Automation and Manual testing. I have strong exposure in UI, Database/Back-end testing and API testing in Onprem and AWS, Microsoft Azure. Experienced in Cucumber, Gherkin, Maven, Behavior-driven development (BDD), Selenium WebDriver, Java. Experienced in SDLC, analyze requirements. Expertise in finding scenarios, writing and executing test cases, log and close bug maintaining bug life cycle. Used the market leading test management tools Jira/ALM. Experienced work in Agile Methodology. Lead the offshore team.

Strength in Software Testing:

●Sound Knowledge of Software Development Life Cycle (SDLC) and Methodologies like Agile, Waterfall.

●Experienced in API Testing, Backend and Front-End/UI testing in different Domains.

●Experienced in defining and creating Test Plan.

●Good experience in interacting with Business Analyst, Product Owner and developers to analyze the User Requirements, Functional Specifications and System Specifications.

●Expertise different types of testing like Unit, Functional, Blackbox, Whitebox, Smoke, System, Regression, End-to-End, Parallel, Integration, UAT testing, Load testing, Stress testing, Performance testing.

●Experienced using test management tools like Jira, ALM.

●Experienced using automation tools Selenium (IDE, Web driver), UFT.

●Experienced in writing RTM (Requirement Traceability Matrix), TPD (Test Plan Document).

●Strong skills in Back-end testing using SQL queries on Oracle, Cassandra, MySQL, Postgres.

●Working experience in OLTP Projects (Source to Target conversion) using Transformation rules.

●Expertise in analysis of Problem severity, Defect tracking and Defects reporting system.

●Participated in evaluating and implementing tools, methods, technologies, standards and practices in order to make the QA department and IT as a whole more effective and efficient in providing service to clients.

●Proactively studied various kinds of testing concepts and templates from various sources and effectively implemented them across the organization.

●Worked in Finance, Banking, Mortgage (Ginnie Mae, GMEP, Platinum Pool Processing), Auto Telematics, IOT-Telematics (Internet of Things), Health Care, ERP and Billing Applications.

●Extensive knowledge in gathering and understanding BRDs (Business Requirements Document), FRDs (Functional Requirements Document), FRSs (Functional Requirements Specification), SRS (Software Requirement Specifications) and Use Cases.

●Able to work in a team as well as independently.

●Strong written and verbal communication skills and able to coordinate across multiple teams.

Strength in Database Management Systems

●Performed Queries and Manipulated Data in databases Oracle, SQL Server, Cassandra, Aurora.

●Understanding of basic PL/SQL Programming and Constructs as procedure, functions.

Technical Skills:

Test Management Tools : Jira, ALM

Automation Tools : Selenium Web driver with Java, UFT, JMeter

Operating System : Windows, UNIX

Languages : Java

Scripting Languages : VB script, Java script

Database : SQL Server, Oracle,Cassandra, MS Access

Other Tools : TOAD, Informatica

Application Packages : MS-Office, Microsoft Outlook, Microsoft Lync, MS-Project, Slack

Professional Experiences:

Webtools Project of USPS Apr 2022 – Present

Assigned Role: API Tester(Fullstack)

Responsibilities:

●Analyzing Project Requirements Document (RD).

●Writing Test Cases using ALM and executing test cases.

●Attending daily standup meetings and defect review meetings.

●Tested applications and logged the defects in ALM.

●Solid experience of API testing with tools like Postman.

●Conducting automated API testing with Postman and JMeter.

●Using JSON/XML requests in the API body.

●Validating backend data using methods GET,POST,PUT, DELETE.

●Response codes 200, 400, 401, 500.

●Automate the collection of the API requests using test data files.

●Functional, Regression Test suite testing.

●Performing UAT Testing.

PNC Bank Feb 2022 – Mar 2022

Project: Retail Banking

Assigned Role: QA Analyst

Project & Assignment Description:

●Reviewed and analyzed system specifications for Retail Banking.

●Prepared Test Cases and test data.

●Conducted different types of testing.

●Performed Interactive Voice Response (IVR) testing for the Bank.

●Document, report, and track software defects using JIRA.

●Created test cases in Jira(Xray) and executed test cases in Xray.

●Performed API testing using tool Google Postman and started api testing with Karate framework.

●Worked in Genesys Cloud Environment.

Environment: Agile/Scrum, Microsoft Teams, Jira (Xray), Oracle, Postman API.

Public Consulting Group(PCG) Feb 2022 – Feb 2022

Assigned Role: QA Analyst

Project & Assignment Description:

●Performed API testing and Project documentation.

Customized Energy Solutions (CES) Aug 2021 – Jan 2022

Project: Retail Energy

Assigned Role: Sr. QA Analyst

CES advances the growth of energy retailers by providing an end-to-end comprehensive offering of hosted solutions, expertise. CES offers a series of hosted platforms developed and serviced by a team of industry experts specializing in competitive energy market entry and operations, state and regional grid registration, renewable compliance and market intelligence. CES combines efforts to make day-to-day operations run more smoothly and business grow more quickly.

Project & Assignment Description:

●Analyzed system specifications for Retail Energy.

●Prepared Test Cases and test data.

●Attended daily standup meeting.

●Review and analyze system specifications

●Develop, document, and execute QA test cases for new functionality.

●Backend validation for data completeness/correctness.

●Document, report, and track software defects using JIRA.

●Enter test cases in Jira(Xray) and execute test cases in Xray.

●Performed API testing using the tool Google Postman.

●Performed regression testing.

●Ran the SQL Retail SSIS jobs, DB tasks.

●Participated in all aspects of the software development life cycle and Agile ceremonies.

●Encourage a culture of accountability for ensuring the system has minimal defects and adheres to company standards.

●Help troubleshoot issues.

●Worked with cross-functional teams to ensure quality throughout the software development lifecycle.

Environment: Microsoft SQL Server, SSIS, Blue UI, Agile/Scrum, Microsoft Teams, Jira (Xray).

Duck Creek Technologies, NJ Oct 2019 – July 2021

Project: Workers Compensation Claim(Insurance)

Assigned Role: Sr. QA Automation Engineer

Responsibilities:

●Played a very strong QA role for the client company.

●Analyzed Requirements Document (RD).

●Prepared Test Cases and reviewed.

●Attended daily standup meeting.

●End of Sprint attend Retrospective, Demo (Story, Bug) and New sprint planning meeting.

●Perform Functional, Blackbox, Whitebox, Smoke, System, Regression, End-to-End testing.

●Tested insurance UI ‘Workers Compensation Claim’.

●Used Azure DevOps for Bugs logging.

●Performed API testing using the tool Google Postman.

●Created/Updated Regression Script for API testing.

●Used Automation Tool ATC (Automation Testing Center) for creating automation scripts.

●Performing SQL Server backend testing, IIS server, SQL Script.

Environment: Microsoft Azure DevOps, Microsoft SQL Server, Team Foundation Server (TFS), Microsoft Test Manager (MTM), Microsoft Visual Studio, VM Claim, VM console, Phoenix Tenant, Selenium Web driver, Java, Share point, Agile, Scrum, Skype Business, Microsoft Teams.

Healthfirst Mar 2019 – May 2019

Project: Health Insurance

Assigned Role: Sr. QA Analyst

Responsibilities:

●Prepared test cases from the business logic and user requirements.

●Sync up with Business Analysts for understanding requirements.

●Designed Test Plans, Test Procedures and Test Cases and Executed Test Cases.

●Performed Backend Database Testing with the SQL queries.

●Used HP Quality Center as a test management tool where logged the bugs.

●Worked on domain HIE (Health Information Exchange) and HL7 (Health Level 7)

Environment: Quality Center, XML, SQL Server, Windows, Agile, Scrum

Verisk Analytics, Jersey City, NJ Feb 2016 – Feb 2019

Project: IOT Auto Telematics

Assigned Role: Sr. QA Engineer

Verisk Analytics, Inc. is an American data analytics and risk assessment firm based in Jersey City, New Jersey and San Francisco, California, serving customers worldwide in insurance, natural resources, financial services, government, and risk management. The company uses proprietary data sets and industry expertise to provide predictive analytics and decision support solutions in fraud prevention, actuarial science, insurance coverages, fire protection, catastrophe and weather risk, data management, and other fields.

Responsibilities:

●Performed my QA role for IOT Auto Telematics Project.

●Analyzed Project Requirements Document (RD).

●Wrote Test Cases using Jira/Excel sent for review to BA/Team lead/Project Manager.

●Attend daily standup meetings and defect review meetings.

●Attended mob development as driver and Navigator.

●Attend Retrospective, Demo and Sprint planning meetings at the end of every sprint.

●Executed Unit, Functional, Blackbox, Whitebox, Smoke, System, Regression, End-to-End, Parallel, Integration, UAT testing, Load testing, Stress testing, Performance testing.

●Tested applications and logged the defects in Jira.

●Solid experience of API testing with tools like Postman, Swagger

●Conducted End to End automated API testing, Load and Performance testing with the JMeter.

●Generated response using JSON request in the API body.

●Used Datastax DevCenter and Apache Solr to query the backend data.

●Performed ETL transformation from source Cassandra to target SQL server data migration.

●Performed data migration testing from On Premise to AWS.

●Experienced AWS tools (EC2, S3 bucket, Lambda function, PostgreSQL).

●Experienced API migration validation from on premise to AWS Environment.

●Established framework with Selenium Web driver, Junit, TestNG, Cucumber and designed feature file, wrote test cases in BDD environment.

●Expert finding elements in a web page using ID, Name, Tag, Attribute, CSS, Linktext, PartialLink text, Xpath.

●Applied Assert, verify command to check if the element is on the page or not. Used Explicit and Implicit wait when searching elements.

●Implemented collections Array and Hashtable.

●Used Junit annotations like Test, Before, After, Ignore, BeforeClass, AfterClass.

●Experienced in Jenkins, versioning tools (Git, Bitbucket, GitHub).

●With the hands-on Java coding, created Java Class, Objects, Constructor, Interface, Extends class to a child class.

●Applied java function overloading, Constructor overloading, function overriding.

●Implemented java OOP concepts Inheritance, Polymorphism, Abstraction, Encapsulation in the project automation.

●Implemented Javascript in Selenium Webdriver with the predefined Interface JavascriptExecutor which is available under package org.openqa.selenium.JavascriptExecutor.

●Implemented javascript in Selenium webdriver instead of using sendKeys method, if the radio button or checkbox is disabled.

●Extended the java class, applied interface, initiated objects for the project.

●Lead the offshore team of QA resources. Get the work status and mentor them.

Environment: AWS, Redshift,Cassandra, SQL Server, Aurora, Windows, Jira, Selenium Web driver, JMeter, Datastax DevCenter, Apache Solr, Confluence, Slack, Skype Business, Agile, Scrum.

Bank of New York Mellon, Brooklyn, NY May 2015 – Dec 2015

Project: Mortgage

Assigned Role: Sr. QA Analyst

BNY Mellon was engaged in a major systems modernization effort from Ginnie Mae. Multiple phases of this modernization effort and it included automation of several processes that previously were paper-based. The new functionalities will be available to users via the Ginnie Mae Enterprise Portal (GMEP). As Sr. QA Analyst I was responsible for test creation of test designs, participating in walkthroughs of testing procedures, Test processes, Test cases and Test data development, executing test cases, preparing all reports, Analyzing the results and then submitting them to Project Manager. I worked with the Ginnie Mae Platinum Pool Processing (Mortgage) Project.

Responsibilities:

●Analyzed the Requirements Definition Document (RDD) and Technical Design Documents (TDD)

●Wrote Test Cases in ALM and generated a document of test cases from ALM and sent for review to BA/Project Manager.

●Attended every day work status meeting and defect review meeting.

●Expertise Manual, Automated, Unit, Functional, Blackbox, Whitebox, Smoke, System, Regression, End-to-End, Integration, UAT testing, Load testing, Stress testing, Performance testing.

●Executed test cases and logged the bug (Document verification and functional defects) in ALM.

●Worked on OLTP (Online Transaction Processing) data conversion from the mapping document.

●Tested data migration from source to target maintaining transformation rules through insert and update.

●Created Test Bed data for Insert and Update testing.

●Worked on OLTP Delta Load (Insert and Update testing).

●Maintained continuous communication with BA, Developer, product owner to resolve defects.

●Keep close contact with the team members to speed up the work flow.

●After signing off the testing report to the BA, QA Lead, QA Manager and Project Manager.

●Used automation tool UFT (UI automation), JMeter (Performance test).

●Worked on multiple projects dividing the bandwidth.

Environment: Mainframe, Windows, Oracle, HP ALM/Quality Center, Microsoft Lync, Citrix receiver, Agile, Scrum.

KPMG LLP United States, Montvale, NJ June 2013 - Apr 2015

QA Analyst

KPMG LLP has been developing Tax Technology Tools. KPMG’s Global Tax Technology Practice (TTP) is a multi-disciplinary team of professionals, proficient in both tax technical issues and technology innovation, responsible for developing, delivering and supporting software applications for KPMG's Tax clients and Tax professionals across the U.S. and around the world. I worked on Federal Tax as a Tester in Montvale, NJ.

Responsibilities:

●Analyzed the Product Backlog Items from the current Sprint.

●Discussed Product Backlog Items with Developers from the running list.

●Logged the Bugs using tool Microsoft Team Foundation Server with the attachments/screen shots and linked the Bugs with the required stories.

●Notify Bugs to Developers, Test Lead and other Testers.

●After the fix retested and closed the bugs.

●Participated in a Daily Scrum meeting through a quick conference call and shared with the Scrum Master what I did yesterday, What I will do today and any impediments.

●End of every Sprint participated in Retrospective, Demo and New Sprint Planning Meeting.

●Attended Monthly QA meeting and submitted the monthly work status report.

●Tested Applications in different Environment Like sQA, iQA, UAT and PROD.

●Participated in Production Release Testing and performed Smoke, Integration Testing and reported the issues.

●Created test data for Functional and Regression testing.

●Designed Test Plan, Test Cases and Executed Test Cases.

●Performed smoke, functional, regression, black box, white box, gray box, sanity, UAT, End to End testing.

●Validated backend data with the SQL scripts.

●Created and Tested Resource Request (RR) for Offshore Agency.

Environment: Microsoft Azure, SQL Server, Windows, .NET, Microsoft Team Foundation Server (TFS), Microsoft Visual Studio, Microsoft Lync, VPN, Agile, Scrum.

Application Security, Inc. NY Sep 2011 - May 2013

SQA Tester

I have tested AppDetectivePRO (Database and Big Data Scanner) and DbProtect (a data security platform that uncovers database configuration mistakes) and ASAP Updates (Application Security Automatic Protection Updates).

Responsibilities:

●Discussed with Business Analysts to understand the business process and write the test cases based on the different business scenarios.

●Involved in the Business Scenario Analysis and Test Case Scripting for the Data Management System.

●Communicate with DBA and other related entities to facilitate test environments for tester and end user for UAT.

●Communicate with the End User to Facilitate the UAT.

●Create, update and monitor Testing Status Matrix to keep track of the Daily testing Status Report.

●Document, implement, monitor, and enforce all processes for testing as per standards defined by the project.

●Check / Review the Test Cases documents.

●Monitor and Participate in all phases of testing life cycle including document reviews, and project status meetings.

●Create SQL Test Script for data validation, functional and Regression testing.

●Test data creation for UAT (User Acceptance Testing), Functional and Regression testing.

●Interacted with Business Analysts for requirements, and analyzed design documentation requirements and business scenarios.

●Designed Test Plans, Test Cases and Executed Test Cases.

●Performed smoke, functional, regression, black box, white box, gray box, sanity, UAT, End to End testing.

●Provide Test Reports, Documented and Communicated test results with management.

●Participate in Daily Testing status meetings and coordinate with the Developers and Testers to resolve and close defects.

●Wrote and executed SQL scripts for back end testing.

●Ensure the timely delivery of different testing milestones.

●Conduct reviews, walk throws, inspections and meetings to improve the quality of the product.

●Involved in Data Analysis in the ETL process and Contribute to the analysis of data requirements and data migration.

Environment: XML, HTML, SQL, Dynamic SQL, SQL server 2008, MS Office 2007, Windows XP, .NET.

CareFirst, Washington, DC Jun 2010 - Aug 2011

Test Engineer

The goal of CareFirst is to provide quality health services across the Maryland, Delaware and Washington, D.C. region by offering affordable and accessible products. I worked as a backend tester of customer databases and on Medical plans, Dental plans, and vision plans.

Responsibilities:

●Prepared detailed test cases by understanding the business logic and user requirements for manual and automated testing.

●Interacted with Business Analysts for requirements, and analyzed design documentation requirements and business scenarios.

●Designed Test Plans, Test Procedures and Test Cases and Executed Test Cases.

●Performed Backend Database Testing by writing and running SQL queries.

●Developed test scripts for GUI, functionality and regression testing using Quick Test Pro (QTP).

●Developed, enhanced and maintained automated testing scripts with QTP for functional Regression testing.

●Created Check points and Synchronization points using QTP for functional testing.

●Performed Descriptive Programming for QTP wherever necessary.

●Used HP Quality Center for Business Process Testing, test planning, defect report and executing the test cases.

●Worked as Quality Center project administrator, customized the project to meet testing needs.

●Reported defects in a timely manner and logged them into the Quality Center.

●Performed data creation upon requests for UAT (User Acceptance Testing).

●Analyzed software and business requirements documents to get a better understanding of the system from both technical and business perspectives.

●Analyzed Business specifications documents and attended Change Request meetings to document changes and implemented procedures to test changes.

●Worked on domain HIE (Health Information Exchange)

●Worked with the Hospital Edges message transformation through HL7 (Health Level 7)

●True Care End to End testing. Verified demographic data of True Care and Health share the same. Active member, Active in True Care Cohort.

●Process different types of messages (Create, Update, Discharge, Transfer, Cancel admit, Cancel discharge)

●Hospital patient data mockup and sent it through Hospital edges.

●Generated reports.

Environment: Quality Center, QTP, VBScript, XML, SQL, PL/SQL, MS Access, Java, JavaScript, Windows, Unix, Agile, Scrum.

Educational Qualification:

Master of Science - Mathematics - University of Dhaka

Bachelor of Science – Mathematics, Physics, Chemistry

International Diploma in Computer Studies (IDCS), NCC(UK)

International Advanced Diploma (IAD) in Computer Studies, NCC(UK)



Contact this candidate