647-***-**** admi28@r.postjobfree.com linkedin.com/in/ajomon-isac-pmp-®️-03b6bb96 647-***-****

PROFILE:

A dedicated, hardworking, and self-motivated SAP Certified Techno Functional Professional has 17 years of experience in SAP Financial and Management Accounting together with Business Intelligence Solutions and Technical Developments. Over the 15 years of SAP career with SABIC, I have been building both personal and professional skills. Handled many challenging situations and complex requirements from several customers. As a team player of SABIC IT & CoE, my goal is to understand Business requirements from stakeholders and customers, perform Analysis and develop high quality and value-driven Analytical solutions using SAP and Non-SAP Analytical applications.

A suitable Team Player with excellent Analytical skills, Customer Service, Presentation, Communication, Organizational and Interpersonal skills that enable me to develop long lasting, trust-based relationships with Managements, Peers, Stakeholders and Clients.

KEY SKILLS:

Hands-on experience in Data Warehouse Apps such as BW, BW on HANA, BW4HANA, HANA Native Developments in XSJS using XS Engine and S4HANA embedded Analytics.

Proficient in various Data Provisioning, Data Modelling, Data Visualization tools to build analytical apps.

Data Provisioning Tools: BW Extraction, BODS, SLT, DXC, SDA, HANA, SDI and ODP Sources.

Data Modelling Tools: ADSO, Composite Provider, Open ODS, Infosource, HANA Calculation Views, ABAP CDS, HANA CDS, Table Function, Hana XSJS using XS Engine, Power BI, Tableau, Cognos, and Power Pivot.

Data Modelling Development Tools: Eclipse, WEB IDE, HANA Studio, BW workbench, IDT & UDT.

Data Visualization BI Reporting Tools: FIORI/UI5 Apps, TABLEAU, SAC, Cognos, Lumira, Power BI, Bex /BW Query Designer, Design Studio, WEBI, Analysis for Office &Crystal Reports.

Development of RICEF Objects in ABAP for FI, PS and PPM Modules.

Developed FIORI APPS- Front end (HTML5,CSS,JavaScript, UI5 Frameworks) and Back End (OData Service).

Extensively experienced in Interfaces, Custom IDOC creation / Creating IDOC extension, Message type, Partner Profile configuration.

Good working knowledge in User Exits, BAdi and Enhancement Spot (Implicit and Explicit).

Have very good experience in preparing of Functional Specification, Technical Specification, Unit Test Scripts, Development integration Test Scripts.

Good Functional Knowledge in S4/HANA FIN & LOG, PS, PPM, IM, FICO, MM, SD, SCM, HR, and CATS.

Expert in SAP Project Implementation Methodologies (ASAP & ACTIVATE).

Familiar with ABAP Transport Management & HANA Lifecycle Management.

Conducted more than 200 Hrs of End User training in diverse Analytics solutions.

Project management (Certified PMP) experience with JIRA and Microsoft Project tools.

Expertise in End-to-end Project Lifecycle and various activities.

Expertise in Project Planning and Cost monitoring/Control process (SPI & CPI, EAC, ETC, VAC - Earned Value Analysis).

CAREER HISTORY

SABIC IT S4HANA/ BI CONSULTANT SAUDI ARABIA JAN 2020 - JUN 2020

Project: Transformation /Migration of ECC 6.0 To S/4HANA

Conducted workshops with business Stakeholders and SME to understand the business requirements.

Adopt and Implement HYBRID AGILE with Scrum methodology.

Worked with cutover team to plan the data loads and cleansing efforts.

Support data migration, data conversion, validation, and testing activities.

Configured SAP S/4HANA Financial Accounting and Management Accounting related activities (GL, Accounts Payable, Account Receivables, Asset Accounting etc.).

Configured SAP S/4HANA Embedded Analytics related activities.

Support SAP BPC Embedded Consolidation process on S4HANA/ECC (legacy system).

Design Hands on configuration of application objects Delta initialization, Custom measures and Complex reporting Creating aggregations, queries, data flow between cubes and building templates.

