Professional Summary:

• Over 9 years of experience in the software industry in the Analysis, Design, Development, Migration, Implementation and Customization of Implementation of Software Applications.
• Proven Techno-Functional skills in all aspects of software development Life Cycle, Conversion, Testing, Installation, Support, troubleshooting and enhancements.
• Good expertise in RICEW Reports, Interfaces, Conversions, Extensions, Workflow, OA Framework components, Integrating with 3rd party products to Oracle Applications.
• Working Knowledge in Oracle Applications E-Business Suite 11i/R12 Oracle Inventory INV , Oracle Purchasing PO ,Order Management OM , Oracle Advanced Supply Chain Planning, Oracle Advanced Pricing, e-Commerce Gateway ECE Trading Community Architecture TCA , DEMANTRA, HRMS,Payroll, Advance benefits, BOM, WIP, Warehouse Management System WMS , Oracle Product LifeCycle Management PLM , WEB ADI, General Ledger GL , Accounts Payables AP , Accounts Receivables AR , Fixed Assets FA ,Procure to Pay, Order to Cash, Demand to Distribution, Budget to Close, Project Accounting, Costing, calendar/financial period change and Self Serviced Applications such as iProcurement, isuppliers, iReceipts, iPayments, iExpenses, iStore, Quality, Purchasing, Supply Chain Management, Workflow, Self Service Web Applications, Cost Management, Engineering, Planning Products, and Work In Process, System Administration, Application Object Library, and Oracle Alerts.
• Well Versed with the various versions of Oracle Applications viz. R12.1.3,11.5.10/11.5.9/11.5.8 /11.5.7/11.0.3/10.7.
• Worked extensively and has strong experience in the Oracle Application E-Business Suite development tool-set Oracle 8i/9i/10g, SQL Plus, PL/SQL, Developer 2000, Developer 6i Forms and Reports , Jdeveloper 10g, Discoverer, BI Publisher, OBIEE, TOAD, XML Publisher, Shell Scripting,OAF,ADF, Forms Personalization,Form Customization using CUSTOM.pll, Customizing and Developing Workflows and using Oracle Applications API's .
• Performed various roles like Team Leader, Technical Lead, Architect, Software Engineer and Technical Consultant.
• Working knowledge in Performance tuning of the database using utilities like Explain plans, TKPROF,Implementation Methodologies like AIM MD200/MD50/60/70/120, BR100, TE50, Process Documents .
• Excellent communications and interpersonal skills. Well versed in gathering requirements from customers/clients. Conversant with Project Management and Quality procedures and working with Oracle Support, Creating Service Requests, and Visual Safe Source to maintain source code.
• Extensive experience in Creating Users, Responsibilities, Request Sets, Request Groups, Profile Options and registering Executables, Concurrent Programs, Form Functions, Reports by using Application Object Library AOL , System Administration.
• Proficient in Interface Programs and Conversion Programs for importing data from Legacy Systems using SQL LOADER.
• In depth knowledge of Order to Cash O2C , Budget to Report and procure to pay P2P processes.
• Implemented Oracle Installed Base, iExpenses, Concur from scratch
• Extensive experience in Oracle Back-end server-side PL/SQL Development i.e. Stored Procedures, Packages, Functions Triggers using SQL Navigator and Toad as development tools. Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, and Synonyms.
• Considerable knowledge in fine-tuning code for better performance.
• Experience in implementing bolt-on applications like MV,Concur
• OAF pages from the scratch development experience.
• Implementation experience on bolt on applications like Concur, Markview and Sunguard payment gateways

TECHNICAL SKILLS:

Confidential

Oracle Application Consultant

Description: As a alone Oracle consultant responsible for Implementation,Analysis, Design , Development, Testing, User training and Support, Enhancements, Upgrades for iDirect, Inc.

Responsibilities:

• Upgraded from release 12.1.1 to 12.1.3
• Implemented iExpenses replacing with Concur
• SOA Webservice integrations among internal and stand alone systems.
• Developed Customer account syncing webservice between remedy and oracle
• Developed salesrep detailed webserivce integration between Salesforce and oracle
• Roll out of oracle Installed base over Remedy systems for product installation tracking
• Critical oracle Patch implementations and maintenances.
• Quarterly Audit support.
• HTML reporting development across the modules.
• Configured Java Mail in oracle apps to be used for all concurrent programs.
• Developed various iSUpport BI Publisher reports
• Customer renewal reporting tool
• Self-service query web application for ad-hoc user data requests
• HR employee upgrade and sync up with legacy systems
• Excel based template BI Publisher reports
• AT T employee mobile billing report in BI Publisher with Workflow approvals
• Developed BI Publisher sub templates with generic organization standards to be maintained across the concurrent programs.
• Month end monitoring and support activities across the modules.
• Created Business event subscriptions for patchup or reporting business purposes.
• Support and resolution under SLA guidelines.
• Usertraining on new module rollouts.
• Business process improvements.

Environment: Oracle Applications EBS R12.1.3, Middleware 10.3.6.0, Database:11.2.0.3, BI Publisher, Webservices, ADF, AOL, GL, IB,OM,INV, AR, AP, PO, HRMS, Advance PL/SQL, SQL Plus, Toad, Reports 10g, Forms 10g.

Confidential

Oracle Application Analyst

Description:

As a Techno Functional Consultant responsible for Analysis, design, development, testing and implementation, Business Applications Support of customized Oracle Applications ERP solutions for support, enhancements and upgrades for our Client Google, Inc.

Responsibilities:

• Implemented Concur replacing with Iexpenses.
• Developed rule based recognition auto invoice creation program.
• Created rule based engine Form from scratch to identify the expense key parameters.
• Customized OAF pages to create client specific Iprocurement.
• Developed XML publisher report for handling long check printing format.
• Development of program to restrict Citi counterfeit card transactions.
• Visa Rec5 validation API development
• Concur region wise policy configuration setup
• Performance improvement program for Google Card interface.
• Worked on the merchant interface to load get the file from oracle and load the data into Google system.
• Worked on Balances Conversion using API's.
• Worked on the interface to create element entries for the employees.
• Involved in setup of Project Management, Project Accounting and Project Manufacturing module.
• Configured the Budgets through change order in Project Management.
• Tested various Allocation methods to achieve the target.
• Involved in setting up Templates, Auto Accounting, Project Parameters in project Manufacturing.
• Involved in setting up project template, accounting rule, etc.
• Defined Project related setup options, Project calendar, Project Period and identified Project types, Project Templates, Task related setup and Project related workflow and profiles.
• Documented requirements and created functional specifications to implement expense report.
• Developed test scripts for unit testing, system testing, and integration testing.
• Developed custom responsibilities for application end users.
• Trained Users on the Sungard, CitiDirect applications.
• Gcard Auto Payment Location specific changes, get individual payments thru file processing, Email automation and Dunning notifications, handling individual payments.
• Concur Expense Handling Application Maintenance and Upgradations.
• Workflow customizations for Finance approver/CEO/CFO injection in hierarchy.
• Developed and customized reports using oracle reports, Discoverer and XML publisher.
• Many HR reports.
• Exception Report.
• Payment Distribution Journal report.
• Costing Details Report.

Environment: Oracle Applications EBS R12.x, 11.5.10.2 , Sys Admin, AOL, GL, AR, AP, PO, HRMS, Advanced Benefits and Payroll, Oracle 10g PL/SQL, SQL Plus, Toad, Reports 10g, Forms 10g, Discoverer, BI Publisher.

Confidential

Oracle Procure 2 Pay Analyst

Description:

Responsible for business application support for Google, Inc.

Responsibilities:

• Worked on the Accounts Payables Invoice interface in accounts payables.
• Gathered and mapped requirements to Google procurement custom environment functionality.
• Developed interface to have Add new line requisition line feature.
• Customized some of the reps info form. Added a tab canvas to the existing content canvas and added the fields to the tabs in the canvas.
• Customized an AR Credit Memo Approval Request Work Flow in Advanced Collections.
• Developed a new report in INV to get the Inventory on hand quantity details and the back flush details.
• Payment Solutions:
• Support and Development in Oracle Applications 11.5.10i AP,PO,HRMS Modules.
• CitiDirect,CFX ,Sungard,Wells Fargo Integrations.
• Taxations.
• 170 MarkView invoice Process Application Maintenance and upgrades,
• Oracle Integrations,Invoice Workflows
• Bug Fixing ,Enhancements and Maintenance of Procure to Pay modules Oracle Applications 11.5.10i AP,PO,HRMS
• Expense Reporting Employee Credit Cards Known for Google as Gcard :
• Gcard Auto Payment Location specific changes, get individual payments thru file processing,Email automation and Dunning notifications, handling individual payments.
  • Concur Expense Handling Application Maintenance and Upgradations.
• Procurement Operations:
• Complete evaluation of requisition approval workflow for improvements.
• Spend Authority Exceptions and Changes.
• Work with business Users on determining and working on strategic direction and initiatives.
• Filing summary for schedule Hold report.
• Transaction History by Fund Report
• Schedule of assets held for investment report.
• oStatement of Changes to Net Assets summary by investment class.
• Participant Detail Report.
• Statement of Changes to Net Assets.
• Developed and customized reports using oracle reports, Discoverer and XML publisher like.
• Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs.
• Customized the existing Auto lockbox interface in Accounts Receivables.
• Customized various transactions in Accounts Receivables like Invoices, Receipts, and Credit Memos and Debit Memos etc.
• Creation of SQL Loader control programs and PL/SQL validation procedures to execute along with customer interface and vendor programs to support the interface requirements.
• Developed a GL interface module using SQL LOADER for data loading. For preprocessing of data used PL/SQL and for integration with Oracle Applications developed UNIX shell scripts to import Journal entries from external source.
• Creation of SQL Loader control programs and PL/SQL validation procedures to execute along with customer interface and vendor programs to support the interface requirements.
• Customized check printing report in AP as per the specific requirements
• Developed Backlog Report, This is a custom report basically finds all the orders lines which are not full filled. Order lines that are not shipped. I have developed a procedure which picks up all backlog lines into a temp table and prints on a report.
• Worked in creating menus, functions, sub functions, defining responsibilities and Segregation of Duties.
• Worked on Error Handling System in storing all the errors that occur during interfacing and loading.
• Created the database schema objects like tables, views, synonyms, indexes, procedures, functions.
• Generated ad-hoc queries to analyze underlying data for inconsistencies and integrity issues to find data issues.
• Support, Enhancements and Bug Fixing on Oracle Application 11.5.10.2 Financial Modules
• for Cummins India Ltd,Pune,Cummins Financials Services
• Customizations, Performance Tuning of Custom Programs, Interfaces using RICE Methodologies.
• Work with Business Analyst in translating business requirements into Functional,Tehcnical Requirements Document and to Detailed Design Documents.
• Present and defend product designs and architecture to clients.
• Develop the programs as per the Technical Design Documents. Ensure that development is performed as per requirements
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product .Communicate activities/progress to project managers, business development, business analysts and clients
• Develop implementation and test plans, build software acceptance criteria, coordinate and work with clients to oversee the acceptance and dissemination process .

Environment: Oracle Applications EBS 11.5.10.2 , Sys Admin, AOL, GL, AR, AP, PO, HRMS, Advanced Benefits and Payroll, Oracle 10g PL/SQL, SQL Plus, Toad, Reports 10g, Forms 10g, Discoverer, BI Publisher. Advance Pl/sql, Pl/sql, Sql, Forms6i, Reports 6i, Unix, Shell Scripting, Performance Tuning, Oracle Discoverer, XML, Java script.

