PROFESSIONAL SUMMARY:

• 10 years of SAP Experience as BI Technical Consultant. 6 years of SAP Experience as SAP Business Objects Developer. Experienced in Migrate the 3x data source to BI 7.0.
• Experienced in generating reports using Business objects BO . Expertise in generating reports from BW OLAP cubes using BOXI R/3. Expertise in working on SAP integrations with BO environment.
• Experienced in creating designing Universes for BO reporting.
• 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.
• Experienced in Business Information Warehouse components, Info Objects, Info Providers, Info Sources, Update Rules, Transfer Rules, and Info Packages using BW Administrative Workbench AWB .
• Experienced in designing, creating and maintaining ODS Objects, Info Cubes and Multi-Providers.
• Expertise in building Info Cubes for SD, MM, PP and FI application components.
• Experienced in writing lookups, Update routines, Transfer routines, User Exits using ABAP.
• Extensively worked with R/3 and Flat File loading for Transactional Data, Master Data and Attributes.
• Good experience in creating roles transport objects, requests.
• Expert level skills in extracting data from SAP R/3 systems using different extract structures like LIS, LO Cockpit, Generic extractors and good knowledge in CO-PA. Expert in working on projects using SDLC methods. 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.
• Expertise in creating custom Data Sources to extract data from OLTP systems to BW through Persistent Staging Area PSA and done Monitoring and Error Handling in PSA.
• Good experience in using Open hub services.
• Experienced with Layered Scalable Architecture LSA and organization of an EDW Enterprise Data Warehouse . Comprehensive knowledge on data extraction from SAP R/3 FI-CO, MM, SD, PP , My SAP CRM, SEM-BPS, SRM, SCM- APO using different Extractors such as 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.
• Experienced in creating best practice Development Standards for Business Warehouse project teams.
• Expertise in Report Generation - Worked in BEx Analyzer in building Queries and saving in Workbooks 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 BEX Analyzer, query designer, report designer and Web Application Designer WAD .
• Experienced in creating WEBI reports and creating universes using BOBJ Business Objects .
• Expertise on production support activities. Solid interpersonal, written and oral communication skills. Wide experience working closely with peers and clients to implement customer-specific project plans and coordinating projects with vendors, technicians and non-specialists. Solutions-oriented professional with ability to quickly learn and apply new knowledge. Proficient in Coordination with Business Users, Clients all stakeholders. Extensively worked with different version of BW like 2.x, 3.x and BI 7.0 Netweaver 2004s . Worked on Business Objects 3.0, 3.1, 4.0 WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius .

• Created Universes on BW Infocubes and Queries and generated WEBI reports. Worked on Business Objects WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius . Worked on Live office QAAWS for creating connections to design dashboards. Worked on UDT Universe Design Tool IDT Information Design Tool to design Webi reports. Worked on dimensions, measure objects, hierarchies in WEBI.

• Created security on the universes and worked on Implementing Universe Life Cycle Mgmt.
• Worked on Alerts, Drill down, Dynamic Visibility in BOBJ reports. Worked on the elimination of loops and traps occurred in the Universe Design. Created Webi reports on multiple Universes.

Technical Skills:

• Operating Systems : Windows NT/95/98/2000, UNIX
• Reporting : SAP Business Objects BO 4.0/3.1/3.0
• Cross Applications : ALE, and IDOCs.
• Databases : Oracle 7.x/8.0, MS-Access.
• Languages : ABAP/4, C, VB, SQL.
• ERP : SAP R/3 ECC 6.0, 4.6x, and 4.7x.
• Data Warehouse : SAP BW BI 7.3, 3.5, 3.1C 3.0B and 2.1C.
• Tools Packages : MS Office.

Professional Experience:

Confidential

Senior SAP BI/BO/BW/BOBJ Consultant

