TECHNICAL SKILLS:

Hardware: AS/400

Software: JD Edwards World Development Standards: Data Dictionary, Vocubulary Overrides, Dream Writer, FASTR, Server Programs

Operating System: iOS, OS/400, Microsoft Windows 10

Database: AS/400 RDBMS, SQL Server 2012

Languages: C#, ASP.Net, Objective - C, Swift, C++, VBA, PhP

PROFESSIONAL EXPERIENCE:

Confidential, Newburgh, NY

Senior Programmer/Analyst

Responsibilities:

• Case Management, production support, ad hoc RPG code changes
• CallTracking, production support, VBA system
• Letters System, production support, C++ code analysis and code changes
• C#, Visual Studio 2017, Entity Framework, ASP.Net,RESTful Web Services
• Objective-C, Swift, Certified Professional Xamarin Developer

Confidential, Parsippany, NJ

Senior Programmer/Analyst

Responsibilities:

• Worked on SalesRep Commissions system.
• Data conversion of legacy system to Mastermind System (order entry), sales rep commissions processing.
• Data conversion/integration with JD Edwards’s financial modules.
• Responsible with mapping data into JD Edwards for GL data interface.

Confidential, Highland Mils, NY

Senior Technical Resource

Responsibilities:

• Web-based development project, internal marketing processes.
• Designed and developed internal web-based processes for marketing and invoicing using .NET Technologies (ASP.NET, C#, SQL Server 2005, 2010) in Visual Studio development platform.

Confidential, Parsippany, NJ

JD Edwards Data Archiving

Responsibilities:

• Developed programs to extract selected company codes JD Edwards data using RPG, AS/400.
• Lead technical lead on planning/implementation of data extract process.
• Developed programs to extract/reformat JDE World Data into SQL Server data formats, utilizing JDE methodologies such as Data Dictionary, Dream Writer and Server Programs.
• Technical Lead on JDE Edwards Data Extraction Project and ASP.NET Reports and Inquiry.
• Responsible for design, development, testing and execution of the whole project.
• Designed web based JDE Reports and Inquiries for:
• General Ledger:
• Income Statement
• Account Ledger Inquiry
• Balance Sheet
• Account Balance by Month
• Tax Reports (Trial Balance Format)
• Accounts Payable/Purchasing:
• Vendor Ledger Inquiry
• Vendor Payment Inquiry
• Vendor Master Information
• Fixed Assets:
• Item Master Information
• Project (Capital Projects) Master Information
• Capital Projects and Assets
• Created detailed technical design for developers to convert JDE Reports into SQL Server/ASP.NET platform.
• Perform revisions and enhancements on VB.NET code-behind programs.

Confidential, Melville, NY

Advanced Pricing

Responsibilities:

• Provided development/testing to the development team.
• Responsible for coding and testing.
• Specifications provided by the design team. JDE Standards are used such as Dream Writer, Data Dictionary, Vocabulary Overrides, and JDE Server programs.
• Provided input and assistance during the design phase of Advanced Pricing related projects.
• Provided development/testing for post-production enhancements and fix programs for the Advanced Pricing team.
• Created/executed SQL scripts to retrieve information from Sales Order application.
• Provided Post-Live production support for Order Management module, verifying system Integration Data and other production related issues. Day-to-Day data validation and remediation processes written RPG 400.
• Wrote Interface Programs to upload/download JD Edwards OneWorld Inventory Item(s), Pricing and Cost Information from/to Excel spreadsheets.
• Wrote conversion programs to convert AS/400 legacy Purchase Order, Sales Order, Inventory Item Master/Item Balance/Customer Master/Vendor Master Application data into OneWorld system.
• Unit tested, modular tested and ensured that converted data are valid within JDE Oneworld applications interfaced with Distribution Modules.
• Implemented EDI Outbound Invoice (810) module, Wrote/Designed XML/EDI Invoice Processing.
• Generated the following EDI Invoice Files (on JD Edwards System):
• F47046 Invoice HEader
• F470461 Additional Header
• F47047 Invoice Detail
• F470471 Additional Detail
• F4706 Order Address Information
• Wrote RPG program to map EDI Outbound Invoice File to consolidate the Information into Header/Detail XML Invoice Documents and wrote C#/XML programs to retrieve and send document to recipients.
• XML/EDI Sales Order Processing - receive XML PO and map them to JDE EDI Inbound Customer Orders (850) to the following JDE Incoming PO files:
• F47011-(Customer PO Detail Files) turns to F4201
• F47012 (Customer PO Detail File) turns to F4211
• F4706 (Customer PO Address File) turns to F4006
• Created programs to map EDI files into JDE Sales Order Batch Order processing file and generate Sales Order.
• Implemented JD Edwards PO Acknowledgement (855) that creates the following JDE EDI Files:
• F47026 - Order Acknowledgement Header
• F47027 - Order Acknowledgement Detail
• F4706 - Order Address Information
• Wrote programs that consolidate the above files content and create an XML Document that is send to a business partner.
• Hands-On experience converting Access Data into AS/400 Database using C#, ADO.NET, ASP.NET and XML (.Net Platform) technologies.
• Real-Time E-Commerce/JD Edwards Backend Integrated SALES ORDER.
• Provided JD Edwards functional and technical expertise for the web development team that’s working on a JD Edwards Online Sales Order Processing.
• Developed server-side programs that provides data for Sales Orders submitted via the internet. G
• Generated data to be passed over the web-front end and receive and processes data from web customers to JDE Edwards Sales Order module.

Confidential, Danbury, CT

Responsibilities:

• PO Approval setup.
• Setup the Procurement Management PO Approval Routing and Setup, Vendor Owned Inventory process development and testing.
• Daily production support on Distribution modules issues such as validate In-Transfer Qty accuracy, Cycle count Item classification and other related issues that arises on daily operation.
• Program revisions for Vertex Sales Tax software interfacing with JD Edwards’s system. Tax Code setup and custom programs to include automated Tax Calculation using Vertex.
• AS/400 Platform, using RPG/400, SQL/400.
• Hands-On of OneWorld Developer Immersion.
• JD Edwards OneWorld Xe Purchase Order enhancements, using OneWorld Development Tools through Object Management Workbench for Table Design, Forms Design, Report Design, Event Rules programming for Interactive and Batch Processing programs. Report Writing tools used to revise and enhance existing reports and batch programs as well as create new ones.

Confidential, Danbury, CT

Responsibilities:

• JD Edwards World, AS/400 Platform, using RPG ILE, SQL/400.
• Data gathering, analysis, designed and developed end-to-end including unit testing, system testing an Inventory reconciliation process and reporting system.
• Purchase Order Approval Route Implementation Implemented Purchase Order module’s PO Approval and Routing features.
• Development and implementation of an interface to create auto-generated journal entries from a subsidiaries, mapping and generation of F0911Z1 batch interface records.

Confidential, Wilmington, DE

Responsibilities:

• JD Edwards Accounts Receivable data extraction and map to a flat file to be sent via FTP into SAP sytem.

Confidential, New York, NY

Responsibilities:

• Worked on a legacy system-JD Edwards WorldSoftware interface and Automated Cash Application.
• Designed/coded and implemented module that pulls data from legacy system to create F0311Z1/F0411Z1 and corresponding F0911Z1 records. Automate the A/P Payments to create A/R Cash Receipts (F0312) as well, and enable the users to use the Automated Cash Application program do eliminate manual entries and data entry errors.

Confidential, Oakland, NJ

Responsibilities:

• MAPICS-OneWorld Conversion/Interface Financials:
• Customer Master Conversion: Wrote program to map/convert MAPICS.
• Customer Master file into JDE OneWorld Address Book ‘Z’ files. (F0101Z2, F0301Z1) and run ‘Address Book Batch Upload’ to load Z- F0101Z2 data into (F0101,F0111, F0115, F0116…) file(s); afterwards run a custom program to populate F0301Z1 with the JDE generated Address Number (AN8) and then run ‘Customer Master Batch Upload’ to process F0301Z2 data into F0301, F03012 and F0150 file(s).
• After the above process, verify that all mapping values are correct and reflect the proper setup such Payment Terms, Search Type and other related information that affects the processing of Accounts Receivable transactions.
• Vendor Master Conversion: Wrote program to map/convert MAPICS.
• Vendor Master file into JDE OneWorld Address Book ‘Z’ files. (F0101Z2, F0401Z1) and run ‘Address Book Batch Upload’ to load Z- F0101Z2 data into (F0101,F0111, F0115, F0116…) file(s); afterwards run a custom program to populate F0401Z1 with the JDE generated Address Number (AN8) and then run ‘Supplier Master Batch Upload’ to process F0401Z1 data into F0401.
• Verified that important field values such as Search type, Payment Terms, Tax Id and other vendor setup related information that affects the processing of Vouchers and other Accounts Payable processing.
• Open Payables Conversion: Wrote program(s) to map/convert MAPICS.
• Open Accounts data into F0411Z1/F0911Z1 then run ‘Batch Voucher Processing’ to process them into F0411 and F0911; post the voucher batches that were created, verify/reconcile by creating reconciliation spreadsheets to prove that the Open Payables for both MAPICS System and OneWorld are reconciled.
• GL - Journal Entry Conversion/Interface: Wrote program(s) to convert MAPICS General Ledger data for two years; validate and converted them into F0911Z1; processed it into F0911, created reconciliation spreadsheet to verify that current MAPICS balances and converted OneWorld GL balance are the same.
• An Interface program/process was develop to capture MAPICS distribution transactions into OneWorld G/L on a daily basis, it also utilizes the F0911Z1 and Batch Journal Entry processing to load into F0911 and post into F0902.
• Open Accounts Receivables Conversion/Interface: The most difficult among the Financial Modules to implement, Wrote program(s) to convert/map Open Accounts Receivables from MAPICS into F03B11Z1 (for Invoices, Adjustments, Credit Memos, Finance Charges), process them into F03B11 file, afterwards, load MAPICS payment data into F03B13Z1,process them into F03B13 and F03B14, run the Automated Payments.
• Processing to apply them again generated F03B11 data; create a reconciliation spreadsheets that shows total records count, total amounts and customer/invoice level Open Amount is the same between OneWorld and MAPICS. Interface is run utilizing RUNUBE command from AS/400 JDE library.
• Accounts Receivable History:
• Accounts Payable History:
• Applying the same approach used in converting Open Accounts Receivable and Accounts Payable program(s) were also created to converted 2 years’ worth of A/R and A/P history.
• Wrote RPG/ILE data-mapping program that maps MAPICS data to corresponding JD Edwards OneWorld Interoperability Iterface Tables. Client needs MAPICS-JDE.
• Financial modules interface, once they go live, so that MAPICS-distribution generated accounting related transactions will be reflected into the OneWorld system.
• Copy over MAPICS-to-JD Edwards Chart of Accounts Cross . Using Excel/Access to AS/400 RDBMS format.
• Converted MAPICS Open A/R, Open A/P and GL Systems, generate reconciliation report(s) between MAPICS data and JDE converted data.
• Process Automatic Payment (Cash Application) into JDE Open A/R.
• Converted/Processed A/R History into JDE A/R Customer Ledger/Payments file(s). Convert/Process A/P MAPICS History file into JDE A/P Vendors Ledger and Payments file(s) provided post-live support to the financial modules.

Confidential, Danbury, CT

Programmer/Analyst

Responsibilities:

• Online Registration system, wrote server-side programs (RPG ILE) that provides the information to the e-business components and into the client (web user).
• Run FTP procedure to move compiled programs to customers AS/400.
• Wrote SQL/400 test scripts, to generate the right data to test the web site.
• Designed and implemented the credit processing module of the online registration system.