Summary - SAP Certified Solution Consultant in SAP NetWeaver BI / BW.

• 6years of experience in SAP and 5 years experience using SAP BI 7.0, full cycle implementation
• SAP BI 7.0 Reporting: Worked extensively with BEx Analyzer, BEx Browser, BEx Query Designer, for developing reports, analysis and also worked on Web reporting using BEx Web Publisher, Web publishing wizard and BEx Web Application designer.
• SAP BO Universe design and experience in the use of WEBi, DESKI, Xcelsious and BO Integration Kit
• SAP BW Data extraction: Experienced in Data Extraction from Flat Files and SAP R/3 using different extraction structures such as LO-Cockpit and Business content, excellent knowledge of SAP BI 7.0 components like Data source Enhancement, User Exits.
• SAP BW Generic Data extraction: Created, activated and worked on a daily basis with Generic Extractors based on Tables, Views and InfoSets.
• SAP BW Support: Provided technical support to other developers and coordinated escalation of issues to SAP Online Support System for resolution.
• SAP BW Performance Tuning: Experience in Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing of infocubes and use of statistics for the same.
• BI 7.0 Data Monitor: OLTP extraction data, Loading (Full /Delta Up-Load), Scheduling, Monitoring, Process Chains, Remote Cubes.
• Performed Data load management, CTS, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Remote Cubes, MutiCubes, Data Mart and Open Hub Service.

Strengths

• Data Warehousing Concepts including Multi Dimensional Modeling, ETL, Reporting (BEx), Monitoring, Configuration, implementation, upgrade & Support.
• Business Object Universe Design, Xcelsious / Crystal reporting, WEBI, DESKi, BO Integration Kit
• SAP NetWeaver, BI & EP.
• Database Designing, Programming (OLTP), Administration and report optimization

Certification

• SAP Certification in SAP NetWeaver BI.
• Trained in data integration using SAP Business Object
• Query Design, Optimization and Performance.
• BI EP Integration scenarios

Professional Experience

Confidential, Houston, TX, USA
Client - GMAM, Detroit (February, 2010 September, 2010).
Position: SAP BI Developer [Front End and Backend], Lead & Support services
Responsibilities:

• Used BEX Analyzer, BEX Web Analyser, WAD and Query Designer for Query Presentation, Management and Generation.
• Extensively used BEX analyzer, Filters, Calculated and Restricted key figures, Exceptions and Conditions. Generated reports using Query Designer and WAD.
• Optimised queries run time by creating queries with Variables [User Exits, Replacement variables and Manual input].
• Created Jump Queries using RRI (Report to Report Interface) to give facility to drill down Report from summarized format to detailed format.
• Business Object Universe design
• Create Dash board for data analysis using SAP BO Crystal and Webi Reporting tools
• Involved in various kinds of Unit testing, Integrated Testing, Acceptance testing and Regression testing of the developed objects, reports and checking the data quality and the functionality of the objects as per the requirements.
• Implemented various Performance Tuning activities to increase the performance of Queries by Creating Aggregates, Partitioning and Compression of infocubes.
• Responsible for Identifying Business Requirements from end-users. Installed Business Content, Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object.
• Tested the new features of BI 7.0 which includes new data flow, re-modeling, Real-time Data Acquisition, enhanced features of Process Chains etc.
• Responsible for the creation of Naming Convention document and other Documents for Infocubes, DSO Objects, Info Sources, Info Objects.
• Worked extensively on Logistics Cockpit and extracted data. The data included Sales Order, Delivery, Shipment, Billing, Purchase, Goods Movement, and Stock Revaluation.
• Extended the Business Content Data sources using Enhancements and populated the appended fields using User Exits. Created custom Info Source/Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW
• Responsible for conducting Extractions from R/3, which involves Datasource enhancements for FI and Queued Delta, V3 Job scheduling procedures for SD modules.
• Applied Transfer rules, update rules, involving transformations (transfer routines, start routines, Update routines) to maintain data consistency.
• Worked on standard business content Financial Accounting Cubes 0FIAR_C02, 0FIAR_C03, 0FIAP_C02, 0FIAP_C03.
• Involved in various Sales and Shipment data extractions like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VAKON, 2LIS_11_VASCL and Shipment data extractions 2LIS_08TRTK, 2LIS_08TRTLP.
• Involved in Sales order Header and Item Level data extraction
• Used different tables to extract data, tables such as VBAK (Sales order header data), VBAP (Sales order item Data), VBUK (Sales document Header status), and VBUP (Sales document item status).
• Was involved in Building different Cubes, DSO’s in supply chain management, info-providers in Quality Management: Inspection lot cube, notifications item DSO, Notification Activities Cube, Plant maintenance: Equipment Dismantling, Maintenance orders Cubes. Purchasing, Production Planning and Controlling.
• Managed, monitored several data loadings, Error Debugging and rectification, solving issues, problems faced during Data uploads. Involved in Increasing the Load performance of the BW system while loading into ODS objects and Info cubes.
• Created Process Chains for loading Master and Transaction data and running subsequent processes.
• Data cleansing and Error handling of PSA data and loading PSA data to ODS objects. Staged Data in the ODS before transferring to the Info cubes.
• Archived Transaction data from Info cubes and ODS objects using archiving objects to reduce the enormous administration workload which led to longer data processing times.

