Sap Fico Consultant Resume
0/5 (Submit Your Rating)
Burbank, CA
SUMMARY
- Experienced senior SAP FICO consultant having 10+ years of hands on experience in SAP Financial Accounting and controlling module.
- Certified consultant in Financial accounting module with ECC6.0
- 7+ years of experience in business accounting and auditing.
- SAP experience includes implementation projects in different roles from Business Analyst, Sr Business Analyst, and experience of 3 full life cycles SAP FI/CO implementations, 3 roll outs, 2 upgrades and production support & 1 global implementation.
- Rich experience in implementation and project management skills covering business requirements gathering, business process analysis, GAP analysis, and proof of concepts design, configuration, unit testing, integration testing, documentation, data conversion/ Migration of master and transaction data in mass volumes, end user support and training.
- Experience in implementing SAP for Manufacturing, High - Tech industries.
- Designed and implemented CO-PC implementation Configured cost component structure and planned and actual costing variants for make to order and make to stock scenarios. Tested the Product Costing module and Cost Object Controlling respectively. Additionally, served as team player in completing the project on time resulted in to more cost savings.
- Extensive Configuration experience in FICO module in GL, AP, AR, AA, CO-PCA, CO-CCA, COPC and strong understanding of integration with MM, SD, PP, & PS modules.
- Extensive experience in configuration Payment Medium Workbench system (PMW), ACH & Wire Payments using Data Medium Exchange Engine (DMEE).
- Extensive Experience in Asset Accounting, successfully implemented Asset accounting and did 3 rollouts.
- Experience in support of Investment Management, assigned ID numbers to the Investment account and provided support to the users in Investment transactions like Enter Class Data, create Security structure, reports like overall reporting.
- Extensive support experience in support activities of Treasury related assigned ID numbers to the Investment account and provided support to the users in Investment transactions like Enter Class Data, create Security structure, reports like overall reporting.
- Rich working experience with non-SAP system like MES and Work Stream Systems.
- Experienced in interfacing data from with 3rd party systems by using ODBC link Server Connections, Perl Scripts and DTS Objects, and developing upload objects like LSMW, and BAPI’s.
- Able read ABAP code and debug the code.
- Strong business process knowledge of end to end supply chain processes including Sales and Distribution, Procure to pay SNC & ARIBA process, Invoice management, Inventory Management, Production Planning and Execution, Quality Management and Delivery processes in the manufacturing environments in specialty materials and semiconductor industries.
- Highly responsive professional with the ability to build confidence and trust with colleagues Exhibit the ability to take initiative, work independently, and prioritize time effectively to deliver in a timely manner.
- Personal qualities include the ability to work with, lead and motivate various personalities to accomplish cross-functional project goals by being a team player and fostering a team environment.
- Commended and recognized on numerous occasions for delivering positive results.
TECHNICAL SKILLS
- Finance General Ledger (FI-GL/New-GL)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Asset Accounting (FI-AA)
- Bank Accounting
- FSCM Cash Management
- Treasury Management
- Dispute and Collections Management
- Controlling Cost Element Accounting (CO-CEA)
- Cost Center Accounting (CO-CCA)
- Profit Center Accounting (EC-PCA)
- Internal Orders (CO-IO)
- Profitability Analysis (CO-PA)
- Product Costing (CO-PC)
PROFESSIONAL EXPERIENCE
Confidential, Hillsboro, OR
SAP FICO Lead Business Analyst
Responsibilities:
- Successful upgraded system from ECC5 to ECC 6.0, done UAT testing in FI with HP Quality Center. Managed FI cutover activities and scheduling of batch jobs.
- Successfully closed several upgrade related issues in internal SAP applications.
- Configured end to end implementations in multiple domestic and international company codes with G/L, AP, AR, Asset and banking
- Successfully completed 2 full life cycle end to end implementations at TriQuint 1 upgrade and 3 rollouts.
- Implemented functionality for tracking down-payments on Capital Internal Orders.
- Worked extensive in automation of Accounts Payable/Receivable and Banking through implementation of Readsoft Invoice Automation
- ACH & Wire Payments using Payment Medium Workbench (PMW) and Data Medium Exchange Engine (DMEE), Electronic Bank Statements (EBS), Lockbox.
- Self-driven FI improvements saving more number of hours of user time with quantitative benefits and improved internal control and audit ability.
- Designed and developed ODBC interface to get mass volume of Routing data from MES system to update custom SAP routing table along with additional MM information.
- Developed custom Program to read moss volume of routing data from custom table and create routing in SAP
- Designed an Application with workflow for Capital Internal Orders creation and assigning budget, saved lot of CEO, CFO, VP and Director Business user’s hours in workflow, management recognized and awarded me.
- Implemented Asset Accounting Created Chart of depreciation and assigned Chart of depreciation to company codes, created depreciation keys using period control and multilevel methods.
- Assigned number ranges to asset classes, assigned balance sheet accounts and depreciation accounts for asset accounting.
- Performed mass upload of Asset Master Data with reference to legacy asset number, transferred opening balances and accumulated depreciations for Assets.
- Defined Investment Bank accounts and assigned in search strings for investment accounts in Posting rules and posting keys in EBS configured and assigned
- ID numbers to the Investment account and provided support to the users in Investment transactions like Enter Class Data, create Security structure, reports like overall reporting.
- Delivered important BI reports touching sensitive areas like WIP and Variances as part of the CO-PC implementation.
- Designed an Application with workflow for vendor master creation at plant, company code and Treasury approval, eliminated duplicate vendor creations and saved lot of business hours, management recognized and awarded me.
- Delivered greater process and reporting capabilities to business by implementing Asset accounting integrated with Investment Management
- Profit Center Accounting, Foreign Currency Translation, SAP Inter-company Reconciliation, Taxes on Sales and Purchases.
- Worked with key super users to design and implement Business Intelligence (BI) reporting for Finance and Controlling areas - PCA; CO-PC; FI-GL and FI-AA.
- Participated and ensured smooth integration of three Acquisitions at TriQuint.
- During acquisitions of different plants uploaded assets and transferred the assets from one company code other company codes.
- Worked with security and business teams to assign proper security roles for both standard and custom SAP applications as per SOX compliance.
- Reviewed and participated in KPMG quarterly audits in key finance transactions.
- Documented all developments and given training to business key users in SAP standard as well as custom TriQuint functionalities.
- Involved in day-to day production support issues, documented test results in help desk system, and coordinated the weekly changes to production with basis team.
- During day to day production support process under continuous improvement process trace the root cause and resolves issues for ever.
- Worked with offshore development team developing custom applications and regular production fixes.
- Worked on support issue types like enhancement (Development), service request, and Break fix status tickets.
- Worked on developing test scripts for various business scenarios for Unit testing, Integration testing with MM, PP & SD and User acceptance testing.
- Written test case and scenarios Logged test scenarios in HP quality center. Documented all test results and trained the business key users in SAP standard as well as custom TriQuint functionalities.
Confidential
Responsibilities:
- Created GL accounts and migrated Customers and Vendors from legacy system to SAP system in mass volumes, Transferred GL, vendor and customer balances from legacy system to SAP system.
- Defined House banks and bank accounts, Payment terms and payment methods, new check printing procedures specific to the company codes and created payment advises to vendor payments.
- In Fixed Asset module created Chart of depreciation and assigned Chart of depreciation to company codes, created depreciation keys using period control and multilevel methods.
- Assigned number ranges to asset classes, assigned balance sheet accounts and depreciation accounts for asset accounting.
- Performed mass upload of Asset Master Data with reference to legacy asset number, transferred opening balances and accumulated depreciations for Assets.
- Assigned Controlling area to Company code, created Cost Center Hierarchy, Profit center Hierarchy, performed cost center and PCA mass uploads. Created Cost element groups and capital internal order type.
- Maintained Clearing accounts for company codes in OBYA transaction, updated Customer and Vendor Master accordingly.
- Documented the complete business process and provided training to the end users as part of Roll-Out Project implementation.
- Provided post go-live critical support to all sites across different countries and resolved various issues to stabilize the system implementation.
- Documented the complete business process and provided training to the end users as part of Roll-Out Project implementation.
- Developed test cases test scenarios based on business process to support UAT and integration testing activities and coordinated all the transports to support go-live activity.
- Identified all custom transactions that are used in day to day business process across all sites to prepare test scripts.
- Prepared end to end test scripts for all company codes based on TrQuint Business Process that includes SAP and custom transactions interfaces using HPQC.
- Performed end to end Unit testing using test script, documented the test results, assisted business in performing the end to end UAT testing.
- Prepared list of all batch jobs, reviewed and scheduled them as part of integration and cutover.
- Implemented Split order process by activating BADI to transfer actual cost from parent to child in split process.
- Designed and tested BADI implementation in Production order split creation process specific to Oregon and Texas plants.
- Created test cases specific to this split process enhancement and tested in 2 company codes.
Confidential
Responsibilities:
- Created GL accounts and migrated Customers and Vendors from legacy system to SAP system in mass volumes, Transferred GL, vendor and customer balances from legacy system to SAP system.
- Defined House banks and bank accounts, Payment terms and payment methods, new check printing procedures specific to the Philippines company codes and created payment advises to vendor payments.
- Configured, specific to Germany designed and tested creation of additional payment methods to support Payment Medium Workbench system (PMW). Developed and designed ACH & Wire Payments using Data Medium Exchange Engine (DMEE).
- Performed mass upload of Asset Master Data with reference to legacy asset number, transferred opening balances and accumulated depreciations for Assets.
- Assigned Controlling area to Company code, created Cost Center Hierarchy, created Profit center Hierarchy, performed cost center and PCA mass uploads. Created Cost element groups and created capital internal order type.
- Maintained Clearing accounts for company codes in OBYA transaction, updated Customer and Vendor Master accordingly.
- Documented the complete business process and provided training to the end users as part of Roll-Out Project implementation.
- Developed test cases test scenarios based on business process to support UAT and integration testing activities and coordinated all the transports to support go-live activity.
- Provided post critical support to all sites across different countries and resolved various issues to stabilize the system implementation
- Designed and developed ODBC interface to get mass volume of Routing data from MES system to update custom SAP routing table along with additional MM information.
- Developed custom Program to read moss volume of routing data from custom table and create routing in SAP.
- Designed custom programs in SAP to do lot starts, wafer allocation and goods issue of production orders based on data from various custom tables.
- Developed various custom tables to store Mass Volume of lot start and wafer allocation information and developed Perl scripts to update same information in MES system using DTS packages.
- Designed Perl Scripts to get Mass volume WIP data from MES system and update SAP custom tables to update expected out date and quantity in Production orders to determine subsequent lot starts by planners.
- Designed and Developed MII interface to get Mass volume of Split lot information from MES system to create production order splits in SAP and update same volume SAP Split orders back to MES system.
- Designed and developed ODBC interface to get Production order moss volume confirmations from MES system and post confirmations in SAP system.
- Designed and implemented CO-PC implementation, created Costing BOM’s Costing Routings, Configure origin groups, configure overheads based on Overhead key, Configure cost component structure
- Configure planned and actual costing variants for make to order and make to stock scenarios. Tested the Product Costing module and Cost Object Controlling respectively.
- Additionally, served as team player in completing the project on time resulted in to more cost savings.
- Configure period end closing activities for WIP calculation- Results analysis version, valuation methods, line IDs, assignment, Update and posting rules for WIP settlement
- Variance key- Configure variance key and assign as default variant for plant, configure target cost version and Configure settlement profiles
- Designed and developed Enhancement to transfer costs from Parent order to child order at the time of splits, in ECC upgrade project under CO-PC.
- Delivered important BI reports touching sensitive areas like WIP and Variances as part of the CO-PC implementation ReadSoft AP invoice Automation & Standardization of Procure to pay Process
- Implemented ReadSoft at TrQuint to automate input from multiple invoice sources in to SAP along with workflow approval process to streamline the invoice processing, cut down the time and invoice processing cost.
- Invoice Automation speeds up accounts payable processes, allowing for faster financial statements and fewer late payment fees.
- Designed and tested an enhancement in Purchase order to make the recipient filed mandatory to trigger the invoice approval work flow.
- Provided electronic version of cheat sheet to help business perform their normal activities to support ReadSoft implementation.
- Designed and tested a function to perform hierarchy lookups based on dollar value and PO Recipient filed enhancement
- Ensured all the buyers email address matches the email address on the purchasing group and also cleaned up vendor master to eliminate duplicates.
- Designed and tested a Vendor Master Creation Portal to support the vendor master activities with work flow process and provided additional search capability to find the duplicates based on Tax Id Number.
- Provided post critical support to all sites across different countries and resolved various issues to stabilize the system implementation.
- Configured, designed and tested creation of additional payment methods to support Payment Medium Workbench system (PMW).
- Developed and designed ACH & Wire Payments using Data Medium Exchange Engine (DMEE).
- Configured, designed and tested Electronic Bank Statements (EBS), Lockbox, Positive Pay and Evaluated Receipt Settlement (ERS).
- Designed and tested supplier portal where the suppliers can see 100 days of invoice payment history.
- Worked with Basis team to ensure remote server access, authorizations to the end users to work on Invoice cockpit &web cycles.
- Worked with basis and network team to set up a file storage system to store DMEE files.
- Documented the complete business process and provided training to the end users as part of ReadSoft implementation.
- Developed test cases test scenarios based on business process to support UAT and integration testing activities and coordinated all the transports to support go-live activity.
Confidential
Responsibilities:
- Worked on Pre-implementation Scope study, Project Preparation and Finalization of Business Blue Print and involved in Business Processes Reengineering and suggestion of Best Practices. Prepared Functional Specifications documents and Process Definition Documents for new development Objects like (RICEF’s) Reports, Interfaces, conversions, Enhancements and Forms, prepared AS IS and TO BE process documents.
- GL Accounting: Configured Operational chat of accounts, group chart of accounts and country specific Chart of Accounts, created Account Groups and G/L accounts. Configured fiscal year variant, posting period variant, filed status variants. Customizing Screen Layouts for document entry at account / document levels, settings for clearing and posting of documents, Parallel Currencies, Foreign Currency Transactions and Exchange Rate Differences etc. Configured currencies and translation ratios.
- Accounts Receivable (AR): Configured customer master data, customer groups, customer field status, Configured and Tested the Lock Box program for Accounts Receivables payments in BAI2 Format
- Accounts Payable(AP): Configured vendor master data, vendor account groups, tolerance groups, automatic payment program, outgoing payments, recurring transactions, MM - FI integration, three way match, purchase order invoice, house bank, bank accounts, reason codes, check lot, custom check printing, different payment methods including check, wire transfer, validation and substitution, manual and electronic banking statements, business process procedures, unit testing, integration and regression testing, user acceptance testing, user access role based on SOX compliance .
- Cost center accounting: Configured cost elements/groups, cost centers/groups, cost center hierarchy, cost elements, and statistical key figures, automatic account determination, activity types, assessments, cycles, segments and distributions, CCA budgeting and planning
- Internal orders: Configured order types, settlement rules, internal order planning, distribution cycles, cost collector configuration and cost element planning.
- Enhanced Cost center and internal order master data, added additional fields in Cost Center CC Owner, Responsible Capital Analyst, Responsible Finance Approver, in IO added owner of internal order and responsible persons for creation of PR’s.
- Designed an Application with workflow for Capital Internal Orders creation and assigning budget undertaken as an in-house project completed within short time, saved lot of CEO, CFO, VP and Director Business user’s hours in workflow process, management recognized and awarded me.
- Product Costing: Worked configuration of Product cost by Order and Product cost by period scenarios.
- Profit Center accounting (PCA): Configured and customized PCA basic settings, Profit Center Hierarchy, Assignments, CO-objects to Profit Centers, Distribution and Assessment of Costs, planning and Development of Reports.
- Profitability Analysis: Worked on configuring and customizing the operating concerns, Characteristics, Value Fields, Maintaining the Derivation Rules and Valuation, CO-PA Planning, Activating, Reporting, and Adding New Value fields and Characteristics to existing operating concern, Operating concern regeneration, building summarization levels, create COPA reports
Confidential, Burbank CA
SAP FICO Consultant
Responsibilities:
- Included in Pre-implementation Scope study, Project Preparation and Finalization of Business Blue Print and involved in Business Processes Reengineering and suggestion of Best Practices.
- Prepared Functional Specifications documents and Process Definition Documents for new development Objects like (RICEF’s) Reports, Interfaces, conversions, Enhancements and Forms
- Conducted Business Meetings with Development teams and Functional Core team members for Developments of the objects
- G/L accounting: Configuration of basic organizational structure, account groups, configuration of interest calculation (both for balance and item), and configuration for valuation of foreign currency loans,
- Configured all business transactions for accounts payable and account receivables including the payment program configuration, automatic check payment advice and payment analysis printing.
- Clearing of vendor and customer open items, bank master data, house banks for payment program, Periodic-processing correspondence and transferred huge data from Legacy system to SAP.
- Bank accounting: Configured house banks, G/L accounts for Bank accounts and bank account reconciliation program
- Integrated Asset Accounting (FI-AA & AM) structured and valuated Fixed Assets, new Acquisitions, Alteration, Depreciation postings, Year-End closing and Fiscal Year Change.
- Configured Cost center standard hierarchy, Created Cost Center groups and cost centers. Creation of Primary and secondary cost elements, Designed and created Assessment Cycles to allocate overhead costs.
- Creation of Standard hierarchy, Profit center groups and creation of profit centers under groups.
- Preparation of Test cases for testing the Scenarios in Mercury Quality center for Integration Testing and Unit testing
- Designing the steps for Test cases for integration testing and end to end scenarios
- Monitoring the business users to test all the test cases and managing the defects which are created during the testing.
- Preparing the daily schedules for integration testing data.
Confidential
FI Consultant, Location Lead
Responsibilities:
- Understanding new requirements of Business
- Preparing Functional Specs on need basis.
- Responsible for providing the first level support. The scope of support is extended to SAP FI/CO, MM, PP, PS, SD, and QM modules.
- Provided support in configuration and enhancements in the areas of account determination, field status groups, order types, documents types, cost elements and reports.
- Major Configuration points include configuration of Fixed Asset Classes, Master data, Addition, retirement, transfer and other business transactions
- Configuration of Group Fixed Asset Functionality and Group depreciation Reporting
- Data conversion from Excel Database using SAP LSMW functionality
- Designed and executed Data Mapping, cleansing and cutover plans for Conversion of Legacy system into SAP for huge volumes of master data and transaction data.
- Adhering to Client Business Process and Documentation.
- Handling the Service Requests raised by users within the stipulated timeframe and intimating the users the solution by phone/email.
- If issue is a repeated one, did the root-cause analysis did required config changes and did the developments if required.
- Handled issues in GL, AR, AP, Asset Accounting, Cash forecast related to Customers and vendors.
- Handling FI integration issues
- Provided reports in Asset accounting.
- Provided End user training monthly for newly joined End users.
- Working as a team member in the Enterprise Change Management team.
- Engaged in interaction with the Client & understanding the Business Process.
- Creation of AS-IS, TO-BE & Configuration Documents, (T1, T3 and T4 Documents).
- Involved in the Defining and Assigning of Enterprise Structure change elements.
Confidential
Associate ConsultantResponsibilities:
- It’s a Pilot Project, Configured settings for group company codes, configured the posting period variant, Fiscal year variant, and field status groups, defined tolerance groups for employees, and assigned the variants to company code.
- Configured and Customized General Ledger accounting Defined the chart of Accounts, Creation of G/L Accounts for each company code, Screen layout rules, automatic account assignments, recurring entries.
- Configuration for valuation of foreign currency loans
- Creating bank House Banks, Bank Accounts GL accounts for bank accounts and creation of reconciliation accounts for vendors, customers. Created Manual Bank reconciliation Statement
- Configured and Customized Accounts Receivable and Accounts Payable modules including Creation of Vendor Master Records, Customer Master Records, account groups, tolerance groups
- Automatic account determination, payment advice for payments. Configuration for automatic payment program
- Integration of MM and SD with FI Configuration for the controlling area and cost element accounting
Confidential
SAP R/3-FI-Functional Consultant
Responsibilities:
- Support Project of SAP for Sri Murudeshwar Tiles Private Limited, which is a part of Murudeshwar Group of companies.
- This assignment includes Pre-implementation Scope study, Project Preparation and Finalization of Business Blue Print.
- Configured the settings for Employee tolerance groups, field status groups, and Automatic account assignment for the G/L.
- Configured vendor & customer account groups and defined screen layout for them.
- Creation of customer and vendor invoice and payment postings.
- Configured Incoming and Outgoing Invoice, Incoming and Outgoing Payment to meet the need of the organization.
- Provided user support/training by maintaining customer and material information.
- Configured the sending and paying company codes in AP.
- Configured valuation methods for open item clearing for GL, AR and AP.
- Configured different payment methods normal and installment payment method.
- Created vendor and customer master records specifying number ranges and screen layouts.
- Designed and Coded a BDC program for Customer Master, it will update records in Customer Master.
- Designed and Coded a BDC program to migrate Vendor Master Data from legacy system to SAP R/3 database.
Confidential
Implementation Team Lead
Responsibilities:
- Designed and developed and implemented Goodwill ERP solutions of complex financial, accounting and reporting application.
- Directed all accounting, financial reporting, and tax operations for ERP subsidiary company
- Designed the chart of accounts and writing customized General Ledger and Financial Reporting systems
- Developed and monitored all planning and budgeting parameters and internal financial reports, including allocation factors for distribution of common costs and analysis of profits by projects
- Performed Finance and Accounting functions for several departments
- Prepared budgets, reports and financial statements
- Maintained account reports, and tracking spending and cost variances for reporting to senior management
- Successfully reorganized accounting function following termination of predecessor
Confidential
Assistant manager
Responsibilities:
- Maintain IDBI public issue & Allotment money.
- Collecting Allotment money & forwarding paid certificates.
- Forwarding Allotment money to IDBI by way of TT s.
- Reconciliation of Allotment Money and Maintenance of paid data & unpaid data.
- Regularly keeping touch with the IDBI people & providing required data & reports
- Keeping correspondence with the investors queries, and keeps them satisfactory.
- Transferring the certificates and provide to the investors in short time.