Milorad Marjanovic

416-***-****

adho8g@r.postjobfree.com

https://www.linkedin.com/in/milorad-marjanovic-19926014

SUMMARY OF QUALIFICATIONS

20+ years of experience with Oracle:

20+ Years Oracle Database (Releases 6, 7, 8, 8i, 9i, 10g, 11g, 12c)

20+ Years Oracle SQL, PL/SQL, Pro*C, Pro*Cobol, SQL*Plus, SQL*Loader, Stored Procedures, Functions, Packages, Database Triggers, SQL Scripts, SQL Tuning

10+ Years Oracle Forms, Oracle Reports (Releases 4, 4.5, 5, 6, 6i, 9i, 10g)

3+ Years Oracle Designer (Releases 2, 6, 6i, 9i)

3+ Year Oracle APEX (Oracle Application Express) (Releases 5, 18, 20)

10+ Years Oracle SQL Developer, TOAD

5+ Years Oracle e-BS (e-Business Suite) (Oracle Applications) (Release 11.5.10.2)

3+ Years Oracle Financials (Accounts Payable AP, Accounts Receivable AR, General Ledger GL), Order Management (OM), Transportation Management, Shipping, Warehouse Management

10+ Years Data Migration, Data Conversion, ETL, DW, ERM, Logical and Physical Database Design

3+ Years Java Integration

5+ Years Microsoft SQL Server, Microsoft Access

2+ Years Ellucian Banner Student

1+ Year Perl, COBOL, C, MySQL, JIRA, Cayenta UMS, SharePoint, Confluence.

20+ years of experience with Leading Financial, Insurance and Technological Companies:

ACCENTURE

ALBERTA BLUE CROSS

ALLIANZ Insurance

BMO (Bank of Montreal)

BNS (Bank of Nova Scotia)

GEORGE BROWN COLLEGE

HBC (The Hudson’s Bay Company)

HUMBER COLLEGE

IBM

INDUSTRY CANADA

MANULIFE Financial

MDS NORDION

MINISTRY OF NATURAL RESOURCES

NORTEL

OHN (Ontario Hydro Nuclear)

OMERS (Ontario Municipal Employees Retirement Board)

OPG (Ontario Power Generation) (New Horizon System Solutions)

PWGSC (Public Works and Government Services Canada)

RBC (Royal Bank of Canada)

STRATOS

SWISS RE Insurance

EDUCATION

GRADUATE SOFTWARE ENGINEER

B.Sc. in Software Engineering

University of Zagreb, Computers Department, Software Section, 5 years,

Zagreb, Croatia, Yugoslavia.

PROFESSIONAL EXPERIENCE

Oracle Developer

PUG - Peterborough Utilities Group

Peterborough, Ontario, Canada

June 2019 – June 2020

Cayenta Utilities Support

Project Objective: Provide technical support to Electrical and Water Utility services in their transition to Hydro 1.

Developed and maintained various APEX applications, pages and processes.

Developed and maintained various SQL and PL/SQL programs and queries.

Developed and maintained various daily, weekly and monthly reports.

Executed Data Import and Data Export procedures.

Created Design Documents and Build Documents.

Performed Unit test

Agile methodology. Participated in daily and weekly meetings with business and technical teams.

Worked directly with business teams to gather business requirements.

Worked on multiple project at the same time.

Cayenta is highly configurable revenue management services and software for regulated and deregulated municipal and cooperative public utilities.

Environment: Oracle 11g, Oracle APEX 20, PL/SQL, SQL, SQL Developer, Cayenta UMS, Unix.

Oracle PL/SQL Database Developer

BMO Corporate Cards

Toronto, Ontario, Canada

August 2018 – July 2019

MasterCard TSYS Conversion

Project Objective: Convert large number of old Oracle Forms modules and PL/SQL Stored Procedures and Packages to new Oracle Apex system to support TSYS (Total System Service) credit card processor.

Develop, troubleshoot, test and tune Oracle APEX applications, PL/SQL stored procedures and packages.

Develop various Apex pages with reports, forms, calendars, validations and processes.

Develop Perl scripts for text file processing.

Develop Unix/Linux shell scripts for job scheduling.

Master card CDF3 file format.

Created Design Documents and Build Documents.

Worked directly with business and technical teams in Canada and abroad.

