SUMMARY:

• 12+ years of professional SAP BI/HANA/BW consulting experience with customers across Oil/Gas, Manufacturing, Retail and Fashion industry in functional areas SAP SD, MM, PP, FICO, PS, HR, CRM.
• Experience in optimizing, performance tuning Native HANA, BW on HANA based on SAPs proven best practices and standard design principles.
• Strong ABAP programming, analytical, problem solving and debugging skills
• Extensively involved in business requirement gathering, GAP analysis and converting the business requirements into preparing the functional and technical specifications accordingly.
• Expert in HANA, BW on HANA, BW modeling with best practices
• Expert in integrating non - sap data to sap BI, SAP Hana by designing best data provisioning ETL techniques, data flow and reporting solutions.
• Fine-tuned BW/HANA with ABAP and recommended corrective action
• Handled complete BW Architecture, Design and Integration with HANA, BW on HANA, BOBJ 4.x using layered scalable architecture++ (LSA++) with build up of hybrid Confidential /BI application
• Strong in automating the data loads by identifying and eliminating manual process steps in reporting solutions. Expert in data recovery and work plans.
• Expert in delta enabling existing and new data sources. Expert in LO implementation, enhancement, with delta relevant new user defined fields
• Very quick in finding the root causes of production issues and designing quick fixes and robust solutions for making the BI Landscape stable.
• Experienced as SAP BI/BW Architect and hands-on developer of both traditional BW and BW on HANA with experience in design documents for BW on HANA
• Hands on in SQL Scripts, Procedures and SQL calculation views in HANA
• Experience with data extraction from SAP/Non-SAP Source Systems using SLT, BODS, SDI and SDA.
• Extensively worked in supporting large user groups in training, developing user manuals and navigating users in different report requirements
• Knowledge of S4 HANA for real time reporting and positioning BW with S4 HANA CDS Views based on SAP best practices
• BW 7.4 on HANA: Open ODS view using Hana tables and virtual tables using SDA, Composite provider, ADSO, Field based and IO based modelling, SAP Hana Live, Migration from LSA to
• LSA++, modeling using Hana Live
• BI Modeling: Info Cubes design, Info Sources, Info Object maintenance, ODS/DSO Objects, Creating Update rules, Transfer rules, Transformations, DTP’s, Open Hub Destination etc.
• Customizations and Extraction: Data source enhancements, Generic Extractors, User Exits, Logistics Cockpit configuration and customization, Transformations, update rule
• BI Reporting: Built custom queries, BEx Analyzer, BEx Query designer, Webi reports with sections, breaks, Dashboards using Bex query, Query as web service, Analysis for office and Analysis for OLAP, BO Explorer
• SAP HANA: information modeling using attribute, analytical, calculation views using sql scripts and CE functions, data provisioning SLT, DXC, Business objects data services (BO DS), Reporting on Business objects 4.x Explorer, Webi, Analysis for OLAP, Dashboard
• Hands-on experience in designing custom INFO Objects, Data Sources, Info Sources, ODS/DSO Objects, and INFO Cubes.
• Strong production support experience involving data load monitoring, data load fixes, etc.
• Extensively worked under Onsite/Offshore model for support activities.

TECHNICAL SKILLS:

SAP BI NetWeaver 2004s/ BW 7.4/7.3/7.0/3.5/3.1 C/3.0, BO 4.1/4.03.X, IDT4.1. Webi 4.1, Dashboard builder 4.1, Design studio 1.5 BODS 4.0, SAP HANA 1.X, HANA Studio, S4 Hana analytics, SQL, ABAP Core Data Services, Data Modelling using HANA Studio, ABAP Development Tools (ADT), HANA Live models consumptionDatabase Technologies: MS-SQL, Oracle, MS Access, SQL ScriptSAP MM, FICO, SD, PP, PS, CRM

ERP Packages: ECC 6.0, SAP R / 3 Version 4.7 / 4.6C / 4.6B

IS utilities: AFS, FMS, CAR

