Emilio Alpanseque Email & Phone Number

San Rafael, California, United States

ERP Support Management, System Administration, Security Management, Change Control, Configuration Management, and ERP Project Management. Third-Party Vendor Management: ERP Application Management Support (Infosys), ERP Oracle Support (Oracle), ERP Hosting/DB Support (Cognizant).Oracle E-Business Suite R12 (12.2.5):Financials: General Ledger, Payables, Receivables, Fixed Assets.Supply Chain: Inventory, Order Management, Shipping, WMS/MSCA, ASCP, Demantra, Weigh & Kitting.Manufacturing: Oracle Process Manufacturing, MES, Quality.Human Resources: Oracle Cloud HCM, Oracle Fusion Workforce Compensation.Integrations and Peripherals:Zebra Barcode Scanners (Integration with WMS/MSCA).Microsoft Intune (Centralized Management of Barcode Scanners).Mettler Toledo Scales (Integration with MES for OPM).Seagull BarTender (Integration with WMS/MSCA for Label Printing).appMIGRATE (ERP Configurations Migrator).appMDM (Master Data Management).Oracle UPK (Process Knowledge and Training).Coupa SpendSource (P2P, Supplier Punchouts). ServiceNow Enterprise IT Service Management (Rome). Compliance: FDA 21 CFR Part 11, GXP processes (GMP, GLP, GCP). Computer System Validation, SOX.

San Francisco Bay Area

ERP Support Management, System Administration, Security Management, Change Control, Configuration Management, and ERP Project Management. Third-Party Vendor Management: ERP Application Management Support (Infosys), ERP Oracle Support (Oracle), ERP Hosting/DB Support (Cognizant).Oracle E-Business Suite R12 (12.2.5).Financials: General Ledger, Payables, Receivables, Fixed Assets.Supply Chain: Inventory, Order Management, Shipping, Purchasing, iProcurement, OSN, WMS/MSCA, ASCP, Demantra, EDI/3PL, Weigh & Kitting, OPSM.Manufacturing: Oracle Process Manufacturing, MES, Quality.Human Resources: HRMS, Payroll, Benefits, Oracle Fusion Workforce Compensation.Mettler Toledo Scales (Integration with MES for OPM).Seagull BarTender (Integration with WMS/MSCA for Label Printing).Wavelink Avalanche (Centralized Management of Barcode Scanners).appMIGRATE (ERP Configurations Migrator).appMDM (Master Data Management).Oracle UPK (Process Knowledge and Training).ServiceNow Enterprise IT Service Management (Kingston). Compliance: FDA 21 CFR Part 11, GXP processes (GMP, GLP, GCP). Computer System Validation, SOX.

San Francisco Bay Area

ERP Support Management, System Administration, Security Management, Change Control, Configuration Management, and ERP Project Management.Oracle E-Business Suite R12 (12.2.5).Financials: General Ledger, Payables, Receivables, Fixed Assets.Supply Chain: Inventory, Order Management, Shipping, Purchasing, iProcurement, OSN, WMS/MSCA, ASCP, Demantra, EDI/3PL, Weigh & Kitting, OPSM.Manufacturing: Oracle Process Manufacturing, MES, Quality.Human Resources: HRMS, Payroll, Benefits, Oracle Fusion Workforce Compensation.Mettler Toledo Scales (Integration with MES for OPM).Seagull BarTender (Integration with WMS/MSCA for Label Printing).Wavelink Avalanche (Centralized Management of Barcode Scanners).appMIGRATE (ERP Configurations Migrator).Printech CheckPlus (Check Printing).Oracle UPK (Process Knowledge and Training).Compliance: FDA 21 CFR Part 11, GXP processes (GMP, GLP, GCP). Computer System Validation, SOX.

San Francisco Bay Area

ERP Support Management, System Administration, Security Management, Change Control, Configuration Management, and ERP Project Management.Oracle E-Business Suite R12 (12.1.3).Financials: General Ledger, Payables, Receivables, Fixed Assets.Supply Chain: Inventory, Order Management, Shipping, Purchasing, iProcurement, OSN, WMS/MSCA, ASCP, Demantra, EDI/3PL, Weigh & Kitting, OPSM.Manufacturing: Oracle Process Manufacturing, MES, Quality.Human Resources: HRMS, Payroll, Benefits, Oracle Fusion Workforce Compensation.Mettler Toledo Scales (Integration with MES for OPM).Seagull BarTender (Integration with WMS/MSCA for Label Printing).Wavelink Avalanche (Centralized Management of Barcode Scanners).Noetix (Corporate Reporting)appMIGRATE (ERP Configurations Migrator).Printech CheckPlus (Check Printing).Oracle UPK (Process Knowledge and Training).Compliance: FDA 21 CFR Part 11, GXP processes (GMP, GLP, GCP). Computer System Validation, SOX.

