SUMMARY:

• 8+ Years of Experience in SAP HANA, SAP BW 7.3, Business Objects 4.0, WebI, Crystal Reports, Celsius, SAP BODS 4.0, SAP ECC (R/3), SQL server for various types of industries. Involved in multiple Full life cycle Implementations that includes business process prototyping, blueprinting, requirements gathering, RFP (Request for Proposal), development, configuration, testing and validation, go live, production support and training, full End - to-End lifecycle implementation of SAP HANA.
• SAP BI/BOBJ 4.0/BODS: Expertise in integrating BOBJ reporting tools includes WEBI, Crystal Reports, Xcelsius/Dashboard Design, Explorer, Business Layer, and Data Foundation in the Universe/Information Desgin Tool. Completed multiple full End-to-End BOBJ lifecycle implementations. Extensive experience in loading and data staging of SAP and non-SAP data
• SAP HANA/Hadoop: Expertise in full End-to-end HANA life cycle implementations including ECC, BODS, HANA PL/SQL, BW, T-SQL Information Design Tool and WEBI/ Crystal/ Dashboard on the reporting side. Hands-on experience in data movement including SLT, BOBJ Data Services and HANA modeling. Maintained the parallel database processing using various Hadoop and data integeration technologies like mapReduce, Hive, Datameer etc.
• Expertise in SAP BI 7.X/BW 3.X (Data Modeling, Extraction, Transformations, Loading & Scheduling) and developing its components including Info Objects, Data Sources, DSOs, Info Cubes, Transformations, DTP’s, Update/Transfer routines, User Exits, Function Modules, BEx components and among others.
• Expertise in BOBJ Reporting including Universe Designer, Crystal reports and WEBI reports, All aspects of the SAP implementation lifecycle, and a solid grasp of the ASAP methodology. Highly skilled in designing functional, technical specifications and process implementation roadmaps for business requirements.
• Good understanding of Business Planning and Consolidation (BPC 10); including planning, consolidation and Intercompany, Ownership etc.
• Expertise in Data Source Enhancement, Generic Extractors, User Exits, Data Loading, Scheduling, Monitoring, Process Chains, Multi Providers, Info Sets, Remote Cubes, Data Mart and Open Hub Service.
• Experienced with creating aggregates, compression and partitioning, BW Upgrade and Performance Tuning in BI/BW, Net weaver 2004s environment and migration from BW 3.5 to BI 7.3. BW Report Design, Query Design, KPI Reporting, Testing, and Performance Tuning
• Worked on building Universes on BEx Queries and Reports generation using Crystal Reports, ASAP methodology and procedures of SAP R/3 implementation, CRM, FSCM, ECC, SCM, APO FI-GL, AP, AR, AA & CO-PA and HR/IP, PLM, Billing and Direct management modules.
• Crystal/WEBI Reports: Extensive Experience in developing reports in Crystal reports XIR2 using Business Views and Xcelsius and expert in creating multifaceted Ad-Hoc reports using Business Objects, Web Intelligence and Desktop Intelligence and designing of Dashboards in Xcelsius. Completed several crystal report projects at major customer sites. Major responsibilities include getting requirements from the user and developing Crystal Reports. Maintaining proper documentation of the reports for future reference.
• Experience in assigning user roles groups, adding users to the groups, access security rights. Worked on creating and maintaining users in the LDAP /Windows Active Directory and providing them single sign-on capabilities using Kerberos and Linux/Windows system.
• Provided technical/functional and analytical expertise in responding to complex, specialized report, Training & Supporting End-Users requests requiring higher-level data analyses and data management services

TECHNICAL SKILLS:

Data Warehouse: SAP HANA, BW 7.3/7.1 & 3.5, BPC 10, Essbase

ERP: SAP ECC 6.0,5.0, R/3, CRM, FSCM, SD/MM, HR, APO, FICO, COPA, PCA, HR and Logistics.

Reporting Tools: SAP BODS 4.0 BO 4.0 - BI & Data Services, BO XI 3.1 - Web Intelligence, Crystal Reports, BEx, XCelsius, Financial Reporting, Informatica, OER

