S M Shafiqul Islam, Developer in Dhaka, Dhaka Division, Bangladesh

S M Shafiqul Islam

Software Developer

Location
Dhaka, Dhaka Division, Bangladesh
Toptal Member Since
June 18, 2020

Shafiqul is an expert in project, product, IT process, and large-scale team management, database, and architecting software solutions with more than 13+ years of working experience in multinational conglomerates, software companies, and remote platforms. With a great combination of technical and leadership skills, he has developed and implemented numerous IT projects across the globe. An empathetic communicator and leader, Shafiqul employs both traditional project management and Agile.

S is available for hire
Hire S

Portfolio

BRAC Bank
Databases, API Integration, Mobile, Web, SQL, Microsoft Power BI...
Asalat Al-Sharq For General Trading...
Oracle, Oracle PL/SQL, C#, Database Design, Relational Databases...
Deligram
MySQL, React, Vue, PHP, IT Projects, Stored Procedure, SQL Stored Procedures...

Experience

Database Administration (DBA) - 13 yearsSQL - 12 yearsOracle - 12 yearsDatabases - 10 yearsDatabase Design - 10 yearsDatabase Modeling - 10 yearsMySQL - 8 yearsPostgreSQL - 3 years

Location

Dhaka, Dhaka Division, Bangladesh

Availability

Part-time

Preferred Environment

PL/SQL, SQL, MySQL, Oracle, Linux, Amazon Web Services (AWS), Databases, Database Administration (DBA), Database Design, Database Modeling

The most amazing...

...I worked as a database architect for Aurea Inc, where I had to consolidate many extensive volume databases into one, keeping performance intact.

Work Experience

2020 - PRESENT

Technical Delivery Manager

BRAC Bank
  • Managed the delivery of the internet banking app used by more than 400,000 customers for various financial transactions and bill payments.
  • Scaled up and tuned architecture to stabilize the application for the rapidly increased number of users.
  • Added new features continuously by integrating the API of different services.
  • Managed the digital onboarding application of this fastest-growing bank.
Technologies: Databases, API Integration, Mobile, Web, SQL, Microsoft Power BI, Database Migration, DAX, Power Query, Oracle 10g, Oracle Database Architecture
2022 - 2022

Oracle Database Architect (Contract)

Asalat Al-Sharq For General Trading, Solutions Systems Information Technology Co.Ltd
  • Investigated a long pending performance issue and provided a permanent solution with no performance bottleneck faced.
  • Designed a database for the new module in the existing ERP solution.
  • Implemented a physical standby database for backup and recovery.
Technologies: Oracle, Oracle PL/SQL, C#, Database Design, Relational Databases, Database Optimization, Data Engineering, Databases, Excel 365, Dashboards, PostgreSQL, Database Migration, Oracle 10g, Oracle Database Architecture
2019 - 2021

Head of Product and Database

Deligram
  • Managed the development of Deligram's eCommerce product for web and mobile, including Android and iOS.
  • Directed the successful rollout of every feature of this omnichannel eCommerce platform to generate tractions.
  • Planned, developed, and managed operations for other B2B products like dgKhata—a simple accounting for Mudir Dokan (small-scale retail stores), dgSupply—a B2B platform for ordering bulk products by the shopkeeper, and dgNow—a hyperlocal product.
Technologies: MySQL, React, Vue, PHP, IT Projects, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Microsoft Power BI, Data Architecture, Database Schema Design, SaaS, Oracle SQL, Oracle DBA, Data Analytics, Data Visualization, Data Engineering, Excel 365, eCommerce, Database Migration, Data-driven Dashboards, Business Intelligence (BI), DAX, Power Query, Oracle 10g, Oracle Database Architecture
2015 - 2018

Development Manager

Monstar Lab Bangladesh
  • Established PMO, managed multiple projects simultaneously, and oversaw resource allocation.
  • Ensured best practices, techniques, and tools for project planning, execution, project management, ongoing milestone/deliverable tracking, communication, and key performance metrics.
  • Provided software solutions for projects and served as a company strategic board member.
  • Contributed to developing the following projects: an Uber-like application for Japan Taxi, a video-enabled fashion eCommerce platform, and a parking eCommerce platform for the Japanese market.
Technologies: Amazon Web Services (AWS), MongoDB, Spring, MySQL, Project Management, Relational Database Services (RDS), Jakarta EE, IT Projects, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Technical Project Management, Redmine, Data Modeling, Oracle SQL Developer, SQLyog, Data Architecture, Database Schema Design, Oracle SQL, Oracle DBA, Data Analytics, Excel 365, Dashboards, eCommerce, Database Migration, DAX, Oracle 10g, Oracle Database Architecture
2016 - 2017

Senior Database Administrator | Database Architect

Aurea Inc (via an Online Freelance Agency)
  • Performed database consolidation for various types of databases.
  • Increased performance of queries and database server performance.
  • Created and monitored multiple databases that Aurea used and solved problems.
Technologies: IMPDP, expdp, exp, Document Management Systems (DMS), RMAN, PostgreSQL, MySQL, SQL, Oracle, ETL, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Amazon S3 (AWS S3), Data Architecture, Amazon RDS, Database Schema Design, Oracle SQL, Oracle DBA, Data Analytics, Excel 365, Dashboards, Amazon Aurora, Database Migration, Oracle 10g, Oracle Database Architecture
2014 - 2015

Database Head and Development Lead

Jaatra.net, MGH Group
  • Served as a group database administrator (DBA) of MGH Group. Led a Jaatra back office development project in creating accounting software for a travel agency.
  • Managed the software support and implementation team. Built a scalable database for the Jaatra.net portal and eCommerce solution for the travel industry.
  • Created a database for travel agency accounting software (ERP).
Technologies: Java, Reports, Forms, Accounting, Oracle, IT Projects, Toad, Oracle Forms & Reports, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Visio, Redmine, Data Modeling, Oracle SQL Developer, SQLyog, Data Architecture, Database Schema Design, Oracle SQL, Oracle DBA, Data Analytics, Excel 365, PostgreSQL, Database Migration, Business Intelligence (BI), Power Query, Oracle 10g, Oracle Database Architecture
2012 - 2013

Manager (IT) | Group DBA and Technical Lead

Jaatra.net, MGH Group
  • Led and managed the technical team. Contributed to SMART software development and customization.
  • Developed software to increase the efficiency of the Galileo GDS system, and led implementation for every subscription of SMART.
  • Led Jaatra.net portal development. Participated in Jaatra.net back office development of accounting software for a travel agency.
Technologies: PL/SQL, Java, Reports, Forms, Accounting, Oracle, IT Projects, Toad, Oracle Forms & Reports, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Visio, Redmine, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle DBA, Data Analytics, Excel 365, Database Migration, Business Intelligence (BI), Oracle 10g, Oracle Database Architecture
2012 - 2013

Manager (IT) | Group DBA & Technical Lead

Jaatra.net, MGH Group
  • Served as group DBA for MGH Group. Led and managed the technical team.
  • Contributed to SMART software development and customization. Developed software to increase the efficiency of the Galileo GDS system, and led implementation of subscriptions of SMART.
  • Led Jaatra.net portal development. Participated in Jaatra.net back office development. Designed, installed, and configured database and application server for an online portal.
Technologies: Oracle, SQL, PL/SQL, IT Projects, Toad, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Visio, Redmine, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle DBA, Data Analytics, Excel 365, Database Migration, Oracle 10g, Oracle Database Architecture
2011 - 2011

Assistant Manager | DBA & Developer

Jaatra.net, MGH Group
  • Led SMART back office and other software development teams across Bangladesh, Nepal, and Mauritius.
  • Served as a project development lead of Jaatra.net, the first online travel portal of Bangladesh. Developed software to increase the efficiency of the Galileo GDS system and led implementation for every subscription of SMART.
  • Performed database administration for all in-house and customer databases.
Technologies: XML, Java, Database Administration (DBA), Reports, Oracle Forms, PL/SQL, SQL, IT Projects, Toad, Oracle Forms & Reports, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Redmine, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle DBA, Data Analytics, Excel 365, Database Migration, Oracle 10g, Oracle Database Architecture
2010 - 2010

Senior Software Engineer | Database Developer

Jaatra.net, MGH Group
  • Acted as a key developer of the SMART software section. Development was based on user requirements. Tools included Oracle Forms 6i, Oracle 9i, and Oracle XML parsing.
  • Served as a group member to implement jaatra.net, the first online travel portal of Bangladesh. Tools included Jakarta EE and ORACLE.
  • Configured, monitored, and performance-tuned the database server and application server for jaatra.net (www.jaatra.net).
  • Provided support to the SMART Software across Mauritius, Madagascar, Nepal, and Bangladesh.
  • Provided full DBA support to the travel agency database with a proper recovery policy.
