|
INDUSTRY EXPERIENCE
SUMMARY:
Biotech / medical mfg -- 4 years
Chemicals / mining / logistics -- 1 year
Mental health / research -- 2 years
Military -- 2 years
Sports and entertainment -- 1 year
On-line education -- Current
Data Warehouse Manager
CodeReady Solutions -- 11/2008 - Present
Responsible for development of the Enterprise Data Warehouse for Better
Trades, a provider of stock market education, charting products, and data
services.
Data Warehouse Manager
Ashworth University – Norcross, GA – 1/2006 –
11/2008
Responsible for the architecture and
development of the corporate datawarehouse of a large distance
education provider. Provided extensive analytics to help maximize the
broadcast marketing budget through PRIZM and ElementOne psychographic profiling.
Automated lead prioritization, recirculation initiatives and skills based
routing. Implemented a fair incentive program contributing to a 40%
increase in conversion rate of the 70 person call center. Developed
"UnicaLite", a campaign management system to handle the fulfillment of 3M
lead acquisition phone and email
messages per month. Analyzed campaign impact through comparison of
AB splits and holdout groups. Built models to look at revenue
accrual rates over a student lifecycle to facilitate effective customer
interaction strategies. Improved collections effectiveness through
better visibility of account aging and roll rates.
Integrated corporate data assets to provide a product level P&L statement,
providing insight into unprofitable lines of business. Built procedures to
handle credit card encryption and decryption on remote servers. Automated
nightly builds of DW to include hundreds of complex aggregation tables
in a 300M record environment. Build XML documents to distribute key word
performance metrics to our search vendors. Transitioned the company to SQL 2005 Database, OLAP, and Reporting
Services.
SCUBA Divemaster
Blue Marlin – Lombok, Indonesia – 6/2005 – 11/2005
Responsible for the safety and
satisfaction of groups of divers. Experienced in cave diving, technical diving,
and underwater photography. PADI, NACD, and TDI certified.
Data Architect
Imerys – Roswell, GA – 5/2004 – 4/2005
Responsible for the reporting and
warehouse infrastructure of a $3B chemicals company in roles ranging from
Architect to ETL Developer. System owner and developer of the Corporate Budget
and Forecasting application. Facilitated better sales analytics by engineering
the process to distribute personalized cube slices nightly to 150 regional sales
managers via Lotus Notes, allowing users full multi-dimensional analysis from
within Excel while disconnected from the corporate intranet. Provided strategic
guidance for warehouse implementation, development practices, report
distribution methods, performance improvement, and disaster recovery. Developed DTS packages and Oracle stored procs to
extract and conform data from the Oracle OLTP system, staging the data in SQL2000.
Packages contained error-handling, event-notification, cleansing,
cross-matching, and handled complex business rules. Created aggregation
strategies for performance and ease of ad-hoc reporting.
Database Administrator
Immucor
– Norcross, GA – 9/2000 – 5/2004
Responsible for all production
databases of the largest U.S. manufacturer of blood testing products. Developed a corporate
warehouse providing business intelligence for the full manufacturing lifecycle.
Provided performance tuning, administration, and backup of critical high volume
databases. Conducted installations, configurations, upgrades, and migrations of
databases and ERP software. Adhered to stringent U.S. FDA change control and
documentation protocol. Conducted three Enterprise Resource Planning (ERP)
implementations of the Baan package on both Oracle and SQL in an environment
highly regulated by the FDA. Integrated external customer demographic data with
the corporate warehouse, providing better visibility of market share per
vertical. Worked closely with
project stakeholders and business analysts to define goals and objectives
related to BI strategy in the areas of GL, demand planning, bill of materials,
inventory management, budgeting, forecasting, sales channel, logistics, cap-ex,
AR, AP. Developed mining models helping better understand customer
segmentation. Reduced material and labor variances by developed Material
Resource Planning (MRP) logic to more accurately account for customer demand and
current inventory of Bill of Materials (BOM) subcomponents. Provided managers
easy analysis of their departmental budget variances by creating an OLAP tool
for departmental budget and expense reconciliation. Developed
a pager alert system monitoring numerous potential points of failure. Installed
and administered Crystal Enterprise system.
Research Coordinator
State of Alaska – Anchorage, AK – 1/1998 – 5/2000
Developed and managed a patient records database for the Evaluation and Research
division of a state-run mental health institution. Evaluated research funded by
the US Department of Education to ensure accuracy in data reporting. Developed
computerized testing tool for diagnosing patient stability. Supervised three
research assistants and data entry specialists, ultimately responsible for data
quality.
Intelligence Analyst
United States Marine Corps – Virginia Beach, VA – 8/1993 – 12/1995
Operated systems involved in document control, scheduling, and graphical design.
Security Clearance: TOP SECRET (currently inactive)
TECHNICAL
PROFICIENCIES:
ERP Systems
-- Baan IVc4, IFS (Skills translatable to SAP or Peoplesoft)
Database and Tools -- Oracle 8i / 9i, Microsoft SQL 7 / 2000 / 2005,
PL/SQL, T-SQL, Microsoft Analysis Services (OLAP), DTS, SQL Server Integration
Services, Erwin, TOAD, SQL Navigator, PL/SQL Developer, Clarion PRIZM NE, Targus
ElementONE,
Psychographic / Demographic Data, Geocode data for taxation
Modeling and Statistical Tools – Market Miner, SPSS
Languages – PL/SQL, T-SQL, MDX, Basic exposure to C#, VB .NET, VB6
Reporting – SQL Server Reporting Services 2005, Crystal Reports /
Enterprise / Analysis, Access, Safari, APOS
OS / Hardware -- Windows NT/ 2000/
2003; Basic understanding of UNIX
(Solaris), AS400, SAN (EMC)
Server Tools – Understanding of server backup applications & strategies,
automated email distribution & messaging, and job scheduling
Call Center -- Noble DCM, DCR, and Maestro;
Toshiba Dialer
Graphics Tools – Illustrator CS2, Photoshop CS2, ImageReady
Miscellaneous – MS Visio, Lotus Notes, MS Project
EDUCATION:
Microsoft Certified
Database Administrator (MCDBA) – MCP ID# 1874545
Microsoft Certified Systems Engineer (MCSE)
Bachelor of Arts in
Cognitive Psychology
University of Alaska Anchorage, Cumulative GPA 3.88
Emphasis on statistics, research design, and psychometrics
GRE Scores: Quantitative = 790/800, Verbal = 610/800, Analytical = 700/800
|
