Skills Inventory

** ***** ** ******** ****** and development

** ***** ** ****** *********** and DBA

** ***** ** **/*** and Ada programming

** ***** ** **** *** Linux

** ***** ** ****** ****** and architecture

14 years of data modeling and process modeling

11 years of scripting languages

11 years of OLTP systems development

11 years of BI, OLAP, and Data Warehousing

8 years of CASE, including DB/Artisan and Erwin

8 years of C programming

6 years of Agile project management

5 years of Oracle production DBA

5 years of Object oriented design and programming

4 years of management consulting

2 Experience

2 Independent Consultant, 2004 Present

For Verizon, developed components of a network health and incident reporting system on an Oracle/Linux platform.

For the USPS, designed and developed components of an Operational Data Store (ODS) on an Oracle/Linux platform.

Managed a small team using Agile methods.

For Marriott, solved performance problems of an Oracle/Linux reporting system. Reengineered the database and a dozen

PL/SQL and Korn shell modules.

3 For Northrop Grumman, solved performance problems in a VLDB data mart and billion row Cognos cubes.

Created a data mart in Oracle 11g and developed an ETL subsystem using Oracle Data Pump and and flashback

databases.

5 For the USDA, developed a reporting subsystem using Oracle, Cognos Framework Manager and Cognos Report

Studio. Developed a demo Business Intelligence application using Cognos Transformer and PowerCubes.

Developed a data migration subsystem using Oracle 10g, and PL/SQL.

For Comcast, developed a high volume DSS database using Oracle 10g and PL/SQL. Also managed a team, performed

production support, and designed the data model using ERwin. Maintained applications written in Python. Designed a

data mart using dimensions, fact tables, and cubes.

For Alion, investigated and fixed a crashed production system using Oracle 10g and PL/SQL. Developed database

administration and programming tools, acted as DBA and developer.

For Advo, evaluated a data warehouse reporting on an Oracle Applications 11i implementation, produced reports

recommending technical and organizational changes. Analyzed a data mart using dimensions, fact tables, and cubes.

For KTC, represented and developed a DSS system in Java, PL/SQL, Javascript, and Cold Fusion.

For Nakuuruq Solutions, organized and led a team of developers in producing a budgeting system using Oracle 10g and

the Oracle Developer Suite 9i. Produced development and configuration management documentation and procedures.

Used Scrum as a project management method.

For OSG, tuned Oracle high volume financial applications, resulting in orders of magnitude performance gains. Used

integrated Oracle/Java testing environment, becoming proficient in UT/PLSQL, Junit and Cactus. Produced financial and

demographic reports using PL/SQL and APEX.

For OST, developed a data model and database using Postgresql, Hibernate, and Eclipse.

1 Database Architect, SRA International, 2003 2004

Developed a batch external interface subsystem in 2 months without requirements, design, or ICDs. Refactored and

ported 70,000 lines of PL/SQL code to a new Oracle 9i application. Produced an Oracle coding standards document.

Produced system documentation using DB/Artisan and DBMS_DDL. Produced system performance studies

demonstrating orders of magnitude of improvement.

Organized and managed a new team of production and development DBAs for a government agency. Participated in the

organization of the larger IT staff for the same agency.

Planned the creation of an Oracle Applications 11i services practice, including the identification of clients, skilled

personnel, and target modules.

2 Independent Consultant, 2001 2003

For a government agency, tuned and reengineered an Oracle 9i database, reducing response times from hours to

seconds. Developed applications using PL/SQL, PL/SQL Server Pages (PSP), and materialized views. Designed data

mart for payroll reporting.

For a non profit, designed and partially developed a Corporate Information Factory and components of a custom CRM

system using Oracle 8i and 9i, PL/SQL. Produced the enterprise data model, operational data store, and data warehouse.

Designed a data mart using dimensions, fact tables, and cubes. Performed physical database design, and database

administration. Developed a code generator that produced 150,000 lines of PL/SQL code from Oracle and business

metadata. Patched a poorly performing Informatica installation with indexes.

For a startup, designed and developed the server side of a marketing system using Oracle 8i, PL/SQL. Performed

physical database design, and database administration. Developed a code generator that produced 100,000 lines of

PL/SQL code from Oracle metadata. Created a data mart for marketing promotions using a star schema and OLAP cubes.

3 Senior Manager, Logictier, 2000–2001

As an Engineering department manager, developed standards and procedures for integrating stovepipe applications into

an enterprise framework, including data warehousing, enterprise data modeling, and real time response systems. Created

data warehouse development teams and a real time systems development team. Served as moderator in requirements

gathering and program management activities. Organized 3 projects using Agile methods, including Extreme

Programming.

As an application developer, served as database developer and DBA on a web usage tracking application using Oracle 8i

and Advanced Queuing. Performed logical and physical design of an Operational Data Store (ODS) and data mart.

4 Independent Consultant, 1995–2000

For a startup, designed the server side of a commercial product that merged data from ERP, CRM, and legacy systems.

Performed data modeling and physical database design, programming, and database administration using Oracle 8i.

Analyzed Oracle Applications 11i data model. Designed an OLAP module having dimensions, fact tables, and cubes.

For an internet service provider, evaluated Oracle Applications 11i ERP and CRM modules, produced migration plans from

legacy and COTS application to Oracle Financials. Managed small engineering/operations department. Converted

production Oracle database from version 7 to 8i.

For a telecommunications company, performed database administration, configuration management, and project

management on a work order system using Oracle 8 on Solaris 2.6, Oracle performance tuning resulting in orders of

magnitude improvement in speed. Administered Oracle Application Server 4.0.8. Developed utilities using PL/SQL and

Korn shell.

For a telecommunications company, developed a long distance pricing system using Oracle 8i, PL/SQL, Oracle

Replication, and PowerBuilder on NT and Unix platforms. Designed and partially developed a telephone billing system

using Oracle Advanced Queuing, C, and OCI. Managed a team of 6 developers and DBAs, delivering a complete system

in less than two months. Performed logical and physical database design as well as server architecture.

For a government contractor, installed, configured, and tuned an Oracle 8 database on Windows NT. Developed database

administration procedures, and ported a MS Access/Visual Basic application to Oracle.

For a bank, designed and developed a series of mortgage analysis reports. Developed data migration scripts, Y2K

analysis programs and over 40 other applications using PL/SQL, Oracle Developer, PowerBuilder, Korn Shell, C, OCI, and

Pro*C. Designed a forerunner of an OLAP module using dimensions, fact tables, and cubes.

For a government agency, created an Oracle Financials reporting subsystem that replaced standard reports and added

custom Oracle Developer Suite reports specific to government contracting. Reverse engineered 2500 Oracle Applications

tables into Oracle Designer, designed an OLAP layer to reside in an Oracle Applications custom module.

On a DoD project, reindexed an Oracle database of 200 tables, reducing access times from minutes to seconds. Wrote

utilities and scripts, including a complete Oracle installation script in Korn shell. Advised on performance, security, and

database design issues. Reviewed logical data model for purposes of normalization. Developed application server

software and dynamic table sizing scripts.

For a startup, designed, developed, and implemented a batch reporting system using Oracle 7. Reverse engineered and

maintained the above in Oracle Designer. Coded over 130 reports and database procedures using features such as

Oracle Replication. Conducted performance tuning, physical database design and other DBA activities. Designed and

code web applications using HTML, Java, OCI, Pro*C and shell scripts.

5 Technical Manager, HFSI, 1994 1995

Performed logical and/or physical database design on 11 Oracle Version 7 databases using data warehouse techniques.

Supervised 3 6 software developers. Developed EAI module for Oracle Manufacturing and Oracle Financials and legacy

systems. Conducted performance tuning and other operations support activities on 12 Oracle databases. Developed

decision support applications using Oracle Designer and Oracle Developer Suite, C and OCI.

6 Independent Consultant, 1985 1994

For a telecommunications company, performed data modeling, physical database design, and development on a Yellow

Pages order entry system using Oracle 7. Developed modules using Oracle Designer and Oracle Developer Suite.

Performed EAI analysis of integration of custom and legacy systems with Oracle Financials. Designed interfaces to Oracle

Financials. Served as DBA and Data Administrator.

For a bank, designed and developed an EAI module, a report distribution system, in the Oracle Financials for using C and

OCI and the Oracle Developer Suite.

For a power company, produced specifications for radiological tracking systems using Oracle Designer. Served as data

administrator and database administrator. Coded Oracle Developer Suite, Pro*C, and FORTRAN applications.

For an energy company, developed an EAI module, a budgeting subsystem/Decision Support System integrated with the

Oracle Financials. Performed physical database design and database administration.

For an energy company, developed an EAI/Decision Support Subsystem custom module for the Oracle Financials.

For a government contractor, engineered a report subsystem for an environmental science application using Oracle 6.0,

C++, OCI and X Windows. Performed physical database design, database administration, and tuning.

For a telecommunications company, analyzed system and data model of Decision Support System (DSS). Managed a

team of thirteen programmers.

Programmer/Analyst, Bureau of Labor Statistics, 1983 1985

Served as primary programmer in a Consumer Price Index (CPI) revision. Lead implementation of three integrated,

distributed data gathering and analysis systems using Pascal, SQL, and windowing packages. Served as database

administrator.

Education/Previous Experience

B.S., Business and Management

Clearances

DoD Secret

aco9ko@r.postjobfree.com

Contact this candidate