Gustavo B. freelancer experto en Data Warehousing, OLAP, SQL Server, SQL

Gustavo B.

Business Intelligence Consultant

0 / 5

Valor hora:

USD 47,54

Programación y Tecnología

Habilidades (Máximo: 5)
Sobre mí
Application development in the area of: Business Intelligence, Data Mining, corporate Data Warehouses, and in general the creation of environments for the capture, storage and analysis of information for decision making.
Historia laboral
* Independent Consultant (Computer Software): Recent Activity:
• Sears Holdings: AIX Scripts to load the Pilot corporate dimensional model. IBM AIX RS6000. Perl. Troy, Michigan y Chicago, Illinois, USA (2006, 2012, 2013).
• Southern California Edison: Install and configure SAP SM System. Redhat. Oracle. Los Angeles, California, USA (2011)
• Service Birmingham: Custom Reporting System. SAP SM. Business Objects. Crystal Reports. Birmingham, England.
• City of Henderson: Custom interface and report development. SAP SM. Henderson, Nevada, USA (2010)
• New York Power Authority (NYPA): Custom development for alternate scorecard and initiative reporting and support to profusely comment data (2010).
• Swiss Post: Custom development for scorecard reporting, Initiatives Indicators, Timeline Charting. SAP SM. Switzerland (2009)
• SAP: Corporate Strategy Group (CSG) SAP Global internal corporate strategy development project. Custom development for scorecard reporting, KPI handling, entry and approval user communication, corporate structure hierarchy, etc. SAP SM. Cambridge, Massachusetts, USA (2007, 2008, 2009)
• Pacific Gas & Electric Company (PG&E): Include third party contents in the Operational Review reports. SAP SM. San Jose, California, USA (2007).
• Sears Holdings: Formulae metadata design to automate OLAP variable creation. 3K Formulas, 1 billion Kmart and Sears sales records. Perl. Troy, Michigan, USA (2007)
• Transnet: Extensive SAP SM customization. SAP SM. Johannesburg, South Africa (2007).
• Yahoo: Corporate BU Dashboard, corporate data collection and creation of key performance indicators (KPI) for the Balance Scorecard. DBA & BI Consultant. MySQL, Pilotworks, Perl. (2005, 2006). Sunnyvale, California, USA.
• Sears Holdings: AIX Scripts to load the Pilot corporate dimensional model. IBM AIX RS6000. Perl. Troy, Michigan y Chicago, Illinois, USA (2006).
• Microsoft Venezuela: Electronic banking and clearing house SQL Server consulting (2006). Caracas, Venezuela.

* Corporación Cipher (Computer Software) [desde 8/2005]: Projects:
• Microsoft Venezuela: Initiative Characterization System for PDVSA AIT (Part of the corporate EPM (Enterprise Project Management)). Server 2003, SQL Server 2000, Analysis Services, Visual Studio 2003 .NET, IIS 6.0 (2005). Caracas, Venezuela.
• Biggott: Management Information System (SIG). Intranet information portal to visualize the corporate financial profile: Key indicators, Balance, P&L, CAPEX, Headcount, Payroll Expenses, etc. 100 Reports. SQL Server 2000, MIS Alea, MIS onVision Web Servicies. (2005). Caracas, Venezuela.
• Telcel BellSouth: HR Budget and expenses analysis system. Extensive reporting, multiple scenario management. SQL Server 2000, MS OLAP, MIS Plain. (2003, 2004). Caracas, Venezuela.
• Procter & Gamble (P&G): Billing Services: Web application for the processing and visualization of the corporate phone usage consumption (300K monthly calls). Linux, PHP, MySQL. Caracas, Venezuela.
• West Indian Tobacco Co.: Caribbean Area Planning, Production planning, raw material handling, sales and exportation projector. Visual Basic 6.0. 2003-2005. Port of Spain, Trinidad.
• Citibank Venezuela: HR Budget management, 2001 forecast, multiple scenarios. Oracle, VB, SQL Server, Accrue Pilot, 2002, 2003. Caracas, Venezuela.
• Citibank Venezuela: Analysis of Pay link and Corporate accounts (RM). Transactional flow of products, balance and average balance, NY DDA USD and Finance Control. Cosmos, VB, SQL Server, Accrue Pilot. 2002. Caracas, Venezuela.
• Excelsior Gama supermarkets: Branch daily sales information capture (Los Palos Grandes, La Tahona, La Vizcaya, Macaracuay, Manzanares and Santa Fé) (140M records). Data warehouse creation of the corporate subsystems. Btrieve, Pervasive SQL 2000, SQL Server, Accrue Pilot Decision Suite. Caracas, Venezuela.
• Smurfit (Cardboards of Venezuela): Management Summary (Corrugated, Finance and other items). Caracas, Venezuela.

* Venezuela Analitica (Computer Software) [desde 11/2000]: Managed all aspects of the company’s intranet and internet technology: Lease dedicated servers, Domain Names Management, Automated content control. Ad distribution and management. Social network areas: (Forums, Chat, Webcasting, surveys).
• Large contents website (about 20K pages) with extensive information about Venezuela’s actuality. Awarded as the Best Internet Magazine by Lo Mejor de Punto COM a prestigious event that awards the best Venezuelan web sites.
• A content management library to expedite the creation of content oriented web sites also manages banner based publicity campaigns, online surveys and helps administer databases.
• Other sites: (B2B portal for the oil industry), (Colombian news and opinion site), (election candidates and voting guidelines), (baseball data and online contests), (contents for children), Mis Niños y Yo, SOS (Vargas tragedy victim search portal), Cyberanalítica (Cyber culture website), Bitblioteca (Electronic library with lots of reference information), Health and Lawyers portal.

Rankeado: No está rankeado

Proyectos en curso: 1

Último login: Hace 2 años

Registrado: Hace 5 años