Benjamín Razo Estrada Email & Phone Number

Vancouver, British Columbia, Canada

Ciudad De México Y Alrededores, México

Roles:  Analysis of requirements for new projects Design Database Models Development of Catalogues and Fact Tables Development of new Database objects and Installation scripts objects. Responsible of the release of new Database Models through uDeploy Follow-up to task through Confluence and JIRA. Upload source code to Bitbucket Monitor nomenclature and definition rules compliance for Database Objects Implementing Staging Area and Datawarehouse for Treasury regulatory reports area. Development of Reports in MicrostrategyAchievements:  Implementation of Customer Catalog for Markets Products, LEI and Derivatives. Design and Implementation of data structures for Auctions Model Design and Implementation of data structures for Liquidity Model

Mexico City

Roles: BI Project Leader.  DBA (SQL Server) Creation of executive views and dashboards (Power BI, ZAP, ProClarity, Business Objects) Design and maintenance of business Datawarehouse. Designing and Implement data integration, data quality, data profiling, and Data Integration  Participation & lead in business requirement and solutions design Performing data analysis, data modeling, and measure/KPI definitionsAchievements:  Multidimensional models for SellIn, Purchases, Market Intelligence and Warehouse, based on MSSQL Server and sourced by different ERP’s (SAP S4 Hana / Dynamics AX / Dynamics SL) New data dictionary and methodology for processes and database field names.  Expert in SQL Server Integration Services (SSIS) and SQL Server Analisys Services (SSAS)  New Projects management based on PMI methodology Business Intelligence FrontEnds used: ProClarity, ZAP BI, Business Objects, Power BI Development of SellOut datawarehouse, integrating data from different Retail providers and wholesalers. Database management and security roles creation. Design and development of the whole Datawarehouse schema. Business dashboards development for board of directors and business partners. Developing and maintain data standards, processes, and templates to support data-driven analysis and self-serv BI Identifying and recommend opportunities to improve data quality processes Experience building Power BI Desktop reports. Experience publishing reports and dashboards to Power BI online services

Roles:  Project Leader Development of Multidimensional Business Intelligence models. (KPI’s, financial and marketing models, ETLs) BI Trainer. Developing complex ETL processes using parameters and control figuresCreation of executive views and dashboards Identify the business implications of data-related decisions Responsible to help define, date model and build data structures.Achievements: Highligts in projects:Secretaría de Seguridad Publica (development of KPI’s for ‘Kidnappings’ information and ‘066’ emergency number)Almacenes García (multidimensional model for Sell In and Warehouse)Grupo Integer (development of planning and Project model. Executive dashoboards for CEO)

Roles:  Project Leader Development of Multidimensional Business Intelligence models. (KPI’s, financial and comercial models, ETLs) Participation in the implementation of best practices and methodologies in data models BI Trainer. Support and Maintenance and Implementation of improvements to existing models Demo models for: Televisa, Tv Azteca, UVM, LG, IPN, Flecha Amarilla, General de seguros, Elsamex, etc. Sales support.Projects: Development of Multidimensional Business Intelligence models and BI infrastructure for: Grupo San Miguel (Canned food) Turistar (Public transport bus service) CFE (DPIF/DMCE)  TUM (Transporters) Tupperware (Home Products) Grupo Energético del Sureste (Gas Stations franchises) Beiersdof (Goods manufacterers) Snap On (Tools supplies) ProMarket (Advertising) Estrella de Oro (Public transport bus service)

 Development of Multidimensional Business Intelligence models. (KPI’s, financial and comercial models, ETLs) Participation in the implementation of best practices and methodologies in data models BI Trainer. Support and Maintenance and Implementation of improvements to existing models

Ciudad De México Y Alrededores, México

Roles:ProgrammerWebmaster and designer Maintanance Vendors web portal

Mexico

Worked as a volunteer at IT educational area giving training to external people in Programming Languages, Operating Systems, etc.

Post Graduate, Data Scientist And Business Analytics

Licenciado, Ciencias De La Informática