Description of information system – Database Management System
Background
In an uber globalized market of today, companies are faced with challenges in each and every step of their business. Our analytics and research services are geared towards giving those companies that extra edge over the competition. We process and analyze terabytes of data and break down all the fuzz and chatter around it to give our customers meaningful insights about their competition and the market they are engaged in.
By leveraging our data collection, processing, and research and analytics expertise and by focusing on operational excellence and an industry standard delivery model, we help the leading companies making insightful business decisions.
A comprehensive portfolio of our services include, Market, Business and financial research, Domain based analytics and Data processing services. Our industry wide focus is into Banking, Finance, FMCG, Insurance, Retail and Manufacturing industries.
Role and responsibilities
On studying the company’s profile, it seems that company has following resources which form the personnel of its information systems:
a. Chief Information Officer – It provides assistance to senior management on IT related tasks.
b. Develop and maintain IT infrastructure.
c. Develop efficient design to implement operations of the company.
d. Information System specialist – It designs and administers infrastructure development and support.
e. Database administration – Storing data and mining it for future goals of the company.
f. Project Manager – He/She will be responsible for managing the project issues.
g. System Analyst – He/She analyzes the whole system and conduct technical research. Also prepares documentation for future goals.
h. System Administrator – He or she will be responsible for resolving internal network issues of the company.
Data collection
a) SP-based data – It is the data collected over network traffic. It provides data to tool vendor. It does not collect secure data.
b) Panel based data – It collects internet user data.
c) Tool-monitoring data – It is installed at user end. Alexa is one of the examples in this category.
d) Online monitoring data – Here user takes survey and provides data to company.
Description of Information System
Positioning – The Company has online database for processing data, messages, batch and manual data input processing. It has two integrations: Vertical integration where processing of data is done for office area (ERP) and Horizontal integration where archival of data of various archival system takes place.
Databases include the open SQL database where process values, batch data and messages are stored. It provides client-server architecture for displaying data. Along with displaying of data, user can also evaluate data, analysis data and generate reports.
Hardware & Software
a) Hardware Server – P IV (minimum), 1 GB main memory, 100 GB hard drive
b) Hardware Client – PII (minimum) 500 MHz
c) Operating System Server – Windows 2000 Server or Windows 2003 Server
d) Operating System Client – Windows 2000 or Windows XP
e) Database Server – Sybase or Microsoft SQL Server 2000
f) Database : Sybase/Microsoft SQL Server
Additional Modules
a) Process Values (500 – 15.000 Values/min)
b) Messages
c) Redundant Coupling
d) Data Backup
e) Backup Server
f) Batch Archiving, Batch Reports (incl. electronic signature)
g) Manual Data/Value Correction
h) Excel Addin
i) Standard Reports
j) Document Archive
k) Electronic Signature
l) Interface “Web Server”
m) Parameter Control
n) Maintenance
o) Interface “Other Systems”
p) Development Toolkit
Type of Business
Web Analytics
The company’s expertise in Web Analytics includes the following functions :
Online traffic analysis
Content research and analysis
Conversion rate analysis
Data Mining and Social Media Analytics
CRM Analytics
Management of the Campaign from its Execution to completion alongwith ROI Analysis
Acquisition and Cross-sell/Up-sell Analytics
Customer Retention
Finance and Business research
The company’s expertise in Finance and Business research supports its client’s strategic decision making and day to day operations by assisting with intelligence, research and reports.
Detailed company and Industry based research
Tear Sheets and Company profiles.
Analysis of value chain, Stocks, Shareholdings and SWOT
Benchmarking of Industries and detailed sector reports
Business Intelligence
Market entry and positioning strategy
Trend Analysis and future predictions
Economic and Demographic studies
Corporate Finance and M&A Support
Support for preparing of Pitch Book
Benchmarks and Comparisons, LBO Models
Valuations and Financial Analysis
Equity Research
Financial Models and Predictions
Research Reports
Summaries of Earnings
Market research and end-to-end solution provider to corporate and research houses.
Survey Design
Researching proposal
Compiling proposal
Designing questionnaires
Survey Management
Survey Programming (Web)
Conducting Web Surveys
Online Panel Management
Data Management and Processing
Data Processing
Scripting and Coding
Data Transcription
Validating Data
Content Analysis (for Qualitative DIs and GDs)
Presentation/Report Writing
Validation of Report
Charting the Tabulated data
Presentation reports on major presentation software
Market Research Analytics
Brand Modeling
Consumer Modeling
Market Segmentation
Targeting
Marketing Mix
Outsourcing Activities
Offshore and outsourcing activities includes the following
Data Processing and Data Conversion -Data Collection and processing in MS Excel, CSV and Other databases format to SPSS, Quantum, SAS etc. for further processing.
Data Processing: Banner Tables
Data processing and converting in tabulated form
Data Processing: Data Analysis Services
Advanced statistical services to promote fact based decision making for companies.
Interfaces
The company’s IS has interfaces for evaluating data i.e. reports defined by users with MS Office (Excel and Microsoft word), standard components of software like Crystal reports and Business Objects. Since the company is less two years old, it is using Google Analytics as its web analytics tool.
Infrastructure and Security
The company has implemented security policies Enterprise Security Policy, Issue-Specific Security Policy and Systems- Specific Security policy. It follows NIST security model and follows IETF security architecture. It has chosen firewalls based on generation and structure. Along with this, it implements a type of Intrusion Detection and Prevention System. Privileges are defined for accessing Virtual Private Network.
