OBJECTIVE:

Programmer Analyst in Visual Basic, SQL Server, Oracle and QA Analyst in ETL, Data Stage and database seeking hands on QA Engineering Opportunity in the area of Retail, Banking and Health Care sectors.

SUMMARY:

• Around 11 years of demonstrated ability in Development, coding, testing, analysis, implementation, user training and customer support with strong background in Client/Server applications using ODBC.
• Extensive experience in developing and programming in Visual Basic 6.0/5.0 using DAO, RDO, ADO, Oracle 8.x / 7.x, Oracle PL/SQL, MS SQL Server 2000 / 7.0, MS Access .
• Extensively used Seagate Crystal Reports, HTML, XML, implementing Active - x controls, COM/DCOM technologies in Windows 2000 / NT/XP platforms
• Sound knowledge in POS (Point-Of-Sale) - Registers, Store PC and ISP Server Testing.
• Extensive Experience for 4 years as an QA Analyst using tools like ETL Datastage (Ascential), Oracle. Involved in test planning, creating test cases, preparing and executing test scripts and presenting test results, raising and tracking defects in Mercury/HP Quality Center. Automated test scripts using QTP.
• Good Analytical and programming skills and Excellent Communication/Inter-personal Skills with problem-solving and trouble-shooting capabilities. Interfaced with all levels of management and ability to work individually as well as in a team. Excellent team player and Managed 5 offshore team members.

TECHNICAL SKILLS:

GUI: Visual Basic 6.0 / 5.0 /4.0, Visual InterDev.

Internet: ASP, XML, VBScript, JavaScript, HTML, DHTML, IIS, and PWS

OS: Windows 2000 / NT / 98 / 95 / 3.11, and DOS

RDBMS: MS SQL Server 2000 / 7.0 / 6.5 / 6.0 , Oracle 8.x / 7.x, PL/SQL, MS Access 2000.

Technology: Active-X, COM, DCOM, ADO. Net, VB.Net, ASP.NET

Data-Access Methodologies: DAO, RDO Using ODBC, ADO using OLEDB

Tools: Seagate crystal Reports, Mercury Quality Center, Visual Source Safe, ETL Data stage.

WORK EXPERIENCE:

Confidential

QA Engineer

Responsibilities:

• Involved in Creating Functional Test plans and Test cases for different service Objectives containing web based UI applications. Also involved in validating the data in the database and in the application.
• Involved in performing Test Execution for this test cases in HP ALM Quality Center by updating the necessary screen shots and Actual Test Results and passing them in Test Lab.
• Involved in Raising Defects in case of any issues found during test execution and while performing validation.
• Working with Dev Team to Resolve this issues and also work with Offshore team to assign tasks for them.
• Providing a Sign-off by preparing necessary documents for the stake holders.

Technolgies Used: SQL Server, ALM HP Quality Center, Java, XML.

Confidential

QA Engineer

Responsibilities:

• Involved in Creating Test plans and Test cases for data migration project between two web based applications.
• Also involved in validating the data in the database and in the application.
• Comparing 2 patient charts between the 2 applications and validating patient’s medical record is the key feature of our testing.
• Validating the Unix server logs when issues found. Functional, Regression Testing was performed.
• Was involved in the Successful implementation of the application in 2 different practices.

Technolgies Used: Toad for Oracle, ALM HP Quality Center, JIRA,Putty, Java.

Confidential

Sr. QA Analyst

Responsibilities:

• Acquire locale data - Address Format, phone numbers Format, names for each country and generate a document based on the information collected. Worked on 150 countries.
• Creating xml file containing address layouts for each country and using xslt transform the xml to html output page for keying in the sample valid address.

Technolgies Used: WebStorm- xml Editor, Html

Confidential

QA Tester

Responsibilities:

• Involved in Creating Test cases for various internal web based applications - Shipment Planning, Receiving.
• Executed Test Scripts and Test cases in SIT and UAT environment like Label Printing.
• Raised Defects in JIRA - Defect Management Tool for Tracking Defects. Performed Regression Testing.

Technologies Used: JIRA, SQL Server 2012, Agile Environment.

Confidential Systems QA

Responsibilities:

• Involved in creating Test Plans and Test Scripts based on the business and functional requirements.
• Executing the Test Scripts and writing queries for validation in SQL Developer and capturing the results.
• Validating the Oracle Database after ETL Batch job runs on a daily basis. Involved in testing a loan application.
• Uploading the Test cases and updating the test execution in HP Quality Center.

Technologies Used: ETL, HP ALM Quality Center, Oracle - SQL Developer, QTP, Agile Environment

Confidential, Dublin, CA

QA Tester

Responsibilities:

• Involved in validating different types of card transactions in POS Registers and validating them in the SQL Server present in the ISP.
• Involved in validating different types of store applications including Till balancing and assigning tills to register using Store Back Office and Cash Office PC.
• Involved in validating the different processes and services that are running on the ISP Server which are essential for processing daily transactions and validating them during end of day.
• Testing Markdowns, Receiving, re-ticketing, label printing using wireless handheld PDT guns and the printers.
• Involved in testing isp, store pc and registers using Remote desk top conneciton(RDC) - testing via RCO and RDP(Remote desk protocol).

