Oracle Applications EBS Developer

Mwaura Muiruri

** *** *** * #*

Hopkins MN *****

563-***-**** *******.*******@*****.***

Summary

Mwaura is an Oracle Applications Developer analyst with 13+ years of experience including analysis, customization, upgrade, implementation and support of Oracle e-Business Suite Applications (R12, 11i).

Additional Qualification Highlights

Extensive experience in implementation, Migration, Customization, and Production Support of various modules in Oracle Applications with major focus in General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO),Inventory (INV), Human Resources (HR), and Cash Management (CM).

Hands-on experience in Data Conversion, Data Migration and Developing Interfaces within several modules in Oracle Applications using PL/SQL, SQL*Loader, UNIX/Linux, Python and Oracle packaged APIs.

Technically proficient in RICE(CEMLI) components (Reports, Interfaces, Conversions and Extensions).

Expertise on designing and implementing Oracle Alerts.

Expertise on developing new reports by using XML Publisher (BI Publisher).

Developed and modified reports using OBIEE.

Developed new Concurrent Programs, Packages, Procedures, Functions,UNIX shell scripts, and Flex Field Customizations.

Performance tuning of long running SQL queries, packages and procedures.

Interacts with users in providing daily production support, troubleshoots issues, and documents/creates and follows up on Oracle service requests (SRs).

Professional Experience

Graco Inc., Minneapolis, MN Apr. 2022 – Present

Senior Oracle EBS Developer

Developing and customizing interfaces for Oracle EBS Applications R12.1.3 and 12.2.11 in

Modules AP, AR, OM, INV, PO, WMS and SCM

Worked on code mitigations during upgrade from Oracle EBS R12.1.3 to 12.2.11

Customize Oracle reports, XML(BI) Publisher reports, forms and workflows to meet functional business requirements.

Design, develop, and test custom extensions (e.g. packages, functions, procedures, and triggers), and APIs using PL/SQL, Unix and Powershell.

Performance tuning long running processes.

Optimizing data processing using bulk collect/collections.

Work with end users and functional analysts to capture and document business requirements.

Work with end users and functional analysts to perform unit, system, and regression testing.

Migrating code changes to production environment.

Develop documentation to detail development, logic and testing processes.

Provided after-hours on-call support on a rotating basis and as needed.

Meredith Corporation., Des Moines, IA Nov. 2018 – Mar. 2022

Oracle EBS Developer

Responsibilities:

Developing various reports using XML Publisher.

Performs requirements gathering from users via meetings, phone, email and IM.

Worked on R12 AP Payment process change specific to external vendor requirement.

Introduced Use of FNDLOAD to migrate objects to other Instances after development.

Writing stored packages, procedures, functions and scripts using PL/SQL, unix, powershell and python.

Code Performance Tuning and Testing.

Design, preparation, and conduction of workshops and training sessions for end users on new and lesser-known features for improvement of day-to-day productivity.

Full UAT testing Cycles for each business process.

Support of production environment and users on a daily basis by responding to various ticket requests.

Developed various interface/conversion programs for AP and AR.

Wipro Ltd., East Brunswick, NJ Feb. 2018 – Oct. 2018

Oracle EBS Developer

Responsibilities:

Developing various reports using XML Publisher.

Modification of Forms thought personalization.

Writing stored packages, procedures and functions using PL/SQL.

Code Performance Tuning and Testing.

Design, preparation, and conduction of workshops and training sessions for end users on new and lesser-known features for improvement of day-to-day productivity.

Full UAT testing Cycles for each business process.

Support of production environment and users on a daily basis by responding to various ticket requests.

Developing interface/conversion programs.

University of Northern Iowa, Cedar Falls, IA Oct. 2010 – Feb. 2018

Oracle ERP Techno Functional Consultant

Responsible for development of customizations to meet business requirement using PL/SQL for University’s Oracle EBusiness Applications. Role includes trouble shooting and fixing issues, and liaising with third party vendors to resolve issues.

Participated in upgrade from Oracle applications 11i to R12.

Performs requirements gathering from users via meetings, phone, email and IM.

Worked on R12 AP Payment process changes due to changed functionalities from 11i.

Educated users on how to use the new R12 Payment Process.

Developed and implemented AP Invoice interfaces.

Developed and transmitted various reports/files for external vendors.

Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing

Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle

Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing

Working on workflow builder to modify the PO REAPPROVAL workflow to meet the client requirements

Created Item categories, category sets, category codes, default category sets for the various items in Inventory application

Setting up Item templates, Item attributes, UOM and UOM classes in Inventory

Made OAF customizations and extensions for HR, AP, PO, and iProcurement.

Setup Banks in Cash Management

Customized Cash Management interface to import Payments from banks.

Accounts Receivable Setups

Customized Accounts Receivable Autoinvoice and Customers interfaces

Set up custom R12 Advanced Collections Dunning Letters due to changed functionalities from 11i.

Added DFF to Accounts Receivable Transactions Workbench

Designed custom BI/XML RTF templates for Check Printing in Payables and Payroll on blank stock.

