SUMMARY

• SAP BI/BW consultant with more than 8 years of experience, which includes experience in Business Objects and BPC as a techno - functional consultant playing various key roles in Design, development, Production support and reporting techniques across modules FI/CO, HR, SD, PP, MM, WM.
• Implemented 2 Full lifecycles involving all phases of ASAP methodology including Requirement Gathering, Project Planning, Gap analysis and implementation.
• Worked on Data Extraction, Data Modeling, Transformations, Data Loading, Scheduling, Monitoring, LO Cockpit, CO-PA Extractions, BEx techniques, Reporting, Planning, and Consolidations.
• Maintained OLTP extraction from R/3 source systems such as LIS, CO-PA, FI-AR LO-Cockpit, non-SAP data into BW server, Flat Files and from Generic Data Sources.
• Implemented BI content data source enhancements as per client requirements.
• Created SAP BI/BW components like Info Objects, Data sources, Info Sources, Data Store Objects, Info cubes, Remote cubes, DTPs, Update rules, Transfer rules, Transformations, Multi Providers, Process Chains, Data Marts, and Open Hub Services.
• Proficient in Data modeling using MDM and BW extended star schema models.
• Wrote Start/End routines and User Exits/Customer Enhancements using ABAP/4 code.
• Experienced in Performance Tuning including Data Partitioning, Aggregates, OLAP Cache and Pre Calculated Web Templates.
• Experienced in Production support and issue resolution that involved debugging of data loads, modifying update routines and transfer routines.
• Worked extensively in BEx analyzer, BEx XLS query, Query Designer, Web Application Designer, Info set queries, Jump analysis using RRI.
• Designed Web Application Designer, published reports on web and involved in debugging and monitoring capabilities using Query Trace, BW Statistics.
• Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures and created aggregates for frequently used queries.
• Evaluated statistical performance and improved data load and query performance using Compression, Aggregates and Partitioning techniques.
• Experienced in APO demand planning, SAP BPS Planning Model, End-User Interface and Planning Process.
• Responsible for the successful delivery of functional and technical components of legal and management consolidation solutions using SAP BPC 7.5.
• Created new application sets in existing one such as ApShell application set, Applications, Dimensions, Hierarchy, Forecast data, BPC book for Planning and Consolidations.
• Developed flexible and powerful functions within BPC reports and input schedules to retrieve, display, and submit data for a real-time view of the financial planning position of organization.
• Worked extensively on Business Objects XI 3.1 - Business Objects Designer, Reporting, Web Intelligence, Crystal Reports and XCelsius reports.
• Responsible for designing Universes by creating Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Designed and Developed extensive Business Objects reports using multiple Queries , combination of chart and tables.
• Created different types of reports like Master/Detail, Cross Tab and Chart and Ad hoc Reports using End User module in Business Objects.
• Developed dashboards using Business Objects Xcelsius.
• Published Crystal Reports on to Business Objects Infoview to provide access to end users.
• Involved in Manual Testing of the application by developing Test Cases, Test Scripts using Quality Center by reviewing the business.
• Used RWD uPerform as part of training to capture knowledge and to facilitate the retrieval of knowledge.

TECHNICAL SKILLS

ERP Packages: ECC 6.0 and SAP R/3 - 4.7 / 4.6C, 3.1C.

SAP Modules: FI, CO, HR, PP, MM, SD, CO-PA, BPS, APO, BPC.

Data Warehouse: SAP BI 7.0 and SAP BW 3.5 / 3.1C.

Enterprise Database server: Oracle 9i, SQL Server.

Reporting Tool: BEx Reporting tools, Business objects XI 3.1 - WebI Reporting and Crystal Reports 7.X/8.X.

Languages: C, C++, Core Java, MATLAB, ABAP/4, SQL, PL/SQL.

Web Technologies: HTML, JavaScript, XML.

PROFESSIONAL EXPERIENCE

Confidential

SAP BI Architect

Environment: SAP ECC 6.0, SAP BW on HANA, BEx, Business Objects BI4.0, LumiraTableau, Power BI.

Responsibilities:

• Involved in gathering user requirements and worked with business process experts to understand their reporting needs.
• Activated SAP business content required for the business need. Enhanced the standard extractors and created custom extractors.
• Worked on most of the Finance deliverables including P&L, Balance Sheet, Roll Forward, Cost Center Reporting, Accounts Receivable and Inventory reports.
• Worked on complex cost center reporting which includes but not limited to expense reporting, consumption reporting and expense forecasting.
• Supported the Balance sheet and created business funds flow reporting throughout all the mergers and acquisitions.
• Worked on BW 7.4 new features such as Advanced DSOs, Semantic portioned objects and Composite providers.
• Worked on HANA migration project, impact analysis, pre-migration activities and post migration activities.
• Converted all the existing cubes to HANA cube and worked with new HANA features which include calculated views and converting the existing transformations to AMDP scripts to improve performance.
• Worked with EDH team in bringing the real-time data using Smart Data Integration.
• Worked on critical Finance deliverables and supported month end/ year end closing deliverables throughout the period.
• Maintained/Enhanced critical master data and hierarchy objects.
• Created several complex Bex queries which are used for building dashboards and mobile applications.
• Worked on security reports which would help the users determine the roles that they would need in order to access a specific report.
• Worked with HR/PeopleSoft team for their reporting purposes and also worked with several other 3rd parties and integration teams.
• Created and scheduled process chains for all the new developments/deliveries and maintained and modified the existing process chains addressing the failures in case of any.
• Worked on performance tuning to improve the query run times and backend load timings to achieve multiple runs/ increased frequency to near real time.
• Hands on experience with Power BI for proof of concept with some reports.

