SUMMARY:

• I have over 11 years of experience in Oracle Applications E - Business Suite (EBS) R12.
• Expertise knowledge on Oracle forms, Reports, Interfaces, PL/SQL and Conversions.
• Expertise on Oracle complex BI/XML publisher reports, Discoverer Reports or RDF Reports.
• Worked for the financial services, retail and port industries on modules like FAH, AR, AP, CE, GL, FA, CM,PA, OM, Trade Management, i-Procurement and ASCP.
• Mainly worked on requirement, analysis, designing, coding, and unit testing.

TECHNICAL SKILLS:

Database: - Oracle 10G, 11G

Programming Languages: - SQL, PL/SQL and UNIX.

Oracle tools: Oracle EBS R12, Oracle Forms, Oracle Reports, XML Publisher, Discoverer, Web ADI, Oracle Workflow Builder, Oracle Data Loader and Oracle Business Application Monitoring (BAM).

Operating system: - Windows XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential

BSA - Finance Solutions

Responsibilities:

• Designed and provided solutions on modules like Oracle FA, Cost Management, Cash Management, Oracle Projects, Oracle payables, Oracle GL and Trade Management.
• Extensively worked on SLA configuration. Created custom sources and appended these sources in the Account Derivation Rules.
• Developed BI/XML publisher reports for Integration related to Ecommerce and Oracle EBS.
• Worked closely on ecommerce related projects which involved more of configuration related to Receivables side of Transaction Types, Receipt Classes, Receivable activities, Auto accounting rules and customers.
• Worked on Third party module which is Virtual Trader which handles intercompany transactions and post it to GL.
• Designed a new program, which enables the new items in the new Inventory Organization from the existing organization.
• Configured Trade Management’s Approval rules, claim types, claim reasons and provided technical and functional solution for building a WEBADI tool for the Approval rules.
• Configured Auto accounting rules in Oracle Projects. Implemented Expense reports in Oracle payables as part of new project. Interfaced these new expense reports to Oracle Projects.

Confidential

Business System Analyst - Development

Responsibilities:

• Designed and Implemented Intercompany profit elimination which involves modules like Procurement, Inventory, Order Management, WMS and Cost management.
• Developed key critical reports related to Cash Management.
• Developed a key Inventory Org move program which transfers the open Sales Orders from One Inventory Org to another. This program dynamically determines the number of child concurrent processes that needs to be kicked off depending on number of open Sales Order lines.
• Developed an Oracle Form to handle Bulk Orders for wholesale customers.
• Developed reports on AR, AP, GL, OM, Inventory and Virtual Trader.
• Worked on extension related to Item hierarchy updated program which comes from PLM.
• Created a Web ADI Tool for Mass Promotions Upload.
• Developed Oracle Interfaces Monitoring Tool using Oracle BAM technology for Period Close.
• Adhered to Oracle AIM methodology and suggested process improvement tools and technology.
• Implemented a key report - Oracle Cash Management - General Ledger Reconciliation Report.
• Designed and developed various Complex BI Publisher Reports and Forms objects by gathering detailed requirements from the client’s functional team and provided robust solution.
• Successfully completed the technical, functional design documents for complex, medium and low type forms, reports and forms in stipulated time frame.
• Carried out feasibility study by performing Proof of Concepts (POC) for complex requirements

Confidential

Technical Consultant

Responsibilities:

• Worked on Upgrading the Google’s Security associated components from 11i to R12.
• Well versed with SQL Injection and its effects which help to maintain the data security.
• Implemented Oracle Forms based “Advanced Supply Chain Planning” Mass update on planned orders.
• Technical Architect of ATP Leveling Tool which uses Order Management and Advanced Supply Chain Planning using Oracle Forms.
• Worked on AR Conversion, customization of Collections form, Lockbox, Order Re-Scheduling, item attribute update & GL PJE Report.
• Developed a formatting tool for all PLSQL Database Objects.
• Designed and developed various Oracle XML/BI Publisher Reports and Forms objects by gathering detailed requirements from the client’s functional team and provided robust solution.
• Successfully completed the technical design documents for complex, medium and low type forms, reports and in stipulated time frame.
• Lead the offshore team and gave the right direction for the solution approach.
• Proactively involved in discussion within the team and on-shore for any issue during the design and development which help me delivering the component on time in right directions.
• Carried out feasibility study by performing Proof of Concepts (POC) for complex requirements

Confidential

Technical Consultant

Responsibilities:

• Successfully Implemented Oracle Financials Accounting Hub both technically and functionally in stipulated time frame.
• Designed and developed various Reports, Interface, Conversion, Extension, Workflows, and Forms (RICEWF) objects by gathering detailed requirements from the client’s functional team and provided robust solution.
• Complete ownership for delivery of Technical Components.
• Successfully completed the technical design documents for complex, medium and low type RICEWF components in stipulated time frame.
• Proactively involved in discussion within the team and on-shore for any issue during the design and development which help me delivering the component on time in right directions.
• Carried out feasibility study by performing Proof of Concepts (POC) for complex requirements.
• Successfully developed customization using forms personalization, Oracle Alerts.
• Lead the offshore team and gave the right direction for the solution approach.

Confidential

Technical Consultant

Responsibilities:

• Successfully developed and Implemented Custom modules like Gang management system and Recruitment module.
• Involved in requirement understanding.
• Prepared technical design document for conversions, interfaces, forms and reports in Oracle Property Manager, and custom modules like Gang Management System and Recruitment modules.
• Developed Oracle Forms and Discoverer Reports for the custom module named as Gang Management System and Recruitment module.
• Implemented Bugzilla defect tracking tool and used it for defect maintenance.
• Created reports using XML Publisher, Oracle Discoverer Reports for modules like PN, HR, SCM and Port Operating System.
• Performed peer review of technical designs and codes.
• Maintained the standard documents for all the components.
• Worked on Form Personalization.

Confidential

 Developer

Responsibilities:

• Involved in obtaining information regarding the Incident, Problem Management, and Change Requests and update the details for the Incidents, Problem and Change requests raised.
• Tracked effort and reporting closure of change requests or Incidents
• Responsible for logging any change requests or Incident that are encountered during the testing process.
• Developing PL/SQL code for analysis and rectification of data sent by branches, as required by the client.
• Developed Oracle forms, Reports and Discoverer Reports.
• Involved in generating reports and metrics to document productivity gained by usage of ISDM and baseline results for future improvements.
• Served as Technical Advisor to Client.
• Responsible in creation of technical design documents and developed the code objects for new enhancements.
• Involved in creation of re-usable assets for the project.
• Analyzed customizations and enhancements: evaluated design, quality, stability, and maintainability of custom code developed to fill gaps between standard Oracle applications functionality and business requirements. Recommended and implemented solutions as needed.
• Performed peer review of technical designs and codes.