***********@*****.*** Sultan Khan
Summary
Test Analyst professional with experience managing a diverse portfolio of
IT projects and business efforts for Fortune 500 companies. Over 9 years of
experience in Information Technology Project management, Software Quality
Assurance and Testing, expertise in System Analysis, Design, Implementation
and maintenance of test procedures for Web based and Client/Server
applications. Strong analytical abilities, reliable, goal oriented and
quick learner with excellent communication and interpersonal skills. Proven
ability to work effectively in both independent and team situations with
positive results.
. Strong process and methodology experience, providing mentoring and
coaching to product and project leadership and teams. PDLC, PMLC, SDLC,
epmm, waterfall, CMMI and Agile Process Engineering
. Excellent hands-on leadership, diplomacy and team-building skills.
Possess drive and commitment to see projects through completion with a
"going the extra mile" attitude and belief system ensuring customer
satisfaction
. Strong analytical, organizational, resource and cost management,
supervisory and communication skills. Ability to relate to people at any
level of business and management
. Experience with business planning, process/initiative financial tracking
and billing, forecasting, CRM and budget/actual analysis for various
organizations
. Highly skilled Quality Assurance consultant, Offering a successful
background in formal education and experience in Quality Assurance,
computer programming, software development, information security,
upgrades, software training, QA/Analysis and testing with proven
expertise in managing complex projects for Fortune 500 companies
. Excellent knowledge of Business Management and Business Operations
. Well acquainted with Software Development Life Cycle (SDLC)
. Expert Level experience of testing during all phases of the Software
Development Life Cycle from Initiation phase to the Software Release
phase
. Excellent knowledge of Microsoft Dynamics CRM, Microsoft Dynamics GP,
SFDC
. Excellent working knowledge of Product and Project Testing
. Expert in Manual and Automated Testing of Client/Server and Web
applications and developing & maintaining test plan, test cases and test
scripts
. Expertise in Test Case Design, Test Tool usage, Test execution, Defect
Management and Defect Tracking
. Expertise in Agile/Scrum testing methodologies
. Expertise in UNIX and Linux
. Experience in using MS Project
. Expert in GUI, Functional, Integration, System (Black Box), Regression,
Mutation, Usability, Grey Box, End-to-End, Recovery, Sanity, UAT &
Performance/Load Testing
. Experience in writing SQL and Pl/SQL scripts for backend testing
. Experience in using Mercury Interactive Automation Tools like QTP,
WinRunner, LoadRunner, TestDirector, and Quality Center
. Experience in using IBM Rational Tools like ClearQuest, ClearCase,
RequisitePro
. Expertise in using Command Editor, Configuration Assistant, TWS - Tivoli
Workload Scheduler 8.4, WinSCP - 3.6.2, Microsoft Access 2010 "New SDU
Test Data Tool", Putty
. Expertise in Setup and maintaining the test environments
. Advance Working knowledge of Version Control and Change management
systems
Technical Summary
Languages TSL, SQL, C++, JavaScript,XML, HTML, JAVA
Operating Systems Windows Vista/ XP/NT/7, Unix, Linux, Win Servers
Databases Oracle 9i/ 8i/7.x, Microsoft Access, SQL Server, DB2
Servers WebSphere Application Server, JBoss Application
Server, Windows server 2003, MS SQL Server 2008, MS
Share Point Server 2010, Exchange Server 2010,
Windows Server 2008
Testing Tools MercuryInteractive:QTP8.x,9.0,TestDirector6.x/7.x/8.
0,WinRunner6.x/7.x, LoadRunner7.x/8.x, ClearCase,
ClearQuest, Bugzilla, Team Track
Tools & Package SQL*Plus, SQL*Loader, Command Editor, Configuration
Assistant, Adobe Acrobat Suite, Microsoft Office
Suite, Tivoli Workload Scheduler 8.4, Microsoft
Office, CVS, WinSCP 3.6.8, Putty, IBM RequisitePro
Tomcat, DBvisualizer. Beyond Compare 2, SVN, SnagIT
8.2
Software Packages Microsoft Dynamics CRM, Microsoft Dynamics GP,
SalesForce, AS400, MS Word, MS Excel, MS Access, MS
Visio, MS Project, PowerPoint, Adobe Photoshop,
Cisco Call Connector, Varsity, ACT, Soft Phone
Internet Skills: IIS, FTP, Netscape, and Internet Explorer, Mozila
Firefox
Network Skills: LAN, WAN, TC TCP/IP, Subnet Mask, Active Directory,
Filezilla
Experience Summary
DCSS CSE, Rancho Cordova CA
Application Test Analyst III
April 11 - Current
Application: Department of Child Support Services- Child Support
Enforcement System
Project: CSE (Child Support Enforcement)
Environment IBM Rational ClearQuest, ClearCase, RequisitePro, DB2, Web
Services, windows 7, MS Project, QTP, Quality Center 11.0,
SnagIt 8, Command Editor, Configuration Assistant, Control
Center, TWS - Tivoli Workload Scheduler 8.4, WinSCP - 3.6.2,
Microsoft Access 2010 "New SDU Test Data Tool", Putty,
Visio, Load Runner, Microsoft Office, SQL, MS Share Point
Server 2010, Exchange Server 2010, JAVA, VPN, Unix
Responsibilities:
> Test Planning: Developed Test Plan, Test Strategies, Test policies, Test
Scenarios, Manual Test Scripts, Automation Test Scripts
> Operational Phase: Developed and implemented standard Testing Procedures
and Strategies
> Test preparation Phase: Identified and created Test Cases
> Test Execution Phase: Executed Test Scripts, Validated Test scenarios,
identified issues, logged defects, created batch files, executed batch
files, executed POCs, generated Issue tracking sheets and reports,
conducted meetings with stakeholders, performed troubleshooting
Albert Uster Imports, Gaithersburg MD
Software QA & Testing Manager / IT Project Manager
Feb 10 - April 11
Application: MS Dynamics CRM & GP
Project: Complete transition from AS400 to MS Dynamics CRM & GP
(Humongous amount of data in Terabytes)
Environment - Microsoft Dynamics CRM, Microsoft Dynamics GP, AS400, DB2,
Web Services, windows 7, MS Project, Cisco Call Connector,
Varsity, ACT, Soft Phone,QTP9.0, SnagIt 8, Bugzilla, Load
Runner, Microsoft Office, MS SQL Server 2008, MS Share Point
Server 2010, Exchange Server 2010, Windows Server 2008, .NET
Platform, MS Studio 2010, Active Directory, VPN, Filezilla
Responsibilities:
> Planning Phase: Developed, evaluated, and selected optimum closure
strategy
> Operational Phase: Developed and implemented new procedures and controls
> Project Planning Phase: Developed project plans and schedules, Business
Requirement Documents, High level and Detailed Solution Design Documents
> Project Execution Phase: Supervised project team
> Quality Assurance Phase 1: Generated Test Plan, Test Cases, Test
Scripts, QA roll testing process
> Quality Assurance Phase 2 - Testing: Performed Functional, System,
Application, performance, regression, & UAT
> As a hand on quality analyst, extracted lead files from the SFTP (Secure
File transfer protocol) and saved it in to the DB2, run the executable
file and fulfilled the process.
> Used DB2 command editor to generate, edit, execute and manipulate SQL
statements.
> Highly responsible for configuring, monitoring, troubleshooting the
database servers for DB2 using database access methods and SQL
queries.
> Highly responsible for developing, evaluating and selected optimum
closure strategy and reviewed detailed design documents for use cases
and data structure.
> Implemented Bug management process
> Generated Testing progress Matrix, Project Issue tracking, Test result
matrix, & Build release documents.
3Soft USA, Vienna VA
Software QA & Testing Manager/ Project Manager
Oct 09 - Feb 10
Application: UVISS (Under Vehicle Inspection and Screening Software)/
EMR/CRM
Projects: UVISS - Video intelligence, data mining and reporting software
tool.
EMR - A unique Application which combines complete EMR and ADS
functionality along with additional features.
CRM - Implemented MS Dynamics CRM solutions.
Environment - EJB 3.0, JDK 5.0, JBoss Application Server, Axis Web
Services, SVN, My Eclipse 5.1.0, MS Project, PostgreSQL 8.1,
Hibernate 3.0, windows XP Professional, Unix, QTP9.0, SnagIt
8, Clear Quest, X-planner, Load Runner, Microsoft Office, SQL
Responsibilities:
> Planning Phase: Developed, evaluated, and selected optimum closure
strategy
> Operational Phase: Developed and implemented new procedures and controls
> Project Planning Phase: Developed project Execution plans and schedules
> Project Execution Phase: Supervised project team
> Testing Phase: Generated Test Plan, Test cases, RTM, Bug Reports
> Extensively used MS-Excel for Importing/exporting data from QTP.
Razor Stream LLC, LAS Vegas NV
Sr. Software QA Analyst & Testing Lead Feb 07 -
Sept 08
Application: MAMBO (Media Application Management Broker Online) Front end
Application (helloworld.com, vmdirect.com, woozyfly.com)
Project: MAMBO: Manage/Control the added Content, performs encoding if
required save it in the database and user should be able to download and
view the content in the desired format.
Environment - JSP, Servlets, Struts, EJB 3.0, JDK 5.0, JBoss Application
Server, Axis Web Services, JMS Messaging, SVN, My Eclipse
5.1.0, XML, PostgreSQL 8.1, Hibernate 3.0, Ant 1.6.5, MS
Project, windows XP Professional, Unix, QTP9.0, SnagIt
8,Bugzilla, Team Track, X-planner, Load Runner
Responsibilities:
> Involved in Project design phase
> Generated Project Execution Plan using MS Project
> Generated Business Plan, Business Requirement document, Functional &
Technical specs
> Analyzed project earned value cost and schedule performance
> Prepared work breakdown, scheduling, and budgeting.
> Coordinated multiple stakeholders, including clients, outside
consultants, tenants, and regulators
> Generated Master Test Plan, Module Test Plans, and Performance Test
Plan, Test Cases & Scripts, RTM, Test Matrix, Bug & Test Progress
Reports
> Coordinated with offshore team on daily bases
> Performed Smoke, Functional, User interface, Integrated, UAT, System,
regression, and performance/stress testing
> Defect management by interacting with the development team, business
experts and subject matter experts
> Used Wiki to Generate User Guide Documents
> Generated work flows for Team Track
Gateway Computers Inc, Irvine CA
Sr. Software QA Analyst & Testing Lead
Nov 05 - Feb 07
Application (GPS 1.0, OC2.4-5, Gateway Select, Gateway.com)
Project: The Gateway Productivity Suite (GPS) is a comprehensive set of
applications designed to enable customization of the gateway products. GPS
will serve as the backbone engine for the configuration and pricing of the
products for the future order capture (OC) and consumer -facing
applications and will support E-source and gateway.com.
Environment - QTP 9.0, Load Runner 8.1, Bugzilla, Quality Center, Linux,
Java, My SQL, Oracle, Tomcat, CVS, WebSphere Application
Server (WAS), Jboss, JDEE, Windows XP, DBVisualizer,
Xplanner, SSH, Beyond Compare 2, SnagIT, CMS 6.7, Reman Tool
Responsibilities:
> Gathered Requirements and generated BRD
> Created detailed Test cases and Scripts for both GPS and OC
applications, generated Test Plan
> Extensively practiced OOP and designing concepts for web based testing.
> Develop QA procedures & Performed Smoke, Functional, User interface,
Integrated, System, regression, and performance/stress testing
> Used Bugzilla to log defects, generated RTM, Defect Matrix, and Test
Progress reports
> Identified major Defects in Functional testing of GPS
> Used SQL Commands to verify the changes replicated in DB correctly
> Used Quality Center to generate daily Bug reports
> Created test sets in Quality Center
> Generated Load/Performance Test Summary, and detailed Reports using
LoadRunner
> Used QTP 9.0 to automate the test cases.
> Used SSH, WinCVS, and QA server to generate new build.
> Highly responsible for configuring, monitoring, troubleshooting the
database servers for Oracle.
> Used Linux for QA server
> Involved in setup and configuring test environments
> Performed Smoke test on UAT and Prod environment after each roll out
Washington Mutual Bank, Irvine CA
Software QA Analyst/Tester
Sep 05 - Nov 05
Application (Order Outs & eDocs)
Project:
The "Order outs" project will provide functionality to manage the ordering,
tracking and escalation of all 'Order Outs' (for example, the flood
certificate, the Mortgage Insurance certificate and Verbal Verification of
employment). The "edocs" project - This will cover the electronic delivery
of 3-days disclosures, correspondence and closing packages.
Environment - Test Director 8.0, SQL, COBOL, windows XP, Snagit, JAVA
Responsibilities:
> Generated BRD, Test Plan, Test Cases, and Test Matrix
> Developed the Positive and Negative Test Cases for various modules based
on the business requirements
> Used SQL for DB changes and backend verification
> Developed and executed test scripts for regression and functional test
> Developed and executed Manual test scripts for SIT and UAT phases using
Test Director
> Logged defects for the errors found in execution and functionality of
the application, took snap shots of the application for developers to
identify the bugs easily using Snagit
> Developed SQL Script to validate Data Transaction in Front End Testing.
> Developed and executed SQL Queries via SQL Developer / SQL Navigator and
saved Test Result.
> Generated Log reports.
> Generated defect reports using Test Director.
> Used Quality Center to generate daily Bug reports.
> Generated different sets of data sheets to Order Products on RealEC site
> Reconciled the data sheets for all the products that they are according
to the agreed standards
> Created test sets in Test Director
> Coordinated with RealEC team to change the status of defects once they
are fixed at WAMU side
> Attended Weekly Test Team Meetings
> Conducted Walkthroughs with the Stakeholders for analyzing the testing
procedures among different modules of the application
Deloitte/State of CA/Bank of America/FDC, Sacramento CA
Software QA Analyst/Tester March 05 -
Sep 05
Application (CCSAS) / (SDU)
Project:
The (California Child Support Automation System -Child Support Enforcement)
CCSAS-CSE project is an effort being undertaken to create a child support
system to improve the operational effectiveness of the Department of Child
Support Services (DCSS) California.
Environment - QuickTestPro 8.0, Rational Test Suit, ClearCase, ClearQuest,
LoadRunner 8.0, Command Editor, Configuration Assistant,DB2,Windows XP,
SQL, UNIX
Responsibilities:
> Analyzed Business Requirements Document and System Requirement
Specification to develop QA procedures
> Involved in all phases of testing like Smoke, Functional, User
interface, UAT, Integrated, System, regression, Operations, SQT and
performance/stress testing
> Provided Operations Testing daily activities report to SDU team
> Attended weekly SDU Test Team Meetings and took meeting minutes
> Generated SDU Test Team Meeting Agenda for every week
> Performed Performance testing using LoadRunner
> Conducted Load testing by generating Vusers and distributing them on
different load generators and to determine the server's response time
using LoadRunner
> Performed backend database test and wrote SQL statements and procedures
to analyze the data with front-end data.
> Used Rational ClearQuest for defect reporting and requisite pro for
requirement storage.
> Used DB2 command editor to run DB2 commands.
> Also tested web based thin client applications as an additional web
portal.
> Involved in setup and configuring test environments
> Maintained excellent relations with development team and Stakeholders
> Generated Bug, Test Progress, Weekly Status reports and graphs
IT-Pak
Quality Assurance Tester Jan 00 -
March 03
Project:
The application was about a nursing home automation solution. It was aimed
to describe the workflow adaptation for important process such as claims
handling, employee management, patient management, and accounts management.
Environment - Visual Basic, SQL, Oracle, Windows XP, Java, HTML, CSS, JSP,
Bugzilla
Responsibilities:
> Involved in defining the Test Strategy, Test Objective and writing the
Test Plans to fulfill the System and User Requirements Criteria.
> Reviewed and Identified the System and Functional Requirements
> Created Test Requirements, Test cases and Test Scripts using Test
Director
> Performed all kinds of testing including, smoke, regression, UAT,
integration, mutation etc
> Developed Manual scripts to test the functionality of the application
> Performed Regression testing by executing the scripts.
> Executed SQL statements for Data base testing
> Performed Defect management by interacting with the development team,
business experts and subject matter experts
> Used Bugzilla for defect reporting & tracking
EDUCATION:
Bachelors of Computer Information Management
Life University
Marietta, GA
Certifications
. Software Quality Assurance
. Software Testing
References Available upon request