Environment: Linux, Oracle 12c, Oracle APEX 18, Oracle Forms 10g, PL/SQL, SQL, Oracle SQL Developer, XML, MasterCard CDF3 file format.

Data Analyst

TELUS Health

Toronto, Ontario, Canada

June 2018 – Mar 2019

EMR (Electronic Medical Records) to PSS (Practice Solution System) Conversion

Project Objective: Convert EMR (Electronic Medical Records) from various medical offices to Telus Health PSS (Practice Solution System)

Uploaded medical records from various medical offices to Telus virtual test servers.

Performed cleaning, mapping and conversion of data in different text file formats.

Executed Data Import and Data Extract procedures.

Performed Unit test, UA test

Created Design Documents and Build Documents.

Environment: MS Windows Server 2008, Oracle 12c, SQL, PL/SQL, XML, MapForce, Bomgar, SalesForce, Jira, Confluence.

PL/SQL Developer System Analyst

Scotiabank

Toronto, Ontario, Canada

September 2016 – Mar 2018

Enterprise Risk Management System Support (ERMS)

Scotiabank currently uses Moody’s Risk Analyst (RA) and Risk Origin (RO) to analyze the financial statements of borrowers and determine the bank’s internal Credit Risk Ratings for those borrowers in order to achieve an “Advanced Internal Ratings Based (AIRB)” status.

Design, build, test, debug and deploy Oracle APEX Applications and PL/SQL Stored Procedures and Packages.

Develop various Apex pages with reports, forms, calendars, validations and processes.

Develop MS SQL Server queries.

Design, build, test, debug and deploy Unix Shell Scripts to Automate Data Extracts.

Execute Data Extracts PL/SQL Packages and Generate Risk Data Extracts.

Develop and Automate Data Extracts for Scotiabank branches in Canada, Chile, Mexico and Peru.

Unit test, QA tests, UA test

Production Support, Technical Support.

Create Design Documents and Build Documents.

Worked directly with business and technical team in Canada, Chile, Mexico and Peru.

Technical environment: Oracle 12c, Oracle APEX 5, SQL Server, PL/SQL, SQL, SQL Developer, Moody’s Risk Analyst (RA), Moody’s Risk Origin (RO), Microsoft SQL Server.

Oracle Developer/System Analyst

George Brown College

Toronto, Ontario, Canada

April 2016 – Jul 2016

Ellucian Banner support

Project Objective: Implement various George brown Customizations to Ellucian Banner Student system.

Custom modify Ellucian Banner Student modules.

Design, Build, Test, Debug and Deploy Oracle Forms, Oracle Reports and Oracle PL/SQL Packages.

Develop COMMS (Course Outline Mapping and Management System) Report.

Develop CAAT Full-Time Academic SWF Data Collection Report.

Unit tests, Technical Support.

Technical environment: MS Windows 7, UNIX, Oracle 11g, Oracle Forms, Oracle Reports, SQL*Plus, SQL, PL/SQL, TOAD, Ellucian Banner Student, JIRA,

Oracle Developer/System Analyst

Humber College

Toronto, Ontario, Canada

August 2015 – March 2016

Ellucian Banner Student upgrade

Project Objective: Implement various Humber Customizations to Ellucian Banner Student system.

Custom modify Ellucian Banner Student Registration System.

Design, Build, Modify and Test Oracle Forms, Oracle PL/SQL packages, UNIX shell scripts.

Unit tests, Production Support.

Utilized Agile, iterative approach to software delivery that builds software incrementally from the start of the project, instead of trying to deliver it all at once near the end

Technical environment: MS Windows 7, UNIX, Oracle 11g, Oracle Forms, SQL Developer, SQL*Plus, SQL, PL/SQL, Ellucian Banner Student, JIRA.

Test Automation Developer/Team Lead

TD Bank – Wealth Management

Toronto, Ontario, Canada

January 2015 - July 2015

UCID – Unique Canadian ID Project

Project Objective: Implement TD Wealth data elements into a newly built MDM v11.3 instance.

Design, build, test and debug Oracle PL/SQL Scripts, SQL Server scripts, Test Scripts for QA Test Automation.

Prepare Test Strategy and Test Cases documents.

Lead a team of PL/SQL Developers.

Technical environment: MS Windows 7, UNIX, Oracle 11g, SQL Developer, SQL*Plus, SQL, PL/SQL, Microsoft SQL Server, MySQL.

PL/SQL Developer, Design and Development Lead

Alberta Blue Cross

Toronto, Ontario, Canada

February 2013 – January 2015

OSL - Online Sales Project

Project Objective: To design and develop secure online application site.

Design and Build Oracle PL/SQL Scripts, Test Scripts, UNIX Shell Scripts, SQL Tuning Scripts.

Design and Build Database Objects, Stored PL/SQL packages.

Enhanced Logical Database Model and Physical Database Model.

Participated in integration with Java front-end. Coordinated with Java team.

End User Support.

Provides an environment which facilitates the transmission of sensitive information between the client and their sales representative during the varying stages of the sales process.

Technical environment: Unix, MS Windows 7, Oracle 11g, Oracle Designer, Oracle Forms, Oracle Reports, Oracle SQL Developer, SQL*Plus, SQL, PL/SQL, Java.

Oracle Developer

Softchoice

Toronto, Ontario, Canada

February 2012 – September 2012

Corona Project

Designed and developed PL/SQL program units, SQL Tuning Scripts, Test Scripts, SQL Tuning.

Designed and developed PL/SQL packages to support Purchase Order generation and Sales Order generation.

Designed and developed PL/SQL interfaces between Corona and Oracle Financials, Accounts Receivable and Accounts Payables.

Enhanced Conceptual and Physical Database Model (ER Model).

End user Support.

Project Objective: To implement new CRM system. Purchase Order, Sales Order, Quote, Accounts Payable, Accounts Receivable.

Softchoice’s legacy CRM system (Triton) is based on Oracle database at back end and Oracle Forms screens at front end.

Softchoice’s new CRM system (Corona) is based on Oracle database at back end and .NET screens at front end.

Utilized Agile, iterative approach to software delivery that builds software incrementally from the start of the project, instead of trying to deliver it all at once near the end

Technical environment: Unix, MS Windows, Oracle 11g, Oracle eBS (e-Business Suite) (Oracle Applications 11i) (11.5.10.2) (A/R, A/P, GL), Oracle Developer 6i, Forms and Reports, Oracle OEM, SQL*Plus, SQL, PL/SQL, TOAD, XML.

Oracle eBS (e-Business Suite) (Oracle Applications 11i) Developer

PepsiCo Canada

Toronto, Ontario, Canada

September 2011 – January 2012

Frito Lay Canada Project

Project Objective: To implement various Customizations to Oracle E-Business Suite (RICE Elements - Reports, Interfaces, Conversion and Extensions).

Designed and developed Custom Extensions.

Designed and developed custom Oracle Developer Forms and PL/SQL Packages.

Designed and developed Oracle PL/SQL Scripts and Unix Shell Scripts.

Used Oracle E-Business Suite API (Application Programming Interfaces).

Technical environment: Unix, MS Windows XP, Oracle 11g, Oracle eBS (e-Business Suite) (Oracle Applications 11i) (11.5.10.2), Oracle Developer 6i, Forms and Reports, SQL*Plus, SQL*Loader, SQL, PL/SQL, TOAD.

Database Developer/System Analyst

SCOR Life Insurance

Toronto, Ontario, Canada

May 2011 – July 2011

Sylvie Project

Project Objective: To convert existing system to new system.

Data Migration and Conversion.

Designed, developed and maintained load scripts.

Converted large number of Life Insurance Policies, Transactions and Reference Data.

Implemented, tested and documented code.

Designed and developed Oracle PL/SQL Scripts and Unix Shell Scripts.

End User Support.

Technical environment: Unix, MS Windows XP, Oracle 11g, Oracle Developer Suite 11g, MS Access, SQL*Loader, SQL*Plus, SQL, PL/SQL, TOAD.

Oracle Developer

Bank of Montreal

Toronto, Ontario, Canada

May 2010 – May 2011

Vanguard Project

Vanguard is a new product on the InvestorLine platform that fills the gap between direct investing and the full service brokerage by offering an online advisory service supported by registered Investment Specialists.

Based on existing RIS system (Retail Investment System) and current market data.

Project Objective: To implement new system.

Designed and developed custom Oracle Developer Forms, Reports and PL/SQL Packages.

Designed and developed Unix Shell Scripts.

End user Support.

Technical environment: Unix, MS Windows XP, Oracle 10g, Oracle Developer Suite 10g, SQL*Plus, SQL, PL/SQL, TOAD.

Oracle Developer

Shoppers Drug Mart

