PROFESSIONAL SUMMARY:

• 11+ years of technical and functional experience in Oracle EBS Financial modules and implementation projects, Oracle Fusion Financial modules.
• Extensive technical and functional knowledge in Oracle EBS Financials Releases 12.1.X, and 12.2.X, Oracle EBS technical architecture, filesystem, data migration, upgrade and posse’s knowledge in similar areas in Oracle Fusion financials.
• Well experienced in Oracle Applications Framework (OAF) and Application Development Framework (ADF) using Java Developer, Oracle Forms and Reports, BI Publisher, EBS database table schema, Web Adi, Application Object Library (FND), SQL, PLSQL, XML, Oracle Workflow, Core Java, Unix OS, creation and registration of Apps custom Reports, Database Objects and Customization, defining concurrent programs, Descriptive Flex Fields.
• Good exposure in BI Publisher XML Publisher, which includes report development objects like data templates and RTF's.
• Extensive experience writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Advanced PL/SQL data types like Record Type, Table Type, Bulk Collect and SQL Loader scripts.
• Expertise working with Oracle 7.x/8.x/9i/10g/11g, Developer 2000, PL/SQL, Forms 6i/9i/10g, Reports 6i/9i/10g, SQL Loader and XML/BI publisher 5.6.2.
• Used Trading Community Architecture TCA APIs to create/Update Parties and Relationships.
• Experienced in Customization Forms and Forms Personalization.
• Experienced in analyzing using KPOF, SQL Trace, and Explain Plan.
• Involved in analysis, design, development, testing and implementation of medium to large scale projects.
• Leading a team of 5, involved in maintenance of EBS and Fusion financial products with tasks such as conducting regular meetings with the team to discuss the customer issues, technical issues, solutions through web conferences, working with oracle support teams.
• Developed projects both in EBS and Fusion Financials for the Core product of Oracle General Ledger, tax setup, Intercompany setup/balancing areas, Legal Entity, Business unit and other products like Receivables and Payables.
• Development of new enhancements and fixing the Customer bugs for new release (R12). Creation and performing end - end testing of RPC (Recommended Patch Collection) in local and QA integrated environments.
• Assisted in data migration between different versions of oracle applications by suggesting possible tools like Oracle setup, DRM and fixing the problems in incompatibility in the data.
• Experience in developing technical and functional test cases, using Application Implementation Methodology (AIM).
• An enthusiastic and personable team player, with ability to adapt to different work environments and has always maintained a shorter learning curve, effective communicator and presenter with strong analytical and Bug solving skills and capacity to meet deadlines.

TECHNICAL SKILLS:

Skills: Frameworks of Oracle: OAF, ADF with Oracle Jdeveloper, J2EE. Junit, OATS, Selenium, Fusion Middleware, Oracle SQL/PLSQL Skills. Oracle Forms, Oracle BI Publisher / XML Publisher, Oracle Reports, Oracle Workflows Oracle applications Release 12.1.X, 12.2.X and Oracle Fusion R13. Oracle 9i, 10g with Oracle SQL Developer 1.1 Sun Secure global Desktop Native Client MS Office ( MS Word, Excel etc )

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Technical Consultant

Environment: Oracle EBS instance, Oracle Forms and Reports, SQL, PLSQL.

Responsibilities:

• Creation and registration of Apps custom Reports.
• Customizing standard workflow.
• Development of new reports using BI publisher.
• Defining chart of accounts COA, segments, value sets and values.
• Create Primary Ledger, Operating Unit and Legal Entity Setup.
• Defining Accounting Calendar, period types, calendar periods.
• Setting profile options like SET OF BOOKS ID, data access set.
• Setup Ledger, bank setup,

Confidential

Environment: Oracle Forms and Reports, SQL, PLSQL. Duration: .

Responsibilities:

• Creating, chart of Accounts, calendar and completing Accounting setup and its concepts
• Segment Qualifiers and Flex field Qualifiers.
• Create Primary Ledger, Operating Unit and Legal Entity Setup.
• Ledger Options Setup.
• Journal Entry, Inquiry, Journal Import and posting processing.
• Managing Inter Company and Intra company transactions
• Currency Architecture and Translation.
• Importing Data using Web ADI Content
• Financial Report Generation Process (FSG) and Drilldown on the Reports.

Confidential

Responsibilities:

• Involved in end-to-end development cycle for the project using Fusion Middleware. Developed prototypes for some key concepts like producer/consumer, polymorphism, Key/Partial Flex and many other components which benefitted the product as a whole
• I performed detailed design based on high level design specifications.
• Assist in system planning, scheduling and implementation.
• Conducted a system study for Oracle E-Business Suite (built on OAF, FORMS) in refactoring the same to Fusion using ADF, SOA
• Built certain modules in the product end to end and involved in the implementation of Functional/Data security, Embedded help, Contextual Events, Flex consumption.
• Build and execute unit test plans. Review integration and regression test plans created by QA.
• Provide and mentor the new bees.
• Deliver the project within the agreed timeline with good Quality.

Confidential

Environment: Oracle Forms, ADF.

Responsibilities:

• Analyzing SQL Trace and tkprof (also Concurrent SQL trace) and performance tuning and executing SQL Data fixes
• Analyzing the OA FND Log, FRD (Forms Runtime Diagnostics) Trace.
• Configuring Software and hardware to solve performance or data issues.