INFORMATION TECHNOLOGY PROFESSIONAL

Expertise: System Analysis & Design, Oracle or Database Development, Oracle versions 7-11g, Oracle Forms (6i-10g) & Reports,
PL/SQL, Unix, Project Lead/Management.

Highly experienced, deeply driven, motivated system analyst/software engineer with 11+ years of track record in Oracle database (from ver. 7 to 11g) and system development. Has worked with various industry such as local government agencies (created, designed and partially coded an Accounting System, that is modular and integrated), manufacturing, software consultancy, utilities, telecom and insurance (function focus: CLAIMS (Pension/Annuity), New Business, Policy Administration, Underwriting, Agency, partial Account for Agent commission) . Led a big team of software developers, database administrators, quality assurance analyst and document analyst. Extensive involvement in the different stages of software development, maintenance and support. An Oracle Certified Associate and pursuing Oracle certifications (OCP/OCM/OCE). Have experienced in doing minor DBA roles/jobs.

Technology Snapshot:
Software: Oracle PL/SQL, Oracle versions 7.0, 8.04,9i, 10g and 11g, Oracle Forms 6i and 10g versions, Oracle Reports, Digital UNIX OSF/1 4.0B/4.0D, MS-DOS 2.x–6.22, Microsoft Windows ver. 3.xx/95 xx/98, Intel/Alpha Based Microsoft Windows NT Workstation/Server Oracle SQLNet, Oracle Developer Server 1.6.1, Oracle WebServer 2.1.1, Oracle Jinitiator 1.1.7.27, Oracle Developer 2000 Forms Release 4.5, 6.0,6i, Oracle Designer 2000, Seagate Info, Crystal Reports, Microsoft Office products, Connectivity and Terminal emulation software like Xcursion, Kea!Term, Delphi4.0/5.0, PowerBuilder 8.0, Citrix, Putty, PVCS, SmartFTP, Microsoft Visual SourceSafe, Oracle Developer SQL Data Modeler, Visual Studio

RDBMS: Oracle Enterprise Server Edition 7.x.x.x (with Distributed, OPS, EBU, and Replication implemented), ROSS, Oracle Database 8, 9i, 10g and 11g, AS400
Hardware: DEC Alpha Based Machines 4100/8200 models, Intel Pentium, IBM PC and Compatibles, IBM AIX, IBM Power7

• Product/Software Development
• Data and Application Architecture
• Product Support/Maintenance
• Familiarity with Agile Development
• Structured System Development/Information Engineering
• Knowledge in Oracle EBS (thru online reading)

Confidential,USA OCTOBER 13 – Present
Oracle Developer

Baker is Taylor is the world’s largest distributor of physical and digital content and value-added services.

• Lead and perform data analysis for projects and on-going application enhancements. Develop lasting conceptual and logical data models and designs that support current and future business requirements. Identify and document the interactions between data and business/application processes. Participate in and lead logical data model discussions.
• Design and develop physical datamodels and schemas for projects and on-going application enhancements. Write and executes stored procedures, triggers, and complex cursors. Ensure data integrity, security and performance through review of physical data models against application processing and architectural designs.
• Lead and perform database-related testing in conjunction with other application testing efforts. Coordinate the implementation of database objects, tables and stored procedures into production. Support development efforts, including consulting on the design and execution of all data-related tasks.
• Support and perform the resolution of production application dataissues, Oracle upgrades and maintenance. Contribute to projects, enhancements and conversions by writing and maintaining Oracle procedures, functions, and packages.
  Recommend improvements to or replacement of application databases, data processes and data modeling tools.

Confidential,Malaysia JUNE 2010 – JUNE 2011
MATADOR SINGAPORE JUNE 2009 – JUNE 2010

Confidential,Senior System Analyst/Oracle Developer

Hong Leong Assurance Berhad (HLA) is one of the largest insurance companies in Malaysia. It is a well-established and respected Malaysian brand offering financial planning and protection solutions to meet the various needs of Malaysians at different cycles of their lives.

Extensive exposure in New Business, Underwriting, Claims(Pension, Annuity, GMAT, Death, TPD, PPD and other claims) and Policy Servicing, Unit Link module, Group Life System. Traditional and Takaful Insurance. Minor knowledge in Finance/Accounting. Minor knowledge in General Insurance

• Provided effort needed in the changes or enhancement required by the user particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others
• Produced technical designs and specifications from the functional requirements, development of functional and technical specifications into working application modules in addition to completing documentation and testing. Ultimately working with other developers to incorporate code into a larger application
• Solved issues raise by our end-users, doing so would include investigation on how and why the bug had occurred (root cause analysis), rectifying the problem, testing and documenting particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.
• Analyzed changes, foresee impact to the totality of the system and business in order to minimize possible risks
• Assisted any member of the team in solving an issue
• Monitored user requirements and sees to it that the RFA’s assigned are delivered on time
• Monitored the performance of the injected programs, provided solution if in case the injected program caused system slowdown

Confidential,
System Analyst/Oracle Developer JUNE 2007 – MAY 2009

A company that offers a single end-to-end Insurance Solution that covers all lines of business: Individual Life, Group Life, Investment Linked and General. It spans across functions like illustration, quotation, new business, policy servicing, claims, agency management, commission and benefits, accounting and services. The main business is to help Insurance Companies to strategize and operate by leveraging on Information Technology, a key enabler to achieve transformational growth through Operational Excellence and Innovation.

