Mariam Islam

adbloq@r.postjobfree.com

732-***-****

Summary:

Overall 6 Years of experience in Software Quality Assurance field. Expert in Manual & Automation testing in Data warehouse, Client & Web based application in Windows. Seeking a challenging position as a Software Test Analyst/Test Engineer Position anywhere in the United States.

Work Status: US Citizen

Summary:

•Over 6 years of experience in maintaining Test Strategies, creating the Test Plan, Test Scenarios, Test Scripts and Automation of testing Client/Server and Web applications.

•Coordinated the plans, strategies and tasks with the Project Manager, Business Analyst, Developer, QA Team, Release Management

•Experience using query tools for Oracle, Teradata to validate reports.

Managed handling multiple projects and Worked as Test coordinator for many offshore/onsite models.

•Experience in testing and writing complex SQL statements.

•Exposure in editing Test Plan, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.

•Extensive experience working on regulatory projects like Basel II, Basel III using OFSAA/AXIOM SL frameworks.

•RIS submission Data (Account and Portfolio) in production validated using Mapping docs against EIP for TRD, OCC, MLL, HELOC, FICO, FHLB and Credit Card before sending to AXIOM and Argus.

•Has exposure in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.

• Expertise in testing complex Business rules by checking mapping and various transformations (STM).

•Experience in all phases of Software Development life cycle.

•Experience in coordinating testing efforts among the team, exposure to Software development life cycle (SDLC), waterfall methodologies.

•Performed Unit, Integration and System Testing.

•Good analytical and problem-solving skills.

•Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

•Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.

Technical Skill Set:

Databases : SQL Server 2014, Oracle 11g, Tableau

Toad, Teradata Studio, Teradata Assistant 14.0

Programming :SQL, PL/SQL, HTML, VBA Macros, Visual Basic.

Tools : JIRAS, HP-ALM, QTP/UFT, Axiom SL, OFSAA, OBIEE, Excel, SharePoint.

Professional Experience:

MUFG-Union Bank (Jersey City, NJ) June 2019- Present

Quality Engineering (QE)

MUFG (Mitsubishi UFJ Financial Group) is one of the world's 5th largest financial groups, with total assets of approximately $2.7 trillion (USD). MUFG (Mitsubishi UFJ Financial Group) offers services in corporate and investment, commercial, and consumer banking, as well as transaction banking, securities, wealth management, and more.

Involved in multiple Financial reporting projects (Basel III, FFIEC 031, FR Y9C, FR Y-8, FR Y-15). These projects were for federal regulatory reporting for financial institutions which provides more flexibility in calculating minimum regulatory capital and improves risk sensitivity of regulatory capital frame work, while maintaining current capital levels in the system.

Responsibilities:

Understand the functional requirements.

Worked very closely with product owner, developers, IT lead, Bas, and QA teams.

Analyzed Business Requirements and Functional Specifications and developed Test Plan detailed Test Scenarios, Test Strategies and Test cases.

Involved in creating Test Plan according to the business requirements.

Created, prepared and conducted quality assurance review meetings, develop test plans, test cases, user scenarios, check lists, daily status report, weekly status report and other QA documentation.

Logged the bugs in Defects tab in JIRA.

Add the user stories in JIRA.

Delivered user stories in bi-weekly sprint based on Agile scrum methodology and involving in daily scrum meetings.

Design the test cases by mapping MDRM number and the Lead sheets and FreeForm Reports from Axiom SL.

Verify the correct lead sheet loaded to Axiom

Verify the data round up occurred as per requirement

Verify output data by manual adjustment (MDA) in lead sheet and running workflow

Verify each line item data from lead sheet against axiom report

Execute the reports in Basel III financial reporting.

Review the Lead sheets data with Free Form Reports to make sure data was correctly populated before it was submitted to the FED.

Environment: AXIOMSL, SharePoint, JIRA Zephyr (bug tracking, issue tracking, and project management), Microsoft Office 365.

SunTrust Bank (VA) Oct 2017 – May 2019

QA Tester

