OBJECTIVE: To obtain a challenging position as an Oracle Database Developer/Administrator/Support.

SUMMARY:

• DBA Database developer and administration with 12 years' experience in ORACLE primary and another 6 years experience in MS SQL secondary database server.
• Oracle certified DBA.
• With 9 years' background experience in telecommunication and 5 years' experience in insurance and other area.
• Proficient/expert in Data modeling, PL/SQL, performance tuning, database administration.

KEY SKILLS:

Strong experience with Red Hat Linux, Solaris, Windows, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, Veritas Cluster Service, RAC, ASM, RMAN, Flashback, Data Guard, Replication golden gate , Partition, Oracle Enterprise Manager, export/import, ERWIN, database schema /structure design, database installation/upgrade, Performance tuning in instance and application alert log, initial parameters, AWR, ASH, sql profile, pl/sql profiler , SQLs and PL/SQL packages, Query optimization, Backend Programming, Oracle functions, triggers, stored procedures using cursor, ref cursor, collections, objects, self join, connect by prior, merge, multi-table inserts, global temporary tables, oracle analytic function, dynamic SQL, bind variables and sys context , Materialized Views complete refresh/fast refresh , Query rewrite, shell scripts Unix K shell, sed and awk and Java.

EXPERIENCE:

Confidential

Oracle Database Developer

• Contributed to the feature delivery using agile methodology in releases on key modules and pricing impact projects such as core price engine development. Pricing rule setups, discount setup, promotion setup and copy procedure on GCP inventory retrieval etc. New start and MACD core pricing engine development covers pricing on MIS, AVPN transport, access, bvoip and CPE CSU/DSU, routers and router cards . Lead design and development.
• Responsible for database design and modeling. Create database objects and constraints. Use MV and application API to have check constraints across tables.
• Create/maintain K shell script to synup system.properties URLs against connectivity grid for given release and environment and send alert for any mis-match URL
• Create/maintain generic K shell export/import script to migrate DB from GCSM interface
• Lead create/maintain K shell script/cronjobs in handling data load, report generation in CMDB and with interfaces such as CSI, PCGlobal.
• Lead all data load efforts SOC, PSOC, ABNE, EAGLE Summit . Create process and automate scripts to load data.
• SQL Performance tuning of Adopt using sql profile, AWR, profiler report and reproduce. Reduce the number of function calls in PL/SQL package, rewrite hang/trouble SQL using merge, subquery factoring and hint. Resolve connection issues, deadlocks. Fix indexes.
• Lead, performed DBA tasks such as creating databases, monitor database performance, locks, and space usage.
• Set up goldengate replication with interfaces.
• Support release and DMCR. Give permanent fix on production and ST, BST/UAT tickets on a daily base.
• Work with client, requirement, and system test team on better understanding client needs, requirement and assist testing.
• Worked on backend documentation on Adopt functionality areas
• Conduct knowledge sharing sessions and code reviews.
• Lead code refactoring and implement of Oracle features/new features

Confidential

Oracle Database Developer/Administrator/ consultant

• Contributed to CPMR Corporate Product Master Repository database load. Participate in context load for tables including product type, product type distinction, product market region, product market segment, product parent partner affiliation, product characteristics product characteristics product and blind keys update. Responsible for database load to product, services and provision module in CPMR. CPMR database load use k shell, awk script to auto-format the original delimited files into fixed-format, explicit column positions data source files, auto-generate the sql loader fixed-format explicit column position naming control files using with clause, analytic functions and query to user tab columns, external tables for load source data to staging tables. PL/SQL to load data to CPMR target database using bulk operation. Merge, multi-table insert all, DBMS ERRLOG package and LOG ERRORS to suppress the exceptions at the row level instead of the statement level and the ability to recycle the input rows with foreign key violations.
• Responsible for federation of CPMR to FCPMR. Identify the mapping rules for data in CPMR to PMT PR, PMT PSCBR, PMT PRPAK and PMT PRKWD in FCPMR. Capture product change events using database trigger process. Enable the full refresh by entering all product ids in the master activity log MAL table. Use overloading of update mal procedure in MAL package to have calls with different signatures. Create reusable database access procedure in MAL package. To avoid the mutating table error, revisit the requirement to remove the reference to the table that owns the low-level trigger. In the exception handler of the row-level triggers and MAL package, design and implement the handler to log the error to database table, as well as to raise the error to the client.
• Performance tuning of CPMR Oracle 10g and Oracle 11g database using metrics, statspack, benchmark, performance and advisor tools in OEM. Performance tuning of CPMR indexes, tables, SQL's and store procedures using b-tree indexes, bit-map indexes, join order, constraints, merge, multi-table insert all, Oracle query optimizer, TKPROF, SQL tuning tools in OEM etc.
• Performed DBA tasks such as creating databases, RAC database maintenance, Perform space management, database restore/recovery, database error fixes and monitor index usages. Perform DB patches/upgrade. CPMR databases are setup on Linux 64-bit.
• Support release, production ticket investigations and production fixes.

