RESUME

of

Levin Mootoosamy

E-Mail: acqvq3@r.postjobfree.com

Telephone: +61-411-***-***

Skills Synopsis:

Oracle Products:

Oracle Forms, Oracle Reports, Oracle Application Object Library (AOL) V10, Oracle Application Object Library (AOL) GUI V10.7, V11.x, G/L, AP, AR,PO, HR, PAY, OTL, GHR & FA table structure, Oracle Fast Formula, Employee and manager Self Service Web Application, Oracle 8i/7.0, Developer 2000, Smart Db, SQL Navigator, TOAD, Self Service Personalisation, Oracle XML Publisher.

Operating Systems:

VAX VMS, UNIX(SUN, IRIS), MS-DOS, NOS, SIMEX, MS WINDOW, MS NT

Specialty Skills:

Oracle Forms 2.3, 3.0, 4.0, 4.5, 6.0, Oracle Reports 2.0, 2.5, 6.0 . Oracle Application Object Library AOL (GUI). AIM, Financials and Human Resources table structures, Oracle Fast Formula, Oracle system Administration. Implementation of Oracle Human Resources, Payroll, OTL and OLM, XML Publisher, OUM.

Experience Summary

Experienced technical and functional Oracle resource with well over 20 years of information systems background. Involved with the Oracle HR/Payroll module since inception of product. Wide variety of industry and product experience. Excellent understanding of Oracle applications and directs those aptitudes to implementing successful business solutions. Strong analytical and trouble shooting skills. Emphasis on problem (gap) resolution within tight time constraints.

Professional Experience

Professional Experience

February 2013- August 2013

Tata Consulting Services

Qantas, Sydney, Australia

Team Leader

Support of Qantas HRMS applications, including Payroll. Day to day problem analysis and resolutions. Upgrade of HRMS from R11 ro R12. Responsible for the realignment of HRMS R11 to R12. Analyzing all the enhancements, Fast Formulas, Reports, and Forms, Packages and interfaces and determining the update that must be carried out.

March 2012- January 2013.

Took time off from work.

Oct 2011 – Feb 2012

Independent Consultant ( RedRock Consulting)

City West Water, Sunshine, Victoria.

City West Water is currently implementing the whole of Oracle eBusiness Suite, R12.

Involved in the implementation of Oracle HRMS (HR, Payroll, iRecruitment, OLM, OTL, and Succession Planning) R12. As the Functional Architect I was responsible for conducting workshop with the City West Water HR department to gather information on the current Legacy system and the expectation of the future Oracle system. The first phase involve the high level design of future process flows and identify possible Gaps. RD11 Oracle OUM methodology document is used to document the future process flows.

Feb 2008 – March 2011

ASG Group, Perth, Australia.

Principal Consultant

Government of Western Australia (Shared Services Project), Canning ton, WA.

Application Functional Consultant supporting the HRMS (HR, Payroll, OTL, OLM, irecruitment) applications:

Solved day to day problem via HP Quality center. Analyze the problem and determine whether it is customization, seeded or data problem. If it is a customization problem determine the problem and apply appropriate solution to solve the problem. If it is a seeded problem the log a TAR. If it is a data or user problem the take appropriate steps to correct the problem. I was also involved in the process design and Gap analysis.

Dana Yerona, Sydney

Responsible for HR/Payroll/OTM support for DANA Yerona. Solve Technical and Functional Problem for the HR/Payroll Applications. Did an enhancement for Shift Employee in the OLM Fast Formula.

Tourism Australia, Sydney

Responsible for HR/Payroll support for Tourism Australia. Solve Technical and Functional Problem for the HR/Payroll Applications.

ASG Group (Corporate Head), Perth

Responsible for several enhancement for the Corporate HR/Payroll applications. Including sending an email notification to appropriate manager of their contractors end date 15 days prior to the contract end date. Also, created an Oracle concurrent report for on demand contract end date. Did some data cleaning on employee end date.

