AIMAN

adi68y@r.postjobfree.com

973-***-****

www.linkedin.com/in/sanaaiman

Undertake challenges in a professional environment and develop skills to suggest and adopt the best strategies that can contribute towards the growth and development of the organization and also help me to attain the job satisfaction. PROFESSIONAL SUMMARY

• Over 10 years’ experience in testing web based, ETL applications.

• IT Professional possessing progressive experience in analysing, designing, developing, testing, production support and managing information technology projects.

• Develop and document test scenarios, test specs, test scripts, test cases, defect tracking and reports.

• Analyse the results of software tests and provide results for use in development code inspections and group reviews of project deliverables.

• Documentation and maintenance of test suites.

• Analysed business requirements, software requirement specifications to create test plan and test cases for manual and automated testing.

• Experience in different types of testing: Sanity Testing, Black Box Testing, System Integration Testing, Functional Testing, Integration Testing, UAT, Regression Testing.

• Developed and maintained automated test scripts.

• Extensive experience in writing SQL to validate the database systems and for backend ETL testing.

• Testing Initial and Incremental ETL data loads.

• Experience tested various BI reports using backend SQL.

• Proficient in working with UNIX platform.

• Reporting End of the Day Report to the Project Managers/Stakeholders.

• Provide post-implementation support for all deliverables. KNOWLEDGE BASE

ETL Tools Informatica Power Center 9/8.x

Data Bases Oracle 11g, 10g, MS Access, SQL Server 2005/2008 R2/2012 Development

Languages

Java, JavaScript, XML, HTML, CSS, SQL, T-SQL

Operating Systems Linux, Windows

BI Tools Cognos BI 11, SSRS

Testing Tools Selenium Webdriver, HP – Quality Center/ALM, QTP, JIRA, Bugzilla, SQUASH, TFS. GUI Tools Toad, Oracle SQL Developer, SQL Server Management Studio, Putty, Autosys, Solace Queue, WinSCP.

Methodologies Agile, Waterfall, Iterative.

Frameworks TestNG, Maven, Jenkins, Cucumber.

IDE Eclipse, IntelliJ.

HANDS ON EXPERIENCE

Wells Fargo, North Brunswick NJ Dec 19 – Till Date Senior QA Analyst/QA Lead

Was part of SFTR for WFS (Wells Fargo Securities), investment banking division of Wells Fargo’s. This project was intended to enhance the transparency of the securities financing markets by requiring those who enter into the securities financing transactions (SFTs) to report the SFT to a trade repository. Responsibilities:

• The ESMA reporting Back End Testing Specialist, I am responsible for managing the database for tracking SFT reporting data requirements to ensure compliance with ESMA testing guidelines and maintain European Markets Infrastructure Regulation (EMIR).

• Reviewing quality specifications and technical data design documents to provide timely and meaningful feedback.

• Constructed and executed SQL queries to verify data quality.

• Performed Sanity, functional, positive, negative, Integration, System Integration, Regression, End to End and User Acceptance Testing.

• Developed test automation scripts using TestNG for regression and performance testing of the various releases of the application.

• Interacted with Business Analysts/Stakeholders to determine functional specifications.

• Performed Integration testing for various application integration points.

• Estimating, prioritizing, planning and coordinating quality testing activities.

• Conducted database integrity testing using SQL Queries on reporting functionality

• Conducted Defect Triage meetings and QA status meetings and Produced daily progress reports to Stakeholders and Project managers.

• Extensively worked on testing large data sets.

• Validating the data in the production system & comparing it against the QA source data.

• Assisted test data preparation for QA environment.

• Verifying whether the data is transforming correctly according to business requirements.

• Verifying that the projected data is loaded into the data warehouse without any truncation and data loss.

• Verifying and making sure that ETL application reports invalid data and replaces it with default values.

• Verifying and making sure that data loads at expected time frame to improve scalability and performance Environment: IIS, Apache, JBOSS, Solace QUEUE, Symphony UI, Web Services, LINUX, Windows XP, SQL Server 2014, JIRA, HP ALM, AutoSys, TestNG

Aegis Insurance, Secaucus NJ Aug 17 – Sep 19

QA Analyst

Responsibilities:

• Analysed business requirements, system requirements, responsible for documenting functional requirements and supplementary requirements in Squash.

• Involved in developing detailed test plan, test scenarios, test cases, test scripts using Squash for Functional and Regression Testing.

• Involved in writing test cases using id, name, linkText, class, Xpath, Css locators for automation testing.

• Generated customized Xpath and Css from html attributes.

• Experience in Agile, Scrum methodology

• Participated in Daily Scrum meeting, Stand-up meeting, walkthrough meeting, weekly assessment meetings with business analysts and developers

• Written SQL Queries to validate the test data.

• Executed Test case and Test scripts in test lab module of Squash.

• Documented test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

• Conducted Test Case Walkthroughs to achieve consensus on Test Case correctness &completeness.

• Worked closely and coordinated with the team to resolve unsolved issues

• Took the Application Screenshots and copied the images whenever exceptions occurred and at important checkpoints of application execution.

• Executed queries in Sense plug to check the flow of Elastic Search

• Validated data in the front end and back end through Sense Plugin.

• Excellent with using open-source bug tracking tool JIRA

• Experienced in various types of testing including Smoke Testing, Functional Testing, Performance Testing, Black box testing, System Testing, Ad Hoc Testing, Sanity Testing, Positive and Negative Testing and Regression Testing.

• Create, assign, update and monitor the defects in defect Tracking System using JIRA and enter new change requests into the JIRA.

• Attending Defect Review meetings with Developers, Tech Lead, and Project Manager to discuss issues regarding the Open defects, resolved defects and all other defects associated to the Source system.

