Meryl Meyer
Hermosa Beach, California
(310) 372-2189/Fax (928) 563-3111
e-mail: Click here to request my email address
Please no relocation or travel
- Summary
- Extensive experience with MS Sql Server Development, MS Reporting Services, Crystal Reports and Cognos Impromptu. Excellent SQL database modeling as well as business analysis and requirements gathering.
Partial Project List
- Operations Report Infrastructure (IndyMac and Financial Freedom)
- Created an Operations Report Infrastructure (SQL Server) to allow the various operations departments to easily identify work-in-progress. In addition, this system allows management to easily identify problems in their area that need to be address. Another benefit of this system is that it identifies data issues that need to be addressed and potential system issues with their Loan Origination systems.
- Project Tracking Database (IndyMac and Financial Freedom)
- Created and maintained an Access/SQL application that tracked projects as well as the tasks associated with the projects. In addition, this system allowed for the tracking of Policy and Procedure revisions and maintenance.
- Business to Business Web Site (ShofCorp)
- Design: 3 Tier Client Server application utilizing VB 6.0 Web Classes, MTS Com Data Interface and MS SQL Server 6.5
- Web site allows businesses to sell products and services to other businesses or consumers
- Crystal Reports (IndyMac)
- Create/Modify Crystal 6.0 Reports to report off of their existing SQL Server Database
- Customer Information Maintenance System (Eastern Pacific Energy)
- Design: MS Sql Server Database, Visual Basic 5.0, ODBC, Crystal Reports 5.0
- Maintains customer information and generates reports
- Shop Report (KPMG Peat Marwick/Western Digital)
- Design: Oracle Database, Visual Basic 4.0, ODBC, Spread/VBX, Crystal Reports 5.0.
- Generates a production test report based on user supplied various criteria
- Report Cataloging System (First Consulting Group)
- Design: Microsoft SQL Database, Visual Basic 4.0, ODBC, Spread/VBX, Crystal Reports 5.0.
- Maintains data custom reports for a Time Keeping program and allows users to select and print reports stored in the "catalog"
- Mortgage Collateral Management System
- Design: Microsoft SQL Database, Visual Basic 4.0, vbSQL, Spread/VBX, Crystal Reports 5.0.
- Maintains data on all collateral held by a mortgage holding company. Allows users to create "pools" of loans meeting specified criteria.
- Full security
- Insurance Liability Calculation Program
- Design: SQL Database, Visual Basic 4.0, Spread/VBX, Crystal Reports 5.0
- Complicated calculation algorithm to calculate an insurance company’s liability to dealers for policies sold
- Lease Reporting System
- Design: Access Database, Visual Basic 3.0, Spread/VBX, TabPro, Crystal Reports 4.5.1.1.
- Maintains data on leases for numerous offices and reports on costs and other lease data
- Basic security (users can look but not touch information that they are not directly responsible for)
- Facilities Project Management System
- Design: Access Database, Visual Basic 3.0, Spread/VBX, TabPro.
- Maintains data on projects in process
- Allows users in 3 different areas of the project to share data and view other individual’s status on the project
- Prints several management reports giving the user options on sort order, selection criteria, etc.
- Basic security (users can look but not touch information that they are not directly responsible for)
- Parking Management System
- Design: Access Database, Visual Basic 3.0, Spread/VBX.
- System allows company to maintain data on employee parking spaces and cost and print reports to management
- Bank Annuity Policy Management System
- Design: Access Database, Visual Basic 3.0, Spread/VBX.
- Wrote several utilities which read mailed text files and process them, i.e., updated databases, print reports, etc.
- Designed security interface for the system
- Payroll Recordkeeping and Accrual System
- Design: Access Database, Visual Basic 3.0, Spread/VBX.
- Employees enter their time and time off into system. System generates timesheets and payroll reports. Monthly vacation accruals are calculated and users can access their own time to look up their available time off, etc.
- 3 levels of security for setting up records, approval process, etc.
- Provides management reports on time off, overtime paid, etc.
- Client List
- Fiancial Freedom
- Irvine, California
- 7/05 - present: Consultant
- QAVantage, Inc.
- Red Bank, New Jersey
- 8/02 - present: Consultant
- IndyMac
- Pasadena, California
- 4/99 - present: Consultant
- ShofCorp
- Lake Forest, California
- 3/99 - 4/99: Consultant
- IndyMac
- Pasadena, California
- 12/98 - 3/99: Consultant
- Eastern Pacific Energy
- Brea, California
- 2/98 - 10/98: Consultant
- KPMG Peat Marwick, LP
- Los Angeles, California
- 5/97 - 9/97: GE Capital Heritage, Consultant
- 6/97 - 9/97: Western Digital, Consultant
- First Consulting Group
- Long Beach, CA
- 3/97-5/97: Consultant
- KPMG Peat Marwick, LP
- Los Angeles, California
- 5/96 - 1/97: GE Capital Heritage, Consultant
- 6/96 - 12/96: CWM Mortgage Holdings, Consultant
- Visual Logic Solutions
- Los Angeles, California
- 1/96 - 6/96: Consultant
- Transamerica Financial Services
- Los Angeles, California
- 5/95 - 12/95: Consultant
- The Holden Group
- Los Angeles, California
- 10/94 - 12/94: Consultant
- Nelson & Quillin
- Los Angeles, California
- 8/94 - 3/95: Consultant
- Education/Accreditations
- 1989 - Present
- Self taught Visual Basic (1.0 - 6.0), Crystal Reports (1.0 - 11.0), SQL (5.0-2005), Reporting Services, MS Access
- Programmers Toolkit for Visual Basic, SQL System Administration, Microsoft Access Database
- 12/93
- Microsoft SQL Server Developer Course
- 1979 - 1983
- Boston University
Boston, Massachusetts
Bachelor of Science in Business Administration, Concentration in Finance