SUMMARY

• 10 plus years of experience in SAP BW/BI including 4 years of SEM BPS, 4 years in BPC.
• Worked in various roles as Technical lead, Architect, Developer, Tester and Trainer.
• Worked in complete life-cycle environment in all phases like Analysis, Blue-printing, Data Architect, design specification, development, performance tuning, testing, documentation, maintenance, training, Security authorizations and trouble-shooting.
• Business Areas - SD, MM, PP, FI, CO, PS, CRM, SRM, HR, APO, SEM and BPC.
• Modeling - Extensive experience in BW Architecture, Extended Star-Schema, Multi Dimensional Modeling, Data Flow Strategy, Defining Dimensions, InfoCube, Multiprovider, Infoset, DataSource, InfoSource, InfoObject, PSA and ODS.
• Extractions - Extracted data from LO Logistics Cockpit for SD, MM, PP, APO and CRM. COPA Extraction, Business Content Extraction for FI, CO, PS and HR and Generic DataSources from Views and Function Modules, DB connect and Flat Files.
• Customizations - Experience in activating standard Business Content, extending and enhancing InfoCubes according to the requirements, Datasource Enhancements, User Exit Variables, Virtual Keyfigures, Start Routines and Formula Builder.
• Integrated Planning: Experience in configuring IP for Business Planning and creating aggregation levels, input ready queries, planning workbooks, etc.
• BPS: Experienced in developing BPS technical objects such as transaction cubes, planning functions, planning variables and user exits. Experience in developing custom planning layouts, planning package and function modules using ABAP.
• BEx Reporting - Expertise in front-end Business Warehouse components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries and Web application designer, Web Items.
• BO XI R3 Expertise in all client tools Desktop Intelligence, Web Intelligence and Infoview of Business objects suite and created interactive reports using Xcelsius. Experience in designing and developing the “Universe” (business view of the database) using Designer and Universe Builder, designing ad-hoc reports, scheduling the processes and administering the BO activities. Worked with CMC to give access and rights, created folders, categories users and groups, connections.
• BW Security – Worked extensively in BW security. Defined Roles and Authorizations based on InfoAreas, Infocubes, Multiproviders, and Infoobjects as well.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to Basis support for optimization. Improved data load and query performance by doing Compression, creating Aggregates, Indexes, Data packet size.
• R/3 ABAP – User Exits, Customer modifications.
• 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.
• Extensively involved in End User training as well as Developer Training. Created Technical Documentation, Training Manuals etc.
• Non-SAP-2 years of experience as a programmer in Java, Visual basic, C, C++, Oracle 8i/7.x, MS SQL Server, PL/SQL, Business Objects 5.x,6.5.XI 3.0.
• Experience in working with warehouses SAP Business Warehouse 3.5 and 7.0 and Microsoft OLAP Analytical services.
• Worked in SAP BPC MS 5.1 & 7.0,SAP BPC NW 7.0& 7.5 and have acquired boot camp knowledge on BPC 10 MS & NW from SAP Conference with CPA credits.
• Extensively worked on the Input Schedules, Reports build on EVDRE and with the templates and have worked in creating custom dimensions for preparing the members data for dimensions.
• Worked extensively on the integration of data inbound and outbound from SAP BI to BPC on both NW and MS versions.
• Worked on the script logic and have created the custom Data manger package.
• Worked in the SAP BPC 5.1 for Change Management.
• Knowledge of SAP BO PCM 7.5
• Excellent communication, interpersonal, analytical skills and strong ability to perform as a lead and as part of a team.

PROFESSIONAL EXPERIENCE

Confidential,Houston, TX
Sep 2012 – Present

SAP BI/BPC Integration Lead
Environment: SAP ECC 6.0, BI 7.3, BPC 10 NW

• Created Interfaces for Data Transformation and Conversions in BPC for both Master Data and Transaction Data.
• Created Staging Cubes for both Finance and Project Systems in BI for BPC Data.
• Enhanced couple of fields to the project master data.
• Automated the both Master and Transaction Data loads from BI to BPC by creating custom process chains for loading into BPC.
• Created a Delta DM package for Finance Transaction data into BPC
• Created multiple DM packages for user and Admin and have enhanced the script logic tasks and prompts to the DM.
• Maintained the Global Parameters for performance of BPC.
• Created Security in BPC.
• Tuned script logic for long running DM packages.
• Created some adhoc BPC reports for reconcilation in BPC Excel using the new EPM functions.

Confidential,Oak Creek, WI
Jun 2012 – Aug 2012

SAP Sr BI Consultant
Environment: SAP ECC 6.0, BI 7.0, BOBJ 4.0, BPC 7.5 NW

• Created Data Flow Conversions from Legacy systems to BI using the Flat File interface and DB connect.
• Created the Email bursting for Query results to Cost center owners using the Broadcasting.
• Enhanced couple of fields to populate the Open PO performance report for getting the Lead times from Material Master and Info record.
• Created APD’s and open hub to get the data from BPC to BI.
• Designed a universe using Information Design Tool (IDT) with BICS connection to SAP Info cube.
• Enhanced Logistics Data Source 2LIS_11_VAITM for KF with different pricing conditions.
• Have created reports for Top 50 suppliers and other Logistics reports.
• Created WEBI reports using WEBI rich Client with Bex queries where BICS connection creates in IDT with BICS.
• Created Interactive what if dashboards using Dashboard Designer.
• Created Special WEBI reports to feed Dashboard through BI Services.
• Created few complex Crystal reports using Crystal Reports 2011 connecting Bex and MDX queries.
• Created the Webi Reports and gave access to the users.
• Created Adhoc reports on BOBJ Analysis tool for slice and dice.

Confidential,Deerfield, IL
Jul 2011 – May 2012

SAP BI Consultant
Environment: SAP ECC 6.0, BI 7.0,BOBJ 4.0, BPC 7.0 MS

• Developed Data Conversions from Legacy systems to BI using the Flat File interface.
• Worked in the Consolidation process built in BI for Currency Translation and Intercompany Eliminations.
• Worked in the custom programs to automate the process chain for data loads from flat file.
• Extensively worked in creating process chains and used new process types such as Decision to start the process chain with multiple alternatives.
• Extensively worked in the Open Hub to extract the data and push it to FTP.
• Worked Extensively in design and creating the Bex Queries.
• Worked in the reconciliation of data using excel for validating data from Source systems and EDW and BPC MS.
• Worked in the development of custom codes using ABAP in Trnaformations for BI Consolidation for customProcess like Balance Carry forward, Intercompany Profit Eliminations, Currency Translations through end to end Project development, go live and support.
• Worked in the BI Management Reporting using Webi.
• Worked in the BOBJ Microsoft Office Analytics tool for excel based Adhocreports.
• Desined a universe using Information Design Tool (IDT) with BICS connection to SAP Infocube.
• Created WEBI reports using WEBI rich Client with Bex queries where BICS connection create in IDT with BICS.
• Worked in the FI general ledger data source 0FI_GL_4 to change the safety limit for delta .
• Worked in creating the Manual Adjustment Inputs to load in the Consolidations cube.
• Worked with custom ztables maintenance used for lookup to populate the mappings of BPC dimension properties to BI Master data objects with some exception rules.
• Worked in COPA cost based extractions.
• Created DSO’s, Infocubes ,Infoobjects , Multiproviders.
• Installed Business Content for Technical Content.
• Created APD for Brand Innovation using Query as source and direct update DSO as target.
• Woked in the performance improvement of BI data loads and for query performance.
• Worked in creating the BIA indexes.
• Have involved in lot of issues related to BIA indexes, missing SID’s, increasing number range buffer, adjusting dimension tables.
• Have been coordinating tasks related to be executed while the development and support with offshore teams in BI.
• Have been involved in extracting data from BI to pushing it to BPC MS using the open hub.
• Have involved in creating DB connect for MS DB tables for centrally maintaining the master data with the BPC hierarchies in BI and for allowing the reconciliation of planned data from BPC to BI for developing Variance reports.
• Used Administrative Workbench to create Info cube with parameters, info objects, multiple characteristics and key figures with appropriate transfer and update rules.
• Data Extraction from BW to APO system and from Planning Area to Info cubes.
• Used Custom Extractor by FM for extracting the Pricing Conditions to BI.
• The Logistics Extractors in SD enhanced with new ZZ fields and tried to reduce the downtime while moving across landscape by implementing the changes to delta.

Confidential,Kent, WA
Jun 2010 – Jun 2011

