Anmar is available for hire

Anmar Amdeen

Verified Expert in Engineering

Full-stack Developer

Elgin, IL, United States

Toptal member since May 29, 2024

Expertise

Data Engineering Excel Macros Windows Development Visual Basic Database Excel Development SQL Server VB.NET Classic ASP SQL VBA

Bio

Anmar is a senior full-stack developer with over 25 years of experience. Passionate about continuous learning, he adeptly adopts new technologies to tackle real-world challenges. With a self-taught, versatile skill set and a resilient 'can-do-anything' attitude, Anmar's expertise spans ASP.NET, SQL, Bootstrap, Excel VBA, Git, jQuery, JavaScript, and Java, with a commitment to ongoing technical growth. He will be a great addition to any team.

Portfolio

F&G Annuities & Life

Excel VBA, Visual Basic for Applications (VBA), Excel 365, Microsoft Excel...

JPMorgan Chase

VB.NET, Oracle, Jira, Documentation, Databases, Agile Software Development...

Here Technologies

Excel VBA, ASP.NET, Classic ASP, SQL, Visual Basic for Applications (VBA), Ajax...

Experience

Excel VBA - 20 years
Databases - 20 years
Visual Basic for Applications (VBA) - 20 years
Classic ASP - 10 years
SQL Server Management Studio (SSMS) - 10 years
Visual Basic .NET (VB.NET) - 10 years
REST API Clients - 7 years
ASP.NET - 5 years

Availability

Full-time

Preferred Environment

Windows, Excel VBA, SQL Server Management Studio (SSMS), Visual Studio, Visual Basic, Visual Basic .NET (VB.NET), ASP.NET, Classic ASP, Visual Basic for Applications (VBA), Visual Studio Code (VS Code)

The most amazing...

...thing I've created is an Excel tool for offline data collection that syncs with an SQL database once an internet connection is available.

Work Experience

Lead Application Developer

2023 - 2024

F&G Annuities & Life

Developed Excel VBA tools to handle heavy datasets and calculations, enabling auditors to analyze and detect outliers in large data files.
Cut data processing time from two hours to 38 minutes by employing a mix of innovative formulas and hybrid formula/VBA macro approaches.
Halved auditors' time expenditure by crafting Excel VBA tools for auto-downloading data sets via REST API, which aligned with corporate standards.

Technologies: Excel VBA, Visual Basic for Applications (VBA), Excel 365, Microsoft Excel, Data Engineering, JSON, Reporting

Senior Full-stack Engineer | Manager Level

2019 - 2021

JPMorgan Chase

Attained a stable application status by maintaining and updating a VB.NET desktop application with Oracle connectivity and updating several aspects of the application based on user and regulation changes.
Improved the efficiency and accuracy of Oracle query executions by advising on the selection process and methodology enhancements.
Created comprehensive documentation for a thick client application to facilitate future system upgrades.

Technologies: VB.NET, Oracle, Jira, Documentation, Databases, Agile Software Development, Excel 365

Quality Tools Developer

2014 - 2017

Here Technologies

Built the Excel VBA tool TeeMan to enhance data entry accuracy and eliminate errors for field drivers collecting data for the quality team.
Accelerated data transfer processes by creating an SQL Server solution that uploads data from global collection offices using standardized Excel VBA tools, replacing outdated tally sheets.
Developed statistical tools to analyze data from field drivers using technologies like ASP, SQL, Ajax, and more.

Technologies: Excel VBA, ASP.NET, Classic ASP, SQL, Visual Basic for Applications (VBA), Ajax, REST APIs, REST, APIs, REST API Clients, jQuery, JavaScript, Agile Software Development, Web Development, Jira, Microsoft Excel, Data Engineering, JSON, HTML, CSS, SQL Stored Procedures, Reporting

Lead Excel VBA Developer

2012 - 2014

Abbott Laboratories

Resolved issues with processing large Oracle records into Excel by segmenting the query into parts.
Enhanced Oracle Java Application Control Language (JACL) process efficiency and reduced daily spreadsheet file sizes by modifying code in Oracle IOP.
Led the initiative to improve application usability by adding controls for users to navigate to specific pages of Oracle IOP results within an Excel interface.

Technologies: Excel VBA, Visual Basic for Applications (VBA), Oracle, Java, Complex Problem Solving, Microsoft Excel, Data Engineering, JSON, Reporting

Experience

BoldCodes

https://boldcodes.com

Developed an online repository for code functions—concise blocks or snippets—that serve as foundational components for new projects. Since 2002, I've compiled these functions for rapid accessibility, facilitating the swift creation of complex tools.

The platform permits user registration through LinkedIn credentials, automatically crafting a developer profile upon initial login, utilizing LinkedIn's login REST API.

TeeMan

https://anmar.co/Products/Pf-TeeMan/

Designed a hybrid offline/online tool that allows data collectors in the field to download a tally sheet for a particular city, work on it offline while on the road, and subsequently synchronize the completed tally sheet with the database upon returning to the office.

This advanced tool, which integrates Excel with an SQL database, also features a web interface enabling statisticians to analyze the collected data and transform it into meaningful metrics and KPIs.

7Bricks

https://7bricks.com

Inventory management tool tailored to catalog and track collectibles (like die-cast cars or LEGO sets for LEGO enthusiasts). This versatile application can also be adapted to manage a wide array of inventory or hobbyist collections.

MyResume

https://MyResume.cc

Launched a complimentary platform for hosting PDF resumes, enabling users to log in with their LinkedIn credentials and upload their resumes as PDFs or Word documents. Users can share their resumes through an easily rememberable link. The service leverages LinkedIn's login REST API and an SQL database for functionality.

Education

2000 - 2004

Bachelor's Degree in Computer Science

University of Technology - Baghdad, Iraq

Skills

Libraries/APIs

jQuery, REST APIs

Tools

Visual Studio, Microsoft Excel, Excel 2010, Excel 2007, Excel 2013, Excel 2016, Jira, Power Query

Languages

Excel VBA, Visual Basic, Visual Basic .NET (VB.NET), Visual Basic for Applications (VBA), SQL, HTML, JavaScript, CSS, VB.NET, T-SQL (Transact-SQL), Visual Basic 6 (VB6), Stored Procedure, C#, Java, PHP

Frameworks

ASP.NET, Classic ASP, .NET

Platforms

Windows, Visual Studio Code (VS Code), Microsoft Edge, Oracle, Alteryx

Storage

SQL Server Management Studio (SSMS), Databases, Microsoft SQL Server, SQL Views, MySQL, JSON, SQL Stored Procedures

Paradigms

Agile Software Development, REST, ETL

Other

Development, Documentation, Data Engineering, Excel Macros, Excel Expert, Reporting, REST API Clients, Data Migration, APIs, Web Development, Excel 365, Complex Problem Solving, Ajax

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.

Share your needs

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

Choose your talent

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

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