Summary:

• Over 12 years of SAP BI/ BObj HANA experience in IT Industry, including all facets of Industry Software Engineering, Implementation and production support for SAP BI Projects for diversified Business Organizations, which includes more than 8 years of SAP BI 7.0 and SAP Business Object XI 4.0 BOBJ Dasboard Design, Information Design Tool/Business Layer using Xcelcius 2008/Dashboard Designer and SAP FI-CO, SD, MM, REFX.
• Sr SAP Business Object BOBJ Architect 9 years experience Technical Lead: 4 Full Life Cycle including Offshore/Onsite Design and Build: Working as Lead Business Object BOBJ Integration of BI- BO on Pharma/Oil/Finance/Technology projects which involve launching significant SAP projects Including Dashboard Builder and Xcelcius 2008 Dashboard Finance and Sales Reporting.
• Excellent expertize with Business objects reporting on SAP BI/HANA Finance /SQL databases with hand's on experience in teradata Database Server optimization for viewing and managing large amounts of Sales and Financial data. Performed Data base scalability analysis, implemented Database parallel processing, Excellent experience with BObj reporting on Teradata/SAP BI/HANA/SQL/Oracle Databases to develop high volume reporting using , Information Design Tool universes to maintain the integrity of sales and finance reported data.
• Extensive experience in assessing the company, business process, Developed Business Object BOBJ s Enterprise customers and partners Reporting using the SAP Enterprise Portal 7.0 to implement Business Object BOBJ s enterprise solution. Developed Business Object BOBJ s XIR4.0 reporting for Small and Medium Businesses customers using the Crystal Reports 2008 and Xcelcius Dashboard solutions. Publishing BO reports and Dashboards to Enterprise Netweaver 2004's Portal.
• Excellent experience in SAP BusinessObjects BOBJ Dashboards Xcelcius for real time applications, Voyager, BO Data Federator, BO Rapid Data Marts and worked with business analysts to explore online analytical processing OLAP data using BO 4.0 explorer designed specifically for financial reporting that delivers a full range of functions for the analysis of multidimensional data set. Full life cycle upgrade project from SAP BO 6.X to SAP BOXIR3.0 upgrade.
• Excellent SAP BI 7.0 Experience with Datasources, Extractor, DSO's Design and Build of extraction, COPA/FIGL/FIAR/AP/DisputeManagement/FI-AA Datasources Developed BO Universe and BO Infoview Portal for CO-PA extraction of data from for costing and Accounting based COPA Knowledge of new dimensional products like SAP COPA APO, COPA CRM, COPA SRM, COPA MDM.
• Sr. SAP BI Architect: 9 years Involved in implementation of 6 full life cycle BI projects Provided key services such as data modeling, design support, data management, global and cross-functional metadata definition support, as well as cross-functional technical design support for other SAP BI project teams related to FI/CO, SD, BI - Financial management and MM modules.
• Developed BODS 4.0/4.1 Data ServicesTransformed data in Open Hub with ABAP coding in the form of a custom Business Add-In BAdI and Info Cubes design, Performance and tuning, Strong on End-to-End BI Configurations and Customizations from Extraction, Staging, Loading, Transports Expertise in design of Info Cubes, ODS Objects, Customized Queries etc., Business Content Enhancements Report Designer Reporting.
• Deploy BI BEX Broadcasting and Web application designer dashboards which are compact displays that render Web content graphically and easily. SAP BI SRM Experience 1 Years : Supplier Relationship Management 5.0 and SAP Retail 5.0 Hands on experience in IDOC, User Exits, BI programs, ALV, BDC, LSMW.
• SAP-EPM 10 / BPC 7.5/ EPM BPC 10.0 experience includes creating Input Schedules, packages, functions, layouts, creating Transactional BPC InfoCubes and developing application sets for Financial Planning. Worked on BOBJ Integration with BPC 7.0/5.1

• 7 years of Lead Architect Experience in Data Services ETL,BO Explorer, Data Integrator, HANA Data Modeller and Data service Designer, Data service extraction DF SAP MtrlDim SAP Sales data flow for building a material and Customer dimension table consisting of the SAP Ecc or R/3 data flow to read data from an SAP ECC table and perform Sales and Finance operations that happen for sales Order and Customer Partner relationship in the SAP ECC

• Extensively worked as Lead Architect to define BODS Data services , BO Explorer, Ipad BO Mobile integration for reporting. Designed Data service Target table into which the material and Customer dimension data loads. experience with Invoice and Sales Order with Customer Master Data and Customer Sales Master data mappings to define transformations by using the Data Services Designer
• Worked in Data Services Management Console BODS 4.1 to transform load and Validate the Data from SAP using BO Explorer, Data Integrator, Data Federator .

TECHNICAL SKILLS:

• Web Technologies RDBMS
• DHTML, HTML, XML MS-SQL Server, Oracle
• Operating Systems Reporting Tools
• Windows XP, 2000, 98/95/NT, BEx and web reporting, MS-Excel,
• MS-DOS 6.X, UNIX, Reporting Tools Crystal Reports
• MS Access, Oracle, SQL Server
• Data bases
• ERP: ECC 5.0/6.0, SAP R/3 4.0B, 4.6B, 4.6C
• Business Intelligence BO XI 4.0/3.1/4.0, Net Weaver 2004s BI 7.0/7.3, BO Explorer and BO Mobile integration, SAP BI 7.3/7.0 3.5,3.1/4.0C, 3.0B, 2.1C, Business Object BOBJ s XI 4.0
• R3.0, Xcelcius 2008, Crystal reports 2008, BODS 4.0/4.1/ HANA 1.0 /BI HANA 7.3 700.14.01 Web Application Designer, Query Designer
• Functional Modules: MM, SD, PP, FI/CO, IM

Professional Experience:

Confidential

SAP BO/BI/HANA/ BODS Architect Lead

Role: BI /Business Objects / Xcelsius /HANA Architect

Responsibilities:

