SUMMARY:

• Total 19 yrs SAP experience with 2+ yrs in SAP R/3 Abap/4 development and 17 yrs in SAP BW/BI. 17 yrs of experience as Techno functional consultant in implementing SAP HANA, SAP BW ( BW 7.5,7.4,7.3, BI 7.0, BW 3.5), SAP BPC, SAP ABAP/4, SAP BOBJ, SAP BO (4.1, 4.0, XI3.1), SAP BODS, HANA Live, SAP ECC and SAP Lumira projects.
• Modeled different solutions based on side - car HANA approach, BW on HANA and native Hana Models including data provisioning using DXC, SLT and BODS.
• Worked on SAP Native HANA, HANA (side-car scenario) & BW on HANA. Worked on design and development of BW on S/4 HANA (Month-end & Historical Data) S/4 HANA Modelling Good understanding of all aspects of integration with SLT and BO Data Services 4.0. Good knowledge on HANA Attribute, Analytical and Calculation View. Knowledge of HANA scripting and ability to merge both SAP and Non-SAP Data.
• Worked 6 full life cycle BW/BI implementations.
• Experienced Sr.SAP BI Consultant & Architect who has successfully led project teams from 4- 15 resources from requirements gathering through to implementation and support. Lead and worked with teams on an Onsite-Offshore model.
• Worked on SolMan 7.1 (Solution Manager) and ChaRM (Change Request Management) for all the CTS (Change & Transport systems) to move objects within environment.
• Worked on integration between SAP Fiori/UI5 and SAP BI Business Objects and SAP Fiori/UI5 & NetWeaver Gateway Expertise.

TECHNICAL SKILLS:

Fiori/UI5 expertise: ECC HCM Apps, Logistics & MM Apps, System Landscape, Architecture, SSO, Security Set Up, Gateway configuration. Fiori Package Configuration on SAP Gateway & Backend ECC App ConfigurationWorked on 7 BI 7.0 Upgrade Technical and Functional Upgrade projects upgrading BW2.1C to BW 3.0(at Pratt and Whitney),2.1c to 3.5(SAP NetWeaver 04) (at Confidential ) and BW 3.1c to BI 7.0(SAP Netweaver 2004s R1 SP8 at IBM) and BW 3.1 to BI 7.0 NW2004s.

SAP BW/BI: Expertise in DataModelling creating infoproviders, DSO(ODS), Multiproviders and Infosets. Extraction from COPA, FI, SD, MM, APO(SCM), SRM, CRM and FI-SL modules. Experience with Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP data extraction, loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.

Technical Proficiencies: SAP R/3 version 3.x/4.x, ECC 5.0/6.0, SEM 3.5/4.0, Netweaver 2004s, BW3.x, BI 7.0, BI 7.1, BW 7.3, BW 7.4 SAP HANA 1.0, BPS, IP, FI/CO (GL, AR, AP, AA, COPA, CCA, PCA, COPC) Oracle, ABAP/4, Windows 2000/NT/ME/98, UNIX, Linux, Microsoft Project Management tools, MS Word/ Excel/ PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

SAP BW/BOBJ HANA Architect

Environment: SAP R/3 ECC 6.0, SAP HANA1.0, Salesforce.com, SCM 7.0, BI 7.4, BI 4.0, BI 4.1, Analysis for Office, BODS, BO Design Studio 1.5.

Responsibilities:

• Worked closely with stakeholders & users in the gathering and validation of requirements and ensuring that delivered solutions meet and exceed stakeholder expectations.
• User requirement analysis and development for COPA, Logistics and FI reports and created LSA ++ dataflow. Responsible for analyzing the requirements and identifying the gaps.
• Involved in ETL Based replication to provision the data from ECC to HANA system through BODS
• Involved in providing solutions to the complex requirements using BW 7.3 Infoproviders (Transient Infoprovider, Virtual Master Data InfoObjects, Composite Providers, Multiproviders) for HANA Models and resolved HANA error’s like data type mismatch, numeric overflow, etc.
• Involved in identifying the area to improve the performance by utilization of HANA In-Memory computing feature, Column store, Calc Engine features.
• Involved in Optimizing the Design of the data flows in BW, HANA for the requirements.
• Involved in Planning of data load activities runbook preparation. Created SQL, SQL Script, CE Functions.
• Worked on Users requirement for development of BOBJ WebI (Web Intelligence & also Analysis for Office) reports and Variants for SAP as well as Non-SAP data sources.
• Collaborate with onsite/offshore team with respect to all ongoing customer deliverables.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical issues.
• Evaluating existing standards and processes and recommending and implementing new standards and processes on a proactive basis.
• Involved in building a set of Webi pricing reports and Dashboards for Management and Pricing team to do what if Analysis scenarios in Product Pricing.

Confidential, Mason, MI

SAP BW/BOBJ, BW on HANA Architect

Environment: SAP R/3 ECC 6.0, SCM 7.0, SAP HANA 1.0, BI 7.3, BI 4.0, BI 4.1, SAP Fiori/UI5, Analytics for Office, Lumira, BO Design Studio 1.5.

Responsibilities:

• SAP BW upgrade and BW on HANA Migration
• Defined design standards and best practices of building models over HANA.
• Successfully migrated 56 TB Oracle system to HANA using downtime-minimized approach.
• Primary liaison with SAP during ramp-up, responsible for all OSS communications and resolutions. Involved in Pre and Post migration tasks for DMO. Performed pre-validation steps.
• BW to HANA migration Readiness Check.
• Checks of ETL ABAP code and fixed outstanding issues in all environments.
• Gathered benchmark performance statistics for load and activations.
• Performed pre-activity steps in all environments and Involved in HANA sizing.
• Assessment of current BW environment and provided over all environment and functional area specific data flow optimization guidelines.
• Responsible for architecture, preparing system for BW on HANA upgrade including system prep and cleanup activities.
• Involved in preparing the BW environment for Pre & Post Migration steps to HANA.
• Conversion to SAP HANA-optimized DSOs and cubes (In memory cubes) after system migration. Migrated existing info providers to HANA optimized providers.
• Involved in architect, design, development and maintenance of HANA data models (Attribute view, Analytical View and Calculation views), HANA Security, data provisioning thru SLT, Import, export and migration.
• Assists in all phases of implementations as needed including analysis, migration, testing, and /knowledge transfer to end-users, go-live assistance, and post implementation support.
• Included a mix mode SAP HANA and SAP BW on HANA approach where there were standalone HANA models, HANA models exposed as Virtual Providers in SAP BW and finally classical BW on HANA models. The latter made use of in Memory Optimized DSOs exposed thru Multi-Providers and BEX Queries and use of in-memory optimized cubes when aggregating data with different granularity
• Performance Optimization techniques, HANA Stored Procedure calls by Data Services
• Developed HANA models and BODS flows for Phase II and Phase III.
• Reports Developed in this Project: Customer Black log Summary Report, Customer Touches, Billing Summary, Opportunity Summary, Sales summary, New Customer Mix / Growth, Expense Reports for QTD and YTD, P&L analytics on monthly, quarterly, year to date basis.

