SAP FICO Treasury Consultant

OBJECTIVE

Seeking a challenging position as a Senior SAP FICO Treasury Consultant, where my knowledge of Financial and Controlling module in SAP R/3 along with my professional experience, allows me to make an immediate contribution with the continued personal and professional growth

BACKGROUND SUMMARY

About 14 years of experience in projects Consultants on different areas. completed four implementations and support experience working as a consultant.

Extensive Functional experience in Configuration and Customization in FI-GL, OTC, S2S, Banking, Asset Accounting, Controlling, Credit Management and Cash Management.

Analyze, design solutions for issues related to Accounts Receivables (AR), Accounts Payable (AP), Tax procedures, Revenue recognition and Intercompany accounting, Multi Currency.

Experience in Integrating FI with CO, SD, MM and PP modules (Procurement, sales, billing, and inventory). Provided and worked on solution like GL interfaces for expense or revenue systems as well as Swiftnet and FX system.

Experience working on projects and modules planning, executing, monitoring, testing and effectively tracking project progress, deliverable and issues and providing adequate updates to project senior management. Experience with working with offshore resources.

Extensive working experience across various industries like Pharmaceutical, Retail, Manufacturing, Banking, Utility, IT Service and Hospitality Industries.

Very good experience on analyzing GAPS and providing solution. Have worked with Users and with external parties like Bank, Blackline, Ariba, FX rates Vendor, Treasury platform to setup interfaces and accounts.

Very good knowledge of SAP S/4 Hana and very good understanding of migration.

Ability to communicate clearly with senior and high level management and executives, including ability to re-state key points of meetings to ensure that communications were correctly understood by all parties. Worked with solution manager, knowledge of Gap Analysis.

Performed Business requirement collection, project analysis, process design, blue print, GAP analysis, production support and train IT and end key user staff.

Possess Strong communication, Analytical, Project Planning, Problem Solving Techniques combined with a variety of Functional skills.

Excellent Accounting and Finance knowledge with demonstrated Competencies in Financial and Business Analysis developed while working with different Clients.

Strong experience in preparing Business Requirements Document and Functional Specifications.

Multi-Tasking and Organizational Aptitudes, with proven experience in Development and Implementation of Strategies.

TECHNICAL EXPERTISE

ERP Application

SAP ECC 4.7, ECC5.0,ECC.6.0, REVAL, SunGard, Blackline, Concur

Methodologies

Solution Manager, ASAP

Applications

MS Office (Word, Excel, PowerPoint, InfoPath, OneNote, Publisher, Outlook, Visio) MS Project, Intuit QuickBooks, SharePoint, Blackline, SunGard, REVAL etc.

Databases

MS SQL Server

SAP

SAP FICO, MM, SD, FM, Treasury

Operating System

Windows NT/98/2000/2003, Windows XP, UNIX.

Trainings

Business Accounting, Property Management System PC Networking Technician, SAP FICO, HP Quality Center, Treasury

WORK EXPERIENCE

Client: BWX Technologies Inc. Jan 2017 – Current

Role: SAP FICO Consultant & Blackline Project Manager

Project Description: BWX Technologies Inc. (BWXT) is a leading supplier of nuclear components and fuel to the U.S. government; provides technical, management and site services to support governments in the operation of complex facilities and environmental remediation activities. Project was to review current SAP FI-CO process and provide support and recommendation to simplify month end processes.

Understand the current landscape of client and corporate accounting structure and propose the best solutions to enhance the account processes including month end GL account reconciliation with third party tool.

Analysis, Design, configure and manage Financial functional requirement, co-ordinate update Business as well as SAP project management.

Performed and lead call with vendors in evaluating third party GL reconciliation and task management tools (like Blackline, Trintech and Autorek) and setting up demo with corporate accounting team including controller and GL administrator.

Understand third party tools capabilities in communicating with SAP system and provide information to vendor and recommendation to business after comparing all product.

Prepare project time line and scope and lead end to end implementation for Blackline tools and support user after go live for day to day issue. Also, communicate with IT technical team for security requirement and any interface capabilities.

Prepare and review functional specs as well as technical specs for the requirement and review with Business as well as IT team for any technical requirement.

