SUMMARY

• Experienced in leading the business team to drive projects through full development cycle within project and budget parameters. Skilled trainer and project leader, able to direct multiple tasks effectively. Exposed to all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live. Mainly solution delivery and result - oriented individual in analyzing project situations and implementing solutions.
• 16+ years of hands-on implementation, customization and maintenance experience with SAP. Including 14+ years of experience with 6 full life cycle implementations of SAP BI/BW (3.x and 7.0, 7.3 and 7.4) / BOBJ (XI 3.1 and 4.x) / BODS(4.x), SAP HANA 1.0 and 1.9 years of experience with SAP ABAP/4.
• Involved in Business Data Modeling, Implement and deploy SAP BW, BOBJ & HANA solutions to achieve defined business goals. Implemented end-to-end data warehousing and analytics.
• As SAP HANA Solution Architect Created HANA Analytic Views, Attribute Views, Calculation Views and HANA Security/User setup & Configuration. Developed Schemas, Schema mapping and Programming in HANA including ABAP, SQL Script and CE Functions.
• Experienced in gathering Business Requirements, Analysis, Design, Development, Testing, Implementation, Upgrade and Production Support across various industries.
• Proficient at translating business goals and requirements into SAP BI solutions, guiding clients through effective blueprint workshops, facilitating decisions on best practice procedures, and overseeing.
• Experienced in Designing the Global systems to give the global reporting and performance point of view.
• Experienced in SAP Process knowledge with respect to CRM, APO, FICO, SD, MM, HR & GTM modules.
• Experienced in data modeling, gathering requirements, translating into functional/design specifications, creating info objects, info providers, creating BW/BOBJ reports using WEBI/BEX/WAD/VC/QlikView objects.
• Proven track record of improving ETL load and Query Performance by efficient design (e.g., data modeling, indexing, architecture, configuration, performance tuning, etc…) and overall understanding of the system landscape and experience technical knowledge.
• Comprehensive Team Lead experience implementing SAP BI related to extracting, transforming and loading data (ETL) from SAP R3, APO, CRM and legacy systems into SAP BI/BW Systems.
• Activation, enhancements & Installation of Business Content for CRM, SD, FICO, MM, PP, HR and GTM.
• Strong hands on experience in the Upgrade project from BW 3.1C to BI 7.0 (SAP NetWeaver 2004s)
• Which includes all the stages of Ramp-up starting from the migration of classical 3.x dataflow mechanism (migrate 3.x datasource to 7.0 datasource, creating Transformations, DTP’s etc), creating new 7.0 Dataflow and comparing output as a result of the migration till Go-Live
• Strong hands on experience in the Upgrade project from BI 7.0 (SAP NetWeaver 2004s) to BW 7.3 and BW 7.4 with HANA as Database.
• Worked on Non SAP Systems (Oracle, AS400 and System2000) Using DB Connect, UD Connect and involved in Extraction configuration.
• Excellent Experience in the Extraction, extensively used LO-Cockpit, COPA, Generic Extraction (Delta Enabled) methods for data extraction.
• Experience in Data Source Enhancement, OLTP extraction data, Loading (Full /Delta Up- Load), Monitoring, Remote Cubes, Data Mart, Open Hub Service, Performance Tuning, Aggregates and BW Transports.
• Experience in Enhancement of Data Sources using User Exits as per the client requirements. Used ABAP coding in Start Routines, End Routines, and Expert Routines and at different levels of Transformation
• Experienced on Developing the CEO Dashboards.
• Configuration of Batch jobs, Process Chain, event management and Report to report interface.
• Experienced in activating and enhance business content objects, enhancing standard SAP data extractors and creating generic data extractors.
• Experienced on Enhancements, Information Broadcasting and Integrate the BI Web Applications into Enterprise Portal.
• Experienced in providing complete knowledge transfer and conducted several BI internal training sessions.
• Production Support - Extensive experience in support, Data loads, Validation and trouble shooting of transaction data and Master data, Change management, Transport Management, Roles & Security, System Checks, Performance tuning and process chains.

