summary

• Over 7 Years of experience in Oracle, PL/SQL, SQL PLUS, Oracle Reports, Oracle Forms.Over 8 plus years of Oracle Applications system experience across multiple streams in the product suite - Financials, Supply Chain Management SCM , Human Resources HRMS and Customer Relationship Management CRM as well Financial Services modules like Property Management, Lease Management and Treasury
• Experience in all phases of the Software development life cycle SDLC in an ERP environment.
• Experience in various Oracle technologies like ADF, SOA, OBIEE, BI-Apps, OA Framework, Forms, Reports, AME, Workflow, BPEL, Discoverer and XML / BI Publisher
• Experience in Customizing Oracle Forms with Forms Personalization, Custom.pll on Forms 10g/6i.
• Expert in designing and developing Oracle Forms Reports using Forms10g and Reports 10g.
• Techno-Functional consultant with expertise in General Ledger GL , Account Payable AP , Account Receivable AR , Fixed Assets FA , Cash Management CM , Purchasing PO , Order Management OM , Inventory INV , Shipping WSH , Discrete Manufacturing ODM , Process Manufacturing OPM , Advanced Pricing QP , I-Procurement and AOL objects
• Hands on experience in 11i R12 implementation and roll-out of financial modules like GL, AP, AR and FA
• Experience in debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports.
• Experience in Software Development Life Cycle including Analysis, Design, Development, Implementation, Testing and Post Production Support using Oracle Applications R12 12.1.3 , 11i 11.5.9,11.5.10.2
• Experience in Customization and Implementation of Oracle Reports 6i/9i/10g.
• Perform business development and proposal support tasks in pursuit of EAM opportunities.
• Good Knowledge in Oracle Application Framework OAF
• Experience in development customization of XML/BI Publisher and Discoverer Reports
• Extensive experience with XML/BI Publisher, Oracle 9i Discoverer, JDeveloper, Developer, Form builder, Report Builder, Workflow Builder, Kintana, VSS, PuTTY, Toad, SQL Developer, SQL Loader, SQL and PL/ SQL programming on Windows and UNIX with Oracle database
• Experience in I-Store, I-Expenses, eBtax and TCA modules
• Extensively Worked on AIM documents like MD050, MD070 and MD120
• Experience in development of forms and reports using SQL and PL/SQL, reports using XML Publisher and exposure to Workflow, Web PLSQL, JTF, MSCA, OAF, ADF using jDeveloper 9i, 10g, 11g and development of business reports using OBIEE
• Good functional knowledge in O2C and P2P cycles, HR Modules, and Fusion Talent Management
• Experience in registration/migration of Forms, Reports, OAF UI pages, ADF Pages, PLSQL programs and XML Publisher Reports
• Migration of legacy data to oracle using SQL Loader and UTL FILE utilities
• Experience in using Bug Management Tools such as Bugzilla, Footprints, Numara Track IT and STAR JIRA
• Functional experience across e-business suite modules: Services, Customer Care, Install Base, Trading Community Architecture TCA and Marketing, Receivables, Payables, General Ledger, Treasury, HRMS, Performance Management, Payroll, Projects, Inventory, Order Management, Purchasing, Work in Process WIP , Bill of Material BOM .

Technical Skills

ERP Application Version : - Oracle 11i, R12, Fusion.

ERP Modules :-

• Techno-Functional Skills in Accounts Payables AP , Accounts Receivables AR , INV, OM, PO, BOM, TCA, Telesales ,Collections, iPayments, iExpenses, iRecruitment, iStore
• Technical Skills in iSetup, Quoting, Service Contracts OKS , iSupplier, Sourcing
• Techno-Functional Skills in HR Modules such as ESS, OTL, OLM, Benefits, Payroll and Fusion Talent Management sub-modules such as Goal Management, Performance Management and Compensation Management, Oracle Forms 6i/9i/10g , Oracle Reports 6i/9i/10g , Oracle Workflow Builder, XML/BI Publisher, JDeveloper, VSS, PuTTY, SQL, PL/SQL, UNIX, Shell Scripting, XML, HTML, C and JAVA

