SUMMARY:

• Over 10 years of experience in SAP and more than 6 years as Lead / Architect in SAP BW, SAP ERP, SAP HANA, SAP BI and SAP BPC.
• Successfully handled and delivered projects involving SAP BW  covering core SAP ERP modules, SAP BW on HANA, SAP BPC standard, SAP HANA development, SAP BW upgrade, and SAP BW integration with SAP BI (Business Objects). 
• Exposure to SAP implementations in Semiconductor industry, Telecommunications, Consumer Products and Professional services
• Experienced and well versed with SAP ECC modules functionality including SAP General Ledger, Controlling, Finance Account Payables and Account Receivables, SAP Order Management, Shipping, Pricing, Purchasing, Inventory, Treasury, SAP Quality Management, SAP Production Planning and SAP APO.
• Extensive experience in requirement gathering, gap analysis, designing functional &technical specifications, development, Unit/SIT/UAT testing, cut - over planning, deployment and post Go-live support.
• Working knowledge of Software Development Lifecycles (Waterfall and Agile)
• Capable of presenting design/solution options to Business teams, articulate functionality to users, able to clearly communicate with Finance users in Biz terms
• SAP Business Warehouse (SAP BW)
• Expert in designing BW data model that can handle large volumes of data (Dynamic Rolling year using SPO’s), implementing best practices to prevent unwanted growth of data in BW and optimizing BW models for HANA upgrades.
• Strong understanding of integration to BW and to downstream systems using open hub services.
• Design faster and efficient master data/transactional data extraction by leveraging ODP (operational data provisioning) form SAP ECC.
• Capable of BW performance tuning covering cube modeling, line item dimension usage, DB partitioning, Compression, logical partitioning, DB stats update, indexes, debug BEx query performance, identify performance bottle necks
• Working knowledge of handling BW refresh health checks part of BW system maintenance
• Hands on expertise to extract data from Non SAP systems using DB connect ODBC and data services.
• Experience in using New HANA specific modelling and data flow objects (Composite Provider, Advance Data Store Objects, Open ODS Views)
• Proficient in Object Oriented ABAP programming
• SAP HANA
• Working knowledge in native HANA development that includes creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SAP HANA Live (Analytics).
• Good understanding in using SAP HANA data migration tools such as SAP BODS (Business Objects Data Services), SLT and SDA (Smart Data Access) to extract structured/unstructured data from different source systems into HANA
• Expert in designing SAP HANA BW mixed modeling scenarios.
• Well versed with LSA++ architecture with SAP BW implementations on SAP HANA.
• SAP BPC
• Strong understanding of BPC standard model design including Dimension design, Script logic, BPF, Work status, Security, Report and Input schedules design
• Hands on expertise in troubleshooting BPC MDX errors, tracing EPM logs
• Deep understanding in resolving EPM login performance issues
• SAP BI
• Experience in designing reports using SAP BI 4.1 tools including Web intelligence, Analysis for OLAP

TECHNICAL SKILLS

• SAP BW Architecture
• Domain knowledge in SAP General Ledger, Finance Account Payables and Account Receivables, SAP Order Management, Shipping, Pricing, Purchasing, Inventory, Treasury, SAP Quality Management, SAP Production Planning and SAP APO.
• SAP ABAP programming
• HPQC - Test case creation and execution
• SAP HANA modeling
• SAP BPC NetWeaver

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW/BPC Architect / Consultant

Responsibilities:

• Understand the requirements in finance, Costs center accounting, internal orders /Treasury areas.
• Design BW models as per SAP proposed LSA architecture on non-HANA database.
• Establish “Near real time extraction model” for FI GL extractors to meet Financial close reporting needs.
• Design BW models that can handle large data sets approx. 90 million rows/year ex: FIGL line items
• Design a model that can support rolling year finance data by using SPO based partition using BADI.
• Configure extraction approach to fetch Non SAP data into SAP BW using DB connect.
• Design open hub destination to export BW data to external oracle systems using DB link.
• Design custom BW/ECC models for Treasury cash management, FAS115
• (Statement of Financial Accounting standards) reporting needs.
• Design an approach for BW data security that governs the enterprise data security for BO reporting.
• Analyze information designer tool (IDT) 4. 1 (multisource connectivity feature) capabilities on top of BW 7.4 and understand the advantages and the limitations of this approach.
• SAP BPC Performance Optimization and drill through interface design between BPC and BW
• Improve BPC EPM Login performance by working with SAP, tracing EPM logs, STAD and ST12 traces, enabling shared memory, configuring BPC parameters.
• Develop drill through reports on BEx query from BPC EPM add in for finance, cost accounting, treasury reports.

Confidential

SAP BW/HANA Lead

Responsibilities:

• Design BW-HANA mixed modeling scenarios that covers exchange of BW models in HANA and vice versa.
• Design complex script based calculation views using CE functions in HANA which sources data from SAP BW.
• Well versed with LSA++ architecture that helps in designing SAP BW on HANA
• Develop stored procedures in HANA that in turn be called in BW transformations. Thus, achieving performance gain during data loads in BW.
• Well versed with creating transient providers.
• Design HANA artifacts such as attribute view, analytic views.
• Identify data discrepancies and data quality issues, and work to ensure data consistency and

Confidential

SAP BW Lead consultant

Responsibilities:

• Work closely with Business Users, BI team, SAP Basis, SAP Security and Functional
• Teams to assess business requirements.
• Design, develop and implement enterprise-level Business Intelligence solutions to address ongoing business strategies
• Design and Develop SAP BW Reporting Solution for the following Order-to-Cash KPIs:
• Days Sales Outstanding
• Payment Pattern Analysis
• Collection Effectiveness Index
• Back order processing, Perfect order item and delivery Performance
• Global Spend analysis
• Enhance standard Purchasing data sources 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL and their corresponding Data Structures and Extractors to meet the requirements.
• Customize ‘Sales Overview - Deliveries’ Info cube to add Status Information, Loading and Transportation Information and modified the R/3 Extractors (2LIS 12 VCHDR and 2LIS 12 VCITM) to get the necessary information.
• Extend ‘Sales Overview - Sales Invoices’ Info cube to capture Document flow information such as Subsequent and Preceding Documents with their information.
• Modify 2LIS 13 VDITM Data Source to capture the above information and modified the extractor to get the information.
• Work with Solution Manager in maintaining and integrating BW/ECC Functional Specifications, Development Templates and Transports.

Confidential

Assistant manager- Lead SAP BW Consultant

Responsibilities:

• Gather requirements, reporting catalog, Gap Analysis, Data Modeling and development for G/L accounting, AP & AR.
• Implement BW profitability models (CO-PA) enabling senior management to analyze profitability at a strategic level while also allowing the financial, sales and marketing staff to analyze at an operational level to better manage the product, customer, and market portfolio to maximize profit margins.
• Involve in Transportation of BI Objects across the Landscape.
• Create Process Chains to run delta loads for FIGL/COPA to load Master and Transaction Data on Daily Basis.
• Involve in Coordinating and assisting in creation of user acceptance (UAT) test plans and execution.
• Responsible for application design, coding, system/unit test plans and execution including associated documentation.

Confidential

Senior SAP BW/BO consultant

Responsibilities:

• Implement and supported SAP BO Reporting on top of SAP BW, thus was successful in integrating SAP BI and BOBJ 3.1 at Confidential
• Involve in preparation of SAP BI-BO integration design document
• Design changes of chosen BEx Queries which will act as source for SAP BO front end
• Creation of OLAP universes based on BEx queries
• Creation of Web intelligence documents following the SAP suggested best practices
• Exporting of universe and WEBI docs on CMC
• Transporting of BO objects across the landscape
• Perform reconciliation of data between SAP BW and SAP BO(knowledge on enabling ODA trace)
• Long running BEx queries performance tuning by applying suitable performance tuning solutions both at report level and BI data modeling level.
• Enhance the loading performance by applying suitable techniques. (Ex: index handling during loading, Number range buffering, DSO settings, Parallel data load etc…)

Confidential

Senior SAP BW Consultant

Responsibilities:

• APO Forecast/Actual Reporting: Architected the design for extracting Forecasting Data from APO system. Developed the entire Data Modeling/Extraction process for reporting on Forecast Snapshot (Daily/Monthly).
• Requirements gathering for Purchasing & Inventory, Gap Analysis & Risk Assessment.
• Activate and load MM & Inventory information for Logistics KPI Analysis. Research and gap-fit Purchasing Business Content. Troubleshoot pre-go live break-fix issues and ABAP transformations in Purchasing & Inventory.
• Develop analysis authorizations for Purchasing and Inventory modules
• Activate BW Technical Content
• Upgrade BW 3.5 dataflow to BW 7 dataflow.

Confidential

SAP BW Consultant

Responsibilities:

• Handle various issues related to post LSA Architecture implementation
• Involved in BI upgrade from 3.X to 7.0
• Work on cases related to Post Upgrade activity from SAP 3.5 to BI7 .0
• Pre-Post Support pack implementation activities
• Work on LO Re-initialization on request basis
• Incidents related to daily data loading issues
• Provide technical assistance to the team with respect to the queries related to data loading
• Involve in BW Pre-Post up gradation activities from 3.x to SAP 2004s and also dealt with data load issues after up gradation.
• Handle Weekend activities like - Scheduling and rescheduling of process chains, filling of aggregates, compression of Info cubes