RESUME: Sr. Oracle Financials Consultant - - - Available

RESUME: Sr. Oracle Financials Consultant - - - Available

Post by J Silv » Wed, 23 Apr 2003 02:47:20



JIVAN SILVA               ji...@relational.ca               (416) 937-3282

Get a Word copy of my resume here ---> www.relational.ca

PERSONAL PROFILE:

* Twelve years experience in designing solutions for large high technology corporations.
* Proficiency in database development, system analysis and Oracle Applications.
* Solid foundation and education with increasing training and specialization.
* Quick to learn with the ability to work in a team environment as well as independently.
* Good people skills coupled with strong sense of ethical behavior and commitment.
* Canadian and Brazilian citizenships with Canadian government security clearance.
* United States TN-1 work visa eligibility.

 CONTRACTS HISTORY:

 Dec. 2002 - Feb. 2003 NAV Canada       Ottawa - ON

* Participated in the migration from Oracle Financials 10.7 to 11i.5.7 under Oracle 9i AS, 8i.1.7.4i and AIX 4.3.
* Reviewed and modified 100 scripts for the overnight synchronization of an external Oracle Discover database
 with tables from the AR, GL, PO, WSH and HR modules, using Unix shell, PL/SQL, SQL*Loader and Toad.
* Completed the migration of several reports to 11i in the Order Management, Shipping and Warehouse modules,
 including Packing Slip, Pick Slip, Mailing Label, Bill of Lading and Custodial Items Value.
* Migrated 6 database triggers (auditing trail generators) from AR tables to the correspondent 11i HZ objects.

 Mar. 2002 - Sep. 2002 Economical Insurance Group     Waterloo - ON

* Completed the development, testing and documentation of the Lockbox Interface. The work was done
 on AR, GL and HR modules of Oracle Financials 11i.5.7 under Oracle 9i AS, 8i.1.7.3 and AIX 4.3.
* Completed the Premium Refunds interface. The PL/SQL package used the Adjustment API to create
 and approve adjustments. Developed reports about the files transmitted to the service provider.
* Completed an extraction program to produce merged records from refunds and receipts for EFT
 and credit card. A procedure to extract check information was later added to the package.
* Developed bridges between the mainframe and Oracle using MQ-Series and standard Oracle packages.
* Created a write-off procedure using the Adjustment API and Oracle Reports 6i.0.8.18.

 Aug. 2001 - Nov. 2001 Computer Science Corporation (CSC)@ NORTEL Networks  Toronto - ON

* Migrated vendors (Mexico and Puerto Rico organizations) from 10.7 char to 11i.5.3, Oracle 8i.1.6 / HP-UX 11.
* The migration of vendors, sites, contacts and related setups overcame technical challenges and involved a great
 deal of interaction with users during the User Acceptance Testing (UAT) and process optimization phases.
* Collaborated in the correction and completion of the Fixed Asset Tag Label file extraction interface, APEX
 Interface (Suppliers, Payments & Invoices) and for the Inbound Invoice Detail EDI Interface (810 format).
* Developed very complex reports for the Accounts Payable and General Ledger modules using Reports 6i.
* The work was performed on GL, AP, PO, AR, CE, FA, INV, HR, OE, Alert and Workflow modules, using
 Unix Shell Scripts, Remedy software and Oracle Developer 2000 6i tools including Reports 6i and Forms 6i.

 ji...@relational.ca    (416) YES-DATA         Page 2

 Feb. 2001 - May  2001 Accenture @ BELL South      Atlanta - GA

* Technical Architect Coordinator (manager level) for Phase 1 of project BEST -  Bell South Supply
 Chain Transformation, using Oracle Financials Release 11i.5, Oracle 8i.1.6 under Sun Solaris 2.8.
* Phase 1 activities included the complete functional and technical implementation of Oracle e-Catalog,
 Oracle i-Procurement, Purchasing 11i, General Ledger 11i, Oracle Alerts 11i and Oracle Workflow 11i.