Participated in business and project meetings and advised to Corporate and Project to minimize suspense GL entries by providing proper GL mapping.

Responsible for delivery of the development objects in GL Banking and Treasury. Coordinating with the SOX compliance team for the security issue.

Configured and provided best practice solution for EBS setup for reconciliation, cash positioning and liquidity forecasting.

Review and provide recommendation on SAP Treasury, AP and AR Payments: Payment Processing (Inbound/Outbound) – ACH, Domestic Wire and Cross-Border Wires. Free-Form, Repetitive, Vendor, Customer, Investments and Debts payments and Lockbox files.

Responsible for Chart of Account list, cut over task, integration and UAT testing. Have performed as a Super User and prepared users for GO live and supported them into day to day issue as well as month end, quarter end and year end closing issue until project hand over to R&M team.

Help accounting team in reconciling all require Balance sheet GL during UAT testing which include AP, AR, Cash GL, Accrued GL, Prepaid GL and payroll GL.

Work in between business and IT team to full fill both side requirement.

Client: Wells Fargo Aug 2016 – Dec 2016

Role: SAP FICO Treasury Consultant

Project Description: Wells Fargo is a national bank scope of project is work with Bank Client and help in setting up DMEE file structure as well as review reporting functionality to client.

Lead and analyses current XML template and review against current version of ERP system for its accuracy.

Review Bank BAI2, MT940 bank template and provide recommendation.

Understand SAP client issue and provide guidance in building XML or ISO 20022 as per Banks requirement

Work with client on AP and AR Payments: Payment Processing (Inbound/Outbound) – ACH, Domestic Wire and Cross-Border Wires. Free-Form, Repetitive, Vendor, Customer, Investments and Debts payments and Lockbox files.

Help Bank in building BAI2 or MT940 files for SAP customer and communicate with SAP client to resolve issue related to reporting.

Lead and provide recommendation on third-party middleware bank want to use to communicate to ERP system.

Design Customer/Vendor verification xml format and provide feedback on interfaces between and bank and ERP.

Goal of project is to receive most available and accurate data from ERP system to process without error and provide status messages back to clients.

Review current payment status messages template and provide recommendation.

Understanding business needs and leading thoughtful design discussions around meeting those business needs in a standard manner fully leveraging SAP product capabilities

Developing and maintaining architectural and design direction and leading teams to develop creative business solutions within it.

Working with Customer Solutions analysts and business personnel to understand Finance business processes (particularly Treasury processes) and provide the technology to support these processes

Based on requirements submitted by the business, develop detailed functional and technical specifications for changes to the

Consulting with other custom code developers and provide technical specs for interfaced solutions

Performing unit / integration testing of changes (configuration, custom development, etc.) in development and staging environments, including regression testing of functionality that may be impacted by change/

Providing support for other activities that impact the system, such as configuration changes to support changing business.

Worked on Customer statements, Vendor Invoices and invoices management including dunning.

Client: CSC Falls Church VA Dec 2013 – July 2016

Role: SAP FICO Treasury Consultant

Project Description: CSC is a global leader of next generation information Technology Company. The Finance transformation project is creating one global, seamlessly integrated platform of standardized business.

Understand the day to day issues on corporate accounting, order to cash and procure to pay side and propose the best solutions to enhance the account processes.

Analysis, Design, configure and manage Financial functional requirement, co-ordinate and update Business as well as SAP project management

Performed and lead Configuration and Customization in FI-GL, AR, AP, Bank Accounting, Treasury, Intercompany FX rates and Swiftnet.

Provide Support, maintenance and enhancement of the FI/CO functionality in Cost Controlling, Collection and Dispute management, CC Accounting and PC Accounting.

Participated in business and project meetings and advised to Corporate and Project on GL interface with Treasury and Payroll, Swiftnet, Exchange rates and FX all interfaces.

Worked on Foreign currency valuation, Financial reports Substitution, Validation and parallel ledger setup.

Responsible for delivery of the development objects in GL Banking and Treasury. Coordinating with the SOX compliance team for the security issue.

Responsible for preparing test plan and load into HPQC and assign onshore and offshore team and track their progress and help them as needed.

