TECHNICAL SUMMARY

• 8 yrs of years of experience in SAP BW 3.5,4.0,7.0,7.3,7.4, SAP BO XI R2, XI R3.
• Good experience in SAP HANA 1.0 SPS4- SP8 .
• Designing the data flows to load the data from non-SAP source systems to SAP HANA.
• Good Knowledge of SAP HANA Modeler HANA Studio , Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytical Privileges, Procedures.
• Worked on SAP HANA for E3 billing invoice and Reporting on SAP Native.
• Lead full cycle SAP HANA sizing and pre-procurement planning.
• Embedded all the calculation in HANA Analytical View and Calculation View.
• Developed custom function to save the invoice data in the HANA tables for recording and auditing purposes.
• Worked with exiting BI team to integrate What if reports using native HANA, Webi4 and Dashboard.
• Day to Day SAP HANA Administration and Support.
• Design and Build multiple universes for information model consumption.
• Conducted 5 day on site training on SAP HANA for BI team.
• Build the Sandbox, Pre-Development and Development SAP HANA environment in Cloud Share environment.
• Leverage SAP SLT and Business Object Data Services BODS to acquire the data into SAP HANA DataMart Native and BW on HANA
• Experience with multiple full life-cycle implementations in SAP BI/BW, Business Objects adopting ASAP Methodologies which involves Requirement Workshops, Gap analysis, Business Blue-Printing, Realization, Data extraction, Data modeling, Data loading, Production Support, Testing, Documentation, Requirement analysis, End user documentation, Reporting and Go-Live Check.
• Expertise in business warehouse components Info Objects, Standard and Custom Info Cubes, DSO's, Info packages, DTP's and Transformations.
• Expertise in Data-Modeling Multiproviders, Info cubes, DSO, Remote Cubes, Master Data, Process Chains , Extraction LO Cockpit, non-SAP, Flat files Generic Extractors using FI-CO, MM, AP, AR, GL .
• Proficient in creating Data models and Data flows using the Wizards in BW 7.3 and proficient in designing hybrid Providers and Semantically Partitioned Objects.
• Excellent knowledge of BW system, Data Warehousing concepts including data modeling, ETL, Query, Report Design, BW Web Reporting and Open Hub Service.
• Experience in ABAP/4, Update/Transfer Routines, BDC programming. Expertise in using Start Routine, End Routines and Expert Routines for Complex data transformation Requirements. Experience in creating DTP Filter Routines and Info package Routines User Exits.
• Experience in the configuration and implementation of the Process Chains for the regular data loads and scheduling and monitoring the data loads.
• Expertise on OLTP extractions from SAP R/3 and products like CRM, SCM and SEM using LO Cockpit, CO-PA, LIS, Generic Extractors and non-SAP R/3 extractions using DB connect and also extracting data from flat files.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, partitions, and Info cube compression techniques.
• Extensively worked on Reporting tools like BEx Analyzer, BEx Query Designer, BEx workbooks, Web Application Designer.
• Expertise in using Universe Designer over BEx queries and Info Cubes to migrate model data from BI to BO for reporting. Excellent skills to develop reports using Webi. Valuable knowledge of Crystal Reports.
• Experienced in SAP BW front end tools BEX Analyzer, Query Designer and Web Application Designer WAD and also experienced with Report-to-Report Interface RRI .
• Experience with Calculated Key Figures, Restricted Key figures, Structures, Characteristic Variables, Text variables, Exceptions and Conditions.
• Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite.
• Design and build Data load using Business Object Data services BODS and mix of SLT.
• Design and developed complex SQL script for all the calculations for Feedstock Report Maintenance Control Report and Net Balance Statements.
• Build multiple reports and dashboard using Webi4, BO Dashboard Xcelsius and crystal report and BEX Reporting.
• Experience in BO 4.0 including Crystal Reports 2011, Dash Board Design, Information Design Tool, BI Launch Pad, Web intelligence Rich Client, Universe Designer Tool, BO Explorer, Analysis Edition for OLAP,BI workspace, BO widgets, managing Central Management Console CMC , Upgrading CMS using Upgrade management Tool.
• Worked with LCM Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA, and Prod .
• Enabled Single Sign on SSO feature, imported SAP BI roles into Business Objects, enabled automatic imports of SAP BI users, managed users, applications, security, Universe management, groups in Central Management Console CMC .
• Experience in exploring the data using Information Spaces in BO explorer 4.0.
• Enhanced Performance of BOBJ REPORTS.
• Good understanding of SD, MM, FICO, HR, CRM modules.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: SAP HANA /BW /Business Objects Consultant

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Assisted SAP Basis team in installing HANA 1.0 and solely integrated it with Business Objects 4.0 and BODS4.0.
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.
• Installed BOBJ 4.0 and BODS 4.0 and configured SAP and Windows AD authentication for Business objects enterprise.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Created Technical specifications and standard modeling documents for HANA.
• Architect and design SAP HANA SP4 three tier landscape for Maple leaf food HQ and Frozen Bakery business diversion.
• Design and integrated exiting BODS and SAP SLT with HANA.
• Develop ETL Jobs with very heavy transformations for data acquisition from SAP ECC and Non SAP systems.
• Data Load via SAP BW extractors DXC to HANA from Legacy BW.
• HANA information model design and build which includes Package, Attribute View, Analytic View, Calculation View and Schemas.
• Design SAP HANA data model information Views for report consumption with time dimensions.
• Develop SQL scripts and functions for complex reusable scenarios in HANA.
• Created HANA database users, role, analytical privileges for data and data model security.
• Developing reports on Calculation View / Analytic View using Webi3 and Webi4/ Explorer.
• Configured CO-PA HANA Accelerator/RDS.
• Build SAP FI, SD data to build information model for user consumption Attribute View, Analytical View, calculation View .
• Build multiple universes for reporting data mining needs.
• Build multiple reports and dashboard using Webi4, BO Dashboard Xcelsius , and Crystal Report, BEX reporting and Visual Intelligence
• Configured SAP HANA Finance and controlling rapid-deployment solution RDS .
• HANA model development for non-SAP Databases and application.
• Design and build SAP HANA Universe Business Layer .
• HANA and BI integration point optimization.
• Developed CO-PA and ODS date models and reporting.
• Worked with Power user from different business units design traditional and HANA universe.
• Created 100 plus interactive analysis for Inventory Analysis, Income Statement and Balance Sheet using Webi4. Building filters, using prompts, creating merge queries and linked reports with breaks. Integrating Financial Statement Versions as Hierarchies in Webi4 documents over HANA engine.
• Worked in SD, PM, MM and FICO modules.
• Create printable reports for actual verses plan data using Crystal Reports for Production, Sales and Revenue.
• Integrated Microsoft Office to HANA reporting build scale out HANA design for growth and performance boost and disaster recovery.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID's for developers, super users, and end users.
• Working with SAP BI and BOBJ Business users, Project managers, and involved in requirement gathering, analysis and creation of best practice architecture.
• Created SAP Business Objects SAP BW 7.3 Roadmap document, functional and technical specifications for seamless integration and reporting.
• Worked with SAP BO, BI, Basis, and R/3 teams and involved in providing integrated solutions.
• Management, Folder management in Central Management Console CMC .
• Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file data sources.
• Designed BICS connection in BI 4.0 - on top of SAP BEX queries, enabled OLE DB for OLAP .
• Designed .UNX universes using information Design Tool on various source systems including BW 7.4 As relational source .

