|
Overview – Skills/Software
|
SQL Server 2000 – 2005
|
C/C++/C#
|
Dreamweaver
|
ErWin
|
|
.Net/ASP
|
SYBASE
|
PHP
|
PowerDesigner
|
|
XML
ETL Development
|
SQL Anywhere
COM
|
HTML
Oracle
|
Intel, Motorola & Zilog Assemblers
System Architecture
|
|
MS SSIS and DTS
|
DCOM
|
Visual FoxPro
|
Data Modeling
|
Industries
|
Publishing
|
Credit Card Processing
|
Fixed Income
|
Billing
|
|
Hotels
|
Bankruptcy Funds
|
Real Estate
|
Invoicing
|
|
Insurance
|
Tobacco
|
Sales Prospecting
|
Collections
|
|
Grants Management
|
Broadcasting
|
Construction & Architecture
|
Data Warehousing
|
Languages
Mother Tongues: English, French, and Italian - Written and Spoken Fluently
Understanding of: German, Spanish
Experience
ELAG Inc. LTD 2002 to Present - Lead Developer Analyst – SQL Server 2000-2019, MySQL 5.1, XML, C/C++, Visual FoxPro, Android/Java/XML/Eclipse
Work for ELAG Inc. included direct work with the following clients/partners:
Insurity, Hartford CT (remote) 2020-2022
Began Design, SQL Server Data Model and Visual C# MDI interface for cross-product Data Dictionary for this insurance-only software company. Fixed numerous issues in Workers Comp legacy system and Claims legacy system in client VPN and Insurity VPN. Wrote speedy SQL Server DB comparison tool.
New Note 2021: Minibars returning on line slowly.
Editor's note 2020: Kimpton and Hyatt are discontinuing all minibars as a result of SARS-COV-2
Current: Club Minibar Hotel Minibar Inventory, Sales, Order Processing & automated Purchase Order Generation & Invoice Reconciliation, Room Check Application. Server: MS SQL Server. Client: Java Android 4 & 5, Google Nexus 7, Samsung Galaxy, ASUS, Amazon Fire. 110+ Remote tablets in 50+ Hotels with Android applications performing daily room checks , storing day data cumulatively and transmitting when WiFi is available trickling transactions to/from SQL Server DIRECTLY. Inventory control from said devices every 2 weeks, order processing as restocking is received – back end calculates & generates orders based on sales history/forecasts/projected growth. Larger-scale back-end Windows Application (both across the ecosystem and Hotel by Hotel) performs all management and executive reporting functions.
Argo Partners (3/2004 - 2019) - All-in-one solution for private fund dealing exclusively in bankruptcy. Solution included call tracking, buy/sell tracking, competitive bidding, automated mailing, faxing and emailing via Word/Outlook/Net Satisfaxion, and dynamic financial reporting. Recent large scale enhancement allows non-technical users to create their own database-active HTML form letters, which are, in turn, sent over Outlook at a rate of 800 / minute. This small business-wide turnkey application has now cycled through 200+ in a dozen years without the necessity for formal training, and has NEVER BEEN DOWN for more than 5 minutes (or the time it takes to reboot), and even that not in this decade (I think.)
2014: Electricite de France – Renewable Energy – MS SQL Server 2008 Integration Project involving the aggregation of Wind Turbine data, forecasting data, and power market pricing data.
2011 AllSportsAccessories.com – SQL Server back end, windows admin application communicating with and backing the ZenCart eCommerce platform.
2010-2011 Fulpac, Inc. Inventory Management, Order Entry, Logistics. End to end turnkey system for a fulfillment & packing operation.
2011 HRT – Prior work in neurophysiology and thermodynamics has come in useful for this audio processing-related embedded C work. This includes audio file format conversion, audio lossless compression, filters, polynomial interpolation. Under NDA.
Source Media – Accuity (Formerly Thomson Media and Thomson Financial Publishing) - Architect and developer Galitool Data Warehouse and mining tool, which drew from 7 legacy business systems, reformatted data using ETL system which I developed and fed into a common operational data store I developed as well as third party CRM systems. This tool also included WYSIWYG invoicing from one common data store from orders entered into multiple independent systems. Other features included real-time aging, customer de-duping, automated shipping, centralized financial reporting, unapplied cash and refund management, and marketing list generation. All these features I designed and developed. Among the legacy packages interfaced were Neasi-Weber Admarc, DSI Mutipub, AIT Memex, Epicor Clientele, Microsoft CRM, Great Plains .
In general terms, responsible for the aggregation of 4 or five business units and their core business systems (billing, CRM, etc.). This involved understanding often abstruse, denormalized, mainframe-era models, and creating models that amount to conversion stages so that not only was the flow of data towards the center smooth, but we could decide to keep certain legacy systems alive indefinitely, while still drawing up-to-date transactions, in some cases every 15 minutes. Modeled entirely in PowerDesigner.
Argo Partners - All-in-one solution for private fund dealing exclusively in bankruptcy. Solution included call tracking, buy/sell tracking, competitive bidding, automated mailing, faxing and emailing via Word, and dynamic financial reporting.
This turnkey system was modeled and built from the ground up in 3 weeks.
International Rett Syndrome Foundation - Grant Management & Tracking
Nyc.com – full-featured real estate web site (not unlike Trulia.com, but before it) developed in ASP.NET/C# and SQL Server 2005.
Planroom Pro – Document tracking hosted site for Architects, facilities managers and General Contractors
InDemand (Pay-per-View) - 2001-2002 - MS SQL Server 2000, SYBASE ASA 6, VFP6
Project Leader for Direct Billing/Video-On-Demand Project. This project re-engineered the way iNDEMAND does business. This involved evaluating and redesigning accounting systems in conjuction with the CFO (from local cable affiliates nationwide self-reporting sales on an honesty system to a direct billing system based on actual sales). The project also created a business-wide logical model (in powerdesigner) and implemented a 'RAD' Object-Oriented Client Framework the aim of which was to remove most programming from the process of building thin clients, and trained Xbase programmers to work with Client/Server technology and Object Orientation. I also wrote an RFP to attract a potential Clearinghouse/trading partner.
I also designed and implemented the engine responsible for Deals and Royalty Accounting. These contracts have an almost limitless set of possible sub-clauses and calculation methods.
Thomson Financial/The Bond Buyer -April 1999 to Jan 2000- ORACLE 7.3, SYBASE ASA 6, VB6, VFP6
Analyzed, designed, developed and implemented the Bond Buyer 40, the Municipal Bond Futures Index. This includes remote data collection from area brokers, Bond Coupon Conversion Factor and Yield calculations on the fly, as well as Active X/OLE Automation to feed formatted statistical tables to the newspaper (via Word), to the paper's Web Site, and the News Wire, Automatic FTP and Email to clients. Followed up with three systems devoted to publishing: An Editorial/Prepress job tracking system which allows news staff to track publication pages as they are sent to, and return from, prepress; a buyer's guide/directory generation system, and an editorial system dedicated to automated Bond Redemption Notice generation.
Philip Morris Intl Programmer /Analyst,- Jan 1999 to March 1999 - SYBASE 11,VB5, Unix
LEMB, A Financial Systems Dept. Large-Scale Data Warehouse which handles worldwide Income Statements, Balance Sheets, and Variance Analysis. The GUI is entirely data-driven, and tasks include new requirements and maintenance to existing code for both the GUI (VB5) and SYBASE procedure and triggers. ERWin Data Model, multi-application and multi-database dependence.
Intercontinental Hotels Prog/Analyst, Reservations - May 98 to December 98 - SQLServer , VB5
Responsible for finishing development and design of the Reservations Client System in Visual Basic 5 for Win95/NT, to be installed at all Intercontinental Hotel locations and reservations offices. A worldwide, transaction-intensive platform based on a C/Stratus back end with SQL Server reporting, this assignment provided valuable experience with, among other things, optimizing a very large VB5 Client to run in
real-time on a Pentium 60 / 16MB platform.
Philip Morris International - Switzerland , Year 2000 Analyst - February 1997 to January 1998 -Y2K
Responsible for analysis & renovation of Visual FoxPro, Foxpro and C/C++ systems. Wrote an interactive Y2K Scanning/Editing tool in VFP 5/ SQL Server. Is used by PM regional Offices. Also responsible for in-depth analysis of VFP, Fox, and C/C++ in terms of Y2K compliance. Deliverables were extensive documents outlining testing procedures, compliant functionality, non-compliant functionality, and possible Y2K renovation approaches.
Pitney Bowes, Programmer/Analyst - November 1996-February 1997 - C/C++
For a large logistics facility, involved in the conversion of 'carrier' (i.e., trucking company) rate data into a common internal format. This is achieved via several key programs, command-line and GUI C programs and DLLs. New functionality must constantly be added, and the idea is to reunite all these disparate processes under one shell.
Hartford Structures, Consultant/Partner - January 1996-November 1996 - C/C++, Visual Foxpro 5
Developed Construction Project Management System to run under Win32s, Win95, NT, for possible future market release. Developed in Visual FoxPro, Watcom C/C++, SQL Anywhere and Power++. Use of OCXs and OLE linking to all MS Office products.
GE Electrical Distribution & Control - Programmer /Analyst - July 1995 - December 1995 - C/Clipper
Responsible for updates to a configuration/order system. The software handles all the engineering, sizing, CAD, and costing/pricing logic for all GE large-scale electrical systems. Brought in to provide new functionality and to strengthen some of the weaker links in this very large- scale project. The software was originally developed in C, Clipper, and CodeBase, and was being ported to Windows, Visual C++/SQL Server.
Independent Consultant – Mostly Geneva
Union Bank of Finland , Skandinaviska Enskilda Banken - Programmer/Analyst – C/Foxpro
Designed and developed Bank Netting System for Windows. The system reconciled financial transactions in multiple currencies between multiple divisions of a corporation or other entity. Prototype in Foxpro for Windows and Visual C++ system in Foxpro for Windows
For an Independent Trader - VB3 / C
Rebuild of COMPASS Currency Trading System in Windows, to predict movements of Dollar Mark and Yen with respect to each other. Prototype in VB and initial application in Visual C++.
UNHCR - High Commissioner for Refugees - Foxpro
Developed Disbursements Module for monitoring and tracking payments to refugees in CEERICS, the Registration System for the UN High Commission for Refugees.
NatSoft SA, Geneva
Nestle Corp - 1993-94 - Foxpro
Developed and maintained IMSP, Nestle Corp.'s very large-scale supply planning logistics system in FoxPro for DOS. The system was responsible for deployment and load planning of Nestle products across greater Europe , from all of its production facilities to its warehouses. Inventory Management, Sales Forecasts, Net requirements, Product pallet sizing, custom non-linear calendars were all involved.
World Health Organization - 1994-95 - Foxpro
Appointed facilitator to UN conference on Water and Sanitation in Benin , Africa . Responsible for developing an MIS strategy for sanitation and consequently advising local directorates, as well as setting them up physically in the subsequent weeks. Various FoxPro Statistical/Monitoring Projects, both in DOS and Windows, all designed to monitor Water and Sanitation Quality around the world. One of these specially developed for the Gaza strip was installed and modified on site in Palestine .
Philip Morris International, Switzerland - 1994 - Foxpro/C/Assembler
Analyzed, designed, and developed the Philip Morris EEMA Headquarters Administration system. The system was networked to 880 employees across 4 buildings and managed everything from telephone billing/directory to car pools and distributed publications. Developed in Foxpro for Windows 2.6/GENSCRNX + Assembler program and TSR to automate the download of information from Telephone PBX.
Federal Government of Switzerland - Office of Statistics - 1994 - VB3/Ingres/C
Developed BESTA Statistical Questionnaire Imaging System. This system collected and managed a long questionnaire filled out by all businesses in the country. Front-end VB 3.0, Image Scanning in C, database Ingres on UNIX, but PCs were also on LAN Manager.
Independent Consultant , Hartford , CT 1992 - 1993
MEPSCO Refrigeration - Software Engineer - 1992-1993 - C/Assembler
Developed a supermarket thermodynamic and electrical control system for MEPSCO (ME). The system had a Z80 Assembly back end which ran all refrigeration and electrical systems in supermarkets, 24 hours a day, linked via modem to a GUI front end in C which received alarms and monitored/calibrated system behavior. The protocol between the two was also developed in-house, and Z80 back end was eventually ported to 386.
Trinity College Engineering Department - Software Engineer - 1992 - C/Assembler
Developed a data acquisition and analysis system for the neurophysiology dept. at Trinity College . This C and Assembly system on PC and outboard hardware sampled animal brains and recorded EEG, displaying and analyzing results in real-time. The system was outlined in IEEE-EMBS publication.
Independent Consultant , Rome , Italy 1991
Digital Equipment Corp Italy - Engineer - 1991 - C/Assembler
Developed imaging interface for radiological systems for Digital Equipment Corp., Italy (whose client was a hospital). All hospital X-rays were scanned and archived through this system. The frame-grabbing board was device-driven in Assembler, while the programs which transferred images across DECNet to VAX optical disks were in C.
Metronotte Italy - Systems Integrator - 1991
Integrated a Wide-Area Network for Metronotte (a security company). This system was designed with 5 LANtastic LANs, 61 PCs, and modem
bridges across 13 sites in 6 cities. Designed and implemented the overall system. DS Telematica Italy - Programmer/Analyst - 1991 - Unix/C
Ported a large-scale Accounting/Inventory/Job Control system from VAX/Ultrix COBOL to SCO UNIX C. The original conversion did not function. Brought in to analyze the 250 C source files and debug the software for a release deadline.
Employee - 1987-1991 Aetna Life & Casualty - Automation Specialist November 1987- Dec 1990 - Foxpro/C/Assembler
Developed Claims department DB Networks which automated the drudgery of forms printing by reading claim data and determining which of 80 forms and versions to print and send, as well as to whom. The system was Xbase, adapted to be optical by the writing of a TSR which interfaced DB to scanners and kept track of scanned documents. Also developed complex statistical tracking system for bodily injury claims
Education
Lycees Chateaubriand & Stendhal , Italy
Malvern College , UK
Trinity College , Hartford CT
|