Sr. Sap Is-retail Fico Consultant Resume
3.00/5 (Submit Your Rating)
Edison, NJ
SUMMARY
- Sr. SAP FICO Functional Analyst with 11+ years of experience in various industries such as Manufacturing, Retail, Chemicals, Construction, and Oil and Gas with hands - on experience in configuration, 4 full life cycle implementations, customizing, testing and integration.
- Experienced in gathering and evaluating business requirements, identifying process gaps between AS-IS and TO-BE processes, re-engineering business processes, creating business blueprints, mapping processes to SAP R/3, functionality and collecting master data.
- Worked on SAP S/4HANA.
- Extensive expertise in Design, Development, Configuration, Customization, Testing, Troubleshooting, Documentation and Reporting, User Training in FI/CO
- Experience with all major areas of FI including General Ledger, Taxations, Asset Management, Bank Accounting, Accounts Payable & Accounts Receivable and major areas of CO including Internal Order, Cost Center Accounting, and Profit Center Accounting.
- Experienced in SAP Record to Report (RTR) process.
- Worked on Automatic Payment Program and Dunning procedure for Vendors/Customers.
- Worked on Lockbox, Electronic Bank Statement (EBS), Credit Management, Dunning, APP.
- Involved in production support for GL, AP, and AR modules.
- Extensively worked on FI-MM integration, FI-SD integration and OTC process, P2P process, other modules like HR, Plant Maintenance, SRM and PS.
- Trained end users about the new system functionality and explained the integration between the various modules SD, MM, FI & CO.
- Worked on fixed assets.
- Worked on configuring Input/output Tax and Withholding Tax and have knowledge on external tax systems ‘VERTEX’, SABRIX
- Worked on month-end closing procedures, provided support for month end and year-end financial activities, and ECC Ehp3, EhP 6, EhP 7, EhP 8 upgrades.
- Proactively Participated in Mergers and Acquisition implementations, ERP Consolidations.
- Worked on Product Costing, BOM, routing and integration with PP.
- Worked on CO-PA (Profitability Analysis) reporting, forms, planning, derivation rules and structures, product and customer hierarchy, PA settlement, realignments, and integration issues with Sales & Distribution. Solid experience in managing, coordinating and sequencing Transports. Promoting custom packages and code to QA and PROD systems.
- Excellent communication skills, team participation, inter-team co-ordination, and team leadership abilities and working closely with Off Shore teams..
- Deep working knowledge of Upstream and Downstream Oil Business.
- SAP Security experience including designing roles, Authorization Objects, GRC access control tools - Firefighter, Compliance Calibrator and Access Enforcer for Sarbanes-Oxley section (SOX) compliance.
- Industry specific experience in IS-Utilities, CCS, IS-Oil & Gas, IS-Retail. Understand the Business process for industry standards.
- Effectively train, motivate and mentor managers, engineers, developers and technicians.
- Effectively managed large teams to deliver measurable results and growth.
- Experience with SAP BI/BO, BPC, BODS (3.2 & 4.0), BackOffice Associates, Salesforce.com.
TECHNICAL SKILLS
ERP: SAP R/3.4, ECC 5.0, ECC 6.0.
Programming Skills: C, C++, Visual Basic and ABAP, Sy-Base and eclipse.
Operating System: Windows, Unix/Linux, Mac.
PROFESSIONAL EXPERIENCE
Confidential, Edison, NJ
Sr. Sap IS-Retail FICO Consultant
Responsibilities:
- Worked on extending costing and accounting views and populating standard price and moving average price for the materials using LSMW related to IS-Retail.
- Worked on setting up new Canadian stores sales postings.
- Worked on inter-company, intracompany STOs, pro-forma invoice creation.
- Worked on Setting up new Gift card process with external vendors and post these transactions into Sap via middle ware.
- Worked on setting up .com domain and posting these into Sap.
- Worked on creating new reconciliation process for gift cards related to MID’s.
- Worked on inter-company, intracompany STOs, pro-forma invoice creation related to IS-Retail.
- Worked on INTRASTAT tax reports for Billing and Purchases, adjusted pricing procedure with statistical condition type to populate invoice value in case of INTRA-COMPANY cross border invoices related to IS-Retail.
- Worked on configuration of EDI transaction setup for intercompany STOs and maintained OBCA, OBCD, OBCE.
- Worked on enhancement of tax code determination-based destination country of goods rather instead of company code country.
- Maintained SD and MM pricing procedures using VK11 and MEK1 and tax classification using MWST related to IS-Retail.
- Worked on FTP to SFTP setup for integration between SAP and Concur with IBM Sterling as middleware for Travel & Expenses.
- Testing procure to pay process related to IS-Retail.
- Successful Implementation of FI (GL, AR, AP) and CO settings on the development server and ultimate transportation on to the testing and production servers related to IS-Retail.
- Configured ERP structure and Financial Accounting global settings: key settings being company code, Business area, fiscal year variants, field status variant, open and close posting periods, document types and document number ranges and validations.
- Credit management settings: key being credit control area and risk categories.
- Implementation and maintenance of FI-AR, FI-AP master data of customers and vendors with open item processing related to IS-Retail.
- Configuration of interest calculation related to IS-Retail.
- Configuration of Bank accounting, Asset accounting, Cost and Profit center accounting.
- Prepared, documented and maintained all documentation and processes for end users.
- Conversion of year dependent periods to normal calendar month periods related to IS-Retail.
- Preparation of LSMW data upload templates, testing and performing data upload. GL balances both cumulative and line item balances including vendor, customer and asset master data were loaded via LSMW technique. Designed and implemented bank payment interfaces with US, CA and EU Banks via SAP FSN (Financial Services Network).
- Worked on House Banks, Bank Key uploads via FIORI, Bank Accounts upload via FIORI tool on Test Systems related to IS-Retail
- Worked on S/4 HANA 1809 related to IS-Retail.
- Worked on Positive Pay file with Confidential .
- Worked on configuration of Bank Communication Management, Approval Workflows and Basic Treasury functionality related to IS-Retail.
- Designed and configured EBS and utilized search string functionality to determine different posting rules.
- Worked on development of custom apps for AP related to IS-Retail.
- Lead on-site and off-shore team.
Confidential, Cleveland, OH
Sr. Sap FICO Consultant
Responsibilities:
- Worked on SAP Asset Accounting configuration for US.
- Configured Chart of Depreciation, Depreciation Areas, Depreciation Keys, Depreciation Methods, Asset Classes, Layouts, Depreciation Keys and other settings.
- Fixed Assets customizing with respect to US Federal Tax depreciation (MACRS, AMT & ACE). Maintained baseline configuration in Sandbox and conducted prototyping to confirm organization elements and development requirements.
- Worked on data migration from 3rd party system to SAP and created LSMWs for Asset Master Data, Old Assets Depreciation Data and Current Year Asset Depreciation Data.
- Worked on general ledger setup for US company code, worked on migration of G/L balance, AP, AR open items from third party EVO system to SAP system.
- Worked on inter-company, intracompany and plant abroad STO scenarios.
- Worked on EU taxation and implemented several notes for plant abroad intracompany STOs INTRASTAT reports.
- Designed, customized and developed solution for sales and use taxes for US using TAXUSJ (SAP internal tax calculation based on jurisdiction codes) at state, county, city and district level.
- Designed, customized and developed solution for sales and purchase taxes (HST, GST, PST and QST) configuration for Canada using TAXCAJ (SAP internal tax calculation based on jurisdiction codes.
- Developed US 1099 / US 1042S form for withholding taxes in US for non-employee expenses and others and applied relevant notes.
- Configured jurisdiction code structure, jurisdiction codes, condition types, access sequences, account keys, tax codes (FTXP), and automatic account determination.
- Worked on SAP Banking Configuration.
- Designed, customized and developed payment interface using SAP PI and created DMEE payment file structures (PMW) for CITI and Scotia Banks.
- Worked on SAP Asset Accounting configuration for US including localization US GAAP, IFRS.
- Provided guidance for use of Debug access, Fire fighter User Id’s to developers and Functional support consultants.
- Participated in daily team calls for individual teams doing Gap-Analysis and requirement gathering.
- Provided weekly targets and deadlines to the teams involved. And monitored the progress in daily status calls and weekly project level status updates.
- Managed all stages of data migration - business data analysis, data extraction, data loading, user acceptance testing, user sign-off, Cut-Over plans, migrating to Dev/QA/ Prod landscapes, post go-live validations and Final business signoff, Go No-go decision.
Confidential, Cleveland, OH
Sr. Sap FICO Consultant
Responsibilities:
- Worked on SAP RTR area includes AA, AP, AR and GL.
- Worked on functional specification on development of mid-year asset upload program using BAPI FIXEDASSET OVRTAKE CREATE for newly acquired plant NOLA, LA.
- Worked on Fixed assets - implemented asset revaluation process to revalue the asset value to current market conditions.
- Worked on settlement profile for AUC assets.
- Created custom transaction types for asset depreciation for JV assets.
- Worked on setting up asset related batch jobs for month-end and year end processes.
- Worked on design and development of custom DMEE tree for Confidential for buyer initiated payments to pay the business cards for Accounts Payables in txt format and configuration of OBPM.
- Worked on DMEE file configuration and custom payment program development for Canadian bank TDB (Toronto Dominion Bank) for ACH payments using custom format and have developed multiple function modules to populate the DMEE XML file with all the required information for Accounts Payable.
- Worked on redesigning of EDI 820 interface for Remittance Advice and Implemented Lockbox BAI2 file process for Account Receivables.
- Worked on Positive Pay file interface with Confidential bank for Checks issued to vendors.
- Worked on VAT for Europe taxes, integration with VERTEX for US region for sales and use tax.
- Worked on SAP FI-SD integration related production issues.
- Set up Planning Framework with relevant Planning levels, packages, methods and parameter set to set up the Sales Plan on SAP system.
- Defined variables and forms for the creation of Profitability Reports and reported them to the Finance Department of the company.
- Handled Allocation Cycles in COPA, assessment cycle for transfer of overheads, flow of actual values and to assess cost center costs/process costs.
- Conducted workshops for user training on processes, developed user documents, rendered active support for testing and troubleshooting the issues encountered by users.
Confidential
Sap FICO Consultant
Responsibilities:
- Support towards Month End Closing (MEC) and address issues related to depreciation, accruals, FI-CO reconciliation, balance sheet adjustment postings and foreign currency valuation to mention few.
- Accounts Payable - GR/IR clearing, automatic clearing, invoice verification (MIRO) and physical inventory.
- Participated in SAP EHP8 Support Pack Upgrade; liaison with Basis/ABAP teams to implement various OSS notes related to receivables, payables, and banking processes. Conduct unit, integration testing in development, quality systems, and validation of various processes in production.
- Accounts Payables - implemented recommended process changes towards Indonesia Banking Regulatory.
- Implemented New GL, activated new Ledger, performed document splitting, Parallel Accounting and periodic processing and extensively exposed to integration issues of FI with MM and SD.
- Worked on customization of document splitting functionality, account classification, document types for document splitting, zero balance account in New GL.
- Worked on segment reporting customization, auto determination of segment via profit center as part of new GL activation.
- Worked with SAP Services for New GL activation and data migration.
- WRICEF developments - Cash Forecast Report for Payables department and an enhancement to check for open commitments for a WBS element during closure.
- Strong cross functional skills - integration of order to cash, procure to pay processes with financial accounting.
- Define accounting codes, mapping with FI company codes and valuation areas for the transaction figures of various treasury instruments to flow into FI for valuation and reporting.
- Worked on intercompany billing, clearing.
- Worked with SolMan and ChaRm process.
- Configured characteristic derivations for AR deductions
- Worked on production revenue accounting, defined business partners and revenues according to the client requirements.
Confidential, Irvine, CA
Sap FICO Consultant
Responsibilities:
- Co-ordination of problem tickets with offshore resources (functional as well as technical) to ensure that the tickets are resolved within the stipulated SLAs.
- Responsible for supporting Record to Report (RTR), and SAP FI-SD, FI-MM modules on daily basis.
- Payment Medium Workbench (PMW) - created new DMEE structure for Citibank payment, HSBC Net (in xml format).
- Mexico accounting project to meet the Mexico legal requirements to accommodate UUID’s and RFD numbers on SAP invoices from vendor XML invoices.
- Colombia GAAP and IFRS statutory Project - allocation of additional costs such as freight, duties, VAT taxes, Insurance to inventory account and Asset Value to meet the Colombian legal requirements.
- Worked on regulatory tax changes for European countries like Slovakia, Italy, and CZ.
- Period End and Year End Closing activities - bad debt, revenue accrual, settlement, depreciation, recalculation of depreciation, period postings etc.
- Enhancements and support towards FSCM, Vendor Invoice Management and BRAINWARE OCR application Involved in the user acceptance test, provided training to the end users.
- Created training documentation and manual to the end users.
- Configured lock box according to the business requirements
- Defined order type to create sales orders, assigned each order type to a number range and
- Users.
- Calculated activity types using standard cost to ensure the proper flow of costs.
- Used material ledger for ascertaining real costs for materials and optimizing material inventory.
- Configured new GL functionality for assigning segments for Profit centers activated the non-leading ledger for new company code with different fiscal year variant and updated the cost center.
Confidential
Sap FICO Consultant
Responsibilities:
- Application Management: Liaison with Supply Chain, Sales & Distribution, and HR team to address day to day support issues, change request and major enhancements.
- Redesigned Accounts Payable Interface for PAYMODE ( Confidential ) that helps to monitor IDoc failures of this interface and automatically reprocess failed IDocs.
- Payment Medium Program RFFOED1 to general PAYEXT/PEXR2002 message types.
- Configured and customized Chart of accounts, Company code Global Parameters, Fiscal year Variants, Posting Period Variants, Account Groups, Field Status Groups, and Tolerance Groups.
- End to end system configuration towards Electronic Bank Statement (EBS) and Lockbox to process MT940, BAI2 files.
- Implemented an automated vendor reconciliation process and implemented multiple OSS notes.
- Audit Report - developed an ALV report for submission to Confidential & Confidential and Confidential to assist them with quarter and year end audits.
- Dunning Report - to notify employees (based on Republic of Congo) of the advances taken but not paid within stipulated due date. Workflow triggers auto email notifications to employees.
- Vendor Clearing - a custom development to validate partner bank type (BnT) during vendor clearing posting.
- Worked with SolMan and ChaRm process.
- Worked on open text invoices for data invoicing and reporting.
- Worked on open text routing invoices and preparing reports on the unpaid invoices
- Worked Extensively on BOM and Routing rework, cost estimate updates and costing run.
- Configured Costing run for various finished materials across various plants.