SAMPLE RESUME FORMAT with project details

SAMPLE RESUME FORMAT with Project details

My Name..........................................

Company name.................................

Address.............................................

Client………..........................................

Duration…………….................................

Project type…………………implementation

Team size 14

PL 1

TL 1

Basis consultant 1

BW consultants 4

ABAP consultants 4

Functional consultants 4

Job type contract

Consultancy name>>>>>>>>>>>>

Position technical consultant (BW)

Role team member

Project manager name XXXXXXXXXX

Team lead name XXXXXXXXXXXXXXX

Project manager status ONSITE

Team lead status in Bangalore office

Client details:

Project details:

It is BW implementation project. This project deals with implementation of

1 inventory scenario

2 purchasing scenario

3 sales analyses

4 financial analyses

As a team member I am working in inventory and purchasing scenarios

Inventory details:

To analysis of stock data from SAP R/3 and to evaluate materials for which no movement has occurred.

It includes two info cubes:

Material movement (technical name 0IC_C03)

Slow moving items (0ic_mc01)

The objective of this project is valuated stock analysis, blocked stocked analysis.

Slow moving item analysis, stock overview.

Purchase details:

This objective of this project is to analyze purchase data from R/3

It include fallowing info cubes

Purchase data (0pur_c01)

Vendor evaluation (0pur_c02)

Purchase groups (0pur_co4)

The key points regarding this project are

1 analysis of material groups, vendors and materials. This data enable u to find answers to fallowing questions

Each material have been order from certain vendors.

Project status: scheduled to completed by Jan 2010

BW expertise

1 Business area: business area R/3 Logistics modules (SD<MM<PP< Wm), FICO.

2 BW Info cube design, info sources, info Object maintenance, ODS objects, update rules/trans rules.

3 BW reporting: BEx business explorer, analyzer, business browser, restricted key figures, structure, variables, exceptions, conditions, RRI, info set  query, and (WAD),web reporting.

4 BW security: reporting authorization, user profile maintenance (PFCG)

5 Customization  data source enhancement, Generic extractors, user exits and customized delta built up for the data source, update/transfer rules creation.

6 BW administration: use process chain

    Extensively to administrator background process in BW

7 BW operations: data load management, event processing and reporting optimization.

8 ABAP reporting, use exits, customer modifications, routines.

9 training: conducting training sessions for users in BW reporting, security and end user training in reporting and knowledge training.

PRODUCTION SUPPORT

1 involved in escalating high prioritized tickets regarding extraction, performance issues and also load failures.

2 analyzed and corrected production problems as they occur in the SAP BW systems.

3 monitoring of info packages and analyzing the reasons for failures of info packages

4 job logs overview in Sm37 and tRFC IDOCS execution in sm58, sm50.

5 maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not      after data loads.

6 maintaining work history for all tickets until it is closed down.

7 To communicate with customer who posted the tickets.

8 resolved the customer posted tickets through main.

9 provided high level of customer service to end users, business units and groups.

10 daily monitoring of info cubes and ODS objects requests.
11 presentations to business client on the BW reports for their sign off


Model Resume Preparation:

Name: xxxxxxxxxxxx                                                                                            xxxxxxxxx@gmail.com

SAP BI/BO Consultant                                                                                           Contact: (xxxxxxxxxx)

Professional Summary

·        Vast  experience in  SAP BW/BI 3.5/7.0 consulting.

·        Implemented 2 full life cycles following the ASAP methodologies which included requirement gathering, business blue printing, gap analysis, realization and go-live and post go-live support in SD, MM and FI-CO functional areas.

·        Good knowledge in SAP BI/BW implementation with in depth technical skills in various SAP R/3 implementations, Rollouts, Upgrades, and Post implementation support  in  MM and SD mainly using LO- cockpit extractions.

·        Implemented SAP BI/BW with in depth skills in FI-CO module and worked on sub modules likes FI-AA(asset accounting, Customer/Vendor Analysis),FI-AR, FI-AP, FI-GL, Controlling Project accounting mainly using standard extractors with customized and generic extractors.

