EXPERIENCE SUMMARY:

• SAP Consultant with 12+ years of experience in SAP BI/BW4HANA/ BOBJ / NATIVE HANA - Involved in Projects based on Implementation, Upgrade and Production support. An associate of Confidential as a Technology Lead from the year 2010 and worked in Confidential as Assistant System Engineer from .
• Expert level Business Consulting experience in Analytics area with focus on SAP BI-BW, Native HANA and Business Objects playing Lead roles.
• Good knowledge of HANA modelling and scripting including writing stored procedures and development of HANA views using SQL and graphical. High level knowledge of various replication methods to HANA and various reporting techniques on top of HANA views.
• Good in programming with ABAP and SQL. Have done the native Hana modelling and BW related modelling through BWMT.
• Worked extensively in Retail domain with exposure in POSDM.
• My technological forte is SAP BW 7.3/7.5/BW4hana/Native Hana, SAP BOBJ & Tableau.
• SAP BW/HANA certified Application Associate.
• Hands on Experience and Technical Proficiency in ETL Data Extraction, Data Loading, Data Modeling, DSO Objects, Info Cube, Multi-Providers.
• Experience in LSA++ standard model with creation/converting to new BW7.5 modelling Objects ADSO, ODSO, Composite provider.
• Involved in upgrade from BI 7.0 to 7.3 & BW migration from Oracle to HANA
• Strong experience in various phases of a project including analysis, design, development, configuration, testing, as well as documentation, and end-user specifically focused in
• SAP BI for various versions ~ BI NW 7.0, NW 7.3, 7.5 & Hana.
• Mixed Modelling with Hana views and Hana optimized BW objects and used them as source to Calculation views.
• Involved in: Data load management, ETL, experience in Scheduling, Process Chains of Events, loading (Full Init / Delta Load), Monitoring, and involved in broadcasting of the reports.
• Extensively worked on DTP functionalities like enhanced filtering, DTP monitoring and Error DTP stack.
• Responsible for Creating, Modifying and activating business content extractors, Info Objects, Info Cubes, Multi Providers and DSOs according to the reporting requirements.
• Experience working on remodeling of Info cubes to improve the performance issues using Aggregates, Rollup, Indexing, Partitioning, and Compression.
• Involved in Building and transforming data using Open Hub Destination and analysis process designer.
• Enhancing of data sources for extraction using ABAP code according to Customer requirement.
• Involved in Technical POC/POV for projects and contribution to SAP Center of Excellence (COE) by delivering sessions on upcoming technologies.
• Experienced in interacting with business users to analyze the issues which they are experiencing, documenting and rolling out the deliverable.
• Lo Cockpit, Exposure to generic Extraction, Activating Data Sources and Setting of V3 update Deleting Setup Tables and Data Loading (ETL).
• Experience in creating Info Package to create Process chains and Scheduling of data loading with Full/Initialization/Delta upload method as a part of ETL.
• BEX Reporting: Extensively worked with query designer conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables
• Involved in Production Monitoring of SAP BW application with the more that 85 process chains and performed performance tuning activities, document the issues and train end user.
• Experience in testing front end reports and optimizing the performance.
• Experience in managing the team from off shore (India) to get the delivery done on time to meet the SLA.
• Proficient in data modelling using BW extended star schema model
• Proficient in Evaluating Requirements and implementing BI solution for Clients
• Extensive Experience Implementation, Developments as well as Production Support projects
• Performed extensive Logistic extractions, Finance and generic extractions
• Worked on queries using Bex Analyzer and Bex browser.
• Accomplished SAP BW/BI Trainer.
• Extensively used Multiproviders, structures, variables, exceptions, conditions, restricted and calculated Key Figures in reporting
• Experience in Performance Tuning of extraction and routine codes.
• Proficient in handling support projects. Analyzed and corrected production problems as they occur in the SAP BW system.
• Experience on implementing BW 7.4/BW 7.5/BW4HANA, Worked on Graphical Data Modelling objects such as Advance-DSO, Composite provider, Semantic providers.
• Experience on SAP Business Objects 4.2
• Experience working on Lumira 2.0 and Analysis Office for excel.
• Experience on Crystal Reports.
• Experience on Universe design tool and Information design tool.
• Experience on Webi and have developed reports based on BW, Netezza and AS-400 as backend.
• Involved in CMC (Central Management Console) with User creation, Group Creation, and provides the rights of the users, Folder Maintenance.
• Experience on SAP Business Objects 4.2 Dashboard Builder, Web Intelligence, OLAP Analysis, Explorer
• Developed reports Business Objects Dashboards/Reports for Mobile devices. (MOBI)
• Extensively worked on HANA Studio
• Extensively worked on Attribute View, Analytical Views, and Calculation Views.
• Experience in replication scenarios on SAP landscape transformation (SLT) Sybase Replication Server with operational reporting
• Strong experience on SAP BW HANA ( BWoH )
• Worked on SAP HANA Smart Data Access.
• Have reporting experience using HANA and Business Objects and MS Excel.
• Experience with SQL, SQL Script and Store procedures in SAP HANA
• Worked on Currency Conversions in SAP HANA
• Extensively worked in Advanced DSO, Open ODS View and Composite providers.
• Worked on Start and End routines in Transformations
• Experience in enhancing the Data sources
• Experience in developing customer exits for reporting.

