The EZ Pharma project is related to Pharmaceutical Company which manufactures medicines.The Project “Eazy Pharma” is an optimum solution to all Pharmaceutical companies which assists them to obtain orders from its distributors who are geographically scattered. To retain and provide information about manufactured stock, dealers, vendors (raw material suppliers), category details etc., & to provide online interface between pharmaceutical company and dealers. The new implemented system not only takes the orders from distributors for Pharma companies but also facilities the administration in reviewing the stock, as well as the various report generation for the firm. The project is a web-based project, which maintains vendors, product categories of various types and their description for which they supply. The Category wise products under each category, discount, and payment modes such as Cheque, and online payment mode like Credit Card,debit card etc. The system also maintains the order details, to provide the valuable reports regarding sales to the organization whenever and whereever needed for the administration and analysis of sales for the organisation. The EZ Pharma system also enables us to open the website from any location and place orders and makes the distribution and sale very cost efficient by maintaining the details of supplier location and customer location. A detailed report of customers available in that location is driven which helps the supplier supply the medicines to a near by location and there by reduces the cost of transport. This ensures the value of cost of product to reduce its price and also makes it profitable for the pharma companies.

Legacy Data Migration Tool (LDMT) is a very powerful yet easy to use data movement facility that can transfer data. It enables data movement between data sources (Access, Oracle, SQL server). The database administrators and application developers can benefit significantly from Data Transformation Services by understanding what it has to offer them, particularly while working with High level databases (Oracle, SQL Server). LDMT is an innovative database migration product that easily converts data from one database to another. Migration toolkit automates the entire migration process of converting data, database objects. Manually converting data from one database to another is risky and it takes long period of time. So, by using this LDMT toolkit we convert the tables from one database to another with less time, more accuracy and error free. Due to some disadvantages with some databases, For example, we want to convert data from Access to other database like Oracle. In this project, we are going to develop a toolkit, which convert the data from Source database to target database (Access, Oracle, SQL etc) using .net language.

The supply chain networks are becoming more complex because of the global imbalance in the labor market. These costs are forcing many firms to source from other countries that provide less expensive labor. The Supply Chain Management Project mainly helps the firms to control their production costs so as to remain competitive in the market. The other reason as to why the Supply Chain Network is becoming more complex is because of multiple customers and consumers of products and services of various firms. They are increasingly becoming more sophisticated. The customers are demanding more customized products and services, in the markets with better services, products, and goods to meet their various needs. The product variations in the market is making the demand forecasting became even challenging. The firms are made to predict on both the option mix and volumes. This is instead of the solitary demand model that they were accustomed in the production of products for customers. Moreover, the increased various product types have resulted, into a larger number of manufacturers and suppliers, to administer higher harmonization costs. This has made the firms that are in the same supply chain, to coordinate with each other, so as, to optimize their processes. The complex network of warehouses, suppliers, factories, and distribution and retail centers, make the success of the Supply Chain Managements to be difficult. This calls for better process management of the system components in order to succeed in the complex networks. The aptitude of a business to route information and make quick, but, the correct decisions are the key to a promised growth. Therefore, it has become essential to estimate and forecast the supply and demand of the unprocessed materials. This is from the point of sale locations and reorganizing the structure of business where it is needed. An organization needs to integrate both the material flow and information so as to realize the objectives and goals of a system. The integration can make the system be, in a position, to provide access to information, execute, and help in decision making processes. The conventional ways of managing the supply chain have transformed over the years. Our Logistics Supply project on the new application system that we have implemented enables a face to face management, paper dominated order processing systems, automated tracking systems, and wired communications. These are the tools that the supply chain managers are been provided with to enhance the supply based on the requirement. This change has benefitted to the many existing and new systems like extranet and intranet, e-business, e-procurement, electronic internet marketing, and the use of internet in the administration of the supply chains. The digitization and information technology has huge impacts on supply chain and their management.