Professional Summary

• Over 10 years of experience in Analysis, Design, Development of Oracle Applications environment R12/11i/10.7/10.6
• Excellent command over SQL, PL/SQL Packages, Procedures and Functions
• Proficient in Oracle Developer 10g, Oracle Reports 6i, Oracle Forms 6i
• Experience with Business Analysis, Business Modeling, Process Modeling, Function Modeling, ERD, System Design, Custom Development Methods and Application Implementation Methods
• Extensive experience in data mapping of Oracle Functionality with Business requirements, Reports, Interfaces, Conversions, Customizations, Design and development of RICE objects

• ERP: Oracle Applications R12, 11i (11.5.10.2, 11.5.9, 11.5.7, 11.5.5, 11.5.4), 11.0.3, 10.7, 10.6
• Applications Modules: Oracle General Ledger, Accounts Receivables, Accounts Payables, Oracle Order Management, Oracle Shipping, Oracle Inventory, AOL, Oracle Purchasing, Work in Process, Bills of Material, e-Commerce Gateway (EDI) and WEB ADI
• Databases: Oracle 7.x, 8.x, 8i, 9i, 10g, 11g
• Development Tools: Oracle Developer 10g, Oracle Developer 6i, Oracle Designer, Erwin 3.5.2, SQL Loader, Oracle Discoverer 4.1, TOAD 7.6, Taviz Integration Studio 3, INOVIS Mapping Workbench 6.0 and INOVIS Operations Center Client 6.0.2, Oracle Workflow Builder 2.6.3.5, Crystal Reports
• Languages: SQL, PL/SQL, Visual Basic
• Methodologies: Oracle Applications Implementation Methodology (AIM), Data Modeling, ERD and Relational Database Design, Merant Version Manager
• Web Development: JavaScript, ASP, HTML, XML Publisher

Certifications

• Oracle Certified Application Developer, Oracle Developer Rel.2
• Oracle Internet Application Developer, Oracle Forms Developer Rel. 6/6i
• Oracle Applications Training (Manufacturing and Financial)
• University of Toronto Oracle 8i Developer Professional Certificate
• S & Q Mart Certificate ISO 9000 Internal Auditing Course
• S & Q Mart Certificate of Participation ISO 9000 Documentation Course

• B.Sc. Industrial Engineering

Work Experience

Confidential- Milton 8/11 - 9/12
Technical Consultant, R12 Upgrade Project
Order Management (OM)

• Created new WEB ADI template for updating item attributes and item cost. Used Item API's
• Modified SOA reports for R12 tax changes
• Modified custom libraries, fixed validation problems
• Compiled 11i reports/forms for R12.
• Improved the performance of Kaycan Bill of Lading (XML) report
• Modified the query to improve the performance of AA01 KP WISL - Order Download interface
• Modified some XML Publisher reports for new layout
• Validated order import interface for EDI order, KP wanted to be sure that price sent by customer equals price returned

Accounts Receivables (AR)

• Modified invoices for R12 tax changes
• Modified Kaycan - Manual Invoice Log custom form and reports for RMA
• Provided technical support for daily production problems
• Migrated OAF form personalization to PREP and PROD instances

Application Object Library (AOL)

• Maintained concurrent managers to decrease pending processes. New workshift and program type used
• Provided documentation using AIM

Work in Process (WIP)

• Created KBP Paint Usage Detail, KBP Monthly Product Usage and KBP - Scrap Production
• XML publisher reports for manufacturing. Used MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTION_LOT_NUMBERS, WIP_DISCRETE_JOBS, BOM_DEPARTMENTS_V, BOM_DEPARTMENT_RESOURCES_V, BOM_RESOURCES_V views and tables
• Created new PL/SQL function to get shift numbers

Confidential - Mississauga 3/11 - 7/11
Technical Consultant
Accounts Receivables (AR)

• Created new Customer Account Statement template
• Combined Monthly, One Time and RMA invoices to one report file.
• Created Tracking: Aging - 4 Buckets Report (Delimited) report
• Converted 10.7 report files to 11i
• Provided technical support for daily production problems

Purchasing (PO)

• Created Tracking: Printed Purchase Order XML Publisher report

Depot Repair (CSD)

• Created Depot Repair Analysis (Summary) XML Publisher report
• Created RMA Label for SATO CL408e warehouse printer. Submitted this program from Repair Orders form using form personalization.
• Created Tracking: Service Request Summary XML Publisher report

Confidential - Canada 11/10 - 2/11
Technical Consultant/Vendor Customization Project - Confidential, Toronto
Accounts Payable (AP)

• Modified existing 3WAY custom reports to generate output as delimited and printable format
• Created duplicate invoice report
• Modified Custom Factor, Vendor Site and Dept/Mfg forms
• Modified custom library for Vendor Site Form, fixed validation problems
• Created new responsibilities and menus for custom forms
• Solved trigger problems
• Created Messaging Gateway package to send messages using Oracle Advanced Queue
• Provided technical support for daily production problems

Oracle Workflow (WF)

• Solved PO Confirm Receipt (PORCPT) process daily problems

Confidential- Milton 9/08 - 8/10
Technical Consultant
Order Management (OM)

• Created custom price breaks by item category form. Added new function to QP_CUSTOM package
• Created new KP - Monthly Home Depot Sales by Market XML report using XML Publisher
• Modified Sales Order Acknowledgement Report, added Order and Header level attachments to report layout (PDF and Character versions)
• Modified custom libraries, fixed validation problems
• Added new sales order total verification to EDI 850 Price Comparison and Item Number Verification interface and added new section to current Oracle Report.
• Improved the performance of Enter Weekly Pick Slip Internal Number custom form
• Modified Cumulative Internal Requisition Weight and Volume form's LOV using Form Personalization
• Provided technical support for daily production problems

Oracle Workflow (WF)

• Added new process to Order Flow - Generic Workflow (OEOH) to send notification to branches if the order is an EDI order
• Modified Minimum Price List Workflow Package
• Created "Order Flow - Kaycan - External Shipping One Shot Deal With Header Level Invoicing" process in OM Order Header (OEOH) workflow definition
• Created "OM Order Line OEOL, Created Line Flow - Generic with Wait for Approval and Header Level Invoice Interface" process in OM Order Line (OEOL) workflow definition file

Accounts Receivables (AR)

• Modified MLS function and report where clause for EDI invoices
• Modified AR Statement, fixed layout problems for US and FRC versions

Confidential - Mississauga 11/07 - 9/08
Technical Consultant
Accounts Receivables (AR)

• Created Payment Entries forms for CCSA and Non CCSA Customers payment
• Created an interface program for Lockbox process. This process creates cash receipts which prevented manual reconciliations from being done prior to payment application
• Created Approval form to automate adjustment approval process
• Created an interface for Auto-invoice process. This interface creates debit and credit memos for after adjustments have been approved
• Created payment reconciliation report, Subs Count Update and Adjustments Approval reports
• Created an interface program to automatically update the Price List Lines after approval adjustments
• Setup Lockbox and Autoinvoice process
• Provided technical support for daily production problems

Confidential - Montreal 6/06 - 8/07
Technical Consultant
e-Commerce Gateway (EDI)

• Tested 810, 856, 864 and 870 mappings for Menard and Home Depot

Order Management (OM)

