Test Cases Quality Assurance
Resume:
Chandrika Thaggahalli
acx4ud@r.postjobfree.com
Experience Summary
IT professional with a Senior Quality Assurance Team Lead / Analyst record for developing and leading successful QA project and solution in both Waterfall and Agile environment.
Diversified experience in web application, client-server, network, multimedia, and database projects in UNIX and Windows environment.
Expertise in all phases of the software life cycle risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
Hands on experience with functionality testing, UAT, GUI testing, regression testing, web testing, backend testing, system testing, system integration testing and data driven testing using Mercury and Rational tools.
Involved in Customization, Domain creation, project creation, User role management, Creating test cases and defect creation and management using HP ALM/QC tools.
Education and Certifications
•Bachelor Of Science in Computer Science: RVCE college, Bangalore, India
Quick Test Professional 10.0, ALPi International, 2010
ISTQB (International Software Testing Qualification Board ) Certified, June 2012
ITIL ( Information Technology Infrastructure Library) certified
Relevant Technical Skills
Operating Systems: Linux, UNIX, IBM ES9000, IBM-370, Windows
Languages: C, C++, Pro*C, COBOL, JCL, CICS, VSAM, HTML, SQL
Databases: Oracle (11g), Information Management System Database (IMS DB), DB2/SQL, Virtual Storage Access Method (VSAM), Time Sharing Option/Interactive System Productivity Facility (TSO/ISPF), Customer Information Control System (CICS), Easytrieve, Query Management Facility (QMF)
Tools: Test Director, CA_RELIA Workbench, IBM Rational ClearCase, IBM Rational Clear Quest, MICROFOCUS WORKBENCH, IBM WORKBENCH, DBArtisan, TOAD (9.5), CA Harvest Change Manager, Unicenter Service Desk,Putty, Autosys 11.3.5,Informatica 9.5.1, QTP 11, Doors 9.3, Altova XML spy 2013, Quality Center (10.01),
HP ALM (11),MS Visio
Professional Experience
Fannie Mae: Senior QA Analyst April 2013 to Present
Description:
- The Making Home Affordable Program (MHA) is a critical part of the Obama Administration’s broad strategy to help homeowners avoid foreclosure, stabilize the country's housing market, and improve the nation's economy. Home affordable Modification Program (HAMP) lowers the monthly mortgage payment in order to make them more affordable and sustainable for a long-term. HAMP program houses a number of programs under it like Second Lien Modification Program, Home affordable Foreclosure Alternative (HAFA) program, Home affordable Unemployment program.
- Fannie Mae is the largest player in secondary mortgage industry in USA. For securities accounting, FUSE program was initiated to reduce the number of processes and manual interventions in the legacy accounting system. While Sim Corp Dimension application does the accounting, position establishment for Stand Alone Asset lots for GAAP and Tax accounting is done in the interface area and fed into SCD. Data from Capital Markets and EDI shall be received on a daily basis for all securities that are bought into Fannie Mae Stand Alone Asset Portfolio and events like liquidation, pay downs,redemptions, amortization, impairments, consolidation, etc are applied on them. Restructuring of the existing structured or the unstructured products would be accounted for. Depending on the product and corporate actions, either settlement date accounting or trade date accounting would be determined. Booking rules are applied and posted into GL.
Responsibilities:
Developing and Modified Test cases from Business Requirements in ALM/HP Quality Center
Performed Black Box Testing, White Box Testing, Functionality Testing, Unit Testing, Integration Testing, System Testing, Modular Testing, Backend Testing, Regression Testing and User Acceptance testing.
Created Test Plan, Test summary document and gathered artifacts during the Testing cycle.
Created and manipulated test data using Altova XML spy and TOAD.
Performed root cause analysis of the defect and documented it using Clear Quest during the execution phase.
Provided testing estimate and created Regression suite test cases for the various projects.
Created Requirement Traceability Matrix to map between the requirements and test cases.
Created test data for all ETL mapping rules to test the functionality of the Informatica graphs.
Validating the load process of ETL to make sure the target tables are populated according to the transformation rules and data completeness.
Written Test Cases for ETL to compare Source and Target database systems.
Implemented Agile QA methodologies.
Extensively tested of data accuracy and generation of Reports.
Execution, Monitoring and validation of Batch Job using Autosys and validation the backend tables using SQL.
End to End production testing and validation of Autosys job.
Fannie Mae DTF (Data transformation) tool was used to created automated SQL script.
Platform: Clear Quest, Rational Clear Case, Altova r11.0 XML spy, HP ALM, TOAD, Autosys, Putty, DOORS, Informatica 9.5.1
Department Of Labor (DOL): Team Lead/Senior QA Analyst Jan 2008 to March2013
Description:
–Worked as a QA Team Lead for the OFLC one-Stop Portal application this provides a single entry for the entire FLC application. This acts as a central repository for FLC content which includes form, news and alerts. It is a single search engine in which a public with one unique account can submit and process the application for foreign labor certifications programs like LCA (H1B,H-1B1,E3), the Temporary programs(H-2A,H-2B) or the PERM.
–Worked as Senior Software QA engineer For Prisoner Re-entry Initiative .This program, which involves several Federal agencies, is designed to reduce recidivism by helping inmates find work when they return to their communities, as part of an effort to build a life in the community for everyone. DOL will be awarding grants under this competition to faith-based and community organizations (FBCOs) to be the agencies carrying out this demonstration
–Worked as a QA lead for The Beneficiary-Choice Contracting Initiative seeks to strengthen the education and work status of the ex-prisoners. By providing specific services, such as mentoring, soft-skills and/or GED training and specialized job training.
–Validation Of the National Emergency Grants (NEG) are discretionary grant awards by the Secretary of Labor that temporarily expand the service capability at the state and local area levels by providing funding assistance in response to significant dislocation events
–Worked as a QA Lead for the Youth Build project whose main strategy is to focus on job development, placement, and retention programs for High school dropouts
Responsibilities:
Responsible for managing all the Quality Assurance functions include planning, strategy, testing execution and tools.
Analyzed and reviewed Business requirements, functional specifications and design documents to Develop Test requirements, Test Plans, designated Test cases and Test Scripts
Conducting walk-through of Test Strategy documents.
Worked with the Project Manager and other technical leaders to establish time tables and agree on a Quality Assurance plan
Ensure that QA process is documented, communicated and adequate to ensure agreed quality levels for all the application.
Ensure traceability of test cases to requirements, working with the project Business Analyst to ensure all requirements are tested.
Coordinated performance testing and ensures that performance standards are communicated and documented.
Performed Manual Functionality testing, Integration testing on Client server and Web application
Responsible in influencing the direction of the automation effort, schedule and prioritization.
Oversees determination of need, selection and implementation, and maintenance of QA tools.
Participate in UAT planning and execution activities for business
QA issue prioritization and resolution facilitation.
Manage the planning and execution of product testing efforts including the associated hardware and personnel resources to meet customer committed dates
Analyze requirements during the requirement analysis phase of project.
Involved in performing both Frontend and Backend testing
Written complex SQL queries using multiple joins and sub queries for validating Reports generated either monthly or quarterly.
Facilitates weekly Quality Assurance meetings and maintain agenda.
Platform: Windows, Oracle 10g, CFMX 7
Tools: Toad For oracle 10.6, CA Harvest Change Manager, Unicenter Service Desk, HP Quality Center 11, QTP 10, Internet Explorer, Firefox, Safari, MS Word, Excel, Access
America Online (AOL): Senior QA Analyst May 2004 to Feb 2007
Description:
–Validated Infranet, which is a customer management, and billing system. It manages customer information, rates and bills the customer at the end of the billing cycle. Infranet application was validated every time AOL announced new package, price plan change or when it cancelled some of the existing package.
–Worked as Senior Software QA engineer on DMP (Digital Media platform) project that gives the ability for AOL subscriber and non-AOL member the ability to purchase digital music and games.
–Worked as a QA lead on cycle billing application under AR (Account Receivable) project that consolidates charges (billable and non-billable) to member and produce bills depending on their offer. The application also generates reports and other processing statistics and groups the monthly fees and session charges into line items that display in the member billing statement.
–Worked as a QA lead on Valista Premium Services Platform project that seeks to modularize business processes and back -office system to support AOL premium service. This new service supports both AOL and NON- AOL members. The PSA/Valista platform was developed as a J2EE application supported by BEA WebLogic 8.1 application server and Oracle 9i database.
Responsibilities:
Design, develop, and execute test cases using test plans and functional specifications.
Backend database testing in Oracle environment including validating stored procs, jobs and triggers.
Participate in the design spec reviews to understand design, contribute quality requirements and ensure testability
Installed the code and conducted the Functional, System, Integration, Regression and End to end testing.
Identify test requirements from specifications, map test case requirements and design test coverage plan.
Validated more than 150 reports per project that were developed using Abinitio. These reports were validated for all the country which uses AOL services.
Isolate, replicate, and report defects and verify defect fixes.
Worked with the Call center in AOL for end to end testing for the entire work flow from when the user purchase a product to his final bill and generating the financial reports for AOL
Used Scheduling tools such as Autosys to Schedule and run the jobs
Provided Training and Supporting Documents for projects which were outsourced.
Platform: UNIX, Oracle 10g, PL/SQL, HP-UX 10.x and Sun Solaris 5.6
Tools: Toad For oracle, Test Director, Internet Explorer, MS Word, Excel, Access, Embarcadero DBArtisan 7.3.0 and AOL’s proprietary tools
AT&T: Senior Test Analyst/Developer January 1999 to May 2002
Description:
-Worked as a QA Analyst for CADM application. CADM is a redundant account maintenance database (Oracle 8i) primarily focused on Customer Account Data Management on behalf of AT&T’s “business” customers. It either directly or indirectly supports bundling multiple telecommunication services into a single bill.
-Validate the data conversion /migration project in CADM. Data was migrated from IMS Database to Oracle.
-Worked as a developer for conversion/migration project in CADM application. Data was migrated from IMS Database to Oracle.
Responsibilities:
Served as a Agile QA test analyst ran scrum meeting, which included daily stand up,iteration planning and release planning
Designed, implemented, and maintained TSD (Test Strategy Document) for CADM software.
Validated new tables and query performance against these tables that were created due to the Migration.
Used bug-tracking tool Cleartool to track the issues generated during testing.
Performed Transaction driven test cases from start point to the final bill.
Implemented automated testing methodology.
Validated test cases in both the old and the new DB for checking the data validity
Used Cleartool to track the issue generated during Testing
Developed number of programs using Unix Korne shell, Pro*C and PLSQL for testing the application
Performed Acceptance testing to demonstrate to the client testing experience of the GUI in terms of compliance with the standards functionality
Responsible for creating detail design and specification documents.
Developed and implemented the code and participated in the production install
Developed and executing the unit and integration testing cases before QA hand off.
Demonstrated the installation and execution procedure of code to the assigned QA engineer.
Environment: UNIX, SQL, PL/SQL, C, IBM Clear Quest, Pro C, oracle 8i, SQL*loader, Sun Solaris 5.6
Tech Domain, Inc: Programmer/Analyst Oct 1997 to Jan 1999
Client – Conectiv (Power/Utility Company)
Description:
Worked as a Developer for Connectiv, which is one of the Electricity Company serving New Jersey, Delaware and Virginia.
The project was to implement system solutions to support processes within the Customer Care Group for the management of Retail Access in NJ for Conectiv's Local Distribution Company (LDC). These processes include Customer Contact, Meter Reading, Field Orders, Billing, Adjustments, and Payment/Collection.
Responsibilities:
Involved in writing and presenting the SDD (System Design Document)
Reviewed the business requirements and created specification documents with the changes required in the existing code
Responsible for analyzing and updating the existing COBOL programs to meet business requirements.
Developed and executing the unit and integration testing cases before QA hand off.
Demonstrated installation and execution of code to assigned QA engineer.
Environment: COBOLII, IMS DB, VSAM, TSO/ISPF, CLIST, ISPF, CICS and EASYTRIEVE.
Building Network Automation Pvt. Ltd: Programmer/Analyst: Aug 1996 to Oct 1997
Description:
Financial accounting system that provides facility to register Employees information. Through various stages of their career growth in the organization till severance of employment though retirement, resignation or termination.
Personnel management system keeps track of all employee details and incorporated queries and reports on the information, which helps in the decision making for the management.
Responsibilities:
Involved in writing and presenting the SDD (System Design Document)
Responsible in design, development and implementing the project
Developed and executing the unit and integration testing cases before QA hand off.
Developed and maintained COBOL code for the applications Financial Accounting System and Personnel Management System.
Environment: COBOL, PLI, JCL (JES2/JES3), DB2/SQL, QMF, VSAM, TSO/ISPF and CICS
Motorola: Programmer/Analyst August 1995 to June 1996
Description:
Developed System resources monitoring and Automation for Motorola mailing system
Responsibilities:
Planning the software Project and creating Algorithm
Creating the system design document, Detail design document,coding
Responsible for Code review walkthroughs
Application was developed using C on UNIX system
Environment: C, HP-UNIX 10.x
Contact this candidate