SUMMARY

• Total of Fourteen years experienced in IT Industry, of which Eleven years only in SAP. Current focus is on SAP Business Warehouse (BW) Database’s Design (Info cube), Development (Info cube, ODS), Installation (BW Central and Database Instance), Configuration (Info cubes, extractors, Business Content), Fine Tuning (BW Production Go live), BW Upgrades, Sizing (Pre Installation of BW), Capacity planning, Performance, sizing using SAP ASAP methodologies.
• I have experience with SAP/Data warehouse and in deep experience as SAP BW Consultant using SAP BW (20B, 21C, 30A, 30B, 31C, 3.5, 7.0, 7.3) Modules and 3+ Years experience as ABAP Sap R/3 4.X. I have implemented BW through 4 Full Life cycle Projects and Nine years experience in SAP BO 4.0 and integrating BO with BI and HANA.I have experience in implementing, configuration and solving module - level issues (HR, HCM, ISU, ESS, MSS, OTC, FI, FM, PS, FI-CO, CCA, PCA, CO-PA, FI-SL, FI-GL, ECCS, GTS, IP, Procurement, Manufacturing, PM, PP, LIS, Service center, Vendor Master, SCM, CRM, SPM, MySAP.com (Financials),
• Demand to Plan), APO Demand Planning, PS, SEM-BPS, PP, MRP, MM, SD, BPC, EPM, SAP HANA etc) and Project System. I have strong experience in various phases of a project including analysis, design, development, BackOffice/Data Conversion, configuration, testing, as well as documentation, communication, coordination, documentation, project planning and interpersonal skills, experience in leading and co-ordination of offshore team and end-user training. Good understanding of project management and System Development Life Cycle

TECHNICAL SKILLS

ERP: SAP R/3 v4.6B / 4.6C / 4.70, ECC 5.0, 6.0.

SAP BW/BI: BI 7.0, B.W 3.5, 3.1c, 3.0b, 2.1c, 2.0b, HCM, ESS, MSS, ISU, D2B, CRM 4.0, SEM 3.1B, IP, BEx, WAD, Qlikview, BOBJ 4.0, BODS.

Databases: DB2, Oracle, MS SQL Server 7.0, MS Access.

Languages: ABAP/4, C, C++, VBA, ASP, HTML, JavaScript, SQL, PL/SQL.

Web Tools: MS FrontPage ’00, Macromedia Flash.

OS: Windows 9x, NT, XP, Working knowledge of UNIX, MS-DOS.

MS Office Products: Microsoft Excel, Word, Access, PowerPoint, Visio.

PROFESSIONAL SAP EXPERIENCE

Confidential, New York, NY

SAP BI/BW Lead

Responsibilities:

• Post upgrade validation of data manager packages, reports, calculations, server connection, EPM functionality
• Collected the requirements configure BPC consolidation application for legal consolidation with FX currency translation.Testing/Validating system for the 10 NWfunctionalities and following with OSS messages
• I involved in working with Master data to harmonize during data transfer to SAP BI.
• Creating planning and consolidation reports in the 10 NW system such as consolidated income statement, consolidated P&L, BVA (Budget Versus Actual) report, Head count management, income/expenses trend analysis.
• Update dimension members, perform optimization
• Maintain script logic, default logic for calculations.
• I involved working with end client like Banking Industries (J. P. Morgan, Wells Fargo and Merrill Lynch) for rating solutions using SAP BI reporting
• Involved working with Senior Compliance Officer for the Real Estate (“RE”) Division, whose activities include: commercial RE loan origination, tax credit and community development investments, RE Investment Banking activities, CMBS securitization and loan servicing functions solutions..
• Worked with Senior Compliance Officer for Structured Credit Products (e.g. CMBS, CDO, CLO, CDS, CMO etc) as well as the Structured Products Sales, Trading and Syndicate teams reporting for real time.
• Developed various deliverables like BBP, Functional and Technical specs, Data mapping and Data flow documents, GAP & Impact analysis documents, Step by step solution and Transport seq.
• Key role played in the Business objects reporting requirements, design sessions and the GAP analysis
• Worked with the team to extend the knowledge of CRM salesforce.com
• Handling script logic for complex calculation including allocation.
• Work with end user and fix issues, explain the periodical maintenance.
• Maintain, update currency re-measurement/translation in BPC/EPM, ECC as per FASB52
• Extract the periodical financial data from SAP ECC,BW to BPC applications
• Calculate the monthly retained earning
• Handled BPC security such as task profile, member access profile, team, users
• Worksheet generation
• Data Load using BODS to Crystal Reporting.
• Calling /Using BADI features in the script logic.
• Using work status features to control data
• Using API functions in the EPM reports