Involved in multiple Capital reporting projects (Basel 2, Basel 3, LCR, Cash flow Projection, 2052a). These projects were for federal regulatory reporting for financial institutions which provides more flexibility in calculating minimum regulatory capital and improves risk sensitivity of regulatory capital frame work, while maintaining current capital levels in the system.

Responsibilities

Understanding the Requirements and Functional Specifications of the application

Participate in identifying the Test scenarios and designing the Test cases

Prepare and Execute Test cases as per System Requirement

Identify Defects and discrepancies, document and track Defects in HP Quality Center and coordinated defect calls

Retest defect fixes and provide updates to the development team

Performed various black box testing Methodologies such as functional testing, Database Testing, Usability Testing and Regression testing

Performed Regression Performance tests on system upgrades

Involved in Bugs Tracking and Prepared Bug Report Documents

Created SQL queries to retrieve data from database to validate the input data.

Executed different SQL Queries to ensure data integrity

Involved in Business analysis and requirements gathering

Coordinated with Development Team to discuss defects/issues

Helping Business team with required information for UAT in QA environment

Responsible for Validation of Data quality checks and Asset Classification rules

Validated EIP Data loads and availability of data in all staging tables using toad

Validated record count and data load as per the SCD type

Worked on LCR Categorization process and thoroughly ensuring that data is categorized as per the rules defined

Validated the Form functionality and error output in OFSAA framework.

Validated the Categorization compare functionality in the form’s framework

Validated Reclass, Default and overwrite categorization is happening as per the rule

Running multiple batches for data validation

Created, Executed and monitored the LCR Calculator batches

Validated LCR OBIEE Flash reports based on the fact table data

Validated the LCR factor rates are being applied correctly

Validated the deposits, lending, wholesale and retail subject areas with respect to prompts columns and their measures and if the balances tie up to fact table

Worked with OFSAA (Oracle) tool to process the data coming from different sources with regards to batch execution and batch monitor

Ran purge runs to purge the data and free up the space

Worked on complex SQL queries and executing them using TOAD for Oracle and TOAD for Data analyst for analysis

Environment: HP Quality Center/ALM (Application Lifecycle Management), Quick test Professional/UFT (Unified Functional Testing), VB Script, OBIEE, Oracle 11G, Toad, Teradata.

Wells Fargo Bank (New jersey) Feb 2016 – Sept 2017

QA Analyst

Well Fargo Bank is a world leading retail bank in USA. It provides their clients with expert advice, innovative solutions, outstanding execution and comprehensive access to the world's capital markets. As the investment banking and securities business of UBS, they are part of one of the World’s most stable and secure financial institutions.

Responsibilities:

Tested RIS submission Data in Production validating EIP data against mapping document in ETL before sending them OCC.

Tested EIP portfolio and account data extracted from TDR, OCC, MLL, HELOC, FHLB in ETL before sending them to Argus.

Tested EIP account and portfolio data against AXIOM.

Co-ordinated with Development Team and all stakeholders to discuss defects/issues.

Helping Business team with required information for UAT in QA environment.

Coordinate the plans, strategies and tasks with the Project Manager, Business Analyst, Developer, QA Team, Release Management.

Enhanced and created QTP/UFT scripts using reusable actions, parameters and check points.

Involved in documenting clearly defined test scenarios into test cases.

Updated tasks statuses in excel to ensure burn down charts are not skewed.

Assisted project manager in maintaining test schedules, issue/decision logs.

Designed reports to provide summary of test status using MS Project and Excel.

Performed Functional, Data Migration, Regression and System Integration testing.

Analyzed defect aging and reported to management to ensure that the release is not affected.

Analyzed recurring defects and attended root cause analysis (RCA) meetings.

Requirement review meetings with business analysts and providing suggestions/feedback for better validation.

Validation of the reports bases the rules/short hands given by the Business.

Meetings with Development team to understand code implementation and impact using Oracle Solution and Sizing documents.

Preparing test scenario documents.

Creating test sets in test plan and modified the scripts based on the latest business requirement changes in ALM 12

Traceability of Defect or Requirement with Test Case.

