VIKRAMJEET SINGH
# ****, ** ** *, **** Puri, Tibba road, Ludhiana-141007
Mobile: +91-985*******, E-mail: ******************@*****.***
CARRIEROBJECTIVE:
Seeking assignments in MIS, Data Entry Computer operating from home,, ERP or Backend ERP with a growth oriented organization that will enable me to utilize my strong analytical &Interpersonal skills.
SUMMARY:
Master of Computer Applications with 5 years plus experience in MIS, Data entry,Comuter operator,ERP & Backend Sale Support area in manufacturing Limited Company. Extensive experience with Sale Inventory & Purchase ERP Modules.
EDUCATION:
Session
Course
Institute/University
Percentage
2007-10
Masters of Computer Applications
Quest Infosis, Punjab Technical University
76%
2003-06
Bachelor of Computer Applications
Arya Collage, Punjab University
71 %
2002-03
10 + 2 ( Commerce )
S.C.D Govt. Collage, Punjab School Education Board
70 %
2000-01
10th
A.V.M, Punjab School Education Board
76 %
TECHNICAL SKILLS SETS:
Data Entry & Computer operating
Advance Excel :
Vlookup, Hlookup, Index & Match, Macro, Nested if Statements with logical operators like AND, OR, Conditional formatting, Pivot Table & Charts, Data Validation.
Formulas & functions Like sumifs, sumif & Countifs, countif, CountA,Average, Substitute, Max, Min, Concatenation, Len, Proper, upper,lower, left, right, mid, replace, trim, numerical functions like fact, sqrt, mod, power, product, round & Date & time functions,
Google Sheets :
MIS reporting on various Erp module i.e. sale, inventory, purchase.
Database Management System : RDBMS, SQL Programming :
.
DDL, DML, DCL, TCL, Clauses, Joins, Functions, Constraints, Tables, Views
Reporting Tool : Crystal Reports 9
Office Applications: MS Access, MS Word, MS Power point. ERP : Nuron, Tally erp9
ORGANISATIONAL SCAN
MIS Data Entry EXECUTIVE Jinal Fine Industries ( Aug 17– till date)
Deepak Fasteners Limited, The Largest Industrial Fasteners Manufacturer in India since 1956 and today the proud Worldwide Owner of UNBRAKO. It is exporting fasteners to Kuwait, U.A.E., Saudi Arabia, Jordan, Israel, Yemen, Egypt, Greece, Indonesia, Sudan, Australia, Germany, Canada, U.K., Holland, Malaysia, Brazil, and Chile and exporting wide range of fasteners such as Bolts, Nuts, Washers, ASTM Studs, Foundation Bolts, Threaded Rods confirming to International Standards such as DIN, ASTM, BS, ANSI, JIS, IS and ISO etc.
Functional/Operational :
Data Entry of of Sale order, Invoicing, packing slip IN ERP.
Preparation of Purchase Orders, Purchase Invoices, Purchase indent some time if required.
Responsible for Good receipts data entry and entry of receipt & payment voucher and debit & credit note.
Stock adjustments & Stock Movement according to user requirements in ERP.
Stock Valuation.
Responsible for all Data Entry Tasks.
Preparing power point slides related with different business aspects & processes.
Mail drafting& mail correspondence.
Reporting:
Generating MIS reports on Sale, Inventory, and Purchase Module for business analysts & end users in ERP.
Provide Sale support and maintenance to existing management information system (MIS).
Generate and distribute management reports in accurate and timely manner.
Knowledge of Advance Excel, Google Sheets, SQL and Crystal reports to maintain MIS.
Good Knowledge of Sale, Inventory, Purchase ERP Module & its process.
Online & offline rectifying overseas user queries related with MIS & operational ERP of
( UK, Australia, & Shannon (Ireland) & America countries
Preparation of daily, weekly, monthly, intercompany sale, yearly sale, domestic & export sale.
ACHIEVEMENTS/INTERESTS:
Won 1st prize in Bhangra in Collage annual function.
Secure 99 marks out of 100 in English in secondary school.
Quick Summary
5 Years of Experience in Data Entry,Computer operator.MIS, ERP, EDP and Backend support for Manufacturing domain. Extensive experience with Sale & Inventory, Inventory modules.
Declaration:
I hereby certify that the particulars furnished above are complete and correct to the best of my knowledge.
Place :
Date :
VIKRAMJEET SINGH