We provide IT Staff Augmentation Services!

Sap Hana - Fico Lead Consultant Resume

5.00/5 (Submit Your Rating)

NJ

SUMMARY

  • 21+ years of overall experience including 14 years as SAP FI - CO consultant in implementation, Rollout & conversion projects, Customization, Configuring and CO Reporting in SAP R/3, ECC 6.0 and S4 HANA Central Finance. Excellent working experience in testing, documenting, user training, support and COPA allocations and BI reporting encompassing different work environments and in diverse industries like Oil & Gas, Banking, IT Hardware & Manufacturing.
  • Experience in E2E Implementation covering Blue Printing, Fit-Gap Analysis, facilitate Design, functional specifications, preparation of test cases, training documents, Unit Testing, UAT, Cutover, Hypercare and production support projects for Fortune 500 MNC.
  • Finance Experience - GL, Accounts Payable, Accounts Receivable, Credit Management and Bank.
  • Controlling Experience - Business Allocations, Profitability Analysis, Segment-wise reporting, Cost & Profit Center Accounting.
  • Worked on a very large data conversion & migration project for Capex & Opex items.
  • Proficient in interacting wif Solution Architects & ABAP developers for finalizing right IT solutions and translating Business requirements into technical & functional specifications for custom developments, Enhancements, BAPI, Process automations and Business & Operational performance reports.
  • Worked on RICEF objects including design of complex reports and Enhancements. Drafted functional specifications providing table logic and detailed design for reports and coordinated wif technical team for development of Objects.
  • E2E Testing experience including framing Test strategy, unit testing, user acceptance testing, regression & integration testing (worked on HP-QC ALM 12.55)
  • Worked wif diverse teams across different time zones, Offshore-Onshore model wif customer 1st mindset and strong team player.
  • Project management experience including managing timelines, resources, prioritizing activities, monitoring milestones, Gantt chart analysis, PoAP, reworking project to changing project scope, timelines and resource availability, managing team issue logs &, Conducting Blueprint Workshops.
  • Certified SCRUM Master wif working experience in both AGILE & Waterfall ways of working.

TECHNICAL SKILLS

ERP System: SAPECC 6.0, MFG Pro

S/4 HANA: Finance (1809)

SAP FI Modules: General Ledger/New General Ledger/ Special Purpose Ledger, AP, AR, Asset Accounting

Controlling: Cost Element/Cost Center Accounting, Profit Center Accounting and Profitability Analysis (CO-PA) Business Allocations, Internal Reporting.

BI Reporting Tools: Power BI, Dashboard Designer

Project Management/Agile: MSVSTS

Applications: MS Word,PowerPoint, Excel

Others: HP QC(Testing), HP Service Now(Transportation requests), Balsamiq (Mock-up creation) Sharepoint 2013 (Security administration) Alteryx (Data blending)

PROFESSIONAL EXPERIENCE

Confidential, NJ

SAP HANA - FICO Lead Consultant

Responsibilities:

  • Review & capture existing reporting, gather functional/reporting requirements and analyse teh same.
  • Translate requirements to technical & functional components dat would be used for developing reports.
  • Manage teh DHT and ensure data accuracy in it.
  • Review Chart of Accounts to identify obsolete GL accounts for clean-up.
  • Ensure timely availability of COPA files and other input data for allocations and validate teh same for data accuracy.
  • Prepare training manual for adjustment entries and its impact extension ledgers and consolidation reports.
  • As SCRUM master responsible for preparation of Sprints, Backlog planning/refinement, Daily SCRUM calls & Sprint retrospective.

Confidential

SAP Fico S4 Hana Lead Consultant