• Executed automation scripts on different browsers/environments & reported defects/results to the team

• Broad understanding of Agile Software Concepts.

• Perform parameterization of the automated test scripts in selenium to check how the application works against multiple sets of data contributed in developing automation framework that uses Java, Selenium Web Driver and TestNG

Environment: Oracle 11g, SQUASH, SQL, SeleniumWebdriver, Java, HTML, Elastic Search, Sense, Jira, Agile Methodology, TestNG.

MIO, New York City NY Mar 17 – Jul 17

QA Engineer

MIO serves McKinsey's pension plans, partners, and former partners, working to enhance their long-term financial stability through superior investment performance and advice. It is managed independently, and all its activities are separate from McKinsey's consulting operations. Was Part of 3 projects of Investment domain

(Insight, FOSS and Automation Project)

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.

• Responsible for testing Business Reports developed by Business Objects.

• Studied the PL/SQL code developed to relate the source and target mappings for my testing needs.

• Developed test data in preparing the mapping document for source to target.

• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

• Extraction of test data from tables and loading of data into SQL tables.

• Written several shell scripts using UNIX Korn/Bash shell for file transfers, data archiving, error log creations and log file cleanup process.

• Developed and Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

• Tested several stored procedures.

• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.

• Creating UNIX scripts for file transfer and file manipulation.

• Validating the data passed to downstream systems.

• Involved in testing data mapping and conversion in a server based data warehouse.

• Used Quality Center to track and report system defects.

• Developed test automation scripts using TestNG for regression and performance testing of the various releases of the application.

Environment: Informatica 9.5, SAP BO, TERADATA, Oracle 11g, HP ALM, SQL, PL/SQL, UNIX, TestNG Wells Fargo, Charlotte NC May 15 – Feb 17

ETL/Backend Tester

The main objective is to focus on the ETL and User Acceptance testing (UAT) for the CSBP Test- Card Retail Sales. It is responsible for testing the booking and servicing of credit cards within Interact and Card Solutions. Responsibilities:

• Implemented QA processes (defect tracking, test case management, automated testing strategies, etc.).

• Coordinated QA processes and activities across the teams.

• Developed Test Plan, Test Design, Test Cases, Test Script.

• Conducted Test Execution, Test Status Reporting.

• Performed Black Box, Manual, Functional, Regression, Integration, System tests.

• Written SQL queries manually and also built SQL queries using TOAD to validate the Customers ' addresses and accounts level data.

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.

• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.

• Debugging the SQL-Statements and stored procedures for various business scenarios.

• Performed extensive Data Validation, Data Verification against Data Warehouse.

• Loading Flat File Data into Teradata tables using Unix Shell scripts.

• Used HP Quality Center to upload all test cases in Test plan and Test lab modules.

• Tested several Informatica Mappings to validate the business conditions.

• Testing the source and target databases for conformance to specifications.

• Designed and executed the test cases on the application as per company standards and tracked the defects using HP Quality Center 10.

• Involved in Web Services Testing using SOAP UI.

• Automated the screen shots using an inbuilt recorder in the MS Dynamics AX 2009.

• Designed and prepared scripts to monitor uptime/downtime of different system components.

• Interacted with senior peers or subject matter experts to learn more about the data.

• Identified duplicate records in the staging area before data gets processed.

• Extensively written test scripts for back-end validations. Environment: Informatica 9.0, Cognos 2011, SOAP UI, HP Quality Center/ALM, Teradata 12, TOAD, Oracle 11g, SQL Server 2008 R2, QTP

Cognizant Technology Solutions, India Sep 10 – April 15 Programmer Analyst

Worked for the clients USAA, ICICI Prudential and Crawford Insurance clients on Testing various applications. Responsibilities:

• Involved in implementing each phase of SDLC and Coordinated in Test Environment setup.

• Analyzed and reviewed requirement document to create the test plans, Test Cases and Test Scripts.

• Interacted with client for requirement gathering and analysis and for studying the existing system.

• Created manual test cases, reviewed with different stakeholders to validate the functionality.

• Involved in development, execution, and improvement of testing processes.

• Performed functional testing by deployment request, sanity testing, prioritized QA Test Cases within project plan.

• Performed Defect Root Cause Analysis, interacted with related Team, and tracked defects in a Quality Center.

• Uploaded the test cases from Excel to Quality Center.

• Identified software problems, wrote easy-to -follow bug reports, logged them into bug tracking tool Quality Center monitored their progress and verified their fix.

• Involved in Back End testing using SQL queries.

• Involved in planning QTP testing process by Analysing the AUT.

• Assisted business & marketing team in execution of UAT by providing data.

• Involved in System Integration Testing with external/Internal interface and understood overall customer business functionalities.

• Shared technical information with team and involved in production testing with critical production problem.

• Interacted with upper management to provide daily QA status, discussed outstanding issue and upcoming project functionalities.

• Attended meetings involving Developers, DBAs and Analysts, Project Manager for tracking changes and change management.

• Conducted user acceptance testing.

• Provided weekly statuses to the project manager as well as users.

• Reported the status of testing activities to the teams and management as necessary. Environment: Quality Center, QTP, Manual testing, Oracle 10g, Rx connect, WebLogic, Java, SQL Plus, SQL, PL/SQL, Windows, UNIX, Shell scripting.

EDUCATIONAL PROFILE

• Bachelors in Engineering, Computer Science, Anna University India. CERTIFICATION

• ISTQB

MERITS

• Certified in ISTQB-ISEB Certified Tester Foundation Level (CTFL).

• Won “Spotted” award for the best project team member with zero fallout for the year 2012.

• Acknowledged for the work done for the year 2020 at Wells Fargo – SFTR.

• Available upon request.

REFERENCES

Contact this candidate