QA Analyst w/Oracle

IT Quality Assurance professional with expertise in all phases of testing for client-server and web applications

SUMMARY OF QUALIFICATIONS

* *****’ of IT experience in requirement analysis, software design, development, quality assurance methodologies, testing, defect tracking and reporting for Fortune 500 clients in banking, financial services and healthcare industries

Adept in formulating detailed test plans, procedures, test strategies and test scripts to meet business specifications

Highly experienced in unit, system, regression, functional, manual, automated, positive, negative, white and black box testing and software test configuration and version control

Competent liaison between business analysts, user representatives and concerned technical team members and managers in application design and document reviews

Strong communication, presentation, analytical and technical writing skills

TECHNICAL SKILLS

Operating Systems Windows 98/NT/2000/XP/Vista, Basic knowledge of UNIX

Database Oracle 6i/9i/10g

Applications MS Project, Mercury TestDirector, QuickTest Professional(QTP),Quality Center(QC), Oracle Designer, Oracle Developer 2000(Forms 6i and Reports 6i), Oracle Discoverer, TOAD, Visual SourceSafe, SCCS, MS Office, MS Visio

Languages Oracle SQL, PL/SQL

CERTIFICATION

Certified Project Management Professional (PMP), Project Management Institute (PMI)

PROFESSIONAL EXPERIENCE

TATA CONSULTANCY SERVICES, INDIA (TCS)(July 1998 – July 2007) - India’s leading IT services, business solutions and outsourcing organization with over 100,000 IT consultants in 47 countries. TCS generated consolidated revenues of US $5.7 billion for fiscal year ended 31st March 2008

Utilized test methodologies and automated test tools to support the delivery of quality products. A summary of the projects completed is given below in chronological order.

Testing Center of Excellence (CT Summation Case Vault - web-hosting service) - System testing of the new version and migration support

Responsibilities: Senior QA Analyst

Client: Wolters Kluwer

Duration: Mar 2006 –July 2007

Involved in the preparation of use cases, test cases, test scripts, defect reports

Analyzed and interpreted functional specifications in order to develop test plans and test cases

Gained an understanding of the application and put it through several rounds of manual testing as per plan, along with the team

Reviewed the deliverables

Coordinated with the onsite team for daily status updates and defect reports

Developed procedures, standards and checklists for the team

Ensured adequate quality assurance and control activities for the deliverables

Environment: Internet Explorer, Mercury TestDirector, QuickTest Professional (QTP), Microsoft Project, Microsoft Office Suite, Internal Project Management System, and VSS

Annual Report Filing - The objective of the project was to build a web filing application which would submit annual reports to and obtain information from states' websites

Responsibilities: Project Lead

Client: Wolters Kluwer

Duration: Oct 2005 – Feb 2006

Actively involved in feasibility analysis

Formulated and designed use cases

Formulated the project plan and tracked the milestones and deliverables

Coordinated with technical lead, testing team, onsite team and clients

Managed resources, planned knowledge building and sharing sessions for new technologies

Prepared the environment for testing and performed system testing

Faced quality audits and project management reviews

Environment: ASP .NET, C#, BizTalk Server, Internet Explorer, Mercury TestDirector, QuickTest Professional(QTP),Microsoft Project, Microsoft Office Suite, Internal Project Management System, VSS

Functional testing and migration of CA Clarity (formerly NIKU -project management system) - This initiative comprised multiple projects which dealt with:

- Maintenance of project management software (NIKU)

- Enhancement (Actuate reports development) for new version (Clarity)

- Functional testing of the new version of the software

- Implementation support during and after migration to the new version.

Responsibilities: Senior QA Analyst

Client: Bank of America

Duration: Mar 2005 – Sept 2005

Involved in formulating the test plan and tracking project progress

Gained an understanding of the new and old versions of the system

Prepared the test plan, test cases and was actively involved in defect finding, reporting and tracking them to closure

Was involved in analyzing and troubleshooting potential defects

Coordinated with the onsite team and clients for status updates, defect reports and bug tracking

Prepared an adequate QA environment for the deliverables

Prepared checklists, standards and procedures

Reviewed all the deliverables

Environment: Internet Explorer, Mercury TestDirector, Microsoft Project, Microsoft Office Suite, Actuate, Internal Project Management System, and VSS

This was the largest migration of Niku in bank compared to earlier migrations and there were no major issues like previous migrations. The extensive testing carried out during Clarity 7.5 migration, helped vendor to fix more than 100 severe bugs including very critical issues like JVM crash. We were passed on a 'Team Celebration Card' in recognition of our efforts.

Hospital management system - This is a comprehensive Hospital Management System product developed for medium to large-size hospitals, which addresses all the major functional areas for hospitals.

Responsibilities: Project Lead

Client: Multiple Clients

Duration: Jan 2004 – Feb 2005

Actively involved in the enhancement and implementation support of the application

