We provide IT Staff Augmentation Services!

Oracle Apps Techno Functional Developer Resume

Charlotte, NC

SUMMARY

  • Computer Engineer with proven expertise in object - oriented analysis and design and exceptional record overseeing all facets of Software Development Life Cycle, from analysis and design to implementation and maintenance. Looking to secure a challenging position in a well-established organization where my knowledge and experience as an Oracle Techno Functional is shared and encouraged.
  • Over 9+ years of experience in Oracle Applications E-Business Suite as a Techno- Functional Consultant in design, development, data conversion, implementation and upgrading of Oracle Applications. Experienced in version upgrade from 11i to R12.
  • Experience in Purchasing (PO), Order Management (OM), Payables (AP), Receivables (AR), General Ledger (GL), Financial Accounting Hub (FAH), TCA, Advanced Pricing, Service Contracts, SLA and Inventory (INV), CM, FA modules in Multi-Org Environments (MOAC).
  • Hands on experience in Development, Customization of RICEW (Reports, Interfaces, Conversions, Extensions, and Workflow,) Objects and creation of Functional/Technical Design Documents
  • Expertise in using Oracle 9i, 10g,11g and, 12c, 12c Exadata databases and Proficient in PL/SQL programming using Procedures/Packages, Database Triggers, Cursor variables, Custom Exceptions, Exception Handling, Conditional Control Statements, Loop Statements and Dynamic SQL.
  • Experienced in design and development of Interface/Conversion programs to import data from legacy systems and integrate into Oracle Applications using open interfaces and APIs, and worked on Interface/Conversions like GL Interface, Supplier Invoice Interface and Customer Invoice Interface.
  • Excellent Perspective on Converting the Functional Specifications into technical design and Development
  • Extensive end user support and involved in root cause analysis, coordination with users, fixing, testing, user approval and migration to production
  • Good Experience in business flows like Procure to Pay (P2P), Order to Cash (O2C), Configure to Order, Quote to Cash, and Drop Ship Cycles.
  • Experience in UNIX Shell Scripting and Command Line Utility. Developed/ Used scripts to generate. ldt files for concurrent programs, value sets, request sets, profile options and upload them in other environments.
  • Extensive experience in Implementation, Customization, and Support for Oracle Applications using Oracle development and reporting tools like SQL*Loader, SQL Developer, JDeveloper, Workflow Builder, TOAD, SQL*Plus, Reports 6i/9i/10g, XML/BI Publisher and Discoverer 4i/9i/10g.
  • Experience in writing design documents (AIMS) MD50s and MD70s
  • Proven hands on experience in customizing and development of forms, reports, Alerts, PLSQL API’s, interfaces, workflows, OA framework pages and customizing/extending Oracle Discoverer.
  • Extensively worked on design and development of data conversions including master data and transactional data (Supplier, Customers and AP/AR transactions, GL Balances and Assets) as part of various r12 re-implementation and implementations
  • Strong experience in SQL and PLSQL. Proficient in using Developer2000, Forms 6i/10g and Reports 6i/10g for both development and customization of forms and reports as per client specifications.
  • Strong knowledge in Multi-Org Architecture and Trading Community Architecture (TCA).
  • Worked on Oracle EBS and third part tools (RevPro), Hadoop integrations.
  • Good understanding and ability to troubleshoot various issues faced during the development lifecycle including coding, debugging, testing and final roll-out.
  • Excellent communication and interpersonal skills, Self-motivated, Hardworking with an ability to perform under pressure and work in a team environment.

TECHNICAL SKILLS

ERP: Oracle Applications 11i(11.5.9,11.5.10,11.5.10.2), R12(12.0.4,12.0.6,12.1.3,12.2.4, 12.2.5,12.2.6, 12.2.9)

Data Bases: Oracle 9i, 10g, 11g, 12c, 12c Exadata, 19c

Oracle Applications: GL (+ FAH), XLA, AP, PO, AR, INV, OM, CM, FA, AOL, SLA, Shipping, Advanced Pricing, IExpense, iProcurement.

Oracle Tools Forms: Oracle Forms 10g/6i

Reports: Oracle Reports 10g/6i, XML Publisher

Discoverer: Discoverer Administrator 4i/10g, Discoverer Desktop and Plus 4i/10g

Work Flow: Work Flow Builder 2.5

Other Tools: FND Load, Data Loader, Putty, HP Quality Center, HP ALM, MS-Office, WinSCP, WebADI, Github,uDeploy, HP PPM, Dimensions CX, Aqua Data Studio, Autosys

