Ossama El Sarraff, Senior Data Migration Specialist

Ossama El Sarraff

Senior Data Migration Specialist

BDI Worldwide

Location
Canada
Education
Diploma, Diploma of Computer Science & Information
Experience
35 years, 7 months

Share My Profile

Block User


Work Experience

Total years of experience :35 years, 7 months

Senior Data Migration Specialist at BDI Worldwide
  • Canada - Mississauga
  • November 2014 to October 2020

* Designed and led the ETL team in developing a data quality tool to help the business users to cleanse master data (customers, vendors and materials) and provided them with meaningful error reports as well as provided the management with summary statistics regarding the amount of cleanliness of data.
* Designed and developed BODS jobs to auto-generate data migration maps that include all available fields for SAP data migration using LSMW and iDoc methods to standardise the process.
* Designed and developed cross references to help the ETL team in validating migrated data before loading it to SAP.
* Led data mapping workshops to walk various team members (technical and functional SMEs) through requirements for migrating different data objects from the legacy systems and other sources to SAP.
* Participated in 4 full migrations from end-to-end from legacy systems (AS/400) and other sources into SAP including data mapping (including identifying sources from either legacy systems or offline files that I designed as templates to fit into the migration objects), data cleansing preparations, staging data, ETL, pre and post data validation including reconciliation and error reports, and post GoLive support.
* Developed multiple jobs in BODS, LSMW and Winshuttle scripts to upload and maintain SAP data in various areas like MM, CM, VM, BOMs, PIRs, IM/WM, LE, and custom tables.
* Developed some SAP queries to help the business in decision making and identifying areas of improvement with the quality of the data used.
* Trained and mentored other local and global team members in learning new techniques and in learning data migration and maintenance jobs and processes that I’ve developed.
* Optimised own jobs and other team members’ jobs to better perform and to balance the load on impacted servers.
* Maintained databases including BODS repositories as well as data stores for migrations/cleansing.
* Troubleshoot BODS job server and SQL Server issues.
* Data maintenance and user support after Go Live projects for various branch countries of the company.
* Upgraded BODS from 4.1 to 4.2.8 and from 4.1 to 4.2.12 including repository and datastore migration and upgrade.
* Upgraded and migrated database objects from SQL Server 2008R2 to SQL Server 2012, and from SQL Server 2008R2 to SQL Server 2017.
* Performed resume review and technical interviews.

Business Analyst III at UTC
  • Canada
  • January 2006 to July 2013

* Participated in the Enterprise Data Archival project using ETL tools (BODS) to archive legacy data from JDEdwards into an Oracle database (3 releases/7 JDEdwards instances) including analysis and data mapping.
* Participated in BI/BW configuration including InfoCubes, DSOs, Multi-Providers, InfoSets and Process Chains, and BI/BW tools including BEx, WebI, and Universe creation/maintenance.
* Participated in maintaining, scheduling and monitoring BW reports.
* Participated in pre-validating, staging and loading legacy converted data into SAP using BODS and LSMW.
* Participated in the conversion of legacy data from JDEdwards to SAP (3 releases - 7 JDEdwards instances); mainly in the SCM area including MM, Production Orders, Purchasing, Inventory, BOMs, Routings as well as the Component and Complex MRO solutions.
* Participated in assisting users in cleansing the legacy data as well as in completing conversion data maps. Also, identified legacy fields that could accommodate SAP values for easier mapping and conversion.
* Trained and assisted some of the team members to use Business Objects Data Integrator (BODI)/Business Objects Data Services (BODS) and that resulted in using this tool in over 95% of the JDEdwards extracts to SAP.
* Supported the user community using JDEdwards and some of its related in-house built applications.
* Customized JDEdwards to fit business needs and requirements.
* Performed a disaster recovery test for the currently used AS/400 system including the JDEdwards application.
* Designed and developed an application to automatically disable the AS/400 user profiles either immediately or on a scheduled date and time and integrated that into the JDE User ID Review security screen.
* Developed some Crystal Reports to help users analyse data and also in data cleansing activities prior to the conversion to SAP.
* Followed up with auditing requirements and SOX guidelines.
* Managed the AS/400 operations including backup/restore, security, user profiles maintenance and disk management

Business Systems Analyst (Acting IT Manager) at Green World Food Express Inc.
  • Canada
  • April 2004 to January 2006

* Cleaned and applied standards to the master data in the used ERP package (Business Vision).
* Continued data cleansing activities to ensure data integrity and accuracy.
* Created a new map for all internal/external storage locations and updated the system accordingly.
* Configured all kitted items and created BOMs for data accuracy.
* Created various Crystal Reports to help the management and different business areas to perform their functions more efficiently.
* Modified the cheque printing layout to use one pre-printed form which saved the company a lot of money.
* Helped with software/hardware installation including the upgrade of Business Vision from version 6.5 to version 7.0
* Supported the company’s computer network and software.
* Helped with reviewing the company’s website development and content.

Senior JDE Consultant at Nadiscorp Logistics Group Inc.
  • Canada
  • January 2002 to March 2004

* Designed and developed applications to print various reports extracting data from JDEdwards and matching old reports from a VAX legacy system during a conversion project.
* Designed and developed some application tools to convert any AS/400 spool file or physical file into an Excel formatted file or a text/Word document file using native CL/400 commands.

Senior Consultant at YMCA
  • Canada
  • November 2001 to December 2001

* Completed a project for data conversion from Cyborg software to ADP payroll software using MF-COBOL.
* Designed and developed several validation and verification reports to ensure proper conversion between both systems.

Senior Consultant - Contract at Savant Systems Inc.
  • Canada
  • September 2000 to October 2001

(A software development and integration company)

Environment:
H/W: AS/400, LAN(Linux), Windows
S/W: JDEdwards, RPG/ILE, RPG/400, CL/400, QUERY/400, SQL/400, Client Access/400, Pegasus Mail, Windows 98

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance); analysing programming problems and recommending alternative solutions and documentation.

Accomplishments:
* Participated in the development of an in-house ERP system for the retail industry to be customized to various clients based on their needs (this project is still in progress).
* Verified that all programs in the ERP system complies with the company’s standards.
* JDEdwards customization for the clients of the company.

Technical Project Manager, AS/400 at Footmaxx Holdings Inc.
  • Canada
  • February 1999 to September 2000

(A computerized gait & pressure analysis and prescription custom made foot orthotics manufacturer)

Environment:
H/W: AS/400, LAN(Windows/NT)
S/W: JDEdwards, RPG/400, CL/400, QUERY/400, SQL/400, JDEdwards World Writer, Spool-A-Matic, Client Access/400, Microsoft Outlook, Visio, MS-Project, Windows 95/NT

Responsibilities:
Managing all the AS/400 and JDEdwards development and operations issues, systems analysis, design & programming (development, enhancement, evaluation, testing, maintenance and training); analysing programming problems and providing alternative solutions and documentation, tailoring JDEdwards programs to adapt to the company’s requirements, developing new modules to interface with JDEdwards, security and operations management, liasoning with other department managers, interfacing with vendors and internal & external consultants, handling all user requests and prioritizing them, setting up all parameters and codes in JDEdwards, managing & assigning tasks to the AS/400 staff and interviewing/hiring new staff.

Accomplishments:
* Participated in the implementation and setup of JDEdwards (A73 Cum 8) with a consulting JDEdwards partner company including the Financial, Distribution and Manufacturing modules.
* Developed EDI programs to upload and translate all incoming orders through a PC-based client software into the sales and manufacturing systems of JDEdwards providing it with all parts and manufacturing instructions for creating sales and work orders.
* Analysed and designed a module to review and edit invalid uploaded orders before pushing them to the JDEdwards’ Sales and Manufacturing systems.
* Developed a program to upload sales invoices from an Access database to the JDEdwards’ A/R system before implementing the Distribution module.
* Developed a program to upload customers from an existing Access database into JDEdwards’ Address Book.
* Utilised the CIF files to default each sales/work order to a specific sales/manufacturing branch/plant.
* Participated in most the CRPs of the implemented JDEdwards’ modules.
* Customized some of the JDEdwards reports like cheques, invoices, statements, work orders, pick slips, etc.
* Developed a series of query and world writer reports to help management and production staff to determine the areas of backlogs and where orders stand.
* Developed a process to convert AS/400 printer files into PDF files and e-mail them from the AS/400 directly to any internet e-mail address.
* Set all the AS/400 operations & security processes and

Senior Consultant P/A - Contract at Saville Systems Inc.
  • Canada
  • January 1998 to June 1998

(A software development company in the field of telecommunications billing)

Environment:
H/W: AS/400, LAN(Novell Netware V 4.11)
S/W: RPG/400, CL/400, QUERY/400, Hawkeye, Reflection for IBM, Microsoft Mail, Visio, Windows 95

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance); analysing programming problems and recommending alternative solutions and documentation.

Accomplishments:
* Developed a program for calculating clients’ reward points.
* Participated in Y2K problems analysis.
* Participated in a comprehensive test of some modules of one of the clients’ applications for Y2K compliance.

Senior Programmer/Analyst - Contract at Hoffmann - La Roche Limited
  • Canada
  • September 1997 to December 1997

(A pharmaceutical company)

Environment:
H/W: AS/400, LAN(Novell Netware V 3.12)
S/W: RPG/400, CL/400, QUERY/400, SQL/400, BPCS, Hawkeye, Rumba/400, cc:Mail, MS-Windows 3.1

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance); analysing programming problems and recommending alternative solutions; documentation; various applications and data maintenance & support; designing and running customized query reports.

Accomplishments:
* Fixed problems and enhanced programs in an inventory application.
* Designed customized queries for sales data.
* Investigated and fixed various billing problems.
* Enhanced some programs for sales/budget related reports.
* Extracted data for transfer from the AS/400 to the PCs.
* Supported most of the used applications.

Senior Programmer/Analyst - Contract at Star Data Systems Inc.
  • Canada
  • May 1997 to June 1997

(A software development company in the field of mutual funds)

Environment:
H/W: AS/400, LAN
S/W: COBOL/400, RPG/400, CL/400, QUERY/400, Rumba/400, Lotus Notes

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance); analysing programming problems and recommending alternative solutions; documentation.

Accomplishments:
* Participated in the conversion process of some files from a company standard application (SMS) to a customized version of the application to one of the clients (CISS).
* Applied required modifications and enhancements to the customer version of the in-house built application SMS.
* Participated in the synchronization of testing and production environments for testing and quality assurance purposes.

Senior Programmer/Analyst - Contract at Woolworth Canada Inc.
  • Canada
  • March 1997 to May 1997

(A distribution company)

Environment:
H/W: AS/400
S/W: RPG/400, CL/400, Query/400, SQL

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance); analysing programming problems and recommending alternative solutions; documentation.

Accomplishments:
* Modified one of the currently used distribution systems to accommodate the new Harmonized Sales Tax that was introduced in New Brunswick, Nova Scotia and New Foundland on April 1st, 1997.
* Applied some modifications and file expansions to an existing payroll system.
* Created some programs to backup history file members and purge unused data on the system.

Application Specialist at InterTrans Logistics Solutions Ltd.
  • Canada
  • September 1995 to December 1996

(A software development company in the field of freight management & logistics)

Environment:
H/W: AS/400, LAN(Novell Netware V 3.12)
S/W: RPG/400, CL/400, JDEdwards, MS-Windows, MS-Office, MS-DOS

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance); analysing programming problems and recommending alternative solutions; integrating in-house products with JDE software; documentation.

