KARAN ARORA

Ph: 303-***-**** ac1n4m@r.postjobfree.com

Summary:

Around 3 Years of experience of Maintenance, Production Support and Development. Well conversant with Production Support & development.

IT Applications experience ranges from Employee payroll to accounting & Inventory.

Enthusiastic and passionate to develop and learn new skills if required.

Technical Skills:

Operating Systems : Windows 7,2000,XP, Windows NT 3.5/4.0,

Windows 95/98/2000,MS-DOS, Unix.

Languages : Java,C,C++,Fox-Pro, Dbase, SQL, PL/SQL,HTML

Databases : Oracle 9i/8i/7.x, MS Access, FoxPro

Packages : MS Office2000(MS Word, MS Excel),Power Point

Professional Experience:

Xavient Information Systems, INDIA: (Hadoop Development Trainee) June,2016 - June,2017

Xavient is a global IT consulting and software services company, we focus on transforming business ideas into effective solutions. Xavient is headquartered in the U.S with an international network of delivery centers primarily established in India.

Joined Xavient as a fresh software engineer. Working as Hadoop trainee. Worked on use of sqoop and flume,map-reduce framework, use of pig and hive, hadoop 2.0 and Hadoop Administrator

Raghu Exports (India) Pvt. Ltd. INDIA: (Support Analyst - Part Time) Apr-2014 - May,2016

Raghu Exports is a manufacturing and export house . It does manufacture and export the leather goods to

Europe, North America and Middle East countries. The in house custom software development is done on

Windows and FoxPro. I did work on the project from requirement analysis and UAT perspective. I had

a major role in maintaining the applications.

Project : Accounts Management & Export Management System

As a Support Analyst I supported the following systems for Raghu Exports

1. Payroll Regular From attendance to end salary like we installed two biometric machine at the main entrance ( Time Office Department). After a month we maintain overtime register, Attendance Register, Monthly Salary Register, Salary summery, P.F. register, E.S.I. Register, Leave Register, Advance Register, uncover Advance Register, H.R.A. Register, At the End of the Quarter we maintaining E.S.I. Return, P.F. Return (Govt. Rules). Whenever its Diwali(Festival of Lights in India) We are maintaining Bonus for all the Full time employees.

2. Payroll On Contract Basis:- Its depends on Production Basis. i.e. Different contactors Production Report, Production Summery, Product wise summery, Employee wise summery, from to date Production, From to date Production of the Individual contractor, Quality Reports, Rejection reports etc.

3. Accounts:- We are maintaining Cash book, Bank Book, Sale Book, Purchase Book, Petty cash Book. VR's Entry, Ledgers General Ledger, Customer Ledger, Supplier Ledger, Statement of A/Cs, Customer outstanding, Supplier Payment Reports, Supplier Payment Summery, Expenses Summery (Month wise, quarter wise) Trial balance,(i.e. Supplier Trial Balance Customer Trial Balance & General Trial Balance), In sale department we are maintaining Billing & sale book too. At the end of the year we work on creating Balance Sheet, Profit and Loss, Fixed assets, Sundry creditors & Sundry debaters. Cash flow, Projected Next Year Budget etc.

4.Inventory Control:- We are maintaining Item masters, supplier masters, minimum maximum list,

Quotation Masters, Demand Note Entry, Purchase order Entry, Order Execution, Order Printing, Gate

Receive Entry, Gate Return Entry, Issue Entry, Issue Return Entry, Bill Receive Entry, Outgoing Gate

Entry, Incoming Gate Entry. In Reporting We are maintaining Bill passing and valuation, Issue evaluation,

crucial Item list( Min, Max.) Rate comparison list, Call Quotation, Comparative quotations List, Quotation

list (Item wise and supplier wise), Item List without Quotation, Demand list without quotation, Pending

demand for Orders, Pending Purchase Orders,(Item wise or supplier wise), Receipt Register, Issue Register,

(Department Wise or Item wise), Item wise & Supplier wise order list, Store Item Balance List

(Trial Balance of Items), Item Statement, Consumption reports( Department Wise, Item Wise),

Consumption Summery (Department Wise and Item wise), Order list with Pending Quantity,

group wise item Status.

Roles & Responsibilities:

Its being a small company I was involved in different roles other than just being Support Engineer/Analyst.

Involved in monitoring the back end scheduled jobs which run on daily, weekly or monthly basis.

Involved in coordinating with the business for resolving the issues on daily basis.

Involved in upper management for process improvement, Hardware upgrades, Software upgrades.

Environment:

Windows NT/2000, FoxPro

Education :

Bachelor of Computer Application (GNDU Amritsar)

Training in Big Data, Hadoop Development & Hadoop Administration

Achievements :

Represented DAV College at group discussion related to Data Structure held at LPU as group leader.

Winner of “Brain spot” competition ie: logic testing.

Participated as group leader in India’s largest IT FEST held at LPU.

References : Available on request

Contact this candidate