SUMMARY

• Certified in SAP BW/BOBJ and HANA SP 9 with 11 years of SAP BW,BPC,HANA and BOBJ experience.Working as BW & HANA Consultant, BW & BPC Consultant, SAP HANA Developer, BW & BOBJ Consultant and Sr. SAP BI Consultant for Multiple industries like Digital,Oil & Gas, Medical,Wholesale,Retail Industry and Manufacturing Industries.
• Experience in Information Technology industry with SAP BW (BW 7.5,BW 7.4,BW 7.3, BI 7.0, BW 3.5), SAP BPC 10.1,SAP HANA SP11,SAP BOBJ (4.1, 4.0, XI3.1), SAP BODS, SAP ECC, SAP CRM.
• 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 Migration of BW systems to BW on HANA
• 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 and SDA
• Worked with Near Line Storage(NLS)
• 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.
• Experience in SAP BW Data modeling of Composite Provider, AdvDSO’s,ODP, Open ODS Views, Info Cube, Multi Provider, Info Objects, SPO, Data source, Transformation & DTP, Process Chains, Open Hub Destination (OHD), APD.
• Extensively worked with BPC Planning using Models, dimensions, input templates and Reports
• Extensively worked in SAP BW Data Extraction from Multiple SAP and Non SAP (Legacy) Systems using BI Content Extractions LO(SD,MM,PP,QM,PM), FI/CO, 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,Analysis for Office, Explorer and Design Studio
• Worked in Agile methodology and delivered user stories with in the Sprint time lines.
• Worked in Waterfall methodology to deliver the Change requests as part of Quarterly release
• Ability to co-ordinate multiple tasks with conflicting priorities

TECHNICAL SKILLS

• SAP BI 7.0
• BW 7.3
• BW 7.4
• BW 7.5 &BPC 10.1
• SAP HANA 1.0 SP5
• SP9
• SP11(HANA Studio)
• Business Explorer
• Web Application Designer.
• Business Objects 4.0 (Information Design Tool
• Universe Designer
• Webi
• Analysis for Office
• Explorer and Design Studio).
• SAP ECC
• SD
• MM
• FI/CO
• QM
• PP
• CRM

PROFESSIONAL EXPERIENCE

Confidential, NC

BW/HANA/BPC Consultant

Responsibilities:

• Analyzing the business requirements and converting them into Functional design and Technical design documents
• Created Analytical views and Calculation views (Dimension and Cube) using ECC and BW/BPC Schema Tables in HANA Studio
• Created Composite providers in BW Modelling based on Calculation views
• Used Calculation views as Data sources using ODP source system and Data source is updated to Open hub to supply the data to third party systems from HANA Views
• Transported HANA Calculation Views from Dev to QA, PreProd and Production systems using Transaction SCTS HTA
• Worked with Variables, input parameter, Restricted and calculated columns
• Input parameters using Read from Table, mapping of Input parameters, created variables at semantic layer and applied filters at the different levels of HANA Views to avoid performance bottle necks
• Worked with Aggregation, Projection, Star Join, Union, Inner Join, Left Outer Join and Text Join
• Worked with Adv DSO in BW Modelling and used Nav Attributes in Composite Provider
• Generated SQL and used where condition filters as part of Testing the HANA Views to avoid any performance issues
• Worked with Plan Viz perspective to analyze the performance of the HANA Views
• Worked with ABAP Perspective to generate the HANA View as an External view, which can be used as a ABAP Table
• Created Virtual Cubes on top of Non SAP source systems using Adapter DTP virtually shown the data in Bex reports on top of Virtual cubes
• 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).
• Worked with BODS functionalities Project, Job, Work flow, Data flow, Data store to import the tables from non SAP to HANA
• Worked with Calculation views using semantics for Currency Conversion and Unit of Measure Conversions.
• Worked with Column views
• Worked with BPC Models, Dimensions, Transformation files, Conversion files and DMP’s
• Combined data from BPC Models and BW Info providers, created Analytical and Calculation views on top of them. On top of Consolidated final calculation view, using it as a BW data source through ODP source system generated the outbound files with the help of Open hub destination
• Worked with LTR,LTRC,Trigger table and Log table
• Involved in HANA Upgrade from SP9 to SP11
• Having good knowledge on Smart data Access(SDA), Smart data quality integrator to access the data from different Data bases using Virtual tables, Transformations(HANA Flowgraph)

Confidential, WA

BW/BPC Consultant

Responsibilities:

• Analyzing the business requirements and converting them into Functional design and Technical design documents
• Worked with ECC,DB Connect and BODS to bring the SAP and Non SAP data into BW
• Worked on End to End development of OPEX,COGS, Accountability Margin, Head Count, Ending Inventory, Monthly Currency and Budget Currency
• Created Actuals, Forecast and Budget related DSO's, Transformations, info cubes as per the Business requirement
• Crated Account, Profit center,Product Family and Geography Master data
• Created Profit Center(Forecast and Budget), Product Family(Forecast and Budget)Hierarchies and Geography Hierarchy which will be used in BPC Input forms and Reports
• Created and Maintained models, dimensions, members, for Account, Product Family, Geography, Profit center and Allocation Rule
• Created Process chain which can take care of dependencies in data loads and which can be used based on Planning cycle for Budget, Forecast and Actuals.
• Process chain development to support master data and Transactional data loads from BW to BPC
• Worked with Unit Testing, Integration Testing and UAT
• Worked with different defects raised by Testing team and Business Users
• Created and Maintained Input Template and Reports Template in BPC
• Worked with Script logics/BADI and Member formulae's and included them into Data manager package
• Usage of conversion, transformation files for the data management process.
• Configure data manager extraction for the actual, forecast and Budget data.
• EPM report functions.
• Involved in Pre/Post Go-Live activities
• Worked with SAP Max Attention team as part of BW to BPC Load Performance issues and implemented OSS Notes to resolve the issues
• Worked with Light Optimization of BPC models to improve the Performance of Input forms and Reports
• Worked with BPF’s, Process Templates and Process Instances as part of the Budget Cycle

Confidential, OH

BW/HANA Consultant

Responsibilities:

• Involved in Requirements gathering and preparing the Functional design and Technical design
• Involved in development of HANA objects Attribute Views, Analytic Views, Calculation Views to implement the real time data reporting directly from ECC through HANA and BW.
• Created/maintained Schemas and packages, worked with Analytical privileges
• 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.
• Worked with Variables,input parameter,calculated columns,Generate time data, Time Attribute and Hierarchies (Level Hierarchy and Parent child hierarchy)
• Created Universes on top of HANA calculation views and developed theWebi 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
• Worked on migration of BW systems to BW on HANA
• Worked on Pre and Post Migration activities and implemented the relevant OSS notes along the systems in Dev, QA, Pre Prod and Prod
• Involved in Unit testing, Integration Testing and UAT
• Developed Webi reports, extensively used Prompts,Variables, Drill down, Breaks, Sections, Conditions, input controls
• Worked with Design studio, created analysis application, worked with data sources, analytic components, Basic and container components

Confidential, IL

Sr. BW/HANA Consultant

Responsibilities:

• Analyzing the business requirements and converting them into Functional design and Technical design documents
• Worked on migration of BW systems to BW on HANA
• Worked on Pre and Post Migration activities and implemented the relevant OSS notes along the systems in Dev, QA, Pre Prod and Prod
• Worked on End to End development of Finance module which includes, R/3 enhancements, Creating DSO's, Update rules/Transformations, creating info cubes, creating the queries and reports
• Worked on the performance improvement techniques at different stages of data model and at Reports level.
• Prepared BW Cutover check list and handled cutover activities
• Involved in development of HANA objects Attribute Views, Analytic Views, Calculation Views to implement the real time data reporting directly from ECC through HANA and BW.
• Created/maintained Schemas and packages, worked with Analytical privileges
• Worked with Variables,input parameter,calculated columns,Generate time data and Hierarchies (Level Hierarchy and Parent child hierarchy)
• 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.
• Developed WEBI reports on SAP Bex Queries using BICS in Webi Rich client.
• Created Balance sheet report, Ageing Reports, Overdue analysis reports, CAPEX and OPEX Reports and other Finance Reports.

Confidential, TX

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 and BW.
• Created/maintained Schemas and packages, worked with Analytical privileges
• 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 theWebi 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
• Involved in Unit testing, Integration Testing and UAT
• 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

Sr. BW/BO Consultant

Responsibilities:

• Involved in preparation of Technical Design, Development and Testing.
• Analyzed the Functional and Technical Designs, raisedgaps to related FD Owners.
• Interacted with Functional designers regarding the issues as part of the Build and Test.
• Involved in Unit testing, FATand 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 andPCA.

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 transported 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.