Web Framework : - AK

, JTF Java Technology Foundation for CRM Applications , OAF Oracle Application Framework for E-business Suite applications , MSCA/MWA Mobile wireless Architecture for SCM Applications and ADF Application Development Framework for open source fusion applications , Web PLSQL, ADF Mobile, Fusion ADF

Methodology : - Application Implementation Methodology AIM

• Tools : - Toad, SQL Loader, PL/SQL Developer, Discoverer, Data Loader,
• BI/XML Publisher, OBIEE, Load Runner.

GUI : - Forms 6i, OAF using JDeveloper 9i/10g/11g, Eclipse 3.2.2.

Programming Languages :-SQL PL/SQL, C, C , FORTRAN, JAVA, JavaScript, HTML5, PHP.

Database : - Oracle 8i/9i/10g, SQL Server 2000, MS Access, Sybase, DB2

Project Management Tools : - Microsoft Projects, Visio Editor, PM Smart

• Configuration Management : - WinCVS, IBM Web sphere Clear case, Mercury Kintana and
• Tools Interwoven Teamsite

Bug Management Tools : - BugZilla, Footprints, Numara Track IT, STAR JIRA

Java Technologies : - JDBC, JAVA, Servlet, JSP, JavaScript, EJB, RMI, Swing, Hibernate, Spring.

Web Servers : - Apache Tomcat, OC4J, Oracle Application Server, Web Logic

• Utilities : - IE 5.0/5.5, Netscape 4.7/6.0, Mozilla, Chrome, Putty, WinSCP Integration Tools : - XML Gateway 11.5.9, Oracle Workflow 2.6, Business Even
• System BES ,Message Designer 2.6,Oracle 9i Interconnect iStudio with AQ, DB and FTP Adapters, Oracle BPEL Process Manager with Orchestration and Rules Engine, 10g Release 2 10.1.2 ,CMSDK, Oracle Alerts

Other Tools/Utilities :- Toad, SQL Developer, Oracle Work Flow Builder, MS Word, Optio, MS Visio, MS project, SMA, Web sphere, XML, BMC, Vault, Visual Source Safe VSS , Mercury ITG, Sub-version, Test Directory TD , QC, Support Magic SM , SQL Loader, Import/Export utilities, IBM Clear case, Clear quest, Prima Vera, Heat, CVS

Operating Systems : - Windows 98, 2000, NT, XP, 7, UNIX Solaris, HP-UX , Linux.

Professional Experience

Confidential

Oracle Developer

Responsibilities:

• iExpense and iProcurement approval process and self-service screen customizations
• Data loader and interface programs in AR and Treasury modules
• Design, Develop, Review, Deploy RICE Reports, Interfaces, Conversions, Extensions, Forms and Workflow components and AOL objects as part issue fix and enhancement requests
• Testing rdf /xml reports in client's testing environment Development ,QA ,Production
• XML reports on OM, AR, OPM and AP
• Discoverer reports in development.
• Developed and modified the transaction data, query forms.
• Developed GL Revaluation Functionality and Reports.
• Developed AP - Revaluation Report and AR - Revaluation Report.
• Developed issues inventory materials forms.
• Involved in working on different customizations of forms and reports in various modules like GL, AP, AR, FA and PO.
• Developed purchase order creation forms.
• Workflow developments for OPM module
• Developed Interfaces for OPM module
• Updated MD50, MD70 and MD120 documents according to the R12.
• Provides recommendations for development, improvement or simplification as necessary.
• Product Support in 11i and R12.

Environment: Oracle Applications 12.1.3, AP, iProcurement, OA Framework, AR Interface to GL from HSR, Automation of Receipts and Remittances, Oracle Collections, Oracle iPayment, OM, Java, SQL, PL/SQL, Discoverer, Workflow, Forms, Reports

Confidential

Oracle Developer

Responsibilities:

• Upgrade Development and Production support for Oracle E-Business Suite 12.1.3 version of Master Data Management and iStore modules using SQL PLUS, shell scripting, Oracle Components for Java OC4J , Oracle Application Server, Oracle Applications Framework, JDeveloper, Application Development Framework and BPEL Processes with Oracle Workflow
• Customize standard Unmapped Subsidiary Accounts report using Oracle Reports as per the user requirements for General Ledger Consolidation purposes
• Developed inspection forms, issued forms.
• Participated in R12 upgrade project upgrading from 11.5.10.2 to R 12.1.3.
• Customized forms to make changes related to R12 for MOAC changes and tables changes
• Developed major enhancements required for business process in Order to Cash and Procure-to-Pay cycles.
• Developed finished good inventory forms.
• Developed forms based on stored procedures.
• Involved in developing custom XML/BI Publisher reports like Open Sales Orders Summary, Purchase Order Summary
• Customized Order Management Header and Line workflows to meet business requirements
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom
• Developed Shipping Report to show data from Install Base and Service Contracts data using Discoverer.
• Developed material incoming forms.
• Involved in creating Discoverer reports to generate Purchase Order reports
• Good experience customizing and personalizing approvals using Oracle Approval Management AME
• Developed and customized various custom reports like PO Requisition Details Report, Open PO Report by Buyer, Open Receipts Report and PO Unsourced Requisitions Report in Reports 10g builder
• Customized the SLA Accounting Events Page with OAF personalization and Extensions

Environment: Oracle Applications 12.1.3, REVPRO, AP, AR, GL, SLA, OA Framework, Core Java and Web Services, JSP, Servlet

Confidential

Oracle Developer

Responsibilities:

• This project includes the up gradation of Oracle R12 from 11.5.10, Oracle Financials GL, AP and AR AND SCM modules INV, PO, OM are upgraded to R12 as part of the project plan
• Did performance tuning of existing Oracle forms as well as created new Oracle forms using different built-in as well as User-defined functions and procedures.
• Responsible for gathering details of existing 11.5.10 systems from client
• Upgrade system in various instances by upgrading the custom forms, reports and custom pl/sql programs/processes.
• Support for AP, AR, GL, FA modules
• Developed, upgraded, maintained and troubleshooted Oracle Forms and Reports
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors.
• Customized forms using CUSTOM.PLL
• Developed reports like:
• Credit memo Account verification report
• AR Revenue extract report
• Sales Quote for Order Management
• Prepared the documentation of Forms and Reports.
• Resolving day to day issues based on tickets or calls
• Developed the level reports like address, employee details.
• Developed the GUI reports like PO, Invoices, Gate pass, GRN etc.
• Modified XML Publisher report for FA Asset listing Report FA to add few columns
• Worked on P2P Process
• Developed the Oracle matrix reports for finance and purchase, sales modules.
• Defined editors, Created list of values and record groups in Oracle Forms 10g
• Developed Technical Documents MD70 for various RICE objects as per RICE Reports, Interfaces, Conversions, Extensions, Forms and Workflow components design
• Provided report that would show the remaining quantity details as of date for any PO.
• Changed the existing forms and reports of customized Accounts Receivables.
• Design customizations to import invoices and customers into Accounts Receivable, receipts into Accounts Receivables

Environment: Oracle applicationsR11, R12, Finance modules GL, AP, AR, CM, FA, PO, INV, OM , Goal Management, Performance Management, Compensation Workbench, JDeveloper, Install Base IB , Service Contracts SC , Field Services FS , Oracle Quoting and Inventory INV modules and uploading the data to Accounts Receivables AR , Order Management OM .

Confidential

Oracle Developer

Responsibilities:

• Fixing Bugs in Forms and Reports previously designed.
• Developed master reports.
• Developed custom workflows for tracking service requests, and notifying users about the status of these service requests.
• Involved in generation of FSG reports according to the client requirement and consolidated automated financial statements using Financial Statement Generator FSG .
• Orders for Suspense Account Report
• Payments Overdue Report
• Order Detail Summary Report
• Orders by Item Report
• Credit Order Detail Report
• Mailing Label for shipping Report
• Packing Slip Report
• Pick Slip Report
• Developed reports like:
• Customized Sales Order form and was also involved in developing new form to display Delivery Information in Oracle Order Management
• Designed and developed adhoc Discoverer reports
• Registration of new forms and reports using Application Object Library AOL

