Russell Fox
Database Developer
  • West Sacramento,
  • California,
  • United States
Member Since: 2014/05/07
Industry: Business
Top Skills:
Tech Certifications:
Wizard
Connect on Live

Database guy in California, mostly SQL Server but enough knowledge of other DBs to cause serious problems. SSRS, MongoDB, ETL, beer/wine.

More bio
Activity
Points this month50
Total points451,065
Questions: 1
Solutions: 288
Articles:
Videos:
Courses:
Posts:
Live: 1
Professional Background
Database Developer
First Corporate Solutions
January 2014 – Present
Business Intelligence Developer (contractor)
Hewlett-Packard Networking
January 2013 – January 2014
Created B.I. solutions for the HP Networking division, including SSRS reports, SSAS cubes, and SharePoint PowerPivot dashboards.
Database Administrator
First Corporate Solutions
October 2010 – December 2012
Database administrator responsible for ETL operations of UCC data from multiple states, database development for new systems, business intelligence/SSRS reporting, and error tracking using Microsoft SQL Server 2000 & 2008.
Web Developer
Colliers International
January 2008 – June 2010
Full responsibility for company's three main database servers (back-ends for ColdFusion 8 intranet, Microsoft Dynamics CRM 4.0, and SharePoint WSS 3.0): updated from SQL Server 2000 to 2005, set up the company's first SSRS server and created financial reports with the Director of Finance, set up backup and maintenance plans.
Created a job tracking system based on Microsoft Dynamics CRM 4.0 and Windows SharePoint Services (WSS) 3.0 for a large project with the FDIC.  Analyzed project processes at all levels of the internal and client organizations and made recommendations on system changes and improvements.  Selected and managed a SharePoint contractor.
Given full responsibility for the company's ColdFusion job management intranet site: updated from CF5 to CF8, repaired broken functionality and added new features.  Replaced HTML reports with SSRS.
Created invoice document generator using OpenXML and C# .Net.
IC, Database Developer
EGIA
2010 – 2009
Contract position to develop Microsoft Access projects (Access front-end with SQL Server back-end) to support new energy efficiency projects managed by EGIA.
Database Developer
MetroPCS
January 2008 – May 2008
(dates concurrent with Colliers) to re-engineer an aging Access/SQL Server system for tracking cell tower site construction projects.  Interviewed personnel in the Executive, Administration, and Operations departments to map requirements and define scope-of-work.  Made extensive use of SQL Server triggers and views to transfer operations from the client desktop to the server.  Created a more robust, flexible system with one tenth of the original VBA codebase, along with more useful and attractive reports.
Database Administrator / Web Developer
The Lyle Company
December 2006 – December 2007
Returned to Lyle (see below) to create the new corporate website per their design specifications (www.lyleco.com) using PHP 5 and MySQL 5.  Created job tracking system with SQS server 2005, Access, and SSRS to replace a multitude of individual Excel spreadsheets.
Lease Auditor
Tower Records
May 2006 – October 2006
(Company went bankrupt 10/2006)  Transferred an aging Paradox lease database to SQL Server 2005.  Audited leases for CAM over-charges, discovering over $500k in over-charges
Developer / Lease Auditor
The Lyle Company
May 2004 – April 2006
Took over development on an aging trouble ticket system in Access 2000: improved record retrieval time from minutes to seconds by implementing proper indexes.  Generated new reports with Crystal Reports.  Helped manage leases on AT&T cell tower sites including landlord contact and issue resolution.
More
Education
University of California, Davis
BA
English, Environmental Policy
1988 – 1996
More
Full Biography

Database developer since 1996, generally in the Microsoft stack but currently working on a MongoDB project. Just completed a project to use Amazon's SES to send emails via Database Mail, which also forced me to finally learn C#.

Languages
No Languages shown

Level Progress

Current: Level 15
Russell needs 60,935 points to level up.
LVL 16
  • Overall
    15
  • Microsoft SQL Server
    10
  • Microsoft SQL Server 2008
    8
  • SSRS
    8
  • Query Syntax
    6
  • Microsoft SQL Server 2005
    4
  • Microsoft Access
    4
  • Databases
    4
  • SQL
    3
  • Microsoft Excel
    3
  • MySQL Server
    3
  • DB Reporting Tools
    3
  • VBA
    2
  • ASP.NET
    2
  • Microsoft Server OS
    2
  • .NET Programming
    2
  • SSIS
    2
  • Spreadsheets
    2
  • Microsoft Dynamics
    2
  • Visual Basic.NET
    2
  • Oracle Database
    1
  • C#
    1
  • VB Script
    1
  • Microsoft Office
    1
  • Windows OS
    1
  • Microsoft Development
    1
  • JSON
    1
  • Java
    1
  • JavaScript
    1
  • Microsoft Applications
    1
  • Windows 10
    1
  • Page Layout Software
    1
  • Web Development
    1
  • XML
    1
  • Programming
    1
  • VPN
    1
  • Azure
    1
  • Microsoft SharePoint
    1
  • AJAX
    1
  • Active Directory
    1
  • C++
    1
  • Facebook
    1
  • Linux Networking
    1
  • Microsoft Visio
    1
  • Networking Hardware-Other
    1
  • NoSQL Databases
    1
  • PHP
    1
  • Perl
    1
  • Proofreading
    1
  • Quality Assurance
    1
  • Software
    1
  • Twitter
    1
  • Windows Server 2008
    1
  • iPad
    1

Profile Validation

Email Verified
Expert Level Achieved
PayPal Connected