SUMMARY

• Over 9 years of experience in Software Testing from Finance, Healthcare and domains
• Testing expertise in DB Testing pertaining to ETL and BI environment. Authoring and executing complex SQL queries on Oracle 10g based ETL environment. Easy in using complex Excel functions for report generation for data comparison across FACT and STAGING tables. Experienced in using Oracle SQL Developer and Toad for querying Data bases.
• Experienced in XML data import to SQL data base. Validation pertaining to XML node data verses DB values verification pertaining to bulk clinical trial data imports.
• Hands on experience of establishing framework and working in framework based test automation
• Experienced in automating test cases using various tools viz., QTP 11, 9.5, 8.2, OATS 9, Test Complete 6 and selenium
• Demonstrated aptitude and interest and passion for programming - VB and SQL
• Strong understanding of OOPS concepts and Java IDE
• Hands on experience in authoring scripts towards keyword driven framework in QTP 11 and 9.5
• Exhaustive scripting experience in VB towards automation framework.
• Possess sound knowledge of Data bases. Authored SPs for data population.
• Extensive usage experience in quality management and defect tracking tools - QC 11, QC 9.5, TD8, rational tools and test link
• Experience in Handling payment and transaction processing
• Exhaustive web applications testing experience on various browsers/platforms.
• Experienced in gathering information and writing use case stories, test scenarios and test cases for complicated applications.
• Experienced in web content management testing in Oracle UCM 10g
• Worked in Agile and HIPAA (P and S) environments
• Possess working and configuration experience in SAP R/3 (PP,MM) sound functional knowledge in MRP and manufacturing processes
• Experienced in Six Sigma and SPC methodologies
• Possess Leadership, collaboration skills, attention to details and taking a big picture

TECHNICAL SKILLS

• Operating System: Microsoft Windows Family, Unix
• Database: SQL 2000, Oracle
• Web Technologies: HTML, ASP, XML, JS
• Test Automation tools(GUI): QTP 11, 10, 9.5 and 8.2 on VB, Java, Flex/Oracle 11G; VB, .Net / AIX
• Winrunner 7.6, Oracle Application Testing Suite, Test
• Complete 6, Compuware Testpartner
• Test Automation (CUI): SmarTerm macro coding
• Scripting language: VB 6
• Other tools used for automation: Winrunner 7.6, test complete 6, OATS 9.2
• Performance testing: Used WAPT, Trained in HP Load runner
• SQL: Authored stored procedures for large pool of data creation
• SDLCs environments worked with: Agile and waterfall
• Test management: Quality Centre11, Test link, Rational
• DB testing: Conversant with SQL queries. Written stored procedures for
• Data Population
• CRM Tool: Trained in Siebel CRM - Call center application
• Content Management tool: UCM

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Responsibilities:

• Evaluation of credit data difference amongst FACT and other stage and dimension data bases
• Execution of queries pertaining to periodical release testing and reporting
• Documenting and reporting of data changes for periodical releases
• Validation of defect fixes managing tests in ALM 11 for regular releases
• Authoring small stored procedures/queries in oracle for small time needs to improve productivity
• Defect validation for build release needs periodical needs
• Using Oracle Business Intelligence tool for verifications and tally against DB
• Participating in defect triage meetings and working with development for target fixes
• Coordinating with Business team for verifications and requirement
• Validation of Staging and Fact data against the meta data ETL mapping document
• Prepared a document for staging and FACT table mappings for regular validations and written queries for the related validation.
• Involved in extensive DATA validation using SQL queries and back-end testing and Support data reconciliation and validation efforts in existing production data and reporting systems
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.—Studying the difference between staging and fact and legacy DBs.
• Data validations against ETL pertaining to quality of data seen in staging and reporting defect issues.
• Adhering to ITIL standards of working at every stage of defect tracking and others

Environment: Oracle SQL developer and Toad for Data Analysts. Oracle 11G DB, Informatica,

Confidential,

Responsibilities:

