Sr. Consultant- SAP BI Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Payton Donoven 

payton@gmail.com 

Summary:

Ø    SAP Consultant with 7+ years of extensive experience in SAP BW, playing various key roles in SAP BW/BI/BO - Data Modeling, Report development and expertise in Performance tuning.

Ø    Implemented three full life cycle implementations for different modules (FI/CO, SD, MM, PP, CS, PM, CRM) in SAP BI/BW in all phases like Gap analysis, Blue-printing, design specification, development, performance tuning, testing, documentation, maintenance, training, Security authorizations and trouble-shooting..

Ø  Upgrade Experience in SAP BW from 3.5 to BI 7.0 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0.

Ø  Well versed in several areas of BW/BI in the Logistics and Financials applications (SD, FI/CO, MM,  PM, CS and PP, CRM).

Ø  Expertise in ETL activities like Data Extraction, Data Modeling, and Loading (Full/Delta upload).

Ø  Proficient in Data Extraction from SAP ECC (FI/CO, MM, SD, PP, PM, CS, CRM), BW/BI using extraction structures such as LIS, LO Cockpit, FI and Generic Extractors.

Ø  Excellent experience in activating & enhancing the standard Datasources with structural changes & User Exits with complex ABAP coding, Extracted Data from Flat files & DB Connect source systems for legacy data.

Ø  Worked on routines (start routines and update routines) to update characteristics and key figures in the InfoCubes.

Ø  Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.

Ø  Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer)for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries and Web application designer.

Ø  Worked on Business Objects(BOBJ) using Universe design, Dash board reporting.

Ø  Experience using Universe Designer, Web Intelligence, Crystal Reports 2008, Xcelcius and BW OLAP Universes.

Ø  Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques, OLAP cache.

Ø  Experience using Open hub service extracted Data from BI and transferred to other Systems.

Ø  Created and maintained BI Accelerator Indexes using BI accelerator administration tools.

Ø  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.

Ø  Strong planner and organizer with demonstrated ability to develop business solutions that increase efficiency, productivity, and profitability.

Skill Set:

Data warehouse     : SAP BW 3.0C,3.1C,3.5, SAP BI 7.x

Language                    : C, C++, Java, SQL, PL/SQL, ABAP/4

ERP Packages : SAP ECC 5.0,ECC 6.0, R/3 4.6,R/3 4.7

SAP Modules           : SD, FI/ CO, PP, MM,CS.PM

Web                            : 

L, XML, Dream Weaver.

Reporting Tools   : BEx Reporting, Web Application Designer, Business Objects (XI), Crystal  Reports

Databases             : SQL Server 2000/2005, Oracle 8i/9i/10g, MySQL, MS Access

Web Servers         : IIS 5.0/6.0/7.0

Operating Systems           : Windows family, UNIX

Professional Experience:

Bank of America, NC
June 2010 – Present

SAP BW Consultant                                                                             

Environment: BI 7.x ECC 6.0, FI/ CO, Business Objects XI 3.1, BEx Analyzer.

Responsibilities:

·        Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.

·        Understood the business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business Requirements.

·        Activated the Business Content for Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL), Cost Center Accounting (CO-CCA) and customizing them as per the client requirement.

·        Initialized and Extracted deltas from the data sources 0FI_AR_4, 0FI_AR_6 and 0FI_AR_10 from the tables KNC1, KNB4, BSAD/BSID loading Finance Line Items and Payment History details to the ODS 0FIAR_O03, 0FIAR_O06, 0FIAR_O10.

·        Developed multiproviders ZFIAR_MU01, ZFIAR_MU02 and ZFIAR_MU03 above the ODS and cubes 0FIAR_C03, 0FIAR_C06, 0FIAR_C10.

·         Created reports Finance “Days Overdue analysis” “Payment History by Document Type”, “DSO Analysis by Period” reports.

·        Activated accounts payable cubes, accounts receivable cubes, Sales cubes from Business Content and customized as per requirement.

·        Extracted daily deltas of Cost Center actuals from data source 0CO_OM_CCA_9 and loaded into the Costs and Allocations InfoCube 0CCA_C11.

·        Extracted Cost center statistical key figure actuals for headcount into 0CCA_C03 InfoCube from datasource 0CO_OM_CCA_3.

·        Developed Write Optimized DSO’s for EDW layers to improve the performance.