Confidential

SAP BI Consultant.

Environment: SAP ECC 6.0, SAP BI 7.0, ABAP/4, BEx, Business Objects XI 3.1.

Responsibilities:

• Gathered user requirements for analysis and reporting, identified Gaps and created Technical design documents.
• Worked on enhancing numerous extractors and its data flow for the data to be extracted by external systems through open hubs.
• Worked extensively on Open hubs and processed the data for external interfaces.
• Enhanced the existing FI reports as per the requests from business.
• Worked extensively on Finance and Controlling. Created BEx report for FI and CO consolidation purposes.
• Created Reconciliation reports and Close and Consolidation report.
• Worked extensively on Performance tuning such as Redesign of process chains, collecting statistics and created indexes.
• Enhanced Controlling extractors and populated the added fields using SAP load exit.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Created Transformation Routines, Start Routines, end Routines as per the requirement and for the lookups from one DSO to other.
• Developed Queries using Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Crystal reports, Authorizations, User profile maintenance, BEx Analyzer, Info set query, RRI, Web reporting and Workbooks.
• Developed Reporting jump targets using RRI to other reports. Created RRI report for drilling down from aggregated reporting on cube to line item detail report on DSO.
• Developed multiple Lead time reports using BEx for different scenarios to determine the Weighted Average Lead Time (by quantity)
• Worked on Analysis Process Design (APD) for identifying the missing records from previous month to current month for MTD calculation and to reproduce them with initial values.

Confidential, Mason, OH

SAP BI Consultant.

Environment: SAP ECC 6.0, SAP BI 7.0, ABAP/4, BEx, Business Objects XI 3.1.

Responsibilities:

• Gathered user requirements for analysis and reporting, identified Gaps and created Technical design documents.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Stored data from SAP R/3 tables into ODS objects through PSA to perform detailed level of reporting.
• Created Info Cubes, ODS, Multi Providers, Transformations, Update Rules, Transfer Rules, Communication Structures, Transfer Structures, DTPs, Info Packages, Process Chains.
• Uploaded Master and Transactional data from flat files and SAP R/3. Extensively involved in Master data management.
• Understanding and using different Data Warehousing Workbench Functions and Features.
• Created ODS object and loaded data into Info Cube for the deliveries by creating Data Transfer Process and Transformations.
• Customized extract structures in SAP R/3 by adding additional fields and developed the corresponding user exits to populate those fields. Worked extensively with LO Cockpit to activate required logistics data sources and did the delta management.
• Created Multi Cubes to utilize the existing data of the basic cubes and enhance the reporting flexibilities.
• Configured daily, weekly, monthly Process chains for loading master data and transaction data into business warehouse.
• Extracted data using flat files for raw materials in order to track inventory.
• Performed manual activities for testing the functionality of master data and transactional data extracts from various interfacing systems via flat files.
• Tested reports, workbooks and functionality of reports by analyzing data and filters within the report.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Created Open Hub Destination Objects (Info Spoke) to transfer data from standard Data Store Objects to Flat Files.
• Experienced in working with Business Explorer (BEx) tools and publishing the reports on web using Web Reporting tools.
• Used BEx analyzer to develop Sales Analysis and ABC Classification reports and facilitate data analysis using filters, navigational attributes, calculated and restricted key figures.
• Used Web Application Designer (WAD) to develop web reports using web items, interactive charts, graphics, and tables.

Confidential, TX

SAP BI/BO Consultant.

Environment: SAP ECC 6.0, SAP BI 7.10, ABAP/4, BEx, Business Objects XI 3.1.

Responsibilities:

• Involved in requirement gathering from the client and users, took part in GAP analysis and project scope planning.
• Accountable for BI reporting for Sales, Billing and Finance modules.
• Worked on LO Cockpit extensively. Creation of tables, Generic data sources, Customization of standard extract structures, Enhancement of the standard extract structure as per the requirement.
• Worked extensively with Sales Order, Billing, Delivery/schedule line and Document condition objects. Enhanced the data sources 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 13 VDITM, 2LIS 13 VDHDR.
• Loaded the data from R/3 to BW and used Initialization with delta update and full update methods for extracting Sales Order and Delivery Information.
• Scheduled and automated data loads from R/3 to BW and optimized the data load performance by adjusting the packet size, data selection and number of Info packages.
• Created and maintained Process chains for periodic loads of Master data and Transaction data from R/3 system to Data Targets and optimized the load performance by data selections and number of Info packages.
• Extended Transaction data and Master data by appending new data elements using enhancement component.
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other. Testing and Debugging of routines.
• Designed DSO’s for SD module for Sales Header, Sales order Item, Billing Items, Schedule line, Sales History, Sales Quota, FI/GL etc.
• Created Transformation mappings, DTPs, Info packages for all above DSOs.
• Setup custom multi providers for logical partitioning based on regions. Used multi provider hint to improve query performance.
• Created and maintained Master data objects with hierarchies. Created and maintained Process chains in RSPC to schedule daily loads.
• Involved in Performance enhancement features such as Cube Indexing, maintaining Aggregates, Rollups and cube Compression.
• Involved in cube remodeling and repartitioning as per requirement.
• Created custom queries to show sales according to region, cost center and compared the sales for the company products.
• Worked with Web Application Designer to create templates for presenting the sales and shipment history and used information broadcaster to send out pre calculated queries.
• Worked on deployment of Webi reports and Xcelcius dashboards.
• As a part of Universe development, created Classes, different kinds of objects, cardinalities, Strategies, resolving loops using Aliases and Contexts.

Confidential

SAP BI/BO Consultant.

Environment: SAP ECC 6.0, SAP BI 7.10, SAP BPC 7.5 NW, ABAP/4, BEx, Business Objects XI 3.1.

Responsibilities:

• Involved in full life cycle implementation of BI 7.0 in FI and MM modules.
• Worked on Data Extraction, Modeling, transformation, Data Loading, Scheduling jobs, Monitoring data loads and Reporting.
• Worked on DSOs, Info Cubes, Multi Providers, Update Rules and Start Routines. Business Content, Generic data extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring Performance tuning and extracting.
• Extracted actual expense data by Cost Center from SAP ECC to SAP BI into three separate Info Cubes E&P Cube, M&M Expense Cube and G&A Expenses Cube.
• Performed transaction data loading from ECC out of FAGLFLEXT table daily or on demand during month end using standard extractors into SAP BI DSOs and Info Cubes with transformation rules.
• Used process chains to schedule, monitor and validate data loads for both leading ledgers and non-leading ledgers.
• Extracted the data from MM modules and uploaded the data into procurement cubes using extractors 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL.
• Installed Business Content for Financial and Logistics Info Cubes to meet the user requirements.
• Developed the Data Source for CO-PA on the basis of operating concern (Account based and Cost based) and developed DSO objects for the Data sources and generated reports.
• Activated and Customized profit center accounting cubes which include accounts payable cubes, accounts receivable cubes. Extracted Line Item data from GL, AR and AP.
• Implemented BI Content data Source enhancements, Generic extractors, User exits and Customized delta built up for the data sources.
• Created Custom Data Source and User exits required for data extraction & Custom Update Routine for data transformation.
• Utilized the Analysis Process Designer (APD) to perform calculations of projected inventory levels.
• Partitioned Info cubes for query performance and archiving requirements. Assigned data classes and appropriate size categories to all data targets and building regular compression into data load processing.
• Worked on creating aggregates to do performance tuning so that it improves the query performance.
• Experienced with Business explorer Analyzer, Query Designer, Web Application Designer, Report designer (Net Weaver 2004s).
• Analyzed Business reporting requirements that could be satisfied with SAP business content and installed the necessary objects.
• Experienced in developing Queries, Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Crystal reports, Authorizations, User profile maintenance, BEx Analyzer, Info set query, RRI, Web reporting and Workbooks.
• Developed flexible queries using filters and navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized fashion.
• Experienced overseeing and facilitating enterprise level strategic planning, change management, and training initiatives.
• Customizing the reports, Input Schedules, Logic to meet the specific needs of the client using supported functions with BPC.
• Created BPC AppSets, Applications, Dimensions, Hierarchies, Script logic, Formulas, Data loads, etc. as well as enhanced SAP BPC functionality.
• Worked on data management and loading of transaction data to BPC using the data transformation, conversion logic, master data loaded to a BPC dimensions and validation of data loaded.
• Designed the Planning Layouts with WEB Interface for Planning Sales at different levels of aggregation for different Sales Managers, Product Managers and the Regional Directors.
• Created Business Process Flows.
• Implemented a Planning/Reporting/Budgeting application for organizational reporting and planning.
• Worked along with the team for SAP Security issues such as User Access Provisioning Management, Updated Transaction via SU24, Maintained transaction selection and authorisation objects in activity groups.
• Worked on WebI components to develop reports on universes using Universe Builder XML components.
• Performed on pre calculated Web templates and also OLAP Cache.
• Designed Universes and classes by Business Objects XI 3.1 enterprise tool and build all the objects required for WebI reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions.
• Reviewed all SAP MM reports and carried out modifications as per Clients requirements.
• Designed and deploy ad-hoc reporting functionality using WebI.