Professional Experience

Confidential

Project Management and Business Intelligence / Consultant

• Provided consulting in the successful start-up of a firm that provides automotive services.
• Recommend and initiate necessary IT systems and protocols to best serve the business.
• Conducted business researches to target market.
• Provided IT support.

Business Intelligence Project Definition Phase

• Determined of Business Intelligence requirements.
• Defined of dashboard and scorecard, which included key performance indicators.

Confidential

Project Management and Business Intelligence / Consultant

• Identified Business Intelligence requirements from stakeholders.
• Identified Testing procedures.
• Determined tasks, duration, and responsibilities.
• SAP Master Data for implementing the SAP Inventory module.
• Data cleaning, data standardization, data analysis, V-lookups and pivot tables, Document Control

Confidential

Project Management and Business Intelligence / Consultant

• Provided consulting in the successful start-up of a firm that provides diplomatic security services.
• Formulated and implemented the marketing plan for the company to ensure a success launch.
• Provided and continue to provide marketing support with emphasis on Internet / Social Media efforts.
• Recommend and initiate necessary IT systems and protocols to best serve the business in a cost-effective way.
• Perform project feasibility for International Humanitarian Support.

Confidential

BI Project Manager/Analyst

• Successfully Implemented a Labor Analysis Business Intelligence solution for a simulated national construction company using Microsoft BI Stack, and completed others projects focused on a specific module, such as is MS SQL Server Integration Services SSIS , MS SQL Server Analysis Services SSAS , and MDX, MS SQL Server Reporting SSRS .
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. Created several MDX queries according to business requirements.
• Developed several detail and summary reports including line and pie charts, trend analysis reports.

Confidential

Student Employee Financial Aid Analyst

• Met all organizational goals and objectives / performance standards using the financial aid systems. Assisted students in securing the funds necessary to pursue their educational goals at Miami Dade College providing quality service, reliable information / access to information, and by one-on-one consultations with students, parents, and the general public.

Confidential

Production Senior Project Leader:

Successful delivering on time and within budget multiple projects applied to oil gas upstream industry. Defining project staffing, objectives, activities, cost and time estimating, planning and scheduling, monitoring and control, and project evaluation:

• Coordinated development of the first Marketing Plan that increased the capture of new customers by 5 .
• Identification of Business Opportunities for Automation in the Electrical Sector for potential new market growth.
• BI Oracle Data warehousing: Decision Support System DSS Transportation / Logistic 2002-03 : Development of the analysis phase for building an operational Data Mart that allowed the users optimize the use of the transportation units. Building of many several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.
• BI Enterprise Informational Environment of PDVSA 2002 . Built a Conceptual Model: Analysis of 17 Business Units, among them E P, Gas, Pequiven, Carbozulia, Public Relations, and Intevep. It was defined the KPIS' to be used by PVD executives, including the definition of the official data.
• BI Oracle Data warehousing: Decision Support System DSS Drilling Data Mart 2002-02 : Building an operational Data Mart to the Drilling Department. Analysis of the business in order to determine the data needed for reducing the cost associated to the drilling process. Building of many several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements. Statistical data analysis.
• BI Oracle Data warehousing: Executive Production Data Mart 2000-01 : Building an operational Data Mart which integrated different sources of data. Analysis of the business in order to determine the date needed for preparing the Official Reports required by Government. Building of many several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements. Statistical data analysis
• SAP-Plant-Maintenance 2000 : Functional support about 3,000 users in the Upstream Plant Maintenance function by giving solutions to their requirement, configuring technical objects, preparing the monthly reports and Statistical data analysis.
• BI Oracle Data warehousing: Oil / Gas PDVSA Supply Chain System 1998-1999 : Technical support to the upstream users using preparing queries and reports using the Oil Gas Enterprise System with a GIS tool, CENTINELA. Implemented the Human Interface of Centinela in the Eastern Division of E P of PDVSA.

BI Projects Responsabilities:

• Creating the business conceptual model. Defining business requirements identifying the business measures, the dimensions, the grain, business definitions and rules, and verifying data sources.
• Identifying the data: where the data exists or where does not exist, perform gap analysis.
• Creating the Dimensional logical Model. Identifying fact tables, dimensions tables star schema , snowflake model, link fact tables to the dimension tables, and create views for users.
• Designing summary tables.
• Formulation of the architecture requirements.
• Use of data model tools as is Oracle Designer.
• ETT Extraction, transformation, and transportation specifications and testing.
• Documentation and training.
• Define metadata.
• Database sizing.
• Discoverer data administrator:
• Defining user requirements, item classes, optional and mandatory conditions, calculated items, complex folders and organize into business areas, custom folders, summaries and hierarchies.
• Maintain the End User Layer.
• Grant access to user or roles, or set privilege.
• Maintain scheduled workbooks, Design and development of business intelligence reports.