• Implementing Best Practices in Business Objects Universe Design, Web Intelligence Design, Content Management, Row-level Security setup, Custom Access Levels and User Management in a multi-server clustered environment.
• Experience with HANA Based Adobe Business Reporting solution and Analytics tool on HANA Mobile, Portals, On demand Services, Embedded Enterprise Apps etc. Performance Tuning of HANA Models with various data partitioning techniques
• Excellent experience with various Accelerators COPA, Finance, SOP and deployment of RDS Rapid Deployment Solution on HANA . Developed custom HANA based Application for Finance Ledger solution using ETL tools for HANA - SLT, DS, Sybase Replication Server and Planning Application Kit PAK on HANA.
• Experience in HANA based BI reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables, using system generating joins. Experience with HANA scripts while creating complex SQL views for custom based HANA applications for software licensing .
• In-depth knowledge in processing information objects such as previewing data of information objects, validating models, comparing versions of information objects, generating object documentation.
• Expertise in HANA Data modeling scenarios and activities of developing schemas, importing table definitions, adding connections. Setting preferences for modeler, HANA studio with overall experience in all the aspects of modeling in SAP HANA. Experience working with Revenue and CRM POS content HANA models, attributes and measures, hierarchies.
• with HANA- Finance full SDLC on SAP and non-SAP systems.
• Excellent hands-on experience of HANA security and user enhancement/ setup configuration.
• Installed, Upgraded and Configured SAP BW 7.3 with SAP HANA as the foundation system
• Installed and configure your SAP HANA landscape using SLT system Landscape Transformation and BO Data Services
• Enhanced and Developed HANA/BI COPA Data sources and extracted data using data services for Revenue, Sales and Channel Inventory Line Item, Payment History, Cost and Allocation and in sales HANA/BI Repository objects to include source systems such as PCM COPA Info-cubes, time characteristics and harmonized version. Developed custom data extraction via HANA for General Ledger Info cubes and Plan data Balance sheet and profit loss , actual and plan data for Profitability Analysis.
• Installed HANA on BW 7.30. Implemented new features on BW Workspaces of BW 7.30 on HANA for end users to combine Financial local data with corporate data under governance of IT. Used HANA with Analysis Office and developed the workflow of uploading local Financial data and performed Data Modelling in HANA. Enabled the direct connectivity to HANA by support of hierarchies and custom development of HANA End to end solution for customer POS and Inventory requirements for end customers
• Implementing Best Practices in SAP HANA Design, SLT for HANA Data Replication Design Content Management, Row-level Security setup, Custom Access Levels and User Management in a multi-sourced HANA based environment.
• Business Objects Lead consultant for XI 4.0 BOBJ Dasboard Design, Information Design Tool/Business Layer in Business Objects XI Architecture, Xcelsius /Dashboard Design for Financial Revenue /PCM , CAPEX/ Expense/ TPM Channel Sales and Channel Inventory Reporting, User Management, Configuration Management
• Managed and performed tasks related to BW 7.3 system upgrades and hot packs
• Understanding/implementation with SAP BW 7.3 and migration of BW 7.0 to BW 7.3
• Extensively involved in Data Modeling , Universe design and functional design for data services and Managing BO Servers, Repositories, Connections and Administrative tasks.
• Extensively worked on latest features in Business Objects XI 4.0 Information Design Tool/Business Layer using Xcelsius 2008/Dashboard Designer. Extensively worked on development and scheduling of the Business Objects reports BO Mobile and BO Explorer reporting experience
• Xcelsius integration with BPC 10 for Financial Consolidation dashboard and: Income Statement Report, Balance Sheet Report, Audit Report and Intercompany matching elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code etc
• Resolved loops and traps using aliases and contexts. Created complex joins like outer joins and equijoin theta joins and checked the integrity of the Universes.
• Created Parameterized, Cross-Tab, Drill down and Summary reports in BO Explorer, Dashboards.
• Data Model Designer, developed, modified and maintained Business Objects universes using Designer for ad hoc and canned reports.
• Created joins, indicating cardinalities, checked integrity of the universe and resolved loops and traps using aliases and contexts. using various functions, Aggregate objects in the universe.
• Designed cascading prompts in the universe to filter the list of account names based on the business units. Import, export universes with secured connection and reports to and from Repository. BO Mobile and BO Explorer reporting experience

Role: Sr. SAP BODS Architect

• Expertise in BODS Data services 4.0/4.1, Data Cleansing using SAP Data Services/Data Quality and installing and configuring data quality address directories for cleansing various country related data.
• Expertize in information Steward, SAP HANA, BODS Data services 4.0/4.1
• Lead the BODS Data services 4.0/4.1 data extraction from ERP Systems SAP, Oracle Applications worked with Manufacturing, SD and Inventory modules working with SAP Data Services Data Stores, Open Hub tables, Transformas and Rapid Marts' and Development.
• Customizing the SAP Data Services Data Stores, ATL Rapid Marts' design, develop/customizing jobs to defined enhancements to populate the Dimensional and Fact tables to accommodate the business requirements.
• Executing / Scheduling the BODS Data services 4.0/4.1 Jobs using SAP function modules/reports in background/foreground to accommodate Job execution in the assigned time frame window and monitoring the function modules' execution to guarantee the successful population of Data Services Data Store tables.
• Worked with BODS Data services 4.0/4.1 flat files from SAP, efficiently using FTP to get/put the files from/to SAP R3 Application Server for the target table population and for other transformations and custom built ABAP Transforms.
• Handling Initial/ Delta Loading of BODS Data services 4.0/4.1, Data Availability, Data Consistency and Data Quality.
• Proficient in BODS Data services 4.0/4.1 Data Mart, ROLAP, MOLAP, HOLAP, Star Schema, Extract, Transform and Load of Data, Requirement Analysis, Design,
• Development, Testing. Documentation and Implementation of Business Applications.
• Worked on BODS Data services 4.0/4.1 Objects / Transformations such as Data Flows, R/3 Data Flows, Query, SQL, Hierarchy Flattening, Validation, Flat File Format, Validation, Table Comparison, Map Operation / Scheduling and Supporting Data Integrator Web Admin and Third Party Schedulers like Tidal / Error Handling and problem fixing in Data Integrator / Migration of code between environments Data Integrator Central Repository
• Used, Rational Clear Case to maintain different builds of the application Log bugs in test director and coordinated with other team members to achieve goals and objectives.

Confidential

Role: Sr. SAP BI/BO Architect

Responsibilities:

• Excellent Experience with Business Objects XI 4.0 universe and webi reports and Xcelsius optimization with all applications including the HANA
• Worked on BObj universe design and Build the Integration with BPC 7.0/7.5 Application Sets Financial Planning and CRM OEM and Retails channel sales Sell thru and Sell in data Planning applications for Creating Dimensions and Properties with enhancements to BPC Applications and applying dimensions to BPC script Logic/Calculations. BO Mobile and BO Explorer reporting experience
• Worked on SAP-BPC Netweaver 7.0/ 7.5 including creating Input Schedules, packages, functions, layouts, creating Transactional BPC InfoCubes and developing application sets for Financial and Trade Promotions Planning and currency translation.
• Developed BObj Universe, webi BOXI 3.1/4.0 and Xcelsius reporting from BI info-cubes and Bex Queries for cost center planning, Xcelsius Dashboards for Revenue , COPA, PCM enterprise reporting Flash summary, Executive Financial Dashboards and Dashboard reporting for CRM Channel Sales and CRM Service, quotes and CRM orders data in BI Infocubes, DSO's , Data sources using custom BADI and function modules.
• Interaction with end users for understanding business-reporting requirements and design build of BI Extractors, Data sources, DSO's and Info cubes for Defer Recon. for GL, CRM Channel Inventory and CRM POS and Sell thru data
• Data Warehouse strategic enterprise BI and data warehousing deployments
• Enhanced the standard extractor 0CRM FM FPO and used CMOD user exits to populate the enhanced fields. Design and Build Xcelsius Dashboards to measure the CAPEX and Asset Depreciation KPI.
• Created the staging DSOs and Reporting cubes. Created Transformations, Start routines and End routines for data transformation. Responsible for extraction of Sales Revenue History from Legacy system ISR into BI. Enhancements and support of Event Planning and Revenue Planning functionalities.
• Created Xcelsius Dashboards to measure the Impact of change in Foreign Exchange FX rate on P L and Balance Sheet. Financial Actual/Budgeting/Forecast reports: Trend analysis business objects reports and Xcelsius Dashboards for- Regional Consolidation Actual from GL and Trend analysis report- Account Schedule.
• Responsible for implementing Purchasing and Inventory logistics Module to analyze clients Purchasing and Inventory data using custom extractions 0PUR C0X and LO Extractions data sources. Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains, User Exits, BADI. Customized and maintained Data Sources such as billing, Sales Order Billing and Delivery Order for the SD /FI/ CRM module and Profitability Analysis Actual Data..
• Created BI Multi-providers for comparisons of plan-actual data in FI and for calculating average value of sales order allocations in SD.
• Worked on creating Aggregates, compressing InfoCubes, creating Indexes, MultiCubes and process chains. Developed real time Infocubes for BPC Planning.
• Designed and developed Info Objects, Info Providers, Aggregation Levels, Filters, Planning Functions, and Planning Sequences
• Configured and involved in troubleshooting custom BPC applications using the BEx toolset including BEx Query Designer, BEx Analyzer, and BEx Web Application Designer
• Created variables to parameterize queries, planning functions, filters, and characteristic relationships.
• Created reports using BEx Analyzer that include Plan/Actual revenue recognition and comparison of Order and sales value by sales representatives, Vendor delivery efficiency, Incoming Orders, Sales-order stock reporting, Balance sheet and Profit Loss using filters, restricted and calculated and Virtual Key Figures, variables, formulas, exceptions and conditions.
• Created Open Hub Destination Objects Info-Spoke to transfer data from standard Data Store Objects to Flat Files.
• Utilized DB connects Interface to extract data from SQL Server into BW system.

Sr. Business Objects Architect Experience

• Installed SP 2/3/4/5 on the XI 3.1/4.0 environment based on the best practice.
• Configured Business Objects XI3.1/4.0 Clustering in SIA's and in xml files for load balancing and fail over tolerance.
• Made parameter changes on Business object services to suit clients reporting requirements and fine tuned the server performance. Migrated content across R3 and 3.1/4.0 environments by initializing import wizard from 3.1/4.0 environment. Configured IIS, Tomcat, and Tomcat Redirector, updated the xml files in tomcat with cluster parameters.
• Implemented SSO by configuring the Active Directory Authentication in CMC Created Access Levels and built the security structure in 3.1/4.0. Assigned security to Business Objects Metadata Manager and users.
• Extensively used Instance Manager to monitoring the recurring schedules, finding the failed schedules and rerun them.
• Debug the schedule failures due to BOBJ server issues based on the work flow.
• Cloned the BOBJ services as per the requirement and set configuration templates for different Services. Created scripts to Stop and Start the SIA automatically.
• Configured Auditing on all the BOBJ services. Evaluated the Trace on the BOBJ services to debug through Trace Logs generated
• Communicated with the user and developer community to understand their requirements to build the reporting application.
• Involved in the Installation and Configuration of BO XI R3.1/4.0 Enterprise in development Environment. Security implementation and User/Group Management Using Central Management Console.
• Migration of Universes, Reports between all the environments Development, QA Production using import wizard. Designed and Developed Business Objects universes and applied row level and object level security to different groups and users.
• Security Administration: Defines Folders/Groups/Users to CMS and grants access to Business Objects XI users, folders, groups, universes and modules in a centralized security environment.
• Designed and maintained Universes and exported them to the CMS repository Info store, File store . Managed categories that were created and assigned to documents by users users must be given rights by the system administrator .
• Responsible for Business Objects deliverables that includes daily and yearly Enterprise reporting process. Responsible for data validation once reports were refreshed.
• Handled daily ETL processes and batch jobs with stored procedures to load data into reporting database before reports were triggered in scheduler.
• Created and Maintained Universes using Business Objects. Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports.
• Created Business Objects XI 3.1/4.0 reports and Universe, Free-Hand SQL, Stored Procedures on Teradata database and BI database and Visual Basic Procedures as Data providers
• Designed, developed and maintained Projects, Programs, Applications, Operations Review and Other IT universes
• Developed both full client and webi reports. Utilized Business Intelligence capabilities of Business Objects using Business Objects SDK to support event handling in reports. Built the feature of Nested Prompts in reports using BO SDK.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Involved in the creating the reports on the web using the WebIntelligence.
• Extensively used Calculations, Variables, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Generated complex reports using Business Objects.
• Created Drill-Through Reports to provide users with more detailed information and query linking.

SAP EPM 10.0 and BPC 7.5 Integration with Business Objects and Xcelsius dashboards Experience:

• Blue printing, design, developing, testing and supporting the Business, planning, and consolidation systems.
• Implemented planning systems for Expense, Sales, Human Resources and Inventory.
• Dimension Management, Application Management, Application set Management and User Management.
• Dimension Member Formulas, Script Logic, work sheet logic, dimension logic, advanced logic, and Business Rules.
• Loaded Transactional data from a Flat File/BI data, and Master Data to BPC Dimensions.
• Loaded and validated data for various applications.
• Configured ownership application for investment, and Equity.
• Configured Intercompany elimination, Currency Translation, and Exchange rate maintenance for Legal consolidation.
• Developed Audit reports, settings of Work Status and creation of Comments.
• Maintained Hierarchy of Cost Center Accounting and Profit Center Accounting and loaded the data to BPC for the purpose of Planning, Budgeting, Forecasting and legal Consolidation.
• Used EV functions in reports and nested reports. Configured Data Manager Packages to upload flat file using Conversion file and transformation files. Developed scripts in SQL stored procedures, functions, and triggers to supplement data transformation and improve the performance of the data extractions.

SAP BODS 4.0/4.1 Integration with Business Objects:

• Defined database BODS 4.1/4.1 Data services Data Stores and File Formats to allow Data Services to connect to the source or target database and files. Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 10g SQL, PL/SQL .
• Involved in Data Modeling, Deployment of SAP Data Services, DQ and ETL Development using BODS
• Built complex ETL BODS 4.1/4.1 Data services solutions using BODS to extract source data from Oracle, SQL Server, flat files and load it into Oracle based EDW Enterprise Data Warehouse .
• Experience in cleansing data in BODS 4.1/4.1 Data services using proper data types and mappings.
• Tuned BODS 4.1/4.1 Data services Mappings and Transformations for the better performance of jobs in different ways like indexing the source tables and using Data transfer transformation.
• Worked on BODS 4.1/4.1 Data services Change Data Capture on both Source and Target level for SCD Slowly changing Dimension Type1, Type 2 and Type 3 for loading historical data and current data into EDW
• Migrated BODS 4.1/4.1 Data services and executed ETL code in multi-level environment using a rigorous migration and testing strategy
• Loaded data to Flat Files
• Used Data Quality transformations like Global Address Cleanse, Data Cleanse to clean the incoming Clients addresses/data as per the inbuilt address dictionary.
• Installed and configured BODS 4.0 Designer, different repositories Local, Central, and Profiler , Job server, and Data Quality Address directories.
• Prepared and presented training materials for the ETL BODS 4.1/4.1 Data services tool and usage. Mentored employees on the ETL tool processes

Confidential

Role: Sr. BI- HANA/ BObj Architect

Worked as an Sr Business Objects/ BW Architect along with providing support for all production and business user issues.

Responsibilities:

HANA Architect:

• HANA Data Model studio and design the data model , developed, modified and maintained Business Objects universes using Designer for ad hoc and canned reports.
• Installed and configure your SAP HANA landscape using SLT system Landscape Transformation and BO Data Services
• Installed, Upgraded and Configured SAP BW 7.3 with SAP HANA as the foundation system
• Extracted source data and provide data loading services to SAP HANA for Software Licensing
• Hands on HANA Experience and implement data replication options and experience with SAP HANA Data Modeling services HANA Studio
• Integrated SAP HANA landscape with Logistics and Finance source system landscape
• Implemented SAP HANA reporting capabilities and Established security services/framework around SAP HANA
• OS/DB migration implementation services related to HANA
• Accelerated the ramp up and running on SAP HANA to enhance system landscape.
• Performance Tuning on SAP HANA tuning and Maintenance and configuration of SAP Portal and/or SAP BW systems related to for SAP HANA landscape

BObj Architect:

• Interaction with end users for understanding business-reporting requirements and designed and build Xcelsius Dashboards for Sales Operations, Bookings and Billings . Revenue Actuals, COPA and Financial GL and Planning BObj Universe and.
• Validating technical / functional BObj Universe specification for World Wide Sales Operations to include the opportunities and Leads and Sales Order Process development from BRD includes Informatica 8.1 ETL and BObj XI 3.1/4.0
• Translate the functional requirements to technical design Informatica and Business Objects
• Assisting the team in Development of Business Objects Reports BO Mobile and BO Explorer reporting experience
• Trouble shoot data issues working with Informatica team
• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI XI and Crystal Reports XI. Used Analyzer and Explorer to view reports from different prospect. For this used Slice and Dice and Drill down.
• Created BObj Universes for HR Analytics, Bookings Billings and Channel Sales, Sales Operations and CRM service and Orders generation using Designer module in Business Objects. As a part of Universe development, created Classes, different kind of objects, cardinalities, Strategies. Resolved the loops using Aliases and contexts. Check the Integrity of the Universes. Export the Universes to Repository for making available to users.
• Established BObj Security user groups and users and assigned privileges.
• Responsible for performance tuning of universes and reports
• Assisting in production migration of associated Informatica ETL and reports
• Created new BObj universes Accounts Payable and General Accounting and modified the universe Procurement Card with new classes, sub-classes and objects as per the standards that were put in place during the strategy process and identified objects as Dimensions, Details or Measures.
• Linked Universes AP and GA to share the Universes which had common dimension tables, classes and objects.
• Designed new Universes and modified the existing Universes based on the report requirements.
• Uses of Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias Tables to remove cyclic dependencies.
• Created Classes, Sub Classes, Dimension Objects, Measure objects in multiple universes, checked the Integrity of the Universes and exported the Universes to Repository to make them available to users.
• Used various join methods like Equi-join, Theta-join, Outer-join in designing the universes.
• Resolved Loops and Traps using the functionality of Aliases and Contexts.
• Used Stored Procedure as Data provider to retrieve data from scheduled tables and complex queries.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Analyzed Reports using Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Creating the Reports from Excel files using Business Objects through Personal data files
• Converted the Reports to Text File format as per the User requirement Using Business Objects 3.1/4.0 Version.
• Generated the Business Objects Reports using the universe as the main Data providers and writing the complex queries including Sub queries, Unions, Intersect and.
• Brought data from a personal data file into BO and combine it with data from a BO Universe query.
• Created Reports on web using Info View Portal and Web Intelligence, distributed the Reports to different users.
• Used Broadcast Agent for scheduling and distributing the documents using Xcelcius add on Infobrust.
• Participated in Pilot Demo implementation of BObj Upgrade XI 4.0 at Adobe Systems .