SAP BI/IP- Consultant
Environment: SAP ECC 6.0, BI 7.01

• Prepared strategy, scoped, collected business requirements, analyzed the process to be modeled for MAP Financial Planning.
• Created the Real time infoproviders for allowing planners to enter data into the cubes through the interface using WAD.
• Used copy, distribute and delete planning functions and for some calculations used the Fox code.
• Used inverse formulas in creating the BEx input ready Queries using the Query Designer.
• Created the actual cube to store the data from the sales, inventory and merchandise.
• The aggregation levels where created on the multiprovidersfor BEx input ready queries.
• Reports were created to get the required KPIs such as Cost Adj $, Gross Margin, Receipts $,Turn etc
• Performance Analysis and tuning has been performed.
• Assisted testing team for doing Performance, Functional and Integration testing.
• Created Variance reports, year over year comparison reports and KPI Reports.
• Created the 5 yr planning layouts, 1 Yr Planning Layouts with seasons with In season and Pre Season and also with Reconciliation Planning Layouts for both 5 Yr and 1 Yr for the areas Like Merchandise, Location and Strategic Planning.
• Assisted to create the security in BI for Finance users.
• Created the version management process for using the Strategic, Merchandise and Location Planning.
• Managed and worked closely with a team of 7 in onsite and offshore.

Confidential,Boston, MA
Oct 2009 – Apr 2010

SAP BI Consultant
Environment: SAP ECC 6.0, SRM 5.0, BI 7.0, BPC 7.0 NW, BO 3.1

• Prepared strategy, scoped, collected business requirements, analyzed the process to be modeled
• Created Business Requirements Document (BRD) and Business Design Document (BDD) for Consolidation.
• Created the BI BRD and BDD for Finance and SRM Spend Analytics.
• Prepared the Interface Document for Oracle Hyperion MDM into BI using UD Connect.
• Activated the Business Content for Procurement, RFx, Contract Management, PO and Invoices from SRM to BI.
• Created Custom measures in BPC NW to hold data in different views for reporting in QTD AVG,YTD AVG and PERIOD AVG.
• Created Master Data Load automation using BI process chains into BPC.
• Created separate application for Cash flow reporting purposes in BPC.
• Identified custom fields for consolidation and created a Functional Spec to Enhance the New General Ledger table in ECC.
• Created the new FIGL Transaction data load into BPC using the datasource 0FI_GL_12 from ECC.
• Loaded Historical data, Statistical data into BPC using Flat File upload into BPC.
• Created Validation reports for Historical Data in BPC EXCEL using EVDRE functions.
• Created BS, IS, AUM and Flows reports and some other internal managerial reports across products, portfolio and class using BPC Excel for Consolidation.
• Created the Custom menu for running the Consolidation tasks.
• Used custom badis for some calculations and for custom measures.
• Installed the BC in BI for FI AA, AP, AR used the data sources like 0FI_AA_20, 0FI_AP_20, 0FI_AP_30, 0FI_AR_20 and 0FI_AR_30.
• Used Bex Analyzer to create the Adhoc Queries. Worked with Query designer as well as WAD for creating the web templates.
• Used portal for Web reports.

Confidential,Benton Harbor, MI
Jul 2009 – Sep 2009

SAP BI/BPS Consultant
Environment: SAP ECC 6.0, BW 3.5, SEM BPS 4.0.

• Rolled out a complete life cycle Budget Input Tool, Admin Tool Project for Global Cost Center Reporting.
• Completely responsible for the initial phase of the Project Delivery.
• Prepared and collected business requirements, analyzed the process to be modeled
• Created Business Requirements Document (BRD) and Business Design Document (BDD) for Cost Center Accounting for budget input and Statistical internal orders.
• Designed the retraction for cost center for primary costs using planning function for retraction of BPS planned data to the Systems of ECC from BW to push the planned data for Analysis and Planning and using the reports in KSBP in ECC.
• Extracted the data from ECC to BW using CCA.
• Created Planning areas for Drivers, Headcount and salaries, Travel and SIO using the driver methodology and Budget Input planning Multi Area.
• Created Web Interfaces for Both Budget Input and Admin tool
• Created Calculations using fox code for Variance calculation, Salaries and for copy versions.
• Prepared KT and training documents for Business Users.

