SUMMARY

• Over 8 Years of IT experience in Software Testing, development and implementation of software projects including around 9 years of experience in implementation, customization and testing Oracle Applications, worked on OM, PO, AP, AR, and GL modules.
• Manual testing and Automated testing - of client-server technology and Web Based, Client/Server environment, N Tier, e-Business Applications & Web Technologies under multiple platforms using QuickTest Professional and Quality Center.
• Proficient in writing PL/SQL Procedures/Functions, Stored Procedures and Triggers.
• Expertise in data integration, data migration into Oracle databases using SQL*Loader and data conversion from legacy system into Oracle Application using PL/SQL.
• Proficient in database and query performance tuning.
• Worked on Sev 1, 2 for production break fixes including working on oracle online web conferences and coming up with resolutions and performed correct test plans and setups based upon the issue discovered.
• Devised and tested the chart of accounts including the control account and performed the variance analysis
• Worked on QTP automation and scripts design for automation in the 1st assignment.
• Discoverer3i/4i/9i, Workflow2.6, Oracle 10g/9i/8i/8/7.x, UNIX, Linux, and Shell Scripts and Oracle Applications (Financials, Manufacturing and Sales & Distribution modules).
• Ability to read understands Design Documents and Functional Specifications leading to the writing of test plans/Test scripts.
• Involved in Functional, Regression, Black box, White box, System Integration, system, Back-end and User Acceptance Testing of client server application/web application.
• Extensive knowledge and experience with backend database testing using complex SQL queries to validate content-including Inner Joins, Outer Joins, unions etc.
• Excellent knowledge develop and executing of Functional Test plans and Test scripts according to the functional design document.
• Knowledge in Black Box Testing and white box testing of the application.
• Hands on experience in writing Test Scripts in QuickTest Professional and WinRunner.
• Excellent knowledge in back ends testing using SQL navigator, TOAD
• Excellent communication skills and a good team player.

TECHNICAL SKILLS

Oracle Tools: Reports 2.5/6i/9i, Forms 4.5/6i/9i, Discoverer 4i/9i, Developer 2000/6i/9i, Oracle 8i/9i, JDeveloper, QA Framework, Languages SQL, PL/SQL, UNIX Shell, VB Script, XML, Visual Basic

Databases: ORACLE E - Business suite 10g, 11i, R12, MS SQL Server 2000, 2005, Mainframe, web and mid-tier

Servers: Web Logic Server 4.5.1-9.2, IIS4.0-6.0, Web Sphere 5-6.0.

Other Tools: Toad, ETL, SQL Loader, SQL Query Analyzer, Seagate Crystal Reports

Testing Tools: Mercury Quality Center, Mercury Quick Test Professional, Mercury WinRunner, Mercury Test Director, Mercury Load Runner, Clear case and Rational Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle Functional Analyst

Responsibilities:

• Analyze the business requirements and functional specifications for creating Requirements Traceability Matrix (RTM) and testing of the major modules like Account payables, Account Receivables, General ledger, Purchasing and Federal Admin modules that are being implemented in HIGLAS.
• HBX system, JIRA and JAMA with hands on knowledge
• Working closely with CMS (Center with Medicaid and medical services) and HHS (Health and Human Services)
• Involved in making the detailed Oracle Financials Test Plan regarding the scope and focus of the testing.
• Testing the production fixes of Setups, Data fixes, Month End Data fixes, Code Changes, Patch testing (Oracle, Autosys, Websphere), AutoSys (Configuration validation for the changes), Websphere (Negative testing, Segment validation, Toad database validation includes Audit tables, task table, error table and staging tables)
• Round trip testing for the following inbound interfaces 271, 274, 811R, 811S, 837, 810 and outbound interfaces of 835 and 811V. Inbound and Outbound interfaces will be processed as part of the daily work basis.
• Performing regression Test suit (Automation), Round trip validation with Treasury for NTDO related changes, Performance Engineering reviews and approvals.
• Testing the database using SQL queries
• Involved in the functional testing using Mercury Quality Center
• Involved with all phases and stages of software life cycle including end-to-end system testing and business requirements analysis.
• Proactively involved in identifying and troubleshooting the data /code related issues.
• Coordinated the Development team and conducted and participated in status meetings.

