SUMMARY

• Over 8 years of experience in SAP BI/BW and completed two SAP full lifecycle implementations, gaining experience in gathering business requirements, Gap analysis, Asap methodology, blueprinting, prototyping with users, detailed design, hands - on configuration, system test planning, system test execution, UAT - User Acceptance Test planning and execution, super user training, Go-live or cutover planning, and support.
• Worked in two SAP BW/BI full life cycle implementations, as well as upgrades. Analyzed feasibility study for NW 2004s BI for Upgrade and creating Production Support environment.
• Worked on Blue Print, Data Modeling, Designing, Documentation, Development to till Go Live and Support.
• Extensive experience and expertise in SAP BI/BW Extraction (Generic /Standard), Modeling and Reporting (i.e. Back-end and Front-end). Good at implementing SAP BW with different SAP data source.
• Strong in Configuration of Data targets, Datasources, Info objects, Keyfigures and Multiproviders
• Configuration of Transfer Structure, Transfer Rules, Start routines, Transfer routines, Update routines and End Routines.
• Extensively worked on Process Chains, Data source Enhancement, OLTP data extraction, Loading (Full /Delta Up-Load), Monitoring, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports, RSRT, Query tuning, Building aggregates, Indexing.
• Extensively worked on OLTP extractions using LO Cockpit, CO-PA, FI, generic datasource customization, master data, and Customer defined tables (z-tables) extraction.
• Extensive experience in Multi-Dimensional Data Modeling, Extended Star-Schema, Data Flow Strategy.
• Proficiency in Performance Tuning using Rollups, Partition, Compression and ticket resolution.
• Wrote various ABAP queries for field’s selection, data modification and updating to targets.
• Expert in SAP BI Business Explorer and SAP BI Web Application Designer. Worked on SAP Business objects including Universe Design, Web Intelligence, Crystal Reports and Xcelsius.
• Experienced with providing users with access to data by building reports and queries using tools including SAP BW BEx Query Designer/Analyzer, Crystal Reports and Business Objects Web Intelligence.
• Expertise in front-end Business Warehouse (Bex Suite) components for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Customer Exits, Variables, Exceptions, Conditions, RRI.
• Development experience of Extractors, InfoObjects, InfoSources, ODS Objects, Basic InfoCubes, Transactional InfoCubes, InfoPackages, Volume sizing estimates and establishing Dataclasses, Roles and Authorizations, Infospokes.
• Strong on End-to-End SAP BW Configurations and Customizations from Extraction.
• Served as liaison between application development team and technical operations staff.
• Excellent communication and presentation skills. Reputed for dedicated teamwork, solid work ethics and Commitment to achieving various Goals and key objectives. Good academic performance, analytical, and problem-solving skills
• Manage tasks and engagements with little or no supervision.
• Focused on reuse, granularity, modularity, compos ability, componentization and interoperability or applications and technologies.
• Communicate effectively with client, project management and team members.
• Experience in technical and functional upgrade.
• Deep understanding and adhered to standards and compliance requirements (both common and industry-specific). Strong understanding of BI tools, procedures and principles.
• Serviced identification and categorization, provisioning and delivery, and monitoring and tracking
• Strong proficiency in both principles and execution of data modeling and solution architecting

TECHNICAL SKILLS

SAP: SAP Net weaver 2004s BI 7.1 Ehp1/7, SAP BW (3.5/3.1C/3.0B), SAP BOBJ/BO (XI 3.1/R2/6.5), SAP ECC (6/5), SAP R/3 (4.7/4.6C/4.6B/4.5B), BI Integration with SCM/APO, HR, and CRM, Reporting

Operating Systems: Windows 95/98/2k/XP/Vista/7

RDBMS: Oracle10/9/8.x, MS SQL Server 2000, MS Access

Tools: & Utilities: ABAP/4, SQL, IDOC, RFC’s, DBconnect

Web Technologies: HTML, XML, ASP, JavaScript, VBScript, Servlets

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BI/BW

