SUMMARY

• Over 9 + Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle Applications, PL/SQL with all the phases of a project including Requirement analysis, Customization, Implementation, Design/Development, Testing and Production Support on Oracle E - Business Suite applications.
• Worked extensively on various Interface design, development, customizations, Error Handling & Support.
• Extensive Oracle Apps techno-functional experience in various modules includes - Account Receivables, Accounts Payable, General Ledger, Sub ledger Accounting, and Fixed Assets.
• Extensive experience on importing data from external systems for Suppliers, Customers, AP Invoices, AR Invoices and Journal Entries using various PUB packages and API tables
• Extensive experience in developing Interface/Conversion programs to import data from legacy systems to Oracle Applications using PL/SQL, SQL Loader, DB Links, UTL File etc
• Participated in CRP’s with Business users from different countries on different modules like GL, AP, AR, FA and System admin modules as part of end to end business flows.
• Oracle Certified Associate - Oracle 9i
• Expert in writing Stored procedures, Functions, Packages, Database triggers, Shell-Scripts and SQL*Loader scripts.
• Expert in System Administration activities like defining Users, defining and adding Responsibilities to Users, assigning Profiles values, Flex fields and Flex values, Oracle Forms, Oracle Reports, defining Concurrent programs and providing support to business end users.
• Hands on experience with Toad, PL/SQL developer, Forms, Reports and XML publisher
• Hands on experience in developing .prog files using UNIX shell scripting and creating batch programs.
• Experience in librarian activities like maintaining source codes using Star team, PVCS and VSS.
• Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
• Experience in implementing various Production rollouts of application.
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
• Possess good communication skills and quick learning ability
• Excellent team player with leadership qualities and coordinating abilities

TECHNICAL SKILLS

Database: Oracle 10g, Oracle R12 / 11i, MS Access

Languages: PLSQL, C++, Java, XML Publisher

Developer Tools: Toad, SQL Programmer, PLSQL Developer, SQL Navigator

GUI: Developer 6i (Forms and Reports), Visual Basic 6

Operating systems: MS Windows 95/NT/2000, UNIX, Sun Solaris, MS DOS

PROFESSIONAL EXPERIENCE

Sr Oracle Apps Techno Functional Analyst

Confidential, NJ

Responsibilities:

• Developed Technical and Functional specs for various Interfaces and Reports based on the discussions with the Business Users.
• Developed Inbound Interface program to validate and import the AP Suppliers and AP Invoice lines from external system - Ariba and Lawson as part of Account Payables module.
• Developed Inbound Interface program to validate and Import AR Customers and AR Invoices from external system - Ariba and Lawson as part of Account Receivables module.
• Developed various reports using XML Publisher in Accounts Payables on Invoices, Invoices lines, Distributions and Payments.
• Developed various Reconciliation reports on the Invoice and Payment transactions that are posted to General Ledger thru SLA tables using XLA Entities, XLA Headers, XLA Lines and XLA Distribution.
• Involved in the Development of the GL Interface Program to Import and validate the Journal Entry Transactions into GL INTERFACE table using SQL*Loader and successfully created the Journal Entry's data into GL JE BATCHES, GL JE HEADERS and GL JE LINES using Journal import program.
• Developed various reports in General Ledger like GL Balances with Entered and Accounted Currency, YTD Balances and on Translated Balances with Ledger Info.
• Developed various Check request templates as part of the Payment Process Requests in R12.
• Supported Business users in running the Payment Process Batch with different scenarios.
• Extensive experience with the SOA architecture with the EBS modules in R12.
• Defined Descriptive Flex Fields (DFF) to store the additional info from external / legacy systems on Invoice level, Invoice line level etc.
• Created various Concurrent programs / value sets / Look Confidential as part of the Interface programs and migrated them from one instance to another instance by creating LDT files.
• Working with the AR API Interface Programs to load the data into the tables with the validations.
• Participated in Walkthrough and defect report meetings periodically.
• Worked closely with Oracle Support by logging SRs on various issues.
• Provided 24X7 support as part of PROD issues

Environment: TOAD 10.6, Oracle 10g, Oracle Applications R12 (12.1.3),AR,AP,GL, PL/SQL, SQL* Loader, SOA, Forms/Reports 10g, SQL*Plus, PVCS (version control software), Workbench, HP PPM Workbench 7.

Sr. Oracle Apps Techno-functional Analyst

Confidential, Wayne, NJ

Responsibilities:

• Developed Technical Specification for various Interfaces like GL Exchange Rates, Supplier Conversion, AP Invoice Import based on the client requirement.
• Developed GL Exchange Rates program as part of loading the GL Daily Rates into the System from Bloomberg
• Customized the Payment Process Request in generating the Payment Batches as per the Client Requirement.
• Developed various PL/SQL packages, Procedures, Functions, and Views as part of various Interface developments for AP and GL.
• Developed various Adhoc queries from AP to General Ledger as part of reconciling the sub ledger balances to GL.
• Developed various SQL queries and extracts on GL / AP / SLA modules as part of XML Publisher development.
• Developed Email notification system for Concurrent Programs to send the Output and logs files to User / User groups.
• Used parameter cursors and ref cursors for performing DML operations involving multiple records.
• Tuned the performance of queries by working intensively over indexes.
• Defined and maintained various paths as part of Inbound and Outbound Interfaces and also in maintaining the Error files and ARCH files.
• Developed various Lookups, Value sets, Concurrent Program Creation & Registration, Request Set Creation & Registration (these request sets were created for various Interfaces & Reports).
• Working with the ireceivables to collect the receipts from the system PRISM.
• Worked on various SR’s in different modules - AP, GL, AR and FA.
• Developed Oracle Forms for Customer/Address Registration, Credit card Transactions and Inquiry screens under Account Receivables module.
• Participated in Walkthrough and defect report meeting periodically
• Worked closely with Business users in identifying the gaps and providing work around and Customizations.

Environment: Oracle Applications R12 (12.1.3)PL/SQL, SQL and SQL PLUS, AR, AR API, IRECEVABLES, SQL LOADER, SOA, UNIX Shell Scripting, Repository Manager 7.x/8.x, Workflow Manager 7.x/8.x, TOAD.

Confidential, WI

Techno-functional Analyst

Responsibilities:

• Involved in the detail analysis of the current data mart and identification of Fact and Dimension tables and developed mapping logic.
• Worked with the data mart users to find out their requirements and designed the data mart tables accordingly to meet the user’s demands.
• Developed Supplier Interface using AP SUPPLIERS INT, AP SUPPLIER SITES INT and AP SUP SITE CONTACT INT Interface tables.
• Designed, developed and supported the AP Invoice Upload Interface (vendors which were not exist will be created also) for the invoices which will be coming from different suppliers.web services and also using soa suite.
• Developed various Lookups, Value sets, Concurrent Program Creation & Registration, Request Set Creation & Registration
• Involved in Converting Assets from One GL Set of Books to other GL Set Of Books as a part of GL Conversion project.
• Customized FA Account Generator workflow to generate accounts based on FA Books.
• Worked on the resolutions of SR’s that are raised as part of critical production issues and follow-up the same until the issue is solved.
• Reported to the Project manager regarding the progress of the production issues.
• Customizations in Purchase order reports.
• Worked on AP Invoice Upload interface to match to Purchase Orders.
• Extensively worked with PL/SQL programming - PL/SQL Packages, Functions, Procedures, and Views to implement business logics/rules.
• Worked closely with DBA for SQL queries tuning using Explain Plan, Hints and optimizing the query.
• Involved in Extraction and the Cleansing of the data from flat files using SQL scripts, and used SQL Loader and PL/SQL for loading the data into the Interface table.
• Extensively created database objects like Tables, Indexes, Triggers, Stored Procedures, sequences, synonyms, clusters, views
• Created Materialized views for enhancing the performance of complex business intelligence queries
• Provided production support to schedule and execute production batch jobs and analyzed log files.
• Extensively involved in unit testing and test cases.
• Involved in creating various documentations like Design document, Unit test plan and Migration documents etc.

Environment: Oracle R12, PL/SQL, SQL and SQL*PLUS, SQL*LOADER, ERWIN, UNIX Shell Script, Repository Manager 7.x/8.x, Workflow Manager 7.x/8.x, TOAD.

Confidential

Oracle Apps Developer

Responsibilities:

• Identifying the information needs within and across functional areas of an organization.
• Developed various Technical design docs on GL Interfaces, GL Code Combinations import program
• Developed Currency exchange rates program using the Corporates rates in Oracle apps.
• Worked on optimizing existing PL/SQL packages, procedures, functions and views to suit business needs. Used parametric cursors and ref cursors for performing DML operations involving multiple records.
• Managed database optimization and table-space fragmentation.
• Tuned the performance of queries by working intensively over indexes.
• Created various DFFs in storing the Additional information for Invoices and Customers.
• Developed various Custom reports in General Ledger modules based on the User requirements
• Created various shell scripts to execute PL/SQL procedures and packages and defined them as Concurrent Programs in Oracle Apps.
• Developed various Concurrent Programs, value sets, lookups as part of the various Interface programs.

Environment: Oracle Apps 11i (11.5.10), Oracle 9i, Repository Manager, Workflow Manager, TOAD and PVCS.

Confidential

Oracle Developer

Responsibilities:

• Monitoring existing SQL code and performance tuning if necessary.
• Created indexes for retrieving data quickly.
• For better performance used EXPLAIN PLAN, HINTS to tune queries.
• Created Temporary Tables in procedure to achieve performance issues.
• Used TOAD for faster application design and developments.
• Wrote complex SQL queries using joins and sub queries.
• Wrote Procedures and Functions using oracle.
• Based on the requirement developed necessary forms and reports.
• Created indexes to improve the system performance.
• Wrote scripts for creating Views.
• Read data from flat files to oracle tables using SQL*loader.
• Developed Unix Shell scripts.

Environment: Oracle 9i/10g, SQL Plus, SQL Loader, Toad, Forms 6i, reports 6i & UNIX (Solaris).