Haider Afzal

PROFESSIONAL SUMMARY:

•Over Eight years of experience in Quality Assurance professional field.

•Strong knowledge of Software Development Life Cycle (SDLC) including Waterfall, Agile Methodology, RUP having an understanding of various phases of Requirement, Analysis /Design, Deployment, and Testing.

•Very well versed with quality assurance techniques for client-server and web-based applications, in different industries including Health IT, CRM, and Financial/Banking.

•Developed and executed test cases, manual and automated.

•Involved in all STLC phases.

•Experienced at defining the test process; identify the risk, test stage definition, methods (inspection, review, dynamic) and baseline acceptance criteria, and deliverables.

•Gap Analysis, understanding of the cross-functional process, understanding of the business operation and process development methodologies.

•Experience in testing with SQL PL/SQL scripts.

•Documented test results and software features being tested to ensure the highest quality results.

•Great experience with backend testing utilizing complex SQL statements. Excellent grasp of advanced SQL OLAP functions that can help slice and dice the data with minimal code.

•Worked independently to interpret and expound on software functionality.

•Experienced in training other professionals and provided team leadership.

•Adept at reporting the test results and various matrixes.

•Well versed with testing applications platformed on UNIX, LINUX and Windows operating systems.

•Experience in writing and tweaking Shell Scripts and using Cron jobs.

•Developed manuals for Application End Users, and provided training for Application functions such as Cognos Insight reports.

•Experienced in different Defect tracking and reporting systems including HP Quality Center 11.5.2 (ALM), FIT Issue Management System, BugHost.

•Proficient in User Acceptance Testing (UAT).

•Extensive knowledge of health industry including insurance ICD 9 / ICD 10, CPT Codes, HL7, and HIPAA transactions including transaction set 837.

•Great at analyzing the root cause of the issue and impact of it, and communicate it to the management.

TECHNICAL SKILLS:

•Operating Systems

UNIX (AIX, HP), LINUX, Windows

•Programming LANGUAGES

SQL, PL/SQL, UNIX Shell, HTML

•RDBMS

Oracle 11g, 10g, 9i, Teradata 13/12/V2R6, MS- Access, SQL Server 2000/2005

•Testing/Tracking Tools

HP QTP, HP Quality Center (ALM), ClearQuest, BugHost, Bugzilla

•ETL/BI

Pentaho 4.2, Informatica 9.1, Teradata FastLoad, MultiLoad, BTEQ

•Tools & Utilities

SQL Developer, Toad, SQL Assistant, IBM Cognos 8, MS Office, MS Visio,

PROFESSIONAL EXPERIENCE:

Associated Bank,

Stevens Point, WI

Role: Sr. QA Analyst

Duration: Nov 2014 to Current

Associated Banc-Corp is a U.S. regional bank holding company providing retail banking, commercial banking, commercial real estate lending, private banking, specialized financial services, and insurance services. It is the largest bank (by asset size) headquartered in Wisconsin. The bank's main focus is middle-market commercial banking in the Midwest area.

•Worked extensively on Web Portal, the main interface for Enterprise Lending Center (ELC) software

•Worked on new process workflows to incorporate changes into test plans and procedures after TILA RESPA 2015 guidelines became effective in the year 2015

•Executed all test cases and reported defects using HP ALM, verified fixes, and closed bugs during end to end phase of testing

•Regression testing was done to ensure proper application functionality, data entry, processing, and interface stability with an established baseline for future tests.

•Performed periodic smoke testing on ELC after every software release to ensure all loan processes flow smoothly and normally in all channels i.e. Retail, Correspondent & Wholesale.

•Created test plans involving general loan processing procedures for mortgage types e.g. Fixed Rate & ARMs, Conventional, FHA, VA, USDA, Rural Housing, Non-Conforming, Home Ready, Jumbo, HELOC & Reverse mortgage types.

•Tested detailed procedures for complete line of user groups i.e. Originators, Reg team & Pre-processors, Processors, Underwriters, Closers, Post-Closers, Appraisal Reviewers, Document Custodians, Final Docs & Third Party Originators and Coordinators (TPO)

•Originated loan applications routinely to test against various loan scenarios such as, Denied, Suspended, Withdrawn, Incomplete, Change of Circumstance, Cures, Waived Escrows, Tax Disbursements, and Flood Insurance etc.

•Validated forms and documents - loan estimates, loan commitment and cover letters, loan acceptance letters for Correspondent & Wholesale, standalone disclosures, closing packages, 1003 loan applications, 1008 transmittal summaries, compliance reports, and agreements.

•Tested interfaces as part of ELC – CBC Innovis Credit, Informative Research, Fannie Mae Credit and Desktop Underwriting, Fannie Mae Early Check, Ernst Fee Services, First American PredProtect, Flood, and FraudGuard.

Environment: HP ALM Quality Center 11.5, Mortgage Cadence, ELC, Borrower Center, Desktop Originator, Windows 7, Microsoft Sharepoint, AMC Blueworks, Microsoft Office, MS Visio, UAT, End-to-End.

Capital One Bank, St Cloud, MN

Role: Sr. QA Analyst

Duration: Jan 2013 to Nov 2014

Capital One is a diversified bank that offers a broad array of financial products and services to consumers, small businesses and commercial clients. A Fortune 500 company, Capital One has one of the most widely recognized brands in America.

