OBJECTIVE:

Looking for an opportunity as SAP BW/BI Consultant in FI, SD,MM,CRM,& BOBJ

• More than Five years’ experience in SAP BW/BI. Extracting master data from different tables, Data integration, Data Analysis, Data warehouse, ETL, ERP SAP R/3, Business intelligence applications/Reports using R/3 ECC 5/6, SAP BW3.5/BI7.0 & ABAP. Involved in full life cycle BW projects followed ASAP methodology, proficient in data modeling. And BW/BI extended star schema models to build InfoObjects, InfoCubes, InfoPackages, DSO/ODS. Expertise includes financial, Sales and Distribution, administrative system and manufacturing sector applications.
• Data Modeling Extensive involvement in gap analysis. Design and maintenance of InfoCubes, MulitProviders, Remote Cubes and ODS Objects in consistent with Extended Star schema and efficient Multi-dimensional data modeling techniques.
• Data Extraction Created and customized InfoSources/Datasources, Transfer Structures, Extract Structures, Update Rules, Transformations, DTP and Start Routines. Scheduled and monitored data uploads into InfoProviders such as InfoObjects, ODS, InfoCubes as well as PSA. Automated data extraction process using Process Chains utility
• Proficient in Data Extraction from SAP R/3 (CRM,FI, MM, SD, and PS), flat files and BW using extraction structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors
• Reporting Building custom queries using Restricted and Calculated KeyFigures, Variables, Structures and Exceptions. Extensive experience with Query Builder, BEx Analyzer
• Development and modifications to datasources, infosources, ODS, master data and infocubes
• Creation of infopackages and perform data loading as well as monitoring and fixing of data loads
• Enhancing/customizing the InfoCubes/DSOs/InfoObjects/BEx Queries;
• Overall designing of BW InfoCubes (Basic Cubes, Multi-cubes, Remote cubes, and Aggregates), BW ODS Objects, BW Datamarts and BW Process Models;
• Designed, developed and unit tested ETL processes and Data Warehouse structures;
• Supported and tested all developed programs and solutions
• Drove business requirements down to the last detail and interpreted requirements to ABAP consultants.
• Very good knowledge on Cross Functional Customization required for interfacing with FICO and MM.
• Very comfortable working with ABAP consultants on different development and enhancement objects like user-exits, routines, custom reports.
• Excellent communication skills and ability to lead client-facing blueprint workshops and follow-up for approvals from process owners.
• Willing and quick learner with the ability to lead teams in disparate environments across the globe.

EDUCATION:

Bachelor’s Degree in Engineering

• Training in SAP BI/BW 3.5 & 7.0, SAP SD 4.6 & CRM 4.0, BOBJ 3.5/4.0

Necc Technologies Inc. Toronto, ON

Confidential,System Analyst
September 2011 – Present

• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Created Universes by defining connections and retrieving data from database.
• Used Built-in and External strategies for creating components of a universe.
• Created Aliases and Contexts for solving the Join Problems in Business Objects.
• Created New Classes and User Objects in designing the universes.
• Exported the universes to the Repository to make resources available to the users.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Created and modified the WEBi Reports for various financial groups using the Universe as a main data provider.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet,
• Monitored BW data loads for Daily/Weekly/Monthly and resolution for the load failures, performances tuning of data load for critical BW applications
• Scheduled Process chains for automating the Delta Loads, Aggregate Rollups and Change Runs,
• Installed Data sources 0FIGL_7, 0FIGL_4 under Finance (General Ledger Accounting) Module.
• Created Multiprovider on 0FIGL_C02 (Cost of Sales Ledger: Transaction Figures) and 0CCA_O09 (Actual - Line Items) to meet the reporting requirements.
• Developed BEx Reports like Balance sheet report, Profit and Loss report in financial applications using BEx Analyzer.
• Modified the existing Cost center Reports like Costs and Allocations Comparison Report, Costs and Allocations Trend Report etc. as per the users requirement

Confidential,SAP Functional Consultant
October 2009 – March 2011

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes.
• Created several Universes using Designer according to the Requirement.
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Exported the universe to the Repository to make resources available to the users.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins
• Documented all the changes made to the Universes and Reports for future references.
• 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
• Generated reports using BEX (Business Explorer) with variables, exceptions restricted key figures and calculated key figures. Used RRI feature to jump between the queries to analyze the data
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Used Alerts to draw attention to a particular block of data by highlighting it.
• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
• Used features such as functions, running totals, and parameters, conditional formats to develop highly formatted Crystal Reports.
• Enhancing/customizing the InfoCubes/DSOs/InfoObjects/BEx Queries;
• The overall design of BW InfoCubes (Basic Cubes, Multi-cubes, Remote cubes, and Aggregates), BW ODS Objects, BW Datamarts and BW Process Models;
• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications
• Worked extensively on standard and custom defined LO extractors. Used LO extract structures and data sources in sales material management to facilitate the data extraction to BW
• Used ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to Update Key Figures in the Info Cubes
• Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates and Involved in Production Support
• Heavy Technical concentration in designing ETL process like InfoPackages, InfoSources, Update Rules, Reports for Sales and Distribution
• Creating and monitoring all transport activities in both Source and BW systems required to install the application in development, QA and production
• Developing prototypes of ETL processes and Data Warehouse structures;
• Working closely with the Technical Lead to define/evolve the data storage architecture and data transformation architecture sections of the Solution Architecture

