Russell Lobban

Summary of Qualifications

  • Designed and implemented data marts which other university campuses have adopted as their working model.
  • Strong experience and knowledge in Extract, Transform and Load (ETL) data processes and tools interfacing with Oracle, SQL Server, MySQL and other data sources.
  • Extensive experience in developing PL/SQL packages on Oracle 9i through Oracle 11G.
  • Demonstrated expertise in web application development using ASP.NET, MVC, C#, HTML and XML.
  • Experience in developing and administering SharePoint sites, including providing custom lists, document libraries, and Business Intelligence integration using SQL Server Reporting Services.
  • Strong communicator with the ability to interface and translate between management, end users and technical staff.

Technical Skills

  • OS:  Windows server (2003,2008), Linux desktop and server
  • Languages:  SQL, TSQL, PL/SQL, C#, ASP.NET, ASP, HTML, XML, Perl
  • Databases:  Oracle, SQL Server, MySQL
  • Tools: Cognos, Visual Studio.NET, Microsoft Reporting Services, PL/SQL Developer

Professional Experience

Data Analyst
Auctiva, Chico, California                                                                        January 2012 – Present

  • Design and Implement Dimensional Modeled data marts to support operational data and analytical data.
  • Build and Implement SQL Server Analysis Services Cubes for end users adhoc querying.
  • Implement Decision Support System for the executive team to support evidence based decision making.

Data Warehouse Lead
California State University, Chico, California               October 2009 – January 2012
In addition to Data Warehouse Developer duties:

  • Project planning and ongoing assessment of progress for Data Warehouse projects.
  • Responsible for All aspects of the Data Warehouse, including data modeling, ETL and reporting.
  • Provide direction to Data Warehouse team.
  • Evaluate data needs of the campus.
  • Work as the liaison with Institutional Research, Enrollment Management, Information Security, Application Development and other departments to provide any support required.

Business Intelligence/Data Warehouse Developer
California State University, Chico, California                March 2007 – October 2009

  • Develop reports and dashboards using Microsoft Reporting Service, Oracle PL/SQL and ASP.NET to deliver actionable data to the decision makers on campus.
  • Design and implement data warehousing solution using Cognos and PL/SQL to report across the three modules of PeopleSoft CMS including Finance, Human Resources and Student Administration.
  • Responsible for continuous Oracle and Microsoft SQL Server database performance tuning.
  • Use Cognos Data Manager and PL/SQL to perform Extract, Transform and Load (ETL) processes.
  • Train and mentor report writers in different departments on campus.
  • Create user guides and provide ongoing workshops and training for end users.
  • Accomplishments
    • Developed a general ledger data mart that has been adopted by multiple other CSU campuses.
    • Implemented a web application in which reports from multiple reporting systems used on campus can be found in a central location (

Analyst/Programmer II
California State University, Chico, California                October 2002 – March 2007

  • Design and implement web based solutions to assist advisors with their daily tasks.
  • Produce reports for the Federal Department of Education based on government specifications.
  • Provide desktop support to staff members in the department
  • Serve as the primary technical support representative and liaison for the department.
  • Accomplishments
    • Implemented student tracking application using ASP.NET and Microsoft SQL Server eliminating the need for paper files.
    • Converted progress report paper forms sent to professors to an online version increasing the return rate by 45%.

Education and Certification

Master of Science, Computer Science December 2008
California State University, Chico CA

Bachelor of Science, Computer Science December 2002
Florida International University, Miami FL

ITIL Service Management Foundation Certification – June 2010

Real World Project Management – May 2008

Sans Essential Secure Coding Java/J2EE – October 2010

Oracle Database 11g: Advance PL/SQL Ed 2 LVC – June 2011