EXPERIENCE Microsoft Technologies Microsoft Access Microsoft SQL Server / Azure Microsoft ASP.NET / C# Microsoft Angular / MVC Microsoft WPF Mainframe/Mini Microsoft Word / Excel
Microsoft SharePoint - Power Apps, Power BI
C#, MVC, Angular, WPF
Microsoft Access
ASP.NET
Microsoft SQL Server, Azure
Excel
Microsoft SharePoint -Power Apps, Power BI
World’s leading state-of-the-art web-based rapid development environment.
MGM Transformer
Teams – SharePoint. Developed Flow applications to set up action triggers as documents were received in a business pipeline.
D.L. English Design
Teams – SharePoint. Used Power BI, Power Apps, and Flow to handle actual vs. estimated cost projections for Senior Management, and remote data entry on job costs for designers in the field.
Equinaire Real Estate
SharePoint. Wrote a company application to analyze a data farm of Los Angeles County real estate statistics to compare against individual MLS listings, giving them ratings as to how attractive their price was compared to expectations.
Microsoft Access
The #1 most common application development environment in the world.
Acu-Care
Microsoft Access. Integrated data for insurance companies into reports as email attachments..
American Security Products
Microsoft Access, SQL Server. Programmed system to handle manufacturing, marketing, item returns and workflow.
Association of Los Angeles County Deputy Sheriffs
Microsoft Access. System to report summary statistics on how this policeman’s union performed.
Dent-ology
Microsoft Access. Extracted and emailed results of commission splits for auto body work.
Hermandad Mexicana
Microsoft Access, Microsoft Word 1040. Helped people by auto-filling IRS tax forms based on a questionaire.
Investor's Business Daily
Microsoft Access. Manufacturing system to look for weaknesses in production chain.
Kaiser Permanente Genetics Laboratory
Microsoft Access. Interface with lab equipment to HL7 upload to 4medica mainframe.
Loma Linda University Medical Center
Microsoft Access, SQL Server. Construction management system used for over $1 billion of campus construction projects.
MGM Transformer
Microsoft Access, SQL Server, C#, ASP.NET. Custom transformer quoting system. Has built in logic for adjusting options based on choices.
National Tax Experts
Microsoft Access. System which fills in Word based IRS tax forms based on questions answered by customers.
Palladeo
Microsoft Access, SQL Server. System for preparing quotations on interior design, with full details on all materials and labor involved.
T.C. Metal
Microsoft Access, SQL Server, C#. Manufacturing system tracks all materials, with invoicing uploaded to Sage Accounting system.
U.C.L.A. School of Public Health
Microsoft Access, SQL Server, C#, ASP.NET. Admissions tracking system. Categories of applicants, along with class scheduling.
Microsoft SQL Server / Azure
The world’s leading database technologies.
American Security Products
Microsoft SQL Server, Microsoft Access. Data storage and procedures to support custom Access manufacturing system.
Loma Linda University Medical Center
Microsoft SQL Server, Mcrosoft Access. Back end data and procedures to support custom construction management system.
Aspen Community Health Clinics
Microsoft SQL Server. Wrote procedures to transfer data from internal systems to state required format.
MGM Transformer
Microsoft SQL Server, Microsoft Access, C#. Support for web based quoting system used by manufacturer’s representatives throughout the country.
Aurora Life Assurance
Microsoft SQL Server. Acting Information Systems Director. Developed SQL Server interface with FAST mainframe system.
Palladeo
Microsoft SQL Server, Microsoft Access. Procedures and data to store all labor and materials used in grocery store, drug store and bank remodels.
Inland Fair Housing Mediation Board
Microsoft SQL Server, C#, ASP.NET. Procedures to process information in website serving a dozen offices in Southern California.
T.C. Metal
Microsoft SQL Server, Microsoft Access. Data and procedures to back up manufacturing application which also interfaces with G/L.
Kaiser Permanente Genetics Laboratory
Microsoft SQL Server, Microsoft Access. Back end data repository for laboratory equipment while it was analyzed.
U.C.L.A. School of Public Health
Microsoft SQL Server, Microsoft Access, C#, ASP.NET. Engine used behind custom financial website, showing secure statistics on school performance.
Microsoft ASP.NET / C# / Angular / MVC / WPF
These are the world’s leading web and desktop development platforms.
Answer Financial
ASP.NET, C#. Developed “Kinetix”, a patented method for processing web pages dynamically based on users answers.
U.C.L.A. School of Public Health
ASP.NET, C#, SQL Server. Developed custom financial application, including web based graphs of statistics.
Blue Cross of Southern California
ASP.NET, C#. Wrote part of Sales Force Automation (SFA) web based application to be used by insurance salespeople in the field.
MGM Transformer
ASP.NET, C#, Microsoft SQL Server, Power Apps, WPF. Wrote logic-filled web application which customizes design options for electrical transformers.
Inland Fair Housing
ASP.NET, C#, SQL Server. Developed dynamic web based questionnaire to help people apply for assisted housing.
Microsoft Word / Excel
In depth knowledge of the #1 word processor and spreadsheet.
Acu-Care
Microsoft Excel, Microsoft Word. Numerous Excel extracts. Customized Word letters, using remote controlled mail merge.
Kaiser Permanente Genetics Laboratory
Microsoft Word. Extracts sent to Word in embedded tabular format.rd.
MGM Transformer
Microsoft Word, Microsoft Excel. Quoting system has advanced Word extract features, such as section titles, dual columns of floating data, and fully automated data entry.
Hermandad Mexicana
Microsoft Word. Integrated questionnaires entered by applicants for tax assistance with Word based 1040 IRS tax forms.
Mainframe/Mini
Additional experience with large, popular platforms.
The Boston Company
Experience with DYL280, EasyTrieve, COBOL, and SAS. Managed Money Market II Portfolio Accounting system.
State Street Research & Management
Integrated Reuter‘s feeds with internal mainframe system in COBOL.
Loma Linda University Medical Center
Supported dBase IV system for cardiology statistics reporting. Facilitated this system’s integration with EPIC.