Abstract: A multi-window time-aware personalized recommendation system and method is provided. The system includes a memory having computer-readable instructions stored therein. The system further includes a processor configured to access purchase history of one or more users and to select a pair of items purchased by the one or more users based on the purchase history. The processor is further configured to determine a contributory affinity value between a first item and a second item of the selected pair of items for each of the one or more users. The contributory affinity value is determined based on a first time-decay function and a second time-decay function associated with purchase times of the first and second items. In addition, the processor is configured to combine the contributory affinity values for each of the one or more users to estimate the affinity value between the first and second item across multiple time-windows.

Abstract: An ETL system for extracting transactional data from a plurality of source machines is provided. The ETL system includes a data query module configured to provide an interface to enable a data analyst to define an input query to extract transactional data, which is present on a plurality of source machines. The source machines form a multi-tenant system and each source machine is identified by a unique tenant identifier. The system also includes a query parsing module coupled to the data query module and configured to deconstruct the input query to create a tree structure. The tree structure comprises a plurality of distinct queries. The system further includes a data extraction module coupled to the query parsing module and configured to extract transactional data based on the distinct queries and copy the transactional data to a destination system wherein the transactional data comprises a plurality of data types.

Abstract: A report generation system is provided. The system includes a database configured to store customer data and transactional data for a plurality of customers of a client. The report generation system also includes a query generator accessible by an analyst to define one or more report queries using a plurality of input variables. The query generator is configured to deconstruct the one or more report queries to create a query tree structure. The query tree structure includes a plurality of distinct report queries. The report generation system further includes a report processor configured to process the customer data and the transactional data based on the plurality of distinct report queries and values of input variables to generate one or more reports with output data. The report processor includes a report design module accessible by the analyst to define a plurality of data visualization formats.

Abstract: An ETL system for extracting transactional data from a plurality of source machines is provided. The ETL system includes a data query module configured to provide an interface to enable a data analyst to define an input query to extract transactional data, which is present on a plurality of source machines. The source machines form a multi-tenant system and each source machine is identified by a unique tenant identifier. The system also includes a query parsing module coupled to the data query module and configured to deconstruct the input query to create a tree structure. The tree structure comprises a plurality of distinct queries. The system further includes a data extraction module coupled to the query parsing module and configured to extract transactional data based on the distinct queries and copy the transactional data to a destination system wherein the transactional data comprises a plurality of data types.