Address: *** **** ** ******
Meerut (India)
Email id:
************@*****.***
Mobile no: +919*********
. Having extensive knowledge and working experience in Accounting.
. Having extensive knowledge, functional and support experience in SAP.
. Proficient in Tally, MS-Office and Communication skills
. Team player with excellent communication skills.
. Good customer service skills, interpersonal and, analytical skills.
. Advance knowledge of Computer and easily adaptable to software and
operating systems.
. Having extensive knowledge and working experience in Indian Taxation.
July '05 - Jun One Year Diploma In Computer Chandigarh India
'06 Accounting
Applied Computer Systems Chandigarh
Jul '01 - May Bachelor of Commerce Uttar India
'04 Meerut College Meerut (C.C.S Pradesh
University)
. Presently working with Avian Consulting Ltd., as SAP FI/CO Consultant,
Sep 2007 to till date.
. Worked for Contour Automotive Products Ltd. (A Manufacturing Unit of
Tractor Parts) Chandigarh, as Assistant Accountant from June 2005
to Aug 2007.
. Worked for M/s Ashok Aggarwal & Associates. Meerut, as Accounts Officer
from Jul 2004 to June 2005.
SAP SUPPORT PROJECT 1st :>
Associated with Avian Consulting India as an SAP FICO- Functional
Consultant since Sep 2007 to Till Now, Avian is an ERP consulting company
based in Chandigarh, India.
Organization - Avian Consulting Limited.
Client - Jakson Engineers Limited (Noida)
Position - SAP FI/CO Consultant
Duration - Sep 10 - till now
Reporting To - Senior Consultant
Project Profile:
Jakson is a leading provider of silent DG sets, as well as a major
manufacturer of Control Panels solutions. Jakson has sales offices and
manufacturing plants across northern and western India.Jakson Implemented
includes modules FI, CO, MM, SD, PP and HR.
Key Responsibilties:
Co-ordinating with client for giving acceptable solutions to problems,
queries raised by
Client within predefined stringent time limit and giving solution to
users
Resolving issues On Priority Basis
Providing support to end users day by day
Corrections made in the configuration settings for different company
codes as per the
Client's requirement
Customizing and configuration of various areas of IMG activities
including
General Ledger master records.
Solving Account receivable/ Accounts Payable related issues
Withholding Tax configuration according to client requirement
House banks
Cash Journals
Taxes on sales and purchases
Asset Accounting
Basic setting of Controlling
SAP SUPPORT PROJECT 2nd :>
Organization - Avian Consulting Limited.
Client - Lava International Limited
Position - SAP FI/CO Consultant
Duration - Jan 10 - Aug 2010
Reporting To - Senior Consultant
Project Profile:
Lava International is a global trading organization with sales and
marketing set-up spread over various Asia - pacific countries. Its main
emphasis is to procure the customer orders from various countries and
convert them into Purchase orders back to back on their own processing
Mills located in China with mills directly shipping the material to the end
customer but invoicing to Lava International. I am responsible for their
Finance requirements study for reporting, design, develop and deliver
solutions for Accounting as well as Sales and Distribution and Material
Management.
Key Responsibilties:
Handling issues regarding field status of master record of G/L, AR & AP
Creating of new Customer & Vendor Groups
Creating new House Bank
Creating Payment methods for Automatic Payment Program
Solving issues & creating new Payment Terms for customers
Creation of Dunning Procedure for customers
Creation of Business Transactions in Cash Journal
Creating Tax Codes for input & output tax
Participating in on-going training and performance development to maintain
and update skills. Ensuring appropriate arrangements are made with
supervisors in the team to allow for maintaining appropriate service levels
while attending meeting etc.
SAP IMPLEMENTATION PROJECT 1st :>
Organization - Avian Consulting Limited.
Client - Lakshmi Oil & Food Ltd. Nabha (Punjab)
Position - SAP FI/CO Consultant
Duration - Jan 09 - Nov 2009
Reporting To - Project Manager
Project Profile:
Lakshmi is a leading company in manufacturing edible oils like Vanaspati,
Refined Oil and other Rice products having a large market share in the
Northern Region. Today Laksmi has an installed capacity of 10,000 metric
tons per month with a turnover of over 450 Cores Laksmi has introduced a
range of refined oils - namely, groundnut, cottonseed, mustard, sunflower.
Implementation includes modules FI, CO, MM, SD and PP.
Key Responsibilties:
Created G/L Accounts in the charts of accounts and defined global
parameters in company code area, defined account groups, configured the
settings for creation of G/L master records, sub-ledger accounts for
customers, vendors and automatic account assignment, reconciliation
accounts and special ledger accounts.
Created sample account rules variant to link the sample account transfer
rules to the proper company code, screen variant templates, account
assignment model for distribution of expenses, reference document for
posting of recurring entries.
Defined tolerance groups, retained earnings and document types.
FI-Accounts Receivable:
Created customer master data, configured customer group, customer field
status
Created customer with reference and integration with sales & distribution
module
Worked on assignment of credit control area to company code, credit risk,
interest Calculation and evaluation of terms of payment
Configured the foreign currency valuation of the open items and account
balances by configuring the valuation procedure Configured the exchange
rate gain and loss accounts for the exchange rate keys,
FI-Account Payable:
Created vendor master data, configured vendor groups, vendor field status
and assigned number ranges for vendor account groups.
Created vendor with reference and integration with material management
Setting of house banks and configured automatic payments, paying company
codes, payment blocking reasons and defining check lots, lock box
configuration.
Controlling (CO)
Enterprise Structure, Cost Center Profit Center, Defining controlling Area,
Assign Company code to controlling Area, Assign Number Range to controlling
Area, cost element Primary and Secondary cost center accounting, Product
Costing configuration.
Data Uploading Through LSMW
Opening and Closing Activities
SAP IMPLEMENTATION PROJECT 2nd :>
Organization - Avian Consulting Limited.
Client - Cooper Automobile Pvt Ltd (Chandigarh)
Position - SAP FI/CO Consultant
Duration - Oct 07 - Dec 2008
Reporting To - Project Manager
Key Responsibilties:
Responsibilities included interacting with client's business process team
Collecting all the business requirement Create functional specifications
For the programming team to develop custom reports and requirements
Responsibilities in FI:
Configured organizational structure for FI module - Company Code,
Chart of Accounts, maintained field status variants and assign to
Company code, variants for document entry
Defined account groups and created master data for vendors/Customers.
Configured Reconciliation Accounts in G/L for domestic as well as foreign
Vendors/Customers
Configured automatic payment program for outgoing payments for company
codes in Accounts Payable (AP)
Responsibilities in CO:
Configured cost elements, costing sheets, standard hierarchy, cost
Centers, activity types, statistical key figures, master data groups,
Validations and substitutions, assessments, distributions and
Reposting allocation cycle and segment
Cost Center Planning included defining versions, planning layouts,
planner profiles and activity planning.
Configured basic settings, maintaining profit center hierarchy,
assignments, CO-Objects to Profit Centers, distribution and assessment of
costs, Planning and development of Reports
Position: Assistant Accountant
Jun 05 - Aug 07: Contour Automotive Products Ltd.(Chandigarh)
Reporting To: Financial Accountant
Key Responsibilties:
. Account receivable.
. Account Payable.
. Bank Reconciliation.
. Payroll.
. Month end Financial Statements and Management reports.
. Performed General Office Duties and Administrative Tasks.
Position: Accounts Officer
Jul 04 - Jun 05: M/s Ashok Aggarwal Chartered Accountant Firm (Meerut)
Reporting To: Senior Accountant
Key Responsibilties:
. Account receivable.
. Account Payable.
. Bank Reconciliation.
. Payroll.
. Month end Financial Statements and Management reports.
. Performed General Office Duties and Administrative Tasks.
SAP FI/CO related Skill Sets
and experience
SAP FI GL
. Company code configuration which includes creating chart of accounts,
. Creating posting period variant, defining retained earnings account,
. Creating document types. Define tolerance groups for employees
. Configuration for Maximum exchange rate differences
. Configuring parallel currencies
. Configuration for automatic clearing
. Configuration for foreign currency valuation
. Configuration for regrouping of GR/IR clearing
. Creating financial statement version i.e. defining balance sheet and
profit and loss account
. Integration - FI- MM automatic account assignment, FI- SD automatic
account assignment
SAP AR & AP & Bank accounting
. Configuring account groups for Customers and Vendors, defining screen
layout per activity for customers and vendors
. Deleting customer data
. Configuring payment terms
. Automatic account assignment for various AR & AP transactions like
bank charges, overpayments/underpayments, exchange rate difference,
rounding differences
. Configuring payment block reasons
. Configuring automatic payment program
. Includes House bank configuration, manual cheque deposit
. Configuring the manual bank reconciliation and the electronic bank
reconciliation
. Configuration for dunning
. Configuration for special G/L transactions like down payment made,
down payment received, bills of exchange, customer guarantee
. Configuration for regrouping according to maturity
. SAP Asset Accounting
. Creating/Copying Depreciation Areas- Assignment to company Code,
. Input Tax Indicator Configuration, Screen Layout Rules
. Specify Account Determination Rules - Define Asset Classes, Number
Ranges,
. Critical Check Boxes Notification
. Integration of Asset Accounting with General Ledger, Defining Posting
Rules to Cost Center, Specify Financial Statement Versions for Asset
Accounting
. Complex Depreciation Calculation Procedures- Setting up of
Depreciation Areas, depreciation key, Define Cut off Value key
. Defining the crucial Base Methods, Declining Balance Methods,
Multilevel Methods, Maintaining Period Controls
. Pre Production Go Live Activities and Their Configuration
SAP CO Module
Organization Structure:
. Created Cost Center and Profit Center Standard Hierarchy
Configuration:
. Configured Controlling area for CCA & PCA, CO number ranges, order
types, settlement profile, planning profile, budget profile and status
profile.
Master Data:
. Created Primary & Secondary Cost elements, Cost centers, Profit
centers, internal orders, activity types & statistical key figures.
SAP SD related Skill Sets
. Enhancement of organization structure for new business area.
. Creation of full scale document cycle from quotation to billing
document (order type, item category, schedule line category, copy
control and definition & assignment of different organizational
units).
. Configure sales order types, item categories and schedule line for
customized order creation
. Configured incompletion procedure for various sales order types.
. Sales return cycle
. Different claim reimbursement to customers through credit memo route.
. Worked on Configuring Pricing for new sales areas including condition
tables, condition types, access sequence, Customer and Document
pricing procedure, condition exclusion.
. Material listing and exclusion to boost the sales of allied items
. Creating product proposal according to user requirement specification
. Customization of revenue account determination procedure (KOFI / KOFK)
and assigning to relevant G/L account.
. Mapping sales promotion through free goods issue and sales BOM in SAP.
. Customers credit management through automatic credit control.
. Creation of delivery type ZLO (i.e. without order reference) from
scheduling delivery
. Configured Billing components comprising billing document types,
Collective processing of billing documents, order and delivery
related billing.
. Well conversant with different standard stock reports - MMBE, MB52,
MB5B etc.
. Provided cross functional integration with MM,PP,FI/CO
SAP MM related Skill Sets
. Purchase Management
Purchase Requisition
Vendor info record
RFQ's
Price comparison list
Purchase order
Contract (quantity and value)
Scheduling Agreement
Number Ranges
Document Types
Quota Arrangement
. Inventory Management
Goods Receipt
Number Ranges
Movement Types
Stock Types
Stock Overview
Transfer Posting
Goods Issue
Reservation
Invoice Verification
Document
. Automatic Account Determination
(Interface with FI Module)
Valuation And Account Assignment:
Account Modifier
Valuation Grouping Code
Transaction Event Key
. Release strategy
. Material Requirement Planning
MRP Controllers
Automatic PO
. Organization structure
plant, purchasing, organization,storage location
General Settings in Customization
Non-Technical:
Planning/organization: Strategic, out-of-the-box thinker and focused
implementer with time and schedule management skills.
People Skills: Listening, interacting with individuals at all levels,
building positive ongoing-customer relationships as I have been working in
Woolworths as Customer Assistants.
Level
ERP Systems and Computer
Software
My Back Office Advance
SAP Extensive
Tally (Accounting Software in Advance
India)
MS Excel Advance
MS Word Advance
MS Power Point Advance
MS Outlook Advance
KanwalPreet Singh Dhillon
SAP Support Analyst
Department of education and training, NSW
Darsh Singh (Financial Controller)
Australia, Perth
Academic Qualifications
References:
Skills Summary
Professional Experience:
Summary
Employment Objective:
To work for a position that is dynamic, demands high performance and
professional challenge, wherein I can exhibit and develop my technical and
transferable skills that I have gained from my experience and education in
Accounting.