SUMMARY

• SAP BW/BOBJ Certified with 10 years of SAP BW, HANA, BPC and BOBJ experience.
• Worked as BW & BPC Consultant, BW on HANA Consultant, SAP HANA Developer, BW & BOBJ Consultant and Sr. SAP BI Consultant for Multiple industries like Digital, Oil & Gas, Medical, Retail Industry and Manufacturing Industries.
• Experience in Information Technology industry with SAP HANA, SAP BW ( BW 7.4,BW 7.3, BI 7.0, BW 3.5), SAP BPC 10.1, SAP BOBJ (4.1, 4.0, XI3.1), SAP BODS, SAP ECC.
• Coordinated with business/users and responsible for deployment & Go - live (Review/approve transport, solution architecture, help troubleshoot and coordinate any issues with basis and functional teams).
• Experience in SAP BW Implementation, Support, Upgrade, Rollout
• Experience in 5 full life cycle implementations including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Training Documentation and end user training.
• Expertise in SAP HANA Modeling of Attribute Views, Analytic Views, Calculation Views, Procedures Decision Tables, Package & Schemas and Analytic Privileges.
• Extensively worked in SAP HANA Data provisioning activities to provision the data from SAP & Non-SAP sources systems using BODS ETL Based & SLT Based replication
• Expertise in SAP HANA to BW & BW to HANA model importing mechanism and provided solutions for Blended Scenarios reporting for BW on HANA Implementation projects.
• Extensively worked in BW 7.3 components (Transient Provider, Composite Provider and SPO).
• Extensively worked with BPC Planning using Models, dimensions, input templates and Reports
• BW Architect, Experience in BI 7.0, BW 7.3 End to End implementation & production support projects using ASAP
• Experience in SAP BW Data modeling of Info Cube, Multi Provider, Virtual Provider, Transient Provider, Composite Provider, DSO, Info Objects, SPO, Data source, Transformation & DTP, Process Chains, Open Hub Destination (OHD), APD.
• Extensively worked in SAP BW Data Extraction from Multiple SAP and Non SAP (Legacy) Systems using BI Content Extractions LO, FI, SD, HCM, Flat File, and Generic Extraction
• Designed and developed queries for reporting using BEx Analyzer, Query Designer and Web Application Designer
• Extensively involved in Data load & Report Performance tuning Techniques (Partitioning, Parallelization, Aggregates, Cube Compression, Line Item Dimension, and Indexing).
• Extensively involved in SAP BI-BW Production Support in handling daily batch jobs, load failures, delta failures, Performance issues, BIA issues, System issues, reporting issues, locking issues, resource bottleneck issues.
• Extensively worked in SAP Business Objects (BO 4.1, BO 4.0, BO XI 3.1) tools like Universe Designer, Information Design tool, WEBI and Dashboards.

TECHNICAL SKILLS

• SAP BI 7.0
• BW 7.3 & BW 7.4
• BPC 10
• SAP HANA 1.0 SP5
• SP6
• SP7(HAN Studio)
• Business Explorer
• Web Application Designer
• Business Objects 4.0
• Information Design Tool
• Universe Designer
• Webi & Dash boards
• SAP ECC
• SD
• MM
• FI/CO
• QM
• PP
• CRM
• Transportation and shipment

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr. BW/BPC Consultant

Responsibilities:

• Analyzing the business requirements and converting them into Functional design and Technical design documents
• Worked on End to End development of Order to cash objects which includes, R/3 enhancements, Creating DSO's, Update rules/Transformations, Creating info cubes, creating the queries and reports
• Prepared BW Cutover check list and handled cutover activities
• Create, Maintain custom dimension/ info object, dimension property, for entity, account, product, time
• Copy packages to copy the forecast, plan, and budget data.
• Developing, unit testing the reports using the EPM functions. Created and Maintained Application Sets(Environment),Dimensions and Applications(Models) in BPC
• Created and Maintained Input Template and Reports Template in BPC
• Usage of conversion, transformation files for the data management process.
• Configure data manager extraction from ECC and BI system for the actual, plan data.
• Performed Data Loads in SAP BPC NW from flat files.
• EPM report functions.
• BPC process chain development to the financial data to staging DSO and to the cube
• Process chain development to support master data loads from BW to BPC
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created monthly and summary reports in WEBI 4.0 for the different domains like Finance and SD.
• Worked on Order to Billing report which gives complete details of the sales order to Order creation to Billing.

Confidential, CA

Sr. BW/BPC Consultant

Responsibilities:

• Created and maintained Dimensions, Models. Customized the dimension properties as per the requirement.
• Loaded Master data and Transactional data into BPC
• Created Data Manager package to execute the BPC process chains
• Worked with EPM functions and created input forms and Reports
• Worked with Formatting of Input forms and Reports
• Worked with EPM Functions Dimension override, Sorting Override, Insert cells before after block
• Worked with Data filtering, Sorting and Ranking functionalities
• Involved in Unit Testing, UAT and performed Reconciliation between BPC vs BW systems
• Worked with Forecast and Budget related Finance Reports
• Worked on front-end Business Warehouse tools for creating consolidated income statement and Balance Sheet, Profit in Inventory and Cash flow report

Confidential, CA

Sr. BW/HANA Consultant

Responsibilities:

• Involved in development of HANA objects Attribute Views, Analytic Views, Calculation Views to implement the real time data reporting directly from ECC through HANA.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Created Universes on top of HANA calculation views and developed the Webi reports.
• Extensive experience in SAP SLT and Business Object Data Services (BODS) to acquire the data into SAP HANA Data Mart (Native and BW on HANA).
• Imported ECC Tables into HANA using BODS and replicated the data
• Worked with BODS functionalities Project, Job, Work flow, Data flow, Data store to import the tables from ECC to HANA
• Data Load via SAP BW extractors (DXC ) to HANA from Legacy, Performed data modeling and developed Analytical views for the transactional data,
• Integrate SAP BW on HANA data with HANA models using Composite & Transient providers
• Developed Webi reports, extensively used Prompts, Variables, Drill down, Breaks, Sections, Conditions, input controls

Confidential, TX

Sr. BW/HANA Consultant

Responsibilities:

• Developed Attribute views for the master data and Analytical views and Calculation views for the Transactional data.
• Imported ECC Tables into HANA using BODS and replicated the data
• Worked with BODS functionalities Project, Job, Work flow, Data flow, Data store to import the tables from ECC to HANA
• Loaded ECC tables into target schema tables using SLT based table Data Provisioning and also performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Worked on migrating standard SAP Models to In-memory optimized models and Performance testing.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Integrate SAP BW on HANA data with HANA models using Composite & Transient providers
• Reporting (BEx Query Designer, WEBi).

Confidential

Sr. BW/BO Consultant

Responsibilities:

• Involved in preparation of Technical Design, Development and Testing.
• Analyzed the Functional and Technical Designs, raised gaps to related FD Owners.
• Interacted with Functional designers regarding the issues as part of the Build and Test.
• Involved in Unit testing, FAT and Integration Testing for the developed objects.
• Prepared Unit testing scripts and successfully executed Unit testing, Functional Acceptance testing by resolving the issues.
• Attended weekly status meeting to update the Build and testing status to the client manager.
• Prepared Process chain template and AS IS document from the existing data flow.
• Worked on End to End development of Order to cash objects which includes, R/3 enhancements, Creating DSO's, Update rules/Transformations, Creating info cubes, creating the queries and working on WAD to publish the reports into Portals.
• While making the changes to existing objects taken care of dependencies, collecting the objects into a sequence of transports.
• Moving the transports from Development to QA system and fixing any issues happening as part of the transportation.
• Involved in UAT and Go-live process.
• Worked on Defects raised during different phases of Testing like Integration Testing and UAT.
• Worked on Info set and Multi providers.
• Worked with Bex and Web Reports, in Bex used Variables, Calculated and Restricted Key figures
• Worked with Statistical setup jobs for inventory, sales, Delivery, Billing and other LO extractors
• Prepared Cutover checklist and participated in cutover activities
• Created Sales order stats report, Order to Billing Report, Invoice Volume Report, OTIF summary and Detail report where user can drill down from summary to detail using RRI.
• Worked on Order to Billing report which gives complete details of the sales order to Order creation to Billing.
• Modified the Technical Design and Functional Designs with new Change request details and uploaded them into Solution Manager.
• Created Input ready Queries and worked with Webi Reports in BO.
• Worked with Planning area, Planning functions, Planning level, Planning package and web interface builder.

Confidential, IL

Sr. BW Consultant

Responsibilities:

• Analyzing the business requirements coming through change requests with the business users and translated into Functional Design and Technical Design Documents.
• Attended interaction meetings with the project team members and end users to understand the requirements.
• Attending the Weekly Project status meeting to discuss about the Open tickets, Open issues and any planned maintenance activities.
• Attending the Release management meeting to address the new changes to be released to production as part of Weekly and Monthly release after we receive the UAT from Business Users.
• Worked on priority 1 & 2 tickets and resolved them with in the SLA limits.
• Preparing the RCA for P1, P2 tickets (for future reference) and sending it to client support manager for the review.
• Maintaining the SLA 100% with out any deviations.
• Maintained the system with out any issues during Period close, Quarter close and Year end close. Avoiding any unplanned outages and providing the 100% system availability to Business.
• Managing the daily overnight loads as part of monitoring and guide the team members to fix any issues encountered as part of daily monitoring.
• Sending notification to relative end users when ever some issues happened in Overnight data loads and not able to resolve them by start of the business day.
• Following all the preventions to avoid any impact of the new objects when moving into Production.
• Following the client specific processes through Mercury ITG (KINTANA) tool for approvals and documentation required to move the ticket step by step.
• Managed and developed a process of refreshing QA environment, coordinating any issues with the refresh with BASIS and Security team.
• And performing all the Post refresh activities into QA environment once the refresh is over.
• Involved in testing support packs, OSS notes, query development, and on-call responsibilities.
• Configure, validate, and promote requested enhancements to existing BW solutions.
• Anticipate and resolve project and support services risks and obstacles, and recommend solutions.
• Worked with FI-AR, FI-AP, FI-GL, SD, MM, PS, AM, CCA and PCA.