TECHNICAL SKILLS

ERP: SAP ECC 6.0/5.0, SAP R/3 4.7/4.6c/4.0b

BI/BW/HANA: BW 7.4/7.3/7.0/3.5/3.1 C/3.0B - HANA 1.0 - SP7

Functional Areas: FICO, SD, MM, HR, CRM (4.0, 5.0 and 7.0), APO (SCM 4.0), GTM and SEM.

Reporting Tools: BEx, WAD, QV, Web/Desktop Intelligence, BOXI 3.1, BO 4.0, 4.1, 4.2, BODS 4.0, 4.1, Xcelsius 2008+, Crystal 2008, 2011 and 2013 and Dashboards 4.1

Operating Systems: Windows 95/ NT 4.0/98/2000/XP/7/8/10 and UNIX

Database: Oracle 11g/10g/9i/8.0/7.0, SQL Server 2005/2008 R2/2012/2014

Languages: ABAP/4, HTML, Java Script, JAVA, C, C++

Tools: ASAP, MS VSS, Visio, MS Office and SQL

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

BW BOBJ Lead Consultant

Environment: SAP BI 7.4, SAP BO 4.0

Responsibilities:

• Worked on enhancing "Schedule of Net Pension Liability for Employers and Non-Employer Contributing Entity (BOBJ144)" and "Statement of Changes in Fiduciary Net Position (BOBJ049)" Webi reports to in- corporate newly created Fund and GL Hierarchy Changes.
• Worked on Quarterly Release Change Requests and Day-Day Incidents and Non-Release Change Requests. (Change Requests and Incidents include BW Backend, Bex Query and BOBJ Changes)

Confidential

BW BOBJ Lead Consultant

Environment: SAP BI 7.4, SAP BO 4.0

Responsibilities:

• Worked on developing below BOBJ Webi, Crystal and Analysis Workspace Reports as a part of GASB 74/75 Project.
• Complete data flow is implemented in BW backed (Infor Providers along with Transformations logic as per the FDS) along with Bex Queries for Development of below BOBJ Reports.
• BOBJ190 - Deferred Inflow and Outflow Amortization Schedule - MPP
• BOBJ191 - Schedule of Proportionate Share for Employers of Confidential Medicare Premium Payment Program
• BOBJ192 - Report of Medicare Premiums and Surcharges Paid
• BOBJ183 - Schedule of Changes in Net OPEB Liability of Employers
• BOBJ184 - Net OPEB Liability of Employers
• BOBJ185 - Schedule of Employer Contributions - OPEB
• BOBJ186 - Sensitivity of Net OPEB Liability to Changes in Health Care Cost Rates
• BOBJ187 - Sensitivity of Net OPEB Liability to Changes in Discount Rate
• BOBJ188 - Schedule of Aggregate OPEB Amounts for Employers
• BOBJ189 - Money Weighted Rate of Return - THBF

Confidential, Raleigh, NC

BW Sr. Consultant

Environment: SAP BI 7.3, SAP BO 4.1 and 4.2

Responsibilities:

• Worked on Migrating existing BEx Webi Reports to Business Objects Webi, CRE and Dashboard Reports. The migration process includes Back-end changes like changing the Transformation logic, Bex Query Customer exit changes and Data source enhancement changes for below BOBJ Reports.
• Worked on Migrating BEx Report FMLA Overview in PT to BOBJ Web Intelligence.
• Worked on Enhancements to Change the existing BOBJ Web Intelligence Reports based on requirements.
• Worked on Migrating BEx Benefits Reports to BOBJ Web Intelligence.
• Worked on Migrating BEx PA EEO Reports to Crystal Reports.
• Migrated BEx Reports Employee Appointed Exempt Designation, Retroactive Position Time Setting Changes - Details in PA and OM to BOBJ Web Intelligence.
• Migrated BEx Reports Position Eligibility Settings, Employment Eligibility Verification & Residence Status in PA and OM to BOBJ Web Intelligence.
• Migrated BEx Reports VSL Eligibility by Start Date, VSL by Donor, Comp Time Aging and VSL by Receiver in PT to BOBJ Web intelligence.
• Worked on Different Web Intelligence BO Functionalities like Breaks, Sorts, Merging, Table Formatting, Cell Formatting, Chart Types, Table Types, Filtering, Formulas and Variables during development of above WEBI Reports.
• Implemented Customized features in Input Controls to display the Graph dynamically between two measures in Comp Time Aging Report.
• Implemented Customized features in Conditional formatting to sort the Text of Calendar Month/Year in right order for Comp Time Aging and FMLA Overview Reports.

Confidential

BW Lead Consultant

Environment: SAP BI 7.4, SAP BO 4.1

Responsibilities:

• Created Web Intelligence Interactive Reports based on BEx HR Queries like Benefits Reports and Personnel Time Management Reports using BICS Connections through IDT.
• Worked on Different Web Intelligence BO Functionalities like Sections, Breaks, Sorts, Merging, Table Formatting, Cell Formatting, Chart Types, Table Types, Filtering, Formulas and Variables during development of above WEBI Reports.
• Full Knowledge of BEx and BO WEBI Integration and have followed best practice scenarios while developing BO WEBI reports based on BEx HR Queries to improve the Performance in WEBI.
• Created Dashboard HR Reports like Compensation Management Reporting and Organization Management Reporting based on BEx HR Queries using Dashboard Design Tool in BO.
• Used Different Chart types and Dashboard Components while creating the above Dashboard Reports.
• Migrated the Crystal Reports 2008 which are in SAP BO 3.1 to BO 4.1 Crystal Reports for Enterprise.

Confidential

SAP BW-BOBJ HANA Lead Consultant

Environment: SAP BW 7.4, SAP HANA 1.0, BODS 4.1 and SAP ECC 6.0

Responsibilities:

• Involved in SAP BW Upgrade project from BW 7.0 to BW 7.4 with HANA as a Database. (After Acquisition of Pergo by Mohawk Industries - Unilin Corporation, Data Integration Project is done from Pergo BW 7.3 Systems to Unilin BW 7.0 System. After this, Upgrade Project in Unilin is done from BW 7.0 to BW 7.4 with HANA as a Data base).
• Performed Pre-and Post-Upgrade Activities during Upgrade through Program ZBW HANA MIGRATION COCKPIT (SAP NetWeaver BW Migration Cockpit for SAP HANA).
• Full Understanding and Implementing Experience of In-Memory DSO’s Architecture Tables like Activation Queue, Active Data Table (Main Storage, History Storage and Delta Storage) and Change Log Tables.
• Converted Standard Sales DSO’s to In-Memory DSO’s during Upgrade Process using Migration Tool RSMIGRHANADB.
• Created Transient Providers/Analytical Indexes using Tool RSDD HM PUBLISH after Upgrade to deploy the Information Models Created in HANA Schemas for COPA and GL Tables for Finance Reporting.
• Created Composite Providers based on Transient Providers (COPA and GL) and Budget and Forecast Info cubes in SAP BW for Finance Reporting.
• Participated in HANA strategy planning and HANA Box setup and development activities.
• Created HANA Analytic Views, Attribute Views and Calculation Views on COPA and GL Tables for Finance Reports Profit and Loss by Channel Report and Profitability Analysis by Customer Reports.
• Data Provisioning is done for COPA and GL Tables by SLT for Real-time Replication. ABAP Programming is done in SLT based on Business Requirements.
• Developed Schemas, Schema mapping, HANA programming including SQL Script and CE Functions.
• Participated in future HANA Strategies and Workshops.
• Utilized SAP Business Objects Data Services to Extract Data from SAP ERP and load it into SAP HANA Database for CARA (Claims) Reporting.
• Developed Custom Customer Sales Reporting within Claims for Specialty Sales to keep track of the sales which are done by Specialty Customers.
• Developed Item Movement Report to keep track of Specialty Items that are sold by Custom Customers.
• Utilized transaction LTR in ECC per SAP Landscape Transformation (SLT) when setting up data loads for SAP HANA Database. Utilized in ECC (SD11) in creating data model models delivered specifically as Rapid Development Solutions (RDS).
• Worked extensively with HANA Studio.
• Created Attribute views, Analytical views and Calculated views (graphical and SQL Script) for data consumption by BOBJ Explorer for Finance Reports Cost of Sales, Administrative Expenses, Operation Support Expenses and Shared Services Expenses Reports.
• Identified the tables in ERP system using SE15 or SE84 to find the relevant table(s).
• Configured the source data system for RFC access from the SLT Component.
• Configured the target SAP HANA system for access by the SLT component.
• Setup replication using the SAP HANA In-Memory studio.
• Start replication from the source system to the target SAP HANA system.
• Analyzed Data in SAP HANA using the Excel interface to SAP BO 4.0 tools.