• Modified the custom package to update customer minimum statement amount in the AR_CUSTOMER_PROFILE_AMOUNTS table after submitting AR Customer Print Statement
• Created an interface to update GROUP_CODE for unique Destination Org ID and Item Source Category ID in the PO_REQUISITIONS_INTERFACE_ALL table
• Modified Kaycan - Nightly Update of Item Sales History package to add legacy sales data. This package runs every night to populate some attributes in the MTL_SYSTEM_ITEMS_B table
• Developed many reports like Kaycan - Payables Account Analysis Report, Kaycan Account Analysis Report, Kaycan Account Payables Details Report, Kaycan - Freight Account Analysis Report, Kaycan - Print New Invoices, Kaycan - Reprint Invoices
• Created new MLS package to run the Reprint Invoices Report for both FRC and US versions
• Added some functionality to Oracle Forms using custom.pll. Modified custom libraries
• Created some reports for manufacturing like KBP - Paint Usage - Detail, KBP - Monthly Product Usage - Paint, KBP - Scrap Production
• Performance improved for some reports like AR - Kaycan - Customer Hot List, INV - Kaycan - Receiving Transactions Register, OM - Kaycan - Transaction Register. Updated the report query and used lexical parameters for improving performance
• Modified minimum price list package for Workflow Process
• Created item matrix report using XML publisher
• Provided technical support for daily production problems

Confidential - Montreal 10/05 - 4/06
Technical Consultant e-Commerce Gateway (EDI)

• Created INOVIS mapping which reads from EDI 856 Advance Shipping Notice. Created PL/SQL Package to populate staging table for Ship Confirm Process

Order Management (OM)

• Added validation to custom Replenishment Entry and Maintenance Forms. Modified the forms for performance enhancements
• Created a concurrent program to update OE_HEADER_IFACE_ALL and OE_LINES_IFACE_ALL interface table for EDI Purchase order Reimport process

Confidential- Markham6/05 - 9/05
Technical Consultant
Irving Oil Project - Confidential (7/05 - 9/05)
General Ledger (GL)

• Created daily and monthly GL interface using Confidential Studio. Modified the existing Canada interfaces for US interfaces. Template used XML source file to populate GL_INTERFACE table. This program calls the Journal Import program after loading interface table

Accounts Payable (AP)

• Created an AP interface programs using Taviz Integration Studio. Template used XML source file to populate AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables. This program calls the Payables Open Interface Import program after loading interface tables

Confidential - Toronto (6/05 - 7/05)
General Ledger (GL)

• Created technical design for GL closing balances (Year 2005) sourced from GEAC GL, once cleansed will have to be mapped onto the new Oracle COA from the existing COA through translation tables.
• Successfully translated 2005 monthly historical balances data will then be moved to Oracle GL_INTERFACE table.

Fixed Assets (FI)

• Created technical design for Fixed Assets balance conversion. Opening assets for all the legal entities converted from GEAC Assets to Oracle Fixed Assets through the FA_MASS_ADDITIONS Interface Table.

Oracle Inventory (INV)

• Created technical design for item conversion. Used standard Inventory Application Program Interfaces supplied by Oracle. Used MTL_SYSTEM_ITEMS_INTERFACE, MTL_ITEM_CATEGORIES_INTERFACE and MTL_UOM_CONVERSIONS tables

Accounts Payables (AP)

• Created technical design for Supplier Conversion. Rogers wanted supplier sites and contacts to be programmatically loaded for both purchasing and payables. Source data provided as Microsoft Excel file. Used PO_VENDORS, PO_VENDOR_SITES_ALL and PO_VENDOR_CONTACTS tables

Human Resources (HR)

• Created technical design for Employee Conversion. Employee information from PeopleSoft will be converted into Oracle HR application tables. Used HR_EMPLOYEE_API.CREATE_EMPLOYEE, HR_PERSON_ADDRESS_API. CREATE_PERSON_ADDRESS, HR_ASSIGNMENT_API.UPDATE_EMP_ASG and HR_SIT_API.CREATE_SIT API's

Confidential - Canada/MDS CBS Project - Toronto-Ottawa8/04 - 3/05
Technical Consultant
Order Management (OM)

• Extended the Shipping Transaction Form using Custom.pll. Updated shipped quantity field for specific item in the form and used OE_ORDER_PUB.PROCESS_ORDER API to update shipped quantity column in the OE_ORDER_LINES_ALL table

Shipping Execution (WSH)

