SUMMARY

• Around 8 years of Experience in Information Technology with good expertise in Oracle Applications including Implementing, Testing, Developing, and Customizing of Oracle Financial and SCM modules - Accounts Payables (AP), Accounts Receivables (AR), General Ledger (GL), Fixed Assets (FA) and Oracle Purchasing (PO), Order Management (OM), Oracle Process Manufacturing (OPM), Oracle Projects, Cash Management, Shipping, Inventory (INV), Advanced Pricing and Advanced Collections.
• Extensive experience in implementation, support, upgrade and enhancements of Oracle Applications versions 11i/R12.
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project requirement study, Project planning, High-level design, Low-level design, Coding, Implementation, Testing and Quality Assurance Documentation.
• Experience in Application Object Library (AOL) for registration of concurrent programs, Request Sets, Interfaces, Forms, Reports, Value Sets, Profiles, Custom Menus and responsibilities etc.,
• Extensive experience in design, development, customization and implementation of various business applications in different platforms using Client-Server Technologies.
• Extensive experience in PL/SQL Oracle database and RDBMS Concepts Procedures, Functions, Packages and Database Triggers.
• Hands on experience in designing, developing and testing various RICEW (OracleReports, Forms, Interfaces, Conversions, Extensions and Workflows) components, OracleAlerts and Lookups as per Oracle standards.
• Expert knowledge in Oracle core financial modules and many years of exposures to O2C and P2P tracks in multi-org corporate environments.
• Extensive working experience in Reports development using XML Publisher, Oracle Discoverer, Oracle Reports, EIS Reporting, OBIEE and Hyperion Reporting.
• Good understanding of Data Conversion and Data Migration process including vast expertise in Global implementations and working with large group of business users and Onsite & Offshore model projects.
• Proficient in using Multiple Reporting Currencies (MRC) and Multi Org feature and implemented them in interfaces, Oracle reports and custom processes.
• Experience in various development tools like SQL Developer, SQL*Loader, TOAD, FileZilla, WINSCP, PUTTY.
• Good Exposure to Oracle Application Framework (OAF) and OracleApplication implementation methodology (AIM) and expertise in creating inbound and outbound feeds, creation of automated processes using Application Program Interfaces (API).
• Hands on experience in design and development in Extraction, Transformation & Loading (ETL) of data from multiple sources (oracle, flat file and ftp) using oracle pl/sql, sql loader, sql plus, UTL File package.
• Experienced in Requirements gathering, GAP analysis, documentation, application technical design, and unit testing of custom module components.
• Developed, customized and personalized Oracle Forms using Form Builder, and CUSTOM.PLL.
• Worked with UNIX shell scripting to automate the execution of the batch processes.
• Effectively made use of Materialized Views, Query Re-Write and Transportable table spaces, Ref Cursor, External Tables and Collections and Exception handling.
• Expertise in design and development of Interface/Conversion programs to import data from legacy systems and integrate it into OracleApplications using open interfaces and APIs, and worked on Interface/Conversions like GL Interface, Custom Invoice Interface.
• Experience in the preparation of FunctionalDesign Specification Documentation, Technical Specification documents and System Test scripts for Extensions including: Data Conversion/Migrations, Inbound/Outbound interfaces, Reports, Forms and workflows.Utilized AIM Methodology and/or Oracle Unified Methodology as per client requirement.
• Worked with Oraclesupport team Metalink to aid in resolving application problems and solutions.
• 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.
• Ability to work under pressure, meet deadlines and work extra hours when needed.

TECHNICAL SKILLS

Oracle Applications: E-Business Suite - Oracle R12 (12.2.4/12.1.3 ) Oracle 11i (11.0.3/11.5.3/11.5.8/11.5.9/11.5.10 ) Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Fixed Assets (FA), Order Management (OM), Inventory (INV), Oracle Purchasing (PO), Oracle Project Costing, Advanced Pricing, Quoting, Pricing Agreement.

Languages: SQL, PL/SQL, JAVA, UNIX

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

GUI Tools: Oracle Reports 10g/9i/6i, Oracle Forms 10g/9i/6i, XML(BI) Publisher, Workflow Builder, Discoverer Administrator, Desktop, Plus and Viewer 4i/10g

