SUMMARY

• Business Analysis, Data Analysis, Requirements Management, Data Mapping, UAT & System Test effort of Secondary Mortgage and Financial Industry.
• 9 years of experience in SDLC (software development life cycle), Business Analysis, Design, Software Quality Assurance (Frontend/ Backend), and UAT of Client Server and Web Applications following Waterfall and Agile development models.
• Certified Agilent. (SAFe Certification). Also Rational Certified Tester.
• Strong knowledge and background managing SDLC & Business processes.
• Well versed with all tools and technology those are used in projects & change management of Confidential and Confidential . (Rational Requisite Pro, DOORS, HPQC/ALM, Relational DB).
• Strong background in using established procedures to document instructions. Work with Stakeholders, End - Clients, SMEs and DBA for gathering and documenting Business Requirements, Business Rules documentation and Functional Requirements, Data Requirements/Mapping documentation, Business Data Dictionary updates, and Performance Requirements. Use Visio to create use case diagrams. Participate in architectural design review. Analyze Entity Relationship diagram, Schema diagram, Logical Data Models. Experience in generating and reporting data analytic reports.
• Work towards resolving data anomalies, which include missing data, corrupted data, incorrect mapped data, truncated data, and redundant data. Other types of data validations include table structure, property validation, cardinality ratio, NULLS, table’s comparison, and Integrity. Some examples of data validation in Selling/Servicing System, Underwriting Applications include aggregate figures such as loan UPB validation, LTV calculation, Cash loan data, servicer’s data about investor reporting, Interest Rate validation, Collateral Remaining Term computations etc.
• Rational Suite Enterprise Tools (RequisitePro, and ClearQuest).
• Strong background in writing Complex Test Plans, RTM (Requirement Traceability Matrix), Test Cases, and Test Scripts, and Test Summary Report.
• Outstanding listening skills. Proficient with White Box, Black Box methodologies.
• Adhere to established standards and processes/procedures for UAT.
• Strong analytical and clear/concise documentation capabilities to meet client expectations.
• Self-starter, self-motivated, excellent professional, attention to detail, communication, verbal, problem solving, documentation, and interpersonal skills.

PROFESSIONAL EXPERIENCE

Confidential, Mclean, VA

Sr. Business/Data Analyst

Responsibilities:

• Coordinate with all teams for Business Requirements, Functional Specifications, Use Case and Data Model Diagrams.
• Work collaboratively with project teams for UAT/Data quality testing of various applications.
• Query database to validate the data mapping correctness as per the data mapping requirements.
• Submit user-request for DCR (Data change request) including details about what is wrong in the production data, and with justification what change is needed.
• Review and approve received data change requests. Validate justification, criteria, basis, application, and documentation of received requests.
• Perform quarterly internal audit for randomly identified DCRs. (Control 117).
• Contribute in data attestation control process and log issues in ClearQuest as per identified outliers. Assign CQ issues to Pricing or other responsible teams for the resolution.
• Participate in UAT test cases, Requirements, and Test plan peer review sessions. Perform UAT and Data Quality tests.
• Ensure up-to-date UAT documentation and reference documentation for team review in local/network repository or at SharePoint.
• Day to day facilitating and consulting with technology and business team members to clarify any requirement or testing issues.
• Provide regular status updates to Manager.
• Schedule (audio/video) meetings by using Outlook for review, triage/resolution of any identified issues or for peer review sessions.
• Work closely with key project team members and ensure compliance with laid down standards and procedures. Interact and coordinate with Stakeholders, Business Process Owners and business subject matter experts.
• Provide LOE; ensure smooth operation, coordination, in a timely fashion. Provide feedback to supervisor.
• Escalate any perceived or legitimate issues on time (as appropriate) to the supervisor.

Environment: Data Quality, DCRs, Audit, Project Management, Change Management, Planning, Automated Testing, MS Office, Excel, ACCESS, SQL, Oracle, IE 9.0, Rapid SQL, HPQC/ALM.