Languages: ABAP/4, C, C++, JAVA, SQL, PL/SQL, VB.

DBMS: Oracle 9i, T-SQL, MS-SQL Server, MS Access

Operating Systems: Windows 2003/2000/ XP, Linux, Mac

Web Technologies: HTML, DHTML, XML, JavaScript, XI, Net Weaver

Other: MS-Office, Remedy, HPQC

PROFESSIONAL EXPERIENCE:

Confidential, NY

SAP BI BW BOBJ HANA Consultant

Responsibilities:

• The objective of SAP BI-BO Project was to come out with operational reporting for BI systems for business areas SAP HR,FI CO,SRM,CRM,MM,SD,PP.
• Using SAP BO different Web Intelligence, Xcelsius dashboards for business areas Human Resource, finance, operations where developed.
• Enhanced existing Multi providers & Info sets, Cubes.
• Understanding the business process and reporting requirements by interacting with Sr. line Managers, Business heads Sr. Business analysts of client.
• Extensive work in reporting using BEx Query Designer, Analyzer, Web Application Designer (WAD).
• Involved in POC development using Design studio to create mobile reports.
• Worked extensively on the BO 4.0 tools like Dashboard, WebI, Analysis for Office.
• Extensively worked with ABAP on Update Rules, Transfer Rules and User Exits.
• Preparation of ERP specifications, Functional Specifications, Technical Specifications, Gap Analysis.
• Daily Monitoring of complex Process Chains
• Taking care of Daily / Weekly / Monthly Jobs as per client requirements.
• Troubleshooting the process chains and keeping track of the issues that occur and identify to find long term solutions for them.
• Involved in Handling change requests, tickets & solved performance related issues.
• Handled On site - Off shore Model. Handled a Team of six, assigned work direction to consultants and lower level analysts.
• Maintenance of documentation of the daily loads, process chain status, etc. •Extensive work in extracting data from SAP R/3 using LO Cockpit, FI-SL, CO-PA and generic extractors. OLTP Extraction (Transaction Data, Master Data Attributes, Text, Hierarchies).
• Extensive work in data modeling of Info Cubes, ODS, Info Objects, Info Sources, Data Sources. Customized standard business content extractors and enhanced Data Sources in various applications using User Exits.
• Involved in the upgrade of backend components to BI 7.4.
• Involved in creating Proof of Concept for the new Front end features in BI 7.4
• Involved in migrating reports from 3.X to BI 7.0, identified and resolved issues in the migration.
• Independently handled Unit testing, Integration testing, and User acceptance testing (UAT).
• Extensively involved in preparing User Manuals and Business User training of Department heads, directors, and senior managers.
• Checking data consistency, aggregates and hierarchies through RSRV.
• Configured security roles and authorizations for both BW objects and reports.
• Performance tuning by maintaining Aggregates, Compression, Partition, indexing of info cubes and use of statistics for the same. SAP BI-BO Roles

Confidential, PA

SAP BI BW BOBJ Consultant

Responsibilities:

• Involved in 2 full lifecycles of BI/BW 7.3/7.31 implementations and involved in all levels of BI/BW implementation such as Data Modeling, Extraction and Reporting.
• Extensively worked on the configuration and developing cubes in BW7.3 using SAP SSM.
• Involved in giving training to power users and team with new components of BW 7.3/BO 4.0.
• Have good understanding of the Function modules like CRM, FICO, COPA, PCA, APO, SD/MM. SRM,FSCM, ECC, SCM.
• Worked with business for requirements gathering configuration design
• Worked heavily on CRM Activity, Opportunity and Complaints extractors to develop CRM-BW cubes and also build reports on top of it.
• Worked on the CRM Extractors ( 0CRM SALES ACT 1, 0CRM OPPT H, 0CRM OPPT I, etc)
• Worked on the FICO extractors ( 0CO OM CCA 1/2 COSP, COSS, 0CO OM CCA 3 COSL, COKL, 0CO PC PCP 01/02 KEKO, TCKH3, TCKH8, 0CO PC PCP 03 CKIS, T001K, TKA02, KEKO, MARA, MBEW)
• Worked on FI- AR cube for enhancement of the standard datasources to accommodate the Credit/Collection management fields and also build reports on top of it.
• Worked on SRM Purchasing Reporting on 0BBP SC, 0BBP SCA, 0SR MC01.
• Developed Disputes and Collection Management cubes as full development from scratch and also build Bex/ BOBJ reports on top of it.
• Worked on developing BO 4.0 reports using IDT, Dashboards, WEBI tools.
• Developed reports on BO 4.0 starting from requirement gathering, developing and testing and improving the performance of the reports.
• Worked extensively on ABAP building generic datasroucs, views, infoset query, customer user exit, start routines, end routine and expert routines, variables exits, BADI etc
• Gathered and analyzed the requirement to replicate the ECC content in HANA usingdata provisioning.
• Performed datamodeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed SQL script and T-SQL bases stored procedures for data intensive based models.
• Configured SAP FSCM system for Dispute cube and Multiprovider involves archiving and BWA.
• Created process chain on Master Data, Text, Hierarchy, Business Partner, and CRM Marketing Element etc.
• Worked on the enhancement of the FI AR to include the Credit/Collection Management fields to the DSO, Cubes and the Multiprovider
• Extensive work in data modeling of infocubes, DSO, info Objects, Infosource, Datasources, Customized and business content extractors and enhanced Datasources in various application using User Exits.
• Enhanced Data Sources and created Generic Data Sources using Infoset query as part of extraction.
• Extensively worked with ABAP on Update Rules, Transfer Rules, Start and End routine.
• Conducted and performed Performance tuning Techniques (Aggregates, Cube Compression, Line Item Dimension, and Indexing) for improving the Reporting.
• Expert in creating Process Chains for Automation of process and better performance.
• Expert in Report Generation as worked extensively in BEx Analyzer in building Queries and and created custom Queries using Conditions, Exceptions, Filters, Calculated Key figures, Variables and created aggregates for frequently used queries.
• Worked on developing SAP BOBJ OER WEBI, OLAP reports, Dashboard design on underlying Bex queries for reporting purpose.
• Created ad-hoc reports in WEBI for the Business users using drill down and hierarchy functionality in building the reports.
• Developed KT documents as part of landing process to the support team.
• Tested the development in BW using HP Quality Center testing tool for unti and regression testing.
• Have also use OFS tools for file sharing across the enterprise.
• Worked on the ticket management, Quality Management and Change Record tools.
• Worked with Project Team on key decisions related to functional designs that are compliant with Industry Best Practices
• Successfully did the project to Go Live by identifying and resolving critical issues.

Environment:: SAP BI 7.3, Netweaver 2004s, SAP R/3 4.7, SAP ECC 6.0 SAP CRM, FSCM, SD/MM, HR,SCM, ECC, COPA, PCA, SCM, SRM, SAP BOBJ 4.0 Dashboard, BEx Analyzer / Query Designer, Business Objects4.0, WEBI, ABAP MS Excel

Confidential, Gold River, CA

SAP BI BW BOBJ Consultant

Responsibilities:

• Worked as a Senior Business Objects consultant in implementing data warehouse/ reporting requirements system for Tuition Advisory Services line of business using Business Objects 4.0
• Worked as Data migration specialist to extract tuition spend data coming from multiple systems in flat files, Excel Spreadsheets, Access and SQL Server databases to SAP BW7.3 environment. Created necessary InfoSources, InfoObjects, DataSources and InfoCubes to load the incoming data using Business Objects Data Services 4.0.
• Developed cubes for New GL in BW 7.3.
• Developed BO 4.0 reports on top of Bex queries.
• Developed BO 4.0 IDT and then developed WEBI, Dashboard and Crystal reports.
• Worked with SAP BI AD and BOBJ Business users, Project managers, architects and involved in requirement gathering, analysis and creation of best practice architecture
• Involved in data extraction from PeopleSoft system and Non-SAP (SQL Server) systems using Data Services (BODS).
• Worked on the various functional modules like FI, COPA, PCA, SD/MM, HR and Logistics ( 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 02 ACC)
• Assisted in installation of BusinessObjects Enterprise (BOE), Tomcat Application Server, Crystal Reports, Xcelsius/Dashboard and corresponding Server and client components, tested, documented, maintained the Database, Application and Web tiers and ensured they are working in Development, Testing and Production environments
• Worked with Business Users on design of new reports and changes to existing legacy reports, sourced data from SQL Server, flat files and Access data sources.
• Created OLAP Universes using BO- Universe Designer on top of SAP BI queries, (enabled OLE DB for OLAP) and InfoCubes / MultiProviders; created/modified classes, objects, dimensions, measures and details.
• Created RDBMS Universes using Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts
• Used Query as a Web Service (QAWS), MS Live Office connector and built Xcelsius Dashboards for management and used Xcelsius to create visualization for excel data for pipeline Inventory and Sales& Operations.
• Created queries and reports, Web Intelligence (WebI) and Informatica documents in Java/.Net InfoView and created Web Intelligence (WebI) reports on top of the Universes created using the Designer
• Involved in analysis, design, development, configuration, testing, deployment of SAP BW/BI Info Objects, ODS, DSO, InfoCubes, InfoSets, MultiProviders, Transformations, DTP, InfoSources, DataSources and transformations
• Created/Edit queries and reports in BOBJ - InfoView for multidimensional analysis and trained users on drill-down, cross-tab, triggers, master detail, slicing and dicing, ad-hoc reports by Web Intelligence (WEBI), and publishing (to BO Inbox, email, FTP, ..) in multiple formats (html, pdf)
• Involved in designing, developing, testing Front End Solutions, BW queries as needed by users
• Worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles.
• Involved in developing and conducting extensive Unit testing, Integration testing (SIT), Regression testing, User Acceptance Testing (UAT) and documentation

Environment:: SAP BI 7.3, Netweaver 2004s, SAP R/3 4.7, SAP ECC 6.0, FI, COPA, PCA, SD/MM, HR and Logistics, Oracle, Enterprise Portal (EP) 6.0, BEx Analyzer / Query Designer, Business Objects 4.0/XIR3.1, WEBI, Data Integrator, Xcelsius, VB Scripts, ABAP, MS Excel

Confidential, OH

SAP BOBJ BW BI Consultant

RESPONSIBILITIES:

• Worked as BI/BO consultant and gathered business requirements and deliverables for report requirements along with functional end users in the business areas. And analyzed to identify business content data sources for Enterprise Data warehouse.
• Designed and developed custom DataSources, Info Sources, Extractors, Info Cubes and DSO'S to fulfill user requirements.
• As part of the performance tuning created aggregates for info cubes.
• Involved in review for various objects and created test case and test plans in different environments.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked with ABAP programmers in creating ABAP codes for Transformation routines.
• Performed Master data and Transaction data extractions (SAP) and automated the data loads using Process Chains.
• Worked on the various functional modules like FI, HR, SD and APO.
• Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
• Universal Design: Universe planning building and implementation, design methodology, development cycle Creating Classes, Objects, schema, store procedures.
• Web Intelligence: Created Advance multiple Reports, Ad hoc query, tables, charts, Complex Filters customized formulas and highly formatted page layouts.
• Dashboard: Creating chart with visualizing data range, Series, interactive model, map with graphics, Query as a Web Service.
• Crystal Reports: Planned, created formatted reports, multiple groups, Integration with SAP Data Source, manipulation formulas, applying conditions and exporting reports to Excel.
• Deployed BO Reports/Dashboards in SAP Enterprise Portal.
• Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis using Explorer, Xcelsius and Dashboard.
• Implemented security features of Business Objects like row level, object level and report level to make the data secure.
• Used multiple data providers such as Universe and personal data files in generating report.
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Used Structures, Calculated key figures, Restricted key figures, selection, Formula, exception and conditions. Extensive experience in performance tuning, aggregates to improve the Reporting performance.
• Developed prototype and presented the demo session for user acceptance.

Environment:: SAP BI 7.0, Netweaver 2004s, SAP R/3 4.7, SAP ECC 6.0, Oracle, Enterprise Portal (EP) 6.0, BEx Analyzer / Query Designer, Business ObjectsXIR3.1, WEBI, Data Integrator, Xcelsius, VB Scripts, MS Excel

Confidential, Woodland Hills, CA

Senior BOBJ BW Consultant

RESPONSIBILITIES:

• Involved in BW upgrade into BI and migrated the BW 3.x data sources to BI 7.0 data sources.
• Involved with performance tuning of queries by maintaining Aggregates, compression, partition of info cubes.
• Worked on the functional areas that includes FI, SCM, ECC.
• Created test cases to validate BI objects after upgrade.
• Delivered Documentation for all new objects and enhancements.
• Participated in GO LIVE and Production support.
• Worked with end users in understanding the current Budgeting scenarios from various business units and gathering new requirements.
• Extensively worked on Accounts receivable info cube such as Payment History (0FIAR C05).
• Created Financial GL, Line Items, Cost Center and Account Balance reports using BEX queries for Financial reporting purposes.
• Created a Dashboard with the Net Sales value report by Calendar years and drilled down further by Quarter, Sales Organization, Sales Offices and Sales Reps using Bex tools (Analyzer, Query Designer and Web Application Designer).
• Performed performance tuning to Info Cube objects through aggregates etc.
• Created Multi-Provider based on the Standard and the Real Time cube and InfoProvider based on the Real Time Cube.
• Was involved in the BOBJ meetings to upgrade to Business Objects 4.0.
• Actively involved in migration of Business Object resources from BOXI 3.1 to BOXI 4.0 environment.
• Performed regression testing after migration to BOXI 4.0 platform.
• Created Input Ready Query in the Query Designer using the Filter created in the Planning Modeler.
• Used the Input Ready Queries in the Web Application Designer and published them in the Portal.

Environment:: SAP BI 7.0, Netweaver 2004s, SAP R/3 4.7, SAP ECC 6.0, Oracle, Enterprise Portal (EP) 6.0, BEx Analyzer / Query Designer, Business ObjectsXIR3.1, WEBI, Data Integrator, Xcelsius, VB Scripts, MS Excel

Confidential, Ft. Worth, TX

Senior SAP BI Consultant

Responsibilities:

• Train as well as recommend the Client’s SAP development team in utilizing SAP’s Best practices and solutions.
• Interact with Budget Office Power Users to identify the Reports/Worksheets that needed to be migrated to BI 7.0 environment.
• Analyze and identify new functionality of BI 7.0 Web Application Designer to display Justification texts (Text Documents created as part of Budgeting process) directly in BI reports, for which Crystal Reports was being utilized earlier.
• Create 8 Custom Reports for Budget Office using BI 7.0 Query Designer and then build Web Templates for these portal reports using WAD by implementing Modification Modules recently developed by SAP to display documents.
• Supported the development of Printing Solution, where Macros were used in Bex Analyzer to develop Bex Worksheets for Formatted printing as required by County’s Budget Office.
• Support the technical upgrade of BW 3.5 to BI 7.0
• Interact with SAP to fix issues that were encountered during this upgrade by opening OSS messages.
• Support the migration of Planning functions (both SAP GUI based as well as Web based)
• Involved in Post Production Validation and Data Loading Tasks.
• Train End Users (Corporate as well as Plant level) in understanding and utilizing the various Reports designed as per their business requirement.

Environment:: SAP BI 7.0, Netweaver 2004s, SAP R/3 4.7, SAP ECC 6.0, Oracle, Enterprise Portal (EP) 6.0, BEx Analyzer / Query Designer, Business ObjectsXIR3.1, WEBI, Data Integrator, Xcelsius, VB Scripts, MS Excel

Confidential, Indianapolis, IN

SAP BW Developer

Responsibilities:

• Provided design and modeled of Info Cubes for SD, CO-PA and FI invoices. Defined transfer rules for Info Cubes and customized update rules using ABAP. Extracted data from R/3, NON SAP server using DB connect and flat files. Performed detailed analysis to improve the performance on data load and reporting using Info Cube compression, Aggregates and indexing.
• Specific Accomplished Tasks:
• Worked on redesigning of Info Cubes, pulling delta from R/3 to staging environment and then into Integration layer, Worked on Batch Design for Open Demand and Allocation Delta pull into staging layer and Integration layer.
• Added new plants (distribution center) in to the existed infpackage selection criteria, config tables, program variants, start routine and update rules as per the requirement.
• Created Multi provider upon 8 sales info cube partitions to enable reporting across all regions.
• Created Process Chains to automate the data load and data target administration and monitored the processes.
• Used Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to Update Key Figures and Characteristics in the Info Cubes.
• Created Info Sets, assigned user groups to the Info Sets and also defined Info Set queries. Create exception evaluations for queries. Designed multiple drill-through reports from BEx Queries, ODS Objects.
• Extended the extract structures by adding new fields and populating them with the User Exits.
• Performed Delta Upload Management with OLTP extraction. Used LO Cockpit processes and monitored LO Extraction.
• Involved in Setting up and Monitoring Process chains for the complete data extractions and Loading. Scheduled extract jobs, grouping of extract jobs, monitoring of transfer and update data loads.
• Performance tuning at data loading, reporting before Go-Live. Analyzed performance statistics and recommended improvements.
• Worked extensively on BEx Analyzer. Used Navigational attributes, Filters, Exceptions, Conditions, Jump targets (RRI), Variables, Hierarchies, etc.
• Prototyped Crystal Reports on top of R/3 and BW and leveraged the Crystal Reports for operational reporting needs.
• Created Info spoke based on DSO and pulled into the flat table and DB tables.
• Transported new development to production by grouping the needed objects.
• Handled postproduction support and development of new design cycles simultaneously.
• Trained end users using BEx Reports.

Environment:: SAP BI 7.0, Netweaver 2004s, SAP R/3 4.7, SAP ECC 6.0, Oracle, Enterprise Portal (EP) 6.0, BEx Analyzer / Query Designer, Business ObjectsXIR3.1, WEBI, Data Integrator, Xcelsius, VB Scripts, MS Excel

Confidential, Deerfield, IL

SAP BW Reporting Consultant

Responsibilities:

• Involved in the project for implementing the BW and developed Decision Support System environment. Identified BC Info Providers and other BW objects also performed Gap analysis to design and develop the data model to meet reporting requirements. Extensively worked on Extraction, Modeling and Reporting.
• Specific Accomplished Tasks:
• Consultant in charge of FI and LO Cockpit and master data scenarios implementation into BI.
• Worked on standard and custom defined LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery and billing information.
• Configured and customized Logistic Cockpit extract structures and data sources in sales and distribution and material management to facilitate the data extraction to BW and to reporting using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user exits.
• LO-Cockpit extraction: 2LIS 11 VAITM, 2LIS 02 HDR, 2LIS 03 BF and 2LIS 03 UM using V3 update.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Enhanced existing master data and transactional data extractors. Modified and Created User Exit programs to accommodate additional fields in the extract structure of the Data source.
• Sourced data from variegated data sources including R/3 & legacy data system transformed and loaded data into data targets using ETL tool.
• Setup flat files extraction for legacy data, assigning data sources to the Info Source, defining transfer structure, and metadata maintenance for the Info Source.
• Handled profit center accounting cubes (0PCA C01, 0PCA C02), accounts payable cubes (0FIAP CO2, 0FIAP C03), accounts receivable cubes (0FIAR C02, 0FIAR C03) as a part of cross-functionalSAPBW implementation. Created Balance Sheet, Profit & Loss Reports, Trial Balance, and Cash Flow Statement on GL Info Cube.
• As part of Performance Tuning optimized the load performance by adjusting the packet sizes, data selections and number of Info Packages.
• Generated report for the Manufacturer to notify the delivery date and the details of material based on sales order.
• Extensively involved in publishing the Reports to Portal, email, Collaboration rooms and KM using BEX broadcaster for the end users to access them
• Fixed formatting, dimension and variable issue in Webi report after migration.
• Provide both functional and technical documentation. End user training and knowledge transfer on using reports.
• Extensively worked on the design and development of the process chains.
• Captured BW objects in packages for transport.

