- Senior Software Engineer at Mitchell1
- Senior SQL Developer at Thomson Reuters
CEO Space, , Entrepreneurship
January 2005 – Present(14 years 9 months)San Diego, CA
Architect of Dot NET apps & SQL databases. Designed the system architectures and administration of large data sets from various data sources. Lead both local and off shore teams. Worked with customers to meet their needs. Develop and negotiate service level agreements and manage to ensure their attainment. Draft and review Requests for Proposals and Information (RFPs, RFIs) and evaluates responses and recommend vendor selection. Managing development, infrastructure, hardware and software migration projects. Manage on and offshore teams (Brazil and Taiwan) on development, implementation and also manage administration of technical training program for business users. ICS is a provider of information data and technology services to political campaigns and businesses. ICS has created technology products and services for political campaigns and businesses. Products all use SQL Server including some on SQL Azure, performance tuning with SQL Analyzer, TFS Azure, and Distributed architecture with Model View ViewModel (MVVM) design pattern. Back ends are WCF services. All are developed in an Agile style process with Unit Testing. Split between C# and VB
Created new and maintained current Data APIs which included business logic, C# services backed by SQL stored procedures, SQL and NoSQL database design and SSIS packages. Data Services Web API’s producing Html, that was then consumed by special Automotive Diagnostics tools and Snap On websites and by third party customers. Worked with distributed teams on and offshore (Ireland). Improved processes by removing technical debt; the database structures including tables and stored procedure were in single files and checked in to source control making updates difficult to manage. Converted to SSDT database projects in Visual Studio solutions. Then created repositories with deployment branches in continuous integration suite using Team City. Git source control, Team City continuous integration, Version1 agile sprint. C#, SQL, XML, Marklogic
Worked with a distributed team of developers and analyst to convert the property tax systems of various county governments including San Diego, Riverside, Tulare, and Kern Counties. Wrote SQL scripts to validate pre and post conversion. Assisted other developers on problem analysis and resolution. Coached team members on advanced SQL concepts, Clean Code and Agile methodologies as they apply to SQL. This was a 95% remote position.
Member of the Systems Level Test (SLT) engineering team. Created a Dot Net C# DLL template to interface a Dot Net based framework to a UNIX based Java system for hardware testing. Used the template as bases for new WPF application that automatically generates Dot Net classes and library projects dynamically from XML data. This code generator Included MS Build, custom version control and automated integration with Perforce source control. The DLLs were used to interfaces via Telnet to work with the java test classes. Supported off shore team in Korea. Created multithreaded Web API for instruments that were not IP assessable. Thus, enabling java programs to access the instruments.
As a member of a team helped built the SQL database side of an automated highway tolling system. A real time system that included collection of automobile transactional data from various collection points and then assembling the “trip” and assigning the appropriate tolls using stored procedures, views and functions. Assisted other team members in introducing structured testing for database programming development. Correct and redesign specifications as needed. Worked with QA team, investigating and fixing system bugs.
January 2015 – October 2015(9 months)San Diego
ACES needed to provide data for a lawsuit. The Aces database was out of control with incomplete and inconsistent data across various normalized and NON normalized datasets including data embedded in other sources in various formats. Investigated and analyzed the problems then recovered and corrected data included merging data from previous data vendors. Created stored procedures, functions and view to support the recovery process. Used SQL Analyzer for performance tuning and investigation. Created distance calculator inC# from mapping APIs and applied to data. Created Excel and SSRS reports to support the lawsuit with the corrected data.
Re-worked a legacy WPF app that controls a genetic sequencing instrument, from a flat C# XAML / Code behind to a MVVM pattern. This re-work required a rewrite of the existing XAML to a standard format and creating View Models with some cases fixing issues with the back end (model). Unit tested new work and used Unit test to show unwanted dependencies in Illumina code. Some features were tightly bound to the entire program requiring additional extensive rework and unit testing.
Created an ASP.Net app using web services and WCF with SQL integrating and internal scheduling service with Gmail and Exchange into one unified front end.
March 2013 – April 2013(1 month)Sylmar CA
Created WPF Touch screen for inpatient survey. Created various SSRS reports
Worked in a team developing a WPF application for generating membership contacts in PDF format that can then singed digitially by the member.
Contract. Web Services for client of Dailey.
Technical Advisor / Statistician to the councilwoman and staff
2009 – 2009
Native or bilingual proficiency
Professional working proficiency
Professional working proficiency
Skills & Expertise
- Small Business
- Team Foundation Server (TFS)
- Windows Communication Foundation (WCF)
- Cascading Style Sheets (CSS)
- Community Service
- Windows Presentation Foundation (WPF)
- Mobile Applications
- Software as a Service (SaaS)
- Business Development
- Entity Framework
- Web Development
- ASP.NET Web API
- Web Services
- SQL Azure
- Computer Programming
- Web Applications
- Test Driven Development
- ASP.NET MVC
- Microsoft SQL Server
- Unit Test
- Language Integrated Query (LINQ)
- Full-Stack Development
Interim Secret Clearance.
US Government JPAS, License