Post Job Free
Sign in

Sales Data

Location:
Puebla, Mexico
Posted:
August 15, 2014

Contact this candidate

Resume:

Name Belinda Dominguez

Email *******.******@*****.***

Mobile 484-***-****

6th October 1982

Birth Day

Nationality Mexican

Willing to Move Yes

Visa TN1

Education

Bachelor Degree in Business Iberoamericana University Dec 2005

Administration

Languages

Spanish Mother Tongue 100%

English 90%

Certifications

SAP BW 7.1 Integration with BI 4.0 2013

SAP HANA 1.0 2012

Professional Summary

• As a former consultant with Savantis Group I have worked with new tools such as BW 7.4 on HANA 1.0

revision 80 for a project with Merchandise Planning. As a leader of the project with a new tool, I deal with

different issues like product improvements, tool ad equations (configuration), training user documents,

SAP developers testing work.

• SAP Senior Consultant in Business Intelligence tools, having a major experience with SAP BW followed

by a strong knowledge in BO front end tools (Webi, Explorer, Information Design Tool) also a year of

experience with SAP HANA tools (SLT, HANA Studio). Overall I am a senior consultant who looks up to

learn new technology and gain experience on it.

• I have 6 years of professional experience with SAP BW a year with SAP HANA and three years with BI

tools. I’ve worked in 9 Full life cycle implementations, 8 Rollouts and Production Support.

• I’ve been working with HANA modeling and SLT extraction scenarios for two POCs and 1 production

project.

• Had an active participation in discussions at SAP Walldorf Germany and presentations based on best

practices. Analyzing and solving issues reported by SAP consultants currently engaged in HANA

projects at customer sites. Attend lectures followed by hands-on training exercises to gain more in-depth

knowledge of HANA modeling.

• I have given HANA teachings to new interested consultants from different partners and also to new

customers.

• I also gave a conference in SAP FORUM 2013 about BI Mobile to more than hundred attendances.

• Review How-To Guides to ensure accuracy and compatibility with newer releases of software

applications.

• Experience building universes for reporting with Webi and also Explorer as a front end reporter.

• Good experience in configuration and testing of BW for BPC.

• Extensive experience in Blueprints, Configuration, Unit, Stress, Volume, Regression, User Acceptance

and Integration Testing, Training, Data conversions, Data Migrations, Documentation and Production

support.

• OLTP Extraction from SAP R/3 into BW using different extraction structures such as LO, CO-PA, FI-SL

and Generic Extractors along with flat file extractions of Data from third party systems using

methodologies like DB Connect, XML uploads and carried out transports to staging and production

environments.

• Extensive experience in developing specifications for Interfaces, Custom Reports, and ABAP code for

Routines.

• Designed and Customized InfoObjects, InfoSources, Created transfer structures, transfer rules, update

rules, DTP, and Transformations, Routines for DSO, InfoCubes.

• Carried out Transport to staging and production environments, data transfer using Open Hub Services

(OHB)/Info Spokes.

• Involved in the production support, Scheduling Start Process and Process Chains of Events, Data

source Enhancement, Remote Cubes, MultiCubes, Data Mart and Open Hub Services, fixing errors and

daily ETL Data load (Full/Delta up-load) Monitoring of the BW jobs and designed Process chains for

Daily, Weekly, Bi-Monthly and Monthly data loads.

• Configuration and administration of Info spokes (OHS) for external DW Systems.

• Expertise in Report Generation as per user requirements using BEx/WAD/Business Objects such that

the execution time is evenly distributed throughout the report by using free characteristics, Restricted

key figures, Calculated key figures, Variables, formula variables, Exceptions and Conditions.

• Good knowledge in ABAP debugging techniques to work with user-exits, routines and BADIs.

Worked on Non SAP Systems Using DB Connect, UD Connect and involved in Extraction configuration.

Activation, enhancements & Installation of Business Content for SD, FICO, MM, and QM, CO-PA, CCA.

Extensive experience in implementation and configuration of SAP FI/CO modules- GL, AP, AR,

Customer Master, Vendor Master, Fixed Assets, Controlling Area, Cost element & groups, Internal Order,

Cost Center Accounting (CO-CCA), Cost center Profit center Accounting(CO-PCA) and Profitability

Analysis(CO-PA) as source systems for BI/BW.

Developed flexible queries using filters, navigational attributes, variables, Cell Editor in Bex analyzer to

facilitate data analysis in a drill down or summarized way to give detail level of information

Knowledge in identifying, testing and documenting of SAP application controls in compliance with ASAP

methodology in SOLMAN.

Good team handling experience which I came across from Associate consultant roles to technical team

lead.

Excellent communication, team leadership, and interpersonal skills.

JUMP PROJECT (2014)

Duration: 3 months

Industry: Retail

Project: SAP BI for CRM

Role: SAP BI Senior Consultant

Responsibilities:

Developed Webi reports with Web Intelligence, configured custom variables, analyzing reporting

requirements, developing detailed reporting specifications. Thorough understanding of the Functional

