SUMMARY:

• Experience working on HANA single and multi - tenant data base container architecture.
• Experience in HANA user security and authorization concept.
• Good knowledge on HANA Memory management and delta merging operation.
• Expertise on SAP HANA Analytical View, Attribute View, Calculation View, Analytical privileges, Composite Providers, Transient Provider, analytical Index using BW eclipse in HANA studio as well as BW environment.
• Good knowledge in HANA View generations on BW info providers, and BW on HANA mixed scenarios.
• Good knowledge on migration of existing attribute views and analytical views to calculation views type dimension and cube.
• Good knowledge in HANA artifacts development using Modeler and Development prospective in HANA studio.
• Development of store procedures, tables function and scalar functions to implement complex business use cases.
• Good knowledge in development AFL graphs to federate the data from external source system using SDA (Smart data access) & SDI (Smart data integration) tool.
• Expertise in consuming HANA information models.
• Expertise in combining custom tables and HANA standard view.
• Having knowledge in creation of HANA Analytic privileges.
• Expertise on creating a Calculation View using Join, Union and Aggregation.
• Expertise on creating a Calculation View on Attribute view and Analytical view.
• Expertise on inner, left outer, right outer, full outer, text join, referential join.
• Expertise on extracting data from ECC data to SAP HANA using SLT.
• Good knowledge on HANA 2.0 Dynamic Tiering.
• Having knowledge on SAP HANA User security management.
• Good knowledge in creation of flow graphs using Smart Data Quality transforms for data consolidation.
• Good Knowledge in using of data transformation capabilities (Union, Join, sort, map, aggregation, template tables, data sinks).
• Good knowledge in real time data integration and batch data integration.
• Experience working on HANA Webi IDE which comes with HANA 2.0.
• Experience in Design, Development, Implementation and Production Support for Business Applications in SAP Business Intelligence/Warehouse (BI 7.X/3.X) with SAP R/3 (4.X/ECC 6.0).
• Successfully completed 3 full life cycle implementation projects starting from requirement gathering from the business users to delivering the Reports.
• Extensive experience in Modeling, Data Extraction/Loading (ETL), Analysis Process Designer (APD), Information Broadcasting.
• Worked on areas of Purchasing, Orders, Delivery and Billing.
• Carried out the upgrade of SAP BW Application.
• Extensively worked on designing/creating InfoObjects, InfoCubes, DSO Objects, InfoSets, Multiproviders, Composite Providers, DTP, Transformations, Data Sources, InfoPacakage, InfoSources, Transfer Structures, Communication Structures, Process Chains, Transfer Rules, Update Rules, BEx Analyzer, Views, Work Books.
• Installed and activated business content (in BI 7.x/3.X), enhancement of DataSources and wrote routines - start routine, end routine, field routine, transfer rules and update rules.
• Worked with LO Cockpit and generic data extractions.
• Worked on Agile, Waterfall methodology, JIRA, HEAT and Remedy ticketing systems.
• Expertise in working with Solution Manager.
• Worked on onsite/offshore, multi-location delivery model.

SAP BUSINESS OBJECTS SKILLS:

• Worked on SAP BO 4.0, 4.1, 4.2.
• Experience working on SAP Business Explorer Suite, SAP Business Object Analysis Suite.
• Experience creating dashboards using Design Studio, SAP Lumira discovery and Designer.
• Created reports using Power BI.
• Created relational/OLAP universes and Connections using Information Design Tool (IDT).
• Developed query objects including restricted key figures, calculated key figures, Structures, RRI, user entry variables, replacement path variables, customer exit variables, SAP exit variables and authorization variables.
• Worked on SAP BODS 4.1
• Worked on POCs for Spotfire/BW integration and Oracle to Exadata migration.

TECHNICAL SKILLS:

ERP: SAP R/3 4.7, 4.6, ECC 5.0, ECC 6.0

