Scroll To View More
Hire the top 3% of freelance developers
Jorge Ramirez

Jorge Ramirez

Lima, Callao Region, Peru
Member since April 19, 2017
Jorge is a business intelligence consultant with more than nine years of experience. He has knowledge of the full process of business intelligence projects from analysis, requirement gathering, design BI architecture environment, database modeling, KPI and PI indicator definition, development, testing, and implementation.
Jorge is now available for hire
Portfolio
Experience
  • Database Design, 11 years
  • SQL Stored Procedures, 11 years
  • Stored Procedure, 11 years
  • T-SQL, 11 years
  • DataMart, 10 years
  • Data Warehouse, 10 years
  • Requirements Analysis, 10 years
  • SSRS, 10 years
Lima, Callao Region, Peru
Availability
Full-time
Preferred Environment
TBD
The most amazing...
...work I’ve done was a BI project involving five Verizon business services—extracting/cleaning multiple data sources (CSV files, SharePoint forms, SQL databases).
Employment
  • Business Intelligence Lead
    2016 - PRESENT
    RRN Consulting SAC
    • Led and executed BI projects for clients such as Domiruth Travel Service and Gemalto.
    • Designed the business intelligence project's architecture. Handled the SQL Server installation and configuration of the SQL Server Reporting Services, SQL Server Integration Services, and SQL Analysis Services.
    • Created stored procedures using temporal tables; focusing on the performance in order to avoid deadlocks in the main transactional databases, understood the query execution plans for each query in order to build the ETL to clean and extract the data to the datamarts.
    • Gathered the requirements and understood the client business processes to define the KPIs.
    • Designed and created the dashboards required for the projects.
    • Trained final users to install and manage the Power BI Desktop, report on the development, and publish to Power BI Web. Created workspaces in the Power BI Web and manage collaboration permissions.
    • Wrote migration reports from Crystal Reports to SQL Reporting Services 2012—improving the report design and stored procedures performance.
    • Create SQL Server Analysis 2012 Cubes and trained the final users to built reports from Microsoft Excel connected to the SSAS cube.
    Technologies: SQL Data Tools, SSRS, SSIS, SSAS, SQL Server 2014, Power BI, Report Builder 2.0 and 3.0
  • Business Intelligence Lead
    2016 - 2016
    Internet Enterprises Holding
    • Gathered requirements from users of each area.
    • Defined the KPIs and dashboards.
    • Designed the business intelligence architecture. SQL Server and SQL Data Tools installation. Extract Data using Sql Server Integration Services 2014 to from a SQL Server Azure data base.
    • Sales datamart modeling, Create and manage reports in Power BI to keep tracking on sales goals.
    • Managed projects.
    Technologies: SQL Data Tools, SSRS, SSIS, SSAS, SQL Server 2014, Power BI, Report Builder 2.0 and 3.0
  • Business Intelligence Project Manager
    2014 - 2015
    Axcess Financial
    • Managed BI projects within the data science PMO.
    • Coordinated the releases and tasks with the business PMO.
    • Gathered user requirements.
    • Presented weekly project indicators to upper management.
    • Created and followed the business intelligence projects' schedules.
    Technologies: MS Project, Pentaho
  • Business Intelligence Analyst
    2011 - 2014
    Verizon Terremark
    • Designed the business intelligence architecture. SSAS Cubes using the Star and Snowflake multi dimensional modeling.
    • Developed and maintained reports using SSRS. Improved the performance on a continuous basis by tracking the query execution plan.
    • Developed and supported the ETL using SSIS.
    • Developed and maintained the OLAP cubes using SSAS.
    • Worked on dashboard development and maintenance using PerformancePoint.
    • Acted as the internal lead on the business intelligence team.
    Technologies: SQL Data Tools, SSRS, SSIS, SSAS, SQL Server 2012, PerformancePoint, Report Builder 2.0 and 3.0
  • Business Intelligence Developer
    2010 - 2011
    Transaolution Systems S.A.
    • Provided support for the gatherment requirement user meetings.
    • Developed the ETL packages.
    • Supported the business intelligence architecture design.
    • Developed the report models for the ad hoc reports requirements.
    • Built the OLAP cubes.
    • Developed the reports using reporting services.
    Technologies: SSRS, SSIS, SSAS, SQL Server 2008, Power BI, Report Builder 2.0 and 3.0
  • Business Intelligence Developer
    2009 - 2010
    Avances Tecnologicos SRL
    • Developed ETL packages.
    • Developed reports using SSRS.
    • Supported the web development for the reports' module.
    • Aided the web solution analysis.
    • Provided support for the business intelligence requirement meetings.
    Technologies: SSRS, SSIS, SSAS, SQL Server 2008, Report Builder 2.0 and 3.0, ASP.NET
  • Business Intelligence Consultor
    2009 - 2009
    Domiruth Travel Services
    • Gathered user requirements for the web for the BI project.
    • Created the project schedule using MS Project.
    • Developed the ETL packages using SSIS 2008 R2 and stored procedures.
    • Designed the data mart and applied the Star multidimensional model and a bottom-up analysis.
    • Created reports with the required indicators using SSRS 2008 R2 and improved the continuous stored performance using temporal, improvement loops and by creating needed indexes.
    Technologies: BIDS, SSRS, SSIS, SSAS, SQL Server 2008, ASP.NET
  • Analyst Developer
    2008 - 2009
    Avances Tecnologicos SRL
    • Supported web modules development using ASP.NET.
    • Designed a database using SQL Server 2005.
    • Provided support for user testing.
    • Supported the requirement analysis.
    • Gave help as needed to the solution deployment.
    Technologies: ASP.NET, SQL Server 2005
  • Business Intelligence Developer
    2008 - 2008
    Banco Interamericano de Finanzas
    • Supported the data mart design.
    • Created the report stored procedures using SQL server.
    • Wrote reports using SSRS.
    • Supported the web development solution.
    • Gave help as needed to solution deployments.
    Technologies: BIDS, SSRS, SSIS, SSAS, SQL Server 2008, Report Builder 2.0 and 3.0
Experience
  • Back-End Contract Management (Development)

    I developed a web solution using ASP.NET for Domiruth (a travel agency company) to manage the contract conditions. Each airline is integrated with a flight ticket sales data mart to extract and clean the data from the transactional database using SSIS 2008. I also built a report for the contracts to control the accomplishment of each contract condition.

  • Verizon Terremark | Operational Data Center Dashboard (Development)

    This was a data warehouse project extracting data from multiple sources such as CSV files, SQL databases, and SharePoint forms.

    I gathered the requirements and defined the KPIs from multiple business areas—designing the dashboard reports for each area using PerformancePoint.

    I designed the data warehouse architecture and optimized the ETL process. I also built the report models to be the source of ad hoc reports based on the data warehouse information. In addition, I trained the final users and helped desk teams from Brazil, USA, and India.

Skills
  • Languages
    Stored Procedure, T-SQL
  • Tools
    SSRS
  • Paradigms
    Requirements Analysis, Database Design, KPIs
  • Storage
    Microsoft SQL Server, SQL Stored Procedures, DataMart, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS)
  • Other
    Analysis, Business Intelligence (BI), Data Warehouse, Data Warehouse (DW) Requirements, Query Optimization, BI Reports, Business Requirements, Data Analysis, Project Management Office (PMO), Project Management
Education
  • Project Management diploma in System Engineering
    2012 - 2012
    ISIL - Lima, Peru
  • Business Intelligence diploma in System Engineering
    2010 - 2010
    Universidad Peruana de Ciencias Aplicadas - Lima, Peru
  • Engineer's degree in System Engineering
    1998 - 2005
    Universidad Ricardo Palma - Lima, Peru
Hire the top 3% of freelance developers
I really like this profile
Share it with others