BObj Security Admin/Architect:

• Supported the development of the BObj security Folder Level/Row Level Security assessment, including a changes to the current business processes
• Lead Developer for the Revenue and Booking Billings and Sell Thru Universe technical design and documentation
• Maintaining BO in 3 different versions at the same time ranging from 6.5 to XI 3.1/4.0
• Migration of all Enterprise wide Universes to XI 3.1/4.0 environment in phases
• Involved in Server Architecture for 3.1/4.0 and document changes for Environment Planning
• Provide business continuity for the legacy environments and also ongoing support for BO XI version
• Involved in creating users and user groups using Central Management Console CMC and assigning the privileges to the users to access the Business Objects applications.
• Setting up the BObj security levels to the users in universe module like row level and object level security
• Design and develop the Xcelcius Dashboard, Universe and required reports using Antivia and Infospoke Infobrust add on's in BObj Xcelcius.

SAP BW Experience:

• Built DSO objects for Bookings Billings and Channels Sales and Revenue Recognition, Info cubes, Infosets and BEx reporting using SAP BW 7.0
• Performed extraction, transformation, and loading of data ETL by preparing SAP R/3 for logistics Billings and Bookings 2LIS 13 VDITM, 2LIS 11 VAITM and COPA SAP BW and defining the loading strategies, initial and delta data loads using IDocs and PSA TRFCs , loading data via flat files and staging BAPI, and scheduling and monitoring data loads.
• Uploaded cost center DSO's and Infocubes data CO-PA into cost center for analyzing actual and plan data in Infocubes, replicated data sources, and made delta uploads using time stamp method. Created Open Hub Objects to connect the SAP BW data to EDW for reporting.
• Generated BW Function Module and BW Programs to Support the Informatica Loads for Revenue Bookings and Billings
• Created Sales Ops and Finance Multi-provider and Info Sets and performed reporting on them.
• Performed day-to-day responsibilities including analysis of data requirements and translation of these requirements into dimensional data models, with an emphasis on actual implementation in BW.
• Developed a custom Info Cube as per design specifications in order to meet the business user requirements.
• Worked on SAP BW Custom extractors, datasources and Infocubes to support revenue recognition and milestone billing for Adobe Partner revenue amortization. Setup the item category for revenue recognition, billing plan type and account determination. Worked with Rev Rec tables through VF44

Business Objects Integration Tools and BPC Netweaver 7.3 / 7.0 Experience:

• Worked on Universe Connections, Query as a Web Service QAAS and Live Office application for Business Objects application Financial Accounting and Profitability analysis dashboard using to develop functionality for business users to quickly create queries and publish them as web services. Worked on web services BI Business Object integration as part of Business-Objects Enterprise Premium deployment to create live Dashboards for Revenue and Sales Operation Opportunity leads and sales order process

• Built currency translation mechanism to allow users report in multiple currencies.
• Created Allocation functionality to distribute high level budget numbers to business units/product lines based on previous years actual to calculate line-items on income statement based on drivers input.

• Created Business Process Flows BPFs to streamline planning application.
• Created Custom Menus using VBA macros to follow certain business process guidelines.
• Set up the security mechanism in BPC: users, teams, member-access profiles task profiles.
• Executed the data transfer process from third party system into BPC.

• Presented BPC proof of concepts and demos to clients, who are looking into new dimensional planning consolidation solution that included partnering with SAP America BPC team. Proficient in writing Script coding/MDX, creating/running data manager/SSIS packages.

SAP BODS 4.0/4.1 Business Objects Integration:

• Extensively worked as Lead Data services Architect to define Data service Target tables into which the material and Customer dimension data loads. experience with Invoice and Sales Order with Customer Master Data and Customer Sales Master data mappings to define transformations by using the Data Services Designer
• Worked in Data Services Management Console to transform load and Validate the Data from SAP systems
• Performance tuning of Data Services engine to execute individual jobs defined in the
• Finance and Sales application created using the Designer.
• Worked in tuning the Data Services Repository to store Designer predefined system objects and user-defined objects including source and target metadata and transformation rules.
• Implementing Best Practices in Business Objects Universe Design, Web Intelligence Design, Content Management, Row-level Security setup, Custom Access Levels and User Management in a multi-server clustered environment.
• Managed and performed tasks related to BW 7.3 system upgrades and hot packs
• Understanding/implementation with SAP BW 7.3 and migration of BW 7.0 to BW 7.3
• Extensively involved in HANA Data Modeling

Confidential

Role: Sr. SAP BI- BO Architect

Responsibilities:

SAP BI Experince:

• Developed PCA/AR/AP.FI GL/Cost Center Accounting Dashboards and BI Design and Build BI Info cubes , DSO's SD- CRM BI extractors for Product detail page, Product category pages, store locator, shopping cart etc to meet the business requirements
• BW Design and Build of SAP LMS/Net Revenue, Fixed Cost, Inventory, Cash flow and Contribution Margin Reports BI Custom-Quote Interface/Application to be able to quickly provide customers with service and application quotes for one or more tools. Design of SAP FICO- BI Info cubes/DSO's/Extractors for COPA, PCA, Cost center accounting, FI GL , AR and Inventory stock reports using Bex Query designer and BOXI 3.1/4.0 front end Info view.

SAP BO Experince:

• Designed and developed, Created the entire data flow for Blocked Invoices data from R/3 system to DSO and then onto Info cube, DSO, data source etc.
• Extensively involved in Developing and Enhancing of custom Queries extracting data for
• Aging Metric of Blocked Invoices even using advanced Bex Query features like cell editor writing BEx exits.
• Developed BOXI 3.1/4.0 Infoview Dashboards for finance CCA,PCA, Fixed revenue and LMS reports by extracting data from Net suite using BO Data Service.
• Developed Xcelsius Dashboards based online analytical processing OLAP tool
• working with multi-dimensional data, combining information from different
• Finance systems within a single workspace Voyager. Developed access Voyager from within the
• Business Objects Enterprise Info View portal. created new analysis using BO Data Service
• workspaces in Voyager, and view and edit workspaces that have been saved to the
• Business Objects Enterprise repository Voyager.
• Designed and Build a Business Intelligence Voyager Finance and CRM Reports designs and Implemented the Business Intelligence Sales Invoice Details Dashboard reporting and Sales Manual Pricing Business Object Crystal Voyager Finance and CRM Reports Solution.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Build BOXI webi reports for SAP CRM Trade Promotion Management for Trade funds management, Account planning, Trade promotions and CRM Pricing and revenue.
• Demonstrated advanced understanding of Business Objects Financial and Sales Operations reports that can be used in support of business operations. Managed the entire Business Objects reporting process from design through implementation including gathering report requirements, report design development, scheduling reports and publishing reports on the web using Share point site.
• Developed Business Objects Universes and created custom canned reports using web Intelligence, Crystal Reports and Excel Pivot reports based on client's current and future needs.
• Interacted with Business Users for the revamp of reporting modules.
• Collaborated with customers and requirements team to visualize and design reports, dashboards, and balanced scorecard to align both objectives and measurements.
• Designed and develop Xcelsius Business Object Dashboard and Infobrust scheduling of Webi and Xcelsius dashboards and Reports cross-tab reports, summary reports with drill-down capabilities and sub-reports. Exported reports into various formats like PDF, HTML, EXCEL, and WORD by using Business Objects and webi Reports based on user requirements.
• Used Crystal Management Console to run and schedule reports.
• Created Oracle Tables / Views for data extraction. Configured using ODBC / OLE DB data source.
• Reduced cost and development time by creating report parameters, report templates for re-use.

SAP Data services Experience:

• Built Business Objects XI 4.0 / BODS Data Services Data Store objects for Bookings Billings and Channels Sales and Revenue Recognition, Info cubes, Infosets and BEx reporting using SAP BW 7.0
• Performed Data Services extraction, transformation, and loading of data ETL by preparing SAP R/3 for logistics Billings and Bookings 2LIS 13 VDITM, 2LIS 11 VAITM and COPA SAP BW and defining the loading strategies, initial and delta data loads using IDocs and PSA TRFCs , loading data via flat files and staging BAPI, and scheduling and monitoring data loads.

Confidential

Role: Sr. SAP BI- BO Architect

Responsibilities:

• Created CRM BI Design and Build Function Module extractors on BI 7.0 technology SD- CRM BI Infocubes, DSO's SD- CRM BI extractors for Product detail page, Product category pages, store locator, shopping cart etc to meet the business requirements
• Design of SAP SD- CRM BI Custom-Quote Interface/Application to be able to quickly provide customers with service and application quotes for one or more tools. Design of SAP CRM- BI Service Quotation, Version Management to keep track of all the quotations submitted to the customers. Configuration of SD- CRM- BI Service Quotation Management, Service Contract Management and Service Order management, Price Protection in CRM, Channel Inventory for CRM, Resale Claim and Tracking, Design Registration
• Automatic creation of Preventive Maintenance cases with the help of Service Plans. Design/Configuration of Interaction Center.
• Excellent CRM BI experience in configuring capabilities SD- CRM- BI Master Data, Internet Pricing Configuration IPC , Billing, Sales Methodology and Sales Assistant. Partner Processing
• Dashboard Build for SAP CRM Trade Promotion Management for Trade funds management, Account planning, Trade promotions Revenue Recognition / Channel Management
• Develop Technical Designs from Functional designs for CRM BW TPM, Marketing Sales Order Quote, Price Protection , Channel Inventory CRM Reporting
• Worked with Trade claims management and Trade promotion analytics
• Designed the BOBJ Designer and Info view reporting solution for FI Asset/Profit Center Accounting Delta Load solutions for New COPA/GL/Asset/AR Data Model, Extractors, Data store Objects and Info cubes for Purchasing, Accounts Payables, Invoice Notification Management and Order Management.
• Designed and Build BO XI 3.1/4.0 BOBJ Reports for CO-PA/FI-GL/FI-AP/AR,FI-AA/FI-PC BO Universe and BO reports/Dashboards and also designed the COPA BOBJ module as well within the SAP ECC system to design and develop CO-PA drill-down BOBJ reports within the SAP system. COPA reports provide profitability information for gross-margin analysis for characteristics such as customers, product lines, regions, and combinations of these characteristics.
• Designed BOBJ COPA - BO Universe and BOBJ Infoview and Dashboards for CO-PA reports that reside within the SAP system, COPA reports provide real-time profitability information, which is vital for Sandisk Technology Business.
• Financial Budget BO Reporting experience includes creating planning areas, levels, packages, functions, layouts, creating Transactional InfoCubes and developing retractors. Experience in planning applications with Integrated Planning BI 7.0 / Netweaver 2004s . Developed BI data extraction and Infocubes for data from ECC with XI Interface tool

SAP BOBJ Experience:

• Designed and Developed BOBJ Dashboard Xcelsius Reporting for Enterprise Finance and Sales business. BOBJ Business Object BOBJ XIR3.0/3.1/4.0, Crystal Reports 2008 and Xcelcius 2008 Reporting and BI BO Integration Functional and Technical Design.
• Developed CAFR Xcelsius Dashboards: Comprehensive Annual Financial Reporting in BI Report Enterprise Portal which have detailed presentation of the state's financial condition. reports on the state's activities and balances for Sandisk Technology.
• Lead the Implementation of SAP BO to replace legacy systems SOAR. Analyzed reporting needs to implement as part of SAP BI FICO implementation.
• Developed Xcelsius Dashboards BO reports to Benchmark is measured in Sandisk Utilities Customers URC per hour. specific representation of a Sandisk utilities in data model for Plant Maintenance PM.
• Designed Financial reporting using Business Object Voyager tool with access to multiple different OLAP sources in the same report to get a comprehensive view of the financial business and the cross-impact that financial trend may have on another

SAP BOBJ Experince:

• Created Reports like Cross Tab, Master detail, Tabular and charts in Desk top intelligence and the web intelligence.
• Developed various repots like Blank reports, Cross tab Reports and Sub Reports.
• Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
• Exported universes to the repository to making resources available to the users.
• Created reports using the BOXI OLAP and Non OLAP Universes and Free-hand SQL as data providers.
• Involved in development and deployment of Complex Reports.
• Publish BI Web Portal report to iViews using Business Object BOBJ BOBJ dashboards and Info view BOBJ Dashboard and reports publish to portal
• Created web application BO portal template in designer for trigger portal content such as BO Reports and ECC FI and COPA transactions through client eventing.
• Worked on Business Object BOBJ WEBI Infoview and Crystal Reports 2008 and Xcelsius 2008 dashboard reporting and Publishing WEBI reports with parameter values.
• Worked on Business Object BOBJ s XI Integration Kit for SAP Solutions delivering the strongest business intelligence solution for works customers
• Worked on conversion of desktop Intelligence documents to Web Intelligence XI 3.0 documents using the Report Conversion Too and Universe Designer and Designer.
• Finance , Controlling and Sales modules reporting in Crystal reports and WEBI Info view reports including SAP OLAP and SAP HR sessions and workflows in Business Object BOBJ s XI 3.0

