Post Job Free

Resume

Sign in

Data Architect Fp A

Location:
Sachse, TX
Posted:
February 19, 2024

Contact this candidate

Resume:

Tajuddin Mohammed

Data Architect SAC Datasphere HANA BW ABAP BO

+1-512-***-**** (M), ad3qtx@r.postjobfree.com

Experience Summary:

Experience

** *****

SAP

** ***.

Technologies

SAP Analytics Cloud

(SAC)

Planning (FP&A), Data Actions, Muti-Actions, budgeting, Forecasting, Reports, Dashboards, Analytic Designer, DIBO, Smart Insights, Smart Data Discovery

7 yrs.

SAP Native HANA

Hana Modeling, Schema, Table, Decision table, Analytical Privileges, Stored Procedures XSA, Calculation Views (Script, Graphical)

7 yrs.

Datasphere/ Data Warehouse Cloud

Data integration, cataloging, semantic modeling, data warehousing, and virtualization,

<1 yr.

ABAP on S/4 HANA

Classes & methods, Badi's & User Exits, CMOD, Classical and ALV reporting, BW Data source, Start & End routine, CDS Views, AMDP, BOFS, IFRS & RAR reporting.

7 yrs.

BO / Presentation

Query Designer, Bex Analyzer, WEBI, Lumira, Analysis for Office, Tableau, Power BI & SAC

9 yrs.

Cloud

Azure Data Lakes

2 yrs.

BW & BW on HANA

Standard and Custom Data Source extractors, Data loading to PSA, Transformation, routines, cubes, multi provider, ADSO, Virtual Provider

10 yrs.

ETL

SLT, CORS, SAC to HANA (Direct & Embedded) Connection, OData, REST, SOAP, universe (BO), IDT, Info view

10 yrs.

Authorization

Roles, Authorization Object (ABAP), Teams & Roles (SAC)

18 yrs.

Functional

SAP SD, MM, LE, FI, CO, HR, OTC, PP, PS, PM

18 yrs

Implementations

5 implementations (2 - S/4 Hana, 2- SAC, 1- BW)

18 yrs

Tools

Hana Studio, BAS, Eclipse, Web IDE, SAP GUI, Visual studio, BTP

18 yrs.

Management

Project Lead / Architect

Leading team, Resource allocation, Time keeping, Delivery on time, Risk assessment, Management reporting, Budgeting, Cost reduction, Customer Satisfaction

7 yrs.

Learning

AI / ML

Python, Typescript, Artificial intelligence & Machine learning, Generative AI, NLP

2 yrs.

Certification

SAP

SAC (P), HANA, BW, ABAP, MM, AWS, SCRUM, PMP

Employers

Fisher Investments: Dec 2022 – till, Wipro Sep 2017 – Dec 2022, Infosys. Sep 2015 – Sep 2022, Apex Systems Mar 2015 – Aug 2015 Al-Falak Aug 2009 – Mar 2015 TCS Mar 2006 – Aug 2009

Education

Bachelor of Engineering (B.E, 2005) Osmania University, HYD, India

Career Summary:

A R C H I T E C T (S/4 HANA SAC DATASPHERE BTP)

Fisher Investments Plano, Tx, USA Dec 2022 - Present

Roles and Responsibility:

•Successfully led global Implementation project of SAC (planning) over S4 Hana Cloud (in Azure) connected by Datasphere using Cloud Data Integration.

•Played a pivotal of Lead Data Architect while working closely with FP&A (Financial Planning and Analysis) team to understand their requirements for planning, budgeting, and forecasting, and translated them to technical documents.

•Have coordinated with technical team at offshore, to develop and deliver above project on time.

•Established data connections to diverse SAP and non-SAP data sources within Datasphere (formerly known as Data Warehouse Cloud DWC), aligning data with BDFA (business data fabric architecture) to ensure data precision, comprehensiveness, and dependability.

•Engaged with multiple modules within Datasphere, including data integration, cataloguing, semantic modelling and virtualization.

•Extracted valuable insights from data by amalgamating information from various origins as part of the open e-data ecosystem. This provides users the flexibility to leverage their investments with seamless integration of sap and non-sap platforms, significantly simplifying their data landscape.

•Used embedded BW in S4 Hana to create BW Queries over CDS Views that are consumed into SAC using Datasphere.

•Demonstrated expertise in performance tuning for SAP systems, including fine-tuning, query execution, data processing, and system responsiveness; to enhance overall system efficiency.

•Collaborated closely with the financial team to thoroughly understand business requirements and create business requirement documents that are eventually converted to Functional and later in technical specification.

•Implemented effective cost control strategies leveraging SAP Analytics Cloud, enabling organizations to optimize both CapEx and OpEx for enhanced financial performance.

