ANSHIKA KOHLI
Email : *******.*****@*****.***, Phone : 269-***-****
Experience Summary
. Over seven years of experience in the software development industry,
with MNC, Tata Consultancy Services Ltd. Total six years of experience
as Test Manager, Test Lead and programmer in Java on UNIX focused with
PL/SQL coding. Around 4 years of extensive testing experience of POS
application testing, 2 years working on ETL Tool, 3 years of PL/SQL
experience.Worked as Automation Test Manager and Regression testing
manger of java based applications and OBIEE applications
. Over five years of experience in Customer Interaction, Quality
Assurance, Project Estimations, Project planning, Project
Coordination, Requirements Analysis, Testing and Implementation for
small and medium size teams
. Domain knowledge of Retail (Apple) and Banking (PNC,HDFC).I have
worked on iphone application and tested the Point of sale application
for Apple on iphone.Also have around 2 years of testing exp on iphoen
application.Performed client, server, performance and load testing as
the POS application was first time launched on iphone.
. Certified ISTQB by America Software Testing Qualification Board
. Proficient in Software Development life cycle Quality Assurance
testing including System testing and testing methodologies. Excellent
understanding of the Software Development Life Cycle and role of QA.
. 5 years of Experience in lead QA and mentored with team of 7 juniors
QAs.
. Responsibility of QA lead includes reviewing of Test plan, Test cases
and defect tracking with developers.
. Experience in Agile Methodology, V-V model, Iteration model Testing.
. Experienced in Manual and Automated testing, test schedule planning,
test case design, Documentation and Execution. Editing and playback
the scripts after fixing the bug.
. Experience in writing Test strategy, Test scenario, Test plan, Test
cases, Defect reports and developing Test scripts.
. Technical & functional areas of expertise include Test management,
Automation Testing, Web application testing including OBIEE
dashboards, ETL testing .Worked on technologies like JAVA, JSP, HTML,
and XML. Good concepts of Oracle 9i/8i and Application Performance or
load testing using Load Runner
. Good exposure in creating documents (QA Status Report, QA Summary
Reports, QA Test Logs, issue and defects) to apprise project team
members as to the status of meeting defined quality goals.
. Participated in Requirements review and supported User Acceptance and
Production Verification Testing.
. Experience in Manual and automated testing tools like Mercury
Interactive Win Runner, Quick Test Pro 10.0 (QTP), Quality Center
10.0, and Test Director 8.0.
. Expertise in testing GUI applications, SQL query scripts and SQL
commands for testing.
. Involved in generating Test Scripts using Quick Test Pro 10.0 (QTP)
for different transactions to execute Functional Testing, Regression
Testing and Acceptance Testing.
. Performed Functional testing, Black box testing, GUI testing, Back-end
testing, Load/Performance testing and Regression testing.
. Experience in User Acceptance Testing (UAT).
. Involved in preparation of Test Data and managing data requests.
. Expertise in Automated Testing of Web and Client/Server applications
developed on Windows/UNIX environment using Quality Center 10.0, Quick
Test Pro 10.0 (QTP),
. Represented various meetings for QA issues with various levels of
management in organization.
. Experience in writing training documents, Test Matrices, Traceability
Matrix.
. Expertise ability to quickly master new concepts, very co-operative
team player, fluent communicational skills, and interpersonal skills,
innovative and self motivated.
Technologies and Skills
. Software QA leadership: Total ~7 years of experience of developing and
implementing QA processes, and developing and leading software QA
programs and teams.
. Software quality assurance: Total ~7 years of experience as a software
QA engineer, writing and executing test plans and test cases in highly
structured and loosely structured development environments and
performing all types of testing (functional, installation, acceptance,
browser compatibility, load, stress, performance, volume); experience
in managing software QA programs, Extensive experience writing and
executing automated testing scripts (primarily with Load runner)
. Test automation software: QTP, QFT, Load runner, HP Quality Centre
V9.2, Microsoft Project, SQL *PLUS, PL/SQL Developer, TOAD, Junit,
Brio
. Platforms: UNIX, Windows, MS-DOS,
. Database systems: Oracle 10g
. Languages: Java, HTML, mySQL, PL/SQL, Java, JSP,, Oracle 9i,
. Other software: ODBC, JDBC,JBoss
. Mac Based Tools and Environment : Jmeter, Eggplant, QFTest, LuntBuild,
Squish, SoapUI, Vi Editor, Eclipse, Expresso, Radar, DBVisuallizer
Qualifications
|Degree and Date |Institute |Major and |
| | |Specialization |
|Bachelor of |Maharishi Dayanand |Electronics and |
|Engineering, June |University (Rohtak) |Communication |
|2005 with First class| |Engineering |
|with honours. | | |
Professional Certifications / Memberships
| Professional Certification / Membership |Member Since / Date |
| |Certified |
|ISTQB Foundation Level |Mar, 2009 |
|SCJP 1.4 Certified |Mar, 2008 |
Assignments
The details of the various assignments that I have handled are listed here,
in chronological order.
PNC Bank
|Project |Retail BI |
|Customer |PNC Financial Services, Cleveland, Ohio. |
|Period |Sept'11 - Sept' 12 |
|Description | |
| |PNC is the fifth largest financial services |
| |company in United States with more than US |
| |$290 billion assets, PNC is a highly |
| |diversified and growing financial services |
| |organization spanning the retail, business |
| |and corporate markets. |
| |PNC provides services in deposit, lending, |
| |cash management and investment to more than 5|
| |million of customers across 13 states and |
| |District of Columbia. PNC operates in more |
| |than 2500 branches in United States and has a|
| |worldwide network of foreign correspondent |
| |banks. |
| | |
| |PNC has more than 200 software applications |
| |that are necessary to run day-to-day business|
| |in their branches as well as processing the |
| |data in the central operations centre. The |
| |applications are based on platforms that |
| |range from IBM Legacy Mainframe systems to |
| |the open systems like Informatica, client |
| |server, web and EAI (Enterprise Application |
| |Integration) technologies. |
| | |
|Role |Testing QA Lead |
| | |
|Responsibilities | |
| |Project lead responsibilities |
| | |
| |Lead 7 members test team. |
| |Responsible for managing the testing team, |
| |supervising their work and providing guidance|
| |on test plan preparation and testing to the |
| |team. |
| |Architected and implemented QA processes & |
| |practices, including defect and test |
| |management. |
| |Standardize QA standards and practices across|
| |teams where possible. |
| |Planned all resources and schedules for |
| |regression testing and automating the scripts|
| | |
| |Generated test progress and defect reports |
| |and sending to the client at regular |
| |intervals. |
| |Developed status update templates and |
| |provided timely status updates for the status|
| |review meetings. |
| |Review daily and weekly Testers' status |
| |reports and take necessary actions and |
| |assessing the progress and effectiveness of |
| |the test effort |
| |Direct Customer interaction: Requirement |
| |gathering on different business processes to |
| |be tested/automated and providing proposals |
| |on the new initiatives. |
| |Tracking the progress on testing done by team|
| |in all respective areas, identifying the gaps|
| |(if any) and advising team for corrective |
| |actions. |
| |Ensuring the appropriate planning and |
| |management of the test resources. |
| |Resource screening for new resource |
| |requirements. Escalate Testers' issues and |
| |other testing related issues to the Sr. |
| |Management. |
| |Review daily and weekly Testers' status |
| |report to access the progress and |
| |effectiveness of test efforts and take |
| |necessary actions, as required. |
| |Customer interaction and sharing of issues, |
| |concerns and accomplishments |
| |Work Allocation and Task assignment to the |
| |team members at onsite and offshore |
| |Reporting status to client, holding status |
| |and staff meetings. |
| |Coordinating with various teams for different|
| |project related activities |
| |Participation in project audit, project |
| |monitoring and status meeting. |
| |Appraisal and review of goals of team members|
| | |
| |Supervising Quality Assurance |
| |Tracking tasks and Mitigating Risks |
| |Determining the resource requirements and |
| |hiring the required resources for the project|
| | |
| |Participation in strategy meeting |
| | |
| | |
| |Functional / Technical responsibilities |
| |Managing, coordinating, planning and |
| |executing the testing for the client |
| |applications. |
| |Creation of Test Strategy and Test Plan for |
| |various projects in PnC area. |
| |Verifying the application from Accessibility |
| |aspects |
| |Assigning the work from functional & |
| |technical perspectives. |
| |Update Relevant Documents & Report Progress |
| |on Maintenance. |
| |Estimations, technical specifications and |
| |other Project Management related activities. |
| |Identification of Test Scenarios and |
| |developing test cases for the requirements |
| |provided. |
| |Testing and co-ordinating OBIEE dashboards |
| |and involved in the backend testing also. |
| |Performed functionality testing by |
| |coordinating with the business users and |
| |development teams. |
| |Performed Data Testing to validate data |
| |across various PNC applications. Did Data |
| |Validation on a number of applications that |
| |merged to form a combined data set after the |
| |merger of National City Bank with PNC Bank |
| |which constitutes millions of customer data. |
| |Generated test progress and defect reports in|
| |Quality Center. |
| |Developed status update templates and |
| |provided timely status updates for the status|
| |review meetings. |
|Tools / Solution |Lotus Notes 8.5, Microsoft Project, PL/SQL |
|Environment |Developer, Oracle 9i database, Mercury |
| |Quality Center, |
|Work Location |Cleveland, Ohio |
Apple
|Project |Point Of Sale |
|Customer |Apple |
|Period |Jun, 2007 to Aug'2011 |
|Description |Apple Inc. is an American multinational |
| |corporation headquartered in Cupertino, |
| |California, which designs and manufactures |
| |consumer electronics and software products. |
| |The company's best-known hardware products |
| |include Macintosh computers, iPod portable |
| |media players, and the iPhone. Apple software|
| |includes the Mac OS X operating system, the |
| |iTunes media browser, the iLife suite of |
| |multimedia and creativity software, the iWork|
| |suite of productivity software, and Final Cut|
| |Studio, a suite of professional audio- and |
| |film-industry software products. The company |
| |operates more than 250 retail stores in nine |
| |countries and an online store where hardware |
| |and software products are sold. |
| | |
| |The present Apple Point Of Sale (POS) is a |
| |Point of Sale application used in Apple |
| |Retail stores. POS is a Desktop application |
| |build on Java platform that helps with |
| |reporting, |
| |application build on Java platform that helps|
| |with reporting, sale, return, discounts, |
| |exemptions, accounting, and receipt printing.|
| |The system interfaces with SAP retail and |
| |several other internal systems. POS |
| |applications are also available on Mobile |
| |devices, which can be carried by store people|
| |for faster and efficient Sale processing. |
|Role |Test Lead |
|Responsibilities | |
| |Test lead of 10 members (both onsite offshore|
| |team. Work Allocation and Task assignment to |
| |the team members. |
| | |
| |Responsible for updating the client in |
| |meeting regarding status of the project on a |
| |weekly/biweekly basis. |
| |Review test plans prepared by Onsite & |
| |Offshore Teams |
| |Planning each phase and performing task of |
| |build deployment & testing |
| |Facilitating optimization of test scripts by |
| |mapping business requirements with |
| |application functionality |
| |Researching and facilitating usage of |
| |automation tools for testing |
| |Performed testing on mobile application i.e |
| |iphone.The point of sale was first time |
| |installed on iphone and all the validation |
| |were done by our team.Validation included |
| |client testing server testing performance |
| |testing and load testing. |
| | |
| |Coordinating with Production team on release |
| |of any patch in Production as and when |
| |required. Also creating patches and pushing |
| |into production. |
| |Monitoring code coverage using Emma tool. |
| |Automating existing scripts using Squish and |
| |QFT. |
| |Performance testing using Soap UI - Load tool|
| | |
| | |
| | |
| |Project management responsibilities |
| | |
| |Customer interaction and sharing of issues, |
| |concerns and accomplishments |
| |Work Allocation and Task assignment to the |
| |team members |
| |Reporting status to client, holding status |
| |and staff meetings. |
| |Coordinating with various teams for different|
| |project related activities |
| |Participation in project audit, project |
| |monitoring and status meeting. |
| |Appraisal and review of goals of team members|
| | |
| |Supervising Quality Assurance |
| |Tracking tasks and Mitigating Risks |
| |Determining the resource requirements and |
| |hiring the required resources for the project|
| | |
| |Participating strategy meeting and periodical|
| |business meeting |
| |Participated in defect review meetings and |
| |coordinated with the development team for the|
| |timely resolution of defects. |
| |Coordinated and did follow up with the |
| |development and testing team to make sure |
| |system testing is done thoroughly and on |
| |time. |
| |Weekly status on testing to the project |
| |manager from TCS and PNC to keep them posted |
| |on the progress and discussed with them the |
| |concerns/issues during the scheduled weekly |
| |meetings and also provided them with the |
| |testing status. |
| |Coordinated with Business Users for UAT |
| |phase. |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| |Functional / Technical responsibilities |
| |Managing, coordinating, planning and |
| |executing the testing for the client |
| |applications. |
| |Maintenance & Enhancement of the existing |
| |test scripts. |
| |Assigning the work from functional & |
| |technical perspectives. |
| |Update Relevant Documents & Report Progress |
| |on Maintenance. |
| |Estimations, technical specifications and |
| |other Project Management related activities. |
| |Developing test cases for the requirements |
| |provided. |
| |Creating Win Runner/ QFP test scripts for the|
| |manual test cases. |
|Tools / Solution |Vi Editor, Eclipse, Expresso, Radar, |
|Environment |DBVisuallizer |
| | |
| |Testing Tools: Jmeter, Eggplant, QFTest, |
| |LuntBuild, Squish, SoapUI Tool. |
| | |
| |Solution Environment: Java, Oracle, MySQL, |
| |Unix |
|Work Location |Cupertino, CA and Noida, India |
Apple
|Project |Point Of Sale |
|Customer |Apple |
|Period |May, 2006 to May'07 |
|Description |Apple Inc. is an American multinational |
| |corporation headquartered in Cupertino, |
| |California, which designs and manufactures |
| |consumer electronics and software products. |
| |The company's best-known hardware products |
| |include Macintosh computers, iPod portable |
| |media players, and the iPhone. Apple software|
| |includes the Mac OS X operating system, the |
| |iTunes media browser, the iLife suite of |
| |multimedia and creativity software, the iWork|
| |suite of productivity software, and Final Cut|
| |Studio, a suite of professional audio- and |
| |film-industry software products. The company |
| |operates more than 250 retail stores in nine |
| |countries and an online store where hardware |
| |and software products are sold. |
| | |
| |The present Apple Point Of Sale (POS) is a |
| |Point of Sale application used in Apple |
| |Retail stores. POS is a Desktop application |
| |build on Java platform that helps with |
| |reporting, |
| |application build on Java platform that helps|
| |with reporting, sale, return, discounts, |
| |exemptions, accounting, and receipt printing.|
| |The system interfaces with SAP retail and |
| |several other internal systems. POS |
| |applications are also available on Mobile |
| |devices, which can be carried by store people|
| |for faster and efficient Sale processing. |
|Role |Developer - Team Member |
|Responsibilities | |
| |Technical responsibilities |
| |Functional Specifications preparation (HLD) |
| |Preparation of Low Level design. |
| |Coding and Code/UTC reviews. |
| |GUI Development using JAVA, JavaScript, HTML,|
| |JSP |
|Tools / Solution |JAVA, JSP, JavaScript, Windows NT, |
|Environment |Eclipse3.0, ANT, MySQL, |
|Work Location |Noida, India |
HDFC
|Project |Online Banking |
|Customer |HDFC |
|Period |Dec, 2005 to May'06 |
|Description |Involved in Online Banking Application for |
| |creating an Account Link and testing the |
| |Mutual Fund Calculations of Customer's |
| |Investments. The application provided the |
| |Account Summary (balances, last deposits |
| |etc.) and Activity Details (Transaction |
| |Details regarding transfer of funds between |
| |the various accounts). User was enabled with |
| |the option of changing 'PIN' number and |
| |validating (enable/disable) transfer of funds|
| |between accounts. |
|Role |Test Engineer |
|Responsibilities | |
| |Analysis of specifications and |
| |functionalities provided by the client. |
| |Designed Security, functionality, Usability, |
| |test cases in Test Director. |
| |Checked the basic functionality of GUI by |
| |manual testing. |
| |Executed manual test cases in Quality Center.|
| | |
| |Responsible for tracking and reporting bugs |
| |using Quality Center.. |
| |Performed backend testing and front end data |
| |testing using SQL queries to retrieve and |
| |verify the information in database. |
| |Tested data consistency, data integrity and |
| |data validation. |
| |Tested navigation and the user Interface for |
| |ease of use. |
| |Involved extensively in Black Box Testing |
| |(Functionality, GUI Testing). |
| |Interacted with developers during Unit |
| |Testing. |
|Tools / Solution |JAVA, Win Runner, Test Director, Oracle, Java|
|Environment | |
|Work Location |Noida, India |
Additional Contributions to Organization
|Program or Course |Coverage/Presented to |
|Recruitment Activities at |Participated in various |
|Organisation Level |Recruitment drives, walk-in |
| |and telephonic interviews for |
| |Java resources. |
|L & D level contribution |Imparted training on testing |
| |and PMP areas |
Training Conducted
|Year |Title |Presented |Location |Organised by |
| | |to | | |
|2010 |Mercury QC |Project |Cleveland |PNC, Tata |
| | |Members | |Consultancy |
| | | | |Services |
|2009 |OBIEE testing and|Project |Cleveland |PNC, Tata |
| |ETL Testing |Members | |Consultancy |
| | | | |Services |
|2008 |Training imparted|Team |Noida 2 |Tata |
| |on transportation|Members | |Consultancy |
| |domain specific | | |Services |
| |knowledge | | | |
|2008 |Apple POS |Team |Noida 2 |Tata |
| |Application and |Members | |Consultancy |
| |Servers | | |Services |
Training Taken
|Year |Title |Location |Organised by |
|2010 |Data Warehousing Concepts |Cleveland |PNC Financial |
| | | |Services |
|2010 |BFSI Domain sessions in |Cleveland |PNC Financial |
| |areas like Credit Cards, | |Services |
| |Corporate Financing, and | | |
| |Retail Banking etc. | | |
|2008 |QFT and Squish (Testing |Cupertino |Apple |
| |tools) | | |
|2007 |Mercury Tool |Noida |Apple |
|2006 |Oracle PL/SQL |Noida |Apple |
|2006 |Foundation Unix |Hyderabad |Tata Consultancy|
| | | |Services |
|2006 |IQMS |Hyderabad |Tata Consultancy|
| | | |Services |
|2006 |Core Java |Noida |Tata Consultancy|
| | | |Services |
Personal Details
|Date of Birth |09-Mar-1984 |
|Nationality |Indian |
|Sex |Female |
|Marital Status |Married |
|Present Mailing Address |745 Apt# 1D Alfa court, Portage |
| |,Michigan 49002 |
|Permanent Address |A-7 CEL Apartments Vasundhra Enclave|
| |Delhi 96 |
Passport
|Name as on |Relatio|Passport |Date of |Expiry |Place of |
|passport |nship |Number |Issue |Date |Issue |
|ANSHIKA KOHLI|Self |F5657896 |05-Dec-200|04-Dec-201|New Delhi |
| | | |5 |5 | |