SAP BI Lead Experience:

• Lead extensively in BI development of Financial management and Finance and Controlling Cost based COPA, Accounting Based COPA, Asset Accounting and New General Ledger Accounting Data Models. Supply chain Management and Inventory, Material, Purchase Order and Invoice Verification.
• Data models and Order Fulfillment area by using 2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 11 V SSL, 2LIS 12 VCITM and 2LIS 13 VDITM standard extractors.
• Developed BI FI-GL, FI-SL, FI-AR, FI-AP, FI-AA, FI-PS Extractors and Infocube for BI especially Financial management Reporting
• Worked extensively in development of Finance BI reporting for inter-company sale using a transfer price, where the inter company profit show on consolidated group reporting
• Participant in the Strategic Growth Plan for the Global Architecture Technology group.
• Initiated on-going discussions with other SAP FICO and BW industry leaders to collaborate on bringing best practices into Business Intelligence community.
• Developed BI FI GL Document Splitting line items Data Model in BI which feed selected dimensions to produce financial statements for the selected dimensions at any time. BI reporting include the profit centers and segments balance, assignment of the vendor and tax lines to a profit center and segment.
• Worked with the client to understand the Business Intelligence 7.0 reporting requirements. Had several sessions scheduled to understand the Financial management in existing data warehouses and their expectations from BW.
• Worked with Financial BI Data Model to implement Sarbanes-Oxley Act requirements for corporate financial reporting worldwide. Developed Finance BI Reports to have accurate and more reliable in terms of SAP's Accounts Receivable AR module reporting indicate the risk of bad FI-AR debts
• Developed BI Finance Infocubes and Finance reports for profit centers to monitor internal profits, BI BOBJ Dashboard and reports publish to portal reports include the transfer pricing for exchanges between profit centers. These transfer prices are selected automatically for goods movements stock transfers, goods usage between profit centers as Internal revenue and Internal costs in EC-PCA

Confidential

Role: Sr. SAP BI- BO Architect

Business Object BOBJ XIR3.0, Crystal Reports 2008 and Xcelcius 2008 Reporting and BI BO Integration Functional and Technical Design

Responsibilities:

• Worked extensively on Business Object BOBJ XIR3.0 WEBI Reporting using Infoview's, WebIntelligence Documents, Business Object BOBJ Designer to create Universes and Business View's for the purchase orders that extracts confirmed and invoiced values and quantities.
• Worked on Creating FI - COPA Personal Shell Oil Business Object BOBJ Corporate Xcelsius Dashboards for Central Finance and Shell Global Solutions MI Web Digital Cockpit Reporting using Web Templates in Web Application Designer and Xcelcius 2008 Dashboard reporting in Business Object BOBJ BOBJ
• Worked on Security design for Business Object BOBJ dashboards using Central Management Console and providing authorization to Global Finance managers, worked on Automating Dashboards with Rules and Creating rules.
• BI Architect for Finance New GL Totals and Line Item solution: Development and design of New GL data model to provide the functionality for Finance Management Solutions ie. Balance sheet and Income Statement analysis.
• Designed BO reports for CO-PA that offers many useful reporting features, including drill-down, slice-and- dice, sorts, and exceptions. BO Reporting combination of CO-PA and Sales offer the optimal reporting option with the maximum use of existing reporting investments.
• Implemented Actual Vs Estimate Reporting Solutions using Enterprise Portal 6.0 , BO XI 3.0 and Business Object BOBJ BOBJ Xcelcius 2008 Dashboard Manager's. Hands on experience in IDOC, User Exits, BDC programs, ALV, BDC, LSMW.

Detailed BI Design Activities:

• Prepared TDD Technical Design Documents and Build BI Data Model for New General Ledger Accounting and New GL Line Item Data Model used to generate the Balance Display , Monthly Financial Trends and GL Balance Control Reports. Build and use dimensional data warehousing for virtually any type of business application.
• Designed the BI FI GL, FI - COPA Delta Load solutions for New GL Totals and GL Line Items Data Model, Extractors, Datastore Objects and Infocubes for Accounts Receivables, Accounts Payables, Invoice and Order Management.
• Designed and Build the BI FI AR/AP FI - COPA solutions: BI Finance reporting include the companies with reason codes to analyze which customers had too many payment differences. After the analysis, BI report is used to interact with the customers. Elimination of the FI AR payment differences reduced their costs drastically
• Created BI Design and Build for Function Module extractors on BI 7.0 technology from existing AP/FI/Sales/CRM and Travel and especially Expense management
• Structures. Created intermediate Finance write optimized DSO Structures based to improve performance while loading FI data. Created Spend Data Warehouse SDW DSO, Cubes and multiprovider based on the technical design document. Created SAP BI Bex and Enterprise Portal Dashboards with Web digital Cockpit reports based on multiprovider.
• Worked as Business Intelligence-FI Lead to establish rules and boundaries from the beginning to achieve the Timelines and delivery of Project. Managed the whole project by instituting a defined structure right from the prototyping or predevelopment environment and building the BI Infocubes and Extractors in BI Development system.
• Worked as Architect for SAP Business Intelligence Integration with Business Object BOBJ BOBJ FI - COPA reporting solution responsible for the many important aspects of a project such as resource requirements, timelines and deliverables, testing, training, change management, go-live, and production support. Managed multiple project groups to develop in the same BI -Business Object BOBJ BOBJ - Finance system at the same time with different timelines and deliverables, Business Intelligence team lead to achieve the project goals
• Worked on SAP BusinessObjects Dashboard Manager XI for the deployment of powerful Dashboards for SHELL MI and Leadership Pack Finance and Controlling Reporting which provide visibility, alignment and insight across the Shell enterprise Management Reporting Portal.
• Involved as team lead in Project Evaluation, Information Gathering, Business Blue Print, Documentation, Customization and Configuration with an in depth understanding of business processes relating to SAP Finance, Unit Integration Testing, Validation and Substitution, Controlling and integration with SD, FI MM, and PS modules.
• Played an active role in Functional Requirements Gathering, Roll outs and meetings with Key users. Identify BI Net Weaver 2004'S requirements, Planned and created a data warehouse.
• Functional BI Lead for the Sales and Distribution BI Process team and SAP FI- BI Team to Maintain consistency throughout the project. Developed methodology for every planned implementation phases of project. Implemented GL Totals 0FI GL 10 and GL Line Item and Procurement overview aggregated . Worked on Invoice and Billing for Sales and Distribution BI Reports .