* Responsible for the deliverables of the RICE team (Reports, Interfaces, Conversions and Extensions).
* Daily tasks included attending meetings with other team managers, review and approval of technical
 design documents and technical mentoring of team members on Oracle tools and applications products.
* Worked as a technical resource / system administrator on as per needed basis for dev & tst environments,
 developing, debugging and modifying PL/SQL programs, Unix shell scripts and Forms 6.0.8/XML/JSP.
* The environment also included non-Oracle utilities - Kintana (environment migration and cloning tool),
 Orbix (CORBA), Direct Connect, Harvest (version control), AppsWorx (Concurrent Manager substitute).

 July 2000 - Dec. 2000 CSC Energy Services      Columbus - OH

* Supported all the production environments and users on a daily basis by responding to emergency requests.
* Developed new reports and optimized existing ones with the use of database triggers and Unix shell scripts.
* Assisted CSC in its continuing market expansion by adapting the financial core modules: GL, AR, AP and
 PO reports and interfaces to comply with the new market regulations and billing requirements nationwide.
* Contributed to the Oracle team as the apps system administrator for the Development and Test environments.
* CSC has Oracle Financials 11i / 10.7 char and multiple Oracle 8i.1 / 7.3.4 remote instances on SunOS 5.6.

 Jan. 2000 - June  2000 IKON Office Solutions      Philadelphia - PA

* Developed a bridge from the SBT/AP Legacy system to the Oracle FA Mass Additions open interface.
* Created an interface from Oracle GL to SBT/GL transferring all posted SBT journal entries produced
 by the FA Mass Additions upload. A chart of accounts mapping  was developed to support this process.
* Developed a sub-system that extracts AP journal entries from Oracle GL into OMD/GL legacy system.
* A substantial part of the work consisted in programming with packages, database triggers, Unix scripts,
 PL/SQL, automated FTPs, extensive system administration, end user support, creation and maintenance
 of Forms 4.5 and Reports 2.5 using Developer 2000 and Application Object Library 11 resources.
* Ikon has Oracle Financials 11 and several Oracle 8 distributed databases running on AIX 4/RISC 6000.

 ji...@relational.ca    (416) YES-DATA         Page 3

 July 1999 - Dec. 1999 IBM Canada @ The Canadian Wheat Board    Winnipeg - MB

* Provided day to day technical and functional support to the world's single largest exporter of wheat and
 barley - CWB. Among the modules supported were GL, AR, AP, PO, FA, OE, INV, AOL, ALR and HR
 of its Oracle Financials / Distributions 10.7 SC and Oracle 7.3.4 running on IBM's AIX 4 / RISC 6000.
* Worked as the Apps System Administrator for the production, accept, test and development environments.
* System Administration tasks included routine purge of old concurrent report requests, monitoring system
 resources and concurrent processes, installation and support of user as well as developer related products,
 administration and security control of 300 users and migration to new releases - Oracle 8i / Financials 11i.
* Support Analyst tasks included the management of the complete TAR life cycle, troubleshooting end user
 problems, management of a comprehensive repository with CWB's problems and solutions, development
 and delivery of training for key users and the creation of policies for maintenance on all environments.
* Database Administration tasks included scheduling and managing client and server patch installations using
 Otto and Autopatch utilities and regular patch compliance check with Y2K white papers. Optimization of
 processes, Korn shell scripts writing and Unix and Oracle production environment backup rescheduling.

 Apr. 1999 - Apr. 1999 LAFARGE        Montreal - PQ

* Provided consultancy on the development, customization and system administration of 32 GL, AP and AR
 reports using Reports 2.5 and PL/SQL for Oracle Financials 10.7 NCA under Oracle 7.3 / DIGITAL UNIX.

 Jan. 1999 - Mar. 1999 CSC @ United States Coast Guard Finance Center   Chesapeake - VA

* Participated in the implementation of the Accounts Receivables module of Oracle Financials 10.7 SC
 using Reports 2.5, PL/SQL and database triggers under Oracle 7.3 and HP 9000 / HP-UX 10 / WNT4.
* Tasks included the customization and trouble shooting of  the dunning letters, 3 invoice reports, the
 import of customers from an Access database and the System Administration for the test instance.
