SUMMARY

• IT - Business Professional with experience in Business Analysis,functionaland technical design of Oracle EBS.
• Over 8 years of experience in Oracle E-Business Suite in Design, Development, Implementation and Customization of business applications using Oracle Applications.
• Proficient in Software development life cycle (SDLC) including analysis, design and implementation of software applications.
• Experience in Application Object Library (AOL) for registration of concurrent programs, Request Sets, Interfaces, Forms, Reports, Value Sets, Profiles, Custom Menus and responsibilities etc.,
• Experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Triggers.
• Experience in various development tools like SQL Developer, SQL*Loader, TOAD, FileZilla, WINSCP, PUTTY.
• Good working knowledge on Oracle core financial, Supply Chain and Manufacturing modules along with exposure on Order to Cash (O2C) and Procure to Pay (P2P) cycles.
• Hands on experience in designing, developing and testing various RICEW (OracleReports, Forms, Interfaces, Conversions, Extensions and Workflows) components as per Oracle standards.
• Good Exposure to OracleApplication implementation methodology (AIM) and Oracle Unified Methodology (OUM).
• Extensive working experience in Reports development using XML Publisher, Oracle Discoverer and Oracle Reports.
• Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments and also self-motivated to work independently with excellent communication skills.

TECHNICAL SKILLS

Oracle Applications: E-Business Suite - Oracle R12 (12.2.9/12.2.5/12.2.4/12.1.3 )Accounts Payables (AP), Accounts Receivables (AR), Fixed Assets (FA), General Ledger (GL), Inventory (INV), Order Management (OM), Oracle Purchasing (PO), Oracle Projects, Service Contracts, Bill of Material (BOM), Work in Process (WIP), Oracle Revenue Management & Billing (RMB) - 2.3/2.6

Languages: SQL, PL/SQL, UNIX

Oracle Development Tools: TOAD, SQL Developer, Putty, WINSCP, FileZilla, SQL*PLUS

GUI Tools: Oracle Reports 10g, Oracle Forms 10g, XML(BI) Publisher, Workflow Builder, Discoverer Administrator, Desktop, Plus and Viewer 11g, Oracle Business Intelligence (OBIEE) 11g, Noetix Administrator, Noetix Generator, Noetix Workbench, Jenkins

Operating Systems: UNIX, Windows 10/8/7

Databases Tools: Oracle 12c,11g, MS Access

Version Control Software: Subversion (SVN), GitLab

Ticketing Systems: HEAT, RHESolution, JIRA, FootPrints, Service Now

Other Tools: Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Senior Oracle EBS Developer

Responsibilities:

• Work with Business Analysts, Solution Architects and Quality Assurance (QA) Engineers on project implementation.
• Analyze the functional software specifications, write technical specifications and implement business logic.
• Responsible for developing inbound and outbound interfaces between Oracle EBusiness Suite (EBS) and one or more SaaS solution providers in the expense management market.
• Design and develop the import of new time card, converted time card and amendment time card data between PSA (Professional Services Automation) and Oracle Project Accounting (OPA).
• Responsible for burning the Enhancement request queue for the import of Project interface between Salesforce cloud based platform, PSA (Professional Services Automation) and Oracle Project Accounting (OPA).
• Develop PLSQL functions and procedures to generate task numbers and sending the Oracle project details back to the source system using REST API calls.
• Design, develop, test, and maintain Oracle EBS integrations that conform to enterprise design standards.
• Design and develop the REST API calls to send outbound formatted JSON messages from Oracle EBS to Salesforce platform via an integration layer.
• Document use cases, create physical and logical data models and build deployment plans.
• Analyze log files to help debug software issues and provide ongoing support throughout the SDLC process.
• Design and develop the custom reprocess programs to support the projects creation and time cards import interfaces.
• Work with business partners to deliver leading-edge solutions on On-Premise and cloud-based SaaS applications. Partner with project leads to create end-to-end solutions.
• Develop and fix software bugs in existing code per the user requirements.
• Collaborate with teams within IT to develop software solutions and interact with team during SIT and UAT phases of projects.
• Perform data analysis for project conversion, run SQL to extract from the system and provide analysis.
• Follow the SDLC and agile methodologies in software development. Develop and test software developed, use automated tools to test and code base to store developed code.
• Analyze the run time of programs across various environments to suggest improvements.
• Prepare software changes upon the UAT and coordinate with change control and managers to migrate the changes to Production.
• Consult with stakeholders and end users to study software issues and develop solutions. Develop reports and prepare configuration and user guides for the software components being developed.