Confidential

Oracle Application Developer

Description:

• Lead the Design/Development and Deployment of Items, On-Hand Quantities, Inventory Transactions, Price Lists, Modifiers, Qualifiers, Sales Orders, PCARD Interface, GL Extract Interface, Lockbox, Positive pay and Check Printing programs.
• Worked on Creating Data Source, Users, Roles, and Assigning Roles to Users, developing BI publisher reports in OBIEE.
• Developed two custom OAF Pages by creating Entity Objects, View Objects and Controllers and registered them in Oracle Applications.
• Lead the development team and consultant's teams globally.
• User training and production support of Oracle Applications 11i/ R12 Procure to Pay, Order to Cash, Demand to Distribution, Budget to Report, Project Accounting, Costing, calendar/financial period change and Self Serviced Applications such as iProcurement, suppliers, iReceipts, iPayments, iExpenses, iStore, Quality, Inventory, Bills of Materials, Purchases, Order Management, Advanced Pricing, APS, Workflow, Self Service Web Applications, Cost Management, Engineering, Planning Products, ADF, WEB ADI, Work In Process, Advanced Supply Chain and Planning, DEMANTRA, and HRMS .
• Involved in the Customization of Pricing Attributes for Advanced Pricing and FA Account Generator Workflow . Involved and reviewing the MD50's and MD70's for designing and developing Interfaces, conversions and reports for the Phase II
• Developed internal Service Request system by customizing Oracle Forms, alerts and reports
• Utilized AIM METHODOLOGY and created MD50, MD70 and CV40 documents for supporting applications
• Generating the Code Combinations using Account Generator and Workflow
• Developed PL/SQL program for Loading the Data from the file into Oracle Custom tables using UTL File utility
• Developed PL/SQL program for Processing the Data for customer and vendor validations and insert into AP AR interface tables
• Worked on Auto Invoice, Auto Lockbox, and Customer Interfaces in AR module
• Customized the Variances reports for executive business requirement
• Customized the Depreciation Reports for Fixed Assets
• Customized the ACH and Positive pay process for sending to Bank
• Designed and developed the Sales Forecast, Raw Material Forecast and Planned Order demand reports by using the Supply Chain and Order to Cash Applications
• Customized the AR Lockbox process.
• Designed and developed the Custom Check printing process
• Designed and developed the Service Request system internally to maintain all the bugs/enhancement requests.
• Designed and developed the Procurement Card Transactions process.
• Designed and developed Global Inventory Details by Account reports.
• Personalized and customized various forms Shipping and HRMS, zoom functionality, etc,.. based on the business requirement
• Designed and developed Pick Slip and Packing Slip reports to include the Barcodes and additional business requirements.
• Designed and developed the interfaces to send the data into Content Management System CMS
• Designed and developed the WIP inbound and outbound process to load the data from the shop floor to Oracle directly and sends the details back to shop floor system.
• Customized Standard Oracle Un-Received Shipments using reports 6i to include the new required functionality.
• Involved in Unit Testing.
• Imported Customer Information by using Customer Interface in Receivables. Worked on Auto Invoice to import Invoices, Debit Memos and Credit memos
• Created SQL Loader script to load data into temp tables from AS/400 data files and build program to validate the data for business rules and load the data to Auto invoice interface tables
• Created programs to validate the data received from banks and developed program to create lock box interface lines and header records to lockbox interface tables.
• Performed system administration functions such as Creation of Users, Creation of Responsibilities and Set up user profiles specific to applications
• Designed and developed ADP inbound and outbound interfaces for HR, Benefits, OTL and Payroll requirements.
• Working with global users to gather the requirements.
• Involved in user meetings for Gap Analysis
• Coding the Custom Packages, Procedures and Functions for Custom Reports for all the various modules using PL/SQL programs.

