SUMMARY:

• Over 7+ years of professional experience in system analysis, design development, and Quality Assurance in Client Server and Web Based Applications.
• Experience working in Financial, Insurance, Banking and Health Care Domains.
• Experience in software testing process which includes preparing Test Plans, Test Cases, Test Scenarios Executing Tests based on business requirements and functional requirements.
• Experienced in the different types of testing that include System testing, Integration testing, Functional testing, User Acceptance testing (UAT), Black Box Testing, Manual and Regression testing with automated testing tools.
• Working Experience with Agile Methodology - Scrum, V Model.
• Strong in developing Test plans, Test cases, Test data, Defect Tracking & Reporting, Ability to perform under deadlines, good individual and team player
• Managed the process of data creation for testing purposes.
• Prepared new Datasets from raw data and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Experience in testing on Enterprise wide applications with multiple databases, and Ability to test backend applications by using SQL statements.
• Testing of database projects on Windows and UNIX Operating Systems.
• Defect Tracking for both Manual and Automated Testing.
• Involved in Complete Software Development Lifecycle (SDLC) of QA Software Development and Testing Methodologies.
• Working experience with Oracle, MS SQL Server. ETL testing for data profiling and BI report system.
• Experience in creating QA testing environment using Integration, GUI, Functionality, Regression, and System Testing.
• Experience in test management and defect tracking tools like Quality Center, Clear Quest.
• Sound knowledge of Black Box, System Testing, Regression, Integration, Functionality and User Acceptance Testing, Database Testing.
• Well versed in analyzing Results, Bug Tracking & Reporting, Detailed status reporting
• Good knowledge on Test Coverage Analysis and Ability to mentor teams to meet the deadlines.

TECHNICAL SKILLS:

Testing Tools: Quality Center 10.0, ALM, Win Runner, Quick Test Pro, Rational Suite (Clear Case, Clear Quest, PVCS Bug Tracking Tool) Compuware Tools (Team Track, Track Record).

Web Technology: HTML4, JavaScript, VB Script.

GUI Tools: Visual Basic, Developer 2000, Crystal Reports.

Databases & RDBMS: Oracle, MS Access, DB2, SQL Server, Teradata, Big Data

Operating Systems: Windows (98/2000/2003 NT/XP) and UNIX, Linux.

ETL & Reporting tools: Informatica, Business Objects, SAS, SAS EG

Languages: C, C++, SQL, PL/SQL, ASP.NET

STRENGTHS:

• Ability to understand Functional and Software Requirements Specification documents.
• Proficient in Manual (System, Black Box) & Automation testing.
• Excellent ability to manage resources in mission critical, high-pressure projects.
• Specific expertise in writing Functional, Integration and System Test cases

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SAS QA Analyst

Responsibilities:

• Involved in Testing of client server SAS based software for SAS NPV Modeling Application.
• Collaborating with business and Business Technology partners to determine business quality objectives and Involvement in understanding the requirements with business
• Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology.
• Participated in Sprint Planning meetings where the Testers will identify the strategic features of the user stories and review the current sprint user stories that are in business requirement during the Sprint Planning and Acceptance criteria for Testing will be documented.
• Performed functional, performance and regression testing in UNIX environment on command line using SAS based macros to validated and compare the datasets.
• Participated in daily scrum meetings where all the testers will address any blockers blocking testing and discuss the status of assigned tasks.
• Performed testing on GUI also in UNIX environment by running the jobs in backend and compare the both results.
• Validated the results and logged defects in ALM (QC) if there is any discrepancies.
• Design, implement, execute and evaluate wide range of SAS systems and integration tests and ensure software systems and services meet minimum standard against defined functional and nonfunctional requirements.
• ETL testing for Data Profiling and BI Reporting system
• Running the jobs/Workflows for ETL process
• Prepared and ran sql queries to verify Dimensional and Fact tab les.
• Experience in ETL/Manual testing on windows/Linux environment. Experience in preparing/reviewing/executing test cases, defect logging/tracking/analysis.
• Prepared test data for functional & Integration testing.
• Expertise in ETL/DWH testing concepts, TOAD, Base SAS concepts
• Executed test cases, test scripts manually and also using automated tool Quickest Professional.
• Analyze System documentation e.g. Requirement, Interface Specifications, Design etc.
• Work with Development and System Analyst to define test scenarios.
• Created Test Scenarios and Test Cases in ALM.
• Reviewed and logged new defects using ALM during the Regression Testing.
• Created automated test scripts for testing using Quick Test Pro.
• Performed Regression Testing by executing the scripts with Quick Test Pro.
• Performed Functional testing to ensure that software requirement specified Standards and end user requirements.
• Accountable for test status and participate and report statuses in all test related team meetings.
• Manage Defect Reporting Process and Collaborate with developers as needed to isolate root cause of defects.

