PROFESSIONAL SUMMARY:

• Around 8+ years of experience in Quality Assurance with both Manual and SQL/Backend Testing for Business Intelligence, Data - warehouse, Client-Server, and Web based.
• Strong experience in analyzing and testing on Finance, Banking, Pharma and Insurance.
• Strong knowledge of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Extensive experience working and testing in different ETL technologies like Informatica, Datastage.
• Expertise in Data Warehousing concepts and Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Extensive experience in drafting Test Plans, Test Strategies, Test Scenarios, Test Scripts, Test Specifications, Test Summaries, Test Procedures, Test cases & Test Status Reports.
• Experience performing various types of testing like black box, integration and system testing and designing test plans, test cases and summary reports.
• Strong Database experience in Oracle, SQL Server, Netezza and exposure to Teradata, Sybase and MySQL databases.
• Experience using query tools for Oracle, MS SQL, DB2 and Teradata server to validate reports and troubleshoot data quality issues.
• Experience in PL/SQL programming, triggers, procedures, functions and packages.
• Experience in LINUX, HP-Unix operating system, UNIX shell (C, Korn, Bourne) scripting.
• Efficiently performed Defect Tracking using various tools like ALM, Quality Center, JIRA, Rational Clear Quest and Bugzilla.
• Excellent communication skills, Good organizational and interpersonal skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.
• Excellent oral and written communication skills.

TECHNICAL SKILLS:

QA Methodologies: Agile, Scrum, Waterfall, RAD

Quality assurance: ALM, HP Quality Center, JIRA,Test Director, Rational ClearQuest

Programming Languages: SQL, PL/SQL

ETL Tools: Informatica 9.1/8.6, SSIS, Datastage 7.5, 11.3

BI Tools: Business Objects XIR4, Cognos 8.4

Tools: TOAD for Oracle, PL/SQL Developer, Query Analyzer, DB ArtisanOracle Enterprise Edition, Aquadata Studio for Netezza

Operating Systems: Windows 2000/NT/XP, UNIX, Linux

Databases: Oracle, MS SQL Server, Netezza, Sybase, MySQL

Scripting Languages: UNIX shell (C, Korn, Bourne) scripting

Others: SQL, SQL Loader, WinSCP, Lotus Notes R5

PROFESSIONAL EXPERIENCE:

Confidential, Middletown NJ

ETL QA Tester /UAT Support

Responsibilities:

• Actively involved End to End, Regression, Functional, System Testing and User Acceptance Testing
• Regularly interacted with BA’s and Developers in facilitating discussion on various problems and issues. Proactively setup meetings with BA’s, UAT and technical teams.
• Managed and Lead the offshore team, coordinated with onshore and offshore QA team.
• Used SQL developer for Querying ORACLE and validate data from the data sources to the target GCP Database.
• Worked with source system personnel on source data delivery issues. Interacted with DBA and Environment team for setting up test environment.
• Executed test cases manually to perform Integration testing, compared and analyzed actual with expected results and reported all deviations using Quality Center ALM.
• Followed through with appropriate team/individual up to final resolution/sign off.
• Extensive experience in test planning, test scenario and test data creation.
• Performed verification of UNIX logs using Putty as part of few test cases. Used UNIX commands/scripts for checking job status and data content in the file.
• Extracted and loaded test data from various sources (such as files/tables) into Oracle using SQL
• Experience in troubleshooting of Datastage jobs and fixing the data issues in QA and UAT env
• Excessively used Datastage Director for monitoring and resolving issues with ETL Jobs.
• Validated data flow for web based application(POSC GUI) and data passed to downstream systems using SQL.
• Writing SQL statements that use joins and sub-queries to combine data from multiple tables.
• Extensively used DataStage Tool like Infosphere DataStage Director to view logs for execution errors.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data.
• Resolve/escalate any issues that might slow down the testing progress.
• Test execution, defect management and weekly testing status reporting.
• Validation of data transformations and perform End-to-End data validation for ETL systems.
• Involved in UAT Regression testing for release.
• Took responsibility in checking out production release and helped in validating critical issues.
• Keep QA Lead and management informed of current state of quality and test progress
• Experience in SDLC and Agile methodologies using Scrum methodology.

