Oracle E-Business Suite Functional / Technical Lead
Resume:
DONALD WEKESA
H: +1-571-***-**** *.******@*****.***
PROFESSIONAL SUMMARY
•11+ Years of experience in analysis, design, testing and implementation of Oracle projects and report building
•Experience in doing Fit/Gap analysis, design, system setup, configuration, testing and implementation, documentation, training and production support of complex applications.
•Worked extensively in Oracle Applications modules INV PO, AME and AP.
•Secondary skills on AP, AR, PL/SQL.
•Expertise in Order-to-Cash cycle and Procure-to-Pay cycle.
•Did multiple full cycle end to end implementations, Upgrade and support projects of Oracle E-Business Suite Applications 11.5.10, R12.0.4, 12.1.1 and 12.1.3.
•Experience in preparing Configuration and Design documents, Process documents, training material, Test scripts and conducting trainings and client presentations.
•Expertise in SYSADMIN and Oracle Applications activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flex field, registering menus, concurrent programs, providing support to apps users for any functional issues.
•Managed all technical and financial aspects of the annual budget process, providing analytical support, budget data and other financial data for month-end closing.
•Strong documentation, analysis, requirement skills and good interpersonal and communication skills to work with clients and team members.
•Engaged in multiple business development activities like Uats, Sits and Fats with various clients of Oracle consulting.
•Co-ordinate with Onsite/Offshore Functional and technical teams.
•Good exposure on Oracle Applications Implementation Methodology (AIM).
•Experience in conducting Oracle Apps trainings to various levels of people in the organization.
•Ability to work with SQL query tools such as SQL* Plus, Toad.
•Proficient in working with Oracle Service Requests (TAR)
•Skills in Single-Org to Multi-Org implementation of Oracle E-Business Suite.
•Excellent oral and written communication skills and client interaction.
Areas of Expertise
•OTBI developer
•FRS developer
•Dexterity in Windows operating systems:
•Windows Professional
•Oracle approvals- AME and Supervisory Hierarchy
•Item Master and Product data hub
•Expertise in supply chain components:
•PO
•Pricing and advanced pricing Administration
•Manufactucturing, work definitions, routings and item structures
•Specialist in primary financials:
•I procurement and Oracle Cloud Procurement
•Incentive Compensation
•Conceptual knowledge of ERP application components:
•Sound abilities to:
•Conduct variance analysis and implement process improvements
•Proficiency in business intelligence tools like power Bi, SSIS, SSRS, BI Publisher, Jasper reports and discovery reports
Work Experience
Senior Oracle Business Analyst Order Management (Astec industries)
Managed the implementation of Supply Chain Modules, including back-to-back fulfillment, internal material transfers, contract manufacturing, and inventory management.
Configured order management extensions like customer classes on the order header level to ensure the right pricing for Sales orders.
Configured transformation rules to determine the right order types for Returns
Worked with sales and AR to develop pricing matrix classes, pricing strategies, price lists, discount list and cost list to fit the business model.
Implemented and enforced pricing rules and guidelines, ensuring compliance with corporate policies and preventing excessive discounts across all sales channels.
Documented AS-IS and later the to-be BRDS.
Configure specific model pricing that encapsulates not only the highest tier but all the sub-assemblies and components.
Configured and enabled redwood pricing approvals
I was part of the pricing redesign project that involved rationalization of order types, customer classes and intercompany cost lists
Conducted in-depth pricing and margin analysis to identify opportunities for price adjustments, contributing to an overall increase in annual profit margin.
Developed both OTBI and Bi publisher reports and dashboards pricing reports that aid in analyzing price changes across legal entities
Configured work definitions, item definitions including item structures for CTOs, and ETOs
Implemented sourcing rules and distribution rules.
Configured Inventory organizations, sub inventories ad locators.
Implemented Pick slip groupings, pick waves and intercompany routing.
Senior System Integration Analyst (Whitecap)
Apr 2023- Sept 2023
•Gather, analyze, and document business requirements for internal customers.
•Ensure technology solutions align with business needs and strategic goals.
•Research, design, document, test, and leverage business solutions.
•Assist in defining and planning departmental project roadmaps.
•Partner with clients and manage prioritization and delivery of IT services for WMS integration to oracle R12.1.3.
Senior oracle cloud implementation Analyst (MSD- Metropolitan sewage District)
St Louis, Missouri
•Install and configure the FRS cloud studio.
•Analyze user requirements and build financial reports using smart view.
•Build specialized reports for procurement and HCM departments using OTBI and data models.
•Build adhoc reports used by OIC for the integrations between cloud and other applications.
•Convert OBIEE reports to the OTBI.
Senior Business Analyst (Ameren Cooperation)
St Louis, Missouri
December 2019- 2022.
•Configure the oracle cloud purchasing and procurement modules based on the user requirements.
•Implement jobe level for approvals
•Inventory and Location set up.
•Account builder configuration
•Common set up of Payables
•Advising business on leading practices.
•Analysing reporting requirement
•Developing process documentation e.g. BR100, MD50, MD45 etc.
•Install and configure the FRS cloud studio
•Install and configure the FRS cloud studio.
•Build specialized reports for the company
•Create reports from different systems in OAC( oracle Cloud Reporting)
Oracle Logistics Expert and Technical (The Brunswick Group)
Kampala, Uganda
January 2019- May 2019
•Providing International & Multi-Cultural Team Leadership
•Assessing Project, Risk, Quality and Budget Management
•Participating in Critical Problem Solving - Design Thinking
•Executing Leadership, Communication & Strategic Planning
•Engaging Stakeholder Relationship Management and Vendor, Contract & License Management
•Specializing Agile Methodology, Business Analysis & Requirements Gathering
•ERP Implementation & System Development Life Cycle
•Application Performance Management - AppDynamics
•Oracle Managed Cloud Services.
Jasper Developer/Analyst
Trans skills LLC Dubai.
September2018- January 2019
•Worked on optimizing jasper server with known configuration settings
•Customizing the implementation of existing jasper implementation
•Generating ADHoc view according to the required domains
•Write documentation on reports based on creating reports managing server domains etc...
•Analyze the functional & technical requirements and of the project.
•Create new Users, Roles and manage Jasper Server Repository.
•Create new Input Controls; Drop down lists, resource bundles on the Jasper Server.
•Designed and developed user friendly Financial and Billing reports using PL/SQL, Analytic Functions, SQL, iReport and deployed onto Jasper Server.
•Developed Cash reconciliations and Securities reconciliations reports.
•Created batch jobs for the data cleansing and generation of summarized reports.
Environment: Jasper Server 6.1.1/6.0.1, Jasper Analysis, iReport 5.6.0, SQL, PL/SQL, MySQL 5.0.27, Jasper Analysis, Java, Sun Solaris, Unix Shell Scripting
Oracle Project Support (Oracle Supply Chain Management Lead Consultant)-
Wipro, MTN Johannesburg
June 2016 – August 2017.
•Proficiency in business cycles, P2P (Procure to pay) and O2C (Order to
Cash).
•ASCP souring rules configuration to allow ATP and OM’s SO scheduling process to define “source from” calculation based on customer site’s region
•Negotiate technical and non-technical solutions that both satisfy the
•Business user and conform to the technical architecture.
•Analyzed client business requirements and translate these into appropriate
•Configuration specifications.
•Functional knowledge of Oracle Financial applications with configuration skills,
•Process definition, analysis, design, & implementation.
•Participated requirements definition/mapping & application of required configuration
•Changes, test plan, scenario & script development.
•Provided support in the development cycle, starting from business process and definition to configuration and unit testing, assistance and follow-up with user
•Testing through to co-ordination of transports to Production & post-live support.
•Developing and maintaining the configuration and functional design documents and
•Supporting role-based profile changes.
•Experience in Maintaining and Supporting Oracle Applications Version R12
•(Inventory - INV, Warehouse Management System - WMS, Work-In-Process -
•WIP, Bill of Materials - BOM, Oracle Receiving (RCV: Procure-To-Pay), Oracle
•Order Management (OM: Order-To-Cash), Oracle Shipping - WSH, Workflow
•And System Admin.) And Oracle Fusion
•In-depth knowledge of Oracle Applications Inventory (INV), Warehouse
Management System (WMS), Work-In-Process (WIP) and the underlying tables and ASCP.
Configured and managed complex pricing rules and strategies, including price lists and discount lists, to meet profitability goals.
Collaborated with sales and finance teams to define and implement pricing strategies for new product launches.
Utilized PL/SQL to develop custom pricing logic for unique customer tiers and promotions.
Reduced pricing errors by 20% by implementing automated pricing validation processes.
Supported the pricing management team with the implementation of new pricing initiatives and strategies
Assisted with general pricing inquiries and the entry of pricing data into various systems, including Oracle EBS R12
Troubleshot and resolved complex pricing issues within the Oracle Advanced Pricing module and its integration with Order Management.
Powertech System Integrators- System Integration Engineer/BI system analyst
FEB 2015-MAY 2016
•Participate in the integration between the billing system and Ecwin manager.
•Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008/2012 R2.
•Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
•Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
•Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
•Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
•Developing reports on SSRS on SQL Server (2000/2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
•Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
•Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
•Provided technical support and development to the Profitability Systems and Reporting group. The group leveraged Microsoft's BI tools and Acorn's modeling software to implement accurate models, cubes, and reporting on customer and product profitability for the company's global business operations.
•Designed and developed Data Warehouse for the Profitability Systems and Reporting group.
•Implemented technical projects into production.
•Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagrams using MS Visio tools.
•Implemented and managed project Change Control System and processes and tracks project issues resolution.
•Managed team SharePoint site.
•Prioritized and handled multiple tasks in high-pressure environment.
IBM IT Specialist –ERP
AIRTEL UGANDA
JUNE 2013-JUNE 2014
• Experience in Maintaining and Supporting Oracle Applications version R12 (Inventory - INV, Warehouse Management System - WMS, Work-In-Process - WIP, Bill Of Materials - BOM, Oracle Receiving (RCV: Procure-To-Pay), Oracle Order Management (OM: Order-To-Cash), Oracle Shipping - WSH, Workflow and System Admin.) and Oracle Fusion
•In-depth knowledge of Oracle Applications Inventory (INV), Warehouse Management System (WMS), Work-In-Process (WIP) and the underlying tables that support the application modules.
•Participated in the implementation of Africa single instance oracle e business suite for all Africa operational countries under Airtel thus included AP, GL.AR, CM, OM and inventory.
•Solving day to day operational requirements like training, troubleshooting in modules like AP, GL, Inventory, costing etc.
•In charge of managing ERP and relevant applications in a smooth manner.
•Ensure the optimal usage of systems in the business.
•Implement business Processes in ERP.
•Custodian of the configuration data for this includes customization of desktop web ADI for oracle r12, setting up approval hierarchies both positional and AME.
•Provide input and guide regarding Oracle Applications capabilities and functions to the business.
•Anticipate problems and resolve them in time, to the highest quality, meeting or exceeding business expectations.
•Participate in the development of processes and procedures for ERP implementation projects
•Analyze client business requirements and translate these into appropriate configuration specifications.
•Functional knowledge of Oracle Financial applications with configuration skills, process definition, analysis, design, & implementation.
•Requirements definition/mapping & application of required configuration changes, test plan, scenario & script development.
•Provide support in the development cycle, starting from business process definition to configuration and unit testing, assistance and follow-up with user testing through to co-ordination of transports to Production & post-live support.
•Develop and maintain the configuration and functional design documents and support role-based profile changes.
Oracle ASCP ANALYST –ERP
WARID Telecom (Uganda) Limited
JULY 2011 – JULY 2013
•
Expertise in analyzing business requirements as a part of implementation, up gradation projects and provides extensive functional support for Post-Production Support projects in SCM and MFG Modules of Oracle Applications R12 and 11i.
Extensive knowledge in Oracle EBS modules including Inventory (INV), Order Management (OM), Purchasing (PO), Work In Process (WIP) & Shipping (WSH).
Good experience in Application Set up Activities and Production Support of INV, BOM, ENG, WIP, AP MPS/MRP, ASCP, MSCA (Mobile Supply Chain Applications), OM, PO, Costing, I Supplier and iProcurement modules of Oracle Applications (R12/11i/10.7).
Proficient in business cycles, P2P (Procure to pay) and O2C (Order to Cash).Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.
•Participated in the migration of Oracle Costing, WIP, BOM, MRP, Planning and OM to version 11.5.10.
•Table mapping identification and registration.
•Custom objects control and classification into a repository.
•Custom objects migration for WIP, BOM, Costing, MRP, Planning and Order Management modules.
•Design, analysis and development of enhancements and new features, including customized reports, procedures and forms, in order to adapt Oracle solution and meet customer requirements.
•Responsible for tuning and continuous performance improvements.
•Coaching of team members in Planning, Inventory, WIP, BOM, Costing, OM and MRP modules.
•Development of migration documentation, including issues detected and improvements implemented during the Go Live.
•Onsite Analyst for the requirements during the upgrade process. Coordination of the Offshore Team (5 members) to accomplish and meet time and scope agreements to complete the required migration.
•Analyze client business requirements and translate these into appropriate configuration specifications.
•Functional knowledge of Oracle Financial applications with configuration skills, process definition, analysis, design, & implementation.
•Requirements definition/mapping & application of required configuration changes, test plan, scenario & script development.
•Provide support in the development cycle, starting from business process definition to configuration and unit testing, assistance and follow-up with user testing through to co-ordination of transports to Production & post-live support.
•Develop and maintain the configuration and functional design documents and support role-based profile changes.
•Experience in Maintaining and Supporting Oracle Applications version R12 (Inventory - INV, Warehouse Management System - WMS, Work-In-Process - WIP, Bill Of Materials - BOM, Oracle Receiving (RCV: Procure-To-Pay), Oracle Order Management (OM: Order-To-Cash), Oracle Shipping - WSH, Workflow and System Admin.) and Oracle Fusion
•In-depth knowledge of Oracle Applications Inventory (INV), Warehouse Management System (WMS), Work-In-Process (WIP) and the underlying tables that support the application modules.
SYSTEM ANALYSTWARID Telecom (Uganda) Limited-Kampala
MARCH 2008 – JULY 2011
•In charge of provisioning and MS CRM in the information technology department of the company. Responsibilities include:
•Responsible for designing and implementing the subsidiary portal, and applications in visual studio that is currently used for provisioning.
•Customizing and designing reports for users in sql and jasper reporting tool
•Responsible for customizing CRM modules tofit the ever-varying user needs like CRM forms, attributes and settings.
•Supporting the implementation of CRM and other support systems through the development and implementation phases
•Ensuring adherence to procedures and controls for minimizing revenue leakage in the service provisioning and customer management
•Testing and validating system deliverables.
•Ensuring adherence to change management procedures.
•Ensuring Service Call Resolution within SLA.
•Ensuring Systems Security (System Access)
•Allocating access to authorized users based on access requisition forms
•Ensuring CRM & FORIS System Availability
•Providing enough reports about service provisioning activity between the billing system and the NE’s
•Ensuring timely reconciliations between the NE’s and the billing system
•Providing internal customer support
•Provisioning efficiency
•Maintaining service quality targets
•Supporting the customer complaints handling function
•Monitoring the services in Tibco.
•Handling service reports including daily customer care reports
•Offering support to the billing function
•Offering support to all business centers and call centers throughout their daily activities including swapping and reactivation of sim swaps
•Participating in adjacent system validations, development and deployment
•Participating in product testing in conjunction with Engineering/Quality Assurance, and vendors
•Backing up of BSS applications and failovers thus actively participating in (among others) smoke tests
•Continuously participating in customizing and developing supplementary modules to CRM and other semi-independent systems
Education
Walden university- MSC information system (global chain supply)- present
University of Eastern Africa Baraton- BSc Software Engineering 2002/3-2006/7
Kabojja High School- Advanced Level Certificate 1999-2001
Hillside High School- GCSE 1998
Professional Affiliations
ug.linkedin.com/pub/donald-wekesa/16/528/14/
Toolbox.com username donnay
Additional Information
PERSONAL PARTICULARS
Surname: Wekesa.
First name: Donald.
Date of birth: 11th December 1981
Sex: Male.
Marital Status: Married.
Nationality: Ugandan.
References
Mr. Leonardo Thomas
Acting Senior Manager IT Operations
MTN South Africa
********.******@***.***
Mr. Cosmas Ssematimba
Assistant IT manager
Warid Telecom
*********@*****.***
Contact this candidate