Sapna Shah

***Augustine CT E-Mail Address:

abil0p@r.postjobfree.com

Oviedo, FL 32765

Cell: 407-***-****

Wk: 407-***-****

OBJECTIVE

To pursue a professional career within the Senior Quality Assurance System

Analyst field that will utilize my cross-disciplinary technical, analytical

and database development & management skills.

SUMMARY OF EXPERIENCE

. Extensive Functional and QA Testing experience in People Soft - CRM

Customer Connect 8.8, 9.0 - People Tool 8.47, 8.48 on Oracle 10.0 Client.

. Extensive experience in Integration between PeopleSoft CRM 9.0

Application and iSeries (via Lansa Integrator and Vision Solutions

Symbiator middleware tools).

. Proficient in Read and understand C # and .NET Language and XML language.

Load Runner and SQL Server 2005- SSIS, Admin, and Development and

Reporting Services experience.

. Nine + years of experience in IT industry and Five + years of Quality

Assurance / Functional - Testing Experience.

. Extensive experience in using Oracle Database Management System, Database

Integration, SQL and PL/SQL, database back up and recovery and

administration. Proficient in Novell networking system that involves

Network Administration. (NetWare 6.0). Proficient in using MS Windows

application suit.

. Familiar with the UNIX operating system and common desktop environment, X-

window commands and shell scripts.

. Familiar with testing of business systems by following the business rules

and functional design documentation. Familiar with the POS- Credit Card

application software testing, batch settlement. Troubleshoot and resolve

production issues along with testing the new enhancements on the

application.

. Performed Installation of Oracle products like Oracle 8i and 9i

Enterprise edition on Linux. Performed installation of SQL Server

Enterprise Edition.

. Performed end to end and regression testing for the software and manually

executing test cases and using the Test Automation tool by ensuring the

functionality of the product.

. Web page development and maintenance using the Microsoft Front Page.

COMPUTER SKILLS

Languages:

SQL, PL/SQL programming, HTML, JAVA, Access Programming, Visual Basic

Programming, Perl Scripting, SQL Server Business Intelligent Development

Studio, .NET Application, People Code.

Database & Software:

Oracle, TOAD, DB2, Access, MS Word, MS Excel, MS PowerPoint, MS Internet

Explorer, People Soft 8.4 Financial Application, Visual- FoxPro, Lotus

Notes, Visual Basic, Oracle 9.0, Oracle 8.1.5 installation and familiar

with concept of DBA activities, People Soft Customer Connect CRM 9.0 with

the People Tools 8.48, iSeries AS400, DB2, People Soft CRM Application,

Crystal reporting - Info Manager, SQL Server - 2005, AS 400 - I-series.

Operating System: UNIX, Red Hat Linux 7.1, Windows NT/XP/98 and MS -DOS,

Sun Solaris, Novell NetWare 6.0.

SUMMARY OF QUALIFICATIONS

. Proficient in forming queries and creating the database objects.

. Proficient in Online - Functional testing and trouble shoot issues by

analyzing data.

. Proficient in Linux operating system with x-window commands. Creating

users, groups and assigning the appropriate right to those users and

groups. Compressions of the tar files. Setting up the environmental

variables and exporting those variables.

. Proficient at utilizing computer system to produce SQL reports, expertise

in PL/SQL programming using an Oracle Relational Database in client side

development tools, and studying towards DBA certification that requires

knowledge and skills to set up, maintain, and troubleshoot an Oracle

database. Ability to adapt, learn and enhance skills with assigned

projects.

. Assume leadership role and coordinate between business subject matter

experts and technical developers to complete the end to end testing of

the deliverable.

. Willing to take on extra responsibility to get work done and ability to

communicate technical language in easily understandable term.

. Ability to work and lead more than one project in a given period of time

and meet the deliverable dates on the projects.

. Quick works effectively, independently or as part of a team and highly

organized, efficient in fast-paced multitasking environment, able to

prioritize work and accomplish objectives with enthusiasm.

EMPLOYMENT

Senior Quality Assurance Systems Analyst (II)

September 2005 - Present

Scholastic Book Fairs Lake Mary, FL

