Omar G.

Data Analyst

Senior Data Integration Analyst
8/1/2021 - 5/1/2023

Developed ETL processes for various solutions including Master Data Management, Data Warehouses (DW), and Operational Data Stores (ODS) utilizing tools such as Pentaho Data Integration, IBM DataStage, and Databricks. Responsibilities included data collection from multiple sources, implementation of data normalization rules, correction of data errors, consolidation of collected data, data enrichment, and data governance. Created indicators using Microsoft Power BI by performing dimensional modeling of data, developing external charts using R language, and installing and configuring Power BI Gateway for use with Power BI Web. Constructed graphical panels and reports to enhance data visualization. Administered multiple types of databases including Postgres, Oracle, and Microsoft SQLServer. This entailed creating advanced analytical SQL queries, developing dimensional models, and implementing routine automated backup scheduling. Additionally, utilized Shell Script for automating data loads and other functionalities, which contributed to streamlined operations.

BI and Database Analyst
3/1/2021 - 7/1/2021

Oversaw the BI and database sector, performing analysis of requirements to meet client needs. Specialized in dimensional database modeling and the development of complex SQL queries, tuning, procedures, and functions using Oracle, SQLServer, and Postgres databases. Developed ETL processes utilizing Pentaho Data Integration and crafted insightful dashboards, analyses, panels, and reports with Power BI. Managed database migrations, ensuring seamless transitions across various platforms.

BI Analyst
12/1/2015 - 8/1/2020

Conducted requirements analysis for company clients, followed by the modeling of dimensional databases. Developed SQL queries, procedures, and functions utilizing Oracle, SQLServer, and MySQL databases. Executed ETL processes with Data Stage (IBM) and Spoon (Pentaho) tools, ensuring efficient data transformation. Created interactive dashboards, analytical panels, and comprehensive reports using BIEE (Oracle), Power BI, and PHP. Maintained and provided support for the company's report-generating tool, ReportServer, while also handling the maintenance of internal company systems using Java.

Systems Analyst
7/1/2014 - 7/1/2015

Conducted requirements analysis with company clients and performed data modeling. Developed various internal and external systems, including CRM, financial, support, and after-sales systems. Provided consulting and mentoring on Maker All, WebRun(Java), and WebRun(.NET) tools. Responsible for the maintenance and support of the company's internal systems.

Systems Analyst
6/1/2013 - 6/1/2014

Analyzed software requirements and developed systems in the area of Municipal Management, including the Real Estate Recadastramento Portal. Collaborated closely with the manager of the Systems Quality Team (EQS) and Data Administration (AD) to ensure high-quality system performance and data integrity.

Systems Analyst
7/1/2009 - 7/1/2011

Performed in-depth requirements analysis to understand client needs. Excelled in data modeling to structure complex data systems. Developed a range of internal and external systems including CRM, Finance, Support, and After Sales. Provided consulting and mentoring on Maker All tools and WebRun framework, delivering expertise in both Java and .NET environments. Took responsibility for the maintenance and support of internal systems, ensuring operational continuity and efficiency.

Analysis and Development of Systems at Unijorge
2017 - 2020