PROFESSIONAL SUMMARY:

• Over 12+ years of strong experience in implementing Enterprise Scale Reporting Solutions using SAP BW / BO/Hana. Architect Design, Develop, and Implement SAP BW Hana systems and processes to capture, integrate and distribute information in enterprise business intelligence.
• Leverage subject matter knowledge in SAP BW with SAP HANA to lend additional credibility to their project teams and add value to their projects.
• Identify business requirements, requirements management, functional design, prototyping, process design (including scenario design, flow mapping), testing, training, defining support procedures and supporting implementations.
• Architect, design and develop an enterprise business intelligence and data warehousing solution.
• Certified in SAP Business Warehouse powered by SAP HANA in Open SAP Online Course
• Experience in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
• Experience in Near Line Storage (NLS) using Sybase IQ to archive data from BW Hana.
• Experience in SLT & RDA processes for Real Time Reports.
• Worked extensively on the BI tools, Business Objects, Crystal Reports, Design Studio, Power BI, Analysis for OLAP, BO Explorer for Info Spaces, Bex Query / Analyzer and HANA reporting.
• Comprehensive functional knowledge in Sales & Distribution (Sales Orders, Deliveries, Billing), MM (Purchasing & Inventory Management), PP, QM, SRM, FI/CO (GL, AR, AP, CCA, PCA and COPA) and General business process of SAP ECC.
• Experience in migration activities for BW 7.3 on Hana migration.
• Involved in planning, design, development, implementation and production deployment of reporting solutions using SAP BOBJ reporting tool for various business process like Sales and Finance.
• Expertise in using Universe Designer(UDT)/Information Designer(IDT) Tool using BICS (Business Intelligence Consumer Services) over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting. Excellent skills to develop reports using SAP Webi/Crystal Reports live Office.
• Extensively worked on BO performance over Bex by implementing Query Stripping, removing unused hierarchies in BEx, Suppressing unused hierarchies in BW.
• Worked as an onsite AMS reporting lead for BOBJ reporting and coordinated with Offshore BOBJ BI teams.
• Extensively worked on Designing and maintenance of data targets like the Info Objects, DSO Objects, Info Cubes, Info Sets, open hub, APD and Multi Providers, SAP HANA - optimized DSOs, SAP HANA-optimized Cubes, Composite Providers, Semantic Partitioned Objects(SPO), 7x Migration Tool, Analytical Index as per the SAP Best practices.
• Experienced in activating standard Business Content, extending and enhancing using User Exits according to the end-user requirements
• Involved in Post-Production support that includes monitoring of process chains and data loads, reconstruction of data targets in case of failed loads, rescheduling of process chains, debugging of transformations.
• Expertise in creating Bex Queries using structures, variables, calculated key figures, restricted key figures, cell restrictions and RRI Jump Queries and modifying standard templates and creating custom templates Using Web Application Designer.
• Expertise in writing ABAP code in start / end routine and routines in transformations, CMOD code for Bex Variables, Custom Extractors.
• Experience training end users in Bex reports, workbooks.
• Experience in working individually, onsite - offshore model, multi delivery location (global delivery) model and multi-vendor environment.
• Worked on BODS Data migration to Migrate data from Non-SAP and ECC systems to SAP BW.

WORK EXPERIENCE:

Confidential, Minneapolis, MN

Sr. SAP BW/Hana Consultant

Responsibilities:

• Worked in Catalyst Rel. 1,2 US implementation
• Involved in a detailed gap analysis between the SAP Standard Business Content and Reporting Requirements.
• Worked on Lag analysis concept where we have we different fiscal variants (USA Vs other countries) to update corresponding Fiscal period.
• Worked on GPC reports design where we have used the concept converting Data Model to KF Model to improve the query performance.
• Worked in Hana Studio for creation of advanced DSO’s & Composite Providers.
• Involved in Analysis Authorization objects for users data security authorizations.
• Designed and developed on ABC/XYZ analysis report by Product & Product location level, on Open PGI, Pipeline Sales reports, OBD (Outbound) & IBD (Inbound) reports.
• Worked on Supply Chain Reports like Monthly Inventory Snapshots, Demand Planning reports, Inventory Projection, Products Past Shelf life & Demand Vs Supply reports.
• Worked on SOE (Statement of Expenses) reports distribution to respective users through broadcasting (using Email Bursting) using Cost Center Authorizations.
• Expertise in writing ABAP code in start / end /expert routine and routines in transformations, CMOD/BADI code for Bex Variables, Custom Extractors.
• Handling Lookups in transformations using ABAP Coding.
• Worked on UC4 job scheduling tool for Process chains schedules.

