Herbert Julius Garonfolo
Financial Data & Systems
Who am I?
My name is Herbert Julius Garonfolo, and I work as a freelance IT consultant with a huge interest in the intersection between technology, data and finance.
Especially, I find it interesting how efficient IT solutions can be used to run a company in the most optimal way and support important decisions by uncovering valuable financial and operational insights.
I add value to your company by employing my many years of experience in the financial sector with my skills in solution design, financial reporting, coding and business development.
I am an experienced developer and solution architect, and I quickly feel at home in all kinds of coding, scripting and data handling environments (both legacy and cutting-edge platforms).
Advanced Analytics | Financial Business Intelligence | Solution Selling | Banking | Finance | Treasury | Cash Management | Regulatory compliance | Insurance | Financial Risk Management | Forensics | Solution Architect | Data Warehouse | Data Analytics | Machine Learning | Python | R | SAS | SQL | Microsoft SQL Server | MySQL / MariaDB | Linux | Java | C# | PHP | Git | Docker | AS/400 | DB/2 | z/OS | SAP R/3 and S/4HANA | Microsoft Dynamics | RPA | Automation Anywhere | Uipath | Salesforce CRM | JSON | XML | REST APIs
Focus areas and selected experience
Back-office IT systems - design and development
I have successfully created several back-office applications that handle e.g. invoicing, CRM, financial risk and accounting
I feel at home with both cloud-based (AWS / Azure) and on-premise platforms
Solution design and IT architecture
I have successfully designed many different IT systems by understanding user requirements, business processes and legal compliance
I employ a structured approach designing the IT architecture and business process flows together with the business and IT department
I am a trained software developer and business economist, and I am good at combining both worlds
Process optimization using machine learning and advanced data analytics
Invoice recognition and automatic handling
Processing of e-mails, contracts or other digital documents by automatically understanding the topic of the e-mail
Extraction of text from forms with hand-writing and text extraction from PDFs
Extraction of text from pictures (e.g. validate a picture of a drivers license)
Advanced forecasting of demand, supply or inventory levels including seasonal elements and trends
AML analytics and fraud detection: Visualizing how information flows in a network of computers, people or bank transactions
Management: IT development manager or Head of IT
I have worked for several years as IT Manager and Head of IT development
Combining budgets, risk and costs with business value, communication and stakeholder management
I have successfully completed IT audits, cybersecurity audits, pen-tests and the like
Data validation
Data quality framework and reporting
Measuring data quality and prioritising efforts
Data cleaning using advanced methods such as machine learning and advanced statistics
Validation of data using advanced rule-engines
Data migration
Moving data from legacy systems to modern platforms, e.g. mainframe, db/2 to modern data warehouse solution such as Microsoft SQL server
Consolidating many sources of information into a general data model
Validating the data and implementing unit tests in data pipelines
Handling big data (Apache Spark, Teradata, tables with millions of rows)
Data warehouse development
Data modelling based on business requirements
Designing the data warehouse
Creating a BI solution on top of the data warehouse
Implementing or improving data sources and ETL
Fixing bugs and improving performance
Expert knowledge on databases (SQL, no-SQL) and database servers
Data modelling
Understanding users, compliance and technical requirements, I am able to create a holistic data model that delivers the optimal value in the context
Agile data model design
Leading workshops and requirement specification
Product owner
I have many years of experience working in agile software development as a Product Owner or Scrum Master
As a product owner I benefit from understanding both the business and IT side. This leads to good solutions and efficient bridge building and communication between the business and IT department
I can juggle prioritisations related to business value and IT costs, and make efficient choices and suggestions
Server management and dev-ops
I have many years of hands-on experience setting up servers and handling dev-ops
I have designed and created deployment frameworks and processes that include checkpoints, quality assurance and proper testing
I understand networking, firewalls, DNS and ISO compliance and I can assess and mitigate security risks