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, Database Management System, Oracle PLSQL

At Softaims, I’ve found a workplace that thrives on collaboration and purposeful creation. The work we do here is about more than technology—it’s about transforming ideas into results that matter. Every project brings a mix of challenges and opportunities, and I approach them with a mindset of continuous learning and improvement. My philosophy centers around three principles: clarity, sustainability, and impact. Clarity means designing systems that are understandable, adaptable, and easy to maintain. Sustainability is about building with the future in mind, ensuring that the work we do today can evolve gracefully over time. And impact means creating something that genuinely improves how people work, connect, or experience the world. One of the most rewarding aspects of working at Softaims is the diversity of thought that every team member brings. We share insights, question assumptions, and push each other to think differently. It’s this culture of curiosity and openness that drives the quality of what we produce. Every solution we deliver is a reflection of that shared dedication. I’m proud to contribute to projects that not only meet client expectations but also exceed them through thoughtful execution and attention to detail. As I continue to grow in this journey, I remain focused on delivering meaningful outcomes that align technology with purpose.

Main technologies

  • Fullstack Developer

    6 years

  • MySQL

    5 Years

  • SQL

    2 Years

  • MySQL Programming

    2 Years

Additional skills

  • MySQL
  • SQL
  • MySQL Programming
  • SQL Programming
  • Unix Shell
  • Microsoft Access Programming
  • Relational Database
  • Database Management System
  • Oracle PLSQL

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