Ezra Arcia

Ezra Arcia  new_releases

About

Detail

Data Engineer
Argentina

Contact Ezra regarding: 
work
Full-time jobs
Starting at USD45/hour
Flexible work
Starting at USD45/hour
id_card
Internships
Starting at USD45/hour

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 8% verified
  • Endava
    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
  • DevReady
    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
  • Globant
    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 Off reports
  • B
    BI Technical Lead
    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 different 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 Department
    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.
  • DHL
    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 Staff 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
  • DHL
    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
  • Empresas Polar
    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
  • Empresas Polar
    Internship Industriekauffman program
    Empresas Polar
    Apr 1993 - Apr 1996 (3 years 1 month)
    - The Industriekauffman 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.
  • Biwares
    Data Engineer verified_user Verified experience
    Biwares
Education verified_user 0% verified
  • Universidad de Buenos Aires
    Bachelor's Degree Psichology
    Universidad de Buenos Aires
    Jan 2013 - Current (13 years 5 months)
  • Universidad Católica Andrés
    Diplomado Marketing/Marketing Management, General
    Universidad Católica Andrés
    2008 - 2009 (1 year 1 month)
  • F
    Programa Superior de Escritura Creativa
    Fundación ICREA
    Feb 2003 - Nov 2006 (3 years 10 months)
  • Universidad Simon Bolivar de Barranquilla
    Ingenieriá en computación
    Universidad Simon Bolivar de Barranquilla
    Feb 2002 - Nov 2004 (2 years 10 months)
  • CEVAC
    TSU, Business Administration and Management, General
    CEVAC
    Jan 1993 - Nov 1996 (3 years 11 months)