Resume

Last update 2008.04.24

Download in MS Word format

Professional Summary:

  • 8+ years in the IT domain focused on report development and analysis tools
  • Proficient with SQL 2005 Business Intelligence tools, Data Warehousing and ETL processes
  • Proven talent in Database Analysis, Reporting, Development and common Administration tasks

    • Technical Summary:

    SQL Server 2000/2005:

  • T-SQL, Stored Procedures, Backup/Restore, Replication, Indexes, Normalization concepts

    • Business Intelligence:

  • Extract Transform Load (ETL) development using SQL Server 2005 Integration Services (SSIS)
  • Dimensional Data Modeling and Cube development in SQL Server 2005 Analysis Services (SSAS)
  • Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS)

    • Oracle 9i:

  • Basic PL/SQL, Stored Procedures, Sequences, Functions

    • Professional Experience:

    LPL Financial (July 2007 » Present)

    SQL Server Business Intelligence Analyst / Developer

  • Lead team on Business Intelligence efforts by providing real world training exercises and demonstrations
  • Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM)
  • Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
  • Architect faux data mart solutions to improve performance of SQL Server 2005 Reporting Services (SSRS)

    • Stratagene (Feb 2007 » July 2007)

    SQL Server Business Intelligence Analyst / Developer

  • Provide SQL Server 2000 Data Warehousing (OLAP) support and upgrade plan
  • Design and execute SQL Server 2000 – SQL Server 2005 upgrade plan
  • Integrate custom .Net assemblies into Reporting Services Reports for outside the box solutions
  • Use SSIS to perform ETL operations for Master Data Management (MDM) needs as well as auditing reasons

    • Thomson Learning (NETg) (Nov 2005 » Dec 2006)

    SQL Server Database Developer / Analyst

  • Interface with business to gather Business Intelligence requirements
  • Administer OLTP and OLAP SQL Servers
  • Develop Oracle PL/SQL stored procedures for Decision Support System to assign sales territories to new leads
  • Architect and execute Business Intelligence solutions including ETL, OLAP, and Reporting requirements
  • Manage migration from Crystal Reports to SQL Server 2005 Reporting Services (SSRS)

    • ICE Enterprises (May 2004 » Nov 2005)

    SQL Server Developer (Aug 2004 » Nov 2005)

  • Install, configure, and develop SQL Server 2000 Reporting Services (SSRS)
  • Advanced reporting techniques included time series trend analysis, de-normalization of data and linear regression
  • OLTP T-SQL development support for cruise booking software
  • Custom ETL solutions using T-SQL stored procedures schedules as jobs.
  • Perform migration from Crystal Reports to SQL Server 2000 Reporting Services (SSRS)

    • Operations Analyst (May 2004 » August 2004)

  • Create Busines Intelligence solutions including Executive Dashboards and Business Scorecards with MS Excel
  • Perform ETL operations for Business Intelligence reporting solutions using custom VBA and Excel web queries
  • Create ad-hoc queries from SQL Server databases for custom reporting needs

    • MCI Communications (Apr 2000 » May 2004)

    SQL Server Developer (February 2002 » May 2004)

  • Developed custom online reporting solution using classic ASP and SQL Server 2000
  • Administer local SQL Server 2000 for custom reporting app.
  • Develop custom T-SQL stored procedures to perform ETL operations

    • Third Party Verification Specialist (June 2001 » February 2002)

  • Research sales issues by doing ad-hoc queries in Oracle 8i and SQL Server 2000 databases
  • Developed website for all communication to local inbound sales reps using classic ASP and SQL Server 2000
  • Act as a liason between national support organizations and local call center management

    • Helpdesk Administrator (April 2000 » June 2001)

  • First level support for all system issues including PC, Telephony, and LAN issues
  • Troubleshoot desktop PC issues and resolve by replacing hardware or re-imaging the PC
  • Nightly maintenance of local servers (backups to tape, batch jobs, etc.)
  • Perform basic SQL Server 2000 administration tasks including security access, backups and restores.

    • Education:

    Maricopa County Community Colleges

    Glendale Community College (Spring – Summer 2001)

  • General educational requirements plus some basic programming language courses (VB6, Classic ASP)

    • Scottsdale Community College (Fall – Spring 2002)

  • Focused on math and programming classes for CIS Associates Degree (Database Fundamentals, Oracle PLSQL)

    • Phoenix College (Spring – Summer 2006)

  • More general requirements, Accounting, Math and other programming courses (Unix, C#)

    • *References upon request