Adil Sultan Email & Phone Number

Islamabad, Islāmābād, Pakistan

--------Client : First National Bank (South Africa)--------- Successfully migrated an on-premises Enterprise Data Warehouse (EDW) to AWS, specifically from Sybase to Amazon Redshift.- Transformation and development of Stored Procedures, Views, and UDFs to support the migration process.-Interacting with Clients, Understood requirements and assigned the tasks to team members according to ability.- Testing of data on both data bases of different data sources using the reconciliation toll.- Created automated scripts using the AWS Redshift metadata tables for smooth delivery.- Supervised completion of daily duties.- Assigned tasks to team members according to ability.- Trained co-workers in Amazon redshift and Sybase.- Encouraged team to work together and resolve interpersonal conflicts.

Islamabad, Islāmābād, Pakistan

-------- Client : Allied Bank Limited --------- Ensured 24/7 smooth operations of DWH and its related ETL. - Established connection with different sources and destinations - Developed new ETL pipelines and optimized existing pipelines.- Ingestion, Transformation and Processing of structured and unstructured data into data lake using ODI and Hadoop Ecosystem.- Managed ODI Lifecycle components Developments i.e. Models, Mapping (with transformation like Lookup, Filters, Joins, Aggregates, Knowledge Modules), Variable, Procedure, Data Quality Controls, Packages, Scenario, Complex Files, Load Plans and other components.- Development of batch email alerts using python scripts.- Spark Jobs Development & Optimizations for fast processing.

Islāmābād, Pakistan

Postpaid Billing & Audit.- Postpaid Billing process level optimizations.- Postapid reconciliations for quarterly and yearly audit.- Verification of invoices (Charging, CDR’s, Tax).- Responsible for generating post billing processes (Duplicate Bill, E-Bill, Corporate Bill and SMS processes). CRM PROJECT- Requirements gathering and implementation as per agreement with business users.- Performed User acceptance testing with end-users.- Highlighted logical system issues to development team for rectification.

Islāmābād, Pakistan

- Assist Business users in breaking down and assessing the scope of project.- Work closely with the business and technical personnel to identify gaps in requested functionality and offer innovative solutions.- Creating and submitting ad hoc reports and queries.- Analysis of customer’s complaint trends and identifying the problematic issues/areas.- Identify and reimburse all impacted customers due to any issue arise at BOSS system level.- Proposing solution, Implementation & testing of the issues to minimize complaints.- Coordination with Product Owner, CMC and CC for complaints reduction.- Developed In-House portal on PHP to provide better system visibilities for catering complaints at level-1.

Islamabad

- Extracting data using SQL, claiming data to process & validating.- Creating and submitting ad hoc reports & queries.- Developed SQL procedures and shell scripts for automated system monitoring.- Work with the Systems team, Planing and Implementation team, Engineering teams and Vendors to improve system performance.- Ensure end-users Charging, Provisioning, CRM, BVS, Accounts, Billing, MNP, IR, Configurations, reports queries are dealt efficiently and timely.- Ensure all BOSS nodes and network availability at all time.- Testing on BSS and OSS after new development or amendments.- Operations of online charging system and vendor management.- Analysis of complaints due to system related issues, identifying root cause and providing resolution.- 3rd party services (SMS ,MML,USSD,MMS)- Provisioning (HLR, IR, PCRF, CRBT, MCA etc.)

Islāmābād, Pakistan

- Developed Official Hybrid Mobile Application for (FBISE) Federal Board of Pakistan.- Developed Website on PHP MVC framework (Laravel 5.2).- Designed and Managed MySQL databases for Custom PHP solutions.- Developed web portal using custom PHP.- Converted PSD’s to responsive HTML.- Developed and Customized WordPress themes.- Built Several Websites using WordPress themes.

Islamabad, Islāmābād, Pakistan

-Developed oracle forms.-Managed and updated databases under the supervision and coordination of a Database Administrator