Mr. K. Sudhakar
Manager - Sales
Applitech Solution Limited
Ahmedabad.
Sept. 14, 2000
Dear Mr. Sudhakar,
Purchase Order
Please treat this as our Purchase
order for development & installation at our premises, a customised software
for Internal Management System for Order Execution & MIS.
This order is being released in
response to your revised offer dt Sept. 12, 2000, but with following changes as
agreed upon over telephone yesterday and in our meeting this morning:
Price
The price will be Rs. 8.25 lakhs
(Rupees Eight Lakh and Twenty-five Thousand only).
Penalty Clause
For each phase, you have
quoted certain no. of days
required to complete the phase. These are given in Annex: A.
From this Annex: A, completion
date will be calculated for each phase. This will be called "Phase
Completion Date" (PCD).
For any delay in actual
completion of a given phase, beyond PCD, a penalty will be levied at the rate
of 0.5% of the total order value for each week (or part thereof) of the
delay. However, the total penalty will be limited to 5% of the order
value.
Start of the Project
Allowing you 10 days to mobilise
your manpower resources and for intimating to us, the names/
qualifications/past experience of your team-members who will work on our
project, Phase I shall commence on Monday, Sept 25.
Phase-Wise Completion Dates
These will be as per Annex: B
If there is a likelihood of delay
in completion of any phase, you will inform us in writing about the same in
advance. This will, however, not change/alter the PCD as far as the application
of Penalty Clause is concerned.
By same token, any time saved in
completion of an earlier phase, could be utilised for execution of the
subsequent phase, without altering the PCD for the subsequent date.
Other Terms & Conditions
These will remain same as per
your offer dt. Sept. 12, 2000, except to the extent as modified above.
Enclosed, find our cheque No 412944 dt 14/9/2000
for Rs. 1.65 Lakhs.
Kindly sign & return
duplicate copy of this letter by way of your acceptance.
With regards
H Sarabh
J.P Consultant
Accepted:
Sign: [Signature]
Name: T.R. SUDHAKAR
Date: Sept. 14, 2000.
Annex: A
ORDER EXECUTION MODULE
(Internal Management System)
COMPARISON OF OFFERS BY
APPLITECH
|
Phase/Stage |
No. of Days Required to
Complete the Phase |
|
|
As per Aug. offer |
As per Sept. offer |
|
|
I - System Requirement
Study |
10 |
20 |
|
II - Design & System
Specs. Physical design. |
30 |
35 |
|
III - Coding/Testing/
Documentation/ User Acceptance Testing |
40 |
45 |
|
IV - Installation of
Software/Training |
20 |
25 |
|
Total |
100 |
125 |
|
V - Debugging till
fault-free Operation of Software. |
40 |
40 |
Annex: B
PHASE COMPLETION DATES
(PCD)
|
Phase |
No. of Days |
Starting Date |
Completion Date |
|
I |
20 |
Sept. 25 |
Oct. 14. |
|
II |
35 |
Oct. 15 |
Nov. 17 |
|
III |
45 |
Nov. 18 |
Jan. 1, 2001 |
|
IV |
25 |
Jan. 2, 2001 |
Jan 26, 2001. |
The entire project must be
completed by Jan 26, 2001.1
40 days time
allowed/permitted to Applitech for "Debugging" will not be counted
for Project Completion Date however the final 20% payment will be made,
not at the end of Ph2ase IV but only after the
"Debugging" period.
Crystal Reports Features
Easy to Use and Learn
- Use 1 of 15 Report Experts to quickly design
reports
- Smart Navigation™ quickly locates report data
- Over 100 ready-to-use, pre-defined reports (over 30
in standard version)
- Flexible design window (template) and preview
window (LIVE data) tab interface
- Sort and subtotal in ONE step
- Drag and drop, best fit, browse data field, right
mouse menus, undo/redo
- Precision formatting and placement of objects
- Comprehensive user and developer documentation,
including online user's guide and technical reference
Turning Data into Information
- Multi-pass reporting with powerful grouping and
sorting including Top N/Bottom, N and Named (custom) grouping
- Easy data selection with Select Expert query
interface
- Powerful Formula Editor with 160+ built-in
functions and operators for manipulating data
- Extensible formula language can be customized with
user-defined DLL functions written in Microsoft Visual Basic, Visual C++,
Visual J++, C, or Delphi™ cross-tab objects
- Use text objects to combine text fields, database
fields, and formula fields
- Include graphs in reports using any one of 80 fully
integrated and customizable styles
- Export to other tools such as spreadsheets
Flexible Reports
- Subreports: embed reports within reports
- Conditional sections/reports: produce different
sections/reports depending on data conditions
- Cross-tabs for summarizing information
- Form-style reports: easily output database
information onto forms
- Multiple detail sections
- Microsoft BackOffice reports: 12 pre-defined
reports for Microsoft NT Event Logs, Microsoft Systems Management Server,
Microsoft Exchange, and more
- Mail merge and mailing labels
Presentation Tools
- Drawing-style interface, rulers and guidelines
- Line drawing, box drawing and graphic image support
(BMP, BLOB, JPEG, PCX, TIF, TGA)
- Integrated customizable graphing - 80 styles in
16-bit and 32-bit
- Underlay images across report sections
- ActiveX (OLE) container
- Print page X of Y
- Customized Formula Editor & formula control of
formatting
- Text objects combine text, fields, images and more
in flexible objects. Edit each element independently
Efficient Report Distribution
- Integrated Email capability (VIM, MAPI, Lotus
Notes, Microsoft Exchange)
- Distribute presentation-quality reports via the
Internet or Intranets
- Other export formats include HTML, Excel, Lotus
1-2-3, Word, WordPerfect, ODBC, text, and more
- Export or Email reports with saved data (result
sets) for mobile or remote analysis
- Compiled reports for free distribution or
executable reports
- Scheduled reports for automatic processing and
distribution
Rapid Application Development
- Seamlessly integrate reports into Windows and
web-deployed database applications
- Automation Server Interface and Object Library
- Event/call-back support
- ActiveX (OLE/OCX) Control
- Visual Basic Custom Control (VBX - 16-bit only)
- MFC Class Library with AppWizard (32-bit only)
- Delphi Visual Component Library (VCL)
- Informix-NewEra Class Library
- Report Engine DLL
- Active Data Driver for easy integration with Visual
Basic applications, DAO, ADO, RDO, memory blocks and grids FREE runtime
Web Reporting
- Crystal Web Report Server for web-deployed reports
on Microsoft Information Server, Netscape Fast Track, and Netscape
Enterprise Server
- Page-on-demand thin-wire technology allows users to
pull reports from the server a page at a time as required
- Dynamic data refreshes updated reports on demand
- ActiveX, Java and HTML Smart Viewers
- Crystal Active Server Component integrates reports
into Active Server Pages (ASPs) for adding reporting to web-deployed
applications
Native PC Data Access
- ACT! 2.0, 3.0
- Btrieve (requires DDFs)
- Clipper (NTX)
- dBASE (BDE, MDX, and NDX - 16-bit only)
- FoxPro 2.6 (IDX, CDX)
- Microsoft Access 1.0-2.5, 7.0 (Jet and DAO) and
Access Queries (DAO)
- Microsoft Jet and DAO Engine
- Paradox 3.5-4.5 and 3.5-7.0 (BDE)
Native Client/Server and
Network Data Access
- Arbor Essbase
- IBM DB2, DB2/2, DB2/400, DB2/6000
- INFORMIX
- Microsoft Exchange
- Microsoft Internet Information Server
- Microsoft Systems Management Server
- Microsoft SQL Server (Native and InterSolv
DataDirect)
- Microsoft Windows NT Event Logs
- Oracle 7.2, 7.3, 8.x
- Scalable SQL
- Sybase SQL Server 10, 11
- Web Server Activity Logs (NCSA format)
ODBC Data Access (drivers
included)
- ASCII
- dBASE
- IBM DB2/2
- INFORMIX
- Lotus Notes (16-bit only)
- Microsoft Access 1.0-2.5, 7.0, 8.0 and Access
Queries
- Microsoft Excel (XLS) 4.0, 5.0, 7.0, and 8.0
- Microsoft SQL Server
- Oracle
- SQLBASE by Centura (formerly Gupta)
- Sybase SQL Server 10, 11
- Microsoft Visual FoxPro 3.0
SQL Features and Tools
- Create Data Dictionaries (meta layer) that simplify
database structures
- Convert between database drivers
- Stored procedure support (Microsoft Access, Oracle
7.2, Sybase, SQL Server, and Watcom)
- Process queries, including aggregate functions, on
SQL servers
- Query tool with SQL editor
System Requirements:
Hardware requirements for running
Seagate • Crystal Reports 8:
- 32-BIT • Microsoft Windows 95, 98, 2000 or Windows
NT (ver 4.0 or higher) • 30 MB hard disc space (full install 210 MB) • 32
MB RAM Windows NT & Windows 98 • 486 or higher processor • CD-ROM
Crystal Reports
|
Pro Edition V8.0 |
$395 |
|
Pro Edition V8.0, W/ 1Yr Sub |
$495 |
|
Pro Edition V8.0, 5U W/ 1Yr Sub |
$1995 |
|
Developer Edition V8.0 |
$495 |
|
Crystal Reports Developer
Edition 8.0, 5 User |
$1985 |
|
Crystal Reports Developer
Edition 8.0, 5 U W/ 1 Yr Sub |
$2485 |
|
Crystal Reports Developer
Edition 8.0, W/ 1 Yr Sub |
$595 |
Application Development
If you're a professional
developer using reports in your applications, Seagate added some new features
you might appreciate. Seagate Crystal Reports 8.0 now makes integrating reports
into applications even easier and gives you further choices that help lever
your existing skills and development tools. At the same time, it's even easier
for end users to interact with your applications and quickly find the
information they need.
Oracle Discoverer
Ease of Use
For non-technical, business
oriented end-users, usability of access tools is the single most important
consideration. Discoverer provides a unique interface, where users interact
directly with the data with which they are familiar.
Unique Development Approach
Given the importance of the user
interface, a completely new approach to development was taken with Discoverer.
Instead of developing the product and then fine-tuning the user interface, the
user interface was developed before any software development activity was
started. User interface design specialists spent six months working with
customer groups to ensure that the design was correct from an end-user
perspective as opposed to a development perspective. The development of the
product started only after the user interface was finalized.
The net result of this innovative
approach to development is an interface that provides unsurpassed usability
with an intuitive look and feel. This is also evident from the reaction in the
user community and the press.
- Discoverer won PC Week's Analyst's Choice award in May
1997. Discoverer's scores were:
- Usability: A
- Capability: A
- Manageability: A
- Discoverer won the DM Review Readership award for
the Business Intelligence - Managed Query Environments category in late
1997.
- In November 1997, American Institutes for
Research placed Discoverer as No. 1 in an independent competitive
usability test, for its ease-of-use and user interface design.
- Discoverer for the Web, the version of Discoverer
that is able to run from a web browser, can be deployed with minimal
effort. Its user interface design closely follows the design of the
windows release which means no retraining is required.
Performance
- Users reap the performance benefits of Discoverer
through its easy-to-use interface. Discoverer optimizes performance,
transparently to the end user, in all 3 layers involved in providing user
functionality: server, network and client, to provide fast and reliable
access. Discoverer's unique query prediction feature protects performance
of queries, enabling users to take a priori action in using the
system to maximum efficiency.
Navigational Power
- Discoverer provides a high level of navigational
power through the "drill" paradigm. Users drill through their
data, from highly summarized down to higher [The last line seems cut off,
should probably be "down to more detail or lower levels."]
levels of detail and vice versa.
Users also drill across data to move from one frame of reference to another.
The Hyperdrill feature enables users to drill from summarized data to actual
transactional detail records. The drill paradigm extends to enable end-users to
even drill out of Discoverer into other desktop applications, including
Microsoft Word, Web Browsers, multimedia applications, and more.
Centralized Administration
The Discoverer End User Layer
(EUL) is a server-based business abstraction layer. Discoverer stores metadata
once in the EUL, which is a set of tables stored in the database. This allows
for easier creation, maintenance, and access of the centrally maintained EUL.
This centralized architecture has several advantages:
- Modifications made once in the EUL are reflected
immediately when the users connect to Discoverer. Users are added to the
system without undue burden on the system or the administrator.
- Discoverer takes advantage of the security features
of the particular database.
- The EUL can be built right 'on top' of, any
underlying architecture of the data warehouse -star schemas, normalized,
de-normalized, etc...
- The EUL can be backed up by the regular database
backup mechanism.
- The Refresh option can be used to resynchronize
changes in the source database repository with those defined in the End
User Layer to ensure that users are querying all available data.
- Discoverer for the Web is able to use the same EUL
as the windows client - which means virtually no administrative costs and
zero costs to view a Discoverer report, stored in the database, from a Web
client. Both the Web and Windows releases of Discoverer are able to access
the same saved and scheduled "workbooks" stored in the database.
Scaleability
- The Discoverer architecture leverages relational
databases (RDBMS) as both a repository for metadata and data. The Oracle
database server has proven time and again its ability to grow as the needs
of an organization grow. Discoverer takes advantage of the ability of the
Oracle database server to handle large numbers of users and large volumes
of data to provide high performance queries and high throughput.
Discoverer also works against non-Oracle ODBC data sources.
- In the Web environment, as many Discoverer Servers
may be deployed as possible to ensure load balancing, high performance and
scaleability.
Business Business Intelligence
Features
- The business decision making process varies in
complexity depending on the situation. Due to its variability, tools used
to support this process have to be flexible enough to support different
ways of accessing information. Discoverer
provides a high level of
flexibility and support to suit the diverse needs of decision makers.
Analysis Approach
- The need to access information may arise due to a
specific question such as "What percentage of my purchasing dollars
go to each of my vendors?." Or, in some cases, the question is more
general. A question such as "Is there a pattern in price discounts
that are offered to customers?" falls into this category.
- The difference is that the information needed to
answer the first, more specific question is easily identifiable and is
relatively constant. The second question is less deterministic in terms of
what information is needed to come up with answers. Should one look at
discounts across products, channels, time periods or geography, or a
combination of these, to identify patterns? Discoverer supports the latter
through its intuitive interface, which enables users to rapidly change the
dimensions along which information is queried and viewed. For example,
changing from a view which presents discounts across products and time
periods to discounts across sales channels and geography takes only a few
clicks of the mouse. This flexibility enables end-users to identify the
correct "frame" to utilize for their decisions.
- Discoverer supports specific questions through
"workbooks" which are saved and reused many times.
Discoverer automates the execution of "workbooks" on a
regular basis, if needed, so timely information is available to the
end-user with minimal effort.
Aggregations
- Large amounts of information are efficiently
analyzed by aggregating the information and drilling down to higher levels
of detail. Discoverer automatically aggregates data appropriately based on
the information analyzed. Discoverer modifies the aggregation as users
drill down or up through their data. For example, in a query with Region
and Profit, Discoverer aggregates Profit up to the Regional level. As the
user drills down into a particular Region to view Profit at the City
level, Discoverer aggregates Profit for that Region up to the City level.
Users also easily modify the type of aggregation as necessary, i.e., Sum
of Profit is easily modified to Average Profit.
Exceptions
- When working with large amounts of information, it
is useful to have key facts highlighted. Order volumes that are unusually
high or higher-than-normal, is an example of information that needs to be
highlighted. Discoverer enables users to define key facts and highlight
this information visually using a "traffic light" style effect.
Users focus on this immediately and perform further analysis such as
drilling to detail records or identifying trends. Such analysis leads to
decisions that take advantage of early signs of market change, operational
issues, and so on.
Visual Analysis
- Presenting information in a visual manner is useful
in identifying trends and anomalies. Discoverer supports reporting
information through several types of graphs - line, bar, pie, area, etc.
These graphs add to the impact of information when added to executive
reports and reports published on the web.
VALUE PROPOSITION
- Companies implementing Discoverer as a component of
their business Intelligence system reap the benefits of an analytically
powerful and high-performance product. Companies gain the ability to make
better and faster decisions, increased productivity, and a better equipped
employee workforce. These benefits translate into better informed
decisions, more efficient business processes and ultimately, competitive
advantage in the marketplace. End-users realize immediate productivity
gains with the intuitive user interface and powerful analysis and
presentation capabilities of Discoverer. Administrators experience savings
in time and money from the reduced maintenance overhead.
SUMMARY
- Discoverer enables the organization to explore new
business dimensions and understand exactly what factors are affecting and
driving the business. Companies can analyze different facets of their
business and gain the insights needed for informed decision making. Using
Discoverer, companies build business intelligence systems that fully
leverage their data assets to gain a competitive advantage in the
marketplace.1
Discoverer solves many of the
problems normally associated with databases so that now you can easily:2
- Find data that you know is in the database.3
- See data displayed quickly without waiting for the
computer to spend a long time searching through the entire database.4
- View data in a familiar format that is easy to read
and understand.5
- Analyze data using a wide array of techniques
including drilling up and down through the data's details, finding data
that meets certain conditions or that falls within ranges you specify,
sorting data, comparing results from "what if" scenarios, and so
on.6
- Prepare reports of your analytical results and
findings.7
- Share data 8with others, and in other
applications (such as Excel).
Presenting Data on a Graph
- Discoverer User Edition can convert tables and
crosstabs to graphs or charts so you can analyze and present data
graphically. Graphs and charts of tables and crosstabs are especially
effective for presentations of results.
- The features of a graph
- Creating graphs
- Modifying a graph
Pivoting, Drilling and Sorting
Data
This chapter explains how to find
and arrange the data that you want to analyze. The topics include:
- Pivoting data
- Drilling into and out of the data's details
- Sorting data9
Pivoting Data10
- Laying out data on a table or crosstab organizes it
so you can easily compare results side by side, spot trends when you see
progressions, track progress over weeks, months and years, and so on. In
other words, how the data is arranged is an important aid to analy11sis
because it reveals data relationships that may not be apparent.
- Pivoting data is how you move the data from one
axis to another to arrange it for efficient analysis. For example, you can
pivot data from the body of the table or crosstab to the page axis and
back again to see new data relationships.
- One way to think about pivoting data is to
visualize the data plotted on a graph, and then switching data from the
x-axis to the y-axis.12
Pivoting for Comparison and
Analysis13
- Pivoting a column on a table from the body to the
page axis or from the page axis to the body rearranges the order of the
data as it is presented and helps you organize the data. On a crosstab,
however, pivoting a column has a much different meaning because the
positions of data columns determine the data interrelationships of the
items on the crosstab. Therefore, pivoting a column on a crosstab not only
changes the positions of t14he data-you may see different
numerical values as the data relationships vary.
Drilling Into and Out of Data
- Drilling into data shows more details about the
data. Drilling out of data consolidates the data for a broader overview.
Typically, you drill into data to analyze it at a finer level of detail,
and drill out to get the "bigger picture."
- In addition to drilling into and out of data on the
current table or crosstab, you can also drill to another worksheet, or to
related item that isn't on the worksheets.15
- Drilling directly from a table or crosstab by
clicking a drill icon is the quickest way to drill, and covers many types
of drilling typical in routine data analysis.16
- Dr17illing from the Drill dialog box
provides even more options for drilling.
Sorting Data
- Sorting arranges text data in alphabetical order
and numeric data in numerical order. Creating an ordered list of
customers, or employees, or product part numbers are typical uses of
sorting. However, sorting is also helpful in analyzing data. For example,
sorting sales data from most profitable sales to least profitable sales
shows the relative standing of your company's best selling products or the
most effective salespeople.18
- You can also group data and then sort within the 19group.
For display and reporting purposes, each group of data can start on a new
page.
Applying Analysis Tools to
Your Data
- The process to apply analysis tools to your data is
basically the same for each tool. You can turn on the tool to analyze
data, turn off the tool to return the data to its previous form, edit the
tool definition to change the analysis, create new definitions, and apply
the tool definition selectively to one or more items.
Reporting Results
This chapter explains how to
create reports with Discoverer User Edition. Topics in this chapter include:
- Preparing reports for printing and previewing
- Sending reports with e-mail
- Exporting to other applications
- Producing scheduled reports
- Sharing worksheets
Preparing Reports for Printing
- Tables and crosstabs are displayed in a format that
easily lends itself to reporting of results. Additional options, such as
adding headers and footers, page numbers, and the date, help you prepare
the report for printing.
Sending Reports with E-mail
Messages
- You can send worksheets, graphs, and selections of
a table or crosstab as part of an e-mail message. This feature is
available for most e-mail applications, however, if it does not appear on
the menu, your e-mail application does not support the feature.
Exporting to Other
Applications
- You can export tables and crosstabs in a variety of
formats to open them in other applications. For example, you can export a
table to a Microsoft Excel workbook or a Lotus 1-2-3 spreadsheet and then
use Excel or Lotus 1-2-3 to open the table.
Producing Scheduled Reports
- Scheduled reports are workbooks set to run at a
specified time. For example, you may want to run a worksheet at the end of
each month that calculates monthly profits from monthly sales figures, or
run a report every two weeks based on a worksheet that produces a biweekly
cash flow analysis.
- Often, worksheets that you want to use for
scheduled reports are designed specifically for that purpose, rather than
being a worksheet for your day-to-day analysis. For example, the worksheet
may include special calculations or conditions that produce the results
you want for the scheduled report on a periodic basis only.
- You can select all or some of the worksheets in a
workbook to run as a scheduled report. Typically you schedule reports if:
- The report will take a long time to run;
scheduling a report to run at night or on the weekend avoids
overburdening the server during normal working hours.
- You run a report at regular intervals, such as
weekly report of sales figures or a monthly cash flow analysis.
Because a scheduled report runs
on the server, you do not need to leave your computer running overnight (or
whenever you schedule the report to run). The results of running the scheduled
report are saved on the server as well and, therefore, are available when you
log on to the server and start Discoverer.20
Sharing Workbooks21
Sharing a workbook grants other
people access to it to view, analyze, and print the data. You can share
workbooks with other people by setting up sharing two ways:22
- Assign a group of people who can share one of your
workbooks.23
- Assign one or more workbooks that one other person
can share with you.24
- Sharing workbooks lets others use and analyze the
same data. For example, you may want everyone in the accounting department
to share a workbook that includes accounts payable and accou25nts
receivable information. Similarly, you may want a project manager to have
access to all the workbooks created for the project.
Advanced User Edition Features
- Discoverer User Edition includes several advanced
features for working with data. This chapter describes those features and
explains how to use them.
- The advanced features are:
- Retrieving Rows and Counting the Number of Rows
- Creating Parameters
- Creating Calculations
- Creating Advanced Conditions
- Creating Options
- Using Command Line Options
- Importing SQL
Retrieving All Rows and
Counting the Number of Rows
- Rows for tables are fetched from the database
incrementally in groups. The number of rows in each group is specified in
the Options dialog box based on the value set in the option "Retrieve
data incrementally in groups of:". Click the Query Governor tab on
the Options dialog box to see that option.
Creating Parameters
- Parameters are placeholders used instead of
specific values in the definition of a condition. Unlike regular
conditions that find the same data each time they're applied, parameters
offer choices at the time the worksheet loads.
- For example, suppose one of your routine analysis
jobs is to compare sales performance by evaluating sales figures for
various products from different groups of cities. By creating two
parameters-one for products and the other for cities-you can select the
specific grouping of data for the analysis at the time the worksheet
loads.
- Parameters are particularly helpful if several
people use the same workbook or worksheet. Each person can select the
parameters that load only the data of interest on the worksheet.
- Parameter selections appear when loading a
worksheet. Here's an example that shows a parameter for limiting the
available data to two cities and one department, Video Sales.26
Creating Calculations27
- Calculations produce additional data for your
worksheets. Simple calculations based on the data in a worksheet can
produce typical business answers, such as sales commissions per
salesperson, royalty fees paid to a supplier, and so on. Complex
calculations can find the answers to more complicated questions including
"what if" scenarios.28
- In other words, instead of merely viewing your data
to find trends and answers, you can use calculations to rigorously analyze
the dat29a using mathematical techniques.
- The results of calculations are displayed as new
columns on a worksheet, or the calculations can be part of other
calculations.
Using SQL
If you are familiar with SQL, you
can open workbooks with your own SQL programming statements.
|
Price |
|||
|
Discoverer Plus |
Named User Single Server |
1 Year |
$795.00 |
|
Discoverer Plus |
Named User Single Server |
2 Year |
$1218.00 |
|
Discoverer Plus |
Named User Single Server |
4 Years |
$1777.00 |
|
Discoverer Plus |
Named User Multi Server |
1 Year |
$995.00 |
|
Discoverer Plus |
Named User Multi Server |
2 Year |
$348.00 |
|
Discoverer Plus |
Named User Multi Server |
4 Years |
$597.00 |
bundled and/or renamed products
(Handwritten diagram)
12/9/2000
RESUME DATABASES - OFFLINE
A flowchart/diagram showing
the flow of resumes:
- ONLINE RESUMES ($\rightarrow$ E-mail)
- 3pjobs.com
- E-mail ($\rightarrow$ Module 1)
- (ISys)
- Module 1 (Central Processing/Database)
- (Search Engine Built-In)
- Receives input from:
- (2) E-mail
- (4) Direct & E-mailed resumes (ISys)
- Typed resumes (Manual) - with
"scan/OCR" arrow pointing to Module 1
- Floppies (X)
- (3) Databank F (ISy) - Arrow from Module 1
points to Databank F
- Databank F (ISy)
- Contains Typed/Saved resumes prior to 1997
- Input via "scan/OCR"
- Arrow from Databank F points to Module 1
From: headhunt@3p-jobsearch.com
To: manjiri@3p-jobsearch.com
Date: Thursday, September 07,
2000 12:16 PM
Auto Mail generated from enquiry
at www.3p-jobsearch.com
Programming by Nexxt Gen
Software.
ADVT- RELATED DETAILS.
Adv. No: 823
Full Name: Aruna P
Designation: Director
Company: TASC Consulting Pvt Ltd
Product/Services: Documentation
and Courseware development
Consultant:
Address: D2/10 Khira Nagar, S.V.
Road, Santacruz (w)
City: Mumbai
Zip: 400054
Country: India
Phone: 91-22-6142686
Fax:
E-mail: people@tascindia.com
JOB RELATED DETAILS.
Job Designation: Courseware
Developer
Function: Create CBTs, WBTs and
Instructor led training
No of vacancies: 1
Posting City: Mumbai
State: Maharashtra
Country: India
Approx Salary: 7000
Our Client: INFORMATION
TECHNOLOGY
MAN SPECIFICATIONS.
Age (Max): 26
Exp (Min): 1
Edu-Qualification: Any
JOB REQUIREMENTS.
Languages Spoken: English
Knowledge/Job Role: Do you love
learning new technologies?
Do you write well in English?
If the answer to both these
questions is Yes!! then get in touch with us. We are looking for
courseware developers to join our team.
You will be part of a growing
team that develops courseware (Instructor-led, CBTs and WBTs) on cutting
edge technologies like XML, ColdFusion, IIS, Java, EJB
(Handwritten note): given
to Tapan on 12/9/2000
and much, much more......
To be a part of our team, you
must:
- Love learning new technologies.
- Have excellent English skills.
- Like to write.
- Have good communication skills.
- Be a self-starter.
- Have a sound foundation in any one of the following
technologies/tools: C, C++, Java, D/HTML, VB Script,
JScript/JavaScript, IIS, Visual Basic, SQL Server, Microsoft Developer
Studio, XML, ColdFusion or any other cutting edge technologies.
- Be based in Mumbai.
A career at TASC Consulting
begins with a 3 to 6 months probation period after which the candidate
is confirmed. During the probation, we will train the selected candidates on
the various tools of the trade, writing techniques and instructional design
principles.
Remuneration: Negotiable
Skills - Attitudes - Attributes:
Industry/Product Exposure:
Send me P.O.:
Comments:
Subject: Head Hunt enquiry
from web site
Meet
From: chetan chetan@3pjobs.com
To: aslbmy@bom3.vsnl.net.in
Subject: Meeting
Date: Saturday, September 09,
2000 12:45 PM
To,
Applitech Solution Ltd.
Mumbai
Kind attn: Mr Sudhakar
Sir,
You may wish to check-out www.ureach.com before
we meet next tuesday.
With kind regards
Mr. Sudhakar
APPLITECH
Mumbai
Sept. 7, 2000.
Dear Sudhakar:
Integration Of
Accounts/Finance Software Package with our ORDER EXECUTION MODULE.
I refer to our telecom yesterday.
I look forward to meet you on 12th inst at 11 am.
During our meeting on Sept. 1,
question came-up of integrating accounts package "TELLY" into
order-execution module. Ravi said you have tried to do this in the past
but it has not worked well.
On the other hand, Ravi
said that you have, yourselves, developed some Accounts related packages, which
can be, very well integrated with our Order Execution Module. You have
developed one package, specifically meant for "SERVICE"
industries.
During our meeting itself, I
requested
you to plan on such an integration
and let us have your cost-estimate for same. Of course, this transition
must ensure that whatever data we have, currently residing on "TELLY"
must be AUTOMATICALLY migrated to your Software package. There should be
no need to re-enter these data manually. This is a key requirement and I
would like to have your confirmation re: this aspect.
To give you an idea of what we
are looking for, I enclose:
Annex A:
Routine Accounts related
Activities
Annex B:
Finance Related Activities (MIS).
Most (but may not be all) of the
items covered under Annex: A, would require, either concerned CONSULTANT (who
is handling a particular SEARCH assignment) or a junior ACCOUNTANT, to key-in
necessary data into various screens.
Most of the output statements
mentioned
in Annex: B, should get automatically
generated, from the data already entered earlier by the CONSULTANT/
ACCOUNTANT. Of course, some fields may need to be entered later on.
Annex: A & Annex B,
very broadly describe requirement of Computerised system.
Since APPLITECH itself is
in "Service" industry, I suppose you must have already
installed such a system in your own office. As in our case, you too have many
Consultants, each of whom, is working on several "mini-projects/assignments"
simultaneously, at any given point of1 time. I feel the MIS needs
of Applitech & 3P are very similar and what is required is mere
extension to 3P, what you must have already implemented long time ago.
With regards,
H Sarabh
ROUTINE ACCOUNTS ACTIVITY
Annex: A
6-9-2000
|
ACTIVITY |
FREQUENCY |
|
|
Daily |
||
|
1. |
Preparation & entry of all
expense vouchers in computer |
$\checkmark$ |
|
2. |
Compile/Tabulate "actual
expenses incurred during last 2 years (Cost-centre wise) |
|
|
3. |
Entry of all Purchase orders
released by us on Suppliers |
$\checkmark$ |
|
4. |
Entry/bank depositing of all
cheque-payments recd from clients with invoice details |
$\checkmark$ |
|
5. |
Daily
reconciliation/Verification of Cheque Book/Pay-in Slip/Pass-book/Bank balance |
$\checkmark$ |
|
6. |
Maintenance of
"Imprest" a/c & Tally with "Cash-on-hand" |
$\checkmark$ |
|
7. |
Timely payment of all bills
(water/electricity/society/phone/supplies/service etc) |
$\checkmark$ |
|
8. |
Preparation & Despatch of
all Invoices (to clients) as per data given by concerned consultants |
$\checkmark$ |
|
9. |
Follow-up of each & every
Invoice, one week before due date. [Vigorous follow-up till full payment is
received & based on customer OUTSTANDING STATEMENT] |
$\checkmark$ |
|
10. |
Preparation of Client-wise
"Out of Pocket Expense" statement |
|
|
11. |
Follow-up of OOP invoices
payment |
$\checkmark$ |
|
12. |
Renewal of all Insurance
Policies (office-eqpt-car-medlclaim etc) |
|
|
13. |
Alerting & following up
with concerned responsible persons for timely renewals of all
"Service-contracts", before expiry date in each case |
|
|
14. |
Monthly trial balance/P&L
statement |
|
|
15. |
Monthly actual expense
statement (Item-wise) |
|
|
16. |
Filing of Income Tax Returns
(Co & family members) |
|
|
17. |
Timely payment/deposit of
TDS/Prof-Tax/IT/Service Tax/PF any other statutory levies |
|
|
18. |
Timely payment of
salaries/retainerships/incentives to all staff (as per attendance) |
$\checkmark$ |
|
19. |
Timely renewals of all
FDs/Creation of new FDs |
|
|
20. |
Maintenance of Fixed Assets
Register |
Note:
Routine accounting will cover
3P/Income
M I S.
Annex: B
6-9-2000
|
ACTIVITY |
FREQUENCY |
|
|
Daily |
||
|
1. |
Development of Cost-Centres
& Cost-Trends |
|
|
2. |
Compile/Tabulate "actual
expenses incurred during last 2 years (Cost-centre wise) |
|
|
3. |
"actual invoicing"
" " (several ways) |
|
|
4. |
Develop "NORMS"
for "expenses" based on: |
|
|
Staff strength Area No. of persons appointed No. of computers No. of telephone lines No. of consultants No. of clients No. of shopping baskets No. of Adults |
||
|
5. |
Develop a set of "ASSUMPTIONS"
for each cost centre/staff member who is likely to "incur" expenses
or "achieve" billing targets |
|
|
6. |
Develop "ANNUAL/QUARTERLY/MONTHLY"
budgets (for expenses) |
|
|
targets (for
achievements/billing) |
||
|
7. |
Prepare Budget Vs. Actual/
"Variance" Statements (for
expenses/invoicing/collection/customer Outstanding/appointments/partners
signed-up/resumes received/shopping baskets recd./Interviews
conducted/proposals submitted etc). To be done monthly (Qty Variance/Price
Variance/Assumption-Variance) |
|
|
8. |
Develop 3 monthly rolling
forecast for CASH INFLOW/OUTFLOW |
|
|
9. |
Prepare month-end "ORDER
BACKLOG" statement (Industry wise/Function-wise/Desig: level
wise/Client wise/Consultant wise) |
|
|
10. |
Same as above, prepare, monthly |
|
|
"ORDER BOOKING" statement |
||
|
Invoicing |
||
|
Collection |
||
|
11. |
Client-wise, chronological,
Invoice History/Payment Receipt History |
|
|
12. |
Supplier-wise, chronological,
Bill History/Payments made history. |
APPLITECH
Mumbai:
Sept. 6, 2000
Dear Sudhakar,
Order Execution Module
I refer to
your quotation dt. Aug. 21,
my note dt. Aug. 24
our meeting dt. Sept. 1
During our meeting you said, you
will meet us again on 11th Sept with your detailed proposal,
incorporating whatever features we discussed on Sept. 1 (and as
mentioned in my note of Aug. 24).
I await your phone-call.
In the meantime, I enclose news cuttings
re:
navin.com
Talisma e-CRM.
These may be of interest to you.
With regards
H C Parekh



























No comments:
Post a Comment