Raghavendra. V. Samuga
Phone: (541) 850-8361[H]
E-mail: raghu_qad@yahoo.com
EXPERIENCE SUMMARY:
Over 5+ years of experience in the analysis, design and development of
QAD'S MFG/PRO(ERP Package) and PROGRESS(4GL& RDBMS) .
EDUCATIONAL QUALIFICATION:
· Bachelors of Business Management (Financials Major) from
Mangalore University, India (1996).
· Honors Diploma in Network Centered Computing from National Institute
of Information Technology(NIIT) 2 Semesters ( 1997) .
TECHNICAL ENVIRONMENT:
ERP Applications : MFG/PRO (Inventory Control, Purchase Order, Global
Requisitions, Sales Order/Invoice,
Distribution Requirement Planning,
General Ledger, Accounts Receivable, Accounts Payable,
Fixed Assets, Work Orders, Product Change control,
Material requirement planning) ,EDI
On Version 7.4h to Mfg/pro eB2.
CRM : Implementation & Training of Entice CRM at
Digiland Singapore Ltd
RDBMS : Progress(6.0,7.3,8.3B,9.1C,9.1D),
Oracle(7.1), Forms(4.2),Sybase, MS SQL
Languages : C ++ ,HTML
Packages : MS Office
Operating Systems : UNIX(HP, Digital,SCO) Windows – NT Win 2000
Professional , Novel Netware, MS-DOS
Hardwares : PC-XT,AT, 386/486, Pentium III,IV, Digital Alpha Server,
HP Server.
MAJOR ASSIGNMENTS:
Organization: Digiland Singapore Ltd /
GES Singapore International Ltd, Singapore.
Digiland Singapore Ltd which was set up to handle the sales, marketing and distribution activities of the GES group (www.ges.com.sg ) famous for its line of PCBA circuit
boards and Datamini (www.datamini.com.sg) computers and peripherals. Digiland has its operations through out the south east asia pacific region and it has its branches in Australia, Malaysia, Thailand, Philippines, Hong Kong etc. The MIS group of Digiland, handles all the ERP related issues within the company and also implements ERP for third party Companies.
1) Sep'03 - Nov'03
Mfg/pro Program migration from Ver 9.0 to eB2 for GES Singapore Ltd.
As GES Singapore Ltd was getting migrated from version 9 Mfg/pro to eB2, all the customized programs of old version, modified to be sync with the programs of Mfg/pro eB2.
Responsibilities as Application Specialist :
· Mainly involved in modification/testing of all version 9.0 customized programs .
· Modifications to existing CIM programs of Ver 9.0, so that it can work well in eB2.
· UAT(User Acceptance Test) of all the modified programs along with the users and fix the programs based on the UAT results.
Environment : Progress CUI (8.1B,9.1D), Mfg/Pro Ver9.0, eB2 on HP Unix .
2) Jul'03 - Sep'03
Conversion of Standard Cost to Average Cost for Eltech Electronics Ltd.
Eltech Electronics were using the standard cost as the main cost set for all their GL reporting. Later due to the operational issues they wanted to move their cost set from “Standard” to “Average”. The change in cost set mainly effects all the open work orders existing in the system. This project was mainly involved, in conversion of the cost set along with writing a few CIM programs for uploading, downloading of work orders, WO split , wo component issue , work order bill maintenance and work order release.
Responsibilities as Application Specialist :
· Extraction programs to extract only those WO related data where work order is open and wip cost exists for any work order, in a proper format so that the same set of data can be used to upload back into database.
· Analyze the impact of cost conversion with the users/user groups and find a suitable solution.
· Developed reports to cross verify the total wip cost and total open work order qty after the cost conversion.
· Development of CIM uploading programs which were used for uploading of work order maintenance, work order component issue, work order receipt, work order close , work order receipt and work order bill maintenance.
Environment : Progress (9.1C), Mfg/Pro eB on HP Unix .
3) Feb'03 - Jun'03
Implementation of MRP Module &
Central Procurement planning System for Digiland and its subsidiaries.
Central procurement system is a add-on module to Mfg/pro, based on the buyer code maintained in the system, buyers will approve the plan orders and thus it gets created as purchase order. Based on the total PO value, the PO has to be approved by the respective personnel; whose name and user id is maintained in the system. On each approval, system will send the e-mail notification to next approver and will be routed to the approver. Once the PO is approved by all the approvers, the PO will be confirmed and thus the warehouse people can do the PO receipts.
Responsibilities as Application Specialist :
· Creation of maintenance programs based on the plan order approval, system will build the PO through CIM and will send e-mail notification to the purchasing department.
· Involved in development of new maintenance program using browser, where the users can approve the purchase orders based on the total PO value, once the approval is done it will be routed to next level and will notify them by e-mail.
· Involved in the Customization of core Mfg/pro source code
to fit the user requirements.
Environment : Progress (8.1B), Mfg/Pro Ver.9 on HP Unix .
Customizations to Form trap related programs for GE Supply Asia Ltd through Singapore Computer Systems.
Form trap is a additional software which is used in GE Supply to print out the SO, Invoice and purchase orders in a pre-defined template with company logo, borders ,boxes etc. In brief, instead of customizing the standard Invoice print, SO Print, QAD provides a set of programs, which can be mainly used for form trap purposes. Based on the user requirement, additional columns has to be stubbed into the output data in a pre-defined way so that the same data can be used by form trap software to print the Invoice , SO and other documents.
Responsibilities as Application Specialist :
· Add additional columns for Invoice, SO , Purchase order, Customer statement, Pre-shipper/Shipper Print and ,Proforma Invoice Print .
· Modifications to the existing form trap programs.
Environment : Progress (9.1D), Mfg/Pro eB2 on Linux .
4) Mar’02 - Jan’03
Mfg/pro Implementation for Eltech Electronics Ltd Singapore &
Eltech Electronics Ltd USA(Boston)
Eltech Electronics is a provider of advanced electronics manufacturing
services to original equipment manufacturers with worldwide,
world-class operations in the United States, Singapore and Malaysia.
Eltech was using some other software(MINX) to handle Inventory/MRP/Finance Modules. As there was an requirement to have a full pledged ERP system, MIS group of Digiland Singapore handled the implementation, consolidation and user training .The
whole implementation took around 7 to 9 months and later few months mainly involved in remote support to the users and handling helpdesk calls.
Responsibilities/Tasks :
· Involved in the Customization of major QAD MFG/PRO source code
to cater to specific user requirements.
· Downloading of Mfg/Pro AR, Sales, Invoice History, Customer related
data for EDI.
· Designing, developing and customizing reports as per the user requirements
· Designing, developing and modifying various maintenance like Sales Order/Purchase Order/Bill Of Material /Work Order Maintenance etc.
· Designing, Developing and coding various reports on Sales Orders, Purchase Orders, Inventory Ageing, Invoice Printing, Work Orders etc.
· User training on various modules and supporting the users on day to day works.
· Preparation of Unit Test Plans, Perform Unit Test Verification etc...
Environment : Progress (9.1C), Mfg/Pro eB on HP Unix .
5) Nov’01 – Feb’02
Digiland Singapore Credit Limit SMS Notification
Digiland Singapore wanted to implement an application on Mfg/pro (ERP),
which checks the customer credit Limit each time when any SO is placed and if customer balance goes beyond some certain limit, than to hold the SO & send an SMS/Email to the Financial Controller/GM to approve the Sales Orders related to that Customer. In turn Financial Controller/GM replies back via SMS/email to the same ,
based on which the finance users either will hold the so or will release it.
Basically from Mfg/pro the data will be send to SQL server in text format.
Scripts/Programs from SQL server will read the data and using the
EDX (Electronic Data Exchange) Software, and the EDX will send the SMS to respective
Persons.
Responsibilities/Tasks :
· Maintenance screen to store user-id and mail-ids and Credit Limits.
· Creation of Programs to send SMS/Email to the Financial Personnel based on Some system parameters.
· Preparation of Unit Test Plans, Perform Unit Test Verification etc
· Train the Users on the above.
Environment : Progress (8.3B), Mfg/Pro( 9.0) on HP Unix
6) Sep’01 – Oct’01
Implementation of CRM in Digiland Singapore
As CRM is playing a key role in all the businesses, Implementation of CRM in Digiland Singapore took place during the above period. As the end-users i.e Sales/Marketing people had requested to display the Mfg/pro related data i.e. AR details/Invoice details and Payment details in CRM, I was responsible for downloading programs which downloads the AR/Invoice & Payment details data from Mfg/pro on hourly basis thru cronjob and the same will be transferred to SQL server, from where the same data will be uploaded to CRM.
Responsibilities/Tasks :
· Downloading of Mfg/Pro (ERP) AR, Sales, Invoice History, Customer related Data on some hourly basis from Unix to WIN NT and from there to SQL Server.
· Preparation of Unit Test Plans, Perform Unit Test Verification etc
· CRM Installation to all the users system.
· Conduct CRM Training to all Users.
· Database Administration.
Environment: Progress Ver 8.3b (RDBMS, 4GL) MFG/PRO ver 9.0 on HP Unix ,
WIN NT , MS SQL
7) July’01 – Aug’01
Digiland Australia Auto E-mailing & Fax Notification from Unix
Digiland Australia was in need of a system where, it can automatically check in for the new sales orders in the system and if any new sales Order found, than send an Auto E-mail or Fax to the customer for thanking them ,for placing the Order with them. And also if any sales order is confirmed, then the system sends the Invoice by E-mail or Fax to the customer.
Responsibilities/Tasks :
· Developments of Maintenance program where in user can key in the customer code and SO number based on which system send an E-mail/Fax from Unix.
· Designing, Developing and Customizing Maintenance Programs
As per the user requirements
· Developed Programs to Upload the existing Customer's Email IDs and Fax numbers.
· Preparation of Test Cases.
Environment: Progress (8.3B), Mfg/Pro( 9.0) on HP Unix
8) Mar’01 – June’01.
Implementation & Customization of QAD MFG/PRO for Thongsiek Fish Industry(Singapore) and Trans Europe Computers (HongKong) .
Trans Europe Computers is Hong Kong based company which is into Manufacturing and distribution of computers and Other peripherals(www.transeurope.com.hk) where as Thongsiek Fish Industry is a local company which is mainly into production of fish balls and exports them through out the Asia-Pacific region.
Responsibilities/Tasks :
· Involved in the Customization of major QAD MFG/PRO source code to cater to specific user requirements
· Designing, Developing and Customizing reports as per the user requirements
· Developed Programs to Upload MFG/PRO Pricelist based on Flat Files Using MFG/PRO s CIM Load
· Designing, Developing and coding various reports on Sales Orders, Purchase Orders, Inventory Ageing, Invoice Printing etc.
· Conduct User Training for the Customization done.
· Preparation of Test Cases.
Environment : Progress (8.3B), Mfg/Pro( 9.0) on HP Unix
9) Nov’00 to Feb’01
Upgrade of QAD MFG/PRO (From Ver. 8.5g to 9.0) for all the
Digiland Subsidiaries.
(Digiland Thailand, Digiland Malaysia, Digiland Australia).
Digiland Singapore Ltd is a subsidiary of GES Singapore Intl Ltd.
Being the corporate Office in Singapore it has different branches in Australia, Thailand, Malaysia, Philippines, India and Shanghai. As all the branches were using older version of Mfg/pro , when Ver 9.0 got released most of the branches has been upgraded from 8.5g to Version 9.0
Responsibilities/Tasks :
· Upgrade of existing Customized Programs to 9.0 version
· Involved in the Database Dump/Load Process for the Upgrade
· Preparation of Model Check List to verify the Database Integrity before and after Upgrade
· Preparation of Unit Test Plans, Perform Unit Test Verification
· Involved in Implementation and System Testing.
· Customization of PO and SO module CIM related Programs.
Environment : Progress Ver 7.3/8.3b (RDBMS, 4GL),MFG/PRO ver 8.5g/9.0 on HP Unix
Apart from the above New projects/ In house projects , I was also responsible for the routine maintenance work/Supporting to existing users /Helpdesk queries, Bug fixing and also for some extent Progress Database administration.
Organization : Blue Chip Computer Consultancy at Bangalore, India.
1) April 2000 to October 2000
Production Schedule Generation (MFG/PRO) for Hindustan Lever
Limited (Unilever Group),Bangalore.
Hindustan Lever Limited is having many factories where they are in to production of detergents,Personal products and Toilet Soaps .They had a software which they were using to calculate the production Cost and they use to pass the manual JVs for the consumption in MFG/PRO. They wanted to revamp the old system and to come up with a new system which can be used for production schedule and which can pass a Consumption JV to financials module using CIM.
This Project involved development of Production Schedule Generation System customised module for production costing at stage level in Mfg/Pro, This add on module will extract the required information from inventory, Accounts Payable, Financials & Distribution modules of mfg/pro. The financial effect of the consumption of raw materials to produce the finished goods will get passed as journal voucher into the mfg/pro financials. The three key modules of the system are calculating production cost, Auto JV, and Some Technical Efficiency reports.
Responsibilities as a System Analyst :
· Designing and development of a customized database for storing the Production schedule related information, to Capture Additional Information for Reporting purpose and to pass Consumption JV to System.
· Design and development of screens using progress RDBMS according to the requirements of Hindustan Lever Limited.
· Updating the customized database through the screens developed.
· Client Co-ordination, Programming, Testing, Implementation and Documentation.
· Developed Program Specification, user manual as per the ISO standard specifications.
· Developed complex programs i.e. maintenance, CIM Uploading and reports, system test cases.
· Implementation of the above customized Software in 4 Factories.
· Training the users at all implemented Factories.
· Implementation Support (Central Supporting) for the implementers who were on the
Sites.
Environment : Progress (7.3), Mfg/Pro( 7.4I) on Digital Alpha Unix Server.
Organisation : Blue Chip Computer Consultancy at Bangalore, India.
2. Jan 2000 to March 2000.
Consolidation of Fixed Assets Management(MFG/PRO) for Hindustan Lever Limited(Unilever Group), Bangalore.
It is an add on module to the core fixed assets management of Mfg/Pro. Hindustan Lever Limited has got around 90 profit centers through out the country ,in all these profit centers fixed assets has been implemented. All these profit centers will be sending monthly reports i.e depreciation reports, capital expenditure reports, asset commissioning reports to Head office or to the Corporate office. Earlier at HO & CO they used to consolidate these reports using some spreadsheets.Where as from now onwards this module will help them a lot like,all the profit centers will be running a program at the month end which picks up the required data and spools a asci file with some extension ,which will be uploaded at the HO or CO to consolidate the total worth of the assets throughout the country.This module has got some complex reports and some maintenance options which will allow the users to get some good consolidated reports.
Responsibilities as Senior Software Engineer :
· Designing and development of a customized database for keeping the extra information, which cannot be stored in QAD Database.
· Design and development of screens using progress RDBMS according to the requirements of Hindustan Lever Limited.
· Updating the customized database through the screens developed.
· Client Co-ordination , Programming , Testing,Implementation and Documentation.
· Developed Program Specification, user manual as per the ISO standard specifications.
· Developed complex programs i.e maintenance and reports, system test cases .
· Implementation of the above customised Software throughout the profit centers through telnet
Environment : Progress (7.3), Mfg/Pro( 7.4I) on Digital Alpha Unix Server.
3. April 1999 to December 1999.
Customisation of Fixed Assets Management (Mfg/Pro) for Hindustan Lever Limited (Unilever Group) at Bangalore.
HLL is having around 80 to 90 profit centers throughout the India including HPC, ICD, beverages and Personal care products. The total worth of HLL is 11 thousand crores. In that around 60% belongs to Fixed Assets and the other 40 % belongs to current assets. Its a procedure that, for fixed assets usually all the companies calculate the depreciation (i.e. monthly or yearly) just to know the usage value of all the assets. Till now they did not had any other software through which they can calculate depreciation for the Assets like plant and machinery, office equipments, building and computers. Now by using the above customized software they can calculate depreciation and system will be passing the necessary entries to GL. Software has been mapped in such a way that it fulfills HLL rules and company policies.
The Fixed Assets Module includes the following activities:
a) Monitoring the capital proposals
b) Commissioning or Capitalization of Fixed Assets.
c) Calculation of Depreciation.
d) Posting the depreciation entries to GL Module.
e) Reconciliation of Reports.
Responsibilities as Software Engineer:
· Design and development of screens using progress RDBMS according to the requirements of Hindustan Lever Limited.
· Client Co-ordination regarding the design of tables structures .
· Programming, Implementation and Documentation.
· Developed Program Specification, user manual as per the ISO standard specifications.
· Developed complex programs, system test cases.
· Implementation of the above-customized Software throughout India i.e. around 14 to 15 factories, branches.
· Training the users at all branches and Factories.
Environment : Progress (7.3), Mfg/Pro( 7.4I) on Digital Alpha Unix Server.
4. November 1998 to March 1999.
Customisation of Distribution Requirement Planning(Mfg/Pro) for Brooke Bond Lipton India Ltd(Unilever Group) at Bangalore, India.
DRP is one of the crucial activities of the company's day to day operation . It is responsible for the distribution network to ensure that the right stock are made available
at the right time in the right place for effecting the sales. This module is aimed at calculating the stocks required at the CFA's (Carrying and Forwarding Agents) depending on the factors like forecast, sales order , quantity on hand, safety stock etc.
Responsibilities as Programmer :
· Developed add-on reports for the information of safety stocks, lead time , quantity on hand of different CFA's.
· Developed reports for the dispatches based on the criteria like invoice wise, customer wise, transporter wise, date wise, item wise etc.
· Prepared user manual documents and program specifications.
· Preparation of the test plans, test cases and output of the test results.
· Implementation of the latest versions sources codes through telnet at different sites.
Environment : Progress(7.3 ), Mfg/Pro(7.4h) on UNIX(Digital Alpha Server).
5. August 1998 to October 1998.
Integrated Costing System For Hindustan Lever Limited (Unilever Group) at Bangalore, India.
This software is an add-on module to the Mfg/Pro , used in the manufacturing Department. This software can be used to know the production cost of the item at each and every process during the time of production which will be helpful for the production dept. to know what is the exact cost they are incurring to produce an item.
Responsibilities as Trainee Programmer :
· Developed several add-on reports which helps in analysing the costs per unit at each process.
· Developed test plans and program documentations.
Environment : Progress(7.3e), MFG/PRO(7.3e) on SCO-UNIX.
Organisation : Lakhotia Computer Centre at Udupi, India.
1. Feb 1998 to June 1998
I was working as a faculty at Lakhotia Computer Centre, which is one of the leading
Computer Institue in India. I used to teach Oracle 7.1 , Developer 2000 and C++.
Responsibilities as Faculty :
· Train the students on the above RDBMS and languages.
· Discuss/ Solve the hands-on exercises.
· Trouble shoot the students problems during practical classes.
· Database Administration and System administration.
PERSONAL INFORMATION :
Date of Birth : 18th May 1976.
Sex : Male
Marital Status : Single
Phone: (541) 850-8361[H]
E-mail: raghu_qad@yahoo.com
EXPERIENCE SUMMARY:
Over 5+ years of experience in the analysis, design and development of
QAD'S MFG/PRO(ERP Package) and PROGRESS(4GL& RDBMS) .
EDUCATIONAL QUALIFICATION:
· Bachelors of Business Management (Financials Major) from
Mangalore University, India (1996).
· Honors Diploma in Network Centered Computing from National Institute
of Information Technology(NIIT) 2 Semesters ( 1997) .
TECHNICAL ENVIRONMENT:
ERP Applications : MFG/PRO (Inventory Control, Purchase Order, Global
Requisitions, Sales Order/Invoice,
Distribution Requirement Planning,
General Ledger, Accounts Receivable, Accounts Payable,
Fixed Assets, Work Orders, Product Change control,
Material requirement planning) ,EDI
On Version 7.4h to Mfg/pro eB2.
CRM : Implementation & Training of Entice CRM at
Digiland Singapore Ltd
RDBMS : Progress(6.0,7.3,8.3B,9.1C,9.1D),
Oracle(7.1), Forms(4.2),Sybase, MS SQL
Languages : C ++ ,HTML
Packages : MS Office
Operating Systems : UNIX(HP, Digital,SCO) Windows – NT Win 2000
Professional , Novel Netware, MS-DOS
Hardwares : PC-XT,AT, 386/486, Pentium III,IV, Digital Alpha Server,
HP Server.
MAJOR ASSIGNMENTS:
Organization: Digiland Singapore Ltd /
GES Singapore International Ltd, Singapore.
Digiland Singapore Ltd which was set up to handle the sales, marketing and distribution activities of the GES group (www.ges.com.sg ) famous for its line of PCBA circuit
boards and Datamini (www.datamini.com.sg) computers and peripherals. Digiland has its operations through out the south east asia pacific region and it has its branches in Australia, Malaysia, Thailand, Philippines, Hong Kong etc. The MIS group of Digiland, handles all the ERP related issues within the company and also implements ERP for third party Companies.
1) Sep'03 - Nov'03
Mfg/pro Program migration from Ver 9.0 to eB2 for GES Singapore Ltd.
As GES Singapore Ltd was getting migrated from version 9 Mfg/pro to eB2, all the customized programs of old version, modified to be sync with the programs of Mfg/pro eB2.
Responsibilities as Application Specialist :
· Mainly involved in modification/testing of all version 9.0 customized programs .
· Modifications to existing CIM programs of Ver 9.0, so that it can work well in eB2.
· UAT(User Acceptance Test) of all the modified programs along with the users and fix the programs based on the UAT results.
Environment : Progress CUI (8.1B,9.1D), Mfg/Pro Ver9.0, eB2 on HP Unix .
2) Jul'03 - Sep'03
Conversion of Standard Cost to Average Cost for Eltech Electronics Ltd.
Eltech Electronics were using the standard cost as the main cost set for all their GL reporting. Later due to the operational issues they wanted to move their cost set from “Standard” to “Average”. The change in cost set mainly effects all the open work orders existing in the system. This project was mainly involved, in conversion of the cost set along with writing a few CIM programs for uploading, downloading of work orders, WO split , wo component issue , work order bill maintenance and work order release.
Responsibilities as Application Specialist :
· Extraction programs to extract only those WO related data where work order is open and wip cost exists for any work order, in a proper format so that the same set of data can be used to upload back into database.
· Analyze the impact of cost conversion with the users/user groups and find a suitable solution.
· Developed reports to cross verify the total wip cost and total open work order qty after the cost conversion.
· Development of CIM uploading programs which were used for uploading of work order maintenance, work order component issue, work order receipt, work order close , work order receipt and work order bill maintenance.
Environment : Progress (9.1C), Mfg/Pro eB on HP Unix .
3) Feb'03 - Jun'03
Implementation of MRP Module &
Central Procurement planning System for Digiland and its subsidiaries.
Central procurement system is a add-on module to Mfg/pro, based on the buyer code maintained in the system, buyers will approve the plan orders and thus it gets created as purchase order. Based on the total PO value, the PO has to be approved by the respective personnel; whose name and user id is maintained in the system. On each approval, system will send the e-mail notification to next approver and will be routed to the approver. Once the PO is approved by all the approvers, the PO will be confirmed and thus the warehouse people can do the PO receipts.
Responsibilities as Application Specialist :
· Creation of maintenance programs based on the plan order approval, system will build the PO through CIM and will send e-mail notification to the purchasing department.
· Involved in development of new maintenance program using browser, where the users can approve the purchase orders based on the total PO value, once the approval is done it will be routed to next level and will notify them by e-mail.
· Involved in the Customization of core Mfg/pro source code
to fit the user requirements.
Environment : Progress (8.1B), Mfg/Pro Ver.9 on HP Unix .
Customizations to Form trap related programs for GE Supply Asia Ltd through Singapore Computer Systems.
Form trap is a additional software which is used in GE Supply to print out the SO, Invoice and purchase orders in a pre-defined template with company logo, borders ,boxes etc. In brief, instead of customizing the standard Invoice print, SO Print, QAD provides a set of programs, which can be mainly used for form trap purposes. Based on the user requirement, additional columns has to be stubbed into the output data in a pre-defined way so that the same data can be used by form trap software to print the Invoice , SO and other documents.
Responsibilities as Application Specialist :
· Add additional columns for Invoice, SO , Purchase order, Customer statement, Pre-shipper/Shipper Print and ,Proforma Invoice Print .
· Modifications to the existing form trap programs.
Environment : Progress (9.1D), Mfg/Pro eB2 on Linux .
4) Mar’02 - Jan’03
Mfg/pro Implementation for Eltech Electronics Ltd Singapore &
Eltech Electronics Ltd USA(Boston)
Eltech Electronics is a provider of advanced electronics manufacturing
services to original equipment manufacturers with worldwide,
world-class operations in the United States, Singapore and Malaysia.
Eltech was using some other software(MINX) to handle Inventory/MRP/Finance Modules. As there was an requirement to have a full pledged ERP system, MIS group of Digiland Singapore handled the implementation, consolidation and user training .The
whole implementation took around 7 to 9 months and later few months mainly involved in remote support to the users and handling helpdesk calls.
Responsibilities/Tasks :
· Involved in the Customization of major QAD MFG/PRO source code
to cater to specific user requirements.
· Downloading of Mfg/Pro AR, Sales, Invoice History, Customer related
data for EDI.
· Designing, developing and customizing reports as per the user requirements
· Designing, developing and modifying various maintenance like Sales Order/Purchase Order/Bill Of Material /Work Order Maintenance etc.
· Designing, Developing and coding various reports on Sales Orders, Purchase Orders, Inventory Ageing, Invoice Printing, Work Orders etc.
· User training on various modules and supporting the users on day to day works.
· Preparation of Unit Test Plans, Perform Unit Test Verification etc...
Environment : Progress (9.1C), Mfg/Pro eB on HP Unix .
5) Nov’01 – Feb’02
Digiland Singapore Credit Limit SMS Notification
Digiland Singapore wanted to implement an application on Mfg/pro (ERP),
which checks the customer credit Limit each time when any SO is placed and if customer balance goes beyond some certain limit, than to hold the SO & send an SMS/Email to the Financial Controller/GM to approve the Sales Orders related to that Customer. In turn Financial Controller/GM replies back via SMS/email to the same ,
based on which the finance users either will hold the so or will release it.
Basically from Mfg/pro the data will be send to SQL server in text format.
Scripts/Programs from SQL server will read the data and using the
EDX (Electronic Data Exchange) Software, and the EDX will send the SMS to respective
Persons.
Responsibilities/Tasks :
· Maintenance screen to store user-id and mail-ids and Credit Limits.
· Creation of Programs to send SMS/Email to the Financial Personnel based on Some system parameters.
· Preparation of Unit Test Plans, Perform Unit Test Verification etc
· Train the Users on the above.
Environment : Progress (8.3B), Mfg/Pro( 9.0) on HP Unix
6) Sep’01 – Oct’01
Implementation of CRM in Digiland Singapore
As CRM is playing a key role in all the businesses, Implementation of CRM in Digiland Singapore took place during the above period. As the end-users i.e Sales/Marketing people had requested to display the Mfg/pro related data i.e. AR details/Invoice details and Payment details in CRM, I was responsible for downloading programs which downloads the AR/Invoice & Payment details data from Mfg/pro on hourly basis thru cronjob and the same will be transferred to SQL server, from where the same data will be uploaded to CRM.
Responsibilities/Tasks :
· Downloading of Mfg/Pro (ERP) AR, Sales, Invoice History, Customer related Data on some hourly basis from Unix to WIN NT and from there to SQL Server.
· Preparation of Unit Test Plans, Perform Unit Test Verification etc
· CRM Installation to all the users system.
· Conduct CRM Training to all Users.
· Database Administration.
Environment: Progress Ver 8.3b (RDBMS, 4GL) MFG/PRO ver 9.0 on HP Unix ,
WIN NT , MS SQL
7) July’01 – Aug’01
Digiland Australia Auto E-mailing & Fax Notification from Unix
Digiland Australia was in need of a system where, it can automatically check in for the new sales orders in the system and if any new sales Order found, than send an Auto E-mail or Fax to the customer for thanking them ,for placing the Order with them. And also if any sales order is confirmed, then the system sends the Invoice by E-mail or Fax to the customer.
Responsibilities/Tasks :
· Developments of Maintenance program where in user can key in the customer code and SO number based on which system send an E-mail/Fax from Unix.
· Designing, Developing and Customizing Maintenance Programs
As per the user requirements
· Developed Programs to Upload the existing Customer's Email IDs and Fax numbers.
· Preparation of Test Cases.
Environment: Progress (8.3B), Mfg/Pro( 9.0) on HP Unix
8) Mar’01 – June’01.
Implementation & Customization of QAD MFG/PRO for Thongsiek Fish Industry(Singapore) and Trans Europe Computers (HongKong) .
Trans Europe Computers is Hong Kong based company which is into Manufacturing and distribution of computers and Other peripherals(www.transeurope.com.hk) where as Thongsiek Fish Industry is a local company which is mainly into production of fish balls and exports them through out the Asia-Pacific region.
Responsibilities/Tasks :
· Involved in the Customization of major QAD MFG/PRO source code to cater to specific user requirements
· Designing, Developing and Customizing reports as per the user requirements
· Developed Programs to Upload MFG/PRO Pricelist based on Flat Files Using MFG/PRO s CIM Load
· Designing, Developing and coding various reports on Sales Orders, Purchase Orders, Inventory Ageing, Invoice Printing etc.
· Conduct User Training for the Customization done.
· Preparation of Test Cases.
Environment : Progress (8.3B), Mfg/Pro( 9.0) on HP Unix
9) Nov’00 to Feb’01
Upgrade of QAD MFG/PRO (From Ver. 8.5g to 9.0) for all the
Digiland Subsidiaries.
(Digiland Thailand, Digiland Malaysia, Digiland Australia).
Digiland Singapore Ltd is a subsidiary of GES Singapore Intl Ltd.
Being the corporate Office in Singapore it has different branches in Australia, Thailand, Malaysia, Philippines, India and Shanghai. As all the branches were using older version of Mfg/pro , when Ver 9.0 got released most of the branches has been upgraded from 8.5g to Version 9.0
Responsibilities/Tasks :
· Upgrade of existing Customized Programs to 9.0 version
· Involved in the Database Dump/Load Process for the Upgrade
· Preparation of Model Check List to verify the Database Integrity before and after Upgrade
· Preparation of Unit Test Plans, Perform Unit Test Verification
· Involved in Implementation and System Testing.
· Customization of PO and SO module CIM related Programs.
Environment : Progress Ver 7.3/8.3b (RDBMS, 4GL),MFG/PRO ver 8.5g/9.0 on HP Unix
Apart from the above New projects/ In house projects , I was also responsible for the routine maintenance work/Supporting to existing users /Helpdesk queries, Bug fixing and also for some extent Progress Database administration.
Organization : Blue Chip Computer Consultancy at Bangalore, India.
1) April 2000 to October 2000
Production Schedule Generation (MFG/PRO) for Hindustan Lever
Limited (Unilever Group),Bangalore.
Hindustan Lever Limited is having many factories where they are in to production of detergents,Personal products and Toilet Soaps .They had a software which they were using to calculate the production Cost and they use to pass the manual JVs for the consumption in MFG/PRO. They wanted to revamp the old system and to come up with a new system which can be used for production schedule and which can pass a Consumption JV to financials module using CIM.
This Project involved development of Production Schedule Generation System customised module for production costing at stage level in Mfg/Pro, This add on module will extract the required information from inventory, Accounts Payable, Financials & Distribution modules of mfg/pro. The financial effect of the consumption of raw materials to produce the finished goods will get passed as journal voucher into the mfg/pro financials. The three key modules of the system are calculating production cost, Auto JV, and Some Technical Efficiency reports.
Responsibilities as a System Analyst :
· Designing and development of a customized database for storing the Production schedule related information, to Capture Additional Information for Reporting purpose and to pass Consumption JV to System.
· Design and development of screens using progress RDBMS according to the requirements of Hindustan Lever Limited.
· Updating the customized database through the screens developed.
· Client Co-ordination, Programming, Testing, Implementation and Documentation.
· Developed Program Specification, user manual as per the ISO standard specifications.
· Developed complex programs i.e. maintenance, CIM Uploading and reports, system test cases.
· Implementation of the above customized Software in 4 Factories.
· Training the users at all implemented Factories.
· Implementation Support (Central Supporting) for the implementers who were on the
Sites.
Environment : Progress (7.3), Mfg/Pro( 7.4I) on Digital Alpha Unix Server.
Organisation : Blue Chip Computer Consultancy at Bangalore, India.
2. Jan 2000 to March 2000.
Consolidation of Fixed Assets Management(MFG/PRO) for Hindustan Lever Limited(Unilever Group), Bangalore.
It is an add on module to the core fixed assets management of Mfg/Pro. Hindustan Lever Limited has got around 90 profit centers through out the country ,in all these profit centers fixed assets has been implemented. All these profit centers will be sending monthly reports i.e depreciation reports, capital expenditure reports, asset commissioning reports to Head office or to the Corporate office. Earlier at HO & CO they used to consolidate these reports using some spreadsheets.Where as from now onwards this module will help them a lot like,all the profit centers will be running a program at the month end which picks up the required data and spools a asci file with some extension ,which will be uploaded at the HO or CO to consolidate the total worth of the assets throughout the country.This module has got some complex reports and some maintenance options which will allow the users to get some good consolidated reports.
Responsibilities as Senior Software Engineer :
· Designing and development of a customized database for keeping the extra information, which cannot be stored in QAD Database.
· Design and development of screens using progress RDBMS according to the requirements of Hindustan Lever Limited.
· Updating the customized database through the screens developed.
· Client Co-ordination , Programming , Testing,Implementation and Documentation.
· Developed Program Specification, user manual as per the ISO standard specifications.
· Developed complex programs i.e maintenance and reports, system test cases .
· Implementation of the above customised Software throughout the profit centers through telnet
Environment : Progress (7.3), Mfg/Pro( 7.4I) on Digital Alpha Unix Server.
3. April 1999 to December 1999.
Customisation of Fixed Assets Management (Mfg/Pro) for Hindustan Lever Limited (Unilever Group) at Bangalore.
HLL is having around 80 to 90 profit centers throughout the India including HPC, ICD, beverages and Personal care products. The total worth of HLL is 11 thousand crores. In that around 60% belongs to Fixed Assets and the other 40 % belongs to current assets. Its a procedure that, for fixed assets usually all the companies calculate the depreciation (i.e. monthly or yearly) just to know the usage value of all the assets. Till now they did not had any other software through which they can calculate depreciation for the Assets like plant and machinery, office equipments, building and computers. Now by using the above customized software they can calculate depreciation and system will be passing the necessary entries to GL. Software has been mapped in such a way that it fulfills HLL rules and company policies.
The Fixed Assets Module includes the following activities:
a) Monitoring the capital proposals
b) Commissioning or Capitalization of Fixed Assets.
c) Calculation of Depreciation.
d) Posting the depreciation entries to GL Module.
e) Reconciliation of Reports.
Responsibilities as Software Engineer:
· Design and development of screens using progress RDBMS according to the requirements of Hindustan Lever Limited.
· Client Co-ordination regarding the design of tables structures .
· Programming, Implementation and Documentation.
· Developed Program Specification, user manual as per the ISO standard specifications.
· Developed complex programs, system test cases.
· Implementation of the above-customized Software throughout India i.e. around 14 to 15 factories, branches.
· Training the users at all branches and Factories.
Environment : Progress (7.3), Mfg/Pro( 7.4I) on Digital Alpha Unix Server.
4. November 1998 to March 1999.
Customisation of Distribution Requirement Planning(Mfg/Pro) for Brooke Bond Lipton India Ltd(Unilever Group) at Bangalore, India.
DRP is one of the crucial activities of the company's day to day operation . It is responsible for the distribution network to ensure that the right stock are made available
at the right time in the right place for effecting the sales. This module is aimed at calculating the stocks required at the CFA's (Carrying and Forwarding Agents) depending on the factors like forecast, sales order , quantity on hand, safety stock etc.
Responsibilities as Programmer :
· Developed add-on reports for the information of safety stocks, lead time , quantity on hand of different CFA's.
· Developed reports for the dispatches based on the criteria like invoice wise, customer wise, transporter wise, date wise, item wise etc.
· Prepared user manual documents and program specifications.
· Preparation of the test plans, test cases and output of the test results.
· Implementation of the latest versions sources codes through telnet at different sites.
Environment : Progress(7.3 ), Mfg/Pro(7.4h) on UNIX(Digital Alpha Server).
5. August 1998 to October 1998.
Integrated Costing System For Hindustan Lever Limited (Unilever Group) at Bangalore, India.
This software is an add-on module to the Mfg/Pro , used in the manufacturing Department. This software can be used to know the production cost of the item at each and every process during the time of production which will be helpful for the production dept. to know what is the exact cost they are incurring to produce an item.
Responsibilities as Trainee Programmer :
· Developed several add-on reports which helps in analysing the costs per unit at each process.
· Developed test plans and program documentations.
Environment : Progress(7.3e), MFG/PRO(7.3e) on SCO-UNIX.
Organisation : Lakhotia Computer Centre at Udupi, India.
1. Feb 1998 to June 1998
I was working as a faculty at Lakhotia Computer Centre, which is one of the leading
Computer Institue in India. I used to teach Oracle 7.1 , Developer 2000 and C++.
Responsibilities as Faculty :
· Train the students on the above RDBMS and languages.
· Discuss/ Solve the hands-on exercises.
· Trouble shoot the students problems during practical classes.
· Database Administration and System administration.
PERSONAL INFORMATION :
Date of Birth : 18th May 1976.
Sex : Male
Marital Status : Single