Adela Smith Email & Phone Number

Knoxville, Tennessee Area

Senior Software Engineer 2 specializing in database architecture and development.

Knoxville, Tennessee Area

As a data warehouse architect, I plan and execute data warehouse data models and BI solutions for the corporation as a whole. I work very closely with a team of ETL and OLAP experts and participate in all aspects of research, development, test, validation, verification, and deployment.

As an ETL developer in the Business Intelligence Department, I developed and tested ETL processes to extract, transform and load financial and marketing data into an internal company data warehouse (hosted on Oracle 11g) for business intelligence usage. In addition, I developed and executed 120-page Test Plan containing 32 Test Cases for a revenue data mart hosted in a SOX-compliant environment. Other development responsibilities included: contributing to the ETL development lifecycle including data analysis, design, development, release/version control, and deployment; documenting mappings, workflows, scripts or other products developed as part of the project; working with Business Object team members to optimize and performance tune SQL queries. Tools used: Informatica version 8.1.1; Solaris 8, MS Office Products, ErWin 7.0. Languages used: Oracle PL/SQL, Perl, UNIX Scripting (bash)

Melbourne, Florida Area

SW Engineer - Clearances: SSBI, DODHarris Government Communication Systems Division; CMMI Level IV (1/2004 - present): SW Engineer 3 specializing in Oracle DB administration and DB technologies. Provided Oracle DBA infrastructure services and strategic guidance for division. Managed & performed Oracle DBA services for Oracle 7.x, 8i, 9i, & 10g. Obtained & managed Certified-level membership in the OPN for GCSD – saving the division $4M+ in the first year. Key negotiator with Oracle for price hold agreement with Harris saving the corporation ~$2M over 3 years. Established policies/procedures for Oracle needs for the division. Provided technical guidance & recommendations for IR&D projects & business pursuits especially pertaining to all db technologies. Provided technical contributions as key personnel in major pursuits and proposals.Government Communication Systems Division (formerly GISD & GASD); (7/95 – 1/2004): SW Engineer 2/3 specializing in DB application dev & targeted R&D. Led projects for internal intranet applications. Developed data models for very large databases (VLDB). Performed data modeling and data migration design, dev & validation for large-scale data migrations. Worked in IR&D investigating emerging DB technologies & their feasibility/applicability to division strategic goals. Authored technical papers used for business development & employee education. Provided technical expertise for proposals, pursuits, & programs. Provided Oracle DBA skills as a division-wide resource for DBA services of dev, test, & production DBs. Designed & developed in-house business apps for internal, division-wide use. Performed embedded design, dev, & testing of imaging products processing digital & analog medical images & of already existing & new Unix-based & PC-based MIS products. Provided DBA expertise for Informix & Oracle. Harris Government Aerospace Systems Division (1/92 - 7/95): SW Engineer specializing in embedded sw development for digital maps.

Bscs, Computer Science

Bachelor Of Science (Bs), Computer Science