Data Warehousing: SAP BW versions 3.1c, 3.5, BI 7.0, 7.3, 7.4, 7.5 HANA studio 1.0 sp10, 2.0 SP2

Functional Module: SD, PP, SCM, CO-PA, HR, FI/CO

Reporting: BEx Query Designer, WAD, Crystal reports, WebI, BO 4.0, 4.1, 4.2, Analysis for Office 2.0, 2.3, AOLAP, Design Studio, Lumira 1.6, 2.0, 2.1, Power BI (Jan 2019)

Email System: Microsoft Outlook, IBM Lotus Notes

PROFESSIONAL EXPERIENCE:

Confidential, Woodlands, TX

SAP BW/BO/HANA Developer

Environment: SAP ECC 6.0, SAP BW 7.5 on HANA, SAP BEx 7.x suite, SAP HANA Studio 2.0, SAP BO 4.1, 4.2, SAP BO Analysis Suite 2.0, 2.3, SAP BEx Query Designer, SAP BEx Analyzer, SAP Lumira 2.0 (discovery & designer), Power BI

Responsibilities:

• Worked on the HANA optimization, creating Composite providers in place of MultiProviders, transporting queries, modifying process chains, replacing Cubes with ADSOs.
• Worked on BW 7.5 on HANA development projects using ADSOs, composite providers, calculation views to model data.
• Worked on mixed scenarios, implemented HANA models by consuming BW generated HANA views from HANA end.
• Worked on HANA content migration across the landscapes using HANA lifecycle manager.
• Worked on HANA Change list management for efficient administration of HANA changes.
• Worked on upgrading BO from 4.1 to 4.2, tested reports and performed performance checks.
• Created SAP Lumira and designer reports in design studio, as per user requirements.
• Worked on upgrading SAP Lumira 1.31, Design studio 1.6 to SAP Lumira 2.0 suite which has discovery and designer.
• As a part of this activity, converted dashboards to the new Lumira 2.0.
• Worked on troubleshooting issues with the upgrade, upgrading patch levels, testing reports, to improve overall report performance, eliminating errors in the reports. .
• Worked on installing and patching Lumira client tools on citrix, installed the necessary packages.
• Worked on Power BI reports, using direct query, import modes to create various dashboards.
• Gave trainings on different BO Reporting tools to multiple users
• Provided support to users in different regions with respect to report issues, scheduling, modifying, fixing errors.

Confidential

SAP BW/BO/HANA developer

Responsibilities:

• Worked on the upgrade from BW 7.0 to BW 7.4. This involved testing, pre and post query snapshots. Involved in testing the new functionality of patch upgrades in BW.
• Leveraged the new functionalities of SAP BW 7.4 like Composite Providers, open ODS, advanced DSO to improve data manipulation, remodeling and faster data access in reports.
• Worked on HANA data modeling.
• Created calculated columns, restricted columns and filters in HANA studio.
• Created relational connection in IDT to connect HANA to WEBI for reporting.
• Involved in the migration of SAP BW on Oracle to SAP BW on HANA. This involved checking the performance of queries after migration on to HANA.
• Worked on the Order Reporting project to extract and load data from the Hand Held system into BW.
• Created relational universes in IDT (Information design tool) working on different connection mappings in the data foundation layer and editing objects in the business later as per the user requirements.
• Worked on creating WEBI reports in BO 4.1 on the relational universe, testing them for different scenarios to achieve optimum performance.
• Worked on the BW/BO support tickets raised by users.
• Managed a team of 5 onsite resources and 10 offshore resources.
• Worked on Power BI POC and had a lot of discussions on implementation planning.

Confidential, El Segundo, CA

SAP BW/BO Developer

Responsibilities:

• Worked on the BO to Microstrategy migration project.
• Worked on Sponsor data project for Confidential & Confidential for DTV, DTV Now, U-Verse, and NFL applications.
• Used Agile methodology, JIRA ticketing system and confluence setup.
• Managed a team of 4 onsite resources and 2 offshore resources.
• Conducted weekly meetings with the client to troubleshoot open issues and discuss the progress on the project.
• There were many moving parts (teams) in the project, brought everyone together on the same page, resolving critical issues.

