Recent...

CCB Implementation (2014 to 2016) – This Customer Care and Billing project included data conversion from AS400 based ORCOM Customer Information and Billing System, security implementation, custom interface, and custom report development. The tasks included: 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 scripts for synchronized launching of CCB conversion batch jobs required for data validation, key generation and data insertion. Execution of multiple full end-to-end conversions, including the one for go-live. Help with data cleanup by designing and developing scripts for pre-validation of ORCOM data. 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. Implemention of security by defining user profiles, user groups, to-do roles, and user permissions. Development of custom XC2 Backflow System interface. Creation of custom BI Publisher reports for Export of Customer Data, and Custom Receivables Aging Report.
CCB Implementation (2014) – This Customer Care and Billing project included security implementation, batch scheduler implementation, analysis of migration tool (CMA) and database schema comparisons. The tasks included: Setting up LDAP integration between WebLogic and Active Directory, Defining user profiles, user groups, to-do roles, and user permissions, Synchronizing CCB authorization groups with Active Directory, Defining CCB batch jobs for hourly, daily and periodic runs, Documenting parameters for each CCB batch, Defining jobs streams and job dependencies, Analyzing foreign reference errors created during object migration using CMA tool, Comparing and reporting configuration setup differences between CCB environments.


Previous...

JDE Expense Integration with AMEX (2013) - This JD Edwards EnterpriseOne project included creating an inbound interface for JDE Expense Management System that brought in employee incurred credit card expenses from AMEX to JDE. The tasks covered included analyzing requirements, creating design document, mapping of AMEX and JDE codes, development of custom JDE interface objects (tables, views, applications, user defined codes, processing options, universal batch engines, and menus), conducting tests and promoting objects. The custom objects were designed so that users can easily identify and correct mapping errors. All maps were soft coded to cover any changes without programmer intervention.
JDE Vendor Payment Reports (2013) - This JD Edwards EnterpriseOne project included creating reports for AP Vendor Payments where the output was desired in PDF as well as CSV formats. The task covered included creating design document, development of custom JDE objects (processing options, universal batch engines, and menus), conducting tests and promoting objects. As the reports included all category codes from supplier master, CSV output was carefully designed so as not to drop any column in the output.

more...
JDE Expense Integration with AMEX (2013) - This JD Edwards EnterpriseOne project included creating an inbound interface for JDE Expense Management System that brought in employee incurred credit card expenses from AMEX to JDE. The tasks covered included analyzing requirements, creating design document, mapping of AMEX and JDE codes, development of custom JDE interface objects (tables, views, applications, user defined codes, processing options, universal batch engines, and menus), conducting tests and promoting objects. The custom objects were designed so that users can easily identify and correct mapping errors. All maps were soft coded to cover any changes without programmer intervention.
JDE Vendor Payment Reports (2013) - This JD Edwards EnterpriseOne project included creating reports for AP Vendor Payments where the output was desired in PDF as well as CSV formats. The task covered included creating design document, development of custom JDE objects (processing options, universal batch engines, and menus), conducting tests and promoting objects. As the reports included all category codes from supplier master, CSV output was carefully designed so as not to drop any column in the output.
CCB Data Share interface - Phase II (2013) – This Customer Care and Billing project included enhancing custom interface developed in 2012, using Java, J2EE, PL/SQL, and Web Services. The tasks included introducing XAI web services for account management, enhancing out bound interface queries, adding new letter and Crystal report formats, adding rate schedule constraints, and processing phase II data.
JDE Go-Live Support (2013) - This JD Edwards EnterpriseOne project included assisting company with pre go-live support. The activities included – Applying latest Tools Release Patch (TR 9.1.2.4), migrating objects to v9.0 modified on v8.12 since last object merge, verifying availability of check print modification developed last year in XMLP and BI Publisher, performing data conversion iteration, assisting in user testing and finally converting data during go-live, and providing post go-live support as needed.
JDE Check Print using Oracle's BI Publisher (2012) - This JD Edwards EnterpriseOne project included creating and deploying Microsoft Word (RTF) template for standard JDE check printing program R04572. The template included check details, company logo, MICR font, and authorized signature for amount threshold.
JDE Tools Release upgrade to 9.1 (2012) - This JD Edwards EnterpriseOne project included upgrading Tools Release from 8.98 to 9.1 and it was done in Windows 2008, Microsoft SQL Server 2008, and WebLogic 10g environment.
CCB Data Share interface (2012) – This Customer Care and Billing project included gathering requirements, designing, and developing custom interface for sharing customer data amongst Utility companies using Java, J2EE, PL/SQL, and Web Services.
JDE Version 9.0 install (2011) - This JD Edwards EnterpriseOne project included upgrading version 8.11 to version 9.0 as a parallel install and it was done in Windows 2008, Oracle 11g, and WebLogic environment. Install comprising of Deployment Server, Enterprise Server, Web Server, Server Manager, Environment setup, Object merge, and System data merge, Security Setup, applying latest ESUs and ASUs, and iterating data conversion.
JDE Version 9.0 install (2011) - This JD Edwards EnterpriseOne project included upgrading version 8.12 to version 9.0 as a parallel install and it was done in Windows 2008, Microsoft SQL Server 2008, and WebLogic environment. Install comprising of Deployment Server, Enterprise Server, Web Server, Server Manager, Environment setup, Object merge, and System data merge, Security Setup, applying latest ESUs and ASUs, and iterating data conversion.
JDE Migrating legacy payroll data (2011) – This JD Edwards EnterpriseOne project included gathering requirements, designing and developing custom applications for converting AS400 historical Payroll data to JD Edwards EnterpriseOne using JDE Tools, PL/SQL, AS400 DTF, and SQL Loader. Designing and developing custom JDE application for presenting this converted data in columnar format.
JDE Financial data consolidation (2011) - This JD Edwards EnterpriseOne project included gathering requirements, designing and developing custom JDE Financial Reports in JDE Tools pertaining to Trial Balance, Income Statement, and Balance Sheet to consolidate Financial data coming from 18 countries. Developing custom applications pertaining to account number lookup, account number cross reference, and loading consolidating data in to Z tables easily.
CCB Billing interfaces (2010) – This Customer Care and Billing project included gathering requirements, designing, and developing custom interfaces using Java, J2EE, PL/SQL, and Web Services. Interfaces included e-Bill enrollments, Auto Pay enrollments, Payment uploads, Meter Read uploads and downloads, Bill Printing extract, General Ledger integration with JD Edwards EnterpriseOne, Back Flow integration with XC2 system, IVR and Company Website data feeds.
CCB Crystal reports (2010) – This Customer Care and Billing project included developing custom reports using Crystal Reports, Oracle database, PL/SQL, and Business Objects XI.
CCB Billing data conversion (2009) – This Customer Care and Billing project included gathering requirements, designing, and developing data conversion from AS400 based ORCOM Customer Information and Billing System to Oracle based Oracle Utilities Customer Care and Billing System using Java, PL/SQL, AS400 DTF, and Oracle SQL Loader. Data Conversion included data pertaining to CCB Modules of Person, Account, Premise, Meter, Meter Read, Item, Service Point, Service Agreement, Bills, Payments, Adjustments, and Account Balances.
CCB Version 2.2 install (2008) - This Customer Care and Billing project included install of version 2.2, creation of environments, applying product patches and upgrades, configuring WebLogic and Windows AD integration using LDAP for user authentication, setup of workflow and scheduler, and install of Business Object XI server.
JDE Procure to Pay implementation (2008) – This JD Edwards EnterpriseOne project included gathering requirements, analyzing gaps, creating custom objects, setup of menus and security, training personnel, and converting legacy data for JD Edwards modules pertaining to Address Book, Purchase Orders, Inventory, and Accounts Payable.
JDE Bill of Material integration (2007) - This JD Edwards EnterpriseOne project included designing and developing custom objects using JDE Tools, and PL/SQL to integrate JDE Bill of Material and custom Bill of Material for use in JDE Material Resource Planning MRP and Work Order Generation.
JDE Version 8.12 install (2006) – This JD Edwards EnterpriseOne project included install of version 8.12 and it was done in Windows 2003, Microsoft SQL Server 2000, and Oracle Application Server OAS (10g) environment. Install comprising of Deployment Server, Enterprise Server, Web Server, Environment setup, setup of menus and security to implement JDE default deny security, applying latest ESUs and ASUs, Create!Print Server, and converting data from JDE World using T/SQL and DTS.
JDE Financial reports (2006) – This JD Edwards EnterpriseOne project included Gathering requirements, designing, and developing custom Financial Reports in JDE Tools, and creating custom JDE smart fields. This task involved reverse engineering AS400 legacy reports and creating similar reports in EnterpriseOne.
Graphical Statistical Analysis (2005) – This project included gathering requirements, designing, and developing an internal web site for Graphical Statistical Analysis of Electrical Test Data of Semiconductor Wafer using PL/SQL, IIS, ASP.NET, Office Web Component Charts, and ADODB technologies. Programming included auto data capture from vendors in Asia, data conversion to company format, and data analysis to support web site.
JDE Shipping documents automation (2005) – This JD Edwards OneWorld project included gathering requirements, designing, and developing automated shipping document generation in JDE using C functions, JDE tools, PL/SQL, Acrobat API, XML, Excel automation, VB.NET, SMTP and MAPI.
JDE BAAN ERP Merge (2004) – This JD Edwards OneWorld project included gathering requirements, designing, and developing merge of BAAN ERP and JD Edwards ERP systems. Where merge scope included data pertaining to Address Book, Items, Inventory, Bill of Material, Sales, Purchase, Accounts Payables, and Accounts Receivables.
JDE Shop Floor data integration (2003) – This JD Edwards OneWorld project included gathering requirements, designing, and developing integration of FABLESS Work-In-Progress manufacturing data between company and vendors in ASIA.
JDE Bill of Material interface (2002) – This JD Edwards OneWorld project included gathering requirements, designing, and developing custom interface between JDE Manufacturing and IRONCAD design system using JDE Tools, C, and PL/SQL.
JDE CAMSTAR interface (2001) – This JD Edwards OneWorld project included gathering requirements, designing, and developing custom interfaces between JDE system and CAMSTAR MESA using JDE Tools, C, MS-Access, PL/SQL, and Visual Basic.
JDE Manufacturing implementation (2000) – This JD Edwards OneWorld project included gathering requirements, designing, and developing customizations in JDE Manufacturing system using JDE Tools, C, Crystal Reports, and Visual Basic. Customizations included Bar Code support in JDE, Real-Time integrations with third party applications, maintenance of weighted average cost in dual currencies, EDI Integration, development of custom Work Order Entry application and Crystal Reports Integration with JDE.
JDE Distribution implementation (1999) – This JD Edwards OneWorld project included gathering requirements, designing, and developing customizations in JDE system using JDE Tools, C, Crystal Reports, and Visual Basic. Customizations included pick slip, shipping documents, invoice, and custom applications for JDE Sales Order Entry.

less...