Sabbir Ahmed
SPECTRUM / COX
Dacula,GA
31
years of professional experience
Senior Oracle Supply Chain Solution Architect with 30+ years of experience leading Oracle EBS implementations across manufacturing, utilities, and industrial sectors. Proven architect of end-to-end supply chain solutions spanning demand and supply planning, manufacturing, inventory, quality, and complex third-party integrations. Designing, integrating, and optimizing systems. Proven track record translating complex business operations into high-fidelity technical requirements, managing onshore/offshore teams. Deep expertise aligning business transformation with scalable Oracle architecture.
Skills
Oracle applications technical developer and analyst with expertise in procure to pay
order to cash
forecast to plan
demand to build
financials
manufacturing (discrete and process both)
ASCP
MRP
WIP
Quality
HR/Payroll and Oracle projects & contracts modules.
Excellent knowledge of AOL (Application Object Library) and System Administration Modules.
Expertise in implementing RICE (Reports
Interfaces
Conversions
Extensions) components in the area of technical design
development
Integration testing and deployment.- MSCA
Shipping Execution.
Extensive experience in Oracle Applications Open Interfaces and Standard API’s- SQL & Data Structures.
Worked extensively in Multi-Org architecture.
Extensive experience in design and development of Oracle Reports
PL/SQL Packages
Database Triggers and customization of Oracle objects.
Extensive experience in developing and customization of oracle workflow.
Worked on Oracle Application Framework (OAF)
which includes customization and personalization.
Extensive experience in XML/BI Publisher
which includes working on report development objects like data templates and RTF’s.
Worked extensively with data warehouse project using CDC
Stream and IIDR.
Experience with data archive using Applimation & Optim system.
Extensive knowledge of Trading Community Architecture (TCA). Imported customer and supplier information into oracle from legacy systems.
Designed Technical Documentation using AIM Methodologies (MD50
MD70 and CV40).
Extensively worked on Shell and Perl Scripts. Solid experience with Java programming.
Worked extensively on Month End Close Process Issues.
Possess excellent communication skills
strong proficiency in problem solving
provide alternate & efficient solutions for critical issues.
Work History
Solution Architect
10 Years 3 Months- Solution Architect for Oracle supply chain applications and OBIEE/ODI applications of shared services team. Support production environments and users on a daily basis by responding to emergency requests (24x7).
- Lead and manage blended delivery teams (onshore & offshore), providing architectural direction, design validation, and delivery governance. Prioritize and assign incidents, provide KPI matrix of team performance to management.
- Identify and maintain list of custom RICE objects, scheduled concurrent & Control-M jobs. Work diligently to handle tickets both QuickBase & Service NOW.
- Coordinated project team during go live for Cox Media Group, engage in UAT, known issues, design changes to obtain better understanding of the project. Identify any training/knowledge transition activities needed. Obtain training, knowledge transition and MD.50, MD.70 documents, service guides, code review, architecture design, application monitoring plan from project team. Ensure problem management process is aligned with current business unit.
- Analyze current business processes, design future business flows, perform business requirements mapping, and identify gaps, impact, workarounds and reporting needs for custom interface for order management and inventory module.
- Support of production systems globally within Supply Chain stream (PO, iPoc, OSN, OM, INV & FastFax). Handle Enhancement requests - Review, discuss, Analysis, Feasibility, Design, Testing & Deployment and approve requirements for enhancements to the application and its surrounding processes. Day to day issue resolution with documenting solutions in the ticketing tool (SNOW).
- Design, develop & implement all integrations with third-party logistic partner, reduce error for better integration, perform root cause analysis for future prevention, develop alert system to handle error or unexpected behavior and weekly alert to notify performance matrix with management team. Also developed alternate solutions in case of integration failures.
- Immense improvement for procurement team. Start with process to conform correct item setup, blanket purchase agreement (BPA) is in synch with approved supplier list (ASL) so workflow automation is seamless, notifying any pending approval activity, supplier communications are established as expected, all approval follows employee authorization limits & high dollar orders are brought to attention of procurement team.
- Developed custom Min-max planning for contractor organizations to replenish inventory by creating transfer order from sourcing organization.
- Facilitate month end closure (MEC) process, ensure all transactions are costed & posted. Generate various reports for finance team to reconcile with balance book.
- Conduct KT (knowledge Transfer) sessions to enhance team strength & build internal repository.
Senior Analyst
5 Years 11 Months- Key member of Enterprise Solution (ES) upgrade of Oracle EBS to 12.2.4. Role involved gap and functional analysis, new features review, testing and UAT coordination documentation.
- Involved in identifying custom objects, incorporate R12 changes, adding new functionality, bug and issue mitigation from previous customizations.
- Worked on technical Design (MD070), implementation Design (MD120) and testing (TE020) documents.
- Major technical changes includes, incorporating Sabrix tax engine with R12 Payable module, redesigning interface between Oracle GL and Data Repository (DR) for Southern Accounting & Reporting Analysis (SARA) system.
- Developed routines to Drilldown Subledger (SLA) for reporting purpose and AP Invoice interface system design between Oracle and Maximo systems.
- Involved in workflow customization for AP Invoice approval.
- Applied payment process customization, developed new BI Publisher template for ACH, EDI and positive payment and modify template for Check print. Developed process to securely transfer payment files to bank, convert all custom reports from reports builder to Bi publisher.
- Implement MasterCard transaction for i-Expense application. Developed a process to recover personal expenses of using corporate credit card through payroll deduction. Customization of Inventory Validation process, apply holds based on business requirement (large amount, foreign supplier etc).
- Applied Performance Improvement for many custom processes like PP-122, PP-147 & DR streaming. Significant improvement in "Duplicate invoice monitoring" process, improve Invoice locking issue for Sabrix tax process.
- Data repository (DR) streaming improvement during month end when try to process large volume of data.
- Interface development: Developed Supplier interface with BRW02, a supplier maintenance system used by different ERP. Invoice load from other application, Employee load from SHIPS. Purchase Order, Invoice & Payment interface and re-trigger process with Maximo ERP system.
- Set Up Min-Max planning for Southern Linc Inventory, automate process to replenish inventory at retail level from corporate. Key member in implementing Depot repair and Service contract module.
- Developed many reports as per user requirements, also developed process for Data repair automation. Replace Oracle Warehouse Builder (OWB) & used custom PL/Sql load for streaming process.
- Developed several audit report for internal audit group. Implement concurrent request move & purge program. The system deals with large amount of concurrent requests daily & there is specific business need to purge them.
- Technical lead of Production support team in resolving daily issues & month end closing related issues. An alternate solution was developed for data repository system which is used for financial reporting and reduced the closing time from 8 hours to 30 minutes for one of the busiest closing nights.
- Key member for Disaster Recovery exercise, co-ordinate password change & monthly release management, perform code review & one of the approvers for change management application.
- Environment: Oracle EBS R12.2.4, 12.1.3 & 11.5.10. AP, GL, i-Expense, PO, AR, INV, OM, BOM, PA, Service Contracts, Depot Repair. Oracle 9i, 10g, 11g. Reports 10g, Forms 10g. Workflow Builder, JDeveloper, PL/SQL, SQL
- Loader, TOAD, Linux, Unix, Java, Oracle R.I.C.E, BI Publisher Reports.
Senior Developer-Analyst
1 Year 4 Months- Developed and implemented custom IT solutions to create efficiency within the organizations Inventory, BOM, WIP, Quality, Purchasing, Payables and HR modules.
- Collaborated with business users to analyze and understand business problems and needs. Lead process configuration and system activities.
- Involved in CRP meetings to discuss the issues and concerns regarding various requirements gathering and designing reports and forms.
- Worked on cross functional teams for resolving various oracle functional issues and gathering appropriate requirements.
- Modified account generator workflow to derive account combination based on Project/Task and expenditure type.
- Developed QAR (Quality Assurance for Receiving) process for purchased items based on item’s commodity code. Load all QAR data, assign to master item as attachment, define purchasing and receiving attribute for items based on QAR and also developed a user interface to maintain QAR data.
- Provided alternate solution for inventory "put-away" error for receiving module. The R12 bug for PO receiving caused a massive transaction problem.
- Developed an interface system between Oracle and Bartender systems to print label for WIP jobs. Also developed interface system between paperless manufacturing system and Oracle WIP. Developed an interface system between Oracle time and labor (OTL) and ADP.
- Map item and BOM data from legacy system and import to Oracle system. Defined a template to generate Indented BOM for Engineering department and load item and BOM from MS Excel to Oracle. The new process saved enormous time and provided data accuracy.
- Custom packing slip report which use barcode was developed using BI publisher.
- Merge Vendor 1099 data between Legacy system and Oracle AP. Develop an interface system to upload "Advance Shipping & Billing Notifications" (ASBN) data to customer iSupplier portal.
- Apply customization to Oracle Forms via custom pll or personalization as per business requirement.
- Developed and customized several reports using XML Publisher and Report builder.
- Provided end user training, day to day support, mentoring in house staff and maintained service requests (SR).
- Environment: Oracle EBS R12.0.6. Project manufacturing, INV, BOM, WIP, Engg, AP, GL, Project & Contracts, OTL, Oracle 9i. Reports 6. Forms 6. Workflow Builder, JDeveloper, PL/SQL, SQL
- Loader, TOAD, Unix, Oracle R.I.C.E, XML Publisher.
Senior Developer-Analyst
3 Years- Lead Developer for Oracle Process Manufacturing and Logistics modules.
- Performed gap analysis and migration from process manufacturing to discrete manufacturing, and also upgrade to "Order Management" from "Order Fulfillment".
- Set up scheduling and ran the ATP process successfully.
- Ensured current procedures are in compliance with established processes, standards and tools.
- Verifies and ensures test plan, scripts support testing objectives are executed properly.
- Participates in defect management strategy and coordinate with project team to ensure timely resolution of defects.
- Developed an interface between Order Fulfillment and APPIAN logistics system to send delivery information and retrieve the load from "Direct Route" system, and load item custom Oracle application.
- Developed a custom Logistics system to assign driver, maintain sub-division, and trucks using Oracle Forms.
- Applied ATP functionality to OPM Logistics- Oracle process manufacturing 11i did not offer Available to Promise (ATP) functionality.
- Developed an allotment function in a manner that is consistent with Boral’s requirements for scheduled production commitments.
- Developed and customized reports for process manufacturing module using Oracle reports and Discoverer.
- Developed web application to view order and delivery information from "Blackberry" for sales & logistics team.
- Developed Java web service to retrieve geo-coding data from Mapinfo application Archive OPM data over 3 years using Application system.
- Environment: Oracle EBS 11.5.9 & 11.5.10. Process manufacturing (OPM), Order Fulfillment, AP, AR, GL, FA, iProcurement, Logistics. Oracle 8i. Reports 6, Forms 6. Workflow Builder, PL/SQL, TOAD, Unix, Java.
Senior Programmer/Analyst
7 Years 2 Months- Involved in developing and Review of MD 070 documents for (INV, BOM, WIP, AP, OM, PO, GL and AR) module implementation/development.
- Worked closely with the functional teams to understand the intricacies of the business and document accordingly.
- Developed Oracle transactions pre-processor: Cinram Oracle inventory system used inventory transaction processor heavily (about 1 million records per month).
- Developed a Pre-processor to validate records in the transaction interface for successful load of batches.
- Developed item interface in inventory (INV) to import the item information from the legacy system into oracle inventory (INV) using SQL
- Loader and PL/SQL validations.
- Developed a custom web based "Order Entry" system for corrugate product (Super Finish Good). This system was used by Warner Home Video and New Line Cinema and allows them to add, delete, and update orders, allow visibility in inventory, reservation and workability. Also send trigger based email confirmation upon any activity on orders. Built entire back end processes using Oracle packages.
- Key member in developing the "Tooling" application for the production systems. Before a CD or DVD is manufactured in assembly line "Tooling" system has to confirm availability of tools known as STAMPERS, which are derived from SOURCE, FATHER, MOTHER and CUT. Responsibilities included database design, Package, Trigger, Email confirmations, load all pre-production items from LEGACY system to Oracle and define "Serial Number" , also updated Inventory and apply serial numbers by "Transaction Processor" and maintain history of transactions. Defined flexfields and maintain hierarchy of pre-production items.
- Defined sourcing rules for "Store Room" items to generate PO requisition based on Min-Max planning.
- Developed a "National Inventory Database (NIDB)" system that allows other sister companies to provide visibility of "BOM" configuration of all finish good, quantity available, supply/demand and last PO/SO dates.
- Developed a "Billing" interface for Warner Home Video (major customer, over 50% of the business): This interface created invoices based on "Bill When Ship Complete" model.
- Developed a process to perform physical inventory: this process generated an MS EXCEL report based on org, label, category or item type. Inventory will be updated based on discrepancy.
- Developed a process to mass update Bill of Materials by label code or finishing type.
- Functional setup of Oracle Receivables module, loaded customer and invoice data from legacy system to Oracle using open interface.
- Developed an API to derive pricing for Order Entry module based on BOM and price.
- Developed numerous business components, mission critical alert system, custom reports using Oracle Report, customize oracle Forms and front end screen using Active Server Pages (ASP).
- Designed and developed Item & BOM Conversion program to Import legacy data.
- Developed Conversion program to import Item Categories and Inventory Load.
- Environment: Oracle Applications 11.0.3, 10.7, Oracle 10g, Reports 2.5, Forms 4.5, SQL
- Loader, UNIX, PL/SQL, ASP, Java script. Modules: Inv, BOM, WIP, AR, PO, AP, GL, FA, Order Entry & Synquest scheduling.
Senior Consultant
1 Year 1 Month- Responsible for presenting technical and functional analysis and recommendations for solving key business issues related to conversion and implementation of legacy system through Oracle Financials. Primary applications were Oracle OE, AR, FA, AP, PO and GL.
- Developed interfaces to integrate Oracle OE with client’s custom order entry application. Also involved in customizing Oracle OE system, developed reports.
- Responsible for developing a check writing process for Oracle Payrolls to print check by ADP. Process involved development of database packages to retrieve data from Oracle HR and Payroll applications for payment type of check, direct deposit and zero dollar payment.
- Analyzed the scope of the project and data mapping. Developed an online process to transfer data between OTM (On the Money) and Oracle Receivables. Process involved developing GUI forms to continuously read data from OTM, validate and add data in receivables module using open interface.
- Developed Conversion program to import Receivables Transaction data using Auto Invoice Program.
- Developed Lock box program to import receipts from the legacy systems.
- Reports were developed to reconcile the data in two systems.
- Involved in data mapping and conversion of vendors, customers and assets data from OTM to Oracle.
- Involved in various validations such as purging previous data, checking for duplicate files, validating input data, updating invalid data, formatting input data and transferring data from custom staging table(s) to interface table(s) such as GL_INTERFACE.
- Customized Oracle application Forms as per business request. Developed reports for receivables module.
- Clients: Helena Chemicals, Memphis, TN. Boral Bricks, Augusta, GA. Impac Hotel Group, Atlanta, GA.
Consultant
1 Year 11 Months- Member of a large implementation team for Oracle financials, manufacturing & HR applications.
- Involved in Item & order entry import process from legacy system.
- Involved in the functional to business analysis to develop a custom HR application.
- Developed a system to setup the indirect account table in Smart-Time system and define flex-fields. Also involved in the development of an interface to import data from Smart-time system to Oracle.
- Developed several reports for HR and Smart-time system as per user requirement.
Education
M.S - Chemical Engineering
Timeline
Solution Architect
SPECTRUM / COX
06.2016 - CurrentRead More
Senior Analyst
Southern Company
04.2010 - 03.2016Read More
Senior Developer-Analyst
DRS Technolgy
12.2008 - 04.2010Read More
Senior Developer-Analyst
BORAL Industries
12.2005 - 12.2008Read More
Senior Programmer/Analyst
WEA /CINRAM Mfg
11.1998 - 01.2006Read More
Senior Consultant
Oracle Corporation
10.1997 - 11.1998Read More
Consultant
PLUS MARK Inc
11.1995 - 10.1997Read More
University of Detroit
M.S from Chemical Engineering
Read More