SUMMARY

• Over 11 years of experience in Information Technology with 7+ years in Software Quality Assurance Testing, using Manual Testing and Automation Tools like Mercury and Rational Tools.
• Professional with extensive experience in testing of large Web & client server, Data warehouse applications and Mainframes in Finance, Investment Banking (Mortgage), Retail shopping, HealthCare Services and Insurance Industries
• Outstanding skills in working on System Development Life Cycle Methodologies (SDLC)
• Extensively involved in end user group discussions to get the system requirements
• Communicated to and coordinated with team members, managed offshore team and conducted triage sessions with offshore team
• Expertise in preparing Test plans, Test Scripts and Test Cases for manual and automated testing according to design specifications and functional requirements of the application
• Adept at backend testing and data validation testing using SQL queries
• Proficient in Functional, Negative, Regression, System, Integration, User Acceptance (UAT),
• Security, Usability and compatibility and configuration testing during the various phases of the development of the application.
• Knowledge of Rational Unified Process.
• Extensively involved in Manual Database Testing using SQL Integration Testing of System Integration testing and User Acceptance Testing (UAT)
• Experience using SQL* Loader, to facilitate data import/export from staging tables to production tables, writing PL/SQL procedures, Cursors, Functions, and Packages.
• Experience in testing Star/Snowflake schemas, Fact and Dimensional tables.
• Complete understanding of Ralph - Kimball and Inmon approaches to Data Warehousing.
• Strong expertise in end to end data warehouse testing.
• Extensive ETL DW testing experience using DataStage and QualityStage 8.1/7.5X.
• Strong expertise in implementing Complex business rules by creating re-usable transformations and Mappings/Mapplets.
• Experienced in testing and debugging Business Objects XIR3.1/2, Crystal Reports 2008/XIR2, user defined queries and reports to enable drill-down and slice and dice analysis on multiple databases
• Strong expertise in writing ANSI standard SQL Scripts
• Experience in working Unix, Redhat Linux and MVS OS/390 environment

TECHNICAL SKILLS

Testing Tools: Mercury Tools - Quality Center, WinRunner, LoadRunner

Rational Tools: Clear Case, Clear Quest

Database: Oracle10g, 9i, 8i, 7.x, DB2, SQL Server 7.0 and MS-Access, Teradata 12

Languages: SQL, PL/SQL, Java

Applications: Oracle E-Business suite (EBS), Oracle Financials 11.5.8 /10.7

Products/Tools: DataStage 8.1/7.5x, Crystal Reports XI&2008 Business ObjectsXIR2/3MicroStrategy Reporting Suite, TOAD, PL/SQL Developer, SQL*Loader, TIBCO, Erwin, Autosys, Cognos8, MS Office, Oracle Forms 6i/4.5, Oracle Reports 10g/6i

Operating System: UNIX, WINDOWS NT/2000, OS/390 MVS, AS/400

Web Development: Oracle 10g HTML DB, XML, XSL, JavaScript and Java/J2EE, Perl Scripts

CM Tools: Clear Quest, Clear Case, PVCS

Business Domains: Finance / Investment Banking (Mortgage), Retail Shopping, HealthCare Services and Insurance

PROFESSIONAL EXPERIENCE

Confidential

Sr. QA Analyst

Responsibilities:

• Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Clear Quest based on the Release Requirements Documents
• Participated in SA’s meetings to keep track of new requirements from the project
• Performed Integration System test (IST), End to End (E2E), D2D Test, Environment Shakeout test, Implementation Shakeout test, regression testing
• Validated outgoing XML messages
• Validated flat files coming from downstream systems and mocked up feed files by using vi editor
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer
• Performed Backend/SQL Test for Insert, Update, and Functions.
• Participated in business requirements reviews and software system (application) designs for testability.
• Connected remotely to UNIX servers using PUTTY and FTP files across different test environments by using Ultra Edit and Command prompt.
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules.
• Reviewed Error log files in UNIX box when order fails to load into SQL tables.
• Attending weekly status calls along with Test leads and Manager

Environment: Oracle 11G, Toad 10.0.0.41, Informatica 9.1, IBM Cognos 8, UNIX, MS Office Suite.

