SUMMARY:

• 5 ­­years of experience in IT industry with an emphasis on Software Quality Assurance & Testing.
• Extensive experience working in various domains like Banking/Finance
• Strong knowledge of the Systems Development Life Cycle(SDLC) models such as Agile, Water Fall methodology.
• Worked Extensively with Manual and Automated Testing.
• Experienced in developing Test Plans, Test Cases based upon the business requirements.
• Involved in maintaining Test Matrix and Traceability Matrix(TTM) and performed Gap Analysis.
• Executed QA testing in various data warehouse environments.
• Strong DataWare housing experience using Informatica Power Center, Oracle Warehouse Builder, Data mart, ETL, OLAP, OLTP.
• Experience in implementation in Database, Dataware house, Client/Server, Mainframe and web based Applications.
• Worked on functional testing of IBM InfoSphere Information Server on various platforms including Solaris, Linux and Windows.
• Performed User Acceptance Testing (UAT) Manually.
• Proficiency in interacting with Oracle, SQL Server and DB2 databases using SQL.
• Participated in design walkthroughs and verified QC Test Scripts and results.
• Proficient knowledge in various types of Software Testing such as Black Box, Positive, Negative, Data - driven, Unit, Integration, System, Front-End and Back-End Testing.
• Effective Time Management Skills and consistent ability to meet client deadline.
• Excellent analytical, problem solving, presentation, and interpersonal skills.
• Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte,NC

QA Analyst

Responsibilities:

• Involved in Business meetings with SME's for the walkthrough of requirements and application.
• Using agile methodology and engage in an iterative workflow and incremental delivery of working software.
• Created Test Plan from business requirements for System balance & controls project for Financial Dataware house.
• Created Test Plan for PeopleSoft Financials Cost-alignment project.
• Created Test cases for PS cost-alignment project for allocating expenses for Xerox, postage, Purchasing accruals, Performance compensation allocations.
• Created and set up test data by creating journals for testing allocations in PeopleSoft general ledger.
• Collected weekly test metrics that reflected the current status of the test execution and the state of the defects.
• Tested application engine and SQR process that were created in people soft general ledger like Rent and occupancy, performance compensation, copy and postage and Benefits allocations manually.
• Used SQL Server management and verified data present in database by writing SQL queries.
• Interacted with offshore team regularly and assigned work related to the projects.
• Tested data flow from Omni application to Financial Dataware house.
• Wrote SQL, PL/SQL queries/procedures to access data and crosscheck the results against Data Warehouse.
• Constructed complex SQL queries to validate the data in between Source Tables Vs Data warehouse as per the Transformations defined in Data Specification documents.
• Proficient use of Quality Center to log and track defects and to keep track of the Business Requirements.
• Verified the rectified bugs by retesting the application after the defects are fixed.
• Extensively used SQL statements to validate the front-end values with the backend of the application.
• Involved in tracking and updating of the Requirement Traceability Matrix, thereby linking the test cases with the business requirements as well as other associated test cases.
• Created Application Understanding documents for Summary Prospectus project, System Balance and Controls project and PeopleSoft Cost Alignment project which are used by On-site and offshore teams.
• Performed back end testing using Query analyzer and Crystal reports.
• Involved in Integration testing and Regression testing of the people soft application.
• Participated in defect review and go-no/go meetings.
• Verified the files that enter into CTLS are in correct format where these files will be used for loading data in FDW.
• Coordinated team of QA resources to perform the testing related activities through all phases of STLC.
• Active interaction with team members, team lead and developers in review meetings to evaluate the progress and performance of the application.

Environment: Quality Center, Agile, SQL Server, WINDOWS, M.S Office(MS Excel, MS Word, MS PowerPoint),Dataware House.

Confidential,San Francisco,CA

QA Tester/Manual Tester

• Creation and execution of the various Test cases and Test scripts.
• Using agile methodology and engage in an iterative workflow and incremental delivery of working software.
• Development of SQL queries as per the request from the business team in SQL server.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Used SQL to ensure the data integrity is maintained.
• Created Test data for testing various scenarios involving the creation of Packages, Customers, and Accounts for Deposits, Loans, Credit Card applications.
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance.
• Worked on creating an application for borrowers which will let them access and get updates from Loan application to closing of the Loan on a user friendly interface. Created Process flow diagrams to depict the welcome email user receives, the pending documents trigger, follow up status and deny application status.
• Define Strategy and planning for Data warehouse Testing and Test Data Management.
• Participated in major project - Finance Metrics / Data Mart testing (Data warehouse testing). Verified source data retrieved from various applications. Validated data loaded into database, initial data loading and incremental data loading. Verified the records inserted or updated in the database.
• Primary tester of Finance Metrics Rework (Data warehouse testing). Verified SAM's data (enterprise accounting system) loaded into database - Activity, Summary, Adjustments and Funds. Validated the data with balance sheets and Excel formulas.
• Created and Maintained Test Matrix and Requirement Traceability Matrix.
• Primary tester of SSN masking and VBA reports which includes report of Address, Allocation, Balance, Fee, Loan Balance, Transfer Activity and Participant Default on Omni Station (SunGard)- a 401(K) Plan management and administration system.
• Developed and executed test cases test Scenarios and followed-up defects using Test director.
• Proficient use of Quality Center to log and track defects and to keep track of the Business Requirements.
• Arranged weekly team meeting to assign testing tasks and acquisition of status reports from individual team members.
• Conducted Bug review meeting to discuss resolution of issues.
• Participated in Triage Meetings, weekly status meetings with IT and business people.

Environment: Quality Center, SQL Server, WINDOWS, M.S Office, Dataware house

Confidential,El Monte,CA

Dataware house Developer

• Good knowledge of Software Quality Analyst methods, code optimization techniques, software performance tuning and enhancement techniques.
• Good knowledge of various Testing methodologies such as Unit testing, Integration and System testing, Automation Testing Service, Functional Testing, Client server architecture testing, web based testing, Test Data Management.
• Extensive working experience on multi-tiered environments involving SQL Server 2008 T-SQL, SQL Server 2005 T-SQL.
• Analytical Problem Solving: Analyzing the effective heavy duty data solutions for Database Archiving, Data Conversion and Batch Data interface using SQL Server.
• Extensive knowledge of C# object oriented programming language and object oriented application development cycle including threading and garbage collection.
• Excellent Analytical skills and strong ability to triage and troubleshooting complex business and technical problems.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team. Sincere, well-organized, quick-learner self-motivated team player.
• Provided the test summary report to the QA Lead and coordinated with the fellow QA to plan the test execution.
• Coordinated with onsite and offshore teams for better understanding of client needs and provided quality deliverables.

Environment: Windows, SQL, C, C#