Oracle Manager And Solution Architect Resume
Houston, TX
SUMMARY:
- Extensive experience with Oracle EBS Implementations, Upgrades, Configurations, Development, and Business Analysis in global, multi - org, multi-country, and multi-currency environments.
- Over 18 years of high performance experience with Oracle E-Business suite in technical, functional and management roles. Over 9 years of delivery and efficiency oriented management experience.
- Excellent gap analysis, project management, resource management, solution architecting and troubleshooting skills repeatedly tested in high-pressure environments. Worked extensively with EBS Setups, Architecture, Development tools, on Financials, SCM, OTC, Manufacturing, PTP and CRM modules.
- Deep experience designing and delivering rich in-house systems and custom extensions, complex business solutions using Oracle seeded functionality, and driving projects that contribute to company’s efficiency.
- Rich business facing experience; building and maintaining key relationships with employees, vendors and customers at all levels.
TECHNICAL SKILLS:
ERP: Oracle E-Business Suite versions R12, 11i, 11.0.3, 10.7, and 10.6.
Modules: General Ledger (GL), Account Receivables (AR), Oracle Purchasing (PO), Accounts Payables (AP), Cash Management(CE), Planning, ASCP, Inventory(INV), Order Management (OM), Pricing, Shipping, Configurator, Discrete Manufacturing, iExpenses, Tele-Service(CS), Service Contracts, Install base, System administration, Alerts and AOL
Other Functional Areas: Lean Six Sigma, Basic Accounting, Cost Accounting, Purchasing, Billing, Sarbanes Oxley, AIM Methodology, Gap Analysis, Feasibility analysis, and Project Management
Technical Skills: Oracle Forms and Reports, Workflow, Unix shell scripts, Discoverer, Oracle Form Personalization, C, Pro*C, Toad, WinRunner, PVCS, Visio 2003, Prevue 5.1, Ms-Project, Oracle APIs, Integration, Configurator, Java and Bi-Publisher (XML Publisher), Oracle SOA, SQL tuning
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Oracle Manager and Solution Architect
Environment: Oracle EBS 12.1.3; SCM, OTC, Financials, Manufacturing
Responsibilites:- Responsible for Discovery-to-Delivery of new projects, adding new business units to Oracle.
- Led and successfully completed implementation of Oracle EBS for Mexico operating company, respecting Mexico statutory requirements. Performed gap analysis, setup modules, provided training to users, coordinated testing, GL accounts reconciliation, and acquired business sign-offs.
- Identified and implemented numerous solutions for new process implementations and improvements using oracle standard functionality and designing oracle extensions.
Confidential, Pittsburgh, PA
Service Delivery Manager and Functional Support
Environment: Oracle EBS 12.1.3; SCM, ASCP, OTC, Financials, Manufacturing, Depot Repair
Responsibilites:- Oracle EBS Functional and DBA support for client - Industrial Scientific.
- Formed and Managed EBS support team and DBA Team; achieved SLAs.
- Provided hands-on support for Supply Chain and Manufacturing modules as support lead.
Confidential, Katy, TX
Sr. Manager Enterprise Applications
Environment: Oracle EBS 11i and R12: Manufacturing, SCM, Financials, WMS, OM, ASCP, SOA
Responsibilites:- Project Manager for Oracle EBS Upgrade project from 11.5.9 to 12.1.3. Delivered upgraded instances, custom objects based on changed oracle entities and processes including interfaces, AP payment processes and reports, recreating OAF substitutions; setup role based responsibility accesses for R12; project reporting, coordination with BAs.
- Implemented Oracle SOA in the organization, and utilized it for a B2B2C and Third Party Logistics project for partners ebags.com and costco.com.
- Functionally designed and delivered Work Order completion process for quick assembly completion and synchronizing it with ASCP database.
Confidential, Southfield, MI
Oracle Financials Consultant
Responsibilites:- Led a short project to replace their legacy check printing software with Oracle R12's check printing functionality. Helped with and year-end closing issues and provided functional support.
Confidential, Ann Arbor, Michigan
Manager
Environment: Oracle Applications 12.0.4, Financials, Manufacturing, Order Management, Tele-Services, HR (shared), MSCA, ASCP, Oracle SOA & BPEL 10G, onsite and offshore team, Informatica.
Responsibilites:- Architected and Implemented master data hub; Designed and developed MSCA customizations; Enabled interfacing data between production and non-production instances using Informatica to respect SOX requirements.
- Implemented multiple internal I.S processes, for example, improved SDLC process, patch processing, and implemented KanBan methodology for SDLC visibility. Improved environment and facilities for the development team for better productivity and quality of deliverables. Enforced good requirement documents and prioritization.
Confidential, Manitowoc, Wisconsin
Manager
Environment: Oracle Applications 11.5.9, 11.5.10: Financials, Manufacturing, OTC, PTP, CRM, Services, HR (shared), Oracle OnDemand hosted servers, Optio.
Responsibilites:- Directed IS side of projects for Oracle EBS roll-outs to new business units. Successfully completed seven roll-outs to new business units.
- Served as CRM Functional Lead in one of the roll outs as an additional responsibility.
- Worked on gap analysis, BP80, BR100, and led Conference Room Pilot.
- Completed database 10G upgrade, and ‘Change of Hosting Partner’ projects successfully.
- Assembled from scratch, through effective leadership and mentoring, a high-performance team with less-experienced employees and low-cost consultants, saving thousands of dollars per month. Trained them on technical skills like Form Personalization, XMLP, and Java.
- Performed hands-on role of Solution Architect and Business Analyst as needed.
- Served as Subject Matter Expert leading multiple re-engineering projects e.g., procurement card automation, Engineering item creation and ECO processes, services re-engineering to reduce data entry time and process efficiency, XML data interchange with customers, shop floor labels, moving production to China, EFT through third party, intercompany transactions, Multi-channel dunning letters, ACH payment and confirmation letters to employees and vendors.
- Order to Cash (OTC) Hands-on work: Setting up Intercompany shipping in a multi-country and multi-SOB environment. Setting up document sets for printing at pick and pack; Provided invoicing solution by setting up fulfillment sets; Customizing OM workflows and assigning to OM Transaction types; Interfacing Oracle shipping with UPS software; Interfacing Sales Order from Pepsi to Manitowoc using XML gateway; Column Mapping and design (MD50) for shipping related interfaces with Concentrek (a transport solutions company); Sales reporting to corporate based on complex regions assigned to area managers; Troubleshooting issues with advanced pricing calculations; Configurator changes in EBS 11.5.8; Customized internal order workflows.
- MFG (DTB) Hands-on work: Designed a custom module for Shop Floor labels printing for discrete jobs; Items, Categories, BOMs and Routing conversions for each implementation at Manitowoc; New Item Creation workflow and ECO workflow technical design; Uploading Pending costs; Custom serial number generation program; Custom component shortage report.
- Conducted EAI vendor selection; Led and completed the project to select the best EAI tool for the organization. Project included organization wide requirements gathering, pugh matrix, demos, customer reference calls, and POC.
- Designed and implemented change control process and development methodology, respectful of Sarbanes Oxley requirements, which resulted in uplifting of application quality standards.
- Point person to senior management on business priorities; provided project status updates to stakeholders, and monthly team reports and metrics. Worked with IS director on budget planning, strategic planning, and consulting requirements.
Confidential, Milwaukee, Wisconsin
Module Lead
Environment: Oracle Applications 11.5.8- modules: PA, AR, GL, AP, PO, CE; HP 9000, HP UX 10.20, Oracle 8i, Novell, Toad.
Responsibilites:- Responsible for all setups for General Ledger, Cash Management and A.P. like chart of accounts, set of books, key flexfields, payables system options etc. Areas and branches setup in HR organizations, HR locations, HR Hierarchies, GL Hierarchies.
- Performed requirements gathering, project planning, functional and technical analysis, and development for customizations, interfaces, extensions and provided user support including month end closing. Designed credit cards interface to AR.
- Played key role in European integration projects aspiring for a global database and global code base. Implemented statutory set of books for European countries using consolidation facility in Oracle GL. Provided Oracle EBS training to European IT personnel.
- Worked extensively on 10.7 to 11i upgrade project. Reviewed business processes, modified existing customizations and interfaces for 11i compatibility, and got users’ sign off. Utilized TCA relationships in customers, which was a new feature of 11i.
- Re-engineered business processes for minimum IT involvement, and worked on Sarbanes Oxley issues.
Confidential, Montgomeryville, Pennsylvania
Conversion Lead
Environment: Oracle Applications 10.7 and 11.0.3, HP 9000, HP UX 10.20, Oracle 8.0.5.
Responsibilites:- Converted Vendors, Customers, Items, Categories, Purchase Orders, AR invoices, Sales Persons, and AP invoices, year-end accounts balances, key flexfield values and GL code combinations, item-category assignments, and brought on-hand inventory balances.
Confidential, Dallas, Texas
Technical Lead, Programmer/ Analyst
Environment: Oracle Financials 10.7NCA, SUN Enterprise 6500, Sun OS 5.6, PVCS.
Responsibilites:- Led technical design, data mapping and setups for conversion of customers and invoices from Legacy system to Oracle Receivables. Prepared Technical Design Documents (CV70 & MD70)
- Customized Forms and Reports for AR, OE, PO and GL including graphical postscript reports. Developed Drop Ship Confirm interface between OE and PO.
- Performed AOL & System administration jobs like registering programs, setting up printer drivers etc.
Confidential, Allentown, Pennsylvania
Developer and Performance Testing Lead
Responsibilites:- Developed and ran scripts using 'Prevue' and Unix shell scripts for performance testing. Trained and led a team of four developers to use Prevue and develop Prevue scripts for stress testing, and planned the testing.
- Developed scripts in WinRunner for automated conversions of data to Oracle.
- Developed OE interface, custom forms for vendors and historical invoices and reports for AP, AR and PO.
Confidential
Senior Applications Analyst
Responsibilites:
- Developed Extensions to Oracle Financials by customizing forms, reports, and packages adhering to Oracle Applications coding and interface standards. Developed Libraries and functions that were re-used for different development units.
- Worked on the following modules: Oracle Purchasing, Oracle Payables, Oracle Receivables, Oracle Order entry, Tax and duties registers.