PROFESSIONAL SUMMARY:

• 12 years of progressive experience as software test engineer (Manual & Automation), quality analyst, test analyst, QA test coordinator and QA test lead with CANADIAN and USA clients.
• Strong expertise in databases, database internals, system installations and database technologies.
• Solid understanding of relational databases and SQL. Strong understanding of Internet architecture and browsers.
• Expert in analyzing test and reporting needs, evaluating requirements, custom designing solutions, troubleshooting for complex test systems and management issues.
• Strong background in testing software products, enterprise & web applications testing, Client server application testing and database testing. Experience in leading small team of testers and QAs.
• Extensive experience in testing of Java based web application solutions in IBM WebSphere/BEA WebLogic and Tomcat environment. Experienced in testing multi - tiered, web-based and native applications.
• Expertise in Stocks, Equities, Options, Mutual funds and Fixed Income trades. Good expertise in Over-the-counter(OTC) oroff-exchangetrading.
• Strong background in ETL testing, core banking applications, multi-dimensional modelling data warehouses and retail and capital market applications. Excellent understanding of market risk policies.
• Performed heavy duty testing of ETL loads in data warehouse Involved in development of complex SQL queries. Worked with and has excellent understanding on data warehouse Fact and Dimension Tables.
• Understands complex ETL data warehouse concepts. Has the ability to pull data from multiple sources .Expert in Relationship testing and Risk based testing.
• Extensive exposure to financial industry in regard to market risk policies, retail and capital markets. Worked on regulatory and compliance ETL banking projects like CDIC, AML, FATCA, WAL and Statistics Canada.
• Proficient in smoke, functional, regression, system integration, unit, user acceptance, integration, end to end testing, application, unit and performance testing, test planning, QA estimation, requirements gathering & modeling, test case creation and execution, test scenario, test bed, defect documentation, regression test setup, test process, defect management and defect life cycle and test project team co-ordination. Analyzed project requirement documents to identify test requirements.
• Implemented QA standards like SIX SIGMA (DMAIC and DMADV), ISO 9001, CMM (Level 1 to Level 5), BS7799, and TMM in the project level. Good knowledge in data analysis and graphical representation of data.
• Good knowledge in QA business analysis: business analysis planning & monitoring, enterprise analysis, elicitation, requirements analysis, requirements management & communication.
• Expertise in creating consolidated requirement documents, Traceability matrix documents, Test Plans, Test cases, Defect management plan, DIT, SIT, UAT exit reports and release management documents.
• Provided direction, expertise, feedback, coaching and development to build the capability of junior staff and offshore teams. Experienced in leading the team and conducting the performance appraisal. Was Responsible for guiding, advising and mentoring junior test engineers.
• Documented actual test results and responsible for the end-to-end tracking of all issues found and communicated status to Project management and assisted in defect investigation and escalation. Experienced in executing test cases, analyzing the test results and providing reports to Management.
• Resourceful in accomplishing tasks within deadlines, Efficient, organized, flexible and enthusiastic approach to multi-tasking and issue management, self-motivated and quick learner, works well under pressure and stays focused on getting the job done. Has the ability to work independently as well as within the team.
• Excellent organizational skills, a self-starter and can work independently, guiding& supporting the peers, creating best practices within the team with strong written and oral communication skills and an effective Team Player. Strong troubleshooting and problem-solving skills and has the capability to drive issues to resolution.
• Worked on Software Methodologies including Agile, Water fall, V model, Client server and Smart Client applications and risk reward model. Extensive expertise in developing QA strategies for SDLC.
• Proficient in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Coordinated with upstream and downstream stake-holders to overcome obstacles in meeting the test schedules.
• Provided input to QA metrics on all projects including defect rates and root cause analysis. Assisted Release Manager with department monthly metrics, QA dash boards and PowerPoint presentations. Involved in Work Intake Committee to provide weekly estimates to Business Units when required.
• Responsible for leading, coordinating, tracking, managing and reporting QA activities. Identified gaps in requirements, executed QA plan, reported and tracked defects and reported issues in a timely manner to the Project Team.
• Coordinated and worked with offshore teams on QA deliverables and bridge the communication between QA offshore team and local project teams. Came up with the innovative ways on testing application functionality ensuring greater test coverage as a value add service to the stake holders.
• Proven Expertise in the web service testing using SOAP UI. Experienced in functional testing and load testing of web services.
• An excellent software test engineer - coordinator with good Inferencing, Prioritization skills, Troubleshooting, Big picture in mind, Multi-tasking, ability to work in different test environments, a ‘test to break’ attitude, an ability to take the point of view of the customer, strong desire for quality and an attention to detail.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, HP-UX, UNIX, Solaris, Neoview and Non Stop Kernel