Environment: Oracle Applications Release R12 / 11i / 11.5.10, FA, AP, PO, GL, Oracle 10g, SQL, SQL PLUS, SQL Loader, UTL Scripts, TOAD, PL/SQL, Shell Scripting, SDLC Source Control, Discoverer10g.

Confidential

Oracle Developer

Responsibilities:

• Business Process and User Requirement analysis and preparation of specification document.
• Mapping the requirements in financials
• Creating Forms and Reports as per business specification.
• Review/Create/Modify the Reports RDF and Forms in Oracle 10g.
• Involved in registering forms and reports.
• Developed new forms using TEMPLATE.fmb and customized existing forms in the OM module according to the client's requirements.
• Involved in designing of required end user forms using Oracle forms 10g.
• Defined Editors, Created List of Values and Record Groups in Oracle Forms 10g.
• Created numerous web based Forms and Reports using Oracle Developer 10g.
• Customized sales order form to book an order only on weekdays and Customized PO form to do not generate a PO if the price is less than some amount
• Customized AP Remittance workflow in Payables
• Hands on experience in Oracle reports like label, tabular, pre-print, Matrix, group above, group left, group right etc.
• Created descriptive flex fields for standard forms to allow users populate extra information.
• Involved with Unit testing and system integration testing during testing phase. Followed AIM methodology to build TE20, TE40, CV 60, MD120, MD 70 documents.

Environment: Oracle Applications Financial Suite R11.5.10 AP, GL, AR, OM, PO, INV, HR, CM , Oracle database 10g. XML Publisher, Discoverer Reports, Oracle Alerts and UNIX

Confidential

Oracle Developer

Responsibilities:

• Developed custom workflows in different modules like PO approval, AP Invoices
• Developed a report for MHM Commission Approval for sales representatives
• Creating Forms and Reports to accommodate the business functionality of the MHM
• Prepare high level design documents, DLD and User manuals
• Developed RMA Receipt Report using Reports 10g.
• Developed pre-print reports.
• Personalization of components using Oracle Forms Personalization and OAF
• Developed and Customized Customer Statement Printing, Dunning Letter Printing using XML Publisher

Environment: Oracle Database 8i, Oracle Forms and Reports and XML Publisher, OAF, Java, JSP, XML, XSL, OAS ,Oracle 10g, Oracle AQ, Workflow Builder, TOAD. SQL, PL/SQL, Reports 6i, TOAD, SQL LOADER, Designer 2000.

Confidential

Oracle Developer

Responsibilities:

• Conversion of existing Forms 5 to Forms 6i and Reports to Reports 6i.
• Design and develop various RICE Reports, Interfaces, Conversions, Extensions, Forms and Workflow components part of critical Oracle iProcurement Implementation
• Involved various other customizations using PLSQL, forms, reports development which are part of Direct Fulfillment.
• Developed Various MIS reports, min- max level reports, re-order reports, re-order status reports, purchase order for suppliers, incoming material generator reports, Quality reports, Pending purchase orders reports, pending sales orders reports.
• Developed BI/XML publisher reports/XML Reporting in DF Purchasing Modules
• Application maintenance. Provided fixes to production issues under support
• Design and Develop the complex SQL Queries, Reports, Oracle Java API's
• Designed the forms for front end interface for the users using Forms 6i.
• Create the system master forms to create the users, responsibilities, user rights, assigned the privileges, added the menus, and added the reports and forms.
• Developed ADHOC Queries and Reports for Users to check status at various levels

Environment: Oracle E-Business Suite R11i 11.5.10 , Solaris OS Unix based , Windows XP, PL/SQL, SHELL SCRIPT, Java/J2ee, Oracle 6i Forms and Reports, Oracle Discoverer, Oracle 9i, Workflow Builder, TOAD, Oracle Application Framework, Oracle Application Server, Oracle 11i Quoting Module.