We provide IT Staff Augmentation Services!

Sap Bods Consultant Resume

2.00/5 (Submit Your Rating)

Dallas, TexaS

SUMMARY

  • Over 10 Years of experience in Information technology field wif strong emphasis on Data Warehousing and Business Intelligence, which includes 6 Years of Development, Administration and Support solutions for Business Objects Data Services.
  • Over 8 years of experience wif SAP Data Services and data integrator as an ETL tool and also more TEMPthan 6 years of SAP Data Conversion Experience.
  • Installed and configured the Business Objects Data Services V.4.2/V.4.1/V4.0, Data Services XI 3.2 wif SAP BI, ECC, SCM and CRM.
  • Experience in installing and working wif the Information steward 4.0.
  • Expert in Data Services Data Quality (DQM) like address cleansing and data cleansing process
  • Created the Repositories on Oracle 10g/11g, SQL Server 2012, and Linux and configured the Local, Profiler repositories wif Job server and Management console.
  • Strong understanding of RDBMS and Data warehousing concepts and Knowledge in Data mart development, ER Modeling and Data - Flow Modeling.
  • Worked wif Data Integrator, Quality and Platform Transforms.
  • Extensively worked on development of mappings and worked wif BODI Transformations like, Map Operation, Table Comparison, TEMPEffective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc
  • Experience working on Change Data Capture on both Source and Target level and implemented SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
  • Worked extensively on integration of Business Objects Data Services wif SAP modules and non-SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2005/2008/2012 , DB2.
  • Knowledge in SAP modules SD, MM, FI, and CO.
  • Extracted SAP ECC Extractors data (SD, MM, FICO, CO PA) and loaded it into Enterprise Data warehouse. Developed various SAP BODS Jobs based on the delta extraction type of ECC extractors to setup the subscription for delta extraction process.
  • On HANA Database expertise on Data provisioning and transformation techniques, Modeling techniques, Security and authorization techniques
  • Experienced in loading data from multiple sources to tables into HANA Database.
  • Worked wif ABAP dataflow and Data transports to extract the data from R3 tables.
  • Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
  • Expert in using LSMW, BDC's & IDOC's in loading data into SAP ECC 6.0
  • Loaded data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS by referencing SAP AIO jobs.
  • Used Data services XI 4.2 as an external system as ETL to extract data from ECC and BI for cleansing the data using Data Quality transforms.
  • Worked wif Open Hub Services to push data out of SAP BI using Data Services. Also
  • Worked wif Match and Associate Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
  • Worked extensively wif AIO (All in One) Templates and SAP ABAP.
  • Worked on Profiling and Auditing in migration.
  • Installed and have development work on the Information Steward and done some profiling tasks in data insight.
  • Database: Worked wif End-To-End implementation wif Data warehousing team. Strong understanding of OLAP and OLTP Data warehouse concepts, Dimensional Data Model, Star Schema, Snowflake Schema.
  • Rapid marts Implementation: Experience in Integration SAP suite of BI products wif Business Objects including Business Objects Data Services (Rapid marts). Implemented Cost Accounting, Fixed Asset, Purchasing, Sales Analysis Rapid marts
  • Implementation: Played a key role in several phases of implementation for various projects in Requirements Gathering, Analysis, Blueprinting, System Configuration, Data modeling, Unit testing, Integration testing, Cut-Over activities, Go-live strategies and Post Go-Live Stabilization Maintenance Activities.
  • BW Development: Configured and Implemented BW reporting using BEx Analyzer and WAD (Web Application Designer). Development of Queries, Reports and Workbooks. Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and Filters. Experienced in Development & Testing of Info Cubes, DSO’s, Aggregates, Hierarchies, Info Sources, Data Sources, Extract Structures, Enhancements, Info Set. Loading data from R/3 system from application specific data sources, generic data sources for master data, transaction data and flat file from third party systems to Info cubes and DSO in BI 7.0. Proficient and sound noledge wif Planning, Multidimensional data modeling using extended star schema, Design Implementation, and User Training of SAP Business Information Warehouse.
  • BO Administration: Managing the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CCM. Security design features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure by creating Users/Groups/Sub-groups & assigning the privileges
  • Testing: Experienced in creating Test Scripts - Unit/Functional Integration using Mercury QA tools, creating Test Plans and End User Documentation and Training Materials. Prepared test scripts and test cases to validate data and maintaining the data quality.
  • Good Communication and Interpersonal skills wif the ability to interact wif end-users, managers and technical personnel. Technically sound, Result-Oriented wif strong Problem solving skills.
  • Capable of working as a Team Member or Individually wif minimum supervision. Flexible and versatile to adapt to any new environment wif a strong desire to keep pace wif latest technologies