* Assisted the conversion and testing of USCG's legacy systems and helped users with technical support.

 Aug. 1998 - Sep. 1998   Cancom - Canadian Satellite Communications   Toronto - ON

* Developed several new reports and customized existent ones for the Accounts Receivable module of
 Oracle Financials and Manufacturing 10.7 SC using Reports 2.5, Oracle 7.3.4 and HP-9000 /HP-UX 10.
* Optimization of 2, 3 and 4 hours reports into 10 minutes reports and the development of large PL/SQL
 procedures were an important part of this work.

 Apr. 1998 - June 1998   CANAC - A Kohler Company     Toronto - ON

* Completed independently all the setup of the Purchasing module and the expense items part of the
 Inventory of Oracle Financials / Manufacturing 10.7 SC under Oracle 7.3.3 and RISC 6000 / AIX 3.2.
* Tasks include functional and technical analysis, testing, system admin, documentation and user training.

 Nov. 1997 - Feb. 1998   DOFASCO          Hamilton - ON

* Assisted the pre-production phase of the General Ledger, Accounts Receivable and Payable modules of
 Oracle Financials 10.6 / 10.7 and Purchase Order, Inventory, Order Entry and EDI interface modules of
 Oracle Manufacturing 10.6. Worked also as the Apps System Administrator in the testing environment.
* Tasks included end users support, installation of Oracle products, Reports 2.0 customizations, TARs
 management and PL/SQL 2.3 scripts development under Oracle 7.1.6 and HP 9000 / HP-UX 10.

 June 1997 - Oct. 1997   ESCO Corporation        Vancouver - BC

* Completed the conversion of the Bills of Material and Inventory modules of Oracle Manufacturing and
 Accounts Receivable (including some setup) of the Oracle Financials 10.7 Smart Client Multi-Org.
* Wrote a set of  scripts in PL/SQL 2.3, sql*loader, database triggers and packages for the 500 gigabytes
 Oracle 7.3.3 instances under Digital Alpha 8400 server /64-bit DIGITAL UNIX 5.6, WNT4 and W95.
* ESCO's project was considered by Oracle Corporation the third-largest implementation of Oracle
 Applications in the world and successfully proceeded faster than any other comparable site until that date.

 Nov. 1996 - May 1997   ALIAS | WAVEFRONT - A Silicon Graphics Company    Toronto - ON

* Wrote a set of scripts in PL/SQL, sql*loader and database triggers for the conversion of the Accounts
 Receivable and Payable modules from the legacy systems to Oracle Financials 10.6.1 Multi-Org.
* Created a collection of C procedures for the analysis and cleanup of the legacy data files.
* Developed the Revenue Recognition, Revenue Reallocation and Discount interfaces using PL/SQL 2.3.
* Developed also the interface between the Order Entry system and AR, including both the Error
 Handling and the Log Control procedures using PRO*C 2.2, Oracle 7.3 and SGI Indy/IRIX 5.3.

 ji...@relational.ca    (416) YES-DATA         Page 4

 Sep. 1996 - Oct. 1996 DATA GENERAL CANADA        Toronto - ON

* Completed the setup and conversion of the Accounts Payable, Purchase Order and Fixed Assets modules
 of Oracle Financials 10.6 / Multi-Org using PL/SQL 2.3 with Oracle 7.3 under AViiON / DG-UX 4.11.

 May 1996 - Aug. 1996   CLEARNET       Toronto - ON

* Participated in the User Acceptance Testing of the new billing system for the first PCS - Personal
 Communication Services, in Canada. Tasks included test scripts, scenarios writing and process mapping.
* Completed a set of programs to write and read the UTX file - unrated transactions, using PRO*C 2.0,
 PL/SQL 2.3, Oracle 7.3 under HP 9000 / HP-UX 10.0 and Sun Sparc Ultra with Solaris 2.5.

 WORK HISTORY:

 Dec. 1995 - Feb. 1996 ORACLE Corporation Canada  (Jr. System Administrator)  Toronto - ON

