Post Job Free

Resume

Sign in

Accounts Payable Accounting

Location:
Naperville, IL, 60564
Posted:
March 12, 2017

Contact this candidate

Resume:

Narendran Rajan

SAP S* Hana Consultant

773-***-****

acy85w@r.postjobfree.com

PROFESSIONAL SUMMARY:

12+ years SAP FICO Functional Consultant with sound and resourceful experience in varied Industrial sector like - Software and Consumer Electronic, Manufacturing, Life Science – Medical devices, Agricultural Heavy equipment, products and End to End Business process Knowledge.

10+ years as Accountant with extensive exposure Accounts, Auditing, Taxation – Direct and Indirect.

Leading Clients Microsoft, John Deere, St. Jude Medicals, Estee Lauder, Tate & Lyle, BNSF Railways (a Berkshire Hathaway Inc. Division), Bose Corporation, Harmon International.

Expert knowledge of Financial, Cost and Management Accounting practices prevailing in multiple industrial sectors - Textile Processing, Construction, Travels, Trading and Chartered Accountant firm.

Simple Finance, ECC 6.0 and SAP R/3 Involved in Five Full life cycle implementation with exposure to all phases of projects like Requirement gathering, Business process analysis and improvement, legacy system study, GAP Analysis, Blueprinting, Design, Development, RICEFW Functional Specs Configuration, Customization, Testing and Training to Post Go Live Support and Hyper care.

SAP Training Center – Successful Completion Classroom training by SAP for TZRAR1 – Revenue Accounting and Reporting 1.2 IFRS15.

Sound knowledge of FIRS 15 RAR and IFRS 16 Lease Accounting provisions.

SAP FI extensive expertise and exposure to Designing, Configuring and Testing Asset Accounting AA, Project systems PS, Investment Measures IM, General Ledger Accounting GL, Accounts Payable AP and Accounts Receivable AR especially in highly Complex Business Environment.

Business scenario drafting and scripting, Testing - Functional, Integration and Regression Testing.

Project Documentation and Record keeping - Conversant with Solution Manager, HP Mercury Quality center, BMC Remedy, IBM Ascendant, SharePoint documentation, MDM, VSTF.

Sound interpretation skills of Generally Accepted Accounting Principal (GAAP), International Financial and Reporting Standards (IFRS) required to be adhered in implementation of FICO module.

Simple Finance indepth knowledge of the SLT and DMO Migration process involing Accounts receivable, Accounts payable and Fixed Asset module with POC and Demos for Clients.

Extensive functional expertise and exposure to cross-functional coordination, design and configuration of cross functional integration FICO with MM, SD, BPC, PS modules and legacy systems DB2, Mainframe, RaodMac, MFGPro, Alfred and developed Integrated functionality reports.

Expertise in Month end and Year end closing operations and process improvement.

Strong Academic background in Financial, Management Accounting and Cost Accounting principles.

Master Data Mapping / Migration from Legacy system to SAP R/3 using LSMW and Batch input.

Worked on various enhancements and User Exits, Reports, business security role authorization and user creation, troubleshooting and resolving problems and trouble shooting for GRC compliance testing.

Team Lead- Mercury Quality Center (MQC) System and Regression Testing coordinator with offshore.

Effective command over oral and written communication,Excellent Documentation and presentation skills, Dynamic team player with high learning Acumen to adopt new Technologies and Tools.

Education / Certifications MS Finance – United States.

Masters (Financial & Management Accounting) – India.

SAP Training TZRAR1 – Revenue Accounting and Reporting 1.2 IFRS15.

SAP SKILLS

FI Fixed Asset, Project Systems, Investment Measures, General Ledger, Accounts Payable / Receivable, Asset Accounting, RAR 1.2.

CO Cost Center Accounting, Cost & Revenue Element Accounting, Internal Order, Profit Center Accounting & Profitability Analysis

Integration/ Interfaces FICO integration with SD, MM and vertex / LSMW, I Doc’s, BDC, BAPI

BI FI, SD and MM reports validation

Flex Charms, Solution Manager, BMC Remedy, Mercury HPQC

Professional Experience

SAP AMERICA - FI S4Hana Consultant Oct 2016- Till date

S4Hana 1511 FI Implementation integrated with Project system, CPM and Fiori App

