Occupation:Developer |
Location:New York, NY |
Education Level:Some College Units Completed |
Will Relocate:YES |
Description
Summary: Management of the life cycle of an MS Access application from design phase through to deployment, testing, maintenance and training. - Software requirements: Gathered software requirements from the project stakeholders and end users. Utilized UML techniques to create use- case models to provide an overview of the usage requirements of the customized application. Created entity-relationship models using MS Visio to make presentations of the database architecture. - Security: Use of general best practices for a multi-user application: creation of workgroups, user and administrative groups with various levels of permissions, use of .mdw files via desktop icon to open the application as part of the user-level security. Deployment of the MS Access application to the network shared drives and to the end users' PCs. - Designed the application using front-end and back-end database structure. The front-end consist of MS Access objects such as queries, forms, reports, modules and uses linked tables to the back-end. The back-end data database contains the tables. - Conducted training sessions for end users and created user and technical manuals. Responsible of ongoing maintenance to tweak and improve the performance of the application as well as the development of new features. - Creation of adhoc reporting tools. Responsible for the design and data integrity of numerous statistical reports using MS Access, MS Excel and Crystal reports. Data analysis tools created using complex queries, nested queries and multi-joins with several tables. Use of the DDL and DML SQL queries. ODBC connection to import and process data from Lotus Notes. Transfer of data via XML to Oracle database. - Migration of existing multi-user application from MS Access 97 to MS Access XP. Redesigned and restructured an existing application called Legal Bills that had been poorly designed and abandoned. Investigated the application and constructed a new design that would accommodate the client's needs.
Work Experience
| COMPANY | POSITION HELD | DATES WORKED |
|---|---|---|
| Lend Key Technologies Inc. | Software Engineer | 3/2012 - 8/2014 |
Accomplishments
Highlights:
Keywords