* Made installations, setups and some DBA tasks for courses of the Education dept. under HP-UX 9.0.
* Coordinated the copy of the US unix model, structure and standards, including the implementation
 of the Optimal Flexible Architecture - OFA, on all Canadian Training Centers using ORACLE 7.2.2.

 Sep. 1995 - Nov. 1995 SEER Technologies  (Sr. Consultant)    Toronto - ON

* Completed five weeks of intensive training in Raleigh, NC. Studied and trained in the technical
 construction of very large scale client/server applications using HPS CASE under ORACLE 7.2.
* Participated in a one week workshop on Consultant Techniques in Orlando, FL.

 Feb. 1994 - July 1995 Origin C&P Services  (Sr. System Analyst / Sr. Programmer) Rio de Janeiro

* Worked closely with clients, achieving outstanding results at all full life cycle of the systems -
 data modeling, process analysis, programming and testing, delivery, training and maintenance.
* Consulted regarding PL/SQL statements optimization and database tuning for the Xerox Brazil.
* Completed (independently) all the full life cycle of the Parts Per Million - PPM and the CPS -
 Cost Performance Supplier systems for the Quality Assurance area of  Xerox Brazil using
 Forms 4.0, Reports 2.0, PL/SQL 2.0 and ORACLE 7 under Sun Sparc 20 and Solaris.
* Developed and administered a complete course on ORACLE 7 for Origin co-workers.
* Completed (in a team environment) the Distributed Data Processing - DDP project for the
 Manufacture area of Xerox Brazil using PL/SQL 2.0 and the distributed option of ORACLE 7.
* Completed (in a team environment) all the full life cycle of the Credit Card Contingency system for
 Mesbla Financial Systems using Forms 4.0, PL/SQL 2.0, ORACLE 7.2, HP PA827 and HP-UX 9.0.
* Completed (in a team environment) all the full life cycle of the Vessel Management system for
 Lachman Corporation using PL/SQL 2.0, ORACLE 7 and Gupta SQL Windows.

 Jan. 1993 - Nov. 1993 Relational Consulting  (System Analyst / Sr. Programmer) Rio de Janeiro

* Completed (in a team environment) all the full life cycle of the External Accounts Reconciliation for the
 Souza Cruz Overseas using SQL*Forms 3.0,  SQL*Reports, PL/SQL and ORACLE 7 under SCO UNIX.
* Completed (independently) and maintained the Telephone Management system for the Mesbla Holding
 using SQL*Forms 3.0,  SQL*Reports, PL/SQL and ORACLE 6 and 7 under HP-UX.
* Completed (in a team environment) all the full life cycle of the International Trade Monitoring  system,
 including the Import, Export and Funding modules for the Bozano Simonsen Bank using PL/SQL,
 SQL*Forms 3.0, SQL*Reports, and ORACLE 6 under HP-UX and SCO UNIX.

ji...@relational.ca    (416) YES-DATA         Page 5

 Aug. 1991 - Feb. 1992 RHEEM Commercial and Industrial   (Programmer)   Rio de Janeiro

* Pioneered and implemented a system based on relational database (IBM SQL/DS).
* Administered a SQL course for the development team.
* Developed complex graphics, programs and reports for the Import/Export system.
* Programmed the Inventory Control system using COBOL/CICS/SQL.

EDUCATION:

Pontificia Universidade Catolica do Rio de Janeiro (PUC-RJ)

1992             M.Sc. in Computer Science, completed 12 credits.
1992             B.Sc. in Data Processing, graduated.
1988             Computer Engineering, completed 77 credits.

CERTIFICATES:

Ryerson Polytechnic University

2003             Advanced Business Management, 364 h, On-Going (3/8 done).
2003             Business Management, 364 h, On-Going (6/8 done).
2003             Accounting - Finance, 364 h, On-Going (6/8 done).
1998             Web Design, 84 h, Completed.

Fundacao Getulio Vargas do Rio de Janeiro (FGV-RJ)

1995             International Business and Finance, 360 h, Completed.

ACHIEVEMENTS:

Pontificia Universidade Catolica do Rio de Janeiro (PUC-RJ)

