Overview – Skills/Software
SQL Server 2000 – 2019 |
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 |
Refrigeration Control |
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
Flexware Controls, Bangor, ME 2023-Present
SQL Server Database collects real-time data from a series of supermarket-based Raspberry Pis, making data available to a series of users in real time.
Insurity, Hartford CT 2020-2021
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 legacy Workers Comp legacy system at client site.
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
|