32746

The current position with Scholastics involves major responsibilities:

. Extensive Functional and QA Testing in People Soft - CRM Customer Connect

8.8, 9.0 - People Tool 8.47, 8.48 on Oracle 10.0 Client.

. Extensive experience in Integration between PeopleSoft CRM 9.0

Application and iSeries (via Lansa Integrator and Vision Solutions

Symbiator middleware tools).

. Responsible for integration testing (unit, system, QA, and regression) on

Customer, Contact, Opportunity, Order and Task management modules; for

both real-time and batch (synchronous/asynchronous) integrations. Also

developed QA methodology and monitored quality of the data integrated.

. In-depth business and functional understanding allowed to prioritize

troubleshoot, and solution Production issues post go-live.

. In-depth knowledge of the complex, multi-system architecture and data

models: helped set up integration strategies, field formats and

procedures; and helped coordinate data mappings and data validation.

. Strong understanding of Integration Broker tool, including data mapping,

exception handling, message queue partitioning, and integration flow

monitoring.

. Thorough knowledge of Process Scheduler and Monitor tools: Setup

recurrences, scheduled, managed and monitored processes and multi-process

jobs.

. This involves: Evaluate integration, configuration, and automation Tools,

Online and Backend Data Validation.

. Also involved actively in Functional Requirement meetings and understand

the Testing Strategy for CRM application.

. Create and document detailed testing scripts for CRM applications. Use

testing scripts to test software changes/enhancements.

. Test application changes and enhancements before implementation to "live"

production environment.

. Maintain and use database of test data that is representative of "live"

company data for querying, testing, analyzing and evaluating data.

. Also in user acceptance, and regression test plans and test cases based

on review of technical specifications and user requirement.

. Interact directly with the application team to ensure product development

is fulfilling the user requests.

. Report and record bugs and rework issues to application team throughout

the QA process.

. Work with requesting users to verify change is satisfactory, expected

results are achieved and user acceptance testing is complete.

. Communicate with System Administrator to ensure all system access, menus

and user groups are setup and tested prior to system implementation

. Fill out appropriate documentation for production changes and get users

sign off of the production move. Verify the production implementation of

tasks.

. Update project tracking system using Lotus Notes Database with status of

tasks assigned, tested and attach any documents related to testing the

task.

. Respond to helpdesk issues that are system user related problems or

questions. Assist in the education of users who are in need for company

business applications.

. Create helpdesk issues in project tracking system that need development

attention.

. Interact directly with the application team and users in explaining and

troubleshooting helpdesk issues for resolution.

. Communicate production move schedule and completion of the change to

requesting users.

. Assist with the peer review, mentoring and knowledge sharing for other

software applications whenever required.

. Familiar with the knowledge of the Software development Life Cycle (SDLC)

and SAUX Compliance audit regulation.

Program Assistant March 2004 -

September 2005

University Of Central Florida

Research Parkway, Orlando, FL

The position with purchasing department is as a Program Assistant that

involves following task

. Maintain all the Vendor Files in the People Soft 8.4 Financial

application.

. Maintain EBSCO subscription services.

. Maintain Vendor database and daily vendor reports.

. Run the appropriate query using a query tool.

. Given assignment to create a database using Access to pull the report.

. Attend ongoing training sessions as needed.

PeopleSoft 8.4 Financial Support

November 2003 - March 2004

University Of Central Florida

Research Parkway, Orlando, FL

The position at UCF Help Desk with Finance and Accounting is as a Support

Help Desk and I have been assigned to perform following tasks:

. Answer incoming calls for End Users of PeopleSoft 8.4

Financial Applications and help them resolve the problems

they have with the application like: Creating Online

Requisition, PO Related Questions, Performing a Budget,

Journal, and Voucher Inquiries. Perform a Budget Check, Print

Budget Positioning, Expenditure, and Crystal Reports using a

Reporting Tool within the application.

. Use a query tool to perform a query within the application.

Developed a query to pull the data for all the Closed Help

Tickets from October through December. And finalized that

into a report for the Project Manager.

. Create a Help ticket for the issues users are having and

