SUMMARY

• Over 10+ years of IT experience in Data Warehousing, SAP Data Migration, Data Cleansing using and Business Objects Data Services(BODS, Informatica, BO Reporting Tools, WEBI, Crystal.
• Expertise in Data Analysis, Design, Modeling, Development, Testing and Implementation of Data Warehousing Applications, Data integration, Data cleansing, Data Governance.
• Expertise in Data Warehouse Implementation.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS) and Data Marts, using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions.
• Installed & configured Data Services XI 3.2 and Upgraded from Data Services XI 3.2 to 4.0.
• Extensively worked on integration of Business Objects Data Services with SAP MODULES (Finance, HR & CRM) and Non - SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2008/2005/2000, DB2, JD Edwards MainFrames, Flat Files and Legacy System files.
• BODS/DataQuality in design of work flows, data flows, scripts and complex transforms using different data integrator, platform and data quality transforms.
• Expertise in BODS code migration using Check-In/Out of Central/Local Repository.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor, and error) and by examining the target data.
• Extensively used Data Services Management Console to schedule and execute jobs.
• Expertise in data warehousing techniques for data cleansing, Slowly Changing Dimensions (SCD) phenomenon, surrogate key assignment and Change Data Capture (CDC).
• Involved in design, development, optimization and maintenance of BODS jobs to extract data from various sources to data marts/data warehouse various SAP modules through IDOCS.
• Experience in working with ABAP dataflows to extract the data from SAP Applications.
• Extensive knowledge of AIO Methodology (SAP RDS Package) for Data Migration Process & working with RDS templates in Data Services for Data Migration and Data Warehousing, Loaded data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS by referencing SAP AIO/RDS jobs.
• Experienced in loading Data from SAP/Non-SAP/Excel sources to ECC using either BODS (IDOCS/ BAPIs) or using pre built Programs/ LSMW. Experienced in Fetching Data from ECC Using ABAP Data Flows.
• Worked on Information Steward cleansing packages to build the business rules in Information Steward.
• Extensive experience in installing and configuring Information Steward 4.0.
• Experience in profiling the data using Information Steward 4.0 (Data Insight), Data Insight 3.0.
• Experience in profiling and metadata management using information steward 4.0.
• Performed address, dependency, redundancy and uniqueness profiling using Information Steward 4.0 for data profiling.
• Worked on scheduling, rescheduling, monitoring, modifying utilities in Information Steward 4.0.
• Wide knowledge on Information Steward 4.0 utilities like calculate scorecard, compute lineage report, purge, update search index.
• Worked on validation rules, complex validation rules and rule bindings on Information Steward.
• Worked on Matapedia category and on creating custom cleansing package using Information Steward 4.0.
• Architecture and designed Data Quality dashboards for sectors and regions implementing SAP Information Steward Data Insight Functionality.
• Worked on Data Quality concepts and familiarity with setting up Data Cleanse, Address Cleanse, Match and Associate transforms.
• My experience includes system support, performance tuning, backup and recovery, space management, maintenance and troubleshooting.
• Prepared test scripts and test cases to validate data and maintaining the data quality.
• Experience working with Open Hub Services to push data out of SAP BI using Data Services.
• Configured the Data services to connect to the SAP R/3, CRM and BI.
• Has thorough knowledge on Legacy System Migration Workbench (LSMW).
• Experience in Data migration and BI using Oracle, SQL Server, Actuate and BIRT.
• Ability to understand the business environment and translate business requirements into technical solutions.
• Excellent communication with exceptional problem solving, including technical writing, presentation and strong interpersonal skills with the ability to interact with end-users, managers.

TECHNICAL SKILLS

SAP Application: SAP BI 7.0, ECC 6, SAP BW 3.5, BO 4.0, XI 3.1.

ETL Tools: SAP BO Data Services 3.2.4.0, 4.1, Informatica.

Languages: BI- ABAP.

Source Systems: R/3 4.7, ECC 6.0, Legacy System, Flat file.

Reporting Tools: Bex, BO Webi.