Environment: Oracle Applications R 12.1.3/ 12.2.9 (Oracle Projects, INV, OM, AP, AR, GL), SQL,PL/SQL, UNIX, Oracle 12c, Forms/Reports10g, WINSCP, Putty, GitLab, Jenkins, SQL Developer, TOAD.

Confidential, St. Louis, MO

Oracle EBS Developer

Responsibilities:

• Working closely with business analysts and solution architects for gathering and clarifying the business requirements.
• Analyzing the business and functional specifications and writing technical specifications followed by implementing the business logic.
• Developing inbound interfaces for the import of OSR data between a third party system and OracleTrading Community Architecture (TCA).
• Creating custom staging tables, materialized views, indexes in Oracle database and writing scripts to provide Grants on tables and PLSQL components.
• Developing custom PLSQL packages to read and validate the staging tables, applies business logic, formats and calls the public OPA project creation APIs.
• Defining and maintaining concurrent programs, lookups, xml data definitions and templates.
• Configuring profile options, adding sub menus and functions to the EBS responsibilities to facilitate the Oracle API calls.
• Developing XML publisher reports using rtf templates to produce the excel outputs on processed import data from staging tables.
• Designing and developing the custom reprocessing programs to support the custom interface import programs.
• Develop and support RICEFW components in Oracle Project Accounting (OPA), Order Management (OM), Oracle Receivables (AR), Accounts Payable (AP) and General Ledger (GL) modules.
• Assigning concurrent programs to the custom responsibility request group and scheduling concurrent programs and request sets on a periodic basis.
• Writing FNDLOAD scripts to download .ldt files for custom concurrent program, lookups, and XML publisher data definitions and templates.
• Coordinating with quality assurance/functional analysts for testing the project import programs and reports.
• Designing summary reports in the concurrent programs output and log files to display the status of the records and capture any errors.
• Updating mapping and setup documents, writing technical specifications document (MD070) and migration documents for the deployment.
• Performing Unit testing on the developed interfaces and monitoring the UAT during the test cycles in the recently cloned instances.
• Debugging and fixing the bugs and defects that identified during the UAT phase and accommodating the new code design changes in to the interface import programs.
• Using distributed version-control system GitLab, created repositories including branching, merging and tracking the developed technical components.
• Migrating the technical components between the instances and to the higher instances using GitLab.

Environment: Oracle Applications R12.1.3 (TCA, INV, OM, PA, AP, AR, GL), SQL,PL/SQL, UNIX, Oracle 12c, Forms/Reports10g, WINSCP, Putty, GitLab, SQL Developer, TOAD.

Confidential, Saukville, WI

Oracle BI Developer (EBS)

Responsibilities:

• Involved on an enhancement project called Cut-To-Length to address the Oracle system modifications and changes to the client business processes to meet the customer and inventory requirements successfully.
• Gathered requirements from business users and subsequently developed the functional and technical design documents for Oracle Discoverer and OBIEE reports touching various EBS R12.2.5 modules such as AR, AP, FA, GL, OM, INV, PO, WIP and BOM.
• Designed Functional Design Documents (MD050), Technical Design Documents (MD070) and Unit Testing Documents (TE020) complying with Oracle AIM standards.
• Extensively worked on developing, customizing and sharing several Discoverer workbooks under Financial, SCM and Manufacturing modules for business analysis.
• Collaborated with business users and peers to ensure successful implementation of multiple custom AP, AR and FA reports including all the ledgers as per the users request to meet their month-end processing needs.
• Created and customized underlying Noetix views and implemented using Noetix Workbench and Administrator for Discoverer and OBIEE reporting tools.
• Administered Noetix activities including Noetix Views Regenerations, Noetix Organization refreshes, Noetix EUL generation for Discoverer.
• Scheduled and monitored various concurrent jobs related to EBS activities, Noetix security along with Discoverer scheduled workbooks.
• Modified SQL folders in End User Layer (EUL), imported workbooks and granted privileges using Discoverer Administrator as per user requirements.
• Developed and modified various PL/SQL stored procedures, functions, triggers and underlying views for the Discoverer and OBIEE reports to implement complex business rules.
• Worked on enhancing the custom AR reports which are impacted by adding the new item catalog groups and catalog segments. Added the additional columns and logical conditions in to the reports.
• Involved on high level discussions on Discoverer migration project and as a prerequisite, cleaned up unpublished discoverer reports from production.
• Participated in all phases of the project including development, UAT, QA and Go-Live followed by post Go-Live support.
• Monitored the production issue track and prioritized the issues, involved on weekly team meetings and change review meetings across the IT division.

