SUMMARY:

• Over 16+ years of diversified Oracle and MS SQL server database experience.
• Emphasis on Oracle Financials ERP R12.2,R12.1 and R11i Applications Development/Support with Oracle 6i,9i,10g Forms/Reports tools, PL/SQL packages, data conversion, interface and application support. Knowledgeable in Database, Client/Server/Web Applications Development. Knowledgeable in Oracle database administration, backup and recovery. Ability to handle multiple projects on - hand within different language scopes on time and within budget.

TECHNICAL SKILLS:

Programming Language: Oracle PL/SQL (16+ years), Microsoft SQL server 2012 and 2017 (5+ years), SQL (16+ years), C, C++ (3+ years), JAVA (1+ year), PERL 5.0(7+ years), UNIX shell scripts (2+ years)

Tools: Oracle Forms and Reports ver. 6i, 6.0 (16+ years) - (Oracle OCP certified)Oracle Forms and Reports ver. 9i, 10g (16+years) -taken Oracle 9i upgrade classes and exam. Oracle Jdeveloper 9i,10g(2 year) Oracle Developer 2000, (2+ year) SQL*Plus, SQL*Loader, (16+ year) Quest T.O.A.D (Tools for Oracle Application Development) (16+ years), PL/SQL Developer (16+years) MS SQL server Management Studio 2012 (3+years) MS SQL server Management Studio 2017 (3+years) IBM Maximo Asset management (3+ years) DataSplice (iPad asset management software work with IBM Maximo) (1+years) AccuRev 3.5.5(Software Control Management software) (2 year) Erwin 4.0 (5+ years), VISIO (4+ years), Visual C++, MS Office Suit (up to version 2010) Microsoft Team Foundation Server (TFS for source control)

Database /ERP Systems: Oracle Financial Application Release 12 (12.2.7) (AP, AR, GL, FA, PA, INV) (6+ years) Oracle Financial Application Release 11i (11.5.9) (AP, AR, GL, FA) (7+ years) (Order Management modules) (1 year) Microsoft Dynamic AX Financial system(1+ year) Oracle Database 7, 8, 8i, 9i,10g,11g (16+ years) Microsoft SQL server (5+years)

Operating Systems: Sun/Solaris, HP - UNIX, FreeBSD Linux Windows 95/98/ME/XP/Vista/Windows 7,8,10 Windows 2000, (2+ year) Windows NT4.0, (5+ years) (MCSE + I NT4.0 certified) Citrix Metaframe XP server/client, Red Hat Linux, (3+ years)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Developer

Responsibilities:

• Support ChromeRiver expense reporting software and integration to Oracle.
• Support WorkDay HR/helpdesk software integration to Oracle.

Confidential, Houston, TX

Senior Programmer/Analyst

Responsibilities:

• (1st year) Support Oracle Financials 11i (11.5.10) eBusiness Suite:
• Fix Asset, Account Payable, Account Receivable, General Ledger, Inventory, Purchasing modules.
• Member of Oracle Financials (R12.1) upgrade implementation team.
• (2nd to 6th year) Support/Enhance Oracle Financials R12 (12.2.2) eBusiness Suite (Fix Asset, Account Payable, Account Receivable, General Ledger, Inventory, Purchasing modules)
• Perform yearly process of 1099-MISC, 1099-NEC and 1099-S, Director’s fee
• IRS eFiling.
• Create audit data, reports for PWC auditors and Internet audit.
• Automated/support AP electronic payment system with Confidential .
• Automated/support Check payment process and land record payment process (with secure32)
• Create eText templates for processing various payment process and payment xml files.
• Support/enhance various customized reports for AP/AR/GL/FA module.
• R12.1 to R12.2 upgrade project.
• Support MarkView document scanning system.
• Support join venture related accounting processes.
• (6th year)
• Enhance and support IBM Maximo asset management system (version 7.6).
• Enhance and support iPad and Chrome browser base DataSplice software for online and offline asset management and repair scheduling system.

