sales@appliedalgo.com, support@appliedalgo.com
.

Applied Algo ETL Suite
  = Quant Platform (From Financial Derivatives pricing, Program Trading to Supply Chain Demand/Sales forecast)
    = Scheduler ("Batch Processing", "Workload Automation")
      + Load Balancer ("Grid Computing")
        + Built-in ETL (SQL, FTP|NTFS - csv|xls|xlsx, OS commands ...)
          + Built-in Audit (Change Management & Security)

If you do a lot of number crunching, We're in the bussiness to Make Life a Lot Simpler for you!
.
Every noteworthy provider support Job Scheduling, Job Chaining and Grid Computing. Among others, one feature that set us apart is that JobController automatically persist Execution Result, whether it's a port scan, or result from a Time Series Analysis on a Portfolio Rebalancing platform. Data table is Automatically Created and Versioned, with column types either inferred from actual data or from schedule configuration.
We've bundled multitude of ETL services with Applied Algo ETL Suite. For instance, user may schedule inbound/outbound FTP file transfer with JobControlller. JobController automatically audit file md5 signature, timestamps, and in addition, content of any csv|xls|xlsx file sent or received (Optional). Regular Expressions filtering with Recursive directory searches, optional purging after transfers, optional directory flattenning are among the many options we have provided for to help developers not having to re-write, or hardcode, common transfer and persistence|auditing logic.
Further, you can plugin computation coded in almost any language - No Integration Headache! (Samples bundled in unmanaged C++/Java/.NET/Excel-VBA).
Simplicity, Stability and Scalability: Applied Algo ETL Suite is a platform that actually works for you, not vice versa. Let your developers focus on Core Analysis and Deliveries. Leave Platform and Infrastructure Plumbing to us.
Contact sales@appliedalgo.com, we'll get the package setup/demo from your desk in minutes over Skype+Remote Desktop. We'll gladly provide assistance to get you started quickly, No consultation fee. You may then make your evaluation.
Job Controller
Simplicity - Have a look at our demo video. You can compare setup with, for example, Hadoop installation process. With Applied Algo, everything is Embedded: GUI, Database and web servers. No separate install. It's completely Standalone application you can even run from your desktop - Except the nodes of course.
.
Automatic Persistence - persistence/data table created and versioned automatically. No hard coded logic to save parameters/results.
.
Data Dictionary - Import data columns/types are persisted for later reviews/comparisons. For imported files, column types are automatically inferred.
.
No Integration Headache - Extension API is designed with Simplicity & Adapability as primary design objective, exposed via WCF (Web Service) and RabbitMQ. User may plugin computation of their own coded in practically any programming language. Worked samples bundled coded in unmanaged C++/Java/.NET/Excel-VBA. We've worked it all out for you.
.
Grid Computing: Multi-metric Load Balancing with Throttling and User Overrides: CPU/Memory/Disk Queue/Round-robin. Supports Node Affinity/Group to route similar jobs to appropriate node groups.
.
Per-cell/row Validation - user may configure desired data type, numeric range, even Regular Expression for each column.
.
Built-in ETL - Integrate data from: local folder/shares, FTP/SFTP, HTTP, SQL (Microsoft SQL server, Firebird, ODBC - MySQL). File types: csv/xlsx/xls
.
Audit any File Sent/Received - With built-in FTP/NTFS commands, any you sent/received are automatically audited: timestamp, size, md5 signature, and optionally file content (xls/xlsx/csv only)
.
Audit any SQL or bat script executed - not just name of SQL/bat script, but actual content executed.
.
Parameter Rendering - Example 1. "$T-1$" is rendered to 'yesterday'. Example 2. "$SWEEP|0.1-0.3|0.05$" will spawn 5 executions from 0.1 to 0.3 on 0.05 increments. Pre-rendered/Rendered parameters can be persisted on per Execution basis for tracking purposes
.
Enterprise Job Scheduling (Workflow Automation) - Recurring every sec/minute/hour/day/week/month/quarter...etc. Optional Skip Weekend and/or holiday. Parent-Child schedule relationship (Job Chaining), with conditional execution criteria.
.
Web Interface - Review execution status while you're away from your desk (Read-only/Supports Https/Embedded Web Server). Responsive Layout, fit nicely on Desktop + Mobile Devices
.
HttpCmd - Fetches data from Internet. Ability to replay Fiddler session (saz).
.
PlatformAuditProbe - Windows (64bit Windows 7 or above) Forensic Toolkit: Running Processes w/port#, arp, route print, open files handles, logon sessions, scan registry/drivers/scheduled tasks, Event Log, Recycle Bin, Browser History (Chrome/Firefox/IE), user/group list, folders/files scan (Please refer to "AppliedAlgo PlatformAuditProbe Guide" under "Documentation" tab)
.

