ENNIO GALIANI
Burbank, CA | (818) 859-8104 | ennio@elaginc.com
Senior software developer and data architect with extensive experience designing, building, integrating, and maintaining database-driven business systems across publishing, financial services, insurance, hospitality, utilities, logistics, and other industries. Background spans SQL Server, data warehousing and ETL, application development, legacy-system modernization, financial processing, and embedded software.
Databases & Data: Microsoft SQL Server (2000–2019), MySQL, Sybase, SQL Anywhere, ETL, SSIS, DTS, data modeling, data warehousing
Programming: C, C++, Visual C#, Visual FoxPro, Java, Android, PHP, HTML, XML, Visual Basic, Assembly Language(s)
Architecture & Integration: Solution architecture, data architecture, COM/DCOM, ActiveX/OLE Automation, client/server systems, system integration, legacy modernization
Tools: PowerDesigner, ERwin, Eclipse, Dreamweaver, Microsoft Word/Outlook automation
Specialized: Financial and royalty accounting, transaction processing, data conversion, reporting, embedded systems, file-format conversion and lossless compression
Publishing • Financial services • Credit-card processing • Bankruptcy funds • Insurance • Hospitality • Utilities and power • Broadcasting • Real estate • Construction and architecture • Refrigeration control • Billing and invoicing • Collections • Data warehousing • Tobacco
· Lead development and analysis across database, integration, and application projects using SQL Server, MySQL, XML, C/C++, Visual FoxPro, Android/Java, and Eclipse.
· Developed a SQL Server database solution that collects real-time data from supermarket-based Raspberry Pi devices and makes it available to users in real time.
· Began design of a SQL Server data model and Visual C# MDI interface for a cross-product data dictionary at an insurance software company.
· Resolved issues in a legacy workers’ compensation system at the client site.
· Built an integrated hotel minibar platform for inventory, sales, order processing, purchase-order generation, invoice reconciliation, and room checks.
· Implemented a SQL Server back end with Android applications running on tablets from multiple manufacturers; deployed across 50+ hotels with 110+ remote tablets.
· Designed offline-capable data capture and synchronization over Wi-Fi, plus inventory controls, replenishment workflows, sales-history-based order calculations, and management reporting.
· Developed an end-to-end business application supporting call tracking, buy/sell tracking, competitive bidding, automated mail/fax/email, and financial reporting.
· Added tools that let nontechnical users create database-driven HTML form letters and distribute them through Outlook at a reported rate of 800 per minute.
· Built a turnkey application used by more than 200 users over its first dozen years, with minimal training requirements and a strong uptime record.
· Integrated wind-turbine data, forecast data, and power-market pricing data using SQL Server 2008.
· Developed a SQL Server back end and Windows administration application supporting the Zen Cart e-commerce platform.
· Developed embedded C functionality for audio-file format conversion, lossless compression, filtering, and polynomial interpolation. Work performed under NDA.
· Architected and developed the Starfish data warehouse and data-mining tool, integrating seven legacy business systems through a custom ETL process and a common operational data store.
· Designed and built WYSIWYG invoicing, real-time aging, customer deduplication, automated shipping, centralized financial reporting, unapplied-cash and refund management, and marketing-list generation.
· Modeled data-conversion stages across multiple business units and legacy systems, enabling current transactions to flow into a central environment as frequently as every 15 minutes.
· Delivered the core turnkey system from the ground up in three weeks.
· Developed a grant-management and tracking system.
· Developed a real-estate website using ASP.NET, C#, and SQL Server 2005.
· Developed a hosted document-tracking website for architects, facilities managers, and general contractors.
· Led a project to redesign accounting processes, moving cable-affiliate reporting from self-reported sales to direct billing based on actual sales.
· Created a business-wide logical data model in PowerDesigner and an object-oriented rapid-application-development client framework.
· Trained Xbase programmers in client/server development and object-oriented design; authored an RFP for a potential clearinghouse/trading partner.
· Designed and implemented a deals and royalty-accounting engine supporting complex contract clauses and calculation methods.
· Designed and implemented the Bond Buyer 40 municipal bond futures index, including remote broker data collection, yield and coupon-factor calculations, and automated publication to Word, the website, and newswire.
· Built editorial/prepress tracking, buyer’s guide generation, and automated bond-redemption notice systems.
· Maintained and enhanced a global financial data warehouse for income statements, balance sheets, and variance analysis using Sybase and Visual Basic; worked with data models, stored procedures, and triggers.
· Completed development of a Visual Basic 5 reservations client for worldwide deployment, supporting a transaction-intensive C/Stratus back end and SQL Server reporting.
· Analyzed and remediated Visual FoxPro, FoxPro, and C/C++ systems for Year 2000 compliance.
· Built an interactive Y2K scanning/editing tool and documented testing procedures, compliant and noncompliant functionality, and remediation options.
· Developed and maintained C programs and DLLs to convert carrier-rate data into a common internal format.
· Developed a construction project-management system using Visual FoxPro, Watcom C/C++, SQL Anywhere, Power++, OCXs, and OLE integration with Microsoft Office.
· Enhanced a configuration and order system supporting engineering, sizing, CAD, costing, and pricing for large electrical systems during a transition toward Windows, Visual C++, and SQL Server.
· Union Bank of Finland / Skandinaviska Enskilda Banken: designed a Windows bank-netting system for reconciling multicurrency transactions across corporate divisions.
· Independent trader: rebuilt a currency-trading system intended to model movements among the U.S. dollar, Deutsche Mark, and yen.
· UNHCR: developed a disbursements module for tracking refugee payments within a registration system.
· Nestlé: developed and maintained a FoxPro supply-planning and logistics system covering deployment, load planning, inventory, sales forecasts, net requirements, pallet sizing, and custom calendars.
· World Health Organization: developed water and sanitation monitoring systems and advised local directorates on management information systems; facilitated a UN conference on water and sanitation in Benin.
· Philip Morris International: developed a headquarters administration system supporting 880 employees across four buildings, including telephone billing, directories, car pools, and publication distribution.
· Swiss Federal Office of Statistics: developed a questionnaire-imaging and data-management system using Visual Basic, C, and Ingres.
· MEPSCO Refrigeration: developed supermarket refrigeration and electrical controls with a Z80 assembly back end and a C-based monitoring interface.
· Trinity College Engineering Department: developed a real-time neurophysiology data-acquisition and analysis system; the work was described in an IEEE-EMBS publication.
· Digital Equipment Corporation, Italy: developed an imaging interface for hospital radiology systems, including image capture and transfer to VAX optical storage.
· Metronotte, Italy: designed and implemented a wide-area network linking 61 PCs across 13 sites in six cities.
· DS Telematica, Italy: analyzed and debugged a large accounting, inventory, and job-control system during migration from VAX/Ultrix COBOL to SCO UNIX C.
· Aetna Life & Casualty: developed claims-department database networks that automated form selection/printing and supported scanned-document tracking, along with statistical tracking for bodily-injury claims.
English, French, and Italian — fluent in written and spoken communication. German and Spanish — reading/understanding.
· Lycées Chateaubriand & Stendhal, Italy
· Malvern College, United Kingdom
· Trinity College, Hartford, Connecticut