Summary

Having overall of 7+years of experience that includes 5+years of SAPBW Consultant and 1+years of experience as junior executive trainee in EDP.
Worked with different industries sector like Pharma, Utilities, Telecom and Electronics.
Good Cross Functional Knowledge of PP, PM, SD, MM, FI-CO, PS, Modules.
Knowledge of production support in SAP BW.
Good Knowledge on SAP APO DP Module.

Possesses excellent Analytical programming and communication skills, Strong commitment, dedication and efficient problem solving.

Summary :
Involved in implementation of 3 full life cycle BW projects and provided key services like data modeling, design support, data management.
Experienced in Business Information Warehouse components, Info Objects, Info Providers, Info Sources, Update Rules, Transfer Rules and Info Packages using BW Administrative Workbench like AWB.
Involved in BW upgrade projects like BW 3.5 to Net weaver 2004s.
Experienced in Net weaver 2004s Business Information components, Info Objects, Info Providers, Info Sources, transformations, DTP, DSO, Start and end routine using Data Warehouse Workbench.
Involved in different testing like string, FUT, UAT and Recursive.
Experienced in designing, creating and maintaining ODS Objects, Info Cubes and Multi-Providers.

experience in building Info Cubes for SD, MM, PP and FI application components.
Experienced in writing Update routines, Transfer routines, User Exits using ABAP.
worked with BW enhancements as per client requirements.
worked with R/3 and Flat File loading for Transactional Data, Master Data and Attributes.
Developed Test cases according to test specification and executed test cases.
Conducted Testing on reports which are extracted from SAP R/3 source systems.

Expert level skills in extracting data from SAP R/3 systems using different extract structures like LO Cockpit, Generic extractors and good knowledge in CO-PA.
Experienced in using Delta update mechanisms for uploading the data to BW from R/3 in specific intervals. Experienced in Job Scheduling and process chains.

experience in creating custom Data Sources to extract data from OLTP systems to BW through Persistent Staging Area like PSA and done Monitoring and Error Handling in PSA.

Good experience in using open hub services
Comprehensive knowledge on data extraction from SAP R/3 like FI-CO, MM, SD, PP, My SAP CRM, SEM-BPS, SCM- APO using different Extractors like LO Cockpit, CO-PA and FI-SL.
Performance Tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of Info Cubes and use of Statistics for the same.

experience in Report Generation - Worked in BEx Analyzer in building Queries and saving in Workbooks like Excel work sheets and created Custom Queries using Conditions, Query Filters, Exceptions, Variables, Structures, Calculated Key Figures, Restricted Key Figures and Hierarchies. Experienced with BEx Query Design and formatting in RRI.

Extensive experience in reporting using business Explorer like BEX Analyzer, query designer and Web Application Designer like WAD.
Experienced in Job Scheduling and process chains.

experience on production support activities.
Conducting Functional, Regression testing.

R/3 Ecc 6.0, 4.6x, 4.7 x
Languages : C, C++, SQL, ABAP/4.
Application Software : Oracle 8/9i
Technologies : Client-Server and Web-Based
Operating System : Windows 95/98/2000, Windows XP
Data Warehousing : SAPBW
Web Related : HTML
Tools and Packages : MS-Office


Employment

2005 -  2005
SAPBW Consultant

Education

Miscellaneous

Engagement Overview

Client : Wyeth pharmaceuticals, PA
Duration : March2007 - Till date
Role : SAP BI Consultant

Responsibilities :
Interacting with functional consultants and business experts for designing data models and data sources.
Migrated the 3x data sources to Netweaver 2004s.
Created Multi cube based on Sales and Distribution.
Developed flexible Queries using filters, variables, navigational attributes in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
Completed the feasibility study of the current business process functional specifications and identified the relevant areas for customizations.
Used DSO to stage data before transferring DSO contents into Info cube.

Generated and maintained aggregates and rollup activities as part of the Info cube management.

Involved in maintenance and support activities for solving issues raised by users.
Created Process Chains to automate the loading Process.

Environment : SAP ECC 6.0, SAP 2004S like BI 7.0, BEx Analyzer, Windows 2000/NT.

Client : Consumers Energy, MI
Duration : Oct 2005 - Feb2007
Role : SAP BI Consultant

Client Description :
Consumers Energy is a public utility company that provides natural gas and electricity to more than 6 million of Michigan s 10 million residents and serves customers in all 68 of the state s Lower Peninsula counties. CMS Energy s primary businesses are independent power production and natural gas transmission. The project is a Big Bang implementation to replace the legacy systems driven by mainframes.

