Mirza Camargo Mercado Email & Phone Number

Barcelona, Ct, Es

Barcelona, Cataluña, España

Viladecans, Cataluña, España

- Responsible for the Data Architecture team that carries out the migration of the Sales department's data models from Microsoft SQL Server in an On-Premise environment to Amazon Cloud (S3, Redshift, Airflow, PostgreSQL), using Data Vault 2.0 methodology.- Responsible for the deprecation strategy of Business Objects (Reports, Universes) to Tableau and Denodo.- Responsible for defining corporate data architecture's framework, standards and principles, including modelling, metadata, security, reference data, data dictionaries, etc.- Management and technical support of the design and implementation of database solutions and models of the data engineering teams of the Data department (10 Agile teams of between 8 to 10 people).- Creation and Management of the Operations area of the Data department (5 Agile teams of between 8 to 10 people each), as well as the definition of the roadmap and its subsequent monitoring.- Product Owner of the iOCC Operations area leading multidisciplinary projects in collaboration with companies external to Vueling (Cisneria Engineering, General Electric) generating cost optimization and automating processes that reduce dedicated personnel.- Responsible for the selection of data engineers for the data department, meeting the needs of the product teams.- Responsible for the “Vueling University” initiative of the data department to recruit data engineers in Zaragoza through the Center for Advanced Technologies.- Support in taking business requirements to transform them into technical specifications, including data flows, integrations, transformations, databases and data warehouses.- Evaluation of the database model implementation procedures to ensure they comply with internal and external regulations.- Review physical, logical and conceptual data models of data engineering teams to ensure they are aligned with existing standards and conventions.- Recommendations for solutions to improve new and existing data models.

Barcelona, Cataluña, España

Responsible for leading the design, development and implementation of critical business intelligence initiatives and projects that will contribute to strategic decision-making across the organization (Generali Insurance)- Manage the deployment of a data warehouse and business intelligence platform that integrates and transforms financial data.- Manage the design, development, testing and deployment of the company's control panels.- Develop business requirements, evaluate current reporting capabilities, and make recommendations on improving BI analytical tools.- Develop and maintain the logical and physical business model.- Propose templates for the functional and technical documentation of the different initiatives.- Work closely with various functional teams to translate business requirements into optimized semantic layers, reports and dashboards.

Barcelona Y Alrededores, España

Working as a consultant, participating in different projects with different clients from many sectors (Banking, Insurance, Public Sector, Industry, etc.).- Design and deployment of a data warehouse and business intelligence platform that integrates and transforms data from disparate sources.- Design, development, testing and deployment of the company's control panels and dashboards.- Develop business requirements, evaluate current reporting capabilities, and make recommendations on improving BI analytical tools.- Work closely with various functional teams to translate business requirements into optimized semantic layers, reports and dashboards.- Design and implement the definition, documentation and development of mapping rules for the movement of data from different data sources to the BI environment.- Design and implement Business Intelligence, information quality and information management governance.- Create logical data models that include entity-relationship-attribute models, as well as relational and/or dimensional models and their subsequent physical implementation of data structures.- Work in a direct relationship with business users to facilitate, define and document data requirements as a basis for database design, extraction, analysis and cleansing.- Provide practical data modelling (relational and dimensional) for Data Warehouse/Data Marts and the overall BI environment.- Provide best practices and guidance on the use of ETL, data modelling (relational and dimensional), and reporting deliverables.- Develop and maintain complex reports.- Develop and create comprehensive data validation and error processes as a component within the “end-to-end” BI solution architecture.Technologies used: Cognos Studio, OBIEE 10g – 11g, Power Center, Microstrategy 9.2. – 9.3., Microsoft SQL Server, SAP Business Explorer, SAP Business Objects XI/XI 3.2, arcplan Enterprise, Informática Power Center, Pentaho Kettle

Barcelona Y Alrededores, España

Responsible for the design, layout and coding of different websites, involved with the technical and graphic aspects:- How the site works and how it looks, also participate in maintaining and updating existing sites.- Site navigation code.- Design of buttons and other controls for the site.- Creation of site mockups for client approval.- Fix any functionality issues, including removing "dead links".- Updating and maintenance of the sites.- Write well-designed, testable and efficient code using software development best practices.- Design websites/user interfaces using standard HTML/CSS practices.- Data integration from various back-end services and databases.

Bolivia

- Design of web interfaces, logos, banners and flash animations- Web programming- Website hosting service- Network Solutions- Administration tasksTechnologies used: MySQL, PHP, JavaScript, Action Script, Adobe Dreamweaver, Adobe Flash, Corel Draw, Adobe Freehand

Master Avanzado En Programación Y Arquitectura Java, Programación Informática

Master En Comunicaciones Móviles, Dimensionamiento De Redes Gsm/Gprs, Redes Umts, Servicios Y Aplicaciones (Messaging, J2Me, Wap)

Ingeniería Superior De Informática, Ingeniería Informática