Mwaura Muiruri

*** * **** ** *******, IA ***** 563-***-**** ac3rye@r.postjobfree.com

Decorah, IA

Summary

Mwaura is an Oracle Applications Developer with 11+ years of experience including analysis, customization, upgrade, implementation and support of Oracle e-Business Suite Applications (R12, 11i). He is employed full-time by the University of Northern Iowa and is looking for an opportunity to work in a Business/Commercial Environment and continue his career. Mwaura resides in Decorah, IA, is a Permanent US Resident (Green Card Holder), and is available and will relocate with a 2-week notice.

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 and Oracle packaged APIs.

Technically proficient in RICE 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 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

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

Oracle ERP Programmer Analyst

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.

Customized Cash Management interface to import Payments from banks.

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

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

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.

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 loadrequirements, customer/vendor contact information, and job schedules.

Implemented new client and suppliers by working with business and data integration team members todefine 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

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 use 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