Banner Image

Skills

  • Design
  • Oracle
  • SQL
  • Analysis
  • App Development
  • Clustering
  • Database Development
  • Db Design
  • ERwin
  • Etl
  • Financial Analysis
  • Microsoft
  • Microsoft SQL Server
  • Microsoft SQL SSRS
  • MySQL

Sign up or Log in to see more.

Services

  • DB Architect

    $11/hr Starting at $25 Ongoing

    Dedicated Resource

    I am Ahmed Mustafa, having nine Microsoft Virtual Academy certifications, working currently as Principal Database Administrator at CMMI 5 www.netsoltech.com for five years along with successful freelancing...

    AnalysisClusteringDatabase DevelopmentDesignEtl

  • DB Design, Revamp and Optimization

    $21/hr Starting at $27 Ongoing

    Dedicated Resource

    I have more than seven years extensive DB Design and re-vamp experience. During this I have successfully improved hundreds of complex reports stored procedures and load intensive applications and have...

    App DevelopmentDb DesignDesignERwinFinancial Analysis

About

I have more than seven year experience involving DB Design, Revamp, Optimization, Migration and Administration consultancy with major experience as Database Architect(PSE) at CMMI 5 Netsol IT Village (www.netsoltech.com ) of more than five years and recent experience with Crossover as Level 2 DBA (www.Crossover.com). I having nine online DB and DW certificates, dual bachelors in Economics, CS and Physics, Maths.

I have extensively worked on Amazon RDS, SQL Server (version 2000 to 2017) , SQl Azure, MYSQL (5.5,-8.0), Oracle (9i, 10g, 11g) , Postgres (9.3, 9.4) ,BIDS, AWS Aurora, VB.Net, SSDT, SSIS,SSAS,SSRS, PowerBI, ERwin, ER Studio, Vertabelo, MySQL (5.6,5.7) , MariaDB, Postgres (9.4, 9.6) and tweaked SAN storage and RAID deployments for optimized DB and DW response.

I have re-vamped hundreds of complex dayend and monthend batches and solved many complex concurrency issues of transaction intensive applications.Further, I have been nominated by two awards at Netsol, have been awarded Team of month award on successful optimization of ERP for BMW Auto Finance China and performance excellence award on revamping Month-end batches of Daimler Auto Finance from five hours to minutes.

I have lead and designed from scratch University Automation Project for International University of Madinah which involved ETL and migration from legacy system and 3- tier architecture of WEB , API and Mobile based application with Cache DBs in SQLite and centralized DB in SQL Server.It contained many dashboards as well for giving insights to senior management of university.

I have also designed from scratch a PostgreSQL based DB for Medical team in USA to support 10k concurrent connections.

Best Regards.