Environment:: SAP BI 7.0, Netweaver 2004s, SAP R/3 4.7, SAP ECC 6.0, Oracle, Enterprise Portal (EP) 6.0, BEx Analyzer / Query Designer, Business ObjectsXIR3.1, WEBI, Data Integrator, Xcelsius, VB Scripts, MS Excel

Confidential, Phoenix, AZ

SAP BI Consultant

Responsibilities:

• Interaction with Business Users to understand the current business process and identify the reporting requirements for respective groups.
• Analyze and support the design of a suitable Data Model and then Identify appropriate SAP BW Business Content.
• Perform Gap Analysis to identify the enhancements required as part of the Data Model
• Develop the data model in a Prototype environment as per SAP Best Practices, with Data feeds connecting into BW from ECC 5.0, CRM 4.0 and SRM 4.0 systems.
• Activate relevant Business Content Info Cubes, ODSs, Update Rules, Info Sources, Transfer Rules in the areas of:
• Bidding Engine: Invitation & Bids - (SRM)
• Sales and Distribution Analyses - (CRM ERP Analytics )
• Activity Analyses, Installed Base Analyses, Customer Analyses, Lead Analyses, Marketing & Campaign Analyses, Sales Analyses and Service Analyses - (CRM Analytics) Channel Sales, CRM Interaction Center.
• Training & Event Mgmt., Payroll, Recruitment, Personnel Administration, Cross Application Time Sheet, Personnel Development, Compensation Mgmt., Benefits, Org Mgmt., Time Mgmt. and Strategic HR - ( HR)
• Purchasing ( - Supply Chain Mgmt.)
• Support the enhancement of Info Objects and applicable Extractors in the Source Systems
• Load Master Data and Transactional Data into the relevant Data Providers with Full and Delta Update methods using appropriate process chains.
• As part of BW administration, resolve underlying issues during Activations, Extractions & Loading and utilize SAP OSS whenever needed.
• Use System Monitors / Tools to identify the root cause in case of loading/query retrieving issues.
• Activate the business content queries and publish them for the users to analyze the output on Enterprise Portal using views
• Create Custom Queries/Alerts for the Users and send them Via Email/Web Links to various business teams using Information Broadcasting.
• Used BW Statistics, Query Monitor and optimized Update Rules, Aggregates and created Indexes to enhance query performance.
• Replicate the Data model in Development Environment and organize the Transports to QA /Production Environment

Environment: SAP Net weaver 04, (BW 3.5 ), SAP R/3 4.6, ECC5.0, CRM 4.0, SD, MM, HR, SRM 4.0

Confidential, Houston, TX

SAP BI Consultant

Responsibilities:

• Analysis of reporting requirements and Business content in the areas of SD, MM, PP and FI-CO
• Identifying the Gaps in Business content and design the best possible solution to bridge the gap by creating custom ODS, Cubes and extractors.
• Designing the complete architecture for proper data transfer and reporting with special emphasis on performance.
• Identifying the commonalities in requirements for creating Aggregates for performance.
• Creating the Load Schedule for different Master and transaction data for future maintenance.
• Responsible for Info Package schedules and monitoring the data loads for checking its completeness, data integrity, and aggregation and compression status.
• Create Custom ODS and Info cubes for data storage after analyzing the reporting requirements and the data requirements of downstream systems.
• Testing the data transfer and the analyzing the data extraction load for performance tuning.
• Monitoring the data loads to ensure all errors are resolved.
• Create custom update rules and transfer rules for updating the ODS and Info cubes from Flat Files and R/3 data sources.
• Create custom extractors for transfer the data to the Master data objects for initial and delta loads.
• Create Reports on ODS and Info cubes using Formula variables, restricted key figures, Calculated key figures and also creating variables from Master data attributes for reporting.
• Create the design for custom ABAP programs to load some data and create interfaces to other downstream systems.
• Interact with Business users for developing report interface and report content.
• Develop Bex reports and conduct testing in coordination with business users and obtain signoffs

Environment: BW Version 2.1c, SAP R/3 4.6C