Improver

Vanessa McCaleb

Software Developer at Preferred Systems Solutions

Ashburn, Virginia

Over 14 years experience providing database and data solutions, in numerous architectural environments. Most recent experience is as a software developer extracting, transforming and loading disparate datasets in an enterprise environment. Primary tool used to develop and maintain ETL code is Pentaho Kettle Spoon 4.2. Uses Oracle as an operational datastore and Netezza as a enterprise repository for transformed data along with associated utilities: SQL Loader, SQL Developer and SQuirreL for manipulating data. Utilizes sql, stored procedure languages (e.g. PL/SQL), regular expressions (RegEx), javascript and java to update/transform data.


Experience delivering logical/physical database designs using various modeling tools such as Embarcadero ER Studio, Erwin and SQL*Developer. Also experience designing and developing logical and physical data models for Staging, Data Warehouse, and Data Marts. Adroit with providing capacity planning, interfacing specifications, data loading plan, data maintenance plan, security policy, backup and recovery and disaster recovery plans.

Architected a solution leveraging Amazon Web Services (AWS). The solution required configuration of numerous AWS services including EC2, S3, EBS, RDS and IAM.

---

Experience:

• Database Administrator (Qvine Corporation)
• Database Engineer (Preferred Systems Solutions)
• Oracle Database Administrator (BAE Systems)
• Software Developer (Preferred Systems Solutions)
• Architect / Principal Consultant (Epikuru)
• Database Administrator (General Dynamics Information Technology)

Skills: