Testing Oracle
Resume:
Sadagopan Seshachalam
Contact: 678-***-****
Email: ************@*****.***
___________________________________________________________
EXPERIENCE SUMMARY:
. 7 years of experience on Oracle financial QA testing.(E-Business
Suite) FA, PO, OM, INV, A/R, A/P. G/L.BOM, WIP,I Procurement.
. 3 Years of Structured Integration, System and Performance Testing
experience in Financial,(A/R, A/P. G/L) Health care Insurance
Banking, Manufacturing, Departmental Warehouse Management System,
Human resources in a Client Server/Environment, /ERP/Oracle.
. Internal users and external customers can view bills online using
Oracle Receivables, Oracle receivables, Oracle Collections. or other
calling application.
. Interacted with Functional and Technical Teams in highlighting
deficiencies
. Prepared Test Plan Formulation, Test Scripts and Test Cases for each
test cycle.
. Participate in the analysis, development and review of test plans,
test cases
. Manual and automated test script design and development using
Winrunner, Testdirector, Loadrunner, QTP 9.2, Quality Center. CVS
Version control.
. Hands on experience in designing manual test scripts and Test
development life cycle . creates and updates defect tracking logs and
works with development teams to ensure that all defects
. Involved in Database testing using SQL Statements and Queries.
. Experience in testing under Windows 95, 98, 2000, NT, XP, IBM
Mainframe and Unix environments & Sunsolaris
. Experience in testing various methods including Validation,
Verification, Functional, Integration, End to End testing
Performance, Graphic User Interfaces (GUI), Regression, System,
Recovery, Volume, Load and Stress, UAT
. Involved in Black Box, Grey Box and White Box testing.
. Experienced in understanding Test plan. QA Process, SDLC and other
methodologies Solid understanding of relational databases and SQL.
. Creates and maintains test plans and scripts, and carries out hands-on
testing efforts both manually and using automated test tools.
. Good troubleshooting skills and excellent communication skills.
. Experience in writing validation code i.e. SQL statements for data
selection.
Languages C,C++, SQL, PL/SQL, TSL and Linux,
Unix Shell Scripts
ERP Oracle Financials 10.7/11/11.5.10, R12
Oracle ERP modules A/P, A/R, FA, GL,,CRM, Order
Management, OTC,P2P, HR Benefits,
Install base and Manufacturing,
Warehouse management. procurement, I
Expenses,
Databases DB2, Oracle, MSSQL, and MS Access.
Operating Systems Windows95/98/NT/2000,XP, Unix, Linux
and Solaris.
Testing Tools Compuware, Winrunner, Testdirector,
Quality center Loadrunner, QTP 9.5,
Silk Test, Rational Robot.
Business Tools MSWord, MS Excel, MS Power point & MS
Project, Visio, VB scripts
Defect Tracking Tools BugZilla,Test Clear Track pro, Clear
Quest, Mercury-Test director, Quality
center.9.5
Web Technologies HTML. XML, VB scripts
Graphic Tools Photo Shop
Reports Crystal reports
PROJECT EXPERIENCE
Wellsfargo Bank Winston Salem NC
May '10 - Present
ETL QA Analyst
CUSTDW (Customer Data Warehouse) is an existing data warehouse containing
heterogeneous data of Wells Fargo Legacy Customers using wholesale/Treasury
Management products. Currently the Wachovia accounts are employed to this
data warehouse to help Merger Transition Customer View team to serve
customers better. The CUSTDW development team has provided the even driven
framework to support ongoing merger activity in order to convert customer
accounts based on predefined Business Rules.
.
RESPONSIBILITIES
. Involved in testing of Back End functionalities for different core
processes to verify business constraints, Data Validation using SQL.
. Performed Software development life cycle process, developed the
system test plans by interacting with cross-functional team to meet
end user requirements.
. Reviews and validated QA Test Plan with functional test scenario using
testing methodology by reviewing all test scenarios with
internal/external team.
. Involved with developer to understand design of application, process
flow and assist development team in unit testing.
. Prepared documentation on validating Business Rules/Criteria in forms
metadata and helped other team members to understand the whole
process.
. Validating metadata used for various core processes.
. Performed sanity testing using post installation check using release
notes and identified installation or code initial problems.
. Communicated with Project Management to establish LOE of each phase of
SDLC and planned testing strategy with peer team.
. Involved at performing various Manual Feeds by validate data using
SQL.
. Identified business requirement gap with customer level and involved
in impact of functionality of application.
. Worked independently with the users for requirements gathering and
prepare Functional specifications.
. Performed defect analysis to identify root cause of problems and
interact with appropriate team and resolved outstanding problems.
Discussed blocking defects with team.
. Assist production support team on release night to complete the
testing.
. Performed regression testing for various modules and core processes to
ensure the overall functionality.
. Created data modifications test scripts for several test scenarios to
perform negative testing.
. Involved in System Integration testing with external & internal
interface team and performed E2E Testing.
. Provide data for SIT and tested all interfaces to make sure
functionalities supports E2E.
. Assisted Production support team to resolved production issues,
trained team to develop cross-functional ability.
. Developed plan for cross-functional training with team for knowledge
transfer.
. Attended most of the meetings involved the discussion of new
requirements/changes in existing functionalities and shared my
thoughts to provide best approach to achieve the goal of organization.
ENVIRONMENT: Oracle 10g,Microsoft SQL Server 2000/2005, Toad, SQL
Developer, UNIX, MS Office Tools, SharePoint. Toad 10.5. Quality
center: 10.5, UAT, SIT, Production Testing
Global Payments, Atlanta, GA
Sep '08 - Mar '10
QA Analyst
. Analyzing business documents like, functional, technical and Test
plans.
. Responsible for gathering information from client, customers, core
users regarding the data and business processes and made proper
documentation.
. Participated in all phases of Soft ware development and Software
testing life cycle.
. Execute and Maintain QTP scripts
. Analyzing business documents like, functional, technical and Test
plans.
. Developed and executed different work products Quality Center.
Requirement maintenance, Test plan, Test Suite and execution. Design
and execution of test strategy, test plan, test cases
. Plan & prioritized manual and automation activities and design and
developed Automation Test Scripts and manage the testing activities
using QTP
. Developed the Data Driven Framework for maintaining the automation
scripts.
. Reusable functions to increase the reusability in the automation.
. Created Data Driven Tests to validate the same scenario with different
test data.
. Scheduling and allocating work amongst the team members, ensuring
deliverables in time.
. Developed the strategy for Manual Testing of the application and
tested the strategy to be client compliant.
. FA: Functional testing of various scripts, Asset manual, quick
Additions, CIP Assets, Load ADI Assets (Application Desktop
Integrator), mass additions, create JE and reconciliation with GL,
Retire and re-instate assets, Depreciation,. Transfer of Various
Assets.
. Cash Management Inbound outbound testing: Loading bank statement
interface file through FTP, upload files for Asia and Pacific region.
. HP QTP version 9.2- Debit card reconciliation testing of various
automated scripts. Recording and Enhancing scripts and creating
scripts. Automated testing using the tools Quick Test Pro, Quality
Center to run both manual and automated scripts. Enhanced Test Scripts
using QTP features like checkpoints, Synchronization points and
parameterization..
. Write SQL queries to perform data validation and also wrote queries
for Log table and Validate that all order Counts are as expected
compare to production. Joints- Union, Intersect and minus. Multiple
sub queries, Loops, Triggers
Environments: Oracle version 11.5.10 and R12. UNIX, Operating system: sun
Solaris, Database: Oracle 9i Release 2, Toad, SQL with Agile experience.
QTP Version 9.2 and VBScript.
Xerox Corporation, New York
Jul '06 - Sep '08
Lead QA Analyst.
CRM application: Worked with 6 offshore resources. Coordinating to
accomplish the job and collecting daily matrix report.
. Creating a DMA (Document Management Agreement) contract database
application CDB (Xerox service contract database)
. Create Performance test scripts using Load Runner.
. XONE application performance test by executing the load runner scripts
to get the contract Unit and contract numbers.
. Automated Flex contract is for creating line and service contracts
and for creating service, labor, equipment, units and pool contract.
Service Contract, Install base bring this into Oracle XONE
application. Creating workup sheet in value quix, Enter service, meter
reads and allowance. Correct the contract error and approve from the
controller.
. Match and post the contract order from flex process through telnet and
enter to Oracle database. Did regression test using Load runner.
Manufacturing -Purchasing -P2P
. Creating Test plan. Analyzed SRD and BRD and wrote test cases in
Purchase Module. Worked on validating end to end flows and
interfaces. White box testing, UAT testing, Invoice Transaction
coming from Account payable is tested through interface and view
results in web methods. Test conducted on multiple organizations.
Requisition, Purchase order, Receiving, Blanket purchase agreement.
Validation of Purchase order, I procurement, PO print, PO EDI and PO E-
mail purchaser. Checking the purchase order in Approved supplier list-
Item is purchasable, approved, stock, enabled and Assigned to an
organization.
. A/R: Testing Address validation, Receipts, Adjustments, Invoices
Checking the reports.
. A/P: Testing Supplier information, PO. Import invoices, Payments-
online, cash, wire payments, PO header, lines, distribution, releases,
credit card payment.
. WIP testing: Discrete, Assembly, Repetitive manufacturing, Assembly to
order. Shop floor control- Assembly moved to shop floor and
controlling. Supply chain module and warehouse Transport management.
. WMS Cycle Count . Internal Order. Internal Requisition. Job or
Schedule. Move Order. Purchase Order. RMA. Sales Order
. OTC: Testing the following - Entering the order, booking the order,
scheduling the order. Pricing. Testing the line item, pricing list and
modifiers.
. TOAD: Querying the date from the front to backend using select command
and comparing the results using SQL.
Environments: Oracle version 11.5.9 Operating system: sunsolaris, Database:
Oracle 9i Release 2, Toad.
Oracle Apps Modules tested: A/P, A/R, and CRM, Install base and
Manufacturing & WM Automated tool like Loadrunner 9.0 & QTP 8.2 and Test
Director Using AIMS Methodology. Agile experience
IBM, NY
Sep '04 - Jun '06
QA Tester
IBM his implementing Oracle Apps 11i Accounts Payable Legacy
Decommissioning from Mainframe to Oracle App
Bank of Nova Scotia: In bound file testing A/P with payment.
Responsibilities. Creating Master test plan: Writing Overview, Objectives,
Goals, Testing data under test environments, system scope, creating Test
plan, Test data, Data strategy
. Developing Test scripts from Functional and Technical documents.
. Common payment engine for outbound and inbound payments.
. Credit Card support - Validation, authorization and funds capture.
. Transmission of Bills Receivable transactions
. Bank account transfer support for Oracle Receivables and Payables.
. Testing all criticality and functions, provide regular status to
project managers, review with developers and technical lead, to ensure
software is properly tested
. Oracle Financial Apps interface and getting reports
. Using Control-M, FTP from Mainframe to UNIX.
. Testing the data under OAAP-Development environment and Testing
environment
Western Union Money transfer: Decommissioning the Mainframe and moving to
SQL Server. Every day A& P store transactions of customer and vendor is
sent to IBM to process and make payment to Western Union and generate
various reports, such as Daily, Weekly, Division and Group reports.
Responsibilities: Creating Master Test Plan. Performing one or more tests,
System/Integration test and performance test and Database testing.
. Testing all criticality and functions, provide regular status to
project managers, review with developers and technical lead, to ensure
software is properly tested, black box testing and UAT testing.
. Smart Database to check the records are stored properly
. Using Control-M, FTP from Mainframe to Unix
. Text data file taking manual Excel sheet to compare the sql server
results
. Testing the data under OAAP-Development environment and Testing
environment
Environments: Oracle Apps 11.5.9, UNIX, Toad 6.5 Hp OS 5.8, Test Director
7.2, Oracle 9i, SQL Server 2000. Agile experience, Iterations
CISCO Systems Inc, CA
Mar '04 - Aug '04
QA Tester
Cisco System implementing Oracle Apps 11i in various modules like Order
Management, Accounts Receivable, Legacy Systems and Boundary Systems. P2P,
Install base & Order Management.
Order to cash: Customers call the order, check the price, check
availability, book order, receive cash, generate invoice, ship confirm and
pick release. Procure to pay: Check the price of the vendor, P.O for
approval and send the P.O to vendor. Matching and paying the invoice,
receive the invoice, item to the shelf or to employee and receive the
shipment
Responsibilities
. Going through various DSD's and FSD's and writing String Test Scripts
for Book Order and Create Order manually.
. Writing E2E scripts and generic scripts.
. Mapping the entire requirement into the Test Case Builder.
Participated in Specification reviews and Mapping Documents reviews
with Technical staff and Business System Associates.
. Uploading all the String scripts and E2E scripts, Generic Scripts into
Test Director.
. Bug fixing all the scripts issues and reports to the management.
. Performed manual functional testing of various business areas.
. Writing SQL queries for fetching data from boundary systems.
Environment: Oracle Apps 11.5.9, Unix Hp OS 5.8, Test Director 8.00,,
Oracle 8i,PL/SQL
CNA LIFE INSURANCE, TN
Dec '02 - Feb '04
QA Analyst
CNA Life Insurance has implemented Oracle Applications 11i and it is
integrated to other widely used legacy applications. They have customized
Interfaces to meet the business requirements and in addition, many
customized Forms and Reports are built in Accounts Receivable (AR) module.
Manually testing Insurance forms.
Responsibilities
. Participated in Specification reviews and Mapping Documents reviews
with Technical staff and Business System Associates.
. Did Extensive testing of the Customized and Oracle standard Reports
before and after Customization.
. Participated in Code review sessions with the developers for
production fixes.
. Executed test Scripts for the Inbound and Outbound interfaces to
Oracle AR.
. Developed SQL scripts to validate the Oracle Interface and Base
tables.
. Performed Functionality testing, Stress testing and Regression
Testing.
. Participated in Production Check outs and Provide QA support for
Production fixes.
Environment: Oracle Apps 11.5.5, Sun OS 5.8, Rational Clear Quest, Sun OS
5.8, Oracle8.1.7.4.
Enterprise-rent-a-car, MO
Apr '02 - Nov
'02
QA Analyst
Enterprise-rent-a-car was in a process of implementing Oracle applications
and it was integrated to other widely used legacy applications. They have
customized Interfaces to meet the business requirements and in addition to
it many customized Forms and Reports are built.
Responsibilities
. Wrote test cases and test plans based on technical and functional
design documentations.
. Wrote Test Cases and Load Test Plans based on Technical Documents been
prepared.
. Developed Load Test Strategy to do performance testing of the
applications.
. Performed Load and Performance Testing of critical areas of Oracle
Applications module by simulating the load on the system using Load
Runner 7.0.
. Performed Load Test of Outbound and Inbound Interfaces.
. Executed test cases created in Winrunner for functional testing
. Used Mercury Test Director for defect documentation.
. Worked on volume testing and stress testing.
. Performed manual functional testing of various business areas.
. Network Load testing was done by generating Network load from various
locations and the entire application was load tested using Load Runner
7.0
Environments: Oracle Apps 11.5.6, Winrunner 7.0 Load Runner 7.0, Test
Director 7.0, Sun Solaris 8, Oracle 8, UNIX.
Spencer Savings Bank, NJ
Mar '01 - Mar' 02
QA Tester
This was an application developed for a commercial bank. The complete
application covered entry of Cash-In, Cash-Out, Loan Approvals, Wire
Transfers, Loans, Financial Cash-flow Statements, Financial Ratio
Statements, Asset, and Equity etc. The product is more focused on Mortgage
Home loan schemes and Certificate of Deposits, Facilitated with Home buy
ability Test and Mortgage calculators. Involved in Testing of Loans and
Certificate of Deposits (Fixed Income) modules.
Responsibilities:
. Written Test Plan and Test Cases using Test Director.
. Created Test Scripts to test the HTML pages according to the Test
Cases. Performed Functional, Regression and System Testing.
. Performed Data-Driven testing using Winrunner.
. Performed Cross Browser, Configuration, Content & Security Testing..
. Used V user Script Generator for writing and debugging automation
scripts for Vusers, monitoring communication between Test application
and server.
. Incorporated Vuser scripts in load Runner Scenario after inserting the
General Function calls.
. Load tested the application with Loadrunner. Analyzed the graphs and
generated Performance reports. Written Database Vuser Scripts and
Performed back-end Testing-using TSL, SQL calls to the database
server.
. Tracked extensive IT testing issues of the whole project resulting
from test execution and categorized according to severity of the
problem.
Environments: WinRunner6.0, LoadRunner6.5, TestDirector6.0.2, Oracle, C,
8.0, PL/SQL, VB 6.0, Windows NT.
Bharath Heavy Electricals Limited. INDIA
Sep' 00 - Jan'01
QA Tester
Time Logging System is designed and developed to record the attendance of
BHEL Employees. This system has got an Administration Module and a Employee
Module. Employees can view but cannot modify the records.
Responsibilities:
. Manually executed various tests before functional testing using SQA
Robot.
. Involved in writing Test plans, Test cases and Test scripts using MS
Word and MS Excel.
. Conducted database testing (Data_ driven_ testing).
. Performed Security testing in different management levels.
. Performed positive and negative testing and tested for boundary cases.
. GUI testing, Black box testing.
Environments: VB, COM, DCOM, Oracle7.3, SQA Robot, Crystal Reports, Windows
95, Solaris, MS Word,MS Excel
.EDUCATIONAL QUALIFICATIONS: M.S Finance and Accounting and Certification
in Computer Applications.
Contact this candidate