Ezra Arcia Data Engineer

Data Consultant

Endava

Feb 2021 - Current (5 years 4 months)

- Technical Leadership. Data Architect. DW modeling, ETL development, Reporting. Technologies used: Azure DB, Azure Data Factory, Azure Logic Apps, Azure Functions, Azure Data Lake, Power BI, Power Apps. Agile Framework

Senior Business Intelligence Developer

DevReady

Oct 2019 - Feb 2021 (1 year 5 months)

- Developing Business Intelligence solutions with MS SSIS, MS SSRS, MS Power BI, MS SQL Server, MS Azure Logic Apps, Dataverse

Business Intelligence Specialist Sr

Globant

Aug 2019 - Feb 2021 (1 year 7 months)

- Creation of 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 Oﬀ reports

B

BI Technical Lead

Aug 2017 - Jul 2019 (2 years)

- Leading a team of developers for a BI Factory. Full stack BI development with Microsoft BI Tools and MicroStrategy. Tasks include developing Stored Procedures in MS SQL Server, creating ETL packages in MS SSIS, analyzing, diagnosing and solving - production errors. Weekly meetings with stakeholders in the client side reviewing status of projects and setting priorities and objectives week to week. Communicating the advantages of Agile developing methodologies and successfully accomplishing - the alignment to them in both sides, Factory and Client. Also, collaborating in projects of other teams for clients.

B

Business Intelligence Consultant Sr

Jul 2013 - Jul 2017 (4 years 1 month)

- Responsible for several projects at the same time, in some cases working with members of a team in diﬀerent countries and time zones. Working with vendors supporting the implemented tools in the client, communicating issues, nd following them through - Teaching courses of tools such as OBIEE, Modeling Business Intelligence solutions, developing Stored Procedures, Queries, Views, Triggers, and other Database objects, ETL Packages, constructing metadata for BI Tools, Creating Reports and Dashboards. - Also, integrating solutions with MS Excel and VBA. Self-managing of workload and workflow. The tools used were many and diverse depending on the client visited. Business Intelligence Architecture Design, Development and Training, with MS SQL S

Budget Specialist

Budget Department

Jun 2010 - Apr 2012 (1 year 11 months)

- Technical arm of the Budget department. Developing tools and controls for the Budget process of the whole bank using Microsoft Dynamics, Microsoft SQL Server, MS Excel, and MS Access. Data Analysis of differences, savings managing, calculations of - macroeconomic parameters. Leading meetings with department heads to set goals and review differences. Developing and maintaining processes of monitoring and control of applications.

Sales Administrator

DHL

Jun 2009 - Jun 2010 (1 year 1 month)

- aintained DTS Packages and complex queries and MS SQL Server Stored Procedures that extracted and transformed information from multiple sources and updated information for Management Decision Making Reports like KPI, Sales Performance, and - Salesperson and Sales Staﬀ Scorecard Developed and supported reporting using ASP, COGNOS, VBA and MS Excel. Performed DB administration for several servers, oversaw tuning, monitoring, login administration, backup policy and upgrades and installation - Managed the Sales CRM system (COMET) In charge of presentation of monthly performance results to Sales Management (by region, category, revenue, units, and weight among others) Received and imparted instruction about new processes and global sales - pol

National Statistics Analyst

DHL

Mar 2006 - Jun 2008 (2 years 4 months)

- Developed an automated tool, using MS SQL Server, DTS and ASP, to improve the operational performance of the deliveries, by monitoring the checkpoint compliance, transit times and “transport collect” alerts. Programming of Stored Procedures, Triggers - Alerts and complex queries to create compliance alerts Designed and developed KPI and Personnel Scorecard reporting using ASP and MS Excel. In charge of presenting monthly analysis and performance results to the Operational management Performed DB - administration for several servers, oversaw tuning, monitoring, login administration, backup policy and upgrades and installations. Received and imparted instruction about new processes and global operational policies

A

Business Intelligence Consultant

Arcia C Soluciones

Mar 2004 - Jun 2005 (1 year 4 months)

- Designed and modeled the Metadata for the new Data Warehouse of the bank Designed and created DTS packages to extract data from the AS/400 and transform it to be used in MS SQL Server Supported several applications developed in Visual Basic 6, ASP, - HTML, JavaScript and also reports in Crystal Reports. Supervised two analysts who were in charge of BOD/EOD processes and the automation of reports and other tasks.

A

MIS Analyst - IT Analyst (DBA)

ABN AMRO Bank

Jul 1998 - Feb 2004 (5 years 8 months)

- Managed and maintained the Reporting System of the bank, which include not only creating complex queries to obtaining information but also the creation of the corresponding report. In charge of developing, maintaining and deploying every accounting - and performance report for internal and external consumption using MS Access Maintained several applications developed in house, like the Credit Scoring system that was developed using MS Access Database administrator to several MS SQL Server servers

Investment Control Supervisor

Empresas Polar

Apr 1996 - Jun 1998 (2 years 3 months)

- Was the operational arm of a small team in charge of monitoring the investment in sales equipment (freezers) and its performance in terms of money, units and volume. Extraction and Transformation of data from AS/400 to MS Access and MS Excel - Automation of reports using Visual Basic for Applications (VBA) in MS Excel and MS Access. Analysis of data using SSPS to find tendencies of sales behavior

Internship Industriekauffman program

Empresas Polar

Apr 1993 - Apr 1996 (3 years 1 month)

- The Industriekauﬀman Dual System of instruction from Germany comprises classes followed by long internships in several departments of a sponsor company, which was hands-on training in Production, Planning, Marketing, Sales, Human Resources, Finance, - Quality Assurance and Accounting. At the end of the process, I stayed as a Costs Accounting Analyst and my tasks included: valuating and taking inventory, Sales Cost calculation and automation of several administrative processes.

Data Engineer

Biwares

Ezra Arcia

About

Detail

Timeline

Résumé

Ezra Arcia new_releases

About

Detail

Ezra Arcia