Confidential, Annapolis, MD

Sr. Business Analyst/UAT

Responsibilities:

• Work collaboratively with internal and external stakeholders, business teams, technology teams for managing business requirements and project management.
• Participate in business requirements review sessions with stake holders, create business cases. Gather and perform gap-analysis as per project needs.
• Participate in IT change review board meeting to discuss change in scope, impact assessments, issue logs review, LOEs.
• Coordinate and ensure cooperative efforts with technology and business teams for refinement and listing of test cases/scenarios. Ensure documentation of Requirements and test case in HPQC/ALM.
• Arrange for peer-review sessions (for Requirements, Test Plan, RTM, Test cases) as needed so that everyone in the project especially stakeholders gets familiar with the updates from time to time.
• Work closely with supervisor/manager for management & prioritization of multiple tasks and projects.
• Ensure up-to-date business requirements, functional requirements, use cases, specifications documentation and reference documentation for team review in local/network repository or at SharePoint.
• Work on data mapping documentation, identify boundary values, edge conditions for business rules, positive and negative scenarios. Identify business cases those can be used by technology teams for validation of functionality and rules i.e when a rule should trigger and also when it should not etc.
• Day to day facilitating and consulting with technology and business team members to clarify any requirement or testing issues.
• Provide regular status updates to Manager about status of Requirements management and UAT.
• Schedule (audio/video) meetings by using Outlook for review, triage/resolution of any identified issues.
• Coordinate with development/technology teams for resolution of any requirement issues.
• Work closely with key project team members and ensure compliance with laid down standards and procedures. Interact and coordinate with Stakeholders, Business Process Owners and business subject matter experts.
• Provide LOE, ensure smooth operation, coordination, in a timely fashion. Provide feedback to supervisor.
• Escalate any perceived or legitimate issues on time (as appropriate) to the supervisor.

Environment: Business Requirements, Visio, Project Management, Change Management, Scheduling, Risk Management, Planning, Automated Testing, DOORS, QTP 12, MS Project, MS Office, Excel, ACCESS, SQL, Oracle, IE 9.0, TOAD, UNIX, HPQC/ALM.

Confidential, Washington, DC

Sr. UAT/BA Analyst

Responsibilities:

• Take lead in providing initial draft of Project Management Work Plan. Provide timely updates for change management.
• Participate in CRB meetings. Approve change procedures. Schedule team meetings to discuss change in scope, impact assessments, LOEs, additional budget plans.
• Act as primary POC for UAT (User Acceptance Testing) and analyze business requirements and functional specifications for the application. Assist in requirement review session, gathering and analysis as per project needs.
• Provide project guidance and necessary assistance to team members and other contractors on the project.
• Write Test Plan with clear definition of Entrance and Exit criteria, scope, and strategy details.
• Accountable to develop test plan and test cases/scenarios. Document Requirements and tests in HPQC.
• Test cases creation to cover boundary values for rules based testing, positive, negative scenarios. Create test data to test boundary values i.e. condition when a rule should trigger and also when it should not etc.
• Day to day consulting with business and development team members to clarify any requirement or testing issues.
• Work with team members and ensure timely and successful completion of UAT planning, organization and execution.
• Write test cases; develop test scripts as needed. Manage documentation and provide status reports to supervisor on daily/weekly basis. These status reports include test execution status, and defect status reports.
• Self-starter and work independently while driving and managing assignments from concept through deployment/launch.
• Perform database queries to research and perform the business functions, validation and Risk Rating reports generation.
• Participate in internal review of test case sessions for status and improvements.
• Perform vlookup, and other data sorting, filtering functions, formulas for data validation in Excel, and Access.
• Validate, document and represent test results. Save results in HPQC.
• Coordinate with the development team for test execution and collecting test evidences/artifacts.
• Work closely with all project team members and contribute as needed ELSIF/SDLC documentation in all important areas.
• Maintain documentation as per SDLC and application development controls and oversight.
• Ensure proper documentation of Test Strategy, Test cases, Test results, and Defects Summary.
• Ensure smooth operation services including any needed research, coordination, and feedback to business team members and to the management. Provide LOE to supervisor as and whenever needed.
• Escalate any perceived or legitimate issues on time (as appropriate) to the supervisor.