Responsibilities :
As a part of implementation team, involved in gathering user requirements and data modeling using ERM, Star Schema Concepts.
Installed relevant SAP business content.
Migrated the 3x data sources to Netweaver 2004s
Designed and customized data models and Info Cubes for FICA, Billing, Device management, Back Office.
Created different queries on FICA, Billing, Device management, Back Office area.
Designed and customized data models and Info Cubes for Customer Service Plant maintenance.
Used DSO to stage data before transferring DSO contents to Info Cube.
Worked on activating the standard business content info cube Project systems and Investment management.
Worked on different functional module for business requirement.
Worked on Gas emergency and Gas leak reports.
Worked on Meter reading and Meter testing reports.
Responsible for design, development and extraction of data from R/3 Source System and Flat Files to the BW system and created various Info package to enable data transfer.
Extracted consolidated data from different sap and non sap systems as project required.
Scheduled info packages in order to load data from R/3 to BW.
Conducted Testing on reports which are extracted from SAP R/3 source systems.
Created Process Chains to automate the loading Process.

Environment : SAP ECC 6.0, SAP 2004S like BI 7.0, BEx Analyzer, Windows 2000/NT.

Client Description :
Ericsson wants to upgrade its SAP Business Intelligence unit to the latest version in this case to BI 7.0 which is part of the new Net Weaver platform. The main reason in doing this is that it makes the data in BW more accessible so that reports is made available to the top-level management in a more convenient way. My significant amount of time in the project is spent in doing the upgrade from 3.5 to SAP BW 7.0, all the usual BW work like extraction, transformation and loading. Apart from this I am also partly responsible for testing the quality of logistics and finance related data after upgrade.

Responsibilities :
Generated and maintained aggregates and rollup activities as part of the Info cube management.
Tested Delta mechanism for LO extractors as of BI 7.0

Testing quality of data in cubes and other targets.
Coordinating with SAP for solving different bugs.

Comparing the load timing for different loads as performance activities.
Created process chains as per user requirement.
Coordinating with basis people for applying patches.
Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
Involved in repair loads for sales and finance areas.

Involved in maintenance and support activities for solving issues raised by users.

Environment : SAP R/3 4.7, SAP BW BI 7.0, BEx Analyzer, Windows 2000/NT.

Client : Ericsson Dallas, TX
Duration : Oct 2004 - April2005
Role : SAPBW Consultant

Client Description :
Ericsson is the world-leading supplier of telecommunication equipments and related services to mobile and fixed network operators globally. In 2005 it was decided to replace the old BW 3.0b solution with the BW 3.5 solution to be build up using an Enterprise Warehouse methodology according to a set of BW Guidelines. The replacement of the BW 3.5 solution is covering all Ericsson process areas handled in BW. The project was initiated to replace the current BW 3.0b solution for Ericsson Supply and fulfilling new Ericsson Supply demands.

Responsibilities

As a part of implementation team, involved in gathering user requirements and data modeling using ERM, Star Schema Concepts.
Installed relevant SAP business content.
Interacting with functional consultants and business experts for designing data models and data sources.
Completed the feasibility study of the current business process functional specifications and identified the relevant areas for customizations.
Designed and customized data models and Info Cubes for Sales order lead time, Delivery precision Shipment, Handling unit.
Used ODS to stage data before transferring ODS contents to Info Cube.
Worked on activating the standard business content info cube 0IC_C03 Material movement and 0PUR_C01 Purchasing data.
Created Multi cube based on Sales order and Billing cubes.
Responsible for design, development and extraction of data from R/3 Source System and Flat Files to the BW system and created various Info package to enable data transfer
Worked on creation of Aggregates and hierarchies for the Info Cubes to access data in an efficient and ordered level.
Extracted consolidated data from different sap and non sap systems as project required.
Mapped characteristics, key figures required for APO, developed info cubes for historical data and transaction data.
Configured planning area with different cubes from different sources.
Configuring the BW system, getting the transaction data from various systems into BW and moving this data into APO as per the DP key requirements.
Mapped data extraction from planning area to BW.
Developed various reports for forecast comparison.
Integration between APO and R/3 for Vendor-Managed Inventory process.
Created Info sets Queries and workbooks ; used variables, calculated key figures, restricted key figures, structures, conditions, exceptions and reporting agents. Resolved, implemented BW Query faults and change requests.

Used Web Application Designer to develop web reports for Supply Chain operational reference model like SCOR.

