Arran Technologies has in-depth experience in hosting web sites and associated databases. Configurations and security levels are dependent on the client's requirements. Our current configuration and setup has passed Price Waterhouse's "Internet/Intranet Attacks" security audit.
Since 1994, we have been helping our customers manage and support their networks from both a technical and application standpoint. We provide ongoing support to our Outsourcing Service Clients in the areas of network design, security, and disaster recovery.
Arran Technologies enjoys a caliber of staff that compliments the technical support services we provide to our customers. Our technical personnel hold certifications in:
Microsoft Certified Professional - SQL Server 6.5 and SQL Server 7.0
Operations/Data Center Disaster Planning and Recovery
We develop security solutions to conform to customer requirements and specifications. If applicable, Arran Technologies will suggest security solutions.
Arran Technologies provides system architecture services to our customers. We work with the customer to identify the best-fit solution to their information technology needs. We have experience in Setting Up, Administering and Securing the following hardware platforms and software products:
Business success today requires more than mastering markets – it requires mastering information. Organizations capable of leveraging their business information gain a key competitive advantage in an increasingly global marketplace. Business Intelligence Deployment is the process that provides this in-depth information for your business.
Arran Technologies focuses on developing value from our client's transactional business systems by providing Data Warehousing and OLAP (On-Line Analytical Processing) solutions for business analysis and decision support. Our experience in deploying this technology empowers us to deliver information to our clients in such a way that ‘knowledge workers’ can make better and faster informed decisions. This type of expertise has also been central in providing our customers with Systems Integration capabilities.
Areas of expertise and experience include:
Data Warehouse Design and Development
Data Modeling and Database Administration
Specialized Knowledge in Selected OLAP Tools
Cognos Powerplay
Brio
Express
Seagate Worksheet
Microsoft SQL Server 7.0 OLAP Services
Data Transfer Products and Services
Our experience in capturing and reporting information spans multiple databases:
Internet web sites give corporations an effective means of promotion and provide an opportunity to reach prospects, provide e-commerce and web hosting services, establish profitable relationships with customers, and communicate with employees who potentially can be scattered around the globe! Day-to-day business issues are resolved through enhanced communications, collaboration, and accelerated information access.
Since 1994, we have provided our customers with web based application development services to address their Internet, Intranet, and Extranet requirements. As a leader in web based solution development, we work with our clients in building custom applications to meet their specific business needs.
Application design/development services include:
Web Concept Design Services
Graphic Design Services
Web Application Development
Customer Business Applications
Database Driven Applications
E-commerce Business to Business Applications
Conversion of Legacy Databases to Open Systems
Application Modernization and Integration Services
Arran Technologies has extensive experience in converting and transforming data and applications from legacy systems to ODBC compliant databases and product suites. Our dominant legacy database is MAPPER. In addition to MAPPER expertise, we are experienced in converting multiple data sources (Excel, Flat Files, Access, AS400/DB2) to "Other" destination databases.
Our approach in integrating disparate data sources into target databases has proven to be effective as evidenced by our many successful projects.
Successful Data Conversion projects include the following legacy and ending platforms:
MAPPER to Oracle
MAPPER to SQL Server
AS400/DB2 to Oracle
Microsoft Access to Oracle
2200 Flat File to Oracle
Flat Files to SQL Server
MAPPER to Access
Excel to Oracle
Our data conversion methodology is one of a phased approach with several re-iterations to validate the conversion rules and test the conversion process.
Significant elements of our process include:
Identify Source of Data for New Applications
Clean-up Legacy System Data
Extract Legacy System Data
Manipulate Legacy System Data
Populate Applications
Unit Test Manipulation Programs
Execute Conversion String Test and Mock Conversions
Validate Converted Data
Visual Representation of Arran Technologies Data Conversion Model:
