Sap Bw Consultant Resume
Professional summary:
A total of 7 years IT experience, 5 years of experience as SAP BW Developer/Analyst.
2 Full project full-life cycles (ASAP methodology).
Post Production Support – Technical and Functional.
Extensive experience in Administrator Workbench, Business Explorer.
Data Extraction, Data Loading (Full /Delta Up-Load), ETL, Scheduling and Monitoring of daily loads.
Worked extensively with process chains.
Experienced in data Modeling, InfoCubes, InfoSource, Multiprovider, ODS objects, LO Cockpit.
Worked extensively with customized business objects and Installation of standard Business Contents.
Query and Data Load Performance Tuning using Aggregates & Roll-Up, Compression of an InfoCube, Indexes, Query read modes, Partitioning, Bitmap indexes and Data packet sizing.
Worked extensively with BEx Analyzer, and BEx Query Designer for developing reports, analysis and Web reporting using BEx Web Publisher,BEx Web Application designer and portal reporting.
Highly motivated, systematic, adaptive to new technologies and possess excellent interpersonal and communication skills.
Environments:
BW 3.1, 3.5, BI 7.0
R/3 4.6c, ECC 5.0, ECC 6.0, BEx Analyzer Oracle 9.2 Version 7.
Windows 98/2000/XP/VISTA
MS Project, MS FrontPage 2003, HTML, MS Share Point, MS PowerPoint, MS Excel
PROFESSIONAL EXPERIENCE:
Confidential,HOUSTON TEXAS April, 2008 – Current CAPACITY: SAP BW Consultant. Client: Confidential,Austin, Texas.ROLES.
- Involved in a Full life cycle project. ( Implementation of the FI module )
- Analyzed business requirements, performed Gap analysis with respect to the data model needs and available business content.
- Daily monitored delta data upload and troubleshooting where necessary. Create, modify and monitor process chains. Create and maintain ODS objects, InfoCubes, related InfoObjects, Transfer and Update rules of data extracted from FI and LO modules.
- Worked with Logistics,PM and FI Data Sources, tables, developed generic Data Sources and enhanced Data Sources where necessary.
- Develop queries, include the use of variables, restricted key figures, calculated key figures, conditions, exceptions, and used RRI to jump target for more granular reporting.
- Developed and modified web templates for portal reporting.
- Maintained Consistent InfoCube data validation by comparing with PSA data.
- Provided post production support to business users on how to use the BEx analyzer and interpret the contents of the data.
- Designed Data warehouse data flow (data modeling) and architecture based on functional requirement.
- Ensured data consistency and created technical specification for Customers specific requirements.
- Performed testing on Business warehouse/ intelligence objects before transport to Quality and production systems.
- Creation of Aggregates, Rollups, Compression and development of indexes where necessary to improve on performance.
- Creation of Transfer rules and update rules for InfoSources and InfoProviders
- Creation of Transformation and Data Transfer Process (DTP).
- Object migration from BW 3.5 to BI7.
- Involved in complete life cycle implementation of SAP BW using ASAP methodology.
- Participated in project reviews with business analyst and various LOB (Line of business) users, understood and implemented functional requirements as intended for performance enhancement.
- Analyzed the requirements and identified the suitable business content for FI/COand had the standard InfoCubes, DSO’s, and various other relevant objects installed and activated.
- Involved in testing the extractors, data loads and reports before transporting into production.
- Used Process Chains to automate data load processes, maintaining BW statistics, rollup of BW aggregates.
- Extracted Master data and Transaction data from SAP R/3, ECC 6.0 for FI/CO modules.
- Created extract structure to send CO-PA data from SAP R/3 system to BW system.
- Extracted data using CO-PA (cost or account based) for analyzing the data on various criteria/partitions like cost centers, companies, controlling area, regions to compare cost of sales or overhead costs, product costs.
- Created InfoPackages for uploading the master and transaction data.
- Extracted data(open invoices) from legacy system into SAP BW in flat file format
- Created and maintained Process chains for daily delta loads.
- Worked on performance related issues by Creating Aggregates & Roll-Ups, Compression and Indexing.
- Worked extensively on query performance, using OLAP caching.
- Worked on Query Design including Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions, and Variables.
- Also involved in the post production support, which required training of end users.
SAP Module: FI/CO, SD, MM.
Confidential,Austin, Texas August, 2003 – November, 2004
CAPACITY: Accounts Payable/Receivable Clerk.
- ROLES:
Responsible for maintaining accuracy of Journal Entry into the general ledger
Utilization of accounting system for asset inventory purposes.
Filledservice request from customers.
Working knowledge of automated A/P, A/R systems.
Resolving Invoice and Billing disputes
Built relationships and communicated daily with customers,
Created, entered and invoiced customer orders through SAP
Verified that vendor numbers, addresses, invoices and amounts correspond with the invoices that are entered for payment
Monitored backlog by following up and tracking products owed to customers, expedited orders, verified pricing, and provided samples to customers.
Provided weekly reports to management and communicated daily requirements to team leads
Monitored customers accounts and resolved outstanding issues while working closely with the credit department
SAP FI general ledger accounts: expense and revenue maintenance.
SAP FI accounts payable and receivable maintenance: setting up tolerance for customers and vendors, customer and vendor master records creation.
Cleared open and incoming payments and posting of partial and residual payments in an invoice.
Used various reporting tools to pull data for analysis of various cost centers performance and Developed reports using Business Explorer.
Interfaced between company accounts department and technical team, in developing effective and efficient accounts management system that meets the company’s requirements.
Participated as a team member with end users and SAP BW Developers in Full Life Cycle implementation of SAP BW 3.0, SAP R/3, employing
- ASAP methodology.