Confidential,SAP Functional Analyst
January 2007 – June 2009

• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications
• Worked extensively on standard and custom defined LO extractors. Used LO extract structures and data sources in sales material management to facilitate the data extraction to BW
• Used ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to Update Key Figures in the Info Cubes
• Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates and Involved in Production Support
• Worked on sales order info sources 2LIS_11_VAHDR, 2LIS_11_VAITM and also on sales delivery info sources 2LIS_12_VCHDR and 2LIS_12_VCITM
• Enhancing/customizing the InfoCubes/DSOs/InfoObjects/BEx Queries;
• The overall design of BW InfoCubes (Basic Cubes, Multi-cubes, Remote cubes, and Aggregates), BW ODS Objects, BW Datamarts and BW Process Models;
• Configured SAP SD module requirements in the areas of:
• Sales Order Types, Item Categories, Schedule Lines, Copying Control, Number Ranges
• Pricing and its interface with Accounts Receivable, Taxes and Account Determination
• Material Determination, Sales BOM, Output Determination, Foreign Trade, Credit Management.
• Integrating SAP- SD touch points with different R/3 modules like WM and MM.
• Shipping process (deliveries, picking, packing), Delivery document types.

Confidential,SAP SD Functional Consultant
March 2006 – November 2006

• Configured the SD module with IMG to suit the clients business requirements
• Conducted manual and automated testing of applications in n-tier and web environments
• Provided production support in the role of SD functional consultant to almost 2000 users globally
• Provided custom solutions to SD issues on a daily basis
• Actively involved in different projects to enhance the functionality of existing 4.6c R/3 environment
• Worked extensively on pricing procedures and pricing conditions
• Configured SD functionality of variant bill of materials and variant price
• Involved in the set-up of the foreign trade functionality for export and import requirements
• Running and Analyzing Customer Master Tables
• Provide daily support for issues arising from Sales and Distribution transactions
• Representing Sales and Marketing on SAP and reporting related projects
• Ensured new staff or changes requiring new SAP authorizations

Confidential,SAP SD Functional Consultant
August 2004 – December 2005

• Configured sales areas and business areas and assigned plants to sales organizations and company code
• Configured sales document types and copy controls as per the needs of the subsequent processes
• Automated the system for efficient customer order management to a great extent by assigning and processing requisitions based on Info Records and extensive use of scheduling agreements for all regular materials reducing the number of transactions
• Analyzed the pricing strategies and customizing pricing procedures for products
• Configured Special sales order type \'Rush Orders\' and working closely with account receivables
• Created outline agreements that included value contract and quantity contract for different applicators
• Configured system for master data details screens for maintaining dealer\'s details and product data
• Setting up rebate agreements for dealer
• Created work flow for accounts receivable when sales order is put on credit hold
• Customized material determination procedures
• Customized the revenue account determination by identifying G/L accounts and using FI integration
• Configured delivery documents, billing documents, and shipping documents
• Prepared sales reports on product inventory levels, sales level at dealer level, and sales by product type

Confidential,SAP SD Functional Consultant
June 2003 – May 2004

• Key player in mapping business processes
• Developed, tested and implemented developments according to the requirements
• Created material types and assigned to the industry
• Configuration of Pricing procedure determination, Condition tables, Condition type- Definition and control, Access sequences, Condition records, Customer pricing procedure and document pricing procedure
• Billing type definition and control, Rebate processing, and Credit Management
• Variant configuration according to the business scenarios for order configuration
• Configured Sales, Delivery, Shipping, Billing Documents and Consignment Process
• Configured the system for different processes in sales order processing, which includes Consignment stock, Rush Order and Cash Sale to meet specific requirement in business sales activity
• Created item proposal for different material combinations that were frequently ordered and delivered in certain quantities

TECHNICAL SKILLS
Software: SAP R/3 - 4.7/4.6C, SAP CRM 4.0, ABAP, VB Script, JavaScript,
Tools: Quick Test Pro 9.2, Win Runner, HP Quality Center,
Operating Systems: MS-DOS, Windows’98/2000/NT/XP, UNIX, MVS, Mac OS 9/X.
Databases: DB2, RDBMS, Oracle, AS 400, MS SQL server.
Utilities: VSAM, JCL, FILE-AID, TSO, MS Office, MS-Project, VSTS.
Languages: C, C++, ASP, PL/SQL, Java Script, SQL, HTML, XML and VB Script
Languages: Oracle9i Visual Basic 6.0, C++, HTML, and XML