SUMMARY:

• A certified SAP Business Intelligence Consultant with an overall experience of 9 years on SAP BW / BI Modeliing and a further 3 years on SAP experience on team lead
• A result oriented team player with excellent communication skills and s in providing hands - on guidance with SAP BW /BI, BOBJ & SAP HANA to clients in Pharmaceutical, Energy, Telecommunication, Retail and Banking sectors.
• Sound knowledge and understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in HANA studio.
• Created several stored procedures and SQL scripts using CE functions to generate reports.
• Extraction of data from traditional database tables using STL and BODS within HANA.
• Created MultiProviders, InfoCubes, DSO’s, InfoSets, InfoObjects, InfoSources, Advanced DSO’s, Composite providers, SPO / Write Optimised DSO, migration of datasources. Modeling with SAP HANA Studio 1.0 - Creation of Attribute Views, Analytical Views, Calculation Views based on SAP ECC tables. ABAP.
• BO Designer: Creating of Universe using BO 4.0 and Webi for adhoc reporting.
• Data extraction: SAP CRM, GRC, AP / AR / CCA / PCA, SD, LO (Sales and Billing), CO-PA, FI-SL, HR, HSE and generic extractors along with flat file extractions, APD, Open Hub Destination Objects (InfoSpoke) to transfer data from standard Data Store Objects to Flat Files.
• Hands on with Business Objects Designer 4.0, built reports using BO Query designer, Web Intelligence (WEBI) and Xcelsius dashboards.
• Created Bex reports using Query designer, Bex Analyser for Workbooks and displayed reports like Plan/Actual revenue comparison, Order and sales value by sales representatives, Vendor delivery efficiency, Incoming Orders, Sales-order stock reporting, Balance sheet and Profit Loss, structured queries. Free characteristics, restricted and calculated key figures, Variables, formula variables, exceptions and Conditions. Expertise in report generation via Pre-calculation servers.
• Migrating 3.x objects to ver. 7.x, Aggregates, preparing deployment plans, cutover tasks in staging, QA and production systems. Process chains.
• Performance Tuning, Housekeeping, Aggregates, Indexes, Compression, Partitioning and Statistics. Write optimised DSO & creating Indexes, Reporting on Multiprovider(s). Testing: Involved in all testing phases of SAP BI configuration.
• Production support: Multi zone operation, Broadcasting reports, Scheduling of Process Chains of Events, Data source Enhancement, Remote Cubes, MultiCubes, Data Mart and Open Hub Services, fixing errors and daily.
• Enabling real time functionality on cubes, defining / combining of planning functions, Tools, filters, that can be used in queries and planning functions. Planned mode / load mode - Loading data via process chains / front end data entry via BW reporting.

TECHNICAL SKILLS:

RAD GUI Tools: Visual Basic

DBMS/RDBMS: SQL Server 6.5/7.0/2000 , Oracle 7.X, 10, Ms Access 7.0

Web: HTML 4.0, 5.x, 6.x, JavaScript

ERP: SAP R/3 3.0, 4.6b, ECC5, ECC6, CRM5, SAP GRC.

Data warehousing: BW 2.1c. 3.0b. 3.5, BI 7.0, 7.3, 7.4, SAP HANA 1.0, SAP BO, SAP BODS.

Languages: C, ABAP/4, SQL

Tools: Business Objects 4, XI r3, r2, r1, 6.5, WebI 4, XI, 6.5, BEx Query Designer; Xcelsius 2008 / Dashboard Designer. SAP HANA Studio, BO Design Studio 4.0.

Others: Ms Office 97/2000/2007 , 2010, Lotus Notes 5,6,7.x, Visio 4.1/5.0

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Consultant

Responsibilities:

• Flat file data migration to SAP HANA
• Usage of Bex and BOBJ for reporting and analysis.
• Stakeholders engagements, documented requirement
• SAP SLT for transforming, mapping rules at field level.
• Extracted data from different legacy finance systems and then planned their migration into HANA DB.
• Performed various levels of testing like Unit testing / Integration testing and co-ordinated UAT.

Confidential

SAP BI / BO Lead Consultant

Responsibilities:

• POC for BW 7.4 on SAP HANA using Business Objects 4.0 as reporting platform.
• BOBJ using BO query designer 4.0 / Webi for reporting.
• Data migration SD / FI / CO-PA from remote SAP BI systems and re-implement on SAP HANA
• Loading from ECC tables using BODS as ETL tool into HANA Schema.
• Ad-hoc scheduling of data load using BODS
• Enhanced BW architecture to meet ver 7.4 like HANA optimised DSO’s and Infocubes, SPO(s), Advanced DSO(s).
• Redesigned the Inventory model and CO-PA data models in BW for performance based reporting.
• Upgrading 3.x objects to 7.x, housekeeping activity like clearing of error logs and PSA tables, checking various tablespace growth, analysis and control measures within BI.
• Designed and enhanced process chains to facilitate automatic deletion, updating and refreshing of data targets.
• Involved in creating new and modified existing Hierarchies to meet “Drill Analysis” needs of the users.
• Performance stress and volume testing / Regression and UAT
• Post go-live production support.

Confidential

SAP BI/BO HANA Lead Consultant

Responsibilities:

• KPI reporting. Modelling on SAP BI 7.1
• Enhanced existing data models Infocubes / DSO’s Write optimised DSO’s for performance improvement.
• Data extraction and re- engineering on BW data model.
• BEx and BO for report generation.
• New reports on COPA, SD billing and other FI reports, HSE, Climate Change reports, Oil Spillage and Health & Safety.
• Data Provisioning and replication from source system toHANA DB.
• Metadata, replication from SAP ECC tables toSAPHANA using SLT and BODS - Business Objects Data Services.
• Created Process Chains and for automated data loading and performed housekeeping activity.
• Creating SAP HANA information models, Attribute, Analytical & Calculation views; attributes and measures, hierarchies.
• SQL statements, stored procedures, CE calculations.
• Worked across different time zones like APAC, North America and Europe.

Confidential

Senior BI Consultant (Mature)

Responsibilities:

• POC on SAP HANA 1.x Connected to SAP BW and ECC6 using SAP HANA design studio for insurance sector.
• Xcelsius dashboards and SAP BO design studio which includes Key Metrics and YTD reports.
• Migrating standard Infocubes, DSO to In memory optimized Infocubes
• Importing the BW Models in to SAP HANA using HANA Studio.
• Consuming the HANA Models in BW by creating the Transient Providers.

Confidential

Senior BI Consultant

Responsibilities:

• KPI reporting solutions on BW 7.1 for Machine in field, meter reading and serial numbers, expiring contracts, Rental agreement, Service contracts of the copier machines in the market place.
• Data extraction from SAP CRM, 0BPARTNER, FICO, SD, LO Cockpit.
• Workshops / review meetings

Confidential

Senior BI Consultant

Responsibilities:

• Project EVO: BW ver 7.0: New reporting requirement for UK and Ireland business users.
• Attended workshops, design and development of SAP BW reporting.
• R/3 extraction: SAP PS, Sales and Billing.

Confidential

Responsibilities:

• Enhanced and developed BW on 3.5 and Bex reports to reflect Bank currency notes, Counterfeit, mutilated, new & old notes.
• R/3 extraction: FI, SD and Demand Planning.
• Interaction with Business users, Accounting team
• Extensively worked on re-modelling the back-end design.
• R/3 Extraction: HR, CRM and ECC systems. SAP Integrated Planning SAP BI IP - Long Term
• BW enhancements, performance tuning,
• Involved in report generation using BSP application which linked the article code with respective images. Bex analyser was used to display the contents of the report.