Project Description/Scope: IT Client is a multinational technology company which manufactures, develops, licenses, support Telephone technology for use in enterprise wide area network and leading supplier of DS3, T1/E1, Digital subscriber Line, Frame Relay, Asynchronous Transfer Mode (ATM), Integrated Services Digital Network (ISDN) and Digital Data Services (DDS).

Responsibilities/Deliverables:

Requirement gathering, Process mapping of General ledger, Accounts receivables, Accounts payables, Fixed Asset with project systems - Greenfeild implementation.

Demonstrated Asset accounting functionalities Fiori Apps, S4Hana system and Netweaver NWBC.

Business User sessions for the General ledger, Accounts payable and Fixed Asset functionality involving team members from SAP and non- SAP background.

Functional design finalization for the Acquisition, Transfer, retirement, valuation, depreciation calculation, month end and year end closing process.

Defined technical clearing account for integrated asset acquisition and activated accounts assignment objects.

Checked all setting and pre activation check for the Green Field implementation for Fixed Asset

Configured and Defined period control method for the asset accounting.

Configured Automatic payment program, set up all company codes for payment transactions, set up payment method for country, Bank determination for payment transactions.

Workflow for purchase order for Capital acquisition for to be settle to Fixed assets.

Configured additional asset classes to fit business requirements.

Demonstrated Asset Accountant role in Fiori App for Opening and reversing asset accounting document posting in the Asset under construction, asset intercompany transfers, Asset scrapping without consideration.

Workshop sessions with SD, MM team finalize the integrated end to end process flow and figure out integration points and enhancements required.

Review Depreciation Test run with business users, validation with the Business users on the fixed asset balances, Verifying the specific depreciation requirements.

Analyzing the 1610 simplification list for possible upgrade from 1511 to 1610.

Business Requirements and Functional Design requirements documentation for configuring SAP system enhancements for legacy systems interfacing with SAP

Working with business to have the signoff and acceptance from business users and stakeholders.

Experience and expertise analyzing and building enhancements to system interfaces between SAP and legacy systems, mapping data, data conversion or data migration

Microsoft, Redmond, WA.

FICO Lead Consultant with additional BPC responsibility Jan - Sept 2016

Microsoft is a multination technology company which manufactures, develops, licenses, supports, sells computer software, consumer Electronics and personal computers and best known for windows operating system and Microsoft office suite. It is second to none as the world’s largest software maker by revenue and one of the World’s Most valuable companies.

FI Environment : FICO, BPC, BW General Ledger, Fixed Asset, Project systems, CCA, PCA, COPA, Product Costing, FSCM – Credit Management, Treasury, Mercury, MS Sales, wasabi, Alfred,

Requirement gathering, Blue Printing, Functional specifications for the Intercompany relations and transactions worldwide, creating intercompany owing and settlements through IHCC – House bank for the Worldwide Transfer Pricing Intercompany Automation Project-WW TPIC Project.

Design and blue printing sessions with Business SME’s, SAP America, PWC, E&Y and Accenture Team involving intercompany transactions and settlements through multiple systems and landscape, Mercury, Alfred, MS Sales, Wasabi, BI, BPC and ECC solutions.

Finalized business design and functional guidance in setting up BPC dimensions and members for Retraction of the data from BPC to ECC and BPC to mercury update of master data sync.

Designed solution for Commission, Royalty and Product Payment (MOPR) calculation logic in BPC

Designed intercompany settlement involving multiple settlements on a Monthly, Quarterly true ups, semi-annual true up, Annual true up on sub- ledger, General ledger and IHCC processes.

Maintained Intercompany relations for the intercompany transactions with spread across the globe.

Business process and design for the intercompany calculation of the Commissions, Royalties, Product payments, shared services, cost sharing agreements and arrangements between the parent and subsidiary companies operating every country across of the world.

Configured IC Transfer pricing integration with material management, Sales and distribution.

Activated Asset accounting in new Company code with required additional Asset classes.

Configured Asset Classes, depreciation keys, transaction types, asset master data, acquisitions, retirement, group assets, and capitalization of asset under construction.

Customized report for asset accounting with additional field requirement to comply with additional requirement by the auditors.

Created Account assignment models, recurring entries and sample entries as per business requirement.

