We provide IT Staff Augmentation Services!

Oracle Ebs Senior Developer Resume

Clearwater, FL

SUMMARY

  • 9+ Years of experience as a Senior Developer in Oracle EBS Applications and Configuration Management System.
  • Proven Technical skills in all aspects of Software Development Life Cycle, Installation, Conversion, Testing, Support, Troubleshooting and Enhancements
  • Techno Functional expertise in Oracle Applications modules such as Order Management, Inventory, Bill of Materials, Work in Process, Purchasing, Shipping, and Demand Planning.
  • Performed End to End Integration testing in Order to Cashand Procure to Paycycles.
  • Expertise in Oracle Forms, Reports Development&Forms Personalization.
  • Expertise in development/enhancement of thePL/SQLPackages/Stored Procedures withDynamic SQL, REF Cursors, Collections, Bulk Collect, Record Type, Table Type,Functions, Triggers& Exception Handling,PERL, MSSQL, andMySQL.
  • Data Conversion Expert to migrate the data from Legacy to R12 Applications using Oracle open interfaces and Oracle Public API’s
  • Data Conversion Expert to migrate the data from Smart Client/Netcool to Remedy using Remedy Jobs.
  • Expertise in building&designing new databasefrom scratch by creating Database Objects like Table, View, Index, Synonyms, Sequences, Constraints, Creating Entity Relationship Diagram by Module Specific.
  • Expertise in Performance Tuning & Optimization of SQL/PLSQL Scripts.
  • Well Proficient with DevOps and Agile Methodology
  • Possess excellent communication skills and a smooth client handling and interaction experience.
  • Strong proficiency in Problem Solving, Taking Initiative and Time management.
  • Received various appreciations from the end customers for best in class deliverables.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, MSSQL, MySQL, Perl and UNIX Programming

RDBMS: Oracle 11i/10g/9i/8i, MSSQL, and MySQL

Database Tools: SQL*Plus, SQL Navigator, PLSQL Developer, TOAD

Reporting Tools: Oracle Reports & Forms 10g/9i

Incident Mgmt: Smart Client, BMC Remedy, Service Now

Migration Tools: Kintana, Clear case & SDLC

Agile Tools: JIRA for Sprint Planning

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Clearwater, FL

Oracle EBS Senior Developer

Environment: PL/SQL, SQL*loader, SQL Developer, Lucid chart, Agile, JIRA, Sprint Planning, Oracle Applications R12

Responsibilities:

  • Performed System Administrator role to define users and assign responsibilities and set profile options.
  • Designed and developed PL/SQL Package to perform Unreserve, Split, Reservation using the Oracle API - oe order pub.process order
  • Developed XML Publisher Reports that requires changes in RDF report & RTF template that showcase the reports related to Pack Ship & Shipping details with respect to Sales Order details that was recently shipped from the Shipping Inventory..
  • Created Form Personalization to hide the Shipping Method & Freight Terms in the Sales Order Line Form for the configured responsibility list in the Common Lookup, since it was handled in a custom form.
  • Developed PL/SQL package to update the SHIP TO from a custom form to OE Order & Line level using the Oracle API - oe order pub.process order, and it invokes the PL/SQL package from the FMB of the Custom Form.
  • Developed XML Publisher Reports that requires changes in RDF report & RTF template that showcase the reports related to Pack Ship & Shipping details with respect to Sales Order details that was recently shipped from the Shipping Inventory.
  • Designed and developed PL/SQL Package for creating and updating freight charge on the OE Line using the Adjustment Table Type in the Oracle API - oe order pub.process order
  • Designed and developed PL/SQL Package for extracting the Price List Header, Lines, Secondary Price List, and Qualifiers. The extracted data will be created in the Soap Request - PayLoad Format, later that will be loaded into the Integration Middle Tier Instance.
  • Developed Shell Script to rename the Art Files in the Unix Directory.
  • Created custom concurrent programs for each XML reports and created custom value sets associated to the concurrent program.
  • Constants values used across the PL/SQL package are maintained using the custom lookup and Descriptive Flexfield.
  • All the deliverables will be delivered in Agile Methodology using the JIRA Sprint Planning.
  • All the changes will be migrated with the Change Request. I will be responsible to create the test cases with evidence that covers the entire scenario, attached the prepared technical design documents and to migrate the changes through SDLC tool.
  • Involved in Production Support Activities after GO LIVE.

Confidential, Schaumburg, IL

Senior Data ConversionTechnical Lead

Environment: MSSSQL, PL/SQL, SQL*loader, SQL Developer, MySQL, Hedissql, PERL, Draw IO, Agile, JIRA, Sprint Planning, Smart Client, Remedy and Netcool

