SUMMARY:

• SAP Consultant with 14 years of extensive experience in IT industry, specialization in Enterprise Data warehousing, Business Intelligence, Analytics and Integration, expertise in SAP BI Implementation with BW, Business Objects and HANA Platforms
• Three full life cycle implementations which includes project preparation, gathering requirement, business blueprint, realization, Production support and end user documentation and training under deadlines with extensive experience
• Involved in upgrade of BW 3.5 to BI 7.0, BI 7.0 to BW 7.4 powered by HANA.
• Expertise in designing and maintaining InfoObjects, DSO, ADSO, InfoCubes, MultiProvider and Composite provider (HCPR).
• Expertise in designing HANA information models: Attribute View, Analytic View, and Calculations Views.
• Experienced in OLTP extractions of SAP LO - Cockpit, CO-PA, CO-CA, FI-GL, FI-AP, FI-AR, PCA, GTM, MM, IM, PM, ISU/CCS, PS, Generic extractions and non-SAP data.
• Data Provisioning extracted data from ECC using ODP and SLT, used BODS as an ETL for extracting data from other systems.
• Expertise in Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Data Mart, Open Hub Service, Scheduling and BW Transports.
• Worked extensively on SAP BW Modeling tool, SAP HANA Modeler, BEx Analyzer, Query Designer, Web Application Designer, WEBI, SAP Design Studio, and Lumira.
• Generated reports on InfoProviders and Multiproviders using Structures, Restricted Key Figures, Calculated Key Figures, Cell editors, Characteristic Variables, Text Variables, Formula Variables, Exceptions, and Conditions.
• Expertise in publishing reports to roles and portal, broadcasting workbooks, reports to end-users, scheduling WEBI reports.
• Created WEBI reports & Crystal reports and deployed them through Info View with BW Universe as Source and BICS connection.
• Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Alerts for creating Business Objects reports.
• Created Advance analytics like Speedometers, Interactive Metric Trends to gauge the performance of the Key Businesses and display them as Dashboards.
• Good skills in dealing with production support issues, which involved debugging of data loads, update routines and transfer routines, process chains and monitoring and scheduling data loads.
• Involved in assignment and maintenance of Roles and Authorizations to users for BI security.
• Conducted training on BEx, WEBI, SAP Lumira for Business Users and Web training and new features to power users.
• Communicate effectively with Team members, developers, clients and end users in a diverse matrix environment.

TECHNICAL SKILLS:

Data Warehouse: HANA 1.0, SAP NW 2004s BW 7.4, BI 7.0, 3.5, 3.1C, 3.0B.

Operating Systems: Windows NT 4.0/XP/2000/98/Unix, Windows 9x, MS-DOS

Languages: ABAP, HTML, Java, SQL, and PL/SQL.

ERP Packages: SAP R/3 ECC 6.0, 4.7, 4.6C, 4.6B.

Web Technologies: HTML, XML, ASP, Web Tools & Servers Java Web Server2.0, Microsoft Front Page.

OLAP/Reporting Tools: BEx Reporting, Web Application Designer, Report Designer, Business Objects (XI R2.1, 3.1), Web Intelligence (XI R2.1, 3.1, 4.1 & 4.2), Info View, Crystal Xcelcius 2008, SAP Lumira, SAP Design Studio

PROFESSIONAL EXPERIENCE:

Confidential,MO

SAP BW/HANA/BOBJ Consultant

• Gathered requirements from client and assisted client functional team in understanding reporting needs of the project.
• Prepared necessary documentations and time lines for blue printing, realization, testing and go-live cut-over activities.
• Designed BW models for PQSE, Grain Profitability and ARROP reporting.
• Created custom data models (DSO, Infocube and Multiprovider) for extracting data from non-SAP (DB connect) and SAP for PQSE & GT reporting.
• Implemented SAP CCA and PCA business content for Grain profitability reporting.
• Created BW IP data models for Asset health metrics and APD models for summarized reporting.
• Proactively involved in migration/upgrade from BI 7.0 to BW 7.4 powered by HANA.
• Migrated BW 7.x data models to BW HANA Optimized version.
• Installed and customized business content for SAP Plant Maintenance by using HANA optimized objects (ODP datasource, ADSO, Composite provider).
• Remodeling of Inventory dataflow by leveraging HANA optimized BW objects.
• Design and creation of HANA Information Models (Attribute View, Analytic View and Calculation view) for Cost Savings Analysis.
• Design and development of KPI, Industrial Expense and Industrial Metrics reports using Bex Query Designer, WAD and SAP Design Studio.
• Developed Productivity Scorecards with complex calculations merging multiple Bex queries in WEBI for Crush, Refine, and Bottling and Packaging divisions of Bunge Global operations (BNA, BAS, BBR, BSC and BEMEA).
• Created process chains, meta-chains and scheduling of BO reports.
• Handled Support, maintenance and enhancement activities.
• Created user manuals and trained end users in SAP Lumira.

Environment: SAP ECC 6.0, SAP BW 7.4 on HANA, HANA 1.0 SP12, SAP BI 7.0, SAP GTM, SLT, PM, IM, PCA, ABAP, BEx Analyzer, Query Designer, SAP BOBJ (4.x), SAP Design Studio, Lumira

Confidential,NY

SAP BI/BOBJ Consultant

• Gathered requirements from client and assisted client BI functional team in understanding BI reporting, security needs of the project.
• Created gap analysis, technical specifications, designed BI models for JMS Reporting, JRS Cost Reporting (SAP PS, Inventory), Survey Analytics Reporting.
• Installed and customized business content for SAP Project systems.
• Created custom DSO’s, InfoCubes, Multiproviders and DB connect datasources for extracting & reporting Job management system (Oracle) and SVA data.
• Developed function module based generic extractors for pulling SAP Project systems and Inventory data.
• Created delta enabled DB connect datasources using ABAP (FM, Programs etc.).
• Enhanced the standard SAP PS master and transaction datasources for extracting custom fields.
• Created start routine, end routines and expert routines for handling different business rules in transformations.
• Developed realignment process for updating Veeva vault data (non-sap) through self-update transformation, DTP routines.
• Developed Open hubs to external targets through APD methodologies
• Automated data loads through creation of Master data, Transaction data and Meta chains.
• Created BEx queries with RKFs, CKF’s (restricted and calculated keyfigures) & formula variables.
• Created BO OLAP universes on top of SAP BEx queries to access SAP BI data.
• Created WEBI reports and deployed them through Info View with BW OLAP Universe as Source.
• Created complex WEBI reports by merging multiple BW OLAP universes.
• Developed Job history & cost reports, Census reports and Survey reports etc.
• Prepared BI Authorization design documents for creating user access to BO WEBI reports.
• Prepared Power User and End User training manuals, and conducted WEBI training sessions to client users.
• Developed VBA application to generate PowerPoint decks from WEBI reports.

Environment: SAP ECC 6.0, SAP BI 7.0, PS, ABAP, BEx Analyzer, Query Designer, SAP BOBJ (XI R3.1), Oracle, VBA.

Confidential,TN

SAP BI Consultant

• Prepared Gap Analysis Documents to drive enhancements, Design Documents and Technical Specifications Documents.
• Created custom master data InfoObjects, transformations, Flat file DataSources, DTPs and Infopackages. Data was loaded from Flat file DataSources and Essbase Server through UD connect.
• Created Views, generic extractor with delta capability, custom DSO & Info Cubes and extracted data to BI system for Travel & Expenses (HR) reports.
• Enhanced the extractor and populated the added fields through custom program included in user exit.
• Created custom extractor for Billed items (SD) with full and delta capability. Created text data sources for billed items (SD).
• Installed and migrated the Business Content for Headcount and Personnel Actions (Personnel Administration).
• Created transformations, transformation routines, complex start routines and transformation routines for Sales, Backlog Revenue and FTE scenarios.
• Created self-update transformations and end routines for realignment of Backlog process.
• Created direct update DSO’s (EDW layer) and regular APD process for populating the Headcount DSO.
• Created, filled and maintained BI Accelerator Indexes on InfoCubes.
• Created custom APD programs for loading high volumes of data to Direct Update DSO’s for Revenue summary model.
• Designed and created multiproviders for supporting multi-functional specific requirements.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data and scheduled them according to data publication calendar.
• Expertise in using BW Tools for analyzing and performance tuning the daily & weekly process chains.
• Developed test cases for unit test and integration test scripts for various data flows, and performed testing using quality center.
• Acted as a bridge between the business and information technology teams for Dashboard designs
• Created BI queries with restricted keyfigures (RKF), calculated keyfigures (CKF), cell restrictions, help cells, exceptions.
• Created Interactive Metric Trends to gauge the performance of the Key measures and display them as Dashboards.
• Created BW OLAP Universes on top of BW Queries to access the BW data in Business Objects.
• Created Year over Year (YOY), Rolling period trend reports for utilization and Revenue, Billed items scenarios.
• Created WEBI reports and deployed them through Info View with BW OLAP Universe as Source.
• Designed dashboards using Xcelcius and developed detailed level reports using WEBI.