• Worked with project team of 30 PMO's, functional, technical, ABAPers, testers, BA's .
• As a part of implementation BO/BW team of two Architect myself , analyzed and designed a BI model for complete FI, SRM and Procurement implementation project.
• Experience on BO report and universe Developer.
• Experience in Business Objects WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius .
• The Miami-Dade County Public Schools, LAUSD Los Angeles Unified School District enrolls more than 640,000 students in kindergarten through 12th grade, at over 900 schools, and 187 public charter schools. The boundaries spread over 720 square miles and include the mega-city of Los Angeles and Miami as well as all or parts of 31 smaller municipalities plus several unincorporated sections of Miami and California. It's a 20 Million project implementation done by Phoenix Business Consulting.
• Analyzing the existing BI system which has HR module implemented and prepared the implementation plan for the new requirements. Installed business content for implementing the FI Finance and SRM modules. Installed Business content AA Asset Accounting , AP Accounts Payable , AR Accounts Receivable , FM Funds Management , GL General Ledger Accounting , GM Grants Management and delivered standard reports which are selected for the go-live.
• Installed Business Content BE Bidding Engine , PC Purchasing Contracts , SC Shopping Cart , EP E-procurement , TV Travel Management , MM Materials/Inventory Control and delivered standard reports.
• Identifying the existing infoobjects and creating the new Infoobjects that are necessary for the project.
• Creating the mapping documents for the objects from source to data targets.
• Creating and loading Master data objects texts. Worked on configuration of setup tables for the LO Cockpits. Worked on system settings SPRO , OMSL settings for Material and Product data loads.
• Creating Multiproviders, Infocubes, DSO's, Transformations, Infopackages and DTP's for custom data models. Worked on DSO's and Infocubes data loads and monitoring and fixing data load errors.
• Created Master data, Hierarchies, and transactional Process chains and Meta Chains.
• Worked on RICEFW Reports, Interfaces, Conversions, Extensions, Forms and Workflow objects and delivered which were assigned. Worked on Variables, Display navigational Attributes.
• Worked on Restricted Keyfigures and calculated keyfigures.
• Reviewing the model changes, Performance monitored data loads, tuned critical web reports and Portal reports. Written Lookups, Start routines, End routines, Update routines, Transfer routines, User Exits using ABAP. Enhanced the standard extractors using BADI's.
• Worked on New GL's PSGLFLEXA, PSGLFLEXT tables and 0FI GL 14, 0FI GL 10 datasources.
• Transporting and monitoring developed objects across the landscape. Creating Custom Bex queries and reports to be used by the business users. Converted the standard data models to Z Custom data models.
• Fixed the defects which were logged by business users in HPQC tool. Worked on building BW data models for Legacy systems data migration.
• Created various custom reports for the client requirements: CAFR reports Comprehensive Annual Financial Report , Pooled cash reconciliation by fund account report, Revenue and cash Receipts Report by fund and Account report, AP warrants report, Budget Availability report, Contract Summary detail report, Vendor master report, School Accountability Report Card Report.
• Created Universes on BW Infocubes and Queries and generated WEBI reports. Worked on Business Objects WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius . Worked on Live office for creating connections to design dashboards. Worked on IDT Information Design Tool to design Webi reports.
• Worked on dimensions, measure objects, hierarchies. Created security on the universes and worked on Implementing Universe Life Cycle Mgmt.

Environment: SAP ECC 6.0, SAP 2004S BI 7.3 BEx Analyzer, BO 4.0, Windows 7.

Confidential

Senior SAP BI/BO/BW/BOBJ Consultant

• As a part of implementation team analyzed and designed a BI model for Vistex implementation project.
• The Brown-Forman Corporation is one of the largest American-owned companies in the spirits and wine business.
• Analyzing the existing system based on the user requirements. Identifying the existing infoobjects and creating the new Infoobjects that are necessary for the project. Creating the mapping documents for the objects from source to data targets. Creating and loading Master data objects texts.
• Installed Business content for Vistex datasources. Worked on configuration of setup tables for the Vistex datasources. Creating Infocubes, DSO's, Transformations, Infopackages and DTP's.
• Worked on DSO's and Infocubes data loads and monitoring and fixing data load errors. Worked with Data Store Object types DSO and Open Hub Destinations. Worked on Display navigational Attributes.
• Reviewing the model changes, Performance monitored, tuned critical web reports. Written Update routines, Transfer routines, User Exits using ABAP. Transporting and monitoring developed objects across the landscape. Creating Process chains for automating of data loads and monitoring.
• Creating Bex queries and reports to be used by the business users. Created WEBI reports for OLAP cubes of BW. Designed Universes for report generation in BO. Worked on Business Objects WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius . Created Universes on BW Infocubes and Queries and generated WEBI reports. Worked on Live office for creating connections to design dashboards.
• Worked on IDT Information Design Tool to design Webi reports. Worked on dimensions, measure objects, hierarchies. Created security on the universes and worked on Implementing Universe Life Cycle Mgmt.

Environment: SAP ECC 6.0, SAP 2004S BI 7.0 BEx Analyzer, BO 4.0, Windows 7

Confidential

Sr SAP BI BOBJ Technical Consultant