Accomplishments:
* Writing the technical specifications, scheduling, developing and testing most of release 3.3.5 of AXIS (in-house base application for Shippers freight management) and SMS335/JDE71 (Shippers Management System integrated with JDEdwards Distribution System).
* Applying and fixing the integration logic to different JDEdwards cumulative levels with the in-house built application SMS.
* Installing JDEdwards 6.2 (Cum 10) onto the system.
* Setting regression test plans for integrated and upgraded versions of updated software.
* Developed a rating engine module for a client based on their specifications.
* Participated in migrating one of the clients to a more recent release of AXIS.
* Started researching the possibility of converting the in-house built applications into the Double Byte Character Set mode.

Programmer/Analyst at Baycom Inc.
  • Canada
  • September 1994 to September 1995

(A software development company in the field of mutual funds)

Environment:
H/W: AS/400
S/W: COBOL/400, RPG/400, CL/400

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance); analysis programming problems and recommending alternative solutions; systems conversion from S/38 code into native AS/400 code; technical assistance of junior technical staff; documentation (technical & user level: flow charts, operating procedures, user guides, etc.).

Accomplishments:
* Rewritten a program for printing statements to be directed to a tape file instead of being printed onto a spool file for one client.
* Participated in a big project for data transmission using different transmission methods (Created the RJE transmission command & related programs).
* Created programs to fix automatic time sheet entry discrepancies and produced project reports based on the fixed time sheet entry data base for corporate use.
* Participated in the enhancement and tailoring of the existing packages for various clients.

Programmer/Analyst at Seabury & Smith Limited
  • Canada
  • September 1993 to September 1994

(An insurance management company)

Environment:
H/W: AS/400, LAN (Novell Netware V3.12)
S/W: COBOL/400, CL/400, QUERY/400, MS-Windows, MS-DOS, IBM PC-Support

