S M Shafiqul Islam
Software Developer
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.
Portfolio
Experience
Database Administration (DBA) - 13 yearsSQL - 12 yearsOracle - 12 yearsDatabases - 10 yearsDatabase Design - 10 yearsDatabase Modeling - 10 yearsMySQL - 8 yearsPostgreSQL - 3 yearsAvailability
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
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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.
Experience
DB Consolidation
https://www.aurea.com/• 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/• 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
• 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
• 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
• 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
• 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
• 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)
• 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
• 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.comSkills
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
Master of Business Administration Degree in Operations Management
East West University - Bangladesh
Bachelor's Degree in Information Technology
University of Peshawar - Pakistan
Certifications
Project Management Professional (PMP)
Project Management Institute (PMI)
Agile Certified Practitioner (PMI-ACP)
PMI
Scrum Master Certified (SMC)
SCRUMstudy
Oracle Database 10g Administrator Certified Associate
Oracle
Oracle PL/SQL Developer Certified Associate
Oracle