Sap Fico Functional Analyst Resume
Chicago, IL
SUMMARY:
- Over 14+ years of SAP FICO experience in various modules - FI (with SAP New GL, AP, AR. Treasury &Banks) Controlling (CEA, CCA, Internal orders, PCA, CO-PA, Product Costing (CO-PC), Material Ledger). EC-CS (Consolidations), (Asset Mgmt (AM), Integration experience with Project Systems (PS), Production Planning (PP), Procurement (MM), Investment Mgmt (IM), Sales & Distribution (SD), and good understanding & hands on experience in IFRS reporting and SOX compliance
- Worked within both waterfall and agile SDLCs for the end to end project implementations.
- Worked as a SAP FICO specialist in diversified industries - Automotive, Manufacturing, FDA approved Bio-Pharma (Abbot Labs), Public sector (Federal), Retail, Tobacco, and other industries
- 12+ years of Professional & business experience as a Certified Accountant (CPA)
- Participated in 8 Full life cycle implementations (with strong understanding of all aspects of a full life cycle implementation), 2 upgrades and 3 production support roles, extensive knowledge in Data Conversion - Data mapping, data cleaning, and conversion master & transactional data from various legacy systems to SAP by using various tools (LSMW, CATT, Quick Test, and various custom programs.
- Worked with BW/BI teams to provide master & transactional data through Extractors
- Worked with EPM/HFM teams in generating consolidated financial (Actual & planning) reports.
- Teamwork / collaboration expertise with significant experience in taking a leadership role in team / project activities
- Ability to research and assess potential SAP solutions in support of new business requirements
- Worked in several roll out projects - Mexico, Europe, Canada, Brazil, China, and South Africa.
- Worked in all phases of design, development, testing, Go live & post Implementation support, and adopted best implementing practices..
- Lead experience in Upgrade to 4.7 & ECC 6.0
- Worked extensively with Hyperion for running various reports, Vertex system for use& sales tax calculation & reporting, worked with various interfaces, EDI, and IDCOS ect.
- Strong Process understating of Financial Management, Accounting, Auditing, Taxation, and Capital Management areas.
- Good understanding of US GAAP/IFRS and in SOX Compliance.
- Strong skills in problem solving, making best project plans & leading the projects, participating as a team member of projects, and supporting users.
- ERP: SAP R/3 ECC 6.0, 5.0, 4.7, 4.6C, and 4.6B versions.
- FI: General Ledger SAP-FI-GL, New GL, Accounts Payable SAP-FI-AP, Automatic payment program, Treasury, House Bank, Bank reconciliation (electronic and manual), Procure-to-pay-cycle, Substitutions, Validations, Accounts Receivable FI-AR, Order-to-cash, SAP-Treasury, Lock Box processes, EDI, Credit Management SAP-FI-CM, Special Purpose Ledger SAP-FI-SL and Asset Accounting SAP-FI-AA (Fixed assets, Asset classes, and special asset classes), and Interfaces and data loads (LSMW, CATT & others)
- CO: Profitability Analysis SAP-CO-PA, Profit Center Accounting SAP-EC-PCA, and Overhead Cost Controlling SAP-CO-OM, Cost Center Accounting SAP-CO-OM-CCA, Internal orders (SAP-OM-OPA), WBS elements, Activity-Based costing, Standard hierarchies, Product Costing SAP-CO-PC, Cost Object Controlling, and Product cost planning.
- Implementing new functionalities & maintenance of EC-CS Consolidation
- Expert in preparation of reports using BI, HANA, BEX (Business Explorer), Report writer and Report Painter
- Knowledge of ASAP implementation and capability of communicating with ABAP programmers for technical specifications. Application of OSS notes wherever applicable.
- Conducted Feasibility Studies, Project planning, Planning for Development, Enhancements and conversions
- Expertise in Configuration and testing
- Experience in Globe template Implementation (Full life cycle Implementations)
TECHNICAL SKILLS:
Software Tools: Mercury QTP Test Director, Quality Center, MS Office, MS Project, MS VISIO, Lotus SmartSuite, MSSQL Server, ORACLE, MS ACCESS
PROFESSIONAL EXPERIENCE:
Confidential, Chicago, IL
SAP FICO Functional Analyst
Responsibilities:
- Responsible to provide leadership to the SAP IT Finance (which includes working in the cross modules - FI(GL/AP/AR/Treasury/FSCM/Fixed Assets/Project systems), CO (CEA/CCA/PCA/COPA/COPC (process & PM orders) by providing the business initiative solutions within SAP, coordination of project-related deliverables and providing ongoing support & resolution to day to day issues of the business.
- Responsible in implementing Controlling module (which at present used partially) with CEA, CCA, PCA, CO-PA, and COPC at the Sebree, KY plant.
- Responsible in working with PWC (Price water house coopers) EPM/HFM teams, and with BW team by providing required master & transactional data from ECC system, and in making required configuration/development works to bring group Chart of accounts & mapping the operational chart of accounts for the purpose of creating Consolidated financial statements (as per US GAAP & IFRS guidelines) through Hyperion system.
- Responsible in working with PWC implementation team who is implementing the ECC 6.0 with New GL at newly acquired Mt. Holly plant in South CarolinaDeliverables
- Development of separate custom programs to extract financial, controlling, and sales data to feed HFM (Hyperion) system
- Worked with BI team to provide appropriate standard/custom table information which in turn helps them to identify the appropriate Extractors/data sets
- Analyzed all the existing Report Painter/Custom reports used by the Century, and identified crucial reports which need to be generated through BI/HFM route.
- Completed the end to end implementation of CO Module (CEA, CCA, PCA, CO-PA, and COPC), and after integration/UAT testing it went live in the production.
- Prepared all the systems (Sandbox/Dev/QAS) in Brown field (i.e. exiting plants) in sync with the PROD system by loading all missing master data, and by loading new group Chart of accounts by using LSMW tool, and made them ready to rollout Green field Templets(Mt.Holly implementation with New GL) to these plants.
- Being member of COE (Center of excellence) provided complete support to the business & users by resolving the issues, without breaching SLA time line, in the areas of FI(GL, AP, AR, and PS) CO(CEA, CCA, PCA, CO-PA, and Product Costing relating to CO/Process/PM orders), and in the areas of integrating modules - SD, MM, and PP
- Conducted sessions to end users and knowledge transfer sessions to Power users at Sebree plant location.
Confidential, Collegeville, PA
SAP ERP Finance Solution Analyst
Responsibilities:
- Working with BI team for master & transactional date flow through custom programs, helping them in segmenting the transactional line items as per profit center/Business units, and working closely to consolidate the data & to report the financials through Hyperion system.
- Additional Configurations for VAT for several Company codes located in Europe, Asia, Canada, and Mexico, and developed the AR & AP VAT allocation & calculation driver program to generate custom reports for each Business Unit by grouping all the profit Centers covered under that unit, by extracting Tax data from BSET table,
- Involved with the team in the demo phase of SAP HANA DB using HANA Studio
- Performed the Master & Transactional data replication through Data Provisioning using SLT (SAP Landscape transformation) method from SAP ECC source system.
- Conducted HANA Modeling activities for the creation of Calculation (Graphical) views by using Attribute & Analytic models for Aggregate outputs.
- Along with the team conducted activities to generate CO-PA & other reports in HANA DB on Excel (MdX)
- Worked with development team in development of custom programs to re-class the AR & AP reconciliation accounts related open items as per its offsetting lines so that every AR & AP recon open items will be split with an assignment of profit center/Business unit.
- Worked with ABAP team in modification of custom AR aging report programs in order to get the data from BFOD A & BFOK A tables instead from BSID & BSAK tables, and to classify the data as per Credit control area and as per Credit Segments (FS-CM)
- Project Systems-Worked in configuring R&D related new projects, defining the time profiles, maintained the Planning and Budget profiles, configuring the parameters for Network/WBS scheduling profiles, created the Fund Commitment items & assigning to GL account, and assignment of WBS element to projects and assignment of Cost center/AUCs in the settlement profiles
- Working in BT (Business Technology) help desk area in resolving the end user Incidents, and Change request (both Config. & Development related), without breaching SLA (Service line agreement) time. issues relating FI (GL, AP, AR, Treasury, Asset Accounting, Project systems), CO (CEA, CCA, PCA, CO-PA, Product Costing, Material ledger), issues relating data flows from SD, MM, PP, PS, making Configuration & enhancements in the Material ledger area to make the Actual run as per requirements, and WM areas, Master data issues, and issues relating to data in/out from various non SAP systems.
- Product Costing (CO-PC): For global company codes I have setup new Costing & Valuation variants, integrating controlling modules with Product Costing by mapping various Cost elements to new cost components created in new Cost component structures, Configured new Costing sheets to generate Overhead costs (labor, material) for new Plants, Configured new settlement profiles to attach to production orders used for MTS(for repetitive manufacturing), Configured all the components for WIP(Working capital calculation), configured required variance Keys to assign for the purpose of variance calculation, and helped the PP team by providing required cost centers, activity types (with pricing), and other master data for configuring the BOMs, and Routings.
- Further in CO-PA module added new Characteristics and Characteristic values, adding new SD pricing conditions in mapping with CO-PA Value fields, updating PA Transfer structure with new controlling area related source (Cost elements/groups) and destination (Value) fields, created new product hierarchies, and incorporated in the new CO-PA derivation rules in order to derive new Characteristic values from Product hierarchy, and created new derivation rule to derive Product hierarchy from material master when there is direct posting from MM to CO-PA. As per the client need, created new KE30 reports & forms in order to generate reports by ‘units (Product) by size and by sales quantity.
- Configured required steps to map the CO-PC cost estimates & Variances to flow into CO-PA.
- Creation test cases & testing scripts relating all SAP modules by using HPQC tool, and inter acting with users in User acceptance testing
Confidential, Naperville, IL
Analyst, Business/Configuration Lead
Responsibilities:
- Implementing end to end Customer Rebate & Subsequent settlement process within SAP ERP system
- Implementing end to end Vendor Rebate & Subsequent settlement process within SAP ERP system for the Purchases & Vendor Returns
- Responsible for Production Support which includes - Incident/ Service requests monitoring, and bug fix through corrective//Project changes in SAP application, handling issues
- Coordination of technical resources necessary to implement solutions for complex business requirements within& outside SAP ERP systems
- Determine functional solutions to meet business requirements, detail system design, analyzing the jobs/programs needed to be written or revised, and estimating the time and resources needed to complete the project/assignment
- Actively interacted with business users by various correspondences (memos, e-mail, and voicemail) to convey project/assignment status and information in terms clear to business and technical users.
- Sales data flow into SAP SD & FICO modules through various legacy inbound interfaces, which includes inter-Company operations, handled VFX3 issues, and Credit card processing.
- Involved in the day to day support in inbound data flow from various interfaces into SD & MM modules in integration with FI, CO, Project Systems, and CO-PA which includes complete the support business process relating to Buy On Line (BOL), master data setup, configuration & development of required enhancements to make required changes in the exiting in & out bound interfaces, and created Custom reports as per business requirement. Made required system changes through configuration. & development to accommodate & process all types of Customer Credit cards like setting up & updating various custom tables to record credit card information, tolerance limits, and authorizations. Implementing by configuring the system for automate processing the customer receipts through Payment program which includes required enhancement in Treasury & TIBCO interfaces
- Involved in support of all the Controlling modules like CEA, CCA. PCA, CO-PA, and brought changes in the required areas through enhancements & configuration., Involved in maintaining the Project Systems for various Capital & Investment projects, Creating WBS elements & its settlements to various AUCs (Assets under Construction), and designed various custom reports in FI & CO areas
- Involved in implementing the required changes in Asset Accounting to add various new requirements, Depreciation keys, and account determination with new GL accounts for the data flow into FI&CO modules.
- Involved in the end to end implementation of VIPO (Vendor income Project Optimization) Project:
- This project is to automate the Vendor rebate process in SAP by enhancing the calculation vendor income on the event driven funding, and to enhance its forecasting ability. It includes end to end configuration in SD area - Creation of various rebate agreement types, rebate conditions, and creating various pricing procedures with relevant routines for requirements & calculation formulas. Prepared several functional design documents for bringing new custom programs & enhancement in the exiting program through User exits, and routines. Development of customer Invoice & debit memo forms by using SAP Scripts & Smart forms.
- Involved in the end to end implementation of D&D (Damage & Defective articles return to vendors) Automation project:
- Automate the existing Damaged & Defective (D&D) process in SAP to leverage the written claims subsequent settlement functionality for claiming damage and defective from the vendors
- In the form of rebate The rebate is either an actual returns within the prior fiscal period OR· a pre-defined allowance of gross or net YTD purchases OR· a fixed monthly dollar amount..
Confidential, Andover, MA
Global FICO service Lead
Responsibilities:
- Responsible to provide leadership to the SAP IT Finance by providing the business initiative solutions within SAP, coordination of project-related deliverables and managing the activities of team resources.
- Responsible to provide leadership in the maintenance of the SAP system along with other solutions in support of business processes
- Production Support - Incidents, Service requests/Standard change, Corrective change/Bug fix, Problem tickets/RCA, Performance improvements, System refresh validation, Projects, and end to end Responsibility of service in relation to co-ordination with other vendors/stakeholders of the service locations in United states, Mexico, Canada, Netherlands, China, India, and Australia.
- SLA monitoring & keep the ticket handling without breach of SLA
- Responsible to comply with Quality & Regulatory regulations of FDA, PCI/Health care security regulations (HIPPA), and to comply with ICS/SOX regulations
- Handling of Customer services like Installations & after sale services by Service work orders (through resource related billing)
- Managed Record-to Report Process team, BI, BOBJ and HANA teams
- Providing the required Configuration &Code changes through valid CRs, and to provide all the required functional & technical design documents, module, Regression, User acceptance tests documents in Solution Manger repository.
- Monitoring Incidents/Service requests/ CRs in SM7, and providing resolutions within the time given by SLA
- Update the Knowledge repository (in SM7), and update the support process manual & SLA hand book.
- Creation test cases & testing scripts relating SAP modules in HPQC tool, and inter acting with users in User acceptance testing
Confidential, Chicago, IL
Consulting Manager
Responsibilities:
- Responsible to provide leadership to the SAP IT Finance by providing the business initiative solutions within SAP, coordination of project-related deliverables and managing the activities of team resources.Responsible to provide leadership in the maintenance of the SAP system along with other solutions in support of business processes
- Prepared ‘AS IS Confidential EMD division Business blue print’ after due discussions with client.
- Prepared ‘TO BE Confidential EMD division Business blue print’ to
- Bring Confidential EMD division into SAP ECC 6.0 and to Integrate the FICO module with MM (order to Cash), PP (Production Planning), Product Costing, CO-PA and SD (Order to Cash) modules through account determination process.
- Prior to finalizing the TO BE blue print, prototype configuration & testing has been conducted in the following areas
- Configured & tested Customer down payment process Determined the GL accounts to post SD related billing documents & MM related goods movement documents into FI
- Created the required Cost elements, cost centers, profit centers and its groups.. Maintaining required pricing procedures for customers, documents, and Item categories, and defining pricing procedure determination, and profit center substations ( through billing user exits) in the billing process, I Docs process related issues.
- Product Costing: Created PP related Production order types, and assigned new settlement profiles & allocation structures. Created of new Overhead cost elements, Activity types, planned activity costs. Configured new Costing variants, Costing Sheet with Activity type & Cost Center as base, and added the cost elements to cost component structure. Provided required master data (Cost centers, work centers, Activity types with activity prices to the cost centers) to the PP team, and created the BOMs & required routings. Configured the Work in Process (which includes defining RA keys, creation of WIP cost elements, defining RA versions & valuation methods, defining Line IDs & assignments, defining update - assignment of WIP cost elements to RA key/RA version/Line IDs, and defining of posting rules to post WIP FI.) and Variance calculation (which includes defining Variance keys, valuation variants for WIP, and defining of target cost versions), and assigned RA keys & variance keys to newly created production & other orders.
- Updated all the transactional data in CCA, PCA, CO-PA, and Product Costing and generated the standard & custom reports as per clients requirement Prepared the functional specifications to post Use Tax in the maintenance orders through a journal entry.
Confidential, St.Louis, MO
Consulting Manager
Responsibilities:
- Europe PTP & OTC and PR&D Project: Setting up new company codes for Europe for the purpose of establishing procure to pay (PTP), and Order to Cash (OTC) processes which includes
- In FI & CO module assignment of Chart of accounts to new Company codes, setting up new master data (GLs, Cost elements/groups, Cost & Profit Centers with hierarchy, and internal orders), configuring required distribution cycles in Cost center accounting & Profit center accounting, and settlement profiles for Internal orders, and created required primary & Secondary Cost elements and groups in Cost Element Accounting.
- Configured Inter Company billing & integrated FI &CO with MM&SD which includes, SD&MM account determinations, setting up new movement types, billing types, required enhancements for profit center substitution in billing documents, required configurations to post the Stock Transport orders, and changes in material masters with new product hierarchies in basic & costing views, adding new sales org. & Plant views, and adding the new Valuation data. Maintaining required pricing procedures for customers, documents, and Item categories, and defining pricing procedure determination profit substations in the billing process, and handled IDocs process related issues.
- In Product Costing module configured new Process order types with new Planned & Actual costing variants for processing PR&D Semi finished stock, and post them into inventory.
- In the CO-PA module added new Characteristics and Characteristic values, adding new SD pricing conditions in mapping with CO-PA Value fields, updating PA Transfer structure with new controlling area related source (Cost elements/groups) and destination (Value) fields, created new product hierarchies, and incorporated in the new CO-PA derivation rules in order to derive new Characteristic values from Product hierarchy, and created new derivation rule to derive Product hierarchy from material master when there is direct posting from MM to CO-PA. As per the client need, created new KE30 reports & forms in order to generate reports by ‘units (Product) by size and by sales quantity.
- Changes ZIE Custom program project: Thoroughly reviewed the program, which is supposed to post intercompany profit (in the material) elimination entries in eliminating Company codes while executing ‘MIGO’ and ‘MIRO’ transactions, to find the reasons for not working after the implementation of SAP enhancement pack 5, and identified the reasons that the SAP note 561175 which was implanted with BAPI - BAPI ACC GL POSTING POST, was stopped working. Coordinated with SAP America to make the required changes in the SAP note, and made the Program functional.
- Product costing: (Ireland Costing Sheet Project) I have done the required configurations to populate Freight as a separate component in the material cost estimate-which includes creation of freight as an Additive cost, making required changes in the Costing & Valuation variants in order to allow the additive cost, and adding the freight cost elements in Cost Component Structure. As per client need created new Labor costs as new activities, updated the new cost elements relating new activities& new Overheads in Costing Sheet & Cost Component structure, created new Overhead rates, and involved with PP team in the creation of new process orders, new costing Variants, and in updating the Routings/Master Recipe with new Operations.
- Creation test cases & testing scripts relating SAP modules HPQC tool, and inter acting with users in User acceptance testing
Confidential, Glendale, CA
Consulting Manager
Responsibilities:
- Responsible to provide leadership to the SAP IT Finance by providing the business initiative solutions within SAP, coordination of project-related deliverables and managing the activities of team resources.
- Responsible to provide leadership in the maintenance of the SAP system along with other solutions in support of business processes
- Responsible for SAP Rollout, Design, Analysis, Enhancement and Support Projects for newly acquired Pizza & Ice cream US market ( Confidential and Kraft foods)
- Configured newly acquired company codes and their global settings
- Designed FIT-GAPs, Functional specification, Test scripts (preparation and execution) and knowledge transfer as a part of the Rollout.
- Lead COPA Rollout: Added additional characteristics, value fields, PA transfer structure maintenance, derivation rules, top down distribution, and COPA planning design.
- Maintenance of integration areas and account determination in SD and MM with Finance.
- Involved in COPA moth end closing, and Provided production support &development roles.
- Worked with business teams in getting reporting requirements and delivered global report painter reports.
- Involved in the migration of KRAFTS assets (asset accounting) into US Confidential SAP ECC6.0 version which includes creation of depreciation areas based on USGAAP, IFRS and Tax requirements.
- Created Internal orders, settlement rules, individual and collective settlements of internal orders, Statistical key figures (SKF).
- Product Costing (CO-PC): For global company codes I have setup new Costing & Valuation variants, integrating controlling modules with Product Costing by mapping various Cost elements to new cost components created in new Cost component structures, Configured new Costing sheets to generate Overhead costs (labor, material) for new Plants, Configured new settlement profiles to attach to production orders used for MTS(for repetitive manufacturing), Configured all the components for WIP(Working capital calculation), configured required variance Keys to assign for the purpose of variance calculation, and helped the PP team by providing required cost centers, activity types (with pricing), and other master data for configuring the BOMs, and Routings
- Involved in the Configuration of New GL, Chart of accounts, Company Codes, assignment of account groups, Field status variants and Fiscal year variant. Involved in New GL conversion activities, document splitting, parallel ledgers to bring US GAAP and IFRS porting in the client environment, and leading and non-leading ledgers creation.
- Involved in Cutover, Monitoring of transports, Data loads, Go - Live preparation and data conversion activities in Global Environment.
Confidential, Winston Salem, NC
SAP FICO Delivery Manager
Responsibilities:
- Responsible to provide leadership to the SAP IT Finance by providing the business initiative solutions within SAP, coordination of project-related deliverables and managing the activities of team resources.
- Responsible to provide leadership in the maintenance of the SAP system along with other solutions in support of business processes
- Implemented the Chargeback process (Vistex) which includes configuration Agreement types, pricing procedures with relevant condition types, configuration of accrual and settlement profiles, configuration of message types for partner communication, and reconciliation vendor responses.
- Responsible for SAP Implementation, Design, Analysis, Enhancement and Support Projects in RJRT Globally
- Configured Company codes, Fiscal year variants, Account groups, Field status variants and other assignments related to company code configuration
- Configured newly acquired company codes and their global settings
- Designed FIT-GAPs, Functional specification, and knowledge transfer documents as a part of the blueprint and realization phases in many areas of FI and CO.
- Coordinated with MDM team (Master data Management team) in the Master data loads, data validations for Vendors / Customers / Cost centers / internal orders in SAP system.
- Performed the system Validations, functional unit testing, regression testing and User acceptance testing (UAT) with the Power users on the configured systems. Coordinated the maintenance of the transports for Finance team.
- Worked in the integration areas of FI-MM and FI-SD and completed the configuration
- Designed some of the Enhancements and coordinated with ABAP team in development of in several areas such as Credit management, Scheduling agreements areas and others.
- Designed reports as per business requirements by using Report painter, Report writer tools for global company codes such as China, UK, Italy, Germany, India and others.
- In FI-GL, Involved in Configuration of GL accounts, chart of accounts, assignment of account groups, Field status variants and Fiscal year variant. Involved in New GL conversion activities, document splitting, parallel ledgers, Leading and non-leading ledgers creation.
- In accounts payables (AP), set up different Payment methods, Payment terms. Configuration also includes FI-MM integration and Procure to pay (PTP) processes
- In Accounts receivables (AR), set up the complete configuration like setting up billing, Dunning procedures and other areas including the integration of Credit Management (CM), TAXWARE, Order to Cash (OTC) & Sales and Distribution (SD).
- Worked on some of the production support issues related to the Flash sales, intercompany transactions, IDocs and Logistics (MM and SD).
- In Asset Management (FI-AM), involved in the master data loads of Asset accounting, Asset classes, Depreciation areas, Depreciation keys, and other Assets under construction, as part of implementation.
- Created SAP info sets, queries from standard tables & table joins in Global and standard areas for data extraction process.
- Configured Cost center master data (CO-CCA), Cost center hierarchy, Period end closing activities, Actual &Planned Assessment, Distribution cycles and Automatic account assignment.
- Defined financial statement versions for all the Company codes in all American, Europe and Asian regions
- Configured Profit center Master data (CO-PCA), Profit center hierarchy, P&L statements & balance sheets for Profit centers
- Defined Internal orders (CO-OM-OPA), settlement rules, individual and collective settlements of internal orders, Statistical key figures (SKF).
- Configuration of CO-PA, Operating concern, Characteristics, value fields, Derivation rules (table lookups, clear, move and others), SD integration areas with CO-PA, condition types, access sequence and flow of actual values. COPA reporting and Settlements to the COPA segments.
- Presented Project documentation to end users and conducted knowledge transfer sessions to Power users.
- Involved in Cutover, Monitoring of transports, Data loads, Go - Live preparation and data conversion activities in Global Environment.
- Involved in Maintenance of GRC (Governance, Risk & Compliance) controls for FI team. Proposal of Role Assignments, Role Conflict Management, and Mitigation control applications for sensitive transactions.
- Creation test cases & testing scripts relating SAP modules in HPQC tool, and inter acting with users in User acceptance testing
Confidential, Milwaukee, WI
Sr. SAP Business Systems Analyst
Responsibilities:
- Participated in testing phase of Global rollout of SAP ECC 6.0 FI (New GL/AP/AR), CO (Cost Center Accounting, CO-PA), integration of SD module with FI in Overseas subsidiaries (Europe, China, and India), regression testing of Horizon Project (US implementation) for the following areas using Confidential Quality Center.
- Regression Testing: for the global roll out projects
- Employee Expense Reports (Travel Management) - Expense submission (below and above limits for travel for domestic & international, meal, books, and other expenses either by cash or through Credit Card) to their superiors through workflow emails, and its approval process through Workflow. Created user rolls and authorizations.
- External and Internal purchasing
Confidential, Auburn, IN
SAP FICO Team Lead
Responsibilities:
- Involved in New GL ECC6.0-Ledger set up as per US GAAP & Local GAAP, new documents & splitting rules, assignments, document number range, and validation rules etc., AR, and AP, Foreign Currency set up for Germany& Poland for parallel reporting, supporting in designing DME files for the Payment program in order to send them to Banks.
- Defined additional transaction types to meet the Poland local laws in Asset Accounting, and added custom sort fields in Asset accounting reports to populate the asset locations which required by the Poland Tax authorities.
- Involved in preparation of Functional design documents for all the Detailed Requirement Documents, Test Scripts for Unit testing &Testing, and tracking defects detected by the users in the integration testing through Quality Center tool & made the required corrections.
- Involved in the Cooper Bankruptcy Process (SAP - Fresh start Accounting) which includes
- Reorganization value is allocated to company’s assets consistent with accounting for business combinations All assets and liabilities must be recorded at fair value (Revaluation of all assets) Intangible assets and goodwill be recorded.
- Implemented the Chargeback process (Vistex) which includes configuration Agreement types, pricing procedures with relevant condition types, configuration of accrual and settlement profiles, configuration of message types for partner communication, and reconciliation vendor responses.
- Involved in testing the design and effectiveness of controls as per SOX compliance, documentation of internal disclosure controls and procedures, setting up workflows to send Emails to employees about accounting, internal controls, and auditing matters as follow-up information, configured the separate document type/period for material adjustments, configured automated early warning indicators, and e-mail notification support timely identification of material risks and changes in financial condition.
Confidential, Chicago, IL
Sr. SAP FICO Functional Analyst
Responsibilities:
- Creation of Planned and actual assessment & reposting cycles for cost centers, setting up batch jobs and running planned and actual assessment and reposting cycles, and running internal order settlements.
- Developed the data migration strategies for obtaining 11 years of data files from various Legacy systems, and migrated the cleansed data into SAP using various custom developed programs & LSMW tool
- Complete FIT 1, FIT 2 and FIT 3 cycle testing in preparation for go live, and provided post go live support in month end closing activities.
Confidential, Columbus, OH
Responsibilities:
- I was involved in the configuration of Project systems structure which includes defining the projects and activation of project management in Controlling area, creation of WBS elements, Networks, and activities. Defined the Validation & substitution for Project definitions, Defined fund commitments for the projects, maintained the Planning/Budget/DB profiles, configured the parameters for Network/WBS scheduling profiles.
- Order to Cash: Involved in Configuring new Company codes, Creation of GL, AR master data, configured complete collection process- setting up of House banks, Lock box with EDI setup, Configured the AR/AP payments in Payment medium Workbench (PMW), integration with SD, MM, PP, and PS with FI, interfaces with other existing legacy systems (inbound &out bound), Data conversion relating GL, AR, AP, AA, and CO data from various legacy systems to SAP systems in US, Europe, and Brazil, Creation Profit center substitution rules, Inter Company billing Process, and creation of new forms using the SAP Scripts for generating inter-company, and charity invoices.
- Conducted a peer-to-peer analysis comparing the acquiring and target companies
- Review of various functions - single help desk and a combined employee portal, value of master data for all enterprise resource planning (ERP), existing relationships of shared customers and find ways to retain those customers after the merger or acquisition, and Evaluating the overall synergy of IT systems, including the enterprise architecture, hardware, networks, data stores, technology platforms, business software, and user interfaces.
- Involved in testing the design and effectiveness of controls as per SOX compliance, documentation of internal disclosure controls and procedures.
- Involved in Creation of Master data &uploads of CCA & PCA, creation of plan & actual assessment & reposting cycles, and uploads, setting up batch jobs for actual data loads, Creation of Internal Order master data, and its settlement profiles & creation of Jobs for its settlement, and creation various reports as per business requirement using Report painter.
- Involved in European Fixed Asset Implementation relating to 8 Countries /20 company codes, and my responsibilities include fixed asset configuration, Conversions, Testing and go live support from USA using Test director.
- Involved in creation CO-PA master data, derivation rules, Profitability segments, Costing keys, Planning frame work, PA Transfer structure, assignment of GL accounts for auto post, Assigning the SD Condition Types to CO-PA Value Fields, activating transfer of billing documents to CO-PA, and creation various CO-PA reports with multiple summarization levels.
- Involved in Defining Costing Sheets, Material Cost Estimates, Costing Versions, Quantity Structures, Results Analysis Keys, Cost Elements for WIP Calculation, Posting Rules for Settling Work in Process, and periodic WIP runs, Creation of CO related Production orders, Settlement Profile & assignment of PA Transfer & allocation structures, monitoring the assessments of cost enters, and settlements of production &sale orders, analyzing discrepancies in variance, COGS/ revenue postings, and maintained summarization hierarchies/levels/object types in order to generate various CO-PC reports.
- Co-ordinate with off shore team from India and Germany as well as local ABAP resources.
- Involved in SIT, UAT, and FIT testing, and after go live support in resolving production related issues, and helping month end closing process.
Confidential, Nashville, TN
Sr. SAP FICO Functional Analyst
Responsibilities:
- Configure and implement FICO module(New GL, AR, AP, and AA)
- Integration configuration between FI-AA, MM, and SD
- Responsible for the upgrade from 4.6C to ECC 6.0 and provide Post GOLIVE support for the upgraded Production SAP system.
- Driving the IS projects to run smoothly in the Global environment with the use of best practices, good decision making.
- Involved in change management activities, Knowledge Transfer workshops, Risk management and assessments, and communication to the business user communities.
- Lead the SAP Scoping, Configuration, Upgrade and Implementation support.
- In New G/L Defined Leading and non Leading Ledgers for parallel reporting of the clients subsidiaries located in North America, Mexico, Asia, Europe, and Africa with deferent currencies as per IFRS guidelines, Defined accounting principles for IAS/US-GAAP, Local GAAP Germany (HGB), and assigned the desired ledger group to the accounting principles, Variants for Real-Time Integration to Company Codes, defined Document Number Ranges for Entry View/ General Ledger View, Document Types for Entry View in a Ledger & for General Ledger View, and assigned Scenarios to Leading and to some of non leading ledgers as per client requirement, Classified G/L Accounts, Document types for Document Splitting, Defined Document Splitting Characteristics for New G/L Accounts, defined default Profit centers by company code using FAGL3KEH tables, defined required validation rules, made settings for online integration with CO, and FI-AM, and migrated cleansed data to New GL.
- Involved in testing the design and effectiveness of controls as per SOX compliance, documentation of internal disclosure controls and procedures.
- Configured and customized SAP Asset Accounting- FI-AM which included creation of asset classes, asset master data, chart of depreciation, activated the additional posting indicators to post APC & Depreciation in New GL, assignment of FM area, defined valuation areas for parallel valuation (defining new accounting principles), settings for additional account assignment objects to account assignment types for posting APC &Depreciation values in CO, creating new Depreciation keys to calculate Depreciation as per the new laws.
- EC-CS (Consolidation): Created all consolidation related master data, hierarchies, document types, conducted the data & Consolidation monitor, and milestone tasks, and done the EC-CS Account analysis & ran revaluation and translation reports.
- I was involved in the configuration of Project systems structure which includes defining the projects, creation of WBS elements, Networks, and activities. Defined the time profiles, maintained the Planning/Budget profiles, configured the parameters for Network/WBS scheduling profiles, created the Fund Commitment items & assigning to GL account, and assignment of WBS element to projects and AUCs
- Data Conversion of AP, AR,GL, assets, and CO data from/to legacy systems located in Mexico, Germany, and Brazil by using LSMW and with Custom Programs, settlement of AUCs, retirement, transfers etc for the Mexican, and Latin American subsidiaries. Supported the users during period end close issues like depreciation runs, tax related issues etc., and worked on creating new reports for the client in FI-AM module.
- Configured and customized AR and AP modules for vendors subject to tax, interest calculations on open items & account balances, foreign exchange calculations, Configured automatic payment & dunning programs, and helped end users in running these programs, and in clearing the logs.
- Made required changes in exiting Tax Procedures, Input and Output Tax Codes, created new Jurisdiction codes, added new Tax accounts and assigned for automatic account determination, created required additional condition records & updated new pricing procedures for the new condition types, and modified Vertex interface to in corporate changes.
- Interacted with SD and MM team in the configuration for integrating SD, MM, involved in UTP, SIT, and UAT testing, preparation of work instruction manuals, and after Go-live support in month end closing process.
Confidential, DC
Sr. SAP FICO Functional Consultant (Federal)
Responsibilities:
- Worked on Treasury module implementation (Cash, Fund, Investment, and Loan management), which includes configuration, testing, conversion, and in creating user documents.
- Created Chart of Accounts (as per Federal accounting standards-Trust fund accounting)
- Fund Management: Creation of Master data like FM area, Commitment items, Fund & Fund centers, Account assignment elements, budget structure, and Derivation tool to derive FM account assignment, setting for budget planning & execution, settings for integration with GL, CO, and AA, involved in closing process, and helped generating reports.
- Implemented the Cash Management and Electronic Bank statement Functionality- incorporating customers, vendors and bank transactions, Setting of Planning levels & planning group, source symbols and its assignment, and data transfer strategies.
- Configured House banks, Bank accounts, Lock box with EDI interface, and monitoring Lock box data files before executing lock box program.
- Configured Loan management: Business Partners, Product types& categories (Contract data -Flow types, Condition Types) assignment of product type to product categories, settings for Cash flow, defined payment forms, and configured Loan Correspondence settings (documents, activities, integrated posting to the correspondence types, Dunning, collateral value determination, and reports for monitoring.)
- Involved in Testing, Data Conversion, and Demo and prototype for TR module.
Confidential, Austin, TX
Sr. SAP FICO Functional Consultant
Responsibilities:
- AP/AR: Configured, tested and documented the implementation of Vendor Down Payments process, Implemented Payment Advices for ACH vendor payments, made required changes in house banks, lock box settings to configure EDI interface for Bank file transfer through IDOCS, made the changes in Sales/Purchase tax to in corporate new jurisdiction codes, condition records, and Tax accounts. Reviewed the vertex interface, and resolved the issues involved tax calculation in SD and MM updating/checking the tax indicators in new customer/vendor/material masters, and maintained tax jurisdiction codes in new cost centers, plants, materials, Vendor & Customer masters, provided support in Inter Company transfers & billing process, added new dunning areas, dunning levels, changes in interest calculations, and made the required changes in the dunning forms as per business requirement.
- Configured the ERS-Evaluated receipt settlement functionality,3 way invoicing (LIV). tested, and helped the end users in the execution.
- Worked with Basis consultant in creating and testing authorization objects for GL, AP, AR, FM areas, and configured the work flows.
- Involved in Asset Accounting Master Data maintenance, handling acquisitions, retirements, Scrapping, Inter Company transfers, settling the Assets under Construction, posting down payments & Invoices, and in depreciation runs.
- Reviewed the existing cost & profit center reporting for client suitability and use, and created new reports as per the client requirements by using Report painter.
- Analyzed the problems involved in PCA balancing, and made the required changes in the PCA balancing custom programs.
Confidential, Dearborn, MI
SAP FICO Functional Consultant
Responsibilities:
- EC-CS Modification, and Production support to FI (GL, AR, AP, AA), CO (CCA.PCA, CO-PA) modules, and SD & MM integration related issues.
- EC-CS Modification: Analyzed, modified, and tested existing FI & EC-CS configuration to accommodate the use of a new data element called “Functional Areas” for cost of sales accounting breakdown on the P&L, modified all existing P&L reports in EC-CS for their legal and management reporting to accommodate the new method of “Functional Area”..Documented, tested and received sign off for all configuration changes to support the “Functional Area” breakdowns by cost centers on the FI/CO side and sub items on the consolidation side.
- Provided support to AP, AR, Treasury, SD, AM, MM end-users on various areas like payment terms, processing payment runs, material master, vendor master, asset master, depreciation calculation, cash management etc.
- Asset Management: Provided support to FI-AM users which included creation of asset classes, master data, chart of depreciation, acquisitions, settlement of AUCs, retirement, transfers, capital leases etc. Supported the users during period end close issues like depreciation runs, tax related issues etc for subsidiaries in different countries.
- Provided support in creation of new assessment and reposting cycles and its up loads, creation of internal orders as per business requirements and setting up batch jobs to settle them to other CO objects/AA/FI.
- Defined additional Profitability segments and its assignments, creation new characteristics and value fields as per the business need, and attending all issues relating updating of variance, COGS/revenues to CO-PA, and helping in reconciliation of CO-PA profit margin with FI figures.
- Configured new material cost estimates, made required changes in costing variants, generated new costing sheets, and provided support in periodic assessments, and settlements.
- Resolved issues involved in various inbound/outbound interfaces to GL by making required changes.
- Resolved help desk tickets with respect to various areas of FI and CO. Developed necessary process flows, documentations, change requests etc based on the requirements.
- Coordinated with various departments like engineering, accounts payable, purchasing, asset management etc to analyze various issues related to taxes calculated from Vertex and helped in documenting the process flow.
Confidential, Phoenix, AZ
SAP FICO Functional Consultant
Responsibilities:
- Worked on SAP GL/AP/AR, fixed asset accounting, CCA PCA, and MM & SD integration with FI.
- Involved in SAP upgrade from 4.6B to 4.7 which includes comparing and modifications of objects, unit & Integration testing, transport of objects, migrate existing configurations, company codes, Support during in User Acceptance testing, and Responsible for documentation and knowledge transfer to onsite team.
- Worked closely with process streams in raising FITGAPs and suggested best business practices.
- Provided Business process procedures (BPP), Business process descriptions (BPD), Functional Specifications for the RICEF (Reports, Interfaces, Conversion, Enhancements and Forms), & other FITGAP s in the present business system.
- Developed the configuration templates in Solution manager for the purpose of rollout
- Asset Accounting: Configured new depreciation areas, relevant tables, asset classes, and asset master data, capitalization process to capture costs spanning multiple years and/or multiple capital projects to plan and track costs, internal orders configuration for Capital orders through IM, book and Tax depreciation related Dep. /calculation Keys in accordance with US Tax Regulations, upload of Legacy Assets using LSMW tool, and defined reports, using Report writer and Report Painter, as per client’s requirements.
- Configured Operating and Capital lease functionality as per US GAAP requirements.
- Configured Controlling area, PCA CCA hierarchies & Master data, Planning layout, transfer pricing, defined distribution and assessment cycles, and generated reports as per client requirement.
- Supported the FI team in setting up the SAP-GL accounts, and in other SAP-FI modules like SAP- AP (Accounts Payable), payment methods, Preprocessed payables, SAP-AR (Accounts receivable)
- Involved in the process of establishing the Vertex Interface with SAP R/3 system which includes FI, SD, and MM modules. Made the required configurations, and co-ordinate with ABAP team in the development activities.
- Involved in integration of FI with SD& MM.
- Developed Test Scenarios / integration test documents and, documents.
Confidential
Independent Consultant
Responsibilities:
- Compilation, Accounting, Audit, and Financial Reporting.
- Taxation: Compilation and Filing of Federal, State, and Local Tax Returns.
- From inception stage to commissioning of Manufacturing and Trading Clients.
- Senior Auditor handling various auditing assignments.
- Quarterly and annual SEC reporting.