JDE Consultant
Resume:
Waqas Shakil
Email: *****.******@*******.***, Contact number: 847-***-****
OBJECTIVE: To obtain a challenging position in as a Techno-Functional Consultant/Enterprise Report Writer in JD Edwards Enterprise One software implementation projects.
Summary:
• 7 years IT experience with good knowledge in Software Development Life Cycle (SDLC).
• Over 6 years of Techno-Functional in J.D.Edwards OneWorld Xe, PeopleSoft EnterpriseOne 8.9/10/11 applications on Sales and Distribution (Inventory, Warehouse Management, Procurement and Sales Order Management), Manufacturing (Shop Floor Management, Forecasting, and Work Orders) and Financial (AR, AP, GL, Job Cost, and Fixed Assets) modules.
• Strong on J.D.Edwards tool set (FDA, RDA, TDA, BDA and Debuggers both NER/ C).
• Strong hands on experience on all One World Xe and PeopleSoft EnterpriseOne 8.x tools like Object Management Workbench (OMW), OCM, NER, TC, TER, Menu Design, Data Structure Design, Processing Option Design, Batch Application Design and Interactive Application Design.
• Experienced in designing and debugging C/NER Business Functions, building Interfaces and Electronic Data Interchange (EDIs).
• Knowledge in Sarbanes-Oxley Act and implementing SOX compliant security module.
• Experienced in the Functional aspects of JDE Monthly and Fiscal year Book Closing and Reconciliation Processes.
• Strong hands on experience in performing regular maintenance/ release activities on weekly, monthly or quarterly basis.
• Experienced in situations requiring direct User interaction during Requirement collection, design, development and product implementation phases.
• Strong working knowledge of RDBMS like Oracle 8/9/10g, SQL Server 6.5/7.0 and worked on large and complex databases.
• Excellent Communication and Interpersonal skills with the ability to learn new concepts and applications quickly.
Technical Skills:
ERP: Oracle/ JDE EnterpriseOne 8.11/8.12
J.D.Edwards OneWorld Xe,
OneWorld/E-ONE Tools: Object Management Workbench (OMW), Object Librarian (OL), Configuration Manager (OCM), Report Design (RDA), Table Conversions (TC), Table Event Rules (TER), Menu Design, Data Structure Design, Processing Option Design, Table Design (TDA), Business View Design (BDA), Interactive Application Design (FDA) and Data Dictionary (DD), and Smart Fields.
Reporting Tools: Enterprise Report Writer (ERW)/RDA, JDE BI Publisher
Transformation Tools: SQL Server Integration Services (SSIS) and Data
Transformation Services (DTS)
Operating Systems: Windows NT/2000/ME/XP, Unix, Sun Solaris, OS/400.
Languages: C/C++, VB,C#,VC++ 6.0, Java, SQL, PL/SQL, UNIX Shell,
RPG/400, CL/400.
Web Tools: HTML and OpenGL
Database: Oracle 8i/9i/10g, SQL-Server 6.5/7.0, DB2/400, FoxPro
Professional Experience:
Brightstar, IL
JDE EnterpriseOne Consultant Jun 2008 – Present
Designed and developed various table conversions and reports for handling different EDI transactions sets for different customers. Also responsible for coordinating the test events of EDI interoperability. And created functional and technical specs, custom reports, tables, BI objects, business views, applications and modified standard objects for Financial, Inventory Movement, Sales and Distribution Modules. Some of the projects are listed below:
• EDI 850 Inbound - Standard
• EDI 940 Inbound - E-Commerce
• EDI 850CC Inbound
• EDI 856 Outbound
• EDI 864 Outbound
• EDI 944 Outbound
• Manual Sales Orders upload
• Address Book Conversion
• Customer Master Update
• Sales Order Date and Freight Update
• Modified Release Credit Hold – Standard Report
• Modified EDI Inbound Purchase Order Edit/Create – Standard Report
• Modified PO Unedited Transaction Inbound Processor– Standard Report
• Price Adjustment Upload
• AP/AR Close
• Price Adjustment Details
• AR Subsequent Collections
• Aged AR - Detail & Summary by Credit Manager and Sales Channel
• Inventory Availability Report
• Inventory Movement Report
• Month to Date Shipments, Tracking and Receipts reports
Created Business Functions, Custom Tables, Business Views, and Applications, such as:
• Create Proper String - BSFN
• Extended EDI Table – Table
• Manual Sales Upload Table
• Manual Sales Orders Upload – APPL
• VMI Upload table
• VMI Order Maintenance - APPL
Environment: JD Edwards E812, Oracle 10g, Windows
SunStone Inc (TSIAG Holdings), IL
JDE EnterpriseOne Consultant Feb 2008 – Jun 2008
PART TIME Jun 2008 – SEP 2008
Created mapping documents, designed and developed various custom reports, data conversions, tables, business views, and applications for conversion of Inventory Management, Sales and Financial Module from HFA (legacy system) to JDE Enterprise One. Also created supporting objects such as Error log table, Audit Reports/Applications, Custom Cross Reference table and business functions for data conversion. Following are the list of conversions:
• Address Book Master
• Customer Master
• Item Master/Item Branch
• Item Cost
• Item Cross Reference
• Item Base Price
• BOM Master File
• Item Cycle Count
• Item on Hand
• Supplier Price Catalog
• Ticketing (Custom)
• Silver Matrix (Custom)
Created Business Functions, Custom Tables, Business Views, and Applications, such as:
• Get Cross Reference Info - BSFN
• Write Error Record - BSFN
• Conversion Audit Table – Table
• Conversion Audit – APPL
• Cross Reference Table
Environment: JD Edwards E811, SQL Server 2005, Windows
Service Master, IL
JDE One World Consultant Dec 2006 – Jan 2008
Designed and developed various custom reports, tables, business views, and applications for Financial, Distribution & Inventory Management, HR and Billing Module. Also interacted with users to gather requirements for creating functional specifications. Some of the customs reports and interfaces are listed below:
• A/P & Address Book Interface
• AP & Address Book Interface Header-Detail Integrity Report
• Invoices by Company by GL Date
• Xign Outbound Interface - Payment File
• Xign EDI Inbound Interface - Inv Discount
• eScreen Address File Export Interface
• ePayroll Outbound Interface
• Pre-Employment Exception Report
• Employee Address Listing
• Minimum Wage Exception Report
• Chemical Usage Comparison
• Weekly Summary Table Update Report
• Monthly Billing report
• Sarah Title III Report
• Billing Summary Report
• Assessment Exception Report
• Modified Invoices and Purchase Orders in Optio Design Center
Created Business Functions, Custom Tables, Business Views, and Applications, such as:
• Get Weekend Dates – BSFN
• Item Weekly Summary table – TBLE
• Weekend Dates – TBLE
• Maintain Weekend Date – APPL
Environment: JD Edwards One World Xe, SQL Server 2000, Windows
Inland Real Estate Group of Companies, IL
JDE Enterprise One Consultant AUG 2006 – DEC 2006
PART TIME DEC 2006 – SEP 2007
Designed and developed various custom reports, tables, business views, and applications for Financial and Property management Module. Also interacted with users to gather requirements for creating functional specifications. Some of the customs reports are listed below:
• Modified standard Generate Positive Pay Text File
• Tenant Insurance Non-Compliance Interface Report
• G/L Account Balance with and without Sub-ledger
• Trial Balance by Business Unit, Company with and without Sub-ledger
• A/P Accruals Report
• Consolidated Trial Balance
• Income Statement with Debt Covenant Certificate by Business Unit and Company
• Consolidated Income Statement with Debt Covenant Certificate
• Comparative Balance Sheet by Business Unit, Company
• Consolidated Comparative Balance Sheet
• Quarterly Comparative Income Statement by Business Unit, Company
• Consolidated Quarterly Comparative Income Statement
• Modified Custom CAM Report
Created Custom Tables and Applications, such as:
• Created a custom table, business view and maintenance program for Debt Covenant Constants
• Created a custom table, business view and maintenance program for Signature used by Debt Covenant Certificate
• Created a custom table, business view and maintenance program for Positive Pay Y/N Flag
• Created Custom UDC application to allow certain UDCs to be maintainable by the users (shared UDCs are not allowed to delete by user), while other UDCs to be maintainable only by IT Department
Environment: JD Edwards E811, SQL Server 2005, Windows
Woodhead Industries, IL October 2005 – Aug 2006
JD Edwards Enterprise One Consultant
Worked intensively in the areas of Finance, Distribution & Inventory such as creating and maintaining the Interface of JDE with various other sources like Web/Unica/ECI400. Task mainly involved coding of the interface, retrofitting, making the mapping documents, changing them according clients changing specifications, running the table conversions to make sure all the tables are getting updated according to the JDE standards.
Created many Reports using ERW like -
• Commission Report: Summary and Detail
• A/R Aging/Scorecard
• Income Statements Financial Reports
• Spending Accounts Financial Reports
• Sales and Cost Income Detail Report by Item Number and Address
• Sales Analysis Summary By State Report
• Sales and Income Detail Report Customer Hierarchy
• Freight Charges Interface Inbound Application
• Sales and Income Detail by Product Hierarchy
• Summary Of On Hand Quantity by GL Class Code
• Monthly Purchase Price Variance Detail Report
• Work Orders With No Standard Cost
• Expected Vs Actual P.O. Price (Difference)
• Item Ledger File Without Balance Forward
Environment: JD Edwards One World/E811, DB2/400, Windows
Craig Industries, IL Dec 2004 – Sep 2005
JD Edwards One World Technical Consultant
Craig Industries has long been recognized as the leader in the Electrical manufacturing industry. Its manufacturing unit is located at Mexico and corporate office in Illinois. Customized manufacturing-scheduling workbench (P31225) for generating child WO using parent work order (rate work order) by checking Parts list for material status. Created report to print shop paper work for rate work order.
Responsibilities:
• Created the custom table F5648011 (Work table) to store WO number while calling UBE to avoid the prompt
• Created the custom interactive application P5631225 (Child WO Parts list Processing)
• Created the Custom Batch applications R5648011 and R5631415 print shop paper work for rate WO
• Created Detail Income Statements by Company and Business Unit.
• Created Consolidated Income Statement
• Created Balance Sheets
• Created Trending Reports
• Created Sales Analysis Report
• Used Event Rule Debugger and VC++ Debugger at Unit Testing level, to debug JDE source code and Business Functions, respectively. Worked with various Business and System Functions
• Imparted training about JDE technical to the employees
• Interacted with users while testing process
Environment: JD Edwards One World, DB2, Windows
Creamland Diaries, IL Jul 2003 - Oct 2004
Technical Consultant
• Created Financial Reports such as customized Income Statement, Balance Sheets
• Worked on Data Conversions of Historical Lots from Legacy(BPCS) to JDE
• Modified Forms for the Parts list Application for Custom Validation Rules
• Created the Lot number schema Batch Application which automatically generates the Lot number and assigns them
• ACH Process: Modified the vanilla process to accommodate the ACH process for CCD and PPD formats for Vendors
• Worked on creating the Item return policy for the client using Custom Applications and UBEs
• Created Return Merchandise Enhancement (RMA) for the validation for Returned Items for Expired Lots
• Worked on Sales Order Download program to download the data from WMS, which validates DEA#, Certificate of Analysis and single lot customer
• Working on Post-Live issues for the client pertaining to Sales Order, Inventory Management, AP, AR, GL, Job Cost and Manufacturing
• Monitoring Nightly Jobs
• Created Interface between Hyperion and JDE for Backorder Updates and Cost Of Good Sold
• Worked on Production Support to fix UBEs and create new Reports
Pakistan State Oil Company, Pakistan May 2001- Jun 2003
JDEdwards One World Xe Technical Consultant
Financials, Distribution on AS/400 and Unix
• Extensively involved in the migration and Full Life Cycle Implementation from the Legacy AS/400 system to JDEdwards One World Xe
• Developed Table Conversions to transfer data from the Legacy system
• Interfaced with legacy Manufacturing systems to transfer the Bill Of Material and Work Orders
• Customized Invoice Print (both Sales Order and A/R) to meet the requirement
• Customized Address Book application P01012 to accommodate more fields
• Modified the A/R Summary report (R03B413A) to add new 121-150 days aging bucket
• Developed A/R Check Detail report, which gives the details on how checks distributed on invoices by Customer
• Worked on Table event rules (TER) for the JDE standard tables and custom tables
• Experienced in using Z-Files and Z-processors for various processes like Chart of Accounts, Business unit, etc
• Merged the customized code using the Visual ER Compare tool
• Customized the BOM and Routings: P30200, P30201, R30410, R30415, and R30430
• Coordinated the testing efforts with the development team
Finex Securities, Karachi, Pakistan May 2000 - April 2001
Renowned financial brokerage firm with diversified portfolio
• Studied the functional aspects of information systems: Karachi Automated Trading System (KATS), and Investors Information System (IIS).
• Karachi Automated Trading System (KATS) is used for trading stocks by the brokerage houses on behalf of their clients. This system is used for transactions such as spot, 3 day settlement (T+3), futures, and continuous funding system (CFS) for leverage clients.
• Investors Information System (IIS) generates reports for clients such as client trading confirmation receipts, account summary and monthly trading activities.
ORIX Investment Bank, Karachi, Pakistan Jan 2000 - Apr 2000
Leading multinational financial institution with broad-based products
Market research and development
• Developed a system-assisted morning briefer for the brokerage division and clients. First part of the report provides analysis of financial news, briefing of the prior trading day activity, and daily forecast. Second part of the report, would provide auto updated financial data both in tabular and graphical format showing key indicators from different financial markets such as Equity, Foreign Exchange, and Money Markets were shown along with their yield curves.
• Source application database was in Fox Pro. Tables and graphs designed and developed in MS Excel. Reports were generated in MS Word.
NIB Bank, Karachi, Pakistan May 1999 - Dec 1999
Rapidly growing multinational commercial bank
Corporate Finance Research Analyst (Summer Intern)
• Compiled a report to provide an overview of Pakistan’s Knitwear industry. Presented trend analysis of Knitwear exports in pre and post WTO era. This report also identified key success factors of the industry.
********************************
Contact this candidate