Rekha Sunkam

Rekha Sunkam – Senior Software Tester
Rekha S
Email: rekhasqa5@gmail.com Work Status: US Citizen.

Summary:
Over ten years of professional experience in Information Technology in Analysis, Development, Testing and Implementation. Strong software testing background includes Analyzing System Requirements and Functional designs to identify potential gaps prior to preparing test plan and test execution. Proven track record in coordinating daily workloads, meeting deadlines and working through unexpected situations with strong commitment to quality. Excellent organization and prioritizing abilities resulting in effective time management and successful project Implementations.
• Experienced in testing in Agile, Iterative and Waterfall Environment .Expertise in Software Development Life Cycle (SDLC) processes and methodologies, identifying product quality issues/process flaws, analyzing impacts, devising effective strategies. Domain Knowledge on business applications developed for supporting Finance, Banking, Healthcare, Retail, Insurance and Mortgage Industry.
• Proficient in development of Test Strategy, Test Plans, Test Procedure, Test Cases and Testing Signoff Reports.
• Experienced in leading the Daily Defect meetings, Weekly Status meetings and creating Weekly testing status reports to submit metrics to the project management team and handling multiple projects efficiently.
• Strong Skills in using White Box, Gray and Black Box testing methodologies.
• Experienced in Unit Testing, Integration Testing, System Testing, Performance Testing, Regression Testing, IT and UAT Testing.
• Specialized in testing WINDOWS, UNIX and MAINFRAME environments.
• Proficient in Manual and Automation testing of Client/Server, ERP-SAP, SalesForce.com Cloud, Web and Data warehouse (ETL) applications.
• Ability to manage large projects with complex testing cycles in an effective way by introducing innovative ideas through brain storming with the team. Experienced in managing large, medium and small IT projects and estimation of the test hours per project.
• Experienced in claims processing with EDI transactions (270/271, 276/277, 278, 820, 834, 837 and 835) in HIPPA and HL7 Environment.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.
Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Strong Skills in using Integration, GUI, Functionality, Regression, Performance, Stress and Configuration Testing.
• Knowledge of quality assurance policies relating to compliance with IEC 62304, FDA Title 21 CFR Part 11, ISO 14971, and IEC 60601 for testing involved with Medical devices.
• Experience in documenting and tracking of all software defects using tools like Rational Clear Quest, Quality Center, ALM, Test Link, Microsoft Test Manager, Defect Tracking System (DTS),Rally, Test Director ,JIRA and Version One.
• Experience in testing Database Applications with Data Driven Tests in Oracle, DB2 and SQL Server. Experienced with testing Web Services (WSDL, WADL, and REST-SOAPUI Pro) using SOAP UI 4.0/3.0, Apache Axis Client 2.x, Eclipse 3.4, and IBM RAD 7.0.Rational Integration Tester.
• Experience with industry standard methodologies like RUP (Rational Unified Process) and CMM (Capability Maturity Models).
• Excellent Analytical, Problem solving and Technical skills. Personal skills include Excellent Communication, Documentation, effective time management and the ability to work in a team as well as independently.

Technical Skills

Testing Tools:
Quality Center 11(ALM), Quick Test Professional (QTP), Microsoft Test Manager, Test Director, Quality Center, QC ALM, Selinium IDE, Load Runner, JUnit. Nunit, JIRA, Bugzilla, Rational, ClearQuest.,Rally,(DTS/Defect Tracking System),Version One.

Project Management Tools:
PVCS, Microsoft Visual Source Safe, Quality Center, Rational Clear Quest, Team Foundation Server.

Scripting Languages:
TSL, VBScript, Java Script, Shell Scripting.

Database and Reporting Tools:
SQL*Reports, SQL*Plus, SQL*Loader, TOAD, SQL Navigator.

Technologies / ERP
Image Capture Technology – Ascent Capture, Kofax, SOAP UI,REST, SAP, SalesForce.com. TIBCS,SAS, IBM Appwatch MQ, Progress, Mind reef Soapscope

Programming Languages:
Java,ASP,Visual Basic,C, XML,HTML.

RDBMS/Databases:
Oracle ,SQL Server,DB2,TeraData,BigData,MS-Access

Educational Qualification:

Master’s in Business Administration (Finance and CIS)

Professional Certifications:

Sun Certified Java Developer.
Sun Certified Web Component Developer.
Certified in Oracle SQL.
Certified in DB2 Database.
Professional Experience:
Gettington Brands , Lead QA Analyst Apr 15 – Oct 15
Gettington.com is a fast growing e-Commerce retail brand and offers thousands of brand-name products with the flexibility of shopping now and paying over time.

Responsibilities:
• Lead the testing team for integrating the legacy systems with Oracle RMS software.
• Created test strategies for verifying the daily transactional inbound integrations from BSB legacy systems (PIM / GP) to Oracle systems (RMS/RPAS)
• Involved in developing test strategies for Conversion testing. It includes extraction of data from legacy systems and applying the transformation rules as per data mapping and load to Oracle staging tables.
• Involved in Web Services testing which included testing the data being passed across various queues, investing the broken builds and failed tests, verified the queues and topics on Active MQ Server, checked the JMS messages, verified the XML files and the log files by manually running the Jenkins server.
• Used JIRA software to plan and track stories and testing progress for each Sprint.
• Lead the testing efforts which include end to end testing for Purchase Order module and EDI interactions with external entities.
• Verified all the data mapping and transformation conditions are tested successfully.
• Involved in validation of data transformations from source systems to destination systems using mapping documents.
• Developed and executed UNIX shell scripts and wrote complex SQL queries for validating business rules for ETL project.
• Involved in test case creation for ETL to compare Source and Target database systems and identified the duplicate records in the staging area before data gets processed
• Ensured that the mappings are correct and conducted data validation testing .Involved in validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Performed Verification, Validation, and Transformations on the Input data (Text /Flat files, XML files) before loading into target database.
• Involved in writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data. Validated the Counts and Contents from source file to Staging and then from Staging to DW.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.Involved in extraction of test data from tables and loading of data into SQL tables.
• Created the Traceability Matrix and reviewed it with the Business team and Development team.
• Involved in Defect Management using Bugzilla and coordinated with project team for defects resolution.
• Written extensive SQL Queries to perform Database testing and validated UI.
• Logged the defects, determined repair priorities and tracked the defects until resolution using JIRA.
• Extensively worked for QA planning, coordination and implementation of QA methodologies.
• Involved in automation and maintenance of test framework using Jbehave, Selenium and Java and contributed to QA process improvements.
• Involved in complex test data creation for conversion, integration and regression testing and verified various batch jobs are run correctly before the functional testing.
• Managed the defect tracking, prioritization throughout the testing phase and escalated any risks or issues to the leadership team on a timely basis.
• Involved in daily standup meetings and communicated the test execution, any road blocks, defect count, other testing status and metrics to the project team.
• Coordinated the onshore and offsite testing efforts to ensure project test deliverables are completed on time.
• Assisted the business line testing in UAT/ Stage environment.

US Bank, Senior Software Tester/Lead,MN Nov 10- March 15
As a PFAM test lead , I lead various US Bank Projects – Trust Now Essentials(TNE),BANA,ITC Portal, Nexus/Trust Hub Optimization Release 1 and 2 and WM Brokerage Project and they were successfully implemented without major production issues.
As a PFAM Test Lead my responsibilities included the following:
• Created all the testing artifacts as per the US Bank’s Quality Process Governance and Deliverables Library according to the process area.
• Involved in the preparation of Master Test Plan and Test Strategy document specifying an overview of testing approach, Testing strategy, roles, responsibilities and its scope.
• Efficiently developed and executed SQL scripts to extract data from different tables for Wealth Management ETL Brokerage Project with the help of Use Cases and Business Requirement Document in Agile environment with JIRA.
• Involved in creation of Test cases and Bug Management in Microsoft Visual Studio.
• Ran automated test cases for exploratory testing using Microsoft Test Manager.
• Involved in analysis of data model view, source data and data completeness.
• Created test cases, tracked user stories and defects (defects resolution) in Rally for ITC Portal project to ensure the expected data is loaded or not and data transformation is done as per the specifications .
• Created test cases for data extraction, transformation and loading phase to validate the data is transformed as per ETL mapping rules.
• Involved in Data Analysis and thereby creating Data Mapping Documents.
• Involved in data extraction from various sources like SQL Server, Oracle, flat files and DB2.
• Performed Manual Testing to test the brokerage applications on various apple and android devices and multi browser testing on IE7, 8, 9 Firefox11, 12, Google Chrome18, 19,Mozilla and Safari 534.55.3.
• Created SQL scripts to verify the data for truncated values, null values and duplicates.
• Verified the source data elements to destination data elements is mapped correctly.
• Validated the Counts and Contents from source file to Staging and then from Staging to DW.
• Executed the DW reports by running SQL Queries against the source files.
• Validated the contents and counts in Fact and Dim Tables.
• Involved in logging defects in DTS (defect tracking system), retesting and providing test metrics. Communicated with developers through all phases of testing to prioritize defect resolution.
• Tested the web services applications and validated WSDL files using SOAP Scope
• Validated request and responses against XML Schema using XML Spy Modified XML files to manipulate the data to create errors on the Web services to perform negative scenarios.
• Developed Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.
• Performed Web Services testing using Mind reef Soap Scope, Audit Viewer (to view message logs) and Appwatch (MQ) for Customer and Accounts related transaction projects
• Involved in creation of Testcases in Quality Center/ALM and Testing Signoff Document and suggesting quality improvements once the ST1 (System Testing in IT), ST2 (System Testing in UAT) and BLA testing is done.
• Worked with the Hogan CIS backend systems for data querying and information retrieving.
• Involved in leading the Daily Defect meetings, Weekly Status meetings and creating Weekly testing status reports to submit to the project management team.
• Mentored new team members and consultants delegated tasks and helped end users to understand the Process flow of various Applications and serving as Subject Matter Expert (SME) to the team by serving as QA Coordinator whenever needed by the project team. Responsible for Sanity testing of SOR File loads
• Involved in creation and execution of testcases relating to Account Management, Lead Management- Manual creation of Leads in SFDC,Accounts Update Process, Contact – Contact Creation process, Contact Update process, Contact Delete process and Opportunity Management- Opportunity Creation through Internal Sales Involvement, Opportunity Creation through Accounts, Opportunity creation through Lead Conversion, Auto Renewal Opportunity in Salesforce.com Project..
• Received E-buttons and Appreciation emails from Managers for making projects go live successfully due to excellent testing efforts and working during weekends and after office hours to get the work done when needed by the team.
• Suggested and implemented innovative ideas to make QA Process more efficient. Assisted in establishing testing best practices and made suggestions for process improvement efforts within Quality Assurance process. Involved actively in ICTD (Intelligent Test Case Design) Test Case Standards Team. Communicated effectively with Developers, Testing team members, Business Line/End Users, Development and Project managers to resolve issues and questions through all phases of testing.

Coventry Healthcare, MN, QA Analyst Jul 08 – Sep 10
Worked as a QA Analyst at Coventry Healthcare provider of healthcare services. The scope of this project was to build a site for registered members/patients which provides various features such as Search utility to all the registered patients to view and select Physicians, schedule appointments, request quotes and various tools for managing your well-being and claims processing.

Responsibilities:
• Analyzed the user/business requirements and functional specs documents. Involved in meetings for preparing test plans based on Business Requirements Document (BRD) and System Requirement Specifications (SRS)
• Parameterized the scripts and tested those scripts using data driven methodology
• Provided estimate of test efforts to project Stakeholders and planned accordingly to monitor the testing status to cost/time and resource projections.
• Involved in the preparation of Master Test Plan specifying an overview of testing approach, Testing strategy, roles, responsibilities and its scope.
• Created the traceability matrix between requirements and test cases.
• Prepared sample EDI test sets for files like 276/77, 278,837 and followed HIPAA implementation guide in preparing them.
• Prepared Claim, Member, Provider Test data for Test cases.
• Tested various operations in the claims processing (Adjustments, Claims, and Overpayments, underpayments, COB, COBRA and External Claim editing).
• Reviewed EDI 837 claims and flagged HIPPA non-compliant claims received from the Payer side.
• Tested the claims processing with EDI transactions (270/271, 276/277, 278, 820, 834, 837 and 835) in HIPPA and HL7 Environment.
• Performed Manual Testing to test the application on multi browser testing on IE, Firefox, Google Chrome and Safari.
• Used Quick Test Pro (QTP) to create and run automated scripts and reusable actions. Tested the application by inserting check points and synchronization points in test scripts.
• Conducted Daily Defect meetings to discuss testing issues, defects and results with development team and business users.
• Performed database verification and validation using SQL Queries for various test cases in Quality Center.
• Used SQL to verify that all conditions in the transformation logic have been covered
• Validated Source to Target mappings. Worked with developers and end users to resolve issues that are found in the data, mapping document.
• Compared the source tables with the target tables for data base testing
• Prepared Testing signoff document and worked with development and business users to make Go/No decisions for deployment.
• Logged the defects, determined repair priorities and tracked the defects until resolution using JIRA.
• Used Apache Axis utility to generate client for Web Services, executed Web Services using Eclipse Java IDE and SOAP UI.
• Coordinated and assisted in the development and execution of User Acceptance Test Cases.(UAT Testing) for business line users.
• Mentored junior team members and helped them come up to speed with testing by providing SME support. Worked with offshore testing team in India and coordinated their efforts.
• Communicated the status and progress of multiple projects to QA Manager and Project Managers which helped them forecast any risks through Status reports and Meetings.

Wells Fargo Home Mortgage,MN, SQA Lead /Analyst Feb. 07- Dec 07
Wells Fargo & Company is a financial services company providing banking, insurance, investments, mortgage and consumer finance through more than 6,000 stores, the Internet and other distribution channels across North America and internationally. As a software Quality Assurance Analyst I worked on multiple large scale projects like Eclipse Project, CAMP Project, IL Foundation Project using Image Capture Technology (ICT – Scan, Capture the digital images and export it to database) as well as various small enhancements.