Used WAD to develop a statistical report which shows loading status report.
Created Process Chains to automate the loading Process.
Analyzing the early watch report and solving performance related issues.
Monitoring daily or weekly/monthly loads and solving loading issues.
Involved in weekly maintenance issues as part of performance team.
Worked extensively on different issues for getting root cause of problem and solved some issues writing ABAP program.
Solving severity issues raised by users.
Training end-users on utilizing, developing and creating BW Queries.
Environment : SAP R/3 4.7, SAP BW 3.5, APO 3.1, BEx Analyzer, Windows 2000/NT.

Client : Shell Lubricants Hudson, TX
Duration : June2003 - Sept 2004
Role : SAPBW Consultant

Client Description :
Shell Lubricants are 1 of the global leaders in the finished lubricants industry, manufacturing and marketing a range of top quality lubricant products. The project revolved around developing a business module on SAP BW for the Material and sales data warehousing enabling the business partners and decision makers of the company to take strategic decisions. As a functional BW consultant the responsibilities were to cater ready and efficient access of the Material and Sales logistics data through SAP Business Information Warehousing like BW.
Responsibilities : Participated in the full lifecycle of the project and performed analysis, design, development and implementation of standard/ customized Info Cubes and ODS Objects for FI and CO Modules.
worked on activating the standard delivered business content of LIS in the form of Info Objects, Info Sources, Info Cubes, ODS and customizing it by creating new business content
Worked on configuration of BW by identifying the needs of customer, modeling the data, defining the data sources at OLTP and reporting the data by using Administrator Workbench business explorer.

Created new data targets ie Info Cubes and ODS by creating interfaces at BW and SAP R/3 level.

Created Info Sources, Info Cubes, Aggregates, ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party customers, material, vendor line items and creating ledgers.
Involved in enhancements as per user requirements.
Involved in writing update routines, transfer routines, user exits using ABAP.
Responsibilities included Analysis, Customization and coding for various programs in SD and MM modules.
Created the Process Chain Process and Sub Sequent Event for sending the Email at the all stages for the data Upload.
Worked on flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW.
Transporting requests from development system to various systems.
Extracted data from FI, SD, MM, CO-PA and PP modules of SAP R/3 and from flat files into SAP BW system using Generic, Business Content and LO Extractors.
Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
Developed reports on Info Cubes/ODS objects using BEx Analyzer/Explorer to facilitate summarization of data.
Created a statistical report which shows when last data is loaded to cubes.
Reconciliation of COPA data with R/3 system.
Analyzing root cause of the problem and try to find permanent fix.
Involved with sap basis team for BW security.
Performance Tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of Info Cubes and use of Statistics for the same.

Environment : SAP R/3 4.6C, SAP BW BW 3.0B, BEx Analyzer, Windows 2000/NT.

Client : NEWSPAPER NATIONAL NETWORK LP, NY
Duration : Oct2002 - May2003
Role : SAPBW Consultant

Client Description : Involved in complete life cycle Implementation of BW 3.0B which includes Data-Modeling, Data Extraction and Reporting.
Modified Update rules, transfer rules, update routines and transfer routines as per client requirements
Developed multi providers on various objects.
Involved in using performance enhancements features like Cube Partitioning, Indexing, maintaining aggregates and compression.

Uploaded data to different targets from different sources.
Transfer routine was created to convert invalid character for transfer rules in Info Source.
Designed and developed Quires using filters, restrictions, exceptions, conditions, variables and formulae.
Working knowledge in reporting agent.
Data extraction from Oracle tables and views like Database connect.
Handled data modeling of various FI Cubes like CO-PA, AP, AR, GL and ODS s

Environment : SAP BW BW 3.0B, ORACLE 8.0 BEx Analyzer, Windows 2000/NT.

Client : Singareni Collieries, India
Duration : July2001 - Sept2003
Role : Junior Executive Trainee in EDP Dept

Client Description :
The main Business of Singareni Collieries Company Limited like SCCL is mine Underground Non-Coking coal and supplies the same to Thermal Power Stations, Cements, Fertilizers, Paper, Sugar, Textiles, Tea, Tobacco curing and other industries located in South India. SCCL is operating 67 coal producing mines in 4 Districts-Khammam, Warangal, Karimnagar and Adilabad.

Responsibilities :
Maintained Coal production Data of Singareni Colleries in Kothagudem Region.
Prepared updated reports of weekly production, monthly production according to the requirement.

Maintained Employee s personal information and enhanced the changes or updates according to time.
Generated Companies Financial Reports like Plan Expenditure, cost of production, sale value, profit after tax according to the data given by company auditors.