|
Client: County
government
Situation: A lost
password had rendered one of the county’s key databases
inaccessible. Furthermore, the database needed migration to
SQL Server, and county staff needed training on the application.
Solution: GopherData
recovered the lost password, identified the role security
played in the application, and led code review sessions with
county programmers to teach them the principles of MS Access
workgroup security. Finally, we converted the application
to a SQL Server backend, using Data Transformation Services
(DTS). This included opening communication between the SQL
Server backend and the Access front-end with the appropriate
Data Source Name (DSN). This project also involved upgrading
users to a county-compatible version of Microsoft Data Access
Components (MDAC).
Skills Used: Microsoft
Access, Microsoft Data Access Objects (DAO), Microsoft SQL
Server, Microsoft Visual Basic for Applications.
Status: Completed
Client: Multi-billion
dollar financial services corporation
Situation: Surprised
by new federally-mandated standards on loan agreements and
other operations, the company scrambled to comply.
Solution: In this
project, GopherData developed a complex report to satisfy
federal requirements on corporate loan health. The report
required extensive pre-run time programmatic manipulation
of numerous record sets. The final report was instantiated
per client.
Skills Used: Microsoft
Access, Microsoft Data Access Objects (DAO), Microsoft Visual
Basic for Applications.
Status: Completed
Client: Healthcare
Services Network
Situation: In
order to continue tracking adverse drug reactions, a chain
of hospitals and clinics needed to transfer vital data to
SQL Server before the sheer volume in information rendered
the existing database inoperative.
Solution: GopherData
developed a proprietary database for managing this information.
To expedite data input, the database featured many usability
enhancements, such as "Not in List" event routines.
The capstone was its main report, which made use of extensive
programmatic manipulations of report run-time events.
Skills Used: Data
Modeling, Microsoft Access, Microsoft Data Access Objects
(DAO), Microsoft Visual Basic for Applications.
Status: Completed
Client: Multi-billion
dollar financial services corporation
Situation: Unable
to generate the complex reports it required for thorough business
analysis, the client needed immediate assistance in programming,
administration and security consulting.
Solution: This
lengthy engagement is broken down by subgroup: 1) Loan Covenant
Reporting: GopherData created a complex report tracking loan
covenant defaults by various measures, usually three consecutive
defaults. 2) Charting Business Unit Performance: GopherData
created a series of Excel PivotTables with charts to track
business unit performance. 3) User Activity and Concurrency:
Extending the existing MS Access workgroup security functionality,
GopherData created a user-transaction log which tracked user
activity on critical tables. In addition, we created a temporary
table monitoring currently logged-on users. 4) Database Consolidation:
Using a union query, we consolidated multiple branch copies
of the same database. This centralized the data storage, but
slowed access time for some branch banks in outlying areas.
As a workaround, we created a nightly routine which programmatically
sent to these branches a copy of the previous day’s database.
5) Mass Data Entry: Loan covenants require borrowers to report
at regular intervals, the scheduling of which this group pre-entered
into the database by hand input. To save time, we created
a routine which programmatically created these schedules.
It also included a rollback feature to back out of an input
series.
Skills Used: Microsoft
Access, Microsoft Data Access Objects (DAO), Microsoft Excel,
Microsoft Office, Microsoft Visual Basic for Applications,
Microsoft Window NT Server
Status: Completed
|
