Cris Solano

***** ****** *****

Houston, TX *****

ad262v@r.postjobfree.com

PHONE: 760-***-****

Primary Skills:

EDI analyst, EDI Mapping, Programming, Testing using JDE E1 and SAP ECC.6. Business analyst, QA, Strong Team Player, Excellent Problem-resolution and Presentation skills, Good Communications skills, Analytical Thinking, Customer Focused, Attention to Detail, End to end knowledge of the entire Software Development Life Cycle. More than 24 years working with EDI transactions, X12 and EDIFACT file formats, Distribution(Retail), Banking, Transportation, Manufacturing, Consumer Packaged Goods and healthcare Domains. JDE and SAP(IDOC) integration. Leading B2B development, production support and infrastructure teams. Working with EDI to Flat Files, SQL, XML and SAP IDOC using Map Editor, Visual Mapper, and Application Integrator. Experience investigating API and User Exits code(Java, C, C++) and finding issues and resolving them. EDI implementation in the cloud for OpenText(former TrustedLink TLI on Azure using Windows Server and SQL Server.

Technical Summary:

Platforms: AS400, Mainframe(OS/390), Windows, Unix, Linux EDI Tools: Inovis(TrustedLink, BizManager/BizLink/BizLink Mapper), Application Integrator/Enterprise/Trade Guide

(GXS), Extol, SeeBurger(BIS), IBM Sterling B2B Integrator(Former Gentran), ITX/ITXA (Unix), IBM Transformation Extender(Mercator), Data Stage.

EDI Domains: Financial, Distribution, Manufacturing, Transportation, Healthcare, Consumer Packaged Goods

Software: SQL, PL/SQL, Microsoft Visual Studio 2014, Visual Source Safe EDI Standards: EDIFECS, X12, ANSII 4010 & 3041 formats, D96.A, D93.A, D97.A, VDA Health Care Transactions: 837 (I, D, P), 278I, 276, 277, 835, 270, 271, 820, 834,997 Consumer Packaged Goods: 888, 940, 943, 944, & 945 Supply Chain Transactions: INVOIC, ORDERS, DESADV, IFTSTA, IFCSUM, 850, 810, 856 Ebanking Transactions: FINTSA, PAYMUL, CREMUL, Lockbox Languages: AS400(RPG, RPG/ILE, Cobol), C#, (.NET Framework) SQL, PL/SQL, Java, Java Scripts Databases: Microsoft SQL Server, Oracle, DB2.

Protocols: GXS VAN, SFTP, OFTP2, FTP, Connect Direct, SSH, AS2, Web Services. ETL Tools: IBM Data Capture, Oracle GoldenGate, SSIS, Informatica, Dell Boomi. WORK EXPERIENCE:

Epsilum LLC Houston, TX, Based Company Sep 2015-Current Projects assigned:

- Dean Foods, Dallas Texas, Project Manager 1/3/2021-Current EDI Implementation, warehouse, inventory, manufacturing

· Design, program and implement EDI work flows and API Integration Modules, and Data Exchange using Informatica Tools.

· 3PL/Supply Chain transactions 940, 943, 944, & 945.

· AS400, JD Edwards, IBM Sterling Suit, BizManager400.

- Black & Decker, Baltimore, Project Leader Maryland 12/31/2020 EDI SAP Implementation(EDI, EDIFACT) SAP, EMEA

· Design, program and implement EDI work flows and API Integration Modules, and Data Exchange using Informatica Tools.

· Performs technical needs analysis and project planning for various Business Units

· Conduct technical and application training.

· Assist in Sarbanes/Oxley audits.

· Writing EDI API(Java), Programs Specs JDE 7.3 and JDE E1.

. EDI OpenText(TrustedLink(Inovis, BizManager), TLE Translation Software. Mapping new transactions, creating SAP IDOC Maps.

. EDI Sterling B2B Integrator Mapping new transactions, creating SAP IDOC Maps.

- Unit testing, maps, maps, communication, standards. API’s, Unit testing in between partners.

- Cardone Industries, Philadelphia, PA, Project Manager 5/2018 2/2019 o EDI Seeburger Implementation BIC and SAP Adapter, (EDI X12, EDIFACT)SAP ECC.6.

· Analysis of several EDI Software options

· Perform technical evaluation of EDI Software brands

· Selection of Seeburger(BIS) as an EDI processor

· Seeburger implementation, and EDI .NET Framework

· Conversion more 120 maps from Gentran, BizManager, AS400) to Seeburger(BIS), Data Replication (DB2 to SQL), Informatica Power Center.

- Unit testing, maps, maps, communication, standards. API’s, Unit testing in between partners.

- IPS Corporation (Los Angeles, CA), Senior EDI, ERP SME 1/2017 4/2018 o EDI JDE Implementation(EDI X12, EDIFACT) JDE 9.2

· Design, program and implement EDI work flows and API Integration Modules

· Performs technical needs analysis and project planning for various Business Units

· Conduct technical and application training.

· Assist in Sarbanes/Oxley audits.

· Writing EDI API(Java), Programs Specs JDE 7.3 and JDE E1, and C# (.Net Framework) EDI OpenText(TrustedLink(Inovis, BizManager) Translation Software. Mapping new transactions, creating logical and physical file, Coding user exits and create lookup reference tables.

- Unit testing, maps, maps, communication, standards. API’s, Unit testing in between partners.

- Denso Corporation (Los Angeles, CA), Senior EDI SME 1/2016 12/2016 EDI JDE Implementation(EDI X12, EDIFACT) Oracle EBS

· Design, program and implement EDI work flows and API Integration Modules

· Performs technical needs analysis and project planning for various Business Units

· Conduct technical and application training.

· Assist in Sarbanes/Oxley audits.

. EDI OpenText(TrustedLink(Inovis, BizManager TLI) Translation Software. Mapping new transactions, creating logical and physical file, coding user exits and create lookup reference tables.

- Unit testing, maps, maps, communication, standards. API’s, Unit testing in between partners.

- Migration from IBM Transformation Extender(Mercator) EDI to OpenText(TLI) Health Care Related Projects

• Blue Cross Blue Shield CareFirst – Federal Employee Program Operations Center (FEPOC) Medical and Dentist claims, Medical Plans

- EDI 837, 834, 999 transactions, new implementation.

- Using IBM Sterling suite and ITX as mapping tool.

- Design API and triggers, especial processing.

- Support and troubleshooting.

• CVS/Caremark Project Leader, Chicago IL

Prescription Management, Pharmacy Claims, Orders, Payment Process and Online Orders.

• McLaren Health Care, Project Leader, Flint MI.

Medical Claims, Pharmacy Claims, Billing Process, Payments.

• Eli Lilly, Project Management, Indiana, IN.

Upgrade all EDI System, including all commercial transactions and Health Care Transactions. EDI Tool IBM Sterling B2B Integrator(Former Gentran)

- Elementis, East Windsor, Project Manager, New Jersey EDI Implementation (Elementis LLC), 810, 850, 856, 219, 220, 214. Project Leader and Architect

· Design, program and implement EDI work flows and API Integration Modules

· Performs technical needs analysis and project planning for various Business Units

· Conduct technical and application training.

· Assist in Sarbanes/Oxley audits.

· Writing EDI API Programs Specs JDE 7.3 and JDE E1.

. EDI OpenText(TrustedLink(Inovis/BizManager/BizLink/BizLink Mapping Client Translation Software. Mapping new transactions, creating logical and physical file, coding user exits and create lookup reference tables.

Hewlett Packard, Houston, Texas Sep-2007 – Sep 2015 Senior System Engineer(Business Integration Role, Architect)

• Full setup for new EDI Trading Partners (1065 Partners, Including Walmart, SAM’s Club, FEDEX)

• Developed new maps in order to comply with Trading Partners requirements (850, 856, 810, 820) and full integration with host ERP (JDE E1) using IBM Sterling B2B Integrator(Former Gentran) and IBM Transformation Extender(Mercator).

Analyzed and developed interfaces for converting legacy ERP systems to a global SAP while to remaining seamless to the trading partner.

• Technical Lead on project enhancements and upgrades(JDE/EDI AS400 to Windows), using OpentText(TrustedLink(BizManager) and Data Stage transformation Software.

• Performed Project Management activities such Identifying, managing & controlling changes, Planning work according to the objectives, Analysis and design of objectives Tracking and reporting progress coordinating implementation

• Function as a liaison between internal/external business community and IT (JDE, SAP, Oracle Business Suite) organization in order to provide technical solution to meet user needs

• Document system specifications and solutions to satisfy project requirements.

• Provide system and customer support to users including issue resolution.

• Set up Trading relationships in Inovis, TrustedLink, BizManager and SeeBurger(BIS) integration tool.

• Created and executed queries and Stored Procedure in ORACLE, DB2 and SQL Servers in order to move data from/to staging Database (JDE 47 System), using Informatica Tools.

• Created mapping specifications and performed Gap analysis

• Set up and executed test scripts (documented on MQC)

• Wrote pre-post processing scripts

• Worked with management to set up Service level agreements and Supportability initiatives

• Implemented and complied with change management process Dole Foods, Thousand Oaks, California Nov/2005 – Sep/2007 Senior Project Manager(Integration and EDI)

• Created custom compliance map to validate syntax against X12 flat files, in special 875 X12 EDI transaction.

• Created maps to connect to DB2 and perform logging and loads into JDE ERP System and IBM Sterling B2B Integrator(Former Gentran) as an B2B Integrator.

• Created maps to extract data from DB2 to create flat files

• Utilized Connect Direct to create scripts to transfer files to Mainframe systems and ISeries Systems

• Involved extensively in Implementing QA, Documentation, Testing, Verification and Validation processes

• Created/Modified Stored Procedures for fixes and new implementations in DB2 Data Base

• Participated in business requirements phase for claims and eligibility file structure implementation

• Involved in design and implementation of entire EDI system and produced System Design documentation

• Develop and maintain EDI training manual and system documentation.

• Created maps which called Stored Procedures to create flat file dependent on inputs from a User Interface written in .NET

• Involved in implementing C# code working with C++ called from JDE to send messages to WebsphereMQ and to trigger claims processing

• Scheduled all tasks using Custom Scheduler to kick off EDI processes Invitrogen, Carlsbad, California Jan/2003 to Sep 2005 Project Manager (Integration Role)

Involved extensively in Implementing QA Test Plans, Documentation, Testing, Verification and Validation processes

• Created 837 translation and custom compliance maps for Electronic Mailroom Initiative

• Created Design documents and process/data flow charts for communication and implementation with other business units

• Completed Analysis, Specification creation and maps

• Worked efficiently and effectively with EDI Administration to implement maps.

• Involved in data and requirements gathering to implement numerous projects

• Working with IBM Sterling B2B Integrator(Former Gentran) as a B2B Integrator.

• Coding Java API’s for IBM Sterling integrator, (Custom Maps) Other Permanent Positions and Contracts 4/1998-7/2003 Earns & Young Senior IT Project Leader

• HoMedics Pontiac, Michigan Project Leader, JDE One World XE Implementation, GL, AP, AR, Distribution, Unix, Oracle, and RFC inventory application using devices attached to forklifts reading Big labels at the warehouse and T.L ASHFORD Barcode Label Software, integrate with JDE XE, AS400 Platform.

• Eli Lilly Indianapolis, Indiana, Project Manager, JDE World year 2000 remediation thirty instances around the world, manufacturing and floor control modules.

IBM Professional Services

• Caremark Chicago, Illinois, Project Manager, Design, Developed, Implementation of Health Care Prescription System in IBM Websphere Environment, following the HIPAA principles. Receiving payments and making payments for all health care providers like Aetna, Blue Cross. Also the system allow CERNER and EDI Transactions

(270, 271, 276, 277, 820, 824, 835, 837, 997)

INTERNATIONAL POSITIONS

Costa Rica, Central America

1985-1998 The Bali Co. Administrative Manager, MIS & Finance Division 1981-1984 Institute of Development and Financial Cooperatives MIS Manager

1976-1980 Ministry of Public Transportation

Systems Department Manager

1971-1974 Social Security

Systems Analyst/Programmer

Nicaragua, America Central

1974-1976 Consisa

Systems Analyst

Education

Bachelor Degree, Computer Science, 1984, Universidad de Centroamerica, Costa Rica. Languages

English, Spanish.

Contact this candidate