Environment: Oracle11i, R12 &10g, Autosys, Websphere, Unix, SQL, TOAD, Mercury Quality Center, Mercury Quick Test Professional, Rational Clear Quest, Rational Clear Case, Eroom and Remedy

Confidential

Oracle Functional Analyst

Responsibilities:

• Prepared Functional and Technical Requirement Specifications based on the Business Requirement Documents.
• Tested the AP, AR, GL, PO, APA and Fed Admin modules
• Involved in data validation and database integrity testing through creation and execution of SQL statements
• Writing and Executing Test Plans and Test Cases for testing the financial modules.
• Interacted extensively with the end-users to understand and define a precise accounting flex field structure in Oracle General Ledger
• Involved in making the detailed Oracle Financials Test Plan regarding the scope and focus of the testing.
• Involved in creating Oracle Financials Testing Strategy document.
• Written generic and negative test scripts for AP, AR, GL, PO, APA and Fed admin modules
• Tested the Setup suppliers, Created Purchase Requisitions, Purchase orders in Oracle Purchasing.
• Tested the Setup Account Payables, Setup Payment terms, invoice distribution, matching of invoices against PO
• Tested the production fixes of Setups, Data fixes, Month End Data fixes, Code Changes, Patch testing (Oracle, AutoSys, Websphere), AutoSys (Configuration validation for the changes), Websphere (Negative testing, Segment validation, Toad database validation includes Audit tables, task table, error table and staging tables, 824S Validation for inbound and outbound, dataflow validation test from Websphere to oracle tables, round trip data and file transfer validation), Loans, Letters, and HTB
• Performed Admin accounting testing on Inbound File loadings, Validation of data, Validation of CANs, Expenditures and Obligations, Transfer and Postings of the above, Configuration validation changes if necessary, Vendor/Customer Interface validation, admin accounting Automation Regression suit execution
• Round trip testing for the following inbound interfaces 271, 274, 811R, 811S, 837, 810 and outbound interfaces of 835 and 811V. Inbound and Outbound interfaces will be processed as part of the daily work basis.
• Regression Test suit (Automation), Round trip validation with Treasury for NTDO related changes, Performance Engineering reviews and approvals.
• Tested the Set Of Books Definition, Cross Validation rules, accounting Flex Field definition, accounting calendar definition, accounting flex field value sets, Journal Entry and Journal Posting Functionality, complete flow of Journal entries, revaluation function in GL, Auto Invoice Interface, Accounting and Invoicing rules, Invoice Workbench, Receipt Workbench
• Tested the database using SQL queries
• Managed requirements using Test director and HP Quality center
• Involved in the functional testing using Quality Center and Win Runner
• Involved with all phases and stages of software life cycle including end-to-end system testing and business requirements analysis.
• Participated in the Unit and Integration Testing along with the end-users
• Proactively involved in identifying and troubleshooting the data /code related issues.
• Coordinated the Development team and conducted and participated in status meetings.
• Excellent knowledge in the QA Defect flow.
• Escalate Critical defects immediately and the responsible person notified.
• Set up data for re-testing, and re-test defect fixes.
• Revise test cases, if needed
• Track and close defects after re-testing these.
• Identify defects which are of performance-impacting nature, for taking up in performance test.
• Critical Success Factors” followed to achieve the best Quality
• Timely Reviews and Signoffs -All process owners to give timely inputs, review comments and signoff on deliverables.
• Infrastructure Availability - All Infrastructure components (Network links, Test Environments, Testing tools etc.) must be available as per project plan so as to avoid loss of work for large section of project teams.
• Early testing, planning and coordination with teams involved to maximize timely and cost-effective testing.
• Collaborative Team structure with clear roles and responsibilities.
• Preparing automation test plan
• Knowledge in creating new action, nesting, Inserting to the existing action.
• Created Data driven regression test scripts by parameterizing values in steps and check points.
• Knowledge to enhance the script after recording by descriptive programming.
• Extensively used reusable action scripts for regression test.
• Created scripts to check the Output values.
• Created scripts to query the database, to verify whether data’s are updating properly in the database.
• Very good Knowledge in Analyzing test results.