Documented all the changes that needed for functional requirements.

Update management with the statistics of the Test execution.

Wrote SQL queries to validate data.

Prepare and presented test results and reports.

Interacted with development team to track delivery schedule.

Participated in Defect Meetings with QA, product owner and development team.

Attended daily SCRUM meeting and provide team with test results and performance improvements needed.

Updated the Client/management with daily/weekly work status.

Environment: HP-ALM, QTP/UFT, Oracle 11g, DB2, informatica, TOAD, Teradata Assistant 14.0, Teradata Studio, MS Office, Widows.

Barns and Nobles (New York) March 2014 – Jan 2016

Software Tester

Barnes & Noble's eCommerce application helps users to change the future of reading. B&N are the world’s largest bookseller and one of the world’s fastest growing digital media and consumer technology companies. Application includes the nation’s highest rated and most heavily trafficked specialty retail stores, digital content and hardware sales through our exploding NOOK brand, college bookstores, and online retailing through BN.com.

Responsibilities:

●Reviewed and verified for adequacy of SDLC documents (Software development plan, functional specification, risk management plan, deployment guide, release management and user manual.

●Designed and developed Test Scenario/Test Cases/Test steps for various Business Services/methods covering both positive and negative testing requirements.

●Involved in reviewing and implementing the Business Requirement Documents to create a comprehensive list of Test Cases and various test scenarios.

●Participated in Requirements walk through and analyzed developed Use Cases.

●Verified and edited test data in new or existing systems.

●Prepared Excel Sheet for Requirements and export the requirements to HP-ALM.

●Wrote comprehensive Test Cases and executed written Test Cases of the application.

●Used HP-ALM as the test repository, executing the Test Cases, Test Scripts and logging & generating various reports and graphs for further analysis.

●Wrote and recorded VB Scripts for automating the testing procedure using Quick Test Professional.

●Maintained Test Matrix for the latest test results information.

●Reviewed Business Requirement documents for writing Test Cases and Test Procedures.

●Identified Defects and discrepancies, documented & tracked Defects in HP-ALM and coordinated defect calls.

●Retested defect fixes and provided update to development team.

●Planned Test Script execution to allow enough time for multiple passes and/or significant regression tests.

●Communicated defects encountered during regression test and followed-up with developers until all issues were resolved.

●Created SQL queries to retrieve data from database to validate the input data.

●Executed different SQL Queries to ensure data integrity.

Environment: HP-ALM, Quick Test Professional (QTP), Agile test methodology, HTML and SQL.

Cigna (Philadelphia, PA) Jan 2013 - Feb 2014

QA Tester

Cigna is an American worldwide health services organization based in suburban Bloomfield, Connecticut and Philadelphia, PA. Cigna offers Medicare and Medicaid products and health, life and accident insurance coverages to individuals in the U.S.

Responsibilities:

●Designing of Test Scenarios, Test Cases, and Test Conditions as per the requirements.

●Involved in Requirements Analysis and creating Traceability Matrices.

●Tracking Defects using HP-ALM

●The existing Member Portal application is being updated, it is being refreshed by rebuilding it on the “dot net” platform.

●Updated the registration and login processes to make it more efficient and user friendly.

●Updated the accounts so the members can login as Member, Non-Member, Head of Household or Authorized user.

●Integrating HP-ALM and QTP for reporting defects.

●Reporting Test Results, defect tracking, defect review, validation.

●Reviewing the status of the project and taking corrective measures as required.

●Training the other resources and allocating work.

●Involved in Resource planning and Effort estimation.

●Involved in requirements capturing, documentation of the system & enhancement of the application.

●Reporting Daily and Weekly Status Reports to clients.

●Post Production Support.

Environment: HP-QTP, HP-ALM, VB Script, SQL Server, MS Office, Windows

Awards at Work:

●Three stars Award as a Certificate of Recognition.

●Gems and spotlight Award for contribution towards work improvement.

●Outstanding Performance award.

●On the Spot Award

Education:

BS/BA in Finance/management

University of Pittsburgh (2009)

Pittsburgh, PA

Contact this candidate