Ashraf Jamal Khan

Phone: 201-***-****

gvx9n5@r.postjobfree.com

***** ****** ** *** ***

Parma Heights, OH 44130

Summary

• Over 8 years of progressive IT Experience which includes experience in Application Analysis and Quality Assurance Testing of application systems in Client/Server, and Web environment both Automation and Manual Testing

• Expertise in Software development life cycle and testing Methodologies such as Agile, Water Fall, V-Model and Spiral model.

• Hands on experience in all phases of SDLC , requirement analysis, use case decomposition, test planning, estimation and strategy

• Good exposure in performing verification and validation activities, including preparation of test scripts, step-by-step execution of test scripts and reporting the bugs in Quality Center

• Adopted automation tools like Quick Test Pro (QTP) 9.2 and 10.0

• Experienced in testing & verifying Business functionality, Database and Security Standards for different client/server applications in the areas of Finance and knowledge of trading related applications (Options, Stocks, and Forex)

• Performed SIT(System Integration Testing), UAT(User Acceptance Testing),GUI Testing Performance/Load/Stress Testing, Functionality Testing, Back-end Testing using SQL

• Proficient in analyzing business requirement, writing Test cases, test scenarios and test deliverables

• Extensive expertise in requirements captures analysis, documentation, and translation in technical specifications

Skills Summary:

Testing Tools: QTP, Load Runner, Quality Center, Jmeter,Test Director

Database: PL/SQL, DB2, SQL Server and MS-Access, Oracle 11i/R12, Toad 4.6

Languages: Visual Basic 6.0, PL/SQL, C++, HTML

GUI Tools: SOAP 2.0,Front Page, Visual Interdev 6.0, Visual Studio 2003/2005/2008/2010

Internet: HTML, DHTML, and XML

O/S: Windows 9x/2000/XP/Vista, Window 2003, Window 2008, UNIX, Linux 9.0.

Networks: Microsoft Certified Professional (NT server track 2000, Networking Essentials)

Tools: Word, Excel, Access, Outlook, PowerPoint, Visio, Front Page, Toad

Professional Experience:

Kaiser Permanente (BETS Team) (Feb’2012 – Current)

Test Lead /Defect Checker

Kaiser Permanente is a leading and fast growing Health Care Benefit Provider. BETS (Benefit Enhancement Tracking System) is a Department responsible for All Client/Server based application Development for All MON(MidAtlantic,Ohio and North west), ROC(Regions Outside of California),HI and CO regions. Application development is being happened for ICD-9 to ICD-10 Conversions as well as Benefit and Coverage application.

Responsibilities:

• Communicate with offshore Team as QA has Offshore team for Screens and UI Testing.

• Conduct daily Defect Call to Discuss existing defects and their Status

• Create and Update Daily defect report in Team Room.

• Create defect report based on Tech Lead requirements.

• Update Quality Center Defect Tab for Closed, open, Fix in Progress Defect

• Assign defects to Dev or fixed defects to Tester accordingly.

• Create RTM(Requirement Test Matrix) based on Provided PSDD( Physical Design Document)

• Create Test Plan with the help of PSDD and RTM.

• Upload Test cases to Quality Center from RTM.

• Right Test steps and execute them when the Code is ready to Test .

• Create SQL queries required for testing prospective.

PNC Tech Center (Apr’ 11 – Jan’ 2012)

Role: Test Coordinator

PNC Financial group is one of the largest financial groups within USA enlarging their circle by many mergers and acquisitions happening. I was engaged for two major conversions (Bank Atlantic and Flagstar Bank). Worked directly with project manager reporting and updating is the key role of my position. Beside test coordinator role about 60% testing, Query writing, Query customization, Query running and logging results in Dash board, update query listing in SharePoint, Crating different query and result folders in Ca Clarity, Resources management using ALM 11.0 Administration privileges (Assigning different roles to the test team, Oversee test plan, Test results, defects etc) .WR Mailer, Mailfile, Main frame testing and validation.

Administrative Responsibilities:

• Conduct daily check point meeting.

• Conduct overall progress of the project.

• Report to the manager.

• Assigning different roles to the test team.

• Divide load evenly to the test team.

• Meet the time line.

• Help the team in writing query.

• Create Task folder in project repository for results.

• Create reports and forward them to the Dev Team.

General Responsibilities:

• Create and customized SQL queries testing and validate customer level and account level information.

• Create reports and send them to the Test Coordinator.

• Log on to main frame online accounts and validate customer information prior to sending Preconversion mailer.

• Update Test Plan and test Lab using ALM (Application Lifecycle Management).