Documentation: Application Implementation Methodology (AIM), MD70, MD50, CV40, BR100

Languages: SQL, PL/SQL, SQL*Plus 9.0, SQL*Loader, C, C++, Shell Scripting

Development Tools: TOAD, SQL Developer, SQL*Plus, JDeveloper (OAF &ADF), IntelliJ

Integrations: Oracle EBS to RevPro (Revenue Recognition Tool) Integration. Oracle EBS with Scala-Hive based custom framework. Oracle EBS with Java-Spark based custom framework.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle Apps Techno Functional Developer

Responsibilities:

  • Worked on 2 Applications to implement non-Oracle Sub-Ledger Integration with Oracle FAH to consume WIM data for Accounting and Oracle EBS General Ledger Project.
  • Worked in an environment to address enhancement requests and also performed Production Support duties for RICE components.
  • Authored Technical Design (MD70) based on Functional Requirements (MD50) and walk through the technical design of the components for both applications.
  • Supported existing RICE components and also developed new ones based on Business Requirements.
  • Implemented PARALLELISM in multiple custom programs to process Millions of transactions in no time.
  • Worked on multiple POCs internally to perform impact analysis on the increase of data volume and to propose Design changes of existing systems.
  • Worked with Oracle by raising Service Requests (SR) to get Customized Patches to support Confidential ’s Oracle Exadata environments.
  • Modified multiple custom Concurrent Programs to include Parallel Hints to enhance the runtimes of batch jobs.
  • Made use of AWR reports and SQL Tuning Advisor reports to fine tune various long running jobs by working with DBAs to create SQL Profiles on those various Concurrent Jobs.
  • Developed custom Packages, Procedures, Data Clean up scripts (DMLs) based on business requirements.
  • Monitored and fixed multiple Performance Issues on custom Concurrent Programs as a part of Production Support duties.
  • Worked with Product Teams internal to WF to integrate Oracle EBS with internal Java-Scala based framework called FlowMaster to lift and shift data from oracle to create parquet files on mapr volume.
  • Developed shell scripts to extract parameters needed to submit spark jobs from csv files.
  • Created/configured json files, shell scripts, jil scripts needed to automate connectivity and flow between Oracle EBS and Hadoop Environments.
  • Developed Autosys scripts to trigger spark jobs from oracle EBS via concurrent programs.
  • Automated the complete process submit spark jobs from oracle EBS.
  • Supported various Testing cycles for the Quarterly Release Schedules.
  • Worked with EBS-DBA Team to raise Work Orders, Change Requests for various activities.

Environment: Oracle EBS R12.2.6 (Financial Accounting hub (FAH), AP, AR, XLA, General Ledger, System Admin, AOL), Oracle Exadata, SQL, PL/SQL, JDeveloper (OAF), SQL Developer, TOAD, SQL*Plus, SQL*loader, Forms Builder 10g, UNIX shell script, HP ALM, OAF, ADF, Putty, WinSCP, GitHub, uDeploy, JIRA, Agile, PAC2000, Aqua Data Studio, Spark, Scala, MapR,Autosys.

Confidential, Davidson, NC

Responsibilities:

  • Design and Develop Utilities to handle various Logo changes on XML Publisher Reports and Oracle Reports to integrate into Oracle E-Business Suite.
  • Design and author Technical Design (MD70) based on Functional Requirements (MD50) and walk through the technical design of the components for Separation project.
  • Address enhancement requests for various existing and new XML Publisher and Oracle Reports.
  • Worked on Oracle Projects module to close make the adjustments in Funding/ Billing/ Events and close out the projects to PENDING CLOSE and eventually CLOSE them out.
  • Worked on Oracle Payables to create custom programs to update Pay Groups for selected OUs based on Invoice Number and Doc Sequence Numbers for different OUs.
  • Developed script to stage targeted ASNs which are in EXPECTED/ PARTIALLY RECEIVED status, insert them in RCV TRANSACTIONS INTERFACE and run “Receiving Transaction Process” to cancel the ASNs.
  • Design and develop custom database objects like Packages, Stored Procedures, Functions, Triggers, Anonymous Blocks, shell script to meet the business needs.
  • Create FND Messages, Users, Profile Options, Value Sets, Menus, Form Functions, Alerts to make sure the RICE components work in both production environments.
  • Made use of oracle’s API’s and built custom logic to perform data validations, addition or update of new/existing functionality as per business requirement.
  • Troubleshoot various issues in existing Production Environment and address enhancement requests.
  • Work with Oracle Service Requests team the handle issues from Product by raising SR’s, engaging oracle in testing sessions to replicating the issues, attended calls via WebEx sessions to explain issues and to get solutions.
  • Perform code changes, create proper versions of code and PPM entries based on Change requests.
  • Design implementation plans for monthly releases and coordinate with deployment engineers for production deployments.
  • Involve in production support, proactively identify potential issues and offer solutions based on existing code.
  • Debug and perform root cause analysis on issues raised by business teams.
  • Design alerts using shell scripts and integrate with Oracle E-Business Suite.
  • Work with DBAs on various data clean-up activities in higher environments in case of any job failures for various reasons in higher environments.