Confidential,Long Beach, CA
Sept 2008 – Jun 2009

SAP BI/BPC Consultant
Environment: SAP ECC 6.0, BW 7.0, BPC 5.1 MS.

• Rolled out a complete life cycle Financial Planning and Consolidation Project for EPSON 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.
• Implemented the FI, P2P and OTC modules in BI.
• Created 2 applications in BPC for Legal Consolidation and Managerial Consolidation.
• Created a Finance Planning application.
• Created the Annual, monthly and quarterly forecasts for Balance sheet and Revenue planning using the Financial planning application.
• Created Allocation rules (for Expense Allocations) using tables in SQL Server clcAllocH and clcAlloc and executed via custom SSIS data manager packages.
• Created conversion and transformation files to upload historical data and transactional data from ECC, BI and legacy applications.
• Used Input Schedules to forecast and Budget Income Statement and balance Sheet.
• Created Worksheet and Script Logics in BPC for calculations in Income Statement and Balance Sheet.
• Created Cash flow reports.
• Also used BPC for consolidating data from companies of US, Canada and LATIN.
• Created Business Process Flows (BPFs) in BPC to monitor progress of users, send email notifications, and assure consistency and uniformity.
• Created Custom Menus with macros to execute the Month-End close activities in a sequence.
• Extensively worked on security set up creating various task profiles and member access profiles to allow several users to perform various tasks and access certain data sets.
• Activated work status to lock the actual and plan data after the close.
• Created a transport mechanism on the SQL server 2005 with a shared drive holding the changed/new object files to be transported controlled with Date/Time stamps.
• Created process chains using the BPC process types in BPC 7.0.
• Involved in the upgrade activities for BPC 7.0.
• Provided hands-on training and delegated work to the client’s BI Team.
• Responsible for the development of various Test cases/scenarios and reconciliation at various stages of testing such as Unit Test, Functional Unit Test and detailed Integration Testing.
• Created several reconciliation reports for data validations and exceptions. Managed the Training, Dress Rehearsal and Cut-Over activities for Go-Live.

Confidential,Cleveland , OH
Jan 2008 – Sept 2008

SAP BW/BPS Consultant
Environment: SAP ECC 6.0, BW 3.5, SEM BPS 4.0.

• Responsible for BI reporting, data modeling and integrate with actuals from FIGL Plan data from BPS.
• Extensively involved in the requirement gatherings, conducted workshops with business users in gathering AS-IS process and defining To-Be process.
• Created functional and technical specification for Data Architecture of BI for splitting the cubes for Budgets, Projections and Strategic Planning.
• Defined the Business Planning process steps and configured BPS to accommodate the planning cycles.
• Created Planning Areas, Planning Levels, Planning Packages, Planning Functions, Parameter Groups, Manual Layouts and Global Planning Sequences for BPS according to the business requirements.
• Created Function Modules for Derive, Combination check and Proposals for the Characteristics Relationship.
• Created comparison and Validation Reports for Actual Vs Projections and Budgets of Plan data.
• Involved in the upgrade activities of the MS SQL 64 bit with the testing.
• Created the Aggregates for the Transactional cubes based on the Planning Levels, Planning Functions, Planning Sequences.
• Created infospokes for extracting the data from BW.
• Created Partitions for the reporting cubes.
• Involved in the activities of BW and BPS Production Support.
• Involved with the Users to check the long running queries and tuning on the queries.
• Created the Structural authorizations for Organizational management.
• Assigned the RSSM authorizations objects for infoproviders.
• Created the authorization variables.
• Installed the Business content for BW HR for OM, BN.
• Created reports on Organizational Management using the staffing Assignments cube 0PAOS_C01.
• Created reports on the Benefits cube 0PABN_C01.
• Created Projects Overview report and WBS element Cost and Variance query.
• Installed the Business Content for Project systems Data sources.

Confidential,Concord, CA
Mar 2007 – Dec 2007

SAP BI Architect
Environment: SAP ECC 6.0, BI 7.0, IP, BPS, BPC and FICO, SD, APO.

