SUMMARY:

• Over 10+ years of experience in Business Analysis, Requirement Engineering, Resource Management and Test Planning across Health care, Debt consolidation, Data Warehousing and Capital Market Domain in different roles varying from Test Analyst to Test Lead
• In depth experience in working with business stakeholders and technical team to identify requirements, perform gap analysis between existing goals and procedures, create business and functional documentation, design and develop systems and solutions
• Good understanding of development methodologies like Waterfall model, Agile development including all phases of Project lifecycle like Requirements elicitation/gathering, Analysis, Design, Implementation, Testing and Deployment
• Extensive experience in handling Requirements Management, Business Requirements Document (BRD), Functional Requirements Specification(FRS), System Requirement Specifications (SRS), Use Case Specifications and Requirements Traceability Matrix
• Excellent Knowledge of Database Systems - Oracle 10g, SQL server, DB2 and Data ware house concepts.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries
• Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge
• Excellent knowledge in Eagle Investment Systems ( EAGLE - STAR/PACE)
• Extensive experience in Capital Markets, Corporate Banking, Financial Asset Management
• Subject matter expertise in Fixed Income, the Custody and Corporate action. Good understanding of Equity, Cash management, Capital market, SWIFT, Options, Derivative Securities fundamentals with hands on experience
• Highly skilled in Manual Testing of software applications across multiple technologies and platforms
• Experience in collecting QA SLA/metrics data, analyzing and proposing necessary improvements to the QA process.
• Experienced in coordinating testing efforts, test deliverables, status reporting and issue escalations to management
• Good experience in Report generation from QC using API’s
• The experience includes extensive knowledge in testing of software applications for client server and Web based applications in ASP.NET and Oracle
• Strong knowledge of Business Intelligence, Business Architecture, Data Warehousing, Database structures and query formats with stronghold on SQL and Oracle systems
• Worked in full life cycle of the software design process including requirement definition, design, testing, documentation and maintenance
• Proficient in creating Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Process Flows using MS Visio, Mindjet Manager.
• Good interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies

TECHNICAL SKILLS:

Operating Systems : Windows XP/2000/2007, Linux and UNIX

Databases: Oracle 8i/9i/10g/11g, DB2 8.0/7.0, SQL Server 2005/2008, Teradata MS Access

Domains: Investment Management, Capital Market, Health Care, Debt Consolidation

Utility Tools: SQL Developer, TOAD and SQL Assistant

Test management: Quality Center (ALM), Hexawise Management

Office Tools: MS Visio, MS Office, SharePoint, Excel, Word , MindJet Manager,Jenkins

Automation Tool: Rational Integration Tester

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

• Developing data requirements and data interface material and publishing that information to external stakeholders of the Common Securitization Platform. The team also maintains the Common Securitization Platform Data Dictionary, which serves as the business data dictionary for the Platform
• Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system
• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production
• Provide any related test data to interface and prepare the test data by inputting in the GUI For testing the CR
• Executed the SQL queries for backend validations
• Responsible for Regression testing to make sure that application is working fine because of the changes to the new code/enhancement
• Responsible to prepare all the Quality Assurance Documents and posted in Share point and Quality Center
• Worked closely with the Quality Assurance team and conducted User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
• Monitored client expectations and conducted user interviews to improve overall quality of the Application

Confidential

Senior Consultant

Responsibilities:

• Work with software developers on the design and specification of features of the application.
• Testing involves Data base, Cross Commit XML validations through Data base logs and Valuation service XML logs validations, UI Validations and Functionality testing.
• Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system
• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production
• Provide any related test data to interface and prepare the test data by inputting in the GUI For testing the CR
• Executed the SQL queries for backend validations
• Responsible for Regression testing to make sure that application is working fine because of the changes to the new code/enhancement
• Responsible to prepare all the Quality Assurance Documents and posted in Share point and Quality Center
• Worked closely with the Quality Assurance team and conducted User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
• Monitored client expectations and conducted user interviews to improve overall quality of the Application

Confidential, Irvine, CA

Test Lead

Responsibilities:

• Part of the functional team to identify functional gaps between legacy application and EAGLE
• Involved in functional testing ( Pre Release and Post Release testing) for the EAGLE application
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and UAT testing
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Subject matter expertise in Fixed Income, the Custody and Corporate action. Good understanding of fixed income, Equity, Cash management, Capital market, SWIFT, Options, Forwards, SPOT, Swaps & Derivative Securities  fundamentals with hands on experience
• Posts transactions at account level, keeping track of account positions, cash and accruals
• Processing transactions such as trades, corporate actions, capstock, interest accrual, settlement and cash movement
• Maintaining the share, cost, market value for cash and securities
• Maintaining and validating the general ledger account
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases.
• Work with software developers on the design and specification of features of the application.
• Testing involves Data base, Cross Commit XML validations through Data base logs and Valuation service XML logs validations, UI Validations and Functionality testing.
• Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system
• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production
• Provide any related test data to interface and prepare the test data by inputting in the GUI For testing the CR’s.
• Executed the SQL queries for backend validations
• Responsible for Regression testing to make sure that application is working fine because of the changes to the new code/enhancement
• Responsible to prepare all the Quality Assurance Documents and posted in Share point and Quality Center
• Worked closely with the Quality Assurance team and conducted User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
• Monitored client expectations and conducted user interviews to improve overall quality of the Application

Confidential 

Test Analyst

Responsibilities:

• Work with software developers on the design and specification of features of the application.
• Testing involves Data base, Cross Commit XML validations through Data base logs and Valuation service XML logs validations, UI Validations and Functionality testing.
• Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system
• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production
• Provide any related test data to interface and prepare the test data by inputting in the GUI For testing the CR
• Executed the SQL queries for backend validations
• Responsible for Regression testing to make sure that application is working fine because of the changes to the new code/enhancement
• Responsible to prepare all the Quality Assurance Documents and posted in Share point and Quality Center
• Worked closely with the Quality Assurance team and conducted User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
• Monitored client expectations and conducted user interviews to improve overall quality of the Application

Confidential

Test Lead

Responsibilities:

• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle
• Performed data quality analysis using advanced SQL skills
• Ensured Error logs and audit tables are generated and populated properly
• Provide any related test data to interface and prepare the test data by inputting in the GUI For testing the CR
• Executed the SQL queries for backend validations
• Responsible for Regression testing to make sure that application is working fine because of the changes to the new code/enhancement
• Responsible to prepare all the Quality Assurance Documents and posted in Share point and Quality Center
• Worked closely with the Quality Assurance team and conducted User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.
• Monitored client expectations and conducted user interviews to improve overall quality of the Application

Confidential

Test Lead

Responsibilities:

• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production

Confidential

Test Engineer

Responsibilities:

• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production

Confidential

Test Engineer

Responsibilities:

• Analyze Business Requirement, SRS, and participating in the document inspection
• Involved in preparing master Test plan and Test Scenarios
• Responsible for preparing Test case Spread sheet, Test Cases, Setting the Environment, executing the test cases and document the results in Quality Center
• Extensively involved in preparing test cases, test conditions and test scripts for manual testing
• Responsible to resolve the issue by talking to Developers, Business Analysts and Client
• Responsible to report the defect to Developer, QA Manager, Development manager and
• Add defects in Quality Center for the Fix
• Involved in user acceptance test plan Provided UAT test cases for the client to verify before deploying the application into production