S M Shafiqul Islam, Oracle Forms & Reports Developer in Dhaka, Dhaka Division, Bangladesh
S M Shafiqul Islam

Oracle Forms & Reports Developer in Dhaka, Dhaka Division, Bangladesh

Member since March 1, 2018
S M Shafiqul Islam is a database expert with more than 14 years of experience as a database developer, administrator, and architect in many international mid to enterprise-level organizations. Also, he is an Oracle Certified Developer and DBA. He got extensive expertise in database design, normalization, SQL, PL/SQL, database administration, backup and recovery, ETL, performance tuning, and more. He has the competitive advantage of working with many tools, including a cloud environment.
S is now available for hire

Portfolio

Experience

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.

Employment

  • Head of Product & Database

    2019 - PRESENT
    Deligram
    • Managed the development of Deligram's eCommerce product for web and mobile, including Android and iOS.
    • Managed 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
  • Senior Database Administrator | Database Architect

    2016 - PRESENT
    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 Inc used and solved problems.
    Technologies: IMPDP, imp, 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, AWS S3, Data Architecture
  • Development Manager | Project Manager

    2015 - PRESENT
    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. Served as a member of the company’s strategic board.
    • Contributed to the development of the following projects, including 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), AWS, 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 Head & Development Lead

    2014 - 2015
    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
  • Manager (IT) | Group DBA & Technical Lead

    2012 - 2013
    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
  • Manager (IT) | Group DBA & Technical Lead

    2012 - 2013
    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
  • Assistant Manager | DBA & Developer

    2011 - 2011
    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
  • Senior Software Engineer | Database Developer

    2010 - 2010
    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
  • Programmer

    2008 - 2009
    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

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
  • Tools

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

    Database Design, ETL
  • Platforms

    Java EE, Oracle, Linux, Amazon Web Services (AWS)
  • Industry Expertise

    Project Management, Accounting
  • Storage

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

    Technical Project Management, IT Projects, Accounting Systems, Oracle Forms & Reports, Server Administration, Data Architecture, Data Modeling, Projects, AWS, Forms, Reports, Document Management Systems (DMS), exp, expdp, imp, IMPDP, Relational Database Services (RDS), Data Migration, Data Administration, Backup & Recovery, Import/Export, Solution Architecture, APIs, API Integration, Data, Email
  • Frameworks

    Spring
  • Libraries/APIs

    Vue

Education

  • Master of Business Administration Degree in Operations Management
    2014 - 2016
    East West University - Bangladesh
  • Bachelor's Degree in Information Technology
    2004 - 2008
    University of Peshawar - Pakistan

Certifications

  • Project Management Professional (PMP)
    MARCH 2020 - MARCH 2023
    Project Management Institute (PMI)
  • Agile Certified Practitioner (PMI-ACP)
    DECEMBER 2018 - PRESENT
    PMI
  • Scrum Master Certified (SMC)
    FEBRUARY 2016 - PRESENT
    SCRUMstudy
  • Oracle Database 10g Administrator Certified Associate
    MAY 2008 - PRESENT
    Oracle
  • Oracle PL/SQL Developer Certified Associate
    SEPTEMBER 2007 - PRESENT
    Oracle

To view more profiles

Join Toptal
Share it with others