• Forest has well-established franchises in the therapeutic areas of the central nervous and cardiovascular systems, and they are always exploring new product opportunities that address a range of health conditions.
• As a SAP BI Analyst gathered user requirements and analyzed the source system information.
• As a part of implementation team analyzed and designed a BI model for Marketing Intelligence national project. Gathered business requirements and prepared Business requirements, Solution Design documents.
• Worked with the BI team and helped in designing the data flow diagrams. Extracted flat file data from BI Application server to DSO's, Infocubes Master data objects. Designed and extracted data to NDTI, NSP, NPA, IPS Audits. Created Infopackages, DTP's, and Transformations to load the data from Flat files to BI system. Checked the program for file validations and quality checks designed by ABAP.
• Written Update routines, Transfer routines, User Exits using ABAP. Extracted data from Oracle database using DB Connect. Worked with database team to guide in creating tables and view specifications.
• Worked on the design of architecture and done some modifications for better reporting.
• Made some changes to existing design for reducing the load on processes in architecture.
• Worked with Data Store Object types DSO and Open Hub Destinations. Worked on Display navigational Attributes. Created WEBI Crystal reports for OLAP cubes of BW.
• Designed Universes for report generation in BO. Transported objects and checked the transport requests.
• Investigating the existing design and suggesting the new model changes to achieve the reporting requirements. Reviewing the model changes, Performance monitored, tuned critical web reports.
• Designing the new reporting queries in SAP BEx query designer and Analyzer.
• Created and modified datasources for the views of different systems. DSO to stage data before transferring DSO contents to Info Cube. Worked with BI Objects including transformations, DTP's.
• Created Process Chains to automate the loading Process. Creating the Transport requests to make the changes move through the client landscape. Working with the SAP Basis to make the transports move through various environments. Executing the reports in Quality environment and move the reports to Production. Worked on Business Objects WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius .
• Created Universes on BW Infocubes and Queries and generated WEBI reports. Worked on dimensions, measure objects, hierarchies. Created security on the universes and worked on Implementing Universe Life Cycle Mgmt.

Environment: SAP ECC 6.0, SAP 2004S BI 7.0 BEx Analyzer, BO 3.1, Windows 7.

Confidential

SAP BI BOBJ Analyst

• Confidential has an extensive understanding of technology and unique, industry-specific knowledge gained from developing custom output solutions for thousands of organizations.
• As a SAP BI Analyst gathered user requirements and analyzed the source system information.
• Worked with database team to guide in creating tables and view specifications. Worked on the design of architecture and done some modifications for better reporting. Made some changes to existing design for reducing the load on processes in architecture. Helped in analyzing reports using Dashboards.
• Worked with new Data Store Object types DSO and Open Hub Destinations. Worked on Display navigational Attributes. Played an active part in generating the database setup schema.
• Installed relevant SAP business content BCT . Transported objects and checked the transport requests.
• Investigating the existing design and suggesting the new model changes to achieve the reporting requirements. Reviewing the model changes. Performance monitored, tuned critical web reports.
• Worked on APO DP data extraction, actual and forecast data. Designing the new reporting queries in SAP BEx query designer and Analyzer. Worked on all aspects of ETL processes and data sources from SAP ERP systems 4.6c, ECC6.0 . Helped in analyzing for redesigning of business applications.
• Created WEBI Crystal reports for OLAP cubes of BW. Designed Universes for report generation in BO.
• Created and modified datasources for the views of different systems. Performance monitored, tuned critical web reports. Used DSO to stage data before transferring DSO contents to Info Cube.
• Worked with BI Objects including transformations, DTP's. Created Process Chains to automate the loading Process. Created Invoice orders, Delivery status, Address book, Open/back order, Feed12, Sales demand, Stock overview, APO DP Forecast hardware reports.
• Testing the reports to check the reporting requirements are matched. Creating the Transport requests to make the changes move through the client landscape. Working with the SAP Basis to make the transports move through various environments. Executing the reports in Quality environment and move the reports to Production. Created Universes on BW Infocubes and Queries and generated WEBI reports.
• Worked on Business Objects WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius . Worked on dimensions, measure objects, hierarchies. Created security on the universes and worked on Implementing Universe Life Cycle Mgmt.

Environment: SAP ECC 6.0, SAP 2004S BI 7.0 BEx Analyzer, BO 3.1, Windows XP.

Confidential

BW BOBJ consultant

