SUMMARY:

• 8 years of experience as Quality Analyst. Vast knowledge of Software Development Life Cycle & its methodologies, expert in Quality Assurance testing of Web Based. Client/Server, ETL and BI applications.
• Expert in using the Agile/Scrum and Waterfall testing lifecycle Methodologies
• Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Strong experience in testing Data Warehouse ETL Tools like Informatica, Data Stage, AbInitio and SSIS.
• Experience in both manual and automation testing process and in creating automation environment using Quick Test Pro (QTP), JMeter, and Quality Center.
• Expertise in test strategy design based on the various types of testing including integration, function, system, End to End, load, stress and performance testing, Data warehouse ETL, Bakend(Database), Web Applications, API testing.
• Interact with clients for Quality discussions and responsible for the QA deliverables.
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Proficient in SQL query and testing RDBMS such as, Oracle, SQL Server, MySQL for data validation.
• Performed GUI testing, system testing, functional testing, black box and white box testing.
• Automated test scripts was developed using QTP and JMeter.
• Proficient in using SQL Queries using Workbench & SQL Plus to ensure data consistency of front - end and raw feed by developing and executed complex SQL queries for database.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects, Micro Strategy, SSRS and Crystal Reports.
• Sound Knowledge and experience in Star schema/Snowflake schema.
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Verified database changes by writing SQL queries, executed the application and data manipulation.
• Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, HP ALM, Clear QUEST, Bugzilla, and Email (outlook)
• Strong experience in Backend testing on Relational Databases (RDBMS) like Oracle using complex SQL queries.

TECHNICAL SKILLS:

Methodologies: Waterfall, Iterative, Agile/Scrum, SDLC, STLC

Programming Languages: SQL, PL/SQL, XML, java, Python scripting

RDBMS/ Database: SQL Server, Oracle, MySQL

GUI Tools: JMeter, Oracle SQL Developer, SQL Workbench, SQL server

WORK EXPERIENCE:

Confidential, San Francisco, CA

Sr. QA Tester/ETL Tester/SQL Backend Tester

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts. Tested functionality across applications and workflows.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power Center.
• Wrote Python scripts to perform ETL operations in MySQL databases using MySQLDB.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on Oracle.
• Involved in testing designing and development of Data warehouse environment.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/ Data warehouse According to Business Rules.Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Performed ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Involved in extensive DATA validation on data marts by using SQL queries.
• Validated several SSIS and SSRS packages to verify that they are working according to BRS.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Validated Business Objects reports by running the SQL queries based on the business rules.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Experience in testing Business Report developed in Business Objects.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
• Served as the quality assurance lead at SCRUM meetings.
• Performed functional, unit and regression testing of application, which is a reporting solution to generate readable reports and XML files for the Center of Medicare & Medicaid Services (CMS).
• Developed and maintained all test specifications, scripts and data in accordance with CMS specifications.
• Verified database changes by writing SQL queries, executed the application and data manipulation.
• Interacted with software application developers and customer service teams to clarify design specifications, test requirements and address defect resolutions.
• Reported, tracked and monitored defects in the Visual Studio Team Foundation Server.

Environment: DWH ETL Informatica 9.6.1, Business Objects XIR4, SQL, PL/SQL, Oracle 11g/10g, SQL Server, HP Quality Center 10, SOAPUI, UAT, TOAD, Java, UNIX, Flat files, XML

Backend Tester/SQL Tester/ETL Tester

Responsibilities:

• Conducted JAD sessions with management, SME's, Business users and other stakeholders for open and pending issues to develop specifications.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Tested various ETL Datastage transformation rules based on log files, data movement and with help of SQL.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Prepared test cases in Test Plan tab execute in Test Lab and logged defects using Application Management LifeCycle (ALM) QC.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Created ETL test data for all ETL mapping rules to test the functionality of the Datastage.
• Ensured that migrated data is complete, accurate and correct from Oracle database.
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts.
• Performed Data Verification, data Validation, and Data Transformations on the Input data (Text files, XML files) before loading into target database.
• Tested Data stage Hashed files for extracting and write data - an intermediate file in a job. Test Cognos reports for data validations and compare results with TOAD.
• Extraction of test data from tables and loading of data into Oracle. Written Test Cases for ETL to compare Source and Target database systems.
• Written cases to test application manually in Quality Center and automated using QTP.
• Performed Regression, UAT and Database testing. Performed data validation-using SQL.
• Involved in developing UNIX Shell wrappers to run various SQL Scripts.Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Tested summary reports, ad-hoc reports and on demand reports using Cognos Report.
• Extensively tested several Cognos reports for data quality, fonts, headers and cosmetic
• Co-ordinate with business and technical people regarding test run results.

Environment: ETL Datastage, Oracle 10g, Cognos, SQL, TOAD, Quality Center, UAT, QTP, JCL, RationTools, Java, TFS, Clear Quest, JIRA, VB Script, Excel.

ETL QA Tester

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Tested all the ETL process that were developed to fetch the data from various feeds into the data warehouse.
• Perform manual testing and created various test results to track the testing results.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Tested reports in report studio and query studio by using SQL.
• Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
• Automated and scheduled the Datastage jobs using UNIX Shell Scripting.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

Environment: DataStage, Business Objects, SQL Server Quality Center 9.2, JIRA, Web Services/Web methods, XML, HTML Oracle, SQL,ALM, TOAD, TFS, JCL, Windows, UNIX.

Quality Analyst/ Software Tester

Responsibilities:

• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Responsible for creating Test plan, development of test scripts, execution and validate Test results and document test evidence.Comparing/analyzing mainframe test data with the front end.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Running SQL queries on the mainframe servers to retrieve test data.
• Creating and running automated scripts through Mercury Win runner. Reviewed Functional and Integration requirements.
• Develop Functional and integration test cases and review Test Cases wrote by peers.
• Created Test Cases, and got reviewed those by peers.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
• Discuss issues/defects with the business and development teams. Testing/Verifying/logging defects.
• Written complex SQL queries for querying data against different databases for data verification process.
• Developed UNIX Shell scripts to automate repetitive database processes
• Performed application setup in test environment and enhancing the documentation.
• Worked with internal and external developers/quality assurance staff to understand and resolve issues.
• Performed stress, performance and load testing on application APIs using Jmeter.
• Wrote automated test cases on Java for API testing and tested database on each API response.

Environment: Informatica power mart 5.1, Toad, Test Director, Visual Basic 6.0,UAT, Load Runner 7.8, JMeter, Quality Center, Windows, Linux, Java, Sybase, C, HTML, Oracle10g.