Eduardo Simoes Email and Phone Number

- Maintenance of a financial risk model system for the healthcare sector (R language)• Improvements, adjustments and corrections in each necessary financial risk statistical model (market, underwriting, default, operations and investment risk)- Automation of manual processes in the healthcare actuarial area with Excel spreadsheets using VBA language.- Identification of anomalies and analysis of cost reduction charged by healthcare service providers.- Identification of anomalies and analysis of revenue collections (monthly fees and co-payments) charged by the company from its customers and service providers in the healthcare sector.- Various other day-to-day analyzes in the medical field using SAS to perform ETL, and using Power BI and Python tools to present and perform the analyses.

• Support board and management decisions, and collaborate with all other areas of the company (financial, accounting, operational, etc.)• Data extraction• Data collect• Data cleaning• Data processing• Interpreting data• Statistical Calculations• Data visualization with Power BI, Tableau, Jupyter Notebook and Excel• Relational database modeling• Data Warehouse Modeling• MS SQL Server, T-Sql and SSIS• R, Python• Knowledge of Administrative and Operational Processes• Enterprise Resource Planning (ERP)• W #- Development of a donation collection management system (C# and T-sql)• Financial Data Processing• Creation of communication layouts with billing gateways• Data Modeling and Standardization• Datawarehouse modeling and feeding• Data Source Integration• Data Qualification and Validation• Backup and Recovery• Access Management• Data Audit• Data Analysis and Insight Generation (Financial Reports and Dashboards) • Profitability Analysis by Campaign • Customer Purchasing Behavior Patterns • Cash Flow Forecast • Identification of Non-Essential Expenses • Segmentation of Profitable Customers (age, education, type of donation, etc.) • Analysis of Sales Trends (seasonality, festive period, etc.) • Collection and Recovery Efficiency • Assessment of Financial Risks (Default, Billing Error and Fraud) • Analysis of Return on Investment of campaigns • Customer Payment Standards • Monitoring of Key Financial Indicators (KPIs) - Donor/donation recovery, Error/fraud rate, Average ticket, Base utilization, etc.• Training and knowledge replication• Metadata Management• Data Lifecycle Management• Interdepartmental Collaboration

• Data Extraction • Data Cleaning • Data Processing • Interpreting Data • Data Visualization with Power BI and Excel • MS SQL Server, T-Sql and SSIS

• Analysis of requirements and implementation of Enterprise Resource Planning (ERP)• Deep knowledge in all ERP product development tools• Object creation and programming in T-SQL database language• Data Analysis and dynamic Excel spreadsheets• Routines to improve system usability

Main activities: Network infrastructure installation, customer service in hardware and software maintenance.

Main activities: Network infrastructure installation, customer service in hardware and software maintenance.