Certified Oracle Forms Developer, database programing, Oracle Reports
Resume:
Zorida Boochoon
E-mail: *********@*****.***
Page 1 of 6
Zorida Boochoon
Brampton, Ontario, Canada, L7A 2Z6
Telephone #: 226-***-****(Mobile), 289-***-****(Home) Email: *********@*****.***
SUMMARY
A skilled, self-motivated Oracle Certified Developer who is involved in all aspects of the Systems Development Life Cycle. Acquired expertise in design and development using SQL, PL/SQL, packages, procedures, functions, triggers, Oracle Developer Forms and Reports, in both a UNIX and Windows environment. Detail oriented, capable of working under pressure and meeting deadlines, being a team player giving all for the success of the team. TECHNICAL SKILLS
Development Tools: SQL *Plus, PL/SQL, Oracle ADF 11g, Oracle Developer Forms and Reports 6i/ 9i/10g/11g, TOAD, Test Track Pro, SVN, PVCS, VSS, CVS, MKS, Oracle Designer, SQL*Loader, Linux and HPUX Shell Scripting, XML, HTML5, JavaScript, jQuery, CSS3, JSON, Pro*C, Appworx Job Scheduler, MS Access database, MS Visio, Microsoft Sharepoint, TicketXpert, Oracle Application Express (APEX) Environments: Databases - Oracle 6, 9i, 10g, 11g, 12c, WebLogic, Operating Systems: Linux, Windows
CERTIFICATIONS
Oracle Certified Professional (OCP) - Oracle Internet Application Developer - Forms
ITIL v2 Foundation Certification
Career Overview
Assessed and cultivated long-term strategic goals for development of application programs in conjunction with end users, managers, clients, and other stakeholders.
Adhered to company standards for Software Change Control Lifecycle which included:
Proposal/Requirements Specification
Design
Development
User Testing/Acceptance
User Training/System Documentation
Implementation
Analyzed user requirements, and based on findings, designed functional specifications for database applications.
Created functional and technical requirements documents and presented to business users.
Created design for table structures, created primary keys, unique keys, and referential integrity constraints.
Utilized business process modeling tools (TOAD, Oracle Designer) for data modeling and mapping.
Observed control principles of Sarbanes-Oxley (SOX) for audit purposes.
Utilized query optimization techniques for performance tuning.
Coordinated and worked with other technical staff to develop and implement relational database applications.
Provided estimates for project tasks.
Developed automated database applications using the applicable database technology.
Worked with project managers to ensure that data entry, retrieval, change and delete functions met business requirements for project completion.
Zorida Boochoon
E-mail: *********@*****.***
Page 2 of 6
Identified inefficiencies in database applications and leveraged solutions.
Diagnosed and resolved database access and performance issues.
Designed and deployed database table structures packages, forms, and reports.
Assisted in planning data migration to new databases during upgrades and participated in the coordination of these migrations.
Assisted with the re-design of redundant systems, policies, and procedures for disaster recovery to ensure effective availability, protection, and integrity of data assets.
Developed and maintained UNIX scripts for application/batch and cron execution.
Documented and trained users on new and modified application modules.
Utilized Reverse Engineer methodology in some cases to understand existing application modules for troubleshooting user-reported problems and for documenting applications.
Ensured that modules have traceable system audit trails and controlled user access.
On-call technical support for issues related to software implementations.
Experience with installing and configuring Oracle Forms/Reports Developer Tool
Knowledge of Oracle Application Express (APEX)
Knowledge and experience with database/performance tuning including creating indexes on tables. Includes code optimization.
Experience with creating users, administering security through granting access to menus using roles.
Knowledge of database backup and recovery.
PROFESSIONAL EXPERIENCE
George Brown College, ON September 2016 – December 2016 160 Kendal Ave,
Toronto, ON M5R 1M3
Position: Systems Analyst - Contract
Applications supported: Higher Education (Sungard Banner HE Version 8.2).
Completed work for upgrade of Banner application to version 8.7 – applying vendor patches.
Modified existing Oracle PL/SQL database packages, adhering to business requirements.
Collaborated with Business Analysts to create functional and technical requirements prior to code development/change for each project.
Conducted analysis on Student data for modification to Transfer Credit report.
Created new database function to determine Transfer Credit Type.
Created Test Plan and Test Scripts for use by Quality Analysts to test new automated implementation for Course Description update.
Utilized PL/SQL database procedures that generate HTML pages for troubleshooting reported issues.
Created functional and technical requirements using MS Visio and related software to identify problems, solution(s) and identify test criteria.
Created and executed test cases for testing development work.
Worked with QA team for conducting analysis and testing.
Completed technical and user documentation on work completed and tested. CMiC Global
Computer Methods International Corp Apr 2016 – Jun 2016 4850 Keele Street,
North York, Ontario, M3J 3K1
Position: Application Developer
Utilized Oracle Forms 11g and PL/SQL for application development.
Developed/maintained PL/SQL packages for back-end processing.
Created/Modified Oracle ADF programs as per requirements.
Developed new and modified existing Oracle Forms and PL/SQL database packages, adhering to business requirements.
Created and executed test cases for testing development work.
Worked with clients for conducting analysis and testing. Created/executed test cases.
Compiled documentation on work completed and tested.
Providing client support for testing and production services based on primary business of Financial, Equipment Maintenance, Inventory and Purchasing Applications. HighJump Software Canada Inc.
Partner - Accellos, Markham, ON Mar 2015 - Feb 2016 Zorida Boochoon
E-mail: *********@*****.***
Page 3 of 6
125 Commerce Valley Drive West, Suite 700
Markham, Ontario L3T 7W4
Position: Support-Developer
Utilized Oracle Forms 11g/10g/9i/6i and PL/SQL for application development.
Developed PL/SQL packages for back-end processing.
Collaborated with Business Analysts to create functional and technical requirements prior to code development/change for each project.
Developed new and modified existing Oracle Forms and PL/SQL database packages, adhering to business requirements.
Created and executed test cases for testing development work.
Worked with clients for conducting analysis and testing. Created/executed test cases.
Completed documentation on work completed and tested.
Implemented code to clients’ testing and production sites
Providing client support for testing and production services based on primary business of Logistics Management.
Wilfrid Laurier University, ON May 2014 – Mar 2015 75 University Avenue West
Waterloo, Ontario, N2L 3C5
Position: Systems Analyst
Utilized Oracle Forms 11g and PL/SQL for application development.
Applications supported: Higher Education (Sungard Banner HE Version 8.2).
Completed work for upgrade of Banner application to version 8.7 – applying vendor patches and release.
Developed PL/SQL packages for back-end processing.
Developed new and modified existing Oracle Forms and PL/SQL database packages, adhering to business requirements.
Collaborated with Business Analysts to create functional and technical requirements prior to code development/change for each project.
Conducted analysis on Alumni data for creating audit trails and correction of data. Utilized PL/SQL packages/procedures and database triggers for implementing solution.
Developed database procedures using HTML code within PL/SQL to generate HTML pages.
Created functional and technical requirements using MS Visio and related software to identify problems, solution(s) and identify test criteria. Presented to Business Users..
Utilized business process modeling tools for data modeling and mapping.
Created and executed test cases for testing development work.
Worked with users for conducting analysis and testing.
Completed documentation on work completed and tested. Home Hardware Stores Ltd., ON May 2011 – May 2014
34 Henry Street West, St. Jacobs
Ontario, N0B 2N0
Position: Programmer/Analyst
Utilized Oracle Forms 11g, Reports 10g and PL/SQL. In development of applications
Applications supported: Manhattan Warehouse Management System and Home Hardware legacy Integrated Logistics Management System.
Developed PL/SQL packages for data conversion.
Utilized principles of ETL – Extract Transform and Load for data migration.
Developing new and modifying existing Oracle Forms, Reports and database packages, adhering to business requirements.
Conducted analysis on Home Hardware applications for impacts based on data interface between the legacy application and Manhattan Warehouse Management System. Modified existing and created new API’s – Application Programming Interfaces between legacy and new application.
Created requirements documents and conducted presentation with business users prior to code development.
Developed database procedures to generate XML files.
Created functional and technical requirements using MS Visio and related software to identify problems, solution(s) and identify test criteria. Presented to Business Users.
Utilized business process modeling tools for data modeling and mapping.
Created and executed unit test cases on code developed.
Utilized Test Track Pro to follow traceability of requirements for change and change flow for work being tested.
Zorida Boochoon
E-mail: *********@*****.***
Page 4 of 6
All projects utilized Test Track Pro as a method to record all defects and work completed to correct the defects for new and updated programs, including PL/SQL Packages, Forms, Reports, Unix Scripts and changes to the Job Scheduler Appworx.
Documented work completed and tested.
Wilfrid Laurier University, ON Dec 2010 – May 2011 75 University Avenue West
Waterloo, Ontario, N2L 3C5
Position: Systems Analyst
Utilized Oracle Forms 10g and PL/SQL for development.
Applications supported: Higher Education (Sungard Banner HE Version 8.2).
Developed PL/SQL packages for back-end processing.
Developed and maintained PL/SQL Procedures for generating HTML pages in conjunction with Identity Access Management for student login to Information Systems.
Developed new and modified existing Oracle Forms and PL/SQL database packages, adhering to business requirements.
Collaborated with Business Analysts to create functional and technical requirements prior to code development/change for each project.
Created functional and technical requirements using MS Visio and related software to identify problems, solution(s) and identify test criteria.
Conducted analysis on Accessible Learning modules, Students Awards and Financial Aid modules for further work with Oracle Forms and PL/SQL.
Created functional and technical requirements using MS Visio and related software to identify problems, solution(s) and identify test criteria. Presented to Business Users.
Utilized business process modeling tools for data modeling and mapping.
Created and executed test cases for testing development work.
Completed documentation on work completed and tested.
Experience with creating database file systems and using import/export utility. Alberta Blue Cross, Edmonton, AB Jan 2009 - Oct 201*-*****-*** St
Edmonton, Alberta T5J 3C5
Position: Systems Analyst
Utilized Oracle Forms and Reports 10g, 11g and PL/SQL for software development and maintenance in the Insurance industry.
Applications supported: Health and Dental claim adjudication and payment.
Developed PL/SQL packages for back-end Financial Rates management, claim adjudication and customer payment.
Developed and modified on-line customer statements.
Worked with Business Analysts to complete requirements on Use Cases.
Interpret and create Data Model diagrams for use in project development.
Created functional and technical requirements documents and presented to business users.
Utilized business process modeling tools for data modeling and mapping.
Created requirements documents and conducted JAD sessions to Business users.
Created and executed unit test cases based on work completed. Accellos, Markham, ON Nov 2008 - Dec 2008
125 Commerce Valley Drive West, Suite 700
Markham, Ontario L3T 7W4
Position: Contractor Software Developer
Utilized Oracle Forms 9i for maintenance and new development for Logistics Management Application. Active Intelligence Inc., Mississauga, ON Sep 2008 - Oct 2008
- Oracle Certified Partner
Position: Consultant Oracle Forms Development
Oracle Retail Merchandising System Forms Customization (Oracle RETEK)
Utilized Oracle Forms, PL/SQL, TOAD and PVCS for the project. Zorida Boochoon
E-mail: *********@*****.***
Page 5 of 6
Leon’s Furniture Limited, North York, ON Jan 2006 - Apr 2008 Position: Oracle Programmer/Analyst
Provided Technical support on the GE Retail System: Sales Order/Maintenance, Inventory Management, Purchasing, Accounts Receivable, Accounts Payable, General Ledger, Marketing, Store Traffic Counter System, and Extended Warranty System.
Designed, developed and deployed new modules as well as maintain existing applications utilizing SQL, PL/SQL, Stored Procedures, Functions, Packages and Triggers, Oracle Forms and Reports. Utilized Oracle Distributed database option to connect to several databases. Used SQL* Loader to load database tables. Created UNIX scripts to execute background processes. Utilized the appropriate Oracle optimizer methods for tuning/performance.
Executed backup scripts to start database backup and retrieved backup media for storage.
Developed an invoicing system for bulk sales. Extracted sales orders data to generate invoices. An interface was developed to link to the AR/GL modules. Created tables, views, synonyms, sequences and indexes. Features included use of SQL, PL/SQL, Oracle Forms and Reports. Used Forms and Reports Templates, Property Classes, Tool Bars, Menus and other Library Objects.
Developed auditing modules using SQL, P/SQL, Oracle Forms and Reports to monitor and control sales and inventory, drastically reducing time, effort and cost involved to capture inconsistencies within the general procedures of the organization.
Developed an Office Supply System using SQL, PL/SQL, Forms and Reports to track distribution and invoice stationery and supplies shipped to 60 stores across Canada. An interface was developed to link this system with the AR/GL modules in the main application. Used OLE objects to facilitate the uploading/downloading of spreadsheets/data files between forms/reports and the network drives on users PCs.
Experience with creating database file systems and using import/export utility. Spar Aerospace Limited, Mississauga, ON Sep 2000 - Jun 2005 Position: Oracle Programmer/Analyst
Technical support for the design and development of Oracle applications to ensure that business objectives were met:
Program Management, Job Tracking/Production Control/ Work Order Maintenance, Shop Floor Data Collection, Work Order Estimation, Receiving/Shipping, Inventory Management, Purchasing, Contracts, Engineering Management, Quality Control, Finance, Human Resources (Time and Attendance).
Worked on team with IT Manager to setup Disaster Recovery Plan and auditing controls according to Sarbanes-Oxley (SOX) laws.
Endured compliance with Completeness, Validity and Identification checks, Authentication and Access Authorization controls, Problem management, Change management controls, Data Integrity Input controls.
Major projects:
Developed a system to analyze shop-floor work performance utilizing SQL, PL/SQL, Oracle Forms and Reports.
Enhanced the Purchasing/Inventory application to include controls compliant with the CGP/ITAR
(Controlled Goods Program (Canada)/International Traffic In Arms Regulation (USA)). Developed modules using SQL, PL/SQL, Stored Procedures, Functions, Triggers, Oracle Forms and Reports. Created database objects such as tables, synonyms, sequences.
Developed modules within the Inventory application to automate processes, otherwise executed manually by users, drastically reducing time and cost. Used PL/SQL, Oracle Forms and Reports. Created UNIX scripts to execute background processes.
Created functional and technical requirements using MS Visio and related software to identify problems, solution(s) and identify test criteria.
Developed user-access controls at the field level of forms in the Discrepancy Notices system. Created controls using Forms Triggers.
Created a Supplier Data Warehouse to analyze vendor activity. Used SQL*Loader to load database tables. Developed user interface using Oracle Forms and Reports. Created UNIX scripts to execute background processes.
Developed system for Auditor inquiry and reporting based on the financial application.
Developed application for conducting Trend Analysis for DND (Department of National Defense) based on work order related statistics.
Created Tracking system for parts received for maintenance. Zorida Boochoon
E-mail: *********@*****.***
Page 6 of 6
Created batch process to auto punch and approve employee labour for employees on vacation
(Time and Attendance system).
Developed notification in the Production Control/Work Order Maintenance system for work order costs approaching the maximum maintenance cost.
Experience with creating database file systems and using import/export utility.
Executed backup scripts to start database backup and retrieved backup media for storage. EDUCATION
Oracle University - Oracle Certified Professional (OCP) - Oracle Internet Application Developer - Forms, Reports, SQL, PL/SQL, Develop Program Units.
Oracle Data Modeling training.
JSP development training
Certificate - ORACLE Database Administration - Learnix Limited, Toronto
Diploma – Advanced Programming, Systems Analysis and Design
- Herzing College, Toronto
Oracle training SQL*Plus, PL/SQL, Forms 11g/10g/9i/8i/6i, Reports 10g
Training – JavaScript, jQuery, HTML5, CSS3, XML, JSON
Humber College – Web Design and Development
Continuous learning – Oracle Database Development 12C, Oracle EBS Applications
Oracle Application Express (APEX)
Project Management, IBM - Toronto
Linux
Contact this candidate