·        Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC Generic Extractions and also in BI data modeling like Start Routines and End Routines.

·        Created Aggregates on Info Cubes to improve the query performance.

·        Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.

·        Created Daily Sales Reports which involves Daily Sales Orders, Order Reasons, Customer Group and other important sales data.

·        Created daily invoicing report involving all import billing data and Created daily back order report involving import sales, material and date.

·        Created BI OLAP universes over BEx queries using Universe Designer.

·        Extensively worked in INFOVIEW to create Web Intelligence Reports over the Universe Created.

·        Designed process chains for daily master data loading, transactional data loading from SAP ECC.

·        Transported all necessary objects (DEV to QAS) and then imported the requests to production.

St.Mary’s Health Center,MO

June 2009 – May2010

SAP BW Consultant
Environment:   SAP BI 7.0/IP, BW 3.5, SAP R/3 4.7, ECC 6.0 SD, MM, FI/CO, CRM, SAP BEx Analyzer, BEx Analyser, BOE XI 3.1.

Responsibilities:

·        Involved in complete lifecycle implementation of the project from gathering user requirements,   preparation of technical specifications documents, designing and developing reports, unit testing(UAT) to Go live production support.

·        Implemented SAP BI 7.0 for SD, PP, MM modules.

·        Involved in analyzing and designing the data flow from ECC to BI and responsible for deployment.

·        Responsible for design, development and extraction of data from ECC source system into BI from SD, PP and MM using LO cockpit extraction methods.

·        Extracted data from Production (PP) and Process Orders (PP-PI) to analyze manufacturing orders.

·        Extracted data from data sources like 2LIS_02_ITM, 2LIS_02_SCL, 2LIS_02_HDR and populated into the procurement infocubes 0PUR_C07, 0PUR_C08, and 0PUR_C09 to evaluate service levels.

·        Created setup tables for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the ECC system to the delta queue of the BI system.

·        Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution (SD) modules (SalesOrder“2LIS_11_VAHDR/VAITM”, Shipping/Delivery“2LIS_12_VCHDR/VCITM”) and (Billing 2LIS_13_VDHDR/VDITM”).

·        Created reports like confirmed quantity, item purchase orders as requested, complete purchase order quantities delivered and purchase order values.

·        Developed reports in SD module like open sales order report which included all organization levels, delivery status, shipping details and partner function details.

·        Published the reports on the web using Web Application Designer using the wizard as well as drag and drop web items like ad-hoc, table and filter for creating customized web templates according to the user requirements.

·        Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.

·        Worked Extensively on Various production support issues and administration of BI back-end operations to ensure data is successfully extracted from source systems, transformed, loaded into the warehouse and available for business use when needed.

Pratt & Whitney, CT.

June 2008- May 2009
SAP BW Consultant                                                                                        

Environment: SAP R3 4.6, SAP BI 3.5, PM, CS, FI/CO, ABAP, BEx Analyzer, Query Designer, Web Application Designer.

• Actively involved in requirement gathering, gap analysis, Design and implementation.
• Prepared Gap Analysis Documents to drive enhancements, Design Documents and Technical Specifications Documents.
• Installed the Business Content for Plant Maintenance, Customer Service, IS utilities, Accounts Payable, Cost center Accounting (CO-CA), and Customized as per Client Requirement.
• Extensively Migrated the Installed Business Content Objects and Dataflow to BI.
• 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 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 BI.
• Extracted Maintenance and Service orders data (Plant Maintenance, Customer Service), Purchasing Requisitions using LO-Cockpit extraction.
• Also Extracted Accounts Payable Line Items data (FIAP).
• 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 Number of Orders Closed, Past Due Rolling 12 - Month reports for Plant Maintenance and Customer Service Orders.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Created Exception Aggregations, Formula Variables, RKF’s and CKF’s in the Queries.

Novartis Pharmaceuticals Corp, NJ

July 2007 – May 2008

SAP BI Consultant

Environment : SAP BW 3.5, BI 7.0, SAP R/3 ECC 6.0, SD, MM, PM

Responsibilities:

• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization
• Managed and monitored data loads with Full update and Delta update
• Created reports, which displays sales orders and line items, which needed to be delivered by a certain date
• Involved in extraction of data from PM.
• Involved in Up gradation of the system from 3.5 to BI 7.0, migrated BW 3.5 data sources to BI 7.0 data sources
• Created Data Transfer Process(DTP) to schedule the update in BI 7.0
• Experienced in formatting various changes in WAD like converting Bar graph to line graph during the upgrade
• Worked on ABAP data dictionary and improved performance on some of the reports
• Created Real-time info cubes for loading the BPS (Business Planning Simulation) data into it from RDA Data sources.
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors
• Enhanced new Info Objects to be attached/mapped in Info Sources/Communication structures. Changed transformation  rules as per customer requirements (ABAP routines)
• Designed, developed ETL, extracted BW Data to Non- SAP System using Open Hub service
• Maintained Process chains to automate and schedule the background performance tuning jobs of BW query using Indices, aggregates, Compression, Achieving and Partition
• Evaluated statistical performance on OLAP using BW Statistics  
• Rescheduled the failed request from the cube by deleting the requests in the Info Cubes
• Used the new functionality BEx Information Broadcasting available in BI in SAP Net weaver 2004
• Published the reports in Portals from WAD by sending them in iViews
• Generated reports based on reporting requirements on purchase order summary, purchase order details, sales order summary, sales order details, invoice details and BPS reports
• Created templates for web publishing using HTML, VB and JavaScript and published the report using the developed templates
• Involved in creating JavaScript for passing variables to  different levels for WAD (Web Application Designer)
• Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information, required in areas of SD and MM. Worked on Currency conversion as per user requirements.

Georgia Power, GA

April 2006-June 2007                                                                                                                                                             

SAP BW Consultant                                                                                                                                                                                                                                                      

Environment: SAP R3 4.6, SAP BW 3.5, FI, ABAP, Bex Analyzer, Query Designer, Report Designer, and Web Application Designer

Responsibilities:

• Actively involved in requirement analysis, data modeling and technical implementation.
• 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 ZFIGL_C0 for GL Line item data and ZFIAP_C00for AP Line item data over standard business content DSO.
• 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 key figures 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.
• 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.
• 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.
• 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.
• 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
• 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.
• Extensively used Information broadcasting for broadcasting web reports, workbooks to end users and power user.

British Petroleum, UK.                                                  

April 2005 – February 2006

SAP BW Consultant    

Environment: SAP R/3, BW, ABAP, SD and FI/CO.

Responsibilities:

·        Understood the Client requirement, prepared the technical specification of the report requirements.

·        Created interactive reports in SD module extracting information on sales organization levels, delivery and invoice status, shipping details and partner function details.

·        Created an Interacted Report to compare prices of products from various vendors.

·        Worked extensively to debug the existing SAP program and modify the code using modification assistant to customize the program as per requirements.

·        Developed reports for week’s capacity information, Return Summary List by Plants, Shipment details.

·        Extensively involved in debugging many ABAP report.

·        Developed routines to implement complex pricing requirements not handled by standard SAP.

·        BDC upload programs for Purchasing Info Records, Vendor Master and Bill of Material Data.

·        Create report to display the material master sales view and purchase views to cross verify with the legacy data to ensure data consistency.

·        Involved in analysis, specifications, development and testing for the sales data conversion from legacy system to SAP database system using BDC sessions method.

·        Created Production Order Status report.

·        Designed and created BDC module for changing Customer s attributes.

·        Generic Program to load data from Excel spreadsheet to custom tables.

·        Created custom transaction and area menus.

                                                                                                                                                                                        

Dr. Reddy Laboratories, India.

April 04 – March 05

Software Engineer

Environment: SAP R/3 4.6, BW 3.1c, 3.5, BEx Analyzer

Responsibilities:

·        Design and Development of Custom Info cubes, ODS objects, Multi Providers, Info sets and master data objects.

·        Developed Custom ODS objects that captures the erroneous data.

·        Development and Enhancement of Info sources, Transfer rules and update rules.

·        Created update rules with necessary update routines and start routines.

·        Created and activated Communication Structure, Transfer Structure, Transfer Routines, Update Rules

           (both ODS and Info Cube level). Built and loaded cubes and validated results.

·        Created Scheduling plans for data load to use Process chains in order to load Master Data and

·        Transactional Data from SD into BW.

·        Worked on system tools for tuning like RSRV, ST05.

·        Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.

Download Resume Format