Environment: SAP BI 7.3, SAP ECC 6, Bex Query Designer, BOBJ 4.0, BODS, FI - GL, EPM.

Confidential

SAP BI/BW Lead

Responsibilities:

• Worked as Sr. BI BOBJ Consultant for re-implementation of FI, CR-B/IS-U
• Requirement Analysis & Workshops with business stakeholders
• Reporting/Dashboard (Cubes/Queries/Drill troughs) solution definition using BOBJ tools/BO Universe.
• Scope with analysis of the reporting needs of the project comparatively between existing and future reporting needs.
• Designed solution to implement NEW GL needs and legacy data build in SAP BW.
• Prototype to present the solution based on Legacy (Policy data) Vs ECC data (New GL basing on Ledgers) in BW.
• Implemented solution to derive the complexity through BW to bring policy data from LEGACY to BW to ECC.
• Designed IS-U implementation Logical and Physical data model
• ETL architecture- Integration with downstream (SAP ECC)and upstream feeds ( Campaign, CRM (CR-B), Analytical Models)
• Developed/Delivered workshop/trainings on CR-B components.
• Audit KPI Solution and Formulation, Infrastructure sizing.
• Responsible for identifying and developing testing scenarios for Patch Upgrades/ Upgrades as part of Production Support.
• Provide Performance Tuning activities weekly on certain BI objects including removal of PSA's, Compression, Roll ups of Aggregates.
• Provide assistance in the area of collecting, transporting and Testing of all Queries, and Workbooks.
• Excellent knowledge of SAP BW Components like Info Cubes, Multi Cubes, Info Sources, Info Objects, ODS objects, Update Rules and Transfer Rules.
• Mentored team in development of Extract Transformation Loading, Model and Analytical Components.
• Involved in the Re-Implementation rather upgrading the system due to the complex application involved in the process.
• Development of technical specification based on IS-U Functional requirements
• Integration with Mobile server components is designed using windows server machine. We supported BOBJ with windows and UNIX.
• Extensive involved in with SAP BI Accelerator (BIA) setup and index creating as well as the new features like Transformations, end-routines, DTP, Data acquisition etc.
• Integrate BOBJ data to improve the timeliness and accuracy of your information and to Reduce risk by uncovering single-supplier dependencies and monitoring contract compliance
• Involved in Improving the efficiency and security with a closed-loop process for sourcing BOBJ
• worked on Increasing the Consolidation under management by establishing performance targets
• Involved in Unit and QA testing and performed the tuning to improve the query as well as the loading performance. Created and refreshed the BWA indexes as well as DB stats.
• Involved in development of Interfaces to transfer data from SAP to middleware.
• Reviewing team member's work and coaching them and testing.

Environment: SAP BI 7.0 and 7.3, BWA, SAP BW 3.5, SAP ECC 6, BEx Query Designer, BEx Analyzer, BOBJ 4.0 and SAP Utility, FI - GL and CA, CRM (CR-B).

Confidential, New York, NY

SAP BI/BW Lead Architect

Responsibilities:

• Worked as Sr. BI/BW Lead Architect POSDM, FI, Retail Consultant
• Developed various Multiproviders for reporting needs.
• Developed several infocubes for various purposes.
• Created info packages and loaded data into infoproviders for both 3.5 and 7.0 versions.
• Involved in the Modeling and development of various BEx reports as per specifications.
• Created DSO’s and loaded data in both 3.5 and 7.0 versions.
• Performed the Purchasing analysis of materials groups, vendors, and materials, Analysis of the purchasing activities of purchasing groups.
• Performed the Vendor evaluation analysis to compare the vendors with each other and also to check whether a certain vendor deliveries a material punctually and in the desired quantity.
• Performed the reporting using Cognos and analyzed the data for the corresponding KPIs.
• Performed the CRM analysis for customer interaction center, opportunities analysis, Sales order complaints analysis, and Service Quality analysis.
• Performed the inventory analysis to analyze stock data from SAP ECC and to evaluate materials for which no movement has occurred, stock overview, slow moving items analysis.
• Created queries to analyze the comparison of wage types from different personnel areas, analysis of quarterly overview of various USA-specific restricted wage types such as total gross amount.
• Created queries to compare the costs of overtime hours with the number of overtime hours, analysis of hours lost due to illness with the illness costs, analysis of calendar quarter overview of personnel expenses using amounts for NEW G/L accounts.
• Hands on experience in scheduling BOBJ reports based on events (Event Based Scheduling).
• Worked closely with Redwood team to automate BW processes.
• Developed ABAP code to notify redwood to trigger process chain.
• Hands on experience in creating alert file manually and programmatically to notify BOBJ scheduler of data load completion.
• Worked closely with SAP Basis team to move data from FTP site to Application server and vice versa based on business requirements.
• Worked with cumulative and non-cumulative key figures in BEx applications.
• Created several user exit variables for various BEx query needs. Created several query variants in RSRT Tcode.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Transported various objects from development server to QA and Production servers.
• Interacted with the management and business end-users to identify business requirements
• Managed and monitored data loads in production.
• Worked with BW Accelerator (RSDDV), version - SAP Net weaver BI 7.0. Operating System HP-UX.
• Involved in (BWA) setup and index creating, transformations creation, end-routines, DTP, Data acquisition etc.
• Involved in resolving issues by executing BWA Re-Org analyze issue in RSDDBIAMON2 by working with transaction code TREXADIN.

Environment: SAP BI 7.0, BIA, SAP BW 3.5, SAP HANA SAP ECC 5, BEx Query Designer, BEx Analyzer, BOBJ 3.0, SAP Retail and POSDM.

Confidential, Peapack, NJ

SAP Lead Architect

Responsibilities:

• Worked as Sr. BI Lead Architect CRM, APO, HCM, GTS, FI, IP, COPA, BPC Consultant
• Managed and developed the project plan, assigning tasks to team members on the BI Upgrade Project.
• Perform and document gap analysis. Prepare estimates for Global SAP and BW system Integration project.
• Performed initial configuration of new BI 7.0/7.3 landscape including defining source systems for R/3 and ECC and legacy ERP system.
• Utilized new BI 7.0 transformations and DTPs for all new developments.
• Developed numerous custom datasources using database views and custom function modules.
• Implemented new BI 7.0 security authorization objects.
• Utilized the Analysis Process Designer (APD) to populate summary cubes using complex queries on other cubes.
• Upgrade - developed test plan for technical backend and front-end testing. Successfully completed the upgrade for each BI environment.
• Developed process chains to automate the initialization and delta updating of all data.
• Reporting - BEx/BOBJ and Web Reporting, Information Broadcasting.
• Knowledge of integrating external data sources using: DB Connect, Open Hub
• ABAP - for complex data loads in start and end routines, transformations, update rules, transfer rules. Complex functions used in BW-IP, GTS applications.
• Strong analytical, multi-tasking and problem solving skills.
• A proven resource in defining systems strategy, developing systems requirements, and implementing practical business solutions under multiple deadlines.
• Published iViews to the Enterprise Portal to be used by external business partners to access BI data.
• Created over BEX/BOBJ Reports and assigned them to roles by department.
• Identified data sources and prepared Qlikview Applications.
• Charts are used in making reports more user-friendly in analysispurposes.
• Report publishing and assigning CALs in Qlikview Server.
• Installed new technical BI business content to implement cubes for tracking usage, performance, and status of BI system.
• Integrate SPM data to improve the timeliness and accuracy of your information and to Reduce risk by uncovering single-supplier dependencies and monitoring contract compliance
• Involved in Improving the efficiency and security with a closed-loop process for sourcing and SPM
• worked on Increasing the Spend(SPM) under management by establishing performance targets
• Utilized new UOM conversion functionality available in BI 7.0
• Migrated existing APO cubes from previous BI 3.5 system.
• Involved in preparation of roadmaps for SAP HANA
• Developed Jobs in SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Loading data into table definitions, suspending data loads, resuming data loads.
• Involved in preparation of roadmaps for SAP HANA

Environment: BW 3.5, BI 7.0, BOBJ, Qlikview, ECC, FI, IP, COPA, GTS, CRM, SCM, HCM, APO, DP SAP HANA, BPC, SPM, PM.

Confidential. Morgantown, WV

SAP Lead Architect

Responsibilities:

• Worked as Sr. BI Lead Architect IP, CRM, HCM, FI COPA Consultant
• Gathered business requirements and defined deliverables along with functional analysis and worked with SAP R/3 technical and SMEs in the business areas.
• Implemented Standard Business Content InfoCubes like Line Item (0FIAR C03), Payment History (0FIAR C05), and Cost and Allocation (0CCA 11) and customized those using Update Rules. Created ODS, InfoCubes and MultiProvider for queries.
• Extracted and uploaded data into InfoCubes from DataSources like Cost and Allocation (0C0 OM CCA X), Internal Order (0C0 OM OPA X), Account Receivable (0FIAR AR 4) and Account Payable (0FIAR AP 4) for the FI & CO modules from the Business content.
• Responsible for design, development and extraction from R/3 Source system and flat files to BW for FI & CO.
• Worked with functional consultant for mapping the source data (R3/non R3) to target datasource in BW.
• Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history.
• Developed and Tested Web Reports/BOBJ for drill down functionality including updating rules and transfer rules & verifying queries.
• Create and extensively used Info spoke to feed data to data marts.
• Extensively involved in the scheduling and monitoring using process chain in Administrative Workbench.
• Monitoring and implementing the solutions to the errors in the Production System.
• Worked on the performance of queries and performed various tuning techniques using compression, aggregates and MultiProvider.

Environment: BW 3.5, BI 7.0, ECC, FI, IP, COPA, BOBJ CRM 5.0, Windows NT.

Confidential, Commack, NY

SAP CRM 5.0, IP, BW 3.5, BI 7.0, VC, BEX

Responsibilities:

• Worked as Sr. BI CRM, IP, HCM, MDM Consultant
• Involved in reviewing the current state of problem definition & identify data synchronization requirements in BW and BI. Understanding of each category of the problems in detail with sample data & scenario’s Study all the components associated with data synchronization area & data feeds from sales representatives (tablets) and external vendors (IMS, Epsilon etc.), BI/BW and Case Management
• Test the error scenarios with Confidential data and direct entry through Tablets (mobile device) quantify the volume of scenarios happening at each business requirement /event (wherever possible).
• Involved in the web based solutions in the Business partner relationships for enable channel partners to sample drops in the market and also for sell more effectively, also updates sales to the optimize channel operations with the Vendors.
• Developed data targets for Revenue recognition and distribute the Revenue wide across the organization.
• Analyze the volumetric and determine the complexity and assign priority for solution development
• Involved in Remodeling the Data Targets and Enhanced the Extractor.
• Led the Synchronization of a prototype retail reporting front-end using portals for Sales, Billing Data Services. The team included me, an Architect, and two report developers. The engagement included: Requirements collection, refinement, and validation.
• Design and develop solution to fix the root cause of the problem (s) and conduct unit test & QA test.

Environment: BW 3.5, BI 7.0, R/3, CRM 5.0, IP, Siperian, HCM, MDM, Windows NT.

Confidential, Bothell, WA

SAP R/3 4.6c, BI 7.0, BEX Report

Responsibilities:

• Worked as Sr. SAP-BI ISU, Consultant.
• Lead a team of consultants for implementing the SAP BI solution and migration.
• Gathered requirements from functional users in Sales and Purchasing for cross functional analysis.
• Defined work packages and technical specifications for design, development, testing and roll-out.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
• DataSources in BI. Defined the initial sizing requirements based on source data volume estimates. The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, ODS, Cubes, Aggregates, queries and workbooks.
• Gathered Business Requirements and Conducted Gap Analysis to install Business Content. Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube and ODS to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.
• Enhanced master data sources 0Customer, 0Material and 0Vendor to meet custom reporting requirements.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Created Multiprovider on sales and delivery cubes to assist reporting on sales and delivery together.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Used reporting agent to create batch jobs for Report printing and Exception reporting.
• Involved in documentation and end-user training.

Environment: SAP R/3 4.7, SAP BI 7.0, ISU, Oracle, UNIX

Confidential, Commack, NY

SAP CRM 5.0, BW 3.5, BI 7.0, BEX

Responsibilities:

• Worked as Sr. SAP-BI CRM, IP Consultant.
• Collected requirements from users and Modeled data targets according to the reporting and Interface requirements. Worked with teams to discuss/review technical specifications and functional requirements and get the right approval.
• Designed and Developed BI SFA Data Model - Integrated Planning functionality to transfer data file via Web Interface into BI.
• Involved in life cycle Implementation of SAP BW 3.5, Scheduling, Monitoring, Info-cubes, Info-Source, Remote Cubes, ODS objects, BEx-Analyzer, BEx-Query, Workbooks, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load).
• Involved in integrating re-implementation of BW 3.5 reports to BI 7.0 into the portal.
• Created Aggregates, Segmentation and Multi-providers to improve load and query performance.
• Created BI reports using Web Application Designer (WAD), Report Designer, Query Designer, Analyzer Design Mode.
• After successful sign-off from Confidential on the solution validation, proceeded with Upgrade/Sizing deployment/development work in BW & BI.
• Employed user exits to achieve the enhanced functionality.
• Used BEx Analyzer and create queries using Conditions, Exceptions, Variables, Filters, Restricted key Figures, calculated Key Figures and generated report meeting the business requirement.
• Enhanced the User Interface for the Excel Reports.

Environment: BW 3.5, BI 7.0, R/3, CRM 5.0, GTS, HCM, Windows NT.

Confidential

SAP R/3 4.6c, BW 3.7, BEX Report

Responsibilities:

• Worked as Sr.-BW SEM Project Architect Consultant.
• Understand the CS Business Methodology.
• Worked on virtual cubes like 0BCS VC10 to generate the financial data with SEM specific consolidation groups.
• Created HCM application that breaks down the different salary costs (using a salary rate application). The cost allocation at this level is only available in BCS and not in R/3. Helped the client in implementing this logic.
• Created process chains (RSPC) for master data loads and transaction data that was scheduled for periodic loads using events. Analyzed HCM business contents DataSources.
• Managed the portal teams, coordinated project tasks, timelines and project responsibilities.
• Identified the manufacturing Strategy after thorough evaluation of Discrete Manufacturing, Repetitive manufacturing, Process Industry. Production planning is based on Quarterly, monthly rollover planning, by Fox formulas and consolidation considering the constraints across the business functionalities i.e. the sales demand fluctuations, Capacity constraints, Raw Material availability & contribution analysis.
• Worked with BI Domain Architect for designing a simplified BI Data model for complex Customer Business requirements as per the existing client’s Business Processes.
• MRP both long term & quarterly rollover planning. Inventory monitoring and analysis.
• Involved in Development of iViews, pages, Worksets, Excel and Roles.
• Responsible for coordinating the BPS/BCS requirement gathering from the end users and the Functional Subject Matter Experts.
• Formulated the extraction strategy of the data from the enterprise wide consolidation engine which used the SEM-BCS application and it included both SAP and non SAP applications.
• Extensively worked on generating the BCS financial reports for the balance sheet and income statement accounts for the consolidation units across the enterprise. Worked on Cubes for BCS like 0BCS C10, 0BCS VC10 and Virtual DSO.
• Synchronized Master data from BW to SEM BCS and vice versa.
• Involved in Deployment into Portal. Creation of iViews/Role. Also Web pages/Worksets.

Environment: BW 3.5, NW 04, R/3 4.70, ECC5.0, HCM, Demand to Plan and Windows NT.

Confidential, Nashville, TN

BI 7.0, ECC5

Responsibilities:

• Worked as SAP BW Lead Configurator
• Contracted as a Senior BW Consultant to provide BW and SAP Security support (On-Call) resources to their worldwide ITS landscape (4.70, Enterprise Portal, BI 7.0, NW04s/WAS). Identified and Implemented Application and database tuning to improve IDOC/Batch job Processing. These activities improved overall system response time, reduce user problems and long wait times and drastically reduce Month End/Nightly processing time.
• Completed several reviews for the SAP Enterprise Portal Training Material developed in-house.
• I Worked with BI Architect for designing a simplified BI Data model for complex Customer Business requirements as per the existing client’s Business Processes.
• Involved in (BWA) setup and index creating, transformations creation, end-routines, DTP, Data acquisition etc.
• Involved in resolving issues by executing BWA Re-Org analyze issue in RSDDBIAMON2 by working with transaction code TREXADIN.
• In additions activities included Print-List configuration, Batch scheduling, capacity planning, and tuning to insure successful migration of all required document types. Design, Implemented info providers (Cubes, ODS, Remote Cube) Utilizing Business Content in Support of FI, FM, HR, HCM, ESS, MSS, CRM and BW statistics reporting. This includes all steps in loading/Transactional Data from R3 source system (DataSource, InfoPackage, etc.).

