BM&FBusiness Intelligence Analyst
Sep. 2000 - Apr. 2005Collaborator of 7Comm Informática allocated at BM&F (Bolsa de Mercadorias & Futuros) initially as a web developer and later as a Business Intelligence Analyst. Participated in a complete Data Warehouse project, covering the entire typical lifecycle, which included the initial phases of defining data sources and modeling analytical bases, creating data transfer and ETL processes, and delivering consolidated information through user reports. Developed web applications using ASP pages and COM+ components written in Visual Basic. > Definition of analytical data models and star schema models
> Creation of ETL processes using DTS packages
> Implementation of OLAP cubes and creation of managerial reports using Crystal Reports
> Implementation of cubes using Microstrategy 7.5.1 through the following modules: Architect, Office, Desktop Designer, Web Analyst, Administration
> Programming in Transact-SQL through stored procedures, triggers, and ad-hoc queries
> Developed an application in ASP pages and components used to make Microsoft OLAP cubes available to internal company users via a web interface