Confidential, San Francisco CA

Sr. QA Analyst\Lead

Responsibilities:

• Gathering requirements and Understanding the functionality of the application
• Participate in review of project requirements to understand test objectives and to provide input on testability of requirements
• Preparing Test Plan and Test Strategy documents
• Create, Verify/Update Test scripts in Quality center
• Worked on backend testing verifying Schema objects like tables, indexes, views, synonyms, Sequences, individual procedure and integration tests of procedures
• Creates and executes efficient SQL queries to validate Extract, Transform and Load(ETL) process
• Interacts with test team and other groups to identify, create, and maintain test data needed to execute test cases
• Perform Execute functionality, system, integration, regression testing
• Raise and track defects in Quality center and provides specific guidance on defects to developers
• Report progress and issues to test management and participates in test team status meetings
• Coordinate/Document actual test results and responsible for the end-to-end tracking of all issues found
• Participated in Reviews, Meetings and seeking clarifications
• Performs Daily status report, Weekly status report, Defects Analysis reports
• Interacted with Business, Technology Leads, QA Managers, Project Manager
• Maintained Daily activity based tracking sheet for tasks assignment
• Handled Daily status calls with Business and Tech leads.

Environment: Oracle 10G, PL/SQL, Toad 10.0.0.41, Informatica 9.1, IBM Cognos 8, Quality Center 10.0, SQL Server 2008, MS Access, Share point, UNIX.

Confidential, Johns creek GA

Sr. QA Analyst\Lead

Responsibilities:

• Understanding of Business Logic and data flow.
• Participated in reporting summary documents reviews.
• Worked closely with developers and report planners/analysts to insure that an acceptance criterion is complete and accurate for desired report capability
• Coordinating between onsite and offshore teams that required serving as a Onsite coordinator and do the necessary knowledge transfer, work allocation to offshore team, testing of work done by offshore team
• Involved in preparing Test plans based on user requirement documents
• Create test data on Mainframes using File Aid and Wrote SQL Quires using QMF
• Testing with Batch programs are compiled and executed using JCL
• Analyzed the data using SPUFI
• Run JCL batch jobs to validated the data on Mainframes
• Created test scenarios and test cases for the functionality, integration testing of the ETL,DDL,SQL and Unix scripts for User Acceptance
• Participated in preparation of test cases for some reports to do the unit testing
• Preparation of test plans, test cases and test scripts using Quality Center
• Performed Black Box, White Box, Positive and Negative testing
• Preparing the test data and populated data into tables for to cover all test scenario in the Application
• Running Data Stage Jobs from Unix environment
• Tested Functionality, Usability, Interface, Compatibility, Performance and security for web-based Business Intelligence reports
• Generating the test execution, other matrix reports from a test plan and test lab from a module of defect tab, Preparation of defect log with screen shots and creating Defect Reports daily base
• Follow on bug fix with up the developer

Environment: Teradata 12, DataStage 8.1, Business Objects XIR2/R3.1, Crystal Reports XI,OS/390 MVS, DB2, JCL, TSO, Quality Center 9.0, PL/SQL Developer, UNIX

Confidential, Washington DC

QA Analyst

Responsibilities:

• Worked in a team with Managers, Programmers and business users to test ETL application based on Oracle back-end & Unix environment and Business Intelligence application based on Java and BEA Web Logic server environment
• Involved in writing Test Plans for SF GAGO Fair Value Application based on Business rules and functional specification documents.
• Involved in writing use cases, test cases and describe the purpose of the test, setup conditions, test conditions needed to produce the pass/fail criteria, and specific instructions on how to conduct the test using Quality Center. write test scripts for the test cases and SQL/Automation scripts for backend validations
• Performed Functional, Navigational, Usability, System, End to End and Regression testing
• Maintaining Bug database by posting bugs, testing bugs, changing the status of bugs and closing the bugs once the bug is fixed through Quality Center
• Wrote Unix shell scripts for file manipulation to aid in testing and to execute Autosys batch jobs
• Performed validation for Cross-tab grid reports, graphs, dashboards (grid-and-graph displays), performance scorecards etc against their underlying tables and cosmetic page layouts after exporting to Excel or PDF etc
• Involved in Internal Review, Tech Review and Walkthrough of the Test Procedures with the Developers, Requirement Management, Testers and Project Quality personnel.
• Worked with the development team to ensure testing issues are resolved

