SUMMARY

• 13 years of IT industry experience as a Techno - functional Architect/Consultant in SAP BW/BI, BO, BODS, ABAP, HANA, S4 HANA(Embedded Analytics) PMP Certified, worked.
• 5 Full life cycle Implementations & 8 Production Support projects experiences in SAP
• Involved in ASAP implementation methodology (Initial Preparation, Blueprint, Realization, Final Preparation, Go Live)
• Very Good Business Domain Knowledge of Order to Cash OTC (O2C) (SD), Account to Reporting (A2R) (FI-CO), Procurement-to-Pay (P2P) (PP/MM), Logistics, QM, Forecast to Stock (F2S) (PP/MM/APO), IS - Oil & Gas, IS-Utility(IS-U/ISU), IS- Retail
• Exposure of diverse Industrial Sectors including Consumer Packaged Goods, Aviation, Manufacturing, Oil & Gas, Household, Healthcare Equipment manufacturing, Oil Film packaging.
• Effective team player/Team Lead/ Manager with good communication skills, strong positive attitude, excellent analytical skills, and capable of adapting to new technologies. Fluent with tools to document business requirements/processes MS Word, Excel, PowerPoint, Project and Visio
• SAP BW (Business Warehouse) (Version: 3.5/7.0/7.1/7.3/7.4 ): Data Extraction (ECC, APO, Flat file, CSV, Logical file) LO-Cockpit, Generic Extraction, Data Loading (Full /Delta/Init/Repair Full), Modeling, Business Content Installation, DS, DSO, Info cubes, Multi Provider, Routines (Start/Field/End/Expert) Update rule, Transfer rule, Performance optimization, SAP Authorizations, Open Hub Destination (OHD), Analysis process designer (APD), Multi cube, Infosource, BW star schema model, Master data model, Business Explorer Query, WAD, Process Chains (Creations / Scheduling/ Monitoring), Layered Scalable Architecture concepts (LSA++), BEx Broadcasting, Multi-Dimensional Star Schema, Extended Star Schema, Entity Relationship(ER). Knowledge in Hadoop, Qlikview, worked on tools HPQC ALM, Remedy, SM, Service Now, etc
• SAP ABAP: Fully conversant with all aspects of RICEF development including Reports, Interfaces, ALE/IDocs, LSMW, BAPI, BADI, User Exits, Custom Features, Smart forms. Object Oriented Programming, ABAP on HANA.
• SAP Business Objects (Version: 3.1/4.0/4.2), BODS on Hana Cloud Integration: Universe Designer, Web Intelligence, Crystal Report, IDT, UDT, Dashboard, CMC, Analysis Office, Analysis for OLAP, Lumira, Xcelsius, BODS - Workflow, Data stores, Data flows, repository, configurations etc.
• SAP HANA: Data Provisioning, SAP LT Replication Server (SLT), BODS, SDA (Smart Data Access), HANA modeling: Attribute View, Analytical View, Calculation views, SQL, Stored Procedures in HANA using SQL Script, SAP HANA Security: User Management, Roles, and Privileges, Dynamic Tiering, SDI/SDA Smart Data Integration & Smart Data Access, Performance Optimization, HANA XS, Transformations settings in SLT IUUC REPL CONTENT, SAP standard report /SDF/HANA BW SIZING to estimate required HANA database size, reporting based on HANA schemas and Views using SAP BO 4.0 tools like IDT, Crystal reports, Dashboards. Worked on multiple POCs & Presales activities for HANA, Lumira, Design studio. SAP ECC on HANA.
• BW On HANA: SAP BW specific modeling like using LSA++, Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning, ADSO(Advanced DSO), Open ODS views, hybrid scenarios - BW data models and HANA views as per the requirement, Manage, Architecture and knowledge of how BW on HANA works & insights into sizing, Knowledge on HANA Live, RDS.
• S4 HANA Embedded Analytics: Design & development of CDS view(Core Data Services), SQL, Annotation, Debug, Lifecycle management of objects, Fiori, Consuming CDS view in Fiori App, Design Studio, Lumira, Office of Analysis.

PROFESSIONAL EXPERIENCE

Confidential

