SUMMARY

• Over 9 years of experience in field of IT, this includes 7 years of SAP BW wif ABAP and one and half in JAVA Technology.
• Involved in Two full life cycle implementations, one upgrade project and production support.
• Analytical, flexible, result - oriented person who understands sense of urgency, works well under pressure and is competitive and customer focused.
• Experienced in preparing data modeling and query design documents based on the business requirements.
• Experience in BI 7.0 and Involved in ETL Process, Including Transformations and Data Transfer Process (DTP).
• Niche expertise wif Generic extraction, LO and FI extraction methods.
• Expertise in LO Cockpit, FI-AR, FI-AP, CO-PA, FI-SL and Generic Extractions.
• Highly efficient in designing architecture for different staging scenarios involving Operational Data Store (ODS) and InfoCubes in order to present an efficient Data Model.
• Customized InfoCubes, DSO, InfoObjects and InfoSources.
• Proven ABAP/4 capability wif User-Exit enhancements, Rules and Routines.
• Extraction from Oracle views using DB Connect Data sources.
• Experience in Open Hub (Info Spoke) to download data from InfoProviders to flat files.
• Experienced in creating Restricted Key Figures, Calculated Key Figures, Characteristic Variables, Text Variables, Variables, Structures, Exception and Conditions.
• Designed the Dashboards using Visual Composer and published using iViews in Portal.
• Implemented performance tuning using Indexing, Compression, Aggregates, rollup and Partition.
• Developed the Process chains to automate the loading process and monitored them.
• Involved in production support activities like to monitor of jobs, checking the workload of the system and Process Chain log to monitor running of chains.
• Involved in preparing technical specification and functional specification.
• Good knowledge in Performance Optimization Using BI Accelerator (BIA), Redesign functions Remodeling, Repartitioning, Integrated Planning (IP).
• Worked on BEx components - Query Designer, Analyzer, Report Designer and Web Application Designer.
• Good Understanding of BDC for Data transfer from legacy system to SAP system.

TECHNICAL SKILLS

ABAP/4 Tools: Data Dictionary, Application Hierarchy, Transport Organizer, Transactions, Area Menu, and SAP Query.

Debug and Test Tools: Breakpoint, Runtime Analysis, SQL Trace, Dump Analysis, and CATT.

Reports: Classic and Interactive reports using Report writer/painter, Screen/Menu Painter and ALV Grid/List.

Layouts: SAP Scripts (Text, Style, Forms) and Smart forms (Smart Styles).

Enhancements: Customer exits (Menu exits, Screen exits and Functional Module exits).

Dialog Programming: Dialog programs using screen painter, flow logic and transaction code.

Data Load: BDC, BAPI, LSMW.

Cross Application: BAPI, ALE and EDI, Extension and Creation of IDocs.

Data Warehouse: SAP NW 2004 BI 7.0

Database: Oracle 9i PL/SQLLanguage ABAP, JAVA, PL SQL

Office Tools: Microsoft Excel, Word, PowerPoint

OS: UNIX, Windows

Reporting Tools: BEx Reporting, Crystal Reports.

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP Consultant - SAP BI

Responsibilities:

• Developed Process chains for data loads.
• Developed Delta setup process for LO Extractions.
• Identified the needs for data staging layers in BI. Installed BI Content and enhancements based on business needs.
• Customized and maintained DataSources such as Billing (2LIS 13 VDHDR), Sales Order (2LIS 11 VAHDR), and Delivery Order (2LIS 12 VCHDR) for the SD module and Purchasing Order Item (2LIS 02 ITM) for MM. Used process chains to schedule the info packages and data transfer processes. Also customized primary LO Cockpit structures 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL and set the extraction process using LO cockpit and V-3 updates.
• Configured BW objects including generic data sources to extract data from R/3 systems.
• Activated Delivery service info cube 0SD C04 for the monitoring delivery schedules.· Extracted Purchasing Data, 0PUR C07 (Purchase Order Quantity Service Level), 0PUR C08 (Purchase Order Item Service Level) and 0PUR C09 (Purchase Order Service Level).
• Responsible for job schedules for loading Master Data (Texts, Attributes and Hierarchies) for Materials and Transaction Data into the corresponding ODS Objects and InfoCubes.
• Activated Business Content DataSource 2LIS 02 ITM and enhanced both using Lo-Cockpit and Append Structure. Developed User Exit RSAP0001 to fill the additional fields added through append structure. This DataSource is replicated and InfoSource created using this DataSource. A Custom InfoCube has been created using this InfoSource.
• Installed Purchasing data Cube 0PUR C01 from the data sources 2LIS 02 SCL & 2LIS 02 ITM and 2LIS 02 HDR.
• Reconcile data loaded between BI and ECC systems.
• Created Sales MultiCube over the Sales order, Delivery to provide visibility of data across the sales cycle in the same query.

Environment: SAP BI 7.0 and ECC 5.0 MM, SD, FI.

Confidential, AZ

Senior SAP Consultant

Responsibilities:

• Responsible for creating the Queries based on the user requirements.
• Worked on BI 7.0 testing, Consistency Checks, Impact Analysis and kick off all the master data and transactional data process chains and compared the reports wif production system.
• Customized and maintained Datasources such as billing item (2LIS 13 VDITM) and Sales Order item (2LIS 11 VAITM) for the SD module and Purchasing Order Item (2LIS 02 ITM) for MM
• Created Transport requests and transported the developed Info providers and queries to the test box and subsequently to the production box
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned Queries using Aggregates and MultiProvider
• Performed statistical setup for purchase, Sales, Billing and Shipment and extracted the data to BI.
• Customized Lo Cockpit data source to include custom defined fields and populated those fields using customer exits before the setup.
• Used “Queued Delta” method to extract the delta records of MM and SD application.
• Extensively worked in generating reports on Finance Invoices and MM Invoices. Worked on Finance Data Extractors 0FI AR 03 and 0FI AP 03 and loaded data into data targets.
• Designed and developed process chains (RSPC) for master data loads and transaction data loads wif the halp of Info Packages and these Process chains are scheduled for periodic loads.
• Involved in production support to check the loads regularly.
• Involved in solving performance-related issues.
• Daily monitor the data loads and resolve the issues on priority base.
• Created and maintained aggregates, rollup of data using process chains, after the successful extraction of transaction data.
• Expertise in creation of BEx Queries, Workbooks, structures, variables, calculated key figures, restricted key figures and RRI reporting.
• Extensively worked on Creating Dashboards & Web Reports Using Web items Like Tables, charts, Drop down Box, Radio button Check Group, Label, Filter and Text Elements.
• Generated Queries, Reports, and Work books wif custom Layouts using logos, Charts Overdue analysis, Customers Overview, Vendor overview etc..,
• Transport of objects from Development to Testing and Production systems using CTS and Error correction during import.

Environment: SAP ECC 6.0, SAP BI 7.0, SD, MM and FI/CO modules, Windows 2000/NT.

Confidential, Fl

Senior SAP Consultant - BI/BW

Responsibilities:

• Conducted Requirements Gathering interviews and workshops wif end users.
• Mapping of Data elements, Data dictionary, Design of ODS, InfoCube, and Multi Providers. Definition of key figures and characteristics. Some areas are for FI (AR,AP,GL)
• Used BW Standard and Generic Extractors to fetch the data from ECC to BW.
• Developed and modified InfoObjects, InfoCubes, ODS Objects, DTP, Transformations, to suit the business requirements.
• Involved in the development of Infocubes for FI, FI-GL, FI-SL, CO-PA.
• Implemented complex update rules and transfer rules.R/3 User exits for transactional and master data attributes.
• Worked on data modeling. Worked on Infocubes such as 0FIAP C02 (Account Payable), 0FIAP C03 (Account Payable Line items), 0FIAR C02 (Account Receivables), 0FIAR C03 (Account Receivables Line Items), 0FIAR C05 (Account Receivables Payment history) and developed custom Infoproviders and ODS objects required for MIS to analyze data in decision making.
• Migration of DataSources from 3.x to BI 7.0.
• Populated the Info Objects, ODS Objects and InfoCubes wif Master data and Transactional data from SAP R/3 via Data Staging area (PSA) by creating InfoPackages.
• Involved in creating update rules and start routine. Designed and developed technical architectural solution.
• Worked wif reporting team to generate reports in Cognos using Report studio and BEX, Web query development and Crystal reports from SAP BW as well as SAP R/3 for presentable Dash Boards, Balance score cards etc.
• Developed enterprise IT strategic direction and able to influence IT system decisions that are cost TEMPeffective, supportable and scalable in computing environment.
• Involved in creating MultiCubes, Infosets based on the requirements.