Environment: SAP ECC 6.0, SAP BI 7.0, HR, FI, SD, COPA ABAP, Sales, BEx Analyzer, Query Designer, Web Application Designer, SAP BOBJ (XI R3.1) Crystal Xcelcius 2008, Essbase Server.

Confidential,OK

SAP BI/BOBJ Consultant

• Actively involved in requirement gathering, gap analysis, Design and implementation.
• Prepared Gap Analysis Documents to drive enhancements, Design Documents and Technical Specifications Documents.
• Developed a Proof of Concept Project for SAP Business Objects compatibility with SAP Business Intelligence.
• Installed the Business Content for Plant Maintenance, Customer Service, IS utilities, Accounts Payable, Purchasing (MM), Cost center Accounting (CO-CA), Human Resources, and Customized as per Client Requirement.
• Extensively Migrated the Installed Business Content Objects and Dataflow to BI 7.0.
• Developed Write Optimized DSO’s for EDW layers and Standard DSO for Consolidation Layers.
• Created Direct Update DSO’s for creating history data and for snapshot scenario reports.
• Developed Transformations with Start Routine, Update Routine and End Routine. Created and Maintained DTP and InfoPackages for Loading.
• Created Generic DataSources with ability of Delta Functionality.
• Enhanced the Master Data and Transaction DataSources with Z-fields and populated using User Exits.
• Created flat files for Hierarchies and Custom Hierarchies in R/3 and loaded them to BW.
• Extracted Maintenance and Service orders data (Plant Maintenance, Customer Service), Inventory Management Data, Purchasing Requisitions and Purchase Orders data (MM) using LO-Cockpit extraction.
• Also Extracted Accounts Payable Line Items data (FIAP) and Human Resources (HR) data.
• Extensively extracted IS Utilities Master data (such as Account Determination, Connection Object, Installations, Business Partner, Rate Category, Usage Class etc...)
• Extracted IS Utilities Revenue data such as Billing Details, Customer Counts and Miscellaneous Revenue.
• Created InfoSets (Backlog and Past due Orders) and Multiproviders for driving reporting requirements.
• Integrated FIAP and MM data by creating InfoSets for Procure to Pay reporting Scenarios.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Created Universes on SAP BI/BW Queries and InfoCube as Source Data.
• Created Universe pre-defined filters, Dimension Objects and Calculated measures in OLAP universe’s with the help of MDX Functions.
• Created WEBI reports & Crystal reports and deployed them through Info View with BW Universe as Source.
• Created Number of Orders Closed, Past Due Rolling 12 - Month reports for Plant Maintenance and Customer Service Orders.
• Generated Cycle Time Reports for Procure to Pay (MM and FIAP) and Monthly Labor Distribution reports for Human Resources.
• Developed IS Utilities reports related to Customer Billing and KWH measures.
• Created Inventory Accuracy Dash boards (Xcelcius) and for Management Reports for Inventory Management, and Wages and Cost report from Cost Center Accounting data.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Created Exception Aggregations, Cell Editors, Formula Variables, RKF’s and CKF’s in the Queries.
• Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created Advance analytics like Speedometers, Interactive Metric Trends to gauge the performance of the Key Businesses.
• Created Hyperlinked Web Intelligence (WEBI) Reports using Open Document Functionality.

Environment: SAP ECC 6.0, SAP BI 7.0, PM, CS, MM, ISU/CCS, HR, FI, Inventory Management, ABAP, BEx Analyzer, Query Designer, Web Application Designer, BO Designer (XIR 2.1,3.1), WEBI (XIR 2.1,3.1) Crystal Xcelcius 2008.

Confidential,KY

SAP BW Consultant

• Actively involved in requirement analysis, data modeling and technical implementation.
• Involved in upgrade of BW 3.5 to BI 7.0.
• Installed Business Content for Financial and Profit Center Accounting Info Cubes and customized the FI-GL, FI-AR, FI-AP and PCA business content cubes for meeting the business requirements.
• Extensively worked with General ledger, Accounts payable data sources for extraction and loading of data from FI to BW.
• Created custom InfoCubes such as FIGL CC00 for GL Line item data and FIAP CC00 for AP Line item data over standard business content DSO.
• Worked extensively on Profit Center Accounting data sources such as 0EC PCA 1, 0EC PCA 2.
• Defined and maintained transformations created DTP’s and Infopackage for scheduling the loads to data targets.
• Extracted data from SAP (FI & PCA extractions) and legacy systems (using DB connect). Involved in Generic Extraction of PCA data.
• Used ETL for data staging, cleansing and consolidation.
• Created Start routines and End routine in transformations to update characteristics and key figures in the InfoCubes.
• Performed Remodeling on existing cubes to accommodate new keyfigures and characteristics.
• Responsible for loading Master data (Texts, Attributes and Hierarchies) and Transaction data from R/3 Data Sources, Non - SAP systems and from Flat Files.
• Expertise in troubleshooting the load failures and extensively used Error-DTP for correcting the loads.
• Improved query performance and data load using aggregates, compression and partitioning techniques.
• Created and maintained BI Accelerator Indexes using BI accelerator administration tools (RSDDBIAMON, RSDDV).
• Generated reports to display the debit and credit total and the balances of a FIGL account interval for the individual posting period of the specified fiscal year.
• Extensively worked with the workbooks in the creation of Profit & Loss (P&L) reports for Rehab facilities.
• Involved in creation of different types of reports such as month to date (MTD) reports, year to date (YTD) reports, monthly reports, quarterly reports and annual reports for a facility analysis
• Data Mining: Created Analysis Process Designer (APD) to create a complex Charge Alert report.
• Created Customer Exit Variables for MTD and YTD reports. Expertise in debugging the Start routines and end routines.
• Extensively used formula variables, conditions, exceptions, exception aggregation and Cell editors for developing complex custom reports and dashboards.
• Created iViews, pages to display BEx/web reports in Enterprise portal 7.0.
• Worked on pre calculated Web templates used Control queries to increase the performance of query and also worked on OLAP Cache.
• BI Security: Implemented Authorization Objects, Roles, Profiles, Activity Groups etc and also Analyzed Web reporting functions using Web Application Designer (WAD) and Information Broadcasting.
• Extensively used Information broadcasting for broadcasting web reports, workbooks to end users and power user.
• Conducted training on BEx usage for Business Users and Web training and new features to power users.

Environment: SAP ECC 6.0, SAP BI 7.0, BW 3.5, FI, PCA, ABAP, MS-SQL server 2005, Bex Analyzer, Query Designer, Report Designer, and Web Application Designer.

Confidential,OH

SAP BW Consultant

• Involved in the Design phase and developed the different design documents like system specification, ETL design documents and Reporting Design document.
• Involved in data migration from BW 3.5 to BI 7.0.
• Customized the Procurement Cube to enhance the BC as per the client requirements by adding attributes to the master data.
• Created custom extractors with delta functionality using function modules for MM data extraction.
• Extracted data from MM, SD module from InfoSources and loaded the data into the procurement cube using LO-Cockpit.
• Business Content InfoCube was used for over all Sales Analysis. Transaction data was loaded from different Sources Systems using InfoSources such as 2LIS 11 VASCL, 2LIS 11 VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order.
• Enhanced Business Content Data Sources by using append structures and User Exits from transactions SMOD and CMOD.
• Developed a report on MM cubes to check the price variance for materials from different vendors. Checked the existing records for the given vendor to show the difference in prices.
• Generated reports to display the balances sheets of a FIGL account interval for the individual posting period of the specified fiscal year and saved them in workbooks.
• Created reports on the SD cubes to display Incoming orders and Sales figures for different facilities of the company.
• Involved in creation of dash boards for sales, purchasing and delivery using web application designer.
• Supported in solving post-production issues, created documentation and developed end user training material and also conducted training sessions.