Environment: Oracle E-Business Suite R12 (SCM, AP, AR, GL, MFG, Projects Modules), SQL, PL/SQL, Shell Scripting, XML Publisher Reports, Oracle Reports, JDeveloper (OAF), WINSCP, Putty, JIRA, HP PPM, Dimensions.

Confidential, Charlotte, NC

Oracle Apps Techno Functional Developer

Responsibilities:

  • Worked on 2 projects to implement FAH in Oracle EBS to process 60 Million transactions and production support of General Ledger in Oracle EBS as another application.
  • Designed and authored Technical Design (MD70) based on Functional Requirements (MD50) and walk through the technical design of the components for FAH project.
  • Supported existing RICE components while developing new ones based on Business Requirements.
  • Worked with Oracle to customize GLPPOSS executable for posting to handle huge volume of transactions.
  • Addressed enhancement requests for General Ledger project as a part of production support.
  • Design and develop custom database objects like packages, stored procedures, functions, triggers, anonymous blocks, shell script to meet the business needs.
  • Created Responsibilities, Users, Profile Options, Value Sets, Menus, Form Functions, Alerts.
  • Made use of oracle’s API’s and built custom logic to perform data validations, addition or update of new/existing SEGMENTS in oracle EBS to create/modify the new/existing Code Combinations.
  • Design and develop custom OAF forms to meet business requirements to support the business users to Modify/Delete/Search GL Source/Categories, Elimination Offset/Target Accounts, Suspense Line Entries records.
  • Worked on Inbound and Outbound Interface designs to consume and output data from EBS applications.
  • Created adamin and XML Import scripts for deploying the OAF forms. Worked with automation of OAF Forms deployments with uDeploy team.
  • Worked on BSV Form OAF Personalization to allow users to correct 50 to 100 records at a time.
  • Designed and developed Posting Wrapper jobs to run 10 to 12 parallel posting jobs at a time.
  • Worked with Oracle to support the systems by raising SR’s, engaging oracle in testing sessions to replicating the issues, attended calls via WebEx sessions to explain issues and to get solutions.
  • Worked on performance tuning, implemented Parallel Processing for long running and huge data load queries.
  • Modified many packages to drop and recreate N(X) indexes before and insert and after an Insert to reduce the processing time.
  • Design implementation plans for monthly releases and coordinate with deployment engineers during the production deployments.
  • Involved in production support, proactively identifying potential issues and offer solutions based on existing code.
  • Debug and perform root cause analysis on issues raised by business teams.
  • Design alerts using shell scripts and integrate with Oracle E-Business Suite.
  • Work with DBAs on various data clean-up activities in higher environments in case of any job failures for various reasons in higher environments.
  • Authored Implementation plans for project releases, led the code deployments for 2 SOR integrations.

Environment: Oracle EBS R12.2.6 (Financial Accounting hub (FAH), AP,AR,XLA, General Ledger, System Admin, AOL), Oracle Exadata, SQL, PL/SQL, JDeveloper (OAF), SQL Developer, TOAD, SQL*Plus, SQL*loader, Forms Builder 10g, UNIX shell script, HP ALM, OAF, ADF, Putty, WinSCP, GitHub, uDeploy, JIRA, Agile.

Confidential, Charlotte, NC/ Atlanta,GA

Oracle Apps Developer / Integration Lead

