PROFESSIONAL SUMMARY

• Over 9 years of experience as a SAP BI/BOBJ techno-functional consultant with 5 complete life cycle implementations involving data modeling, data extractions, report development including 1 complete life cycle implementation of SAP BI on HANA database.
• Support the BW and BO Environments.
• Make Enhancements, test and work with End Users.
• Monitored with Basis Team to create connectivity to HANA.
• Trigger-Based Data Replication used with SAP Landscape Transformation LT Replication Server
• Extraction-Transformation-Load ETL based Data Replication used with SAP Business Objects Data Services to specify and load the relevant business data in defined periods of time from an ERP system into the SAP HANA database.
• Extracted Metadata from the source system into the Target SAP HANA system.
• Configured on the HANA Studio the import server to pull data into HANA from SAP Business suite
• Leader providing recommendations to client's Basis, DB and UNIX team.
• Additional requests like Support packs, system refreshes that needed estimation and prior approvals.
• Monitor Database and file system free space to avoid issues
• Worked extensively with SAP standard table - RSMSSPARTMON on the number of partitions happened at the database level.
• Checking the database backup logs and resolve failures
• Analyzing SAP, DB and OS logs for technical issues
• Monitoring SAP processes to avoid system operations issues
• Monitoring standard SAP housekeeping jobs ST01/SU03/SM51 likewise
• Monitoring SAP system performance
• Monitoring Memory and CPU consumption
• PSA Cleanup - RSAR PSA CLEANUP DIRECTORY in check/repair mode
• Monitoring lock entries and updates terminated
• Checking Database Statics DB02
• Short Dump analysis ST22
• Analyze Early Watch reports and provide recommendations
• Other routine Basis monitoring and troubleshooting tasks
• Checking Database Statics, Short Dump analysis, analyzing Early Watch reports and provide recommendations, Other routine Basis monitoring and troubleshooting tasks
• Extensive SAP experience with FI/CO FI AP, FI AR , SD and MM Modules.
• Experience in SAP BW3.5, BI 7.0/7.1/7.3/7.4 ECC 6.0, BW-IP, Upgrade from 3.5 to BI 7.3/7.4.
• ABAP Programming on BI Routines and CMOD,BADI
• Expertise in BW Components like Info Objects, Info Sources, Update rules, Transfer rules, Info Cubes, ODS, PSA, Info Spokes and Info Packages, Queries, Calculated key figures, restricted key figures, variables etc.
• Worked extensively on CO-PA, FI, LO Cockpit and Generic data Extractions.
• Expertise in designing SAP BW interface requirements with both R/3 source systems as well as Non R/3 source systems in modeling of Info Cubes, Info sources.
• Worked extensively on performance tuning, BW Statistics, Indexes, Data Marts, process chains, Error handling in subsequent processing, Business content installation, data cleansing in PSA.
• Experience with Business Objects Enterprise / SAP Business Intelligence Analytics Platform 4.0.
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Knowledge of business intelligence best practice processes, tools, standards and practices.
• Worked on reports using BEx Query Designer, BEx Analyzer and Web Application Designer.
• Created and enhanced Data Sources using database views, Info Sets, and function modules. Hands on ABAP coding on extractions.
• Experienced in ABAP programming techniques including Reporting, Dialog Programming, ALE, SAP Script and user exits.
• Excellent technical, business, communication and time management skills.
• Efficient and adept working in cross cultural and cross functional organizations due to exposure in both Europe and USA markets.

WORK EXPERIENCE

Confidential

SAP BI-BOBJ-HANA Lead

Responsibilities:

• Support the BW and BOBJ Environments. Make Enhancements, test and work with End Users.
• Leader providing recommendations to client's Basis, DB and UNIX team.
• Additional requests like Support packs, system refreshes that needed estimation and prior approvals.
• Monitor Database and file system free space to avoid issues
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Worked extensively with SAP standard table - RSMSSPARTMON on the number of partitions happened at the database level.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Checking the database backup logs and resolve failures
• Experience with Business Intelligence/ Datawarehouse data store design Datawarehouse - Datamart / Operational Data Store environment.
• Analyzing SAP, DB and OS logs for technical issues
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Monitoring SAP processes to avoid system operations issues
• Monitoring standard SAP housekeeping jobs ST01/SU03/SM51 likewise
• Monitoring SAP system performance
• Monitoring Memory and CPU consumption
• PSA Cleanup - RSAR PSA CLEANUP DIRECTORY in check/repair mode
• Monitoring lock entries and updates terminated
• Experience in the design and implementation with SAP Business Objects BI Product Suite Web Intelligence, Explorer, Xcelsius, Visual Intelligence and Mobile BI .
• Checking Database Statics DB02
• Short Dump analysis ST22
• Analyze Early Watch reports and provide recommendations
• Other routine Basis monitoring and troubleshooting tasks
• Experience in Universe Design using Universe Designer / Universe Design Tool.
• Experience with Business Objects Enterprise / SAP Business Intelligence Analytics Platform 4.0.
• Experience building from the ground up an enterprise self-service business intelligence environment.
• Experience with SAP Business Objects BI Suite Tools Web Intelligence , Xcelsius, Explorer, Lumira
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Knowledge of business intelligence best practice processes, tools, standards and practices.
• SAP BI 7.X Migration to HANA, BW Production Environment General System Health Checks, Monitoring, HANA Configuration with BO 4.X

Confidential

SAP BW-BI-BOBJ/ HANA Consultant

Responsibilities:

• Data Modeling: Info Cube design, Info Source, Info Object maintenance, ODS object, Multi Provider, Update rules, Transfer rules, Info Packages, Info Package Groups Key figure and characteristics BADI - Restricted and Calculated Key figures,CMOD, Virtual key figures.
• Extraction: LIS, LO master data and transaction data Full/Delta , Flat file master and transactional data, generic extraction, enhancements and strong exposure to CO-PA Extraction.
• Reporting: Business Explorer Analyzer Variables Calculated key figures, Formulas, Free characteristics, Filters, Exceptions, Conditions.
• Worked on SD, MM, Sales Overview And GAP Analysis Stock Overview and In FI Asset Payable And Receivable Cubes OFIAR C03 And OFIAR C02 ,0FIAR C01 and worked ON Queries i.e. Overdue Analysis And Payment History, Day sales outstanding And Account payable
• Worked on Information broadcasting and VBA MACRO EXCEL. Sound knowledge in Visual composer. Published the Reports on the Enterprise Portal Dashboard
• Used RRI TO jump into another query to get detailed data
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Good knowledge on transportation and authorization.
• Performance Tuning: Rollup, Collapse, Aggregates, Reconstruction, and Partitioning of Info Cubes, Indexes.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Experience in the design and implementation with SAP Business Objects BI Product Suite Web Intelligence, Explorer, Xcelsius, Visual Intelligence and Mobile BI .
• Created IDT Information Design Tool connection to build WEBI reports on top of BEX Queries through BICS
• Worked with BPC team to load General Ledger Actual Data from BW Info cube ZNGL O10 to BPC system, manipulate and store into Cons cube /CPMB/ZGIIKTC
• Involved in BW-BPC integration for Project system Data loads
• Built complex WEBI reports by combining 3 OLAP universes using Merged Dimension
• Prepared User manual/authorization roles and also trained business users about WEBI functionalities.
• Exclusively worked on WEBI by using variable calculations, merged dimension, sections, Input Controls, Rankings, Query filters as well as Table filter functionalities.
• Built Cross Table, Column and Stacked Charts according to functional requirement provided by business users.
• Created report filters in the UDT Universe Design Tool to improve WEBI report performance.
• Experience building from the ground up an enterprise self-service business intelligence environment.
• Experience with SAP Business Objects BI Suite Tools Web Intelligence , Xcelsius, Explorer, Lumira
• Experience in Universe Design using Universe Designer / Universe Design Tool.
• Worked on Performance tuning of WEBI and BEX reports by using Query Stripping, BI Indexes, BI statistics, Aggregates, Partitioning of Info cube and also OLAP based Cache.
• Extensively worked on the expert routine to load data from Inventory cube for Store Obsolescence report.
• Worked extensively on PM, MM and SD modules.
• Activated and enhanced standard PM Data Sources and also Data Modeling in BW system.
• Experience with Business Objects Enterprise / SAP Business Intelligence Analytics Platform 4.0.
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Knowledge of business intelligence best practice processes, tools, standards and practices.
• Worked on Material Classification Data source configuration and connected as the attributes of material Info object.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Extensively worked on SAP BW functionality like LO Extraction, update routines as well as developed custom BW cubes and queries for specific user requirements that could not be met by using Standard Business Content.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying extended Star Schema modeling principles in Data Design, used expert knowledge of data warehousing concepts, Info Cube data design and reporting
• Designed Sales MultiCubeover the Sales order, Delivery and Billing cubes to provide visibility of data across the sales cycle in the same query
• Activated Standard Business Content and loaded large volumes of production data into Info Cubes pertaining to SD MM.
• Configured and activated SAP BW Adapter in CRM to extract CRM related objects into BW.
• Extended Activity Data Source 0CRM SALES ACT 1 in CRM to add custom fields like owner Id and buyer contact fields
• Created custom Master Data Sources using tables, views, domains, ABAP query and set up Delta for custom fields.
• Experience building from the ground up an enterprise self-service business intelligence environment.
• Experience with SAP Business Objects BI Suite Tools Web Intelligence , Xcelsius, Explorer, Lumira
• Extensively worked on reporting using BEx Analyzer, created calculated and restricted key figures, variables, exceptions, conditions, jump queries and Excel properties to meet client requirements.
• Implemented BW Web reporting and well versed with Web Publisher Wizard to publish views on the web.
• Developed Documentation on Business Explorer and Reporting for the End User.
• Involved in translating business process into business and technical requirements.
• Created Generic extractors/Cubes/ODS/objects in BI.
• Involved in creating Data Sources, Info sources, and Transformation.
• Extensively worked on extracting the data from SAP R/3 and Flat Files to SAP BI.
• Extracted data from different modules in SAP R/3 like FI/CO, CO-PA and SD.
• Involved in activating various Business Content objects for extracting Master Data and Transactional Data from SAP R/3 into SAP BI.
• Extensive work done on Process Chains as well as performance enhancing Aggregate tables and system settings and parameters to speed up loading as well as reading of data.
• Enhanced existing master data and transactional data extractors.
• Worked extensively with loading Transactional data.
• Created Multi providers by defining to utilize the existing data of the Basic Cubes and enhance reporting flexibilities.
• Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Experience with Business Intelligence/ Datawarehouse data store design Datawarehouse - Datamart / Operational Data Store environment.
• The client had Data Services jobs running on MySQL Server and worked on upgrade to HANA Database for performance tuning worked extensively in the Data Services Upgrade.
• Business objects Data services is ETL tool which was used to extract data from source ECC and then load into HANA.
• Monitored with Basis Team to create connectivity to HANA.
• Trigger-Based Data Replication used with SAP Landscape Transformation LT Replication Server
• Extraction-Transformation-Load ETL Based Data Replication used with SAP Business Objects Data Services to specify and load the relevant business data in defined periods of time from an ERP system into the SAP HANA database
• Extracted Metadata from the source system into the Target SAP HANA system.
• Configured on the HANA Studio the import server to pull data into HANA from SAP Business suite.