Responsibilities:
Systems analysis, design & programming (development, enhancement, evaluation, testing and maintenance) in the field of insurance management; analysing programming problems and recommending alternative solutions; determining general system requirements in view of user needs and available resources; system installation and updating (OS/400, PCS/400 and PC software packages); on site and by-phone systems support and troubleshooting (AS/400 and PC's); technical assistance of junior technical staff; documentation (technical & user level: flow charts, operating procedures, user guides, etc.); performing and supervising some operating duties (backup, printing, etc.).

Accomplishments:
* Participated in transferring an accounting system from the HP3000 environment into the AS/400 environment.
* Introduced new features (added new user interfaces for inquiries) into the AS/400 programming environment.
* Introduced an e-mail system into the LAN environment.

Programmer/Analyst at The International Scribe for Computer
  • Egypt
  • December 1991 to August 1993

(A software development company)

Environment:
H/W: AS/400, IBM PS/1
S/W: RPG/400, CL/400, MS-Windows, MS-DOS, dBase ||| Plus, BASIC,
Pascal, MS-Works, MS-WORD, Harvard Graphics, Lotus 123

Responsibilities:
Programming, systems quality control assurance and testing, systems arabization, documentation, AS/400 system support and operating, PC technical support & training and supervising & monitoring data entry jobs on the PC's.

Accomplishments:
* Established standards and check lists for quality control assurance of applications.
* Participated in the conversion of some Latin applications into Arabic.

Part-time PC Software Instructor and Consultant at Various Private Institutes
  • Egypt
  • January 1988 to August 1993

PC software instruction and consulting.

Volunteer Instructor/Developing Consultant at Voluntary Work
  • Egypt
  • January 1993 to August 1993

Voluntary AS/400 instructor and consultant to the IS Department of the General Authority for Rehabilitation Projects & Agricultural Development (Egyptian Ministry of Agriculture)

Programmer/Analyst at Central Bank of Egypt
  • Egypt
  • February 1988 to December 1991

(A Financial Banking Institution)

Environment:
H/W: IBM PS/2
S/W: DOS, MS-Windows, COBOL, dBase III Plus, BASIC, Pascal, Lotus 123, Harvard Graphics, Soritec Sampler (Econometric modeling s/w), WordStar, ArabStar, Arabic DisplayWrite 2

Responsibilities:
Computer section administration and coordination with other sections & departments, systems analysis & design, computer programming & operating, flowcharting, documentation, data coding, staff supervising & training, technical support, testing and evaluating software, designing charts for the economic and statistical analysis and for the bank's publications, creating and compiling time series for statistical studies and research and implementing regression analysis techniques using various economic variables and indicators for research purposes.

Accomplishments:
* Established standards and norms in the computer section of the Economic Research Department.
* Computerized the Central Bank of Egypt's library index.
* Feasibility study to introduce a mid-range computer into the Economic Research Department.
* Enhanced and improved several procedures through introducing computerized techniques.
* Transferred several processes from manual processing into computerized processing.

Volunteer Computer Consultant/Developer at Volunteer
  • Egypt
  • June 1990 to June 1990

Developed a program to randomly select tenants for government subsidised housing (Cairo Governorate - Egypt)

Translator/Typist at Central Bank of Egypt
  • Egypt
  • December 1987 to February 1988

(A financial Banking Institution)

Responsibilities:
Translation from/to English and Arabic, préçis writing and typing my work.

Accomplishments:
Participated in the translation of the Central Bank of Egypt's Silver Jubilee Report.

Translator/Typist, Programmer at PLAN International Egypt
  • Egypt
  • January 1987 to December 1987

(An international organization for fostering children)

Environment:
H/W: IBM PC's
S/W: MS-DOS, dBase III Plus, BASIC, Pascal, Lotus 123, ArabStar

Responsibilities:
Translation from/to English and Arabic, simultaneous interpretation, computer programming & operating and typing my work.

Education

Diploma, Diploma of Computer Science & Information
  • at Institute of Statistical Studies & Research - Cairo Univ.
  • June 9999

Not completed

Diploma, Computer Programming
  • at Various Computer Institutes
  • July 2001

The following courses have been attended since 1994 till present: Novell Netware CNA, Introduction to Oracle SQL and PL/SQL, Web Development using Active Server Pages (ASP), HTML, VBScript, JavaScript & InterDev and Java Programming.

Diploma, JDEdwards
  • at JDEdwards
  • March 1999

JDEdwards World Technical Foundation

Diploma, Computer Courses
  • at Various Dom. & Int. Computer Institutions & Companies
  • August 1992

Attended the following courses from 1982 till 1992. Introduction to Computer Science, COBOL & Programming Stock Control Systems using COBOL, RPG II, Pascal, BASIC, PC-DOS, Operations Research Techniques, Operations Research Application in Banking, IBM-AS/400 System Facilities, CL/400, IBM-AS/400 Data Base, RPG/400.

Diploma, Diploma of Translation (English/Arabic)
  • at Faculty of Arts - Cairo University
  • June 1989
Bachelor's degree, English Language & Literature
  • at Faculty of Arts - Ain Shams University
  • July 1985

Specialties & Skills

Microsoft Access
Testing
MS Project
COBOL including COBOL/400
Systems Analysis and Design
AS/400 including RPG/400, CL/400, OS/400, DB2/400
JDEdwards including A/B, Finance, Distribution, Manufacturing & Security
Technical Project Management & Leadership
MS-Access
ASP, VBScript, JavaScript, HTML & MS InterDev
MS Office & MS Project
Testing & Documentation
Systems/Customer Support & Training
SAP Business Objects Data Services (BODS)
SAP Data Migration
SAP BI/BW
Crystal Reports
Data Cleansing

Languages

English
Expert
Arabic
Expert
French
Intermediate