We provide IT Staff Augmentation Services!

Sap Consultant Resume

Dallas, TX

Summary of Experience and Qualifications:

Nitin Arora is a functional/technical Senior Consultant with expertise and in depth knowledge of SAP R/3 FI/CO Modules. He has over 7 years of experience in SAP R/3 implementations (start to finish), upgrades and has worked in various industries like Manufacturing, Semiconductor, Consumer, and Financial institutions. He has implemented Global Projects with ASAP methodology for clients from scope study to Go-Live and Post live support. His skillsets cover wide range of successful roles in system design, analysis, configuration, system testing, data conversion, and production support in FI Accts Payable, FI Accts Receivable, FI Financial Accounting, FI General Ledger/New GL, FI Special Purpose Ledger, FI Fixed Asset, Treasury, CO Controlling, CO Cost Center Accounting, CO Product Costing, CO Profit Center Accounting. He is experienced in different versions of SAP 4.6C, EE 4.7, ECC 5.0, and ECC 6.0 and has advanced technical skills in SAP, Visio, Excel, and PowerPoint

Work Experience:

Confidential, Dallas, TX
Senior Technical/Functional SAP Consultant October 04, 2010 – Present

Role: Senior Consultant responsible for the following:

  • Extensive involvement with the client in gathering business requirements, conducting workshops, designing blueprint documents, writing FRD’s and specifications
  • Involved in pre-planning phases of the project which includes feasibility study, arranging and leading the Finance workshops for gathering requirements and for the blueprinting of documents
  • Understanding the legacy processes and systems to find the GAPs in an effort to come up with an estimation of customized solution and work load
  • Configured organizational structure like setting up of client, creation of company, company codes, G/L master data, ledgers, setting up of various variants as used by the company
  • Configured field status groups, posting periods, document number ranges.
    Grouped G/L accounts into various account groups
  • Created and maintained different COA’s like operational COA, group COA, country specific COA, G/L account master records. Customized account groups, field status groups, posting keys, document types, open & close posting periods
  • Configured new company codes, house banks, depreciation keys, payment transactions and payment runs processing, bank master data
  • Extensively involved in the procure to pay and order to cash processes workshops in an effort to configure the integration of FI with SD and MM
  • Involved in configuration of New GL, creation of leading and non leading ledgers for IFRS and USGAAP reporting. Configuration of currency’s for leading and non leading ledgers
  • Involved in the project’s AS-IS study, TO-BE analysis, gap analysis, business process re-engineering, configuration, & modifications to suit the client\'s requirements, user documentation & user training. Studied & analyzed the existing business processes
  • Developed the LSMW scripts for uploading chart of accounts, customer and material master data
  • Configured segments for profit center and segment accounting
  • Configured validations and substitutions for various checks and rules at the GL Account and cost center levels
  • Involved in creation of controlling area, cost elements, activity planning, cost centers, profit centers. Integration - Assigned G/L accounts for the predefined processes for integration with AM (AA), SD and MM modules
  • Master data extraction from legacy system, formatting as per SAP fields, mapping with SAP, data cleaning and preparing upload files
  • Creation of company-specific master records of GL accounts, Customer Master, Vendor Master, Cost Centers, Activity type and Statistical key figures
  • Customized new chart of account to meet clients’ requirement as per global chart of accounts. Created various financial statement versions to support diverse reporting requirement
  • Involved with Data conversion activities. Build functional specifications for the development of the interface to upload historical data into ECC and resolved issues/errors occurring in the loading process
  • Involved with month, quarter, and year end activities like allocation, carry forward balances etc and resolved the issues associated with the processes
  • MDM: Supported MDM consultants with the set up of master data from FICO perspective based on different sources per region
  • Understanding the existing processes and architecture of SAP FSCM and support end users in their daily activities like receiving payments through lockbox
  • Supported client with their Dispute management issues
  • Fix bugs or enhance the system for existing technologies and processes related to Lockbox, credit management
  • Understand the interface between the legacy system and the flow of invoices to SAP - Read data files (e.g. Lockbox file) to debug errors related to upload files
  • Understand Functional specifications for Dunning and customer refund process and help resolve issues
  • Tracking Incident system and resolving tickets raised by customers and end users to close the issues
  • Understand Biller direct functionality and help the client enhance the implementation and create user manuals
  • Understand SAP customized transactions for cash, checks, ACH and help resolve issues related to them
  • Objective was to make the whole AR Collection system FSCM more efficient and help fixing the existing bugs and support the implemented functionalities
  • Prepare unit testing cases, perform unit testing and confirm with functional teams before it is implemented into production environment
  • Provide day-to-day support for ABAP programs, reports, screens, user exits, etc. in development, test and production environments
  • Providing on-going production support forSAPapplication jobs, programs, reports, and interfaces, including on-call and call-out responsibilities
  • Review functional and technical feasibility for enhancement requests in his/her assigned application and modules. Develop/implement program modules or new functionalities from general specifications.
  • Identify system performance issues that relating to assigned applications and modules. If necessary, coordinate withSAPBasis team to resolve performance issues
  • Work as a partner with functional teams to resolve issues and to test new enhancements
  • Develop guidelines and standards in support of application development practices
  • Identify key programming design issues and recommended possible solutions

