Profile

• With 23 years of IT industry experience, 15 years of diverse experience focused on relational databases, SQL and OLAP, and one year as a development manager, I am well prepared to meet your needs as a database team manager, senior/lead database developer, or data architect. My experience covers a broad range of end products from web application services to packaged software to computational data analysis.
• I am an active seeker of new skills and personal improvement, which has given me a highly diversified portfolio of experiences and accomplishments. From independent data warehouse consulting to serving as Developer/DBA on commercial casino back-end systems processing millions of dollars and millions of transactions daily, I have built my career around meeting big challenges with elegant, high-performance, scalable solutions.

Experience

PRESIDENT

confidential

Manager of the operations of a thriving online community training professional photographers to do Search Engine Optimization SEO via ebook sales and paid memberships. Providing ongoing support and content to over 600 active subscribing members and a community of over 6,000 customers. The business is conducted purely as a side project and second income specifically designed to demand minimal attention and intervention while providing a profitable revenue stream.

SENIOR DATABASE DEVELOPER

confidential

Lead developer of Order To Cash ETL Master Data Management processes loading revenue from multiple disparate shopping carts into a unified and authoritative revenue recognition system. Responsible for integration of source data from systems including MS SQL, MySQL, MongoDB, and custom third-party feeds, with schemas in languages including French, Spanish, English and German. Architect of a technical solution for portable migration of invoices and orders between multiple systems without impact to revenue accuracy. Lead database developer/architect of e-commerce solutions for Pay-Per-Booking revenue models and Third Party Distribution channel revenue sharing. Member of cross-functional Big Data committee. Member of company chapter of Toastmasters.

MANAGER, IT BUSINESS PROCESSING

confidential

Leader of a mixed in-house / outsourced team developing custom platform applications for iOS, Android, and web to support data collection and analysis for the company's work in statistical research. Launched products include: RouteScout a GPS data collection app for iOS and Android, selected by NCTCOG for a technology demonstration project, winner of best poster presentation at Household Travel Symposium 2012 , RideTrack an app for collection of mass transit boarding/ alighting data, used in field for FDOT and LAMTA studies , TransitManager a PHP web service and MySQL database supporting RideTrack with scheduling, management, and data collection , and NuTripX an ASP.NET/SQL Server application for household travel survey data collection . Provided continuing lead database developer support for ongoing projects in Calgary and Cleveland as needed.

SENIOR DATABASE DEVELOPER

confidential

Lead database developer on multiple very large household travel studies, including Calgary, Cleveland, NYMTC, Oahu, Massachusetts, Atlanta, and CALTRANS. Within first week on the job, refined the Continuous Data Flow processing code to achieve a 10-fold reduction in daily processing times from an unsustainable 18h to 90m. In addition, streamlined the process to automate implementation of all data model changes, saving hundreds of man hours. Spearheaded implementation of GIS data types in the CDF code, enabling more of the geographic analysis and computation to be automatically completed within the database and saving hundreds of Statistical Services man-hours.

SQL CONSULTING / IOS DEVELOPMENT / TEACHING

confidential

Developed iOS brainstorming app, Storms, which enabled a two-phase capture and categorize approach to brainstorming on small screens. Performed SQL Server and MySQL services for a variety of clients including Magnus Karlsson Stockholm, Sweden , Matthew Greene Austin, TX , and Woofi Austin, TX . Taught personal development seminars in 22 countries, managing itinerary, logistics, budget, and scheduling for myself and a partner.

DATABASE DEVELOPER

confidential

Designed and developed high-availability, highly transactional casino back-end systems. Architect of database implementations for Session Bingo and industry-standard S2S protocol.

DATABASE ADMINISTRATOR

confidential

Data lead for the development of the NewHomeSource.com product, a marketing site for the homebuilding industry driven by daily XML feeds. Data architecture, DB development, DB administration and customer support.

DATA WAREHOUSE CONSULTANT

confidential

Architect and lead developer of a data warehouse system for the tracking of mortgage-backed securities. Developed a complex scorecard algorithm for mortgage borrower performance and standardized a B2B data transfer schema for mortgage servicing companies to participate in scoring.

SR. REPORTING ANALYST SR. WEB DEVELOPER

confidential

DBA and lead designer/developer of corporate reporting and data warehousing for a mortgage servicing specialist. Architect/designer/programmer of corporate intranet.

VARIOUS DB AND IT POSITIONS

Employers including Texas Instruments, Georgetown University, and the US Army via Maden Tech

Skills

• Microsoft SQL Server 7, 2000, 2005, 2008, 2012, and 2014. OLAP Services, Analysis Services, DTS, SSIS, SSAS, ETL.
• T-SQL, MDX, XML, HTML, VBScript, Javascript, CLR, C, Objective-C, R, Haskell, Mathematica Performance tuning, debugging, root cause analysis, high availability.
• Data modeling, ERWin, dimensional modeling Kimball, Inmon , process modeling, UML. Multiple VCS systems including StarTeam, SVN, VSS, AccuRev, Git, and Mercurial
• Scrum, Agile development, Lean development, Test-Driven development
• Reporting: Cognos, Brio, Hyperion, Crystal Reports, SSRS, Proclarity, Tableau, Qlikview Compliance: HIPAA, FCRA, SOX, US Secret Clearance lapsed