Reporting / Design Tools: BEx Query Designer, BEx Analyzer, Web Application Designer, SAP BO BI 4.0, BO XI 3.X, Web Intelligence, Crystal Report, Xcelsius, Deski, Live Office, QaaWs, Infoview, IDT & UDT, SAP BOBI, Open DocumentProgramming languages ABAP, Java, C

Technologies: Web Services, SOA, XML, XSL

Scripting Languages: HTML, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SAP HANA consultant

Responsibilities:

• Design HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and
• Column/Row based tables in HANA design studio and make them available in the BI system via Virtual providers
• Apply advanced data modeling techniques, including currency conversion, variables and input parameters
• Perform SLT replication to migrate ECC tables to HANA and extracting live data from cloud systems using
• Restricted data access by using Confidential privileges (system privilege, object privilege, package privilege)
• And Creating Role by grouping analytical privileges
• Worked with Copy & Derived options while creation HANA objects
• Working with different type of joins: Inner Join, Left outer join, Right outer join, Referential join and Text Joins
• Created script based Calculated Views
• Created decision tables using Parameters, Conditions & Actions for what-if analysis
• Transporting the HANA Objects by using Developer mode and Delivery unit
• Developed Webi reports, extensively used Prompts, Variables, Drill down, Breaks, Sections, Conditions, input controls
• Pre-and-Post HANA migration activities for BW on HANA including pre-migration housekeeping tasks and post-migration issues fixes
• Worked extensively on HANA modeling for BW Objects
• Designed SAP BW on HANA Composite Providers as semantic layers using BW on HANA Modeling tools

Confidential, OH

SAP HANA BW consultant

Responsibilities:

• Responsible for analyzing all the fiscal calendar usages and conversions.
• Successfully migrated Key reports such as Inventory Roll Forward, Aging, Inventory-Stock by Week etc.
• Enhanced several interfaces and Reports for different sales planning channels for EMEA/DUBAI/BRAZIL
• Successful enhanced the BW interfaces for LOCATE Sales which is a true Omni Channel Experience.
• Created DSO’s, Complex Transformations, ABAP routines, APD’s for Locate sales and Inventory.
• Created Margin sales report for GMO Rollout Countries.
• Developed the following HANA Data Models: Attribute Views for master data, Confidential Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Confidential Views for report consumption with time dimensions.
• Created HANA Views (Attribute, Analytical, Calculation) for Monthly Hyperion Interface.
• Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Worked on POSDM & CAR Extractors into BW.
• Troubleshooting SAPBW7.4 on HANA issues and responsible for applying the OSS notes.
• Prepare and document Functional and Technical Specifications for data mapping, conversions, interfaces and job scheduling. Plan Transport and OLTP extract processes
• Worked on BW BEx and Web reporting. Created and modified existing reports
• Responsible for Creating Charms using Solution Manager and moving the transports across the landscape.
• Worked on Cut-over activities and data validations and post go-live support.
• Created Process chains and automated daily loads for Transaction and Master Data loads.
• Design HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and
• Perform SLT replication to migrate ECC tables to HANA and extracting live data from cloud systems using
• Smart Data Integration (SDI) and Smart Data Across (SDA) to combine both structured and
• Unstructured data for reporting
• Trained the users in using excel using Hana Views
• Pre-and-Post HANA migration activities for BW on HANA including pre-migration housekeeping tasks and post-migration issues fixes
• Worked extensively on HANA modeling Objects for BW

Confidential - Los Angeles, CA

SAP HANA BW Consultant

Responsibilities:

• Developed BI design for reporting on Planning and Budget process required to maintain forecasting and actual vs. forecast reporting operability.
• Analyzed and corrected production problems.
• Analyzed the logic and implementation of Contracts and Super contracts in LO process and corrected the issues.
• Designed and developed a complex report for Forecast inventory.
• Created Composite Info providers using Kepler Modeler.
• Developed mixed modeling with Bw7.4 on HANA, Migrated Infocubes to HANA optimized infocubes.
• Created analytical View, Calculation Views and attribute views
• Created complex Bex queries on the Multiproviders with structures to support BOBJ universes.
• Created process chains using various process to automate data loading, activation of ODS, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Developed Webi report for Daily flash to broadcast the daily Invoice details to the Core team
• Developed Webi report to show the sales details and gross for the detail of week to date.

