We provide IT Staff Augmentation Services!

Oracle Ebs Consultant Resume

2.00/5 (Submit Your Rating)

Milwaukee, WI

PROFESSIONAL SUMMARY:

  • Oracle Certified Professional with over 15 years of experience as Oracle EBS Developer implementing, customizing and supporting Oracle HR/Payroll and Financials modules in US.
  • Over 5 years of experience leading and managing EBS development team of employees and consultants.
  • Extensive experience working with Oracle development tools including Forms, Reports, XML Publisher (BI Publisher), Workflow and AME.
  • Strong programming experience in creating Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
  • Experience using JDeveloper, OA Framework, SOA, BPEL, Discoverer and NOETIX,
  • Strong experience in using Oracle EBS APIs and Open Interfaces, along with in - depth knowledge of schemas and table structures in various EBS modules.
  • Experienced in designing and developing Reports, Interfaces, Conversions and Extensions.
  • Adept in all stages of project life cycle including As-is/To-Be Process Mapping, Gap Analysis, Business Requirements, Functional and Technical Designs, Prototyping, Development, CRP, UAT and Production Support.
  • Strong leadership skills coupled with solid analytical and problem solving capabilities.
  • Excellent at verbal and written communication with proven abilities to communicate effectively with business users, management and technical resources.

TECHNICAL SKILLS:

Languages and Tools: SQL, PL/SQL, ORACLE DEVELOPER TOOLS 2000/6i/10g (Forms 4.5/ 6/ 6i/10g, Reports 2.5/ 6/ 6i/10g), UNIX Shell Scripts, SQL PLUS, SQL*Loader, TOAD, SQL Developer, GOLDEN, ORACLE PORTAL (Release 3.0, 9.0.2), HTML, JavaScript, OA Framework, JDeveloper, NOETIX, Discoverer, Oracle Fast Formula, SOA, BPEL, BI Publisher (XML Publisher), Web ADI, Oracle Workflow

Databases: ORACLE SERVER RELEASE 11g, 10g, 9i, 8i, 7.3

ORACLE e: Business Suite R12 (12.1.3), 11i (11.5.10), 11.0.3, 10.7 (HR, Payroll, AP, iExpense, PO, AR, GL, GMS, PA, OM, INV, WIP, PO, WMS, OAB, LD, Service, ALERTS, SYSADM, VPD, AME), BANNER (3.1/ 2000), Taleo, Peoplefluent (RMS, Performance Management System)

Other Tools: MS Excel, MS Word, MS Power Point, MS Visio, PVCS, Kintana, APPWORX, Jetform, SVN, Starteam

Operating Systems: WINDOWS 7, WINDOWS XP, WINDOWS 2000, WINDOWS NT, WINDOWS 95, WINDOWS 3.1, Sun Solaris, MS-DOS

Industries: Manufacturing, Health Care

EXPERIENCE:

Confidential, Milwaukee, WI

Oracle EBS Consultant

Application: Oracle E-Business Suite R12 Support

Responsibilities:

  • Provide day-to-day support for various Oracle modules including HR, Payroll, LD, GL, PO, AP and Grants Accounting.
  • Gather requirements, analyze and present and implement solutions for enhancement requests.

Environment: SQL, PL/SQL, SQL Plus, TOAD, GOLDEN, Oracle Server (Release 10.1.0.5), UNIX, ORACLE DEVELOPER TOOLS (FORMS and REPORTS 10g), DISCOVERER, BI PUBLISHER, STARTEAM

Confidential, Milwaukee, WI

Enterprise Development Supervisor

Application: Oracle E-Business Suite R12 Support

Responsibilities:

  • Hands-on technical leadership and supervisory role engaged in development, enhancement and support of core business applications implemented in Oracle E-Business Suite.
  • Maintain big picture view of the business systems and provide project management and technical leadership to the development team
  • Contributed to projects and production support as lead developer.
  • Generated high level design documents, data design templates and as well as functional (MD050), technical (MD070) and migration documents (MD120)
  • Performed Technical Lead responsibilities.
  • Created a document repository of commonly used templates along with examples for each template type.
  • Created sharepoint sites to maintain documentation and artifacts for projects and initiatives run by the development team.
  • Develop, manage and maintain a highly-skilled and energized development team
  • Acted as the Hiring Manager for the Oracle development team.
  • Conducted performance reviews; formulated career plans for direct reports; guided the team through performance targets and goal setting activities.
  • Conducted regular 1:1s and team meetings.
  • Coordinated and implemented IS cross- and mentoring activities including lunch and learn and knowledge sharing sessions
  • Presented plans and conference budgets to management.
  • Made salary recommendations based on performance and market conditions.
  • Oversee day-to-day operations of designated support staff
  • Met with Production Support Coordinator, Project Managers and Business Liaisons on a regular basis to coordinate work efforts and resource needs and ensure timely and quality solution delivery.
  • Supervised direct reports’ work priorities and resolved conflicts.
  • Provided direction and leadership on a daily basis to ensure development resources delivered sound solutions.
  • Serve as a liaison, build trust and relationships
  • Provided status reports and activity updates to management; Presented team s to management on a regular basis.
  • Developed and maintained relationships with internal and external teams.
  • Disseminated organizational updates and information to the team in a timely manner
  • Implemented following Projects/Initiatives
  • Inbound and Outbound interfaces to multiple third party systems iExpense/P-Card Implementation
  • Re-write of Personnel Action system and Funding solution
  • External Supplier Confidential
  • Accrual Plan Enhancements
  • Interfaces to Student System (Banner)
  • Implementation of hosted RMS and Compensation Systems
  • Process Automation to save data-entry/processing time

Enterprise Technical Lead

Confidential

Application: Oracle E-Business Suite R12 Upgrade and Support

Responsibilities:

  • Provide project management and technical leadership to the development team
  • Contributed to projects and production support as lead developer.
  • Was responsible for the all technical components, system design and technical oversight of complex business initiatives.
  • Coordinated and participated directly in the technical aspects of complex initiatives, projects and production support ensuring scheduled milestones and project/program objectives were met.
  • Operated across multiple projects simultaneously and was responsible for the appropriate architecture and technical implementation of projects.
  • Participated throughout the project life cycle providing input on possible solutions, pitfalls, and issues regarding the initiative.
  • Provided technical input on large cross functional IT projects including build vs. buy analysis, software selection, development, and system integrations.
  • Worked directly with the business, analysts, project management, and the development team to conceive and implement solutions that satisfy various business challenges and objectives.
  • Provided estimates to proposed solutions.
  • Developed project task breakdowns, including timelines and resource allocation.
  • Optimized the development processes by establishing standards and ensuring that standards and processes were followed.
  • Held team meetings and regular knowledge sharing sessions.
  • Projects
  • Oracle EBS R12 Upgrade
  • Implementation of hosted systems - Benefits, Performance Management
  • Automation of Supplier Creation and Maintenance
  • Employee and Student Confidential
  • Rewrite of Taleo-Oracle interface to replace SOA with Oracle Workflow Events
  • Automation of Labor Distribution

Enterprise Programmer Analyst

Confidential

Application: Oracle E-Business Suite 11i Upgrade and Support

Responsibilities:

  • Responsible for design, development and business analysis to enhance and support Oracle EBS Suite.
  • Design and develop WRICE objects (Workflow, Reports, Interfaces, Conversions, Extensions)
  • Produce functional and technical documentation using AIM Methodology
  • Work with Oracle Support to resolve Oracle EBS issues
  • Timekeeping System Implementation
  • Designed and developed program to transfer pay files generated in the third party timekeeping system (Timelink) to MCW network using secure FTP.
  • Designed and developed the inbound interface to validate and import time entry data into Oracle using Payroll APIs.
  • Electronic Personnel Action Support Systems (ePASS)
  • Was part of the project team that designed and implemented an application to process all Personnel Actions including New Hires, Transfers, Promotions, Reclassifications, Terminations and Salary and Funding Changes
  • Designed and developed generic wrappers based on Oracle HR APIs including Position, Person, Assignment, Address and Phone
  • Developed BPEL processes to expose the API wrappers as web services to be consumed by processes interfacing with third-party Applicant Tracking System (Taleo)
  • Designed a funding solution using Oracle Forms to capture the amounts and account allocation for employee salaries.
  • Setup AME components including custom Transaction Type, Attributes, Conditions, Approver Groups and Rules to handle Funding Approvals
  • Automation of Miscellaneous Payments
  • Led the team that designed and implemented the automation of Miscellaneous Payments including Incentive Pay, Bonuses, On Call Pay, Honorariums, etc.
  • Designed and developed custom workflow to handle approvals
  • Setup AME components including custom Transaction Type, Attributes, Conditions, Approver Groups and Rules to handle required approvals
  • Designed and developed a summary form for Payroll to review and transfer Miscellaneous Payment batches to Payroll
  • Budget and Salary Income/Expense (BASIX)
  • Led the initiative to enhance the custom budgeting application used at MCW
  • Used WebADI to enable users to upload data from excel spreadsheet into Oracle custom tables.
  • Used XML Publisher in conjunction with Oracle Reports to provide report data in excel format.
  • Production Support
  • Provide day-to-day support for various Oracle modules including HR, Payroll, Employee Self-Service, OAB, LD, GL, PO, CM and Grants Accounting
  • Provide development approach and effort estimates for enhancement Change Requests
  • Conduct mentoring and sessions to introduce new technologies to the technical staff.
  • Provide functional overviews in the following areas: HR, Payroll, Budgeting

Environment: ORACLE APPLICATIONS R12, 11i (HR, Payroll, Self-Service, OAB, LD, CM, GL, SLA, PO, AP, iExpense, AR, FA, GMS, PA, AME) SQL, PL/SQL, SQL Plus, TOAD, GOLDEN, Oracle Server (Release 8.17.1.0, 9.0.1.3.1), STARTEAM, UNIX, BI PUBLISHER, WEB ADI,AME, Discoverer, SOA, BPEL, JDeveloper, OA Framework, ORACLE DEVELOPER TOOLS (FORMS and REPORTS 6i, 10g)

Confidential

Oracle EBS Consultant (Analyst/Programmer)

Application: Oracle E-Business Suite 11i Upgrade

Responsibilities:

  • Order Management
  • Developed an Order Import program to convert open sales orders in 10.7 to 11i
  • Re-wrote all custom Order Entry processes and reports including Bill of Lading, Pick Slip, Sales Order Acknowledgement using the new Order Management data model.
  • Service
  • Created notifications for Service Incidents.
  • Created a listing all Service Requests by Customer, including the tasks, owner, assignee, estimated effort hours, actual effort hours, notes and resolution for a specific Service Request.
  • Payroll
  • Setup payroll elements and links for Roth 401(K) plan and generated bank files for the new plan.
  • Provide day-to-day support with HR/Payroll issues
  • General Customizations
  • Performed necessary modifications to AP, AR and PO custom reports, processes and views to use the 11i data model
  • Re-applied customizations to forms and reports that were affected by the upgrade; Used Forms Personalization where possible
  • Created ad-hoc reports in WebDB, to enable the users to export the data into excel format
  • Used HR APIs to convert employees’ person details, addresses, phone numbers and assignment details to Oracle for the new site.
  • Designed and developed outbound and inbound interfaces to and from Kronos (Timekeeping system). Involved in the setup of Kronos to ensure that required data was passed to and from Oracle.
  • Inventory
  • Created a program to perform mass Subinventory Transfers by LPNs, and generate a report to list the LPNs with the status of the Subinventory Transfer.
  • Created a program to perform mass Miscellaneous Issues on LPNs that had been shipped to the customer.
  • Created several custom reports for Inventory including reports to list Negative On-Hand Quantities, SubInventory Locator quantities, LPN Quantities by Supplier, Store Room Items in Inventory.
  • Work in Process
  • Created several custom reports for WIP including reports to list Open Work Orders with Deficient Items, Sub-Assembly Material List, Sub-Assembly Supplier List, Work Order Shortage Summary and a Work Order report that used data from Oracle WIP and several custom tables to generate paper work that was used on the shop floor to complete Sub-Assemblies and Kits
  • Designed and developed a Work Order Copy program that enabled users to copy Sub-Assembly and Kit work orders, and generate related paper-work. When copying Kit work orders, all the Sub-Assemblies required for the Kit were also automatically copied.
  • Developed a program to bulk cancel Work Orders.
  • Designed and developed netting process to generate Netting and Excess Inventory reports for the supplier, based on the on-hand quantities and the work order demands
  • Worked on Work Order Close and Purge process to close and then purge work orders that were more a year old.
  • Purchasing
  • Developed PO Import program to be called from a custom form to enable the users to create approved Purchase Orders for specific vendors.
  • The PO Import program was also used to import the initial load of Purchase Orders into Oracle
  • Warehouse Management System
  • Wrote queries to get the LPN Count by Supplier, Putaway Count, Putaway Count by GL Period and Average Putaway time, so the data could be displayed on the Warehouse Dashboard
  • Designed and developed several custom forms to allow users to view, and maintain data in custom tables iSupplier Portal
  • Customized iSupplier Portal to add a new tab to display custom report showing License Plate Number counts by Subinventory
  • Performed VO extensions to display receiving counts in on-hand inventory
  • Displayed open demand by Supplier item on iSupplier Portal
  • Jetform Design
  • Used JetForm Design to modify the file outputs for Customer facing documents including Invoice, PO, Deposit Advice, AP and Payroll Checks
  • Developed a process to generate 2D labels for LPNs using JetForm Design

Environment: ORACLE APPLICATIONS 11i (HR, Payroll, OM, Service, INV, WMS, PO, WIP) SQL, PL/SQL, SQL Plus, SQL Developer, JDevelper, Oracle Server (Release 8.17.1.0, 9.0.1.3.1), WEB DB, ORACLE DEVELOPER TOOLS (FORMS 6i, REPORTS 6i), OA Framework, Jetform

Confidential

Enterprise Programmer Analyst

Application: Oracle Applications 11i Upgrade and Support

Responsibilities:

  • Involved in the 11.5.10 Upgrade and Family Pack K upgrade for Human Resources.
  • Responsibilities included testing and re-applying the required customizations.
  • Set up Payroll Elements and Element links to use the new Oracle functionality.
  • Oracle Advanced Benefits
  • Involved extensively in the setup of life events, collapsing rules, eligibility rules, plans, options, rates and program and plan enrollment requirements.
  • Created Fast Formulas for rates, eligibility rules, and rate and coverage start and end date determination.
  • Customized Accrual Fast Formulas to meet the specific business requirements.
  • Ran Administrative life events for rate/option changes.
  • Was actively involved in the Open Enrollment Process. Responsibilities included set up, testing and processing of the Open life event. Also performed necessary validation after the enrollments were entered and the life event was closed.
  • Involved in the 11.5.9 Upgrade and Family Pack D to Family H upgrade for Human Resources, specializing in Oracle Advanced Benefits. Responsibilities included testing, making required setup changes and creating Fast Formulas to meet the business requirements
  • Involved in the Post Implementation Review process.
  • Payroll
  • Developed custom form for heads down data entry to record the time entry wages, accrual usage and additional payments. Developed a process using element entry APIs to create non-recurring element entries in Payroll from the data entered in the Heads Down Data Entry form.
  • Customized Oracle Seeded Reports using Oracle Reports to meet MCW requirements - Payroll Register, Deposit Advice, Check Writer.
  • Modifications to payroll fast formulas to meet MCW requirements.
  • System Administration
  • Set up Flexfields, Value Sets, Lookups, Concurrent Programs and Executables, Register custom forms, Define Form Functions, Menus and Responsibilities, Manage Request Groups.
  • Designed and developed custom payroll reports using Oracle Reports.
  • Created custom payroll balances for the ease of reporting.
  • Converted Visa related data for foreign nationals in the Extra Person Information DFF and Special Person Information KFF using APIs.
  • Oracle Human Resources
  • Designed and developed custom HR reports using Oracle reports and UNIX shell scripts.
  • Set up audit trails on HR tables to report new hires, corrections, updates and deletes in daily audit reports.
  • Created Oracle Alerts to send e-mail notifications to users based on the changes occurring in the system.
  • Labor Distribution
  • Designed and developed custom LD reports using Oracle reports to verify labor schedules and labor distribution adjustments.
  • Designed and developed a solution to reconcile historical and current labor distribution data for reporting purposes.
  • Created a process to upload monthly labor schedules for Residents.
  • General Ledger
  • Created Transaction Listing Report to lists the transactions for all accounts along with the beginning and ending balances for each account. The report drilled down to the sub-ledgers (Payables, Receivables and Purchasing) to get the PO, Invoice, Receipt, Vendor and Project details based on the journal source.
  • Developed a process to extract all GL transactions along with sub-ledger information into a custom table. Views based on the table were made available to end-users through Discoverer.
  • Budget and Salary Income/Expense (BASIX) - Custom Application for position and general budgeting
  • Designed and developed custom forms conforming to Oracle Application User Interface and Coding Standards.
  • Defined and developed concurrent programs and procedures to allow the download of required data from Oracle EBS to start the budget.
  • Create multiple reports including crosstab reports using Oracle Reports.
  • Created upload processes to load approved budget to General Ledger along with the positions, salaries and labor schedules to the respective systems in Oracle Applications.
  • Electronic Personnel Action Requests (ePAR)
  • Created a custom OA Framework page to capture changes to Budgeting data when processing a HR personnel action.
  • Made changes to various ePAR action workflows to display the BASIX page.
  • Created a concurrent program to update the BASIX data from the interface table that was populated by ePAR.
  • Created a form to display status of the records in the interface table.

Environment: ORACLE APPLICATIONS 11i (HR, Payroll, OAB, LD, GL, Fast Formula) SQL, PL/SQL, SQL Plus, TOAD, GOLDEN, OA Framework, JDeveloper, Oracle Server (Release 8.17.1.0, 9.0.1.3.1), STARTEAM, UNIX, Oracle Developer Tools (FORMS, REPORTS)

Confidential, Pewaukee, WI

Oracle Portal Consultant

Application: Employee Portal

Responsibilities:

  • Involved in the installation of the Application Server and the Database Server.
  • Involved in development of an intranet site implementing the Oracle Portal technology.
  • Implemented Oracle Ultrasearch - a global search tool to perform cross-repository search.
  • Implemented Corporate Calendar portlet to enable users to view and search monthly corporate events in a calendar format. Portal Form was developed for data maintenance.
  • Developed Scheduled Outage Calendar to provide monthly view of scheduled outages by area. The calendar provided hyperlinks to appropriate applications where the users could view and maintain data for the specific outage.
  • Implemented stock and weather portlets.

Environment: ORACLE PORTAL 9.0.2.2.22 SQL, PL/SQL, SQL Plus, Javascript, HTML, Oracle Server (Release 9.0.1.3.1)

We'd love your feedback!