Profile

• Strong 20 years of experience within the Information Technology Industry with expert knowledge on IBM Mainframes, MVS OS/390. Expertise on all phases of Software Development Life Cycle like Planning and Requirements Analysis, Defining Requirements, Application and Database Design, Application and DB Development, Testing, and Deployment application and databases .
• Maintained project tasks with changing priorities and tight deadlines.
• Worked on several technical challenges and provided solutions approved by all stake holders.
• Analytical minded with consistently in resolving ongoing issues that are widely accepted by others.
• Demonstrated proficiency in leading, monitoring and mentoring individuals to maximize levels of productivity, while forming cohesive team environments.
• Worked with Mainframe, JDE Financial Modules and Asset Management , SQL SSIS ETL SSRS, JDA Supply Chain
• Recognized for setting long ranged vision, with eyes on the horizon of the problem being addressed.

Technical Summary

• COBOL, JCL, SQL, Natural, Adabas, CICS, DB2, IMS-DC, DL/I, VSAM, TSO/ISPF
• JDE, JDA, SSIS, SSRS, TOAD, DBVisualizer, VPN, HTML, JAVA, Servers,
• Heat, Remedy, ServiceNow
• MVS OS/390, Z Series, AS/400 iSeries, UNIX, Windows.

Professional Experience

CONFIDENTIAL

Description:

• Created reference documents for JDE Financial Modules at FGL Calgary, working on testing new interfaces for Finance and Assest management modules at Marks's and FGL Sports Check
• Created reference documents for AS400 and Manhattan Warehouse Inventory Management System , created run book for several systems.
• Short projects to run scripts for closing and bringing back servers on Unix, lotus Notes and Domino, .
• JDA Demand Fulfillment
• JDA - Size Scaling attend, Planning and allocated meetings
• SAS Store Assortment , store master and merchandise data ETL to PMM.
• Worked on overseas job shadow and reverse job shadow for POS, PMM as company in process to run the project in-house. Run SQL for query, load and delete records from production tables using Toad and DBVisualizer.

Environment: JDE, JDA supply chain , Toad, Oracle, SQL, Lotus Notes, UNIX, AIX, Servers, Robot, Control-M, Servicenow, and iSeries

CONFIDENTIAL

Description:

• Enhanced and maintained running applications on mainframe, designed and developed users' new requirements. Production Support for online and batch processing. Daily monitoring of QA imports and deal with any issues when arises. Document issues in Remedy, creation of internal tasks for development-worked up to 40 hours, created project request for work over 40 hours and successful in seeking approval prior to commitment.
• Have been involved with QA testing per QA guidelines on SDLC, performing testing and user acceptance testing, wrote complex MS/SQL queries. Developed data load and exported programs using COBOL where Excel/ Text file as input/ output was used Worked on data analysis data from IBM Mainframe and Maximo exported ETL daily to SSIS based QA Data Warehouse System, worked with daily data import issues, wrote complex MS/SQL queries. Developed SSRS reports using SQL queries. Documented system requirement and design document SRS and SDS . Provide advice on information systems Coordinated with parallel development team if any of the objects underwent change coordinated setting up the test environments, and performed component installation in test regions. Developed templates used for test cases/scripts, test plans, test summary report and UAT using MS Word and MS Excel, document test results. Worked with users and their requirements, provide advice on information systems for Environmental Record Management Administration, documented the user requirements, discussed IT strategy and policy, created new query screens and data exports Web, .NET, Java, HTML and Visual Basic and updated user manual. Also documented user requirement and design document SRS and SDS

Environment: COBOL, IDMS, ADS/O, ADSA, Z/OS, MS/SQL, PL/SQL, SSIS, SSRS, IPBridge and JCL and Windows Server

CONFIDENTIAL

Description:

• Daily high priority work to analyze through the IDMS-OPER online transactions. Responsible for deleting the registry, provided that the task took longer in the system. Land Title Production user support for online applications, watching of SQL and IDMS project, since all IDMS online transactions updated to SQL. Development and maintenance of applications, including both the batch and online, backed up DBA and PM when needed.
• Following the SDLC provided system analysis, project design, project estimates per EDS documentation, discussed changes with users, estimated change, development, documented and corrected issues found during software development and testing, user approval, UAT and implemented the changes, documented user and design documents SRS and SDS Worked on IBM Mainframe Z/OS platform using COBOL, NATURAL, IDMS, ADABAS, ADSO along with SQL servers

Environment: IDMS, DB2, COBOL, Natural, Adabas, CICS, SQL, ZEKE, SAM, TSO/ISPF, MVS, JCL

CONFIDENTIAL

Description:

JDE upgrade's to newer version with additional reports for all modules priority to financial reports. Testing the new environment, creation of test cases and presenting the issues to weekly meetings.

Responsibilities:

• Performed system and data analysis following the SDLC to create JDE Contractor application systems project lead, development screen in JDE 8.11 equivalent to green screen AS400 , developed test plans, tested and implemented Contractor Application and new table help screens. Developed user training and trained contractor user on new developments.
• Developed new reports and maintained existing reports, changed application screens and added new functionality in ERP package, used SQL to unload data from production and load to test environment for testing.
• Documented software and system testing issues, also collected issues found during testing from the team, documented them and presented in weekly progress meeting. Worked with a large team of employee's and consultants Letter of appreciation

Environment: JDE, DB2, SQL, PL/SQL, Oracle, AS/400 and iSeries

CONFIDENTIAL

Description:

Enhanced and maintained running applications on mainframe, designed and developed users new requirements. Production Support for online and batch processing. Nightly batch processing support. Lead morning meeting and distributed minutes of meeting.

Responsibilities:

• Developed new and maintained over 1000 programs using COBOL, ADSO, CICS, DB2, IDMS database on Order Entry/ Receipt, Price/ Cost Management, Inventory Management, Shipping, Billing and Invoicing, Finance AR, AP and GL , Customer Management, Rebate Management, Fixed Asset, Sales Profile, Product Purchase History
• Member of the team that performed all stages of the software development lifecycle including system analysis, project design, development, testing and maintenance of the various legacy IBM mainframe systems and applications COBOL and CICS
• Worked on major project 32 million towards converting three legacy COBOL companies to JDE 8.9 with customization due to the business requirements. Unloaded legacy sales data and created new function in JDE for Agriliance sales history. Participated with Auto Pilot for automated testing, load test and performance test, also worked in parallel with teams overseas

Environment: IDMS, DB2,ADS/O, JDE, COBOL, CICS, Oracle, MQ SERIES, FILEAID, MVS, TSO and JCL

CONFIDENTIAL

Description:

Provided production support to McGraw-Hill, Sprint and DBA to GE supply

Responsibilities:

• Worked as an IDMS DBA with GE Supply, besides the daily, weekly and monthly DBA activities Developed QA for over 100 developers local and overseas .
• Production Support day time and after hour
• COBOL and Adabas program changes and testing.
• Technical Environment: IDMS, ADS/O, COBOL, DB2, CICS, MVS, TSO and JCL

CONFIDENTIAL

Responsibilities:

• Wrote several COBOL DL/I programs for the payroll system
• Wrote several COBOL IMS programs to list different grade employee in Saudi Ministries
• Wrote several COBOL IMS CICS programs to display number of Saudi and non-Saudi employees.
• Lead and supervised SDLC with database migration from IMS DL/I databases to IDMS database.
• Database administration and supervised the entire project. Estimated databases areas, files and space requirements , developed functional hierarchy, entity relationship, data flow diagram, data structure diagram, defined data redundancy, created record definitions in IDD.
• Dump Report Files utilization report
• Technical Environment: IMS, CICS, IDMS, ADS/O, COBOL, MVS, TSO and JCL