Oracle Developer
Resume:
Thusith S Ekanayake
Houston, TX 77024
********@*****.***
Objective:
To contribute relevant experience and educational background to an Oracle Developer position in the United States.
Work Experience:
• Ajilon Consulting, USA, Oracle Developer 04/2007 – 06/2009
• THEMIS Ltd, Canada, Oracle Developer 09/2006 – 12/2006
• Home Hardware Ltd, Canada, Oracle Developer 09/2004 - 06/2006
• Oracle Corporation, US/CA, Principal Consultant 07/1997 - 07/2004
• SCT Corporation, U.S.A, Programmer/Analyst 09/1994 - 07/1997
Skills Highlight:
Oracle & Other Products:
Oracle 10g, Oracle 9i, Forms 10g, Reports 10g, Forms 6i, Reports 6i,
Data Junction (ETL Tool), Oracle 8.x, Developer/2000 (Forms 5.0, Reports 3.0), Designer/2000 (R2.1.2), Oracle 7.x, Developer/2000(Forms 4.5, Reports 2.5), Designer/2000(R1.3.2), Forms 4.0, SQL, PL/SQL, Access, TOAD
Operating Systems:
Windows XP, Windows 2000, Windows NT, Windows 98, Windows 95, MS-DOS and UNIX
Management/Leadership Skills:
Technical lead for Rhode Island courts project, Project Lead for Cobb County system development
Life Cycle Expertise:
Requirements Analysis, Prototyping, Application Development, Application Customizations, User Acceptance Testing, Implementation, GUI Design
Applications:
Retek, SCT Banner Courts
Project Experience:
04/2007– 06/2009
Senior Oracle Developer
Ajilon Consulting
Client: Sumitomo Corporation – Houston, TX
Involved in the design and the development of Tubular Information Management System (TIMS2) for Sumitomo Global Tubular Solutions (SCGTS). TIMS2 is a proprietary supply chain management (SCM) system designed to manage tubular products and services purchased by leading oil and gas companies. The system is design to handle all aspects of the tubular services business including Purchase Order, Receiver, Forecasts, Quotes, Sales Order, Invoice, Inventory, Fabrication, Transfer, Inspection and Tally along with many other modules.
TIMS2 is an Oracle forms based solution that also provides users with many custom oracle reports to manage their tubular services business.
TIMS2 is developed to replace the existing TIMS application with major enhancements to improve the tubular services business. The project also involved the conversion of the existing system to the new system.
As a leading member of the team, responsibilities included design and development of the major modules using oracle forms, testing, defining application standards, designing the user menu, creating database objects, packages, procedures, database triggers and libraries.
Development Environment: Oracle 10g, PL/SQL, Forms 10g, Reports 10g, SQL Navigator, TOAD, Windows XP
09/2006 – 12/2006
Senior Oracle Developer
THEMIS Program Management Ltd – Canada
Designed and developed reports and forms for the Family Responsibility Office (FRO) to transition from their current model to an Integrated Service Delivery Model (ISDM). Worked with a team of developers and analysts to produce reports and forms to deliver an application that delivered a client centric solution.
Development Environment: Oracle 10g, PL/SQL, Forms 10g, Reports 10g, Windows XP, TOAD, PVCS
09/2004 – 06/2006
Senior Oracle Developer
Home Hardware Ltd – Canada
Member of a team responsible for the design and migration of Legacy and Home Hardware custom retail management system into RETEK. Application was delivered in releases.
• Release one involved development and migration of Organizational Hierarchy, Merchandise Hierarchy, Departments, French Translation, Warehouse, Promotion Zones, Location Stores, Price Zone, Cost Zone, Location Traits, Item Freight, Printer Queues, Vendor Sites, Freight Cost, Supplier, Supplier Attributes, Supplier Expense, Currency, Supplier Inventory Management, Supplier Warehouse, Freight Terms, Supplier Address, Supplier Trait, Supplier Trait Matrix, and AP Terms.
• Release two involved development and migration of Ecology, ACMR, Unit of Measure, Item Master, Item Freight, Item Attributes, Hazard Class, UPC, Simple Packs, Market Retail, Vendor Exceptions, Base Market Retail, Brand Names, Subclass, Supplier Country, Supplier Country Location, Primary Country, Item Expenses, Retail Pricing Strategy, Futures and Complex Packs.
• Release three involved development and migration of Promotion Events, Promotion Head, Buyer, Loss Leaders, Promotion SKU, Unit of Measure, Docket Details, Store Deal Head, Store Deal Details and Store Deal Dates.
Development Environment: RETEK, Oracle 10g, Oracle 9i, PL/SQL, Forms 10g, Reports 9i, Data Junction (ETL Tool), TOAD, Access, Windows 2000
06/2002 – 07/2004
Computer Systems Analyst
Oracle Corporation – Canada
Designed custom enhancements for the Oracle Student System. The requirement to interface with the third party software from Black baud and Degree works was met using custom views and packages.
Team member of an internal Provider Simplification project proposal. Responsibilities on the development included estimates on custom objects such as tables, views, packages, procedures, database triggers, forms and reports.
Development Environment: Oracle 9i, PL/SQL, Forms 9i, Reports 9i, Windows 2000
01/1998 – 04/2002
Principle Consultant - Oracle Corporation
Client: Rhode Island Judicial Technology Center - Providence, RI
Technical lead to implement the custom interfaces for the Rhode Island Judicial Technology Center using ACS Justice Information System (Formerly SCT BANNER) software.
As the technical lead I was responsible for the design and the development of the following Interfaces and Forms.
• Police Interface and Form - This interface receives arrest records from more than thirty police departments at real time and inserts them into a set of custom tables where they can be viewed by courts staff using the Custom Initial Case Filing Form. Each court location has jurisdiction over a set of police departments and the court users are allowed access to only the cases that belong to their jurisdiction through this form. The users are allowed to update any incorrect data and verify the defendant and each party associated with the case in order to determine if they are to be created as new entries. Upon verification users can create a case in BANNER with a click of a button. This will create case, party, charge, bail, agency, person, address, telephone, plea and account information automatically. After creating a case it is deleted from the queue. During the life of a case the updates are sent back to police departments each day. The file transfer process was implemented using FTP and UNIX Scripts.
• Warrants Interface and Form - The warrant interface reports all the warrants issued and quashed by the courts to the state police every three minutes. The Warrants are issued using the Custom Warrants Issuance form. This form allows the users to create warrants the using case id, document type and the judge. All other information is automatically retrieved and inserted, including the docket codes. The quashed warrants are reported separately to the attorney generals office as well. The file transfer process to the AG and the state police was implemented using FTP and UNIX Scripts.
• DCYF (Department of Children Youth and their Families) Interface - This interface provides DCYF with case, party, event, outcome, charge and sentence data on DCYF related cases from the family court. The database triggers written on the appropriate tables will filter the DCYF related cases, since not every case is DCYF related, and insert records into a set of custom tables. DCYF is granted access to these custom tables and views through a database link.
• RONCO (No Contact Order) Interface and Form - This interface provides the Attorney General's office No Contact Order information when issued by the courts through the custom RONCO Notification form. This form allows information to be directly inserted into the AG custom tables through views and a database link. The courts staff is also allowed to update the Expiration Date and the Term of Order through this form.
• Traffic Dispositions and Form - Interface allows the Municipal Courts to submit charge dispositions and fees electronically to the Traffic Tribunal and have them dispose the charges automatically and maintain information on fees associated with the charges. Any errors generated during this process can be viewed using the Custom Municipal Court Error form.
• Custom Monthly Attorney Calendar Form – Upon entering the attorney name, month and year the users are allowed to view the calendar for a given attorney for that month. The form is displayed as an actual calendar. The users can navigate to a given date and find out the events scheduled for that day by a click of a button.
• Other Custom Forms – Custom Criminal Report Parameter Form, Custom Person Warrants Query Form, Custom Person Information Verification Form, Warrant Fix Request Form, Custom Juvenile Report Parameter Form, Juvenile Case Jacket Tracking.
Designed the functional specifications for the Domestic Violence and Victim Information Interface. When implemented this would allow the police departments to electronically submit Domestic Violence cases and allow the courts to maintain a victims database.
In addition to the above interfaces, the following reports were designed for the Criminal Courts and the Family Courts.
• Criminal Reports - Docket Sheet, Event Calendar, Cost Calendar, AG-3, Warrants, Judgment, Pending Cases, Ready Trial and Sentence Registry.
• Juvenile Reports - Face Sheet, Event Calendar, Backings, Capias, Pending Cases, Score Sheet, Habeas and Summons.
Development Environment: Oracle 9i, Oracle 9iAS, Forms 6i, Reports 6i, Developer/2000(R1.6), Forms 4.5, Reports 2.5, Designer/2000, ORACLE 8i, ORACLE 8.0.5, PL/SQL, TOAD,Windows 95, Windows NT, Windows 2000, Citrix and UNIX
12/1997 - 01/1998
Senior Consultant - Oracle Corporation
Client: Boral Bricks, Inc - Augusta, GA
Mentored Forms 4.5 programming and addressed the design issues for the Rail Car Management System. Responsibilities included; developed Forms 4.5 standards checklist, performed code review, recommended and implemented software improvements, conducted peer/regression testing, and developed custom report.
Development Environment: ORACLE Forms 4.5, Reports 2.5, ORACLE 7.3, PL/SQL and Windows 95
07/1997 - 12/1997
Senior Consultant
Oracle Corporation (Internal) - Houston, TX
Developed application software in support of Oracle Health and Safety Applications. Responsibilities included; coding enhancements, fixing software bugs, peer/regression testing, developing customer defined reports, and application software implementation.
Development Environment: ORACLE Forms 4.5, Reports 2.5, ORACLE 7.3, PL/SQL and Windows 95
09/1994 - 07/1997
Programmer/Analyst
SCT Corporation - Lexington, KY
Successfully completed a project developing a new Juvenile courts system for Orange County, CA. Wrote technical specifications to meet the requirements of the functional specifications and ensured that the new system stays within the scope of the BANNER baseline system. Responsibilities include analysis, coding, creating tables, peer testing and systems testing. Used ORACLE Developer 2000, ORACLE 7.3, PL/SQL, Windows 95 and UNIX to implement the system and Pro C to write reports.
Responsible for overseeing the conversion of BANNER 2.1.5 release from Forms 4.0 to Forms 4.5 and instructed the beginning programmers on the conversion to follow BANNER standards. Also involved in correcting the problems that emerged due to the conversion.
Responsible for writing the technical specifications for Random Judge Assignment and Case Priorities Within a Calendar for Cobb County, GA. Responsibilities also include coding, testing, creating tables and documentation. Used ORACLE 7.3, Forms 4.0, PL/SQL, Windows 95, Pro C and UNIX for the custom modification.
Responsible for analysis, design, coding and error correction of BANNER 2.1.5 court system. Designed logic to meet BANNER standards and specifications. Made changes to already existing programs to comply with the standards. Prepared data and tested software with them and made changes to programs if there were any errors. Documented systems and programs according to standards. Developed new forms to enable work flow rules for BANNER 2.1.9 and did modifications to other relevant forms to work with the new forms.
Development Environment: ORACLE version 7.3, Developer 2000, Forms 4.0, Forms 4.5, PL/SQL, Windows 95, Pro C, UNIX
Education:
Bachelor of Science, Computer Science, University of Kentucky, Lexington 1994
Oracle Education & Training:
Oracle 9iAS Portal: Build Corporate Portals and Portlets
Oracle 8i Database Administration and Architecture
Data Warehousing Fundamentals/Data Warehouse Database Design
Develop Applications with Business Components for Java
Developer 2000/R6 Build Reports
Deploy Web-Based Applications using PL/SQL
Designer 2000 /R2.1.2 Forms Generation
Java for Oracle Developers
Echo 2000/Configuration Management using Echo 2000
Designer 2000/Design and Build Applications
Developer 2000/Forms II
Designer 2000/Design and Build Database Objects
Developing Applications using Oracle Forms 4.5
Developing Applications using Oracle Forms 4.0
Building Complex Application using Procedural Language (PL/SQL)
Database Administration: Oracle 7.x RDBMS
Computer Based Training:
Developer 2000(Reports 2.5) Data Model Design
Developer 2000(Reports 2.5) Design & Development
Developer 2000(Reports 2.5) Format Control
Miscellaneous:
Consultant of the quarter, Oracle Corporation North East, January, 1998
Consultant of the quarter, Oracle Corporation North East, January, 1999
References:
Available Upon Request
Contact this candidate