Ayesha Shah
Email: ********@***********.***
Address:
City: Herndon
State: VA
Zip: 20171
Country: USA
Phone: 301-***-****
Skill Level: Any
Salary Range:
Primary Skills/Experience:
To obtain an employment as a Database Administrator in a professional organization at a challenging & responsible position that facilitates growth, responsibility and teamwork prospects. I need a platform where I can explore my dormant potential and my own expertise and skills in IT field.
Educational Background:
High School Dipolma from Computer Institute, Rockville MD 1/2001 to 9/2012 (Oracle Database Administrator/Developer Certified Associate,OCA)
High School Dipolma from International Islamic University, Rockville MD 1/2001 to 12/2012
Job History / Details:
Career Overview
To obtain an employment as a Database Administrator in a professional organization at a challenging & responsible position that facilitates growth, responsibility and teamwork prospects. I need a platform where I can explore my dormant potential and my own expertise and skills in IT field.
Qualifications
Computer Institute Rockville, MD
Oracle Developer/Administrator Certified Associate (OCA).
(Exams in progress)
International Islamic University
Islamabad Pakistan
Bachelor of Science Degree in Computer
Science (BSCS)
Technical Skills
Skills Experience Total Years Last Used
Oracle 11g (SQL, Reports and forms)
Java
HTML
VC.net (C#)
Turbo C
C
Microsoft Office 2007/2010(Word, Excel, Access)
Outlook 2007/2010
Microsoft Visio 2003
Rational Roses
Front Page
Demo builder, Mat lab
Computer Graphic(Adobe Photoshop, Flash)
Google Apps(Mail, Calendar, Chat and DOCS)
Web Technology
Windows (Using, Installing, Formatting & Settings)
Internet Explorer
Windows 98, 2000, 2003, 2007, XP & Vista
Education and Certification
2012 Computer Institute Rockville, MD
OCA Oracle Developer/Administrator Certified Associate
Computer Institute, Oracle Database Administrator:
Created databases, table spaces, users, roles, and profiles. Maintained redo log files, rollback and temporary segments. Managed tables, indexes, and physical storage. Maintained data integrity constraints, Use clusters and index-organized tables. Manage Database Users, enrolled, monitored and dropped database users. Created and managed default and specific user profiles, granted database privileges and managed roles and resources. Used Export/Import utility, Offline Backup, online Backup and Archiving. Perform complete and incomplete recovery of the databases.
Used special utilities to increase the performance of the database.Used Explain Plan utility, SQL Trace and TKPROF utilities to check performance and to see how the query is executed and where the information was obtained. Tuned memory structures, changed size of memory buffers and set appropriate checkpoint intervals. Configured server-client architecture of the Oracle database using Oracle SQL Net product, a listener and dispatchers. Worked with multithreaded server configuration.
Passed the exam 1Z0-051 Oracle Database 11g: SQL Fundamentals with 81 percentage score while Exam 1Z0-052 is in progress.
Oracle Database Developer:
Developed Customers' Orders Tracking System (COTS) application (Oracle Forms) consisting of several tables including orders table, customers table, items table, products table, and prices. These tables were related together to create a complete tracking system. Identified users and functional requirements to solve COTS problem. Built Entity Relation Diagram (ERD) for the Data Model and identified the Data Model's attributes. Designed (GUI) online screen (screen layout). Prototyped interactive data entry and displayed output screens. Developed interactive online screens. Tested functional and user's requirements and deployed and implemented COTS application. Designed batch and online reports (Report layout). Prototyped and developed batch and online reports. Used Data Definition Language (DDL), i.e. created alters and drop tables, views, synonyms, sequences, indexes, and clusters. Created within tables all kinds of constraints and create referential integrity between tables, using Entity Relational Diagram (ERD), and logical Data Models (LDM). Used Data Manipulation Language (DML) including SELECT, INSERT, UPDATE, and DELETE, and sub queries. Created many block of codes, procedures, functions, packages, and triggers and menus. Created the Stock Tracking Report, creating within these application different styles of reports, namely: tabular, master/detail, matrix, mailing, letter, and form reports. Procedure Builder was used to create common procedures for libraries to use them within several applications.
One Exam is in progress.
2009 International Islamic University Islamabad, Punjab
Bachelor of Science BS in Computer Science
BSCS, Software Development:
Developed software Online Admission Test System for BSCS and BSSE students in the degree of bachelor in Computer science. The Application was server n client based. MS SQL was used for Database and VC.net Language used for developing application.
Projects During BS course work:
Magazine publication using MS Office, Singer company database management system in MS-Excess, CDs and Cassette's shop database management system in JAVA, Implementation of algorithms, designing web site for Swiss miss makeup products using HTML.
Langugaes
English
Urdu.