Business Intelligence Consultant

Activities:

- Project Management
- Working Group Leadership
- Systems Analysis
- Software design and development of BI
- Consultant Data warehousing.
- Consultant Business Intelligence
- Business Objects suite Instructor (Crystal Reports, OLAP Intelligence, Voyager, Web Intelligence, Set Analysis, Data Integrator, Business Objects Enterprise, Designer, Xcelsius)
- Microsoft tools instructor (Analysis Services 2000/2005/2008, SSIS 2005/2008)

Knowledge Areas:

- Functional Analysis in BI projects.
- Develop of general BI applications, specialized in SAP Business Objects (platforms: 6.0 / 6.5/9/10/XI R1, R2, R3.0, R3.1, BOE R4).
- Database design for general purposes.
- Database design Data Warehouse purposes.
- ETL tools (Business Objects Data Integrator/Data Services, DTS - MS SQL Server 2000, SSIS - MS SQL Server 2005/2008)
- Multidimensional database design (OLAP-MSAS 2000/2005)
- Database administrator (DBA) (Oracle 8i/9i/10g/11g), MS SQLServer 2000/2005/2008)

Work experience:

Tech BI S.R.L. (Business Intelligence Consultant Company– December 2010 – present)

Title: Account Manager.
Activities: Tech BI SRL is a Business Intelligence company located in Rosario and Buenos Aires in Argentina, I work as Consultant, Account Manager, Senior Analyst, Technical and Functional Analyst, doing data warehouse tasks as well as implementing BI solutions. I work with users collecting data for the functional and technical design.

Projects:

Boston Consulting Group (BCG) (Multination Consulting Company, Boston USA)
Project: Business Intelligence System
Title: Account Manager.
Activities: Business Intelligence SAP-BO Enterprise XI R2 and SAP-BO Enterprise R3.1 environment administration. Server administration and configuration. Web Application server configuration. Security administration, Users and Groups maintenance. Audit administration. Analysis and implementation of new requirements. Web intelligence report development for accounting, Human Resources, project and administration areas. Universes administration.
Design and implementation of Oracle Database. Model and implementation of data warehouse for Project administration. On demand resolution for end-users. (Security problems, issues with reports, help with report development).
Migrate Business Objects Enterprise XI Release 2 to SAP-BO Enterprise XI R3.1. Requirement analysis, environment analysis, installation and configuration of the new BOE XI 3.1 environment. Migrate the entire environment to the new BO server. Resolve issues after migration.
Manager of a BI Team for implementing new requirements. Daily tasks include BO Enterprise administration, End-User Support, participate in meeting calls with BCG employees where new requirements are analyzed or modifications are discussed. Universes administration.


Velocity Partners (Technology Multinational Company – September 2010 – December 2010)

Title: Senior SQL Developer.
Activities: Prepare environment for new requirements. Load and data modifications. Database model modifications. Creation and tuning of queries. Package implementation in the production environment and process change monitoring. Find problems resolutions and implement improvements. Daily process maintenance and documentation. Store Procedures development in MSQL Server 2005/2008.


Hewlett Packard Argentina (Technology Multinational Company – May 2009 – August 2010)

Title: System Database Administrator.
Activities: System DBA. Worked with Oracle 9i, 10g y 11g in Unix and Windows environments. Also worked with SQL Server 2000 y 2005.
I was part of the System DBA group giving Support to General Motors and GMAC accounts.
Scope: Database Administration. Database Installations. Installation and tests of start-up/shutdown processes. Database software installation. Backup definitions (Schedule and configuration). Administrate users, groups and profiles. Maintenance of DB files. Tuning tasks. Implement changes analyzing the environment impact. Resolve issues in the DB. Database Restore. Install patches


Crystal Solutions SA (Business Intelligence Consultant Company – April 2007-May 2009)

Title: Senior Analyst
Activities: Crystal Solutions SA is a Business Intelligence company located in Buenos Aires and Rosario in Argentina. I worked as Consultant, Senior Analyst, Technical and Functional Analyst. I developed Data warehouse tasks, survey with end-users, build of functional and technical designs. Work with different database engines (SQL Server, Oracle) and everything related to construct a Data warehouse or create the environment to be ready for the BI exploitation, using DTS, jobs, Cubes.
Work with Crystal Reports, Olap Intelligence, Web Intelligence, Crystal Xcelsius, Voyager, And Live Office Designer.

Projects:

TSTT (Telecommunication Company, Trinidad & Tobago)
Project: Business Intelligence System
Position: Senior
Activities: Design and Implementation Database (Oracle), Design Models, Design Extraction, Transformation and Load process.
Scope: Data warehouse design and implementation of consolidated information covering different transaction systems. Using the tools of SAP Business Objects Data Integrator (Data Services).