Confidential, Thomasville, Georgia

Sr. SAP BW/BO/HANA Consultant

Environment: SAP ECC 6.0, SAP BW 7.0,7.4 on HANA, SAP BEx 7.x suite, SAP HANA Studio 2.1.11, SAP BO 4.1, SAP BO Analysis Suite 1.4, 2.0, SAP BEx Query Designer, SAP BEx Analyzer, WebI, Information Design Tool (IDT), SDW.

Responsibilities:

• Worked on installing/enhancing the new HANA optimized standard business content for sales, delivery, billing extractors consisting of 2LIS 02, 2LIS 11, 2LIS 12 and 2LIS 13 extractors.
• Created reports in Analysis for Office 1.4, 2.0 on the standard Sales Overview MultiProvider to analyze how to combine this with the Order Reporting data.
• Worked on the new AFO 2.0 SP3, creating and saving different workbooks for users.
• Worked on scheduling setup tables for sales, deliveries, billing and purchasing.
• Worked on the transports using the Change control system, updated issues/documentation using AtTask, which is a project progress tracking application.
• Worked on general ledger Finance extractors 0FI GL 4 to improve the data loading performance.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View and Calculation View.

Confidential, Houston, Texas

Sr. SAP BW/BO/HANA Consultant

Environment: SAP ECC 6.0, SAP BW 7.3, SAP HANA Studio, SAP BEx 7.x suite, SAP BODS 4.1, SAP BO 4.1, SAP BO Analysis Suite SAP BEx Query Designer, SAP BEx Analyzer, SAP Business Objects Data Services, WebI.

Responsibilities:

• Worked on the onsite/offshore model and managed a team of three offshore consultants.
• Worked on the Tax Project to replicate a SAP report in BW combining data from Finance and Sales, getting COST value from the SD flow
• Wrote end routines, field routines to remove invalid characters, start routines to lookup data from different DSOs to get COST values, document types, serial numbers and other fields.
• Created BODS jobs, workflows to link the SAP OpenHub Table output, editing certain fields, before putting the extract file on a shared folder.
• Worked on enhancements on purchasing extractors 2lis 02 itm, SD extractors 2lis 11 vaitm
• Created a generic extractor on VEKP/VEPO for handling, information, extracted data over to the BW side
• Enhanced Shipping extractor 2lis 12 vcitm for delivery information
• Worked on hierarchies for entity target label. Created jobs in BODS to bring data over from DRM module to BW to load the entity hierarchy
• Built reports in BEx query designer on purchasing data based on EKKO/EKPO join, BSIK (accounting secondary vendor information), Handling VEKP/VEPO join, LIKP/LIPS join (delivery information)
• Gave users training on SAP Business Objects Analysis Suite of Analysis on Excel and PowerPoint.
• Created Change documents in Solution Manager (CHARM) to move objects via transport of copies, releasing transport requests following the transport windows for Normal/Maintenance and Emergency transports
• Created Universe using SAP BW as source for BO 4.1
• Created Management Reports, Tax Reports, PCM reports, EDW reports, Financial Statement reports using WebI
• Worked on a POC for implementing SAP HANA 1.0 sp5 on BW 7.3.
• Did a POC on Spotfire integration with BW, another POC to establish baselines for query performance comparing, Oracle on IBM/AIX and Oracle on Exxadata.

Confidential, Plymouth, Michigan

SAP BW/BO Team Lead

Environment: SAP ECC 6.0, SAP BW 7.3, BEx 3.5, 7.0 suite, Query Designer, BEx analyzer

Responsibilities:

• Provided leadership and co-ordination between onsite and offshore resource activities.
• Worked on daily production support and fixing of process chain failures.
• Worked on Process Chain performance improvements via cube compression, parallel loading and timing depending on the resource available.
• Worked on Remedy Tickets created by users regarding changes to existing workbooks, change in the drilldown, and layout of the reports.
• Worked on Support messages to make enhancements to existing reports by bringing the necessary fields from SAP via different extractors.
• Estimated the effort needed in building reports and working on the reports.
• Worked on uploading the exchange rates monthly from the JCI portal.
• Successfully resolved the issue with the cost analysis reports getting delayed because of the delay in the end-to-end accruals process chains.
• Took active part in SOX, Scope Freeze, GO/NO-GO meetings for Support Messages.
• Had daily calls with the offshore to guide them with pending remedy tickets and other process chain fixes and issues.
• Worked on the upgrade project from BEx 3.5 to BEx 7.0
• Used BEx Information Broadcasting to distribute the right information to the right people Confidential the right time.

Confidential, Plano, Texas

SAP BI/BO Consultant

Environment: SAP ECC 6.0, BI 7.3, BEx 7.0 Query Designer, BEx analyzer, BO XI 4.0, WebI

Responsibilities:

• Worked on the Branch Manager Business Portal project to bring a list of KPIs from BW to develop reports using BEx query designer.
• Used a range of calculated KFs, restricted KFs and formula variables in the queries.
• Worked on scheduling reports using Information Broadcasting to export reports in form of excel and pdf files.
• Coordinated with the offshore team to use web services to give data to SharePoint.
• Created jump to queries to navigate from one query to the other.
• Set user roles & permissions / authorizations for BW.
• Developed technical specifications based on the functional specifications to ensure the correct development of the solution to satisfy the business need.
• Created DSOs of Standard, Direct update and Write Optimized type, used them to stage data before transferring DSO contents to Info Cube.
• Involved in Data Modeling, Data Extraction, Data Loading (Full/Delta Upload), Scheduling and Monitoring.
• Worked in AHS (After Hours Support) team to monitor Process Chains and provide production support (hyper care).
• Prepared documentation to transport queries to Production and followed the SOLMAN procedure and attended CAB to get approval.
• Worked with the business, SharePoint team to make changes to the queries to resolve timeout issues.
• Extensively created reports in WebI, implemented drill down features and created reports including horizontal table, vertical tables, forms and charts.
• Worked in designed & modification of the Universes as per the requirements adding new classes and objects as required.
• Worked on WebI components to develop reports on universes using Universe Builder XML components.

Confidential, Alpharetta, Georgia

SAP BI/BO Consultant

Environment: SAP R/3, BW 3.5, BI 7.3, WAD, BEx Analyzer, BO XI 3.1, WebI, Xcelcius

Responsibilities:

• Completed phase one of an ongoing project, which is called the GRS (Global Repair Services)-Demand Planning project.
• Completed eRMA WAS reporting, CVRT project in which got good experience in creating generic extractors, function module and SAP program, which was a copy of standard SAP program.
• Worked on APO, WAS, ECC source systems for these projects.
• Worked in AHS (After Hours Support) team to monitor Process Chains and provide production support (hyper care).
• Created data transfer processes using process chains and gained experience in extraction, transformation, data distribution techniques in the ETL process.
• Wrote start routines, end routines, expert routines as well as logic for DTP, infopacks to dynamically change the selection criterion based on sy-datum, etc.
• Extensively worked on write optimized DSO's
• Resolved the RFC issue successfully when we were not getting records into BW from the source system (WAS) as the transaction ids were getting stacked up in the TRFC monitor. (applied a SAP note
• Created export generated Data Sources to test data in Q bringing it from BW Production as well as exporting InfoCubes over to different source systems to bring data over.
• Wrote expert routines for looking up data based on the requirement to do calculations for the CVRT project and created OpenHubs to give data over to Informatica.
• Performed Data load management, CTS, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Multicubes, Data Mart and Open Hub Service.