PROFESSIONAL SUMMARY

• Over 7 Years of experience in SAP BI/BW.
• Experience in 3 Full Life cycle implementations in SAP BI/BW for different modules, and experience working with SD, FI/CO, SCM, IM, MM, SRM, PLM and HCM.
• Working Experience in all phases of the project from blue print, gap analysis to customizations, Go-Live, Post Live Production support, User training documentations.
• Expertise in creating Data transfer processes using process chains and extensive experience in extraction, transformation, data distribution and real- time data acquisition (RDA) techniques in the ETLprocess.
• Working understanding of accelerated SAP methodology for life cycle implementation.
• Excellent skills in Extraction from SAP R/3, flat files and BW using extraction structures such as LIS, LO Cockpit, CO-PA, FI, Business Content and Generic Extractions.
• Performed Data load management, CTS, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Multicubes, Data Mart and Open Hub Service
• Experience of working in SAP BI/BW in utility sector, financial sector, pharmaceutical and food companies.
• Extensive experience in BI/BW with Infocube design, ODS objects, DSO objects, InfoSets, MultiProviders, Remote Cubes, InfoObjects, Hierarchies, Data Sources, Update Rules, Transfer Rules, Infospokes, Open Hub Service , Infosets, DTP’s, Transformations, Start routines, End routines, Expert routines and Function Modules.
• Expertise in Performance tunning and working experience on scheduling Batch Processes through process chains. Improved query and load performance using Aggregates, Partitions, and number range buffering, Data Selection and Data Compression.
• Excellent skills in Extraction from SAP R/3, flat files and BW using extraction structures such as LIS, LO Cockpit, CO-PA, FI, Business Content and Generic Extractions.
• Worked with SAP SPM(Spend Performance Management) and also experienced in HR BI.
• Also used BOBJ which is a reporting tool and migrated data from BI to BO.
• Worked on extractors in the areas of FI/CO, PP, MM and SD.
• Expertized in transferring data from BW 3.0/3.5 to BI 7.0.
• Experience in BI enterprise reporting with SAP NetWeaver BEx Query designer, Web Application Designer, SAP Netweaver Visual Composer, Analysis Process Designer, WEBI, Xcelsius and Dash Boards
• Navigating in reports, restricted Key Figures, calculated Key figures, structures and cells, properties of Attributes and Characteristics, hierarchies, Variables, exceptions & conditions, report to report interface (RRI) BEx Analyzer and BEx Web Analyzer.
• Well expertised in SAP SD/VISTEX.
• Experience in Integrating SAP BI/BW with Business Objects tools and designing Universes, generating complex reports in Webi, Deski and Crystal.
• Support ABAP and formula editor to customize update rules for ODS Objects and InfoCubes
• ABAP experience to support writing Update and Transfer Rules and Start Routines.
• Efficient with ABAP loading for large number of programs,function groups and module pools.
• Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
• Experienced in working with GRC Access control.
• Experience using Excel, Outlook, MS Access, VB6.0, EJB.
• Good Team Player, Strong Interpersonal Communication skills combined with Self-Motivation, Initiative and Project Management Attributes.

Skill Set

Data Warehousing SAP BW versions 3.0c, 3.1c, 3.5, BI 7.0

Functional Module FI/CO, SD, MM, IM, CO-PA, HR, PP, PLM

Reporting BEx Reporting Designer, WAD, Crystal reports.

Education:Bachelor of Technology

WORK EXPERIENCE:

Confidential, WI February 2011- Present
Sr. SAP BI/ BW Consultant

Responsibilities:

• Involved in full life cycle implementation, accelerated SAP methodology and Post Go-live support.
• Generated reports using BEx Query Designer with SAP CRM as a source system.
• Migrated Queries upgraded and migrated the templates from 3.5 to 7.0.
• Conducted Query consolidation and designed a layout for the web templates.
• Customized Purchasing and Inventory cubes and developed custom objects for purchase requisitions and MRP data. Responsible for statistical update (Initialization) of MM application setup tables and configuring the delta extraction for logistics extractors
• Co-ordination with all the users / functional Leads of all modules and gathering the requirement for BI reports.
• Improved the query performance and load performance using aggregates, partitions, number range buffering, data selection, and data compression.
• Created Data Transfer Process(DTP) to schedule the update in BI 7.0
• Generated reports on Info Cubes, Info Sets, ODS and Multi Provider using BEx queries.
• Created Reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, grouping, sub reports etc.
• Global User training on Strategic and Operational BI reporting.

