System Analyst
Microcenter
Total years of experience :21 years, 9 Months
Designed and developed PL/SQL procedures and packages to reduce embedded SQL and eliminate direct access to tables. This improved performance, enhanced security, and reduced the need for client/server product releases. Optimized SQL often improving performance by well over 100%. Helped developers redesign database intensive processes to improve use of indexes and reduce database load. Migrated applications from 9i to 10g. Developed Unit Test Plans and other documentation to support the business and the support team.
Environment: Oracle 9i/10g, Oracle Forms & Reports Developer 9i/10g, HP Unix, Windows XP
Developed and modified PL/SQL packages, procedures, functions, triggers, forms, reports as per requirement to make new enhancements or resolve problems. Designed, developed and tested business reports. Resolved functional issues in business processes through enhancements. Performed Integration testing for checking complete functionality of various modules. Involved in analyzing, developing and testing modules for PACCS.
Environment: Oracle 9i, Forms 3.0, Oracle Forms & Reports Developer 6i, Windows 2000/XP
Participate in analyzing, Designing, Developing, Testing and Documenting different modules for fabric processing e.g. Grey Inspection, Singeing/De-sizing, Pretreatment (Bleaching), Setting, Mercerization, Dyeing and Printing for processing department. Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards. Performed Unit Testing.
Environment: Oracle 9i, Oracle Forms Developer 6i, Oracle Reports Developer 6i, Windows 2000/XP
Oracle Certified Professional Developer Track (SQL/PLSQL/Forms/Reports)
Oracle Developer(SQL/PLSQL/Forms/Reports)