Data Explorer
Per Cell Comparison - Unlike Winmerge, Data Explorer compare data on left grid against data on right grid Cell-by-Cell
.
Composite PrimaryKey - User may specify single/composite Primary Key(s) which is used in matching corresponding rows from left/right data tables.
.
Single/Multiple Comparison Target Column - User may specify single/multiple data column(s) as Comparison Target
.
Multiple Data Sources - (a) JobController Cache Database, (b) other database (Firebird, Microsoft SQL, ODBC - My SQL), (c) flat file (csv, xlsx, xls)
.
Execution Parameters, Data Dictionary, and Actual Processed Result - All accessible from Data Explorer
.
Feature Comparison with Commercial & Open Source Alternatives
Limitation 1: JobController/DataExplorer/NodeController runs only on x64 Windows 7 or later. Because NodeController don't run on any other platform, Scheduling/Load Balancing support only available to Extension Commands running on x64 Windows.
This said, Extension Commands is still accessible from Linux/Unix box over WCF/RabbitMQ.
.
Limitation 2: JobController's embedded Firebird database (CACHING.FDB, Max size subject to Operating System Limitation: Windows NTFS, max=16 Exbibyte (EiB) - http://www.firebirdfaq.org/faq59/) - This said, you probably don't want to persist 16 EiB of data in one database file, on one disk, in a single machine. JobController is responsible for persisting/distributing processed data (When Data Explorer/Extension Commands request it).
Users are advised to enable Automatic Purging to keep JobController's embedded database size in check. If necessary, use a third party tool to roll over data from JobController embedded database (Caching.FDB) to another location for permanent archiving.
.
In event that you're registering a lot of Disk IO, confirm whether or not Performance Bottleneck is coming from database tier (JobController's embedded Firebird database). Or if Disk Activity is coming from another application? If, indeed, disk activity is coming from JobController's caching/fetching operations, here're couple options: Install Multiple JobController instances on multiple physical machines, Exteneral Commands to source from External Database Cluster, faster disk: SAN. Bear in mind that Distributed Persistence is not a Product Feature that Applied Algo ETL Suite offers.

Quant Platform

Information System Change Management and Security Auditors

Harvesting Free Data from Internet

Getting Started is a Breeze: Installation and Rundown - Contact sales@appliedalgo.com, we'll get the package setup/demo from your desk in minutes over Skype+Remote Desktop. We'll gladly provide assistance to get you started quickly, No consultation fee. You may then make your evaluation.

Illustration of JobController Load Balancing capability, and how it's different from "Windows Tasks Scheduler"

Automatic Persistence w/Versionning (Data Table automatically created for you) with Versioning (In event of schema change)

CellValidation using SQLCmd: 1. ColValidator (Regular Expression + Predefined Validation Expressions), 2. ColTypeValidator/ColRangeValidator (Numeric Range Validation)

Please also set before execution: 1. PercentWarningBeforeFlaggingException to a loser threshold, 2. ApplyTransformation = true (Validation is part of "Transformation")

JobController Scheduling Parent-Child & Auto-Retry

Change Management - SQLCmd to detect database changes

Reconciliation using Data Explorer - csv file on left grid, xlsx on right grid

Embedded Web Interface (Read only) - No separate installation/embedded in JobController. Content wraps around nicely when user adjust browser/screen width. Fits nicely on Mobile Devices!

FTPCmd - RecursiveGet with Regular Expression Filtering. User may preview files to be downloaded from NTFS/FTP Previewer. The video further illustrates auditing capabilities offerred - from file content to file md5 signatures/timestamps/owner... etc

HttpCmd basic - download HSI constituents and last trade prices from Yahoo Finance

SplitColumnCmd - Split "Change" column into "Change" and "Percent Change"

TransformColumnCmd - convert Yahoo Ticker "0001.HK" to Bloomberg Ticker "1:HK"

HttpMasterListCrawlerCmd - Demonstrates how to download from http://finance.yahoo.com/q?s=$SYMBOL$ for each HSI constituents their cross sectional data (EPS/PE/DPS...etc)

.
Applied Algo ETL Suite, Full Commercial License
License Fee: USD 1250 (Per Instance)
.
Expiry: N/A, perpetual
.
Applied Algo ETL Suite include: JobController (Single Instance, Includes Builtin-ETL & Change/Security Scanning Utilities), DataExplorer (Single Instance), NodeController, PlatformAuditProbe - Everything you need to setup your Workflow Automation and Computing Grid all bundled in one package.
MaxNodes = 10 (Max # nodes connected to JobController), MaxSchedules = 500 (Max # Schedules loaded in Single JobController instance) - Additional package of (10 nodes+500 schedules): USD1250
.
Volume discount available. Special discount will also be available to ISV (Independent Software Vendors) who are bundling our products with their own.
.
Migration-integration-customization/Onsite support arrangements welcomed, but fees is to be discussed on case-by-case basis.
.
Contact sales@appliedalgo.com, we'll get the package setup/demo from your desk in minutes over Skype+Remote Desktop. We'll gladly provide assistance to get you started quickly, No consultation fee. You may then make your evaluation.

Following topology shows one instance of JobController running, and five instances of Data Explorer referencing the one JobController instance.
In this case, you will need 1 license of Applied Algo ETL Suite (Include one Data Explorer license), and four licenses of Data Explorer.
Maximum # NodeControllers which can connect to a JobController instance depends on MaxNodes.
Maximum # Schedules a JobController instance will host depends on MaxSchedules.
.
Applied Algo ETL Suite, Academic
License Fee: USD 175 (Per Instance)
.
Expiry: N/A, perpetual
.
Applied Algo ETL Suite included: JobController (Single Instance), DataExplorer (Single Instance), NodeController, PlatformAuditProbe - Everything you need to setup your Workflow Automation and Computing Grid all bundled in one package.
MaxNodes = 5, MaxSchedules = 250 - Additional package of 5 nodes+250 schedules: USD175
Scan of valid student/Staff ID required (Up to one year after graduation).
.
Data Explorer (Commercial or Academic)
License Fee: USD 250 (Per Instance)
.
Expiry: N/A, perpetual
.
Single license for Data Explorer on any one machine is bundled with Applied Algo ETL Suite. Purchase additional license if you need to install Data Explorer on multiple machines.
.
Charity
License Fee: Free
.
Expiry: Perpetual
.
Whether your charge is to help educate unprivileged kids or under-funded medical research, we'd be happy to help.
Convince us, that what you're doing is non-profit, and is for betterment of all of us.
.
Evaluation
License Fee: Free
.
Expiry: 30 Days
.
Bundled MaxNodes = 4, MaxSchedules = 100
.
Upon expiry, you'd still be able to launch the application, but many functions will be disabled behind the scene
JobController/DataExplorer and NodeController only runs on 64bit Windows 7 or above only. Extension Commands, user defined computations, can be either x86 or x64. Free 30 days Evaluation License for Applied Algo ETL Suite will be sent to your mailbox upon registration. You may also download from here Documentation package, PlatformAuditProbe (Free commandline Windows Forensic Utility, 64bit Windows 7 or above) and RecursiveCopyFilesAndFolder (Free). To purchase Applied Algo ETL Suite, please click "Buy Now" button. Do include "HardwareId" (From application's "Licensing" tab) in your order submission. Detail installation instructions in "AppliedAlgo ETL Setup and Installation Guide".
.
First Name *
.
Last Name *
.
Email Address *
.

Installation/Setup

JobController

Extension API

DataExplorer

PlatformAuditProbe (Free)

ODBC Configuration

.
Developer Advocates
Your Role: You will be responsible for identifying sales opportunities with clients and prospects, to achieve sales and other target(s), maintain and further improve service standards to clients, as well as expand the company’s share of market in existing distribution network and identify new clients with strong growth potential. To do this, you must be a Developer at some point of your career. You need to be well connected, and you probably need to come from a background in relevant business, Quantitative Finance for instance. We pay those who deliver.
.
Renumeration: Primarily Commission based.
.
Contact: hr@appliedalgo.com