PROFESSIONAL SUMMARY:

• 8+ years of progressive experience in Oracle Technologies.
• 4+ years of hands on experience in Oracle ADF 11g Architecture, JDeveloper, Oracle ADF development (ADF Business Components, ADF Faces, ADF Task Flows).
• 4 years of experience with Oracle E - business Suite - Core HR, AR, AP, GL delivering value added Business Solutions through rigorous planning, design and development.
• Expertise in designing, developing, unit testing, deploying and maintaining applications using Oracle ADF.
• Extensively developed ADF secure applications using OID (Oracle Internet Directory), E-business Suite security (SDK) and Site Minder authentication.
• Have good knowledge on Web Logic Server 11g.
• Experience in tuning ADF applications.
• Strong understanding of Oracle Applications Architecture and Data structures.
• Developed Interfaces, Extensions, Conversions for integration between E-business Suite and third party systems
• Experience in Application Development and maintenance using Oracle Applications Framework (OAF).
• Extensively worked on Development and Maintenance projects using both Waterfall and Agile Methodologies
• Experience in the preparation of Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces.
• Experience in workflow Customization according to user requirements
• Experience in Tuning SQL statements to improve execution performance.
• Expertise in performing gap analysis and business process mapping.
• Experience in articulating design and development concepts in technical specification documents using AIM documentation like MD050, MD070.
• Involved in estimate, plan, track, control costs, and provide project status reporting.
• Excellent team player as well as an independent leader.
• Excellent communication skills, adept in client interaction and understanding business applications.

TECHNICAL SKILLS:

Technologies: Oracle PL/SQL, J2EE, Oracle ADF

Application Development: Jdeveloper9i with OA, Jdeveloper 11.1.2.3,Oracle Workflow Builder, SQL*Plus, SQL Navigator, SQL*Loader 6.0, Toad

Application Servers: Oracle Web Logic Server 11g

ERP Modules: Oracle Apps 11i (Core HR, Payroll),Oracle AP(Payables), Oracle AR(Receivables) Oracle GL (General Ledger)

RDBMS Databases: Oracle 9i/10g/11g, SQL Server

Operating Systems: MS: DOS, Windows 98, 2000, NT, XP

Reporting Tool: Report 6i

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Developer

Hardware/Software: Windows and UNIX, Oracle ADF 11gR2, Oracle applications 11.5.10.2, Oracle Database 11g (SQL and PL/SQL), Oracle AR, Oracle AP, BI Publisher 11g

Responsibilities:

• Designed and developed a rich ADF UI for brokers and employers to view and download their Schedule A documents.
• Design, Implement and Test Oracle ADF applications using JDeveloper 11g
• Responsible for developing ADF applications with restricted access using Site Minder authentication with HTTP request.
• Consumed standard oracle BI Publisher Web Services to be invoked from managed beans and interacting to data layer for integrating BI Publisher with ADF UI.
• Consumed custom Web Services in developing ADF Data Controls.
• Developed ADF Model components (creation, configuration, and tuning of Entity Objects, View Objects, Application Modules, bindings and data controls) for various projects.
• Designed and developed self guiding Customer Account Configuration application using ADF Page Fragments, ADF Bounded Task Flows and Train components with multiple Train Stops.
• Developed a prototype to implement Dynamic Train Stops in ADF Faces.
• Developed business validations in various ADF Projects using EO validation and field level validation.
• Developed ADF Dynamic regions.
• Automated Invoice Adjustments process by developing application using ADF and integrating with Oracle Workflow.
• Implemented capabilities to upload and download files of different MIME formats in ADF UI.
• Responsible for developing Secure ADF applications with restricted access using Oracle Identity Management (OID) and Application Roles.
• Responsible for developing Secure ADF applications using Oracle E-business security (Oracle E-business suite SDK) and Enterprise and application Roles.
• Developed managed beans to interact with Oracle pl/sql objects (Procedures, Functions) using Oracle Callable Statements Java API.
• Developed updateable and read only View Objects for various ADF applications.
• Involved in the development of Database components required for ADF Faces development.
• Coordinated with the offshore team in various stages of the project.
• Have promoted and built a team atmosphere, motivating team members.

Confidential, NJ

Module Developer

Hardware/Software: Windows and UNIX, Oracle Applications 11.5.10.2, Oracle Database 11g (SQL and PL/SQL), SQL PLUS, Oracle AP, Oracle AR, Oracle GL, Oracle ADF 11g R1

Responsibilities:

• Designed and developed Master Detail layout for Cash Receipt application using JSF pages in ADF.
• Achieved displaying different table data in the same Popup window based on different business conditions, using Switcher component in ADF.
• Responsible for developing Secure ADF applications using Oracle E-business security (Oracle E-business suite SDK) and Enterprise and application Roles.
• Used Groovy Expressions to dynamically control the ability to update table data based on users roles.
• Integrated ADF based applications with Oracle Workflow Builder.
• Developed ADF Model components (creation, configuration, and tuning of Entity Objects, View Objects, Application Modules, bindings and data controls) for various projects.
• Developed UI fragments, templates and bounded and unbounded task flows using Jdeveloper 11g.
• Implemented Search functionality in JSPX pages.
• Implemented page submit validations using Action Listeners in ADF Faces.
• Developed managed beans to interact with Oracle pl/sql objects (Procedures, Functions) using Oracle Callable Statements Java API.
• Involved in the development of Database components for ADF development.
• Migrated existing OAF based applications to ADF.
• Worked in all phases of Support and Enhancements.
• Developed custom UI using OAF for the application of cash to invoices - Integrated Oracle Workflow with OAF for approvals
• Extended OAF Pages to provide enhanced custom functionality in iReceivables, Customer Online.
• Prepared Business Requirement Documents and Technical Design Documents as per the client requirement.
• Developing adhoc queries and providing data to the users from backend as per business requirements
• Worked as offshore team member closely with Onsite team and Client team.

Confidential

Developer

Hardware/Software: Windows and UNIX, Oracle Applications11.5.10.2, Oracle Database 9i (SQL and PL/SQL), SQL Navigator, Oracle Workflow Builder

Responsibilities:

• Customized Oracle provided Expense Reports Workflow ( APEXP )
• Developed a workflow for a custom Travel Authorization requirement
• Configured AME Rules for Expense Reports and Travel Authorization Approvals
• Developed Interfaces For Loading And Maintenance Of Credit Card Transaction.

Confidential

Developer

Hardware/Software: Windows and UNIX, Oracle Applications11i, Oracle Database 9i (SQL and PL/SQL), Oracle Developer 6i, Putty, SQL PLUS and SQL Loader, Oracle AP, Oracle AR, Oracle GL

Responsibilities:

• Creation of Value sets in various Modules of the application.
• Defining Menu, functions, Reports
• Defining Concurrent Programs, Executables.
• Taken part in closing activities of the client on a monthly, quarterly and annual basis
• Involved in the maintenance work like monitoring the Activities on a regular basis
• Define and maintain all Set ups like Memo Lines, Lockbox, and Auto Invoice etc.
• Development of Inbound Interface to transfer the data from flat files to database tables.
• Extracted data from the underlining Oracle tables for General Ledger conversion project.
• Set up lock box processing in the application side

Confidential

Developer

Hardware/Software: Windows and UNIX, Oracle Applications11i, Oracle Database 9i (SQL and PL/SQL), Putty, SQL PLUS, Core HR, Oracle Payroll

Responsibilities:

• Gap Analysis and Requirement mapping during the implementation
• Implementation of Core Oracle HR for the client - Conversions, Interfaces, Reports
• Developed approval flow using AME
• Developed User Hooks at API and Table levels to log transaction Data and achieve Business Validation logic.
• Worked on resolving various incidents related to work and home address.
• Worked on generating various comma separated reports using UTL FILE utility.
• Enhanced and fixed inbound and outbound interfaces.
• Configured Seeded Earning/Deductions elements, flex fields and setting up Business Groups for US Implementation.
• Developed Fast Formula for Prorating, element skip rules and Accruals.
• Automated the conversion process for migrating company and people data from legacy system into Oracle HRMS.
• Developed outbound and inbound interfaces.
• Worked as a single point of contact for the end to end Implementation of Private SDI (State Disability Insurance Tax) for clients.
• Expert in Oracle AOL concepts.
• Worked on generating different reconciliation reports for payroll generation
• Set up the payroll for the organization.
• Had written request set for the automated processing of payroll for various clients.
• Monitoring task completion and status updates.
• Generating CMMi-5 quality deliverables including project scope document, estimation, peer review, system analysis and design documentation.
• Performing Causal Analysis Review (CAR) and Fishbone Analysis.

Confidential

Developer

Hardware/Software: Windows and UNIX, Oracle Database 9i (SQL and PL/SQL), SQL PLUS

Responsibilities:

• Fixed bugs and supported the existing Oracle system
• Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Developed new functionality to the existing application as part of change requests
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain Plan, Trace, Stored Outlines
• Developed Oracle pl/sql and UNIX based Monitoring Dashboard leading to Green Belt Certification