Abdul Wahab

• Administrating and coordinating MS SQL & Oracle database instances globally, both on-premises and in the cloud (AWS, Azure). Managing full SDLC process for servers. • Configuration of health checks for performance monitoring, creation of automated scripts (T-SQL , PL/SQL) and notifications, scheduled critical operations for production instances. Capacity planning and business continuity, Index rebuilding, User access control. Backups and recovery policies Database migrations.

• Working on database systems with Terabytes of Data in the Data Warehouse (SSAS), Reporting and analysis based on many fact and dimension tables. • Observing and analyzing various performance metrics like throughput, latency, concurrency, and resource utilization, Query Performance, Database Health, Session and Connection Monitoring, Cache and Buffer Monitoring, Index and Table Statistics. • Performing ETL to consolidate, clean, and structure data from various sources for analysis and reporting.

• Design, prepare functional specification and application development (PHP, EXTJS), database development ( PL/SQL), Reports Generation, Dashboards. • Reviewing the Database ERD diagrams, proposing data model designs & Data Analysis • Supported the different UI with backend logic, wrote SQL code to summarize the data. • Worked on support tickets, maintenance tasks and project coordination. • Created and provided workshops to end users, created user-friendly training materials & documentation (SOP).

• Creating and maintaining, Integration stream data from different diverse sources and load into data DWH. • Visualization of data including Reports, Dashboards. • Data cleansing, ER modeling, developing process for DWH & documentation. • Implemented complex business requirements in backend, using efficient stored procedures and flexible functions, as well as the application front end • Creating GUI for web forms (HTML, CSS, JavaScript, ASP.NET C#, PHP),query writing .

• Writing assigned application code (HTML, CSS, JavaScript, ASP.NET C# ). • Conducted data import and export operations using the DTS wizard. • Troubleshooting, performance issues & error handling in Stored procedure & Views. • Coordinated with the Front-End Developers in detecting the bugs and solving the same.

Information technology, Databases, Software developement