Technologies: Jakarta EE, XML Parsing, Oracle, Oracle9i, Oracle Forms, IT Projects, Toad, Oracle Forms & Reports, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle SQL, Oracle DBA, Excel 365, Oracle 10g, Oracle Database Architecture
2008 - 2009

Programmer

IICT, BUET
  • Configured Oracle physical standby database for database high availability and recovery.
  • Designed and implemented a database for BMET considering all business processes.
  • Collected new requirements, analyzed and designed database accordingly.
Technologies: Java, Oracle, IT Projects, Toad, Stored Procedure, SQL Stored Procedures, Oracle PL/SQL, Oracle SQL Data Modeler, Server Administration, Data Modeling, Oracle SQL Developer, SQLyog, Database Schema Design, Oracle SQL, Oracle DBA, Excel 365, Database Migration, Oracle 10g

Experience

DB Consolidation

https://www.aurea.com/
• Administered Oracle Database and improved performance by removing bottleneck due to significant volume.
• Database consolidation—moved small databases into big Amazon RDS for Oracle.
• Migrated database from another heterogeneous platform to Oracle.

Toku P

https://toku-p.earth-car.com/
Scope and solution details:
• Parking reservation eCommerce platform for Japan.
• Customers can reserve parking on a specific day, time for multiple slots.
• Parking owners upload and showcase their parking.
• Partner and admin to manage all things.

Technology included:
• Jakarta EE, Spring Framework
• Hibernate as ORM
• MySQL database
• AngularJS
• Google Maps
• AWS

Contribution:
• Acted as a project manager

runway.moda

Scope:
• Fashion eCommerce platform (unique featured) development
• Buy products from video

Solution details:
• Fashion eCommerce platform developed from where the product can be purchased from video by clicking on it.

Technology:
• Jakarta EE, Spring Framework
• Hibernate as ORM
• MySQL database
• AngularJS

Contribution:
• Acted as a project manager, solution architect, and database head.

Jaatra Back Office Development

Scope:
• With the advancement of technology, we needed to change our existing specialized travel agency back office system into a new web platform.

Solution details:
• It is cloud-based accounting software accessible from anywhere over the internet.
• It can fulfill the diversified requirements of travel agencies from different countries.
• It automates the travel agency business process.

Technology:
• Jakarta EE, Jakarta Server Faces (JSF) Framework
• Hibernate as ORM
• Oracle database
• JasperReports for reporting

Contribution:
• Acted as a project manager
• Major contribution in analyzing system and design, leading team for deliverables, and taking part in the development
• Server deployment and administration.

Galileo SMS Solution

Scope:
• SMS Solution for the travel agencies using Galileo GDS (Global Distribution System) to send an automatic SMS to the passenger when a ticket is confirmed.

Solution details:
• Developed a centralized software solution by which passengers get an automatic SMS when they ticket by Galileo GDS System.

Technology:
• C#,.NET and Crystal's reports were used for development.
• Visual Studio 2008 was used as the development tool.
• Runtime XML is captured from Galileo GDS, parses data, and generates a high graphical ticket with all relevant information.
The facility prints passenger tickets or emails passengers using Gmail's free mail server.
• Oracle database is used to schedule processes, generate and send SMS, and parse GDS-created XML.

Contribution:
• Acted as the leading developer.

Smart e-Ticket

Scope:
• Email solution for the travel agencies using Galileo GDS to send an automatic email to the passenger.

Solution details:
• Developed a database-independent software solution by which the agency owner can email the e-ticket to their passengers with their company information.

Technology:
• C#.NET and Crystal's reports were used for development.
• Visual Studio 2008 was used as a development tool.
• Runtime XML is captured from Galileo GDS, parses data, and generates a high graphical ticket with all relevant information.
• The facility provided to print a passenger ticket or email the passenger using Gmail's free mail server.

Contribution:
• Acted as the leading developer.

Jaatra.net Project Development (Outsourcing) and Implementation

Scope:
• With the growth of online business trends in Bangladesh, MGH decided to go for a new software implementation for travel agencies.
• The software will enable travel agencies to have a web presence, introducing a new sales channel for agencies.