San Francisco Bay Area

Managed operational relationships & performance between IT Convergence Managed Support Services & customers. Responsible for delivery of Oracle Applications related services including project, hosting & support, client expectation management, SLA management, off shore & near shore team coordination. Customer accounts included The Spaceship Company, Volterra Semiconductor, ESS Technology, j2 Global, Pico Holdings, Accuride International, Glass Lewis, Odwalla and more.

San Francisco Bay Area

PROFESSIONAL SKILLS Oracle Applications Versions R 10.7, 11.x, 11i, R12Oracle Applications Modules (GL, AP, AR, AX, PO, FA, ONT, OPM, ASCP, HRMS) Oracle RDBMS R 7.x, 8.x, 8i, 9i, 10g, 11gOracle Developer 6i, 9i, 10g (Oracle Forms, Oracle Reports)Oracle Discoverer 4i, 10gOracle BI Publisher 10g, 11gOracle BI Enterprise Edition OBIEE 10g, 11gOracle Tutor 11.5.6, Oracle Portal 10g 10.1.4, Oracle Workflow Builder 2.6Oracle SQL*Plus 8.0, PL/SQL 2.3, SQL* Loader, SQL Developer, TOADRed Hat Enterprise Linux, Sun Solaris, HP9000, SCO Rel5.0, Windows 98/2000/NT/XP/7/8LAST ENGAGEMENTAmy’s Kitchen (Petaluma, CA)February 2011 – October 2012 Technical Lead for Oracle Applications R12 (12.1.3) Financials, OPM & ASCP.Designed & implemented best practices methodology for development & deployment of customizations.Designed & developed custom iBOM, including custom tables, loading procedure & XML publisher reports including: iBOM, Finished Good Production Costs & Percent Organic.Designed & developed custom ASCP Pegging program, including custom tables, loading procedure & XML Publisher report to review ASCP Pegging after every MRP run.Developed custom XML Publisher reports including: WIP Shelf Life, Stock Aging, First Time Transactions, Current Orders, Transportation Requirements, Sales by Cost Component, Inventory Item Metrics, Orders on Credit Check Holds, AR Customer Credit Report. Developed & implemented AR Invoice & Sales Order Acknowledgement documents customized for four different countries (US, Germany, France & UK) including data definition & template differences & bursting controls.Managed technical team, conducted daily & weekly status reviews, coordinated & assigned tasks, led meetings, maintained project plan. Other engagements include the companies: Xenoport, Amway, Orthofix, Riverbed Technology, Symyx Technologies, DRS Technologies, Zachary Brands and more. Full detail available upon request.

San Francisco Bay Area

MAIN ENGAGEMENTSTorani (South San Francisco, CA)July 2007 – August 2007Technical Lead responsible for the development & deployment of a comprehensive Discoverer Business Area for the modules (AR, AP, FA, GL & PO). Including 10 complex Discoverer reports such as a 7-bucket AR Aging, AP transaction details & more. Development & deployment of a custom Inventory Payables Accrual report.Discoverer (Administration & Desktop Edition) & Advanced PL/SQL training.OXY Occidental Petroleum (Houston, TX)March 2006 – June 2007Technical Lead responsible for Techno-Functional support tasks for Oracle Financials (GL, AP). On-call single contact point for AP & GL support issues for OXY’s international sites in Argentina, Colombia, Oman, Qatar & Libya. Worked on-site in Argentina for five weeks.Performed maintenance, troubleshooting & modification of all multiple custom programs such as reports, interfaces & other developments including custom AP Invoice Validation process, Invoice Withholding Calculation process, AP EFT file generations, AP Month process, etc.Eastern Municipal Water District (Perris, CA)February 2004 – June 2004Technical Lead for Oracle Financials 11.5.9 integration with Maximo. Developed PO Requisition Interface between Oracle & Maximo.Developed Automated Zero-Out process for Oracle Inventory quantities using Dataload.Customized PO Approval Workflow & PO Requisition Workflow.Developed PO Requisition Import Report & Pending Purchase Order report.Performed Value set load & Account combination load.Customized AP Supplier merge program.Other engagements include the companies: Diebold, The Nature Conservancy, Electronic Arts, Gymboree, School Specialty, NCS Pearson and more. Full detail available upon request.

Madrid Area, Spain