Environment: SAP BW 7.4/7.5, BW on HANA, SAP ECC 6.0, HANA 2.3.29

Confidential, Minneapolis, MN

Sr. SAP BI/BO/Hana Consultant

Responsibilities:

• Managed Onsite and Offshore Teams and acted as SPOC for all communication
• Involved in Year end and Period end activities.
• Experience in maintenance of Authorization objects for roles in reporting.
• Actively Involved in Providing the Solution for recurring failures in Production to keep system healthy.
• Actively involved in monitoring the Production System and close the service requests (SR) with in SLA deliveries in ticketing tool Global Resolution System (GRS) & Service Now (SN).
• Worked on extremely complex landscape where there is separate path for Break-fix and Development.
• Experience in Data flow with multiple systems like Sending the data from APO (Supply Chain) to BW then to Smart Ops once respective optimization completes sending the resulted data back to BW and then to APO BW.
• Worked in architecture team to design the new requirement and redesign the existing flows.
• Worked as onsite coordinator for all communications.
• Experience in Converting functional requirements to technical design documents.
• Extensively involved in gathering the reporting requirements from the business users by meetings.
• Involved in a detailed gap analysis between the SAP Standard Business Content and Reporting Requirements.
• Extensively worked on writing test scripts and on the Unit and Integration testing of the reports.
• Worked on different areas SD, MM, QM, PP, Inventory and APO (Supply Chain).
• Worked on all the backend objects like Info objects, DSO, Info cube, Info set, Multi providers
• Extensively worked on BWA/BIA, Aggregates, Partitioning of info cubes, and secondary indexes on DSOs.
• Extensively worked on BEx Queries, CKFs, RKFs, Cell definitions, Workbooks, WAD.
• Extensively worked on the start / end routines and the routines in the transformations using ABAP Coding.
• Created generic extractors using function modules and tables for reporting on the custom build contract application in ECC.
• Worked on Inbound and Outbound Interfaces (Ex: Setting up of message types, Partner profiles for the respective configuration)
• Worked on Composite Providers which has the feature of Union and Joining Functionality.
• Worked on APO Pipeline reports.
• Experience in migration activities for BW 7.3 on Hana migration, pre-migration i.e., housekeeping activities and post migration i.e., check consistency of tables by running program ex: RSDU TABLE CONSISTENCY, RS BW POST MIGRATION, transfer inconsistent Info Objects from SAP Business Content.
• Checking DDIC (data dictionary) consistency by running the program RSUPGRCHECK.
• Experience on Converting the Regular tables to Real Time tables through SLT (SAP Landscape Transformation) Process and converting the Standard Data Sources to Real Time Data Sources (RDA).
• Worked on Daemons which will be used to push the data from ECC to BW Hana System at regular intervals.
• Experience in Converting Hana Optimized DSO’s to Standard DSO’s for SLT Purpose by running the program RSDRI RECONVERT DATASTORE.
• Generated BO universe on Bex queries and created SAP Webi reports.
• Worked extensively with SAP Webi intelligence functions, formulas and variables.
• Utilized SAP Webi Intelligence reporting tool to create graphical representation of reports such as bar charts, Pie charts as per requirement.
• Used formatting options such as Cross tab representation, section breaks, data sort options, calculations, fonts, colors and conditional formatting in SAP Web Intelligence.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Scheduled the BO report using Schedule Manager in CMC to run every day on a periodic basis
• Responsible for creating the Crystal Reports On demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports
• Created Dashboards for Freight Level A, B, C, D & E Def, Pref Dashboard Charts & tables in Design Studio.
• Created multiple Analysis Application Using Bex Query as a data source in Design studio
• Sales and Shipment (Freight) relevant information used for charts and tables in design studio.
• In a Single dashboard we have shown the trends of the data year wise, month wise by using multiple analysis applications in design studio.
• Worked on Enterprise Hana to create Attribute Views, Analytical Views and the Calculation Views for the Complex logics (Graphical & SQL Script) in HANA Studio.
• Designed and Developed Reporting on Hana Analytical Views and publish them in BW with Virtual Provider.
• Migrated HANA content from development, testing environment to Production environment using Delivery Units.
• Having Experience in HANA Objects creation using SQL Script for Calculated Views and having exposure in execution of Store Procedure in HANA.
• Reconciled the data with the existing BW Reports with the new HANA Models.
• Converting Data Store objects and Info Cubes into advanced Data Store objects.
• Extensive Knowledge on LSA, LSA++, Composite providers, Transient Providers, Advanced DSO (ADSO) and Open ODS view using BW Modeling tools in HANA Studio.

