Dagny Solutions, Los Angeles, CA
Oct 2012 – Current
Design and build databases to serve as the back-end to customer
facing applications. Oversee the migration and population of data
into the new databases, ensuring accuracy and integrity of all
SQL, Postgres, Python
Center for American Progress, Washington, DC
Aug 2011 – Oct 2012
Migrate a major website from Zope to WordPress and MySql. Design, code and deploy websites and WordPress content management systems for all major properties. Investigate and resolve bugs and site outages. Maintain a high level of consistency and quality. Assist in QA and testing of all sites we develop.
Integrated Training Solutions, Rosslyn, VA
Mar 2010 – Mar 2011
Build a web application to incorporate cultural factors into decision making for use by international organizations. Designed the Oracle and MySql databases and laid the foundation for the PHP/Codeigniter classes to implement the user interface.
Dagny Solutions, Arlington, VA
Sep 2008 – Nov 2009
Developed a website(duelingsports.com) that allows users to measure their ability to predict sports outcomes. Fully designed and programmed the interface and back end database using PHP, PostgreSQL, HTML, CSS, Apache and Linux within the CodeIgniter MVC framework.
FTI Consulting, Washington, DC
Dec 2005 – Aug 2008
Implement SQL solutions for a legal document management business. Load and migrate data between Ringtail SQL Server 2005 databases, and ensure data consistency. Clean up bad data and reconcile billing using SQL and Perl scripts. Implement SQL code to generate data and billing reports for project managers using Reporting Services. Design and build database applications using SQL server stored procedures, Perl and Python to manage document conversion work flow.
Sep 2001 – Dec 2005
Designed and built the database for managing project information for USAID in Iraq. Wrote all the triggers and stored T-SQL procedures. Imported legacy data from various file formats, cleansed for accuracy and transformed to fit into the new system.
Administer the SQL Server database used for the New Iraqi Army recruiting center in Iraq, run ad hoc reports and queries and clean up inconsistent data using SQL queries.
Developed Internet enabled databases in MySql. Implemented the conversion of legacy data from text and spreadsheet files into RDBM systems and analyzed the results to ensure data integrity using a variety of scripts and SQL programming.
Design, develop and implement corporate tax software with an Oracle or SQL server back-end and VB front end for accounting departments, gathering specs and working with business analysts to modify the software to fit their specific needs. Design accounting reports, using SQL queries for auditing purposes.