·        Worked in  SAP APO(PP/DS) and supply chain management.

·        Worked with CRM and extracted data from CRM data sources to BI/BW system.

·        Experienced in designing and maintaining Info objects, DSO’s, Characteristic’s, Key figure’s, Info sets, Multi Providers and Info cubes.

• Built  Business Warehouse Components like Extractors, Standard and Custom Info Cubes, DSO (Standard, Direct update and Write optimized), Info Set, Info Objects and Info Sources, Web reporting, Extraction, Transformation, DTP, Transfer Structures, Update Rules, Transfer Rules, Info Packages and Authorizations.
• Proficient in enabling, enhancing, delivering and activating standard Business Content, extending and enhancing according to the requirements, performing Data load management, Scheduling Process Chains, background scheduling, reporting agent, alert monitor, profile maintenance, process chains, event triggers and event chains.

·        Skilled in Extracting data from SAP R/3 system using LO-cockpit, CO-PA, CO-CA, FI-GL, FI-AP, FI-AA, FI-AR extractors.

·        Good knowledge of data models  such as Extended star schema and Star schema.

·        Performed extractions from SAP R/3 system to BW system using extraction queue’s and delta queue’s with the help of V3 serialized and un serialized updates.

·        Used flat files and other legacy data base systems to load data into BW systems using flat file interface or UD connect.

·        Used ABAP customer exits to enhance the data sources.

·        Used transaction codes such as CMOD and SMOD to write the user exits.

·        Performed performance tuning by creating Aggregates, Indexes, Compression and data partitioning within the Info cubes.

·        Extensively involved in migrating data from 3.5 to 7.0 environment.

·        Worked extensively on Bex analyzer, query designer, Web application designer , web reports and Xcelsius.

• Generated reports on Info Providers and Multi providers using Structures, Restricted Key Figures, Calculated Key Figures, Cell editors, Characteristic Variables, Text Variables, Formula Variables, Exceptions, and Conditions and Replacement  path.

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

·        Created Advanced Analytics speedometers and Interactive Metric trends to gauge the  performance of key Businesses and Display them as Dash Boards.

·        Created Hyper linked Web Intelligence using open document functionality.

·        Effectively used advanced reporting and formatting functions in BO reporting.

·        Proven record in creating complex reports by linking data from multiple data providers.

• Expert in Report Generation, Extensively worked on BEx analyzer, Query Designer, WAD, Ad-Hoc Queries, Conducted training on BEx usage for Business Users and Web training and new features to end users.
• Communicated effectively with Team members, developers, clients and end users in a diverse matrix environment.

 Skill Set:

 Data Warehouse: SAP NW 2004 BI, 3.5, 3.1C, 3.0B.

 Operating Systems: Windows XP/Unix.
 Languages: ABAP/4, HTML, SQL, and PL/SQL.
 ERP Packages: SAP R/3  4.7, 4.6C, 4.6B, ECC 6.0.
 Web Technologies: HTML, XML.

 Reporting Tools: BEx Reporting, Web Application Designer, Report Designer, Business      Objects (XI R2.1, 3.1), Web Intelligence (XI R2.1, 3.1), Info View, Crystal reports, Xcelsius 2008.

Professional Experience:

Life Technologies, Carlsbad, CA

Role: SAP BI/BO consultant.                                                                                                        May 10- present

Life Technologies is a global biotechnology company specializing in genetic research assays and custom solutions.

   Responsibilities:

·         Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.

·         Held meetings with business users in order to gather business requirements and prepared business blue print based on those requirements..

·         Extracted data  from data source 0CRM_OPPT_ATTR_I , for reporting on item master data such as partners, item type or status etc.

·          Built ODS 0CHM_ATTR for channel partner attribute and data was retrieved from 0CRM_CHM_ATTR for channel management.