Configured general ledger accounts for Inter-company billing process and Inter-company Accounts payable for inter-company transactions and across legal entities.

Accounts payable : configured Automatic Payment program – paying company code, payment methods in the country, Payment method in company code, bank determination, House bank and payment media.

Record maintenance in VSTF – Visual Studio Team Foundation Server and MTM – Microsoft Test Manager – Web based Testing tool owned by Microsoft.

Business Requirements and Functional Design requirements for custom application development, building a new system or enhancing existing systems

Business Requirements and Functional Design requirements documentation for configuring SAP system enhancements or enhancements to legacy systems interfacing with SAP

Align Global Chart of accounts with Local Chart of account as a part of Global Acquisition and merger.

Heavy interaction with business, Legacy SME’s, Technical Lead, and technical IT resources to analyze impact to SAP and legacy systems identifying general ledgers to merged and closed and redesigning the Financial statement version for local reporting in compliance with GCOA compliance.

Analyzing the evaluating the legacy interface changes impacting changes by analyzing the transaction volume changes, changing the inter face logic.

Complete business requirements analysis for configuration enhancements to SAP and legacy systems that interface to SAP, working with business to acquire signoff from stakeholders.

Experience and expertise analyzing and building enhancements to system interfaces between SAP and legacy systems, mapping data, data conversion or data migration

John Deere, IL

FICO Lead Consultant March 2014 – Dec 2015

John Deere largest manufacturer of Agricultural machinery in the world and is one of the global fortune 500 Company. Deere and company agricultural products are sold under the brand name John Deere and includes Tractors, Combine harvesters, Cotton Harvesters, balers, planters, seeders, sprayers, construction equipment and suppliers of Diesel engines

FI Environment : Distributed FICO, General Ledger, Fixed Asset, Project systems, CCA, PCA, COPA, Product Costing, FSCM – Credit Management, Treasur, BPC, Hyperion, Simple Finance S4Hana.

Analysis of business requirements, determining organizational structures and classifying business units/locations as company codes, business areas and profit centers

Configured New Asset Class with Memo value as business requirement and transferred required assets from old asset class to new asset class.

Created Assets and Sub Assets as a part of the conversion projects to accommodate all the legacy assets.

Unit and functional testing for the Acquisition, transfer and retirement of the assets and validated the results with the business users, SME’s and project stack holders.

Designed and developed Asset net book value report as per the business requirement.

Rationalize and Mass Change the description of the assets to suite the business naming conventions.

Co-ordinated with Master cutover plan and enlisted the cutover activities for asset data migration and performed the 3 cycles of the cutover activities including the mock cutover.

Evaluated Asset base of the legacy company code with business users to clean up the assets master record for Data Migration before uploading in the SAP Asset accounting through AS91.

Developed program base on BTE’s to give visibility to Down payment in logistics system on booking of invoices through MIRO and MIRA including the withholding tax deducted on vendor down payment.

Developed and enhanced fixed asset reports to give visibility to additional business requirements based on Cost center and business areas created additional sort variants for CIN implementation.

Design and configuration for Distributed FICO model for Accounts payable with logistics and finance in two different landscape for country India version involving Withholding Tax, Excise duty.

Designed and configured logistics transactions for finance related activities in Distributed environment involving replication of logistics related transactions in Logistics and Reporting landscapes.

Configured duplicate invoice check based on company code, invoice reference and date of invoice.

Invoice verification and processing – stock /non stock, duplicate invoice check, payment block reason.

Configured automatic payment progress with payment method per country for payment transaction.

Defined reason code for overpayment and underpayments, configured accounts for overpayment, underpayment, exchange rate difference, rounding off differences.

Configured Automatic payment program, set up all company codes for payment transactions, set up payment method for country, Bank determination for payment transactions.

Evaluated foreign currency valuation setting, intercompany elimination rules.

Maintained Vendor Master data accounting view, withholding tax details for country India.

EDI and IDoc setup for distributed FICO for replication of the finance documents in the reporting landscape, maintained partner profile for the middleware Gentran and PI system

Configured and implemented passive acknowledgement for the invoices posted through EDI.

Solution manager for tracking of the issues and transport management.

Profit Center Standard Hierarchy, master data, standard hierarchy, Dummy profit center.