• Responsible for BI reporting, datamodeling and extraction of Plan data from APO-DP and SNP, integrate with actuals from SD, COPA and Plan data from BPS and IP.
• Created Functional and technical specification for Data Architecture of BI.
• Created several Infoproviders, for extracting data from DP and SNP. Created remote cubes for online reporting. Also created Backup Infocubes and Snapshot Infocubes for capturing the historical versions of Plan data.
• Interfaced with APO- Demand Planning for Demand Supply forecasted in APO.
• Extracted data from COPA, COPC and Special Ledger (SL) data from R/3 for actuals.
• Extensively involved in BPS and IP projects in creating the real-time infoproviders and input-ready queries for planning.
• Maintained extensive technical documentation throughout the project.
• Provided hands-on training to the end-users in working with the queries.
• Worked closely with the Basis, BW and R/3 teams to ensure that each of the environments were completed on time and the functionality delivery was concise.
• Developed various Test cases/scenarios for Unit Test, Functional Unit Test and detailed Integration Testing.
• Created Info Objects, Transformations, DataTransfer Process and Data targets to load Master and Transactional data from APO and R/3 system into BW system.
• Created several reports Master data change report, Forecast Comparison report, Actual Vs Forecast Report, Weekly Forecast Report, Disaggregated Forecast Reports, etc.
• Created Managerial reports like S&OP Deck, 18-Month price and discount, New and Discontinued Material Exception report.
• Extensively worked in performance tuning the queries by maintaining aggregates, indexes, statistics and compression on infocubes. Created Process Chains to automate the data load and data target administration and monitored the processes.
• Used Cache Monitor to trace the amount of memory used by the query runtime.
• Used transactions like DB02 and ST03for database management.
• Conducted training for End-users. Developed BW training documentations for different users based on their roles.

Confidential,Marshall, MN
Apr 2006 – May 2007

SAP BW Consultant
Environment: SAP BI 7.0, SAP BW 3.5, SEM 4.0, APO 3.1,CRM 4.0, SAP R/3 ECC 5.0, and Windows NT

• Successfully rolled out a Business Warehouse Project implementation in the modules of PM, QM, and PP and Transportation.
• Interaction with the management and other involved parties to identify business requirements.
• Extracted data from QM, PM, PP module using LO cockpit and General Extraction methods and also used Flat files for loading the data from other sources.
• Extensively worked in the Supply Chain for reporting KPI’s in Metrics SGSC Dashboard.
• Used the new features of BI in backend to load data (DSO, transformations, DTP, etc) as well as front End (report designer, Exception aggregation, Filters, workbooks).
• Extensively worked on BEx in creating reports using all features of reporting like Report designer, workbooks, structures, variables, Calculated Keyfigures, restricted keyfigures, exception aggregation, etc.
• Created reports like Downtime percentage, Quality Complaints and Overall Equipment Effectiveness.
• WAD was used to report the queries in the Dashboard.
• Also worked in uploading transportation data from flatfiles and created reports for analyzing various parameters like total freight, total drop, total weight, total miles by shipping method, load, etc.
• Enhanced the master data and Transaction datasources.
• Applied OSS notes to resolve some of the issues.
• Created the process chains to automate the data loads.
• Involved in full life cycle of the project from gathering the requirements, Development, Testing, Documentation and GoLive.
• Created Web enabled Dashboard. Dashboard presents employee data on Hires, Headcounts, Promotions, Separations, Appraisals-PPP ratings, Vacancies, Campus Hires, OT reporting, HR demographic and Org hierarchy information and Budget to Actual Reporting from CO data.
• Worked in the areas of Cost Center Accounting, Personnel Cost Planning, HR Payroll and Personnel Time Management and extracted data from DataSources like 0CO_OM_CCA_9, 0HR_PACP_1, 0HR_PT_1, 0HR_PT_2 and 0HR_PY_1.
• Installed business content cubes and ODSs like 0CCA_O09 (for “actuals”), 0PACP_C01, and 0PY_MC02. Also worked on custom reports like cost center accounting actual line items overview, comparison of personnel cost plans on these InfoProviders.
• Rolled out a full P&L and Income Statement Planning project in SAP configuring BW, BPS and APO.
• Project Blueprinting and Scoping for CRM Marketing and Campaign Planning using BPS
• Completely responsible for the Design and Configuration of the BW and BPS for the flow of actual and Budget/Forecast data to/from APO, R/3 and SEM/BW.
• Created the data model in BW to accommodate the Budget/Forecast data from APO, Plan Data from SEM and Actuals data from R/3.
• Integrated all the data in BW using Multi Providers and Infocubes to create reports like Factory P&L, Income Statement and Sales and Production reports.

