SUMMARY:

• A highly motivated, result - oriented, customer-focused IT professional and passionate about technology and quality.
• Modeling: - Creation of custom Info Cubes, DSO, MultiProviders, Master data Info Objects, Process chains and Involved in User Acceptance Test, Go-Live.
• Extractions: - Used Business Content, Extracted data from ECC and CRM.
• Reporting: - Worked on BEx query designer making global and local structures, restricted key figures, Variables, Exceptions and conditions.
• Involved in complete ETL process and Reporting.
• Had involved slightly in CRM DS enhancements.
• Can do ABAP Coding working with end routine and enhancements.
• Extensively Worked on LO Extraction.
• Extensively worked on the Generic Extraction (Data Sources) and created generic data sources.
• Completed three implementation projects in SAP BW.
• Knowledge in SAP BO Design Studio, SAP Lumira
• Excellent working knowledge of SAP BW On HANA new features: Composite provider, Open ODS View, Advanced DSO, Building hana calculation Views, Extraction from SAP HANA Views
• Working knowledge of SAP HANA Data provisioning, Data modeling.
• SAP BW on HANA: Composite Provider, Advanced DSO, Open ODS View, SAP BW - HANA Mixed scenarios, Publishing Data from HANA Calculations views into BW, semantically partitioned Objects, Graphical Data Flow, Hybrid Providers, LSA++, Generation of hana models from BW Objects, Operational Data Provisioning using HANA Information Models etc.
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Knowledge on SAP BODS, SLT, Direct Extractor Connection, Flat file Uploader.
• Worked on Micro strategy Reports having base as SAP BW on HANA.
• Have very good understanding of the Europe/US client handling skills both at onsite as well as support from offshore.
• Have very good understanding of project plan for implementation.
• Have been trained in LSA (Layered Scalable Architecture) and LSA ++Concept.
• Good at Documentation which involves various phases of the project.

PROFESSIONAL EXPERIENCE

Confidential

Environment: SAP BW on HANA. (SAP HANA 7.4)

Associate SAP BI Consultant/ SPOC for NAM

Responsibilities:

• Gathered and analyzed the requirement for the global data warehousing project on BW on HANA.
• Designed the architecture and detailed hana models for extracting actuals to sas planning environment and reporting requirements.
• Designed regional layered hana models for scalability and flexibility for many functional areas like Open Orders, Shipments, Billing, Point of sales, sas planning.
• Delivered close to 300 metrics on OTC, Procurement and Planning on SAP HANA using BI tools like WEBI, Design studio, BO analysis for Office.
• Built real-time reports on sap hana using SLT replication methods.
• Extensively leveraged LSA++ architecture using the BW on HANA framework.
• Converted attribute and analytic views to calculation views of type dimension and star joins and scripted calculation views to table functions.
• Worked on Scripted calculation Views to push down calculations to sap hana.
• Designed SAP BW on HANA Composite Provider as semantic layer using BW on HANA Modelling tools in HANA Studio.
• Generated SAP HANA Analytic Views for standard DSO’s in HANA and used them in calculations Views.
• Enhanced Loading performance by Pushing down ABAP Logic into SAP HANA Script Based calculation view and improved performance by 40%. Reduced loading time by 3 hours.
• Loaded data into SAP BW with SAP HANA Calculation View as source using DB Connect.
• Leveraging Semantically Partitioned DSO feature Loaded and managed mass data volume for several regions.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio .
• Implemented LSA++ architecture in the BW on HANA Landscape.
• Worked extensively on HANA modelling for BW Objects.
• Created SAP BO Analysis for Office Reports for analytical reporting.
• Designed webi reports with complex formatting.
• Designed SAP BO design studio Dashboards for Sales and Procurement.
• Loaded data from legacy BW system into BW on HANA using BODS for history data.
• Migrated HANA content from development, testing environment to Production environment using Charm integrated LCM Process.
• Extensively working on SAP BODI Designer Components- Projects, Jobs, Workflows, Data Flows, Data Store and Transformations, Formats.
• Using designer to create source definitions, design targets, create jobs and develop.

Confidential

Environment: SAP BI 7.0, SAP R/3, ECC 6.0.

Associate SAP BI Consultant/ Team Lead.

Responsibilities:

• Involved in creating Info Objects, Data Sources (Generic and LO Enhancements), Master data and Transactional data into BI System as per the client Requirement.
• Created data sources and info packages for transaction data.
• Extensively worked on MM module (extract the data from R/3 to BI System).
• Extensively Worked on LO Extraction.
• Other than P2P also involved in Critical Business reports in enhancing existing functionality.
• Also worked on Creation of CRM reports.
• Worked extensively in Transportation Part.
• Developed flexible reports using Variables, Filters, calculated key figures, Restricted Key figures, and using Conditions, and analyzed in the BEX analyzer and organized workbooks in BEX browser

Confidential

Environment: SAP BI 7.0, SAP R/3, ECC 6.0.

Senior SAP BI Consultant.

Responsibilities:

• Involved in creating Info Objects, Data Sources, Info Packages and Data Target to load Master data and Transactional data into BI System as per the client Requirement.
• Created data sources and info packages for transaction data.
• Extensively worked on MM module (extract the data from R/3 to BI System).
• Extensively Worked on LO Extraction.
• Involved in Performance Tuning by using Business Intelligence Accelerator (BIA).
• Involved in designing process chains and creating process chains for master and Transactional data Loads
• Managing the process chains and monitoring.
• Monitoring of info package and analyzing the reason for failure of info package.
• Till Dec 2012 worked in development of WWI. From Jan 2013 to August 2013 gave support for same project.

Confidential

Environment: SAP BI 3.5 and 7.0, SAP ECC 6.0.

SAP BI Consultant

Responsibilities:

• As part of Interior divestitures carried out developmental activities related to BW module.
• Creation of Change Management documents after detailed discussions with the client.
• Responsible for the entire developmental process with regard to the given objects.
• Knowledge Transition and user education for the new development / enhancements
• Extensively worked on activating the Standard Delivered Business Content in the form of Info Objects, Info Sources
• Involved in modification of Info Cubes, ODS, Info Sources for master data and transaction data.
• Extracted master & transaction data using LO Cockpit, generic Data Sources from OLTP.
• Worked extensively on Administrator Work Bench, Created Info Objects, characteristics and key figures.
• Designed making extensive use of the PSA and ODS capabilities.
• Involved in Performance tuning by BIA, compression, indexing and partitioning of Info Cubes.
• Developed flexible reports using Variables, Filters, calculated key figures, Restricted Key figures, and using Conditions, and analyzed in the BEX analyzer and organized workbooks in BEX browser.

Confidential

Environment: SAP BI 3.5 and 7.0, SAP R/3 ECC 6.0

Associate SAP BI Consultant

Responsibilities:

• Providing Post-implementation support for the SAP Business Warehouse system from offshore.
• Proactively participated in Knowledge Transition from Offshore being a Knowledge Recipient.
• Preparing KT plan documents and reviewing the documentation of the project.
• Learn application architecture and business process.
• Worked with migration testing which is assigned by client.
• Prepare Agenda, Minutes of Meeting with regard to KT session.
• Attending the KT sessions through web conference.
• Resolving the customer tickets depends on the priority.
• Monitoring Daily/Weekly/Monthly data loads
• Analyzed and corrected production problems as they occur in the SAP BW system
• Maintaining Work History for all the tickets until it is closed down.
• Daily monitoring of Info cubes and ODS object requests.
• Dealt with Compression of Info cubes.