Responsibilities:

• Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases of SAP BW.
• Lead as f-functional consultant to delivery and qualify SAP BI/BW definition and requirements, gap analysis, technical design build/development, testing and roll-out. Implemented SAP BW with different SAP data source.
• Extensively used SQL, PLSQL and ABAP Routines to modify/update data and develop reports.
• Identified the extractors on the R/3 OLTP systems and defined the Transfer structures on the source and target systems. Created BW components like Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.
• Design schemas in HANA modeler and developed Calculation views Attribute/Analytic using tools on HANA models for a Pilot Project.
• Created Attribute, Analytical, Calculation views on structure in SAP HANA modeler.
• Extracted Cost Center hierarchy & Cost Element hierarchy into BW using respective data sources 0COSTCENTER 0101 HIER & 0COSTELMNT 0102 HIER.
• Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting Header and Line item data from the Sales and Distribution (SD) module (Sales Order LIS 11 VAHDR/VAITM, Shipping/Delivery 2LIS 12 VCHDR/VCITM and Billing 2LIS 13 VDHDR/VDITM.
• Experience organizing process chains with transaction RSPC and analyzed process chain load for optimal performance issues and updates for necessary automation process requirement.
• Worked as CRM Techno-functional consultant to develop reports like “Activity Monitoring Report”, “Opportunity Monitoring Report”, “Territory Monitoring Report” etc.
• Used SAP BW for DataStage to extract, transform and load (ETL) the data from various data sources FI/CO, SD, MM, and HR including the legacy systems and developed reports.
• Active participant in full-cycle implementation of SAP BW and BOBJ (from project planning to go-live and post go-live support).
• Experience Bursting of dashboards data source to deliver personalized dashboard with embedded offline viewing, linking of two reports for Passing parameters and flash variables.
• Experience implementing break/fixes, report enhancements, debugging, troubleshooting and performance tuning (load failures/deadlocks) various complex issues.
• Thorough knowledge of Security permissions, authorization objects, and roles within SAP BW and BOBJ, including SAP Authentication.
• Experienced with providing users with access to data by building reports and queries using tools including SAP BW BEx Query Designer/Analyzer.
• Experienced with enterprise-wide data modeling, database design, and building data structures and data mapping routines in SAP BW to support the data and reporting requirements for all areas of the organization.

Environment: SAP Net weaver 2004s BI 7.3 Ehp1/7, FI, SD, SAP BOBJ/BO (XI 3.1/4.0/R2/6.5), ABAP/4,ECC 6.0, Oracle, Business Explorer, SAP HANA Modeler 1.0, SAP Design Studio 1.0

Sr. SAP BI/BW Consultant

Responsibilities:

• Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases of SAP BW -SAP BOBJ development project.
• Lead as f-functional consultant to delivery and qualify SAP BI/BW definition and requirements, gap analysis, technical design build/development, testing and roll-out. Implemented SAP BW with different SAP data source.
• Generated several Consolidated (BCS) financial statements to accommodate different accounting principles. Used the consolidation monitor to execute the consolidation tasks and to monitor the entire consolidation process.
• Extensively used SQL, PLSQL and ABAP Routines to modify/update data and develop reports.
• Identified the extractors on the R/3 OLTP systems and defined the Transfer structures on the source and target systems. Created BW components like Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.
• Created reports Finance “Days Overdue analysis”, “FX Monthly”, “FX Global Exposure”, “Payment History by Document Type” and “DSO Analysis by Period” reports.
• Experience in creating Multi currency, Balance Sheet analysis, Profit & loss and cash flow statements.
• Activated profit center accounting cubes (0PCA C01, 0PCA C02), accounts payable cubes (0FIAP C02, 0FIAP C03), accounts receivable cubes (0FIAR C02, 0FIAR C03) Sale cubes (0SD C01, 0SD C02, 0SD C03, 0SD C05) from Business Content.
• Design schemas HANA and developed Calculation views Attribute/Analytic using tools on HANA models for a Pilot Project.
• Generated Cost Center “Plan/Actual” report which provides an overview of the situation of primary and secondary costs and “Internal Order” report to provide an overview of the actual and planned costs incurred during reporting time frame on certain internal orders.
• Extracted Cost center statistical key figure actual for headcount into 0CCA C03 InfoCube from data source 0CO OM CCA 3.
• Experience organizing process chains with transaction RSPC and analyzed process chain load for optimal performance issues and updates for necessary automation process requirement.
• Worked as CRM Techno-functional consultant to develop reports like “Activity Monitoring Report”, “Opportunity Monitoring Report”, “Territory Monitoring Report” etc.
• Used SAP BW for DataStage to extract, transform and load (ETL) the data from various data sources FI/CO, SD, MM, and HR including the legacy systems and developed reports.
• Active participant in full-cycle implementation of SAP BW and BOBJ (from project planning to go-live and post go-live support).
• Experience Bursting of dashboards data source to deliver personalized dashboard with embedded offline viewing, linking of two reports for Passing parameters and flash variables.
• Experience implementing break/fixes, report enhancements, debugging, troubleshooting and performance tuning (load failures/deadlocks) various complex issues.
• Thorough knowledge of Security permissions, authorization objects, and roles within SAP BW and BOBJ, including SAP Authentication.
• Experience in Unit testing, system testing, integration testing and performance testing. Hands-on development experience with Business Objects WebI, Universe Designer, Live Office, Query as a Web Service (QaaWS), Lifecycle Manager, and Xcelsius.
• Experienced with providing users with access to data by building reports and queries using tools including SAP BW BEx Query Designer/Analyzer, Visual Composer, Crystal Reports, Business Objects Web Intelligence, reporting with MDX integration and/or other enterprise reporting tools.
• Experienced with enterprise-wide data modeling, database design, and building data structures and data mapping routines in SAP BW to support the data and reporting requirements for all areas of the organization.

Environment: SAP Net weaver 2004s BI 7.1 Ehp1/7, FI, SD, SAP BOBJ/BO (XI 3.1/4.0/R2/6.5), Visual Composer, ABAP/4,ECC 6.0, Oracle, Cognos, Informatica, Business Explorer, BCS, BPC, Crystal Reports.

SAP BW/BI Consultant

Responsibilities:

• Involved in the Blueprinting phase, Gathering business requirements, analyzing existing SAP system and other interfaced systems and participated in the ETL architecture of Finance and Controlling modules using BI Administration workbench.
• Involved in Full life cycle implementation of BW BPS involves transitioning from BW-BPS to BI- IP.
• Worked extensively on FI-CO, SD, HR, COPA. Loaded the data from ECC to BI and used initialization with delta update and full update methods. Used SAP BW for DataStage to extract, transform and load (ETL) the data from various data sources HR,PP, SD, and FI .
• Key person to maintain/manage and code User Exit programs for CRM Services, Activities and Opportunity Management and Logistics.
• Worked on CRM-BI IP integration to load data in to planned and Actual cubes.
• Developed data model for Actual and planned data with CRM-BI IP for report requirement of target Customer sales.
• Extensively worked for BW-CRM integration area like Services, Survey Confirmations, IBase, Activities, Opportunity management and ECC Logistics and FI.
• Worked as CRM Techno-functional role for data sources like 0CRM SRV PROCESS H, 0CRM SRV PROCESS I, 0CRM OPPT H, 0CRM OPPT I and with ECC data sources like 0FI AP 4, 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 13 VDITM and its corresponding DSOs and Cubes.
• Created second level DSOs on top of 0CRM OPPH, 0CRM CNFI, 0CRM PROH, 0CRM PROI and created End Routines to do look ups on different master data objects to make the data in linear line.
• Written Implementations for BADIs like CRM BWA MFLOW to fill data in to enhanced fields to improve performance of data loads.
• Enhanced 0DOC NUM master data InfoObject with CRM Service Order information to make synchronize the relation between Service Order to Purchase Order.
• Extracted the data from HR modules and uploaded the data into HR Info Cubes for 0PY C02 Payroll data, 0PABN C01 Benefits, Staffing Assignments 0HR PA OS 1, 0HR PA CM 1 and 0PT C01 Time and Labor Data and worked on transformations.
• Created Generic Extraction from user defined tables and created transformations using ABAP routines.
• Extracted non-SAP systems data like Oracle, BODS, Teradata using UD connect and did flat file extractions.
• Designed and created complex process chains to automate the data load and data target administration.
• Developed Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.
• Created WEBI reports with Variables, Prompts and Complex Calculations to get Alerts for Xcelsius Dashboards.
• Implemented analytics across the organization and used tabs on company performance via flexible management dashboards and scorecards and implemented index awareness.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Generated complex and large reports to show information from service order to Purchase Order to Account payable using RRI to meet the business user’s requirement.
• Build complex new queries with variables, calculated key figures, restricted key figures, customer exit variables and authorization object variables.
• Created test cases and closely worked with business users to test the queries and documented data model for backend objects and front end queries for production support.

Environment: SAP ECC 6.0, SAP BI 7.0, SD, MM, PP,FI, PCA, SCM, ABAP/4, IP, Business Explorer, Xcelsius, Crystal Reports with MDX, BOBJ/BO (XI 3.1/3.2), WEBI, Query Designer, Report Designer

SAP BW/BI Consultant

Responsibilities:

• Involved in the development of the user requirements, testing, initial phase of production and thereby possessed a good understanding of complete life cycle implementation of SAP BW.
• Gathered user requirements for creating reports such as Geographical Sales Lead Report (sales prospect monitoring), Daily Billed Report (revenue monitor) based on KPIs and studied the business content to suit the clients requirements
• Extensively involved in installing and customizing the standard BW business content to pull information from various source systems including SAP R/3, Oracle and flat files to load the data into InfoProviders.
• Worked in the areas of purchasing and extracted data from DataSources like 2LIS 02 ITM, 2LIS 02 SCL and 0FI AP 3. Also extracted and populated data into LO InfoCubes from DataSources 2LIS 11 VAITM, 2LIS 11 VASTH and 2LIS 12 VCITM.
• Worked on custom reports like vendors without materials, materials without vendors, spend data by material group, consolidated spend history, and purchase price variance.
• Created custom report called forecast variance report, which compared actual data from 2LIS 02 ITM and planned data from 2LIS 03 S194.
• Customized InfoObjects to match report requirements by creating variables in BEx and creating InfoCubes based on the data content. Created MultiCubes such as Demand cube, Supply Cube and Inventory Cube.
• Created the required InfoSources (for flexible upload and direct upload) and InfoPackages to load the appropriate data into ODS via PSA for data staging. Uploaded transaction data into ODS objects from flat files and Oracle 8i. Multiple ODSs then fed the data into the InfoCubes and InfoObjects.
• Created and maintained transfer rules, transfer routines, update rules, and update routines to maintain data consistency.
• Extracted data, initialized delta for uploading of transaction data from R/3 systems by V3 updates. Monitored the data load.
• Designed and built the generic data source on VEKP, LIKP tables of R/3 by creating view on both tables on delivery numbers and document types. Wrote user exits and customized delta built up for these DataSources using V3 update.
• Created Conditions, Exceptions, Structures, and Variables to use them in BEx Reporting.
• Worked with Info Package groups and Process chains for effective scheduling and automation of various data loading processes.
• Resolved Query Performance issues using transactions like RSRT, RSRTRACE, ST03N, RSDDSTAT, and BW Statistics. Involved in fine-tuning the performance by creating aggregates based on BW statistics, creating InfoCube partitions, data indices, optimal packet size, and data compression.
• Developed authorization objects and profiles to restrict the access to the data model and queries.
• Worked with OpenHub feature for creating InfoSpokes in extracting the master data of the logistics, and material for exporting to a different SQL server.
• Responsible for the creation of Naming Convention document and other Documents for InfoCubes, ODS Objects, InfoSources, InfoObjects.

Environment: Sap Net weaver 2004S, ECC5.0, SAP BW 7.0,SD, FI,MM, Oracle 8i, Windows NT, Business Explorer, WAD.

SAP BW/BI Consultant

Responsibilities:

• Involved in complete life cycle update (from preparation, business blue printing, realization and go-live) of SAP BW & APO in SD, MM and FI modules.
• Performed LO-Cockpit extraction to pull data from Sales and Distribution SD module into the BW system.Customization of datasources in CO-PA, LIS, HR, FI/CO and LO Cockpit to match the business requirement.
• Extracting the data from MM (Material Management 2LIS 03 BF data sources), and PP (Production Planning and controlling) modules.
• Wrote reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping details and partner function details. The tables used were VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, and MARA.
• Help project team in extracting data, interfacing BW with APO. Loaded Demand Planning and ATP relevant data from I2/APO into BW.
• Created ABAP routines in Update rules, Info Objects. Used custom exits in creation of Variables. Used debugging process for verification of extraction process.
• Worked on BI 7 for GATP relevant reporting on APO and Prepared the Sizing document by using Quick Sizer tool.
• Designed the Data flow for extracting Sales and Shipment Data from R/3 to APO/BW.
• Extracted data from the Planning Area (DP). Involved in Creating Planning Area's, Planning Book and generating CVC.
• Designed and developed several BEx Queries for LAG reports (ACTUALS VS FORECAST).
• Performed CTM Job for transportation. Filled Setup Tables.
• Built an interface by using tscopy for master data load in SNP from legacy database.
• Installed Business content for Sales & Operations Planning of SCM PP in BW side.

Environment: SAP R/3, BI7, BW 3.5, APO 5, SRM 4.0, ABAP/4,, Business Explorer, WAD, SD, MM, FI, CO-PA

Confidential

SAP BI/BW Consultant

Responsibilities:

• Involved in complete life cycle implementation (from preparation, business blue printing, realization and go-live) of SAP BW in SD, MM and FI modules.
• Created Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Cubes to load Master and Transactional data from SAP R/3 system and flat files into BW system.
• Created and mapped source and target structures, loaded transactional data and master data, set up delta load using SAP Standard extractor program. Created transfer rules and update rules.
• Installed and extended standard Business Content based on client requirements for enhancing Data sources for transaction data, master data and texts.
• Created, Maintained and modified existing queries on different Info Cubes related to SD, MM and FI/CO modules. Extensively worked on Query building, filtering data, Structures, Variables and conditions.
• Created a custom Start Routine, Update Rules and Transfer Routines to meet the business requirement.
• Schedule of Process Chains for Hourly/ Daily / Weekly Loads as and when required.
• Involved in the preparation of Technical specifications and maintained all the technical documents of all the objects and their user manuals.
• Designed custom ODS for sales order line items relevant to demand planning.
• Involved in extracting data from custom data sources i.e. Generic Extraction.
• Involved in the Integration testing in quality of Objects.
• Designed custom info provider for Delivery analysis and to load large volume of data from SAP R/3 4.6C Source systems.
• Extensively involved in Design and creating Processes Chains to automate the process of loading data into data targets
• Designed ODS object for MRP and loaded data. Developed an interface between legacy system Windmills and BW to extract data and developed reports Sales by customer and Sales by materials.
• Worked on Info Cube to develop income statement report.
• Involved in transporting objects in system landscape and in production support.
• Designed loading strategies for master data, initial load of transactional data and delta loading of both master data and transactional data.
• Developed ABAP routines at Info package level for data manipulation and restriction.
• Defined strategy to set up the historical data to load into BW and improved performance by running parallel setups.
• Developed Transfer rules, update rules and Start routines to in corporate Business logic for data manipulation.

Environment: SAP BW3.5/3.0bSAP R/3 4.6B/4.6C/4.7, BEx, SD, MM, PP, FI.