•Participated in discussions with product owner and subject matter experts to understand the requirements document business

•Attended team meetings to clarify user stories and requirement changes involving Collateral Management System (CMS), the loan processing software being tested

•Implemented testing strategy before and after every two-week release sprint

•Created user stories and flow diagrams to assist in writing test acceptance criteria

•Conducted formal and informal product design reviews against requirements to provide input on functionalities and verify expected outcomes before the launch

•Tested procedures for a range of fixed rate and adjustable rate mortgage products as well as agricultural lands to ensure products were set up as per guidelines and pricing grids

•Executed test cases involving loan processes from Origination to Booking, document and fee validation, running utilities, ordering services and completing a list of loan tasks

•Made suggestions to the team and gave input on automating nightly builds, Integration, and regression, as well as exploratory and acceptance testing

•Provided continuous feedback to the entire development team on the status/progress of several CMS functionalities being tested

•Coordinated closely with development to review code, groom requirements, end-user stories and discuss situations where further coding was required

•Uploaded and hosted various document types using Microsoft Share Point to share with the team

LPS, Cleveland, OH

Role: QA Analyst

Duration: Jan 2012 to Dec 2012

LPS Field Services is a national field service company dedicated to assisting mortgage servicers in satisfying loan servicing requirements.

•Assisted in the development of User Stories while unilaterally working with the business unit.

•Helped evolve Field Services with respect to various externalities.

•Created individual test scenarios to cater to a wide array of mortgage servicing needs.

•Created Test Cases and Test Scripts.

•Managed and created test data to stay in compliance with the dynamic mortgage industry.

•Worked extensively on loan servicing mediums of delivery.

•Facilitated in the customization of Inspection forms to enhance the efficiency of data collection.

•Documented all stages of testing and development through electronic channels.

Priority Health, MI

Role: Software QA Analyst

Duration: Jan 2010 to Dec 2011

This project is designed to ensure PH is compliant with the Consumer Information Provision of the Affordable Care Act. The Consumer Information Provision requires the distribution of two documents, one titled the Summary of Benefits and Coverage (SBC) and the other a Uniform Glossary of common health insurance terms.

The automated solution will involve using a new software called Intelledox for document generation. This will allow PH to pull plan information from Metavance into the SBC template using the terminology and guidelines specified in the regulations.

•Involved in the meeting with Business process owners, SME (subject matter experts) and other stakeholders for Requirements gathering and refining in definition stage.

•Gathered, documented, and analyzed user requirements for creating a Test Plan.

•Developed a Test Plan and communicated to all team members.

•Validated the data collection phase by testing "Coverage Calculator Transformations". This involved validation of file extracts created by Informatica mappings.

•Used test data for verifying the proper functioning of the SQL scripts that calculate coverage.

•Extensive use of complex SQL for data validations. Used advanced SQL functions and also tested PL/SQL functions and procedures.

•Developed Process Model and detailed Business Policies and modified the business requirement document.

•Heavily involved in the transition from ICD-9 to ICD-10 codes.

•Validated the document generation both manually and through the application Intelledox.

•Verified the storage of documents to SharePoint after being generated.

•At the backend, validated the processes involved in validating the SBC document. Benchmarked the generated document against the template provided by the Government.

•Created test cases and test scripts for the front end web pages, for the validation of the newly added functionality that makes the SBC document easily accessible to the consumers.

•Reported defects using HP Quality Center, also verified fixes and closed bugs during regression testing. This testing was done to ensure proper application functionality, data entry, processing, and interface stability with an established baseline for future tests.

•Used application lifecycle management (ALM) for managing requirements, test planning, and functional testing.

•Developed various test cases for data validation and business function validation of UAT.

•Pulled source data for UAT validation.

•Extensively involved in meetings and reviews to resolve issues related to open issue.

•Developed Test Metrics on the weekly basis for senior management.

Nuesoft Inc., GA

Role: Software Test Analyst

Duration: August 2009 – June 2010

This project focused on quality assuring a web-based CCHIT Certified® electronic health record System (NueMD). The system comprises of a .net based workflow system and integrations with many external systems including SureScripts, Lab Diagnostics, Eligibility Verification portals and more. Emphasis was also laid on making sure that the software complies with HIPAA requirements. Project was developed offshore

•Worked in an Agile Environment on the web-based EMR (Electronic Medical record).

•Involved in requirements gathering documents.

•Liaison between business partners and overseas developers.

•Developed and executed various manual test cases and documented the processes to perform functional testing of the application.

•Performed Cookie Testing and Security testing for application servers confirmation, HIPPA security and compliance standards.

•Performed GUI testing, usability testing, and Browser compatibility testing.

•Developed and executed various integration testing scenarios incompatibility of a system with pharmacies, labs medical claims.

•Involved in the testing of NueMD Medical Billing Software component. It included the QA of the EDI Payment Remittance - 835, Eligibility Inquiry-270, Eligibility Response-271.

•Gained extensive health insurance industry domain knowledge including ICD-9, CPT Codes, HL7 Interfacing, ePrescription, Labs Integration.

•Documented the process of data flow with other Third Party Applications.

•Document any defects, and work with the project team to resolve defects identified during the development.

Education:

Bachelor of Arts, International Relations, Minnesota State University, MN

Contact this candidate