PROFESSIONAL SUMMARY

• Experience in 3 Full Life cycle implementations in SAP BI/BW for different modules, and experience working with SD, SCM, MM, SRM and HCM.
• Working understanding of accelerated SAP methodology for life cycle implementation.
• 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 ETL process.
• Experience of working in SAP BI/BW in telecommunication, utility sector, financial sector, energy sector and food companies.
• Expertise in Performance tuning and working experience on scheduling Batch Processes through process chains. Improved query and load performance using Aggregates, Partitions, number range buffering, Data Selection and Data Compression.
• 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.
• Worked on extractors in the areas of WAS, PP, FI/CO, MM, SCM and SD
• Experience in BI enterprise reporting with SAP NetWeaver BEx Query designer, Web Application Designer, Analysis Process Designer.
• Involved in creation of Infocubes, 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.
• 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
• Support ABAP and formula editor to customize update rules for ODS Objects and InfoCubes
• ABAP experience to support writing Update and Transfer Rules, Start Routines, End Routines and Expert Routines.
• Involved actively in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
• Experience using Excel, Outlook, SQL Analyzer, MS Access
• Good Team Player, Strong Interpersonal Communication skills combined with Self-Motivation, Initiative and Project Management Attributes.

TECHNICAL SKILLS

ERP: SAP R/3 4.7, 4.6, ECC 5.0, ECC 6.0

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.

Languages: C, C++, C#, Java, Visual Basic, ABAP/4, SQL, PL/SQL.

Databases: SQL Server 2000/2005, Oracle 8i/9i/10g, MySQL, MS Access

Web Servers: IIS 5.0/6.0/7.0

Scripting Languages: HTML, Java Script, ASP, JSP, CSS

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, Georgia

SAP BI/BW Consultant

Environment: R/3 BW 3.5, BI 7.0, WAD, BEx Analyzer

Responsibilities:

• Completed phase one of an ongoing project which is called the GRS (Global Repair Services)-Demand Planning project.
• Completed eRMA WAS reporting, CVRT project in which got good experience in creating generic extractors, function module and SAP program which was a copy of standard SAP program.
• Worked on APO, WAS, ECC source systems for these projects.
• Worked in AHS (After Hours Support) team to monitor Process Chains and provide production support (hypercare).
• Created data transfer processes using process chains and gained experience in extraction, transformation, data distribution techniques in the ETL process.
• Wrote start routines, end routines, expert routines as well as logic for DTP, infopacks to dynamically change the selection criterion based on sy-datum, etc.
• Resolved the RFC issue successfully when we were not getting records into BW from the source system (WAS) as the transaction ids were getting stacked up in the TRFC monitor. (applied a SAP note)
• Built a lot of Process Chains (some to trigger the IF wf using ABAP program) and corrected some PCs already in Production in order to improve the system performance.
• Worked on the eRMA project to write logic in order to do look-ups on different DSOs (cartdtl, serial no, etc) and built MultiProvider to do reporting off it.
• Monitored the discrepancy between the ZRM3 report generated on ECC side with the IF record count and the record count from the function module result screen on BW side which was causing significant hypercare issues.
• Wrote routines to convert calendar weeks, calendar days coming from the APO side to fiscal month, fiscal weeks on BW side using different function modules.
• Created generic extractors on ECC, WAS and SCM side following the SOLMAN (Solution Manager) process.
• Got approval for every change in the Source System from the CAB (Change Advisory Board) which is a meeting attended by technical experts, architect and technical leads.
• Created Z tables in ECC, SCM, WAS and SAP program for different projects.
• Created export generated DataSources to test data in Q bringing it from BWP as well as exporting InfoCubes over to different source systems to bring data over.
• Wrote expert routines for looking up data based on the requirement to do calculations for the CVRT project and created OpenHubs to give data over to Informatica.
• 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.

Confidential, Beaumont, Texas

SAP BI Consultant

Environment: R/3 4.7, BW 3.5, BI 7.0, WAD, BEx Analyzer

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.
• 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 routines within 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.
• 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.

Confidential, Nashville, TN

SAP BW Consultant

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

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 the 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 to
• Uploaded the 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).
• Created Web templates using Web Application Designer WAD.
• Involved in creating I-views for web templates.

Confidential, Bakersfield,CA

SAP BW Technical Consultant

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

Responsibilities:

• Created reports in SD like Daily Sales Bookings, Deliveries and Billing, Monthly Sales Analysis, etc. 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 orders.
• 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.

Confidential

SAP BI/ BW Consultant

Environment: BW 3.5, BI7.0, ECC 6.0, ABAP/4, BEx Analyzer, Query designer, WADBusiness Modules: CRM, CCS, SCM, MM, SD, PP

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.
• Developed reports for SAP CRM, and MM.
• Designed, developed and documented the star schema model for the custom InfoCubes to upload cost center information.
• Developed the ODS architecture for sales orders, delivery, billing & consolidated ODS.
• Migrated Queries upgraded and migrated the templates from 3.5 to 7.0.
• Conducted Query consolidation and designed a layout for the web templates.
• Application of OLAP Processor core functionalities, slice and dice, drillup- drilldown, special aggregation, sorting, aggregation for analyzing and reporting the data.
• Actively involved in Data Modeling design and created Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, updating Transformation rules, Data Transfer Process (DTP), Open Hub service.
• Developed customized cubes for Cost Center, Internal Orders, WBS Element, FI-AP, FI-AR, FI-GL(New)
• Worked extensively on 0CCA C11, 0OPA C11, 0WBS C11, 0FIGL C10, 0FIGL V10, 0FIGL C14, 0FIAP C03.
• Worked on Start routine and End Routines in the transformation using ABAP programs.
• Created/Maintained and regular monitoring of process chains for Master and Transactional Data.
• Created transports to move objects to Production.
• 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.
• Generated reports on Info Cubes, Info Sets, ODS and Multi Provider using BEx queries.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Involved in the migration and deployment of the universes and reports across multiple domains.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as iView.
• 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.for Mid Market
• Design and development of a multi-dimension authorization concept in BW
• Data modeling and implementation of the ODS objects
• Development of transfer and update rules in the ODS object
• Enhancement of a customer-internal extractors (from CRM) for business partner