Confidential, Portland, OR

SAP BW/BOBJ,BW on HANA Architect

Environment: SAP R/3 ECC 6.0, SAP CRM 7.0, SCM 7.0, BI 7.0, BI 7.3, HANA1.0, S/4 HANA, BI 4.0, BO Design Studio

Responsibilities:

• Phase 1 - Worked on BW BOBJ development specifically with Dashboard Reporting using the new BOBJ Design Studio, worked on and developed BOBJ Webi reports against SAP BW BeX queries.
• Gathering and analyzing dashboard requirements and development of Design Studio Dashboards based upon BW BeX queries as datasources.
• Analysis of existing CRM reports on legacy systems and migrate/convert/recreate in the new Webi BOBJ environment. Participate in discussions to validate captured dashboard & BOBJ Webi requirements and develop functional/technical designs.
• Phase 2 - Worked on the HANA and BW on HANA mixed models using Virtual providers.
• Moved SAP BW specific models to a Hybrid BW on HANA.
• Developed custom ABAP SLT for prepopulating data for performance optimization
• Found workarounds to multiple Problems/Issues.
• Defined design standards and best practices for scalable and sustainable development.
• Worked with IT leadership in defining the key success factors, scope & expectations, risk mitigation, cost-benefit and outlining roadmap to better leverage primary and secondary benefits.
• Actively collaborated with Basis, OS/DB teams in resolving migration and performance issues
• Designed and developed Financial reports (Consolidated balance sheet Analysis, Consolidated income statement report, Monthly Comparison Balance sheet and Income statement Analysis, Expense Reports for QTD and YTD)

Confidential, Middlebury, CT

SAP BI, BOBJ & HANA Architect

Environment: SAP R/3 ECC 6.0, Salesforce.com, SCM 7.0, HANA Live, SAP HANA 1.0 SP7, BI 7.0, BI 7.3, BOBJ 3.1, BI 4.1

Responsibilities:

• SAP BW on HANA platform - Managed System Landscape preparation with Basis team.
• SAP BW Technical upgrade: Conversion of data flows, datasources, queries, workbooks and security objects from version 3.x to 7.x in BW DEV system and transported all through the landscape to BW Production environment.
• SAP BW authorizations migration from 3.x to Analysis Authorizations.
• Process Chains migration to include DTP flows.
• Testing and validation of 7.x objects.
• Process Chain monitoring and bug fixes after upgrade to 7.x.
• Integration testing with SAP BO and Portal.
• Plan and execute HANA pre-migration activities.
• Collected statistics from Data loads and Reports Execution timings before migration to HANA.
• Supported migration to SAP HANA via DMO option - SAP Notes implementation.
• Plan and execute HANA post-migration activities.
• Hierarchy objects dataflow/datasource migration from version 3x to 7x.
• System Validation and Testing after migration.
• Integration testing with SAP BO and portal after migration to HANA.
• ABAP code upgrade after migration.
• Experience in calculating Virtual characteristic using BADI
• ABAP Routines optimization.
• Data Cloning
• Performance analysis by comparing pre and post migration runs time and presented to management.
• System Cleanup: Deletion of unused objects from the BW DEV system and transported through the landscape.
• Universe Layer removal: Replacement of SAP BO Web Intelligence reports created on top of BO Universes by creating Bex queries and consuming them to SAP BO Web Intelligence via BICS connection. This empowers webi reports with SAP HANA in-memory database.
• Final validations and system health check.
• Go-Live: BW-HANA migration.
• Analyzed and presented SAP BW Data Model re-architecture as per LSA++ concepts to leverage SAP HANA as the In-memory database.

Confidential, Tulsa, OK

SAP BI/BOBJ & HANA Architect

Environment: SAP R/3 ECC 6.0, SAP HANA 1.0 SP5, BI 7.3, BI 4.0

Responsibilities:

• Responsible for the design, performance and operations of the HANA Analytics environment.
• Worked on managing the project for upgrading SAP HANA from HANA 1.0 to 1.4 and upgrading of the Service packs.
• Worked with SAP HANA Security team on managing schemas, data model objects, import/export content and SAP HANA Security including User Management, Roles, and Privilege.
• Have good knowledge on SAP HANA modeling, Data Provision, Partitioning, Security and Reporting.
• Involved in configuration of SLT Server, monitoring the data loads form ECC to SAP HANA DB
• Loaded ECC tables into target schema tables using SLT based table Data Provisioning and performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning.
• Created Packages, Attribute Views, Analytical Views, Calculation Views, and modified the system generated joins
• To validate SAP HANA Solution on various technical & business parameters including query performance, data compression, analytics on Business Objects reporting tools.
• Created and managed Delivery Units to move across different environments
• Configured/created ODBO connections (MS Excel) and JDBC connections (SAP Business Objects BI 4.0) for accessing the information models from SAP HANA for Analysis for Office (A-Office) reporting purpose.
• Analyses of a critical ECC Finance report based on multiple tables.
• Analyze the KPI’s of Debit and Credit.
• Existing report takes close to 2 hours to execute (ABAP code logic ~3000 lines).
• Data summarized at the Cost centre level.
• Data detailed at General Ledger Line item level.
• Base tables contain over 100 million records.
• Blueprint document preparation.
• Replication of base tables in SAP HANA and data modeling, including cluster table.
• Use of Analytical views/ Calculations views for performing look-ups.
• Write SQL scripts, CE coding.
• Used SAP HANA Modelling to analyze a large volume of complex data to gain business insights into customer spending patterns, and to develop new market offers to expand existing customer base and in turn generating more revenue for the company.
• Worked on Modelling approaches - using the Graphical Modeler where no SQL or SQL script knowledge required, Built-in Union, Join, Projection & Aggregation nodes provided, I used the (Script-Based Editor)
• Created Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
• Execute the report ad-hoc at any time and for any period.
• Execution time reduced to a few minutes.
• Drill-down enabled reports.
• Access the information on mobile devices.