• Developed a report to provide users with a list of packages and corresponding information. The report provided the final delivery destination for multiple trips. Used WSH_DELIVERY_ASSIGNMENTS, WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS, WSH_TRIP_STOPS, WSH_TRIPS and WSH_DELIVERY_DETAILS tables

Work in Process (WIP)

• Developed a Finished Parts Transfer and Production Control Report to provide a hard copy of the job description upon which the user can document performance of tasks and record relevant data.
• Developed a request set including the "Finished Parts Transfer and Production Control Report" and Discrete Job Routing Sheet Report. Used WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_OPERATIONS, BOM_DEPARTMENTS, MTL_SYSTEM_ITEMS, BOM_RESOURCES and WIP_OPERATION_RESOURCES tables

e-Commerce Gateway (EDI)

• Developed interface programs to provide the Trading Partner with an automatic rejection of the purchase order via the EDI 855 Purchase Order Acknowledgment transaction. Electronic purchase order rejects acknowledgments generated by this interface when the order is rejected either in the e-Commerce Gateway, or during the Order Import process.
• Developed interface programs to provide the Trading Partner with an automatic rejection of the purchase order change via the EDI 865 Purchase Order Change Acknowledgment transaction. Electronic purchase order change reject acknowledgments generated by this interface when the order change is rejected either in the e-Commerce Gateway, or during the Order Import process

Install Base (CSI)

• Developed interface programs to provide flat file for Cobalt Management Program (CMP). CMP needed to see all records for the Product Irradiator item in order to get customer and address per serial number.
• Created a script to send the flat file via FTP. Created a request set for Cobalt Management Program and Cobalt Management FTP
• Created a SQL Loader script to populate Cobalt Address table from flat file

Confidential - Canada (Pacific Development Center) - Vancouver 2/04 - 5/04
Technical Consultant
General Ledger (GL)

• ADVO required all employees'travel/entertainment expenses be posted to Oracle General Ledger on monthly basis.
• Developed PL/SQL Concurrent Program to translate from flat file and load into GL_INTERFACE table using UTL_FILE
• Developed technical details and construction workbook documentations

Accounts Receivables (AR)

• Designed and developed File Extract concurrent program needed to provide data to ADVO's internal/external auditors. The data was composed of product and invoice information and was extracted from Install Base, Inventory, Receivables and Custom tables
• ADVO required to convert all open transactions (invoices, credit memos and debit memos) and receipts (On Account and Unapplied) from Oracle 10.7 Accounts Receivable to 11i. Created conversion program to populate staging table, RA_INTERFACE_LINES_ALL and RA_INTERFACE_SALESCREDITS_ALL tables
• Converted the conversion to an interface which populates RA_INTERFACE_LINES_ALL and RA_INTERFACE_SALESCREDITS_ALL tables
• Developed a report which has the ability to produce outputs in two formats: one in Bottomline Format and the other in Printable format.
• Developed a concurrent program which transfers the Bottomline format to the Check Printing PC using the MQ Hub.
• Created a request set for Printable and Bottomline format. Updated AR_CUSTOMER_CALLS and AR_CUSTOMER_CALL_TOPICS tables

Accounts Payables (AP)

• Customized 11i Payables Account Analysis report into the AP Expense Detail Report. Modified the query and layout.

Confidential - Detroit, MI/Windsor, Ont. 9/02 - 11/03
Technical Consultant
General Ledger (GL)

• Transferred GL Account Balances from legacy system. Developed a control file to load account balance from CSV file into staging tables using SQL/Loader then validated data and written customized program to insert data into the GL_INTERFACE table using PL/SQL
• Designed and Developed Custom Accounts Enquiry form to show the details of the accounts. This form is based on a view one can query on a given account but not update or insert through this form
• Designed and developed Summary Budget Analysis, Central General Operating Fund Balance, Details Changes in Fund Balance, Capital Expenditure and Variances reports
• Developed technical details and technical overview documentations

Accounts Receivables (AR)

