Summary:

• 9+ years of SAP BW/BI 3.5/7.0/7.1/7.3 as a Techno Functional Consultant.
• SAP Certified Application Associate – SAP HANA 1.0
• Worked extensively on Administrator Workbench.
• Expertise in BW data administration by creating Report Authorizations and User Profile Maintenance.
• Good functional knowledge of FI-CO, HR, SD, MM and general business process.
• Expertise in ASAP methodology usage.
• Good knowledge in determining Schemas and Creating Calculative, Analytical and Attribute views with hierarchies, variables and measures.
• Experience using SQL script to create tables and delete unwanted data from tables.
• Performed Data load management, experienced in Scheduling Start Process and Process Chains of Events, Data source Enhancement, data loading (Full /Delta Up-Load) and Monitoring.
• Expertise in Report Generation and Dashboards - Worked extensively in BEX Analyzer in building Queries and Workbooks and created Custom Queries using Conditions, Exceptions, Variables & Structures and created aggregates for frequently used queries, RRI - Jump queries, Web Publishing, WAD.
• Good hands on experience in creating Cognos reports with BW as datasource.
• Expert level in front end development in designing queries, workbooks and dashboards.
• Worked on Business Objects by Building Universes, WEBI Reports, Crystal Reports, Xcelsius dashboards using BI services, QwAAS and BICS connectivity.
• Proficient in creating planning areas, levels, packages, functions, layouts for customization using BPS and their functions with FOX Formula in the Planning Modeler.
• Created Planning Functions (Distribution, Allocation, Copy, Delete, and repost, Exit, FOX and Revaluation), Account based model, Key Figure model, BPS Authorizations, Data slices, Variables, Currency translations, UOM conversions, Web-interface builder, Status and Tracking System.
• Involved in Translation of User requirements into specifications for complex logical data models and have demonstrated to the client on overall Data Warehouse Design.
• Worked with the various IT teams to facilitate problem resolution, conduct Training Sessions for the end users.
• Strong Knowledge and experience in software development life cycle (SDLC) including analysis, design, development, testing and maintenance.
• Motivated and focused team player with excellent interpersonal, time management and communication skills.

Technical Skills:

• ERP : SAP R/3 EECC6.0, 4.7, 4.6C/4.5B/4.0B/3.1H
• Data warehousing : SAP BI 7.3,7.1 3.5/3.1/3.0B, SEM – BW 4.0
• Functional Modules : SD, FI/CO, HR ,MM
• Programming : ABAP, C++, C, Visual Basic, SQL, FOX,PL/SQL
• Web Technologies : ASP, HTML, WAD.
• Reporting : BEx, Crystal Reports, WebI, Xcelsius, Cognos
• Operating System : UNIX, Windows NT/9x/2000/XP
• RDBMS : Oracle, MS SQL Server
• Packages : MS-OFFICE

Education/Training:

• Masters in Business Administration (MBA)
• Bachelors in Computer Sciences
• Diploma in Network Centered Computing

Professional Experience:

Sr. SAP BW/BI Developer Mar’ 2011 – Apr’ 2012
Client: Confidential, FL

Responsibilities:

• Designed and developed the WFM model and built Custom data sources, DSOs, Cubes, Queries and Web Reports.
• Worked extensively on transformations for Time and Date Conversions using ABAP.
• Developed reports for FI and HR teams on AR, AP, Payroll and Quota modules.
• Developed workbooks and broadcasted to the end users.
• Developed web reports and dashboards using WAD and published on portal.
• Developed Paid Time Off, Payroll Register, Posting Date Summary, GL Line Items, AR Monthly, and Budget vs. Plan workbooks to automate the close process for AR and GL teams.
• Created open hubs for capturing BW data and sending to EDW tables.
• Played key role in upgrade and re-hosting activities.
• Designed BEx queries for consumption by Cognos Report Studio.
• Gathering requirements from the users and converting the functional requirements in to technical specs for FI, HR, SD and MM modules.
• Worked on various info cubes like Purchasing Groups, Vendor Evaluation for the Material Management module from the Business content.
• Worked on info cubes like Quotations, Sales Order and Customer for the Sales and Distribution module from the Business content.
• Trained technical personnel on BIW, BEx Reporting, Web Reporting, and Knowledge transfer.
• Designed Technical Specs for extractors, DSOs, Open hubs, Cubes and reports for the Point of Sale project.
• Designed Technical specs for Article and Merchandise hierarchies and article assignments for extracting from ECC and loading into BW and EDW.
• Developed the DSO for Article hierarchy with Article Assignments.
• Primary support and on call 24/7 for all SAP BW production issues.