SAP Treasury, AP and AR Payments: Payment Processing (Inbound/Outbound) – ACH, Domestic Wire and Cross-Border Wires. Free-Form, Repetitive, Vendor, Customer, Investments and Debts payments and Lockbox files.

Electronic Bank Statements - Prior day and Current Day EBS statements from multiple domestic and international banks (BOA, JPM, CITI, Wells Fargo, HSBC, Scotia, RBS, Lloyd, Barclay, HSBC, Standard Charter, Dutch Bank) in BAI2 and MT940 formats through SWIFT network. Have designed and configured Cash Position Report and liquidity forecasting Report for domestic and international bank accounts and legal entities.

Responsible for Data Migration, Cut over task, integration and UAT testing. Have performed as a Super User and prepared users for GO live and supported them into day to day issue as well as month end closing issue until project hand over to R&M team.

Have worked with Treasury on REVAL implementation and REVAL to SAP interfaces. Also, worked on FXALL software for trading.

Lead implementation of Treasury and Swiftnet integration end to end for North America, Asia and Europe.

Environment: ECC 6.0

Client: 3M, St Paul MN Nov 2012 – Aug 2013

Role: SAP FICO Consultant

Project Description: 3M is a global innovation company. The Sap transformation project is creating one global, seamlessly integrated platform of standardized business. Retiring people soft and oracle and bring it under one platform

Worked in all phases of the project from development to the end user training

Design and analyzed detailed Functional and Rational Specifications for FI and CO process from Implementation point of view.

Worked on troubleshooting and debugging on production defects during hyper care.

Involved in primary enhancement/configuration work on FI with core focus on AR/AP/NEW GL, CO and Cash Management.

Worked with OTC team closely to configure Lockbox processes

Defined Tolerances for Customers and Vendors, Payment Terms, Account for Cash Discounts and Payment Differences.

Design, configured and tested the Product Costing functionality also worked with bringing intraday statements for cash positioning. Worked with BCM and Swiftnet functionality

Processes implemented were Cash and liquidity management, treasury and A/P payments (XML) using In-House Cash, bank reconciliation, Inter-company processes including pooling, Lockbox etc.

Developed WRICEF Functional documents by conducting meeting with different team and Business users to create enhancement for inbound and outbound processes.

Involved in meetings with AR and AP team to understand their requirements Lockbox and XML files

Worked closely with interface and ABAP team to explain Enhancements

Designed & configured automatic payment program as per client requirement.

Worked on HPQC for Functional and User acceptance testing with offshore team.

Worked with third party vendors and like Bank, Swiftnet, Middleware for interfacing also schedule and monitor batch job with third party software.

Environment: ECC 6.0

Client: Cendant Corporation, Parsippany, NJ November 2009 – March-2012

Role: Sr. SAP FICO Associate Consultant

Project Description: Cendant is a luxury hotel and resort chain system in the United States and worldwide. Cendant started to implement SAP that supports the Financial and Operational processes for the recording of all Customer transactions for revenue, tax and accounts receivable and for managing the consolidated financial results of the Customers. I was involved as a part of Implementation team for AP, AR, GL and CO module in all phases.

Responsibilities:

Worked in all phases of the project from blue print development to the end user training on ECC 6.0

Worked in configured and customized GL account including master records, creation of Company codes, Chart of accounts, Account Groups, Field status groups, Fiscal year variants, Posting periods, Document number ranges.

Worked with ABAPER Importing Historical data from legacy system by using LSMW

Configured A/R & A/P accounts including Vendor/customer master records, Account groups, Tax Calculation, Tolerance groups, Credit limit for customers, Country/company code specific payment methods, Manual incoming/outgoing payments, Credit memos, Partial payments, Installment payments, Residual payments, Claims and Disputed payments, Discounts, Vat tax configurations.

Performed material costing with cost estimate using quantity structure. Analyzed BOM and materials type. Inventory valuation.

Customized fast entry screens layouts for G/L account items, park documents, individual or mass reversal of documents, and valuate foreign currency.

