Skills
PROFESSIONAL SUMMARY
- Having more than 14+ years of extensive experience in IT industry with around 11 years of SAP Products like Business Warehousing/Business Intelligence/Business Objects/BW on HANA/B4HANA experience with strong exposure to data provisioning, modeling and administration roles.
- Proficient in conducting workshops, gathering requirements, gap analysis, POC, development, testing, FS & TS documentation, maintenance.
- Proficient in business processes across various SAP functional modules like SD, MM, PP, PS, Vistex, Finance, HR-PA.
- Efficiently managed teams of various sizes and worked with the team to achieve company & client's goals
- Provided BI trainings to associates, end user trainings to Client after Implementation.
- Proficient in Planning and Design the Implementation of SAP Business Information Warehouse models, Bex Reporting and BO Reporting.
- Extensive experience in designing and developing data models in BW and HANA 1.0
- Proficient in troubleshooting and performance tuning of BW/BO/HANA designs.
- Experienced in End to End implementations and support projects for different clients for SAP modules in SAP BI/BW/HANA.
- Fair knowledge on SAP Workforce Performance Builder (WPB)
- Capable of working in a group as well as independently with excellent communication skills. Strong production support experience, good at trouble shooting with quick turnaround in fixing the issues.
- SAP BI, HANA 1.0 Certified.
- ITIL V3 Certified
- Lead Blueprint workshops with Business Subject Matter Experts, Business Analysts to understand the business scope and data reporting requirements to align solutions with business needs.
- Provide recommendations, plans, and leadership to fully integrate the solutions for business needs and meet them efficiently and effectively.
- Influence and guide external Service Provider and other partners in solution design and delivery, providing guidance and review of developments, and designs to ensure methodology, best practices and standards are followed and to ensure overall quality of the solution.
- Estimating project cost and resource needs, controlling scope, leading external providers to deliver on time and on budget.
- Proven track record of successful SAP BW on HANA and HANA solution design and delivery; demonstrated strong planning skills; demonstrated strong in-depth knowledge of multiple SAP Functional areas [SD, MM, PP, WM, FI (AR/AP/GL), COPA, BPC].
- BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB. Proficient in Data modeling using BW extended star schema models.
- BEx Worked Extensively in BEx Analyzer in building Queries, saving it in Workbooks (Excel work Sheets). BW Expertise in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules, Which Includes Data Modeling.
- Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.
- Web Reporting Developed Web reports, Web items, customized Web templates using Web application designer (WAD) and query designer.
- Proficient in Business Objects Reporting using Crystal Reports, WEBI Rich Client 4.0, Live Office and Xcelsius.
- Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.
- Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
- BI Operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
- Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains and Open hub.
- Developed all kind of Routines (Start, End & Expert) during the creation of Transformations & DTPs using BADI's through ABAP.
- ABAP - Reporting, User Exits, Customer Exits and designing and developing generic extractors with function modules.
- Responsible for providing ABAP new development/support from offshore.
- Bug fixing & enhancements to existing development objects.
- Responsible for debugging standard & customized programs to analyze critical issues in ABAP Reports or extractors.
- Information Design Tool (IDT) to create universes connecting to multiple Data Sources.
- Designing/Developing Universes/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.
- Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
- Developing WEBI reports on SAP BW Queries using BICS connectivity.
- Modifying BW queries in to generate WEBI reports in BO to meet user requirements.
- Design Studio to create best and user friendly dashboards.
- SAP BODS for extracting and loading data from ECC and heterogeneous source systems into SAP HANA/SAP BI.
- Developing data flows and work flows using BODS. Worked on RDS to implement ETL Replication.
- Implementing SAP BODS Incremental Data load leveraging BO products or other third party products.
- Conversion of Other DB SQL Scripts into HANA SQL Scripts .
- Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script.
- Strong experience on Creating SQL, Stored Procedures with SQL Script and also with Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like – Tracing, Using the SQL Script Debugger.
- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport – Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import – mass import of metadata, selective import of metadata.
- Designing data extraction methods using SAP Landscape Transformation, Smart Data Assess and BODS
- Design the data modeling using advanced BW objects like Advanced DSO, Composite Provider based on the cases to achieve the client requirements.
- Migrating standard BW flow to BW/4HANA aDSOs and CPs.
- Creating dual case scenario flows using Composite Providers, aDSOs and Calculation Views to meet the user requirements to provide faster data availability to the client.
- Proficient in LSA++ Architecture.
Project history
Working in Malaysia for MNC company,
Worked for multiple MNCs in india.
Worked for multiple MNCs in india.
Local Availability
Only available in these countries:
Malaysia
Open to Travel