Environment: Oracle 11g, HP ALM 11/ Quality Center 10.0, IBM-Ascential DataStage 7.5, IBM-Ascential DataStage 11.3, UNIX, Excel, SQL developer for Oracle, Shell Script,WinSCP.

Confidential, New York, NY

SQL Backend Tester

Responsibilities:

• Extensively worked with the Business Analysts in understanding the requirements and participated in High Level Design walkthroughs between Business Analyst and development teams.
• Responsible for creating complete Test plan,Test cases and RTM for given business requirement.
• Wrote extensive SQL (multi-table join queries and sub-queries)for backend testing (pattern testing).
• Performed testing for various patterns (such as AGR, PIVOT, CROSS3, IID, IPD etc.)
• Used SQL for validating Web applications (Marketspace and ACMS).
• Actively involved in End-to-End testing, Functional Testing & Regression Testing.
• Executed complex queries using TOAD for ORACLE and Aquadata studio for Netezza.
• Created test data to cover various use case scenarios and performed positive and negative testing.
• Worked closely with development team to keep the test reports status latest and accurate.
• Performed exhaustive data integration testing using SQL.
• Used JIRA for adding test failure and success evidence.
• Involved and practiced agile project management with daily stand up calls.
• Used QC and ALM to store the test cases.
• Generated test summary reports and provided QA sign off.
• Took responsibility in checking out production release and helped in validating critical issues.
• Used UNIX commands for checking job status and file comparison.

Environment: Oracle 11g, Netezza, HP ALM 11/ Quality Center 10.0, JIRA, Toad for oracle 11.6, Aquadata studio15.0, SQL, PL/SQL, UNIX, Excel, TortoiseSVN, Jenkins, WinSCP.

Confidential, New York, NY

ETL QA Engineer /Application QA Tester

Responsibilities:

• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Involved in End-to-End testing, Smoke testing, Functional Testing & Regression Testing
• Writing SQL statements that use joins or sub queries to combine data from multiple tables.
• Validated S&P Capital IQ Critical Web based Applications like Global Credit portal, RX Credit research, RX Direct Access, RX web services as per entitlement packages.
• Tested High revenue applications like RX Ratings, RX web services.
• Validated extensive RX Ratings SPAN files, Daily files and Master files (XML and text format).
• Validated Low latency Application - Broadcast alerts
• Used proprietary RXWS (similar to SOAP UI) tool for invoking web services to validate target data.
• Performed Data comparison and Data validation for applications during their parallel production lifecycle.
• Created test users using LCMS (Leads & Customer Management System) tool for entitlement based testing.
• Giving user sign off after testing functionality

Environment: Oracle 11g, HP ALM 11/ Quality Center 10.0, Informatica 9.1, Business Objects XIR4, Toad for oracle, SQL,PL/SQL, Windows 2000, UNIX, Excel, Beyond compare, SecureFX, RXWS.

Confidential, Cleveland, Ohio

SQL/Backend Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Wrote SQL scripts to perform database testing and to verify data integrity
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Participated in fact and dimension table implementation in Star Schema model based on requirements.
• Prepared Test Plan from the Business Requirements and Functional Specification
• Generated test data (on UNIX box using Shell scripts) to support development
• Used TOAD Software for Querying ORACLE and WinSQL for Querying DB2 and conducted data integrated testing by extensive use of SQL
• Write SQL statements that use joins or sub queries to combine data from multiple tables.
• Tested Autosys JILS to automate daily and quarterly batch jobs.
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Reported debugging and tracked defects using Quality Center.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Worked with Data Warehousing developers who extensively used Datastage, to design mapping to move data from source to target database using Stages to do the functionality.
• Worked with Data Conversion projects for testing data quality after migration.
• Used SQL Loader for data retrieval and querying.
• Validate the business functionality usingUATTesting
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in Manual and Automated testing using QTP and Quality Center.

