Post Job Free

Resume

Sign in

Pl Sql Oracle Ebs

Location:
Miramar, FL
Salary:
153000
Posted:
January 30, 2024

Contact this candidate

Resume:

Mohammad Haque

Tel : 786-***-****

Email : ad279p@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/mohammad-haque-726b378

SUMMARY

Around 15+ years of IT experience including software development, architecture design, database design, project management and team management.

Prepared functional and technical design documents for customizations and conversions using AIM documentation methodology (MD,CV, BR, etc.).

Strong background in Business Processes with good understanding of the various process cycles of software development including analysis, design, coding and quality assurance.

Proficient in multiple Oracle Financials modules, Supply Chain modules such as MDM, Procure to Pay, and Quote to Cash. Well-versed in solution design, build, testing, transition, and production phases.

Excellent technical skills in developing CEMLI (Customization, Extension, Modification, localization, and Integration) and Rice (reports, interfaces I/O, Conversions, Extensions and Workflow) Components in the domain of Oracle Applications E-Business Suite.

Expertise in ETL/Oracle environments using most of the oracle related tools under Unix/Linux and Windows environments, including Data Warehousing and Business Intelligence.

Expertise in designing, developing and deploying Graphical user interface forms and reports using Developer tools, including SQL, PL/SQL, GraphQL, Postgresql.

Familiar with industry standard SDLC methodologies such as agile and waterfall. Strong ability to lead teams to drive organizational initiatives to successful conclusions on time and within budget.

Technical Skills:

ERP: Oracle Apps 11i, R12 (12.1*, 12.2*), Fusion Cloud R13

Modules: Oracle Financial Modules (GL, AR, AP, FA),

Oracle Order To Cash (OM, Advance Pricing QP, WSH, AR, CM)

Oracle Procure To Pay (Procurement, Purchasing, AP)

HRM, MDM, TCA, AOL

Technologies: SQL, PL/SQL, Reports 9i/10g, BI Publisher, Forms Personalization, Alerts, AOL, EDI

Database: Oracle DB (11g,12c, 19c), PostgreSQL, SQL Server

Tools: Toad, Sql Developer, Putty, Oracle Developer Tools, Workflow Builder, Jdeveloper (10g,11g), XML Publisher, UTL File, CI/CD (Bitbucket, Bamboo, Golden Pipeline), Opsgennie, Jmeter

PROFESSIONAL EXPERIENCE

World Kinect Corporation (WKC), Miami, FL Feb ‘10 to Nov ‘23

Title: Sr. Technical Lead (Full Time)

Over 12 years worked in World Kinect Corp as a full-time employee in various roles. Participated in multiple Oracle full life cycle implementations. Developed custom applications integrated with Oracle EBS, data import program, data warehousing, and EDI with many 3rd party applications.

Provide technical leadership in the implementation and customization of Oracle E-Business Suite.

Analyzed existing oracle 11i customizations, extensions and providing better solution of maximum utilization of oracle R12 features and functionalities.

Retrofit Oracle objects in R12, performed architecture review, walked through proof of concept to business users, implemented final solutions.

Assists in designing new programs of routine complexity and for basic enhancements to existing programs.

Managing offshore, onsite team to resolve day to day Oracle apps support and maintenance issues.

Logs tasks, manage and monitor tickets and maintain release planning.

Formulated solutions aligning with user requirements, authored comprehensive functional and technical documentation, and collaborated closely with the technical team throughout the development and testing phases.

Design and develop custom applications that interface to Oracle Order management and Oracle Purchasing, Oracle Payables and Oracle Receivable modules.

Oracle Modules and Custom Applications: Tender Applications, Pricing Engine, Fuel API, CA Portal, Supplier EDI, Oracle Advance Pricing, Oracle Purchasing (PO), Order Management (OM), Oracle MDM, Oracle Financial (GL, AR, AP, FA), Cash Management(OCM), Inventory (INV)

Worked in various Interface programs in Oracle Financial, Blanket purchase agreements, Blanket sales agreements, Sales Order, Quotes, TCA

Seamless integration with HighRadius (3rd pary application) for advanced collections and payment processing.

Developed and customized many custom solutions and Oracle apps extension through PLSQL API, Workflow, SOA, Oracle DB, PostgreSQL.

Developed Complex Custom Engine through PLSQL API to generate pricing based on Oracle Advance pricing data.

Automated Blanket Purchase and Blanket sales order creation based on the fuel price index change using PLSQL API.

Setup template in Cash Management module and monitor Bank transaction, Payment, and monitor report.

Developed Program to validate and upload MDM data to Oracle.

Worked extensively with DBA's and Oracle team to fast tune complex queries, table partitioning, table index, SQL trace and TKPROF.

Developed interface program to integrate with many 3rd party vendors.

Developed and support SOA composites integrated with Oracle EBS

Created and tailored Oracle Reports 10g and BI Publisher to meet specific requirements.