Environment: SAP BW 3.X, 7.0, SAP ECC 5.0, Bex Analyzer, Bex, Oracle 9i, ABAP4, FI, CO.

Confidential, CA

Senior SAP BW & ABAP Consultant

Responsibilities:

• Heavily involved in customizing and activating standard delivered BW business contents in the areas of Sales and Distribution, Profitability Analysis, Account Receivable and Account Payable.
• Worked wif CO-PA and Standard Business Content Cubes for accounting reports on Cost-Center and Profit Center.
• Developed InfoCube, MultiCube, ODSs, define DataSource and load R/3 data using extractors for Sales Order, Sales document, Billing, Delivery, Materials, Purchasing, Orders, Customers, General Ledger, Account Receivable, CCA plan and PCA plan.
• Involved in developing the Extractor program to get relevant data from various R/3 tables. (VBAK, VBAP, VBEP, LIKP, LIPS, BSEG, BSIS, BSAD, COEP, EKKO, EKPO etc.)
• Scheduled and monitored Daily/Weekly/Monthly data loads to InfoCubes and ODS-objects through process chains. Involved in setting up on Full and Delta Loads for SD Business Content and Custom Data.
• Worked wif trouble-shooting for data integrity problems, monitor load performance, tuning and optimization.
• Widespread use of ABAP/4 programming skills for numerous enhancements, Start routines, Update rules and Transfer rules.
• Created Multi-Providers to extract data from Multiple Data Targets for providing information to the queries for Sales/Billing Reporting.
• Identified the tables for generating the custom data sources that are to be utilized as InfoSource on BW for custom reporting. This process involved identifying the R/3 reports and underlying tables to implement the same reports in BW.
• Developed custom queries for user specifications. Created variables and associated user exits to assign the default values such as sales organization and purchase organization.
• Modified the User exit programs to accommodate the additional fields in the extract structure of the DataSource wif ABAP.
• Advised delta loading and ODS Loading process. Performed Delta repairs whenever required.
• Provided the knowledge transfer to the client team. Provided support in pre-production and production mode.
• Managed and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Involved in Pre-Validation testing.

Environment: SAP R/3 4.6C, ABAP/4,SD,FI/CO Modules.

Confidential, MN

SAP BW & ABAP Consultant

Responsibilities:

• As part of team, involved in Designing Dashboard using Visual Composer tool.
• Resolved various BW query performance and load performance to support the implementation.
• Designed and configured Process Chains for entire BI load Process and implemented email notification of load progress.
• Actively involved in preparing user and technical documentations.
• Analyzed the production support issues and searched the OSS notes to fix the issues.
• Gatheird and Mapped Sales Order Item attributes for BW reporting purpose.
• Designed and developed/created InfoCubes, DSOs and DTPs.
• Activated necessary Standard Business Contents and used the required standard queries
• Enhanced the Extractors to suit the requirements
• Created DTP and Transformation for mapping the fields from source to target fields.
• Defined target currency in info objects and determine Target Currency for currency conversion from InfoObject
• Worked on Multi Currency Translation in BEx
• Loaded Master and Transaction Data. Handled full, init and Delta loading.
• Worked wif BEx Tool to design and develop Queries and Reports.
• Developed highly customized analytical reports wif Business Explorer (BEx) Analyzer. Created and used Structures, Variables, Calculated Key figures, and Restricted Key figures, RRI, Exceptions, Conditions and Filters for user specific outcome.
• Developed custom queries for user specifications. Created variables and associated user exits to assign the default values such as sales organization and purchase organization.
• Modified the User exit programs to accommodate the additional fields in the extract structure of the Data Source wif ABAP.

Environment: SAP R/3 4.0b, ABAP/4, FI,SD and Oracle.

Confidential

JAVA Developer

Responsibilities:

• Responsible for preparing HLD, DLD and development of Customer and product management modules using struts framework.
• Redesign the custom stored procedures used by legacy application.
• Responsible identifying and preparing solution test document.