•Developed compelling data visualizations within SAP Analytics Cloud to communicate complex financial information in a clear and concise manner, facilitating better understanding of CapEx and OpEx trends.

•Work on various planning processes including Capex (Capital Expenditure), Opex (Operating Expenditure), depreciation, and P&L (Profit and Loss).

•Extensively worked upon in SAP native Hana, SAC (planning), ABAP CDS, Datasphere, to deliver various planning reports.

•Successfully created a Direct Hana Live connection from SAC to the Hana database (S4), as well created a BW connection type to get data from BW embedded S/4 Hana system. while optimizing data transfer and query performance.

•Integrated AMDPs for SAP ABAP programs, utilizing SAP HANA's capabilities.

•Developed SQL Script-based database procedures for efficient data handling.

•Implemented multi-action and Data actions to project the salary of both internal and external salespersons, ensuring efficient data processing.

Proficient in using BTP as a holistic solution provided by SAP.

•Crafted CDS Views within S4 Hana, considering performance optimization, and effectively consumed them in SAC using Data services, streamlining data access for reporting.

•Expertise in enabling smart insights and discoveries over various KPI’s have helped customer to get insights to unrealized profits.

A R C H I T E C T (HANA SAC ABAP ON S/4 HANA)

Apple (Wipro) Austin, TX June 2022 - Dec 2022

Roles and Responsibility:

•Providing architectural solutions for customer requirements and project roadmaps, with a focus on authorization and security.

•Evaluating system architectural improvements and optimization, including conducting Proof of Concept evaluations for alternative technology solutions aimed at cost savings and improved performance while maintaining data security.

•Developed AMDP, CDS views with annotations, OData services. .

•Implemented Extended Calculation View in the OTC module to introduce custom logic and functionalities, ensuring a seamless integration of business rules.

•Consumed CDS Views in SAC for creating reports on Sales, & Accounts Receivable.

•Providing smart insights and rolling forecast capabilities of SAP Analytic cloud.

•Modernization of legacy systems following a cloud native approach.

•Supported existing reports and created new reports to cater the requirements of business users.

•Handled data loading from Flat files into tables and building hierarchies using SQL scripts.

•Demonstrated expertise in creating and optimizing database artifacts within SAP HANA XSA, contributing to improved performance and efficient data management.

A R C H I T E C T (HANA SAC S4/ HANA ABAP ON S/4HANA)

SABIC Riyadh, KSA Sept 2017 - June 2022

Roles and Responsibility:

•Adherence to industry best practices and excellence in generating Private, Re-use, and Reporting views to promote modularized modelling.

•Successfully migrated sap ECC to S/4 Hana in a migration project which involves various steps such as data cleansing, data mapping, integration with cloud, Transformation, Data Quality, security, and governance.

•Expertise in HANA Modelling, including Attribute, Analytical, Calculation views & Procedures,

•Worked on various greenfield projects that includes, Data Modelling Proficiency, specializing in crafting Cube, and Star Join-based Calculation Views.

•Proficient in writing custom logic using sql scripts in the SAP HANA environment.

•Created variables, Input parameters, Calculated columns, and Filter expressions.

•Cloud Deployment Competence, with proficiency in deploying solutions across diverse HANA environments, including Hana on Azure Cloud, and S/4 Hana on-premises installations.

•Applied AMDPs to optimize complex queries and reporting.

•Created Procedures, Analytical privileges, Roles, buffer tables, and scheduling XS jobs while considering performance optimization.

•SAP HANA Security expertise, Roles, Privileges, and robust security management.

•Data Provisioning Proficiency, including Data Provisioning methods like SLT & SOAP requests.

•Developed various Dashboards and Analytical applications in SAC for finance, HR, sales and logistics as well as non-SAP systems (Flat Files, other non-SAP Data sources).

•Experience on creating Live and acquired Data connections in SAC.

•Experience in Designing Teams, Roles and assigning role to business users in order to restrict data to be viewed in various dashboards in SAC.

•Extensive experience in connecting SAP Analysis for Office from SAP data sources for analytical exploration by business users.

Sr. C O N S U L T A N T (BW BO)

PWC (Infosys) Tampa, FL, USA Aug 2015 – Sept 2017

Roles and Responsibility:

•Onsite lead role handling a team of 18 at offshore.

•Architecting reporting requirements into technical design and development.

•Translate Business requirement documents and functional specifications into technical specifications, data flow diagrams and data models.

•Create Proof of Concept documents for client’s requirement and present it to business.

•Worked on enhancement projects involving data warehouse systems such as BW, & BO.