Responsibilities:

  • Worked on Integrating a third part tool (RevPRO) which helps in Revenue Recognition with Oracle EBS R12 version
  • Develop PL/SQL scripts to accommodate various client’s requirements during the outbound (GL Data) and inbound process (OM Data).
  • Validate data flow from Oracle EBS to RevPRO and develop stored procedures and packages to build interface programs.
  • Develop scripts to perform validations on data that is pushed back to Oracle GL interface tables from RevPRO.
  • Working on generating acknowledgements for data pushed to third part tool and data received from third party tools in to Oracle Applications.
  • Worked for Integration team in Confidential . As a part of Integrations, worked with Dell Boomi WebServices team and Client during various stages of the Implementations.
  • Initial phase of the project Implementation involves identifying the data with respective table/columns across OM, AR and GL modules.
  • Designed the process to stage the data in client’s environment that is identified as required by RevPro. Once the data is staged in the staging area, work with Boomi WebServices team to pull the data from Oracle EBS staging area to RevPro staging area.
  • Worked on customizations and added validations to product related stored procedures to perform data validations before and after Revenue Recognition.
  • Co-ordinated with the WebServices team to pull the data as required once the data is staged in EBS and validate the data that is pulled into RevPro staging tables.
  • Worked on Acknowledgement services process design to trigger emails from RevPro to users to identify the issues in Data Collection process.
  • Performed Data Collection process in RevPro to create Revenue contracts as required during the implementation and Validate the data flow across various tables in the RevPro.
  • Worked with clients to update the data issues that were raised during the Data collection process to correct the staged data.
  • Designed Outbound GL Data feed push from RevPro to Oracle EBS environment of the client once the Revenue is Recognized.
  • Worked with WebServices team and Functional team during the whole CRP, UAT testing to validate the data as pulled from EBS.
  • Worked on Scheduling process of Data Pull and Data Collection processes in production to completely automate the process.

Environment: Oracle EBS 12.2.5 (OM, INV, AR, GL), SQL, PL/SQL, SQL Developer, TOAD, RevPro, Inbound and Outbound Data Pull and Data Push, Dell Boomi Websevices, SOAP.

Confidential, Charlotte, NC

Oracle Apps Techno- Functional Consultant

Responsibilities:

  • Extensively worked on Oracle General Ledger reimplementation from Oracle EBS 11. .2.5
  • As part of the re-implementation team involved in requirement gathering sessions, designing and authored Technical Specifications (MD070) based on Functional Specification documents (MD050) for various customizations.
  • Migrated various 11i RICE objects to r12 which involved in re-engineering of all the 11i custom objects including re-developing based on r12 functionality and new business changes
  • Created Packages, Stored Procedures and created concurrent programs, request sets on them and assigned to various responsibilities based on requirements.
  • Created new Responsibilities, Users, Profile Options, Value Sets, Menus, Form Functions in DEV environment. LDT files were generated for Concurrent Programs, Value Sets and deployed in other environments later.
  • Developed SQL*Loader scripts to load data from legacy system into custom interface tables after validating data through a custom built Concurrent Programs.
  • Worked on AuditTrial setups on some custom tables to generate reports on regular basis as a part of complete cycle.
  • Raised SR’s with Oracle to perform third party integrations and developed Technical documentation for DBAs to apply patches and handle the integration.
  • Worked on building scripts for data conversions to push data from 11i EBS to R12 EBS for 3 different components using database links.
  • Worked on integrating Oracle ADF with Oracle EBS 12.2.5 and implemented successfully.
  • Gathered business requirements for the custom ADF forms and designed wireframes.
  • Developed custom ADF forms for performing create, update and search operations on custom tables for users to maintain data on various source systems and their categories.
  • Used various ADF Faces across different regions during the development of ADF forms based requirements.
  • Designed and developed scripts to perform completely custom processes in GL module.
  • Developed PL/SQL Scripts to load data from external system to GL Interface tables and GL Base tables after performing prevalidation (custom process).
  • Worked on Oracle Application Framework (OAF) to develop custom forms for re-implementation. Created form functions for the same and took care of deployment process in various environments.
  • Developed custom OAF forms to search, create, validate and update records on elimination accounts, unpostable records.
  • Co-ordinated with DBA’s to run adadmin scripts and bounce of apps tier when needed.
  • Extensively developed PL/SQL scripts to perform validations, archive and purge records according to business rules.
  • Worked on Profile Option changes to make sure multiple journal imports does not post various ledgers to same batch and made sure separate Group IDs are populated for each posting.
  • Documented all the work done for future reference. Also created various reference manuals for functional testers and users.
  • Processed data coming from third party Sub-Ledgers (AP,AR) accounts and loaded data into separate Financial Accounting module which later posted to consolidated GL module.
  • Created Indexes on tables and worked on procedures to change SQL scripts to improve the performance of packages thereby decreasing the time consumed by concurrent programs
  • Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, Request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.