Confidential

Associate Consultant

• Handled Multiple roles and responsibilities Lead, Developer and Performance Changes in the Consumer Lending Flexcube programs.
• Java Upgrade of Flexcube to Flexcube Java for Consumer Lending Module.
• Flexcube FCJ Benchmarking and Performance Tuning of the Application.
• Flexcube Archival and Purging Business Logic Development
• Benchmarking of various Module Contracts for Client Brazil-AMB.
• Identifying the Various Unit areas for Performance Tuning.
• Creating the Virtual Users and taking the Readings using JMETER.Metadata Collection for all the modules given as a requirement.
• Site Implementation support of Archival and Purging Tool for UBS-LONDON.
• FLEXCUBE FCJ10.0 Release Migration and Conversion Tool Development from older Systems.
• Post Implementation support of Flexcube in Western Europe.

Environment: Oracle 9i, SQL, PL/SQL,JavaScript, Win 2000/XP, TOAD 7.5, SQL, PL/SQL,JSP,Javascript,Forms6i, JDeveloper,MSXML4.0 XSL, SOA.

Confidential

Description:

• Creating responsibilities and assigning them to a particular application.
• Customizing and developing the PSP's for each and every client specification.
• Developing packaged functions and procedures, triggers, indexes etc.,
• Developing the PSP's PL/SQL server Pages by embedding the JavaScript in PL/SQl code,
• ScheduleXpert Product Development
• Continued support for production issues as third level production support specialist. Supported user community in defining Service Level Agreements SLA
• Provided technical and investigative support for functional users on interfaces, defects, change requests, debugging issues, testing, service pack upgrades and adhoc report requirements
• Designed and setup Oracle batch jobs across entities.
• Unit Testing on AP,AR setups designed by Functional Consultants.
• Creating responsibilities and assigning them to a particular application Sys Admin .
• Customized and developed Oracle Reports and Forms in AP,AR and PO Module.
• Designed and developed interfaces to legacy systems
• Implemented several change requests to customize functionality in Oracle 11i Finance, Manufacturing and Order Management packages, in full conformance with RICE processes and documentation standards.
• Sarvotham TMT
• Creating responsibilities and assigning them to a particular application.
• Creating the tables, sequences, views, triggers and other data objects required.
• Developing the forms and reports using forms9i and reports9i.
• Key project implementations as team member
• Oracle Certified Professional in Oracle 9i
• As a fresh Graduate Got assigned to work on Oracle associated Projects and as a beginning.
• Trained as Oracle Application Developer in SQL STAR INTL
• ICDS-CARE Integrated Child Development Services .
• Involved in development, customization and data migration into Oracle Applications project.
• Involved in the creation of database and database activity, performance tuning.
• Utilized Application modules, e.g., PO, INV and PA. Involved in the customization of forms and reports using developer/2000 tools and loaded legacy data into Oracle applications modules.
• Familiar with registration of new programs in Oracle Applications as concurrent programs. Involved in data load using Interfaces to load legacy data into Oracle modules,Used SQL Loader and PL/SQL to load data into Apps production tables from flat file via temporary tables, Worked as a member of Oracle Applications ERP Data Migration Support Team, Responsible for registration of new programs in Oracle Applications as concurrent programs, Used UTL FILE packages, DBMS Packages and PL/SQL to develop batch programs.
• Developed Electronics File Transfer Payment programs to automate payment transfer.
• Wrote Shell scripts that were directly called from Oracle Applications, Conducted training on SQL, PL/SQL and Oracle Developer.
• Prepared design and deployment documentation provided deployment and data migration services and assisted with user training, Involved in registering the reports, screens and batch programs, unit testing, and verification with users.
• Environment:Oracle 9i, SQL, PL/SQL,JavaScript, Win 2000/XP, TOAD 7.5.,Oracle Financials, 11i,XML,jDeveloper,Forms 9i,Reports 9i ,Oracle r12