Environment: BODS 4.0, BOBJ4.0, HANA 1.0 SP3, SAP BW 7.4, SAP ECC 6.0, Linux, MS office, Visio, MS Outlook.

Confidential

Role: Sr. SAP BO/BW Consultant

Responsibilities:

• Responsible for requirement gathering by working with business and technical users, analysts, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
• Worked closely with Production Planning PP , material management MM , Sales and Distribution SD , Logistics LE , Financials FI AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash, Procure-To-Pay, Point of Sale POS data via Data Stage and other integrated solutions.
• Involved in installation, configuration of BO tools and SAP BI integration with SAP Business Objects using SAP Integration Kit.
• Developed Business Objects BO utilities and scripts and extracted, transformed and loaded data marts, extended Business Objects Rapid Marts for analytical reporting, using Data Integrator.
• Designed data models as per the System landscape, created Functional and technical BW specifications, considered proper data modeling techniques and data management strategies and created Technical BW Specifications for BW Objects.
• Installed and configured SAP BW Business Content, created Documentation on existing business processes, and documentation for testing and support of BW Objects, Processes and Practices.
• Captured the BW data elements required by the end users and extensively involved in analysis, design, development, configuration, testing, deployment of BW Objects Info Objects, ODS, DSO, Info Cubes, Info Sets, MultiProviders, Info Sources, Data Sources and corresponding extract, transformation, communication structures .
• Developed and deployed the technical and best practice methods for extracting financial vendor data from SAP R/3 via FI delta enabled extraction methods.
• Mapped POS with IS-Retail interfaced sales financial transactions from POS to SAP IS-Retail using IDoc technology, executed data migration plan and helped retailers understand POS data better and respond in time.
• Implemented the BI 7.0 concepts of Transformations and DTPs using the existing data source migration and involved in up gradation and migration from BW 3.5 to BI 7.0.
• Worked with SAP ABAP team and created code that will result in the highest performance possible.
• Utilized an EDW approach to store all the data in a 1:1 ratio in a staging ODS.
• Involved in loads initialization in SAP BW system followed by extraction LIS/LO Cockpit extraction, FI, CO-PA extraction from SAP R/3 system and Non-SAP systems and scheduling regular Full Loads / Delta Loads using Process Chains.
• Used DB relevant techniques and maximized DB performance, data modeling techniques and maximized query performance.
• Created Crystal Reports on queries that were built on BEX Query Designer and wrote complex queries including Sub Queries.
• Designed and Customized OLAPuniverses based on SAP BW MOLAP Application .
• Designed various reports using Web Intelligence using the Universes built.
• Responsible for the Designing the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis.
• Widely used Drill mode and Slice and Dice techniques to modify the reports in accordance with user's analysis needs.
• Worked extensively on Designer, Web Intelligence web I , Desktop Intelligence Desk I , Crystal reports, Xcelsius and Central Management Console CMC .
• Developed Complex Reports Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts
• Used QAAWS, Live Office connector and built Xcelsius Dashboards and used Crystal Xcelsius to create visualization for excel data
• Involved in designing, developing, testing Front End Solutions, BW queries as needed by users, also designed and developed web reports using Web Application Designer WAD and exported Business Explorer BEX reports to web pages.
• Transported web templates from WAD to Enterprise Portals by creating I views and published queries on the Web / client Portal
• Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager
• Worked extensively with SAP BASIS team in regards to moving Transport Requests and worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles.
• Involved in developing and conducting extensive Unit testing, Integration testing FIT , Regression testing, User Acceptance Testing UAT and documenting the tests and results
• Provided Knowledge transfer KT and Training to BW team members and Super Users on Green Street Project, FI-AP Analytics Project and guidance to team members on Excel-to-SAP project related to Manufacturing during all phases of project
• Involved in Realization, Final Preparation, Go-Live and Post Implementation, developed production support plan and resolved production support issues.
• Created Service Level Objectives SLOs , Solution Documents with the BW team that will guide the production support team when issues occur.

Environment: BI 7.3, Business Objects XI 4.0, BEx Analyzer, Query Designer, HPQC, Web Application Designer, Web Intelligence, SAP R/3 6.0 FI module.

Confidential

Role: SAP BW/Business Objects Senior Consultant

Responsibilities:

• Involved in complete life cycle implementation of SAP BW.
• Participated in the Blue Print stage to design the Fill Rate Schema at Order level, Item Level and Quantity Level.
• Extracted the Transaction data from SAP R/3 systems using LO cockpit.
• Customization of info cubes ZSD C13 and ZSD C12 based on 0SD C13, 0SD C11 and 0SD C12 and additional fields from Client.
• Created transformation rules, start routine and end routines, info packages and data transfer processes.
• Writing ABAP routines: start routines, end routines rules.
• Implementation of start routine to filter out auto-generated records for vendor consignment goods movements and customer consignment goods movements and to only load the records with particular sales organization.
• Development of DSO's, info objects and the Data Flow according to functional specifications.
• Used Write-optimized DSO's for staging huge volumes of data.
• Created : Process chains, Multi Providers, Info Sets, DSO's, Aggregates
• Fine-tuned the data flow, for improving data load performance.
• Setting up Monitoring Process chains for the complete data extractions and Loading.
• Created queries reports for Sales Order Fill Rate by Header, Item/Qty Fill Rate by Air Craft Model, Order Qty/Item Fill Rate by Plant and Top 50 Materials Delivered Late.
• Created queries reports using calculated key figures, variables, exceptions, conditions.
• Broadcasted reports through E-mail Portals.
• Developed, managed, and updated data models, including physical and logical models of the data warehouse.
• Checking data consistency, aggregates and hierarchies through RSRV.
• Implemented number range buffering for the loading performance.
• Created OLAP Universes using BOE XI R2- Universe Designer on top of SAP BI queries and Info Cubes / Multi Providers created/modified classes, objects, dimensions, measures and details.
• Created RDBMS Universes using Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts.
• Used Query as a Web Service QAWS , MS Live Office connector and built Xcelsius Dashboards and used Crystal Xcelsius to create visualization for excel data.
• Created queries and reports, Web Intelligence Web I documents in Info View and created Web Intelligence Web I reports on top of the Universes created using the Designer.
• Utilized/managed various components of Business Objects Enterprise BOE XI R2 - Web Intelligence Rich Client, Central Configuration Manager CCM , Central Management Server CMS , and Crystal Reports.
• Worked with SAP Basis and BI teams and involved in upgrading the SAP BI support package to SP21, installed Business Objects Enterprise XI R2 SP2 Integration for SAP Solutions.
• Created/Edit queries and reports in BOBJ - Info View for multidimensional analysis and trained users on drill-down, cross-tab, master detail, slicing and dicing, ad-hoc reports by Web Intelligence Web I , scheduling and publishing to BO Inbox, email, FTP, .. in multiple formats html, pdf, xls
• Created Crystal Reports from multiple sources and functionalities like slice dice, drill down.
• Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager.
• Provided Training to BOBJ Business Users, team members and created end-user training material and documentation.