Environment: Oracle Applications R12.2.5 (PO, AP, AR, FA, GL, INV, OM, BOM, WIP), SQL,PL/SQL, UNIX, Oracle 12c, Discoverer 11g, OBIEE 11g, Forms/Reports10g, Workflow builder, WINSCP, Putty, SQL Developer, TOAD, Noetix.

Confidential, New York, NY

Oracle EBS/Reporting Developer

Responsibilities:

• Designed and authored various Business Requirement Documents (BRD), Functional Design Documents (FSD) and Technical Design Documents (TDD) that would help any person in understanding the end-to-end design.
• Working on Oracle Discoverer Reporting suite to customize and support several reports using in Financial, SCM and Manufacturing modules.
• Worked on an implementation project in Oracle R12 (12.1.3) on integrating Suppliers, Invoices and Banks from multiple third-party systems to Oracle Accounts Payable (OAP).
• Gathered business requirements and worked on documenting the requirements for building a Generic AP Supplier Interface and AP Invoice Interface.
• Created Visio’s for business flows, performed interface mappings and related documentation including BRD and BR100 for all AP (Accounts Payables) interfaces.
• Documented and developed the Supplier Bank interface from multiple third party systems using Oracle Standard API’s based on the BRD.
• Interacted on daily basis with Users on design requirement for data mapping from Legacy to Oracle R12.
• Worked extensively on defining Executables, registering Concurrent programs, creating custom Value sets, Lookups, Flexfields and Request sets as per client requirement.
• Modified a complex trigger on AP Base table to in corporate business logic on Supplier end date.
• Involved in analyzing, designing and developing the various RICE components. Worked on Interfaces, Data Conversions, developing and customizing Oracle Reports as per business requirements.
• Fixed the code by troubleshooting the issues on the existing reports, Views and custom packages of the Discoverer Reporting Suite.
• Involved and provided production support on Oracle Accounts Payable (AP), Accounts Receivables (AR), Purchasing (PO), Fixed Assets (FA) and General Ledger (GL) modules.
• Interacted effectively with users, developers and peers to ensure the successful delivery and implementation of the solution.
• Worked on Oracle Revenue Management and Billing (ORMB) upgrade project from version 2.3 to 2.6.
• Also tested Oracle RMB upgrade instance by identifying issues and supporting business functionality by working in close proximity with business users and technical team.
• Analyzed various inbound interfaces including creation of clients, policies, bonds, bill generations and custom batch jobs in ORMB.
• Entered and tracked issues in JIRA. Analyzed the defects raised, identified the root cause and provided the recommendations to the RMB and EBS technical teams to get them fixed.

Environment: Oracle Applications R 12.2.5/12.1.3 (AP, GL, PO, FA, FAH, RMB), Oracle 10g, SQL,PL/SQL, Forms10g, Reports10g, Oracle Discoverer, Workflow builder, WINSCP, SQL*Loader, TOAD and UNIX.

Confidential, Milpitas, CA

Oracle Apps Developer

Responsibilities:

• Prepared user level and system level maintenance documentation, Technical Documentation, Unit test, Integration Test and Test plans.
• Worked on CAPEX enhancement project in Oracle R12 (12.1.3) to improve the accuracy and controls of assets prior to asset creation by enabling end-to-end integrated business process.
• Created additional processes in the Projects workflow as a part of CAPEX Implementation Project to send workflow approval notifications to the functional and finance users in hierarchical way.
• Developed few custom workflows on sending the reminder and escalation notifications to the pending workflow approval notifications for Asset Validation.
• Worked on OE workflow change for specific Line Type to modify and to stop AR invoice interface.
• Worked on AP Credit Card workflow change to customize messages and notifications for expense reports.
• Resolved production issues on Cash Management Report, identified the issue and for the long-term fix, updated the code for this report as per the root cause analysis.
• Worked on AP, AR, PO, GL, FA, CM, OM and Projects modules as part of enhancement and implementation projects.
• Supported the team with Post production issues. Acted as a Maintenance technical support for guiding users understanding the new system and solve daily problems.
• Customized the Order Header Level and Line Level Workflow (WF) processes to add the custom activities.
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Involved in activities like Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options, registering Executables, Concurrent Programs, Form Functions and Reports by using Application Object Library (AOL) and System Administrator.
• Worked inOracleBack-end PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using TOAD and SQL Developer as development tools.
• Developed UNIX Shell Scripts for uploading/downloading files from the server and for moving objects between instances using FNDLOAD scripts.
• Involved in Project Checkpoint, CRP, UAT, Go-Live meetings and participated actively in CRP, UAT & Production Go-Live activities.
• Completed the Go-Live including preparation of deployment documentation, coordinating with DBA/OMCS (Oracle Managed Cloud Services) for the movement of code to production and provided warranty support for 15 days.

