Operating Systems: :MS-DOS, WINDOWS95/98, Windows NT, Unix

Languages: :SQL, PL*SQL,

Databases : Microsoft SQL Server 7.0, Oracle 7.3, MS-Access

GUI :Developer 2000, Visual Basic 5.0/6.0

• Analyzed Business Requirements and System Specifications to understand the application.
• Designed Data model for GCM Database
• Database was developed by using SQL server7.0 backend and MS Access 2000 as front-end
• Stored procedures are used to create all tables in GCM Database
• ADO are used to connect the Database
• Performed Manual/QA Testing Software
• Involved in preparing the Test requirements, Test Plan and Test cases
• Executed Test cases manually to test application functionality against user requirements for security and performance.
• Performed negative and positive testing
• Participated in document Reviews and inspections
• Identified Software bugs and interacted with developers to resolve technical issues
• Used Test Director for error reporting and communicating between developers, product support and test team members.
• Used SQL Queries to make sure that data was entered properly in the right tables, when the data was entered from front end screen.
• To ensure the integral aspect of QA environment, Regression testing was undertaken after every bug fixes.

Designed, developed and maintained the Garments database using SQL Server on the back end and MS Access on the front end. Garment database provides the Inventory Management, Accounts Receivable, Accounts Payable, General Ledger, System Management

• Involved in analyzing the business requirements
• Designed the database using MS Access 2000
• Forms and Reports are designed using Access as Front end
• Involved in writing Test cases,Test Scripts
• Executing test cases
• Editing the test scripts to perform various types of testing
• Performed Backend testing using SQL queries
• Wrote Modification Request(MR) for defects found during test execution using PVCS Tracker
• Built test environment with Automated Testing tool and Error tracking tool
• Technical reviews and inspection of functional and design specifications
• Participated in weekly meetings with Test team and Development team

Auto match (Apr 99 – Sep 99)

This application is used to maintain the lists of clients, prospective clients and their requirements of skills for the various positions available in their contact information, skills, availability and preferences. The application matches the requirements of the client with skills of the candidates and generates the report. The application was designed and developed using SQL Server, Visual Basic and MS Access.

• Involved in preparation of documentation and training for the end users
• Wrote and implemented Test scripts/Test cases
• Performed Unit testing, Functional, Testing, Integration testing, System testing, Regression testing.
• Analyzed the bugs ,documented errors using MS-Excel

Description: Participated in JAD sessions and collected requirements for the sample analysis (SAS) in Blue cross Analytical Labs. Created functional hierarchy, tables and generated scripts for database. Designed, developed, tested and implemented SAS.Developed front-end screens using Access and generating reports.

PHARMACY MAINTENANCE:

Client : Fernandez Maternity Hospital

Duration: : 4 months

Software Environment :Oracle, MS Access with VB 5.0

Team Size : 3 members

Role : System Analyst

Operating System : Windows 95

Description : The project consists of maintenance of medicine stocks, and supplier’s details, cheques issued to suppliers, sales made to patients, refunds of medicines. If there is any price augmentation they have to be updated according to the corresponding prices. the medicines issued to the in-patients over a number of days could be procured at discharge table so that billing is made easier, a summary of medicines issued to the patients were also generated during the patients stay for the doctors to know all the medicines issued to the patient this facilitates any reimbursement for the patient to be claimed. Reports were generated based on daily purchases, daily sales, monthly purchases, monthly sales, cash purchases and credit purchases for every month, medicines issued to patients, medicines stock reports.

SALES ORDER PROCESSING (SOP) :

Client : Ramanuja Traders

Duration : Four months

Software Environment: Oracle 7.3, Developer 2000

Team Size : 4 members

Role : Involved in Design, Coding and Development

Operating System : Windows 95

Description: SOPs consists of Customer, Product Maintenance, Preparation of Orders, Challans, Invoices for Challans, Reports. SOPs computerizes receipts most of the functions as soon as customer seeks an order for products. It supports enough choices while invoices are being made. Another important functions are queries and reports. This involves direct entry of relevant information into centralized database with facilities for update, queries and reviews through interactive terminal.

Duration: : Three months

Environment: : MS Access

Team Size : 2 members

Role :Coding and Development

Operating System: :Windows 95

Description : Banking consists Bank master maintenance, Transactions, Customer wise reports, Bank transaction reports. This reports main aim is to computerizing the functionalities of a Bank. This project records customers in different categories by account types. It records daily transaction of the Bank, allowing to add, modify customers, providing with lot of options open in nature of account. It provides loan, deposit schemes for customers. It calculates interests monthly, annually depending upon the nature of account. Reports are generated for daily transactions, customer-wise, amount subscribed by the Bank for loan, interest paid on deposits and monthly transactions and petty cash.

EDUCATIONAL QUALIFICATIONS

• Post Graduate Diploma in Computer Applications, August 1994 - July 1995.
• Doctor of Philosophy (Ph.D.), Osmania University, Hyderabad (1990-1994).
• Master of Science from Osmania University, Hyderabad (1987-1989).