SUMMARY

• Around 8 Years of IT experience in QA Testing/ETL/BI - Reports & Testing of software systems in Data Warehouse/ Business Intelligence/ Oracle and Web-based environments under Windows and UNIX platforms.
• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and QA Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensive experience in writing complex SQLQueries and PL/SQL scripts.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects BOXI, Micro Strategy, Cognos including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in test management using HP Quality Center, Microsoft TFS and maintained Versioned objects using Rational Clear Case.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center, Rational Clear Quest, Bugzilla.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6/8.5/8.1/7. x, SSIS, DataStage, Ab Initio

QA Tools: HP - Quality Center, Test Director, Microsoft TFS

DBMS/Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages: SQL, PL/SQL, C, Java

Databases: Oracle11/g/10g, SQL Server 2008/2005/2000, DB2, Sybase Teradata V2R6/V2R5

BI / Reporting Tools: IBM Cognos 8.0, Business Objects, SSRS, Micro Strategy

Operating Systems: Microsoft Windows - Vista, XP, 98, 2000, NT 4.0 UNIX - Sun Solaris, HP-UX

PROFESSIONAL EXPERIENCE

Confidential

Senior Back end/DWH Tester

Responsibilities:

• Analyzed the Requirements from the client and Developed Test cases based on functional requirements, General requirements and system specifications.
• Involved in preparing RTM by link and sync process, mapping the test cases with the appropriate requirements in Quality Center.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Performed functional testing to execute complex manual test cases for both Web applications and backend database testing.
• Created test cases and test data to cover negative scenarios and to expand the test coverage.
• Performed Regression, Integration, end to end, negative and Adhoc testing on each build scheduled every week since the project followed Agile Scrum methodology.
• Performed manual testing to verify the UI functionalities are as per the business requirements.
• Validated the functionalities of the application in production right before the software going live.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse
• Have tested different Informatica transformations like Source Qualifier,Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Created SQL compare statements to validate Actual result with the Expected Results.
• Validated T-SQL objects like stored procedures, functions, triggers.
• Extensively used Informatica Workflow Manager to run the workflows.
• Documented the Defects found in testing using Quality Center.
• Used SQL Profiler to monitor the performance of SQL queries.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Extensively involved in System testing & Regression testing and Integration testing
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible in testing Initial and daily loads of ETL jobs.
• Used Quality Center to upload final test scripts and test results after final SIT (System Integration Testing)
• Executed automated test scripts using QTP for Regression testing.
• Excel reports are validated using SQL and embodying complex formulas in the Excel.
• Worked extensively on Analysis Studio and Report Studio in testing various Cognos Reports.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Oracle 11g, Informatica Power Center 9.1, SQL, PL/SQL, HP Quality Center, QTP 10.0, Teradata, Cognos 10, Solaris 10, XML, XSD, XSLT, Windows XP/NT.

Confidential, Philadelphia, PA

Sr. ETL Tester

Responsibilities:

• Interaction with business / data analyst to understand the mapping document and requirement specification
• Written Test Plans, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center
• Creating the test plan and test case as per the SSD/Business cases.
• Analyzing the application system and their source databases
• Understand existing business processes and data model.
• Mapping business needs/requirements to subject area model and to logical enterprise model
• Validating the testing strategy to build the data.
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Confidence testing the application in QA / production by performing smoke and sanity tests.
• Tested Post session emails to provide information about the mappings used sessions and batches completion statuses.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing bugs so that they conform to the business needs.
• Participated in weekly meetings and discussed modification request with team.
• Performing GAP and Impact Analysis for in-house changes and fixed the test cases and plan.
• Updated framework scripts and parameters in QTP and executed regression test suites in QA region using UFT.

Environment: Data stage, Power Center 9, UFT, QC, Oracle 10g, TOAD, UNIX Shell Scripts, Control-M.

Confidential, Albany, NY

ETL Tester

Responsibilities:

• Worked on testing multiple projects in different environments as the application was migrating from Java 4 to Java 5 and Oracle 10g to Oracle 11g.
• Performed ETL / data migration testing based on upgrade and gap analysis.
• Responsible for designing test plan, test cases and document the same in the Quality Center.
• Tested the analysis reports and logged defects on QC.
• Lead the internal and external Test plan walkthrough documents review meeting
• Performed functional, Regression, End to End testing, staging and production smoke testing.
• Used QTP Scripts to execute the smoke test and also for the transaction data load
• Involved in validating various SSIS and SSRS packages according to functional requirements.
• Manually Executed test plans and test cases to verify actual results against expected results
• Involved in testing the backend Database retrieved the data from the tables by writing complex SQL queries.
• Attend defect status meetings and update the progress to client test manager/project manager.
• Extensively used Quality Center for test planning, bug tracking and reporting.

Environment: Informatica, SSIS, SSRS, MS SQL Server 2008, Quality Center 10.0, QTP, Unix, XML, SOAP UI, Java, SQL, Oracle 10g, TOAD, MS Office

Confidential, Louisville, KY

QA Analyst

Responsibilities:

• Analyzed the business requirements, system requirements, and data mapping requirement specifications, interacting with client, developers and QA team.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Tested Metadata of tables including the data types, constraints and default values on the columns.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in Functional Testing, Regression Testing, Sanity Testing, Ad-hoc Testing and User Acceptance Testing.
• Responsible to test the functionality of Ab Initio graphs.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in preparationand maintenance of theRequirement Traceability Matrix(RTM) to measure the progress, test matrix and test script review.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Written several complex SQL queries for validating Business Objects Reports.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Oracle data warehouse
• Extensively usedRational Clear Questto track defects and managed them.
• Tested whether the reports developed in Business Objects are as per company standards.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Ab Initio 2.13, Oracle 10g, SQL Server 2008, SQL, TOAD, PL/SQL, DB2, Business Objects XI, Microsoft Visio 2003, XML, XSLT, .Net, Web Logic, Clear Case, Clear Quest, DOORS, Autosys, Windows XP, PuTTY, UNIX

Confidential, Frisco, TX

Quality Tester

Responsibilities:

• Developed Test Cases, Test Execution, Defect Reporting and Risk Analysis (where required), and Regression Testing
• Conducted project reviews and communicated periodic updates to upper management and client contacts
• Designed client walk-through documents for new CRs & identify the regression cases.
• Tested the Permission based access control of the operations for CAM and ICAM users.
• Tested provisioning new Account numbers, adding a line and security testing of closing accounts (no permission to close an Account for ICAM users).
• Worked on multiple projects performing Functional testing on sites like TMO.com and Tmobile.com
• Provided upper management with weekly, daily, and hourly project status updates as and when required.
• Interacted with Amdocs SAMSON system for some end to end verification
• Designed and executed Test Plans for the system Performance Testing for optimal performance of the data and reports under various real-time conditions.
• Extensively involved in developing and completing Black-Box testing as required
• Worked closely with developers and Business teams in resolution of technical issues.
• Involved in testing the backend Database; retrieved the data from the tables using SQL Queries.
• Tested all the applications in Dev, Sys test and Production environments.
• Reported the defects, tracked the defects and attended daily meetings.

Environment: UNIX, Quality Center 9.0, C#, Oracle, DB2, SQL Developer, Windows XP, MS Office 2007