KAWALDEEP SANDHU
New Jersey, USA
(: 704-***-****
(: ***********@*****.***
[pic]
Job Summary and Core Competencies:
V 11 years of strong experience in Release Management, Business, Functional
and Quality Analysis in Retail, Publishing and Telecom domains
V Around 5 years of extensive working experience as Business Analyst, UAT
Coordinator, Test Manager and Release Manager at different Client's
places in USA.
V Have working experience with fortune 500 software enterprises such as
Lowe's Companies Inc., Pearson Education and Wolters Kluwer
V Gigantic experience and knowledge in Retail, E-commerce, Publishing,
Telecommunication and knowledge of Accounting, Finance & Banking domains
V Experience in managing application support releases from planning and
development through production implementations
V Experience in testing of client/server and E-commerce applications (web-
sites and portal testing) with Manual and Automation testing approaches
V Proficient in BPM (Business Process Modeling) and BPT (Business Process
Testing) strategy
V Expertise in all kinds of Black Box testing techniques. testing processes
and methodologies
V Knowledge and experience in testing Siebel, Sterling, JD Edwards, BMC and
Kenan products/modules
V Working experience in Agile methodology, V model, Waterfall model and
Spiral model
V Expertise in design, review and execution of Test Strategy, Test Plan,
Test Cases and Scenarios from BRD & Use Cases
V Vast experience in Client Management, Vendor Management & Team Management
in onsite-offshore delivery model and setting up independent QA/Testing
Centers
V Expertise in eliciting system requirements, documenting requirements,
defining business processes, and identifying risks based on
functionality, workflow and business rules.
V Expertise on Bug tracking tools: Team Foundation Server, Test Director,
HP Quality Center, JIRA
V Well acquainted with complete Software Test Life Cycle (STLC) and
exposure of all stages of Software Development Life Cycle (SDLC) and
Defect Life Cycle
V Exceptional ability to maintain and build client relationships, interact
one on one with clients, business stakeholders and converse with all
facets in the clients organization
V Excellent problem solving skills with a strong technical background and
good interpersonal skills
V Quick learner and excellent team player having ability to meet tight
deadlines and work under pressure
V Proven ability to work efficiently in both independent and team
environments
Professional Achievements and Awards:
< "Certificate of Excellence" from Pearson Technology
< "Certificate of Excellence" from Lowes Companies
< "Certificate of Excellence" from HCL Lowes Testing Center
< "Best Performance" Award from HCL Technologies
Professional Experience:
* Working for HCL America, USA as Associate Project Manager since July
2005 till date
* Worked for Gnix Infosoft, Noida India as Member QA Group from Mar 2004
- Apr 2005
* Worked for HCL Technologies, Gurgaon India as Trainee since Jan 2003 -
Jul 2003
Technical Skills:
Testing Tools Winrunner, QTP
Operating System MS-DOS, Windows, Unix
Databases Oracle 8i, MS-SQL Server, Sybase
MS-Package MS-Office
Version Control Tools PVCS, CVS, Star Team
Bug Reporting Tools Team Foundation Server, Test Director, Quality
Center, JIRA
Projects Undertaken:
Project Name Corporate Legal Services - Application Support and
Maintenance
Client Wolters Kluwer
Role Release Manager and QA Manager
Team Size 23
Duration Jun 14 - till date
Location NY USA
Responsibilities and Achievements:
* Responsible for enforcing ITIL processes
* Directs and executes all phases of production support releases
* Ensures adherence to the master Project Schedule focused on the cross-
organizational interdependencies
* Communicates project and QA status to involved constituencies
* Manages and coordinates the migration process
* Responsible for prioritization, assignation and resolution of ASM
tickets.
* Co-ordinate with other track leads in resolving tickets.
* Work closely with individual track leads for e.g Order Point, One
World and BI. Ensure SLA adherence and process compliance in co-
ordination with onsite and offshore individual track leads.
* Liaise between user community and project team; mentoring the team
and providing technical & functional support and training to the
project team
* Responsible for adherence to SLAs & Participate in review meetings.
* Responsible for IRT's resolution in co-ordination with Business
analysts and technical leads
* Co-ordinate any service outage investigations and incident reporting.
* Provide Effort confirmation for billing.
* Risk management - project risks and people risks - and development of
mitigating strategies
* Recognize change management issues and risks; develop recommendations
and mitigating strategies.
* Manage project resources to ensure maximum efficiency, effectiveness
and resource utilization
* Responsible for delivering quality code to production
* Responsible and Accountable for managing the overall test effort
across the unit
Project Name Enhanced 911 and DIDs in FX
Client Telepacific Communications, USA
Role Business/QA Manager
Team Size 5
Duration Mar 13 - Feb 14
Location NJ USA
Details:
E911 project seeks to build in more automation in existing
TelePacific applications in order to enable the processing of the
911 and E911 requests with the 911 Service Provider (ILECs/Intrado)
without the need of much manual intervention from the LIM
Provisioning team.
DIDs in FX project is intended to add functionality in FX to support
identifying service features on individual DID's for SmartVoice PRI, CAS
and SIP services.
Responsibilities and Achievements:
* Responsible for requirement gathering and management of a program
involving 10 integrated applications
* Performing feasibility study and analysis of the new program vis- -vis
legacy applications
* Preparing extensive System Requirements documents
* Bridging of documentation and information gaps, brainstorming
discussions on road blocks with all stakeholders
* Managing communications and coordination between Business, Development
and QA teams
* Assisting the QA team with QA methodologies, processes, testing
artifacts and deliverables
Project Name CIF-BPEL 2.0
Client Pearson Technologies, USA
Role Test Manager
Team Size 5
Duration May 12 - Feb 13
Location Upper Saddle River, NJ USA
Details:
The contract Information Form process automates and replaces the paper
based Contract management workflow in place. The contracts are basically
the agreement outlining the terms and condition of services provided by the
Authors contributing content.
Responsibilities and Achievements:
* Responsible for planning and managing the QA activities of 3
integrated projects
* Conduct End-to-End Analysis of all Business and System/Application
Changes to determine the most effective Test Strategy/Approach in
accordance with internal SDLC processes.
* Managing overall Release Test efforts across Test Leads and
onshore/offshore Test Analysts
* Responsible for test plans, benchmarking and test result analysis for
Performance testing
* Report and communicate status/risks/etc. directly to Director/VP-level
and appropriate Project Management
* Manage the reporting of periodic QA Status Reports and QA Testing and
Financial Metrics to Senior Leadership
* Assess Defect impact on Test Deliverable(s) and Schedule to
proactively determine the contingencies
* Responsible for enforcing and auditing the QA processes and
methodologies
* Also responsible for Assuring alignment of strategic quality
initiatives with corporate goals and scorecards
* Actively assisted the team in testing the Electronic-Contract
workflows
Project Name Higher Education Workflow Rewrite (HEWR)
Client Pearson Technologies, USA
Role Test Manager
Team Size 25
Duration Jul 11 - Apr12
Location Upper Saddle River, NJ USA
Details:
The HEWR program was aimed at implementing editorial and production
workflows for Pearson Education to achieve significant savings through
standardized processes, tools and integrated systems.
Responsibilities and Achievements:
* Responsible for planning and facilitating QA activities of 7
integrated projects
* Implemented streamline communication between client and offshore QA
team
* Ensuring complete compliance in terms of quality and timely delivery
of all QA artifacts
* Implemented a seamless communication process for daily QA status to
all project stakeholders in the form of various reports as: Daily QA
Status Report, Daily Test Velocity report, Test Summary reports,
Testing status report, Traceability metrics, and Build Planning
* Successfully managed escalations, communications & coordination
between client, development teams and QA teams
* Responsible for implementing and streamlining QA methodologies and
processes across various on-going projects
* Prepared workload model, benchmarking of applications under test for
performance testing
* Actively assisted the team in testing various applications envisaging
the electronic texts/electronic books on multiple handheld devices
Project Name Lowe's Testing Centre-Services Platform (Release4)
Client Lowe's Companies Inc, USA
Role UAT Coordinator
Team Size 80 Business Users
Duration Oct 10 - May 11
Location Mooresville, NC USA
Details:
LTC- Services Platform program was aimed to provide complete solutions to
meet evolving customer needs and proactively manage the customer
experience. It involved the implementation of Sterling Order Management
system (OMS) for multi channel fulfillment of electronic orders
Responsibilities and Achievements:
* Responsible for planning and facilitating User Acceptance Testing of
11 integrated projects with a team of 80 Business Leads and Users
* Implemented a holistic E2E test approach to test 11 integrated
projects in UAT and connect 11 business teams for single UAT execution
* Assisted the Business Leads and Users in creating a pool of UAT test
cases and implementing the UAT test approach for Sterling OMS
implementation for Order Fulfillment program
* Responsible for maintaining Share-point for all UAT related
documentation and Creating various reports as: Project Status Report,
Test Summary reports, Testing status report, Traceability metrics,
User Schedule planning and Build Planning
* Presented UAT kick-off presentation, Trained the business users on
usage of Quality Center
* Prepared business flow diagrams for the E2E business scenarios
* Project Status Reporting to all Business Owners, Users, stakeholders
and PMOs
* Single Point of contact for all UAT activities
* Managed communications & coordination between Business &multi-vendor
IT teams
* Handled UAT defect resolution process with the IT teams
Project Name Lowe's Testing Centre-Services Platform (Release2)
Client Lowe's Inc, USA
Role Regression Test Manager
Team Size 12
Duration Jan 10 - Sep 10
Details:
LTC- Services Platform program was aimed to provide complete
solutions to meet evolving customer needs and proactively manage
the customer experience. It involved the implementation of Sterling
Order Management System for electronic orders via lowes.com
Responsibilities and Achievements:
* Added value to the Services Platform program by implementing Business
Process Testing strategy for enterprise level Regression testing of
the program
* Implemented an Independent Verification and Validation method for
Regression testing by ensuring an unbiased testing approach and
reduced the overall cost of the program by $1 million
* Added value to the project by effective cost utilization by ramping up
and ramping down the resources according to the need and situation of
the project
* Costing, Estimation and Budgeting of the project
* Project Status Reporting to all stakeholders and PMOs
* Handling Risk and Contingency Management
* Managing Communication with client and escalations
* Assisted the team with testing artifacts and deliveries
* Team and resource management
* Assisted the team in testing the order fulfillment process involving
lowes.com order capture, legacy OMS, Sterling DOM, Transport
Management System
Project Name Lowes Testing Centre-Credit Expansion
Client Lowes Inc, USA
Role Test Lead/ Test Manager
Team Size 15
Duration Aug 08 - Jan 10
Details:
LTC- Credit Expansion - New Credit Offerings was a development
project involving testing in its full lifecycle. It involved
introduction of 2 new co-branded credit cards in the market for
boosting the sales
Responsibilities and Achievements:
* Responsible for leading and managing the Offshore team for $4.5M
program
* Preparation of Test Plan and Test Strategy for System Integration
testing and Regression testing the electronic application and
processing of Lowes VISA and Lowes AMEX credit cards through financial
EDI transactions with GE and AMEX
* Managing the execution of SIT and Regression testing for timely
delivery of high quality deliverables to meet the program goals.
* Ensured smooth coordination and communication among teams in the multi-
vendor environment.
* Reviewing Test Scenarios and Test cases and QTP Test scripts
* Planned and executed automation of Regression test suite using QTP 9.0
* Estimation and Re-estimation of Project for both Manual and Automation
* Costing and Budgeting of the project
* Monitoring and tracking team activities
* Maintaining Metrics data for Quality Assurance Auditing
* Project Status Reporting to client and all stakeholders
* Managing Offshore/Onsite coordination, multi-vendor and client
coordination
Project Name Sales Force Automation (SFA) Higher Education
Client Pearson Technologies, USA
Role Test Lead/Functional Analyst
Team Size 5
Duration Nov 05 - Jul 08
Details:
Socrates application has two flavors, namely, Remote Application
that is used by the Sales Reps in the field having both the
application and the database locally on the Laptops, and a Network
Application that was used by Administrators where they connect to
the Network database directly.
Responsibilities:
* Involved in Onshore QA Cycle and Functional Analysis for SFA-HE
releases at Client place (Pearson Education, New Jersey, USA)
* Interfacing with the technical team to translate the gathered
knowledge into development of the envisaged applications.
* Coordination between Business, Client and Offshore team
* Review of Test Scenarios and Test Cases
* Involved in Deployment, Build Process of databases on Servers
* Involved in Interface Testing, Database Testing, Integration Testing
and Regression Testing
* Detecting and tracking bugs to closure.
* Involved in UAT Kick-off and Postmortem Meetings
* Played the role of Defect Prevention Analyst (DPA). Performed Causal
Analysis of Defects.
* Extensively involved in mentoring the new team members
Project Name Pearson Asset Library Project (PALP)
Client Pearson Education, USA
Role Sr. QA/BA
Team Size 6
Duration Jul 05 - Oct 05
Details:
PAL-P is an e-commerce application used to manage Pearson digital assets.
Currently PAL manages digital images used for creation of books known in
PAL as "projects". Application provides extensive search capabilities as
well as usage-related pricing, metadata editing and image annotation of
electronic content.
Responsibilities:
* Designing UAT Test Cases.
* Executing the Test Cases, Regression Testing and Test Scripts at
Offshore.
* GUI testing for entire application and Functional Testing.
* Bug Reporting and Bug Analysis
* Involved in UAT Kick off and Postmortem Meeting.
Project Name Day Dream - Interactive Charts
Client Pearson Education, USA
Role QA
Team Size 3
Duration Jan 05 - Apr 05
Details:
Daydream Education has a product series of Interactive Charts for
several subjects meant to run on Interactive Whiteboards. The
existing products in the series, namely Science, ICT and English,
using Macromedia Flash as the technology for production.
Responsibilities:
* Understanding the entire system.
* Designing UAT Test Cases.
* Executing the Test Cases, Regression Testing and Test Scripts at
Offshore.
* GUI testing for entire application and Functional Testing.
* Bug Reporting and Bug Analysis
Project Name Stanford - Dosimetry Training Tool
Client Pearson Education, USA
Role QA
Team Size 4
Duration Mar 04 - Dec 04
Details:
Under this project a web based Dosimetry Training tool was developed to
relieve Mentors of the task of developing and administering approximately
500-600 hours of didactic training to their Students. The tool consisted of
up to 20-25 Course Modules. Each small course module in turn consisted of
approximately 20 training sessions.
Responsibilities:
* Understanding the entire system.
* Executing the Test Cases, Regression Testing and System Testing
* GUI testing for entire application and Functional Testing
* Bug Reporting and Bug Analysis
Project Name Time Sheet Management System
Client In-House Project
Role QA/ Trainee
Team Size 4
Duration Jan 03 - Jul 03
Details:
This project was developed to help the employees of HCLT to keep record of
the time spent doing various activities in a day's work by daily making
entries in their respective time sheets. It also helps the manager to keep
track of the work done by his team members.
Responsibilities:
* Participated in Requirement Analysis.
* Executing the Test Cases, System Testing of the application
* GUI testing for entire application and Functional Testing
* Bug Reporting
Academic Qualification
V MCA from U.P.Technical University, Lucknow. India
V B.Sc. (Hons.) Chemistry from Miranda House, Delhi University, India