Ezra

Data Engineering solutions and Business Intelligence with cloud technologies.

• SSIS / SSRS
• Technologies:  Azure SQL, Azure Synapse, Azure Logic Apps, Azure Functions, Datverse MS SQL Server, Snowflake, Power BI.

He performed technical leadership roles, especially in Data Architecture. He worked on Data Warehouse modeling, and he participated in ETL development. He used the Agile methodology.

• Data Reporting
• ETL
• Data Warehousing / Modeling
• Technologies used: Azure DB, Azure Data Factory, Azure Logic Apps, Azure Functions, Azure Data Lake, Power BI, Power Apps.

Data visualization and data modeling creation using custom reports and dashboards.  He developed ETL processes using Pentaho and Microsoft services.

• Reports and Dashboards with Power BI Data Modeling with Azure SQL DW
• ETL process with Azure Data Factory U-SQL Azure App Insights
• Use of MS SQL Server and PostgreSQL
• ETL development with Pentaho and MS SSIS
• Use of SuccessFactors (SSFF) API for Time Off reports

Architecting, designing, developing, planning, and implementing full-stack SQL Server BI solutions. Building, optimizing, and maintaining data warehouses and SQL Server databases. Creating complex ETL processes from multiple data sources. Providing business insights and decision-making power through data visualizations and interactive reports.

• Developed Stored Procedures in MS SQL Server, creating ETL packages in MS SSIS, analyzing, diagnosing, and solving production errors.
• Communicating the advantages of Agile developing methodologies and successfully accomplishing the alignment to them in both sides, Factory and Client.

Technologies:  PowerBI, ETL, SSIS, Agile, SSAS, T-SQL, SQL Server

Architected, designed, and developed SQL Server and Microstrategy solutions for clients in the financial industry. Developed complex ETL processes for multiple data sources with BI tools like SSIS and custom SQL queries. Built custom reports and dashboards to interact with complex data sets. Developed and maintained data warehouses.

• Taught courses on tools such as OBIEE
• Modeling Business Intelligence solutions, developing Stored Procedures, Queries, Views, Triggers, and other Database objects
• Constructed metadata for BI Tools
• Created Reports and Dashboards
• Integrated Solutions with MS Excel and VBA.
• Self-managing workloads and workflows.

Technologies:  OBIEE, ETL, PowerBI, MS Excel, VBA, SQL Server, SSIS, Talend, SSAS, C#, Oracle, PL/SQL, Active Directory, ASP.NET, IIS

Designed and developed tools to improve control and analysis of the budget for one of the largest banks in Venezuela. Developed BI applications in a Microsoft environment with SQL Server, Access, and Excel. Apps were used for budget analysis like savings management, macroeconomic parameters, and more.

• Data Analysis of differences, savings management, and calculations of macroeconomic parameters.
• Led meetings with department heads to set goals and review differences.
• Developed and maintained monitoring processes and application control.

Technologies:  MS Dynamics, SQL Server, Excel, MS Access, PowerBI, T-SQL.

• Sales Administrator at DHL (2009-2010)
• Copywriter for DC33 Group (2008-2009)
• National Statistics Analyst at DHL (2006-2008)
• Junior Business Intelligence Specialist at MPR Venezuela (2005-2006)
• Business Intelligence Consultant at Arcia C Soluciones (2004-2005)
• MIS Analyst and Senior IT Analyst (DBA) at ABN AMRO Bank (1998-2004)
• Investment Control Supervisor at Empresas Polar (1996-1998)
• Scholarship Intern at Empresas Polar (1993-1996)