Operating Systems: Windows95/98/XP/Vista/7, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Sr SAP BODS Lead consultant

Responsibilities:

• Extracted data from ECC,MDM and uploaded to Ariba System through BODS.
• Worked for the extraction of invoice, Purchase, Suppliers and Vendors for the spend Analytics.
• Designed batch jobs using Business Objects Data Services 4.2 to generate load files.
• Created tab delimited flat files ready for LSMW to upload data in to SAP ECC to validate these flat files using LSMW, worked with ABAP resources.
• Prepared Error reports with rejected records and sent to Business users for review and reprocess.
• Develop conversion programs using ABAP and LSMW.
• Involve in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Lead and support the data migration strategy and processes to enable efficient and effective deployment data conversion.
• Worked on Hana SDI /SDA models.
• Worked on the SAP ECC,SAP BW, Non SAP systems data ingestion into cloud storages, cassandara system.
• Extracted data from ECC, BW to MS SQL.
• Defined the business rules in information steward for the dashboards.
• Experience in building Operational Data Store (ODS) and Data Marts, dimensional modeling techniques with Kimball.
• Worked in mentoring the team for the best practices, guidelines for process improvement, reliability and Data Correctness.
• Performed gap analysis from technical perspective and provide best practices recommendation
• Worked extensively with ABAP data flows, ECC Extractors and ABAP developers to work through the development and issue resolutions
• Worked with BAPI/IDOC integration using BODS to Extract or Load data.
• Worked in Data Quality for the customer data like geocoding Address directories.
• Migrated data from different source systems to MS Sql and doing reporting according to the business needs.
• Worked on Customer Master Address cleansing for US and Canada data on business and individual customers.
• Worked on Information Steward cleansing packages to build the business rules in Information Steward.
• Responsible to setup SAP BODS/BOIS data connection.
• Extensive experience in installing and configuring Information Steward.
• Experience in profiling the data using Information Steward (Data Insight), Data Insight .
• Experience in profiling and metadata management using information steward.
• Performed address, dependency, redundancy and uniqueness profiling using Information Steward for data profiling.
• Worked on scheduling, rescheduling, monitoring, modifying utilities in Information Steward.
• Wide knowledge on Information Steward 4.0 utilities like calculate scorecard, compute lineage report, purge, update search index.
• Actively interacted and procured requirements from business.
• Performed profiling (column, redundancy, uniqueness) on tables from databases (MS SQL SERVER, ORACLE, SAP HANA Informix) and Applications (SAP BI).
• Provided required inputs to different project group working on Metapedia and Metadata management functionalities of Information Steward.
• Built and trouble shoot various ETL work flows involving standardization and match criterion using SAP Data Services.
• Built a custom cleansing package for name standardization using Information steward Cleansing Package Builder Functionality.
• Expertise on Material Master data for objects such as materials, customer, vendors migrate data from legacy systems to ECC.

Environment: SAP HANA, SAP ECC, SQL, DB2, ABAP/4, SAP BO 4.0, SAP BODS 4.2

Confidential, San Diego, CA

Sr SAP BODS/HANA Consultant

Responsibilities:

• Extracted data from MS Sql,Oracle to HANA through BODS.
• Worked on Hana SDI /SDA models.
• Extracted data from ECC,BW to MS SQL.
• Experience in building Operational Data Store (ODS) and Data Marts, dimensional modeling techniques with Kimball.
• Worked in mentoring the team for the best practices, guidelines for process improvement, reliability and Data Correctness.
• Performed gap analysis from technical perspective and provide best practices recommendation
• Worked extensively with ABAP data flows, ECC Extractors and ABAP developers to work through the development and issue resolutions
• Worked with BAPI/IDOC integration using BODS to Extract or Load data.
• Worked in Data Quality for the customer data like geocoding Address directories.
• Migrated data from different source systems to MS Sql and doing reporting according to the business needs.
• Worked on Customer Master Address cleansing for US and Canada data on business and individual customers.
• Worked on Information Steward cleansing packages to build the business rules in Information Steward.
• Responsible to setup SAP BODS/BOIS data connection.
• Extensive experience in installing and configuring Information Steward.
• Experience in profiling the data using Information Steward (Data Insight), Data Insight .
• Experience in profiling and metadata management using information steward.
• Performed address, dependency, redundancy and uniqueness profiling using Information Steward for data profiling.
• Worked on scheduling, rescheduling, monitoring, modifying utilities in Information Steward.
• Wide knowledge on Information Steward 4.0 utilities like calculate scorecard, compute lineage report, purge, update search index.
• Actively interacted and procured requirements from business.
• Performed profiling (column, redundancy, uniqueness) on tables from databases (MS SQL SERVER, ORACLE, SAP HANA Informix) and Applications (SAP BI).
• Provided required inputs to different project group working on Metapedia and Metadata management functionalities of Information Steward.
• Built and trouble shoot various ETL work flows involving standardization and match criterion using SAP Data Services.
• Built a custom cleansing package for name standardization using Information steward Cleansing Package Builder Functionality.
• Expertise on Material Master data for objects such as materials, customer, vendors migrate data from legacy systems to ECC.

Environment: SAP HANA, SAP ECC, SQL,DB2, ABAP/4, SAP BO 4.0, SAP BODS 4.2

Confidential, Portland, OR

Sr SAP BODS-IS/HANA Consultant

Responsibilities:

• Sr. BODS Consultant working multiple projects as ETL developer.
• Worked with the basis team to Install and configure BODS with ECC 6.0
• Created tab delimited flat files ready for LSMW to upload data in to SAP ECC to validate these flat files using LSMW, worked with ABAP resources.
• Prepared Error reports with rejected records and sent to Business users for review and reprocess.
• Develop conversion programs using ABAP and LSMW.
• Involve in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Lead and support the data migration strategy and processes to enable efficient and effective deployment data conversion.
• Developed the workflows to load the data into Customer Master Sales data(KNVV) and Patner roles(KNVP) from legacy systems.
• Developed jobs to load the Legacy system data into COND A04 IDOC(KOMG, KONH, KONP segments) by referencing the SAP AIO SD pricing job.
• Extracted data from DB2, Sql to HANA through BODS.
• Worked on HANA SDI/SDA models for the POC projects.
• Created flow graphs in the HANA and configured the remote sources in the Provisioning of DP Agent.
• Implementing the Data warehouse data as data marts using Dimensional modeling techniques such as Kimball.
• Extracted data from DB2,ECC,Sql and created views for the reports.
• Worked in mentoring the team for the best practices, guidelines for process improvement, reliability and Data Correctness.
• Performed gap analysis from technical perspective and provide best practices recommendation
• Worked on the POC to extract data by using standard ECC extractors and load to staging
• Build solutions to extract data for various data objects FI-GL, FI-AP, FI-AR data from SAP ECC.
• Worked extensively with ABAP data flows, ECC Extractors and ABAP developers to work through the development and issue resolutions
• Worked with BAPI/IDOC integration using BODS to Extract or Load data.
• Worked in Data Quality for the customer data like geocoding,Address directories.
• Worked on HANA models as per the business requirements.
• Worked on Customer Master Address cleansing for US and Canada data on business and individual customers.
• Worked on Information Steward cleansing packages to build the business rules in Information Steward.
• Responsible of guide the basis team for configuration in development environments the PostgreSQL ODBC driver and connection for SAP BODS/BO IS server.
• Responsible of setup the BODS JOB test scenarios for integrate SFDC, PostgreSQL, Oracle and Teradata.
• Responsible to setup SAP BODS/BOIS data connection.
• Responsible to setup and documented SAP Information steward connection with PostgreSQL and Teradata.
• Extensive experience in installing and configuring Information Steward 4.0.
• Experience in profiling the data using Information Steward 4.0 (Data Insight), Data Insight 3.0.
• Experience in profiling and metadata management using information steward 4.0.
• Performed address, dependency, redundancy and uniqueness profiling using Information Steward 4.0 for data profiling.
• Worked on scheduling, rescheduling, monitoring, modifying utilities in Information Steward 4.0.
• Wide knowledge on Information Steward 4.0 utilities like calculate scorecard, compute lineage report, purge, update search index.
• Worked on validation rules, complex validation rules and rule bindings on Information Steward.
• Worked on Matapedia category and on creating custom cleansing package using Information Steward 4.0.
• Architecture and designed Data Quality dashboards for sectors and regions implementing SAP Information Steward Data Insight Functionality.
• Actively interacted and procured requirements from business.
• Performed GAP analysis across various projects throughout the Organization.
• Installed and configured SAP Data Services 4.1 and SAP IS 4.0.
• Administered SAP Information Steward which includes building security matrix, creating custom groups and roles to data stewards based on their regions and responsibility.
• Performed profiling (column, redundancy, uniqueness) on tables from databases (MS SQL SERVER, ORACLE, SAP HANA Informix) and Applications (SAP BI).
• Dealt with Master and Transactional tables.
• Provided required inputs to different project group working on Metapedia and Metadata management functionalities of Information Steward.
• Built and trouble shoot various ETL work flows involving standardization and match criterion using SAP Data Services.
• Built a custom cleansing package for name standardization using Information steward Cleansing Package Builder Functionality.
• Trained and introduced the possibilities of SAP Information steward to current Data Quality team and the impact of replacing current process of generating DQ dashboards.
• Expertise on Material Master data for objects such as materials, customer, vendors migrate data from legacy systems to ECC.
• Worked extensively material master objects such as basic data purchasing, sales, accounting.
• Installed address directories, build cleansing rules logic to BO Data Quality.
• Build continuous improvement process around customer master data by build exception reports and providing dashboard reporting on data health.

