Oracle Cloud Software Development

Adil Baig

**** ******** *****

LAWRENCEVILLE, GA 30044, USA

E-mail: ********@*******.*** 678-***-****(H)

Summary

** ***** ** ********** ** Oracle technologies in various responsibilities.

Expert level knowledge in Oracle Cloud and ERP technical implementations.

Implemented technical components for Oracle cloud Financials, HCM, PPM, and SCM modules.

Experience with all the phases of the Cloud/R12 software development life cycle including data conversion, customization, extensions, reports development, Integrations, fast formulas.

Excellent communication skills, highly motivated, good technical and presentation skills.

MS from University of Memphis, TN (USA).

US Citizen (Public Trust Clearance)

Skills

Languages SQL, PL/SQL, HTML, XML, Java Script

Platforms UNIX (HP/AIX), Windows 10/NT/2000, LINUX, Solaris

Scripting C shell

Databases Oracle 9i, 10g, 11g, 12c, 19x, SQL Server, My SQL

ERP Oracle Federal Financials 12.2.4, Oracle Financials 12.2.7.

GL, AP, AR, CM, FA, PO, INV, OM, IB, PA, iSupplier, iProcurement, iAssets, Advanced Collections, Quality, cMRO, ASCP etc.

Business Processes Procure to Pay, Order to Cash

Development Tools Forms 12g & Reports 12g,

TOAD 9x, SQL Navigator, Discoverer Reports, JDeveloper, BI Publisher

Database Design Erwin 9.x, Visio, Oracle Designer 6i

ETL Tools ODI

Integration Tools OIC, SOAP, REST services

Version Control GitHub

Oracle Cloud Release 21x, 22x, 23x

Certifications: Oracle Cloud Infrastructure Developer 2021 Certified Associate

Oracle Cloud Infrastructure 2021 Architect Associate

Oracle Cloud Platform Application Integration 2021 Certified Specialist

Oracle Autonomous Database Cloud 2021 Certified Specialist

Work Experience

L3Harris (Dec-24-Current)

Senior EBS Developer

L3Harris is Implementing new operating units for their business unit

Responsibilities:

Implemented BER calculation for newly added business units based on cost method

Implemented new fields and code for an existing custom form

Implemented solution for fixing duplicate values entry for serial number by fixing a package

Implemented changes to two custom APEX applications based on the business requirements.

BPMI Project (Nov-22-Aug’24)

Senior Fusion Technical Consultant

Project Profile:

BPMI implemented Oracle cloud ERP and HCM migration for their legacy systems. The project is implemented by Accenture Federal.

Responsibilities:

Implemented APEX time charge application to enter time charge and move the data to Oracle SAAS environment.

Implemented OTL fast formulas based on functional requirement.

Implemented various HCM custom BI reports for Absent Management, Core HR, and Time and Labor.

Implemented OTBI reports for Absent Management, Core HR, and Time and Labor.

Implemented APEX application to load one-time conversion data derived from SAAS.

Implemented APEX application to show APEX data as reports dashboard for user query and data analysis.

Implemented OIC integrations to move PO, Projects and HCM data from SAAS into APEX tables.

Implemented ESS Jobs and BIP reports to be used for onetime conversions using OIC integrations.

Implemented OIC integration to move data from SAAS to FTP server using bursting.

Implemented custom PO, and Supplier Negotiations reports using BI publisher. The PO report was replacement for seeded PO report and involved building custom template and data models. The Supplier Negotiation Report involved customizing the seeded template.

Implemented PO validation report using BI Publisher. This report validated data at PO header, line, line locations, and distribution levels.

Environment: ERP/HCM Cloud 22C, SQL Developer, Cloud Insight, OIC, APEX 19C, GITHUB

DIFS OCFO Project (Jul’21-Nov’22)

Senior Conversion Consultant

Project Profile:

DC district is moving its legacy EBS and EPM systems into Oracle Cloud. The project is implemented by first moving pilot agencies to Oracle cloud and in near future 100 agencies with be moved to Oracle Cloud. The project is led by Deloitte team.

Responsibilities:

Implemented code for data transformation of AR open invoices for FBDI load.

Implemented code for data transformation of fixed assets for FBDI load.

Implemented code for data transformation of PO for FBDI load.