Offshore coordinator for two of the implementation sites and beta site

Was responsible for tracking all defects reported in the product and closing them according to the priority or severity

Estimated effort for work - new features and enhancements

Participated actively in analysis and brainstorming sessions for new features

Interacted closely with Developers, Business/Systems Analysts, Project Managers, and End Users

Environment: Oracle Developer 2000 Forms 6i and Reports 6i, Oracle Designer, TOAD, PL/SQL Developer, VSS, Microsoft Project, Microsoft Office Suite, Internal Project Management System, VSS

The expertise of this team was used in the proposal making activities for NHS, UK and a portion of the team has now moved over to the client’s site for NHS implementation

TCS BaNCS (Formerly branded TCS Quartz) - TCS BaNCS Core Banking platform enhances the basic business of banking with the capability to configure and manage the full cycle of the banking process, from origination to servicing across multiple channels. The award-winning banking platform (ranked #1 in the IBS League table) supports institutions of every operational size and complexities across the globe – Internal Acceptance Testing of the retail banking version of the product

Responsibilities: QA Team Member

Client: Multiple Clients

Duration: Dec 2002 – Dec 2003

Actively involved in RAD (Rapid Application Development) sessions of the application and worked closely with development team for all the functions- opening, maintaining and closing accounts, deposits and withdrawals, issuing of checks, issuing of loans

2. Built a test case repository for the system

3. Involved in system testing and verification of the rectified defects so that the system got fine-tuned for implementation.

Environment: MS Word, MS Excel, Internet Explorer, and VSS

BIDS (Bill of Material Information Data System) - The objective of the project was to re-host DSS functionality, keep-up-to-date for data feeds and improve the performance of the system to handle more load/users and volume of data.

Responsibilities: Team Member

Client: Boeing

Duration: Jun 2002 – Nov 2002

1. Actively involved in architecture review

2. Reviewed and refined the design documents along with the technical team of the client

Developed Data Integration modules

Generated combinations of data as per the various scenarios and tested the data integration modules – complete database testing

5. Developed pilot reports

6. Interacted with users and technical team of the client and co-coordinated with the offshore team

Environment: Oracle Designer, TOAD, PL/SQL, Oracle Reports 6i, VSS

E-Integrated Brokerage System - This is a multi-exchange, multi-depository, multi- segment, multi-clientele product which can be used by brokerage houses, professional clearing members & custodians for their front office and back-office functionality

Responsibilities: Module Leader/Team Member - Deliveries DP Interface module

Client: Multiple Clients

Duration: Jan 2000 – May 2002

Actively involved in requirements analysis, design, development, testing, implementation and maintenance

Formed part of implementation team at one of the clients' sites and worked hand-in-hand with the users for successful completion of trading and settlement cycles using e-IBS

Used JAD (Joint Application Development) methodology to refine and add new features into the module and oversaw their smooth integration into the product – collected and analyzed requirements, made approach/gap documents, helped technical members design and build and participated in integration testing

Interacted closely with Developers, Business/Systems Analysts, Project Managers, and End Users

Actively involved in system testing of the product before implementation at any site or before a major release

Environment: Oracle Developer 2000 Forms 6i and Reports 6i, Oracle Designer, Pro*C, TOAD, PL/SQL Developer, VSS, Microsoft Project, Microsoft Office Suite, Internal Project Management System, VSS

Statewide Computerization of state electricity board - The client is an organization entrusted with the responsibility of transmission and distribution of electricity in the state of Karnataka. The project involved the study of the Administrative System of client and then its complete computerization.

Responsibilities: Team Member - Financial Accounting and Materials Management modules

Client: Karnataka Electricity Board

Duration: July 1998 – Dec 1999

Actively involved in requirements analysis, design, development, testing of the modules

Made low-level design documents, developed the features of the modules and tested them

Used JAD (Joint Application Development) methodology to refine and add new features into the module and ensured their smooth integration into the product – collected and analyzed requirements, made approach/gap documents, designed and built them

Environment: Oracle Developer 2000 Forms 6i and Reports 6i, Oracle Designer, TOAD, PL/SQL Developer, VSS, Microsoft Project, Microsoft Office Suite, Internal Project Management System, VSS, MS Visio

Developed and maintained quality assurance standards and processes and managed quality improvement activities, complete with a software metrics program

Actively involved in the development and advancement of project methodologies, processes, tools, templates, best practices and benchmarking

Analyzed business and system requirements managed development of specifications to create and execute detailed test plans and verified bug fixes.

Configured test environment and created strategy for product development and certification. Assured test data, scheduled automated/manual tests. Approved results documentation and tracked systems updates.

Established and maintained working relationships across all businesses, across IT, and between technology team members.

Contributed to continuous improvement by leveraging CMMi methodologies

Experienced in handling product releases as well as project applications

EDUCATION

Master of Computer Applications, Birla Institute of Technology, India, July 1998

Contact this candidate