PROFESSIONAL SUMMARY:

• Strong 20+ years of experience within the Information Technology Industry; with expert knowledge on Confidential 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 SKILLS:

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

PROFESSIONAL EXPERIENCE:

Confidential

Systems Support Analyst

Responsibilities:

• 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 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, .
• Daily duties to work on user requests for History Modeling Data Upload, Transfer to Fulfillment, RUN Calculate Plan
• Deleted History Records (using SQL, TOAD, DBVisualizer)
• Reviewed Business Requirements (BRD) and provided Solution Documents.
• JDA - Size Scaling attend, Planning and allocated meetings
• Reviewed ongoing PMM or POS ETL problems, further Size Scaling to SAS ETL issues
• 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

Responsibilities:

• Solutions - oriented Analyst with notable success, having participated in the SDLC including project design and planning, system analysis, development and implementation of system wide applications and manual testing solutions in direct support of business objectives. Documented program changes and user requirements as per business requirements and system specifications. Supervised, reviewed and updated test requirements and got sign-off from project team for industrial based Order, Inventory, Asset Management, Shipping, Finance and EDI applications
• Developed over 100 Batch and DC-Batch, online screens, online transaction dialogs, batch programs using COBOL and DC. Used TPSORT on online dialogues and resolved database installation problems after communicating with vendor the online storage issues when releasing large data for sorting using TPSORT in online dialog.
• Designed and developed data structure diagram, database record sets and indexes, schema, sub-schema and databases. Used online screen and OLQ to create test data, review data using OLQ and OLQ-Menu, and used OPER to watch online transactions.
• 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 for Environmental Record Management Administration system, documented the user requirements, created new query screens and data exports (Web, .NET, Java, HTML and Visual Basic) and updated user manual.
• 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 Confidential 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

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

Senior Support Analyst (Mainframe)

Confidential

Responsibilities:

• Worked with users on all technical issues, daily operations and ad - hoc requests; watched daily system maintenance reports and after hour application support.
• Online transaction and batch transactions updates on DARS and SQL projects.
• Worked with ZEKE for batch job scheduler; as was responsible for scheduling adhoc jobs in ZEKE
• Provided day time application, FTP, CASPOOL, DARS, replication between IDMS and SQL project (SPIN) and fax support to Confidential Land Registries Examiners
• Coordinated with other support groups; current IDMS applications were under development on DB2, SQL and WEB
• Following the SDLC; provided system analysis, project design, discussed changes with users, estimated change, development, documented user requirements and corrected issues found during software development and testing, user approval, UAT and implemented the changes
• Corrected batch programs for billing (payment received during day time). Tested the complete batch process to update and to view the $ in online applications executing test plans
• Reported software UAT testing results to the project manager for SIGN-OFF. Coordinated the sign off documents with developmental teams in accordance with QA guidelines. Documented changes to user training guide.
• Developed the templates used for test cases/ scripts, test plans, test summary reports and UAT using MS Word and MS Excel
• Solely trained and monitored the EDS employees, documented and smoothly hand over the project upon departure
• Strongly recognized for implementing administrative, decision-making, and supervisory course of action when directing a group. Also highly innovative in advanced mechanisms of achieving directed goals.

Technical Environment: IDMS, DARS, COBOL, ADS/O, ADSA, DB2, CICS, SQL, ZEKE, SAM, TSO/ISPF, MVS, and JCL

Lead Analyst

Confidential

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.
• GL/Daily Trial Balance; converted fields from legacy system into an interim table, mapped the converted fields, and converted the address book values for the component of AP, AR, GL and Asset
• Data analysis of HR payroll batch transactions when received than uploaded to Z table and allowed it process through available functions.
• 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.
• Developed data fixes (DB2, PL/1 and SQL). Supervised and reviewed sign off solutions for Dry run conversion issues
• 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)
• Utilized SQL Queries to verify test environment data, and DB2 with production
• Created user reference document and trained user to maintain, monitor and update project testing progress, as detailed as possible to include tasks; such as milestones for task, module level testing and Dry run issues, conversion tables, Sequels, Communications etc. Coordinated with QA and development teams to ensure quality standards were met in development and testing phases

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

Lead Analyst (Mainframe JDE)

Confidential, Land’O Lakes, MN

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
• Worked with user project team and technical team members in defining and performing needed enhancements or special requests of the TOPS (Terra Order Processing System) to keep it up to date on business requirements
• 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 Confidential mainframe systems and applications (COBOL and CICS)
• Participated in the evaluation of long term strategies for support of Agrilance Retail system requirements and creation of test plans. Maintained a stable production environment, performed maintenance and enhanced requests and technical participation on development teams in support of Confidential Retail System
• 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 Confidential sales history. Participated with Auto Pilot for automated testing, load test and performance test, also worked in parallel with teams overseas
• Independently maintained all technical and operational aspects of Confidential s business; dealt with the users, logged complaints and resolutions in Heat and Remedy ticket systems
• Provided support for issues related to EDI (Gentran EBD1001 - Inbound Editor, EBD1041-Inbound Mapper, EBD1002 Outbound-Editor and EBD1042-Outbound Mapper)
• Supervised, mentored and trained new staff, QA new development and special nightly jobs if requested to be scheduled
• Worked with no technical supervision; Created documentation, gathered/ interpreted user requirements and made recommendations, and determined project target dates. Evaluated test scripts and test results to ensure project met requirements and updated user training guide.
• Logged Application/ Program Report errors found during testing of software and systems and followed-up with the team when ready for re-testing
• Created a one plan document to maintain, monitor and update project testing progress, as detailed as possible to include tasks such as milestones for task, module level testing and dry run issues, conversion tables, Sequels, Communications etc. Testing plan was based on the best information and estimation of times from the project plan. Go No Go impact
• Provided and monitored (24/7) the production support continuously for several years

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

Production Support (Mainframe)

Confidential

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).
• A Technical project leader for the Application change releases, top contributor and designer of several projects.
• Redesigned the organizational Database, reviewed User s and Systems requirements, Defined Entities, Process Normal - ization and possible Data Redundancy, Populated IDD with Elements, Grouped Elements to Records, Relationship, Attributes, Transaction priorities, Update and Inquired Ratio, Access keys and Generic keys, DB growth, Database Structure Diagram.
• Backed up and restored procedures. Resolved Applications and User problems, trained Programmers and Users, provided production applications support and resolved number of production after hour issues.
• Organized, formulated and delegated the morning meeting for nightly batch processing and distributed issues and concerns discussed in the meetings.

Technical Environment: IDMS, ADS/O, COBOL, DB2, CICS, MVS, TSO and JCL

Project Lead (Mainframe)

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.
• Documented DL/I and IMS data structures and also added the possibilities of migrating them to IDMS with more systems added to it.
• IDMS database design and development training from ADV Orga of Germany
• 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.
• Schema and subschema areas were identified, coded and compilations.
• Initialized new areas; backup and restore functions
• Build, delete and re-build indexes (index re-organization)
• Dump Report (Files utilization report)
• Area expansion and restructure
• IDMS version migrations
• Provided training and Mentoring to the senior IT staff for Database design, programming techniques to programmers
• Guidance, directions and co-ordinations with team members before executed large Database migration
• Provided big growth to databases, application development and smoothly running production environment
• Resolved application and user problems, provided user support and resolved production applications problems.

Technical Environment: IMS, CICS, IDMS, ADS/O, COBOL, MVS, TSO and JCL