Daniel Corredor Mazuera

Daniel Corredor Mazuera Business Intelligence | Marketing | Retail | Data Analysis | Big data | Benchmarking | Power BI | SQL | Access - Bogota, Colombia - https://www.linkedin.com/in/daniel-corredor-mazuera/ Bilingual business administrator, with 2 years of experience in marketing, analysis of sales figures in the retail sector, business intelligence, SQL programming and database management in Excel, which through benchmarking seek to study the competition to create strategies to improve decision making, based on the analysis of big data. Professional with knowledge in SQL, Access, Power BI and Power Pivot, as well as critical thinking skills, teamwork and assertive communication. WORK EXPERIENCE MOVII - DATA ANALYST MARCH 2022 – ACTUALY Responsibilities: Create new queries through SQL, in order to achieve a correct analysis of the company's requirements, to be able to create data visualization dashboards in order to have an autonomous system so that the information is updated by itself. Manipulate aws services(S3, Iam, redshift, Quicksight) to use their correct functioning according to the company requirements. Achievements: I unified sql queries to visualize in a simple and understandable way company information through aws Quicksight service. I consolidated reports for movii user analysis, allowing to have a quick response for the company's actions. Implemented new sql queries to clean, create and transform new and historical company information. SAMSUNG ELECTRONICS - BUSINESS INTELLIGENCE ANALYST SEPTEMBER 2019 – SEPTEMBER 2020 Responsibilities: Create new databases with historical information through Excel, in order to achieve a correct analysis of new business opportunities, research and analyze campaigns, discounts and competitor's movements in the white goods market, through Google Trends to make counteroffers and achieve higher sales volume in the market share and monitor the growth and control of the company's products in the Colombian market in different web pages. Achievements: I unified a database on specific white line information, which allowed to analyze sales, market position, market share, insight share, self share, among others. I consolidated reports for the analysis of competitors' advertising, allowing to take actions on new strategies. I implemented databases in Excel, with characteristics of new products that were included in Colombia in order to have clearer and more concrete information. SIEMENS SA - ADMINISTRATIVE SUPPORT SERVICE SEPTEMBER 2018 - SEPTEMBER 2019 Responsibilities: Create and control the issuance of insurance policies for Siemens sister companies and implement strategies for time optimization in procedures for the issuance and control of warranties and policies through Excel. Achievements: I optimized macros in Excel to reduce the quoting time of bank policies by 50%. I structured new strategies for the organization of information in databases related to issued policies achieving a 10% reduction in search time. ACADEMIC BACKGROUND BACHELOR DEGREE UNIVERSITY EL BOSQUE BUSINESS ADMINISTRATOR ENERO 2014 - FEBRERO 2018 SUPPLEMENTARY COURSES CERTIFICATE UNIVERSITY EL BOSQUE BUSINESS INTELLIGENCE AND DATAMINING MARZO 2021 - JUNIO 2021