Sr. Jd Edwards Technical Consultant Resume
PROFESSIONAL SUMMARY
- 11+ years of IT experience as a software Engineer in analysis, design, coding, testing documentation and customization in various client/server applications.
- Over 6+ years of extensive experience on JD Edwards One World ( Enterprise One 9.0,8.9, 8.10, 8.11, 8.12, Xe, 7.3.3.2) as a Technical Team Developer.
- Expertise in CSMS, Financials/GL, Distribution/Logistics, Manufacturing, Transportation, Real Estate Management, HRMS modules.
- Experience applying ESU’s and SAR’s.
- Involved in implementation and customization of Inventory Management, General Accounting, Job cost Property management, Sales Order Processing, Purchase Order Management, Fixed Assets, Accounts Receivable, Expense Participation, Accounts Payable, Product Data Management, Shop floor control, Forecasting, Shop Floor Control, Bill of Materials (BOM) and Work Orders.
- Strong experience on all One World And XE Tools like OMW, Workbench including Table Design (TDA), Forms Design (FDA), ERW (Enterprise Report Writer),Business View design (BDA), Interactive Application Design, Menu Design, Table Conversions (TC), Data Dictionary (DD), Universal Table Browser (UTB), Processing Option Design Aid (PODA), Data Structure Design, Business Function Design Aid (BDA).Excellent experience using Power forms and subforms.
- Worked on migration of data from legacy databases to JD Edwards One World using Z - file process.
- Used table conversion tools to convert data.
- Experience in writing technical documentation with the information collected from the users.
- Used Microsoft Visio and other Microsoft Office tools in preparing technical documentation.
- Experience in World reporting tools FASTRS, WorldWriters, and DreamWriters.
- Experience in debugging C Business functions, NER Business functions.
- Extensive working knowledge in Object Oriented Analysis, Design, and Programming
- Experience in Web applications and Interoperability.
- Also used the ER Debugger tool extensively in Applications, Reports, Business Functions (NER and C, C++).
- Experience in Oracle 7.x & 8,9i, Visual Basic 6.0, Java,SQL, MS Access, ASP 3.0
- Involved in new challenges exploring the Enterprise Solutions industry with a highly competitive and reputed organization.
- Excellent problem-solving and communication skills and is a team player.
- I can consider myself as an “Achiever” instead of just a “Doer”
Technical skills
Operating Systems: Windows NT/XP/2000, UNIX, OS/400
Languages and Technologies: Java, C, C++, PL/SQL, RPG/400, CL/400, COBOL, Fortran.
ERP: JD Edwards One World - Xe/73.3.2/Enterprise One 8.10, 8.11, 8.12,9.0
JDE One World Tools: OMW, ERW, BSVW, BSFN, NER, RDA, FDA, OL, OCM, UDC, DD, TDA, TC and UTB
Web/Application Servers: JSP, ASP 3.0, Servlets, EJB, HTML, XML
Reporting Tools: Enterprise Report Writer (ERW)/RDA, FASTRS, WorldWriters, DreamWriters, Crystal Reports
Microsoft Tools: MS excel, MS word, MS Visio, MS PowerPoint, MS FrontPage
- GUI: Visual Basic 6.0, Developer 2000, Reports 4.6/3.1.
- RDBMS: Oracle 9i/8i, MS Access 2000, SQL-Server 2000, DB2/400
PROFESSIONAL experience
Client: Confidential, Minneapolis, MN
Duration: Oct ‘08 - Till date
Position: Sr. JD Edwards Technical Consultant: Enterprise One 9.0
Environment: Enterprise One 9.0, ERW (Enterprise Report Writer), SQL Server.
Roles and Responsibilities:
Involved in modifications as well as new design and development of objects. Involved in creating new reports from scratch and modifying the existing reports, and also involved in Creation and modification of interactive applications. Collected requirements from users and prepared specifications. Used ERW (Enterprise Report Writer) tool to develop reports Form design for creating interactive applications.Applied several SAR’s to the programs.
Main Achievements: Modified the Business Function to automate the management fees calculations, which saved tremendous amount of time.
Some of the Objects created or modified:
- Involved in developing Custom UBE’s and Interactive Applications for Expense participation.
1. Operating Expenses - R551532
2. Operating Expense Calculation - R551538
3. Tenant Charge schedule report - R551502B
4. Lease Master Listing report - R5515401
5. FASB 13 Year end report - R551513B
6. EP Billings Register - R1538
7. Account detail by Month – R5515L004B
8. AREF Account association Program – P15L120
9. FASB 13 AR Balance report – R5515406
10.FASB 13 AR Revenue report – R551513C
For all these reports, Custom tables are created and used to hold the object account structures.
- Involved in developing Custom UBE’s and Interactive Applications for Financials/GL
1. Trial balance consolidated – R09410
2. AR Aging Summary report – R5503B413A
3. Accounts receivable reports – R03B reports
4. Consolidated operating statement by MCU – R5509001
5. AR aging summary by Business Unit cat code.
6. Open AR Summary – R03B413A
7. Calendar Operating Statement – R5509001B
- Worked on Copying & modifying Business Function N15L010 AREF Calculate/Load Building Management Fee
- For all the report work files created custom forms/Interactive applications to maintain the table structure.
Client: Confidential,MN
Duration: May ‘08 – Sep ‘08
Position: Lead Technical Consultant: Enterprise One 8.12
Environment: Enterprise One 8.12, ERW (Enterprise Report Writer), DB2/400.
Roles and Responsibilities:
Involved in Upgradation from 8.9 to 8.12..
Involved in EDI development, modifications as well as new design and development of objects.
Main Achievements: Automated the email process to handle all the shipment notifications for sales orders and purchase orders.
Some of the Objects created or modified:
- Involved in developing Custom UBE’s for Item Location Conversions.
- Involved in developing Custom UBE’s for Item Balance Conversion.
- Involved in development of EDI 855.
- Involved in development of EDI 856.
- Involved in development of EDI 850.
- Developed Interactive applications to handle and maintain the EDI transaction tables.
- Involved in creating Contract Letter UBE.
- Involved in Custom maintenance Interactive applications.
- Involved in developing ShipXpress interface
- Auto fax interfaces which includes Shipment notification as well as presourced shipments for both Sales orders as well as Purchase orders.
Client: Confidential, Minneapolis, MN
Duration: Dec ‘07 – Apr ‘08
Position: Lead Technical Consultant: Enterprise One 8.12
Environment: Enterprise One 8.12, ERW (Enterprise Report Writer), SQL Server, Citrix.
Roles and Responsibilities:
Involved in Modifications as well as new design and development of objects.
Involved in managing the team as well as giving training to developers for version 8.12
Main Achievements: Automated the email process for the shipments.Trained developers to handle the project successfully.
Some of the Objects created or modified:
- Worked on update reports to adjust Customer PO number in F4211.
- Modified AR reports – R03B4201A,R03B4201B,R03B1692.
- Created Report R5542950 to update table F4211 based on User input data
- Create Brokerage report on F0911and F4211.
- Added Table triggers for F4211 to insert Bill of lading number.
- Worked on Order Status Report.
- Modified P4915 (Work with Shipments) Application
- Worked on Media objects to modify P4915.
- Modified P4210, P4310 and P4915 to send emails to buyers as well as users when shipment number is changed or Promised delivery date is changed.
- Modified P4915 according to client’s requirements.
- Worked on R49115 Bill of lading report.
- Modified R04570 Create payment groups report.
- Modified P4210 according to client’s requirements. Modified freight handling code according to requirements.
- Created P554211A used to upload data to F4211.
- Modified R5549115 Transportation Bill of lading report.
- Modified R5541003 Pallets label report.
- Worked on Sales invoice and Clean orders reports
- Creating different reports from scratch and modifying the reports.
- Helped and trained client on Financial Reports
- Participated in giving training to users and developers on interfaces and reporting.
Client: Confidential, Houston, TX
Duration: Oct ‘06 – Nov ‘07
Position: Sr. JD Edwards Technical Consultant: Enterprise One 8.10
Environment: Enterprise One 8.11, ERW (Enterprise Report Writer), SQL Server
Roles and Responsibilities:
Involved in Modifications as well as new design and development of objects in this Phase 2 Implementation project. Involved in creating new reports from scratch and modifying the existing reports, and also involved in Creation and modification of applications. Collected requirements from users and prepared specifications.. Involved in working and solving the production issues.
Main Achievements: Developed complex Labor variance report .Created meter reading report giving more flexibility instead of using Interactive application which saved tremendous amount of time.
Some of the Objects created or modified:
- Created Report R5548127 to download the data from F4801 and F1207 and populated CSV files to Users.
- Created Report R5548128. Processed differently from above.
- Created Labor variance report R5504801 to give labor hours, Variance.
- Created Meter reading report R551201L with additional functionality other than Screens provide. Worked on solving the issues in Interactive applications.
- Created BOM work order exception report R55311BOM.
- Created Blocked Invoice evaluation report R554311A.
- Modified general ledger post report to properly post error report R09801E.
- Modified the interactive applications: P12011 to added more functionality to it.
- Created Interactive application P5548122 for Mass upload to F4801 table.
- Modified P4210 to add more functionality to it.
- Modified Work flow system to send the messages to Originators of Work order approvals.
- Worked with different kinds of Time entry reports. Created 6 Time entry reports for Mobile technology.
- Worked on different Supplier reports for Sales order processing.
- Modified the table triggers.
- Worked on different issues on existing reports and interactive applications.
- Involved in Debugging and modification of the Existing Interactive and Batch applications.
Client: Confidential,MN
Duration: Aug ‘05 – Sep ‘06
Position: Sr. JD Edwards Technical Consultant: Enterprise One 8.10
Environment: Enterprise One 8.10, ERW, Windows 2000, Oracle and Citrix.
Roles and Responsibilities:
Involved in Creation and modification of applications for this Phase 2 implementation project. Involved in EDI processes. Converting the data from Flat files to JD Edwards and from Foreign Tables Worked as a team developer in Centralized reporting team Exclusively to develop reports and applications.
Main Achievements: Created EFT to handle transactions with Confidential Bank.
- Created Statements to Banks (EFT notices to Bank) using Table conversion (R5903B2).Generated the report for the same.
- Created Statements to Customers (EFT notices to Customers) Using Table Conversion and created the report for the same (R5503B2).Generated report for the same.
- Modified the Automatic Invoice debit process report according to the client’s requirements based on the EFT process.
- Created Table Conversion for Open Sales Orders and created error reports for the same (R5942OPN).
- Created Table Conversion for Open Direct Ship Sales Orders and created error reports for the same (R5942DSO).
- Created Report to write the non stock lines to the tables F42119 and F42199.
- Worked on solving the issues in Interactive applications.
- Created Table Conversion for Open Transfer Orders and created error reports for the same (R5942OPT).
- Modified the Purchase Orders Edit/Create report R47011 according to the client’s requirements for Sales orders to accommodate direct ships sales orders and Transfer orders.
- Created Sales Order History for Legacy systems from ACE, IMPACT and AGRISOURCE. Created Error Reports for the same (R5942IMP, R5942ACE, R5942AGR).
- Created UBE for the Conversion of “Outstanding Deposit History Conversion” (R594118).Created error report for the same.
- Worked on Production Support after Go-Live of the Project.
- Worked on resolving several issues after Go-Live.
- Involved in Debugging and modification of the Existing Interactive and Batch applications.
- Part of a Centralized Reporting team exclusively to develop vast number of reports for AR, AP, GL, Distribution, Manufacturing modules.
- Specification collections from functional people and customizing interactive and batch applications using One World development tools (FDA, RDA).
- Involved in testing the Table Conversions and Reports in DEV, CRP and PROD environments.
Client: Confidential, Birmingham, AL
Duration: Nov ‘04 – Jul ‘05
Position: Sr. JD Edwards Technical Consultant: Enterprise One 8.10
Environment: Enterprise One 8.10, Windows 2000, Oracle and Citrix.
Roles and Responsibilities:
Worked on Tabular reports. Converting the data from Flat files to JD Edwards. Worked as a functional analyst. Collected requirements from users and prepared specifications.
Main Achievements: Created complex Financial Trend report.
- Analyzed the end user needs and customized applications to meet requirements
- Created Financial Trend Report (R5509031) according to the user specifications with dynamic selection
- Created Labor Analysis Report (R5551542) accordingly, details by Employee & GL date and details by
- Modified Statement of contract condition Report (R55514060), Modified to HA from AA ledger
calculations.
- Modified Project Financial Summary Report (R55514050), modified current month profit and total profit.
- Modified RAAP sheet report (R551001) and created variance reports to get variance for original
Approved and Revised budgets.
- Modified Commitment analysis Report (R5551542) by filtering PO’s with tax commitments.
- Worked on JSI (Job status inquiry) screen (P512000).
- Modified Profitability Report (R552170) added additional functionality for the calculation cost by cost
profit categories.
- Created Job Profit Analysis Report (R5509061).
- Modified Account progress entry screen (P552001) added additional functionality to save column
versions and ability to update ETC and EAC values.
- Modified Job progress entry screen (P552002) added functionality to save column versions.
- Modified Gross profit Quick entry screen (P550312) added functionality for calculations of U1 and U2
ledgers.
- Modified Transaction register (R5505301) sorted by GL date and created summary report.
- Created Time and Pay register (R5505301) Created historical and current information of the
employees.
- Involved in Debugging and modification of the Existing Interactive and Batch applications.
- Specification collections from functional people and customizing interactive and batch applications
using One World development tools (FDA, RDA).
- Involved in testing the reports in DEV, CRP and PROD environments.
Client: Confidential, Milpitas, CA
Duration: Sep ’04 – Oct ’04
Position: JD Edwards Technical Consultant; JD Edwards One World XE, Enterprise One 8.10
Environment: Enterprise One 8.10, ERW (Enterprise Report Writer), Windows 2000, UNIX, and Citrix.
Roles and Responsibilities:
- Worked as a functional analyst.
- Worked with interface between Gulliver to JD Edwards. Created Z-file process.
- Worked with interface between MES to JD Edwards. Created Z-file process.
- Collected requirements from users and created technical specifications for the interfaces.
Client: Confidential, Somerville, NJ
Duration: Aug ’04 - Sept\' 04
Position: JD Edwards Technical Consultant; JD Edwards One World XE, Enterprise One 8.9
Environment: JD Edwards One World XE, Enterprise 8.9, ERW, Windows 2000, Oracle 8i and Citrix.
Roles and Responsibilities:
Involved in creating new reports from scratch and modifying the existing reports, and also involved in Creation and modification of applications. Converting the data from Flat files to JD Edwards. Involved in Testing of the applications. Used ERW (Enterprise Report Writer) tool to develop reports.
- Created Finished Goods Returns Report (R5500012), Detail report is generated based on Invoice and summary by Credit code
- Created Usage and losses Report (R550032) Created summary version based on the GL dates.
- Worked on Data conversion from HCS to JDE using Z-file process. Developed a batch application to pull the data from User defined format and update JDE files.
- Created Work Center Costs Upload (P5530006). Worked on Interactive applications and Batch processes. Developed a batch application(R5530006) to pull the data from Excel and update JDE files
- Created Purchase Materials costs upload (P5530026). Worked on Interactive applications and Batch processes. Developed a batch application(R5530026) to pull the data from Excel and update JDE files
- Created WO variance Report (R5542001).
- Created new set of UDC’s which are used in the Sales Order entry application (P4210), which gives the information of the quantity and package specification of shipment
- Worked with Data Dictionary to create new data items.
- Created Tables and Business views.
- Worked with Menu Design to create Custom Menus.
- Developed and tested interactive applications using FDA, Event Rules, and Business Functions.
- Involved in Debugging and modification of the Existing Interactive and Batch applications.
Client: Confidential, Hickory, NC
Duration: Dec ‘03 - Jul ‘04
Position: JD Edwards Technical Consultant; JD Edwards One World XE
Environment: JD Edwards One World XE, ERP 8.0, ERW, Windows 2000, DB2/400 and Citrix.
Roles and Responsibilities:
Involved in upgrade from One World XE to ERP 8.0. Involved in Migration of World to One world. Involved in modification of business functions. Used ERW (Enterprise Report Writer) tool to develop reports. Worked as a functional analyst. Collected requirements from users and prepared specifications. Worked on AS/400 environment. Worked on Fastr, Worldwriters, Dreamwriters, and on RPG reports.
Main Achievements: Worked on complex conversions from Fastrs,Worldwriters to One world
- Developed Z-file process for the migration of World data from text file to JDE tables.
- Converted the reports from world to One World.
- Developed Work Files to design reports, which shows the mismatches between the Sales Order and Purchase Order files.
- Designed reports with Processing Options, which gives the output with specific Error Messages depending upon the Audit
- Modified Shipping report according to client requirements.
- Developed Customized Address Book (P590102) for Sales Order System with added features where user needs to enter only the minimal data.
- Used the Data Conversion Programs to convert Data from Legacy System to JD Edwards System.
- Created new search screens depending on the Clients Requirements.
- Created DD’s, Tables, Business Views & Processing Options for the above Applications & Reports
- Used the One World Table Conversions tool to convert data from various Legacy systems into One World. These conversions include the following applications: 1) Address Book (Customers and Suppliers) 2) General Ledger.
- Customized the Sales Order Application for “Ship Cancels” and “Removals” and also added the new fields (LOB, EUSE, TRDJ, etc) to the Customer Service Enquiry Application (P594210)
Client: Confidential, Minneapolis, MN
Duration: May’ 03 - Nov ‘03
Position: JD Edwards Technical Consultant; JD Edwards One World XE, ERP 8.0.
Environment: JD Edwards One World XE, ERW (Enterprise Report Writer), Windows 2000, DB2/400 and Citrix.
Roles and Responsibilities:
Involved in creating new reports from scratch and modifying the existing reports, and also involved in Creation and modification of applications
- Created Bill of Materials Obsolete report (R5941A).
- Created Master Routing Report (R593041).
- Created Buyer Activity Report (R5943MRO).
- Created Excess/Obsolescence Inventory Report (R59OBEX).
- Created Pipeline Report (R59PLP0).
- Created Financial Budget report.
- Created the Quote Report (R594353) which gives the details of the Supplier, used Business Function to retrieve the same.
- Created financial reports, which include the Batch wise details, which have the similar prototypes of R09320.
- Created collection strategy program P5503B13.
- Created P5903B13 collection strategy program in Account receivable.
- Designed Custom Reports for the Sales Details by State and Country wise and which are scheduled on a monthly basis.
- Involved in Debugging the Existing Interactive and Batch applications.
- Involved in doing the Table Conversion tasks from world to the One World Tables.
- Developed the Order by the Object report, which gives details based on the sub order.
- Designed Reports to get the data from the GL and shows the analysis in costs and expenses.
- Used the Data Conversion Programs to convert Data from Legacy System to JD Edwards System.
Client: Confidential, INDIA
Duration: Jan ‘01 - Apr ‘03
Position: Oracle Technical Consultant
Environment: Oracle 7.3, Visual Basic 5.0, PL/SQL and Windows NT.
Client: Confidential, INDIA
Duration: Jun ‘99 - Dec ‘00
Position: Technical Developer
Environment: ASP 2.0, ADO, OLE DB Oracle, HTML, IIS, and Windows 95.
Client: Confidential, INDIA
Duration: May ‘98 - Jul ‘99
Position: Technical Developer
Environment: HTML, Applets, JDBC, Java 1.1, SQL Server 4.0 Windows 95.