SUMMARY:

• Experienced Quality Assurance Analyst/Tester with 7+ years of experience in the Information Technology industry, involving analysis, both Manual and Automated testing of Client Server and Web applications.
• Possess specific experience in the Banking, and Financial Domains.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and Test
• Summary Reports for both Manual and Automated Testing.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, Abinitio and Autosys tools.
• Expertise in designing and developing test strategy, test plan, test cases and generating test reports, defect reports and product quality assurance documentation.
• Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration Verification and Validation End - to-End and User Acceptance Testing.
• Experienced in Agile Methodology. Proficient in Black Box and White Box Testing methodologies. Possess specific experience performing Regression and Functional Testing using Quick Test Professional
• Proficient in Mercury s Test Director and Quality Center for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking.
• Proficient in Rational Clear Quest and Quality Center for Defect Tracking
• Defined and Implemented Processes and Procedures for QA Departments
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels

TECHNICAL SKILLS:

Operating Systems: MS-DOS and Windows, Linux

Languages: C, VB Scripting, JAVA Scripting.

Packages: MS Office 97 / 2000 / XP/ 2007, MS SHAREPOINT

RDMS Packages: Oracle 10g, SQL, MY SQL

Testing Tools: Quick Test, Professional (QTP), TEST Partner, RFT, RPT, JUnit (Eclipse)

Defect Tracking Tools: Quality Center (QC), MANTIS, JIRA, Rational Clear Quest

Web Languages: HTML, DHTML and XML

Tools: & Utilities: Documentum, Informatica, Cognos, SQL - SSIS SSAS SSRS.

EXPERIENCE:

Confidential, San Diego, CA

QA Tester

Responsibilities:

• Reviewed requirements together with QA Manager, QA Lead & Business Analyst.
• Reviewed Technical documents like BR, TR, SFD, PRD and DSD and Prepared Test Cases.
• Prepare Test Plans and Test Cases for the GUI, Integration and backend server DB to frontend.
• Execute SQL queries to validate data for tools displaying is correct.
• Developed and executed SQL queries using MS SQL Server for data verification.
• Responsible for functional specifications, test script creation and the initial testing of the imaging and workflow system.
• Review Functional Specification document, OM-XML and wireframes and understand the database and tables relations and functionality.
• Give suggestions to the development team to make the application more users friendly from user perspective.
• Write test cases in QC Test Plan and execute in Test Lab.
• Log defects in QC to keep track of the issues.
• Created Test Plan and Test Lab in QC and upload Test cases.
• Issued defects and worked with different teams to resolve.
• Modifying, updating, and uploading reports into Documentum, an online data repository for version control and distribution of deliverables to stakeholders
• Developed and executed various manual testing scenarios and neatly documented the process to perform Functional of the application

Environment: s: HP Quality Center, QTP, Oracle,SQL, SQL Server, HTTP, SOAP UI, HTML, XML, Documentum, Outlook, Excel.

Confidential, Omaha, NE

QA/ETL Tester

Responsibilities:

• Developed and maintained the Quality Assurance Program Plan and implemented the documented quality and testing policies, plans and processes to support the plan.
• Reviewed Technical documents like BR, TR, SFD and IA and Prepare Test Cases.
• Prepare Test Plans and Test Cases for the Integration of the backend server DB to frontend EDW.
• Execute SQL queries to validate tables in Data Base.
• Created a New Hire document containing information to help orient a new hire to the QA Team. Document contained How-To s including access and setup instructions to applications, databases, supporting test ware, and test tools
• Created a standard operating procedure document for the application under test and its tools
• Responsible for functional specifications, test script creation and the initial testing of the imaging and workflow system.
• Created a QTP Instructions and troubleshooting document to assist new and existing test team members with the creation and modification of QTP automated scripts
• Review Functional Specification document, OM-XML and wireframes and understand the database and tables relations and functionality.
• Write test cases in QC Test Plan and execute in Test Lab.
• Give suggestions to the development team to make the application more users friendly from user perspective.
• Developed and executed SQL queries using PL/SQL Developer for data verification.
• Extensively do the Database testing in Teradata, Quality Center and Informatica IDE.
• Connect to Database from UNIX and validate tables using SQL.
• Update the Databases as the new build comes in and set up the environment.
• Report issues directly to developer and get the fix immediately and regenerate the database with the new code and retest to verify if the fix is applied.
• Log defects in QC to keep track of the issues.
• Created Test Plan and Test Lab in QC and upload Test cases.
• Issued defects and worked with different teams to resolve.
• Executed SQL queries in Teradata SQL Assistant to check DB tables.