Environment: Oracle 11g, Quality Center(ALM 11.0), Mainframe Mira Screens, Toad(Editor, Query Builder).Lotus Notes 8.5, Microsoft Office 2007, Windows xp2001.Ca Clarity PPM

LPS Empower, Sharon, PA (May ’10 – Feb’ 11)

Role: QA Analyst

LPS Empower is Prime Loan origination and Processing Firm. Having More than 50 Developers Only in Sharon PA Location with 20 Quality Assurance Analysts. Having First National Bank, Capital One, ING Insurance, Northern trust Commerce Bank and Redwood Trust etc.

We Develop, Customized, Merge Application as well as custom Patch Development according to client specification is our specialty. Application Development environment is .Net C# and Data Bases are SQL Server and Oracle 11G.

Responsibilities:

• Analyses FDS and BRD.

• Create and Customized Test Script and Used Cases.

• Create SQL Queries to test Different Code and Database testing.

• Used SQL to verify the Database Values.

• Import/Export xml file for customize Application Testing.

• Able to update Config files to make local host working.

• Perfect knowledge Of Microsoft Office suit.

• Attend all meetings Related to pre and Post Development of an Application.

• Bugs finding and defect tracking is a part of my job.

• Duplicating Issues before submitting is an assigned responsibility.

• V-Model and Agile Scrum Methodology.

Responsibilities as a QA Lead:

• Patch Review before patch closed.

• Smoke Test for the new deliverables.

• Help the team in creating test environment.

• Help team in creating SQL queries for testing Database.

• Able to oversee and solve exceptions in Log viewer and exception viewer.

• Tune Local host and customized code to make it work.

• Attended Meetings to Discuss B.R.D.s and Functional Documents.

• Create and Presented Power Point presentation for new Deliverable to the Client.

Experience as a Developer:

• Able to look into the code and trace the error.

• Open up new test set and change set to compare and find the changes.

• Customized the coding used .Net C# to make changes in the interface.

• Discussed different conditions for new deliverables with developers.

Environment: .Net C# development, Web and Windows Applications, HTML, SQL, ORACLE Database, XML, Microsoft Office suit, TFS, IIS, and SOAP.

Education Dynamics, Hoboken, NJ (Feb’09 – Apr’10)

Role: Sr. Quality Analyst

Education Dynamics -- higher education's leading marketing company, built from e-Learners, Educational Directories Unlimited, WorldClass Strategy and GoalQuest -- provides marketing and student affairs professionals the tools they need to meet their critical objectives in attracting students and retaining them through graduation. The company has pulled together the best in content resources and proprietary technology applications all managed by a team of professionals with unparalleled experience in the higher education field. Collectively, it is the only organization that delivers products and services with a proven track record for helping schools find, enroll and retain students. The Application is .net framework and it is completely web based application.

Responsibilities:

• Managed the requirements, Test Cases and Test Design in Quality Center

• Created GUI, Functional, and integration Test Cases in Quality Center.

• Involved in preparing test plans

• Followed the Agile scrum methodology.

• Performed BVT, UI, Functionality, Integration, System, and Regression tests.

• Involved in Daily Meetings and weekly Team Meetings.

• Used VSS system for Version Control.

• Used TOAD for querying Oracle databases.

• Developed, Enhanced, and Maintained automated testing scripts using VB Script in Quick Test Professional for Regression and functional testing.

• Involved in testing Web based SharePoint applications.

• Used Local Repository for storing the objects.

• Enhanced the script by adding Controlled structures (like If Else statements,

• For loops etc.) Depend on how test case demands.

• Developed several Checkpoints like standard checkpoints, bitmap, text, database checkpoints to the scripts.

• Used Regular Expression to identify dynamic objects.

• Performed parameterization to check how the application is behaving with multiple sets of data.

• Created several reusable Actions for reusing the Actions in several other scripts.

• Created Sub Procedures for reusing the same code within the same script by calling the Sub Procedure

• Created several libraries files for declaring global variables, functions etc.

• Schedule the Test scripts to run from Quality Center and store results on QC.

• Interacted with developers and business analysts to resolve the defects.

Environment: Quality center 9.2,10.0,SQL, TFS, .Net, HTML, IIS, Java Script, Web Logic, Rational Clearcase, UNIX, Microsoft Excel, QTP, Quality Center, and Test Director

Sovereign Bank, Boston, MA (Oct’07 – Dec’08)

Online personal & Corporate Banking

Role: Quality Analyst