TECHNOLOGY:

ERP: SAP BW 7.3 / 7.5, BW4Hana, Native Hana

Visualization tools: SAP Bex Query Designer, SAP Business Objects, Analysis Office & Tableau

Externals Tools: Tidal, Jira

Databases: SAP HANA, SQL, Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue

Sr. Consultant

Landscape: SAP BI, SAP BW4Hana, Native Hana, Netezza, ABAP, BO WEBI, Crystal Report, Analysis office, Tableau

Responsibilities:

• Gathering requirements from the end users and preparing business requirement documents and get reconfirmation from the business users.
• Created gap documents and gap analysis for all demand planning, Sales and operational report.
• Lead BW HANA 7.5/BW4Hana upgrade project and guided team to resolve post upgrade data and performance issues.
• Designed HANA data models (attribute, analytical and calculation views) and stored procedures Implemented data provisioning using SLT, SDA.
• Worked on Composite provider by creating virtual providers using HANA views to design the report on actual data which is coming from BW and planning data ‘which being uploaded’ from flat file into HANA table. Created SAP Hana Graphical views and star joins as per the business requirement.
• Worked on Open ODS view and created reports on this for prototype of design. Extensively worked on BW Virtual providers based on HANA views to get the data from HANA. And created BW Real time reports using these virtual providers. Worked on SLT to replicate ECC tables for various functional areas to meet user’s report requirement.
• Worked and activated HANA information models which are required for real time reporting from BW point of view.
• Exposed ADSO/ Master data as Hana views and used them as source to Calculation views.
• Created composite provider based on calculation view and ODSO. Exposing the views to be consumed in visualization tools like SAP BOBJ, Tableau.
• Worked on ABAP routines such as Start Routines, End Routines, and Field Routines.
• Building SAP HANA views and unioning multiple views to provide a single source of truth. Building Adhoc SQL Queries to analyze raw data before finalizing the requirement and Design.
• Performed administrative tasks such as Promotion management, job scheduling etc. Maintain Audit database and prepare the report usage data for monthly statistics dashboard.
• Designing, developing and testing the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Prepared daily and month-end Desktop Intelligence reports for forecasting, renewal analysis for the business users having different formats like Crosstab, Listed Reports.
• Developing Web Intelligence reports and scheduling and sending the reports to the users through Info View.
• Scheduling the reports through CMC and forming user groups and giving them access to folders and rights to do various operations on reports through Info View and WebI.
• Designed and developed standard and summary reports SAP BOBJ based projects having SAP BW/Netezza/ AS 400 at backend.
• Design and Development of BW BOBJ reports based on multiple data sources like SQL, SAP CRM, ECC and SAP BW/HANA
• Resolving reporting issues within SLA: Crystal report, Web Intelligence, Analysis Office, Information Design Tool and Universe design Tool.
• Worked on Business Objects Administration like CMC and CMS maintenance & security issues.
• Worked on deployment activity using Promotion Management for DEV, QA and PROD environments.
• Involved in presales activities like preparing Statement of work, Project task distribution, deliverables, Project risks, assumptions and exclusions.
• Design/Build of ETL/Reporting using Business Intelligence /Analysis Office for Excel and Business Objects tools.

Confidential

SAP BW/BOBJ Developer

Landscape: BI 7.4, ABAP, Hana, BO WEBI

Responsibilities:

• Involved in project kick-off discussions and creating the Technical specifications.
• Coordinating with the Business Analyst Team and Database Team to make the Technical Design Specifications derived out from Business Requirement document to capture what changes are required in current BO reports and universes.
• Perform in-depth data analysis and translate specifications into a working universe and/or reports. Making the derived objects in the universes using formulae.
• Modifying the Universe to include new tables and joins, adding prompts, new classes and objects, derived tables, aliases, shortcut joins, adding cascading objects.
• Modifying the existing reports to add the new objects, adding the hyperlinking to the other reports.
• Unit testing and integration of reports directly through BO and Java UI. Supporting the reports in production environment.
• Resolving and updating the bugs in HP Quality Centre. Interacted with customers and Developed a high-level implementation plan, selected project team, plan
• Determine Landscape and Transport Strategy along Basis team, Acquire, Install and Test the Technical Environment (hardware, software, database, desk top and connectivity - Basis)
• Finalized a list of pre-delivered business contents to be activated by functional components, data sources, Info Cubes, Info Objects, Queries, and roles
• Assigned responsibility for each component Agree upon the instrument (template) to record the test result and additional requirements, develop evaluation criteria and test plan, Check database parameter setup for performance Prepare end user material. Coordinated and Implement Production Scheduling, Develop a BW Operations Guide.
• Handling the issues experienced while transporting the newly developed objects across the landscape.
• Spearheaded Business Contents Activation, Populate SAP delivered business contents with customer data, Verify the content activation Result, Conduct End User
• Conducted System Tests with End User Feedback, Conduct Volume Test, System Performance Tuning,
• Maintained and Enhanced Universes based Webi reports based on business requirement.
• Good exposure in using SAP market place and forum and working with SAP Support Engineers in SAP tickets.
• Enhanced Operations Guide, Monitoring and addressing production issues, if any. End user support, Project Go-live Review, Define the Scope of next Iteration of Implementation

Confidential

SAP BW/HANA/BOBJ Consultant

Landscape: BI 7.4, Hana, ABAP, BO WEBI - Crystal Report, Analysis Office

Responsibilities:

• Lead a 16-member offshore team through the preparation of high level design, detail design, development, testing and migration of SAP BI back end objects and reports.
• Worked as a BW Hana/BO Consultant on enhancements, implementation as well as production support.
• Designing, developing and testing the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Wrote various routines logic for looking up data based on the requirement to do calculations for projects and created Open Hubs & APDs to give data over to outbound interfaces.
• Worked with Business content extractors for General Ledger, Material Management, Sales distribution, Account Payables & Account Receivables to extract data from SAP R/3.
• Designed and Modeled BW backend development Involved in creation of reports using Query Designer such that by using Conditions, Exceptions, Free Characteristics, Restricted Key figures, calculated key figures, user entry Input Variable and formula Variables.
• Worked in migration from oracle to Hana DB and resolved all post migration issues.
• Extensively involved in activating the Business Content for Info cubes, DSOs Data Sources, Multi Providers as well as Created Custom Info cubes, DSOs, Multi providers & Transformation from Data sources to DSO and DSO to Info cubes. Doing data validation of the reports.
• Designing, developing and testing the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Prepared daily and month-end Desktop Intelligence reports for forecasting, renewal analysis for the business users having different formats like Crosstab, Listed Reports.
• Developing Web Intelligence reports and scheduling and sending the reports to the users through Info View.
• Scheduling the reports through CMC and forming user groups and giving them access to folders and rights to do various operations on reports through Info View and WebI.
• Preparing the end user documents and ensuring the Quality of the deliverable products.
• Extensively involved in creating a BEx Reports (Global Position Query) where I used Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Customer Exit, and Used Variables with User Entry/Default Value. Handled Change Requests (CR’s), service requests (SR) & enhancements
• Worked with SAP R/3 Logistics (LO) and Hands On functional area like Sales distribution (SAP SD & MM).
• Handled the tickets of priority 1, 2 and 3 by following (SOP) Standard Operating Procedures. Supported client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Involved in complete life-cycle implementation of SAP BW 7.0, which includes data modeling, data extraction, data loading, and Reporting and support activities.
• Reporting - created Custom Queries using Conditions, Exceptions, Variables & Structures and created aggregates for frequently used queries and Proficient in designed BEX Query Designer, Structures, Exceptions, free characteristics, restricted key figures, calculated key figures, and different types of Variables with different processing types.
• Developed KPI Webi Reports by accessing universe and Bex Queries. Created Web Intelligence Reports with query filters, grouping according to the user requirement.
• Finalizing the requirements, designing the solution, developing and testing the solution and supporting during user acceptance testing
• Worked with Basis for various support activities for upgrades, system refreshes, patch installations etc.
• Made the Changes in the Query according to Business requirement. Supported during UAT, go-live and post-implementation phases

Confidential

SAP BW/BOBJ Consultant

Landscape: BI 7.4, ABAP, BO WEBI

Responsibilities:

• Responsible to gather requirements from business users and coordinate between onsite and offshore team.
• Involved in converting the requirement document into functional and Technical design documents.
• Responsible for developing Cube, DSO, Multi Providers, Transformations, DTPs and handled test loads using Transformations, Info Packages, DTPs to verify BI 7.0 functionality.
• Worked on Generic, File system and LO Extraction to meet data requirements.
• Involved in the enhancement of data sources, appended the vital fields by writing the exit code.
• Build / Leading BUSINESS OBJECTS team which built reports based on top of queries. Created Webi Reports using various functionalities like cross tab, conditional formats, Break, Built in functions.
• Built IDT data federation / Business Layers over HANA views to be used for webi reports.
• Working on complex solutions like pulling data in a table from multiple queries, building custom hierarchy in webi reports.
• Transported various objects from BID to BIQ to BIP after completion of successful testing by using SE09 and STMS.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting using BEx Analyzer, Designed and developed several workbooks and global views. Worked with other teams to ensure outbound interfaces are working seamless.
• Created routines in Transformation as per customer requirement. Involved in Building and transforming data using Open Hub Destination and Analysis process designer.

Confidential

SAP BW/BOBJ Consultant

Landscape: BI 7.4, ABAP, BO WEBI

Responsibilities:

• Job monitoring and scheduling Process Chains and Fixing Process Chain failures during data extraction. Analyzed and corrected the load failure.
• Manual data load using Flat files whenever user wants to load file.
• Involved in tuning the performance of the system.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Experience in the Transport Management activity of importing the transports among various SAP systems
• Generated and maintained aggregates and rollup activities on info Cubes as part of the info Cube management
• Creation & Modifications of queries as per the NG business Request.
• Responsible to acknowledge any issue raise by the users and solve it within the SLA ((P3, P4, P5) defined by the customer.
• Change Request based development of BW objects. Delivery from offshore with a team of 3 BW Consultants.
• Worked in the R/3 side for adding fields in Generic Data Source and standard extractor.

Confidential

SAP ABAP Consultant

Landscape: ABAP/4

Responsibilities:

• Extensively worked on SPAU, SPDD activities, Implementing OSS Notes etc., for the ECC 6.0 upgrade.
• Modified the BDCs that need to be addressed because of the screen changes by SAP in ECC 6.0.
• Analyzing the relevant OSS notes that are applicable for the current version of ECC 6.0 and applying the same
• Preparing the test scenarios for the programs that are modified as part of the ECC 6.0 Upgrade

Confidential

SAP BW-BI Consultant

Landscape: SAP BW-BI 7.0

Responsibilities:

• Responsible for the Production Support Activities performed at Offshore
• Monitored the Loads of master data and transactional data through process chains
• As part of loading we schedule the process chains on daily, weekly and monthly basis to load the data into respective targets
• Monitored Process Chains and Meta Chains, worked to fix errors; Sid issues, duplicate data records, Activation of DSO errors, memory issues and Timestamp errors, etc. with respective corrections
• Performed Data Extraction and Data Staging using LO Cockpit (LBWE), loaded the data from ECC6.0 to BI7.0 used Initialization with Delta Update methods
• Involved in planning of Data reloads activities
• Worked on Broadcasting and pre-calculation servers, Created Broadcast setting for queries and workbooks to publish the reports to the users via E-Mail
• Performing test data loads in mirror systems before transporting changes to production server.
• Involved in solving tickets regarding extractions, Performance Issues and load failures.
• Worked on BI stabilization project where the teams from SAP and service teams are involved to stabilize the system and improve the data load SLA’s.
• Proposed many Process Improvement Plans (PIPs) which were implemented for best practice.
• Involved in validating and checking the reports for the customers so that correct data is been updating on regular basis.