PANKAJ RANA

Mob: 098******** E-mail – acqyvz@r.postjobfree.com

CAREER OBJECTIVE

It will be my endeavor to serve the Organization to the best of my capabilities bringing about the desired results and at the same time enriching myself from the invaluable experience.

Overview

9.8 Years of overall experience out of which 5 + years of professional experiences which includes SAP Implementation experience in Financial Accounting (FI) & Controlling (CO) areas in all phases of Global End-To-End SAP implementation Projects. Designing and testing system improvements to increase productivity and reduce costs.

Having a Valid USA B1 Visa.

Extensive working experience across various industries like Steel, Auto, Manufacturing, Utility.

Extensive experience in Business Analysis, GAP Analysis, Requirement Gathering, and Solution Delivery. Identify various integration process. Identify GAPS in early stages for an ahead of the schedule project delivery.

Experienced with ASAP methodology including Business Process Reengineering, Feasibility Analysis, Configuration, Testing, and Training

Expert trainer for business and end users as well as to SAP consultants in SAP FI/CO

Good understanding with to write FS and work with developers for drafting functional and technical specifications

Excellent communication, presentation and interpersonal skills, a total team player. Self-starter with drive, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver results, even under pressure.

TECHNICAL SKILLS

ERP SKILLS : SAP FICO,

OPERATING SYSTEM : Windows XP,Windows98,Window 2007.

MISCELLANEOUS : MS Office Suite (MS Word, MS Excel, and MS Power Point).

Key Areas in SAP : (G/L, A/R, A/P, AA, TDS, New G/L, PA, PC, PCA, CC, IO, ML).

SAP R/3 Tools : LSMW, Report Painter, Report Writer.

PROFESSIONAL EXPERIENCE

Presently working with NEC Technologies as a LEAD SAP Consultant from 12th June 2015 to Till date.

Worked with KPIT Technologies as a Sr. SAP FICO Consultant from 26th March 2012 to 6th June 2015.

Client: - O C Tanner February 2015 to Till Date

Project: - Development

As a team member my involvement in this project was providing functional expertise in the area of FI-CO module.

Period-End Closing With Partially Delivered Production Orders, Calculation of Work In Progress (WIP),Review WIP Calculations, Production Order Variance Calculation

Settle Variances, Analyze Variances, Close Completed Production Orders, Production Order Information System.

Responsible for detailed problem determination of issues escalated from Level-1.

Problem determination includes re-creating the issues, determining the point of failure by stepping through the ABAP Code and identifying the problem resolution.

If the resolution is a major development or configuration fix, provide the necessary change detail to Level 3.

To have the deepest level of application or product understanding.

Able to understand both the standard application features (i.e. out of the box functionality) as well as the detailed components of the customized features.

Responsible for making changes, migrating them, completing the ticket and communicating the change to the level 2 support person, who can then resolve and close the call.

Determine problems found by the proactive application monitoring being done on a regular basis by the level 2 support person. Therefore, the level 3 person may also have to apply patches, complete performance tuning, Create tables.

Co-ordination of problem tickets with offshore resources (functional as well as technical) to ensure that the tickets are resolved within the stipulated SLAs.

Ensuring that offshore team resources are properly loaded, help them in solving tickets where required and ascertain that the tickets are resolved well within the stipulated SLA timelines set.

Handling Day to Day issues relating to Configuration and business process development

Attending Daily meeting with Client as well as Internal which is related to projects

Prepared End user training Document

Enhancement of the SAP for the end user based requirement

Solved the Post Production issues related to SD, MM, FI, CO.R

Resolved the issues in Unit testing and Integration testing.

Documentation and training on procedures for Finance (AR,AP,GL)

Verified the Test Scripts executed including the Month End Closing Scripts

Tested the settings on the development server and transported the settings onto the testing server for user testing and confirmation, and transported into the production server after user confirmation.

Creating custom Reports on AR and AP by giving functional specifications to the ABAP team for development.

Data-up load, by using ABAP designed BDC programs, Account assignment modules & LSMW.

Documented the processes using standard templates.

Client: - DEWA Sep 2014 to January 2015

Project – Implementation (Integration with PM & PS)

Creation of Allocation cycle, settlement rule, costing variant, for FI & PM integration

Settlement of Maintenance order during month end process.

Creation of Cost center, Cost Elements for Maintenance orders

Assignment of Activity type with Cost center in KP26.

EAM/Plant Maintenance for Auto creation of Equipment master/Asset Master Sync

Integration Of Asset management with Plant Maintenance for Equipment master record creation and serialization

Plant Maintenance-Asset Integration using Auto creation of Equipment Master from asset

Configured Asset Management Life Cycle using Fixed Asset, Internal Orders and Plan Maintenance solutions for handling Farming Equipment and Fleet management

Plant maintenance- Equipment master record integration for automatic creation of Equipment master records and vice versa in sync with asset master

Internal order configuration for Capital orders

SAP AMS APJ (Asia Pacific Japan) Jan 2014 – Aug 2014

Source: SAP JAPAN

Client: VWJ, NIPPON, JDI, CEAT Tyres

Handling day to day tickets which has been raised by Client from the prospective of SAP FICO.

Attending Daily meeting with Client as well as Internal which is related to projects.

SAP FI/CO Consultant for trouble shooting of the day to day problems

Responsible for solving tickets in GL AP, AR, Asset Accounting and Banking in FI area and cost center accounting, Profit center, Internal order and Project System in CO area.

Interacted with Business users wherever required for getting resolved the tickets.

Solution provided for various change requests on the priority bases.

Impact analysis and conflict management documents prepared for the change request.

Configured and customized FI – AP – APP and Dunning Programs.

Resolved day to day issues which is related to Material Ledger.

Solving the issues related to Month end activities Eg. Material Ledger, Closing Cockpit.

Prepared functional spec for various forms and reports.

Performed unit testing and integration testing for Asset Accounting, AP, AP, and CCA.

Extensively exposed to integration issues of FI with MM, and SD.

Tested the settings on the development server and transported the settings onto the testing server for user testing and confirmation, and transported into the production server after user confirmation.

Creating custom Reports on AR and AP by giving functional specifications to the ABAP team for development.

Data-up load, by using ABAP designed BDC programs, Account assignment modules & LSMW.

Documented the processes using standard templates.

AG Industries (Implementation) Aug 2013 – Dec 2013

Solution- Auto Edge

Version- EHP6

SAP FINANCE

As a team member my involvement in this project was providing functional expertise in the area of FI-CO module.

Implementation involving the following Finance and Controlling module areas: Complete enterprise and G/L Structure, Automated integration with Accounts Payables and Receivables, Cost Elements, Cost Centre, Internal Order, Profit Centre, reporting and analysis

Analyzed document flow, validation procedures, and completed a AS-IS study

Blueprinted existing processes in the form of flow diagrams followed by creation of SAP Business processes and configuration of SAP as per the requirements

Taxation: Indian Localization with VAT, Sales Tax, Service Tax

Configured and customized General Ledger, creation of G/L accounts, screen layout rules, automatic account assignments, financial statement version, validation and substitutions

Configured and customized Account Receivable and Accounts Payable modules: including creation of Vendor and Customer Master Records. EBS, Bank Interfaces files, Manual Bank statements, Payment methods, Automatic payment methods, MM and SD integration with Finance

Indian Localization with CIN-Excise-Excise groups, Chapter ids, Excise Registrations, company code setting, plant settings, Series groups, Account determination, Excise accounts groups per Excise Transactions types, Excise utilization, Excise registrations,

EWT Basic settings, Business place, withholding types for invoice posting, withholding types for payment posting, withholding tax codes, activation of withholding taxation, assignment of company code, define withholding accounts,TDS certificates, Challan, Bank challan updating, Sales Tax, Service Tax

Treasury: Configured House Banks, Payment Programs, Automatic Payment Methods, and Alternate Bank Selections for Payments. Checks Management, checks printing and defining void reason codes.

Data Migration: Master Data Objects Including GL master data, Vendor Master Data, Customer Master Databank Master Data, Cost elements, cost centers, Profit centers, Activity types, Work centers

Transactions Data conversion: GL Balances, Vendor open items, customer open items, Asset legacy balances, GRIR open items

Enhancements & RICEF: Reports, Interfaces, Conversion& Forms

Testing & Training: Design, configuration, unit testing, integration testing, UAT, end user training and cut-over

Provided Production Support and End-User demo training sessions.

SAP CONTROLLING- Configuration Overhead Controlling, Maintain Controlling Area, Maintain Controlling Area - Basic Settings Assign Company Code, Maintain Versions, Maintain Number Ranges for CO,Documents, Maintain Allocation Structures, Maintain Allocation Structures Assignments, Maintain Allocation Structures - Source (CE-Group),Define Order Types

Product costing Planning including cost component structures, Costing sheet, Costing variant, valuation variant, costing types,,

Activity types, Result analysis, Allocation structures, Settlement profiles, WIP, Variance keys, Target cost version, Variance keys, Posting rule, WIP, Valuation methods, Result analysis version

Discrete manufacturing process with production orders with make to stock/make to order

Master data preparation in Test cycles: Activity types, Cost centers, Activity type planning, Over heads loading, BOM, Routings

Create costing run, Execute costing run, Review errors, Analyze proposed standard prices, Edit cost run and execute, Execute costing run, Mark as future planned price, Release standard cost estimate and revalue stock at start of new fiscal year

Closing Operations in Sales and Distribution Are Complete for Inventory Movements., IT Support to Ensure Goods Movements Are Complete

Production Transactions Are Complete, Open New MM Period, Actual Overheads Calculation Production Order

Period-End Closing With Partially Delivered Production Orders, Calculation of Work In Progress (WIP),Review WIP Calculations, Production and Process Order Variance Calculation

Settle Variances, Analyze Variances, Close Completed Production Orders, Production Order Information System.

Profitability Analysis (COPA): KEPM Designs: Planning methods, Layouts, Reports, Planning levels, Planning versions, Derivations rules, Data uploads from excel

IndoAuto Tech (Implementation) Jan 2013 – July 2013

Solution- Auto Edge

Version- EHP5

SAP FINANCE

As a team member my involvement in this project was providing functional expertise in the area of FI-CO module.

ASAP Methodology End to End Project Description/Scope: Implementation, Production Support and Development Template.

General Ledger: Chart of accounts, Baseline Configurations, Accounts Groups, MM, SD, PP, GL Integrations, account determination in MM,SD,PP,AM

Configuration of A/R and A/P modules: Terms of payment, Open item Management, configuring account assignment for Overpayments/Underpayments and Cash Discounts, Reason codes configuration, Residual & Partial payments, Charge-off, Deduction Management, Credit management, Tolerance groups, Document Reconciliation, Dunning Procedure, Account group creation, Line layout configuration

Banking: Configured APP, Cash management to monitor payment flows and liquidity, Banking configuration, Manual Bank statement processing, Payment advices, Exchange rates

Indian Localization with CIN-Excise-Excise groups, Chapter ids, Excise Registrations, company code setting, plant settings, Series groups, Account determination, Excise accounts groups per Excise Transactions types, Excise utilization, Excise registrations.

EWT Basic settings, Business place, withholding types for invoice posting, withholding types for payment posting, withholding tax codes, activation of withholding taxation, assignment of company code, define withholding accounts,TDS certificates, challan, bank challan, Sales Tax, Service Tax

Fixed Asset Module: Chart of Depreciation, Asset Classes, Screen Layout and Account Determination, Defining Multi Depreciation Areas as per business requirements, Depreciation keys, Assignment of GL Accounts, Valuation areas, Depreciation methods, Depreciation Keys, Asset Master Data, load file preparations, business acceptance

Data Conversation legacy assets, cut over data in including master data and transactional data, Load File validations, Data conversation issues and load files issues resolutions,Load validations from business, Business acceptances, Change requests, Assisted in configuration of Cost Element and Cost Centre accounting.

Functional Design for the Accounts receivables aging analysis report and Vendor Payments analysis report,Vendor ledgers, Cash Book, Bank Book

Documentation: Configuration, Unit testing, Integration testing, Test plans, User manuals.

Testing & Training: Design, configuration, unit testing, integration testing, UAT, end user training and cut-over.

SAP CONTROLLING- Configuration Overhead Controlling, Maintain Controlling Area, Maintain Controlling Area - Basic Settings Assign Company Code, Maintain Versions, Maintain Number Ranges for CO,Documents, Maintain Allocation Structures, Maintain Allocation Structures Assignments, Maintain Allocation Structures - Source (CE-Group),Define Order Types

Product costing Planning including cost component structures, Costing sheet, Costing variant, valuation variant, costing types,,

Activity types, Result analysis, Allocation structures, Settlement profiles, WIP, Variance keys, Target cost version, WIP valuation methods, Result analysis version

Discrete manufacturing process with production orders with make to stock/make to order

Master data preparation in Test cycles: Material master, Activity types, Cost centers, Activity type planning, Overheads calculation, BOM, Routings.

Loading and validation of the planned prices from business and multiple costing runs for testing

Period end closing: Product cost estimation, Make to stock, Make to orders, Production order, Material withdrawals, WIP calculation, Costing Run and releasing cost estimates Overhead calculations, Variance calculations, WIP, Settlement Calculations

Creating Costing run, Single/Multi level Material prices Determinations, Consumption Revaluation, closing postings, confirming costing results, COPA periodic revaluation, marking material prices, releasing material prices, material price analysis, releasing prices material price updates periodically.

Configuration documentation, Test Plans, Unit testing, Integration testing, CAT testing, Approvals, Peer Review and sign off

Functional Design specification for Update Standard prices to Subsidiaries from Master Plant) and review technical design document and SLA

Configured CCA by creating cost centers, activity types, statistical key figures, cost center standard hierarchy, cost center categories, document numbers, validations and substitutions, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations.

Create internal orders, Set Planner Profile, Plan costs for order, Check Settlement Rules, Execute Settlement of planned costs for order, Confirm Correct Settlement

Activity type planning, Budgeting, Planning statically key figures, Cost Element planning, plan distribution, Internal Activity planning, Plan assessment, Activity input planning, Indirect activity allocation, Plan reconciliation.

Horiba June 2012 – Dec 2012

Month-end closing activities – GR/IR Clearing, F110 automatic payments, Settlements, Asset Depreciation run, Manual adjustments, Closing and Opening GL, Vendor, Customer posting periods.

Understand the functional requirement of the user, make it in SAP & work accordingly.

Prepared End user training Document

Enhancement of the SAP for the end user based requirement

GL Trial Balance, Vendor open invoices, Customer open items upload using Conversion accounts. Clearing of On Account postings, GR/IR clearing, Closing & Opening Vendor posting periods, GL Month end recurring entries

Cash Journal for check receipts and payments

GL, Vendor and Customer master data upload using LSMW/ BDC.

Classification of GL Accounts.

Configuring Fiscal year variant, Posting periods and Field status variant.

Working with ABAP (Technical consultant) for a new report creation

Worked with SMARTTECH Infosystem Pvt. Ltd as a SAP FICO Consultant on a support project of USA based company (Pelican) from July 2011 to March 2012.

Client: Pelican

Roles & Responsibilities.

Configuration of relevant area’s in FI-GL, CO-CCA

Integration and functional testing

Accounts Payable processes, Accounts Receivable processes

SD Integration, MM Integration, Asset Accounting, Inbound/ Outbound SAP Interfaces, Month end closing.

Resolving Regression testing issues.

Month-end closing activities – GR/IR Clearing, F110 automatic payments, Settlements, Asset Depreciation run, Manual adjustments, Closing and Opening GL, Vendor, Customer posting periods.

Understand the functional requirement of the user, make it in SAP & work accordingly.

Prepared End user training Document

Enhancement of the SAP for the end user based requirement

GL Trial Balance, Vendor open invoices, Customer open items upload using Conversion accounts. Clearing of On Account postings, GR/IR clearing, Closing & Opening Vendor posting periods, GL Month end recurring entries

Cash Journal for cash receipts and payments

Worked with Hages Business Solution Pvt. Ltd (HBS) from July 2010 to July 2011.

Client:- Jindal Stainless Steel.

Roles & Responsibilities

Configuration of relevant area’s in FI-GL, CO-CCA

Integration and functional testing

Accounts Payable processes, Accounts Receivable processes

SD Integration, MM Integration, Asset Accounting, Inbound/ Outbound SAP Interfaces, Month end closing.

Resolving Regression testing issues.

Month-end closing activities – GR/IR Clearing, F110 automatic payments, Settlements, Asset Depreciation run, Manual adjustments, Closing and Opening GL, Vendor, Customer posting periods.

Understand the functional requirement of the user, make it in SAP & work accordingly.

Prepared End user training Document

Enhancement of the SAP for the end user based requirement

GL Trial Balance, Vendor open invoices, Customer open items upload using Conversion accounts. Clearing of On Account postings, GR/IR clearing, Closing & Opening Vendor posting periods, GL Month end recurring entries

Cash Journal for check receipts and payments

Worked with SMARTTECH Infosystem Pvt. Ltd as a SAP FICO Consultant on a support project of USA based company (Pelican) from July 2011 to March 2012.

Worked with Hages Business Solution As a SAP FICO Consultant on a Support Project of Jindal Stainless Ltd, Hisar, Haryana from July 2010 to July 2011.

Worked with Chartered Accountant Firm (Sahil Gambhir) as Accounts Executive from June 2009 to July 2010.

Roles & Responsibilities

Book keeping & Vouching

Preparing TDS challans

Preparing VAT reports, Service tax.

Checking statutory liabilities

Worked with Planet PCI Infotech Ltd. as Accounts Executive (SAP) From September 2008 to June 2009.

Roles & Responsibilities

Booking of Vendor & Customer bills and making payments in SAP

Clear Vendor & Customer Payment.

Vendor & Down down Payment.

Use Special GL transaction.

Worked with Taj Palace ( A TATA Enterprise) as F&B Executive From September 2004 to October 2007.

Educational Qualification

2001-2002 CBSE Matriculation

2003-2004 CBSE Intermediate

2003-2006 D.U. B.Com (Pass)

2007-2010 ICFAI MBA Finance

Diploma in Business Management from ICFAI University.

Advance Diploma in Business Management from ICFAI University.

Certified Associate Financial Planner in Tax & Estate planning from FPSB (2012).

Having a provisional National Apprenticeship Certificate from PUSA Institute, Delhi

Personal Information

Father’s Name : Mr. Guldev Singh Rana

Date of Birth : 15th Aug. 1986

Address : RZE-23 Sitapuri part-1, New Delhi – 110045

Linguistic Proficiency : English, Hindi & Punjabi.

Hobbies : Traveling; Making/ Meeting new friends; Net Surfing;

Listening to music; watching movies.

Passport : Yes

VISA : Having a B1 Visa for USA

Assuring you a flawless track record at your esteemed organization.

Date (PANKAJ RANA)

Contact this candidate