SUMMARY

• Have 11 + years of experience in SAP BW/BI, SAP HANA along with SAP BO ABAP/4 programming and BW On HANA, as a technical architecture & team lead
• Worked with the global clients such as Confidential, Confidential Group, Confidential Energy Management, Confidential, P&G Procter Gamble, Confidential, and Confidential - complete implementation of SAP BW on HANA, HANA development, Go-Live support
• Responsible for the SAP BW/BI, SAP BW IP, SAP BO and SAP HANA projectdevelopment lifecycle from project preparation, BBP(Business Blue Print), realization, final preparation, requirements gathering, functional technical design documents, development, unit testing, Integration testing, Use Acceptance Testing, Go-live and post Go-live support
• Experience with Confidential, Procter & Gamble, Confidential, and Confidential, Confidential Energy Management - Solutions driven professional with extensive experience in design, deployment of large BI (SAP BW on HANA, Native HANA, HANA Live and Business Objects systems that play a key role in strategic and operational decision
• Key player in the project related to SAP HANA, SAP BW on HANA, ETL, EDW and R&A (BEX, SAP BO 4.0, IDT) across functional tracks like SD, CRM, MM, PP, SCM demand planning, Generic extraction, HCM,HR, FI-AP(Accounts Payable) FI-AR(Accounts Receivables), FI-GL, Warranty & SD Unit Cost, Manufacturing Productivity, Inflation, Spend Analytics, Inventory 2.0. Plant Maintenance
• Developed complex BO Universes, WEBI Reports, Xcelsius / Dashboards, Crystal Reports, Lumira visualizations Worked with SAP WEBI reports source as a BEX Query, WEBI reports were scheduled on weekly basis, the output was sent in excel format to customer mail box directly
• Experience with Perkin Elmer and Confidential - SAP BW production support and maintenance
• Experience inSAP HANAdata provisioning using SAP LT replication server (SLT) and data service
• Design & creation of HANA attributes views, analytic views, calculation views, analytics privileges, attribute mapping, and calculated attributes, calculated measure, restricted measure, currency as unit of measure
• Defined solution roadmap for HANA, BW & BOBJ application integration into Grainger’s landscape
• Managed key HANA, BW & Business Objects initiatives with an oversight responsibility to deliver projects on time
• Expertise in creating, organizing, publishing and scheduling reports using CMC
• Experience in test designing, test planning, writing test cases and executing test cases and coordinating defect resolution using HP-QC tool

TECHNICAL SKILLS

BW Data warehouse/ Module: SAP BW 7.4, 7.3, 7.0, BW 3.5, SAP HANA, SAP BO 4.0, Lumira, IBM Data Stage, SCM, HCM, FSCM, SAP Payroll, AFS, CRM, HR, FI-CO, FI AP FI-GL, FI-AR, APO, APD’s, PL/SQL, Micro Strategy, Warranty SD, BP Forecast, Manufacturing Productivity, Unit Cost, SAP BEX, Sales Planning, Demand Planning and Demand planning accuracy

ERP/Tools: SAP ECC 6.0, R/3 4.6 & HPQC, AMEX, REMIDY, SAP IP Vistex

Operating System: MS-DOS, Windows 98/2000/XP, UNIX

SAP HANA: SAP HANA Studio, SAP HANA Information Composer, SLT, SAP Data Services, Direct Extractor Connection, Flat file Uploaded

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/HANA Consultant & Team Lead

Environment: SAP HANA studio, SAP HANA, SAP BW on HANA, SLT, BPC On HANA, HANA Database, HANA Information views ECC, CRM, SAP BW 7.4, APDs, Open hub tables, BO IDT, Flat Files, ABAP/4, PL/SQL & SAP BEX, Business Objects front-end

Responsibilities:

• Involved in full cycle of implementation of SAP BW on HANA, SAP HANA on BO,, SAP BW IP which includes Analysis, rrequirements gathering, development, testing, reporting, Go-live and Post Go-live support
• Strong SQL, Column engine (CE) and HANA Procedural Language developer
• SAP HANA Troubleshooting and Performance Analysis
• Lead the interaction between Infrastructure and BI development teams
• Define and maintain design guidelines related to HANA and BI systems
• Optimize data integration within and across HANA, BI and source systems, Coordinate across development to define, plan and support implementation of releases
• Extensively worked Advanced SQL, Advanced Hana Procedure, Performance Tuning Advanced Data Modeling, SQL Script, SAP HANA XS Application
• Extensively worked on SAP HANA Modeling - attribute views, analytic views, calculation views, analytical Privileges, Column store views and performed SQL, Creating Function using PL/SQL the Function Editor coding to push data into data base intensively
• Involved data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT)
• Involved in SAP HANA Security including User Management, Roles, and Privilege
• Well verse with SAP HANA Administration, Performance Optimization, Modeling using
• Involved in preparation of weekly status reports and documentation
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting
• Broadcast data via SAP BW Open Hub APD Destinations like Data Warehouse, MDG, CRM, SD IP: Vistex Sales teams
• Expertise in BW on HANA, LSA++ Architecture
• Report development on SAP BO 4.0 WBBI & IDT tools, Sales Planning, Inventory reports by the agreed improvements
• ABAP for SAP BW, Expert, End, Start, Field Routines, FM for Extractor Enhancement. Development of Reports using SAP Business Objects Web Intelligence, Support the bid team in creating proposals, scoping and resource planning
• Experience in designing and developing the Universe & IDT and updating the existing Universes to CMC, Scheduling the processes and administering the BO activities. Scheduled the reports in info view
• Develop SAP BW On HANA Advanced DSOs (ADSO), Open ODS Views from COPA, Composite Providers, Open Hub Destinations, Enhancement of Standard Extractors in SAP CRM and SAP SD, SPA Event Management
• Work in Transnational teams from different regions, Co-ordinate with the Customer’s Partners, Customer Business and IT Teams and the SAP Offshore Delivery Team
• Develop Custom Reports in BEx Query Designer and SAP Business Objects’ Web Intelligence
• Process Chains and Data loads
• Extensive experience in Unit, Functional, Integration, Regression, User Acceptance and System Level Load

Confidential - Pleasanton - CA

SAP BW/HANA Technical lead

Environment: SAP BW7.4, APDs, SAP BEX, HANA studio 1.0.1, IDT, SCM, Flat Files, ABAP/4, PL/SQL, MicroStrategy & Business Objects front-end

Responsibilities:

• Involved in full cycle of implementation of SAP BW on HANA, SAP HANA on BO which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support
• Translate the Business KPIs into HANA & Define the Reporting Layouts Using SAP BO WEBI reports
• Experience with HANA Live and Virtual Data Mart (VDM). Building custom applications using VDMs
• Involved in creating custom schema, non-ECC tables and SQL queries in SAP HANA
• Involved in Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT, BODS and DXC, HANA security including User Management, Roles and Analytic Privileges
• Experienced with different Relational databases like Teradata Hadoop with HANA, Oracle and SQL Server, Created HANA optimized data providers Info cubes and DSO created in SAP BW
• Enhance DPA reports by the agreed improvements
• Create the Business Blue-Print document
• Helping to the R&A team in critical issues in BEX reporting
• Installed relevant SAP business content objects, BEX report and Involved in transporting the objects through the landscape
• Key player in the project related to SAP (ETL, EDW, BEX, BO) across functional tracks like Demand planning, Sales Planning Sales Forecasting Reports, SD, Inventory Reports, Invoice Detail Report, Manufacturing Productivity Reports
• Analysis, design and implementation of reports SAP (BEX, BO) for the deployment of strategies in the Business Analysis
• Involved in the prepared Technical Specifications (EDW,BEX, BO) according to the collective inputs obtained from functional team
• Worked with SAP SAP Webi Reports source as a Bex Query, Webi Reports were scheduled on weekly basis, the output was sent in excel format to customer mail box directly
• Involved in SAP HANA Data Modelling using Attribute Views, Analytic Views and Calculation Views & SAP HANA Data Provisioning using SAP LT Replication Server (SLT)
• Involved in preparation of functional & Technical design documents
• Validation of Data in the SAP BO WEBI Reports vs ECC vs HANA Views
• Creation of HANA Attributes views, Analytic views, Calculation views, Attribute Mapping, Hierarchies, Package, Constant columns, Analytics Privileges, Calculated Attributes, Using Currency as Unit of Measure
• Involved in HANA objects moving Development System To Quality System To production System Using Delivery Units Export/Import of Models Activating Impacted Objects, Validating Information Models
• Created generic extractors from SCM and ECC sale system
• Used HANA studio to create different kind of views Analytical, attribute and calculation views
• Created HANA optimized data providers Info cubes and DSO created in SAP BW
• Create the Business Blue-Print document

Confidential - Plainville, CT

SAP BW Technical lead

Environment: SAP BW 7.0, CRM, SD,FI-AP(Accounts Payable) FI-AR(Accounts Receivables), SAP CRM Web UI.ABAP/4

Responsibilities:

• Major Responsibilities include BW Data loading Monitoring /Issue resolution.
• Handling any new CR’s & Attending client meetings and taking care of these requirements fixing issues for Complaints, Return process and status management.
• Involved SAP CRM,SD,AP,AR with BW Roll Out &Go-Live support activates (Global Orders, Global revenue, Global Cost, Open Service order)
• Involved with BI data load scheduling by using process chains, monitoring and troubleshooting data extraction/load problems.
• Handling the Business critical tickets using remedy tool
• Reconciliation of data with interfaces, BWA Indices, Secondary Indices, Rollup and Compression PSA deletion and maintaining aggregates as a part of performance tuning
• Month end and Year End activities.

Confidential - Cincinnati, OH

SAP BW/BO HANA Technical lead

Environment: BI 7.0 to BI 7.3 on HANA, SAP BO Web Intelligence 4.1,Informtion Design tool 4.1,, ABAP/4,Auto Sys

Responsibilities:

• Involved in full cycle of migrating SAP BW, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support
• Upgrade from BI 7.0 to BI 7.3 and also Service pack upgrade SP9 through design, testing, UAT (User Acceptance Test), defect monitoring and resolution and release management as well as post go-live support
• Experienced in requirement gathering, developing functional and technical specifications
• Experience in creating Ado reports using Business Objects Web Intelligence tools
• Key player in the project with ADM &EDW layer DSOS, Info cubes, Multi Providers, PSA, Process chains, InfoSec queries, batch scheduling, and analysis processes according to the Requirement request
• Design & Creation of HANA Attributes views, Analytic views, Calculation views, Hierarchies. Analytics Privileges. Attribute Mapping, Calculated Attributes. Currency as Unit of Measure, Comparing Object Versions, Export/Import of Models
• Created new and modified existing reports for EMEA, NA & ASIA region to fulfill the business Need
• Involved with BI data load scheduling by using process chains, monitoring and troubleshooting data extraction/load problems
• Captured various transport requests and transported the same to acceptance and quality systems for EMEA, NA & AISA
• Transporting objects from BW system to BW HANA system and then across to HANA Land scape, Carried out the house-keeping before moving the BW to BW on HANA
• Modifying the process chains according to HANA system and automating them via Auto Sys
• Carried out the house-keeping before moving the BW to BW on HANA
• Migrated the BW Info Cubes and DSOs to HANA optimized
• Report development on modules like FICO, spend analytics,
• Created many complex and customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization

Confidential - Shelton, CT

SAP BI Lead Consultant

Environment: SAP BW, BEX, ABAP/4, Flat Files, Oracle

Responsibilities:

• Created many complex and customized reports for specific business requirements and also involved in new features of SAP BI security like Analysis authorization
• Maintained Process Chains to automate and schedule the data loads
• Major Responsibilities include Data loading Monitoring /Issue resolution
• Key player in the project related to SAP (ETL, EDW, and BEX) across functional tracks SD, FI, CRM, and FI-GL
• Involved SAP CRM BW Production support with BW Go-Live support activates (Global Orders, Global revenue, Global Cost, Open Service order)
• Reconciliation of data with interfaces., Analysis of Dockets and Solving
• Month end and Year End activities, Compression, PSA deletion and maintaining aggregates as a part of performance tuning, Maintained Process Chains to automate and schedule the data loads
• Attending client meetings and taking care of these requirements
• Handling any new CR’s

Confidential

SAP BW/BO R&A Lead Consultant

Environment: SAP ERP 6.0, BI/BW, Business Objects 3.x, Data stage, HPQC, REMEDY, Flat Files

Responsibilities:

• Creation of Process Chains & scheduling as per dependency & maintaining alert configuration
• Key player in the project related to SAP (ETL, EDW, BEX, BO) across functional tracks like Accounts Payable, Accounts Receivables, Unit Cost, Manufacturing Productivity, Inflation, Spend Analytics, Inventory, Customer Profitability and Customer Sales, Cost Center Accounts
• Analysis, design and implementation of reports SAP (BEX, BO) for the deployment of strategies in the Business Analysis
• Key player in the project related to SAP (ETL, EDW, and BEX) across functional tracks SD, FI, CRM, and FI-GL, Various Data Extraction, loading Monitoring processes (Standard, Generic) using LO, SD Billing, Purchasing, Shipping, FI-AP, FI-AR, Inventory
• Helping to the R&A team in critical issues in BEX reporting
• Worked with SAP BO Webi Reports source as a Bex Query, SAP BO Webi Reports were scheduled on weekly basis, the output was sent in excel format to customer mail box directly
• Created new web intelligence reports using universe and Bex Query as source
• Played a key role in the discussion with business analysts and end-users regarding data modeling, Business Content, granularity, Reporting Analysis and performance tuning
• Responsible for the SAP BW/BI, SAP BO Project development lifecycle from Project preparation, BBP(Business Blue Print), Realization, Final Preparation, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support, Functional technical design documents through unit testing &integration testing
• Supporting the Regions includes north America, Europe(Mosaic), Asia Pacific and Latin America
• Carrying the necessary configuration changes as per the business requirement
• Handling the Business critical tickets with in the SLA
• Respond to cases within the time specified in the SLA
• End user Assistance and support on general issues
• Monitoring daily data loads, resolving data loading issues, report issues raised by the client,
• Help Desk Issues management (Tracking & Monitoring tickets on a daily basis and resolving the issues )
• Participation in regular Weekly team review meetings

Confidential

Senior Associate Consultant SAP NTW (Developer)

Environment: SAP ERP 6.0 SAP BI, ABAP/4

Responsibilities:

• Worked extensively on Data warehouse workbench (RSA1). Designed and developed Info Objects, Info Cubes, DSOs, Info sets and Multi providers
• We developed flexible business User interfaces for calling BAPI’s from SAP ABAP HR Module Payroll Data.
• Designed Standard Data sources from R/3 and flat file, Created Transformations and assigned Rule groups.
• Worked on different types of Data Store Objects (DSO) like: Standard DSO, Write optimized DSO & Direct update DSO
• Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Created Process Chains to automate the process of loading data into Data Targets
• Involved in Transporting the BW objects from development server to Quality server
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains. Extensively worked with all types of tickets raised by end-users.