• Hewlett Packard is a technology company that operates in more than 170 countries around the world. As a BW consultant the responsibilities were to Analyze, design, extract the source information in order to generate the reports for different countries.
• As a BW consultant gathered user requirements and analyzed the source system information.
• Worked with database team to guide in creating tables and view specifications. Worked with new Data Store Object types DSO and Open Hub Destinations. Played an active part in generating the database setup schema. Installed relevant SAP business content BCT . Modified the relevant SRM datasources for data loads. Transported objects and checked the transport requests.
• Created and modified objects to maintain relation between systems. Migrated the 3x data sources to Netweaver 2004s. Extracted data from SCM datasources. Worked with Basis and support team in generating and assignment of logical systems. Written Update routines, transfer routines, User Exits using ABAP. Interacted with users for reporting requirements and collected the change requests.
• Actively participated with team members in different locations of different modules for synchronization of project. Performance monitored, tuned critical web reports.
• Worked with BI Objects including transformations, DTP's. Worked on all aspects of ETL processes and data sources from SAP ERP systems 4.6c, ECC6.0 . Helped in analyzing for redesigning of business applications. Created datasources for the views of different systems.
• Worked on different data sources under customer services and plant maintenance. Created Process Chains to automate the loading Process. Worked on Sales order and Purchase order reports.

• Worked on Main control and MEC Month end close reports. Created Multi cube based on Service order and Maintenance order. Extracted consolidated data from different SAP and non-SAP systems as project required. Created Universes on BW Infocubes and Queries and generated WEBI reports.

• Worked on Business Objects WEBI, DESKI, Crystal Reports, Dashboards/Xcelsius . Worked on dimensions, measure objects, hierarchies. Created security on the universes and worked on Implementing Universe Life Cycle Mgmt.

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

Confidential

SR BW consultant

• Nova's proprietary technology has the ability to efficiently process over 25 different feedstock sources with no refinery modification, including low cost feedstocks. Nova's technology replaces the inefficient batch process with a continuous process that allows economies of scale. As a BW consultant the responsibilities were to cater ready and efficient access of the customer service and maintenance order to SAP Business Information Warehousing BW .
• As a part of implementation team, involved in gathering user requirements and data modeling using ERM, Star Schema Concepts. Installed relevant SAP business content BCT .
• Migrated the 3x data sources to Netweaver 2004s. Interacting with functional consultants and business experts for designing data models and data sources. Worked with BI Objects including transformations, DTP's. Worked with new Data Store Object types DSO and Open Hub Destinations.
• Worked on different data sources under customer services and plant maintenance. Written Update routines, Transfer routines, User Exits using ABAP. Created different queries on FICA, Billing, Device management, Back Office area. 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.
• Extracted data from SCM datasources. 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.
• Extracted SD data to BW and passed on to APO DP. Created datasources for integrated planning to extract data. Developed extractors from SAP R/3 and APO. Worked on Gas emergency and Gas leak reports.
• Worked on Meter reading and Meter testing reports. Involved in different testing like string, FUT, UAT and Recursive. Created Process Chains to automate the loading Process.

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

Confidential

BW consultant

• 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 can be 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 extraction, transformation and loading . Apart from this I am also partly responsible for testing the quality of logistics and finance related data after upgrade.
• Tested Delta mechanism for LO extractors as of BI 7.0. Test iterations were done on various reports as a part of release activity. Testing quality of data in cubes and other targets.
• Worked with new Data Store Object types DSO and Open Hub Destinations. Coordinating with SAP for solving different bugs. Comparing the load timing for different loads as performance activities.
• Created process chains as per user requirement. Worked with BI Objects including transformations, DTP's.
• Written Update routines, Transfer routines, User Exits using ABAP. 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.

Confidential

BW Consultant

• Confidential is the world-leading supplier of telecommunication equipment's 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 as well as fulfilling new Ericsson Supply demands.
• As a part of implementation team, involved in gathering user requirements and data modeling using ERM, Star Schema Concepts. Installed relevant SAP business content.
• 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. Mapped characteristics, key figures required for APO, developed infocubes for historical data and transaction data. Developed various reports for forecast comparison.
• Integration between APO and R/3 for Vendor-Managed Inventory process.
• Created Infosets, 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 SCOR . Used WAD to develop a statistical report which shows loading status report.
• Created Process Chains to automate the loading Process. Monitoring daily /weekly/monthly loads and solving loading issues. Involved in weekly maintenance issues as part of performance team.
• 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.

Confidential

BW Consultant

• Confidential is among the largest and most reputed companies in India's private sector. Its reputation is based on strong customer orientation, the technological sophistication that characterizes its products and projects, and an impressive record of achievements across six decades. It has undergone a transition from stand-alone systems, towards integrating CAD, Enterprise Resource Planning SAP , project scheduling, and other systems.
• Involved in requirement analysis, modeling, Business Content Activation, Front-end design, data load scheduling. Involved in extraction, configuration and construction of Data targets.
• Created number of Reports with various filters, formulas and restrictions and variables
• Enhanced the Data Sources InfoSources for additional business requirements, used Customer Exit Variables, Formulas and Filters for the client business requirement. Involved in Query Definition, Query Presentation - BEx Analyzer and Scheduling of Daily, Weekly and Monthly Data Target loads using Process Chain and Event Controller.

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