Experience Summary:
Over ** years of JD Edwards (E1) experience in various industries with implementation, enhancement and production support as Programmer Analyst with strong functional knowledge in Financial, Sales & Procurement modules and worked with JDE OMW Toolsets UBEs, Business Functions, NERS, RDA, FDA extensively. Experienced in Leading projects/team from requirements gathering through implementation and support including helping business users in process changes for their effective & faster operation. Also, worked and maintained JDE security as security Administer and extensive experience in P/L SQL in analyzing & resolving JDE Production Issues and working closely with Business users.
Technical Skills:
ERP System (Tools) : JD Edwards EnterpriseOne (XE/8.10/9.2), PeopleSoft Enterprise (8.9)
Languages : C, C++, SQR
RDBMS : SQL Server, Oracle
Others : PL/SQL, Unix Shell Script
Technical Certifications:
JD Edwards Oneworld XE (Tool set) : JD Edwards APEC Partner, India
PeopleSoft Integration Tools : Oracle University, NJ, USA
People Tools I & II : Oracle University, NJ, USA
WebMethods Enterprise 4.5 : WebMethods
Education :
Bachelors Degree in Engineering, University of Madras, India
Contact Details:
Phone: 732-***-**** (C)
Email: ac4m9i@r.postjobfree.com
Work Profile
Client : CBRE Group
Location : Dallas, TX
Title : SME (Contractor)
Duration : Jun 17 – Till Date
Overview:
As a consultant supporting client (CBRE) on their project to bring different systems (JDE, Oracle EBS, iScala, SalesForce, Lease Admin, Project Management System) data into their unified Enterprise Data Platform in order to be utilized in Business Analytics System Tableau Dashboard.
As functional Analyst worked on analyzing Business Analytical requirement on Financial Dashboard and helping Data Architects on Data Model design. Worked on analyzing JD Edwards Source System to the Unified Enterprise Platform and worked with Data Engineers on mapping the same into EDP database tables
Similarly worked on analyzing Oracle EBS and iScala for financial EDP Requirement and also worked on Sales Force system for Lease transactional analytical requirement. Worked on creating test scripts to validate Enterprise Data Platform and compare against Source System data.
Roles & Responsibilities:
Analyzing Business Analytics Requirement from the business
Working with Data Architects on Data Model design
Source System analysis (Data profiling) in order to map against target Enterprise Data Platform
Functional validation against Source to Target Data Mapping
Test Script creation and execution on Functional aspects
Skills:
ERP System : JD Edwards, Oracle EBS, iScala, Sales Force (TM), Kahua Project Management
System, Lease Admin System (Seqentra/HarborFlex)
Functional : Finance, Lease Transaction, Project Management
Company : Casper Sleep Inc
Location : NY, US
Title : JDE SME (Techno-Functional)
Duration (Full Time): Jul 16 – Jun 17
(Contract) : Jun 17 – Till Date
Overview:
As Techno-Functional Analyst worked in JDE Enterprise One 9.2 implementation and post go-live support. As a Lead from Client side worked with 3rd party implementation team on defining the requirement, business requirement analysis, user testing and development (interfaces, reports & applications).
Worked as Techno-Functional SME on the design and development of interfaces, applications, reports and JDE System configurations.
Worked on implementation of Supply Chain Management (Procurement, Sales, Inventory), Finance modules
As JDE Security Administrator worked in setup and maintaining JDE Security before and after go-live
Designed and Developed interfaces to send multiple types of payment to bank in various countries (as we operate in multiple country/Currency)
Designed and developed interfaces to bring Customer Ledger receivables and Credit Card Settlement Feed into Receipts.
Production Support:
Worked on resolving issues and supporting business on Supply Chain Management and Finance (AR, AP & GL) modules and that includes resolving any data related issues.
Worked in defining and fixing JDE Security
Helping user in Financial month closing process.
Roles & Responsibilities:
Requirement Gathering from the business users on their new requirement
Analyzing the user requirement and proposing solutions on changing business process and code changes on the JD Edwards System
Design & Develop new applications, reports and interfaces for JD Edwards System.
Working with the business users on day-to-day issues in JDE System
As JDE Security Admin worked to define and fix Security in JDE
Skills:
ERP System : EnterpriseOne 9.2
Functional : Sales, Procurement, Inventory & Financial
Operating System : Unix
Database : Oracle
Company : CBS Corporation
Location: NY, US
Title : Sr. Application Developer
Duration: Jun 13 – July 16
Overview:
Working as a Sr. Application Developer to support CBS’s division (ShowTime Network Channels) finance department on their JD Edwards EnterpriseOne (8.10) System (AP, AR & GL).
Some of the Projects Involved:
ACH Payment:
Worked on analysis, development and implementation of ACH payment at Showtime/Smithsonian Channels. This involves developing new reports and applications.
Duplicate Address Book Records:
Developed reports/application to identify and archive duplicate vendors/employees that exists in E1 Address Book.
Annual Expenditure Limit:
Custom validation over the payment that exceeds the annual limit for the vendors and it puts the Vendor payment on hold if that exceeds. Also it reverts back the hold flag if the limit gets increased
Month End Reports:
Developed reports that identify any discrepancy on Cash Received and Invoices during month end Balancing.
Production Support:
Being a member of IT team supporting Corporate IT team worked on resolving issues with JDE AR, AP & GL modules and that includes resolving any data related issues.
Roles & Responsibilities:
Requirement Gathering from the business users on their new requirement
Analyzing the user requirement and proposing solutions on changing business process and code changes on the JD Edwards System
Design & Develop new applications, reports and business functions for JD Edwards Financial System.
Working with the business users on day-to-day issues on the Financial Systems
Skills:
ERP System : EnterpriseOne 8.10
Functional Knowledge : Financial (Accounts Receivable, Accounts Payable, GL)
Operating System : AS400
Database : DB2
Company : Kate Spade & Company(Formerly known as Liz Claiborne Inc.,)
Location: NJ, US
Title : Sr. Application Designer
Duration: Jan 06 – June 13
Overview:
Being part of IT Team involved in supporting Corporate Finance with their ERP System JD Edwards OneWorld XE and Actual Costing System. Also trained in PeopleSoft Enterprise Tools to support company’s HRMS System.
Some of the Projects Involved:
Production Support:
Being a member of IT team supporting Corporate Finance team worked on resolving issues with JDE AR, AP & GL modules and that includes resolving any data related issues. Worked extensively on AR and AP month end closing (balancing) issues.
A/P Interfaces from third Party Vendors:
Designed and developed programs to interface third party Invoices into JDE A/P System that include invoices of telecommunication, facility maintenance, utility payment and EDI retail vendor invoices and Custom Broker Invoices. This interface process includes validate & process the interface file (text file) to JDE Z tables and send email to business user group with details of any issues on the file.
Travel & Expense Implementation:
Worked on creating interfaces from PeopleSoft HRMS System to Travel & Expense System (CONCUR) with employee and department details. Also worked on interface from Concur to JDE with G/L transaction (Payment).
Workflow A/R Deduction System Implementation:
As part of the A/R deduction system implementation worked on interfaces from JDE to Workflow system that includes chargeback’s and credits. The new process will write-off chargeback’s and credits in JDE System and send the same to Workflow System and there it will be closed.
Actual Cost Accounting System:
Liz Claiborne developed a new system on Java platform and reports using SQR for Actual Cost Accounting. This includes interfaces with legacy systems and JDE. As part of the team involved in design & development of SQR Reports and JDE interfaces.
Mexx AR Implementation:
After Liz Claiborne acquired Mexx, an European apparel maker we implemented JDE (AR) for them and this includes new interfaces, reports and application changes.
Bullfrog Project (AR Return Process):
AR Return Process development using JDE Tools & Oracle PL/SQL Procedure in order to facilitate faster & economically smart deduction to credit matching process. This process requires to bring credits from Source System, JDE and Deduction System through interfaces, populate bar code tables using nightly scheduled job and interface to external vendor to send deduction data for any changes after bar code generation. Using the newly created JDE applications users from remote place will match credit with deductions based on external vendor application (deductions) and JDE bullfrog (newly built) application data at item level.
Eschement Process (Abandon Property):
Abandon Property Payment Process to provide business users ability to find out customers we owe them money and cut checks as part of the State Law. This project consists of developing Oracle View in order to bring only valid credits, deductions from JDE and external deduction system, JDE Application for users to select the customers for payment & sweep the same the external system after closing in JDE. Once users resolve those deductions/credits in the external deduction system the summary of payment details interfaced to JDE AP system for payment. Also developed positive pay file interface to bank.
PeopleSoft Projects:
New Travel & Expense System integration with JD Edwards EnterpriseOne System and PeopleSoft Enterprise System
New Stock option management system integration with PeopleSoft Enterprise System
Health Benefit interfaces with providers from PeopleSoft Enterprise System
Roles & Responsibilities:
Requirement Gathering from the business users on their new requirement
Analyzing the user requirement and proposing solutions on changing business process and code changes on the JD Edwards System
Analyzing of Financial Data for Financial Month End closing and reconciling financial reports
Design & Develop new applications, reports and business functions for JD Edwards Financial System.
Design & development of interfaces programs to send and receive data between PeopleSoft Enterprise ERP system (Human Resource Management) and external vendors using PeopleSoft tools and SQR programs.
Design & develop Oracle PL/SQL procedures to extract data from JD Edwards system
Design & development of Interfaces between JD Edwards System and other third Party Systems or external Vendors
Working with the business users on day-to-day issues on the Financial Systems
Skills:
ERP System : JDE (XE), PeopleSoft
Functional Knowledge : Financial (Accounts Receivable, Accounts Payable, GL)
Operating System : UNIX
Languages : SQR Programming, PL/SQL Programming
Database : Oracle 9i
Company : Transworld Information Systems Inc.
Location: NJ, US
Title : Programmer Analyst
Period : May 2005 – Jan 2006
Overview:
Transworld Information Systems provides Client services to support client’s JD Edwards ERP Systems. Being part of JD Edwards Team supported various clients on their JD Edwards ERP System to analyze business process, functional setup, User Security, fixing production issues, enhance their applications & reports using JD Edwards Tools and maintain data integrity among other systems by maintaining interfaces with JD Edwards System.
Some of the clients supported during the period with Transworld are:
The Gale Company, New Jersey based leading commercial real estate company in United States and Europe. Supported clients’ asset management, lease & tenant management and financial on JD Edwards ERP system.
GCA Services Group, Pennsylvania based leading provider of comprehensive custodial, light maintenance and grounds management services. Supported client’s financial module on JDE
Responsibility:
Requirement gathering from Users on new requirements & application modifications.
Analyzing business process and advising business users on process changes
Creating and changing functional setup on JD Edwards Financial module.
Setup and maintain User Security on the JD Edwards System.
Design and development of Applications, Reports and Business Functions in JD Edwards ERP System using JD Edwards Tools.
Responsible for analyzing, fixing and testing production issues in JD Edwards ERP System using JDE tool and functional setup changes.
Design & develop Oracle PL/SQL procedures to extract data from JD Edwards system and interface with other systems and external vendors
Writing UNIX Shell Scripts to call JD Edwards jobs and Oracle Procedures
Testing and documentation
User training on JD Edwards Financial Module on day-to-day activities and functional setup
Skills:
ERP System : JD Edwards OneWorld (ERP 8.0)
Operating System: Windows, UNIX
Database : Oracle 9i, SQL Server 2000
Company : HCL Technologies Ltd.,
Location: India / NY, US
Title : Sr. Consultant
Duration: Apr 03 – May 05
Overview:
HCL Technologies is leading Software Consulting company providing support to clients in maintaining their Software systems.
Being part of JD Edwards Team supported various clients on their JD Edwards ERP System to analyze business process, functional setup, User Security, fixing production issues, enhance their applications & reports using JD Edwards Tools and maintain data integrity among other systems by maintaining interfaces with JD Edwards System.
Client supported during the period with HCL:
CT Corporation, New York based leading provider of corporate legal services and being JD Edwards Consultant involved in production support, application enhancement, Report & Business Function development and solving JD Edwards Service Pack 22 issues in Web client.
Roles & Responsibilities:
Requirement gathering from Users on new requirements & application modifications.
Analyzing business process and helping users on System (functional) setup
Design and development of Applications, Reports and Business Functions
Developing business functions using ‘C’ Programming.
Responsible for analyzing, fixing and testing production issues in JD Edwards System
Training users on business process changes and functional setup
Design and development of interfaces between JD Edwards and third party systems.
Training and mentoring developers on JD Edwards System
Testing and documentation
Skills:
ERP System : JD Edwards EnterpriseOne (Release: XE)
Modules : Distribution & Logistics, Manufacturing, Finance
Database : SQL-Server/Oracle
Company : Accel ICICM Ltd.,
Location: India
Title : JDE Technical Consultant
Duration: Aug 02 – Apr 03
Overview:
Accel ICIM Systems & Services, Asia-Pacific business partner for JD Edwards Company (Currently with Oracle Corporation) is a leading Software Consulting provider for the JD Edwards ERP product and support clients in maintaining their ERP Software systems.
During the period with Accel involved in the following project:
Proteck Circuits & Systems Ltd, A Leading the manufacturer of Press Equipments and CNC Laths. Being a JD Edwards Technical Consultant involved in their implementation of JD Edwards ERP System (Manufacturing, Sales and Finance modules). Also this implementation includes Advanced Planning and Scheduling (APS) for their planning department.
Roles & Responsibilities:
Design and development of Applications, Reports and Business Functions in JD Edwards ERP System using JD Edwards Tools.
Responsible for analyzing, fixing and testing production issues in JD Edwards ERP System using JD Edwards tools.
Skills:
ERP System : JD Edwards EnterpriseOne (Release: XE)
Modules : Distribution & Logistics, Manufacturing, Finance
Database : SQL-Server
Company : ISAP Technologies PVT Ltd.,
Location: India
Title : Programmer
Duration: July 01 – Aug 02
Overview:
ISAP Technologies is software development company and as a programmer involved in design & development of software products & projects.
Some of the projects involved during the period associated with ISAP are
Design and development of client/server application software for Management information system for educational institutions
Construction project management
Designed and developed web based solutions for Publication house
Design and development of client/server application software Accounting Package
Roles & Responsibilities:
Requirement Gathering & Analysis
Design & development of web pages using HTML & ASP programming
Design & development of database tables using SQL Server 7.0
Design & development of Client/Server application pages using Visual Basic 6.0
Skills:
GUI : Visual Basic 6.0,
Internet : ASP 3.0, Java Script, VB Script
Database : SQL Server 7.0
Company : Profilz
Location: India
Title : Programmer
Duration: July 00 – Jun 01
Overview:
Profilez is software development company and as a programmer involved in design & development of software products.
Some of the projects involved during the period associated with Profilez are
Design and development of client/server application software for Library management
Designed and developed web based solutions for Online Trading
Roles & Responsibilities:
Design & development of web pages using HTML & ASP programming
Design & development of data base tables using SQL Server 7.0
Design & development of Client/Server application pages using Visual Basic 6.0
Unit Testing
Skills:
GUI : Visual Basic 6.0
Internet : ASP 3.0, VB Script
Data base : SQL Server 7.0