Environment: SAS 9.3, SAS EG 5.1, UNIX, LINUX, VI Editor, HP ALM 11.50, SAS Add-in Microsoft office, Windows SAS, SAS Management Console, BO Professional Edition Reflection X FTP, WINSCP FTP, MS SQL, SAS/ACCESS,SAS Macro.

Confidential, Fairfield, NJ

Sr.QA Analyst

Responsibilities:

• Reviewing the Business Specifications Documents, Attending Specification review meetings.
• Analyzed Business Requirement document and prepared Test cases for Unit Level, Functional and Integration Testing.
• Developed test cases in Quality Center using the functional specifications in Doors.
• Identify the source tables from which the Data Warehouse extracts data
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Verifying the data in target database by ETL process. Verified column mapping between source and target
• Involved in identifying the risks and issues.
• Co-coordinating with offshore team by assigning everyday task and reviewing the project status.
• Attending weekly status meetings and updating weekly status reports using MS One Note.
• Reviewed and logged new defects using Quality Center during the Regression Testing.
• Writing test cases and reviewing test cases written by offshore team on various projects in Quality Center.
• Communicating with business team on change controls and specification changes and updating Test cases accordingly.
• Performed functional and backend testing by executing the SQL queries.
• Regression testing was performed on new version and on any new changes done by the business partner.
• Worked with developers to rectify the defects and the fixes the defects.

Environment: HP Quality Center 10.0, VBScript, Java, Visual Elk, SQL Server 2005, Doors, MS Excel2007, MS Project2000, and Windows 7: Oracle 10g.

Confidential, New York

Business/ QA Analyst

Responsibilities:

• Analyzed functional requirement documents and business requirement documents and decided which part of application has to be tested manually and which part has to be tested using Automation tool. .
• Performing business analysis for financial execution by risk & key channels and associated sub-sectors that will be utilized to notify future investment conclusions.
• Identify areas where Risk and Compliance controls are lacking and implement strong controls.
• Perform analytical services as part of lending team
• Prepared reports of Compliance check over the Business Process Improvement.
• Involved in International transaction monitoring and investigated the about the beneficiary companies and created their profiles in consumer banking.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Identified defects, reported and documented them using ALM.
• Involved in various phases of testing like development testing, System and Integration testing, Component level testing and User Accepting Testing.
• Implement the new features of the IT system (technical design)
• Technical Recommendation and Testing Co-ordinate testing efforts with QA
• Ensures issues are identified, tracked, reported on and resolved in a timely manner.
• Works with client personnel to identify required changes.
• Takes input from supervisor and appropriately and accurately applies comments/feedback.
• Consistently delivers high quality services to our clients.

Environment: Oracle 8i, ALM, Windows 2000,2003 advanced Server, XP, HTML, JAVA, VB Script, SQL, VB, Oracle9i, Visual SourceSafe.

Confidential, Parsippany, NJ

QA Analyst

Responsibilities:

• Analyzed the Business and System requirements for various modules of the application.
• Created Test plan template, Test Design and responsible for implementation of Test cases as automated test scripts.
• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Analyzed the source data coming from Oracle, Flat Files, and MS Excel coordinated with data warehouse team in developing Dimensional Model.
• Experience with Quality Center including administration, requirements, test planning/design, test lab/execution (i.e. Creating and executing complex test sets), and defect tracking.
• Quality Center customization of the Requirements, Test Plan, Test Lab, and Defects modules.
• Involved in writing Test Plan and Testing Strategy.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• Tested data warehouse objects - Fact tables, dimension tables, and association tables.
• Co-Ordinated with an offshore team to develop the application as per requirement.
• Worked very closely with developers to recreate defects found and also to verify fixes.

Environment: Quality Center, Quick Test Pro, Informatica8.6, Win 2000, JAVA, HTML, Java script, VBScript, SQL, Unix