SUMMARY:

• 9+ years of Experience as a Software application tester in Mortgage, Financial and Telecom sector
• Worked on Test Management Tools, Support Central (Defect Tracking) and Quality Center.
• Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control for many ETL, BI and Web Applications.
• Experience in both Agile and Waterfall development methodologies.
• Worked in all phases of Black Box and White Box testing of the Application beginning from the preparation of Test Plan, Test Cases and Test Scripts. Worked in important phases of Testing Life Cycle like Unit Testing, Integration Testing, Regression Testing, Business Functionality Testing, System Testing, Regression Testing and Load testing.
• Extensive experience in writing Test Plans, Test Cases and Test Scripts for Manual & Automated testing.
• Experience in writing SQL queries, generating reports to ensure data integrity and validating business rules.
• Expert in writing SQL queries for several databases including Oracle10g, SQL Server 2008, DB2 and Teradata.
• Expert in ETL and BI testing and worked with many ETL tools like Informatica, Data Stage, SSIS, Ab Initio, and few BI tools like Business Object, crystal reports,Cognos, & OBIEE on large scale applications.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Extensive experience in defect management, status presentation and test data preparation.
• Complete expertise in system integration, data consolidation and data migration between vendor's and client's legacy applications
• Extensive experience in creating, modifying XML files for Web services testing using tools like XMLSPY and SOAPUI.
• Experience in testing UI rich web applications both manually and through automation using selenium / Java / Cucumber /Gherkin api’s.
• Ability to prioritize multiple tasks while meeting deadlines.
• Strong Problem Analysis & Resolution skills and ability to work in Multi - Platform Environments like Windows and UNIX.
• Strong communication, technical and interpersonal skills and works well in a team environment as well as individually. Ability to work across organizational boundaries has been a trademark of my ability to accomplish project goals on schedule.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, Shell Scripting, C, C++

Database Systems: Oracle, DB2, Sybase, Teradata, Netezza, Microsoft SQL Server,MS Access

Data Warehousing: Informatica, SSIS, Data Stage, Ab Initio, Business Objects, Cognos,Crystal Reports

Testing Tools: HP (Quality Center(ALM), Win Runner, Load Runner, Test Director),IBM Test Manager, IBM Requisite pro, IBM Clear Quest, DOORS.

Other Tools: TOAD, WinSQL, Data mover, Rapid SQL, Text Pad, Ultra Editor, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Loan Product Advisor

• Actively participated in complete software lifecycle of requirements gathering, analysis, design, development and testing of the project using Agile Software Development methodology.
• Worked with business team to ensure requirements are understood and implemented according to business specifications / process.
• Skilled in analyzing business process flows and requirements for UAT testing purposes.
• Developed test scenarios based on business process models.
• Develop, review and maintain test plans, test cases and test scripts from requirement documentation, technical specification documentation and/or business scenarios.
• Develop/Execute tests for various LP Access methods like LPO (Loan Prospector Outreach), LP com, S2S, W2W, D2W and LP Inside.
• Responsible for testing Automatic Order of VOI (Verification of Income) for Pilot Customers.
• Responsible for Verifying error messages based on data received from BCVS and Checking the connectivity from LPA to BCVS income service through feedback certificate.
• Verified the EDS calculated values to LPA to be displayed on the feedback certificate and feedback messages.
• Responsible for End to End testing for Income Verification with LPA, EVS, BCVS and EDS.
• Responsible for Integration testing across LPA, LQA, Selling and LCVA systems.
• Develop regression test scripts based on potential impact of new functionality or changes.
• Execute tests, document test results, perform analysis on results and identify potential impacts.
• Provide management with reports on problem resolutions and test progress.
• Partner with other IT staff in working through issues/defects and resolution.
• Responsible for overall testing completion metrics & analysis, as well as status read-outs to upper management.
• Ensuring testing is completed within established timeframes and that objectives conform to the user requirements.
• Effectively communicate issues and concerns to appropriate parties based on analysis and defects.

Environment: HP ALM 11.53, UNIX, Version1, Doors, Rapid SQL, Soap UI, XML spy

Confidential, Herndon, VA

Sr. QA Analyst

