SUMMARY

• 7 years of Experience in Quality Assurance which includes Manual Testing and Automation Testing in Health Care, Insurance and Banking domain
• Strong knowledge of Software Development Life Cycle (SDLC), Testing Techniques and Methodologies
• Experienced in designing Test Plans, Test Scenarios, Test Cases, Test Reports and Documentation
• Highly experienced in all levels of Testing such as Black Box Testing, Positive Testing, Negative Testing, Integration Testing, ETL Testing, Functional Testing, System Testing, Regression Testing, Stress Testing, User Acceptance Testing (UAT) and others.
• Experienced in managing/executing test plans, test scripts HP ALM Testing Suite.
• Strong Knowledge in Bug Life Cycle and Defect Tracking
• Expert in writing Test Cases based on the Business Requirement documents
• Expert in Automation Testing tool like Quick Test Professional and Test Management tool like Quality Center
• Proficient in Testing Web technologies - XML, XDA schema, SOAP, HTTP
• Generated Test Scripts executed Smoke Testing, Functional Testing, ETL Testing and Regression Testing etc
• Expert in building Data Driven, Keyword Driven framework, Automation Object Model
• Experienced in Descriptive Programming to test the dynamic objects and fire events
• Ensured the application was built as per the requirements and performs all intended functions
• Well versed with Office utility tools such as MS Word, Excel, Visio and PowerPoint
• Knowledge in DBMS and SQL, PLSQL Packages, Procedures and Functions
• Excellent communication, presentation and interpersonal skills
• Worked in tight schedules on different web and windows based applications
• Easily adaptable to any new Technologies and Business environment

TECHNICAL SKILLS

ESB: Java CAPS 6.2, Red Hat Fuse

Automated Testing Tools: Quick Test Professional, Load Runner

Test Management Tools: Quality Center, Bugzilla, IBM Clear Quest

Databases: SQL Server, MySQL, MS Access, DB2,Oracle, Terradata

Operating Systems: Windows XP, Windows 7, UNIX

Languages: HTML, Visual Basic, VBScript, Java, PLSQL, ProtgreSQL, Shell Scripting, Perl Scripting, Python

ETL: Informatica 8.6

Other Tools & Utilities: MS Word, Excel, PowerPoint, Visio

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Quality Analyst

Responsibilities:

• Reviewed requirements and design documents with developers and project manager to confirm expected functionality with technical and business needs.
• Evaluated features using risk based testing techniques. Gathered Business Required Document and created Test plan and Test cases.
• Designed, formulated and optimized application test strategy, test scenarios, and test cases .
• Tested multiple types of Publisher & subscription model interfaces ex Web service to Database, Database to Database, FTP to Database etc.
• Validated data integrity in the source and the target systems for Bug free Data transmission.
• Performed Positive, Negative, load and Regression tests for given CRs. Change Requests .
• Arranged weekly meetings with responsible source and target system leads for test plan review and status.
• Communicated project readiness, status and potential risks with stakeholders.
• Documented, quantified and elevated risks and Provided statistical reporting and analysis.
• Estimated effort required to perform QA activities and reported QA status on Daily basis.
• Managed to work independently or as a Team player in dynamic work environment.
• Quickly adapted to multiple external systems and applications to validate the dataflow among systems.
• Analyzed existing Oracle Packages / Procedures / Functions and recommended Metadata designs for better data management.
• Eliminate code redundancy by developing Reusable Utility Packages that can be used by other packages and developers / Testers/Operations teams.
• Analyzed the performance of the SQL queries using Explain Plan and tuned queries for testing needs.
• Automated a consolidated Error Report from error table using UTIL MAIL.
• Created friendly user guides as future reference for Confidential ’s teammates.

Environment: Quality Center, Java Caps, PL/SQL, JAVA, Windows 7, MS Office, UNIX.

Confidential, Newark, DE

Quality Analyst

Responsibilities:

• Created Test cases for various scenarios in the Quality Center.
• Created PL/SQL Packages on the QA Environment for efficient testing.
• Tested Oracle Stored Procedure for positive and negative scenarios
• Worked with vendors closely to get appropriate data for testing on QA environment.
• Used SAS to create datasets by merging oracle tables, existing datasets, and delimited text files.
• Validated SAS datasets for tagging bad records based on business rules.
• Validated the lookup functionality of QDE which fetches matched records from data warehouse.
• Validated SCD Type 2, Type 3 tables which the process uses for fetching data for processing accounts.
• Performed backend testing for data integrity, Data Accuracy and consistency.
• Executed and Validated UNIX (KSH) Shell Scripts which calls SQL jobs in sequence.
• Executed Test Cases and validated data transformations at various stages.
• Tested suppressions on the main dataset based on business logic and validated results.
• Tested the SAS algorithm on calculation of Delta exposure and assignment of line and level to the chase customers.
• Tested SQL Loader to load data to target tables and validated the exchange of partitions after compete load.
• Worked in Agile, waterfall method Environments adapted and created Test scenarios.
• Logged Defects and tracked them in Quality Center and Documented potential risks identified during testing and reported to project manager.
• Involved in Testing ETL-Informatica various mappings/transformations.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse target schema design (star schema) and maintenance.
• Used extensively Informatica Designer, Workflow Manager, Workflow monitor and Repository Manager.
• Executed and tested Perl scripts.
• Tested Sessions, Workflows/Worklets and scheduled them in the Workflow manager and Performance tune them.

Environment: Quality Center, (KSH) Shell Scripting, Perl scripts, PL/SQL, SAS, JAVA, Windows XP, MS Office, SQL Developer, UNIX.

Confidential, Newark, DE

Quality Analyst

Responsibilities:

• Gathered Business Required Documents and understood the Data Flow Diagrams of the new process
• Created Test cases in the Quality Center for each functionality of the process
• Conditioned data in the QA Environment using PL/SQL for the process to pick the test accounts
• Written a sas code to dump sas datasets into temp tables, Sort and Merge datasets.
• Validated each sas dataset by running various SQL queries and made sure the data is as per the BRD.
• Coordinated with Policy team and development team and made sure both teams are in SYNC
• Identified potential issues and reported to the Dev team and logged defects in the Quality Center
• Worked closely with DBA to make sure the process is using resources at required level and performed stress testing
• Created PL/SQL Blocks to condition the data for a faster and efficient testing
• Worked closely with Production Support team for a smother Implementation into Production

Environment: Quality Center, (KSH) Shell Scripting, Perl scripts Windows XP, MS Office, SQL Developer, UNIX

Confidential, Newark, DE

Quality Analyst

Responsibilities:

• Created Test Cases based on the Test plan to cover all the requirements in the Requirement Specifications document.
• Tested the process for the restart logic if the process fails unexpectedly
• Conducted negative testing on every process to capture the Return code and pass it to TWS
• Tested Common Function library with the new return code capture capability
• Recommended many code changes to existing processes to handle scenarios when there is NODATA to process
• Tested many Time sensitive shell scripts to run and append the log file
• Executed all the Test cases, Tracked Defects and reported status in Defects Module of QC
• Managed and Updated RunBook for the Production Support team to prevent flaws during ECM Enterprise Change management
• Ran SQL Queries to inserted data from production servers to QA server and ran the process at the scheduled time to create real production scenario
• Coordinated with the Development and the TWS team to set up resources and Naming Standards for jobs and streams
• Performed Black Box, Positive, Regression and Negative testing for all the assigned processes
• Opened Defects and follow up till the dev team fixed the defect

Environment: Quality Center, (KSH) Shell Scripting, Perl scripts Windows XP, MS Office, SQL Developer, UNIX, TWS.

Confidential, Newark, DE

Quality Analyst

Responsibilities:

• Performed Backend Testing for the changed steps and compared with production version
• Implemented various test strategies to test the code changes made to the process
• Validated the Terradata queries by running queries in Terradata SQL Assistant after the process runs
• Detected various defects occurred during the migration at the code level and reported to the developers
• Extensively tested the code changes at every step and coordinated with QA lead and Developers
• Tested Common Engine exclusions for the accounts after the code change at any given step
• Performed Data Validations by developing queries to test if the process picks accounts as per the Functional Tech document
• Detected Production issues opened ticket for EPI (existing production issue) and recommended fix for the new release of the process.
• Created real life Negative test scenarios for the process to fail and recommended code changes.
• Created test data to test the process after the changes made to the SQL files
• Performed Regression Testing after every tar release to make sure only authorized code changes exist
• Tested process doesn’t have any reference to the legacy database (ADS) at any given step and the EVAR file
• Created Implementation scripts and tested if the process is running exactly same in Production Environment
• Participated in meetings, supported the defect management process and reported updates

