SOLUTIONS
CONSTRUCTION QUOTER
Project Type: Workflow
Technologies: ASP.Net, Oracle,SQL Server, javascript, css, automated email
System designed to track surveys for new construction.
Changes in survey status triggered email notification to relevant staff.
Automatically downloaded data nightly from an Oracle data warehouse.
Automated rules developed to relegate certain surveys to the backburner.
Provided extensive reporting incorporating drill-down and export to pdf or Excel.
COMMISSIONS
Project Type: Finance
Technologies: ASP.Net, Oracle, SQL Server, javascript, css
Calculated commissions for sales reps based on a compensation plan.
Automatically downloaded sales and other data nightly from a linked Oracle server.
Stored procedure calculated commission pay per period based on manager, rep, or order.
Membership model and screens allowed specialized viewing by administrator,manager, or sales rep.
Single click export of reports to pdf or Excel.
CUSTOM MAILING LISTS
Project Type: Marketing
Technologies: ADO.Net, Oracle,SQL Server
We are adept at handling and manipulating large mailing list datasets and can:
Match leads to existing customers and/or distance to closest plant.
Group leads within buildings or on neighboring streets to determine density and low cost connections.
Append non-standard data points e.g. ethnicity, for language appropriate marketing.
For one Fortune 100 satellite TV provider, we ranked commercial buildings by city for best mix of lowest construction cost and highest likelihood of tenants to become video consumers.