Projects > Solutions
1. Redesign database and web application to improve the performance and enhancements:
Aporia analyzed the existing application design and database structure, developed new database and application design and layout, developed the project plan, and developed the enhancements of the application.
2. New Application Requirement Study and Design:
The client engaged Aporia to conduct a requirement study, design and develop a web application in Microsoft .NET environment. The application was for in-house training and university of the employees.
3. Ship Security Assessment and Ship Security Plan Application:
As part of the project Aporia conducted a requirement study for both applications. Developed work flow and flow chart, hardware and software requirements for development, applications design concepts, time and budget requirements to develop the applications.
4. Operational and efficiency review for both Unix and Windows based servers:
Aporia conducted thorough review of all Processes, Applications and IT Systems, in order to determine the appropriate utilization of systems, proper selection of applications, and proper selection of databases for an oil and gas exploration and production company. This was a dual environment which included both UNIX and Microsoft server and desktop platforms .
5. Oil & Gas Well Lease Tracking Application:
This project involved developing a series of intricate production reports that used a reporting tool to access an extremely complex Oracle database. (The database schema had over three hundred normalized tables). Each report was documented.
6. Workflow Management Project:
This project was to assist the client's staff in defining and analyzing their needs in a work flow application, designing and writing a series of reports (both in tabular and graphical presentations) to address those needs, and setting-up the Meta Layer.
7. Reports development to provide ad hoc and production information on oil and gas well operations:
Aporia used a reporting tool to access an Oracle database. On this project, Aporia team worked with the employees actually using the reports to define, develop, test and approve our results.
8. Enhancement of performance and reliability of Microsoft SQL Server Database design and web application:
Aporia performed normalization, using correct data types, referential Integrity, using stored procedures instead of direct SQL calls, implementing indexes and triggers, populate and synchronize the new database and overall database design testing services.
9. Remotely configure and update Microsoft Exchange server:
The client engaged Aporia to configure and update an exchange server at a remote data center and then continue to maintain proper functionality of the server on an ongoing basis. This also involved migration of some older Exchange information from an existing server and a remote server to the new one.
10. Configure and Install a new Small Business Server (SBS):
Aporia reviewed and analyzed client’s server configuration requirements; developed the configuration and installation process, setup and installed the SBS and 2003 Server, setup the MS Exchange server and clients and tested the setup and usability of the system. Aporia also conducted training and documented the configurations on MS Exchange and other SBS administration.
11. Relocation of UNIX system -
The client engaged Aporia to conduct general performance review on its Unix System prior to relocating the system to another building. Aporia also recommended immediate and long term improvements for achieving optimum performance, efficiency and security. Aporia reviewed system connectivity, network set-up, system configuration, performance, data storage efficiency, software and hardware utilization and security standards.
12. Data Center Relocation:
This project involved the development of a comprehensive project plan using Microsoft Plan and then the execution of that plan to relocate sixty-five desktop computers, eight servers and the Local Area Network (LAN). This relocation project was successfully completed over a single weekend and did not disrupt the business’s normal operation.
13. Network slowdown Troubleshooting:
The client felt that the network was running slow for which Aporia did a thorough review of the health of the network and determine that the problem was broadcast storms and was able to recommend the appropriate changes to correct this problem.
14. Network Preventative Support Services:
The client had problems retaining the correct skilled network administrator for a variety of reason. We provided a network administrator to correct the preexisting problems, provide help desk support for Exchange, Citrix and the Local Area Network (LAN).
