SUDARSAN MODAK
Address: C/o, Ganesh Chandra Golder, 95/34, Bose Pukur Road, Kolkata-700042
Contact: +91-983*******; E- mail: acqx57@r.postjobfree.com, acqx57@r.postjobfree.com
SAP Sr.FICO CONSULTANT
Looking for a suitable opportunity for career advancement
PROFILE & STRENGTHS
Qualified MBA having 14 years of Experience in the area of Finance & Accounts domain, expertise in Commercial & Branch Accounting and 6 years of SAP FI/CO experience in ECC 7.2 version.
Extensive experience in Accounts & MIS, Financial Operations, Auditing and MIS & Budgeting activities.
Possess expertise in General Ledger Maintenance, Accounts Receivable, Accounts Payable, Cash Journal set- up, Asset Maintenance, Royalties & Tax Withholding, CCA, PCA, COPA, Product Costing, Material Ledger, Actual Costing & Unit Test Document for Configuration.
Domain expertise in Construction, Execution, Defect & Trouble- shooting on SAP Module.
Excellent analytical, quick learning and problem solving skills with a desire to work in a team oriented environment.
Excellent communication, presentation and interpersonal skills, with the ability to develop team and client interaction expertise. An extrovert with the ability to interface well with people from diverse backgrounds.
SAP Skills
Financial Accounting:
Creation of G/L Masters, New G/L, Cash Journals, House banks and Maintaining Field Status Variant and Posting Keys, Special Purpose Ledger
Defining Fiscal year variant, Posting periods, Tolerance groups, Document types and number ranges
Defining Interest Calculation Types, Defining Reference interest rates, Assigning Accounts for Automatic Posting for Interest Calculations.
Creation of Customer/Vendor Accounts Groups, Number Ranges, and Customer/ Vendor Masters Creation
Configuring Automatic Payment Program, EBS and Dunning for Vendors/Customers
Configuring Input /Output Tax and Withholding Tax
Testing in HPQC, Solution Manager and CHARM.
Financial Contract Accounts (FICA):
Account Determination (Co.code, Division, Account Determination ID, Main Transaction, GL Account)
Security Deposit (Cash Security- Accepted in terms of Cash or Check) (Non Cash Security Deposit- In terms of bank Guarantee or Letter of Credit).
Installment Plans, Collection Management, Interest Calculation, Transfer of Item
Dunning, Transfer to GL, Reset Clearing, Late Payment Charges, Period End Closing
Asset Management:
Configuring Chart of Depreciation, Depreciation Areas and Depreciation Keys
Creation of Asset Classes, Asset Number Ranges, Account Determination, and related settings
Managing acquisition of new asset with Asset Under Construction (AUC) and settlement of the same to final asset
Transferring APC Values
Maintaining Group and Low Valued Assets
Controlling:
Maintain the Versions for actual and planned postings
Creation of Cost Centres and Definition of Cost Centre Hierarchy
Creation of Activity types and Statistical key figures and Allocation, Distribution and assessment of costs
Creation of Primary and Secondary Cost Elements with appropriate Cost Element Category
Definition of Internal Orders Types, Order Masters and Settlement Profiles
Creation of Cost Centres and Definition of Cost Centre Hierarchy
COPA & Product Costing
Actual Costing & Material Ledger
Integration with FI-CO, FI-MM & FI-SD.
PROFESSIONAL EXPERIENCE
DYNPRO INDIA LTD from September’14 to till date
Client : PHILIP MORRIS INTERNATIONAL Project
Role : Sr. SAP FICO Consultant
Organization : IBM INDIA PVT. LTD
Key Responsibilities
Working in First Level Support (FLS) and up gradation move to 2nd Level.
Solve the SRQ before the end date as priority basis.
Not only Finance part. I have involved also travel management and security issue.
In finance part mainly I have involved in GL, AP and AR, Bank and Assets related issue.
Configuration of Automatic Payment Programming, APP Run (F110), EBS File Load, Set Up House Bank, Set Up EBS Frame Work, Test the EBS Upload Etc.
In controlling part I have involved in CCA, PCA, and Internal Order.
COPA- Structure, Master Data, Planning, Automatic Account Assignment.
Product Costing- Porduct Cost Planning (Basic Settings for Material Costing, Define Calculation Base, Define Overhead Key, Define Costing Sheet), Material Cost Estimate with Quantity Structure, Cost Object Controlling, Variance Calculation, Settlement.
Actual Costing/Material Ledger- Activate Valuation Area for Material Ledger, Actual Costing for Materail Ledger, Price Determination, Realization of Material Ledger and Actual Costing, Config Dynamic Price Change, Define Access to Actual Costing & Material Ledger, Check Material Ledger Document after inventory posting in plants, Actual Costing run is final activity
I have also worked in WBS.
In travel management I have worked mainly some approval issue.
In testing part I am working in HPQC ( Prepare the Test Scripts, Documentation, and for each test case which is to execute the entire script and pass/fail is tracked at the unit test scripts level), In test scripts prepared in word ( Header Information, Test Script Description, Steps, Specific Test Master Data)
I have also created defect linked to specific step in Integration Testing.
SOLMAN- Test Requirement and Test Object from SOLMAN will flow to Quality Center, Test Script created and attached to the Test Plan in QC, Test Case Design (Create Script, Create Detail Test Component, Test Sequence).
CHARM – Change request approval, System Changed Activity Monitoring, Integration to Transport Routes
In 2nd Level I am working in EHP7 UAT testing for Western Europe in PANAYA tools.
In FICA Part
Set Up Co.Code for Contract Accounts Receivable & Payable, Define Co.Code Group, Application Area, Define Number Ranges, Define Sender Structure, Account Determination IDs for Contract, Maintain User Specific Posting Settings, Define Lock Reason for Posting Lock
Account Determination (Co.code, Division, Account Determination ID, Main Transaction, GL Account)
Security Deposit (Cash Security- Accepted in terms of Cash or Check) (Non Cash Security Deposit- In terms of bank Guarantee or Letter of Credit).
Installment Plans, Collection Management, Interest Calculation, Transfer of Item
Dunning, Transfer to GL, Reset Clearing, Late Payment Charges, Period End Closing
DYNPRO INDIA LTD from Jan’14 to August’14
Client : BRITISH AMERICAN TOBACCO (BAT), Implementation Project.
Role : Sr. SAP FICO Consultant
Organization : IBM INDIA PVT. LTD
Key Responsibilities
Understanding Business process of the Client’s Business and actively involved in SAP-FI/CO Implementation in Aegis Com Group
Structuring the Organization as per Aegis Requirement
General Ledger (FI-GL) taking care for uploading master data and configuring the pre-requisites which includes Creation of Chart of Accounts, Account groups, and Retained earnings accounts, etc.
Special Purpose Ledger (SPL) Define Table Group, Maintain Ledger, Maintain Local Posting Period, Maintain Valid Document Type, Actual Posting test from FI to Special Ledger, Report Painter
Accounts Receivable (FI-AR), and Accounts Payable (FI-AP) master data uploading and maintaining the prerequisites such as creation of account groups, number ranges and Payment configuration etc.
Configuration of AA (FI-AA).– Creating Legacy Assets and maintaining the prerequisites such as Chart of Depreciation, account determination, screen layouts, asset classes, defining depreciation key separately for book depreciation and Tax depreciation, asset master record and sub assets, acquisition, Creating Legacy Assets, Period end Closing
Configuration of Controlling area(CO), Maintaining CO version, Maintaining number ranges for planning and actual transactions in CO and Defining primary and secondary Cost Elements
Creation of Cost Center Groups and Cost Centers (CO-CCA), Defining different Activity types and Statistical key figures, Settings for Allocation of costs among cost objects with different methods like Assessments, distributions and reposting
Creation of allocation structures and settlement profiles, Creation of Different Internal Order Types, maintain planning and budgeting of Internal orders(CO-IO)
COPA- Structure, Master Data, Planning, Automatic Account Assignment.
Product Costing- Product Cost Planning (Basic Settings for Material Costing, Define Calculation Base, Define Overhead Key, Define Costing Sheet), Material Cost Estimate with Quantity Structure, Cost Object Controlling, Variance Calculation, Settlement.
Actual Costing/Material Ledger- Activate Valuation Area for Material Ledger, Actual Costing for Material Ledger, Price Determination, Realization of Material Ledger and Actual Costing, Config Dynamic Price Change, Define Access to Actual Costing & Material Ledger, Check Material Ledger Document after inventory posting in plants, Actual Costing run is final activity
Working in Workflow and Travel Management in HR Part
Imparting Training to the End Users.
Data Migration and Conversion Templates in Blue Print Phase are as follows:-
TaO Deployment Plan
Waves in different Deployment
Evaluate DMI Template, Set up Connectivity with Legacy System- Infra & BAO, Data Profiling-BAO
Prepare DMI & MAP (GL, AR, AP, Assets, CCA, PCA)
Facilitate Data Cleansing, Facilitate Record Matching, Data Load, Defect Resolution, Input in Cutover Plan
Review project and production change requests, advising on data related issues.
Perform required analysis, estimation and ‘trail runs’ to support data migration activities.
Test Management, Testing Tool Integration (HP Load Runner, HP Quality Centre.
In testing part in HPQC ( Prepare the Test Scripts, Documentation, and for each test case which is to execute the entire script and pass/fail is tracked at the unit test scripts level), In test scripts prepared in word ( Header Information, Test Script Description, Steps, Specific Test Master Data)
I have also created defect linked to specific step in Integration Testing.
SOLMAN- Test Requirement and Test Object from SOLMAN will flow to Quality Center, Test Script created and attached to the Test Plan in QC, Test Case Design (Create Script, Create Detail Test Component, Test Sequence).
CHARM – Change request approval, System Changed Activity Monitoring, Integration to Transport Routes.
CAPGEMINI INDIA LTD from Aug’12 to Aug’13
Client : BROOKS BROTHERS Inc. Implementation Project
Role : SAP FICO Consultant
Key Responsibilities
Involved in AS-IS process flow charts and designed blueprint workshops for finalizing Organization elements and for many integrated processes
Developed test cases and involved in unit testing and Integrating testing
Instrumental in developing Functional specs for data migration using BDC. Worked closely with
Development team
Configured the New General Ledger module
Defined Chart of Accounts, Account groups
Created General ledger master data of various B/S and P&L accounts both at chart of accounts level and company code level.
Created Bank Master data, House banks and GL accounts
Modification to the Field Status variants according to Clients specifications
Configuring Financial Statement version as per the Client requirements
Creation of Customer/Vendor Accounts Groups, Number Ranges, and Customer/ Vendor Masters Creation
Configuration of terms of payments for Customers/Vendors
Configured interest calculation methods for Customers/Vendor Payments and Bank Interest.
COPA- Structure, Master Data, Planning, Automatic Account Assignment.
Product Costing- Porduct Cost Planning (Basic Settings for Material Costing, Define Calculation Base, Define Overhead Key, Define Costing Sheet), Material Cost Estimate with Quantity Structure, Cost Object Controlling, Variance Calculation, Settlement.
Actual Costing/Material Ledger- Activate Valuation Area for Material Ledger, Actual Costing for Materail Ledger, Price Determination, Realization of Material Ledger and Actual Costing, Config Dynamic Price Change, Define Access to Actual Costing & Material Ledger, Check Material Ledger Document after inventory posting in plants, Actual Costing run is final activity
Documented End user manual and trained users – worked closely with them during Post- Go live period.
CAPGEMINI INDIA LTD from Jan’12 to July’12
Client : BAKER HUGHES Implementation Project
Role : SAP FICO Consultant
Key Responsibilities
Wave 3_ Cost Load involved in the following activities:-
Reconciliation: Initial Inventory Value from the extract, Final Inventory Value from Cost Load, Insufficient Quantity (in local currency & group currency).
General Ledger Reconciliation: W3_Inventory_Loaod.
EAS: Cost Data Load Process
Accounts Receivable by legacy ledger
Accounts Payable: FMDM Vendor Details Cross Reference-Inter Company, Employee Vendor Cross Reference, Trade Vendor Cross Reference.
Wave_3: Consolidated Profit Center, Consolidated Cost Center, Plant Profit Center.
CAPGEMINI INDIA LTD from June’11 to Dec’11
Client : LEVI’S Project
Role : SAP FICO Consultant
Key Responsibilities
Involved in the following activities:-
Prepare Week Status Report & Monthly Status Report of LSUS.
Fixed Assets Accounting: Organizational Structure-Multiple Chart of Depreciation, Book Depreciation post to leading ledger, Depreciation area post to local ledger, Assets Class, Acquisition, Transfer, Retirement, Depreciation Key, Integration with General Ledger.
General Ledger: COA, Account Group, Fiscal Year Variant, Foreign Exchange Valuation, Post Recurring Entries,
Bank Accounting: APP, Cash Journal, Bank Reconciliation,
COPA- Structure, Master Data, Planning, Automatic Account Assignment.
Product Costing- Porduct Cost Planning (Basic Settings for Material Costing, Define Calculation Base, Define Overhead Key, Define Costing Sheet), Material Cost Estimate with Quantity Structure, Cost Object Controlling, Variance Calculation, Settlement.
Actual Costing/Material Ledger- Activate Valuation Area for Material Ledger, Actual Costing for Materail Ledger, Price Determination, Realization of Material Ledger and Actual Costing, Config Dynamic Price Change, Define Access to Actual Costing & Material Ledger, Check Material Ledger Document after inventory posting in plants, Actual Costing run is final activity
ITSM & Charm Process: ITSM- Tracks Request, Incidents & Changes for all systems, System record for all change requirement, required to trigger a change request in CHARM for changes that require an SAP transport. CHARM- Used only for SAP impacted changes which require a transport, Triggered from an ITSM change order when a transport is required in SAP.
In testing part in HPQC ( Prepare the Test Scripts, Documentation, and for each test case which is to execute the entire script and pass/fail is tracked at the unit test scripts level), In test scripts prepared in word ( Header Information, Test Script Description, Steps, Specific Test Master Data)
I have also created defect linked to specific step in Integration Testing.
SOLMAN- Test Requirement and Test Object from SOLMAN will flow to Quality Center, Test Script created and attached to the Test Plan in QC, Test Case Design (Create Script, Create Detail Test Component, Test Sequence).
WDC LTD from April’10 to June’11
Client : BLUE HARMONY Project
Role : SAP FICO Consultant
Organization : IBM INDIA PVT. LTD
Key Responsibilities
Involved in the following activities:-
oConstruction: Test Case, Test Scripts, Test Suite
oExecution: Test Suite, Test Scripts, Test Results & Reports
oDefect: How to create a defect, Defect field description, Defect process in Clear Quest
oTrouble Shooting Tips: Test Suite Interruption, Recovering, Test Script Execution through Rational Quality Manager
oWork Certify Tools: Test Suites are run in work certify on the test scripts basis, When execute the system capture the sap screen and on that basis system shows the result. In this tool mainly 6 steps are there: Requirement, Processes, Data, Variable, Results & reports.
WDC LTD from July’08 to March’10
Client : PHILIP MORRIS INTERNATIONAL Project
Role : SAP FICO Consultant
Organization : IBM INDIA PVT. LTD
Key Responsibilities
Involved in the following activities:-
General Ledger: Maintain General Ledger- General Settings
oAccounts Receivable and Accounts Payable: Invoice verification of Vendor, Vendor Master Data and Customer Master Data, Creation of House Bank, Automatic Payment Program, Tax on Sales & Purchase.
oSet Up of Cash Journals
oAsset Maintenance: Define Asset History Sheet, Define Chart of depreciation & assign to company code, Define how depreciation areas post to G/L, Specify Doc type for posting of Depreciation, Maintain depreciation key, Define Substitution rule.
oRoyalties & Withholding Tax: Activate Extended Withholding tax, Define withholding tax type for Invoice posting & Payment posting, Assign Withholding Tax type to Company code.
oCost Centre Accounting: Configuring the controlling area, cost element accounting set up, setting cost Centre hierarchy, cost Centre master data, and activity type.
oProfit Centre Accounting: Maintain profit center settings for controlling area, creation dummy profit Centre, creation of standard hierarchy and creation of profit Centre master, profit center panning configuration.
COPA- Structure, Master Data, Planning, Automatic Account Assignment.
Product Costing- Porduct Cost Planning (Basic Settings for Material Costing, Define Calculation Base, Define Overhead Key, Define Costing Sheet), Material Cost Estimate with Quantity Structure, Cost Object Controlling, Variance Calculation, Settlement.
Actual Costing/Material Ledger- Activate Valuation Area for Material Ledger, Actual Costing for Materail Ledger, Price Determination, Realization of Material Ledger and Actual Costing, Config Dynamic Price Change, Define Access to Actual Costing & Material Ledger, Check Material Ledger Document after inventory posting in plants, Actual Costing run is final activity
Also involved in Unit Test Document for Configuration.
GAMMON INDIA LIMITED from Mar’ 08 till Jul’ 08
Client : Sabarmati Riverfront Development Project at Ahmedabad
Role : Accounts Executive (ERP)
Key Responsibilities
Cash A/c & Work Cash A/c preparation.
FBT preparation after month end Cash A/c.
Col 21 Advance Posting
Liability Statement preparation & MFS.
MB Checking and Payment abstract Preparation.
IBM Preparation
GANNON DUNKERLY & CO.LTD. From Aug’ 06 till Mar’ 08
Client : Reliance Industries Ltd at Jamnagar
Role : Accounts Officer (SAP-fico)
Key Responsibilities
Responsible for Budgeting, Accounts & MIS preparation which involved the following activities:-
oAnalyzed MIS reports & documentation at the end of each month.
oFormulated various budgets & conducted variance analysis to determine difference between projected figures & actual expenditure and recommended corrective actions.
oPrepared various ledgers & reconciliation statements for analyzing the books of accounts.
oPrepared and maintained statutory books of accounts viz, journal, ledger, cash book and subsidiaries in compliance with time & accuracy norms.
oPresented a true and fair view of the financial position of the company by preparing financial statements.
oManaged payment of Bills and oversaw other Payable/receivable operations.
oReconciled inter branch accounts and monitored branch records as well as preparing creditors/ debtor’s reconciliation statements.
Accountable for the entire gamut of finance operations which included the following:-
oPrepared annual budgets as well as conducted variance analysis to find out causes of deviation and undertaking corrective measures.
oLiaison with banks / financial institutions for raising adequate finance to meet working capital and long term capital requirements.
oManaged fund and working capital requirements thereby ensuring optimum utilization of the same for meeting financial commitments of the organization.
Managed Auditing on related activities including conducting verification of various books of accounts to detect any possible fraud and ensuring that accounts prepared conform to swiftly handling matters related to TDS, FBT etc.
SCIENTIFIC TIMESHARING SYSTEMS LTD. Apr’ 99 to May’ 02 and June’04 to till Aug’ 06
Role : Accountant
Key Responsibilities
Responsible for the maintenance of books of accounts, such as Cash Book, Bank Book, Journal, Sales & Purchase Register etc.
Accountable for Commercial Accounting including Billing upon customers and follow up with the customers regarding outstanding dues, Sales & Purchase Accounting and the Payment to Suppliers & Contractors.
Involved in Branch Accounting to effectively co-ordinate with head office regarding monthly reports and coordinate with Branch offices for financial and other accounting matters/reconciliation
Responsible for the maintenance of branch accounts.
SUMMER TRAINING
Project Name
Financial Statement Analysis
Organization
Berger Auto & Industrial Coatings Ltd.
Duration
2 months
Role
Summer Project Trainee
Project Name
Advertising & Promotion
Organization
Indian Institute of Software Technology
Duration
2 months
Role
Summer Project Trainee
EDUCATION & PROFESSIONAL DEVELOPMENT
MBA- FINANCE- 2004
Sikkim Manipal University
B.COM HONS. – 1995
Calcutta University
CLASS XII- 1991
West Bengal Board of Secondary Education
CLASS X- 1989
West Bengal Board of Secondary Education
Date of Birth: 19th July, 1972
Language Proficiency: English, Bengali, and Hindi.
Permanent Address: 7A, Lala Babu Shire Road. Post: Belurmath, Dist: Howrah. Pin No: 711202.
Present Address: 95/34, Bose Pukur Road, Bank Plot, Kolkata-700042. (Near Bakultala Bus Stop)
Passport No. F6209436
References: Available on request