Marc A Hilbert, Developer in Buenos Aires, Argentina
Marc is available for hire
Hire Marc

Marc A Hilbert

Verified Expert  in Engineering

Bio

Marc has worked in IT since he was 16. He has been a programmer, analyst, manager, business owner, and database specialist. He has a strong background in banking apps and has worked extensively on libraries, construction, and manufacturing projects. He is most comfortable with back-end database roles. Marc has solid analytic skills. He values and provides clear communication and enjoys working on projects that capture his imagination.

Portfolio

MineMaven
Database Architecture, Relational Database Design, Relational Databases...
Cartea Daliei - Toptal Volunteer
PostgreSQL, Supabase, Non-governmental Organizations (NGOs)
IUDU
Consumer Finance, SQL, SQL Server 2016, CRM Design, PostgreSQL, Microsoft Excel...

Experience

  • Requirements & Specifications - 20 years
  • Consumer Finance - 20 years
  • Functional Design - 20 years
  • SQL - 15 years
  • T-SQL (Transact-SQL) - 15 years
  • Microsoft SQL Server - 15 years
  • CRM Systems - 10 years
  • MySQL - 2 years

Availability

Part-time

Preferred Environment

Microsoft SQL Server, Relational Databases, Relational Database Design, MySQL, Functional Design

The most amazing...

...project I've designed and implemented was a database solution for managing and servicing 14,000,000 delinquent loans for a Brazilian consortium.

Work Experience

SQL DB Architect/Developer

2022 - PRESENT
MineMaven
  • Designed an SQL Server database to manage mine inventories and product quality throughout the entire mining cycle—from pit to port.
  • Developed and deployed stored procedures, views, scheduled jobs, sequences, triggers, and functions.
  • Integrated VBA and Power Query to interface with clients' Excel workbooks.
Technologies: Database Architecture, Relational Database Design, Relational Databases, SQL Server 2016, English, Database Design, Database Development, Databases, Reports, SQL Stored Procedures, Stored Procedure, Power Query, Query Optimization, Complex SQL Queries, Database Schema Design

Database Consultant

2024 - 2024
Cartea Daliei - Toptal Volunteer
  • Worked closely with a project manager to deliver functional and database design for an app used for student enrollment in free IT courses in Romania.
  • Provided assistance in database design and best practices.
  • Developed procedures and functions in Supabase (a derivative of PostgreSQL).
Technologies: PostgreSQL, Supabase, Non-governmental Organizations (NGOs)

Senior Database Consultant

2020 - 2022
IUDU
  • Worked as a senior database consultant for the deployment of a world-class financial package.
  • Undertook specification and development work for local customization and CRM integration.
  • Oversaw back-end testing and QA. Accompanied production rollout.
Technologies: Consumer Finance, SQL, SQL Server 2016, CRM Design, PostgreSQL, Microsoft Excel, Data Analysis, T-SQL (Transact-SQL), Requirements & Specifications, Oracle PL/SQL, Functional Design, CRM Systems, Data Modeling, MySQL, Database Design, Quality Assurance (QA), Database Development, Databases, Reports, PL/SQL, SQL Stored Procedures, Stored Procedure, Relational Databases, Relational Database Design, Database Modeling, Query Optimization, Complex SQL Queries, Database Schema Design, ETL, APIs, Financial Data, Business

Technical Manager

1995 - 2020
Pick Professional Center SRL
  • Served as a project manager in projects involving the development of many financially oriented software products for local banks and retailers.
  • Spearheaded the development of debt collection software as the manager, lead designer, and developer.
  • Managed and participated actively in developing materials management, invoicing, and AP and AR software for mid-sized industrial companies.
  • Implemented CRM solutions in banking environments.
  • Served as the lead database consultant for implementing certain modules of a major digital banking platform. Participated in the project from inception through post-production.
Technologies: Microsoft SQL Server, .NET, Microsoft Excel, T-SQL (Transact-SQL), Requirements & Specifications, NoSQL, Functional Design, Pick D3, UniData, Data Modeling, Database Design, Database Development, Databases, Reports, SQL Stored Procedures, Stored Procedure, Relational Databases, Relational Database Design, Data Migration, Excel VBA, Database Modeling, Database Migration, Query Optimization, Python, Database Schema Design, Business

Senior Consultant

2006 - 2008
AIG Consumer Finance
  • Migrated data for millions of consumer finance products from five different banks and various platforms as part of a startup for a new AIG company dedicated to servicing distressed assets.
  • Offered in-depth knowledge of the financial products behind the data along with data migration skills in this job.
  • Maintained regular interaction with team members and corporate representatives in English, Spanish, and Portuguese.
Technologies: Microsoft SQL Server, Data Migration, Data Integration, Debt Collection, Excel VBA, Visual Basic for Applications (VBA), Data Modeling, English, Database Design, Data Cleaning, Database Development, CSV File Processing, Databases, Reports, SQL Stored Procedures, Stored Procedure, Relational Databases, Relational Database Design, Database Migration, Data Engineering, Complex SQL Queries, Database Schema Design, Financial Data

Experience

Colega | Debt Collection System

Colega is debt collection software used by many retailers and financial institutions. I authored and designed many of its modules, including its collections strategy motor, call center, legal, and field collections modules.

Multiplatform Customer Support System

Served as a group leader in designing, creating specifications, and delivering QA and implementation work for a customer service requirements system for a bank. Results included the integration of requirements from the call center, mobile app, chats, and IVR. I created a methodology for the timely resolution of work orders. I also performed daily, often hands-on, interaction with developers and weekly reviews.

GE Consumer Finance CRM

Managed the implementation and systems roll-out of customer service and telemarketing solutions for GE Consumer Finance in Argentina. I had substantial interactions with key department managers for the implementation of issue workflows.

Database Designer/Developer for a Multi-practice Dental App

A multi-practice dental system on which I worked as a database designer and developer. The software was oriented toward clinical—non-billing—aspects: dental exams, diagnosis, treatment plans, clinical notes, and patient history.

Oracle PL/SQL Design and Development

The client was a large financial institution specializing in consumer finance. Provided for several years Oracle PL/SQL and SQL Server expertise in developing and maintaining the following applications: Personal Loans, Mastercard, and Debt Collection. From this client and many others, I gained substantial knowledge of how loans are approved and the financial calculations involved.

Skills

Libraries/APIs

Complex SQL Queries

Tools

Microsoft Excel, Erwin, Microsoft Power BI, Power Query

Languages

T-SQL (Transact-SQL), SQL, Stored Procedure, Excel VBA, Visual Basic, Visual Basic for Applications (VBA), Visual Basic 6 (VB6), Python

Paradigms

Database Design, Database Development, ETL

Platforms

Pick D3, Windows, Oracle

Storage

PostgreSQL, Oracle PL/SQL, UniData, Microsoft SQL Server, Databases, SQL Stored Procedures, Relational Databases, Database Modeling, MySQL, Database Migration, Database Architecture, SQL Server 2012, SQL Server 2016, PL/SQL, NoSQL, Data Integration

Frameworks

.NET

Other

CRM Systems, Consumer Finance, Debt Collection, Requirements & Specifications, CRM Design, Functional Design, Reports, Data Modeling, Relational Database Design, Data Migration, Finance, Design Specifications, English, Data Engineering, Query Optimization, Database Schema Design, Financial Data, Customer Service Strategy, Data Analysis, Data Cleaning, CSV File Processing, CSV, Data Analytics, Data Cleansing, APIs, Business, Quality Assurance (QA), Supabase, Non-governmental Organizations (NGOs)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring