SUMMARY

• Seasoned systems analyst and programmer with proven expertise in translating business process requirements into computerized solutions while considering accounting implications
• Dedicated SAP Analyst/Programmer offering more than 12 years of techno-functional support for FI, CO, SD, HR, MM modules, with 2 full life cycle implementations and 2 upgrades
• Team oriented application developer with more than 13 years of diverse accomplishment in implementation, maintenance and enhancement of computerized business applications
• Committed accounting professional (CPA) with more than 6 years progressive experience in cost accounting, financial analysis, corporate internal audit, and general accounting
• Track record of delivering on-time and on-budget project work across enterprise functionalities
• Proactive practitioner doing continuous self-study to stay abreast on new application development methodologies(SDLC, OOP, internet/web, DBMS), SAP functionalities and objects (reports, interfaces, conversions, enhancements, forms), and accounting practice (GAAP, IFRS)

EXPERIENCE

ABAP Programmer, Confidential, (Philippines) Mar 2006 – May 2008
- Assigned to Telus (BPO and call center) May 2008
- Assigned to Accenture (BPO for Bristol-Mayers-Squibb) Nov 2007 - Apr 2008
- Assigned to Globe Telecom (telecommunications) Mar 2006 - Apr 2007

• ALV - developed ALV reports for: PO status and payment forecast (commitment, delivery, payments); SD sales by region; AR report by type of transaction; and HR employee data
• BDC - developed programs for the following transaction codes: APPCHANGE-change employee appraisal data; APPCREATE-create employee appraisal data; AS01-create asset master data; CJ02-update settlement rule for WBS projects; F-02-post GL entries; IE01-create equipment master data; IL01-create functional locations; IQ02-change serial number of materials; and MM01-update PO text characteristics of material master data
• Business process analysis – conducted analysis of: electronic bank statement process flow; automatic reversal of accrual journal entries; and automatic update of equipment master data
• Configuration – assisted users in creating GL accounts and in updating financial statements versions
• Dialog programs – developed and maintained program for employee stock options
• Interactive reports – developed drilldown reports for: Expense and Budget Variance; Capital Expenditures (CAPEX) monitoring; and Customer Statement of Account
• Mentoring – provided guidance to associate ABAP programmers in troubleshooting program abends, dumps, and logic errors; assisted Functional Analysts in the preparation of functional and technical specifications; acts as resource in the resolution of techno/business problems
• Optimization - modified SQL code of reports resulting to faster system processing
• Out-of-the-box – developed solution to work around the limit of 999 line items for periodic GL posting of a payroll journal entry consisting of more than 1000 lines items
• SAPScript - implemented replacement of check-approving signature and oriented

Functional Analysts on SAPScript set up, process flow and programming

• Standard reports - developed standard reports for: Capital projects consisting of 3 separate listings with different line widths in one program; Fixed assets status report
• Text translation – modified programs for multi-language implementation
• Upgrade - modified customized programs for upgrade from 4.6C to ECC with emphasis on Unicode compliance

SAP Analyst/Programmer, Confidential, (Saudi Arabia) Jan 1995 – July 2005

• Counseled and assisted end-users in module implementation thru blueprinting, gap analysis, configuration, authorization, data conversion, reporting, master data maintenance, transaction processing, user training, unit and integration testing, and documentation
• Provided solutions to requirements for end-users of modules for GL, AR, AP, AM, IO, CEA, CCA, SD, HR, and MM, by setting up alternative business processes thru configuration and ABAP programming – dialog, reports (lists, interactive, ALV), BDC, SAPScript, ABAPQuery
• Implemented thru ABAP Workbench, major projects including AR sub-module for invoicing and statement of accounts, SD sub-module for monitoring of shipping containers, MM production statistics, CCA overhead reports, HR pay slip download to company intranet, KPI monitoring, Basis segregation of duties, electronic payment of vendors, download of pay slip data for electronic transmission to banks, SAPscript configuration of company checks, and BDC programs to upload periodic accounting journal entries, fixed assets master, and material master data
• Regarded as subject matter expert on integration points between business process among SAP modules and the relationship of corresponding database tables
• Prepared data for migration from version 3.0F to 4.6C for upgrade requirements
• Acted as resource to other team and department staff in the resolution of techno-business concerns
• Implemented standards for program development, code review, enhancement, and optimization
• Trained entry-level ABAP programmers using self-developed training materials
• Developed more than 300 reports and optimized runtime of more than 100 customized programs
• Transferred legacy data using customized BDC and SAP standard programs for FI, CO, SD, and MM
• Member of in-house implementation team responsible for configuration and data conversion for FI, CO, SD, and MM modules
• Trained in-house in 1995 and implemented SAP up to 1997 while maintaining legacy systems

