Technical Summary

Confidential is a Senior Solutions Architect with 16 years of Industry experience including 15 years with Oracle. Confidential has valuable expertise in planning and designing implementation strategy, upgrades, migration strategy, instance and integration strategy, and building robust systems t streamline business process. He has very strong knowledge of database management/monitoring, performance tuning, and reorganization cloning and migrating Oracle databases across different platforms, upgrades, patching, as well as installing and configuring Oracle Real Application Clusters 11gR2 and 10gRAC. He has vast programming experience with Oracle PL/SQL, Forms, Reports, Oracle ADF/Java Framework and XML Publisher. He has implemented Parallel Concurrent Processing, Workflow, Discoverer 10/11g, and Fusion Middleware Oracle Identity Management SSO/OID , SOA/BPEL, Webcenter Portal and Weblogic. Confidential has extensive experience in Oracle RAC 11G/10G/9i with Oracle EBS R12/11i as well High Availability HA with Oracle DataGuard and database replication with GoldenGate. Confidential als has experience with migration, maintenance and management with Oracle Exadata V2 running a BI/Datawarehouse environment, as well as OBIEE 10/11g, Informatica, DAC, OWB and OBIA, and als implementation of Oracle Enterprise Manager Cloud Control 12c.

Oracle Certifications:

• Oracle 10g/9i Database Administrator OCP
• Oracle E-Business Suite R12 Applications DBA OCP
• Oracle E-Business Suite R11i Applications DBA OCP

Professional Skills

• Fusion Middleware Oracle OIM/OID/SSO,Access Manager,Portal,WebLogic
• Oracle OBIEE 10g/11g, Informatica Powercenter, DAC, Warehouse Builder, OBIA
• Oracle Database 11G/10G RAC/9i/8i/8.0.5/7.3.4 HA/DataGuard
• Oracle Exadata V2 and Oracle Goldengate
• Oracle Enterprise Manager Cloud Control 12c
• Oracle Applications R12/11i/10.7
• Oracle Forms Reports 11g/10g/9i/6i/6/5/4.5
• Oracle Financials GL, AP, AR , Projects, iProcurement, WIP, OM and HCM
• Oracle Weblogic, Portal, ASP, Javascript, HTML
• Peoplesoft 9.1 HCM and Finance
• Kofax Markview, integration with Oracle Weblogic and R12
• Business Objects XI R2 / 6.5, Hyperion Analytic Services 9.1
• Banner 7.4 and 8.2 versions
• Remedy ARS ITSM /OS3, Intergraph G/Technology
• Oracle Metasolv M6.0, MDSI Advantex
• MS SQL Server 2003, 2008, Sybase
• Oracle VM, HP-UX, IBM AIX, SUN Solaris, Red Hat Linux, Oracle EL

Professional Experience

Senior Principal Consultant

Client: S B Engineers and Constructors Jan Present Location: Houston TX

• Plan and design the implementation of Oracle Webcenter Portal 11g and integration with Oracle IDM SS with Access Manager
• Install and configure Fusion Middleware product Weblogic 10.3.6, database repository schemas, OIM, OID, WebTier, Webgate and Oracle Access Manager
• Upgrade Oracle Portal 10g t Oracle Webcenter Portal 11g.
• Implement instance strategy for Oracle R12 EBS upgrade enviroments
• Primary DBA responsible for building and managing Oracle EBS R12 and 11i Release 11g RDBMS.
• Oracle Database characterset conversion from US7ACII t UTF8.
• Installed, patched and upgrade databases from Oracle 11.2.0.3 t 11.2.0.4 DB versions.
• Lead DBA for the upgrade of Oracle EBS R11.5.10.2 t R12.1.3 for CRP1, CRP2 and UAT in Solaris 10 and 11 environments.
• Migrate R11i and R12 instance from Solaris 10 t Solaris 11.
• Remediate Oracle Forms and Reports 10g custom programs
• Installation and configuration of Oracle R12 and 11i Application and databases.
• Applied patches RUPs, minipacks, family packs and bug fixes on Oracle EBS R12 and 11i Apps instances.
• Cloning and migration of Oracle EBS R12 and 11i Apps instances across multiple environments.

Environment Oracle Fusion Middleware Oracle Webcenter 11g, Oracle Weblogic, Oracle EBS R12.1.3, Oracle10gAS, Oracle Webcenter Portal 11g, Oracle 11gR2 RDBMS, Solaris 10/11

Confidential

• Plan and design the implementation of Texas Children's High Availability requirements with Oracle Dataguard 11g using Oracle Enterprise Manager Cloud Control 12c
• Setup and configure Oracle Enterprise Manager Cloud Control 12c for Enterprise database management, monitory and maintenance with Dataguard.
• Install and configure Oracle Weblogic 10.3.6 and repository database.
• Build HCMPRD Peoplesoft 9.1 Primary Standby database local in Datacenter and Secondary Standby database in remote Datacenter using Oracle Dataguard 11gR2 with OEM 12c.
• Configure Fast Failover between Primary and Standby Oracle 11gR2 databases.
• Implement Oracle 11g Dataguard Observer for seamlessly and automatic failover t Standby database in case of failure or disaster with Dataguard broker.
• Configure Peoplesoft 9.1 HCM application for Transparent Application Failover t Primary Standby in case of Disaster, as well as t Secondary Standby in case of Disaster in Primary Datacenter.
• Managed and troubleshoot issues, and work closely with Oracle DBAs and client end-users t faster resolution and documentation.

Environment Peoplesoft 9.1 HCM, Oracle 10g RDBMS, Oracle 11gR2 RDBMS, Oracle Dataguard, IBM AIX 7.1, Oracle Weblogic, and Oracle Enterprise Manager Cloud Control 12c

Senior Oracle DBA

IT Convergence Confidential

• Migration strategy for Oracle R12 EBS Production environment from Oracle On-Demand Datacenter t ITC Managed Datacenter
• Implementation and upgrade strategy for Oracle 10g SS t Oracle 11g IDM SS with Access Manager, and integration with Active Directory
• Lead the team in building new environments and coordination with offshore team
• Install and configure Single Sign-On using Oracle Identity Management Oracle Access Manager, Oracle WebGate and Oracle Internet Directory release 11g.
• Migrated Oracle EBS R12 from Oracle OOD t client datacenter.
• Integrate Oracle Internet Directory with Oracle E-Business Application R12.1.3 instance.
• Integrate Oracle Access Manager with Oracle OID and define policies.
• Integrate Oracle Access Manager with Oracle E-Business Suite Application 12.1.3.
• Integrate LDAP MS Active Directory with Oracle Internet Directory.
• Migrate EBS R12 instance from Oracle On-Demand Datacenter t ITC Datacenter.

Environment Oracle Fusion Middleware Oracle Identity Management Oracle Access Manager, WebGate, OID, Weglogic, Oracle EBS R12.1.3, Oracle 10g RDBMS, Oracle 11gR2 RDBMS, Oracle Dataguard, Oracle Linux

Confidential

• Exterran global leader in natural gas compression products and services and a premier provider of equipment and solutions for processing, production, air emissions and water treatment.
• Plan and design integration strategy of Oracle EBS instances.
• Worked with Functional and Development resources in reviewing and fixing various application and database issues/bugs.
• Lead the team in managing critical issues, and coordinating with client management with action plans t address critical issues and resolutions.
• Managing tasks between offshore and US resources for timely and crystal clear handover t ensure 24/7 operation.
• Migration of Oracle EBS 11i instance from OOD Oracle On Demand environment t ITC Managed Services.
• Maintained, managed and administration of Oracle R12 multi-node environment and 11i environment integrated with various applications such as KofaxMarkView, GRC, SOA/BPEL, Vertex and Hyperion.
• Installed and configured Fusion Middleware Weblogic with SOA/BPEL and Markview.
• Managed and troubleshoot issues, and work closely with client end-users t faster resolution and documentation.
• Manitowoc was founded in the lakeshore community of Manitowoc, Wisconsin, in 1902
• as a shipbuilding and ship-repair organization, and currently have operations in 26 countries around the world.
• Plan and design implementation strategy for Oracle EBS 11i upgrade t R12
• Upgrade of Oracle EBS R11.5.10.2 t R12.1.3 on DEV, TST and PROD instances for The Room Place.
• Upgrade of Oracle EBS R11.5.10.2 t R12.1.3 on DMWACI, TMWACI and PMWACI instances for Manitowoc.
• Primary DBA responsible for building and managing Oracle EBS R12 and 11i Release 10g RDBMS and 11gRAC databases.
• Installed, patched and upgrade databases from Oracle 11.1.0.7 t 11.2.0.2 DB versions.
• Installation and configuration of Oracle R12 and 11i Application and databases.
• Applied patches RUPs, minipacks, family packs and bug fixes on Oracle EBS R12 and 11i Apps instances.
• Cloning and migration of Oracle EBS R12 and 11i Apps instances across multiple environments.
• Install, configure and managed Oracle R12 MWA / WMS.