Environment: Teradata SQL Assistant, Quality Center 10.0, Excel, SQL, PL/SQL, Microsoft Outlook, Informatica IDE, Informatica Power Center, DBW, ETL, Excel, MS Office, VEdit, Ultra Edit, Ultra Compare, Putty

Confidential, Wilmington, DE

ETL QA Analyst

Responsibilities:

• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Ab Initio and provide technical support and hands-on mentoring in the use of Ab Initio.
• Tested reports and ETL mappings from Source to Target
• Created test case scenarios, executed test cases and maintained
• Managed test cases in Mercury Quality Center and tracked defects using Quality Center 10.0
• Developed and executed various manual testing scenarios and neatly documented the process to perform Functional of the application
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Involved in testing of Informatica mappings. Performed Data Validation with Data Warehouse
• Developed test plans and performed peer reviews of deliverable documents to be stored in Documentum.
• Developed and executed SQL queries using MS SQL Server for data verification.
• Reviewed and analyzed project documentation including functional requirements, wireframes, visual design, and copy and developed high level and detailed test cases based on those documents.
• Modifying, updating, and uploading reports into Documentum, an online data repository for version control and distribution of deliverables to stakeholders.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL testing and designing of the flow and the logic for the Data warehouse project.
• As a ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.

Environment: Mercury Quality Center, Informatica, Ab Initio, ETL, QTP, SQL, MS SQL Server, MS Office Suite.

Confidential, Pleasant Hill, CA

QA Tester

Responsibilities:

• Reviewed requirements together with QA Manager, Vice President of Human Resources & Business Analyst.
• Created automation framework for testing account management system in the HP QTP/ QC environment.
• Created presentation documents and guidance materials on the automation framework.
• Played key role in defining test automation procedure and standards, creating Win Runner and Quick Test Professional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
• Tested Performance & Accuracy related queries under SQL Server.
• Reviewed existing documentation on the testing application and communicate issues with other teams (development, networking, DBA, etc.)
• Regular interaction with the core developers helped us in fixing the defects in less time.
• Worked with Test Analysts to ensure that defects are tracked and documented and results communicated to developers and stakeholders.
• Created automation scripts and user-defined functions and executed them daily.
• Created and executed the smoke tests in the pre-production and "go live" environment.
• Reported found issues and tracked them in the HP QC.
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Provided reports on automation coverage, issues and prospects.
• Conducted interview of candidates for the automation tested position.
• Coordinated automation efforts of automation engineers.

Environment: s: HP Quality Center, QTP, HTML, Oracle, SQL, PL/SQL, SQL Server, HTTP, SOAP, HTML, XML.

Confidential, Paramus, NJ

QA Tester

Responsibilities:

• Analyzed Business Requirements and Identified documents required for system and functional testing efforts for all test scenarios.
• Developed all the necessary documents for QA Testing like Test Strategies, Test Plan which includes all test items & Test Cases, and User Documents etc.
• Validated the daily and monthly reports in against the data in Oracle databases
• Worked in brokerage operations processing new accounts and general securities transaction process.
• Reviewed manual testing methods and created and implemented an automated test strategy and generated automation scripts.
• Participated in the development of data from the existing systems to the Oracle Financial Applications
• Worked closely with users and Application developers to ensure that application development meets to user s expectations.
• Maintained client database, working closely with team to relationship-manage customers and maximize referrals and sales opportunities .
• Extensively validated the back-end data by using SQL and PL/SQL.
• Developed TSL scripts and GUI maps for all the test cases to be tested manually and automation using WinRunner for functionality, integration and regression testing.
• Created WinRunner scripts that were used by other testers for regression testing.
• Created automated scripts using WinRunner for checking functionality and rules defined in CORBA server using test driver programs.
• Enhanced test scripts by inserting synchronization and checkpoints.
• Gained familiarity with the use of Actions and Transactions. Parameterized the test script to run with different sets of data.

Environment: Win Runner 7.0, Test Director 7.0, TSL, SQL, PL/ SQL, C, Java 2.0, CORBA, Oracle and Windows 2000,Oracle 8.1.6/9i.

Education - Bachelor’s in commerce 1998; Delhi University, India