Phone :+92 300 5510762

Email : a.mannan@3astech.com

Mani's Data chronicles

Blogs

Projects Details

Oracle Data Guard Deployment

Mar 2023 – Present

Associated with Flint International (For HPE)Associated with Flint International (For HPE)

Configure and Deployment of Oracle Data Guard for multiple clients and projects; Mission critical Database Systems up to size of 10TBConfigure and Deployment of Oracle Data Guard for multiple clients and projects; Mission critical Database Systems up to size of 10TB

Skills: Data Architecture · Cloud Computing · High Availability Architecture · Business Intelligence (BI) · Oracle Data Guard

 

Database Migration (On Premises to Cloud)

Nov 2022 – PresentNov 2022 – Present

Migration of production live databases systems from different source to cloud platforms:

-DB2 to AWS Aurora Migration
– Oracle to AWS RDS PostgreSQL migration
– SAP to AWS RDS PostgresqlMigration of production live databases systems from different source to cloud platforms: -DB2 to AWS Aurora Migration – Oracle to AWS RDS PostgreSQL migration – SAP to AWS RDS Postgresql

Skills: Data Architecture · Cloud Computing · High Availability Architecture · Business Intelligence (BI) · Oracle Data Guard

 

Oracle Database RAC Installation and Configuration

Nov 2022 – Present

Associated with Flint International (For HPE)Associated with Flint International (For HPE)

– Hardware Resource Sizing
– Oracle Real application cluster Installation & configuration as per project needs [48+RAC deployments]

Oracle 12cR1
Oracle 12cR2
Oracle 19c– Hardware Resource Sizing – Oracle Real application cluster Installation & configuration as per project needs [48+RAC deployments] Oracle 12cR1 Oracle 12cR2 Oracle 19c

Skills: Data Architecture · High Availability Architecture · Business Intelligence (BI)

 

Oracle Databases Migration

Nov 2022 – Present

Associated with Flint International (For HPE)Associated with Flint International (For HPE)

Oracle Database migration (100 + Database Systems); using migration techniques:

– Oracle Data guard switchover for hot systems with no downtime
– Hot Cloning Oracle PDBs Databases
– Oracle Backup and Recovery
– Plug/Unplug Approach
– Duplicate Database
– Oracle Data Pump
– Data Guard SnapshotOracle Database migration (100 + Database Systems); using migration techniques: – Oracle Data guard switchover for hot systems with no downtime – Hot Cloning Oracle PDBs Databases – Oracle Backup and Recovery – Plug/Unplug Approach – Duplicate Database – Oracle Data Pump – Data Guard Snapshot

Skills: Data Architecture · Cloud Computing · High Availability Architecture · Amazon S3 · Business Intelligence (BI) · Oracle Data Guard

 

Oracle Grid & Database patching

Nov 2022 – Present

Associated with Flint International (For HPE)Associated with Flint International (For HPE)

Plan and Perform Patching on various clients’ Database systems:;

-Oracle RAC-Grid patching for Production Systems (50+Database Systems)
-Database patching for Production Systems (50+Database Systems)Plan and Perform Patching on various clients’ Database systems:; -Oracle RAC-Grid patching for Production Systems (50+Database Systems) -Database patching for Production Systems (50+Database Systems)

Skills: Data Architecture · High Availability Architecture · Business Intelligence (BI) · Oracle Data Guard

 

Data Systems and Advance Analytics (DWH, BI, Data Science, Data Engineering and Visualization)

Feb 2022 – Nov 2022

Associated with The Entertainer (FLZ LLc)Associated with The Entertainer (FLZ LLc)

-System Integration and maintenance of B2B and B2C Data systems including:
1- Operational databases
2- Data Lake
3- Data Warehouse
4- BI & Data Analytics
5- Interactive business Dashboards-System Integration and maintenance of B2B and B2C Data systems including: 1- Operational databases 2- Data Lake 3- Data Warehouse 4- BI & Data Analytics 5- Interactive business Dashboards

Skills: Data Architecture · Cloud Computing · High Availability Architecture · Business Intelligence (BI)

 

Coporate Training – Advance Oracle Technologies (Database, RAC, Data Guard, Data Warehouse, ODI, Oracle BI/Analytics)

Sep 2019 – Feb 2022

Corporate Training Services for below clients:

• The Knowledge Academy UK – Team of 6+ Consultants in United States of America [OAS 5.9]
• The Knowledge Academy UK – Team of 12+Consultants in United Kingdom [OEMM]
• The Knowledge Academy UK– Teams of 8 Consultants in United Kingdom & New Zealand[ODI-12C]
• The Knowledge Academy UK – 6 x Batches – Team of 60+ Consultants in United Kingdom [OAS 5.9]
• World Bank – Team of Consultants [Data Warehouse & BI; ODI-12C, OBIEE-12C]
• Blue Peaks Consulting – Oracle 19C, 12C (DB Administration-OCP DBA, RAC, Data Guard, SQL Tuning]
• World Bank – Team of Consultants [Oracle DB Admin- 19c]
• World Bank – Team of Consultant [Oracle RAC, Performance & Tuning]
• Directorate General Immigration & Passport Head Quarters [Oracle 12c DB Administration II, Data Guard, RAC, Performance & Tuning, Oracle Utilities, DWH & BI Fundamentals-ODI, Oracle Analytics Server, OBIEE, DB Security Essentials]
• Blue Peaks Consulting [Ms SQL Server Administration 2014/2016/2017, Ms SQL Server development]
• Directorate General Immigration & Passport Head Quarters [Oracle DB Admin- 12c]
• Blue Peaks Consulting [Data Warehouse & BI Fundamentals, ODI, Oracle DB, Oracle Analytics Server/ OBIEE, Power BI]
• Ericsson Pakistan [ Oracle DB Administration & Advance DB Administration]
• Inbox Technologies [SQL Tuning]
• ACS Training Company [Big Data Foundation & Data Security]
• Central Asia Cellular Forum [ SQL, BI, Data Analytics]
• Data Warehouse & BI Training & Consultation [3G Technologies]
• UAAR & ICMA [DWH, BI, Big Data, Data Analytics]Corporate Training Services for below clients: 

• The Knowledge Academy UK – Team of 6+ Consultants in United States of America [OAS 5.9] 

• The Knowledge Academy UK – Team of 12+Consultants in United Kingdom [OEMM] 

• The Knowledge Academy UK– Teams of 8 Consultants in United Kingdom & New Zealand[ODI-12C] 

• The Knowledge Academy UK – 6 x Batches – Team of 60+ Consultants in United Kingdom [OAS 5.9] 

• World Bank – Team of Consultants [Data Warehouse & BI; ODI-12C, OBIEE-12C] 

• Blue Peaks Consulting – Oracle 19C, 12C (DB Administration-OCP DBA, RAC, Data Guard, SQL Tuning] 

• World Bank – Team of Consultants [Oracle DB Admin- 19c] 

• World Bank – Team of Consultant [Oracle RAC, Performance & Tuning] 

• Directorate General Immigration & Passport Head Quarters [Oracle 12c DB Administration II, Data Guard, RAC, Performance & Tuning, Oracle Utilities, DWH & BI Fundamentals-ODI, Oracle Analytics Server, OBIEE, DB Security Essentials] 

• Blue Peaks Consulting [Ms SQL Server Administration 2014/2016/2017, Ms SQL Server development] 

• Directorate General Immigration & Passport Head Quarters [Oracle DB Admin- 12c] 

• Blue Peaks Consulting [Data Warehouse & BI Fundamentals, ODI, Oracle DB, Oracle Analytics Server/ OBIEE, Power BI] 

• Ericsson Pakistan [ Oracle DB Administration & Advance DB Administration] 

• Inbox Technologies [SQL Tuning] 

• ACS Training Company [Big Data Foundation & Data Security] 

• Central Asia Cellular Forum [ SQL, BI, Data Analytics] 

• Data Warehouse & BI Training & Consultation [3G Technologies] 

• UAAR & ICMA [DWH, BI, Big Data, Data Analytics]

Skills: Business Intelligence (BI)

 

Modernize Database Systems Management – AWS Cloud

May 2021 – Jan 2022

Associated with NorthBay SolutionsAssociated with NorthBay Solutions

-RDS – PostgreSQL Performance Optimization
-RDS – SQL Server Performance Tuning
-AWS Infrastructure Optimization

Tools: AWS DMS, Cloud Watch, Performance Insight, Manage Engine, SQL Server Profiler, SQL Server EM-RDS – PostgreSQL Performance Optimization -RDS – SQL Server Performance Tuning -AWS Infrastructure Optimization Tools: AWS DMS, Cloud Watch, Performance Insight, Manage Engine, SQL Server Profiler, SQL Server EM

Skills: Data Architecture · Cloud Computing · High Availability Architecture · Amazon S3

 

Telecom Data Warehouse, Data Analytics and BIWarehouse, Data Analytics and BI

Feb 2014 – Sep 2020

-Systems Integration

-Data Feed Configuration
-Data Life Cycle implementation and maintenance
1-Operational Sources,
2-Data Lake, ETL/ELT, Data Storage
3- Backup and Recovery; Disaster Recovery
4- Data / Information Archiving
5- Metadata Management
6- Data Analytics/Aggregation, 

Summaries,Segments
7- Performance Optimization
8- RAC Database operations management-Systems Integration -Data Feed Configuration 

-Data Life Cycle implementation and maintenance 

1-Operational Sources, 

2-Data Lake, ETL/ELT, Data Storage 

3- Backup and Recovery; Disaster Recovery 

4- Data / Information Archiving 

5- Metadata Management 

6- Data Analytics/Aggregation, 

Summaries, Segments 

7- Performance Optimization 

8- RAC Database operations management

Skills: Data Architecture · Data Visualization · High Availability Architecture · Business Intelligence (BI)

 

Rawalpindi-Islamabad Metro Bus Project

Jul 2014 – Jan 2020

Show project

The greater Islamabad – Rawalpindi Metropolitan Area is the third largest in Pakistan with a population of over 4.5 million inhabitants. The high percentage of motorized traffic operating in Twin Cities causes traffic congestion and time delays. The Punjab Metrobus Authority intends to resolve the issue of public transportation in the twin cities through implementation of Metrobus System/Bus Rapid Transit. The Scope of the Project covers the following two areas:

1. Provision, commissioning, installation, calibration, integration, testing and execution of CCTV Surveillance System, Connectivity (Fiber Optic), Data Center (Server/Racks/Storages), Video Wall, Uninterruptible Power Supply, Data Cabinet, IP Telephony and Public Address System (IT Systems) for The Rawalpindi-Islamabad Metrobus System (including all hardware, software, networking, etc), and configuration, customization, deployment, and maintenance of the entire solution. (FROM SADDAR (Rawalpindi) TO PM SECRETARIAT (Islamabad)

2. Operations and Maintenance at PMA stations, Corridor and Command and Control Center and utilize the deployed IT Systems.

Its honor for me that Interactive Group management trusted my abilities and nominated me as a Project Manager for this project. The team I got is well professional and I have full support of my seniors and colleagues.The greater Islamabad – Rawalpindi Metropolitan Area is the third largest in Pakistan with a population of over 4.5 million inhabitants. The high percentage of motorized traffic operating in Twin Cities causes traffic congestion and time delays. The Punjab Metrobus Authority intends to resolve the issue of public transportation in the twin cities through implementation of Metrobus System/Bus Rapid Transit. The Scope of the Project covers the following two areas: 1. Provision, commissioning, installation, calibration, integration, testing and execution of CCTV Surveillance System, Connectivity (Fiber Optic), Data Center (Server/Racks/Storages), Video Wall, Uninterruptible Power Supply, Data Cabinet, IP Telephony and Public Address System (IT Systems) for The Rawalpindi-Islamabad Metrobus System (including all hardware, software, networking, etc), and configuration, customization, deployment, and maintenance of the entire solution. (FROM SADDAR (Rawalpindi) TO PM SECRETARIAT (Islamabad) 2. Operations and Maintenance at PMA stations, Corridor and Command and Control Center and utilize the deployed IT Systems. Its honor for me that Interactive Group management trusted my abilities and nominated me as a Project Manager for this project. The team I got is well professional and I have full support of my seniors and colleagues.

Other contributors

 

Disaster Recovery of Database Systems

Sep 2016 – Aug 2017

– DB High Availability

– Database replication
– DR Drill and Testing
Technologies: Oracle 11g,12c, SQL Server– DB High Availability – Database replication – DR Drill and Testing Technologies: Oracle 11g,12c, SQL Server

Skills: Data Architecture · High Availability Architecture · Oracle Data Guard

 

Telecom Fraud System Upgrade/migration – MTN Nigeria

Nov 2012 – Apr 2013

Associated with LM ERICSSON Nigeria Ltd.Associated with LM ERICSSON Nigeria Ltd.

Migrate existing Fraud System to new released, also migrate Database from Oracle 10g to 11g

Environment: Oracle 11g, SQL/Pl-SQL,SAS, Toad, Unix, Oracle Data Pump (expdp/impdp)Migrate existing Fraud System to new released, also migrate Database from Oracle 10g to 11g Environment: Oracle 11g, SQL/Pl-SQL,SAS, Toad, Unix, Oracle Data Pump (expdp/impdp)

Skills: Data Architecture · Data Visualization · High Availability Architecture · Business Intelligence (BI)

 

MTN Nigeria – Implementation and Management of Telecom Revenue Assurance System (a Data Warehouse,Data Analytics and BI system)

Jun 2009 – Oct 2012

Associated with LM ERICSSON Nigeria Ltd.Associated with LM ERICSSON Nigeria Ltd.

Phase by Phase development,testing, implementation and migration(and maintenance) of System which was completed in 5 Phases followed by Production Stability period. Post implementation was followed by a managed services (support SLA) period for more than a year

Environment: Oracle 10g, SAS, LTW, Toad,LAE, BRAIN, SQL, PL-SQL, Data files/Tablespace management tools, Unix,Oracle Data Pump(external tables, expdp/impdp, SQL Loader),Enter prize Manager,Oracle Performance Diagnostic Tools Phase by Phase development,testing, implementation and migration(and maintenance) of System which was completed in 5 Phases followed by Production Stability period. Post implementation was followed by a managed services (support SLA) period for more than a year Environment: Oracle 10g, SAS, LTW, Toad,LAE, BRAIN, SQL, PL-SQL, Data files/Tablespace management tools, Unix,Oracle Data Pump(external tables, expdp/impdp, SQL Loader),Enter prize Manager,Oracle Performance Diagnostic Tools

Skills: Data Visualization · High Availability ArchitectureSkills: Data Visualization · High Availability Architecture

Other contributors

 

Nigerian Mobile Telecommunications Company

Jun 2009 – May 2010

Associated with LM ERICSSON Nigeria Ltd.Associated with LM ERICSSON Nigeria Ltd.

After a successful delivery of a Fraud system the client requested for revenue assurance functionality where up on they requested Thomas to return. Some restruction of resources was made and Thomas was given the opportunity to assist in project management. Thomas was responsible for defining the scope, gather and analyze requirements, create a functional design, test the deliverables and train the end users.After a successful delivery of a Fraud system the client requested for revenue assurance functionality where up on they requested Thomas to return. Some restruction of resources was made and Thomas was given the opportunity to assist in project management. Thomas was responsible for defining the scope, gather and analyze requirements, create a functional design, test the deliverables and train the end users.

Skills: Data Visualization · High Availability Architecture

Other contributors

 

MTN Nigeria – Telecom Fraud Management System (a Data Warehouse, Data Analytics and BI system)

Nov 2007 – Aug 2009

Associated with LM ERICSSON Nigeria Ltd.Associated with LM ERICSSON Nigeria Ltd.

Phase by Phase development,testing, implementation and migration (and maintenance) of System which was completed in 4 Phases followed by Production Stability periodPhase by Phase development,testing, implementation and migration (and maintenance) of System which was completed in 4 Phases followed by Production Stability period

Skills: Data Visualization · High Availability ArchitectureSkills: Data Visualization · High Availability Architecture

Other contributors

 

Ericsson Charging System(Voucher Server, SDP, Ericsson Data Warehouse)

Sep 2007 – Jun 2008

Associated with LM ERICSSON Nigeria Ltd.Associated with LM ERICSSON Nigeria Ltd.

1. Voucher Server: Review database and find Problem areas and suggest & implement solution
2. SDP: System integration, installation and implementation
3. Ericsson Data Warehouse: Analyze system performance, Issues detection and suggest & implement tuning/remedial actions

Environment: 10g,Toad, Oracle Peformance Monitoring and tuning tools,SQL, Oracle Real Application Cluster, Data Guard, Oracle ASM, Unix, Solaris1. Voucher Server: Review database and find Problem areas and suggest & implement solution 2. SDP: System integration, installation and implementation 3. Ericsson Data Warehouse: Analyze system performance, Issues detection and suggest & implement tuning/remedial actions Environment: 10g,Toad, Oracle Peformance Monitoring and tuning tools,SQL, Oracle Real Application Cluster, Data Guard, Oracle ASM, Unix, Solaris

Skills: Data Visualization · High Availability Architecture