Confidential, CA

Responsibilities:

• Involved in Blue print phase by collecting the requirement related to Personal Expenses, Capital Expenses Reports
• Prepared AS IS, TO BE Documents and FDS Documents.
• Worked with Cost center planning, Revenue Planning, CAPEX, OPEX, Personal planning.
• Created Real time cubes, Aggregation levels, Filter, Planning functions and planning sequences.
• Created Characteristic relations using Top down distribution and also worked with Data slices.
• Worked with Planning functions (Copy, delete, Revaluation, Distribution, unit conversion and Currency conversion).
• Worked with Flat file load of Budget, Forecast and Plan data into the Real time cubes.
• Maintain Master data and created variables in IP.
• Created Input ready Queries and worked with WAD to create web layouts for plan data.
• Included planning sequence, planning functions, save, exit, refresh functions in web layout.
• Responsible for transformation of Business requirement to Technical specification and implementation of end-to-end solution.
• Involved in analysis, design, development, testing, deployment of solutions, and post-production support.
• Worked with Cost center Accounting, FI-AR, FI-AP,FI-GL, SD,MM.
• Worked with Basic and Transactional cubes, Transformations, loaded data using DTP from PSA to DSO and Info cubes.
• Created process chains to automate the transaction / master data loading from SAP and Non-SAP.
• Used LO, CO-PA, PCA, FI-GL, FI-AP, FI-AR extractors for extracting logistics and FI related data into BW.

Confidential, CA

Responsibilities:

• Worked with planning area, and multi planning area while working with Profit Center Accounting and Cost Center Accounting.
• Assigned different Finance transactional cubes to the planning areas
• Uploaded data into Transactional cubes for Plan, budget and Commitments
• Worked with Flat file upload of data to upload different flat files (HR Data, Expenses, budget, and salaries).
• Created planning level, planning package and layouts
• Worked with planning functions like Copy, Revaluation, delete, Repost, currency translation, unit conversion and Distribution.
• Worked with planning functions, parameter group.
• Worked with and planning sequence, characteristic relationships, data slices and variables
• Worked with Web interface builder and Planning Folders
• Worked with Planning area, planning level, planning package and planning functions.
• Created Layouts, parameter group and planning folders.
• Worked with Web interface builder, data slices variables and characteristic relations.
• Worked with Basic and Transactional cubes, Transformations, loaded data using DTP from PSA to DSO and Info cubes.
• Involved in unit testing and UAT for all the developed objects.
• Transported modified/new objects from development system to Test and Production system using BW transport mechanism.

Confidential, CA

Responsibilities:

• Worked with users to analyze and translate business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Work collaboratively with Project managers and Technical Leads to perform necessary tasks in order to realize stated milestones/deliverables on time and on budget.
• Involved in UAT and Go-live process.
• Worked with Position reports, Forecast reports. Billing reports, booking reports and backlog reports.
• Worked with FI-GL (Balance sheet, P&L for the current period, QTD, YTD), FI-AR, FI-AP, MM (Inventory stock reports, inventory aging, purchasing reports).
• Created process chains for master data and transactional data.
• Created Work books and involved in End user training of Reporting.

Confidential

Responsibilities:

• Created ODS and cubes for FIN, SD, MM, WM, QM and PM by referring into L2 Specs.
• Created the objects by following the standard naming conventions
• Worked with calculated and restricted key figures, variables and free characteristic
• Worked with unit testing for all objects in R/3, PSA and at data target level.
• Involved in Go-live and retransported all the failed transports from QA to Production box
• Worked with bug fixing of all assigned defects while doing integration testing by looking into the issue log
• Created process chains for master data and for transactional data.
• Worked on SAP BW functionality like LO Cockpit, COPA, Generic extractions and flat file extractions.
• Loaded the master data (Attributes, text and hierarchies) and transactional data from five clusters(R/3 source systems).
• Loaded Historical data in production box for FIN, STC, WM, QM, PM and MFG by resolving the data load errors.