Date of Birth :
Rachna Kanwar(Formerly Rachna Kaushal)
06th March 1983
MCA (Masters in Computer Application) from Gurukula Kangri University, Haridwar with 80% in June 2007
Bsc IT (Bachelors in Information Technology) from GNDU, Amritsar, Khalsa College, Jalandhar With 70% in June 2004
XII from D. A. V. Public School, Chandigarh. CBSE(59%) in April 2001
X from Sarvhitkari.Vidya.madir, Mansa. PSEB (85%) April 1999
Designation in the Organization
4 years in HCL
Test Plan and Test cases Planning & Preparation.
Having ample knowledge/experience in Database (SQL Server 2005) and UI Testing.
Smoke, BVT, System, Integration, Regression testing and Performance testing: Web Test, Load Test.
Experience the usage of the Octopus used to deploy the project on Distributed Servers (in terms of databases and reports).
Virtualization using tool ‘Hyper-V’ & SCVMM for creating, modifying VMs
Test Environment Creation.
Handling all Networking issues, VMs related issue, Domain Issues, DNS issues.
Good communication skills, worked at client end with Microsoft at Redmond(USA)
Windows Server 2003, Windows Vista, Windows 9.x/ 2000/XP.
Technologies & Development Tools
MS-SQL Server 2005.
Visual Studio 2005,2008
Source Depot, Product Studio.
Overview of Active Directory.
Microsoft Certified Technology Specialist in SQL Server 2005 Database
Design and Implementation (070-431)
Project Details (Projects in reverse chronological order)
Project : BPOS - CCS Deployment @Redmond
Project Duration :
From : Mar 2009
To : Feb 2011
Duration: 23 months
Team Size: 3
Operating System: Win 2K3,Win 2K8
Client: BPOS-The Communication and Collaboration Services (CCS) Deployment, Microsoft Corporation, USA
Description: The Business Productivity Online Suite is a set of Microsoft hosted messaging and collaboration solutions including Microsoft Exchange Online, Microsoft SharePoint Online, Microsoft Office Live Meeting, and Microsoft Office Communications Online. These online services are designed to give your business streamlined communication with high availability, comprehensive security, and simplified IT management. When your company subscribes to one or more of the services, it connects to the rich interactivity of on-premises client and server applications with the flexibility and scalability of Web-based services. Because Microsoft hosts the services, it reduces your company’s need to maintain IT services on site. Many organizations today are moving to this "software-plus-services" model, because it decreases the need to manage hardware and software.CCS Actually works for key features like: E-mail and calendar functions, E-mail and calendar functions, Document collaboration and workspaces, Web conferencing, Microsoft Online Services Administration Centre, Microsoft Online Services Sign In application etc.
Role: Software Design Engineer in Testing
Worked from client location and then later work as a SPOC from Offshore.
Involved in Selection of employees for CCS project and groomed them for Interviews preparation, Provide Knowledge transfer to selected ones.
Setting up an environment for Testers by creating Topologies (both scaled and Non scaled) and Deploy the latest bits using Octopus Tool.
Trouble shooting for Active Directory and DNS issues and resolve them for Testers(Beijing Team )
Involved in handling all the issues related to Environment setup.
Product Studio tool is used for logging Bugs and Source Depot for Versioning control.
Involved in creating Power Shell scripts to automate the processes like: Check point creation for VMs, Reset check point, Check Domain of VMs, Automate the Pre deployment check list, Host server pre requisite.
Involved in setting up the configuration of Host Servers, Arranging IPS for VMs, and Create Virtual Machines on those Host servers.
Handling issues related to Exchange servers like related to clusters, Jobs.
Involved in doing the Clean /Upgrade deployment either manually or via scripts.
Involved in documentation of processes related to Project and upload them on SharePoint page.
Project : MSN Fuse Validation @ Redmond
Project Duration :
From : Dec 2007
To : Nov 2008
Duration: 11 months
Team Size: 11
Operating System: Win 2K3
Client: MSN, Microsoft Corporation, USA
Description: FUSE Validation system is the project of MSN Publishing Platform. It is a distributed light weight network monitoring mechanism that has been integrated into Composition Framework (CF) of MSN. This persisted data is further processed and presented through web portal as reports and dashboard views to end users using SSRS. Project MSN Fuse Validation – V2 is enhancement over Fuse V1 where in a much stronger, scalable and robust architecture is designed to support heavy data traffic, widened customer need/requirements using enhanced features of SQL Server 2005 and .Net 3.5.
Role: Tester (Backend and UI Testing)
Framed test cases covering both the UI as well as functional aspects.
Performed extensive front end UI testing identifying UI, data as well as browser compatibility issues.
Involved in extensive database testing (SQL Server 2005), checking the data consistency and correctness at individual layers, as well as end to end.
Performed Performance testing for reports using VSTT.
Involved in test case execution and corresponding bug logging in Product Studio.
Performed Unit, BVT, System, Integration and Regression testing.
Automated test cases using VSTT.
Project : Microsoft Adcenter SQL Server Capability
Project Duration :
From : Jan 2007
To : Nov 2007
Duration: 10 months
Team Size: 12
Operating System: Win 2K3
Client: Microsoft Corporation, USA
Description: In project-Microsoft Adcenter Sql Server Capability new reusable components were developed using SQL Server 2005 that are optimized and can be used further.
Role: Creation and Testing of SQL Scripts
In project-Microsoft ADcenter SQL Server Capability I have groomed myself by working on new topics like SSRS, OLAP, In-depth Knowledge and proper Usage of TSQL Statements. I have created and tested the following reusable components which are implemented in Microsoft ADcenter SQL Server Capability project mentioned below:
Release_space_2005_SQL-COE_PHASE2: In this component I wrote the Scripts to SHRINK LOGS/DATABASE FOR RELEASING PHYSICAL SPACE. Also wrote write dynamic queries, Created UserDoc. And done testing of this component.
Comparison between two Databases: In this component Create sub module-Diff of table schema b/w Dbs, Tables found only in Source, found only in destination, tables with diff in schema, Exact match tables. Also Create script to see this difference exported to Excel file.
Dynamic Chart generation-Hybrid Charts: Worked on Dynamic chart generation-how to create Column chart, Line Chart, Hybrid Charts (Column/Line) and their functionality, worked upon Image indicators, Deployment of reports.