Confidential

Oracle Database Developer/Administrator/ consultant

• Contributed to the feature delivery in releases on key modules such as trailer system setup, office site plan setup, office recovery operations, manage external data files, ndr reports such as inventory reports and recovery reports.
• NDR backend file monitor process uses Unix K shell, sed and awk. NDR Store Procedures and triggers use cursor, ref cursor, collections, objects, self join, connect by prior, merge, global temporary tables, oracle analytic functions and regular expression SQL. NDR materialized views store the result of the query for the facility count in a database segment and eliminate the need to re-execute the query in real time.
• Responsible for database design and modeling. Create tablespaces, database objects and constraints.
• Performance tuning of NDR Oracle 10g and Oracle 11g database using metrics, statspack, benchmark, performance and advisor tools in OEM. Performance tuning of NDR indexes, tables, SQL's and store procedures using b-tree indexes, bit-map indexes, join order, constraints, object tables, nested tables, merge, MV, global temporary table, parallel hint on full-table scan, Oracle query optimizer, TKPROF, SQLTXPLAIN and SQL tuning tools in OEM etc.
• Performed DBA tasks such as creating databases, set up flashback, set up RMAN and set up Data Guard. Perform space management, database restore/recovery, database error fixes and monitor index usages. Perform DB patches/upgrade. NDR databases are setup on Linux 64-bit.
• Support release, production ticket investigations and production fixes.

Confidential

Oracle Database Administrator/Developer consultant

• Contributed to the feature delivery in releases on key modules such as WorldRoute process, generate OCRM, Term Rule, TOD Costing/Routing, Bilateral and 12 AcuWorld Report Store Procedures. AcuWorld Report Store Procedures and triggers use cursor, ref cursor, collections, merge, global temporary tables, oracle analytic functions and dynamic SQL.
• Set up AcuWorld reports in cronjobs using K shell.
• Responsible for database design and modeling user ERWin. Create tablespaces, database objects and constraints.
• Performance tuning of AcuWorld Oracle 9i and 10g database. Identify high-resource SQLs. Fine tuning the SGA/PGA, indexes, database I/O. Introduce index scan option within OCRM processing using optimizer index cost adj at session level. Convert non-partitioned AcuWorld report tables to partitioned tables using online table redefinition. Introduce table compression.
• Perform DBA tasks such as write script using Unix K shell, sed and awk to auto startup/shutdown DB, to auto export acuworld permanent and reference tables and to analyze tables. Perform database restore/recovery, database error fixes, manage acuworld DB tablespaces, create DB/create new instance and perform DB patches/upgrade. AcuWorld DBs are setup on Solaris 10.
• Support release, production ticket investigation and production fixes.

Confidential

Oracle Database Administrator/Developer consultant

• Contributed to the feature delivery in releases on key modules such as DVA automation, PSAT, Sots Feed, Auto Disconnect, Worklist, Worklist/Order level purge/archive, CTB and GCNOTE etc. help with requirement, development, system test and UAT. Sots Feed and GCNOTE uses unix K shell and Perl. EFMS store procedures and triggers use cursor, ref cursor, collections, objects, dynamic SQL and global temporary tables and sys context. EFMS materialized views store the result of the query for the worklist metrics in a database segment and eliminate the need to re-execute the query in real time.
• Responsible for database design and modeling. Create tablespaces, database objects and constraints.
• Performance tuning of EFMS Oracle 8i and Oracle 9i database. Fine tuning the SGA, partition, indexes, database I/O. Rewrite of complicated application SQLs which access big tables. Recommend the use of bind variables.
• Support production ticket investigations and production fixes.
• Perform DBA tasks such as release store procedures/triggers, PL/SQL debugging, database error fix, database replication and MV maintenance, database user/role/object management, monitor sessions/locks/long-running queries, check alert log/audit trail and manage rollback segment etc.
• Join DB table re-org, database backup/archive/restore/recovery, database migration, generate or analyze database statistics etc. EFMS DBs are setup on Solaris 10.

Confidential

Developer

• Maintain IRecruiter, an online hiring management product. The product is built on open standards in term of platform, tools and software development methodology, using cutting edge technologies such as J2EE framework, XML, XSLT, object oriented technology and feature-driven development process, etc.
• Designed and Developed Vendor Manager System, which facilitates vendors who has partnership relationship with Comrise to submit candidates to the opening jobs posted by IRecruiter. The system provides updates to the vendor their candidates' profiles. It also accepts cover letter resume uploading, create candidate profile into IRecruiter and establish linkage with IResume. Vendor Manager is implemented on JRun J2EE application server, using HTML, DHTML, JavaScript, CSS, JSP and XML/XSLT at the Presentation layer and EJB entity/session beans, JDBC at the middle layer and use SQL 7.0 functions, triggers and stored procedures at the backend layer.
• Developed IRecruiter DocuMerger, a message driven component. DocuMerger receives incoming XML message with structured data and processing instructions, retrieves the destination document template from the template pool according to the processing instruction, populates the destination document template with data embedded in XML messages and generate destination document. Document Merger behavior is controlled and set by property file. The component is implemented using Java, Jaxp, Xalan XML Parser, XSLT transformation, etc.
• Maintain CSS Candidate Self Service and Referral System using JRun, Java Servlet, JSP, EJB, Java, JDBC, XML/XSLT and SQL 7.0 functions, triggers and stored procedures.
• Participated in the development of iResume, a powerful and comprehensive resume capture and candidate creation tools. IResume receives and parses job seekers' resumes in various formats word, rtf, text, html, pdf, tif, etc , extracts key information such as name, address, contact, skill, education and employment information and generates HR-XML compliant candidate profile, it also provides flexible connectors such as HTTP, socket etc to integrate with external systems. IResume is implemented as a rule-base, message-driven using XML as message protocol engine, which provides input and output connectors through tcp/ip, http protocols making it very flexible to be integrated with external systems. The rule-based engine can learn different formats and layouts of resume body and parse extract information very accurately. IResume is a backend system using Java, XML and Microsoft Messaging Queue, Regular Expression technology.
• Developed Dell Order Entry Project, an E-Commerce on-line shopping site of Dell computers. The system simulates a real-world shopping cart and maintains information of Dell computer catalog and in-stock computer listing as well as purchasing order and shipping details. Dell Order is implemented using JavaScript, HTML, DHTML at the front-end client-layer and ASP, Microsoft Site Server Commerce Edition and SQL Server at the backend layer. Dell Order Entry was transported to the customer for hosting maintenance after release of the project development.
• Participated in the development of ECI web application, an employment Consultancy Inc Personality Assessment Project. ECI maintains a pool of questions. A test taker can logon to the system and take a test. ECI generates the score based on the position the test taker is looking for and the profile algorithm. A report and a list of interview questions will be generated too. ECI maintains information of Questionnaire, Job Category, Job Trait, ECI User, Client, Client Admin, Test Taker, Test Answers, scoring algorithm and Test Result Generate Algorithm. ECI also provides Archiving of Test Taker, Test Answer, Score history through implement of trigger. The system is implemented using HTML, DHTML, VBScript, JavaScript at the front-end presentation layer, ASP, VB COM at the middle-tier business layer and SQL 7.0 functions, stored procedures, triggers at the backend database layer. Went through full life cycle of the web ECI development including use case analysis, Entity-Relation Database design including constraints and deployment architecture design. Went through SQL 7.0 database Administrations including ECI database creation configuration, Backup, Recovery, Tuning, and Job Scheduling.

