SUMMARY:

• 9+ years of experience in Information technology. Possessing experience in Development, Customization and implementation of Oracle Applications (E - Business Suite) in Oracle Financials and Manufacturing and SCM modules.
• 1+ year of experience in Oracle Fusion HCM (Human Capital Management) cloud. Involved In implementation and support of HCM cloud projects.
• Experience in General Ledger (GL), Accounts Payables (AP), Account Receivables (AR), Purchasing (PO), Cash Management (CM), Fixed Assets (FA), Inventory (INV), Work in Process (WIP), Bill Of Materials (BOM), Oracle Process Manufacturing (OPM) and Order Management (OM) .
• Good knowledge in AIM (Application Implementation Methodology). Creating technical docs such as MD70 and MD120.
• Experience in development of Packages, Procedures, Functions and Database Triggers using PL/SQL.
• Strong understanding and working knowledge on Order to Cash and Procure to Pay Cycles.
• Developed and customized RICE components like Reports, Interfaces, Conversions and Extensions.
• Good experience in SQL, PL/SQL, Forms & Reports, Interfaces and APIs.
• Good Experience in working on Data Conversions.
• Development of workflows using Oracle Work Flow Builder. Developed several conversions from legacy systems to Oracle Applications and within several modules in Oracle applications.
• Expertise in technical skills such as registration of Custom built tables, Forms and Reports following application hierarchy. Very good knowledge in Oracle Application SYSADMIN.
• Very Strong experience in OAF Personalization’s and familiar with multiple way of migration of both OAF pages and OAF personalization’s into oracle Applications and registering the pages in oracle applications.
• Very good experience in customizing existing OAF Screens , Forms and Reports as per business needs using OAF Substitutions , custom PLL s, Form Personalization respectively.
• Working knowledge in using Oracle Discoverer Administrator and Worksheets development using Discoverer Desktop and Discoverer Plus Components.
• Strong Hands-on experience in Oracle ERP Applications, SQL, PL/SQL, Oracle Report Builder 6i, 10G, XML(BI) Publisher, SQL*Plus, SQL*LOADER, UNIX Shell Scripting and FTP.
• Experience in Application System Administration activities like defining responsibilities, Value sets, Flex fields, Reports, Managing Concurrent Programs, Providing Support to Apps End Users.
• Expertise on Data Conversion and Data Integration from Legacy Systems or External Systems into Oracle Applications using Oracle open Interfaces and Oracle Public API’s.
• Well versed with Unix Shell Scripting and Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Experience in Data loading into Oracle HCM Cloud using tools like Spreadsheet Loader, HCM Data Loader (HDL) Tool which includes the Workforce structure data, Worker data, Contacts data, Work relationships data, Payroll data and Salary info.
• Expertise in resolving HCM Data Loader issues and have good understanding on HDL errors.
• Experience creating reports using subject areas in Oracle HCM Cloud BI.
• Extensive experience in developing and customizing Reports using XML/BI Publisher with xml data template and Oracle Reports data template.
• Tuning of customized application including reports and backend customization by using different application tuning techniques like EXPLAIN PLAN, SQL*TRACE, TKPROF, HINTS, DBMS PROFILER etc.
• Possess strong technical skills and business knowledge coupled with product knowledge in Oracle E-Business Suite.
• Interact with people at all levels and also have Onshore/Offshore Co-ordination. Possess excellent communication and problem solving skills, and work ethics.
• Proven characteristics of being highly motivated. Strong problem-solving skills and analytical skills. Self-starter and ability to work independently without any supervision.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications 11i, R12 Modules Purchasing (PO), Accounts Payable(AP), Account Receivable(AR), General Ledger(GL), Order Management(OM), Inventory Management(INV), AOL, Work in Progress(WIP), Fixed Assets (FA), Cash Management (CM), HRMS, HCM

Languages: SQL, PL/SQL, C, C++, Unix, SOA/BPEL

Databases: Oracle 11g/10g/9i

Software Tools: Toad, SQL*Loader, SQL Developer, Putty, WinScp, PVCS, Note Pad++

GUI Tools: Oracle Reports 10g/9i, XML(BI) Publisher, Discoverer 10g, Workflow Builder

Operating Systems: Windows, Unix, Linux

AIM:, MD070, MD050, MD0120, CV060, BR100, Reconciliation Tool kit Document.

Bachelor of Engineering: from OSMANIA UNIVERSITY, INDIA - 2009

PROFESSIONAL EXPERIENCE:

Confidential, Strongsville, OH

Sr. Oracle Applications Techno Functional

Responsibilities:

• Gather requirements for customization and developing RICEW components.
• Production Support: analyzing and providing work-arounds for Sev1 tickets as well as debugging, fixing and testing the issues related to AP, AR, GL, FA and PO modules and migrating the code fix to Production as necessary.
• Banking Conversion Project:
• Coordinated with business partners and the bank to customize AR ACH File generation process.
• Based on the Profile class, logical segregation was provided within the same file which helped create a separate ACH file to Huntington bank for customers of profile classes.
• Customer Conversion:
• Involved in Customer Conversions to load Customer data (0.5M records) from Legacy systems into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.
• Fixed several issues in custom AR Customer Interface and Invoice Import interface with CMS system - ACH job issues, CMS Customer interface loading issues.
• HCM:
• Worked on Core HR, Payroll modules.
• Developed HCM Extracts to extract the data from Oracle Cloud systems and send to OneStream application
• Development and customization of Oracle Business Intelligence reports as per the requirement. Developed new BI reports to extract the absence details and related other reports.
• Designed and developed an alternate Payroll Process - end-date, create different payment methods - using HDL (HCL Data Loader), Spreadsheet Batch Loader etc.
• Data Loading/Conversions using HCM Data loader (HDL), Spreadsheet loader which includes the Worker data, Salary info, Payroll Direct Deposit data etc.
• PO Requisition Workflow:
• Customized approver hierarchy; added custom lookup to accommodate exemptions in custom approval flow, employees representing two cost centers etc.
• Modified the Requisition Import Program to group the items and generate the Requisition number.
• Customized the Purchase Order Document to dynamically change the fields and notes based on the Item Type and Warehouse/Location.
• Developed the Purchase Order Creation and Receiving Programs.
• Personalized PO entry form to disable Changing PO price for few responsibilities.
• Working on custom OAF form for correction of receipts.
• Worked on form personalization:
• On invoice Workbench and Shipment matching screen to control Invoice and PO matching as per the user requirement;
• Resolved issue where Credit memo impacting quantity-based POs using from personalization;
• Default certain fields on Account Details form etc.
• Tuning of custom GL Details Transaction queries; preparing budget reports.
• Resolved production issues with partial retirement of assets in Fixed Assets.
• Coordinating with Oracle, and internal DBA team for SRs, new product releases, upgrades/patches/fixes, Workflow mailer configurations, setups etc.

Environment: Oracle R12.2.4, Oracle 11.2g DB, PL/SQL, Oracle Cloud Application19B (11.13.19.04.0 ), JDeveloper 11.1.1.9, Form Builder, Workflow builder 2.6.3.5, BI/XML Publisher, UNIX and Windows, OAF, Financials - AP, AR, GL, FA and Cash Management(CM).

Confidential, Arlington, VA

Sr. Oracle Applications Techno Functional

Responsibilities:

• Developed high level technical design and Functional design documents for Inbound and Outbound transactions
• Requirement Gatherings, Data Fixing, Reports & Forms Development, UAT and Production Implementations, documentation.
• Extensively worked on conversions into Oracle AP, AR, GL Balances import, PO by mapping the data, writing oracle stored procedures, packages and oracle seeded packages. Has developed interfaces for transferring data from legacy to Oracle Apps.
• The interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for EDI Vendors', 'Outbound interface for EFL Customers' etc
• Handled conversion stages for Inventory, Bills of Material and Purchasing modules. Designed dataload scripts for manual conversions
• Converted the entire Historical Purchase Orders using import standard Purchase Orders into Confidential Production
• Converted the entire Historical Purchase Order Receipts using Receiving Transaction Processor into Confidential Production
• Converted the entire Historical Invoices using Payable Open Interface Import into Confidential Production
• Wrote an API for converting the Invoice payments and was able to convert all Historical Invoice Payment History into Confidential Production
• Created Custom reports as per client requirement across the modules Global HR, Compensation, Goal and performance management.
• Created HCM extracts for Fusion to EBS integration for person details, Contacts, Phone numbers.
• Created HCM extracts for Third party system interfaces and updated fields status after extracting data by integration HDL with Extract
• Created staging tables required for loading the legacy data and loading the staging tables with the legacy data using SQL Loader
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from Legacy system, validating data using PL/SQL API and then loading the data into Vendor Information base tables.
• Modified the Create PO Document and PO Approval workflows as per the user requirements
• Developed a custom program to update the specific Purchase Orders and PO Requisitions as soon as the Sales Order is updated.
• Developed the Purchase Order Creation and Receiving Programs.
• Developed a custom interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
• Personalized OAF pages in Order Management, implemented PPR, Substituted/extended the seeded regions, COs & VOs.
• Developed OAF extension in iExpenses to default distribution template while entering expenses.
• Worked on rounding customizations of dollar amount in iExpense using OAF. This involves customizing and extending controller CO and entity object EO
• Develop Custom Components using OAF platform.
• Worked on OAF customization to encrypt the TIN/SSN which is entered/updated on the supplier web page.
• Developed and Updated several SCM and Finance Reports: Print Requisitions Report, Print Purchase Order - Jordan, Print Purchase Order, AR Aging Report, AR Invoice Print Report etc. in BI publisher.
• Developed shell script to send the log/output file of a concurrent program through mail.
• Created Service Requests & worked with Oracle Support for Application issues in Finance and SCM modules.

Environment: Oracle R12.2.4, Oracle 11g DB, Oracle Cloud 18C, PL/SQL, JDeveloper 10.1.3.5.0 , OBIEE & Report Builder 10.1.2, Form Builder, SQL*Loader, BI/XML Publisher, UNIX and Windows, OAF, ASCP, Financials, Projects, PO, INV, OM.

Confidential, Durham, NC

Oracle Applications Senior Developer

Responsibilities:

• Analyzed the user requirements, work with Functional & other Technical team members to design the solutions, implement the solution to improve the business process and expand the system’s capability.
• Created several tables, advanced queues, object types, packages, GRC flow rules, subscriptions, concurrent programs, values sets, lookups, profile options, functions, menus, DFFs etc.
• Created new GRC flow rules that get invoked with changes in inventory master data and inventory transactions, and call the custom API that pushes the data to advanced queues (AQ) as payload, from which middleware consumes this data and passes to third party systems in B2MML format.
• Developed custom API to extract TCA party information and integrate with Fusion Middleware. Worked on Business Events to invoke this interface.
• ERP Enhancements - as part of process improvements in SCM and ASCP modules, worked on various technical changes in the system to accommodate the gaps in multiple business work streams.
• Created XML/BI publisher reports for Exception handling of several custom interfaces and forms in PO, OM, INV, QA and OPM modules.
• Developed/updated various custom interfaces, forms and reports based on the provided Business requirements.
• Designed and Built a custom Application Framework (OAF) page to generate Lot genealogy for specific lot entered and Regulatory country approvals for Finished Good item entered.
• Extensively worked on PCG (GRC Control) rules to personalize/customize forms in OPM modules such as Batch Details form, Item Reservations form and Material Transactions form.
• Modified, enhanced and added additional validations for custom wrapper APIs in integrations such as Delivery Confirmation Inbound, IR Receipt Inbound, Order Inbound interfaces etc.
• Created/updated Alerts, Concurrent programs, Shell script, packages, procedures, triggers, types, tables, advanced queues for different business needs.
• Did form personalization on some forms in QA module.
• Work with business users on production issues to debug and recreate steps to reproduce issues then rewrite code as needed.
• Prepared various Technical Design documents & migration documents to comply with the Regulatory and SOX standards.

Environment: Oracle applications 12.2.4, PL/SQL, JDeveloper 10.1.3.5.0 , Forms 10.1.2, Report Builder 10.1.2, SQL*Loader, UNIX and Windows, OAF, Shipping, OPM, ASCP, OM, INV, QA, PO.

Confidential, Hanover, MD

Oracle Applications Senior Developer

Responsibilities:

• Development of ‘Carrier Integration’ customization in shipping module with 3 major carriers FedEx, UPS and Expeditors for the shipping of Ciena manufactured products.
• Created several custom tables, views, synonyms, triggers and indexes at custom packing working bench level.
• Developed interface with FedEx, UPS and Expeditors shipping Carriers for the shipping data.
• Created views that are specific for each carrier to pick trip/delivery data that is needed. And created custom tables where the carriers send the signal/use their tools to update with tracking details/Waybill number etc.
• Developed Concurrent programs, PL/SQL Packages to validate and extract shipping data from EBS to Carrier Tables, to update carrier tables and EBS tables with carrier updates and to send signals and update shipping status to OTM.
• Developed a Package to copy data from Carrier Tables to base tables after carrier updates and set RFS Flag in EBS at delivery level in base tables.
• Built custom reports using Oracle XML Publisher and registered them in Oracle Apps in AP, AR, PO and Shipping modules.
• Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances.
• Designed and Developed various new Descriptive Flexfields (DFF) for Standard Oracle R12 Applications Modules.
• Created CUSTOM JAVA TOP on server for customized OAF pages.
• Created new OAF pages which includes custom simple search, advanced search, PPR (partial page rendering) select option, committing data through EO (Entity Objects).
• Developed new pages from scratch- Custom page, Customization of existing pages - custom page, Personalization of OAF page- Seeded pages (GUI changes), Extension of OAF pages - Seeded pages.
• Involved in the Pre and Post upgrade activities.
• Responsible for new development and change requests.

Environment: Oracle applications 12.2.4, PL/SQL, Forms, SQL*Loader, UNIX and Windows, OAF, Shipping

Confidential, Branchburg, NJ

Oracle Applications Senior Developer

Responsibilities:

• Working on Archival of Oracle Applications (Financial, Purchasing, OM, INV, iExpense and iProcurement modules) of ‘Cubist Pharmaceuticals’ which has been acquired by ‘ Confidential & Co’ recently. The core role is the validation and archival of Cubist data and to be in touch with administrators and users to help them to retrieve necessary data, and to resolve server and application related issues.
• Involved in the preparation & planning of incident, risk and change management procedural documentation for clients.
• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables of ‘ Confidential & Co’ database (using both UTL and SQL Loader - for different cases).
• Developed PL/SQL scripts for validating the data and Storing the data into Confidential ’s MTL SYSTEM ITEMS INTERFACE and then populating the base tables by running the ITEM IMPORT Interface.
• Involved in importing Sales order data into Oracle Application base tables. Wrote PL/SQL procedure to validate data and load into interface tables and using order import inserted orders into the base tables of ‘ Confidential & Co’.
• Developed UNIX Shell scripts to run the interface program and to archive the data.
• Supplier and Global Supplier Sites Conversion: Involved in Analysis, Data Mapping and Client Interaction for supplier conversion. Also involved in creating all the supplier sites (once converted to respective operating units) to Global Operating Unit as per the client requirement.
• Worked on XML pages, java classes and OA pages along with BC4J components for validation and updated records based on the validation check such as supplier information.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).
• Used Auto Invoice Interface to import Standard Invoices into Oracle Receivables using a control file, PL/SQL Packages/Procedures and Auto Invoice Import program.
• Customized AR account status Report, and AP Trial Balance report using Report tool.
• Modified and updated existing custom forms to adapt to new database schema.
• Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps. Registered the form and migrated.fmx executable file to $AU TOP on forms server of client.
• Explain Plan, TKPROF was used for checking and enhancing the performance of queries.
• Involved in creation and updates of several PL/SQL packages and Procedures.
• Extensively used the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Analyzing Linux and Windows servers of ‘Cubist Pharmaceuticals’ with Business users and decommissioning the servers that are not in use.
• Understanding and Troubleshooting complex customer issues on production environment. Responsible for identifying any bugs occurring in the applications as well as fixing them.
• Analysis of customer reported issues, which could be a code issue, data fix issue, performance issue.
• Responsible for daily and incidental issues involving fixing failures of feeder systems and outbound data failure fixes. Logging Service Requests (SR) on metalink.

Environment: Oracle Applications 12.1.3, Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, SQL*Loader and UNIX, Windows.

Confidential, El Segundo, CA

Sr. Oracle Apps Techno Functional Consultant

Responsibilities:

• Designed and developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures, and Packages.
• Developed a customized interface “ Adaptive Interface ” program to validate invoices and payment details from legacy systems like ICE, IBM Gers and upload to Oracle Interface .
• Implemented AP Invoice import through Payables Open Interface Import Program.
• Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and BI/XML in AP, AR and PO.
• Integration of Purchase Order module in the new organization by migrating all the PO setups and data from other organization.
• Loaded the vendor’s information from legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Worked on Oracle Application Framework (OAF) to develop custom solutions for iExpense and iProcurement module. Development involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
• Worked on integrating newly created PG files with the existing PG files with handling back button and popup window option.
• Develop PL/SQL program that extracts and generates a flat file from Oracle GL to send to IBM Cognos TM1 applications which is used for budgeting and forecasting.
• Created an Oracle Alert that triggers whenever a new responsibility is added or there is a change in existing responsibility for the user accounts.
• Implemented HCL’s ToscanaLite workflow. Developed and scheduled a concurrent program to send ‘Daily Paid Invoices’ data on daily basis, and also created a trigger to update the vendor data on real time basis to the Toscana DB through a DB link between the two databases.
• Developed SQL scripts to provide GL data to BDO organization for audit purpose.
• Development of an inbound interface to load receivables data from a flat file sent by legacy system MSG into Oracle.
• Integrate OAF page with third party tool for Address Validation
• Customized existing custom oracle reports to replace plain text output to PDF format using XML/BI Publisher.
• Registered the new XML/BI Publisher report as concurrent program.
• In XML/BI Publisher, created a Data Definition with XML data.
• Used Microsoft Word to create an RTF template with all the required data fields and registered the formatted template in XML/BI Publishers Template Definition.
• Worked on AP XML Check template as per the business requirements.
• Worked on UTL PACKAGE and SQL*LOADER for the interfaces and conversions.
• Developed SQL*Loader control programs and PL/SQL validation procedures to load legacy GL Code Combinations into Oracle General Ledger GL.
• Created new dimensions and cubes in TM1 applications and used TurboIntegrator (TI) Processes to load and retrieve data from database tables and other data sources.
• Uploaded data into AP and GL through Web ADI and trained functional team on the same.
• Created temporary Views, Subsets using Turbo Integrator and populated data for Actuals.
• Performed system administration functions such as creation of users, creation of responsibilities, defining value sets, creation of concurrent programs and executables, registering applications.

Environment: Oracle Applications 12.1.2 (AP, AR, GL, FA, CM, PO modules), Oracle 10g, PL/SQL, SQL, Forms, Reports, Workflow Builder 2.6.3.5, SQL*Loader, Putty, FileZilla and UNIX.

Confidential, Ramsey, NJ

Sr. Oracle Apps Techno Functional Consultant

• Actively participated in requirement gathering of various reports and creating Technical specification documents.
• Designed and Developed functional and technical documentation (MD50, MD70, MD120) using AIM Methodology.
• Imported AR Invoices from legacy system into applications using SQL*Loader script, Import Sources and AR Interface tables.
• Designed and developed report in BI Publisher to display Purchase order details like order number and total amount along with corresponding currency conversions for each country the company deals with.
• Created various PL/SQL procedures for generating various reports by populating custom tables, including Accrual Report, Customer Transaction Report, Center Report and Cost Center Reports.
• Created Business Areas, Custom Folders and Item Classes in Discoverer Administrator and built complex work sheets in Discoverer Plus.
• Customized the Standard AP CHECK Print Report as per client specific requirement.
• Worked on resolving the Trial Balance Reconciliation issues in AP module during Month end. Applied various Global Data fixes and analyzed their technical impact before migrating to production.
• Developed ADI templates and used ADI spreadsheets to upload invoices into AP.
• Developed PLSQL program and registered as concurrent program for generating Inactive Customers program based on transactions in the past 5 Years.
• Created various reports using XML Publisher including Custom Customer Invoices Register, Customer AR Statement, AR Invoice’s Report etc.,
• Developed SQL Loader Program for loading data files from flat-files in custom tables and created various custom interface packages to validate and populate values into custom tables used for reporting purposes.
• Created the Inactive Customers report.
• Customized the aging bucket report using XML Publisher. Created Complex Matrix reports in XML/BI Publisher.
• Converted various Standard 6i reports to XML/BI publisher reports.
• Automated the process of migrating Data Definitions and Templates from Instance to Instance.
• Used Template, sub Template method for a creating single report with multiple Layouts.
• Created PDF/EXCEL/Word output’s for reports based on requirements.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Worked with the bursting team to successfully send report outputs to customer’s printer, fax and email.
• Worked closely with Oracle Product Development team to resolves issues in BI publisher.
• Designed and developed extraction programs, which would populate base table information into custom tables from O2C (Order to Cash) and P2P (Procure to Pay) modules.
• Worked with performance tuning tools like Explain Plan and TKPROF to improve the performance of various custom PL/SQL Packages developed.
• Created various SRs in different levels working in close proximity with Oracle support group for resolving various bugs.

Environment: Oracle Application 12.1.3 GL, PO, AP, AR, PA, Oracle 9i, Reports 10g, Forms 10g, Discoverer 10g,Oracle SOA/BPEL, PL/SQL, SQL *PLUS, SQL*Loader, SQL Developer, Windows, XML Publisher 5.6.3, Work flow Builder 2.6.3.5, Linux x86.