BS

Betina Schellemberg

available

Last update: 11.10.2018

BI Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional) | French (Elementary)

Skills

PSA                                                                                                          January 2012 – May 2018
ATOS for PSA                                                                                         June 2012 – To the present Technical and functional leader Analysis, design and implementation of reports in Business Objects XI release 2, 3 and BI4
Modeling Universes in Business Objects XI release 2, 3 and 4
Analysis and design of BDD (Oracle 10 and 11, DB2)
Analysis and design of ETL's (PL / SQL)
Migration of Universes and reports from Business Objects XI release 3 to BI4
Planning and allocation of resources
Hourly load tracking
Team coordination[BSS-U1] 
[BSS-U2]  IT Resources                                                                                   August 2011 – December 2011 Senior Functional Analyst Senior Analyst Business Intelligence
 
DirecTV
Analysis, implementation and design of Datawarehouse (Billing and Collection).
Analysis of cubes (IBM Cognos 8).
Analysis of ETL's (DataStage).
  Sofrecom                                                                                       September 2010 – August 2011 Senior Functional Analyst Senior Analyst Business Intelligence
 
Peugeot Citroen
Analysis, design and implementation of reports in Business Objects XI release 2.
Modeling of Universes in Business Objects XI release 2.
Analysis and design of BDD (Oracle 10)
Analysis and design of ETL's (PL / SQL)  
Altgerant                                                                                          October 2009 – August 2010 Senior Functional Analyst Leadership of implementation projects Oracle Standard Edition 1
 
Liderazgo de proyectos de implementación en Oracle Standard Edition 1
 
Jesús en el Huerto de los Olivos School
Analysis and design of ETLs, data model, metadata model and reports
 
Ferreyros (Perú)
Modeling of Cubes IBM Cognos 8. Design and implementation of Reports IBM Cognos 8. Training of FrameWork Manager
 
Mapfre (Perú)
Design and implementation of Cognos Reports 8. Security Implementation. Design of the Business Intelligence Portal
 
ILatina Business Services                                                             July 2008 – September 2009 Senior Functional Analyst Leadership of implementation projects IBM Cognos BI
 
Naldo Lombardi
Analysis, design and implementation of Cube of Movements (Sales, Purchases and Stock)
 
Manpower
Implementation of Cognos BI and Metrics (Balance Scorecard)
 
Global Mind
Implementation in Cognos BI for each of the Global Mind clients
 
DIARCO
Reengineering of the Sales model in Cognos BI (cubes)
 
Essen
Analysis, design and implementation of Cognos BI for the financial area.
 
Cervecería Quilmes
Training FrameWork Manager
 
Schneider Electric
Training: Report Studio, elementary and advanced
 
Sofrecom Argentina                                                                                   July 2007 – July 2008 Senior Functional Analyst Santander Río I participated in the Corporate MIS Project and those that are annexed to it.
  Analysis and design of the Datamart of Actual and Budgeted Expenditures.
Analysis and functional Design of ETL's to migrate the PeopleSoft Expenses (ABM) information to the designed base.
Design of Universes in Business Objects XI Release 2.
Design of Reports and Indicators in Business Objects (Web Intelligence).
Design of other Universes and Reports in Business Objects (Web Intelligence).
Analysis and Design of the Database and the BIG application (Management Information Base), for sending interfaces to Corporate
 
Caputo S.A.                                                                                      August 2006 – July 2007 Senior Functional Analyst  
Analysis and design of the Company's Datamart in SQL 2005.
Design of ETLs in Visual Studio (SQL 2005) to migrate information from the company's ERP (Informix) to the designed database.
Design of Universes in Business Objects XI Release 2.
Design of Reports, Indicators, Metrics and Analytics in Business Objects (Web Intelligence).
Maintenance of the Datamart (SQL 2005)
 
Jet Consulting                                                                                 May 2006 - August 2006 Senior Functional Analyst Telefónica de Argentina
I participated in the project to migrate the Special Products to the new Biller
 
Survey and functional specification of Interfaces necessary for Product 0800/0810 and Claims for Special Products.
 
Flow Technology                                                                             January 2006 – April 2006 Senior Functional Analyst Siderar
I participated in the project to certify in the Sarbanes-Oxley Law (SOX) in the Information Technology area
 
Survey of all interfaces between SAP and the legacies systems of the company
Functional specification of interfaces
 
TGV                                                                                                   March 2005 – December 2005 Senior Functional Analyst Advertmind S.A.
I participated in a redesign project of an ERP oriented to Media and Advertising Agencies in .NET
 
Task Tracking and Effort Estimation. Coordination of the work team
Survey of the different ERP modules
Functional specification in UML (Use Case Diagrams). Tool: Enterprise
Database Design Tool: Enterprise and Visio
 
Sofrecom                                                                                 November 2004 – February 2005 Senior Functional Analyst  
Transportadora Gas del Sur:
I participated in a reengineering project
Migration of ETLs designed in DataStage from Sybase to Oracle
 
Aguas Argentinas
I participated in a Business Intelligence project in Aguas Argentinas.
 
Design of Universes and Reports in Bussiness Object with information from the Water Analysis Laboratories
Design of ETLs in SQLServer to process information from Work Orders
Universe and Reports Design to obtain information and indicators from the Work Orders
 
Grupo ASSA                                                                                       January 2003 – October 2004 Senior Functional Analyst ARCOR
I participated in a Business Intelligence project at ARCOR – Córdoba City
 
Design of new reports at the request of the users. Design of ETLs in order to obtain information from the company's ERP (JDEdwards - OneWorld) with DataStage.
Training for Business Object users (Reporter, Designer and Supervisor).
Design of tables of the company's Datawarehouse with information from the JDEdwards -OneWorld.
Design of Business Object Universes in order to obtain indicators of company management.
 
Duke Energy
Training for Business Object (Reporter) to End Users and those who were going to perform the product administration (Designer and Supervisor).
Design of the Database (SQLServer 2000) with information to be provided to the Clients of the company (demand, consumption, prices, etc.).
Design of the application for manual data entry.
Design of the Business Objects Universe, in order to obtain information to be published in a Web of clients.
Design of interfaces with the Database.
Test of the interfaces and applications developed. Design of Reports for Customers in Business Object. These reports were published on the Clients Web. Design the reports for internal company information.  
MetroRED Telecomunicaciones                                                               1997 – 2002 Senior Functional Analyst I worked in the Information Technology area of ??the company.
 
Responsible for the analysis, customization, implementation and maintenance of the modules of Sales, Work Orders and Billing in OneWorld (AS400), allowing the systematization and integration of the sale, installation and billing of services.
Analysis, customization, implementation and maintenance of the Sales and Work Orders modules in Siebel (Oracle), replacing OneWorld and achieving the integration of these with Trouble Ticket (Siebel module for the entry of customer complaints).
Construction of the interface for data migration from Oneworld (AS400) to Siebel (Oracle). In this way, it was possible to have historical information in Siebel.
In order to systematize and integrate payments, collections, accounting and inventory management, I carried out the implementation, parameterization and maintenance of J.D.Edwards: Purchases, Inventory, Accounts Payable, Accounting and Fixed Asset Master (AS400).
Analysis and implementation of Business Object for telephone traffic analysis (EHPT - BMP), Sales and Billing. Through this implementation, the internal client was able to count on a tool to obtain all types of reports.
With the same aim, I made the development, implementation and subsequent maintenance of the data repository (Oracle) for Billing (EHPT - Progressor), Billing Mediator (EHPT - BMP) and Sales (Siebel).
Maintenance of the Budget System (SQLServer 7, HTML) and the Project Management System (SQLServer 6.5, Visual Basic), developed by contractors.
I obtained the MetroRED recognition, being a member of the President's Club Award in 1999, awarded for outstanding performance and commitment to the company.
 
Telefónica de Argentina                                                                                        1992 – 1997 Semisenior Functional Analyst In a first period, I belonged to the area of ??Microinformatics, later and until leaving the company, I belonged to the Management of Large Client Systems.
 
Analysis of sales processes, monitoring, installation of services and after-sales service of the Large Customers area, achieving the improvement thereof. This analysis was carried out with the Navigator systems methodology.
Analysis, development, implementation and maintenance of the Commercial Management Systems of Digital Direct Lines and Digital Telephone Access (Natural / ADABAS - Unix), achieving the systematization of the processes of sale and installation of these services.
Analysis, development and implementation of interfaces with the Billing System of the two aforementioned systems.
Maintenance and analysis of applications developed by third parties (SQLServer - Visual Basic).
For a brief period, support Windows users, Office and other applications.
  Siderca                                                                                                                     1991
Trainee HelpDesk
Installation and maintenance of computer equipment
 
STUDIES
  • Industrial Engineer
 
TRAINING
  • Supernatural (Siderca 1991).
  • Total Quality (Telefónica de Argentina 1992)
  • Instructor Training (Telefónica de Argentina 1993)
  • Professional Development Program (Telefónica de Argentina 1995/1996): Introduction to Negotiation, Marketing, Interpersonal Relations, External and Internal Customer Service.
  • AS/400 (Teknoda 1997)
  • Accounts Payable, General Ledger, Purchases, Inventory and Fixed Assets of J.D.Edwards (ASSA 1997)
  • Training for future Managers (MetroRED 1999)
  • Risk Management in Project Manager (IIR Training 2001)
  • Business Object Designer, Supervisor y Reporter (Grupo ASSA 2001)
  • Workshop Infosphere (IBM 2008)
  • Oracle Enterprise Edition I (Oracle 2009)
 
OTHER ACTIVITIES
  • Assistant Professor of Operations Research (Industrial Engineer U.B.A.) 1990 - 1991
  • Operations Research Professor (Instituto de Estudios Terciarios San Patricio) 1989 - 1990

 

Project history

No references

Local Availability

Only available in these countries: Argentina
Profileimage by Betina Schellemberg BI Consultant from BI Consultant
Register