Environment Oracle EBS R12 12.1.3 Application, Oracle EBS 11.5.10.2, Oracle Fusion Middleware Oracle Identity Management, SOA/BPEL and Weblogic , Oracle GRC, Markview, Vertex O' Series, Oracle 10g RAC, Oracle 11gR2 RDBMS, Oracle VM, Oracle Enterprise Linux

Confidential

• GSL-Oracle R12 Project Implementation is t transform GSL operations t drive back int the business, and create a roadmap and global business process for GSL in preparation of eventual migration of North America and Global Locations ont Oracle EBS R12.
• Provide leadership in designing system architecture for PCI Compliance implementation
• Lead role in RAC database design, capacity planning, database tuning and system architecture
• Lead role in designing system architecture for EBS R12 implementation for North America, Canada, EMEA and South America.
• Provide training and mentoring for client DBA staff in management of R12 databases
• Conducted Oracle 11g Performance Tuning for application developers
• Developed coding standards, documented cloning process and database design procedures
• Installed and configured Oracle Weblogic 11g for SOA integration with Oracle EBS R12 instance.
• Responsible for building and managing Oracle R12 11gRAC ASM databases
• Oracle11g RAC ASM Database monitoring, performance, tuning and reorganization
• Installed, patched and upgrade databases from Oracle 11.1.0.7 t 11.2.0.1 DB versions
• Installation and configuration of Oracle R12 Application and databases
• Applied patches RUPs, minipacks, family packs and bug fixes on Oracle R12 Apps instances
• Cloning and migration of Oracle R12 Apps instances across multiple environments
• RAC t RAC, RAC t non-RAC and non-RAC t RAC cloning of Oracle R12 environments
• Setup and configure multi-node Oracle R12 environment in Dev and Test
• Configure Oracle EBS R12 environment for PCI Compliance
• Install, configure and managed Oracle R12 MWA / WMS.
• Maintained, managed and administration of Oracle R12 multi-node environment
• Management and monitoring Oracle R12 instance using Oracle 11G Enterprise Manager Grid Control.
• Migrate Oracle EBS R12.1.3 from 11gR2 RAC t Oracle Exadata V2.
• Install and configure Oracle GoldenGate for data replication.
• Configure data replication between Oracle Datawarehouse database and EBS
• Management of Oracle Exadata running a BI/Datawarehouse environment
• Prepare the R12 environment for PCI Compliance

Environment Oracle ERP R12 12.1.3 Application, Oracle 11gR2 RAC ASM, Oracle Exadata V2, Oracle 11G Enterprise Manager Grid Control, Oracle Enterprise Linux, IBM AIX

Confidential

• The Riverbed short-term engagement primary involves performance tuning of OBIEE Datawarehouse database.
• Provided the lead role in performance tuning of existing OBIEE Datawarehouse database.
• Generate AWR reports t monitor performance of OBIEE database.
• Generate trace files and tkprof output t further analyze poor SQL statement performance.
• Create materialized views t fine tune OBIEE reports.
• Modify init.ora parameters t further fine tune the database.
• Propagate performance tuning changes in DEV, TEST and Production environment.

Confidential

