Eugene Kotlar Resume



SummarySeasoned Information Systems professional with 20+ years of diversified Analysis, Design, Programming, Implementation, Consulting, and Management experience focusing on the iSeries environment. Ability to hit the ground running and make immediate contributions.Excellent communication skills, self-motivated, quick learner, and team player.Technical SkillsHardware:IBM I (former AS400), System 38, Sun Software:JDA MMS, LogPro, BPCS, Custom Legacy Systems, MS ProjectLanguages: SQL, RPG – all versions, CL, XML, RPG-XML Suite, JavaScriptDevelopment: RDi, DBU, RLU, SDA, X-Analysis, HawkeyeTesting: Toad Datapoint, TestBench, SoapUI, Postman Communication: GETURI API, Email APIs, FTP, Data Queues, IFS APIsLifecycle Mgmt: MKS Implementer, Aldon CMS, JIRA, Azure DevOps Data Mgmt:ODI, MuleSoftThird Party: E-Dialog, Epiphany, PlanetPress Professional ExperienceMajor Retailer, NYJuly 2019 – PresentSenior Software Developer/ConsultantDesigned, developed, and implemented Webservice-based platform to allow automatic parts procurement from multiple vendorsDesigned, developed, and implemented a platform for automatic invoice validation and approvalAll new applications are created using fully free RPG, DDL, ILE concepts, embedded SQL. The new platform is supporting REST and SOAP Webservices with XML and JSON messaging. Composing, transmitting and parsing is done using RPG-XML suite of applications developed by Krengel Technology Implemented multiple enhancements to the existing ERP systemEnvironment: RPG FREE, DB2 SQL, RDi, Postman, RPG-XML SuiteUnifirst, MAMarch 2018 – July 2019Senior IBM Power System (former AS/400) ConsultantParticipating in data conversion project migrating data from DB2 on IBM Power System to Oracle.Creating mapping, technical and QA entry documentation.Designing, coding and unit testing conversion programs using RPG FREE and embedded SQL.Creating SQL views to define business rules for data extraction.Creating stored procedures for Mendix Low Code and MuleSoft teams to access/update legacy data.Creating data maps for ETL team Record count and end-to-end audit reporting are done using Toad Datapoint by running queries against source, staging and target data points.Running mapping sessions with the software vendors identifying data gaps and reporting it to the upper management and the business. Environment: RPG FREE, DB2 SQL, RDi, ODI, ETL, MuleSoft, Toad DatapointMBI Inc., CT May 2016 – Jan 2018iSeries ConsultantMigrating applications current written in Access and Excel to iSeries native code, saving on significant licensing fees.Converting homegrown ERP system databases from DDS defined files to SQL driven DDL using tables, indexes, views, and triggers.Replacing business logic using SQL views and Stored Procedures.Utilizing SQL scalar functions, ranking, partitioning, and nesting to define complicated views. Converting existing paper-based reports to Excel/PDF, allowing reports to be distributed via email. Environment: OMS, RPG, CL, SQL, Implementer, Hawkeye, DB2 Triggers, ILE functions and utilities, Email APIs, FTP/SFTP, RDi, IFS APIseBay Enterprise, PA Feb 2012 - May 2016Principal Software EngineerCoordinated interfaces within multi-platform environment ensuring web orders validation, allocation, and fulfillment.Made modifications to existing code to enable new configuration functions. Conducted code reviews. Provided test scripts for user acceptance testing. Participated in new development of enhancements to current JDA MMS transactional system with Omni-Channel functionality utilizing heavy XML messaging and GETURI API. The new system is fully supportive of In-Store-Pickup, Ship-to-Store and Ship-from-Store retail modules. Environment:JDA MMS , LogPro, RPG, CL, SQL, Aldon ACMS , X-Analysis, DB2 Triggers, ILE functions and utilities, Email APIs, FTP/SFTP, soapUI, TestBench, RDI, JIRA, E-Dialog, Epiphany, GETURI and IFS APIsGSI Commerce, PA Mar 2010 – Feb 2012iSeries ConsultantParticipated in B2B multiple launches of major boutique retailers. Coordinated JDA MMS Sales Audit configuration and new development effort for client brand name line to be sold through third-party e-commerce solution. Environment:JDA MMS , LogPro, RPG, CL, SQL, Aldon ACMS , X-Analysis, DB2 Triggers, ILE functions and utilities, Email APIs, FTP/SFTP, soapUI, TestBench, RDI, JIRA, E-Dialog, Epiphany, GETURI and IFS APIsTauck World Discovery, CT Feb 2008 – Jan 2010iSeries ConsultantTook part in database and application transformation project taking system from green screen and mostly flat file-based database to GUI Java-based front-end relational DB2 using data access layers technique.Modified legacy RPG code to access data using access layers, writing SQL and Free RPG based store procedures for data layers and Java Web Sphere services. Environment:RPG, CL, SQL, WDSC, Code 400, MKS Implementer, X-Analysis, DB2 Triggers, ILE functions and utilities, Email APIs, FTPDuane Reade, NY Nov 2006 – Feb 2008iSeries ConsultantCreated new Central Fill Inventory Replenishment application to provide the mechanism for replenishing from available RX inventory versus always supplying shortage from vendors. An application was seamlessly integrated with JDA MMS database. The system was seamlessly integrated with MMS and BlueCube database. Robust forecasting functions allowed for streamlining new store opening procedures and planning. Created multiple reporting tools for sales analysis, replenishment, loss prevention and inventory control subsystems. Environment:JDA MMS, RPG, CL, SQL, Aldon CMS, MMS advanced logging, DB2 Triggers, ILE functions and utilities, Email APIs, FTP, ASC's SEQUELMervyns, CA Sep 2006 – Nov 2006iSeries ConsultantParticipated in new development and implementation of Supply Chain Management system. An application is implemented under JDA MMS510 umbrella. It provides an ability to track inbound ASN’s (856) and map it to the original PO’s (850). It also provides the function for Trailer/Shipment (214) acceptance. Created centralized repository for EDI errors (864) to provide the client with automated ability create Vendor Compliance Requests. Environment:JDA MMS, RPG, CL, SQL, SoftLanding Turnover CMS, DB2 Triggers, ILE functions and utilities, Crystal ReportsCabela’s, NE Dec 2005 – Sep 2006iSeries Consultant & Team LeadParticipated in multi-channel transformation project implementing JDA MMS510. Implemented subsystems: Product, PO, Catalog, Costing, Pricing, Special Promotions, and Warehousing.Hands-on development used a variety of iSeries technologies, including FTP, TCP/IP, native programming languages ILE RPG and CL, Java, advanced printing protocols.Used Web Methods to communicate data between various platforms and iSeries environments. Environment:JDA MMS, RPG, CL, Java, SQL, Aldon CMS, DB2 Triggers, ILE functions and utilities, Crystal Reports, Web Methods APIs, FTPAmscan, NY Aug 2005 – Dec 2005iSeries ConsultantParticipated in BPCS 5.1 maintenance and production support. Wrote ZMOD to BPCS interface. Developed Sales/Inventory history report generated on iSeries server and downloaded into Excel format. Responsible for day-to-day support for Passport Xchange EDI system. Used AS/SET as the development tool and program generator. Environment:BPCS, AS/SET, RPG, CL, Java, SQL, Aldon CMS, DB2 Triggers, ILE functions and utilities, FTPVIKO Publishing House, Russia Nov 2003 – Aug 2005Project Manager and AS/400 ConsultantDesigned and created ERP application for the international client in a printing industry. Worked with DB2-based relational triggered database and AS/400 green screen multilingual UI.Wrote business procedures to support GL, AP, AR, Cash remittance, Shop Floor, Order Entry, Billing, Inventory control, Shipping, and CRM; performed Web marketing reporting.Environment:RPG, CL, JavaScript, CGI, SQL, DB2 Triggers, ILE functions and utilities, FTPMurray Feiss International, NY Dec 2001 – Sep 2003AS/400 Project LeaderSupport and modification of Palm PC to AS/400 sales interface used during trade shows. Data was sent via modem to BPCS, automatically processed and goods were shipped to the customer within one day. Creation of customer notification system (CNS) that automatically emails order progress and financials from BPCS to the customers Day-to-day BPCS production support; EDI to BPCS interface support.Environment:BPCS, AS/SET, RPG, ILE functionality, CL, SQL, Palm Sales Organizer, Java based sales interface, EDI interfaceQuality Business Systems, Inc., CT Sep 2000 – Dec 2001TeacherTaught Java related technologies, including Java, JFC/Swing, AWT, JDBC, JNI, Java Applets, Servlets, Java Beans, J2EE, EJB, JSP, Multithreading, RMI, CORBA, XML, HTML, and SQL.Thomson Newspapers, CT Feb 2000 – Sep 2000Software EngineerResponsible for development, testing and deployment of enterprise Internet applications and tools, including Electronic Classifieds, Directory Search, Ad Alert, and EMail System. Environment:Java, HTML, XML, servlets, RMI, EJB, SQL, Oracle 8i, JavaScript, CORBA, JNDI, UNIXJDA Software, CT Feb 1997 – Feb 2000AS/400 Sr. Technical Analyst and Technical ManagerCreated functional and technical specifications for various applications based on the results of business application analysis meetingsParticipated in new application development and an existing programs maintenance using subfile processing (Page-by-Page, Partial, Load-All), Message subfiles, Windows, Menu Bars, Embedded/ Interactive SQL/400, service programs, Triggers, program binding, referential integrity of DB2/400, and AS/400 System APIs.Provided technical support for the development team, ensuring compliance with local programming standards for each corporate client.Environment:JDA MMS, RPG, ILE, CL, SQL, PDT, DB2/400Michael Anthony Jewelers, Inc., NY Jun 1995 – Feb 1997AS/400 Sr. Programmer/AnalystCompleted conversion from legacy system to Billing Planning Control System (BPCS) 5.02 system.Applications included Order Entry, Billing, Inventory Control, Shop Floor Control, AP, AR, and GL.Modified existing code and created new programs for “assetized” programs using AS/SET ADK.Participated in new application development and program maintenance utilizing subfiles, message subfiles, APIs, message handling and other innovative programming techniques.Environment:BPCS, AS/SET, RPG, ILE functions utilizing service programs and procedures, CL, SQLUnited Distillers of North America, CT Jun 1993 – Jun 1995AS/400 Sr. Programmer/AnalystDesigned/coded modifications for BPCS, Order Entry, Inventory, and GL.Assisted in system conversion from BPCS 2.05 to 4.00.Designed automated plant electronic interface between Mapics and BPCS Order Entry/Billing.Environment:BPCS, AS/SET, RPG, CL, SQLEducation & CertificationsLatvia State University, Riga, LatviaB.S., Computer ScienceCertificationsHealth Coach (2018)IBM Certified Specialist (1999)Sun Certified Programmer for Java 2 Platform (2000) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download