Data Analyst
Resume:
Sr. QA Analyst
Mohiuddin Mubeen
adgou5@r.postjobfree.com
A Quality Assurance Analyst with 7+ years of experience as a Functional Tester in the industries of Banking, Insurance, Finance, Retail and Networking domain.
PROFESSIONAL SUMMARY
A highly competent and result oriented Test Analyst with 7+ years of diverse experience in Information Technology with expertise in analysis and design of Testing and Quality Assurance with various Client/Server and Web applications including Salesforce using Manual and Automation Testing Tools – Quality Centre, QMF, MTM, TFS, Azure, SOAP UI, Mainframe, Jaws, RubyMine and Postman.
Expertise in reviewing/analyzing Software Requirements Specification documents [SRS], Business Requirement Documents [BRD], creating and developing Test Plans, Test cases and test Scripts and interacting with development Team and Requirement Team.
Possess strong Functional experience, with a thorough understanding of the business process, QA approach to Software testing, Software Development Life Cycle and Testing Life Cycle.
Extensive knowledge of different kinds of testing like Functionality Testing, Integration Testing, Regression Testing, Data Driven Testing, Smoke Testing, User Acceptance Testing, and End to End Testing on Web and Client/Server based applications
Proficient in various QA Testing Methodology Including Test Case, Test Script Recording/Enhancement, Test Set Execution and Defect Tracking.
Experience with bug tracking tools like Quality Centre, MTM, Azure, TFS and familiar with Bugzilla.
Experience in leading testing activities for multiple projects.
Experience in Reviewing and monitoring test matrices developed and maintained by QA Testers and Analysts.
Experience with Waterfall and Agile Methodologies.
Hands on experience in performing multiple SOA architecture Web services (SOAP and REST) validation using SOAP UI.
Updating XML in SOAP UI for testing the scenarios for the application.
Developed and implemented test scripts in Gherkin.
2 year of experience working in AGILE Software development model Environment.
Expertise in AGILE methodology, Running/attending daily STANDUPS, Entry/Exit 3 Amigos attending Iteration Planning meetings, Retrospective, presenting in Show and Tell the business (PO review).
Good experience in writing and running SQL queries using Oracle Database (QMF) daily to retrieve datafor validation.
Solid experience with back end testing.
Highly motivated resourceful team player that takes a positive approach to problem resolution.
Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
Ability to work independently, attention to detail and meet tight deadlines.
Built and maintained successful working relationships with immediate team members.
Ability to effectively communicate with cross-functional teams and UAT team.
Enthusiastic about learning new concepts in emerging technology.
A quick learner and easy adoptability to new environments, technology and people.
Technical Skills:
Testing Tools : HP-ALM, MTM, TFS, QMF, Mainframe (Green Screens) -TSO ISPF, Soap UI
Ruby/Cucumber, Azure, Jaws, IBM Rational, Postman
Defect Tracking Tools : Quality Center 9.2/9.5, ALM, Bugzilla, TFS, IBM Rational, JIRA
Languages : SQL and PL/SQL.
Database : SQL Server, Oracle, DB2, UDB2
Methodologies : Agile/Scrum, Waterfall
Operating system : Windows 2000, Windows XP/NT.
Others : MS-Word, MS-Excel, MS-PowerPoint
Familiar with : ESRI-ArcGIS, VB Script and Python
EDUCATION:
Bachelor’s Degree in Computer Science from Osmania University (India)
2 Year Higher Diploma in Software Engineering (HDSE).
Detailed Professional Experience:
Huntington National Bank (HNB), Columbus OH Dec ‘17 – Present
Role: Senior QA Analyst
Description: Accepted full time position with HNB, worked with the credit card team, Enterprise Sales & Services (ESS) team and currently working with MAX (Salesforce) team.
The projects are listed below:
Senior QA Analyst - OMNI Team – MAX Deepening (Mass Affluent & Active Branch Queue):
As QA Lead, impart focus to multiple projects involving different Business segments. Act as a key liaison with clients(Line of business) understanding their business needs to provide testing solutions within time.
1.Mass Affluent Description: This project is to automate the ability for bankers to own and manage customers’ subsets in MAX.
2.Active Branch Queue Description: The objective of this project is to build a customer check-in feature when they walk-in to the branch. This will help bankers in the branch to serve customers in a timely manner.
Responsibilities:
Attended user story refinement and estimation meetings
Reviewed the User Stories, PBI’s and the technical specification of the application with Business Analysts and Developers.
Created Test Strategy and reviewed with the Scrum team.
Tested 2 applications (Huntington.com and MAX) for branch check in functionality.
Tested Mass Affluent functionality in Salesforce Mobile app.
Created test cases based on the user stories.
Executed test cases in both environments and tracked progress in MTM/TFS
Logged defects in MTM and linked to the PBI’s in TFS.
Worked with Dev team to resolve issues and defects.
Worked with Business Application Owner and UI/UX team.
Retested the defects that were fixed, added the screenshots and closed the defects
Participated in the retrospective meeting and let the team knows what went well and what the team can better do for delivery of stories on time.
Having experience to manage the team as both offshore coordinator and onsite coordinator.
Managing test runs by creating a test run report
Created Test Status report and sent it to project team daily
Participated in User Acceptance Testing (UAT) and recorded user feedback, reported to QA Manager in the form of Change requests (CR's)
Interacted with cross-functional leads responsible for UAT - providing them with test schedules, test data, direction, and detailed test scripts.
Performed End to End Testing and Regression testing for every modification in the application and for each build.
Mentored new team members, helped with on boarding and knowledge management activities.
Environment: Microsoft Test Manager (MTM), Team Foundation Server (TFS), Backend Database Testing QMF (DB2 UDB2), Postman, SQL Server, Azure.
Senior QA Analyst - Salesforce Lightning Data Integrity: This project had multiple phases and was set out to address two major components:
1.Upgrade to the Salesforce Lightning UI and ensure functionality within the application works in the Lightning Experience comparably to how it used to work in the classic.
2.Address Customer data inaccuracies in MAX, using CIS as the source system of Customer and Account Information.
a.MAX application receives data from multiple sources including CIS, NML, Net Oxygen, Oracle HR, and Zoot/Lexis-Nexis. Although some business segments, such as Commercial, do informal reviews of MAX data, Audit identified that there is a lack of data integrity controls to verify the accuracy and completeness of the system data received by MAX from data feeds. Various data points tested by Internal Audit resulted in discrepancies in customer data in MAX when compared with source system data. Through inquiry with management, audit was informed that errors in production jobs and data mapping caused the data discrepancies.
b.Data flowing into MAX includes account eligibility information, loan application status, incentive compensation factors, and customer information, however MAX is not considered the source system for any of this data. So far, application data integrity controls to verify the accuracy and completeness of data exchanges were not immediately established.
c.Without a method for verifying data accuracy and completeness, imprecise customer account offers, incorrect account eligibility requirements, incorrect incentive compensation, and erroneous loan updates could exist. While MAX is not a system of record, inaccurate data could result in negative customer experience, increased processing time, and an increased risk exposure to the bank.
Below are the additional projects that I worked on, at Huntington and that were completed successfully:
Senior QA Analyst - Home Lending Project: Worked as a lead on this project – This Project is the first phase of a multi phased effort to provide enhancements to the Customer relationship Management tools employed by the Home lending and Business Banking teams. This also consisted of enhanced Velocify leads management functionality and the on-boarding of Business Banking to the Velocify and Marketing Cloud platforms.
Senior QA Analyst - OMNI channel project (GFA (guided financial assessment) /FHQ (Financial health quiz – Iteration 2) related to Salesforce: To meet consumer expectations and move into a “Category of One”, Huntington is redefining its branch strategy and approach to retail banking. Banker roles and responsibilities are evolving to create an advisory-like approach to everyday banking while, at the same time, the branch sales process is being redefined. As part of the ideal sales experience, technology will play a pivotal role and support the new process. Guided Financial Assessment will be a tool that can be used across channels to facilitate consistent relationship building, identify consumer goals and financial needs, personalize product recommendations, and improve the referral process.
ESS: Beneficial Ownership –This Project was related to Enterprise Sales and Services where changes and enhancements were made to HNB systems, policies and procedures.
EBOS: Easy Branch online setup –This project included branch bankers to set up Online Banking (for Consumer accounts) via ESS and automatically mail Adverse Action letters to customers who are not able to open an account. I validated, if Primary Owners, Additional Owners and Joint owners can enroll in online banking successfully.
EBOS Business (OMNI): The purpose of the EBOS project is to take the existing EBOS for Consumer functionality and add support for Business profiles with the upcoming changes to the Business Banking deposit product suite targeted for May 2019, this accelerated item provides critical lift for online enrollment, which is a required component for two of offerings (Reverse Positive Pay and Remote Deposit Capture). The elimination of the help desk phone call will streamline the online enrollment process (for ROL only - BOL is out of scope) and increase same day enrollment.
ROL Mirroring: SSO from MAX (SF to ROL (Retail online Banking).
Max Communities: This project was related to Salesforce where two communities were enabled Real Estate and strategic Partner.
ADA: American Disability Act - Testing for MAX communities’ project using Jaws professional software.(Section 508 of the Rehabilitation Act)
Responsibilities:
Created Master Test Strategy document and reviewed with the project team.
Uploaded the requirements to Quality Center.
Created test cases based on the requirement document.
Coordinated with cross impacted teams (EIM, SOA & DataStage) to provide testing timelines, help setup data and track progress.
Staged customer data in CIS, waited for the staging job to run overnight, to make sure the data is loaded from CIS to MAX staging tables and after the P1 delta process verified the next day that all data updates are reflected in MAX
Tested if data is sent via SOA services from MAX to CIS (downstream applications)
Validated the P1 delta jobs modified to make sure that the bad data is not getting inserted in the MAX application.
Coordinated with offshore QA team for test execution progress, helped them with any blockers or concerns.
Used QMF to validate all the customers data like name, address, phone number and email address. To make sure the data is flowing and stored correctly in customer information systems (CIS).
Worked as Test lead for End to End testing.
Worked on running XML in SOAP UI for customer data
Coordinated as a lead both with offshore team and onsite team.
Wrote complex SQL Queries to validate the integrity of the database and tested database table’s data
Performed data migration testing.
Worked with Dev team to resolve issues and defects.
Worked with Business Application Owner and UAT team.
Retested the defects that were fixed, added the screenshots and closed the defects
Created Test Status report and Burn Chart and sent it to the project team daily.
Mentored new team members and transferred knowledge where required.
Participated prod validations during the release weekends
Environment: HP- ALM 11.5, Soap UI, Backend DB Testing QMF (DB2 UDB2),, Mainframe (Green Screens) Passport, TSO ISPF, Salesforce.com Platform, Salesforce Lightening, TFS, MTM
TEK Systems, Inc. Columbus OH Mar ‘17 – Dec ‘17
Role: QA Analyst/Tester
Client: Huntington National Bank
Description: Huntington National Bank (HNB) is a regional bank holding company headquartered in Columbus, Ohio, with $100 billion of assets and a network of 996 branches and 1,855 ATMs across eight Midwestern states. I am working in the Credit Card Systems team and am responsible for the credit card origination, credit card servicing, credit card rewards and credit card alerts applications. I have been working on the HNB’s acquisition of the First Merit Bank (FMER) and transition of all the consumer and business credit cards applications into HNBs systems.(First Data Conversion and Integration Program – FDCIP).
FDCIP – This consisted of four sub-projects i.e. Credit Card origination, Servicing, Rewards and Alerts.
Responsibilities:
Core responsibilities involved in Testing of the banker facing application, consumer facing application, online credit application.
Reviewed the Business Requirement Specification Document and the technical specification of the application with Business Analysts and Developers.
Extensively created and executed Test Cases based on business requirements for all the applications of the credit card systems at HNB. – Project – FDCIP.
Back end system testing using M-Cycle, file testing in Mainframe (Green Screens) using Passport application.
Have thoroughly done peer reviews for Test Cases.
Performed End to End Testing, System Testing, Smoke testing, and Regression testing for every modification in the application and for each build.
Tracked and reported defects in ALM.
Involved in writing test plans and test cases to test different enhancements made to Credit Card Origination and Rewards application.
Created scripts to set up Test Data in QA environment based on Test cases.
Executed SQL queries in QMF to validate data accuracy for credit card transaction data.
Interacted with Business Analysts to clarify the functionality of the application.
Worked with IT leads in working through issues/defects & resolution.
Interacted with cross-functional leads responsible for UAT - providing them with test schedules, test data, direction, and detailed test scripts.
Reporting defects tracked using ALM and analyzed the variation between expected and actual results.
Create Traceability matrix, Risk Book.
Environment: Windows 7 Enterprise, DB2, UDB2, Mainframe (Green Screens) Passport, TSO ISPF, Backend DB Testing, HP- ALM 11.5, IE and Firefox.
Amalga Technologies Inc. Columbus OH May ‘15 – Sep ‘16
Role: QA Tester
Client: Arch Mortgage Insurance Company
Description: Arch Mortgage Insurance Co., provides residential mortgage insurance products to mortgage lenders and investors in the United States. The company offers various mortgage insurance products to meet the capital and credit risk mitigation needs of mortgage lenders and investors that protect them in the event of borrower default by reducing or eliminating the resulting credit loss to the insured institution.
Responsibilities:
Participated & reviewed the QA test plan and provided inputs to QA test plan
Extensively created and executed Test Cases based on business requirements.
Interacted with Business Analysts to clarify the functionality of the application.
Have thoroughly done peer reviews for Test Cases.
Performed Integration, functional, regression and end to end testing on application.
Tracked and reported defects.
Involved in writing test plans and test cases to test different enhancements made to Claims application.
Reviewed the Business Requirement Specification Document and the technical specification of the application with Business Analysts and Developers.
Entered various scenarios in Claims Application manually and ran the reports to verify if the claims are properly assigned to claims analysts based on Claims Amount and Lender.
Executed the new and existing test scripts on different releases and validated the actual results against the expected results by using Quick Test Professional.
Track test results for management, categorizing issues and creating/distributing defect reports and managing defect database using Quality Center.
Reviewing System Requirements to define testing scope for various levels of testing (Functional, System, and Regression).
Worked with IT leads in working through issues/defects & resolution.
Interacted with cross-functional leads responsible for UAT - providing them with test schedules, test data, direction, and detailed test scripts.
Reporting defects tracked using Quality center and analyzed the variation between expected and actual results.
End to End testing covering multiple interfaces.
Create Traceability matrix, Risk Book.
Update Regression Test suite after every Iteration.
Implemented industry best testing practices.
Environment: Windows 2000/XP, MS SQL Server, HP Quality Center 10.0, IBM Rational, QTP,JIRA, IE and Firefox.
Amalga Technologies Inc. Columbus OH Oct ‘14 – Apr ‘15
Role: QA Tester
Client: American Apparel
Responsibilities:
Participated in design walkthroughs to understanding the functional requirements, created test plans, test cases based on the requirements. Also, I was responsible for functional defect tracking and maintaining test suits in HP Application Lifecycle Management.
Created Structured Query Language (SQL) queries to perform Data Validation and Business Transactions of Membership & Providers tables and data types.
Created defects found in the application and escalate to the appropriate developer.
Wrote SQL queries and performed Back-End Testing for data validation to check the data integrity during migration from back-end to front end.
Tested the Login, Look and Feel, Shopping Cart, Order Status and Check out functionality.
Involved in Configuration Testing and Content Management System.
Perform end to end order scenarios to check the flow of order processing and payment process (OMS).
Used HP Quality Center ALM to create and maintain Test Requirements and defect tracking, also verified resolution of software and specification defects.
Involved in generating Requirements Traceability Matrix (RTM) for functional requirements.
Extensively used Quality Center for Test planning, Bug tracking, and Reporting.
Used SOAP UI tool to test SOA based architect application to test SOAP application and rest API
Execution of test scenario’s and analyzing the actual result against the expected result.
Worked on Purchase order, Versioning and transfer between warehouses by using SQL Database..
Participated in Weekly meetings and walk through to discuss Defect Priorities.
Extensively used Quality Center for defect tracking and reporting.
Networking Conducted the Smoke testing to check the high level functionality of the application.
Expertise and experience in performing different kinds of testing like Functional, GUI, Integration, Backend, Regression and System Testing
Environment: Windows 2000/XP, MS SQL Server, HP- ALM/ Quality Center - 10.0, IBM Rational, QTP, IE and Firefox.
Client: Avaya India Private Limited, Hyderabad, A.P. Feb ‘13 – Sep ‘14
Role: QA Tester
Project: App Launches
Description: The App launches project is used to submit the online service applications. This wasbrowser-based User Interface. There were five different phases involved in App launches testing like Data validation, App Validation, App Submission, Data base validation, Result analysis and Reporting.
Responsibilities:
Core responsibilities Involved in Manual Testing of the application.
Participated & reviewed the QA test plan and provided inputs to QA test plan
Fixed the Defects in the maintenance phase
Extensively developed and executed Test Cases based on business requirements.
Have thoroughly done peer reviews for Test Cases.
Performed Smoke Testing, Regression testing for every modification in the application and for each build.
Have done GUI &Integration testing of the application.
Discussed and analyzed about business requirements with business analyst to get all business scenarios.
Tracked and reported defects using Quality Center.
Work together with Software developers to resolve / reproduce the defects.
Expertise in analyzing and generating the Test Reports.
Environment: Windows 2000/XP, Quality center 9.5/ALM 11.0, SQL Server, QTP 9.5
Client: G E Money Servicing Pvt. Ltd, Hyderabad A.P. Aug ‘11 – Jan ‘13
Role: Quality Analyst/Tester
Project: Mortgage Loans Integration
Description: G E Money is financial services company provides financial services-including corporate and business, personal banking, mortgage servicing that meets a wide range of customer needs. The project was a web-enabled application involved in developing the banks module for an online mortgage application, which allows customers to apply for mortgage, check the status of their application, a mortgage calculator, where the customers can decide how much loan they can afford.
Responsibilities:
Interact with Business Analysts to clarify the functionality of the application.
Involved in Test Design includes Test Data Preparation and reviews
Developed test matrices to trace various requirements and scenarios to appropriate test scripts.
Validation of test and production builds manually.
Perform Functional and System testing on the application.
Involved in Project meetings and interacted with other team members in order to resolve the problems.
Analyzed defects status using Quality center and interacted with developers to fix defects of the application. Attend defect review meetings.
Provided Implementation support during the implementation and deployment phase.
Expertise in analyzing and generating the Test Reports.
Environment: Windows 2000/XP, Visual Source Safe, Quality center.
Contact this candidate