TECHNICAL SKILLS

BI: SAP BI 7.0/3.5

ETL Tools: SAP BO Data Services 4.2/4.1,4.0, XI 3.2 SP1(Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2., SIA, Central Management Console, Central Configuration Manager, Designer, Tomcat, Apache

Data Modeling/Oracle Utilities: Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader.

Databases: ORACLE 11.2/10g/9i/8i, DB2, Informix, MS Access, MS SQL Server 2005, 2008, 2012, Syspro, David database.

Languages: SQL, PL/SQL, ABAP, Java, C#, .Net, VB.net, C, C++

Web Technologies: Servlets 2.0, JSP 2.0, XML (XSDL, XSLT, SAX, DOM)

Web Tools: HTML 3.2/4.0, IIS 4.0/5.0.

Operating Systems: UNIX, Linux version 3.0.13-0.27 , MS-Dos, Windows NT 4.0/2000/ 2003/2008 r2, xp

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

SAP BODS Consultant

Responsibilities:

  • Integrated SAP suite of BI products wif Business Objects including Business Objects Data Services (Rapid marts).
  • Installed and configured SAP Data services 4.2 SP7 Client on SQL server environment in non-production and production environment. Created Local, Central and Profiler Repository wif SQL Server 2012 and configured it wif job server and management console.
  • Installed the SQL Server 2012 R2 and created the Databases for Data Services and Repositories.
  • Implemented Cost Center, Fixed Asset, Purchasing, Sales Analysis, Account payable, Account receivables, Production planning, General Ledger and Inventory Rapid marts for deploying rapid reporting solutions. All prebuilt rapid marts are customized based on business requirements.
  • Architected Confidential -CPS integration project and designed ETL process and guided a team of developers to meet demanding deadlines.
  • Standardized the customer master and Material master data during the data integration of merger company.
  • Initiated interaction wif business and SAP functional resources to find the data integration requirements and modifications. Based on Business requirements and existing database structures developed ETL data mapping document.
  • Developed the High-level and Detail-level documentation of the project.
  • Worked wif ETL programmers on implementing the Design of the project wif Data mapping blue prints and also met project standards using proven data load tools and methodology.
  • As a part of Confidential new acquisitions extracted data from multiple ERP systems (Microsiga of Brazil region, Syspro of china region, SAP ECC 6.0 of NFTA region, SAP ECC 4.6 of EMEA region, David database of south Africa region) and various CSV/Excel spreadsheets to Enterprise data ware house (SQL Server 2012) using several ETL tools.
  • Developed SQL Server Cubes to extract the data as CSV files for loading data in the non-integrated server environment.
  • Strong SQL Server scripting skills. Capable of developing the complex SQL server structures and lookup tables which are used during the rapid mart process.
  • Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs to extract data as files.
  • Developed Stored procedures and SQL Jobs to defrag and compress the SQL Server tables for performance optimization of database. In the process created/altered the indexes and partitioning of the database tables.
  • Implemented Data services optimization techniques to improve the jobs performance. It includes the cache adjustments, bulk loading, commit row sizes, increasing the parallel processing, push down SQL, adjusting Look up techniques.
  • Worked extensively on the COPA based timestamp type extractors for extracting the profitability business related information. Capable of maintaining and enabling of various delta type of SAP ECC extractors.
  • Developed an Error handling technique to address the internal SAP BODS application bugs to enhance the stability of the SAP Business objects enterprise.
  • Designed, developed, deployed and maintained universes using Business Objects designer, tableau. Installed and configured Business enterprise in a multi-tier environment.
  • Created customized Web Intelligence reports from various different sources of data. It includes major managements reports for sales by region, sales by market segment, sales by sales manager, sales by product hierarchy, sales by customer hierarchy.
  • Managing the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CCM. Security design features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure by creating Users/Groups/Sub-groups & assigning the privileges.

Confidential, Dallas, Texas

SAP BODS Consultant

Responsibilities:

  • Installed and configured SAP Data services 4.1 Client on Linux environment in non-production and production environment. Created Local, Central and Profiler Repository wif oracle 11g database and configured it wif job server and management console.
  • Installed the SQL Server 2012 R2 and SQL developer and created the Databases for Data Services and Repositories.
  • Installed the All in One (AIO) Best Practices Projects, Data flows, Work flows and transformations and Data Quality (DQM) like address cleansing and data cleansing process.
  • Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform (to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
  • Used the case, validation, merge transforms and lookup function to validate the customer master basic data (to find whether that record already exist in SAP or not).
  • Implemented MATMAS IDOCS for loading new or updated custom ZASY and ZSRT materials from Legacy systems.
  • Data cleansing by filtering the incorrect records and send the good data into the custom build warehouse by creating the Fact and Dimensional tables in Data Services.
  • Created the Repositories, SAP data stores, read and modified the custom ABAP transformations, calling RFC’s BAPI’s, reading the SAP functions to Data Services.
  • Migrated the Data Services code from DEV to Quality and Production systems using both Central repository and Atl files.
  • Experience wif Data Services Confidential Rapid Marts for Cost Accounting, Fixed Asset, Purchasing, Sales Analysis extraction from ECC 6.0 to SQL Server 2012 database for building Enterprise DW project Reports.
  • Resolved issues prevailing wif the Confidential Rapid Marts and applied the best practices to overcome the failures occurred during First and Delta Load.
  • Created the SAP data stores and configured to have shared directory method to use ABAP transformations and SAP functions in the Data Services to extract Data out of SAP ECC 6.0.
  • Used Business Objects Data Services to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like Oracle 10g/11g, MySQL and SQL Server.
  • Used SCD type II for loading data in the Enterprise DW.
  • Extensively worked on the new add-on on SAP BODS Extractors to load data to SQL server Database. In the process extracted SAP ECC Extractors data (SD, MM, FICO, CO PA) and loaded it into Enterprise Data warehouse.
  • Worked extensively on Confidential and custom defined LIS and LO extractors (mainly on Sales and Billing Extractors)
  • Developed an advanced strategy to capture the job execution, load statistics (Audit Statistics and check sum) values for enhancing and optimizing the quality of Load. As a part created the Global and Local Variable and customs SQL queries and implementing the Data Services based on client’s requirements.
  • Understand user requirements and Data Model defined and developed by the business analysts and data architects. Analyze and import the Source definitions and created target definitions, logical and physical designing of target tables.
  • Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.
  • Participate in developing best practices data warehouse standards for building Data warehouse and data modeling.
  • Utilized several transformations in ETL jobs developed using Data Integrator including Date Generation, TEMPEffective Date, Table Comparison, History Preservation, SQL, Merge, Pivot, Reverse Pivot, Query Transform, Validation etc.
  • Extensively used lookup and lookup functions (lookup and lookup ext) to perform database lookups.
  • Batch jobs configuration and set repository schedules using Data Services Management console.
  • Stage the source data from flat files, SQL server, DB2 sources into stage tables.
  • Migrated the Legacy data to SAP ECC 6.0 by using the Data Services Best Practices AIO methods by using IDOC methods.
  • Expert in Installation and configuration of Information Steward 4.0, Data Insight, and AIO Templates.
  • Worked wif Information Steward to pre-assess the source system data and to develop data cleansing profiles, execute profile.

Confidential, Norwalk, CT

SAP BODS Consultant

Responsibilities:

  • Interacted wif project managers, business analysts and Business users to analyze business requirements and outline the proposed solution.
  • Initiated DBA interactions for resource requirements and modifications.
  • Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
  • Worked closely wif the data modeler and given suggestions for the model feasibility.
  • Participated in Data Mapping workshops and follow up meetings wif the client business and IT teams. Assisted in the data mapping and Gap analysis between source and target data in BODS as per the blueprint.
  • Installed and worked on the SQL server 2008 for the extraction of the source files.
  • Extracted source files in the CSV file format from the SAP BW by creating cubes.
  • Extracted source data from SAP BW 7.0 using the Data services as external tool.
  • Loaded data from multiple source systems into the SAP BW 7.0 by creating RFC connection.
  • Staged all data in the PSA Level based on the data mapping analysis.
  • Installed SAP Business objects data services 4.0 and created Local repositories.
  • Proposed Architecture and solution approach and developed the ETL design document.
  • Participated in Design discussions and developed low level design specification.
  • Worked on BODI Transformations like, Map Operation, Table Comparison, TEMPEffective Date, History Preserving, SQL, Key Generation, Query, Case, Merge, Validation, Pivot, Reverse Pivot, Row Generation Etc
  • Implemented SCD type 2 in the Data warehouse for the Dimension data.
  • Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations
  • Developed Validation using validation transform, case transform jobs to validate source system to identify data errors in staging.
  • Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and Data profiling process.
  • Developed test cases and implemented unit test and system integrated test. Jobs have run through test load Data and performed Data Validation and Data Reconciliation.
  • Also worked on the requirement gathering for the reporting and developed the mapping from the DW to report layout.
  • In Developing a micro strategy report we used existing Microsoft Excel Live reports and templates as a reference to identified the metrics and later met wif business user to identify calculation of them.
  • Worked on the Micro strategy tool to design the Live reports, Dashboards.

Confidential, Santa Clara, California

SAP BODS Consultant

Responsibilities:

  • Initiated DBA interactions for resource requirements and modifications.
  • Created new mappings and updated old mappings according to changes in Business logic.
  • Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
  • Participated in Data Mapping workshops and follow up meetings wif the client business and IT teams. Assisted in the data mapping and Gap analysis between source and target data in BODS as per the blueprint.
  • Designed and Developed High-level and Detail-level documentation of the project.
  • Worked wif functional teams closely to understand the gaps, coordinate wif business on specific business rules, work wif data conversion programmers on transformation rules and met project standards using proven data load tools and methodology.
  • Worked on the technical details for transforming existing data onto Oracle DB using tools such as BODS & Microsoft SQL server 2008. Modified and created new data services jobs wifin the existing target system to meet the project requirements.
  • Implemented SCD - Type me & II using normal transformations (Other TEMPthan Table comparison and History Preserving) in Data Integrator to increase performance. As a part of optimization used MAP operations to route update and insert records in the DW by creating the necessary indexes and Implemented incremental load process.
  • Designed and developed and done the unit test for all ETL routines in BODS.
  • Created new mappings and updated old mappings according to changes in Business logic. Performed major role in understanding the business requirements, designing and loading the data into data warehouse
  • Used Business Objects Data Integrator to load data from source system to multiple target systems based on requirement (ODS, DART and Downstreams)
  • Initiated DBA interactions for resource requirements and modifications
  • Used Business Objects Web Administrator to schedule and monitor Batch jobs
  • Defined Target Load Order Plan for loading data into Target Tables
  • Prepared Unit Test Cases.
  • Migrated all ETL Jobs and Data Base (Microsoft SQL server 2008 and Staging) into Production from Development Environment.
  • Handled several issues which came under production support.

Confidential, Bloomington, IL

SAP Data Migration Developer

Responsibilities:

  • Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
  • Created the Local Repositories, Secured Central Repositories, Profiler Repositories using Sql server 2008 database and configured the Local, Profiler repositories wif Job server and Management console.
  • Configured the Data services to connect to the SAP R/3, CRM and BI by using transport codes.
  • Move the projects from DEV to ST, ST to UAT and UAT to Production using ATL files.
  • Scheduled the Jobs in Management Console.
  • Participated in meeting wif SAP functional team to prepare functional mapping and to give suggestion that, wat we can achieve by using data services.
  • Prepared the functional mapping to CREMAS, DEBMAS, MATMAS idoc and prepared GAP analysis.
  • Created the data stores for SAP and Legacy (by using ODBC connection to underlying legacy data base which is DB2).
  • Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
  • Used the platform and data integrator transforms as a part of mapping.
  • Worked extensively wif Address cleanse (USA Regulatory certified address cleanse), Data cleanse, match transforms (Firm address match batch) for cleansing the legacy records in customer master, material master, vendor master.
  • Used the case, validation, merge transforms in validation process.
  • Worked on Enrichment process to give more detail level data to SAP.
  • Prepared Excel sheets (reference tables for Legacy fields to SAP fields) and worked on the Excel sheets by building logical connection in File formats.
  • Exposure to Data Services Architecture Data services objects, Data services design interface, Data stores, Importing metadata, File format.
  • Used the local repository metadata to build a universe (purpose is to generate reports on IDOC status and messages)

Confidential, New York, NY

SAP Data Migration developer

Responsibilities:

  • Created the Local Repositories, Central Repositories, and Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories wif Job server and Management console.
  • Configured the Data services to connect to the SAP R/3.
  • Installed & configured Data Services XI 3.1 SP1 in Development & Production Server.
  • Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
  • Extracted the data from IBM Main frames by creating data stores using ODBC connection based on the requirements.
  • Gathered information’s for getting the mapping to load the data into Customer Master IDOC(DEBMAS06) in meeting wif SAP functional team and Legacy team.
  • Using AIO CUSTOMER MASTER JOB, created the job to load into customer master segments.
  • Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform (to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
  • Used the case, validation, merge transforms and lookup function to validate the customer master basic data (to find whether that record already exist in SAP or not).
  • Using the ABAP dataflow, extracted the data from R3 table and generated the lookup tables.
  • Implemented the Data Enrichment step as per the AIO schema.
  • Used WE05 transport code to check the IDOC status.
  • Created the WEBI reports to generate the status of IDOCs using SQL Server database (repository tables).

Confidential, West Kingston, RI.

ETL/ BO Developer

Responsibilities:

  • Based on the requirements, extracted the data from ECC 6.0, Legacy and loaded into BW 7.0 using Data Services.
  • Implemented Slowly Changing Dimensions - Type me & II in different mappings as per the requirements.
  • Interacted wif Users to no their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
  • Converted business requirements in business/technical requirement documents.
  • Technical expertise in Analyzing, Design, Implementation and administration of security models wif row level data security, role based security etc in Business Objects.
  • Installed and configured Business Objects XI 3.1 on Windows wif Web logic
  • Designed, developed, deployed and maintained universes used Business Objects designer.
  • Installed and configuredBusiness ObjectsDataServices (Business Objects DataIntegratoror BODI)in a multi-tier environment.
  • Experience of data services security and configuring SSL for data services components.
  • Experience of data services user security and management.
  • Worked on all the options in designer user interface of data services.
  • Tuned and Enhanced Universes wif SQL Queries for the Report Performance.
  • Worked on Data Integrator which provides an easy to use, graphical design environment that includes data cleansing tasks.
  • Worked on Data Integrator which delivers enhanced data cleansing, data enhancement, and match/consolidate features through seamless integration wif First logic technology.
  • Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
  • Strong Data Warehousing and analysis skills including,OLTP, OLAPRelationalandDimensionalmodeling skills (star schemaandsnowflake schema).
  • Worked as primary support for production environment.
  • Created Web Intelligence reports Ad-hoc reports.
  • Tuning the queries to improve the performance of the report refresh time.
  • Created Universes and complex reports against huge Oracle database.
  • Created user defined @prompts and complex conditions at Universe level for better performance.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Identifying and Removing Bottlenecks in order to improve the performance of Dashboards and Reports.
  • Good Knowledge of Creating the Target tables and defining the sources of data in the data Federator.
  • Worked on mapping the data sources to targets using the data federator
  • Worked closely wif DBAs to create aggregate tables to support Universes and dashboard.
  • Implemented Open Doc to drill down to detail WEBi report from Xcelsius Dashboard.
  • Exported Xcelsius to repository to make it available for users through info view.
  • Used relative path URL to migrate Xcelsius Dashboards from one environment to other Environment.
  • Created WSDLs using Query as a Web Service (Qaaws) from different Data sources.
  • Deployed configuration on all Development, Test, SIT, UAT and Production Environments.
  • Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard and BIAR file methodology
  • Technical expertise in Analyzing, Design, Implementation and administration of security models wif row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
  • Designed, developed, deployed and maintained universes using Business Objects designer.
  • Implemented row level Security, object level Security at the Universe level for security purpose.
  • Created customized Web Intelligence reports from various different sources of data.
  • Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
  • Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
  • Worked closely wif DBAs to create aggregate tables to support Universes and dashboard.
  • Worked extensively wif @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions and setup Hierarchies for Multi dimensional Analysis.
  • Installed Crystal Xcelsius 2008 and developed dashboards using various components.
  • Created WSDLs using query as web services and implemented WSDLs into dashboards
  • Created WSDLs using Query as a Web Service (Qaaws) from different Data sources.
  • Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.

Confidential

SAP BW Developer

Responsibilities:

  • Worked extensively on BEx Analyzer for creating Queries, modifying and navigating through the result of a query and filter data. Worked on Key Figures for currency translation and defining restricted Key Figures.
  • Extended Info Sources wrote transfer rules and update rules. Built and loaded cubes, validated results.
  • Designed cubes to accept multiple Info Sources. Extracted Meta data, master data and transaction data. Wrote complex transfer rules and update rules. Maintained data in ODS. Configured and loaded all LIS tables, setup Meta data and master data transfers, activated all Info Objects, Info Sources and Cubes. Created custom LIS Info structure, Info Objects, Info Sources and Info Cube. Performed Meta data transfers, extracted data and reconciled the Info Cubes.
  • Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx. Created custom Info Cubes including Update Rules. Created Info Package and populated Info Cube wif full update.
  • Assigned queries to different User Catalogs using BEx. Developed Excel workbooks for publishing views on the Web. Developed selection screen for the reports using filter parameters for the BW query using JavaScript.
  • Activated Info Object, Info Catalogs. Defined Info Source, updated Meta data, maintained and activated Communication structures, maintained Transfer Rules. Transfer routines were specified for period conversions.
  • Created Info Package and populated Info Cube wif full update.
  • Worked wif RRI (Report to Report interface) between ODS object and Info Cube.
  • Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting. Assigned queries to different User Catalog on client specification.
  • Developed queries and executed using Business Explorer Analyzer.
  • Worked wif business people to establish analysis requirements and functional specialists to locate data sources.
  • Responsible for training customers in both the configuration and utilities provided by the Business Information Warehouse.
  • Extensively worked wif flat file (text, excel) loading for transaction data, attributes, texts and hierarchies.
  • Successfully Installed the Business Objects Integration kit.
  • Created the Universe Using the Info cubes, BEx queries.
  • Got the corporate training on newly introduced Cascading prompts and Implemented in Webi reports.

We'd love your feedback!