Programmer Analyst
Resume:
Johnny Ta
Charlotte, NC *8278
(704) 458 – 5620
****.**.****@*****.***
SKILLS
Experienced Working in Oracle Database Development. Using TOAD, SQL, SQL*Plus, PL/SQL, Oracle APEX, Oracle Form, Crystal Report, BI Publisher.
Good Working Knowledge in Microsoft Server 2005/2008. Using Microsoft SQL Server Management Studio Tool to Maintain and Modify the Production Data Daily as well as Create New, Modify Tables, Indexes, Triggers, Store Procedure, Functions, View.
4 years + in Java/J2EE Programming as well as Developed Document Report with XML/XSL.
Application Production Support Experience.
Strong Analytical and Troubleshooting skills.
Good Working Knowledge in UNIX, HP UNIX Commands. Using Vi to developed batch process in PRO*C
Worked with Source Control and Version Management Tool CVS.
Experienced in Quality Center to track defects and conduct testing.
Experienced with Functional Understanding of ecommerce applications, interfaces and business processes.
Performed projects in full development life cycle, especially in the analysis phase and the design phase.
PROFESSIONAL EXPERIENCE:
Jomar Softcorp International Charlotte, NC Aug 2021 – Current Programmer Analyst
Create new, modify, and update processes of Manufacturing and Roll Goods Processing System
Work closely with Project Manager to estimate technical working effort and to develop technical solutions for future projects
Monitor and manage customer’s data daily
Write scripts which create/modify tables, indexes, triggers, store procedures, functions and views that are called in the Java Scripts, Java, and JSP for warehouse scanners.
Develop various screens using Java EE on Eclipse throughput Manufacturing System, Roll Goods Processing System, Customer Services System
Create/Modify various reports using XML and XSL as format and processes is under Java
Familiar with Jasper Report
Work directly with clients for their ad-hoc requests
Working with Oracle, SQL Server database in Java
The Cato Corporation Charlotte, NC Jan 2015 – Apr 2020 Programmer Analyst
Develops technical solutions to a wide range of difficult problems. Solutions are innovative and consistent with organization objectives.
Using PL/SQL, Oracle APEX, Crystal Report, Oracle Form, BI Publisher to develop/modify report.
Troubleshoot issues and formulate both short- and long-term solutions while working in collaboration with DC Operations and the Logistics and Warehousing group
Ensures all issues are logged per IT Helpdesk standards and resolved based on business priority. Follow-up with users to confirm issue resolution meets the business requirement.
Jomar Softcorp International Charlotte, NC Feb 2010 – Jan 2015 Programmer Analyst
Create new, modify, and update processes of Manufacturing and Roll Goods Processing System
Work closely with Project Manager to estimate technical working effort and to develop technical solutions for future projects
Monitor and manage customer’s data daily
Write scripts which create/modify tables, indexes, triggers, store procedures, functions and views that are called in the Java Scripts, Java, and JSP for warehouse scanners.
Develop various screens using Java EE on Eclipse throughput Manufacturing System, Roll Goods Processing System, Customer Services System
Create/Modify various reports using XML and XSL as format and processes is under Java
Work directly with clients for their ad-hoc requests
N & T Custom Design Inc. Charlotte, NC May 2007 – Feb 2010
IT Developer, Family Owned Cabinet Company
Transformed cabinet manufacturing manual process into a more robust process by developing a cabinet software design tool (using Microsoft SQL 2000)
Developed and maintained company’s web-site
Management HR Role for family business
New Breed Logistics Corp. Charlotte, NC Jul 2005 – May 2007
Production Support Developer
Monitored real-time SQL data and jobs for global transactions, in a high volume operations environment
Troubleshoot and fix system as needed on a daily basis
Worked closely with clients and/or Business Analyst to enhance / add new functionalities to current system
Logistics Internet Services (LIS) Charlotte, NC Jun 2000 – Jun 2005
Software Engineer
Developed, maintained, and provided client support for the application
Implemented and customized WMS to meet the requirements of Armstrong Industry, F&P, Saint Gorbain Company, Alcon, Mckee Foods, and US Can, etc.
Elicited requirements from clients and prepared design documents for projects
Worked closely with team to implement and test projects
Provided installation at clients’ sites and training
Involved in after business hours to provide seamless customer’s support
SCT Corp. Columbia, SC Jul 1998 – Jun 2000
Programmer Analyst / Oracle Developer
Developed and maintained custom utility of BANNER Customer Information System (CIS).
Frequent involvement with clients to better understand business process and functions
Modified existing user entry screen forms using Oracle Designer 2000, Oracle Forms 4.5, Form 5.0 and developing stored procedures and packages using PL/SQL
Developed database for client using Oracle 7.3, Pro*C running under HP UX.
Maintained BANNER CIS as part of the Defect Correction Team.
EDUCATION
University of North Carolina at Charlotte Aug 1994 – May 1998
Bachelors of Science in Computer Science
REFERENCES
Khanh Tra
Sr. VP, Product Management
Suzy, Inc.
Kevin Vargro
Manager of IT Warehouse Team
The Cato Corporation
Contact this candidate