• Produced technical designs and specifications from the functional requirements, development of functional and technical specifications into working application modules in addition to completing documentation and testing. Ultimately working with other developers to incorporate code into a larger application.
• Provided effort needed in the changes or enhancement required by the user particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.
• Solved issues raise by our end-users, doing so would include investigation on how and why the bug had occurred (root cause analysis), rectifying the problem, testing and documenting particularly on Claim Modules (Pension or Annuity, Maturity), New Business, Agency, Policy Administration, Agent’s Commission accounting entries, Underwriting and others.
• Analyzed changes, foresee impact to the totality of the system and business in order to minimize possible risks
• Converted some Oracle Forms 10g version to 6i version (Security Forms).
• Assisted any member of the team in solving an issue
• Provided support for product enhancements to meet the customers’ requirements.
• Designed, created and executed test cases based upon business requirements and system requirements to validate system functionality.
• Analyzed and documented test results, investigated discrepancies and tracked issues.
• Helped in takafulization (Conversion of some conventional insurance terms to Islam-accepted insurance word/s) forms for Islamic Insurances.
• Monitored the performance of the injected programs. (Minimal fine tuning experience)

Confidential,
Senior Software Engineer JULY 2005 – JAN 2006

Accenture is a global management consulting, technology services and outsourcing company. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world\'s most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments

Confidential,
SC GAS is a subsidiary of Southern Company, the premier super-regional energy company in the Southeast United States. The century-old company is known for its excellent customer services, high reliability and competitive prices and was rated No. 1 among electric and gas utilities on Fortune Magazine’s Most Admired Companies. Southern Company GAS is one of Georgia’s largest natural gas providers, serving approximately 200,000 customers with a commitment to providing competitive prices and the highest level of service.

• Gave aid to Accenture Business Services for Utilities client in Canada
• Handled RMT’s (Request Management Tool) for Unix and Oracle PL/SQL
• Prepared Detail Design, Test Plans and Test Scripts for every RMT assigned
• Created, modified, tested and fixed bugs and errors in Unix and PL/SQL
• Monitored user requirements and made sure that the RMT assigned is delivered on time
• Provided support for product enhancements that meet the customers’ requirements
• Designed, created and executed test cases based upon business requirements and system requirements to validate system functionality
• Analyzed and documented test results, investigated discrepancies and tracked issues
• Performed application fine tuning

Confidential,Philippines FEB 2000 – JULY 2005
Project Manager/System Analyst

Cytronics International Inc. (CII) is an information technology (IT) services Company established back in 1988. It was founded by professionals having a combined total of over 300 man-years of comprehensive IT experience. It was established primarily as an organization that specializes in providing IT manpower resources to various organizations.

Confidential,
Local Government Information System (LGIS) is composed of 30 applications, categorized as follows: Revenue Generation, Financial Management, Administrative Support Planning and Development Building Permit, Barangay Operations, Legislative Management, Point of Payment System and Executive Information System.

• Analyzed, Designed and partially coded a full Accounting System that is modular and integrated (captures the following modules: Account Receivable, Account Payables, General and Subsidiary Ledger, Cash Management, Fixed Asset and others).
• Produced technical designs and specifications from the functional requirements, development of functional and technical specifications into working application modules In addition to completing documentation and testing ultimately working with other developers to incorporate code into a larger application. Such application/system are: Accounting System, Procurement, Inventory, Document Tracking, Public Safety, Asset Management, Cash Collection and other systems.
• Provided progress or status reports to the project’s consultant, these include problems encountered during system development phase
• Ensured relevant technical specifications and processing information of integrated solutions are communicated to the interface systems teams and operation teams
• Involved in an end-to-end solution design, development, project management, testing and roll-out
• Designed, created and executed test cases based upon business requirements and system requirements to validate system functionality
• Analyzed and documented test results, investigated discrepancies and tracked issues
• Facilitated small to medium size group meetings for information gathering and problem solving
• Elicited requirements thru facilitated workshops, interviews, review of existing systems and/or business documents and feedback loops to customers, users and managers
• Collaborated with software architects/DBA to develop both high level and detailed application models that meet the business needs
• Proactive in identifying inefficiencies in system use from a technique or process viewpoint and proposed changes that may include process redesign and/or system enhancement
• Monitored process performance (e.g. requirements management, testing, etc) and recommended process improvement actions aimed at elevating product quality across the entire organization
• Assisted in prioritization of requirements/product features and balance against development and implementation schedules.
• Full accountable for ensuring development projects are on schedule
• Evaluated programmers’ development and working capabilities

• Confidential,Social Security System : First project assignment was with Social Security System that handles the contribution made by private employed individuals, SSS BOIS or Branch Online Inquiry System has Pension and Funeral modules.
• Questronix (Client: Social Security System): Associate Programmer
• Hewlett Packard (Client: Globe Telecoms): While leading a big team, I was called to partially work in HP for their Globe Telecommunication client.
• Goodyear Philippines
• Participated in system presentation/demo of LGIS for possible future clientele.

Confidential, UNIVERSITY Bachelor of Science, Industrial Psychology; March 1998

TRAINING AND CERTIFICATION

Pentasoft/Aetins

• PentaISF
• Technical Standards
• Risks & Products in Life Insurance
• Insurance Concepts (Life & General)
• Analysis of Premium and Sum Assured
• Fundamentals of Islamic Insurance

Kosher Software

• VB.Net & ASP.Net
• MS SQL Server
• JavaScript

Accenture

• PL/SQL
• Application Testing
• Leadership
• Developer 2000
• UNIX
• Capability Maturity Model (CMMI)

Cytronics Internation Inc.

• PL/SQL
• UNIX
• Designer 2000
• Developer 2000
• Oracle Web Programming
• PowerBuilder
• SQL Plus
• Oracle (Character Based)
• Delphi

Baker & Taylor

• Agile Development
• Visual Studio

• Oracle Certified Associate (OCA)