Implemented OTBI reports to show data conversion for AR invoices, PO, and FA load.

Implemented the BI reports for Budget controls to show budget data based on parameters.

Worked on specification documents and run books for the various conversion objects.

Implemented Dashboard for Suppliers, Contracts, AR, and PO conversion OTBI reports.

Implemented custom BI (excel) FA register and reconciliation reports.

Implemented three custom OBI (excel) FA reports based on lean specifications.

Implemented custom logic to derive the correct values to derive the GL load from multiple excel data files.

Implemented 1099 report using standard report in cloud.

Implemented custom BPM approvals for AR and PO.

Environment: ERP/EPM/SCM Cloud 21C, SQL Developer, Cloud Insight, OIC

Apps Associates (Feb’21-Jun’21)

Principal Consultant

Company Profile:

Apps Associates drive efficiency and optimize business processes through comprehensive portfolio of

application and technology services from full, project-based life cycle implementations to managed services

and staff augmentation.

Responsibilities:

Sikich Project (01-Jun-21, 01-JUL-2021):

Analyzed the conversion and reports requirements for cloud ERP, SCM and EPM.

Lead four technical resources offshore and 8 functional resources.

Made teams for different skills and assigned responsibilities.

Hollander Project (15-APR-21, 15-JUN-21):

Lead team to build BOM concurrent program to migrate data from AGILE system to EBS.

Lead team to build Customer item concurrent program to migrate data from data files to EBS.

Lead team to build item price list import concurrent program to migrate data from data files to EBS.

Hologic Project (01-Mar-21, 30-APR-21):

Researched and presented ERES and AME process to the client for Inventory transaction creation and approval.

Lead efforts to migrate Financial and SCM data for Cynosure from Hologic system.

Lead four technical and functional resources to complete the client requirements.

Managed code quality, documentation, and presentations to client.

Wrote scripts needed to migrate attachments from Oracle EBS to NetApps.

Lead in improving performance of the queries for data retrieval.

Environment: R12 Financials/SCM, SQL Developer, SmartSheet, UNIX scripts, ERP/HCM/EPM Cloud 21C

Accenture (Sep’2018- Jan’21)

Associate Manager (Senior Developer)

Company Profile:

Accenture is a global services and consulting company. Offering strategy, consulting, digital, technology and operations services, it is a Fortune 500 company with offices around the world.

Responsibilities:

Helped the client set up development standards and processes to implement R12 Supply chain modules.

Helped the client with setting coding standards, technical document template selection, unit test plan template selection, and code review document template selection.

Implemented complex AME rules for requisition, PO, and Invoice approvals. The implementation involved using more than 30 rules for each custom transaction type.

Implemented workflow for requisition, PO, and Invoice account generator.

Implemented Alerts in PO for various scenarios.

Implemented extension for supplier deactivation, automated assignment of the buyer for requisitions, etc.

Reviewed functional, technical, and unit test documents for other senior and junior team members.

Built custom web-based query form for quality module to insert, update delete quality data.

Manage mid-level and junior developers and assign development objects. Responsible for evaluating their work and progress.

Responsible for grooming the analysts and providing career guidance advice.

Environment: SQL, PL/SQL, SQL Developer, LINUX, Oracle AOL, Oracle Financials 12.2.7, SCM, HCM, BI publisher, AME, Workflow

US Coast Guard (Elizabeth City, NC) (Aug’2012-May’2018)

Technical SME Oracle Applications

Company Profile:

The United States Coast Guard is the maritime security, search and rescue, and law enforcement service branch of the United States Armed Forces and one of the country's eight uniformed services.

Responsibilities:

Lead the technical team efforts to find the best solutions to move the Legacy system data to Oracle applications R12.

Design analysis of the Legacy system and identify challenges to configure Oracle cMRO, SCM, and financial modules based on the Legacy system design.

Identify the conversion programs needed to migrate legacy data to Oracle applications.

Identify the best design solution to move the Oracle applications transaction data to Oracle Datawarehouse for Cognos reporting purposes for the client.

Wrote MD30 and MD40 design and Build standards for the current implementation.

Wrote CV60 document for the conversion of Item Instance, Routes, Unit Configuration, Master Configuration, Maintenance Requirements, Items, Item category, Employee, AR Invoice, AP Invoice, Suppliers, Customers.

