Consultant Specializing in World Wide Web Server Design, Development, Support, and Maintenance
: Dave Aiello has published a new Senior Internet Developer resume
Over ten years experience in all aspects of client / server application design and maintenance. Three years experience in full life cycle implementation of World Wide Web, electronic mail, File Transfer Protocol (FTP), and other Internet-style servers. Two years experience with integration of various Internet servers and SQL databases. Implementor of encryption and digital certificates (Secure Sockets Layer 2.0 and 3.0) on the Netscape SuiteSpot server platform. Developer of several Web applications which have been converted from "legacy" client / server systems.
Read on for [ Experience | Education | Additional Training | References ]
See also [ Biographical Sketch of Dave Aiello ]
Extensive experience with Windows NT Server and Workstation Version 4.0 and 3.51, Solaris and SunOS from SUN Microsystems. Significant experience with various Linux distributions, AIX from IBM, and Digital UNIX. Extensive experience with MacOS Systems 6, 7, and 8.
Server Product Suites:
Extensive experience with Netscape SuiteSpot, including Enterprise Server, Mail / Messaging Server, Directory Server, Catalog / Compass Server, Certificate Server, Proxy Server, News Server, and Collabra Server. Extensive experience with Microsoft Back Office 2.5 and 1.5, including Microsoft SQL Server 6.5 and 6.0, Microsoft Internet Information Server, and Microsoft Index Server. Some experience with Epicentric Portal Server 2.1, Apache 1.3, and Lotus Domino Server 4.5x and 4.6.
Enterprise Database Systems:
Extensive experience with Sybase Version 4.9.2 and 11.x on SunOS, Solaris, Digital UNIX, and Windows NT, including interfacing applications to them via DB-Library, Client-Library, and ODBC. Extensive experience with Microsoft SQL Server 6.5 and 6.0, including interfacing applications to them via ODBC.
Internet Development Tools:
WWW Page Design and Site Management Tools:
Significant experience with page design and site management tools, including NetObjects Fusion, Netscape LiveWire Site Manager, Netscape Communicator Composer, Microsoft FrontPage 97, Adobe SiteMill and PageMill. Experience configuring Netscape and Microsoft server products to accept FrontPage Server Extensions.
- Member, USENIX, 1999-.
- Member, SAGE, the USENIX System Administrators Guild, 1999-.
- Member, Netscape DevEdge / Netscape Developer Program, 1996-.
- Member, International Sybase User Group, 1996-.
- Member, Independent Computer Consultants of America (ICCA), 1997-1999.
- Apple Certified Developer 1985-1989. Apple Partner 1989-1997.
- Member, ACI US Developer Program, 1988-1997.
- Member, New York Macintosh User Group, 1991-1997.
Value Added Reseller Programs:
- Member, Netscape Solution Expert Program, 1997-.
- Member, ACI US Developer Program, 1988-1997.
J.P. Morgan Chase & Company, Inc., New York, June 1998 to August 2001.
AuditXchange Intranet Site, Technical Lead.
Multinational financial services firm.
Lead the effort to adapt the Slashcode Open Source Project to the J.P. Morgan Chase corporate IT environment. Successfully ported Slash 0.3 and 0.93 from Linux / Apache / mySQL to Solaris / Netscape Enterprise Server / Sybase. The Slash Engine implementation is currently being used as the basis for a Knowledge Management application within the Audit Department.
AuditXchange, the Internal Audit Web Site, is implemented on Netscape Enterprise Server 3.6 under the Solaris operating system. Content is generated dynamically from a Sybase SQL Server 11.9.2 database using Perl 5.005 and DBI with the DBD::Sybase driver.
In October 2000, AuditXchange surpassed 1,000 individual stories (content pages). Content under management is growing at an annualized rate of approximately 725 percent.
Intranet Portal for Employees, Module Developer and Syndication Designer.
Implemented a series of Java Beans, Java Servlets, and Java Server Pages within the Epicentric Portal Server application framework. These "portal beans" appear to the user as modules within the portal environment. Created the first module for the employee portal the implemented Rich Site Summary (RSS) syndication. Also implemented modules that capture headlines of several other news-oriented Intranet sites on the J.P. Morgan internal network.
The Employee Portal is implemented on Netscape Enterprise Server 3.6 under the Solaris operating system. Content is generated dynamically by Epicentric Portal Server Version 2.1.
Chatham Township Data Corporation (CTDATA), Denville NJ, and
Intellidyne, Seattle WA, August 1995 to present.
Implemented two public Internet sites based on Slash 0.3 and 0.4
Client / server and WWW consulting firms.
Web Master and Postmaster.
The Web Sites ctdata.com and rcnj.org were converted from small Web Sites with individually designed Web Pages between June and September 2000. Page views on the two Web Sites increased approximately 1,000 percent. They are now considered two of the best Web Sites in their market niches. Headlines from these Web Sites appear on my.netscape.com, my.userland.com, and xmltree.com.
Designed and implemented a public Internet site for two small consulting firms.
In order to complete this project, a fractional T1 had to be ordered, installed, and tested. Internet services had to be established with an ISP. A Windows NT Server running WebSite, Post.Office (POP3 / SMTP server), and an FTP server had to be installed, tested, and maintained. The Server had to be configured for multiple TCP/IP addresses and home pages. FrontPage Server Extensions also had to be installed and configured.
Managed successful conversion from WebSite to Microsoft Internet Information Server Version 2, and from IIS Version 2 to Version 3. Managed successful conversion from Internet Information Server Version 3 to Netscape Enterprise Server Version 3. Managed successful migration from Post.Office to Netscape Messaging Server.
Managed successful migration from 256k Frame-Relay Connection to full T-1. This required a co-ordinated cut from the existing virtual circuit to one with a larger capacity. It also required a multi-stage DNS change to ensure that service to customers? Web Sites and mail servers was not interrupted.
Atlantic Amateur Hockey Association, 1994 to present.
Appointed by the Referee-in-Chief of the Atlantic District (New Jersey, Eastern Pennsylvania, and Delaware) to build and maintain the database of registered ice hockey officials living in the area. Primary point of contact in the three state area for USA Hockey corporate information systems personnel and database users.
Regional Affiliate of USA Hockey, the amateur hockey association of the United States.
Officiating Database Coordinator and Web Master.
Designed and co-developed the Atlantic District Officiating Program Web Site, http://www.aaharefs.org/, the largest and most technically complex Web-based application operated by USA Hockey or its affiliates. This Web Site went live at the beginning of August 1999.
The Atlantic District Officiating Program Web Site was implemented on Netscape Enterprise Server 3.6 on the Windows NT operating system. Content is generated from Microsoft SQL Server 6.5 using Perl 5.005 with DBI and DBD::ODBC.
The database was originally implemented as a client / server application based on 4th Dimension for the Macintosh, which was maintained from 1994 to 1996. In May 1996, the database was successfully ported to Microsoft SQL Server 6.0. This was upgraded to SQL Server 6.5 in 1998.
Lipton, Englewood Cliffs NJ, March to May 1998.
North American Foods Intranet, redevelopment of existing internal Web Site, March to May 1998.
Multinational food manufacturing firm. Part of the North American Foods Division of Unilever PLC.
Consolidated a number of partially functioning individual Web Pages, and made a single, coherent Web Site out of them. This became the Unilever North American Foods Intranet.
Designed a new look and feel for the North American Foods Intranet using NetObjects Fusion 3.0 for Windows NT. Deployed the Web Site on a Lotus Domino Web Server (Version 4.6). Created an interface between the NetObjects Fusion Web Site and a number of Lotus Notes databases that had been "Web-enabled."
Also designed and built a small document repository using the Windows NT File System (NTFS). Wrote CGI and non-CGI scripts with ActiveState Perl 5.003 which would dynamically build "index" pages for each directory in the file system. These index pages were automatically linked into the North American Foods Intranet by a combination of the logic embedded in the Perl scripts and the settings established in the Domino Server Administration database.
Automatic Data Processing (ADP), Jersey City NJ, December 1997 to March 1998.
IRexpress, http://www.irexpress.com/, an investor relations automation application, December 1997 to March 1998.
Multinational computer services and payroll processing firm.
Served as Database Administrator for the IRexpress project through the development, alpha, and beta testing stages. Managed schema and server-based logic using Embarcadero DBArtisan and Microsoft SQL Server Enterprise Manager. Built four separate server environments using Compaq Proliant and Prosignia servers, and IBM Netfinity servers.
Managed schema migrations between 16 SQL Server databases on four servers. Wrote most of the stored procedures and triggers. Tuned the database for performance by creating new clustered and non-clustered indexes, changing device and segment placement, and moving database logic from web server to database server.
Wrote End-of-Day batch processes in ActiveState Perl for Win32, an implementation of Perl 5.003. The End-of-Day scripts integrated calls to Microsoft SQL Server with calls to the Windows NT operating system via the Korn Shell in MKS Toolkit. Made the script portable to a Sybase System XI / UNIX environment by abstracting all calls to the Windows NT operating system away from the core code of the scripts.
Philip Morris USA, New York NY, October 1997 to January 1998.
Analyst Workstation (AWS), quantitative analysis tool for consumer product brand management, application acceptance testing and documentation, October 1997 to January 1998.
Multinational consumer products firm.
Developed, implemented, and documented a testing program which evaluated the differences between Analyst Workstation, a Microsoft Windows application developed by Management Science Associates of Pittsburgh PA, and DataNet, a similar application written for the Apple Macintosh.
Schering-Plough Research Institute, Kenilworth NJ, July 1996 to July 1997.
IRIS, proposal to redevelop existing client / server application, July 1996 to April 1997.
Multinational pharmaceuticals firm.
IRIS, redevelopment of existing client / server application as a Web-enabled application, April 1997 to July 1997.
Wrote a proposal to convert an existing client / server application called IRIS from Macintosh front end / Sybase back end, to Netscape front end / Sybase back end. The proposal was accepted and work began on the conversion in April 1997. The project ended in July 1997 when key components of the IRIS application had been converted for Intranet access.
IRIS is a bio-informatics application written by Human Genome Sciences of Rockville MD. The legacy front end of the application is written in 4th Dimension and 4D SQL Server by ACI. The rewritten version of the front end is being implemented in Netscape LiveWire running on Netscape Enterprise Server Version 3.0, connecting to Sybase via DB-Library.
GCF, Inc., Norwood NJ, January 1997 to present.
Designed and implemented an Internet site where clients and potential clients in the New York metropolitan area can obtain information about GCF products and services. Also implemented a mail server which serves 10 to 15 employees, and an EDI trading relationship with Square D via the Harbinger value added network.
Electronic Products Distributor. Authorized distributor for Square D, Telemécanique, and other major suppliers.
Internet Site Architect, Web Master, Postmaster, EDI systems integrator.
In order to complete this project, a frame relay connection had to be ordered, installed, and tested. Internet services had to be established with an ISP. A Windows NT Server running Netscape Enterprise Server and Netscape Messaging Server had to be installed, tested, and maintained.
InterWorld Ventures, New York, January 1997.
Netbuyer Web Site, http://www.netbuyer.com/
optimized and tuned Microsoft SQL Server 6.5 database, January 1997.
Internet application developer for electronic commerce and on-line catalog applications.
Provided SQL Server consulting services to InterWorld for enhancement of this major Internet site owned by Ziff-Davis' ComputerShopper publication. Advised InterWorld to denormalize certain information to reduce number of joins required to complete a query initiated by a Site user. Also recommended improvements in the non-clustered indexes on most important tables.
Netbuyer Web Site is run on a Compaq Proliant with multiple Pentium CPUs, 512 megabytes of RAM, and gigabytes of hard disk space in RAID configuration. Server runs Windows NT 4.0, Microsoft SQL Server 6.5, and Internet Information Server 3.0.
J.P. Morgan & Company, Inc., New York, April 1993 to December 1995; August 1996 to February 1997.
Foreign Exchange Options, supported and tested versions 14.07 - 14.10, August 1996 to February 1997.
Multinational financial services firm.
Adapted major portions of the FX Options Systems' functionality to the Emerging Markets business. System has been used primarily in the FX, FX Options, and Cross-Markets Proprietary Trading businesses at J.P. Morgan, worldwide. Acted as DBO (database owner) on two Sybase 4.9.2 databases and one System XI database. Wrote and installed stored procedures and triggers, wrote UNIX shell scripts that performed operations on development and production databases, made changes to database schemas.
Supported a User Acceptance Test, lasting more than 6 weeks, in J.P. Morgan's Mexico City Office. Test consisted of individual application functionality and synergistic testing of three custom software packages, one custom Sybase Open Client application, and interfaces to several vertical market applications in the Mexico City office.
BeRated!, designed and developed versions 1.0 to 3.0, April 1993 to December 1995.
Hired as the first developer of the BeRated! Suite of Applications for Performance Appraisal, Staff Management, and Executive Compensation. System has been used since 1993 by executives and staff of Emerging Markets, Foreign Exchange, Commodities, Exchange Traded Products, and Cross-Markets Proprietary Trading businesses at J.P. Morgan. The BeRated! Suite has become the prototype performance management system for all J.P. Morgan business units worldwide.
- BeAdministRated!, designed and developed versions 1.0 to 1.2.x, January 1994 to December 1995.
- BePaid!, designed and developed versions 1.0 to 2.0, January 1994 to December 1995.
- BeCounted!, designed and developed version 1.0, January 1994 to December 1995.
Sybase, New York and Parsippany NJ, March to May 1996.
Designed and implemented a secure Internet site where Sybase users at Citibank could obtain information about Sybase's Data Warehousing products and services. The Web Site was event-specific and designed to support Sybase's global data warehousing proposal to Citibank. This Web Site was accessed by Information Systems professionals in New York, London, Frankfurt, and Hong Kong.
Client / server database tools developer.
In order to complete this project, a fractional T1 had to be ordered, installed, and tested. Internet services had to be established with an ISP. A Windows NT Server running WebSite, Sybase SQL Server for NT, and Post.Office had to be installed, tested, and maintained.
System was decommissioned at the request of the client in May 1996, when the proposal to Citibank was completed.
Telesector Resources Group, White Plains NY, February to April 1993.
A subsidiary of NYNEX, now Verizon, a multinational telecommunications company.
Created the Open Network Access Wire Center Deployment Database for NYNEX Corporation. This program allows NYNEX to electronically transmit to the F.C.C. a list of the facilities and services available in each wire center. This project was developed in dBASE IV and Turbo Pascal according to specifications provided by Bellcore and standards previously in place at New York Telephone, New England Telephone, and NYNEX.
Teach for America, New York, November 1992 to January 1993.
Modified an existing 4th Dimension Version 2.x database to support 4th Dimension Version 3.0 and the 4D Server. The 4D Server was ultimately expanded to 25 concurrent users. The system is a high volume, applicant tracking database which supports a national, non-profit organization.
A national Non-Profit Organization supported by many of the major charitable foundations in the United States.
Consultant, Admissions Program.
L.L. Bean, Inc., Freeport ME, July to December 1992.
Developed an Electronic Data Interchange transaction tracking and reporting system. It employed client / server technology with 4th Dimension as the client environment and Sybase, DB2, and Datacomm as the servers.
World famous clothing and adventure equipment company.
Consultant, Information Systems Group.
Rensselaer Polytechnic Institute. (Troy NY), May 1989.
B.S. Management. Concentration in management information systems.
Served as manager of the nationally-ranked Division I, RPI Men's Ice Hockey Team, 1985-1988. Played in several non-league hockey games during the period. Also played on the Men's Lacrosse Team, 1986.
Currently serving as President of the Rensselaer Club of New Jersey, http://www.rcnj.org/, the New Jersey Chapter of the Rensselaer Alumni Association.
Received the Alumni Key Award from the Rensselaer Alumni Association, for outstanding service to Rensselaer, in June 1998.
Most Significant Continuing Education and Technical Training:
USENIX Tutorial Series, (Atlanta GA), October 1999.
Two day, instructor led training course series covering system administration and network operations using version 2.2 of the Linux operating system (i.e., RedHat Linux 6.x).
O?Reilly Perl Tutorials, (Boston MA), April 1999.
Three day, instructor led training course series covering dynamic Web Page generation, and automated Web Site management using the Perl language.
Netscape Enterprise Server Training Course, (Edison NJ), April 1997.
Three day, instructor led training course covering installation, configuration, tuning, and management of the Netscape Enterprise Server for UNIX. Actual training took place on Sun servers and workstations running Solaris. Instruction was provided by staff of Access Graphics.
Sunsoft Java Developer Camp, (Philadelphia PA), January 1996.
Introductory course to Java development. Topics included integration of Java applets into World Wide Web sites, choice of development tools, base classes, construction of new classes, creation of applets, and use of the Abstract Windowing Toolkit (AWT).
The Dale Carnegie Sales Training Course, (Westbrook ME).
A ten week training course in the human relations approach to professional selling. Participated in a training course which is designed to improve sales and customer service. This program directly improved consulting service because it taught effective listening and questioning techniques, positive mental attitudes, and constructive negotiation skills.
Available on request.