Caio Fernando Email & Phone Number

State Of Ceará, Brazil

As a part of the big team of this big company, I held a fundamental role in developing Oracle PL/SQL queries for accessing and manipulating critical and raw data in our data lake. Additionally, I collaborated with business, managerial, and IT teams to understand reporting requirements and develop business models that met their needs, automating the data capture process (SAP S/4HANA and internal system). In addition, my responsibilities included generating intelligent and agile reports, conducting advanced analysis and storytelling, and automating processes using Python.Technologies Used: Power BI | API | SQL | PL/SQL | Databricks | Python

Fortaleza, Ceará, Brasil

Web and desktop development with data engineering analysis using Python (Requests, FastAPI, Django, Flask, Pandas, SQLAlchemy, dash, NumPy, Plotly, Seaborn, OpenPyxl, Selenium, Playwright, PyAutoGUI, Machine Learning, among others), JavaScript (HTML, CSS, SCSS, React, NodeJS, Express and Bootstrap), relational and non-relational databases, Excel, Power BI. Examples to solution:1. Web system for data scraping from government websites and importing them into the client's system via API, generating reports with automatic e-mail sending. Technologies Used: Python | FastAPI | Requests | Flask | SQL | Pandas | Jupyter | Selenium | AWS |2. Internal desktop system for control and auditing of employee obligations and responsibilities, internal and client communication, fee and taxes controls, demand with billing control, and employee movement.Technologies Used: Python | FastAPI | Flask | SQL | SQLAlchemy | Pandas | Power BI | Selenium | AWS3. Web system for issuing invoices with control of changes, deletion, and editing. With tax calculation and generator directly linked to the RFB (Internal Revenue Service Brazilian API). With issuance of custom reports and integrated dashboards. Technologies Used: SQLAlchemy | SQL | Python | Selenium | Plotly | NumPy | Pandas | Google GCP4. Data scraping on the state secretary's website and integration with the database. Technologies Used: SQLAlchemy | FastAPI | Flask | Python | Selenium | Plotly | Dash | NumPy | Pandas | Databricks5. Landing Pages and web systems. Technologies Used: Python | Django | Flask | HTML | CSS | React | Javascript

Fortaleza, Ceará, Brasil

Planning and setting goals for the team, automating all possible processes, integrating modules of accounting systems (Fortes, Dominio, and Protheus), importing and configuring integration of internal and external systems within the company's environment, developing layouts, general accounting entries, reconciling suppliers, clients, obligations, banks, technical contact and visits to clients, responsible for integrating client companies with the office, generating reports (cash flow, trial balances, balance sheets, income statements, journals, among others), custom controls (Python, PowerBI, Excel, and VBA), conducting technical visits to clients, organizing documentation and filing, general registration services, monthly tax closures, configuration and sending of SPED ECD and ECF files (Internal Revenue Service Brazilian), billing, company opening and closure, provision of taxes and payroll, analysis of financial statements, monitoring and assisting team performance, reviewing tax calculations (Federal, State, and Municipal) and payroll calculations, among other routine activities related to the accounting sector. Technologies Used: Thomson Reuters Dominio | TOTVS Protheus | Power BI | API | SQL | VBA | Python | DatabricksReason for Leaving: I was assigned responsibility for the company's technology department.

Fortaleza, Ceará, Brasil

Development automation and financial control web accounting system.Led and coordinated a multidisciplinary team for the successful development and delivery of projects (Scrum and Kanban), defined and prioritized product requirements, closely collaborated with internal and external stakeholders, created and managed the Product Backlog, ensured that user stories were well-defined and understood by the development team, conducted regular planning and review meetings to iteratively adjust project goals and scope, communicated product visions and goals clearly to the team and stakeholders, ensuring common understanding and alignment, proactively resolved impediments and obstacles affecting team progress, and contributed to the continuous improvement of agile processes and development practices, resulting in increased efficiency and quality.Technologies Used: Scrum | Kanban | APIReason for Leaving: Management shelved the project.

Fortaleza, Ceará, Brasil

Developed automations and desktop applications for the company and clients using Python. Dashboards and developed Power BI data reports using SQL. Conducted meetings with management and operations to showcase results and goals. Integrated systems, developed various layouts, views, system parameterization, explored new technologies and improvements technology for the company overall. Managed the technology team and acted as product owner for third-party projects.Technologies Used: Python | Selenium | Flask | Django | SQL | Requests | FastAPI | Power BI | DatabricksReason for Leaving: Opportunity job in the technology field.

Fortaleza, Ceará, Brasil

I collaborated with the management team to generate and develop management dashboards, leveraging statistical methods and automations for streamlined data capture. Our dashboards provided real-time insights, with data updated automatically on an hourly basis.Technologies Used: Power BI | SQL | Protheus TOTVS | VBA | PythonReason for Leaving: Client transition.

Engenharia De Software, Information Technology

Pós-Graduação Lato Sensu - Mba, Taxation

Ensino Superior, Accounting