SUMMARY

Creative software engineer with 12 years of experience. Strengths include building interactive web sites, reporting systems, data storage systems and server automation. Extra care given to system usability, maintainability and simplicity.

SKILLS

Python - PHP - ASP - JavaScript - [X]HTML[5] CSS - Debian - Solaris - Windows Server 2003

MySQL - MSSQL - sqlite - Oracle

IIS - Apache - nginx - XML-RPC - VPS - Cloud (AWS-Rackspace) - API - Fabric

Android - SL4A

CONSULTING SERVICES

Enhancements to multi-CDN front-end system, both client and admin areas, with Python, PHP, MySQL
Integration with third-party APIs via SOAP, REST, XML-RPC, such as paypal.com, encoding.com, heywatch.com, edgecast.com
Development of API for video loading, encoding, deployment to CDN and playlist creation, specifically for iPhone HTTP Streaming (m3u8)
E-commerce site customization with CS-Cart, PHP, MySQL, JavaScript, python. Media files on Amazon S3.
Server setup and maintenance. Windows 2000, 2003, Linux. Automated cloud deployment (Rackcloudspace, python fabric, Apache libcloud)
Web-based reporting application for loan process queue management, online loan-pricing, excel pivot tables for loan officer commissions. Mailings with MS Word, Python, MSSQL
Server migration and maintenance automation with Python. Firewall and network configuration: Cisco, SonicWall.
Developed and maintain kissws.com for development use, including service logging, queues.
Cloud sevices consultation, S3, CloudFront, rackspacecloud, encoding.com api

CORPORATE EXPERIENCE

Countrywide, Bank of America (Calabasas)

Analyst III, 2010-

Enhancements to SQL reports for subprime repurchase pool management
Reporting automation, dependency management.
Data transformation, validation
Creation of web-based internal tools for discovery, graphing of data relationships (Python, web.py, graphviz)
Creating C#4 .Net team intranet, per IT specs.

Health Net, Inc. (Woodland Hills, CA)

Programmer Analyst 2004 - 2009

Designed and built custom application framework in ASP Classic with granular role-based security, database connection wrappers, user-dependent menu, database-persisted session and key-value store. Used as security and UI framework for nine applications that were unsecured and standalone before.
Built web-based hospital utilization reports.
Designed, implemented, tested web-based medical management reporting engine for EDS-built medical auth transaction system. This included report definitions, customizable data filters, measures, submeasures, and custom column banding; drillable from national level to member listing to member detail level. Metadata in MSSQL 2000, user data in read-only Oracle 9 data warehouse, JavaScript + synchronous AJAX and filter mechanisms. All table-driven. Used by medical management as primary reporting tool.
Designed and built Appeals and Grievances reporting system with data filters, date-range selection, and compliance calculation. Metadata in MSSQL2000, user data in read-only Oracle 9 data warehouse.
Wrote a suite of Python scripts to automate deployment to test and production servers; to monitor, maintain uptime and availability on Solaris 9, integration with XML-RPC for preemptive reporting cache optimization. This reduced on-demand page generation time to meet SLA.
Debugging and additions to provider system maintenance. C# .NET.
Documentation and maintenance of Provider Credentialing application. FoxPro v8.

Imperial Capital Bank, (Encino, CA)

DBA/Analyst Programmer 1999-2003

Database administration (Access 97, 2000, MSSQL 2000); application development (XHTML+CSS+ASP+ADO on intranet, Access97 and 2000); systems design, evaluation, development, documentation (loan operations, audit reporting, user management); script automation (VBScript, Python, XML-RPC); user password/groups management Win/Exchange; Win2K Server+IIS setup/admin/backup + Active Directory.
Loan databases with customized intranet reports and csv exports to Excel. Residential loan portfolio analysis (1000+ loans, $120M+) with gap, delinquency, roll rates, CRA, FHLB reporting. Reports on credit rating average falling at or near loan payment repricing due to more creditworthy borrowers refinancing away from the pool prompted executive management to sell the entire loan pool.
Designed and implemented a web-based replacement for legacy applications in security, invoicing, HR, production, management real-time reporting, etc. Crystal Reports.
Custom system for ASP-based authentication, session-maintenance, granular security, and access login. PGP, AES encryption, MD5 and SHA. SSH and telnet server administration. Scripted and command-line FTP. Samba, PostgreSQL, Apache 2.0, Python, PHP. Setup LAMP server on DMZ for special 4-month project to automatically report on software deployed on company computers.

ACTIVITIES and PROJECTS

Member of Southern California Python user group. Presented several times.
Debian fabric deployment tools
Android SL4A python scripting
Automated cloud deployment with libcloud, others
Active iPhone developer

EDUCATION

Bachelor of Science in Information Systems (Business option) from California State University, Northridge.