Daniel R. Spohn Address: 1684 Barlow Rd. Hudson, OH 44246 (216) 926-9506 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: http://www.joggermaps.com/ http://www.tsqltutorials.com/ http://freessisdocumenter.com/ http://www.us-city-home.com/ http://www.citystatelocal.us/ Memberships: IEEE Computer Society The Data Warehousing Institute (TDWI) Association of Computing Machinery (ACM)