Testing Tools: Quality Center, Load Runner, Shell, Perl, Rational Requisite pro, Rational Purify, Tcl/Tk, Load Runner, Junit, QTP and Selenium

Database: MySQL, Oracle, SQL Server, Sybase, Loadstar, TOAD, OFSAA and HP SQLMX.

Applications/ Office tools: MS Project, MS Office (Word, Excel, Power point, Visio), MS Share Point

Web Technologies: HTML/DHTML, VB Script, ASP, MS Front Page, Visual Studio, Java, Junit.

Defect Tracking Tools: HP QC, JIRA, Bug Zilla, Wiki, Test link

Application Servers: Web logic, Jboss, Tomcat, Apache

Version Control Tools: Clear case, VSS and Share point.

Web Technologies: Web services, SOA, Java, J2EE, HTML, XML messaging, JavaScript, VBScript and JSP and FpML schema messaging.

ETL: Informatica, Data warehousing, OFSAA and multi-dimensional modelling.

Software Methodologies: Agile, Lean, Water fall, V model, RUP, Risk Reward, UML, Client server and Smart Client applications.

CRM: Siebel CRM, SAP Basis, SAP Security

Testing Frame works: Mocha, Staf, Selenium, Junit, Apache Jmeter

Other Tools: Ilog Jviews, Ilog Server, Tibco, Share point, MVS, Toad and DB visualizer.

PROFESSIONAL EXPERIENCE:

Confidential

TEST Manager and QA ANALYST, TEST CO-ORDINATOR

Environment: IBM Confidential Machine, HPQC

Responsibilities:

• Responsible for defect tracking and logging defects in QC.Collected reports from the team and providing the updates to the manager.
• Developed test report, test plan, test cases and test matrices for the project.
• Reviewed test cases written by other QA members.
• Executed test cases for the Confidential project.
• Verified the credit card logs as part of the test case execution result verification.

Confidential, ONTARIO, CA

SENIOR TEST and QA ANALYST, TEST CO-ORDINATOR

Environment: Windows XP, HP QC, Toad-Oracle 10G, Defect Management, IE, Toad analyst, Share point, ETL, Informatica.

Responsibilities:

• Reviewed Business Requirement Document, Solution Requirement Document and Application Design Document.Involved and prepared Test Strategy, Test Plan and Test Estimates.
• Defined Test Coverage, Testing In Scope / Out of Scope, Approach, Entry / Exit Criteria and Deliverables.
• Identified the target test Items to be evaluated by the test effort. Defined the appropriate tests required and any associated Test Data. Was Responsible for gathering and managing the Test Data.
• Created and updated test documents (Test Risk Assessment, Testing Estimates, Gap Analysis, Test Strategy, Test Plan, Test Cases, Daily Defect Report, UAT Test Plan and Document Sign Off) at SharePoint on regular basis.
• Conducted SIT and UAT Exit reports walk through and got the test plan sign offs from business, QA manager and QA director. Completed and obtained signoff for the master test plan for the project.
• Performed system integration testing (SIT), User Acceptance testing, UAT, Negative Testing, Backend Testing and End-End Testing on oracle 10g.
• Analyzed the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types in Source DB, Staging DB, Operational DB and in DataMart.
• Extensively worked on Data Mapping, Data Validation and Data Integrity using complex SQL queries.
• Performed end-to-end testing for feeds from source mainframe (GLM, CCIS and Hogan) to target DataMart system via feed hub.
• Verified the data accuracy to load source file to Staging-ODS-Data Mart during CDIC project.
• Used test management tool HP ALM Quality Center to create reports and graphs for analysis and tracking for test process. Was Responsible for guiding, advising and mentoring junior test engineers.
• Conducted the test cases walk through with the Business and Internal (Dev and BA) team.
• Responsible for coordinating, tracking and reporting QA activities, test schedules and statuses. Identified gaps in requirements executed QA plan, reported and tracked defects, and reported issues in a timely manner to the management and executives.
• End to End testing activities for SIT and UAT for CDIC RID Project.
• Involved in testing from Source - Staging-Operational data store- Data mart-Views
• Created test documents (Test Risk Assessment, Testing Estimates, Gap Analysis, Test Strategy, Test Plan, Test Cases, Daily Defect Report and SIT/UAT Test Plan Exit Reports) for CDIC RID project.
• Performed smoke testing, Functional Testing and Backend testing on oracle 10g.
• Facilitated project problem solving and troubleshooting of quality issues with development for RID data mart tables.
• Performed system integration testing (SIT), User Acceptance testing, UAT, Backend Testing and End-End Testing on oracle 10g. Involved in Regression testingof CDIC FID DataMart.
• Worked with all stakeholders to define/improve the defect management process.
• Effectively facilitated defect meetings and drive defect for the solution for CDIC RID project.
• Actively followed up with defect owners and communicated with them to ensure the defects are processed effectively.
• Coordinated with INTRIA upstream and downstream stake-holders to overcome obstacles in meeting the test schedules.
• Defined and monitored the Quality of defects, helped testers on improving the quality of defects
• Produce defect metrics reports and raise defect related risks/issues to the project.
• Coordinated with upstream and downstream stake-holders to overcome obstacles in meeting the test schedules.
• Created Test Requirement Traceability Matrix to trace and align Test Cases with the Business Requirements and ADD and the defect logged in HPQC.
• Coordinated and performed system integration testing (SIT), User Acceptance testing (UAT), Backend Testing and End-End Testing on oracle 10g.
• Analyzed requirements for OFSAA, ADD and detailed program specs/use cases to ensure they are concise and testable for Statistics Canada Project. Verified the business rules in OFSAA.
• Completed and obtained signoff for the test cases, master test plan and Exit reports for the project.
• Prepared and coordinated the User Acceptance Testing (UAT) of OFSAA performed by Business Client.
• Documented the defects and reports to Project Team. Tracked the defects through the Defect Life Cycle via HP Quality Centre v11.52 for Statistics Canada Project.
• Acquired final sign-off of testing results from the appropriate Project managers/stakeholders.
• Reported test results to the Project Manager. Prepared QA portion of the release notes. Attended Project related meetings every day for Statistics Canada Project.
• Chaired Test Team related meetings and prepared meeting materials for Statistics Canada Project.
• Did the coordination for 9 team members along with my tasks for Statistics Canada Project.

Confidential

Responsibilities:

• Very through and familiar with the Confidential CETM Quality process and framework for AML and FATCA project.Conducted the QA testing Requirements for the AML and FATCA project.
• Designed and created test plan, test cases, traceability matrix and exit reports for the AML and FATCA project.
• Captured the test results and opened the new defects in HP QC. Conducted the internal and external test plan walk through for the AML and FATCA project.
• Managed the defined QA Processes to ensure all the standards are met for the AML and FATCA project.
• Responsible for getting Sign offs for SIT and UAT Exit report from higher management for the AML and FATCA project.
• Daily status reporting (MOM) and metrics creation for AML and FATCA QA team.
• Understood data mapping rules and developed complex queries for data transformation extracts for AML and FATCA QA team at the time of test execution.
• Worked on several change requests for AML and FATCA projects.
• Provided input to QA metrics on EDSF projects including defect rates. Assisted QA Manager with department monthly metrics, QA dash boards and PowerPoint presentations.

Confidential

TEST CO-ORDINATOR and Senior QA Test ANALYST

Environment: Windows 7, Web services, Dot net, HP QC, MS SQL Server, Defect Management, Manual testing, IE, QTP, Load Runner

Responsibilities:

• Tested various features of WTIS project and monitored applications.Responsible for defect tracking and logging defects in QC, querying the Database, collecting reports from the team and providing the updates to the manager. Developed test report, test plan, test cases and test matrices for QA methodologies. Reviewed test plan & test cases written by other QA members.
• Met Business Analysts resources and development teams to understand the requirements.
• Opened new defects in JIRA, retested them upon fixes coming from development, eventually closing them.
• Ensured QA/testing methodology enables us to deliver well-documented, high quality software solutions
• Performed Functional, Security, System testing and Smoke testing manually. Created and executed SQL queries as part of back-end testing.
• Performed Regression testing for each and every function in every release or Build during Quality Assurance life cycle process
• Executed the automated scripts created by Automation team using QTP and analyzed the Test results
• Involved in the tracking and updating of the Requirement Traceability Matrix, thereby linking the test cases with the business requirements as well as other associated test cases

Confidential

Senior QA Test Analyst (Co-op Position)

Environment: Windows XP, Web services, J2EE, HP QC, Sybase DB, Defect Management, Manual testingIE, MS Project, DB Visualizer, Share point, SAS, Web services, XML and FpML schema and capital market products.

Responsibilities:

• Tested Confidential project - capital markets, stocks, securities, equities, options, transaction history, mutual funds, accounts, fund transfer and quotes. Monitored applications.Responsible for QC management, defect tracking, creating users and roles in QC, querying the Database, collecting reports from the team and providing the updates to the manager.
• Developed test report, test plan, test case doc and test matrices for QA methodologies
• Arranged meetings with other QA resources and development teams to understand the requirements.
• Participated in project kick off meeting, review meeting with the QAs, developers and BA’s.
• Collaborate effectively with the development teams to work / assess defects.
• Worked extensively on SYBASE to perform Data Integrity, Data Validation and Data Mapping Test.
• Performed Testing and Validation of the Buying Power of Brokerage account for various Trading like Equities, Options, Mutual funds and Fixed Income; Found Issues, reported and performed regression on the fixes to make sure the Buying Power calculated are displayed correctly on the application.
• Extensively tested Funds Transfer between Brokerage accounts, Banking accounts and External financial institutions.
• Tested Bill Payment functionality of Brokerage accounts. Developed detailed Test Cases for Equity and Options trading in HPQC.
• Performed the web services testing (Functional testing and Load testing) of the application.

Confidential

Environment: Smart Client Apps, Agile and Scrum Methodology, Windows OS, HP QC, CMM KPAs, SAS, Review and Analysis of project documents, Junit, Defect Management, Bugzilla, Share point, Selenium, JIRA.

Responsibilities:

• Co-ordination of the test execution activities for WIC project.Handled QC role and Functional Consultant role for SLG Practice project.
• Created the test library, Performed Integration and system testing, performance tests, UI testing of the WIC application. Designed and wrote the SRS and Test plan for WIC project.
• Spearheaded the gap analysis study for CMM 5.0 and TMM Implementation for CIBER Testing Business Unit.
• Achieved high Customer satisfaction rate of 5/5 for the WIC project for meeting stringent performance targets and obtained ‘Best Project’ among 30 projects.
• Established testing and QA best practices and checklists for CIBER testing business division.

Confidential

Test Engineer and promoted as Senior QA Test Analyst - TEST LEAD

Environment: Windows XP, HP NeoView, HP Tandem, Non Stop SQLMX, HPQC,HPUNIX, SOLARIS, LINUX, J2EE, Oracle DB, Manual testing, Junit, HP QC, TMM, Defect Management, Share point, JIRA,JUNIT

Responsibilities:

• For the HP NeoView, Symantec and Sun project I had 11 team members reporting to me. I did the coordination and performance appraisal for them.Responsible for defect tracking and following it up with the development team and closing the defects.
• Planned and prepared test scenarios and test scripts and enhanced them according to the requirements.
• Monitored, Created and circulated Daily & Weekly Status Reports.
• Participated in test planning, assisted in preparing various testing documentation (e.g. Test strategy, Test plan, defect management plan, test scenarios, test cases and test matrix etc.) and test results walkthroughs.
• Executed test cases within the testing environment, ensuring accuracy and recorded test results / defects and obtained approval. Created testing and QA best practices and checklists.
• Maintained and provided accurate testing status reports during testing phases and maintained documentation of test results according to defined processes / tools (including HP Quality Centre)
• Participated in post implementation reviews and processes (e.g. lessons learned, post-install application verifications etc). Developed SQL scripts for running complex data integrity test cases.
• Conducted Performance testing and Compatibility tests for Symantec NSW project. Performed cross browser check e.g. IE-6, IE-7, Safari and Fire fox.
• I worked closely with Business Analysts and Developers to create test plans and test cases.
• Provided release status reporting as required to the Release Manager, stakeholders and other release participants. Excellent Knowledge in test driven design with continuous integration.
• Worked on ecommerce project performance test plan by reviewing performance testing strategy. Load testing was done by Load Runner to ensure performance capability of the newly developed web based e-commerce application. Experienced in testing multi-tiered, web-based and native applications.
• Attended periodic meetings, teleconferences and led discussions on problem resolution. Reported, tracked, reviewed, analyzed and compared bugs using a defect tracking system. Ensured that the raised defects are fixed, retested and closed in the defect management tool.
• Attended the regular client calls and discussed the weekly status with the client. Involved in gathering business requirements & documenting them using Rational Requisite pro.
• Analyzed user requirements, attended CR meetings and to document changes and implement procedures for test changes.
• Tested the Java based multi-tiered web application solutions in IBM WebSphere/BEA WebLogic and Tomcat environment for BP and National grid projects.
• Involved in the regression testing of Trading systems and Order management systems for the capital market applications of ANZ bank.
• Nm Tested the Capital market Applications of (cash, future, options and mutual funds) ANZ bank.
• Performed the system integration testing, application, unit and performance testing of SUN JES project.
• Coordinated basic project activities, review of deliverables and knowledge impartation for new team members.