specifications and outstanding issues related to specifications.

Created universe layer to translate from DB tables and field terms to final business user understanding.

MERCHANDISE PLANNING ON HANA (2014)

Duration: 6 weeks

Industry: Retail

Project: SAP RDS Merchandise Planning

Role: SAP BW Senior Consultant

Responsibilities:

Activate developed data models, activate cubes, queries, planning functions, planning sequence,

aggregates, and adjust the model to the customer needs.

Extraction of the master data and transactional data from ECC, mainly stock, sales & purchasing

information.

Load 2 years of historical data & current year.

Prepared documentation and Data Flow design for the key users understanding.

COMPARTAMOS BANCO (2013)

Duration: 4 Months

Industry: Banking

Project: SAP BW Reporting with Bex

Role: SAP BW Senior Consultant

Responsibilities:

Developed BW reports with Query designer, configured custom variables and calculated key figures,

analyzing BW reporting requirements, developing detailed reporting specifications. Thorough

understanding of the Functional specifications and outstanding issues related to specifications.

Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing

reports based on various roles.

Created reporting authorizations and user profile maintenance.

LIVERPOOL (2012)

Duration: 3 Months

Industry: Retail

Project: SAP HANA Reporting with BI Front end Tools

Role: HANA team lead

Responsibilities:

Modified data models, attribute views, Calculation views and Analytic Views, according with the

customer new requirements, looking obtain more information out of the “Null Movement Items”. So they

could see also articles with sales prior to 2 years ago.

Extraction of the main inventory ERP tables to feed the tables in HANA Studio.

Modified filters while extracting data with SLT so we could get all the information.

Connecting Information Design Tool with HANA, applying the best practices so the report performance

were optimized.

Modified WEBI reports using the tool as a front end for all the reports.

Prepared documentation and Data Flow design for the key users understanding.

CHEDRAUI (2012)

Duration: 2 Months

Industry: Retail

Project: SAP HANA Operational Reporting

Role: HANA team Lead

Responsibilities:

Developed data models, attribute views, Calculation views and Analytic Views, according with the

customer requirements, looking to improve the performance of the main FI reports with SAP ERP.

Extraction of the main ERP tables (like MARA & MARC) to activate the business content in HANA

Studio.

Loading 9 millions of data records approximately to feed the required reports.

Connecting Information Design Tool with HANA, applying the best practices so the report performance

were optimized.

Building WEBI reports using the tool as a front end for all the reports.

The performance for the FI reports using HANA was improved, from one entire day to only few seconds.

Prepared documentation and Data Flow design for the key users understanding.

MODELO (2012)

Duration: 2 Months

Industry: Beer Production

Project: SAP HANA Business Content Reporting with BI Front end Tools

Role: HANA team Lead

Responsibilities:

Developed data models, attribute views, Calculation views and Analytic Views, according with the

customer requirements, looking to improve the performance of the main Inventory reports with SAP

ERP.

Extraction of the main ERP tables to activate the business content in HANA Studio.

Loading 9 millions of data records approximately to feed the required reports.

Connecting Information Design Tool with HANA, applying the best practices so the report performance

were optimized.

Building WEBI reports using the tool as a front end for all the reports.

The performance for the FI reports using HANA was improved, from one entire day to only few seconds.

Prepared documentation and Data Flow design for the key users understanding.

ITESM (2011 & 2012)

Duration: 4 Months

Industry: Education

Project: SAP BW for BPC

Role: BW Lead

Responsibilities:

Developed BW data models and designs, configured custom and delivered content BW objects,

analyzing BW reporting requirements, developing detailed reporting specifications. Thorough

understanding of the Functional specifications and outstanding issues related to specifications.

Frequent meeting with the functional team to resolve the outstanding issues and regular updating of

functional specifications.

Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing

SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert

knowledge of data warehousing concepts.

Developed basic Cubes.

Built various Multi providers on CO, Investments.

Extensively involved in setting up of procedures for extracting data from SAP R/3 by using generic

extraction.

Developed Infosources and Written several routines in Update and transfer rules.

Created extractors to extract CO-PA data for the relevant Operating Concerns from SAP-R/3 into SAP

BW and created corresponding Infosources, ODS Objects and Infocube in BW.

Designed and developed process chains (RSPC) for master data loads and transactional data loads

with the help of info packages. And these process chains are scheduled for periodically.

Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing

reports based on various roles.

Created reporting authorizations and user profile maintenance.

Created a Process Chain, which deletes the PSA Data based on the Retention Periods.

Used both initializations with delta update and Full update methods depending on the business

requirement.

Involved in transporting the BW objects from development system to QA for unit testing and integration

testing.

Transport the objects from Development to QA for testing.

MINERA MEXICO (2011)

Duration: 3 Months

Industry: Mineral Miners

Project: SAP BI (Webi Reporting)

Role: SAP BI Consultant

Responsibilities:

BI developer responsible for analysis, design of the front end reports according with the user

specifications.

