Address:

1684 Barlow Rd.

Hudson, OH 44246

(216) 926-9506

Daniel R. Spohn


daniel@danielspohn.com

http://danielspohn.com

Profile:

I'm currently working as a Business Intelligence Developer in Cleveland, Ohio. I specialize in database development, data extraction and loading, reporting, data analysis tools (OLAP) and server side web development. I'm a creative problem solver, self motivated, and love to work with new and exciting technologies.

Education:

Youngstown State University - Youngstown, Ohio

Graduated: May 2007

Degree: Masters of Computing and Information Systems GPA: 3.9

Kent State University - Kent, Ohio

Graduated: May 2005

Degree: Bachelor of Business Administration in Computer Information Systems (Dean’s List)

Recent Training:

  • Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services

  • Implementing and Maintaining Microsoft SQL Server 2005 Integration Services

Significant Coursework:

  • DBMS (Oracle 9i, SQL, Database Modeling)

  • SQL, PL/SQL Programming (Oracle 8i, PL/SQL)

  • Adv. Database (Oracle, Indexing, Database Engine)

  • Data Mining (R, WEKA)

  • Server-Side Web Development

  • Programming for Business I & II (VB .NET, Java )

  • Principles of Systems Development (VB .NET)

  • Object Oriented Programming (C++, Linux, g++)

  • Data and File Technology (VB .NET, MS Access)

  • Client-Side Web Development

Skills:

  • Database Design / Development

    • MS SQL 2005, Oracle 9i, MySQL, MS Access

    • SQL Server Management Studio, SQL*Plus

    • SQL,T-SQL, PL/SQL, SSIS, SSAS, SSRS

  • Dashboard Design / Development

    • Sharepoint, Performance Point, Proclarity, DSP

  • Web Site Design / Development

    • PHP, Perl, JavaScript, AJAX

    • XHTML, XML, CSS

  • Server Tools

    • ssh, telnet, vi

  • Software Design / Development

    • VB .NET, Java, C++

    • Visual Studio .NET

    • SourceSafe, CVS

    • MS Project, ERD design

  • OS Installation and Management

    • Linux, Windows

  • Linux Server Management

    • Apache, PHP5, cron, MySQL, CUPS

    • Ubuntu, Debian, Red Hat/Fedora

Career Experience:

Progressive Insurance – Business Intelligence Developer - Mayfield, Ohio - 07/07 – Current

  • Working on Business Intelligence projects in a telecom environment.

  • Create Multi-Dimensional cubes using SQL Server Analysis Services 2005 (SSAS)

  • Create ETL Processes using SQL Server Integration Services (SSIS)

  • Develop T-SQL for Reports and Stored Procedures

  • Create Reports using SQL Server Reporting Services 2005

  • Create Dashboards in Sharepoint using Performance Point and DSP webparts

  • Perform rotating 24x7 production support of ETL and OLAP jobs.

Pharmacy Data Management Inc. - Database Developer - Boardman, Ohio - 09/06 – 07/07

  • Worked on Business Intelligence projects in a pharmaceutical business environment.

  • Created Extensive Stored Procedures and Functions in T-SQL in MS SQL Server 2005

  • Developed numerous reports using SQL Server Reporting Services 2005

  • Developed (ETL) methods using SQL Server Integration Services (SSIS)

  • Data Exporting and ETL through MS Access and SQL Server

  • HIPAA compliance training

Tripleclick Design – Web Developer - Fairlawn, Ohio - 12/04 – 03/06

  • Developed a Web Based Document Management System.

  • Developed product administration system and shopping cart application for e-commerce site using SSL and authorize.net.

  • Setup and Maintained application servers, a development server, and a web server.

  • Developed and administrated MySQL databases for applications and wrote extensive SQL queries.

  • Created PHP modules for Internet Applications (in-house projects and client projects)

  • Created VB.NET interfaces for displaying intranet web applications.

  • Developed ERDs and Project Schedules for several projects.

  • Completed several large team and solo projects.

Center for the Study and Development of Minority Businesses – Web Developer– Kent, Ohio 08/04 - 12/04

  • Website Design- Redesigned the entire web site including graphics and HTML. Implemented custom JavaScript, added DHTML menus, and site-wide CSS.

  • Implemented and designed electronic registration for the Center’s classes. Written in Perl, sends notification via e-mail and records them to XML.

Trispan Corporation – Technology Consultant - New Middletown, Ohio - 09/03 – 12/06

  • Part-Time Technology Consultant and Computer Technician

  • Installation of Network and Data Backup Equipment

Personal Projects:

Memberships:

  • IEEE Computer Society

  • The Data Warehousing Institute (TDWI)

  • Association of Computing Machinery (ACM)