Configured Controlling Area, assigned number ranges to controlling area, and maintained versions. Worked on Cost center accounting (CCA) & Profit center accounting (PCA), maintained the master data, standard hierarchy, substitutions, and assignments. Configured Profit Center Accounting planning included defining versions, planning layout, planning profile

Configured and maintain AR Dunning process, Interest Calculation on Account Balances and line items.

Trained Business Process Owners and End Users

Environment: ECC 6.0

Client: Philips Morris Richmond VA May 2007 – Oct 2009

Role: SAP FICO Functional Consultant

Philips Morris is largest cigarette and tobacco producer. The Company is in to cigarettes business. I was a member of strategic Financial Solution group in implementing the SAP financial solution and worked in areas of finance and Controlling Participated in a full life cycle of SAP Project Implementation from Business Blueprint Realization, Final Preparation, Go Live and Support

Responsibilities:

Gathering Business requirement for existing business processes

GL Accounting Creation of GL master, Cash Journals, Sample documents, parked documents month end provisions.

Account payable creation of vendor account groups, configuration for automatic payment posting, Defining alternative reconciliation account for special GL transaction like Down payments and Automatic payment program. Configured interface with third party software Vertex for Tax Calculations

Account Receivable creation of customer master, customer account groups, interest calculation configuration, Dunning program for customer account and Defining terms of payments.

Bank accounting configuration of House Bank, checks management, and bank statements.

Configuration of CO module – Organizational structure settings, maintenance of cost center, Standard hierarchy, Creation of cost centers, Cost elements, stastical key figures, internal orders, profit center accounting, profitability analysis.

Product Costing (make- to- order and make- to-stock) configuration, –ML Configuration, Planning, Cost object controlling, custom setting in OBYC and Material Ledger.

Involved in integration issues in SAP from SD and MM modules to the FI module.

Final integration test and validation, End user training, Quality checks.

Provided post implementation support to the operational team.

Configuration of Tax on sales and purchases, Withholding tax Procedures, Cross Company code Configuration.

Setting up of own payment methods, payment files and advices through change in SAP scripts

Configuration and creation of house banks, bank accounts and assignment of these accounts to a check lot.

Configured automatic payment program for out-going payments in A/P.

Configured payment terms, over-due interest calculations, cash discounts and automatic clearing of line items.

Imported and processed Electronic bank statements (EBS) worked with BAI2 file formats.

Environment: ECC 5.0

Client: Eli Lilly and Company, Indianapolis, IN January 2005 – April 2007

Role: SAP FI/CO Consultant

Eli Lily is the 10th largest pharmaceutical company in the world Lilly was one of the first companies to initiate a bona fide pharmaceutical research program about 3800 employee and plant located in 13 countries and product marketed into 123 countries. I was hired for onsite support for fully integrated sap in manufacturing environment

Responsibilities:

Used to look after the payables and receivables operations

Maintenance of GL, AP and AR master data in FI side. In CO, maintained Cost Centers, Cost Elements, Profit Center and Internal Orders

Setting up of Background jobs

Configuration changes in the system for different requirements for best practice

Monitoring/Re-processing of Idocs and Batch jobs

Provided support to the daily activities supported by SAP

Month end closing activities

Ticket resolution and answering how-to questions

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

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, re-create tables or indices, etc.

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

Environment: ECC 5.0

Client: HD Supply Facility Maintenance Tampa FL December 2002 – December 2004

Role: Account Receivable Associate

HD Supply is largest providers of maintenance, repair, and operations products in hospitality and health care services. The Company is in to manufacturing and reselling.

Responsibilities:

Maintain up-to-date billing system

Follow up, collection and allocation of payments

Carry out billing, collection and reporting activities according to specific deadlines

Reconciliation of accounts

Monitoring customer account details for non-payments, delayed payments and other irregularities

Maintain accounts receivable customer files

Follow established procedures for processing receipts, cash etc.

Prepare bank deposits

Investigate and resolve customer queries

Process adjustments

Organizing a recovery system and initiate collection efforts

Communicating with customers via phone, email, mail or personally

EDUCATION

Bachelor of Commerce – Major Accounting

Gujarat University, Ahmadabad, India

Diploma in Computer Science

N L Collage, Mumbai, India

Contact this candidate