SUMMARY:

• Senior QA Analyst with over 10 years in software quality assurance testing on API web services,ERP applications like Oracle, Microsoft SQL, ETL, Data Warehouse and report testing using datamarts.
• Well versed in all phases of SDLC, Agile/Scrum methodologies, best practices & Testing Life Cycle, Knowledge of Process Improvement, IT Governance and Risk Management.
• Solid experience in developing Test Scripts, Test Plans, Test Scenarios, Test cases and UAT Sign - off documents based on Requirements and Design documents.
• Expert in ETL testing, writing SQL queries for Verification Testing, Stored procedures/function, ability to manage all phases of testing, creating defect reports on risks, defects and problems across multiple projects.
• Expert in API web service testing tools like - POSTMAN,SOAPUI and Lisa Devtest for automation)
• Reporting: Testing the data warehouse against reporting needs. Testing the data warehouse against by writing complex SQL queries to be written to validate.
• Rich experience in onshore/offshore module with currently handling 5 offshore team members.
• Experience in selenium automation and TestNG framework.
• Provide a test summary reports that reflects the quality attributes of the software under test. Communicate with development, project management, and customer stakeholder where necessary.

TECHNICAL SKILLS:

• API web service & Methodologies
• Test Plans, Cases & Processes
• Functional Requirements
• Scripting & Documentation
• Regression & Negative Testing
• Expertise in Teradata,DB2 and Oracle sql
• Data Interface & Migration Testing
• Datawarehouse/ETL/Report testing
• Experience in Big data testing
• Defect / Bug Tracking
• Test Strategies & Coverages
• QA & QC Standards

WORK EXPERIENCE:

Confidential, Austin

Senior QA Test lead

Responsibilities:

• Working in an agile environment with great knowledge of QA processes and SDLC (Software Development LifeCycle), Windows based applications
• Leading the cart and checkout API web service testing team from both functional and automation.
• Develops proper documentation
• Extensive experience in testing API web services using POSTMAN, POSTER and LISA automation.
• Strong experience in SQL.
• Handled large data warehouse, datamarts and ETL testing through batch loads.
• Rich experience in onshore/offshore module with currently handling 5 offshore team members.
• Designs, documents, and implements white box and black box test plans, test approaches and test cases using information from product documents, knowledge of business processes and discussions with developers.
• Design and develop manual function, regression test cases as a basis for creation of automated tests.
• Extremely knowledgeable in software development lifecycles using Agile with Scrum methodology.
• Create and maintain test cases as per the new/updated requirements.
• Test Execution as per the QA process
• Experience in Defect Management Process
• Reports software bugs and communicates software defect behavior to engineering teams using bug tracking software such as TFS, Bugzilla, Trac, Jira etc
• Provide status reports and metrics on test case creation and execution and defects.
• Proactive and promote best practices, standards and processes for Manual and automation testing.
• Experience with Restful API, SoapUI, POSTMAN,LISA Devtest, ALM and JIRA for scrum board.

Test Lead

Tools: and Technologies: Teradata Database, HP Quality Center, Micro Strategy Report Tool.

• Develop test strategy based on the project requirements and schedule
• Responsibilities: I involved in,
• Preparing Test Plan for the CMR Reporting.
• Creating Test Data for testing the Complex Views.
• Writing Test Cases for the Semantic Views.
• Writing complex queries to validate the report queries.
• Guiding the 4 member team in a effective manner to complete the report testing on schedule.
• Design, develop, and execute detail oriented test scripts, test cases and project specifications.
• Report defects found in testing diligently, promptly, and accurately, using standard defect tracking tools.
• Report test progress against schedules (planning and execution).
• Provide a test summary report that reflects the quality attributes of the software under test. Communicate with development, project management, and customer stakeholders where necessary.
• Perform both new functionality and regression tests; identify, analyze and report issues for follow-up. Ensure the integrity of test material.

Senior test engineer

Tools: and Technologies: Hadoop distributed file system ( HDFS) is used for storing AWH Data Hive is used to retrive/Quey the AWH Pentaho is used for ETL, Reporting and Analysis Mysql is used for creating DataMarts Unix script Framework is used to perform some of the ETL process and Test Automation.

• Leading the BI - QA Team Interaction with Various Development Team and Release management Teams.
• QA Data Base Administration Create HDFS files and Folders Structure and Hive Table creation. Deploying RPMs in different QA environments. Test Case: Created an Automation framework (Unix) for regression testing. written set of SQL for data masking ( production data to QA environment ).
• ETL: Testing the ETL process for quality of data and its coverage in terms of available data sources.
• Testing ETL Abort scenarios and reprocessing rejected records and Modularized ETL testing.
• Slowly Changing Dimension Testing. Test cases for Duplication Handling in Fact Table. TestCases for Incremental Load. Test Cases to verify the index handling at the time of ETL Load and Lookup.
• Reporting: Testing the data warehouse against reporting needs. Testing the data warehouse against SQL queries to be written.

Senior PL/SQL developer

Tools: /Technologies: Oracle SQL, PL/SQL, TOAD, UNIX, Control M, HP Quality Center.

• Migrating the code from various environments from System testing to System Integration testing and finally to the Production environments.
• Analyzing the requirements given by BA for writing test cases.
• Writing complex queries using oracle 10G to validate the transformation mapping from staging environments to the target environments for each fields.
• Coordinating with onsite developer and BA for clarification of requirement.
• Testing Unix scripts to check the extraction of the files from target environment.
• Writing Pl/SQL stored procedures and functions to transform the data from staging to target tables.
• After manually running all the jobs, we will setup these jobs through Control M for running of these jobs.

Design/developer

Tools: /Technologies: Oracle SQL, PL/SQL, TOAD, UNIX, Control M, HP Quality Center.

• Release Management.
• Verifying Production releases before moving to production.
• Analyzed the Functional/Design specifications for the Business processes, Validations based on the gathered requirements given in the BSD.
• Writing stored functions, procedures and triggers depending on the requirement.