Responsibilities:
• Involved in preparation of Test strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required conducting the effort.
• Involved in meetings for preparing test plans based on Business Requirements Document (BRD) and System Requirement Specifications (SRS).
• Involved in Smoke testing, Functional testing, Regression testing, Integration testing and System testing.
• Used Agile Testing Methodologies while working on ICT Project. Involved in walkthroughs of acceptance testcases, reviews, daily SCRUMs and project retrospective meetings. Used Version One for agile testing which include testcase creation, execution and defect status.
• Involved in setting up the Test Environment for Smoke Testing ,SIT Testing and UAT Testing.
• Assisted in the development and execution of User Acceptance Test Cases in Quality Center.(UAT Testing)
• Participated in walkthroughs, reviews, status meetings, daily SCRUMs and project team meetings.
• Setting Up the environment for writing Test Cases using the Quality Center instead Of using Spreadsheet(in Excel).
• Involved in the preparation of Master Test Plan specifying an overview of testing approach, Testing strategy, roles, responsibilities and its scope.
• Setting Up the environment for tracking the defects using the Rational ClearQuest and Version One.

Applied Industrial Technologies,CA, QA Analyst Dec. 05- Feb07
Responsibilities:
• Involved in meetings for preparing test plans based on Business Requirements Document (BRD) and System Requirement Specifications (SRS) and suggested areas of improvement by acting as a Subject matter expert.
• Analyzing System Requirements and functional designs to identify potential gaps prior to preparing test plans and test execution by performing Gap Analysis.
• Developed Test Cases and automated Test scripts based on the functionality of individual screens and overall system flow. ensuring that it meets all defined business requirements and associated functionality.
• Involved in Integration Testing with other departments like POS, Finance and Inventory.
• Parameterized the scripts and tested those scripts using data driven methodology.
• Wrote SQL queries, functions and stored procedure to check proper data population in application tables.
• Developed and executed testing scenarios and conducted integration testing in all areas of SAP FI/CO,CRM,HR SD and MM modules.
• Coordinated the efforts of offsite team and worked on multiple projects.
• Interacted with Business teams and Developers to understand business requirements and bug fixes.
• Participated in status meetings, release meetings to report issues.

Toyota Financial Services, CA,QA Analyst / Tester Jan 05 – Oct 05
Responsibilities:
• Involved in testing the application manually in the initial stages and then developed the automated test-scripts in the later stages.
• Involved in Development and Execution of Test Plans, Test Cases & Test Scripts by reviewing the business requirements document, and technical specifications document.
• Analyzing System Requirements and functional design documents.
• Used Quick Test Pro(QTP) to create automated scripts, created transactions and reusable actions.
• Generated sanity level automated script to check the objects overview in the application before regression testing.
• Tested the browsers under specific conditions, with Java script enabled and disabled
• Gathered Test Input data. Test Input data includes Pre-condition, Test Input, Test Result, Test Regression data.
• Extensively using IBM AIX ISeries to validate and verify the Reports.
• Participated in User Acceptance Test (UAT), Documented procedures and guiding the users in verifying various transactions on the System.
• Involved in the functional testing of web pages , Developed Test scripts and enhanced scripts using QTP
• Responsible for weekly status updates showing the progress of the testing efforts and open issues to be resolved.
• Actively participated in enhancement meetings focused at making the application more stable for real time usage.
• Worked with offshore testing team in India and coordinated their efforts.

PNC Financial Processing Corporation,PA, QA Tester Sep 03 -Nov 04
Responsibilities :
• Involved in the preparation of test plan specifying an overview of testing approach, Testing strategy, roles, responsibilities and its scope.
• Developed Functional Test Scenarios and Procedures to meet the project requirements.
• Involved in designing and implementing the QA Process using RUP (Rational Unified Process)
• Responsible in creating and modifying the existing documentation and submitting them in perforce (Version control System).
• Documented detail Test Plans using MS Word following the documents.
• Developed the test management process and trained and mentored testing staff on automation tools, automation process and quality assurance.
• Developed and executed QA Test plans for Functional, Integration and System Testing.
• Maintained Test Matrix for latest test results information
• Prepared status summary reports with details of executed, passed and failed test cases.
• Prepared bi-weekly and final testing report of the whole application.

Experience
BACK TO TOP

Job Title
Company

Experience

Senior Software Tester

US Bancorp Information Services Corporation
– Present

Additional Info
BACK TO TOP

Current Career Level:
Experienced (Non-Manager)

Work Status:
US – I am authorized to work in this country for any employer.