Environment: SAP HANA, SAP ECC, SQL,DB2, ABAP/4, SAP BO 4.0,SAP BO WEBI. SAP BODS 4.2.

Confidential, Houston,TX

Sr BODS Consultant

Responsibilities:

• Sr. BODS Consultant working multiple projects as ETL developer.
• Trained ETL team (used to Informatica formerly) on Data Services specifically on Data quality transforms such as Cleanse and Match.
• Has experience in SAP implementation with Winshuttle as data load tool.
• By using Kimball methodology implemented the data marts for the business areas as data warehouse data and generating the reports for the business.
• Worked with the basis team to Install and configure BODS with ECC 6.0 and SAP BI/BO 4.0
• Performed gap analysis from technical perspective and provide best practices recommendation
• Worked on the POC to extract data from SAP Open Hub tables.
• Worked on the POC to extract data by using standard ECC extractors and load to staging
• Build solutions to extract data for various data objects FI-GL, FI-AP, FI-AR data from SAP ECC and SAP BW to load the Staging for downstream reporting.
• Experience in profiling the data using Information Steward 4.0 (Data Insight), Data Insight 3.0.
• Experience in profiling and metadata management using information steward 4.0.
• Performed address, dependency, redundancy and uniqueness profiling using Information Steward 4.0 for data profiling.
• Worked on scheduling, rescheduling, monitoring, modifying utilities in Information Steward 4.0.
• Wide knowledge on Information Steward 4.0 utilities like calculate scorecard, compute lineage report, purge, update search index.
• Worked on validation rules, complex validation rules and rule bindings on Information Steward.
• Worked on Matapedia category and on creating custom cleansing package using Information Steward 4.0.
• Extracted the GL data from open hub tables in BW to provide to downstream BI
• Worked extensively with ABAP data flows, ECC Extractors and ABAP developers to work through the development and issue resolutions
• Worked with BAPI/IDOC integration using BODS to Extract or Load data.
• Worked with data governance for master data objects in sap MDM, sap BODS,Data quality and information steward.
• Worked on Customer Master Address cleansing for US and Canada data on business and individual customers.
• Worked on Information Steward cleansing packages to build the business rules in Information Steward.
• Expertise on Material Master data for objects such as materials,customer,vendors migrate data from legacy systems to ECC.
• Worked extensively material master objects such as basic data purchasing,sales,accounting.
• Installed address directories, build cleansing rules logic to BO Data Quality.
• Build continuous improvement process around customer master data by build exception reports and providing dashboard reporting on data health.

Environment: SAP HANA,SAP ECC, ABAP/4, SAP BO WEBI, SAP BODS 4.0, 4.2

Confidential - Newark NJ

Sr. BODS Consultant

Responsibilities:

• Worked on around 70 objects in Data Migration including both Master and Transactional Data.
• Involved in 5 Go-lives, cut over weekends during Business critical golives for all objects.
• Worked as a cut-over lead in Golives, working on Business critical timelines with users.
• Worked with SAP MM, PM (Plant Maintenance), SAP FI, controlling teams on Data Migration.
• Worked on complex objects like BOM(Bill of Materials), Purchase orders, Sales orders, Inventory Management,Maintance - Orders, Project Systems, Project Journals, Budgets and Settlement rules.
• Installing and maintaining the SAP Business Object Data Services 4.0/XI 3.2, and Global Address Cleansing packages, with Oracle database on Development, Test and Production environments.
• Experience in extracting data from various data sources like SAP R/3, Fixed Width and Delimited Flat Files, Oracle, SQL Server, DB2.
• Extensively worked on ABAP Dataflow to extract data from SAP R/3 4.6C to staging tables.
• Involved in Customer Master, Vendor Master, Source List, Sales Order and Vendor Contracts objects development and creating IDoc files.
• Used SAP Best Practices AIO Methodology (BPDM) in data migration.
• Modified Jobs, Work flows and data flows to apply mapping rules as per mapping document.
• Used Data Integrator and plat form transforms like, Query, Merge, Validation, Row-Generation, Key Generation, Pivot, Case, Table-Comparison, History Preserving and SQL.
• Used Data Quality transforms like Data cleanse, Match and Global Address cleanse to perform cleansing on Master Data Objects.
• Closely worked with ABAP developers to upload IDoc files into ECC 6.0.
• Prepared Error reports and sends to the Business users.
• Designed batch jobs using BO Data Services 3.2/Data Quality for Vendor Master and Customer Master data cleansing.
• Extracted from different sources, cleansed, converted and loaded the data into BW system.
• Worked on both Dev, QA and Production Environments, moving jobs to Central repository.
• Providing Reconciliation reports to the client before and after load of the data.
• Used SAP function modules in Data services to extract Text from SAP 4.6C to staging tables.
• Created tab delimited flat files ready for LSMW to upload Recipes, Vendor and Customer text into ECC 6.0.To validate these flat files using LSMW, worked with ABAP developers.
• Worked on Purchase orders Long text through BODS and handled Carriage returns and line feeds and loaded data in ECC.
• Performed SAP Data management activities such as data assessment, cleansing, outlining strategy approach, process and policy the data migration plan.
• Worked on Information Steward cleansing packages to build the business rules in Information Steward.
• Conducted pre and post load sessions with business users for data validation.
• Implemented the quality rules in Information Steward 4.0 and BODS 4.0
• Used HP Quality Center to track the defects.
• Prepared technical specification document.

Environment: BODS 3.2, 4.0, SAP ECC 6.0, SAP BI7.3, Bex Designer, WAD, BOBJ 4.0

Confidential, Seattle, WA

Sr. BODS Consultant

Responsibilities:

• Sr. BODS developer supporting ETL for EDW and Data migration efforts.
• Implemented the data warehouse data marts in EDW by using the modeling Kimball methodology.
• Created Data Flows to load data from flat file, CSV files with various formats into Data Warehouse.
• Involved in creating batch jobs for data cleansing and address cleansing.
• Involved in creating the batch jobs for de-duplicating the data for different sources.
• Worked on making full load jobs in to incremental loads using Map Operation, Table Comparision and Auto Correct Load.
• Worked to Reverse Engineer code build in IBM DataStage to convert to BODI/BODS ETL code.
• Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in order to load data from source to Target Systems.
• Extensively used lookup, lookup ext functions in Data Integrator to load data from source to Target using a transform Table.
• Designed & developed error catching procedures in BODI jobs.
• Scheduled and Monitor jobs using Data Integrator Management Console.
• Defined separate data store for each database to allow Data Integrator to connect to the source or target database.
• Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the Local and Global Variables.
• Created and administered Local and Central Repositories for multi user environment.
• Migrated and tested jobs in different instances and validated the data by comparing source and target.
• Automating all error handling, error escalation, and email notification procedures.
• Generated several Metadata reports for Data Integrator mapping, and job execution statistics.
• Worked on Reporting using Actuate, Crystal Reports and BO WEBI XI 3.1, 3.2.

