MIS

Executive Summary

Our customer is a leading provider of cutting edge Silicon Design, Embedded Systems and Software services. The customer wanted us to develop a system which eliminates the manual generation of reports and invoices. 

ennovate team successfully executed development and testing of Management Information System allowing generation of invoices, reports and alerts on occurrence of particular event. 

The Customer

• Our customer is a leading provider of cutting edge Silicon Design, Embedded Systems and Software services. Their capabilities include knowledge of silicon design and verification, high-speed board design, embedded firmware and application software development. The company's India and US design centers, have delivered system level solutions to a variety of customers.
• Management Information System is one of their in-house product developments.

The Challenge

• The Account department generates all the invoices and reports manually, which may lead to human error. MIS allow users to generate invoices, reports like Balance Sheet, Bank Reconciliation Statement and alerts on occurrence of particular event. The system also allows generating the consolidated revenue reports for each subsidiary company.

The Solution

• Includes subsections like
  • Service Model Definition
    • It includes Automation for invoice generation for einfochips customers based on contract terms and work done by engineer
    • Consolidated Revenue Report for each subsidiary company
    • Sales Realization Report helps company to recover past dues
    • Email notification to customers to remind them for clearing invoices
    • Import of legacy data (from 3rd party software like QuickBooks and Tally)
    • Generation of Balance Sheet, which provides a snapshot summary of what your business owns or is owed - assets - and what it owes - liabilities - at a particular date
    • Bank Reconciliation Statement helps the company to compare their personal bank account, records to the bank's records of the individual's account balance in order to uncover any possible discrepancies
  • Design & Development
    • ennovate team was involved in Requirement analysis and feasibility of the project
    • We defined service oriented architecture for scalability
    • The project is a windows based application developed in C#.Net
  • Testing
    • Testing types which were applicable for this project were Data and Database integrity Testing, Functional Testing, User Interface Testing, Performance Profiling, Installation Testing
    • Data and Database Integrity Testing :
      • The database is tested as a subsystem with in MIS Application
  • Functional Testing:
    • The goals of this testing was to verify proper data acceptance, processing, and retrieval, and the appropriate implementation
  • User Interface Testing:
    • The goal of UI testing was to ensure that the User Interface provides the user with the appropriate access and easy navigation throughout the application
  • Performance Profiling :
    • The goal of Performance Profiling is to verify performance requirements have been achieved
  • Installation Testing:
    • The purpose was to insure that the software can be installed under different conditions and once installed, the software operates correctly

The Hurdles

• MIS is involved in Importing and Exporting Data to and from Tally & QuickBooks. The challenge here was, as Tally and Quick Books are external software’s, in case they change, it might affect MIS

• So to overcome it, the MIS xml templates were made compliant with Tally before company migrate to any new version of Tally

• MIS development started in early 2007 and since then it has successfully came over all the challenges and hurdles with the sheer hard work of ennovate team members

The Technology

• Technology: .NET 2.0, C#.NET, Windows Service, XML, Web Service, SOAP, XSLT
• Database: Oracle 9i
• Web server: IIS
• OS: WindowsXP, Vista

The Benefit

• MIS helped the account department in generating crucial reports like Revenue, Sale Realization and Balance Sheet which are crucial part for decision making in organizations for smooth execution