Solution details:
• MGH decided to build a web portal that will connect to all major global distribution systems.
• The project was decided to be developed with a partnership with ANMsoft India.
• A survey was conducted to understand different travel agencies' needs.

Technology:
• Jakarta EE is the primary technology
• WebService is used to integrate the portal with the global distribution system (GDS)
• Oracle is the database

Contribution:
• Project technical manager while outsourcing development.
• Major contribution in testing, customization, implementation, application, and database server administration.

Galileo Management Information System (GBL-MIS)

Scope:
• Full software package for Galileo Bangladesh Ltd (sister concern of MGH) and other NDC for keeping track of assets, earned segments.
• Full automation of hardware purchase, distribution, and maintenance log.
• Competitive analysis report between investment and earned money from markets in terms of segments.

• Financial integration with the group's main accounting software technology:
• Oracle Application Server Forms and Reports Services
• The Oracle Application Server 10g

Contribution:
• Acted as the leading developer and project coordinator.

SMART Implementation in Mauritius, Madagascar, Nepal, and Bangladesh

Scope:
• Galileo, a sister concern of MGH, decided to spread the SMART software among travel agencies of the mentioned countries.
• The main target was to lock the existing customers by providing this software as a value-added service.
• Two major parts of the SMART implementation are sales and finance.
• Automatic data retrieval from the corresponding GDS, namely Amadeus, Abacus, and Galileo system, in the sales module, was a challenge.

Solution details:
• A major study was done to understand the country-specific business need.

Technology:
• Used Oracle Forms 6i for this implementation
• GDS data retrieval was designed in Java

Contribution:
• Acted as a developer.

Omnichannel eCommerce Platform

http://www.deligram.com
Developed and managed one of the leading eCommerce platforms of Bangladesh, focused on bridging the gap between online and offline shopping. We built a digital platform for mudir dokan (small-scale retail stores) and helped them create their digital presence.

Skills

Languages

Java, SQL, Stored Procedure, XML, C#

Tools

Redmine, SQLyog, Toad, Power Query, RMAN, Navicat, Oracle SQL Data Modeler, Visio, Microsoft Power BI

Paradigms

Database Design, Oracle Database Architecture, ETL, B2B, Business Intelligence (BI)

Platforms

Java EE, Oracle, Linux, Amazon Web Services (AWS), Mobile, Web

Storage

Database Administration (DBA), PL/SQL, Database Modeling, MySQL, Oracle SQL Developer, Databases, Oracle 10g, SQL Stored Procedures, Oracle PL/SQL, Oracle DBA, Amazon Aurora, Database Migration, PostgreSQL, Oracle9i, XML Parsing, Amazon S3 (AWS S3), Oracle RDS, MongoDB, Web SQL, Database Architecture, Oracle Database Tuning, Oracle SQL, Relational Databases

Industry Expertise

Project Management, Accounting

Other

Technical Project Management, IT Projects, Accounting Systems, Oracle Forms & Reports, Server Administration, Data Architecture, Amazon RDS, Database Schema Design, SaaS, Data Analysis, Data Analytics, Excel 365, Dashboards, eCommerce, DAX, Data Modeling, Data Visualization, Data Engineering, Data-driven Dashboards, Projects, Forms, Reports, Document Management Systems (DMS), exp, expdp, IMPDP, Relational Database Services (RDS), Data Migration, Data Administration, Backup & Recovery, Import/Export, Solution Architecture, APIs, API Integration, Data, Email, Database Optimization

Frameworks

Spring

Libraries/APIs

Vue

Education

2014 - 2016

Master of Business Administration Degree in Operations Management

East West University - Bangladesh

2004 - 2008

Bachelor's Degree in Information Technology

University of Peshawar - Pakistan

Certifications

MARCH 2020 - MARCH 2023

Project Management Professional (PMP)

Project Management Institute (PMI)

DECEMBER 2018 - PRESENT

Agile Certified Practitioner (PMI-ACP)

PMI

FEBRUARY 2016 - PRESENT

Scrum Master Certified (SMC)

SCRUMstudy

MAY 2008 - PRESENT

Oracle Database 10g Administrator Certified Associate

Oracle

SEPTEMBER 2007 - PRESENT

Oracle PL/SQL Developer Certified Associate

Oracle