Testing Sql Server
Resume:
Emmanuel Omo
Houston TX 77056
abilrx@r.postjobfree.com
OBJECTIVE: An enthusiastic, self motivated individual who strives to achieve a very high standard in any endeavor with the willingness to learn
and adapt. My assets as a strong communicator with the aptitude to use initiative to achieve all professional targets are favorable for any
organization. As an effective team player with the ability to work with minimal supervision, I hope to utilize these strengths and attributes within
an effective manner and responsible role.
Profile
• Over 5 years of experience as a QA Tester, which includes both Manual and Automated testing using Mercury Interactive Test suite on
different environments
• Adapted to technical skills in functional, regression and performance testing of various organizations
• Good experience in doing Functional and Regression Testing by using Mercury Interactive testing tools WinRunner and QTP
• Extensive experience in Functional Testing, Database Testing, System Testing, Regression Testing, Performance Testing, Smoke Testing,
compatibility Testing and User Acceptance Testing(UAT) .
• Expertise in TSL Scripting on WinRunner and VBScript on QTP
• Excellent experience in understanding SEI CMM levels of documentation
• Excellent Experience Agile Testing methodology and agile SDLC
• Experience in database testing in Oracle,SQL server and My SQL environment
• Very good experience in doing Manual Testing by using TestDirector,Quality Center and Microsoft Excel
• Extensive experience in manual testing and automated testing Specialized in writing Test Plans, Test Scripts, Test Analysis and Testing Life
Cycle.
• Good experience in understanding Software Development Life Cycle(SDLC)
• Good functional knowledge in the area of Insurance, Financial, Banking, Trading and Pharmacy application areas
• Excellent experience doing backend testing for Oracle Database by using SQL queries
• Extensive experience in implementing QA methodologies on the basis of Quality standards like CMM levels.
• Excellent experience in defect reporting by using TestDirector and Quality Center
• Very good Experience in doing Performance and Stress Testing by using LoadRunner
• Profound Analytical and Problem Solving Skills with an Excellent Team Culture
• I am a self and quick learner and can learn new technologies very fast
Technical Skills
Testing Tools : WinRunner, LoadRunner, TestDirector,QualityCenter, QuickTest Pro
Databases : Oracle, MS Access, SQL Server
Application Servers : WebLogic, IIS
Environment: Java, JavaScript, Jboss, J2EE, Oracle, Ejb, XML, Weblogic, Ms SQL Server, Windows, and UNIX
Other Skills : Microsoft Word, Microsoft Excel, Microsoft Office, MS Dos, Access, Quicken, AS400, Project Management Office / Software,
Trading Some Financial Instruments with the usage of Algorithmic and Quantitative Trading style.
EDUCATION:
Capella University Minneapolis, MN and HCC South West Campus Houston Texas
Finance & Computer Science.
PROFESSIONAL EXPERIENCE:
Travelex Worldwide Money (Nov 2009 – Feb 2010 )
Currency Trader : Part – Time
Responsibilities :
. Trading global currencies.
. Correspondence with prospective clients.
. Daily accounting mathematical currency computations.
. Taking in stock of currencies needed for daily currency trades.
. Setting daily currency spreads, and differentiating spot rates from fixed rates.
. Putting currency rates on electronic – board.
ABC: Americanized Benefits Consultants, Houston Texas ( Jan 2009 – Sept 2009 )
(Health Insurance Brokers)
Business Development Specialist
Responsibilities :
• Attended the daily Project status meetings.
• Determined the performance of critical transactions by reviewing analysis graphs
• Constant Interaction with prospective clients.
PNC Financial Services Group Inc., PA ( Oct 2006 – Oct 2007 )
QA Tester
Description: PNC Bank Corp. is one of the largest diversified financial services organizations in the United States. Its major businesses include
Regional Community Banking, Corporate Banking, Private Banking, Mortgage Banking, Secured Lending, Asset Management and Mutual Fund
Servicing. The Company has developed new software, PINACLE, with many salient features for the operations of Treasury Management.
PINACLE new software developed for PNC Bank Corp has many salient features for the operations of Treasury Management.
Responsibilities:
• Analyzed the user/business requirements, functional specifications and use case documents to create the Test Plan, Test cases for System
testing
• Developed test cases, test scripts manually and also using automated tool Quick Test Professional QTP
• Performed GUI interface testing in Client side
• Done both positive and negative testing on each future of the application
• Back End Database verification manually and using Quick Test Professional QTP to automatically verify Database with the values entered
during automated testing by inserting Database Checkpoints
• Checking the database for database validations using SQL statements using Database Check Point
• Perform web test using Quick Test professional for checking page contents, web objects, frames and tables.
• Performed Sanity Testing, Integration Testing, Regression testing, User acceptance testing (UAT) and System testing by using Quick test
professional QTP
• Done multibrowser Testing on Internet Explorer (IE) and Netscape Navigator (NN)
• Responsible for doing the batch testing by using Test Batch Runner Tools in QTP
• Worked with various checks points(Standard checkpoints, Database Checkpoints, Text checkpoints and Bitmap checkpoints) to perform
regression testing
• Conducted Stress and Load Testing by creating Scenarios in LoadRunner
• Done extensive parameterization to ensure real time load conditions
• Used Rendezvous point to better control and generate peak load on the server there by stressing it and measuring its performance
• Utilized LoadRunner Analysis tool to analyze the response time of the Transactions
• Tracing and reporting defects using Quality center, that facilitates work flow issues and helped resolving technical issues with developers.
• Interacted with developers to resolve defects, performed Regression testing by using QTP to verify that bug fixes did not break some other
parts of the system
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center
• Maintained Test Matrix for the summarized test results information and created deliverables such as the test summary reports
• Attended the daily Project status meetings
Testing Tools : Quick Test Professional,LoadRunner,Quality center
Environment : Vb.net, Asp.net, C#.net, SQL and Windows.
MBNA Bank, Newark, DE ( Aug 2005 – Aug 2006 )
QA Tester
Description: The Customer Relationship Center (CRC), web based application, enables users to view all accounts associated with a customer.
These accounts include credit card, Gold Reserve, Gold Option, Sales Finance, Mortgage, Aircraft, B2B, and deposits (CDs, Money Market and
IRAs). CRC currently provides customer centric information to MBNA people that enable them to quickly identify service and sales opportunities.
The Customer Marketing Application (CMA) is the enterprise call center service application for soliciting products to the customers, recording
comments and customer disposition reasons, showing group/associate bank benefits and retaining the customer by using the wizard
functionality. It also maintains the historical data for statistical other reporting purposes for each customer contact and product display.
Responsibilities:
• Drafted test strategies, test plans and test cases based on functional specification.
• Analyze system requirements and formulated a Test Plan for testing the functionality, navigation, and integration testing of the application,
using Quality center.
• Performed Manual testing to check the integrity of flow of data from front end to the back end.
• Performed GUI, User Acceptance, System and Integration testing using QTP.
• Conducted validations using checkpoints and transactions in QTP to perform System Testing.
• Retrieved data from application using output values.
• Performed API Testing.
• Conducted Testing on both Windows and UNIX environments
• Conducted Load and Stress testing was done by creating virtual users using LoadRunner
• Measured response times and transaction rates of the application using performance testing
• Determined the performance of critical transactions by reviewing analysis graphs
• Quality center used a Bug Reporting tool.
• Used Quality Center for defect tracking, writing requirements, and test plan and run tests in the Test lab
• Responsible for weekly status updates showing the progress of the testing effort and open issues to be resolved, interact with developers and
users for any update and change in the application.
Testing Tools : WinRunner, LoadRunner, TestDirector and Manual Testing
Environment : Java, JavaScript, J2EE, Oracle and Windows
MetLife Insurance NY ( June 2004 – June 2005 )
QA Tester
Involved in testing of web application, which was developed for MetLife Insurance Company. MetLife is one of the leading insurance companies
in the United States. The application helps the field agents of the company to enter prospective customers’ data. The application also calculates
the amount of premium required, cash value and benefit amount for the years in consideration. The Online application has different modules
and I was involved in testing the Long Term Cares. In this system, registered members with MetLife can get details of their LTC insurance,
change the term of their coverage and also use the premium calculator to determine the new premium.
Responsibilities:
• Generating and implementing templates for Test Plan, Test Cases, and Test Scripts.
• Wrote SQL queries to test the different scenarios in the application.
• Performed User Acceptance Testing, and Back end Testing.
• Manually conducted Positive and negative testing.
• Performed manual testing on different modules of the application using TestDirector
• Involved in performance testing of the web site and the entire application, analyzed the test results with the business team.
• Conducted Functional, Integration, System, Regression, Performance and Black Box Testing by Using WinRunner.
• Worked with functions and involved in synchronizing the Test Scripts using WinRunner
• Involved in Load Test using LoadRunner to make sure every utility functions accordingly to the pre defined requirements.
• Created Rendezvous points at various places in scripts in order to simulate heavy user load by using LoadRunner.
• Designed the LoadRunner scenarios with various user mix incrementing in constant ratios, till the peak load is achieved
• Reported defects by using TestDirector, verified fixes and closed bugs during Regression testing
• Attended daily status meetings with Project management on testing update.
Testing Tools: Quick Test Professional, Quality Center, LoadRunner and
Manual testing
Environment: Java, J2EE,Ejb, XML, Weblogic, Ms SQL Server, Windows, UNIX
CIGNA HealthCare, CT ( April 2003 – April 2004 )
QA Tester
Cigna healthcare provides quality health, dental, vision, pharmacy and behavioral health coverage for employees and their families. As a QA
Analyst, had to interact with physicians, business managers and site staff to understand their operational Responsibilities.
Responsibilities:
• Designed and developed Test Plan, test scenarios, test procedures, Test cases and test data according to functional specifications and
business requirement documents
• Developed a comprehensive test plan software testing
• Worked on system requirements as well as business requirements interface and prepare test cases for integration testing and system testing.
• As a team member responsible for testing the Application manually as per business requirements.
• Performed Testing Manually
• Generated the TSL scripts using with WinRunner
• Performed End to End testing manually and regression testing with WinRunner
• Created WinRunner test scripts, GUI map files, modified the Win Runner scripts where and when required and maintained the existing
WinRunner scripts
• Interested with Developers and system Engineers to nail down the technical problems
• Performed Testing of the Application both UNIX and Windows Platforms
• Performed the System, Integration testing on functional modules
• Tested the application compatibility on various versions of Netscape and Internet explorer browsers
• Reported defects by using TestDirector, verified fixes and closed bugs Regression testing
• Interacted with developers to resolve the defects.
Testing Tools : Manual Testing, WinRunner and TestDirector
Environment : Java, JavaScript, J2EE, HTML,UNIX, MS SQL server, Windows
Verizon Wireless Inc., Walnut Creek, CA ( Feb 2002 Feb 2003 )
Part of team as QA Tester to analyzing current / modified mobile / wireless application systems providing with selling service plans, mobile and
its accessories and user account maintenance.
Responsibilities:
• Designed and executed test plans and test cases.
• Conducted Manual testing for checking Functionality during the various phases of the development of the online application.
• Designed Test Cases Manually for the Entire Application using TestDirector
• Wrote SQL Statements to extract Data from Database to verify the output Data of the reports.
• Performed System Testing, Unit Testing, and Integration Testing by using WinRunner.
• Conducted Regression, positive and negative tests.
• Bug tracking done through TestDirector.
• Used Test director an bug reporting tool for Reporting software bugs and maintained reports, tracked defects and also interacted with the
programming team to resolve technical issues.
Testing Tools: Manual Testing, WinRunner and TestDirector
Environment: Java, J2EE, JavaScript, HTML, Tomcat, Oracle, and windows
REFERENCES ARE AVAILABLE UPON YOUR REQUEST
Contact this candidate