Sara Gracious

 Sara Gracious Email:- - Mobile :- SYNOPSIS Performance driven professional with total 9 years of valuable experience in the areas of Manual Testing, Data Warehouse/ ETL testing, Database testing, Functional testing, Web based testing. Worked for Dynasty through Crossover for 2 years as QA manual Tester((July 2018 to March 2020) Participated in all phases of Software Development Life Cycle (SDLC) – Envisioning through Deployment with major exposure on large programs in Functional, Integration, End to End Testing, regression Testing and User Acceptance testing phases CORE COMPETENCIES Hands on Experience in DATAWAREHOUSE /ETL Testing using Informatica, Database Testing using SQL, GUI Testing and Web based testing. Hands on Experience in using Test management tools like Microsoft Test Manager, HP Quality Center etc. Hands on Experience in Test Case execution, Test data preparation, Test result analysis and Defect Tracking. Provided Knowledge Sharing sessions for our team that covered critical Functionalities of the application. Experience as a Software Tester on Waterfall Model Software development process Types of Testing performed: Smoke Testing, Functional testing, regression testing, retesting, Adhoc testing and E2E testing. Supported UAT. Worked on Supply Chain Domain, Health Care, Retail and Pharmacy Domain. Involved in preparing Data Metrics, Effort Estimation, Test Specifications, Knowledge based documents, Test cases, Test Input data and testing by using manual test procedures Efficient in handling Change requests after determining the impact and pushing it through the integrated process Have worked extensively with Business/App Dev Partners across 3 major regions (Americas, APJ and EMEA) on major Global Programs involving more than 10-15 Applications. Participated in SIT Entry/SIT exit, UAT entry/UAT exit meeting along with daily defect review call with all stakeholder, ensuring all technology interface like web services, Informatica [ETL Tool], MQ connectivity, Control-M jobs etc is been done and smoke tested before SIT/UAT Entry EMPLOYMENT HISTORY Worked for Dynasty Through Crossover for 2 years as QA manual Tester (July 2018 to March 2020) Worked in Dell International Services Bangalore as Senior Test Analyst for 5 years (June 07,2010-January15,2015) Worked in UST Global as Software Engineer before joining DELL (September03,2007 – June04,2010) TECHNICAL SKILLS Operating Systems : Windows 9x, 2000/XP and UNIX (Putty) Tools : Nexus, Toad, Informatica 9, Abinitio, SQL Assistant, QC, MTM, Control-m Testing : Database testing, UI Testing, Web Services testing, Black box, Sanity/Smoke Testing, Supported User Acceptance Testing (UAT), Functional and Regression testing. Database : ORACLE 10g, SQL SERVER, TERADATA Domain knowledge : Supply Chain, Retail, Pharmacy, Health Care ACCOLADES ISTQB (International Software Testing Qualifications Board) Foundation level certified professional SPOT award winner for the outstanding performance and contributions to SDM 3.0 Testing at DELL INTERNATIONAL SERVICES. Professional Experience: CROSSOVER: (July 2018 to March 2020) as QA manual Tester CLIENT: AUTOPROCESSOR AND DYNASTY Worked for Dynasty and Autoprocessor through Crossover for 2 years as QA manual Tester Used Inkscape (vector graphics software) for vector mapping of Dynasty Sports stadiums Worked with Autoprocessor-world’s most comprehensive, flexible, and intuitive inventory distribution software solution Did Venue Mapping and Production Mapping in Autoprocessor from different sources (STUBHUB, EI Box office) to destination (Autoprocessor) DELL INTERNATIONAL SERVICES: June 2010 to Jan 2015 as Senior Test Analyst Project3: ISP 4.0 (Data warehouse/ETL Testing) Type of Testing: Data warehouse Testing Database: Oracle 10g, Teradata Tools: Informatica, Quality Center Role: Test Lead Description: ISP- Integrated Service Platform is a front end Siebel CRM application where all call details is entered and gets stored in Oracle database. It is used by dell customer service representatives. ISP is a comparative new application. Still many legacy applications are there which are presently used by customer service representatives. Data related to the call details is getting covered one by one in the subsequent releases. ISP 4.0 was the one of the many releases for ISP where we had to validate transition of data from Source to Audit to Base. Responsibilities: Creating Test Plan, Test Strategy and Test Estimation Documents. Attending the Walkthroughs by way of Tele-conference from Business Analyst Review and approve Software Requirements Specification (SRS) and Technical Specifications Documents. Interfaces with Development Lead as the single point of contact Execute test scripts according to the test schedule Document test results, issues, and defects in Quality Centre. Perform responsibilities listed in the Defect Tracking Procedure Document Maintain Testing Documentation. Project1: SDM 3.0 (DATAWAREHOUSE/ETL Testing) Type of Testing: Functional/Regression Tools: Informatica, MTM, TOAD, TFS, CONTROL-M, PUTTY Description: The Segmentation Data Mart (SDM) is a system that supports the marketing campaigns of Dell. Segmentation Data Mart facilitate segmentation, list selection, incorporate suppressions contacts and accounts for marketing activities. Core capabilities include filtering out competitors, Account association, Job title categorization, Suppressions and integration to Eloqua (marketing automation tool). Project2: LA Expansion Phase 1 Application: SCDH (Supply Chain Data Hub) Type of Testing: Functional/Regression Database: Teradata Tools: Informatica, Microsoft Test Manager, TOAD, TFS, CONTROL-M, PUTTY Description: The high-level program purpose is to transition the fulfillment of the supply chain from the existing CEVA 3LA facility to a new expanded facility in the Southern California area. The new location 3PL provider will be Syncreon. They will be required to support all current capabilities existing at CEVA 3LA plus any additional requirements and capabilities expanded to the new building. They are required to be on-boarded and develop capabilities to support B2B messaging with Dell logistics and fulfillment applications. They are required also to support and adhere to Dell inbound and outbound messaging specification and requirements. Responsibilities: Coordinating with cross interface teams related to upstream & downstream data, performance, business operations for Trouble tickets handling. Risk Identification & Management. Understanding stakeholder requirements and their management. Manage customer feedback and escalations Efficient in handling Change requests after determining the impact and pushing it through the integrated process Review, approve and sign-off project deliverables both from business and internal Interface users Closely working with Program Manager and Business partner in preparing test scenarios and Ensuring projects are delivered as per customer requirements and expectations. Preparing and presenting the lessons learned after each deployment. Post deployment - Supporting internal business users by resolving the trouble tickets during normal operations of the factories. Participate in SIT Entry/SIT exit, UAT entry/UAT exit meeting along with daily defect review call with all stakeholder, ensuring all technology interface like, web services, Informatica [ETL Tool], MQ connectivity, Control-M jobs etc is been done and smoke tested before SIT/UAT Entry Ensure traceability matrix prepared and end to end scenarios reviewed with business as well as interface team. Providing training to UAT users and Provided Knowledge sessions to the team. Managed regression test suite set-up for regression testing for End to End Scenarios. Review all project artifacts like SRS, TDS, Test Spec and test cases. Set-up TFS including linkage between requirements, test cases, execution results and defects to establish traceability and tracking Involved in preparing Test Strategy/Approach Testing effort estimation for FRs/CRs Test Planning & Management (Analysing BRs/FRs, Test Scenarios, Test Conditions, Progression & Regression Test Scripts) Test Execution, Test Status, Analysis and Reporting Test Data Management, Test Metrics, Test Artifacts. Project 4: EBI portal Type of Testing: Functional/Regression (Manual) Environment & Tools: Dot Net, Windows 2000, HP Quality Centre Role: Test Lead Description: EBI Portal is a “Reporting Inventory” and a place for all users to access the various BI tools that are owned by EBI (DDW). It is meant for Dell Business to have one central portal to reach in order to access the integrated Business Intelligence Reporting Tools like Business Objects, SSRS or Micro Strategy. It comprises of several modules like Team Creation, using different Tools and Managing Access requests for both static as well as dynamic reports. Responsibilities: Creating Test Plan, Test Strategy and Test Estimation Documents. Attending the Walkthroughs by way of Tele-conference from Business Analyst Review and approve Software Requirements Specification (SRS) and Technical Specifications Documents. Interfaces with Development Lead as the single point of contact Execute test scripts according to the test schedule Document test results, issues, and defects in Quality Centre. Perform responsibilities listed in the Defect Tracking Procedure Document UST GLOBAL: September 2007 to June 2010 Project5: SDS MITIGATION (DATAWAREHOUSE/ETL testing) Type of Testing: Functional/Regression Database: Oracle 10g, Teradata Tools: HP Quality Centre, Informatica Role: Software Tester Client: DELL Description: SDS Mitigation is a project for validating AP Asset and Entitlement data and related functionalities from Teradata database into SDS system Responsibilities: Involved in Identifying the Test Scenarios Wrote descriptive and precise test cases Wrote SQL queries to be used for data validation Executed test cases and prepared test reports Documented and managed owned defects Verified defect resolutions for owned defects Reported test execution status Project6: WELLPOINT - Pharmacy e-Business Type of Testing: Functional/Regression (Automation) Tools: Rational Robot, HP Quality Centre Role: Software Tester Client: WELLPOINT Description: The e-Business project involves catering to enhance requirements of web applications under the health care domain. The project involves enhancement of websites for health and lifestyle management application that provides information and tools to help manage specific conditions, disease and illnesses. Responsibilities: Involved in Identifying the Test Scenarios. Involved in preparing the Test cases, Test reports. Involved in Regression Testing. Used Rational Robot for Regression Test Script Automation. Involved in the Test Execution ACADEMIA 2006 Bachelor of Technology(B-Tech) in Information Technology from Ilahia College of Engineering Cochin; one of the most reputed University of south India with 71% aggregate PERSONAL DOSSIER Date of Birth: 16th May 1984 Father’s Name : Gracious.P. Kunnath Sex: Female Marital Status: Married Nationality: Indian Languages: English, Hindi, Malayalam. Address : C-803, SMONDO-3, NEOTOWN, ELECTRONIC CITY, BANGALORE