Environment: Quality Center, Oracle11G/10G, SQL, PL/SQL, MicroStrategy Reporting Suite, Autosys, Java, HTML, XML, UNIX, MS Office, Web Logic, Clear Case, Clear Quest

Confidential, VA

QA Analyst

Responsibilities:

• Involved in Business requirements decomposition, assisting QA Lead and Project Manager in Test Strategy development.
• Analyzed the UML work flow designs, interpreting the Test Scenarios and decomposing the functionality into Test Scripts
• Prepared Requirement Traceability Matrix to map the USE case and the Test cases with the requirement from the Design Requirement Document
• Involved in writing test plans, test cases and maintained them using Rational Clear Case.
• Performed web based applications testing and involved Functional, Integration, Navigational, Hyperlink, System and User Acceptance testing.
• Tested the application on different browsers like Internet Explorer 4.0/5.0, Netscape 4.0/4.7, AOL, Mozilla on different platforms like Windows 95/98/NT, Macintosh and Linux operating systems.
• Used Clear Quest for reporting the defects on a daily basis.
• Performing regression testing to test the functionality of the application after the bug fixing.
• Reported the test execution status in the Bug Review Meetings on a weekly basis with the project group.

Environment: Manual Testing, Rational Clear Case, Rational Clear Quest, Oracle, OS/390 MVS, DB2MS SharePoint, Windows 2000, Sun Solaris, Web Logic, Java J2EE, Web Methods.

Confidential, Chicago, IL

Oracle Developer

Responsibilities:

• Involved in requirement analysis
• Analyzed logical, physical and dimensional model for Confidential Insurance to understand the table structure with the help of Erwin
• Prepare/review BRD, FD and TD document. Meet the business users frequently to asses the effectiveness of the solution, requirement definition/improvements, status updates, design, project reviews and scope creep resolutions. The role involves extensive business and IT interactions.
• Work with both Relational and Dimensional data models. Handle STAR Schema design, ETL Strategy and Data-replication from ODS. Work with dimensions, hierarchies, levels, measures, aggregations and fact table granularity.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum
• Created and Scheduled Sessions and Workflows based on demand, run on time, run only once using Informatica Workflow Manager
• Utilized SQL*Plus to display data and to create grants, table space, and tables for unit testing
• Perform Design level and SQL performance tuning, code review, work with materialized views, partitioning, indexing strategies, de-normalization and other techniques to improve performance

Environment: Oracle 8.1, Informatica 6.1, Cognos 7, Linux, Erwin, Toad, SQL, PL/SQL

Confidential

Oracle Developer

Responsibilities:

• Developed GL Interface Program for migrating journals from legacy systems to oracle.
• Loaded data from Legacy system to Flat files using Database Exports. Populated staging tables using SQL Loader.
• Developed custom PL/SQL procedures to validate the data in staging tables and transfer them to GL INTERFACE table.
• Creation of Concurrent executables and Concurrent Programs for reports.
• Developed Various Custom Folders using SQL queries in Discoverer.
• Trained users on how to create adhoc reports using the Discoverer Desk top.
• Registered the Oracle Functions with Discoverer and imported them into Discoverer End user Layer.
• Developed many Work Books in different modules like Accounts Receivable, Accounts Payable, General Ledger and Fixed assets.
• Incorporated various Discoverer features like Items, Calculations in the Work Books.
• Scheduled Discoverer Work Books to run at Regular Intervals.
• Extensively developed reports using ORACLE DISCOVERER TOOL.
• Printer setups for the DISCOVERER tool.

Environment: Oracle Applications(11.5.8), Oracle 8i, PL/SQL, SQL*Loader, SQL Plus, SQL*NETOracle application server OAS8.0, TOAD, Discoverer4i, Oracle Reports 6i, Oracle Forms 6iOracle XML Publisher, AIX UNIX and FTP