Environment: SAP BI 7.3, SAP ECC 6.0, FI/CO, HR, SD,MM,ABAP/4, BEx Analyzer, Query Designer, Web Application Designer, Cognos.

Sr. BW/BOBJ Consultant Mar’ 2010-Dec’ 2010
Client: Confidential, FL

Responsibilities:

• Delivered the Business Intelligence solutions to the end user with in a structured framework based around the SAP Business Objects BI and SAP Business warehouse BW platform.
• Created Reports using SAP BW data as data source.
• Designed Technical Specs for extractors, DSOs, Cubes and BEx queries
• 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.
• Build Universes, Crystal and WEBI reports for Cost Center Analysis Report, Work Orders and Notification Data. Creating various Sales Analysis and other KPI\'s report used by business.
• Created query using QAAWS and using Dynamic query created Xcelsius Dashboards.

Environment: SAP BI 7.1, SAP ECC 6.0, FI/CO, SD, MM, ABAP/4, Query Designer, BO Design XI 3.1, WEBI XI 3.1, Xcelcius 2008.

Senior IT ERP Business Systems Analyst May’ 2007 – Jan’ 2010
Client: Confidential, FL

Responsibilities:

• Gathering requirements from the users and convert them in to technical specs.
• Developed Budget workbook to automate the process for the users to budget for every year and ease the process for the 30 business personnel to make budget decisions easier and faster.
• Developed the Wind Resource Automation workbook and reports to automate the monthly process of calculating and manipulating data for 40 plants.
• Worked on foreign currency reports and converting the currency to EURO.
• Develop the functional and technical specs and design and develop reports using Query Designer.
• Developed multiple queries, workbooks and web reports like Comparative Plant Managerial Metrics, Invested Capital, Notes Receivable/Payable, Tax provision reports, Consolidated Income Statement, Budgeting/Forecasting Reports etc...
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Created BW components like Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.
• Conduct training sessions for end users on BW workbooks and Web templates on navigation, using parameters and extracting and displaying data as required for analysis.
• Performed unit testing on the complete data flow of the model developed from source system through BI, user acceptance testing and data validation testing and prepared documentation.
• Production support: Resolving Remedy issues provide support to the business users, Maintenance like cube version analysis and cleanup, loads monitoring, create and manage aggregates.

Environment: BW 3.5, 7.0, ECC6.0, Windows NT, BEx Analyzer, WAD, FI/CO.

SAP BW Consultant Oct’ 2006– Apr’ 2007
Client: Confidential, CA

Responsibilities:

• Involved in requirement gathering from the users and converted them into technical specs.
• Used extractors from Logistics Cockpit for Sales Order Header and Item level and Billing.
• Used ODS objects to stage the data from different data sources and transferred the ODS contents into various data target and Info Cubes based on the requirement.
• Designed and developed Multiproviders on InfoCubes for sales and billing.
• Built Process Chains for running Delta (Batches) after manual INIT loads in Logistics, developed many ABAP routines for Update and Transfer Rules.
• Developed the Forecast Pack reports for the users to analyze what has been forecasted and what has been achieved and plan accordingly for the future.
• Developed reports like Gross Functional Expenses, Direct clearing, Operating expenses, Direct expenses, Indirect expenses, Cost of sales Non – GAAP forecast, Income Statement Non-GAAP forecast, Headcount forecast, Fully Burdened expense detail , Royalty Income, In-licensing expense detail, Product Sales etc .
• Loaded the hierarchies from R/3 and modified the extractor for changes to the specific hierarchies on 0Costcenter to change the display of the hierarchy nodes in BW.
• Loaded the transactional data and master data in BW.
• Created Structures, Calculated Key figures, Restricted Key figures, conditions and exceptions.
• Created aggregates and set the read modes to analyze and increase the performance.
• Developed web reports and published the reports on the web and also developed Dashboards.
• Completed the unit and integration testing successfully.
• Presented the project to the users and completed documentation.
• Involved in end user training and prepared end user material.

Environment: BW 3.5,SAP R/3 4.7, Windows NT, BEx Analyzer, WAD, FI/CO, SD.

