Michael L.Data Scientist
Skills
Data Scientist with approximately two years of professional experience in data analysis and manipulation. Proficient in Python, SQL, and Power BI, with a demonstrated ability to utilize Google Sheets (Google App Script) and Google Data Studio for data visualization and reporting tasks.
Data & Analytics Manager
7/1/2023 - Present
Specialized in the development of data projects by collaborating with clients from the initial stages, accurately identifying and addressing their data needs. Gained expertise in ETL development, including comprehensive data extraction, cleaning, and categorization using Python scripts. Managed to collate and tabulate data from diverse sources for efficient comparison, and delivered insightful dashboards using Power BI, ensuring the visual information was well-organized for optimal comprehension.
Led the development and scope expansion of projects in alignment with the maturity of the data, successfully incorporating new features into each scope. This involved advanced data analysis, ensuring data accuracy and scalability within the data engineering processes. Developed and managed multiple web scraping projects, applying sophisticated techniques to harvest and process data from various online sources.SAP Consultant
2/1/2023 - 7/1/2023
Developed an implementation of the BW HANA database, demonstrating proficiency in modern database management systems. Conducted extensive S4 HANA unit testing, ensuring robustness and reliability of the system. Managed string testing (integrated) to ensure seamless integration across modules. Created detailed documentation in Solman to facilitate smoother project tracking and maintenance. Tested and validated Fiori apps in Embedded Analytics, guaranteeing optimal performance and user experience. Customized SAP solutions to meet specific client needs, showcasing adaptability and expertise in tailoring software solutions. Maintained constant communication with clients to collaboratively develop and refine projects, ensuring alignment with their requirements and expectations.Risk Analyst
5/1/2022 - 2/1/2023
Developed dashboards to monitor fraud prevention metrics in real-time, utilizing new insights to apply and evolve business rules, identifying gaps in existing queries, and generating instant alerts for outliers. Maintained regular communication with customers following suspicious transactions, requiring adept analysis to ascertain their legitimacy and safeguard against scams or money laundering. Conducted in-depth studies on business rules created with transaction data using Python and SQL in BigQuery, providing managers with novel insights and perspectives on fraud prevention.Finance Data Scientist Intern
5/1/2021 - 5/1/2022
Developed studies leveraging multiple databases to monitor company operations, emphasizing financial metrics such as EBIT, EBITDA, and operating profit, and visualizing the results through Power BI dashboards for managerial insights. Created a comprehensive database for A/B testing to analyze and optimize the company's client portfolio, identifying opportunities for targeted actions based on customer data. Automated various spreadsheets sourced from different data origins to enhance efficiency and information accuracy by deploying Excel and Python scripts, including spreadsheets for billing calculations. Conducted in-depth market studies to create accurate client personas that reflect the Brazilian market landscape. Designed and implemented complete ETL workflows utilizing Alteryx to streamline data extraction, transformation, and loading processes.Business Intelligence Intern
11/1/2020 - 4/1/2021
Developed multiple databases utilizing Google Sheets and Google App Script to enhance automation and enable seamless cross-referencing within a unified platform. Evaluated customer needs and objectives by designing interactive dashboards using Google Data Studio, facilitating visual information representation and aiding in the comprehension of each consulting phase and its progress. Provided support to various departments by automating spreadsheets with Python, thereby streamlining workflow efficiency and data management.
Production Engineering at Presbyterian University Mackenzie
2018 - 2022
Power BI at Yto Nihon
5/1/2020Advanced Excel at Impacta
3/1/2019
Michael is available for hire
Hire Michael L.All Howdy Candidates are vetted for skills and english proficiency.