We provide IT Staff Augmentation Services!

Bi/hana Lead Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Extensive experience of over 18 years in SAP Project Implementation, Global Reporting, Business Process Re - engineering, Conflict Resolution and Issue Management.
  • Led and facilitated Solution Design workshops and Business Requirement gathering meetings with multi-function and multi-disciplinary participants.
  • Implemented multiple full life cycle projects using SAP industry solutions, ASAP methodology, Pre-Configured Client (PCC) and Country Versions.
  • Implemented reporting system using SAP HANA. Extracting data from various legacy and SAP systems and replicating the same in HANA. Using HANA models to report and send data to other data warehouses. Trained in S4 HANA (Simple Finance) and have an understanding of differences and additions in the new business suite.
  • Implemented special projects like Fiscal Year Change, SOX Project, Legal Consolidation Project, Functional and Technical Upgrade projects, Global template rollout projects and Support projects.
  • Bridge the gap between Finance and technology. Collaborate with Finance stakeholders and technology to translate business requirements into concrete, specific projects that drive measurable value to the organization and align with the Organization’s finance technology strategy.
  • Performed Project Management activities like creation of project plans, deciding project implementation methodology, resource planning, project scheduling and budgeting, deciding system landscape design, documenting initial requirements, determining database sizing and presenting baseline playback for proof of concept.
  • Expertise in configuring SAP Finance modules like General Ledger Accounting (New GL), Accounts Receivable and Accounts Payable, Special Purpose Ledger (SPL), Legal Consolidation (ECCS), Asset Accounting, Cost Center and Profit Center Accounting, Internal Orders, Product Costing for both make to order/stock, Revenue Recognition and Profitability Analysis (PA).
  • Experienced in integration with other SAP Feeder Modules including in-depth understanding of SD, MM and PP modules and expertise in setting up SD pricing conditions and linking pricing procedure for finance postings as also configuring MM schema and account determination.
  • Well versed in setting up New General Ledger including creation of Leading/Non-Leading ledgers, setting up special Depreciation areas for IFRS/GAAP principles, developing custom GL characteristics and setting up custom Document Splitting rules.
  • Global reporting using various reporting mediums like BIW, HANA, Spotfire, ABAP programs. In depth expertise in creating models linking various tables into views to be used to extract data or create reports to fulfill business requirements.
  • Knowledge of basic SOX rules relating to the finance function including segregation of duties for specific finance functions like accounts payable/receivable. Use of mitigating controls like summary reporting and managerial authorization to have better internal controls.
  • Expert knowledge in Techno-functional areas like designing of finance user exits including Business Transaction Events (BTE), automating Tax procedure using standard SD conditions as also integrating with third party products like Taxware/Vertex, IDOC management and use of Solution Manager for implementation and documentation.
  • Strong Managerial capabilities in handling diverse teams, good analytical and problem solving abilities and excellent communication and interpersonal skills.

PROFESSIONAL EXPERIENCE

Confidential

BI/HANA Lead

Responsibilities:

  • FI Lead responsible for the entire Accounts Payable interface, MRC Consolidation, Custom Enhancements and Production Support.
  • Lead for Fuse project implementation. Interface with Corporate LYNX AP and ARIBA systems.
  • Enhancing Custom Programs for processing for invoices and payments from corporate system, using IDOC data to post/change invoices in local SAP system, defining tables for handling errors as well as reprocessing and reporting and reconciling data between Corporate and Local systems.
  • Custom program to analyze and post differences in COGS postings to Accounting and Profitability Analysis mainly for Display materials with Sales BOM and Item category group ERLA.
  • Assisting in handling production support for product costing, profitability and overhead accounting modules.
  • Handling other enhancements not under support purview. Activities includes understanding complex production issues, determining solutions, creating Functional and Technical documentation, assisting is custom program development, unit functional and regression testing, HPQC documentation, supporting User Acceptance Testing (UAT), sending transports to production system and post production support for these enhancements.
  • Supporting FICO post production activities for issues escalated by the offshore/onshore team. Support includes solving tickets raised accounts Payable interface with LYNX system, General Ledger area including period closing, Product Costing issues, COPA posting and reconciliation tickets and other interface areas.
  • Writing validation and substitutions for profit center and segment derivation.
  • Setting IDOC partner profile, custom programs for posting invoices, credit memos and other postings.
  • Coordinating with offshore, onshore and interface teams to successfully deliver project within timelines.
  • BI/HANA Lead for Global reporting - Mexico, Brazil, Japan, Australia, US and Canada.
  • Designing HANA Models/Views for FI data extraction from various SAP and Legacy systems. Extracting master and transaction data into Teradata systems for global reporting. Leading the tax reporting initiative for various sales tax, use tax and direct tax reporting.
  • Use of reporting as control reports for PWC audit. Generating various audit control reports joining various tables, views across different modules. Compliance of FDA regulations including documentation of support tickets, managerial and internal audit authorizations and post transport testing. J&J has a very robust internal control system for moving transports from development to production environments.

Confidential

EIM Lead

Responsibilities:

  • EIM (Enterprise Information Management) Finance Team Leader responsible for Global FICO reporting.
  • Managing Functional and Technical teams for delivering Finance Reports (BW) to end users.
  • Functions include bridging the gap between Finance function and Technology, managing demand for Global Finance reporting, evaluating Business Requirements for reports, evaluating relevant technologies (ABAP/BIW or any Other Third Party tool like Spotfire) and prioritizing report requirement for the Finance stream.
  • Determining Initial Approach for report development, Preparing Functional and Technical documents including defining of requirements and other relevant Techno-Functional data, presenting multiple Approaches/Options to Business and Technical delivery team for Confirmation (PowerPoint, Visio) and suggesting enhancements to existing processes - FICO configuration.
  • Understanding and evaluating FICO configuration and existing BIW Standard Content to determine Configuration/Custom changes required for developing finance reports.
  • Determining Testing strategies, Testing scenarios and methodology and Data sets for user testing. Use of reports for developing internal controls for various finance functions.
  • Managing Post Production Support including bug fixes and Final handover to Support Team
  • Major Reports include - Product Profitability report (Determine Material Profitability and allocate non assigned cost to materials), Accounts Receivable report (Identify key A/R aging trends and risks and provide input for the Quarterly Balance Sheet Review and the Working Capital Initiative, Purchase Price Variance report ( Analyze Price variances for purchases and other transactions at various levels. Due to Exchange (DTE) and Due to Billing (DTB) amounts should be calculated and displayed using budgeted rates.

We'd love your feedback!