SUMMARY

• Over 7+ years of experience in manual testing on web based, Client/Server and data warehousing applications.
• Well - versed with all stages of Software Development Life Cycle (SDLC ) and Software Testing Life Cycle (STLC ) with good working knowledge on testing methodologies, disciplines, tasks, resources and scheduling.
• Professional experience in SQL, Metadata, Functional, Regression, BI Testing, UAT Testing and GUI testing.
• Extensive ETL testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) and other ETL Processes (Data Warehouse Testing )
• Extensive Experience in SQL and PL/SQL scripting.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema . Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in using Bugzilla, Test Director and HP Quality Center for Bug Tracking and Defect Reporting.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in working with Software Development team in resolving Defects, presenting Defect Status reports, resolving requirement, and observed design inconsistencies.
• Experience in Reports testing in Crystal Reports XI Environment.
• Strong working experience in Windows NT/2000/XP and UNIX environments.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Experience in Web based applications like online banking, transactions applications.
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Linux, Sun Solaris

Languages: SQL, PL/SQL, UNIX Shell Scripting

Bug Reporting: Mercury Test Director 8.0, Rational Clear Quest, HP Quality Center 11.0, Bugzilla

Databases: Oracle 9i/10g/11g, SQL Server 2005/2008

ETL Tools: Informatica Power Center 8/9

Database Tools: TOAD, SQL Developer

Reporting Tools: Crystal Reports 10.0/XI R2, OBIEE

PROFESSIONAL EXPERIENCE

Confidential,Santa Monica,CA

Senior ETL Analyst

Responsibilities:

• Wrote SQL validation scripts and executed SQL stored procedures to validate the output data.
• Create Validation Views for various scenarios on top of LOAD tables and validate the data in these Views.
• Extract data files from HP, convert EBCDIC files to ASCII format and place the ASCII files in Informatica Server
• Loading the files onto STAGE tables, validating the files and their counts against the Files from HP.
• Validate the date loaded in the views created on top of STAGE tables against the data provided by HP.
• Wrote complex SQL queries including Join Conditions, SQL Functions, Sub Queries to check the data from Source and Target.
• Validated data being loaded into OMX is matched with data sent from HP.
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Developed parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Executed batch processing and verified the jobs status and data in database tables
• Used JIRA for documenting Test Plans and Test Cases and log the expected results.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Done retesting the existing test cases with the different kind of source systems.
• Worked with developers to understand the functionality and Business rules to better validate the data

Confidential,Westlake Village,CA

Senior QA Engineer

Responsibilities:

• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Created and executed SQL queries to perform source to target testing on DB2 database. Performed the following tests: DATA COMPLETENESS, VALIDITY, UNIQUENESS, DATA INTEGRITY, DATA TRANSFORMATION, DATA QUALITY, and INITIAL/INCREMENTAL LOAD TESTS.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Wrote complex SQL queries including Join Conditions, SQL Functions, Sub Queries to check the data from Source and Target.
• Executed the workflows in the workflow manager to start the ETL process.
• Validated the load processes of ETL to make sure the target tables are populated according the data mappings provided that satisfies the transformation rules.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Performed Integration, End-to-End, system testing, involved in Functional Testing & Regression Testing.
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Prepared documentation for some of the recurring defects and resolutions and business comments for those defects.

Environment: HP Quality Center, DB2, Oracle, SQL, SQL*Plus, UNIX, Quick Test Pro 8.0, Test Director, Windows NT/2000

Confidential,Sunnyvale, CA

ETL Tester

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Performed manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Analyzed application data using the SQL to identify the ETL processes
• Modified and created SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performed backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Formulated the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performed database testing to verify backend database transactions.
• Coordinated user acceptance testing activities for business groups and IT.
• Involved in communication between UAT team members, business leaders, and IT.
• Participated in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Created, maintained and updated regression suites upon receiving new build.
• Modified and executed test scripts for web based environment-using Quality Center .
• Created traceability relationship between requirements in the same module and also between different modules.
• Analyzed requirements and creating and executing test cases
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involved in formulating the test plan, procedures and Wrote test cases.

Environment: HP Quality Center, Oracle10g, SQL, PL/SQL, DB2, SQL*Plus, UNIX, shell scripting

Confidential

QA Tester

• Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.
• Gathered and Analyzed Functional and Performance requirements.
• Involved in project planning, coordination and implemented QA methodology .
• Extracted test data by understanding relational database design diagrams Created.
• Designed, Created and executed manual Test Cases.
• Reviewed Test cases for automation and provided inputs about the scope of Automation.
• Prepared documentation about the automation suite architecture.
• Peer Review of the scripts and made recommendations for updates if any.
• Performed extensive backend testing by writing Complex SQL queries .
• Setup the Performance test environment with the support of technical team.
• Response time, throughput, hits per second were studied by graphs and reported.
• Created manual & automated test cases for testing web services.
• Used Test Director for storing, maintaining the test repository, bug tracking and reporting
• Prepared documentation for some of the recurring defects and resolutions and business comments for those defects
• Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner
• Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation
• Wrote SQL queries to test the data in database using TOAD and validated the data
• Developed Test Matrix to give a better view of testing effort
• Participated in Test Readiness Review Meetings

Environment: Java, Java Applet, JavaScript, Web logic Application Server, Oracle9i, SQL, PL/SQL, Test Director 8.0, UNIX (Solaris), Unix Shell Scripting.

Confidential

QA Tester

• Involved in designing the Test Cases using Functional Specifications
• Conducted extensive manual Black Box testing to better understand the functionality of the Application.
• Peer reviewed the Test Cases and made recommendations.
• Designed, Created and executed manual Test Cases.
• Test Environment Setup and Performed the Functional and Regression Testing
• Detecting bugs, classifying them based on the severity, and documenting them.
• Open Defect's with help of Bugzilla wherever discrepancies found in the code and assigning them to development Team.
• Involved in Testing Change Requests (CR) that is testing base enhancements to the existing code before implementing in the Production.
• Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation.
• Attended periodic meetings, teleconferences and led discussions on problem resolution.
• Coordinated with Developers for Defect analysis and performed Regression Testing.
• Developed Test Matrix to give a better view of testing effort.

Environment: Java, XML, Java Script, HTML, Bugzilla, Oracle, Mainframe, UNIX, Shell scripting.