Responsibilities:

  • As part of teh Blueprint team, was fully responsible for requirement gathering & analysis. Conducted interviews wif process owners and facilitated workshops wif stakeholders to gather requirements and analysed teh same to identify gaps.
  • Jointly wif Project Manager created teh Business Requirement Document for discussions wif Decision Review Board to obtain sign-off.
  • Translate teh Business requirements to technical & functional components dat was used for developing reports.
  • Adherence to Cost Data rules for master data.
  • Performed ETL to convert and migrate data from legacy.
  • Finalized penalties and additional costs for small and urgent orders wif Lubes team and worked wif technical team to automatically remove discounts for such orders.
  • Configuring Ledgers (both leading & non-leading) and extending teh Chart of Accounts to participating LE’s.
  • Set up idoc for sending data to allocation tools for Business allocations as per set rules.
  • Worked jointly to set up Ledgers, Extension Ledgers & Currencies
  • Validation of Master data upload to ensure adherence to Cost Data rules and to align wif US GAAP.
  • Activation of Material ledger
  • Set up of Asset accounting, validating master data and working wif team to migrate transactional data.
  • Worked wif BI development & technical team to develop customized Management reporting on Business Process Management, P&L and Gross Margin Analysis.
  • As SCRUM Master was responsible for preparation of Sprints, Backlog planning/refinement, Daily SCRUM calls & Sprint retrospective.
  • Prepared cutover strategy and supported cut-over activities.
  • Responsible for E2E Testing - Co-ordinate Regression & Integration testing, Perform Quality testing, Creation of UAT test scripts, maintain testing docs in HPQC, facilitate UAT, ownership of defects log, defect fixing and obtaining sign-off.
  • Review and approve transportation requests between different environments via HP Service Now
  • Documentation and End-user training.
  • Monitor Hypercare and ensure seamless handover to support team.

Confidential

Responsibilities:

  • As a key member of teh implementation team wif expertise on both legacy system and SAP, worked closely wif designing teh solution.
  • Jointly worked wif configuration team to configure Enterprise structure, basic settings for company code (Fiscal year variant, Posting Period Variant, Document types & number ranges, Document Field Status Variants, Tolerances).
  • Adopt teh design of Chart Of Accounts, Company Codes, GL Accounts, Profit Centers, Cost Centers and its hierarchies.
  • New GL environment for 1 OU - Segment reporting, Profit Center Accounting and Intercompany processes and Interfaces
  • Responsible for Transactional data migration from legacy system (Capex Bay tool) including data conversion and ETL.
  • Verified teh business-critical table record counts and all financial and controlling reports as part of several mocks and validated by business sign off.
  • Configure, test and implement various approval workflows for audit compliance.
  • Evaluate functionality changes/enhancements in upgrades and work wif technical & infrastructure to manage roll-outs.
  • Prepare, test and troubleshoot, validate implementation setups and review customer reports post migration.
  • Owned teh UAT testing and Business sign-off.
  • Owner of Data Harmonization Tool post migration.
  • Responsible for timely resolving of defects & maintaining defect log.
  • Prepared Cutover Strategy and worked wif Data migration team for master data and transactional data loads in Finance, AP, AR and Fixed Assets, Planning data.
  • Part of Hypercare team and hand-held support team for post-production support for 3 months.

Confidential

SAP FICO Consultant

Responsibilities:

  • Work wif vendors to monitor progress of L1 tickets, escalate when needed and iron out issues for timely closure.
  • Responsible for Period close and periodical reconciliation of A/P and A/R Subledgers.
  • Support Quarter close & Year end activities
  • S4 Consultant for troubleshooting day to day issues.
  • Investigate issues causing blocks in Payables/Receivables & identify teh root cause.
  • Manage changes in Credit limits and credit control
  • Support Business users for issues in submitting Plan and Latest Estimation into SAP BPC.
  • Responsible for reconciliation of plan/LE submitted numbers in BPC.
  • Evaluate functionality changes/enhancements in upgrades and work wif technical & infrastructure to manage roll-outs.
  • Assist Release Management teams and hierarchy changes from time to time.
  • Responsible for Data Rules & final reviewer of Migrations to different environments.
  • Maintenance of monthly exchange rates.
  • Analyzed and identified teh old differences in Profit center & Cost centers and worked wif respective teams to correct entries and/or write off.
  • Full owner of Downstream Business Allocation Tool dat allocates common costs every month for various plants, refineries & businesses.
  • Monitor Control M for any failures and timely escalation for resolution of issues
  • Responsible for data accuracy & timely availability of COPA files post Business allocations
  • Worked wif technical team for enhancements: Payment notifications, Account statements, dunning letters, open item list and Balance confirmations
  • Support Release management in testing including creating test scripts, performing integration and regression tests for every release in QC.
  • Assist end-users in timely submission of Plans & rolling forecast numbers in SAP BPC and resolve any issues
  • Worked wif third party vendors and end users to reduce teh number of IT tickets by training end users on troubleshooting issues.
  • Review and approve all transportation requests for teh LoB via HP Service Now.
  • Suggest process improvements and provided necessary training to end users.
  • Responsible for gathering requirements and writing teh Functional design specifications along wif tables details and logic for custom developments and enhancements and co-ordinate wif developers.
  • Support Transportation requests between various environments
  • Raise IT tickets and follow up wif respective support desk for restoration of failed applications.
  • Train local teams in creating Test-scripts.
  • Functional Site Owner (SharePoint) of web-pages dat maintains MI report related communications
  • Follow approved approvals & processes to make changes in allocations
  • Facilitate Testing window and co-ordinate User Acceptance Test for Change requests.
  • Work wif Integration teams & Vendors to fix downstream issues.
  • Responsible for year-end finance Big Bang process.

