SOPHIA L. STEWART

accrzk@r.postjobfree.com

301-***-****

TOP SECRET CLEARED

I have acted in support of relational database management systems by meeting with clients,

gathering database requirements, creating software requirements documents, and software design

documents. I have over 10 years of specialized support to relational database management systems

of various size and complexity for civil, defense, and intelligence community clients. I have served in

the capacity of Database Administrator, Database Developer, Database Programmer, Database

Analyst, and as a Lead Database Developer. Specifically, I have supported the back end organization

of data; established user roles and managed/monitored accesses; constructed and migrated/installed

new instances of databases; and developed scripts to run queries.

EDUCATION

M.S. Information Technology: Database Systems Technology, University of Maryland

•

B.S. Information Science and Systems, Morgan State University

•

CERTIFICATIONS

DATABASE SYSTEMS TECHNOLOGY (Oracle 11G)

•

JAVASCRIPT FOR WEB DEVELOPMENT

•

TECHNICAL TRAINING

•

• Oracle BI Analytics: Advanced Application Oracle 10g PL/SQL

•

Developer 11i Oracle HRMS Technical Foundation

•

• Oracle BI Presentation Services 10g: Human Resources

Create Reports/Dashboards Oracle 9i Designer

•

• Oracle BI 10g: Analytics Overview OPSEC Fundamentals

•

• Advanced JavaScript for Web Oracle 9IAS: Generate Dynamic HTML

•

Development from PL/SQL

• JavaScript for Web Development Introduction to Computer Security

•

• ASP.NET Oracle 9i: Advanced PL/SQL

•

• Developing a Website FGT Oracle 9i Designer: Web PL/SQL

•

• Oracle 9i Database Administration Design and Generation

Fundamentals II Managing Development Using Oracle

•

• Oracle 9i Database Administration Repository

Fundamentals I Introduction to Oracle 9i: PL/SQL

•

1

Administering the Oracle 9i Application

•

Server

Oracle 9i Reports Developer: Build

•

Reports

Oracle IDS Designer: Web PL/SQL Design

•

and Generation

Oracle IDS Designer: 6i

•

Oracle IDS Forms: Build Internet

•

Applications II

Oracle 9IAS: Develop Web Based

•

Applications with PL/SQL

Oracle IDS Forms: Build Internet

•

Applications I

Oracle 9i: Program with PL/SQL

•

Data Modeling and Relational Database

•

Design

Develop PL/SQL Program Units

•

Introduction to Oracle 8i: SQL and PL/SQL

•

2

•

WORK EXPERIENCE

6/11 to 1/14 – Independent Contractor

Database Developer – Create the database solution development as well as database components

of the design, building, maintenance and support of custom applications. Focus attention to detail so

as to ensure that systems of high availability and scalability as needed by the organization are fully

functional and operating 24x7. Develop complete database solutions for a variety of business

requirements and challenges of an inventory database.

Web Master Create the company website, debug issues that arise with the performance of the

website, monitor the interface for performance issues and perform troubleshooting on the website,

review the statistics and monitor the website optimization, along with maintaining and updating the

website design.

Booz Allen Hamilton 12/05 to 5/13 Lead Database Developer, Sr. Database Analyst, and Sr.

Oracle Database Administrator

Lead Database Developer Lead technical staff, provide technical direction and manage project

timelines; Interact with the client and develop technical specifications that meet requirements.

Demonstrate a strong grasp of Ms Access database architecture, modeling, ETL, SQL, VBA and

database access tools. Document all work and write requirements documents for the product.

Participate in code review and the acceptance process in order to improve methodology and delivery.

Support the systems engineering process through the testing of complex military software. Test

software for correctness, completeness, and accuracy. Prepare deliverable reports detailing the

results of testing activities.

Sr. Database Analyst – Download and analyze data from an Oracle, web based database that allows

regional budget formulation, funds administration, and managerial analysis for the department.

Followed by modifying data from several different databases and creating a new MS Access

database to produce desired data input/output, trend analysis and financial reporting that is scalable

by organization and appropriation to ensure accurate reporting to the Comptroller and other executive

management.

Sr. Oracle Database Administrator Provide technical support in the development of ad hoc reporting

requests from the Client. Work with the Functional Analysts to determine where the requested data

resides in the Oracle 10g Database. Identify tables and data elements then write programs in

PL/SQL to extract the data from the database and provide the data in a CSV file format to the

Functional Analyst and the Client. Prioritize requests and communicate questions or data limitations

to others. Analyze data to determine if there are data integrity issues or the data does not represent

the Client's request. Perform Oracle Database Administration activities that are required, such as

PL/SQL programming, creating tables, packages, views. Performing database imports & exports and

maintaining the database.

3

Department of the Navy 04/02 to 11/05 Senior IT (Oracle) Specialist

Provide Administration of Oracle databases in creating of new and maintenance of existing database

structures, and maintaining systems security. Communicates both orally and in writing for interface

between users, contractors, suppliers, or other organizational units: Serve as senior computer

specialist, setting priorities and coordinating personnel resources and workloads in the evaluation,

approach and completion of requested programming needs: Has continuing responsibility for

assigned systems: Assure technical accuracy of coding, testing, debugging and implementation of

new and modified systems: Develop and assist programming personnel in the preparations of all

phases of AIS documentation, ensuring compliance with documentation standards: and Perform

system analysis and design for both new and existing systems in response to user requirements and

in an effort to increase job efficiency and decrease manpower/workloads.

Information Management Consultants, Inc. 5/00 to 04/02 Oracle Developer

Maintain the Application data on site at NIH/CSAT. Install and update the custom reporting tool,

Reports Generator. Train the client’s users on Report Generator. Complete conversion of database

template from Access 97 to Oracle 8.0. Maintain Oracle tables using PL/SQL. Provide requirements

analysis and database development to the effort to create a Project Revenue tracking System.

AWARDS

Booz Allen Hamilton Performance Award March 2011

Booz Allen Hamilton Performance and Team Award August 2009

Booz Allen Hamilton High Five Award October 2007

Special Achievement Award August 2005

Special Act Award and Time Off Award August 2004

Special Act Award and Time Off Award August 2003

4

Contact this candidate