• Devising test data picking up strategy for new scripts
• Devising scripts for complicated test case involving Data base connections
• Development of public functions in VB for usage in framework
• Driver script files for new keyword driven test cases
• Script development in framework for regression needs
• Script execution, testing and evidence publishing to team
• Maintaining scripts for product enhancements
• Automation of established manual test cases with specific delivery targets
• Collaborating with offshore teams for over all deliveries
• Analyzing the requirement test cases for automation and escalations for clarifications
• Regular status and other Meetings with client
• Written and used complicated SQL queries for fetching data from Sybase for verifications against data in pdf.
• Test data handling and managing large test data for availability
• Review of test cases in QC and reframing if necessary towards automating the same in QTP
• Investigating defects in QC and retesting on a need basis.
• Important areas handled: New Enrollment, Benefit Focus (Medical and Health benefits),
• Claims, Handling changes in events and related changes in benefits,
• Obtaining claims statement to customers (from third party EDI). Validations of claim statement in pdf verses UI application. Validation reports to be sent to hospital and insurance beneficiary and so on.
• Domain summary: IT services for Health care insurance product

Environment: VB, .net, j script, Oracle 10G, QC 9.5

Tools: used: QTP 9.5, QC 9.5,

Confidential, Pittsburgh, PA

Responsibilities:

• Played a key role in Standardized the scripts according to locally accepted Hydride framework
• Developed VB functions and reusable actions for repetitive use
• Descriptive methods used in scripts as and when needed to improve maintainability
• Devised a new method of test data handling through QC folders
• New method on proto type to Invoke an HTML to enter test specific data specific to script
• Test results and evidence publishing to team
• Worked on small time VB scripts for OTA interface in QC, Script maintenance related:
• Periodical execution of scripts for regression testing needs, analyzing defects and publishing test results. Logging defects based on results
• Script development and executions towards smoke testing/data flow validations on a daily basis.
• Maintaining scripts for product enhancements
• Automation of established manual test cases
• Development of test cases and automating the same in certain circumstances
• Written and used complicated SQL queries for fetching data from Oracle DB for verifications against data in front end and for calculations in QTP scripts
• Extensively used Quality Center for batch process and executing the Automation scripts
• QTP script execution towards periodical Regression testing
• Enhancing our QTP tests by inserting checkpoints that search for specific values of a page, object, text and strings
• Analyzing QTP test results to pinpoint defects in the application

Domain summary: IT services for in house Mortgage product

Environment: Front End: VB, Java, Flex 3.0; DB: Oracle 11g, QC 11

Confidential,

Responsibilities:

• The general public interactive web site of Telstra was used for selling various telephone plans. The large dynamic content was held by Oracle UCM servers. The testing areas included bulk data movement across different data bases. Usage of queries for testing of data correctness, equality and content testing. Oracle SQL developer was used here. Testing the contents across different servers was also done.
• Interacting with client towards work - single point of contact for testing activities
• Creation of Test Plan, high level scenarios, test case construction, test estimates, resource estimates, weekly status reports.
• Validated the data across different databases
• Conducted and participated in internal QA meetings within the team.
• Creation of UAT Requirements Traceability Matrix.
• Test planning & Strategizing, quoting time needed for testing activities
• Allocating work to members on daily basis
• Helping members with troubleshooting
• Worked with Project Management to scope the testing effort and provide status and estimates.
• Java scripting - Authored test scripts in Oracle Application Testing Suite for feasibility study and demonstrated to the client.
• Test cases: Authored test cases. Reviewed test cases by members.
• Defects tracking and resolution - Prepared standard templates for defect creation, Initiating triage meetings, Coordinating with developers and other members for reproduction, resolution and closures. Reviewing of defects raised by members
• Reporting: Extracting test execution defect status reports from QC on daily basis and sending to PM and teams for triage.
• Worked with the content management tool Oracle’s UCM with for testing enhancements connected with client’s web content.
• Undergone in Siebel CRM - Call center application

Domain summary: General public content managed web site used for general public interface for Telstra services in Australia .

Environment: VB.net; DB: Oracle 10G. UCM, Oracle ATS, QC 9.2