Environment:SAP BI 7.0/IP, BW 3.5, SAP R/3 4.7, ECC 6.0 SD, MM, FI/CO, CRM, SAP BEx Analyzer, BEx Analyser, BOE XI 3.1.

Confidential, TX
Client Johnson & Johnson, Bridgewater, NJ [ Oct, 2009 - Feb, 2010]
Position: SAP BW/BI

Responsibilities:

• Understandings design documentation including the high-level data model and understand the complexity and dependencies and plan the timelines for development based on the resource availability.
• Interpret functional requirements based on the design document and support the Technical Development Specifications for SAP BW database and reporting objects.
• Creation of Generic Datasource using Tables/Views, Functional modules and customizing the Business content Datasource through User Exit in SAP R/3 and ECC6.0.
• Transformation and updating of Data from the source system using Transfer Routines, Update Rules, Start Routines, End routine (ABAP/4) etc.
• Developing various kinds of reporting objects including the Queries, Web Templates, query variables, Variable exits, workbooks, RRI. Exceptions, conditions etc.
• Customizing of standard BW objects as per the client requirements and extraction and loading of data from ECC.
• Configured the V3 jobs for delta collection and Delta Extraction. On the BW side, have created necessary Infopackages for Init & Daily Delta Loads for both Master & Transaction Data. Extracted & Validated Data; Created Process chains to automate the load schedule. Extracted data from ECC & Flat files.
• Used the BEx Web Application Designer, to create HTML pages which contain various tables, charts, existing exceptions, filters and alert monitor.
• Used RRI interfaces, filtering, conditions, variables, currency conversions, jump queries and navigational attributes. Exception handling through SAP Mail, batch printing and alert monitor.
• Created Aggregates for Info Cubes to improve query performance.
• Develop SAP BW Reports in support of Functional and Technical specifications and document the design and development of the Database objects and reports.
• Transportation of BW Objects from Development system across the landscape through Transport Connection.
• Involved in various kinds of Unit testing, Integrated Testing, Acceptance testing and Regression testing of the developed objects and checking the data quality and the functionality of the objects as per the requirements.
• Lead the Quality review team to review all the developed objects and checking the quality of development, functionality and the validity of the data to check if the objects are developed as per the Clients requirements.

Environment SAP ECC 6.0, BI 7.0, SD, SCM, HR,FI, BEx Query Designer, BEx Analyzer, BEx Web Analyzer, BEx WAD, BEx Report Designer

Confidential, London, UK
Client National Health Service, London, United Kingdom (April, 2008 September, 2009).
Position BW Support consultant
Responsible for

• Lead the SAP Netweaver BI implementation team which implemented BI for the first time at NHS South UK. Implement an enterprise wide reporting solution for their global accounting and sales operations.
• Performed requirements gathering, translating functional to technical requirements, Implementation, Training and testing.
• Enhanced Business Content and Material Classification were implemented.
• Custom sales analysis reports cut short the reporting time from 30 days to near real time with ad hoc data loads.
• The ETL process was automated using Process Chains.
• EP was also configured for web reporting.
• Training materials and training was organized. Trained the client to manage support activities on their own.
• User Acceptance testing was conducted in 2 iterations and any bugs were analyzed and rectified and issues with Business Content and the SAP BI product were ironed out with the help of SAP through OSS.
• Using SQL to retrieve data and using Business Objects Data Integrator Ensures Timely, Accurate, and Trusted Data are deliver to the end user
• Implementing Business Object Advanced data profiling to validate data content, structure, quality, and relationships between tables in data source.

Environment SAP ECC 5.0, BI 7.0, EP 7.0, BEx Query Designer, BEx Analyzer, BEx Web Analyzer, BEx WAD, SAP BOE XI2, WEBI, DESKI, Crystal Reports.

Confidential, London, UK
Client Lambeth Borough, London, United Kingdom (Mar, 2007 Apr, 2008).
Position: SAP BW/BI Consultant
Responsibilities:

• Schedule daily/weekly/monthly data loads.
• Maintaining Reconciliation to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Monitoring of data loads and analyzing the reasons for frequent failures of info packages.
• Involved in solving tickets regarding Extractions, Performance Issues and also Load Failures.
• Created Reports using Calculated Key figures, restricted key figures, Formulae, Conditions and Variables and Developed Drilldown Reports Using RRI
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Maintain list of all the activities for all the tickets until it is closed down.
• 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.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Monitoring of info packages and analyzing the reasons for frequent failures of infopackage.

Education :

MSc Petroleum Engineering
BEng (Hons) Mechanical Engineering