Environment: SAP ECC 6.0, SAP BW 3.5, BI 7.0,BEx Analyzer, Query Designer, Web Application Designer, Cognos 8.2, FI, SD, MM.

Confidential,WI

SAP BW Consultant

• Actively involved actively in requirement analysis, data modeling and technical implementation.
• Performed design, development implementation of standard/customized InfoCubes and ODS Objects for Cost Center Accounting.
• Analyzed the reporting requirements that could be fulfilled by business content Infocubes for Cost and Allocations 0CCA C11.
• Extensively worked with Cost Center Accounting data sources such as 0CO OM CCA 1, 0CO OM CCA 9.
• Created Multiprovider s over cost center accounting InfoCubes and ODS Objects for reporting purposes.
• Designed and created custom InfoCube ZSD C241 for sales order and ODS ZSD C123 for sales delivery.
• Worked on sales order InfoSouces such as 2LIS 11 VAHDR, 2LIS 11 VAITM and on sales delivery InfoSources such as 2LIS 11 VCHDR, 2LIS 11 VCITM, and 2LIS 11 VCSCL .
• Created navigational attributes on existing InfoCubes as a part of maintaining and developing new reports.
• Performed performance tuning of queries using indices, aggregates, compression and partition.

Environment: SAP R/3 4.7, SAP BW 3.5, BEx Analyzer, Query Designer, Web Application Designer, SD, CO.

Confidential,TX

SAP BW Consultant

• Interacted with the end users to understand their reporting requirements and creating document of understanding.
• Performed analysis, design, development and implementation of standard/customized InfoCubes and ODS Objects for MM and SD modules.
• Loading the master data and transactional data from the flat files & SAP R/3 to BW using
• LO-Cockpit, COPA, FISL and Generic extraction methods.
• Involved in mapping of data source to InfoSource with transfer rules in SAP BW and also in mapping of InfoSource with data targets using update rules.
• Created virtual key figures and calculated key figures to satisfy the reporting requirements.
• Analyzed InfoCubes (RSRV) and maintained aggregates (RSDDV) to improve performance.
• Developed BW reports using BEx analyzer, created queries with variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Improved query performance and data load using aggregates, compression and partitioning techniques
• Used the report/ report interface to jump between the queries for efficient analysis of data.
• Used ABAP routines (start routines and update routines) in update rules and transfer rules to update characteristics and key figures in the InfoCubes.
• Analyzed and optimized the processes in BW using BW statistics.
• Developed documentation on BEx reporting for the end users.

Environment: SAP R/3 4.7, SAP BW 3.3, BEx Analyzer, Query Designer, Web Application Designer, SD, MM, FI/CO.

Confidential,TX

SAP BW Developer

• Active participation in gathering user requirements and performing data modeling using BW extended star schema concepts.
• Prepared technical specification with respect to functional specification before going to develop objects.
• Developed module pool program, which will collect the data from different database tables according to end user requirements.
• Involved in Creation of ODS Objects and also worked with various options. Which involves activating data in ODS, deleting data in change log and also updating the data in ODS to subsequent data targets, involved in maintaining Multi-Cubes.
• Designed Two Info cubes with daily and monthly granularity, extraction from PSA.
• Structure and Metadata maintenance for the Info Source and source system
• Created classical and interactive reports using BEx analyzer, Query designer for the required purchasing and sales order queries.
• Created a report which displays sales order and line items, which needed to be delivered on a particular date.
• Uploaded Transaction Data from Flat File as the Source System. Involved in Info Cube maintenance i.e., Compression, Roll- up.

Environment: SAP BW 3.1C, SAP R/3 4.6C, BEx Analyzer, SD, MM.