SUMMARY

• Over Eight years of diversified experience in Software Quality Assurance and Testing on Client/Server, Windows based and Web based applications.
• Proven success in meeting or exceeding customer needs as an individual contributor and as team member.
• Participated in requirements analysis and design discussions to assist in the solution of the system.
• Strong knowledge of Software Development Life Cycle (SDLC) as well as Software Testing Life Cycle (STLC) and the Role of QA.
• Extensive ETL testing experience using Informatica (Power Center/ Power Mart, Workflow Manager, Workflow Monitor).
• Experience in testing Business Intelligence reports generated by various BI Tools such as IBM Cognos 8.1, Business Objects XI R2/R3 etc.
• Extensively experience in analyzing business requirements and specifications, development and execution of Test Plans, Test Scripts and Test Cases.
• Involved in Manual testing/Automation testing & Tracking defects using Test Director & Quality Center.
• Created maintained and executed Manual and Automated test scripts for System, Functional, Regression, Integration, Performance and UAT testing
• Developed Test scripts for automated testing using Quick Test Pro.
• Involved in Writing, Updating and maintaining the Test documents for various stages of Testing for reference and auditing purpose.
• Strong experience in all levels of Testing such as Positive testing, Negative testing, Integration Testing, Functional Testing, System Testing, Regression Testing and User Acceptance Testing (UAT), Black box testing, sanity testing.
• Used SVN for software configuration management and version control
• Experience with relational database systems using Oracle/Mysql/SQL Server
• Wrote test scripts to verify the data integrity and validate test cases
• Expertise in Problem solving and Bug Tracking Reports using Bug tracking Tools.
• Specialized in manual and Automation testing using tools like QTP.
• Knowledge in creating and executing SQL queries for Oracle database and MS SQL Server
• Experience in performing web services testing using SOAPUI and RESTClient

TECHNICAL SKILLS

Languages: SQL, PL/SQL, JavaScript, HTML, XML, PHP, Java 1.5/1.6,VB script

Testing Tools: JUnit, Quick Test Pro 11 (QTP)

Database Tool: Oracle SQL Developer, Db Visualizer, SQL Server Studio,, TOAD

Database: Oracle 11g/10g, SQL Server 2010, Mysql 5

IDE: Eclipse

Web Tools: Firebug

Application Server: Apache Tomcat 6/7/Jboss 6/7

ETL Tools: Informatica 9.5/9.0/8.6, SSIS

Web Technologies: HTML, Javascript

Source Control: Tortoise SVN

Defect tracking tools: Quality Center 10/11, JIRA, Rally

Operating Systems: Windows XP/Vista/7, UNIX

Methodologies: Waterfall, Agile

Webservices: SOAP UI, REST Client

Office tools: MS office MS word, Excel, Power point

Integration/Scheduling: Jenkins

PROFESSIONAL EXPERIENCE

Confidential, Middletown, NJ

Responsibilities:

• As a team, analyzed the requirements and design documents to come up with a test plan.
• Developed test Scenario, Test Cases and Test steps for test Schema and loaded into HP ALM after sign - off for Functional, System, Integration and Performance Phases.
• Identified and created source data as per requirements.
• Involved in all phases of Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Designing, Test Environment Setup, Test Execution and Test Reporting.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Defined data requirements and elements used in XML transactions.
• Conducted the Structural validation testing on source & target table structure, check field to field mapping on the Informatica Power Centre 9.1 including the check on data types, length, column names on both source and target tables, field types & formats.
• Tested ETL jobs as per business rules using ETL design document
• Worked in an Agile technology with Scrum.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Scheduled the jobs using CA Workload Control Center and automated the jobs to be ran Confidential specific time and automated the reports.
• Wrote SQL queries using joins, sub queries and correlated sub queries.
• Validated the report generated using Business Objects using SQL queries.
• Queried databases using SQL queries in SQL Server Management Studio to validate the data loaded into target tables
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Written manual SQL Queries and fired them on OLAP-Database to compare the results.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Wrote test cases in HP ALM and raised defect in HP ALM.
• Maintained the track of defect and defect report in HP ALM and conducted defect review meeting.
• Participated in Daily defect calls to elaborate on newly raised defects and also to keep track on the status of existing defects.
• Use Informatica debugger and session log to debug the defects.
• Performed smoke and sanity testing for migrating the code changes from development environment to SIT, UAT and Production environments.
• Reported weekly status report, documented defects as testing is in progress
• Responsible for drafting Test/Defect Metrics and Test Closure Report.

Environment: Informatica Power Center 9.1, MS SQL Server 2008, Oracle 11g, SQL, AGILE, XML, Business Objects XIR3, HP ALM

Confidential, Chicago, IL

ETL QA Tester

Responsibilities:

• Extensively written several Test Scripts to compare source and target database.
• Analyzed the requirements and wrote simple to complex queries to test the requirements.
• Performed Dry Run on the test scripts before System Integration Testing.
• Involved in verification, validation and Functional, GUI, System, Integration, Sanity, Regression testing
• Validated data from source to stage and stage to target database
• Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data
• Worked on Informatica workflow monitor to create and execute workflows
• Performed record count from source to target database
• Prepared scripts to convert Excel to flat files
• Tested the data migration from an Oracle data source to Teradata
• Prepared test/Seed data for various positive and negative testing scenarios
• Performed tests to check whether there is any loss of data during data loads
• Tested reports daily, weekly, monthly based reports
• Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files
• Designed and developed automation framework using custom function/ subroutine libraries to support functional/ regression automated testing solutions using QTP 10
• Tested Micro Strategy reports and written test cases using HP Quality Center
• Logged the defects found in quality center while execution of test scripts
• Tracked the bad records present in the table
• Tested all the reports by running queries against the warehouse using TOAD. Also compared those queries with the Micro Strategy SQL engine generated queries
• Validated the data present from flat files to database
• Wrote complex SQL queries using Teradata SQL assistant and TOAD for various testing purpose
• Developed test/QA environment using Informatica
• Created mappings and executed workflows using Informatica power center
• Tested Daily, Weekly, Biweekly and Monthly data loads
• Tested the layout of the table from the database to the data model

Environment: Informatica 9.0, Oracle 11g, Teradata, Teradata SQL Assistant, TOAD, SQL, PL/SQL, Rational Clear Quest, Autosys/Jenkins

Confidential, NJ

ETL/SQL Tester

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data Confidential source and compared with the Target to validate Transformations.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Logged defects using HP Quality Center 10, linked defects with requirements and generated Defect Reports in QC.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Used Oracle SQL developer tools for Querying source Database.
• Performed Report Testing using Crystal Reports by writing SQL queries to validate the data on the report and compare with the backend data.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
• Retesting the resolved defects/issues after the developers fix the defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Informatica 9.0, Oracle 11g/, PL/SQL, TOAD 8.0, SQL, Quality Center 10.0, Crystal Reports 12.0

Confidential, Parsippany, NJ

ETL Tester

Responsibilities:

• Designed and developed QA Test Plan/Test Cases using Testing methodology with all possible Use Case to cover all testable functions in Positive & Negative Testing.
• Provided Test metrics on the results of system testing activities; coordinated and collaborated with others in analyzing collected requirements to ensure system development and implementation plans meet customer needs and expectations.
• Helped drive automation innovation (participated in testing tool analysis and/or reviews, assisted and/or trained other manual testers in automation, implemented recommendation to improve test automation).
• Developed SQL Scripts (Developed complicated SQL Script in Toad) to validate data, automated UNIX based process.
• Set up Test Environment including refresh database from production, maintained test environment with upcoming release.
• Involved in key learning process after each release to implement process in future as a part of QA Process Management.
• Interacted with team to resolve daily issues in installation, code delivery, documentation, and defects.
• Involved in testing of multiple applications with QA, SIT and UAT testing by documenting, reviewing, resolving defects, follow up with interface sign-off.
• Supported Change Control by reviewing impact of all modules planned all release schedules, back out plan.
• Supported production support team in production Trouble Ticket to analyze root cause of problems and resolved with team.
• Involved in production support testing assisted team in staging testing, support in change control request.
• Involved in different major and minor release testing by updating test plan with testing methodology, reviewed test results and analyzed defects and resolved with team.
• Experience with testing Quality Center and Toad for defect tracking and database use.
• Ability to multi-task effectively, Excellent verbal and written communication skills and attention to fine details.

Environment: Informatica 8.6, Oracle 10g, Cognos 8.4 BI Series, UNIX, HP QC 10

Confidential

QA Tester

Responsibilities:

• Mapped the requirements with developed test cases
• Participated in peer reviews of software requirements, designs and test procedures.
• Prepared test procedures for automation.
• Created Regression Test cases and automated them for the purpose of regression testing.
• Enhanced scripts by creating Actions, Checkpoints, Synchronization points and parameterization with Quick Test Pro (QTP).
• Worked as a Quality analyst to test the re-design of the Buy Online Pickup in store system
• Participated in system testing, deployment validation and worked proactively with the QA team lead and developers to resolve any issues.
• Conducted Integration Testing, Functional Testing and User Accepted Testing (UAT).
• Provided back end testing for data validation using SQL Queries.
• Managed and executed the traceability matrix of requirements (RTM) to test cases.
• Used Quality Center for uploading requirements, creating Test Plans, Test Cases, Test Sets and updating Test results.
• Updated Clear Quest to ensure efficient documentation of QA activities.
• Wrote VB Scripts using Quick Test Pro (QTP) for creating Checkpoints, Synchronization Points & Data Driven Testing.
• Reporting and verifying the bugs in Mercury Quality Center.

Confidential

Software Developer

Responsibilities:

• Created Manual and Automated test cases and scripts.
• Reviewed the System requirement document for developing high-level Test Strategy.
• Analyzed the Functional Business requirements and Design documents, Developed Test plans for different Testing stages
• Interacted with Development and Design teams to design and plan the test plans.
• Performed Load/Performance, security, recovery, multi platform, concurrence, database validation. Performed regression testing using QTP
• Participated in all appropriate Test scenario inspections, Test case reviews, work and functional mapping sessions.
• Participated in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues.
• Responsible for security testing which was accomplished by creating and logging in under different fictitious login ID’s.
• Responsible for submitting the bugs into the Quality Center depending upon their priority.
• Supported Design and Deployment team to resolve reported problems
• Created new modules using PHP/JAVA as per the specifications
• Extend core functionality of the system through custom programming
• Test the system in all major browsers
• Help troubleshooting the errors/issues and improving site performance
• Automation test script using Selenium to test the added feature
• Created tools which helped in support