Confidential - San Diego, CA

Sr SAP BW Consultant

Responsibilities:

• Analyzed and Corrected production problems as they occur in the SAP BW system
• Customized and maintained Data Sources such as billing (2LIS 13 VDHDR), Sales Order (2LIS 11 VAITM), and Delivery Order (2LIS 12 VCHDR) Purchasing Order Item (2LIS 02 ITM) for MM.
• Data loaded to BPC info provider, validations done, unit tested and transported to Quality then to production
• Developed numerous custom data sources using database views and custom function modules.
• Utilized the Analysis Process Designer (APD) to perform custom calculations of projected inventory levels.
• Enhanced business content data sources with append structures and ABAP user exits.
• Designed data model and BI Objects to develop numerous AR revenue related analytical reports
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems
• Collecting and Releasing transports (BW and BEx). Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production
• Debugging the Extractor checker, Start routines and End routines
• Enhanced CRM extractors 0CRM COMPLAINTS I with custom fields as per the business requirement.
• Handled the huge loading for historical conversion from the CRM, ECC and the legacy BW systems in D and Q environments
• Reconciliation of BI reports with the ECC & legacy data as wells as the reports.
• Work with end users to resolve the day to day data and reporting issues.
• Have good working knowledge on the User ticket tool (ESMS), assigning the tickets and resolving them as needed.
• Tested front-end portal reports with Multi provider.
• Involved in Unit testing, integration testing, regression testing and UAT testing.
• Reported bugs through HP ALM 11.0 and interacted with developers to assist in resolving the issues.
• Have good understanding on Solution Manager CHaRM process.

Confidential

Sr SAP BW Architect

Responsibilities:

• Involved in Enhancing global implementation of HR OM/PA modules
• Delivers HCM consulting experience at functional and technical level.
• Involved in modeling OM/PA Data models and created generic extractors.
• Responsible for customizing the standard table to enable standard extractors extract data from IT302 Additional actions.
• Responsible for enhancing the standard 0Employee/0Person as per the business needs.
• Responsible for modeling the Headcounts and actions Infoprovider and Staffing info providers to enable business to report on them.
• Created generic extractors and enhanced standard extractors using BADI’s.
• Created Start routines, end routines and expert routines in transformation using ABAP.
• Created test environment, test plans, test data involving Business users in the UAT/Integration testing
• Created training documentation/power point presentations for the Business Users

Confidential

Senior SAP BW Developer

Responsibilities:

• Project involves migrating applications from SAP BW3.5 to SAP BI7.3. Use SAP BW to extract data and build dashboards in Xcelsius, and build and modify existing reports and simultaneously create and design reports using SAP BOBJ.
• Upgraded from BW 3.5 to BI 7.3 Technical Upgrade and Dash Board implementation.
• Interacted with the management and business Decision-makers to identify business requirements.
• Documented reporting needs of the Business Service and Support Organization and disseminated those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Successfully executed the BI Upgrade strategy from BW 3.5 to BI 7.3 including Pre-Upgrade and Post Upgrade tasks (collecting system objects, Security). Upgrade Activities:
• Involved in the Pre-Upgrade Activities (3.5 to BI 2004s).
• Running of Reports for activation of all the Objects.
• Running RSRV for the Consistency Check for Master and Transactional Data.
• Running the Report RSUPGRCHECK Report for Checking the Consistency Check.
• Migrated Library Items from 3.5 and from 3.5 to 7.3.
• Emptying the Queues (SM13 & LBWQ) by running the V3 Jobs.
• Deleting the Data from the Set-Up Tables
• Running the Process Chains to fetch Data and Emptying the RSA7.
• Resolved many issues around the Upgrade. Created OSS messages for Upgrade issue.
• Conducted the User Training on the New Bex Features. Installed and configured the BI Admin Cockpit. Successfully deployed the New Analysis Authorization.
• Responsible for developing High Level Data flow and revising the Gap Analysis.
• Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters and free characteristics.