• Actively participated in complete software lifecycle of requirements gathering, analysis, design, development and testing of the project using Agile Software Development methodology.
• Worked with business team to ensure requirements are understood and implemented according to specifications.
• Developed test scenarios as per business rules defined in functional and non-functional requirements.
• Created Test Cases, Test Data and Test Scripts as per business requirements.
• Performed backend testing to validate the data writing SQL queries in Oracle using toad.
• Involved creating the End to End test scenarios and execution.
• Involved in testing with web services using Soap UI.
• Validated the schema for the input mismo files and CLDF by using xml spy.
• Used Tibco/Gems tool to monitor live messages on queues, topics which helps to validate the intermediate process like LD event and LDO event.
• Validated business rules/edits coming back from BRO/CBRS.
• Executed batch jobs in Unix and verified Event log file for testing and debugging.
• Validated direct seller, sub servicer and service bureau functionality using various user roles like direct seller, third party access.
• Validated EU components of LDNG system both internal and external to LDNG like Geocoder, Address enrichment service, Appraisal Matching Service, Limits service, SSN.
• Verified the Basic and Advanced search, export capabilities and the capability to print or export search results and reports to PDF/XLS/CSV files.
• Generated the RTM by mapping all the requirements in the Quality Center that are loaded from DOORS.
• Executed the batch jobs in the unix environment to load the data from source systems.
• Performed all UI screens validations and data flow between screens that are match with the backend.
• Experienced in test automation using cucumber, Gherkin, Selenium Web Driver.
• Worked on the batch job failures by tracing the log files and resolved the issues
• Demonstrated the application to end users and business team
• Generated the test metrics and addressed the progress of the project in the daily status meetings.

Environment: HP ALM 11.53, Oracle, Sybase, UNIX, Rally, Doors, Toad, Rapid SQL, GEMS, XML spy

Confidential, McLean, VA

Sr. SQL Developer / Tester

• As a member of the Scrum team participated in daily standup meetings, project status meetings as well as retrospective meetings and iteration reviews.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Worked on SQL *Loader to load data from flat files obtained from various facilities every day.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used SQL *Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Generate SQL Scripts and create views for reports.
• Used Toad to Extract and test the data in the database.
• Responsible in coding and debugging views.
• Performed smoke, functional and regression testing on SIT, UAT and PROD environments.
• Involved in system integration and user acceptance testing (UAT).
• Involved in Preparation of test cases using ALM, test scripts and Smoke testing of Application.
• Develop test scenarios based on business process flows.
• Performed Data preparation activities to support testing.
• Worked with business area representatives to perform SIT / UAT.
• Verified web based access controlled by user roles, authorizing views and tasks within the solution under specific rules.
• Verified the selling rep and warrant sunset dates based on the EDS rules.
• Verified the Basic and Advanced search capabilities and the capability to print or export search results and reports to PDF/XLS/CSV files.
• Verified the user capability to view detailed audit history of loan R&W data based on events
• Created or modified test data to be used for validation.
• Created traceability matrices, test and bug reports and other test related documents.
• Participate in meetings with UAT team and stakeholders to review project planning, status, and issue discussion.
• Took an active role in static testing activities such as design review and requirements inspections to identify ambiguity and inconsistency in requirements.
• Involved in front-end (GUI) testing which is developed in Java, back-end (DB2 Database) and data validation testing of the application.
• Performed ETL testing with source system as CDW and Target as LCI with all the transformations.
• Reviewed the test cases written for integration and functional testing as per the scenarios created.
• Developed complex SQL queries during End-to-End testing stage.
• Performed Backend Testing using complicated SQL Queries and to test the application with huge volume of data from different systems like CDW, EDS and LCI.
• Involved in web services testing Using Soap UI and XMLSPY.
• Involved in creating XML files for testing the rules against EDS system.
• Ran batch jobs to generate internal and external events and verified logs in case of event failure.
• Coordinated and guided the automation test team by providing sql for automating the Regression Suite.
• Report testing results and issues in a timely and accurate manner.
• Conduct root cause analysis of identified defects, providing development/business partners with sufficient detail to understand, replicate and resolve.

Environment: HP Quality Center 10.0, Data stage, DB2, UNIX, Rational Clear Quest, Doors, JIRA, Oracle 8i

Confidential, Ashburn, VA

QA / Data Analyst

• Involved in analyzing Business requirements and is responsible for the planning execution and tracking of Integration and User Acceptance testing.
• Responsible for SIT project planning like creating testing scenarios, test plans and test scripts.
• Handle the tasks of explaining SIT scope, criteria and entry/exit strategy.
• Perform responsibilities of conducting research on IT requirements and business requirements in UAT areas.
• Environment set up and loading the reference data accordingly.
• Created test plan and executed test cases.
• Used Generic TPT Tool to stage the data from flat files into Teradata database and extracting the data from Database to flat files to send to downstream systems.
• Used Data stage to stage and parse the data from biller’s flat files to Teradata Database and scheduled the cron to run the UNIX scripts.
• Familiar using different parallel job stages such as Join, Merge, Lookup, Remove Duplicates, Copy, Filter, Funnel, Dataset, Change Captured, Modify, and Aggregator.
• Extensively used Teradata utilities like Fast Export and MLoad.
• Designed and developed various jobs for scheduling and running jobs under job sequencer and Data stage Director.
• Modifying and moving the configuration files, parm files, UNIX shell scripts as needed from CVS to Test Environment.
• Coordinating with interfacing teams for test files, environment setup, test case execution and for required mappings.
• Interface Testing to make sure that the files meets the requirements and load into VZBDW.
• Write and execute complex SQL queries to validate actual test results match expected results.
• Debugging the SQL-Statements and stored procedures.
• Debugging the Unix Shell scripts and logs in the Data stage Director and reporting the same in QC.
• Running the Data stage sequencers to send the required data from views to flat files and automatically sftped to SRDM, RACE etc.
• Performed backend testing using SQL queries and verified data integrity. Developed regression test scripts for the application
• Responsible for metrics gathering, analysis and reporting.
• Conducted review sessions on test case and regression test scripts in quality center.
• Lead the team in offshore to do spec reviews, test case writing, running tests, logging bugs, and communicating issues. Got hands on when / where needed.
• Reported bugs using Quality Center and generated the defect reports for review.
• Defect reporting and tracking was also done using Quality Center and Maintained the test traceability matrix.
• Performance tuning of views, sql queries and stored procedures, functions.
• Tested stored procedures for transforming and loading of data according to the business requirements.
• Monitoring the process in viewpoint and running stats for the spool space issues.

Environment: Quality Center 10.0, Data stage, Teradata V2R6, Oracle 10g, UNIX, Mainframes, Rational Clear Quest, Data Mover.

Confidential, Providence, RI

DWH/Reports Tester

• Prepared extensive set of validation test cases to verify the data based on the business process flows.
• Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
• Studied and understood the Data warehouses, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects.
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Involved Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems.
• Execute and analyze complex test cases and compare the results with expected results and product requirements.
• Performed Regression Testing of the affected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build.
• Written several SQL statements. Tested the output of Statements from sql vs. ETL output.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Queried databases using SQL queries in TOAD, SQL Server Management Studio,Aqua Data Studio to validate the data loaded into target tables.
• Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications.
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Study of detailed requirement of end users of system & their expectations from Applications.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Experience in loading from various data sources like Teradata, Fixed Width and Delimited Flat Files.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Involved in extensive DATA validation using SQL queries and back-end testing .
• Responsible for developing UAT test process and monitoring SIT execution phases.
• Familiar with Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis).
• Familiar with Use of filters, conditions, calculations, etc.
• Familiar with Creating Drill Down, Sub Report, formulas, charts in crystal reports.
• Created hyperlinks to link between reports.
• Testing the existing B.O. reports, scheduler and security functionality with multiple profiles.
• Excellent knowledge of Data Warehouse concepts, Star schema and Snowflake Schema, Fact table, Dimension tables.
• Writing Custom SQL for reports performance.
• QA the result sets and validate with the end users.

Environment: Quality Center 10.0, Business Objects XIR3, Oracle 10g, Data stage, Teradata V2R6, DB2, UNIX, Microsoft Access, Auto sys.

Confidential, Jersey City, New Jersey

DWH QA

• Involved as a key member of project teams through all phases of realization, go-live, rollout, post Implementation support, maintains and services of Quality Assurance and Development jobs.
• Write and execute complex SQL queries to validate actual test results match expected results.
• Loaded the extracted data into database through UNIX.
• Validated the source and target data count.
• Debugging the SQL-Statements and stored procedures
• Developed regression test scripts for the application
• Performed backend testing using SQL queries and verified data integrity
• Involved in metrics gathering, analysis and reporting to concerned team
• Tested the Oracle PL/SQL testing programs
• Conducted review sessions on test case and regression test scripts in quality center
• Tested several data validation graphs developed in Ab Initio environment.
• Worked with all kinds of components with Ab Initio including Dedup, Denormalize, Normalize, Rollup Tested Target Load Order Plan and Constraint based loading for loading data correctly into different Target.
• Tested the business rules into technical specifications for ETL process for populating Fact and Dimension table
• Prepared the test data for various source systems and to test the ETL transformation rules
• Performed document, code reviews on all documents and code related to ETL, giving feedback where useful.
• Lead the team in offshore to do spec reviews, test case writing, running tests, logging bugs, and communicating issues. Got hands on when / where needed.
• Worked on data loading (ETL) from Oracle and Flat Files to D.W.H using Work-flow Monitor.
• Tested universes for supporting ad hoc queries and Invoice reports according to business requiremen
• Tested Business Intelligence reports in form of Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula's etc.2-D, 3-D Column, Line, Area and Pie charts.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Tested Simple reports Accounts by Category, Accounts by Products, Leads to Opportunities by Category, Opportunities by Product, Summary Quote, Print Quote Report, Service Request, Assets and leads report.
• Tested Master-Detail Reports, Cascade Reports, Summary Reports, Standard and Adhoc reports.
• Tested Reports as per the user requirements like Calculations, Variables, Break points, Drill down, Slice and Dice and Alerts for creating Business Objects reports.

Environment: Oracle 9i, SQL, PL/SQL, Support Central, Load Runner 8, IE 6, Business Object 6.5 / XI R2,Ab Initio, Unix, Quality Center 9.2 and Microsoft WAPT 3.5 and Install WatchPro 2.0