Confidential

SAP BI BOBJ Consultant

Responsibilities:

The system was based on SAP BW 3.5 version with FI, PP, HR and MM modules and focus mostly on FI. Every month there was a critical period for the first 10 days where PCA and CCA jobs were of great importance and should be completed on time before the start of business hours otherwise reports showed incorrect values.

Day-to-day Activities included Job monitoring and rectification and Rectification of Reports

Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.

Experience with Business Objects Enterprise / SAP Business Intelligence Analytics Platform 4.0.

Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.

Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.

Experience building from the ground up an enterprise self-service business intelligence environment.

Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.

Experience with SAP Business Objects BI Suite Tools Web Intelligence , Xcelsius, Explorer, Lumira

Experience in Universe Design using Universe Designer / Universe Design Tool.

Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.

Knowledge of business intelligence best practice processes, tools, standards and practices.

Experience with Business Intelligence/ Datawarehouse data store design Datawarehouse - Datamart / Operational Data Store environment.

Common Issues faced were Failure of Jobs process chains and incorrect report values.

Experience in the design and implementation with SAP Business Objects BI Product Suite Web Intelligence, Explorer, Xcelsius, Visual Intelligence and Mobile BI .

Confidential

SAP BI BOBJ Consultant

Responsibilities:

• Responsibility pertained to implementation of the Business Units of Phase 2 and Phase 3 of the Client. My responsibility included monitoring the various test data loads from Data Services Side to BW.
• Spend Analysis based job profile included
• Preparation of Reconciliation Documents w.r.t R/3 and BI Data.
• Scheduling of Process Chains on every 5th and 15th working day of the month.
• Optimizing the Load and Recon Process improve load and recon process until next load. Reducing time in the process.
• Added Sales force Info Object and also coded in the end routine for the NGPS Monthly Open Hubs.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Changed DTP selections for NGPS monthly Open Hubs which are related Brand-Territory- Category level.
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Validated Open Hubs by matching Product Total Prescriptions with initial staging DSO values.
• Created a copy of transports to move BEx Queries from Production environment to development.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Created test cases and scenarios to do validation in Development and Quality Environment.
• Experience with Business Objects Enterprise / SAP Business Intelligence Analytics Platform 4.0.
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Knowledge of business intelligence best practice processes, tools, standards and practices.
• Worked on formula variable to populate namenda baseline end date as a key figure in the BEx report using customer exit.
• Experience in the design and implementation with SAP Business Objects BI Product Suite Web Intelligence, Explorer, Xcelsius, Visual Intelligence and Mobile BI .
• Built BEx queries using restricted key figures and new formulas to validate FPC sales force reports based on Business Transaction ID.
• Built and maintained OLAP universes with custom filters and prompts to meet the ad-hoc and canned reporting requirements in Business Objects.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Experience in Universe Design using Universe Designer / Universe Design Tool.
• Experience with Business Intelligence/ Datawarehouse data store design Datawarehouse - Datamart / Operational Data Store environment.
• Utilized LCM Life Cycle Management tool for promoting/migrating WEBI reports and Universes from development to production environment.
• Worked on Universes to refresh BEx Query structure and also involved changing the pointer at the OS level.
• Worked on the Physician Call and Change WEBI reports to display Baseline End date which is coming from BEx query as a key figure on the heading of each measure in the report.
• Added separate tab to the Internal WAS WEBI reports for the FPC Sales Force and also made sure report is refreshing on open.
• Prepared Design Documentation to the DR project as well as FPC sales force project in the Microsoft Visio.
• Coordinated with Basis Team to move Transport Objects from Development to Production system.
• Monitored batch job processes after deploying changes into the Production Environment.

