SUMMARY:

• Over 13 years of Business software development and consulting experience in which 10 + years of SAP experience across modules SD, MM, FI/CO with focus on BI (Business Intelligence) and Planning Modules as BPS - Business Planning & Simulation, IP - Integrated Planning - CPM Commercial Project Management, additionally 2.5 years of experience with SAP BW on HANA and Native HANA 1.0 SPS 08/07/06, SAP Data Services 4.2.Experience in Working with SAP BW 3.5 Ver, SAP BW- BPS (Business Planning and Simulation), SAP BI 7.0 IP and SAP BPC Microsoft and NetWeaver
• Participated in 7 life cycle Implementations
• Manage Project Manager / Team lead across multiple SAP & Non SAP Implementation
• Experience in Applications Integration, Data Integration, Business requirements analysis, Process Re-engineering, Gap-Analysis, Design, Development, Testing and Implementation of SAP Applications.
• Involved in preparing Business case study for BW on HANA implementation.
• HANA Pre-implementation task as HANA Sizing, System cleanup activity and ABAP migration of data objects 3x to 7x new data flow for HANA implementation
• Involved in ABAP code optimization post HANA Implementation during stabilization
• Full life cycle HANA implementation with extensive HANA modeling.
• Experienced with SAP HANA data modeling and implementation of Attribute Views, Analytic Views, and Calculation Views by Relational and Multidimensional representation as per the Business requirements.
• Experienced with SAP HANA programming including SQL, SQL Script/Procedures, Decision Tables, Analytic Privileges and predictive analysis algorithms, HANA PAL & BFL libraries for time series and Apriori algorithm.
• SAP UI5 Development for user Interface for Consumer and Marketing facing app using HANA Odata Rest API layer
• Expert knowledge and deployment experience with SAP BW 7.4/7.3 Powered by SAP HANA
• Ability to architect and design the complex data models in HANA that assimilate the data from multiple Source Systems (SAP & non-SAP) to effectively and efficiently solve Business requirements.
• Extensively worked with SAP BPC Application Set, Applications, Dimensions, Dimension Members, Reports, Input Schedules, Script Logic, BW integration for master & transactional data etc.
• Worked on implementing EVDRE best practices as advised by SAP
• Created reports using EVDRE, EVEXP, EVGTS, EVPRO and EVDES functions.
• Expertise in Multidimensional data Modeling, Star Schema and Extended Star Schema, Design, Development and implementation of InfoProviders (InfoCubes, DSOs, MultiProviders, InfoSets, Master data objects, etc.), Data Extraction, Transformation, Translating and Loading the data from different Source Systems like SAP ECC, SAP CRM and Non-SAP PC Flat Files Data into SAP BW/BI system
• Hands on Experience with Back-end Business Warehouse Components like Extractors, Info Objects, Info Sources, Update Rules, Transfer Rules, Info Cubes, Info Packages and working with Start Routines, transfer Routine and Update Routine.
• Front-end Business Warehouse Components like Queries, Calculated key figures, Restricted key figures, Structures, Variables, Filters, Free Characteristics etc.
• Performed extraction of data from SAP source systems using LO Cockpit, LIS, delta and Generic data extractions (flat files).
• Strong on End-to-End BW Configurations and Customizations from Extraction, Staging, Loading, Reporting through BEx Analyzer, Security and Performance.
• Expertise in Data Integration from SAP BW/BI to BPC for NetWeaver applications
• Worked extensively in data integration from SAP BW/BI system to BPC NW system to load Actual/Plan/Forecast data.
• Opex & Capex planning (Operational and Capital expenditure planning)
• Created Planning Cubes, Planning Areas, and Multi planning Areas to Plan on More than one Planning Areas.
• Excellent experience in BW system upgrade activities BW 7.0 to 7.3/7.4 and prepared the test plans for the BW/BI System upgrade.
• Involved in BW DEV., QA. Systems refresh activities and BW Production system migration activities.
• Provided End- User Training and Knowledge transfer on all aspects on the Implementation Process.
• Strong Communication & user interaction skills, ability to work in team as well as an individual.