Confidential, Long Island, NY

Sr SAP BW Lead Consultant

Responsibilities:

• Worked on BW Upgrade project for Patch and plug in upgrades, which involved preparation of all clients for upgrade, post upgrade testing.
• Was responsible for the change management process and moving the objects to production.
• Developed Standard Test case template for Pre-and Post-Upgrade process in upgrade.
• Tested Sandbox and development environments as per test cases in upgrade process from the business users.
• Perform test support patches and OSS Notes for Upgrade.
• Involved in creation/approval of transports between D-Q-P systems.
• Created test environment, test plans, test data involving Business users in the UAT/Integration testing
• Administered the user’s roles and privileges in Central Management Console.
• Scheduling the documents and distributing them using CMC and monitoring them.
• Creating aggregates and indices for better query performance
• Evaluated statistical performance and made recommendations to basis support for optimization

Confidential, Houston TX

SAP BW Consultant

Responsibilities:

• Design, Development & Enhancements, Queries & Reports & Cutover Activities
• SAP Basis Kernel Upgrade and Testing the downstream Applications
• Enhancements to Standard Data Sources
• Data Loading to Inventory Targets
• Unit Testing & Automating the Loads
• Designing & Development of BEx Queries & Reports
• Identifying the Affected applications for SAP Basis Kernel Upgrade and design the test plan
• Search and Apply the SNote
• Plan the affected applications and downtimes of the Batch jobs from ECC.
• Tested all the process chains across the landscape.
• Responsible for the Test plan, Test strategy and Test cases and coordination with different teams across.
• Responsible for regression testing and system testing and validation of UAT results with users.
• Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team.
• Maintaining Reconciliation’s for Finance and Inventory data to verify the data in SAP R/3 and SAP BW are same or not after the month end data loads as a part of month end activities.
• Actively involved in transition Phase to take Knowledge transfer and prepared SMTD document for SAP-BW system.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Maintaining the queue - related to the system generated tickets and customer generated tickets.
• Maintaining Work History for all the tickets until it is closed.
• Handling Customer generated tickets and interacting with users for getting clarifications, giving effective solutions to SIR’s assigned involving report and data issues.
• Interacting with different teams for the delay of schedule loads and re-schedule the loads when the file is arrived by control m team
• Analyzed and Corrected production problems as they occur in the SAP BW system
• Preparing status reports on Data Load monitoring of daily, weekly and monthly loads
• Enhancing the Standard Data Sources across functional areas as per the Business Requirements
• Enhancements to User Exit variables for Queries
• Design & Development of BEx Queries across all Functional Areas
• Design & Development of Workbooks and publishing them as per Business Roles
• Extensively coordinated with the Security teams to design & implement Analysis Authorization for various Reports
• Enabling some of the Business Content Characteristics as Authorization Relevant
• Conducting the Train, the Trainer Session for the Business Users
• BW-BO Integration:
• Business Objects Responsibilities:
• Involved in SAP BI BO integration and Migration of BI Bex Queries into BO.
• Created OLAP universes on Info cubes, Multi Providers and BEx Queries using Universe Designer.
• Designed and developed Xcelsius Dashboards using Universe (Query as a Web service), Web reports (Live Office), BI queries(BICS) and used Open Document to drill down from Dash board to detail level of reports created using Web Intelligence.
• Involved in performance tuning of various WEBI reports in BOBJ side.

Confidential

Environment: Seebeyond, SAP NW2004s, R/3 ECC-5, Windows Xp.

Responsibilities:

• SeeBeyond Developer and Production support member
• Involved in identifying to fix the defects and Change Requests raised.
• Involved in development of
• Reports
• Dialog programming