Responsibilities:

  • Worked as a Techno Functional Lead to migrate the Smart Client Customer Data into Remedy Migration across all the regions like NA, EMEA & APAC.
  • Understanding the business logic between the Smart Client and Remedy system to create a master mapping document for each dataset.
  • Defined, analyzed, and validated business requirements with the source and destination system to know the feasibility to accommodate all the features.
  • Created MSSQL Procedures to have a periodic sync between the Smart Client and Remedy. The Procedure will extract the RAW data from the source Smart Client, performs data cleaning and interface the data into the respective data sets likeRemedy Foundation, CMDB, Vendor CI, People CI data.
  • Created Linked Serverto access the Source Databases like Smart Client and Remedy, and used OPENQUERY to access the table sources.
  • Used Error Handling Exceptions inside the MSSQLjobs
  • Using SQL Server Agent Created and Scheduled the Jobs that daily/hourly basis based on the nature of the Jobs
  • Createsdata flow diagram that explains how the data process from Source Smart Client to Destination Remedy using DRAWIO.
  • Created Master Entity Relationship Diagram that explains how technically the data flows from source and destination, what kind of data massaging that needs to be performed before interfacing the data to the destination tables.
  • All the deliverables will be delivered in Agile Methodology using the JIRA Sprint Planning.
  • All the action items will be recorded in the Backlogs. Initial discussion will be organized by me with the development team to get the effort estimate on each JIRA story.
  • Involved in scheduling the all the jobs created in a sequential manner by knowing the dependency on each data set. Sprint Planning will be discussed with the Clients, and get the priority from them and plan accordingly based on the sprint effort on each JIRA story.
  • We will always have a buffer in the Sprint Plan to ensure for taking care of any ad-hoc requests requested by clients, and to handle customer escalations.
  • Facilitated release management of monitoring standardized solutions and requirement definitions through formal technical reviews.
  • Development/Engineering, Technical Support, and Global Operations.
  • Oversaw requirements traceability matrix and ensured that acceptance test strategy and plan aligned accordingly.
  • Ensured development process proceeded within and met target/milestones dates for roll out of services.

Confidential, Chicago, IL

Oracle EBS Senior Developer

Environment: Oracle, PL/SQL, SQL*loader, PL/SQL Developer, Visio, Draw IO, and Oracle Application R12

Responsibilities:

  • As part of Lenovo’s acquisition of Confidential, it has been intended to incorporate Confidential Process maintained in Oracle R12 to Lenovo’s SAP Model.
  • Involved in requirement gathering, analysis and design of the application.
  • Worked with the client team to understand the currentBusiness processes currently being carried out in Confidential across all the modules, drafting the different process models, as well as system relationship of various legacy systems.
  • Presenting the Confidential As Ismodel to Lenovo team and discussing on the Lenovo’s requirement as well as SAP limitations for deriving To Bemodel.
  • Worked with different team to understand to workflow and data flow exists in Oracle R12 and created data flow diagram for the Lenovo Team.
  • Involved in writing SQL scripts to fetch the sample data based on the EBS Modules.
  • Involved in analyzing the existing PL/SQL Stored Procedures to know the custom logic exists in Oracle R12and highlight the mapping for the same.
  • All the customization exists per modules are well documented with the sample data, to map the respective Oracle EBS functionality in SAP
  • Coordinating between Onsite and Offshore team.

Confidential

Oracle EBS Senior Developer

Environment: Oracle, PL/SQL, SQL*loader, PL/SQL Developer, Visio, Oracle Forms, Oracle Reports, Kintana, Clear case, WINSCP, PUTTY, and Oracle Application R12

