Sr SQL/RPG/EDI Developer
Information Technology
Apr 2017 - present
Garland, TX
* RPGIV/ILE/FREE, & CL programming on iSeries
• SQL, Embedded SQL, PHP, prototypes, procedures, service programs.
• API calls, binding directories, triggers, and stored procedures.
• JD Edwards ERP development on iSeries all suites.
• System integration, iSeries systems, security support, and SQL
• DB2 relational database DBA
• IT Financial services in Mortgage Servicing (LSAMS)
• Advanced MS Office & Lotus Notes
• Managed multiple project assignments, self-managing workload to meet all expected delivery dates.
• WebSmart & VISUAL STUDIO .Net development.
• Websphere Data Integrator (WDSC), web services/applications.
• XML, AJAX, JSON, & HTML.
• WDI maximizing data integration development time.
• Change Management using Implementer, Hawkeye, XAnalysis, and ZMOD Web Development: PHP, HTML Javascript, and Zend Framework
• MDCMS and RDI development tools utilized
• SFTP/FTP, AS2, EDI mapping, trading partner interaction/setup, & development
• JD Edwards financials.
• IBM i DB2 database, IFS, Apache WebServer
• Advanced Windows and MS Office tools
• WebSmart development
• VISUAL STUDIO .Net development
• EDI mapping, trading partner interaction/setup, & development
• SFTP/FTP & AS2 trading partner setup for transaction processing
• Data Mapping for integration from source to destination for specifications utilizing EDI and FTP to import for migration or merging for integration
• Oracle, MySQL, MicroStrategy, Developer and Mainframe Cobol/DB2
• Support KRONOS upgrade/Implementation (Version 6 to 8)
• Handled everything functional around the project
• Hands on technical work for support/troubleshooting purposes
• Jira project tracking
SR Software Engineer/EDI Manager/Technical Specialist
Information Technology
Nov 2004 - Apr 2017
Dallas, TX
* EDI Manager using Sterling Integrator, GXS, Gentran, Trusted Link client and AS2 Biz Mgr/Biz Talk, WebMethods B2B, iSeries on multiple lpars, Manufacturing and Distribution of Dairy products on iSeries.
• EDI mapping in JWALK both X 12 & XML.
• Data Mapping for integration from source to destination for specifications utilizing EDI and FTP to import for migration or merging for integration
• Project lead and developer on multiple JDE, BPCS, & EDI projects on iSeries.
• Utilize RPG/400/ILE/Free, embedded XML, C, SQL and stored procedures.
• Use of Implementor and Aldon change management for project implementation.
• AGILE Methodology.
• DB2 relational database DBA.
• EAI for integration.
• IBM Sterling Software suite utilization.
• CMS using PHP & MYSQL.
• SFTP/FTP customer processing.
• ADP & WORKDAY HR processing development.
• SAP migration and interface to Trusted Link using XML.
• WDI ERP data integration development for maximization.
• ERP/SFA Financials development.
• eCommerce Channel - Direct Traffic.
• Lean Logistics OTR Traffic Manager.
• ASC Trac WMS using SQL Server.
• CRM utilizing Trusted Link Client & AS2 BizMgr/BizTalk, Gentran, WebMethods B2B/AS2.
• PHP web development using Zend Server. Workday HR reporting. IBM Sterling Integrator.
• WebSmart Development
• VISUAL STUDIO .Net development
• Production Support for SDLC & DEVOPS.
• Kronos (v6.2 & Higher) - Base Configuration, Manager/Employee Timecard Approval, People Record, Labor Levels, Timecard View, Timecard Edits, Paycode Edits, Timecard Reconciliation, Historical Edits, Timecard Audit, Transaction Assistant, Accrual Balances, Genes, Hyperfind Queries, Core Reports, Remote Clocks, Security.
• Analysis and design using object methods in support of authoring System Requirements documentation.
• Developed interfaces to ADP from KRONOS on iSeries and FTP to IFS for data transfer.
• Design & creation of test plans & test cases supporting the test plans.
• Advanced SQL development skills used in support of testing & trouble shooting custom solutions.
• Functional understanding of Quality Center working independently & as a team member.
• Supply Chain and Logistics support for forecasting and Truck Management of 3rd party carriers.
Sr. Software Engineer
Information Technology
Feb 2001 - Nov 2004
Plano, TX
* Sr. developer on iSeries for mortgage servicing software.
• Perform new system development, programming including coding, testing, documentation, Implementation and end-user support utilizing RPG ILE & Free, embedded XML, C, SQL and stored procedures.
• Web development utilizing .Net, Asp.Net & Websphere Data Integrator (WDSC).
• DB2 relational database DBA.
• JDA ERP development on iSeries.
• Use of TURNOVER change management software.
• Mortgage Servicing software development on iSeries in house developed software.
• EDI utilizing AS2 BizMgr/Biz Talk B2B, IBM Sterling Integrator.
• Data Mapping for integration from source to destination for specifications utilizing EDI and FTP to import for migration or merging for integration
• Production Support for SDLC and DEVOPS.
• Websphere Development Studio Client (WDSC) for coding and Data Integration.
• VISUAL STUDIO .Net development
• KRONOS (v6.2 & higher) - Base Configuration, Manager/Employee Timecard Approval, People Record, Labor Levels, Timecard View, Timecard Edits, Paycode Edits, Timecard Reconcilation, Historical Edits, Timecard Audit, Transaction Assistant, Accrual Balances, Genes, Hyperfind Queries, Core Reports, Remote Clocks, Security.
• Analysis and design using object methods in support of authoring system requirements documentation.
• Developed interfaces to ADP from KRONOS on iSeries and FTP
• Design and creation of test plans with supporting test cases.
• Advanced SQL development skills used in support of testing and troubleshooting custom solutions.
• Functional understanding of Quality Center working independently and as a team member.
Sr. Programmer Analyst
Information Technology
Sep 2000 - Feb 2001
Plano, TX
* Team Lead for DPI Telephony software Usage group on iSeries.
• Perform new system program development & maintenance in ILE, including analysis, design, coding, testing, documentation, implementation and end-user support.
• Use of TURNOVER change management software.
Sr. Programmer Analyst/Int'l Project Manager
Information Technology
Jun 1997 - Aug 2000
Plano, TX
* Project Manager for all International sites: Australia, Mexico, & Canada on iSeries.
• Ongoing analysis of current applications for maximum utilization of system utilities.
• Perform new system development and maintenance programming, including analysis design, coding, testing, documentation, implementation and end-user support for Daisytek Austrailia. Tools AS400, RPGIII, /400/ILE & JD Edwards 7.3 World ERP, WebSmart Development Studio Client (WDSC) for coding and Data Integration.
• Planned, coordinated, and implemented new versions of VERTEX tax software and standardized tax calculation for Order Entry/Invoicing/GL/AP/AR applications within JD Edwards World, IBM relational DB2 database concepts and design.
• Conduct ongoing training for JDEdwards/Daisytek applications for new IT employees.
• Managed a staff of four programmer/analysts in the support and integration of both custom and packaged JDE World applications, all suites.
• Support, development, & maintenance of Purchasing & Inventory JDE World Suites.
• Support of JDE World interfaces to Rapastan race track & Pick-to-Light warehouse setup.
• Mapping, testing and coordination of EDI GENTRAN software with JDE World.
• Reworked DREAMWRITER versions for invoice faxed acknowledgements for entire company.
• IBM Sterling VAN.
• IMPLEMENTOR Change Mgmt Software for JDE World ERP SDLC.
Sr. Systems Engineer
Information Technology
Apr 1996 - Jun 1997
Richardson, TX
CU Services Sr. Systems Engineer
• Performed new system development and maintenance programming analysis, design, coding, testing on iSeries.
• Documentation, implementation and end-user support. Programming accomplished utilizing
• RPG III/400/ILE. Applications software supported: LINK21 & PEERLESSCU (ALLEGRO).
• Implemented PEERLESSCU (400) for multiple client sites from the LINK21 (36) software.
• Produced streamlined requirements Documentation for software conversions and DB2 relational database concepts and design.
Sr. Software Developer
Information Technology
Dec 1994 - Mar 1996
Dallas, TX
* Performed new system development and maintenance programming utilizing SDLC on iSeries. * Programming was accomplished utilizing RPG III/RPGLE/400.