SUMMARY:

• I am a Business Systems Analyst with 24+ years of professional experience supporting Oracle Financials Application, and improving the business operations. I am expert and highly familiar with functional operation, maintenance of EBS and ERP Oracle Applications (FND, AD, GL, AP, AR, PO, INV, OM, SLA, EBTAX, O2C, and P2P).).
• Also with troubleshooting experience to diagnose and resolve technical and/or functional issues related with Oracle, SQL and UNIX scripting in a professional way.
• Also I have strong Oracle APPS DBA experience.

TECHNICAL SKILLS:

• Oracle Applications Order to Cash (O2C)
• Knowledge of Oracle AIM and OUM method
• Business analysis skills
• ETL Process management for Data Warehouse
• Data Warehouse Administration
• Oracle Apps Procure to Pay (PO, AP, GL, AR)

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Oracle Support Engineer

• Guidance about GL core process (mass allocation, revaluation, recurrent journals, etc.)
• Guidance teams/user about new integrations
• Run and creation of reports
• USDRQ pivot table
• Assistance to RTS team
• Maintain revaluation modules
• Maintain GL calendar
• Analysis of impact of new additions in AR, AP and GL. (Functional and technical)
• Assistance other teams with data issues related with GL interface and file feeds
• Solving issue related with period 13/month end/close of quarter data.
• Running and monitoring GL overnight batches
• Solving issue with GL process like SLEOFFSET, Auto reversal, custom revaluation, file outbound, etc.
• Maintain Cost Centers, cross validation rule, revaluations, security rules, mapping tables
• Training RTS support team member
• Interviewing prospect RTS support team members
• Consulting activities
• Functional testing of new projects
• Supporting and collaborating to Softtek’s proposals to new customers

Oracle Applications Senior Consultant

• Senior Functional Consultant of Oracle Applications e - business suite release 12 and 11i for Oracle Applications Financials modules: General Ledger (GL), Accounts Payables (AP), Purchasing (PO), Receivables (AR), Sub-ledger Accounting (SLA), and i-Suppliers. All together to support the set up and functionality of Oracle Apps Procure to Pay flow for the business. Resolving any Sub-ledger Accounting issues and working very close with Oracle Support when a Technical Assistance Request becomes opened with Oracle Corp.
• Data Warehouse Administration with Teradata Software and ETL tools: Decision Expert Administration and Decision Cast.
• Supporting the Order to Cash applications, from the order created and booked, resolving the issues when the Pick Release is done and creates the reservation against the source sub-inventory. Also ensure the shipping process creates the deliveries and become available to the Interface Trip Stop. It was important to monitor the invoice interface to become populated the interface tables and the Auto invoice program in Receivables to import and creates the invoices. After being processed the invoices and running the accounting in Receivables, monitor and check out the Journal Lines become interfaced and import into General Ledger and become posted according the settings.

Business Systems Analyst

• Oracle Applications System Administrator / Data Warehouse Administrator at PKC Group formerly AEES INC at San Antonio, TX
• Maintenance and Setting up Oracle Applications e-business suite 11i like System Administration, Receivables (AR), Purchasing (PO), Payables (AP), Inventory (INV), Order Management (OM), General Ledger (GL) and Workflow.
• Supporting the Order to Cash applications, from the order created and booked, resolving the issues when the Pick Release is done and creates the reservation against the source sub-inventory. Also ensure the shipping process creates the deliveries and become available to the Interface Trip Stop. It was important to monitor the invoice interface to become populated the interface tables and the Auto invoice program in Receivables to import and creates the invoices. After being processed the invoices and running the accounting in Receivables, monitor and check out the Journal Lines become interfaced and import into General Ledger and become posted according the settings.
• Full support for the Oracle Procure-to-Pay process and Order to Cash. From the purchasing of raw material with a purchase order, the PO approval, the invoice generation with auto invoice interface until being generated the accounting transactions and sent and post to the GL module.
• Limited DBA functions including security and user administration: User accounts, responsibilities, menus, functions, request groups, etc.
• Concurrent Managers: Monitoring, setting up, troubleshooting, etc.
• Printers: Setting up and troubleshooting new printer registration.
• Responsibilities: Setting up, customizing, maintenance.
• Reporting different Oracle information by request with SQL*Plus, PL/SQL, Toad, or standard reports.
• Troubleshooting Oracle Workflow and services.
• Project administration in development, test and production environments for Oracle Applications and Data Warehouse. All this include developing, testing, documenting and moving projects between environments.
• Data Warehouse Administration: Using Decision Expert Administration and Decision Cast from Teradata Software. ETL Tools from Teradata software.
• SQL and UNIX scripting for extracting data from Oracle Applications to Data Warehouse.

Consultant

• Owner of Marale, Inc. - Managing a small business
• Consultant to small business to create their web pages and improve the performance of their computers.
• Managing Marale’s operation, inventory, and accounting which include the ledger and taxes

Technical Specialist

• Team Leader activities for the Financial Applications Product Support team.
• Covering the manager role in a rotation basis.
• Effective management of escalated and critical customer situations.
• Effective negotiation skills to better-managed customer expectations on resolution of problems.
• Analysis and resolution of Oracle customer technical issues specifically for Oracle Applications (Oracle Payables, Oracle Receivables, Oracle General Ledger, Oracle Federal Financials, and other Oracle Applications modules) providing data fixes and/or patches or finding the right functionality to work around the issues.
• Assisting other key groups within Oracle Support on a rotational basis.
• Participating in the On Demand Hosting Service (OHS) team on a regular basis.

Applications Technical Support Manager

• Managing and coaching a group of analysts that focused on Oracle Applications support and maximizing team performance.
• Effective management and resolution of critical customer escalations like a technical lead of Oracle Applications.
• Interacting with the Consulting organization to ensure milestones where met on time.
• Visiting critical customer installations for better working relationship.

Senior Technical Analyst

• Delivered support through the hotline for Oracle Applications products.
• Participate in the rotation plan between Oracle Mexico and Oracle Corp.
• Coordinating the creation of Oracle Applications Support team.
• Oracle APPS DBA for internal databases.
• Delivering field support for key accounts.

Analyst programmer

• Developing applications for manufacturing enterprises using C language and PC packages.

Analyst programmer

• Programming Systems; giving technical support to the faculty administration and students; teaching computers classes.