Operating Systems: UNIX, Windows 8/7/XE, AIX, Sun Solaris, Oracle Linux.

Databases Tools: Oracle 12c,11g,10g,9i,8i, MS Access

Version Control Software: PVCS, Rational Clear Case, Visual Source Safe (VSS)

Ticketing Systems: HEAT, HP Service Center, JIRA, WEBSERVE, SMILE

Other Tools: Microsoft Office, Projects, MS Access, Erwin, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

Oracle EBS Analyst/Developer

Responsibilities:

• Designed and authored various Functional Design Documents (FSD) and Technical Design Documents (TDD) that would help any person in understanding the end-to-end design based on the Business Requirement Document.
• 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.
• Developed PL/SQL Packages required for implementation of all the AP inbound interfaces using oracle standard API calls. During the process, developed validation procedures, error handling and debug logic as per the client’s complex design specifications.
• Created staging tables required for loading the legacy data using SQL loader. Developed interface programs to load data from custom tables to interface tables and imported in to Oracle Application using Standard Open Interface Import Programs.
• 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 a business logic on Supplier end date.
• Supported the team with post production issues. Acted as a maintenance support for guiding the users understanding the new system and solve daily problems.
• Interacted extensively with Users for the TO-BE Process and documented the complete end-to-end processes for GL and AP modules for validation and approval.
• Defined test cases with QA team and coordinated user participation in final testing phases for all inbound interfaces.
• Also tested Oracle upgrade instance by identifying issues, supporting business functionality & resolving issues by working in close proximity with business users and Oracle Support.
• Designed the functional spec for the Auto Invoice Interface to import Customer Invoices, Credit & Debit Memos in AR by incorporating business mapping rules and validations.
• Involved and provided production support on Oracle Accounts Payable (AP), Accounts Receivables (AR), Purchasing (PO), Fixed Assets (FA) and General Ledger (GL) modules.
• Co-ordinated with offshore technical team for getting code fix, reports, and interfaces developed by providing test cases and functional specs as part of Conversion.
• Involved in analyzing, designing and developing the various RICE components. Worked extensively on Interfaces, Data Conversions, developing and customizing Oracle Reports as per business requirements.
• Conducted weekly and bi-weekly meetings to track and share progress on IT Enhancements (Change Requests) and defects.
• Interacted effectively with users, developers and peers to ensure the successful delivery and implementation of the solution.

Environment: Oracle Applications R12.1.3 (AP, AR, GL, PO, FA and FAH), Oracle 10g, SQL,PL/SQL, Forms10g, Reports10g, Workflow builder, WINSCP, SQL*Loader, TOAD and UNIX.

Confidential, Milpitas, CA

Oracle Apps Techno-Functional Developer

Responsibilities:

• Proficient in preparation of theFunctionalDesign Documents MD50, Technical Design Documents MD70 and Unit Testing Documents TE020.
• Worked on an enhancement project in Oracle R12 (12.1.3) on OracleReports andOracleWorkflows for modifying/extending existing functionality of components as per business needs.
• Worked on OE workflow change for specific Line Type to modify and to stop AR invoice interface.
• Effectively worked on various Form Personalization’s under PO and OM modules to accomplish specific business validations.
• Provided various data fixes for Blanket PO’s and Unposted Assets according to clients requirement.
• 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.
• Took part in implementing Integrated End-to-End Oracle solution, which enabled using an integrated platform. The new process provided opportunities to increase automation, increase transparency & collaboration, data integrity, and optimization (manual process reduction).
• Created additional processes in the Projects workflow as a part of CAPEX Project to send workflow notifications for approval to the functional and finance users in hierarchical way.
• Worked on fixing issues withOracleReports, PL SQL interfaces Customizations, Forms and Workflows.Customized the existing interfaces and import programs for Order Import, PO and Requisition Import.
• Developed few custom workflows from scratch for the custom logics to meet the client requirements to send the reminder and escalation notifications to the pending approval notifications.
• 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.
• Experience in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Lookups, Flex Fields, Value Sets, Form Functions, Reports by using Application Object Library (AOL) and System Administrator.
• Created logical and physical database objects like tables, views, synonyms, indexes and triggers to meet development needs.
• Extensively worked inOracleBack-end PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers using TOAD and SQL Developer as development tools.
• Guiding an offshore team for technical andfunctionalassistance from client location.
• Developed UNIX Shell Scripts for uploading/downloading files from the server and for moving objects between instances using FNDLOAD scripts.
• Developed various Custom reports, Customized existing reports according to thefunctional specifications using Reports 10g and XML publisher.
• Work on the development activities as part of issue resolution. Performed UnitTesting, migrated to next environments, assisted users, resolved critical issues and closed tickets.
• Developed queries to meet the requirements as perfunctionalspecification, prepared the test cases, and made sure we got the sign off for all the reports.
• 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 given warranty support for two months until the project stabilized.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.

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