Wrote MD120 documents to help the DB team move the conversion programs to new environments.

Wrote conversion programs for Item Instances, Routes, Unit Configuration, Master Configuration, Maintenance Requirements, Items, Item category, Employee, AR Invoice, AP Invoice, Suppliers, Customer using standard API’s.

Built interfaces for Inventory items/categories/cost, Invoices, and Supplier data

Used iSetup to migrate the GL, SCM, and cMRO data to new instances.

Implemented attaching UPK files to the APPS help menu for user training and testing.

Implemented Maintenance Due List report, Configuration Report, and other custom reports in XML publisher for the client reporting.

Integrated SOA services in Oracle Fusion middleware environment to enable and use web services for instant data transfer from the client system to Oracle Applications.

Environment: Oracle Federal Financials 12.2x, cMRO, SCM, HCM, BI publisher, SOA, SOAP, REST, XML, PL/SQL, SQL Developer, SQL, LINUX

INCOMM INC. (Atlanta, GA) (Dec’2010-Jul’2012)

Lead Oracle Apps Analyst

Company Profile:

With more than 25 years of global experience in the FinTech industry, InComm Payments has partnered with the largest and most popular retailers and brands in the world. InComm products and services – which range from prepaid cards to switch payment processing – enable retailers and brands to create a seamless commerce experience – whether that's in store, online or via mobile.

Responsibilities:

Implemented conversion of Master data for Oracle Applications R12.1.3 implementation for GL, Customers, Vendors, and Items for fourteen operating units.

Implemented conversion of AP and AR Invoices for fourteen operating units.

Implemented interfaces for AR Billing, Items decrement, and GL face value for data transfer from external systems into Oracle applications R12 for fourteen operating units.

Wrote CV40, CV60, MD50, and MD70 AIM documents for all the conversion and interfaces.

Wrote Reports in Discoverer and modified existing Discoverer reports from 11i to R12.

Implemented migration of master data from 11i into R12 for 11 operating units.

Wrote dashboard reports in OBIEE as per business needs.

Implemented Customer Invoice, Aging Reports, and Customer Statements using XML Publisher.

Created several custom Alerts using Oracle Alerts Module for Oracle applications.

Customized the seeded workflows for Requisition, PO create Documents, and PO Approval to auto approve the Blanket and Contract Purchased orders by automatically Email them to Supplier.

Performed the BI publisher setups using the XML Publisher Administrator responsibility.

Implemented BAI, NACHA, and receipts file transfer from WELLS FARGO, JPMC, and RBC into R12.

Managed, and assigned project tasks to junior developers and updated client about their progress.

Environment: Pl/SQL, TOAD, SQL, AIX UNIX, Oracle AOL, System Administration, API, Inventory, GL, AP, AR, PO, BOM, REPORTS 11g, iSupplier Portal, XML Publisher, DISCOVERER reports

TROVER MEDICAL SOLUTIONS INC. (Louisville, KY) (Jul’2010-Nov’2010)

Senior Oracle Analyst

Company Profile:

The Company’s primary business is medical claims recovery, and its primary product is subrogation recovery, which generally entails the identification, investigation and recovery of accident-related medical benefits incurred by its clients on behalf of their insureds, but for which other persons or entities have primary responsibility.

Responsibilities:

Implemented single sign-on for many Custom Oracle applications. The project involved designing and coding applications from requirement analysis and updating users and owners in fast-paced Agile development methodology with daily meetings and weekly presentations. The many Custom Oracle Systems in different Schemas had to be integrated with single sign-on screen listing all user tasks from different custom applications and maintaining the same existing security as listed for all individual schemas.

Modified the exiting Forms to new requirements for maintaining the software.

Modified many packages as per the requirements to implement the changing business logic.

Code review of peer and enhancing the existing design of the forms and database packages to drive efficiencies and ease in maintenance.

Knowledge share with client senior, mid-level and junior developers.

Environment: 10g, Forms 10g, PL/SQL developer

Education

MS, University of Memphis, TN, USA.

BE MJCET, Hyderabad, India.

References

Emil Moster (Project Manager), 252-***-****©

Kathie Hood (Project Manager), 919-***-****©

Contact this candidate