Environment: SAP BODS 3.2, 4.0, SAP ECC, BW 7.3, B O 4.0, WebI, BEx Query Designer

Confidential, Durham, NC

Sr. BODS Consultant

Responsibilities:

• Sr. BODS Consultant supporting ETL development for data migration, data quality and Integration
• Implemented / Customized Project (pre-built for Plant Maintenance and Cost Center), WSR Project, Scorecard Project and process of Data Migration.
• Worked in mentoring the team for the best practices, guidelines for process improvement, reliability and Data Correctness.
• Handled Administration tasks like Installation / Configuration / Up-gradation of Data Services from 12.2.0.0 to 12.2.2.0 components (Job Servers, Repositories), User / User Groups, Data Profiling and Data Cleansing, Code Promotion / Version Management using Central Repository.
• Analyzed data in source systems to assess data cleanliness and make recommendations for addressing within the source systems or as part of the ETL process, responsible for error handling, and performance tuning of Jobs.
• Worked on POC implementation of HR Rapid Mart for People Soft performed GAP Analysis and configuration of BO Data Services to handle data in and out of People Soft ERP System.
• Handled data quality to address cleansi0ng name cleansing and de-duplication based on the business rules, installing and configuring data quality address directories for cleansing various country related data.

Environment: Business Objects Data Services (3.2) for ETL 12.2.0.0/12.2.2.0, SQL Server 2005/2008, Windows 2008/XP, ER-Studio.

Confidential, Dallas/Fort Worth, TX

ETL Developer

Responsibilities:

• Involved in requirement gathering and database design, data modeling using Erwin.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2005 Integration Services (SSIS).
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like For Loop Container, For each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Triggers (Instead Of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Created Linked Servers to retrieve data from other databases.
• Monitored and modified Performance using execution plans and Index Tuning.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: Business Objects Data Integrator Rapid Marts 11.5.2.0, Business Objects 6.5, Oracle 9i, SAP R3 4.7 on UNIX, Windows XP.

Confidential, Webster, NY

SAP BI Associate Consultant

Responsibilities:

• Worked extensively on LO-COCKPIT for Loading data into the Standard Cubes.
• Monitoring the Roll-ups and Compressions while loading the data into the Info cubes.
• Base work for the performance tuning which includes fact table partitioning, PSA partitioning.
• Scheduled the data packet size in SAP R/3 according the business requirements.
• Scheduled and monitored periodic data loads from R/3 to BW.
• Monitoring the errors and handling them manually when needed.
• Extensively worked on Design and Development of Cubes, ODS objects, Info objects, Multiproviders, Datasources and Infosets for reporting on Sales Order Data, Purchase Contracts, and inventory management
• Involved in Partitioning and un partitioning cubes to improve performance.
• Developed web based queries for the users within the intranet, used HTML for customizing the reports.
• Extensively worked on fine-tuning of the reports, used various tuning techniques which include building aggregates, Routines, Function modules and also data distribution.
• Developed flexible queries using navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Used ODS to stage the data before transferring the ODS contents to the Info cubes.
• Developed ODS report to give details of delivery items and schedule line items.
• Worked in retracting BW data to open Hubs.
• Changing of existing queries to suit the client requirements.

Environment: SAP BW 7.0, SAP R/3 Enterprise 4.7, SD, HR, FICO, MM, Inventory, BEx Query Designer, Web Application Designer