May 2007 – Dec 2007

Independent Consultant.

Government of Western Australia (Shared Services Project), Cannington, WA.

Application Functional Consultant supporting the HRMS (HR, Payroll, OTL, OLM, irecruitment ) applications:

Solved day to day problem via HP Quality center. Analyze the problem and determine whether it is customization, seeded or data problem. If it is a customization problem determine the problem and apply appropriate solution to solve the problem. If it is a seeded problem the log a TAR. If it is a data or user problem the take appropriate steps to correct the problem.

TAB Corporation, Melbourne, Australia.

Was involved in fixing bugs. Wrote a fast formula to generate employee number. Debug and corrected a big PL/SQL packages (250 pages) for employee time coming from a third party application to OTL Did enhancement to reports and Fast-Formulas.

Virgin Blue, Brisbane, Australia.

Created an online self service page for employee to enroll in the Virgin Blue Profit Sharing Scheme. That include creation of reports and other security.

June 2006- April 2007

Taycom Business Solutions Inc, Detroit, USA.

Managing Consultant-1

City of Detroit. Detroit, Michigan, USA

Application Techno Functional Consultant (Functional and Technical). Responsible for the production of all AIM MD050 documents as well as prototyping all extensions to the Oracle HRMS Applications. I was also involved in the process design and GAP Analysis. Writing Fast Formulas. Designing conversions and Interfaces.

2004- 2006

Oracle Corporation, Perth, Australia

Consultant

September 2005 – 2006

Coventry Group Ltd. Perth.

Built five interface from legacy to Oracle Financials, using Oracle Warehouse Builder.

One interface to import invoice from legacy to Oracle Payable.

Three interfaces from Legacy to Oracle General Ledger.

One Interface to update prices in Oracle Materials, Oracle Pricing and Oracle Purchase Order.

Built one Payment Flat File to Westpac Bank for Supplier payment.

June 2005 – August 2005

Government of Western Australia, Shared Services, Cannington, Australia

Implementation of Australian Payroll. Involved in the process design, GAP analysis. Configure a Vanilla UAT and demonstrate the HRMS process to the employee of the Government of Western Australia. Designed the Grade, Step Progression points using Plan Wizard.

BAE Systems. Adelaide.

Created a PL/SQL program to generate OTL timecard when an absence is created in Self Service HR.

Created a PL/SQL program to generated timecard for public holiday.

Independent Consultant

1999 – 2004

June 2004- July 2004

Tetra Tech, Pasadena, California, USA.

Responsible for the creation of Oracle and modification Fast Formula to be implemented in the Time Entry rules. Also created a package to maintain the CTO balances of Tetra Tech, based on the time entered on the timecard.

March 2004- May 2004

Grays – Mauritius

Responsible for the production of Financial reports using Oracle Report 6i.

March, 2001 - December 2003

Government of Quebec, Quebec City, Canada

Responsible for the implementation, both functional and technical, of Oracle Payroll and Oracle Time and Labor (OTL) modules (11i) and Self Service HR 4.0. Québec Government has around 70,000 employee. My responsibility consisted of project planning, staffing, and solution design and reviewing all documents before they are sent to the Government of Quebec... I also designed the Oracle Business process model of the Oracle US payroll application Level 5.

November, 2000 - March 2001

Vectren Corporation, Evansville, Indiana, USA.

Implemented the Oracle Human Resources and Payroll modules. Developed the Paid Time Off Accrual for Vacation and Sick. Created and customized Fast Formulas.

July, 2000 - November 2000

F.A Bartlett Tree Experts, Stamford, Connecticut, USA.

Implemented the Oracle Human Resources and Payroll modules. Developed the interface between time entry and Oracle Payroll. Customized Fast Formulas. Developed conversion program to convert legacy data to Oracle.

Netigy Corporation, San Jose, California, USA.

2000