• The LMU short-term engagement involves upgrade of the current Oracle EBS11i 11.5.10.2 t R12.0.6.
• Provide the lead role in the technical upgrade of existing R11i t R12.
• Conducted testing and dry run t upgrade existing R11.5.10 instance t R12.0.4
• Developed and revised custom programs i.e check printing reports
• Upgrade Database 10.1.5 t 10.2.0.4
• Upgrade Oracle Applications EBS 11i t R12.0.6
• Oracle Forms and Reports 10g
• Upgrade of Oracle Discoverer 4i t Oracle Discoverer 10g
• Upgrade Oracle 9i t 10g database for Banner application
• Support user testing for Banner applications 8.2

Confidential

• The short-term engagement project is t provide point monitoring solutions by platform and leverage cost efficiencies within that approach which will result in maximized service availability and reduced outages caused by database problems.
• Re-implement the existing Oracle Enterprise Manager 10g Grid Control t allow monitoring and spanning of Applications, middleware and database management.
• Cleanup the existing Notification Rules configuration and implement Database Monitoring standards as per AvivaUSA requirement.
• Perform diagnostic, application and database health check on the current OEM Grid Control environment
• Create test planet and conduct testing in Dev, Test and Production environment.

Confidential

• The Apoll short-term engagement involves migration of the current Oracle 11i EBS environment t OATM.
• Provided the lead role in OATM database migration
• Migration of 2.3 terabyte Oracle 10G database t OATM
• Fine tune OATM migration
• Dry run and testing in Development environment t accommodate the 3 days windows allowed for the activity t complete.

Confidential

• Broadridge short-term engagement covers health check on the current Oracle 11i EBS environment.
• Oracle Applications environment health check
• JVM settings, Purging and archiving analysis
• Concurrent request management
• 11i Patchsets, Auditing and Security
• Log Analysis
• Oracle Database Health check
• Database I/ contention, Shared pool contention and utilization, latch contention, und utilization, instance parameters
• Security evaluation
• Backup and Recovery and Performance and Scalability
• Identify resource intensive SQL statements

Confidential

• Zachry R12 Implementation covers Purchasing, iProcurement, Project Contracts, EAM, iSupplier Portal and Discrete Manufacturing. The project goal is t migrate the existing Oracle 11i Applications t Oracle R12 with new setups and functionality.
• Lead role in designing system architecture for EBS R12 implementation
• Responsible for building and managing Oracle R12 instances
• Database monitoring, performance, tuning and reorganization
• Installed, patched and upgrade databases from Oracle 10.2.0.3 t 11.1.0.6 versions
• Installation and configuration of Oracle R12 Application and databases
• Maintenance and management of OracleR12 Dev, Test, UAT and production DBs
• Applied patches minipacks, family packs and bug fixes on Oracle R12 Apps instances
• Cloning and migration of Oracle R12 Apps instances across multiple environments
• Setup and configure multi-node Oracle R12 ERP environment in Production and UAT
• Maintained, managed and administration of Oracle R12 ERP multi-node environment
• Management and monitoring Oracle R12 instance using Oracle 10G Enterprise Manager Grid Control
• Configured and managed Oracle R12 Workflow

Environment Oracle ERP R12 12.0.5 Application, Oracle 10G Enterprise Manager Grid Control, Oracle 10G/11G Database, Red Hat Linux

Oracle 11i Apps DBA / Oracle DBA

Confidential

Nor' Easter Project is the largest project and consulting transaction to-date undertaken by CapGemini with an estimated of 250M over 2 years. The project goal is t provide support t Fairpoint in expertise, leadership and program management in full system development life-cycle in areas such as ERP Systems HR, Financials and SCM , OSS Provisioning, Activation, Inventory, Wholesale and Trouble , Network Management, MACC and Operation Centers Call Center, Data Center and NOC , prime integrator for CRM and BSS.

• Responsible for building and managing Oracle databases for the following applications: Oracle 11i ERP, Oracle IM/OID/SSO, MDSI Advantex, Remedy, Intergraph, Metasolv, Oracle Communications ASAP, Business Objects XI R2, Hyperion, Geneysis, Siebel 7.8, Informatica PowerCenter 8.11, Comverse Kenan/BP, NetCool/Proviso
• Configured, installed, managed and administer Business Objects XI application and DB
• Configured, installed, managed and administer Remedy ARS 7 and DB, High Availability and Load Balancing
• Database monitoring, performance, tuning and reorganization
• Cloning and migrating Oracle databases across different platforms
• Installed, patched and upgrade databases t Oracle 10.2.0.3, 10.2.0.2 versions
• Installation and configuration of Oracle 11i Application and databases
• Maintenance and management of Oracle11i dev, test, UAT and production DBs
• Applied patches minipacks, family packs and bug fixes on Oracle 11i Apps instances
• Cloning and migration of Oracle11i Apps instances across multiple environments
• Setup and configure multi-node Oracle11i ERP environment in Production and UAT
• Configured Oracle Database DataGuard environment for Oracle 11i database
• Maintained, managed and administration of Oracle11i ERP multi-node environment
• Configured and managed Parallel Concurrent Processing on Oracle 11i environment
• Configured and managed Oracle 11i Workflow and Oracle Discoverer 10g
• Configured and Managed Oracle Identity Management SSO/OID
• Integrated Oracle 11i ERP with Oracle Internet Directory and Single Sign-On SSO
• Environment Oracle 11i 11.5.10.2 Application, MDSI Advantex, Intergraph, Hyperion, Metasolv, Oracle Communications ASAP, Remedy, Business Objects XI R2, Siebel 7.8, Informatica, Comverse Kenan/BP, NetCool/Proviso, Oracle 10G/9i Database, HP-UX11 Unix, Windows 2003 Server, Sun Solaris 9

Confidential

Oracle Apps DBA / DBA Remote DBA

VeriFone Inc. is recognized worldwide as the trusted leader in secure electronic payment technologies. VeriFone has delivered POS/payment solutions t customers in more than 100 countries worldwide. The company offers the best and most advanced secure electronic transaction solutions available, including hardware, software and a full range of services for debit, credit, checks and smart cards. It has regional sales offices in North America, Latin America, the Caribbean, South America, Europe, Middle East, Africa, Asia and the Pacific Rim

• Provided technical support t the developers and users regarding database problems, bugs and patches
• Provided technical support t ERP, Clarify and JAVA developers in tuning SQL statements and batch programs
• Developed PL/SQL batch programs for uploading data from OLTP databases t Data Warehouse database
• Assisted developers in Oracle Forms and Reports programming
• Migrated existing Oracle9i databases t Oracle10g RAC database
• Database and schema creation and Database backup and recovery
• Database monitoring, tuning and reorganization
• Moving forms, reports, and database objects int production
• Database tuning using Oracle Trace event 10046
• Cloning Oracle Apps instances
• Systems Admin for Oracle Applications
• Deployment B universe files and LOVs t BOPROD repository database
• Maintenance and management of Business Objects B repository database
• Maintain, manage and administer Clarify CRM and Broadvision application
• Environment Oracle Applications 10.7SC, Business Objects, Oracle 10G RAC Database, Oracle 9i Database, Oracle 8i Database, Clarify Applications, Broadvision, AppWorx, HP-UX11 Unix, Windows 2000 Server, Red Hat Linux 8.0

Confidential

.

Oracle DBA/Technical Consultant/Trainer

• System Access is a leading financial software provider of customer centric universal solutions for financial service institutions worldwide. Headquartered in Singapore, System Access has regional offices serving the needs of customers in over 20 countries, across Asia Pacific, Europe, the Middle East and Africa. Its product SYMBOLS provides banking solutions such as Retail Banking, Corporate Lending, Wholesale Banking and Universal Banking.
• Provided technical support t the developers and users regarding database problems, bugs and patches.
• Performance tuning on Oracle Forms and Reports programs.
• Assisted developers in fine tuning SQL statements
• Migrated client database int off-site database in Manila.
• Setup SYMBOLS 8.2 environment for developers.
• Backup and restore of databases.
• Management and maintenance of Oracle Application Server Release 2.
• Maintenance and management of the different versions of Ceska databases.