Confidential, Naperville, IL

Oracle Techno-Functional Developer

Responsibilities:

• Authored Technical Design documents (MD070), Unit Testing Documents (TE020) and Installation Document (MD120) for all the customizations and enhancements.
• Designed new business logic, which triggers an email notification to investigate whenever the inbound file /outbound file, is missing for a particular utility as per the existing schedules.
• Worked on various Form Personalization’s in AP, AR and OM modules to add/block few fields at different levels.
• 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 Various Purchasing reports. Generated new reports as well as converted existingOraclereports to XML, by creating RTF templates using Template Builder.
• Worked ondata fixesfor invoice holds pending in the background in Accounts Payables (AP) and wrote API’s to release the holds.
• Experience in customizing Oracle workflows such as the PO Approval process, Order/Line Flow to send user notifications based on the business requirement.
• Tuned the code in custom utility business logics to stop the credit on invoices from being credited and extracted the output files at the time the code change goes in to correct the accounts that have credited incorrectly.
• Upon change requests, simplified the options on third party screens, which increased the capture of customer details by phone representatives.
• Experienced in creating Concurrent Programs, Request sets, Flex fields, lookups, Profiles, Value sets, User setup and defining responsibilities through Application Administrator responsibility.
• Worked on customizing the Lockbox interface for Account Receivables (AR).
• Used CUSTOM.pll to customize the standard oracle Forms.
• Extensively interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Worked on various data repair change requests to move the specific list of Inventory items from one sub inventory to another sub inventory.
• Participated in technical design enhancement discussion, documented the requirements and finalized the approach of development of RICEW objects.
• Worked on tuning the custom packages for better performance, troubleshooting, debugging and 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.
• Fix the emergency issues occur during month end. Project the issue and get approvals from managers, migrate and close the issue before month end close.
• Resolved number of service requests from business by extracting the data requested.
• Mainly worked on Oracle EBS Production issues related to AP, AR, GL, FA, INV, OM, and PO.
• Schedule meetings and assisting the business on time.Make business user friendly with theoracleERP application.
• Analyzes the feasibility and develops requirements for new systems and enhancements to existing systems, ensures the system design fits the needs of the client.

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

Confidential, Tulsa, OK

Oracle Techno-Functional Developer

Responsibilities:

• Authored design documents (CF250), technical specifications (MD200) and Installation documents (MD120) for all the customizations.
• Involved in developing various SQL, PLSQL and UNIX shell scripts for conversion programs and interfaces, developed custom oracle forms and reports, performed forms personalization based on the functional specifications provided.
• Developed and extended functionality of various RICEW components in modules like OM, INV, AR, AP, CM, GL and PO.
• Worked on application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues.
• Created various concurrent request sets and scheduled them to run on predefined timing periodically, including: Order Import interface program, Auto Invoice Program, Payables Open Interface Import etc.,
• Developed custom reports using Report 10g and XML Publisher. Customized various seeded reports to in corporate business functionality and generate spreadsheet outputs.
• Developed Operational Dashboards for business to view current health of the organizations.
• Involved in Preparing Design Documents for all Customizations with detailed solutions, development and implementation of all interfaces and conversions.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Involved in some activities for Oracle System Administration module such as, creating new menus, responsibilities, value sets, descriptive flex-fields and defining the required system profile options. Extensively utilized the Application Object Library to register SQL*Loader programs, Shell Scripts, PL/SQL procedures, Forms and reports.
• Designed and developed Custom Trial Balance reports to help Business cross validate converted Journals and Balances before and after data conversion.
• Provided post go-live support and involved in user training sessions.
• Experience in Building data conversion/migration strategy, mapping legacy system fields to Oracle Applications data fields.
• Supported on Month end closing. Assisted users in completing the transactions.
• Documented all the work done for future reference. Also created various reference manuals for functionaltesters and users.
• Resolved period closings issues in oracle General Ledger while performing one time translations and auto reversal at the end of the period.
• Performed complete design and development of Custom Payment method 'VPAY' and the corresponding integration with Oracle applications.
• Customized Order Management Header and Line Workflows for incorporating Role Based Approval for the pre-specified business conditions.
• Worked on customization of PO Requisition Account Generator Workflow, Updated the logic for the accrual account for expense items to copy the company segment of the charge account to the company segment of the accrual account.
• Resolved various General Data errors occurred by analyzing and applying GDF patches and the corresponding Root Cause Fix Patches.
• Worked as a technical support for resolving various bugs for various service requests raised with Oracle Support.

Environment: Oracle Applications R12.1.3 (GL, AR, AP, PO, OM, CM, FA, INV, iProcurement, IExpenses, EB-Tax), Oracle 10g, SQL,PL/SQL, Forms10g, Reports 10g, JDeveloper 10g, TOAD and UNIX.

Confidential, Minneapolis, MN

Oracle Apps Techno Functional Developer

Responsibilities:

• Worked on the upgrade process of Oracle11i (11.5.8) to R12 (12.1.3).
• Extensively tested oracle upgrade instance, identifying issues, supporting business functionality & resolving issues working closely with business users and Oracle Support.
• Worked on archive and purge process that will save the AR invoices in a file until a given date, and then deletes the records from tables.
• Involved in Loading and importing credit card transactions and exporting the expense report into Oracle Payables in Oracle Financials.
• Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.
• In the GL module, designed and developed packages for Journal Import Interface to import journals information into the system. Developed PL/SQL package to validate and insert the validated data into interface tables.
• Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.
• Developed various Business Areas using Oracle Discoverer Administrator mainly on financials GL, AP, AR and PO. Developed various reports with complex business conditions by creating various workbooks in Discoverer plus and sharing them to users.
• Developed interface to add bank account of an employee supplier in Payables from their payroll data.
• Created a custom interface to load Procurement card transaction to Oracle payables.
• Analyzed the requirements, performing risk analysis for mapping the business processes. Understanding the gaps, recommended the necessary customizations.
• Configured payment system to record wire payments in payables and to avoid direct journal entry in General Ledger.
• Customized the remittance advice as per the client’s requirements.
• Assisted in the month end and year-end close process of financial modules.
• Resolved number of production issues in GL, AP, AR, PO and FA.
• During the Support phase, applied various Recommended Patch Collections (RPCs) for AP, Suppliers, Workflows and Cash management. Analyzed and applied various GDFs in payables and applied RCA patches to fix the issues permanently.
• Created FSG (Financial Statement generator) Reports defined row sets, column sets and reports.
• Performed Forms Personalization to ensure the security of the system and data access to only specific orgs for which user belongs to.
• Extensively worked on Forms Personalization and customization for incorporating business logic.

Environment: Oracle Apps 11i (11.5. .1.3) (AP, PO, GL, FA, AR, iExpense, AME, System Administrator) Oracle10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Data Loader, Reports 10g, Forms 10g, BI Publisher, Discoverer 10g, Workflow, Windows 7, UNIX.

Confidential, San Jose, CA

Oracle Apps Technical Developer

Responsibilities:

• Developed new Reports and customized existing Reports in the AR and AP modules according to the client's requirements.
• Developed a Custom Program to validate and Import Sales Order from legacy system into Oracle Application using order-processing API.
• Worked on Payables Open Invoice Interface in Accounts Payables (AP) from data loading, validation and interfacing.
• Developed various custom reports and customized standard reports in Order Management (OM), Inventory, Pricing and Shipping Modules.
• Worked with users through the entire Software Development Lifecycle (SDLC).
• Developed Supplier Master Data and Customer Master Data Conversion from legacy system into Oracle Applications base tables using APIs.
• Created custom forms with control block and auto populating data to Control blocks at run time using PRE, POST-Query triggers.
• Utilized Oracle's Application Implementation Method (AIM) approach, and documented the process using the recommended AIM documentation such as MD 50, MD70 and MD120.
• Worked on customization of standard forms through custom.pll.
• Generated various reports like Sub-Ledger Accounting Activity Report, Cash Management Reconciliation Reports, Material Transaction Report and others using XML Publisher.
• Worked with API's and Conversions like Item Master, BOM, Item-Category, On-hand quantity, Journal Import, Customer, and Sales Order etc.
• Developed new Concurrent Programs, Forms & Reports and Flex Field Customizations
• Developed UNIX Shell scripts to archive inbound/outbound files and report outputs.
• Providing Production support and helping users in the month end closing and to complete pending transactions.
• Modification of custom components as per various requirements of the project.
• Worked on form personalization e.g. Standard Customer Master Form Personalization to work conditionally for various responsibilities and different users as per their profile settings.
• Customized the Order Header Level and Line Level Workflow (WF) processes to add the custom activities.
• Created Materialized Views to hold the extracted and calculated data for Reporting purposes.
• Expertise in writing Challenging Codes using SQL, PL/SQL and UNIX Shell Scripts.
• Created new custom folders and value lists in discoverer admin layer.
• Writing Custom PL/SQL packages for the Project Costing and Billing extensions and developing various reports for Invoicing, Billing and Man-hour reports.
• Developed new custom forms from scratch as per client requirements, involved in bug analysis, and fixing process.

Environment: Oracle Applications R12 (AR, AP), SQL, PL/SQL, Reports/Forms 10g, TOAD, Discoverer 10g, Oracle Database 10g, XML Publisher.

Confidential

Oracle Apps Technical Developer

Responsibilities:

• Responsible for Design, Development and support of Rebate processing project and support.
• Designed and developed custom forms to enter the customer operations and Medicaid rebates as the client’s requirements.
• Designed and developed custom forms to enter product, location, contacts and partner master data as per the end user requirement.
• Developed workflows to send notifications to users and workflows for account generation in AP, PO and AR modules.
• Involved in implementation of OM module and developed brand new order interface as part of the data conversion from legacy system.
• Worked on Order Import in Order Management (OM), Purchase Order conversions for PO.
• Developed stored procedures to populate the interface tables in the process of importing customer’s information into AR and Purchase Order information into PO.
• Registered Concurrent program executable, defined concurrent programs attached to request groups and attaching request groups to responsibilities.
• Worked on various programs involving use of pricing engine, Price lists, pricing formulas, qualifiers and modifiers.
• Designed and developed various Business-to-Business processes involving Inbounds and Outbounds.
• Developed shell scripts to load data from staging tables into the interface tables and call the concurrent programs to populate the base tables as part of the conversion.
• Enabled descriptive flex fields to store additional custom information to develop the complex reports based upon several different custom applications as well as oracle applications.
• Prepared Technical Design Documents (MD70) for all the objects developed.
• Interacted with end users and translated their requirements into documents that catered the logic for implementing user requirements.

Environment: Oracle Applications 11i (AP, AR, GL, OM, PO), Oracle Forms/Reports 6i, XML Publisher, Oracle Workflow Builder, TOAD.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
• Altering the database Objects to synchronize it with the new Schema created.
• Creating Database Tables, Views, Indexes, Triggers and Sequences and Developing the Database Structure with ETL Concepts.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune SQL queries for better performance and also extensive Usage of Indexes.
• Used Sql*Loader for loading the database tables with huge volumes of data from Old Schema.
• Involved to prepare user level and system level maintenance documentation, Technical Documentation, Unit test, Integration Test and writing Test plan.
• Developed functions, procedures and packages as re-usable application programs that translated complex business logic using PL/SQL and SQL to transform data between source staging area to target staging area.
• Extensively used PL/SQL tables, cursors and exception handling.
• Created database objects like Tables, Sequence, Synonyms, Views, and Materialized Views.
• Importing data from different varieties of sources like flat file, excel file or Oracle dump file into Oracle database source schema tables using SQL*loader.
• Responsible for creating and maintaining the Table spaces, Users and assigning Roles and Privileges.
• Developed, Tested and Migrated the OraclePL/SQL scripts to Production.

Environment: Oracle 10g/9i, SQL, PL-SQL, SQL*Plus, Toad, Stored Procedures, Functions and Triggers, UNIX.