Summary:

 
• Nine years of       experience in Development,       Consulting, Implementation and Support of Various Oracle Financials       modules (AR/AP/FA/CM/LNS/GL).
 
• Proficient in SQL, PL/SQL and Performance Tuning

 
• Skilled in writing complex stored  procedures/functions/Database Triggers using Oracle PL/SQL

 
• Good Knowledge of Developer 2000 tools like Oracle Forms and Oracle Reports

 
• Proficient in Reporting tool Oracle Discoverer,  BI Publisher (formerly XML Publisher).
 
• In-depth Experience in using various Oracle       Application Object Library(AOL) features viz Key Flexfield and       Descriptive Flexfieldimplementation in the Forms and Reports,       Concurrent Processing, custom library, Folders and Oracle Alerts.
 
• Good Knowledge of Oracle Workflow

 
• Experienced in Oracle Applications Framework  -   9i.

 
• Functional Side - Involved in Core process  Analysis (AS-IS Study), Requirement gathering, TO-BE process Mapping, functional  gap analysis, custom application design, configuration, module setup, test  script generation, writing training guides, training end users andproduction  support of various financial modules.

 
• Good insight into the data model of Oracle  Financials modules like Oracle Receivables, Oracle Payables,Oracle  Loans, Oracle iSupplier, Oracle iExpenses, Oracle Assets, Cash Management and  Oracle General Ledger.

 
• Actively involved in the development of Oracle  Receivables (AR) product for 11.5.9, 11.5.10CU1 & 11.5.10CU2 point  release during my stint with Oracle  Corporation for 4 years (2002-2006).

 
• Knowledge of 11i Data  model of Trading Community Architecture, functionality of Advance  Collections and Global Accounting Engine modules.

 
• Well versed with both Order to Cash (O2C) and Procure to Pay (P2P) (Business flows and Accounting Entries  generated) in Oracle Applications.

 
• Expert in Oracle AOL concepts and their  application while developing any custom code which has to be integrated with  the base apps.

 
• Basic Knowledge of Data ware Housing techniques  (worked on ETL methodology), Facts, Dimensions tables and Reporting Repository  (DDS, MDS etc).

 
• Exposure to various business processes and applications  implementation methodologies (AIM).

 
• Sound knowledge and experience in working with  onsite and offshore model.

 
• Part of core team to ensure quality  adherence and process compliance.

 
• Involved in recruitment process, effort estimation,  Team Managementand preparing scope of work/project plan etc.

 
• Responsible for final code reviews of customizations  done in Finance area.

 
• Good communication skills and client handling  abilities.

 
• Capable of handling any Oracle Application's  module, if given.

Education:

Bachelor of Electronics  and Communications Engineering

Technical Skills:

Development  tools  : Developer 2000, Toad, SQL Navigator, SQL Loader, Data Loader, Oracle

    Workflow  Builder, Web ADI, Oracle JDeveloper 9i, Putty, SFTP etc

    Report  writers  : Oracle Reports, Oracle XML Publisher

    BI  reporting tools  : Oracle  Discoverer

    Databases   : Oracle  8/9i/10g

Functional Skills:

Good  Knowledge of Oracle Financials & Procurement modules like AP,  AR, GL, FA, CM, LNS, iSupplier, iExpenses, iProcurement, PO, EIB

  Excellent  knowledge of Data model of above Financial Modules.

Professional Experience:

Client:Confidential,Aug2009  -  Present

    Role:Oracle Applications Team Lead

Description:  As a part of ERP team in Cricket, my role involves  gathering business requirement from Client/Functional Consultant/ERP Manager  and coming up with the solution component. This involves the solution design, development,  unit testing and coordinating with DBA/SYADMIN teams to migrate the solution in  UAT/Prod Environments.

