Jorge is available for hire
Hire JorgeJorge Ramirez
Verified Expert in Engineering
Data Marts Developer
Location
Lima, Callao Region, Peru
Toptal Member Since
June 18, 2020
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.
Data Warehouse DesignData WarehousingBI ReportsDatabase DesignSQL Stored ProceduresT-SQL (Transact-SQL)Microsoft SQL ServerSQL Server Reporting Services (SSRS)Business Intelligence (BI)Data AnalysisSQL Server Analysis Services (SSAS)SQL Server Integration Services (SSIS)Project ManagementSQL Server 2014Microsoft Power BI
Portfolio
RRN Consulting SAC
Microsoft Report Builder, Microsoft Power BI, SQL Server 2014, SSAS...
Internet Enterprises Holding
Microsoft Report Builder, Microsoft Power BI, SQL Server 2014, SSAS...
Axcess Financial
Pentaho, Microsoft Project
Experience
Availability
Part-time
Preferred Environment
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).
Work Experience
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 data marts.
- 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: Microsoft Report Builder, Microsoft Power BI, SQL Server 2014, SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT)
Business Intelligence Lead
2016 - 2016
Internet Enterprises Holding
- Gathered requirements from users of each area.
- Defined the KPIs and dashboards. Managed various projects.
- Designed the business intelligence architecture. SQL Server and SQL Data Tools installation. Extracted data using SQL Server Integration Services 2014 from a SQL Server Azure database.
- Worked on sales data mart modeling. Also, created and managed reports in Power BI to keep track of sales goals.
Technologies: Microsoft Report Builder, Microsoft Power BI, SQL Server 2014, SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT)
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: Pentaho, Microsoft Project
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: Microsoft Report Builder, PerformancePoint, SQL Server 2012, SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT)
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: Microsoft Report Builder, Microsoft Power BI, SQL Server 2008, SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
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: ASP.NET, Microsoft Report Builder, SQL Server 2008, SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
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: ASP.NET, SQL Server 2008, SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio
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: SQL Server 2005, ASP.NET
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: Microsoft Report Builder, SQL Server 2008, SSAS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio
Experience
Back-End Contract Management
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
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.
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 (Transact-SQL)
Paradigms
Database Design, Requirements Analysis, Business Intelligence (BI)
Storage
SQL Server Reporting Services (SSRS), SQL Stored Procedures, Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005
Other
Data Warehouse Design, Data Warehousing, Key Performance Indicators (KPIs), BI Reports, Query Optimization, Requirements & Specifications, Data Marts, Analysis, Data Analysis, Project Management Office (PMO), Business Requirements, PerformancePoint, Business Intelligence Development Studio
Industry Expertise
Project Management
Frameworks
ASP.NET
Tools
SSAS, Microsoft Power BI, Microsoft Report Builder, Microsoft Project
Platforms
Pentaho
Education
2012 - 2012
Project Management Diploma in System Engineering
ISIL - Lima, Peru
2010 - 2010
Business Intelligence Diploma in System Engineering
Universidad Peruana de Ciencias Aplicadas - Lima, Peru
1998 - 2005
Engineer's Degree in System Engineering
Universidad Ricardo Palma - Lima, Peru
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring