9917 Whitworth Way
(410) 480-8422 (home)
(410) 786-4731 (office)
Objective
To obtain a professional level job where I can use and enhance my database, system design, and project management skills.
Qualifications
I am an Oracle 11g/10g/9i/8i Certified Database Administrator. Currently I have 14 years of professional experience. I have a Masters degree in Computer Systems Management (Database Systems Technologies) and undergraduate degrees in Computer Science and Biology. I continue to take and teach computer science courses in the evening.
Education
2005
MS, Computer Systems
Management (Database Systems Technologies)
GPA: 3.923
1999
BS, Computer Science
1995
BS, Biology
Hardware/Software
Programming Languages:
Java, JavaScript, C, C++, Lisp, Prolog, Basic, Pascal, Icon, Assembly, SQL, PL/SQL
Databases:
Oracle 11g, 10g, 9i, 8i and 7, Microsoft SQL Server, DB2, Microsoft Access, Teradata
Operating Systems:
Unix, Linux, VAX/VMS, Windows Server
2003, Windows 2000, Windows NT 4.0, Windows
Software/Utilities/Business
Intelligence:
MQ/QREP, MATLAB, SAS, Erwin, Oracle Forms, Reports and Designer
Certification
Oracle 11g, Oracle10g, Oracle9i, and Oracle 8i (Oracle Certified Professional)
Database Systems Technologies (Graduate Certificate UMUC)
Work Experience
September 2009 Centers for Medicare & Medicaid Services
To Present
Special Assistant GS-13
· At the Centers for Medicare & Medicaid Services I am currently working a detail as a Special Assistant in the Enterprise Databases Group.
· Collaborate with OIS Special Assistants. These activities include: support for OIS Leadership meetings; support for Component Meetings; Annual OIS Director's Citation Awards process.
· Identifies opportunities to create, innovate, or leverage existing processes which lead to efficiencies in overall OIS operations.
· Assure Group and Deputy Group Directors are prepared for meetings. Assure agendas and background material are available. Capture action items and make sure they are followed through to completion.
· Analyzed and categorized all business functions performed in EDG and determined implications of future initiatives/investments on those functions. This analysis was used by the EDG management team as a baseline for discussions and will serve as a foundation for future strategic planning.
· Participated in group level technical discussion as well as reviewed and commented on technical papers discussing Master Data Management, Service Oriented Architecture, Cloud Computing, Enterprise Portals, Disaster Recovery, High Availability, and Enterprise Data Environment Strategies.
· Act as a consultant on policies, procedures, and issues. Perform reviews, studies, and evaluations. Provide advice and recommendations to the OIS senior management on key issues affecting the operations on OIS and CMS programs. Prepare briefings and presentations.
· Attend and participate with or represent EDG senior management in high level meetings involving EDG issues, projects, and work assignments including management program policy development. Direct, monitor, and report on needed actions to ensure OIS and CMS goals, objectives, and deadlines are understood and met.
· Coordinate EDG program related studies and projects that cut across components and may involve other CMS Centers/Offices/Regions to assure that all products are adequate and all staff work is completed on time for the Office Director/Deputy Director. This includes establishing priorities, timetables, standards, and guidelines for completion of work.
· Worked on EDG FY2011/2012 Information Technology Budget Call Letter
· Work on special assignments involving sensitive and/or confidential program and personnel related issues.
· Perform special analytical and written assignments as needed.
April 2007 Centers for Medicare & Medicaid Services
To September 2009
Division of Database
& Middleware Services
Information Technology
Specialist GS-13
· As a Government Technical Lead for the Division of Database & Middleware Services I provided contractor oversight for:
· As a Government Technical Lead for the Division of Database & Middleware Services my duties also include:
· As a Government Task Lead I had the following responsibilities as related to Award Fee Letters:
· As a Government Task Lead I had the following responsibilities as related to Invoices:
§ Review labor hours and skill mix
§ Compare current invoice hours to previously invoiced hours to ensure trend is as expected, based on work added to/removed from contract
·
Send the signed invoice coversheet to the
o with concurrence that invoiced hours are reasonable for the period reported, or
o with non-concurrence and a list of issues found in the invoice
§ Distribute invoice to other GTL’s and/or business owners for review; consolidate issues and comments back to the PO
· As a Government Task Lead I had the following responsibilities as related to Technical Evaluation Panel (TEP):
· As a Government Task Lead I had the following responsibilities as related to Statements of Work (SOW):
June 2003
To April 2007
Bird Banding
Laboratory
Information Technology
Specialist GS-13
· The USGS Bird Banding Lab maintains current and historical information on migratory birds. Over 50 million north American birds have been banded and tracked since the early 1920’s. This banding and sighting information is currently maintained on an older batch oriented HP system that is being replaced by a modernized system that will provide both government and academic researchers with the bird banding data they need in a timely and cost effective manner.
· I designed the overall data base architecture for the new Bird Banding System. This new system is a multi-tier application consisting of database servers, web servers, management servers, security servers, and end user machines. This project includes migrating data from the legacy HP computer into an Oracle database. This data was mapped .from a hierarchical system into a relational system. This included setting up naming standards and data base best practices. I also assisted in setting up a WIKI system to allow end users to collaboratively work on the system requirements. I was part of a small group that implemented a problem referral and tracking system so end users and management could report and track problems. We set up a web application server that communicated with the database system. The current data base consists of approximately 100 tables and over 60,000,000 rows of data.
· After the initial Data Base Design I implemented the Data Base Architecture which was supported by code written in Oracle Forms, Oracle Reports, Java, JavaScript, SQL and PL/SQL.
· In addition to my database activities I am responsible for the design, programming and implementation of the band order management portion of the new banding system. This subsystem is written in , JavaScript, SQL and PL/SQL.
· I am responsible for systems administration for the Bird Banding Lab’s Oracle servers. I perform server configuration using the database configuration assistant (DBCA) to create and clone databases. I maintain security in the database and on the Oracle servers. I apply security patches to the Oracle servers. I load and unload data into the database using Oracle Import, Export and Data Pump. I monitor and manage server-generated alerts. I make use of general storage enhancements in Oracle. I also create the SYSAUX Tablespace and relocated SYSAUX occupants. I use the system resource management features of Oracle to automatically switch a session back to the original consumer group at the end of the top call. I set idle time-outs for consumer groups. I simplify management tasks by using the Oracle scheduler to create a jobs and view information about job executions and job instances. I reduce space related error conditions through proactively managing tablespace usage. I reclaim wasted space from tables and indexes using the segment shrink functionality. I also use the Segment Advisor and the Undo Advisor to manage space in Oracle. I create temporary tablespace groups and assign temporary tablespace groups to users. I perform advance database tuning for the Bird Banding Lab’s Oracle systems.
· I installed and configured Snort to be used as an IDS (Intrusion Detection System) tool for the Linux and Windows servers that supported the BBL Oracle application.
·
I manage and lead the Bird Banding Labs Oracle
Project Team. I write system documentation and present material to upper
management on the status of the Oracle Project. I use Oracle Net Meeting to
hold meetings with staff from across the
May 1999 Social Security Administration
To June 2003 Division of Data Base Systems
Data
Base Administration Branch
· I was a member of the Data Base Administration Branch which supports SSA’s major Oracle data bases which were used primarily by commercial off the shelf packages that SSA acquired to support administrative and management information systems. Because of the size of the SSA application systems, and its functionally organized development organization, the data base administration functions were separate from, but provided direct support to the application programming areas. Application design teams had members from both the systems development and the database areas.
·
I helped develop and enforce the Data Base
Architecture used by SSA for both major programmatic and administrative
systems. I was responsible for data base administration and data base related
design and development activities for several production databases with over
hundreds of tables
and hundreds of thousands of rows. I helped develop
and enforce database standards, guidelines and operational policies and procedures. I reviewed physical structures. I reviewed performance, maintenance and
utilities associated with each structure (i.e., REORGS, LOAD, UNLOADS). I reviewed necessary storage media (DASD and Tape). I reviewed SQL performance and performed SQL
tuning. I reviewed application's access
to the database structures and reviewed backup & recovery strategies along
with the purge/archive criteria. I
monitored database/subsystem performance issues including memory usage and
tuning. I was a member of a team that
implemented, maintained, and tested both security and backup & recovery
strategies.
· I used software tools such as ERWIN to automate design transformations, to generate relational database design, to generate data base models; and to support naming and data type standards. I performed basic day to day administration for applications such as DICARS, LDF, TNA, MICES. I met with programmers and operations staff to identify and resolve any data base related issues. I helped develop naming standards and , performed tuning of stored procedures.
· When SSA purchased commercial software packages for administrative and management information systems, I was on several of the evaluation teams that carefully reviewed vendor proposals and software to ensure that proposed software packages met the detailed requirements specified in SSA’s request for proposals. These evaluations were often very complex and lengthy and required digging through layers of marketing and proposal information to find out the true capabilities of products. After we evaluated written proposals we also installed and tested the software for compliance with the proposal specifications of functionality and performance.
· I wrote Java programs, Korn shell scripts, and SQL scripts to support database administration functions. These programs and scripts were used to compare databases, change passwords, retrieve performance data, perform maintenance of old files and system logs and perform advanced security related tasks and audits. I wrote procedures for the Sniper Security System to help protect COTS products, which contained embedded passwords and where vulnerable to attack.
· I developed dynamic WEB pages using Java, JSP, Servlets and HTML on an Oracle Application Server (OAS) and internet Application Server (iAS) environments. This system was used to maintain project and release information for database projects and activities.
· I worked with the Oracle 11i Financials Suite on the RFACTS project.
December 1997 United States Department of Commerce/Bureau of the Census
to May 1999 Geography Division
Economics Programs Branch
Upper Marlboro,
I worked for the Economic Programming Branch, which prepares
data from the decennial census and the economic census for analysis. When the census data comes in it is optically
scanned and processed. Any data that is
not coded with confidence is sent to a large clerical operation in
· I designed and developed a C program to take this data and break it up into small work units and added extra quality assurance cases.
· I developed a set of command procedures to transfer the data from the VAX system where the initial processing is done to the UNIX system.
· I wrote control files and loaded the data into the Oracle database with SQL Loader.
· I wrote a PL/SQL program that would compare and grade the QA cases. For each QA case there would be three identical records to compare.
· I also developed PL/SQL code that would calculate how long a clerk took to complete a work unit.
· Using Oracle Forms, I designed and developed a separate training system from the production environment so that the clerks could learn how to use the system without corrupting the production database. I set up a grader, using Oracle Reports, to evaluate the progress of the clerks.
· In addition to using Oracle Developer, I set up and managed the database. I tested the system under Oracle 7.3.3 and Oracle 8.04. I created tables, indexes and views. I set up users and roles. I used SQL Loader to load data into the tables. I used import and export to transfer data along with data links between the databases. I used SQL extensively to monitor the integrity of the system and data. I created tablespaces to store the tables and indexes and helped with debugging problems with Oracle’s context option.
October 1995 United States Department of Agriculture
to December 1997 Agricultural Research Service
Soil Microbial Systems Laboratory
I worked for Dr. Jeffrey Buyer, a research chemist at the Soil Microbial Systems Lab.
· As an entry-level soil microbiologist duties included collecting and harvesting soil samples, preparing these samples for analysis and performing multiple procedures with the final analysis generally using gas chromatography for identification of species based upon fatty acid composition.
· Designed and implemented software in C++ to manipulate data collected from different projects in microbiology and for projects in the Remote Sensing and Modeling Lab.
· Programmed for the Remote Sensing and Modeling Lab under the UNIX environment. One program, written in C++ took data from a satellite and used it to model a biological system. Converted MATLAB m file programs into C programs. Also did some basic image processing with MATLAB.
· Used C++ to write a program that would manipulate data from a biology experiment in order for my supervisor to work with the data in SAS. Used SAS to do statistical modeling of data. Used Microsoft Access and Lab Chem. to create and work with the lab’s chemical inventory database.
January 2000
To Present
I am a Adjunct Assistant Professor at UMUC. I have also supported over 60 classes in computer and information science in the past 10 years as a teaching assistant.
Courses I have taught:
· CMIS 102 Introduction to Problem Solving and Algorithm Design
· CMIS 141 Introductory Programming
· CMIS 325 Unix with Shell Programming
· CMIS 320 Relational Databases
· CMIS 420 Advanced Relational Databases
· CMIS 435 Computer Networking
· CMSC 424 Database Design
· IFSM 310 Software and Hardware Concepts