SUMMARY

• 10+ years of experience as an SAP BW/BO/HANA Technical Consultant including 3 years of experience in SAP Business Objects, 2 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.
• Involved in upgrade project from BI 7.0 to BW 7.3, HANA migration and Support and Maintenance projects
• Worked on various versions of SAP BW starting from 3.1C, 3.5, Net weaver BI 7.0, 7.3 and BW 7.4, 7.5 powered by HANA, HANA Studio 1.0,2.0 SAP BO4.0/4.2
• Defined LSA architectures in implementations for optimizing usage of standard business content
• 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, Created BO Reports on top on Bex Queries using BICS Connection.
• 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, APO-DP and CRM 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 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

Programming Languages: ABAP/4, C.

PROFESSIONAL EXPERIENCE

Confidential, Madison, NJ

Senior SAP BW4HANA Analyst/Lead Consultant

Responsibilities:

• Requirement gathering of the legacy BW metadata objects including Master and Transaction data of the APO flows.
• Involved in lift and shift HANA migration from BW 7.4 to BW 7.5 for HANA.
• Estimate the migration plan for HANA migration of the APO flows as Lift and Shift migration project.
• Prepared cutover activities and lead the migration from end to end activities delivered on time.
• Collected the metadata including info objects, DSO, Cube, Multi provider, Bex, Transformation, DTP, Open hub, APD, Process chains and FM and Programs.
• Transport the objects of the APO BW metadata in a sequence with object dependency from legacy BW to HANA BW where EPM objects already existed without impacting on the common master and transaction data.
• Resolved technical issues during migration and transports of the BW objects and documented for tracking purpose.
• Conversion of the classic DSO to advanced DSO by using T-code RSB4HTRF which converts entire flow from classic to advanced DSO, Cube to advanced DSO and Multi provider to Composite provider.
• Conversion of Multi provider and it’s Bex to Composite provider including Bex by using program RSO CONVERT IPRO TO HCPR
• Created ADSO, Open ODS view and Composite providers for the data flow related to DP and SNP.
• Implemented and developed various scenarios in SAP HANA system related to modelling on Attribute Views, Analytical Views and Calculation Views by graphical.
• Created and managed Delivery Units to move across different environments and maintain schema mapping.
• Organised transports of HANA models through CTS management T-code SCTS HTA
• Created Users, Roles, Privileges, Packages, and Schemas as part of HANA security on HANA life cycle management.
• Perform Build and Unit test on the BW4HANA system for APO flows and documented with test result.
• Lead the Pre-and Post-Go-Live activities after successful UAT, SIT, Regression and VTO

Confidential, Atlanta, GA

SAP BW HANA Lead Analyst

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 Supply Chain Management Reports solution in BW on HANA.
• Materialized data in HANA environmentusingSAPLT 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 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, Roseland, NJ

SAP BW HANA Lead Developer

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 Multi provider 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, Ewing NJ

Lead SAP BW BO HANA Developer

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 datafrom ECC toSAPHANAusingSAPLT 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, Lebanon NJ

Senior SAP BW Techno/Functional 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.

Confidential, Duncan SC

SAP BW Techno/Functional Consultant

Responsibilities:

• Extensively worked on presentations, involved in workshops and break-down sessions for requirement gathering, design and development of the above reports.
• Analyzed and extracted forecast and planning (SNP) data from APO into BW for reporting purposes.
• Extracted sales data from ECC and JDA for demand planning. Used 2LIS 11 VAITM data source to pull data for sales and enhanced this data source to include demand groups sitting in the customer partner functions text fields.
• Used open hub to extract sales data out of BW to send it to JDA for planning purposes.
• Worked on Component View data source 2LIS 04 P COMP, Material View data source 2LIS 04 P MATNR, Production Order Master Data 0PRODORDER.Extensively and 2LIS 03 S194 MRP Data source.
• Activated new GL/AR extractors in ECC.
• Designed and enhanced ECC data sources using BADI’s.
• Developed complex customer/user exit variables, navigational attributes, calculated key figures, restricted key figures in BEx query designer to facilitate data analysis.
• Created WEBI reports and universes using the BEx query as source.
• Worked extensively in writing requirement documents, detailed design documents and test scripts.
• Worked closely with security team to test the developed SAP BW Roles.

Confidential, Bristol, TN

SAP- BI BO Consultant

Responsibilities:

• Activation of standard data sources in ECC in the 11, 12 and 13 application areas of SD.
• Initializing set up tables for sales orders, deliveries and billing.
• Creating DSO’s, Cubes, and Transformations, DTP’s, Info packages and Process chains.
• Worked on Query Design including restricted key figures, calculated key figures, conditions, exceptions, and variables.
• Create Universes and WEBI reports in BOBJ.
• Documentation to execute unit and integration tests in development and quality boxes.
• Involved in unit and integration tests. Resolved performance & production issues with Universes and WEBI Reporting.
• Created Objects in BPC to hold GL actual and PCA data for consolidation purposes.
• Performed reconciliation activity from ECC to BPC 7.5 & BI to BPC.
• Monitored BPC data loads.
• Worked on process chain and subsequent processes monitoring.
• Monitored the data loads and analyzed the reasons for frequent failures of data loads.

Confidential, Pittsburgh, PA

SAP- BI BO Consultant

Responsibilities:

• Extensively involved in data extraction from legacy applications, non-SAP sources, SAP ECC & SAP APO.
• Responsible for customizing and activating the Business Content Objects and loading the data into DSO and Info Cube objects.
• Created SD reports for Daily Bookings and Shipments, Monthly Sales Analysis, Open Orders.
• Extracted data from Shipping LO extract structures 2LIS 12 VCHDR and 2LIS 12 VCITM. Created Info package for both Initialization and delta and loaded in to 0SD C02 Deliveries and 0SD C04 delivery services.
• Extracted data from Sales Billing Extract Structures 2LIS 13 VDHDR and 2LIS 13 VDITM and created Info packages for initialization and Delta to feed 0SD C05 sales Offers/Orders Info Cube.
• Extracted 2LIS 02 S011 (Purchasing Groups), 2LIS 02 S013 (Vendor Evaluation) Data Source for purchasing activities of a single purchasing group and vendor evaluation consistently to a BW system.
• Designed process chains for master data loading, delta loading and for weekly PSA deletion and created events to trigger another process chain.
• Installed and analyzed BI statistics to know the usage of aggregates.

Confidential

SAP BI/BW Consultant

Responsibilities:

• Simultaneously, involved in full life cycle implementation of BI 7.0 along with an upgrade of client’s current SAP BW 3.5 to BI 7.0/Net Weaver 2004s and performanceanalysis.
• Extensively worked on SAP ECC Extraction of Financial data, CO-PA and Sales & Distribution Lo-Cockpit.
• Created Delivery, Billing DSO objects and used DSO objects to update custom Info Cubes.
• Worked with FI Cubes to enhance the performance (modeling, data load) from other systems and did currency conversions for country specific currencies.
• Extensively worked on asset accounting data. Developed reports based on the user requirement
• Worked on generic data extraction in CO-PA. Extracted Line Item data from GL, AR and AP
• Extracted data from MM (Stock Initialization - “2lis 03 BX” data sources). Extensively worked on customer, vendor analysis in BW, integrating data from Teradata to BW using UD Connect
• Activated and customized profit center accounting cubes, accounts payable cubes/.accounts receivable cubes. Created Multi-Providers on Sales, Deliveries and Billing Info cubes
• Involved in the design and development of Profitability Analysis (PA) Cube in Controlling (CO) and Profit Center Accounting (PCA) as part of SAP FICO implementation

Confidential

SAP BW Technical Consultant

Responsibilities:

• Involved in complete BW life cycle implementation from Blueprint to go-live and production support stages.
• Worked with key application users to define information required in other SAP R/3 templates and convert them into functional specifications, and determine the required solution in a SAP BW in order to fit into the global reporting template.
• Extensively involved in supporting SAP BW application and involved in data loading, fixing issues related to data loading, load monitoring, performance tuning, write and modify existing ABAP codes for better performance and issues.
• Extracted data from FICO (GL, AP, AR & COPA), SD, CRM, HR and MM from R/3, from flat files, from Oracle (through DB Connect) and from XML into SAP BW.
• Design, write, test and debug complex data extraction, transformation and load programs according to specifications.