Environment: Oracle11i &10g, AutoSys, Websphere, OWB (Oracle Warehouse Builder), OracleBI Discoverer 10g (10.1.2.1), MS SQL Server 2005, SQL, PL/SQL, XML, TOAD, Mercury Quality Center, Mercury Quick Test Professional, Mercury WinRunner, Mercury Test Director, Mercury Load Runner, Rational Clear Quest, Rational Clear Case, AutoSys

Confidential

Oracle Functional Analyst

Responsibilities:

• Working through the entire software development life cycle from QA standpoint.
• Analyzing functional requirements, and technical specifications on a wide range of applications.
• Interacted with the Users for requirements and involved in the test data model design compatible for Oracle Applications tables.
• Tested the PO,GL, AP, AR, INV, OM, FA, Fed Admin modules
• Involved in data validation and database integrity testing through creation and execution of SQL statements.
• Created test cases, test plan for testing the financial modules.
• Writing and Executing Test Plans and Test Cases across distributed systems and networks
• Tested the database using SQL queries.
• Created Discoverer Reports for Purchase Orders using Oracle Discoverer 10g.
• Involved with all phases and stages of software life cycle including end-to-end system testing and business requirements analysis.
• Developed interface program to import items from the legacy system to Oracle, Developed validation programs to validate the data before loading into interface tables.
• Designed, developed, Tested PL/SQL packages to validate and import the legacy invoice data into Oracle Receivables.
• Successfully loaded the data available in the interface tables Employees, Receivables, Payables, Customers and Item Safety stocks of Oracle Applications.
• Participated in the Unit and Integration Testing along with the end-users
• Proactively involved in identifying and troubleshooting the data /code related issues.
• Coordinated the Development team and conducted and participated in status meetings.
• Involved in Functional, Regression, Black box, White box, System Integration, system, Back-end and User Acceptance Testing of client server application/web application.
• Interacted with Business Analyst and Developers to under stand the business flow and Technical Interactions.
• Strong analytical knowledge to trouble shooting the application if there is an issue in application.
• Coordinating with client for Change request and Enhancement in the application.
• Interacted/Present in the client meetings and weekly reviews.
• Involved in weekly QA meetings with QA members and Project leads.
• Developed Test plans and Functional test scripts and smoke test scripts based on the business requirement.

Environment: Mercury Interactive - Quick Test Professional 9.2, Oracle 11.5.10, Mercury Quality Center, Web, Mid tier, .NET, Windows XP. Windows 2003, Crystal Reports, Active PDF, ClearCase, ClearQuest, SQL query Analyzer, Oracle - SQL editor, Microsoft Visio. Microsoft Power Point.

Confidential

Software Engineer

Responsibilities:

• Involved in the development of MFC UI threads in Wind/U using C/C++.
• Did version management using clear case to get the final source to be built.
• Implemented COM/DCOM functionality in Wind/U.
• Performed various levels of testing (unit testing, functionality testing, integration testing, system testing).
• Participated in Xprinter3.3.1 development.
• Provided fixes for many customer issues under QFE.
• Implemented many Xprinter APIs to provide postscript printing.
• Involved in the design and development of eXactML application.
• Developed XML parser in C++ based on DTD & Schema.
• Involved in developing many test cases for eXactML and involved in testing.
• Achieved certificate from VP, Engineering, Bristol technology, CT for excellent job.
• Developed XSL style sheets to view the generated XML files by eXactML.

Environment: C, C++, UNIX (Solaris, HPUX, AIX & Linux), Win32, MFC, X/Motif, Shell scripting, COM/DCOM, Postscript/PCL, XML, XSL, DTD, Schema, Perl & flex/bison.