Sr Qa Analyst Resume
Arlington, VA
8+ years of experience as a Lead / Senior Quality Assurance Consultant, Quality Assurance Engineer, Test Analyst, Test Engineer in testing software applications developed on various technologies. Rich experience in different domains such as banking and logistics and having good knowledge in various software testing tools makes it easy to work in different test environments. I am interested to work in both manual and automated testing of software applications. I am looking forward for a bright career in Software testing.
Education Summary: M.C.A (Master in Computer Applications)
B.sc
Technical Summary
Software’s Tested on technologies
- HTML, VBScript, JSP,C,C++, Java,J2EE XML, Web services, SOAP and VB ,Web test, , COBOL,JCL
- Servers – IBM Web sphere,
- SAP R/3 Modules , Oracle Applications
- ETL Informatica 8.1.1
- BOXIR2 Reports
Expertise on Testing Software’s
- Mercury – Quick Test Professional 8.0, 8.2,9.0,9.2,9.5(QTP), Win Runner8.0, Load runner 9.0, Test Director 7.5, Quality Center 9.0,SIR Tracker,JIRA,Star Team ,VSS and CaliberRM, Rational Robot ,Clear case, Clear Quest, Requisit pro.
Area Of Specialization
- Experience in testing (Manual / Automation) of Software applications in Client Server and Web Environment. Strong in Analyzing Business / Technical specifications scenarios
- Excellent in preparing Test Strategies, Test Plans, Test Scripts, Test Reports and test documentation and can comply with your established processes, can maintain strict adherence to your guidelines, policies and procedures.
- Rich in Web GUI eCommerce testing experience.
- Solid understanding and Experience of GUI design
- Expertise in QA Methodologies, like Agile, RUP, SCRUM, Waterfall. Quality Assurance Life Cycle, Test Strategy, Test metrics. Worked on full Software Development Life Cycle(SDLC).
- Perform quality assurance analysis and testing on an Enterprise-level web application and Client server applications
- Experience in White Box Testing, Black Box Testing, Positive, Negative, Data Driven, Functional, UI, Backend, System, and Integration Testing. Worked on Performance Testing, Load Testing, Stress Testing and Regression Testing.
- Experience in write effective SQL queries, review and translate the meaning of the results.
- Domain knowledge of Logistics, Web based applications, Banking and Finance (Investment, Mortgages, and Core) and Health care and Insurance.
- Knowledge and Experience in creating data health care claims
- Excellent working knowledge of UNIX,
- Skills in back-end testing using SQL queries on database tables
- Extensively used Test Director/QC, Rational Clear Quest, Team Track to report bugs
- Done Certification Finance Foundation from CITI GROUP
- Done NSE (NATIONAL STOCK EXCHANGES) Certification.
- Working experience with FACETS 4.5 and 4.6, CLAIMS Customer Services, EDI transactions 270/271,276/277,278,837/835 ANSI X12, QNXT, ITS CAE (Care advance) , Medicare .
- Defect Tracking and Reporting
- Knowledge and Experience in design and implementing automation framework using functional testing tools like Quick Test Professional (Mercury Interactive) like Data Driven and keyword driven
- Rich Experience in handling Functional Libraries ,Object repositories and Descriptive programming
- Experience in Using and maintain of Actions and Reusable actions
- Experience and handling in Check points depends on requirement.
- Expertise in QTP scripting and BPT Components.
- Knowledge and Experience in Ab initio
- API Testing for batches
- Knowledge and Experience in Autosys for scheduling jobs on batch mode
- Rich experience in Web application testing
- Rich experience in Mainframe Testing manual and Automation on mainframe process
- Experience in Project Management Activities like estimations, creation of project plan, planning and control, executing time bound projects, task recognition, setting deadlines and milestones, task assignment, task execution, resource management.
- Well versed in configuration Management Tools like VSS and Star team.
Databases
SQL Server 2000/2005, MySQL, Oracle9x/10g, SQL Navigator, TOAD and Rapid SQL, Sybase, Interactive querying Tool, Adept SQL Diff Tool, ETL Informatica, DB2
Professional Experience:
Confidential
Date From / To
Position
Project Location
Client
Sr.QA
Arlington, VA
NRECA
Hardware/OS
Windows
Environment
ETL Informatica, SSIS, Bug Tracker, SQL Server 2005/2008,Oracle 10g, Adept SQL Diff Tool, QTP9.2 ,Quality Centre , XML, Winscp, SharePoint, Agile, SSRS (reports)
Project Details
The Confidential Migration project, that aims to replace informatica to SSIS , integrate and de-duplicate Insurance plans and data at an enterprise level, and to create and maintain a SSIS packages and replacing Informatica mappings of the most accurate, current, and consistent information about a insurance Plans,
Roles / Responsibilities
- Interacted with the Business Clients, Product Owners, Developers & QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios
- Participated in Requirements, Design, and Release Readiness review sessions.
- Responsible for preparing of Traceability matrix
- Participated in the QA Meetings, Bug Review Meetings, Go/No-Go Meetings & responsible for updating & verification of the Project Checklist during the Deployments/Releases
- Own the creation and ongoing maintenance of test documentation and test plans.
- Responsible for preparing Test Strategy Plan
- Responsible for the ETL (Informatica) build validation process on an ongoing basis
- Worked with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL(Informatica) functionality (properly processing good data, i.e., transformations, calculations, and derivations)
- Developed and reviewed test cases source to target mappings
- Responsible for the running and validation of jobs in SQL Agent for ETL process of any additions/modifications to before release to production.
- Prepared test data for ETL(Informatica) inputting flat files
- Experienced with Winscp for FTPing Files for ETL(Informatica) process
- Executed batches jobs for Informatica and validated the result files
- Experienced with SharePoint navigations for logging defects in Bug Tracker tool.
- Write and execute SQL queries to validate actual test results match expected results.
- Experience in extensive database testing and Back End Testing using SQL queries with SQL database Performed Manual Testing of the Application to determine ease of usability
- Experience in write effective SQL queries, review and translate the meaning of the results
- Developed SQL test scripts for Functional and Regression Testing
- Developed Test case for SharePoint for document uploads and content verification.
- Developed SQL scripts for Comparing data in different databases on separate servers
- Automated SQL scripts for taking row counts on daily basis for daily, weekly and Monthly tables
- Tested databases DWP_Staging and DWP_Target for informatica and SSIS packages
- Extensively used Adept SQL diff tool for comparing data for DWP_Target database
- Experience in HIPAA certification of reports for MEDICAL,VISON and DENTAL
- Developed flows for Daily ,Weekly and Monthly for Informatica mappings to create same order of SSIS Packages
- Designed and developed QTP frame work(data driven)
- Developed test scripts using QTP (Vbscript) for existing test case and Unit tested.
- Developed and maintained Functional Libraries,Object repositories and Descriptive programs
- Developed automated test scripts using QTP for functional and regression testing for NRECA Applications
- Created reusable actions using QTP for existing test case and Unit tested
- Experienced with informatica mappings and check the source and target table mappings
- Responsible for testing all FACT and LKUP tables at target level after SSIS packages deployed
- Responsible for testing and have to certify for good to go for Daily, weekly and Monthly tables to replace informatica to SSIS packages
- Tested more than 80 SSRS reports and validated the report data using SQL queries
- Tested and navigated Reports using navigation links testing for different levels of reports
- Tested all SSRS reports using drill down and drill up links and logged the defects in Clear quest
- Identify and log defects if/when a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
- Responsible for Execution and validation of UNIX scripts and modified the scripts as per analysis.
- Executed and scheduled batch jobs using SQL Agent
- Responsible sending Status reports on weekly basis
Date From / To
Position
Project Location
Client
Mar 2009 / Jun 2009
Sr.QA
Lincolnshire, IL
Confidential
Hardware/OS
Windows ,UNIX
Environment
ETL Informatica 8.1.1, Autosys Job Scheduler, Web services, MQ series, Batch and Real time process, Clear quest, SIR Tracker, Oracle 10g, TOAD, Quality Center , IBM Lotus Notes, XML, Winscp, SharePoint, BOXI Reports (Crystal reports)
Project Details
The Customer Data Integration (CDI) project, that aims to consolidate, integrate and de-duplicate Walgreens customer data at an enterprise level, and to create and maintain a central repository of the most accurate, current, and consistent information about a customer, CDI Phase 2 will build upon the foundation created in Phase 1 by implementing integration components through Web Services, adding additional source data into the Customer Hub.
Roles / Responsibilities
- Interacted with the Business Clients, Product Owners, Developers & QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios
- Coordinating and handling teams in an offshore - onsite model, leading and managing team sizes of 4
- Participated in Requirements, Design, and Release Readiness review sessions.
- Participated in the QA Meetings, Bug Review Meetings, Go/No-Go Meetings & responsible for updating & verification of the Project Checklist during the Deployments/Releases
- Own the creation and ongoing maintenance of test documentation and test plans.
- Responsible for the ETL (Informatica) build validation process on an ongoing basis
- Worked with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL(Informatica) functionality (properly processing good data, i.e., transformations, calculations, and derivations)
- Developed and reviewed test cases for 3rd party sources for AARP and Prison data files
- Responsible for the running and validation of datastage jobs for ETL process of any additions/modifications to before release to production.
- Responsible for HIPPA Guidelines testing
- Prepared test data for ETL(Informatica) inputting flat (AARP and Prison) files
- Experienced with Winscp for FTPing Files for ETL(Informatica) process
- Executed batches jobs for Informatica and validated the result files
- Experienced with SharePoint navigations for logging defects in SIR Tracker tool.
- Write and execute SQL queries to validate actual test results match expected results.
- Experience in extensive database testing and Back End Testing using SQL queries with SQL database Performed Manual Testing of the Application to determine ease of usability
- Experience in write effective SQL queries, review and translate the meaning of the results
- Developed SQL test scripts for Functional and Regression Testing
- Responsible for Functional testing for web services Using SOAP UI
- Developed and Executed tests for Web service for Get, Search and Publish
- Tested more than 80 BOXI (Business Objects) reports and validated the report data using SQL queries
- Tested and navigated Reports using navigation links testing for different levels of reports
- Tested all BOXI reports using drill down and drill up links and logged the defects in Clear quest
- Identify and log defects if/when a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
- Responsible for Execution and validation of UNIX scripts and modified the scripts as per analysis.
- Executed and scheduled batch jobs using Autosys
Date From / To
Position
Project Location
Client
May 2008 / Mar 2009
Sr. QA/ Lead
Union, NJ
Confidential
Hardware/OS
Windows Xp, Windows NT , VMWare,UNIX
Environment
Java,J2EE,QTP 9.2 and 9.5,Vbscript, Quality Center9.0,Rational Robot, MUMPS, ORACLE, SYBASE, Microsoft, SQLServer 2000/2005XML,HTML,MS-Excel, TSO, WYL,TE,Web services (BEA Web Logic 8.1), IIS, Web Applications, TIBCO, Apache, PL/SQL,DB2, Agile Methodology, COBOL, JCL
Project Details
The Facets is core product for Trizetto.it provides complete health care package it serves the payer market, comprised of national and regional health insurance plans as well as benefits administrators.TriZetto\'s Facets Workflow takes claims administration and customer service to higher levels of productivity and cost-effectiveness. This Java-based software application automatically prioritizes and routes claims and customer service work items, based on rules that reflect organization’s business, staffing and training needs. Through integration with Facets, the Workflow application enables seamless, real-time delivery of claims and customer service items, eliminating bottlenecks, automating work and reducing costs while improving speed and accuracy
Roles / Responsibilities
- Interacted with the Business Clients, Product Owners, Developers & QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios
- Involved in Walkthroughs, Defect Report meetings & Audits during various phases of SDLC
- Participated in the QA Meetings, Bug Review Meetings, Go/No-Go Meetings & responsible for updating & verification of the Project Checklist during the Deployments/Releases
- Performed Release Validation Testing on the core functionalities to ensure that the products delivered to Production meet the specified Business Requirements for the launch of the application
- Exhaustively retested Health Claims with Production Issues & succeeded in achieving customer satisfaction
- Maintain the test environments (data loads, database backups, restarting the servers, requesting deployments, troubleshooting issues).
- Experienced in Installation and Up gradations and configure with Mercury Suite
- Experienced for Upgrading patches and running Old scripts on new version tools and vice versa
- Well versed in Install and up gradation of Add-ins in QTP
- Designed and developed QTP frame work(data driven)
- Developed test scripts using QTP (Vbscript) for existing test case and Unit tested.
- Developed and maintained Functional Libraries,Object repositories and Descriptive programs
- Created reusable actions using QTP for existing test case and Unit tested
- Developed manual and automated test cases for Medical (Professional), Hospital (Institutional) and Dental Claims and execute validating them using user requirements and design documents.
- Exhaustively involved in Claims processing as and when required.
- Prepared test data as per design of test cases for Portal application testing.
- Participated more in to batch process modules, UI screens, and Reports.
- Prepared test data and generated web services scripts using SOAP transactions executed them using SOAP UI tool.
- Using SOAP UI tested Functional testing for web services.
- Participated in SOA testing and UAT testing with end customers.
- Created and Executed SQL test scripts for Functional and Regression Testing using Rapid SQL
- Created data files for EDI 835,837,270 and 271 transactions
- Uploading EDI files for Batch processing
- Responsible for Batch execution and validation of Batches.
- Executed MQ series transaction for 270/271 and 276/277.
- Analyzed the results for MQ series transaction of 270/271 and 276/277
- Responsible for Installation and running batches on App Servers , DB Servers and Web services
Library
Responsible for HIPPA GATE way validation of Oracle, Sybase and Microsoft.
Testing HIPPA rules on web based application
- Validating values of EDI Filed codes
- Used TIBCO for Integration testing between Facets and QNXT
- Developed ITS manual test cases for facets and QNXT3.4 for claims processing
- Created and Executed Manual Test cases for QNXT 4.6 and Updated results in QC .
- Expert in Installation of facets Application server, facets Interactive and Web services Library
- Developed BPT components and execution of BPT test components.
- Participated in the technical review of test automation project deliverables
- Created Functional Libraries, Object repositories for Facets 4.5 to Facets 4.6
- Developed QTP scripts using Vbscript and executed through QTP and updated results in QC
- Communicated with support, business and development teams to resolve issues during test execution
- Responsible Service pack testing for facets 4.31, 4.41 and 4.51 on ORACLE,SYBASE and MICROSOFT databases
- Responsible Conversion Testing facets 4.3 to 4.5 and 4.4 to 4.5 on ORACLE,SYBASE and MICROSOFT databases.
- Responsible for Build validation for weekly on Build release for facets 4.5 and gateway validation.
- Responsible for conducting weekly status meetings with Client
- Responsible for Automation of all applications Using QTP 9.2
- Responsible for execution of rational regression scripts on each Service pack release and updated results in QC
- Entered and managed defects in Mercury Quality Center
- Responsible for Mainframe Testing and Automation of Mainframe process using QTP TE Add-ins
- Co-ordinating offshore team and need to provide required information and in track of daily status
- As Sr. QA need to interact with all 5 client teams on daily basis.
- Coordinating and handling teams in an offshore - onsite model, leading and managing team sizes of around 15
Jeppesen
Date From / To
Position
Project Location
Client
Feb 2008 / May 2008
Sr.QA
New York, NY
Confidential
Hardware/OS
Windows 2000
Environment
.Net, QTP 9.0,Rational Clear Quest, Request Pro, Load runner 9.0,JIRA, Unix, BEA Web Logic 8.1, Web application, SQL Server 2005, XML, Citrix, MS-Excel, MS-Project, Agile Methodology, Oracle Applications.
Project Details
The Crew Management System (CMS) is an application used by Airlines British Airways, US Airways,Miami, Mexicana, Comair, UPS, Boston Maine & ASTAR for crew scheduling. It is one of the several applications within the Maestro Suite of products from SBS-Jeppesen. Crew Management System interfaces with other applications both within the suite as well as externally. The regulatory, company and contractual rules that an airline must follow constitute a fundamental part of the daily operation, and often the interpretation of the legal definition varies from airline to airline. It is one of the Critical modules within the Maestro Suite of products from Jeppesen.
Roles / Responsibilities
- Responsible for developing system test plans and test scripts based on the user requirements and Use cases
- Prepared test data as per design of test cases for Portal testing
- Preparing and participating in Client weekly status report calls
- Tasks Scheduling and monitoring as per the project plan.
- Conducting final reviews for test artifacts before delivering to the client
- Mentoring Testing Team in Writing Test cases and in Test execution phase
- Providing testing estimates to management team
- Performed Frontend and Backend testing techniques
- Experience in extensive database testing and Back End Testing using SQL queries with MySQL database Performed Manual Testing of the Application to determine ease of usability.
- Designed and developed QTP frame work(Data driven)
- Developed test scripts using QTP (Vb script) for existing test case
- Created Reusable actions and used them when where required
- Developed Functional Libraries and Maintained Object repositories
- Created QTP scripts for web based and database testing.
- Participated in UAT testing with end clients for Portal testing
- Responsible for validation of UNIX scripts and modified the scripts as per analysis.
- Tested and executed test cases on different browsers for compatibility of web application on IE 6 and 7, Firefox, Netscape navigator, Opera.
- Used Selenium for browser regression testing.
- Used Selenium regression test/cross browsers testing on all platforms.
- Participated in walkthrough with client and the development team, attended Defect reporting meetings periodically
- Coordinating and handling teams in an offshore - onsite model, leading and managing team sizes of around 6
- Participated in Manual and automated Load test for Every Release through Citrix.
- Preparing the automation scripts for regression scenarios.
- Involved in Salesforce Application testing for tracking sales groups to manage customer relationships.
- Tested Built own Financial and Human resource application in salseforce IDE.
- Analyzed Graphs and created data for Load runner for performance test scenarios
- Worked in CQ for tracking defects
- Prepared Test summary report after every shakeouts and submit it to the managers
FedEx Freight
Date From / To
Position
Project Location
Client
Jan 2007 / Feb 2008
QA Analyst/Test Lead
Colorado Springs, CO
Confidential
Hardware/OS
Windo2000 ,Unix
Environment
- EETL Informatica GDE 1.13 BOXIR2 (Business Objects), Oracle9i, Autosys Job Sscheduler,Quality Center9.0, Toad8.6
Project Details
The Operations Performance Metrics project is tasked with combining East (ARFW, now FXFE) and West (VIKN, now FXFW) Operating Company operation measurements in one centralized reporting application, including goals and metrics related to shipment volume, revenue, and pickup and delivery costs for the initial Phase 1A. The intent of the project team is to define common operation measurements and report them out to the field via performance dashboards and Scorecards and Operational reports.
The purpose of this project is to develop Common Metric Reporting for FedEx Freight East and FedEx Freight West, which may be viewed at all, levels with a common understanding of the definition of the metric values being reported. Common Metric reporting will present common metrics presentation of FXF Operations from the Opco level through, division, region, service center, OpArea and employee
Roles / Responsibilities
- Responsible for developing system test plans and test scripts based on the user requirements and design documents
- Experience in extensive database testing and Back End Testing using SQL queries with SQL database Performed Manual Testing of the Application to determine ease of usability.
- Prepared test data as per design of test cases and executed and logged the defects
- Coordinating and handling teams in an offshore-onsite model, leading and managing team sizes of around 4
- Communicated with support, business and development teams to resolve issues during test execution
- Worked in Dashboard and Scorecard Calendar, Hover text, Glossary and Refresh time testing
- Involved in Report Navigation Links testing for different Org levels
- Tested more than 300 BOXI (Business Objects) reports and validated the report data using SQL queries
- QA Test Data being verified thru different requirement SQL against each Gauge data in the Dashboard and Graph & Grid data in the Scorecard
- Understand the Active Data Warehouse (ADS) and Operational Data Mart (OPS_MART) data mapping specification for Data Selection, Aggregate Rules, General Source/Target global rules and Mapping in Ab Initio
- Design the Data Leanage Mapping sheet for both target tables and the data sources and also cross verified with Ab Initio
- Metrics aggregation are calculated from ADS tables by summing rows for the Location and Time Period and verified with the OPS_MART tables
- Verified the DATE_DIM table one row for each calendar day and to rollup the correct calendar days in a Week, Month, Quarter and FY.
- Experience in write effective SQL queries, review and translate the meaning of the results.
- Verified there will be rows for all Org Levels (Service Centers, Regions, Divisions, OpCo and FXF) and for all Time Periods (Daily, Weekly, Monthly, Quarterly and Fiscal Year)
- Involved in Data Driven Test, executed SQL queries to extract data from QA database and verified the Target data
- Modified SQL/PL SQL Scripts and tested them.
- Responsible for validation of UNIX scripts and modified the scripts as per analysis.
- Executed and scheduled batch jobs and using Autosys
- Verified Info view Sign-On thru single User Logon model includes LDAP authentication and logon
- Developed SQL test scripts for Functional and Regression Testing in Quality Center
- Validation of Back end data using SQL Join scripts
- Designed Test Cases for report validation in Quality Center
- Participated in UAT testing with end customers
- Worked in Quality Center for planning, running and tracking defects
- Participated in walkthrough with client and the development team, attended Defect reporting meetings periodically
FedEx
Date From / To
Position
Project Location
Client
Nov 2005 / Jan 2007
Functional / Automation Test Lead
Memphis, TN
Confidential
Hardware/OS
Window 2000
Environment
Java, Java script, XML,C,C++ QTP 8.2,9.0, Vbscript, Quality Centre 9.0,Ab initio 2.13,GDE 1.13, Unix, Linux, Sybase, web services,TIBCO, Requisite Pro, BEA Web Logic 8.1, SQL Server 2000/2005, SOAP, API Testing, Tuxedo,Webtest,DB2, TSO/ISPF,JCL, COBOL, Water fall Model, SAP R3
Project Details
FedEx serves its customers with worldwide services, which is regulated through its e- commerce and supply chain solutions. FedEx provides its customers the client software that allows the customer to connect to the FedEx Servers, which in turn enables them to Ship, Rate and Track a package and others services like Address verifications, Service Availability requests and lot many other services which requires rigorous testing.
Roles / Responsibilities
- Involved in the development of system testing strategies, plans, cases and conditions to ensure
Processes and products meet standards.
- Updating the existing test cases as per the change request and tickets issued
- Coordinating and handling teams in an offshore - onsite model, leading and managing team sizes of around 8.
- Communicated with support, business and development teams to resolve issues during test execution
- Preparing the automation scripts for regression scenarios using internally developed tool
- Prepared test data as per design of test cases
- Prepared test data and generated web services scripts using SOAP transactions executed them using XML SPY.
- Experience in Mainframe testing environment using TSO/ISPF for Job submitting, monitoring and sending the status to development.
- Experience in JCL batch processing and report the abend to the developement.
- Tested API s using CTS truough tuxedo interface and SOAP for webservices and XML transactions.
- Tested backend Servers on UNIX environment.
- Responsible for server shakeout under UNIX environment on daily basis.
- Developed test cases for GUI`s as per requirement
- Extensively tested GUI`s as per requirement and logged the defects with proper screen shots.
- Maintain the test environments (database backups, restarting the servers, requesting deployments, troubleshooting issues).
- Responsible for validation of UNIX scripts and modified the scripts as per analysis.
- Executed and scheduled batch jobs and using Autosys.
- Generating test cases/procedures as per requirement
- Deciding the test coverage and update the properties file as per the coverage conditions
- Executed monthly production migration release shakeouts, regressions shakeouts, sanity testing
- Validation of Back end data using SQL Join scripts.
- Performed Frontend and Backend testing techniques
- Updated the existing automation scripts to better functional coverage and scenarios
- Update the Test plans, Test cases, Test scripts and Test procedures required for testing
- Prepared Test summary report after every shakeouts and submit it to the managers
- Send a weekly report to the Test Manager
- Maintained requirements traceability matrix using quality centre
- Entered and managed defects in Mercury Quality Centre.
- Designed and developed QTP frame work.
- Provided design documentation for the test automation projects
- Created action based scripts using QTP (Vbscripting)
- Participate in the technical review of test automation project deliverables
- Developed Ad hoc graphs using Ab initio for testing data
- Used components in Ab intio like input table, out table, input file, output file ,filter by expression, reformat, Join and rollup
- Participated in Mainframe Testing for validating rates in Mainframe system
- Prepared test data and test results (input / output files) for data driven method. Involved in
- Developed SAP GUI and also validated screens
- Involved in Unit tested of SAP-ABAP code.
- Executing the QTP scripts individually and in batches.
- Supported users involved in User acceptance testing.
Green Point Mortgage
Date From / To
Position
Project Location
Client
Jan 2004 / Nov 2005
Functional / Automation Tester
New York, USA
Confidential
Hardware/OS
Windows 2000/XP.
Environment
.Net, Oracle 9i, Win Runner 8.0, Test Director 8.0,Clearcase,Unix,Star team and CaliberRM, Calypso
Project Details
Green Point has been using Gallagher Millennium, a mortgage lending software developed by Gallagher Financial Services as their Loan Origination System. Due to inadequate support and performance issues, GPM has decided to move to a new system called Empower. Empower system is comprised of 2 major subsystems. They are called Pre-Funding and Post-Funding. Pre-Funding system is used for loan origination while Post-Funding is used for tracking the loan after it is funded for its legal compliance, sending it to the investor and finally reaching the warehouse department. Pre-Funding application is a client server application accessed via the Citrix thin client while post-funding is an n-tier application developed using .NET solutions and accessed via Internet Explorer.
Roles / Responsibilities
- Carrying out testing for various loan activities like New loan, Underwriting, Processing and Closing of loans of various channels like Retail, Wholesale, Commercial, Government and Correspondent.
- Developed the System Test Plans, Test Scripts and Test Cases using Software specifications document.
- In the Process of Developing System Test Plans analyzed the product requirement documents and detailed design, functional documents
- Responsible for Functional and Regression testing in various environments.
- Responsible for the System, Integration Testing of the Application and Validation, Usability Testing of the Application.
- Performed Database Validation Testing and manipulations using SQL
- Experience in the execution of procedures and test cases based on measurable business requirements
- Used Test Director 8.0 to prepare Test cases, procedures and Requirements Traceability Matrix.
- Developed test cases and approach for data validation and database components for the developed system
- Generated Test Analysis Reports using Test Director 8.0.
- Used Test Director as the tool for Defect Tracking and Reporting.
- Responsible for analyzing the documents and executing test scripts.
- Delivered bug reports and managed problems using Problem Tracking System (PTS)
- Co-coordinated with product management and development teams to resolve problems.
- Co-coordinated with Project Managers, Business Analysts and System Analysts to set up the pre-validation and validation environment to execute the scripts.
- Verified that all modules were tested properly based on requirements.
- Executed the tests to verify the web GUI using Win Runner.
- Created Data Driven test phases by creating different data tables
Citigroup
Date From / To
Position
Project Location
Client
Nov 2003 / Jan 2004
Software Test Engineer
Mumbai
Confidential
Hardware/OS
Unix
Environment
Java, JSP, Servlets, Tomcat 4.0, MVC architecture, Oracle 8.0, Test Director 7.2 and Star Team, MS Visio, MS-project.
Project Details
Citigroup is an organization, running financial operations all around the globe. The CSI maintain information of all the software applications owned by Citigroup. Besides, it defines and manages a workflow process to facilitate the request and approval (by heads of different groups) of processes like Planning, Development and Enhancement of software applications.
Roles / Responsibilities
- Developed test plans, test procedures and test cases according to business specification given and tested GUI functionalities according to guidelines of the test plans
- Performing extensive manual testing of each module.
- DesignedFlow Charts using MS Visio from the Use Cases stored in Caliber.
- Involved in SQL database backend testing
- Logging and tracking defects into Test Director 7.2 and producing defects reports.
- Interacting with developers on various issues relating to software defects, builds.
- Suggested Enhancements to the application.
- Prepared Tractability Matrix document to map the test cases to the requirements
Merrill Lynch
Date From / To
Position
Project Location
Client
June 2001 / Oct 2003
Test Analyst
Mumbai, India
Confidential
Hardware/OS
Windows 2000
Software
Java, Sybase ,Unix, Test Director 7.5,Calypso (Securities Tool)
Project Details
This project is an online brokerage and banking application. System consists of various modules like Loan Submission, Banking, Loan Locking, Pricing, Re-Lock, Withdraw, Extend Loan Expiry, Ready to Fund, Funding, Closing, Interest calculations, Buy backs, Mortgages Re-finance and Payments, Investing, Lending and Planning etc. It also generates reports based on clients’ loan status like loans missing collateral documents, loans purchased, loans pending conditions, loans pending settlement review, loans not cleared for settlement. Various components in the system running fortnightly on different servers to send notifications like loans expiry, locking, funding, fee payments etc. The Accounts mainly consists of Individual, Banking retirement and loans. The investing consists of Markets of Markets, Trade, Portfolio management, and research. Each of them has different functionality like Balances, Performance report, Portfolio watch list etc. The Banking consists of Account detail, Transfer funds and Credit card processing Reports etc.
Roles / Responsibilities
- Planned, designed, implemented and executed test strategies, test procedures, test plans, and test cases according to specification given
- Written cases at unit or component level for each batch jobs or/and process
- Analyzed the data required for testing from 5 different databases
- Involved in preparation of test data when production data was not available. Involved in complete system and end to end testing
- Organized test procedures and executed tests in software and database environment
- Participated in Functionality and Regression Testing
- Defect Tracking and management through Test Director 8.0