Bpc Lead Consolidation Consultant Resume
SUMMARY:
- Dedicated and detail - oriented SAP Financial Professional with significant consultative and business experience in financial accounting, consolidation, planning and budgeting.
- Certified SAP FI-CO and SEM, and trained S/4 HANA Finance, and BPC Consultant with over 20 years SAP implementation experience.
- Track record of leading or participating in multiple SAP implementations, including SAP BPC, SEM-BCS, SEM-BPS, FI/CO, and ECC Budgeting and Planning.
- Analytical and organized, a skilled natural leader that drives organizational excellence by developing and implementing positive changes.
- Comfortable operating at any level of an organization and easily develops and maintains the support and respect of a solid network of internal and external associates.
- Articulate and persuasive in handling management, peers, staff, and vendors with experience in participating in pre-sales calls.
- Certified Public Accountant with excellent negotiation, presentation, and interpersonal skills.
- Superior communication proficiency, both oral and written.
- Solution design, configuration, and unit testing, and deployment of Business Planning and Consolidation (BPC)
- Strong knowledge of integration points between FI-CO, and BI/BW and Business Planning and Consolidation
- Excellent knowledge of SAP BI/BW data modeling related to BPC, and BW-Integrated Planning
- Training and expert knowledge in BPC Netweaver version (Embedded and Standard).
- Training and expert knowledge in SAP S/4 HANA Finance
- Strong knowledge of integration points between FI-CO and HR, Payroll, Travel Management, MM, SD, BI, PS and other SAP ECC modules
- Solution design, configuration and unit testing of FI-GL (including New GL), Asset Accounting, Accounts Receivable, Accounts Payable, Travel Management, Special Ledger, Profit Center Accounting, Cost Center Accounting, Internal Orders, Project Systems Report Writer, Report Painter, and BI queries.
- Global Implementation; preparing and conducting business process workshops and preparing global and local templates design for companies in several countries, including South American, Asia, and European countries.
- Excellent knowledge of New General Ledger: Parallel ledgers, Document splitting, Intercompany Transactions, and Segments,
- SAP Upgrade experience including New General Ledger, FI/CO, and SAP BPC
- Team Lead and project management experience with strong knowledge of ASAP methodology and Solution Manager
- Knowledge of Financial Statement Planning (Income Statement, Balance Sheet, and Cash flow) Capital Budgets, Cost Center Planning, Profit Center Planning, and Internal Order Planning
- Knowledge of International Financial Reporting Standards vs. US GGAP vs. Canadian GAAP
PROFESSIONAL EXPERIENCE:
Confidential
BPC Lead Consolidation Consultant
Responsibilities:
- Conducted blueprint requirement gathering and design workshops
- Collaborated with BW team lead to architecture and design consolidation solution
- Collaborated with S4 Finance team lead to ensure S4 HANA configuration is tightly integrated with BPC
- Designed and developed BPC data models and data flow
- Developed and Managed project plan
- Manage a team of 5 resources (onshore and offshore)
- Responsible for coordinating work stream activities
- Configuration and unit testing of Consolidation Business rules, Currency Translation, Eliminations and Journal Entries
- Developed BPC Business Process Flows and Work Status to support consolidation processes
- Created BW Info Objects and attributes
- Created HANA calculation views
- Configured model, dimensions, members, and properties, business rules and other objects
- Designed and Configured reports
- Prepared Confidential
- Identified business process issues and made recommendations for improvements
- Implemented best practices for BPC planning and Consolidation modules.
Confidential
BPC Solution/FICO Solution Consultant
Responsibilities:
- Conducted blueprint requirement gathering and design workshops
- Collaborated with BW team lead to architecture and design consolidation solution
- Collaborated with FICO team lead to ensure FICO configuration is tightly integrated with BPC
- Designed and developed BPC data models and data flow
- Developed project plan
- Responsible for coordinating work stream activities
- Configuration and unit testing of Consolidation Business rules, Currency Translation, Eliminations and Journal Entries
- Developed BPC Business Process Flows and Work Status to support consolidation processes
- Configured model, dimensions, members, and properties, business rules and other objects
- Configured security settings and data access profiles
- Configured conversion and transformation rules for data upload into BPC
- Developed reports for internal and external reporting purposes
- Designed and Configured Revenue, Product, and Expense, planning models.
- Designed and configured reports
- Prepared Confidential
- Provided post implementation support
- Participated in HANA BW upgrade project
- Participating in scoping and planning of S/4 HANA upgrade deployment
- Identified business process issues and made recommendations for improvements
- Implemented best practices for BPC planning and Consolidation modules.
Confidential
BPC Lead Consultant
Responsibilities:
- Conducted blueprint requirement gathering and design workshops
- Collaborated with BW team lead to architecture and design consolidation solution
- Collaborated with FICO team lead to ensure FICO configuration is tightly integrated with BPC
- Developed BPC data model and data flow
- Developed project plan
- Manage a team of 4 resources (onshore and offshore)
- Responsible for coordinating work stream activities with onshore and offshore resources
- Configuration and unit testing of Consolidation Business rules, Currency Translation, Eliminations and Journal Entries
- Developed BPC Business Process Flows and Work Status to support consolidation processes
- Configured model, dimensions, members, and properties, business rules and other objects
- Configured security settings and data access profiles
- Configured conversion and transformation rules for data upload into BPC
- Developed reports for internal and external reporting purposes
- Prepared Confidential
- Designed ad provided solution for complex consolidation process relating Joint Ventures, Proportionate and Equity accounting.
- Provided recommendation to streamline consolidation and month-end close.
Confidential
SAP BPC Lead Consultant
Responsibilities:
- Conducted blueprint requirement gathering and solution design workshops
- Collaborated with BW Lead to architecture and design BPC:
- Developed BPC Data Model and Data Flow for HC, FTE and labor cost planning
- Configured BPC: Dimensions, Models, BPF, Comments, and Reports, Input schedules to validate and confirm solution design.
- Created BPC system Deliverables
- Responsible for documenting SAP BPC business rules and logic scripts as required
- Responsible for creating training and system documentation deliverables
- Responsible for creating input templates and reports.
- Responsible for coaching junior BPC consultants
Confidential
SAP BPC Consultant
Responsibilities:
- Provided logic script support; maintain existing logic as result of business rule changes or process updates. Created new script logic as result of business rule changes or new requirements
- Created and maintain file for subsequent conversion and transformation
- Provided consulting for new security rules implementation, best practices for security setup, etc.
- Prepared Confidential and End User Training document
- Provided Consulting/training for complex report/input templates creation, best practices for creation, etc.
- Provided Consulting for master data maintenance and structure modification (dimension, properties, members, etc.).
- General consultation on various matters related to the application set including potential software upgrades
- Provided production support, including break fixes
- Improvement in planning solutions
Confidential, Denver, Colorado
BPC Consultant
Responsibilities:
- Reviewed existing FI/CO configuration tight integration between FI/CO and BPC for Consolidation reporting
- Reviewed existing FI/CO and Consolidation business processes and configuration
- Modified existing FI/CO and consolidation configuration to conform to SAP Best Practices
- Configuration and unit testing of Consolidation Business rules, Currency Translation, Eliminations and Journal Entries
- Developed BPC Business Process Flows and Work Status to support consolidation processes
- Configured model, dimensions, members, and properties,
- Configured security settings and data access profiles
- Configured conversion and transformation rules for data upload into BPC
- Developed reports for financial board packages
- Prepared Confidential and End User Training document
- Provided Post production support, including break fixes
- Recommend ways to improve financial month-end close
Confidential, Buffalo, New York
SAP FI/CO Team Lead Consultant
Responsibilities:
- Managed a team of three business analysts and one functional consultant to deliver FI/CO solution.
- Solution design and configuration for the following modules: FI-GL, Accounts Receivable, Logistic Invoice Verification, FI-Accounts Payable, Fixed Assets, Banking, Project Systems, Travel Management, Sales Tax, and Profitability Analysis, and Consolidation (EC-CS)
- Conducted scoping and planning.
- Organized and conducted business requirement and design workshop
- Reviewed existing FI/CO business processes and configuration and make recommendations for process improvement and system re-design
- Prepared project plan for FI/CO work stream
- Managed and coordinated FI/CO project deliverables including, RICEFW, Traceability Matrix, and Test Plans
- Worked with SD and MM team lead to ensure system is integrated according SAP Best Practices
- Provided end user training
- Provided Post production support, including break fixes
- Identified areas for process improvement and re-configured system to simplify the financial reporting processes.
- Recommended best practices for developing project deliverables and documentation
Confidential, New York, New York
SAP FI/CO/BPC Consultant
Responsibilities:
- Provided functional and business knowledge to facilitate migration to BPC 7.5
- Provided FI/CO and BPC knowledge for retracting cost center budget and plans back to SAP ERP 6.0
- Assisted in developing data and process scenarios mapping between BPS an BPC for compliance
- Collaborated with technical BW consultant to developed and design BW 7.0 ETL from BPS Info cube to BPC 7.0 application cube and BPC to other to BW reporting cubes
- Developed input templates and schedules using Evader
- Assisted with creation and execution of integration test plans
- Created RICRFW deliverables and other project documentations
- Provided General FI/CO production support
- Provided cost centre and revenue planning functional expertise for migration from BPS to BPC
Confidential
Senior SAP ERP Financial Consultant
Responsibilities:
- Participated in implementation of SAP BOBJ financial reporting tools: Configured SAP Financial Consolidation for QA testing. Created and executed test script and test plans.
- Obtained a thorough understanding of BMO financial reporting business processes
- Obtained thorough understanding of BMO financial reporting system landscape, including inbound and outbound interface
- Liaised between core SAP development team and BMO Technology team.
- Conducted BOBJ FC knowledge transfer session to QA users and IBM team
- Provided SAP Expertise to assist client with multi-year road map
- Obtained thorough understanding of SAP BOBJ Financial Consolidation
- Configured Financial Consolidation system for QA testing environment
Confidential
FICO/SAP Banking Analyst
Responsibilities:
- Responsible for unit and integration testing for the following functional areas; FI/CO, AR, Loans Management, and Collateral Banking Services modules.
- Created test scripts and test plans utilizing QC testing tools.
- Prepared business process flows
- Collaborated with business process owners to develop and test SAP roles and security profiles
- Provided functional expertise with respect to FI-GL, AR and AP
- Prepared key deliverables including, configuration unit/integration testing, and project documentation such as Confidential, Traceability Matrix, and Test Plans.
- Provided input to streamline project methodology
- Identified business process issues and made suggestions for improvements
Confidential, Atlanta, GA
Senior FI-CO/BPC Consolidation Consultant
Responsibilities:
- Participated in SEM-BCS migration to BPC NW 7 blueprint workshop
- Configured/Tested Consolidation Business rules, Currency Translation, eliminations and Journal Entries
- Leveraged dynamic templates in Appshell to create input schedules and EvDRE reports
- Created test plans and test scripts and performed unit and integration testing
- Collaborated with ABAB developers to resolve break fixes and defects
- Provided FI/CO/BPC expertise to super users and end-users.
- Conducted and directed user acceptance testing workshop
- Prepared key deliverables including, configuration unit/integration testing, and project documentation such as Confidential, Traceability Matrix, and Test Plans.
- Provided functional expertise with respect to New General Ledger vs. Classic General Ledger, Special Ledger, and New Depreciation Calculation for fixed assets, Foreign Currency Translation (Parallel Currencies), Intercompany Transactions,
- Provided Post Production support including break fixes.
- Successfully completed project on time and within budget.
- Provided expert consolidation and Planning functional and business knowledge
- Resolved issues relating to FI-GL multi-currency translation
Confidential, Detroit, Michigan
Senior FI-CO
Responsibilities:
- Analyzed FI/CO and EC-CS design and recommended changes to ensure FI and consolidation systems met US, Canadian, and German HGB GAAP reporting requirements.
- Designed and configured Special Ledger, PCA, and EC-CS systems for consolidated plan, budget and forecasting versions.
- Ensured FI-GL and Profit center modules are configured correctly for integration with business consolidation tool for both plan and actual data
- Re-configured inter-company, currency translation, elimination of investment tasks.
- Configured FI/CO to satisfy and segment and management reporting.
- Modified currency translation method in FI-GL to correctly translate group currency in the general ledger.
- Liaised with BI team to ensure reports are Designed and configured to meet the business requirements
- Prepared key implementation phase deliverables including, configuration unit/integration testing, and project documentation such as Confidential, Traceability Matrix, and Test Plans.
- Provided Post Production support including break fixes
- Successfully completed project on time and within budget.
- Streamlined currency translation process
- Streamlined Intercompany matching process
- Developed workaround solutions for standard inter-company elimination of investment and consolidated plan and budget versions.
Confidential, Atlanta, Georgia
Senior SEM-BCS Consultant
Responsibilities:
- . Utilized FI/CO expertise to help with consolidation and financial reporting for SEM-BCS.
- Oversaw integration of FI/CO with SEM-BCS reporting solutions.
- Provided expertise and overview of current SAP consolidation model.
- Organized, Led and Conducted requirements gathering and blueprint workshops.
- Confirmed business process requirements with subject matter experts.
- Performed fit gap analysis and assisted in developing project plan.
- Developed practices to optimize functionality to conform to Sarbanes-Oxley requirements.
- Collaborated with BW team to activate business content and to determine data source for consolidation system; developed InfoCube and consolidation data model.
- Design and configured system to handle standard consolidation functions including automatic elimination of investment, minority interest, re-classification, and inter-company elimination.
- Assisted in designing and creating BW query reports.
- Created test scripts and performed unit and integration testing.
- Developed reporting interface for submission to Corporate Hyperion Consolidation tool
- Managed Project Plan including reviewing and preparing blueprint and implementation phase deliverables such as configuration unit/integration testing, RICEFW and other project documentation.
- Provided Post implementation support
- Implemented system on time and within budget.
- Improved accuracy and transparency between SAP R/3 and Consolidation system by simplifying consolidation processes.
- Enhanced timely and accurate reporting between SAP consolidation system and Corporate Hyperion system.
Confidential, Arlington, Virginia
Senior SEM-BCS Consultant
Responsibilities:
- Responsible for FI-GL, Special Ledger, and Consolidation modules
- Prepared Global and local FI/CO templates for companies in North America, South America and Europe.
- Gathered requirements, led blueprint workshops and reviewed business process requirements with subject matter experts; performed unit and integration testing.
- Participated in design and integration with FI/CO modules (GL, CCA, PCA, I/O and Asset Accounting) such as trading partners, profit centers, transaction types, Global operational chart of Accounts, Consolidation/Group chart of Accounts, document splitting, intercompany transactions
- Provided Expertise in Foreign Currency translation methods in accordance with Generally Accepted Accounting Principles
- Reviewed and prepared project plan, blueprint and deliverables.
- Collaborated with BW team to activate business content and to determine data source for consolidation and planning systems.
- Created InfoCube and consolidation data model; performed fit gap analysis.
- Design and configured system to handle standard consolidation functions including automatic elimination of investment, minority interest, re-classification, and inter-company elimination.
- Assisted in designing and creating BW query reports.
- Created test scripts and performed unit and integration testing.
- Provided expertise to super user and end-users and post-production support
- Other roles included preparation of key implementation phase deliverables including, configuration unit/integration testing, and project documentation such as Confidential, Traceability Matrix, and Test Plans.
- Prepared Global and Local templates for corporate wide ERP system rollout.
Confidential, Houston, Texas
Senior FI/CO- Consolidation and Planning Consultant
Responsibilities:
- Developed high-level road map and options for implementing SAP BPC (OutlookSoft).
- Organized and led high-level requirement gathering Workshops for consolidation and planning business processes.
- Developed BPC Consolidation prototype and translated business requirement into consolidation design.
- Configured system to demonstrate consolidation functional requirements
- Configured the following: Application sets, Dimensions, Load and Validate data, Business Process flows, Reports and input schedules, EvDRE reports, etc.
- Analyzed current SAP current FI/CO design and recommended changes to ensure tight integration with SAP BPC (OutlookSoft).
- Presented an overview of current SAP consolidation and Planning model; EC-CS, SEM-BCS, SAP BPC (Outlook Soft)
- Compared and evaluated SEM-BCS, Hyperion and SAP BPC (Outlook Soft) consolidation tools
- Assisted in developing business case for implementing consolidation and reporting tool.
- Developed consolidation demo scripts, evaluation criteria, and inputs for business case.
- Presented client with informed data to select BPC Outlooksoft as the selected Planning and Consolidation tool.
- Recommended new processes for simplifying monthly consolidation, monthly forecast and annual consolidated budgets.
Confidential, Atlanta, Georgia
Senior FI-CO Consultant
Responsibilities:
- Served as subject matter expert on Fixed Assets, General Ledger, Accounts Receivable, Accounts Payable, Cost Center Accounting, Profit Center Asset Accounting, Internal Orders, R/3 Planning and Budgeting
- Designed and configured Fixed Asset Accounting, Profit Center Accounting, Cost Center Accounting
- Organized and directed requirements gathering and blueprint workshops. Created Global and Local templates for subsequent rollout to other entities.
- Confirmed business process requirements with subject matter experts.
- Prepared key deliverables including project plan, configuration unit/integration testing, and project documentation such as Confidential, Traceability Matrix, and Test Plans.
- Project completed successfully on time and within budget.
- Simplified capital budgeting, internal order, fixed assets and profit center processes.