Input Excel Workbooks are first imported programmatically to capture data, check for errors and perform further analysis. Any changes done to a MC is archived and retrieved by the system for future display. Although financial amounts are presented in US dollars, users can utilize a new currency exchange rate and see the concurrent updates. Exchange rates are stored in the system for the appropriate conversion. Developed self-guided screens for user friendly navigation, reports are generated depending on user defined criteria.
All database objects have descriptive names that clearly represent their purposes.
Utilized VBA code throughout the application. When the SAS program finished, the VB program would parse the SAS output and write to an Oracle database. Advertising Company Developed a Visual Basic application that parsed flat files and loaded an Access database. The database was then queried to produce combinations of reports describing Yellow Pages usage information that were written to PDF files and indexed with HTML for ease of retrieval. Pharmaceutical Research Division Using SAS 6.12, Visual Basic, and Excel, wrote a system that took clinical data and produced Case Report Form tabulations for client that were to be used both internally and for FDA submission.