Confidential, Richardson, TX
Senior SAP FI/CO Programmer Analyst Jan 2007 – Sep 2010

Job Description: FI/CO Lead analyst involved in implementing various projects, implementations, configurations, enhancements, gathering requirements from client’s business users and solving other issues associated with the FICO module and related sub modules. Job profile also includes designing functional and technical specifications for the programming team to develop customized programs and reports for users.

Key Responsibilities:

  • Involved in all phases of implementation from development of business blue print to end user training and taking the system live. Defined requirements, process reengineering, configuration, integration, testing and user training
  • Demo the business process to business / Stakeholder for signoff
  • Configured FI global settings, enterprise structure, new company codes, AP, house banks, AR, GL, Fixed Assets and Project Systems
  • Automation of Invoices: Designed and successfully completed an automated process to upload invoices. The project demanded to have all legal invoices upload in the system automatically with an interface between SAP and the third party vendor
  • SAP MIC: Worked in tandem with SAP consultant and configured SAP MIC module for the client. The Management of Internal Controls (MIC)component enables the system to move toward compliance with the software requirements laid out in the Sarbanes-Oxley Act of 2002 (SOA)
  • Schedule Manager: Configured Schedule Manager for the client. SM is SAP’s functionality whose extensive automation features facilitate the definition, scheduling, execution, and review of tasks that are executed on a regular basis, such as period-end closing
  • Lockbox: Implemented lockbox functionality at the client. Gathered business requirements and configured the system. Involved with Bank for various discussions for the file formats and other structures
  • SAP BPC: Key team member for supporting the SAP BPC application from FI perspective. SAP Business Planning and Consolidation (BPC) application is the industry\'s leading solution for managing critical financial and operational planning, budgeting, reporting, and analytic requirements. It is fully integrated with Microsoft excel
  • Product costing: Configured the required settings for new plants that used process manufacturing and enabled calculation of standard costs for valuation of standard costs
  • Material Master Data: Involved in maintaining the accounting and costing view of the material master data to maintain standard cost of material for product costing and inventory valuation purposes
  • ACH implementation: Implemented payment method ACH for US companies vendors
  • Involved in testing by creation of Invoices, PO’s, Vendor Master, Customer Master, and Accounts in the test environment to replicate certain production system scenarios and solving problems pertaining to them
  • Configured organizational structure from accounting view - Company Code, COA, defined posting keys, maintained field status variants & assign to company code, screen variants for document entry per business specifications and tested configuration in various scenarios. Integrating different modules - GL, AP, AR, SD and MM
  • Involved in the project’s AS-IS study, TO-BE requirements, gap analysis, business process re-engineering, configuration, & modifications to suit the client\'s requirements, user documentation & user training. Analyzed the existing business processes
  • Mapped the Cost component layout for calculation of direct and indirect costs for product costing purposes & created overhead cost sheet with relevant overhead groups
  • Experience in resolving issues related to Asset accounting and project system settlements, problems and issues associated with profit center hierarchy, cost center hierarchy & their centers
  • Prepared and designed the functional specs for the custom reports in FI and related areas. Used Report Painter and Report Writer in PCA and CCA. Actively involved with programming team to achieve the results
  • Configured Payment Program configuration: Company code data, Paying company code, Country payment methods, wire transfer settings, ACH payments
  • Designed end-to-end business process for Order to Cash, Accounts receivable, Credit management and Payment program
  • Design and configuration requirement for customer groups, customer master, screen layout, payment terms, dunning area, dunning forms, customer statement, customer forms, interest calculation, contra accounting of customer and vendor, Credit control area, user exit for back sales order, Credit risk category, Automatic e-mail functionality for credit block sales order
  • Designed workflow functionality for the 3-Way match in the Invoice verification process
  • Developed the business process for the electronic payment via SAP payment program in Accounts payable. Designed the business process for sending e-mail and Fax of remittance advice
  • Experience in testing the functionality in QA, implementing in production and developing necessary documentation for future maintenance
  • Performed Unit testing, End-to-End testing of the business processes using various scripts
  • Created unit test scripts and test scenarios for GL, AP, AR, CCA, PCA, internal orders, product costing, standard reports, and custom reports ( BI )
  • Experience in mapping of the existing business processes, design of the To Be processes and defining a detailed project scope
  • Defined the required Project Profiles for Project Systems. Created necessary Allocation rules for WBS and AUCs. Executed settlement of AUC to Fixed Assets
  • Co-coordinated month and year end activities
  • Developed the Business Process Procedure (BPP\'s and BPDD’s) for the end user training
  • Analyzed, designed and tested Finance interfaces
  • Developed the various functional specifications for enhancement, forms and reports for the customer. Used SAP ASAP methodology
  • Configured SAP solution using tools such as IMG, OSS Notes, Best Industry Practice, IDOC, BDC sessions, etc
  • Analyzed Data Structures with the help of Abaper, prepared data in excel, defined and mapped values ( fixed, variable ), and uploaded into new system
  • Filled the GAP with regard to transaction code RVND and Electronic Bank statement search criteria, mapping BAI codes based on EBS note to payee fields etc
  • Configured Product cost by period/Order/Sales Order, Work-In-Progress, Variance calculation, Settlement
  • Configuration of master data, business/dunning /payment processes in AR/AP
  • Fixed Asset Accounting - Defined chart of depreciation, various depreciation areas and depreciation keys required, fixed asset classes, number ranges etc
  • Designed a plan for carrying out the capitalization smoothly linking the project systems and fixed assets modules
  • Workflow on FI release for payments and parked documents
  • Configured the revenue account determination procedure using condition types to hit the right revenue and cost account
  • Configured Treasury functions for Cash/Funds management and Investments
  • Responsible for a role to be played in Financial Accounting and Controlling Modules (FI, CO and PP) which were to be integrated with other SAP modules (MM & SD) in various divisions of the company in various sites. Subsequent responsibility for providing Post Go-Live support and Roll-out to other sites
  • Preparing business Blue print as per ASAP methodology, finalizing Business Organization Structure and mapping business processes
  • Worked with developer to define guidelines for Data transfers and conversions using BDC Batch input methods and LSMW
  • Configuration of Enterprise Structure, containing Company Code, Chart of Accounts, controlling area, Business area, Valuation area and Credit Control area
  • Participated in workshops to define requirements and develop to-be processes for general ledger, closing process, foreign exchange, & intercompany transactions
  • Configuring Control modules for Cost Centre Accounting, Product Cost planning and Overhead Costing
  • Designed and configured various purchasing components including Purchase Orders, Invoice Verification, and ERS (Evaluated Receipt Settlement)
  • Tested and implemented SAP Lockbox which is used for automation of AR process of clearing customer payments. Worked with clients lockbox banks to validate the inbound files. Wrote testing scenarios and planned for integration testing, user acceptance test, training, and Go Live execution
  • Managed and configure the revenue account determination for S&D module and configured the account assignments for Goods issued for various material types
  • Configuring costing for Production Order, Sales and Internal Order. Involved in settlement of production costs and assessment of variances
  • Preparation of User Manuals for Financial Accounting and Production Planning
  • Configuring Automatic Payment Program in Accounts Payable
  • Designed and configured Vendor Master Data: Vendor Group, Vendor Field Status, and Creating Vendor & Customer Master Data & Risk Categories. Configured the integration of logistics modules such as MM & SD Configured house banks, Bank accounts, GL structure, posting rules for automatic assignment
  • Configured CO-PA. Defined market segments by selecting appropriate value fields and characteristics to fulfill market profitability analysis of clients business
  • Created summarization levels in COPA to minimize report execution time. Identified requirements that necessitated use of Profit centers to fulfill internal financial reporting
  • Defined profit center hierarchy, cost center hierarchy & maintained assignment monitor
  • Defined substitution rules at sales order level to derive right profit center based on agency, location and division
  • Master data extraction from legacy system, formatting as per SAP fields, mapping with SAP, data cleaning and preparing upload files
  • Created user defined reports using Report Painter & Report Writer in PCA and CCA. Created user defined planning layouts & planner profiles in PCA and CCA
  • Defined credit control area for credit management in the application components AR and SD
  • Defined credit limit checks for SD processing, Risk management for receivables, assign Company Code to Credit Control Area
  • Payment processing in AR and Automatic Account Determination. Designed Lock Box procedure for Accounts Receivables payments in BAI2. Developed AR aging report, created Invoice Layout and processed invoices. Configured Evaluated Receipt Settlement in AP and automatic generation of Credit/Debit Notes for Return Goods
  • Analyze material management process to design the business process flow chart for Purchasing
  • Interfacing with external systems through ALE, Custom IDOCs, Workflow, BAPIs, RFCs, BDC & flat files
  • Resolved issues related to asset accounting and project system settlements
  • Payment Program configuration: Company code data, Paying company code, Country payment methods, wire transfer settings, ACH payments, Dunning Notices
  • Designed, configured & implemented accounts payable check printing, payment blocking reasons & defining check lots, Use tax reporting, & related month end financial reports
  • Configured reconciliation accounts for various sub-ledgers and configured Vendors and Customers clearing procedures
  • Prepared functional specs for the custom reports in FI module

Confidential, Gurgaon, India
SAP Business Technology Analyst June 2003 - July 2004

Job Description: SAP Analyst involved in working with senior FICO Consultants and to assist them in various work activities related to SAP implementations, documentation, designing test scripts. Involved in working with technical teams to develop functional specifications for customized interfaces

Key Responsibilities:

  • Assisted senior consultants in setting up workshops to impart hands-on, step-by-step training to prep users with the skills needed to best operate and optimize R/3 in their jobs
  • Assisted in data conversion including importing various master data from Legacy systems to SAP using LSMW and CATT in collaboration with the technical team
  • Conducted Unit testing, Integration testing, Regression testing and User Acceptance Testing (UAT), tracked results and reported issues
  • Created Validation and Substitution rules to determine appropriate Business Areas and Functional Areas
  • Interacted with the end users, business process owners and other functional consultants for the finalization of functional specifications to meet the growing needs of the client
  • Participated in and coordinated the data cleansing and data migration activities from legacy systems to SAP in cooperation with the technical consultants and other functional team members
  • Assisted senior consultants in providing training and support to business users
  • Got trained in FICO while assisting and supporting senior consultants with their day to day activities and SAP end to end implementations
  • Worked with the technical team to create user exits to increase SAP user friendliness, and developed reports for internal and external reporting using Report Painter and Drill-down reporting
  • Prepared documentation for end users for GL, AP, AR and AA. Trained them to use the SAP R/3 system to do their job on a day-to-day basis
  • Worked with the senior SAP consultants to map the business operations to SAP and prepared Business Blueprints

  • Confidential, Houston, TX
    Graduate Student Assistant Aug 2004 – May 2006

    Responsibilities and duties involved:

  • Assisting web administration work
  • Writing queries based on students technical information and generating crystal reports
  • Worked on development of Scanning and Imaging Application (PEOPLESOFT)
  • Maintained database for keeping the records of Students
  • Analyzed, designed and tested Finance interfaces
  • Experience in mapping of the existing business processes, design of the To be processes and defining a detailed project scope for the development of the Imaging application
  • Education:
    Master of Science in Information Systems

    Technical Skills:

    Programming Languages: ABAP, C, C++
    Databases: Oracle, SQL Server, SQL, PL/SQL
    Operating Systems: UNIX, Windows NT/2000/XP/9x, MS-DOS
    Project Management : MS Project, Visio, ASAP (SAP)
    Tools/Packages: SAP, PeopleSoft, Crystal Reports/Query Analyzer
    Others:MS Word, MS Excel, MS PowerPoint

    Hire Now