SUMMARY

• Having 12 Years of experience in IT Service industry on Oracle E Business suite (Purchasing (PO), Inventory (INV), Shipping, Order Management (OM) Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Bill Of Material (BOM), Work In Process (WIP), Cash Management (CM), Service Resource Planning (SRP), Project Accounting (PA), Advanced Pricing, iProcurement & AOL) as technical developer(80%), functional(20%), PL/SQL Developer, BI/XML Publisher & Oracle Workflow Developer.
• Experience in Analysis, Design, Architecture and Development of Software Applications, Business Intelligence projects in Oracle Suite Products.
• Working experience in implementing and providing solutions to complex issues
• Extensively worked on Oracle Supply chain (inventory, purchasing, Order management, Receiving, Shipping (SCM)), Manufacturing (Work in progress & Bill of Material) (MFG) and Financials Modules (Account payables, Receivables and General ledger) in Oracle EBS (P2P & C2C) (Order to cash & Procure - to-Pay)
• Good experience in solving severity 1 and high priority 24/7 production issues (P1).
• Having sound experience in designing, developing and deploying Oracle objects, XML Publisher Reports.
• Strong experience in development of various RICEW Components (Reports, Interfaces, Conversions Extensions and Workflow)
• Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries withORACLE SQL.
• Experience on Form Personalization & Custom.pll
• Experience in loading data using WebADI, SOAP API's
• Having hands on Knowledge on Oracle Cloud BI and OTBI reports and Scheduling,
• Having work experience in developing Oracle Work Flows.
• Experience on Appworx Application which use to schedule the jobs.
• Expertise in developing interfaces between legacy systems to Oracle ERP Applications using Standard Open Interfaces, SQL*Loader, UTL File, PL/SQL, DATALOAD and using Bulk Collect, Collections, Analytical Functions, APIs etc.
• Strong experience in performance tuning and query optimization using tools likeTK - Prof.
• Experience in design and writing technical specification documentation (MD70) and Migration document forOracle EBS components
• Sound knowledge ofsoftware development life cycle (SDLC)with substantial experience with object-oriented analysis and design methodologies.
• Demonstrateexperience in understanding AP Payment Processing, Formats
• Oracle Associate Certified
• Expertise in using Oracle JSON functionalities to enable application data consumption.
• Developed Oracle packages using extensive JSON and XML features.

TECHNICAL SKILLS

ERP: R12 (PO, INV,OM, AP,AR, GL, BOM, WIP,SRP & AOL),11i & 10.7

Languages: SQL, PL/SQL, Shell scripting, JAVA

Tools: PL/SQL Developer, TOAD, Putty, WINSCP, SQL * Loader, SSH Client, JIRA, BitBucket

RDBMS: Oracle 19c,12C, Oracle 11g,Oracle 9i &10g

GUI Tools: Forms 10g, 6i, 4.5 and Report 10g,6i &2.5, XML Publisher, Oracle Workflow, Appworx, Discoverer reports, Endeca reports

Operating System: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

• Identify scope, business and functional requirements and create process flow for MRO Oracle EBS Integration with 3rd party application
• Developed new interfaces and reports as per business requirement.
• Developing Outbound Interface programs on Price list, Customers, Suppliers, Items Master and other Oracle EBS standard data which required for 3rd party system to sync up with Oracle EBS SCM and Financials Data.
• Design and Developing Custom program for Sales order integration with 3rd party application and process the data which received from 3rd party and load the staging tables in Oracle EBS and create Sales orders.
• Design and Developing the Oracle Purchase interface program
• Developed AP Invoice interface
• Understanding the client’s business needs and translate those needs into technical terms and solutions.
• Preparing testing strategies, writing test cases. Support User acceptance testing and integration testing.
• Regular day to day development status and metrics to the Leadership team.
• Provide Functional, Technical and data consultation as a Subject Matter Expert and domain expert for the Confidential MRO (Maintenance Repair Overhaul) application.
• Providing the Adhoc reports to user on service requests.
• Support various analytic initiatives, planning, decision making and solving technical customer issues in Aviation Supply chain domain for MRO application.
• Provide end to end support on numerous infrastructures, technological upgrades and performance improvement. Execute and support activities required for this purpose.
• Identified the customer pain areas and initiated process improvement.
• Impact analysis for the requirements and provided the estimations to each enhancement.
• Coordinate with business users for integration testing, user acceptance and implementation.
• Analyzing production Issues, Bug fixing for business requirements.
• Improving the performance of objects (Reports, procedures)
• Co ordinating with finance team on month end process and issues
• Provided work around, when major issues happened in production many times, to reduce the damage.
• Preparing the test plan when new Engine model is setup and involved in business process testing.
• Monitoring Job status email, Post clone activities, Outage support.

Environment: and Technology: Oracle EBS R12( SCM & Finance), PL/SQL, XML Publisher, Forms & Reports, SQL*Loader, PL/SQL Developer, Shell scripting, procedures, functions, (supply chain and Finance modules )

Confidential, Cincinnati, OH

Senior Oracle EBS Technical Consultant

Responsibilities:

• Regular interaction with client (Functional Users) for various activities like requirement gathering, Issues Resolution, Query Resolution, User Acceptance Testing, Status Reporting.
• Effort estimation for the enhancements and defects
• Requirement gathering, design, development and testing of Logistics and Finance modules interfaces.
• Worked with functional interface team to get the data mapping.
• Created inbound PLSQL validation programs for PO, INV, AR, AP and GL. Loaded transactions into open interface tables.
• Created outbound PLSQL packages to create files for different module transactions.
• Created PLSQL procedures for status report.
• Worked on control program and SQL loader to load data.
• Development of database objects such as tables, indexes, packages, procedures and functions.
• Solved critical production issues.
• Solved various performance issues.
• Requirements Analysis including impact and feasibility analysis for enhancements and defects.
• Preparing testing strategies, writing test cases. Support User acceptance testing and integration testing.
• Creating Technical Solution and Design for the business requirements. Sharing them with development team and collecting queries from team and getting them resolved from GE business stakeholders.
• During the project cut over and go-live, co-coordinating among project teams and other stakeholders for smooth project execution.
• Documentation and Knowledge Management. Knowledge transfer to Production control (L2) Team.
• Created MD50 and MD70 documents.
• New developments and Bug fixing for business requirements
• Analyzing production Issues
• Providing Support to Onsite coordinator.
• Review the code, Test Results.
• Responsible to move defect free objects.

Environment: and Technology: Oracle EBS R12 &11.5.10(PO, INV, AP, GL, OM, AR, iProcurement), PL/SQL, XML Publisher, Forms& Reports, SQL*Loader, PL/SQL Developer, Shell scripting, Appworx, Supply Chain (SCM) and Finance modules

Confidential

Programmer

Responsibilities:

• Writing PL/SQL Programs for implementing validation rules.
• Created documentation for every component developed so as to facilitate users to understand the component and use it effectively.
• Development of Reports
• Defining value sets, Profiles, Executables and concurrent programs.
• Testing the objects in all possible scenarios as per of unit testing. Providing the test case results leads.
• Preparing the migration scripts.
• UAT Support and issue debugging.
• Preparation and review of Technical Design documents
• Working as Offshore Team Member Closely interact With Onsite Team.
• Developed an Inbound Interface to Load ASN Details into Purchasing Applications Base Tables from Legacy System.
• Developed an Inbound Interface to Load Receipt Details
• Developed an Inbound Interface to Load Forecasting Details
• Developed an Inbound Interface to Load Purchase Order Details into Purchasing Applications Base Tables from Legacy System.
• Developed an interface which reschedule the Purchase order details.
• Developed a pl/sql script which picks the requisition details from oracle table and writes on to the file.
• Developed a Pl/sql script which pulls the data from custom table and writes on to the file.
• Developed a one-time script which insert data into custom tables.
• Developed a Report which mails all the fallout records of Purchase order interface.
• Developed a report which mails all the fallout records of ASN open interface.

Environment: and Technology: Oracle EBS 11.5.10.2(PO, INV, AP, OM, AR, MFG), PL/SQL, XML Publisher, Forms& Reports, SQL*Loader, PL/SQL Developer, Shell scripting, Workflows, procedures, functions, Supply Chain (SCM) and Finance modules

Confidential

Programmer

Responsibilities:

• Developed Receipt outbound interface.
• Developed Program which keeps orders ON HOLD of Denied customers
• Developed shipment outbound interface using UTL package
• Developed Denied customers orders Report.
• Customized a Requisition Import Exceptions Report
• A new report that shows Back Order Information by using XML Publisher.
• A new report that shows Supplier vat Information
• Created a shell script which execute the SQL report and send output as mail notification.

Environment: and Technology: Oracle EBS 11.5.10.2(PO, INV, OM), PL/SQL, XML Publisher, Forms& Reports, PL/SQL Developer, Shell scripting, procedures, functions, Supply Chain (SCM)

Confidential

Programmer

Responsibilities:

• Development of Reports
• Created documentation for every component developed so as to facilitate users to understand the component and use it effectively.
• Writing PL/SQL Programs for implementing validation rules and submitted the concurrent program through back end.
• Developed Einvoice outbound interface using UTL Package.
• Developed Einvoice XML outbound interface using Rdf and plsql program. create shell script to transfer the file from one server to another server. create shell script to rename the file when the file was created.

Environment: and Technology: Oracle EBS 11.5.10.2(AR), PL/SQL, XML Publisher, RDF Reports, PL/SQL Developer, Shell scripting, procedures, functions, Finance

Confidential

Programmer

Responsibilities:

• Worked on production tickets and closed them without crossing SLA
• Implement few new business requirements.
• Monitoring jobs and Emails

Environment: and Technology: Oracle EBS 11.5.10.2 (PO, INV, WIP, BOM, AP), PL/SQL, XML Publisher, RDF Reports, PL/SQL Developer, Shell scripting