SUMMARY

• Over 10+ years of IT experience of ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing and Supporting Oracle Applications of Oracle E - business Suite. These include Analysis, Design, Development and Implementation of different projects for applications and in the field of Oracle e-business Suite.
• Experience in Oracle E-Business Suite/Oracle Applications with core expertise on GAP Analysis, Process Mapping, Defining Business Requirements, Implementation and Configuration
• Module implementation for Oracle E-Business for Financial Modules.
• Experience in Full Life Cycle Implementation projects which includes expertise from Requirement Gathering, GAP Analysis, Database & Application Design & Development, Implementation, Pilot Testing, Impact Analysis, User Training, Go-live & Production Support.
• Successfully implemented Global HR and Payroll, Absence management module
• Expertise in writing and modification of Fast formulas used in Oracle Payroll, Oracle Advanced Benefits and Oracle Time and Labor
• Experience in Oracle HCM (EBS/Fusion), including workflow and alerts; PL/SQL and Fusion Middleware Object Design, Development
• Develop and enhance JavaScript in APEX applications using either external JavaScript files or dynamic actions in APEX pages.
• Extensive experience in Oracle Application modules like General ledger(GL), Accounts Payables(AP), Accounts Receivables(AR), Advance Global Intercompany System (AGIS), Cash Management(CM), e-Business Tax and Vertex
• Hands on experience in supporting Oracle Application Modules Fixed Assets (FA), Purchasing Order (PO), Order Management (OM), Advance Collections.
• Excellent experience in Data loading into Oracle HCM Cloud using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data, and Salary info.
• Performed development, testing and integration of Oracle application objects (Oracle forms and reports) and Oracle database objects (tables and views).
• Proficient in server side configuration - Store Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
• Experience in Oracle Advanced Benefits (OAB) and Oracle Learning Management (OLM)
• Proficient in development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
• Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
• Skilled and experienced in UNIX Shell scripting and worked extensively on Unix/Solaris/Linux platforms.
• Proficiency in Oracle Application Implementation Methodology and Software Development Life Cycle (SDLC).
• Worked Extensively in Conversions and Interfaces in most of the Financial Modules. Extensive hands on experience using most of the API’s.
• Highly skilled in creating new XML Reports using XML Publisher and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications
• Worked on functional design for conversions of Jobs, Extra Information Types, Personal Payment Methods, Elements using Oracle seeded API’s..

TECHNICAL SKILLS

• Oracle E-Business Suite
• SQL and PL/SQL
• Tools like JDeveloper
• AME
• XML publisher
• OAF
• ADF
• SOA
• Informatica
• Workflow
• Power Builder
• SQL Navigator
• TOAD
• Crystal Reports
• Data Flow and Processing
• Oracle Discoverer
• Oracle Reports 6i
• BI
• SQL Server and MS-Office tools.
• Job Scheduling
• Programming Java
• C
• C
• Pro C
• HTML
• JSP
• UNIX and Shell Scripting

PROFESSIONAL EXPERIENCE

Sr. Oracle EBS Developer

Confidential, Oak Brook

Responsibilities:

• Worked on Oracle Applications Release 12.1.3/ R12. Responsible for the technical design, program development, unit testing and migration of AP Invoice Interface.
• Involved in design, development and testing of new and existing Interfaces using PL/SQL to interface non-oracle and Oracle systems to Oracle applications Modules, Install Base modules and PO. All the interfaces were registered and run through the concurrent manager.
• Customized Reports and Forms to meet user requirements mainly in financial modules (AP, GL, and AR).
• OBIEE, Hyperion financial Managemet, Hyperion reporting, managing server and database resources, Importing/ Exporting hierarchies and Setting up Validations and Verifications.
• Involved in creating new XML Reports using XML Publisher and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Oracle Fixed Assets (FA) module - General Ledger entry processing, Journal entries, asset set up, year end process and global updates.
• Oracle RAC 10g Installation, RAC performance tuning and Connection Load balancing in RAC .
• Customize/ Maintain Oracle Application Framework (OAF) Application.
• Write custom components in OAF and OAF extension using Forms Personalization and extending controller.
• Deploying BPEL Processes, maintaining, diagnosing, and resolving issues, Oracle BPEL process manager.
• Used Oracle Directory Service Manager to integrate OID with Oracle Enterprise Manager to centrally manage and monitor all services, including Oracle Fusion Middleware, Oracle Databases, and Oracle Applications.
• Development of Oracle Applications based standard APIs and Interfaces to legacy systems, customizations of Interfaces, Development of reports and forms using Oracle Developer 2000 kit. SQL and PL/SQL based coding.
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Write extensive PL/SQL procedures, functions, packages, cursors.
• Created validation procedures to execute along with customer interface and vendor programs to support the interface requirements
• Created triggers for transaction adjustment, Auto Adjustment, defined Vendors, Invoices, Tracking of payments, Prepayments.
• Integrated Legacy purchase order Information with Oracle Payables Interface.

Sr. Oracle EBS Applications Developer

Confidential, Burbank