Technologies Used: POS Systems, Store Back Office/Cash Office PC, ISP Server, PDT Guns, PDT Printers, Store Laser Printer, SQL Server.

Confidential, San Ramon

Sr. QA Engineer

Responsibilities:

• Involved in Testing Different Types of Daily, Monthly Reports for Risk Data Control, Generated from Business Objects.
• Involved in data analysis, ETL Transformation and Mapping and Database Validation (for Transaction Data Mart and Credit Data Mart).
• Created Test Strategy, Test Plans, Test Scripts and Executing test cases for Ad-hoc Reports and for some Data mart in Data warehousing.
• Defects found were raised in Mercury Quality Center.

Technologies Used: Toad for Oracle 10.5, Business Objects, ETL - Informatica.

Confidential, San Bruno

Test Engineer

Responsibilities:

• Involved in POS Testing projects for various brands in Confidential - which includes executing test cases in POS Systems.
• Involved in updating the test cases in Quality center and also raising Defects.

Technologies Used: POS Systems, Mercury Quality Center.

Confidential, Fremont, CA.

Test Engineer

Responsibilities:

• Involved in testing projects for various brands in Confidential - which includes test planning, preparing test cases, test data preparation and test case execution.
• The test cases were prepared using the functional design documents and covers business scenarios and the functionality of each interface.
• ETL Batch Jobs would run on a daily basis and loads data into Oracle Database.
• Each test scenarios were executed and the necessary test results were captured. During execution in case of any issues found involved in raising defects and issues in a tool called Quality center.
• The testing comprises of 2 phases - System testing and integration testing. Involved in both the phases.
• Involved in managing and guiding the offshore team for this project.

Technologies Used: Triggered Jobs using Mainframe, Ascential ETL Data stage v7.5, Oracle PL/SQL.

Confidential, Fremont, CA

Application Support Engineer

Responsibilities:

• Involved in monitoring the daily reports that are generated for customer.
• The reports were scheduled to run on a daily basis in the crystal server which generates an unformatted excel report.
• The software application was developed in Visual basic which was used for formatting the crystal reports as per customer requirement, and data was uploaded and maintained in SQL Server.

Technologies Used: Visual basic, SQL Server, Crystal Server, Crystal reports.

Confidential, Sunnyvale, CA

Quality Assurance Engineer

Responsibilities:

• Involved in doing Data analysis and Maintenance and validating the data in the database.
• Building the reports and Testing the reports generated from Crystal reports.
• Involved in creating Test cases for the same and executing the test scripts.

Technologies Used: Oracle PL/SQL, Crystal Reports.

Confidential, San Francisco, CA

Lead Developer

Responsibilities:

• Creating tables and writing stored procedures and executing them.
• Designing and developing MIS reports. Generating reports using COM+ techniques in Crystal Reports.
• Designing user-access menu and integrating the module.
• Used Visual SourceSafe 6.0 for source code control.Testing the programs, and providing feedback.
• Analyze those errors and help team members in debugging and re-testing, coding.
• Maintaining the record of work assigned, time taken for the development, testing and on the whole completion of the project.

Environment: Visual Basic 6.0, COM+, Crystal Reports Visual Source Safe 6.0, ADO, Oracle 9.0, PL/SQL, Windows 2000 Professional, Windows 2000 Server.

Confidential, Seattle, WA

Lead Developer

Responsibilities:

• Designing and developing the front end in VB and MSXML API’s.
• Report Designing, developing MIS reports and generating these reports using Crystal Reports.
• Testing the programs, by all possible means and giving feedback.
• Testing stored procedures, triggers, packages & functions using PL/SQL.
• User access and team member’s rights and privileges were maintained in the database.
• Maintaining the record of work assigned, time taken for the development, testing and on the whole completion of the project.

Environment: Visual Basic 6.0,Crystal Reports, ADO, Oracle 8.0, PL/SQL, Windows 2000 Professional.

Confidential, SanJose, CA

Sr Architect/ Developer

Responsibilities:

• Tree view structure was built in Visual basic.net. Data is stored in a file and retrieved in tree form.
• The tree view will contain the objects, sub-objects and its tasks; a sequence diagram can be designed from this data, the objects, sub-objects are stored in the oracle database.
• Extensively Used ADO.net for connecting between Visual basic and Oracle (PL/SQL).
• The same has to be ported in java and data is to be stored in XML.
• Used XML Document Object Model (DOM) in a configuration XML file to retrieve the tree back.
• Used OLEDB to connect to the database. Wrote stored procedures, triggers, packages & functions using PL/SQLData stored in oracle database, retrieved using ADO. Net, disconnected record set.
• Stored procedures were executed thru visual basic front end. Triggers were called to verify the data in oracle.

Environment: Visual Basic.net, Oracle 8.0, PL/SQL, XML, XSLT, XML Spy-3.5, Windows 2000.