Responsibilities:

 
• Designed       and developed an End to End custom application (Non-PO Invoice Entry) and       integrated with standard iSupplier functionality. This Application enabled       iSupplier's to create Non-PO Invoices in the system and import into AP.       This overcomes oracle's limitation where-in the isuppliers can only create       PO based invoices using the standard oracle iSupplier Module. In this       project, I developed the database design, coded in OA Framework/PL-SQL and       wrote the custom programs to interface the data from Custom Applications after       the workflow approval into Oracle Payables using Oracle Payables Open       Interface.

 
• Data       Conversion of Fixed Assets from Existing FA Book into new Book, Tax Book.

 
• Completed       customization to insure that CATS application Data imported from XML       Gateway/iSupplier sources always have integral values of Quantity Invoiced(No       Such Restriction in Oracle Applications)

 
• Worked       on Alert project to create Invoice Holds notification alerts of various       types.

 
• Developed       key Oracle Discoverer Reports viz Invoice on Holds Report, AP Payment       Schedules Report, EIB Decimal Items Report etc.

 
• Developed       complex PL/SQL code to implement parallel processing (both in Oracle       Applications using FND concurrent processing API's and Oracle database       using dbms_jobs)

Client:Confidential, Dec2008  -  July2009

Role:Oracle Apps Technical Consultant

Description:  As a part of DFT Team (Development Frameworks  and Tools) in Cisco, my role involved the development of software solutions  across Cisco IT by establishing standards and best practices as well as  delivering concrete artifacts for IT developers including tools, re-usable  frameworks and development management systems for Technology Platforms with  focus on Productivity, Performance and Code Quality. We have created Mailing Framework,  Messaging Framework, Exception Framework and Logging Framework for various Oracle  Apps environments which are used by Apps Developer community within the Cisco.

Responsibilities:

 
• Involved       in the design, development and testing of mailing framework which is used       to send email with/without attachments using oracle applications utilities       and java.

 
• Exception,       Messaging and logging framework which are used by pl/sql developers across       Cisco IT for Raising Exceptions, Calling Oracle Applications Message       Dictionary and Log Debug/Error Messages for Oracle Applications       Environment.

 
• Played       the role of project lead and co-coordinated with the on-site/off-shore       team and built and trained ODC team to support these frameworks in future.

Client:Confidential, Jan2007  -  Oct2008

Role:Techno-Functional Consultant

Description: REC is NBFC (Non Banking Financial Company) which  provides loan assistance to State Electricity Boards/State Power Utilities for  investments in electrification schemes. RECL is implementing Oracle 11i for managing  their business as well as other internal operations. Oracle Projects is used to  first record every loan request as a project. Once the project is appraised and  approved, the loan is sanctioned and Oracle Loans module is used to monitor the  disbursement activities and repayment process.

Responsibilities:

 
• Module       Owner of Accounts Payables and Fixed Assets (AP & FA) modules.

 
• Participated       in AS-IS process study of all the finance modules.

 
• TO-BE       process mapping of Accounts Payables and Fixed Assets Modules.

 
• Complete       Set-up of AP and FA modules.

 
• CRP1       & CRP2 (Conference Room Pilot) Business cycle presentation to the       client.

 
• Imparted       Functional training to Core users for modules owned.

 
• Performed       unit testing of the system for AP/FA module for end users.

 
• Technical       Lead for Data Migration of Financial modules (Customers, Suppliers, Asset       Master, Loans, Sales Invoices, Purchase Invoices).

 
• Enhanced       existing Oracle Payables and Assets reports according to new business       requirements.

 
• Developed       the interface to integrate Oracle Projects with Oracle Loans.

 
• Technical       Lead for all the customization in Oracle Loans/Accounts Payables/Fixed       Assets Module.

Client: Confidential, Jan2006  -  Jan2007

Role:Oracle Applications Techno-Functional Consultant

Description: Colt was upgrading to 11.5.10 from 11.0.3. As a  part of the upgradation project, I was involved in the development and support  of custom FRICE components.

Responsibilities:

Data  Conversion

    Customer Data Cleansing Project: As a  part of this project (in 11.5.9 and 11.0.3) for customer profiles, some of the  critical data elements essential to the functions within ERP's Advance  Collections were rationalized. This required updating the two systems that  supported these fields (Order Handling & Provisioning and ERP1103) and changing  the default values for certain fields such as Profile Class, Collector Code,  Account Status and Risk Code. This was achieved by populating the staging  tables from Oracle as well as from Excel sheets using SQL Loader and then  profiling based on certain business rules.11i Instance (OH&P) was then  updated using a TCA API whereas the 11.0 database (ERP1103)

  was updated using the DB Link by calling an AR API.

Custom  Interface Development

    CMS Monthly Commissions Build Interface  Development: This program extracted data from 11.5.10 GL and  AR Customer tables and published that to CMS custom tables. The concurrent  program Got the matching customer and contract details for Billed Revenue by GL  Date between the given dates (months) from the oracle standard AR and GL tables  and published them into CMS Custom tables in Oracle 11.5.10.

Custom  Oracle Reports Development

 
• Duplicate  Payment Report: The  Invoice Audit report listed all duplicate payments for a certain supplier. The  requirement was to search for duplicate payments for a period and optionally  for an amount and supplier. The standard RDF report was customized to select  all unpaid invoices based on the parameters which are not selected for payment  and compare with all invoices (excluding cancelled Ones).
 
• AP  Invoice Register Report: The standard Invoice Register provides  information to review detailed information about Invoices.The supplier invoices  were scanned and images were stored in an image processing system called XTRAC.  Payables users then created AP Invoices based on the XTRAC Images. Image ID in AP Invoice as reference. The Image ID from XTRAC was used as a  reference and was captured in the ATTRIBUTE2 column of the AP Invoices header  table (e AP_INVOICES_ALL). The customization involved displaying the Image id  and removing the Invoice type column from standard report output.
 
• Standard  Customers Excluded from Dunning Report: The Standard Customers Excluded from dunning  report, based on the standard Oracle report called 'Customer Profiles Report' displayed  all active customer accounts and site level profiles having dunning flag set to  'No'.
 
• Transaction  Adjustment Report: The Transaction Adjustment Report, customized on  top of standard Oracle report called 'Adjustment Register' could be produced by  OU or cross all OU's/SOB's i.e. ability to restrict cross-org report to  specific users, by registering the same executable twice, with different  parameter values. It required some fields to be removed from the standard  report and displayed Output in semi-colon separated fashion.

Custom  Discoverer Reports Development

 
• Supplier  created after Invoice Date Report: The report highlighted potential supplier policy  breaches by listing invoice and supplier details where an invoice (Non  Cancelled) was booked with a supplier invoice date that is prior to the Oracle  supplier creation date. It prompted for invoice creation date range parameters.
 
• PO  Value Exceeds PR Value Report: This Report listed approval and PO/PR details for  all Approved non-inventory POs whose value exceeded the approved PR value. The  report was required to check that purchasing department was not changing PO  values against approved PRs without due business approval. This also picked up  cases of PO's without PR's.
 
• Requisition  Self Approval Report : This Report listed all requisitions that were  raised and approved by the same person within a given date range. The report  checked if either the Preparer OR Requester is also the only approver (self  approval). It prompted for creation date range parameter along with parameters  related to requester, country and business unit.
 
• PO  Date after Invoice Date Report: This report reported potential policy breaches by  showing where a supplier has recorded a commitment (invoice date or invoice  creation date) prior to PO being issued or approved and where a PO had only  been raised upon receipt of an invoice (retrospectively raised PO). The report  displayed the Requisitions which were raised and approved after the supplier  invoice date or invoice creation date.
 
• PO  Approval Report: This Purchasing Report showed details of  autocreated, non inventory PO's andapproval action history (including  people the PO was sent to who did not approve it) for Purchase Orders approved  in a given date range.
 
• Supplier  Details Listing Report : The report showed key Supplier Header and  Supplier Sites records to check the validity of supplier data and control  settings. The report could display either Site or Header information on the  basis of report parameter.It could show three columns summarizing the  number of invoices, purchase orders and the amount paid against the supplier  site.
 
• Invoice  On Hold Report: This was an amendment to the standard 'Invoice on  Hold' report in 11i to include additional information from PO (Requestor Name,  Approver name and PO number) to allow the Accounts Payables to efficiently  resolve holds.

Confidential, June2002  -  Jan2006

    Role:  Senior  Applications Engineer  -  Accounts Receivables Product Development Team

Description: I had been a part of Oracle Receivables  development team for 4years, developing new features for the  product as well as providing business solutions to any inherent gaps within the  product reported by existing clients. As a developer, I was involved in coding  some of the complex transactions, receipt workbenches & customer module in  Oracle Receivables.

Major Projects undertaken  at Confidential

 
• Receivables  API's: I was solely responsible for developing &  maintaining the various API's provided by AR (Invoice API, Adjustment API, Deposit  API, Receipts API).

 
• Data  Task force: - As a part of the Data Task force , my job involved analyzing various data issues  being faced by the customers, and rectifying the faulty piece of code. This is  very critical for Oracle from customer satisfaction point of code as corrupt  data is one of the worst bottlenecks, which can lead to lot of delays for the  end user and are severity 1 issues in most cases. I was engaged in creating  generic data fix scripts for all the known causes of data corruption as well as  creating the necessary patches to make sure customer's don't end up with more  "bad" data.

 
• Enhancements  in Transactions/Receipts workbench : Worked on various enhancements and maintenance in the Core AR module for Global customer base.  This includes Complete Re-architecture (UI make over) of Transactions and  Receipt form for 11.5.10.

 
• Business  Views Upgrade: - Business  views are layer of entity descriptions for use in ad-hoc queries against Oracle  Applications data using analytical tools like Discoverer. Financial  intelligence delivers business views pertaining to AP, AR, GL, FA, CE and AX. My  role was to upgrade AR Business Views to the new R12 data model. Apart from  changes in Business Views changes were also done to Discoverer folders based on  these business views.

Roles &  Responsibilities Handled

• Worked on over 500 Bugs       and Enhancements in Accounts Receivables Module While working in AR       Development team in Oracle. Was involved in various enhancements in       Receipts and Transactions workbench of Oracle Accounts Receivables (AR)       module.

 
• Expertise       in Query and Performance tuning in Oracle.       Hands-on experience in analyzing the Oracle SQL Raw Trace and TKPROF'd       trace files in working query and database performance issues.

 
• Experienced in Inbound and Outbound       Interfaces.

 
• Knowledgeable in Data Conversions.

 
• Familiar with Oracle Workflows viz PO Approval       workflow, Requisition Approval workflow and AR Credit Memo Workflow.

 
• Skilled in preparing and delivering       presentations to both technical and executive positions.

 
• Excellent track record in demonstrating strong       analytical and problem solving skills.

 
• Good understanding of Software development       process, from initial planning through deployment.

 
• Responsible in technical training for other       team members. Coordinated in various changes, enhancements to other team       members.

 
• Involved in the recruitment process of new       members in team.

 
• Responsible for internal code reviews across       the team for all the builds.