Edi Analyst Resume
Milwaukee, WI
PROFESSIONAL SUMMARY:
- Having 16 plus years of experience in Application software development, testing, production support and maintenance projects in EDI and mainframe related applications in the areas of retail, banking, automobiles, insurance, transportation and finance and telecommunications.
- Extensive experience in Business Analysis to Translate EDI Requirements into Functional Specifications and Develop Logical Mapping for Gentran on Mainframe.
- Highly Experienced in Distribution, Manufacturing, Supply chain, Healthcare, Shipping and Logistics industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
- Extensive experience in various Business Applications like Logistics, Healthcare, Finance, Leasing, Telecommunication, Logistics, Distribution, Retail Healthcare.
- Experienced in working with AS2, SFTP and FTP communication protocols.
- Developed business process for FTP, FTPS, document routing, file edits, Integration and database reporting.
- Expertise on various standards such as EDI ANSI X12, EDIFACT, HIPPA, SAP IDOC, Custom Data formats and XML.
- Proficient with different translation tools like SI Map editor, EDI HQ.
- Proficient working with Graphical Process Modeler for designing Business Processes in SI.
- Expertise in New Trading Partner On - boarding.
- In-depth knowledge of all QA Phases that include Manual, System, End-to- End testing.
- Experience on XML, XSD, XPATH, XSLT and other internet related technologies.
- Testing the maps and the melding flow configuration.
- Migration from mainframe Gentran to Sterling integrator on open systems.
- Experienced writing SQL queries in Oracle, MySQL and IBM DB2.
- Daily checking Project tracking using tools like JIRA, MS Project.
- Worked on COBOL, DB2, JCL, CICS and VSAM.
- Experienced working with File Formats like ANSI X12, EDIFACT, IDOC, CSV, XML, and legacy specified application file formats.
- Worked on flat file, ANSI X12 EDI transactions like 834, 835, 837, 850, 855, 856, 810, 820, 816, 860, 865, 945, and 940, 204, 210, among others.
- Worked on EDIFACT EDI transactions like ORDERS, ORDRSP, DESADV, INVOIC, and REMADV among others.
TECHNICAL SKILLS:
Hardware: Pentium-II, IBM 3090
Operating Systems: Windows XP/2000/98, MS-DOS, Linux, Unix (Solaris),AIX 5.3MVS/ESA (IBM 3090, ES9000)
Languages: COBOL, Pro COBOL, PL/1, JCL, C, JAVA, C++
Databases: IMS/DB, DB2, TERADATA, IDMS, Oracle 8i / 9i / 10G, mySQL
Tools: and Utilities: CA7, CA-11, File-Aid, Platinum, TSO/ISPF, INFOMAN, PANVALET Changeman, Endeavor, Expediter, IBM utilities, CICS, Platinum CA11, EAZYTRIEVE, INTEREST, Control M, IDCAMS, DFSORT, FILEAID, SPUFI, SYNCSORT, QMF, IBM Sterling Integrator 5.x, BPML, Adapters
Oltp: CICS, IMS/DC
Access Methods: VSAM
Standards: ANSI X12 EDI, EDIFACT, HIPAA, HL7, Rosetta net, SWIFT
PROFESSIONAL EXPERIENCE:
Confidential, Milwaukee, WI
EDI Analyst
Responsibilities:
- Migration of trading partners from a legacy system to Sterling integrator.
- Worked on various EDI transaction 850,855,856,810,860,865 and 861.
- Design, code, test, debug, maintain and document Sterling Integrator maps of varying levels of complexity.
- Design, code, test, debug, maintain Business Process at varying level of complexity.
- Closely worked with application team, dealers, and suppliers for UAT (both IB and OB).
- Assist junior development and support personnel in providing solutions to customer related requests and/or system problems.
- Perform impact analysis and on business process/Sterling Integrator system changes and document results.
- Closely worked with different application teams in Gentran sunset project.
- MFT Sterling Integrator and Sterling File Gateway setups in both test and production environments.
- Create dynamic routing channels in SFG using routing channel templates.
- Generate reports from SFG upon request from business group.
- Connectivity testing with trading partner using FTP, SFTP, FTPS, AS2.
- Trading partner contacts, interviews, and investigations to determine the trading partners current file transfer needs.
- Trading Partner onboarding to SI from Gentran which includes setting of trading partner profiles, identities, creating envelopes.
- Accessing the Gentran trading partner profile and get the current envelope information for setting up in Sterling integrator (SI).
- Worked in Agile environment using KANBAN flow.
Confidential, Chicago, IL
EDI Analyst
Responsibilities:
- Migrating the WDI maps to SPS commerce process for that prepared cross reference documents to SPS commerce.
- Load PO’s into DB2 backend database by executing the JCL job and verify the PO’s on customer service screens.
- Created mapping specification documents for Invoice 810,850,855,856,810,214,215,823,860,965,997, to SPS commerce for mapping.
- Worked on various formats like XML, flat files and data bases.
- Protocols: FTP, SFTP, HTTP/HTTPS, AS2 and VAN.
- Perform regression testing for both output files.
- Created map sets for 850,855,856,860,865,940,945,214,215 and 810 using Sterling Integrator 5.2.6.
Environment: COBOL II, DB2 SQL, CICS, JCL, WDI, BPML, Sterling Integrator 5.2.5, services and adapters.
Confidential
EDI Developer
Responsibilities:
- Involved in creating new maps for Trading Partner.
- Created maps for the below listed EDI transaction sets using IBM Sterling Mapping Tool.
- Create envelops and code list on Sterling 5.X.
- The requirement was to create as well as report in a specific format.
- Created map sets for 823,214,215,850,856,855 and 810 using IBM sterling integrator and Gentran.
- Protocols: FTP, HTTP/HTTPS, AS2 and VAN.
Environment: IBM Gentran, windows NT, JCL, COBOL,IBM B2B sterling Integrator 5.1, BPML,SFTP,AS2 and FTP, Adapters and services
Confidential, Glenview, IL
EDI Developer
Responsibilities:
- Translating the data from ANSI X12 to text format in inbound process using the translator.
- Sending an Acknowledgment (EDI X12 997 Functional Acknowledgment) to the trading partners.
- Experience with different "data" structures (EDI, SAP IDOC, APP, flat files, XML etc).
- Involved in creating new maps for Trading Partner.
- Created maps for the below listed EDI transaction sets using IBM Sterling Mapping Tool.
- Create envelops and code list on Sterling 5.X.
- The requirement was to create as well as report in a specific format.
- Created map sets for 823,214,215,850,856,855 and 810 using IBM sterling integrator and Gentran.
- Protocols: FTP, HTTP/HTTPS, AS2 and VAN.
Environment: COBOL II, DB2 SQL, JCL, QMF, Gentran, IBM B2B sterling Integrator 5.X,BPML,Sterling file gateway(SFG), proxy setup for AS2 communication.
Confidential, St. Louis, MO
Senior Application Programmer
Responsibilities:
- Program Analysis and Program technical document preparation
- Modified programs using COBOL, DB2, IDMS, VSAM, CICS, CA- Intertest, File Manager and JCL.
- Code review, report preparation, unit testing, system testing and integration testing, data migration from other systems to current system.
- Wrote new batch COBOL programs and changes of existing programs.
- Interacted with business users and other systems teams to discuss new projects.
- Checked out elements from Changeman and created packages in workbench.
- Coordinate the testing efforts with UAT team and resolved their findings on the application. Assisted setting up the test environment for UAT.
- Production support and find the route cause analysis.
Environment: COBOL II, CICS, DB2 SQL, IDMS, JCL, MQ, QMF, XML, SPUFI, WORKBENCH, OS/390, INTERTEST, FILE MASTER and VSAM
Confidential, Bentonville, AR
Senior Mainframe Developer
Responsibilities:
- Confidential had Rapid Response project to create the tickets by business users. Involved in analysis, design, testing and implementation.
- Analysis of high level business requirements as part of system development.
- Program analysis and program technical spec document preparation.
- Code review and report preparation.
- Unit testing, system testing and integration testing.
- Data migration from other systems to current system.
- Wrote new batch COBOL programs and changes of existing programs.
- Interacted with business users and other systems teams for discussing project enhancements.
- Check-out elements from Changeman and created packages in Changeman.
- Coordinated the testing efforts with UAT team and resolve their findings on the application.
- FTP the converted data from mainframe to UNIX box using the JCL.
- Provided document and check list for change control.
- Created map sets for 214,215,850,856,855,823 and 810 using IBM sterling integrator and Gentran (migration from gentran to IBM sterling Integrator).
Environment: IBM Gentran, windows NT, JCL, COBOL,IBM B2B sterling Integrator 5.1, BPML,SFTP,AS2 and FTP, Adapters and services.
Confidential, Menomonee Falls, WI
Merchandise Planning
Responsibilities:
- As part Quantum Retail Project deployment.
- Running batch quantum jobs thru ESP scheduler and monitor the Linux box.
- Modifying batch jobs and prepared the input data.
- Code review, Review reports preparation Unit Testing, QA and production jobs.
- Interact with system testing team for discussing about new changes.
- Coordinated the testing efforts with UAT (User Acceptance Testing) team and resolved findings on the application on 24X7 basis. Applied patches to different testing environments.
- Prepared one time request form in Lotus Notes and note the catch-up timing for each job.
- Attend project meetings, release meetings and QA status meetings.
- Create Invoice 810, 850, 855,997,823 and 856 using EDI Sterling Integrator 5.x.
Environment: COBOL II, DB2, SQL, PL/I, JCL, QMF, WindowsNT,Web logic, SPUFI, FTP, ESP scheduler, Linux, Oracle, Gentran and IBM B2B sterling Integrator 5.x.
Confidential, Chicago, IL
Senior Systems Analyst
Responsibilities:
- This system loads the data from various systems, validates the data in various levels and loads it into tables. Involved for new functionalities added into the existing programs. Also worked in MOB to fix the data in production tables and worked on adhoc tasks.
- Program analysis and program technical specific document preparation.
- Wrote new programs with COBOL, DB2, and CICS.
- Code review and reports preparation.
- Data migration from tapes.
- Wrote stored procedures.
- Wrote new batch COBOL programs that were run by shell scripts from Unix Platform.
- Coordinate testing efforts with UAT team and resolved their findings on the application. Set up the test environment for UAT.
- FTP the converted data from mainframe to UNIX box using the JCL.
- Developed maps for load data into the oracle database.
Environment: COBOL II,PL/1,CICS,DB2 SQL, IMS DB, JCL, QMF, SPUFI, Changeman, Expeditor, VSAM, Easytrieve, IBM Debugger, GENTRAN, EDI, Informatica, FTP and Heat issue tracker tool, CA-7 and CA-11, Platinum for DB2,Unix AIX, Control-M, Oracle, OS/Z
Confidential, Chicago, IL
Designation: Senior Software Engineer
Responsibilities:
- Wrote backend COBOL program for the Java/JSP front-end screens with Web logic middleware.
- Interacted with the front-end web team for the enhancements and new development. Continuously documented best coding practices for the backend COBOL programming declaring read only cursors with option uncommitted read.
- Resolved Ad hoc problems.
- Wrote new batch COBOL programs that were run by shell scripts i.e. from Unix Platform.
- Supported billing and procurement Mainframe systems 24X7.
- Coordinated testing efforts with UAT team and resolved their findings on the application.
- Check-out elements and create packages from endeavor.
- Converting data from mainframe systems to UNIX box, to load the DB2 tables for Java programs.
- FTP the converted data from mainframe to UNIX box using the JCL.
- Prepare unit/system plans, test data.
- Convert the JCL’s to UNIX box instead of running on mainframe.
- Performed manual testing and UAT testing.
- Performed analysis and documentation of test results.
- FTP the programs thru JCL into the UNIX box.
- Data migration from mainframes to Java application (DB2 to Oracle).
- Confidential tortoise for check-in, check-out components and version control tool.
- Created map sets for 850,856 and 810 using IBM sterling integrator and Gentran
Environment: Micro Focus COBOL,DB2 SQL,JCL, Easytrieve, CICS, Gentran, QMF, SPUFI, Changeman, Expeditor, AFP, JHS, UNIX(IBM AIX), SYNC SORT, Oracle, EDI,AQT, Shell Script, FTP, VSAM, JAVA, IBM Web Sphere and MQ Series, PL/SQL,OS/Z
Confidential
Senior Software Engineer
Responsibilities:
- Translated requirements into detailed design document and coded the COBOL programs.
- Traced the job a bends and communicating with the operation team with a resolution.
- Medical, Vision client totals in the jobs.
- Monitoring the Batch jobs using CA-7 and also supporting VFS systems 24X7.
- Prepare the daily reports for claims like vendor fee reimbursement (VFR), vendor claim Reimbursement (VCR), hospital savings program (HSP) and interface.
- Created multiple one time use report COBOL programs as business users requested. Documented the productions bends along with the resolution and updated the existing documents as needed.
- Create packages and Check-out elements from endeavor.
- Wrote stored procedures.
- Performed UAT testing, analyzed and documented test results.
- Provided support for system testing and implementation.
Environment: COBOL II, DB2 SQL, JCL, QMF, SPUFI, Endeavor, CA-7, Expeditor, JHS and VSAM
Confidential
Senior Software Engineer
Responsibilities:
- Quick Lease Confidential Order Maintenance is a system used to inquire the vehicle information and to assign a vehicle to particular order number. It performs the unassigned, changes and deletes information of particular order number. The system which is replacing this transaction from mainframe and enable with web using the MQ Series.
- Wrote new programs in COBOL, DB2 and CICS.
- Involved in meetings to gather information and requirements from the clients.
- Responsible for error code testing
- Analysis of the business requirements provided by the clients.
- Preparation of Program Specs and interact with customers.
- Used SQL to access data. Used QMF and SPUFI to validate test results and documented the test results using Microsoft Word. Set up after test walkthroughs.
- Conduct weekly walkthroughs on the application progress for meeting schedules and provided testing standing periodically to the higher management.
Environment: COBOL II, DB2 SQL, CICS, Panvelet, Expeditor, QMF, SYNC SORT,SPUFI,JAVA, MQ Series, IBM WebSphere and JCL.
Confidential
Senior Software Engineer
Responsibilities:
- The Healthy Balance System is created to support Confidential Corporate Medicals initiative of reducing medical costs by achieving better health for its retirees, employees, and dependents. Healthy Balance System is a hybrid system developed to take advantage of cutting edge web technology and power of mainframe computing.
- The objective of this project is to assign a unique identifier to healthy balance population, employee, retiree, spouses, surviving spouse and external clients and utilize this unique identifier throughout the system.
- Wrote new Programs Cobol, DB2, Code review, Review reports and perform unit testing.
- Monitoring the Batch jobs.
- Check out the elements from production using Endeavor tool.
- Creating the packages for moving the Acceptance test regions.
- Analysis of the Business requirements provided by the clients.
- Create test data to perform System, Assembly and Regression testing.
- Coordinate the testing efforts with UAT (User Acceptance Testing) team and resolve their on the application, it also involved Setting up of the Test Environment for UAT.
Environment: COBOL II, DB2 SQL, JCL, Endeavor, QMF, SPUFI, AFP, Expeditor
Confidential
Programmer Analyst
Responsibilities:
- Global network services are network provider for Confidential bank. The application already existing and doing the manual dispute settlement transactions, the major enhancement of the project is to automatic settle the dispute transactions, and also including the pricing method for all message types like Chargeback, remittance, Presentment and network fee.
- Program Analysis and Program Specification Document preparation
- Wrote New Programs COBOL, DB2 (SQL) and monitoring the Batch jobs.
- Involved in meetings to gather information and requirements from the clients.
- Maintenance and 24/7 production support.
- Prepare the time details for batch jobs.
- Test the stress testing on mainframe with millions of records.
- Received the calls from various groups who they are supporting the other systems.
- Analysis of business requirements and preparation of program specs interact with customers.
- Created test data to perform System, Assembly and Regression testing.
- Analyzed and validated test results to ensure existing functionality and recommend corrective actions where necessary.
- Participate in daily meeting with the team, walkthroughs and defect tracking meetings.
Environment: COBOL, DB2 SQL, JCL, Changeman, Infoman, QMF, SPUFI, Expeditor