Project Sales
Resume:
Chandra Sekhar Kotturu
JDE Techno Functional Consultant
Professional Summary
Around 11 years of experience in JD Edwards OneWorld Xe / EnterpriseOne 8.10, 8.11, 8.12,9.0,9.1 and 9.2 which includes onsite exposure for short /long onsite and offshore durations
Extensive knowledge on JDE Development tools like Enterprise Report Writing, Interactive Applications, Table Conversions, C-Business Functions (Transaction Processing) and Work Flow management.
Good knowledge in developing internal and published business services with the help of JDeveloper.
Good knowledge of Real Estate Lease Management Operations under Leasing and Finance.
Good experience in handling BI Publisher Reports RTF and EXCEL Templates.
Subject Matter Experience on interfaces between JDE and legacy systems.
Extensive Knowledge in using JDE Interoperability and EDI standards and well versed in data migration activities.
Developed JDE tool developments like Auto email, Services Monitoring, PO viewer, Julian Date, E1 Page Constructor, Automatic Task Upload.
Working experience in JDE Procurement, Sales Order Management, Accounts Payable, Accounts Receivable and General Ledger Modules.
Proficient in utilizing Interoperability functionality of JDE using the JDE Z processes solutions gained as part of working with various JDE heterogeneous integration projects.
Good knowledge if installation and configuration of business services.
Working experience for BizTalk integration and Optio Integration with JDE.
Working knowledge of World Writer, FASTR.
Good SQL, PL SQL and SQL Server 2000 knowledge gained as a part of working on the Data Consolidation projects.
Experience in handling priority tickets like P1, P2 with quick response and timely resolutions meeting SLA’s.
Experienced in documentation of standard business processes, operating procedures, job aids and run book for support.
Technical Skills
ERP
JD Edwards OneWorld Xe B733 / 8.10/ 8.11, World Soft (A7.3)
Languages
RPG/400,C++,C, Java
Operating System
Windows 2000, Windows XP,AS/400
Database
MS SQL Server, Oracle
Project Profile
Project Name: Managed Services
Project Duration: Sept 2016 to till Present
Working Organization
CSC – UXC RED ROCK CONSULTING
Client
ANZ Clients
Industry of Client
Project Description
JDE version
JD Edwards Enterprise One 9.1 (Tools Release 9.1.5)
Modules
Finance, Distribution, Real Estate
Role
Functional Consultant
Responsibilities
Support the managed services tickets for Finance – Accounts Receivable, Payable, Expense Management, Fixed Assets and General Ledger.
Project Name: Production Support & Development Projects
Project Duration: August 2013 to Sept 2016
Working Organization
AHMED KHALIL AL BAKER MEDICAL SUPPLIES
Client
Leader Pharma Distribution Company, Dubai
Industry of Client
Pharma Distribution
Project Description
Support for existing production jobs.
Development of FOC (Bonus) Reports and its implementation.
New Companies Rollout for Other regions with different path code setup.
SQL Support for the daily fixes.
Van Sales B2B Automation Application for placing an order till invoice.
System Tools: PO Viewer, Task Documentation, Julian Date Converter
Cheques scanning application along with Sales Entry Application.
JDE version
JD Edwards Enterprise One 9.1 (Tools Release 9.1.5)
Modules
Finance, Distribution, Real Estate
Role
Technical Lead /Functional Consultant
Responsibilities
Technical Lead supporting database and CNC Related activities.
PLSQL Related activities. SQL Fixes.
Company Rollout and FOC Project Implementation
Application Development and Other monitoring activities.
Developed Mobile Sales/Van Sales Custom Application for End to End Sales Process.
Designed and Developed Lease Approval Flow along with Recurring Billing, Manual Billing Entries.
Project Name: SP24 Upgrade & Production Support & Data Archiving & Rollout
Project Duration: November 2010 to August 2013
Working Organization
HCL TECHNOLOGIES
Client
Leader Publishing Company, USA
Industry of Client
Publishing
Project Description
The project is to upgrade from SP22 to SP24 and provide continuous support for production activities.
It includes development project about AP and AR Data archiving and Database upgrade.
In addition to that, we have customized one world and integrations to support for new company acquisition.
JDE version
One World Xe (B7333, SP 23)
Modules
Finance, Distribution, Manufacturing
Role
Lead Technical Consultant /Module Lead/Project Lead
Responsibilities
SP24 Upgrade from SP22.
Test the applications and report functionalities after the upgrade.
Troubleshoot and fix the issues coming up in Upgrade.
Manage the offshore development team.
Managing the Timely delivery of deliverables.
Creation of unit and integrated test scripts for setups and applications testing.
Create and maintain documentation of Applications & UBE design documents and training material.
Work on Integrations, implementation of tools, Production Support
Worked on the Data archiving procedures and successfully executed the project for huge set of data.
Worked as Lead for Data archiving project and managed the offshore team.
Worked as technical lead for new company acquisition.
Designed and developed the integrations to support for new company acquisition and new applications rollout to one world.
Project Name: Data Consolidation and Czech Conversion
Project Duration: December 2009 to November 2010
Working Organization
HCL TECHNOLOGIES
Client
Leader Chemical Company, USA
Industry of Client
Chemicals
Project Description
The project is to consolidate the data for three instances along with conversion of Czech Data base.
JDE version
One World Xe (B7333, SP 23) & Enterprise One 9.0
Modules
Finance, Distribution, Manufacturing
Role
Technical Consultant
Responsibilities
Responsible for the solution design, develop and execute.
Responsible for optimize the solution design with increased performance.
Responsible for development of SQL Scripts in PL/SQL for the upgraded oracle Data base.
Responsible to develop scripts for Czech Conversion in SQL Server 2000 for SQL Server Data base.
Responsible for the execution of all the scripts developed during Data consolidation and Czech conversion process.
Responsible for creating the user manuals and Technical Design Specifications.
Project Name: Data Consolidation and Czech Conversion
Project Duration: October 2009 to December 2009
Working Organization
HCL TECHNOLOGIES
Client
Leader Chemical Company, USA
Industry of Client
Chemicals
Project Description
The project is to Install and Configure Business Services along with the implementation of major interfaces with the help of business services.
JDE version
One World Xe (B7333, SP 23) & Enterprise One 9.0
Modules
Finance, Distribution, Manufacturing
Role
Technical Consultant
Responsibilities
Responsible to analyze the existing interfaces to find the necessary mappings in manufacturing.
Responsible for Design of Business services by identifying the business functions for each phase of Manufacturing work order process existing in XE.
Responsible for the replacement business functions in Enterprise one 9.0 for the business functions in XE.
Responsible for the Development of Internal Business services and published business services in manufacturing.
Responsible for doing Unit Testing of Business Services.
Responsible for Integration Testing for manufacturing process after deploying the published and internal business services.
Responsible for the development and unit testing of custom business services for the UOM Conversion, Get 2nd Item Number and GETADHOC.
Responsible for the unit testing of the major interfaces in Job costing which we developed using business services.
Project Name: EnterpriseOne 8.11 Implementation
Project Duration: June 2008 to Oct 2009
Working Organization
HCL TECHNOLOGIES
Client
World’s leading Dairy manufacturer, Srilanka & Newzland
Industry of Client
Dairy Manufacturing
Project Description
EnterpriseOne 8.11 Implementation
JDE version
E 8.11
Modules
Sales Order Management, Finance, Manufacturing
Role
Technical Consultant
Responsibilities
Design and Development of supporting interfaces in Distribution and Finance using standard EDI reports.
Development of the reports related major interface to make the process flow so effective.
Development of Invoice (R5542565LK) by inclusion of local taxation in srilanka like VAT Withholding Taxes with proper format provided by client.
Modification of Cheque printing program (R5504572A) to the customer requirements.
Worked with custom reports which are useful for processing finance related operations like credit balance report, withholding tax monthly report, withhold tax certificate for each customer.
Worked with stock report which will be providing the information from different departments like manufacturing, sales, inventory along with suggestion to embark the sales.
Responsible for the Menus creation and promotion and security setups.
Responsible for creation user manual and super user training along with document submission.
Responsible for the post go live support to resolve the issues at the earliest by staying near to client.
Responsible for production support for srilanka, Malaysia, newzland.
Responsible for developing the workflow related to service management for newzland opco.
Project Name: Development and Production Support
Project Duration: Aug 2007 to June 2008
Working Organization
HCL TECHNOLOGIES
Client
Pipeline Manufacturer, MO,USA
Industry of Client
Client is one of the leading Providers of trenchless technology. They are able to respond to worldwide sewer, water and industrial pipeline rehabilitation needs with long term and less disruptive solutions. Their business process is primarily functioning on JDE One World Xe/ World A7.3 (Co-existence) and also assisted by Pnet, Rapid Decision, etc., as their supporting systems.
Project Description
HCLT was awarded the Integration project between One World Xe and Pnet which was a vital project for Client’s business process. HCLT was also supporting the clients Manufacturing and Financial modules
JDE version
One World Xe (B7333, SP 23) / World A7.3
Modules
Manufacturing, Finance, Procurement
Role
Technical Consultant
Responsibilities
Worked with A/R Aging Reports
Worked with exporting the A/R Aging Reports into CSV format.
Worked with the custom Report A/P Vouchers By Company(R5704APV)
Modified the Invoice Print with Smart Fields (R48507) to print the Units of measure on the report.
Worked with the custom Vendor Summary Report (R5704VEND)
Modified the Custom report G/L Audit to get the output flat file with different delimiters.
Worked with the four World Writer reports relating to the Manufacturing. Developed the same reports in the One World.
Implementing the Auto- email Tool at the client site.
Project Name: Development and Production Support
Project Duration: March 2007 to Aug 2007
Working Organization
HCL TECHNOLOGIES
Client
Leading Medical Devices Manufacturing company, USA
Industry of Client
Offshore Support & Enhancements.
Project Description
The project is about providing the JDE support on the Manufacturing Module which client has implemented
JDE version
E8.12
Modules
Finance
Role
Technical Consultant
Responsibilities
Developed a report (R57EMPD), which gives the detailed information about Department, Salary, Grade and Benefits of the employer based on the Employee ID and the Department ID. Developed this report using tabular report design aid to give the automated totals.
Created a Report copying Asset Report Writer: Additions and Retirements (R1200002) and modify it in order to have all assets movement during the year sorted by class number. The report will display the asset total for each class and the total of all assets.
Modified the existing Address Book Application P01012 to include Shipment Number and Getting the phone number and phone type from F0115 based on effective date.
Created Custom report R5543121 to calculate Transaction time elapsed for different Routing Steps in the Receipt Routing Process over a period of time.
Created a report (R57SOBACK) to give the details about the back ordered information including the reason for back order.
Responsible for the process documentation of the defects and solutions. The technical solution was identified based on the study done according to the client requirements and Functional solution. The Unit test cases are recorded and the modified process is tested based on the Unit test cases.
A thorough study is made on the requirement and modifications are made accordingly. A thorough study is done aftermath the code changes to analyze the impact of the code change on various other inter-related processes.
Defects are resolved based on the priority of the Issue assigned by the Production Support Team.
Project Name: HCL Solution Development
Project Duration: November 2006 to March 2007
Working Organization
HCL TECHNOLOGIES
Client
HCL
Project Description
This project is about analyzing the requirement, developing and testing of the Automatic Email Tool.
JDE version
JD Edwards EnterpriseOne 8.12, JDE One World Xe 733
Role
Developer
Responsibilities & Development Details
Automatic E-Mail Tool is used to E-Mail the output automatically when the report or its version runs manually or by scheduling, to the corresponding recipient.
Using the custom application the user enters the report, version name and other details necessary for sending the email
The custom report is either scheduled or submitted manually based on the processing option values where we enter the server path and acknowledgment details
Involved in Analysis and requirement gathering of Automatic Email Tool
Preparing of technical specification document
Involved in development of tool in both Xe and E8.12 Versions
Preparation of Test cases.
Project Name: HCL Solution Development
Project Duration: Aug 2006 to November 2006
Working Organization
HCL TECHNOLOGIES
Client
HCL
Project Description
This project is about analyzing the requirement, developing and testing of the Service Monitoring Tool.
JDE version
N/A
Role
Developer
Responsibilities & Development Details
Service Monitoring Tool is used to E-Mail to the CNC Administrator or to group of CNC when particular windows service is down.
Developed the algorithm to the process monitoring action on a particular windows service
Developed an .exe using C++ programming.
Preparing of technical specification document
Preparation of Test cases.
Contact this candidate