• Developed a control file to load Customer information from flat file into interim tables using SQL/Loader then validated data and written customized program to insert data into the interface table using PL/SQL

Application Object Library (AOL)

• Defined concurrent program assigned to request groups
• Created and register Tables in Oracle Application

Confidential - Windsor 9/01 - 8/02
Technical Consultant - Alabama University (5/02 - 8/02)
General Ledger (GL)

• Using GL Worked on Journal Import program to import data from legacy system into Oracle Applications. Used PL/SQL for validating the data from legacy system to interface tables. Run journal import to load the data into Oracle application tables GL_JE_BATCHES, GL_JE_HEADERS and GL_JE_LINES
• Developed a custom form to create, update and view attribute information for the Account String using the Descriptive Flex Fields. Integrated the form with Oracle General Ledger
• Developed the Patient Service Revenue Report using Oracle Reports 6i
• Customized reports using Report Builder 6i
• Worked as a data conversion team member for migrating data using SQL/Loader and PL/SQL

Application Object Library (AOL)

• Defined Concurrent Program and assigned to the corresponding request group in the Oracle Applications
• Defined concurrent program and executables for custom PL/SQL programs and reports
• Registered several customized forms by running the AD scripts and integrated them with Application using AOL

Technical Consultant - Confidential (9/01 - 3/02)
General Ledger (GL)

• Developed interface programs to load journal transactions, which were maintained in existing legacy system to Oracle General Ledger system tables. Interim Tables created to hold the data from the flat file and validations
• Validated data in the interim tables before moving data into interface table (GL_INTERFACE)
• Load the valid data from interface tables to Oracle General Ledger system tables (GL_JE_HEADER, GL_JE_LINES)

Account Receivables (AR)

• Migrated the data from Oracle Applications 10.7 to Oracle Applications 11i using Customer Open Interface
• Move the validated data from the interim table to different interface tables
• RA_CUSTOMERS_INTERFACE_ALL, RA_CUSTOMER_PROFILES_INT_ALL
• RA_CONTACT_PHONES_INT_ALL, RA_CUSTOMER_BANKS_INT_ALL

Confidential - Toronto 5/01 - 7/01
DBA / Programmer (Contract)

• Worked in a team environment as an Oracle DBA and Developer 2000 Programmer
• Created and maintained new databases for web channel

Confidential - Toronto 1/01 - 3/01
Database Application Developer (Co-Op)

• Managed and administered Oracle database for Computer Parts Distribution Company
• Developed a financial and sales reporting system using Oracle Developer 2000

Confidential - Turkey 2/97 - 2/00
System Analyst / Programmer

• Developed a custom Manufacturing and Order Entry System for a leading Printing Company
• Developed forms, reports and database packages and procedures using Forms 4.5, Reports 2.5
• Customized Reports using Reports 2.5 and SQL*Reports
• Writing PL\\SQL Scripts such as Packages, Procedures and Functions
• Leader of the Quality Circle Group; decreased 1% of total paper waste (total value $200,000)

Project: Worked on full life cycle of the Project. Responsible for Business Analysis, Function Analysis, ERD Modeling, Module Design, Module Data Diagrams, Database Design, Generation and Customization of Forms and Reports for Pricing, Newspaper Distribution System, Daily Production System and Sales Reporting System using Designer/2000 and Developer/2000

Confidential - Turkey 2/96 - 2/97
System Analyst / Programmer

• Supported existing Oracle Applications 10.6
• Responsible for trouble shooting, maintenance and enhancements
• Created a report for product and customer mailing label
• Created users and gave privileges in Novell. Setup of automatic backup system

Confidential - Turkey 1/95 - 2/96
Planning Engineer

• Selected, purchased and implemented an MRP System
• Supported the purchase and budget department in preparation of 3-month budgets
• Developed program to get material production needs in seconds. Before they were using Lotus 123 tables to combine the data. They were taking 2 days to prepare purchasing amounts. Prevented company loss.