Prepared project related documentation (functional design, technical design, test scripts) during the

different stages of a project.

Analyze and configure universes with the data model flows as needed for the reports. Designing the

optimal data environment to facilitate custom reporting and data analytics solutions.

Interact with business to gather requirements, prioritize work, develop enhancements to the existing

system, coordinate testing, and perform change management/training for Webi Reporting.

Perform analysis and design; write technical specifications; configuration and programming in the

SAP/BI environment, including testing and implementation.

Develop and drive the implementation of BI best practices and standards for the team.

Support the on boarding and training of BI Power Users.

CHEDRAUI (2009)

Duration: 13 Months

Industry: Retail

Project: SAP BW for SAP POS DM

Role: BW and POS DM Senior Consultant

Responsibilities:

Gathered and assessed customer requirements through interviews, questionnaires and Business Model

Blueprints

Worked with functional consultants for mapping the SD, FI and POS data onto the DataSources in BI.

Information from various sales docs (like customer orders, deliveries and invoices) were mapped from

SD area, various levels of detailed key figures were mapped to address the requirements of profitability

analysis, and information from general ledger was required for financial reporting.

Customized and maintained DataSources such as Purchasing, Sales Order and Delivery Order for the

SD model.

Worked on creating Aggregates, compressing InfoCubes, creating Indexes, MultiCubes and process

chains.

Created reports using BEx Analyzer, including Order and sales value by sales representatives, Sales-

order stock reporting, Balance sheet and Profit Loss using filters, restricted and calculated Key Figures,

variables, formulas, exceptions and conditions.

Create a generic data flow with routines so the comission rules were calculated in BW with the POS

incoming information.

COMEXTRA (2008)

Duration: 5 Months

Industry: Retail

Project: SAP BW

Role: SAP BW Consultant

Responsibilities:

Gathered and assessed customer requirements through interviews, questionnaires and Business Model

Blueprints

Worked with functional consultants for mapping the SD, PA, and FI data onto the DataSources in BI.

Information from various sales docs (like customer orders, deliveries and invoices) were mapped from

SD area, various levels of detailed key figures were mapped to address the requirements of profitability

analysis, and information from general ledger was required for financial reporting.

Enhanced Standard Business Content InfoCubes like Line Item, Payment History, Cost and Allocation

and in sales BCT ODS objects to include source system ID, time characteristics and harmonized

version.

Developed custom InfoCubes for General Ledger and Plan data (Balance sheet and profit loss), actual

and plan data for Profitability Analysis.

Customized and maintained DataSources such as billing, Purchasing, Sales Order and Delivery Order

for the SD module.

Created Multiproviders for data in FI and for calculating average value of sales order allocations in SD.

Worked on creating Aggregates, compressing InfoCubes, creating Indexes, MultiCubes and process

chains.

Created reports using BEx Analyzer and WAD that include Plan/Actual revenue comparison, Order and

sales value by sales representatives, Vendor delivery efficiency, Incoming Orders, Sales-order stock

reporting, Balance sheet and Profit Loss using filters, restricted and calculated Key Figures, variables,

formulas, exceptions and conditions.

Created Open Hub Destination Objects (InfoSpoke) to transfer data from standard Data Store Objects to

Flat Files.

Utilized DB connects Interface to extract data from SQL Server into BW system.

CIE (2008)

Duration: 8 Months

Industry: Entertainment

Project: SAP BW for IP

Role: SAP BW Consultant

Interacting with the Customer, Understanding Customer business requirements, analysis, technical

design, development and testing of various global templates

Data modeled for CO-PA, FI to get the account balances and transaction figures, which are key data

elements for the industry.

Developed a BW data mart for accounts information, which includes all operating expenses and

incomes transacted from 4 Legacy systems.

Designed 4 data models for the different industry branches, one data flow for standard objects other

data flow for custom objects and integrated into BW system. Activated and created the business content

objects and custom objects.

Developed real time Infocubes for IP Planning.

Applied ABAP code to restrict confidential Company Codes, GL Accounts, Vendor numbers, Cost

Centers and Chart of Accounts in the standard master and transactional datasources.

Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable

Exits to show the Invoicing amount of the respecting periods.

Developed queries based on client requirement. Used calculated key figures, formulas, restrictions,

conditions, Exceptions in the queries. Developed report-to-report interfaces, Published views on web.

Developed the Process Chain using ABAP code for automated extraction and loading processes based

on SAP BW events chain functionality.

Prepared the documentation on data flow design from two Legacy system, restriction, and filter of data,

Data Modeling, Unit Testing, User Training, and Report Designing objects.

Prepared the Cutover Activities documentation for Go Live.

Developed documentation, including functional requirements, test cases, test plans, test scripts

according company work instructions.

Developed reports using query designer, BEx analyzer and web application designer.

Configured use of restricted and calculated key figures in queries, structures, and variables.

Worked with Web Application Designer to create different templates.

Created Query for Technical Project Overview on Infocube.

Used Report Designer to publish the reports in portal



Contact this candidate