Confidential

• Migrated client database int off-site database in Manila.
• Backup and restore of database.
• Setup and configuration of SYMBOLS 8.2 version application
• Maintenance and management of the different versions of EBH databases.

Confidential

• Performance tuning on Oracle Forms and Reports programs.
• Assisted developers in fine tuning SQL statements
• Provided technical support t the developers and users regarding database problems, bugs and patches.
• Setup and configuration of SYMBOLS 8.3 version application.
• Management and maintenance of Oracle Application Server Release 2.
• Maintenance and management of the different versions of MCB databases.

Confidential

• Provided technical support t the developers and users regarding database problems, bugs and patches.
• Performance tuning on Oracle Forms and Reports programs.
• Assisted developers in fine tuning SQL statements
• Setup and configuration of SYMBOLS 8.3 version application.
• Performance tuning of application and database.
• Management and maintenance of Oracle Application Server Release 2.
• Maintenance and management of the different versions of CDB databases.

Environment SUN Solaris 8, Red Hat Linux Advanced Server 2.1, Windows 2000 Server, Windows 2003 Server, Oracle 9i Database, Oracle 9i Application Server Rel2, Oracle 9i Developer Suite, Oracle 8i Database, Oracle Forms 6i, Oracle Reports 6i, Oracle 7.3.4 Database

Confidential

Oracle DBA/Team Leader and Technical Consultant

Project: Online Registration and Portal

• Online Registration and Database Migration
• Conducted Oracle 9i Training on PL/SQL, Forms and Reports and Database Administration
• Developed coding standards and naming conventions t be used in all the systems of PEZA including table names, sequence names, index names, constraints names, stored procedure, function names and program names.
• Supervised and led the team in the development of the eRegistration System including the Functional Analysis, System Analysis and Design and the integration of the eRegistration System int the existing PEZA website using Oracle Forms9i and Oracle Reports9i
• Installation and configuration of the Oracle 9i database, Oracle 9i Application Server, as well as the Linux Advance Server t be used for the development and production.
• Installation and configuration of Linux Advanced Server and Oracle 9i Backup database.
• Migrated existing Oracle 8i database t Oracle 9i database. This task includes the migration of the existing PEZA Registration System int the Oracle 9i production database.
• Environment Red Hat Linux Advanced Server 2.1, Oracle 9i Database, Oracle 9i Application Server Rel2, Oracle 9i Developer Suite

Technical Consultant for Confidential

• Training and Technical Consultant
• Provided technical support t developers on Oracle11i Order Management reports customization.
• Prepared exercises for the topics discussed.
• Conducted remote training sessions on Oracle SQL/PLSQL, Oracle Forms 6i and Reports 6i.
• Conducted remote and on-site training sessions on Advance Oracle Forms 6i and Reports 6i.
• Conducted remote and on-site training sessions on Oracle8i DBA Fundamentals I.
• Conducted remote and on-site training sessions on Oracle8i DBA Fundamentals II.
• Conducted remote and on-site training sessions on Oracle8i DBA Performance Tuning
• Made sure that each topic discussed is well understood by the trainees.
• Installed and configure Oracle9i Database on Red Hat Linux Advanced Server 2.1.
• Environment Red Hat Linux Advanced Server 2.1, Oracle Financials 11i, Oracle 8i Database, Oracle 9i Database, Oracle Forms 6i, Oracle Reports 6i

Oracle DBA/Systems Analyst Confidential

Renardet S.A. Consulting Engineers headquartered in Geneva, Switzerland is a consulting company that provides consulting services t financial institutions such as World Bank, Asian Development Bank, AUSAID and among others.

Confidential

• Implemented information systems for the financial and project management application requirements of the project. The project involved the development of a Project Financial Information System for the Highlands Road Maintenance Group of the Department of Works, Papua New Guinea DOW , using Oracle's development tools and Oracle database, and upgrading of DOW IT staff technical skills through Oracle Training Program.
• Training Instructor on Oracle Database Administration and Oracle
• PL/SQL, Forms and Reports programming
• System analysis and design development and database design of PFIS from an Oracle Application 10.7 GL, AP and AR modules.
• Program and debug screen and report modules needed by the system.
• Conducted client presentations t senior management levels of the department.
• Maintained and managed PFIS Database.
• Conducted technical training on Oracle PL/SQL, Forms and Reports
• Conducted technical training on Oracle Database Administration particularly installation on SC UNIX platform, creation and database management, backup and recovery, and troubleshooting database problems.
• Conduction technical training on SC UNIX including installing, configuration, backup and recovery procedures.