Responsibilities:

• Worked on configuration and customization various oracle modules for multi-phase implementation
• Developed SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.
• Conversion and reconciliation of Legacy AP Invoices and Payments into Oracle Applications.
• Designed and developed Payables interface import program and interface tables to load invoices from the legacy systems into the oracle payables base tables.
• Build Customsecurityto Cloud HCM like creating /modifyingdata roles, job rolesandsecurity profiles.
• Search Fields customizations using OAF and Java programs, XML, Self-Service extensions to control access to TMA in iRecruitment.
• Designed Functional specifications for extensions and customizations for irecruitment, and Performance Management
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Performed maintenance on existing HCM configurations and worked with the users and define standards on using Descriptive Flex fields from reporting and integration perspective.
• Developed multiple HCM Extracts for outbound interfaces to integrate with other systems and designed some extracts for Payroll Interface
• Testing and debugging Oracle Internals, Architecture and Performance issues.
• Setup client/server connections for developers, create databases, table spaces for different application schemas; enroll users, and setup auditing.
• Write scripts to create tables, indexes, views, aliases and synonyms to meet developer requests
• Managed REST service lifecycle activities including searching and deploying your desired APIs as REST services, viewing deployed services through WADL descriptions.
• Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.
• Customized Invoice Register Report by appending additional columns like invoice terms, supplier site promotions cost and descriptive flex field information.
• Developed Reconciliation Report using XML Publisher (BI Reports) Reporting Tool.
• Developed a new report to get users who have Purchase order and requisition open and are out of the company.

Oracle EBS Developer

Confidential, Pittsburgh

Responsibilities:

• Worked on Oracle E-Business Suite R12 implementation which includes Core HR, Oracle Payroll, Oracle Time and Labor and Oracle Advance Benefit modules.
• Assist Functional team in Business Requirement Specification (BR100) for HR and Payroll.
• Designed legacy data conversion strategy for HR, Payroll, OAB and OTL modules and performed lead rule for configration
• Involved in business requirements finalization process, assisted fuctional team lead in design, gap assessment, and process redesign sessions.
• Performed OTL setup by defining Approval rules, Hours types, Time entry rules, Approval styles and Setting up the Preferences.
• Configured mapping of timecards elements of OTL with Oracle Payroll earnings for Multi-Payroll environments.
• Implementation of OLM requirements and customizations
• Developed functional specification and performing actual conversions from legacy system to Oracle applications.
• Created File Based Loader & OTBI reports with HCM Extracts integration in HCM Cloud.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Analyzed and mapped legacy balances with Oracle payroll elements and prepared technical specification for Payroll Balance Upload.
• Created new elements with compliance to FLSA, PTO plans and fast formulas were created.
• Designed Spec. for month-end Benefit Balance validate and update to Oracle payroll, developed programs to upload time from contingent worker time system to OTL which includes time and project attributes for OTL module.
• Designed various inbound interfaces (person import, Email import, Absence import Encryption SSN and IRC autohire import) and outbound interfaces Was responsible in defining Advanced Benefits, Eligibility Factors, Eligibility Profiles, Programs, Plan types, Plans and Options, Enrollment Requirements, Flex credits, Benefit Pools, and Standard Rate Calculation.
• Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types for HRMS module and maping of Costing fileds with Oracle finantial.
• Worked on Catalogue security and managing enrollments in oracle Learning Management.
• Modified the seeded HR workflow processes as per the their needs for Oracle Self Service and Payroll.
• Was involved in Unit testing, System Testing and in phase of UAT across multiple environments.

Oracle Technical Developer

Confidential, Deerfield

Responsibilities:

• Designed and Developed custom programs like API's, Mapping Procedures and gateway programs using PL/SQL for General Ledger GL . Extensively used Discoverer to build GL reports.
• Actively supported in resolving production related issues with Business Users. Collected the user requirements, converted into functional and technical specifications.
• Actively supported month-end activities and Financial reporting
• Ensure that the application meets the business requirements and system goals fulfill end user requirements, and to identify and resolve system issues.
• Customized standard reports such as AR Customer Invoice Report, Pack Slip Report and Purchase Order Report.
• Designed and developed custom forms for GL Interface Gateway.
• Worked on payables interface which picks the Data from the Custom screen (OAF screen where user enters the data after the goods are received) and after validating the data is populated in the Interface table and error are displayed in the Log Output File.
• Setup customization of Incentive compensation, compensation policies, compensation structure, Modeling Contract Agreements in Oracle
• Development of Custom Interfaces to interface employee data from PeopleSoft to Oracle EBS.
• Created PL/SQL procedures, functions, triggers as needed. Developed complex technical changes in PL/SQL and SQL queries.
• Designed and Developed customer invoice interface program to load the customers from IBK to Oracle Receivables AR . Performed tuning for various PL/SQL scripts.
• Loading the AP, GL spread sheets data into APPS using web ADI.
• Experience in fixing the issues using PL/SQL, performance tuning and enhancements with the ability to support environment processing large volumes of data required in financial systems.