SUMMARY

• 7 years of experience as an SAP BW/BO/HANA Technical Consultant including 2 years of experience in SAP Business Objects, 1 year of experience in SAP HANA and extensive experience in SAP ABAP.
• Highly experienced in analysis, design, development, implementation, testing, trouble - shooting and documentation of applications in SAP BW/BI Client/Server environment.
• Certified in SAP HANA & SAP ABAP
• Involved in upgrade project from BI 7.0 to BW 7.3
• Experienced in blue printing, requirement gathering and interacting with business users for BI reports, data modeling, architecture, design, development and configurations for many multinational companies.
• Well versed and experienced in Dimensional Data Modelling in HANA Studio and have strong skills in areas of SAP BW/BO & SAP HANA.
• Good Knowledge of Data Provisioning and replicating data from source system to HANA Database using SLT, Sybase Replication Server and Business Objects Data Services. (Trigger based, Log based and ETL)
• Worked on complex calculation views, analytic views & attribute views for master data.
• Worked on POC related to pharmaceutical industry powered by SAP HANA by following best practices, optimized data models along with consuming these data models in MS Excel and Business Objects Explorer.
• Excellent experience in design and development of Info cubes, Multiprovider, DSO/ODS, semantically partitioned DSO info sets, data sources, info objects, transformations, Open Hub, extractor configuration and data loading, information broadcasting and process chains.
• Extensively worked on Dashboards, BEx analyzer, BEx Query designer, WAD, Variables, Jump query-RRI and publishing reports in EP.
• Worked on complex WebI reports & Crystal reports.
• Involved in extracting data from R/3 using BW content extractors, custom generated extractors and generic extractors.
• Extensively worked on various modules in R/3/ECC such as SD, MM, FI (AR, AP, and GL), APO-DP, HR, CRM and COPA for extracting data and loading into BW data targets.
• Hands on experience in ABAP/4 in BI and ECC, including but not limited to extractor enhancements, transformations, generic extraction using function modules and user exits/BADI.
• Worked on time conversion and currency conversion based on client requirements.
• Performance Tuning: Proficiency in query and load performance improvements using Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques. Evaluated statistical performance on OLAP using BW Statistics
• Involved in end to end testing (Unit testing, User acceptance testing, Data validation testing) between BW and R/3
• Extensively involved in data extractions from legacy applications like (JDE, SPIES, Oracle SQL Server and Flat Files) and SAP R/3.
• BW Transports: Involved in testing the extractors, data loads and reports before going into production & transporting the BW objects from development to quality and subsequently into production.

TECHNICAL SKILLS

ERP: SAP R/3 4.7/4.6C., ECC 6.0 BO XI 3.1, BPC

SAP Modules: FI/CO, Logistics (SD, MM, PP) CRM, and SRM.

Data Warehouse: Netweaver 04s BI 7.3 7.0, BW 3.5, 3.1, HANA Studio

Reporting Tools: BEx Reporting (BW 7.3/BI 7.0/BW 3.X), BO XI 3.1, Xcelsius

Programming Languages: ABAP/4, C.

Interfaces: Workflow, Enhancements, BAPI.

Operating Systems: IBM AIX 5.3, Debian (Woody, Sarge), Ubuntu

Others: MS Office Suite, Quick Test Pro, HTML, Dreamweaver, FrontPage, Photoshop

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/BO/HANA Technical Consultant

Responsibilities:

• Migrated SCM data flow from Actavis’ SAP BW system to Allergan’s SAP BW system for users in Actavis to have a seamless user experience in Allergan’s systems as well. The users have access to the same reports and dashboards in Allergan system as well.
• Improved the performance of the data flows by optimizing the design while replicating to Allergan BW system.
• Worked with business users to in corporate additional enhancements to the existing data flow while replicating the data flows.
• Replicated complex BEX reports and Webi reports.
• Involved in unit testing and UAT of the complete data flows.
• Involved in post-production deployment hyper care.
• Extensively worked with Quality Management Team to understand Business requirement.
• Worked with SAP ABAP team to develop an USER Interface in BW system for Quality Management team, replacing excel based data management. USER Interface is built using the DSO Table as backend source tables for USER Interface.
• Built Master data for specific for the Quality management User Interface.
• Developed APD’s and DSO’s to provide data to QlikView Dashboards.
• Built Unit Replenishment Report using Demand Forecast from SAP APO and Delivery data extracted from 2LIS 12 VCITM.
• Built Unit Sales Report is built using Sales Forecast from APO and Delivery data extracted from 2LIS 12 VCITM.
• Unit Sales Report and Unit Replenishment Report are designed to do unit conversions based on the material group.
• Worked on Shipment Report where the report is built on Billing data (extracted using 2LIS 13 VDITM) & Delivery Data (2LIS 12 VCITM)

Confidential

SAP BW/BO/HANA Technical Consultant

Responsibilities:

• Analyzed production boxes for performance tuning using different tables like RSRREPDIR, RSDDSTAT DM, RSDDSTAT OLAP RRKMULTIPROVHINT
• Used RSRV to identify dimensions in the cube that were more than 20% of the total cube size and marked them as line item dimensions
• Resolved memory consumption issues in BWA by archiving historical data, only maintaining the latest data in cubes and updating BWA with them and removing unused cubes in the BWA system worked on parameter changes for all queries which run BWA
• Worked on SPO Cubes to improve performance and reduce Query Data Manager time
• Analyzed top queries and changed the “read” mode and “cache” mode parameters
• Worked on Multiprovider Hint to improve Query Data manager time
• Created a standard procedure on BWA regular maintenance
• Worked with Production support Team and prepared a Checklist on regular maintenance.

Confidential

