SUMMARY

• Over 6+ 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 wif 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.
• Having 6 months of experience in SAP HANA.
• 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 (me.e. Back-end and Front-end). Good at implementing SAP BW wif 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.
• Experienced in BI-Integrated Planning. Involved in creating Real time infocubes, planning modeler.
• 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, HR, 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 wif providing users wif 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.
• Performed datamodeling and developed Analytical views for teh transactional data, Attribute views for teh master data, and teh calculation views as final model in HANA Studio.

TECHNICAL SKILLS

SAP: SAP Net weaver 2004s BI 7.3/7.0, 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 wif 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, San Jose, CA

Sr. SAP BI/BW Lead Consultant

Responsibilities:

• Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases of SAP BW.
• Gatheird and analyzed teh requirement to replicate teh ECC content in HANA usingdata provisioning.
• Extensively used ABAP Routines to modify/update data and develop reports.
• Created Technical specifications and standard modeling documents for HANA.
• Performed datamodeling and developed Analytical views for teh transactional data, Attribute views for teh master data, and teh calculation views as final model in HANA Studio.
• Identified teh extractors on teh R/3 OLTP systems and defined teh Transfer structures on teh source and target systems. Created BW components like Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.
• Involved in extracting HR data into BW cube 0PA C01 through extractors 0HR PA 0 and 0HR PA 1.
• Extensively involved in scheduling BWA on cubes and monitoring teh BWA.
• Involved in BI-Integrated Planning. Involved in creating Real time infocubes, planning modeler, planning functions, planning sequence and BW queries on Aggregation level.
• Performed LO-Cockpit extraction to pull data from R3 SD modules into BW system extracting Header and Line item data from teh 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 wif 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) teh data from various data sources FI/CO, SD, MM, and HR including teh 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 wif 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.
• Experienced wif providing users wif access to data by building reports and queries using tools including SAP BW BEx Query Designer/Analyzer.
• Experienced wif enterprise-wide data modeling, database design, and building data structures and data mapping routines in SAP BW to support teh data and reporting requirements for all areas of teh 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

Confidential

SAP BW/BI Consultant

Responsibilities:

• Involved in teh Blueprinting phase, Gathering business requirements, analyzing existing SAP system and other interfaced systems and participated in teh 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 teh data from ECC to BI and used initialization wif delta update and full update methods. Used SAP BW for DataStage to extract, transform and load (ETL) teh data from various data sources HR,PP, SD, and FI .
• Extracted teh data from HR modules and uploaded teh 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 flat file extractions.
• Designed and created complex process chains to automate teh data load and data target administration.
• Developed Analytical Reports wif multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using teh Business Objects Enterprise XI.
• Checked teh Universes for Integrity and exported to teh Repository to make resources available to teh users and groups and Created Adhoc Reports by accessing teh Universe.
• Generated complex and large reports to show information from service order to Purchase Order to Account payable using RRI to meet teh business user’s requirement.
• Build complex new queries wif variables, calculated key figures, restricted key figures, customer exit variables and authorization object variables.
• Created test cases and closely worked wif business users to test teh 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, Query Designer, Report Designer

Confidential

SAP BW/BI Consultant

Responsibilities:

• Involved in teh development of teh user requirements, testing, initial phase of production and theirby possessed a good understanding of complete life cycle implementation of SAP BW.
• Gatheird user requirements for creating reports such as Geographical Sales Lead Report (sales prospect monitoring), Daily Billed Report (revenue monitor) based on KPIs and studied teh business content to suit teh clients requirements
• Extensively involved in installing and customizing teh standard BW business content to pull information from various source systems including SAP R/3, Oracle and flat files to load teh data into InfoProviders.
• Worked in teh 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 wifout materials, materials wifout 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 teh data content. Created MultiCubes such as Demand cube, Supply Cube and Inventory Cube.
• Created teh required InfoSources (for flexible upload and direct upload) and InfoPackages to load teh appropriate data into ODS via PSA for data staging. Uploaded transaction data into ODS objects from flat files and Oracle 8i. Multiple ODSs tan fed teh data into teh 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 teh data load.
• Designed and built teh 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 wif 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 teh 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 teh access to teh data model and queries.
• Worked wif OpenHub feature for creating InfoSpokes in extracting teh master data of teh logistics, and material for exporting to a different SQL server.
• Responsible for teh 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.

Confidential

SAP BW/BI BO Consultant

Responsibilities:

• Scheduling and Monitoring of Info Packages.
• Keeping note of all teh tickets until they are closed.
• Refreshing daily and monthly wise Xcelsisus Dashboards.
• Saving teh output of teh query in Application Server every month.
• Involved in taking necessary actions to correct teh info Packages by doing Manual Update and running teh Info Packages manually depending on teh case.
• Receiving teh customer generated tickets and resolving them.
• Maintaining Work History for all teh tickets until it is closed down.
• Maintaining Reconciliation’s to verify teh data in SAP R/3 and SAP BW are same or not after teh data loads.

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

Confidential

SAP BW/BI BO 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 teh BW system.Customization of datasources in CO-PA, LIS, HR, FI/CO and LO Cockpit to match teh business requirement.
• Extracting teh 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. Teh tables used were VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, and MARA.
• Help project team in extracting data, interfacing BW wif 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 teh Sizing document by using Quick Sizer tool.
• Designed teh Data flow for extracting Sales and Shipment Data from R/3 to APO/BW.
• Extracted data from teh 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 teh business requirement.
• Schedule of Process Chains for Hourly/ Daily / Weekly Loads as and when required.
• Involved in teh preparation of Technical specifications and maintained all teh technical documents of all teh 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 me.e. Generic Extraction.
• Involved in teh 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 teh 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 teh 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, FI.