Responsibilities:

  • Developed a New Custom Form: Time Based Confidential .
  • The Objective of this Form component is to maintain the BOM/ATO Planning percentage in R12 APS instance. An Oracle Form was created that will hold the BOM data based Search Criteria ATO Grand Parent, Option Class and Option Item.
  • Once the collection RUN is completed on weekly basis, the latest BOM details will be updated in the R12 APS BOM table (msc bom components). A new concurrent program was created and scheduled after the collection program that will fetch the latest BOM details into the Staging Table.
  • I have used Content Canvas for the Search Criteria and used Stacked Canvas for displaying the result block.
  • Most of the input parameter was configured in the Form as LOV in the palette.
  • All the back end table update that happens through the form was well maintained in separate PL/SQL block inside the form and handled Exceptions accordingly.
  • Form Installation and Initial Configuration steps was taken care by me, the steps were well documented and shared across the team.
  • Developed PL/SQL Packages for BOM Comparison Reportthat compare the BOM structure from the last week structure with the current week structure,and Confidential report that show the BOM structure from the current week to next 52 weeks. Both the report output will be exported an EXCEL attachment and will be send as an attachment to the configured emails.
  • Used UTL FILE to create reconciliation & compare report.
  • Declared Global Variables/Local Variables in the PL/SQL Package based on the usage
  • Used ParameterizedCURSOR to fetch the data from the staging table, store the data into a ROWTYPEvariable, and do a single insert into the final table.
  • Precise Demand Calculation: Confidential Mobility uses Demantra to estimate future demands based on the market conditions. In the exiting process, the gross shipments will be extracted from R12 ERP and loaded into Demantra. Returns History will not be considered while calculating the DEMAND.
  • The Objective of this project is to collect returns (RMA) from R12 ERP, store the data in a new custom series, so the planners could refer the Returns and create their DEMAND more accurately.
  • Collected Returns history from ERP into Demantra using the PL/SQL stored procedures.
  • RMA Receipt and Credit, RMA Receipt only data collected into Demantra.
  • RMA Credit only data NOT collected into Demantra.
  • Used Dynamic SQL to access the Oracle R12 transactional database from Planning database.
  • Used BULK Collect to collect the RMA extract from the REF Cursor and load the data into RMA history table using RECORD type
  • Returns data is showcased in a custom series “Returns” in Demantra.
  • Involved in preparing test scripts in all the levels of the project.
  • Involved in both creating and reviewing of MD70 based on the MD60 created by the functional folks.
  • All the changes will be migrated with the Change Request. I will be responsible to create the test cases with evidence that covers the entire scenario, attached the prepared technical design documents and to migrate the changes through Kintana.
  • Involved in Post Production Support after the GO LIVE.

Confidential, Horsham, PA

Oracle EBS Senior Developer

Environment: Oracle, PL/SQL, SQL*loader, PL/SQL Developer, Visio, TOAD, Kintana, Clear case, WINSCP, PUTTY, PeopleSoft and Oracle Application 11i

Responsibilities:

  • Responsible for creating the queries based on the existing PeopleSoft requirements.
  • Performed System Administrator role to define users and assign responsibilities and set profile options.
  • Developed PL/SQL Reports that shows the visibility on Inventory Onhand with respect to Inventory Organization, Locator, Cubic Volumes&Inventory Aging Report
  • Developed PL/SQL Reports that shows the visibility on PO receipts by volume with respect to inventory organization.
  • Developed PL/SQL Reports that shows the visibility to Excess & Obsolete Report
  • Have created PL/SQL procedures that explore the BOM Phantom details.
  • Explored the BOM using the Oracle API - bompxinq.export bom and LOOP each component to check whether it is a Phantom based on the supply type of the component.
  • Created custom concurrent programs for each XML reports and created custom value sets associated to the concurrent program.
  • Constants values used across the PL/SQL packages are maintained using the custom lookup and Descriptive Flex field.
  • All the changes will be migrated with the Change Request. I will be responsible to create the test cases with evidence that covers the entire scenario, attached the prepared technical design documents and to migrate the changes through Kintana.
  • Involved in Production Support Activities after GO LIVE.

Confidential

Oracle EBS Senior Developer

Environment: Oracle, PL/SQL, SQL*loader, PL/SQL Developer, Visio, TOAD, Kintana, Clear case, WINSCP, PUTTY, and Oracle Application 11i

Responsibilities:

  • Developed a New Custom Form: Confidential (Buyer Workbench & Approver Workbench)
  • Buyer Workbench was designed to submit multiple BPA’s at a time for approval and the Approver Workbench to approve the BPA submitted for the approval.
  • As part of Standard Oracle EBS functionality, the Blanket Purchase Agreement will be either submitted or approved once at a time. We have created Buyer workbench, that display the list of BPA released that are eligible for submission for approval. So the Buyer can submit multiple BPA for submission.
  • Once the Buyer submitted the BPA, BPA eligible for approval will be displayed in the Approval Workbench. Supervisor can approve / reject the BPA based on the approval limit and requirement.
  • I have used Content Canvas for the Search Criteria and used Stacked Canvas for displaying the result block.
  • Most of the input parameter was configured in the Form as LOVin the palette.
  • All the back end table update that happens through the form was well maintained in separate PL/SQL block inside the form and handled Exceptions accordingly.
  • Used the ROWTYPE to load the data from the staging to final table
  • Invoked the PO APPROVAL workflow, to approve the BPAinsidea PL/SQL Proecure.
  • Form Installation and Initial Configuration steps was taken care by me, the steps were well documented and shared across the team.
  • Involved in both creating and reviewing of MD70 based on the MD60 created by the functional folks.
  • Interacted with the end user to ensure the requirement was taken care and get the feedback to incorporate any additional changes.
  • Granting accessand Form privileges to the new users in Oracle Applications.
  • All the changes will be migrated with the Change Request. I will be responsible to create the test cases with evidence that covers the entire scenario, attached the prepared technical design documents and to migrate the changes through Kintana.
  • Involved in Production Support Activities after GOLIVE.