SAP BW Consultant May’ 2006 – Sep’ 2006
Client: Confidential, CA

Responsibilities:

• Involved in requirement gathering and designed the functional and technical specs.
• Developed Info cubes, ODS and Multi providers and extracted and loaded data from R/3.
• Developed Forecast Metrics reports for the users to forecast for the future depending on the actual for the units and extended cost and also depending on the SKU level, Weighted Average and Mix Error percentages.
• Developed queries in purchasing based on the Purchasing Data, Vendor Evaluation and Purchasing Groups cubes.
• Developed Dash Boards and familiar with Information Broad Casting in SAP Net Weaver 2004S.
• Used Information Broad Casting and set the BEx and Web reports on pre calculation.
• Distributed the Workbooks and Web Reports to the users using Broadcasting.
• Created and formatted workbooks and also created Jump queries for drilling down to the detailed reports from the summarized reports.
• Performed end user training sessions in reporting scenarios, and documented the BW process of the project

Environment: BW 3.5,SAP R/3 4.6C, Windows NT, WAD, Net Weaver 04, FI/CO, MM.

SAP BW/BPS Consultant Jan’ 2005 – Apr’ 2006
Client: Confidential, TX.

Responsibilities:

• Developed [ETL] Extraction, Transfer and Loading of Data from R/3 to resolve the complexity in maintaining the Tax structure, developed an integrated tax solution.
• Built Transactional cubes for Planning and Basic cubes for actual data. Created multi-planning area to transfer the data from Actual Data to Plan Data.
• Extensively worked with planning functions COPY, FOX formulas, allocation, distribution, aggregation, Delete, Revaluation, Reposting, Currency translation, Forecast for allocation.
• Configured SEM-BPS features to include: planning areas, levels, packages, and layouts to carryout planning functions.
• Implemented Characteristic Relationship in all planning areas using Attributes, reference data, hierarchies. Worked on User Exit for specific user required combination of characteristic values.
• Designed and handled manual planning layouts using layout builder with different formats.
• Created Variables to limit configuration and control access to planning levels and layouts, development of Planning Sequences.
• Created reports that are used on a Daily, Weekly, Monthly and Annual basis.
• More than 60 reports have been developed which include BBC Cost Based, BBC UK APA, and Federal IT return to Provision, NOL, Deferred Roll forward, Current Foreign Income Tax Liability, Effective Tax Rate, Analysis of Tax Accounts, and Income Tax Reconciliation, Provision (benefit) for Income taxes with discrete Items, Deferred Tax Liability, Permanent Differences, and Tax Provision.
• Used RRI jump queries for drilling down to other queries.
• Actively involved in training end users and preparing end user material.

Environment: SEM - BW 4.0, SAP R/3 4.6C, Windows NT, BEx Analyzer, WIB, FI/CO.

SAP BW Consultant May’ 2003 – Nov’ 2004
Client: Confidential

Responsibilities:

• Designed and modeled the complete data warehouse solution with ETL by building custom CO-PA info Cubes and all custom structures and objects to fit the business requirements of the client.
• Performed data extractions from SAP R/3 and Non-R/3 systems to BW for HR and FI/CO.
• Identify/resolve supporting master data issues for the payroll cubes.
• Identify and complete specs for HR payroll queries.
• Developed BEx queries on standard and customized Payroll cubes.
• Thoroughly analyzed Short Dump and Application Log reviews to debug errors Created indices for info Providers for better query performance.
• Loaded Hierarchies for Profit Center, GL-Account, Product, Customer, etc from R/3 to give user friendly reports out of BW.
• Developed custom reports like Ultimate Comparison – Actual/Budget, Account Analysis Detail, Gross Profit Detail, Gross Profit Consolidated by divisions, Journal detail reports, Revenue detail analysis, reports related to Film Costs and various Validation reports.
• Created Queries, workbooks and used customer exit to create variables.
• Created formatted reports using Crystal Reports.
• Assisted in performance tuning for loading data and improving the query response time using aggregates, Info Cube partitioning and indexing.
• Performed end user training sessions in reporting scenarios, and documented the BW process of the project

Environment: SAP BW 3.0B, SAP R/3 4.5B, Oracle, BEx Analyzer, Crystal Reports,  Crystal Enterprise, HR, FI/CO.