Environment: BW 3.5, BI7.0, ECC 6.0, ABAP/4, Crystal Reports 10.0, Oracle 9i/10g, BEx Analyzer, Query designer, WAD, BO Designer, WEBI , Xcelsius 2008, FI- CO, CRM, HCM, CCS, SCM, MM, SD, PP

Confidential, San Francisco CA September 2009 to February 2011
SAP BI Consultant

Responsibilities:

• Created master data Info Sources for uploading master data and hierarchies
• Activated and customized profit centre accounting cubes, accounts payable cubes and accounts receivable cubes
• Actively involved in Data source enhancements, generic extractors, user Exits and customized delta built up for the data sources, V3 Updates, controlled by pull/push principle from OLAP system
• Created Extract Structure, Transfer Structure, Replication of Data Sources. Created and maintained Transfer Rules for Communication structure and later by defining Update rules
• Actively involved in extracting required data from the Data Source of PSA to ODS
• Created Data Extraction programs for generating reports using ABAP/4. Created ABAP routines for Transfer Rules and Update Rules
• Created role based security and authorization for all objects
• Extensively used BEx Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets
• Involved in creating JavaScript for passing variables to different levels for WAD (Web Application Designer
• Extracted data from Non-Sap like SQL Server using DBConnect.
• Actively involved in design of physical and logical data modelling
• Monitor Data Load Performance statistics in Production System
• Check Data size reduction against the objectives
• Tune the Data Loading, Housekeeping & Archiving Setup to ensure objectives are met
• Optimize Data size to ensure user requirements for 5 yrs. of data for the users of the system are met
• Optimize the data size is reduced while ensuring that the above requirement is not compromised.
• Key User Documentation and Training.

Environment: SAP BW 3.5, BI 7.0, SAP R/3 ECC 6.0, SD, MM, PM, HCM, CRM.

Confidential, Lake Forest, IL June 2008 to August 2009
SAP BW Technical Consultant

Responsibilities:

• Managed and monitored data loads with Full update and Delta update
• Created reports, which displays sales orders and line items, which needed to be delivered by a certain date
• Involved in extraction of data from PM.
• Involved in Up gradation of the system from 3.5 to BI 7.0, migrated BW 3.5 data sources to BI 7.0 data sources
• Created Data Transfer Process(DTP) to schedule the update in BI 7.0
• Experienced in formatting various changes in WAD like converting Bar graph to line graph during the upgrade
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors
• Enhanced new Info Objects to be attached/mapped in Info Sources/Communication structures. Changed transformation rules as per customer requirements (ABAP routines)
• Designed, developed ETL, extracted BW Data to Non- SAP System using Open Hub service
• Maintained Process chains to automate and schedule the background performance tuning jobs of BW query using Indices, aggregates, Compression, Achieving and Partition
• Evaluated statistical performance on OLAP using BW Statistics
• Monitor Data Load Performance statistics in Production
• Rescheduled the failed request from the cube by deleting the requests in the Info Cubes
• Used the new functionality BEx Information Broadcasting available in BI in SAP Net weaver 2004
• Published the reports in Portals from WAD by sending them in iViews
• Involved in creating JavaScript for passing variables to different levels for WAD (Web Application Designer)
• Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information, required in areas of SD and MM. Worked on Currency conversion as per user requirements.

Environment: SAP BW 3.5, SAP R/3 4.7b, FI, CO-PA, CRM, HCM.

Confidential, Bartlesville, OK Novenber 2007- June 2008
SAP BW Consultant

Responsibilities:

• Interacted with Subject Matter Experts for studying their business requirements.
• Actively involved in the complete life cycle implementation of SAP BW.
• Analyzed business reporting requirements that could be satisfied with SAP business content and installed the documented objects.
• Analyzed, designed and developed Extraction, Transformation, data acquisition, and real time data acquisition processes for a data warehousing and Data Migrations projects
• Analyzed Info Cubes and improved tbrahe performance by creating aggregates, using BI accelerator Index and regularly tuning the data models for info objects and queries.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies).
• Attached newly developed objects to Requests and Tasks and Transport them to QA and Production system.
• Configured, enhanced and extracted data from SAP (using COPA, LO and Generic extractor) and non-SAP systems.
• Defined specifications for frequency and mode of data transfers and setup of batch jobs for Info package by coordinating with basis and system admin teams.
• Experienced in working with ABAP loading for many programs.
• Uploaded data to BW from source systems in specific intervals using delta update mechanisms.
• Developed flexible queries using filters in BEx analyzer to facilitate data analysis
• Created and maintained Report-to-Report interface (RRI).
• Worked on Service Customer management(SCM) server.
• Created Web templates using Web Application Designer WAD.
• Involved in creating I-views for web templates.

