SOPHIA L. STEWART
accrzk@r.postjobfree.com
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