Confidential, Houston, TX

Senior System Analyst

Responsibilities:

• Support and develop for Oracle Financials 11i (11.5.9) eBusiness Suite:
• Fix Asset, Account Payable, Account Receivable, General Ledger, Credit, Sales online and Administrator modules
• Supports treasury department, tax department, Billing Department (General Ledger, Payables, Receivables, General Ledgers) for Houston headquarter and International Offices (UK, France, Italy, Mexico) with Oracle ERP system with muti-org.
• Also perform billing support for total of 50 international locations.
• Enhance and implementation of custom billing, invoicing, data transfer/validation automation through Oracle Payables and Receivable interface tables for Houston headquarter and 55 worldwide offices. (Supports and creates both stand-alone Oracle 10g custom billing forms and other Oracle 6i Forms and Reports within Oracle 11i)
• Implement Receivables Receipt lockbox automation, Positive Pay/ACH(NACHA format)/WIRE interfaces with CHASE bank (recent re-write of Wire Transfer automation due to format changes from CHASE).
• Implementation and integration of Confidential GetPaid Credit Management software with Oracle Financial. Data Import/Export between Oracle and GetPaid software.
• Implementation and integration of Confidential Secure32 Laser Check Printing with Oracle Financial.
• Implementation of Oracle XML Gateway (xgm mapping) to receive complex Vendor invoices from Exxon, Shell, BP in IATA format (more implemented)
• Create custom invoice data files through emails fax and secure FTP for various customers like Coca Cola and Yum Brands etc.
• Perform data migration for BNA Fixed Asset Management Software.
• Perform testing and after upgrade support for oracle 10g database upgrade.
• Perform report performance tuning and bug diagnostic and patch research.
• Write various custom Oracle 6i reports within 11i environment.
• (Aging Reports, Journal Reports, Data Validations, Data mining, Invoices, Sales, Collector, European VAT tax Reports )
• Perform Yearly GL data extraction and monthly VAT tax data files for PWC auditors and accounting department.
• Daily production support on various Oracle ERP modules.
• Responsible for all phases of the systems development life cycle for moderate to complex information systems. The position concentrates on business requirements gathering, feasibility analysis, impact analysis, technical design, coding and documentation.
• User security and role setup in Microsoft AX.
• Report enhancement within AX environment.

Confidential, Houston, TX

Senior Consultant

Responsibilities:

• As senior technical consultant, perform data migration design, migration scripting and implementation for client CenterPoint Energy. Upgrading from Confidential Energy products Confidential and Confidential to latest Entegrate energy solution.
• Trading and Power trading, Accounting, Risk management and Scheduling. Clients included utilities, generating companies, power pools, gas and oil producers, processors and other energy market participants. Supports integrated solution based on open system architecture, and deployed via thin client, Oracle 9iAS platform. Currently supporting Nucleus version 11, 12, 13 on Oracle Forms/Report 6i platform and version 14 on Oracle Forms/Report 9i platform. Also involve in development and support of Entegrate 2.0.4 on Oracle Jdeveloper platform.

Confidential, Houston, TX

Oracle Consultant

Responsibilities:

• (e.g. Raw Material Input to WIP report Labor and Overhead Input to WIP Detail/Summary report WIP Input and Output Reconsolidation Report Standard Routing and BOM report etc.)
• Convert Text mode Oracle Apps reports into Web enabled

Confidential, Houston, TX

Responsibilities:

• Project leader in charge of information gatheringdesign, coding, data migration of new software for forge shop n customer information/file storage and forging procedure approval / release process using Oracle Form 9iReport 9i web mode on 9iAS Oracle Application Server

Confidential, Houston, TX

Responsibilities:

• Convert and expend existing Oracle 6i Forms into web base application from client server mode for Forging engineers and pipe engineers in Houston and Mexico. Adding multiple oracle
• Reports and automate product approval/release process.
• Increase data checking and validation rules and create email notification system. Automate AutoCAD drawing conversion to Acrobat format and display online. Create centralize AutoCAD drawing storage storage/sharing system.
• Research on Form 9i conversion.
• Worked on data conversion scripts and actual screens/forms and back-end PL/SQL processes with oracle packages for Bill of Material, Procedure Sheet, Weight Ticket, Design File, File Control, user administration modules.
• Clean up and migrate existing data from multiple sources and create database triggers, indexes, foreign keys to implement new business rules.
• Perform SQL turning using EXPLAIN PLAN and TKPROF and TOAD.

Confidential, Houston, TX

Responsibilities:

• Creating customized audit reports with PL/SQL, Oracle Reports 6i from Compaq Laptop Order EDI inputs and creates customized Oracle Forms for Oracle Application 11i(ver.11.5.5).Create customized Oracle forms for Order Management modules in 11i Environment.
• Worked on setup, implementing, troubleshooting, custom form development and testing for Order Management
• (Account Payable (AP), Account Receivable (AR) Fix Asset (FA), General Ledger (GL), Shipping (WSH), Inventory (INV), Work in Process(WIP), Bill of Material (BOM), Order Entry(OM) modules).
• Creation of EDI 856 and resolving DSNO problems.

Confidential, Houston, TX

Responsibilities:

• Project leader in charge of information gathering from different users and developers for the project. Establish required data for project documentation. Gather appropriate resources to execute the project in scope and within budget. Leading project with help of fellow developers and DBA. Keep client and management informed of project status and changes that need to be approved. Arrange Quality control and developer/user testing on final product. Arrange for junior Oracle Form developer.
• Using GUI application to duplicate and enhance existing functionalities of character-based FCP Document and AutoCAD filing system application currently running on DEC replace with Oracle 8i .
• Install, configure and maintain Oracle 9iAS application server Release 2.
• Rebuild user interface with Oracle Form 6i. Using Oracle as new database platform and GUI development tools delivering web application through Internet Explorer and Oracle 9iAS. Responsible for development of database architecture, project coding standard, documentation, functional requirement gathering and coding 30+ Oracle Forms.

Confidential, Houston, TX

Responsibilities:

• Working in a development team using Oracle Forms and Reports 6i database tools to create customer contract and pricing system that interfaces with several other systems including Oracle Application 11i.
• Project responsibility include design phase, user request collections and creation of 20+ complex forms, multiple tables, background PL/SQL interfaces/processes, shell scripts, coding standard, project documentations .
• Worked on Oracle Application 11i interfaces and Flex-fields and con-current manager. User Interface was running on a win2000 platform through Citrix Environment. Database was running on a Sun Solaris Environment.

Confidential, Houston, TX

Responsibilities:

• Develop and design prototype screens and prototype database for Electronic Material Procedure Instruction (MPI) application currently running on DEC replace with Oracle 8i.

Confidential, Houston, TX

Responsibilities:

• Installed, configured Oracle Application Server for HP UNIX (HPUX released 11), Oracle Form server 4.5 (for Oracle modules such as HRMS, Payroll, Financial & Manufacture); Applied patches for Oracle Form, Report, Oracle 9ias servers. Migrated Oracle Application Server and Developer 2000 from production box to testing box.
• Other K & W Software In-house Project
• Installed, developed and maintained company’s Vertex database using Oracle 8.05.
• Developed and maintained in-house Oracle application using Developer2000, Forms/Reports 6i and PL/SQL.
• Debug/migrate in-house ASP web page for timesheet processing using MS ASP and JavaScript.

Confidential, Houston, TX

Developer/ System Administrator

Responsibilities:

• As an in-house programmer, developing in-house billing/ financial system applications with Oracle developer 2000 Forms/Reports, PL/SQL store procedures Perl CGI, Unix Shell Scripts for billing/financial system with
• Oracle 8i back-end database.