Développeur BI - Conformité des Données

• Jul 2023 - Present

Data Analyst

• Nov 2022 - May 2023

Main tasks : • Using PREXTRA software as ERP to get reports in Excel document format and use them as a data source in Power BI Desktop. • Generation and/or modification of product price lists. • Design of a price list visualization tool in Power BI using the ERP database as a source. This one hosted in SQL Server. • Processing of products catalog in pdf format and scraping of the company's website to integrate its data into reports, using Power Query. • Use of the application developed by Inlitix on Power BI Service to visualize and identify trends into the differents enterprise subsystems. Related tasks: • ESP Updates API user guide conception document adapted to the enterprise data, in order to publish the products of the promotional market. • Development of sample application to interact with the resources of this API using C#. Used Technologies : • Power BI Desktop. • Power Query. • M advanced formula language. • Power BI Service. • Paginated reports. • DAX Langage. • SQL Server. • Transact SQL. • Analysis Services (SSAS) Tabular Mode. • C#. Show less

Window Clerk

• Feb 2021 - Nov 2022

- Planogram update (products arrangement matrix for show and sell them) at the areas under my responsibility - Wares emplacements at the areas, keeping the stock minimum set. - Facing of the products keeping their correct disposition to the customers on the places for this purpose. - Price, expiration date, and out-of-stock verification of the products in the sections. - Methodical storage of the overstock in the warehouse. - Reception of the wares at the warehouse. - Utilization of the main software to support all these tasks. Show less

System Analyst

• Sep 2000 - Jul 2020

Administration and maintenance of the three hotel management systems (HMS) based on IBM Informix for Unix, Oracle 11g for Windows, and Microsoft SQL Server 2008R2 respectively. Administration and maintenance of pre-designed auxiliary systems to the (HMS) and the development of tools for the exchange of data between them. Most cases based on Microsoft technology, such as Microsoft Office, Microsoft Visual Basic for applications, and Visual Studio Net. Design and development of new auxiliary systems to facilitate administrative tasks such as analysis of costs and consumption of products to predict purchases, financial analysis of the company, as well as budgetary control at different levels (daily, monthly, and yearly). Microsoft Visual Studio (C #) and extensions such as Infragistics products have been used in these developments. Data warehousing as a data storage technology and Business Intelligence services such as Analysis Services, Integration Services, and Reporting Services of Microsoft SQL Server 2012 allowed the data integration from different sources and subsequent data visualization. Microsoft Excel 2013 and 2016 were also used as another customer reporting tools. Installation and configuration of an intranet-based on SharePoint Server 2013 on-premise with Reporting Services integrated. Participation in the design and development of the first version of the extranet of Melia Hotels Internationals, Cuba. Related tasks: Configuration and administration of a local domain network based on Microsoft and Open Source technologies. Microsoft technology for domain controllers, mail servers, application, and database servers. The Open Source was used for the firewall server. To optimize this implementation, the virtualization platform used was Hyper-V from Microsoft Windows Server 2012. Supervision of the project to set up a GPON network as the platform for the extension of various services to the whole hotel, such as wifi-connection, television, telephony. Show less

Construction Investment Department.

• Sep 1998 - Jul 2000

Discuss the constructions projects and its feasibility. Planning and organization of the work, dividing the whole project in objects of work. Organization of the activities for every object of work. Control of construction deadlines for every object of work and for the whole project. Quality control (drafting, control and monitoring of the quality plan). Cost control of the construction project progress. Performing the balance of human and material resources Show less

Scientific Reserve

• Aug 1995 - Jul 1998

Applications development to solve various engineering issues: Software for calculating earthwork in roads. Software for structural calculation of beams resting on infinite elastic supports. Automation of engineering design processes based on the AutoCAD object model. Automation of engineering processes based on the object model of Microsoft Office. Applications development to solve various engineering issues: Software for calculating earthwork in roads. Software for structural calculation of beams resting on infinite elastic supports. Automation of engineering design processes based on the AutoCAD object model. Automation of engineering processes based on the object model of Microsoft Office.