Programmer Analyst - Oracle/SQL Production Support
Resume:
Johnny Ta, Programmer Analyst
Charlotte, North Carolina
****.**.****@*****.***
PROFESSIONAL SUMMARY
Programmer Analyst skilled in enhancing enterprise application support across Oracle Database and SQL Server. Maintains production data and support while developing with Java EE, SQL, PL/SQL including table structures, store procedures, functions, tables, triggers. Achieved increase in report accuracy and reduced issue resolution time through effective troubleshooting. Specializes in delivering tailored solutions for manufacturing, warehouse applications, and server workflows.
SKILLS
SQL PL/SQL Java EE UNIX
Oracle APEX JASPER SSRS Oracle Form
XML/XSL BI Publisher Troubleshooting Requirement analysis
Application Production Support
EMPLOYMENT HISTORY
Programmer Analyst, Jomar Softcorp Corporation Current
Maintain a data warehouse using TOAD, SQL, SQL Plus, Microsoft Server Enterprise. Enhance functionality of Manufacturing and Roll Goods Processing Systems. Collaborate with Project Manager to estimate technical requirements and develop solutions for projects. Write scripts creating and modifying tables, indexes, functions, stored procedures, view. Develop screens using Java EE on Eclipse. Designed and developed reports: Jasper, SSRS, XML/XSL.
Oracle Developer, The Cato Corporation 06/2007 to 04/2020
Develops innovative technical solutions to complex problems aligned with organizational objectives. Utilises TOAD, SQL, PL/SQL, Oracle APEX, Oracle Form, BI Publisher to develop and support WMS systems.
Troubleshooting issues, formulating both short and long term solutions in collaboration with the Distribution Center Operations team, Logistics team and Warehousing team. Ensure issue logging adheres to IT helpdesk standards, resolving based on business priority
Production Support Developer, New Breed Logistics Corporation 07/2005 to 06/2007
Managed real time SQL data for global transactions in a high volume operation environment. Diagnosed and resolved issues daily. I partnered with clients and business analysts to enhance and implement new functionality in the transportation management system. New Breed manages million square feet of ISO-quality warehouse space across more than 70 distribution centers. Support and manage data transactions for Version as a heavy transaction data daily while developing new logistic processes using Oracle PL/SQL stored procedures, functions.
Software Engineer, Red Prairie 06/2000 to 06/2005
Developed and maintained WMS system using TOAD, PL/SQL, SQL Plus, UNIX, VI, C language to create job process. Collaborated with team members to implement and test projects, ensuring timely delivery and quality outcomes. Delivered installation and training users at client sites, offering seamless support after business hours.
Programmer Analyst, Systems & Computer Technology Corp 07/1998 to 06/2000
Directed development and maintenance utilities system for BANNER Customer Information System to enhance user functionality.
Designed and implemented database using Oracle 8i
Modified user entry screen oracle form. Creating stored procedures and packages with Oracle Designer 2000, Oracle form 4.5, 5.0 to streamline data entry process.
Collaborated with clients to understand their business requirements
EDUCATION
Bachelor of Science: Computer Science
University of North Carolina at Charlotte, graduated May, 1998
Contact this candidate