Environment: Quality Center, (KSH) Shell Scripting, Windows XP, MS Office, SQL Developer, UNIX.

Confidential, Napa, CA

Quality Analyst

Responsibilities:

• Created and developed Test Scenario, Test cases for Billing Accounts, Process Payments, Cancel policies and Refunds for different user lines for multiple states
• Performed Function Testing, Integration Testing and Conversion Testing on the vista system
• Developed, modified and executed test cases and scripts using QTP for Integration testing
• Performed Concurrency testing for premium accounting modules
• Functionality testing on Lockbox process, Process batch cash and Process suspense functionality
• Developed automated test scripts for CR (Change Request) for vista and Claims legacy system
• Created Shared Object Repositories and passed variables to Actions Scripts and functions
• Performed data validation for the migrated data sets from legacy system to Vista
• Tested invoices/payments for standard accounts and custom with ERC and Non-ERC accounts
• Performed testing on Refunds, Financial Transactions and A/R History by Policy, A/R History by Billing account, A/R History by Unit functionality
• Tested role-based security which allows/restricts access to system features and data based on roles assigned to a user
• Extensively tested flat rate, prorate and short rate cancellation procedures
• Performed test cases on Process Batch Cash, IPN, and ERC, Refunds reports that were developed using Business Objects
• Created Recovery Scenarios and Exception Handling for running tests smoothly
• Created various Database Check Points, Text Check Points, XML check Points etc on the Vista System
• Used Regular Expressions to make Test Scripts Reusable on the entire module
• Used Descriptive Programming to test the Dynamic objects and get their properties
• Tested the Refund Security, Payment Plans, Primary Billing modules for existing and new policies
• Developed migrating test scripts using Quick Test Professional using keyword driven framework for various modules of the vista billing system
• Created UAT test cases and Executed them, helped the end users understand and use the application

Environment: Windows NT/XP/7, DB2, VBScript, HTML, XML, VB, SQL, Toad, Quick Test Professional, Quality Center.

Confidential, Cherry Hill, NJ

QA Tester

Responsibilities:

• Analyzed the Business requirements, functional specifications, System Design Documents and Use Case documents
• Applied business requirements definition to align business needs with technical implementation. Created Test cases based on Test Plan and Test Scenarios
• Executed the test cases and scripts by importing them into Quality Center analyzed the test results and documented reports.
• Performed Smoke, Functionality, Integration, System, UAT, Regression Testing based on requirements and the software design document
• Written SQL queries for data validation at backend in SQL
• Tested grouping address based on zip code for mailing purpose
• Executed and maintained Regression Suite for Test Scripts and reported defects using Quality Center.
• Extensively used MS - Word/Excel for creating Test cases, documentation and data driven testing
• Developed test cases for Integration testing to test the data flow and data sharing among the systems
• Tested Future Date Capability, Contact History, CMS Activity log of the contacts and Contact Association based on existing data
• Developed Entry & Exit criteria for testing the CMS module.
• Performed Regression Testing using data driven framework on the Automated email to Customers when there is a change
• Used a combination of Mandatory Identifiers and Ordinal Identifiers to identify objects to build a better Shared Object Repository
• Associated Shared Object Repositories for different actions wherever required
• Flagged all the major defects in the defects module till they are closed by adding them to my favorites in QC
• Tested the application for Broken Links and used Synchronization Points using QTP
• Used Descriptive Programming to Identify Dynamic Objects, capture their Properties and Run Methods on them
• Performed regression testing after fixing the bugs and modifying the application in the next Build
• Developed Entry & Exit criteria and defined the pass and fail standards
• Linked Defects with Requirements, Requirements with Test Plan for better Tracking of the BUGS
• Produced Test Metrics showing the number of test cases executed, number passed, number failed and number left to execute in weekly meetings
• Reported QA activities like process flow, problem resolution, and bug tracking to Project Management teams on daily basis
• Generated various Test metrics, Daily status report, Weekly status reports, Monthly status report, QA Status report, Bug report, and Risk analysis document
• Coordinated with the end users during UAT and reported bugs to the development team

Environment: Informatica, Oracle, Windows/UNIX, Quality Center, Quick Test Professional