Environment: SAP BW 3.X,7.X, BW on HANA, SAP ECC 6.0, SAP BO 4.X, HANA 1.0 SPS9, Design Studio

Confidential

Sr. SAP BI Consultant

Responsibilities:

• Worked in architecture team to design the new requirement.
• Involved in upgrade activities from SAP BW 3.5 to SAP BI 7.0
• Involved in cutover plan preparation for all go-lives.
• Worked extensively on performance tuning on existing process chains, set up the dependencies, master data and hierarchies.
• Worked on different areas SD, MM, QM, and Inventory.
• Worked on all the area of ABAP related to BI like extractors, Function modules, Views, Customer-exit variables, Expert routine, start routine and end routine
• Worked on Sales performance reports.
• Set standards, review check list for BW development and ABAP development related to BW.
• Work on BEx Queries, user profiles and role assignment.
• Experience in using BODS as an external system for ETL between ECC and BI.
• Created Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target through BODS.
• Used Open Hub Services to push data out of SAP BI using BODS
• Worked on Developing jobs to extract data from SAP Extractors & Tables, SAP BW DSOs, load to BW PSA
• Worked on creation of DS data stores to connect to data sources such as SAP R/3, SAP BW and Oracle
• Worked on Data Profiling and Data Validation Scenarios

Environment: SAP BI 7.0, SAP BW 3.5, SAP BODS, SAP ECC, and SAP R/3 4.7.

Confidential

SAP BI Consultant

Responsibilities:

• Worked extensively in all the backend objects like DSO, Info cubes, Info objects, multi providers
• Involved in giving training on BI activities to core technical team
• Worked extensively on extractors / Data sources.
• Work on Bex Queries, RRIs, WAD, CKFs and RKFs, role assignments.
• Exposed to full lifecycle right from BW configuration, modeling, analysis, design specification, development, performance tuning and maintenance.
• Designed Technical documents based on business requirements in SD, MM, Financial Management.
• Analyzed, Designed, developed, coded and implemented standard/ customized Info Cubes and DSO (ODS) Objects for MM, SD, FI-CO
• Extensively worked on Generation of Data sources, activation of Info Sources, Transferring Master Data to Characteristics and Transaction data from ECC systems to Info Cubes in BI. Responsible for loading Plan/Actual Master data (Texts, Attributes and Hierarchies)/Transaction data from ECC Data Sources and from Flat Files.
• Regarding Logistics Extraction Cockpit, Maintained extract structures for Sales & Distribution. Developed and enhanced data sources & activated the extract structures for the above modules. Designed data loads Schedule for Lo-cockpit Data Sources.
• Involved in Preparing the Business Blueprint Documents.
• Involved in Loading of Historical Data from Oracle 10g to SAP-BW through DB
• Used the Business Content Sales Overview Infocube for overall Sales Analysis. The transaction data is loaded from different Source Systems using the Info Sources such as Sales Order, Delivery, Billing Document and Sales Order/Delivery using LO-Cock Pit.

Environment: SAP BI 7.0, SAP BW 3.5, SAP ECC, and SAP R/3 4.7.

Confidential

SAP BW Consultant

Responsibilities:

• Worked on activation of BI Content and modified standard extractors related to SD and MM.
• Extensively used BW standard Lo-cockpit business content extractors to extract data from SAP R/3 to BW and performed enhancements to accommodate business needs.
• Designed and developed Info cubes, Info Sources and loaded data from SD module to BW. Worked on line item dimensions.
• Used ABAP Routines in Update rules & Transfer Rules to update characteristics and Key Figures in the Info Cubes.
• Created Info Packages and Info Package Groups to do Full, Initial, and Delta extraction for both Master and Transaction data.
• Involved in Converting the key figure Data model into Account Data model in Budget and forecast part.
• Created transport and communication structures, transfer rules, update rules for ODS and Info Cube.
• Created custom CO-PA Cube, ODS, Data Mart to satisfy business requirements.
• Developed designs dealing with currency conversions as per the user requirements.
• Managed and monitored several data loads. Optimized load performance by adjusting the packet sizes.
• Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
• Worked extensively on BEx Analyzer and customized the reports creating variables, exceptions and conditions.

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