Posted by on May 29, 19103 at 03:35:23:
Manoj Kumar
Summary: Total 9 years of software experience in the IT Industry in areas pertaining to System Analysis, Design and Development. Technically proficient in Developer 2000 (Forms 6.0, Reports 6.0, and PL/SQL) in Window 2000 and AIX environment.
Technical competence in Oracle 7.x, 8.0, 8i.Good communication skills.
Successfully performed design and development under demanding
Time schedules. Good attitude towards teamwork and common goals.
As well as performing System Administrator activities.
Professional: Oracle 7.0 for Application Developers conducted by Oracle Edu.,Delhi
Courses/Training Develop Applications using PL/SQL (V2) conducted by Oracle Edu.,Delhi
Develop Applications with Oracle 3GL PreCompilers conducted by
Oracle Edu.,Delhi
Tune Oracle 7 Applications conducted by Oracle Edu.,Delhi
Oracle8i with Developer 6i conducted by SQL STAR International,
New Delhi
Linux7.3 from Spider Systems Pvt. Limited, Pune
Technical Skills:
Languages: Developer 6.0i, BASIC, PROC*C, C and COBOL
Databases: Oracle 7.3, 8.0, 8i, PL/SQL
O/S: Windows 2000, Window-NT, Window 98, AIX, UNIX, LINUX,
Other: ODDESSY (Object Oriented design & development tool), FoxPro,
Installation Window 2000 Server with Citrix Licenses.
Hardware: Wipro Netpower 5210 Server with RAID System with ICA Thin Client
Technology, RS-6000 with RAID System, Novell based Mail Server with
Using net-mail software, VSAT Server for Data Transfer and IBM
Compatible personal Computers
Professional Experience:
Apr99 – Present: Finolex Industries Limited, Ratnagiri Sr. System Analyst
(Finolex is the largest manufacturer of rigid PVC and pipes and fittings.
Finolex PVC broke new ground by setting up India’s first open sea cryogenic jetty to be owned by a company in the private sector. Manufactures 1,25,000 MT/year of suspension and emulsion POLYVINYL CGLORIDE(PVC). Company having cryogenic storage facilities for the storage ETHYLENE & LPG at their jetty.
Presently I am looking the System Admin, ERP Admin and General Administration activities as well as application development
Jul02 – running: Lab Analysis System & Production Analysis
Description: This project is under two phases, In I-phase Lab Analysis System. Lab
Analysis system having all samples testing for related process for VCM,
SPVC, EPVC resin. Also system monitoring Product Quality of all
process upto PVC resin.
II-Phase
This system basically will takes care of the production analysis of various
Products manufactured by company. It enables the production department
To generate the daily, monthly & yearly, MIS reports. Based on the
Production entered, the wastage, the downtime hours the efficiency of the
Machine is found. Based on this information the employees are given
Incentives, Based on this information the total production, wastage are
calculated.
Contribution: System study, Designing of master and data entry screens, Development, Troubleshooting, Testing, Implementation and working under tight schedules. Working extensively on stored procedures, triggers, Loading Data.
Environment: Developer 6 with Oracle 8
May 01 – Jun 01: Transferring Data from remote location
This system takes care of the data to be transferred from our Pune
Plant to Ratnagiri through lease line or through VSAT connectivity.
Contribution: System study, Designing user interface, coding, Testing, Implementation Troubleshooting. Procedures and Triggers.
Environment: Oracle 8
Sep 00 - Feb 01: Shares Accounting System.
Description: Transaction programs include transfer shares .In share transfer first Scrutiny of transfer deed takes place. Then transfer deeds are done for one cutoff date and updating is done for that cutoff i.e. actual transfer of Shares. Mail transactions includes mail inward, mail outward, mail
Return etc. in daily quotation transaction min and max. of daily share is Maintained.
Contribution: Coding, Designing of forms and coding of transaction’s using stored procedures, triggers, views and the corresponding reports. Testing, Troubleshooting and working within time period. Data Migration using sql loader from basic system. Granting rights.
Environment: Developer 6.0, Oracle 8.0
Feb 00 - Jun 00: Financial Accounting System.
Description: This system is designed as per requirement of the company.
The major module of System is:
Master Module:
Creation of one time master’s likes company, customer, supplier, account, tax, bank, account group, schedule etc.
Transaction’s:
Transaction module considers various sub modules like purchase, sales bank payment, receipts, journal voucher etc. Each sub module consists of entry and various reports.
Bill Passing:
This system is part of financial accounting system. This system
basically takes care the payment’s
Contribution: Prepared a prototype, Acceptance of the prototype, Prepared Master Entry screens and the corresponding Master listing , Transaction screens and it’s corresponding report’s using feature’s of oracle i.e. Procedures, trigger’s view’s. Tuned the procedure’s using proper index on the table’s. Troubleshooting, Testing, and Implementation in time. Loading Data using sql loader from Basic system.
Environment: Developer 6 with Oracle 7.3
Oct 99 - Dec 99: Network Project (Fiber Optic)
Handled the erection and commissioning of Network Project using Fiber
Optic Cables with M/s.Comptel Network India Ltd.
May 99 - Aug 99: Project Information System (MIS)
Description: First time generated MIS report for top management and implemented
Successfully. This is monitoring report of all activities carried out in the
Plant.
Contribution: Designing forms & related reports using oracle features i.e., Stored procedures, triggers, and views, Coding, Troubleshooting, Implementation, Tuning in schedule time.
Environment: Developer 6 Oracle 8
Dec94 – Mar99: Hero Cycles Limited, Ludhiana System Analyst
(Largest BICYCLE manufacturer in the world, with Its name in Guinnes Book of World record since 1998. Production of 12000 bicycles per day. Approx 300 product, 3200 customers, 2000 vendors and 3600 employees (60% piece rated)
Responsibilities for design and development of commercial applications in ODDESY with Oracle 7.3 backend and tools
Developed Areas:
Personnel Management System (Oracle 7.3, Forms 3.0, Proc*C)
The complete online and integrated system with other application i.e. FA, MMS, PPC etc. consisting all the reports and process like employee component master, category component master, employee saving master, leave master, religion master, holiday master and operation etc.
This project generates daily attendance shift wise float of all employee schedule for next week checking the company leave calendar and employee leave application. Employee leave status is update end of shift every day. Salary is a calculated based on table like operation master etc. Reports are like ESI, PF, FPS, BONUS, Overtime and all reports PMS and MMS.
Materials Management System (Oddesy with Oracle 7.3, Proc*C)
The system consists of two module’s stores and purchase module
Stores:
This module takes care of transaction related to material requisition, i.e.
Indent, GIN (Goods inward note), takes care of the stock of materials and
Order according it the reorder level. This also take care of the gin printing,
Monthly reported having information about pending PO’s, rejection
Reports, stock ledger, cardex report’s, pending gin for inspection, indent
Listing.
Purchase:
This module takes care of purchase officer’s allotment to store indent,
Supplier inquiry, getting quotation’s from different suppliers, comparative
Study is done, then according to that P.O is prepared & printed, P.O
Amendment entry * printed. Payment advise entry, Purchase order
Remainder’s, Bill remainder’s and pending P.O statement’s.
Export documentation and analysis (Forms 3.0/Reports with Oracle 7.3 , Proc*C)
The complete online and integrated system with other application i.e. FA, Sales, MMS etc consisting all the reports process like PRE-POST SHIPMENT Invoice and packing documents BL, Goods Lying and LC.
Responsibility:
1] System Administration 2] Network administration
3] Backup’s 4] DBA Activities
Personnel Information :
Date of Birth : 01.11.1971 Nationality : Indian
Passport : A-3351125 (valid till 2007) Martial Status : Married
E-Mail : mkumar_mku@yahoo.com
Correspondence : 134-Narmada, Finolex Hsg Colony, MIDC, Zadgaon, Ratnagiri – 415 612 (Mah) Phone (resi) : +91-2352-226080 Ext.311, (Direct) +91-2352-226806
Permanent : House No. 37-A, Roadways Colony Behind Prabhu Cinema, Lohamandi,
Agra – 282 002 (UP) Phone : +91-562-2111828
Education: Bachelor of Science (Statistics), Agra University,
Post Graduate Diploma in Computer Science & Application, Mathura
Diploma in Computer Programming, Agra
(Manoj Kumar)