Sap Fico Functional Analyst Resume
Irving, TX
SUMMARY
- Over 8 years of experience in SAP configuration, design, Testing and implementation.
- In - depth knowledge and experience in SAP FI/CO implementation encompassing full implementation cycles from Blue Printing to Realization and Go Live, upgrade and support projects.
- Four End to End implementations in SAP FICO AP, AR and GL, SAP COPA. 2 Full Lifecycle Implementations in SAP New G/L: Document Splitting, Ledger Solution and Multiple Scenarios.
- 3+ Implementations in Cost Center Accounting, Profit Center Accounting and Cost Elements accounting. Two SAP Project Systems implementations (integration with contracts and orders).
- Three End to End COPA - Profitability Analysis implementations.
- Two product costing implementation make to stock and repetitive manufacturing processes. Three End to End OTC - Order to Cash (SAP FICO - SD Integration) implementations with complex billing and invoicing and resource related billing solutions, Revenue Recognition, Pricing procedure, Intercompany sales and STO, Credit Management.
- Two End to End PTP - Procure to Pay (SAP FICO - MM Integration) implementations with LIV, ERS, consignment business processes.
- TwoSales and Use taximplementation (for US and Canada - GST and PST). 2 Implementations in SAP Fixed Assets / Asset Management module
- Two full upgrade projects up to ECC 6.0. Efficient use of Report painter, Report writer and LSMW. Accurate and reliable Period end closing, foreign currency valuation. One Closing Cockpit implementation. Extensive working experience across various industries like Chemical, Pharmaceutical, Gas and Energy, Utility, Manufacturing and Retailing.
- Expert in customization of SAP ERP ECC 6.0, 5.0, 4.7 & 4.6c versions in FI-CO modules.
- Responsible, detail oriented with strong technical, analytical, problem solving skills.
- Performed FI testing (FI-AR, FI-AP, FI-AA, FI-GL, New Gl, CO-CCA., CO-PCA, CO-PA, CO-OCA). Experienced System configuration in SAP Controlling modules costing & allocations, internal orders, management reporting, product cost controlling (CO-PC, CO-PA, CO-CCA, CO-IO).
- Involved in Automation payments processing for payments, Credit card authorizations and Issuing checks etc.
- Experience in analyzing business specification documents, developing Test Plans, Test Strategy, Test Scope and defining Test Cases and Automating Test Scripts.
- Experience with Data conversion and providing good strategies with cut over activities.
- Excellent analytical, quick learning and problem solving skills with a desire to work in a team oriented environment. A team player with excellent presentation, communication and interpersonal skills.
- Proficient in External Reporting and preparation of Financial Statements with good understanding of GAAP.
- Conducted training sessions, provided end user training and prepared training documents. Adept in various financial processes including Auditing, Assurance, Accounting processes, Financial statements, Fund Flow Management, Reporting, Consolidation and analysis, Budgeting and Forecasting.
- Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills, excellent communication and interpersonal skills.
- Integration expert for integrating the entire Purchase-2-Pay business process: Creation and maintenance of vendor master records. Vendor transaction processing (including invoices and payments) Integrated nature within the MM component, Invoice verification & Outgoing payment process.
- Integration expert for integrating the entire Order-2-Cash business process covering: Creation and maintenance of customer master records, Customer transaction processing (including invoices, credits, and payments) integrated nature with SD module, Debtor's management, including credit control.
TECHNICAL SKILLS
ERPs: SAP ECC 6.0, SAP ECC 5.0, SAP R/3 4.5b/4.6C / 4.7, SAP Solution manager 4.0, SAP Web Application Server 6.40.
SAP Technology: ABAP/4 Workbench, Data Dictionary, Interfaces, Conversions, Exits, BAPI, BAdIs, EDI/ALE, RFC and IDOCs, C,C++,JAVA.
SERVERS: SAP (NetWeaver 2004s/2004, WAS 6.x, ITS 6.x), J2EE Engine on WAS640/WAS700.
DATABASES: Oracle 7.x/ 8.x/ 9i/10g, MS SQL Server 2000 SP04, MaxDB, DB2 UDB.
HARDWARE: IBM RS6000, Compaq Alpha Server 4100/ ES40, IBM Netfinity, HP 9000, Sun.
OPERATING SYSTEMS: HP-UX, AIX, Solaris, Linux, Windows NT/ 2000/ 2003.
PROFESSIONAL EXPERIENCE
Confidential, Irving TX
SAP FICO Functional Analyst
Responsibilities:
- Interacted with non-information technology related business areas to identify requirements, scope, support implementation of solutions and provide end-to-end coverage for the process teams.
- Created design of reports, forms, interfaces, and conversion to facilitates system understanding and assist the training team in identifying training requirements. Develops business scenarios and test scripts and maintain user documentation. Drives continuous improvements with use of technology solutions by demonstrating value add propositions. Tests, modifies and documents the system configuration. Provide post implementation support. Works in parallel with the training and communication team to ensure all aspects of change is handled.
- Experienced in performing systems analysis and design by meeting with end users and outlining detailed project specifications in order to effectively and efficiently meet business needs and objectives.
- Perform detailed configuration of all CO modules including CCA, PCA, IO, and knowledge in both COPA or Product costing.
- Configured CCA by creating cost centers, activity types, statistical key figures, cost center standard hierarchy, cost center categories, document numbers, overhead structure for accrual costs, allocations using cycle-segment method for periodic reposting, distribution and assessment, indirect activity allocations.
- Create Planning Layouts for Cost Element Planning / CostCenters., CreatePlanning Layouts for Activity TypePlanning, CreatePlanning Layouts for Statistical Key FigurePlanning, Create Planning Layouts for Cost Element Planning / InternalOrders, MaintainUser-Defined PlannerProfiles, DefineAssessmentPlan, DefineAssessment Actual.
- Allocation of quality costs to production cost centers, Period-end closing activities started for production orders, Actual assessment of all cost center costs to profitability analysis (COPA) is run, Analyze costs and revenues for your products, Cost Element planning, Internal Activity planning, Planning Statistical Key Figures, Cost planning using a Template, Overhead allocation using a Costing Sheet, Overhead allocation using a Template, cost estimates. Unit and integration testing for the assembly cycles and component testing cycles. Created Test plans and its approvals from the IT leads and Business CAT system coordination
- Profitability Analysis (COPA):Creating Operating Concern, Maintaining Characteristics, Maintaining User-Defined Characteristics
- COPA: Maintaining Value Fields, Define Characteristic Derivation, Valuation, Assign Value Fields, Valuation Strategies, Set Up Valuation Using Material Cost Estimate, Assign Costing Keys to Material Types
- Maintain Versions, Plan Settlement: Receiving Version in CO-PA, Maintain Revaluation Keys. Define Planning Levels, Define Planning Package, Define Planning Methods (Parameter Set). Create Plan Assessment, Flows of Actual Values, Direct Posting from FI/MM, Define PA Transfer Structure for Settlement. Maintain PA Transfer Structure for Direct Posting, Transfer of Overhead, Contribution Margin Planning.
- Define Variables for Reports, Define Forms for Profitability Reports, Create Profitability Report. Variables for report, forms for report, create reports, Planning Versions, Layouts, Planning Methods, Excel Uploads, COPA master data, Transfer structures, COPA flows
Confidential, Springdale, AR
SAP FICO Functional Analyst
Responsibilities:
- Gathered business requirements and prepared blueprint documentation for OTC cycle for sales order processing, delivery and billing.
- As a Senior SAP FI-CO Consultant, Helped the client to unravel the Financial Reporting strategy with ECC SAP implementation from the existing SIM Process across various Work streams that includes AP, AR, GL, COPA, CCA, PCA, SD, MM. Responsibilities include Enhancement, design, configuration, testing and re-engineering of various functionalities in FI and CO modules & Order Cash Process.
- Involved in Invoice Processing for Payments, issuing checks and posting straight through SAP Invoice Processing.
- Handled Order to Cash (OTC) such functions as Inquiry - Quotation - Order - Delivery - Picking - Post Goods Issue and Billing and Procure to Pay (P2P) such functions as Purchase requisition, Purchase Order, Goods receipt, Invoice verification and Vendor payment.
- Involved in the implementation of Revenue Recognition process for reporting. Worked extensively on data transfer for billing documents from the external source into SAP and COPA. Knowledge on mapping data from external to internal system. Thorough understanding of the BAP’s and IDOC interface. Created specification for IDOC mapping for orders.
- Extensive knowledge on mapping requirements from external source to sap for OTC billing process. This includes understanding on IDOC’s and message types for billing.
- Implemented automated payment workflow for invoices such as Invoice capture, Validation, Resolution Workflow and Information access.
- Conducting meeting with Business users for Preparation of the AS IS and TO BE documents and Interaction with user and client to understand their requirement and concern over existing system to identify system improvement points
- Retest and suggested for enhancement in General Ledger Accounts (GL), New GL, AP, AR, FI/SD Interface and other related configurations. Understood the existing internal financial planning process for reporting and conducted the report rationalization process to provide the functional spec documents for the BI & BOBJ reporting developers.
- Customization of New Financial statement version i.e. Balance Sheet & Income Statement for new Group Account. Changes in the Cost Center Accounting, Profit center accounting, cost elements, cost centers, for enhancement in functionality and reporting.
- Preparation of additional reports for development and enhancement in existing system using Report Painter.
- As a Test Coordinator was working on HP Quality Center for test management, defect tracking and reporting, this included daily status meetings and risk management.
- Involved in Cutover Activities and data conversion and Open AR conversions.
- Maintenance and Tracking of Requirements in the QC requirements module, Creation of Test Cases in Test Plan module, Test Execution in Test Lab module, Defect logging and tracking in Defects module and Dashboard Reporting from HP QC for Release coordination.
- Expertise in preparation of the test scripts and coordinating with the development team for fixes and enhancements. Assisted the end users with the UAT testing along with the Regression testing and System testing.
- Customizing HP QC queries for reports and workflows within Quality Center and creating traceability from Requirements to Test cases to Defects inside Quality center.
- Setting and creating cost elements, cost centers, Profit Center Product Costing, valuation profiles, field status groups, Pricing, Billing, AR lockbox and internal orders for enhancement in functionality and reporting. Re-Configuration of Product Costing, including defining settlement profile, Assessment Cycle and distribution.
Confidential, Benton harbor, MI
SAP FICO Functional Analyst
Responsibilities:
- Primarily involved in the enhancement of freight Costs to serve for the supply chain team at Confidential .
- The business requested the business enhancement change solution to reduce the variances in the freight Costs between standards and the actual posted through the invoices with the Profitability Analysis module of SAP FICO.
- Extensively participated in understanding the GAP by creating the flow charts and Flow Diagrams and presenting to the client partners.
- Involved in the gathering of the business requirements for the enhancements, participating in preparation of the Functional requirement document. Creation of the Cost centers and the value fields as per the requirement. Also, create the planned version and Plan distribution cycle in COPA & CRM.
- Existing system is studied, and gaps are identified before going for the configuration. Maintained Controlling Area settings. Configured settings for controlling area and operating concerns. In Profitability Analysis, restructured the configuration for Cost based CO-PA & CRM.
- Restructured Cost center groups and Profit Centers. Profit center account groups are created. Restructured assignments to profit centers. Maintained versions in profitability analysis. Planning framework is set and worked on planning layout.
- Extensively analyzed the processes for the existing condition records and record types. Created the new record type and condition types for the Costs to serve process.
- Involved in the preparation of the 'As is' document and the Functional requirement document for the technical ABAP team members. Helped in the configuration for the creation of new tables for Shipment, delivery and billing process and creation of new custom Z program for freight costs in COPA.
- Determined the shipment cost calculated in the SAP based on the total weight and the cubic volume obtained from the delivery document details.
- Enhanced the process for calculating and settling freight shipment costs after billing that would post the documents into the COPA and analyzed how the shipment costs are determined in the shipment, how they are transmitted to accounting, and how they are settled with the service provider.
- Created the IDOC and EDI interfaces for the inbound and outbound freight processes. Knowledge OTC scenarios, Contracts, SAP Pricing (SD), Revenue Account Determination, Master Data (Materials, Condition records, Business Partner),EDI/IDOC, interfaces.
- Configuration and Integration of SAP Revenue Recognition with SAP Sales and Distribution and for external data upload, Scenario identification, Configuration, Base system configuration and testing. Identify relevant data from source for Order/Contract items. Design functionality of source data extraction and transformation into SAP RAR acceptable format.
- Created the new reports using the existing reports for the freights with the Report painter and Report Writer tool.
- Prepare & execute the migration and cutover plan.Working with BI team for building report.Interacted with the BW team to create the queries for the new reports from the existing reports. Created the info cubes and info areas for the enhanced process.
- Also, participated in the other projects that in Setup Bank configuration for vendor invoice interface and design custom check layout. Created workflow for automatic payment run.
- Assisted and trained the business users on the new process for thorough understanding of the enhanced process. Support the Gap resolution process in close cooperation with Core Team.
- Provided solution to increase efficiency and profitability with reduction in the transportation charges created through the planned data the SAP that would improve the responsiveness and customer service and decrease freight transportation costs.
Confidential, Schaumburg, IL
SAP FICO Functional - Team Lead
Responsibilities:
- Supported the ZNA systems. Takes Proactive and solution-oriented approach in regard to issue management and resolution when providing day-day support to the end user community.
- Service desk ticket investigation and resolution. Communicate, in a timely manner, both verbally and in writing to Platform personnel.
- Extensively gathered requirements from all users, experts, and key personnel to understand the current functionality of the existing system.
- Decompose high-level information into details, abstract up from low-level information to a general understanding and distinguish user requests from underlying true needs.
- Configure the SAP OTC module to meet the business requirements and conduct solution architecting workshops with business managers.
- Worked on Revenue recognition process for deferred and unbilled revenue accounting scenario. Also have extensive knowledge on external data transfer from non- sap systems using IDOC, (Maintain partner profile etc.). Worked on the interfaces for the periodic transfer of billing data use thestandard IDoc interface as the technology for communicating between an external billing system and the R/3 System.
- Monitoring the interfaces and jobs executed during the month-end closing activities.
- Accounts payable-- creation of vendor master, vendor account groups, configuration for Automatic payment program,
- Defining Alternative reconciliation account for special GL transaction like Down payments and Automatic payment program.
- 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, statistical key figures, Internal Orders, Profit center accounting, Profitability Analysis.
- Conduct project meetings and maintain project schedules by developing project plans and specifications, estimating time requirements, establishing deadlines, monitoring milestone completion, tracking all phases of the project product/service lifecycle.
- Provide timely reporting of issues that impact project progress, coordinating actions, and resolving conflicts. Effectively supervise and instruct both internal and external vendor resources of business and technical professionals to achieve business solutions within project guidelines.
- Apply and recommend the appropriate tools and languages that are required to develop/modify abusinessapplication.
- Involved in the production support activities to resolve day-to-day issues in the banking process for Accounts payable and Accounts Receivable.
Environment: SAP-R/3 Version: ECC 4.7
Confidential, Deerfield, IL
SAP FICO Functional consultant
Responsibilities:
- Conducting and Coordinating Business Blueprint workshops for understanding client requirements.
- Understanding the business scenario in the Q/A database and generate issue log to track issues in the following areas
- General Ledger/ Chart of Accounts
- Accounts Receivable
- Endowment and Other Restricted Funds
- Asset Accounting - Equipment and building
- Accounts Payable
- Preparation of business blueprint deliveries. The task involved identification of data conversions required, interfaces needed.
- Collaborative work with the key users in the documentation of “As-is process”.
- Performed data validation and account determination for mapping of the processes on to the SAP R/3 system.
- Gap analysis with realization of open issues and design of best fit functionalities.
- Educating the client on FI and CO Master and transaction data information with Intercompany processing details.
- Testing of full order to cash and procure to pay process. Have good experience in writing functional specification for generating new reports to ABAP programmers.
- Preparation of test plans, which specify testing overview, testing approach, testing strategy, roles & responsibilities and scope of testing. Developed detailed design and code configuration walkthroughs with creation of test deliverables.
- Provide CRM functional design solutions for customers, including full life-cycle implementation Configure and implement CRM functional modules, encompassing sales planning, order management, account andcontact management, and commission management.
- Successful Implementation of FI (GL, AR, AP) and CO settings on the development server and ultimate transportation on to the testing and production servers.
- 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.
- Configuration of interest calculation. Worked extensively on generating standard Sales report in Accounts receivable-MB55 GR/IR balances. Consistently worked on the IDOC interfaces along with ALE.
- Understand and configure the key integration points in FICA.
- Prepare customize and maintain documentation for Logistics Invoice verification (LIV).
- Configuration of Bank accounting, Asset accounting, Cost and Profit center accounting.
- I was also responsible for the design, configuration and implementation of all CO sub-modules - CO-PC, CO-IO, CO-CCA, Profitability Analysis, Product Costing.
- Prepared, documented and maintained all documentation and processes for end users. Provided SAP training for (CO-CCA, CO-PC, CO-IO, CO-PA)
- Conversion of year dependent periods to normal calendar month periods. I was involved in Period end and Year end closing activities. Assist in month-end closing process. Work with various departments to identify assets to be capitalized, retired or have their lives accelerated or decelerated. Perform depreciation function monthly. Responsible for maintaining the SAP project system for Capital Projects. Prepares the Roll forward for Asset retirement obligations.
- Coordinate with various departments to determine monthly Capital and Depreciation accruals. Perform General Ledger Expense analysis. Provide support for various departments as necessary (i.e.: Running queries, reports, research, etc.).
- Prepare monthly & quarterly general ledger account reconciliations. Prepare schedules and provide support to our external auditors.
- 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.
Environment: SAP-R/3 Version: ECC 6.0, EHP 4