Environment: BI 7.0, Business Objects XI 4.0, Crystal Reports, Xcelsius 2008, WEBI, BEx Analyzer, Query Designer, WEB Application Designer, SAP R/3 4.7 MM , SD FI-CO modules.

Confidential

Role: SAP-BW developer

• Involved in complete life cycle implementation of SAP BW.
• Extracted legacy Transaction and Master data from flat files
• Extracted data using SBE to Info Cubes: Overall Demand Planning, Plan/Actual Comparison of Sales quantities, Global capacity Utilization, Global inventory overview.
• Queries: Order Forecast, Demand/Supply match planned quantities, Global capacity, Global capacity utilization, Global inventory overview.
• Queries Developed: Number of Vendors per Category, Invoices per Account, Splitting the Total Purchase Value over Time, Invoice Values per Category, Top 15 Categories Vendors.
• Data Targets : 0SR FIC01 On the basis of this Info Cube, reports were developed to analyze by vendor, category or product how much money the company has spent for which material group, or for which account, over a certain period of time.
• Involved in requirement gathering for functional areas in FI-AP, FI-AR and CO-PA.
• Did LIS extraction to get SD data: Characteristic Catalog, creating info structure, creating updating.
• Enhanced the Accounts Receivable: Line Items 0FI AR 4 Info Source to include Business Area House Bank
• Enhanced the standard structures Accounts Receivable: Line items 0FIAR C03 and Accounts Payable: Line items 0FIAP C03 line item to include profit centers
• Worked on Asset Accounting Cubes like Annual Values 0FIAA C02 and Annual Values and Transactions Cube 0FIAA C04 .
• Extracted data from FI-AA extractors: Posted Depreciations periodic values , Annual Values and Transactions.
• Created the transfer rules, update rules, transfer routines and update routines for CO-PA extraction.
• Worked on Authorization objects, Transports, Releasing requests.

Environment: SAP R/3 4.7, BW 3.5

Confidential

Role: SAP BW/APO Consultant

• Support for SAP APO GATP system running at different Ericsson sites located globally.
• Primary responsibility is to solve issues reported by users. Resolved cases which were business critical and customer centric thereby assisting the client in better customer service.
• Worked on issues related to Back Oder Processing, Product Allocation Procedure, Rule Based Availability Check, CIF issues, Live cache.
• Supporting ABAPers in debugging issues related to technical specifications
• Proactively monitoring system to check and fix any inconsistency queues, Process Chains of data between R/3 and APO system
• End to End testing of demands placed by users
• Collaboration and interaction with other support vendors of Ericsson HP, IBM for resolution of interface issues and smooth operation of R/3 and APO system
• Preparation of report on system performance and presenting the same to the client on regular basis. Also providing improvement points on the same
• System validation for monthly release and giving AO sign off for system release to end user
• Done end-end testing of all business processes involved during Technical upgrade.
• Extensively involved in monitoring the Process chains and Data loads and resolving the production issues.
• Responsible for job schedules for loading Master data Texts, Attributes and Hierarchies .
• Involved in solving high-prioritized tickets regarding extractions and load failures.
• Analyzed the errors that occurred during the data loading and solved the issues for that occurred during the activation process of the objects.
• Designed and developed Process chains RSPC for master data loads and transaction data loads with the help of Info Packages. And these Process chains were scheduled for periodic loads.
• Worked on the performance tuning the queries by maintaining aggregates, indexes and compression on Info cubes.
• Resolved Post-Production issues like rescheduling process chains to meet user requirement etc.
• Experienced in development of project documentation, testing materials and execution, training materials, requirements gathering including downstream and upstream interface requirements and adhering to a project management.
• Used LO Cockpit extraction for sales order data, the data sources used for extraction were 2LIS 11 VAHDR Sales Doc header , 2LIS 11 VAITM Sales Doc item and used extractors 2LIS 13 VDHDR for billing data