Surbhi Arora
Pittsburgh, PA
******.****@*****.***
https://www.linkedin.com/in/surbhiarora2989
SUMMARY:
1.Overall 8 years of Total Experience in the IT Industry and Proficient in various testing techniques like System Integration Testing, ETL Testing, API Testing, Functional Testing, Smoke Testing, Database Testing and providing support to UAT Testing.
2.Acquainted with Agile Scrum framework, SDLC, STLC, Iterative and Waterfall delivery methodologies
3.Experienced in preparing Test Strategy, Test Estimations, Test Plan and generating various Test Reports
4.Experienced in Project portfolio management for supporting Production Releases
5.Profound knowledge in Logistics Domain and fair knowledge in Capital Market
6.Skilled in preparing Monthly Executive Reports, PMO Metrics Dashboards, Weekly and Daily Execution Metrics and Defect Metrics
7.Hands on experience in Web Service testing, API Testing, Database Testing, Informatica Testing, UI testing, and testing of Web based applications.
8.Knowledge on Informatica PowerCenter, CA Work load automation and Selenium Automation tools
9.Proficient in conducting Work Product Reviews with stake holders.
10.Experienced in developing RTM (Requirement Traceability Matrix) and DTM (Defect Traceability Matrix) to trace the status of the project and defects
11.Expertise in Test Management tools such as Application Lifecycle Management
12.Proficient in identifying defects and defect management using HP-ALM
13.Experienced in Training new onboard resource by providing KTs and required sessions
14.Accountable for Test coverage, follow-up on outstanding issues and Quality delivery
15.Independent worker and capable to accomplish results in any kind of environment with minimal supervision.
16.Strong decision making, Analytical and work prioritization skills which helps me to manage multiple projects on different schedules.
17.Proficient in understanding the Business Requirements and providing sessions to the different teams (Test/Dev UI/Dev API)
EDUCATION:
• Bachelor of Technology in Computer Science and Engineering
EMPLOYMENT HISTORY:
Atos Syntel Inc (Formerly known as Syntel Pvt Ltd): April 2012 to till date
TECHNICAL PROFICIENCY:
Operating System
Windows XP/ Win7/ Win8
Database
Oracle and PL/SQL
Microsoft tools
MS-Word and MS-Excel
Automation Tools
Selenium
Test management tool
HP ALM
Desktop Virtualization
Citrix
Requirement Management
AGM, Caliber
Defect tracking tool
ALM and Pivotal Tracker
Job Scheduling Tool
IBM BPM QA Automation Tool
CA Work Load Automation Tool
Business Intelligence Tool
MicroStrategy
ETL Testing Tool
Informatica PowerCenter
API Testing Tool
Restlet Client
Process Management
Project portfolio management
PROJECT HISTORY:
FedEx ePAT (Enterprise Pricing Analysis Toolkit) 15-Sep-2019 to till date
Project Description: This project is an application which is built for Pricing Analyst so that they were can generate list rates, profit and loss statements across their multiple business units.
Before this project each business unit used to produce profit analysis statements using diverse and non-standard applications.
However, with this project, business analysts would be able to create globalized P&L statements across all business units. This application is interfaces with other Pricing systems to pull and push shipment data automatically such as importing shipment detail, Shipment Metrics from other external applications
Team Size: 15 members
Responsibilities:
As a Test Lead and Onsite Coordinator, I am responsible for:
Participating in daily stand up meeting among whole team to understand day to day progress, mitigate any foreseen risk and help to resolve impediments if any.
Project planning, Test Strategy preparation, customer communication, managing deliverables, Detailed Test Plan creation and implementation.
Updating Test Results in PPM ( Project Portfolio Management) to confirm Production movement of the code
Proving UAT support to Customer and performing Pre and Post production checkouts
Working with client Business and IT team to understand the requirement and passing the same knowledge to different teams (Testing, Development UI and Development API) to make sure everybody has requirement understanding and there are no understating gaps.
Manage and participate in daily scrum call and prepare the weekly progress update to customer.
Coordinate with multiple eternal teams on dependencies and hand shake process during production releases.
Participating in PI planning to align development & business goals with business context & vision and to make sure demand is as per capacity of teams.
Participating in Sprint Planning meeting to understand Sprint goal and backlog containing all items that could be fully implemented until the end of the Sprint by my team.
Stating Quality standards for the team which should be followed throughout the project to mitigate the rework efforts
Ensuring adherences to quality standards on deliverables made by reviewing the work delivered by my team before sharing with stake holders.
Closely working with business for managing the requirements
Doing RCA and provide analysis to development team for quickly fixing the defects.
Providing subject matter expertise to software sub-teams teams for developing and executing component, performance and regression tests
Conducting Retrospective meeting at the end of sprint to discuss the success, failures, lessons learnt and areas with scope of improvement.
FedEx CPM (Customer Pricing Map) 15-Sep-2018 to 14-Sep-2019
Project Description: The objective of this project is to provide insight to pricing analyst so that they are able to understand what type of pricing is loaded at which level for a customer hierarchy and facilitates the analysis of all pricing within a hierarchy. Pricing Analyst want to use these analyses because they want to migrate their legacy customer to new pricing systems and in order to achieve that they want to make the decisions based on customers’ existing pricing.
Team Size: 15 members
Responsibilities:
As a Test Lead, I am responsible for:
Work within a highly collaborative environment where developers, testers and the business work together as a team to deliver the best possible software
Project planning, Test Strategy preparation, customer communication, managing deliverables, Detailed Test Plan creation and implementation.
Coordinated with the development team for prioritizing the defects.
Working with client Business and IT team to understand the requirement and passing the same knowledge to different teams (Testing, Development UI and Development API) to make sure everybody has requirement understanding and there are no understating gaps.
Manage and participate in daily scrum call and prepare the weekly progress update to customer.
Coordinate with multiple eternal teams on dependencies and hand shake process during production releases.
Participating in PI planning to align development & business goals with business context & vision and to make sure demand is as per capacity of teams.
Participating in Sprint Planning meeting to understand Sprint goal and backlog containing all items that could be fully implemented until the end of the Sprint by my team.
Stating Quality standards for the team which should be followed throughout the project to mitigate the rework efforts
Ensuring adherences to quality standards on deliverables made by reviewing the work delivered by my team before sharing with stake holders.
Closely working with business for managing the requirements
Performing manual testing of applications developed by my team
Doing RCA and provide analysis to development team for quickly fixing the defects.
Conducting Retrospective meeting at the end of sprint to discuss the success, failures, lessons learnt and areas with scope of improvement.
ManuLife 28-Aug-2017 to 11-May-2018
Project Description: It was a Capital Market domain project. I was part of Middle office team and the objective of this project was to Calculate the Price for the stocks and make them available on time to the users. There are set of Jobs which run at specified timings and calculate the stock prices and if prices are not there, they request the prices to vendors and make them available for end users. It was very critical application as it was directly hitting the stock market.
Team Size: 10 members
Responsibilities:
As a Consultant and Test Lead, I was responsible for:
Participating in Product Requirement meetings with the stakeholders on Testability.
Writing test cases and executing them and then Sharing Test Results with all stakeholders
Creation of SQL Queries based on requirement.
Perform Informatica, database, functional and regression testing
Comparing source files from Production and Test using Beyond Compare
Report and follow up on the bugs found during testing
Responsible for status updates to summarize project highlight, daily status reports, held follow-up meetings on complex outstanding issues and QA dashboards.
To provide evidences and artifacts which would facilitate stake holder’s decision for the Production Movement.
Providing post-production support to work on the issues which might occur when the system was going live
Creating a user manual for the end users who were newly going to use this system and I also successfully automated all these test cases to run as part of regression for future enhancement request.
Did validation for migration testing by comparing the files generated in Test Environment to the files generated in Production Environment
Did even minute level of analysis even if 0.1% of difference is found.
FedEx ePAT (Enterprise Pricing Analysis Toolkit) 17-May-2016 to 31-May-2017
Project Description: This project is an application which is built for Pricing Analyst so that they were can generate list rates, profit and loss statements across their multiple business units.
Before this project each business unit used to produce profit analysis statements using diverse and non-standard applications.
However, with this project, business analysts would be able to create globalized P&L statements across all business units. This application is interfaces with other Pricing systems to pull and push shipment data automatically such as importing shipment detail, Shipment Metrics from other external applications
Team Size: 25 members
Responsibilities:
As an Onsite Coordinator and Test Lead, I was responsible for:
Coordinating distributed testing team of members across Pittsburgh and, Pune (India)
Responsible for status updates to summarize project highlight, daily status reports, held follow-up meetings on complex outstanding issues and QA dashboards
Active participation in Product Requirement meetings with the stakeholders on Testability.
Participating in PI planning and Sprint planning meetings
Participating in Story grooming sessions with business
Writing test cases and executing user stories
Clearing queries raised by offshore team and getting them closed
Maintaining test bed and test results in HP-QC
Creation of SQL Queries based on requirement.
Perform integration, database, functional and regression testing
Report and follow up on the bugs found during testing through ALM
Running regression scripts using automation and doing RCA for the failures
FedEx ePRS-PMGUI (Pricing Maintenance GUI) 19-Oct-2015 to 16-May-2016
Project Description: This is the project which is used by Pricing Admin team to edit the discounts which are already given to customers and are stored in DB. The whole process of agreement generation takes lot of time and if there are some discrepancies even after the final agreement, discounts can be updated through this system. Also, if PA wants to give same pricing to multiple customer, they can use copy additional features through this application which saves lot of time which is spent on agreement generation.
Team Size: 30 members
Responsibilities:
As an Onsite Coordinator, I was responsible for:
Coordinating distributed testing team of members across Memphis, Pune (India) and Chennai (India).
Coordinating Daily stand up meetings.
Providing knowledge transition on business requirements and reviewing test cases.
Coordinating with clients and conducting meeting for review and approval of test scenarios and test cases.
Analyzing different functionalities and test cases for its suitability for Automation
Conducting work product review with Stake Holders for Test Cases prepared by Offshore Team
Updating automation scripts after each change in the application as per new builds and defect fixes.
Reporting the application issues to the development team and management.
Validating build letter and performing smoke testing once new build is pushed
Participating in meeting with Business and IT team for proposed change requests.
Performing SME Reviews for the defects raised by team to prioritize the defects
FedEx ePRS (Enterprise Pricing Request System) 01-Feb-2015 to 18-Oct-2015
Project Description: This is the project which is used by sales team to propose discounts to their customer and to generate agreement once customer accepts those discounts. For proposing discounts, there are many factors which are take into consideration e.g. geographical distance, volume and frequency of the shipments, other handling requirements if any etc.
Considering all those factors, a proposal is created for customer and agreement is generated. This agreement reaches to customer along with the Rate Sheets on the agreed prices. Once the customer signs the agreement, it is stored in Pricing Database and that pricing becomes the effective pricing for the customer now and all the charges are applied as per the agreed conditions.
Also, if the customer does more business than what he committed for, additional discounts are given to them.
Team Size: 35 members
Responsibilities:
As a Project Lead, I was responsible for:
Analyzing different functionalities and test cases for its suitability for Automation
Understanding the application and the Test Cases prepared by Manual Team
Automating the feasible Functionality
Automation using Selenium and a framework which was made by testing services team of Syntel.
Updating scripts after changes in the application as per new requirements
Maintaining Regression Test bed in QC
Running the automated test scripts as per new builds.
Analyzing the test results and logging defects for failures.
Reporting the daily status to higher management.
FedEx ePRS (Enterprise Pricing Request System) 01-Feb-2013 to 31-Jan-2015
Project Description: This is the project which is used by sales team to propose discounts to their customer and to generate agreement once customer accepts those discounts. For proposing discounts, there are many factors which are take into consideration e.g. geographical distance, volume and frequency of the shipments, other handling requirements if any etc.
Considering all those factors, a proposal is created for customer and agreement is generated. This agreement reaches to customer along with the Rate Sheets on the agreed prices. Once the customer signs the agreement, it is stored in Pricing Database and that pricing becomes the effective pricing for the customer now and all the charges are applied as per the agreed conditions.
Also, if the customer does more business than what he committed for, additional discounts are given to them.
Team Size: 35 members
Responsibilities:
As a Software Engineer, I was responsible for:
Liaising with clients and BAs for requirement understanding.
Undertaking different review processes as per the quality goals of project and organization and writing Test cases.
Coordination of induction and knowledge transfer for new team members.
Preparing test cases and getting them approved
Performing peer review on the work done by my team.
Preparing test bed before execution and making sure the test cases counts are correct
Verify test data and test environment are in place before starting execution.
Verifying work delivered by my team and defects logged to make sure they are as per standards
Pulling reports from QC for defects to test case mappings.
Providing timely data to mangers for maintaining all project related matrices and providing data for project management activities.
Handling the major part of manual testing, involving functional and business testing for various modules of the product as per test plan.
FedEx CRSV (Centralized Rating Service Validation) 1-July-2012 to 31-Jan-2013
Project Description: This is the project to validate the proposed changes and its impact on the rating system which is already in production because of addition of new services and increase in Rate for few existing services.
Team Size: 7 members
Responsibilities:
As a Trainee, I was responsible for:
Understanding the Client Requirements and functionality of the system.
Preparing High Level Scenarios based on BRS
Preparing test cases bases for High Level Scenarios and SRS
Executing test cases as per requirement.
Performing System and Functional testing using DTC tool
Preparing the traceability matrix and mapping functional requirements with test cases.
Raising defect, tracking and re-testing
Retesting the cases where defect has been raised.
Prepared understanding document on Applications worked.
Executing all the test cases as per Test Cycles
Supporting production movement by providing pre-production validation results.