British American Communication (Telecommunication Company, Bahamas)
Project: Business Intelligence System
Position: Senior
Activities: Design and Implementation Database (Oracle), Design Models, Design Extraction, Transformation and Load process. Design the users front-end.
Scope: Data warehouse design and implementation of consolidated information, deployment of reports and scorecard. Using the tools of SAP Business Objects Data Integrator (Data Services), Crystal Xcelsius 4.5, Web Intelligence and BO Enterprise XI R2.





Viva Nuevatel (Telecommunication Company, Bolivia)
Project: Business Intelligence System
Position: Senior
Activities: Design and Implementation Database (Oracle), Design Models, Design Extraction, Transformation and Load process. Design the users front-end.
Scope: Data warehouse design and implementation of consolidated information, deployment of reports and scorecard. Using the tools of SAP Business Objects Data Integrator (Data Services), Crystal Xcelcius 2008, Designer, Web Intelligence and BO Enterprise XI R3.

Corpei (National Agency, Ecuador)
Project: Business Intelligence System
Position: Senior
Activities: Coordination of the implementation team. Building the technical design of the budget model of the company.
Scope: Design and implementation budgeting model on SQL Server 2000, 2005 and 7.0 databases. Deployment with Crystal Planning 4.05 as application. Provided training and support.


Codetel (Telecommunication Company, Republica Dominicana)
Project: Business Objects Training
Position: Senior
Activities: The trainings were for BO Enterprise R3.0 security and administration, Designer and Web Intelligence. Special training in Data Integrator adjusting the needs of the client.

Terminal 6 (Leader in processing and export of cereals and oilseeds, Argentina)
Project: Business Intelligence System
Position: Senior
Activities: Technical analysis and Functional analysis, design and building several reports for the analysis of in/out of trucks from Terminal 6.
Scope: development of web Intelligence´s reports and universes (Designer)

Paladini (Leading company in the production of cold meats, sausages and pressed meat, Argentina)
Project: Balance Scorecard
Position: Senior
Activities: Functional Analysis, Design and Implementation Database (MS SQL Server 2000), Designing Models and Schemas Data warehouse, Extraction Process Design and Transformation, design the users front-end
Scope: Data warehouse design and implementation. Applications for end users: Balanced Scorecard (Dashboard and Performance Manager), OLAP Intelligence, Web Intelligence reporting, Crystal Report. Development SAP Business Objects XI.

Bimbo (Global Market leader in Bakery, Argentina)
Project: Business Intelligence System
Position: Senior
Activities: Design and implementation of database (SQL Server), design and implementation Extraction, Transformation and Load (MS DTS) process, design the user front-ed.
Scope: Solution design and implementation of simulation of different deployment scenarios, taking accounting information. Using tools like Crystal Planning, SAP BO Xcelsius 2008, Live Office and Web Intelligence.

La Virginia (Industry´s leading Coffee and Tea, Argentina)
Project: Business Intelligence System
Position: Senior
Activities: Several projects of short duration development with MSDTS, MS Cubes and Crystal Reports. Development SAP Business Objects XI.

Naranpol (Bottler and distributor of beverages, Argentina)

Position: Senior
Project: SINA
Activities: Implementation of database (SQL Server 2005), Implementation Process Extraction, Transformation and Load (SSIS 2005). Microstrategy report development.
Scope: Production Datamart implementation. Using the tools of the suite of Microstrategy 8.1.2 to exploit the data mart.



Bolsa de Comercio de Rosario (Leader in processing and export of cereals and oilseeds, Argentina)

Project: Business Intelligence System
Position: Senior
Activities: Functional Analysis, Design and Implementation Database (SQL Server 2000), Designing Models and Schemas Data warehouse, design Extraction, Transformation and load process, design the users front-end.
Scope: Dashboards and applications designed for operational areas: Management Control Panels, Special Analysis. Development SAP Business Objects (CRS, Crystal Reports, OLAP Intelligence).

Sociedad Austral de Energía S.A. (Energy Supplier Company, Chile)
June 2010 – August 2010.
Project: Upgrade Business Objects Platform
Position: Senior
Activities: Upgrade version performed of the suite of products from SAP Business Objects XI R2 to XI R3.1 (SP3), Data Services 3.2. Also it was done a change of data source FI CO, for reports and dashboards (Xcelsius 2008 and Live Office) to finance, from SAP ERP. Upgrade version performed of the suite of products from SAP Data Integrator XI to SAP Data Services.

Technical Training: Data Integrator, Crystal Reports, Business Objects Enterprise, Web Intelligence, Designer

Denovedades.com (Data entry administrator – February 2007 – April 2007)

Title: Load Administrator.
Activities: Web search page
Scope: Load tool Administrator.

Elepe Servicios SRL (Consulting – December 2006 – February 2007)

Title: Trainee.
Activities: IT Consultant Company.
Scope: Work with AS 400 y PL. Programming in PL.