Senior Test Consultant. Resume
SUMMARY
- 10 years of IT experience in system analysis, design, testing and implementation of large scale enterprise business systems in Banking, Investment, Financial, Insurance, Telecom and Pharmaceutical Domains.
- In Depth knowledge of Testing OBIEE Reporting, Actuate, Essbase, Hyperion and Regulatory Reports.
- In Depth Knowledge of Migration, Acquisition and Merger, Feed hub and batch processing projects.
- Extensive Experience in testing of Banking, Securities Trading, Commercial Insurance Applications and good Knowledge in FIX (Financial Information exchange) protocol.
- Extensive experience in Trading, FIX Messaging, Order Generation, Order Execution, brokerage, trade processing, market simulation, market data, portfolio analytics with hands on experience in Equities, Fixed Income, Commodities, Futures, Index, Options, Swaps and other Derivatives.
- In depth Knowledge on various functionalities of Property and Casualty insurance Application including Customer Relationship Management, Underwriting, Quotes, Policy Admin, Accounts and Claims systems.
- In depth knowledge on various Functionalities of Telecom Applications including Call Data Record (CDR) Pool, Billing, Accounts systems.
- In depth Knowledge of Various Retail Applications including Contract Management and Inventory Management System.
- Involved in Testing the Compatibility of different functionalities of the Application with Smart Phones and Androids.
TECHNICAL SKILLS
OS: Windows NT, Windows 95/98, 2000, XP, UNIXTesting Tools: QTP, Win Runner, Load Runner, Rational Robot and QA Run.
Bug Tracking Tool: HP Quality Center, Test Director, QA Manager, Rational Clear Quest.
Databases: Oracle, SQL Server, MS Access, DB2, Sybase.
Languages/Scripting: TSL, VB Script, Java, C, C++, XML, SQL, UNIX Shell, Linux, C Shell.
Formatting: XML, HTML, DHTML, VISIO, WORD, EXCEL, and POWERPOINT.
Front End Tools: Visual Basic 6.0, OBIEE 10g, and OBIEE 11g, Actuate Reports, Essbase and Hyperion, Crystal Reports, FoxPro.
Business: Project Management, RUP, SDLC, MS Office, and Lotus Notes.
PROFESSIONAL EXPERIENCE:
Confidential
Senior Test Consultant.
Responsibilities:
- Responsible for analyzing the business and technical requirements of the project to document the scope and defining the Test approach.
- Work closely with project team & business users of the system to perform the impact analysis of the system thereby creating an initial estimation to execute entire Testing Life Cycle of the project.
- Analyzed the Business Requirements and Rules, worked with Business Analysts and Business User in preparing Test Strategy, Test Plan, Risk Assessment and Scalability.
- Review Project Documentation and provide appropriate feedback/Comments.
- Coordinate with Technical team, Business Analyst & Subject Matter Experts for addressing the requirement issues and defects
- Provide Impact Assessment for Change Requests and re - estimating the effort accordingly.
- Responsible for Coordinating, prioritizing & Managing all Quality Assurance Activities.
- Responsible for creating Quality Metrics and presenting them to Project stakeholders.
- Coordinate Testing activities across SDLC phases, review testing artifacts and ensure quality on deliverables.
- Coordinate with project team on performing testing activities.
- Coordinate testing resource utilization, resource planning and allocation.
- Coordinate with environment/infrastructure teams in setting up test environments & executing required batch jobs and key processes.
- Reviewed Test Scenarios, Test Cases, SQL Scripts.
- Manage Quality Assurance through all phases of SDLC.
- Coordinate Performance & User Acceptance testing.
- Represent QA in project meetings.
- Conduct Testing Status & Defect review meetings and attend project meetings.
- Create Test Summary report, Test Execution report and Defect report.
- Managing Defects and Test results through HP QC and owning all the customizations as a Quality Centre Admin.
- Prepare Test logs, daily and Weekly status reports
- Conduct Go/No-GO Meetings to discuss the Test Results before MTP (Move to production).
- Review the implementation plan with configuration change management team.
Confidential
Sr. QA Analyst
Responsibilities:
- Performed requirements analysis, developed and maintained test documentation including Test Scenario Specification, Test Plan, and Test Case Specification.
- Analyzed the requirements and developed positive and negative test cases and established the requirements traceability matrix (RTM).
- Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Security, Backend (Database) Testing.
- Financial and Management Reports according to the business requirements.
- Tested several complex reports generated through OBIEE, Actuate, ESSbase and Hyperion including Dashboards, Summary Reports, Master Detailed,Drill down, Push and Pull reports.
- Involved in testing the batch Jobs run both in Tidal/Sysadmiral and Autosys through Batch job run logs.
- Tested the inbound and outbound Feed Received by EDSF Source and then to Target GLM Target.
- Tested the inbound and outbound Feeds for the Feed hub testing.
- Verified test results (viewing the log files, querying the database using the SQL) documenting the defects.
- Tested theETLInformatica mappings and otherETLProcesses (DW Testing).
- Involved in testing the UI screens, reports which was used by the internal business team.
- Prepared Test Scenarios by creating Mock data based on the different test cases.
- Attended Daily and Weekly Defect Review and Defect Status meetings. Provided updates to other Team members on testing activities.
- Worked with Developers on Defects until the test case is passed.
- Used HP Quality Center as test management tool.
- Mentored other team members in understanding the application and other QA Techniques.
- Created User Guide and developed Power point presentation for the business and End Users.
- Participated in Post-Mortem Analysis (lesson learnt) Reviews and contributed to the report.
- Actively participated in Group discussion and suggested new ideas for monitoring and Improvement of the business process.
Environment: Java, J2EE, EJB, C++, Emptoris 9.0, Oracle, PeopleSoft 9.0,TOAD 10.0.6, Oracle 10g, Oracle 11g, Actuate, Essbase, Hyperion, Toad 10.0.6, SQL Server 2008, Informatica, Autosys, Tidal, Sysadmiral, DB2, PL/SQL, JCL, Web Logic, MS Access, Flat files, Session Logs, SQL scripts, HP QC ALM 11.52,Q.T.P 9.0, Load Runner, CETM Methodology, Agile Methodology, Share point, MS Access, Visio.
Confidential
Sr. QA Analyst-Test Coordinator
Responsibilities:
- Analyzed the business requirements and system specifications to understand the application.
- Participated in the Proof of design Session to review the development of new application and provided feedback.
- Developed Test Scenarios with Test data to support Test Requirements.
- Instrumental in Test documentation (Test Strategy, Test Plan, Test cases, Test Data, Test Scripts).
- Created Test Cases and supporting test data to ensure the data adequately tests all testable situations.
- Tested French contents of the Applications Functionality.
- Involved in executing the Test Scripts and reporting the Test Results in Quality Centre.
- Involved in executing the Test Procedures and Record Defects.
- Taken ownership for specific modules and validated the functionality of assigned modules of the application.
- Created Requirement Traceability Matrix (RTM) and managed all the use cases and test cases matrix using QC and Excel.
- Associated New Change Requests from the business to functional, Integration and regression testing and ensure that the enhancements did not break the existing functionalities.
- Worked closely with development team in resolving Defects, verified and closed Defects reports once they are resolved.
- Conducted and Coordinated in Defect resolution meeting with development, testing team and addressed the severity, priority levels of the Defect and turnaround time for the defect fixing.
- Compared and analyzed the test results for every release and participated in SIT analysis, UAT and PAT session.
- Worked on People Soft application to Updated Vendors, Commodity codes and Business Units.
- Performed Backend testing to validate Suppliers, Commodity Codes and Business Units are integrated properly with Emptoris Contract Management Application.
- Tested Front End reports through OBIEE for Assets and Expenses report.
- Participated in walkthroughs and technical reviews all through the testing phase.
Environment: Java, J2EE, EJB, C++, Emptoris 9.0, Oracle-OBIEE, PeopleSoft 9.0, TOAD, Quality Center 11, Q.T.P 9.0, Load Runner, CETM Methodology, Agile Methodology, Share point, MS Access, Visio.
Confidential
QA Lead/Sr. QA Analyst
Responsibilities:
- Analyzed the business requirements and system specifications to understand the application.
- Interacted with Business Analyst to confirm all Business and Functional requirements has been covered in the Application.
- Participated in the Proof of design Session to review the development of new application and provided feedback.
- Interacted with the Development Team to understand the Design Requirements.
- Responsible for testing the entire application with Manual and Automated strategies.
- Created Test Strategy and Test Plans.
- Created Test Case Templates for testing the entire application.
- Involved in executing the Test Scripts and reporting the Test Results in Quality Centre.
- Worked closely with development team in resolving bugs and verified and closed bug reports once they are resolved.
- Developed SQL queries to test the Database values for data Integrity.
- Responsible for performing Functional, Integration, Regression and system Testing using QTP.
- Added Standard, bitmap, text, text Area, database checkpoints and synchronization points in test scripts using QTP.
- Replaced fixed values with parameters in QTP, to check the functionality of the application with multiple sets of data.
- Compared and analyzed the test results for every release and participated in SIT analysis, UAT and PAT session.
- Tracked defects, which include adding defects, repairing open defects, testing a new build of the application,
Environment: Java, J2EE, EJB, JSP, C++, Oracle, PL/SQL, Mainframe, Unix, TOAD, Load Runner, Quality Center, Q.T.P 8.2, RUP Methodology, Web sphere, Rational Clear case, Team Foundation Server, MS Assess, Visio.
Confidential
QA Analyst
Responsibilities:
- Participated in the Proof of design Session to review the development of new application and provided feedback.
- Analyzed the business requirements, system and functional specifications to understand the application.
- Developed System Test Plans, Test Cases, Test Scripts based on Business Documents.
- Involved in Functionality Testing of applications.
- Developed Test Scenarios with Test data to support Test Requirements.
- Involved in executing the Test Scripts and reporting the Test Results in Quality Centre.
- Involved in executing the Test Procedures and Record Defects.
- Worked closely with development team in resolving bugs and verified and closed bug reports once they are resolved.
- Performed Functional, System, Regression, user acceptance testing (UAT) and Production Acceptance Testing (PAT).
- Tested OBIEE Front End Reports including Account Balance report, Drill down and Drill through reports.
- Developed a detailed Test Plan for the testing effort of the User Interface.
- Performed Database (SQL) testing for checking data validation and data integrity in the new web based platform.
- Responsible for testing of the Interface manually.
- Used Quality Center to track defects and attended meetings with developers in resolving the same.
Environment: Quick Test Pro, Win 2000, Win XP, Mac10.2, Mac 10.4, MS VSS, Access, Weblogic, Oracle (OBIEE)10g, Agile Methodology, Rational Test Manager, Rational clear quest, Mainframe, TSO/ISPF,DB2,JCL,VSAM.
Confidential
Lead QA Tester
Responsibilities:
- Studied, Reviewed and analyzed the business requirements and Functional specifications to understand the application.
- Analyzed System design documents and Data models/Entity Relationship diagrams to understand the connectivity of databases.
- Involved in creating Test documentation including Test Strategy, Test plan, Test cases, Test Data, Test Scripts.
- Involved in Functionality, integration, interface, system and back end testing of applications.
- Developed Test Scenarios with Test data to support Test Requirements.
- Involved in designing the Test Plan and Test cases and maintained in Test Director.
- Involved in functionality testing of filling the Simple and Conditional (contingent) Order, Sell the Order and blocking the Orders.
- Involved in functionality testing of buying and selling of different instrument types including Equity, Bond, Fixed Income, Swaps, and different types of Derivatives ie Futures and Options.
- Involved in functionality testing of Switching, transfer a trade from one series/subclass or one Fund to other.
- Tested functionality for Generating quarterly, Annual Profit and Loss report on the current holdings on OBIEE 10g.
- Tested Drill Through, Drill down, QTD, Monthly, YTD and other Adhoc Reports in OBIEE 10 G as per User’s requirement.
- Tested Functionality for calculating the Expenses incurred in Buying and Selling a Trade.
- Involved in Functionality testing for Calculating the Management, penalties and other types of fees.
- Involved in Functionality testing of pre and post trade compliance.
- Involved in Interface testing of portfolio Management application with downstream and upstream applications (i.e.: Wealth Management, Risk Management, billing and Accounts Application).
- Performed back end testing to verify data integrity and data mapping between front end and back end component.
- Developed SQL queries to connect to the data base.
Environment: Web Application using Java, XML, XSL, JavaScript, Autosys, Sybase 12.0.1(SQL Advantage), OBIEE 10g, Charles River, Weblogic 6 Server, Unix OS, Visual Source Safe, QTP 8.0, Test Director, Clear Case, Agile Methodology.
