Oracle Applications Technical Lead
Rexall PharmaPlus
Total years of experience :24 years, 1 Months
Deliver and support an industry-specific, secure, comprehensive, and centralized software solution (Blue Yonder/JDA) used for
the Supply chain implementation and process improvement project for consumer goods. Implementation of the Blue Yonder
applications.
• Responsibilities include enhancing and supporting Blue Yonder(JDA) applications which include ( Promotion, Pricing,
Category Knowledge Base, Demand, and Fulfillment).
• Led and coordinated with the Development and Testing team for well-planned deliverables.
• Review codes and other standard protocols to test the performance quality of products.
• Works with Project Managers to identify development risks and align internal expectations.
• Ability to interact effectively in an extremely dynamic environment with multiple priorities. Initiating necessary tasks and
ensuring follow-up.
• Execute effective processes for enhancements of existing systems and new user needs.
• Led Oracle Apex Projects and team.
• Environment & Tools: Windows UNIX, .NET, GIT, JIRA, HTML5, XML, SQL, PL/SQL, Power BI.
Deliver and support an industry-specific, secure, comprehensive, and centralized software solution (eSIS) used for the retrieval, collection, and storage of student-related data. Troubleshoot and resolve issues and applications affecting production performance and new development initiatives. Provided extensive support for Tomcat application server.
•Utilize agile methodology and scrum framework in the development of new and enhancement of existing application modules, system designs, and technical specifications, forms, standards, and reports.
•Designed, developed, and maintained customized reports, screens, and database functions, triggers, and procedures.
•Work directly with developers in performing code reviews and on the optimization of code standards.
•Environment & Tools: Windows UNIX, PVCS, .NET, Visual Studio C#, IReport, ASP.Net XML, HTML, Java, IReport, HTML5, CSS3, Bootstrap, Telerik, Oracle forms & reports (9i, 6i), XML, SQL, and PL/SQL.
Provided system and software engineering support for the warehouse management and supply chain management systems. Responsible for managing WMS, SAP, and JDE interface, SQL query optimization, data administration, and the troubleshooting of issues related to system production and new development.
•Delivered consultation services, software solutions, and supply chain software optimization for improved order flow and production and simulation software used for the long-term strategic planning of production networks.
•Wrote the client interface routine for Oracle WMS data to JDE and SAP systems for assigned clients (Church & Dwight Co. and E. & J. Gallo Winery).
•Developed and modified database procedures, functions, triggers, and packages to enhance and improve functionality.
•Environment & Tools: Developer/2000 (Forms-9i, Report-9i), PL/SQL, SQL, SQL-Navigator, MS-Windows NT, UNIX (SUN), Oracle v10g, OC4J, PVCS, and WMS.
Responsible for the development, modification, and maintenance of programs and applications, including the maintenance, troubleshooting, enhancement, and performance of the company’s RETEK Information System. Translated business and customer requirements into customized applications and technical design specifications that enhance and support purchase order, transfer and item processes within the hybrid distribution strategy.
•Streamlined and supported vendor shipping with the consolidation of all merchandise into one warehouse shipping location.
•Developed, customized, modified, and maintained Oracle reports and forms, database procedures and functions, and SQL queries.
•Automated backend jobs with the development of UNIX Shell scripts and the loading of data using SQL*Loader.
•Environment & Tools: Developer/2000 (Forms-6i, Report-6i), PL/SQL, SQL, SQL-Navigator v4.1, Windows NT, Pro*c, UNIX (AIX 4.1), Oracle v9i, PVCS, RETEK, and CTRL-M.
Developed, maintained, and provided troubleshooting support for production and new development initiatives of the RETEK Information System, responsible for managing and serving as the central point of order and merchandise management information flow throughout the enterprise.
•Analyzed, designed, and developed customized packages, procedures, and functions as well as Oracle forms and reports, and data extractions and transformation functions.
•Modified web report logic using new built-in Run-Report-Object.
•Developed order and item inquiry forms resulting in a faster query process.
,
courses: ASP ..NET Programming | C# Programming | Java Programming
,
,
,