LILY.SUNIL KARMAKAR Mobile: +1-484-***-****
SAP FI/CO Consultant E-mail: ***********@*****.***
OBJECTIVES
Having 9+ years of overall experience of which 7 years in SAP FI/CO Consultant. Hands on experience of handling 1 End to End Implementation Projects, 2 Support Projects, one Development Project, One Technical Up-gradation Project and 2 Roll-out projects. Having around 2 years of functional experience as an Accountant and lecturer.
Familiar with ASAP methodology, Business Process Design based on concept documents and documentation. Capable to work in any stage of the project from Blueprint to Go-Live, post Go-Live including maintenance and support.
Expertise in defining the interface with different systems based on Business requirement using RFC, ALE connections for Idoc settings for interfaces like vertex for tax calculation.
Expertise in configuration and support in the areas of General Ledger Accounting, Accounts Receivable, Accounts Payable, Asset Accounting, Bank Accounting & on Integration of FI with other modules like Material Management (MM), Sales & Distribution (SD). Working knowledge of integration with Material Management (MM), Sales & Distribution (SD).
Expertise in configuration and support in CO module like cost elements (CO-CEA), Cost center accounting (CO-CCA), profit center accounting (CO-PCA), Internal Orders (CO-IO), Product Costing (CO-PC) with different processes like Cost Estimate (CEP), Make to stock (MTS) & Make to Order (MTO) Process and Profitability analysis (CO-PA)
Working experience in HP ALM tool, HP QC, Mercury test Director, Oracle Central Office for POS retail system, Control M and Remedy tool.
Knowledge on (Cash management, and Cash concentration) in Treasury Management to create Source symbols, planning levels, planning groups, Treasury groupings, cash management, account groups
Working experience with Testing methodologies as well,(Unit .Regression, Integration), Expertise in creating test plan,test case and execution.
Good team player with excellent technical, interpersonal and presentation skills. Self-motivated and able to work independently as well as in team. Comfortable working in a team environment with tight schedules.
Experience
Working as a SAP FI/CO Consultant in Daimler-Mercedes Benz in Georgia Atlanta from October 2016 to till date.
Worked as a SAP FI/CO Consultant in Limited Brands (Mast Global) in Bangalore from September, 2014 to January 2016
Worked as a SAP FI/CO Consultant in Capgemini India Pvt. Ltd. in Bangalore from June, 2013 to August, 2014
Worked as a SAP FI/CO Consultant in HCL Technologies in Bangalore from November 2011 to September, 2012
Worked as a SAP FI/CO Consultant in Intelligroup Asia Pvt Ltd, an NTT DATA company in Bangalore from March 2011 to November, 2011
Worked as a SAP FI/CO Consultant in IBM India Pvt. Ltd. in Bangalore from August 2009 to February, 2011
Worked as an Operation in charge in ICICI Bank, Allahabad from October, 2005 to December, 2007
Education Qualification
B.Com from Allahabad University, from 2000 to 2003, March.
Completed Computer Diploma Aryavart InstituteAllahabad,from 2003 to 2005.
Skill Set
SAP –R/3 FI/CO MODULE 4.7c and ECC 6.0
Working Knowledge in Operating System Windows 98,2000 and vista
Working Knowledge in Ms – Office
Accounting Package : Tally 7.2
Certification
Completed NCFM Certification in Capital Market from NSE, Mumbai.
SIX SIGMA Certification from IBM.
SAP-FICO Project Summary
Project # 6
Project Name : Daimler-Benz AG, Atlanta,
Employer : Daimler,
Project scope : Support,
Role : FI/CO Consultant,
Duration : October, 2016 to till date.
Client Details
Daimler-Benz AG was a German manufacturer of motor vehicles and internal combustion engines; founded in 1926.
In 1989 Daimler-Benz Inter Services AG (Debi’s) was created to handle data processing, financial and insurance services, and real estate management for the Daimler group
Job Responsibilities
Provided functional & Technical support for all the areas like General Ledger, Accounts Payable, Accounts Receivable, CO-Cost center Accounting, CO-Cost Element Account, CO-Profit Center Accounting, Asset Management and integration with MM, SD & HR
Solved the High, Medium and Low priority tickets with in SLA (100% performance)
Working as a lead Consultant and assigning Incidents to respective team member which has raised by customers using Remedy tool
Provided the solutions for incident, ordering and problem management tickets with in the target dates
Updated the necessary documentations for critical issues based on the request from the customer to know the reason of the issue
Analyzed the functional specifications and user exist to find out the root cause of issues
If the effort exceeded Based on SLA for new request incident, will request t Business to raise a new CR (Change Request)
SAP-FICO Project Summary
Project # 5
Project Name : In-house - Limited Brands,
Employer : MAST global, Limited Brands, Bangalore,
Project scope : Change Request & Support,
Role : FI/CO Consultant,
Duration : September 2014 to January 2016.
Achievement : Best performer / Best in project Delivery
Client Details
The company's products are available in over 3,000 specialty stores nationwide, through the Victoria's Secret Catalogue and online. Through its La Senza brand, products are also available in Canada as well as approximately 40 other countries around the globe. Limited Brands recorded sales of $9 billion in 2008 and employs more than 90,000 associates throughout the United States.
LBI headquarters are located in Columbus, Ohio. We also have offices in New York, New York, Kettering, Ohio and Rio Rancho, New Mexico.
Job Responsibilities
Provided functional support for all the areas like General Ledger, Accounts Payable, Accounts Receivable, CO-Cost center accounting, CO-Cost Element Accounting, CO-Internal Order, CO-Product Cost Controlling, CO-Profitable Analysis, CO-Profit Center Accounting and Integration with MM, SD, Asset Management and Project System.
Solved the High, Medium and Low priority tickets with in SLA (100% performance)
Analyzed the tickets raised by customers in Remedy Tool and assigning to respective person in group.
Provided the resolutions for incident, ordering and problem management tickets with in the target dates.
Updated the necessary documentations like critical issues based on the request from the customer to know the root cause of the issue.
Analyzed the functional specifications and user exist to find out the root cause of issues
Change Request
Simultaneously worked with CR team and completed the tasks within the time limit.
Possess good communication in handling the meeting with customers to understand the complete requirement & Business Process
Prepared the functional specification to meet the customer requirement
Consulting with technical team to explain the functional logic to develop the new reports and new programs as per customer requirement.
100% delivered in time limit.
Configuration of cash pool transaction as per business requirement in Electronic bank statement, E-notification for Automatic Payment Program (APP), Calculation of Cash discount, customer request forms etc.
Maintained validations, substitution and user exit based on the business requirement
SAP-FICO Project Summary
Project # 4
Project Name : T-Mobiles, US,
Employer : Capgemini India Pvt. Ltd., Bangalore,
Project scope : Rollout,
Role : FI/CO Consultant, CI Role,
Duration : June 2013 to August 2014.
Client Details
T-Mobile USA, Inc. is a mobile network operator headquartered in Bellevue, Washington, United States that provides wireless voice, messaging and data services in the United States, Puerto Rico and the U.S. Virgin Islands. T-Mobile USA is the fourth-largest wireless carrier in the U.S. market with 33.73 million customers and annual revenues of US$21.35 billion in 2010.
Job Responsibilities
ICO team visited Plant to interact with client and user department to understand the business process and prepared study document.
Prepared Business Blue Print as per the study document and signed-off.
Involved in realization phase and completed the following customizing and developments.
Customizing
Configuration of New Vendor account group & Vendor master records, Created New Payment terms, payment differences, tax codes, extended Special GL transactions like Down payments, bills of exchange, bank bills & Bank Guarantees for New vendors of Jaipur plant.
Configuration and Settings of new Asset Classes, Asset Master Records for new assets. Define new depreciation keys to calculate depreciation for Jaipur plant. Define and assign the G/L accounts with new account determination for various processes like Asset acquisition, asset transfer, sale of asset with Gain/Loss calculations and Asset retirement without customer and without revenue.
Implemented Check functionality to print check at the time Customer payment, Vendor Payment and Expenses posting.
Integration with other core modules like Material Management (MM), Sales & Distribution (SD) and Production Planning (PP) for Different Business Processes at Plant level
Created a New cost center structure and mapped business processes based on that
Provided internal Order processes with more effectively.
Created assessment cycle for settlement from supporting cost center to manufacturing cost center to compare with Plan and Actual.
Configured overhead percentage in costing sheet and costing variant for standard cost estimate for production activities.
Created a new order type to know the Rework order cost.
Configured Variance key to calculate variance between standard and actual cost.
Created Product Wise Profitability Reports as per business requirement.
Developments
Extended Substitutions and Validations for new plants
Following four way matching functionality for Invoice Verification using ZMIROBAPI.
Developed Tax Calculation reports
Developed Incentive Calculation Report to know about Incentives.
Completed Training and Completed Test Script.
Successfully completed the Integration Test-1 and Test-2.
Successfully went live the project without any major issues as per planned date.
SAP-FICO Project Summary
Project # 3
Client : GlaxoSmithKline
Employer : HCL Technologies in Bangalore
Project scope : Upgradation Project (ECC 6.0)
Role : FICO Consultant
Duration : November 2011 to September, 2012
Client Details
GSK one of the world's leading research-based pharmaceutical and healthcare companies. Headquartered in the UK, we are a global organization with offices in over 100 countries and major research centers in the UK, USA, Belgium and China.
Established in the year 1924 in India GlaxoSmithKline Pharmaceuticals Ltd. (GSK Rx India) is one of the oldest pharmaceuticals company.
Job Responsibilities
Involved in business discussions to plan the list of systems to upgrade from version 4.7 to ECC 6.0.
Planned all the areas like G/L, AR, AP, Integration with MM, SD and Asset management.
Scheduled the testing activities as phases wise and competed all the scenarios testing and handled issues quickly and independently.
Successfully completed all the testing scenarios and got the sign off documents from business.
Successfully completed the technical up-gradation project from 4.7verson to ECC 6.0 without major issues.
Supported to post go-live to close all open issues
SAP-FICO Project Summary
Project # 2
Client : T-Mobiles, US,
Employer : NTT DATA Company in Bangalore
Project scope : Rollout Project
Role : FICO Consultant
Duration : March 2011 to November, 2011
Achivement : Best Performer (Client Certificate)
Client Details
T-Mobile USA, Inc. is a mobile network operator headquartered in Bellevue, Washington, United States that provides wireless voice, messaging and data services in the United States, Puerto Rico and the U.S. Virgin Islands. T-Mobile USA is the fourth-largest wireless carrier in the U.S. market with 33.73 million customers and annual revenues of US$21.35 billion in 2010.
Job Responsibilities
Involved in Concept phase to gather the requirement
Prepared TO-BE process documentation as per user requirement and get signed-off
Involved in realization phase and completed the all the customizing & reports
Successfully completed Integration Test-1 and Test-2 in get the signed off.
Involved in the following customizing
Configuration and Settings for Customer Groups, Vendor & Customer master records, Payment terms, payment differences, Tax on sales and purchases, Withholding Tax, Dunning letters for Customers, check exchange rate system for foreign currency transactions, Special GL transactions like Down payments, bills of exchange, bank bills, Payment requests & Guarantees
Configuration and Settings up of new Asset Classes, Account determination, Asset Master Records, creation of new assets. Define depreciation key to calculation for depreciation. Define and assign the G/L accounts with new account determination for various processes like Asset acquisition, asset transfer, asset scraping and sale of asset with Gain/Loss calculations
E-notification with new functionality to with existing customizing set-up to trigger the E-mail for staff vendors, once run the Automatic Payment Program.
The Integration with other core modules such as Material Management (MM), Sales & Distribution (SD)
Creation of New cost centers, Internal Orders and Profit centers.
Created new CO-PA reports for Profitability reports.
Created the Profit center report, Sales by Material Group excluding internal transfer report, Net sales to 3rd party by country report.
SAP-FICO Project Summary
Project # 1
Project Name : Limited Brands
Company : IBM India Pvt. Ltd. in Bangalore
Project scope : Implementation
Role : FI/CO Consultant
Duration : August 2009 to February 2011
Client Details
The company's products are available in over 3,000 specialty stores nationwide, through the Victoria's Secret Catalogue and online. Through its La Senza brand, products are also available in Canada as well as approximately 40 other countries around the globe. Limited Brands recorded sales of $9 billion in 2008 and employs more than 90,000 associates throughout the United States.
LBI headquarters are located in Columbus, Ohio. We also have offices in New York, New York, Kettering, Ohio and Rio Rancho, New Mexico.
Job Responsibilities
Have been involved in the AS-IS study phase and prepared documentation with the interaction of the clients meeting.
Prepared the TO-BE Documentation based on the requirements in all the processes like G/L, A/R, A/P, A/A, CO-CEA, CO-CCA, CO-Cost estimate Process, STO Process and CO-PA and all the open points have been addressed.
Involved to maintain the RFC and ALE connections to set up idoc settings to transfer the data from one system to another system for consolidation
Prepared functional specifications for user exits, new reports, forms and new developments.
Involved in cutover activates for successful go-live with less issues
Involved in the IDOCs,EDI and Banking process.
Worked for the POS system, PIPE using Oracle central office and SAP.
Involved in the following customizing
General Ledger (GL) Configuration and Settings of Enterprise structure, Chart of Accounts, Fiscal year variant, Variant for Open posting period, Open and close posting period variant, Chart of Accounts, Account Groups, Field status variants, Retained earnings account, GL Master Records, Account Assignment Models, and Recurring entries
Accounts Receivable (AR) Configuration and Settings for Customer Groups, Customer master records, Payment terms, payment differences, Interest Calculation, Tax on sales and purchases, Withholding Tax, Dunning letters for Customers, define the credit control area, check exchange rate system for foreign currency transactions, Special GL transactions like Down payments, bills of exchange, bank bills, Payment requests & Guarantees
Accounts Payable (AP) Configuration and Settings for Vendor Groups, Vendor master records, Payment terms, payment differences, Interest Calculation, Tax on sales and purchases, Withholding Tax, check exchange rate system foreign currency transactions, Special GL transactions like Down payments, Bills of exchange, Bank bills, Payment requests & Guarantees
Asset Accounting (AA) Configuration and Settings up of Asset Classes, Asset Master Records, creation of new assets, Creation of AUC’s and settlement of the same by Capitalizing the Assets. Define depreciation key to calculation for depreciation. Define and assign the G/L accounts with account determination for various processes like Asset acquisition, asset transfer, asset scraping and sale of asset with Gain/Loss calculations
Bank Accounting (BL) Configuring House banks, Bank accounts, maintaining Cheque Register, automatic payment program and maintain cash journal
Treasury Management (TM) Define variants, posting keys and posting rules for check deposit processing. Prepare the manual bank statement and electronic bank statement.
The Integration of the accounting modules with other core modules such as Material Management (MM), Sales & Distribution (SD) and knowledge on Integration CO module with Project system (PS) to define the Planning profile, Budget Profile and Result Analysis to update the WBS element in Project Builder
CO-CEA-CCA: Creation of standard hierarchy, Creation of primary cost elements, Creation of secondary cost element to calculate the overhead calculation with assignment in costing sheet, to estimate the cost and calculate the work in progress in result analysis based business requirement.
Creation of cost centers, activity types, statistical key figures, commitment management, Budget profile to allocate the budget to cost center for internal reporting purpose. Customizing for accrual calculation for plan and actual to prepare the end user documents for training like Activity type planning and execution of assessment and distribution cycle for basis of allocation.
CO-IO: Creation of different types of real and statistical orders for settlement and reporting purpose. Creation of planning profile, settlement profile and budget profile to define the internal order type.
CO-PCA: creation of profit center standard hierarchy, creation of profit centers, creation of dummy profit centers and Activate direct posting & settings for profit center account. Maintain the default account assignment as per business requirement. Prepare user documents for training like creation of account group to create the distribution and assessment cycles.
Cost estimate process: Define costing sheet for over head calculation, Define cost component structure to calculate the activity price or material costing, Define costing variant for cost estimation. There is no MTS and MTO Process since there is not production
CO-PA: Set operating concern, maintain and creation of characteristics. Assign the value fields and quantity fields to flow the values form different module in to CO-PA, maintain Characteristic Derivation and creation of different reports using report painter for margin
Functional Experience
Organization : ICICI Bank Ltd, Allahabad
Period : October 2005 to December 2007
Role : An Operation In charge
Job Responsibilities
Branch Co-ordination.
Managing and generation of necessary MIS.
Controlling Operational Unit.
Business Development.
Sale of demat and trading a/c.
Team Management with marketing research.
Future And Option and Pledging of shares.
Mutual Fund, Insurance and other investment products.
Transposition and transmission of shares.
Achievements in ICICI Bank:
Appointed as a Tele-caller.
Promoted as Back office.
Promoted as Assistant Team Manager.
Promoted as Team Manager in May.
Promotes as Operation In charge.