Confidential, Greensboro, NC

Sr. SAP HANA BOBJ Architect

Environment: SAP R/3 ECC 6.0, BW 7.3 SP5, SAP HANA SP6 REV 61, SAP BOBJ 4.0 SP5

Responsibilities:

• Worked on HANA side car implementation for FI module.
• Architectured the strategy for implementing the SAP BOBJ tools - WEBI, Office Analysis,Design Studio
• Worked with SAP BW (on HANA) integration with Design Studio.
• Worked on SAP BODS to load data from non-SAP into SAP HANA
• Worked with several ETL features of BODS to accommodate the business requirements
• Activated the standard Technical content and maintained Process Chains for statistics
• Worked on product support for daily loads and query performance issues
• Built Financial consolidated, Unconsolidated reports Interactive Analysis reports using various features like variables,formulas,Hyperlinks,Multiple datasources in WEBI
• Works on assignments in resolving problems and making choices, recommendations & decisions.

Confidential

Sr. SAP BW/BOBJ Consultant

Environment: SAP R/3 ECC 6.0, IS-U - Retail, POSDM, BI 7.3, Business Objects 4.0

Responsibilities:

• SAP BW-Retail development for Attune’s Retail client - Columbia Sports. Responsible for the Support, design, performance and operations of the BW Analysis & Reporting Business Intelligence (BI) environment.
• Work & support extensively on all the BW SAP Retail areas POS Data Management, Merchandise Management, Merchandise & Assortment Planning (MAP), Store Controlling & Point of Sale (POS) for Attune’s retail client’s BW implementations.
• Published Reports to BO 4.0 CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats. Created business users, folders and granted security access to the reports using CMC.
• Performed data validation and testing KPIs on new reports. Resolved loops by creating aliases and contexts.
• Worked on developing & support the custom BW objects using BW LSA (Layered Scalable Architecture).

Confidential, Vernon Hills, IL

SAP BW Lead Consultant

Environment: SAP R/3 ECC 6.0, BW 3.5, BI 7.3, Business Objects 4.0

Responsibilities:

• Responsible for the design, performance and operations of the Manufacturing (Production Planning) Reporting & Analysis using SAP Business Intelligence (BI) environment.
• Worked extensively on standard & enhanced the standard BW extractors for Production Planning - Material view from PP/PP-PI -2LIS 04 P MATNR, Component View from PP-PP/PI - 2LIS 04 P COMP extractor, Repetitive Manufacturing Material-2LIS 04 PEMATNR.
• Ensure the design, creation and sourcing of data for InfoProviders and InfoObjects (InfoCubes, DSO, Infosets & Multiproviders) to satisfy Reporting requirements.
• Develop and modify the Manufacturing Reporting & Analysis BI reports using WebI (Web Intelligence).
• Maintain and develop SAP ETL and BeX queries against SAP OLAP cubes (Infocube)
• Maintain and modify BW Queries & Cubes using BICS from BW to BOBJ.

Confidential, Jackson, MI

SAP BW & SAP BW BOBJ Architect

Environment: SAP R/3 ECC 6.0, BI 7.3, HCM, QlikView, Informatica, Oracle, Business Objects 4.0

Responsibilities:

• Responsible for the design, performance and operations of the Business Intelligence (BI) environment.
• Establish and maintain BW design standards and best practices.
• Ensure the design, creation and sourcing of data for InfoProviders and InfoObjects (InfoCubes, DSO, InfoSets and multiproviders) to satisfy reporting requirements.
• Worked on developing & maintaining Reports using SAP BW, combined and analyzed data, easily & quickly, from SAP R/3, SAP BW and non-SAP sources. Enabled the users the ability to visualize information in a wide variety of charts, graphs and tables and ability to interact with SAP data in real time, Enhanced the Standard BW Extractors for PP & P2P (Materials Management - Purchasing Data (2LIS 02 ITM, 2LIS 02 HDR, & 2LIS 02 SCL), Allocation Confirmation and Goods Receipt, purchasing groups & Vendor evaluation, OTC (AP, AR) & Order to Cash reporting.
• Worked on Vistex Data Source customizing using LO Data extraction to handle complex calculations like processing rebates, Sales commissions, Billbacks, Chargeback in ECC using the Vistex Datasources for header data, item data & condition data for Claim request (LIS RM GCRCON, LIS RM GCRHDR, LIS RM GCRITM), Revenue/Cost Adjustments, IP: Billback, IP: Chargeback, Customer Rebates, Sales incentives
• Worked on developing the Std. & install BC cubes/DSO & Multi providers for PA/PD, OM, Compensation management, Personnel Cost Planning, Benefits, Personnel Time management, Payroll, & event management, Travel management & CATS.
• Worked on developing Std.& install BC Infocubes- Benefits Infocube (PABN C01), Organizational Management Infocube(PAOS C01) and Travel Management
• Working on the SAP BI Integration to Business Objects 4.0 as an Analytical & Reporting solution, selecting existing BW Queries for reports and also creating new Reports using BI Queries and Cubes as a DataSource for Business Objects Webi reports, XCelcius Dashboard using BICS.
• Work with functional business leads to translate requests into clear functional specifications followed by technical specifications for Data Warehouse and/or ABAP developer for extractor enhancements.
• Design data extract schedule and work with necessary teams to implement.
• Worked on a prototype project on how to use the new BO Visual Intelligence Tool.
• Ability to understand complex business processes and translate those to technical solutions.

Confidential, Bellevue, WA

SAP BI CRM-BOBJ Lead Consutant

Environment: SAP R/3 ECC 6.0, BI 7.3, CRM 7.1, Oracle, Business Objects (BO) 4.0

Responsibilities:

• Extensively worked on SAP BI 7.3, ECC & CRM on the new CRM 7.0 EHP 1.
• Full lifecycle implementation Extensively worked on SAP BW-CRM on the new CRM 7.0 EHP 1.
• Project liaison with Confidential and major 3rd party vendor for system delivery and deployment.
• Participated in QuickSizing exercises with Basis team for all new BI system builds to ensure proper performance and allowance for growth.
• Installed and configured CRM BW Operational Reporting.
• Activated all business and ICF content for BI & CRM BW Operational Reporting systems.
• Extensively worked with Logical Extractors(LBWE), ODS, Cubes, Flat file loading for Transactional data, and Master Data-Attributes, Texts and Hierarchies for Procurement-Procure to Pay (P2P) and Sales-Order to Cash (OTC) (Sales, billing) processes.
• Working on BI-CRM integration and experience working on CRM infocubes in BW for creating queries for Service Confirmation, Activities and Business Partner analysis from CRM data.
• Consult with the users/functional teams to gather and interpret their documented reporting requirements for SAP CRM (Service) projects.
• Replication of Master, Transactional & Customizing objects between SAP R/3, BI & CRM system.
• Worked on the SAP BI Integration to Business Objects 4.0 as an Analytical & Reporting solution, selecting existing BW Queries for reports and also creating new Reports using BI Queries and Cubes as a DataSource for Business Objects Webi, XCelsius Dashboards using BICS.
• Developed documentation for end users.
• Participated in SAP BI Go-Live check process

Confidential, Bellevue, WA

SAP BI BOBJ Solution Architect

Environment: SAP R/3 ECC 6.0, IS-Retail, SAP SRM 7.0, BI 7.0, Teradata, Vistex ECC 6.0 IP, Enterprise Portal (EP 7.0), Oracle, Business Objects XI R2 and R3.

Responsibilities:

• As an SAP BI/BOBJ Solution Architect worked as a part of the Information Management (IM) organization, specifically the Data and Solution Architecture EDW BI team.
• Worked on SAP BI & BI Teradata systems architecture and its physical implementation, as well as various loading methods and data quality and error processing techniques.
• Worked on Data architecture standards, practice, as well as ETL development methodologie
• Work closely with the requirements teams, business groups, and other ETL and data modeling team
• Worked on providing the Solution Architect for Confidential EDW projects - MBB Pooled BAN Hybrid BAN project, CR22 Reporting, BSSP (Branded Systems Service Parity), El Dorado, Paperless Billing & Yakima & Customer HUB, and on PRS-Prepaid Reporting System, SmartMart, IHUB, ReportInfo systems.
• Hands-on experience with end-to-end data warehouse implementations, analysis & providing Solution Architecture artifacts for the Telecom EDW BI KPI’s & Reporting requirements.
• Worked with the BI Business Analysts, System Analysts, BI Teradata & SAP BI Dev team & Business Objects Reporting, Data Architects for providing BI architectural solutions on various EDW BI projects to ensure that the business requirements can be satisfied by the most efficient and effective architectural solutions

Confidential, Rancho Cordova, CA

SAP BI Consultant

Environment: SAP SRM 7.0, BI 7.0, DB6, AIX

Responsibilities:

• Worked on customizing and activating standard delivered BI Business contents in the areas of SRM.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Managed and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Worked on Shopping Cart, Invoice Documents, Purchase Order, Confirmations, Procurement, Confirmations and Contract Management Cubes and DSO.
• Uploaded the Master and Transactional data from SRM into BI via Data Staging to PSA, ODS and InfoCubes.
• Worked on the Std. Queries and Reports for Shopping Cart, Invoice Documents, Purchase Order, Confirmations, Procurement, Confirmations and Contract Management as part of Go-live.
• Worked on providing Inventory of Architectural Components
• High Level Architecture Diagram

Confidential, Hopewell, NJ

SAP BI Consultant

Environment: SAP R/3 ECC 6.0, EP 7.0, BI 7.0, Oracle, BPC 7.0, OBIEE, Hyperion Essbase, Business Objects XI3.0

Responsibilities:

• Working on Requirements gathering, Analysis, and Design and Develop BW data models with to functional and technical specifications. Understand Business process, Landscape & Architecture for BW configuration for the COA (Finance - Chart OF Accounts) Mapping Early Validation Approach Reporting Project to map Confidential Oracle Data to SAP using SAP BI as the Validation Reporting tool.
• Confidential is currently using Oracle-GL and FDW (Fin. Data Warehouse) and Hyperion Essbase and OBIEE for Reporting, after the merger Confidential will be transitioning to SAP ECC and SAP BI.
• Completely responsible for BPC development for custom developed Planning Area.
• Analysis of current state of Budgeting and Forecasting Processes.
• Managed both the Onsite & Offshore Project team members
• Examined the corporate readiness to implement BPC
• Analyzed and evaluated for opportunities to achieve best in class.
• Configured a prototype in Financial Planning and Cost Planning using BPC to replicate their current S&OP and Cost Center planning in R/3.
• Created the BW InfoCubes, BPS Planning Layouts and Planning Folders.
• Data from different Confidential ’s systems like Oracle, FIG (Financial Interface Gateway-a mapping system to translate and post to GL), and Insight (BAC Global-Ledgers) and Razza (stores Hierarchies), data from the 3 systems and Hierarchy data is loaded to SAP BI.
• BeX Reports were created to validate chart of accounts data between the 3 systems - Insight chart, SAP chart and Merrill chart.

Confidential, Bellevue, WA

SAP BI Consultant

Environment: SAP R/3ECC6.0, SAP IS-U, EBP (SRM 4.0), EP 7.0, BI 7.0.

Responsibilities:

• Worked on Requirements gathering, Analysis, Design and Develop BW data models regarding functional and technical specifications. Understand Business process, Landscape & Architecture for BW configuration for the BI PCAD Reporting Project. using Bex.
• Setup and used DB Connect to extract data from Oracle database into BI for PCAD HR data.
• Setup and used UDConnect to extract Web based system data into BI for reporting.
• Conducted Analysis to setup BI Accelerator for specific Queries considering various factors to boost and enhance the BI query performance. tested BI Accelerator and BeX Queries performances after BI Upgrade.BI Accelerator built using TREX technology (indexing, retrieving, compression) to handle structured data and independent of DB optimizer and aggregates, no aggregate maintenance, minimized roll-up/change run for high Data Volume Queries.
• Analyzed all the InfoCubes and Re-modelled cubes to improve the query performance and for cubes for consideration for BI Accelerator.

Confidential, San Antonio, TX

SAP BI Consultant

Environment: SAPR/3 ECC6.0, IS-Utilities 4.72, EBP (SRM 4.0), EP 7.0, BI 7.0, BW 3.5, BPC 7.0.

Responsibilities:

• Worked on Support and maintenance of SAP BI Project for Confidential financials.
• Completely responsible for the initial phase of the Project Blueprinting and Scoping.
• Prepared strategy, scoped, collected business requirements, analyzed the process to be modeled
• Created Business Requirements Document (BRD) and Business Design Document (BDD) for Legal Consolidation, Managerial Consolidation, and Financial Budget and Forecast.
• Designed the Integration of the Systems of ECC, BI and Legacy Systems (Oracle Financials and Hyperion Pillar) to combine the data for Analysis, Planning and consolidation of data in BPC.
• Extracted the data from ECC new tables like FIGLFLEXT to BI using Standard DS such as 0FI GL 10 and 3FI GL XX TT.
• Conducted Analysis to setup BI Accelerator for specific Queries considering various factors to boost and enhance the BI query performance. tested BI Accelerator and BeX Queries performances after BI Upgrade.BI Accelerator built using TREX technology (indexing, retrieving, compression) to handle structured data and independent of DB optimizer and aggregates, no aggregate maintenance, minimized roll-up/change run for high Data Volume Queries.
• Worked and setup the Bex Broadcaster Wizard to send queries, workbooks and Web Applications as emails and broadcast them into EP. using ‘Continue ‘and ‘Execute ‘options.
• Worked on setting up the Bex Information Broadcasting to send queries, workbooks and Web Applications as emails and broadcast them into EP.
• Worked on Life Cycle Implementation and designing architecture & Extraction of Maximo data (Work Orders, WO Ancestor, WO-Material Item, Work Code and Synonym Domain) into BI using UDCONNECT following EDW (Enterprise Data Warehousing) Concept.
• Used DB Connect to extract data from Oracle database into BI.
• Worked on AR reports Customer Payment analysis and customer balance notification.
• Designed and remodeled BI data model using the EDW Layer concept for maintaining Data Alignment & Consistency for SRM data in BW.
• Integrated SAP (Reservation’s), SRM (PR’s, CTR’s & PO’s) and Maximo Data in design to develop the “Material Availability Online Status Report” suiting business requirements using Report Designer.
• Created test cases and Performed Unit testing & Integration testing for upgraded objects.
• Got appreciation from Business for providing excellent end user & providing manuals to use the system/reports and custom functionality for their ease.

Confidential, Detroit, MI

SAP BI Consultant (Production Support, Dev & Release Team Lead)

Environment: SAPR/3 ECC6.0, IS-U CCS 4.72, BW3.5, BI 7.0

Responsibilities:

• Worked on understanding performance issues in older version and approach them systematically for new BI 7.0 Upgrade.
• Worked on Technical Upgrade from BW 3.5 to BI 7.0
• Work on BW development for SCM Service Line (PSL) Reporting Project.
• Responsible for the data extractions from R/3(ECC 6.0) and external systems to BW for SRM and Logistics, MM, SD and FI/Co.
• Worked on the development of generic data sources SCM and Fi-Co fields, data modeling and development of info providers (ODS, cubes and multi-cubes) for PSL Reporting project using BeX.
• Worked extensively on LO Cockpit, Fi and COPA extractions. Loaded the data from R/3(ECC) to BW
• Modified the User exit programs to accommodate the additional fields in the extract structure of the datasource.
• Conducted Unit Testing of BW development for SCM Reporting.
• Work on setting up the Bex Information Broadcasting to send queries, workbooks and Web Applications as emails and broadcast to end users. Conducted Analysis to setup BI Accelerator for BeX Queries considering various factors to enhance the BI query performance. Tested BI Accelerator and BeX Queries performances after BI Upgrade.
• Worked on BW Logical extractors, ODS and Cubes development for Sales - Order to Cash (OTC) and Procurement-Procure to Pay (PTP) reporting on SAP Netweaver 7.0.
• Worked on the enhancement of data sources (SD, MM, SRM and FI-Balance Sheet and Income Statement), data modeling and development of infoproviders (ODS, cubes and multi cubes) for OTC and P2P reporting project using BeX and Web Application Designer (WAD).
• Write ABAP OO codes for Start, End and Transfer Routines. Wrote Data Source Enhancement User exits for Master and Transaction Data custom fields enhancement using CMOD. Wrote Variable user exits for BeX Reporting.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Managed and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Optimized the load performance by adjusting the packet sizes, data selections and number of info Packages. Done the parallelization while loading into ODS objects.
• Worked on evaluating new technological development and evolving business requirements for BI 7.0.
• Recommended new technologies and products which enhance operations and functionality of systems
• Worked with query builder to build queries in the areas of SCM, Logistics, MM, SD, ECC, CCA, AP, AR and COPA., Consolidated balance sheet, Retail statistical Key figures report, Audit Invoice detail report, AP aging report, AR credit line accounts balance report, Daily report by profit center, EOM reports by product group with profit center details.
• Also, involved in the production support, fixing bugs using Abap Debugger and daily ETL Data load Monitoring of the BW jobs.

Confidential, Federal Way, WA

SAP BI Solution Architect

Environment: SAPR/3 ECC6.0, BW3.5, BI7.0.

Responsibilities:

• Responsible to define architecture and provide highly technical direction to high priority BI 7.0 Upgrade project.
• Worked on evaluating new technological development and evolving business requirements for BI 7.0.
• Worked on Procurement Cubes, Cost Center Cube, Investment Cubes. Uploading the Master data and transactional data from SAP R/3 into BW via Data Staging to PSA, ODS and InfoCubes.
• Managed and co-ordinate with both the Onsite & Offshore Project team members
• Worked extensively on configuration using Administrator Workbench (RSA1). Customized data Sources, InfoObjects, Info Sources and InfoCubes. Created FI-SL InfoCube by generating Transfer Structure, Extract Structure for FI-SL Totals table, and defined and assigned data source for a ledger.
• Analyzed InfoCubes (via RSRV) created and maintained aggregates (RSDDV) to improve the query performance.
• Heavily involved in customizing and activating standard delivered BW business contents in the areas of FI-AP/AR.
• Responsible for providing in-depth technical and business knowledge to ensure efficient design, programming and implementation will be a key area of focus.
• Worked on understanding performance issues in older version and approach them systematically for new BI 7.0 Upgrade.
• Worked on BI 7.0 front-end upgrade, specifically migration of queries, workbooks and web reports.
• Conducted Analysis to setup BI Accelerator for specific Queries considering various factors to enhance the Query performance.
• Worked on setting up the Bex Information Broadcasting to send queries and workbooks to end users.
• Conducted technical studies and evaluations of business area requirements and recommend appropriate technological alternatives.
• Conducted independent analysis of business models, logical specifications and/or user requirements to design business solutions along with technical studies and evaluations of business area requirements and recommend appropriate technological alternatives
• Recommended new technologies and products which enhance operations and functionality of system.
• Experience to help internal organizations to understand the impact of new BW solutions on existing processes.
• Writing Architecture Documents, Functional & Design Specifications.

Confidential, Milford, MA

SAP BI 2004s Senior Upgrade Specialist

Environment: SAP R/3 Enterprise, BW3.1c, BI 7.0, CRM 4.0.

Responsibilities:

• Working on a SAP Netweaver 2004s BI 7.0 Upgrade upgrading from a BW 3.1c.
• Understand the SAP Upgrade Process for the BI Netweaver components.
• Prepare and check the SAP system for the Technical Upgrade.
• Upgrade Preparation Pre-Checks. Check consistency of DDIC objects of Infocubes, InfoObjects and transfer structures.
• Technical Upgrade Preparations (PREPARE and UPGRADE).
• Technical Upgrade Post Activities, doing all the technically related checks.
• Upgrade Post Activities Application. Co-existence of current workbooks/favorites and queries and the new BI 7.0 based workbooks on the same cubes.
• Migrate Web Objects to Netweaver 7.0.
• Handle errors and tuning during the Upgrade process,
• Converting the Data Sources and the PSA to the new DTP Process, Using Transformation process, fixing the ABAP OO codes in Start and End Routines.
• Recommending the Support Package Stacks and Pug-Ins for BI 7.0 for GUI 7.0 and Front-end components and Product Availability Matrix (PAM) for SAP Netweaver 7.0.
• Reactivating the SAP BI System after Upgrading, Running RSD1 to check Info Objects,
• Check the correct Patches of the BI Front-end and SAP Notes for latest information and fixes for various issues during Upgrade ‘Migration’ process.
• Checking Standard IMG with SPRO and basic customizing settings.
• Setting up the migration of the new Authorizations concept of Netweaver 7.0(New BI Authorizations using Analysis Authorization) and the considerations/issues with migration.
• Worked on SAP GUI considerations for end user (that do not design/develop) queries.
• Worked on Unicode and the issues with data exchange from ECC 5.0 to BI 7.0 and installing of language in the new BI 7.0 system.

Confidential, Lake Forest, IL

SAP BW Consultant

Environment: SAP R/3 Enterprise, BW 3.1C, WAS 6.40, CRM 4.0, Oracle, Win NT.

Responsibilities:

• Daily Data Load Monitoring of the BW jobs. Ensuring daily data uploads from R/3 Ent. and R/3 3.1 are successful, Mail notification on status of upload.
• Support users spread globally in their day-to-day reporting requirements.
• Attending to the Production User s BW issues and cases filed in Support Central and providing solution within specific time frame, Support any data issues in terms of the BW data or BW Web and BeX reports.
• Rerunning / Scheduling of failed Process Chains / data loads
• Worked on Automated Backorder Matrix setup responsible for publishing the BackOrder Summary by Product Segment and BackOrder by Profit Center on the web server.
• Coded User Exits and Update rules to customize the extractors to meets the business needs.
• Worked on Modifying the existing Update Rules and changing the Update Rules for the Monetization Data extract program to Update new Key Figures and add/exclude company codes as per the Business requirements.
• Used ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to Update Key Figures in the Info Cubes.
• Outbound Data feeds from BW Server to Cockpit. Cockpit Job Scheduling, Deliverable times and Trouble shooting.
• OSI FOTC Setup need to get FOTC data from R/3 3.1 system. Uploading the weekly non-SAP data and uploading the FOTC feed to GE Plastics Server.
• Setup Monetization and Accrual process for R/3 Enterprise and 3.1 systems. Schedule Process, report and distribution list.
• Worked on a BW Project for BW - R/3 Data Validation and Control for Finance, Sales SD, SCM and CRM.
• Controls will reconcile data across all three BW layers
• Controls will be prioritized based on the following five criteria:
• Criticality to the business (regulatory, customer or vendor-facing, financial impact)
• Extracted Master data from R/3 systems; designed, implemented and tested the ABAP programs to collect data from R/3, coded Abap/4 programs for generic data extraction to BW.
• Develop & test controls
• Develop success & failure notification workflow
• Develop metrics & historical reporting

Confidential, St. Louis, MO

SAP BW Techno-Functional Consultant

Environment: SAP R/3 4.6C, BW3.1, WAS 6.40, Oracle, Win NT.

Responsibilities:

• Responsible for the design, configuration, and customization of SAP BW Reporting in SAP FI, SAP CO modules.
• Worked on BW Cube Development, Extensive Web reporting, BEx reporting experience with Macros and Excel functions Custom development. Automation of running reports.
• Write specifications for business processes, subsystems, programs, reports and interfaces according to customer standards, Support the configuration of the SAP R/3 system in the BW areas
• Optimize business processes, fine tune and enhance existing reports and data procedures, redesign infocubes.
• Attending to the Production Users BW issues and cases filed in Support Central and providing solution within specific time frame, support any data issues in terms of the BW data or BW Frontend Web Reports and BeX Workbooks been used by the Business Users for Fi-Co modules.
• Daily Data Load Monitoring of the BW jobs. Ensuring daily data uploads from R/3 4.6 aresuccessful, mail notification on status of upload.
• Support users spread in 4 states in their day-to-day reporting requirements.
• BW maintenance - Data deletion from PSA \, Patch Upgrade.
• Rerunning / Scheduling of failed Process Chains / data loads

Confidential, Roseville, CA

SAP BW Techno-Functional Consultant

Environment: SAP R/3 Enterprise, BW3.5, BI 7.0, CRM 4.0, Win NT.

Responsibilities:

• Working on data extraction from SAP CRM Service, CRM Sales and Activities to BW.
• Created service tickets, introduction follow-ups and complaints in web client of CRM by using transaction CRM IC.
• Created various data models, ODS and cubes based on business requirements and business transaction types like service ticket, complaint and follow-ups.
• Extracted data from CRM system by delta initialization, full updates and delta to various data providers.
• Created process chains to automate the loading process.
• Created reports on business requirements, service ticket follow-ups, and interactions.
• Created data extracts as flat CSV files and exported the data to different third party servers by using RSCRM BAPI.
• Working on BW-CRM integration and experience working on CRM infocubes in BW for creating queries for Service Confirmation, Activities and Business Partner analysis from CRM data.
• Worked on CRM cube modelling.
• Analyzing business processes of SAP CRM/BW solution possibilities and discussing these with business users.
• Consult with the users/functional teams to gather and interpret their documented reporting requirements for SAP CRM projects.
• Replication of Master, Transactional & Customizing objects between SAP R/3, BW & CRM system.

Confidential, Endicott, NY

SAP Techno-Functional (Project Lead)

Environment: SAPR/3 Enterprise, BI 7.0, BW3.1C, Oracle, Win NT

Responsibilities:

• Worked on an IBM BW project for developing a P2P and Warehouse Management BW Utility product (Customized BW product) as per client for IBM’s client’s requirement.
• Co-ordinate and managed both the Onsite & Offshore Project team members
• Mentor and Advised to IBM whether to do an upgrade from SAP BW 3.1c landscape to BI 7.0 (SAP BW 2004’s Upgrade) or to install a new fresh BI7.0 installation based on various factors and reasons like example - Multi-language and Unicode (Unicode is not possible from 3.1C to BI7.0 as BW 3.1 doesn’t have Unicode) and how to use the new features available in BI 7.0(SAP BW 2004’s).
• Re-developing and re-design the Data Models, BW Cubes, ODS’s, Configuration, BeX queries in the BI 7.0 system.
• Developed new BW Web Templates, Web and BeX Reports and BeX queries from Functional Specs.
• Worked and setup the Bex Broadcaster Wizard to send queries, workbooks and Web Applictions as emails and broadcast them into EP using ‘Continue’ and ‘Execute’ options.
• Working constantly with SAP OSS and communicating back and forth with SAP and fixing the issues and problems successfully, which cropped up during the new install and re-development process.

Confidential, Houston, TX

Sr. SAP BW Consultant

Environment: SAPR/3Enterprise, BW3.5, Win NT

Responsibilities:

• Developed BW Web Templates, Web and BeX Reports and BeX queries from Functional Specs.
• Worked on Portal branding (Customizing the company Portal), in Net Weaver Development environment and in Portal Integration, created content for the Portal using iViews, Pages, Worksets, Roles. Assigned iViews to pages, pages toworksets, and worksets to roles.
• Worked with CSS files, JAVA Script and HTML in WAD.
• Created Tab and Role Menu Interfaces for the end-users (look and feel)
• Designing and editing table classes in SE80.
• Created Queries on Web browser with Ad-hoc Query Designer.
• Created Standard Web templates, Currency translation, Enhanced Menu on web browser, Printing, Variable Screen, Report to Report Interface(RSBBS)
• Working with RSRCACHE for setting cache parameters, User Exits, PFCG (Creating End User Roles) and are used in Role Menu (WAD).

Confidential, Albany, NY

SAP BW Project Lead

Environnent: SAP R/3 4.7/3.1, BW 3.0B, Oracle, UNIX

Responsibilities:

• Worked with CSS files, JAVA Script and HTML in WAD.
• Created Tab and Role Menu Interfaces for the end-users (look and feel)
• Created pre-calculated web templates and keeping the variants in process chains for daily scheduling and for performance increase.
• Designing and editing table classes in SE80.
• Created Queries on Web browser with Ad-hoc Query Designer.
• Created Standard Web templates, Currency translation, Enhanced Menu on web browser, Printing, Variable Screen, Report to Report Interface(RSBBS)
• Working with RSRCACHE for setting cache parameters, User Exits, PFCG (Creating End User Roles) and are used in Role Menu (WAD).
• Archiving the data in SAP BW, Performance Techniques (Aggregates, DB Stats, OLAP Cache etc.)

Confidential, New York City, NY

BW Project lead

Environment: SAP R/3 4.6C, BW 3.1C, CRM 3.0, Oracle, Win NT.

Responsibilities:

• Implemented the world-wide BW security setup by designing the security model with several levels of security.
• Review the current security design and landscape and make recommendations for efficiency improvements and growth.
• Gather and document requirements from the project team on level of security required for the project.
• Develop naming standards for the new level of security roles ensuring it integrates well with the current naming standards.
• Create new security roles using Profile Generator
• Analyzing business processes of SAP solution possibilities and discussing these with business users.
• Consult with the users/functional teams to gather and interpret their documented reporting requirements for SAP CRM projects.
• Worked on segment and target group counts for campaign/contact sizing.
• Worked on campaign/contact/impact response reports.
• Worked on survey response reports.
• Create a campaign and customer contact performance analysis report.
• Create campaign and customer contact effectiveness analysis
• Developed supporting business process procedures that allow for an automated data load and promulgation of data to the warehouse.
• Assist in the technical preparation of Business Process Procedures, Test Scenarios, End-user documentation, and User manuals.
• Develop logical data models using best practices for data capture, data dictionary design, maintenance and overall data integrity.

Confidential, Boston, MA

Senior SAP BW Consultant (Tech Lead) for SAP Business Information Warehouse

Environment: SAP R/3 4.6C, BW 2.1C, BW 3.1, CRM 4.0, Informix.

Responsibilities:

• Involved in upgrading SAP BW 2.1C landscape to 3.0 and enhancements in SAP R/3 4.6C.
• Fixed alpha conversion errors encountered in BW 3.1 loadings.
• Resolved upgrade hard errors like alpha conversion and validated ABAP coding.
• Developed and executed comprehensive test plans to test the functionality and efficiency of the data after the upgrade with an emphasis on back-end cube development and data extraction/transfer.
• Worked on BW System performance tuning.
• Provide direction to the Upgrade team and is a single point of contact for all BW upgrade issues.
• Analyzed the BW System - Load performance and suggested a solution to improve performance, BW System settings - Cache, buffer, DB Sizing, Parallel loading.
• Mentored and suggested solutions for reducing the batch time.
• Testing and Analysis of the CRM 4.0 system for the CRM Business Process Integration with SAP BW after the BW Upgrade.
• Worked on BW-CRM integration and experience working on CRM InfoCubes in BW for creating queries for sales and marketing analysis from CRM data.
• Worked on CRM cube model.
• Campaign Planning cube design, Redemption Rate determination, Version management.
• Working constantly with SAP OSS and communicating back and forth with SAP and fixing the issues and problems successfully which cropped up during the upgrade process.
• Configuration, testing and analysis of upgrade being performed and documented procedure for regular day-to-day BASIS jobs in association with Basis Team.

Confidential, Boston, MA

SAP BW Consultant (Technical Lead)

Environment: SAP R/3 4.6C, BW 2.1C, Informix.

Responsibilities:

• Managed and Monitored data loads with full update and Delta mechanism.
• Worked on BW System performance tuning for data loads and BeX Reports.
• Analyzed Info Cubes (via RSRV) created and maintained aggregates (RSDDV) to improve the performance.
• Extensively used Bex Analyzer, created queries in COPA with Variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Extracted data using CO-PA (KEB0) for analyzing the data on various criteria/partitions like regions to compare cost of sales, overhead costs, product costs, & project system costs
• Converted the customer requirements in SD, MM, FI-CO and HR application areas and translated them into reporting requirements using VBA Macros
• Developed and executed comprehensive test plans to test the functionality and efficiency of the data.
• Revised and documented procedure for regular day-to-day BASIS jobs.

Confidential, Omaha, NE

BW/SEM Consultant (Technical Lead)

Environment: SAP R/3 4.6C, BW 3.1, SEM 3.2, APO 3.1.

Responsibilities:

• Worked on the SEM-BW team, creating and defining measures for the Balance Scorecard and Management Cockpit in the Performance Measurement for the ConAgra Retail and Grocery Organization.
• Loading the data from ESSbase into Cube for CPM.
• Worked on APO extraction to BW.
• Configured and implemented multi-planning area to transfer the data of income statement values planning in profit planning (Key figure model) to the Balance sheet planning (Account based model) in SEM-BPS.
• Designed and developed manual planning area and generated the planning reports for Plan versions. Worked on planning functions like - Formula, Copy, Currency translation, Forecast planning. Worked on FOX code and generated complex logic. Worked extensively on Layout builder, layout formatting, Assess Macros and their interface to SEM-BPS. Worked with Variables, data slices and planning profiles.
• Configured and Implemented web based Status and Tracking system application for clear assignment of planning task to various end users and automatically lock approved plan data for planning.
• Configured and Implemented SEM-CPM Balanced Scorecard for Retail Customer service center, that included design of measures that make use of Customer & Employee Survey ODS developed at the BW side and two main strategies like Operational Excellence and Customer Care Strategy with following main perspectives at the SEM side.
• Great Result Perspective
• Great Customer Perspective
• Great Process (Order Management) Perspective
• Great People Perspective
• Worked on defining the query on BW for SD and Fi-Co to be fed to the measures for Reports.
• Involved in Requirement Analysis, data modeling and technical implementation.
• Handled the design and development of Cube in Controlling module as part of SAP BW Controlling implementation.
• Involved in Design and Build of Custom SEM transactional cubes (3) and Controlling Custom cubes (5).
• Involved in Design and Build of Custom ODS (5)

Confidential, Hartford, CT

BW Consultant for SAP Business Information Warehouse

Environment: SAP R/3 4.6C, BW 2.1C, BW 3.0B

Responsibilities:

• Upgraded from BW Ver 2.1C to 3.0 B.
• Fixed alpha conversion errors encountered in BW 3.0 B loadings.
• Actively involved in end user requirement gathering.
• Involved in designing the Data Model from end user requirement.
• Responsible for data extraction from R/3 source system using LO, COPA Data Extraction and Flat file to BW for SD, MM and HR.
• Did the Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the structures using user exits to support the business needs. Conducted the Data Integration test in both Development and Quality boxes and moved the cubes into Production.
• Used V3 update mechanism for handling delta loads.
• Responsible for design and development and data extraction from PeopleSoft HR (legacy system) application and loading it to SAP BW for reports using Flat files.
• Designed and developed ODS objects and built Infoset queries.
• Designed permanent templates for web reporting, and configured the system to publish variables on the web
• Implemented BEx Reporting and BW Web Reporting and embedded them in MySAP workplace portal wherein the query is displayed.
• Convert the customer requirements and translate them into reporting requirements
• Web enabled the SAP BW query by using the SAP BW Web Publisher wizard and using the Web Publisher without the wizard.
• Developed reports using Business Explorer that had exceptions, conditional formatting, restricted key figures and calculated key figures.
• Created Query view and workbook for COPA corresponding to a business scenario containing a generic navigation block, a table, an Interactive chart and added company logo.
• Worked on data modeling and bringing historical data into BW by creating customized cubes, structures and pulling in legacy system data as excel CSV files.
• Used and worked on generic data extractors, Infosets, creating and customizing Infocubes, Multi-Cubes, ODS.
• Configured BW and Web Application Server (WAS 6.10) to display the Web templates on the browser.
• Design and development of Queries, Workbooks and Infoset queries from both Info Cubes and ODS. Used BEx analyzer and browser.
• Involved in activating and customizing standard BW content
• Created roles and defined authorization profiles and access on InfoObjects, Infocubes, and variables.
• Trained End users on BEx Reports and BW Web Reports.

Confidential, Harrisburg, PA

BW Consultant

Environment: SAP R/3 4.6C, BW 2.1C, Oracle, Win NT, UNIX, ITS.

Responsibilities:

• Configured 16 delivered Cubes in BW2.1C and 6 Custom Cubes for Sales Forecasting, Shipments, Sales Provisioning, Inventory, Dunnage, etc
• Uploaded master data and transaction data from SAP R/3 via Data Staging to PSA, ODS and InfoCubes
• Configured and customized datasources, infosources and Info Cubes
• Analysis and blueprinting of scope for 111 delivered and 56 custom queries
• Heavily involved in customizing and activating standard delivered BW business contents in the areas of