Lead S/4 HANA migration workshops covering delta training, end-user impacts, and conversion topics.

Coordinate issue resolution with an off-shore S/4 Center of Excellence.

Support end user training across Financial accounting & Embedded Analytical Areas.

Design Fiori Apps for FICO and worked on complete transactional fact sheets and analytical apps.

Worked with basis to activate required apps on Fiori launchpad. Deep understanding on backend and frontend Fiori roles and data services.

Created CDS views (Master data and Transactional) for S/4HANA Embedded Operational Analytics.

Developed OData services to integrate CRM entity/contact with Microsoft Outlook, working on OData implementation for Opportunity FIORI application, used redefined standard OData model, OData from GENIL Component, building new OData model,

Delivered different planning solution - cost center OPEX planning, profit center revenue planning, and CAPEX planning by implementing SAC, Cognos, BW IP/BPC Embedded Model on S4HANA.

SABIC IT SR. SAP BW/HANA -ABAP CONSULTANT SAUDI ARABIA JAN 2014 - DEC 2019

Project#1: SABIC Engineering &Project Management- Business Transformation Project

Conducted workshops with Stakeholders and SME to understand the business requirements and objectives.

In-depth knowledge of Financial Planning and Consolidation processes.

Achieved various task- Setup Chart of Accounts as per IFRS, Making Trial balance=0, currency translation, Intercompany Elimination, Consolidation of Investment, calculation of currency translation difference, calculation of Minority Interest, calculation of Share of Investment of Associate in consolidation, consolidation reports as per IFRS requirement etc.

Developed Financial Statements (Balance Sheet, P&L, Cash Flows) based on US GAAP and IFRS Standards.

Define SMART KPI for Department level, Functional Level and Business Level.

Remodel Existing CAPEX and OPEX Business Process in BW4HANA, HANA Native, SAC and BPC Apps.

Developed Strategic Business Planning based on Corporate Finance direction using BPC, SAC and Cognos.

Developed CAPEX Planning models in SAC, BWIP & BPC for Investment Level Planning, Project Portfolio Planning, Individual Project Planning.

Developed OPEX Planning in SAC, BWIP & BPC for Cost Center, Profit Center, GL Planning etc.

Developed Planning and Analytics models (Revenue, Sales, Billing, Payments, Milestone) for Customer Projects Scenarios in SAC, BWIP & BPC tools and updating in CAPEX versions.

Maintain Allocation Table, Value Driver Trees in SAC and Script logic, Business Rules, Allocations in BPC.

Developed Complex calculated measures using DAX Functions in Power BI.

Performed Data transformation using M Language in Power BI.

Developed Analytical stories and Dashboard on SAC, TABLEAU, POWER BI, LUMIRA using HANA views, BW Models & BW Queries.

Developed Predictive models using Classification, Regression and Timeseries depending on Business requirements.

Developed custom Analytical and Planning Application in SAC Designer using CSS and Java script.

Project #2: SAP BW/HANA Optimization & Supports

Interacted with Stakeholders & SME to understand their Ad-Hoc reporting requirements and business rules for Finance, Sales, Procurement, Inventory, Supply Chain, Manufacturing, HR, and Marketing domains and trained them with modified objects.

Worked extensively on all major domain’s Data sources and built Solution Strategy for Multiple Solution such as Finance (RTR), Purchasing (P2P) and Sales (OTC) etc.

Identification of poor performing extractors, transformations, and queries.

Use the new technologies for data provisioning such as SDI, SDA, ODP, OData Services to extract and load the information from SAP and non-SAP systems.

Remodelling existing models/Data Mart in Eclipse and WEB IDE using Composite Providers with HANA Calculation Views, ADSOs, Open ODS Views based on LSA++ architecture.

Re-Designed custom BW transformation to AMDP scripting for Performance optimization.

Developed HANA CDS, ABAP CDS, and external SAP HANA Views for SAP BW4HANA objects.

Exposed CDS Views in FIORI/UI5 APPS using OData Frameworks.