Confidential,Los Angeles, CA
Oct ‘05 – Apr ‘06

SAP BW Consultant
Environment: SAP BW 3.5, SEM 4.0, SAP R/3 4.7, MM, PP, SD, APO, BEx, and Windows NT

• Successfully rolled out a Business Warehouse Project implementation in the modules of PP, SD, and MM.
• Interaction with the management and other involved parties to identify business requirements.
• Involved in all phases of the project cycle from Configuration, Development, Documentation, Integration Testing and Go Live. Represented BW team in various status meetings.
• Extracted Data from MM, PP and SD module using LO cockpit, and General Extraction methods. Also used DB connect and Flat files for loading legacy data, and data from other sources.
• Extensively used BW standard business content extractors to extract data from SAP R/3 and APO.
• Responsible for implementing SD Sales Overview Info cube for summarized sales, deliveries and Billing Information. Also required to create Multiprovider on Sales, Deliveries and Billing Info cubes.
• Created reports like Inventory status report, Inventory aging report and Actual Vs Production Plan report on APO and Inventory Management data.
• Created Backup info cubes for multiple versions of plan data in APO.
• Created Generic Datasources for extracting Data through Function Module.
• Created several reports like Spend Analysis, Open purchase orders, Purchase price variance, COGS, Affinity, Product availability.
• Implemented Data warehouse in BW for reporting purposes on HR and CCA data.
• Implemented Cubes include Payroll, Headcount, Personal actions, Staffing Assignments, Appraisals, and Recruitment.
• Created Web enabled Dashboard. Dashboard presents employee data on Hires, Headcounts, Promotions, Separations, Appraisals-PPP ratings, Vacancies, Campus Hires, OT reporting, HR demographic and Org hierarchy information and Budget to Actual Reporting from CO data.
• Worked in the areas of Cost Center Accounting, Personnel Cost Planning, HR Payroll and Personnel Time Management and extracted data from DataSources like 0CO_OM_CCA_9, 0HR_PACP_1, 0HR_PT_1, 0HR_PT_2 and 0HR_PY_1.
• Built business content cubes and ODSs like 0CCA_O09 (for “actuals”), 0PACP_C01, and 0PY_MC02. Also worked on custom reports like cost center accounting actual line items overview, comparison of personnel cost plans on these InfoProviders.
• Modified the Business Content and created Generic Data Extractors in HR and Logistics Applications.
• Defined and modeled queries to satisfy business analysis. Excel was used to format and slice and dice the data.
• Extensively worked in performance tuning the queries by maintaining aggregates, indexes, statistics and compression on infocubes. Created Process Chains to automate the data load and data target administration and monitored the processes.
• Extensively worked in Web reporting using WAD. Edited HTML, inserted Javascript. Created CSS style Sheets and new features of BW 3.5 like broadcaster, Chart Designer, RRI in web.
• Involved in creating Roles to define authorizations for BW users.
• Applied OSS notes to resolve some BW issues.
• Handled postproduction support and development of new design cycles simultaneously.

Confidential,Parsippany , NJ
Nov 2004 – Sep 2005
SAP BW Team Lead
Environment: SAP BW 3.1, SAP BW 3.5, SEM 4.0,SAP R/3 4.7, APO, BEx, and Windows NT

