PROFILE:

Confidential has over 20 years of experience within the Information Technology Industry; with expert knowledge on IBM Mainframes, MVS OS/390. He is an expert 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). He maintained project tasks with changing priorities and tight deadlines. He worked on several technical challenges and provided solutions approved by all stake holders. He has demonstrated proficiency in leading, monitoring and mentoring individuals to maximize levels of productivity, while forming cohesive team environments. He worked with Mainframe, JDE (Financial Modules and Asset Management), SQL SSIS (ETL) SSRS, SRS, SDS, JDA Supply Chain.

TECHNICAL SKILLS:

COBOL, IDMS (V 5.7, 10.2, 12 …V17), ADSO, TPSORT, CICS, DB2, IMS - DC, DL/I, JCL, SQL, VSAM, TSO/ISPF

JDE, SSIS, SSRS, TOAD, DBVisualizer, VPN, HTML, JAVA

Heat, Remedy, ServiceNow

MVS OS/390, Z Series, AS/400 & iSeries, UNIX, Windows and Servers.

PROFESSIONAL EXPERIENCE:

Confidential

Systems Analyst

Responsibilities:

• Confidential enhanced and maintained running applications on mainframe, and designed and developed new user requirements. He also provided production support for online and batch processing. He provided daily monitoring of QA imports and dealt with any issues that arose. He documented issues in Remedy, created internal tasks for development work, and created project requests for work, and sought approval prior to commitment.
• 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
• 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. Also documented user requirement and design document (SRS and SDS)
• 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)
• 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. Some Netron processor graphical debugger

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

Confidential

Senior Support Analyst(

Responsibilities:

• Worked with users on all technical issues, daily operations and ad - hoc requests; watched daily system maintenance reports and after hour application support
• Worked with ZEKE for batch job scheduler; scheduled 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 SQL and WEB
• Following the SDLC; provided system analysis, project design, 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, IDMS, DB2 along with SQL servers
• 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 development teams in accordance with QA guidelines
• Developed the templates used for test cases/ scripts, test plans, test summary reports and UAT using MS Word and MS Excel
• Trained EDS employees, documented and smoothly hand over the project upon departure

Environment: COBOL, DB2, IDMS, SQL, TSO/ISPF, CICS, MQ Series, Expeditor, Fileaid and JCL

Confidential

System Analyst

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. Documented user requirement, design and development documents.
• 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 (COBOL, 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
• JDE, COBOL, DB2, SQL, PL/SQL, Oracle, AS/400 and iSeries

Confidential

Lead Analyst

Responsibilities:

• 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 IBM mainframe systems and applications (COBOL and CICS), worked portions of design and user requirements.
• 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
• 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
• 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
• COBOL, CICS, IDMS, ADS/O, DB2, JDE, Oracle, MQ SERIES, FILEAID, MVS, TSO and JCL