Environment SC Unixware 7.01, Developer 2000 Forms and Reports, Oracle 7.3.4 Database, Oracle Financials 10.7

Confidential

• A client/server application that supports the activities of the National Road Traffic
• Survey Program and DTS which has the main objective of developing a flexible and sustainable system for the road traffic data collection and monitoring in the Vietnam Road Authority.
• System Analysis and Design for the application.
• Developed programs using Oracle Forms and Reports.
• Conducted Oracle Training SQL/PLSQL, Forms/Reports and DBA
• Developed programs using Visual Basic 6, Map Object and ESRI GIS
• Prepared the Acceptance Test Plan and User Manual.

Environment Oracle RDBMS 9i, Oracle Forms/Reports 9i, Visual Basic 6, Sybase ASE 12, GIS Arcview3.2, MapObjects 2, Win2k Server

Project: Procurement and Supply Information System, Location: Philippines

• The Procurement and Supply Information System PSIS for the Property,
• Procurement and Transport Services Division of the National Economic Development
• Authority NEDA under the Administrative Management Development Project AMIDP involves conversion of hard copy data t electronic data and establish link with related systems. A client/server application designed t provide the agency the means t effectively monitor the status of acquisition, utilization and disposal of supply, property and vehicle.
• System analysis and design development and database design.
• Managed client deliverables, meetings and presentations.
• Maintained and managed PSIS Database.
• Developed programs using Oracle Forms 6i and Reports 6i.
• Prepared the Acceptance Test Plan and User Manual.

Environment Win2k Server, Oracle 8i Database, Oracle Forms and Reports 6i,TOAD

Confidential

Oracle DBA/Systems Analyst/Programmer

Confidential

• The Ministry of Education of Singapore implementation of an integrated system that monitors students and courses movement and allocation for primary and secondary schools, junior colleges, and centralized institutions, the batch and reports module were designed and developed. Software used were SQR and Oracle under Windows Platform. Data is converted using PL/SQL under Unix.
• Created temp tables t handle Data Conversion.
• Created stored procedures and data scripts for data validation using Oracle PL/SQL.
• Load data from Legacy system t Oracle database.
• Maintained and managed Oracle database by doing cold backup and creating UNIX scripts for backup procedures.

Environment SUN Solaris 5.8, Red Hat Linux 7.1, Oracle 8i database, Win2000 Server

Confidential

Oracle DBA/Senior Oracle Programmer

Confidential

• Headstrong, formerly James Martin Company, is a global consultancy with a 20-year track record of providing clients with value-based solutions across: Consulting, System Integration and Application Outsourcing.
• The DFI-Hong Kong Merchandising System HKMS Project is a custom-built application of a common merchandising platform for the three banner operations of a holdings firm in Hong Kong. This is a full life cycle project that re-uses the Core Records implemented in Franklins, Australia and incorporates different merchandising related transactions such as purchasing, inventory, promotions and financials. This als involves development of interfaces between HKMS and other standard business systems.
• Developed programs for screens and reports modules needed by the system.
• Impact analysis for clients change requests.
• Performance tuning for batch programs, screens and reports.
• Maintained and managed HKMS database.
• Created batch processing programs stored procedures, functions and packages .

Environment HP-UX Unix, Win98, Oracle 8i database, Oracle Designer 6, Oracle Developer Forms 6.0 and Reports 6.0

Confidential

• The project involves customization and creation of forms and reports for Department of Transportation and Communication DOTC implementation of Oracle Financials namely Oracle GL, Oracle Payables, Oracle Receivables and Oracle Assets.
• Maintained and managed Oracle database includes cloning and creating new DB.
• Developed programs for screen and report modules General Ledger, Accounts Payable and Accounts Receivable .
• Customization of reports in Oracle Payables, Oracle Receivables and GL.
• Impact analysis for clients change requests.
• Performance tuning of reports.