Bank is a financial institution offering a broad array of financial services and products including retail banking, business and corporate banking, cash management, capital markets, wealth management, and insurance. NAO (New Account Opening) is an online Personal and Corporate banking project that involves development of new systems to support bank’s sales process. NAO helps a bank employee open a New Account for a customer by collecting and saving the various customer information and all the products the customer avails. Existing customers can be searched and edited using the application. This application is used by bank employee for opening a bank account and maintaining customer accounts and related information.

Responsibilities:

• Analyzed the system requirements and developed detailed test plans and test cases provided the documentation according to Agile Scrum methodology.

• Created Traceability between Requirements and Test Cases using Quality Center.

• Performed Unit Testing for NAO (User Registration Module and Existing Customers edit profile Module)

• Performed manual testing as per requirement including negative & positive testing

• Developed test plans and test cases according to business requirement given

Performed the Functionality Testing of the business processes & module according to the specification & expected results mentioned in the test cases

• Analyzed, Revised and Created test plans according to business requirements

• Performed Black box testing, Integration testing, System testing, data validation testing, end-to-end testing of the application and involved in white box testing

• Conducted Parameterization to data tables using Quick Test Pro

• Inserted Standard checkpoints to compare values between the required and the resultant Test Cases

• Performed Regression testing after bugs have been fixed to validate product fixes.

• Responsible for writing scripts which involved some advanced programming of scripts using QTP.

• Performed Developed cases and scripts using Quick Test Pro for Functionality, Security and Regression Testing.

• Wrote SQL queries in Query Analyzer to extract data from the database for Backend Testing.

• Developed Vuser Scripts to do performance testing in Load Runner.

• Conducted Data verification using SQL scripts and Integration Testing.

• Conducted database integrity testing using SQL Queries on reporting functionality.

• Interacted with Business Analysts, Developers and QA team members in different defect raising situations.

Environment: QTP, Oracle 8.0, Clear case, IIS,SQL, Quality Center 9.0, XML,.Net, Microsoft Visio Load Runner and Test Cases

Raymond James, St.Peterburg, FL (Jun’06 – Aug’07)

Fixed Income Trading System

Role: Quality Analyst

Project Details:

Raymond James is a diversified financial services holding company with subsidiaries engaged primarily in investment and financial planning, in addition to investment banking and asset management. Fixed Income Trading Platform is a solution for managing and executing trading orders for fixed income securities such as ABS, MBS and Money Market Instruments in an STP environment. It provides different trading environments and workflows for fixed income orders. Trader and manager can price the security, look for market data, and can do risk analysis using various in-built tools. It offers differences among order creation and trading methodologies based on different fixed income securities.

Responsibilities:

•

• Involved in developing test plans and test cases according to business requirement given

• Analyzed, Revised and Created test plans according to business requirements

• Performed Functionality testing, Regression and GUI testing in QTP and Lisa TEST and VALIDATION.

• Extensively interacted with front office (traders) and back office (settlement, operations) prime brokerage to analysis the system configuration and flow of the system to perform the automation testing

• Performed Usability testing.

• Used break points (to check investment levels), Rendezvous Points ( set for vuser script), multi action , split action, multi parameterization and correlation in QTP for business scenarios

• Responsible for writing scripts which involved some advanced programming of scripts using QTP

• Performed Automated Testing on sections on the website using QTP and Load Runner

• Wrote SQL Queries in Query Analyzer to insert and retrieve data from database.

• Performed data validation

• Participated in meetings with Project Team and Development Team to understand functional requirements

• Performed Backend Testing in Quick Test Pro

• Executed tests before and after bug fixes as a part of regression testing.

• Detected, Tracked and Reported defects using Test Director

• Participated in weekly meetings, where test status and defects were discussed, wrote enhancement and modification requests

• Involved in development of training material for user-acceptance testing

Environment: LISA Suit, QTP, Quality center 9.0, UNIX, Microsoft .NET 2005, XML, ASP.NET, HTML, Load runner, Oracle 10g, MS-Access, ERWIN 7.x, MS-Visio, SQL*Loader

Deutsche Bank, NY (Jan’05 – Apr’06)

FX E-Trade Platform

Role: Quality Analyst

The FX e-trade platform is an online foreign exchange trading application designed to provide clients with comprehensive market information and a high level of execution. This trading platform provides online margin foreign exchange trading services to private clients around the world. The no dealing desk options provides traders, through direct access to foreign exchange, to some of the best bid and ask prices via multiple bank access. This system feeds real-time streaming prices into the currency trading system. They are not simply indications of where the market is trading but actual executable prices where traders can buy or sell the currency pair.

Responsibilities:

• Created and updated test cases based on new and/or /updated functional or interface requirements

• Extracted data from an Oracle System and created MS Excel and MS Access reports

• Designed simple databases and queries to support reporting and analysis using MS Access

• Recorded scripts in QTP to perform Functionality testing.

• Created text area checkpoints to test the properties of the text in the application using QTP.

• Creating scripts to generate new Keywords for input, output and validation using QTP

• Executed automated test cases in QTP

• Recorded scripts in QTP to perform Functionality testing.

• Created text area checkpoints to test the properties of the text in the application using QTP.

• Creating scripts to generate new Keywords for input, output and validation using QTP

• Created baseline scripts for Regression testing in QTP

• Performed Data-Driven Testing using parameterization in QTP using advanced Data Tables.

• Interacted with developers to report and track bugs using Quality Center

• Performed requirement traceability by setting automatic alerts for tracing changes in the requirements and system maintenance

• Conducted Load Testing using LoadRunner for response time monitoring.

• Performed parameterization to ensure real time load conditions using LoadRunner.

• Monitored the scenario run using various online monitors in LoadRunner Analysis.

• Analyzed the results using LoadRunner Analysis Graphs.

• Evaluated test results to identify performance issues, bottlenecks using LoadRunner.

• Imported test cases from MS Excel, MS Word to Mercury Quality Center

• Participated in weekly meeting with the management team and walkthroughs

• Used Quality Center to create the test plan, store test cases and run the test sets

• Interacted with developers to report and track bugs using Quality Center

• Detected and reproduced the defects, and logged defects using Mercury Quality Center

• Generated the test execution report in Mercury Quality Center to be reviewed by the QA Manager and development team

• Prioritized testing efforts based on business risk

• Provided modification and enhancement request as needed to correct the defect and make the software more useable

Environment: Quick Test Pro (QTP), MQC, ASP, Quality Center, HTML, IIS 6.0, Windows NT, and SQL, LoadRunner.

Macy’s System and Technology, Duluth, GA (Jul’03-Dec’04)

Role : Tester

Macy's is a national brand delivering fashion and affordable luxury to customers coast to coast. Macy's stores are operated by 7 regionally-based retail divisions - Macy's East, Macy's Florida, Macy's Northwest, Macy's North, Macy's Midwest, Macy's South, and Macy's West. Home-related merchandise offered in all Macy's stores nationwide is planned, bought and marketed by New York-based Macy's Home Store. Online shopping is offered through macys.com. PACE stands for Planning is About Customer Experience. Financial Plans are the roadmaps developed to support the merchandise and Location Strategies within an organization.

Responsibilities:

• Developed and executed of test plans, Prepared work schedules, Resource planning and bug reporting

• Tasked with creating Test Planning, Test Design, Test Execution and Test Evaluation.

• Documented test plan and test cases using Clear Case.

• Involved in regression testing, Functionality, Navigation, Volume, Security testing of the Merchandise Planning module.

• Created a Test Plan according to the Test Strategy selected and smoke test template.

• Created Workbooks and Plans of various Chain and Location Department In & Pre Seasons.

• Involved in Look and Feel testing of the application windows using the deliverables.

• Tested the main functionalities of the application manually and validated data using Excel Sheets.

• Automated baseline scripts generated using QTP to perform Regression testing for different builds of the application

• Scheduled weekly meetings with office staffs, developers and QA team to discuss about quality issues.

• Tested database contents using SQL Queries and validating through Mainframes.

• Validated Data after the batch process is done and tested before and after batch tests.

• Wrote and executed SQL scripts to validate data which flows to the end user with the actual data in the Database.

• Testing the database using SQL queries in which IIS web server used as application server.

• Executing test cases and identifying mismatches and reporting defects into Bug Tracker and tracking them till they are fixed

• Analyzed the Results using various graphs and reports and using Bug Tracker and CARS.

• Created Data driven tests for multiple sets of data using QTP and for repetitive tasks.

• Involved in Data validation and Database integrity testing on the database.

• Documented Traceability Matrix for Defects on Daily, Weekly and Module basis.

• Developed documentation for User Acceptance Testing and trained the users about the system

Environment: SQL, HTML, Web Services, Rational Clearcase, UNIX, Microsoft Excel, QTP, Quality Center, and Test Director.

Experience Out of USA:

• Planed, Analyzed and developed Complete Online Library System Using .Net C# for well known Foreign University. Pakistan Campus.

• Part of the N.A.D.R.A. (National Database and Registration Authority) Team in developing Computerized N.I.C. (National Identity Card) application using VB.Net and ASP.Net.

Educational Qualifications:

Master of Science University of Karachi

Bachelors of Science University of Karachi

Diploma of Software Engineering Petro man Technical Institute

Bachelors of Education University of Karachi

Contact this candidate