SABIC E&PM Business Transformation Project

• Transform Shares Service to Standalone Business Scenario
•  Remodeling Existing CAPX , OPEX Process
• Modeling Customer Project and updating CAPEX Scenarios
• Defining SMART KPI for Dept level, Functional Level and Business Level
• Strategic Business Planning based on Corporate Finance direction
• CAPEX Planning (yearly and Strategic) - Investment Level Planning, Project Portfolio Planning, Individual Project Planning ( Project Charter , Date Planning, Resource Planning, Project Schedule Planning, Project Cost Planning, Inventory Planning, Revenue Planning, GL Cost Planning, Activity level Planning, Milestone activities, Billing Planning)
• OPEX Planning (yearly and Strategic) - Cost Center Planning , GL Planning,, HR Planning,
• Budget Allocation (Top Down Approach)
• Maintain different Planning Allocation Table
• Maintain and updating Value driver trees
• Maintain Cross Affiliate transaction
• Reporting  Supports (as per IFRS Stand)- Financial Statements ( P&L, Balance Sheet, Cashflow)
• Internal Reports ( Company Performance, Department Performance, HR Performance, CAPEX Performance)
• Transform Shares Service to Standalone Business Scenario
• Remodeling Existing CAPX , OPEX Process
• Modeling Customer Project and updating CAPEX Scenarios
• Defining SMART KPI for Dept level, Functional Level and Business Level
• Strategic Business Planning based on Corporate Finance direction
• CAPEX Planning (yearly and Strategic) - Investment Level Planning, Project Portfolio Planning, Individual Project Planning ( Project Charter , Date Planning, Resource Planning, Project Schedule Planning, Project Cost Planning, Inventory Planning, Revenue Planning, GL Cost Planning, Activity level Planning, Milestone activities, Billing Planning)
• OPEX Planning (yearly and Strategic) - Cost Center Planning , GL Planning,, HR Planning,
• Budget Allocation (Top Down Approach)
• Maintain different Planning Allocation Table
• Maintain and updating Value driver trees
• Maintain Cross Affiliate transaction
• Reporting  Supports (as per IFRS Stand)- Financial Statements ( P&L, Balance Sheet, Cashflow)
• Internal Reports ( Company Performance, Department Performance, HR Performance, CAPEX Performance)

SAP HANA Optimization & HANA Modelling & Reporting

• Interacted with Customers to get the requirements and also trained them with developed objects.
• Identification of poor performing extractors and transformations
• SAP BW/4 HANA Modelling for ADSO and Open ODS, Extraction and loading of data from Sales Stats (0UC SALES STATS 02) and Mass Extraction Activity for FI-CA: BP Items, Payments
• Worked extensively in the Finance - Accounts Payable (FI-AP) - 0FI AP 1, 0FI AP 4; Accounts Receivable (FI-AR) - 0FI AR 1, 0FI AR 4; Finance - General Ledge (FI-GL) - 0FI GL 1, 0FI GL 2, 0FI GL 4, 0FI GL 6 and 0FI GL 10, CO-CCA Extractors(1 CO CCA 1.)
• Redesigned HANA Attributes Vies, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• ABAP Hana optimization of all old custom extractors.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non-sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.
• Developed Database procedures and script-based calculation views using HANA Programing language like SQL, CE Functions or Native SQL
• Developed composite providers and virtual providers, open ODS views
• Optimizing HANA views for best performance
• Developed Analytics solution using SAP HANA and SAP Business Object Tools set like WEBI, IDT, Analysis for Office, Design Studio & Lumira
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter, currency conversion
• Created CDS Views (with Parameters) for exposing to Various Reporting Platforms.
• CDS Views Enhancements Based on Client requirement based on Various reporting Strategies.
• Worked on both Load performance tuning and Report performance tuning by creating DB Statistics, Aggregation, OLAP Cache, Compression, Indexes and Partitioning
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Designed architecture leveraging SAP Gateway, HANA cloud connector, BOBJ Cloud agent.
• utilized new features for advanced analytics reporting and dashboard.
• Interacted with the business team for the requirements gathering and other technical issues fixes in the environment

SAP BW Migration from 7.X DB to BW on HANA

• Identify the need of custom extractors or the right model on native HANA or BW on HANA or hybrid model on BW with Hana, design and implement end to end Dataflow for Financial FI GL AP, AR, COPA and Manufacturing, QM areas
• Translates user requirements into a modelling design in Hana and BW on Hana
• Preforming inhouse Pre and Post Migration activities. (SUM with DMO, PAM & SAP Best Practice)
• Implemented SAP BW on HANA specific modelling like Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning, LSA++, etc.
• Validate Views generated in SAP HANA Live. Decide the SAP BW vs Hana live design for a reporting solution
• Developed and handled hybrid scenarios - BW data models and HANA views as per the requirement.
• Design and develop information models attribute, analytical, calculation views on HANA and Manage SAP BW tables in HANA distribution environment
• Design, trouble shoot and resolve problems related to integration of SAP and non-SAP data in BI
• Integrate the data from non-SAP systems of acquired entities to SAP and maintain the reporting data integrity and security by developing reporting solutions in native Hana and BW on Hana
• Data-Provisioning techniques suing SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS
• Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer MS Excel
• Designed and implemented the Throughput reports in BO4.2, Webi and Dashboard builder
• Worked with LCM Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA and Production.
• Troubleshoot and provided support for the BW environment in modelling, load process, process chain monitoring
• Performance tuning Data loading and BEX reports and job failure reduction activities.

Sr. SAP Business System Analyst