•Created data source at source system, replicate in BW(7.3), Create Info package, modify transformation, transfer rules, update rules, DTP, cube, and multi-providers, modify queries. Schedule and monitor data loads. Have a good understanding of BW4Hana.

•Proficient in SQL and data manipulation techniques for data extraction and transformation.

•Monitored data loads and took corrective actions as needed apart from solving live data reconciliation issue at customer facing.

•Designed and developed BI/BO Reports, and Tableau/Power BI Dashboards.

•Proficient in Tableau Desktop and Tableau Server.

•Extracted, transformed, and loaded data from various sources.

•Optimized Tableau workbooks for performance.

C O N S U L T A N T (BW BO)

Ogilvy (Apex) NYC, NY Mar 2015 – July 2015

Roles and Responsibility:

•Designed and developed various BI/BO Reports using tools such as Tableau/Power BI Dashboards.

•Carried out BW support activities such as data loading, data consolidation and reloads if required.

•Created engaging and dynamic Power BI dashboards. Employed DAX (Data Analysis Expressions) for advanced calculations and data modeling. Integrated Power BI with diverse data sources, encompassing both cloud and on-premises databases.

•Developed Bex Queries, Universe, WEBI reports, and designing X-Celsius/Dashboard.

•Built reports using Bex query designer using features such as restricted/calculated key figures, currency conversions, complex queries using Cells feature/2 structures.

•Hands-on experience on creating complex, formatted, multipage reports using Web Intelligence.

•Managing schedules and publications based on Webi reports.

•Provide production support and troubleshoot issues as needed. Identifies, analyzes, prioritizes, assigns and/or resolves business and technical issues.

•Create/modify authorizations and roles. Set up new users with necessary permissions.

C O N S U L T A N T (ABAP BW BPC)

SABIC (Al-Falak) Riyadh, KSA Aug 2009 – Mar 2015

Roles and Responsibility:

•Analyse Business Blueprint documents and develop Solution Design Documents.

•Created custom Data Sources, Info sources, Transformations, DSO, DTP, Cube, Multi-Provider, APD, Info Packages, Process chains.

•Responsible for various monitoring data load activities and correct them while loading data into BW.

•Activate data sources, info objects, and repair inconsistent Info Packages.

•Worked on various Greenfield projects that includes critical financial reports such as Balance Sheet, Income Statement, and Cash Flow and Sales Quantity, Production Quantity, Profit & Loss Reports.

•Created Bex queries and consumed them into Webi, Lumira reports.

•Wrote ABAP code in start routines, end routines, field routines, CMOD for query variables.

•Worked on support activities that involves BW and ABAP related activities.

•Translates business rules into SAP BPC rules to automate consolidation and planning process.

•Facilitate designing of planning solutions to solve business problems and needs using SAP BPC on HANA.

•Worked upon different processes in SAP BPC such as EPM, BADI, script logics and computations.

•Created real-time info cubes, Planning functions and Allocations.

•Investigate applicable SAP notes, understand potential system impact, and implement complex SAP notes.

•Support and Maintain the BI system performance, integrity, and reliability by performing activities including Monitoring and Tuning performance, data loads process chains, BI logs.

•Train and educate business users of system use & business processes.

S Y S T E M A N A L Y S T (ABAP)

Sony Ericsson (TCS) Mumbai, India Mar 2006 – Aug 2009

Roles and Responsibility:

•Strong capabilities in handling technical upgrades or brownfield implementation, particularly the transition from SAP version 4.6c to ECC 6.0, and providing post go-live support.

•Extensive involvement in upgrading by utilizing tools like SPAU and SPDD to adjust DDIC objects.

•Made Unicode compatible different standard & custom RICEF objects such as: Reports, ALV Programs, Web Dynpro programs, Data Elements, Tables, Domains, Search Help, and Function Groups, Function Modules, Classes & Methods.

•Monitored ALE IDOCS and corrected them upon failure in IDOC monitor.

•Active involvement in cutover and go-live activities, including tasks related to data loading, migration, and customer modification, contributing to the project's overall success.

•Proven track record of making modifications to existing menu and screen painter functionalities to enable the development of custom screens tailored to specific project requirements.

•Development of Remote Function Modules and utilization of BAPIs in custom program development, enhancing the system's capabilities.

•Creation of Module Pool programs for multiple screens, particularly within the HR payment program.

•Implementation of Business Add-Ins (BADI) in accordance with functional requirements to enable the automatic creation of Purchase Orders for each Sales Order, streamlining processes.

•Incorporation of OSS notes as necessary for addressing both basis requirements and functional fixes, ensuring the system's reliability and performance.

•Utilization of enhancement points, User Exits, and BADI functionalities throughout the work to meet diverse project requirements and enhance system functionality.



Contact this candidate