Ravi Mobile: 703-***-****
Database Analyst/QA Tester Email: *******.***@*****.***
Objective:
Looking for a challenging opportunity using my Technical and Analytical Skills in the field of Database Analyst /QA Tester
Career Summary:
• Over 3 years of experience in IT Industry as an Database Analyst / Quality Assurance Tester
• Good knowledge in Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• Worked with databases like Oracle 10g, 9i, 8i, 7.x, SQL Server 2000/2005, Sybase, Ms Access and My SQL and Expert in MS Office 2003, MS Visio.
• Adept with RDBMS Concepts and Entity- Relationship diagrams and used Data Modeling Tools like Ervin and TOAD, SQL Navigator.
• Rich Experience in developing SQL Scripts, PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling and good in Oracle Forms and Reports.
• Extensive knowledge in SQL Tuning queries to enhance the database performance and availability.
• Strong Experience working with Performance tuning utilities like Explain plan, TK proff, Oracle Hints and great conceptual knowledge of Indexes and Table Spaces and Joins, Nested Loops, Full table scans etc.
• Good Knowledge in Data Conversion and migration of legacy application data to Oracle using SQLLOADER and Oracle External Tables.
• Extensive experience working with various Web applications and also with many online, Electronic Commerce Applications.
• Rich Experience working with all the phases of Software Testing Life Cycle and Involved In all Phases of Bug Life Cycle.
• Proficient in Manual Testing using Defect Management tools like Quality Center, Test Director and Bugzilla to track defects and enhancements.
• Worked with Source Control and Source Management tools like Rational Clear Quest, Clear Case, Visual Source Safe, and Harvest.
• Good Experience working with Methodologies like Agile Methodologies and Rational Unified Process and worked as Rational Functional Tester, Quality Center.
• Rich Experience working with Rational Tools Suite, Rational Test Tools and Mercury Tools Suite, Rational Test manager.
• Extensive expertise in conducting Manual Testing and Automated Testing using QTP and Created Test Data and good experience in writing Unix and Shell Scripts.
• Thorough knowledge Automation Testing in testing applications using Regulatory Testing, Automation Testing tools such as Win Runner, Load Runner and QTP and working with VB Script.
• Experience in Black Box, White Box Testing, Positive, Negative, Data Driven, Unit, System, Integrated and Back End Testing, Executed and Updated SQL Queries for Back-End Testing.
• Expert with Microsoft Office Suite, MS Project, MS Visio.
• Strong Analytical, Technical Skills coupled with Good Communication and Interpersonal Skills and Ability to work in team environment and also individually.
Education and Certifications:
• Masters in Software Engineering from University of Stratford, Virginia (Aug 2006 – Dec 2007) – 3.70 GPA.
• Bachelors in Computer Science from Sathyabama Deemed University, India (May 2001 – May 2005) – 3.60 GPA.
Technical Skills:
Operating Systems Windows 2000/2003/XP, UNIX, Linux, DOS
Languages SQL, PLSQL, T-SQL, Unix and Shell Scripting, HTML, XML, C, C++
VBScript, JAVA, Java Script.
RDBMS Oracle 11i/10g/9i, SQL Server 2000/2005, MS- Access.
Oracle Tools SQL * Plus, Pl-SQL Developer, TOAD, SQL Navigator.
Reports Oracle Forms 4.5/5.0/6i, Reports 6i/3/2.5, SQL Reports 9i, Business Objects XIR2/XI/6.5
Bug Tracking Tools Quality Center, Bugzilla, Test Director, Test Manager, Team Track
Testing Tools Rational Tools Suite, Mercury Tools Suite, Automation Testing tools like Quick Test Pro(QTP), Win Runner, Load Runner.
Application Servers IIS 6.0 / 5.0, Tomcat, APACHE 2.0, Web Logic, Web Services.
Software Packges Microsoft Office Suite, MS Project, MS Visio
Version Control Tools Rational Clear Quest, Rational Clear Case, Harvest.
Professional Summary:
Highmark (BCBS), Pittsburgh, PA Feb 08 – Present
Position: Database Analyst/ QA Tester
Highmark (Blue Cross Blue Shield Health Insurance Company) is one of the Leading Health Insurance Company In United States of America. Highmark Medicare administers the Medicare fee-for-services PART A business for Pennsylvania (PA), Maryland (MD), and the District of Columbia (DC), and Is the PART B Medicare administrative contractor for Maryland (MD), Delaware (DE) and the District of Columbia metropolitan area (DCMA).
Responsibilities:
• Involved in creation of Test Plans, Test Cases, Developed Test Scripts, Preparing Traceability Matrix and Created Test Data.
• Involved in analyzing the business requirement documents (BRD),Functional specification documents(FSD) to prepare test cases and Involved in creating data Requiremnts.
• Involved in all phases of Bug Life cycle and managed defects, logging defects, logoff defects, contacts module etc.
• Contributed to preparation of test cases as per the functionality using Business requirements and Use cases, executing the test cases
• Managed Requirements, Test Plans, and Test Cases using Test Director/Quality Center and worked with Rational Tools Including Clear Quest and Test Manager
• Implemented enhancements in existing applications using Oracle and PL/SQL and using Oracle Technologies, Oracle 10g/9i, Sybase 12/11.
• Developed various forms of Joins, Indexing and Index Design and Optimization and created various Indexes, Bit Map and B-Tree Indexes.
• Worked on Query Optimization by using performance Utilities like Explain Plan, TK Proof, Stats pack, Oracle Hints and Improved query performance.
• Interacted with DBA`s and suggested them to created Index`s(Bit-Map and B-Tree) on specific columns In a table which resulted In great query performance.
• Involved in Database Design, Data Modeling, Data Dictionary Creation using tools like Ervin, TOAD etc.
• Involved in Database design with Logical Database Design and Physical Database Design.
• Developed/ Created Test Scenarios, Test Plans, Test Procedures, Test cases, Test Scripts, Test Data for the Applications.
• Developed PL/SQL- Packages, Procedures, Database Triggers and SQL Scripts to populate the historic data in the tables applying business logic and
• Written many database triggers for automatic updating the tables and views and Involved In Enterprise Database Architecture on Oracle Platforms.
• Created a procedure to load the data from excel, CSV files Into Targeted Oracle Tables.
• Wrote complex SQL Scripts and was responsible for Performance tuning of such SQL Queries and Involved in tuning of some interfaces (Stored packages/procedures/functions) to speed up the process.
• Using utilities like SQL*Loader and PLSQL Code loaded conversion data from legacy sources.
• Worked with Quick Test Professional QTP for Automation of Test Cases and for Record, Playback, working with Check Points etc.
• Worked with Load Runner for Performance Testing, Created Virtual Users (Vusers), determined Maximum load, Break Point.
• Actively involved in System Integration testing on the client as well as on the users end
• Actively involved in all phases of Unit and System Testing including UAT.
Environment: Quality Center, QTP, Load Runner, Test Director, Rational Clear Quest, Rational Tools Suite, Oracle 10g, SQL, PL/SQL, SQL*PLUS, SQL Navigator, UNIX and Shell Scripting, Toad, SQL * Loader MS Visio, Lotus Notes.
University of Stratford, Fairfax, VA Jan 2007 – Dec 2007
Position: Database Programmer/QA Analyst (Research/Technical Assistant)
The Project is about Payment gateway project (E-Commerce) that uses the software developed by Commerce One which runs on a UNIX platform. It is a product designed to provide the merchant with a financial gateway from their web site to the financial acquirer for the purpose of card authentication, authorization and settlement. It allows the merchant to perform on-line authorization and settlements with financial acquirers in a secure and reliable environment. For the purchaser, it provides a highly secure and efficient method for purchasing goods over the Internet using a card for payment. Payment gateway application accepts card authorization requests from the merchants system and automatically handles the dialogue with the financial acquirer. Settlement of the transaction may take place immediately or as a separate process.
Responsibilities:
• Involved in analyzing the business requirement documents (BRD),Functional specification documents(FSD) to prepare test cases and Created Test Data and Worked on Data Mapping.
• Created many Training Documentations for Quality Centre, Test Director, Test Director, Win Runner, Clear Quest and for Load Runner.
• Worked with Mercury Tools Including Quality Center, QTP and Load Runner and worked with database like Sybase and Oracle 11i/10g.
• Created many Training Documentations for Quality Center, Test Director, Test Director, Win Runner, Clear Quest and for Load Runner and worked on Data Mapping.
• Involved in preparing Test Plans and developed Test Scripts based on Business Requirements.
• Authored Test Cases in Quality Center after the analysis of Requirements / Use-Cases.
• Performed Functional and Regression testing, Regulatory Testing using the various checkpoint features in QTP.
• Conduct load and Stress testing using Load Runner and provide input into capacity planning efforts.
• Parameterized data using Data Driver Wizard for Test Script reusability across various Test Modules.
• Worked with Oracle/SQL Server databases for backend testing and database testing.
• Successfully implemented enhancements in existing applications using Oracle and PL/SQL and using Oracle Technologies, Oracle 10g, Sybase 12.
• Developed/ Created Test Scenarios, Test Plans, Test Procedures, Test cases, Test Scripts, Test Data for the Applications.
• Worked on Query Optimization by using Performance Utilities like Explain Plan, TK Proof, Stats Pack, Oracle Hints and Improved query Performance.
• Worked on tuning queries using table Joins and Used PL/SQL to Enhance Performance.
• Involved in Database design using Logical Database Design and Physical Database Design.
• Worked with Source Control and Source Management tools like CVS, VSS (Visual Source Safe) and Harvest.
• Involved in Database Design, Data Modeling using tools like Ervin, TOAD.
• Involved in creating/modifying stored procedures/functions/triggers and wrote SQL scripts to populate the historic data in the tables applying business logic.
• Written many database triggers for automatic updating the tables and views.
• Wrote complex SQL Scripts and was responsible for Performance tuning of such SQL Queries.
• Developed many User Interfaces based on Web standards that are supported by all major browsers.
• Using utilities like SQL*Loader and PLSQL Code loaded conversion data from legacy sources.
• Implemented Export/Import Oracle utilities to move data to different testing environments.
• Actively involved in System Integration testing on the client as well as on the users end
• Actively involved in all phases of Unit and System Testing including UAT.
Environment: Quality Center, QTP, Load Runner, Rational Clear Case, Rational Test Manager, Oracle 10g, MS Visio, MS Office 2003, PL/SQL, SQL Server 2000/2005, SQL*PLUS, TOAD, UNIX and Shell Scripting, Ervin, Toad, Oracle Forms 4.5/6i, Reports 10g/6, Business Objects , SQL * Loader MS Visio.
Harsha Informatics, Tirupathi, India Jun 2005 – July 2006
Position: Programmer/Tester
The Project is about Transaction Tracking which is basically developed for a bank sector. This system keeps the track of loan booked against the each customer for the transactions done each month. This system holds all the details of the transactions done by the customer from the loan booking till the loan liquidation. Also, system generates Reports for all kinds of enquiries, like the Billing, Monthly statements, Liquidations, and Disbursements etc, made by the customer.
Responsibilities:
• Developed Test Plans, Test Cases, Test Scripts, Test Strategy, Test Scenarios and Test Reports and testing applications by Unit Testing, Integration Testing, and Regulatory Testing.
• Involved in all phases of Bug Life cycle and Managed defects, logging defects, logoff defects, contacts module etc.
• Created many Training Documentations for Quality Centre, Test Director, Win Runner and for Load Runner.
• Reported defects using Test Director, Test Manager and interacted with the development team to resolve any defects/issues and worked with Rational Clear Quest.
• Performed manual testing by Unit Testing, Integration Testing and Automated Testing for the test cases.
• Managed Requirements, Test Plans, and Developed Test Cases, Developed Test Scripts using Test Director/Quality Center
• Performed data validation- using SQL and Created many stored procedures and Database Triggers using Sybase, Oracle 11i/10g and SQL Server 2000/2005.
• Performed Integration, Regression, UAT and Database testing.
• Responsible for updating and maintaining Test Director for all the defects found during functional and regression testing and follow up the bug life cycle.
• Wrote stored procedures and developed packages using PL/SQL, Utilized cursors, global variables, indexes and collections during the development of PL/SQL code and using Oracle Technologies, Oracle 10g, Sybase.
• Written many database triggers for automatic updating the tables and views.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Involved in Database design using Logical Database Design and Physical Database Design.
• Developed/ Created Test Scenarios, Test Plans, Test Procedures, Test cases, Test Scripts, Test Data for the Applications.
• Worked with Source Controls and Source Management tools like Clear Quest, Clear Case and Harvest.
• Using utilities like SQL*Loader and PLSQL Code loaded conversion data from legacy sources
• Worked with Automation Tool QTP for automation of test cases and for record and playback.
• Worked with Load Runner for Load and Performance Testing, created many VUsers.
• Actively involved in all phases of Unit and System Testing.
Environment: Quality Center, QTP, Load Runner, Rational Clear Quest, Win Runner, Rational Test Manager, Oracle 10g, MS Visio, MS Office 2003, PL/SQL, SQL Server 2000/2005, SQL*PLUS, TOAD, UNIX and Shell Scripting, Ervin, Toad, Oracle Forms 4.5/6i, Reports 10g/6i.