Toronto, Ontario, Canada

February 10 – April 2010

CPMS Project (Central Product Marketing System)

CPMS is product management system. It manages Products, Stores, Prices, Costs, Vendors, Distribution and Promotions.

Project Objective: To implement various enhancements and convert transactions and reference data.

Designed, developed and unit tested Oracle PL/SQL Packages.

Designed and developed Unix Shell Scripts.

Technical environment: Unix, MS Windows XP, Oracle, SQL*Plus, SQL, PL/SQL, TOAD.

Oracle Developer

Bank of Montreal

Toronto, Ontario, Canada

October 2009 – February 2010

Vanguard Project

Vanguard is a new product on the InvestorLine platform that fills the gap between direct investing and the full service brokerage by offering an online advisory service supported by registered Investment Specialists.

Based on existing RIS system (Retail Investment System) and current market data.

Project Objective: To implement new system.

Designed and developed custom Oracle Developer Forms, Reports and PL/SQL Packages.

Designed and developed Unix Shell Scripts.

Technical environment: Unix, MS Windows XP, Oracle 10g, Oracle Developer Suite 10g, SQL*Plus, SQL, PL/SQL, TOAD.

Oracle Developer

Canadian Scholarship Trust

Toronto, Ontario, Canada

June 2009 – September 2009

ETL Project

Project Objective: To convert and clean existing legacy data.

Developed custom PL/SQL packages for extraction, cleaning and loading of transaction and reference data.

Designed and Developed Technical Design documentation and End User documentation.

Unit tested Custom Modules.

Technical environment: Unix, MS Windows XP, Oracle 10g, SQL*Plus, SQL, PL/SQL, TOAD.

Oracle eBS (e-Business Suite) (Oracle Applications 11i) Developer

Ritchie Brothers Auctioneers

Vancouver, British Columbia, Canada

March 2009 – June 2009

CRM Project

Project Objective: To implement Customizations to Oracle E-Business Suite (RICE Elements - Reports, Interfaces, Conversion and Extensions).

Developed custom PL/SQL packages for Customer Relationship Management (CRM).

Designed and Developed Custom Forms for Customer Relationship Management (CRM).

Designed and Developed Installation Packages.

Designed and Developed Technical Design documentation and End User documentation.

Used Oracle E-Business Suite API (Application Programming Interfaces).

Unit tested Custom Modules.

Technical environment: Unix, MS Windows XP, Oracle 10g, Oracle eBS (e-Business Suite) (Oracle Applications 11i) (11.5.10), SQL*Plus, SQL, PL/SQL, TOAD, CVS.

Oracle Developer

MANULIFE Financial

Toronto, Ontario, Canada

September 2008 – January 2009

Accounting Integrity Reconciliation Improvement (AIR) (MAXIMIS) Project

Project Objective: to improve the GL Reconciliation through technical changes. Support of multiple accounting bases. Provide data so business users can drill down to greatest possible detail.

Developed custom PL/SQL packages for account balance extraction and reconciliation.

Unit tested Custom Modules.

End User Support.

Technical environment: Unix, MS Windows XP, Oracle 10g, SQL, PL/SQL, SQL*Plus, SQL Navigator PVCS.

Oracle eBS (e-Business Suite) (Oracle Applications 11i) Developer

IBM Canada

Toronto, Ontario, Canada

June 2008 – September 2008

TekConnect Project

Project Objective: To implement various Customizations to Oracle E-Business Suite (RICE Elements - Reports, Interfaces, Conversion and Extensions).

Developed custom PL/SQL packages for Transportation Management (OTM), Shipping and Deliveries (WSH), Order Management (OM), Incentive Compensation (OIC), General Ledger (GL).

Designed and Developed Custom Extensions and Interfaces.

Designed and Developed Custom Database Objects (Tables, Views).

Designed and Developed Installation Packages.

Designed and Developed Technical Design documentation and End User documentation.

Used Oracle E-Business Suite API (Application Programming Interfaces).

Unit tested Custom Modules.

Technical environment: Unix, MS Windows XP, Oracle 10g, Oracle eBS (e-Business Suite) (Oracle Applications 11i) (11.5.9), SQL*Plus, SQL, PL/SQL, TOAD, CVS.

Oracle Developer

Bank of Montreal

Toronto, Ontario, Canada

March 2008 – June 2008

RIS (Retail Information System) Project