·         Developed query 0CSAL_C01_Q0100 mainly display the activities that have been created in last 12 months either by brand owner company or by related channel partner companies.

·         Developed a query ZORQSC_ZSCNNM04_NN_05 to mainly help the business review the annual budget .

·         Developed query 0CRM_C04_Q0101, mainly to display expected sales volume by product.

·         Developed query 0CSALMC02_Q0102 to enable channel managers and channel partners to analyze sales documents that originate directly or indirectly from a quotation.

·         Built  infocube ZSCNNC05 to capture the Trade Promotion actual.

·         Developed  Infocube ZSCNNC10 to capture the fund postings occurring in the TPM system.

·         Loaded data into data source  0CRM_SERVICE_PROCESS_I from service order items.

·         Worked on the info cube 0CRM_PRI in order to analyze service orders and confirmations at item level.

·         Worked on multi cube 0CRM_MC03, which defined the way in which the  key figures in CO-PA in customer’s R/3 system are viewed from CRM marketing. The data is transferred from CO-PA to the multi cube.

·         Developed info cube 0CRM_QTIC which contains item information for service order quotations.

·         Extracted  data from data sources such as 0CO_OM_OPA_1 and  0CO_OM_OPA_2.

·         Created process chains and meta chains for periodic uploading of text data, master data and transaction data.

·         Created reports in the Bex analyzer using concepts like Inception- to- date, year- to- date and month- to- date.

·         Developed a  infocube ZSCNNC09 to manage the claims.

·         Created jump reports, where a query jumped  from a one report to other specific report, using a Concept called RRI.

·         Developed single and multiple dash boards and score cards using Business Objects.

·         Was involved in unit testing , Integration testing and regression testing of the reports.

·         Wrote test scripts to test different business scenarios.

·         Executed various test scripts.

·         Created Master/detail reports, cross tabs, charts and applied slice and dice, implemented different levels of hierarchies for drill techniques.

·         Created multiple test cases to test various scenarios.

·         Was involved and performance testing and load testing.

·         Experienced in generating Webi reports over various BEx queries and other BI objects such as infocubes etc.

·         Enabled dynamic report linking by passing Variables (prompts) between reports,
Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.

·         Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.

Environment: SAP Netweaver 04 (BI 7.0), ECC 6.0, CRM 5.0, MM, SD, Business Objects Xi 3.1, BEx Analyzer/ Browser/,BO Xi 3, SD, MM, FI /CO modules, Windows XP, SOL MAN 7.0, SCM 5.0.

Phoenix Technologies, Milpitas, CA.     

Role: SAP BI/BO consultant                                                                                                April 09 - feb 2010

                                                                                                                                                                                                                                                                                                                                                             

Designs, develops and supports core system software for personal computers and other computing devices. Phoenix's products commonly referred to as BIOS (Basic Input/ Output System) or firmware support and enable the compatibility, connectivity, security and management of the various components and technologies used in such devices. Phoenix Technologies and IBM developed the El Torito standard.

Responsibilities:

·         Participated in full life cycle implementation of SAP BW/BI.

·         Participated in user meetings to discus project concept, design, and schedule.

·         Customized InfoCubes for SD, PP, MM, FI-GL, FI-AR, and FI-AP modules .

·         Worked with Sales delivery and customer cubes such as 0SD_C01 and 0SD_C02.

·         Activated the data source 2LIS_04_P_MATNR(Manufacturing view from PP/PP-PI) and 2LIS_04_P_COMP (Component view from PP/PP-PI).

·         Extracted and loaded data to info cube 0PP_C10 (to analyze status of manufacturing orders),0APO_C02  to analyze the order data.

·         Extracted and loaded data into info cube 0LCS_C02 to analyze the order fulfillment status, the key figure used here was net value of fright.

·         Extracted data into info cube 0APO_C07 to analyze the overall demand planning, specially the planned sales quantities and sales values

·         Generated reports on multi cube 0APO_MC01(Plan/Actual comparison of production quantities) to compare the plan with actual production.