Confidential

SAP Consultant / Business Reporting

Responsibilities:

• Worked with business to scope the project and helped business users create Functional Specs.
• Enhanced standard extractors to fulfill the Business requirements.
• Created data sources using generic and application specific extraction for FI and SD OTC modules and loaded the business content.
• Extracted the data using extractor LO Extraction 2LIS 12 VCITM Sales-Shipping: Delivery Item , 2LIS 13 VDITM Billing Document Data: Items , 2LIS 11 VAITM Sales Order Item Data to DSO's and to the respective Cubes.
• Used both initializations with delta update and full update methods depending on the business requirement
• Extensive experience in performance tuning of queries by maintaining Aggregates, Indexes, Info Cube Partitioning and Info Cube Compression
• Extracted data from BW Info Providers using Open Hub Functionality to external systems through flat files and separate DB tables.
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Created process chains for daily data loads, Aggregates Roll up, etc. Created messages in the process chains for load failures using emails.
• Built BEx queries with Restricted Key Figures, Calculated Key Figures and Variables which would be utilized to build the Business Objects OLAP Universes.
• Experience in the design and implementation with SAP Business Objects BI Product Suite Web Intelligence, Explorer, Xcelsius, Visual Intelligence and Mobile BI .
• Worked extensively on BEx Analyzer and customized the reports creating variables, exceptions and conditions
• Experience with Business Intelligence/ Datawarehouse data store design Datawarehouse - Datamart / Operational Data Store environment.
• Designed and developed reports on sales and distribution cubes.
• Created a BW report on Sales Analysis Enquiries and a report on Daily Bookings and Shipments using company code.
• Experience with Business Objects Enterprise / SAP Business Intelligence Analytics Platform 4.0.
• Hands-on experience in Universe Design using Universe Designer / Universe Design Tool.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Knowledge of business intelligence best practice processes, tools, standards and practices.
• Hands-on experience with Web Intelligence, QAAWS, Live Office, Info view.
• Handling configuration work which basically involve diagnosing / analyzing the problem or requirement suggesting a solution and recommending action.
• Validating the configuration requests suggesting rework actions. Carrying out Configuration tasks in the development environment Creating change request and releasing transport requests for moving the Configuration to the live Server.
• Conducting test as required in the Pre-production server before the configuration is put in the live server.
• Testing may be of configuration, transaction or quality.
• Also includes Support pack testing, System Acceptance testing