Lore has experience in developing and supporting all the components of a Data Warehouse. Data is extracted from a MySQL operational DB and by scraping other sources such as Google Analytics, Adsense, Webmaster, Apache logs & flat files using Java, Selenium, Perl & PHP and is loaded into an Oracle 10g database using SAP Business Objects Data Integrator (BODI). A logical representation of the data for business analysis is achieved by generating a BO XI R3 Universe. Data presentation is done via SAP Business Objects Web Intelligence reports (WEBI), PDF, Excel & Crystal Reports. Routine operational tasks include monitoring and debugging of daily data warehouse load jobs and generation of daily reports for internal and external users for day-to-day business analysis. Generation of feeds help support other systems and activities. Adhoc analysis is performed to help executives make educated business decisions, resolve puzzles and fine tune operational parameters.