Mohammed Hasham Email & Phone Number

Gormley, On

Preparing reports using SQL and SAS for clients. Maintain clients databases with current information as well as providing analysis as well as reports. • Create SAS programs to correct data and create SAS reports to ensure data quality • Manage scheduling to ensure programs run on time and deleting programs in schedules that aren’t needed. • Monitoring production jobs as well as correcting failed jobs and restarting them when needed• Analyzing failed processes by fixing the SAS or Query jobs and putting them back to production

Work closely with Accounts Manager as well as developers to ensure all campaigns run in a timely and accurate manner. Manage and run direct mail and telemarketing campaigns. Ensure all suppression files are up to date. Use SAS to do ad hoc requests for clients. Create SQL scripts in SQL Server 2005.• Ensure all CIBC campaigns run in a timely and accurate manner• Manage and run Direct Mail and Telemarketing Campaigns for CIBC as well as Aeroplan• Date Extraction and data manipulation to ensure all suppression files are up to date. • Create SAS programs to process ad hoc requests for clients which required data cleansing and reporting• Create SQL scripts in SQL Server 2005 to maintain the database • Transition SQL script to SAS program for CIBC branch requests• Investigated and resolve client complaints and provide analysis. • Data analysis for Rogers and provided year end campaigns results and reports

Ensure all Amex card member data was accurately provided for suppression in external acquisition campaigns for Canada, Australia, Hong Kong, Mexico, New Zealand, United Kingdom, Singapore, France, Germany, Finland, and Sweden. Executed campaigns on a timely and accurate manner across the direct mail channels. Utilized SAS, MVS/TSO, SQL, DB2, UNIX & Visio• Ensured the delivery of high quality service, consistently exceeding customers’ expectations by connecting with the customer to understand the request in depth. • Extracted suppression data from mainframe environment (MVS/TSO) and UNIX from DB2 tables using SQL, modifying the SQL query to suit the needs the Marketing department. • Improved the efficiency and quality of campaign execution by modifying existing SAS programs and creating & running SAS programs for data fixes, manipulation, selection, matching, reporting and data cleansing. Created Quality checks, checklists, and reports to ensure accuracy, to meet compliance & control procedures and to ensure the data going to vendors was at the highest quality.• Utilized UNIX scripts to FTP multiple data files from PC to mainframe or UNIX as well to vendor website including secure transfers (PGP encryption), Tumbleweed or proprietary FTP software.• Created layouts, documentation, detailed process flows, costs, and CPU times of all campaigns using Visio, MS Word and Excel with final files.• Designed, created, tested, and implemented the suppression process using SAS, as well migrated & modified SAS programs from Mainframe to UNIX box. Reduced cost as well as automated programs to save time.• Worked on a gap analysis project involving missing records and finding a solution, as well as providing feedback. Analyze request from marketing and ensure rules and regulations are met for compliance

Responsible for ensuring all Amex card member data is accurately provided for suppression in external acquisition campaigns for multiple international markets.Data extracts in mainframe environment from DB2 tables using SQLExtracted suppression data from UNIX data warehouses using SASCreated and run SAS programs (in both environments) for data fixes, matching and reportingUtilized UNIX scripts for other data cleansing processesCreated file output in various formats based on requirements. (ie Excel, text (binary or EBCDIC), SAS datasets including file layouts.Transferred data between UNIX, mainframe and PC, including secure transfers using PGP encryption, to vendor websites or using proprietary SFT software.Maintained detailed process flows of all campaigns using Visio software. Responsible for acquisition processing, data processing procedures and controlsResponsible for timely and accurate campaign execution across the direct mail channelsWorked on mainframe using MVS/JCL, TSO, SAS, UNIX, and EasytrieveWorked with various applications such as Access, Excel, and MS WordWorked with IDCAMS, SYNCSORT, FILE-AID