redirecting them to appropriate person to solve the issue.

. Completed WebCT courses required for PeopleSoft 8.4 Financial

Application training.

. Attend ongoing training sessions as needed.

System Test Intern November 2001

- November 2003

Converges Corporation Heathrow, FL

The position at Convergys Corporation is as an intern and during the

internship programs I have been assigned to perform following tasks:

. Learnt about the Lotus Database that is used as an internal

database to access all the important documents.

. Ran the Daily Status Reports for Clients and maintained the

Access database that is used to run those reports.

. Supported to create an end to end and regression testing

guide before the release of the new release of the software.

. Understood new feature functionality with Functional Design

Document, Business Requirement Document. Developed test

plans, wrote and executed the test cases related to the new

feature required by the client. Participated in peer,

internal and formal review for any new feature. Utilized

trouble shooting guidelines and followed chain of commands

for a subject matter expertise.

. Also learned about the Unix Environment and the background

processes.

. Executed and wrote SQL queries while executing the test cases

and pulled the right data from the Oracle database.

. Also attended the brown bag session to gain more knowledge of

the Testing Environment.

. Worked with the Test Automation Testing team to define the

Win Runner testing script.

Database Developer Intern June 2001 -

November 2001

Mobile Area Networks, INC. Heathrow, FL

The position at Mobile Area Network is as an intern and during the project

I accomplished and learned following tasks:

. Introduction to Linux kernel.

. Configure the Linux kernel parameters to accommodate the Shared Global

Area (SGA) structure of Oracle8i.

. Created the Linux account to own the Oracle software and apache server.

. I also learned to make shared memory segments and created mount points.

. Pre-installation setup tasks to configure system, and set up accounts,

groups, variables and permissions needed to run Oracle8i.

. Net 8 configuration and TC/PIP protocol.

. Installed Motif library that is required prior to installation of Oracle

8i Enterprise Edition.

. Installed JDK1.2.2 and JRE 1.2.2 prior to installation.

. The major assignment during this time was to work on automatic startup

and shutdown of the database that is to set up the dbstart and dbshut

scripts so that they are called at system startup with the dbora script,

which gets executed. I created the script for the automatic database

startup and shutdown.

. Created database and stored procedures using cursors, which is I

performed database design and database management.

. Also performed post-installation process to configure Oracle 8i.

Tech Assistant 1996-1997

Bina Software Casselberry,

FL

. Maintained customer database prepared correspondence and answered phones.

. Coordinated clients' data processing conversions to new and enhanced

applications.

. Assisted in maintaining client database. Involved in quality assurance

and testing of business systems developed for small businesses.

. Performed data input from technician's work sheets,

generated sales reports, billed invoices and updated

computer inventory.

. Balanced the expense sheets, issued monthly invoices to the

clients.

Lab Coordinator 1995-1996

NIIT Computer Institute Bombay,

India

. Responsible for software and hardware support for students, maintenance

and troubleshooting of related software.

. Responsible for computer operations and resolving software related

problems.

. Assisted in technically demanding assignments.

EDUCATION

People Tool I / II - Release: 8.48:

December - 08

People Soft architecture and tools used to develop and customize

application.

Microsoft SQL Server 2005 Database Developer, Business Intelligence

January -07

Application Development Course Training

Hands on Technology

ORACLE Certification for Database Administrators

A.S. in Computer Programming and Analysis Fall-03

Seminole Community College, Sanford, FL.

Coursework Completed With GPA 4.0

Networking and Operating System Access Programming

Microsoft Computer Package (Office 2000)

Database Management Oracle PL/SQL programming Oracle

Database Administration

Visual Basic Programming Oral Communication Advanced

Microsoft Package (Office XP)

NetWare 6.0 System Analysis and Design

Diploma in ORACLE 8 (SQL/PL- SQL Programming) July

-2000

SSI Institute, Bombay, India

Diploma in MS-DOS, Word Star, 1996-1997

MS-OFFICE (Word, Excel, PowerPoint)

Bombay, India

BS in Chemistry and Microbiology 1984-1989

University of Bombay, India

Contact this candidate