1988 - 1992            Selected for partially repayable scholarship.
1991             Selected for two teaching assistant positions - C language, with scholarships.

Support Research Foundation of Rio de Janeiro (FAPERJ)

1991             Selected for Scientific Initiation Scholarship (Compilers Technology area).

CO-OP PROGRAMS:

Dec. 1990 - July 1991      Furnas Electrical Company (IBM 3090, DB2, DATACOM/DBMS, IDEAL/4GL, COBOL)
May  1990 - Nov. 1990      Unique Systems (ORACLE 5 / 6, UNIFY 2000/RDBMS, ACCELL/4GL, C, SCO UNIX)
Jan. 1990 - Apr. 1990      Conectus Informatics (CLIPPER, C, PASCAL, MODULA 2, PROLOG, UNIX, MS-DOS)

ji...@relational.ca                    (416) YES-DATA                    ADDITIONAL INFORMATION

HARDWARE: Sun Sparc Ultra, Sun Sparc 20, Sun Sparc Classic, HP 9000 series 800/G50,
  HP PA827, SGI Indy Stations, SGI CHALLENGE XL 64-bit RISC server,
  Digital Alpha 8400 server, IBM RISC 6000.

SOFTWARE: ORACLE V9iAS-V8.1.6i-V8-V7.3.4-V6-V5, Developer 2000 6i, Reports V6i-2.5-2-1,
  Forms V6i-6-4.5-4-3-2.3, PL/SQL V6.8-2.3-1, SQL*Plus, SQL*Net 2.0-1.0, PRO*C,
  SQL*Loader, TOAD 7.3, C language, FTP, TCP/IP, Kintana, Unix Shell Script,
  Oracle Financials 11.5.3i /11, 10.7 NCA/SC-10.6, Oracle Manufacturing 11-10.7 SC
  Multi-Org versions, Graphical and Character Interfaces - AOL, GL, AR, AP, PO, OE,
  FA, INV, HR, EDI, Workflow, i-Procurement, PA, CE, BOM, WIP and Alerts modules,
  DB2/2, SQL/DS, HPS CASE Environment, SQL Windows, Solaris 7, 2.7-2.4, SunOs,
  HP-UX 11-10-9, AIX 4-3.2, DG-UX 4.11, LINUX, SCO UNIX, NCR UNIX, IRIX,
  64-bit DIGITAL UNIX 5.6, Windows XP Prof.-2000-98-95-NT 4-3.5, MS-DOS, telnet,
  Remedy, DHTML, MS Office 2000, FrontPage 2000-97, Homesite 3-2.5, HTML 4-3.2,
  Acrobat, JavaScript, MS GIF Animator, Adobe Photoshop 6-5.5-4, Illustrator 9-8-7.

COURSES: Oracle Web Application Server (Oracle Corporation - OC)
  Define Flexfields - 10.7 SC (OC)
  Oracle Inventory - 10.7 SC (OC)
  Oracle Financials Technical Foundations (OC)
  Oracle Accounts Payable - 10.7 SC (OC)
  Oracle Applications System Administration (OC)
  Oracle Accounts Receivable - 10.7 SC (OC)
  Oracle General Ledger - 10.7 SC (OC)
  UNIX / Systems Administration (OC)
  UNIX / Network (OC)
  ORACLE 7.3 DBA I (OC)
  HPS Case Environment
  SQL Windows
  Building, Config. and Expansion of PCs
  SCO UNIX SVR3.2 / Administration
  SCO UNIX SVR3.2 / Basic
  New Microprocessor Architectures
  Hypertext Applied to Software Engineering
  Software Re-Utilization
  LDT-COBOL / CICS / SQL Code Generator
  Easytrieve Plus
  COBOL / Report Writer
  COBOL
  Datacom / DBMS
  IDEAL / 4GL
  Roscoe
  Introduction to JCL
  Structured Logic and Programming
  Unify 2000 / RDBMS
  ACCELL / 4GL
  Dataflex / 4GL

SEMINARS: Oracle Applications Users Group Conferences - Spring 2000