Developed Python scripts uploading files into File Repository Systems (Box, Filenet).

Implemented ETL (Extract, Transform, Load) process for seamless data interfacing across different databases.

Created views and complex SQL query for reports and ETL process.

Developed shell script to automate UTL job and generic FTP process.

Environment: Oracle Applications11i, R12, Fusion, Java, Toad, PL/SQL, SQL, Postgres DB, Oracle Developer Suit (Forms/Reports), Cucumber, Postman, Jmeter, Discoverer, SOA Suit, UNIX (Solaris), CI/CD, Bitbucket, Bamboo, GitHub, Jira, Springboot MS, LeanIX, GraphQL, OpsGennie

World Fuel Services, Miami FL Mar ‘07 to Feb ‘10

Title: SR. Oracle ERP Technical Consultant

Project Details: Implemented Oracle 11i from legacy system. WFS implemented various custom solutions in extensions to Oracle ERP system.

Responsibilities:

Led the integration of Oracle Financials with third-party applications, optimizing data flow and ensuring data integrity.

Collaborated with finance and IT teams to troubleshoot and resolve system issues, ensuring smooth day-to-day operations.

Collaborated on a customized solution linking Quote to Sales Order, integrating the Oracle Order Management (OM) module with a Custom Work Bench.

Executed data loading across various Oracle modules (e.g., AR, AP, GL, OM, TCA) using a data loader and interface tables.

Interface 3rd party applications with Oracle HRM Benefits module.

Worked with various teams to resolve critical bugs and supported production issues.

Customized and developed Oracle reports through Report builder9i, Discoverer, XML Publisher.

Customized standard Oracle forms and AME Workflow as needed.

Developed Interfaces, Customization of Forms and reports 6i.

Written Unix Shell Scripts, batch scripts and PL/SQL Scripts to batch run Oracle Reports

Developed Oracle Alert notifying user when someone cancels or voids a sales order line.

Environment: Oracle Applications 11i, AOL, Report Builder 6i/9i, PL/SQL, SQL, WS_FTP, UNIX (Solaris), TOAD, Workflow Studio, Discoverer Studio, EDI, VSS 6.0

Wheeling Pittsburgh Steel Corp., Wheeling, WV Jan ‘05 to Feb ‘07

Title: Oracle Applications Technical Consultant

Project Details: Oracle Process Manufacturing (OPM), Oracle Financial (AR, AP), Oracle Cash Management (CE), Oracle Purchasing (PO), Inventory (INV), and Application Object Library (AOL), EDI

Responsibilities:

Accounts Receivables/Process Manufacturing GML/INV Customization:

Designed and development of custom programs for interfacing customers and Invoices data into the Receivables module from Legacy system (Main frame).

Developed Invoice conversion from Legacy AR System into Apps Account Receivables by using AutoInvoice.

Developed GetPAID Interface, This Interface will extract all the transaction data from Oracle Receivables and transfer to a collection tool called ‘GetPAID’. GetPAID deals with customer collection process.

Developed and supported EDI 810 (Invoice Outbound), Ship Award Notification Inbound, and EDI 856 (Advance Ship Notification outbound) Transaction

Developed PL/SQL program to load Customer Items and cross-reference with Oracle Organization Items in Oracle INV

Accounts Payables/Purchase order Customization:

Designed and developed of interfacing the Accounts Payables module with Legacy system (Main frame). Customizations like Invoice Error correction form and developing Adjustment memo form and Auto Invoice matching program.

Automation of AP Invoices to match to Purchase Orders in Purchasing. With this process, all the Legacy Invoices would be converted/Interfaced into AP and would be matched to corresponding Purchase Orders by a Process called ‘AUTO MATCH’. The matched Invoices will be approved automatically.

Reports/Forms:

Developed and Customized Reports 6i as per user requirements in OPM module like Pick Slip, Shipping exception and Sales Order.

Involved in customizing several Standard Key Reports such as ‘Cancelled Orders Report', ‘Order by Item report', ‘Capital Projects Committed Dollars', ‘Bill of Materials', ‘Tally & Tag report' and developed several other reports as per user request.

Written Unix Shell Scripts, batch scripts and PL/SQLScripts to batch run Oracle Reports

Environment: Oracle Applications 11i, Oracle 9i, PL/SQL, SQL, SQL*Loader, Developer/2000(Forms/Reports), WS_FTP, UNIX (Solaris), SQL*PLUS, TOAD, Korn Shell, Esker Fax, VSS 6.0

EDUCATION

Bachelor of Science in Engineering, Western Michigan University, Kalamazoo, MI

Apr / 2000 - Apr / 2004

TRAINING

AWS- Cloud practitioner

Oracle Advance PL/SQL

Oracle Reports Advance Workshop

Oracle Workflows

Python

UNIX Fundamental

Agile Methodology



Contact this candidate