Systems Analyst Resume Profile
IL
SUMMARY OF QUALIFICATIONS
- computer industry experience
- IBM mainframe
- EDI
- Extensive background in the IBM mainframe with expertise in Sterling Commerce Gentran EDI, DB2, SQL, COBOL, VSAM, CICS, RPG, Natural/Adabas.
- EDI experience using Gentran on the mainframe, GXS/Inovis Trusted Link software on the mainframe, Windows TLW , Unix TLE , and iSeries/AS400 TLI .
- SAP IDOC's
- Experience using MS Access and SQL server
- Duties included tasks throughout the entire life cycle including requirements definition, analysis, design, coding, testing, implementation, and support.
- Architect, Analyst, Designer, Developer, Data Modeler
TECHNICAL SUMMARY
Platforms Programming Databases
- Mainframe 30 years Cobol 9 years Natural/Adabas 8 years
- AS400 7 years Natural 8 years DB2 6 years
- Unix 3 years SQL 6 years VSAM 6 years
- iSeries 2 years CICS 5 years Access 3 years
- Windows RPG2 5 years DB2/400 2 years
- Access 3 years Oracle 3 years
- Easytrieve 3 years SQL server months
- Cobol400 1 year
- RPG400 1 year
EDI Software Packages Application Software Packages
- Gentran Basic Mainframe 14 years JDA 2 years
- Trusted Link Map Workbench 4 years SAP 2 years
- EDISIM 2 years Lawson months
- Trusted Link Unix TLE 3 years JDE months
- Trusted Link Windows TLW 1 year SunGard months
- Trusted Linked iSeries TLI 6 months
- Trusted Link Visual Mapper 6 months Data Modeling
- Extol months Erwin 1 year
- EDIFECS months
Change Management Microsoft
- ITIL 2 years Word
- Endevor 2 years Excel
- Remedy 1 year Visio
- MKS 1 year Outlook
EXPERIENCE
Confidential
EDI Consultant
- Convert from the Gentran Mainframe t SI Sterling Integrator, and GXS/Advantis t SFG Sterling File Gateway.
- Environment Mainframe, Unix, Gentran, Cobol, Easytrieve, JCL, TSO/ISPF, GXS/Advantis, SAP, JDA, Lawson, ESP, SAR, Word, Excel, Visio, Outlook, Remedy, Fileaid, Sharepoint, Sterling Connect Direct, SFG Sterling File Gateway
Abbott Nutrition
Confidential
EDI Consultant
- Analyzed, Designed, Developed, Implemented and Supported the implementation interfacing with the WMS Warehouse Management System 3rd parties, utilizing Unix TLE .
- Created EDI guides performed unit and integration testing, implemented and supported the EDI transactions including the 846 Inventory Inquiry, 856 Ship Notice, 940 Warehouse Order, 944 Receipt Advice, 945 Ship Confirmation, and the 947 Inventory Adjustment.
- Monitored the TLE error log.
- Handled boarding requests.
- Environment Unix, TLE Trusted Link, Word, Excel, Outlook, EDIFECS, SAP, IDOCS, Putty, Ultra-Edit
Confidential
EDI Consultant
- Analyzed, Designed, Developed, Implemented and Supported the migration of the EDI on the mainframe Gentran t Iseries TLI Trusted Link for the Exit Mainframe project.
- Created EDI guides and mapping projects using GEFEG FX, developed the maps using TLI and the Visual Mapper, performed unit and integration testing, implemented and supported the EDI system.
- Environment Iseries, TLI Trusted Link, Visual Mapper, CL, Word, Excel, Lotus Notes, Project Place, GEFEG FX, SVN, DBU, DDS, Centrasite ActiveSOA, EDIFACT
Confidential
EDI Consultant
- Architected, Analyzed, Designed, Developed, Implemented and Supported an Inbound and Outbound Gentran EDI Gateway t migrate the 850 purchase order, 810 invoice, and 856 advanced ship notice for vendors from the existing applications systems t SAP and JDA for the SAP/OTC project.
- Setup the EDI communications between the trading partners using GXS/Advantis VAN.
- Analyzed the existing architecture, provided estimates, designed the new architecture including creating high level and detail design specifications, developed the Gentran application files, maps, and tables, IBM mainframe jobs and procedures, developed email alerts and reporting, performed unit, trading partner, and integration testing, implemented and supported the EDI system for these vendors.
- Environment Mainframe, Gentran, Cobol, Easytrieve, JCL, TSO/ISPF, GXS/Advantis, SAP, JDA, Lawson, ESP, SAR, Word, Excel, Visio, Outlook, Remedy, Fileaid, Sharepoint, Oracle SQL Developer, Oracle, VSAM, Putty
Confidential
EDI Consultant
- Modify, test, and implement 130 existing Inovis TLE maps t accommodate the GLN Global Location Number. The EDI transactions included are the 850/875 purchase order, 855 purchase order acknowledgment, 810/880 invoice, and the 856 advanced ship notice. The SAP Idoc's included are the ORDERS, ORDERSP, INVOICE, DELVRY and the DESADV.
- Environment Unix, Inovis TLE, Word, Excel, Lotus Notes, FTP, MKS, UltraEdit, XML, Ultra-Edit
Confidential
EDI Consultant
- Support and enhance the EDI applications including the 850 purchase order, 852 product activity data, 860 purchase order change, 861 receiving advice, and 867 product transfer. Support and enhance the handshake between EDI and the applications.
- Environment Mainframe, AS400, Gentran, Cobol, Easytrieve, VSAM, JCL, TSO/ISPF, Word, Excel, Visio, Lotus Notes, VSAM, FTP, SAR
Confidential
EDI Specialist
- Created mapping design specifications for interfacing between the internal DB2/400 internal user files and the SPS Saint Paul Software SIP flat file format. Lead the testing with SPS Saint Paul Software. The transaction sets implemented include the 810, 812, 820, 824, 830, 850, 853, 855, 856, 860, 861, 862, 864, 870, DELFOR, DELJIT, RECADV, and DESADV for approximately 75 trading partners and 150 trading partner transactions.
- Environment iSeries/AS400, Trusted Link TLE/400, DB2/400, RPG400/ILE400, JDE, Word, Excel, Visio, EDIFACT
Confidential
EDI Analyst and Data Architect
- EDI architect, analyst, developer within Finance IT for the Pharmacy A/R system. Performed the entire life cycle including analysis, design, coding, testing, and implementing the EDI 835 Health Care Payment transaction transitioning from a 3rd party.
- Data Modeler within Finance IT for the Vendor Income Processing system. Developed the data model for the re-engineering of the Automated Vendor Income system.
- Environment Mainframe, Cobol, DB2, Easytrieve, Erwin, JCL, TSO/ISPF, Access, Word, Excel, Outlook, Visio, Endevor, VSAM, FTP, ITIL, Quality Center, Strobe
Confidential
EDI Support
- EDI support for the PowerTrack system including the 110 air carrier freight details and invoice, 210 motor carrier freight details and invoice, 214 shipment status, 310 ocean invoice, 315 shipment status ocean , 810 invoice, 850 purchase order, 858 shipping information, and 859 freight invoice,
- Certified EDI transaction sets including the 310 ocean invoice, 810 invoice, and 850 purchase order.
- Environment SQL Server, Mercator 6.7, Word, Excel, Lotus Notes
Confidential
EDI Developer
- Converted the EDI processing from the mainframe t the Unix.
- Architected, Analyzed, Designed, Developed, Implemented and supported transportation EDI transactions sets including 214 carrier shipment status, and warehouse transaction sets including the 940 warehouse order, 943 shipping advice, 945 ship confirmation, 944 receiving advice, 846 inventory inquiry, 947 inventory adjustment, and 812 credit/debit adjustment, 864 text message, along with other miscellaneous transaction sets.
- Environment Mainframe, Unix, Inovis Harbinger Trusted Link EDI software, SQL, Cobol, CICS, Easytrieve, VSAM, EDISIM, JCL, TSO/ISPF, Word, Excel, Lotus Notes. XML, Cyclone
Confidential
EDI Developer
- Implemented claims insurance EDI transactions sets including 148 injury report, 837 health care claim, 835 healthcare payment, 272 loss notification, 811 consolidated invoice, 820 remittance advice, along with other miscellaneous transaction sets.
- Environment Mainframe, Gentran EDI software, JCL, TSO/ISPF, Word, Excel, Lotus Notes
Confidential
EDI Developer
- Designed, Implemented and supported warehouse EDI transactions sets including 940 warehouse order, 943 shipping advice, 945 ship confirmation, 944 receiving advice, 846 inventory inquiry, along with other miscellaneous transaction sets.
- Implemented and supported EDI auction transaction sets including the 850 purchase order, 860 purchase order change, 855 purchase order acknowledgment, 861 receipt, and 810 invoice.
- Environment Mainframe, Unix, Inovis Harbinger EDI software, SQL, Cobol, VSAM, Easytrieve, EDISIM, JCL, TSO/ISPF, Word, Excel, Lotus Notes, XML
Confidential
EDI and Mainframe Developer
- Designed, Implemented and supported EDI transactions sets including 850/875 purchase orders, 810/880 invoices, 820 remittance advice, 856 advanced ship notices, vendor managed inventory and point of sale transactions including the 852 product activity data, 830 planning schedule, and 867 product transfer and sales report, along with other miscellaneous transaction sets including 824 application advice, and 864 text messages.
- Designed, developed and maintained departmental Microsoft Access databases including status reporting for project tracking, time reporting, and recharge, EDI gateway metrics, incident reporting, advance ship notice reporting, and purchase order metrics, and survey databases.
- Environment Mainframe, Sterling Commerce Gentran, DB2, Cobol, VSAM, MS Access, SQL, EDISIM, JCL, TSO/ISPF, Word, Excel, Lotus Notes, VSAM, FTP, Cyclone, EDIFACT, Connect Enterprise
Confidential
Mainframe Developer
- Designed and developed an event driven EDI system for Matsushita, on-line pharmaceutical subsystem for UHC, membership system for CSAA, country profile system for UPS, and a fixed asset accounting system for NSP.
- Environment Mainframe, DB2, Cobol, CICS, VSAM, SQL, Natural/Adabas, Easytrieve, JCL, TSO/ISPF, Word, Excel, Lotus Notes
Confidential
Senior Programmer Analyst
- Designed, developed, and maintained subsystems including accounting, order entry, production control, purchasing, and engineering.
- Environment Mainframe, Natural/Adabas, JCL, TSO/ISPF, Word, Excel
Confidential
Systems Analyst
- Developed an apparel business system and converted from the mainframe t the AS400.
- Environment Mainframe, AS400, Cobol, VSAM, Natural/Adabas, RPG, JCL, TSO/ISPF
Confidential
Senior Programmer Analyst
- Designed, developed, and maintained subsystems including accounting, order entry, production control, purchasing, and engineering.
- Environment Mainframe, Natural/Adabas, JCL, TSO/ISPF, Word, Excel
Confidential
Programmer/Analyst
- Converted from the IBM System 3 t the mainframe.
- Designed and developed manufacturing subsystems for accounting, production control, engineering, and order entry.
- Environment Mainframe, CICS, Cobol, VSAM, RPG, JCL, TSO/ISPF
Confidential
Programmer/Analyst
- Modified Cobol applications for the maintenance team.
- Environment Mainframe, Cobol, JCL