Implemented the Oracle Human Resources and Employee Direct Access modules. Customized the Employee Direct Access module to suite client needs. Help developers with Oracle Reports Queries. Working on interface to Oracle HRMS applications.

Florida Rock Industries Inc. Jacksonville, Florida, USA.

1999- 2000

Project: FAST

Description: Responsible for the implementation of the HR/Payroll module on an NT platform. Created, tested and customize all the element required by the Florida Rock Industries. Inc. Customized the Fast Formula to suite customer needs. Worked on the requirement for the interface of the Time and Attendance Module with Oracle Payroll. Created Descriptive Flexfields required by the Time and Attendance module. Create a PL/SQL package that is called by Fast formula for the Sick Time Pay, Sick Time Accrual, and the Benefit Hours.

Oracle Corporation

1993-1998

City of Detroit, Detroit, Michigan, USA.

1997-1998

Project: Detroit Resource Management System (DRMS).

Description: Responsible for the Interface, Conversion (using Smart Db) and other custom modification required by the City of Detroit for the Oracle Human Resources module. Was very involved in the implementation of Oracle Human Resources and Oracle Payroll.

Washington Suburban Sanitary Commission, Washington, USA.

1997

Guide the client for their Human Resources conversion and Interface. Built a prototype where APIs were used. Training client on utilization of APIs for employee conversion.

Dell Europe, Braknell, England.

1997

Mapped Order Entry, Account Receivables for conversion from Legacy system to Oracle. Data conversion

From Legacy to Oracle using Smart DB.

Oracle Corporation, Herndon, Virginia (Oracle Development)

1995- 1997

Project: Oracle Federal Human Resources (Oracle HR Development).

Description: Develop SF52 Forms and Reports using Oracle Forms 4.5 Oracle Reports 2.5.

Created new Menu to accommodate SF52 forms.

Used Oracle Application Library AOL GUI to Register Forms, Reports and modify Menu.

Implemented Attachment, Folders, Notepad and Flexfields functionality to the SF52 Forms.

Develop an Inbox form to query SF52 forms that have been sent to user. The Drag and Drop feature has been coded into this Inbox form.

Design, code (using APIs) and test the Update to database process.

Master Lock Company, Milwaukee, Wisconsin, USA

1995

Project: Oracle Financial

Environment: VAX as the server and PC Pentium as the clients. The back end was Oracle 7.0 and the front end was Oracle Report 2.0.

Description: Modified the Standard Invoice Report using Oracle Reports 2.0.

Created Several Custom Reports using Oracle Reports 2.0.

Valspar Corporation, Minneapolis, Minnesota, USA.

1995

Project: Oracle Financial

Environment: HP as the server and PC Pentium as the clients. The back end was Oracle 7.0 and the front end was Oracle Report 2.0.

Description: Created a new Invoice Report using Oracle Reports 2.0 and Oracle Forms 4.0.

McCaw Cellular Communication, Kirkland, Washington, USA.

1994-1995

Project: Oracle Financials

Environment: HP 9000/891 as the server and PC Pentium as the clients. Back end was Oracle 7.0 and the front end was Oracle Report 2.0.

Description: Modify standard reports in G/L, PO, FA and PA using Oracle Reports 2.0 to suit customer requirements. Write PL/SQL code for the automatic uploading of data from spreadsheets to financial tables.

WordPerfect Corporation, Orem, Utah, USA.

1994

Project: Customer Management System

Environment: HP 857 as the server and PC 486 as the clients. The back end was Oracle 7.0 and the front end was Oracle Forms 4.0 and Oracle Report 2.0.

Description: Developed customs forms and reports using Oracle Forms 4.0 and Oracle Reports 2.0. Used DDL (Dynamic Link Library) to start and pass data from Oracle forms 4.0 to FOLIO, an InfoBase software.

Legend Corporation, Pittsburgh, Pennsylvania, USA.

1994