SAP BW Architect

Responsibilities:

• Responsible for onsite team handling, client interaction, and onsite-off shore co-ordination activities, Responsible for requirement gathering, gap analysis, preparing functional & technical specification, development & delivery according to business requirement
• Designed & developed Sales traces, DDA, Gaine applications
• Designed & developed the end to flow for D.O for Vistex (It is a third party company) application
• Data source enhancement for HR data-source for HCM system. Production support 24X7.
• Responsible for end to end project management.

Confidential

SAP BW HANA Architect

Responsibilities:

• Responsible for onsite team handling, client interaction, and onsite-off shore co-ordination activities, Responsible for requirement gathering, gap analysis, preparing functional & technical specification, development & delivery according to business requirement
• Designed & developed the GOLD application, Rubber Manufacturer association of Americas(RMA) & Rubber Manufacturer association of Canada (RAC) applications, Distributor & Dealer bonus application.
• Worked extensively in SD, Order to Cash OTC (O2C), Lead to order, MM, PP, logistics area SAP ECC as the backend source system. Great Domain/Business knowledge in these areas.
• Designed & developed Attribute/Analytic/Calculation view & developed the reports on top of these HANA view
• Implemented SAP BW on HANA specific modeling using LSA++ architecture, Composite Providers, exposing BW objects in HANA Views, Operational Data Provisioning(ODP), ADSO, developed hybrid scenarios - BW data models and HANA views, Used SQL script for writing Stored procedure.
• Designed & Developed Universe on BW & HANA, developed many reports in WEBI
• Developed stories & dashboard in SAP Lumira & SAP design studio.
• Responsible for end to end project management.

Confidential

SAP BI BO BODS ABAP HANA Architect

Responsibilities:

• Responsible for onsite team handling, client interaction as a manager, and onsite-off shore co-ordination activities, Responsible for requirement gathering, gap analysis, preparing functional & technical specification according to business requirement
• Designed & Developed the dataflow for: Sourcing dashboard (PO data: ECC>BW>Informatica>Tableau), IDOC report for SSS reconciliation dashboard (using Open Hub Destination OHD), CWD AR feed data to Tableau dashboard, Performance tuning in existing transformation using OOO ABAP programming, Worked in Order to Cash OTC (O2C), Lead to order, SD, MM, PP & Logistics Modules extensively, SAP ECC as the backend source system, IS- Oil & Gas, BW Utilization Dashboard in Xcelsius 2008, Handling SAP BO as an Administrator.
• Migrated the BAAN data to SAP BW as a part of data migration .Designed & Developed Data store connection in BODS for BAAN as source and BW as target, Data Services Data source in BW based upon Data Services Logical system, Imported the BW Data source in Target Data Store of BODS, Imported tables from BAAN to Source Data Store, Data store connection between BODS and BW data source, Project, Job, Workflow and Dataflow to move data from BAAN tables to BW, Validated dataflow and executing job to perform data transfer from source to target.
• Pricing Dashboards which gives the Summary and Detailed level of information on Quotations, Sales Orders, Billing and Gross Margin, Management & End user can visualize the data on single dashboard screen and then they can drill down to the granular level as needed.
• Architecture/Solutions for current requirements, ensuring scope for future Business needs, Plan and execute various developments required. Worked extensively on Project Execution Plan, Cut-Over Plan, Migration Plan, Integration Plan, Transport Governance, Go-Live Plan, Hyper care Plan, Support Plan. Worked closely with Business Users/End Users for SIT, UAT, Test Script/Regression Testing, Defect Management/Closure and Support Documentation. Leverage the maximum of existing BI Landscape of Oil & Gas with minimum changes/development required. Developed custom extractor & custom program in SAP ECC using ABAP to meet the complex requirement.

Confidential

SAP BW BO BODS ABAP HANA TEAM LEAD/Consultant

Responsibilities:

• During AMS support was Responsible for onsite team handling, client interaction and onsite-off shore co-ordination activities. Worked on LO Cockpit, FI Data source, Custom data sources, User Exit, and BADI Enhancements. Developed Many BW objects, BEx reports, Universes, WEBI reports, worked on Incidents & Enhancements.
• Worked on Walmart/ Sam’s Club Split Pallets project, Pulled the data for POS (Point of Sales) from NON SAP system into BW using the SAP Data services(BODS), Assist in maintaining compliance with all audit and SOX initiatives; user security requests to the application.
• Customer extractor development using ABAP, SAP ECC as the backend source system, Great Business & Domain knowledge in SD, MM, FICO, PP, Logistics, Order to Cash OTC (O2C), Lead to order .
• Used Run time analysis, SQL Trace, Code inspector, SAP ABAP Test Cockpit for ECC system
• Production support 24/7, Process Chains monitoring, Fixing of failure loads, Daily report preparation

Confidential

SAP BI Architect

Responsibilities:

• Involved in BW AMS support activities during BW on HANA migration, Created BEx and BOBJ queries to meet ad-hoc requirements, Involved in Data purging activities to prepared BW system for HANA Database migration purpose, Purged Info Cube, PSA, DSO tables as per SAP recommended notes (SAP Notes 1150724, 706478, 1095924)
• Deleted unused and error log data using standard reports like RSPC INSTANCE CLEANUP, RSPC LOG DELET, RSSM ERRORLOG CLEANUP, RSAR PSA PARTITON CHECK, SAP PSA PARTNO CORRECT, RSAR PSA CLEANUP DEFINITION
• Ensured BW system database size as per HANA database sizing, Used archiving and selective deletion process for historical data, Run the SAP standard report /SDF/HANA BW SIZING to estimate required HANA database size, Involved POSDM data mart change log and aggregate tables cleaning activities. Standard info cube into In-Memory info cube Tcode RSMIGRHANADB and program RSDRI CONVERT CUBE TO IN-MEMORY.
• Post migration involved in BOBJ reports development, Creation of new SAP BO reports based SAP BI Data Warehousing Work Bench data targets Including Info Cubes and Multi Providers, Created OLAP and OLTP connections. Worked in Data Foundation Layer and Business Layers in IDT, Used BICS connection to Connect to SAP BI system, Creation of new SAP BO user ids to end users in SAP BO Administration

Confidential

SAP BI Architect

Responsibilities:

• As a part of this implementation, Prepared (BRD) Business Requirement Dossier ( Confidential, FO, BO), ARD (Application Design Document), Designed & Developed data flow document, data access document (Business Explorer Query, workbooks), SAPA (Data Extraction logic, customer exit logic, DB view details), Developed all these BW objects, was responsible for all deliveries within scheduled time line and budget.

Confidential

SAP BW Project Lead/Tech Lead

Responsibilities:

• APO DP Item Level Forecasting Project: Designed and Developed the data flow for BW to load the data to APO system from R/3 and BW & Created the required objects for new data flows (Data Source, Transformation, DTP, DSO, Cubes, MP). Wrote complex ABAP Code in Start/End/ Expert routine for customized requirements in APO system.
• BW Upgrade to SAP Net Weaver 7.3 Project: Handled respective Pre-upgrade/ Post Upgrade activities at R/3 & BW side (i.e. clearing of extraction queues, delta queue, put the running v3 jobs on HOLD, PC unscheduled, Report Testing, BW functionality, DELTA functionality checking), raised OSS note.
• Housekeeping BW Reports Project: Implemented the Strategy for Naming Convention Standard For BW queries (Had 1300+ BEx query, 1600+ workbooks live in Production that time) Implemented Change management & did clean up activity.
• SAP Manufacturing Project: Identified & Installed BI contents for SAP Manufacturing & also created customized BW objects to meet Client Requirements.
• Forex - COPA Doc Currency Project: Under this Document Currency record (Curtype-00) has been replicated into BW through stat-routine as per business requirement & modified all respective reports.
• Warranty Notification-COPA integration: Under this development Notification no & Warranty Code has been integrated to COPA document through creating a new data flow in BW.

Confidential

SAP BW BO Consultant

Responsibilities:

• SC Johnson is manufacturer of many famous products.
• It was a production support project.
• As a part of support worked on LO Cockpit & standard data source enhancements, Developed generic data source, Developed new BW objects & Universes, Developed many end to end WEBI reports.