LinkedIN:  

Seasoned BI developer and business analyst with over 10 years of data management experience seeking a challenging contract position at a company that uses analytics to drive strategy.  Specializing in rapid deployment of Data Warehouse solutions, I have a track record of delivering BI solutions on time and under budget, providing significant documentable ROI.  Experienced with full-lifecycle development including  complex SQL development, OLAP development, DBA duties, ETL coding, requirements documentation, data modeling, and report writing.  Reputation for high-quality work, clever solutions, and a commitment to user satisfaction.
 

EXPERIENCE HIGHLIGHTS:

• Automated $20M of TV Media buys with a self-tuning algorithm based on historical performance

• Optimized call center performance via intelligent call routing to most productive employees, accurate call forecasting and staffing, and revision of the employee bonus structure

• Improved interaction strategies by micro-targeting most profitable customers with psychographic data, GIS visualization of potential markets, and site-selection near valuable customer bases

• Improved supply chain & inventory mgmt with Material Resource Planning (MRP) algorithms

• Developed extensive BI solutions for numerous CRM & ERP environments

• Developed algorithms for automated day trading the CME futures market

• Familiar with SEC audits, and FDA regulated change control & documentation

• Experience with P&L, GL (general ledger), revenue forecasting, and GAAP accounting

• Industry experience in Biotech & medical manufacturing, stock market education, chemicals, logistics, mental health & research, and the military

Data Warehouse Manager
BetterTrades (CodeReady Solutions)  -- 11/2008 - 1/2010
BetterTrades (CodeReady Solutions) is the largest stock market education company
Improved TV infomercial performance by developing a system for full automation of a large media budget.  This algorithm was continuously optimized via sourcing calls to aired media and tracking performance thru the customer lifecycle to calculate a granular ROI: resulted in a large credit in the first quarter after implementation.  Improved site selection thru visualization of actual and potential customer bases: incorporated GIS and psychographic data, and designed maps of all major metro areas.  Architected and negotiated an EMC Clariion storage solution to provide high-performance BI, including a continuously updated development environment via SAN replication.  Built and directed a world-class team of ten, including four SQL developers, an OLAP developer, a report writer, two DBAs, a data architect, a GIS specialist, and a TV Media buyer.  

Data Warehouse Manager
Ashworth University – Norcross, GA – 1/2006 – 11/2008
Ashworth is a large distance education provider with Masters, Bachelor, Associates, and GED programs.
Responsible for the development of an enterprise data warehouse across diverse source systems.  Provided strategic insight into line of business profitability with an integrated product level Profit and Loss (P&L) statement, dash-boarding, and KPIs.  Increased outbound telemarketing conversion rates by 45% across 2.5M monthly telemarketing calls by implementing real-time callbacks of leads.  Increased inbound conversion rate by 35% by implementing intelligent Skills Based Routing of calls to best performing reps, and modifying the bonus structure.  Maximized PPC Search, CPL and TV media buy performance through PRIZM and ElementOne psychographic profiling.  Optimized product pricing structure and customer messaging by developing a system for campaign management to include AB splits and holdout groups.  Recommended a price reduction which resulted in an improved retention rate and customer profitability.  Facilitated effective customer interaction strategies with models computing revenue accrual rates over the customer lifecycle.  Developed credit card encryption and decryption stored procedures.  Improved PPC search vendor interaction with automated distribution of XML documents containing key word performance metrics.

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
Imerys is a $3B multi-national chemicals manufacturer and logistics company.
Responsible for the BI infrastructure in roles ranging from Architect to ETL Developer.   System owner and developer of the Corporate Budget and Forecasting application.  Facilitated better sales analytics by distributing personalized OLAP cube slices nightly to 150 regional sales reps, 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. 

Database Administrator
Immucor – Norcross, GA – 9/2000 – 5/2004
Immucor is a $100M manufacturer of blood reagents and robotic testing systems.  
Responsible for all production Oracle and SQL databases.  Developed a corporate warehouse providing insight into the full manufacturing and sales lifecycle.  Reduced material and labor variances by developing Material Resource Planning (MRP) logic to forecast based on customer demand, current Bill of Materials (BOM) subcomponent inventory, and supplier lead times.  Reduced budget variances by providing managers with a secure OLAP tool for reconciliation of their departmental budget and expenses by G/L line item.  Conducted three Enterprise Resource Planning (ERP) implementations of the Baan package in an environment highly regulated by the FDA.  Provided performance tuning, administration, and backup of critical high volume databases. 

Research Coordinator
State of Alaska – Anchorage, AK – 1/1998 – 5/2000
CHD is a state-run mental health institution funded by the US Department of Education.
Developed and managed a patient records database.  Evaluated grant proposals and research outcomes to ensure accuracy in data reporting.  Developed computerized testing tool for diagnosing patient stability.  Supervised three data entry specialists.  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 & CRM Systems -- Baan IVc4, IFS, SalesLogix

Database and Tools --  MSSQL 2008 (SSAS, SSIS, SSRS ) / 2005 / 2000 / 7, MySQL, Oracle 8i / 9i

Languages – PL/SQL, T-SQL, MDX, and XML, Moderate experience with C#, PHP, VB, shell scripts

Psychographics / Demographics --  Clarion PRIZM NE, Targus ElementONE, Geocode tax data

GIS -- ESRI, MapInfo, Manifold, TigerFiles, Census data

Modeling and Statistical Tools – Erwin, Market Miner, SPSS

Reporting – SSRS 2008 / 2005, Crystal Reports / Enterprise / Analysis, Strategy Companion

Call Center -- Noble Maestro, Toshiba Dialer, Cisco, and  Touchstar

OS / Hardware -- Windows Server 2008 / 2003 / 2000 / NT; Basic knowledge of UNIX, Linux,  AS400, SAN (EMC), routing, load balancing, firewalls, and virtualization.

Server Tools – Understanding of server backup applications & strategies, disaster recovery, job scheduling , and automated email distribution & messaging.

Miscellaneous – MS Visio, Project, Lotus Notes, Illustrator, Photoshop, Ableton Live, UPS WorldShip

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