·         Extracted data  into info cube 0APO_C10 for analyzing sales orders, such as total sales quantities and the scheduled sales quantities.

·         Used multi provider 0APO_MP04 to provide the information about planned sales quantities and the sales values.

·         Performed Lo-cockpit extraction to extract the header and line-item data from SD module(Sales order 2LIS_11_VAHDR/2LIS_11_VAITR).

• Enhanced transaction data source 2LIS_11_VAHDR, VAITM, 2LIS_13_VDHDR, VDITM.
• Worked extensively in SD module, by extracting data from data sources like 2LIS_01_S005( Shipping point), 2LIS_01_S264 ( SD offer).
• Created custom data sources for Service Entry and Purchase Order history information.

·         Experienced in peformance tuning of Infocube and also improved the query performance.

·         Ran reports on the infocube 0PP_C13 for comparing the available capacity with target capacity requirements.

·         Used the Multi provider  0IC_MP04 to  check the material and stock movement across various production units.

·         Ran a query 0SD_C01_Q024  to analyze the amount of incoming orders in relation to the amount of open order.

• Created and maintained CO-PA data sources at SAP R/3 level  and extracted data into Consumer, Goods, Industry, and Financial Key Measure info cubes after creating transfer rules, Info packages and update rules.
• Managed & Monitored several data Loads and optimized the performance by adjusting Packet Size and data Selections.
• Created 12 queries based on calendar day, week, month, and year to obtain a variety of reports for AR overdue analysis, AR-DSO (Days Sales Outstanding), AR due date for net payment, details of AR line items, overview of Accounts Payable, Sales reports (Returns as per customer and month, fulfillment rates, and comparison between orders and returns), queries contained restricted and calculated key figures, filters, and conditions .
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created.
• Created Web I reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked In creating Variables, Prompts in web I.
• Extensively Worked in SAP Live Office to create connections between WEB I and Xcelsius Dashboards.
• Good knowledge Xcelsius components such as filters, Selectors, Label based menu.

·         Created several reports for Asset Balance, Asset Class Transfers, Asset History sheet, Intercompany Transaction, WIP Balance and WIP Aging reports using Bex Analyzer and published them into Net Weaver Portal creating iviews.

·         Proposed and created an “Asset Balance Comparison report” which gives the customer a side-by-side view of the Asset details for different depreciation areas in a single run on the Asset Class and Company code level.

     Environment: SAP BI 7.0, SAP ECC 6.0, FI/CO, SD, SCM 5.0, Business Objects Xi 3.1, Bex Analyzer, Query     Designer, SOL MAN 7.0.

Brown  Brothers & Harriman CO, Boston, MA.

Role: SAP BI/BO consultant.                                                                                                 Nov 08 – March 09

Is a very old privately owned bank, serving the people of America from a very long time. In addition to commercial banking facilities, the firm provides global custody, foreign exchange, private equity, merger and acquisition services, investment management for individuals and institutions, personal trust & estate administration and securities brokerage.

   Responsibilities:

·         Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.

·         Held meetings with business users in order to gather business requirements and prepared business blue print based on those requirements..

·          Extracted data from standard line item data sources like 0FI_GL_04 ( General ledger line item), 0FI_AR_04( Accounts receivable line item) 0FI_GL_07 ( general ledger sales figure data).

·         Extracted data from CO-PA data source 0C0_PC_PCP_01 to provide value cost components and deliver data for product costing header data and product costing ( cost of components).

·         Extracted data from data source 0C0_PC_01 in order to supply plan cost and actual cost of each product.

·         Worked with info cube 0CCA_C11, which contains  all costs and quantities on cost centers.

·         Did performance tuning by building aggregates, Indexes in the SAP BW infocubes.

·         Developed various SAP BW objects Such as ODS, Info cubes , Multi providers, characteristics, Key figures etc.

·         Enhanced various SAP BW data sources and created generic extractors using various ABAP programs.

·         Involved in migrating data from SAP BW 3.5 system to BI 7.0 system.

·         Heavily involved in extracting data from SAP R/3 system to SAP BW/BI system using various extraction techniques.

·         Generated various queries using SAP BI query analyzer.

·         Developed query 0FIGL_C01_Q0001_SCOR based on info cube 0FIGL_C01 to find  the ratio of product revenues to the average value of the fixed and current asset.

·         Extracted data from data source  0CML_CASHFLOW to determine the flow of money in consumer loan department.

·         Worked on query 0BADR_C04_Q0001 in order to display all the commercail real estate loans and their total losses etc.

·         Extracted  data from data sources such as 0CO_OM_OPA_1 and  0CO_OM_OPA_2.

·         Used ABAP routines in update rules and transfer rules to add new fields to the all ready existing info cubes.

·         Created destination tab to specify the exact storage location of the extracted data.

·         Created process chains and meta chains for periodic uploading of text data, master data and transaction data.

·         Created reports in the Bex analyzer using concepts like Inception- to- date, year- to- date and month- to- date.

·         Developed a query 0FIGL_C01_Q0050 based on info cube 0FIGL_C01, which helped displaying the debit and credit balances of G/L account for the individual posting period of specific fiscal year.

·         Worked with Query 0FIAR_C02_Q0001  based on the cube 0FIAR_C02 which helped to analyze the customer’s payment history.

·         Generated reports using replacement path mechanism.

·          Ran reports using payment query 0FC_MP21_Q001, which mainly gives an overview of returns information pertaining to particular company code, source type or the payment type.

·         Developed single and multiple dash boards and score cards using Business Objects.

·         Created Master/detail reports, cross tabs, charts and applied slice and dice, implemented different levels of hierarchies for drill techniques.

·         Experienced in generating Webi reports over various BEx queries and other BI objects such as infocubes etc.

·         Used SAP integration kit to connect various business objects tools SAP BI/BW environment.

·         Involved in designing Universe and migrating existing ad hoc ‘Crystal Reports Explorer 11’ to Web I.

·         Created single business  universe using data federator.

·         Defined BO Classes, Objects in the Universe and defined Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.

·         Enabled dynamic report linking by passing Variables (prompts) between reports,
Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.

·         Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.

Environment: SAP Netweaver 04 (BI 7.0), ECC 6.0, CRM 5.0, MM, SD, Business Objects Xi 3.1, BEx Analyzer/ Browser/,BO Xi 3, SD, MM, FI /CO modules, Windows XP, SOL MAN 7.0, SCM 5.0.

Chevron Phillips Chemical Company

Woodlands, TX

SAP BW Consultant                                                                                                                       Feb  08 – Nov 08                    

Chevron Phillips Chemicals provides full-scale petrochemical and polymer research including new catalyst development, product and process development, and commercial process support.

Responsibilities:

·         Gathered user requirements for analysis and reporting, performed AS-IS Analysis, identified gaps and created technical design documents.

·         Involved in customizing Info Cube supporting SD and PI modules including activation of transfer rules and update rules.

·         Created Multi Cubes to utilize the existing data of the basic cubes and enhance the reporting flexibilities.

·         Worked extensively in extracting data related to process orders from

·         Customized LO cockpit for extract structures to transfer transaction data from OLTP to BW.

·         Replicated source system in BW to made available SAP R/3 data source in BW system.

·         Designed and developed ODS objects to carry out a precise analysis of individual order.

·         Defined Transfer structure, Communication structure, Transfer rules and Update rules for ODS and Info cube.

·         Implemented a framework of templates, restricted key figures, calculated key figures and variables to implement common reporting structure.

·         Resolved Post-Production issues like rescheduling process chains, enhancing Info Cubes to meet user requirement etc.

Environment: SAP R/3 4.7, SAP BW 3.5, SD, PI and FI

     North Face Inc , San Francisco, CA.

     Role: SAP BI/BW Consultant                                                                                                    July 07 – Feb  08                                                                                                                             

                                                                                                   

The North Face INC, is an outdoor product company specializing in outerwear, fleece, and other equipments such as back packs, tents and sleeping bags. The company was trying to streamline its supply chain and for that  it needed a good insight into past and future trends in the sales. Thus they decided to implement SAP BW/BI 7.0, which helped in providing all the data necessary to study the past trends in the industry and helped the company maintain good balance between demand and supply.

Responsibilities:

·         Performed  extractions from SAP R/3 system or non SAP systems to SAP BI/BW system using different extraction mechanisms.

·         As part of existing BW team focused on Unit Testing, Integration testing, Extractor testing and enhancements.

·         Extracted  data from line item data sources like 0FI_GL_4, 0FI_AR_4, 0FI_AP_4 and 0FI_GL_7.

·         Used ABAP routines in update rules and transfer rules to  update fields in the info cube.

·         Used LO-Cockpit extraction for sales order data, the data sources used  for extraction were 2LIS
_11_VAHDR, 2LIS_11_VAITM (Sales Doc header/Sales doc item) and used extractors 2LIS_13_VDHDR for billing data.

·         Enhanced standard data source 0FI_AA_11 to provide Asset Transaction records at Posting Date, Document Level from the tables ANEK and ANEP filling through User-exit.

·         Developed the cubes ZFIAA_C11, ZFIAA_C12, and ZFIAA_C13 from scratch by adding several new fields based on the Info cubes 0FIAA_C11(Cumulative Movements), 0FIAA_C12(Annual-Delta) and 0FIAA_C13(Period values-delta).

·         Enhanced the Master Data Source structure for 0ASSET_ATTR_TEXT by appending several new fields from the tables ANLA, ANLB, and PROJ.

·         Designed documents for extracting the transaction type and billing type level data from the Sales Order Header/Item, Billing Header/Item data source.

·         Created info packages, DTP’S and transformations to load data into standard DSO’S and custom built DSO’S using the data sources like 0FI_AA_11, 0FI_A1_12.

·         Modified Update rules, transfer rules, update routines, and transfer routines as per client requirements. 

·         Used BW transactions like RSA1, RSD1, LISTCUBE to maintain BW objects and data.

• Worked on performance tuning using BI Accelerators, Creating Aggregates, and Indexes and setting Cache properties in RSRT.

·         Ran error DTP’S to rectify the false loads getting transferred to info cubes.

·         Used V1,V2,V3 updates to load data from data sources to the BW system.

·         Maintained extraction queue and delta queue efficiently.

·         Monitored all daily loads into the BW system.

·         Worked in the areas of modeling and administration such as install business content, creation and implementation of InfoObjects etc.

• Involved in creation of different types of reports such as year to date reports, monthly reports, quarterly reports and annual reports for sales analysis.
• Created RRI jump queries for drilling down to other queries and also for comparing with fluctuating data.

·         Improved query performance, using aggregates, compression, Indexing and partitioning techniques.

·         Analyzed ST03, BW Statistics to tune BW system and improve BW loading performance by 20% and BEx query performance by 50%.  Built aggregates and changed query cache modes to improve performance.

·         Used CKF’s , RKF’S, exceptions and conditions in query designer to design the queries according to user requirements.

·         Used  variables in BW queries.

·         Experience in using BO universe designing, Desktop intelligence, Business web intelligence, info views and business objects enterprise.

·         Created, organized , published and scheduled reports using CMC.

·         Created Master/Detail reports, cross-tabs, Charts and applied slice and dice techniques.

·         Developed single and multiple dashboards and scorecards using business objects.

·         Developed reports using business objects functionality like queries, cross tabs, Master detail and formulas etc.

Environment:- SAP ECC 6.0, SAP BI 7.0, BW 3.5, FI,MM,APO,CO , ABAP/4, Business objects, Bex Analyzer, Query Designer, Report Designer, and Web Application Designer.