Environment: ETL/Datastage 7.5, Business Objects XIR3.1, Windows XP, UNIX, Oracle 10g/11gDB2, SQL, SSIS, SQL Server 2008 ER Studio, Shell script, TOAD, Auto Sys, HP Quality Centre 10

Confidential, Woonsocket, RI

QA Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Collected requirements and tested several business reports.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Used Quality Center to create manual (IEEE format) and automated tests, build test cycles, run tests and report and track defects.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Used Quality Centre for tracking the defects.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Tested all Cognos reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Extensively created test data to cover various scenarios and performed positive and negative testing on for validation purposes.
• Extensively test the reports for data accuracy and universe related errors
• Created and Tested event based schedules of the reports and built an emailing mechanism to indicate success/failure of the schedule.
• Tested several dashboards and deployed them across the organization to monitor the performance.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Experienced using database query tools such as TOAD, Teradata SQL Assistant and SQL Plus.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used Query Studio to test ad hoc reports
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Ensured data integrity and verified all data modifications and calculations during database migration
• Involved in user sessions and assisting in UAT (User Acceptance Testing).

Environment: Cognos 8.2, Quality Center 9.0, Windows NT, Linux, Oracle 10g, SQL Plus, TOAD, Teradata V2R6, Teradata SQL Assistant 6.0, ER Studio, MySQL, Shell Scripting, UNIX

Confidential, Wilmington, DE

ETL/Backend Tester

Responsibilities:

• Developed Test cases for the data warehouse in Oracle System
• Test Management tool - Test Director 7.5 is used to prepare test cases, for test execution and to extract testing status and Defect tracking
• As a ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting Gave production support in scheduling and tested this data with the existing data.
• Worked in creating UNIX scripts for file transfer and file manipulation
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• TOAD is used to perform manual test in regular basis. Oracle is using in this project to write SQL queries.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Tested Cognos reports to check whether they are generated as per the company standards.
• Written several complex SQL queries for validating Cognos Reports.
• Worked with business team to test the reports developed in Cognos
• Tested Complex Reports in Cognos 8BI Report Studio.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed detailed System test plan including test procedures and test cases
• Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure that the application meets the requirements and to ensure usability readiness
• Identified and resolved many application bugs and bottlenecks

Environment: ETL Informatica 7.1, Cognos 8.0, DB2, Test Director 7.5, Windows XP, UNIX, SQL Plus, TOAD, Test Cases, Test Scripts, Test Plans, Oracle8i/9i, DB2, Erwin 3.5/4.1, Windows 2000

Confidential

Software Engineer

Responsibilities:

• Involved in Writing Shell Scripts and SQL Stored Procedures to access data from Oracle database.
• Analyzed business needs and implemented the same into a functional database design.
• Written Shell scripting for various needs including job scheduling, job sequencing & data archiving.
• Used Repository Manager to administer Repository, created User groups and Users, provided security by configuring access privileges and profiles.
• Tuned database and SQL statements and schemas for optimal performance.
• Expertise in SQL queries for the cross verification of data.
• Developed system descriptions and instrument specifications.
• Evaluated and implemented engineering design changes.
• Advised equipment and instrumentation used in the process.
• Evaluated factory acceptance tests.
• Prepared requirements, test plans, test cases, test defect reports, and performed Black Box, Regression, Integration and User Acceptance testing.
• Resolved any SQL query issues. Escalated and tracked unresolved issues.
• Recommended SQL queries for standard and custom reports. Documented SQL statement and created report specifications.

Environment: UNIX, Shell Scripting, Test Director, SQL Server, Oracle 8i, PL/SQL, XML, XSD, Windows NT, TOAD