Muhmud Ahmad, Data Warehousing Developer in Kuala Lumpur Federal Territory of Kuala Lumpur, Malaysia
Muhmud Ahmad

Data Warehousing Developer in Kuala Lumpur Federal Territory of Kuala Lumpur, Malaysia

Member since March 8, 2016
For the past 20 years, Muhmud has been working with database systems, with most of that time spent in the UK. He mainly specializes in MS SQL development, but he has also worked extensively with Oracle, MySQL, and PostgreSQL. He is able to function as both a database developer/architect as well as a DBA. Muhmud has worked on a number of BI (business intelligence) projects using SSAS and has exposure to NoSQL solutions such as Riak and Vertica.
Muhmud is now available for hire

Portfolio

Experience

Location

Kuala Lumpur Federal Territory of Kuala Lumpur, Malaysia

Availability

Part-time

Preferred Environment

MS SQL, Oracle, PostgreSQL, MySQL, NoSQL

The most amazing...

...project I've worked on was to create a transformative transactional replication system for creating low latency reporting systems for MS SQL using .NET.

Employment

  • Database Architect | Java Lead | AWS Architect

    2018 - PRESENT
    Open Practice Solutions (via Toptal)
    • Designed a database, optimized queries, indexed, and performed administration work for MySQL.
    • Designed and deployed a new MySQL database environment to an AWS-based Galera cluster with ZFS storage.
    • Led the design and development of new micro-services environment using Java and Spring WebFlux.
    • Containerized application deployments and migrated to Docker.
    • Built from scratch the AWS cloud environment, including site-to-site VPN, cross-site DNS, AWS Auto Scaling, database deployment, Redis caching, and more.
    Technologies: MySQL, Java, Spring Boot 2, Spring 5, Reactive Core
  • Technical Writer

    2017 - PRESENT
    IOD (via Toptal)
    • Wrote technical articles, whitepapers and blog posts for NetApp relating to their latest cloud offerings, including ONTAP Cloud and Cloud Sync.
    • Worked with stakeholders to create ideas for new articles, determine article scope and review changes.
    • Performed proof-of-concept and performance testing work in AWS with ONTAP Cloud in order to provide statistics and test results for various articles.
    • Ensured the technical accuracy of articles produced by other writers.
    Technologies: NetApp, AWS, Azure, Database Systems
  • Database Architect | Node.js Developer

    2018 - 2019
    Perdoor (via Toptal)
    • Designed and implemented a back-end RESTful API for mobile property app, including a database design and development using MySQL.
    • Developed Node.js and JavaScript API using Express.js and Swagger.
    • Worked with project owner to aid in product development and design of the iOS mobile app UI.
    • Deployed all back-end services to AWS and the setup of cloud-based dev/test environments.
    Technologies: MySQL, Node.js, JavaScript, AWS
  • AWS RDS/PostgreSQL Database Developer

    2018 - 2018
    Quick, Inc. (via Toptal)
    • Designed new, relational database schema in PostgreSQL for migration to AWS RDS from existing Firebase system.
    • Created the full documentation, including database diagrams, design overview, additional functionality, such as for encryption-at-rest & field-level encryption, etc.
    • Built models in JavaScript using the Objection.js ORM for access to the database with tests created for basic CRUD operations.
    • Constructed a mechanism for automatic PostgreSQL types to JSON handling in JavaScript which allows for easy data manipulation in the client and structured storage in the database server.
    • Created other JavaScript database maintenance functions such as for adding values to PostgreSQL enums, generating unique user-friendly ID values with efficient duplicate handling, etc.
    Technologies: AWS, RDS, PostgreSQL, Firebase, Node.js, JavaScript, Objection.js
  • Database Designer | Node.js Developer

    2017 - 2018
    Humanlytics (via Toptal)
    • Completely redesigned an MS SQL database system created by Chinese developers which required working with the team in China through translated Skype sessions to understand the requirements.
    • Wrote migration scripts to populate the new database schema from the existing data as well as performing a reconciliation to ensure migrated data was accurate.
    • Developed a RESTful API from scratch using Node.js (ESLint, Flow, Jest, Sequelize) and based on the newly developed database system.
    • Created API endpoints for reporting that enabled users to specify custom data warehousing style aggregate queries to return data for the dashboards and reports.
    • Implemented Apache Solr to provide search capability for customers, personnel, departments, and more. Developed independent business logic modules for salary calculation with full unit test coverage.
    • Managed the set up and deployment of the API and front-end UI in AWS and Ali Cloud using Docker. Created a daily database refresh mechanism for the new database system hosted in Ali Cloud RDS.
    Technologies: MS SQL, Node.js, JavaScript, Business Intelligence, Reporting
  • Data Engineer | BI Developer

    2017 - 2017
    Cartful Solutions, Inc. (via Toptal)
    • Developed complex reporting functions in SQL for event data stored in Amazon RDS for PostgreSQL.
    • Made significant use of PostgreSQL JSON support to query event payloads.
    • Designed a reporting schema for the data to be hosted on Amazon RedShift.
    • Developed an ETL process for the event data to be loaded into the reporting schema.
    Technologies: PostgreSQL, RDS, RedShift, SQL, JSON
  • CTO

    2015 - 2016
    Vedel IT Sdn Bhd
    • Developed a back-end REST API for an in-house recruitment system using Java and PostgreSQL.
    • Took ownership of the technical evaluation for new hires in various technology areas.
    • Provided presales technical consultations for prospective clients.
    • Performed structured evaluations of competing third-party software platforms for the company's back-office processes.
    • Implemented the line management for the company's internal IT team.
    Technologies: Java, PostgreSQL, REST, AngularJS
  • SQL Server BI Architect

    2015 - 2015
    Cubic Transportation Systems Ltd.
    • Designed and implemented a project that involved an accounting and operations data warehouse using SQL Server 2014 Analysis Services.
    • Developed a web application to manage invoicing information using ASP.NET MVC and AngularJS.
    • Built a back-end SOAP web service in C# to support the invoicing application's front-end.
    • Implemented an SSIS ETL process to pull data from multiple data sources, including Oracle.
    • Performed on-call support for the TfL's (Transport for London) SQL Server infrastructure.
    Technologies: MS SQL, SSIS, SSAS, SSRS, ASP.NET, SOAP, MVC, AngularJS, Oracle
  • MySQL Database Administrator and Developer

    2013 - 2015
    City Link Ltd.
    • Migrated and upgraded MySQL servers from a physical to a virtual cloud—including a configuration review, performance testing of new servers, and setup of replication for high availability.
    • Developed a message processing back-end system using Java, RabbitMQ, and Memcached for the processing of over a million real-time messages per day.
    • Built a WebSockets-based web front-end dashboards for real-time reporting using D3.js.
    • Assessed various NoSQL solutions, including Redis and Riak, to be used alongside MySQL.
    • Designed and implemented a financial data warehouse using SQL Server Analysis Services.
    Technologies: MySQL, Java, RabbitMQ, Memcached, Web Sockets, D3.js, MS SQL, SSAS
  • Database Architect

    2006 - 2013
    Aspect Capital Ltd.
    • Rearchitected the legacy environment from multiple different platforms including Oracle and MySQL to a single platform MS SQL environment with a clear separation of OLTP and reporting.
    • Implemented a system on top of the NetApp SAN infrastructure to provide a snapshot-based backup/restore—as well as the instant creation of writable clone copies—for databases of any size, for testing.
    • Set up a database mirroring for high availability as well as implementing PowerShell scripts to perform failovers.
    • Developed a transformative transactional replication system using C++/CLI and MS SQL features, such as CDC and Service Broker, to implement a real-time reporting system.
    • Performed a POC for three different competing platforms to host a financial tick database holding row volumes in the billions, including Oracle HCC (Hybrid Columnar Compression) and Vertica.
    • Implemented a PowerShell-based SQL Server build system for performing repeatable server builds—allowing for full OS and database server configuration.
    • Implemented a Windows service using C++/CLI to manage the MS SQL database environment—including backups, maintenance, archiving, monitoring, and documentation.
    Technologies: MS SQL, Oracle, Java, C/C++, C++/CLI, NetApp, Oracle, Vertica, Zenoss, PowerShell
  • MS SQL DBA and Developer

    2003 - 2006
    Newchurch Ltd.
    • Administered to an MS SQL server for a two-node failover cluster environment hosting externally-accessed reporting back-end.
    • Maintained Oracle development servers as well as providing support and advice to .NET and database developers.
    • Designed and implemented a large-scale Oracle batch processing system using PL/SQL and Java.
    • Implemented a data transformation system for hospital episode statistics using Oracle and featuring complex multi-row calculations.
    Technologies: MS SQL, Oracle, PL/SQL, Java, .NET, DTS, Failover Clustering, Linux
  • Developer

    2000 - 2003
    The Retail Experience Ltd.
    • Developed a handheld-based productivity system for a major footwear retailer.
    • Performed a POC for using MS SQL replication for managing the distribution of data to 300 remote sites.
    • Implemented a complex reporting SQL for the company's back-end MIS reporting system.
    • Implemented the commission part of the system—including application development and back-end SQL reporting.
    Technologies: Visual Basic, MS SQL

Experience

  • Smart.SqlClr (Development)
    https://github.com/muhmud/Smart.SqlClr

    This is a SQL CLR library implemented in C++/CLI that adds many interesting data types and utilities to an MS SQL database, including: lists, maps, SortedMaps, Tuples, and more.

  • LessQL (Development)
    https://github.com/muhmud/lessql

    A hacked version of the Linux-less utility that anchors the first three rows of output which can be useful when using command line SQL utilities.

Skills

  • Languages

    T-SQL, SQL, Java, C#, C++/CLI, XML, XSLT, MDX, Bash, XSD, C++, PHP, Python, JavaScript, Scala, CSS3, HTML5
  • Tools

    SSAS, SSRS, Eclipse IDE, Maven, Emacs, Solr, Jira, Git, Docker Compose, Visio, AWS SES, Microsoft Visual Studio, RabbitMQ, TFS, Erwin, AccuRev, ScalaTest, AWS SDK, GitLab
  • Paradigms

    ETL, Entity-relationship Diagrams, Business Intelligence (BI), Test-driven Development (TDD), Scrum, REST, OLAP, Model View Controller (MVC), Functional Programming, Behavior-driven Development (BDD), Reactive Programming
  • Storage

    Database Administration (DBA), Database Modeling, Microsoft SQL Server, MySQL, Database Replication, NetApp, Oracle PL/SQL, PostgreSQL, JSON, SQL Server Integration Services (SSIS), Vertica, NoSQL, Redis, Riak, Memcached, AWS S3
  • Other

    Data Warehousing, Query Optimization, Software Developer, Business Continuity & Disaster Recovery (BCDR), SANs, SSH, High Availability, SMO, Entity Relationships, SOAP, SCOM, WebSockets, Clustering, IIS, RESTful APIs, High Availability Disaster Recovery (HADR), Cloud
  • Frameworks

    Spring, Windows PowerShell, .NET, JUnit, Dropwizard, Hibernate, Spring 5, Express.js, Swagger, Spring Boot, AngularJS, Lift, JNI
  • Libraries/APIs

    Node.js, D3.js
  • Platforms

    Oracle, AWS EC2, Linux, Windows Server, Docker

Education

  • Bachelor's degree in Computer Science (Software Engineering)
    1996 - 2000
    Wolverhampton University - Wolverhampton, UK

To view more profiles

Join Toptal
I really like this profile
Share it with others