Profile
Overall ** Years of IT experience worked on various applications.
About 11 years of Techno-Functional expertise in Oracle Applications Development with extensive hands-on skills in Implementation and Enhancement projects of Oracle EBS 11i / R12 applications from end to end deployment and testing.
Sound knowledge of O2C and P2P cycles with data flows.
Proficiency in Financials (AP, AR & GL), Order Management (OM), Purchasing (PO) and Inventory (INV).
Expertise in Financial domain and laying out Blue prints for complex EBS solutions.
Over 4 years of experience in effectively managing remote and local development team and providing leadership and direction with effective interpersonal and team building skills.
Extensively worked on Interface/Conversion Programs to import data from various sources into Oracle Apps using PL/SQL, SQL*Loader, UTL file etc.
Extensive hands-on experience in Oracle PL/SQL – APIs, Packages, Procedures, Functions, Sequences and Collections.
Strong expertise in improving performance of the query and processes.
Hands-on experience on customization of Oracle Workflows as per client requirements
Strong expertise in Oracle Applications Framework (OAF) – building medium to complex pages from scratch and OAF customizations.
Expertise in Discoverer Report and XML Publisher Reports (BI Publisher) to build custom reports from scratch to provide solution as per business need.
Sound Knowledge in Oracle Forms to build and customize forms as per client requirement.
Sound Knowledge in Oracle Reports to build and customize reports as per business need.
Worked on Documentation using AIM methodology for Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), Conversion Test Plans (CV70), Testing Documents (TE020) and Release Document (MD120).
Worked on SVN, Kintana, JIRA, Mozart and WinCVS tool for versioning and migration.
Familiar with Agile Methodology to deliver story within Sprint.
Experience in interacting with client/business and building the business requirements. Proficient in analyzing and translating business requirements to technical requirements and architecture the solution.
Strong ability to collaborate and coordinate among all levels of organization in both business and IT with excellent results under tight deadlines.
Excellent in team collaboration, quick adaption and problem solving with good communication and interpersonal skills.
Proven ability to lead and manage multiple end-to-end project implementations.
Worked as lead solution architect across multiple projects.
Technology Skills
ERP Suite
Oracle Applications Release 11i, R12 with proficiency in Oracle Financial with Knowledge in SCM (OM and Inventory modules).
Modules
Oracle Applications Financials (AR, AP and GL), PO, iProcurement. iExpense and Supply Chain Management (SCM) with OM, Inventory (INV) with some exposure to BOM.
Languages
SQL, PL/SQL, XML Publisher, Unix Shell Scripting, Java
Databases
Oracle Database 9i/10G/11G
Application Tools/Technologies
Oracle Applications Framework (OAF), Forms 6i/10g, Reports 6i/10g, Oracle BI Publisher, Discoverer 9i/10g, Oracle Work Flow Builder, SQL* Plus, TOAD, SQL Developer and SOA
Operating System
Windows NT 4.0/95/98/2000/2003/2007, Unix
Professional Qualification
Masters in Computer Applications (MCA) from University of Rajasthan, India
2002 - 2006
Post-Graduation Diploma in Banking and Finance (PGDBF)
from Symbiosis Distance Learning Centre, Pune, India
2017
Employment Scan
Organization
From
To
Designation
IBM
Feb 2015
Till date
Senior System Analyst
Sunera Technologies
Jan 2014
Feb 2015
Associate Manager
Computer Science Corporation
May 2011
Jan 2014
Senior Software Engineer
Capgemini
May 2010
May 2011
Consultant (P3)
Oracle
May 2007
May 2010
Associate Consultant
NetSoft Computers
Jan 2006
May 2007
Software Developer
Key Projects
Organisation:
IBM, Doral, FL (From Feb-2017 to Till Now)
IBM, Pune, India (From Feb-2015 to Feb-2017)
Project Description:
Client – World Fuel Services, USA
Duration – Feb 2015 – Till Date
Environment – Oracle Apps 11.0.3 (Financial, OM, PO and INV)
Job Title – Development Lead
Project Type – Enhancement and Implementation
Brief Description of the Project:
This is enhancement project in financial domain to implement changes in the existing system for improvement of business processes.
Modules
Account Payables (AP), Account Receivables (AR), Purchasing (PO), Order Management (OM), Inventory (INV)
Tools & Utilities
Forms 6i, Reports 6i, Oracle BI Publisher, Oracle Applications Framework (OAF),SQL Developer, WinCVS, JIRA and Mozart
Responsibility
Analyse enhancement request of Invoicing (AR and AP) and Matching Application from business and provide technical solution.
Analyse impact of new enhancement on the other application and provide regression testing plans to make sure no breakdown in existing functionality.
Prepare build using PL/SQL, Oracle Reports, Forms and XML publisher as per technical solution.
Worked with offshore team to find any issues for deliverables and guide them to fix it.
Improve performance of slow process by tuning SQL queries.
Optimization and Performance tuning of the developed codes.
Involve in Code Review, Testing, and Effort estimation for the enhancement requests.
Mentor and monitor offshore team.
Worked with Oracle on SR.
Modified the custom form to handle the Auto Carrier Pay functionality.
Prepare Test document and migration of the code using WinCVS, Mozart and JIRA.
Worked with team member of the project to achieve common goal.
Involved in the Post Production support of the Edicom and Qantas Billing projects.
Projects
1) Edicom Mexico Invoicing and Payments
Performed setups in AR for Mexico Invoicing.
Prepared high level detail design document for Invoicing and Payments flow.
Worked with Mexico and Edicom team for the testing of Mexico Invoicing and Payments to make sure flow is working without any issues.
Collaborate with SOA team to send Invoice and Payments to Edicom for Certification.
Build custom API’s to get Mexico Invoicing data from Oracle and pass it to SOA using PL/SQL Collections.
2) Qantas Billing
Performed setups in AR for Qantas Invoicing.
Prepared high level detail design document for Qantas Invoicing.
Worked with Qantas team for the testing of Invoicing to make sure flow is working without any issues.
Collaborate with SOA team to send Qantas Invoice.
Build custom API’s to get Qantas Invoicing data from Oracle and pass it to SOA using PL/SQL Collections.
Key Objects
ANZ Card Processing– Implemented Card processing for Aviation segment for Compaq Customer.
Matching Workbench PO Flow – PO flow needs to incorporate in the matching workbench application to record supplier invoices against blanket PO.
Auto Carrier Pay – This is to auto pay carrier by supplier site if it’s setup for Auto pay.
Organisation:
Sunera Technologies, Hyderabad, India
Project Description:
Client – World Fuel Services, USA
Duration – Jan 2014 – Feb-2015
Environment – Oracle Apps 11.0.3 (Financial, OM, PO and INV)
Job Title – Associate Manager
Project Type – Enhancement
Brief Description of the Project:
This is enhancement project in financial domain to implement changes in the existing system for improvement of business processes.
Modules
Account Payables (AP), Account Receivables (AR), Purchasing (PO), Order Management (OM), Inventory (INV)
Tools & Utilities
Reports 6i, Oracle BI Publisher, SQL* Plus, SQL Developer, WinCVS, JIRA and Mozart
Responsibility
Analyse enhancement request of Invoicing (AR and AP) and Matching Application from business and provide technical solution.
Analyse impact of new enhancement on the other application and provide regression testing plans to make sure no breakdown in existing functionality.
Prepare build using PL/SQL, Oracle Reports, Forms and XML publisher as per technical solution.
Mentor the team members.
Prepare Test document and migration of the code using WinCVS, Mozart and JIRA.
Key Objects
Vigo-Spain Invoice– New Legal Entity in Vigo – Spain called “WF Lubricants S.L.” has been created in the Land Operating unit and AR Invoices format changed for this Legal Entity.
Credit and Rebill – Customize process for Credit and Rebill in Land Operating Units.
Reverse Charge Setup for Slovakian Customer - Reverse Charge for the Slovakian Customer added for Aviation Segment.
Rematching for Splits - One AP line should be able to match to multiple AR lines. The business would also like to be able to retrieve the references/links associated to the AP and AR. The new functionality should also update the accrual table.
Organisation:
Computer Science Corporation, Hyderabad, India
Project Description:
Client – Omnicare, USA
Duration – Dec 2011 – Jan 2014
Environment – Oracle Apps R12.1.3
Job Title – Techno Functional Consultant
Project Type – Implementation
Brief Description of the Project:
This project was implementation project of AR operations of Omnicare.
Modules
Account Receivables (AR) and General Ledger (GL)
Tools & Utilities
PL/SQL, Oracle Applications Framework (OAF), Reports 6i, Oracle BI Publisher, TOAD
Responsibility
Worked in the full implementation cycle and post implementation support.
To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
Involved in developing technical design document ( MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.
Extensively worked on Oracle Applications Framework (OAF) to build third party cash application from scratch. This application had four new OAF pages for Tie-Out Summary, Details and Batches to review, validate and process payments from third party.
Mentor the team members.
Key Objects
CCE001 Third Party Cash Application – Third party payers send payment information in Electronic Remittance Advices (835) to Omnicare. Omnicare converts multiple 835 files from different payer into a standard CRFF format. CRFF file is interfaced to Oracle for cash application for third party payer. As Oracle doesn’t have the ability to apply cash payments to invoices based on custom attributes like TCN, Rx #, RAF, NABP and Amount Paid, there is a need for developing a custom object.
FIN-E012 Unbilled Charges to Omniview– This program is designed to collect unbilled charges for Facilities, Facility+Patient, Facility+Nursing Stations and House Stock. Unbilled charges are any transactions in OCEAN for a Facility.For a Facility that has not been consolidated and presented to the Customer for payment.
FINI001 AR Customer outbound from Oracle to Sunguard – ARCUST would be used to extract oracle customer data and send it to sungaurd system. This outbound would include converted and non-converted customer.
FIN-E-001 Auto invoicing & auto accounting EXTENSION – The Extension for Auto Invoice and Auto Accounting is required because this extension allows to create AR Transactions at the time of interfacing eligible billable lines from Oracle Order Management to Accounts Receivable and consists of business rules and logic to derive appropriate Transaction Types, create proper accounting entries and enable accurate posting of GL entries based on Omnicare’s specific requirements for Revenue Management of its LTC Pharmacy sales transactions. It also enables assigning the correct legal entity values to the Ar Transactions whether Invoices, Debit Memos or Credit Memos.
FIN-E003 AR Rebilling Extension Credit Application– The Extension to Apply Credits against Open Facility and Patient Charges within a Billing Period is thus required to meet bill presentment requirements to Facility and Patient Customers through the customer portal and/or through third party agencies (such as Endeon for Private Patients); and to ensure that any charges that are not liable to be paid by the customer due to credits issued arising out of re-billing activity are not presented in their consolidated bills/statement of charges.
Organisation:
Computer Science Corporation, Hyderabad, India
Project Description:
Client – Centric Group, USA
Duration – Jun 2011 – Nov 2011
Environment – Oracle Apps R12.1.3
Job Title – Techno Functional Consultant
Project Type – Enhancement
Brief Description of the Project:
This project was enhancement projects of AR and OM operations of Centric Group.
Modules
Account Receivables (AR) and Order Management (OM)
Tools & Utilities
Oracle Apps 12i, XML Report, SQL Developer, Oracle Report 10g
Responsibility
Worked in the full implementation cycle and post implementation support.
To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
Involved in developing technical design document ( MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.
Involved in design and development of Oracle Report, XML Publisher and PL/SQL.
Key Objects
OMR2381 Buying Group Report-Internal Use – This report allows Courtesy Products to standardize the format for the sales tracking reports for Buy Efficient, Gus Vending, American Hotel Register, Wasserstrom, Interstate Hotels Corp., HMA, and Accor
FINR2139 Rebate Checks Report – This report is required because it will allow Courtesy to determine which customers should be receiving rebates for CV1 Brewers for the month as part of the CV1 In-Room Coffee System Volume Rebate Program and the information needed to manually calculate that rebate. This report will also be used to see what customers are currently on the program for accrual of rebate information.
OMR2925 Vendor Rebates – This is a report of sales for specific items to Avendra customers to be used in the calculation of vendor rebates. The report will list the sales of the specific items to Avendra customers on a period basis. This excel based report will allow the user to have a detailed and summary version of sales of the specific items to be used in the calculation of the vendor rebates. In Oracle every time it prints 2 reports based on parameters passed House Hold Essentials (Note: New name Whitney Design ) and China International.
MFGC168 BOM conversion - The MFGC168 BOM conversion is required because there are too many BOM records in ALICE to be converted manually.
Organisation:
Capgemini India Pvt Ltd
Project Description:
Client – AT&T, USA
Duration – May 2010 – May 2011
Environment – Oracle Apps R12
Job Title – Developer
Project Type –Enhancement
Brief Description of the Project:
This project was enhancement projects of PO, AP and INV operations of AT&T.
Modules
Project Accounting (PA), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), iExpense and iProcurement
Tools & Utilities
PL/SQL, Oracle Apps R12, Oracle 10g and OAF
Responsibility
Worked in the full implementation cycle and post implementation support.
To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
Involved in developing technical design document (TDD) for technical solutions using oracle AIM standard.
Involved in design and development of interfaces, customized standard workflow and OAF task.
Key Objects
Manual Hold on EDI Invoices
Applying manual hold on the EDI invoices if invoice lines have the fractional quantity.
Extract PO from Oracle to Data2Logictics
This object would extract the po information from the oracle and send it to Data2Logictics server using sftp connection.
Item Exclusion from iProcurement Category
The iProcurement browsing for items process should exclude certain items from a mapped Oracle iProcurement categories based on the exclusions defined by the administrator.
Organisation:
Oracle India Pvt Ltd
Project Description:
Client – VMware, USA
Duration – Dec 2008 – Apr 2010
Environment – Oracle Apps 11i
Job Title – Associate Consultant
Project Type –Enhancement
Brief Description of the Project:
This project was enhancement of Payable operations.
Modules
Accounts Payable (AP), General Ledger (GL) and Purchasing (PO)
Tools & Utilities
PL/SQL, Oracle Apps 11i, Oracle 9i, Workflow and Discoverer Report
Responsibility
Worked in the full implementation cycle and post implementation support.
To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
Involved in developing technical design document (TDD) for technical solutions using oracle AIM standard.
To develop SQL scripts to create staging tables and developing SQL*Loader control files to load the legacy data into the staging tables. Perform data validations and mappings at staging table level. Wrote PL/SQL validation packages.
Involved in design and development of interfaces, Discovere Report and customized standard workflow according to project need.
Creating PPM Package for object migration.
Key Objects
Journal Line Sequencing Interface
Create a unique line number sequence for manual and generated journal entries in the Italian set of books.
TLC(Transacting Local Currency) Release
TLC changes applied on Revenvue Pending, Revenue Closed and Daily Receipt Recon Discoverer Report.
TouchLess PO Release
Automated the process of PO creation from a Purchase Requisition without the manual intervention of buyers, thereby, eliminating the necessity of the buyers going to the Auto-Create Screen in Oracle and creating the PO manually.
P-Card Invoice Integration with Project
This Integrate Project Accounting with Accounts payables for manual invoices.
Recurring Invoice Automation
This is about to generation of recurring invoices automatically and plug in the Approver Name in each of these invoices for approval.
Organisation:
Oracle India Pvt Ltd
Project Description:
Client – CVRD Inco, CANADA
Duration – Feb 2008 – Nov 2008
Environment – Oracle Apps 11i
Job Title – Associate Consultant
Project Type –Implementation
Brief Description of the Project:
This project was implemented to create multiple reports.
Modules
Accounts Payable (AP) and Accounts Receivable (AR)
Tools & Utilities
PL/SQL, Oracle Apps 11i and Oracle 9i
Responsibility
Worked in the full implementation cycle and post implementation support.
To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
Involved in developing technical design document ( MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.
Involved in design and development of Oracle Report using PL/SQL procedure.
Key Objects
AR TINO Transactions
The report displays matching sales transactions in TINO and ORACLE. The record for each transaction in both systems is compared and the difference in sales amount is calculated
AP Managers Cost Center
This report is intended for each manager to have information available to show him or her exactly what travel costs or transactions will be charged to their cost center for the respective month.
Organisation:
Oracle India Pvt Ltd
Project Description:
Client – Mitra (Internal Oracle Project)
Duration – May 2007 – Feb 2008
Environment – Oracle Apps 11i
Job Title – Associate Consultant
Project Type –Internal Project
Brief Description of the Project:
This project was implemented to create repository of most commonly used Conversions.
Modules
Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO),
Inventory (INV)
Tools & Utilities
PL/SQL, Oracle Apps 11i and Oracle 9i
Responsibility
Involved in developing technical design document (MD 70 ), Testing Documents ( TE020 ) and release documents ( MD120 ) for technical solutions using oracle AIM standard.
Involved in development of custom API’s for the Conversion.
Key Objects
AP Invoices Conversion
This conversion imports all open AP invoices from legacy system to Oracle Application of VeriFone Corporation.
Open Purchase Order Conversion
The Open Purchase Order Conversion is the process of bringing over open purchase order data from the legacy system (MARS/G) to Oracle Purchasing
Iron Mountain Customer Conversion
This Customer conversion allows you to insert and update customer information from the Iron Mountain legacy and billing systems into Oracle Applications.
The Maximo Item Conversion
This Conversion processes the mapping Maximo aviation items from the legacy system to Master Items in Oracle Inventory.
Inventory On hand Quantities Conversion
This conversion provides City Of Chattanooga (CoC) with a method to migrate their inventory balances from System (BIC, City Works, TMS, RTA and Access) to Oracle Inventory
Organisation:
NetSoft Computers, Mumbai
Project Description:
Client – RK Hotels
Duration – Jan 2006 – Apr 2007
Environment – ASP.Net with C#
Job Title – Software Developer
Project Type – Implementation
Brief Description of the Project:
This project was creating software to implement hotel processes.
Modules
Receivables, Expenses and Check In/Out operations
Tools & Utilities
ASP.Net with C# and SQL Server
Responsibility
Worked in the full implementation cycle from scratch.
To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
Involved in design and development of the project with ASP.Net with C# technology with SQL Server as backend.
Certification/Trainings/Chief Accomplishments
Oracle Certified Associate (OCA) Certification
Oracle Certified in Receivables module.
Oracle Certified in Payables module.
Client appreciation for Third Party Cash application in Omnicare project.
Got appreciation from VMware client as exceptional work for TouchLess PO task.
Member of QA/QC team in CSC. Awarded for the best reviewer of October 2012.
Attended Oracle AIA 11g R1 Foundation Pack Implementation Training
Attended Oracle SOA Training
Got 4th rank in University of Rajasthan in I Semester of MCA.