• Interact with the business stake holders to understand business needs, analyzes complex business requirements, reporting requirements and propose the best solution for them, and convert them into write the functional specification.
• Implemented data security access with Universe level security and report level security also system security access with integrating the Active directory according to design specification.
• Designed a Semantic layer-based requirements from business ,  Single source Universes and Multi source enable DB2 AND SQL Server universe using Information Designer IDT for the HCM and FI business.
• Architected and developed  financial dashboards Variance Price Exchange, Daily Sales, Profit Loss using Dashboard Designer and connected source data from SAP BW BEx queries using BICS.
• Provide complex reports solutions in Web Intelligence using advanced functionality like report level prompts, scope of analysis and ranking data source.
• Provided Solutions and Developed HCM Dashboards using Dashboard Designer allowing the leadership teams to analyze headcount, compensation and performance trends and metrics for all levels of the organization and source data feed from Universes using QaaWS export dashboard to mobile server as HTML5.
• Involved and analyzed in creation of  Web Intelligence Reports with different functionality like cascading prompts, drilldown, Scope of Analysis, charts, ranking, alerts and implemented with row level security.
• Worked on BEx Query Designer in designing queries using Variables, Navigational Attributes and Structures to facilitate flexible, detailed drill down data analysis to required level of information.
• 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.
• Migrated Universe designed Universes UNV files into Information Design Universes UNX files using upgrade management tool.
• Worked closely with the Database and ETL team to get required table structures.
• Involved in working with different database environments PROD, DEV, and QA and migration of the universes and reports using LifeCycle Manager. Established a change control for each development.
• Conducted Training sections for all BI Business Users and created end-user training documentation.

SAP Business System Consultant

• Responsible for requirement gathering by working with business and technical users, analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable (LSA).
• Designed & developed BW Architecture to meet global Data Warehousing and reporting Solution.
• Managed the integration effort of SAP BW and non-SAP Sources for consolidation and Harmonization of Global Data for Reporting.
• Worked closely with Production Planning PP , material management MM , Sales and Distribution SD , Logistics LE , Financials FI AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash, Procure-To-Pay, Point of Sale POS data via DataStage and other integrated 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 from SAP R/3 system and Non-SAP systems and scheduling regular Full Loads / Delta Loads using Process Chains.
• Extensively 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 InfoProviders 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 frontend 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.
• Provided Knowledge transfer and Training to Super Users and End Users on Excel-to-SAP project related to Manufacturing during all phases of project.
• Created Service Level Objectives SLOs , Solution Documents with the BW team that will guide the production support team when issues occur.

SAP FICO-PS FUNCTIONAL CONSULTANT

• Worked in Blue print preparation, running workshops, worked in scope/ Requirements gathering & Analysis, worked in finalizing the Design and Architectures, Coordinating the implementations & Build activities, testing and Documentation.
• Worked on US GAAP and IFRS
• Configured Company Code, Posting Period Variants, opening of Posting Periods, Fiscal year Variants, Field Status Groups, Document Ranges, Tolerance Groups, and assigning the variants to Company Code etc
• As a part of global role out set up New Entities, Assigned Chart of accounts, Controlling area and extended/created GL to the new Company Code, Worked in extending the Customer Master and Vendor Master to NEW Company Codes.
• Configured the Credit Management, Credit Control Area, Assigning Credit Control area, Reason Code. AP configuration for vendor master, field status group, setting up work-list, Financial Statement version, G/L Display configuration
• Configured Special Purpose Ledger (SPL), Configured International VAT. Inter-company set-up
• Worked in Accounts Payable, Accounts Receivable,  and GL for EMEA, APAC,AMERICA REGION of Companys
• Configuring & Customizing Vendor Master Data, Account Groups, Logistic Invoce Verification, Terms of Payment, Dunning, interest Calcution, check Management.
• Asset Management: Configured Chart of Depreceiation, Depreciation Areas, Asset class Account determionation, Calculation Keys, Depreciation Keys Transaction Types, Aqucition, retirement, Transfer & Scraping.
• Configured House Banks, Payment Programs, Automatic Payment Methods, and alternate Bank Selections for Payments. Checks Management through assigning number ranges for check lots, checks printing and defining void reason codes.
• Configured Payment Programs (FBZP), Payment Methods in Country, Payment Methods in Company Code, Bank Determination, House Banks (F110)
• Interacted with Client to Create and Group Customer and Vendor Master Data, Vendor Field Status. Customized Line Layouts for GL, AP, and AR data entry and Report displays
• Defined and Configured Controlling Area; Assigned Company Codes and Number Ranges; Operating Concern, Defined Profit Center Hierarchy and Cost Center Hierarchy.  Configured Cost Centers and Profit Centers and Cost Element . Allocations, Primary and Secondary Cost Elements.

Responsibilities PS

• Business requirement gathering, analyzing and finalization as per customer requirements and provide integrated PS solution for Capital Projects / OPEX Projects.
• Business blue print preparation and GAP identification. Preparation of complex authorization matrix. GAP analysis and preparation of Functional Specifications, Configuration, internal testing and integration testing
• 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.
• Creation of Z reports, validation, substitution and user exits as and were required.
• Providing SAP PS post go live support and troubleshooting for All E&PM Mega Projects, Global Projects and Site Projects in all SABIC Affiliates.
• 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.
• 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
• Comparing the standard functionality with the company’s organizational requirements. Address Change requests; work 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
• Study and Analyze the Customization and Highlight functional shortcomings in the existing implementation
• Check all the Z Development, check and analyze the Functional specification preparation for customized reports, scripts and enhancement.
• UAT for all new business requirements including release upgrades, configuration changes, & delta functionality