Eric Poncet - Web, multimedia, software architecture, expertise and management

	RDBMS

Oracle V6/V7 to V8i migration

Adapted and enhanced a suite of PRO*C programs:

Migrated clients from Oracle6/DOS to Oracle8i/Windows 9x/2000
Migrated server from Oracle7/Netware to Oracle8i/Windows NT

Keywords: Oracle 8i, PRO*C, C, Windows NT/2000/9x, PC
Duration: 2 weeks

Y2K / Euro for a European truck consortium

Adapted and validated a 16-year old office management application for Y2K and Euro compliance.
Most challenging was redesigning system components so that all the 60 programs of application would be compatible with both an old technology and a new standard for dates and currencies.
Keywords: Pascal, Pascalisam, Pascalforms, UCSD, DOS, PC
Duration: 1 month

Project management software for a car manufacturer

Developed and edited a project management application for car design.
Users entered project structure, deadlines, milestones and evolution.
The application consolidated project data into dashboards and follow-up graphs.
The product has allowed the client to save a lot of time in project management and eliminate a significant volume of paperwork.
Keywords: Visual C++, MFC, Windows, PC
Duration: 6 months

Single-user to multi-user port

Ported a single-user Oracle5/DOS application to Oracle7 on a Netware server.
Gathered new business requirements.
Rearchitected application to comply with client-server paradigm.
Reengineered programs and forms to allow for concurrent user operations on the data.
Keywords: C, Oracle, SQL, PRO*C, Forms, DOS, Netware, PC
Duration: 2 months

Object-relational bridge

Analyzed and prototyped a bridge between an Object-DBMS and Postgres. Developed a PostQuel driver open to other RDBMS. Designed a grammar for independent schema description. Developed a class library and C++ source code generating tools.
Frequent use of the Internet for research purpose.
Keywords: C++, C, Lex, Yacc, Grammar, PostQuel, Postgres, ODBMS, Bridge, Code generation, Sun, PC, Unix, X/Window, DOS
Duration: 1 year

Production, Accounting, Invoicing for an oil company

Designed and implemented a PRO*C development toolbox.
Redesigned, developed, tested & integrated a complete management solution, which was installed in 120 locations.
Tuned programs, reducing runtime execution of a critical module from 2 ½ hours down to 8 minutes.
Please read the interview I had with an IT-professional magazine.
Keywords: C, PRO*C, Oracle, SQL, Forms, Unix, PC
Duration: 1 ½ year

Logistic management for an industrial design office

Analyzed and developed an application for managing resource and production:

Projects
Parts
Orders
Schedules
Invoices
Statistics

Keywords: C, PRO*C, Oracle, SQL, Forms, DOS, PC
Duration: 6 months

Production management for a plumbery

Architected&developed application and trained users.
This application allowed for the management of:

Supplies
Customers
Projects
Invoices

Keywords: C, DBase, DOS, PC
Duration: 1 month

Production, accounting, invoicing for a real estate developer

In charge of expanding systems and applications.
Conducted market survey, performance and port tests with different hardware companies.
Developed production/accounting/invoicing modules and integrated various office applications.
Keywords: Audit, C, Unify, Unix, Worknet, Altos
Duration: 6 months

Sports event for Paris City Hall

Developed modules for supervising the Paris marathon:

Runners registration
Start/finish follow-up
Results processing

Keywords: C, DBase, DOS, PC
Duration: 1 week

Production management for a rocket designer

Developed a complete solution:

Production management
Project follow-up
Meetings organization (automated agendas and minutes)

Keywords: C, PRO*C, Oracle, SQL, Forms, DOS, PC
Duration: 6 months

Prospect management for a programmable machines distributor

Audited existing application, negotiated contract with the client, and developed an application to generate and follow up proposals and mailings. Trained and assisted users.
Keywords: Pascal, Open access, Data conversion, DOS, PC
Duration: 1 month

Clients database for a furniture warehouse

Designed and implemented an enterprise solution for managing a database of clients and prospects:

Data entry (personal, professional, financial)
Reports (automated mailing, follow-up letters, credit deadlines)
Utilities (printers, security)

Keywords: Pascal, UCSD, Apple 2
Duration: 1 ½ month

Project management software for a corporate building developer

Developed an application for assessing real estate investment projects:

Costs
Budget
Profitability

Keywords: Pascal, Pascalisam, Pascalforms, UCSD, DOS, PC
Duration: 1 month

German localization

Translated user interface and reports of a 40+ program suite from French into German.
Gathered requirements with German partner, implemented the translation and validated with partner.
This project was very exciting, because it required both technical and linguistic skills.
Keywords: Pascal, Pascalisam, Pascalforms, UCSD, DOS, PC
Duration: 1 month

Solution for a truck design office

Designed and implemented a complete enterprise solution for a European truck consortium aimed at managing drawings, tools, parts, orders, invoices, depreciations and financial reports.
Ported from Apple3 to PC. Added extensions.
This application was developed in 1983 and is still being used!!!!
Keywords: Pascal, Pascalisam, Pascalforms, DOS, UCSD, PC, Apple
Duration: 1 ½ year

Cash management for large companies

Implemented and maintained cash management software: accounts, balances, commissions, simulation, financial optimization, statistics, budgets.
Added extensions for teleprocessing bank data, and synchronizing forecasts and operations.
Developed new modules for specific client needs.
In charge of installation and support.
Ported the application from Apple 2 to Apple 3 then PC.
Keywords: Pascal, Pascalisam, Pascalforms, serial communications, RS232, UCSD, DOS, Apple, PC
Duration: 3 ½ years