Allen F. looks like a good fit?

We can organize an interview with Aldin or any of our 25,000 available candidates within 48 hours. How would you like to proceed?

Schedule Interview Now

Allen F. - Fullstack Developer, Data Science, Data Analysis

Working at Softaims has been an experience that continues to shape my perspective on what it means to build quality software. I’ve learned that technology alone doesn’t solve problems—understanding people, processes, and context is what truly drives innovation. Every project begins with a question: what value are we creating, and how can we make it lasting? This mindset has helped me develop systems that are both adaptable and reliable, designed to evolve as business needs change. I take a thoughtful approach to problem-solving. Instead of rushing toward quick fixes, I prioritize clarity, sustainability, and collaboration. Every decision in development carries long-term implications, and I strive to make those decisions with care and intention. This philosophy allows me to contribute to projects that are not only functional, but also aligned with the values and goals of the people who use them. Softaims has also given me the opportunity to work with diverse teams and clients, exposing me to different perspectives and problem domains. I’ve come to appreciate the balance between technical excellence and human-centered design. What drives me most is seeing our solutions empower businesses and individuals to operate more efficiently, make better decisions, and achieve meaningful outcomes. Every challenge here is a chance to learn something new—about technology, teamwork, or the way people interact with digital systems. As I continue to grow with Softaims, my focus remains on delivering solutions that are innovative, responsible, and enduring.

Main technologies

  • Fullstack Developer

    6 years

  • MySQL

    5 Years

  • SQL

    1 Year

  • MySQL Programming

    3 Years

Additional skills

  • MySQL
  • SQL
  • MySQL Programming
  • SQL Programming
  • Unix Shell
  • Microsoft Access Programming
  • Relational Database
  • Database Management System
  • Oracle PLSQL
  • Data Engineering
  • Data Science
  • Data Analysis

Direct hire

Potentially possible

Ready to get matched with vetted developers fast?

Let’s get started today!

Hire undefined

Experience Highlights

Created a data warehouse for a non-profit organiation.

This as an ETL to a data warehouse. The client wanted data extracted from a hosted application database to be able to create write reports against the data and provide management and statistical data to run the organiation. I extracted the data (using SQL) and created a database of the extracted data. Then I transformed the data into new tables that provided the data in a more usable form.

Design and Development of the Data Tier of a major Telecom Project

The application designs and builds telecom services automatically. Messages are received from a front end system that provide information about the service needed such as the end points (your house), the type of service (residential, business, data, video, etc) and the speeds required. The system figures out the best use of the available equipment and cables and creates a design, It then contacts the telecom equipment in the field and instructs it to create the correct service. The database was a combination of an inventory (of equipment, cables, spare and in-use ports and cable pairs, and existing services and what inventory items they are using and a set of specifications for available services that the Telecom company wished to sell. The database contained over 700 tables.. It included stored procedures and stored packages, triggers, and a java API for the business tier developers to access the database. This is a high performance, high volume application. 98% of orders for new or changed services flow through this application without human intervention. Many of the tables exceeded 1 million rows in production and several exceeded 10 million rows. The queries contained many complex joins and a lot of work went into performance and tuning the database and the queries. I was the database designer and lead developer for the data tier. The data tier included a java API for the business tier to receive the data they needed with understanding the underlying data structures.

Automated Process to Modify the Telecom Inventory database

The problem was that a Telecom company we upgrading the equipment in the field to new bigger, faster equipment with new services not available on their old equipment. The old equipment contained thousands of telephone services that had to be moved to the new equipment, both in the real equipment and in the inventory of the computer applications that supported the equipment. The hardware vendor supplied a process that allowed a tech installing the new equipment to backup the configuration information, install the new equipment and download the backed up configuration so the device could be swapped out in an hour or two. The problem was to get that information into the computer applications. There were literally thousands of local phone services that were served by that equipment. The only existing way to modify that code was having a person using the GUI to enter a work order for each service and push it through the system. It was estimated to take 1 to 7 days to update all the services through this process and of course it was error prone. There was an existing API that allowed work orders to be entered into the system but the applications that used that API did not have the information necessary to create work orders of this magnitude. They were built to transfer a single service because a port or cable pair became unusable. I built a front end system that queried the database for the existing services on the equipment to be replace and created API Commands to move the services from the old to the new equipment. It had a web front end to allow the service people to run this at what ever time the actual equipment was being replace (usually in the middle of the night). The process ran in the background while the equipment was being replaced and it finished before the new equipment was installed. It usually took about 30 to 45 minutes.

Cleaning Data Issues in a Production Database

The client was a large Telecom with a very large database that had many complex interactions. There were about a dozen common issues that usually occurred through the normal usage patterns. Since the application was designed to receive almost all orders for service from an upstream system, the data in this database had to be accurate and in sync or the orders would fail. The system expected and maintained a 98% flow through rate untouched by humans. I build a set of queries that would identify problems with out of sync or missing data. For some issues, I had enough information to actually fix the problem. For other,s I produced a report for the users to check out . I built a web front end using Oracle Apex.

Specialized Queries to help Users

The end users for a large Telecom application needed data to assist them in their normal work. The application did not provide this data directly. They had to look through several different application pages to collect the necessary information. I built several queries that produced each set of data in a single report tailored to the end users needs . I built a web front end to allow them to access the data as needed.

Education

  • New Jersey Institute of Technology

    Bachelor of Engineering (BEng) in Electrical engineering

    1966-01-01-1970-01-01

  • Stevens Institute of Technology

    Master of Computer Applications (MCA) in Computer Science specializing in Relational Databases

    1995-01-01-1998-01-01

Languages

  • English