Environment NCR Unix, Win98, Oracle Financials 10.7, Oracle 7.3.4 database, Oracle Developer 2000 Forms and Reports

Confidential

Confidential

Oracle DBA/Senior Oracle Programmer

• Implementation of Web-based Application Systems, Database Migration, and Training and Transfer of Skills for the Department of Budget and Management.
• The project involved the creation of a prototype Corporate Portal for the
• Philippine Government's Department of Budget and Management DBM thru the web-deployment of four key application systems using Oracle's WebDb tool and Oracle 8i database.

• Budget Preparation and Management System BPMS
• Government Manpower Information System GMIS
• Manpower Management Information System MMIS
• Document Tracking System DTS
• DECS School Building Information System
• Developed a web-based HWI/SRP Monitoring System, Accounts Payable, LGU AIP Monitoring System and SEMP LOAN Monitoring System.
• Creation and maintenance of Oracle database.
• Migrated table and data from Sybase t Oracle 8i.
• Maintained and managed BPMS, GMIS, and MMIS databases.
• Developed a database design create tables, constraints and indexes.
• Developed programs for the system SCREENS, REPORTS CHARTS .
• Performance tuning for batch programs, screens and reports.
• Environment Win NT4, Oracle8i database, Oracle WebDB, Oracle Designer 6,Oracle Forms 6.0 Reports 6.0, Oracle Reports Server

Confidential

• A client/server application designed t monitor the attendance of employees of SUN Microsystems Philippines. It includes filing of leave overtime and generation of leave credits.
• System analysis and design which includes ERD and Dataflow Diagrams.
• Maintained and managed AMS database.
• Development of screens and reports needed by the system.

Environment SUN Solaris 5.8, Red Hat Linux 7.1, Oracle 8i database, Win2000 Server

Confidential

• System analysis and design which includes ERD and Dataflow Diagrams.
• Maintained and managed CAS database.
• Development of the system screens and reports

Environment SUN Solaris 5.8, Red Hat Linux 7.1, Oracle 8i database, Win2000 Server

Confidential

• A client/server application designed t monitor inventory of tapes used by
• Central CATV, Inc. SkyCable , one of the top cable companies in the Philippines and
• Scheduling timeslots for each channel.
• Performed system investigation and conduct interviews with the users.
• Developed database design create tables, constraints and indexes.
• Maintained and manage TLMS database.
• Developed programs for screen and report modules needed by the system.
• Performance tuning for batch programs, screens and reports.

Environment Win95, Oracle 7.3.4 database, Oracle Designer2000, Oracle Developer 2000 Forms and Reports 4.5/2.5

Confidential

• The project involved the creation of a prototype system for the Land Registration Authority.
• Developed programs for the Prototype SCREENS and REPORTS

Environment Win95, Oracle 7.3.4 database, Oracle Developer 2000 Forms and Reports 4.5/2.5

Confidential

• A client/server custom-built application designed t promote investments in the Philippines by the Board of Investments.
• Creation and maintenance of Oracle database.
• Developed database designed create tables, constraints and indexes.
• Developed programs for screen and report modules needed by the system.

Environment Win95, Oracle 7.3.4 Database, Oracle Designer2000, Oracle Developer 2000 Forms and Reports 4.5/2.5

Confidential

• The project involved updating of Oracle Forms and Reports of the following systems used by Central CATV, Inc. SkyCable , one of the top cable companies in the Philippines t make it Y2K compliant:
• Billing System, Payroll System and Inventory System
• Revised programs of screen and report modules t become Y2k Compliant

Environment Win95, Oracle 7.3.4 Database, Oracle Developer 2000 Forms and Reports 4.5/2.5

Certifications

• Oracle E-Business Suite R12 Applications DBA OCP
• Oracle E-Business Suite R11i Applications DBA OCP
• Oracle 10g Database Administrator OCP
• Oracle 9i Database Administrator OCP