Confidential

SAP FICO Consultant

Responsibilities:

  • Responsible for requirement gathering and analysis including scheduling interviews and conducting workshops to finalize requirements.
  • Preparation of Functional Specifications and Business Requirement Document.
  • Work wif Solution architect & Designers to brainstorm and finalize solution and data model.
  • Finalize KPI’s & its definitions, create epics and user stories.
  • Creation of Sprints, sprint review and sprint retrospective, maintain project progress status in Microsoft VSTS.
  • Co-ordinate wif IT teams comprising technical team and front-end developers to ensure output meets teh business requirements.
  • As Scrum master, chair daily stand-up calls.
  • Work wif Security teams to arrive at role-based access & Interface teams to ensure all interfaces for external data source is robust.
  • Responsible for test scripts creation, defect management & maintaining testing documentation in HPQC
  • Perform Unit testing and facilitate UAT.
  • Documentation and End-user training.
  • Managed Hypercare support for 2 cycles & facilitated seamless handover to support team

Confidential

SAP FICO Consultant

Responsibilities:

  • Review & capture existing reporting, gather functional/reporting requirements and analyse teh same.
  • Review and capture technical design requirements for integration and reporting to build teh technical components of teh system.
  • Standardization of existing legacy reporting (240 reports) into 9 reports and showcase proposed solution to obtain sign-off from VP.
  • Implement Segment Security rules to enhance and protect data access wifin SAP for managed user access to sensitive data.
  • Oversee development, testing and deployment of C5 analysis reports using Dashboard designer.
  • Work wif IT teams to build an automated interface of COPA files into LUBES cubes.
  • Work wif SAP through SR to troubleshoot software and database level issues in FI modules.
  • As Project Manager responsible for timely delivery wifin agreed budgets.
  • Training end users on best practice to post entries.
  • Facilitate UAT testing & Sign-off.
  • Handled enhancements and changes.

Confidential

SAP FICO Hana Consultant.

Responsibilities:

  • Reviewed Business processes in ECC 6.0 and identified list of standard processes and transactions to be tested from teh functionally.
  • Identified and prepared teh list of all Z transaction codes and custom developments, forms, interfaces, Enhancements to be tested.
  • Performed Business process testing in FI/CO and fixed assets modules for version 6.0.
  • Configuration of reconciliation accounts and alternative reconciliation accounts.
  • Create and assign of Vendor and customer reconciliation accounts
  • Configuration of number ranges.
  • Setting up of House banks
  • Extend profit Center and Cost center settings to be consistent wif other OU’s
  • Extend chart of depreciation, Asset classes and depreciation areas depreciation methods and depreciation keys to make it consistent wif global best practices.
  • Configured Cost Center Accounting, Profit Center Accounting.
  • Configuration of COPA and Downstream Business allocation files
  • Drafted functional specifications and for reports and interfaces and worked wif developers for development of Objects.
  • Worked on Dunning Letters wif printing & Email options.
  • Worked wif BI team on providing R/3 tables for developing FI reports like ageing reports, DSO etc.
  • Preparation of UAT scripts, documentation of results, manage defect log and closure of defects.
  • Extensively worked on RICEF objects, providing teh field mappings of data base tables, design of various complex reports, interfaces, and data loads Enhancements and conversion objects for teh rollout projects of Genentech.
  • Worked on accounts receivables, Down Payments, Payment terms, Correspondence, Foreign currency valuation issues
  • User training on AP & AR entries
  • Worked on production issues in Accounts payable - Automatic payment program and payment files.