RIS is a marketing and sales support tool for Nesbitt Burns employees.

Organizes, manages and stores a wide range of information about each of NB’s clients and their respective holdings.

Allows Investment Advisers to manage clients and their entire portfolios.

Permits online trading and processing of equities, mutual funds and fixed income securities.

Tracks original purchases, average costs, account balances, prices, yields and positions in various currencies.

Project Objective: To implement various enhancements to the system.

Designed and developed custom Oracle Developer Forms, Reports and PL/SQL Packages.

Designed and developed Unix Shell Scripts.

Technical environment: Unix, MS Windows XP, Oracle 10g, Oracle Developer Suite 10g, SQL*Plus, SQL, PL/SQL, TOAD.

Oracle eBS (e-Business Suite) (Oracle Applications 11i) Developer

WSI

Mississauga, Ontario, Canada

November 2007 – March 2008

Galileo Project

Galileo is a complete CRP solution implemented in Oracle Application.

Project Objective: To implement various Customizations to Oracle eBS (e-Business Suite) (Oracle Applications 11i) (RICE Elements - Reports, Interfaces, Conversion and Extensions).

Designed and developed Custom Extensions, Interfaces and Conversions for GL (General Ledger), AR (Accounts Receivable), Quotes, Sales, Support.

Designed and developed custom Oracle Developer Forms and PL/SQL Packages.

Designed and developed Oracle PL/SQL scripts and Unix Shell Scripts.

Used Oracle E-Business Suite API (Application Programming Interfaces).

Technical environment: Unix, MS Windows XP, Oracle 10g, Oracle eBS (e-Business Suite) (Oracle Applications 11i) (11.5.10.2), Oracle Developer 6i, SQL*Plus, SQL*Loader, SQL, PL/SQL, TOAD.

Oracle Developer

Royal Bank of Canada - Dexia

Toronto, Ontario, Canada

August 2007 – October 2007

Global FX Project

Project Objective: To enhance and integrate existing systems.

This project will integrate the existing FX trade capture and aggregation system with a market leading (vendor) automated pricing and profiling system. The result will be automated market and client side pricing that will handle IIS FX transactions

Provide a new pricing and profiling system which will handle IIS FX transactions.

Replace the existing system which is in use - the Foreign Exchange Aggregation (FEA) system. The FEA trade captures and aggregation functionality will be integrated into the Cognotec’s delivered solution.

Designed and developed PL/SQL programs, Stored Procedures, Stored Functions and Database Views.

Implemented, tested and documented code.

Wrote Functional and Technical specification documents.

Technical Environment: UNIX, MS Windows XP, Oracle 10g, SQL Developer, SQL, PL/SQL, TOAD, MKS Source Integrity.

Oracle Developer

Stratos Global Internet Satellite Communications

St John's, Newfoundland, Canada

May 2006 – July 2007

Stratos Global is an international telecom service provider offering customers operating in remote locations with a variety of wireless IP, data, and voice satellite solutions.

STRATOS-XANTIC System Integration

CRM, Billing and Mediation System Integration Project

Project Objective: To convert, enhance and integrate existing systems.