TECHNICAL SKILLS:

SAP SD, MM, PS, APO - DP & SNP, BW: Managing Lead for Development & Support activities

HANA: SAP ECC tables to HANA through SLT, BW on HANA implementation and Native HANA standalone system

BW BPS / IP - Business Planning Simulation & Integrated Planning : Expertise in working with Multi Planning Areas, Planning areas, Planning levels, Planning functions, fox formula, Planning Packages, Planning sequence, Global Planning Sequence, data slices, Use Variables to reduce BPS locks .End User Interface with Enterprise portal by creating Different i views based on the BPS application created .

BI Modeling: Expertise in Data Modeling, Data staging and extensively worked in business information warehouse Info cubes, ODS objects, Info object catalogs, characteristics, key figures, transfer rules, update rules, Info sources, Business content, Data marts, Info packages, multi provider.

BI Extraction: Extensively involved in extraction of data from SAP R/3 using customized LO cockpit and extraction of data from flat files.

BI Reporting: Bex Analyzer, Bex Query, Work books, Info set Queries, Free characteristics, Restricted key figures, Calculated key figures, Variables, Structures, Exceptions, Filters, Conditions, Report to report interface.

Performance issues: Indexes, Partitioning, Compression, Aggregates, Aggregate rollup.

Production support: Monitoring data loads, Process chains.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond WA

Sr. SAP BI Architect.

Responsibilities:

• Scope analysis & documenting Business requirement for Process flow to extract data across all modules in SAP SD, MM, FI / CO & CPM (BI -IP)
• Architect feasible design for extraction for BI -IP CPM planning module
• PoC to define ETL design for future state Architecture
• PoC for different delta logic across all different types of extractors with data Mall & ESBI SQL environment for defining future state of architecture
• Project plan execution & time line for deliverables
• Design and implement interfaces between SAP and ESBI platform
• Designed ODP solution for CPM module to ease extraction solution
• Managing plan for transport across landscape
• SAP SD and FSB module extraction & Reporting user stories for same to enable the desired business processes for reporting on ERP systems
• Built SAP BI Solutions for multiple releases for SAP PS and CPM centric functional areas
• Prepared strategies for Development, Testing and Defect Management for entire implementation.
• Involved with Functional & Technical Documentation.
• Organized regular meetings to ensure successful delivery of work over a global delivery model. - Escalating and resolving issues wherever necessary
• Oversee the Delivery activities of offshore aspects. Delivery Management, efficient utilization of resources, ensure smooth transition of Hand Over, contribute to Quality Improvement of Processes, Ensuring Customer Satisfaction, Mentoring and Training the resources for continued performance.

Sr. SAP BI HANA Tower Lead.

Environnent: HANA one (AWS), HANA Cloud Platform (SAP Hosting)

Responsibilities:

• Project management for Implementation & Support for SAP project SAP Sales & Distribution(SD), Materials Management (MM), Finance / Controlling for Logistics Order to Cash solution
• Involved in designing Future State Architecture involving SAP & Non-SAP Systems
• Scope analysis for PoC
• Extensively used HANA native PAL / BFL libraries
• Predictive analysis built for product recommendation based on purchase history using APRIORI, APRIORI lite Algorithms
• Create information objects: Attribute views, Analytic views, SQL Graphical Calculated views and stored procedures for validation
• ODATA API layer to interact with Customer Front end tools
• SAP UI 5 Development for Consumer and Marketing Analyst App’s for executing recommendation APRIORI algorithm on fly
• System administration and create developer and reporting roles and maintain system table for regular cleanup to avoid growing further
• HCI and HCP addon’s installation to connect from studio
• MDX connector installation to connect MS excel with HANA cloud platform data base for reporting
• Involved with OData API Technical Documentation.

SAP BI Upgrade & Support

Responsibilities:

• Preparing Estimate documents. Efforts needed.
• Involved in creation of Reports by using BEX-Designer.
• Involved in BW upgrade activities(BW7.0 to BW 7.4 SP13 ), Pre upgrade activities(Prepare documents for all objects, Prepare document for system & object check etc…) Post upgrade(Check all obj. activation, prepare document for all the job which need to run, Prepare document for all validation activities etc….)
• Good knowledge about system up gradation and Validation activities
• Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Involved in requirement gathering, preparing technical specs.
• Have been a part of critical releases and refreshes.

SAP BI NW GateWay Development Source one Field service optimation

Responsibilities:

• Involved in requirement gathering, preparing technical specs.
• Data Modeling: Creation of Info objects, Infocubes, DSO, Multi providers, Info packages, Transformations and Process chain.
• Created Bex report to expose through NetWeaver Gateway
• Configuration for SAP BI for OData Calls for frontend
• Configuration for GateWay for OData Calls for frontend
• Security roles defined at SAP BI & SAP Gateway system
• Been Part of User Acceptance Testing and Prepared Documents for the same.

Team lead SAP BI HANA Consultant

Environnent: SAP BI 7.0.

Responsibilities:

• Prepared Business case for Migration of SAP BW (Oracle DB) to SAP BW (HANA DB)
• Involved in HANA Sizing exercise from base scratch to define HANA multi node architecture (7+1 node)
• Analyzed Cold & Hot data for SAP HANA Environment for business area
• Responsible for cleanup activities which is prerequisite before implementing HANA in order to fit system to 7 nodes. It involves deleting of unwanted data from standard table like RSBATCHDATA, RSZWOBJ, RSPCPROCESSLOG, RSRWBSTORE etc. and archiving of RSMONMESS,RSSELDONE etc.
• After implementing HANA involved in optimization of cubes and worked closely with SAP in order to resolve optimization issue eg Inventory cube optimization.
• Changes in ABAP code in start routine, end routine and statement like which involves “SELECT FOR ALL ENTRIES ” in order to get better performance in HANA as suggested by SAP.
• Monitored and compared Oracle BW and HANA BW system simultaneously in order to measure performance and worked with SAP to resolve those performance issues.
• Involved in performance analysis of queries with functional user comparing HANA and oracle database system and collecting stats for same.
• Held workshop to educate user about HANA and its performance benefits.
• Worked on Control M tools to schedule all process chains and jobs for new HANA system.
• Worked on mercury center tool for executing testing scenarios.
• Created cutover activities plan for successful go live.

Team lead SAP BPC Consultant

Environnent: SAP BPC MS.

Responsibilities:

• Business Requirement for Financial Reporting, Opex Metrics and KPI for CCG, CNE,BGE,CGG divisions
• Involved with Functional and Technical Analysis Document.
• Created planning areas and application to support CCG forecast and Strategic plan for source system Pyxis, COG, CE BPC and CNE BPC
• Quarter plan for BGE - Baltimore gas energy to support application for CPA, Metrics and SLR
• Presentation to the client for the use of planning layouts and Reports
• Developed Business requirement specification as technical scoped document for Bex reports to be developed
• Team lead to track the progress of each activity of the development team
• Develop designed scope.

Team lead SAP BI Consultant

Environnent: SAP BI 7.0.

Responsibilities:

• Business Requirement for BI scope Reports
• Involved with Functional and Technical Analysis Document.
• Analyzed and defined scope for Business Requirement for POC work to benefit Business Data ware housing System.
• Presentation to the client for the scoped Reports
• Developed Business requirement specification as technical scoped document for Bex reports to be developed
• Development of Bex reports & Attaching to WAD link for further linking to SAP Portal .
• Development on BEx analyzer and BEx Browser.
• Business gathering for Business blueprint document
• Track the progress of each activity of the development team
• Develop designed scope.

Project lead SAP BI Consultant

Environnent: SAP BI 7.0.

Responsibilities:

• Involved with Functional and Technical Analysis Document.
• Analyzed Business Requirement for development for Open hub service for downstream system.
• Analyzed Business Requirement for development for Open Biller Analysis.
• Involved in writing start routine and End routine based on project scenario through look up from various other data targets.
• Involved in development activities for Rental, Loan, Standing request and Billing Invoice line items for Open Biller Analysis.
• Scheduled data loads to BI from SAP R/ 3 Monitored data loads, which are running hourly, daily, weekly & monthly basis Using process Chain.
• Developed and modified Info Objects Transformations DTP’s and Info Cubes and loaded these objects with master data and transaction data from sap R/3 by creating Info packages and DTP’s .
• Created Customer exit and Function module for enhancement of generic extraction.
• Extracted the data using Generic Extractor from R/3 by customer exit and function module.
• Worked on performance related issues for data loading in BI .
• Involved in the Data load monitoring using the Process Chain technology. As well as analyzing the data load failure issues.

SAP - BI Consultant

Environnent: SAP BI 7.0.

Responsibilities:

• Business gathering for Business blueprint document
• Analyize Business requirement .
• Requirement specification document for Bex properties
• Report to the onsite team .
• Handle Issues in existing reports for performance and report rationalisation.
• Involved with Functional and Technical Analysis Document.
• Analyzed Business Requirement for development of BI Bex reports to be delivered.
• Analyzed data target for Bex reporting for validation of data from source.
• Technical Analysis and modification required at the data source level and Bex reporting level.

SAP - BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.7.

Responsibilities:

• Proposal Response to RFP released by client.
• Prepared Business Blue Print and Technical Design document for the BW Reports to be developed for broadcasting through Portal.
• Developed Reports as per business requirement.
• Updated SAP Patch level with SAP Note: Email broadcasting error for sending simultaneous email to list of users.
• Technical design for the Change Request for Additional Business requirement for redefine Broadcasting through web Application.
• Updated tables in Oracle data base from SAP R/3 financial Management Reports Through SAP Process Integrator using Idoc adapter for data flow from SAP R/3 to SAP PI and JDBC Adapter for SAP PI to Oracle 9.0.2.6 DB.

SAP - BW BPS, IP Consultant

Responsibilities:

• Worked with Planning Areas, Planning Levels, Planning functions, Planning Packages.
• Technical design for the Change Request for Additional Business requirement for redefine Application’s for Operational and capital Expenditure Planning.
• Support Opex and Capex planning areas of BHP Billiton
• Worked with different Planning Scenarios based on Responsibility cost center and Cost center Planning.
• Worked with Allocation tool for end user to provide different types of cost planning for Maintenance and Labor Planning.
• Redefine Process for loading Planning data from the flat file in Background process with Process chain.
• Created Manual Planning layout for end user interface input, Variables to reduce the BPS Locking
• Worked with Fox formula for different scenarios for Currency Translation, Allocation tool and Operational and capital expenditure planning.
• Created BSP Page for flat file upload through i View in Enterprise Portal for loading Planning Info-cube.
• Designed Planning levels as to eliminate locking issue for end users.
• Worked with Planning Areas, Planning Levels, Planning Functions, Planning Functions and planning packages.
• Worked with Variables, Data Slices.Etc.
• Worked with Planning Functions.
• Worked with Cost-Center planning and Sales & Asset level Planning.
• Involved in the creation of Queries for Planning.
• Providing planning at various levels in organization.
• Created Web Interface. Done Unit Test and System Test for Planning Layouts.
• Involved in creating Additional Queries required for business for planning tool.
• Prepared End User training documents.
• Involved in solving Customer Issues with SLA´s.

S AP-BW BPS, IP Consultant.

Responsibilities:

• Requirements gathering from End Users.
• Involved in Preparing Business Blue Print and Technical Design document.
• Worked for Operational and capital Expenditure planning for different scenarios
• Created Planning cubes, Planning Areas, Multi Planning areas to plan over more than one planning areas, Worked with Planning Levels, Planning Function, Planning package.
• Created Variables, data slices, Etc.
• Created Data Slices to restrict simultaneous User access for the same planning char combinations.
• Worked with Fox formulas for different Planning scenarios.
• Worked with Variables to reduce the customizing.
• Created Web Interface, Done Unit Test and System Test for Planning Layouts.
• Used Characteristic relationships for validations and derivations when generating transaction data for Char value combinations.
• Worked with Different Planning Functions like- Repost, Copy, Distribution…Etc
• Created BSP page I view at Enterprise Portal to link the Application for end user interface. and Transactional I view for linking the Custom transaction for maintaining the Tables .
• Created BSP Page for flat file upload through i View in Enterprise Portal for loading Planning Info-cube.
• Created function Modules to Validate and Load the user specific data to the Planning cube.
• Involved in Creation of Queries for Planning.
• Prepared Training documents and Quick Reference guides.
• Provided end-user training and knowledge transfer on all aspects on the implementation process.

SAP-BW Consultant

Responsibilities:

• Involved in the design, development of Multi dimensional Data Models, Info Cubes, MultiProviders, Operational Data Store (ODS), Aggregates, Info Objects, Data Sources, Info Sources, Info Providers, Transfer rules, Update rules, data sources.
• Involved in Installation of Info Objects, DataSources, InfoSources, Data targets, InfoPackages and InfoProviders to load master and Transactional data from SAP R/3 system into BW system as per the client requirements by customizing them.
• Worked extensively on LO Cockpit extractions loaded the data from R/3 to BW and used Initialization with delta update and full update methods.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Extensively worked on utilizing PSA for effective loads and Error Handling.
• Involved in creation of reports using BEX Analyzer such that the execution time is evenly distributed through out the report by using Free characteristics, Restricted keyfigures, Calculated keyfigures, Variables, Exceptions, Navigational Attributes, Text Variables, Filters, Structures, Conditions, Formulas and RRI (Report to Report interface) by creating Multiproviders.
• Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
• Involved in mapping of infosource with the Data targets using update rules.
• Extracting Master & Transaction Data using Generic Data Sources from OLTP.
• Involved in Info Cube maintenance i.e., Compression, Roll-up.
• Business Explorer Analyzer (BEX), including an in-depth knowledge of Sap’s extended star schema modeling.

SAP-BW Consultant.

Responsibilities:

• Extracted data from SAP R/3 Source System and loaded extracted data into Data Targets.
• Set up procedure for extracting R/3 data for Sales Order, Delivery, Billing Document in Sales and Distribution using LO-Cockpit.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Loaded Data into the ODS Object before transporting the data into the Info cube.
• Maintained Data Sources, Transfer Structures, Communication Structures, Transfer Rules and Update Rules, Info Packages for Data Targets.
• Involved with PSA in Monitoring the Data Transfer from Source Systems into BW.
• Maintained Aggregates, Rollup and Compression on Info Cubes as part of the Info Cube Management.
• Uploaded Transaction Data from the Flat File as the Source System.
• Involved in escalating high-prioritized tickets regarding extractions, Performance Issues and also load failures.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Maintaining Work History for all the tickets until it is closed down.
• Maintaining Reconciliation to verify the data in SAP R/3 and SAP BW are same or not, after the data loads.

Faculty Consultant.

Responsibilities:

• Regular sessions for GMAT,GRE(Quantitative & Analytical),and Key skills for Quantitative approach
• Collection of Feedback from Students about the subject (Contd...)
• Identification and evaluation of key performance of the students’ skills.
• Imparting knowledge to the students
• Responsible for reaching out to external associates for Soft skills.
• Designing the work schedules/time tables and implementing them successfully.
• Identifying the training needs and conducting training workshops for trainer and faculty Consultants
• Identification and evaluation of key performance areas of the students and hence forth appraising their performance
• Training the students as per subject and Examination scenario condition.