Sr. Sap Fico Analyst Resume
Plano, TX
SUMMARY:
- 20+ years of experience combined experience with 13+ years of SAP ECC, BPC, One Source (Sabrix) with 6 full - cycle implementations
- Scoping, planning, designing, implementing, testing and post-production support experience
- SAP BPC Expertise: SAP Business Planning and Consolidations modules full cycle experience
- SAP New GL expertise: New GL Implementation full cycle experience
- SAP CO Expertise: Costing-Based Profitability Analysis (CO-PA), Profit Center Accounting (EC-PCA), Cost Center Accounting (CO-CCA), Cost and Revenue Element Accounting (CO-CEL), Report Painter and Report Writer
- SAP FI Expertise: Enterprise Structure, Classic and New General Ledger, A/P and A/R, Bank Accounting, SD/MM Interfacing, Credit and Collection, Asset Management, Special Purpose Ledger
- Treasury Expertise: Lockbox Program, Positive Pay File, EBS, Check Deposit Procedure
- SAP/ONESOURCE Sales and Use Tax (SABRIX) Expertise: Sabrix Indirect Tax Determination application upgrade from 5.0.3.0 to 5.2.0.1 and from 5.2.0.1 to 5.5.0.0 version and Sabrix reports upgrade from 5.0.4.0 to 5.0.5.1 and Sabrix/SAP Production Support experience (Client: Confidential, Fort Worth, TX). ONESOURCE Indirect Tax Determination from 5.1.1.0 to 5.6.1, ONE SOURCE Reporting from 5.0.5.1 to 6.4 and ONESOURCE ERP Integration from 5.0.5.0B to 5.2b (Client: Confidential, TX)
- SAP/VERTEX Expertise: Vertex Q Series upgrade and implementation (Client: Confidential, Plano TX)
- SAP ChaRM, SAP Solution Manager experience
- Broad experience in ASAP Project Implementation Methodology
- Deep understanding of FICO Integration with SD, MM, HR and Project Systems
- Good working knowledge of reading and debugging ABAP code
- Good experience in BW Z and Y Queries
- Solid experience in data conversions, LSMW, IDOC, BAPI, and ALE processes
- Extensive experience in developing and supporting 3rd-Party interfaces including Hewitt, Bloomberg, AMEX Concur T&E, SeeBeyond, Siebel, Hyperion Planner, and IXOS
- HP Quality Manager and Service Manager experience
- Strong experience in training end-users in SAP FI/CO and SAP BPC modules
- Experience with Project Systems resource planning and estimation
- Strong communication, analytical and customer service skills
- Solid knowledge of Generally Accepted Accounting Principles (GAAP) and Statutory Accounting Principles and reporting requirements.
- Self-motivated with strong leadership qualities and adaptable to collaborative as well as independent work environments
- Result oriented and capable of working with minimal supervision
- Experience with leading small teams and working with IT resources working across the globe
TECHNICAL SKILLS:
SAP BPC: Version 10.1 for SAP NetWeaver
ERP Package: SAP R/3 (FI, CO) version 4.0B, 4.5B, 4.6b 4.6c, 4.70, and ECC 6.0
Sales and Use Tax: Vertex Q Series, Quantum Reports and ONESOURCE (Formerly Sabrix) Sales and Use Tax
Databases Excel, Access, SQL Server 2000, Lotus Notes
Operating Systems: DOS, Windows 95/98/NT/2000/Millenium/XP/Vista/Windows 7
Imaging Software: IXOS
Documentation Software: RWD INFOPAK, Caliber, Star Team
Transports Management Tool: RevTrac, SAP ChaRM Solution Manager
Incident Management Tool: Peregrine, Star Team, HP Service Manager, Remedy
Testing: Test Director, Mercury Quality Center, HPQC
Job and Event Automation Software: UC4, Redwood, Control-M
Time Management: SAP Project Systems, Primavera TeamPlay Proficient in MS Office, Project, and Visio
PROFESSIONAL EXPERIENCE:
Confidential, Plano, TX
Sr. SAP FICO Analyst
Responsibilities:
- Work with the implementation partner resources for creating functional and technical design documents
- Present daily status reports to the IT management and business stakeholders
- Create Static and Dynamic reports and input schedules as per the report samples provided by business users
- Create multiple reports in a worksheet and multiple reports on the same sheet for easy comparison with data from different models
- Unit test reports and input forms and set up Options settings as per the implementation partner and TI standards for ready to use in SIT and UAT cycles
- Create and update Cost Org, Profit Center Org, and Account Dimensions and corresponding properties in Web Admin
- Create Member Formulas and Business Rules in Web Admin
- Analyze the logic scripts created by implementation partner and advise any needed updates
- Customize the reports and input schedules to different models as per the defined dimensions for each model
- Verify master data and transaction data loads are working correctly
- Set up Owner properties for BPC Secured dimensions
- Update Version dimension for planning cycles
- Configure Change Work Status settings and test the functionality
- Create and release transports for moving objects to different system environments
- Run Data Manager Packages to transfer, copy data from source members to target members
- Troubleshoot issues by analyzing DM status logs in BPC and UJFS in the backend
- Review Transformation and Conversion files and advise changes to the technical team
- Complete data sanity checks by comparing data in different system sources including ECC, BW, and BPC info providers
- Analyze existing Member Formulas and Business Rules and make changes for fixing issues
- Coordinate project deliverables with the implementation partner and offshore resources
- Create testing scenarios in HPQC for SIT and UAT cycles
- Successfully complete SIT scenarios for all the reports, input schedules, and DM packages
- Log HPQC defects and work with developers and business users for mitigation of defects
- Work with the business users for completion of UAT cycles and successful testing sign-offs
- Document all the Business Readiness items and coordinate with the Change Manager for communicating to the business users
- Assist the training team in creating user training and reference materials
- Assist the power users in training other business users
- Analyze BPC systems logs for troubleshooting various issues identified during testing and post go-live
- Work on HPQC defects and Stars tickets for fixing issues with reports, input forms and DM packages
- Analyze BPC user security profiles and work with the SAP Security team for making changes to the Data Access and task Profiles changes for fixing security related issues
- Work on after go-live issues and support business for successful period closes
- Create test cases and execute test cases to validate business processes across SAP General Ledger, Sales and Procurement areas
- Help the business users to validate canned and custom ONESOURCE tax reports and ensure the it meets the tax departments analysis requirements
- Perform Unit, System Integration and Regression testing using HP Quality Center tool
- Troubleshoot the defects and help in the resolution of any broken functionality
- Conduct As-Is and To-Be sessions with the Receivables and Finance stakeholders
- Determine the configuration changes needed for the new Shipping and Handling charges Condition Types
- Create functional design document
- Update the Sales and Distribution and Finance configuration including new account keys, assign account keys to condition type records and update default account assignments and pricing procedure for new condition types
- Set up default CO account assignment for the shipping and handling charges
- Create new GL accounts, Cost elements, and customer
- Create a prototype and provide demonstration to the business stakeholders
- Create and execute HP Quality Center test cases for SIT and UAT
- Verify SD postings are flowing correctly to FI documents and reporting
- Validate sales documents posted with the new shipping and handling charges are going through the ONESOURCE Tax Determination engine and tax calculations are correct
- Work closely with the B2B and SD teams, and offshore development team for making all the code changes and perform Unit, System Integration and Regression testing
- Work with business power users for User Acceptance Testing and sign-offs
- Provide post go-live support and provide resolution resolve production issues
- Actively participate in As-Is and To-Be workshops
- Assist with business blueprinting sessions
- Create functional design documents
- Configure document splitting rules
- Assist the solution architect in line items and GL balance migrations
- Configure FAGL3KEH default account assignments
- Create new substitution rules and update the existing rules to override Profit center data input for new GL
- Update month-end jobs for new GL and foreign currency valuation and translation programs
- Create new posting period variants for statutory postings
- Update the configuration settings for the archiving program and test the NEW GL table objects can be archived without issues and update the archiving jobs accordingly
- Validate Data Retention Tool (DART) functionality is working correctly
- Work with the CONCUR AMEX support team to updating and testing interface settings for new GL changes
- Test and fix issues with GL outbound and inbound interfaces due to the upgrade
- Validate Leading Ledger (GAAP), IFRS and Statutory ledgers by running standard/custom new GL Balance Sheet, P&L, Trail Balance and Line Item reports and doing GCAC comparisons
- Validate GL, AP, AR, Sales and Distribution, Procurement postings, inbound and outbound interfaces with sales and use tax relevant and non-tax relevant postings to ensure that tax functionality is not impacted
- Test AR/AP manual JE Reclass program and GR/IR clearing program is working correctly
- Validate AR/AP document splitting functionality is working correctly for AR/AP invoices and payment documents
- Validate new Foreign Currency valuation and translation programs are working correctly
- Verify direct postings for statutory asset reporting is working correctly
- Validate the asset depreciation program is working correctly after the upgrade
- Create and run HPQC test cases for Unit, System Integration, Regression and UAT cycles
- Assist with UAT session and work with the super users for stakeholder sign-offs
- SAP GL: Ensure Foreign Currency Valuation and Translation Month-end close processes and profit center substitution for intercompany transactions, PCA Push for payables and receivables and Material Ledger Reconciliation, Copy GL Account Master Data program RFBISA10, Intercompany invoices print program, and standard code to assign profit center based on the defaults maintained in 3KEH settings for intercompany transactions are working correctly.
- SAP ECC/ONESOURCE Indirect Tax Determination (Sabrix): Ensure that ECC/ONESOURCE interface and ECC tax user exit for determining the correct custom attributes and freight and tax codes, core mode for checking the length of external tax jurisdiction code for the field Site, Tax Functional modules EXTERNAL TAX DOC DISPLAY, EXTERNAL TAX DOC CREATE BSET, MRM FI DOCUMENT CHECK, K ABC WORKDAYS FOR PERIODS GET working without any impact.
- SAP Accounts Payables: Verify Automatic Calculate tax indicator is getting populated for EDI and web invoices, Core mod for freight limit calculation, the tax code determination for consignment purchases is occurring at the time of consignment settlement MRKO, Core mod for adding a cover letter for foreign payments in Payment Program, vendor master data ALE functionality is working, central bank indicator is populating correctly on invoices and payments for Germany, Document date and amount no more a criteria for duplicate invoice check in MIRO and FB60, Account group based authorization is not broken.
- SAP Accounts Receivables: Validate that Posting date correctly defaulting on the intercompany AR and AP documents, currency and profit center determination is working correctly for the sample orders (ZS Type) when sending plant, and customer account statement retrieval program after data is archived is working without issues.
- SAP Fixed Assets: Ensure that the depreciation start date for Period Control rule (Pro rata temporis) in a company code is set according to the start date of the FI posting period instead of the start date of the half period depending on the capitalization date for the assets is populated, and core mod for Site field validation is turned, a call to Sabrix external system is not kicked off.
- SAP Cost Center Accounting: Ensure Cost center line item reports are working correctly, all the receiver fields are available for use in KSU5, CATS time sheet data is flowing correctly to CO, core mode to feed CATS overhead and labor to CO are working as before.
- SAP Profit Center Accounting: Ensure that correct reference document number (MM document number not the accounting document number) is getting populated and custom fields in PCA tables BFOD A and BFOK A are appearing correctly.
- SAP Internal Orders: Order settlement process is working without any impact, the line items reports are not impacted and additional fields are available for display, internal order tables can be queried with the external internal order number, and additional fields are available for display in the internal order line item report.
- SAP EDI: Tax code determination based on the account assignment for Web and EBP invoice idocs, execution of BALE unless an IDOC number or a logical message type for the selection criteria, EDI idoc functionality is working correctly for CREMEM invoices.
- SAP ECC/Outbound/Inbound Interfaces: Made sure that there are no failures for the ECC interfaces and there are no upstream/downstream impacts.
Confidential, Fort Worth, TX
Sr. SAP FICO /Sabrix Tax Analyst
Responsibilities:
- Conduct As-Is and To-Be study and requirements gathering workshops
- Assist the project manager in creating the project deliverable documentation and acquiring stakeholder sign-off
- Collaborated with the SAP SD, MM and Basis teams and business process owners for testing requirements gathering
- Create and executed Test Plans in HP QC for integration and regression cycles
- Conduct Sabrix Workbench testing scenarios for consistency with ECC results
- Validate Sabrix Tax Engine and SAP integration reports
- Collaborate with the Sabrix provides for simplifying the Sabrix TE logic to reducing the cost of maintenance for these rules
- Improve the system performance by correcting product and product mappings and implementing Sabrix best practices
- Conduct User training workshops
- Use ASAP methodology for the deliverables
- Validate the RFC connections between SAP and Sabrix
Confidential, Plano, TX
Sr. FICO Configuration Analyst
Responsibilities:
- Resolve break-fix items for Financial Accounting and Controlling areas and integrating with SAP Sales and Distribution, Project Systems, Direct and Indirect Procurement and Freight functionality
- Maintain COPA characteristic values, Product and Business Performance hierarchies on monthly basis
- Provide maintenance support for 25 outbound and inbound interfaces related General Ledger, Internal Orders, and Cost Center Accounting related. Mapics, Bloomberg, Quantum, Hewitt, EOS, POLR, Oracle, and Peoplesoft
- Monitor Idoc queues, edit and reprocess the failed idocs
- Assisted CRM team by providing COPA data for troubleshooting, editing, and reprocessing of CRM Bdocs failures
- Support timely close of books during Monthly, Quarterly and Yearly-End closes
- Assist other IT teams as needed during production downs
- Implement mass change of 1.5 million internal order master data records using LSMW functionality when an interface glitch created duplicate records in the system
- Work on continuous improvement efforts for reducing creation of break-fix tickets
- Find ways to reduce dependence on various monthly maintenances resulting in lower cost of ownership for the organization
- Set up new and maintain exiting Control-M jobs
- Assist with the implementation of Change Management (ChaRM) functionality of SAP Solution Manager for transporting and managing the changes
- Create and execute test cases for SIT, Regression and UAT in Mercury Quality Center
- Work closely with the Data Management Organization in maintaining the GL cross reference tables
Confidential, Plano, TX
Sr. FICO Consultant
Responsibilities:
- Document As-Is and To-be process
- Conduct a fit-gap analysis
- Simplify the process by designing a new clearing account based process from the existing employee/vendor based process
- Coordinate HR master data weekly feeds to Concur with the HR Payroll team
- Work with the HR team for updating the Concur/HR table, and HR/CONCUR outbound interface for employees
- Design BAPI processes accounting document posting
- Design system for booking Credit Card, Out-of-Pocket expenses and workflow for T&E expenses
- Work closely with the power users for finalizing SAP G/L posting flow and clearing process for T&E expenses
- Update UC4 jobs HR feeds to capture Midwest and southwest employees
- Work with SAP ABAP and Middleware team in developing the inbound interface
- Configure new SAP House Banks for T&E vendor payments
- Work closely with 3rd Party Vendors, CONCUR technical team, American Express, Chase, and Wells Fargo for developing outbound interfaces
- Prepare project documentation and test scripts and facilitate power user sign-off
- Conduct and execute test scenarios for Unit, SIT, and Regression test
- Assist the power users in UAT sessions and sign-offs
- Train the business users in the new process
- Work with business primes in documenting the requirements
- Identify the required SAP configuration settings, forms, reports and interfaces needed to be changed for the new brand and create design document
- Configure the company, company codes, chart of accounts fiscal year variant, credit control areas, controlling area, operating concern, Cost center and profit center hierarchies in the SAP finance and HR box to align with the new Brand
- Update COPA reports to align with the new brand
- Work with ABAP team for updating SAPscripts and Streaserve for Corp logos on checks and remittance advices
- Create test cases and execute Unit, SIT, and Regression testing
- Provide post go-live support for break-fix incidents
- Work closely with business primes for requirement gathering
- Attend and document As-Is and To-Be study and Fit-Gap Analysis
- Prepare design documents for separating full FI/CO components for 4 company codes and move configuration, master data, and balances to the new system
- Design the process for disconnecting ALE processes from Master Data Repository System for Material Masters, Vendor Masters, G/L accounts, Cost elements, Cost Centers, Account Groups, Activity Types, and Profit centers
- Work with ABAP team for creating new workflows for Material Master, Vendor Masters, G/L accounts, Cost elements, Cost Centers, Account Groups, Activity Types, and Profit center master creation in the source system
- Configure company codes, chart of accounts, credit control areas, fiscal year variant, posting period variant, and field status variants, global company codes, tolerances and number ranges
- Configure settings for inter-company postings and payments
- Set up customer/vendor credit control customization
- Configure tolerance limits for employees, vendors, customer and G/L accounts
- Consolidate reporting of brought-over company codes with the existing company codes
- Set up automatic payment program for vendors
- Modify SAP settings for the Dun & Bradstreet interface to validate and creating vendor masters in the new system
- Work with Chase bank for setting up and testing the Lockbox and Positive Pay file processes for the new company codes
- Coordinate master data conversion activities with the master data team
- Upload G/L accounts, vendor masters, cost centers and asset masters in the new system using LSMW and consolidate with the existing master data
- Configure chart of depreciation, and depreciation area, and G/L integration settings for transferring legacy asset data
- Configure controlling area, operating concern, cost center hierarchy, and number ranges for CO documents
- Work with ABAP team for modifying Bank interfaces for the new company codes
- Configure material master, vendor master and customer master number ranges in the new system as a carry over from Master Data Repository System
- Transfer remaining asset values and useful life to the new system and consolidate with the existing company codes
- Configure new company codes, chart of accounts, credit control areas, fiscal year variant, posting period variant, and field status variants, global company codes, tolerances, nmber ranges, controlling area, cost and profit center hierarchies, profit centers, and cost centers in the HR Payroll box for the employees transferred due to separation of the entity
- Ensure FI/HR integration is working and employee income and expenses flowing to correct GL accounts
- Prepare test scripts and execute test cases and work with business users for UAT sign-off
- Prepare functional specifications for the upgrade activities
- Document business processes, reports, forms, interfaces and enhancements that will be affected
- Create new settings for Dun and Bradstreet interface to due to the compatibility issues
- Work with ABAP team for implementing code changes for affected process and interfaces
- Perform integration testing to ensure that business functionality is not impacted
- Coordinate SIT and UAT with other IT team and power users
- Document process changes and train business owners
- Provide post go-live production support for resolve break-fixes
Confidential, Nashville, TN
Sr. FICO Consultant
Responsibilities:
- Create 4 new validation and substitution rules
- Work with ABPA team for creating expense funds receipts reclass program
- Set up Customer Master Records, Client Specific Terms of Payment, Employee and Customer Tolerances, Interest Calculation, and Dunning Program settings
- Configure vendor master data for A/P, credit control area settings for Recurring Entries and Automatic Payment Program
- Create primary and secondary cost elements, cost element groups, cost centers and activity types
- Configure and customize SAP Lockbox Program for inter-company postings and miscellaneous receipts postings for 16 Lockboxes with BAI2 format
- Work closely with Bank of America customer support lockbox interface
- Configure House Banks and Bank Clearing Accounts
- Work with ABAP team for Integrating lockbox program with IXOS software for triggering the workflow for on-account and unapplied items and capturing and storing the check images
- Work with the ABAP team and CTT team for integrating lockbox program with Cash Tracking Tool (CTT ) for capturing real time snap shot of company’s cash position
- Create new functional specs for gaps and new user requirements
- Create variants for user-specific reporting requirements and set up run schedules
- Create Configuration Design Documents, Business Process Procedures (BPPs) and training materials using Infopak software
- Assist power users in defining document flows, authority level and relevant access mechanism and process checks and validations
- Create prototype and demonstrate to Super Users and Process Owners
- Create test scripts and execute testing scenarios for Unit and SIT cycles
- Conduct UAT training sessions and facilitate user sign-offs
- Trouble-shoot issues and provide post Go-Live support
Confidential, Edison, NJ
SAP FICO Trainee/Trainer/Consultant
Responsibilities:
- Create training materials for various clients for SAP FICO business processes provide training to new SAP FICO trainees and client users
- Assist in-house ABAP team in break-fixes for code changes to FICO business processes
- Create test scripts and assist the testing team in executing test cases