Environment: R/3 4.7, BW 3.5, BI 7.0, WAD, BEx Analyzer, CRM, SCM, MM, SD,HCM.

TSK Innovations CO, Elpaso, TX April 2007 to November 2007
SAP BW Consultant

Responsibilities:

• Performed functional migration of SAP BW3.5 to SAP BI7.0.
• Worked in the Design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
• Performed migration of emulated data source.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
• Implemented Start and End routineswithin Transformations.
• Enhanced Infocube with remodeling concept to make changes, without having to reload data.
• Used Direct Update DSO in the process of APD (Analysis Process Designer).
• Generated Queries using new BEx Query Designer.
• Designed new applications using new Templates in BEx WAD.
• Worked extensively with new BEx Analyzer.
• Worked with BEx Report Designer to create formatted reports.
• Actively worked in designing, formatting and delivering financial statements, using Crystal Reports
• Executed Adhoc query analysis using Web Analyzer.
• Launched BEx Report to the Web and generated PDF file.
• Experienced in using BEx Information Broadcasting to distribute the right information to the right people at the right time.
• Experience working with New Integrated planning module.
• Published reports on Enterprise portal as iviews.

Environment: SAP R/3 4.6, BW 3.1c, 3.5, BEx Analyzer, WAD, SCM, PP, MM, QM, SD, FICO

Confidential, Hyderabad, India. February 2006 to March 2007
Software Engineer.

Responsibilities:

• Design and Development of Custom Infocubes, ODS objects, Multi Providers, Infosets and master data objects.
• Developed Custom ODS objects that captures the erroneous data.
• Development and Enhancement of Info sources, Transfer rules and update rules.
• Created update rules with necessary update routines and start routines.
• Created and activated Communication Structure, Transfer Structure, Transfer Routines, Update Rules (both ODS and Info Cube level). Built and loaded cubes and validated results.
• Created Scheduling plans for data load to use Process chains in order to load Master Data and Transactional Data from SD into BW.
• Worked on system tools for tuning like RSRV, ST05.
• Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.

Environment: BW 3.5, BI7.0, ECC 6.0, BEx Analyzer, Query Designer, BEx Broadcaster, WAD, SD

Bharat Petroleum Co. Ltd. Mumbai, India, July 2004- January 2006
Software Engineer

Responsibilities:

• Created reports in SD. using BEx query designer, Web Application Designer (BEx-WAD).
• Set up the logistics customizing cockpit by maintaining the extract structures and data sources, activating the update, setting up V3 update for SD documents: sales, delivery and billing order.
• Assigning data sources to the Info Source, defining transfer structure, and metadata maintenance for the Info Source.
• Worked in Logistics data providers, SD and Logistics Info cubes, DSO, multi providers according business needs in SAP BI.
• Extracted and uploaded data into infocubes from data sources like 2LIS_12_VCHDR- Delivery Header data, 2LIS_12_VCITM- Delivery Item Data, 2LIS_12_VCSCL- Schedule Line Delivery, 2LIS_11_VAHDR- Sales document Header data, 2LIS_11_VAITM- Sales document Item data, and 2LIS_11_VCSCL- Sales document Schedule line and customized them using Update Rules. Created DSOs, Info Cubes and Multi- provider for queries. Created Billing Documents, Deliveries Reports, orders deliveries and sales quantities reports, on Sales Overview and Deliveries Info Cubes.
• Developed and documented high level technical design model for the OTC reporting project, using Microsoft Visio.
• Generated reports for the Manufacturer to notify the delivery date and the details of material based on sales order.
• Generated reports to list the detail information of consignment Issue/returns.

Environment: SAP R/3 4.6, BW 3.1c, 3.5, BEx Analyzer, SD