David Hillesland,MCTS
Results Driven Business Intelligence
abmqf1@r.postjobfree.com
Cleveland, OH www.linkedin.com/in/davidhillesland
Business Intelligence Designer/Developer with expertise in dimensional
analysis, OLAP Analysis and Dashboard development. Favors a find the
synergy approach to Enterprise wide strategic business process engineering
utilizing the Microsoft Business Intelligence Suite of technologies.
Technical Proficiencies
SQL Server 2005, 2008 Integration Services (SSIS) for ETL/ SQL Server 2005,
2008 Analysis Services (SSAS) for OLAP / SQL Server 2005 Reporting Services
(SSMS) / Microsoft Office SharePoint Server 2007 (MOSS)/ PerformancePoint
Server for KPI / Scorecards / Dashboard / Microsoft Office (MSO) / MS SQL
Server 2005/2008 Business Intelligence Development (BIDS) / Windows / DOS /
NT / Win2000 / Windows XP / Vista / WinServer2003 / Active Directory / IIS
/ Novell / SQLServer2000 / Kofax Ascent / Optical / Microfilm storage
systems / Centura SQL / SCSI / Outlook / FoxPro / Dbase / Access / Word /
Excel / PowerPoint / Project / Visio / ACT / LaserFiche / FTP /
TCP/IP/Toad/Oracle
SetFocus, LLC. Parsippany, NJ
2008
MASTER'S PROGRAM - BUSINESS INTELLIGENCE
. BI - Implemented a Labor Analysis Business Intelligence solution for a
fictitious national construction company.
. ETL - Existing data from diverse data sources were consolidated into a
uniform SQL Server 2005 database. SQL Server Integration Services was
used to define imports of the data, transform the data (cleaning),
build scheduling packages, to define integration flow, log data error
exceptions and orphaned data and to define Database Maintenance Plans
and send ETL progress emails.
. OLAP - Created multiple cubes, dimensions and business critical KPIs
using SQL Server Analysis Services representing aggregations in
several different ways - hierarchically and using custom groupings
that the company will use to analyze performance. Created several MDX
queries according to business requirements.
. SSRS - Developed several detail and summary reports including line and
pie charts, trend analysis reports and sub-reports according to
business requirements using SQL Server Reporting Services.
. MOSS - Implemented business intelligence dashboards using MOSS 2007
Report Center and Excel Services producing different summary results
based on user view and role membership.
. MSPPS - Created scorecards complete with executive summary dashboards
using MS Office Performance Point Server 2007 Dashboard Designer that
display performance monitoring measures for sales, sales trends, and
book return rates for a fictitious book publisher deriving data from a
SQL Server 2005 OLAP data source and deployed them to SharePoint
sites. The dashboards also contain drill-down capabilities to view
book sales by book category and customer, through summary reports and
sales trend charts.
. MSO - Created score cards with advanced set of dashboards using MS
Office Performance Point Server 2007 Dashboard Designer that feature
executive summary measures for revenue, overhead costs, material
purchases, labor and profitability trends for a fictitious
construction company extracting data from a SQL Server 2005 OLAP data
source and deployed them to SharePoint sites. The dashboards also
contain pages to view performance by employee, by region, and by
quarter enabling end-users to make filter selections.
PROFESSIONAL EXPERIENCE HIGHLIGHTS
Cuyahoga Community College Cleveland, OH
2008-
Business Intelligence Developer - inheriting responsibility for College
wide project.
. BI - Interviewed stakeholders to evaluate technical execution of
business rules. Correlated results into fresh Dimensional Analysis.
. BI - Comparison analysis to original Business Rule analysis presented
to stakeholders and executive management.
. ETL - Developed 40 ETL packages (SSIS) to systematically validate
accuracy of data warehouse compared to primary source (Oracle).
. OLAP - Built 15 multi-dimensional cubes from schemas stored in data
warehouse.
. OLAP - Wrote MDX scripts leading to creation of KPIs for use in
scorecards and Dashboards.
. SSRS - Added to standard reports. Advised on reporting structure and
inter-relationship of reporting, analysis, and portal presentation.
. Evangelized solution to realize original design goals including;
o One Version of the Truth
o Data Driven Decision Making.
HILLTEC SYSTEMS SERVICES Chicago, IL
2002-2008
Consultant (Selected Projects)
BUSINESS DEVELOPMENT - Successfully initialized, established and grew
PenDrive LLC. Created strategic infrastructure to launch technical
product line distribution including business plan, incorporation,
corporate strategy, process documentation, accounting procedures, web
site design, client presentations, pricing structure, and sales
strategy.
CHANNEL MANAGEMENT - Established $16MM dealer channel for Document
Management/Workflow product line. Mentored 166 account representatives
and sales managers in Document Management Solutions Development and
relationship management.
EASTMAN KODAK (BELL & HOWELL Imaging Solutions Division) 1992-2002
Chicago, IL
APPLICATIONS ENGINEER (1997-2002)
Achieved $8MM to $12MM estimated annual sales revenue as instrumental team
member, delivering IT solutions to meet business document management needs.
DATABASE
. Naviquest Development Team - Business Intelligence functional role.
Responsibilities within the project team included: Managing the IIS
server, SQLserver Administration, Database Analysis, QA lead,
oversight on product documentation writer and consultation on business
user solution requirements.
. Hands on SQL dba experience was augmented during the process of
becoming systems engineering expert on the new product. Used SQLscript
to manage MSSQL 2000 database schema, generated Erwin script files,
verifying, and editing prior to creating and deploying new
applications.
. Traveled to client site to troubleshoot and resolve lock-up issues.
Using strong SQL troubleshooting skills, determined root cause of
metadata corruption within the SQLbase engine. Results:
reinstallation of SQL2000, the Naviquest(beta) application and
verifying correct metadata loading.
. Developed database schemas, performed data conversions (ETL), and
prepared report templates.
. Provided business and technical insights gained from database work
connected with installation, configuration, integration, training and
technical support experiences.
PROFESSIONAL EXPERIENCE HIGHLIGHTS continued
APPLICATIONS PRESALE
. Worked with up to 15 account managers, nation wide. Played integral
role in sales process - strategizing with representatives, preparing
proposal packages
INSTALLATION & TRAINING
. Installed, integrated, configured, network and standalone document
management systems at 150 national and international locations. Used
relationship management and technical expertise to create successful
product adoption.
. Sites ranged from insurance companies (claims handling) to municipal
police departments (traffic tickets/accident reports) to healthcare
facilities (medical records units) to the federal government (EEOC),
and the military (integrating mainframe to populate database for
supply function audits).
SYSTEMS SUPPORT ENGINEER (1992-1997)
Department earned $5-$7MM support revenue per year. Performed technical
support for databases, systems, networking and reports, working the queue
and interfacing directly with customer and development staff on reports of
bugs, fixes, upgrades, database conversions, and troubleshooting of
archiving products, computer systems, databases and networking technologies
(LAN/WAN).
. DATABASE - Developed complex query scripts to create tables, indexes,
establish table relationships, stored procedures, and develop
formatted reports. SQLtalk scripting, SQL database operations, and
Windows server tools were the primary customer support tools. SQL
used on a daily basis to discover and resolve technical, operational
and ETL issues.
. LAN/WAN ADMINISTRATION - Exercised initiative in assuming LAN
administration for department concurrent with other roles and duties;
capitalized on Novell CNE status to maintain integrity of Windows
network and mentor promising technical staff.
. INTEGRATION - Resolved configuration and integration issues,
connecting product support to SCSI devices, network interface
(including Novell to NT), Optical jukeboxes, and hardware RAID (cat
5).
Education, Certifications, Environments and Packages
Bachelor of Science -Economics / Accounting / Finance Iowa State
University, Ames, Iowa
A+, MCP, CDIA+, MCTS(BI)