Edi Consultant Resume
Peoria, IL
SUMMARY:
- Over 5years’ experience as an IT Analyst and Developer with a background in analysis, design and implementation of EDI/EAI and information systems. Ability to apply technology to solve business problems.
- Extensive experience in mapping/translation using GIS Application Integrator. The ANSI X12 transactions included 810, 850, 856, 855, 820, 204, 210, 214, 823,824, 830, 860, 861, 862, 865, 867, 814 and 852.
- Experience in integrating Trading Partners into GIS (Envelop Creation, Map Deployments and Development).
- Developed maps (ANSI X12 & EDIFACT).
- Developed different types of maps (Inbound, Outbound, Flat to Flat, EDI to EDI, XML and EDI to Fax format).
- Experience with SAP, XML and Internet based EDI.
- Working Knowledge of different communication protocol such asAS2, HTTP, HTTPS, FTP, and IBM VAN.
- Knowledge of FTP servers and clients.
- Expertise in client side designing and validations using HTML, XHTML,CSS, Java Script, and JSP
- Experience in handling J2EE Technologies like Servlets, JSP, EJB, and JDBC.
- Good experience in using RDBMS includes Oracle 9i, DB2 UDB, MS - Access and MY-SQL.
- Used regular expressions, UNIX Utilities and shell programming for successful implementation.
- Extensive experience in SQL*PLUS, PL/SQL, SQL*LOADER, Stored procedures, Functions, Triggers and packages.
TECHNICAL SKILLS:
EDI Tools: GIS 4.3/4.2/4.1/4.0 , Gentran NT 5.0/4.0/3.1.1 , Gentran UNIX
EDI Standards Generator: EDISIM 5.0
Industry Standards: ANSI X12, EDIFACT, ROSETTANET and XML
Languages: C, C++, Java, J2ee, JSP and SQL and PL/SQL.
GUI Tools: Visual Basic 6.0.
Database Systems: DB2, Oracle 7.X, Oracle 8, Oracle 8i & Oracle 9i/10g and TOAD
Operating Systems: HP-UX 11.0, Windows NT, Windows XP and Linux (Red hat).
WORK EXPERIENCE:
Confidential, Peoria, IL
EDI Consultant
Responsibilities:
- Developed mapping guidelines/specifications for various Retail Industry Trading Partners.
- Developed GIS maps for Inbound 850 (PO Request), Outbound 810 (Invoice), Inbound 820(Payment Order/Remittance Advice), and Outbound 856 (Ship Notice/Manifest).
- Used Database Adaptors, Application Integrator to translate data from EDI to Database, and vice versa.
- Create test scenarios and developed test data to test EDI maps.
- Involved in Unit testing of the maps.
- Created Maps for various trading partners for transactions 810, 820, 828 and 850.
- Created Visio’s for various Implementations.
- Created Business Processes for Inbound and Outbound Translations using Flat File to X12, X12 to Flat Files, CSV to Flat Files and Flat Files to CSV.
- Deployed Maps and Business Processes into GIS.
- Created Envelops for various Trading Partners.
- Involved in System Testing for End to End process flows.
- Documented the Mapping specs and Process Flows.
Environment: GIS 4.2/4.3, ANSI X12 and Positional Files.
Confidential, Bentonville, AR
Coordinator
Responsibilities:
- Developed mapping guidelines/specifications for various Retail Industry clients.
- Involved in creating Application Layouts from Databases.
- Developed EDI maps for Inbound 850, Outbound 810, Inbound 855, and Outbound 856.
- Created Business Processes for Inbound/Outbound collection, Translation and Error Reporting.
- Created test scenarios and developed test data to test EDI maps.
- Involved in System testing of the end to end flow.
- Developed maps to convert from X12 to XML, SAP IDOC, Positional formats.
- Worked with SAP team in workshops.
- Created maps to translate data from X.12 format to SAP IDOC formats for Orders, Order confirmations, ASN's, Inventory snapshots, and Inventory Transfers.
- Configured SAP, XML adapters to support the business requirements.
- Configured GIS Needs to understand the data tables in SAP.
- Experience in Troubleshooting of IDoc Errors
Environment: EDI ANSI X12 4010, GIS 4.1, Oracle 8.x, SAP IDOC, Windows NT.
Confidential, Southfield MI
EDI Consultant
Responsibilities:
- Developed generic inbound process which uses database to get map name and destination folders to write output files.
- Designed and developed maps using Application Integration Tool.
- Maps Data Types: all combinations with application, standard.
- Designed and developed new Trading Partners and code lists.
- Worked on SAP-SD Master data maintenance and Customer Hierarchy.
- Worked on SAP-SD Business process mapping with 3PL System.
- Worked on ALE/IDOC and other cross functional area with Logistics module-MM, LE, WM
- Worked on SAP-SD Route determination and route cost calculation process in SAP
Environment: GIS 4.0, SAP, EDI ANSI X12 4010.
Confidential
Engineer System Administrator
Responsibilities:
- Monitoring the EDI documents flow in ODEX monitor.
- Monitoring errors and rectifies them thru Remedy tool.
- Assigning PQR’s (Problem Query Result) to concerned teams responsible.
- Scheduling auto tasks and process.
- Creating new maps and schemas.
- Testing Performed unit/system testing on all EDI transactions for both inbound and outbound translations
- Fixing the bugs in Maps and Schemas, updating them with modified ones for smooth flow of transiti3.
Environment: GIS 4.1, Oracle 8i, Windows NT, EDI ANSI X12 4010, 3030.
Confidential
EDI Engineer
Responsibilities:
- Monitoring the EDI documents flow.
- Scheduling auto tasks and process.
- Creating new maps and schemas.
- Fixing the bugs in Maps and Schemas, updating them with modified ones for smooth flow of transition.
- Maps were for both inbound and outbound trading partner relationships.
- Created Business Processes and configured Adaptors for communications.
- Deployed BP’s and Maps into GIS.
- Mapped flat file to ANSI X12 850, 860, 810, 855, 860 transactions and vise-versa.
- Tested with trading partners during user acceptance testing.
- Extensively wrote processing/Mapping rules in the GIS maps.
- Developed new implementations for the Outbound ASN are with Inbound SAP IDOC.
- Experience in Validation and Sanity Testing of EDI X12 to SAP IDocs data.
Environment: GIS 4.1, ANSI X12, EDIFACT, Sterling Rule Manager, Sap idoc and Sterling In-flight.
Confidential
SQL Server Developer
Responsibilities:
- Worked on the project that involved development and implementation of a data warehouse.
- Created Store Procedures, Functions, Triggers, Indexes and Views using T-SQL in all the environments for SQL Server 2000.
- Developed DTS Packages to transfer the data between SQL Server and other database and files.
- Scheduled jobs & Re-Scheduled on Production Databases.
- Created report form with Stored Procedure using T-SQL.
- Wrote and optimized Triggers, Stored Procedures and Queries in T-SQL.
- Created database objects like tables, views and indexes.
- Created and modified stored procedures, triggers and cursors.
- Designed, developed and modified various Reports.
- Handled and managed customer relationship management system.
- Designed, developed, and tested complex queries for Reports distribution.
- Built and performed user acceptance testing on modified reports.
Environment: MS SQL Server … My SQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).