Confidential

SAP FICO Hana Consultant.

Responsibilities:

  • Owned teh PoAP for Global Commercial business
  • Gather initial high-level requirements and prepare charter
  • Assign BA’s from teh team for different projects
  • Sole interface between GC Business and different IT teams like Solution Architect, Designer, Developers, Compliance, Integration, Security, Support teams and third-party vendors.
  • Periodical update on various projects to process head
  • Review progress of projects wif IT teams
  • Facilitate and chair calls between Business and IT teams to overcome issues and smoothen project progress
  • Validating design/solutions developed by IT teams/Third Party BW Data Architects to ensure they meet teh agreed Business and performance requirements
  • Super User for SAP BW
  • Facilitated Robotics Process Automation (RPA) of daily reporting using NICE tool.
  • Explore continuous improvement of Processes and automating MI reporting dat includes identifying, facilitating and executing GB & LEAN projects theirby saving FTE.
  • Coach and Mentor 10-member team: Ensure timely and right delivery, review meetings, assist career management, performance discussions & handle underperformers.
  • Support teh Learning & Development team by facilitating Trainings on behavioural & soft skills and Resilience sessions.
  • Developed a Learning Portal for Shell Oil & Gas Downstream Business in SharePoint 2013 wif exposure to an audience of 600 FTE’s.
  • Sharepoint 2013 administrator: Functional Site Owner (FSO) for internal site wif exposure 5500 FTE’s and contractors.
  • Designed Visual Management for team and facilitated monthly tracking.

Confidential

Assistant Manager

Responsibilities:

  • Developed various reports for Balance sheet reconciliation using Hyperion Essbase
  • Developed several product-wise profitability reports using COGNOS.
  • Perform ETL of Credit Default Rate (CDR) data from legacy system into Oracle Financials.
  • Created an automated reconciliation between Sub/General ledger of Derivative products.
  • Plan off-shore Migrations by preparing training plans & co-ordinate travel plans in consultation wif Business Partners.
  • Initiated & Mentored LEAN projects to automate routine daily reports resulting in substantial savings of FTE
  • Monthly Dashboard calls wif Business Partners to understand requirements/improvements & action plans to meet teh same.

Confidential

Senior Finance Analyst

Responsibilities:

  • Quarterly Forecast & monthly outlook.
  • Monitoring & reporting performance against budgets & variance analysis.
  • Monthly Analysis of Headcount, Capex & discretionary spends.
  • Provide monthly margin, revenue assurance and cost management.
  • Contribute to team metrics & SLA deliverables by achieving stated productivity & accuracy goals on continuous basis.
  • Handle finance queries & act as Finance interface for PG group.
  • Maintenance of Baseline & incremental depreciation register.
  • Approvals for Discretionary spend, Capex & Employee expenses.
  • Weekly dashboards on Opex spend to ensure optimum usage of budgets.
  • Drive cost efficiency by conducting regular trainings to budget holders and users.

Confidential

Executive/Assistant Manager

Responsibilities:

  • Was part of teh Operations team to prepare Project Charter.
  • As part of Blue-printing, gatheird requirements for all stake holders, conducted a detailed study of existing legacy systems and performed a fit-gap analysis.
  • Compiled a list of required customizations and customized reports.
  • Worked wif implementation partners in configuring General ledger, Sub-ledgers and Costing components.
  • Configured and set up teh whole Credit Management process including credit limits and credit lock & controls.
  • Automated month-end accruals journals process
  • Worked wif development team to customize Business-wise Financials and consolidation for annual reporting and for various MIS reports to be used by Operations team.
  • Developed unapplied payment matching process for Accounts receivables.
  • Built Inter-company business process encompassing Inter-company invoicing, payments/collections, balances, netting off and reconciliation.
  • Worked wif Deutsche bank to implement an automated payment & direct debit process
  • Set up teh stock matching process to match physical and system stock every quarter.
  • End user training for logistics to updating cost-roll ups for changes in product formulas.
  • User training for Accounts team
  • Created cutover strategy and assisted implementation partners in cutover activities.
  • Post go-live support on AP, AR, Costing & Plan submission issues.

We'd love your feedback!