Hi Friends,

Even as I launch this today ( my 80th Birthday ), I realize that there is yet so much to say and do. There is just no time to look back, no time to wonder,"Will anyone read these pages?"

With regards,
Hemen Parekh
27 June 2013

Now as I approach my 90th birthday ( 27 June 2023 ) , I invite you to visit my Digital Avatar ( www.hemenparekh.ai ) – and continue chatting with me , even when I am no more here physically

Translate

Thursday, 14 September 2000

PURCHASE ORDER

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:

  1. ONLINE RESUMES ($\rightarrow$ E-mail)
    • 3pjobs.com
  2. E-mail ($\rightarrow$ Module 1)
    • (ISys)
  3. 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
  4. 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