Sales Sap
Resume:
ROMA GILDA
****.*****@*****.***
4
PROFESSIONAL SUMMARY
. SAP BW/BI specialist with extensive knowledge attained over 7 years of
SAP consulting. Specializing in Data Modeling, Data Extraction, Generic
Extraction, Data Loading, Scheduling, Monitoring, LO Cockpit and BEx
Query.
. Experience in SAP BI 7.0/ BW projects for FI/CO, SD, and MM modules in
all phases of ASAP like Gap analysis, Blue-printing, Design
specification, Realization, Testing, Documentation and Production
Support.
. Sound knowledge about BW configuration from ECC and R/3 system, working
knowledge of SAP structures and Tables in ECC 6.0 and R/3 4.6C and 4.7
environments.
. Expertise in creating designs of custom extractors for modules like CRM,
SD, MM and FICO.
. Extensive experience on QTP, HP-QC
. Experience in creating ad-hoc queries
. Hands on experience on WEB IC applications
. Expertise in creating Generic Extractors
. Reporting: Expertise in BEx Analyzer, Query Designer, Web Application
Designer, Info-Set queries, Jump Analysis using RRI. Hands on experience
with Front-end Business Warehouse Components, which involved constructing
custom queries using Variables, Structures, Conditions and Exceptions,
Restricted and Calculated Key Figures.
. Experience in working on Crystal Reports
. 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.
. Created Jump Targets, Jump Sources for Jump Analysis using RRI (Report-
Report Interface).
. Created WEBI reports & Crystal reports and deployed them through Info
View with BW Universe as Source.
. Extensively used Calculations, Variables, Prompts and Sorted inputs,
Drill down, Slice and Dice, Alerts for creating Business Objects reports.
. Extensively worked on creating Workbooks included with Complex Excel
functions and VBA.
. Extensively Worked on SAP EP in Publishing Bex queries' and creating
Iviews
. Business Objects Reporting: Created Universes over Bex queries and Info
cubes of SAP BI using Universe Designer
. Extensively worked in INFOVIEW to create Web Intelligence, Desk
Intelligence Reports over the Universe Created.
. BW Transports: Involved in testing the extractors, data loads and reports
before going into production & transporting the BW objects from
Development to Quality and subsequently into Production.
. Good understanding in Project systems, attended training program for the
BI team provided by client
. BW Security: Possess a good understanding of the security constraints
necessary in the BW/BI environment. Have considerable knowledge in the
creation of authorization objects, roles and role groups. Assisted the
security team in establishing effective user authorizations.
. Excellent production support and debugging skills, experience is
resolving trouble tickets, monitoring loads, enhancements and change
requests.
. Excellent communication, team, interpersonal and judging skills, which
facilitate effective communication with other functional and technical
teams.
TECHNICAL SKILLS
Primary SAP-BI, BW, BPS. IP, Portals
skills
Secondary ABAP/4 and Web Technologies
Skills
ERP SAP ECC 6.0, ECC 5.0, 4.7, 4.6c
Reporting Business Explorer, WAD, Business Object, Cognos8
Tool
Database SQL Server 7.0, Oracle
Programming ABAP/4, Java, XML, HTML, Java Script
Languages
PROFESSIONAL EXPERIENCE
Client : Lexmark, KY Dec
2010- Present
Industry : Printers and Scanners
Role : SAP BI Analyst
Lexmark is an American corporation which develops and manufactures printing
and imaging products, including laser and inkjet printers, multifunction
products, printing supplies, and services for business and individual
consumers. The company is headquartered in Lexington, Kentucky.
Environment: SAP BI 7.0, SAP ECC 6.0, FI/CO, SD, MM, COPA
Responsibilities:
. Extensively involved in analyzing the BI statistic cubes and involved in
performance tuning of all the slow running reports in the production
environment
. Working on Production support for solving issues from the end users.
. Involved in many training sessions to help and to make the end client
understand the BI reports and its features.
. Extensively working on customized SD (Order to Cash OTC) reports specific
business requirements in various modules like Invoiced Order Reports,
Sales Shipment report, Sales overview report, Billing document report,
Top 10 Customers etc.
. Working extensively on SD Open sales Order report, which covers all
organization levels, delivery status, shipping figures in BEx analyzer.
. Coordinating and communicating with Business and SAP team for solving the
tickets
. Prioritizing the tickets from the business team and the SAP team
. Gathering requirements from the end users for developing the reports
. Working on Crystal Reports(BOXI, Info view, Business Objects)
. Working on combination reports of Crystal and SAP
. Working on SD & FI Reports (FAGLL03) and validating Reports from ECC to
BI
. Checking the data pulled into the Reports from the source system(ECC)
. Managing the whole data flow from ECC to BI and to the Reports.
. Expertise in publishing reports to roles and portal, broadcasting
workbooks, reports to end-users.
. Created Jump Targets, Jump Sources for Jump Analysis using RRI (Report-
Report Interface).
. Created WEBI reports & Crystal reports and deployed them through Info
View with BW Universe as Source.
. Extensively used Calculations, Variables, Prompts and Sorted inputs,
Drill down, Slice and Dice, Alerts for creating Business Objects reports.
. Excellent communication, team, interpersonal and judging skills, which
facilitate effective communication with other functional and technical
teams.
Client : PepsiCo, TX Jan
2010- Nov 2010
Industry : Food & Beverage
Role : SAP BW-BPS Developer/Tester
PepsiCo, Incorporated is a Fortune 500, American multinational corporation
headquartered in Purchase, New York, with interests in manufacturing and
marketing a wide variety of carbonated and non-carbonated beverages, as
well as salty, sweet and cereal-based snacks, and other foods. Besides the
Pepsi brands, the company owns the brands Quaker Oats, Gatorade, Frito-Lay,
SoBe, Naked, Tropicana, Copella, Mountain Dew, Mirinda and 7 Up (outside
the USA).
Environment: SAP BI 7.0, SAP ECC 6.0, FI/CO, SD, MM, COPA
Responsibilities:
. Extensively worked on QC, QTP for Defect Tracking, Organizing, Managing,
Planning and Executing the Tests.
. Conducted many training and Brown Bag sessions to help the end client
understand the SAP BI system and also to gather the requirements
. Worked with Plant Maintenance with conjunction to procurement data in ECC
6.0 sandbox
. Activated COPA business content Info cubes 0COPA_C01, 0COPA_C02 etc and
provided reporting solutions lilke sales volume revenue consumer sales
trend etc.
. Involved in Validating SD Reports(OTC).
. Published many Bex reports on Enterprise Portal. Also created the report
templates using the WAD ( web Application Designer)
. Activated new General Ledger line item, 0FI_AR_4 (Accounts receivable
Line Item), 0FI_AP_4(
. Created iviews in the portals and published reports for super users.
. Preparation of test plans, which specify testing overview, testing
approach, testing strategy, roles & responsibilities and scope of
testing.
. Involved in System Testing and Regression testing.
. Validating Project key members Reports, Expenditure Reports, Custom
Reports, and Trade Reports with ECC Reports.
. Logging defects and coordinating with the BW Production team for the
Defects.
. Reviewing the Test Scripts before sending to the business.
. Coordinating with CTS Team in India and assigning them jobs.
. Involved in Loading data from Legacy (Hewitt) to SAP ECC and then to BW
by scheduling process chains.
. Checking for the extracted data being loaded into BW using RSA3
Transaction
. Monitoring the Process chains using RSPC/RSPCM.
. Extensively worked on BEx Analyzer, Query Designer, WAD.
. Debugging the queries using RSRT from SAPGUI.
. Proficient in writing the test cases based on the requirements.
BPS Roles Involved
. Worked with Planning Areas, Planning levels, Planning packages, Planning
Functions
. Involved in AOP Planning using the web interface- G&A Cost center AOP
Planning
. Worked with Cost-Center planning and Sales & COGS Planning.
. Involved in planning and forecast for the employees promotion, salary
deductions depending on the previous data
. Involved in creating the planning area in BPS0 Transaction
. Coordinating with BPS Production team for logged defects
. Generating interfaces and planning using the Transaction BPS_WIF0
. Validating Planned Data in the Interfaces to the Master data.
. Involved in creating Broker Master Data, Broker Commissions and loading
it to BW
. Excellent communication, team, interpersonal and judging skills, which
facilitate effective communication with other functional and technical
teams.
Client : Verizon, NJ Jan
2009- Dec 2009
Industry : Telecommunications
Role : SAP BI Tester/Developer
Verizon are a leading provider of IT, Communications, Security & Network
Solutions to enterprises and governments around the world
Environment: SAP BI 7.0, SAP ECC 6.0, FI/CO, SD, MM, COPA
Responsibilities:
. Successfully implemented two full life cycle implementation including Gap
Analysis, Blue-Printing, Report Design and Development
. Extensively worked on QC, QTP for Defect Tracking, Organizing, Managing,
Planning and Executing the Tests
. Experience with WEB IC Functionality
. Coordinated with offshore to develop Analytics and reporting queries and
help understand the business requirements. Successfully made the
transformation for the Process Automation division to move from the
legacy system (MACPAC) to BI reports
. Worked extensively with FI reports like, Pulling ECC Sets Hierarchies
(GS03) into BI (using tcode BW07) for the Income statement reports and
balance sheet reports
. Created many test cases and test scenarios for Unit testing, Integration
testing of many BI reports.
. Created many complex and customized SD (Order to Cash OTC) reports which
specific business requirements in various modules like Sales Shipment
report, Sales overview report, Billing document report, Top 10 Customers
etc... Using Bex Query Designer etc...
. Created complex Procurement Procure to Pay (P2P) reports like invoice
variance, purchase orders, ordering activities, average delivery time,
vendor evaluation
. Activated P2P, SRM Infocubes purchasing data (0PUR_C01), vendor
evaluation (0PUR_C02) etc.
. As a part of Production support involved in Debugging and monitoring load
failures, solving the high priority tickets from HP Quality centre, Delta
loads, planning ECC Outage for filling up of setup tables for Logistics
(LO) extractors, Minimizing the Init load and setting the v3 jobs, loaded
XML data into BI, etc...
. Involved in monitoring the performance of the system and reporting which
includes performing OLAP
. Cache, Aggregates, Indexes, Archiving the non cumulative info cubes,
Partitioning, etc.
. Worked extensively on Data Modeling design like creating InfoObjects,
InfoCubes, DSO, MultiProviders, Info Sources, Infoset, time dependent
master data and also in ETL (Extraction, transformation and loading)
activities like Extraction from Source system, Transformation rules, Data
Transfer
. Process (DTP), Open Hub service etc. Also involved new features of SAP BI
security like Analysis authorization
. Extracted inventory management data using the update marker in the info
cubes
. Developed many complex ABAP enhancement like User Exit Functions, ABAP
enhancements in ECC-BI CMOD, Generic Extractions and also in BI data
modelling like Start Routines and End Routines
. Designed and created many process chains to automate the data load and
data target administration
. 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,Crystal
reports 2008, and Xcelsuis
. Implemented analytics across the organization and used tabs on company
performance via flexible management dashboards and scorecards and
implemented index awareness
. Developed input ready plan queries in Planning functions in IP
environment as per user requirements
. Worked on Planning modeler, planning function and designing data flows
for virtual providers.
Client : Mylan Laboratories Inc, PA
Nov 07-Dec 08
Industry : Pharmaceuticals
Role : BI Consultant
Mylan labs is one of the world's leading generics and specialty
pharmaceutical companies, providing products to customers in more than 140
countries and territories. The company ranks among the top five generics
companies in several markets around the world and is the largest U.S.-based
generics manufacturer in the world.
Environment: SAP BI 7.0, SAP ECC 6.0, FI/CO, MM, CRM
Responsibilities:
. Set up source systems to load both SAP ECC and Non-SAP Transaction data
to BI
. Worked on activating procurement Procure to Pay (P2P) business content
datasources like purchasing 2LIS_02_S012, purchasing groups 2LIS_02_S011,
vendor evaluation 2LIS_02_S013, and Vendor evaluation 0MM_PUR_VE_01
purchasing data 2LIS_02_SCL.
. Worked on APD tool set to make analysis with integration of CRM business
process
. Worked on extensively procurement P2P reports purchase orders, invoice
variance, fullfilement rate etc.
. Worked on Standard Line item data source like 0FI_GL_4( General Ledger
line item), 0FI_AR_4(Accounts receivable Line Item), 0FI_AP_4( Accounts
Payable Line Item)
. Used ABAP Routines (in ECC/ BI Start Routines, End Routines) in
transformation rules to update characteristics and Key Figures in the
Info Cubes
. Created Infospokes to transfer data from SAP BW using open hub
destination
. Provided analysis authorization to the provide security features.
. Managed and monitored several data loadings, Debugged the errors to
identify the bugs and suggested several OSS notes for the errors
encountered while loading the data
. Extensively worked on ETL activities, activated transformation rules, and
scripted extraction routines for master data, texts and hierarchies.
Extensively involved in transportation, developed queries using filters
. Created process chains to automate the data load and data target
administration
. Published the Queries in Portal as views on their respective Folders
. Developed real time info providers BW IP planning
. Deployed Input ready plan queries(IP) as per user requirements in
planning modeler
. Implemented various BI IP scenarios Sales and Budgeting Planning
. Extensively involved in analyzing the BI statistic cubes and involved in
performance tuning of all the slow running reports in the production
environment
. Involved with performance tuning of queries by maintaining BI index,
Rollup, aggregates and Change run of BI accelerator, partition of info
cubes and actively involved in maintenance of OLAP CACHE for specific
queries using the reporting agent and the transaction code RSRT
. Extensively worked on query development (PTP )and formatting techniques
in both BEx and Web Application Designer(WAD) of key BW reports and
created Web Templates
Client : GH Group, NY March
07-Oct07
Industry : Health Care
Role : BI Consultant
Grey Healthcare Group is a global healthcare communications company, It
works with companies to build world-
class healthcare and pharmaceutical brands among medical professionals and
consumers, with a transmedia storytelling approach that covers print,
digital and television broadcast media, medical education, sales force
presentations and manages access strategies.
Environment : SAP ECC 6.0, SAP BI 7.0, WAD, BEX Analyzer, ABAP/4, FI/CO,
SD, MM, CRM, SEM, Net weaver 2004, Windows XP.
Responsibilities:
. Involved in full life cycle implementation, covering all the phases like
Requirement gathering,
. Blue Printing, Realization, Go-live and Post Go-live support.
. Implemented SAP BW/BI 7.0 for SD, MM,FI, and CRM modules and expert in
designing data flow from R/3 to BW/BI system.
. Worked extensively on standard and custom defined LO extractors. Used LO
extract structures and data sources in sales material management to
facilitate the data extraction to BW/BI system.
. Analyzed the PP info cube and ODS objects to meet the reporting needs of
the client.
. Extracted the data from Production orders and Process orders to analyze
manufacturing orders.
. Developed custom Overhead Cost Controlling cubes to split the load from
Costs and Allocation cube 0COOM_C02 to increase the performance.
. Enhanced the 2LIS_02_ITM extractor to pull the purchase conditional data
and load it to the customer cube as per the user requirements.
. Perform the setup table runs, clean Delta Queues, complete pending back
ground jobs and full loads as a part of go live presentation.
. Enhanced the standard master data extractors 0COORDER_ATTR and
0WBS_ELEMT_ATTR to add the new fields TPLNR and AUART.
. Extensively involved in performance tuning of the info cubes by using
Aggregates, Indexes, Partitions and Compression techniques.
. Expert in Data modeling techniques like Transformations, DTP'S, Data
migration, ODS objects and structuring the info cubes as per the
requirements.
. Created aggregates for faster data access using BW proposals from
BW_AGGREGATE_PROPOSE.
. Extracted data from data sources 2LIS_02_LTM, 2LIS_02_SCL, 2LIS_03_SI94
and populated this data into procurement 0PUR_C07, 0PUR_C08, 0PUR_C09 to
evaluate the service levels.
. Performed LO-Cockpit extraction to extract the header and line item data
from the sales and Distribution module.
. Extracted data from MM data source 2LIS_03_BF and PP data source
0PP_WCCP( work center capacity).
. Created reports like Confined Quantity and Item Purchase orders, Purchase
Order quantities delivered, Purchase order Values.
. Created few reports SD module extracting info on sales organization
levels, delivery and invoice status, shipping details and partner
function details. The data was extracted from VBAP, VBPA, VBAK, VBUP,
VBFA, KNA1, LIPS, VBRP, MARA,
. Developed Report for Material Availability list against the Orders, User
status of equipment And Equipment down list against PP extracting from
tables MARA, MARC, MARD etc with a download option into a excel file.
. Used RRI (Report-Report Interface) in order to get detailed information
about Sales orders (0SD_O01) and Order details (0SD_O03).
. Wrote reports in SD Open sales Order report, which covers all
organization levels, delivery status, shipping figures in BEx analyzer to
facilitate data analysis in a drill down or summarized way to give
detailed level of information.
Client : Fenwal Inc, IL
Jan06-Feb 07
Industry : Medical Equipment
Role : SAP BW Consultant
Fenwal Inc is a leading provider of products and services to the blood
industry from the collection, separation and storage of blood and blood
components to our new technologies for improving the safety and
availability of the blood supply.
Environnent : SAP BI 7.0, SAP ECC 6.0, FI/CO (Media Specific)
Responsibilities:
. Extensively involved in Gap Analysis in analyzing the legacy reports (for
e.g. Media reports like Title based reports, Overhead, Payroll etc
Debugged and Prepared the Functional Specification and its Corresponding
Technical Specification.
. Involved in many training sessions to help and to make the end client
understand the BI reports and its features
. Extensive experience in BI 7.0 Reporting in creating the queries and
workbooks by analyzing the
. functional specification
. Created many Proof of Concepts to help understand the requirement with
the Business and also to analyze the performance issues in the design
concepts
. Tested and Documented the Security levels of Analysis Authorization at
Multi Provider level, Info Object level and Hierarchy Node level (e.g.
Cost Center, profit Center etc
. Prototyped the Analysis Authorization security roles by creating Ad-Hoc
queries and workbooks and presented to the Business
. Published the Bex report's iViews on the Knowledge management folder in
the Enterprise Portal
. Worked extensively on the new features of Netweaver BI 7.0 Reporting tool
BEx Analyzer. Created queries using BI- Reporting variables (using Offset
values) for ITD (Inception to date), YTD (Year to date) and MTD (Month to
date)
. Documented the Bex Variables, Query and Workbook standards
. Transported Queries and Workbooks with their respective Roles from
Development to Quality System
. Created and developed many Queries and workbooks using General Ledger and
FS Version hierarchies like Trial Balance, Overhead reports, Title
reports (Media Specific) etc... using calculated and restricted key
figures, structures, variables, formulas, navigational attributes, jump
queries
. Developed Transactional Infocubes for the BW BPS/IP Planning
. Created BW based BPS/IP Planning environment architecture with planning
area, planning level and planning package and sequences
. Implemented BPS/IP scenarios for Sales Planning and budgeting
. Using Bex broadcaster, distributed the customized reports by region and
exported to the Enterprise portal
Client : OSI Pharmaceuticals, Inc. Long Island, NY
Nov04-Dec05
Industry : Pharmaceuticals
Role : SAP BW/Basis Consultant
OSI Pharmaceuticals is committed to shaping medicine and changing lives by
discovering, developing and commercializing high-quality, novel and
differentiated targeted medicines designed to extend life and improve the
quality of life for patients with cancer and diabetes/obesity.
Environment : SAP BW 3.5, SAP R/3 4.7 C, ABAP/4, MM, SD, FI BEx Analyzer,
Query Designer
Responsibilities:
. Involved in complete life cycle implementation of SAP BW.
. Maintained the liaison among the business analysts and the IT team to
gather the requirements for SD data modeling.
. Enhanced Business Content Data Sources as per requirements.
. Extracted Sales data using Logistics Cockpit (LO Cockpit) while
maintaining V3 update.
. Performed Delta Management of transaction data.
. Extensively worked on automation of BW processes through process chains
. Used tools like BW statistics for analyzing and optimizing the processes
in BW.
. Performed performance tuning for Info Cubes. Functionalities included
partitioning (Profitability Info Cube), maintenance of aggregates.
. Generated reports on Info Cubes and ODS objects for Sales Order, Sales
Billing and Sales Delivery data.
Client : Bajaj capital limited, India
Mar01-Sep02
Industry : Finance
Role : Jr.SAP BW Consultant
The company offers best investment advisory and financial planning.
Environment : ABAP/4, SAP R/3 Version 3.1 H, Oracle
Responsibilities:
. Understood the client requirement, prepared the technical specification
of the report requirements
. Created Interactive reports in SD module extracting info on sales
organization levels, delivery and Invoice status, shipping details and
partner function details
. Created an Interactive 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 the requirements
Educational Qualifications
Masters in Engineering - Fairleigh Dickinson University
Bachelors in Engineering - JNTU
Contact this candidate