Developed and setup AP Positive pay template and transmit file to bank.

Customized 1099 misc reports to print both sides on blank stock.

Creation of new custom reports and customizing of existing reports using Oracle XML/BI Publisher

Creation of new custom reports and customizing of existing reports using OBIEE Answers and Analysis.

Created eMail notifications to employees when changes in payroll bank information are made via self-service or change request form.

Created electronic I9 file that is transmitted regularly to external I9 vendor.

Created and modified fast formulas.

Developed plenty of Alerts to supervisors and employees when certain conditions are met.

Developed Linux/Unixshell scripts to load data from staging tables into the interface tables and call the concurrent programs to populate the base tables as part of the conversion.

Uses FNDLOAD to migrate objects to other Instances after development.

Stores all code in CVS (Concurrent Versions System) and SVN (Subversion) repository software.

Registered customized reports and concurrent program/sets using System Administrator and Application Developer

Involved in the tuning of 11i/R12 applications PL/SQL and SQL scripts.

Generated Statspack/AWR reports and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth

Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements

Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database

Dealing with large amounts of data (tuning/performance/design)

Updates custom 1099 and W2 templates yearly.

Documents all customizations using Oracle AIM methodology like BR100,MD120,and MD70.

Extensively worked on developing PL/SQL functions, procedures, triggers, alerts Unix/Linux shell scripts and packages.

Advanced PL/SQL like Bulk Collect, Collections, Pipeline Function, Analytic Functions

Involved in troubleshooting issues including creation/follow-up of Oracle Service requests (SRs).

Conducted quality reviews of code developed by other development staff.

Pinnacle Financial Services. Decorah, IA April 2009 – Sept. 2010

Data Integration Specialist

Responsible for handling and processing data files into Pinnacle business applications with clients and suppliers. Assist in the analysis of client and vendor requirements, define data process flows, and maintain data processing documentation. Verify the correctness and completeness of electronic data, reporting and correcting data issues, and providing recommendations for improving data processing tasks.

Established and maintained processing procedures for electronic data processing including data load requirements, customer/vendor contact information, and job schedules.

Implemented new client and suppliers by working with business and data integration team members to define requirements and procedures.

Developed various interfaces, both inbound and outbound, which are run on periodic basis using SQL*Loader control programs and PL/SQL validation procedures.

Monitored and reported on data or job processing issues as they are moved into production environments.

Created an Alert that triggers as per defined business rules.

Wrote data Migration Unix scripts/create table scripts to load database schema

Researched and resolved data quality or integration issues that are raised or escalated by clients or vendors.

Provided production support and worked with other IT team members to implement enhancements and correct defects.

Performed quality assurance functions (test plans, functional and user testing).

Worked and communicated with cross-functional teams and customers.

Global Soft Tech Inc., Woodbridge, NJ Feb. 2006 – March 2009

Systems Programmer Analyst

Involved in planning and setup of multiple businesses and integrating it into single operating unit, conversion of legacy and open data from multiple operating units into one operating unit. Involved in the complete lifecycle; requirements gathering, design, develop, test and support.

Implemented and supported Oracle Financial Modules GL,AR, AP,PO,INV & CM

Performed review of the business, involved in Requirement gathering, prepared Test Plan preparations and code Development.

Preparation of AS IS and TO BE Process, Understanding legacy system and mapping business process requirements with the same.

Acting as a liaison between client and technical team to enable product development with a close fit to client requirements.

Involved in assisting functional users with Setups procedures for GL, AR, PO and AP

Involved in the analysis of the assigned support tickets, replicating the issue, analysing the custom processes and updating the ticket with the appropriate resolution.

Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to other instances, assist user testing and closing tickets.

Created and modified several UNIX/LINUX shell scripts according to the changing needs of the project and client requirements

Developed various custom reports for all modules using XML Publisher.

Customized existing forms with descriptive flex fields and migrate to other instances.

Worked on the Email notification program to notify the users on failed processes.

Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code.

Review daily support SR’s, co-ordinate with users and resolve issues

Identify SR’s as GAP’s that need customization and review with management with GAP analysis document

Interaction with the users during month end closing and testing when new patches are applied.

Worked on the development of interfaces, Data Conversions, Developing new Reports in XML/BI Publisher for various modules such as HR, AR, PO,INV, AP and GL.

Implemented AP Invoice import through Payables Open Interface Import Program.

Involved in the conversion of Inventory (INV) Items and Item Category data from legacy to Oracle ERP.

Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.

Customized Inactive Item Report and Cancelled Sales Order Report.

Created Service Requests with Oracle Support for different issues identified in test instances and Production.

Developed PL/SQL procedures, functions, packages, triggers to validate the data and insert the validated data into Oracle Standard interface tables.

Proactively tuned SQL queries using Explain Plan, Hints and indexes.

Education

MSc in Management Information Systems – Metropolitan State University, St Paul, MN

BSc in computer Science – Metropolitan State University, St Paul, MN

BSc (Honors)- University of Nairobi, Kenya

Contact this candidate