Confidential

SAP BW-BOBJ HANA Lead Consultant

Environment: SAP BW 7.4, SAP HANA 1.0, BODS 4.1, SAP ECC 6.0 and SAP CRM7.0

Responsibilities:

• After Acquisition of Pergo by Mohawk Industries, as a part of Integration Project, Consolidated Qlikview Claim Action Details, Complaint Details, Claim Escalations and Channel Analysis to Mohawk BW System.
• Developed Schemas, Schema mapping, HANA programming including SQL Script and CE Functions for CRM Models in HANA.
• Utilized SAP Business Objects Data Services to Extract Data from Qlikview SQL Server and loaded into SAP HANA Database for CARA (Claims) Reporting.
• Developed Custom Customer Sales Reporting Integrating with Mohawk CRM information within Claims for Specialty Sales to keep track of the sales which are done by Specialty Customers.

Confidential

BW Lead Consultant

Environment: SAP BW 7.3 and SAP ECC 6.0

Responsibilities:

• After Acquisition of Pergo by Mohawk Industries, as a part of Integration Project, developed Programs, APD’s in Pergo SAP BW Systems to generate the Files and Load into Unilin BW Systems. (Unilin is Child Company of Mohawk Industries with Laminate Business)
• Built a Data Model to Generate the COPA Files and developed APD’s and Programs to deliver the File in the same format as in New System to FTP Server.
• Built a Data Model to Generate the Sales Files and developed APD’s and Programs to deliver the File in the same format as in New System to FTP Server.
• Built a Data Model to Generate the HR Files and developed APD’s and Programs to deliver the File in the same format as in New System to FTP Server.

Confidential

BW Lead Consultant

Environment: SAP BW 7.0, BO 4.0

Responsibilities:

• Involved in full life cycle BO project management. Responsible for requirement gathering, technical design, development and testing.
• Worked Extensively on Data Analysis in SQL to build schemas and Universes in IDT 4.0 to develop Claims Reporting based on requirements.
• Worked on maintaining parameters and list of values in IDT and resolved Chasm trap and fan trap loop issues using Aliases and Contexts.
• Developed WEBI Report for Inventory Analysis, Bookings MTD and YTD and COPA Models based on BEx Queries using BICS Connections.
• Created the Purchase Order Receipts and Product Purchasing by Plant Web Intelligence reports based on BEx Queries using BICS Connection and using BO functionalities like combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and formulas.
• Worked on Creating formula variables, Conditional formatting, sorting and breaking etc., in above WEBI Reports.
• Created the Dashboards using all types of Dashboard Components such as Charts, Selectors, Drop down box for Executive Dashboard Report.
• Created Crystal Reports for Claims Department like Claim Action Details, Complaint Details, Claim Escalations and Channel Analysis.
• Created and managed folders, structures, groups, users, securities, Events, calendars, Access Levels, Categories, Profiles, Servers, Connections, Universes, Voyager Connections, sessions, license keys, Personal folders and inboxes etc. using the CMC.

Confidential

BW Lead Consultant

Environment: SAP BW 7.3 and 7.0, SAP ECC 6.0

Responsibilities:

• Lead team of BI developers to deliver Finance P&L, Inventory and Dashboard reports.
• Lead Offshore IBM and Wissen Team and helping to solve the Critical Support Issues.
• Worked in BI 7.0 environment with various functionalities in the back-end and front-end areas.
• Worked on KE24 Report in BI to get the COPA Actual Information as per the User Requirements which replaces manual report performing by Users every month.
• Worked on Product Costing Report based on extractors Product Cost Planning: Itemizations Costing (0CO PC PCP 03) and Product Cost Planning: All Calculations (0CO PC PCP 01) for Finance.
• Worked on implementing the macros for Product Costing Report to get the report format based on user Requirements.
• Fixed some of the orders in BI through Selective Deletion Process that was deleted by Users in SAP ECC. This resolved the negative order quantities and shipped quantities impact on Sales Performance Report.
• Worked on BI P&L Reporting for Pergo LLC Flooring and Laval Canada to fix the KPI issues and to add the additional columns to workbooks like Commercial Actual and Commercial Budget Sales offices.
• Developed BI P&L report for Pergo Molding which is based on Extractors Profit Center: Actual Line Items (0EC PCA 3), Material movements (2LIS 03 BF), General Ledger: Leading Ledger Balances (0FI GL 10) and COPA Actuals.
• Developed BI P&L report for Pergo Flooring which is based on Extractors Profit Center: Actual Line Items (0EC PCA 3), Material movements (2LIS 03 BF), General Ledger: Leading Ledger Balances (0FI GL 10) and COPA Actuals.
• Worked on Executive Dash Board Report BI Objects that gets the data from SD, Inventory from Production, Inventory from GL and COPA Actuals and Budgets.
• Developed various Models to load the Executive Dash Board Information to different DSOs (Write Optimized and Standard DSOs).
• Developed Different Analysis Process Designers (APDs) to extract the Bex Query Information to DSOs for Qlik View which is used as Front-end tool for Executive Dash Board Reporting.
• Developed BI Inventory on Hand Report that gets the Available inventory on Hand on Monthly Basis based on Inventory Extractors Material movements (2LIS 03 BF), Material Valuation: Prices (0CO PC ACT 05) and General Ledger: Leading Ledger Balances (0FI GL 10).
• Created macros in Inventory on Hand Report to get the Report format as per the user Requirements.
• Fixed the Issues in BI Inventory on Hand Report to populate the Quantities in M2 Conversion Factor.
• Developed New Design for BI-Aged Report to integrate the Sales and Inventory Data through Transformations and DTPs.

Confidential

SAP BW Lead Consultant

Responsibilities:

• Lead team of BI developers to deliver BI POP and Material Ledger reports.
• Worked on BI-POP Project to integrate the Position/Sales data and Pricing Condition Data.
• Developing New Design for BI-POP Project to integrate the Position/Sales and Pricing Data through Transformations and DTPs.
• Worked on Material Ledger Enhancements to populate the Dates and to maintain the History for Cost Simulation KPIs based on Business Requirements.
• Developed Prototypes for the above two tasks in Sandbox and needs to get the sign-off from Business before starting the Development.
• Gave Suggestions to the Off-shore team to re-model the existing Data Targets to improve the Performance.

Confidential

SAP BI Lead Consultant

Responsibilities:

• Used the LO cockpit for extraction of data into the BW for GTM.
• The extractor 2LIS 46 SCL was used for the above said purpose using Queued Delta (V3) update.
• Enhanced the Data GTM Data Source 2LIS 46 SCL (Global Trade Management: Trading Contract Schedule Line Data) based on Reporting requirements.
• Was involved in Automation of the GL posting to be done from the BW system.
• For the above mentioned task the BW system was used as a transactional system and used to generate General Ledger postings for Un-settled tickets, Un-invoiced tickets, AP Purchase tickets, AR Purchase tickets and DP Storage tickets for month-end.
• Was singly involved in the design, development of the whole process flow including the queries.
• The queries were inserted in Workbooks with System(R/3) readable format to be used for the postings.
• Worked on Macros to get the same workbook format as per the business.
• Created month end process chains for the purpose of GL postings.
• Worked with Business user to help and educate them on various aspects of queries and workbooks built.
• Designed Universes for Vendor Analysis, Customer/Vendor Status Open Business and GLSU Models based on Bex Queries.
• Created the Customer/Vendor Status Web Intelligence reports based on Universe using BO functionalities like combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and formulas and deployed through Info View.
• Created the Dashboards using all types of Xcelsius Components such as Charts, Selectors, Drop down box for Vendor Analysis.
• Created and managed folders, structures, groups, users, securities, Events, calendars, Access Levels, Categories, Profiles, Servers, Connections, Universes, Voyager Connections, sessions, license keys, Personal folders and inboxes etc. using the CMC.
• Created Crystal Reports based on Quality Claims Model Universe and from Flat file Data source. Used most of the functionalities of Crystal Reports to format the report based in User Requirements.

Confidential

ENVIRONMENT: SAP BI 7.0, Net weaver 2004s, ECC 6.0, CRM 5.0, Business Explorer, SD, MM and Channel Management, Windows XP.

Responsibilities:

• Requirements gathering, analysis, gaps, face-face to interactions with business teams.
• Published strategy, blue printing and realization documents for Material Model, Backlog, Booking and Billing sales cubes.
• Published strategy, blue print, and realization documents for POS, DPA, Channel Inventory, Claims cubes of Channel Management.
• Prototyped the data flows, transformations, DTPs for Backlog, Booking, POS, DPA, Claims, and Channel Inventory cubes.
• Technical Review of all BI Deliverables.
• Creating Authorizations based analysis of authorizations model and assigning them users and roles.
• Developed Open Hub objects to distribute POS and Backlog data to External reporting systems.
• Created process chains and job scheduling ABAP programs to automate Job flow. Developed BEx Queries, Web templates, Work books for Users.
• Published User Training Manuals, trained users on BEx features and usage of Sales, CRM cubes.
• Performance Tuning by building Aggregates, Partitions, Indexes, Cache Warm-up, Tracing the Query outputs, Redesign the cubes based on Dimensional Table sizes, pre-calculation workbooks.
• Designed and Developed Tools to track dimensional table growth, migrating update rules and Hierarchies, Utility programs to monitor the system.
• Implemented Broad Casting strategies to send pre-calculated Workbooks to users.

Confidential

BI Lead consultant

Environment: SAP BI 7.0, Net weaver 2004s, ECC 6.0, EP 7.0, CRM 4.0 and SCM-APO 4.0

Responsibilities:

• Expertise in BI 7.0 and served as Sr. technical consultant for BI upgrade.
• Expertise in new features like DTP’s, transformations in BI 7.0.
• Deployed Functional Specs, Technical specs as per the Templates specific to Quality Standards in Upgrade Project.
• Involved in SPAU and SPDD Analysis during Upgrade.
• Documented Various Issues which we faced during Upgrade in Specific Templates.
• Re-keyed various Objects which we developed in earlier version in new systems due to Dual-Core Landscape.
• Involved in Re-design Development of Backlog Design (The Old 3.1C Backlog Flow is Re-designed in BI 7.0) in Upgrade project using New Concepts of BI 7.0 like Data Transfer Process and Write Optimized DSO.
• Experience in analysis, design and development of full life cycle BI implementation.
• Involved in Cut-over Activities during system Go-live.

Confidential

BW Lead Consultant

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

Responsibilities:

• Installed SAP delivered SD data sources from LO cockpit and enhanced the data sources to add extra fields according to the business requirement.
• Conducted extraction of data (Delta Load) using the data sources (LO Extraction) 2LIS 12 VCSCL (Sales-Shipping: Schedule Line Delivery), 2LIS 13 VDITM (Billing Document Data: Items) and 2LIS 11 VAITM (Sales Order Item Data).
• Modified the Extract Structures of LO cockpit data sources as per business requirements.
• Created ODS objects to load Billing, Booking and Deliveries data and stored in different levels before loading to the cubes.
• Designed new ODS and loaded data from Bookings, Billings, Deliveries data and calculated Backlog as per business requirement.
• Designed and implemented second level data mart loads for Backlog calculation (SD) including requisite data transformations.
• Designed custom extractors with Delta functionality and created the functional specifications for the development of function modules to extract the data.
• Created security authorization objects for Info Objects, Info Cubes to implement end-user security.
• Worked in Open Hub Service for transferring the data to downstream systems including performance tuning of transformations.
• Designed and developed the data flow and data targets in FI-GL, AP and AR.
• Designed and extracted Account Receivables data using Data Sources 0FI AR 4, 0FI AR 6, 0FI AR 9 and 0FI AR 10 to the data targets 0FIAR O03, 0FIAR C03, 0FIAR O06 and 0FIAR O10.
• Extracted GL and AP data to the data targets ZFIGLO02, ZFIAP O03 and to the corresponding cubes using 0FI GL 4 and 0FI AP 4 data sources.

Confidential

BW Sr. Consultant

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

Responsibilities:

• Installed and Activated Services data sources to extract data to BW.
• Extracted data for Contracts Items, Quotations and Sales to different ODS objects 0CRM PROH (Orders (Header Data)), 0CRM SALO (Sales Orders Items), and to the cubes 0CSAL C01 (Activities) and created queries as per user requirements.
• Excellent working experience with the services data sources 0CRM SERVICES CONTRACT H, 0CRM SERVICE PROCESS I and 0CRM SALES CONTRACTS I.
• Created generic data sources to meet the business requirements and extracted delta’s to BW.
• Created a Z table to store the time stamps of the data sources and maintained it through a FM to reset the time stamp for the delta issues.
• Resolved critical issues faced during the implementation
• Experienced in configuring BPS planning objects including Planning Areas, Planning Levels, Planning Packages, Planning Functions, Planning Sequences, Planning Profiles, Web Interface Builder and Planning folders.
• Gathered user requirements, map against delivered SAP content, and translate into a coherent design document for SAP BW/SEM/BPS Deployment.
• Experience in enhancing and customizing SAP (SEM-BPS) delivered planning objects, including planning Info Cubes and planning applications for different business planning scenarios

Confidential

SAP BW Consultant

Environment: SAP BW 3.1C, BW 3.5, SAP R/3 4.7, EP 5.0, Java Script and HTML

Responsibilities:

• Created custom Info cube based on the Business Content Info cube 0IC C03 to store the Inventory data and used three standard Data sources 2LIS 03 BX, 2LIS 03 BF and 2LIS 03 UM and loaded inventory data into the Info cube.
• Created custom Info cube to store the actual, plan, and budgeted supply data from different source systems. For this created generic data source on Info set to get the planned supply data from R3 Worked on Web Reporting using SAP web wizard.
• Extraction, transformation and loading of data into BW constructs (PSA, ODS, Info Cubes).
• Created and maintained aggregates, master tables and hierarchies.
• Configuring Transportation Layer from Development Server to Quality Assurance and production environment using SAP-BW transport Organizer.
• Developed interactive report listing purchase orders. Created during a specific time period which on drill down displays a sub sequent list of line items for a selected purchase order with information like quantity ordered/received, net value and item description.
• Customer analysis report gives detail purchase amount, outstanding balance, in a fiscal year.
• Developed a report that will show the total value of Inventory order by Customer (consignment fill-up sales order) against the total value Invoiced to Customer (consignment issue sales order).