SUMMARY:

• Over 7 years of excellent IT experience in requirement gathering, data analysis, design, development,
• Experienced in Functionality, Integration, Performance, ad hoc, Stress and Regression Testing on Web and Client/Server based applications.
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Experience doing Data Validation on excel.
• Worked on Great Plains software for testing finance scenarios.
• Experience working with Team Foundation Server for defect management, writing test cases in MTM
• Experienced in functional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing.
• Advanced user in using Test management tools like HP Quality Center/Test Director, MTM
• Proficient with automated testing tools such as QTP, for testing client/server and web based applications.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• A good team player with excellent written and verbal communication skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Centre 8.6.1, Data Stage 8.5

Reporting Tools: SSRS

Data Modeling: E Microsoft Visio

Operating Systems: Windows NT/2000/2003/XP, UNIX and MSDOS

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, DB2

Testing Tools: Quality Center, Test Director, JIRA, HP Quality Center 9.0/9.2/10.0, DoorsLanguages: XML, SQL, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax, VA

QA Analyst

Responsibilities:

• Involved in developing test plans, designed test cases including detailed expected results.
• Involved in Test Case Preparation and Test Case Execution Manually.
• Analyzed application to find out which part can be automated and which can be manually tested.
• Implemented HP ALM/Quality Center for Test Planning, Test Case writing, Test Execution and Requirement Mapping with Test Cases.
• Test automation for web application (SWAP module) using Cucumber
• Performed defect tracking and reporting using Quality Center/ALM.
• Wrote SQL verification scripts to test the result of deployment for correct business logic.
• Performed Back end testing using SQL Quires.
• Conducted GUI and Black Box Testing using QTP and interacted with developers to resolve issues
• Designed and developed User defined functions, Generic functions with well versed VB scripting, Descriptive programming in scripting dynamic objects and Reusable actions in defining scenario flows in QTP.
• Determined the Entry and Exit Criteria for different phases in testing cycle of the system.
• Performed User Acceptance Testing (UAT) on behalf of End Users at client’s environment.
• Followed up with the development team as they fix the bug.
• Extensive mainframe testing with DB2/SQL skills
• Acted as test plan approver for offshore counterpart.

Environment: ALM/Quality Center, QTP, SOAPUI, Windows, Data Warehouse, XML,Agile,Rational Clear Quest, Rational Quality Manager, MS Office and MS Visio.

Confidential, Plymouth Meeting, PA

QA Analyst

Responsibilities:

• Wrote SQL queries to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Reported debugging using Excel data validation and tracked defects using Quality Centre.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back - end testing and worked with data quality issues.
• Worked in Agile technology with Scrum and waterfall models.
• Created and Developed Reports and Graphs using ALM.
• Tested the Front-End Web Applications developed in J2EE for data portal for matching
• Written test plans and estimated time frames for functional IT, UAT phases
• Involved in data warehouse testing by checking ETL procedures/graphs.
• Performed the tests in Adhoc, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing

Environment: QTP, Agile, Business Objects, Quality Centre 11.0, ALM, Oracle 10g / 11g, UNIX, TOAD.

Confidential, Washington DC

QA Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Tested XML feeds loaded into Data Warehousing.
• Tested SQL to extrapolate data from the B2B integrator database to populate a spreadsheet
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Responsible for co-coordinating with offshore team.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle Tested various operational Drill-through and Drill-down reports using SSRS
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Tested the validation process for QA/Prod in the Supply Chain Management System.
• Involved in data warehouse testing by checking ETL procedures
• Implemented and maintained tools required to support data warehouse testing.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Created different user defined functions for applying appropriate business rules
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records

Environment: Quality Center 10.0, SQL,TFS, B2B integrator Informatica, Flat Files, Agile, UNIX, Autosys, Oracle 10G, DB2, XML, XSLT

Confidential, Alpharetta, GA

QA Analyst

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Worked in Agile environment. Developed and implemented effective Test Plan, Test Cases, Test Strategies, Used cases based on the User Stories (Functional Requirements) and perform manual and backend testing.
• Running SQL queries to verify the frontend data in the backend database.
• Used Test Manager as a defect tracking tool and create test cases.
• Worked on Great Plains software for testing the loan products, verifying daily interest, interest calculations, repo scenarios, late fees interest.
• Involved in Test plan, Test case preparation and assigning defects through TFS(Team Foundation Server)
• Worked on report testing on smart list exported from Great Plains software.
• Corresponded with the offshore team to cover up all corners of testing and attend bug triage meetings
• Worked on the front end creating different loan scenarios to ensure data is populating in the correct accounts and verify the data in the corresponding tables in backend.
• Performed web services testing using Test Harness and soapUI.
• Prepared Test plans based on analysis of use cases, Business process specification documents and UI documents.
• Experienced in writing test cases, test plans and execution of test cases reporting and documenting the test results using Microsoft Test Manager (Team Foundation Server Env)
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Worked with the UAT testing team for testing scenario with Great Plains before the release.
• Review the test cases written based on the Change Request document.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Review the test cases written based on the Change Request document.
• Performed regression testing on new versions of the software.

Environment: MS SQL 2000, Oracle 9i, SQL, SQL Navigator, Unix, Windows XP and 2000, MTM, Great Plains accounting software, TFS

Confidential, Richmond, VA

SQL QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Successfully leading a team and coordinating the testing activities to complete System, Integration and UAT Test preparation on schedule.
• Experienced in defining, creating and implementing testing process and methodology for onsite/off-shore team.
• Was involved in UAT testing with their UAT team.
• Performed web services testing using Test Harness and soapUI.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experience testing data conversions and migrations in cross platform scenarios Informatica power center
• Extensive experience in Black box/White box, manual and Automation (QTP) testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in Front to Back testing for all European and Asia pacific regions
• As QA Tester, performing responsibilities with both the functionality and back end testing.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Used Quality Center for test management and defect Reports.
• Creating GUI Map File so that QTP can recognize the GUI objects in the application being tested
• Used Quality Center and performed regression testing on new versions of the software.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.

Environment: TOAD 9.2, Oracle 9.2, QTP 9.2, Quality Center 9.2, DB MS Excel, Web Services, Microsoft Share Point, Windows NT/XP//2003, Soap Ui Testing

Confidential, Flower Mound, TX

Sr. QA Analyst/ETL Test Analyst

Responsibilities:

• Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tested the Front-End Web Applications developed in J2EE for data portal for matching
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Tested Ad-hoc reports, drill down and drill through reports using SSRS.
• Tested different detail, summary reports and on demand reports.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.

Environment: Oracle 9i, SQL, PL/SQL, SQL Navigator, Unix, Windows XP and 2000, Mercury Quality Center.