Miguel Cedeño

MIGUEL ANGEL CEDEÑO FRANCO Colombia, Bogotá, Cedritos, Street 146 #13 - 48 - Phone: +57 - --LinkedIn: https://www.linkedin.com/in/miguel-angel-cede%C3%B1o-franco-9a744432/?locale=en_US IT professional with more than 16 years of experience in different IT areas, some of my specialties would be project management, leadership, integration design, self-study, analytics, negotiation, conflict resolution, team development, data analysis, Report and dashboard constructions, auditing, high adaptability, and command of the English language at a conversational and written level. TECHNICAL SKILLS - Data analysis and visualization tools (Python, Alteryx, Power BI, Advanced Excel, Tableau, Jaspersoft, Crystal, Zoho Analytics). - Data storage and processing tools (SQL, ORACLE, Teradata, MySQL, Snowflake, Athena, S3, Lambda, PostgreSQL). - Programming languages (C #, Javascript, .Net, VBScript, Java). PROFESSIONAL EXPERIENCE THINKBRIDGE Senior Report Writer March 2023 (Actual Job) Integrate on customers-side projects as part of their team and manage, prioritize, investigate, advice and develop assigned tasks. - Designs, documents, codes, tests, and debugs programs using PL/SQL, SQL, HTML, JavaScript, and other necessary languages and tools. - Responsible for report creation with report writing tools, primarily concentrated with relational data bases such as Statistical Analysis Software (SAS), and data mining large volumes of data using query tools such as Advanced Query Tools (AQT) - Analyze system problems. - Use relevant tools to develop the right solution to meet customer data needs. ESCALA Business Intelligence Lead February 2022 – February 2023 Lead the BI team of Escala to get inside key indicators, behaviors and be aware of the structures, propose new structures and designs to optimize the database data consumption. - Lead the planning and organization of obtaining quality data and information so that it is useful and relevant in Escala. Ensure the reliability and integrity of the Company's data. Lead the BI team in the organization and structuring of the database. Detect changes, deviations or anomalies in the behavior of sales, income, expenses, productivity and other important data for the company. Identify changes in consumer behavior or preferences regarding products or services. Provide useful, truthful and timely information to decision makers at Escala. Detect, as soon as possible, threats and opportunities and provide such information for decision making articulated with the strategic objectives. Interpret results and search for conclusions. RAPPI - COLOMBIA Business Intelligence for RappiBank December 2021 – January 2022 Manage the information of RappiBank and get insides from the data point of view to get advantage to the business decisions, campaigns, and strategies. - Perform full analysis of RappiBank. Deepen and develop methodologies to find opportunities. Help to generate strategies that benefit the business based on the trends of the RappiCard THs. Provide the Strategy Area with valuable information based on data that can enhance the growth of the company, reduce consumption or improve customer service. - Provide dashboards and reports to understand the impact of strategies and monitoring tools. Business Intelligence for Long Tail & Expansion CPGs December 2020 – December 2021 Manage the information of all CPG of RAPPI for Long Tail and expansion for LATAM where RAPPI is operating and get insides from the data point of view to get advantage to the business decisions, campaigns, and strategies. - Achieve comprehensive analysis of RAPPI. - Generate dashboards and visual tools for the Long Tail & Expansion CPGs team. - Stablish follow up and results measurements procedures. MIGUEL ANGEL CEDEÑO FRANCO Colombia, Bogotá, Cedritos, Street 146 #13 - 48 - Phone: +57 - --LinkedIn: https://www.linkedin.com/in/miguel-angel-cede%C3%B1o-franco-9a744432/?locale=en_US COPA AIRLINES – PANAMÁ Leader of Business Intelligence for Operations January 2018 - October 2019 Manage the portfolio of projects related to information consumption, analysis, and data storage (DW) of IT for the operational areas of VP Airport, VP Maintenance and Cargo Management. Lead the Operational Information Services team, manage their development, follow-up, and needs of the projects involved with IT internal areas, IT suppliers or in senior management meetings of the company. Leading the Business information area in the development of new reports, dashboards and data models for the operations vice-presidents using different tools like Power BI, Tableau, Jaspersoft and Crystal Reports. Featured projects: Implementation of measurements and improvements in the baggage handling processes of the Tocumen S.A. airport. based on data analysis. Analysis, diagnosis and design of integrations between the SMARTKARGO to SAP and MAINTENIX to SAP systems. Business Systems Analyst III July 2017 – December 2017 Carry the assigned projects of the VP Maintenance, version adjustments, implementation of new technologies, diagnosis of problems and user support and user testing phases (UAT). Coordinate at different stages with internal IT areas, suppliers and meetings with interested parties. Analysis of databases to extract relevant information for the business and for develop reports, dashboard, KPI’s also to determinate a possible problem and the solution for it based on the data construction models, using Power BI, Tableau and Jaspersoft and Crystal Reports. Featured projects: RAMS project of 30 internal managements of the Maintenance VP and 2 external suppliers. Lead architect of the integration team of the new application to different internal and external COPA systems (3 different integrations). PO of the AGILE project development team (250 reports approximately.) Leader of the pilot project of Managerial measurement for the VP of Technology implementing a new tool (WorkFront - AtTask) creation of the profiles and portfolios of the projects, training of managers and analysts to use the tool (10 Management, approximately 50 people). Business Systems Analyst II July 2014 – June 2017 Carry the assigned projects of the VP Maintenance, version adjustments, implementation of new technologies, diagnosis of problems and user support and user testing phases (UAT). Coordinate at different stages with internal IT areas, suppliers and meetings with interested parties. Adjust and development of reports, dashboards, KPI’s in several tools like Tableau, Jaspersoft and Crystal Reports. Featured project: Carry out the change, design, logistics and implementation of the Centralization project in Panama of aircraft manuals for the Maintenance VP for all countries and stations (33 countries, 80 stations). GLOBALBANK CORP. - PANAMÁ Architect and Senior Analyst April 2007 – June 2014 Coordinator of the Programming team and Help Desk team of the BPM department. Manage changes in all its stages for national participation in fairs (MOTORSHOW, CAPAC), system adjustments, user testing internally and externally, parameter adjustments and development and implementations of reports, KPI’s and data visualizations. Featured projects: Project to change the BPM platform at the national level for the bank's consumer products, coordination of the help desk and necessary programming to adjust the new tool to the Bank's needs. Improvement of the management, adjustment, and implementation of new bank parameters in the different databases. ULTIMUS L.A. - PANAMÁ Consulting Engineer August 2005 – March 2007 Requirement’s analysis, consulting, and development of process automation strategies. Featured projects: Software development project for a bank in Miami Florida, involving teams in Mexico, Pakistan and Venezuela. have coordinated the assignment work for Pakistan and review of the submitted work. Infosgroup – UTP – PANAMÁ Developer I May 2005 – July 2005 Internship for outstanding students at the Technological University of Panama where emphasis was placed on requirements analysis and software development. MIGUEL ANGEL CEDEÑO FRANCO Colombia, Bogotá, Cedritos, Street 146 #13 - 48 - Phone: +57 - --LinkedIn: https://www.linkedin.com/in/miguel-angel-cede%C3%B1o-franco-9a744432/?locale=en_US EDUCATION & CERTIFICATIONS ACADEMIC CERTIFICATIONS Universidad Tecnológica de Panamá Computer Systems Engineering, 2007 COPA AIRLINES ACADEMY - Six Sigma Methodology – Yellow Belt, 2015 - Accelerated Process of Adaptation to Change Methodology, 2017 - Leadership Academy, 2018 Universidad Interamericana Master’s in project management, Stand by COURSERA - (5 courses) Python Specialization JAN 2020 - 1 course of Power BI JUL 2020 - 1 course of Introduction to Data Science SEP 2020 - 1 course of Statistics and Probability NOV 2020 - 1 course Managements Fundamentals NOV 2020 *All certificated of Coursera can be seen on my LinkedIn profile.