Confidential

Oracle EBS Senior Developer

Environment: Oracle, PL/SQL, SQL*loader, PL/SQL Developer, Visio, TOAD, Kintana, Clear case, WINSCP, PUTTY, and Oracle Application 11i

Responsibilities:

  • The Objective of the project is to create a overall design strategy to deploy MWB Site for Taiwan organization and to implement the required process flow.
  • Involved in both creating and reviewing of MD70 based on the MD60 created by the functional folks.
  • Interacted with the end user to analyze their requirements.
  • Created interfaces to extract the Item, Item Category, Vendor, ASL, Item Buyer and GSR.
  • Used BULK Collect to load the VALIDATED data from staging to Oracle Interface tables.
  • Granting access and task privileges to the new users in Oracle Applications.
  • Responsible for Technical design documentation for the forms.
  • Responsible for Development of the reconciliationreports usingPL/SQL packages for each data source that helps to identify the Processed/Error records in each data set.
  • All the changes will be migrated with the Change Request. I will be responsible to create the test cases with the evidence that covers the each scenario, with the prepared technical design documents and to migrate the changes through Kintana.
  • Involved in Production Support Activities after GOLIVE.

Confidential

Oracle EBS Senior Developer

Environment: Oracle, PL/SQL, SQL*loader, PL/SQL Developer, Visio, TOAD, Kintana, Clear case, WINSCP, PUTTY, and Oracle Application R12

Responsibilities:

  • The objective of the project is to replace the functionality in CRIS (Cost Reduction Information System) into Oracle Application R12.
  • Responsible for creating the initial SQL extract scripts to get the legacy data for each data set.
  • Tointegrate theCRIS functionality into Oracle R12 SystemItem,Item Cross Reference, Item Cost, Item Category and Bill of Materials related information needs to be migrated.
  • Responsible for creating the initial SQL extract scripts to get the legacy data for each data set.
  • Staging table data will be validated and loaded into the respective interface tables for Item, Item Cross Reference, Item Cost, Item Category and Bill of Materials
  • Using the Standards Oracle Concurrent, the data will be loaded into the base tables.
  • Summary report (Reconcile report) will be sent the user who is submitting the program.
  • Responsible to create the AOL Objects like Executable, Concurrent Programs along with the value set.
  • Have been worked as key Developer to develop data conversion PL/SQL packages to interface the data into the base tables.
  • All the PL/SQL packages code will be reviewed with the concern team before migrating that into Production.
  • Responsible in both creating and reviewing of MD70 document specific to each conversion object.
  • Test cases will be created with respect to each PL/SQL packages and I will be responsible in publishing test results and documents in Google docs.
  • Implemented the updated code across various instances via code migration tools (Kintana and Clear case).
  • Designed and developed a generic PL/SQL package that can be used to send mail to the corresponding team with/without attachment. Generic logic created for reusable purpose across application. All the To Address, Subject can be either passed as a parameter the package or it can be configured in the Custom Lookup

Confidential

Oracle EBS Senior Developer

Environment: Oracle, PL/SQL, SQL*loader, PL/SQL Developer, Visio, TOAD, Kintana, Clear case, WINSCP, PUTTY, and Oracle Application R12

Responsibilities:

  • The scope of this project is to replace Oracle Demand Planning with Demantra. Demantra is a best in class provider of demand management, sales and operations planning, and trade promotions management solutions tool to predict the accurate statistical forecasted demand.
  • Demand Forecast Process: Collect the required data for the forecast from different regions, analyze, derive the global consensus forecast and publish the forecasted data.
  • Involved in both creating and reviewing of MD70document specific to each deliverable based on the MD60 created by the functional folks.
  • Worked as keyDeveloper to create three PL/SQL packages for Product Import, Backlog Import and Data Purge Component to purge the Demantra base tables.
  • Using the Standards Oracle Concurrent, the data will be loaded into the base tables.
  • Responsible to create the AOL Objects like Executable, Concurrent Programs along with the value set.
  • Test cases will be created with respect to each PL/SQL packages and I will be responsible in publishing test results and documents in Google docs.
  • Involved in the post production support after the GO LIVE.

Hire Now