SUMMARY

• Over 12 years of experience in IT.
• Experienced as a SAP BI/BW and SAP BOBJ consultant with 4 full life cycle implementations and Post Production experience in design, development and implementation of SAP BW and SAP Business Objects application.
• In - depth working Knowledge of integrating SAP NetWeaver BW on SAP HANA in combination with SAP Business Objects BI 4.x
• Involved as a key member of project teams through all phases of Implementation - Project Preparation, Blueprint, Realization, Go-live, and Post implementation support.
• Working knowledge of SAP reporting from ECC modules such as FI-CO, IM-MM, SD, PM, HR and SRM and SCM.
• Experienced in multidimensional data modelling and working knowledge of both relational and non-relational database design concepts
• Experience in both BW 3.5 and BI 7.x data modeling.
• Expertise in development and maintenance of both standard and custom BW data models.
• Scheduling of batch job and load monitoring using process chains during production support.
• Experienced in universe design using IDT and UDT.
• Report development experience using SAP BW Bex Query Designer, BW BEx analyzer, SAP Business Objects WEBI, Crystal Reports, Analysis for Office and Analysis for Office OLAP
• Experience using data visualization tools such as SAP Lumira, Design Studio and Tableau
• Experienced in Performance tuning techniques using aggregates, compression, Query read modes, Indexes and logical Partitioning.
• Working Knowledge of SAP Business Objects Analysis for Office and OLAP
• Capable of working independentlyas well as in a team.
• Ability to engage with multiple development projects concurrently and working to tight deadlines
• Highly motivated, eager to learn new concepts/skills.

TECHNICAL SKILLS

• SAP BW 3.5
• SAP BI 7.x SAP HANA
• SAP R/3 4.6
• 4.7
• ECC 6.0; SAP LUMIRA
• DESIGN STUDIO 1.3
• TABLEAU 8.4 and 9.0
• SQL 2005 and SQL 2008
• SAP Business Objects XI R3
• SAP BOBI 4.0
• BOBI 4.1
• SAP Solution Manager

PROFESSIONAL EXPERIENCE

Confidential

SAP BI

Responsibilities:

• Developed SAP BW Infocube for Sales Overview reporting
• Developed data loading strategies (ETL) such as Infopackage, Transformation and DTP to load data from ECC (LO Cockpit) to Sales Overview cube in BW
• Build a Multiprovider using a combination of DSO and Infocube
• Created CKF, RKF, Variables and Structures in BEx Query designer based on report requirements
• Developed Web Intelligence reports (WEBI) using SAP BW BEx Query as datasource
• Used a combination of variables, Functions, Formulas, Calculation Contexts, Filters, Input Control, Merged dimension and drill - down to enrich the design of custom webi report
• Build and formatted webi report by applying Breaks, Sections, Query Filters, Ranking, Sorting, Charts and Conditional formatting (Alerts)
• Responsible for report bursting (Scheduling and Publication)

Environment: SAP BW 7.4, SAP ECC SAP BOBI 4.2, SAP LUMIRA

Confidential

SAP BW/HANA

Responsibilities:

• Worked on SAP BW on HANA - BOBJ integration.
• Worked on financial transaction data of Contract Accounts Receivable and Payable for the Public Sector within PS-CD (Public Sector - Collection and Disbursements) module of SAP - ECC.
• Worked on HANA integration with SAP BW 7.4
• Design & Creation of HANA Attributes views, Analytic views and Calculation views
• Creation of Composite Providers to link the HANA Models, Multi-Providers in BW.
• Mapping of HANA View fields from the Calculation Views into the specific fields in BW system
• Created report to show the Schedule of Proportionate Share for Employers of CalSTRS. This report is to assist employers in meeting the requirements of GASB 74.

Environment: SAP BW 7.4, SAP ECC 6.0, SAP HANA 1.0 SPK9 SAP BOBI 4.2 (WEBI, CRYSTAL REPORTS)

Confidential

SAP Lumira Dashboard Developer

Responsibilities:

• Used HANA views (Calculated views) as source data for Lumira Reports and Dashboards
• Worked with private views, query views and reuse views in HANA Live Browser
• Activated HANA Live content within HANA Live Browser
• Developed dashboard reports using SAP Lumira to include all the required KPI’s
• Created a Storyboard using Geo Bubble Chart, Column chart and Line Chart to depict trend analysis in Sales by region, Top products and Monthly Sales to track the sales data of the parent company and its local markets.
• Created Analytic views and Calculation views in SAP HANA
• Performed data replication into SAP HANA tables
• Created Time hierarchy, Calculated dimensions and Filters in SAP Lumira

Environment: SAP BW 7.4, SPS9. SAP LUMIRA 1.29, SQL 2008, SAP HANA Live 1.0 SP8.

Confidential

SAP BI/BW - BOBJ Lead

Responsibilities:

• Translates Business needs to requirements by conducting requirement gathering sessions with end users
• Developed several webi reports based on functional requirement
• Developed BOBJ reports using SAP BW Queryas datasource.
• Created BOBJ universes using Information Design Tool (IDT).
• Developed Insurance treaty and Claims analysis workbook using SAP Business Objects Analysis for Office
• Developed Executive Level Tableau Dashboard visualization for Senior Management
• Developed Crystal Reports using Crystal Reports for Enterprise 4.1
• Performed data reconciliation and resolved variance issues between ECC and BW
• Developed webi intelligence reports as per clients’ request for insurance reporting requirements.
• Provided level 1 production support role for both SAP BW and SAP BOBJ related issues.

Environment: SAP BW 7.3 SP8, ECC 6.0, SAP BOBJ 4.1, IDT, Tableau 9.0