Environment: Sun SPARCstation as the server and PC 486 as the clients. The back end was Oracle 7.0.

Description: Developed Custom Reports using Oracle Reports 2.0

Storage Tech, Boulder, Colorado, USA.

1994

Guided Storage Tech with their forms development (Oracle Forms 4.0)

TCI, Englewood, Colorado, USA.

1994

Environment: Sun SPARCstation as server and client. The back end was ORACLE 7.0 and the front end was Oracle Forms 4.0.

Description: Developed Customs Forms using Oracle Forms 4.0

Livermore Lawrence National Laboratory (LLNL), Livermore, California, USA.

1994

-Updated R9 Oracle PO ER diagram to reflect R10 changes.

-Reviewed LLNL Interface model.

-Attended workshop on EC/EDI (Electronic Commerce/Electronic Data Interchange).

Fermi National Accelerator Laboratory, California, USA.

1993

Participated in the installation of Oracle Government Financials (Release 9).

Town of Brossard, Financial Consultant, Brossard, Canada.

1993

Participated in the implementation of Oracle General Ledger. Modified screens using SQL* Forms 2.3. Used SQL* Plus at different stages during the implementation process to better suit the customer's needs.

CAE Electronics, Engineer, Montreal, Quebec, Canada.

1990- 1993

Marine control system On Board Trainer Simulator. Responsibilities consisted of all aspects of modeling of ship's electrical plant for real time simulation. This included analysis of customer supplied data, design, coding, and testing of the different electrical systems and models using FORTRAN language. The model includes switchboard distribution, switchboard logic, switchboard breaker synchronization, diesel generator, Solid State Frequency changer, and direct current voltage. Prepared Acceptance Test Document, performed Factory Acceptance Test. Designed lesson plans for training sessions. Used special modeling techniques such as Admittance method and preferential node method. Developed a method to share loads equally on on-line generators in parallel.

Institute de Recherche d'Hydro-Québec, Varenne, Québec, Canada.

1987-1990 Junior Engineer

Modeled Hydro-Quebec/New York Power Pool HVDC Network and developed a software package to convert a double tuned filter to two single tuned filters.

Airport Project Unit, Project Engineer, Mauritius.

1985-1987

Participated in the design of electrical wiring of Plaisance Airport's new terminal and supervised the work on site. Worked with contractors to ensure that proper designs were being implemented. Prepared progress reports.

Work History

Independent Consultant, 10/2011 – Present

ASG Group, Perth Australia, Principal Consultant, 02/2008 – 03-2011

Independent Consultant, 06/2006 – 12/2007

Oracle Corporation, Perth, Australia, Consultant, 01/2005 – 05/2006

Independent Consultant, 01/99 – 12/2004

Oracle Corporation, USA, Senior Principal Consultant, Oracle Government Services, 11/93 – 12/98

Town of Brossard, Financial Consultant, 05/93 - 10/93

CAE Electronics, Engineer, 04/90 - 04/93

Institute de Recherche hydro-Quebec, Junior Engineer, 09/87 - 03/90

Airport Project Unit, Project Engineer, 08/85 - 08/87

Education

Master of Business Administration (MBA), California Coast University, California 1998

Master of Engineering, Concordia University, Montreal, 1989

Certificate in Computer Operations, Programming, England, 1986

Bachelors of Engineering, Concordia University, Montreal, 1985

Oracle Training:

Oracle Report Writer 2.0 Technical Training

Oracle Form 4.0 Technical Training

Oracle Glue 1.1 Technical Training

Develop Oracle Applications with Object Library

Oracle Human Resources 10.5 Training.

Defining Flexfields Training

Introduction to Project Management

Smart Db

Oracle Applications System Administration (Smart Client)

Oracle Web Application Server: Develop Web-Based Applications

Oracle Web Application Server Administration

Oracle Learning Management

E R12/5.6.3 Oracle XML Publisher Fundamentals Ed 1

Contact this candidate