Information Technology Data

SYED MUSTAFA AHMED AL AHDAL

“*.*******@******.***” • 786-***-****

Summary of Qualifications

Several years of solid professional experience in Information Technology and Business Management.

Extensively involved in testing software applications and reporting defects.

Diversified experience in QA Analysis, Test Plans preparation, Test Cases design and testing of Business applications.

Experience in developing and executing Test Plans, Test Scripts, Test Cases and Test Scenarios based on the Functional documents and Business requirements using test management tools.

Experience in different types of testing like Functional Testing, Integration Testing, Black Box Testing, Database Testing, Regression Testing, System Testing and UAT (User Acceptance Testing).

Excellent understanding of SDLC (Software Development Life Cycle), STLC (Software Testing Life Cycle), Bug or Defect Life Cycle and Testing Methodologies.

Experience with IBM Rational Clear Quest, Test Manager, Requisite Pro.

Comfortable with working on new tools like Mercury Interactive Quality Center, Mercury Interactive Quick Test Pro.

Strong Educational background in Business and Information Technology.

Strong Finance & Data Analysis Experience.

Very well experienced in Query Writing (SQL).

Experience with SQL Server/Oracle and Toad as well.

Strong Data Analysis skills including Pivot Tables & Charts.

Experienced in presenting Data in charts, Graphs, Tables and understand the concepts of designing and developing relational databases for collecting data.

Able to write Data Definition, Data Manipulation & Transaction Control Languages.

Strong experience with Business Applications.

Hands on experience with PC Applications mainly MS Office (Word, Power Point, Excel, Access, Outlook).

Strong Internet Searching Techniques.

Adequate public speaking, presentational skills & report writing capabilities.

Good analytical capabilities with well-grounded data analysis & inferential skills.

Able to plan and manage time effectively in order to meet deadlines and ability to perform under tight schedule.

Strong analytical and problem solving skills and a good team player.

Excellent written and verbal communication skills and always try to float ideas.

Adaptable to work both as a team member as well as independent.

Self-motivated and willing to do what it takes to get the job done.

Professional Experience

CIBER, Inc. (Client: Highmark, Inc. - Blue Cross and Blue Shield Association) July 26, 2011 – Present

Associate Consultant – Quality Assurance / Functional Test Analyst

Engaged in the full testing cycle from project requirements till UAT.

Development and maintenance of detailed test cases from specifications and requirements.

Ensuring appropriate coverage of application functionality in the various test plans and test cases.

Ensuring standards and processes are followed and met.

Writing functional test plans/scripts to ensure proper design functionality in accordance with test plan objective.

Performing test execution and reporting.

Ensuring test results and metrics are collected and reported.

Correspond bugs using defect-tracking tool and subsequently verify bug fixes.

To report defects and guide developers to fix the issues.

Tracking changes in existing requirements / new requirements appearing in the Project.

Preparing Meeting Agendas.

To discuss regular project status with the client.

Examination of application defects and classification based on severity.

Participation in Requirement Walkthroughs and Defect Report Meetings periodically.

Appling Order By, Group By and Having clauses to pull the needed data.

Restricting and Sorting Data using Where clause, Boolean Logic, References, Expressions etc.

Using Joins (Left Join, Right Join, Inner Join) to make the data useful.

National Bank of Pakistan Jul 15, 2009 – Dec 23, 2010

Officer Grade – I

Develop and maintain detailed test cases from specifications and requirements.

Executing test cases according to test plan and reporting results.

Communicate products defects to development, report defects using defect-tracking tool and verify bug fixes and performing User Acceptance Testing and Regression Testing when changes are introduced.

Responsible for the creation and execution of test scripts as well as defect logging, tracking and resolution.

Involved in creating functional and technical test case documents.

To report bugs and working with developers to fix the issues.

Keeping track of the new requirements from the Project.

Created and executed test cases, verified the actual results against the expected results and documented for UAT.

Preparing the Agenda for the meetings (e.g. weekly team meeting etc).

Attended regular client calls and discussed weekly status with the client.

Interaction with Development Team to validate test plans / test cases.

Investigation of software bugs and categorization based on severity.

Participated in Walkthroughs and Defect report meetings periodically.

Developed the test plan and test case documents based on the business requirements documents.

Involved in the complete testing cycle from project release to UAT.

Analyzed application bugs, interacted with team members for problem solving issues and discussing weekly project status with the developers.

Meticulously applying DDL (Data Definition Language) and DML (Data Manipulation Language) to define & manipulate Schema Objects in the RDBMS (Relational Database Management System).

To create Constraints, Views, Indexes, Sequences and Synonyms to produce the required output.

Utilizing Expressions and various SQL Functions (i.e. Character, Number, Date, Conversion functions & Group Functions) to exhibit the desired information.

Appling Order By, Group By and Having clauses to pull the needed data.

Restricting and Sorting Data using Where clause, Boolean Logic, References, Expressions etc.

Using Joins (Left Join, Right Join, Inner Join and Full Join) to make the data useful.

Bank Alfalah Limited Jun 18, 2007 – Jul 14, 2009

Range-III Officer