Led Technical team & managed resolution of technical issues in both Application Development & IT Infrastructure during an Oracle EBS upgrade from Release 10.7 NCA to 11i.Involved in integration to/from existing legacy systems for Billing, Customer usage (for deferred income calculation purposes), Payroll, Fixed Assets, Customers, Bank EFT Payments/receipts (FTP, UNIX scripts, SQL*Loader, PL/SQL, & Oracle Open Interfaces).Performed data conversion of AR Open items, Customers, Salespersons, Customer Calls, Inventory items, AP open items, Suppliers & GL Balances. (PL/SQL, DATALOAD, TOAD, FTP, IMPORT/EXPORT, Oracle Open Interfaces).Migrated existing customizations from 10.7/Developer 2000 to 11i/Developer 6i that included: Module that consisted of Three Screens Forms 6i & One Report 6i, A Client Due Dates Customization that enabled adherence to customers’ requests for due dates falling on fixed days of the month (PL/SQL), Several Bespoke Reports & Modified Oracle Standards reports.Managed the technical environment by liaison with the UK DBA team. This included coordinated backup plans, oracle database object creation & other DBA issues (Application was in Warwick, Technical team in Madrid, DBA team in Bradford). Managed execution of the technical data conversion process as specified above for sign-off by end users. Coordinated System & User acceptance testing.Provided support for the project team on implementation & coordinated handover of technical elements to APO (Documentation, Interfaces, Customizations, local business processes, etc).Advised, guided & supported the project team on the use, implementation & maintenance of Oracle applications.

Madrid Area, Spain

Defined criteria for Sign Off of Data Migration & Interfaces Strategy.Established & adhered to project timeline regarding migration design, construction & integration testing.Analyzed & developed procedures, tools, & plans to support manual migration, data cleansing & data reconciliation.Detailed breakdown of interfaces to be migrated or assimilated from current installation.Successfully prototyped several critical processes on 11i including Cross-currency transactions (Euro functionality), Consolidation (via FSG), Input & Output VAT reporting including the numbering requirements of Spanish fiscal authorities.Developed Consolidated Aged Debt & Supplier Invoice Aging reports.Verified Oracle Applications capability of supporting the Spanish language in screens, account names, & reports using Developer 6i.Verified Oracle Applications support of Spanish localizations.Worked with end users to continually evaluate business processes, define requirements, & create technical specifications for necessary system modifications.Designed, developed, tested, & delivered enhancements such as customized forms, customized reports & modified Oracle standard reports (Developer/2000 R1.6 & Oracle RDBMS 7.3.4.4.0). Coordinated temporary contracted programmers in case of larger developments. Maintained technical documentation for financial application extensions. Provided technical & functional user support (AR, AP, GL, AX modules & System Administration Tasks such as define users, responsibilities, menus, data groups, report security groups, concurrent managers & profile options with respect to applications security).Designed & delivered data mining/browsing reports from AR & AP modules (Oracle Discoverer 3.1).Delivered technical assistance on error handling, data base tuning, product patching, & other administration related tasks.

Madrid Area, Spain

Performed several implementations of Oracle Financials R10.7 (NCA & Smart Client versions AR, GL, AP & AX modules) under Pricewaterhouse Coopers Consulting staff & methodology.Designed & developed custom application integration with Oracle Financials that included interfaces for AR, AP & GL (FTP, SQL*Loader, PL/SQL). Customized forms & reports & modified Oracle standard reports (Developer/2000 R1.6 Forms 4.5, Reports 2.5 & Oracle RDBMS 7.3.4.4.0). Performed several data conversions & migrations into Oracle environment using SQL*Loader, PL/SQL, PRO*C & C++ & Unix scripts. Migrations included AR Open items, Customers, Salespersons, Inventory items, AP open items, Suppliers, GL Account balances & budgets.Designed & developed a Customized Statistics Module using Developer/2000 R 2.1 (Forms 5.0 & Reports 3.0) & Oracle RDBMS R 8.0.4.2.2.Designed & developed a Customized Billing Module using Developer/2000 R 1.6 (Forms 4.5 & Reports 2.5) & Oracle RDBMS R 7.3.4.4.0. Provided technical support & training (AR & the Customized Statistics modules) for end users.

Madrid Area, Spain

Designed, implemented & maintained Generators of Onyx Software for Insurance Companies such as Product Generator, Screen Generator, Query Generator, as well as several Insurance Administration Modules such as Endorsements, Settlements, Reinsurance, Direct & Debiting using Oracle tools such as Forms 3.0, Reports 1.0, Oracle RDBMS 6.0. Tested & tuned performance of Onyx Software transactions & host language calls on Unix & DOS operative Systems. Involved in diverse service related tasks including: client presentation, Onyx Software installation, client requirements evaluation, Insurance Products Design Assistance, client enhancements design & implementation, technical support & training, client system porting & data conversion. Worked on client’s sites located in Spain, Czech Republic, Chile, Mexico & Argentina.