EXPERIENCE SUMMARY

• Over 14 years of IT Experience in Analysis, Design, Coding, Testing, Debugging and supporting business applications in JD Edwards One World/ Enterprise one and AS/400. This includes 13 Years of US experience and 8 months of Singapore experience.
• 10 years of JD Edwards One World/ Enterprise One (E9.1, E8.12, XE, B73.3.2) technically skilled in using One world toolset Enterprise Report Writer (ERW), Form Design Aid, Table Conversion, Event Rule Debugger. Also Confidential on setting the setups for AP, GL, AR, and Sales Modules.
• 4 years of AS/400 experience in Creation and Modification of Rpg/400, Cl/400, Ile/400, S/38, Cobol/400, SQL/400, db2/400, Bpcs (Financial and Manufacturing), JD Edwards World Software (A 7.3) and Mapics. 3 years of Crystal reports on release 11 and 12 while parallel working with JDE
• Experienced in Finance, Distribution, Manufacturing, and H/R modules both technically and functionally, also have the skills of working on CNC Administration up to 50%.
• Experienced in prioritizing Issues to ensure goals laid out for the project were considered and completed.
• Fully involved in project requirements, integration, and process review meetings.
• Excellent Communication skills, Self - driven individual who works with Honesty, Respect, Positive Attitude, Efficiency and Teamwork. Desire to learn and grow.

TECHNICAL SKILLS

Operating Systems: Windows NT/98/2000, XP OS/400 and UNIX.

ERP: JD Edwards - One World (ERP9.1, 8.12,Xe and B7.3)

One World Tools: OMW,TDA, FDA, RDA, DSTR, BSFN, BSVW

Databases: Oracle 9I, DB2/400,SQL Server 2000

Languages: Rpg/400, Cl/400, Ile/400,S/36, C++, Java

AS/400 ERP: Bpcs, Mapics, and JD Edwards’s world.

Microsoft office: MS Project, Excel, Power point

Knowledge: Crystal reports (Business objects), BSSV,PL/SQL, Power forms, Java (Web sphere 3.5/4.0,Visualage 3.5), Java Script, Html, Jsp, Servlets, Xml, Uml.

PROFESSIONAL EXPERIENCE

Confidential

JDE Development

Responsibilities:

• Fixed the AR Batch errors and invoice batch errors to complete the GL Update. Created new Monthly reports using RDA.
• Generating monthly reports for hold and unprocessed orders also generate reports for unapplied receipts and amounts asking accounting to fix errors.
• Starting and stopping scheduler jobs and run the DPO Order process to run manually the missing data to ordered users. Confidential on Bill of Material for county to community relationship.
• Involved on Monthly FMSIS Process for sending orders from JDE to MS Access database. Used SQL Command extensively to fix the data issues.
• Confidential on media forms for burning CDS to mayors and customer for hazards flood insurance.
• Creating user ids for new users, Resetting passwords for disabled users.
• Watch order flows into JDE, Fixing data integrities so no publishing errors to store.
• Sending monthly reports about DPO and Eddie downloads to my manager.
• Starting and stopping JDE Development and productions servers for weekly patches and validating the system after it brought back.
• Confidential on trouble shooting Un processed orders from MSC Web store to JDE, because of errors in orders and breakdown of store or JDE System with unexpected interruption on servers.
• Enter the missing receipts to JDE AR system and check if any errors of receiving from pay system.
• Confidential on MSC Re-architecture for data mapping of JDE to new store by running SQL Queries on different JDE tables and bring the data out to load into the new system.
• Run health checks on the websites and inform to designated people to fix the errors on different websites maintained by risk map cds group.

Environment: JD Edwards Enterprise one (E9.1), Oracle 11, Windows 7, FEMA MSC Web store.

Confidential

Upgrade Analyst

Responsibilities:

• Created Table conversions to extract data from three legacy systems into either Z-tables or custom staging tables and uploading the data into master tables based on Global cross reference.
• Confidential on Transportation interface for uploading Routes of CROWN data from F4950,F49501,F4970,F4971,F4972,F4973 tables.
• Modifying Invoice report not to print header summary tax info of different tax groups, also changed descriptions of summary taxes and calculation of Unit price of cases and bottles.
• Confidential on Work orders in Manufacturing module.
• Created users batch upload program to load 2000 users into F0092, F00921, F00925 tables, Also their Roles into F95921.
• Confidential on EDI 852 Outbound process to create data into Edi tables.
• Used MD Debug to watch the values of NER Business functions.
• Troubleshooting problems and set up issues. Provided training to Users of using Finance application in AP and GL Modules. Confidential on Excel to create formulas and pivot tables to summarize data.
• Confidential on 3 way match reports for PTM Department.
• Creating the state reports which are submitted by Confidential every month to the states about the sales of liquor in the states.
• Confidential on Advance pricing Loading of Order groups, Item groups and Customer groups.
• Participated in all phases of the project life cycle, including post-production support and ongoing maintenance; continuously gains an understanding of the customers' operations and how systems are used in support of their operations, transferring knowledge to users and technical members of the team.

Environment: JD Edwards Enterprise one (E9.0, E 8.10, XE and World), Oracle, DB2/400, Windows 7.

Confidential

Database administrator

Responsibilities:

• Created custom ACH payments formats for Vendors and employees according to Bank of America requirements. Confidential with Positive pay process to change the formats.
• Customizing print automatic payments program for check writing.
• Written sun update batch process to update F0911Z1 and F0911 tables.
• Fixing the issues of missing new hires for HR system.
• Payroll is switching to a National ADP account as a result; our KWZ company code is changing to GWK. Tested it in development and updated Production.
• Uploaded salary increments for employees.
• Created Applications to load data into Cross-reference tables of Business units and Address no to validate the conversions process.
• Creating Custom menus for finance from standard menus.
• Developed New Middle ware Interfaces to read the data from tables and Convert the address no, Business units and company number based on Cross reference.
• Written SQL’S to dump data from Environment 8.9 to 8.12 into Middle ware tables of Inventory Master, Branch plant, Item Location and Supplier item relationship, AP Ledger.
• Creating new crystal financial reports (Business objects) based upon the JDE World reports and faster reports.
• Trial balance reports, Grants reports, Balance sheets, Yearend reports, month end reports with crystal reports.
• Confidential with Oracle for Application recovery program for System failures and sign outs of not losing user entered data.
• Added environments for roles, created roles and user ids for upgrading system.
• Created user profiles on both AS/400 and E1 and assigned roles to them. Confidential on of full backup of system to tapes. Moved every day backup tapes to data centers.
• Install the ISERIES as400 copies. Giving access to DV, PY, and PD for new Users.
• Fixing Login issues to E1, Stopping and restarting Web servers when in need. Creating packages and deploy them to PY Environment. Also Confidential with Server manager.
• Setting up the Scheduler jobs and tracking the jobs ran on daily basis for auditing purposes.

Environment: JD Edwards Enterprise one (E9.0 and XE), Crystal reports (11 and 12), I series, DB2/400, Windows XP.

Aggregate Industrie

Technical Team lead

Responsibilities:

• Created and Modified Financial Statements by GL Accounts.
• Developed Job cost Reports Month to date, Year to date using smart fields. Also Confidential through job cost process to set some test data to test the reports. Aggregate industries uses job costing module for contracting of roads, pavements and supplying building materials.
• Trouble shooting the errors in Payroll, HR, AR, AP, GL, Sales order and Purchase Order, Help tickets entered by Users. Fixing up setup issues, data issues changes on UDC’s and category codes.
• Confidential on fixing Functional issues of AR Month end closing for UN posted Batches, Companies out of balance and integrity issues of AR and GL System.
• Leads and communicates plans and issues to management and staff on regular basis as related to critical areas.
• Establish and maintain project status reports and communicate to senior management.
• Responsible for supporting over 200 users on the JD Edwards system including the design of a comprehensive Security Framework and maintenance of all system security, menus, users/roles and developing and performing all user training
• Gather requirements from users, create specifications, and develop code.
• Mapped the tax information to print properly on 1099 forms for Account payables.
• Confidential on AS/400 World writer reports, Ability to use SQL for advanced database queries and updates.
• Customizing the NER Business functions up on changes in applications.
• Generating pay rise reports from payroll table and also Confidential New hires and rehires reports. Created AP Check reconciliation process to store the transactions received from banks into JDE System.
• Created a financial report for budget vs. actual.
• Confidential with Oracle BI Publisher to create templates and definitions to load data from XML into designed tables. Confidential with Power forms to design multiple apps run on a single page.
• Confidential on Modification of stand Employees enrollment Screens on HR.
• Changed the "Monthly CWIP Summary Report” set up to run in the FIN queue. Used Power forms to validate the input field entered by Users.

Environment: JD Edwards’s one world (8.12)/JD Edwards Enterprise one, Windows 2000, SQL Server 2000.

Confidential

Technical lead Programmer

Responsibilities:

• Created Month to date Sales status Report which provides information by Branch Summary, by Consolidation code, by major and minor SBU.
• Modified EDI Edit/create Customer order report to Create Sales order in Sales Master tables, to support Orders received from 30 different customer into EDI trusted links.
• Created Serial no for the orders and generates them on PDF for printing labels in different format through Optio.
• Modified Batch programs of Advance shipment notice (856), Creating invoices to customers.
• Modified Bill of lading program to support US, Canada plants of Foamex.
• Confidential on Open A/R reports, netting reports. Used the tools set TDA, FDA, RDA, DSTR, BSFN, BSVW, DD, OMW extensively.
• Confidential on HR/Payroll module for Payroll cycle generation and benefits enrolment process for the employees.
• Generated reports using columnar, group, tabular reports using ERW Coding event rules. Used Event rule Debugger &VC++ Debugger Debugging tools for Unit testing.

Environment: JD Edwards One World (8.10), Windows 2K, EDI, and DB2/400.

Confidential

Technical Programmer

Responsibilities:

• Confidential on H/R -Supervisory checklist by creating forms, Generating reports that are eligible for 401k, benefits administration, and pay role reconciliation.
• Confidential with EDI trusted links from EDI to JD Edwards and created trading partner.
• Created a UBE (ERW) to Generate Price conflict Report by comparing EDI and JD Edwards line items and Produce a price conflict Report.
• Customizing Forms & Reports in Financial module. A/P - Automatic accounting information, Supplier information, voucher processing. A/R -A/R Reports, Invoice processing, Customer information. G/L - Standard Journal Entry, Bank Entry, Cash Entry Screens. Journal Entry Screens Are Modified for Bank Entry and Cash Entry.
• In Distribution Confidential on Sales order management - Pricing, invoices, Sales order entry. Inventory - Item entry, Inventory transaction, cost updates and Confidential in Plant maintenance.
• Confidential in advance pricing for Improving profitability and competitiveness through more accurate pricing by market sectors and product characteristics.
• Used Table Conversion Utility to create a Program to Interface Unit of Measure Conversion Table from AS/400 into JDE table and writing exceptions and control reports.
• Data Conversion (Interpretability files”) from Unify Based System to JD E One World Tables on SQL Server using Table Conversion Utility.

Environment: JD Edwards One World (B7333), EDI, MQ Series, Win 2K and DB2/400.

Technical Programmer

Confidential

Responsibilities:

• Writing different Screens & Reports in Sales Order management (order to cash), Sales History Inquiry, Modification of Purchase Requisition Entry, Change Pick Slip Printing Program and Purchase Order Report Confidential in HR/Payroll module for modifying payroll history and integrating, pay deductions, benefits. Payroll activities, Human resource activities.
• Created Business Functions, Tables, Data Structures, and Named Event Rules.
• Writing Specification for different Supplier Management, Business Process, Flexible Tax structure and Payment Processing Management.
• Created User-defined rules for stock movement in Warehouse module.
• Customizing Mapics programs and creating new applications development to enhance Mapics using RPG.
• Modules involved included Inventory Worded in Accounts Payable, General Ledger, COM, Production Control & Costing, and MRP.
• Work with operations group to develop new procedures to increase efficiency by utilizing the available technology.

Environment: RPG/400, ILE/400, CL/400, MAPICS (DB/XA) and Implementer