Worked as software developer on JD Edwards Enterprise One project that included upgrading JDE system from release 8.12 to 9.2 on Windows, WebLogic, and Microsoft SQL Server platform. The scope of the upgrade project included following: Planning the upgrade; Sizing servers as per minimum technical requirements; Downloading and installing JDE 9.2 as parallel install; Creating standard environments in 9.2 – pristine, development, prototype and production; Installing WebLogic Instances for Server Manager, and JAS Server; Migrating users and security from 8.12 to 9.2; Implementing AD LDAP integration for user sign on in 9.2; Migrating data, objects and versions from 8.12 to 9.2; Creating Statistics for Migrated Data; Retrofitting custom objects in 9.2; Verifying migrated versions in 9.2; Assisting in redefining GL Allocations in new format in 9.2; Planning and conducting user acceptance tests (UATs) for standard JDE applications and reports pertaining to GL, AP and AR in 9.2; Identifying and running integrity reports for GL, AP and AR in 9.2; Fixing GL, AP and AR batch and data problems in 9.2; and Creating evidence for Audit. The scope also included custom development of following: Creating custom check format in BI publisher; Creating custom objects for Z-table Address Book uploads; Creating custom Financial reports – these period, quarterly, yearly, and cumulative balance format reports included Budget vs Actual Expenses, Cash Flow, Grouped and Individual Balance Sheets, Grouped and Individual Income Statements, Financial Highlights, and Financial Balances.
Worked as software developer on Customer Care and Billing project that included data conversion from legacy AS400 based ORCOM CIS system, implementation of CCB security, custom interface development, and custom report development. Data Conversion – creation of data migration map, design and development of custom data conversion routines in Java, AS400 DTF, Oracle SQL Loader, and Oracle PL/SQL, development of LINUX shell scripts for synchronized launching of CCB conversion batch jobs, multiple full end-to-end conversion executions, and designing and developing SQL scripts for pre-validation of source data. Data Conversion reports – creation of custom audit reports for data validation, batch run execution, end to end counts, execution timing, financial balances, variances, receivables aging, and data fixes. Implementation of CCB security – defining user profiles, user groups, to-do roles, and user permissions. Custom interfaces were developed between CCB and XC2 Backflow System. BI Publisher custom reports were created for Export of Customer Data, and Receivables Aging.
Java, SQL, Oracle PL/SQL, Shell Scripting
Microsoft SQL Server, Oracle
Database Design > Database Development, JDEdwards EnterpriseOne, Financial Statements/Financial Reports, industry~it, Microsoft Windows, Audit, Microsoft SQL*Loader, Cash Flows, Database, custom report development, custom interface development, Financial Statements/Financial Reports > Income Statement, IBM AS400 Hardware, JDEdwards Suite, AD, JDE GL, Analyst/Programmer, JDE AR, WebLogic Enterprise Application Server, JDE AP
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.