|
Pankaj Saxena
Ph:
+91-9818454421
email:pankajsaxenadelhi@yahoo.co.uk
|
Technical Qualification |
Visual Basic 6, ADO, COM / DCOM, Oracle 8i, Crystal Reports, Data Report, Printer Objects, HTM
From Software Technology Group International Ltd (STG).
|
|
|
Engineering Diploma (3 years) in Electronics Engineering from U.T.Tech Board, Lucknow (UP), India. |
|
|
|
|
Objectives |
Strive
to carve myself to attain higher echelons in software field. |
|
Summary |
Having
14+ years total working experience. Out of this last 5 years approx in Application Software Development.
I am having rich experience of analyzing and implementing business rules and designing database
applications, which really inculcate with long working experience. I am well conversant with front-end designing and quite
confident in (MIS) report generation using Crystal Report and Data Report.
|
|
Present Job :
Since 05th
Jan, 1999 |
I am working as Programmer with M/s.Mectronics Infotech Services, New Delhi, a team of enthusiastic and highly skilled
professionals. At present job I have developed and implemented following customised
softwares.
|
Project#1
|
|
|
|
|
Garment Exporter and Importer |
|
|
|
M/s. Berkley Imports
Ltd. |
|
|
268, 13986, Cambie
Road, Richmond BC
CANADA |
|
|
|
Visual Basic 6,MS-Access 2000 & Crystal Report |
|
|
|
Design , Development and Report Generation |
|
|
|
M/s. Berkley Imports Ltd. is engaged in import
and export of garments.
Developed a True MDI Software to maintain Rate Master, Colour Master, Size Master, Size Master, Issue of Purchase Orders, Recording of Status of Shipments,
Noting of Shortage in the Shipments, Goods Receipt and Sample Goods Receipt with clearance of clearing agent bill, Invoicing,
Sample Invoicing, Sale return, Purchase return, maintaining of Stock and Sample Stock with unit LDP. |
|
|
|
1.
P.O.(On Order) Summary 2. P.O.(On Order) by Style 3. P.O.(On Order) by Vendor 4. P.O. (On Order) by Customer 5. P.O.(On Order) by Customer Cancellation Date 6. P.O.(On Order) By Vendor Cancellation Date 6. P.O. Shipped
by Customer 7. P.O. Shipped by Vendor 8. P.O. Shipped Summary 9. Goods in Transit by Style
10. Goods in Transit by Style 10. Goods in Transit by Customer 11. Goods in
Transit Summary 12. Shipment Received
from a Vendor 13. Shipment Received Through Carrier, 14. Shipment Received
Through carrier Summary.
|
|
|
|
1. Sale of Style with % Share 2. Sale of all
Styles with % Share 3. Sale to Customer with % Share 4. Vendor Purchase Price
History, 5. Customer Selling Price History 20 Gross Margin on All Style 6.
Gross Margin on a Style 7. Gross Margin on a Customer 8. Import Expenses
Analysis 9. Broker Bill Summary and approx. 10. other reports
|
Project#2 |
|
|
|
|
Sale, Purchase and Accounting Software |
|
|
|
Kamdhenu Ispat
Ltd., Rohini, Delhi
(A steel manufacturing
company) |
|
|
|
Visual Basic 6, Oracle 8i and Crystal Report 8.
|
|
|
|
Design , Development and Report Generation |
|
|
|
M/s. Kamdhenu Ispat Ltd is a steal giant in
Delhi engaged in manufacturing of steel tor with brand name “Kamdhenu Saria”. This software is developed for keeping complete track of Booking of orders, Purchase Sauda, Maintaining daily rates,
Sale, Purchases, Receipt & Payment through Cash, Bank and Journal Vouchers,
Trial Balance, Ledger Accounts display with month wise summary and navigation
from ledger display to respective bills/vouchers, cash books, bank book, various MIS Reports related with quantitative sale
and purchase, calculation of incentive to brokers according to dealer and distributor
policy and much more.
|
Project#3 |
|
|
|
|
Accounting and Payroll Software |
|
|
|
Vallabhbhai Patel
Chest Institute,
Delhi University,
Delhi |
|
|
|
Visual Basic 6, MS Access-2000, Data Report
& Crystal Report 8.
|
|
|
|
Design , Development and Report Generation |
|
|
|
Patel Chest Institute is India’s only government research institute undertaking
research in chest diseases |
|
|
|
The payroll software is developed to maintain payroll of approx. 250 employees working under 5 categories. This software covers widely all
functions of Personnel department viz. maintaining of employees personal details, salaries, pensions, record of increments/promotions,
calculation of TDS, issuing of Form No. 16 and Form No. 24 (Forms for taxation) etc |
|
|
- Financial Accounting Module
|
The multi financial year, software
is developed to maintain accounting of three departments viz. Non-Plan, Plan
and Suspense Accounts. This software covers maintenance of Group Master, preparation of Bank Vouchers, Salary Vouchers from
Payroll, Journal Vouchers, Advances to Employees, Bank Reconciliation, Receipts of Grants on Research Projects in various
heads with proper validation and checks and Booking of Expenses incurred by Research Fellows etc.. Main reports of the project
are Cash Book, Ledger Accounts, Trial Balance, Bank Reconciliation Statements, Receipt and Payment Accounts, Income Expenditure,
Balance Sheet, Balance Sheet Schedules, Projects Accounts, Staff Advance Ledger, Budget Etc. |
Project#4 |
|
|
|
|
Inventory Management |
|
|
|
MM Services, Sant
Nagar, East of Kailash,
New Delhi |
|
|
|
Visual Basic 6, Oracle 8 and Crystal Report 8.
|
|
|
|
Design , Development and Report Generation |
|
|
|
M/s. MM Services is engaged in Import and Sale of
SMT Adhesive, a consumable used in Major Electronics Industry.
This software is developed to maintain Item
Master, Customer Master, Group Masters and to keep complete track of purchase orders, imports, sale, imports expenses analysis, inventory with LDP, receipt of payment
(bill to bill) from customers, customers ledger accounts, outstanding bills, various reports of stock on batch no., expiry date and various MIS reports on customers,
items and import expenses.
|
Project#5 |
|
|
|
|
Share Accounting Management |
|
|
|
Euro-Gold Jewelellery
Ltd.
New Delhi |
|
|
|
Visual Basic 6, MS Access 97 and Data Report |
|
|
|
Design , Development and Report Generation |
|
|
|
M/s. Euro-Gold Jewellery Ltd is 100 % E.O.U. Public Limited
engaged in manufacturing and export of real diamond jewellery.
This software is developed to provide in-house share-registry services to its shareholders.
This software covers transfer/transmission/transposition of shares, demat of shares with CDSL and NSDL, change of address
of shareholders, split, consolidation and duplicate issuance of share certificates and various reports pursuant to Companies Act, 1956. |
Project#6 |
|
|
|
|
Invoicing Software (Excisable Goods) |
|
|
|
M/s.Precisition
Stampings Ltd.
Faridabad. |
|
|
|
Visual Basic 6, MS Access 2000 & Crystal Reports 8 |
|
|
|
Design , Development and Report Generation |
|
|
|
M/s. Precision Stamping is leading stamping manufacture.
Developed a software to maintain customer master, item master,
Invoicing of excisable goods, printing of invoice on pre-printed stationery using
Printer-Object, other statutory report and sales related reports.
|
Project#7 |
|
|
|
|
Garments Manufacturing) |
|
|
|
M/s. Blue Clothing,
Saket,
New Delhi |
|
|
|
Visual Basic 6, Oracle 8i, Printer Object and Crystal
Report.
|
|
|
|
Design , Development and Report Generation |
|
|
|
M/s. Blue Clothing is quality designer garments manufacturer with
brand name Perry Blue.
Developed a software to maintain Size Master, Colour
Master, Style Master, Fabric Master, Stitching Material Mater (In Number and meter), Group Ledger Master, Fabric Purchase,
Stitching Material Purchase, Issue of Fabric and Stitching Material to Fabricators,
Receipt of Finished Stock from Fabricators, Invoicing, Outstanding stock with fabricators, Finished Stock based
on Quality, Size, Colour etc., Stock of fabric, and stitching material etc., Printing of
labels of finished stock, Invoice, Issue Slips to Fabricator, Receipt
Slip from Fabricator, Vouchers, Ledger, Requisition of Sales Forms froms Customers,
Trial Balance and other MIS Reports with sales.
|
Project#8 |
|
|
|
|
Advertising Booking, Invoicing And FA |
|
|
|
M/s. Veer Arjun
News Papers Pvt. Ltd., New Delhi
(Hindi Daily)
|
|
|
|
Visual Basic 6,MS-Access 2000 and Crystal Report |
|
|
|
Design , Development and Report Generation |
|
|
|
M/s. Veer Arjun is Hindi Daily published from New Delhi.
Developed a software to maintain advertisement booking, scheduling, invoicing, payment receipts,
ledger accounts, mater schedule, journal, sale register, outstanding bills etc.
|
Project#9 |
|
|
|
|
Hospital Automation with Financial Accounting |
|
|
|
M/s. Sarvodaya
Hospital
|
|
|
|
Visual Basic 6, SQL Server and Crystal Report |
|
|
|
Design , Development and Report Generation |
|
|
|
The multi financial year, software is developed to
maintain admission of patients, visiting doctor details, pathological details, daily reports on various aspects. Financial accounting, wages, tax forms etc.
|
Since 1st July, 1992 to
4 January, 1999 |
|
|
·
Mectronics Marketing Services, New Delhi
|
Was looking after sales, Customer Support and interaction with Foreign Principals. Mectronics
is dealing in many foreign agency and selling SMT equipment. During the job I was sent on few training on equipments to Singapore,
Germany and US.
|
Since 17th November to
1st July, 1992 |
|
|
·
ECE Industries Limited, Ghaziabad
(Elevator Div)
(Birla Group |
In beginning I was appoint as trainee engineer and then shifted to R & D and then to
customer Support. I was traveling a lot for installation through out the country.
|
Personal Data |
|
·
Date
of Birth |
20th May 1970 |
·
Qualification |
III Years Diploma Engineering in Electronics From U.P.Tech. Board Lucknow, (UP) India |
|
|
|
|
|
|
·
Address |
H.No: 989, Niti Khand-I, Indirapuram, |
|
Ghaziabad –201010 (UP) India |
·
Phone
No |
(+91)9818454421 / (+91) 120-2606115 |
Date: September 13, 2004
(Pankaj Saxena)
|