Netweaver 2004's Enterprise Portal and BI Reports Functional and Technical Design:

• Developed BI reports using Query Designer for FI Audit Finding on SAP Enterprise Portal 7.0, Prepared Recommendations, Developed and Implemented and Monitor Audit controls and Scheduling Systems using Business Intelligence Portal reporting solution to ensure maximum Departmental Productivity and Efficiency. Business Object BOBJ BOBJ
• Developed using Web Application Designer Web AD A customized drop-down box function used with BEx Analyzer query with the flexibility to create several reports in one report, showing each group of key figures by category in a drop-down box
• Web application Designer. Design and tested SAP BI dashboards which are compact displays that render Web content graphically and easily.
• Developed Visual Composer reports for Financial Audit for different clients under the guidelines of Generally Accepted Accounting Principles GAAP
• Prepared and Issue Audit Reports using BI and Business Object BOBJ s XI R2 Compliance Certificates as per regulatory requirements.
• Created Finance Analytics BI Reports using Query Designer, Business Object BOBJ s and Management Information interactive analytics in BO Dashboards and Web Digital Cockpit Reporting using Web Templates in Web Application Designer.
• Worked on Shell MI and Leadership Pack Web Digital Cockpit Reporting using Web Templates in Web Application Designer Created SAP BI 7.0 Web Digital Cockpit Reports to publish them to SAP BI Enterprise portal.

BI 7.0 Netweaver 2004's Sr Architect : Functional and Technical Finance Design:

• Developed BI 7.0 Finance Netweaver 2004's Design and Build. BI data models for Sales and Finance Infocubes and DSO. Created BI Upgrade approach to produce consistent and accurate data over time. Worked on BI 7.0 - Finance Netweaver 2004's Design and Build for BI Data Conversion Infocubes, Upgrade for BI Info cubes which have Finance Data Validation and Data Migration from Legacy Systems.
• Worked on Enhancement Pack 3 Upgrade Testing and Design and Build Project to Implement the New GL Line Items solutions. This is a new SAP functionality launched at Shell Services as Ramp Up Customer.
• Designed BODS Data services extraction and BI Performance Tuning Techniques: Performance tuning of Queries by maintaining OLAP Cache, Info Provider Variables Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx Query.
• Worked on Production Support in various phases of the project to resolve the critical Incident and change tickets.
• Worked on BI and Business Object BOBJ Onsite/ Offshore Implementation in various phases of the project to resolve the critical Design and Build Issues using tickets.

Confidential

Role: Sr. SAP BI- BOBJ Techno-Functional Architect

Responsibilities:

SAP BOBJ reporting Experience:

• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• 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.
• Creation of Business Object XIR2- SAP reports like CPM , Planning Cubes in CPM FOR Financials, CPM Residential and CPM Business Customers reports, Service charge validation Reports, Monthly paper bill Reports
• Designed COPA Summarization level BOBJ Reports which is one of the most popular techniques for improving report performance in CO-PA. Summarization levels, which are presummarized data for specific characteristics, improve performance dramatically
• Customized CO-PA extraction and Developed Customized COPA BO Reports. Developed COPA Reporting KPI's for PA -Profitability analysis. Developed BO Universe and BO Infoview Portal for CO-PA extraction of data from for costing and Accounting based COPA

BI Lead /Architect Design experience:

• Identified new features in Net Weaver BI 7.0 useful for client, gave a presentation for upgrade and worked hands-on for up gradation to Net Weaver BI 7.0
• Played an active role in Requirements Gathering, Roll outs and meetings with Key users. Identify BI Net Weaver 2004'S requirements, Planned and created a data warehouse.
• Designed and developed, Created the entire data flow for Blocked Invoices data from R/3 system to DSO and then onto Info cube, DSO, data source etc.
• Extensively involved in Developing and Enhancing of custom Queries extracting data for Aging Metric of Blocked Invoices even using advanced Bex Query features like cell editor writing BEx exits.
• Involved in complete life cycle of the project Architecture, Design, Development, Deployment, Performance Tuning, Go-live and support activities from for BI 3.5 to BI 7.0 upgrade.
• Extracted data using DB-Connect, and data export using Open Hub and Info Spoke methodology
• Maintained info packages and monitored Business Intelligence data load into Info Cubes and DSO.
• Ability to connect the SAP R/3 and other legacy systems as source systems to SAP BI.
• Worked on Business Object BOBJ s Web Intelligence query, reporting and analysis u to access the data in Astra Zeneca corporate databases directly from within Business Object BOBJ s Enterprise Info View and to present and analyze this information in a Web Intelligence document. Done implementations using SAP ASAP methodology and through understanding of SAP Best Practices.
• Excellent Experience with Business Objects XI universe and webi reports and Xcelsius optimization with all Teradata applications including the TeradataData Warehouse strategic enterprise Sales, Logistics and Financial data warehousing deployments

Confidential

Role: Sr. SAP BOBJ BI Architect

Responsibilities:

SAP BOBJ reporting Experience:

• Actively involved in creating and updating BOBJ users/user groups and maintained user profiles using Supervisor.
• Designed and Maintained BOBJ Universes and exported them to the repository.
• Created Classes and Objects Measure, dimension and detail in the universe.
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Formatted reports as per the user's BOBJ requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Generated complex reports using Business Objects.
• Created BOBJ Drill-Through Reports to provide users with more detailed information and query linking.

BI Lead /Architect Design experience:

• Extensive experience in Business Intelligence Data Extraction Techniques like Business Content Datasources, LIS, LO-COCKPIT, CO-PA and Generic Extraction.Sales Invoice Extractors
• Involved in the enhancement of 0CUSTOMER ATTR, 0VENDOR ATTR, 2LIS 02 SCL using user-ex