Conversion, enhancement and Integration of various CRM (Customer Relation Management, Billing and Mediation systems based on Oracle database.

Designed and developed Oracle Forms and Reports modules, PL/SQL programs, Stored Procedures and database Triggers.

Designed and developed various database objects (tables, views) to support integration process.

Designed and developed ETL PL/SQL Scripts for Data Extraction, Transformation and Loading.

Implemented, tested and documented code.

Wrote Functional and Technical specification documents.

Technical Environment: UNIX, MS Windows XP, Oracle 10g, Oracle Forms 10g, Oracle Reports 10g, SQL, PL/SQL, TOAD, PVCS, Magic.

Oracle PL/SQL Developer

Swiss Re Life & Health Canada

Toronto, Ontario, Canada

April 2005 – January 2006

BoF- (Business of the Future project)

DW ETL Project

Project Objective: To develop new system.

Data Migration and Conversion from ADABAS database to Oracle data warehouse (DW).

Designed and developed ETL PL/SQL Scripts for Data Extraction, Transformation and Loading.

Designed and created various database objects (tables, views) to support conversion process.

Converted large number of Insured, Insurance Policy, Coverage, Benefit and Underwriting record.

Implemented, tested and documented code.

Technical Environment: UNIX, Oracle 9i, PC, MS Windows XP, Oracle Developer, PL/SQL, SQL*Loader, TOAD, SPEARHEAD ETL Tool.

Oracle eBS (e-Business Suite) (Oracle Applications 11i) Developer

IBM/ORACLE/MDS/Nordion

Toronto, Ontario, Canada

August 2004 – February 2005

CBS - Common Business System

CBS is a complete integrated ERP (Enterprise Resource Planning) system implemented with Oracle E-Business Suite. It automates the following key business processes: Manage the Business (MB), Quote to Cash (QTC), Demand to Available (D2A), and Requisition to Pay (R2P), Manage Human Resources (HR), Contract Management (CM) and Service Management (SM), Accounts Receivable (AR), Order Management (OM).

Project Objective: To implement various Customizations to Oracle E-Business Suite (RICE Elements - Reports, Interfaces, Conversion and Extensions).

Developed custom Oracle Developer Forms and PL/SQL packages for Order Management (OM).

Developed custom PL/SQL packages and libraries for Shipping and Deliveries (WSH).

Developed custom Oracle Developer Forms and PL/SQL packages for EDI Interfaces.

Developed custom Oracle Developer Forms and PL/SQL packages for Accounts Receivable (AR).

Analyzed existing Oracle Database and Oracle Application Modules.

Designed and Developed Custom Extensions and Interfaces.

Designed and Developed Custom Oracle Developer Forms, Custom PL/SQL Packages, Oracle Loader scripts and Unix Shell Scripts.

Designed and Developed Custom Database Objects (Tables, Views).

Designed and Developed Installation Packages.

Designed and Developed Technical Design documentation and End User documentation.

Used Oracle E-Business Suite API (Application Programming Interfaces).

Unit tested Custom Modules.

Technical Environment: Unix, Windows NT, Oracle 9i, Oracle eBS (e-Business Suite) (Oracle Applications 11i) (11.5.9), Oracle Developer 6i, SQL*Plus, SQL*Loader, SQL, PL/SQL, TOAD, EDI Services Software.

Systems Analyst/Oracle Developer

ACCENTURE

Baltimore, Meriland, USA

November 2003 – February 2004

CPS - Coal Production System

CPS is an integrated computer application that automates the following functions:

Customers, Business Units, Corporate Accounting, Mine Accounting, Daily tracking of Bank Transactions and Treasury Activity, Month-end close activities, Maintenance of Control/Validation Tables, Cash Transactions, Sales Plans, Sales Orders, Shipments, Payments and Reporting.

Project Objective: To Document and Enhance existing system.

Retrofitted existing Physical Database to Logical Database Model (ER Model) using Oracle Designer.

Created Entity Relationship Diagrams and Server Model Diagrams.

Analyzed existing Oracle Database, Oracle Forms and Oracle Reports.

Analyzed existing SQL and PL/SQL code in Oracle Forms, Oracle Reports, Oracle Database Triggers and Stored Program Units.

Identified Business Processes and Functions.

Produced Business, Functional, and Technical and End User documentation.

Designed, Developed and Implemented Oracle Security system.

Designed, Developed and Implemented Security Data Model, Database Tables, Security Maintenance Forms, Security Control PL/SQL Logic, User Roles and Privileges.

Implemented Security in Back End trough Oracle Fine-Grained Access Control (RLS - Row Level Security) (VPD - Virtual Private Database) and Security Policy Functions.

Implemented Security in Front End trough PL/SQL Code in Oracle Forms Triggers.

Developed new Database Views.

Enhanced and optimized existing Oracle Reports.

Technical Environment: Windows NT, Oracle 9i, Oracle 9i Application Server, Oracle Designer 9i and 6i, Oracle Developer 9i and 6i, SQL*Plus, SQL*Loader, SQL, PL/SQL, TOAAD.

Systems Analyst/Designer

Airline Limousines

Toronto, Ontario, Canada

November 2002 – October 2003

Airline Limousine is the largest Limo and Taxi Service Company in Ontario.

LIMO - Automated Order Taking and Vehicle Dispatching System

LIMO is an integrated computer application that automates the Limo and Taxi Service processes including Order Taking, Vehicle Tracking, Vehicle Scheduling, Vehicle Dispatching, Vehicle Management, Driver Management, Client Account Management, and Reporting.

Project Objective: To develop new system.

Performed Business and System Analysis.

Produced Business, Functional and Technical specifications.

Developed Process Models using Oracle Designer Process Modeler.

Developed ER Models using Oracle Designer Entity Relationship Diagrammer.

Developed Function Models using Oracle Designer Function Hierarchy Diagrammer.

Generated Physical Database model using Oracle Designer Database Transformer.

Developed Application Modules using Oracle Designer Design Editor.

Generated Application Modules using Oracle Designer Application Transformer.

Generated Oracle Forms Modules using Oracle Designer Forms Generator.

Maintained Oracle Designer Repository using Oracle Designer Repository Object Navigator and Repository Administration Utility.

Performed Data Mapping between Existing and New Database.

Produced ETL PL/SQL Scripts for Data Extraction, Transformation and Loading.

Performed Data Migration.

Developed complex Oracle Forms, Oracle Reports, PL/SQL Code and SQL Scripts.

Supervised 2 Oracle Developers.

Technical Environment: Windows NT, Oracle 9i, Oracle Designer 9i, Oracle Developer 9i, SQL*Plus, SQL, PL/SQL, SQL*Loader, TOAD.

Oracle Forms Developer

Ontario Power Generation

Toronto, Ontario, Canada

January 2001 – November 2002

New Horizon System Solutions is a new technology service partnership created from Ontario Power Generation's Information Systems Group and an affiliate of Cap Gemini Ernst & Young.

CEM - Chemistry & Environment Management System

CEM implements an integrated computer application that automates the Lab Processes including Task Management, Task Scheduling, Chemical Events Management and Quality Assurance at Ontario Hydro facilities and complies with regulatory record keeping and reporting requirements.

Project Objective: To enhance existing system.

Implemented many Enhancements and New Features.

Fine-tuned and maintained the system.

Developed, customized and fine-tuned Oracle Forms, Reports, Graphics, SQL scripts and database objects.

Implemented, tested and documented code.

Technical Environment: HP 9000, HP UNIX, Oracle 8i, PC, MS Windows NT, Oracle Designer/2000, Oracle Developer/2000, SQL Navigator, SQL*Plus, SQL, PL/SQL, TOAD.

Oracle Developer

Hudson’s Bay Company

Toronto, Ontario, Canada

October 2000 – January 2001

RETEK is enterprise system that feeds data to an Oracle data warehouse (DW), which in turn is linked to Cognos PowerPlay and Impromptu online analytical processing systems (OLAP) that are used by executive management, category management, buying and inventory control staff.

RETEK - Retail Merchandising and Warehouse Management Systems

Project Objective: To enhance existing system.

Inventory management, purchase orders, receiving, distributions, transfers, cartons tracking, sales, forecasting, replenishing. Processes and stores daily sales information from 307 locations.

Developed, customized and fine-tuned Developer 2000 Forms, Pro*C programs and SQL scripts.

Designed and developed ETL PL/SQL Scripts for Data Extraction, Transformation and Loading.

Implemented, tested and documented code.

Technical Environment: IBM RS/6000, UNIX, Oracle 8, PC, MS Windows NT, Oracle Developer/2000, SQL Navigator, SQL*Plus, SQL, PL/SQL, Pro*C, TOAD.

Oracle Developer

Allianz Canada Insurance Company

Toronto, Ontario, Canada

May 2000 – October 2000

Allianz Canada is the Canadian subsidiary of Allianz AG, a large multi-national insurance organization operating in over 70 countries on five continents.

INOVA Auto Quotes - Quebec Automobile Quotes Module

Project Objective: To develop new system.

On-line personal lines quotation systems for private passenger automobile.

System allows user to:

Capture client information

Search for an existing customer

Search for an existing quote

Create a new quote using existing customer information

Manipulate the quote (versioning) to produce "what if" conditions

Manually or automatically generate rate classes, driving records, discounts, surcharges

Manually or automatically rate private passenger risks using the Ratabase product

Choose three non-modifiable coverage package options

Use full User Memo functionality and User Diary functionality

Generate the printing of permanent liability cards

Print Documents History.

Developed, customized and fine-tuned Oracle Forms, Oracle Reports, PL/SQL units and SQL scripts.

Implemented, tested and documented code.

Technical Environment: Oracle 8i, Oracle Developer/2000 (Version 6.0), SQL, PL/SQL, SQL*Plus, TOAD, SQL Navigator, MS Windows

Contact this candidate