Created Cost Element, Cost Center, cost center groups, Standard Hierarchy, profit center, profit center groups, made necessary changes to cost center and profit center hierarchy.

Maintained primary and secondary cost centers, activity types, statistical key figures.

Cost center accounting created new cost center, Run Reports for Cost Center Accounting, Cost Center Activity Price report, Created Cost Center Group, Actual/Overhead Calculation for Cost Center /Activity

Maintained Profit Center groups and changes to Standard Hierarchy, cost center groups and changes to cost center Hierarchy. Created new profit centers and cost centers to enhance financial analysis.

Configured Costing and Accounting based profitability Analysis, created Characteristics, derivation rules, derivation Strategy, value fields and valuation strategy for the Operating concern.

Configured Derivation rules for characteristics and used fixed characteristics and had maintained derivation steps to overwrite the fixed characteristics.

HPQC ALM Mercury Quality Center unit Testing, UAT–User Acceptance Testing, FIT-functional verification testing, SIT - System Integration Testing with business user, Regression Testing

Tate & Lyle, IL Sept 2013 – March 2014

FICO Consultant – Fixed Asset

Global provider of distinctive, high quality ingredients and solutions to the food, beverages and other industries through their large scale efficient manufacturing plants using innovative technology to turn raw materials into high quality ingredients for our customers to add taste, texture, nutrition and increased functionality to product that millions of people around the world use or consume every day.

Environment : ECC 6.0, HPQC, Portals, hyperion, Capex Portal

FI Environment : General Ledger, Fixed Asset, Project systems, CCA, PCA, COPA, Product Costing with Material ledger, Interface with Payroll.

Configured Asset Classes, depreciation keys, transaction types, asset master data, acquisitions, retirement, group assets, and capitalization of asset under construction.

Maintained depreciation areas for Group valuation, foreign currency valuation for group currency.

Maintained Account determination for all the asset classes integrating with general ledger accounts.

Maintained parallel valuation for IFRS compliance with Non Leading ledger for IFRS reposting.

Maintained depreciation area 02 for IFRS in local area currency and Area 33 in parallel currency report.

In depth knowledge of implication of acquisitions, retirements, revaluation of assets and customized depreciation keys for depreciation run - planned, special, unplanned depreciation.

Configured chart of depreciation, depreciation areas, classify assets using asset classes, number ranges, asset class account determination for B/S and depreciation G/L accounts.

Maintained company code for Asset accounting activation, configured country specific COD for the affiliates in various countries from SAP delivered standard template for the country.

Configured Costing and Accounting based profitability Analysis, created Characteristics, derivation rules, derivation Strategy, value fields and valuation strategy for the Operating concern.

Configured Derivation rules for characteristics and used fixed characteristics and had maintained derivation steps to overwrite the fixed characteristics.

Month end year end activities including asset accounting specific process for opening and closing year.

Developed Customized portal link for the business to update CAPEX projects and circulate the projects for approval process with workflow for approval and reminders for the project approvals.

Developed CAPEX portal for creation and updating Capital Projects using legacy data upload into SAP.

Developed customized Asset uplift report to for the statutory compliance of capturing history of the asset from the acquisition to retirement – enable tracing the data from legacy until migration to SAP

Develop customized report for IRS compliance covering IFRS, Book depreciation, ACRS, MACRS ACE, Historical cost for Fixed Asset changes during the year.

Interface for Forex daily updating from Bloomberg and European Central Bank rates into SAP.

Maintained settings for foreign currency translation and Exchange rate gain/loss post automatically for EU countries, Bulgaria, Turkey.

Functional validation of BI reports and logic for extraction of values for reporting management reporting.

Estee Lauder Companies Inc., Melville, NY March 2013 – Sept 2013

SAP IBM FICO LEAD

Leading Manufacturers and marketers of wide range of Skincare, makeup, fragrance and Hair care products with operations around the world including France, Germany, Italy, Belgium, China, Spain, Thailand, Philippines, Malaysia and Singapore.

Environment : ECC6.0, HP Mercury Quality Center, Solution Manager, BMC Remedy, Informatica, BI, Portal, JD Edwards, ASK, Cyborg,worldpay, Windows XP, MS word, Excel, Powerpoint, Visio.

FI Environment: General Ledger / Accounts Receivable / Accounts Payable / Fixed Assets / Project systems/ Investment Measures/CCA and PCA/ COPA/ Product Costing.

Requirement gathering, analyzing design appropriate solutions and carry them through implementation including unit testing, integration testing, and coordinate end user training and testing.

Impact analyze, Identifying and recognizing global integration consequences helping project manager on approvals for inclusion of the requirement in future enhancement and releases.

Configured country specific Chart of depreciation, depreciation areas, account determination, screen layout rules, evaluation group, activating depreciation areas in asset classes.

Acquisition posting with automatic offsetting postings, posting unplanned deprecation.

Developed customized report for Fixed Asset Uplift report to help month end processing ability to track legacy old asset number for audit trial.

Developed complete lifecycle management of the asset involving acquisition, intra-company and inter -company transfers, post-acquisition capitalization, retirement with and without revenue and scrapping.

Capitalize projects for Retail store, free standing stores and counters through the project systems lifecycles from approval of Appropriation request to capital work in progress and settlement on completion to final asset.

Configured new depreciation to comply with IFRS reporting with Parallel valuation.

Lead validation, functional and integration testing with other functional modules involving end to end process flow testing, integration and regression testing for all processes related to Fixed Assets.

Adhere to strict project schedule for project documentation, business blueprints, functional specifications, design documents, configuration documentation and test scripts for manual and automated testing.

Month end and year end closing operations including fiscal year opening, change, closing and reconciliation of account with general ledger.

Intercompany scenario involving EDI interface to create automatic creation of the account payable transaction in the receiving company triggered during the in the delivery process.

Support data uploading, validation with the other teams during the realization phase of the project.

Integration with legacy system - non SAP third party and custom developed applications to integrate with sap in processing data on daily, weekly and monthly basis.

Good understanding of technical developments to coordinate with ABAP technical team for developing reports, BDC, User Exits, BAPI, LSMW, ABAP Query, report painter and Workflow requirements.

Solution Manager Documentation updating throughout lifecycle of the project, version control for repository and responsible for checking in /checking out of documents from Solman for better control.

Requirement gathering for the fixed asset for the affiliates within US.

BNSF Railway, Fort Worth, TX. Aug 2010 to March 2013

SAP A2R Senior lead - Fixed Assets

Leader in Railway Freight Movers and Passenger Carriers in US and Mexico.

Environment : ECC6.0, HP Mercury Quality Center, Solution Manager, FelxCHARM, CEPS, BMC Remedy, Millennium, WebAM, RoadMac, Informatica, BI, Portal, Windows XP, MS word, Excel, Powerpoint, Visio.

FI Environment: General Ledger / Accounts Receivable / Accounts Payable / Fixed Assets / Project systems/ Investment Measures, Cost Center accounting, Profit Center Accounting, FSCM, Treasury

Reviewed and analysis of all existing business process and design in the legacy world for requirements.

Requirement gathering, blueprinting, RICEFW functional specification, customization, project scope definition, documentation of flow charts, interfaces, master data migration from legacy systems.

Integrated designing sessions for Investment Measures and Projects Systems design for phased retirement of continuous Assets in the Railway Industry.

Developed interface to update fixed assets in SAP from Engineering, Mechanical, RoadMac database.

Operating lease database two way interfacing with SAP for payment through automated process.

Lease Accounting - maintained Capital lease database, including capitalizing of capital improvement on capital lease and amortization of the same during the life time of the capital lease as per FASB13.

STB – Surface Transportation Board adhered group life depreciation configuration with reversal provision.

Designed and configured automatic Retirement and replacement of linear capital Assets based on useful life, acquiring APC values through Project settlement.

Designed and Customized Asset base for the Linear Assets Like Rail Track, electric Traction, involving Geographical Location wise tracking for the linear Assets like Railroad, Ballasts, signals, Crossings.

Fixed Asset master data Integration with Geographical Code location system to locate the Linear Assets physically within states where in the railways operate inside United States.

Managed asset accounting heavily integrated with Investment measures and project systems.

Designed constant monitoring, replacement and retirement system to retire the assets on a FIFO basis based on useful life of the Assets within the system - linear assets automatic retirement program.

Acquisition of Capital Assets interfacing with Projects systems and Investment measures.

Configured project profile, Budget profile, interest profile, investment profile for the project.

Planned and Evaluated Asset master data cut over plant with the project team and aligned the activities with Master cut over plan.

Developed Net Present Value Dynamic Report Based on geographical location, Line Segment and Beginning Milepost and Ending Milepost - for estimation, sales and Marketing division.

Maintained Low Value Assets LVA and memo values for assets for specific Asset classes.

Conducted business workshops and blueprinting sessions with BPO’s, Mechanical and Engineering team to formulate business processes around acquisition, maintenance and retirement of specific Assets.

Project systems integrated customized table for mapping activity types for automated Asset creation through Customized CJ88 transaction and retirement based on Geographical Location.

Configured depreciation areas, Depreciation Key, Asset Classes, group assets number ranges, asset class account determination, acquisitions, retirements, revaluation, post capitalized posting

Configured depreciation key for Book depreciation in group currency SEC, STB, ACRS/MACRS, ACE, SMACRS, CA ADR, CA AMT, Book depreciation.

Operating lease database two way interfacing with SAP for payment through automated process.

Maintained Capital lease database, including capitalizing of capital improvement on capital lease and amortization of the same during the life time of the capital lease.

Integration with legacy systems maintained by the Engineering and Mechanical divisions to automatically align additions and retirement to existing Lease Asset database.

SAP IFRS compliance team member for initial analysis of the IFRS implications on company.

Analyzing the issues encountered in the month end settlement of the projects to AUC - asset under construction and Final Fixed Asset settlements by analysis of WBS, Network and activities.

Performance improvement for settlement run, Depreciation run and automated retirement process.

Designed critical path for the month end and year end close process to reduce the FA Close Schedule.

Designed customized transactions for Mass Transfer, Retirement and Mass change of Master data.

Developed custom program for Mass Asset Change, Mass transfer - inter and intra company Assets.

Defined sort versions for the various Statutory Reporting Requirements of the company.

Defined New Asset Class based on the company’s requirement to track Asset for reporting.

Maintained four characters and six characters evaluation groups for Asset Master Data.

Maintained Index Series to adjust inflation adjusted APC cost of the Asset.

Define super asset groups to categories the assets for the mandatory reporting requirements.

Developed interface to update fixed assets in SAP from Engineering, Mechanical, RoadMac, Mainframe DB2, whitebook, Millenniem, CEPS.

Asset Master Data Migration from Legacy system, Field Mapping, data Conversion - Main frames, WebAM, Millennium, Roadmac through Informatica via LSMW to the SAP - AS91.

Charms, Solution Manager record maintenance for different phases of the project lifecycle.

Mercury Quality Center Unit Testing, UAT–User Acceptance Testing, FIT-functional verification testing, SIT - System Integration Testing, Regression Testing – Seasonal Releases.

Enabled Retirement of legacy maintained assets using feed from WinShuttle tool.

BMC remedy for tracking for monitoring and measuring the consistency of the system.

Client: St. Jude Medical, Minnetonka, MN. (Aug 2007 - Jul 2010)

SAP FICO Consultant

Environment: ECC 6.0, FICO, SD, MM, PP, SCM, BI, Seibel, Lawson, MFG Pro, Windchill, Concur.

St Jude Medicals a leading global Cardiovascular device company, selling products in more than 100 countries and has over 20 operations and manufacturing facilities worldwide with major focus on Cardiac Rhythm Management, Atrial fibrillation, Cardiac Surgery Cardiology.

FI Environment: General Ledger / Accounts Receivable / Accounts Payable / Fixed Assets /Cost Center

Accounting, Profit Center Accounting, Profitability Analysis

Business process analysis to understand requirements and translate into solutions in Fixed Assets.

Configured ECC 6.0 with New General ledger with Profit center, Segments, parallel ledger for group financial statement and functional areas.

Accounts payables configured House bank, ranking order, Automatic payment programs including setting up payment methods and value date determination.

Configured Lockbox with Wells Fargo Bank with detailed reporting as required by customer.

Configured Account based profitability Analysis, created Characteristics and value fields for the Operating concern. Assigned values to the Value fields, mapped SD conditions to Value fields.

Tested and Scripted scenarios in compliance with



Contact this candidate