Systems Analyst/Programmer
- Confidential, (Saudi Arabia) – petrochemicals, 1987-1994
- Confidential, (Saudi Arabia) – plant operations, 1985-1987
- Confidential, (Philippines) – fertilizers, 1981-1985

• Supervised section of 3 programmers responsible for providing senior management with computerized financial and operational reports
• Implemented and maintained applications using standard SDLC methodologies, for accounts payable, accounts receivable, budget and expense control, capital projects monitoring, comparative financial statements, fixed assets, functional income statements by product line, general ledger, gross margin variance analysis, home ownership, materials and inventory control, payroll, personnel information, plant maintenance, process and job order costing, production-warehousing-shipping-inventory, projected profitability, sales analysis, trade inventory control, and work order tracking
• Led implementation of system for monitoring and control of IT projects
• Was selected and passed in-house training on EDP concepts, computer operation, systems analysis and design, and programming using COBOL, FORTRAN, Basic and Easytrieve.

Accounting, Confidential, (Philippines) – NPK fertilizers and agricultural chemicals

• Cost Accounting Assistant Supervisor, 1980-1981

Supervised 4 accountants responsible for preparation of process and job order product costing; plant production costing reports; manufacturing operations reports highlighting variances between prior period, planned, target, and actual data; projected production costs with emphasis on material requirements planning (MRP); and liaised with government and private institutions concerning company’s current, historical, and projected operations data.

• Financial Analyst, 1977-1980

Prepared monthly company Income Statement and Balance Sheet with corresponding write-ups for variances between prior period, forecast and actual data. Prepared monthly profit and loss statements by product line with emphasis on gross margin variance analysis and corresponding write-ups explaining causes of variances between actual, forecast and prior period data. Coordinated preparation of forecast data for sales, production costs, and budget for expenses. Supervisory support to department staff.

• Corporate Internal Auditor, 1976-1977

Conducted general and detailed financial and operational audit of branch offices, sales outlets, field warehouses, plant and home office operation. Submitted reports and presentations of audit findings. Evaluated and reported managerial implementation of company policies and procedures

• Accountant, 1975-1976

Implemented trade inventory control with emphasis on accounting treatment of receipts, deliveries, sales, losses, claims and stock positioning. Prepared monthly reconciliation of GL and subsidiary ledgers for accounts payable, accounts receivable, fixed assets, materials and supplies inventory, bank accounts, and cost center expenses.

COMPUTER SKILLS

• Languages: ABAP, SQL, PL/SQL, Visual Basic, COBOL, FORTRAN,

Cognos Powerhouse (Quiz, Quick, QTP), Easytrieve

• Operating Systems: Unix, Windows, DOS, Linux
• Database Systems: Oracle, MS Access, HP Turbo Image, Prime Midas, ISAM
• Applications: MS Office (Word, Excel, PowerPoint, Project), Remedy
• Self-study: MySQL, Java, Linux, PHP, HTML, CSS, C, OOP, Javascript

EDUCATION AND PROFESSIONAL QUALIFICATION

• Bachelor of Science in Business Administration - Major in Accounting
• Certified Public Accountant (CPA)

SAP-RELATED COURSES ATTENDED – Version 3.0F (with certificates)
AM010 – Assets Accounting Overview
FI010 – Financial Accounting Overview
AM020 – Asset Accounting
HR010 – Human Resources Overview
AM030 – Configuration & Organization
HR100 – Master Data and Time Data
of Asset Accounting
HR170 – Human Resources
BC010 – SAP Architecture
HR210 – Configuration of Master Data
BC020 – SAP Graphics
BC030 – SAP R/3 Data Dictionary
HR250 – Payroll Configuration
BC090 – R/3 in the Unix Environment
HR260 – Configuration of Travel Expenses
BC100 – R/3 Under Oracle
MM010 – Introduction to Material Management
BC110 – Correction and Transport System
MM040 – Valuation and Physical Inventory
BC170 – Introduction to ABAP Programming
MM070 – Invoice Verification
BC175 – Report Programming Techniques
PP005 – Overview of Production Planning
BC180 – ABAP/4 Data Interfaces
SD005 – Overview of Sales and Distribution
BC185 – Programming Techniques
SD010 – Introduction to Sales and Distribution
BC190 – Dialog-Oriented Report Programming
SD020 – Conditions and Pricing
BC220 – Introduction to Online Programming
SD030 – Sales
BC230 – Advanced Techniques
SD060 – SD Configuration & Organization
of Online Programming
Introduction to Oracle SQL and PL/SQL
CA010 – The SAP Authorization Concept
Administering Oracle7 Database
CA700 – Report Writer
CO010 – Controlling Overview