Environment: Project Management, budgeting, Hyperion/Excel graphs and reports, MS Project Manager, Altova XML Spy, Excel, ACCESS, SQL, IE 7.0, TOAD, UNIX, HPQC10.

Confidential, Mclean, VA

Sr. Business Analyst / Sr. UAT & Data Analyst

Responsibilities:

• Analyze business requirements document and technical specifications of UCDP application. Coordinate effectively with multiple diverse groups and divisions.
• Review detailed specifications of application and design specification document.
• Write Test Plan with clear definition of Entrance and Exit criteria, scope, and strategy details.
• Work with requirement tools Requisite Pro, DOORS, and defect management tool Clear Quest, and Quality Center.
• Write test cases; develop test script, which include coverage of test scenarios, and document for execution in Quality Center.
• Validate and verify system behavior in conformance with requirements.
• Participate in internal review sessions of test cases for improvements.
• Day-to-day consulting with fellow team members and third-party vendor.
• Fluently perform vlookup, and other complex data sorting, filtering functions, formulas for data validation in Excel.
• Very strong in data validations using SQL from Oracle and Sybase databases. Perform Insert, Update queries as needed. Queries include joins, aggregate functions.
• Perform UAT testing of migrated application in appropriate testing environment i.e. in acceptance.
• Scrub, populate and prepare loan test data information and create candidate XML data using XML Spy to simulate Test Scenarios for validation.
• Document test results in Test Lab of QC, provide report to management as needed.
• Mentor and provide assistance to less experienced staff as needed.
• Perform evaluation of testing methodology and testing tools and make recommendation for adopting new tools.
• Work closely with the technology and business Project Manager to ensure project documents are complete, current, and stored appropriately at appropriate repositories.
• Assist in creation of test documentation such as test summary report, defect (test-incident) report for sign-offs.
• As needed for business scenarios perform data engineering to create test data comprising of 1000s of records in flat files, xml, CSV, and export/import into the test database.
• Perform data import using SAS program from CDW (FreddieMac Corporate Data Warehouse). Import data in SQL Server and generate reconciliation reports for 15 banks.
• Escalate any perceived or legitimate issues on time (as appropriate) to the supervisor.

Environment: Manual, Automated Testing, Altova XML Spy, Java, TOAD, FireFox 2, J2EE, PL/SQL, IE 7.0, QTP 9.2, Windows XP, QTP, Netscape 7.0, and UNIX.

Confidential, Herndon, VA

Sr. Test Engineer (Sr. Business Analyst, UAT)

Responsibilities:

• Reviewed Business Requirements document with the business and development team to understand the architecture and functionality of the application. Developed test strategy for functional and non-functional requirements.
• Prepared Test Plan; with focus on overall test strategy, scope, schedule, entrance, exit criteria, risks, and mitigation strategy etc details.
• Performed security testing. Created test data for internal and external user. Managed user Ids.
• Performed application, and user access control tests.
• Requested for any kind of Tool or Technology resources before start of testing.
• Requested access as appropriate for SharePoint, and shared drive to access centralized documentation.
• Manage assigned efforts through the use of standard project management tools such as Project Manager, including project work plans, issue logs, budget tools and the reporting and facilitation of appropriate and effective meetings.
• Request test ids, and prepare test data.
• Participated in Peer-Review session for RTM. Work well with other team members including participation from Development, and Business team members.
• Worked on assigned test cases writing/scripting deliverables and milestone.
• Provided day-to-day progress in test cases writing task to the test lead.
• Prepared strategy and test data and performed penetration testing of the product.
• Once test execution began, provided daily test execution report, and defect status report to test lead.
• Tracked and generated day-to-day execution progress report from Quality Center.
• Tracked and generated day-to-day defects resolution progress report from Quality Center.
• Attend/Participated in defect resolution meetings along with development team.
• Constantly stayed in touch with team about test progress.
• Ensured smooth conduct of test. Validated fixed income, assets pricing.
• Used internal reviews, training sessions to ensure multi-skilling and cross training among testing team members.
• Prepared Test Summary Report. Obtained testing team feedback by performing internal review.
• Quickly learned high level business and system methodologies and processes.
• Obtained approval on Test Summary Report.
• Served as POC to provide any needed assistance such as shakeout test during Production deployment.
• Worked with team lead, stakeholders on the assigned project.
• Identified pain points and areas of improvement around the test practice in general, and proposed solutions.
• Used Rapid SQL and TOAD for Oracle database testing.
• Mentored team members regarding testing process, and procedures.
• Coordinated with Development, and Business teams for smooth testing progress in the project.

Environment: Automated Test using Pathfinder, DOORS, Test Manager, Manual Testing, Java, TOAD, J2EE, JavaScript, System Testing, PL/SQL, IE 7.0, QTP 9.2, Windows XP, and UNIX.

Confidential, Rockville, MD

Sr. System Test Analyst

Responsibilities:

• Acted as POC and UAT Subject Matter Expert. Reviewed the Business Requirements document to understand the architecture and functionality of the application.
• Prepared Test Plan for different modules.
• Created RTM. Arranged Peer-Review session for RTM.
• Performed change impact assessments, process documentation and other related materials.
• Documented test cases and scripts for various screens of the application, in the Quality Center. Arranged Peer-Review session for Test cases.
• Provided day-to-day execution status, and defect resolution status feed back to the UAT lead and to various types of audiences.
• Ensure the availability of all needed resources to carry out their assigned tasks independently.
• Ensure the creation of test data for UAT.
• Created test scripts, and Batch tests, verifying the Test results and reporting the defects using Clear Quest, as well as Quality Center.
• Written SQL, PL/SQL queries in TOAD, as well as PL/SQL Developer. Queries included select statements, sub-queries, joins, and aggregate functions for data validation.
• Executed UNIX commands to perform file and directory operations.
• Used design documents reference such as ERD, Data Dictionary, and Data Flow Diagrams for data analysis.
• Ensured tactful communication and coordination for any difficult or sensitive information.
• Created XML files in XML SPY, and validating against XSD as per provided SOA standards.
• Worked on Agile release using SCRUM test methodology. Requirements were presented as User Stories.
• Responsible for Regression testing after bug fixes and verification of the fixes.
• Performed Content Management Test for Financial Member regulation website for members and examiners.
• Accomplished tasks and performed Business functionality testing, this involved testing of all core functions of the application.
• Used QTP 9.2 for executing automated test scripts creation of test data in application STAR.
• Provided coordination/assistance with test data planning, creation, and test cases for UAT.
• Generated weekly Execution status report, and defect status report from Quality Center.
• Participated in Enhancements and status review meetings.

Environment: Manual Testing, Java, TOAD, SQL Developer, J2EE, JavaScript, MQ, ESB, Beta Testing, PL/SQL, IE 7.0, QTP 9.2, HTTP, Windows XP, SoapUI, JAWS, Netscape 7.0, UNIX

Confidential, Washington, D.C.

Business Analyst, UAT Tester

Responsibilities:

• Reviewed the Project/Business Requirements, and Business/Functional Specifications of AUT (Application under Test) to understand the architecture and functionality of the Application. Perform gap analysis, and derive testable deliverables from Requirements. Worked with various requirement management tools such as DOORS, and REQUISITEPRO.
• Defined overall Test Scope, Test Strategy, Entrance, Exit Criteria, Risk, and mitigation Strategy, Defects Resolution Criteria, as part of Test Planning.
• Analyzed logic pseudo-code, design, review, and execute strategy as per test plans.
• Performed review of system development life cycle methodologies.
• Contributed and participated in documentation of all test deliverables.
• Created test data for System, Acceptance, and Integration Tests. Coordinate with Test Lead, DBA, and Development team for test data preparation, as necessary.
• Created and maintained required QA deliverables - Test Plan, RTM, Test Schedule, Scripts and produce Metrics as per ISS Standards and report on test progress. Participate in cross-functional team/peer review meetings to ensure mapping between test cases, and requirements.
• During Multifamily Projects, tested Syndicator Dashboard, and EBMS Applications for (For Sale/For Rent) Templates Upload, Process Validation, Business Rules Validation related to Sifting of Assets, and Risk Rating Validation of Assets, as per defined weightage, and Factors/Sub Factors calculation.
• Tested high number of Equity Business Management Systems/Finance - Business Objects Reports. (Accuracy, Completeness, Aggregation, and calculated data display in Reports, Formatting of Report, Etc).
• Some examples of GUI tests include testing of User authentication/Login, security testing, Navigation, Menu drop downs, hyperlinks, text fields boundary testing, boundary value analysis, scroll bars, buttons, sorting of data in GUI, and Business Rules/Edits validation as per specific calculations.
• Coordinated with Development, DBA, and Business teams, to overcome issues related to Data migration, mapping of data in Reports, and defects resolution.
• Created and provided complete set of QA documentation to the Supervisor/Lead, as per defined standards.
• Performed Shakeout/Smoke test after first/initial build deployment, to assess stability of the deployed application/build.
• Performed system testing, using Front-end Testing and Back-end testing. Execute the Test Scripts and Validate the Actual Results against the Expected Results. Document overall Test Effort in Quality Center 9.0.
• Performed File/Directory UNIX commands, Execute UNIX Shell Script, validate data processing in the downstream systems using various UNIX commands for the MBS Loan test data. Work on C Shell and Bash Shell.
• Tested Backend tables and views for GUI transactions such as SAVE or UPDATE. Validate newly created backend tables for table structure, Primary Keys, Grants, and Indexes. Perform SQL Queries using Aggregate functions, and INNER/OUTER Joins.
• Participated in Performance Testing Effort, used Load Runner 9.0, LoadRunner/VUGen, Analyzer, and Controller having license for 25 concurrent Users. Deliverables include creating Performance Test Plan, Coordinate with Development, DBA, and Support team for collection and analysis of Usage, and System statistics. Identification of peak load hours, and emulating virtual user test scenarios to match production. Test planning for single user, and concurrent user tests. Manage run-time settings, Correlation, Tests execution, participate in joint reviews and analysis with Developer, DBA, and Support team to analyze captured response times, and server side statistics. Use Analyzer for recording and analysis of network Response time, load and concurrent virtual users statistics.
• Coded VB Script for automating Functional Tests using QTP.
• Executed DB2 SQLs using SPUFI.
• Provided test data support, test scripts reference, and any requested coordination to Business Liaisons/testers during UAT (User Acceptance Testing).
• Managed Defects using Rational Clear Quest, and Mercury’s Quality Center.
• Analyzed results of test execution and document defects in Clear Quest if expected results are not achieved retest once fix has been deployed and close defects once fix has been validated. Categorize bugs based on severity and interface with developers to resolve them.
• Participated in coordination and status review meetings with Development, and Business Teams.

Environment: Manual Testing, Automation, LoadRunner 9.0, QTP 9.2, PL/SQL, Oracle 10g, Sybase, UNIX Environment, Java, J2EE, JavaScript, Informatica, Ab initio, ClearCase, XML, IE 7.0, Windows 2003, XP, Weka, WebSphere, JavaScript, IBM Mainframe OS, TestManager, TSO/ISPF/SPUFI/DB2, Netscape 7.0