Environment: Oracle Applications R12.1.3 (AP, AR, GL, FA, OM, PO and Projects), Oracle 10g, SQL,PL/SQL, Forms10g, Reports10g, Oracle Discoverer, Workflow builder, TOAD and UNIX.

Confidential, Naperville, IL

Oracle Apps Developer

Responsibilities:

• Prepared Functional Design documents (MD050), Technical Design documents (MD070) and Unit Testing Documents (TE020), Installation Documents (MD120) for all the new design processes, customizations and enhancement work.
• Designed a new business logic which triggers an email notification to investigate whenever the inbound File is missing for a particular utility as per the existing schedules.
• Worked on few Form Personalization’s in AP, AR and OM modules to add/block fields at different levels.
• Worked on data repair change request to move the specific list of Inventory items from one sub inventory to another sub inventory.
• Involved in Performance tuning and increased the performance of custom reports by adding advanced concepts like Bulk inserts which benefited the business to get data more frequently to resolve errors.
• Worked on BI Publisher (XML Publisher) for Purchasing reports. Generated new reports as well as converted existingOraclereports to XML, by creating RTF templates using Template Builder.
• Experienced in creating Concurrent Programs, Request sets, Flex fields, lookups, Profiles, Value sets, User setup and defining responsibilities through Application Administrator responsibility.
• Created logical and physical database objects like tables, views, synonyms, indexes and triggers to meet development needs.
• Participated in technical design enhancement discussion, documented the requirements and finalized the approach of development of RICEW objects.
• Experience in customizing Oracle workflows such as the PO Approval process, Order/Line Flow to send user notifications based on the business requirement.
• Worked on tuning the custom packages for better performance, troubleshooting, debugging, fixing the code and made the changes according to the new business requirements.
• Created number of RFC’s (Request for Change) on MOS (My Oracle Support) for deployment of code in monthly releases.
• Resolved service requests from business by extracting the data requested.
• Exposure to Oracle EBS Production issues related to AP, AR, GL, FA, INV, OM, PO and Service Contracts modules.

Environment: Oracle Applications R12.2.4(AP, AR, GL, INV, PO and Service Contracts modules), Oracle 10g, SQL,PL/SQL, Forms10g, Reports 10g, Workflow builder, SQL*Loader, TOAD and UNIX.

Confidential, Naperville, IL

Oracle Developer

Responsibilities:

• Documented all the modifications and enhancements in the applications which includes technical, functional and business process changes.
• Worked on various Form Personalization’s effectively under PO and OM modules to accomplish specific business validations.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Used Oracle E-Business Suite applications, Accounts Payables, Accounts Receivables, Fixed Assets, General Ledger and Cash Management for supporting data extraction, filtering, and validation.
• Experienced in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Form Functions, Reports by using Application Object Library (AOL) and System Administrator.
• Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
• Imported data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database tables using SQL*loader.
• Involved in developing various SQL, PLSQL and UNIX shell scripts for conversion programs and interfaces based on the functional specifications provided.
• Enabled descriptive flex fields to store additional custom information to develop the reports in oracle applications.
• Involved in developing the RICE components. Worked on Interfaces, Data Conversions, developing and customizing Oracle Reports as per business requirements.
• Involved in migrating developed objects between instances. Developed custom shell scripts to create synonyms and grant necessary permissions for the objects, which are being migrated into new instances.
• Interacted with business/functional analysts to understand the requirements and implementing the logic followed by the documentation.

Environment: Oracle Applications R12.1.3 (AP, AR, GL, INV, OM, PO, CM), Oracle 10g, SQL,PL/SQL, Forms10g, Reports 10g, Workflow builder, SQL*Loader, TOAD and UNIX.