Environment: Oracle EBS 11i/R12.2.4 (GL, INV, OM, AR), Oracle Exadata, SQL, PL/SQL, JDeveloper, SQL Developer, TOAD, SQL*Plus, SQL*loader, Forms Builder 10g, UNIX shell script, HP ALM, CA SCM Harvest (Code Repository), OAF, ADF, Putty, WinSCP.

Confidential, South Plainfield, NJ

Oracle Apps technical Developer

Responsibilities:

  • Worked with the end users and gather requirements for developing the detailed process flows and there by developing the requirements matching the custom code.
  • Responsible in developing XML BI publisher reports with respect to printing of repair order information that is send to supplier.
  • Designed custom interfaces from R12 that involves capturing of various transactions coming as flat file basis from third party systems.
  • Designed and developed inventory synchronization report that involves getting the data from third party system.

Confidential, KS

Graduate Research Assistant

Responsibilities:

  • Worked as a Graduate Research assistant in NetApp facility at Confidential .
  • Designed and developed small scale projects to track orders and shipping of orders and requests raised internal around the university.
  • Designed and Developed data models for a Student/Proctor Peer reviewer by getting student’s opinions on proctor and the course work.
  • Created Custom packages, procedures, tables, views, synonyms, sequences, Database Triggers, Cursor variables, Custom Exceptions and other database objects needed for the projects as needed.
  • Worked on fixing long running queries and performance tuning.
  • Worked on multiple academic projects during the course on Parallel Processing, Processor Aging, Parallel Sessions at processor level. Projects Include:
  • Improve the interrupt and polling in Embedded System by using Software Abstraction
  • Parallel Programming to improve concurrency in Multicore Embedded System
  • Implementation of pseudo Banking RDBMS.

Environment: Oracle 11g, SQL Developer, Unix, PL/SQL, Java.

Confidential

Software Programmer

Responsibilities:

  • Worked for a construction company which was developing customized reports and interfaces for internal accounting.
  • Implemented the project from scratch which includes various modules like AP, AR, PO, GL, and INV.
  • Worked mainly on developing conversions and interfaces for modules PO and AP and several reports and other enhancements.
  • Worked on reports to show all cleared Invoices sorted by Invoice groups to show all approved journals that needs to be posted. Also customized reports using report builder as per the requirements.
  • Used PO Approval Workflow to approve new documents and also approve revisions to the Purchase Orders using workflow builder.
  • Customized workflow for PO Requisition Charge Account Generator using workflow builder.
  • Customized supplier form to make it only to be created on approval using workflow builder.
  • Worked on custom packages to develop conversion and Interface programs.
  • Documented customer notes, customers, projected purchases, vendors and developed Approved Suppliers conversion programs.
  • Worked on GL Inbound Interfaces to import the Journals data from third party systems to Oracle applications GL base tables using the standard program ‘Journal Import’.
  • Generated custom reports using different tools like BI Publisher, Discoverer.
  • Used XML Publisher to develop Sales order Report, Purchase order report, Purchase Order Arrival.
  • Developed, implemented and unit tested AP Invoice interfaces in order to import data from the legacy system through a flat file into staging tables using SQL*Loader, validate the data using PL/SQL procedures, insert data into interface tables and running the invoice import concurrent program to load the data into oracle AP tables.
  • Developed many PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
  • Performed customization of the various PO and Sales Order reports.
  • Developed and Created new concurrent request set and scheduled the Order Import interface program to run periodically.
  • Worked on Interfaces to load all the open invoices in to Oracle Receivables.
  • Worked and Tested various set ups and implementation of AP, AR, OM, GL, PO, INV Modules in 11i.
  • Possess functional knowledge on all Financials modules and good knowledge on O2C, P2P cycles, APIs and underlined tables.
  • Created Triggers, Packages, Procedures, Functions, and anonymous blocks to meet the business requirements.
  • Worked on performance improving activities for complex queries using TKPROF, EXPLAIN PLAN, AUTOTRACE and other performance tuning techniques.
  • Provided 24/7 production support when needed.
  • Deployment of application in the Dev, Load Test, Pre-Prod and production environments.
  • Effectively handle escalations & complaints related to project.

Environment: Oracle Applications 11i (GL, AR, AP, PO, OM, INV), BI Enterprise Edition, Reports 6i, workflow, XML Publisher, Discoverer, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX.

Hire Now