Implementing Tables and Views on RDBMS & working with Query Fundamentals.

Submitting SQL to access & manipulate database i.e. RDBMS (Relational Database Management System).

Extracting information from the database thereby making it more meaningful.

Introducing & keeping records updated and as well as creating aliases, joins, unions, constraints, primary keys, foreign keys etc.

Creating new tables plus creating views in the database vis-à-vis specifying links between tables and imposing constraints between tables.

Worked well on both the parts of the SQL i.e. DML (Data Manipulation Language) & DDL (Data Definition Language) and as well as SQL Aggregate functions & SQL Scalar functions.

Analyzing viability of credit applications using computer based models & thereby making recommendations (reports on MS Applications) for onward submission to corresponding credit authority chain for final decision making.

Review client’s performance via bank’s allocated Specialized Banking Systems to assess utilization pattern of facilities, business generated, adjustment of loans, deposits maintained, credit information report, past relationship etc to predict client’s overall future stability.

To manage a portfolio of highly active clients while accommodating regular addition of new clients as well.

To make detailed Credit Line Proposals & perform account reviews with the help of Special Banking System and Analytical Applications.

Thoroughly understanding client’s banking facilities needs by assessing client’s nature of business, ownership type, market reputation, projects in pipeline, financial statements & other related factors.

To conduct comprehensive industry analysis through several information media options.

Communicating with clients on regular basis to resolve their routine banking operations’ concerns by keeping in touch with various divisions including information technology, trade, credit administration, treasury, finance & operations.

Coordinate with the branches/head office/customers mainly through MS Office Outlook to get additional feedback necessary for evaluating credit applications.

Recommending structuring credit limits & formulating repayment schedules on MS Excel using statistical formulae.

Standard Chartered Bank (Pakistan) Limited Nov 06, 2006 – Jun 08, 2007

Associate

Worked well on both the parts of the SQL i.e. DML (Data Manipulation Language) & DDL (Data Definition Language) and as well as SQL Aggregate functions & SQL Scalar functions.

Extracting information from the database thereby making it meaningful.

Implementing Tables and Views on RDBMS & Working with Query Fundamentals.

Using SQL to obtain the right of entry for particular information in the database & manipulate it if required.

Introducing & keeping records updated.

Creating new tables plus creating views in the database.

Specifying links between tables and imposing constraints between tables.

Creating new tables plus creating views in the database.

Ensure credit limits are placed in the Enterprise Resource Planning System of the Bank as per the security compliance certificate.

Dropping, restoring & moving credit lines on the ERP System on just in time basis, keeping an eye on the approved credit applications.

Ensure overdraft rates are properly calculated & updated in the Bank’s ERP system on regular basis.

Ensure long term & money market loans are disbursed/repriced on timely basis on the Banking System to avoid irregularities.

Ensure that all MIS Reports e.g. interest overdue report, loan maturity report etc are prepared internally & circulated to the respective stakeholders in a timely manner.

Ensure all the queries/concerns emanating from Client Relationship Dept. whether linked to ERP Banking System, Audit concerns or Customer related etc are immediately attended & resolved promptly.

Linking with Banks other Information Technology teams located in Pakistan & India to resolve all the concerns with respect to the problems identified in the ERP Banking System and to perform User Acceptance Testing on new ERP reports/ERP modules.

Maintain robust working relationship with client relationship, treasury, information technology, trade, audit & operations teams.

To ensure satisfactory rating during internal & external audits.

Saudi Pak Commercial Bank Limited Nov 23, 2005 – Nov 01, 2006

Officer Grade - II

Worked well on both the parts of the SQL i.e. DML (Data Manipulation Language) & DDL (Data Definition Language).

Worked well on SQL Aggregate functions & SQL Scalar functions.

Implementing Tables and Views on RDBMS.

Creating new tables plus creating views in the database.

Applying SQL to access & manipulate database i.e. RDBMS (Relational Database Management System) by executing queries against them.

Retrieving information from the database thereby making it meaningful using Distinct, Where, Between, Order by, And, Or etc clauses

Inserting & updating records and as well as using Like & Wildcard operators.

Creating aliases, joins, unions, constraints, primary keys, foreign keys etc.

Analyzing viability of credit applications using computer based models & thereby making recommendations (brief reports on MS Applications) for onward submission to corresponding credit authority chain for final decision making.

Thoroughly understanding client’s banking facilities needs by assessing client’s nature of business, ownership type, market reputation, projects in pipeline, financial statements & other related factors.

Review client’s performance via bank’s allocated Specialized Banking Systems to assess utilization pattern of facilities, business generated, adjustment of loans, deposits maintained, credit information report, past relationship etc to predict client’s overall future stability.

Coordinate with the branches/head office mainly through MS Office Outlook to get additional feedback necessary for evaluating credit applications.

To conduct comprehensive industry analysis through several information media options.

Recommending structuring credit limits & formulating repayment schedules on MS Excel using statistical formulae.

Education

1) Masters in Business Administration

Karachi University Business School

University of Karachi

2) Bachelor in Computer Science

FAST (Foundation for Advancement of Science & Technology)

University of Karachi

Contact this candidate