Confidential

Web / Database Developer

• Responsible for full life cycle of web application development
• Designed and developed Web-based BoxEye System, which enables Shipping Lines to up-date, store, report and manage their container assets worldwide, in real time. BoxEye is operated by Samudera Singapore to track the statuses of their owned containers within Asian countries. BoxEye not only records container status changes, but also validates/audits the status change data updates into the system according to movement routing logics. BoxEye also provides Analytical reports to meet management screening/decisions. The system maintains container specification, container leasing histories and container movement and status information. BoxEye is implemented on Microsoft IIS using HTML, DHTML, VBScript, JavaScript at the presentation layer and ASP, SQL 7.0 stored procedures, functions, materialized views, triggers at the backend. Went through full life cycle of the web BoxEye development including user requirement/movement routing logic analysis, Entity-Relation Database design including constraints and deployment architecture design. Went through SQL 7.0 database Administrations including SQL 7.0 database installation, BoxEye database creation configuration, Backup, Recovery, Tuning, Job Scheduling and EDI data transfer/conversion.
• Designed and developed web-based PIWEB System, a container production inspection system. PIWEB is a web-based reporting program for Sinspec customers purchasing new containers. PIWEB updates customer orders facilitates Sinspec surveyor at remote locations to update inspection report pertaining to a specific customer order. The inspection report includes inspection date, containers accepted, containers rejected, lines of production issues such as defects, location of the defects, detail of the defects and images on the defect. PIWEB also provides Dimension Check, Roof Camber Check etc document uploading to the server in formats of WinWord document, Excel sheets and image pictures. PIWEB is implemented on Microsoft IIS using HTML, DHTML, VBScript, JavaScript at the presentation layer and ASP, SQL 7.0 stored procedures, functions and triggers at the backend. Went through full life cycle of the web PIWEB development including user requirement analysis, Entity-Relation Database design including constraints and deployment architecture design. Went through SQL 7.0 database Administrations including SQL 7.0 PIWEB database creation configuration, Backup, Recovery, Tuning, and Job Scheduling.
• Maintain and upgrade CMRC CIMC system, a container repair cost management system. CMRC CIMC are implemented as a client/server on VB 6.0 and SQL 7.0. Duties includes: reformat/transform of the exported data in txt using Unix command/scripts and import into SQL 7.0 database user interface VB client-side form redesign reshape and SQL statement amendment/upgrade according to updated user requirements. Went through SQL 7.0 database administrations including SQL 7.0 CMRC CIMC database configuration, Backup, Recovery, tuning and job scheduling.
• Final Year Project 04/99 12/99 Developed web-based Virtual Classroom system, which is specifically designed and developed to simulate the real world classroom on the Internet. The virtual classroom system is built on a client/server architecture, providing distributed presentations over the internet, which involve multicasting a class presentation via audio, video, shared text, graphics and web pages to participants at their computer desktops. The virtual classroom system allows participants lecturer and students to interact with each other through audio video multicasting, online chat, shared whiteboard and synchronized web browser, it enables side conversations among participants, and it also provides asymmetrical control. The system is developed using Java technology, such as Java Swing, JDBC, JSDT, JDK1.2, and Java Media Framework etc.

Confidential

Web / Database Developer

• Responsible Web programming using Cold Fusion, ASP, VBScript, JavaScript, HTML/DHTML
• Developed web-based software systems such as Client ISO Management System, Kenreal Property Management System, Car Mall Management System and Order Entry System using Cold Fusion, HTML, Microsoft Access
• Developed Car Mall Management System using ASP, VBScript, JavaScript, HTML
• Developed Catering Management System using Visual Basic 5.0 and SQL Server 6.5.
• Developed S A Holiday Tour Operator System under Windows NT environment using Microsoft VB 5.0, VBScript, SQL Server 6.5, ASP and IIS 4.0. 01/98 08/98