Designed, developed complex BPC Input template and reports using analysis for office and validating Data flow from HANA View Embedded BW-PAK Bex Analysis office.

Achieved detail level planning by adding custom member line item and implementing comments to track.

Developed budget and forecast reports on HANA views, pulling plan data from BPC by activating HANA external views setting.

Design and build BW4HANA Optimized BW Queries, Hierarchies to meet reporting requirements.

Developed HANA Exit Variable for BW Queries using BADIs.

Built Reports and dashboard using SAC, TABLEAU, POWER BI, LUMIRA, WEBI and Workbooks in AO.

Designed HANA optimized analysis processes, Authorization concepts and Process Chains.

Monitoring Process Chains, Data Loads, DTPs, and BW/HANA objects in BW4HANA COCKPIT.

Conducted Unit Testing, Integration Testing, Regression Testing, and User Acceptance Testing (UAT).

Made sure every Sprint Project done on time follow the scope weekly and see the need to avoid delay for the Go-live support.

Project #3: SAP BW/BO & BPC Implementation & Supports

Responsible for Requirements Gathering by working with business and technical users, analysts, Project Managers, and involved in analysis and creation of ‘Best Practice' and Scalable (LSA) architecture.

Designed & Developed BW Architecture to meet global Data Warehousing and reporting Solution.

Managed the Integration of SAP BW & non-SAP Sources for Consolidation & Harmonization of Global Data for Reporting.

Worked closely with SAP PP, MM, SD, Logistics LE, and Financials Teams for developing Ad-Hoc report for RTR, P2P, OTC and other business process solutions.

Designed Data Marts as per the System landscape, created Functional and technical BW specifications, considered proper data modeling techniques and data management strategies, and created Technical BW Specifications for BW Objects.

Involved in Loads Initialization in SAP BW system followed by extraction LIS/LO Cockpit extraction, FI, CO-PA extraction and scheduling regular Full Loads / Delta Loads using Process Chains.

Worked on ABAP Enhancements in BW for transformations, functional modules start routines, APD's, Expert Routine, BEx Variables, and Extractor programs for the Performance Optimization.

Performed Load Performance Analysis/Optimization of Data Warehouse through BI Statistics, Clustering/ Re Clustering, Partitioning/Repartitioning & Remodeling functions of Info Providers through redesigning.

Performed Query Performance Analysis and Optimization/tuning through data model, query definition, Aggregates, BI Accelerator, OLAP Cache, DB Statistics, Virtual Characteristics & Key figures, time dependent master data, non-complex authorization & delta caching.

Designed and Developed Front-End Enterprise Reporting, Dashboards/Management Cockpits, queries, query views/elements, Report/Report Interface, Currency Translation, Unit of Measure (UOM) conversion through Business Explorer (BEx) Query Designer, BEx Analyzer, BEx Web, formatted reports, Web Application Designer, Report Designer, Visual Composer, and Information Broadcasting.

Designed a Semantic layer-based requirements from business, Single source Universes and Multi source enable DB2 AND SQL Server universe using Information Designer IDT.

Architected and Developed Financial Dashboards Variance Price Exchange, Daily Sales, Profit Loss using Dashboard Designed and Connected source data from SAP BW BEx queries using BICS.

Provided Complex Reports Solutions in WEBI using advanced functionality like report level prompts, scope of analysis, ranking data source, cascading prompts, drilldown, alerts with row level security.

Created Crystal Reports on BEx Queries that were built on BEx Query Designer and wrote complex queries including Sub queries for Supply Chain business areas.

Managed the development of Financial Statement based on US GAAP and IFRS standards, Consolidated Balance sheet, P&L, Cash Flow and Trial Balance Sheet statements.

Worked on CAPEX, OPEX, Financials, Sales Planning, Head Count Planning, Cost Center Planning, Profit Center Planning, Treasury Planning, HR Planning etc.

Used BPF functionalities, Allocations, Member Formulas, Work status, Security and Script Logics.

Configured Business Rules, Intercompany Elimination, Currency translation and Business process flows.

Implemented Planning and Forecast IP PAK. Using manual planning and planning functions with fox formulas and Reports are delivered using Design Studio and Analysis for Office tool.

