SUMMARY:

• Confidential has nearly 13+ years’ experience in the IT arena, the last 13+ years of those working for SAP consulting companies as a Technical Architect senior consultant, trainer, and team lead. He has been involved in many successfully delivered SAP projects across India, the UK, US and Europe. Gopal has a functional expertise includes configuration, implementation, and development of SAP BI/BW & BO, SAP HANA, ABAP, APO, SD, MM, FI/CO, PS, HR, CRM Modules, sap - IS Retail, SAP-ARIBA.
• His project experience includes all stages of project lifecycles including concept studies, scoping, blueprinting or design, prototyping, realisation (configuration), development, testing,, data up-loading, go-live and support. He has also involved in Presales activities such as preparation of proposal (RFP) and winning of the proposals for Techmahindra, HCL like GE and Confidential .
• Experience in SAP BW for HANA and migrating standard SAP Models to In-memory optimized models and Performance testing. Expert knowledge on SAP-IS Retail domain.
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, and Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modelling using SQL Script, stored procedures. Experience in various Data provisioning tools like SLT, smart data access & DXC.
• Experience in BW on HANA-Designing ADSO, Compositeprovider, openODSview & Transient provider.
• Hands on Experience BW database Archiving by using NLS(SYSBASE-IQ).
• Experience in SAP-BO: Development of WEBI reports by using Bex query as a Data source.
• Proficient in designing Information Design Tool. experience inSAPreporting tools - Lumira Design Studio, Lumira Discovery and WEBI.
• Development of Design studio reports by using HANA Views.
• GOPAL is a leading expert in SAP BI/BO, HANA, ABAP Technical and also, he has very good functional knowledge in SAP SD, MM, APO, FI/CO, CRM, PS & HR modules. Gopal has strong skills in Projects, has completed 6 ends-to-end implementation, 4 support implementations. Having very good strong experience on BW-IP, creating planning area & aggregation levels using RSPLAN(T-CODE).

TECHNICAL SKILLS:

Programming Languages: SAP ABAP/4

Dataware Housing tools: SAP BW 3.5, SAP BI 7.0 / 7.3,7.4 7.5, SAP HANA 1.X Release 1.7& Business Objects 4.0: Database Development

Oracle: 8i/9i/10g/11i/Dev2000, SAP-HANA: Graphical User InterfaceSAP Java WebDynPro 2004s (7.0.14), SAP ABAP WebDynPro 2004s (7.0),: & SAP EP7.0

Web Technologies: ASP, HTMLB, HTML, XHTML, XML, XSTL, PHP, CSS, Perl, JavaScript

Networking: TCP/IP, DNS, HTTP, FTP, LAN and WAN Technologies.

SAP Functional: SAP SD, SAP-APO, SAP FICO, SAP MM SAP CRM & SAP HR, SAP-ARIBA.

PROFESSIONAL EXPERIENCE:

Confidential

HANA BI/BW Technical Architect

Technologies: SAP BI 7.5 SAP-ARIBA, ECC 6.0

Responsibilities:

• Understanding Business Requirement Document from the customer and involved in creation of Business impact document and Propose new solutions that meets customer requirement in SAP-ARIBA system & ECC system with customized work flows.
• Modelling & Architect the Design flow from Ariba to ECC & from ECC to BW system.
• Architect & Building the design flows in BW 7.5 system using ADSO & Composite providers.
• Worked on BW Technical and Functional migration from 3.x to 7.x for the BI data model (in different application areas e.g. Procurement, QM, FI, CO, MM, SD etc.
• Generating of Material & Vendor approval process Reports in SAP BW 7.5 system.
• Replication of Data source by using ODP & ODQ provisioning tool from ECC to BW systemAnd releasing the Extractor for ODP by using RODPS OS EXPOSE.
• Working on deliveries related to configuration.
• Creating/Development Design studio Dash Boards in MAP process (Material approval process)
• Creating/Development of Design Studio Dash Boards in SLP process.
• Worked on BW LSA/LSA++ data modelling.
• Working on BI data model designing for new requirements.
• Translate business requirements into functional and technical design document.
• Work closely with end users in the development and maintenance of BW Objects.
• Hands on experience & strong exposure with latest BW ON HANA Modelling objects is required (Creation of Composite Providers, Advanced DSO's, Open ODS Views etc.).
• Optimization of the BW on HANA data flows, experience in working with large datasets & developing complex BEx queries.
• The reports are based out of BEx and Business Object (WebI and Lumira).
• Working extensively on BI related ABAP work e.g. Routines and enhancing the extractor to achieve the business logic.
• Perform QA for the deliverables.

Confidential

HANA BI/BW Project Lead/Solution Architect

Technologies: SAP HANA1.0 SP5, SAP BI 7.4 / BO 4.0, SAP FICO, ABAP, SD and MM

Responsibilities:

• Working on Rally tool, for task allocation, tracking & logging defects.
• Preparation of Analysis document and Estimation for Enhancements and New implementations.
• Reviewing of Team’s Analysis, Estimation and providing necessary approvals.
• Migrate SAP BI Info Providers to SAP HANA Optimized using transaction RSMIGRHANADBorusing program RSDRI CONVERT CUBE TO INMEMORY
• Implementation of LSA architecture in SAP-BI system.
• Copying the calculation views to Z*calculation views by using HANA Live content.
• Configuring LIS extractors in LBWE t-code for sales orders, delivery & billing.
• Writing Business logic & End Routines in BTL-transformations layer for AR & AP.
• Creating Open HUB services on FI Mater data & transaction data.
• Sending data from Open hub tables to Theia FI system which is third party Talend system.
• Removing Indexes, Rollup’s and Attribute Change Run steps from Existing Process chain.
• Compounding Company code and purchase organization in order to populate these values in vendor master report
• Modifying existing BEx reports based on customer requirements.
• Migration of Master Data from 3.x to 7.x.
• Remodeling of DSO for adding new fields and populating new fields using customer exist.
• Optimizing ABAP routines to improve the performance
• Configuring SAP SLT Schema for both ECC and HANA studio system.
• Filtering & Restricting the Data in SLT system by using LTRS (T-code).
• Publishing HANA VIEWS into BW system by Transient provider using a t-code RSDD HM PUBLISH.
• Loading/Archiving historical data into SYBASE-IQ by using NLS.

Confidential

HANA BI/BW Solution Architect

Technologies: SAP HANA, BI 7.4/ BO, ABAP, SD and MM, APO

Responsibilities:

• Understanding Business requirements from the customer and involved in creation of Proof of Concept Documents for the customer.
• Creation of Calculation views & analytical views for Sales Reports.
• Managing forecast versions on monthly basis, loading data into cubes by forecast version.
• Running process chains on monthly basis to load planning data from planning area.
• Generating forecast Accuracy reports by comparing Actual sales vs planned sales.
• Analytical indexes using RSDD HM PUBLISH transaction on existing SAP BI/BW system.
• Creation of Virtual Providers on top of SAP Analytical View.
• Creation of BEX Report on Virtual provider and publish BEX report document in BO WebI Document.
• Development of Forecast accuracy reports BY SKU, Comparison reports & YTD reports

Confidential

BI/BW & BO Technical Architect

Technologies: SAP BI 7.3/ BO, ABAP, SD and MM, SAP-EP, APO

Responsibilities:

• Working As a 1ST line Support to the Confidential customer.
• Issue Analysis of O2C reports Daily-sales Report, Monthly Sales-Report.
• Preparing Issue Analysis Documents giving 2nd level support.
• Testing p&L Balance sheet reports, O2C reports.

Confidential

BI/BO Solution Architect

Technologies: SAP BI 7.3/ BO, ABAP, OTC, FICO & MM.

Responsibilities:

• Development of Days delay report in SALES using schedule line extractors.
• Development of inventory aging report.
• Development of P&L report.
• Development of Daily Indicator Reports
• Doing UAT & interacting with Customer in the testing phase.
• Preparing Technical Design based upon business Requirements.

Confidential

BI/BW,BO Solution Architect

Technologies: SAP BI 7.3/ BO, ABAP, SD and MM

Responsibilities:

• Preparing TD based on Functional Design & FD lites.
• Creating function module extractor, building cubes & reports (Deferred Revenue)
• Creating Write optimized DSO, if when standard DSO is not present in business content flow.
• Doing unit testing / preparing test scripts.
• Generating reports like deferred revenue, field inventory etc.
• Developing customized extractor using Function module.
• Creating Web Intelligence reports on top of BEX report using BO Client tools.
• Optimizing the existing BW objects to improve the performance by applying performance tuning techniques on both hardware and software level such as using DB02, ST03N, SM50, SM66, Buffering, ABAP Routines, ABAP user exists, physical/logical partitioning, indexing, aggregates on characteristics, hierarchies, rollups, implementing BW Statistics, OLAP catch for BEx Report and error handling.
• Maintain and activate the extract structure of Purchasing Data sources 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL in ECC System. Write necessary logic for new fields on RSAP0001 exist to replicate the USA Purchasing data into Confidential North America’s BW System.
• Delete the existing setup table data of Purchasing Data Source (02) using LBWG
• Fill the setup tables of Purchasing Data sources using SBIW

Confidential

BI/BW Solution Architect

Technologies: SAP BI 7.3 / BO4.0, HANA 1.0, SAP EP 7.0, ABAP, SD, MM, FICO and PS

Responsibilities:

• Involved in Requirement gathering/Blue print Design Phase.
• Finding Data sources related FI-GL/FI-AR/FI-AP/FI-AA
• Installing standard Business Content Cubes/DSO 0FIGL C10, 0FIGL 010
• Developing Reports based on financial statement India version & balance sheets, Actual& Actual Comparison, Actual & Previous Year to Date Comparison Reports.
• Pulling data from legacy system i.e. Oracle DB Connect to SAP-BI system.
• Installing standard inventory Data sources & cube (0LIS 03 BX, 0LIS 03 BF, 0LIS 03 UM &0IC C03), Developing Stock Reports.
• Pulling Data from solution Manager by using CRM Data source & Installing Business Content
• Cube (0CRM SRV PROCESS H; 0CSRV C01).
• Developing Report i.e. open tickets and closed tickets for the particular period.
• Enhancing the Standard Business Content Cubes with Custom fields and Mapping in transformations with Data Source.
• Fixing major errors such as delta failures, caller 09, caller 70, M objects are not activated, ODS activation failures, BIA index errors, TRFC errors, Creation of SID errors, analysing miss match of data between source system and sap BW systems, special characters, memory issues and analysing dumps.
• Enhancing existing Data sources for Logistics, Generic, Controlling, Project Systems and Finance as part of Business requirement.
• Depth Knowledge in both functional area (SD, MM, FICO, CRM & PS) and technical (BI, ABAP, EP, MDM, HANA & BO).

Confidential

BI/BW Team Lead

Technologies: SAP BI 7.0 / BO, SAP EP 7.0, ABAP & HR

Responsibilities:

• Doing all Production support Activities in BI 7.0 like Process chain Monitoring,
• Load related issue handling, regular updating of SLA’S.
• Handling Change Requests, and interacting with clients.
• Exporting BO Reports into Centre Management Console and Running all Reports in java info view.
• Creating Dash Boards by using Query as a web service in Xcellsius Reporting and exporting to CMC (Centre Management Console).
• Monitoring work loads of pears & communicating the same with Onsite pears.
• Data modelling and implementation of Info Objects & DSO’s
• Creation of transformations and Data Transfer Processes (DTP)
• Installed BI Content, migrated Data sources to BI 7.0.
• An APD to store data of huge formulas for a faster query performance.
• Creation of Standard/Write-Optimised/Direct Update DSO’s for storing HR Data
• Creation of Standard Cubes & Master Data Attributes / Text for HR .
• Creation of Data Sources for attributes texts and hierarchies
• ABAP programs to eliminate invalid Chars / (tcode: RSKC), delay attribute change runs and trigger emails in the background and loading and archiving flat files on application server.
• Designed BEx queries to test data integrity of important Key figures.
• Publishing SAP BI/BO Reports in SAP Enterprise Portal.
• Definition of process chains, Managed and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not after

Confidential

SAP-BI/BW Project Type: Development

Technologies: SAP ECC 6.0, SAP BI 7.0 / BO, ABAP & SD

Responsibilities:

• Development Financial Reports based on Cost elements.
• Doing unit testing & Preparing Test documents.
• Preparing Technical Design & functional Design Documents Understanding the blue prints and needs to prepare Technical Specification.
• Implemented BI Content for SD, MM & FI Cubes & DSO’s.
• Loading the Data from SAP R/3 to SAP BI 7.0 using Delta / Full.
• Created custom ABAP expert routines and start routines where it is required
• Developing of required Info Objects and customising existing Cubes/DSO’s/ Master Data.
• Involved Development of Info Cubes & ODS in SAP BI, Credit/Debit Data Sources in SAP ABAP, and Perform ETL Operations in SAP BI.
• Monitoring Loads Using RSPC, RSMO, SM37, and SM50 & Running process chains frequently.
• Creation of Reports using BEx Analyser, Query Designers, Web Application Designer in SAP BI as per customer Requirements.
• KPI & Report requirement analysis, BI-SD data modeling, BI-SD Standard object activation and modification. Design and develop new BI-SD Info providers. Design and develop BI-SD Data sources, New SD Report implementations. Creating user acceptance test of BI reports. BI-SD end user and go-live.
• Creation of Authorization Objects for Reports, Cube’s, DSO’s & Master Data.
• Preparing UTP (Unit Test Plan) for the completed Objects.

Confidential

Senior SAP Consultant

Technologies: SAP BW3.5 ECC MM & SD.

Responsibilities:

• Working on Multiple Systems, Doing Back out planning, SD4 tickets.
• Data modelling, transporting the new development to different quality systems.
• BEx query development for Nordic, rest of the European countries.
• Setting up INIT tables at R/3 side, loading invoices into first level ODS with full load and then doing deltas for the respective cubes according to sales organizations.
• Writing Update routines, transfer routines & start routines.
• Developed shipment report for global data from the scratch level.
• Setting up the inventory cube deltas, reloading the material moment data into stock cube.
• Development of Reports like ‘GBF customer Sales Force based on Material grouping.

Confidential

BW Consultant

Technologies: BW3.5 ABAP R/3 4.7

Responsibilities:

• Dropping & creating the indices when huge volume of data is loading.
• Developed reports on BEX Analyzer (Using free characteristics, key figures, calculated key figures, variables, Exceptions etc)
• Made an interactive report for header & item data with RRI.
• Extracting the data from different data sources.
• PSA Maintenance, Error handling using PSA and query development.
• Resolved Query performance issues using transactions RSRT, ST03N.
• Installed BI Content, migrated Datasources to BI 7.0

Confidential

SAP- Consultant

Technologies: SAP-BW 3.5 R/3 ABAP ECC6, SD, MM.

Responsibilities:

• Loading data from legacy system i.e. flat file.
• Modified/wrote customer exits to fill the appended extract structure with data.
• RSAP0001 enhancement is used to do the data source enhancement & assign to data source using transaction CMOD.
• V3 updates, controlled by pull/push principle from the OLAP system
• Scheduled info packages for delta initialization and delta data loading into info cubes Via PSA, ODS objects.
• Loaded transactional data into PSA and update data from PSA to ODS and activated ODS for reporting.
• Scheduled info packages to load regularly and also automatically triggering the attribute change run & Process chain monitoring (T-code RSPCM).
• Cube partitioning and setting customized info cubes.

Confidential

SAP-Consultant

Technologies: SAP-R/3 4.7, ABAP, SD, MM .

Responsibilities:

• It is a List of purchasing group report is to display the list of Plant, Purchasing Group, and Description of Purchasing Group according to the Plant and also downloads the file in text mode. Tables used in this are Marc, T024.
• This is a monthly-based Transit aging report to verify that all inbound shipments have been goods receipts prior to inventory count.
• This report lists all Deliveries that have been shipped but not yet billed.