
Alexandre C.Data Analyst
Skills
Professional in Business Administration with a postgraduate degree in Business Management and a specialization in Data Analysis. Possesses over two decades of experience in the financial market, specifically in Backoffice and Bank Guarantees. Demonstrates proficiency in data analysis, dashboard creation, and report generation, utilizing tools such as Excel and Power BI. Expert in developing analytical solutions with SQL and Python, maintaining product portfolios efficiently through performance indicators, and well-versed in Agile Methodologies, particularly SCRUM. Capable of conducting data analysis with tools such as Pandas, Numpy, Seaborn, and Matplotlib, and implementing Machine Learning techniques.
MIS Analyst
1/1/2024 - Present
Developed, maintained, and created dashboards and reports using Power BI and Tableau, demonstrating advanced proficiency in data visualization techniques. Utilized SQL for querying and managing databases, ensuring efficient data retrieval and manipulation. Developed technical skills in DAX and MDX to create complex, dynamic calculations and aggregations. Gained experience in integrating data from multiple sources, including Azure Data Lake and AWS Redshift, ensuring comprehensive and real-time reporting capabilities. Achieved a high level of excellence in requirement gathering, collaborating closely with stakeholders to translate business needs into actionable insights. Ensured data accuracy and consistency by implementing ETL processes using Python and Informatica. Additionally, performed performance tuning and optimization of dashboards and reports to enhance user experience and system efficiency.Administrative Assistant
7/1/2022 - 4/1/2023
Managed payment operations within the legal department for a retail institution, ensuring timely and accurate processing of financial transactions. Specialized in the creation and maintenance of comprehensive control reports utilizing Excel, optimizing financial oversight and operational efficiency.Analyst Backoffice
9/1/2012 - 2/1/2021
Performed tasks focused on control and prepared control reports with estimates and targets for the sanitation of internal departmental expenses. Standardized internal procedures related to expense reduction processes and provided support to internal clients. Analyzed, controlled, and planned processes involving bank guarantees.Junior Analyst
9/1/2010 - 9/1/2012
Gained expertise in account reconciliation and provided support for internal clients in the commercial sector. Demonstrated strong control and planning capabilities, with a focus on the analysis of expense processes within the commercial area of the institution. Ensured accuracy and consistency in financial records, contributing to the overall efficiency of financial operations.Clerk
2/1/2003 - 9/1/2010
Performed detailed accounting reconciliations, showcasing strong analytical and problem-solving skills. Developed expertise in using advanced Excel functions, including VLOOKUP, pivot tables, and complex formulas, to analyze large datasets and identify discrepancies. Utilized ERP systems such as SAP and Oracle for timely and accurate reconciliation of accounts. Demonstrated proficiency in handling reconciliations for various accounts including bank reconciliations, intercompany reconciliations, and ledger reconciliations. Applied knowledge of accounting standards and principles to ensure compliance and accuracy in financial reporting. Collaborated with other accounting and finance team members to streamline reconciliation processes, improving overall efficiency and accuracy. Proficient in using reconciliation tools like BlackLine and ReconNET to automate and enhance the reconciliation process. Developed a keen eye for detail through regular audit support and variance analysis, contributing to more precise financial statements.
Administration at Senac University Center
2014 - 2018Administration at Paulista University
2009 - 2013Data Analyst at British School of Creative Arts and Technology
2022 - 2023Data Analyst (Bootcamp) at IGTI
2022 - 2022
Foundations of Statistics: Part 1 at LinkedIn
9/1/2021Agile Management Fundamentals at LinkedIn
9/1/2021English Career for Development at Coursera
6/1/2021Everyday Excel at Coursera
5/1/2021SQL for Data Science at Coursera/UC Davis
3/1/2021Introduction to Python at Coursera
3/1/2021Introduction to Relational Database in SQL at Coursera
3/1/2021
Alexandre is available for hire
Hire Alexandre C.All Howdy Candidates are vetted for skills and english proficiency.