Gui Chagas Email & Phone Number

Ottawa, On, Ca

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

- Develop and maintain data infrastructure, including databases and data warehouses, to ensure efficient storage and retrieval of data.- Design, implement, and maintain data pipelines for data extraction, transformation, and loading (ETL) processes.- Collaborate with data scientists and other stakeholders to understand their data requirements and translate them into technical specifications.- Conduct data cleaning, preprocessing, and quality assurance to ensure data accuracy and… Show more - Develop and maintain data infrastructure, including databases and data warehouses, to ensure efficient storage and retrieval of data.- Design, implement, and maintain data pipelines for data extraction, transformation, and loading (ETL) processes.- Collaborate with data scientists and other stakeholders to understand their data requirements and translate them into technical specifications.- Conduct data cleaning, preprocessing, and quality assurance to ensure data accuracy and integrity.- Identify patterns, trends, and anomalies in data sets to uncover insights and drive business improvements.- Collaborate with cross-functional teams to define data analytics requirements for new projects and contribute to the overall data strategy of the organization.- Ensure compliance with data privacy and security regulations in data handling and analysis processes. Show less

Ottawa, Ontario, Canada

- Proactively identify tracking and testing opportunities for operations activities (purchasing, fulfillment, delivery) with the goal of optimizing performance.- Provide analytical support for the exploration of initiatives to improve customer experience, optimize performance and drive margin improvements.- Track and report on project and initiative success by setting appropriate goals, monitoring performance and creating and executing comprehensive analysis plans.- Translate… Show more - Proactively identify tracking and testing opportunities for operations activities (purchasing, fulfillment, delivery) with the goal of optimizing performance.- Provide analytical support for the exploration of initiatives to improve customer experience, optimize performance and drive margin improvements.- Track and report on project and initiative success by setting appropriate goals, monitoring performance and creating and executing comprehensive analysis plans.- Translate business requirements into analytical projects to identify trends, solve challenging problems and deliver insights.- Present reports and analytical results to key business stakeholders, effectively communicating key findings and recommendations.- Optimize data collection and operations activity metrics to broaden the understanding of our purchasing and distribution engine and enable opportunities for efficiency and growth.- Champion innovative analytical ideas that enable new opportunities. Show less

Ottawa, Canada Area

- Twice prized at Fullscript Hackathon 2019 / 2020Main responsibilities: - Designing and building data visualizations, reports, and dashboards for the purposes of monitoring, understanding and optimizing company performance- Guiding stakeholders in defining their requirements and understanding their data- Improving data availability and data literacy across the organization- Educating and training internal teams on optimal use of our Business Intelligence software-… Show more - Twice prized at Fullscript Hackathon 2019 / 2020Main responsibilities: - Designing and building data visualizations, reports, and dashboards for the purposes of monitoring, understanding and optimizing company performance- Guiding stakeholders in defining their requirements and understanding their data- Improving data availability and data literacy across the organization- Educating and training internal teams on optimal use of our Business Intelligence software- Collaborating with the engineering team to define a required architecture for downstream reporting and analytics- Identifying, analyzing and interpreting trends or patterns in complex data sets- Aiding in the management of our internal data request queue- Becoming a Business Intelligence tool subject matter expert, educating and training internal teams to use the tool optimally Show less

Porto Alegre Area, Brazil

• Certified Blue Prism Developer AD01 • Designated as the lead Developer and Automation Architect • Developed more than 20 process automation solutions using MS Excel and VBA • Designed and developed 4 full automation solutions using RPA for multi-platform environments from Oracle's EBS to Firefox • Responsible for all analytics and KPIs for the automated processes

Porto Alegre Area, Brazil

Superplayer is a music streaming service that aims to improve every moment of peoples lives through the perfect soundtrack. • Developed new product analytics from acquisition to visualization using different tools and skills (i.e. Python, noSQL MongoDB, Tableau) • Supported management in strategical decisions through reports and data analysis • Developed and Reported all KPIs (i.e. Monthly Active Users and Churn) (Large databases with millions of entries) •… Show more Superplayer is a music streaming service that aims to improve every moment of peoples lives through the perfect soundtrack. • Developed new product analytics from acquisition to visualization using different tools and skills (i.e. Python, noSQL MongoDB, Tableau) • Supported management in strategical decisions through reports and data analysis • Developed and Reported all KPIs (i.e. Monthly Active Users and Churn) (Large databases with millions of entries) • Designed and coordinated actions plans for Performance-based Media (Acquisition, Activation, Retention) • Delivered a presentation in the Developers Conference Porto Alegre presenting MS Excel for Data Visualization Show less

Porto Alegre Area, Brazil

• Managed a project to redesign the process of overtime hours control reporting directly to the CEO (2,500+ employees involved) • Designed and developed a system to calculate and control special shifts (1,500+ employees involved) • Designed and developed a dashboard with all HR KPIs and a system to acquire data automatically

Porto Alegre E Região, Brasil

• Corrected a geo-coordinates database (1,000,000+ entries) using statistical analysis and PDCA methodology • Designed and developed a decision tree (1,000+ different paths) for the company's call center (PMI Methodology) • Designed KPIs and a system do control overtime hours (saving in 12 months: BRL 6,000,000+) (Six Sigma Methodology)

Gravataí Area, Brazil

◦ Managed +100 electronic products working with customers for special designs and with factory engineers for process and product improvements ◦ Designed and developed 5 new capacitors for special projects (automotive customers) ◦ Designed an electronic module to reduce scraps on 1uF/63V capacitors (reduction of 50,000+ scraps per week)

Master Of Business Administration (M.B.A.), Project Management

Engineer, Electrical And Electronics Engineering

Nanodegree, Data Science Fundamentals Ii

Nanodegree, Data Science Fundamentals I