• Successfully rolled out a Business Warehouse Project implementation in the modules of FI, CCA, PCA, PS-Project Systems and MM-Purchasing.
• Interaction with the management and other involved parties to identify business requirements and define a Project Charter.
• Involved in all phases of the project cycle from Blueprinting, Design Architecture, Configuration, Development, Documentation, Integration Testing and Go Live. Represented BW team in various status meetings.
• Tasks include studying the Business Process and understanding the whole Landscape and Architecture for BW configuration. Worked extensively on data modeling and reporting.
• Generated Data Sources in APO. Created real-time reports out of remote cubes in APO-DP.
• Extensively worked in APO infocubes for Inventory Planning reports. APO related activities include generating datasources, creating the backup cube, data marts and reports on Inventory and Stocks.
• Extracted data for Actuals from Inventory Management and Purchasing modules and integrated with Forecast/Budget data from APO in BW.
• Worked on custom reports like vendors without materials, materials without vendors, spend data by material group, consolidated spend history, and purchase price variance.
• Extracted Data from FI-GL, CO-CCA and EC-PCA and Purchasing modules using Business Content, LO cockpit and General Extraction methods.
• Extensively worked on enhancing the business Content DataSources in CMOD for 0FI_GL_4.
• Created Generic Datasources for extracting PS Master Data Objects and Texts.
• Created several reports like COGS Less Leukine, Purchase Price Variance, Cost Center Detail, Material Activity, Personnel Expense by EC member, G&A Variance, S&D Variance, Open PO Report, Project Cost Analysis, Sales by Product Actuals.
• Created User Exit variables for calculations on Fiscal Period, Fiscal year, etc.
• Worked extensively in BEx analyzer and browser, developed web reports and created queries, workbooks using variables for characteristics, text and hierarchies, restricted key figures, calculated keyfigures using formula variables and navigation Attributes.
• Used new analysis and repair environment. Performed consistency checks on the data and metadata stored in a BW system. Tested the foreign key relationships between the individual tables of the enhanced star schema of the BW system.
• Involved in BW 3.5 Upgrade activities that include checking relevant OSS, Consistency Checks, Upgrade Phases, post-upgrade checks, Conversions and adjustments, rescheduling jobs, support packs, etc.
• Closely worked with the Basis team in upgrade phases and helped in resolving BW inconsistencies.
• Extensively worked on efficient and improved performance of the reports. Analysis and troubleshooting of the reports using RSRT query monitor and have done gap analysis.
• Extensively worked in defining roles and authorizations for BW Users, BW developers, Administrators and Super Users.
• Created roles based on Infoobject values. Created Authorization objects for infoobjects.

Confidential,CA
Jan 2002 – Oct 2004
SAP BW Devloper
Environment BW 3.0A, BW 3.1, R/3 4.6C, R/3 4.7

• Involved in complete implementation of SAP BW for the CS, FI/CO, EC-CS and SEM BCS modules.
• Created Infocube for Business Consolidation, extracted data from EC-CS data for Legal Entity and Profit center consolidation. Involved in migration of EC-CS to SEM BCS. Created infocubes for BCS and transferred data from EC-CS for History.
• Created Consolidated Balance Sheet, Profit & Loss Reports for EC-CS/ BCS.
• Rolled out a SAP BW project for reporting needs on SAP FI, CO and SD data.
• Interaction with the management and other involved parties to identify business requirements and define a Project Charter.
• Involved in all phases of the project cycle from Blueprinting, Design Architecture, Configuration, Development, Documentation, Integration Testing and Go Live. Represented BW team in various status meetings.
• Tasks include studying the Business Process and understanding the whole Landscape and Architecture for BW configuration. Worked extensively on data modeling and reporting.
• Extracted Data from FI-GL, CO-PA and SD module using LO cockpit, COPA, and General Extraction methods. Also used DB connect and Flat files for loading legacy data, Adjustments, and data from other sources.
• Created several reports like Balance Sheet, Legal Entity P&L on FI-GL data, and Gross Margin, Operating Profit and Geographic P&L on COPA data.
• Used virtual Keyfigures for calculating no. of Days in the Days Sales Overdue reports.
• Created User Exit variables for calculations on Fiscal Period, Fiscal year, etc.
• Worked extensively in BEx analyzer and browser, developed web reports and created queries, workbooks using variables for characteristics, text and hierarchies, restricted key figures, calculated keyfigures using formula variables and navigation Attributes.
• Used Currency translations for reporting in user specific currencies.
• Created different currency translation types based on different types of exchange rates Budget exchange rate, Average Monthly rate etc.
• Used new analysis and repair environment. Performed consistency checks on the data and metadata stored in a BW system.
• Tested the foreign key relationships between the individual tables of the enhanced star schema of the BW system.
• Extensively worked on efficient and improved performance of the reports. Analysis and troubleshooting of the reports using RSRT query monitor and completed gap analysis.
• Extensively worked in defining roles and authorizations for BW Users, BW developers, Administrators and Super Users.
• Created roles based on Infoobject values. Created Authorization objects for infoobjects.

EDUCATION

Bachelors of Technology(4years) - Information Technology