Engineered an extended 2-tier Data Warehouse solution for a large international manufacturer to analyze product warranty claims and quality defects. Solution integrated a Visual Basic developed user interface, Microsoft SQL Server database and custom reporting and graphing tools. Interacted with users to develop business rules and mathematical models into complex SQL queries. Coded speed-optimized ODBC-API interface to the SQL database. Programmed custom grid and combo box controls. Devised an automated and customized graphing and reporting tool that displays reports on screen, prints to printer and saves in EXCEL file format. Coded executables for extracting data from a legacy FOCUS database for use in the SQL database.
Developed a set of Multi-OS, Multi-distribution Client-Server applications using Visual Studio, Visual C++, Visual Basic, MS Access, MS Excel, SQL and Paintbrush as a sales tool for a large Life-Insurance Company. Five ActiveX libraries comprised of Actuarial, database, screen and printer functions were developed into a set of application servers. The main application is an insurance-illustration tool that assembles combinations of 270 insurance plans and riders into a visually appealing screen or printed output that conforms to State Illustration Law. The main user interface provides many help tools including a complete implementation of Tool-Tip Text Boxes, Context-Sensitive Help and a Set of Six Custom Windows Help Files that include links, contents, index and text-search features. A custom Install and uninstall program sets up Six Windows-based and Six Dos-based, from a CD-ROM, for stand-alone PC, CD and LAN installations. A MS Access database is used to track illustrated policies and a high-speed binary database is used for actuarial calculations
Created an ActiveX function library and a set of applications in Visual C++, Visual Basic and Excel to model the characteristics of an optical instrument for a major international manufacturer of semiconductor-processing equipment. The functions were developed into libraries that could be used with Visual Basic, C++ and Excel interfaces. One application performed monte-carlo ray-tracing of an infrared radiation through sapphire optical fibers and scattering from multi-layer Silicon wafers.
Developed a web site using HTML, Java, Java Script, VB Script, ActiveX, ADO, Active Server Pages , MS Front Page, MS Image Composer, Paintbrush, Iphoto plus and Paint Shop Pro. The web site features sound, animated graphics and incorporates frames, style sheets, and other advanced HTML features.
Devised a set of programs in Visual Basic, Quick Basic and C++ to collect, view and analyze ultrasonic scattering data. These programs were developed to analyze ultrasonic a-line scans and transducer beam profiles in order to evaluate the properties of different materials and the usefulness of these materials for medical test equipment.
Developed an insurance illustration program for a large insurance company using C++. Both home office personnel and a multi-state field sales force utilize this sales force automation tool. Worked with key users to understand business and legislative requirements, wrote new programs and modified existing code modules, set up source and executable code version control infrastructure and optimized memory utilization for deployment on field laptops.
Coded a set of programs in C++ that applies Mie theory to calculate scattering intensities, absorption coefficients and extinction coefficients for a wide range of size parameters. Programs, written in Quick Basic, used the data from the scattering calculations and the CIE color chromaticity co-ordinates to generate Windows Bit Map files. Bitmap files where edited using iPhoto Plus, Paint Shop Pro and Microsoft Draw to create visual simulations of the calculated scattering effects.
Created many programs, in Quick Basic, C/C++ and FORTRAN, for use in specific applications including:
Conversion programs- converted data and graphics files
Monte-Carlo - determined equilibrium geometric arrangement of adsorbates on metal surfaces using several different interaction potentials
Crystallography - generated specific lattice types, lattice sums and lattice mappings; LCAO -coded algorithms and performed computations using Extended Hückel, and SCF w -technique methods using Slater-type orbitals
Electron Diffraction - developed algorithms to model the diffraction of electrons from a surface structure using single scattering
Diffusion - modeled the diffusion of CO gas through pressed silica samples using differential equations with Fourier series solutions
Adsorption - modeled the adsorption of CO gas using a statistical-mechanical description of the adsorption process
Meteorological Optics - calculated the trajectories of light rays through ice crystals of naturally occurring shapes (ice crystal halos) and the trajectories of light through stratified medium (mirages)
Computer Graphics - developed algorithms to perform ray tracing on metallic and insulating materials, to optimize intensity patterns of lighting fixtures, to shade the surfaces of 3-d representations of data and functions, and to shade ball-models of molecules and surface structures
Chaos - investigated the steady-state chaotic behavior of competitive and non-competitive economical and biological systems
Curve Fitting - developed algorithms used to fit Lorentzian and Gaussian curves to experimental data.
Created a Windows graphics program, using Visual Basic to trace rays through stratified media using a Runge-Kutta solution to the differential equation describing the path of a light ray.
Created a menu driven DOS graphics program, using Quick Basic and 8086 Assembly language routines, to create, rotate, translate, save and modify model extended-single crystal structures, small single-crystal particles, defect structures, and adsorbate structures and display atoms in these structures as ray-traced spheres.
Designed a menu-driven DOS graphics program, using Quick Basic, that uses ray-tracing techniques to determine the illumination pattern of custom manufactured lighting systems. The program allows the user to input, save and modify the specifications on a number of light sources and reflectors and output the illumination pattern as radial or projected distributions.
Developed a menu-driven DOS graphics program to operate (via serial port) a grating infrared spectrometer, collect, save, load, display and manipulate infrared spectral data using Quick Basic.
Designed and implemented a menu-drive DOS program, in Quick Basic, to interface an IBM-compatible PC to an IR spectrometer, a mass spectrometer, ion gauges and thermocouple devices. Developed IBM-compatible PC interface to control the stepping motors of a camera tracking apparatus for use at the South Pole.
[Home] [Optics and Photonics] [Surface Science] [Software] [Tutorials]
Send mail to rkbrandt@execpc.com with questions or comments
about this web site.
Copyright © 1999 Brandt Innovative Technologies, Inc.