SAP BW/BO/HANA Technical Consultant

Responsibilities:

• Extensively worked on preparing user requirement document, functional requirement documents and technical documents for SAP HANA Migration.
• Responsible for design, development and deployment of the complex CRM Reports solution in BW on HANA.
• Materialized data in HANA environment using SAP LT replication server
• Good knowledge of SAP Landscape Transformation and its configuration
• Involved in Execution and monitoring of data replication process
• Worked on SAP Direct Extractor Connections to extract using Data sources from ECC to HANA system
• Worked on HANA Modeling. Developed the HANA Attribute, Analytic and Calculation (Graphical Modeling/SQL Script Views) for the User reports.
• Strong expertise in SAP HANA security model and its configuration.
• Defined HANA Variables and Parameters for the reporting.
• Worked on User Management Analytic Privileges. Created dynamic Analytic Privileges using SQL Script.
• Strong expertise in working on SAP HANA Development Object and Repository
• Create SAP ECC table data model and analysis, design data models and analytical apps, and implement SAP SLT replication schemas in SAP HANA.
• Administer, monitor, troubleshoot, analyze and resolve technical problems within HANA environments
• Implemented universe on SAP HANA 1.0 (SAP in-memory computing) to provide integrated ad-hoc solution via BO 4.0
• Provided advanced SAP BI and SAP HANA Training
• Involved in user training and documentation.

Confidential

SAP BW/BO/HANA Technical Consultant

Responsibilities:

• Worked on Pilot Real-time Sales Analysis report using analysis for office and views from SAP HANA.
• Extracted data from VBAK, VBAP and VBEP using SLT to get real-time data from SAP ECC.
• Created Attribute views for master data. Replicated data from T001W, ADRC for Plant Master Data Replicated data from MARA for Material Master Data, Replicated data from TVKO for Sales Org Master Data
• Created complex analytic views & attribute views for master data based on the user requirement.
• Using Analytical Privileges provided different security access to users at different levels based on the requirement.
• Worked on replication of data from ECC to SAP HANA using SAP LT replication server
• Extensively worked on Advanced DSO, Transit Provider & Composite providers.
• Worked on SAP Direct Extractor Connections to extract using Data sources from ECC
• Extensively worked on SAP Business Objects 4.1 upgrade and unit testing of reports after migration.
• Extensively worked on Terra system Integration.
• Provided Terra system with Sales History, MRP Data from ECC & Purchase order History using APD’s
• Built complex APD’s using Info providers as source, complex code was written using ABAP Routines in APD, aggregated data for different granularities using Aggregation in APD’s.
• The files generated using APD’s were placed directly on TERRA system using logical file path created by the SAP BASIS team.
• Customer Exist variables were created to set filters in APD’s.
• Forecast data from TERRA system is extracted into SAP APO system and then in turn into SAP BI system for reporting purpose.
• The Inbound freight report is built on two data sources FI data (3FI GL Z1 SI) and shipment data (2LIS 08TRTLP).
• Shipment number from 3FI GL Z1 SI is used to do look up on DSO (built on 2LIS 08TRTLP) to extract shipment information.
• Indexes were created on DSO and master data info objects to improve the performance of the loads.
• Filters were set at G/L Account level for Inbound Freight variance report as the report is only related to Freight charges.
• BEx Query is built using Query Designer and WebI reports using SAP Business Objects 4.1 for inbound freight variance report.
• Extensively worked on Analysis for office to develop pilot reports to understand the Analysis for office tool.
• Complex Process Chains were created to trigger APD’s, Extract data from APO for forecast reports and Extract shipment & finance data for inbound shipment freight variance report.

Confidential

SAP BW/BO/HANA Technical Consultant

Responsibilities:

• Involved in the requirement gathering, design and development of the above reports.
• Involved in development of functional requirement specifications and technical specifications.
• Extensively used SAP BW Version 7.3 to generate client required reports.
• Extensively worked on data extractions from legacy applications & non-SAP sources like JD Edwards and R/3 systems.
• Extracted delivery and inventory data from LO Extra structures 2LIS 12 VCITM & 2LIS 03 BF respectively.
• Extracted forecast data from SNP planning book using export data sources created in SAP APO. Data sources 8ZEUDP C05, 8ZLADP C05, 8ZNADP C05 & 8ZAPDP C05 were used to extract Forecast data.
• Used Multi Providers and navigational attributes in transformations and navigational attributes in DTP’s to filter data.
• Worked on function modules to convert JDE system date to SAP system date. Used ABAP routines in DTP have to apply complex filters.
• Generic data sources are created to extract inventory from MARD table in Legacy R/3 system
• Using UD connects, created data sources to extract data from legacy systems like JD Edwards & SPIES using COMPOSITE middleware tools.
• Worked closely with TIBCO MDM team for data harmonization as the data was extracted from different systems.
• Created new master data info objects for data harmonization like NSOUMAT- source material, NSOURPLNT-source plant, NSMAT PLT-source material plant and NSOURSO- source sales organization.
• Created Open Hubs to send data to TIBCO MDM or in some cases used P-tables as a source.
• Developed Customer Exist Variables using the CLASSES thus improving the efficiency of INCLUDE ZXRSRU01
• Worked on currency conversions for Batch report.
• Extensively worked on custom hierarchies, extracted hierarchy data from flat file to SAP BW
• Developed APD’s using Queries as a source and Direct update DSO as target to send data to SPOITFIRE Dashboard using Active table of a direct update DSO as source to dashboard.
• Worked closely with SAP BASIS team to ensure smooth transition of BW objects from development to production and from development to quality environment.
• Supported all the daily BW production/business issues as well as future enhancements.
• Worked on SAP SOLUTION MANAGER to update technical documents.