Monib Amjad Email & Phone Number

Lahore

Job Responsibilities• Data maintenance, cleansing and validation of different departments.• Create and enforce policies for effective data management.• Development of new analysis areas and new reports and maintaining old reports as per new business requirements• Reconciliation, quality assurance, checking and verifying data integrity.• Report dashboard designing of different departments for web portal.• Administration of data entry operators regarding data validation and accuracy of data.• Develops ad-hoc reports as necessary.• Administration of different departments data portal• Coordination with web portal developers for required modification and changes as per department’s need.

Lahore, Pakistan

• Monitoring and development of ETL operation in IBM Tools DataStage and Nateeza• Designing, Monitoring and troubleshooting ETL jobs of DataStage• Sourcing of additional information from existing source and new source systems in DWH, ensuring data and system integrity and making the information available for business reporting• System analysis of OLTP systems for the extraction of data from operational and legacy systems into Data Warehouse staging area.• Reconciliation, quality assurance, checking and verifying data integrity after loading (ETL)• Monitoring of ETL Batch/Process to ensure data transformation from different source systems to EDWH system that enables different department to generates different reports and campaigns• Accuracy, consistency and maintenance of data in all different stages of EDWH for reporting purpose.• Development of new BI reports and automating existing ones.• Developing of new analysis areas and new reports and maintaining old reports as per new Business requirements• File and Data reconciliation from source to presentation layer.• Coordinate with teams for timely delivery of their required reports and changes as per their requirements• Ad-hoc reporting• Reporting, developing, preparation of 668 data to PTA• Reporting (Daily/Weekly/Monthly)• Addition, changes and mapping of new files from source to EDWH systems.• Documentation of EDWH ETL Job Mapping• Import/export of table and files from different sources to DWH system.

• Monitoring and development of ETL operation in IBM Tools DataStage and Nateeza• Designing, Monitoring and troubleshooting ETL jobs of DataStage• Sourcing of additional information from existing source and new source systems in DWH, ensuring data and system integrity and making the information available for business reporting• System analysis of OLTP systems for the extraction of data from operational and legacy systems into Data Warehouse staging area.• Reconciliation, quality assurance, checking and verifying data integrity after loading (ETL)• Monitoring of ETL Batch/Process to ensure data transformation from different source systems to EDWH system that enables different department to generates different reports and campaigns• Accuracy, consistency and maintenance of data in all different stages of EDWH for reporting purpose.• Development of new BI reports and automating existing ones.• Developing of new analysis areas and new reports and maintaining old reports as per new Business requirements• File and Data reconciliation from source to presentation layer.• Coordinate with teams for timely delivery of their required reports and changes as per their requirements• Ad-hoc reporting• Reporting, developing, preparation of 668 data to PTA• Reporting (Daily/Weekly/Monthly)• Addition, changes and mapping of new files from source to EDWH systems.• Documentation of EDWH ETL Job Mapping• Import/export of table and files from different sources to DWH system.

• Database object development(Stored Procedures, Triggers, Views, Indexes) • Data migration Scripts and Fixation• Data migration analysis and verification scripts• Perform Fields Mapping in data migration• SAP module of development project• Perform Fields Mapping• SSIS of SQL SERVER

Responsibilities:• Data Analysis and Reporting• Risk Management• Fraud Prevention• Data Mining• Fraud Investigation• Customer Support• Customer Satisfaction• Fraud Monitoring• Manage the Fraud Prevention, Detection and Investigation processes• Ensure that Fraud cases are identified and solved within expected time frame• Monitoring and catering customer claims,complaints and Queries, verifies and analysis their causes• Provide Customer Support to B2C/B2B at all levels (L1/L2/L3)• Analyzed and investigated Call Record,Credit History,Credit Card Details,credentials and unusual customer behavior to identify fraudulent activities• Online monitoring of DIBS and PAYPAL• Undertake detailed investigations & performing root cause analysis• Daily, weekly and monthly reports including Carriers, Gateways, KPI's of Operating system, registrations, minutes, payments and on demand as well• Perform Data Analysis to prevent Fraud at all levels• To co-ordinate with different departments to provide resolution to the customer for their Network and Billing Related Issues.• Processing of fraudulent complaints logged by customers• Online monitoring of DIBS and PAYPAL• Performed searches on customer profiles and customer credit history to confirm if fraudulent activity was likely• Coordinate with all business user concerns and make sure their timely resolution.• Member a team of analysts to identify process improvement opportunities and pro-active analysis of data to intercept fraudulent activities• Determine new trends and fraud patterns• Authorized to take decisions according to the customer’s status, behavior, payment history, and figure out any fraud behavior• Lock accounts and add to Internal Block lists.

Lahore

I worked as Data Analyst in World Call Telecom Limited of ICT (Information and Communication Tech) department.Job Responsibilities• Working with Network elements (MSC/WIN/AAA etc.)• Working on Services (Prepaid/Postpaid/PCO)• Working in segments (Voice/1xData/EVDO etc.)• Data Analysis• CDRs verification• Reporting (Daily/Monthly/On-Demand)• Analysis Based Reporting• Settlement• Fraud Management• Revenue Assurance• Documentation of Reporting Portal

Bs(Cs) Hons, Information Technology

Fsc ( Pre Eng ), Engineering

Activities and Societies: Cricket,Table Tennis