(617)383-9241, Quincy, MA

SQL and NoSQL developer, data analysis and reports programmer

    Integrating your data with external sources.

    Developing the right design for your data needs.

    database structure developer.

    Development of functions and Stored Procedures.

    Analyze queries and improve performance.

    Import and export of data, from and to various formats (Excel, CSV, XML, JSON)

    Updates of Catalogs, Inventories, Orders from or to a remote database (EDI, or custom)

    It's common for businesses to use Excel and MS Access and their data repositories. Newer systems are using databases from Oracle (Oracle, MySQL), Microsoft (MS-SQL) and others like PostgreSQL.
    We provide development services and support the use of these repositories.

Recent projects

    Reducing bounce rates for E-Commerce websites.

    Concept and Development of methodologies to mitigate reasons for website bounce rate (leaving the site on same page).

    Python, MSSQL, MySQL - Store Procedures. (execution via Cron/Windows scheduler)

    Product ranking - increasing conversion rate

    Developed an algorithm to rank products, in adherence to a customer search, sales performance and other factors. This functionality was prototyped in Python, works with store procedures.

    Python, ASP, MSSQL - Store Procedures, IIS.

    E-Commerce Automation

    Design and Development of a complete SaaS automation solution providing website owners catalog updates (e.g. import new products, generate product options, prices manipulation, modify product status), inventory updates, site health monitoring, custom code execution, generate export feeds, various email alerts. Works with OSCommerce, Magento and other e-commerce software.

    Python, MySQL, MSSQL (execution via Cron/Windows scheduler).

    Automated upload of Catagories and products.

    Stored procedure based application generating Categories and products for 00,000's of entries for automotive eCommerce site.

    Python, MySQL.

    Mobile eCommerce checkout process

    Enhancement to existing shopping cart to support mobile devices users make a checkout with their device.

    Sale Management for mobile (IPad/Android) devices

    Development of an application for sale management allowing the sales person conduct sales when online and off-line. The same application works on different devices.

    Python, kivy, JSON, sqlite.

    Discount management.

    Developed enhancements to shopping cart discount coupons mechanism to easily produce large amount of unique discount codes (for sites working with coupon sites), manage the usage of these code, and monitor performance and reports.

    ASP, MSSQL, IIS

    Returns (Product returns) Management.

    Developed a product return back-end system to manage the returns from customers, manage returns to supplier/brand including automated RMA requests, email notifications, inventory changes, financial updates and more.

    ASP, MSSQL, IIS

    Brand content in multi-brand environment.

    For a site selling +100 brands, developed a brand content information module where brands can create content, approval work-flow by the site managers, and publication. Including back and front end.

    ASP, Python, MSSQL, JavaScript, IIS

    Search / Thematic pages. Concept and Development of a methodology to automate product grouped pages base on characteristics, and creation of search phrases (keywords) to increase organic search results. Accounts for 40% traffic increase with some sites. Python, MySQL, SQL Server, Linux. (execution via Cron/Windows scheduler)

    Cart abandon solution - Amazon AWS based application.

    Creation and deployment of a cart abandon email solution generating alerts for shop owners, email follow-up to customers, statistic pages generation.

    Python, MySQL, SQL Server, Linux, Windows (execution via Cron/Windows scheduler)

    Bronto (email marketing) integration.

    A complete replacement of a shopping cart application email mechanism and integrating all email events with Bronto. Creation of queue mechanism, error handling, populating contacts and alert mechanism.

    Python, MySQL, SQL Server, Web Services, Windows (execution via Windows scheduler)

    Web application.

    Create a new web application covering purchasing process from generating a purchase request, through managers approvals, orders, receiving, invoicing, accounting and payment. Combination of web and application servers, utilization of background processing.

    PHP, Python, MongoDB.

    Integration with external review services

    Call external review services and populate feedback on product pages

    ASP, Web services.

    Psychology Experiment applications

    Modification and creation of experiments, utilizing game technology to record and measure subject responses and choices.

    Python (PyGame), multi-platform.

aq