Environment: BI 7.0, NW 04s, R/3 4.70, ECC 5.0, BWA, HCM, ESS, MSS, Excel, Windows NT, Oracle 11.

Confidential, Rockleigh, NJ

BW Version 3.5, SAP Version 4.7

Responsibilities:

• Worked as SAP BW, NW 04s, OTC, FI Architect Configurator
• Active Team member worked in writing Document of the business requirements, BW design specifications, including the GAP Specifications and was involves development.
• Created all objects and mappings from Staging to BW.
• Worked with new BW Design (7.0)/SAP NetWeaver 2004s technologies.
• Created the Generic data model for reporting, such as ODS objects, InfoCubes and InfoSets.
• Involved in creating BEx Map, Dash Board, and Demographic Excel Reports these reports gets daily business information.
• Worked with the Data Model related to Customer, Sales, Delivery and Billing Documents related Order to Cash Process.
• Designed, configured and supported activities and functions related to OTC/Order to Cash cycle and interface to FI and MM on Ver.4.6C, including user training in all areas of SD transactions
• Involved in a Data warehouse Implementation that will provide essential metrics and other data for Strategic HR Planning and tactical solutions.
• Worked as SAP BW MM, PP, PS Configurator
• As part of existing BW team focusing on Unit Testing, Integration testing, Extractor testing, enhancements and Validation (FDA) with SAP R/3.
• Formulate BW high level solution strategy and architecture using BPS, BCS, FI-CO, GL, PS, MM, PP, AM, AP Cube/ODS. (Using BW version 3.5 Business content) and Architecture to enhance extractors and methodology.
• ETL & Data warehouse Migration. Coordinated and orchestrated the hardware migration of data warehouse and ETL process using Data stage.
• Working with Logistics Information System (LIS) extensively for extracting the Customers information from R/3, Using LO Cockpit.
• Involved in using the CTS the objects form Development to QA for Testing.
• Maintained the master data, Hierarchies in BCS
• Worked extensively in creating Transactional InfoCubes for BPS Layouts.

Environment: BW 3.5, R/3 4.70, Windows NT, Oracle 9i.

Confidential, Bellevue, WA

Worked as SAP BW, FI, PS, MM

Responsibilities:

• Hands on experience in SAP Authorization concepts, Profile Generation based up on the roles.
• Knowledge of indexes, and query optimization.
• Monitored Transport Management, CCMS, and background jobs.
• Worked with the business content for PS, PCA, CCA, SL, GL and Consolidation configured the system.
• Managed and developed the project plan, Upgrade assigning tasks to team members on the BW Upgrade Project.
• After signing-off from SAP BW 2.1 to SAP BW 3.1 on the solution validation, proceeded with Upgrade/Sizing deployment/development work in BW & BI.
• Performed delta units on CO-PA extractors when the profit center realignment was done in R/3.
• Tested the Aggregates in development as well as in production environment to check the query performance using RSRT and the query time in ST03.
• Created queries as per user requirements using BW ODS object and InfoCube.
• Involved in Core Data Integration with PS, APO for Demand Planning, Supply and Inventory.
• Solved problems encountered during the processes using OSS notes.
• Generation of Data sources in R/3, flat file sources, activation of Info Sources, Transfer Master Data to Characteristics and Transaction data from R/3 systems to InfoCubes in BW.
• Creation of custom InfoCubes in SD area to pull user specific data from R/3 along with necessary InfoObjects, necessary rules to transfer the data. LIS Setup in OLTP into BW
• Generated client specific reports & modified the standard reports displaying SD/FI/MM/PP Modules data. Transfer order report by storage bin or storage type.
• Batch Data Communication: Transferred data for Vendor Master, Purchase Order with multiple items, Outline Agreements, Material Master from Legacy system to SAP R/3 System. SAP Script: Modified systems layout set for printing Purchase Orders and for Goods Receipt.
• Retrieved texts modified and printed the same in the Purchase Order documents using Function Modules.
• Wrote C program to divert related applications to their respective directories and then transfer them to respective departments for further review.
• Developing test procedures that will specify the process or steps to execute test cases, scenarios, scripts and pass/fail criteria Designing and implementing the system.
• Environment: C, VB, Oracle 7.x, Developer 2000, Windows 95.