Designed and customization of aggregation level, filters, planning functions, FOX & characteristic relationship, using RSPLAN.

Worked in the BPC EPM Add In for forecasting and budgeting reports.

Provided Knowledge Transfer and Training to Super Users and End Users on Excel-to-SAP project.

Created Service Level Objectives (SLOs) and Solution Documents.

Worked with (LCM) Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA and Prod.

SABIC E&PM SAP FICO-PS -ABAP CONSULTANT SAUDI ARABIA MAR 2006 - DEC 2013

Business Requirements Gathering, analyzed and finalization as per customer requirements and provide integrated PS solution for Capital Projects / OPEX Projects.

Development of RICEF Objects for PS/IM and PPM Modules.

Modified standard SAP program by BAdi, Enhancement Spot and User Exit to meet client requirements.

Developed both Inbound and Outbound Custom IDoc to interact third party legacy system.

Worked on sending IDocs out of SAP, output determination and stand-alone programs. Involved in ALE configuration like creating Logical Systems, Port, Partner profile, Idoc Segment, RFC destinations, Message type, Customer distribution model to distribute Material.

Executed all phases of Project Management such as initiation, planning, executing, controlling, and closing for projects while leading SAP full cycle implementation as a part of business process improvement.

Creation of Project Coding Mask, Project profile, network profile, planning profile with cost element planning, budget profile with availability control, defining overhead cost structure, settlement profile, result analysis key. and parameter ids.

Project Scheduling, integrating requirement dates and delivery lead times to align supply chain with delivery promises, Project oriented Procurement, monitoring dates and Progress tracking.

Master Data Upload using BDC and LSMW and mapping complex authorization req.

Providing SAP PS Post Go-Live Support and Troubleshooting for all types of Projects.

Post-Implementation Support (Functional & Technical) and guidance for PS, IM & CATS based on Request support ticketing system for SABIC’s SAP PS users across the Globe.

Compared the standard functionality with the company’s organizational requirements. worked on enhancements, Perform Mass Changes.

Develop Project WBS Template, Networks & Operative Projects structures as per Company Business Strategy and innovation. Emphasis on adopting SAP Best Practices in Business Processes.

UAT for all new business requirements including release upgrades, configuration changes, & delta functionality.

PENGUIN ASSOCIATES SOFTWARE DEVELOPER INDIA AUG 2003 to FEB 2006

Designed, coded, and implemented software modifications and enhancements in Visual Basic as frond end and SQL as backend for medium scale for Private Banking Operations, Hospitals, Parish, Super Market, Medical Stores, etc.

Supported software products (Patches) and making progress on new products.

Analyzed User Requirements and developing appropriate software solutions.

Performed Root Cause Analysis on software problems and preparing detailed spec. and program codes.

Tested Products to ensure operation and quality maintained.

Technical Environment: Visual Basic, VB.Net, Oracle, MS SQL, Ms Access.

CERTIFICATIONS:

SAP CERTIFICATIONS: [S USER ID# S0008745528]

SAP Certified Associate ACTIVATE PROJECT MANAGER.

SAP Certified Application Professional - Financial in S4/HANA.

SAP Certified Application Associate - Planning & Analytics with SAP Cloud Platform.

SAP Certified Application Associate - SAP BW/4HANA 2.x and SAP BW 7.5 powered by SAP HANA.

SAP Certified Application Associate - SAP HANA.

SAP Certified NetWeaver ABAP Development Associate.

SAP Certified Procurement MM Application Associate.

SAP Certified Project Systems (PS) Application Associate.

SAP Business Object Cloud SAP Data Migration to S/4HANA SAP ML

EDUCATION:

MBA – Master’s Degree in Business Administration.

MCA - Master’s Degree in Computer Applications.

BS - Bachelor’s Degree in mathematics and Statistics.

PMP - Project Management Professional.

Pursuing Financial Modeling & Valuation Analyst Certification (CFI).

Certificate in Business Analytics.

References Available Upon Request.

Contact this candidate